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');
*/
}
