/**
* 메일필터링을 삭제후에 인서트 한다.
*
* @param massmailID
* @param scheduleID
* @return
*/
public int insertAfterDeleteMassMailFilter(int massmailID, int scheduleID) {
int result = 0;
TransactionStatus status =
getTransactionManager()
.getTransaction(getDefinition(TransactionDefinition.ISOLATION_READ_COMMITTED, false));
try {
result = massmailStatisticDAO.deleteMassMailFilter(massmailID, scheduleID);
result = massmailStatisticDAO.insertMassMailFilter(massmailID, scheduleID);
getTransactionManager().commit(status);
} catch (Exception e) {
getTransactionManager().rollback(status);
logger.error(e);
}
return result;
}
/**
* massmailID로 조회하여 tm_massmail_failstatistic에 있는지 확인
*
* @param massmailID
* @return
*/
public int getMassmailIDFailCount(int massmailID, int scheduleID) {
int result = 0;
try {
result = massmailStatisticDAO.getMassmailIDFailCount(massmailID, scheduleID);
} catch (Exception e) {
logger.error(e);
}
return result;
}
/**
* 통계를 수집할 massmailID를 구한다.
*
* @return
*/
public List<Map<String, Object>> getMassmailIDStatistic() {
List<Map<String, Object>> result = null;
try {
result = massmailStatisticDAO.getMassmailIDStatistic();
} catch (Exception e) {
logger.error(e);
}
return result;
}
/**
* 발송일 기준으로 다운로드 가능기간이 지난 첨부파일은 삭제
*
* @param tableName
* @return
*/
public int deleteSendedFiles(int sendedFileEndDate) {
int result = 0;
try {
result = massmailStatisticDAO.deleteSendedFiles(sendedFileEndDate);
} catch (Exception e) {
logger.error(e);
}
return result;
}
/**
* 오픈/클릭 결과를 sendresult테이블에 업데이트 할 sendID의 갯수를 가져온다
*
* @return
*/
public int getCountOpenClickSendIDs(int massmailID, int scheduleID) {
int result = 0;
try {
result = massmailStatisticDAO.getCountOpenClickSendIDs(massmailID, scheduleID);
} catch (Exception e) {
logger.error(e);
}
return result;
}
/**
* 오픈/클릭 결과를 sendresult테이블에 업데이트 할 sendID를 가져온다
*
* @return
*/
public List<MassMailOpenResult> getOpenClickSendIDs(int massmailID, int scheduleID) {
List<MassMailOpenResult> result = null;
try {
result = massmailStatisticDAO.getOpenClickSendIDs(massmailID, scheduleID);
} catch (Exception e) {
logger.error(e);
}
return result;
}
/**
* 대량메일레코드 삭제
*
* @param tableName
* @return
*/
public int deleteMassMailRowByTable(String tableName, int massmailID) {
int result = 0;
try {
result = massmailStatisticDAO.deleteMassMailRowByTable(tableName, massmailID);
} catch (Exception e) {
logger.error(e);
}
return result;
}
/**
* 대량메일 발송 사용자 정보
*
* @param massmailID
* @return
* @throws DataAccessException
*/
public Map<String, Object> getUserInfoByMassMail(int massmailID, int scheduleID) {
Map<String, Object> result = null;
try {
result = massmailStatisticDAO.getUserInfoByMassMail(massmailID, scheduleID);
} catch (Exception e) {
logger.error(e);
}
return result;
}
/**
* 통계업데이트 표시
*
* @param massmailID
* @param scheduleID
* @return
* @throws DataAccessException
*/
public int updateStatisticYN(int massmailID, int scheduleID) {
int result = 0;
try {
result = massmailStatisticDAO.updateStatisticYN(massmailID, scheduleID);
} catch (Exception e) {
logger.error(e);
}
return result;
}
/**
* 불확실한 오류가 있는지 체크한다.
*
* @param massmailID
* @param testmassmailID
* @return
* @throws DataAccessException
*/
public int selectCountNotKnow(int massmailID, int scheduleID) {
int result = 0;
try {
result = massmailStatisticDAO.selectCountNotKnow(massmailID, scheduleID);
} catch (Exception e) {
logger.error(e);
}
return result;
}
/**
* 메일필터링을 통계를 입력 한다.
*
* @param massmailID
* @param scheduleID
* @return
*/
public int insertMassMailFilter(int massmailID, int scheduleID) {
int result = 0;
try {
result = massmailStatisticDAO.insertMassMailFilter(massmailID, scheduleID);
} catch (Exception e) {
logger.error(e);
}
return result;
}
/**
* 스케줄을 삭제한다.
*
* @param massmailID
* @param scheduleID
* @return
*/
public int deleteMassMailSchedule(int massmailID, int scheduleID) {
int result = 0;
try {
result = massmailStatisticDAO.deleteMassMailSchedule(massmailID, scheduleID);
} catch (Exception e) {
logger.error(e);
}
return result;
}
/**
* 테이블을 삭제한다.
*
* @param tableName
* @return
*/
public int dropTable(String tableName) throws DataAccessException {
int result = 0;
try {
result = massmailStatisticDAO.dropTable(tableName);
} catch (Exception e) {
logger.error(e);
}
return result;
}
/**
* 오류체크를 업데이트
*
* @param massmailID
* @param scheduleID
* @return
*/
public int updateCheckedError(int massmailID, int scheduleID, String checkedError) {
int result = 0;
try {
result = massmailStatisticDAO.updateCheckedError(massmailID, scheduleID, checkedError);
} catch (Exception e) {
logger.error(e);
}
return result;
}
/**
* 오픈/클릭을 업데이트 한 sendID는 tm_massmail_openresult테이블에 Y 로 업데이트 한다(batch)
*
* @param openClinkLists
* @param massmailID
* @param scheduleID
* @return
* @throws DataAccessException
*/
public int[] updateMassMailOpenUpdateYNBatch(
List<MassMailOpenResult> openClinkLists, int massmailID, int scheduleID) {
int[] result = null;
try {
result =
massmailStatisticDAO.updateMassMailOpenUpdateYNBatch(
openClinkLists, massmailID, scheduleID);
} catch (DataIntegrityViolationException e) {
} catch (Exception e) {
logger.error(e);
}
return result;
}