public function smsSchoolSelect()
{
$M = M('safe_paicha');
$paicha_list = $M->select('', 'id,name', '', 'id DESC');
$paicha_id = $_GET['paicha_id'] ? $_GET['paicha_id'] : '';
//排查id
$type = $_GET['type'];
//未排查(1) 还是 未整改(2)
if ($_GET['dosearch'] && $paicha_id) {
$M = M('safe_school_baobiao');
$where = "paicha_id='{$paicha_id}'";
if ($type == 1) {
//未排查学校
$where .= " AND status1>0 ";
} elseif ($type == 2) {
//未整改学校
$where .= " AND status3>0 ";
}
$school_list = $M->select($where, 'school_id');
foreach ($school_list as $k => $v) {
$school_list[$k]['name'] = getSchoolName($v['school_id']);
$school_list[$k]['id'] = $v['school_id'];
}
} else {
$M = M('safe_school');
$school_list = $M->select('', 'name,id');
}
include $this->new_admin_tpl('school_select');
}
public function getBaobiaoDetail()
{
$paicha_id = intval($_GET['paicha_id']);
//排查id
$school_id = intval($_GET['school_id']);
//学校id
if (!$paicha_id || !$school_id) {
$this->jsonResult(array());
}
$M = M('safe_paicha');
$r = $M->get_one("id='{$paicha_id}'", 'id,name,start_time,question_time,answer_time,zhenggai_time,xiangmu_ids');
$r['question_time_format'] = timeFormat1($r['question_time']);
$r['answer_time_format'] = timeFormat1($r['answer_time']);
$r['zhenggai_time_format'] = timeFormat1($r['zhenggai_time']);
$r['school_name'] = getSchoolName($school_id);
//学校名称
$data = array();
$data['paicha'] = $r;
//排查信息数据
$xiangmu_ids = $r['xiangmu_ids'];
$xiangmu_arr = explode(',', $xiangmu_ids);
$M = M('safe_baobiao');
$M2 = M('safe_status_remark');
$baobiao = array();
//报表数据
$bb_data = $M->select("paicha_id='{$paicha_id}' AND school_id='{$school_id}'", '*', '', '', '', 'xiangmu_id');
//数据库中已有的报表数据
$empty_status_arr = array('status2_desc' => '', 'status2_file' => '', 'status3_desc' => '', 'status3_file' => '', 'status4_desc' => '', 'status4_file' => '', 'status5_desc' => '', 'status5_file' => '');
foreach ($xiangmu_arr as $xiangmu_id) {
if ($bb_data[$xiangmu_id]) {
//如果数据库中存在
$baobiao['xiangmu_' . $xiangmu_id] = $bb_data[$xiangmu_id];
$bb_id = $bb_data[$xiangmu_id]['id'];
$r_status = $M2->get_one("baobiao_id='{$bb_id}'");
$r_status = $r_status ? $r_status : $empty_status_arr;
$baobiao['xiangmu_' . $xiangmu_id] = array_merge($baobiao['xiangmu_' . $xiangmu_id], $r_status);
} else {
//否则构建一个空数据
$baobiao['xiangmu_' . $xiangmu_id] = array('xiangmu_id' => $xiangmu_id, 'status3' => '1', 'question' => '', 'answer' => '');
$baobiao['xiangmu_' . $xiangmu_id] = array_merge($baobiao['xiangmu_' . $xiangmu_id], $empty_status_arr);
}
}
$data['baobiao'] = $baobiao;
$this->jsonResult($data);
}
