Cascade drop downs, get list items Using spervices; append retrieved items to drop down

<script src="*****/jquery-2.1.3.min%20(1).js" type="text/javascript"></script>
<script src="****/jquery.SPServices-2014.02.min.js" type="text/javascript"></script>
<script language="javascript" type="text/javascript">
//var dtotal=0;
var resultdiscovered=0;
var resultrepaired=0;

var result1=0;
var result2=0;
var result3=0;
var result4=0;
var result5=0;
var result6=0;
var result7=0;
var result8=0;
var result9=0;
var result10=0;
var result11=0;
var result12=0;
var result13=0;
var result14=0;
var result15=0;
var result16=0;
var result17=0;
var result18=0;
var result19=0;
var result20=0;
var result21=0;
var result22=0;
var resulta=0;
var resultb=0;
var resultc=0;
var resultd=0;
var resulte=0;
var resultf=0;
var resultg=0;
var resulth=0;
var resulti=0;
var resultj=0;
var resultk=0;
var resultl=0;
var resultm=0;
var resultn=0;
var resulto=0;
var resultp=0;
var resultq=0;
var resultr=0;
var results=0;
var resultt=0;
var result23=0;
var result24=0;
var result25=0;
var result26=0;
var result27=0;
var result28=0;
var result29=0;
var result30=0;
var result31=0;
var result32=0;
var result33=0;
var result34=0;
var result35=0;
var result36=0;
var result37=0;
var result38=0;
var result39=0;
var result40=0;
var result41=0;
var result42=0;
var result43=0;
var result44=0;

