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;
}
