@Override
public AdWebTrxInfo getAdWebTrxInfoByTrxId(String trxOrderId) {
String sql =
"select bai.trxorderid,bai.adweb_cid,bai.adweb_wi,bai.buycount,bai.ordermoney,bai.ordertime,bai.userid,ba.adweb_trxurl from beiker_adwebtrxinfo bai left join beiker_adweb ba on bai.adwebid=adweb_id where trxorderid=?";
List list = getSimpleJdbcTemplate().queryForList(sql, trxOrderId);
if (list == null || list.size() == 0) return null;
AdWebTrxInfo ati = new AdWebTrxInfo();
Map map = (Map) list.get(0);
ati.setTrxorderid((String) map.get(("trxorderid")));
ati.setAdcid((String) map.get("adweb_cid"));
ati.setAdwi((String) map.get("adweb_wi"));
ati.setBuycount(((Number) map.get("buycount")).intValue());
ati.setOrderMoney(((Number) map.get("ordermoney")).doubleValue());
ati.setOrderTime((Timestamp) map.get("ordertime"));
ati.setAdweb_trxurl((String) map.get(("adweb_trxurl")));
return ati;
}
@Override
public AdWebTrxInfo mapRow(ResultSet rs, int num) throws SQLException {
AdWebTrxInfo adWebTrxInfo = new AdWebTrxInfo();
adWebTrxInfo.setAdWebTrxId(rs.getLong("adwebtrx_id"));
adWebTrxInfo.setTrxorderid(rs.getString("trxorderid"));
adWebTrxInfo.setAdcid(rs.getString("adweb_cid"));
adWebTrxInfo.setAdwebid(rs.getLong("adwebid"));
adWebTrxInfo.setAdwi(rs.getString("adweb_wi"));
adWebTrxInfo.setBuycount(rs.getInt("buycount"));
adWebTrxInfo.setOrderMoney(rs.getDouble("ordermoney"));
adWebTrxInfo.setOrderTime(rs.getTimestamp("ordertime"));
String adweb_trxurl = rs.getString("adweb_trxurl");
if (adweb_trxurl != null) {
adWebTrxInfo.setAdweb_trxurl(adweb_trxurl);
}
return adWebTrxInfo;
}
@Override
public AdWebTrxInfo getAdWebTrxInfo(Long adwebid, String adcid, String adwi) {
String sql =
"select adwebid,adweb_cid,adweb_wi,adwebtrx_id,trxorderid,buycount,ordermoney,ordertime from beiker_adwebtrxinfo where adwebid=? and adweb_cid=? and adweb_wi=?";
List list = getSimpleJdbcTemplate().queryForList(sql, adwebid, adcid, adwi);
if (list == null || list.size() == 0) return null;
AdWebTrxInfo ati = new AdWebTrxInfo();
Map map = (Map) list.get(0);
ati.setAdWebTrxId(((Number) map.get(("adwebtrx_id"))).longValue());
ati.setTrxorderid((String) map.get(("trxorderid")));
ati.setAdcid((String) map.get("adweb_cid"));
ati.setAdwebid(((Number) map.get("adwebid")).longValue());
ati.setAdwi((String) map.get("adweb_wi"));
ati.setBuycount(((Number) map.get("buycount")).intValue());
ati.setOrderMoney(((Number) map.get("ordermoney")).doubleValue());
ati.setOrderTime((Timestamp) map.get("ordertime"));
return ati;
}
@Override
public List<AdWebTrxInfo> getAdWebTrxInfoList(
String fromDate, String endDate, String srccode, String cid) {
String sql =
"select adweb_wi,ordermoney,ordertime,trxorderid from beiker_adwebtrxinfo bai left join beiker_adweb ba on bai.adwebid=adweb_id where ba.adweb_code=? and bai.adweb_cid=? and bai.ordertime>=? and bai.ordertime<=? and bai.trxorderid is not null";
List list = this.getSimpleJdbcTemplate().queryForList(sql, srccode, cid, fromDate, endDate);
if (list == null || list.size() == 0) return null;
List<AdWebTrxInfo> listAdTrxInfo = new ArrayList<AdWebTrxInfo>();
for (int i = 0; i < list.size(); i++) {
AdWebTrxInfo ati = new AdWebTrxInfo();
Map map = (Map) list.get(i);
String adweb_wi = (String) map.get("adweb_wi");
ati.setAdwi(adweb_wi);
ati.setTrxorderid((String) map.get(("trxorderid")));
Double ordermoney = ((BigDecimal) map.get("ordermoney")).doubleValue();
ati.setOrderMoney(ordermoney);
Timestamp ordertime = (Timestamp) map.get("ordertime");
ati.setOrderTime(ordertime);
listAdTrxInfo.add(ati);
}
return listAdTrxInfo;
}