$(document).ready(function() {
//alert("entered");
    
         //---------------------get work order data------------to dropdown-----// 
         
$().SPServices({
            operation: "GetListItems",
            async: false,
            listName: "Aerial Maintenance Tasks",
            completefunc: function(xData, Status) {

                $(xData.responseXML).SPFilterNode("z:row").each(function() {
                //alert(xData.responseText);
                   
                      fieldTitle = $(this).attr("ows_Discovery_x0020_Work_x0020_Order");
                        //alert(fieldTitle);
                       fieldItem = "<option>" + fieldTitle + "</option>"
                      aftersplitpf=fieldItem.split(".")

                        $("select.wons").append(aftersplitpf[0]);
                    });
                }
            }); 
   
   $(function () {
    
    $("select[name='Discovery Work Order']").change(function () {
        var wons = $(this).find("option:selected").text();
        Clearvariables();

        //alert(wons);
  
        Getgridwonunrepaired(wons);
  Getwondiscovered(wons);  
  Getwonrepaired(wons);  
  
 
  });
  
   });
   //--------------------------summary lookup by querying both grid number & work order number------------------//         
        $().SPServices({
            operation: "GetListItems",
            async: false,
            listName: "Maintenance Grids",
            completefunc: function(xData, Status) {

                $(xData.responseXML).SPFilterNode("z:row").each(function() {
                //alert(xData.responseText);
                   
                      fieldTitle = $(this).attr("ows_Grid_x0020_Number");
                        //alert(listTitle);
                       fieldItem = "<option>" + fieldTitle + "</option>"
                       $("select.grid").append(fieldItem);
       
                   });
                }
            });
   
  
   
     $(function () {
    
        $("select[name='Grid']").change(function () {
        var gridnum = $(this).find("option:selected").text();
        //alert(gridnum);
            Clearvariables();
            sendgridto(gridnum);
     Getgrid(gridnum);
    Getgridwithrep(gridnum);
    Getgridwithdiscovery(gridnum);
    
     });
     
     $("select[name='Discovery Work Orders']").change(function () {
        var won = $(this).find("option:selected").text();
       // alert(gridnum);
       // alert(won);
            //Clearvariables();
            
     Getgridwondis(gridnum,won);
     Getgridwonrep(gridnum,won);
   GetgridwonUNREP(gridnum,won);
    
       });}); 
      
function sendgridto(gridnum)
       {
       //alert(gridnum);
        Clearvariables();
       $('#wd').empty();
       var query="<Query><Where><Eq><FieldRef Name='Grid' /><Value Type='Lookup'>"+gridnum+"</Value></Eq></Where></Query>"
         //alert(query);
         var fm = "<option>" + "select.." + "</option>"
                     
                        $("select.won").append(fm);

         
            $().SPServices({
            operation: "GetListItems",
            async: false,
            listName: "Aerial Maintenance Tasks",
            CAMLQuery: query,
            completefunc: function(xData, Status) {

                $(xData.responseXML).SPFilterNode("z:row").each(function() {
                //alert(xData.responseText);
                   
                      fieldTitle = $(this).attr("ows_Discovery_x0020_Work_x0020_Order");
                        //alert(listTitle);
                       fieldItem = "<option>" + fieldTitle + "</option>"
                       aftersplitpf=fieldItem.split(".")

                        $("select.won").append(aftersplitpf[0]);
                    })  }  })    }
                    
    $("#rese").click(function() 
    {
    //alert("reset called");
    Clearvariables();
$('#wd').find('option:first').attr('selected', 'selected');
    $('#gwd').find('option:first').attr('selected', 'selected');
     $('#gd').find('option:first').attr('selected', 'selected');
    });

               
 function Clearvariables()
 {
 //alert("entered");
 resultdiscovered=0;
 resultrepaired=0;
result1=0;
result2=0;
result3=0;
result4=0;
result5=0;
result6=0;
result7=0;
result8=0;
result9=0;
result10=0;
result11=0;
result12=0;
result13=0;
result14=0;
result15=0;
result16=0;
result17=0;
result18=0;
result19=0;
result20=0;
result21=0;
result22=0;
resulta=0;
resultb=0;
resultc=0;
resultd=0;
resulte=0;
resultf=0;
resultg=0;
resulth=0;
resulti=0;
resultj=0;
resultk=0;
resultl=0;
resultm=0;
resultn=0;
resulto=0;
resultp=0;
resultq=0;
resultr=0;
results=0;
resultt=0;
result23=0;
result24=0;
result25=0;
result26=0;
result27=0;
result28=0;
result29=0;
result30=0;
result31=0;
result32=0;
result33=0;
result34=0;
result35=0;
result36=0;
result37=0;
result38=0;
result39=0;
result40=0;
result41=0;
result42=0;
result43=0;
result44=0;
$("#tdrPoleFrames").html('0');
$("#tdrRemoveHardware").html('0');
$("#tdrPlaceUGSign").html('0');
$("#tdrFiberSurvey").html('0');
$("#tdrSetAnchor").html('0');
$("#tdrPlaceDownGuy").html('0');
$("#tdrPlaceDownGuy").html('0');
$("#tdrPlaceGuyGuard").html('0');
$("#tdrTightenSpan").html('0');
$("#tdrRelashSpan").html('0');
$("#tdrLashStorageLoop").html('0');
$("#tdrRehangCase").html('0');
$("#tdrCutSpliceStrand").html('0');
$("#tdrRiserGuard").html('0');
$("#tdrFoamRiser").html('0');
$("#tdrPlaceFiberJumper").html('0');
$("#tdrPoleReplace").html('0');
$("#tdrVaultReplace").html('0');
$("#tdrLidReplace").html('0');
$("#tdrTrimVegetation").html('0');
$("#tdrRetagLine").html('0');
$("#tdrPlaceUGSign").html('0');
$("#tdrFiberSurvey").html('0');

$("#tdTotalUnrepaired").html('0');
$("#tdURPoleFrames").html('0');
$("#tdURRemoveHardware").html('0');
$("#tdrURPlaceUGSign").html('0');
$("#tdURFiberSurvey").html('0');
$("#tdURSetAnchor").html('0');
$("#tdURPlaceDownGuy").html('0');
$("#tdURPlaceDownGuy").html('0');
$("#tdURPlaceGuyGuard").html('0');
$("#tdURTightenSpan").html('0');
$("#tdURRelashSpan").html('0');
$("#tdURLashStorageLoop").html('0');
$("#tdURRehangCase").html('0');
$("#tdURCutSpliceStrand").html('0');
$("#tdURRiserGuard").html('0');
$("#tdURFoamRiser").html('0');
$("#tdURPlaceFiberJumper").html('0');
$("#tdURPoleReplace").html('0');
$("#tdURVaultReplace").html('0');
$("#tdURLidReplace").html('0');
$("#tdURTrimVegetation").html('0');
$("#tdURRetagLine").html('0');
$("#tdURPlaceUGSign").html('0');
$("#tdURFiberSurvey").html('0');
$("#tdTotalrepaired").html('0');
$("#tdPoleFrames").html('0');
$("#tdRemoveHardware").html('0');
$("#tdrPlaceUGSign").html('0');
$("#tdFiberSurvey").html('0');

$("#tdSetAnchor").html('0');
$("#tdPlaceDownGuy").html('0');
$("#tdPlaceDownGuy").html('0');
$("#tdPlaceGuyGuard").html('0');
$("#tdTightenSpan").html('0');
$("#tdRelashSpan").html('0');
$("#tdLashStorageLoop").html('0');
$("#tdRehangCase").html('0');
$("#tdCutSpliceStrand").html('0');
$("#tdRiserGuard").html('0');
$("#tdFoamRiser").html('0');
$("#tdPlaceFiberJumper").html('0');
$("#tdPoleReplace").html('0');
$("#tdVaultReplace").html('0');
$("#tdLidReplace").html('0');
$("#tdTrimVegetation").html('0');
$("#tdRetagLine").html('0');
$("#tdPlaceUGSign").html('0');
$("#tdFiberSurvey").html('0');

       
$("#tdTotalDiscovered").html('0');   
$("#tdTotalRepaired").html('0');
$("#tdTotalUnrepaired").html('0');

 
 }     
  
  
});
                   
 //-------------------------------------------------------------------------------------------------Getgridwithdiscovery------------------------------------------------------------------------------------------------//
  function Getgridwithdiscovery(gridnum) {
        
       //var qLeft = "<Query><Where><Eq><FieldRef Name='Grid' /><Value Type='Text'>";
        //var qRight = "</Value></Eq> <Eq><FieldRef Name='Task_x0020_Type' /><Value Type='Choice'>Discovery</Value></Eq></And></Where></Query>";
           
           
var query="<Query><Where><And><Eq><FieldRef Name='Grid' /><Value Type='Lookup'>"+gridnum+"</Value></Eq><Eq><FieldRef Name='Task_x0020_Type' /><Value Type='Choice'>Discovery</Value></Eq></And></Where></Query>";

//var query2="<Query><Where><And><Eq><FieldRef Name='Grid' /><Value Type='Lookup'>"+gridnumtypeRepair+"</Value></Eq><Eq><FieldRef Name='Task_x0020_Type' /><Value Type='Choice'>Repair</Value></Eq></And></Where></Query>";
  
     
        
  // var query = qLeft+gridnum+ qRight;
       
 //alert(query);

        $().SPServices({
            operation: "GetListItems",
            async: false,
            listName: "Aerial Maintenance Tasks",
            CAMLQuery: query,
            completefunc: function(xData, Status) {

                $(xData.responseXML).SPFilterNode("z:row").each(function() {
                //alert(xData.responseText);
                   
                 

var pf=$(this).attr("ows_Pole_x0020_Frames");
//alert(pf);
//var aftersplitpf=pf.split("#")
result2=parseInt(pf)+result2;
if(result2=="")
{
result2=0;
$("#tdPoleFrames").html(result2);
}
else
{
$("#tdPoleFrames").html(result2);
 }
       

var rh=$(this).attr("ows_Remove_x0020_Hardware");
//var aftersplitrh=rh.split("#")
//alert(rh);
result3=parseInt(rh)+result3;
if(result3==0)
{
result3=0;
$("#tdRemoveHardware").html(result3);
}
else
{
$("#tdRemoveHardware").html(result3);
 }
       

var sa=$(this).attr("ows_Set_x0020_Anchor");
//var aftersplitsa=sa.split("#")
//alert(sa);
result4=parseInt(sa)+result4;
if(result4==0)
{
result4=0;
$("#tdSetAnchor").html(result4);
}
else
{
$("#tdSetAnchor").html(result4);
 }
       

var pdg=$(this).attr("ows_Place_x0020_Guy_x0020_Down");
//var aftersplitpdg=pdg.split("#")
//alert(pdg);
result5=parseInt(pdg)+result5;
if(result5==0)
{
result5=0;
$("#tdPlaceDownGuy").html(result5);
}
else
{
$("#tdPlaceDownGuy").html(result5);
 }
       

var pgg=$(this).attr("ows_Place_x0020_Guy_x0020_Guard");
//var aftersplitpgg=pgg.split("#")
//alert(pgg);
result6=parseInt(pgg)+result6;
if(result6==0)
{
result6=0;
$("#tdPlaceGuyGuard").html(result6);
}
else
{
$("#tdPlaceGuyGuard").html(result6);
 }
       

var ts=$(this).attr("ows_Tighten_x0020_Span");
//var aftersplitts=ts.split("#")
//alert(ts);
result7=parseInt(ts)+result7;
if(result7==0)
{
result7=0;
$("#tdTightenSpan").html(result7);
}
else
{
$("#tdTightenSpan").html(result7);
 }
       

var rs=$(this).attr("ows_Relash_x0020_Span");
//var aftersplitrs=rs.split("#")
result8=parseInt(rs)+result8;
if(result8==0)
{
result8=0;
$("#tdRelashSpan").html(result8);
}
else
{
$("#tdRelashSpan").html(result8);
 }
       

var lsl=$(this).attr("ows_Lash_x0020_Storage_x0020_Loop");
//var aftersplitlsl=lsl.split("#")
result9=parseInt(lsl)+result9;
if(result9==0)
{
result9=0;
$("#tdLashStorageLoop").html(result9);
}
else
{
$("#tdLashStorageLoop").html(result9);
 }
       

var rc=$(this).attr("ows_Rehang_x0020_Case");
//var aftersplitrc=rc.split("#")
result10=parseInt(rc)+result10;
if(result10==0)
{
result10=0;
$("#tdRehangCase").html(result10);
}
else
{
$("#tdRehangCase").html(result10);
 }
       

var css=$(this).attr("ows_Cut_x0020_Splice_x0020_Strand");
//var aftersplitcss=css.split("#")
result11=parseInt(css)+result11;
if(result11==0)
{
result11=0;
$("#tdCutSpliceStrand").html(result11);
}
else
{
$("#tdCutSpliceStrand").html(result11);
 }
       


var rrg=$(this).attr("ows_Replace_x0020_Riser_x0020_Guard");
//var aftersplitrrg=rrg.split("#")
result12=parseInt(rrg)+result12;
if(result12==0)
{
result12=0;
$("#tdRiserGuard").html(result12);
}
else
{
$("#tdRiserGuard").html(result12);
 }
       

var fr=$(this).attr("ows_Foam_x0020_Riser");
//var aftersplitfr=fr.split("#")
result13=parseInt(fr)+result13;
if(result13==0)
{
result13=0;
$("#tdFoamRiser").html(result13);
}
else
{
$("#tdFoamRiser").html(result13);
 }
       

var pfj=$(this).attr("ows_Place_x0020_Fiber_x0020_Jumper");
//var aftersplitpfj=pfj.split("#")
//alert(pfj);
result14=parseInt(pfj)+result14;
if(result14==0)
{
result14=0;
$("#tdPlaceFiberJumper").html(result14);
}
else
{
$("#tdPlaceFiberJumper").html(result14);
 }
       

var pr=$(this).attr("ows_Pole_x0020_Replace");
//var aftersplitpr=pr.split("#")
result15=parseInt(pr)+result15;
if(result15==0)
{
result15=0;
$("#tdPoleReplace").html(result15);
}
else
{
$("#tdPoleReplace").html(result15);
 }
       

var vr=$(this).attr("ows_Vault_x0020_Replace");
//var aftersplitvr=vr.split("#")
result16=parseInt(vr)+result16;
if(result16==0)
{
result16=0;
$("#tdVaultReplace").html(result16);
}
else
{
$("#tdVaultReplace").html(result16);
 }
       

var lr=$(this).attr("ows_Lid_x0020_Replace");
//var aftersplitlr=lr.split("#")
result17=parseInt(lr)+result17;
if(result17==0)
{
result17=0;
$("#tdLidReplace").html(result17);
}
else
{
$("#tdLidReplace").html(result17);
 }
       

var tv=$(this).attr("ows_Trim_x0020_Vegetation");
//var aftersplittv=tv.split("#")
result18=parseInt(tv)+result18;
if(result18==0)
{
result18=0;
$("#tdTrimVegetation").html(result18);
}
else
{
$("#tdTrimVegetation").html(result18);
 }
       

var rl=$(this).attr("ows_Retag_x0020_Line");
//var aftersplitrl=rl.split("#")
result19=parseInt(rl)+result19;
if(result19==0)
{
result19=0;
$("#tdRetagLine").html(result19);
}
else
{
$("#tdRetagLine").html(result19);
 }
       

var pus=$(this).attr("ows_Place_x0020_UG_x0020_Sign");
//var aftersplitpus=pus.split("#")
result20=parseInt(pus)+result20;
if(result20==0)
{
result20=0;
$("#tdPlaceUGSign").html(result20);
}
else
{
$("#tdPlaceUGSign").html(result20);
 }
       

var fs=$(this).attr("ows_Fiber_x0020_Survey");
//var aftersplitfs=fs.split("#")
result21=parseInt(fs)+result21;
if(result21==0)
{
result21=0;
$("#tdFiberSurvey").html(result21);
}
else
{
$("#tdFiberSurvey").html(result21);
 }
       
resultdiscovered= result2+result3+result4+result5+result6+result7+result8+result9+result10+result11+result12+result13+result14+result15+result16+result17+result18+result19+result20+result21;
$("#tdTotalDiscovered").html(resultdiscovered);

  
                });
            }
        });
 
}

