[Summary view] [Print] [Text view]

   1  <?php
   2  /*+***********************************************************************************

   3   * The contents of this file are subject to the vtiger CRM Public License Version 1.0

   4   * ("License"); You may not use this file except in compliance with the License

   5   * The Original Code is:  vtiger CRM Open Source

   6   * The Initial Developer of the Original Code is vtiger.

   7   * Portions created by vtiger are Copyright (C) vtiger.

   8   * All Rights Reserved.

   9   *************************************************************************************/
  10  
  11  class HelpDesk_TicketsByStatus_Dashboard extends Vtiger_IndexAjax_View {
  12   
  13      function getSearchParams($value,$assignedto = '',$dates) {
  14          $listSearchParams = array();
  15          $conditions = array(array('ticketstatus','e',$value));
  16          if($assignedto != '') array_push($conditions,array('assigned_user_id','e',getUserFullName($assignedto)));
  17          if(!empty($dates)){
  18              array_push($conditions,array('createdtime','bw',$dates['start'].' 00:00:00,'.$dates['end'].' 23:59:59'));
  19          }
  20          $listSearchParams[] = $conditions;
  21          return '&search_params='. json_encode($listSearchParams);
  22      }
  23  
  24  	public function process(Vtiger_Request $request) {
  25          $currentUser = Users_Record_Model::getCurrentUserModel();
  26          $viewer = $this->getViewer($request);
  27          $moduleName = $request->getModule();
  28  
  29          $linkId = $request->get('linkid');
  30          $data = $request->get('data');
  31          
  32          $createdTime = $request->get('createdtime');
  33          
  34          //Date conversion from user to database format

  35          if(!empty($createdTime)) {
  36              $dates['start'] = Vtiger_Date_UIType::getDBInsertedValue($createdTime['start']);
  37              $dates['end'] = Vtiger_Date_UIType::getDBInsertedValue($createdTime['end']);
  38          }
  39  
  40          $moduleModel = Vtiger_Module_Model::getInstance($moduleName);
  41          $data = $moduleModel->getTicketsByStatus($request->get('owner'), $dates);
  42  
  43          $listViewUrl = $moduleModel->getListViewUrl();
  44          for($i = 0;$i<count($data);$i++){
  45              $data[$i]["links"] = $listViewUrl.$this->getSearchParams($data[$i][1],$request->get('owner'),$dates);
  46          }
  47          $widget = Vtiger_Widget_Model::getInstance($linkId, $currentUser->getId());
  48  
  49          //Include special script and css needed for this widget

  50  
  51          $viewer->assign('WIDGET', $widget);
  52          $viewer->assign('MODULE_NAME', $moduleName);
  53          $viewer->assign('DATA', $data);
  54          $viewer->assign('CURRENTUSER', $currentUser);
  55  
  56          $accessibleUsers = $currentUser->getAccessibleUsersForModule($moduleName);
  57          $viewer->assign('ACCESSIBLE_USERS', $accessibleUsers);
  58  
  59          $content = $request->get('content');
  60          if(!empty($content)) {
  61              $viewer->view('dashboards/DashBoardWidgetContents.tpl', $moduleName);
  62          } else {
  63              $viewer->view('dashboards/TicketsByStatus.tpl', $moduleName);
  64          }
  65      }
  66  }