server {
 listen 80;
 server_name example.com;

 location ^~ /web {
 proxy_pass http://localhost:8081;
 proxy_set_header Host $host;
 proxy_set_header X-Real-IP $remote_addr;
 proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
 }

 location ^~ /admin {
 proxy_pass http://localhost:8085;
 proxy_set_header Host $host;
 proxy_set_header X-Real-IP $remote_addr;
 proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
 }

 location ^~ /h5 {
 proxy_pass http://localhost:8082;
 proxy_set_header Host $host;
 proxy_set_header X-Real-IP $remote_addr;
 proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
 }
}

https://mojin.51wangshi.com/

USE information_schema;
select table_name,table_rows from tables where TABLE_SCHEMA = 'mallplus1' order by table_rows desc;

 if(type===1){
 return 'ios首页轮播';
 }else if(type===2){
 return 'android首页轮播';
 }
 else if(type===3){
 return 'pc首页轮播';
 }else if(type===4){
 return 'h5首页轮播';
 }else if(type===5){
 return '小程序首页轮播';
 }


沈兄~能把数据抓出来吗?https://map.beijing.gov.cn/category?categoryId=xx


SELECT * from pms_product where product_attribute_category_id=1 ;
SELECT * from pms_sku_stock where product_id=26;
SELECT * from pms_product_attribute_value where product_id=26;
SELECT * from pms_product_attribute where product_attribute_category_id=3;
SELECT * from pms_product_attribute where id in (SELECT product_attribute_id from pms_product_attribute_value where product_id=26);
SELECT * from pms_product_category_attribute_relation where product_attribute_id in (SELECT product_attribute_id from pms_product_attribute_value where product_id=26);;

SELECT * from pms_product_attribute_category where id =3;
SELECT * from pms_product_category where id=19;

SELECT * from pms_product_full_reduction where product_id=26;
SELECT * from pms_product_ladder where product_id=26;
SELECT * from pms_product_operate_log where product_id=26;
SELECT * from pms_product_vertify_record where product_id=26;

SELECT * from pms_product_attribute ;
SELECT * from pms_product_attribute_category;

SELECT * from ums_member ;
SELECT * from sms_home_advertise;
SELECT * from ums_member_receive_address ;

select * from oms_cart_item where member_id=17;
select * from oms_order where member_id=17;
select * from oms_order_item where order_id=51;
SELECT * from sms_coupon;
SELECT * from sms_coupon_history;
SELECT * from sms_coupon_product_relation;
SELECT * from sms_coupon_product_category_relation;

SELECT * from oms_order_setting;


update sms_flash_promotion_product_relation set flash_promotion_price =196 where flash_promotion_price is null
SELECT * from sys_permission where type=1 ;

SELECT id, name, start_time, end_time FROM sms_flash_promotion_session WHERE sms_flash_promotion_session.store_id = 1
 AND status = 1;

SELECT * from sms_flash_promotion_product_relation ;

-- update sys_permission set `status`=1
SELECT * from sms_flash_promotion_session;

接口需求
1、会员获得的君米排位赛。描述:获得的君米是会员发帖其他人给予的打赏(自身购买的除外),每篇文章每位会员只能打赏一次。
2、后台设计两个奖品栏,第二栏为VIP会员追加的奖励。
3、此活动是所有会员的评选,设计关系的关联。
4、排位名次前端需求按君米数实时更新。



http://ext.dcloud.net.cn/plugin?id=214
http://ext.dcloud.net.cn/plugin?id=465
http://ext.dcloud.net.cn/plugin?id=232
http://ext.dcloud.net.cn/plugin?id=271
http://ext.dcloud.net.cn/plugin?id=467
http://ext.dcloud.net.cn/plugin?id=235
http://ext.dcloud.net.cn/plugin?id=434 水印
http://ext.dcloud.net.cn/plugin?id=417 物流
http://ext.dcloud.net.cn/plugin?id=305 优惠券
http://ext.dcloud.net.cn/plugin?id=299 城市选择
http://ext.dcloud.net.cn/?page=33 评价模版
http://ext.dcloud.net.cn/plugin?id=214 圆环统计
http://ext.dcloud.net.cn/plugin?id=104 cms

订单统计
select DATE_FORMAT(create_time, '%Y-%m-%d') day1,sum(pay_amount) FROM oms_order group by day1 HAVING day1>='2019-08-01' ORDER BY day1


h5
alipay WAP
isWeiXin wechatpay JSAPI_OFFICIAL
wechatpay MWEB



####项目一nginx配置文件

server {

 #访问端口(页面访问端口)
 listen 80;
 server_name www.yjlive.cn;

 error_page 500 502 503 504 /50x.html;
 location = /50x.html {
 root html;
 }

 location / {
 # 前端工程根目录
 root /root/jm/h5;
 index index.html;
 }


		#没有跨域需求可以不配
 #代理路径 地址是以spi开头的 ‘/api开头的都走这个代理’
 # 将前端访问的后台端口变更为‘前台id:前台端口/api/xxx/xxx’

 location /api {

 #正则表达式匹配路径

 rewrite ^/api/(.*)$ /1ドル break;

 include uwsgi_params;

 #后端端口(后端最终访问的端口)

 proxy_pass http://39.106.212.32:8081 ;

 }
 location @router {
 rewrite ^.*$ /index.html last;
 }
 }



	server {

 #访问端口(页面访问端口)
 listen 80;
 server_name www.yjlive.cn;
		#root /usr/local/www/;
 error_page 500 502 503 504 /50x.html;
 location = /50x.html {
 root html;
 }
 ##项目一,同过域名直接访问
		location / {
 #前端工程根目录
 alias /root/jm/h5/;
 index index.html;
 }
 ##项目二,同过域名.com/YYY访问
 location /h5 {
 # 前端工程根目录
 alias /root/jm/mall/;
			try_files $uri $uri/ @router;
			index index.html;
 }
		# 没有跨域需求可以不配
 #代理路径 地址是以spi开头的 ‘/api开头的都走这个代理’
 # 将前端访问的后台端口变更为‘前台id:前台端口/api/xxx/xxx’
 location /api {

 #正则表达式匹配路径

 rewrite ^/api/(.*)$ /1ドル break;

 include uwsgi_params;

 #后端端口(后端最终访问的端口)

 proxy_pass http://39.106.212.32:8081 ;

 }
 location @router {
 rewrite ^.*$ /index.html last;
 }
 }