phpstock/app/admin/controller/StandingBook.php

<?php

namespace app\admin\controller;

use think\facade\Db;

//台账
class StandingBook extends Base
{

    //台账列表
    public function getList()
    {

        $param = $this->request->only(['start_date' => '', 'end_date' => '', 'projectNo' => '', 'planNo' => '', 'spuCode' => '', 'infoNo' => '', 'bidNo' => '', 'orderCode' => '', 'bk_code' => '', 'cgdNo' => '', 'page' => 1, 'size' => 15], 'post', 'trim');

        $where = [];
        if ($param['start_date'] != '' && $param['end_date'] != '') $where[] = ['addtime', 'between', [$param['start_date'] . ' 00:00:00', $param['end_date'] . ' 23:59:59']];
        if ($param['projectNo'] != '') $where[] = ['projectNo', 'like', '%' . $param['projectNo'] . '%'];
        if ($param['planNo'] != '') $where[] = ['planNo', 'like', '%' . $param['planNo'] . '%'];
        if ($param['spuCode'] != '') $where[] = ['spuCode', 'like', '%' . $param['spuCode'] . '%'];
        if ($param['infoNo'] != '') $where[] = ['infoNo', 'like', '%' . $param['infoNo'] . '%'];
        if ($param['bidNo'] != '') $where[] = ['bidNo', 'like', '%' . $param['bidNo'] . '%'];
        if ($param['orderCode'] != '') $where[] = ['orderCode', 'like', '%' . $param['orderCode'] . '%'];
        if ($param['bk_code'] != '') $where[] = ['bk_code', 'like', '%' . $param['bk_code'] . '%'];
        if ($param['cgdNo'] != '') $where[] = ['cgdNo', 'like', '%' . $param['cgdNo'] . '%'];

        $count = Db::name('standing_book')
            ->where($where)
            ->count('id');

        $list = Db::name('standing_book')
            ->where($where)
            ->order('addtime', 'desc')
            ->page($param['page'], $param['size'])
            ->select()
            ->toArray();

        return app_show(0, "获取成功", ['list' => $list, 'count' => $count]);

    }


    //台账详情
    public function getDetail(){

        $id = $this->request->post('id/d',0,'trim');

        $res = Db::name('standing_book')
            ->where('id',$id)
            ->find();

        return app_show(0,'请求成功',$res);

    }

}