dfxd/app/Service/AreaService.php

<?php

namespace App\Service;

use App\Model\Area;
use App\Model\Screen;

/**
 * 区域相关
 * @package App\Models
 */
class AreaService extends Service
{
    public function edit($data){
        list($status,$msg) = $this->areaRule($data,false);
        if(!$status) return [$status,$msg];

        $model = Area::where('id',$data['id'])->first();
        $model->title = $data['title'];
        $model->code = $data['code'];
        $model->save();

        return [true,'保存成功！'];
    }

    public function add($data){
        list($status,$msg) = $this->areaRule($data);
        if(!$status) return [$status,$msg];

        $model = new Area();
        $model->title = $data['title'];
        $model->code = $data['code'];
        $model->save();

        return [true,'保存成功！'];
    }

    public function del($data){
        if($this->isEmpty($data,'id')) return [false,'请选择数据！'];

        $bool = Screen::where('del_time',0)->whereIn('area_id',$data['id'])->exists();
        if($bool) return [false,'区域已经绑定仓'];

        Area::whereIn('id',$data['id'])->update([
            'del_time'=>time()
        ]);

        return [true,'删除成功'];
    }

    public function AreaList($data){
        $model = Area::where('del_time',0)
            ->select('title','id','code')
            ->orderby('id', 'desc');
        if(! empty($data['title'])) $model->where('title', 'LIKE', '%'.$data['title'].'%');
        if(! empty($data['code'])) $model->where('code', 'LIKE', '%'.$data['code'].'%');

        $list = $this->limit($model,'',$data);

        return [true,$list];
    }

    public function areaRule($data, $is_check = true){
        if(empty($data['title'])) return [false,'区域名称不能为空！'];
        if(empty($data['code'])) return [false,'区域编码不能为空！'];
        if($is_check){
            $bool = Area::whereRaw("(binary code = '{$data['code']}' OR title = '{$data['title']}')")
                ->where('del_time',0)
                ->exists();
        }else{
            if(empty($data['id'])) return [false,'id不能为空！'];

            $bool = Area::whereRaw("(binary code = '{$data['code']}' OR title = '{$data['title']}')")
                ->where('id','<>',$data['id'])
                ->where('del_time',0)
                ->exists();
        }
        if($bool) return [false,'编码或区域名称不能重复'];

        return [true, ''];
    }
}