 
 LOCK TABLES `role` WRITE;
 /*!40000 ALTER TABLE `role` DISABLE KEYS */;
-INSERT INTO `role` VALUES ('ee479a4b-f445-4130-a295-572e6126ec96','api组','MODULE_9e6596c1-9fda-4cd2-b20a-1cce7e572a65,MODULE_567662ac-6632-4891-a0cd-24cafc8da0b8,MODULE_5c24bb39-ce5c-4dbb-a3dd-5d720f2472c0,INTERFACE_62bde6e0-988b-475f-bfdf-76203455ec57,4a8eee1c-4863-41f3-9ba8-d11c255de46f,5358c830-7a24-46d8-924e-ff47f3e8fb01,de6f4d42-bf2e-4e1b-a0b8-a706cf24addb,','API模块【模块】,退货退款模块【模块】,编辑器模块【模块】,试用ptapi【接口】,模块管理【菜单】,菜单管理【菜单】,错误码管理【菜单】,','2016-04-01 04:22:07',1);
+INSERT INTO `role` VALUES ('ee479a4b-f445-4130-a295-572e6126ec96','test','MODULE_0,MODULE_62bde6e0-988b-475f-bfdf-76203455ec57,MODULE_9e6596c1-9fda-4cd2-b20a-1cce7e572a65,MODULE_567662ac-6632-4891-a0cd-24cafc8da0b8,MODULE_5c24bb39-ce5c-4dbb-a3dd-5d720f2472c0,INTERFACE_62bde6e0-988b-475f-bfdf-76203455ec57,SETTING,DICTIONARY_62bde6e0-988b-475f-bfdf-76203455ec57,DICTIONARY_e230314f-081d-480e-a018-7e690a642dd6,DICTIONARY_e634d522-aad8-4cdb-9c13-105ee7b17eab,1736697e-fb91-495b-a88e-3b72f898e6ac,ebd05976-ea7e-42af-b198-b853a9477136,4a8eee1c-4863-41f3-9ba8-d11c255de46f,5358c830-7a24-46d8-924e-ff47f3e8fb01,de6f4d42-bf2e-4e1b-a0b8-a706cf24addb,','项目管理,试用ptapi【模块】,API项目【模块】,退货退款模块【模块】,编辑器模块【模块】,试用ptapi【接口】,系统设置管理,试用ptapi,财务API项目,AppApi项目,数据字典管理【菜单】,系统设置【菜单】,模块管理【菜单】,菜单管理【菜单】,错误码管理【菜单】,','2016-04-01 04:22:07',1);
 /*!40000 ALTER TABLE `role` ENABLE KEYS */;
 UNLOCK TABLES;
 


