140 lines
3.2 KiB
PHP
140 lines
3.2 KiB
PHP
<?php
|
|
/**
|
|
* ZoneRepo.php
|
|
*
|
|
* @copyright 2022 beikeshop.com - All Rights Reserved
|
|
* @link https://beikeshop.com
|
|
* @author TL <mengwb@guangda.work>
|
|
* @created 2022-06-30 15:22:05
|
|
* @modified 2022-06-30 15:22:05
|
|
*/
|
|
|
|
namespace Beike\Repositories;
|
|
|
|
use Beike\Models\Zone;
|
|
|
|
class ZoneRepo
|
|
{
|
|
/**
|
|
* @param $data
|
|
* @return array
|
|
*/
|
|
private static function handleParams($data)
|
|
{
|
|
return [
|
|
'country_id' => $data['country_id'] ?? 0,
|
|
'name' => $data['name'] ?? '',
|
|
'code' => $data['code'] ?? '',
|
|
'sort_order' => (int) $data['sort_order'] ?? 0,
|
|
'status' => (bool) $data['status'] ?? 0,
|
|
];
|
|
}
|
|
|
|
/**
|
|
* 创建一个zone记录
|
|
* @param $data
|
|
* @return mixed
|
|
*/
|
|
public static function create($data)
|
|
{
|
|
$data = self::handleParams($data);
|
|
|
|
return Zone::query()->create($data);
|
|
}
|
|
|
|
/**
|
|
* @param $id
|
|
* @param $data
|
|
* @return mixed
|
|
* @throws \Exception
|
|
*/
|
|
public static function update($id, $data)
|
|
{
|
|
$zone = Zone::query()->find($id);
|
|
if (! $zone) {
|
|
throw new \Exception("省份/地区id {$id} 不存在");
|
|
}
|
|
$data = self::handleParams($data);
|
|
$zone->update($data);
|
|
|
|
return $zone;
|
|
}
|
|
|
|
/**
|
|
* @param $id
|
|
* @return mixed
|
|
*/
|
|
public static function find($id)
|
|
{
|
|
return Zone::query()->findOrFail($id);
|
|
}
|
|
|
|
/**
|
|
* @param $id
|
|
* @return void
|
|
*/
|
|
public static function delete($id)
|
|
{
|
|
$zone = Zone::query()->find($id);
|
|
if ($zone) {
|
|
$zone->delete();
|
|
}
|
|
}
|
|
|
|
/**
|
|
* @param array $data
|
|
* @return \Illuminate\Contracts\Pagination\LengthAwarePaginator
|
|
*/
|
|
public static function list(array $data = [])
|
|
{
|
|
$builder = Zone::query();
|
|
|
|
if (isset($data['name'])) {
|
|
$builder->where('zones.name', 'like', "%{$data['name']}%");
|
|
}
|
|
if (isset($data['code'])) {
|
|
$builder->where('zones.code', 'like', "%{$data['email']}%");
|
|
}
|
|
if (isset($data['status'])) {
|
|
$builder->where('zones.status', $data['status']);
|
|
}
|
|
|
|
return $builder->paginate(perPage())->withQueryString();
|
|
}
|
|
|
|
/**
|
|
* 根据国家获取国家的省份
|
|
* @param $country
|
|
* @return \Illuminate\Database\Eloquent\HigherOrderBuilderProxy|\Illuminate\Support\HigherOrderCollectionProxy|mixed|void
|
|
*/
|
|
public static function listByCountry($country)
|
|
{
|
|
if (gettype($country) != 'object') {
|
|
$country = CountryRepo::find($country);
|
|
}
|
|
if ($country) {
|
|
return $country->zones;
|
|
}
|
|
}
|
|
|
|
/**
|
|
* 通过国家ID获取省份拉下选项
|
|
*
|
|
* @param $countryId
|
|
* @return array
|
|
*/
|
|
public static function getZoneOptions($countryId): array
|
|
{
|
|
$zones = self::listByCountry($countryId);
|
|
$items = [];
|
|
foreach ($zones as $zone) {
|
|
$items[] = [
|
|
'value' => $zone->id,
|
|
'label' => $zone->name,
|
|
];
|
|
}
|
|
|
|
return $items;
|
|
}
|
|
}
|