java涉及时间条件查询

var txtBgDate = new Ext.form.field.Date({
  name: 'bgDate',
  fieldLabel: '开始日期',
  format: 'Y-m-d',
  maxValue:new Date(),
  value:MyDateUtil.dateToStr('yyyy-MM-01', new Date()),
  maxLength: 20,
  labelAlign: 'right',
  allowBlank: false,
  labelWidth: 60,
  width: 180,
  editable:false,
  listeners:
  {
    //添加日期选择事件
    "select": function (field, value) {
      txtEndDate.setMinValue(value);
    }
  }
});

var txtEndDate = new Ext.form.field.Date({
  name: 'endDate',
  fieldLabel: '结束日期',
  maxLength: 20,
  minValue:txtBgDate.getValue(),
  maxValue:new Date(),
  format: 'Y-m-d',
  value:new Date(),
  allowBlank: false,
  labelAlign: 'right',
  labelWidth: 60,
  width: 180,
  editable:false,
});
var pageSize = 100;
<%=jsjx.wls.controller.HomeController.extModel("TStorageOrder", "SOModel", "ordertime,askdeliverytime,deliverytime,receivetime,createtime")%>
//订单列表Store
var store = Ext.create('Ext.data.Store', {
  autoLoad: true,
  model: 'SOModel',
  pageSize: pageSize,
  proxy:{
    type:'ajax',
    url:'OrderSto/loadFacOrderList',
    reader:{type:'json',rootProperty:'data'}
  },
  listeners: {
    beforeload: function (store, options) {
      var params = { soCode:txtSOCODE.getValue(),beginDate:txtBgDate.getValue(),endDate:txtEndDate.getValue()};
      Ext.apply(store.proxy.extraParams, params);
    }
  }
});


@RequestMapping("/loadFacOrderList")
public void loadFacOrderList(String soCode, String beginDate, String endDate, HttpServletRequest request, HttpServletResponse response, HttpSession session) {
    if (!Print.CheckPermisson("", session, response)) return;
    UserToken ut = (UserToken) session.getAttribute("user");
    AtomicReference<Long> Count = new AtomicReference<Long>();
    Integer page = Integer.parseInt(request.getParameter("page"));
    Integer limit = Integer.parseInt(request.getParameter("limit"));
    beginDate = beginDate.replace("T00:00:00", "") + " 00:00:00";
    endDate = endDate.replace("T00:00:00", "") + " 23:59:59";
    List<TStorageOrder> list = orderStoService.loadFacOrderList(soCode, beginDate, endDate, ut.getCurrentUser(), page, limit, Count);
    Json json = new Json();
    json.setSuccess(true);
    json.setData(list);
    json.setCount(Count.get());
    json.setTotal(Count.get());
    Print print = new Print();
    print.WriteJson(response, json);

}

@Override
public List<TStorageOrder> loadFacOrderList(String soCode, String beginDate, String endDate, LoginUser loginUser, Integer start, Integer limit, AtomicReference<Long> Count) {
    try {
        PageHelper.startPage(start, limit, true);
        String sql = "select a.*, b.Name statename from TStorageOrder a left join TDicData b on a.State = b.Code and b.DicCode = 'D0004' where (a.State = '01' or a.State = '02' or a.State = '03') and a.FactoryCode = '" + loginUser.getDepCode() + "' ";
        if (StringUtils.isNotBlank(soCode)) {
            sql += "and a.SOCode like '%" + soCode + "%' ";
        }
        if (StringUtils.isNotBlank(beginDate)) {
            sql += "and a.OrderTime>='" + beginDate + "' ";
        }
        if (StringUtils.isNotBlank(endDate)) {
            sql += "and a.OrderTime<='" + endDate + "' ";
        }
        sql += "order by a.OrderTime desc , a.SOCode desc, a.State";
        List<TStorageOrder> list = orderMapper.findBySql(sql);
        PageInfo<TStorageOrder> page = new PageInfo<TStorageOrder>(list);
        Count.set(page.getTotal());
        return page.getList();
    } catch (Exception ex) {
        logger.error(ex);
    } finally {
    }
    return null;
}

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值