package com.saas.biz.www.manage.itemsMgr;

import java.util.ArrayList;
import java.util.HashMap;
import com.saas.biz.dao.itemsDAO.*;
import com.saas.sys.buffer.Buffers;
import com.saas.sys.exp.SaasApplicationException;
import com.saas.sys.log.Logger;

public class ItemsQuery {
	Logger log; 
	ArrayList queryResult= new ArrayList();
	public ItemsQuery() {
		log = new Logger(this);
	}
	
	public ArrayList getQueryResult()
	{
		return this.queryResult;
	}
	public void setQueryResult(ArrayList queryResult)
	{
		this.queryResult = queryResult;
	}
	/**
	 * 獲取新增欄目的欄目列表
	 * @param inbuffer
	 */	
	public void genAddItemsList(Buffers inbuffer)
	{
		log.LOG_INFO("進入genAddItemsList方法...");
		String staffId = inbuffer.getString("STAFF_ID");
		String itemClass = inbuffer.getString("LMJB");
		String upItemId = inbuffer.getString("SJLMBS");
		
		try
		{
			this.queryResult = genAddItemsList(staffId,itemClass,upItemId);
		}
		catch(SaasApplicationException e)
		{
			 log.LOG_INFO(e.getMessage());
		}
		log.LOG_INFO("退出genAddItemsList方法...");
	}
	/**
	 * 獲取新增欄目的欄目列表
	 * @param inbuffer
	 */	
	public ArrayList genAddItemsList(String Staff_id,String itemClass,String upItemId) throws SaasApplicationException 
	{
		ArrayList itemsList= new ArrayList();
		LmxxbExt lmxxbExt = new LmxxbExt();
		int iClass = new Integer(itemClass).intValue()+1;
		String selBy = "";
		if ((upItemId.equalsIgnoreCase("") || upItemId.equalsIgnoreCase("null")) && (!Staff_id.equalsIgnoreCase("admin")))
		{
			lmxxbExt.setParam(":VLMJB", new Integer(iClass));
			lmxxbExt.setParam(":VSTAFFID", Staff_id);
			itemsList = lmxxbExt.selByList("SEL_BY_CLASS_STAFF");
			
		}
		else if (Staff_id.equalsIgnoreCase("admin"))
		{
			lmxxbExt.setParam(":VLMJB", new Integer(iClass));
			itemsList = lmxxbExt.selByList("SEL_BY_ADMIN");
		}
		//select by lmjb:根據欄目級別獲取本級別欄目信息
		if (!upItemId.equalsIgnoreCase("")) 
		{ 			
			lmxxbExt.setParam(":VLMJB", new Integer(iClass));
			lmxxbExt.setParam(":VSJLMBS", upItemId);
			itemsList = lmxxbExt.selByList("SEL_BY_UPITEM");
		}  

		return itemsList;
	}
	/**
	 *  生成新增欄目的界面
	 * @param inbuffer
	 */	
	public void genAddItemsInterf(Buffers inbuffer)
	{
		log.LOG_INFO("進入genAddItemsInterf方法...");
		String itemClass = inbuffer.getString("LMJB");
		String upItemId = inbuffer.getString("SJLMBS");
		
		try
		{
			this.queryResult = genAddItemsInterf(itemClass,upItemId);
		}
		catch(SaasApplicationException e)
		{
			 log.LOG_INFO(e.getMessage());
		}
		log.LOG_INFO("退出genAddItemsInterf方法...");
	}
	/**
	 * 生成新增欄目的界面
	 * @param itemClass
	 * @param upItemId
	 * @return
	 * @throws SaasApplicationException
	 */
	public ArrayList genAddItemsInterf(String itemClass,String upItemId) throws SaasApplicationException 
	{
		ArrayList itemsList= new ArrayList();
		LmxxbExt lmxxbExt = new LmxxbExt();
		LmxxbDAO lmxxbDaO = new LmxxbDAO();
		lmxxbExt.setParam(":VLMBS", upItemId);
		lmxxbDaO = lmxxbExt.selByInfo("SEL_BY_PK");
		if (lmxxbDaO ==  null) return null;
		int iClass = new Integer(itemClass).intValue()+1;
		itemClass =  String.valueOf(iClass); 
		HashMap map= new HashMap();
		map.put("sjlmmc", lmxxbDaO.getLmmc());
		map.put("sjlmbs", lmxxbDaO.getLmbs());
		map.put("lmjb", itemClass);
		itemsList.add(map);
		return itemsList;		
	}
	/**
	 *  生成修改欄目的界面
	 * @param inbuffer
	 */	
	public void genModifyItemsInterf(Buffers inbuffer)
	{
		log.LOG_INFO("進入genModifyItemsInterf方法...");
		String itemClass = inbuffer.getString("LMJB");
		String itemId = inbuffer.getString("LMBS");
		
		try
		{
			this.queryResult = genModifyItemsInterf(itemClass,itemId);
		}
		catch(SaasApplicationException e)
		{
			 log.LOG_INFO(e.getMessage());
		}
		log.LOG_INFO("退出genModifyItemsInterf方法...");
	}
	/**
	 * 生成修改欄目的界面
	 * @param itemClass
	 * @param upItemId
	 * @return
	 * @throws SaasApplicationException
	 */
	public ArrayList genModifyItemsInterf(String itemClass,String itemId) throws SaasApplicationException 
	{
		ArrayList itemsList= new ArrayList();
		LmxxbExt lmxxbExt = new LmxxbExt();
		LmxxbDAO lmxxbDaO = new LmxxbDAO();
		lmxxbExt.setParam(":VLMBS", itemId);
		lmxxbDaO = lmxxbExt.selByInfo("SEL_BY_PK");
		if (lmxxbDaO ==  null) return null;
		itemsList.add(lmxxbDaO);
		return itemsList;		
	}
}