cxinv/app/admin/controller/InvCat.php

<?php


namespace app\admin\controller;
use app\admin\BaseController;
use think\App;
use think\facade\Db;

class InvCat extends BaseController{
    public function __construct(App $app) {parent::__construct($app);}

    public function AddGood(){

    }

    public function GoodList(){
        $page =isset($this->post['page'])&&  $this->post['page']!="" ? intval($this->post['page']) :1;
        $size =isset($this->post['size'])&&  $this->post['size']!="" ? intval($this->post['size']) :15;
        $condition =[];
        $spuCode=isset($this->post['spuCode'])&&$this->post['spuCode']!=''?trim($this->post['spuCode']):"";
        if($spuCode!="") $condition[]=["spuCode","like","%$spuCode%"];
        $good_name=isset($this->post['good_name'])&&$this->post['good_name']!=''?trim($this->post['good_name']):"";
        if($good_name!="") $condition[]=["good_name","like","%$good_name%"];
        $companyNo=isset($this->post['companyNo'])&&$this->post['companyNo']!=''?trim($this->post['companyNo']):"";
        if($companyNo!="") $condition[]=["companyNo","like","%$companyNo%"];
        $supplierNo=isset($this->post['supplierNo'])&&$this->post['supplierNo']!=''?trim($this->post['supplierNo']):"";
        if($supplierNo!="") $condition[]=["supplierNo","like","%$supplierNo%"];
         $creater=isset($this->post['creater'])&&$this->post['creater']!=''?trim($this->post['creater']):"";
        if($creater!="") $condition[]=["creater","like","%$creater%"];
        $count=Db::name("good")->where($condition)->count();
        $total=ceil($count/$size);
        $page = $page>=$total? intval($total):$page;
        $list =Db::name("good")->where($condition)->order("addtime desc")->page($page,$size)->select()->toArray();
        foreach ($list as &$value){
            $company =Db::name("company_info")->where(["companyNo"=>$value['companyNo']])->find();
            $value['companyName']=$company['company_name']??"";
            $supplier =Db::name("supplier_info")->where(["code"=>$value["supplierNo"]])->find();
            $value["supplierName"]=$supplier["name"]??"";
        }
        return app_show(0,"获取成功",["list"=>$list,"count"=>$count]);
    }
}