2021年总结

2021/01/09

h5回滚服务

sh /data/script/h5-shop-ssr.sh

#!/bin/bash
source /etc/profile

#备份
DATE=$(date +%Y%m%d%H%M)
mkdir -p /data/data_backup/pages/h5-sob3.5/$DATE/
cp -r /data/code/h5-shop-ssr/.nuxt /data/data_backup/pages/h5-sob3.5/$DATE/

cd /data/code/h5-shop-ssr
git pull
npm run build
pm2 delete all
npm run pm2

sh /data/script/h5-shop-ssr-rollback.sh 202101092222

#!/bin/bash
source /etc/profile

version=$1

echo "/data/data_backup/pages/h5-sob3.5/$version/"
if [ ! -d /data/data_backup/pages/h5-sob3.5/$version/.nuxt ];then
echo "文件/data/data_backup/pages/h5-sob3.5/$version/.nuxt不存在,回滚版本仅支持以下列表："
ll /data/data_backup/pages/h5-sob3.5/ | awk '{print $9}'
else
echo "开始回滚"

# 回退
```sh
rm -rf /data/code/git/frontend/h5-shop-ssr/.nuxt
cp -r /data/data_backup/pages/h5-sob3.5/$version/. /data/code/git/frontend/h5-shop-ssr/

重启服务

cd /data/code/git/frontend/h5-shop-ssr
npm run store
npm run pm2
fi

2021/01/15

微信代金券

开发指引open in new window

wechatpay-axios-pluginopen in new window

小程序卡券open in new window

微信卡券核销open in new window

发放代金券APIopen in new window

【营销工具】发放代金券API Q&A | 微信开放社区open in new window

2021/01/18

产品规划

消费券核销
代金券
产品追溯
海报自定义
公众号体验馆
公众号模板消息

2021/01/20

SQL存储过程

根据openId查询sob用户信息

SET @openId := 'ojXXs4hg8aqJtbywaZk3k8b4aZxE';

SET @wechatUserInfoId := (SELECT id from wechat_user_info where open_id = @openId);

SET @customerId := (SELECT customer_id from customer_third_party_bind where bind_id = @wechatUserInfoId);

SELECT * from customer WHERE id = @customerId;

根据customerId查询openId

SET @customerId := 10269;

SET @bindId := (SELECT bind_id from customer_third_party_bind where customer_id = @customerId);

SELECT * from wechat_user_info where id = @bindId;

根据手机号清空用户信息

-- v2.0
SET @phone := '15626445903';
 
-- account
SET @account_id := (select account_id from customer where phone = @phone);
select * from account where id = @account_id;
delete from account where id = @account_id;
delete from account_auth_data where account_id = @account_id;
 
-- customer
SET @customer_id := (select id from customer where phone = @phone);
select * from customer where id = @customer_id;
 
-- wechat
CREATE TEMPORARY table wechat_user_id (
  id bigint UNSIGNED not null
);
insert into wechat_user_id
  select wu.id as id from wechat_user wu
  join wechat_user_info info ON wu.id = info.wechat_user_id
  join customer_third_party_bind bind on info.id = bind.bind_id
  where bind.customer_id = @customer_id;
delete from wechat_user where id in (select id from wechat_user_id );
drop TEMPORARY table wechat_user_id;
delete from wechat_user_info where id in ( select bind_id from customer_third_party_bind where customer_id = @customer_id );
 
 
-- customer
delete from customer_info_sass where customer_id = @customer_id;
delete from customer_role_relationship where customer_id = @customer_id;
delete from customer_relationship where customer_id = @customer_id;
delete from customer_info_merchant where customer_id = @customer_id;
delete from customer_third_party_bind where customer_id = @customer_id;
delete from customer where id = @customer_id;

SQL统计

营业额

select sum(amount/100) from sob_order where create_time > '2021-01-18 00:00:00' and status = 2;

活跃企业

select sob_order.company_id,company.company_name,company.province ,company.addr  from sob_order 
LEFT JOIN company on company.company_id = sob_order.company_id 
where sob_order.create_time > '2021-01-19 00:00:00' and sob_order.status = 2 GROUP BY sob_order.company_id ;

2021/01/22

#188活动
SELECT * FROM `mock_banner_data` 
WHERE role_code = 'USER' and banner_type in ('USER_ADS_16', 'USER_ADS_17')
 LIMIT 50;

查询招募页留资信息

SELECT * from customer_consult_info where customer_id = 11242

微信产品

支付即服务open in new window

微信支付分open in new window

易观数据埋点

产品视频教程open in new window

2021/01/25

p2c

2021年前端会有什么新变化open in new window

淘宝imgcookopen in new window

imgcook文档open in new window

插入轮播图

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/popup_not_new.png','/pages/brand_act?actId=17&sourceScene=not_new_brand','POPUP_NOT_NEW_17');

2021/01/28

小程序云函数

h5跳转小程序

云开发短信跳小程序open in new window

h5跳转小程序open in new window

2021/02/01

易观埋点说明

来源场景值sourceScene的类型：

index_brand: 188活动首页轮播图
pay_brand: 188活动支付弹窗
not_new_brand: 188活动非新客弹窗
index_company:  89活动首页轮播图
pay_company: 89活动支付弹窗
index_user: sob3.6消费者角色首页轮播图
index_promoter: sob3.6体验官角色首页轮播图
index_salesman: sob3.6导购角色首页轮播图易观埋点说明

携带sourcescene的事件：

index_page_visible_（进入活动首页）
brand_activity_page_visible_（进入可瑞乐招募页）
brand_activity_page_consult_add_（点击留资体验官）
brand_activity_page_call_phone_（点击咨询体验官）
brand_activity_page_stop_time_（体验官招募令停留时间）

2021/02/19

公众号联通小程序

获取二维码

https://sob-dev.qqbibi.com/wx/qrcode

显示二维码

showqrcodeopen in new window

客服消息

Service_Center_messagesopen in new window

用户发送信息
点击自定义菜单（仅有点击推事件、扫码推事件、扫码推事件且弹出“消息接收中”提示框这3种菜单类型是会触发客服接口的）
关注公众号
扫描二维码
支付成功

2021/02/23

山东

测试活动27

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/shandong/3.6_banner_shandong_188.png','/pages/index?actId=24&sourceScene=index_salesman','INDEX_27');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/shandong/3.6_banner_guide.png','INDEX_27');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/shandong/3.6_banner.png','INDEX_27');



INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188.png?t=202102041434;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','INDEX_30');



INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/shandong/3.6_server_banner.png','INDEX_27');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/shandong/3.6_banner.png','INDEX_27');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/shandong/3.6_banner_shandong_188.png','/pages/index?actId=24&sourceScene=index_promoter','INDEX_27');



INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/shandong/3.6_banner_shandong_188.png','/pages/index?actId=24&sourceScene=index_user','INDEX_27');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/shandong/3.6_banner.png','INDEX_27');

正式活动

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/shandong/3.6_banner_shandong_188.png','/pages/index?actId=28&sourceScene=index_salesman','INDEX_30');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/shandong/3.6_banner_guide.png','INDEX_30');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/shandong/3.6_banner.png','INDEX_30');



INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/shandong/3.6_server_banner.png','INDEX_30');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/shandong/3.6_banner.png','INDEX_30');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/shandong/3.6_banner_shandong_188.png','/pages/index?actId=28&sourceScene=index_promoter','INDEX_30');



INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/shandong/3.6_banner_shandong_188.png','/pages/index?actId=28&sourceScene=index_user','INDEX_30');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/shandong/3.6_banner.png','INDEX_30');



SELECT * FROM `mock_banner_data`  where banner_type LIKE 'INDEX_27'

河南

测试活动

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/3.6_henan_188_banner.png','/pages/index?actId=24&sourceScene=index_salesman','INDEX_25');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/3.6_henan_guide_banner.png','INDEX_25');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/3.6_henan_banner.png','INDEX_25');



INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/3.6_henan_server_banner.png','INDEX_25');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/3.6_henan_banner.png','INDEX_25');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/3.6_henan_188_banner.png','/pages/index?actId=24&sourceScene=index_promoter','INDEX_25');



INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/3.6_henan_188_banner.png','/pages/index?actId=24&sourceScene=index_user','INDEX_25');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/3.6_henan_banner.png','INDEX_25');



INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/sob3.5_act.gif','/pages/brand_act?actId=25&sourceScene=index_brand','USER_ADS_25');

正式活动

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/3.6_henan_188_banner.png','/pages/index?actId=23&sourceScene=index_salesman','INDEX_29');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/3.6_henan_guide_banner.png','INDEX_29');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/3.6_henan_banner.png','INDEX_29');



INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/3.6_henan_server_banner.png','INDEX_29');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/3.6_henan_banner.png','INDEX_29');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/3.6_henan_188_banner.png','/pages/index?actId=23&sourceScene=index_promoter','INDEX_29');





INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/3.6_henan_188_banner.png','/pages/index?actId=23&sourceScene=index_user','INDEX_29');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/3.6_henan_banner.png','INDEX_29');



INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/sob3.5_act.gif','/pages/brand_act?actId=29&sourceScene=index_brand','USER_ADS_29');

3.5广告

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/sob3.5_act.gif','/pages/brand_act?actId=24&sourceScene=index_brand','USER_ADS_24');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/188new_customer_pay_success.png','/pages/brand_act?actId=24&sourceScene=pay_brand','POPUP_24');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/no_new_customer_pay.png','/pages/brand_act?actId=24&sourceScene=not_new_brand','POPUP_NOT_NEW_24');





INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/sob3.5_act.gif','/pages/brand_act?actId=23&sourceScene=index_brand','USER_ADS_23');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/188new_customer_pay_success.png','/pages/brand_act?actId=23&sourceScene=pay_brand','POPUP_23');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/no_new_customer_pay.png','/pages/brand_act?actId=23&sourceScene=not_new_brand','POPUP_NOT_NEW_23');





INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/sob3.5_act.gif','/pages/brand_act?actId=28&sourceScene=index_brand','USER_ADS_28');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/188new_customer_pay_success.png','/pages/brand_act?actId=28&sourceScene=pay_brand','POPUP_28');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/no_new_customer_pay.png','/pages/brand_act?actId=28&sourceScene=not_new_brand','POPUP_NOT_NEW_28');



INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188.png?t=202102041434;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','GOODS_DETAIL_ADS_28');

体验官升级

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/3.6_henan_server_hight_lever.png','[{"goodsId":32,"amount":1}]','LEVEL_29');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/3.6_henan_server_wang_lever.png','[{"goodsId":32,"amount":3}]','LEVEL_29');



INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/shandong/3.6_hight_server_level.png','[{"goodsId":32,"amount":1}]','LEVEL_30');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/shandong/3.6_wang_server_level.png','[{"goodsId":32,"amount":3}]','LEVEL_30');

批量添加时间戳

update `mock_banner_data` set pic_url = CONCAT(pic_url,'?t=20210224')

where id = 58





INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_act_img/shandong/3.6_banner_guide.png','/subpackage_server/pages/server_introduce','INDEX_25');





INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188.png?t=202102041434;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','INDEX_30');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188.png?t=202102041434;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','INDEX_30');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188.png?t=202102041434;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','INDEX_30');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188.png?t=202102041434;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','INDEX_29');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188.png?t=202102041434;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','INDEX_29');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188.png?t=202102041434;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','INDEX_29');

江西、云南

测试活动

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/0309/all_to_188.png','/pages/index?actId=32&sourceScene=index_salesman','INDEX_33');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`, `banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/0309/guide_banner.png','/pages/brand_act?actId=33&sourceScene=index_salesman', 'INDEX_33');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/0309/all_banner.png','INDEX_33');





INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/0309/server_banner.png','INDEX_33');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/0309/all_banner.png','INDEX_33');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/0309/all_to_188.png','/pages/index?actId=32&sourceScene=index_promoter','INDEX_33');





INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/0309/all_to_188.png','/pages/index?actId=32&sourceScene=index_user','INDEX_33');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/0309/all_banner.png','INDEX_33');



INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/368/368poster.jpg','POSTOMER_33');





INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188.png?t=202102041434;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','INDEX_33');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188.png?t=202102041434;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','INDEX_33');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188.png?t=202102041434;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','INDEX_33');

测试活动广告

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/368/368pay_success.png','/pages/brand_act?actId=34&sourceScene=pay_368brand','POPUP_34');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/368/368not_new.png','/pages/brand_act?actId=34&sourceScene=not_new_368brand','POPUP_NOT_NEW_34');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188.png?t=202102041434;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','GOODS_DETAIL_ADS_34');



INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188/pay_success.gif','/pages/index?actId=34&sourceScene=pay_brand','POPUP_32');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188/not_new.gif','/pages/index?actId=34&sourceScene=not_new_brand','POPUP_NOT_NEW_32');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188.png?t=202102041434;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','GOODS_DETAIL_ADS_32');

正式活动

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/0309/all_to_188.png','/pages/index?actId=35&sourceScene=index_salesman','INDEX_37');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`, `banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/0309/guide_banner.png','/subpackage_server/pages/server_introduce', 'INDEX_37');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/0309/all_banner.png','INDEX_37');



INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/0309/server_banner.png','INDEX_37');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/0309/all_banner.png','INDEX_37');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/0309/all_to_188.png','/pages/index?actId=35&sourceScene=index_promoter','INDEX_37');



INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/0309/all_to_188.png','/pages/index?actId=35&sourceScene=index_user','INDEX_37');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/0309/all_banner.png','INDEX_37');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/368/368poster.jpg','POSTOMER_37');







INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188.png?t=202102041434;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','INDEX_37');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188.png?t=202102041434;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','INDEX_37');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188.png?t=202102041434;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','INDEX_37');

正式活动广告

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/368/368pay_success.png','/pages/brand_act?actId=36&sourceScene=pay_368brand','POPUP_36');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/368/368not_new.png','/pages/brand_act?actId=36&sourceScene=not_new_368brand','POPUP_NOT_NEW_36');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188.png?t=202102041434;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','GOODS_DETAIL_ADS_36');





INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188/pay_success.gif','/pages/index?actId=36&sourceScene=pay_brand','POPUP_35');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188/not_new.gif','/pages/index?actId=36&sourceScene=not_new_brand','POPUP_NOT_NEW_35');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/188.png?t=202102041434;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','GOODS_DETAIL_ADS_35');

2021/03/22

完整教程

http://blog.haoji.me/vscode-plugin-overview.html

VSCode插件开发

官方文档

https://code.visualstudio.com/api

https://liiked.github.io/VS-Code-Extension-Doc-ZH/#/

打包发布步骤

申请微软账号

官方教程open in new window

个人组织地址

https://dev.azure.com/1183719396/_usersSettings/tokens

1183719396@qq.com
oyd95445018

publisher-name

ouyangdan

access-tock

有效日期：2022/03/21

n7wdntxv5vxs5wbc4e2fniifvlcnhi5twx4ruds6jnvm5tcxxbiq

全局安装vsce

cnpm install -g vsce

打包发布

vsce login ouyangdan
n7wdntxv5vxs5wbc4e2fniifvlcnhi5twx4ruds6jnvm5tcxxbiq
//package.json文件新增发布者：
"publisher": "ouyangdan",
vsce package
vsce publish

查看插件状态

https://marketplace.visualstudio.com/manage/publishers/ouyangdan

2021/03/23

小程序引导页

http://www.cppcns.com/wangluo/javascript/322971.html

2021/03/25

小程序场景值

https://developers.weixin.qq.com/miniprogram/dev/reference/scene-list.html

2021/04/08

vite

https://juejin.cn/post/6924912613750996999

https://my.oschina.net/u/3347851/blog/4885913

原生浏览器ES模块demoopen in new window

2021/04/09

Vue源码

vue源码入门.pdfopen in new window

https://wiki.qqbibi.com/pages/viewpage.action?pageId=16482499

https://vue-js.com/learn-vue/start/#_2-%E5%AD%A6%E4%B9%A0%E8%A7%84%E5%88%92

2021/04/14

webpack源码

webpack打包原理open in new window

2021/04/15

Typescript面试题

https://www.jianshu.com/p/076ee2751cfc

https://my.oschina.net/u/3991187/blog/4415774

前端跨域解决方案

https://www.jianshu.com/p/8c8f16c46cb8

2021/04/26

sob3.5支付完成弹窗配置

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/39/39pay_success.png','/pages/index?actId=40&sourceScene=pay_102','POPUP_39');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/40/40pay_success.png','/pages/index?actId=39&sourceScene=pay_91','POPUP_40');

2021/05/07 活动列表配置

ALTER TABLE `mock_banner_data`
MODIFY COLUMN `pic_url`  varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '图片路径' AFTER `role_code`;



#消费者角色活动列表
```sql
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/customer_act_list_shopping_ad.png','/subpackage_customer/pages/shopcart','ACTIVITY_LIST_128');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/customer_act_list_upgrade_server_ad.png','/pages/blank?role=server','ACTIVITY_LIST_128');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/guide_act_list_dengsha_video_ad.png;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','','ACTIVITY_LIST_VIDEO_128');

