['name', 'status'] ]; } /** * @notes 资产信息列表 * @return array * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException * @author ljj * @date 2022/2/16 3:18 下午 */ public function lists(): array { $parms = $this->request->get(); $where = [] ; if(!empty($parms)) { if(isset($parms['asset_name'])){ $awhere = [] ; $awhere[] = ['name', 'like', '%' . $parms['asset_name']. '%']; $assetList = AssetInfo::where($awhere)->select()->toArray(); $a_id_Arr = array_column($assetList,'id'); $where[]=['a_id','in',$a_id_Arr]; } if(isset($parms['tenant_name'])){ if(!empty($parms['tenant_name'])){ $where[] = ['tenant_name', 'like', '%' . $parms['tenant_name']. '%']; } } if(isset($parms['tenant_mobile'])){ if(!empty($parms['tenant_mobile'])){ $where[] = ['tenant_mobile', 'like', '%' . $parms['tenant_mobile']. '%']; } } } $lists = (new AssetLeaseInfo())->field('*') ->append(['first_status_desc','second_status_desc']) ->with('asset') ->with('referee') ->where($where) // ->where($this->searchWhere) ->limit($this->limitOffset, $this->limitLength) ->Order('id desc') ->select() ->toArray(); foreach($lists as &$v){ $v['first_name'] = adminModel::where(['id'=>$v['first_uid']])->value('name') ?? ''; $v['second_name'] = adminModel::where(['id'=>$v['second_uid']])->value('name') ?? '' ; } return $lists; } /** * @notes 资产信息数量 * @return int * @author ljj * @date 2022/2/16 3:18 下午 */ public function count(): int { return (new AssetLeaseInfo())->where($this->searchWhere)->count(); } /** * @notes 添加资产 * @param array $params * @author heshihu * @date 2022/2/22 9:57 */ public static function add(array $params) { AssetInfo::create([ 'name' => $params['name'], 'images' => $params['images'] ?? '', 'address' => $params['address'] ?? '', 'contacts' => $params['contacts']?? '', // 联系人 'mobile' => $params['mobile'] ?? '', 'area' => $params['area'] ?? '', 'content' => $params['content'] ?? '', // 'image' => $params['image'] ? FileService::setFileUrl($params['image']) : '', 'status' => $params['status'] ?? 1, 'sort' => $params['sort'] ?? 0, // 排序 ]); } /** * @notes 编辑资产 * @param array $params * @return bool * @author heshihu * @date 2022/2/22 10:12 */ public static function edit(array $params) : bool { try { AssetInfo::update([ 'id' => $params['id'], 'name' => $params['name'], 'images' => $params['images'], 'address' => $params['address'], 'contacts' => $params['contacts'], 'mobile' => $params['mobile'], 'area' => $params['area'] ?? '', 'content' => $params['content'] ?? '', 'status' => $params['status'] ?? 1, 'sort' => $params['sort'] ?? 0, 'content' => $params['content'] ?? '', ]); return true; } catch (\Exception $e) { self::setError($e->getMessage()); return false; } } /** * @notes 删除资产 * @param array $params * @author heshihu * @date 2022/2/22 10:17 */ public static function delete(array $params) { AssetInfo::destroy($params['id']); } /** * @notes 查看资产详情 * @param $params * @return array * @author heshihu * @date 2022/2/22 10:15 */ public static function detail($params) : array { return AssetInfo::findOrEmpty($params['id'])->append(['status_desc','lease_status_desc'])->toArray(); } }