// +---------------------------------------------------------------------- namespace App\Services\Common; use App\Models\AcceptorModel; use App\Services\BaseService; /** * 承兑商管理-服务类 * @author laravel开发员 * @since 2020/11/11 * @package App\Services\Common */ class AcceptorService extends BaseService { /** * 构造函数 * @author laravel开发员 * @since 2020/11/11 */ public function __construct() { $this->model = new AcceptorModel(); } /** * 获取列表 * @param $params 参数 * @param int $pageSize 分页大小:默认 15 * @return array */ public function getDataList($params, $pageSize = 10, $field=[]) { $where = ['a.mark' => 1]; if(isset($params['status']) && $params['status'] != ''){ $where['a.status'] = $params['status']; } $list = $this->model->with(['member']) ->from('acceptor as a') ->leftJoin('member as b','b.id','a.user_id') ->where($where) ->where(function($query) use($params){ $account = isset($params['account'])? trim($params['account']) : ''; if($account){ $query->where('b.username','like',"%{$account}%")->orWhere('b.trc_url','like',"%{$account}%")->orWhere('b.id','like',"%{$account}%"); } }) ->where(function($query) use($params){ $kw = isset($params['kw'])? trim($params['kw']) : ''; if($kw){ $query->where('a.name','like',"%{$kw}%")->orWhere('a.realname','like',"%{$kw}%"); } }) ->select($field? $field : ['a.*','b.username','b.trc_url','b.login_time']) ->paginate($pageSize > 0 ? $pageSize : 9999999); $list = $list? $list->toArray() :[]; if($list){ foreach($list['data'] as &$item){ $item['create_time_text'] = $item['create_time']? datetime($item['create_time']):''; } } return [ 'pageSize'=> $pageSize, 'total'=>isset($list['total'])? $list['total'] : 0, 'list'=> isset($list['data'])? $list['data'] : [] ]; } /** * 添加会编辑会员 * @return array * @since 2020/11/11 * @author laravel开发员 */ public function edit() { // 请求参数 $data = request()->all(); // 头像处理 if(isset($data['avatar'])){ $avatar = trim($data['avatar']); if (strpos($avatar, "temp")) { $data['avatar'] = save_image($avatar, 'member'); } else { $data['avatar'] = str_replace(IMG_URL, "", $data['avatar']); } } // 出生日期 if(isset($data['birthday'])){ if ($data['birthday']) { $data['birthday'] = strtotime($data['birthday']); } } // 城市处理 if(isset($data['city'])){ $city = isset($data['city']) ? $data['city'] : [3]; if (!empty($data['city'])) { // 省份 $data['province_id'] = $city[0]; // 城市 $data['city_id'] = $city[1]; // 县区 $data['district_id'] = $city[2]; } unset($data['city']); } return parent::edit($data); // TODO: Change the autogenerated stub } }