#导购角色活动列表

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/guide_act_list_new_customer_ad.png','/subpackage_guide/pages/new_customer_introduce','ACTIVITY_LIST_128');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/guide_act_list_server_ad.png','/subpackage_guide/pages/server_introduce_v2','ACTIVITY_LIST_128');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/guide_act_list_dengsha_video_ad.png;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','','ACTIVITY_LIST_VIDEO_128');

#首页banner

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/guide_index_banner.jpg','/subpackage_guide/pages/activity_list','INDEX_128');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/customer_index_banner.jpg','/subpackage_customer/pages/activity_list','INDEX_128');

#体验官升级

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/high_level_upgrade.png','[{"goodsId":674,"amount":1}]','LEVEL_128');

INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/wangpai_upgrade.png','[{"goodsId":674,"amount":2}]','LEVEL_128');

2021/05/10 5月活动

测试活动

#消费者角色活动列表
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/customer_act_list_shopping_ad.png','/subpackage_customer/pages/shopcart','ACTIVITY_LIST_38');
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/customer_act_list_upgrade_server_ad.png','/subpackage_customer/pages/server_introduce_v2','ACTIVITY_LIST_38');
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/guide_act_list_dengsha_video_ad.png;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','','ACTIVITY_LIST_38');


#导购角色活动列表
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/guide_act_list_new_customer_ad.png','/subpackage_guide/pages/new_customer_introduce','ACTIVITY_LIST_38');
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/guide_act_list_server_ad.png','/subpackage_guide/pages/server_introduce_v2','ACTIVITY_LIST_38');
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/guide_act_list_dengsha_video_ad.png;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','','ACTIVITY_LIST_38');


