java涉及时间条件查询

最新推荐文章于 2023-01-31 14:54:41 发布

周厉

最新推荐文章于 2023-01-31 14:54:41 发布

阅读量2.9k

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/qq_15237993/article/details/65934853

版权

java 专栏收录该内容

19 篇文章 1 订阅

订阅专栏

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;
}