game ? $req->game : 'jspk10'; $request['no']=$req->no ? $req->no : ''; $request['star_time']=$req->star_time ? $req->star_time : date('Y-m-d'); $request['end_time']=$req->end_time ? $req->end_time : date('Y-m-d'); //$request['status'] = Request::has('status') ? Request::get('status') : 1; $this->getGame(); $dt = \App\Lib\DataTable\DataTable::init(); $dt->setDataSource('/admin/Infos/getMsg?game='.$request['game']); $dt->setLang('game_prize'); $dt->addColsFields('name'); $dt->addColsFields('info_no'); $dt->addColsFields('codes'); $dt->addColsFields('open_time'); if (checkRriv('/admin/Infos/Edit')) { $dt->addColsFields('edit',array('sort'=>false,'templet'=>'#edit')); //$dt->setToolBar(array('edit')); } return view('admin.infos/openMoney', $dt->render($request)); } //获取开奖数据信息 function getMsg(Req $req) { $game = $req->game ? $req->game : 'jspk10'; $no = $req->no ? $req->no : ''; $star_time=$req->star_time ? $req->star_time.' 00:00:00' : date('Y-m-d 00:00:00'); $end_time=$req->end_time ? $req->end_time.' 23:59:59' : date('Y-m-d 23:59:59'); $list = Request::has('limit') ? Request::get('limit') : ''; $page = Request::has('page') ? Request::get('page') : '1'; $fild = Request::has('fild') ? Request::get('fild') : 'open_time'; //$status = Request::get('status') ? Request::get('status') : 1; $order = Request::has('order') ? Request::get('order') : 'desc'; if (empty($game)) { return responseToJson(-5030025022); } $where=array(); /*if(!empty($game)){ $where[]=array('game_name','=',$game); }*/ if(!empty($no)){ $where[]=array('info_no',$no); } if(!empty($star_time)){ $where[]=array('open_time','>=',$star_time); } if(!empty($end_time)){ $where[]=array('open_time','<=',$end_time); } // $where[] = ($status==1)?array('status','<>',-1):array('status','-1'); $db = '\App\Models\GamePrize'; $data = $db::getMsgs($where,$game, $list,$fild,$order); return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total']); } /**获取游戏名**/ function getGame() { $db = new \App\Models\GamePrize; $info = $db->getgame(); return responseToJson($info); } //修改 function Edit(Req $req) { $id = $req->id; if (empty($id)) { abort(404); } $status = $req->status; $status = empty($status)?2:$status; $game = $req->game; $db = '\App\Models\Game' . ucfirst($game); $data = $db::where('id',$id)->first(); if(!$data){ return responseToJson(-5030002922);//没有数据 } $datas = $data->toArray(); $datas['game_name'] = $game; if (!$req->isMethod('post')) { return view('admin/infos/edit', ['data' => $datas]); } else { if (empty($req->info_no) || empty($req->codes) || empty($req->open_time)) { return responseToJson(-5030012022); } $data = array( 'info_no' => $req->info_no, 'codes' => $req->codes, 'open_time' => $req->open_time, // 'time_area'=>date('Y-m-d H:i:s',time()), ); $res = $db::where('id',$id)->where('status','<>',2)->update($data); if(!$res){ return responseToJson(-5030003022);//修改失败 } $log = array( session('adminInfo.admin_name'), trans('common.' . $datas['game_name']), $req->info_no, $req->codes, $req->open_time, ); OperationLog(session('adminInfo.admin_id'), 'edit_game_prize', $log); return responseToJson($res); } } //添加 function add(Req $req) { $game = $req->game; if (empty($game)) { abort(404); } $model = "\App\Models\Game" . ucfirst($game); $datas = ['game_name' => $game]; if (!$req->isMethod('post')) { //当前游戏下一期期号 $info_nos = $model::select('info_no')->orderBy('info_no','desc')->first(); if(!$info_nos){ $info_no = rand(1000, 2000); }else{ $info_no = $info_nos['info_no']+1; } $datas['info_no']=$info_no; return view('admin/infos/editinfo', ['data' => $datas,]); } else { if (empty($req->codes) || empty($req->open_time)) { return responseToJson(-5030012022); } $time = strtotime($req->open_time) ? strtotime($req->open_time) : ''; if (empty($time)) { return responseToJson(-5030014022); //请输入正确的时间格式 } //获取期号 $info_no = $req->info_no; if (empty($info_no) || !is_numeric($info_no)) { return responseToJson(-5030013022); //请填写正确的期号 } $data = array( 'identity' => UUID(), 'info_identity' => UUID(), 'info_no' => $info_no, 'codes' => $req->codes, 'open_time' => $req->open_time, 'time'=>date('Y-m-d H:i:s',time()), ); $res = $this->insetMsg($data,$game); $log = array( session('adminInfo.admin_name'), trans('common.' . $datas['game_name']), $req->info_no, $req->codes, $req->open_time, ); OperationLog(session('adminInfo.admin_id'), 'add_game_prize', $log); return responseToJson($res); } } //插入数据 function insetMsg($data,$game){ $model = "\App\Models\Game" . ucfirst($game); $info = $model::where('info_no',$data['info_no'])->first(); if(!$info){ $res = $model::insert($data); }else{ return -5030114122; //当期游戏已存在 } if(!$res){ return -5030003122;//添加失败 } return 1; } //获取游戏最新期号 function getInfos(Req $req){ $game = $req->game; if (empty($game)) { return responseToJson(-5030012022); } $db = new \App\Models\GamePrize; $info_no = $db->getInfoNo($game); if ($info_no < 0) { $info_no = rand(1000, 2000); } return responseToJson(1,'',$info_no); } //最后一期开奖时间 public function getGameLastOpenTime(Req $req) { $game = $req->game; if (empty($game)) { return responseToJson(-5030012022); } $data = $this->getGameTime($game); $model = '\App\Models\Game'.ucfirst($data['table_name']); $db = new $model; $game_info = $db->getOne($game); if ($game_info < 0) { return responseToJson($game_info,'获取最后期数失败',''); }else{ $data['last_time'] = $game_info['open_time']; //最后一期已开奖开奖时间 $time = strtotime($game_info['open_time'])+$data['cycle_time']+10; //时间处理最后一期已开奖开奖时间+当前游戏开奖时间周期+10秒 $data['change_time'] = date('Y-m-d H:i:s',$time); } return responseToJson(1,'获取成功',$data); } //获取游戏周期秒数 public function getGameTime($game) { $db = new \App\Models\GameType; return $db->getOpenTime($game); } }