#首页banner
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/guide_index_banner.jpg','/subpackage_guide/pages/activity_list','INDEX_38');
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/customer_index_banner.jpg','/subpackage_customer/pages/activity_list','INDEX_38');
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/server_index_banner.jpg;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','','INDEX_38');


#体验官升级
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/high_level_upgrade.png','[{"goodsId":32,"amount":1}]','LEVEL_38');
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/wangpai_upgrade.png','[{"goodsId":32,"amount":2}]','LEVEL_38');

正式活动

#消费者角色活动列表
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/customer_act_list_shopping_ad.png','/subpackage_customer/pages/shopcart','ACTIVITY_LIST_41');
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/customer_act_list_upgrade_server_ad.png','/subpackage_customer/pages/server_introduce_v2','ACTIVITY_LIST_41');
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/guide_act_list_dengsha_video_ad.png;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','','ACTIVITY_LIST_VIDEO_41');


#导购角色活动列表
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/guide_act_list_new_customer_ad.png','/subpackage_guide/pages/new_customer_introduce','ACTIVITY_LIST_41');
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/guide_act_list_server_ad.png','/subpackage_guide/pages/server_introduce_v2','ACTIVITY_LIST_41');
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/guide_act_list_dengsha_video_ad.png;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','','ACTIVITY_LIST_VIDEO_41');


