StoreProductRuleDao.php 2.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | CRMEB [ CRMEB赋能开发者,助力企业发展 ]
  4. // +----------------------------------------------------------------------
  5. // | Copyright (c) 2016~2020 https://www.crmeb.com All rights reserved.
  6. // +----------------------------------------------------------------------
  7. // | Licensed CRMEB并不是自由软件,未经许可不能去掉CRMEB相关版权
  8. // +----------------------------------------------------------------------
  9. // | Author: CRMEB Team <admin@crmeb.com>
  10. // +----------------------------------------------------------------------
  11. namespace app\dao\product\sku;
  12. use app\dao\BaseDao;
  13. use app\model\product\sku\StoreProductRule;
  14. /**
  15. * Class StoreProductRuleDao
  16. * @package app\dao\product\sku
  17. */
  18. class StoreProductRuleDao extends BaseDao
  19. {
  20. /**
  21. * 设置模型
  22. * @return string
  23. */
  24. protected function setModel(): string
  25. {
  26. return StoreProductRule::class;
  27. }
  28. /**
  29. * 获取列表
  30. * @param array $where
  31. * @param int $page
  32. * @param int $limit
  33. * @return array
  34. * @throws \think\db\exception\DataNotFoundException
  35. * @throws \think\db\exception\DbException
  36. * @throws \think\db\exception\ModelNotFoundException
  37. */
  38. public function getList(array $where = [], int $page = 0, int $limit = 0)
  39. {
  40. return $this->search($where)
  41. ->when($page != 0 && $limit != 0, function ($query) use ($page, $limit) {
  42. $query->page($page, $limit);
  43. })->order('id desc')->select()->toArray();
  44. }
  45. /**
  46. * 删除数据
  47. * @param string $ids
  48. * @throws \Exception
  49. */
  50. public function del(string $ids)
  51. {
  52. return $this->getModel()->whereIn('id', $ids)->delete();
  53. }
  54. /**
  55. * @param array $where
  56. * @param string $field
  57. * @return array
  58. * @throws \think\db\exception\DataNotFoundException
  59. * @throws \think\db\exception\DbException
  60. * @throws \think\db\exception\ModelNotFoundException
  61. */
  62. public function getProductRuleList(array $where, $field = "*"): array
  63. {
  64. return $this->search($where)->field($field)->select()->toArray();
  65. }
  66. }