alias('deliveryman')->with(['commander','school']) ->field('deliveryman.*, user.nickName, user.avatarUrl') ->join('user', 'user.user_id = deliveryman.user_id') ->where('deliveryman.is_delete', '=', 0) ->where('user.is_delete', '=', 0) ->where('deliveryman.commander_id', '=', $data["commander_id"]) ->order(['deliveryman.create_time' => 'desc']); // 查询条件 if (!empty($data['nick_name'])) { $model = $model->where('user.nickName|deliveryman.real_name|deliveryman.mobile', 'like', '%' . $data['nick_name'] . '%'); } // 获取列表数据 $list = $model->paginate($data); /* foreach ($list as &$val){ }*/ return $list; } /** * 编辑用户 * @param $data * @return bool */ public function edit($data) { return $this->save($data); } /** * 删除 * @return mixed */ public function setDelete() { // 标记已删除 return $this->save([ 'is_delete' => 1 ]); } /** * 提现打款成功:累积提现佣金 */ public static function totalMoney($user_id, $money) { $model = self::detail($user_id); return $model->save([ 'freeze_money' => $model['freeze_money'] - $money, 'total_money' => $model['total_money'] + $money, ]); } /** * 提现驳回:解冻分销商资金 */ public static function backFreezeMoney($user_id, $money) { $model = self::detail($user_id); return $model->save([ 'money' => $model['money'] + $money, 'freeze_money' => $model['freeze_money'] - $money, ]); } }