public function refresh() { $list = M('order')->order('time desc')->limit(25)->select(); $html = ''; foreach ($list as $k => $v) { $html .= $v['emerg'] == 1 ? '<tr class="am-active">' : '<tr>'; $html .= '<td>' . $v['order'] . '</td>'; //工单号 $building = $v['emerg'] == 1 ? $v['description'] : (empty($v['building']) ? '-' : building($v['area'], $v['building'])); $html .= '<td class="am-show-md-up">' . $building . '</td>'; //报修楼栋 $html .= '<td class="am-show-md-up">' . $v['location'] . '</td>'; //报修寝室 $html .= '<td class="am-show-md-up">' . date("Y年m月d日", $v['time']) . '</td>'; //报修时间 $html .= '<td>' . status($v['status']) . '</td>'; //维修状态 $html .= '<td><a href="' . U('Report/detail', array('order' => $v['order'])) . '">详细»</a></td>'; $html .= '</tr>'; } echo $html; }
protected function goods_export($goods_list = array()) { //print_r($goods_list);exit; $goods_list = $goods_list; $data = array(); foreach ($goods_list as $k => $goods_info) { $data[$k][order] = $goods_info['order']; $data[$k][area] = area($goods_info['area']); $data[$k][building] = building($goods_info['area'], $goods_info['building']); $data[$k][location] = $goods_info['location']; $data[$k][good] = $goods_info['good']; $data[$k][description] = $goods_info['description']; $data[$k][user] = $goods_info['user']; $data[$k][time] = date('Y/m/d H:i:s', $goods_info['time']); $data[$k][dotime] = date('Y/m/d H:i:s', $goods_info['dotime']); $data[$k][donetime] = date('Y/m/d H:i:s', $goods_info['donetime']); $data[$k][canceltime] = date('Y/m/d H:i:s', $goods_info['canceltime']); $data[$k][status] = status($goods_info['status']); $data[$k][emerg] = $goods_info['emerg']; $data[$k][doctor] = $goods_info['doctor']; $data[$k][repairer] = $goods_info['repairer']; } //print_r($goods_list); //print_r($data);exit; foreach ($data as $field => $v) { if ($field == 'order') { $headArr[] = '工单号'; } if ($field == 'area') { $headArr[] = '区域'; } if ($field == 'building') { $headArr[] = '楼栋'; } if ($field == 'location') { $headArr[] = '地点'; } if ($field == 'good') { $headArr[] = '物品'; } if ($field == 'description') { $headArr[] = '描述'; } if ($field == 'user') { $headArr[] = '用户'; } if ($field == 'time') { $headArr[] = '报修时间'; } if ($field == 'dotime') { $headArr[] = '确认时间'; } if ($field == 'donetime') { $headArr[] = '完成时间'; } if ($field == 'canceltime') { $headArr[] = '取消时间'; } if ($field == 'status') { $headArr[] = '状态'; } if ($field == 'emerg') { $headArr[] = '紧急'; } if ($field == 'doctor') { $headArr[] = '管理员'; } if ($field == 'repairer') { $headArr[] = '维修人员'; } } $filename = "goods_list"; $this->getExcel($filename, $headArr, $data); }