LOCK TABLES `setting` WRITE;
/*!40000 ALTER TABLE `setting` DISABLE KEYS */;
INSERT INTO `setting` VALUES ('062f01ae-e50b-4dd3-808b-b4a6d65eeadc','LOGO','resources/upload/images/2016-04-03/033813PIeddK.png','网站主logo，可以直接在value中填写绝对链接地址，也可以自行上传图片','2016-04-01 04:23:18',1,'IMAGE'),('75fd1bf6-1813-4b98-925a-69c098756f08','VISITCODE','true','游客访问私密模块输入密码的同时是否需要输入图像验证码？true为需要，其他为不需要','2016-04-03 08:32:55',0,'TEXT'),('b153c675-5ef7-45f6-bbea-98d2e41e4938','ADMINHELP','帮助中心','<blockquote><p>   感谢使用CrapApi应用接口管理系统！</p></blockquote><p><br/></p><p>常见问题：</p><ol><li style=\"color: rgb(85, 85, 85);background-color: rgb(255, 255, 255);\">什么是【游客图形验证码】？如果开启了【游客图形验证码】，则游客在访问私密模块时不仅需要输入访问密码，而且需要输入【游客图形验证码】，开启【游客图形验证码】能有效防止暴力破解模块访问密码。<br/></li><li style=\"color: rgb(85, 85, 85);background-color: rgb(255, 255, 255);\">什么是【模块密码】？【模块密码】对后台管理没有任何影响，若为模块添加了密码，当游客访问该模块时需要输入访问密码才能浏览，【模块密码】只在当前模块有效，即子模块不能继承父模块的密码。故建议将【模块密码】设置在需要控制访问的接口所属的直接模块上。若多个模块密码一致，游客输入密码后无需再次输入，直接就可以访问。如没有开启游客图形验证码，则关闭浏览器后密码将自动失效，如开启了图形验证码，则用户刷新站点或关闭浏览器后密码将自动失效。</li><li style=\"color: rgb(85, 85, 85);background-color: rgb(255, 255, 255);\">为什么游客输入过访问密码后，再次访问依然需要再次输入访问密码？（1）系统只保留用户最后一次输入的访问密码，如果多个模块需要访问密码，则当用户交叉访问时，后一个密码将覆盖前一个密码，因此需要再次输入访问密码。（2）CrapApi为单页应用，即站点在第一次打开后，以后所有点击都是局部刷新，如果系统开启了【游客图形验证码】，则当用户手动刷新页面，【游客图形验证码】将失效，因此需要再次输入访问密码。</li></ol>','2016-04-02 20:25:43',0,'RICHTEXT'),('b361a416-41fd-478f-809f-356a078bcb88','HELP','帮助中心','<blockquote><p>   感谢使用CrapApi应用接口管理系统！</p></blockquote><p><br/></p><p>常见问题：</p><ol><li>如何添加</li></ol>','2016-04-02 17:40:48',0,'RICHTEXT'),('b5b8f273-83f8-4774-9ea4-f2102f78b242','VERIFICATIONCODE','true','是否开启安全登录？ture为开启，其他为不开启，开启后登录将需要输入图片验证码','2016-04-03 05:52:14',0,'TEXT'),('de94c622-02fc-4b39-9cc5-0c24870ac21f','TITLE','CrapApi|Api接口管理系统','站点标题','2016-04-02 11:09:13',1,'TEXT'),('e0dec957-5043-4c6e-9225-960fbc401116','ICON','http://static.biyao.com/pc/favicon.ico','站点ICON图标（浏览器标题栏图标）','2016-04-02 11:49:41',1,'IMAGE'),('ef157b7f-cc53-4a41-9679-d243d478023c','SECRETKEY','crapApiKey','秘钥，用于cookie加密等','2016-04-02 15:31:00',1,'TEXT');
/*!40000 ALTER TABLE `setting` ENABLE KEYS */;
UNLOCK TABLES;



