System: Windows NT WINDOWS18 10.0 build 17763 (Windows Server 2016) AMD64 | User: IWPD_3544(appclien)

Path: D:\Inetpub\vhosts\appclients.in\fruits-vegitables.nmvm.org\admin

[Back to List]
<?php
include('config.php');
//mysqli_query($con,"update cart set status='Delivered' where id='$_REQUEST[id]'") or die(mysqli_error());
$sel_d=mysqli_query($con,"select * from cart where id='$_REQUEST[id]'") or die(mysqli_error());
$data=mysqli_fetch_array($sel_d);
extract($data);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="Mosaddek">
<meta name="keyword" content="">
<link rel="shortcut icon" href="img/favicon.png">
<title><?php include("include/title.php")?> | Invoice Details</title>
<!-- Bootstrap core CSS -->
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/bootstrap-reset.css" rel="stylesheet">
<!--external css-->
<link href="assets/font-awesome/css/font-awesome.css" rel="stylesheet" />
<link href="assets/advanced-datatable/media/css/demo_page.css" rel="stylesheet" />
<link href="assets/advanced-datatable/media/css/demo_table.css" rel="stylesheet" />
<!-- Custom styles for this template -->
<link href="css/style.css" rel="stylesheet">
<link href="css/style-responsive.css" rel="stylesheet" />
</head>
<body style="overflow-x: hidden;">
<!--main content start-->
<section class="panel">
  <div class="row" style="padding: 20px;margin-left: 20%;margin-right: 20%;">
    <table width="100%" border="1" style="border: #eee solid;
    border-radius: 10px;font-size: 13px;">
      <tbody>
        <tr>
          <td colspan="6" style="padding: 3px 18px 10px;" align="center"><strong>INVOICE</strong></td>
        </tr>
        <tr>
          <td colspan="3" rowspan="3" style="padding: 4px 8px 10px; text-transform: uppercase; //width:50%;">          <b>EAT10</b><br>
            Address: Gurgaon DLF Phase 1 - 122002<br>
            Contact : +91 - 98910 62585 <br>
            E-mail : support@eat10.com<br>
            Web : www.eat10.com<br></td>
          <td style="padding: 4px 8px 10px;" colspan="2">Invoice No : <?php echo $_REQUEST['id'].str_replace("SM","",$code_id)?><br>Date : <?php echo date('d-m-y h:i:a',$order_date)?> </td>
          <td style="padding: 4px 8px 10px;">&nbsp;</td>
        </tr>
        <tr>
          <td colspan="5" rowspan="1"  valign="top" style="padding: 4px 8px 10px;">Buyer's Order No. <?php echo $code_id?></td>
        </tr>
        <tr>
          <td colspan="5" rowspan="3" style="padding: 4px 8px 10px;" valign="top">GST No: 07GHQPS9282B1ZN </td>
        </tr>
        <tr> </tr>
        <tr> </tr>
        <tr> </tr>
        <tr> </tr>
        <tr>
          <td style="padding: 4px 8px 10px; text-transform: uppercase;" colspan="3">Consignee :<br>
          <?php 
		   $s_qry=mysqli_query($con,"select * from cart where reg_id='$reg_id' AND code_id='$code_id'") or die(mysqli_error());
		   $d_data=mysqli_fetch_array($s_qry);?>
            <?php echo $d_data['bll_name']?><br>
            <?php echo $d_data['bll_addr']?>,<br>
            <?php echo $d_data['bll_city']?> - <?php echo $d_data['bll_pin']?><br>
            <?php echo $d_data['bll_state']?><br>
            Contact : <?php echo $d_data['bll_mob']?><br>
            Email ID : <?php echo $d_data['bll_email']?><br></td>
          <td colspan="3" valign="top" style="padding: 4px 8px 10px;">Buyer(if other than consignee) Notify</td>
        </tr>
        <!--<tr>
          <td valign="top" style="padding: 4px 8px 10px;" rowspan="2">Pre carriage by :<br>
            Vcssel/Flight No.:
            
            S/F</td>
          <td colspan="3" valign="top" style="padding: 4px 8px 10px;">Place of receipt by pre carrier<br>
            <strong style="text-transform:uppercase"><?php echo $d_data['bll_country']?></strong></td>
          <td valign="top" style="padding: 4px 8px 10px;" rowspan="2">Country</td>
          <td valign="top" style="padding: 4px 8px 10px;text-transform:uppercase" rowspan="2"><strong><?php echo $d_data['bll_country']?></strong></td>
        </tr>
        <tr>
          <td  colspan="3" valign="top" style="padding: 4px 8px 10px;">Port of Loading<br>
            IGI AIR PORT, NEW DELHI</td>
        </tr>-->
        <tr>
          <td valign="top" style="padding: 4px 8px 10px;">Port of Discharge:</td>
          <td colspan="3" valign="top" style="padding: 4px 8px 10px;">Final Distination<br>
            DOOR DELIVERY</td>
          <td valign="top" style="padding: 4px 8px 10px;" colspan="2">Payment Type <strong><?php 
		  //select product details
		  //$pro_details = mysqli_query($con,"select * from product where id='$product_id'");
		  //$paymentSts = mysqli_fetch_array($pro_details); 
		   if(!empty($d_data['transID'])) echo "Online";else echo "COD";?></strong></td>
        </tr>
        <tr>
          <td colspan="6" style="padding: 4px 8px 10px;">Description of Goods</td>
        </tr>
        <tr>
          <td colspan="6"><table width="100%" border="1" style="border: #eee solid;
    border-radius: 10px;font-size: 13px;" cellpadding="5" cellspacing="5">
              <tr>
                <td>S.N.</td>
                <td>Product Name</td>
                <td>Price</td>
                <td>Quantity</td>
                <td>Amount</td>
              </tr>
              <?php $i=1; $tot_priceIS=0;
			  $order_qry=mysqli_query($con,"select * from cart where reg_id='$reg_id' AND code_id='$code_id'") or die(mysqli_error());
			  while($row=mysqli_fetch_array($order_qry)){
				  $pro_qry=mysqli_query($con,"select * from product where id='$row[product_id]'") or die(mysqli_error());
				  $pro_data=mysqli_fetch_array($pro_qry);
		          $price = $row['Color'];
				  ?>
              <tr>
                <td><?php echo $i ?></td>
                <td><?php echo $pro_data['name'];
				     if(!empty($row['Size']))echo "<br>".$row['Size'];
				?></td>
                <td><?php echo $price?></td>
				<td><?php echo $row['quantity'] ?></td>
                <td><?php echo $price*$row['quantity']?></td>
              </tr>
              <?php  $tot_priceIS=$tot_priceIS+$price*$row['quantity'];
			  $i++;
			  }?>
			  
			  <tr>
                <td colspan="3">&nbsp;</td>
                <td><strong>Shipping Charge</strong></td>
                <td><?php echo $tot_shipping_charge?>/-</td>
              </tr>
              <tr>
                <td colspan="3">&nbsp;</td>
                <td><strong>Total</strong></td>
                <td><?php $tot_price = $tot_priceIS+$tot_shipping_charge; echo $tot_price."/-";?> </td>
              </tr>
            </table></td>
        </tr>
        <tr>
          <td colspan="5" style="padding: 4px 8px 10px;">Amount Chargeable: 
		  <?php
   //Converting Currency Numbers to words currency format
   $number = $tot_price;
   $no = round($number);
   $point = round($number - $no, 2) * 100;
   $hundred = null;
   $digits_1 = strlen($no);
   $i = 0;
   $str = array();
   $words = array('0' => '', '1' => 'one', '2' => 'two',
    '3' => 'three', '4' => 'four', '5' => 'five', '6' => 'six',
    '7' => 'seven', '8' => 'eight', '9' => 'nine',
    '10' => 'ten', '11' => 'eleven', '12' => 'twelve',
    '13' => 'thirteen', '14' => 'fourteen',
    '15' => 'fifteen', '16' => 'sixteen', '17' => 'seventeen',
    '18' => 'eighteen', '19' =>'nineteen', '20' => 'twenty',
    '30' => 'thirty', '40' => 'forty', '50' => 'fifty',
    '60' => 'sixty', '70' => 'seventy',
    '80' => 'eighty', '90' => 'ninety');
   $digits = array('', 'hundred', 'thousand', 'lakh', 'crore');
   while ($i < $digits_1) {
     $divider = ($i == 2) ? 10 : 100;
     $number = floor($no % $divider);
     $no = floor($no / $divider);
     $i += ($divider == 10) ? 1 : 2;
     if ($number) {
        $plural = (($counter = count($str)) && $number > 9) ? 's' : null;
        $hundred = ($counter == 1 && $str[0]) ? ' and ' : null;
        $str [] = ($number < 21) ? $words[$number] .
            " " . $digits[$counter] . $plural . " " . $hundred
            :
            $words[floor($number / 10) * 10]
            . " " . $words[$number % 10] . " "

            . $digits[$counter] . $plural . " " . $hundred;
     } else $str[] = null;
  }

  $str = array_reverse($str);
  $result = implode('', $str);
  $points = ($point) ?
    "." . $words[$point / 10] . " " . 
          $words[$point = $point % 10] : '';
  echo "<b>".$result . "Rupees  Only"; if(!empty($points))echo  $points." Paise";echo "</b>";
 ?> 
 <br>
            Declaration:<br>
            <br>
            <br>
            <br>
            We declare that this invoice shows the actual price of the goods</td>
          <td colspan="1" style="padding: 4px 8px 10px;">FOR<br>
            <br>
            <br>
            <br>Authorized Signatory</td>
        </tr>
        
      </tbody>
    </table>
    <center>
      <input type="button" value="Print" onClick="window.print()" style="margin-top:20px" />
    </center>
  </div>
</section>
<!--main content end-->
</body>
</html>