StoreTryProduct.php 1.7 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061
  1. <?php
  2. /**
  3. * Created by PhpStorm
  4. * Author: 向往那片天空
  5. * Date: 2020/6/9
  6. * Time: 9:07
  7. * 微信/QQ: 250023777
  8. * 格言: 抓住中心,宁精勿杂,宁专勿多
  9. */
  10. namespace app\admin\model\ump;
  11. use app\admin\model\order\StoreOrder;
  12. use crmeb\basic\BaseModel;
  13. use crmeb\services\PHPExcelService;
  14. use crmeb\traits\ModelTrait;
  15. class StoreTryProduct extends BaseModel
  16. {
  17. /**
  18. * 数据表主键
  19. * @var string
  20. */
  21. protected $pk = 'id';
  22. /**
  23. * 模型名称
  24. * @var string
  25. */
  26. protected $name = 'store_try_product';
  27. use ModelTrait;
  28. /**
  29. * @param $where
  30. * @return array
  31. */
  32. public static function systemPage($where)
  33. {
  34. $model = self::setWhere($where)->where('is_del=0')->limit(bcmul($where['page'], $where['limit'], 0), $where['limit']);
  35. return self::page($model,$where, $where['limit']);
  36. }
  37. /**
  38. * 设置拼团 where 条件
  39. * @param $where
  40. * @param null $model
  41. * @return mixed
  42. */
  43. public static function setWhere($where, $model = null)
  44. {
  45. $model = $model === null ? new self() : $model;
  46. if (isset($where['is_show']) && $where['is_show'] != '') $model = $model->where('is_show', $where['is_show']);
  47. if (isset($where['is_finish']) && $where['is_finish'] != '') $model = $model->where('is_finish', $where['is_finish']);
  48. if (isset($where['store_name']) && $where['store_name'] != '') $model = $model->where('store_name', 'LIKE', "%$where[store_name]%");
  49. return $model->order('sort desc,id desc')->where('is_del', 0);
  50. }
  51. public static function getCombinationIdAll(){
  52. return self::where('is_del', 0)->column('id', 'id');
  53. }
  54. }