123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172 |
- <?php
- namespace app\dao\system;
- use app\dao\BaseDao;
- use app\model\system\CapitalFlow;
- class CapitalFlowDao extends BaseDao
- {
-
- protected function setModel(): string
- {
- return CapitalFlow::class;
- }
-
- public function getList(array $where, string $field = '*', int $page = 0, int $limit = 0)
- {
- return $this->search($where)->field($field)->when($page && $limit, function ($query) use ($page, $limit) {
- $query->page($page, $limit);
- })->order('id desc')->select()->toArray();
- }
-
- public function getRecordList($where, $page = 0, $limit = 0)
- {
- $model = $this->search($where)
- ->when(isset($where['type']) && $where['type'] !== '', function ($query) use ($where) {
- $timeUnix = '%Y-%m-%d';
- switch ($where['type']) {
- case "day" :
- $timeUnix = "%Y-%m-%d";
- break;
- case "week" :
- $timeUnix = "%Y-%u";
- break;
- case "month" :
- $timeUnix = "%Y-%m";
- break;
- }
- $query->field("FROM_UNIXTIME(add_time,'$timeUnix') as day,sum(if(price >= 0,price,0)) as income_price,sum(if(price < 0,price,0)) as exp_price,add_time,group_concat(id) as ids");
- $query->group("FROM_UNIXTIME(add_time, '$timeUnix')");
- });
- $count = $model->count();
- $list = $model->when($page && $limit, function ($query) use ($page, $limit) {
- $query->page($page, $limit);
- })->order('add_time desc')->select()->toArray();
- return compact('list', 'count');
- }
- }
|