<?php

namespace Retail\Model;

//[1.7.90]

/**
 * 门店商品标签关联表
 * Class GoodsLabelLinkModel
 * @package Retail\Model
 */
class GoodsLabelLinkModel extends \Common\Model\BaseModel
{
    protected $tableName = 'goods_label_link';
    protected $fields = array(
        'id',                           //int(11) NOT NULL AUTO_INCREMENT,
        'merchant_id',                  //int(11) DEFAULT '0' COMMENT '商户id',
        'store_id',                     //int(11) DEFAULT '0' COMMENT '门店id',
        'label_id',                     //int(11) DEFAULT '0' COMMENT 'label_inventory 表id',
        'goods_id',                     //int(11) DEFAULT '0' COMMENT '门店商品id',
        'operate_id',                   //int(11) DEFAULT '0' COMMENT '操作人员id',
        'add_time',                     //int(11) DEFAULT '0' COMMENT '添加时间',
    );

    /**
     * 查询关联商品信息
     */
    public function getLabelBelongGoods($map, $field, $order, $page, $limit)
    {
        $result['list'] = $this->alias('link')
            ->join('ls_retail_goods as goods on link.goods_id = goods.id')
            ->where($map)
            ->field($field)
            ->order($order)
            ->page($page, $limit)
            ->select();

        $result['count'] = $this->alias('link')
            ->join('ls_retail_goods as goods on link.goods_id = goods.id')
            ->where($map)
            ->order($order)
            ->count();
        return $result;
    }
}