<?php
/**
 * Created by PhpStorm.
 * User: Ziy
 * Date: 14/9/9
 * Time: 下午12:13
 */

namespace YHMOrders\SqlMap;


class Shopping
{
    const INSERT_CHANGE_PRICE = 'insert into `shopping_change_price` (agreement_key,buyer_uid,store_id,seller_uid,product_skc,sale_price,agreement_price,buy_number,goods_type,create_time) values (:agreement_key,:buyer_uid,:store_id,:seller_uid,:product_skc,:sale_price,:agreement_price,:buy_number,:goods_type,UNIX_TIMESTAMP())';

    const SELECT_CHANGE_PRICE_BY_KEY = 'select * from `shopping_change_price` where buyer_uid=:buyer_uid and agreement_key=:agreement_key';

    const UPDATE_AGREEMENT_STATUS = 'update shopping_change_price set is_buyer=:is_buyer,order_code=:order_code where agreement_key=:agreement_key';
    
    const INSERT_SHIPPING_ORDER_CHANGE_PRICE = 'INSERT INTO shopping_change_price(agreement_key,buyer_uid,store_id,seller_uid,product_skc,sale_price,agreement_price,agreement_shipping_fee, order_shipping_fee, order_last_shipping_fee, order_amount, order_code,buy_number,goods_type,create_time) VALUES 
    		(:agreement_key,:buyer_uid,:store_id,:seller_uid,:product_skc,:sale_price,:agreement_price,:agreement_shipping_fee,:order_shipping_fee,:order_last_shipping_fee,:order_amount,:order_code, :buy_number,:goods_type,UNIX_TIMESTAMP())';
}