public function __construct() { $queries = array(); $dao = new CRM_Queryrunner_DAO_Query(); $dao->orderBy('name'); $dao->find(); while ($dao->fetch()) { $temp = array(); CRM_Core_DAO::storeValues($dao, $temp); $queries[$dao->id] = new CRM_Queryrunner_Query($temp); } $this->queries = $queries; }
/** * Function to delete the query * * @param $queryID * ID of the query to be deleted. * * @return bool|null */ public static function del($queryID) { if (!$queryID) { CRM_Core_Error::fatal(ts('Invalid value passed to delete function.')); } $dao = new CRM_Queryrunner_DAO_Query(); $dao->id = $queryID; if (!$dao->find(TRUE)) { return NULL; } if ($dao->delete()) { return TRUE; } }
/** * @return array */ public function setDefaultValues() { $defaults = array(); if (!$this->_id) { $defaults['is_active'] = $defaults['is_default'] = 1; return $defaults; } $dao = new CRM_Queryrunner_DAO_Query(); $dao->id = $this->_id; if (!$dao->find(TRUE)) { return $defaults; } CRM_Core_DAO::storeValues($dao, $defaults); if ($ts = $defaults['scheduled_run']) { $defaults['scheduled_run_date'] = date('m/d/Y', $ts); $defaults['scheduled_run_date_time'] = date('h:iA', $ts); } $this->assign('query', $defaults); return $defaults; }