开发文档

摘要：代码如下获得同一区域下的列获得每个存储数量计算每个区域的数量地区域机房楼层区域地区域机房楼层区域合并标识如果为就不会显示得到每个对象的不重复的数量将转换为数组

功能说明

  主要是添加交换机和路由器并生成相应的端口，用于与服务器或其他网络设备相连

类名和表名

  Board——zq_ho_board(交换机),Cabnetport——zq_ho_cabnetport(端口关联),Ports——zq_ho_port(端口)      

主页面路径

 /exchange/board/list

功能难点

1.端口的生成   

     var arrList = new Array();
        function producePort(){
            var prefix=$("input[name="prefix"]").val()//前缀
            var sult= $("select[name="sult"]").val();//端口类型
            var start= $("input[name="start"]").val();//端口起始
            var ends= $("input[name="ends"]").val();//端口结束
            var speed= $("input[name="speed"]").val();//端口速率
            var career= $("input[name="career"]").val();//限制速率
           if(prefix=="" || sult =="" || start=="" || speed=="" ||career=="" || ends ==""){
             top.layer.alert("请填入参数！", {icon: 0, title:"警告"});
             return false;
            }
           var allcamres=prefix+"-"+sult+"-"+start+"-"+ends+"-"+speed+"-"+career;
           arrList.push(allcamres);//将参数放进数组
           var html ="";
           for(var i=0;i<=(ends-start);i++){
                  html+=""+prefix+(Number(start)+i)+"${fns:getDictLabel( "1", "line_type", "")}";
               if(sult==0){
                  html+=" ${fns:getDictLabel("0", "port_type", "")}"; 
                 }
               if(sult==1){
                  html+=" ${fns:getDictLabel("1", "port_type", "")}"; 
                 }
                  html+=""+speed+" "+career+" ";
             }
           $("#prottabal tbody").append(html);

     将给订的端口参数  arrList 取出并在保存交换机时保存端口信息。

2.交换机的统计
    sql语句部分

    SELECT      a.id as id,
             a.bo_arae as arae,
             substring_index(a.bo_machineroom,"/",1 ) as machineroom,
             substring_index(a.bo_machineroom,"/",2  )as storey,
             a.bo_machineroom as cabinetid,                                
             b.machnum as goodnum, 
             c.lounum as louchen,
             d.machnum as jifang,
             e.arenum as arenum,
             t.name AS modelnumber,                  
             f.modenum as num
  FROM zq_ho_board a 
  LEFT JOIN  zq_mhub_module_type t  on t.id=a.bo_modelnumber
  
  LEFT JOIN (SELECT b.bo_arae, b.bo_machineroom,COUNT(1) as machnum FROM zq_ho_board b  where  b.bo_camtype=#{camtype} GROUP BY b.bo_arae, b.bo_machineroom ) as b on  (b.bo_arae =a.bo_arae and  b.bo_machineroom =a.bo_machineroom) 
  
  LEFT JOIN (SELECT b.bo_arae, substring_index(b.bo_machineroom,"/",2 ) as louchen,COUNT(1) as lounum FROM zq_ho_board b  where  b.bo_camtype=#{camtype} GROUP BY b.bo_arae,louchen ) as c on (c.bo_arae =a.bo_arae  and  c.louchen =substring_index(a.bo_machineroom,"/",2 ))
  LEFT JOIN (SELECT b.bo_arae, substring_index(b.bo_machineroom,"/",1 ) as machineroom,COUNT(1) as machnum FROM zq_ho_board b where  b.bo_camtype=#{camtype}   GROUP BY b.bo_arae, machineroom ) as d on  (d.bo_arae =a.bo_arae  and  d.machineroom = substring_index(a.bo_machineroom,"/",1 )  )
  LEFT JOIN (SELECT b.bo_arae,COUNT(1) as arenum FROM zq_ho_board b  where  b.bo_camtype=#{camtype}   GROUP BY b.bo_arae ) as e on  e.bo_arae =a.bo_arae
  LEFT JOIN (SELECT b.bo_arae, b.bo_machineroom,b.bo_modelnumber,COUNT(1) as modenum FROM zq_ho_board b  where  b.bo_camtype=#{camtype} GROUP BY b.bo_arae,  b.bo_machineroom , b.bo_modelnumber ) as f on   ( f.bo_arae =a.bo_arae and  f.bo_modelnumber =a.bo_modelnumber and  f.bo_machineroom =a.bo_machineroom)
      a.del_flag = #{DEL_FLAG_NORMAL} AND a.bo_camtype= #{camtype}
         
                AND a.bo_arae LIKE 
                    "%"||#{arae}||"%"
                    "%"+#{arae}+"%"
                    concat("%",#{arae},"%")
         
         
                AND a.bo_machineroom LIKE 
                    "%"||#{machineroom}||"%"
                    "%"+#{machineroom}+"%"
                    concat("%",#{machineroom},"%")
         
      
  
        
     
  GROUP BY  a.bo_arae, a.bo_machineroom ,substring_index(a.bo_machineroom,"/",2 ),substring_index(a.bo_machineroom,"/",1 ),a.bo_modelnumber
    

统计的合并单元格的设计思路

  计算出同一个区域下得数量，再分别计算出与该条记录相同的  机房，楼层，区域的各个数量以确定合并单元格的数量，并用数组中的唯一位置将数据存入。  
  代码如下
  
  public List findgoods(Board board) {
    // board.setPage(page);
    // page.setList(dao.findgoods(board));
    List lists = dao.findgoods(board);
    int i = 0;
    List tenpt = null;
    Board h = null;
    for (Board s : lists) {
        List list = new ArrayList<>();
        for (Board t : lists) {
            // 获得同一区域下的列
            if (t.getArae().equals(s.getArae())) {
                list.add(t);// 获得每个list
            }
        }

        List