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 b.fullname, a.month, a.total_bc as bc ,role, cf_992 as wilaya FROM ( SELECT us.id ,CONCAT(first_name,' ', last_name) as fullname ,EXTRACT(YEAR FROM so.duedate) as YEAR,EXTRACT(MONTH FROM so.duedate) as month, sum(subtotal) as total_bc, cf_992 FROM vtiger_users us JOIN vtiger_user2role usr ON usr.userid = us.id JOIN vtiger_role ro ON ro.roleid = usr.roleid JOIN vtiger_crmentity crm on crm.smownerid = us.id and crm.setype='SalesOrder' and crm.deleted <> 1 and ro.roleid in (SELECT roleid FROM `vtiger_role` WHERE `parentrole` like '%{$roleid}:%' or `parentrole` like '%{$roleid}') JOIN vtiger_salesorder so ON so.salesorderid = crm.crmid JOIN vtiger_accountscf acf ON acf.accountid = so.accountid"; /* Where EXTRACT(YEAR FROM so.duedate)=".$year; if($monthp == '') $query = $query." and EXTRACT(MONTH FROM so.duedate) = EXTRACT(MONTH FROM CURRENT_DATE()) "; else $query = $query." and EXTRACT(MONTH FROM so.duedate) = ".$monthp; $query = $query." GROUP by us.id ,month, cf_992"; */ $query = $query." WHERE so.duedate BETWEEN '".$datedeb."' and '".$datefin."'"; $query = $query." GROUP by us.id, cf_992"; $rolestr = "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}')"; if(isVP($roleid)) $rolestr = "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}'"; $query = $query.") a RIGHT JOIN (".$rolestr.") b ON a.id = b.id ORDER by fullname"; $sql_get_result = $adb->query($query); $result = array(); while ($recordinfo = $adb->fetch_array($sql_get_result)) { $result[] = $recordinfo; } $query = "SELECT * FROM vtiger_cf_992"; $sql_get_result = $adb->query($query); $wilayas = array(); while ($recordinfo = $adb->fetch_array($sql_get_result)) { $wilayas[] = $recordinfo; } echo getMonitoringMainBarVP(2).getDateSelect($datedeb,$datefin); echo '

Total des bons de commande / Wilaya

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