'desc'])->select(); return view('agent/agentlist',[ 'workerlist' => $workerlist ]); } public function agentForm() { $id = input('id/d, 0'); $agent = AgentModel::with(['muser'])->findOrEmpty($id); $workerlist = WorkerModel::order(['id'=>'desc'])->select(); return view('agent/agentform',[ 'workerlist' => $workerlist, 'agent' => $agent ]); } public function editAgent() { $id = input('id/d'); $vdata = array( 'id' => $id, 'loginname' => input('loginname/s', ""), 'idnumber' => input('idnumber/s', "") ); try { validate(AgentValidate::class)->check($vdata); } catch (ValidateException $e) { exit(json_encode(array( 'code' => 1, 'msg' => $e->getError() ))); } $muser = UserModel::where(['mobile'=>input('musermobile/s', '')])->findOrEmpty(); if ($muser->isEmpty()){ exit(json_encode(array( 'code' => 1, 'msg' => "关联的用户不存在。" ))); } $data = [ 'userid' => $muser->id, 'workerid' => input('workerid/d', 0), 'loginname' => input('loginname/s', ""), 'idnumber' => input('idnumber/s', ""), 'title' => input('title/s', ""), 'tilpic' => input('tilpic/s', ""), 'picall' => input('picall/a', array()), 'realname' => input('realname/s', ""), 'mobile' => input('mobile/s', ""), 'telephone' => input('telephone/s', ""), 'latitude' => input('latitude/f', 0.00), 'longitude' => input('longitude/f', 0.00), 'province' => input('province/s', ""), 'city' => input('city/s', ""), 'district' => input('district/s', ""), 'address' => input('address/s', ""), 'details' => input('details/s', ""), 'priority' => input('priority/d', 0), 'remark' => input('remark/s', ""), 'status' => input('status/d', 0) ]; $password = input('password/s', ""); if (empty($id)){ $data['password'] = empty($password) ? md5("123456789") : md5($password); $data['createtime'] = time(); $agent = AgentModel::create($data); }else{ if (!empty($password)){ $data['password'] = md5($password); } $agent = AgentModel::find($id); $agent->save($data); } BrokerModel::update([ 'workerid' => input('workerid/d', 0) ],['agentid'=>$agent->id]); exit(json_encode(array( 'code' => 0 ))); } public function fieldAgent() { $id = input('id/d',0); $info = AgentModel::findOrEmpty($id); if ($info->isEmpty()){ exit(json_encode(array( 'code' => 1, 'msg' => "信息不存在" ))); }else{ $info->save([ input('field/s') => input('value/s', "") ]); } exit(json_encode(array( 'code' => 0 ))); } public function delAgent() { $access_admin = session('access_admin'); $password = input('password'); if ( $access_admin['password'] !== md5($password) ){ exit(json_encode(array( 'code' => 1, 'msg' => "操作密码验证失败" ))); } $idarr = input('idarr/a'); $result = Db::name('agent')->whereIn('id',$idarr)->update(['deletetime'=>time()]); if ($result){ exit(json_encode(array( 'code' => 0, 'msg' => "" ))); } exit(json_encode(array( 'code' => 1, 'msg' => "删除失败,请稍后重试" ))); } public function listAgent() { $limit = input('limit'); $page = input('page'); $map = array(); $keywords = input('keywords/s'); if (!empty($keywords)){ $map[] =['idnumber', 'like', '%'.$keywords.'%']; } $workerid = input('workerid/d'); if (!empty($workerid)){ $map[] = ['workerid', '=', $workerid]; } $status = input('status/d'); if (!empty($status)){ $map[] = ['status', '=', $status]; } $list = AgentModel::with(['worker','muser'])->where($map)->order(['priority'=>'DESC','id'=>'DESC'])->limit($limit)->page($page)->append(['status_text'])->select(); $count = AgentModel::where($map)->count(); if ($count==0){ exit(json_encode(array( 'code' => 1, 'msg' => "未查询到数据" ))); } exit(json_encode(array( 'code' => 0, 'msg' => "", 'count' => $count, 'data' => $list ))); } // 申请注册经纪人 public function fagentList() { return view('agent/fagentlist'); } public function fagentForm() { $id = input('id/d, 0'); $fagent = AgentFormModel::findOrEmpty($id); return view('agent/fagentform',[ 'fagent' => $fagent ]); } public function editFagent() { $id = input('id/d'); $fagent = AgentFormModel::findOrEmpty($id); $fagent->save([ 'realname' => input('realname/s', ""), 'mobile' => input('mobile/s', ""), 'address' => input('address/s', ""), 'idcard' => input('idcard/s', ""), 'recommender' => input('recommender/s', ""), 'status' => input('status/d', 1), 'remark' => input('remark/s', ""), 'createtime' => input('createtime/s', ""), ]); exit(json_encode(array( 'code' => 0 ))); } public function fieldFagent() { $id = input('id/d',0); $info = AgentFormModel::findOrEmpty($id); if ($info->isEmpty()){ exit(json_encode(array( 'code' => 1, 'msg' => "信息不存在" ))); }else{ $info->save([ input('field/s') => input('value') ]); } exit(json_encode(array( 'code' => 0 ))); } public function delFagent() { $idarr = input('idarr/a'); $fagent = AgentFormModel::whereIn('id',$idarr)->select(); $result = $fagent->delete(); if ($result){ exit(json_encode(array( 'code' => 0, 'msg' => "" ))); } exit(json_encode(array( 'code' => 1, 'msg' => "删除失败,请稍后重试" ))); } public function listFagent() { $limit = input('limit'); $page = input('page'); $map = array(); $keywords = input('keywords/s'); if (!empty($keywords)){ $map[] =['realname|mobile', 'like', '%'.$keywords.'%']; } $status = input('status/d'); if (!empty($status)){ $map[] = ['status', '=', $status]; } $list = AgentFormModel::where($map)->order('id','DESC')->limit($limit)->page($page)->append(['status_text'])->select(); $count = AgentFormModel::where($map)->count(); if ($count==0){ exit(json_encode(array( 'code' => 1, 'msg' => "未查询到数据" ))); } exit(json_encode(array( 'code' => 0, 'msg' => "", 'count' => $count, 'data' => $list ))); } }