['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) { if ($params['lease_end_time']<$params['lease_start_time']) { return ['code' => 0, 'msg' => '租赁时间范围有误请检查!']; } $where = []; $where[] = ['lease_end_time', '>=', $params['lease_start_time']]; $where[] = ['lease_end_time', '>=', $params['lease_start_time']]; $where[] = ['a_id', '=', $params['a_id']]; $assetLeaseInfo = AssetLeaseInfo::where($where)->findOrEmpty(); if (!$assetLeaseInfo->isEmpty()) { return ['code' => 0, 'msg' => '租赁期内有未到期的租赁信息!']; } AssetLeaseInfo::create([ 'a_id' => $params['a_id'], 'tenant_name' => $params['tenant_name'] ?? '', 'tenant_mobile' => $params['tenant_mobile'] ?? '', 'license_number' => $params['license_number'] ?? '', 'license_image' => $params['license_image'] ?? '', 'lease_contract_image' => $params['lease_contract_image'] ?? '', 'lease_money' => $params['lease_money'] ?? 0, 'lease_start_time' => $params['lease_start_time'] ?? '', 'lease_end_time' => $params['lease_end_time'] ?? '', // 联系人 'purpose' => $params['purpose'] ?? '', 'referee_name' =>$params['referee_name'], 'referee_uid' =>$params['referee_uid'], 'remark' => $params['remark'] ?? '', ]); return ['code' => 200, 'msg' => '新增租赁信息成功!']; } /** * @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(); } }