@RequestMapping("/organization/listorganization.do")
public ModelAndView listAllOrgnization(HttpServletRequest request,HttpServletResponse response){
String st_time = request.getParameter("tj_st");
String ed_time = request.getParameter("tj_ed");
PageArgument pageArgment = getPageInfo(request);
RunTimeUser rtUser = RunTimeUser.getRunTimeUser(request);
StringBuffer sb = new StringBuffer();
List<Object> o = new ArrayList<Object> ();
if(st_time!=null&&st_time.length()>0){
sb.append(" and jgtjsj>=str_to_date(?,'%Y-%m-%d %H:%i:%s')");
o.add(st_time);
}
if(ed_time!=null&&ed_time.length()>0){
sb.append(" and jgtjsj<=str_to_date(?,'%Y-%m-%d %H:%i:%s')");
o.add(ed_time);
}
if(rtUser!=null&&rtUser.getUsertype()!=User.USER_TYPE_NORMAL&&
rtUser.getUsertype()!=User.USER_TYPE_MERCHANT&&rtUser.getUsertype()!=User.USER_TYPE_TGSTATION){
String hql = "";
long _type = rtUser.getUsertype();
if(_type==User.USER_TYPE_TGCENTER||_type==User.USER_TYPE_YYCENTER){
Organization _or = (Organization)userOrganizationMerchantService.getOrganizationOrMerchantByUser(rtUser);
if(_or!=null){
sb.append(" and jgssjg="+_or.getID());
}