public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$page = $request->get('page');
$linkId = $request->get('linkid');
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
if (!$request->has('owner')) {
$owner = Settings_WidgetsManagement_Module_Model::getDefaultUserId($widget);
} else {
$owner = $request->get('owner');
}
$pagingModel = new Vtiger_Paging_Model();
$pagingModel->set('page', $page);
$pagingModel->set('limit', (int) $widget->get('limit'));
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('PAGING', $pagingModel);
$viewer->assign('CURRENTUSER', $currentUser);
$title_max_length = vglobal('title_max_length');
$href_max_length = vglobal('href_max_length');
$viewer->assign('NAMELENGHT', $title_max_length);
$viewer->assign('HREFNAMELENGHT', $href_max_length);
$viewer->assign('NODATAMSGLABLE', 'LBL_NO_SCHEDULED_ACTIVITIES');
$currentUserModel = Users_Record_Model::getCurrentUserModel();
$viewer->assign('CURRENT_USER', $currentUserModel);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/CalendarContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/Calendar.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$number = $request->get('number');
$page = $request->get('page');
$linkId = $request->get('linkid');
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
$limit = (int) $widget->get('limit');
if (empty($limit)) {
$limit = 10;
}
if (empty($page)) {
$page = 1;
}
$pagingModel = new Vtiger_Paging_Model();
$pagingModel->set('page', $page);
$pagingModel->set('limit', $limit);
$columnList = array('LBL_NAME' => 'label', 'LBL_MODULE_NAME' => 'setype', 'Last Modified By' => 'modifiedtime', 'LBL_OWNER' => 'smownerid');
$recordList = ListUpdatedRecord::getListRecord(NULL, $columnList);
$viewer->assign('COLUMN_LIST', $columnList);
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('LIST', $recordList);
$viewer->assign('PAGE', $page);
$viewer->assign('NEXTPAGE', count($recordList) < $limit ? 0 : $page + 1);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/ListUpdatedRecordContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/ListUpdatedRecord.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$linkId = $request->get('linkid');
$owner = $request->get('owner');
$dates = $request->get('expectedclosedate');
//Date conversion from user to database format
if (!empty($dates)) {
$dates['start'] = Vtiger_Date_UIType::getDBInsertedValue($dates['start']);
$dates['end'] = Vtiger_Date_UIType::getDBInsertedValue($dates['end']);
}
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$data = $moduleModel->getPotentialsCountBySalesStage($owner, $dates);
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('DATA', $data);
//Include special script and css needed for this widget
$viewer->assign('SCRIPTS', $this->getHeaderScripts($request));
$viewer->assign('STYLES', $this->getHeaderCss($request));
$viewer->assign('CURRENTUSER', $currentUser);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/DashBoardWidgetContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/GroupBySalesStage.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$LIMIT = 10;
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$type = $request->get('type');
$page = $request->get('page');
$linkId = $request->get('linkid');
if (empty($page)) {
$page = 1;
}
$pagingModel = new Vtiger_Paging_Model();
$pagingModel->set('page', $page);
$pagingModel->set('limit', $LIMIT);
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$history = $moduleModel->getHistory($pagingModel, $type);
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
$modCommentsModel = Vtiger_Module_Model::getInstance('ModComments');
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('HISTORIES', $history);
$viewer->assign('PAGE', $page);
$viewer->assign('NEXTPAGE', count($history) < $LIMIT ? 0 : $page + 1);
$viewer->assign('COMMENTS_MODULE_MODEL', $modCommentsModel);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/HistoryContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/History.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$linkId = $request->get('linkid');
$user = $request->get('user');
$time = $request->get('time');
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
$data = $moduleModel->getWidgetTimeControl($user, $time);
$workDays = $moduleModel->getWorkingDays($time['start'], $time['end']);
$selectedDays = (strtotime($time['end']) - strtotime($time['start'])) / (60 * 60 * 24) + 1;
$viewer->assign('SELECTEDDAYS', $selectedDays);
$viewer->assign('WORKDAYS', $workDays);
$viewer->assign('AVERAGE', $data['average']);
$viewer->assign('COUNTDAYS', $data['countDays']);
$viewer->assign('USERID', $user);
$viewer->assign('DTIME', $time);
$viewer->assign('DATA', $data['data']);
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('CURRENTUSER', $currentUser);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/TimeControlContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/TimeControl.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$linkId = $request->get('linkid');
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$data = $moduleModel->getOpenTickets();
$listViewUrl = $moduleModel->getListViewUrl();
for ($i = 0; $i < count($data); $i++) {
$data[$i]["links"] = $listViewUrl . $this->getSearchParams($data[$i][name]);
}
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('DATA', $data);
//Include special script and css needed for this widget
$viewer->assign('CURRENTUSER', $currentUser);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/DashBoardWidgetContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/OpenTickets.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$linkId = $request->get('linkid');
$data = $request->get('data');
$createdTime = $request->get('createdtime');
//Date conversion from user to database format
if (!empty($createdTime)) {
$dates['start'] = Vtiger_Date_UIType::getDBInsertedValue($createdTime['start']);
$dates['end'] = Vtiger_Date_UIType::getDBInsertedValue($createdTime['end']);
}
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$data = $moduleModel->getCountriesByRating($request->get('owner'), $dates);
$listViewUrl = $moduleModel->getListViewUrl();
for ($i = 0; $i < count($data); $i++) {
$data[$i]["links"] = $listViewUrl . $this->getSearchParams($data[$i][2], $request->get('owner'), $dates);
}
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
//Include special script and css needed for this widget
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('DATA', $data);
$viewer->assign('CURRENTUSER', $currentUser);
$accessibleUsers = $currentUser->getAccessibleUsersForModule($moduleName);
$viewer->assign('ACCESSIBLE_USERS', $accessibleUsers);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/DashBoardWidgetContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/CountriesByRating.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$page = $request->get('page');
$linkId = $request->get('linkid');
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
if (!$request->has('owner')) {
$owner = Settings_WidgetsManagement_Module_Model::getDefaultUserId($widget);
} else {
$owner = $request->get('owner');
}
$pagingModel = new Vtiger_Paging_Model();
$pagingModel->set('page', $page);
$pagingModel->set('limit', (int) $widget->get('limit'));
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$projectsTasks = $owner === false ? array() : $moduleModel->getAssignedProjectsTasks('upcoming', $pagingModel, $owner);
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('PROJECTSTASKS', $projectsTasks);
$viewer->assign('PAGING', $pagingModel);
$viewer->assign('CURRENTUSER', $currentUser);
global $title_max_length, $href_max_length;
$viewer->assign('NAMELENGHT', $title_max_length);
$viewer->assign('HREFNAMELENGHT', $href_max_length);
$viewer->assign('NODATAMSGLABLE', 'LBL_NO_OVERDUE_ACTIVITIES');
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/AssignedProjectsTasksContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/AssignedProjectsTasks.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$linkId = $request->get('linkid');
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$data = $moduleModel->getPotentialTotalAmountBySalesStage();
$listViewUrl = $moduleModel->getListViewUrl();
for ($i = 0; $i < count($data); $i++) {
$data[$i]["links"] = $listViewUrl . $this->getSearchParams($data[$i][1]);
}
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('DATA', $data);
$viewer->assign('STYLES', $this->getHeaderCss($request));
$viewer->assign('CURRENTUSER', $currentUser);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/DashBoardWidgetContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/FunnelAmount.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$linkId = $request->get('linkid');
$owner = $request->get('owner');
$dates = $request->get('expectedclosedate');
//Date conversion from user to database format
if (!empty($dates)) {
$dates['start'] = Vtiger_Date_UIType::getDBInsertedValue($dates['start']);
$dates['end'] = Vtiger_Date_UIType::getDBInsertedValue($dates['end']);
}
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$data = $moduleModel->getCampaignsWidget($owner, $dates);
$listViewUrl = $moduleModel->getListViewUrl();
for ($i = 0; $i < count($data); $i++) {
$data[$i][] = $listViewUrl . $this->getSearchParams($data[$i][0], $owner, $dates);
}
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('DATA', $data);
//Include special script and css needed for this widget
$viewer->assign('STYLES', $this->getHeaderCss($request));
$viewer->assign('CURRENTUSER', $currentUser);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/CampaignsWidget.tpl', $moduleName);
} else {
$viewer->view('dashboards/CampaignsWidget.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$moduleName = $request->getModule();
$page = $request->get('page');
$linkId = $request->get('linkid');
$pagingModel = new Vtiger_Paging_Model();
$pagingModel->set('page', $page);
$pagingModel->set('limit', 10);
$user = $request->get('type');
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$overDueActivities = $moduleModel->getCalendarActivities('overdue', $pagingModel, $user);
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
$viewer = $this->getViewer($request);
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('ACTIVITIES', $overDueActivities);
$viewer->assign('PAGING', $pagingModel);
$viewer->assign('CURRENTUSER', $currentUser);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/CalendarActivitiesContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/CalendarActivities.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$linkId = $request->get('linkid');
$expectedclosedate = $request->get('expectedclosedate');
//Date conversion from user to database format
if (!empty($expectedclosedate)) {
$closingdates['start'] = Vtiger_Date_UIType::getDBInsertedValue($expectedclosedate['start']);
$closingdates['end'] = Vtiger_Date_UIType::getDBInsertedValue($expectedclosedate['end']);
}
$createdTime = $request->get('createdtime');
//Date conversion from user to database format
if (!empty($createdTime)) {
$dates['start'] = Vtiger_Date_UIType::getDBInsertedValue($createdTime['start']);
$dates['end'] = Vtiger_Date_UIType::getDBInsertedValue($createdTime['end']);
}
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$data = $moduleModel->getForecast($closingdates, $dates);
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
//Include special script and css needed for this widget
$viewer->assign('SCRIPTS', $this->getHeaderScripts($request));
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('DATA', $data);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/DashBoardWidgetContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/Forecast.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$linkId = $request->get('linkid');
$createdTime = $request->get('createdtime');
$owner = $request->get('owner');
//Date conversion from user to database format
if (!empty($createdTime)) {
$dates['start'] = Vtiger_Date_UIType::getDBInsertedValue($createdTime['start']);
$dates['end'] = Vtiger_Date_UIType::getDBInsertedValue($createdTime['end']);
}
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$data = $moduleModel->getLeadsCreated($owner, $dates);
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
//Include special script and css needed for this widget
$viewer->assign('SCRIPTS', $this->getHeaderScripts($request));
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('DATA', $data);
$viewer->assign('CURRENTUSER', $currentUser);
$accessibleUsers = $currentUser->getAccessibleUsersForModule('Leads');
$viewer->assign('ACCESSIBLE_USERS', $accessibleUsers);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/DashBoardWidgetContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/LeadsCreated.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$stateActivityLabels = Calendar_Module_Model::getComponentActivityStateLabel();
$page = $request->get('page');
$linkId = $request->get('linkid');
$sortOrder = $request->get('sortorder');
$orderBy = $request->get('orderby');
$params = ['status' => $stateActivityLabels['in_realization']];
if ($request->get('switchParams')) {
$params = ['status' => $request->get('switchParams')];
}
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
if (!$request->has('owner'))
$owner = Settings_WidgetsManagement_Module_Model::getDefaultUserId($widget);
else
$owner = $request->get('owner');
$pagingModel = new Vtiger_Paging_Model();
$pagingModel->set('page', $page);
$pagingModel->set('limit', (int) $widget->get('limit'));
$pagingModel->set('orderby', $orderBy);
$pagingModel->set('sortorder', $sortOrder);
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$calendarActivities = ($owner === false) ? array() : $moduleModel->getCalendarActivities('upcoming', $pagingModel, $owner, false, $params);
$switchLabels = [];
$switchLabels[] = ['label' => vtranslate($stateActivityLabels['in_realization'], 'Calendar'), 'name' => $stateActivityLabels['in_realization']];
$switchLabels[] = ['label' => vtranslate($stateActivityLabels['not_started'], 'Calendar'), 'name' => $stateActivityLabels['not_started']];
$msgLabel = 'LBL_NO_SCHEDULED_ACTIVITIES';
if ($params['status'] == $stateActivityLabels['in_realization']) {
$msgLabel = 'LBL_NO_CURRENT_ACTIVITIES';
}
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('ACTIVITIES', $calendarActivities);
$viewer->assign('PAGING', $pagingModel);
$viewer->assign('CURRENTUSER', $currentUser);
$title_max_length = vglobal('title_max_length');
$href_max_length = vglobal('href_max_length');
$viewer->assign('NAMELENGHT', $title_max_length);
$viewer->assign('OWNER', $owner);
$viewer->assign('HREFNAMELENGHT', $href_max_length);
$viewer->assign('NODATAMSGLABLE', $msgLabel);
$viewer->assign('SWITCH', $switchLabels);
$viewer->assign('LISTVIEWLINKS', true);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/CalendarActivitiesContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/CalendarActivities.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$linkId = $request->get('linkid');
$page = $request->get('page');
if (empty($page)) {
$page = 1;
}
$pagingModel = new Vtiger_Paging_Model();
$pagingModel->set('page', $page);
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$models = $moduleModel->getTopPotentials($pagingModel);
$moduleHeader = $moduleModel->getTopPotentialsHeader();
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('MODULE_HEADER', $moduleHeader);
$viewer->assign('MODELS', $models);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/TopPotentialsContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/TopPotentials.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$linkId = $request->get('linkid');
//var_dump($request->get('createdtime'));
$kpiHelper = new Vtiger_Kpi_Helper($request);
$data = $kpiHelper->getData($request);
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
$viewer->assign('KPILIST', $kpiHelper->getKpiList());
$viewer->assign('KPITYPES', $kpiHelper->getKpiTypes());
$viewer->assign('DTYPE', $request->get('type'));
$viewer->assign('DSERVICE', $request->get('service'));
$viewer->assign('DTIME', $request->get('time'));
//$viewer->assign('KPIHELPER', $kpiHelper);
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('DATA', $data);
//Include special script and css needed for this widget
$viewer->assign('CURRENTUSER', $currentUser);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/KpiContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/Kpi.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request) {
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$linkId = $request->get('linkid');
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$data = $moduleModel->getPotentialsCountBySalesPerson();
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('DATA', $data);
//Include special script and css needed for this widget
$viewer->assign('SCRIPTS',$this->getHeaderScripts($request));
$viewer->assign('STYLES',$this->getHeaderCss($request));
$viewer->assign('CURRENTUSER', $currentUser);
$content = $request->get('content');
if(!empty($content)) {
$viewer->view('dashboards/DashBoardWidgetContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/GroupBySalesPerson.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$loggedUserId = $currentUser->get('id');
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$linkId = $request->get('linkid');
$user = $request->get('user');
$time = $request->get('time');
if ($time == NULL) {
$time['start'] = date('Y-m-d', strtotime("-1 week"));
$time['end'] = date("Y-m-d");
} else {
// date parameters passed, convert them to YYYY-mm-dd
$time['start'] = Vtiger_Functions::currentUserDisplayDate($time['start']);
$time['end'] = Vtiger_Functions::currentUserDisplayDate($time['end']);
}
if ($user == NULL) {
$user = $loggedUserId;
}
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
$selectedTimeTypes = $request->get('timeTypes');
if ('' == $selectedTimeTypes) {
$selectedTimeTypes = 'all';
}
$data = $moduleModel->getWidgetTimeControl($user, $time, $selectedTimeTypes);
$listViewUrl = 'index.php?module=OSSTimeControl&view=List';
for ($i = 0; $i < count($data['data']['days']); $i++) {
$data['data'][$i]['links'] = $listViewUrl . $this->getSearchParams($user, $data['data']['days'][$i]);
}
$timeTypesPossibility = array('PLL_HOLIDAY_TIME' => 'holidayTime', 'PLL_BREAK_TIME' => 'breakTime', 'PLL_WORKING_TIME' => 'workTime');
$viewer->assign('SELECTEDTIMETYPES', $selectedTimeTypes);
$viewer->assign('TIMETYPEPOSSIBILITY', $timeTypesPossibility);
$viewer->assign('CHARTEXIST', $data['chartExist']);
$viewer->assign('TIMETYPESCOLORS', $data['colors']);
$viewer->assign('WORKDAYS', $workDays);
$viewer->assign('USERID', $user);
$viewer->assign('DTIME', $time);
$viewer->assign('DATA', $data['data']);
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('CURRENTUSER', $currentUser);
$viewer->assign('LOGGEDUSERID', $loggedUserId);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/TimeControlContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/TimeControl.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$moduleName = $request->getModule();
$page = $request->get('page');
$linkId = $request->get('linkid');
$sortOrder = $request->get('sortorder');
$orderBy = $request->get('orderby');
$data = $request->getAll();
$params = ['activitesType' => 'upcoming'];
if ($request->get('activitesType')) {
$params = ['activitesType' => $request->get('activitesType')];
} else {
$data['activitesType'] = 'upcoming';
$params = ['activitesType' => 'upcoming'];
}
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
if (!$request->has('owner')) {
$owner = Settings_WidgetsManagement_Module_Model::getDefaultUserId($widget);
} else {
$owner = $request->get('owner');
}
$pagingModel = new Vtiger_Paging_Model();
$pagingModel->set('page', $page);
$pagingModel->set('limit', (int) $widget->get('limit'));
$pagingModel->set('orderby', $orderBy);
$pagingModel->set('sortorder', $sortOrder);
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$overDueActivities = $owner === false ? array() : $moduleModel->getCalendarActivities('createdByMeButNotMine', $pagingModel, $owner, false, $params);
$viewer = $this->getViewer($request);
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('ACTIVITIES', $overDueActivities);
$viewer->assign('PAGING', $pagingModel);
$viewer->assign('CURRENTUSER', $currentUser);
$title_max_length = vglobal('title_max_length');
$href_max_length = vglobal('href_max_length');
$viewer->assign('NAMELENGHT', $title_max_length);
$viewer->assign('HREFNAMELENGHT', $href_max_length);
$viewer->assign('NODATAMSGLABLE', 'LBL_NO_RECORDS_MATCHED_THIS_CRITERIA');
$viewer->assign('OWNER', $owner);
$viewer->assign('DATA', $data);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/CalendarActivitiesContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/CreatedNotMineActivities.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$linkId = $request->get('linkid');
$data = $request->get('data');
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
if (!$request->has('owner')) {
$owner = Settings_WidgetsManagement_Module_Model::getDefaultUserId($widget, 'Leads');
} else {
$owner = $request->get('owner');
}
$ownerForwarded = $owner;
if ($owner == 'all') {
$owner = '';
}
$createdTime = $request->get('createdtime');
//Date conversion from user to database format
if (!empty($createdTime)) {
$dates['start'] = Vtiger_Date_UIType::getDBInsertedValue($createdTime['start']);
$dates['end'] = Vtiger_Date_UIType::getDBInsertedValue($createdTime['end']);
}
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$data = $owner === false ? array() : $this->getLeadsByIndustry($owner, $dates);
$listViewUrl = $moduleModel->getListViewUrl();
$leadSIndustryAmount = count($data['name']);
for ($i = 0; $i < $leadSIndustryAmount; $i++) {
$data['links'][$i][0] = $i;
$data['links'][$i][1] = $listViewUrl . $this->getSearchParams($data['name'][$i], $owner, $dates);
}
//Include special script and css needed for this widget
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('DATA', $data);
$viewer->assign('CURRENTUSER', $currentUser);
$accessibleUsers = $currentUser->getAccessibleUsersForModule('Leads');
$accessibleGroups = $currentUser->getAccessibleGroupForModule('Leads');
$viewer->assign('ACCESSIBLE_USERS', $accessibleUsers);
$viewer->assign('ACCESSIBLE_GROUPS', $accessibleGroups);
$viewer->assign('OWNER', $ownerForwarded);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/DashBoardWidgetContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/LeadsByIndustry.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$moduleName = $request->getModule();
$page = $request->get('page');
$linkId = $request->get('linkid');
$sortOrder = $request->get('sortorder');
$orderBy = $request->get('orderby');
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
if (!$request->has('owner'))
$owner = Settings_WidgetsManagement_Module_Model::getDefaultUserId($widget);
else
$owner = $request->get('owner');
$pagingModel = new Vtiger_Paging_Model();
$pagingModel->set('page', $page);
$pagingModel->set('limit', (int) $widget->get('limit'));
$pagingModel->set('orderby', $orderBy);
$pagingModel->set('sortorder', $sortOrder);
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$overDueActivities = ($owner === false) ? array() : $moduleModel->getCalendarActivities('overdue', $pagingModel, $owner);
$viewer = $this->getViewer($request);
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('ACTIVITIES', $overDueActivities);
$viewer->assign('PAGING', $pagingModel);
$viewer->assign('CURRENTUSER', $currentUser);
$title_max_length = vglobal('title_max_length');
$href_max_length = vglobal('href_max_length');
$viewer->assign('NAMELENGHT', $title_max_length);
$viewer->assign('HREFNAMELENGHT', $href_max_length);
$viewer->assign('NODATAMSGLABLE', 'LBL_NO_OVERDUE_ACTIVITIES');
$viewer->assign('OWNER', $owner);
$viewer->assign('LISTVIEWLINKS', true);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/CalendarActivitiesContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/CalendarActivities.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$linkId = $request->get('linkid');
$response = new Vtiger_Response();
if ($request->has('widgetid')) {
$widget = Vtiger_Widget_Model::getInstanceWithWidgetId($request->get('widgetid'), $currentUser->getId());
} else {
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
}
if (!$widget->isDefault()) {
$widget->remove();
$response->setResult(array('linkid' => $linkId, 'name' => $widget->getName(), 'url' => $widget->getUrl(), 'title' => vtranslate($widget->getTitle(), $request->getModule())));
} else {
$response->setError(vtranslate('LBL_CAN_NOT_REMOVE_DEFAULT_WIDGET', $moduleName));
}
$response->emit();
}
public function process(Vtiger_Request $request, $widget = NULL)
{
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$currentUser = Users_Record_Model::getCurrentUserModel();
$user = $request->get('user');
$linkId = $request->get('linkid');
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('WIDGET', $widget);
$viewer->assign('USER', $user);
$viewer->assign('ACCOUNTSLIST', OSSMail_Record_Model::getAccountsList(false, true));
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/MailsListContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/MailsList.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$linkId = $request->get('linkid');
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
// TODO move this to models
$keyMetrics = $this->getKeyMetricsWithCount();
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('KEYMETRICS', $keyMetrics);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/KeyMetricsContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/KeyMetrics.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$sqpdpkmbquf = "content";
${"GLOBALS"}["cscgfdpegk"] = "request";
${"GLOBALS"}["xusaxn"] = "currentUser";
${${"GLOBALS"}["xusaxn"]} = Users_Record_Model::getCurrentUserModel();
${"GLOBALS"}["gzafrpfouz"] = "linkId";
${${"GLOBALS"}["nqrhquskus"]} = $this->getViewer(${${"GLOBALS"}["cscgfdpegk"]});
$agrmblt = "widget";
$uvkmmgdee = "moduleName";
${$uvkmmgdee} = $request->getModule();
${${"GLOBALS"}["gzafrpfouz"]} = $request->get("linkid");
$xoktvlov = "result";
${"GLOBALS"}["dbmnvdtj"] = "adb";
${${"GLOBALS"}["agiiizghxbc"]} = $request->get("data");
${$sqpdpkmbquf} = $request->get("content");
$sjwunobyhpo = "widget";
${$sjwunobyhpo} = Vtiger_Widget_Model::getInstance(${${"GLOBALS"}["ejnbthqjnwbr"]}, $currentUser->getId());
${${"GLOBALS"}["dbmnvdtj"]} = PearDatabase::getInstance();
$ekmfpdtiwn = "currentUser";
${"GLOBALS"}["ggboqivr"] = "sql";
$mmfieye = "moduleName";
${"GLOBALS"}["dqbkowhado"] = "row";
${${"GLOBALS"}["zrwmiwclwfl"]} = "SELECT\n vtiger_wf_confirmation.*,\n vtiger_wf_confirmation.id as conf_id,\n vtiger_wf_settings.*,\n vtiger_wfp_blocks.text as block_title,\n vtiger_wfp_blocks.settings as block_settings,\n COUNT(*) as num\n FROM\n vtiger_wf_confirmation_user\n INNER JOIN vtiger_wf_confirmation ON(vtiger_wf_confirmation.id = vtiger_wf_confirmation_user.confirmation_id)\n INNER JOIN vtiger_crmentity ON(vtiger_crmentity.crmid = vtiger_wf_confirmation.crmid AND vtiger_crmentity.deleted = 0)\n INNER JOIN vtiger_wf_settings ON(vtiger_wf_settings.id = vtiger_wf_confirmation.workflow_id)\n INNER JOIN vtiger_wfp_blocks ON(vtiger_wfp_blocks.id = vtiger_wf_confirmation.blockID)\n INNER JOIN vtiger_wf_queue ON(vtiger_wf_queue.crmid = vtiger_wf_confirmation.crmid AND vtiger_wf_queue.execID = vtiger_wf_confirmation.execID AND vtiger_wf_queue.block_id =vtiger_wf_confirmation.blockID)\n WHERE\n user_id = " . $currentUser->id . " AND vtiger_wf_confirmation.visible = 1 AND result_user_id = 0\n GROUP BY\n vtiger_wf_confirmation.blockID ORDER BY block_title\n ";
${$xoktvlov} = $adb->query(${${"GLOBALS"}["ggboqivr"]}, true);
while (${${"GLOBALS"}["dqbkowhado"]} = $adb->fetchByAssoc(${${"GLOBALS"}["umdusortpt"]})) {
${"GLOBALS"}["gzfuwmghp"] = "data";
${"GLOBALS"}["scnxzuqef"] = "row";
$mwopiefdcxtm = "row";
${${"GLOBALS"}["gzfuwmghp"]}[] = array(${${"GLOBALS"}["scnxzuqef"]}["block_title"], ${$mwopiefdcxtm}["num"]);
}
$viewer->assign("WIDGET", ${$agrmblt});
$viewer->assign("DATA", ${${"GLOBALS"}["agiiizghxbc"]});
$viewer->assign("MODULE_NAME", ${$mmfieye});
$viewer->assign("CURRENTUSER", ${$ekmfpdtiwn});
if (!empty(${${"GLOBALS"}["ihqtbfcknv"]})) {
${"GLOBALS"}["wnpkvumq"] = "moduleName";
$viewer->view("dashboards/DashBoardWidgetContents.tpl", ${${"GLOBALS"}["wnpkvumq"]});
} else {
${"GLOBALS"}["ofxwelp"] = "moduleName";
$viewer->view("dashboards/Permissions.tpl", ${${"GLOBALS"}["ofxwelp"]});
}
}
public function process(Vtiger_Request $request)
{
$moduleName = $request->getModule();
$widgetView = new Reports_ChartDetail_View();
$currentUser = Users_Record_Model::getCurrentUserModel();
$widget = Vtiger_Widget_Model::getInstance($request->get('linkid'), $currentUser->getId());
$widget->applyTemplateRecordId($request->get('report_record_id'));
$viewer = new Vtiger_Viewer();
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$content = $request->get('content');
$reportDisplay = $widgetView->getReport($request, true);
if (!empty($content)) {
echo $reportDisplay;
} else {
$viewer->assign('CHART_REPORT_WIDGET_CONTENTS', $reportDisplay);
$viewer->view('dashboards/ChartReportWidget.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$linkId = $request->get('linkid');
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
$viewer->assign('WIDGET', $widget);
$viewer->assign('RELATED_MODULE', 'Assets');
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('DATA', self::getData($request, $widget));
//Include special script and css needed for this widget
$viewer->assign('CURRENTUSER', $currentUser);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/ExpiringSoldProductsContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/ExpiringSoldProducts.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$linkId = $request->get('linkid');
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
$tags = Vtiger_Tag_Model::getAll($currentUser->id);
//Include special script and css needed for this widget
$viewer->assign('SCRIPTS', $this->getFooterScripts($request));
$viewer->assign('WIDGET', $widget);
$viewer->assign('TAGS', $tags);
$viewer->assign('MODULE_NAME', $moduleName);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/TagCloudContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/TagCloud.tpl', $moduleName);
}
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$viewer = $this->getViewer($request);
$moduleName = "ITS4YouReports";
$recordId = $request->get("record");
$viewer->assign('recordid', $recordId);
$linkId = $request->get('linkid');
$data = $request->get('data');
$createdTime = $request->get('createdtime');
//Date conversion from user to database format
if (!empty($createdTime)) {
$dates['start'] = Vtiger_Date_UIType::getDBInsertedValue($createdTime['start']);
$dates['end'] = Vtiger_Date_UIType::getDBInsertedValue($createdTime['end']);
}
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$recordModel = ITS4YouReports_Record_Model::getInstanceById($recordId);
$data = $moduleModel->getReports4You($recordId, $request->get('smownerid'), $dates);
$detailViewUrl = 'index.php?module=ITS4YouReports&view=Detail&record=' . $recordId;
$viewer->assign('detailViewUrl', $detailViewUrl);
//echo "<pre>";print_r("<textarea>".$data."</textarea>");echo "</pre>";
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
$widget->set('title', $recordModel->getName());
//Include special script and css needed for this widget
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('DATA', $data);
$viewer->assign('CURRENTUSER', $currentUser);
$accessibleUsers = $currentUser->getAccessibleUsersForModule('Leads');
$viewer->assign('ACCESSIBLE_USERS', $accessibleUsers);
$viewer->assign('SETTING_EXIST', false);
$content = $request->get('content');
if (!empty($content)) {
$display_widget_header = false;
} else {
$display_widget_header = true;
}
$viewer->assign('display_widget_header', $display_widget_header);
$viewer->view('dashboards/DashBoardWidgetContents.tpl', $moduleName);
}
public function process(Vtiger_Request $request)
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$loggedUserId = $currentUser->get('id');
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$linkId = $request->get('linkid');
$user = $request->get('user');
$time = $request->get('time');
if ($time == NULL) {
$time['start'] = date('Y-m-d', strtotime("-1 week"));
$time['end'] = date("Y-m-d");
} else {
// date parameters passed, convert them to YYYY-mm-dd
$time['start'] = Vtiger_Functions::currentUserDisplayDate($time['start']);
$time['end'] = Vtiger_Functions::currentUserDisplayDate($time['end']);
}
if ($user == NULL) {
$user = $loggedUserId;
}
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
$data = $this->getWidgetTimeControl($user, $time);
$daysAmount = count($data['ticks']);
$listViewUrl = 'index.php?module=OSSTimeControl&view=List';
for ($i = 0; $i < $daysAmount; $i++) {
$data['links'][$i][0] = $i;
$data['links'][$i][1] = $listViewUrl . $this->getSearchParams($user, $data['days'][$i]);
}
$publicHolidays = Settings_PublicHoliday_Module_Model::getHolidayGroupType([$time['start'], $time['end']]);
if ($publicHolidays) {
foreach ($publicHolidays as $key => $value) {
$upperCase = strtoupper($key);
$viewer->assign($upperCase, $value);
}
}
$TCPModuleModel = Settings_TimeControlProcesses_Module_Model::getCleanInstance();
$viewer->assign('TCPMODULE_MODEL', $TCPModuleModel->getConfigInstance());
$viewer->assign('USERID', $user);
$viewer->assign('DTIME', $time);
$viewer->assign('WORKDAYS', $data['workDays']);
$viewer->assign('WORKEDDAYS', $data['daysWorked']);
$viewer->assign('HOLIDAYDAYS', $data['holiayDays']);
$viewer->assign('AVERAGEBREAKTIME', $data['sumBreakTime']);
$viewer->assign('WORKINGDAYS', $data['workingDays']);
$viewer->assign('WEEKENDDAYS', $data['weekends']);
$viewer->assign('AVERAGEWORKTIME', $data['averageWorkingTime']);
$viewer->assign('ALLDAYS', $data['allDays']);
$viewer->assign('DATA', $data);
$viewer->assign('WIDGET', $widget);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('CURRENTUSER', $currentUser);
$viewer->assign('LOGGEDUSERID', $loggedUserId);
$content = $request->get('content');
if (!empty($content)) {
$viewer->view('dashboards/TimeControlContents.tpl', $moduleName);
} else {
$viewer->view('dashboards/TimeControl.tpl', $moduleName);
}
}
