<!DOCTYPE html>

<html>

  <head>

    <meta charset = "utf-8" >

    <title>parse xlsx test</title>

    <style>

       #outline {border:5px #666600 outset;padding:10px;}
       div {margin: 20px;}
        
    </style>


<script  src="js/check.xlsx.full.js" > </script>
<script  src="js/jquery.min.js" > </script>
<script  src="js/xlsx.full.min.js" > </script>

   
    <script > // type="module" type="text/javascript"

       $(function(){

         $ ('#my1').on('change',  function(event){//"input:file"
            document.getElementById('message').innerHTML = "";
           for(var i=0;i<event.target.files.lenght;i++){
              $('#message').append(file.name+"<br>");
           }
           var files = event.target.files;
                      if (files.length == 0) return;
                      var f = files[0];
                      if (!/\.xlsx$/g.test(f.name)) {
                          alert('仅支持读取xlsx格式!');
                          document.getElementById('message').innerHTML += "is not Xlsx type1!";
                          return;
                      };            
                        readWorkbookFromLocalFile(f, function (workbook) {
                          if (SheetAmount(workbook) != true){
                            document.getElementById('message').innerHTML += SheetAmount(workbook);
                            return;
                          };
                          if (HaveSheets(workbook) != true){
                            document.getElementById('message').innerHTML += HaveSheets(workbook);
                            return;
                          };
                          if (HaveData3Para(workbook,"C","C16") != true){
                           document.getElementById('message').innerHTML += HaveData3Para(workbook,"C","C16");
                            return;
                          };
                          readWorkbook(workbook,"message","2022-06-07","张强","U1999","U1055P202,U1098P2022");
                         // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {                           
                         //     document.getElementById('Button1').disabled =false;
                              //alert("pass!")                             
                        //  }
                       alert(makeJSONstring(workbook));
                      });
         });//id=my1


         $('#my2').on('change',function(event){//"input:file"
          document.getElementById('message').innerHTML = "";

for(var i=0;i<event.target.files.lenght;i++){

   $('#message').append(file.name+"<br>");

}

var files = event.target.files;
           if (files.length == 0) return;
           var f = files[0];
         //  document.getElementById('TextBox3').innerHTML += f.name+'\n';
           //k下面/    /g  是正则表达式
           if (!/\.xlsx$/g.test(f.name)) {
               alert('仅支持读取xlsx格式!');
               document.getElementById('message').innerHTML += "is not Xlsx type1!";
               return;
           };
           // var arr=[1,2,3];
           // alert(arr.length)
          // str2="";
          //alert(number2alphabet(30000));
          // str2=null;
           
           readWorkbookFromLocalFile(f, function (workbook) {

               if (HaveSingleSheetName(workbook,"SR") != true){
                 document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"SR");
                 return;
               };

               if (HaveData3Para(workbook,"SR","T1") != true){
                document.getElementById('message').innerHTML +=HaveData3Para(workbook,"SR","T1") ;
                 return;
               };

               checkIncomeFile(workbook,"message","202204","汤孝俊","U1066");
              // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {
                 
              //     document.getElementById('Button1').disabled =false;
                   //alert("pass!")
                  
             //  }

             alert(makeIncomeJSONstring(workbook));

           });


         });//id=my2





         $ ('#my3').on('change',  function(event){//"input:file"
            document.getElementById('message').innerHTML = "";
           for(var i=0;i<event.target.files.lenght;i++){
              $('#message').append(file.name+"<br>");
           }
           var files = event.target.files;
                      if (files.length == 0) return;
                      var f = files[0];
                      if (!/\.xlsx$/g.test(f.name)) {
                          alert('仅支持读取xlsx格式!');
                          document.getElementById('message').innerHTML += "is not Xlsx type1!";
                          return;
                      };            
                        readWorkbookFromLocalFile(f, function (workbook) {
                             if (HaveSingleSheetName(workbook,"GRZY") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"GRZY");
                               return;
                             };
                             if (HaveSingleSheetName(workbook,"JJZY") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"JJZY");
                               return;
                             };
                             if (HaveSingleSheetName(workbook,"C") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"C");
                               return;
                             };

                          if (HaveData3Para(workbook,"C","C4") != true){
                            document.getElementById('message').innerHTML += HaveData3Para(workbook,"C","C4");
                            return;
                          };
                          //checkBalanceFile(workbook,logID,strStartDate,strEndDate,userID)
                          checkBalanceFile(workbook,"message","2022-04-07","2022-04-07","汤孝俊");
                         // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {                           
                         //     document.getElementById('Button1').disabled =false;
                              //alert("pass!")                             
                        //  }
                       alert(makeBalanceJSONstring(workbook));
                      });
         });//id=my3




         $ ('#my4').on('change',  function(event){//"input:file"
           document.getElementById('message').innerHTML = "";
           for(var i=0;i<event.target.files.lenght;i++){
              $('#message').append(file.name+"<br>");
           }
           var files = event.target.files;
                      if (files.length == 0) return;
                      var f = files[0];
                      if (!/\.xlsx$/g.test(f.name)) {
                          alert('仅支持读取xlsx格式!');
                          document.getElementById('message').innerHTML += "is not Xlsx type1!";
                          return;
                      };            
                        readWorkbookFromLocalFile(f, function (workbook) {
                             if (HaveSingleSheetName(workbook,"KP") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"KP");
                               return;
                             };

                          if (HaveData3Para(workbook,"KP","W1") != true){
                            document.getElementById('message').innerHTML += HaveData3Para(workbook,"KP","W1")
                            return;
                          };
                          //checkBalanceFile(workbook,logID,strStartDate,strEndDate,userID)
                          checkInvoiceFile(workbook,"message","汤孝俊");
                         // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {                           
                         //     document.getElementById('Button1').disabled =false;
                              //alert("pass!")                             
                        //  }
                       alert(makeInvoiceJSONstring(workbook));
                      });
         });//id=my4

         $ ('#my5').on('change',  function(event){//"input:file"
            document.getElementById('message').innerHTML = "";
           for(var i=0;i<event.target.files.lenght;i++){
              $('#message').append(file.name+"<br>");
           }
           var files = event.target.files;
                      if (files.length == 0) return;
                      var f = files[0];
                      if (!/\.xlsx$/g.test(f.name)) {
                          alert('仅支持读取xlsx格式!');
                          document.getElementById('message').innerHTML += "is not Xlsx type1!";
                          return;
                      };            
                        readWorkbookFromLocalFile(f, function (workbook) {
                             if (HaveSingleSheetName(workbook,"KPCF") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"KPCF");
                               return;
                             };

                          if (HaveData3Para(workbook,"KPCF","H1") != true){
                            document.getElementById('message').innerHTML += HaveData3Para(workbook,"KPCF","H1")
                            return;
                          };
                          //checkBalanceFile(workbook,logID,strStartDate,strEndDate,userID)
                          checkInvoiceSplitFile(workbook,"message","汤孝俊");
                         // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {                           
                         //     document.getElementById('Button1').disabled =false;
                              //alert("pass!")                             
                        //  }
                       alert(makeInvoiceSplitJSONstring(workbook));
                      });
         });//id=my5



         $ ('#my6').on('change',  function(event){//"input:file"
           document.getElementById('message').innerHTML = "";
           for(var i=0;i<event.target.files.lenght;i++){
              $('#message').append(file.name+"<br>");
           }
           var files = event.target.files;
                      if (files.length == 0) return;
                      var f = files[0];
                      if (!/\.xlsx$/g.test(f.name)) {
                          alert('仅支持读取xlsx格式!');
                          document.getElementById('message').innerHTML += "is not Xlsx type1!";
                          return;
                      };            
                        readWorkbookFromLocalFile(f, function (workbook) {
                             if (HaveSingleSheetName(workbook,"CGZ") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"CGZ");
                               return;
                             };

                             if (HaveSingleSheetName(workbook,"CQT") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"CQT");
                               return;
                             };

                             if (HaveSingleSheetName(workbook,"CJT") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"CJT");
                               return;
                             };

                             if (HaveSingleSheetName(workbook,"C") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"C");
                               return;
                             };

                          if (HaveData3Para(workbook,"C","C5") != true){
                            document.getElementById('message').innerHTML += HaveData3Para(workbook,"C","C5")
                            return;
                          };
                          //checkBalanceFile(workbook,logID,strStartDate,strEndDate,userID)
                          checkSalaryFile(workbook,"message","202205","林玲");
                         // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {                           
                         //     document.getElementById('Button1').disabled =false;
                              //alert("pass!")                             
                        //  }
                       //alert(makeSalaryJSONstring(workbook));
                       console.log(makeSalaryJSONstring(workbook));
                      });
         });//id=my6



         $ ('#my7').on('change',  function(event){//"input:file"
           document.getElementById('message').innerHTML = "";
           for(var i=0;i<event.target.files.lenght;i++){
              $('#message').append(file.name+"<br>");
           }
           var files = event.target.files;
                      if (files.length == 0) return;
                      var f = files[0];
                      if (!/\.xlsx$/g.test(f.name)) {
                          alert('仅支持读取xlsx格式!');
                          document.getElementById('message').innerHTML += "is not Xlsx type1!";
                          return;
                      };            
                        readWorkbookFromLocalFile(f, function (workbook) {
                             if (HaveSingleSheetName(workbook,"DK") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"DK");
                               return;
                             };

                          if (HaveData3Para(workbook,"DK","I1") != true){
                            document.getElementById('message').innerHTML += HaveData3Para(workbook,"DK","I1")
                            return;
                          };
                          //checkBalanceFile(workbook,logID,strStartDate,strEndDate,userID)
                          checkCashInFile(workbook,"message","2022-03-01","2022-04-10","汤孝俊");
                         // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {                           
                         //     document.getElementById('Button1').disabled =false;
                              //alert("pass!")                             
                        //  }
                       alert(makeCashInJSONstring(workbook));
                      });
         });//id=my7


         $ ('#my8').on('change',  function(event){//"input:file"
           document.getElementById('message').innerHTML = "";
           for(var i=0;i<event.target.files.lenght;i++){
              $('#message').append(file.name+"<br>");
           }
           var files = event.target.files;
                      if (files.length == 0) return;
                      var f = files[0];
                      if (!/\.xlsx$/g.test(f.name)) {
                          alert('仅支持读取xlsx格式!');
                          document.getElementById('message').innerHTML += "is not Xlsx type1!";
                          return;
                      };            
                        readWorkbookFromLocalFile(f, function (workbook) {
                             if (HaveSingleSheetName(workbook,"FK") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"FK");
                               return;
                             };

                          if (HaveData3Para(workbook,"FK","H1") != true){
                            document.getElementById('message').innerHTML += HaveData3Para(workbook,"FK","H1")
                            return;
                          };
                          //checkBalanceFile(workbook,logID,strStartDate,strEndDate,userID)
                          checkCashOutFile(workbook,"message","2022-04-01","2022-04-31","汤孝俊");
                         // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {                           
                         //     document.getElementById('Button1').disabled =false;
                              //alert("pass!")                             
                        //  }
                       alert(makeCashOutJSONstring(workbook));
                      });
         });//id=my8


         $ ('#my9').on('change',  function(event){//"input:file"
           document.getElementById('message').innerHTML = "";
           for(var i=0;i<event.target.files.lenght;i++){
              $('#message').append(file.name+"<br>");
           }
           var files = event.target.files;
                      if (files.length == 0) return;
                      var f = files[0];
                      if (!/\.xlsx$/g.test(f.name)) {
                          alert('仅支持读取xlsx格式!');
                          document.getElementById('message').innerHTML += "is not Xlsx type1!";
                          return;
                      };            
                        readWorkbookFromLocalFile(f, function (workbook) {
                             if (HaveSingleSheetName(workbook,"B14C") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"B14C");
                               return;
                             };

                             if (HaveSingleSheetName(workbook,"C") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"C");
                               return;
                             };

                          if (HaveData3Para(workbook,"C","C2") != true){
                            document.getElementById('message').innerHTML += HaveData3Para(workbook,"C","C2")
                            return;
                          };
                          //checkBalanceFile(workbook,logID,strStartDate,strEndDate,userID)
                          checkB14CFile(workbook,"message","汤孝俊");
                         // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {                           
                         //     document.getElementById('Button1').disabled =false;
                              //alert("pass!")                             
                        //  }
                        console.log(makeB14CJSONstring(workbook));
                       alert(makeB14CJSONstring(workbook));
                      });
         });//id=my9



         $ ('#my10').on('change',  function(event){//"input:file"
           document.getElementById('message').innerHTML = "";
           for(var i=0;i<event.target.files.lenght;i++){
              $('#message').append(file.name+"<br>");
           }
           var files = event.target.files;
                      if (files.length == 0) return;
                      var f = files[0];
                      if (!/\.xlsx$/g.test(f.name)) {
                          alert('仅支持读取xlsx格式!');
                          document.getElementById('message').innerHTML += "is not Xlsx type1!";
                          return;
                      };            
                        readWorkbookFromLocalFile(f, function (workbook) {
                             if (HaveSingleSheetName(workbook,"B15C") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"B15C");
                               return;
                             };

                            
                             if (HaveSingleSheetName(workbook,"C") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"C");
                               return;
                             };

                          if (HaveData3Para(workbook,"C","C2") != true){
                            document.getElementById('message').innerHTML += HaveData3Para(workbook,"C","C2")
                            return;
                          };
                          //checkBalanceFile(workbook,logID,strStartDate,strEndDate,userID)
                          checkB15CFile(workbook,"message","汤孝俊");
                         // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {                           
                         //     document.getElementById('Button1').disabled =false;
                              //alert("pass!")                             
                        //  }
                       alert(makeB15CJSONstring(workbook));
                      });
         });//id=my10


         $ ('#my11').on('change',  function(event){//"input:file"
           document.getElementById('message').innerHTML = "";
           for(var i=0;i<event.target.files.lenght;i++){
              $('#message').append(file.name+"<br>");
           }
           var files = event.target.files;
                      if (files.length == 0) return;
                      var f = files[0];
                      if (!/\.xlsx$/g.test(f.name)) {
                          alert('仅支持读取xlsx格式!');
                          document.getElementById('message').innerHTML += "is not Xlsx type1!";
                          return;
                      };            
                        readWorkbookFromLocalFile(f, function (workbook) {
                             if (HaveSingleSheetName(workbook,"B16") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"B16");
                               return;
                             };

                             if (HaveSingleSheetName(workbook,"B17") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"B17");
                               return;
                             };

                             if (HaveSingleSheetName(workbook,"B18") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"B18");
                               return;
                             };

                             if (HaveSingleSheetName(workbook,"B19") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"B19");
                               return;
                             };

                             if (HaveSingleSheetName(workbook,"C") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"C");
                               return;
                             };

                          if (HaveData3Para(workbook,"C","C6") != true){
                            document.getElementById('message').innerHTML += HaveData3Para(workbook,"C","C6")
                            return;
                          };
                          //checkBalanceFile(workbook,logID,strStartDate,strEndDate,userID)
                          checkB16toB19File(workbook,"message","汤孝俊");
                         // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {                           
                         //     document.getElementById('Button1').disabled =false;
                              //alert("pass!")                             
                        //  }
                        console.log(makeB16toB19JSONstring(workbook));
                       alert(makeB16toB19JSONstring(workbook));
                      });
         });//id=my11


       })

    </script>

  </head>

  <body>

     <div id="outline">
        <div>
           <a>选择 日报 文件</a>
           <input id="my1" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/> 
        </div>
 
        <div>
          <a>选择 收入 文件</a>
           <input id="my2" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/> 
        </div>
   
         <div>
          <a>选择 支援 文件</a>
             <input id="my3" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/>            
         </div>     
    
    
         <div >
             <a>选择 开票 文件</a>
             <input id="my4" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/>             
         </div> 
    
         <div >
          <a>选择 开票拆分 文件</a>
             <input id="my5" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/>            
         </div> 
    
         <div >
          <a>选择 工资 文件</a>
             <input id="my6" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/>             
         </div> 

         <div >
          <a>选择 到款 文件</a>
             <input id="my7" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/>             
         </div> 

         <div >
          <a>选择 付款 文件</a>
             <input id="my8" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/>             
         </div> 

         <div >
          <a>选择 B14C 文件</a>
             <input id="my9" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/>             
         </div> 

         <div >
          <a>选择 B15C 文件</a>
             <input id="my10" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/>             
         </div> 

         <div >
          <a>选择 B16-B19 文件</a>
             <input id="my11" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/>             
         </div> 

           <div id="message"></div>
     </div>



  </body>

</html>