123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 |
- <?php
- // +----------------------------------------------------------------------
- // | CRMEB [ CRMEB赋能开发者,助力企业发展 ]
- // +----------------------------------------------------------------------
- // | Copyright (c) 2016~2020 https://www.crmeb.com All rights reserved.
- // +----------------------------------------------------------------------
- // | Licensed CRMEB并不是自由软件,未经许可不能去掉CRMEB相关版权
- // +----------------------------------------------------------------------
- // | Author: CRMEB Team <admin@crmeb.com>
- // +----------------------------------------------------------------------
- namespace app\common\dao\store;
- use app\common\model\store\Excel;
- use app\common\dao\BaseDao;
- class ExcelDao extends BaseDao
- {
- /**
- * TODO
- * @return string
- * @author Qinii
- * @day 2020-07-30
- */
- protected function getModel(): string
- {
- return Excel::class;
- }
- public function search(array $where)
- {
- $query = $this->getModel()::getDB()
- ->when(isset($where['type']) && $where['type'] !== '',function($query) use($where){
- $query->where('type',$where['type']);
- })
- ->when(isset($where['mer_id']) && $where['mer_id'] !== '',function($query) use($where){
- $query->where('mer_id',$where['mer_id']);
- })
- ->when(isset($where['admin_id']) && $where['admin_id'] !== '',function($query) use($where){
- $query->where('admin_id',$where['admin_id']);
- });
- $query->order('create_time DESC');
- return $query;
- }
- /**
- * TODO 获取小于某个时间的文件
- * @param $time
- * @return mixed
- * @author Qinii
- * @day 2020-08-15
- */
- public function getDelByTime($time)
- {
- return $this->getModel()::getDB()->whereTime('create_time','<',$time)->column('path','excel_id');
- }
- }
|