MemberCardDao.php 2.0 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667
  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\user\member;
  12. use app\dao\BaseDao;
  13. use app\model\user\member\MemberCard;
  14. /**
  15. * Class MemberCardDao
  16. * @package app\dao\user\member
  17. */
  18. class MemberCardDao extends BaseDao
  19. {
  20. /**
  21. * 设置模型
  22. * @return string
  23. */
  24. protected function setModel(): string
  25. {
  26. return MemberCard::class;
  27. }
  28. /**
  29. * 获取列表
  30. * @param array $where
  31. * @param int $page
  32. * @param int $limit
  33. * @param array|string[] $field
  34. * @return array
  35. * @throws \think\db\exception\DataNotFoundException
  36. * @throws \think\db\exception\DbException
  37. * @throws \think\db\exception\ModelNotFoundException
  38. */
  39. public function getSearchList(array $where, int $page = 0, int $limit = 0, array $field = ['*'])
  40. {
  41. return $this->search($where)->order('use_time desc,id desc')
  42. ->field($field)
  43. ->when($page > 0 || $limit > 0, function ($query) use ($page, $limit) {
  44. $query->page($page, $limit);
  45. })->select()->toArray();
  46. }
  47. /**
  48. * 获取当条会员卡信息
  49. * @param array $where
  50. * @return array|\think\Model|null
  51. * @throws \think\db\exception\DataNotFoundException
  52. * @throws \think\db\exception\DbException
  53. * @throws \think\db\exception\ModelNotFoundException
  54. */
  55. public function getOneByWhere(array $where)
  56. {
  57. return $this->getModel()->where($where)->find();
  58. }
  59. }