#首页banner
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('SALESMAN','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/guide_index_banner.jpg','/subpackage_guide/pages/activity_list','INDEX_41');
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('USER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/customer_index_banner.jpg','/subpackage_customer/pages/activity_list','INDEX_41');
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/server_index_banner.jpg;https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/goodsdetail.mp4','','INDEX_41');


#体验官升级
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/high_level_upgrade.png','[{"goodsId":35,"amount":1}]','LEVEL_41');
INSERT INTO `sob`.`mock_banner_data` (`role_code`,`pic_url`,`jump_page`,`banner_type`) VALUES ('PROMOTER','https://qqbibi-img-prod.oss-cn-shenzhen.aliyuncs.com/sob_5yue_act_img/wangpai_upgrade.png','[{"goodsId":35,"amount":2}]','LEVEL_41');

/subpackage_server/pages/share_poster

/subpackage_server/pages/share_poster_back 

修改为

/subpackage_guide/pages/share_poster

2021/09/03

手动安装npm包

https://blog.csdn.net/fenfeidexiatian/article/details/96993384

https://npm.taobao.org/mirrors/npm/

https://nodejs.org/zh-cn/download/releases/

fs-extra库

https://github.com/jprichardson/node-fs-extra

# 2021年总结

# 2021/01/09

# h5回滚服务

