下线H5链接 - 数讯H5

### 沈阳天地-母亲节 ``` 主页链接 http://vkfc.ailabs.xin/SytdMd 数据统计 http://vkfc.ailabs.xin/SytdMd/sxCounter 清理数据 TRUNCATE `cy_sytd_md`; TRUNCATE `cy_sytd_md_log`; UPDATE `cy_sytd_md_prize` SET `give_openid` ='', `give_time` =0, `use_time` =0, `give_ip` ='', `vcode` =''; ``` ### 百威年会 ``` 主页链接 http://wzwxc2023.ailabs.xin/Bune2024 数据统计 http://wzwxc2023.ailabs.xin/Bune2024/sxCounter 后台投票控制台 http://sxh5.sysx.tech/Admin/Index/index.html 账号：百威密码：123456 清理数据 TRUNCATE `cy_bune2024`; UPDATE `cy_bune2024_sku` SET is_use=0; UPDATE `cy_bune2024_xuan` SET piao=0,last_piao_time=0; TRUNCATE `cy_bune2024_log`; ``` ### 东北华润置地-2024全民健康跑 ``` 主页链接 https://h5fc3.ailabs.xin/HrzdJkp 数据统计 https://mp.ailabs.xin/HrzdJkp/sxCounter 清理数据 TRUNCATE `cy_hrzd_jkp`; TRUNCATE `cy_hrzd_jkp_pay`; TRUNCATE `cy_hrzd_jkp_sign`; UPDATE `cy_hrzd_jkp_number` SET openid='',is_use=0; ``` ### PAFC MALL-抽奖 ``` 主页链接 https://hrfc3.ailabs.xin/PafcQdcode 数据统计 http://mp.ailabs.xin/PafcQdcode/sxCounter 清理数据 TRUNCATE `cy_pafc_qdcode`; TRUNCATE `cy_pafc_qdcode01_log`; TRUNCATE `cy_pafc_qdcode02_log`; TRUNCATE `cy_pafc_qdcode03_log`; TRUNCATE `cy_pafc_qdcode_inviter`; ``` ### 沈阳天地-照片 ``` 主页链接 http://vkfc.ailabs.xin/SytdFace ``` ### 武昌万象城-抽奖 ``` 正式链接 https://wzwxcfc.ailabs.xin/WcwxcQdcode/ 数据统计 http://mp.ailabs.xin/WcwxcQdcode/sxCounter 卡券管家邀请码 240403888 清理测试数据 TRUNCATE `cy_wcwxc3_qdcode`; TRUNCATE `cy_wcwxc3_qdcode01_log`; TRUNCATE `cy_wcwxc3_qdcode_inviter`; ``` ### 三台子万象汇-转盘 ``` 主页链接 http://stzwxh.ailabs.xin/Stzwxh240327/ 数据统计 http://stzwxh.ailabs.xin/Stzwxh240327/sxCounter 后台奖品投放管理 http://sxh5.sysx.tech/Admin/Index/index.html 账号：三台子密码：123456 核销邀请码 240327 清理数据 TRUNCATE `cy_stzwxh240327`; TRUNCATE `cy_stzwxh240327_log`; TRUNCATE `cy_stzwxh240327_prize`; ``` ### 桐乡万象汇-开业抽奖 ``` 主页链接 https://hrfc.ailabs.xin/TxwxhQdcode/ 数据统计 https://hrfc.ailabs.xin/TxwxhQdcode/sxCounter 数据导出 SELECT `openid`, `nickname` as 昵称, `memberId` as 一点万象ID, `sex` AS 性别, `birthday` as 生日, `marry` as 婚姻, `address` as 城市, `feeldata` as 体验 FROM `cy_txwxh_qdcode` where `sex` IS NOT NULL; SELECT `id`,`openid`,`act_xu`,`nickname` as 微信昵称,`avatar` as 头像,`memberId` as 一点万象ID,`new_register` as 是否新会员,FROM_UNIXTIME(`add_time`,'%Y-%m-%d %H:%i') as 参与时间 FROM `chaoyang`.`cy_txwxh_qdcode01_log` ORDER BY `id` ASC SELECT `openid`, `nickname` as 昵称, `memberId` as 一点万象ID, `sex` AS 性别, `birthday` as 生日, `marry` as 婚姻, REPLACE(`address`,'null','') as 城市, `feeldata` as 体验 FROM `cy_txwxh_qdcode` where `sex` IS NOT NULL ``` ### 铁西万象汇-填色 ``` 主页链接 https://h5fc3.ailabs.xin/TxwxhColor 数据统计 https://h5fc3.ailabs.xin/TxwxhColor/sxCounter 后台奖品投放管理 http://sxh5.sysx.tech/Admin/Index/index.html 账号：铁西密码：123456 核销邀请码 240326 清理数据 https://h5fc3.ailabs.xin/TxwxhColor/clear2 清理数据 TRUNCATE `cy_txwxh_color`; TRUNCATE `cy_txwxh_color_log`; TRUNCATE `cy_txwxh_color_prize`; 数据导出 SELECT openid, `nickname` as 昵称,realname as 姓名,mobile as 电话,u.type,u.memberId,FROM_UNIXTIME(`add_time`,'%Y-%m-%d %H:%i') as 参与时间,p.`name` as 奖品,FROM_UNIXTIME(`give_time`,'%Y-%m-%d %H:%i') as 中奖时间,FROM_UNIXTIME(`use_time`,'%Y-%m-%d %H:%i') as 核销时间 FROM `cy_txwxh_color` as u LEFT JOIN `cy_txwxh_color_prize` as p on u.`openid` =p.`give_openid` where `give_time` >0 ``` ### 蔚来汽车-惊喜转盘 ``` 主页链接海口 http://vkfc.ailabs.xin/Nio2Turntable/index1 三亚 http://vkfc.ailabs.xin/Nio2Turntable/index2 数据统计 http://vkfc.ailabs.xin/Nio2Turntable/sxCounter 后台奖品投放和导出 http://sxh5.sysx.tech/admin/Login/index.html 账号：蔚来密码：123789 ``` ### 福州万象城-奇迹咖啡地图 ``` 主页链接 https://hrfc2.ailabs.xin/FzwxcMap 数据统计 https://hrfc2.ailabs.xin/FzwxcMap/sxCounter 卡券管家核销邀请码 240317 后台 http://sxh5.sysx.tech/admin/Login/index.html 账号：福州密码：123456 清理数据 TRUNCATE `cy_fzwxc_map`; TRUNCATE `cy_fzwxc_map_log`; TRUNCATE `cy_fzwxc_map_prize`; ``` ### 东北区域万科-万科人买万科房 ``` 主页链接 https://vkfc.ailabs.xin/Vanke240315/index1 https://vkfc.ailabs.xin/Vanke240315/index2 https://vkfc.ailabs.xin/Vanke240315/index3 后台 http://sxh5.sysx.tech/Admin/Index/index.html 账号德悦密码 123456 ``` ### 哈尔滨松北万象汇-vivo抽奖 ``` 主页链接 https://hrfc4.ailabs.xin/Hrbwxh2Qdcode 数据统计 https://hrfc4.ailabs.xin/Hrbwxh2Qdcode/sxCounter 开奖链接 https://hrfc4.ailabs.xin/Hrbwxh2Qdcode/setPrize 清理数据 TRUNCATE `cy_hrbwxh2_qdcode`; TRUNCATE `cy_hrbwxh2_qdcode01_log`; ``` ### 厦门万象城-抽美妆 ``` 主页链接 https://hrfc3.ailabs.xin/XmwxcBeauty 录入奖品 https://hrfc3.ailabs.xin/XmwxcBeauty/addPrize 清理数据 TRUNCATE `cy_xmwxc_beauty`; TRUNCATE `cy_xmwxc_beauty_log`; UPDATE `cy_xmwxc_beauty_prize` SET `give_openid` ='', `give_time` =0, `give_ip` ='', `use_time` =0, `vcode` =''; ``` ### 福州万象城-抽鞋 ``` 主页链接 https://hrfc2.ailabs.xin/Fzwxc3Qdcode 数据统计 https://hrfc2.ailabs.xin/Fzwxc3Qdcode/sxCounter 清理数据 TRUNCATE `cy_fzwxc3_qdcode`; TRUNCATE `cy_fzwxc3_qdcode_inviter`; TRUNCATE `cy_fzwxc3_qdcode01_log`; TRUNCATE `cy_fzwxc3_qdcode02_log`; UPDATE `cy_fzwxc3_qdcode_underline` SET `openid` ='', `is_use` =0, `add_time`=0, `add_ip` =''; ``` ### 上海苏河湾万象天地-MBTI测试 ``` 主页链接 https://hrfc.ailabs.xin/ShwMbti 数据统计 http://mp.ailabs.xin/ShwMbti/sxCounter http://mp.ailabs.xin/ShwMbti/test3 清理数据 TRUNCATE `cy_shw_mbti`; TRUNCATE `cy_shw_mbti_log`; TRUNCATE `cy_shw_mbti_prize`; TRUNCATE `cy_shw_mbti_prize_ext`; TRUNCATE `cy_shw_mbti_log`; UPDATE `cy_shw_mbti_prize` SET `give_openid` ='', `give_time` =0, `give_ip` ='', `mixc_return` ='', `mixc_time` =0; 数据查询 SELECT * FROM `cy_shw_mbti_prize` where `give_time` >0 AND `mixc_time` =0 AND `mixc_return` IS NOT NULL SELECT * FROM `cy_shw_mbti` where `openid` IN (SELECT `give_openid` FROM `cy_shw_mbti_prize_ext` where `mixc_time` =0 AND `mixc_return` IS NOT NULL GROUP BY `give_openid`); ``` ### 沈阳天地-摇一摇 ``` 主页链接 https://syst.ailabs.xin/Sytd240206 数据统计 https://syst.ailabs.xin/Sytd240206/sxCounter ``` ### 福州万象城-财神 ``` 主页链接 https://hrfc2.ailabs.xin/FzwxcCs 数据统计 https://hrfc2.ailabs.xin/FzwxcCs/sxCounter 卡券管家核销码 240205 录入奖品 https://hrfc2.ailabs.xin/FzwxcCs/addPrize 清理数据 TRUNCATE `cy_fzwxc_cs`; TRUNCATE `cy_fzwxc_cs_log`; UPDATE `cy_fzwxc_cs_prize` SET `give_openid` ='',`give_time` =0, `use_time` =0, `give_ip` ='',`vcode` =''; ``` ### 福州万象城-新年星愿季 ``` 主页链接 https://hrfc2.ailabs.xin/Fzwxc2024Qdcode 数据统计 https://hrfc2.ailabs.xin/Fzwxc2024Qdcode/sxCounter 清理数据 TRUNCATE `cy_fzwxc2024_qdcode`; TRUNCATE `cy_fzwxc2024_qdcode_inviter`; TRUNCATE `cy_fzwxc2024_qdcode01_log`; ``` ### 辽宁移动-党建品牌意见征集(2) ``` 主页链接 http://h5fc.ailabs.xin/Lnyd240119 清理数据 TRUNCATE `cy_lnyd240119_log`; TRUNCATE `cy_lnyd240119_xuan`; ``` ### 辽宁交投集团-游戏报名 ``` 主页链接 http://mp.ailabs.xin/JtSign240129 清理数据 TRUNCATE `cy_jt_sign240129_sign`; ``` ### 万科东北区域-幸运抽奖 ``` 主页链接 https://vkfc.ailabs.xin/Vanke240131/ https://vkfc.ailabs.xin/Vanke240131/?token=1111 清理数据 TRUNCATE `cy_vanke240131_prize`; TRUNCATE `cy_vanke240131_log`; UPDATE `cy_vanke240131_prize` SET `give_openid` ='', `give_time` =0, `give_ip` ='', `realname` ='', `mobile` ='', `address` ='', `lb_realname` ='', `update_time` =0; ``` ### 拓荆科技-大屏抽奖 ``` 主页链接 https://h5fc3.ailabs.xin/TjScreen 中奖信息打印 https://h5fc3.ailabs.xin/TjScreen/prize 清理数据 TRUNCATE `cy_tj_screen`; UPDATE `cy_tj_screen` SET `is_prize` =0, `prize_name` ='', `prize_time` =0, `prize_type` =''; ``` ### 万科东北区域-最具魅力园区评选 ``` 主页连接 https://vkfc.ailabs.xin/Vanke240116?access_token=1111 清理数据 TRUNCATE `cy_vanke240116_log`; TRUNCATE `cy_vanke240116_xuan`; TRUNCATE `cy_vanke240116_log`; update `cy_vanke240116_xuan`set `piao`=0,`last_piao_time`=0; ``` ### 万科东北区域-第三届业主春晚 ``` 主页链接 https://vkfc.ailabs.xin/Vanke240119 清理数据 TRUNCATE `cy_vanke240119`; TRUNCATE `cy_vanke240119_log`; ``` ### 沈阳天地-顾客登记 ``` 主页链接 http://weixin.jiaapps.com/Sytd240117 数据统计 http://weixin.jiaapps.com/Sytd240117/sxCounter 清理测试数据 TRUNCATE `cy_sytd240117_sign`; ``` ### 辽宁移动-党建品牌意见征集 ``` 主页链接 http://h5fc.ailabs.xin/Lnyd240112 清理数据 TRUNCATE `cy_lnyd240112_sign`; TRUNCATE `cy_lnyd240112_sign_log`; TRUNCATE `cy_lnyd240112_sign_xuan`; ``` ### 哈尔滨松北万象汇-抽奖 ``` 主页链接 https://hrfc4.ailabs.xin/HrbwxhQdcode 数据统计 https://hrfc4.ailabs.xin/HrbwxhQdcode/sxCounter 开奖链接 https://hrfc4.ailabs.xin/HrbwxhQdcode/setPrize 清理数据 TRUNCATE `cy_hrbwxh_qdcode`; TRUNCATE `cy_hrbwxh_qdcode01_log`; ``` ### 武昌万象城-抽奖 ``` 抽奖1-抽金条正式链接 https://wzwxcfc.ailabs.xin/WcwxcQdcode/ 数据统计 http://mp.ailabs.xin/WcwxcQdcode/sxCounter 卡券管家邀请码 231211888 抽奖2-抽门票-4种混合正式链接 https://wzwxcfc.ailabs.xin/Wcwxc2Qdcode/ 数据统计 http://vkfc.ailabs.xin/Wcwxc2Qdcode/sxCounter 卡券管家邀请码 231221888 清理测试数据 TRUNCATE `cy_wcwxc2_qdcode`; TRUNCATE `cy_wcwxc2_qdcode01_log`; TRUNCATE `cy_wcwxc2_qdcode_inviter`; ```