<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>Seller List</title>
<style>
	td, th {border-left: 1px solid #DBDBDB; vertical-align: top;}
	#headq {background: green; color: aliceblue;}
	.wd{table-layout: fixed; width: 100%;}
</style>
</head>

<body>
	<?php
 		
		error_reporting(0);
 		include "pagination.php";   
		include "functions/dblink.php";	   

		$find = "ทั้งหมด";
		$condition = 1;	
		
		//กรณี chkbox แล้วโพสกลับขึ้นมา	
		$sql="SELECT * FROM delv001 WHERE DLOCK!=1 OR DLOCK IS NULL ORDER BY DDATE DESC,DNO DESC";
		$result=mysqli_query($con,$sql);
		
		$rs = page_query($con, $sql, 19);
	
		$first = page_start_row();
		$last = page_stop_row();
		$total = page_total_rows();
		if($total == 0) {$first = 0;}	
			
		//<a href='form.php?action=insert'>เพิ่มข้อมูล</a>
		echo '<form method="post">';
		echo "<table class='wd'><caption>" ;     //อ่านข้อมูล result set มาแสดงในรูปแบบตาราง
		echo "<h1>รายการใบส่งสินค้า สำหรับออกใบแจ้งหนี้</h1>";
		echo "<h1>(Delivery List for Invoice)</h1>";
		echo "<span id=\"result\">รายการที่ : $first - $last จากทั้งหมด $total</span></caption>";				
					 
		echo "<tr id='headq' >";      //ส่วนหัวตาราง(ชื่อฟิลด์)
		echo "<th width='4%'>Act</th>";
		echo "<th width='9%'>Delv.No.</th>";
		echo "<th width='15%'>name</th>";
		echo "<th width='8%'>ส่วนลด</th>";
		echo "<th width='12%'>Proj. Name</th>";
		echo "<th width='25%'>รายการ</th>";
		echo "<th width='3%'>#</th>";
		echo "<th width='6%'>@</th>";
	    echo "<th width='8%'>รวม</th>";
		echo "<th width='10%'>ทั้งสิ้น</th>";
		echo "</tr>";		
	 
		while($data=mysqli_fetch_array($rs))
		{			
			echo "<tr>";
			//echo '<td><input type="checkbox" name="NO[]" value=" ' .$data['NO'].' "></td>';
			echo "<td><a href=\"actionController.php?
			                    action=seller/addInvoiceAction&no={$data['NO']}&dno={$data['DNO']}&dlost={$data['DLOST']}&
								actionIs=insert\">[เพิ่ม]</a>
					</td>";
			
				$t1=$data["DOQTY1"]*$data["DOSLEPRC1"];
				$t2=$data["DOQTY2"]*$data["DOSLEPRC2"];
				$t3=$data["DOQTY3"]*$data["DOSLEPRC3"];
				$t4=$data["DOQTY4"]*$data["DOSLEPRC4"];
				$t5=$data["DOQTY5"]*$data["DOSLEPRC5"];
				$t6=$data["DOQTY6"]*$data["DOSLEPRC6"];
				$t7=$data["DOQTY7"]*$data["DOSLEPRC7"];
				$t8=$data["DOQTY8"]*$data["DOSLEPRC8"];
				$t9=$data["DOQTY9"]*$data["DOSLEPRC9"];
				$t10=$data["DOQTY10"]*$data["DOSLEPRC10"];
				$total=$t1+$t2+$t3+$t4+$t5+$t6+$t7+$t8+$t9+$t10;

			if($data["DOC_DISC"]<=100){	
				$s1=$t1-($t1*$data["DOC_DISC"]/100);
				$s2=$t2-($t2*$data["DOC_DISC"]/100);
				$s3=$t3-($t3*$data["DOC_DISC"]/100);
				$s4=$t4-($t4*$data["DOC_DISC"]/100);
				$s5=$t5-($t5*$data["DOC_DISC"]/100);
				$s6=$t6-($t6*$data["DOC_DISC"]/100);
				$s7=$t7-($t7*$data["DOC_DISC"]/100);
				$s8=$t8-($t8*$data["DOC_DISC"]/100);
				$s9=$t9-($t9*$data["DOC_DISC"]/100);
				$s10=$t10-($t10*$data["DOC_DISC"]/100);
				
				$final=$s1+$s2+$s3+$s4+$s5+$s6+$s7+$s8+$s9+$s10;
				
			}else{
				$final=$total-$data["DOC_DISC"];
			}

			echo "<td>$data[DNO]</td>";
			echo "<td>$data[DOC_NAME]</td>";
			echo "<td class=rt>".number_format($data["DOC_DISC"],2)."</td>";	
			//echo "<td>$data["DOC_ADRS"]</td>";
			echo "<td>$data[DOPJNAME]</td>";
			echo "<td>$data[DOPDNAME1]</td>";

	if($data['DLOST']=='Dwn'){
		echo "<td></td>";
		echo "<td>".number_format($data['DOTERM1'])."%</td>";
		echo "<td>DwnP</td>";
		echo "<td class=rtq style='color:red;'>".number_format($final*$data['DOTERM1']/100,2)."</td>";
	}else{	

			echo "<td class=rt>".number_format($data["DOQTY1"])."</td>";
			echo "<td class=rt>".number_format($data["DOSLEPRC1"])."</td>";
			if($data["DOC_DISC"]<=100){
				echo "<td class=rt>".number_format($s1,2)."</td>";
			}else{
				echo "<td class=rt>".number_format($t1,2)."</td>";
			}
			
			echo "<td class=rt style='color:red; font-weight: bold;'>".number_format($final,2)."</td>";
			echo "<tr>";
			
			for($i=2;$i<=10;$i++){
				$blank=NULL;
				if ($data["DOPDNAME{$i}"] != "" OR $data["DOQTY{$i}"] != 0 OR $data["DOQTY{$i}"] != is_null($blank)){
					echo "<td></td>";
					//echo "<td style='width:8%;'></td>";
					echo "<td></td>";
					echo "<td></td>";
					echo "<td></td>";
					echo "<td></td>";
					echo "<td>".$data["DOPDNAME{$i}"]."</td>";
					echo "<td class=rt>".number_format($data["DOQTY{$i}"])."</td>";
					echo "<td class=rt>".number_format($data["DOSLEPRC{$i}"])."</td>";
					if($data["DOC_DISC"]<=100){
						echo "<td class=rt>".number_format($s["{$i}"],2)."</td>";
					}else{
						echo "<td class=rt>".number_format($t["{$i}"],2)."</td>";
					}

					echo "<tr>";
				}
			}
			
			echo "<tr>";
			echo "<th width=' 4%'><hr color='#DBDBDB' size='.1'></th>";
			echo "<th width=' 9%'><hr color='#DBDBDB' size='.1'></th>";
			echo "<th width='15%'><hr color='#DBDBDB' size='.1'></th>";
			echo "<th width=' 8%'><hr color='#DBDBDB' size='.1'></th>";
			echo "<th width='12%'><hr color='#DBDBDB' size='.1'></th>";
			echo "<th width='25%'><hr color='#DBDBDB' size='.1'></th>";
			echo "<th width=' 3%'><hr color='#DBDBDB' size='.1'></th>";
			echo "<th width=' 6%'><hr color='#DBDBDB' size='.1'></th>";
			echo "<th width=' 8%'><hr color='#DBDBDB' size='.1'></th>";
			echo "<th width='10%'><hr color='#DBDBDB' size='.1'></th>";
			echo "</tr>";
		}
	}




		echo "</table>";
		echo "</form>";
		
		//ต่อไปให้แสดงหมายเลขเพจเฉพาะเมื่อมีมากกว่า 1 เพจ 
		if(page_total() > 1)
	    { 	
			echo '<p id="pagenum">';
			page_echo_pagenums();
			echo '</p>';
	    }
		mysqli_close($con);
	?>
</body>
</html>