VegBank

/*

 *	'$RCSfile: VegbankUpdateTag.java,v $'

 *	Authors: @author@

 *	Release: @release@

 *

 *	'$Author: mlee $'

 *	'$Date: 2005/09/16 00:53:31 $'

 *	'$Revision: 1.3 $'

 *

 * This program is free software; you can redistribute it and/or modify

 * it under the terms of the GNU General Public License as published by

 * the Free Software Foundation; either version 2 of the License, or

 * (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

 */

package org.vegbank.ui.struts.taglib;

import java.lang.reflect.InvocationTargetException;

import java.util.Locale;

import java.util.Map;

import java.util.*;

import java.text.SimpleDateFormat;

import java.math.BigDecimal;

import java.math.BigInteger;

import java.text.Format;

import java.text.DecimalFormat;

import java.text.NumberFormat;

import javax.servlet.jsp.JspException;

import javax.servlet.jsp.PageContext;

import javax.servlet.jsp.tagext.TagSupport;

import javax.servlet.http.HttpServletRequest;

import org.apache.commons.logging.Log;

import org.apache.commons.logging.LogFactory;

import org.apache.commons.beanutils.PropertyUtils;

import org.apache.struts.util.MessageResources;

import org.apache.struts.util.RequestUtils;

import org.apache.struts.util.ResponseUtils;

import org.apache.struts.taglib.bean.WriteTag;

import org.vegbank.common.Constants;

import org.vegbank.common.command.GenericCommand;

import org.vegbank.common.utility.Utility;

import org.vegbank.common.utility.ServletUtility;

import org.vegbank.ui.struts.VegbankAction;

import org.vegbank.common.utility.DatabaseAccess;

import org.vegbank.common.utility.DatabaseUtility;

/**

 * Tag that asks the database to reserve new accession codes for client databases

 *    (i.e. VegBranch, Carolina Veg Survey, etc.)

 *

 *

 * @author M. Lee

 * @version $Revision: 1.3 $ $Date: 2005/09/16 00:53:31 $

 */

public class VegbankRequestAccessionCodeTag extends VegbankTag {

	private static final Log log = LogFactory.getLog(VegbankRequestAccessionCodeTag.class);

	//private static final String DATABASE_ACCESSION_KEY_PREASSIGN = Utility.DATABASE_ACCESSION_KEY_PREASSIGN;

	public static final String AUTH_CUSTOM = "custom";

    private static ResourceBundle tblabbreviations =

			ResourceBundle.getBundle("accession");

    /**

     * Process the start tag.

     *

     * @exception JspException if a JSP exception has occurred

     */

    public int doStartTag() throws JspException {

		HttpServletRequest request = (HttpServletRequest)pageContext.getRequest();

		try {

           // TLD Does all this:

//		    if (Utility.isStringNullOrEmpty(getTable())) { log.error("Attribute 'table' is required"); return SKIP_BODY;}

			//if (Utility.isArrayNullOrEmpty(getFieldNamesArray())) { log.error("Attribute 'fieldNames' is required"); return SKIP_BODY;}

//			if (Utility.isStringNullOrEmpty(getRecordcount())) { log.error("Attribute 'recordcount' is required"); return SKIP_BODY;}

//			if (Utility.isStringNullOrEmpty(getRequestkey())) { log.error("Attribute 'requestkey' is required"); return SKIP_BODY;}

          //  String authScheme =  getAuth();

		  //	if (Utility.isStringNullOrEmpty(authScheme)) { authScheme = AUTH_USR_ID; }

            // instantiate this entity

            //Utility.createObject("org.vegbank.common.model." +

            //       Utility.upperCaseFirstLetter(entity.toLowerCase()));

		//	Class entityClass = Class.forName("org.vegbank.common.model." +

        //            Utility.upperCaseFirstLetter(entity.toLowerCase()));

        //    String pkName = (String)entityClass.getField("PKNAME").get(null);

        //    String tableName = entity;

            //the database key

            String dbKey = Utility.DATABASE_ACCESSION_KEY_PREASSIGN;

            //the table:

            log.debug("getting table abbreviations");

			String tableAbbrev = tblabbreviations.getString("abbr." + getTable());

            String reqkey = getRequestkey();

            int reccount = Integer.parseInt(getRecordcount());

              // build INSERT sql

			  StringBuffer sql = new StringBuffer(128);

			  //  StringBuffer selectsql = new StringBuffer(128);

			  //get main clause from SQLStore

			  sql.append("INSERT INTO dba_test ( dba_testrequestacc_id, databasekey, tableabbrev) ");

              sql.append(" values ('").append(reqkey).append("','").append(dbKey).append("','").append(tableAbbrev).append("')");

              log.debug("asking for accession codes via " + sql.toString());

              log.debug("asking for accession codes how many times: " + reccount);

           DatabaseAccess da = new DatabaseAccess();

          for (int i=0; i< reccount; i++) {

               da.issueUpdate(DatabaseUtility.removeSemicolons(sql.toString()));

		   }

		   log.debug("compiling accession codes");

		   da.issueUpdate("UPDATE dba_test SET accessionCode = databasekey || '.' || tableabbrev || '.' || dba_test_id || '.' || confirmcode  WHERE accessionCode is null");

           log.debug("finished with inserting new accessionCodes");

		} catch (Exception ex) {

			log.error("Error while running <vegbank:requestaccessioncode> ", ex);

		}

        return SKIP_BODY;

    }

    /**

	 *

     */

  	 protected String table;

      public String getTable() {

          return findAttribute("table", this.table);

      }

      public void setTable(String t) {

          this.table = t;

    }

    /**

	 *

     */

  	 protected String requestkey;

      public String getRequestkey() {

          return findAttribute("requestkey", this.requestkey);

      }

      public void setRequestkey(String rk) {

          this.requestkey = rk;

    }

 /**

	 *

     */

  	 protected String recordcount;

      public String getRecordcount() {

          return findAttribute("recordcount", this.recordcount);

      }

      public void setRecordcount(String r) {

          this.recordcount = r;

    }

}