//--------------------------unrepaiRed-----------------------------//
function Getgrid(gridnum) {
        
       var qLeft = "<Query><Where><Eq><FieldRef Name='Grid' /><Value Type='Text'>";
        var qRight = "</Value></Eq></Where></Query>";
           
           
//var query="<Query><Where><And><Eq><FieldRef Name='Grid' /><Value Type='Lookup'>"+gridnumtypeDiscovery+"</Value></Eq><Eq><FieldRef Name='Task_x0020_Type' /><Value Type='Choice'>Discovery</Value></Eq></And></Where></Query>";

//var query="<Query><Where><And><Eq><FieldRef Name='Grid' /><Value Type='Lookup'>"+gridnumtypeRepair+"</Value></Eq><Eq><FieldRef Name='Task_x0020_Type' /><Value Type='Choice'>Repair</Value></Eq></And></Where></Query>";
  
     
        
  var query = qLeft+gridnum+ qRight;
       
 //alert(query);

        $().SPServices({
            operation: "GetListItems",
            async: false,
            listName: "Aerial Maintenance Tasks",
            CAMLQuery: query,
            completefunc: function(xData, Status) {

                $(xData.responseXML).SPFilterNode("z:row").each(function() {
                 //alert(xData.responseText);
                   
                  var cmp=$(this).attr("ows_Total_x0020_Unrepairable");
                  var aftersplitcmp=cmp.split("#")
                   //alert("aftersplit"+aftersplitcmp[1]);
                  result1=parseInt(aftersplitcmp[1])+result1;
                 $("#tdTotalUnrepaired").html(result1);
                 //var cmp=0;
                 //alert("after 0 value"+cmp);
                 
                


var upf=$(this).attr("ows_Unrepairable_x0020_Pole_x0020_Fr");
//alert(upf);
resulta=parseInt(upf)+resulta;
if(resulta==0)
{
resulta=0;
$("#tdURPoleFrames").html(resulta);
}
else
{
$("#tdURPoleFrames").html(resulta);
}

var urh=$(this).attr("ows_Unrepairable_x0020_Remove_x0020_");
resultb=parseInt(urh)+resultb;
if(resultb==0)
{
resultb=0;
$("#tdURRemoveHardware").html(resultb);
}
else
{
$("#tdURRemoveHardware").html(resultb);
}

var usa=$(this).attr("ows_Unrepairable_x0020_Set_x0020_Anc");
resultc=parseInt(usa)+resultc;
if(resultc==0)
{
resultc=0;
$("#tdURSetAnchor").html(resultc);
}
else
{
$("#tdURSetAnchor").html(resultc);
}

var updg=$(this).attr("ows_Unrepairable_x0020_Place_x0020_D");
resultd=parseInt(updg)+resultd;
if(resultd==0)
{
resultd=0;
$("#tdURPlaceDownGuy").html(resultd);
}
else
{
$("#tdURPlaceDownGuy").html(resultd);
}

var upgg=$(this).attr("ows_Unrepairable_x0020_Place_x0020_G");
resulte=parseInt(upgg)+resulte;
if(resulte==0)
{
resulte=0;
$("#tdURPlaceGuyGuard").html(resulte);
}
else
{
$("#tdURPlaceGuyGuard").html(resulte);
}

var uts=$(this).attr("ows_Unrepairable_x0020_Tighten_x0020");
resultf=parseInt(uts)+resultf;
if(resultf==0)
{
resultf=0;
$("#tdURTightenSpan").html(resultf);
}
else
{
$("#tdURTightenSpan").html(resultf);
}

var urs=$(this).attr("ows_Unrepairable_x0020_Relash_x0020_");
resultg=parseInt(urs)+resultg;
if(resultg==0)
{
resultg=0;
$("#tdURRelashSpan").html(resultg);
}
else
{
$("#tdURRelashSpan").html(resultg);
}

var ulsl=$(this).attr("ows_Unrepairable_x0020_Lash_x0020_St");
resulth=parseInt(ulsl)+resulth;
if(resulth==0)
{
resulth=0;
$("#tdURLashStorageLoop").html(resulth);
}
else
{
$("#tdURLashStorageLoop").html(resulth);
}

var urc=$(this).attr("ows_Unrepairable_x0020_Rehang_x0020_");
resulti=parseInt(urc)+resulti;
if(resulti==0)
{
resulti=0;
$("#tdURRehangCase").html(resulti);
}
else
{
$("#tdURRehangCase").html(resulti);
}

var ucss=$(this).attr("ows_Unrepairable_x0020_Cut_x0020_Spl");
resultj=parseInt(ucss)+resultj;
if(resultj==0)
{
resultj=0;
$("#tdURCutSpliceStrand").html(resultj);
}
else
{
$("#tdURCutSpliceStrand").html(resultj);
}


var urrg=$(this).attr("ows_Unrepairable_x0020_Replace_x0020");
resultk=parseInt(urrg)+resultk;
if(resultk==0)
{
resultk=0;
$("#tdURRiserGuard").html(resultk);
}
else
{
$("#tdURRiserGuard").html(resultk);
}

var ufr=$(this).attr("ows_Unrepairable_x0020_Foam_x0020_Ri");
resultl=parseInt(ufr)+resultl;
if(resultl==0)
{
resultl=0;
$("#tdURFoamRiser").html(resultl);
}
else
{
$("#tdURFoamRiser").html(resultl);
}

var upfj=$(this).attr("ows_Unrepairable_x0020_Place_x0020_F");
resultm=parseInt(upfj)+resultm;
if(resultm==0)
{
resultm=0;
$("#tdURPlaceFiberJumper").html(resultm);
}
else
{
$("#tdURPlaceFiberJumper").html(resultm);
}

var upr=$(this).attr("ows_Unrepairable_x0020_Pole_x0020_Re");
resultn=parseInt(upr)+resultn;
if(resultn==0)
{
resultn=0;
$("#tdURPoleReplace").html(resultn);
}
else
{
$("#tdURPoleReplace").html(resultn);
}

var uvr=$(this).attr("ows_Unrepairable_x0020_Vault_x0020_R");
resulto=parseInt(uvr)+resulto;
if(resulto==0)
{
resulto=0;
$("#tdURVaultReplace").html(resulto);
}
else
{
$("#tdURVaultReplace").html(resulto);
}

var ulr=$(this).attr("ows_Unrepairable_x0020_Lid_x0020_Rep");
resultp=parseInt(ulr)+resultp;
if(resultp==0)
{
resultp=0;
$("#tdURLidReplace").html(resultp);
}
else
{
$("#tdURLidReplace").html(resultp);
}

var utv=$(this).attr("ows_Unrepairable_x0020_Trim_x0020_Ve");
resultq=parseInt(utv)+resultq;
if(resultq==0)
{
resultq=0;
$("#tdURTrimVegetation").html(resultq);
}
else
{
$("#tdURTrimVegetation").html(resultq);
}

var url=$(this).attr("ows_Unrepairable_x0020_Retag_x0020_L");
resultr=parseInt(url)+resultr;
if(resultr==0)
{
resultr=0;
$("#tdURRetagLine").html(resultr);
}
else
{
$("#tdURRetagLine").html(resultr);
}

var upus=$(this).attr("ows_Unrepairable_x0020_Place_x0020_U");
results=parseInt(upus)+results;
if(results==0)
{
results=0;
$("#tdURPlaceUGSign").html(results);
}
else
{
$("#tdURPlaceUGSign").html(results);
}

var ufs=$(this).attr("ows_Unrepairable_x0020_Fiber_x0020_S");
resultt=parseInt(ufs)+resultt;
if(resultt==0)
{
resultt=0;
$("#tdURFiberSurvey").html(resultt);
}
else
{
$("#tdURFiberSurvey").html(resultt);
}
                });
                
            }
            
        });
 
}

 //--------------------------------------------------------------------------------------------------------repaired------------------------------------------------------------------------------------------//

 function Getgridwithrep(gridnum) {
        

var query="<Query><Where><And><Eq><FieldRef Name='Grid' /><Value Type='Lookup'>"+gridnum+"</Value></Eq><Eq><FieldRef Name='Task_x0020_Type' /><Value Type='Choice'>Repair</Value></Eq></And></Where></Query>";

 $().SPServices({
            operation: "GetListItems",
            async: false,
            listName: "Aerial Maintenance Tasks",
            CAMLQuery: query,
            completefunc: function(xData, Status) {

                $(xData.responseXML).SPFilterNode("z:row").each(function() {
                //alert(xData.responseText);
                   
                 

var pf=$(this).attr("ows_Pole_x0020_Frames");
//alert(pf);
//var aftersplitpf=pf.split("#")
result23=parseInt(pf)+result23;
//alert(result23);
if(result23==0)
{
//alert("entered");
result23=0;
$("#tdrPoleFrames").html(result23);
}
else
{
$("#tdrPoleFrames").html(result23);
}

var rh=$(this).attr("ows_Remove_x0020_Hardware");
//var aftersplitrh=rh.split("#")
//alert(rh);
result24=parseInt(rh)+result24;
if(result24==0)
{
result24=0;
$("#tdrRemoveHardware").html(result24);
}
else
{
$("#tdrRemoveHardware").html(result24);
}

var sa=$(this).attr("ows_Set_x0020_Anchor");
//var aftersplitsa=sa.split("#")
//alert(sa);
result25=parseInt(sa)+result25;
if(result25==0)
{
result25=0;
$("#tdrSetAnchor").html(result25);
}
else
{
$("#tdrSetAnchor").html(result25);
}

var pdg=$(this).attr("ows_Place_x0020_Guy_x0020_Down");
//var aftersplitpdg=pdg.split("#")
//alert(pdg);
result26=parseInt(pdg)+result26;
if(result26==0)
{
result26=0;
$("#tdrPlaceDownGuy").html(result26);
}
else
{
$("#tdrPlaceDownGuy").html(result26);
}

var pgg=$(this).attr("ows_Place_x0020_Guy_x0020_Guard");
//var aftersplitpgg=pgg.split("#")
//alert(pgg);
result27=parseInt(pgg)+result27;
if(result27==0)
{
result27=0;
$("#tdrPlaceGuyGuard").html(result27);
}
else
{
$("#tdrPlaceGuyGuard").html(result27);
}

var ts=$(this).attr("ows_Tighten_x0020_Span");
//var aftersplitts=ts.split("#")
//alert(ts);
result28=parseInt(ts)+result28;
if(result28==0)
{
result28=0;
$("#tdrTightenSpan").html(result28);
}
else
{
$("#tdrTightenSpan").html(result28);
}

var rs=$(this).attr("ows_Relash_x0020_Span");
//var aftersplitrs=rs.split("#")
result29=parseInt(rs)+result29;
if(result29==0)
{
result29=0;
$("#tdrRelashSpan").html(result29);
}
else
{
$("#tdrRelashSpan").html(result29);
}

var lsl=$(this).attr("ows_Lash_x0020_Storage_x0020_Loop");
//var aftersplitlsl=lsl.split("#")
result30=parseInt(lsl)+result30;
if(result30==0)
{
result30=0;
$("#tdrLashStorageLoop").html(result30);
}
else
{
$("#tdrLashStorageLoop").html(result30);
}

var rc=$(this).attr("ows_Rehang_x0020_Case");
//var aftersplitrc=rc.split("#")
result31=parseInt(rc)+result31;
if(result31==0)
{
result31=0;
$("#tdrRehangCase").html(result31);
}
else
{
$("#tdrRehangCase").html(result31);
}

var css=$(this).attr("ows_Cut_x0020_Splice_x0020_Strand");
//var aftersplitcss=css.split("#")
result32=parseInt(css)+result32;
if(result32==0)
{
result32=0;
$("#tdrCutSpliceStrand").html(result32);
}
else
{
$("#tdrCutSpliceStrand").html(result32);
}


var rrg=$(this).attr("ows_Replace_x0020_Riser_x0020_Guard");
//var aftersplitrrg=rrg.split("#")
result33=parseInt(rrg)+result33;
if(result33==0)
{
result33=0;
$("#tdrRiserGuard").html(result33);
}
else
{
$("#tdrRiserGuard").html(result33);
}

var fr=$(this).attr("ows_Foam_x0020_Riser");
//var aftersplitfr=fr.split("#")
result34=parseInt(fr)+result34;
if(result34==0)
{
result34=0;
$("#tdrFoamRiser").html(result34);
}
else
{
$("#tdrFoamRiser").html(result34);
}

var pfj=$(this).attr("ows_Place_x0020_Fiber_x0020_Jumper");
//var aftersplitpfj=pfj.split("#")
//alert(pfj);
result35=parseInt(pfj)+result35;
if(result35==0)
{
result35=0;
$("#tdrPlaceFiberJumper").html(result35);
}
else
{
$("#tdrPlaceFiberJumper").html(result35);
}

var pr=$(this).attr("ows_Pole_x0020_Replace");
//var aftersplitpr=pr.split("#")
result36=parseInt(pr)+result36;
if(result36==0)
{
result36=0;
$("#tdrPoleReplace").html(result36);
}
else
{
$("#tdrPoleReplace").html(result36);
}

var vr=$(this).attr("ows_Vault_x0020_Replace");
//var aftersplitvr=vr.split("#")
result37=parseInt(vr)+result37;
if(result37==0)
{
result37=0;
$("#tdrVaultReplace").html(result37);
}
else
{
$("#tdrVaultReplace").html(result37);
}

var lr=$(this).attr("ows_Lid_x0020_Replace");
//var aftersplitlr=lr.split("#")
result38=parseInt(lr)+result38;
if(result38==0)
{
result38=0;
$("#tdrLidReplace").html(result38);
}
else
{
$("#tdrLidReplace").html(result38);
}

var tv=$(this).attr("ows_Trim_x0020_Vegetation");
//var aftersplittv=tv.split("#")
result39=parseInt(tv)+result39;
if(result39==0)
{
result39=0;
$("#tdrTrimVegetation").html(result39);
}
else
{
$("#tdrTrimVegetation").html(result39);
}

var rl=$(this).attr("ows_Retag_x0020_Line");
//var aftersplitrl=rl.split("#")
result40=parseInt(rl)+result40;
if(result40==0)
{
result40=0;
$("#tdrRetagLine").html(result40);
}
else
{
$("#tdrRetagLine").html(result40);
}

var pus=$(this).attr("ows_Place_x0020_UG_x0020_Sign");
//var aftersplitpus=pus.split("#")
result41=parseInt(pus)+result41;
if(result41==0)
{
result41=0;
$("#tdrPlaceUGSign").html(result41);
}
else
{
$("#tdrPlaceUGSign").html(result41);
}

var fs=$(this).attr("ows_Fiber_x0020_Survey");
//var aftersplitfs=fs.split("#")
result42=parseInt(fs)+result42;
if(result42==0)
{
result42=0;
$("#tdrFiberSurvey").html(result42);
}
else
{
$("#tdrFiberSurvey").html(result42);
}


resultrepaired= result23+result24+result25+result26+result27+result28+result29+result30+result31+result32+result33+result34+result35+result36+result37+result38+result39+result40+result41+result42;
$("#tdTotalRepaired").html(resultrepaired);


                });
                
                
            }
        });
 
}
        
   
   
 
//-----------------------------------------------------------------------------------------------work order number-------------------------------------------------------------------//

