[Sommaire] [Imprimer]

   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  
  12  /**    Function to get the list of tickets for the currently loggedin user
  13  **/
  14   
  15  function getMyTickets()
  16  {
  17      global $log;
  18      $log->debug("Entering getMyTickets() method ...");
  19      global $current_user;
  20      global $theme;
  21      global $current_language;
  22      global $adb;
  23      $current_module_strings = return_module_language($current_language, 'HelpDesk');
  24      $theme_path="themes/".$theme."/";
  25      $image_path=$theme_path."images/";
  26  
  27      $search_query="select vtiger_troubletickets.ticketid, parent_id, priority, vtiger_troubletickets.status, category, vtiger_troubletickets.title, vtiger_troubletickets.description, update_log, version_id,
  28  vtiger_crmentity.createdtime, vtiger_crmentity.modifiedtime, 
  29  vtiger_contactdetails.firstname, vtiger_contactdetails.lastname, 
  30  vtiger_account.accountid, vtiger_account.accountname, 
  31  vtiger_users.user_name from 
  32      vtiger_troubletickets 
  33      inner join vtiger_crmentity on vtiger_crmentity.crmid = vtiger_troubletickets.ticketid 
  34      inner join vtiger_users on vtiger_users.id = vtiger_crmentity.smownerid 
  35      left join vtiger_contactdetails on vtiger_troubletickets.parent_id = vtiger_contactdetails.contactid 
  36      left join vtiger_account on vtiger_account.accountid = vtiger_troubletickets.parent_id 
  37      left join vtiger_seticketsrel on vtiger_seticketsrel.ticketid = vtiger_troubletickets.ticketid 
  38      where vtiger_crmentity.smownerid = ".$current_user->id." and vtiger_crmentity.deleted = 0 and vtiger_troubletickets.status <> 'Closed'  ORDER BY createdtime DESC";
  39  
  40      $resultcount = $adb->num_rows($adb->query($search_query));
  41      if($resultcount > 0)
  42      {
  43          $tktresult = $adb->limitquery($search_query,0,5);
  44          $title=array();
  45          $title[]='myTickets.gif';
  46          $title[]=$current_module_strings['LBL_MY_TICKETS'];
  47          $title[]='home_mytkt';
  48  
  49          $header=array();
  50          $header[]=$current_module_strings['LBL_SUBJECT'];
  51          $header[]=$current_module_strings['LBL_TICKET_ID'];
  52          $header[]=$current_module_strings['Related To'];
  53          $header[]=$current_module_strings['LBL_STATUS'];
  54          $header[]=$current_module_strings['LBL_CREATED_DATE'];
  55          $header[]=$current_module_strings['LBL_ASSIGNED_TO'];
  56  
  57          $noofrows = $adb->num_rows($tktresult);
  58          for ($i=0; $i<$adb->num_rows($tktresult); $i++)
  59          {
  60              $value=array();
  61              $ticketid = $adb->query_result($tktresult,$i,"ticketid");
  62              $value[]= '<a href="index.php?action=DetailView&module=HelpDesk&record='.$adb->query_result($tktresult,$i,"ticketid").'">'.$adb->query_result($tktresult,$i,"title").'</a>';
  63              $value[]=$ticketid;
  64  
  65              $parent_id = $adb->query_result($tktresult,$i,"parent_id");
  66              $parent_name = '';
  67              if($parent_id != '' && $parent_id != NULL)
  68              {
  69                  $parent_name = getParentLink($parent_id);
  70              }
  71  
  72              $value[]=$parent_name;
  73              $value[]=$adb->query_result($tktresult,$i,"status");
  74              $value[]=getDisplayDate($adb->query_result($tktresult,$i,"createdtime"));
  75              $value[]=$adb->query_result($tktresult,$i,"user_name");
  76              $entries[$ticketid]=$value;
  77          }
  78          $values=Array('Title'=>$title,'Header'=>$header,'Entries'=>$entries);
  79          if ( ($display_empty_home_blocks && $noofrows == 0 ) || ($noofrows>0) )    
  80          {
  81              $log->debug("Exiting getMyTickets method ...");
  82              return $values;
  83          }
  84          $log->debug("Exiting getMyTickets method ...");
  85      }
  86      $log->debug("Exiting getMyTickets method ...");
  87  }
  88  
  89  /**    Function to get the parent (Account or Contact) link
  90    *    @param int $parent_id -- parent id of the ticket (accountid or contactid)
  91    *    return string $parent_name -- return the parent name as a link
  92  **/
  93  function getParentLink($parent_id)
  94  {
  95      global $log;
  96      $log->debug("Entering getParentLink(".$parent_id.") method ...");
  97      global $adb;
  98  
  99      $sql = "select setype from vtiger_crmentity where crmid=".$parent_id;
 100      $parent_module = $adb->query_result($adb->query($sql),0,'setype');
 101  
 102      if($parent_module == 'Contacts')
 103      {
 104          $sql = "select firstname,lastname from vtiger_contactdetails where contactid=".$parent_id;
 105          $parentname = $adb->query_result($adb->query($sql),0,'firstname');
 106          $parentname .= ' '.$adb->query_result($adb->query($sql),0,'lastname');
 107              $parent_name = '<a href="index.php?action=DetailView&module='.$parent_module.'&record='.$parent_id.'">'.$parentname.'</a>';
 108      }
 109      if($parent_module == 'Accounts')
 110      {
 111          $sql = "select accountname from vtiger_account where accountid=".$parent_id;
 112          $parentname = $adb->query_result($adb->query($sql),0,'accountname');
 113              $parent_name = '<a href="index.php?action=DetailView&module='.$parent_module.'&record='.$parent_id.'">'.$parentname.'</a>';
 114      }
 115  
 116      $log->debug("Exiting getParentLink method ...");
 117      return $parent_name;
 118  }
 119  ?>