Liczba dni zamowienia

by Torwan

HTML

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<table id="table_to_xls" class="table">
						<thead>
							<tr>
							<th class="nagl" colspan="24">Parametry wybrane - data od: <span>2016-07-11 00:00:00</span>, data do: <span>2016-07-18 23:59:59</span></th>
							</tr>
							<tr>
							    <th class="col1">L.p.</th>
							    <th class="col2">Nazwa</th>
							    <th class="col3">Nr zamówienia</th>
							    <th class="col4">Termin zamówienia od</th>
							    <th class="col5">Termin zamówienia do</th>
							    <th class="col6">Ilość</th>
							</tr>
						</thead>
						<tbody>
																							<tr data-id="4" data-terminod="2016-07-11 00:00:00" data-termindo="2016-07-29 23:59:59" data-zamowienie="ZMK-91" data-nazwa="DIETA OPTIMAL 1000 kcal - 5 dni" data-wybrdataod="2016-07-11 00:00:00" data-wybrdatado="2016-07-18 23:59:59">
									<td class="col1">1</td>
									<td class="col2">DIETA OPTIMAL 1000 kcal - 5 dni</td>
									<td class="col3">ZMK-91</td>
									<td class="col4">2016-07-11</td>
									<td class="col5">2016-07-29</td>
									<td id="colilosc" class="col6">0</td>
								</tr>
																								<tr data-id="4" data-terminod="2016-07-18 00:00:00" data-termindo="2016-08-12 23:59:59" data-zamowienie="ZMK-109" data-nazwa="DIETA OPTIMAL 1000 kcal - 5 dni" data-wybrdataod="2016-07-11 00:00:00" data-wybrdatado="2016-07-18 23:59:59">
									<td class="col1">2</td>
									<td class="col2">DIETA OPTIMAL 1000 kcal - 5 dni</td>
									<td class="col3">ZMK-109</td>
									<td class="col4">2016-07-18</td>
									<td class="col5">2016-08-12</td>
									<td id="colilosc" class="col6">0</td>
								</tr>
																								<tr data-id="5" data-terminod="2016-07-07 00:00:00" data-termindo="2016-07-13 23:59:59" data-zamowienie="ZMK-84" data-nazwa="DIETA OPTIMAL 1000 kcal - 7 dni" data-wybrdataod="2016-07-11 00:00:00" data-wybrdatado="2016-07-18 23:59:59">
									<td...

CSS

table {font-size:8px;}

JavaScript

//obliczanie ilości dni czyli ilości produktów w podanym zakresie dat
		$('table tbody tr').each(function(){
			var datin1 = 0;
		    var datin2 = 0;
		    var datcompare1 = '';
		    var datcompare2 = '';
		    var d1 = $(this).attr('data-terminod');
		    var d2 = $(this).attr('data-termindo');
		    var dw1 = $(this).attr('data-wybrdataod');
		    var dw2 = $(this).attr('data-wybrdatado');
		  	var datad1 = new Date(d1);
		    var datad2 = new Date(d2);
		    var datadw1 = new Date(dw1);
		    var datadw2 = new Date(dw2);
		    var coltemp1 = $(this).find('#temp1');
		    var coltemp2 = $(this).find('#temp2');
		    var colilosc = $(this).find('#colilosc');
		    var lp = $(this).find("td:first").text();
		    var oneDay = 24*60*60*1000;
		    var iloscdnizamowienia = Math.round(Math.abs((datad2.getTime() - datad1.getTime())/(oneDay)));
		    if (datad1 < datadw1) {
				var datcompare1 = 'mniejsza';
				var datin1 = datadw1;
		    } else if (datad1 > datadw1) {
				var datcompare1 = 'wieksza';
				var datin1 = datad1;
		    } else {
				var datcompare1 = 'rowna';
				var datin1 = datad1;
		    }
		    if (datad2 < datadw2) {
				var datcompare2 = 'mniejsza';
				var datin2 = datad2;
		    } else if (datad2 > datadw2) {
				var datcompare2 = 'wieksza';
				var datin2 = datadw2;
		    } else {
				var datcompare2 = 'rowna';
				var datin2 = datad2;
		    }
        var v = $(this).attr('data-nazwa');
        if (v !== undefined) {
            if (v.indexOf('5 dni')!=-1) {
              var iloscdnisum = calcBusinessDays(datin1, datin2)+1;        
            } else {
            var iloscdnisum = Math.round(Math.abs((datin2.getTime() - datin1.getTime())/(oneDay)));
            }
        }        
        $(colilosc).text(iloscdnisum);
		    $(this).attr('data-comparepoczatek', dw1+' - '+d1+' | '+datcompare1);
		    $(this).attr('data-comparekoniec', dw2+' - '+d2+' | '+datcompare2);
		    $(this).attr('data-datyzamowienia', d1+' - '+d2)
		   ...