/**
* The place to check if the data set in the snippet is valid
* to generate the snippet.
*
* When invalid data should result in an error, you can throw it
* here but you can also perform the check in the
* checkRegistryRequestsAnswers() function from the
* {@see \MUtil_Registry_TargetInterface}.
*
* @return boolean
*/
public function hasHtmlOutput()
{
$reqFilter = $this->request->getParam('filter');
switch ($reqFilter) {
case 'todo':
//Only actions valid now that are not already done
$filter[] = 'gto_completion_time IS NULL';
$filter[] = 'gto_valid_from <= CURRENT_TIMESTAMP';
$filter[] = '(gto_valid_until IS NULL OR gto_valid_until >= CURRENT_TIMESTAMP)';
break;
case 'done':
//Only completed actions
$filter[] = 'gto_completion_time IS NOT NULL';
break;
case 'missed':
//Only missed actions (not filled in, valid until < today)
$filter[] = 'gto_completion_time IS NULL';
$filter[] = 'gto_valid_until < CURRENT_TIMESTAMP';
break;
case 'all':
$filter[] = 'gto_valid_from IS NOT NULL';
break;
default:
//2 weeks look ahead, valid from date is set
$filter[] = 'gto_valid_from IS NOT NULL';
$filter[] = 'DATEDIFF(gto_valid_from, CURRENT_TIMESTAMP) < 15';
$filter[] = '(gto_valid_until IS NULL OR gto_valid_until >= CURRENT_TIMESTAMP)';
}
$this->model->setMeta('tab_filter', $filter);
return parent::hasHtmlOutput();
}
/**
* The place to check if the data set in the snippet is valid
* to generate the snippet.
*
* When invalid data should result in an error, you can throw it
* here but you can also perform the check in the
* checkRegistryRequestsAnswers() function from the
* {@see \MUtil_Registry_TargetInterface}.
*
* @return boolean
*/
public function hasHtmlOutput()
{
$sql = "SELECT COALESCE(gto_round_description, '') AS label,\n SUM(\n CASE\n WHEN gto_completion_time IS NOT NULL\n THEN 1\n ELSE 0\n END\n ) AS completed,\n SUM(\n CASE\n WHEN gto_completion_time IS NULL AND\n gto_valid_from < CURRENT_TIMESTAMP AND\n (gto_valid_until > CURRENT_TIMESTAMP OR gto_valid_until IS NULL)\n THEN 1\n ELSE 0\n END\n ) AS waiting,\n COUNT(*) AS any\n FROM gems__tokens INNER JOIN\n gems__surveys ON gto_id_survey = gsu_id_survey INNER JOIN\n gems__rounds ON gto_id_round = gro_id_round INNER JOIN\n gems__respondent2track ON gto_id_respondent_track = gr2t_id_respondent_track INNER JOIN\n gems__reception_codes AS rcto ON gto_reception_code = rcto.grc_id_reception_code INNER JOIN\n gems__reception_codes AS rctr ON gr2t_reception_code = rctr.grc_id_reception_code\n WHERE gto_id_respondent = ? AND\n gro_active = 1 AND\n gsu_active = 1 AND\n rcto.grc_success = 1 AND\n rctr.grc_success = 1\n GROUP BY COALESCE(gto_round_description, '')\n ORDER BY MIN(COALESCE(gto_round_order, 100000)), gto_round_description";
// \MUtil_Echo::track($this->respondentId);
$tabLabels = $this->db->fetchAll($sql, $this->respondentId);
if ($tabLabels) {
$default = null;
$filters = array();
$noOpen = true;
$tabs = array();
foreach ($tabLabels as $row) {
$name = '_' . \MUtil_Form::normalizeName($row['label']);
$label = $row['label'] ? $row['label'] : $this->_('empty');
if ($row['waiting']) {
$label = sprintf($this->_('%s (%d open)'), $label, $row['waiting']);
} else {
$label = $label;
}
if (!$row['label']) {
$label = \MUtil_Html::create('em', $label);
}
$filters[$name] = $row['label'];
$tabs[$name] = $label;
if ($noOpen && $row['completed'] > 0) {
$default = $name;
}
if ($row['waiting'] > 0) {
$default = $name;
$noOpen = false;
}
}
if (null === $default) {
reset($filters);
$default = key($filters);
}
// Set the model
$reqFilter = $this->request->getParam($this->getParameterKey());
if (!isset($filters[$reqFilter])) {
$reqFilter = $default;
}
if ('' === $filters[$reqFilter]) {
$this->model->setMeta('tab_filter', array("(gto_round_description IS NULL OR gto_round_description = '')"));
} else {
$this->model->setMeta('tab_filter', array('gto_round_description' => $filters[$reqFilter]));
}
// \MUtil_Echo::track($tabs, $reqFilter, $default, $tabLabels);
$this->defaultTab = $default;
$this->_tabs = $tabs;
}
return $this->_tabs && parent::hasHtmlOutput();
}
