<?php session_start();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <title>Print GRN</title>
        <style type="text/css">
            <!--
            .companyname {
                color: #0000FF;
                font-weight: bold;
                font-size: 24px;
            }

            .com_address {
                color: #000000;
                font-weight: bold;
                font-size: 18px;
            }

            .heading {
                color: #000000;
                font-weight: bold;
                font-size: 26px;
            }

            body {
                color: #000000;
                font-size: 16px;
            }
            .style2 {
                font-size: 36px;
                font-weight: bold;
            }


            -->
        </style>
    </head>

    <body><center>
            <?php
            require_once("config.inc.php");
            require_once("DBConnector.php");
            $db = new DBConnector(); $dbinv = $db->GetConnection();
            ?>

            <table width="1000" height="428" border="0">

                <?php
                $sql_para = "Select * from invpara where COMCODE='" . $_SESSION['company'] . "'";

                $result_para = $db->RunQuery($sql_para);
                $row_para = $result_para->fetch();

                $sql = "Select * from s_crnma where REF_NO='" . $_GET["invno"] . "'";
                $result = $db->RunQuery($sql);
                $row = $result->fetch();

                $sql1 = "Select * from vendor where CODE='" . $row["C_CODE"] . "'";
                $result1 = $db->RunQuery($sql1);
                $row1 = $result1->fetch();
                
                $sql22 = "Select * from s_crntrn where REF_NO='" . $_GET["invno"] . "'";
                $result22 = $db->RunQuery($sql22);
                $row22 = $result22->fetch(); 
                
                $sql_vat = "Select SVAT,VAT,vat_no from s_salma where REF_NO='" . $_GET["invoiceno"] . "'";
                                $result_vat = $db->RunQuery($sql_vat);
                                $row_vat = $result_vat->fetch();
                
                
                $sql2 = "Select * from s_crntrn where REF_NO='" . $_GET["invno"] . "'";
                $result2 = $db->RunQuery($sql2);
                
                if (substr($row["REF_NO"], 0, 3) == "GRN"){
                    $note = "GRN";
                }else if(substr($row["REF_NO"], 0, 3) == "CAJ"){
                    $note = "CAJ";
                }
                ?>
 		
