where($map)->order(['id'=>'desc'])->page($ppage)->limit($psize)->select(); page_result(0, "", array( 'plist' => $plist, 'pstatus' => $psize > count($plist) ? 'noMore' : 'more' )); } // 申请注册职业顾问 public function pageForm() { $param = ParamModel::where(1)->find(); page_result(0, "", array( 'param' => $param )); } public function regBroker() { $realname = input('realname/s', ""); $mobile = input('mobile/s', ""); $address = input('address/s', ""); $idcard = input('idcard/s', ""); $recommender = input('recommender/s', ""); if ( empty($realname) || empty($mobile) || empty($address) || empty($idcard) ){ page_result(1, "姓名、手机号、当前住址、身份证号均不能为空。"); } $form = new BrokerFormModel; $form->save([ 'realname' => $realname, 'mobile' => $mobile, 'address' => $address, 'idcard' => $idcard, 'recommender' => $recommender, 'status' => 1, 'remark' => "", 'createtime' => time() ]); page_result(0, "", array()); } // 报备信息 public function getOrder() { $orderid = input('orderid/d',0); $agentid = input('agentid/d',0); $order = ReportOrderModel::with(['reportFactory'])->where(['id'=>$orderid])->find(); $orderlog = ReportOrderlogModel::where(['agentid'=>$agentid,'orderid'=>$orderid])->order(['id'=>"DESC"])->select(); ReportOrderlogModel::update(['status' => 2], ['agentid'=>$agentid,'orderid'=>$orderid]); page_result(0, "", array( 'order' => $order, 'orderlog' => $orderlog )); } // 订单信息 public function listOrder() { $brokerid = input('brokerid/d',0); $broker = BrokerModel::findOrEmpty($brokerid); $agentid = $broker->agentid; $ppage = input('ppage/d', 1); $psize = input('psize/d', 20); $map = array(); $map[] = ['ReportOrder.status', '>', 1]; $plist = ReportOrderModel::hasWhere('reportOrderlog',['agentid'=>$agentid])->with(['reportFactory'])->where($map)->order(['status'=>'ASC','id'=>'DESC'])->page($ppage)->limit($psize)->select()->toArray(); foreach($plist as $key=>$val){ $plist[$key]['log'] = ReportOrderlogModel::where(['agentid'=>$agentid,'orderid'=>$val['id']])->order(['id'=>'DESC'])->findOrEmpty()->toArray(); } page_result(0, "", array( 'plist' => $plist, 'pstatus' => $psize > count($plist) ? 'noMore' : 'more' )); } // 数据信息 public function pageBroker() { $brokerid = input('brokerid/d', 0); $stime = strtotime(date("Y-m-d"),time()); $tuserCount = UserModel::where('brokerid', '=', $brokerid)->where('createtime','between',[$stime,$stime+86400])->count(); $userCount = UserModel::where('brokerid', '=', $brokerid)->count(); $tentryCount = ReportEntryModel::where('brokerid', '=', $brokerid)->where('createtime','between',[$stime,$stime+86400])->count(); $entryCount = ReportEntryModel::where('brokerid', '=', $brokerid)->count(); page_result(0, "", array('countobj' => array( 'tuser' => $tuserCount, 'user' => $userCount, 'tentry' => $tentryCount, 'entry' => $entryCount ))); } // 报备信息 public function getEntry() { $entryid = input('entryid/d',0); $brokerid = input('brokerid/d',0); $entry = ReportEntryModel::with(['reportFactory'])->where(['brokerid'=>$brokerid,'id'=>$entryid])->find(); $broker = BrokerModel::with('agent')->findOrEmpty($brokerid); $factorylist = ReportFactoryModel::order(['priority'=>'desc','id'=>'desc'])->select()->toArray(); $factoryidarr = ReportFactoryModel::order(['priority'=>'desc','id'=>'desc'])->column('title'); page_result(0, "", array( 'entry' => $entry, 'broker' => $broker, 'factorylist' => $factorylist, 'factoryidarr' => array_values($factoryidarr), 'today' => date("Y-m-d") )); } public function statusEntry() { $entryid = input('entryid/d',0); $brokerid = input('brokerid/d',0); $entry = ReportEntryModel::with(['reportFactory'])->where('brokerid','=',$brokerid)->findOrEmpty($entryid); if ($entry->isEmpty()){ page_result(1, "报备信息不存在。"); } if ($entry->status > 1){ page_result(1, "报备信息已确认过。"); } $entry->save(['status'=>2]); page_result(0, "", array( 'entry' => $entry )); } public function deleteEntry() { $entryid = input('entryid/d',0); $brokerid = input('brokerid/d',0); $entry = ReportEntryModel::with(['reportFactory'])->where('brokerid','=',$brokerid)->findOrEmpty($entryid); if ($entry->isEmpty()){ page_result(1, "报备信息不存在。"); } if ($entry->status > 1){ page_result(1, "报备信息已确认过,不能删除。"); } $entry->delete(); page_result(0, "", array()); } public function addEntry() { $brokerid = input('brokerid/d',0); $broker = BrokerModel::with('agent')->findOrEmpty($brokerid); if ($broker->isEmpty()){ page_result(1, "职业顾问信息不存在。"); } $data = array( 'workerid' => $broker->workerid, 'agentid' => $broker->agentid, 'brokerid' => $brokerid, 'factoryid' => input('factoryid/d', 0), 'realname' => input('realname/s', ""), 'mobile' => input('mobile/s', ""), 'idcard' => input('idcard/s', ""), 'gender' => input('gender/s', ""), 'nation' => input('nation/s', ""), 'address' => input('address/s', ""), 'startdate' => input('startdate/s', ""), 'enddate' => input('enddate/s', ""), 'reftype' => input('reftype/s', ""), 'refpolicy' => input('refpolicy/s', ""), 'agentremark' => input('agentremark/s', ""), 'status' => input('status/d', ""), 'remark' => "", 'createtime' => time() ); $entry = new ReportEntryModel; $entry->save($data); $newentry = ReportEntryModel::with(['reportFactory'])->where('brokerid','=',$brokerid)->find($entry->id); page_result(0, "", array( 'entry' => $newentry )); } public function setIdcard() { $picpath = input('picpath/s',""); $picpath = root_path()."public".$picpath; $idcard = aliyun_ocr_idcard( $picpath ); if ($idcard==false){ page_result(1, "身份证信息识别失败。"); } page_result(0, "", array( 'idcard' => $idcard )); } public function pageEntry() { $brokerid = input('brokerid/d',0); $statuslist = array( array('value'=>"", 'title'=>'状态不限'), array('value'=>1, 'title'=>'待确认'), array('value'=>2, 'title'=>'已确认'), array('value'=>3, 'title'=>'已入职'), array('value'=>4, 'title'=>'未通过') ); $factorylist = ReportFactoryModel::field('id as value, title, priority')->order(['priority'=>'desc','id'=>'desc'])->select()->toArray(); array_unshift($factorylist, array('value'=>"", 'title'=>'工厂不限')); page_result(0, "", array( 'statuslist' => $statuslist, 'factorylist' => $factorylist )); } public function listEntry() { $ppage = input('ppage/d', 1); $psize = input('psize/d', 20); $map = array(); $brokerid = input('brokerid/d', 0); $map[] = ['brokerid', '=', $brokerid]; $status = input('status/d', 0); if (!empty($status)){ $map[] = ['status', '=', $status]; } $factoryid = input('factoryid/d', 0); if (!empty($factoryid)){ $map[] = ['factoryid', '=', $factoryid]; } $searchval = input('searchval/s', ""); if (!empty($searchval)){ $map[] =['realname|mobile', 'like', '%'.$searchval.'%', 'OR']; } $plist = ReportEntryModel::with(['reportFactory'])->where($map)->order(['id'=>'desc'])->page($ppage)->limit($psize)->select(); page_result(0, "", array( 'plist' => $plist, 'pstatus' => $psize > count($plist) ? 'noMore' : 'more' )); } // 我的邀请 public function getMyuser() { $userid = input('userid/d',0); $brokerid = input('brokerid/d',0); $user = UserModel::with(['userFollow'])->where('brokerid','=',$brokerid)->findOrEmpty($userid); if ($user->isEmpty()){ page_result(1, "用户信息不存在"); } page_result(0, "", array( 'user' => $user, )); } public function sendFollow() { $userid = input('userid/d',0); $ftype = input('ftype/s',""); $remark = input('remark/s',""); if (empty($remark)){ page_result(1, "请输入跟进的具体内容。"); } $followstatus = input('followstatus/d',1); UserModel::update(['followstatus'=>$followstatus],['id'=>$userid]); $data = array( 'userid' => $userid, 'ftype' => $ftype, 'remark' => $remark, 'createtime' => time() ); $follow = new UserFollowModel; $follow->save($data); $user = UserModel::with(['userFollow'])->findOrEmpty($userid); page_result(0, "", array( 'user' => $user, )); } public function listUser() { $ppage = input('ppage/d', 1); $psize = input('psize/d', 20); $map = array(); $brokerid = input('brokerid/d', 0); $map[] = ['brokerid', '=', $brokerid]; $followstatus = input('followstatus/d', 0); if (!empty($followstatus)){ $map[] = ['followstatus', '=', $followstatus]; } $plist = UserModel::with(['userFollow'])->where($map)->order(['id'=>'desc'])->page($ppage)->limit($psize)->select(); page_result(0, "", array( 'plist' => $plist, 'pstatus' => $psize > count($plist) ? 'noMore' : 'more' )); } }