笔记

 

BETWEEN 操作符 日期范围查询

https://www.w3school.com.cn/sql/sql_between.asp

支付宝沙箱环境报 invalid-app-id 错误原因: 无效的AppID参数 错误

https://blog.csdn.net/Gabriel576282253/article/details/100163176

vue 移动端H5非内置浏览器发起微信、支付宝支付

https://blog.csdn.net/chaosama/article/details/99974831?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-6.nonecase&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-6.nonecase

支付宝手机网站支付出现系统繁忙，请稍后再试（大部分是签名错误，需要查询生成签名的字段是否多或少）

https://blog.csdn.net/jason19905/article/details/78636569?utm_medium=distribute.pc_relevant_t0.none-task-blog-BlogCommendFromMachineLearnPai2-1.nonecase&depth_1-utm_source=distribute.pc_relevant_t0.none-task-blog-BlogCommendFromMachineLearnPai2-1.nonecase

 

子查询sql 优惠示例

select *
  from market_coupon cou
 where cou.is_expire = 1
   and cou.status = 1
   and cou.logic_delete = 0
   and 20200702173124 < cou.use_end_time
   and 20200702173124 > cou.use_start_time
   and cou.id in (select user.coupon_id
                    from market_coupon_user user
                   where user.user_id = '8f680f03a1dd4e14b0ec27ff7b5ae16b'
                     and user.coupon_id = cou.id)
   and (cou.goods_type = 0 or
       (cou.goods_type = 1 and
       cou.id in
       (select goods.id
            from market_coupon_goods goods
           where goods.coupon_id = cou.id
             and goods.logic_id = '6e8c64799e78418c9eb32f75e6ac893f')) or
       (cou.goods_type = 2 and
       cou.id in
       (select goods.id
            from market_coupon_goods goods
           where goods.coupon_id = cou.id
             and goods.logic_id = '09a1439fb6a54ebb9c104ffddec8422c')))

关联表查询的另一种写法

 

uniApp 一些代码

//提示信息
uni.showToast({
    title: keyword,
    icon: 'none',
    duration: 2000
});

//跳转传参
uni.navigateTo({
   url: 'seacrhresult?keywords=' + keyword,
});

js 返回上一页面 

1. Javascript 返回上一页history.go(-1), 返回两个页面: history.go(-2);
2. history.back().
3. window.history.forward()返回下一页
4. window.history.go(返回第几页,也可以使用访问过的URL)

js将数组转成json字符串

博文地址： https://blog.csdn.net/s261676224/article/details/82977796

var params = {};         
 
params["item1"] = $("#val1").val();
 
var paramsJson = JSON.stringify(params);
 
console.log(paramsJson);