public function postAddcooperator (Request $request) { $validate = Validator::make($request->input(), [ 'contact' => 'required', 'mobile' => 'required', 'province' => 'required', 'city' => 'required', 'district' => 'required', 'email' => 'required' ]); if ($validate->fails()) { $failed = $validate->failed(); $message = array(); foreach ($failed as $key => $value) { array_push($message, $key); } return $this->failResponse($message); } else { $input = $request->input(); unset($input['_token']); $res = Cooperators::create($input); return $this->successResponse('res', $res); } }
public function getIndex(Request $request) { $page = $request->input('page'); $offset = 20; $pages = ceil(Cooperators::count() / $offset); $page = empty($page) ? 1 : $page > $pages ? $pages : $page < 1 ? 1 : $page; $excel = $request->input('excel'); $province = $request->input('province'); $city = $request->input('city'); $district = $request->input('district'); $query = Cooperators::where('id', '>', 0); if (!empty($province)) { $query->where('province', '=', $province); } if (!empty($city)) { $query->where('city', '=', $city); } if (!empty($district)) { $query->where('district', '=', $district); } if (empty($excel)) { $coopers = $query->skip(($page - 1) * $offset)->take($offset)->orderBy('created_at', 'desc')->get(); $data = ['cooperators' => $coopers, 'pageName' => '合作伙伴', 'current_page' => $page, 'pages' => $pages, 'route' => $this->route]; return view('admin/coope_board', $data); } else { $coopers = $query->get(); require_once 'phpexcel/Classes/PHPExcel.php'; $excel = new \PHPExcel(); $letters = ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H']; $tableheader = ['序号', '联系人', '公司', '手机号', '固定电话', '所属区域', '电子邮箱', '提交时间']; for ($i = 0; $i < count($tableheader); $i++) { $excel->getActiveSheet()->setCellValue("{$letters[$i]}1", "{$tableheader[$i]}"); } $j = 2; foreach ($coopers as $cooper) { $excel->getActiveSheet()->setCellValue("A{$j}", $cooper->id); $excel->getActiveSheet()->setCellValue("B{$j}", $cooper->contact); $excel->getActiveSheet()->setCellValue("C{$j}", $cooper->company); $excel->getActiveSheet()->setCellValue("D{$j}", $cooper->mobile); $excel->getActiveSheet()->setCellValue("E{$j}", $cooper->phone); $excel->getActiveSheet()->setCellValue("F{$j}", $cooper->province . $cooper->city . $cooper->district); $excel->getActiveSheet()->setCellValue("G{$j}", $cooper->email); $excel->getActiveSheet()->setCellValue("H{$j}", $cooper->created_at . ''); $j++; $doc = new \PHPExcel_Writer_Excel5($excel); header("Pragma: public"); header("Expires: 0"); header("Cache-Control:must-revalidate, post-check=0, pre-check=0"); header("Content-Type:application/force-download"); header("Content-Type:application/vnd.ms-execl"); header("Content-Type:application/octet-stream"); header("Content-Type:application/download"); header('Content-Disposition:attachment;filename="cooperators.xls"'); header("Content-Transfer-Encoding:binary"); $doc->save('php://output'); } } }
public function getPush(Request $request) { $order = Order::count(); $coop = Cooperators::count(); $data = "data:{$order}-{$coop}" . "\r\n\r\n"; return response($data, 200)->header('Content-Type', 'text/event-stream;charset=utf-8')->header('Access-Control-Allow-Origin', 'http://www.51linpai.com'); /* header('Content-Type:text/event-stream;charset=utf-8'); header('Access-Control-Allow-Origin', 'http://localhost:8000'); echo 'data:' . date('H:i:s'); */ }