3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.7 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2016 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
10 | CiviCRM is free software; you can copy, modify, and distribute it |
11 | under the terms of the GNU Affero General Public License |
12 | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. |
14 | CiviCRM is distributed in the hope that it will be useful, but |
15 | WITHOUT ANY WARRANTY; without even the implied warranty of |
16 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
17 | See the GNU Affero General Public License for more details. |
19 | You should have received a copy of the GNU Affero General Public |
20 | License and the CiviCRM Licensing Exception along |
21 | with this program; if not, contact CiviCRM LLC |
22 | at info[AT]civicrm[DOT]org. If you have questions about the |
23 | GNU Affero General Public License or the licensing of CiviCRM, |
24 | see the CiviCRM license FAQ at http://civicrm.org/licensing |
25 +--------------------------------------------------------------------+
31 * @copyright CiviCRM LLC (c) 2004-2016
35 * This class provides the functionality to save a search
36 * Saved Searches are used for saving frequently used queries
38 class CRM_Case_Form_Task_SearchTaskHookSample
extends CRM_Case_Form_Task
{
41 * Build all the data structures needed to build the form.
43 public function preProcess() {
46 // display name and email of all contact ids
47 $caseIDs = implode(',', $this->_caseIds
);
48 $statusId = CRM_Core_DAO
::getFieldValue('CRM_Core_DAO_OptionGroup', 'case_status', 'id', 'name');
50 SELECT ct.display_name as display_name,
51 cs.start_date as start_date,
55 INNER JOIN civicrm_case_contact cc ON ( cs.id = cc.case_id)
56 INNER JOIN civicrm_contact ct ON ( cc.contact_id = ct.id)
57 LEFT JOIN civicrm_option_value ov ON (cs.status_id = ov.value AND ov.option_group_id = {$statusId} )
58 WHERE cs.id IN ( {$caseIDs} )";
60 $dao = CRM_Core_DAO
::executeQuery($query, CRM_Core_DAO
::$_nullArray);
61 while ($dao->fetch()) {
63 'display_name' => $dao->display_name
,
64 'start_date' => CRM_Utils_Date
::customFormat($dao->start_date
),
65 'status' => $dao->status
,
68 $this->assign('rows', $rows);
72 * Build the form object.
74 public function buildQuickForm() {
75 $this->addButtons(array(