ball/app/workerapi/lists/MasterWorkerRetentionMoneyLogLists.php

<?php
/**
 * @author 林海涛
 * @date 2024/7/28 上午11:30
 */
namespace app\workerapi\lists;
use app\common\model\master_worker\MasterWorkerRetentionMoneyLog;

class MasterWorkerRetentionMoneyLogLists extends BaseWorkerDataLists
{

    public function queryWhere()
    {
        $where = [];
        if(isset($this->params['formData'])){
            $queryParams = json_decode($this->params['formData'],true);
            if(isset($queryParams['worker_id'])){
                $where[]= ['worker_id','=',$queryParams['worker_id']];
            }
        }
        if(isset($this->params['create_time']) && !empty($this->params['create_time'])){
            $time = [strtotime($this->params['create_time'][0]), strtotime($this->params['create_time'][1])];
            $where[] = ['create_time', 'between', $time];
        }
        return $where;
    }

    public function lists(): array
    {
        $lists = MasterWorkerRetentionMoneyLog::where($this->searchWhere)
            ->where($this->queryWhere())
            ->append(['action_text'])
            ->field(['id', 'sn','action','amount','remark','create_time','update_time'])
            ->order(['id' => 'desc'])
            ->select()
            ->toArray();
        foreach ($lists as &$item) {
            $item['amount'] = $item['action_text'] . $item['amount'];
        }
        return $lists;
    }

    public function count(): int
    {
        return MasterWorkerRetentionMoneyLog::where($this->queryWhere())->count();
    }
}