<tr>
                    <td colspan="2" scope="col"><b style='font-size:24px;'><?php
                        echo $row_para["COMPANY"];
                        ?></b></td>
                    <td scope="col">&nbsp;</td>
                    <td scope="col">&nbsp;</td>
                </tr>
                <tr>
                    <td colspan="2" scope="col"><b style='font-size:21px;'><?php
                        echo $row_para["ADD1"];
                        ?></b></td>
                    <td scope="col">&nbsp;</td>
                    <td scope="col">&nbsp;</td>
                </tr>
                <tr>
                    <td colspan="2" scope="col"><?php 
                    if($row_vat['VAT'] !=0){ 
                    echo "VAT NO - ".$row_para['VAT'];
                    } ?></td>
                    <td scope="col">&nbsp;</td>
                    <td scope="col">&nbsp;</td>
                </tr>
                <tr>
                    <td colspan="2" rowspan="3" scope="col"><span class="heading">
                        <?php if ($note == "GRN") { echo "Good Return Note";}
                        else if($note == "CAJ") {echo "Commercial Adjacment Note";}?></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<?php if($row22['VAT'] == "1") { echo "TAX CREDIT NOTE";}?></td>
                    <td scope="col">&nbsp;</td>
                    <td scope="col">&nbsp;</td>
                </tr>
                <tr>
                    <td scope="col" colspan='2'><?php if($note == "GRN") { echo "GRN No : ". $row['REF_NO'];}
                    else if($note == "CAJ"){ echo "CAJ No : ". $row['REF_NO'];}?></td>
                   
                </tr>
                <tr>
                    <td scope="col" colspan='2'><?php if($note == "GRN") {echo "GRN Date : ".$row["SDATE"];} 
                    else if($note == "CAJ"){ echo "CAJ Date : ". $row['REF_NO'];}
                    ?></td>
                    <td scope="col"></td>
                </tr>
                <tr>
                    <td width="196">Sales Reference - </td>
                  <td width="457"><?php echo $row["SAL_EX"]; ?></td>
                  <td width="101">Invoice No</td>
                  <td width="136"><?php echo $_GET["invoiceno"]; ?></td>
              </tr>
                <tr>
                    <td><?php if($note == "GRN") {echo "Return By -";} else if ($note == "CAJ"){echo "Customer -";}?></td>
                    <td><?php echo $row["C_CODE"] . " - " . $row1["NAME"]; ?></td>
                    <td>Invoice Date</td>
                    <td><?php echo $row["DDATE"]; ?></td>
                </tr>
                <tr>
                    <td>&nbsp;</td>
                    <td><?php echo $row1["ADD1"] . ", " . $row1["ADD2"]; ?></td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                </tr>
                <tr>
                    <td>&nbsp;</td>
                    <td><?php 
                    if($row_vat["VAT"] !=0){
                        echo "Customer Vat No - ".$row_vat["vat_no"]  ;
                    }
                   
                    ?></td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                </tr>
				 
                <tr>
                    <td colspan="4">
                        <table width="900" border="1" cellpadding="0" cellspacing="0"><tr><td colspan="3">
                                    <table width="900" border="1" cellpadding="0" cellspacing="0">
                                        <tr>
                                            <th width="102" scope="col" align="left">Stk No</th>
                                            <th width="350" scope="col" align="left">Description</th>
                                            <th width="98" scope="col" align="left">Part No</th>
                                            <th width="117" scope="col" align="right">Rate</th>
                                            <th width="79" height="22" align="right">Qty</th>
                                            <th width="74" scope="col" align="right">D1%</th>
                                            <th width="74" scope="col" align="right">D2%</th>
                                            <th width="74" scope="col" align="right">D3%</th>
                                            <th width="74" scope="col" align="right">CAJ%</th>
                                            <th width="150" scope="col" align="right">Amount</th>
                                        </tr>
                                        <?php
                                        while ($row2 = $result2->fetch()) {

                                            echo "<tr>
        <td align=\"left\">" . $row2["STK_NO"] . "</td>
        <td align=\"left\">" . $row2["DESCRIPT"] . "</td>";

                                            $sql_stk = "Select * from s_mas where STK_NO='" . $row2["STK_NO"] . "'";
                                            $result_stk = $db->RunQuery($sql_stk);
                                            $row_stk = $result_stk->fetch();

                                            echo "<td  align=\"left\">" . $row_stk["PART_NO"] . "</td>";
                                            	if ($row_vat["VAT"]=="1"){
                                                        $rate=$row2["PRICE"]+$row2["PRICE"]*$row["GST"]/100;
                                              } else {
                                                    $rate=$row2["PRICE"];
                                              }  
                                               $rate=$row2["PRICE"];
                                              
                                            echo "<td align=\"right\">" . number_format($rate, 2, ".", ",") . "</td>
        <td align=\"right\">" . number_format($row2["QTY"], 0, ".", ",") . "</td>
        <td align=\"right\">" . $row2["DIS_P"] . "</td>
		<td align=\"right\">" . $row2["DIS_P2"] . "</td>
		<td align=\"right\">" . $row2["DIS_P3"] . "</td>
		<td align=\"right\">" . $row2["sp_dr"] . "</td>";

                                            if ($row2["VAT"] == '1') {
                                                //if (is_null($row2["DIS_P"])==false) {
                                                $amount = ($row2["QTY"] * $row2["PRICE"] - $row2["QTY"] * $row2["PRICE"] * $row2["DIS_P"] / 100);
                                                $amount = $amount - ($amount * $row2["DIS_P2"] / 100);
                                                $amount=$amount - ($amount * $row2["DIS_P3"] / 100);
                                                $amount=$amount - ($amount * $row2["sp_dr"] / 100);
                                                
                                                $amount_x = ($row2["QTY"] * $rate - $row2["QTY"] * $rate * $row2["DIS_P"] / 100);
                                                $amount_x = $amount_x - ($amount_x * $row2["DIS_P2"] / 100);
                                                $amount_x=$amount_x - ($amount_x * $row2["DIS_P3"] / 100);
                                                $amount_x=$amount_x - ($amount_x * $row2["sp_dr"] / 100);
                                                //} else {
                                                //	$amount=$row2["QTY"]*$row2["PRICE"]/(1+ $row["GST"]/100);
                                                //}	
                                                
                                                $totAmount += $amount;
                                            echo " <td align=right>" . number_format($amount_x, 2, ".", ",") . "</td>
     
      </tr>";
                                            } else {
                                                if (is_null($row2["DIS_P"]) == false) {
                                                    $amount = $row2["QTY"] * $row2["PRICE"] - $row2["QTY"] * $row2["PRICE"] * $row2["DIS_P"] / 100;
                                                    $amount = $amount - ($amount * $row2["DIS_P2"] / 100);
                                                    $amount = $amount - ($amount * $row2["DIS_P3"] / 100);
                                                    $amount = $amount - ($amount * $row2["sp_dr"] / 100);
                                                } else {
                                                    $amount = $row2["QTY"] * $row2["PRICE"];
                                                }
                                                
                                                $totAmount += $amount;
                                            echo " <td align=right>" . number_format($amount, 2, ".", ",") . "</td>
     
      </tr>";
                                            }
                                            
                                        }
                                        ?>
                                    </table></td></tr></table><br />
                        <table width="900" border="0" cellpadding="0" cellspacing="0">
                            <tr>
                                <td  width="600">&nbsp;</td>
                                <?php
                                
                                
                                /*
                                $sql_invpara = "SELECT * from invpara";
                                $result_invpara = $db->RunQuery($sql_invpara);
                                $row_invpara = $result_invpara->fetch();
                                */
                                
                                $txtvata ="";
                                $vatRate = $row["GST"];
                                if ($row_vat["SVAT"] > 0) {
//                                    $txtvat = "SVAT " . $row_invpara["vatrate"] . "%: ";
                                    $txtvat = "SVAT " . $vatRate . "%: ";
                                    $txtvata = $_GET["tax"];
                                } else {
                                    if ($_GET["tax"] > 0) {
//                                        $txtvat = "VAT " . $row_invpara["vatrate"] . "%: ";
                                        $txtvat = "VAT " . $vatRate . "%: ";
                                        $txtvata = $_GET["tax"];
                                    }
                                }
                                
                                
                                $vatVal = 0;    
                                    if ($txtvata !=="") {  
                                    $vatVal = $totAmount/(100+$vatRate)*$vatRate;
                                    
                                } 
                                
                                ?>  
                            <tr>
                                <td colspan="2">&nbsp;</td>
                                <td align="right"><b><?php  
                                $invTot = $totAmount ;
                                echo number_format($invTot-$vatVal, 2, ".", ","); 
                                ?></b></td>
                            </tr>
                                <td colspan="2" style='text-align:right;'><?php echo $txtvat; ?></td>
                                <td align="right"><?php 
                                 
                                    if ($vatVal >0) {  
                                    echo number_format($vatVal, 2, ".", ","); 
                                } ?></td>
                            </tr>

                            <tr>
                                <td colspan="2">&nbsp;</td>
                                <td align="right"><b><?php 
//                                echo number_format($_GET["invtot"], 2, ".", ","); 
                                $invTot = $totAmount ;
                                echo number_format($invTot, 2, ".", ","); 
                                ?></b></td>
                            </tr>
                        </table></td>
                </tr>
                <tr>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td><b><?PHP if($row["CANCELL"]=="1") echo "CANCELED";?></b></td>
                </tr>
                <tr>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                </tr>
                <tr>
                    <td>_______________________</td>
                    <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;________________________</td>
                     
                    <td>_________________</td>
              </tr>
                <tr>
                    <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Entered By</td>
                    <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Checked by</td>
                     
                    <td>&nbsp;Authorized by</td>
                </tr>
                <tr>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                </tr>
            </table>
</body>
</html>


