| | |
| | | import com.yc.utils.JOSNUtils; |
| | | import com.yc.utils.Page; |
| | | import org.apache.commons.lang3.StringUtils; |
| | | import org.aspectj.weaver.ast.Var; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | |
| | | throw new ApplicationException(e.getMessage()); |
| | | } |
| | | String[] strings = tbCols.split(","); |
| | | int index1=0; |
| | | int index1 = 0; |
| | | for (String s : strings) { |
| | | String[] str = s.split("#");// 分出每个统计的列 |
| | | newTbCols+=str[0].toLowerCase()+"=#"+index1+";"; |
| | | newTbCols += str[0].toLowerCase() + "=#" + index1 + ";"; |
| | | index1++; |
| | | } |
| | | page.setNewTbCols(newTbCols); |
| | | } |
| | | gridService.loadAllByFunc(page,env,false); |
| | | //取字段对齐,数字格式 |
| | | String sql1 = "select fieldid,cellAlign,displayformat FROM _sysStatisDetail where formID=" + formID + " AND statisID=" |
| | | + "'" + statisID + "'" + ""; |
| | | List<Map<String, Object>> list1 = this.jdbcTemplate.queryForList(sql1); |
| | | //处理成Map结构方便后面组装 |
| | | Map<String, Map<String, Object>> resultMap=new HashMap<>(); |
| | | if(list1!=null&&list1.size()>0){ |
| | | for(Map<String, Object> objectMap:list1){ |
| | | String id=GridUtils.prossRowSetDataType_String(objectMap,"fieldID").toLowerCase(); |
| | | int indexd= id.toLowerCase().lastIndexOf("as"); |
| | | if(indexd>0) { |
| | | id = id.substring(indexd + 2, id.length()).trim(); |
| | | } |
| | | // objectMap.remove("fieldID"); |
| | | gridService.loadAllByFunc(page, env, false); |
| | | //取字段对齐,数字格式,长度 |
| | | String sql1 = "select fieldid,cellAlign,cellAlign as appCellAlign,displayformat,displayWidth as gridlength FROM _sysStatisDetail where formID=" + formID + " AND statisID=" |
| | | + "'" + statisID + "'" + ""; |
| | | List<Map<String, Object>> list1 = this.jdbcTemplate.queryForList(sql1); |
| | | //处理成Map结构方便后面组装 |
| | | Map<String, Map<String, Object>> resultMap = new HashMap<>(); |
| | | if (list1 != null && list1.size() > 0) { |
| | | for (Map<String, Object> objectMap : list1) { |
| | | |
| | | String id = GridUtils.prossRowSetDataType_String(objectMap, "fieldID").toLowerCase(); |
| | | final String[] byAsOfEnd = id.split("\\s*\\b(?i)as\\b\\s*"); |
| | | if (byAsOfEnd.length > 1) { |
| | | id = byAsOfEnd[1]; |
| | | } |
| | | resultMap.put(id,objectMap); |
| | | } |
| | | } |
| | |
| | | break; |
| | | case 44://静态图标控件 |
| | | returnStr=getBigIcon44(sys,shuai); |
| | | break; |
| | | case 46: |
| | | returnStr=getColorFinder(sys,shuai); |
| | | break; |
| | | case 47: |
| | | returnStr=getProgressBar(sys,shuai); |
| | | break; |
| | | default: |
| | | returnStr = getText(sys, shuai);// 有些控件类型暂无用此替代 |
| | |
| | | "<img id=\""+id+"-img44\" src=\"" + getJspValue(id) + "\"></span>"; |
| | | return icon; |
| | | } |
| | | |
| | | /** |
| | | * 获取取色器 |
| | | * @param map |
| | | * @param shuai |
| | | * @return |
| | | * @throws Exception |
| | | */ |
| | | private String getColorFinder(Map<String, Object> map, boolean shuai) throws Exception { |
| | | PanelBean panelBean = (PanelBean) map.get(PANEL_INFO); |
| | | String id = panelBean.pHelper.id; |
| | | String color = " <div class=\"example square\"><input type=\"text\" id=\"" + id + "\" class=\"coloris46 " + getControls(map) + "\" value=\"" + getJspValue(id) + "\" "; |
| | | color += getReadOnly(map);// 这里可以提出来,还是提出来 |
| | | color += "/></div>"; |
| | | return color; |
| | | } |
| | | |
| | | /** |
| | | * 进度条 |
| | | * @param map |
| | | * @param shuai |
| | | * @return |
| | | * @throws Exception |
| | | */ |
| | | private String getProgressBar(Map<String, Object> map, boolean shuai) throws Exception { |
| | | PanelBean panelBean = (PanelBean) map.get(PANEL_INFO); |
| | | String id = panelBean.pHelper.id; |
| | | String data="data-id=\""+id+"\""; |
| | | String bar = "<div "+data+" class=\"progressBar47 " + getControls(map) + "\"></div>"; |
| | | bar += "<input type=\"hidden\" id=\"" + id + "\" value=\"" + getJspValue(id) + "\">"; |
| | | return bar; |
| | | } |
| | | |
| | | /** |
| | | * 获得权限控制 |
| | | * @param sys |