StoreProductRuleDao.php 2.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | CRMEB [ CRMEB赋能开发者,助力企业发展 ]
  4. // +----------------------------------------------------------------------
  5. // | Copyright (c) 2016~2023 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)->when($page && $limit, function ($query) use ($page, $limit) {
  41. $query->page($page, $limit);
  42. })->order('id desc')->select()->toArray();
  43. }
  44. /**
  45. * 删除数据
  46. * @param string $ids
  47. * @throws \Exception
  48. */
  49. public function del(string $ids)
  50. {
  51. return $this->getModel()->whereIn('id', $ids)->delete();
  52. }
  53. /**
  54. * @param array $where
  55. * @param string $field
  56. * @return array
  57. * @throws \think\db\exception\DataNotFoundException
  58. * @throws \think\db\exception\DbException
  59. * @throws \think\db\exception\ModelNotFoundException
  60. */
  61. public function getProductRuleList(array $where, $field = "*"): array
  62. {
  63. return $this->search($where)->field($field)->select()->toArray();
  64. }
  65. }