platform / yohobuy-doc · Files

合同管理

合同状态

操作	status	oprations
暂存	100	3
保存(待审核)	500	3
待审核->驳回	900	3
待审核->审核通过	200	4
审核通过->续约	500	2
续约->审核通过	200	2
续约->驳回	900	2
审核通过->解约	500	1
解约->审核通过	200	1(end_agreement:Y)
解约->驳回	900	1

例如，根据品牌id获取jit供应商，筛选有效合同

<select id="selectValidJitSupplierByAgreementId" resultMap="BaseResultMap">
        <bind name="size" value="@com.yohobuy.platform.common.util.SqlUtils@getSize(agreementIds)" />
        select <include refid="Base_Column_List" />
        from agreement
        <where>
        <if test="agreementIds !=null and size!=0">
            agreement_id in
            <foreach collection="agreementIds" item="agreementId" open="(" separator="," close=")">
                #{agreementId}
            </foreach>
        </if>
        and agreement_end_time > FROM_UNIXTIME(UNIX_TIMESTAMP(),'%Y-%m-%d') and
        operations != 3 and `status` in (200,500,900) and end_agreement = 'N' and business_model = 7
        </where>
</select>

根据品牌id获取可用分类或根据品牌id和JIT供应商ID获取可用分类

接口名： /AgreementRest/getAllSortByBrandId

入参

{
 "brandId":1550,
}
or
{
 "brandId":1550,
 "supplierId":"1418"
}

---

属性名称	类型	例子	说明
brandId	int	1550	品牌ID
supplierId	String	1418	供应商ID（可选）

---

返回

{
  "code": 200,
  "data": [
    1,
    1,
    1,
    1
  ],
  "message": "可用分类"
}

根据品牌id获取jit供应商

接口名： /AgreementRest/getJitSupplierByBrandId

入参

{
    "brandId":1550
}

---

属性名称	类型	例子	说明
brandId	int	1550	品牌ID

---

返回

{
  "code": 200,
  "data": [
    {
      "id": 1418,
      "supplierId": 1418,
      "supplierName": "1232323",
      "text": "1232323"
    }
  ],
  "message": "品牌关联的jit供应商"
}