//-----------------------------------------------------------------------------------------------Getwonunrepaired-------------------------------------------------------------------//


function  Getgridwonunrepaired(wons)
{
//alert("entered");
 var qLeft = "<Query><Where><Eq><FieldRef Name='Discovery_x0020_Work_x0020_Order' /><Value Type='Number'>";
        var qRight = "</Value></Eq></Where></Query>";
           
           
//var query="<Query><Where><And><Eq><FieldRef Name='Grid' /><Value Type='Lookup'>"+gridnum+"</Value></Eq><Eq><FieldRef Name='Work_x0020_Order_x0020_Number' /><Value Type='Number'>+"won"+</Value></Eq></And></Where></Query>";

//var query="<Query><Where><And><Eq><FieldRef Name='Grid' /><Value Type='Lookup'>"+gridnumtypeRepair+"</Value></Eq><Eq><FieldRef Name='Task_x0020_Type' /><Value Type='Choice'>Repair</Value></Eq></And></Where></Query>";
  
     
        
  var query = qLeft+wons+qRight;
       
 //alert(query);

        $().SPServices({
            operation: "GetListItems",
            async: false,
            listName: "Aerial Maintenance Tasks",
            CAMLQuery: query,
            completefunc: function(xData, Status) {

                $(xData.responseXML).SPFilterNode("z:row").each(function() {
                 //alert(xData.responseText);
                   
                  var cmp=$(this).attr("ows_Total_x0020_Unrepairable");
                  var aftersplitcmp=cmp.split("#")
                  result1=parseInt(aftersplitcmp[1])+result1;
                 $("#tdTotalUnrepaired").html(result1);
                 
                 

var upf=$(this).attr("ows_Unrepairable_x0020_Pole_x0020_Fr");
//alert(upf);
resulta=parseInt(upf)+resulta;
$("#tdURPoleFrames").html(resulta);


var urh=$(this).attr("ows_Unrepairable_x0020_Remove_x0020_");
resultb=parseInt(urh)+resultb;
$("#tdURRemoveHardware").html(resultb);


var usa=$(this).attr("ows_Unrepairable_x0020_Set_x0020_Anc");
resultc=parseInt(usa)+resultc;
$("#tdURSetAnchor").html(resultc);


var updg=$(this).attr("ows_Unrepairable_x0020_Place_x0020_D");
resultd=parseInt(updg)+resultd;
$("#tdURPlaceDownGuy").html(resultd);


var upgg=$(this).attr("ows_Unrepairable_x0020_Place_x0020_G");
resulte=parseInt(upgg)+resulte;
$("#tdURPlaceGuyGuard").html(resulte);


var uts=$(this).attr("ows_Unrepairable_x0020_Tighten_x0020");
resultf=parseInt(uts)+resultf;
$("#tdURTightenSpan").html(resultf);


var urs=$(this).attr("ows_Unrepairable_x0020_Relash_x0020_");
resultg=parseInt(urs)+resultg;
$("#tdURRelashSpan").html(resultg);


var ulsl=$(this).attr("ows_Unrepairable_x0020_Lash_x0020_St");
resulth=parseInt(ulsl)+resulth;
$("#tdURLashStorageLoop").html(resulth);


var urc=$(this).attr("ows_Unrepairable_x0020_Rehang_x0020_");
resulti=parseInt(urc)+resulti;
$("#tdURRehangCase").html(resulti);


var ucss=$(this).attr("ows_Unrepairable_x0020_Cut_x0020_Spl");
resultj=parseInt(ucss)+resultj;
$("#tdURCutSpliceStrand").html(resultj);



var urrg=$(this).attr("ows_Unrepairable_x0020_Replace_x0020");
resultk=parseInt(urrg)+resultk;
$("#tdURRiserGuard").html(resultk);


var ufr=$(this).attr("ows_Unrepairable_x0020_Foam_x0020_Ri");
resultl=parseInt(ufr)+resultl;
$("#tdURFoamRiser").html(resultl);


var upfj=$(this).attr("ows_Unrepairable_x0020_Place_x0020_F");
resultm=parseInt(upfj)+resultm;
$("#tdURPlaceFiberJumper").html(resultm);


var upr=$(this).attr("ows_Unrepairable_x0020_Pole_x0020_Re");
resultn=parseInt(upr)+resultn;
$("#tdURPoleReplace").html(resultn);


var uvr=$(this).attr("ows_Unrepairable_x0020_Vault_x0020_R");
resulto=parseInt(uvr)+resulto;
$("#tdURVaultReplace").html(resulto);


var ulr=$(this).attr("ows_Unrepairable_x0020_Lid_x0020_Rep");
resultp=parseInt(ulr)+resultp;
$("#tdURLidReplace").html(resultp);


var utv=$(this).attr("ows_Unrepairable_x0020_Trim_x0020_Ve");
resultq=parseInt(utv)+resultq;
$("#tdURTrimVegetation").html(resultq);


var url=$(this).attr("ows_Unrepairable_x0020_Retag_x0020_L");
resultr=parseInt(url)+resultr;
$("#tdURRetagLine").html(resultr);


var upus=$(this).attr("ows_Unrepairable_x0020_Place_x0020_U");
results=parseInt(upus)+results;
$("#tdURPlaceUGSign").html(results);


var ufs=$(this).attr("ows_Unrepairable_x0020_Fiber_x0020_S");
resultt=parseInt(ufs)+resultt;
$("#tdURFiberSurvey").html(resultt);




           });
            }
        });
 
}

