public void changeStates(String states,String id){
Map<String,String> parameter = new HashMap<String,String>();
parameter.put("id", id);
parameter.put("type", states);
Map<String,Object> result = bankSettelService.updateStates(parameter);
this.printHtml(result.get("count"));
}
/**
* <p>修改結算表狀態
* @param parameter
* @return
*/
public Map<String,Object> updateStates(Map<String,String> parameter){
Query query = this.getRepository().createQuery();
Map<String,Object> result = new HashMap<String,Object>();
List<Object> sqlParam = new ArrayList<Object>();
StringBuilder sql = new StringBuilder();
String[] arrParam = parameter.get("id").split(",");
String paramIn = "'";//回購單編號
String type = "";//回購單修改后狀態
int count = 0; //修改行數
for(String param:arrParam){
paramIn += param + "','";
}
paramIn = paramIn.substring(0,paramIn.length() - 2);
//回購單狀態
if("1".equals(parameter.get("type"))){
type = REPUR_SETTEL_STATUS03; //待付款
} else if("2".equals(parameter.get("type"))){
type = REPUR_SETTEL_STATUS06; //審批退回
} else if("3".equals(parameter.get("type"))){
type = REPUR_SETTEL_STATUS04; //作廢
} else if("4".equals(parameter.get("type"))){
type = REPUR_SETTEL_STATUS05; //已付款
}
//修改狀態
if(!StringUtils.isEmpty(type)){
Update update = new Update();
//更新回購結算單狀態 如果為已付款 同時要更新回購單狀態為已付款
if("4".equals(parameter.get("type"))){
//更新回購結算單狀態
update.set("BUYBACKSTATEMENT_STATUS = '" + type + "'")
.set("PAYMENTSTATUS = '1'")
.set("PAYMENTDATE = '" + CommonHelper.getCreateTimeToString()+"'")
.update("TB_E_BUYBACKSTATEMENT")
.where("ID in("+paramIn+")");
//查看對應的客戶回購單客戶結算回購狀態是否為已付款，如果是，要更改回購單狀態已付款
sql.append(updateBankReStatusSql);
sql.append("and ID in(" + CL_LF);
sql.append(getSettleStatusSql);
sql.append("AND BUYBACKSTATEMENT.ID in(" + paramIn + ")" + CL_LF);
sql.append(")" + CL_LF);
sql.append("AND FINANCEAFFIRMSTATSUS = ?" + CL_LF);
sqlParam.add(REPUR_STATUS09);//回購單狀態為已付款
sqlParam.add(CREPUR_STATUS04);//客戶回購單結狀態為已付款
query.execute(sql.toString(),sqlParam);
}else{
update.set("BUYBACKSTATEMENT_STATUS = '" + type + "'")
.update("TB_E_BUYBACKSTATEMENT")
.where("ID in("+paramIn+")");
}
count = query.execute(update);
}
result.put("count", count);
return result;
}
function changeStates(flag) {
var checkValues = getCoulmnValue(oTable,'key');
if(isEmpty(checkValues)){
showInfo("请é??æ?©æ?°æ?®");
return false;
} else {
if(flag == 1){
if(confirm('确认审æ?¹æ?¯å?¦é??è¿?ï¼?')){
saveStates(flag,checkValues);
}
}else if(flag == 4){
if(confirm('确认�款�')){
saveStates(flag,checkValues);
}
}else{
saveStates(flag,checkValues);
}
}
}
//审æ?¹æ?°æ?®æ??交
function saveStates(flag,checkValues){
$.ajax({
type: 'get',
url: "<c:url value='/j8_bankSettle/changeStates/'/>"+flag+"/"+checkValues,
dataType: 'html',
success: function(data){
if(data > 0){
showInfo("æ??ä½?æ??å??");
query();
}else{
showError("æ??ä½?失败");
return false;
}
}
});
}
<c:choose>
<c:when test="${optype eq 'approval'}">
<button class="icon-edit" onclick="changeStates(1);">
審批通過
</button>
<button class="icon-edit" onclick="changeStates(2);">
審批退回
</button>
<button class="icon-edit" onclick="changeStates(3);">
作廢
</button>
</c:when>
<c:when test="${optype eq 'payment'}">
<button class="icon-edit" onclick="changeStates(4);">
付款
</button>
</c:when>
</c:choose>
{ "sName": "id","sColumnDataType":"checkbox","sClass": "keyclass",
"sColumnDataTypePro":{'name':'key'},"bSortable": false, "aTargets": [ 1 ]},