Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagejs
//浏览器控制台打印出query,这个变量是控件提交给服务器的查询参数,可以通过修改query里面的条件实现特殊查询
console.log(query);
//当前日期
var dendDateStr = new Date()null;
console.log(d);
//找出过滤条件中的日期
for(var yeari = d.getFullYear()0; vari month< = d.getMonth()+1;
if(month<10) {
  month="0"+month;
}
var day = '01';
query.filterKeys.length; i++){
  if(query.filterKeys[i] === "日期"){ //这里请将日期修改为相应的字段名
    endDateStr = query.filterValues[i];
	break;
  }
}
if(endDateStr != null){
  var fromDateStr = yearendDateStr.substr(0,7)+"-"+month+'-'+day;
01"; //将  2019-10截取出来,拼装成 2019-10-01
  console.log("fromDateStr: "+fromDateStr);
  query.filterKeys.push("日期");  //这里请将日期修改为相应的字段名
  query.filterValues.push(" >='"+fromDateStr+"' ");
}
//再次打印query,在控制台看看是否修改成功,是否与其他字段冲突
//最后生成的sql就是  日期 >= '2019-10-01' and 日期 <= '2019-10-xx'
console.log(query);

 



 

 

 

 

 

...