//===========================================discovered-won====================================================//
function Getwondiscovered(wons) {
        
       //var qLeft = "<Query><Where><Eq><FieldRef Name='Work_x0020_Order_x0020_Number' /><Value Type='Number'>";
        //var qRight = "</Value></Eq> </Where></Query>";
           
           
var query="<Query><Where><And><Eq><FieldRef Name='Discovery_x0020_Work_x0020_Order' /><Value Type='Number'>"+wons+"</Value></Eq><Eq><FieldRef Name='Task_x0020_Type' /><Value Type='Choice'>Discovery</Value></Eq></And></Where></Query>";

//var query2="<Query><Where><And><Eq><FieldRef Name='Grid' /><Value Type='Lookup'>"+gridnumtypeRepair+"</Value></Eq><Eq><FieldRef Name='Task_x0020_Type' /><Value Type='Choice'>Repair</Value></Eq></And></Where></Query>";
  
     
        
  //var query = qLeft+wons+ qRight;
       
 //alert(query);

        $().SPServices({
            operation: "GetListItems",
            async: false,
            listName: "Aerial Maintenance Tasks",
            CAMLQuery: query,
            completefunc: function(xData, Status) {

                $(xData.responseXML).SPFilterNode("z:row").each(function() {
                //alert(xData.responseText);
                   
                 

var pf=$(this).attr("ows_Pole_x0020_Frames");
//alert(pf);
//var aftersplitpf=pf.split("#")
result2=parseInt(pf)+result2;
$("#tdPoleFrames").html(result2);


var rh=$(this).attr("ows_Remove_x0020_Hardware");
//var aftersplitrh=rh.split("#")
//alert(rh);
result3=parseInt(rh)+result3;
$("#tdRemoveHardware").html(result3);


var sa=$(this).attr("ows_Set_x0020_Anchor");
//var aftersplitsa=sa.split("#")
//alert(sa);
result4=parseInt(sa)+result4;
$("#tdSetAnchor").html(result4);


var pdg=$(this).attr("ows_Place_x0020_Guy_x0020_Down");
//var aftersplitpdg=pdg.split("#")
//alert(pdg);
result5=parseInt(pdg)+result5;
$("#tdPlaceDownGuy").html(result5);


var pgg=$(this).attr("ows_Place_x0020_Guy_x0020_Guard");
//var aftersplitpgg=pgg.split("#")
//alert(pgg);
result6=parseInt(pgg)+result6;
$("#tdPlaceGuyGuard").html(result6);


var ts=$(this).attr("ows_Tighten_x0020_Span");
//var aftersplitts=ts.split("#")
//alert(ts);
result7=parseInt(ts)+result7;
$("#tdTightenSpan").html(result7);


var rs=$(this).attr("ows_Relash_x0020_Span");
//var aftersplitrs=rs.split("#")
result8=parseInt(rs)+result8;
$("#tdRelashSpan").html(result8);


var lsl=$(this).attr("ows_Lash_x0020_Storage_x0020_Loop");
//var aftersplitlsl=lsl.split("#")
result9=parseInt(lsl)+result9;
$("#tdLashStorageLoop").html(result9);


var rc=$(this).attr("ows_Rehang_x0020_Case");
//var aftersplitrc=rc.split("#")
result10=parseInt(rc)+result10;
$("#tdRehangCase").html(result10);


var css=$(this).attr("ows_Cut_x0020_Splice_x0020_Strand");
//var aftersplitcss=css.split("#")
result11=parseInt(css)+result11;
$("#tdCutSpliceStrand").html(result11);



var rrg=$(this).attr("ows_Replace_x0020_Riser_x0020_Guard");
//var aftersplitrrg=rrg.split("#")
result12=parseInt(rrg)+result12;
$("#tdRiserGuard").html(result12);


var fr=$(this).attr("ows_Foam_x0020_Riser");
//var aftersplitfr=fr.split("#")
result13=parseInt(fr)+result13;
$("#tdFoamRiser").html(result13);


var pfj=$(this).attr("ows_Place_x0020_Fiber_x0020_Jumper");
//var aftersplitpfj=pfj.split("#")
//alert(pfj);
result14=parseInt(pfj)+result14;
$("#tdPlaceFiberJumper").html(result14);


var pr=$(this).attr("ows_Pole_x0020_Replace");
//var aftersplitpr=pr.split("#")
result15=parseInt(pr)+result15;
$("#tdPoleReplace").html(result15);


var vr=$(this).attr("ows_Vault_x0020_Replace");
//var aftersplitvr=vr.split("#")
result16=parseInt(vr)+result16;
$("#tdVaultReplace").html(result16);


var lr=$(this).attr("ows_Lid_x0020_Replace");
//var aftersplitlr=lr.split("#")
result17=parseInt(lr)+result17;
$("#tdLidReplace").html(result17);


var tv=$(this).attr("ows_Trim_x0020_Vegetation");
//var aftersplittv=tv.split("#")
result18=parseInt(tv)+result18;
$("#tdTrimVegetation").html(result18);


var rl=$(this).attr("ows_Retag_x0020_Line");
//var aftersplitrl=rl.split("#")
result19=parseInt(rl)+result19;
$("#tdRetagLine").html(result19);


var pus=$(this).attr("ows_Place_x0020_UG_x0020_Sign");
//var aftersplitpus=pus.split("#")
result20=parseInt(pus)+result20;
$("#tdPlaceUGSign").html(result20);


var fs=$(this).attr("ows_Fiber_x0020_Survey");
//var aftersplitfs=fs.split("#")
result21=parseInt(fs)+result21;
$("#tdFiberSurvey").html(result21);

resultdiscovered= result2+result3+result4+result5+result6+result7+result8+result9+result10+result11+result12+result13+result14+result15+result16+result17+result18+result19+result20+result21;
$("#tdTotalDiscovered").html(resultdiscovered);

                });
            }
        });
 
}


