success:function(data){
if(data.length>0){
var map = {};
for (var i in data) {
var user_id = data[i]["USER_ID"];
if (map[user_id]) {
if (map[user_id] < data[i]["CREATE_DATE"]) {
map[user_id] = data[i]["CREATE_DATE"];
}
} else {
map[user_id] = data[i]["CREATE_DATE"];
}
//alert(user_id + " : " + map[user_id]);
}
//for (var id in map) {
//alert(id + " : " + map[id]);
//}
for(var i = 0;i<data.length; i++){
//alert (map[data[i].USER_ID] + " " + data[i].CREATE_DATE);
$("#trade").append(
"<tr>"+
"<td class='tdstyle1'>"+data[i].USER_ID + (map[data[i].USER_ID] == data[i].CREATE_DATE ? " <span style='color:red;float:right;'>" + data[i].count + "</span>" : "" ) +"</td>"+
"<td class='tdstyle'>"+data[i].TRADE_CD +"</td>" +
"<td class='tdstyle'>"+data[i].SHOP_CD+":"+data[i].SHOP_NAME +"</td>" +
"<td class='tdstyle'>"+data[i].MACHINE_CD +"</td>" +
"<td class='tdstyle'>"+data[i].MACHINE_NAME +"</td>" +
"<td class='tdstyle'>"+data[i].MACHINE_OPTION_NAME +"</td>" +
"<td class='tdstyle'>"+data[i].MASSAGE_MAIN +"</td>" +
"<td class='tdstyle'>"+data[i].MASSAGE_MEMO +"</td>" +
"<td class='tdstyle'>"+data[i].ORIGINAL_PRICE +"</td>" +
"<td class='tdstyle'>"+data[i].REMAIN_COST +"</td>" +
"<td class='tdstyle'>"+data[i].TRADE_PRICE +"</td>" +
"<td class='tdstyle'>"+data[i].CREATE_DATE +"</td>" +
"<td class='tdstyle'><a style='color:blue;' onClick=\"return confirm('是否要退款?')\" href=\"/...ApplyForResult.jsp?TRADE_CD="+data[i].TRADE_CD+"\">退款</a></td>" +
"<td class='tdstyle'><a style='color:blue;' onClick=\"return confirm('是否驳回?')\" href=\"/...ApplyForRefund?TRADE_CD="+data[i].TRADE_CD+"\">驳回</a></td>" +
"</tr>"
);
}
}else{
//alert("未查到交易订单信息");
}
if(data.length>0){
var map = {};
for (var i in data) {
var user_id = data[i]["USER_ID"];
if (map[user_id]) {
if (map[user_id] < data[i]["CREATE_DATE"]) {
map[user_id] = data[i]["CREATE_DATE"];
}
} else {
map[user_id] = data[i]["CREATE_DATE"];
}
//alert(user_id + " : " + map[user_id]);
}
//for (var id in map) {
//alert(id + " : " + map[id]);
//}
for(var i = 0;i<data.length; i++){
//alert (map[data[i].USER_ID] + " " + data[i].CREATE_DATE);
$("#trade").append(
"<tr>"+
"<td class='tdstyle1'>"+data[i].USER_ID + (map[data[i].USER_ID] == data[i].CREATE_DATE ? " <span style='color:red;float:right;'>" + data[i].count + "</span>" : "" ) +"</td>"+
"<td class='tdstyle'>"+data[i].TRADE_CD +"</td>" +
"<td class='tdstyle'>"+data[i].SHOP_CD+":"+data[i].SHOP_NAME +"</td>" +
"<td class='tdstyle'>"+data[i].MACHINE_CD +"</td>" +
"<td class='tdstyle'>"+data[i].MACHINE_NAME +"</td>" +
"<td class='tdstyle'>"+data[i].MACHINE_OPTION_NAME +"</td>" +
"<td class='tdstyle'>"+data[i].MASSAGE_MAIN +"</td>" +
"<td class='tdstyle'>"+data[i].MASSAGE_MEMO +"</td>" +
"<td class='tdstyle'>"+data[i].ORIGINAL_PRICE +"</td>" +
"<td class='tdstyle'>"+data[i].REMAIN_COST +"</td>" +
"<td class='tdstyle'>"+data[i].TRADE_PRICE +"</td>" +
"<td class='tdstyle'>"+data[i].CREATE_DATE +"</td>" +
"<td class='tdstyle'><a style='color:blue;' onClick=\"return confirm('是否要退款?')\" href=\"/...ApplyForResult.jsp?TRADE_CD="+data[i].TRADE_CD+"\">退款</a></td>" +
"<td class='tdstyle'><a style='color:blue;' onClick=\"return confirm('是否驳回?')\" href=\"/...ApplyForRefund?TRADE_CD="+data[i].TRADE_CD+"\">驳回</a></td>" +
"</tr>"
);
}
}else{
//alert("未查到交易订单信息");
}
}
获取到数据第一步:根据user_id找出时间最近的一条,
二,(map[data[i].USER_ID] == data[i].CREATE_DATE ? " <span style='color:red;float:right;'>" + data[i].count 将数字显示到页面上最近时间的一条数据上面