com.hangum.tadpole.commons.sql/src/com/hangum/tadpole/engine/query/sql/TadpoleSystemLedger.java

   1 /*******************************************************************************
   2  * Copyright (c) 2017 hangum.
   3  * All rights reserved. This program and the accompanying materials
   4  * are made available under the terms of the GNU Lesser Public License v2.1
   5  * which accompanies this distribution, and is available at
   6  * http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
   7  *
   8  * Contributors:
   9  *     hangum - initial API and implementation
  10  ******************************************************************************/
  11 package com.hangum.tadpole.engine.query.sql;
  12
  13 import java.sql.SQLException;
  14 import java.text.DateFormat;
  15 import java.text.SimpleDateFormat;
  16 import java.util.Date;
  17 import java.util.HashMap;
  18 import java.util.List;
  19 import java.util.Map;
  20
  21 import org.apache.log4j.Logger;
  22
  23 import com.hangum.tadpole.commons.exception.TadpoleSQLManagerException;
  24 import com.hangum.tadpole.commons.util.ApplicationArgumentUtils;
  25 import com.hangum.tadpole.engine.initialize.TadpoleEngineUserDB;
  26 import com.hangum.tadpole.engine.manager.TadpoleSQLManager;
  27 import com.hangum.tadpole.engine.query.dao.system.UserDBDAO;
  28 import com.hangum.tadpole.engine.query.dao.system.ledger.DelegerHistoryDAO;
  29 import com.hangum.tadpole.engine.query.dao.system.ledger.LedgerDAO;
  30 import com.ibatis.sqlmap.client.SqlMapClient;
  31
  32 /**
  33  * Tadpole System ledger query
  34  *
  35  * @author hangum
  36  *
  37  */
  38 public class TadpoleSystemLedger {
  39         /**
  40          * Logger for this class
  41          */
  42         private static final Logger logger = Logger.getLogger(TadpoleSystemLedger.class);
  43
  44         /**
  45          * 오라클 변경이력데이터
  46          * @param userDBDAO
  47          *
  48          * @param ledgerDAO
  49          * @return
  50          * @throws TadpoleSQLManagerException
  51          * @throws SQLException
  52          */
  53         public static List<DelegerHistoryDAO> getOracleDetailListLedger(UserDBDAO userDBDAO, LedgerDAO ledgerDAO) throws TadpoleSQLManagerException, SQLException {
  54
  55                 SqlMapClient sqlClient = TadpoleSQLManager.getInstance(userDBDAO);
  56                 return sqlClient.queryForList("getOracleDetailListLedger", ledgerDAO);
  57         }
  58
  59         /**
  60          *
  61          * @param strUser
  62          * @param crNumber
  63          * @param endTime
  64          * @param startTime
  65          * @return
  66          * @throws TadpoleSQLManagerException
  67          * @throws SQLException
  68          */
  69         public static List<LedgerDAO> getMySQLListLedger(String strUser, String crNumber, long startTime, long endTime) throws TadpoleSQLManagerException, SQLException {
  70                 Map<String, Object> mapParam = new HashMap<String, Object>();
  71                 mapParam.put("strUser", "%" + strUser + "%");
  72                 mapParam.put("crNumber", "%" + crNumber + "%");
  73
  74                 if(ApplicationArgumentUtils.isDBServer()) {
  75                         Date dateSt = new Date(startTime);
  76                         DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss:SSS");
  77                         mapParam.put("startTime",  formatter.format(dateSt));
  78
  79                         Date dateEd = new Date(endTime);
  80                         mapParam.put("endTime", formatter.format(dateEd));
  81                 } else {
  82                         Date dateSt = new Date(startTime);
  83                         DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss:SSS");
  84
  85                         mapParam.put("startTime",  formatter.format(dateSt));
  86
  87                         Date dateEd = new Date(endTime);
  88                         mapParam.put("endTime", formatter.format(dateEd));
  89                 }
  90
  91                 SqlMapClient sqlClient = TadpoleSQLManager.getInstance(TadpoleEngineUserDB.getUserDB());
  92                 return sqlClient.queryForList("getMySQLListLedger", mapParam);
  93         }
  94
  95         /**
  96          * ledger 정보를 저장한다.
  97          *
  98          * @return
  99          * @throws TadpoleSQLManagerException, SQLException
 100          */
 101         public static LedgerDAO insertLedger(LedgerDAO ledger) throws TadpoleSQLManagerException, SQLException {
 102                 SqlMapClient sqlClient = TadpoleSQLManager.getInstance(TadpoleEngineUserDB.getUserDB());
 103                 java.lang.Integer intSeq = (java.lang.Integer)sqlClient.insert("insert_ledger", ledger);
 104                 ledger.setSeq(intSeq);
 105
 106                 return ledger;
 107         }
 108
 109         /**
 110          * 원장 데이터 저장 상태를 기록한다.
 111          *
 112          * @param ledgerDAO
 113          */
 114         public static void insertLedgerResult(LedgerDAO ledgerDAO) throws TadpoleSQLManagerException, SQLException {
 115                 SqlMapClient sqlClient = TadpoleSQLManager.getInstance(TadpoleEngineUserDB.getUserDB());
 116                 sqlClient.update("update_ledger_result", ledgerDAO);
 117         }
 118
 119 }