web_site = $this->request->server('HTTP_ORIGIN'); } /** * 获取职员列表 * @ApiMethod (POST) */ public function getSalesList() { $data = input(); $page = isset($data['page'])?$data['page']:1; $page = empty($page)?1:$page; $limit = isset($data['limit'])?$data['limit']:10; $limit = empty($limit)?10:$limit; $where = []; $keyword = isset($data['keyword'])?$data['keyword']:''; if(!empty($keyword)){ $where['men_code|name|phone'] = ['like','%'.$keyword.'%']; } $where['status'] = '1'; $list = Db::name('kuerp_staff_member') ->where($where) ->page($page,$limit) ->field('id,men_code,name,phone,FROM_UNIXTIME(updatetime,\'%Y-%m-%d %H:%i:%s\') as updatetime') ->select(); foreach ($list as $list_k=>$list_v){ $list[$list_k]['phone'] = preg_match("/^1[3-9]{1}\d{9}$/",$list_v['phone']) ? substr_replace($list_v['phone'],'****',3,4) : $list_v['phone']; } $count = Db::name('kuerp_staff_member')->where($where)->count(); $result['list'] = $list;$result['count'] = $count; $this->success('查询成功',$result,200); } /** * 获取客户列表 * @ApiMethod (POST) */ public function getCustomersList() { $data = input(); $page = isset($data['page'])?$data['page']:1; $page = empty($page)?1:$page; $limit = isset($data['limit'])?$data['limit']:10; $limit = empty($limit)?10:$limit; $where = []; $keyword = isset($data['keyword'])?$data['keyword']:''; if(!empty($keyword)){ $where['customer_code|customer_name|customer_mobile'] = ['like','%'.$keyword.'%']; } $third_account = $this->third_account; $where['third_id'] = $third_account['id']; $list = Db::name('kuerp_customers') ->where($where) ->page($page,$limit) ->field('customer_code,customer_name as name,customer_mobile as mobile,staff_member_id as saler,createtime,status') ->select(); foreach ($list as $list_k=>$list_v){ $list[$list_k]['saler'] = Db::name('kuerp_staff_member')->where(['id'=>$list_v['saler']])->value('men_code'); $list[$list_k]['createtime_text'] = date('Y-m-d H:i:s',$list_v['createtime']); } $count = Db::name('kuerp_customers')->where($where)->count(); $result['list'] = $list;$result['count'] = $count; $this->success('查询成功',$result,200); } /** * 添加客户 * @ApiMethod (POST) */ public function joinCustomers() { $detail = input(); $check = $this->checkParameter($detail,[ 'name|客户名称'=>'require', 'mobile|客户联系方式'=>'require', ]); if(isset($check['status'])){ $this->error($check['msg'],'',$check['status']); }else{ $customer_code = $this->getCodes('',1); if(empty($customer_code)){ $this->error('编号获取失败','',27); } $customer = Db::name('kuerp_customers') ->where(['customer_mobile'=>$detail['mobile']]) ->find(); if(!empty($customer)){ $this->error('此手机号已注册','',27); } //职员信息 $saler = isset($detail['saler'])?$detail['saler']:''; if($saler){ $saler_info = Db::name('kuerp_staff_member')->where(['men_code'=>$saler,'status'=>'1'])->find(); if(empty($saler_info)){ $this->error('职员不可用','',27); } } //联系人信息 $data[] = [ 'first_connect_name' => $detail['name'], 'first_connect_mobile' => $detail['mobile'], 'first_connect_phone' => '', 'qq_wx_email' => '', 'connect_address' => isset($detail['address'])?$detail['address']:'', 'is_first' => 1, 'createtime' => time(), 'updatetime' => time(), ]; $customertype = Db::name('kuerp_customertype')->where(['status'=>'1'])->order(['id'=>'DESC'])->value('id'); $third_account = $this->third_account; $customer = [ 'customer_code' => $customer_code, 'customertype_id' => $customertype, 'customerlevel_id' => 1, 'customer_name' => $detail['name'], 'connet_name' => $detail['name'], 'customer_mobile' => $detail['mobile'], 'getgoods_address' => isset($detail['address'])?$detail['address']:'', 'note' => isset($detail['note'])?$detail['note']:'', 'staff_member_id' => isset($saler_info)? (isset($saler_info['id'])?$saler_info['id']:0) :0, 'account_time' => time(), 'third_id' => $third_account['id'], 'createtime' => time(), 'updatetime' => time(), ]; $result = false; Db::startTrans(); try { $result = Db::name('kuerp_customers')->insertGetId($customer); $business_type = 5; Db::name('kuerp_sales_payment_log')->insert([ 'customers_id' => $result, 'business_type' => $business_type, 'bill_time' => $customer['account_time'], 'bill_code' => $customer['customer_code'], 'give_money' => 0, ]); foreach ($data as $data_k=>$data_v){ $data[$data_k]['customers_code'] = trim($customer['customer_code']); $data[$data_k]['sid'] = $result; } Db::name('kuerp_customers_user')->insertAll($data); Db::commit(); } catch (Exception $e) { Db::rollback(); $this->error($e->getMessage()); } if ($result !== false) { $this->success('添加成功',['id'=>$result,'customer_code'=>$customer_code],1); } else { $this->error('添加失败','',27); } } } /** * 客户详情 * @ApiMethod (POST) */ public function customersInfo() { $detail = input(); $check = $this->checkParameter($detail,[ 'mobile|电话'=>'require', ]); if(isset($check['status'])){ $this->error($check['msg'],'',$check['status']); }else{ $third_account = $this->third_account; $customer = Db::name('kuerp_customers') ->where(['customer_mobile'=>$detail['mobile'],'third_id'=>$third_account['id']]) ->field('customer_code,customer_name as name,customer_mobile as mobile,getgoods_address as address,note,staff_member_id as saler,createtime,status') ->find(); if(empty($customer)){ $this->error('未找到相关客户','',27); }elseif ($customer['status']!=1){ $this->error('此客户状态异常','',27); } $customer['saler'] = Db::name('kuerp_staff_member')->where(['id'=>$customer['saler']])->value('men_code'); $customer['createtime_text'] = date('Y-m-d H:i:s',$customer['createtime']); $this->success('查询成功',$customer,1); } } /** * 编辑客户 * @ApiMethod (POST) */ public function editCustomers() { $detail = input(); $check = $this->checkParameter($detail,[ 'code|客户编号'=>'require', 'name|客户名称'=>'require', 'mobile|客户联系方式'=>'require', ]); if(isset($check['status'])){ $this->error($check['msg'],'',$check['status']); }else{ $third_account = $this->third_account; $customer = Db::name('kuerp_customers') ->where(['customer_code'=>$detail['code'],'third_id'=>$third_account['id']]) ->find(); if(empty($customer)){ $this->error('未找到相关客户','',27); }elseif ($customer['status']!=1){ $this->error('此客户状态异常','',27); } //职员信息 $saler = isset($detail['saler'])?$detail['saler']:''; if($saler){ $saler_info = Db::name('kuerp_staff_member')->where(['men_code'=>$saler,'status'=>'1'])->find(); if(empty($saler_info)){ $this->error('职员不可用','',27); } } $address = isset($detail['address'])?$detail['address']:''; $where = []; $where['customers_code'] = $customer['customer_code']; $where['sid'] = $customer['id']; $where['first_connect_name'] = $detail['name']; $where['first_connect_mobile'] = $detail['mobile']; $where['connect_address'] = $address; $where['is_first'] = 1; $user = Db::name('kuerp_customers_user')->where($where)->find(); if(empty($user)){ //联系人信息 $data[] = [ 'customers_code' => $customer['customer_code'], 'sid' => $customer['id'], 'first_connect_name' => $detail['name'], 'first_connect_mobile' => $detail['mobile'], 'first_connect_phone' => '', 'qq_wx_email' => '', 'connect_address' => isset($detail['address'])?$detail['address']:'', 'is_first' => 1, 'createtime' => time(), 'updatetime' => time(), ]; } $customer_data = [ 'customer_name' => $detail['name'], 'connet_name' => $detail['name'], 'customer_mobile' => $detail['mobile'], 'getgoods_address' => isset($detail['address'])?$detail['address']:'', 'note' => isset($detail['note'])?$detail['note']:'', 'staff_member_id' => isset($saler_info)? (isset($saler_info['id'])?$saler_info['id']:0) :0, 'updatetime' => time(), ]; $result = false; Db::startTrans(); try { $result = Db::name('kuerp_customers')->where(['id'=>$customer['id']])->update($customer_data); if(isset($data)){ Db::name('kuerp_customers_user')->where(['sid'=>$customer['id']])->delete(); Db::name('kuerp_customers_user')->insertAll($data); } Db::commit(); } catch (Exception $e) { Db::rollback(); $this->error($e->getMessage()); } if ($result !== false) { $this->success('编辑成功','',1); } else { $this->error('编辑失败','',27); } } } /** * 注销客户 * @ApiMethod (POST) */ public function delCustomers() { $detail = input(); $check = $this->checkParameter($detail,[ 'mobile|电话'=>'require', ]); if(isset($check['status'])){ $this->error($check['msg'],'',$check['status']); }else{ $third_account = $this->third_account; $customer = Db::name('kuerp_customers') ->where(['customer_mobile'=>$detail['mobile'],'third_id'=>$third_account['id']]) ->find(); if(empty($customer)){ $this->error('未找到相关客户','',27); } $customer_name = isset($customer['customer_name'])?$customer['customer_name']:'客户'; $customers_id = $customer['id']; $order_info = Db::name('kuerp_goods_sales_info')->where(['customers_id'=>$customers_id])->value('id'); if(!empty($order_info)){ $this->error($customer_name.'已有业务数据,不可注销','',27); } $order_info = Db::name('kuerp_goods_sales_exchange_info')->where(['customers_id'=>$customers_id])->value('id'); if(!empty($order_info)){ $this->error($customer_name.'已有业务数据,不可注销','',27); } $order_info = Db::name('kuerp_warehouse')->where(['customers_id'=>$customers_id])->value('id'); if(!empty($order_info)){ $this->error($customer_name.'已有业务数据,不可注销','',27); } $order_info = Db::name('kuerp_writeoff')->where(['customers_id|customers_out_id|customers_enter_id'=>$customers_id])->value('id'); if(!empty($order_info)){ $this->error($customer_name.'已有业务数据,不可注销','',27); } $res = false; Db::startTrans(); try { $res = Db::name('kuerp_customers')->where(['id'=>['in',$customers_id]])->delete(); Db::name('kuerp_customers_user')->where(['sid'=>['in',$customers_id]])->delete(); Db::name('kuerp_writeoff_source')->where(['customers_id'=>['in',$customers_id],'type'=>3])->delete(); Db::name('kuerp_sales_payment_log')->where(['bill_code'=>['in',$customer['customer_code']],'business_type'=>['in',[5,6]]])->delete(); Db::commit(); } catch (Exception $e) { Db::rollback(); $this->error($e->getMessage(),'',27); } if($res){ $this->success('注销成功','',1); }else{ $this->error('注销失败','',27); } } } }