package com.doone.wskfmgr.business.config.service;

import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;

import com.doone.data.DataTable;
import com.doone.fj1w.common.CommonMethod;
import com.doone.fj1w.common.PageQueryStyle;
import com.doone.fj1w.common.TableStyle;
import com.doone.util.FileLogger;
import com.doone.wskfmgr.business.netstore.StoreDAO;
import com.doone.wskfmgr.business.netstore.TypeDAO;

public class Service implements PageQueryStyle{

	public int getConditionCount(ServletRequest request, ServletResponse response, Map _map) throws ServletException {
		return 1;
	}

	public String getConditionResult(ServletRequest request, ServletResponse response, Map _map) throws ServletException {
		try {
			if(_map == null) {
				return TableStyle.noBodyTable();
			}
			
			String storeType = (String)_map.get("STORETYPE");
			StringBuffer _sb = new StringBuffer();
			_sb.append(TableStyle.TableHead());
			if(storeType == null || storeType.equals("")) {
				DataTable table = TypeDAO.getStoreType(request.getParameter("CITYCODE"));
				for (int i = 0; i < table.getRows().getCount(); i++) {
					// TODO:性能問題,待重構(gòu).
					_map.put("STORETYPE",table.getRow(i).getString("NETTYPEID"));
					int count = StoreDAO.getConditionResult(_map);
					if(count == 0) { continue; }
					_sb.append("<a href='javascript:' onclick='fnStateClick(this)'");
					_sb.append(" name='ACTION' value='");
					_sb.append(table.getRow(i).getString("NETTYPEID"));
					_sb.append("' style='color: white;'>");
					_sb.append(table.getRow(i).getString("NAME"));
					_sb.append("</a>(<font color='red'>");
					_sb.append(count);
					_sb.append("</font>) &nbsp;&nbsp;");
				}
			}else {
				int count = StoreDAO.getConditionResult(_map);
				if(count > 0) {
					_sb.append("<a href='javascript:' onclick='fnStateClick(this)'");
					_sb.append(" name='ACTION' value='");
					_sb.append(storeType);
					_sb.append("' style='color: white;'>");
					_sb.append(TypeDAO.getStoreTypeName(Long.valueOf(storeType).longValue()));
					_sb.append("</a>(<font color='red'>");
					_sb.append(count);
					_sb.append("</font>) &nbsp;&nbsp;");
				}
			}
			_sb.append(TableStyle.TableTail());
			return _sb.toString();
		} catch (Exception ex) {
			FileLogger.getLogger().warn(ex.getMessage(),ex);
		}
		return TableStyle.noBodyTable();
	}

	/*
	 * (non-Javadoc)
	 * @see com.doone.fj1w.common.PageQueryStyle#getContextResult(javax.servlet.ServletRequest, javax.servlet.ServletResponse, java.util.Map)
	 */
	public String getContextResult(ServletRequest request, ServletResponse response, Map _map)throws ServletException  {
		try {
			if(_map == null) {
				return TableStyle.noBodyTable();
			}
			
			_map.put( "STORETYPE", _map.get("ACTION") );
			int pageSize = Integer.parseInt((String) _map.get("pageSize"));
			int currentPage = Integer.parseInt((String) _map.get("currentPage"));
			int startrecord = currentPage * pageSize;
			DataTable dt = StoreDAO.getContextResult(_map, startrecord, pageSize);
			int row = dt.getRows().getCount();
			if(row == 0) {throw new RuntimeException("StoreService#getContextResult()沒有這類商店存在.");}
			StringBuffer _sb = new StringBuffer();
			_sb.append("<table>");
			for (int i = 0; i < row; i++) {
				long storeid = dt.getRow(i).getLong("storeid");
				String name = dt.getRow(i).getString("name");
				String credit = dt.getRow(i).getString("credit");
				String createtime = dt.getRow(i).getString("createtime");
				String state = dt.getRow(i).getString("state");
				String typeid = dt.getRow(i).getString("NETTYPEID");
				String lockcode = dt.getRow(i).getString("lockcode");
				String font = "black";
				if(state.equals("D")){//商店關(guān)閉為紅色。
					font = "red";
				}
				_sb.append("<tr key='");
				_sb.append(storeid);
				_sb.append("' type='");
				_sb.append(typeid);
				_sb.append("' style= color:'");
				_sb.append(font);
				_sb.append("' >");
				_sb.append("<td class=\"body_td\" align=\"center\" nowrap>");
				_sb.append(storeid);
				_sb.append("</td>");
				_sb.append("<td class=\"body_td\" align=\"center\" nowrap>");
				_sb.append("<a href=\"javascript:\" onclick='window.setTimeout(\"fn_dblClick();\",10);'>");
				_sb.append(name);
				_sb.append("</a></td>");
				_sb.append("<td class=\"body_td\" align=\"center\" nowrap>");
				_sb.append(createtime);
				_sb.append("</td>");
				_sb.append("<td class=\"body_td\" align=\"center\" nowrap>");
				_sb.append(credit);
				_sb.append("</td>");
				_sb.append("<td class=\"body_td\" align=\"center\" nowrap>");
				_sb.append(state);
				_sb.append("</td>");
				_sb.append("<td class=\"body_td\" align=\"center\" nowrap>");
				if(lockcode == null || lockcode.equals("")) {
					_sb.append("&nbsp;");
				}else {
					_sb.append(CommonMethod.getStaffCode(lockcode));
				}
				_sb.append("</td></tr>");
			}
			_sb.append("</table>");
			return _sb.toString();
		} catch (Exception ex) {
			FileLogger.getLogger().warn(ex.getMessage(),ex);
		}
		return TableStyle.noBodyTable();
	}
	
	/*
	 * (non-Javadoc)
	 * @see com.doone.fj1w.common.PageQueryStyle#getConditionPage(javax.servlet.ServletRequest, javax.servlet.ServletResponse, java.util.Map)
	 */
	public int getContextCount(ServletRequest request, ServletResponse response, Map _map)
	throws ServletException  {
		try {
			if (_map == null) { return 0; }
			
			_map.put("STORETYPE",_map.get("ACTION"));
			return StoreDAO.getConditionResult(_map);
		} catch (Exception ex) {
			FileLogger.getLogger().warn(ex.getMessage(), ex);
		}
		return 0;
	}

}