odd_job/app/admin/controller/Agent.php

<?php
namespace app\admin\controller;

use app\admin\BaseController;
use app\common\model\User as UserModel;
use app\common\model\Worker as WorkerModel;
use app\common\model\Agent as AgentModel;
use app\common\model\AgentForm as AgentFormModel;
use app\common\model\Broker as BrokerModel;

use app\common\validate\Agent as AgentValidate;
use think\exception\ValidateException;
use think\facade\Db;

class Agent extends BaseController
{
	
	public function agentList()
	{ 
		$workerlist = WorkerModel::order(['id'=>'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
		)));
	}
	
	
	

}