import hengyi.oa.mobile.exception.ServiceException;
import java.io.UnsupportedEncodingException;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;
import javax.servlet.http.HttpServletRequest;
import org.apache.commons.lang.StringUtils;
 
 
/**
 * 查詢條件封裝類
 * @author  Xue.YQ
 * @created 2018年11月11日
 */
public class TableTagBean
{
 public static final int DEFAULT_PAGE_SIZE = 20;
 
 private static final String DELIMITER = "\n";
 
 private int m_page;
 
 private int m_pageSize = DEFAULT_PAGE_SIZE;
 
 private int m_total;
 
 private String m_orderBy;
 
 private boolean m_asc;
 
 private StringMap m_condition = new StringMap();
 
 private List m_list;
 
 private boolean m_builded = false;
 
 private String m_conditionParam = null;
 
 private int m_pageCount;
 
 private boolean m_canPrev;
 
 private boolean m_canNext;
 
 public TableTagBean() {}
 
 public boolean getAsc() {
  return m_asc;
 }
 
 public void setAsc(boolean asc) {
  ensureNotBuilded();
  m_asc = asc;
 }
 
 public StringMap getCondition() {
  return m_condition;
 }
 
 public void setCondition(StringMap condition) {
  ensureNotBuilded();
  m_condition = condition;
 }
 
 public String getOrderBy() {
  return m_orderBy;
 }
 
 public void setOrderBy(String orderBy) {
  ensureNotBuilded();
  m_orderBy = orderBy;
 }
 
 public int getPage() {
  return m_page;
 }
 
 public void setPage(int page) {
  ensureNotBuilded();
  m_page = page;
 }
 
 public int getPageSize() {
  return m_pageSize;
 }
 
 public void setPageSize(int pageSize) {
  ensureNotBuilded();
  m_pageSize = pageSize;
 }
 
 public int getTotal() {
  return m_total;
 }
 
 public void setTotal(int total) {
  ensureNotBuilded();
  m_total = total;
 }
 
 public List getList() {
  return m_list;
 }
 
 public void setList(List list) {
  ensureNotBuilded();
  m_list = list;
 }
 
 public void ensureNotBuilded() {
  if (m_builded) {
   throw new IllegalStateException(
     "Can't set attribute to TableTagBean after build() is called.");
  }
 }
 
 public boolean getCanNext() {
  return m_canNext;
 }
 
 public boolean getCanPrev() {
  return m_canPrev;
 }
 
 public String getConditionParam() {
  return m_conditionParam;
 }
 
 public int getPageCount() {
  return m_pageCount;
 }
 
 public void build() throws UnsupportedEncodingException {
 
  if (m_condition.size() > 0) {
   m_conditionParam = CryptoUtil.base64url_encode(m_condition
     .toString(DELIMITER).getBytes("GBK"));
  }
 
  if (m_total % m_pageSize != 0) {
   m_pageCount = m_total / m_pageSize + 1;
  } else {
   m_pageCount = m_total / m_pageSize;
  }
 
  m_canPrev = m_page > 0;
  m_canNext = m_page < m_pageCount - 1;
 
  m_builded = true;
 }
 
 public static TableTagBean getFromRequest(HttpServletRequest req)
   throws UnsupportedEncodingException {
  TableTagBean r = new TableTagBean();
 
  String p = req.getParameter("p");
  if (StringUtils.isNotEmpty(p) ) {
   r.setPage(Integer.parseInt(p));
  }
  String o = req.getParameter("o");
  if (StringUtils.isNotEmpty(o)) {
   r.setOrderBy(o);
  }
  String a = req.getParameter("a");
  if (StringUtils.isNotEmpty(a)) {
   r.setAsc(a.equals("1"));
  }
  String c = req.getParameter("c");
  if (StringUtils.isNotEmpty(c)) {
   r.setCondition(decodeConditionParam(c));
  }
 
  return r;
 }
 
 private static StringMap decodeConditionParam(String c)
   throws UnsupportedEncodingException {
  String s = new String(CryptoUtil.base64url_decode(c), "GBK");
  return new StringMap(s, DELIMITER);
 }
 
 public String getQueryParameter() {
  StringBuffer sb=new StringBuffer();
  
  sb.append("p="+m_page);
  if(m_orderBy!=null) {
   sb.append("&o="+m_orderBy+"&a="+(m_asc?"1":"0"));
  }
  
  if(m_conditionParam!=null) {
   sb.append("&c="+m_conditionParam);
  }
  
  return sb.toString();
 }
 
 @Override
 public String toString() {
  StringBuffer sb = new StringBuffer();
 
  sb.append("[TableTagBean]\r\n");
  sb.append("m_page: " + m_page + "\r\n");
  sb.append("m_pageSize :" + m_pageSize + "\r\n");
  sb.append("m_total :" + m_total + "\r\n");
  sb.append("m_orderBy :" + m_orderBy + "\r\n");
  sb.append("m_asc :" + m_asc + "\r\n");
  sb.append("m_condition :" + m_condition + "\r\n");
  sb.append("m_list(size) :" + m_list.size() + "\r\n");
  sb.append("m_builded :" + m_builded + "\r\n");
  sb.append("m_conditionParam :" + m_conditionParam + "\r\n");
  sb.append("m_pageCount :" + m_pageCount + "\r\n");
  sb.append("m_canPrev :" + m_canPrev + "\r\n");
  sb.append("m_canNext :" + m_canNext + "\r\n");
 
  return sb.toString();
 }
 
 @SuppressWarnings({ "rawtypes", "unchecked" })
 public static TableTagBean getFromParameter(HttpServletRequest request)
  throws ServiceException
  {
  String start = request.getParameter("start");
  String limit = request.getParameter("limit");
  String asc = request.getParameter("dir");
  String orderBy = request.getParameter("sort");
  int page = (start != null) ? Integer.parseInt(start) : 0;
  int pageSize = (limit != null) ? Integer.parseInt(limit) : 30;
  boolean isAsc = "ASC".equals(asc);
 
  TableTagBean ttb = new TableTagBean();
  ttb.setPage(page);
  ttb.setPageSize(pageSize);
  ttb.setOrderBy(orderBy);
  ttb.setAsc(isAsc);
   
  
  Map<String, String[]> m = request.getParameterMap();
  String isEncodeURI = request.getParameter("isEncodeURI");
  if (m != null) {
   for (Entry entry : m.entrySet()) {
   String key = (String)entry.getKey();
   Object[] value = (Object[])entry.getValue();
   
//   if("Y".equals(isEncodeURI)){
//    String v= java.net.URLDecoder.decode(value[0].toString(), "UTF-8");
//    ttb.getCondition().put(key, (value[0] == null) ? null :v);
//   }else{
    ttb.getCondition().put(key, (value[0] == null) ? null : value[0].toString());
//   }
   }
  }
  return ttb;
  }
 
}

@RequestMapping("/listAgentAwaitRepor")
 public List<DepartmentOfficeDTO> listAgentAwaitRepor(HttpServletRequest request) throws ServiceException
 {
  TableTagBean ttb = TableTagBean.getFromParameter(request);
  return oldAgentAwaitReportSearchFacade.list(ttb);
 }

String titleName = ttb.getCondition().get("titleName");
 if(!GenericValidator.isBlankOrNull(titleName))
 {
  sql.append(" and biz.biz_title like :bizTitle ");
  sqlParams.put("bizTitle", "%"+titleName.trim()+"%");
 }