get('roleid');
$userId = $current_user->get('id');
$viewer = new Vtiger_Viewer();
$viewer->assign('CURRENTDATE', Vtiger_Date_UIType::getDisplayDateValue(date('Y-n-j')));
$viewer->assign('MODULE', 'Home');
$viewer->assign('MODULE_NAME', 'Home');
$viewer->assign('QUALIFIED_MODULE', 'Home');
$viewer->assign('PARENT_MODULE', '');
$viewer->assign('VIEW', 'DashBoard');
$menuModelsList = Vtiger_Menu_Model::getAll(true);
$menuStructure = Vtiger_MenuStructure_Model::getInstanceFromMenuList($menuModelsList, 'Home');
uksort($menuModelsList, array('Vtiger_MenuStructure_Model', 'sortMenuItemsByProcess'));
$viewer->assign('SELECTED_MENU_CATEGORY', 'MARKETING');
$viewer->assign('SELECTED_MENU_CATEGORY_LABEL', 'Tableau de bord');
//$viewer->assign('SELECTED_CATEGORY_MENU_LIST', $menuGroupedByParent['MARKETING']);
$viewer->assign('MENUS', $menuModelsList);
$viewer->assign('QUICK_CREATE_MODULES', Vtiger_Menu_Model::getAllForQuickCreate());
$viewer->assign('MENU_STRUCTURE', $menuStructure);
$viewer->assign('MENU_SELECTED_MODULENAME', 'Home');
$viewer->assign('MENU_TOPITEMS_LIMIT', $menuStructure->getLimit());
$viewer->assign('COMPANY_LOGO', Vtiger_CompanyDetails_Model::getInstanceById()->getLogo());
$viewer->assign('COMPANY_DETAILS_SETTINGS',new Settings_Vtiger_CompanyDetails_Model());
$viewer->assign('USER_MODEL', $current_user);
$viewer->assign('CURRENT_USER_MODEL', $current_user);
require_once 'libraries/csrf-magic/csrf-magic.php';
$viewer->assign('HOME_MODULE_MODEL', Vtiger_Module_Model::getInstance('Home'));
$viewer->assign('HEADER_LINKS', Vtiger_Header_View::getHeaderLinks());
$viewer->assign('ANNOUNCEMENT', Vtiger_Header_View::getAnnouncement());
$viewer->assign('SEARCHABLE_MODULES', Vtiger_Module_Model::getSearchableModules());
$viewer->assign('INVENTORY_MODULES', getInventoryModules());
$viewer->assign('PAGETITLE','Etat des Stocks');
$viewer->assign('LANGUAGE_STRINGS', Vtiger_Language_Handler::export('Home', 'jsLanguageStrings'));
$viewer->view('CustomDashboard.tpl');
if(isset($_GET['idEtatStock']) && isset($_GET['action']) ) {
if(!empty($_GET['idEtatStock']) && !empty($_GET['action'])) {
if(($roleid == 'H2' || $roleid == 'H4' || $roleid == 'H11') && $_GET['action'] == "delete"){
$query = "DELETE FROM etat_stock WHERE id = {$_GET['idEtatStock']}";
$adb->pquery($query);
$query = "DELETE FROM lignes_etat_stock WHERE id_etat_stock = {$_GET['idEtatStock']}";
$adb->pquery($query);
header("Location: index.php?module=EtatStockList&view=EtatStockList");
}
if(($roleid == 'H2' || $roleid == 'H12' || $roleid == 'H4' || $roleid == 'H11') && $_GET['action'] == "duplique"){
$query = "INSERT INTO etat_stock (grossiste, `date`, creator_id, date_creation, modified_by, date_modification)
SELECT grossiste, DATE_ADD(`date`, INTERVAL 30 DAY), creator_id, NOW(), modified_by, null FROM etat_stock
WHERE id = {$_GET['idEtatStock']}";
$adb->pquery($query);
$query = "SELECT MAX(id) FROM etat_stock";
$my_result = $adb->pquery($query);
$recordinfo = $adb->fetch_array($my_result);
$maxid = $recordinfo[0];
$query = "INSERT INTO lignes_etat_stock (id_etat_stock, produit, lot, dper, qte)
SELECT {$maxid}, produit, lot, null, 0 FROM lignes_etat_stock
WHERE id_etat_stock = {$_GET['idEtatStock']}";
$adb->pquery($query);
header("Location: index.php?module=EtatStockList&view=EtatStockList");
}
}
}
function result($res ,$roleid ){
echo '
|
';
if($roleid == 'H2' || $roleid == 'H4' || $roleid == 'H11'){
echo ' ';
echo ' ';
}
if($roleid == 'H12'){
echo ' ';
}
echo '
|
'.$res['grossiste'].' |
'.$res['date'].' |
'.getFullname($res['creator_id']).' |
';
}
function getGrossisteList( $userId , $roleid){
global $adb;
if($roleid == 'H2' || $roleid =='H32' || $roleid =='H10'){
$query = "SELECT * FROM `etat_stock`";
}else{
$query = "SELECT * FROM `etat_stock` where creator_id = {$userId}";
}
$sql_get_result = $adb->query($query);
$res= array();
while ($recordinfo = $adb->fetch_array($sql_get_result)) {
$res[] = $recordinfo;
}
return $res;
}
function getFullname($id){
global $adb;
$query = "SELECT first_name,last_name FROM `vtiger_users` where id ='".$id."' ";
$sql_get_result = $adb->query($query);
$res= array();
while ($recordinfo = $adb->fetch_array($sql_get_result)) {
$res[] = $recordinfo;
}
return $res[0]['first_name']." ".$res[0]['last_name'];
}
$res = getGrossisteList($userId , $roleid);
echo '';
$viewer->view('CustomDashboardFooter.tpl');
?>