StoreProductProvider.php 1.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. <?php
  2. namespace app\admin\model\store;
  3. use crmeb\basic\BaseModel;
  4. use crmeb\traits\ModelTrait;
  5. class StoreProductProvider extends BaseModel
  6. {
  7. protected $pk = 'id';
  8. protected $name = 'store_product_provider';
  9. use ModelTrait;
  10. /**
  11. * 获取查询条件
  12. * @param $where
  13. * @param string $alert
  14. * @param null $model
  15. * @return StoreProductProvider|null
  16. */
  17. public static function setWhere($where, $alias='', $model=null)
  18. {
  19. $model=$model===null ? new self() : $model;
  20. if($alias) {
  21. $model=$model->alias($alias);
  22. }
  23. $alias=$alias ? $alias.'.': '';
  24. //$model = $model->where("{$alias}status",0);
  25. if(isset($where['keyword']) && $where['keyword']!=='') {
  26. $model=$model->where("{$alias}name",'LIKE',"%$where[keyword]%");
  27. }
  28. return $model;
  29. }
  30. public static function getProviderList($where)
  31. {
  32. $data=self::setWhere($where)->order('add_time desc')->page((int)$where['page'],(int)$where['limit'])->select();
  33. $data=count($data) ? $data->toArray() : [];
  34. $count=self::setWhere($where)->count();
  35. return compact('data','count');
  36. }
  37. }