screen/application/admin/controller/GoodsSku.php

<?php

namespace app\admin\controller;

use app\common\controller\Backend;

/**
 * 商品列管理
 *
 * @icon fa fa-circle-o
 */
class GoodsSku extends Backend
{
    protected $noNeedRight=['bindList'];
    public function _initialize()
    {
        parent::_initialize(); // TODO: Change the autogenerated stub
        $this->model=new \app\admin\model\GoodsSku;
    }

    public function bind_list(){
        $name=input('name');
        $page=input('pageNumber')?:1;
        $limit=input('pageSize')?:10;
        $map=input('custom/a')?:[];
        $value=input('searchValue');
        if($name){
            $map[]=[
                ['goods.name','like',"{$name}"],
                ['goods_sku.name','like',"{$name}"],
                'or'
            ];
        }
        if($value){
            $map['goods_sku.id']=['in',$value];
        }
        $info=$this->model::show()
            ->join('goods','goods.id=goods_sku.goods_id')
            ->where($map)
            ->field([
                'goods_sku.id','goods.name as goods_name','goods_sku.name',
            ])
            ->paginate($limit,false,['page'=>$page]);

        foreach ($info->items() as &$sku){
            $sku['name']=sprintf("商品：%s-规格：%s",$sku['goods_name'],$sku['name']);
        }

        return json([
            'list'=>$info->items(),
            'total'=>$info->total(),
        ]);
    }
}