ExcelDao.php 1.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  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\store;
  12. use app\common\model\store\Excel;
  13. use app\common\dao\BaseDao;
  14. class ExcelDao extends BaseDao
  15. {
  16. /**
  17. * TODO
  18. * @return string
  19. * @author Qinii
  20. * @day 2020-07-30
  21. */
  22. protected function getModel(): string
  23. {
  24. return Excel::class;
  25. }
  26. public function search(array $where)
  27. {
  28. $query = $this->getModel()::getDB()
  29. ->when(isset($where['type']) && $where['type'] !== '',function($query) use($where){
  30. $query->where('type',$where['type']);
  31. })
  32. ->when(isset($where['mer_id']) && $where['mer_id'] !== '',function($query) use($where){
  33. $query->where('mer_id',$where['mer_id']);
  34. })
  35. ->when(isset($where['admin_id']) && $where['admin_id'] !== '',function($query) use($where){
  36. $query->where('admin_id',$where['admin_id']);
  37. });
  38. $query->order('create_time DESC');
  39. return $query;
  40. }
  41. /**
  42. * TODO 获取小于某个时间的文件
  43. * @param $time
  44. * @return mixed
  45. * @author Qinii
  46. * @day 2020-08-15
  47. */
  48. public function getDelByTime($time)
  49. {
  50. return $this->getModel()::getDB()->whereTime('create_time','<',$time)->column('path','excel_id');
  51. }
  52. }