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' => '',
            'standBookNo' => '',
            'projectNo' => '',
            'infoNo' => '',
            'bargainNo' => '',
            'bk_code' => '',
            'orderCode' => '',
            'outCode' => '',
            'returnCode' => '',
            'thNo' => '',
            'returnGoodCode' => '',
            'cgdNo' => '',
            'wsm_in_code' => '',
            'cgdReturnCode' => '',
            'spuCode' => '',
            'skuCode' => '',
            'order_type' => '',
            'supplierNo' => '',
            'companyNo' => '',
            'customer_code' => '',
            '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['standBookNo'] != '') $where[] = ['standBookNo', 'like', '%' . $param['standBookNo'] . '%'];
        if ($param['projectNo'] != '') $where[] = ['projectNo', 'like', '%' . $param['projectNo'] . '%'];
        if ($param['infoNo'] != '') $where[] = ['infoNo', 'like', '%' . $param['infoNo'] . '%'];
        if ($param['bargainNo'] != '') $where[] = ['bargainNo', 'like', '%' . $param['bargainNo'] . '%'];
        if ($param['bk_code'] != '') $where[] = ['bk_code', 'like', '%' . $param['bk_code'] . '%'];
        if ($param['orderCode'] != '') $where[] = ['orderCode', 'like', '%' . $param['orderCode'] . '%'];
        if ($param['outCode'] != '') $where[] = ['outCode', 'like', '%' . $param['outCode'] . '%'];
        if ($param['returnCode'] != '') $where[] = ['returnCode', 'like', '%' . $param['returnCode'] . '%'];
        if ($param['thNo'] != '') $where[] = ['thNo', 'like', '%' . $param['thNo'] . '%'];
        if ($param['returnGoodCode'] != '') $where[] = ['returnGoodCode', 'like', '%' . $param['returnGoodCode'] . '%'];
        if ($param['cgdNo'] != '') $where[] = ['cgdNo', 'like', '%' . $param['cgdNo'] . '%'];
        if ($param['wsm_in_code'] != '') $where[] = ['wsm_in_code', 'like', '%' . $param['wsm_in_code'] . '%'];
        if ($param['cgdReturnCode'] != '') $where[] = ['cgdReturnCode', 'like', '%' . $param['cgdReturnCode'] . '%'];
        if ($param['spuCode'] != '') $where[] = ['spuCode', 'like', '%' . $param['spuCode'] . '%'];
        if ($param['skuCode'] != '') $where[] = ['skuCode', 'like', '%' . $param['skuCode'] . '%'];
        if ($param['order_type'] != '') $where[] = ['order_type', '=', $param['order_type']];
        if ($param['supplierNo'] != '') $where[] = ['supplierNo', 'like', '%' . $param['supplierNo'] . '%'];
        if ($param['companyNo'] != '') $where[] = ['companyNo', 'like', '%' . $param['companyNo'] . '%'];
        if ($param['customer_code'] != '') $where[] = ['customer_code', 'like', '%' . $param['customer_code'] . '%'];

        $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);

    }

}