<?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;
    }
}