$val) { $data = []; foreach ($val as $index => $item) { $data[] = ['text' => $item, 'value' => $index]; } $options['visit_type'][$key] = $data; } } return $options; } /** * Notes: 客户列表 * User: yb * Date: 2024/8/12 * Time: 11:08 * @param $params */ public static function index($params) { $page = $params['page'] ?? 1; $size = $params['size'] ?? 10; //查询顾问信息 $consultantId = JwtToken::getCurrentId(); $consultantInfo = Consultant::firstWhere(['id' => $consultantId]); $deptId = $consultantInfo->dept_id; $type = $consultantInfo->type; $currentTime = time(); $diffNums = self::DIFF_TIME; $where = [ [function($query) use ($diffNums, $currentTime){ $query->orWhereRaw("check_status IN (-1, 1)") ->orWhereRaw("check_status = 2 AND current_status IN (-1,3,4)") ->orWhereRaw("((visit_time + {$diffNums}) - {$currentTime} > 0 AND current_status = 2 AND check_status = 2)"); }] ]; $whereFollow = []; if ($type == 1) { //团队下所有的 $deptIds = TeamService::getIds($deptId); $where[] = [function($query) use ($deptIds) { $query->whereIn('dept_id', $deptIds); }]; if (!empty($params['consultant_id'])) { $consultantId = $params['consultant_id']; $where[] = [function($query) use ($consultantId) { $query->orWhere('consultant_id', $consultantId)->orWhere('report_consultant_id', $consultantId); }]; $whereFollow[] = ['consultant_id', '=', $params['consultant_id']]; } else { $consultantIds = UserService::getIds(1); $whereFollow[] = [function($query) use ($consultantIds) { $query->whereIn('consultant_id', $consultantIds); }]; } } else if ($type == 2){ //个人的 $where[] = [function($query) use ($consultantId){ $query->orWhere('consultant_id', $consultantId)->orWhere('report_consultant_id', $consultantId); }]; $whereFollow[] = ['consultant_id', '=', $consultantId]; } else { //所有团队的 } if (!empty($params['custom'])) { $keywords = $params['custom']; $where[] = [function($query) use ($keywords) { $query->orWhere('name', 'like', "%{$keywords}%")->orWhere('mobile', 'like', "%{$keywords}%"); }]; } if (!empty($params['report_status'])) { if ($params['report_status'] == 1) { //已报备 $where[] = [function($query) use ($diffNums, $currentTime) { $query->whereRaw("((visit_time + {$diffNums}) - {$currentTime} > 0)")->where('current_status', '=', 1)->where('check_status', '=', 2); }]; } else if ($params['report_status'] == 3) { //已锁定 $where[] = [function($query) { $query->whereIn('current_status', [2,3,4])->where('check_status', '=', 2); }]; } else if ($params['report_status'] == 2) { //已失效 $where[] = [function($query) use ($diffNums, $currentTime){ $query->orWhere('current_status', '=', -1)->orWhereRaw("((visit_time + {$diffNums}) - {$currentTime} <= 0 AND current_status = 1)"); }]; $where[] = ['check_status', '=', 2]; } else if ($params['report_status'] == '-1') { //待审核 $where[] = ['check_status', '=', 1]; } } if (!empty($params['check_status'])) { $where[] = ['check_status', '=', $params['check_status']]; } if (!empty($params['type'])) { $where[] = ['type', '=', $params['type']]; } if (!empty($params['visit_time'])) { $datetime = $params['visit_time']; $startTime = strtotime($datetime['start'].' 00:00:00'); $endTime = strtotime($datetime['end'].' 23:59:59'); $where[] = [function($query) use ($startTime, $endTime) { $query->whereBetween('visit_time', [$startTime, $endTime]); }]; } if (!empty($params['current_status'])) { $currentStatus = $params['current_status']; $where[] = [function($query) use ($currentStatus) { $query->where('current_status', $currentStatus); }]; } if (!empty($params['created_at'])) { $createdAt = $params['created_at']; if (is_array($createdAt)) { $createdAtStart = strtotime($createdAt[0]); $createdAtEnd = strtotime($createdAt[1]); } else { //本月开始和结束 $createdAtStart = strtotime(date('Y-m-01 00:00:00')); $createdAtEnd = strtotime(date('Y-m-t 23:59:59')); } $where[] = [function($query) use ($createdAtStart,$createdAtEnd) { $query->whereBetween('created_at', [$createdAtStart, $createdAtEnd]); }]; } $fn = function ($query) { $query->select('name', 'mobile', 'id', 'dept_id'); }; $paginator = MarketCustomer::with(['consultant' => $fn, 'report' => $fn])->where($where)->orderBy('visit_time', 'desc')->paginate($size, '*', 'page', $page); $total = $paginator->total(); $items = $paginator->items(); if (!empty($items)) { //查询所有团队信息 $teamKeys = TeamService::getTeams()->pluck('dept_name', 'dept_id'); $now = time(); foreach ($items as &$item) { $item->mask_mobile = self::handlePhone($item->mobile); $visitTimeInt = strtotime($item->visit_time); $endTime = $visitTimeInt + 60 * 60 * 24 * 30; $visitTimeInt = $endTime - $now; if ($visitTimeInt <= 0) { $visitTimeInt = 0; } if (!empty($item->consultant)) { $item->consultant->dept_name = $teamKeys[$item->consultant->dept_id] ?? ''; } if (!empty($item->report)) { $item->report->dept_name = $teamKeys[$item->report->dept_id] ?? ''; } $item->visit_time_int = $visitTimeInt; } } //本日新增 // $date = date('Y-m-d'); // $start = strtotime($date.' 00:00:00'); // $end = strtotime($date.' 23:59:59'); // $newNums = MarketCustomer::where($where)->whereBetween('created_at', [$start, $end])->count(); // $followNums = MarketCustomerFollow::where($whereFollow)->whereBetween('created_at', [$start, $end])->count(); $data = [ 'new_follow_num' => $followNums ?? 0, 'new_custom_num' => $newNums ?? 0, 'total' => $total, 'rows' => $items ]; return json_success('success', $data); } /** * Notes: 我的客户 * User: yb * Date: 2024/8/13 * Time: 15:14 * @param $params */ public static function myCustomList($params) { $currentTime = time(); $diffNums = self::DIFF_TIME; $page = $params['page'] ?? 1; $size = $params['size'] ?? 10; //查询有效顾问信息 $consultantId = JwtToken::getCurrentId(); $where = [ ['consultant_id', '=', $consultantId], ['current_status', '<>', '-1'], ['check_status', '<>', '-1'] ]; $where[] = [function($query) use ($diffNums, $currentTime){ $query->orWhereRaw("check_status IN (-1, 1)") ->orWhereRaw("check_status = 2 AND current_status IN (-1,3,4)") ->orWhereRaw("((visit_time + {$diffNums}) - {$currentTime} > 0 AND current_status = 2 AND check_status = 2)"); }]; if (!empty($params['custom'])) { $keywords = $params['custom']; $where[] = [function($query) use ($keywords) { $query->orWhere('name', 'like', "%{$keywords}%")->orWhere('mobile', 'like', "%{$keywords}%"); }]; } $paginator = MarketCustomer::where($where)->orderBy('created_at', 'desc')->paginate($size, ['id','name','mobile','gender'], 'page', $page); $total = $paginator->total(); $items = $paginator->items(); if (!empty($items)) { foreach ($items as &$item) { $item->mask_mobile = self::handlePhone($item->mobile); } } $data = [ 'total' => $total, 'rows' => $items ]; return json_success('success', $data); } /** * Notes: 添加客户 * User: yb * Date: 2024/8/6 * Time: 11:20 */ public static function add($params) { $params = MarketCustomer::handleNumParams($params); $mobile = $params['mobile']; //查询客户手机号是否已经存在 if (MarketCustomer::checkCustomExists($mobile)) { return json_fail('客户已经到访'); } //查询顾问信息 $consultantId = JwtToken::getCurrentId(); $consultantInfo = Consultant::firstWhere(['id' => $consultantId]); if (empty($consultantInfo)) { return json_fail('顾问信息不存在'); } $deptId = $consultantInfo->dept_id; $insertData = [ 'name' => $params['name'], 'mobile' => $mobile, 'consultant_id' => 0, 'report_consultant_id' => $consultantId, 'create_consultant_id' => $consultantId, 'dept_id' => $deptId, 'gender' => $params['gender'] ?? null, 'visit_type' => $params['visit_type'] ?? null, 'require_area' => $params['require_area'] ?? null, 'area' => $params['area'] ?? null, 'requirement' => $params['requirement'] ?? null, 'age_range' => $params['age_range'] ?? null, 'focus' => $params['focus'] ?? null, 'region' => $params['region'] ?? null, 'purpose' => $params['purpose'] ?? null, 'level' => $params['level'] ?? null, 'type' => $params['type'] ?? null, 'visit_time' => time(), 'note' => $params['note'] ?? '', 'check_status' => 1, 'current_status' => 1, 'belong_status' => 1, 'created_at' => time() ]; Db::beginTransaction(); try { $customId = MarketCustomer::insertGetId($insertData); Db::commit(); }catch (BusinessException|\Exception $e){ Db::rollBack(); return json_fail($e->getMessage()); } if ($customId) { return json_success('添加成功'); } else { return json_fail('添加失败'); } } /** * Notes: 编辑客户 * User: yb * Date: 2024/8/12 * Time: 10:23 * @param $params * @return \support\Response */ public static function edit($params) { $consultantId = JwtToken::getCurrentId(); $params = MarketCustomer::handleNumParams($params); if (empty($params['id'])) { return json_fail('客户id不能为空'); } $consultantInfo = Consultant::firstWhere(['id' => $consultantId]); if (empty($consultantInfo)) { return json_fail('顾问信息不存在'); } $info = MarketCustomer::firstWhere(['id' => $params['id'], 'consultant_id' => $consultantId]); if (empty($info)) { return json_fail('客户信息不存在'); } $updateData = [ 'name' => $params['name'], 'gender' => $params['gender'] ?? null, 'visit_type' => $params['visit_type'] ?? null, 'require_area' => $params['require_area'] ?? null, 'area' => $params['area'] ?? null, 'requirement' => $params['requirement'] ?? null, 'age_range' => $params['age_range'] ?? null, 'focus' => $params['focus'] ?? null, 'region' => $params['region'] ?? null, 'purpose' => $params['purpose'] ?? null, 'level' => $params['level'] ?? null, 'type' => $params['type'] ?? null, 'note' => $params['note'] ?? '', 'updated_at' => time() ]; if (empty($params['mobile'])) { return json_fail('手机号不能为空'); } $mobile = $params['mobile']; if (false === strpos($mobile,'****')) { //校验手机号格式 $validate = new CustomValidate(); if (!$validate->scene('phone')->check(['mobile' => $mobile])) { return json_fail($validate->getError()); } //修改手机号操作 if (MarketCustomer::checkCustomExists($mobile, $params['id'])) { return json_fail('客户已经登记过了'); } $updateData['mobile'] = $mobile; } $currentStatus = $info->current_status; if ($currentStatus == 1) { //已来电改为已到访 if ($params['type'] == 2) { $updateData['current_status'] = 2; } } $result = false; Db::beginTransaction(); try { $result = MarketCustomer::where('id', $params['id'])->update($updateData); Db::commit(); }catch (BusinessException|\Exception $e){ Db::rollBack(); return json_fail($e->getMessage()); } if ($result) { return json_success('编辑成功'); } else { return json_fail('编辑失败'); } } /** * Notes: 客户详情 * User: yb * Date: 2024/8/8 * Time: 15:36 * @param $params */ public static function info($id) { $fn = function ($query) { $query->select('name', 'mobile', 'id', 'dept_id'); }; $customInfo = MarketCustomer::with(['consultant' => $fn, 'report' => $fn])->firstWhere(['id' => $id]); if (empty($customInfo)) { return json_fail('客户不存在'); } $teamKeys = TeamService::getTeams()->pluck('dept_name', 'dept_id'); if (!empty($customInfo->consultant)) { $customInfo->consultant->dept_name = $teamKeys[$customInfo->consultant->dept_id] ?? ''; } if (!empty($customInfo->report)) { $customInfo->report->dept_name = $teamKeys[$customInfo->report->dept_id] ?? ''; } //手机号加密处理 $customInfo->mask_mobile = self::handlePhone($customInfo->mobile); //查询最新的跟进记录 $follow = MarketCustomerFollow::where('market_customer_id', $id)->orderBy('created_at', 'desc')->first(); $customInfo->follow = $follow; $focus = $customInfo->focus; if (!empty($focus)) { $customInfo->focus = explode(',', $focus); } return json_success('', $customInfo); } /** * Notes: 更新客户状态 * User: yb * Date: 2024/8/14 * Time: 13:23 * @param $params */ public static function updateStatus($params) { $customId = $params['id']; $currentStatus = $params['current_status']; if (!in_array($currentStatus, [-1, 2, 3, 4])) { return json_fail('状态值非法'); } $info = MarketCustomer::firstWhere(['id' => $customId]); if (empty($info)) { return json_fail('客户不存在'); } if ($info->current_status != 1) { return json_fail('客户非已报备状态'); } if ($currentStatus >= 2) { //验证是否已经存在其他到访客户 if (MarketCustomer::checkCustomExists($info->mobile)) { return json_fail('操作失败,客户已存在'); } } Db::beginTransaction(); $result = false; try { if ($currentStatus == 2) { $info->visit_time = time(); } $info->current_status = $currentStatus; $result = $info->save(); if ($result) { if ($currentStatus >= 2) { $where = [ ['id', '<>', $customId] ]; //将其他的改为无效客户 MarketCustomer::where($where)->where('check_status', 2)->update(['current_status' => -1]); //将待审核的改为拒绝 MarketCustomer::where($where)->where('check_status', 1)->update(['check_status' => -1, 'check_note' => self::CHECK_NOTE]); } } Db::commit(); }catch (BusinessException|\Exception $e){ Db::rollBack(); return json_fail($e->getMessage()); } if ($result) { return json_success('操作成功'); } else { return json_fail('操作失败'); } } /** * Notes: 指定顾问 * User: yb * Date: 2024/9/5 * Time: 12:52 * @param $params */ public static function appoint($params) { if (empty($params['id'])) { return json_fail('请选择客户'); } if (empty($params['report_consultant_id'])) { return json_fail('请选择指定顾问'); } $userId = JwtToken::getCurrentId(); //获取绑定的管理信息 $userInfo = Consultant::firstWhere(['id' => $userId]); if (empty($userInfo)) { return json_fail('管理员信息不存在'); } if (!in_array($userInfo->type, [1,3])) { return json_fail('操作权限不足'); } $relationUserId = $userInfo->relation_user_id; $customId = $params['id']; $reportConsultantId = $params['report_consultant_id']; $customInfo = MarketCustomer::firstWhere(['id' => $customId]); if (empty($customInfo)) { return json_fail('客户信息不存在'); } $consultantInfo = Consultant::firstWhere(['id' => $reportConsultantId]); if (empty($consultantInfo)) { return json_fail('顾问信息不存在'); } $currentDeptId = $consultantInfo->dept_id; //当前部门 $now = time(); $logData = [ 'market_customer_id' => $customId, 'consultant_id' => $reportConsultantId, 'dept_id' => $currentDeptId, 'before_consultant_id' => $customInfo->consultant_id, 'before_dept_id' => $customInfo->dept_id, 'note' => $params['note'] ?? '判客指定报备顾问', 'change_user_id' => $relationUserId, 'change_consultant_id' => $userId, 'created_at' => $now ]; Db::beginTransaction(); $result = false; try { $customInfo->report_consultant_id = $reportConsultantId; $customInfo->dept_id = $currentDeptId; $result = $customInfo->save(); MarketCustomerLogs::insert($logData); Db::commit(); }catch (BusinessException|\Exception $e) { Db::rollBack(); return json_fail($e->getMessage()); } if ($result) { return json_success('指定成功'); } else { return json_fail('指定失败'); } } /** * Notes: 转移客户 * User: yb * Date: 2024/8/7 * Time: 14:27 * @param $params */ public static function moveCustom($params) { $userId = JwtToken::getCurrentId(); //获取绑定的管理信息 $userInfo = Consultant::firstWhere(['id' => $userId]); if (empty($userInfo)) { return json_fail('管理员信息不存在'); } if (!in_array($userInfo->type, [1,3])) { return json_fail('操作权限不足'); } $relationUserId = $userInfo->relation_user_id; $currentConsultantId = $params['consultant_id']; //当前顾问 $consultantId = $params['move_consultant_id'] ?? 0; $customId = $params['move_market_customer_id'] ?? 0; $note = $params['note'] ?? ''; $consultantInfo = Consultant::firstWhere(['id' => $currentConsultantId]); if (empty($consultantInfo)) { return json_fail('接收成员不存在'); } $currentDeptId = $consultantInfo->dept_id; //当前部门 $logsInertData = []; $now = time(); $whereCustom = []; if (!empty($customId)) { $whereCustom[] = ['id', '=', $customId]; } if (!empty($consultantId)) { $whereCustom[] = ['consultant_id', '=', $consultantId]; } $customList = MarketCustomer::where($whereCustom)->select(['id','consultant_id','dept_id'])->get(); if (!$customList->isEmpty()) { foreach ($customList as$item) { $logsInertData[] = [ 'market_customer_id' => $item->id, 'consultant_id' => $currentConsultantId, 'dept_id' => $currentDeptId, 'before_consultant_id' => $item->consultant_id, 'before_dept_id' => $item->dept_id, 'note' => $note, 'change_user_id' => $relationUserId, 'change_consultant_id' => $userId, 'created_at' => $now ]; } } if ($customList->isEmpty()) { return json_fail('成员没有客户记录'); } if (empty($logsInertData)) { return json_fail('移交记录不能为空'); } Db::beginTransaction(); $result = false; try { foreach ($customList as $item) { $item->consultant_id = $currentConsultantId; $item->dept_id = $currentDeptId; $item->save(); } $result = MarketCustomerLogs::insert($logsInertData); Db::commit(); }catch (BusinessException|\Exception $e) { Db::rollBack(); return json_fail($e->getMessage()); } if ($result) { return json_success('移交成功'); } else { return json_fail('移交失败'); } } /** * Notes: 转移记录 * User: yb * Date: 2024/8/7 * Time: 15:33 * @param $params */ public static function moveLogs($params) { $page = $params['page'] ?? 1; $size = $params['size'] ?? 10; $where = []; if (!empty($params['custom_id'])) { $where[] = ['market_customer_id', '=', $params['custom_id']]; } $selectFn = function ($query){ $query->select('name', 'mobile', 'id'); }; $paginator = MarketCustomerLogs::with(['custom' => $selectFn, 'beforeMan' => $selectFn, 'currentMan' => $selectFn]) ->where($where) ->orderBy('created_at', 'desc') ->paginate($size, '*', 'page', $page); $total = $paginator->total(); $items = $paginator->items(); $data = [ 'total' => $total, 'rows' => $items ]; return json_success('success', $data); } /** * Notes: 审核客户 * User: yb * Date: 2024/8/16 * Time: 11:21 * @param $params */ public static function checkCustom($params) { $userId = JwtToken::getCurrentId(); $adminId = Consultant::where('id', '=', $userId)->value('relation_user_id'); //查询客户是否已经存在 $customId = $params['id']; $checkStatus = $params['check_status']; if (!in_array($checkStatus, [-1,2])) { return json_fail('状态值非法'); } $info = MarketCustomer::firstWhere(['id' => $customId]); if (empty($info)) { return json_fail('客户不存在'); } $status = $info->check_status; if ($status != 1) { return json_fail('客户不是待转状态'); } $mobile = $info->mobile; if ($checkStatus == 2) { if (MarketCustomer::checkCustomExists($mobile)) { return json_fail('客户已经存在'); } } $consultantId = $params['consultant_id']; $result = false; Db::beginTransaction(); try { $info->check_status = $checkStatus; if ($checkStatus == -1) { //拒绝录入拒绝理由 $info->check_note = $params['note'] ?? '无拒绝理由'; } $info->consultant_id = $consultantId; $info->current_status = $checkStatus; $info->check_time = time(); $info->check_admin_id = $adminId; $info->check_consultant_id = $userId; $result = $info->save(); if ($checkStatus == 2) { //将其他待审的相同手机号的改拒绝 $where = [ ['mobile' , '=', $mobile], ['check_status', '=', 1], ['id', '<>', $customId] ]; MarketCustomer::where($where)->update(['current_status' => -1, 'check_time' => time(),'check_status' => -1,'check_note' => self::CHECK_NOTE]); } Db::commit(); }catch (BusinessException|\Exception $e){ Db::rollBack(); return json_fail($e->getMessage()); } if ($result) { return json_success('审核成功'); } else { return json_fail('审核失败'); } } /** * Notes: 检查客户是否已经登记 * User: yb * Date: 2024/8/21 * Time: 9:40 * @param $params * @return \support\Response */ public static function checkPhone($params) { if (empty($params['mobile'])) { return json_fail('请输入联系电话'); } $mobile = $params['mobile']; //添加和编辑 if (!empty($params['id'])) { //编辑的情况 if (false === strpos($mobile,'****')) { //校验手机号格式 $validate = new CustomValidate(); if (!$validate->scene('phone')->check(['mobile' => $mobile])) { return json_fail($validate->getError()); } //修改手机号操作 if (MarketCustomer::checkCustomExists($mobile, $params['id'])) { return json_fail('客户已经登记过了'); } } return json_success('请求成功',['is_ex' => 2]); } else { $validate = new CustomValidate(); if (!$validate->scene('phone')->check(['mobile' => $mobile])) { return json_fail($validate->getError()); } //添加 $result = MarketCustomer::checkCustomExists($mobile); if ($result) { $isEx = 1; } else { $isEx = 2; } return json_success('请求成功',['is_ex' => $isEx]); } } /** * Notes: 对手机号加密处理 * User: yb * Date: 2024/8/8 * Time: 15:41 * @param $val * @return string|string[] */ public static function handlePhone($val) { return substr_replace($val, '****', 3, 4); } /** * Notes: 处理拜访时间 * User: yb * Date: 2024/8/8 * Time: 16:06 * @param $val * @return float|int */ protected static function handleVisitTime($val) { return (strtotime($val) * 1000); } }