销售数据管理脚本解析-优快云博客

<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=Shift_JIS">
<title>ビジネスプロセスマネージャー</title>
<style type="text/css">
  .DataRowsSample {
        background-color: #FFFFFF;
       }
</style>
<script type=text/javascript>
function revDetail(){
              this.check = '';
        this.year = '';
           this.month = '';
           this.revenue = '';
           this.stocking = '';
           this.gainingsPrice = '';
     }

function changePageData(flagId,tableId){
   var arrayOfpageData =new Array();
   var yearArray =document.getElementsByName("sales_year");
   var monthArray =document.getElementsByName("sales_month");
      for(var i=0;i<yearArray.length;i++)
       {
           if(flagId == i){ continue; }
               var pageObj = new revDetail();
            var cheboxValue = eval("document.myform.checkbox_"+i);
         if(cheboxValue.checked){
           pageObj.check = cheboxValue.value;
         }else{
             pageObj.check ='0';
         }
         pageObj.year = yearArray[i].value;
         pageObj.month = monthArray[i].value;
      var revenueObj = eval("document.myform.myform_revenue_price_"+i+"_id");
      pageObj.revenue = revenueObj.value;
       var stockingObj = eval("document.myform.myform_stocking_price_"+i+"_id");
      pageObj.stocking = stockingObj.value;
          var gainingsObj = document.getElementById("gainings_"+i);
          pageObj.gainingsPrice = gainingsObj.innerText;
            arrayOfpageData[i] = pageObj;
    }
         sortData(arrayOfpageData);
         if(flagId !=-1){
         delChildRow(tableId);
   }else{
         addRevDetailOptionChildItem(tableId,arrayOfpageData);
     }
       var yearArray =document.getElementsByName("sales_year");
    for(var i=0;i<yearArray.length;i++){
   /*      if(flagId==-1 && yearArray.length-1 ==i){
          var lastDataIndex = arrayOfpageData.length-1;
        var newPage = arrayOfpageData[lastDataIndex];
        if(newPage.month == 12){
             newPage.year = newPage.year +1;
         newPage.month =1;
        }
         setValueToWidget(i,newPage);
       }
       else
       {
          var pageObject = arrayOfpageData[i];
        setValueToWidget(i,pageObject);
          }
        */
      var pageObject = arrayOfpageData[i];
   setValueToWidget(i,pageObject);
    }
}

function compare(p1,p2) {
     var returnValue = p1.year - p2.year;
   if(returnValue == 0) {
    returnValue = p1.month - p2.month;
   }
   return returnValue;
}

function sortData(arrayOfpageData){
  arrayOfpageData.sort(compare);
}

function delChildRow(tableId){
    var src= event.srcElement;
    while(src!=null)
    {
     //alert(tableId.rows.length-1);
       if(src.nodeName=="TR"){
        eval(tableId).deleteRow(tableId.rows.length-1);
        return;
    }
    src=src.parentElement;
    }
}