//===========================================repaired-won====================================================//
function Getwonrepaired(wons) {
        
       //var qLeft = "<Query><Where><Eq><FieldRef Name='Grid' /><Value Type='Text'>";
        //var qRight = "</Value></Eq> <Eq><FieldRef Name='Task_x0020_Type' /><Value Type='Choice'>Discovery</Value></Eq></And></Where></Query>";
      
     
           
var query="<Query><Where><And><Eq><FieldRef Name='Discovery_x0020_Work_x0020_Order' /><Value Type='Lookup'>"+wons+"</Value></Eq><Eq><FieldRef Name='Task_x0020_Type' /><Value Type='Choice'>Repair</Value></Eq></And></Where></Query>";

//var query2="<Query><Where><And><Eq><FieldRef Name='Grid' /><Value Type='Lookup'>"+gridnumtypeRepair+"</Value></Eq><Eq><FieldRef Name='Task_x0020_Type' /><Value Type='Choice'>Repair</Value></Eq></And></Where></Query>";
  
   // alert("won repaired called");
        
  // var query = qLeft+gridnum+ qRight;
       
// alert(query);

        $().SPServices({
            operation: "GetListItems",
            async: false,
            listName: "Aerial Maintenance Tasks",
            CAMLQuery: query,
            completefunc: function(xData, Status) {

                $(xData.responseXML).SPFilterNode("z:row").each(function() {
               // alert(xData.responseText);
                   
                 

var pf=$(this).attr("ows_Pole_x0020_Frames");
//alert(pf);
//var aftersplitpf=pf.split("#")
//alert(pf);
result23=parseInt(pf)+result23;
$("#tdrPoleFrames").html(result23);


var rh=$(this).attr("ows_Remove_x0020_Hardware");
//var aftersplitrh=rh.split("#")
//alert(rh);
result24=parseInt(rh)+result24;
$("#tdrRemoveHardware").html(result24);


var sa=$(this).attr("ows_Set_x0020_Anchor");
//var aftersplitsa=sa.split("#")
//alert(sa);
result25=parseInt(sa)+result25;
$("#tdrSetAnchor").html(result25);


var pdg=$(this).attr("ows_Place_x0020_Guy_x0020_Down");
//var aftersplitpdg=pdg.split("#")
//alert(pdg);
result26=parseInt(pdg)+result26;
$("#tdrPlaceDownGuy").html(result26);


var pgg=$(this).attr("ows_Place_x0020_Guy_x0020_Guard");
//var aftersplitpgg=pgg.split("#")
//alert(pgg);
result27=parseInt(pgg)+result27;
$("#tdrPlaceGuyGuard").html(result27);


var ts=$(this).attr("ows_Tighten_x0020_Span");
//var aftersplitts=ts.split("#")
//alert(ts);
result28=parseInt(ts)+result28;
$("#tdrTightenSpan").html(result28);


var rs=$(this).attr("ows_Relash_x0020_Span");
//var aftersplitrs=rs.split("#")
result29=parseInt(rs)+result29;
$("#tdrRelashSpan").html(result29);


var lsl=$(this).attr("ows_Lash_x0020_Storage_x0020_Loop");
//var aftersplitlsl=lsl.split("#")
result30=parseInt(lsl)+result30;
$("#tdrLashStorageLoop").html(result30);


var rc=$(this).attr("ows_Rehang_x0020_Case");
//var aftersplitrc=rc.split("#")
result31=parseInt(rc)+result31;
$("#tdrRehangCase").html(result31);


var css=$(this).attr("ows_Cut_x0020_Splice_x0020_Strand");
//var aftersplitcss=css.split("#")
result32=parseInt(css)+result32;
$("#tdrCutSpliceStrand").html(result32);



var rrg=$(this).attr("ows_Replace_x0020_Riser_x0020_Guard");
//var aftersplitrrg=rrg.split("#")
result33=parseInt(rrg)+result33;
$("#tdrRiserGuard").html(result33);


var fr=$(this).attr("ows_Foam_x0020_Riser");
//var aftersplitfr=fr.split("#")
result34=parseInt(fr)+result34;
$("#tdrFoamRiser").html(result34);


var pfj=$(this).attr("ows_Place_x0020_Fiber_x0020_Jumper");
//var aftersplitpfj=pfj.split("#")
//alert(pfj);
result35=parseInt(pfj)+result35;
$("#tdrPlaceFiberJumper").html(result35);


var pr=$(this).attr("ows_Pole_x0020_Replace");
//var aftersplitpr=pr.split("#")
result36=parseInt(pr)+result36;
$("#tdrPoleReplace").html(result36);


var vr=$(this).attr("ows_Vault_x0020_Replace");
//var aftersplitvr=vr.split("#")
result37=parseInt(vr)+result37;
$("#tdrVaultReplace").html(result37);


var lr=$(this).attr("ows_Lid_x0020_Replace");
//var aftersplitlr=lr.split("#")
result38=parseInt(lr)+result38;
$("#tdrLidReplace").html(result38);


var tv=$(this).attr("ows_Trim_x0020_Vegetation");
//var aftersplittv=tv.split("#")
result39=parseInt(tv)+result39;
$("#tdrTrimVegetation").html(result39);


var rl=$(this).attr("ows_Retag_x0020_Line");
//var aftersplitrl=rl.split("#")
result40=parseInt(rl)+result40;
$("#tdrRetagLine").html(result40);


var pus=$(this).attr("ows_Place_x0020_UG_x0020_Sign");
//var aftersplitpus=pus.split("#")
result41=parseInt(pus)+result41;
$("#tdrPlaceUGSign").html(result41);


var fs=$(this).attr("ows_Fiber_x0020_Survey");
//var aftersplitfs=fs.split("#")
result42=parseInt(fs)+result42;
$("#tdrFiberSurvey").html(result42);

resultrepaired= result23+result24+result25+result26+result27+result28+result29+result30+result31+result32+result33+result34+result35+result36+result37+result38+result39+result40+result41+result42;
$("#tdTotalRepaired").html(resultrepaired);


                });
            }
        });
 
}
     
 
  
 //-----------------------------------------------------------------------------------------------querying won  +  gridnum   +    tasktype= discovery -------------------------------------------------------------------//

