/**
* 插入新的傭金資料
*
* @param ProjectCommissionRequestVo vo
* @return ProjectCommissionResponseVo
* @throws Exception
*/
public ProjectCommissionResponseVo newCommission(ProjectCommissionRequestVo vo) {
ProjectCommissionResponseVo resp = new ProjectCommissionResponseVo();
long newId = 0;
String txStatus = "";
boolean chk = false;
String newPro = "";
try {
// logger.debug("newProjectCommission entry=======================");
// logger.debug("ProjectCommissionRequestVo vo:" + vo);
CommissionVo rvo = new CommissionVo();
CommissionDao dao = new CommissionDao();
rvo.setCost(vo.getCost());
rvo.setProjectprice(vo.getProjectprice());
rvo.setVoice_reward(vo.getVoice_reward());
rvo.setVoice_data_reward(vo.getData_reward());
rvo.setData_reward(vo.getData_reward());
rvo.setBonus(vo.getBonus());
rvo.setCost_gap(vo.getCost_gap());
rvo.setRatesid(vo.getRatesid());
newPro = StringTK.cleanInvalidString(Strings.nullToEmpty(vo.getPrmotion_code()));
rvo.setPrmotion_code(newPro);
// 插入新的傭金資料
chk = dao.insert(rvo);
if (!chk) {
throw new Exception("EC001:新增專案主檔失敗");
}
newId = rvo.getId();
View_project_commissionVo f = dao.viewFindByCommissionId(newId);
List<View_project_commissionVo> list = new ArrayList<View_project_commissionVo>();
list.add(f);
resp.setTxCode(vo.getTxCode());
resp.setData(list);
resp.setTxStatus(ApplicationConstant.TX_SUCCESS); // 設定交易成功狀態
} catch (Exception e) {
txStatus = e.getMessage();
logger.error(e.getMessage());
resp.setTxStatus(txStatus);
} finally {
try {
String ac = getResource().getRequestTranslet().getAccount();
long aUid = UsersTK.getIdFromAccount(ac);
LogTK.info(aUid, LogTK.CATEGORY_PROJECT, "新增傭金資料:" + newId + "/" + resp.getTxStatus());
} catch (Exception e) {
}
}
return resp;
}
/**
* 更新傭金資料
*
* @param ProjectCommissionRequestVo vo
* @return ProjectCommissionResponseVo
* @throws Exception
*/
public ProjectCommissionResponseVo updateCommission(ProjectCommissionRequestVo vo) {
ProjectCommissionResponseVo resp = new ProjectCommissionResponseVo();
String txStatus = "";
boolean chk = false;
String newPro = "";
try {
CommissionVo rvo = new CommissionVo();
CommissionDao dao = new CommissionDao();
// 插入新的費率標籤
chk = dao.update(vo.getData());
if (!chk) {
throw new Exception("EC001:修改專案佣金失敗");
}
resp.setTxCode(vo.getTxCode());
// resp.setData(list);
resp.setTxStatus(ApplicationConstant.TX_SUCCESS); // 設定交易成功狀態
// }
} catch (Exception e) {
txStatus = e.getMessage();
logger.error(e.getMessage());
resp.setTxStatus(txStatus);
} finally {
try {
String ac = getResource().getRequestTranslet().getAccount();
long aUid = UsersTK.getIdFromAccount(ac);
LogTK.info(aUid, LogTK.CATEGORY_PROJECT, "更新傭金資料:" + vo.getId() + "/" + resp.getTxStatus());
} catch (Exception e) {
}
}
return resp;
}
public ProjectCommissionResponseVo listBySubPrjId(ProjectCommissionRequestVo vo) {
ProjectCommissionResponseVo resp = new ProjectCommissionResponseVo();
String txStatus = "";
// boolean chk = false;
try {
// logger.debug("listBySubPrjId entry=======================");
// logger.debug("ProjectCommissionRequestVo vo:" + vo);
CommissionDao dao = new CommissionDao();
// CommissionVo data = CommisssionTK.findCommissionById(vo.getId());
List<View_project_commissionVo> list = dao.viewListBySubPrjId(vo.getSubsetid());
// List<CommissionVo> list = CommisssionTK.findCommissionByRatesId(vo.getRatesid());
if (NullTK.isNull(list)) {
logger.debug("Commission of Project is not exist");
txStatus = "傭金資料不存在";
logger.warn(txStatus);
throw new Exception(txStatus);
} else {
resp.setTxCode(vo.getTxCode());
resp.setData(list);
resp.setTxStatus(ApplicationConstant.TX_SUCCESS); // 設定交易成功狀態
}
} catch (Exception e) {
txStatus = e.getMessage();
logger.error(e.getMessage());
resp.setTxStatus(txStatus);
} finally {
}
return resp;
}