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','Paramétrage Nouveau Note De Frais');
$viewer->assign('LANGUAGE_STRINGS', Vtiger_Language_Handler::export('Home', 'jsLanguageStrings'));
$viewer->view('CustomDashboard.tpl');
function getAllUsers(){
global $adb;
$query5 = "SELECT id,CONCAT(first_name,' ', last_name) as fullname FROM `vtiger_users` where status ='Active' ";
$result5 =$adb->query($query5);
$users=array();
while ($recordinfo = $adb->fetch_array($result5)) {
$users[] = $recordinfo;
}
return $users;
}
function getValidateur(){
global $adb;
$query5 = "SELECT * FROM note_de_frais_parametres ";
$result5 =$adb->query($query5);
$res=array();
while ($recordinfo = $adb->fetch_array($result5)) {
$res[] = $recordinfo;
}
return $res[0];
}
function getParametres(){
global $adb;
$query5 = "SELECT * FROM note_de_frais_parametres";
$result5 =$adb->query($query5);
$parametres=array();
while ($recordinfo = $adb->fetch_array($result5)) {
$parametres[] = $recordinfo;
}
return $parametres[0];
}
$currentDate = new DateTime();
$year_current = $currentDate->format("Y");
$month_current = $currentDate->format("n");
$months = array("JANVIER" => '01', "FEVRIER" => '02', "MARS" => '03', "AVRIL" => '04', "MAI" => '05',
"JUIN"=> '06',"JUILLET"=> '07', "AOUT"=> '08', "SEPTEMBRE"=> '09', "OCTOBRE"=> '10', "NOVEMBRE"=> '11', "DECEMBRE"=> '12');
//$months = array("JANVIER", "FEVRIER", "MARS", "AVRIL", "MAI", "JUIN", "JUILLET", "AOUT", "SEPTEMBRE", "OCTOBRE", "NOVEMBRE", "DECEMBRE");
$parametres = getParametres();
$validateur = getValidateur();
echo'
';
$viewer->view('CustomDashboardFooter.tpl');
?>