Cart.php
642 Bytes
<?php
namespace YHMOrders\SqlMap\Cart;
class Cart {
const COUNT_ProductSku_Uid_LastPrice = 'select count(product_sku) as nums from cart where product_sku=:product_sku and uid=:uid and last_price=:last_price';
const Set_Goods_By_Uid='insert into cart(uid,product_sku,product_skc,salse_price,last_price,buy_number,store_id,goods_type,is_change,create_time) values(:uid,:product_sku,:product_skc,:salse_price,:last_price,:buy_number,:store_id,:goods_type,:is_change,UNIX_TIMESTAMP())';
const UPDATE_ProductSku_NUMS='update cart set buy_number=buy_number+:buy_number where product_sku=:product_sku and uid=:uid and last_price=:last_price ';
}