//-----------------------------------------------------------------------------------------------***************************************************-------------------------------------------------------------------//

    function Getgridwondis(gridnum,won){  
    
    //alert(gridnum); alert(won);
    
    var query="<Query><Where> <And><Eq><FieldRef Name='Grid' /><Value Type='Lookup'>"+gridnum+"</Value> </Eq><And><Eq><FieldRef Name='Discovery_x0020_Work_x0020_Order' /><Value Type='Number'>"+won+"</Value></Eq> <Eq><FieldRef Name='Task_x0020_Type' /><Value Type='Choice'>Discovery</Value></Eq> </And></And> </Where></Query>";
//alert(query);
$().SPServices({
            operation: "GetListItems",
            async: false,
            listName: "Aerial Maintenance Tasks",
            CAMLQuery: query,
            completefunc: function(xData, Status) {

                $(xData.responseXML).SPFilterNode("z:row").each(function() {
                 
        var cmp=$(this).attr("ows_Total_x0020_Unrepairable");
                  var aftersplitcmp=cmp.split("#")
                  result1=parseInt(aftersplitcmp[1])+result1;
                 $("#tdTotalUnrepaired").html(result1);
    
          var pf=$(this).attr("ows_Pole_x0020_Frames");
//alert(pf);
//var aftersplitpf=pf.split("#")
result2=parseInt(pf)+result2;
$("#tdPoleFrames").html(result2);


var rh=$(this).attr("ows_Remove_x0020_Hardware");
//var aftersplitrh=rh.split("#")
//alert(rh);
result3=parseInt(rh)+result3;
$("#tdRemoveHardware").html(result3);


var sa=$(this).attr("ows_Set_x0020_Anchor");
//var aftersplitsa=sa.split("#")
//alert(sa);
result4=parseInt(sa)+result4;
$("#tdSetAnchor").html(result4);


var pdg=$(this).attr("ows_Place_x0020_Guy_x0020_Down");
//var aftersplitpdg=pdg.split("#")
//alert(pdg);
result5=parseInt(pdg)+result5;
$("#tdPlaceDownGuy").html(result5);


var pgg=$(this).attr("ows_Place_x0020_Guy_x0020_Guard");
//var aftersplitpgg=pgg.split("#")
//alert(pgg);
result6=parseInt(pgg)+result6;
$("#tdPlaceGuyGuard").html(result6);


var ts=$(this).attr("ows_Tighten_x0020_Span");
//var aftersplitts=ts.split("#")
//alert(ts);
result7=parseInt(ts)+result7;
$("#tdTightenSpan").html(result7);


var rs=$(this).attr("ows_Relash_x0020_Span");
//var aftersplitrs=rs.split("#")
result8=parseInt(rs)+result8;
$("#tdRelashSpan").html(result8);


var lsl=$(this).attr("ows_Lash_x0020_Storage_x0020_Loop");
//var aftersplitlsl=lsl.split("#")
result9=parseInt(lsl)+result9;
$("#tdLashStorageLoop").html(result9);


var rc=$(this).attr("ows_Rehang_x0020_Case");
//var aftersplitrc=rc.split("#")
result10=parseInt(rc)+result10;
$("#tdRehangCase").html(result10);


var css=$(this).attr("ows_Cut_x0020_Splice_x0020_Strand");
//var aftersplitcss=css.split("#")
result11=parseInt(css)+result11;
$("#tdCutSpliceStrand").html(result11);



var rrg=$(this).attr("ows_Replace_x0020_Riser_x0020_Guard");
//var aftersplitrrg=rrg.split("#")
result12=parseInt(rrg)+result12;
$("#tdRiserGuard").html(result12);


var fr=$(this).attr("ows_Foam_x0020_Riser");
//var aftersplitfr=fr.split("#")
result13=parseInt(fr)+result13;
$("#tdFoamRiser").html(result13);


var pfj=$(this).attr("ows_Place_x0020_Fiber_x0020_Jumper");
//var aftersplitpfj=pfj.split("#")
//alert(pfj);
result14=parseInt(pfj)+result14;
$("#tdPlaceFiberJumper").html(result14);


var pr=$(this).attr("ows_Pole_x0020_Replace");
//var aftersplitpr=pr.split("#")
result15=parseInt(pr)+result15;
$("#tdPoleReplace").html(result15);


var vr=$(this).attr("ows_Vault_x0020_Replace");
//var aftersplitvr=vr.split("#")
result16=parseInt(vr)+result16;
$("#tdVaultReplace").html(result16);


var lr=$(this).attr("ows_Lid_x0020_Replace");
//var aftersplitlr=lr.split("#")
result17=parseInt(lr)+result17;
$("#tdLidReplace").html(result17);


var tv=$(this).attr("ows_Trim_x0020_Vegetation");
//var aftersplittv=tv.split("#")
result18=parseInt(tv)+result18;
$("#tdTrimVegetation").html(result18);


var rl=$(this).attr("ows_Retag_x0020_Line");
//var aftersplitrl=rl.split("#")
result19=parseInt(rl)+result19;
$("#tdRetagLine").html(result19);


var pus=$(this).attr("ows_Place_x0020_UG_x0020_Sign");
//var aftersplitpus=pus.split("#")
result20=parseInt(pus)+result20;
$("#tdPlaceUGSign").html(result20);


var fs=$(this).attr("ows_Fiber_x0020_Survey");
//var aftersplitfs=fs.split("#")
result21=parseInt(fs)+result21;
$("#tdFiberSurvey").html(result21);


resultdiscovered= result2+result3+result4+result5+result6+result7+result8+result9+result10+result11+result12+result13+result14+result15+result16+result17+result18+result19+result20+result21;
$("#tdTotalDiscovered").html(resultdiscovered);



                });
            }
        }); 
    
    }  
    
 function Getgridwonrep(gridnum,won)
{
//alert(gridnum); alert(won);

var query="<Query><Where> <And><Eq><FieldRef Name='Grid' /><Value Type='Lookup'>"+gridnum+"</Value> </Eq><And><Eq><FieldRef Name='Discovery_x0020_Work_x0020_Order' /><Value Type='Number'>"+won+"</Value></Eq> <Eq><FieldRef Name='Task_x0020_Type' /><Value Type='Choice'>Repair</Value></Eq> </And></And> </Where></Query>";
//alert(query);
$().SPServices({
            operation: "GetListItems",
            async: false,
            listName: "Aerial Maintenance Tasks",
            CAMLQuery: query,
            completefunc: function(xData, Status) {

                $(xData.responseXML).SPFilterNode("z:row").each(function() {
                        
            
 var cmp=$(this).attr("ows_Total_x0020_Unrepairable");
                  var aftersplitcmp=cmp.split("#")
                  result1=parseInt(aftersplitcmp[1])+result1;
                 $("#tdTotalUnrepaired").html(result1);


var pf=$(this).attr("ows_Pole_x0020_Frames");
//alert(pf);
//var aftersplitpf=pf.split("#")
//alert(pf);
result23=parseInt(pf)+result23;
$("#tdrPoleFrames").html(result23);


var rh=$(this).attr("ows_Remove_x0020_Hardware");
//var aftersplitrh=rh.split("#")
//alert(rh);
result24=parseInt(rh)+result24;
$("#tdrRemoveHardware").html(result24);


var sa=$(this).attr("ows_Set_x0020_Anchor");
//var aftersplitsa=sa.split("#")
//alert(sa);
result25=parseInt(sa)+result25;
$("#tdrSetAnchor").html(result25);


var pdg=$(this).attr("ows_Place_x0020_Guy_x0020_Down");
//var aftersplitpdg=pdg.split("#")
//alert(pdg);
result26=parseInt(pdg)+result26;
$("#tdrPlaceDownGuy").html(result26);


var pgg=$(this).attr("ows_Place_x0020_Guy_x0020_Guard");
//var aftersplitpgg=pgg.split("#")
//alert(pgg);
result27=parseInt(pgg)+result27;
$("#tdrPlaceGuyGuard").html(result27);


var ts=$(this).attr("ows_Tighten_x0020_Span");
//var aftersplitts=ts.split("#")
//alert(ts);
result28=parseInt(ts)+result28;
$("#tdrTightenSpan").html(result28);


var rs=$(this).attr("ows_Relash_x0020_Span");
//var aftersplitrs=rs.split("#")
result29=parseInt(rs)+result29;
$("#tdrRelashSpan").html(result29);


var lsl=$(this).attr("ows_Lash_x0020_Storage_x0020_Loop");
//var aftersplitlsl=lsl.split("#")
result30=parseInt(lsl)+result30;
$("#tdrLashStorageLoop").html(result30);


var rc=$(this).attr("ows_Rehang_x0020_Case");
//var aftersplitrc=rc.split("#")
result31=parseInt(rc)+result31;
$("#tdrRehangCase").html(result31);


var css=$(this).attr("ows_Cut_x0020_Splice_x0020_Strand");
//var aftersplitcss=css.split("#")
result32=parseInt(css)+result32;
$("#tdrCutSpliceStrand").html(result32);



var rrg=$(this).attr("ows_Replace_x0020_Riser_x0020_Guard");
//var aftersplitrrg=rrg.split("#")
result33=parseInt(rrg)+result33;
$("#tdrRiserGuard").html(result33);


var fr=$(this).attr("ows_Foam_x0020_Riser");
//var aftersplitfr=fr.split("#")
result34=parseInt(fr)+result34;
$("#tdrFoamRiser").html(result34);


var pfj=$(this).attr("ows_Place_x0020_Fiber_x0020_Jumper");
//var aftersplitpfj=pfj.split("#")
//alert(pfj);
result35=parseInt(pfj)+result35;
$("#tdrPlaceFiberJumper").html(result35);


var pr=$(this).attr("ows_Pole_x0020_Replace");
//var aftersplitpr=pr.split("#")
result36=parseInt(pr)+result36;
$("#tdrPoleReplace").html(result36);


var vr=$(this).attr("ows_Vault_x0020_Replace");
//var aftersplitvr=vr.split("#")
result37=parseInt(vr)+result37;
$("#tdrVaultReplace").html(result37);


var lr=$(this).attr("ows_Lid_x0020_Replace");
//var aftersplitlr=lr.split("#")
result38=parseInt(lr)+result38;
$("#tdrLidReplace").html(result38);


var tv=$(this).attr("ows_Trim_x0020_Vegetation");
//var aftersplittv=tv.split("#")
result39=parseInt(tv)+result39;
$("#tdrTrimVegetation").html(result39);


var rl=$(this).attr("ows_Retag_x0020_Line");
//var aftersplitrl=rl.split("#")
result40=parseInt(rl)+result40;
$("#tdrRetagLine").html(result40);


var pus=$(this).attr("ows_Place_x0020_UG_x0020_Sign");
//var aftersplitpus=pus.split("#")
result41=parseInt(pus)+result41;
$("#tdrPlaceUGSign").html(result41);


var fs=$(this).attr("ows_Fiber_x0020_Survey");
//var aftersplitfs=fs.split("#")
result42=parseInt(fs)+result42;
$("#tdrFiberSurvey").html(result42);



resultrepaired= result23+result24+result25+result26+result27+result28+result29+result30+result31+result32+result33+result34+result35+result36+result37+result38+result39+result40+result41+result42;
$("#tdTotalRepaired").html(resultrepaired);




                });
            }
        });


 
}     



 GetgridwonUNREP(gridnum,won)
{
var query="<Query><Where> <And><Eq><FieldRef Name='Grid' /><Value Type='Lookup'>"+gridnum+"</Value> </Eq><And><Eq><FieldRef Name='Discovery_x0020_Work_x0020_Order' /><Value Type='Number'>"+won+"</Value></Eq> <Eq><FieldRef Name='Task_x0020_Type' /><Value Type='Choice'>Repair</Value></Eq> </And></And> </Where></Query>";
alert(query);
$().SPServices({
            operation: "GetListItems",
            async: false,
            listName: "Aerial Maintenance Tasks",
            CAMLQuery: query,
            completefunc: function(xData, Status) {

                $(xData.responseXML).SPFilterNode("z:row").each(function() {
                        
     
                  var cmp=$(this).attr("ows_Total_x0020_Unrepairable");
                  var aftersplitcmp=cmp.split("#")
                  result1=parseInt(aftersplitcmp[1])+result1;
                  alert(reuslt1);
                 $("#tdTotalUnrepaired").html(result1);
                 
                 

var upf=$(this).attr("ows_Unrepairable_x0020_Pole_x0020_Fr");
//alert(upf);
resulta=parseInt(upf)+resulta;
$("#tdURPoleFrames").html(resulta);


var urh=$(this).attr("ows_Unrepairable_x0020_Remove_x0020_");
resultb=parseInt(urh)+resultb;
$("#tdURRemoveHardware").html(resultb);


var usa=$(this).attr("ows_Unrepairable_x0020_Set_x0020_Anc");
resultc=parseInt(usa)+resultc;
$("#tdURSetAnchor").html(resultc);


var updg=$(this).attr("ows_Unrepairable_x0020_Place_x0020_D");
resultd=parseInt(updg)+resultd;
$("#tdURPlaceDownGuy").html(resultd);


var upgg=$(this).attr("ows_Unrepairable_x0020_Place_x0020_G");
resulte=parseInt(upgg)+resulte;
$("#tdURPlaceGuyGuard").html(resulte);


var uts=$(this).attr("ows_Unrepairable_x0020_Tighten_x0020");
resultf=parseInt(uts)+resultf;
$("#tdURTightenSpan").html(resultf);


var urs=$(this).attr("ows_Unrepairable_x0020_Relash_x0020_");
resultg=parseInt(urs)+resultg;
$("#tdURRelashSpan").html(resultg);


var ulsl=$(this).attr("ows_Unrepairable_x0020_Lash_x0020_St");
resulth=parseInt(ulsl)+resulth;
$("#tdURLashStorageLoop").html(resulth);


var urc=$(this).attr("ows_Unrepairable_x0020_Rehang_x0020_");
resulti=parseInt(urc)+resulti;
$("#tdURRehangCase").html(resulti);


var ucss=$(this).attr("ows_Unrepairable_x0020_Cut_x0020_Spl");
resultj=parseInt(ucss)+resultj;
$("#tdURCutSpliceStrand").html(resultj);



var urrg=$(this).attr("ows_Unrepairable_x0020_Replace_x0020");
resultk=parseInt(urrg)+resultk;
$("#tdURRiserGuard").html(resultk);


var ufr=$(this).attr("ows_Unrepairable_x0020_Foam_x0020_Ri");
resultl=parseInt(ufr)+resultl;
$("#tdURFoamRiser").html(resultl);


var upfj=$(this).attr("ows_Unrepairable_x0020_Place_x0020_F");
resultm=parseInt(upfj)+resultm;
$("#tdURPlaceFiberJumper").html(resultm);


var upr=$(this).attr("ows_Unrepairable_x0020_Pole_x0020_Re");
resultn=parseInt(upr)+resultn;
$("#tdURPoleReplace").html(resultn);


var uvr=$(this).attr("ows_Unrepairable_x0020_Vault_x0020_R");
resulto=parseInt(uvr)+resulto;
$("#tdURVaultReplace").html(resulto);


var ulr=$(this).attr("ows_Unrepairable_x0020_Lid_x0020_Rep");
resultp=parseInt(ulr)+resultp;
$("#tdURLidReplace").html(resultp);


var utv=$(this).attr("ows_Unrepairable_x0020_Trim_x0020_Ve");
resultq=parseInt(utv)+resultq;
$("#tdURTrimVegetation").html(resultq);


var url=$(this).attr("ows_Unrepairable_x0020_Retag_x0020_L");
resultr=parseInt(url)+resultr;
$("#tdURRetagLine").html(resultr);


var upus=$(this).attr("ows_Unrepairable_x0020_Place_x0020_U");
results=parseInt(upus)+results;
$("#tdURPlaceUGSign").html(results);


var ufs=$(this).attr("ows_Unrepairable_x0020_Fiber_x0020_S");
resultt=parseInt(ufs)+resultt;
$("#tdURFiberSurvey").html(resultt);





                });
            }
        });
}
    
 
  
    
  function reset()
  {
 
alert("reset");
  

   $('#wd').find('option:first').attr('selected', 'selected');
    $('#gwd').find('option:first').attr('selected', 'selected');
     $('#gd').find('option:first').attr('selected', 'selected');
  //alert("cleared");
   //$('#gd').find('option:first').attr('selected', 'selected');
  Clearvariables();

  }
  
  
      
     
     
     
   
  


</script>