ProvinceService.php 1.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  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. public static $provinces = ['青海','新疆','内蒙古','广西','西藏','宁夏','北京','上海','重庆','天津'];
  10. public function findByName($name)
  11. {
  12. $province = Province::query()->where('name',$name)->first();
  13. if(isset($province))return $province;
  14. foreach (ProvinceService::$provinces as $province) {
  15. if(strstr($province,$name) != null){
  16. return Province::query()->where('name',$province)->first();
  17. }
  18. }
  19. if(str_ends_with($name,'市')){
  20. $province_name = Str::before($name,'市');
  21. return Province::query()->where('name','like',$province_name.'%')->first();
  22. }
  23. if(str_ends_with($name,'省')){
  24. $province_name = Str::before($name,'省');
  25. return Province::query()->where('name','like',$province_name.'%')->first();
  26. }
  27. return null;
  28. }
  29. public function first(array $params)
  30. {
  31. $query = Province::query();
  32. foreach ($params as $column=>$param){
  33. $query->where($column,$param);
  34. }
  35. return $query->first();
  36. }
  37. }