ProvinceService.php 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445
  1. <?php
  2. namespace App\Services;
  3. use App\Province;
  4. use Illuminate\Support\Str;
  5. use App\Traits\ServiceAppAop;
  6. class ProvinceService
  7. {
  8. use ServiceAppAop;
  9. protected $modelClass=Province::class;
  10. public static $provinces = ['青海','新疆','内蒙古','广西','西藏','宁夏','北京','上海','重庆','天津'];
  11. public function findByName($name)
  12. {
  13. $province = Province::query()->where('name',$name)->first();
  14. if(isset($province))return $province;
  15. foreach (ProvinceService::$provinces as $province) {
  16. if(strstr($province,$name) != null){
  17. return Province::query()->where('name',$province)->first();
  18. }
  19. }
  20. if(str_ends_with($name,'市')){
  21. $province_name = Str::before($name,'市');
  22. return Province::query()->where('name','like',$province_name.'%')->first();
  23. }
  24. if(str_ends_with($name,'省')){
  25. $province_name = Str::before($name,'省');
  26. return Province::query()->where('name','like',$province_name.'%')->first();
  27. }
  28. return null;
  29. }
  30. public function first(array $params)
  31. {
  32. $query = Province::query();
  33. foreach ($params as $column=>$param){
  34. $query->where($column,$param);
  35. }
  36. return $query->first();
  37. }
  38. }