Update Copywrite year to be 2019
[civicrm-core.git] / CRM / Case / Form / Task / SearchTaskHookSample.php
CommitLineData
6a488035
TO
1<?php
2/*
3 +--------------------------------------------------------------------+
fee14197 4 | CiviCRM version 5 |
6a488035 5 +--------------------------------------------------------------------+
6b83d5bd 6 | Copyright CiviCRM LLC (c) 2004-2019 |
6a488035
TO
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
9 | |
10 | CiviCRM is free software; you can copy, modify, and distribute it |
11 | under the terms of the GNU Affero General Public License |
c73475ea 12 | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. |
6a488035
TO
13 | |
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. |
18 | |
19 | You should have received a copy of the GNU Affero General Public |
c73475ea
WA
20 | License and the CiviCRM Licensing Exception along |
21 | with this program; if not, contact CiviCRM LLC |
6a488035
TO
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 +--------------------------------------------------------------------+
d25dd0ee 26 */
6a488035
TO
27
28/**
29 *
30 * @package CRM
6b83d5bd 31 * @copyright CiviCRM LLC (c) 2004-2019
6a488035
TO
32 */
33
34/**
35 * This class provides the functionality to save a search
36 * Saved Searches are used for saving frequently used queries
37 */
38class CRM_Case_Form_Task_SearchTaskHookSample extends CRM_Case_Form_Task {
39
40 /**
fe482240 41 * Build all the data structures needed to build the form.
6a488035 42 */
00be9182 43 public function preProcess() {
6a488035
TO
44 parent::preProcess();
45 $rows = array();
46 // display name and email of all contact ids
6e3090fb 47 $caseIDs = implode(',', $this->_entityIds);
6a488035 48 $statusId = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_OptionGroup', 'case_status', 'id', 'name');
353ffa53 49 $query = "
6a488035
TO
50SELECT ct.display_name as display_name,
51 cs.start_date as start_date,
52 ov.label as status
8ef12e64 53
6a488035
TO
54FROM civicrm_case cs
55INNER JOIN civicrm_case_contact cc ON ( cs.id = cc.case_id)
56INNER JOIN civicrm_contact ct ON ( cc.contact_id = ct.id)
57LEFT JOIN civicrm_option_value ov ON (cs.status_id = ov.value AND ov.option_group_id = {$statusId} )
58WHERE cs.id IN ( {$caseIDs} )";
59
33621c4f 60 $dao = CRM_Core_DAO::executeQuery($query);
6a488035
TO
61 while ($dao->fetch()) {
62 $rows[] = array(
63 'display_name' => $dao->display_name,
64 'start_date' => CRM_Utils_Date::customFormat($dao->start_date),
65 'status' => $dao->status,
66 );
67 }
68 $this->assign('rows', $rows);
69 }
70
71 /**
fe482240 72 * Build the form object.
6a488035
TO
73 */
74 public function buildQuickForm() {
75 $this->addButtons(array(
76 array(
77 'type' => 'done',
78 'name' => ts('Done'),
79 'isDefault' => TRUE,
80 ),
81 )
82 );
83 }
96025800 84
6a488035 85}