/**
* 根据查询条件分页查询出符合条件的商品订单信息（后台）
*
* @author 左香勇 2014-9-13
* @update
* @param conSumerOrderData 查询条件实体信息 pageRoll 分页查询对象 userData 用户信息
* @return List<ConsumerOrderGoodsinfoData> 符合查询条件商品订单信息集合
* @since vmaque 1.5
*/
public List<ConsumerOrderGoodsinfoData> getConSumerOrderGoodsInfoDataListBack(
PageRoll pageRoll, ConSumerOrderData conSumerOrderData, UserData userData) {
// 定义查询语句
StringBuffer querySql = new StringBuffer("SELECT ");
querySql.append("MCG.ID AS ID,MCG.GOODSNUM AS GOODSNUM,");
querySql.append(
"MCO.ID AS CONSUMERORDERID,MCO.PRICE AS PRICE,MCO.STATE AS STATE,MCO.CREATETIME AS CREATETIME,MCO.LOGISTICSCOMPANY AS LOGISTICSCOMPANY,MCO.LOGISTICSNUMBER AS LOGISTICSNUMBER,MCO.DELIVERTIME AS DELIVERTIME,");
querySql.append("MCC.CONFIGNAME AS CONFIGNAME,");
querySql.append("MGI.GOODSNAME AS GOODSNAME,");
querySql.append(
"MCU.USERNAME AS USERNAME,MCU.USERADDRESS AS USERADDRESS,MCU.USERMOBILE AS USERMOBILE ");
querySql.append("FROM MINI_CONSUMERORDER_GOODSINFO MCG ");
querySql.append("JOIN MINI_CONSUMERORDER MCO ON MCG.CONSUMERORDERID = MCO.ID ");
querySql.append("JOIN MINI_COMMODITYCONFIG MCC ON MCG.COMMODITYCONFIGID = MCC.ID ");
querySql.append("JOIN MINI_GOODSINFO MGI ON MCG.GOODSINFID = MGI.ID ");
querySql.append("JOIN MINI_CONSUMERUSER MCU ON MCO.CONSUMERUSERID = MCU.ID ");
querySql.append("JOIN MINI_PAGE MPG ON MCO.PAGEID=MPG.ID ");
querySql.append("JOIN CTN_SYSUSER CSU ON MPG.USER_ID=CSU.ID ");
querySql.append(
"WHERE MCG.ISDELETE = 1 AND MCO.ISDELETE = 1 AND MCC.ISDELETE = 1 AND MGI.ISDELETE = 1 AND MCU.ISDELETE = 1 ");
// 定义查询条件
StringBuffer where = new StringBuffer("");
List<Object> objects = new ArrayList<Object>();
// 判断订单对象是否为空，不为空添加查询条件
if (conSumerOrderData != null) {
// 判断订单状态是否为空，添加订单状态条件
if (conSumerOrderData.getState() != null) {
where.append(" AND MCO.STATE=?");
objects.add(conSumerOrderData.getState());
}
// 判断客户对象是否为空
if (conSumerOrderData.getConSumerUserData() != null) {
// 判断客户姓名是否为空，添加客户姓名条件
if (conSumerOrderData.getConSumerUserData().getUserName() != null
&& !conSumerOrderData.getConSumerUserData().getUserName().equals("")) {
where
.append("AND MCU.USERNAME LIKE '%")
.append(conSumerOrderData.getConSumerUserData().getUserName())
.append("%' ");
}
// 判断客户电话是否为空，添加客户电话条件
if (conSumerOrderData.getConSumerUserData().getUserMobile() != null
&& !conSumerOrderData.getConSumerUserData().getUserMobile().equals("")) {
where
.append("AND MCU.USERMOBILE LIKE '%")
.append(conSumerOrderData.getConSumerUserData().getUserMobile())
.append("%' ");
}
}
}
// 判断用户对象是否为空，不为空添加查询条件
if (userData != null) {
if (userData.getLoginMail() != null && !userData.getLoginMail().equals("")) {
where.append("AND CSU.LOGINMAIL LIKE '%").append(userData.getLoginMail()).append("%' ");
}
if (userData.getLoginMoble() != null && !userData.getLoginMoble().equals("")) {
where.append("OR CSU.LOGINMOBLE LIKE '%").append(userData.getLoginMoble()).append("%' ");
}
}
querySql.append(where.toString());
// 分页查询
pageRoll.setCountSQL("SELECT COUNT(1) FROM (" + querySql.toString() + ")");
pageRoll.setSearchSQL(querySql.toString());
JdbcDao jdbcDao = (JdbcDao) SpringContextHelper.getBean("jdbc"); // 获取jdbc
List<ETIPResultSet> rsList = jdbcDao.search(pageRoll, objects);
List<ConsumerOrderGoodsinfoData> consumerOrderGoodsinfoDatas =
new ArrayList<ConsumerOrderGoodsinfoData>();
for (int i = 0; i < rsList.size(); i++) {
ConsumerOrderGoodsinfoData consumerOrderGoodsinfoData = new ConsumerOrderGoodsinfoData();
ConSumerOrderData sumerOrderData = new ConSumerOrderData();
GoodsInfoData goodsInfoData = new GoodsInfoData();
CommodityConfigData commodityConfigData = new CommodityConfigData();
ConSumerUserData conSumerUserData = new ConSumerUserData();
conSumerUserData.setUserName(rsList.get(i).getString("USERNAME"));
conSumerUserData.setUserAddress(rsList.get(i).getString("USERADDRESS"));
conSumerUserData.setUserMobile(rsList.get(i).getString("USERMOBILE"));
sumerOrderData.setConSumerUserData(conSumerUserData);
sumerOrderData.setId(rsList.get(i).getString("CONSUMERORDERID"));
sumerOrderData.setCreateTime(rsList.get(i).getDate("CREATETIME"));
sumerOrderData.setPrice(rsList.get(i).getDouble("PRICE"));
sumerOrderData.setState(rsList.get(i).getInt("STATE"));
sumerOrderData.setLogisticsCompany(rsList.get(i).getString("LOGISTICSCOMPANY"));
sumerOrderData.setLogisticsNumber(rsList.get(i).getString("LOGISTICSNUMBER"));
sumerOrderData.setDeliverTime(rsList.get(i).getDate("DELIVERTIME"));
commodityConfigData.setConfigName(rsList.get(i).getString("CONFIGNAME"));
goodsInfoData.setGoodsName(rsList.get(i).getString("GOODSNAME"));
consumerOrderGoodsinfoData.setCommodityConfigData(commodityConfigData);
consumerOrderGoodsinfoData.setGoodsInfoData(goodsInfoData);
consumerOrderGoodsinfoData.setConSumerOrderData(sumerOrderData);
consumerOrderGoodsinfoData.setGoodsNum(rsList.get(i).getInt("GOODSNUM"));
consumerOrderGoodsinfoData.setId(rsList.get(i).getString("ID"));
consumerOrderGoodsinfoDatas.add(consumerOrderGoodsinfoData);
}
return consumerOrderGoodsinfoDatas;
}