# 重启服务

# 2021/01/15

# 微信代金券

# 2021/01/18

# 产品规划

# 2021/01/20

# SQL存储过程

# 根据openId查询sob用户信息

# 根据customerId查询openId

# 根据手机号清空用户信息

# SQL统计

# 营业额

# 活跃企业

# 2021/01/22

# 查询首页广告banner图

# 查询招募页留资信息

# 微信产品

# 易观数据埋点

# 2021/01/25

# p2c

# 插入轮播图

# 2021/01/28

# 小程序云函数

# h5跳转小程序

# 2021/02/01

# 易观埋点说明

# 来源场景值sourceScene的类型：

# 携带sourcescene的事件：

# 2021/02/19

# 公众号联通小程序

# 获取二维码

# 显示二维码

# 客服消息

# 2021/02/23

# 山东

# 测试活动27

# 正式活动

# 河南

# 测试活动

# 正式活动

# 3.5广告

# 体验官升级

# 批量添加时间戳

# 江西、云南

# 测试活动

# 测试活动广告

# 正式活动

# 正式活动广告

# 2021/03/22

# 完整教程

# VSCode插件开发

# 官方文档

# 打包发布步骤

# 申请微软账号

# 个人组织地址

# publisher-name

# access-tock

# 全局安装vsce

