config-manage/app/Repositories/ConfigCityManagementRepository.php

<?php

namespace App\Repositories;


use App\Models\ConfigCityManagement;
use Symfony\Component\HttpKernel\Exception\HttpException;
use Dingo\Api\Http\Response;
use Illuminate\Support\Facades\DB;
use Illuminate\Database\QueryException;

class ConfigCityManagementRepository {
    public function __construct(ConfigCityManagement $configCityManagement) {

        $this->configCityManagement = $configCityManagement;
    }
    //列表
    public function index($request)
    {
        $where = [];
        if(isset($request['id'])){
            $where[] = ['id', '=', $request['id']];
        }


        return $this->configCityManagement->where($where)->orderBy('id', 'asc')->paginate(20);

    }

    public function edit($request)
    {
        $configCity = $this->configCityManagement->where('id', $request['id'])->first();

        $configCity->province_id = $request['province_id'];
        $configCity->province_name = $request['province_name'];
        $configCity->city_id = $request['city_id'];
        $configCity->city_name = $request['city_name'];
        $configCity->express_type = $request['express_type'];
        $configCity->status = 0;

        DB::beginTransaction();
        try {
            $res = $configCity->save();

            if ($res) {
                DB::commit();
                return Response::create();
            }
            DB::rollBack();
            return Response::create([
                'message' => '编辑失败，请重试',
                'status_code' => 500
            ]);

        } catch (QueryException $exception) {
            DB::rollBack();
            return Response::create([
                'message' => '编辑失败，请重试',
                'error' => $exception->getMessage(),
                'status_code' => 500
            ]);
        }
    }

    public function delete($request)
    {
        $configCity = $this->configCityManagement->where('id', $request['id'])->first();

        DB::beginTransaction();
        try{
            $res = $configCity->delete();

            if($res){
                DB::commit();
                return Response::create();
            }
            DB::rollBack();
            return Response::create([
                'message'  => '删除失败，请重试',
                'status_code'   => 500
            ]);

        }catch (QueryException $exception){
            DB::rollBack();
            return Response::create([
                'message'  => '删除失败，请重试',
                'error' => $exception->getMessage(),
                'status_code'   => 500
            ]);
        }
    }


}