Skip to content

Stmt Unknown FieldType 245 order_detail #395

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
domyway opened this issue Jun 25, 2019 · 1 comment · Fixed by #614
Closed

Stmt Unknown FieldType 245 order_detail #395

domyway opened this issue Jun 25, 2019 · 1 comment · Fixed by #614

Comments

@domyway
Copy link
Contributor

domyway commented Jun 25, 2019 


CREATE TABLE `hj_order_preview` (
  `id` int(13) NOT NULL COMMENT '主键',
  `buyer_id` bigint(13) NOT NULL COMMENT '买家ID',
  `order_sn` bigint(13) NOT NULL COMMENT '预生成的订单号',
  `order_detail` json NOT NULL COMMENT '预生成的详细订单信息，和购物车信息一样',
  `is_del` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
  `add_time` int(13) NOT NULL COMMENT '添加时间',
  `last_update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上次更新时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='订单预生成表，购物车阶段生成';

--
-- Dumping data for table `hj_order_preview`
--

INSERT INTO `hj_order_preview` (`id`, `buyer_id`, `order_sn`, `order_detail`, `is_del`, `add_time`, `last_update_time`) VALUES
(1, 95891865464386, 13376222192996417, '1111222', 0, 1479983995, '2016-11-24 10:39:55'),
(2, 95891865464381, 26752446663434370, '3', 0, 1479984134, '2016-11-24 10:42:14'),
(3, 95891865464388, 53504896673399044, '{\"score\": \"3238\", \"coupon\": {}, \"activity\": [{\"title\": \"\", \"p_type\": \"subject\", \"brand_id\": 0, \"end_date\": \"\", \"image_url\": \"\", \"start_date\": \"\", \"coupon_code\": \"\", \"sub_activity\": [{\"title\": \"\", \"sub_title\": \"\", \"goods_info\": [{\"gc_id\": \"3\", \"is_fav\": 0, \"pre_id\": \"21,1\", \"cart_id\": \"371153\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1473945027\", \"brand_id\": \"44\", \"goods_id\": \"1000260\", \"common_id\": \"96346974446783\", \"goods_num\": \"10\", \"origin_id\": \"7\", \"freight_id\": \"1\", \"goods_attr\": \"\", \"goods_desc\": \"小P老师研发！底妆必备神器\", \"goods_name\": \"即魅JMIXP 丝质水漾妆前乳\", \"goods_spec\": \"30ml\", \"goods_type\": \"normal\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1ap5gvbij1bt9kual2a1qpj2b3d.jpg\", \"goods_price\": \"78.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"166\", \"is_selected\": \"1\", \"online_time\": \"1470374894\", \"origin_desc\": \"台湾正品\", \"platform_id\": \"6957475221475\", \"pre_rule_id\": \"0\", \"origin_image\": \"http://static.huajuanmall.com/country/o_1ankauvv41blfbuq1urd3p313ba9.png\", \"goods_rule_id\": \"0\", \"goods_discount\": \"4.9\", \"goods_hj_price\": \"0.00\", \"belong_activity\": [{\"id\": \"21\", \"title\": \"优惠1 新购物车1\"}], \"goods_marketprice\": \"158.00\", \"replenishment_time\": \"0\"}, {\"gc_id\": \"2\", \"is_fav\": 0, \"pre_id\": \"0\", \"cart_id\": \"371152\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1473945011\", \"brand_id\": \"67\", \"goods_id\": \"1000185\", \"common_id\": \"96187163274729\", \"goods_num\": \"1\", \"origin_id\": \"2\", \"freight_id\": \"1\", \"goods_attr\": \"\", \"goods_desc\": \"贵妇水的好伙伴\", \"goods_name\": \"无印良品MuJi 压缩纸膜\", \"goods_spec\": \"20枚/袋\", \"goods_type\": \"normal\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1amsrcbde1eib1ig81rjqpej1sv9d.jpg\", \"goods_price\": \"33.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"206\", \"is_selected\": \"1\", \"online_time\": \"1468294121\", \"origin_desc\": \"日本正品\", \"platform_id\": \"4547315011902\", \"pre_rule_id\": \"0\", \"origin_image\": \"http://static.huajuanmall.com/country/o_1ajldh68d1c91bo418o7sfnh6vo.png\", \"goods_rule_id\": \"0\", \"goods_discount\": \"5.9\", \"goods_hj_price\": \"0.00\", \"goods_marketprice\": \"56.00\", \"replenishment_time\": \"1476239031\"}, {\"gc_id\": \"3\", \"is_fav\": 0, \"pre_id\": \"0\", \"cart_id\": \"371151\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1473945010\", \"brand_id\": \"55\", \"goods_id\": \"1000301\", \"common_id\": \"96437339476093\", \"goods_num\": \"1\", \"origin_id\": \"7\", \"freight_id\": \"1\", \"goods_attr\": \"\", \"goods_desc\": \"柔软不伤眼\", \"goods_name\": \"Akuma超强电力防水眼线笔-深邃棕\", \"goods_spec\": \"正常规格\", \"goods_type\": \"normal\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1aqejujiv12b61fsktbnhep1f64d.jpg\", \"goods_price\": \"69.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"219\", \"is_selected\": \"1\", \"online_time\": \"1472038607\", \"origin_desc\": \"台湾正品\", \"platform_id\": \"4712106670457\", \"pre_rule_id\": \"0\", \"origin_image\": \"http://static.huajuanmall.com/country/o_1ankauvv41blfbuq1urd3p313ba9.png\", \"goods_rule_id\": \"0\", \"goods_discount\": \"5\", \"goods_hj_price\": \"0.00\", \"goods_marketprice\": \"139.00\", \"replenishment_time\": \"1473145340\"}, {\"gc_id\": \"3\", \"is_fav\": 0, \"pre_id\": \"0\", \"cart_id\": \"371150\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1473945009\", \"brand_id\": \"52\", \"goods_id\": \"1000180\", \"common_id\": \"96186999948877\", \"goods_num\": \"1\", \"origin_id\": \"2\", \"freight_id\": \"1\", \"goods_attr\": \"\", \"goods_desc\": \"帮你节约1/2化妆水\", \"goods_name\": \"尤妮佳 柔软化妆棉40片\", \"goods_spec\": \"80枚/盒\", \"goods_type\": \"normal\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1amsorq25v4e1fm2tl7ord1pnkd.jpg\", \"goods_price\": \"22.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"249\", \"is_selected\": \"1\", \"online_time\": \"0\", \"origin_desc\": \"日本正品\", \"platform_id\": \"4903111478064\", \"pre_rule_id\": \"0\", \"origin_image\": \"http://static.huajuanmall.com/country/o_1ajldh68d1c91bo418o7sfnh6vo.png\", \"goods_rule_id\": \"0\", \"goods_discount\": \"4.9\", \"goods_hj_price\": \"0.00\", \"goods_marketprice\": \"45.00\", \"replenishment_time\": \"1476158620\"}, {\"gc_id\": \"3\", \"is_fav\": 0, \"pre_id\": \"0\", \"cart_id\": \"371149\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1473945006\", \"brand_id\": \"45\", \"goods_id\": \"1000139\", \"common_id\": \"96028932018588\", \"goods_num\": \"1\", \"origin_id\": \"7\", \"freight_id\": \"1\", \"goods_attr\": \"自然色\", \"goods_desc\": \"彩妆大师Kevin研发\", \"goods_name\": \"BM零油光晶漾持妆气垫粉饼\", \"goods_spec\": \"13g\", \"goods_type\": \"normal\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1akkrp7tl1vmu1hko4h91b8g1slfd.jpg\", \"goods_price\": \"158.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"1080\", \"is_selected\": \"1\", \"online_time\": \"0\", \"origin_desc\": \"台湾正品\", \"platform_id\": \"6951076013552\", \"pre_rule_id\": \"0\", \"origin_image\": \"http://static.huajuanmall.com/country/o_1ankauvv41blfbuq1urd3p313ba9.png\", \"goods_rule_id\": \"0\", \"goods_discount\": \"6.6\", \"goods_hj_price\": \"0.00\", \"goods_marketprice\": \"238.00\", \"replenishment_time\": \"0\"}], \"sub_activity_price\": 360, \"sub_activity_marketprice\": 636}], \"activity_price\": 360, \"activity_marketprice\": 636}], \"cartCount\": 14, \"score_rmb\": 10, \"cart_score\": 0, \"header_tip\": \"购物满98元会免运费哟~\", \"freight_diff\": 0, \"freight_full\": \"98.00\", \"freight_text\": \"\", \"user_address\": {\"uid\": \"95891865464386\", \"address\": \"大唐路109号\", \"area_id\": \"45057\", \"city_id\": \"78\", \"add_time\": \"1473846678\", \"area_info\": \"河北省 保定市 莲池区\", \"id_number\": \"\", \"mob_phone\": \"18210747784\", \"tel_phone\": \"\", \"true_name\": \"大山\", \"address_id\": \"21623\", \"is_default\": \"1\", \"province_id\": \"3\"}, \"buy_sku_limit\": 10, \"cash_settlement\": {\"total_price\": 360, \"total_market_price\": 636}, \"use_coupon_code\": \"\", \"pay_freight_text\": \"\"}', 1, 1479984236, '2016-11-24 10:43:56'),
(4, 95891865464386, 53505389013221638, '{\"score\": \"274\", \"coupon\": {}, \"activity\": [{\"title\": \"\", \"p_type\": \"subject\", \"brand_id\": 0, \"end_date\": \"\", \"image_url\": \"\", \"start_date\": \"\", \"coupon_code\": \"\", \"sub_activity\": [{\"title\": \"\", \"sub_title\": \"\", \"goods_info\": [{\"gc_id\": \"3\", \"is_fav\": 0, \"pre_id\": \"21,1\", \"cart_id\": \"371153\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1473945027\", \"brand_id\": \"44\", \"goods_id\": \"1000260\", \"common_id\": \"96346974446783\", \"goods_num\": \"10\", \"origin_id\": \"7\", \"freight_id\": \"1\", \"goods_attr\": \"\", \"goods_desc\": \"小P老师研发！底妆必备神器\", \"goods_name\": \"即魅JMIXP 丝质水漾妆前乳\", \"goods_spec\": \"30ml\", \"goods_type\": \"normal\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1ap5gvbij1bt9kual2a1qpj2b3d.jpg\", \"goods_price\": \"78.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"166\", \"is_selected\": \"1\", \"online_time\": \"1470374894\", \"origin_desc\": \"台湾正品\", \"platform_id\": \"6957475221475\", \"pre_rule_id\": \"0\", \"origin_image\": \"http://static.huajuanmall.com/country/o_1ankauvv41blfbuq1urd3p313ba9.png\", \"goods_rule_id\": \"0\", \"goods_discount\": \"4.9\", \"goods_hj_price\": \"0.00\", \"belong_activity\": [{\"id\": \"21\", \"title\": \"优惠1 新购物车1\"}], \"goods_marketprice\": \"158.00\", \"replenishment_time\": \"0\"}, {\"gc_id\": \"2\", \"is_fav\": 0, \"pre_id\": \"0\", \"cart_id\": \"371152\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1473945011\", \"brand_id\": \"67\", \"goods_id\": \"1000185\", \"common_id\": \"96187163274729\", \"goods_num\": \"1\", \"origin_id\": \"2\", \"freight_id\": \"1\", \"goods_attr\": \"\", \"goods_desc\": \"贵妇水的好伙伴\", \"goods_name\": \"无印良品MuJi 压缩纸膜\", \"goods_spec\": \"20枚/袋\", \"goods_type\": \"normal\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1amsrcbde1eib1ig81rjqpej1sv9d.jpg\", \"goods_price\": \"33.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"206\", \"is_selected\": \"1\", \"online_time\": \"1468294121\", \"origin_desc\": \"日本正品\", \"platform_id\": \"4547315011902\", \"pre_rule_id\": \"0\", \"origin_image\": \"http://static.huajuanmall.com/country/o_1ajldh68d1c91bo418o7sfnh6vo.png\", \"goods_rule_id\": \"0\", \"goods_discount\": \"5.9\", \"goods_hj_price\": \"0.00\", \"goods_marketprice\": \"56.00\", \"replenishment_time\": \"1476239031\"}, {\"gc_id\": \"3\", \"is_fav\": 0, \"pre_id\": \"0\", \"cart_id\": \"371151\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1473945010\", \"brand_id\": \"55\", \"goods_id\": \"1000301\", \"common_id\": \"96437339476093\", \"goods_num\": \"1\", \"origin_id\": \"7\", \"freight_id\": \"1\", \"goods_attr\": \"\", \"goods_desc\": \"柔软不伤眼\", \"goods_name\": \"Akuma超强电力防水眼线笔-深邃棕\", \"goods_spec\": \"正常规格\", \"goods_type\": \"normal\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1aqejujiv12b61fsktbnhep1f64d.jpg\", \"goods_price\": \"69.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"219\", \"is_selected\": \"1\", \"online_time\": \"1472038607\", \"origin_desc\": \"台湾正品\", \"platform_id\": \"4712106670457\", \"pre_rule_id\": \"0\", \"origin_image\": \"http://static.huajuanmall.com/country/o_1ankauvv41blfbuq1urd3p313ba9.png\", \"goods_rule_id\": \"0\", \"goods_discount\": \"5\", \"goods_hj_price\": \"0.00\", \"goods_marketprice\": \"139.00\", \"replenishment_time\": \"1473145340\"}, {\"gc_id\": \"3\", \"is_fav\": 0, \"pre_id\": \"0\", \"cart_id\": \"371150\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1473945009\", \"brand_id\": \"52\", \"goods_id\": \"1000180\", \"common_id\": \"96186999948877\", \"goods_num\": \"1\", \"origin_id\": \"2\", \"freight_id\": \"1\", \"goods_attr\": \"\", \"goods_desc\": \"帮你节约1/2化妆水\", \"goods_name\": \"尤妮佳 柔软化妆棉40片\", \"goods_spec\": \"80枚/盒\", \"goods_type\": \"normal\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1amsorq25v4e1fm2tl7ord1pnkd.jpg\", \"goods_price\": \"22.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"249\", \"is_selected\": \"1\", \"online_time\": \"0\", \"origin_desc\": \"日本正品\", \"platform_id\": \"4903111478064\", \"pre_rule_id\": \"0\", \"origin_image\": \"http://static.huajuanmall.com/country/o_1ajldh68d1c91bo418o7sfnh6vo.png\", \"goods_rule_id\": \"0\", \"goods_discount\": \"4.9\", \"goods_hj_price\": \"0.00\", \"goods_marketprice\": \"45.00\", \"replenishment_time\": \"1476158620\"}, {\"gc_id\": \"3\", \"is_fav\": 0, \"pre_id\": \"0\", \"cart_id\": \"371149\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1473945006\", \"brand_id\": \"45\", \"goods_id\": \"1000139\", \"common_id\": \"96028932018588\", \"goods_num\": \"1\", \"origin_id\": \"7\", \"freight_id\": \"1\", \"goods_attr\": \"自然色\", \"goods_desc\": \"彩妆大师Kevin研发\", \"goods_name\": \"BM零油光晶漾持妆气垫粉饼\", \"goods_spec\": \"13g\", \"goods_type\": \"normal\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1akkrp7tl1vmu1hko4h91b8g1slfd.jpg\", \"goods_price\": \"158.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"1080\", \"is_selected\": \"1\", \"online_time\": \"0\", \"origin_desc\": \"台湾正品\", \"platform_id\": \"6951076013552\", \"pre_rule_id\": \"0\", \"origin_image\": \"http://static.huajuanmall.com/country/o_1ankauvv41blfbuq1urd3p313ba9.png\", \"goods_rule_id\": \"0\", \"goods_discount\": \"6.6\", \"goods_hj_price\": \"0.00\", \"goods_marketprice\": \"238.00\", \"replenishment_time\": \"0\"}], \"sub_activity_price\": 360, \"sub_activity_marketprice\": 636}], \"activity_price\": 360, \"activity_marketprice\": 636}], \"cartCount\": 14, \"score_rmb\": 10, \"cart_score\": 0, \"header_tip\": \"提示文案\", \"freight_diff\": 0, \"freight_full\": \"98.00\", \"freight_text\": \"\", \"user_address\": {\"uid\": \"95891865464386\", \"address\": \"大唐路109号\", \"area_id\": \"45057\", \"city_id\": \"78\", \"add_time\": \"1473846678\", \"area_info\": \"河北省 保定市 莲池区\", \"id_number\": \"\", \"mob_phone\": \"18210747784\", \"tel_phone\": \"\", \"true_name\": \"大山\", \"address_id\": \"21623\", \"is_default\": \"1\", \"province_id\": \"3\"}, \"buy_sku_limit\": 10, \"cash_settlement\": {\"total_price\": 360, \"total_market_price\": 636}, \"use_coupon_code\": \"\", \"pay_freight_text\": \"\"}', 0, 1479999261, '2016-11-24 14:54:21'),
(5, 95891865464386, 13376692331032641, '{\"score\": \"274\", \"coupon\": {}, \"activity\": [{\"title\": \"\", \"p_type\": \"subject\", \"brand_id\": 0, \"end_date\": \"\", \"image_url\": \"\", \"start_date\": \"\", \"coupon_code\": \"\", \"sub_activity\": [{\"title\": \"\", \"sub_title\": \"\", \"goods_info\": [{\"gc_id\": \"2\", \"is_fav\": 0, \"pre_id\": \"0\", \"cart_id\": \"371152\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1473945011\", \"brand_id\": \"67\", \"goods_id\": \"1000185\", \"common_id\": \"96187163274729\", \"goods_num\": \"1\", \"origin_id\": \"2\", \"freight_id\": \"1\", \"goods_attr\": \"\", \"goods_desc\": \"贵妇水的好伙伴\", \"goods_name\": \"无印良品MuJi 压缩纸膜\", \"goods_spec\": \"20枚/袋\", \"goods_type\": \"normal\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1amsrcbde1eib1ig81rjqpej1sv9d.jpg\", \"goods_price\": \"33.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"206\", \"is_selected\": \"1\", \"online_time\": \"1468294121\", \"origin_desc\": \"日本正品\", \"platform_id\": \"4547315011902\", \"pre_rule_id\": \"0\", \"origin_image\": \"http://static.huajuanmall.com/country/o_1ajldh68d1c91bo418o7sfnh6vo.png\", \"goods_rule_id\": \"0\", \"goods_discount\": \"5.9\", \"goods_hj_price\": \"0.00\", \"goods_marketprice\": \"56.00\", \"replenishment_time\": \"1476239031\"}, {\"gc_id\": \"3\", \"is_fav\": 0, \"pre_id\": \"0\", \"cart_id\": \"371151\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1473945010\", \"brand_id\": \"55\", \"goods_id\": \"1000301\", \"common_id\": \"96437339476093\", \"goods_num\": \"1\", \"origin_id\": \"7\", \"freight_id\": \"1\", \"goods_attr\": \"\", \"goods_desc\": \"柔软不伤眼\", \"goods_name\": \"Akuma超强电力防水眼线笔-深邃棕\", \"goods_spec\": \"正常规格\", \"goods_type\": \"normal\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1aqejujiv12b61fsktbnhep1f64d.jpg\", \"goods_price\": \"69.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"219\", \"is_selected\": \"1\", \"online_time\": \"1472038607\", \"origin_desc\": \"台湾正品\", \"platform_id\": \"4712106670457\", \"pre_rule_id\": \"0\", \"origin_image\": \"http://static.huajuanmall.com/country/o_1ankauvv41blfbuq1urd3p313ba9.png\", \"goods_rule_id\": \"0\", \"goods_discount\": \"5\", \"goods_hj_price\": \"0.00\", \"goods_marketprice\": \"139.00\", \"replenishment_time\": \"1473145340\"}, {\"gc_id\": \"3\", \"is_fav\": 0, \"pre_id\": \"0\", \"cart_id\": \"371150\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1473945009\", \"brand_id\": \"52\", \"goods_id\": \"1000180\", \"common_id\": \"96186999948877\", \"goods_num\": \"1\", \"origin_id\": \"2\", \"freight_id\": \"1\", \"goods_attr\": \"\", \"goods_desc\": \"帮你节约1/2化妆水\", \"goods_name\": \"尤妮佳 柔软化妆棉40片\", \"goods_spec\": \"80枚/盒\", \"goods_type\": \"normal\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1amsorq25v4e1fm2tl7ord1pnkd.jpg\", \"goods_price\": \"22.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"249\", \"is_selected\": \"1\", \"online_time\": \"0\", \"origin_desc\": \"日本正品\", \"platform_id\": \"4903111478064\", \"pre_rule_id\": \"0\", \"origin_image\": \"http://static.huajuanmall.com/country/o_1ajldh68d1c91bo418o7sfnh6vo.png\", \"goods_rule_id\": \"0\", \"goods_discount\": \"4.9\", \"goods_hj_price\": \"0.00\", \"goods_marketprice\": \"45.00\", \"replenishment_time\": \"1476158620\"}, {\"gc_id\": \"3\", \"is_fav\": 0, \"pre_id\": \"0\", \"cart_id\": \"371149\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1473945006\", \"brand_id\": \"45\", \"goods_id\": \"1000139\", \"common_id\": \"96028932018588\", \"goods_num\": \"1\", \"origin_id\": \"7\", \"freight_id\": \"1\", \"goods_attr\": \"自然色\", \"goods_desc\": \"彩妆大师Kevin研发\", \"goods_name\": \"BM零油光晶漾持妆气垫粉饼\", \"goods_spec\": \"13g\", \"goods_type\": \"normal\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1akkrp7tl1vmu1hko4h91b8g1slfd.jpg\", \"goods_price\": \"158.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"1080\", \"is_selected\": \"1\", \"online_time\": \"0\", \"origin_desc\": \"台湾正品\", \"platform_id\": \"6951076013552\", \"pre_rule_id\": \"0\", \"origin_image\": \"http://static.huajuanmall.com/country/o_1ankauvv41blfbuq1urd3p313ba9.png\", \"goods_rule_id\": \"0\", \"goods_discount\": \"6.6\", \"goods_hj_price\": \"0.00\", \"goods_marketprice\": \"238.00\", \"replenishment_time\": \"0\"}], \"sub_activity_price\": 282, \"sub_activity_goodsprice\": 282, \"sub_activity_marketprice\": 478}], \"activity_price\": 282, \"activity_goodsprice\": 282, \"activity_marketprice\": 478}], \"cartCount\": 14, \"score_rmb\": 10, \"cart_score\": 0, \"freight_id\": \"1\", \"header_tip\": \"提示文案\", \"freight_diff\": 0, \"freight_full\": \"98.00\", \"freight_text\": \"\", \"shipping_fee\": 0, \"user_address\": {\"uid\": \"95891865464386\", \"address\": \"大唐路109号\", \"area_id\": \"45057\", \"city_id\": \"78\", \"add_time\": \"1473846678\", \"area_info\": \"河北省 保定市 莲池区\", \"id_number\": \"\", \"mob_phone\": \"18210747784\", \"tel_phone\": \"\", \"true_name\": \"大山\", \"address_id\": \"21623\", \"is_default\": \"1\", \"province_id\": \"3\"}, \"buy_sku_limit\": 10, \"cash_settlement\": {\"total_price\": 282, \"total_market_price\": 478}, \"use_coupon_code\": \"\", \"pay_freight_text\": \"\"}', 0, 1480041385, '2016-11-25 02:36:25'),
(6, 95891865464386, 26753388143288450, '{\"score\": \"274\", \"coupon\": {}, \"activity\": [{\"title\": \"\", \"p_type\": \"subject\", \"brand_id\": 0, \"end_date\": \"\", \"image_url\": \"\", \"start_date\": \"\", \"coupon_code\": \"\", \"sub_activity\": [{\"title\": \"\", \"sub_title\": \"\", \"goods_info\": [{\"gc_id\": \"2\", \"is_fav\": 0, \"pre_id\": \"0\", \"cart_id\": \"371152\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1473945011\", \"brand_id\": \"67\", \"goods_id\": \"1000185\", \"common_id\": \"96187163274729\", \"goods_num\": \"1\", \"origin_id\": \"2\", \"freight_id\": \"1\", \"goods_attr\": \"\", \"goods_desc\": \"贵妇水的好伙伴\", \"goods_name\": \"无印良品MuJi 压缩纸膜\", \"goods_spec\": \"20枚/袋\", \"goods_type\": \"normal\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1amsrcbde1eib1ig81rjqpej1sv9d.jpg\", \"goods_price\": \"33.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"206\", \"is_selected\": \"1\", \"online_time\": \"1468294121\", \"origin_desc\": \"日本正品\", \"platform_id\": \"4547315011902\", \"pre_rule_id\": \"0\", \"origin_image\": \"http://static.huajuanmall.com/country/o_1ajldh68d1c91bo418o7sfnh6vo.png\", \"goods_rule_id\": \"0\", \"goods_discount\": \"5.9\", \"goods_hj_price\": \"0.00\", \"goods_marketprice\": \"56.00\", \"replenishment_time\": \"1476239031\"}, {\"gc_id\": \"3\", \"is_fav\": 0, \"pre_id\": \"0\", \"cart_id\": \"371151\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1473945010\", \"brand_id\": \"55\", \"goods_id\": \"1000301\", \"common_id\": \"96437339476093\", \"goods_num\": \"1\", \"origin_id\": \"7\", \"freight_id\": \"1\", \"goods_attr\": \"\", \"goods_desc\": \"柔软不伤眼\", \"goods_name\": \"Akuma超强电力防水眼线笔-深邃棕\", \"goods_spec\": \"正常规格\", \"goods_type\": \"normal\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1aqejujiv12b61fsktbnhep1f64d.jpg\", \"goods_price\": \"69.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"219\", \"is_selected\": \"1\", \"online_time\": \"1472038607\", \"origin_desc\": \"台湾正品\", \"platform_id\": \"4712106670457\", \"pre_rule_id\": \"0\", \"origin_image\": \"http://static.huajuanmall.com/country/o_1ankauvv41blfbuq1urd3p313ba9.png\", \"goods_rule_id\": \"0\", \"goods_discount\": \"5\", \"goods_hj_price\": \"0.00\", \"goods_marketprice\": \"139.00\", \"replenishment_time\": \"1473145340\"}, {\"gc_id\": \"3\", \"is_fav\": 0, \"pre_id\": \"0\", \"cart_id\": \"371150\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1473945009\", \"brand_id\": \"52\", \"goods_id\": \"1000180\", \"common_id\": \"96186999948877\", \"goods_num\": \"1\", \"origin_id\": \"2\", \"freight_id\": \"1\", \"goods_attr\": \"\", \"goods_desc\": \"帮你节约1/2化妆水\", \"goods_name\": \"尤妮佳 柔软化妆棉40片\", \"goods_spec\": \"80枚/盒\", \"goods_type\": \"normal\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1amsorq25v4e1fm2tl7ord1pnkd.jpg\", \"goods_price\": \"22.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"249\", \"is_selected\": \"1\", \"online_time\": \"0\", \"origin_desc\": \"日本正品\", \"platform_id\": \"4903111478064\", \"pre_rule_id\": \"0\", \"origin_image\": \"http://static.huajuanmall.com/country/o_1ajldh68d1c91bo418o7sfnh6vo.png\", \"goods_rule_id\": \"0\", \"goods_discount\": \"4.9\", \"goods_hj_price\": \"0.00\", \"goods_marketprice\": \"45.00\", \"replenishment_time\": \"1476158620\"}, {\"gc_id\": \"3\", \"is_fav\": 0, \"pre_id\": \"0\", \"cart_id\": \"371149\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1473945006\", \"brand_id\": \"45\", \"goods_id\": \"1000139\", \"common_id\": \"96028932018588\", \"goods_num\": \"1\", \"origin_id\": \"7\", \"freight_id\": \"1\", \"goods_attr\": \"自然色\", \"goods_desc\": \"彩妆大师Kevin研发\", \"goods_name\": \"BM零油光晶漾持妆气垫粉饼\", \"goods_spec\": \"13g\", \"goods_type\": \"normal\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1akkrp7tl1vmu1hko4h91b8g1slfd.jpg\", \"goods_price\": \"158.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"1080\", \"is_selected\": \"1\", \"online_time\": \"0\", \"origin_desc\": \"台湾正品\", \"platform_id\": \"6951076013552\", \"pre_rule_id\": \"0\", \"origin_image\": \"http://static.huajuanmall.com/country/o_1ankauvv41blfbuq1urd3p313ba9.png\", \"goods_rule_id\": \"0\", \"goods_discount\": \"6.6\", \"goods_hj_price\": \"0.00\", \"goods_marketprice\": \"238.00\", \"replenishment_time\": \"0\"}], \"sub_activity_price\": 282, \"sub_activity_goodsprice\": 282, \"sub_activity_marketprice\": 478}], \"activity_price\": 282, \"activity_goodsprice\": 282, \"activity_marketprice\": 478}], \"cartCount\": 14, \"score_rmb\": 10, \"cart_score\": 0, \"freight_id\": \"1\", \"header_tip\": \"提示文案\", \"freight_diff\": 0, \"freight_full\": \"98.00\", \"freight_text\": \"\", \"shipping_fee\": 0, \"user_address\": {\"uid\": \"95891865464386\", \"address\": \"大唐路109号\", \"area_id\": \"45057\", \"city_id\": \"78\", \"add_time\": \"1473846678\", \"area_info\": \"河北省 保定市 莲池区\", \"id_number\": \"\", \"mob_phone\": \"18210747784\", \"tel_phone\": \"\", \"true_name\": \"大山\", \"address_id\": \"21623\", \"is_default\": \"1\", \"province_id\": \"3\"}, \"buy_sku_limit\": 10, \"cash_settlement\": {\"total_price\": 282, \"total_market_price\": 478}, \"use_coupon_code\": \"\", \"pay_freight_text\": \"\"}', 0, 1480041597, '2016-11-25 02:39:57'),
(7, 95891865464386, 54045386032464134, '{\"score\": 100, \"coupon\": {\"availableCouponList\": [], \"notAvailableCouponList\": []}, \"act_hash\": {\"0_0_1000000\": \"1\"}, \"activity\": [{\"id\": 0, \"title\": \"\", \"p_type\": \"subject\", \"brand_id\": 0, \"end_date\": 0, \"h5_title\": \"\", \"image_url\": \"\", \"cart_count\": 1, \"start_date\": 0, \"coupon_code\": [], \"sub_activity\": [{\"id\": 0, \"suit\": [], \"title\": \"\", \"p_type\": \"default\", \"p_price\": 0, \"full_diff\": 0, \"sub_title\": \"\", \"diff_price\": 0, \"full_price\": 0, \"goods_info\": [{\"gc_id\": \"3\", \"is_fav\": 0, \"pre_id\": \"0\", \"cart_id\": \"2303100\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1496476177\", \"brand_id\": \"5\", \"goods_id\": \"1000000\", \"is_valid\": 1, \"common_id\": \"96005774422689\", \"goods_num\": \"1\", \"origin_id\": \"2\", \"suit_hash\": \"\", \"freight_id\": \"1\", \"goods_attr\": \"\", \"goods_desc\": \"保湿又防晒，我有小金刚\", \"goods_name\": \"安耐晒金瓶防晒霜\", \"goods_spec\": \"60g\", \"goods_type\": \"1\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1akabcqk9i1i16g1lv81h9lbnkd.jpg\", \"goods_price\": \"179.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"90\", \"is_selected\": \"1\", \"online_time\": \"0\", \"origin_desc\": \"日本正品\", \"platform_id\": \"4901872036509\", \"pre_rule_id\": 0, \"origin_image\": \"http://static.huajuanmall.com/country/o_1ajldh68d1c91bo418o7sfnh6vo.png\", \"goods_rule_id\": \"0\", \"spec_price_id\": \"0\", \"goods_discount\": \"6\", \"goods_hj_price\": \"0.00\", \"belong_activity\": [], \"goods_marketprice\": \"300.00\", \"replenishment_time\": \"0\"}], \"subject_id\": 0, \"sub_activity_price\": \"179.00\", \"sub_activity_goods_price\": \"179.00\", \"sub_activity_marketprice\": \"300.00\"}], \"activity_price\": \"179.00\", \"activity_goodsprice\": \"179.00\", \"activity_marketprice\": \"300.00\"}], \"order_sn\": 54045386032464134, \"cartCount\": 1, \"score_rmb\": null, \"cart_score\": 0, \"freight_id\": 0, \"header_tip\": null, \"freight_tip\": \"\", \"forbid_score\": 0, \"freight_diff\": 0, \"freight_full\": 0, \"freight_text\": \"\", \"order_reward\": [], \"shipping_fee\": 0, \"user_address\": {}, \"buy_sku_limit\": 10, \"forbid_coupon\": 0, \"shipping_type\": [], \"cash_settlement\": {\"total_price\": \"179.00\", \"total_goods_price\": \"179.00\", \"total_market_price\": \"300.00\"}, \"use_coupon_code\": \"\", \"order_preferential\": [{\"p_txt\": \"商品总计\", \"p_type\": \"goods_amount\", \"goods_id\": 0, \"p_amount\": \"179.00\"}, {\"p_txt\": \"运费\", \"p_type\": \"freight\", \"goods_id\": 0, \"p_amount\": 0}]}', 0, 1496478662, '2017-06-03 08:31:02'),
(8, 95891865464386, 54045648996352263, '{\"score\": 100, \"coupon\": {\"availableCouponList\": [], \"notAvailableCouponList\": []}, \"act_hash\": {\"0_0_1000000\": \"1\"}, \"activity\": [{\"id\": 0, \"title\": \"\", \"p_type\": \"subject\", \"brand_id\": 0, \"end_date\": 0, \"h5_title\": \"\", \"image_url\": \"\", \"cart_count\": 1, \"start_date\": 0, \"coupon_code\": [], \"sub_activity\": [{\"id\": 0, \"suit\": [], \"title\": \"\", \"p_type\": \"default\", \"p_price\": 0, \"full_diff\": 0, \"sub_title\": \"\", \"diff_price\": 0, \"full_price\": 0, \"goods_info\": [{\"gc_id\": \"3\", \"is_fav\": 0, \"pre_id\": \"0\", \"cart_id\": \"2303100\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1496476177\", \"brand_id\": \"5\", \"goods_id\": \"1000000\", \"is_valid\": 1, \"common_id\": \"96005774422689\", \"goods_num\": \"1\", \"origin_id\": \"2\", \"suit_hash\": \"\", \"freight_id\": \"1\", \"goods_attr\": \"\", \"goods_desc\": \"保湿又防晒，我有小金刚\", \"goods_name\": \"安耐晒金瓶防晒霜\", \"goods_spec\": \"60g\", \"goods_type\": \"1\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1akabcqk9i1i16g1lv81h9lbnkd.jpg\", \"goods_price\": \"179.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"90\", \"is_selected\": \"1\", \"online_time\": \"0\", \"origin_desc\": \"日本正品\", \"platform_id\": \"4901872036509\", \"pre_rule_id\": 0, \"origin_image\": \"http://static.huajuanmall.com/country/o_1ajldh68d1c91bo418o7sfnh6vo.png\", \"goods_rule_id\": \"0\", \"spec_price_id\": \"0\", \"goods_discount\": \"6\", \"goods_hj_price\": \"0.00\", \"belong_activity\": [], \"goods_marketprice\": \"300.00\", \"replenishment_time\": \"0\"}], \"subject_id\": 0, \"sub_activity_price\": \"179.00\", \"sub_activity_goods_price\": \"179.00\", \"sub_activity_marketprice\": \"300.00\"}], \"activity_price\": \"179.00\", \"activity_goodsprice\": \"179.00\", \"activity_marketprice\": \"300.00\"}], \"order_sn\": 54045648996352263, \"cartCount\": 1, \"score_rmb\": null, \"cart_score\": 0, \"freight_id\": 0, \"header_tip\": null, \"freight_tip\": \"\", \"forbid_score\": 0, \"freight_diff\": 0, \"freight_full\": 0, \"freight_text\": \"\", \"order_reward\": [], \"shipping_fee\": 0, \"user_address\": {}, \"buy_sku_limit\": 10, \"forbid_coupon\": 0, \"shipping_type\": [], \"cash_settlement\": {\"total_price\": \"179.00\", \"total_goods_price\": \"179.00\", \"total_market_price\": \"300.00\"}, \"use_coupon_code\": \"\", \"order_preferential\": [{\"p_txt\": \"商品总计\", \"p_type\": \"goods_amount\", \"goods_id\": 0, \"p_amount\": \"179.00\"}, {\"p_txt\": \"运费\", \"p_type\": \"freight\", \"goods_id\": 0, \"p_amount\": 0}]}', 0, 1496486687, '2017-06-03 10:44:47'),
(9, 95891865464386, 108091298542879240, '{\"score\": 100, \"coupon\": {\"availableCouponList\": [], \"notAvailableCouponList\": []}, \"act_hash\": {\"0_0_1000000\": \"1\"}, \"activity\": [{\"id\": 0, \"title\": \"\", \"p_type\": \"subject\", \"brand_id\": 0, \"end_date\": 0, \"h5_title\": \"\", \"image_url\": \"\", \"cart_count\": 1, \"start_date\": 0, \"coupon_code\": [], \"sub_activity\": [{\"id\": 0, \"suit\": [], \"title\": \"\", \"p_type\": \"default\", \"p_price\": 0, \"full_diff\": 0, \"sub_title\": \"\", \"diff_price\": 0, \"full_price\": 0, \"goods_info\": [{\"gc_id\": \"3\", \"is_fav\": 0, \"pre_id\": \"0\", \"cart_id\": \"2303100\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1496476177\", \"brand_id\": \"5\", \"goods_id\": \"1000000\", \"is_valid\": 1, \"common_id\": \"96005774422689\", \"goods_num\": \"1\", \"origin_id\": \"2\", \"suit_hash\": \"\", \"freight_id\": \"1\", \"goods_attr\": \"\", \"goods_desc\": \"保湿又防晒，我有小金刚\", \"goods_name\": \"安耐晒金瓶防晒霜\", \"goods_spec\": \"60g\", \"goods_type\": \"1\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1akabcqk9i1i16g1lv81h9lbnkd.jpg\", \"goods_price\": \"179.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"90\", \"is_selected\": \"1\", \"online_time\": \"0\", \"origin_desc\": \"日本正品\", \"platform_id\": \"4901872036509\", \"pre_rule_id\": 0, \"origin_image\": \"http://static.huajuanmall.com/country/o_1ajldh68d1c91bo418o7sfnh6vo.png\", \"goods_rule_id\": \"0\", \"spec_price_id\": \"0\", \"goods_discount\": \"6\", \"goods_hj_price\": \"0.00\", \"belong_activity\": [], \"goods_marketprice\": \"300.00\", \"replenishment_time\": \"0\"}], \"subject_id\": 0, \"sub_activity_price\": \"179.00\", \"sub_activity_goods_price\": \"179.00\", \"sub_activity_marketprice\": \"300.00\"}], \"activity_price\": \"179.00\", \"activity_goodsprice\": \"179.00\", \"activity_marketprice\": \"300.00\"}], \"order_sn\": 108091298542879240, \"cartCount\": 1, \"score_rmb\": null, \"cart_score\": 0, \"freight_id\": 0, \"header_tip\": null, \"freight_tip\": \"\", \"forbid_score\": 0, \"freight_diff\": 0, \"freight_full\": 0, \"freight_text\": \"\", \"order_reward\": [], \"shipping_fee\": 0, \"user_address\": {}, \"buy_sku_limit\": 10, \"forbid_coupon\": 0, \"shipping_type\": [], \"cash_settlement\": {\"total_price\": \"179.00\", \"total_goods_price\": \"179.00\", \"total_market_price\": \"300.00\"}, \"use_coupon_code\": \"\", \"order_preferential\": [{\"p_txt\": \"商品总计\", \"p_type\": \"goods_amount\", \"goods_id\": 0, \"p_amount\": \"179.00\"}, {\"p_txt\": \"运费\", \"p_type\": \"freight\", \"goods_id\": 0, \"p_amount\": 0}]}', 0, 1496486696, '2017-06-03 10:44:56'),
(10, 95891865464386, 108091308296012297, '{\"score\": 100, \"coupon\": {\"availableCouponList\": [], \"notAvailableCouponList\": [{\"code\": \"SH2016\", \"title\": \"全场可用\", \"end_date\": \"1469938200\", \"extra_data\": {\"up_price\": 200, \"parameters\": \"$price\", \"show_amount_text\": \"￥20\"}, \"start_date\": \"1465963800\", \"coupon_rule\": \"return $price >= 200 ? $price - 20 : $price;\", \"coupon_type\": \"fullCut\", \"description\": \"全场满200减20\", \"expire_time\": \"604800\"}, {\"code\": \"SH2016\", \"title\": \"全场可用\", \"end_date\": \"1469938200\", \"extra_data\": {\"up_price\": 200, \"parameters\": \"$price\", \"show_amount_text\": \"￥20\"}, \"start_date\": \"1465963800\", \"coupon_rule\": \"return $price >= 200 ? $price - 20 : $price;\", \"coupon_type\": \"fullCut\", \"description\": \"全场满200减20\", \"expire_time\": \"604800\"}, {\"code\": \"SH2016\", \"title\": \"全场可用\", \"end_date\": \"1473436799\", \"extra_data\": {\"up_price\": 200, \"parameters\": \"$price\", \"show_amount_text\": \"￥20\"}, \"start_date\": \"1472745600\", \"coupon_rule\": \"return $price >= 200 ? $price - 20 : $price;\", \"coupon_type\": \"fullCut\", \"description\": \"全场满200减20\", \"expire_time\": \"604800\"}, {\"code\": \"welcomecoupon\", \"title\": \"全场可用\", \"end_date\": \"1474128000\", \"extra_data\": {\"parameters\": \"$price\", \"limit_amount\": 0, \"show_amount_text\": \"￥5\"}, \"start_date\": \"1473868800\", \"coupon_rule\": \"return $price < 0 ? $price : $price - 5;\", \"coupon_type\": \"cash\", \"description\": \"5元迎新优惠券\", \"expire_time\": \"604800\"}, {\"code\": \"WH2016\", \"title\": \"全场可用\", \"end_date\": \"1472745599\", \"extra_data\": {\"parameters\": \"$price\", \"limit_amount\": 0, \"show_amount_text\": \"￥10\"}, \"start_date\": \"1470067200\", \"coupon_rule\": \"return $price < 0 ? $price : $price - 10;\", \"coupon_type\": \"cash\", \"description\": \"10元代金券\", \"expire_time\": \"1209600\"}, {\"code\": \"wx10010\", \"title\": \"全场可用\", \"end_date\": \"1469938200\", \"extra_data\": {\"up_price\": 100, \"parameters\": \"$price\", \"show_amount_text\": \"￥10\"}, \"start_date\": \"1465875600\", \"coupon_rule\": \"return $price >= 100 ? $price - 10 : $price;\", \"coupon_type\": \"fullCut\", \"description\": \"满100减10\", \"expire_time\": \"604800\"}, {\"code\": \"wx20015\", \"title\": \"全场可用\", \"end_date\": \"1471795199\", \"extra_data\": {\"up_price\": 200, \"parameters\": \"$price\", \"show_amount_text\": \"￥15\"}, \"start_date\": \"1471104000\", \"coupon_rule\": \"return $price >= 200 ? $price - 15 : $price;\", \"coupon_type\": \"fullCut\", \"description\": \"满200减15\", \"expire_time\": \"604800\"}, {\"code\": \"wx30025\", \"title\": \"全场可用\", \"end_date\": \"1469938200\", \"extra_data\": {\"up_price\": 300, \"parameters\": \"$price\", \"show_amount_text\": \"￥25\"}, \"start_date\": \"1465875600\", \"coupon_rule\": \"return $price >= 300 ? $price - 25 : $price;\", \"coupon_type\": \"fullCut\", \"description\": \"满300减25\", \"expire_time\": \"604800\"}, {\"code\": \"wx30025\", \"title\": \"全场可用\", \"end_date\": \"1470585599\", \"extra_data\": {\"up_price\": 300, \"parameters\": \"$price\", \"show_amount_text\": \"￥25\"}, \"start_date\": \"1469894400\", \"coupon_rule\": \"return $price >= 300 ? $price - 25 : $price;\", \"coupon_type\": \"fullCut\", \"description\": \"满300减25\", \"expire_time\": \"604800\"}, {\"code\": \"wx30025\", \"title\": \"全场可用\", \"end_date\": \"1472831999\", \"extra_data\": {\"up_price\": 300, \"parameters\": \"$price\", \"show_amount_text\": \"￥25\"}, \"start_date\": \"1472140800\", \"coupon_rule\": \"return $price >= 300 ? $price - 25 : $price;\", \"coupon_type\": \"fullCut\", \"description\": \"满300减25\", \"expire_time\": \"604800\"}]}, \"act_hash\": {\"0_0_1000000\": \"1\"}, \"activity\": [{\"id\": 0, \"title\": \"\", \"p_type\": \"subject\", \"brand_id\": 0, \"end_date\": 0, \"h5_title\": \"\", \"image_url\": \"\", \"cart_count\": 1, \"start_date\": 0, \"coupon_code\": [], \"sub_activity\": [{\"id\": 0, \"suit\": [], \"title\": \"\", \"p_type\": \"default\", \"p_price\": 0, \"full_diff\": 0, \"sub_title\": \"\", \"diff_price\": 0, \"full_price\": 0, \"goods_info\": [{\"gc_id\": \"3\", \"is_fav\": 0, \"pre_id\": \"0\", \"cart_id\": \"2303100\", \"f_score\": 0, \"s_score\": 0, \"add_time\": \"1496476177\", \"brand_id\": \"5\", \"goods_id\": \"1000000\", \"is_valid\": 1, \"common_id\": \"96005774422689\", \"goods_num\": \"1\", \"origin_id\": \"2\", \"suit_hash\": \"\", \"freight_id\": \"1\", \"goods_attr\": \"\", \"goods_desc\": \"保湿又防晒，我有小金刚\", \"goods_name\": \"安耐晒金瓶防晒霜\", \"goods_spec\": \"60g\", \"goods_type\": \"1\", \"is_arrival\": 0, \"pay_derate\": 0, \"expiry_time\": \"0\", \"goods_image\": \"http://static.huajuanmall.com/images/goods/o_1akabcqk9i1i16g1lv81h9lbnkd.jpg\", \"goods_price\": \"179.00\", \"goods_score\": \"0\", \"goods_state\": \"1\", \"goods_stock\": \"90\", \"is_selected\": \"1\", \"online_time\": \"0\", \"origin_desc\": \"日本正品\", \"platform_id\": \"4901872036509\", \"pre_rule_id\": 0, \"origin_image\": \"http://static.huajuanmall.com/country/o_1ajldh68d1c91bo418o7sfnh6vo.png\", \"goods_rule_id\": \"0\", \"spec_price_id\": \"0\", \"goods_discount\": \"6\", \"goods_hj_price\": \"0.00\", \"belong_activity\": [], \"goods_marketprice\": \"300.00\", \"replenishment_time\": \"0\"}], \"subject_id\": 0, \"sub_activity_price\": \"179.00\", \"sub_activity_goods_price\": \"179.00\", \"sub_activity_marketprice\": \"300.00\"}], \"activity_price\": \"179.00\", \"activity_goodsprice\": \"179.00\", \"activity_marketprice\": \"300.00\"}], \"order_sn\": 108091308296012297, \"cartCount\": 1, \"score_rmb\": 10, \"cart_score\": 0, \"freight_id\": 0, \"header_tip\": \"\", \"freight_tip\": \"\", \"forbid_score\": 0, \"freight_diff\": 0, \"freight_full\": 0, \"freight_text\": \"\", \"order_reward\": [], \"shipping_fee\": 0, \"user_address\": {\"uid\": \"95891865464386\", \"address\": \"青口镇三兴花园G幢3单元16楼\", \"area_id\": \"2091\", \"city_id\": \"168\", \"add_time\": \"0\", \"area_info\": \"江苏省 连云港市 赣榆县\", \"id_number\": \"\", \"mob_phone\": \"18652094382\", \"tel_phone\": \"\", \"true_name\": \"黄燕\", \"address_id\": \"24164\", \"is_default\": \"1\", \"province_id\": \"10\"}, \"buy_sku_limit\": 10, \"forbid_coupon\": 0, \"shipping_type\": [], \"special_coupon\": [], \"cash_settlement\": {\"total_price\": \"179.00\", \"total_goods_price\": \"179.00\", \"total_market_price\": \"300.00\"}, \"use_coupon_code\": \"\", \"order_preferential\": [{\"p_txt\": \"商品总计\", \"p_type\": \"goods_amount\", \"goods_id\": 0, \"p_amount\": \"179.00\", \"pre_rule_id\": 0}, {\"p_txt\": \"运费\", \"p_type\": \"freight\", \"goods_id\": 0, \"p_amount\": 0, \"pre_rule_id\": 0}]}', 0, 1496486845, '2017-06-03 10:47:25');


// work fine
sql := "SELECT * FROM hj_order_preview WHERE id = 10"
res, err := client.Execute(sql)

//err : Stmt Unknown FieldType 245 order_detail
sql := "SELECT * FROM hj_order_preview WHERE id = ?"
res, err := client.Execute(sql, 10)
@domyway
Copy link
Contributor Author

domyway commented Jun 25, 2019

resultset.go

ParseBinary function case code add MYSQL_TYPE_JSON work fine

case MYSQL_TYPE_DECIMAL, MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_VARCHAR,
MYSQL_TYPE_BIT, MYSQL_TYPE_ENUM, MYSQL_TYPE_SET, MYSQL_TYPE_TINY_BLOB,
MYSQL_TYPE_MEDIUM_BLOB, MYSQL_TYPE_LONG_BLOB, MYSQL_TYPE_BLOB,
MYSQL_TYPE_VAR_STRING, MYSQL_TYPE_STRING, MYSQL_TYPE_GEOMETRY, MYSQL_TYPE_JSON:

@domyway domyway mentioned this issue Aug 22, 2021
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

support MYSQL_TYPE_JSON domyway/go-mysql
1 participant
@domyway