# 打包发布

# 查看插件状态

# 2021/03/23

# 小程序引导页

# 2021/03/25

# 小程序场景值

# 2021/04/08

# vite

# 2021/04/09

# Vue源码

# 2021/04/14

# webpack源码

# 2021/04/15

# Typescript面试题

# 前端跨域解决方案

# 2021/04/26

# sob3.5支付完成弹窗配置

# 2021/05/07 活动列表配置

# 2021/05/10 5月活动

2021年总结

2021/01/09

h5回滚服务

重启服务

2021/01/15

微信代金券

2021/01/18

产品规划

2021/01/20

SQL存储过程

根据openId查询sob用户信息

根据customerId查询openId

根据手机号清空用户信息

SQL统计

营业额

活跃企业

2021/01/22

查询首页广告banner图

查询招募页留资信息

微信产品

易观数据埋点

2021/01/25

p2c

插入轮播图

2021/01/28

小程序云函数

h5跳转小程序

2021/02/01

易观埋点说明

来源场景值sourceScene的类型：

携带sourcescene的事件：

2021/02/19

公众号联通小程序

获取二维码

显示二维码

客服消息

2021/02/23

山东

测试活动27

正式活动

河南

测试活动

正式活动

3.5广告

体验官升级

批量添加时间戳

江西、云南

测试活动

测试活动广告

正式活动

正式活动广告

2021/03/22

完整教程

VSCode插件开发

官方文档

打包发布步骤

申请微软账号

个人组织地址

publisher-name

access-tock

全局安装vsce

打包发布

查看插件状态

2021/03/23

小程序引导页

2021/03/25

小程序场景值

2021/04/08

vite

2021/04/09

Vue源码

2021/04/14

webpack源码

2021/04/15

Typescript面试题

前端跨域解决方案

2021/04/26

sob3.5支付完成弹窗配置

2021/05/07 活动列表配置

2021/05/10 5月活动