jya-oa-api/application/common/model/HouseLessee.php

<?php
namespace app\common\model;

use app\hander\HelpHander;
use think\Db;
use think\Model;
class HouseLessee extends Model
{
    public function add(){
        $data = [
            'id' => input('id/d',0),
            'title' => input('title','','trim'),
            'org_id' => input('orgId/d',0),
            'name' => input('name','','trim'),//联系人姓名
            'phone' => input('phone','','trim'),//手机号
            'legal' => input('legal','','trim'),//法人
            'address' => input('address','','trim'),//邮寄地址
            'prop_id' => input('propId/d',0),//企业属性
            'remark' => input('remark','','trim'),//备注
            'enable' => input('enable/d',0), //状态
            'type' => input('type/d',1),
            'file' => input('file','','trim'),//附件
            'dep' => input('dep','','trim'),
            'grade' => input('grade','','trim'),
            'code' => input('code','','trim'),
            'level_id' => input('levelId/d',0),
        ];

        $result = validate('HouseLessee')->check($data,[],'');
        if(true !== $result){
            HelpHander::error(validate('HouseLessee')->getError());
        }
        $id = $data['id'];
        unset($data['id']);
        if($id > 0){
            $data['update_time'] = date("Y-m-d H:i:s");
            $ret = $this->allowField(true)->save($data,['id'=>$id]);
        }else{
            $data['create_time'] = date("Y-m-d H:i:s");
            $ret = $this->allowField(true)->save($data);
        }
        if(!$ret){
            HelpHander::error('操作失败');
        }
        return true;
    }

    public function del($id){
        $res = Db::name('HouseContract')->where('lessee_id',$id)->where('del',0)->find();
        if($res){
            HelpHander::error('已被使用无法删除');
        }

        $res = Db::name('HouseTurnLessee')->where('lessee_id',$id)->find();
        if($res){
            HelpHander::error('已被使用无法删除');
        }

        $ret = $this->where('id',$id)->update(['del'=>1]);
        if(!$ret){
            HelpHander::error('删除失败');
        }
        return true;
    }

    public function info($id){
        $info = Db::name('house_lessee')->where('id',$id)->find();
        $info['propName'] = '';
        if($info['prop_id'] > 0){
            $info['propName'] = Db::name('house_lessee_prop')->where('id',$info['prop_id'])->value('title');
        }
        return $info;
    }

    public function lists($page,$size,$title,$type,$orgId){
        $map[] = ['del','=',0];
        $map[] = ['type','=',$type];
        $map[] = ['org_id','=',$orgId];
        if($title != ''){
            $map[] = ['title','like','%'.$title.'%'];
        }
        $lists = $this
            ->where($map)
            ->page($page,$size)
            ->order('id desc')
            ->select();
        foreach ($lists as $k=>$v){
            $lists[$k]['prop_name'] = '';
            if($v['prop_id'] > 0){
                $lists[$k]['prop_name'] = Db::name('house_lessee_prop')->where('id',$v['prop_id'])->value('title');
            }
            $lists[$k]['level_name'] = '';
            if($v['level_id'] > 0){
                $lists[$k]['level_name'] = Db::name('house_level')->where('id',$v['level_id'])->value('title');
            }
        }
        $total = $this->where($map)->count();
        $data = [
            'total' => $total,
            'list' => $lists?$lists->toArray():[]
        ];
        return $data;
    }

    public function all($type,$orgId){
        $map[] = ['del','=',0];
        $map[] = ['org_id','=',$orgId];
        $map[] = ['type','=',$type];
        $lists = $this
            ->where($map)
            ->order('id desc')
            ->select();
        return $lists?$lists->toArray():[];
    }


}