55 行
1.3 KiB
PHP
可执行文件
55 行
1.3 KiB
PHP
可执行文件
<?php
|
|
|
|
namespace Common\Model;
|
|
/**
|
|
* 商户规格模型
|
|
* Class SkuMGoodsModel
|
|
* @package Common\Model
|
|
*/
|
|
//[1.8.50]
|
|
class SkuMGoodsModel extends BaseModel
|
|
{
|
|
protected $tableName = 'retail_sku_mgoods';
|
|
protected $fields = array(
|
|
'id',
|
|
'merchantid',
|
|
'mgoods_id',
|
|
'sku_id_list',
|
|
'purch_price',
|
|
'online_price',
|
|
'retail_price',
|
|
'goods_img',
|
|
'goods_num',
|
|
'sku_num',
|
|
'more_num',
|
|
'less_num',
|
|
'shop_mem_price',
|
|
'store_mem_price',
|
|
'plus_price',
|
|
'addtime',
|
|
'status',
|
|
'state',
|
|
'type',
|
|
'sku_goods_number',
|
|
'sku_code',
|
|
'pd_num',
|
|
'goods_img_id',
|
|
'shop_mem_integral',
|
|
'plus_mem_integral',
|
|
'store_mem_integral',
|
|
'weight_value',
|
|
'third_goods_code',
|
|
);
|
|
|
|
//查询规格信息
|
|
public function getSkuGoodsList($where, $field = 'k.*', $order = 'k.id asc')
|
|
{
|
|
$info = $this->alias('k')
|
|
->join('ls_retail_sale_goods as s on k.id=s.sku_id and s.attribute_state=2')
|
|
->where($where)
|
|
->field($field)
|
|
->order($order)
|
|
->select();
|
|
return $info;
|
|
}
|
|
} |