post['page']) && $this->post['page'] !== "" ? intval($this->post['page']) : "1"; $size = isset($this->post['size']) && $this->post['size'] !== "" ? intval($this->post['size']) : "10"; $condition = [['type',"=",1]]; $count = Db::name("action_log")->where($condition)->count(); $total = ceil($count/$size); $page = $page >= $total ? intval($total) : $page; $list =Db::name("action_log")->where($condition)->page($page,$size)->order("addtime desc")->select(); return app_show(0,"获取成功",['list'=>$list,"count"=>$count]); } /** * 显示创建资源表单页. * * @return \think\Response */ public function create() { } /** * 保存新建的资源 * * @param \think\Request $request * @return \think\Response */ public function save(Request $request) { // } /** * 显示指定的资源 * * @param int $id * @return \think\Response */ public function read() { $id = isset($this->post['id'])&&$this->post['id']!=="" ? intval($this->post['id']) :""; if($id===""){ return error_show(1004,"参数 id 不能为空"); } $info = Db::name("action_log")->where(["id"=>$id])->find(); if(empty($info)){ return error_show(1004,"未找到数据"); } return app_show(0,"获取成功",$info); } /** * 显示编辑资源表单页. * * @param int $id * @return \think\Response */ public function msglist() { $param = $this->request->only(['token' => '', 'orderCode' => '', 'page' => 1, 'size' => 10, 'order_type' => '', 'is_read' => ''], 'post', 'trim'); $apply_id = GetUserInfo($param['token']); if (empty($apply_id) || $apply_id['code'] != 0) return error_show(1002, "用户数据不存在"); $rm = isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : 0; $condition = [['om.uid', '=', $rm]];//自己看到自己的消息 if ($param['orderCode'] != "") $condition[] = ["om.orderCode", "like", "%{$param['orderCode']}%"]; if ($param['order_type'] != "") $condition[] = ["om.order_type", "=", $param['order_type']]; if ($param['is_read'] !== "") $condition[] = ["om.is_read", "=", $param['is_read']]; $count = Db::name("order_msg") ->alias('om') ->where($condition) ->count(); $total = ceil($count / $param['size']); $page = $param['page'] >= $total ? $total : $param['page']; $list = Db::name("order_msg") ->alias('om') ->field('om.*,ap.order_name,p.process_name') ->where($condition) ->leftJoin('action_process ap', 'ap.order_type=om.order_type AND ap.order_process=om.order_status') ->leftJoin('process p', 'p.id=ap.pid') ->page(intval($page), intval($param['size'])) ->order("om.addtime desc") ->select() ->toArray(); return app_show(0, "获取成功", ['list' => $list, "count" => $count]); } /** * 保存更新的资源 * * @param \think\Request $request * @param int $id * @return \think\Response */ public function update() { $id = isset($this->post['id'])&&$this->post['id']!=="" ? intval($this->post['id']) :""; if($id===""){ return error_show(1004,"参数 id 不能为空"); } $info = Db::name("order_msg")->where(["id"=>$id])->find(); if(empty($info)){ return error_show(1004,"未找到数据"); } $token = isset($this->post['token']) ? trim($this->post['token']) : ""; $apply_id = GetUserInfo($token); if (empty($apply_id) || $apply_id['code'] != 0) { return error_show(1002, "用户数据不存在"); } $type = \think\facade\Config::get("order"); $info['order_type_cn']=$type["order_type"][$info['order_type']]; $rm = isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : ""; if($rm==$info['uid'] && $info['is_read']==0){ Db::name("order_msg")->where(["id"=>$id])->save(["is_read"=>1,"updatetime"=>date("Y-m-d H:i:s")]); } return app_show(0,"获取成功",$info); } public function limit() { $id = isset($this->post['id'])&&$this->post['id']!=="" ? $this->post['id'] :[]; if(empty($id)){ return error_show(1004,"参数 id 不能为空"); } $info = Db::name("order_msg")->where(["id"=>$id])->select()->toArray(); if(empty($info)){ return error_show(1004,"未找到数据"); } $token = isset($this->post['token']) ? trim($this->post['token']) : ""; $apply_id = GetUserInfo($token); if (empty($apply_id) || $apply_id['code'] != 0) { return error_show(1002, "用户数据不存在"); } $rm = isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : ""; $read= Db::name("order_msg")->where(["id"=>$id,"uid"=>$rm])->save(["is_read"=>1,"updatetime"=>date("Y-m-d H:i:s")]); return $read?app_show(0,"已读成功"):app_show(1003,"已读失败"); } public function allread() { $token = isset($this->post['token']) ? trim($this->post['token']) : ""; $apply_id = GetUserInfo($token); if (empty($apply_id) || $apply_id['code'] != 0) { return error_show(1002, "用户数据不存在"); } $rm = isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : ""; $info = Db::name("order_msg")->where(["uid"=>$rm,"is_read"=>0])->select()->toArray(); if(empty($info)){ return error_show(1004,"暂无未读数据"); } $read=Db::name("order_msg")->where(["uid"=>$rm,"is_read"=>0])->save(["is_read"=>1,"updatetime"=>date("Y-m-d H:i:s")]); return $read?app_show(0,"全部已读成功"):app_show(1003,"全部已读失败"); } }