public static function complaintsSearchCount($param) { $condition = array(); $db = self::__instance(); if ($param['start_date']) { $condition["AND"]['month[>=]'] = strtotime($param['start_date'] . '-01'); $condition["AND"]['month[<]'] = strtotime($param['start_date'] . '-01 +1 month -1 day'); unset($param['start_date'], $param['end_date']); } if (empty($param)) { $param = array(); } foreach ($param as $key => $value) { if ($key == 'case_id' || $key == 'buss_name' || $key == 'sp_name' || $key == 'dispute_phone' || $key == 'complaint_time') { $condition["LIKE"]["AND"][$key] = $value; } elseif ($key == 'question_type') { $complaintType = Info::getComplaintType(); $questionType = Info::getQuestionType($param['problem_type']); $condition['AND']['problem_type'] = $complaintType[$param['problem_type']]; $condition['AND']['contact_element'] = $questionType[$param['question_type']]; } elseif ($key == 'problem_type') { } else { $condition["AND"][$key] = $value; } } return $db->count('co_complaints', $condition); }
$comName[] = $value['name']; $comScore[] = $value['score']; } $data['provinces'] = implode(',', $proScore); $data['complaints'] = implode(',', $comScore); // foreach ($province as $key => $value) { // $data['provinceMap'][$key] = $value['name']; // } $data['provinceString'] = '"' . implode('","', $proName) . '"'; $data['provinceString2'] = '"' . implode('","', $comName) . '"'; // } $data['province'] = Info::getProvince(false); $data['complaintType'] = Info::getComplaintType('complaint_type', false); $data['questionType'][1] = Info::getQuestionType(1, 'question_type', true); $data['questionType'][2] = Info::getQuestionType(2, 'question_type', true); $data['questionType'][3] = Info::getQuestionType(3, 'question_type', true); $data['complaintLevel'] = Info::getComplaintLevel('complaint_level', false); $data['bussLine'] = Info::getBussLine('buss_type', false); // var_dump($data['bussLine']); //导出excel下载 if ($_GET['download'] == 1) { $downloadStr = array_to_string($data); //var_dump($data);exit; Common::exportExcel($downloadStr, 'black_list'); exit; } $page_html = Pagination::showPager("custom_analyze.php?class_name={$class_name}&user_name={$user_name}&start_date={$start_date}&end_date={$end_date}", $page_no, PAGE_SIZE, $row_count); $export_excel = "custom_analyze.php?download=1&class_name={$class_name}&user_name={$user_name}&start_date={$start_date}&end_date={$end_date}"; Template::assign("error", $error); Template::assign("_POST", $_POST); Template::assign('_GET', $_GET);
$data['questionType'][1] = Info::getQuestionType(1, 'problem_type', true, $problem_type); $data['questionType'][2] = Info::getQuestionType(2, 'problem_type', true, $problem_type); $data['questionType'][3] = Info::getQuestionType(3, 'problem_type', true, $problem_type); $data['complaintLevel'] = Info::getComplaintLevel('complaint_level', false); //var_dump($param,$complaint_level); if ($complaint_type != '') { if ($complaint_type == '0') { Template::assign('complaint_type', $complaint_type); } else { if ($problem_type != '') { if ($problem_type == '0') { Template::assign('problem_type', $problem_type); } else { //var_dump($param['problem_type']);exit; Template::assign('problem_type', $param['problem_type']); $questionType = Info::getQuestionType($param['complaint_type'], 'question_type', false); $param['problem_type'] = $questionType[$param['problem_type']]; } } Template::assign('complaint_type', $param['complaint_type']); $param['complaint_type'] = $data['complaintType'][$param['complaint_type']]; } } if ($complaint_level != '') { if ($complaint_level == '0') { Template::assign('complaint_level', $complaint_level); } else { Template::assign('complaint_level', $param['complaint_level']); $param['complaint_level'] = $data['complaintLevel'][$param['complaint_level']]; } }