/******************************************************************************
    * DatabaseConverterFormController.java - The Spring controller to alter my running production database.
    * 
    * PicMan - The BuckoSoft Picture Manager in Java
    * Copyright(c) 2006 - Dick Balaska
    * 
    */
   package com.buckosoft.PicMan.web;
   
  import java.util.HashMap;
  import java.util.Iterator;
  import java.util.List;
  import java.util.Map;
  
  import javax.servlet.http.HttpServletRequest;
  import javax.servlet.http.HttpServletResponse;
  
  import org.apache.commons.logging.Log;
  import org.apache.commons.logging.LogFactory;
  import org.springframework.validation.BindException;
  import org.springframework.web.servlet.ModelAndView;
  
  import com.buckosoft.BSAccount.web.BSAccountSimpleFormController;
  import com.buckosoft.BSAccount.web.BSAccountUserWebSession;
  import com.buckosoft.PicMan.business.PicManFacade;
  import com.buckosoft.PicMan.db.DatabaseFacade;
  import com.buckosoft.PicMan.domain.Pic;
  import com.buckosoft.PicMan.domain.Root;
  
  /**
   * The Spring controller to alter my running production database.
   * Sometimes, it is easier to throw some code in here then it is to try to 
   * fix the database with phpMyAdmin.
   * @author Dick Balaska
   * @since 2006/09/29
   */
  public class DatabaseConverterFormController extends BSAccountSimpleFormController {
  
  //	private static final boolean DEBUG = true;
      protected final Log logger = LogFactory.getLog(getClass());
  
      private DatabaseFacade	dbf;
      private PicManFacade	pmf;
  
  	public DatabaseConverterFormController() {
  		setSessionForm(true);
  		setValidateOnBinding(true);
  		setCommandName("databaseConverterForm");
  		setFormView("DatabaseConverterForm");
  	}
  
  	public void setPicMan(PicManFacade pmf) {
  		this.pmf = pmf;
  		pmf = this.pmf;		// to remove an "unread locally" warning.
  	}
  
  	public void setDatabase(DatabaseFacade dbf) {
  		this.dbf = dbf;
  	}
  
  	protected Object formBackingObject(HttpServletRequest request) throws Exception {
      	BSAccountUserWebSession userWebSession = this.bsAccountMan.getUserWebSession(request);
  		DatabaseConverterForm dcf = new DatabaseConverterForm();
  
  		dcf.setUserWebSession(userWebSession);
  		dcf.setRoots(dbf.getRoots());
  
  		String v;
  		v = request.getParameter("updSize");
  		if (v != null) {
  			dbf.getSystem().setUpdatePicSize(true);
  			dcf.setMessage("Queued updating sizes");
  		}
  		v = request.getParameter("mlbFilters");
  		if (v != null) {
  			dbf.getSystem().setUpdateMlbFilters(true);
  			dcf.setMessage("Queued MlbFilterFixer");
  		}
  		v = request.getParameter("md5sum");
  		if (v != null) {
  			dbf.getSystem().setUpdateMD5Sums(true);
  			dcf.setMessage("Queued UpdateMD5Sums");
  		}
  		v = request.getParameter("mosaicVectors");
  		if (v != null) {
  			dbf.getSystem().setCalcMosaicVectors(true);
  			dcf.setMessage("Queued calc mosaic vectors");
  		}
  		return(dcf);
  	}
  
  	protected void onBindAndValidate(HttpServletRequest request, Object command, BindException errors)
  			throws Exception {
  
  /*
  		AccountForm accountForm = (AccountForm) command;
  		Account account = accountForm.getAccount();
  
  		if (request.getParameter("account.listOption") == null) {
 			account.setListOption(false);
 		}
 		if (request.getParameter("account.bannerOption") == null) {
 			account.setBannerOption(false);
 		}
 
 		errors.setNestedPath("account");
 		getValidator().validate(account, errors);
 		errors.setNestedPath("");
 */
 	}
 
 	protected Map<String, Object> referenceData(HttpServletRequest request) throws Exception {
     	BSAccountUserWebSession userWebSession = this.bsAccountMan.getUserWebSession(request);
 		Map<String, Object> myModel = new HashMap<String, Object>();
 		myModel.put("userWebSession", userWebSession);
 //		if (DEBUG)
 //			logger.info("referenceData ChainManForm with session " + userWebSession);
 
 		return myModel;
 	}
 
 	protected ModelAndView onSubmit(
 			HttpServletRequest request, HttpServletResponse response, Object command, BindException errors)
 			throws Exception {
 
 		DatabaseConverterForm dcf = (DatabaseConverterForm) command;
 
 		boolean success = true;
 		// boolean action = false;
 
  		logger.info("oldName= '" + dcf.getOldName() + "'");
  		logger.info("newName= '" + dcf.getNewName() + "'");
 
 		if (dcf.getOldName().length() > 0 && dcf.getNewName().length() > 0) {
 			dcf.setMessage("Moved '" + dcf.getOldName() + "' to root '" + dcf.getNewName() + "'");
  			logger.info("oldName action");
  			Root root = dbf.getRoot(dcf.getNewName());
  			logger.info("rid = " + root.getRid());
  			List<Pic> pics = dbf.getPics();
  			Iterator<Pic> iter = pics.iterator();
  			while (iter.hasNext()) {
  				Pic pic = iter.next();
  				logger.info("Pic = " + pic.getName() + " loc: " + pic.getLocation());
  				if (pic.getLocation().startsWith(dcf.getOldName())) {
  					pic.setLocation(pic.getLocation().substring(dcf.getOldName().length()));
  					pic.setRid(root.getRid());
  					logger.info("Upd = " + pic.getName() + " loc: " + pic.getLocation());
  					dbf.updatePic(pic);
  				}
  			}
  		}
  		/*
 		if (cmf.getChainToDelete().length() > 0) {
 			Chain chain = new Chain();
 			chain.setName(cmf.getChainToDelete());
 			dbf.deleteChain(chain);
 			action = true;
 		}
 		if (!action && cmf.getNewChainName().length() > 0) {
 			if (DEBUG)
 				logger.info("Adding new Chain '" + cmf.getNewChainName());
 			Chain c = new Chain();
 			c.setName(cmf.getNewChainName());
 			dbf.storeChain(c);
 			newChainName = c.getName();
 			action = true;
 			
 		}
 		if (!action && cmf.getActiveChain() != null) {
 			Chain c = cmf.getActiveChain();
 			LinkedList<SetSize> newSetsSizes = parseSetsSizes(request);
 			c.setSetSizes(newSetsSizes);
 			dbf.storeChain(c);
 			action = true;
 		}
 		*/
 		if (success) {
 			response.sendRedirect("databaseConverter.do");
 			return(null);
 		}
 		else
 			return super.onSubmit(request, response, command, errors);
 	}
 }