/*获取商家产品列表*/
public static function getProductList($request,$seller_id)
{
$where=[];
$where['seller_id']=$seller_id;
/*配送类型*/
if($request['shipment']&&in_array($request['shipment'],self::$shipments))
{
$where['fulfillmentchannel']=$request['shipment'];
}
/*关键词搜索*/
$search_like=[];
if($request['search'])
{
$search=trim($request['search']);
$search_like = ['or', ['like', 'title', $search], ['like', 'asin', $search], ['like', 'sellersku', $search], ['like', 'tag', $search]];
}
/*tag标签*/
if($request['tag'])
{
$where['tag']=$request['tag'];
}
/*asin类型*/
if($request['asin_type']=='parent')
{
$where[]=['<>','parentasin',''];
}
$prodcuts=SellerProduct::find()
->select(['title','asin','sellersku','tag'])
->asArray()
->where($where)
->andWhere($search_like)
->limit(10)
// ->createCommand()->getRawSql();exit;
->all();
// return SellerProduct::getAsinBySellerId($seller_id);
}
SELECT `title`, `asin`, `sellersku`, `tag` FROM `tbl_seller_product` WHERE (`seller_id`=’A20ANC9S9NO5G6′) AND ((`title` LIKE ‘%222%’) OR (`asin` LIKE ‘%222%’) OR (`sellersku` LIKE ‘%222%’) OR (`tag` LIKE ‘%222%’)) LIMIT 10