get('id'); if(isTopDG($roleid)){$roleid="H10";} /* $monthp = ""; if(isset($_POST['month'])) { $monthp = $_POST['month']; $year = $_POST['year']; }*/ $datedeb = date("Y-m-d",strtotime("-1 month")); $datefin = date('Y-m-d'); if(isset($_POST['datedeb'])) { $datedeb = $_POST['datedeb']; $datefin = $_POST['datefin']; } global $adb; $query = "SELECT EXTRACT(year FROM so.duedate) as year , EXTRACT(MONTH FROM so.duedate) as month, p.productname, CONCAT(first_name,' ', last_name) as fullname , sum(ip.quantity) as totalquantity , sum(ip.margin) as totalmargin, us.id as uid, ro.rolename as role FROM `vtiger_salesorder` so JOIN vtiger_inventoryproductrel ip on so.`salesorderid` = ip.id JOIN vtiger_crmentity e on so.`salesorderid` = e.crmid and e.deleted = 0 JOIN vtiger_products p on p.productid = ip.productid JOIN vtiger_users us on us.id = e.smownerid and us.status <> 'Inactive' JOIN vtiger_user2role usr ON usr.userid = us.id JOIN vtiger_role ro ON ro.roleid = usr.roleid"; /* if($monthp == '') $query = $query." WHERE EXTRACT(MONTH FROM so.duedate) = EXTRACT(MONTH FROM CURRENT_DATE()) and EXTRACT(year FROM so.duedate)=".$year; else $query = $query." WHERE EXTRACT(MONTH FROM so.duedate) = ".$monthp." and EXTRACT(year FROM so.duedate)=".$year; */ $query = $query." WHERE so.duedate BETWEEN '".$datedeb."' and '".$datefin."'"; $query = $query." GROUP by uid, p.productname";//, month , year"; $sql_get_result = $adb->query($query); $result = array(); while ($recordinfo = $adb->fetch_array($sql_get_result)) { $result[] = $recordinfo; } $query = "SELECT id,CONCAT(first_name,' ', last_name) as fullname ,ro.rolename as role FROM vtiger_users US JOIN vtiger_user2role usr ON usr.userid = US.id JOIN vtiger_role ro ON ro.roleid = usr.roleid and US.status <> 'Inactive' and ro.roleid in (SELECT roleid FROM `vtiger_role` WHERE `parentrole` like '%{$roleid}:%' OR `parentrole` like '%{$roleid}' OR ro.roleid = '".$roleid."')"; if(isVP($roleid)) $query = "SELECT id,CONCAT(first_name,' ', last_name) as fullname ,ro.rolename as role FROM vtiger_users US JOIN vtiger_user2role usr ON usr.userid = US.id JOIN vtiger_role ro ON ro.roleid = usr.roleid and US.status <> 'Inactive' where US.id = '{$userId}'"; $sql_get_result = $adb->query($query); $users = array(); while ($recordinfo = $adb->fetch_array($sql_get_result)) { $users[] = $recordinfo; } $query = "SELECT * FROM `vtiger_products` p JOIN vtiger_crmentity e on p.productid = e.crmid and e.deleted = 0"; $sql_get_result = $adb->query($query); $products = array(); while ($recordinfo = $adb->fetch_array($sql_get_result)) { $products[] = $recordinfo; } echo getMonitoringMainBarVP(4).getDateSelect($datedeb,$datefin).getUniteType(); echo '

Réalisé par produit

Nom & Prénom

'.getRegionSelectSubmit($roleid,false).getRolesSelectVP().'

'; echo'

'; echo '

'; $viewer->view('CustomDashboardFooter.tpl'); ?>