LOCK TABLES `interface` WRITE;
/*!40000 ALTER TABLE `interface` DISABLE KEYS */;
INSERT INTO `interface` VALUES ('2e4c0946-61d7-4a63-bb3f-4bf5b3279f4d','http://xxx/activityOrder/8/list.do','post and get','[{\"name\":\"activity_id\",\"necessary\":\"true\",\"type\":\"long\",\"parameterType\":\"HEADER\",\"remark\":\"试用活动id\"},{\"name\":\"page\",\"necessary\":\"false\",\"type\":\"int\",\"parameterType\":\"PARAMETER\",\"remark\":\"页码 如果为空，则返回第一页的数据\"},{\"name\":\"pageSize\",\"necessary\":\"false\",\"type\":\"int\",\"parameterType\":\"PARAMETER\",\"remark\":\"每页显示的数量，如果pageSize为空，则不分页，一次选择所有数据\"},{\"name\":\"88888\",\"necessary\":\"true\",\"type\":\"5\",\"parameterType\":\"HEADER\",\"remark\":\"555\"}]','请求地址:http://xxx/activityOrder/8/list.do\r\n请求头:\r\n	activity_id=xxxx\r\n	88888=xxxx\r\n请求参数:\r\n	page=xxxx\r\n	pageSize=xxxx\r\n','[{\"name\":\"page\",\"type\":\"对象\",\"remark\":\"分页信息\"},{\"name\":\"testList\",\"type\":\"数组\",\"remark\":\"试用单列表\"},{\"name\":\"55\",\"type\":\"55\",\"remark\":\"555\"}]','000001,','{\n    \"data\": {\n        \"testList\": [\n            {\n                \"submitTime\": 1456803171000, \n                \"userId\": 1253817, \n                \"userImg\": \"\", \n                \"userName\": \"Ehsan\"\n            }, \n            {\n                \"submitTime\": 1456891539000, \n                \"userId\": 1253817, \n                \"userImg\": \"\", \n                \"userName\": \"Ehsan\"\n            }, \n            {\n                \"submitTime\": 1457170074000, \n                \"userId\": 1927601, \n                \"userImg\": \"\", \n                \"userName\": \"2927602\"\n            }, \n            {\n                \"submitTime\": 1457171696000, \n                \"userId\": 1772231, \n                \"userImg\": \"\", \n                \"userName\": \"snail-阿蒲\"\n            }, \n            {\n                \"submitTime\": 1457184651000, \n                \"userId\": 389, \n                \"userImg\": \"\", \n                \"userName\": \"路上有你\"\n            }, \n            {\n                \"submitTime\": 1457185381000, \n                \"userId\": 4352, \n                \"userImg\": \"\", \n                \"userName\": \"夜月星空\"\n            }, \n            {\n                \"submitTime\": 1457417579000, \n                \"userId\": 1772231, \n                \"userImg\": \"\", \n                \"userName\": \"snail-阿蒲\"\n            }, \n            {\n                \"submitTime\": 1457422208000, \n                \"userId\": 1927601, \n                \"userImg\": \"\", \n                \"userName\": \"EhsanTang\"\n            }, \n            {\n                \"submitTime\": 1458013122000, \n                \"userId\": 1927601, \n                \"userImg\": \"\", \n                \"userName\": \"EhsanTang\"\n            }\n        ], \n        \"testNum\": 9\n    }, \n    \"error\": null, \n    \"page\": {\n        \"allRow\": 15, \n        \"currentPage\": 1, \n        \"size\": 1000, \n        \"start\": 0, \n        \"totalPage\": 1\n    }, \n    \"success\": 1\n}','{\n    \"data\": null, \n    \"error\": {\n        \"code\": \"000001\", \n        \"data\": null, \n        \"message\": \"xxxxxxx\"\n    }, \n    \"page\": null, \n    \"success\": 0\n}',1,'ff0d04ff-a512-4833-b12e-963be5a1475b','试用ptapi前端接口','查询某试用活动已经获得试用资格的试用单','<blockquote><p>   查看当某活动的试用单列表（已经砍价成功，并且已经提交了订单）</p></blockquote>','[{\"createTime\":\"2016-04-01 12:14:20.0\",\"errorCode\":\"000001\",\"errorId\":\"82e675b4-0c11-414d-8640-91ddead4f3b1\",\"errorMsg\":\"系统未知错误\",\"moduleId\":\"62bde6e0-988b-475f-bfdf-76203455ec57\",\"moduleName\":\"试用ptapi\",\"status\":1}]','userName：super | trueName：超级管理员','2016-04-05 12:04:00','2016-04-01 04:12:51'),('2e65d664-db69-48c2-a467-26b713aa5fef','http://xxx/activity/detail.do','post and get','[{\"name\":\"activity_id\",\"necessary\":\"true\",\"type\":\"long\",\"remark\":\"试用活动id\"}]','请求地址:http://xxx/activity/detail.do\r\n请求头:\r\n请求参数:\r\n	activity_id=xxxx\r\n','[{\"name\":\"success\",\"type\":\"int\",\"remark\":\"是否成功：1成功，0失败\"},{\"name\":\"data\",\"type\":\"对象\",\"remark\":\"活动详情\"},{\"name\":\"error\",\"type\":\"对象\",\"remark\":\"错误信息\"}]','','{\n    \"data\": {\n        \"actEndTime\": 1458208910000,\n        \"actId\": 24,\n        \"actStartTime\": 1456308107000,\n        \"actStatus\": 3,\n        \"actStockNum\": 10,\n        \"applyNum\": 128,\n        \"prodDetailPics\": [],\n        \"products\": {\n            \"durations\": 0,\n            \"img\": \"http://img.biyao.com/files/temp/b5/b54684f1e52226fa.png\",\n            \"imgList\": [\n                \"http://img.biyao.com/files/temp/be/be5d30d9c468e357.jpg\",\n                \"http://img.biyao.com/files/temp/68/687616eb0674b806.jpg\"\n            ],\n            \"price\": 114,\n            \"proDl\": \"<p><img src=\\\"http://img.biyao.com/files/data0/2016/02/22/16/productiondetail/data/19216810095_20496_635917561293653289_0.jpg\\\" style=\\\"\\\" title=\\\"8.jpg\\\"/></p><p><img src=\\\"http://img.biyao.com/files/data0/2016/02/22/16/productiondetail/data/19216810095_20496_635917561299403618_0.jpg\\\" style=\\\"\\\" title=\\\"6.jpg\\\"/></p><p><img src=\\\"http://img.biyao.com/files/data0/2016/02/22/16/productiondetail/data/19216810095_20496_635917561292153203_0.jpg\\\" style=\\\"\\\" title=\\\"7.jpg\\\"/></p>\",\n            \"proId\": 1300155001,\n            \"proName\": \"试用-开发测试-001\",\n            \"shelfStatus\": 1,\n            \"sizeList\": [\n                {\n                    \"des\": \"红色\",\n                    \"img_l\": \"\",\n                    \"img_s\": \"\",\n                    \"name\": \"颜色\",\n                    \"spec_id\": 265,\n                    \"type\": 1\n                },\n                {\n                    \"des\": \"白色\",\n                    \"img_l\": \"\",\n                    \"img_s\": \"\",\n                    \"name\": \"颜色\",\n                    \"spec_id\": 267,\n                    \"type\": 1\n                },\n                {\n                    \"des\": \"黑色\",\n                    \"img_l\": \"\",\n                    \"img_s\": \"\",\n                    \"name\": \"颜色\",\n                    \"spec_id\": 269,\n                    \"type\": 1\n                },\n                {\n                    \"des\": \"35\",\n                    \"img_l\": \"\",\n                    \"img_s\": \"\",\n                    \"name\": \"尺码\",\n                    \"spec_id\": 266,\n                    \"type\": 1\n                },\n                {\n                    \"des\": \"36\",\n                    \"img_l\": \"\",\n                    \"img_s\": \"\",\n                    \"name\": \"尺码\",\n                    \"spec_id\": 268,\n                    \"type\": 1\n                },\n                {\n                    \"des\": \"37\",\n                    \"img_l\": \"\",\n                    \"img_s\": \"\",\n                    \"name\": \"尺码\",\n                    \"spec_id\": 270,\n                    \"type\": 1\n                }\n            ]\n        },\n        \"reportList\": [\n            {\n                \"repAuthor\": \"路上有你\",\n                \"repContent\": \"<p>323<br/></p>\",\n                \"repId\": 114,\n                \"repImg\": \"http://img.biyao.com/files/data0/bytry/5e8187b706314eb98d2d1be27a10e221.png\",\n                \"repTitle\": \"123\",\n                \"userImg\": \"http://img.biyao.com/files/data0/2015/01/25/14/avatar/big/ebdb6c79-52ce-4c7b-bd68-f71ea4bd9563.jpg\"\n            }\n        ],\n        \"supplier\": {\n            \"supId\": 15,\n            \"supLogo\": \"/data0/2015/01/30/15/storelogo/ed8bf934f9344db8.jpg\",\n            \"supName\": \"北京市回力鞋业有限公司\",\n            \"supPhone\": \"15600899477\"\n        },\n        \"tryNum\": 50,\n        \"verifyTime\": 1459418513000\n    },\n    \"error\": null,\n    \"page\": null,\n    \"success\": 1\n}','{\n    \"data\": null,\n    \"error\": {\n        \"code\": \"000001\",\n        \"data\": null,\n        \"message\": \"活动不存在\"\n    },\n    \"page\": null,\n    \"success\": 0\n}',1,'ff0d04ff-a512-4833-b12e-963be5a1475b','试用ptapi前端接口','查询活动详情','根据活动id查询活动详情','[]','userName：super | trueName：超级管理员','2016-04-05 08:00:00','2016-04-01 04:12:51'),('31ea8a71-547d-4938-a2ec-c877e338845f','http://xxx/activity/3/list.do','post and get','[{\"name\":\"page\",\"necessary\":\"false\",\"type\":\"int\",\"remark\":\"页码 如果为空，则返回第一页的数据\"},{\"name\":\"pageSize\",\"necessary\":\"false\",\"type\":\"int\",\"remark\":\"每页显示的数量，如果pageSize为空，则不分页，一次选择所有数据\"}]','','[{\"name\":\"actList\",\"type\":\"数组\",\"remark\":\"活动列表\"},{\"name\":\"page\",\"type\":\"对象\",\"remark\":\"分页信息\"},{\"name\":\"success\",\"type\":\"int\",\"remark\":\"是否成功：1成功，0失败\"},{\"name\":\"error\",\"type\":\"对象\",\"remark\":\"错误信息\"}]','000001,','{\n    \"data\": {\n        \"actList\": [\n            {\n                \"actEndTime\": 1458208910000,\n                \"actId\": 24,\n                \"actStartTime\": 1456308107000,\n                \"actStatus\": 3,\n                \"actStockNum\": 10,\n                \"applyNum\": 0,\n                \"prodDetailPics\": [],\n                \"products\": {\n                    \"durations\": 0,\n                    \"img\": \"http://img.biyao.com/files/temp/b5/b54684f1e52226fa.png\",\n                    \"imgList\": [\n                        \"http://img.biyao.com/files/temp/be/be5d30d9c468e357.jpg\",\n                        \"http://img.biyao.com/files/temp/68/687616eb0674b806.jpg\"\n                    ],\n                    \"price\": 114,\n                    \"proDl\": \"<p><img src=\\\"http://img.biyao.com/files/data0/2016/02/22/16/productiondetail/data/19216810095_20496_635917561293653289_0.jpg\\\" style=\\\"\\\" title=\\\"8.jpg\\\"/></p><p><img src=\\\"http://img.biyao.com/files/data0/2016/02/22/16/productiondetail/data/19216810095_20496_635917561299403618_0.jpg\\\" style=\\\"\\\" title=\\\"6.jpg\\\"/></p><p><img src=\\\"http://img.biyao.com/files/data0/2016/02/22/16/productiondetail/data/19216810095_20496_635917561292153203_0.jpg\\\" style=\\\"\\\" title=\\\"7.jpg\\\"/></p>\",\n                    \"proId\": 1300155001,\n                    \"proName\": \"试用-开发测试-001\",\n                    \"shelfStatus\": 1,\n                    \"sizeList\": []\n                },\n                \"reportList\": [],\n                \"supplier\": {\n                    \"supId\": 15,\n                    \"supLogo\": \"/data0/2015/01/30/15/storelogo/ed8bf934f9344db8.jpg\",\n                    \"supName\": \"北京市回力鞋业有限公司\",\n                    \"supPhone\": \"15600899477\"\n                },\n                \"tryNum\": 50,\n                \"verifyTime\": 1459418513000\n            },\n            {\n                \"actEndTime\": 1458230399000,\n                \"actId\": 88,\n                \"actStartTime\": 1458144000000,\n                \"actStatus\": 3,\n                \"actStockNum\": 0,\n                \"applyNum\": 0,\n                \"prodDetailPics\": [],\n                \"products\": {\n                    \"durations\": 33,\n                    \"img\": \"http://img.biyao.com/files/temp/2f/2fb2386fb977cda7.png\",\n                    \"imgList\": [],\n                    \"price\": 333,\n                    \"proDl\": \"\",\n                    \"proId\": 1300175043,\n                    \"proName\": \"20160317李毅002\",\n                    \"shelfStatus\": 1,\n                    \"sizeList\": []\n                },\n                \"reportList\": [],\n                \"supplier\": {\n                    \"supId\": 17,\n                    \"supLogo\": \"\",\n                    \"supName\": \"强人鞋业\",\n                    \"supPhone\": \"13621289567\"\n                },\n                \"tryNum\": 1,\n                \"verifyTime\": 1458230399000\n            },\n            {\n                \"actEndTime\": 1458230399000,\n                \"actId\": 87,\n                \"actStartTime\": 1458144000000,\n                \"actStatus\": 3,\n                \"actStockNum\": 9,\n                \"applyNum\": 0,\n                \"prodDetailPics\": [],\n                \"products\": {\n                    \"durations\": 33,\n                    \"img\": \"http://img.biyao.com/files/temp/df/dfcc5bea8abefc71.jpg\",\n                    \"imgList\": [],\n                    \"price\": 333,\n                    \"proDl\": \"\",\n                    \"proId\": 1300175042,\n                    \"proName\": \"20160317李毅001\",\n                    \"shelfStatus\": 1,\n                    \"sizeList\": []\n                },\n                \"reportList\": [],\n                \"supplier\": {\n                    \"supId\": 17,\n                    \"supLogo\": \"\",\n                    \"supName\": \"强人鞋业\",\n                    \"supPhone\": \"13621289567\"\n                },\n                \"tryNum\": 1,\n                \"verifyTime\": 1458230399000\n            }\n        ]\n    },\n    \"error\": null,\n    \"page\": {\n        \"allRow\": 50,\n        \"currentPage\": 1,\n        \"size\": 3,\n        \"start\": 0,\n        \"totalPage\": 17\n    },\n    \"success\": 1\n}','{\n    \"data\": null,\n    \"error\": {\n        \"code\": \"000001\",\n        \"data\": null,\n        \"message\": \"Failed to convert value of type \'java.lang.String\' to required type \'java.lang.Integer\'; nested exception is java.lang.NumberFormatException: For input string: \\\"a\\\"\"\n    },\n    \"page\": null,\n    \"success\": 0\n}',1,'ff0d04ff-a512-4833-b12e-963be5a1475b','试用ptapi前端接口','获取试用活动类表','查询所有状态为3（已发布）的活动，按创建时间降序排列','[{\"errorCode\":\"000001\",\"errorId\":\"82e675b4-0c11-414d-8640-91ddead4f3b1\",\"errorMsg\":\"系统未知错误\",\"moduleId\":\"62bde6e0-988b-475f-bfdf-76203455ec57\",\"moduleName\":\"试用ptapi\"}]','userName：tangtao | trueName：唐韬','2016-04-03 10:33:04','2016-04-01 04:12:51'),('65eb4f2c-4992-4939-8415-1a14056c4e3d','http://xxx/activityReport/detail.do','post and get','[{\"name\":\"activity_report _id\",\"necessary\":\"true\",\"type\":\"long\",\"remark\":\"试用报告id\"}]','','[{\"name\":\"success\",\"type\":\"int\",\"remark\":\"是否成功：1成功，0失败\"},{\"name\":\"data\",\"type\":\"对象\",\"remark\":\"试用报告详情\"}]','000001,','{\n    \"data\":{\n        \"repAuthor\":\"路上有你\",\n        \"repContent\":\"<p>323<br/></p>\",\n        \"repId\":114,\n        \"repImg\":\"http://img.biyao.com/files/data0/bytry/5e8187b706314eb98d2d1be27a10e221.png\",\n        \"repTitle\":\"123\",\n        \"userImg\":\"http://img.biyao.com/files/data0/2015/01/25/14/avatar/big/ebdb6c79-52ce-4c7b-bd68-f71ea4bd9563.jpg\"\n    },\n    \"error\":null,\n    \"page\":null,\n    \"success\":1\n}\n','{\n    \"data\":null,\n    \"error\":{\n        \"code\":\"000001\",\n        \"data\":null,\n        \"message\":\"xxxxx\"\n    },\n    \"page\":null,\n    \"success\":0\n}',1,'ff0d04ff-a512-4833-b12e-963be5a1475b','试用ptapi前端接口','试用报告详情','根据试用报告id查询试用报告详情','[{\"errorCode\":\"000001\",\"errorId\":\"82e675b4-0c11-414d-8640-91ddead4f3b1\",\"errorMsg\":\"系统未知错误\",\"moduleId\":\"62bde6e0-988b-475f-bfdf-76203455ec57\",\"moduleName\":\"试用ptapi\"}]','userName：tangtao | trueName：唐韬','2016-04-03 10:33:04','2016-04-01 04:12:51'),('71597b65-bffb-462d-9f0d-6898ff03c8b3','http://xxx/activity/productSizedetail.do','post and get','[{\"name\":\"activity_id\",\"necessary\":\"true\",\"type\":\"long\",\"remark\":\"试用活动id\"}]','','[{\"name\":\"success\",\"type\":\"int\",\"remark\":\"是否成功：1成功，0失败\"},{\"name\":\"sizeDetail\",\"type\":\"对象\",\"remark\":\"规格、su、库存信息\"}]','000001,','{\n    \"success\": 1, \n    \"data\": {\n        \"sizeDetail\": [\n            {\n                \"specs\": [\n                    {\n                        \"goods_size\": \"红色\", \n                        \"name\": \"颜色\"\n                    }, \n                    {\n                        \"goods_size\": \"35\", \n                        \"name\": \"尺码\"\n                    }\n                ], \n                \"storeNum\": 19, \n                \"suId\": \"1300155001000001011\"\n            }, \n            {\n                \"specs\": [\n                    {\n                        \"goods_size\": \"白色\", \n                        \"name\": \"颜色\"\n                    }, \n                    {\n                        \"goods_size\": \"36\", \n                        \"name\": \"尺码\"\n                    }\n                ], \n                \"storeNum\": 12, \n                \"suId\": \"1300155001000002021\"\n            }, \n            {\n                \"specs\": [\n                    {\n                        \"goods_size\": \"黑色\", \n                        \"name\": \"颜色\"\n                    }, \n                    {\n                        \"goods_size\": \"37\", \n                        \"name\": \"尺码\"\n                    }\n                ], \n                \"storeNum\": 0, \n                \"suId\": \"1300155001000003031\"\n            }\n        ]\n    }\n}','{\n    \"data\": null, \n    \"error\": {\n        \"code\": \"000001\", \n        \"data\": null, \n        \"message\": \"活动不存在\"\n    }, \n    \"page\": null, \n    \"success\": 0\n}',1,'ff0d04ff-a512-4833-b12e-963be5a1475b','试用ptapi前端接口','试用活动详情页获取sizeDetail（规格、su、库存信息）','根据活动id查询活动对应的商品的规格信息及su、库存信息','[{\"errorCode\":\"000001\",\"errorId\":\"82e675b4-0c11-414d-8640-91ddead4f3b1\",\"errorMsg\":\"系统未知错误\",\"moduleId\":\"62bde6e0-988b-475f-bfdf-76203455ec57\",\"moduleName\":\"试用ptapi\"}]','userName：tangtao | trueName：唐韬','2016-04-03 10:33:04','2016-04-01 04:12:51'),('955db6b9-c42c-4e84-8a16-891d0944e4da','http://xxx/product/getSuId.do','post and get','[{\"name\":\"spec_ids\",\"necessary\":\"true\",\"type\":\"String\",\"remark\":\"规格id集合：{“1”,”2”}\"},{\"name\":\"product_id\",\"necessary\":\"true\",\"type\":\"long\",\"remark\":\"商品id\"}]','','[{\"name\":\"succeed\",\"type\":\"int\",\"remark\":\"是否成功:1成功，0失败\"}]','000001,','{\n	succeed:1,//是否成功\n	data{\n             suId,//售卖单元Id\n       }\n}','{\n    \"data\": null,\n    \"error\": {\n        \"code\": \"000001\",\n        \"data\": null,\n        \"message\": \"xxxx\"\n    },\n    \"page\": null,\n    \"success\": 0\n}',0,'ff0d04ff-a512-4833-b12e-963be5a1475b','试用ptapi前端接口','根据规格、商品id查询SU','主键按照排序spec_order排序\n通过产品product_id和spec_md5从SU表查询唯一的SuId','[{\"errorCode\":\"000001\",\"errorId\":\"82e675b4-0c11-414d-8640-91ddead4f3b1\",\"errorMsg\":\"系统未知错误\",\"moduleId\":\"62bde6e0-988b-475f-bfdf-76203455ec57\",\"moduleName\":\"试用ptapi\"}]','userName：tangtao | trueName：唐韬','2016-04-03 10:33:04','2016-04-01 04:12:51'),('a7c9ea74-e9cc-4ea4-b555-c0ff9cc9a816','http://xxx/activityReport/4/list.do','post and get','[{\"name\":\"activity_id\",\"necessary\":\"true\",\"type\":\"long\",\"remark\":\" 活动id\"},{\"name\":\"page\",\"necessary\":\"false\",\"type\":\"int\",\"remark\":\"页码 如果为空，则返回第一页的数据\"},{\"name\":\"pageSize\",\"necessary\":\"false\",\"type\":\"int\",\"remark\":\"每页显示的数量，如果pageSize为空，则不分页，一次选择所有数据\"}]','','[{\"name\":\"success\",\"type\":\"int\",\"remark\":\"是否成功：1成功，0失败\"},{\"name\":\"reportList\",\"type\":\"数组\",\"remark\":\"试用报告列表\"}]','000001,','{\n    \"data\":{\n        \"reportList\":[\n            {\n                \"repAuthor\":\"路上有你\",\n                \"repContent\":\"<p>323<br/></p>\",\n                \"repId\":114,\n                \"repImg\":\"http://img.biyao.com/files/data0/bytry/5e8187b706314eb98d2d1be27a10e221.png\",\n                \"repTitle\":\"123\",\n                \"userImg\":\"http://img.biyao.com/files/data0/2015/01/25/14/avatar/big/ebdb6c79-52ce-4c7b-bd68-f71ea4bd9563.jpg\"\n            }\n        ]\n    },\n    \"error\":null,\n    \"page\":{\n        \"allRow\":1,\n        \"currentPage\":1,\n        \"size\":1000,\n        \"start\":0,\n        \"totalPage\":1\n    },\n    \"success\":1\n}\n','{\n    \"data\":null,\n    \"error\":{\n        \"code\":\"000001\",\n        \"data\":null,\n        \"message\":\"xxx\"\n    },\n    \"page\":null,\n    \"success\":0\n}',1,'ff0d04ff-a512-4833-b12e-963be5a1475b','试用ptapi前端接口','查询某试用活动的试用报告','根据活动id查询通过审核的试用报告列表','[{\"errorCode\":\"000001\",\"errorId\":\"82e675b4-0c11-414d-8640-91ddead4f3b1\",\"errorMsg\":\"系统未知错误\",\"moduleId\":\"62bde6e0-988b-475f-bfdf-76203455ec57\",\"moduleName\":\"试用ptapi\"}]','userName：tangtao | trueName：唐韬','2016-04-03 10:33:04','2016-04-01 04:12:51'),('ab7e215e-abab-4b43-a7c3-9bc5a04224e4','http://xxxx/activityOrder/add.do','post and get','[{\"name\":\"activity _id\",\"necessary\":\"true\",\"type\":\"long\",\"remark\":\"活动id\"},{\"name\":\"nickname\",\"necessary\":\"true\",\"type\":\"String\",\"remark\":\"用户昵称\"},{\"name\":\"user_img\",\"necessary\":\"true\",\"type\":\"String\",\"remark\":\"用户头像\"},{\"name\":\"su_id\",\"necessary\":\"true\",\"type\":\"long\",\"remark\":\"基本售卖单元ID\"},{\"name\":\"uid\",\"necessary\":\"true\",\"type\":\"long\",\"remark\":\"请求头信息：用户id\"}]','请求地址:http://xxxx/activityOrder/add.do\r\n请求头:\r\n请求参数:\r\n	activity _id=xxxx\r\n	nickname=xxxx\r\n	user_img=xxxx\r\n	su_id=xxxx\r\n	uid=xxxx\r\n','[]','000004,','{\n    \"data\":null,\n    \"error\":null,\n    \"success\":1\n}\n','{\n    \"data\":null,\n    \"error\":{\n        \"code\":\"000001\",\n        \"data\":null,\n        \"message\":\"xxxxxxx\"\n    },\n    \"success\":0\n}\n',1,'ff0d04ff-a512-4833-b12e-963be5a1475b','试用ptapi前端接口','添加试用单','查询该用户是否在黑名单之中STATUS=0，查询活动是否未开始，是否已经结束，查询活动库存是否大于0，判断该用户是否已经参与过该活动','[{\"createTime\":\"2016-04-01 12:14:20.0\",\"errorCode\":\"000004\",\"errorId\":\"f1ce26cd-ea6b-4e77-9c65-1499fcb24e78\",\"errorMsg\":\"您已砍过|您已经帮Ta砍过一次咯~\",\"moduleId\":\"62bde6e0-988b-475f-bfdf-76203455ec57\",\"moduleName\":\"试用ptapi\",\"status\":1}]','userName：super | trueName：超级管理员','2016-04-05 08:03:00','2016-04-01 04:12:51');
/*!40000 ALTER TABLE `interface` ENABLE KEYS */;
UNLOCK TABLES;

