access_agent['id']; $limit = input('limit/d', 20); $page = input('page/d', 1); $map = []; $map[] = ['agentid', '=', $agentid]; $map[] = ['is_partner', '=', 1]; $keywords = input('keywords/s'); if (!empty($keywords)) { $map[] = ['title', 'like', '%' . $keywords . '%']; } $status = input('status/d'); if (!empty($status)) { $map[] = ['status', '=', $status]; } $list = BrokerModel::with(['agent', 'muser']) ->withCount(['user']) ->where($map) ->order('id', 'DESC') ->limit($limit) ->page($page) ->append(['status_text']) ->select(); $count = BrokerModel::where($map)->count(); if ($count == 0) { exit(json_encode([ 'code' => 1, 'msg' => "未查询到数据", ])); } foreach ($list as $v) { $broker_ids = BrokerModel::where('pid', $v['id'])->column('id'); if (empty($broker_ids)) { $broker_ids = [$v['id']]; } else { $broker_ids[] = $v['id']; } $v['group_income'] = BrokerModel::whereIn('id', $broker_ids)->sum('income'); $v['group_income_total'] = BrokerModel::whereIn('id', $broker_ids)->sum('income_total'); $v['user_count'] = UserModel::whereIn('brokerid', $broker_ids)->count(); $v['below_count'] = BrokerModel::where('pid', $v['id'])->count(); } exit(json_encode([ 'code' => 0, 'msg' => "", 'count' => $count, 'data' => $list, ])); } public function transferFrom() { $broker_id = input('broker_id/d, 0'); $agentid = $this->access_agent['id']; $broker_list = BrokerModel::where('agentid', $agentid) ->where('id', '<>', $broker_id) ->where('is_partner', '1') ->select(); return view('partner/transferform', [ 'origin_broker_id' => $broker_id, 'broker_list' => $broker_list, ]); } public function edittransfer() { $origin_broker_id = input('origin_broker_id/d, 0'); $broker_id = input('broker_id/d, 0'); if (empty($origin_broker_id) || empty($broker_id)) { exit(json_encode([ 'code' => 1, 'msg' => "参数错误", ])); } if ($origin_broker_id == $broker_id) { exit(json_encode([ 'code' => 1, 'msg' => "不可以转移给自己", ])); } $origin_broker = BrokerModel::where('id', $origin_broker_id)->find(); $broker = BrokerModel::where('id', $broker_id)->find(); if (empty($origin_broker) || empty($broker)) { exit(json_encode([ 'code' => 1, 'msg' => "参数错误", ])); } if ($origin_broker['agentid'] != $broker['agentid']) { exit(json_encode([ 'code' => 1, 'msg' => "只有相同门店的经纪人才可以转移", ])); } BrokerModel::where('pid', $origin_broker_id)->update(['pid' => $broker_id]); exit(json_encode([ 'code' => 0, ])); } public function incomeList() { $brokerid = input('id'); if (empty($brokerid)) { exit("未查询到数据"); } return view('partner/incomelist', [ 'brokerid' => $brokerid, ]); } public function listIncome() { $brokerid = input('brokerid'); if (empty($brokerid)) { exit(json_encode([ 'code' => 1, 'msg' => "未查询到数据", ])); } $limit = input('limit/d', 20); $page = input('page/d', 1); $broker_ids = BrokerModel::where('pid', $brokerid)->column('id'); if (empty($broker_ids)) { $broker_ids = [$brokerid]; } else { $broker_ids[] = $brokerid; } $map = [ ['brokerid', 'in', $broker_ids], ]; $list = BrokerIncomeModel::with(['broker'])->where($map)->order('id', 'DESC')->limit($limit)->page($page)->append(['status_text', 'powerreport_text'])->select(); $count = BrokerIncomeModel::where($map)->count(); if ($count == 0) { exit(json_encode([ 'code' => 1, 'msg' => "未查询到数据", ])); } exit(json_encode([ 'code' => 0, 'msg' => "", 'count' => $count, 'data' => $list, ])); } public function below() { $brokerid = input('broker_id'); if (empty($brokerid)) { exit("未查询到数据"); } $agent = $this->access_agent; return view('partner/below', [ 'brokerid' => $brokerid, 'agent' => $agent, ]); } public function listbelow() { $brokerid = input('broker_id'); if (empty($brokerid)) { exit("未查询到数据"); } $agentid = $this->access_agent['id']; $limit = input('limit/d', 20); $page = input('page/d', 1); $map = []; $map[] = ['agentid', '=', $agentid]; $map[] = ['pid', '=', $brokerid]; $list = BrokerModel::with(['agent', 'muser']) ->withCount(['user']) ->where($map) ->order('id', 'DESC') ->limit($limit) ->page($page) ->append(['status_text', 'powerreport_text', 'type_text', 'is_partner_text']) ->select(); $count = BrokerModel::where($map)->count(); if ($count == 0) { exit(json_encode([ 'code' => 1, 'msg' => "未查询到数据", ])); } exit(json_encode([ 'code' => 0, 'msg' => "", 'count' => $count, 'data' => $list, ])); } }