摘要：代碼如下獲得同一區域下的列獲得每個存儲數量計算每個區域的數量地區域機房樓層區域地區域機房樓層區域合并標識如果為就不會顯示得到每個對象的不重復的數量將轉換為數組

功能說明

  主要是添加交換機和路由器并生成相應的端口，用于與服務器或其他網絡設備相連

類名和表名

  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