set('activity_view', 'Today'); $current_user->set('submenuhide', true); $current_user->set('leftpanelhide', true); $roleid = $current_user->get('roleid'); $viewer = new Vtiger_Viewer(); $viewer->assign('MODULE', 'Calendar'); $viewer->assign('VIEW', 'Calendar'); $viewer->assign('SELECTED_MENU_CATEGORY', 'SALES'); $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); $viewer->assign('CURRENT_USER', $current_user); $viewer->assign('SEARCHABLE_MODULES', Vtiger_Module_Model::getSearchableModules()); $viewer->assign('LANGUAGE_STRINGS', Vtiger_Language_Handler::export('Calendar', 'jsLanguageStrings')); $detailViewModel = Vtiger_Module_Model::getInstance('Calendar'); $linkParams = array('MODULE'=>'Calendar', 'ACTION'=>'Calendar'); $linkModels = $detailViewModel->getSideBarLinks($linkParams); $viewer->assign('QUICK_LINKS', $linkModels); $viewer->assign('PAGETITLE','MA TOURNEE'); //$viewer->assign('IS_CREATE_PERMITTED', isPermitted('Calendar', 'CreateView')); $viewer->view('CalendarViewPreProcess.tpl', 'Calendar'); global $adb; $query = "SELECT a.accountid, a.accountname, cf_986, cf_988 FROM vtiger_activity ac JOIN vtiger_crmentity e On e.crmid = ac.activityid JOIN vtiger_seactivityrel sea On sea.activityid = ac.activityid JOIN vtiger_account a On a.accountid = sea.crmid JOIN vtiger_accountscf acf ON acf.accountid = a.accountid WHERE date_start = '".date("Y-m-d")."' AND e.deleted = 0 AND e.smownerid = '".$current_user->get('id')."'"; $sql_get_result = $adb->query($query); $result = array(); while ($recordinfo = $adb->fetch_array($sql_get_result)) { $result[] = $recordinfo; } $result = array(["id" => '1', 'pramassages' => $result]); echo '
Démarrer
Arréter
'; $viewer->view('CalendarView.tpl', 'Calendar'); echo '
'; $viewer->view('CustomDashboardFooter.tpl'); ?>