$proScore[] = $value['score'];
}
foreach ($data['complaints'] as $key => $value) {
    $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}";
예제 #2
0
 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);
 }