[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 Portal_Module_Model extends Vtiger_Module_Model {
  12      
  13      public function getSideBarLinks($linkParams) {
  14          $quickLink = array(
  15              'linktype' => 'SIDEBARLINK',
  16              'linklabel' => 'LBL_OUR_SITES_LIST',
  17              'linkurl' => $this->getListViewUrl(),
  18              'linkicon' => '',
  19          );
  20          $links['SIDEBARLINK'][] = Vtiger_Link_Model::getInstanceFromValues($quickLink);
  21          return $links;
  22      }
  23      
  24          public function savePortalRecord($recordId, $bookmarkName, $bookmarkUrl) {
  25          $db = PearDatabase::getInstance();
  26          if(empty($recordId)) {
  27              $portalId = $db->getUniqueID('vtiger_portal');
  28              $query = "INSERT INTO vtiger_portal VALUES(?,?,?,?,?,?)";
  29              $params = array($portalId, $bookmarkName, $bookmarkUrl, 0, 0, date('Y-m-d H:i:s'));
  30          }
  31          else {
  32              $query = "UPDATE vtiger_portal SET portalname=?, portalurl=? WHERE portalid=?";
  33              $params = array($bookmarkName, $bookmarkUrl, $recordId);
  34          }
  35          
  36          $db->pquery($query, $params);
  37          return true;
  38      }
  39      
  40      public function getRecord($recordId) {
  41          $db = PearDatabase::getInstance();
  42          
  43          $result = $db->pquery('SELECT portalname, portalurl FROM vtiger_portal WHERE portalid = ?', array($recordId));
  44          
  45          $data['bookmarkName'] = $db->query_result($result, 0, 'portalname');
  46          $data['bookmarkUrl'] = $db->query_result($result, 0, 'portalurl');
  47          
  48          return $data;
  49      }
  50      
  51      public function deleteRecord($recordModel) {
  52          $recordId = $recordModel->getId();
  53          $db = PearDatabase::getInstance();
  54          $db->pquery('DELETE FROM vtiger_portal WHERE portalid = ?', array($recordId));
  55      }
  56      
  57      public function getWebsiteUrl($recordId) {
  58          $db = PearDatabase::getInstance();
  59          $result = $db->pquery('SELECT portalurl FROM vtiger_portal WHERE portalid=?', array($recordId));
  60          
  61          return $db->query_result($result, 0, 'portalurl');
  62      }
  63      
  64      public function getAllRecords() {
  65          $db = PearDatabase::getInstance();
  66          $record = array();
  67          
  68          $result = $db->pquery('SELECT portalid, portalname FROM vtiger_portal', array());
  69          
  70          for($i = 0; $i < $db->num_rows($result); $i++) {
  71              $row = $db->fetch_row($result, $i);
  72              $record[$i]['id'] = $row['portalid'];
  73              $record[$i]['portalname'] = $row['portalname'];
  74          }
  75          
  76          return $record;
  77      }
  78      
  79      public function deleteRecords(Vtiger_Request $request) {
  80          $searchValue = $request->get('search_value');
  81          $selectedIds = $request->get('selected_ids');
  82          $excludedIds = $request->get('excluded_ids');
  83          
  84          $db = PearDatabase::getInstance();
  85          
  86          $query = 'DELETE FROM vtiger_portal';
  87          $params = array();
  88          
  89          if(!empty($selectedIds) && $selectedIds != 'all' && count($selectedIds) > 0) {
  90              $query .= " WHERE portalid IN (".generateQuestionMarks($selectedIds).")";
  91              $params = $selectedIds;
  92          } else if($selectedIds == 'all') {
  93              if(empty($searchValue) && count($excludedIds) > 0) {
  94                  $query .= " WHERE portalid NOT IN (".generateQuestionMarks($excludedIds).")";
  95                  $params = $excludedIds;
  96              } else if(!empty($searchValue) && count($excludedIds) < 1) {
  97                  $query .= " WHERE portalname LIKE '%".$searchValue."%'";
  98              } else if(!empty($searchValue) && count($excludedIds) > 0) {
  99                  $query .= " WHERE portalname LIKE '%".$searchValue."%' AND portalid NOT IN (".generateQuestionMarks($excludedIds).")";
 100                  $params = $excludedIds;
 101              }
 102          }
 103          $db->pquery($query, $params);
 104      }
 105  }