Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- insert into sl_cart (tenant_id, ou_id, partner_id, doc_no, doc_date, remark, status_doc, create_user_id, create_datetime, update_user_id, update_datetime, version, member_id, stock_point_id, cart_type, flg_notifikasi_cancel, checkout_datetime) values (11, 14, 3749, 'CART001', '20161104', 'TESTING', 'R', -1, '20161104150000', -1, '20161104150000', 0, 922, 470, 'MEMBER', 'N', '20161104150000');
- insert into sl_cart (tenant_id, ou_id, partner_id, doc_no, doc_date, remark, status_doc, create_user_id, create_datetime, update_user_id, update_datetime, version, member_id, stock_point_id, cart_type, flg_notifikasi_cancel, checkout_datetime) values (11, 14, 3749, 'CART002', '20161104', 'TESTING', 'R', -1, '20161104150000', -1, '20161104150000', 0, 253940, '470', 'MEMBER', 'N', '20161104150000');
- insert into sl_cart_item (sl_cart_id, product_catalog_id, qty, catalog_price, discount_member, discount_member_amount, discount_promo, discount_promo_amount, price_after_discount, total_price_after_disc, so_mlm_id, create_user_id, create_datetime, update_user_id, update_datetime, version) values (50000, 53655, 1, 99900, 25, 24975, 0, 0, 74925, 74925, 71695, -1, '20161104150000', -1, '20161104150000', 0);
- insert into sl_cart_item (sl_cart_id, product_catalog_id, qty, catalog_price, discount_member, discount_member_amount, discount_promo, discount_promo_amount, price_after_discount, total_price_after_disc, so_mlm_id, create_user_id, create_datetime, update_user_id, update_datetime, version) values (50000, 53575, 1, 59900, 25, 14975, 0, 0, 44925, 44925, 71695, -1, '20161104150000', -1, '20161104150000', 0);
- insert into sl_cart_item (sl_cart_id, product_catalog_id, qty, catalog_price, discount_member, discount_member_amount, discount_promo, discount_promo_amount, price_after_discount, total_price_after_disc, so_mlm_id, create_user_id, create_datetime, update_user_id, update_datetime, version) values (50001, 53465, 1, 279900, 25, 69975, 0, 0, 209925, 209925, 71695, -1, '20161104150000', -1, '20161104150000', 0);
- insert into sl_cart_item (sl_cart_id, product_catalog_id, qty, catalog_price, discount_member, discount_member_amount, discount_promo, discount_promo_amount, price_after_discount, total_price_after_disc, so_mlm_id, create_user_id, create_datetime, update_user_id, update_datetime, version) values (50001, 53418, 1, 189900, 25, 47475, 0, 0, 142425, 142425, 71695, -1, '20161104150000', -1, '20161104150000', 0);
- insert into sl_cart_item (sl_cart_id, product_catalog_id, qty, catalog_price, discount_member, discount_member_amount, discount_promo, discount_promo_amount, price_after_discount, total_price_after_disc, so_mlm_id, create_user_id, create_datetime, update_user_id, update_datetime, version) values (50001, 53156, 2, 89900, 25, 22475, 0, 0, 67425, 134850, 71695, -1, '20161104150000', -1, '20161104150000', 0);
- update sl_so_mlm_item_ext set member_id = 922, ref_item_id=90000, ref_id=50000 where so_mlm_item_id = 1923290;
- update sl_so_mlm_item_ext set member_id = 922, ref_item_id=90001, ref_id=50000 where so_mlm_item_id = 1923301;
- update sl_so_mlm_item_ext set member_id = 253940, ref_item_id =90002 , ref_id=50001 where so_mlm_item_id = 1923302;
- update sl_so_mlm_item_ext set member_id =253940 , ref_item_id =90003 , ref_id=50001 where so_mlm_item_id = 1923305;
- update sl_so_mlm_item_ext set member_id = 253940, ref_item_id =90004 , ref_id=50001 where so_mlm_item_id = 1923306;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement