MerchantIntentionDao.php 2.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
  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\common\dao\system\merchant;
  12. use app\common\dao\BaseDao;
  13. use app\common\model\system\merchant\MerchantIntention;
  14. class MerchantIntentionDao extends BaseDao
  15. {
  16. protected function getModel(): string
  17. {
  18. return MerchantIntention::class;
  19. }
  20. public function search(array $where)
  21. {
  22. $query = $this->getModel()::getDB()->when(isset($where['mer_id']) && $where['mer_id'] !== '', function ($query) use ($where) {
  23. $query->where('mer_id', $where['mer_id']);
  24. })->when(isset($where['uid']) && $where['uid'] !== '', function ($query) use ($where) {
  25. $query->where('uid', $where['uid']);
  26. })->when(isset($where['status']) && $where['status'] !== '', function ($query) use ($where) {
  27. $query->where('status', (int)$where['status']);
  28. })->when(isset($where['mer_intention_id']) && $where['mer_intention_id'] !== '', function ($query) use ($where) {
  29. $query->where('mer_intention_id', $where['mer_intention_id']);
  30. })->when(isset($where['keyword']) && $where['keyword'] !== '', function ($query) use ($where) {
  31. $query->where('mer_name|phone|mark', 'like', '%' . $where['keyword'] . '%');
  32. })->when(isset($where['date']) && $where['date'] !== '', function ($query) use ($where) {
  33. getModelTime($query, $where['date']);
  34. })->where('is_del', 0);
  35. return $query;
  36. }
  37. public function form($id, $data)
  38. {
  39. $this->getModel()::getDB()->where($this->getPk(), $id)->update(['status' => $data['status'], 'mark' => $data['mark']]);
  40. }
  41. }