} if (!empty($filled_surveys) && is_array($filled_surveys)) { $allow_ids = cw_array_merge($allow_ids, $filled_surveys); } $surveys = cw_query_hash("SELECT {$tables['surveys']}.* FROM {$tables['surveys']}, {$tables['survey_questions']} WHERE {$tables['surveys']}.valid_from_date < {$now} AND {$tables['surveys']}.expires_data > {$now} AND {$tables['surveys']}.survey_id = {$tables['survey_questions']}.survey_id AND ({$tables['surveys']}.survey_type = 'P'" . (empty($customer_id) ? "" : " OR {$tables['surveys']}.survey_type = 'R'") . " OR ({$tables['surveys']}.survey_type = 'H' AND {$tables['surveys']}.survey_id IN ('" . implode("','", $allow_ids) . "'))) GROUP BY {$tables['surveys']}.survey_id ORDER BY {$tables['surveys']}.orderby", "survey_id", false); $count_surveys = 0; $count_filled = 0; if (!empty($surveys)) { foreach ($surveys as $sid => $v) { list($is_valid, $messages) = cw_check_survey($sid); if (!$is_valid) { unset($surveys[$sid]); continue; } $count_surveys++; if (cw_check_survey_filling($sid)) { $surveys[$sid]['is_filled'] = true; $count_filled++; } if (!empty($filled_surveys) && in_array($sid, $filled_surveys) && $v['publish_results'] == 'Y') { $id = array_search($sid, $filled_surveys); $rid = cw_query_first_cell("SELECT survey_result_id FROM {$tables['survey_results']} WHERE survey_result_id = '{$id}' AND survey_id = '{$sid}'"); if (!empty($rid)) { $surveys[$sid]['is_view_results'] = true; } else { cw_unset($filled_surveys, $id); } } $surveys[$sid]['survey'] = cw_get_languages_alt("survey_name_" . $sid, false, true); } if (!empty($surveys)) {
cw_load('surveys'); $filled_surveys =& cw_session_register('filled_surveys'); if (!isset($config['survey_sending_remainder']) || $config['survey']['survey_send_by_c_area_period'] < $config['survey_sending_remainder']) { cw_array2insert("config", array("name" => "survey_sending_remainder", "value" => $config['survey']['survey_send_by_c_area_period']), true); $config['survey_sending_remainder'] = $config['survey']['survey_send_by_c_area_period']; } if (defined("NEW_SESSION")) { $config['survey_sending_remainder']--; if ($config['survey']['survey_send_by_c_area'] && $config['survey_sending_remainder'] <= 0) { cw_send_survey_invitations_list(); $config['survey_sending_remainder'] = $config['survey']['survey_send_by_c_area_period']; } cw_array2update("config", array("value" => $config['survey_sending_remainder']), "name = 'survey_sending_remainder'"); } # Get survey for menu box $avail_surveys = cw_get_surveys_ids(false, 1); if (count($avail_surveys)) { $menu_surveys = array(); foreach ($avail_surveys as $sid) { $survey = cw_get_survey($sid); if ($survey['valid'] && !cw_check_survey_filling($sid)) { $menu_surveys[$sid] = $survey; if ($config['survey']['survey_menu_only_one'] == 'Y') { break; } } } $smarty->assign('menu_surveys', $menu_surveys); $smarty->assign('surveys_is_avail', true); }