function setValueToWidget(i,pageObject){
    var cheboxValue = eval("document.myform.checkbox_"+i);
    cheboxValue.value = pageObject.check;
    var yearArray =document.getElementsByName("sales_year");
    var monthArray =document.getElementsByName("sales_month");
  for(var k=0;k<yearArray[i].options.length;k++){
       if(yearArray[i].options(k).value == pageObject.year){
         yearArray[i].options(k).selected =true;
       }else
       {
         yearArray[i].options(k).selected =false;
       }
  }
  for(var o=0;o<monthArray[i].options.length;o++){
       if(monthArray[i].options(o).value == pageObject.month){
         monthArray[i].options(o).selected =true;
       }else
       {
         monthArray[i].options(o).selected =false;
       }
  }
  var revenueObj = eval("document.myform.myform_revenue_price_"+i+"_id");
  revenueObj.value = pageObject.revenue;
  var stockingObj = eval("document.myform.myform_stocking_price_"+i+"_id");
  stockingObj.value = pageObject.stocking;
  var gainingsObj = document.getElementById("gainings_"+i);
gainingsObj.innerText = pageObject.gainingsPrice;
var delObj = document.getElementById("del_"+i);
   }

   function addRevDetailOptionChildItem(table1,arrayOfpageData){
      var row = table1.insertRow(table1.rows.length);
    var index = row.rowIndex;
  row.className="DataRowsSample";
  var lastDataIndex = arrayOfpageData.length-1;
  var newPage = arrayOfpageData[lastDataIndex];
  if(newPage.month == 12){
   newPage.year = newPage.year +1;
   newPage.month =1;
  }
     var col=document.createElement("TD");//検収
  col.align="center";
    col.width ="2%";
  col.innerHTML='<font size="2"><input type=checkbox id='+ index +' name=checkbox_' + index +' value='+newPage.check+' onclick=""></font>';
  row.appendChild(col);
     var col=document.createElement("TD");//売上年
        var fontObj = document.createElement("font");
     var mySelect = document.createElement("select");
     var str = "";
     for (var i = 2004; i <= 2010; i++) {
        var opt = document.createElement("option");
        opt.value=i+"";
        opt.text=i+"";
        mySelect.add(opt);
     }
     for (var i = 0; i <mySelect.options.length; i++) {
        var opt = mySelect.options(i);
        if(parseInt(opt.value)==newPage.year){
          opt.selected=true;
        }
    }
    var monthObj = document.createElement("select");//売上月
    for(var i = 1; i <= 12; i++) {
        var opt = new Option(i,i);
        opt.value=i+"";
        opt.text=i+"";
        monthObj.add(opt);
    }
    for(var i=0;i<monthObj.options.length;i++){
       var opt = monthObj.options(i);
       if(parseInt(opt.value)==newPage.month){
          opt.selected = true;
       }
    }
    var spanYearObj = document.createElement("span");
    var spanMonthObj = document.createElement("span");
           fontObj.size ="2";
           mySelect.style.cssText ="width:58px";
           mySelect.name = "sales_year";
           mySelect.id = index;
           mySelect.onmouseover="";
           mySelect.onchange="";
           mySelect.onkeydown="";

           monthObj.style.cssText ="width:43px";
           monthObj.name = "sales_month";
           monthObj.id = index;
           monthObj.onmouseover="";
           monthObj.onchange="";
           monthObj.onkeydown="";

           spanYearObj.innerHTML="年";
           spanMonthObj.innerHTML="月";
           col.appendChild(fontObj);

     fontObj.appendChild(mySelect);

     fontObj.appendChild(spanYearObj);
      fontObj.appendChild(monthObj);
      fontObj.appendChild(spanMonthObj);
        col.align="center";
        col.width ="20%";
        if(1==2){ return; }
        row.appendChild(col);

      var col=document.createElement("TD");//売上金額
      col.innerHTML='<input type="hidden" name="revenue_price_"'+index+' value="'+newPage.revenue+'"> ';
      col.innerHTML='<font size="2"><input type="text" id="myform_revenue_price_"'+index+'_id" maxLength="19" size="20" value="'+newPage.revenue+'" onkeypress=" " onkeyup=" " onblur="" style="text-align:right;ime-mode:disabled" > 円</font>';
   col.align='right';
   row.appendChild(col);
      var col=document.createElement("TD");//仕入CMS
      col.innerHTML='<input type="hidden" name="stocking_price_"'+index+' value="'+newPage.stocking+'"> ';
      col.innerHTML='<font size="2"><input type="text" id="myform_stocking_price_"'+index+'_id" maxLength="19" size="20" value="'+newPage.stocking+'" onkeypress=" " onkeyup=" " onblur="" style="text-align:right;ime-mode:disabled" > 円</font>';
   col.align='right';
   row.appendChild(col);
      var col=document.createElement("TD");//粗利
   col.innerHTML='<font size="2"><span ID=gainings_'+newPage.gainingsPrice+'></span>円</font>';
   col.align='right';
   row.appendChild(col);
      var col=document.createElement("TD");
      col.innerHTML='<a href="#" id="del_" '+index+'><font size=2>削除</font></a>';
   col.align='center';
   col.width='5%';
   row.appendChild(col);
   // alert("3");
}
function reloadSoft(){
   var arrayOfpageData =new Array();
   var yearArray =document.getElementsByName("sales_year");
   var monthArray =document.getElementsByName("sales_month");
      for(var i=0;i<yearArray.length;i++){
          var pageObj = new revDetail();
       var cheboxValue = eval("document.myform.checkbox_"+i);
       if(cheboxValue.checked){
       pageObj.check = cheboxValue.value;
       }else{
       pageObj.check ='0';
       }
       pageObj.year = yearArray[i].value;
       pageObj.month = monthArray[i].value;
       var revenueObj = eval("document.myform.myform_revenue_price_"+i+"_id");
       pageObj.revenue = revenueObj.value;
       var stockingObj = eval("document.myform.myform_stocking_price_"+i+"_id");
       pageObj.stocking = stockingObj.value;
        var gainingsObj = document.getElementById("gainings_"+i);
        pageObj.gainingsPrice = gainingsObj.innerText;
          arrayOfpageData[i] = pageObj;
    }
     sortData(arrayOfpageData);
   }
</script>
</head>

一.
追加或删除数据的页面上处理
changePageData(要删除记录的ID,tableId)
1.将画面上除了要删除的记录装入到一个arrayOfpageData数组中
二.
壳上金额升序的方式排序
sortData()
三.
删除画面上一行控件
delChildRow(tableId)
四.
添加一行控件到画面
addRevDetailOptionChildItem(tableId)
五.
生成一条新数据
六.
给画面上控件赋值
setValueToWidget(dataArray)

demo