invisio v2.0

<!DOCTYPE html>
<html lang="ar">
<meta charset="utf-8">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>INVOICE</title>
    <head>
    
    <script type="text/javascript">
<!--
/*var message="";
function clickIE() {if (document.all) {(message);return false;}}
function clickNS(e) {if
(document.layers||(document.getElementById&&!document.all)) {
if (e.which==2||e.which==3) {(message);return false;}}}
if (document.layers)
{document.captureEvents(Event.MOUSEDOWN);document.onmousedown=clickNS;}
else{document.onmouseup=clickNS;document.oncontextmenu=clickIE;}

document.oncontextmenu=new Function("return false");

if(e.ctrlKey && e.shiftKey && e.keyCode == 'C'.charCodeAt(0)){
     return false;
    }      
 }*/
</script>
    
    
    <script type="text/javascript">
       window.onafterprint = window.close;
       window.print();
      </script>
        
        <style>
            table {
                border-spacing: 3px;
                padding:2px;
            }
        </style>
        <script>
/*            function printpage() {
                window.print();
            }
*/        </script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<style>
@page {
    size: A4;
    margin: 13px !important;
    
}
@media print {
  #footer {
    position:fixed;
    margin-left:-0.75%;
    bottom:0;
  }
  body {-webkit-print-color-adjust: exact; page-break-after:always;}
  .noprint {display:none;}
  #tables
  {
    padding-left:100px;
    padding-right:100px;  
  }
}

@media print {
   table {
        page-break-inside: auto;
      }
      tr{
        page-break-inside: avoid;
        page-break-after: auto;
      }
      img-container{
        page-break-inside: avoid;
        page-break-after: auto;
      }
     /* #sme{display: block; width: 100%; height: 100%;page-break-inside: avoid;}      */
      
}

#container {
  margin-bottom: 2em;
  min-height: 100%;
  clear: both;
  padding: 0 2em;
  text-align: justify;
  padding-left:100px;
  padding-right:100px;
}

</style>
    </head>
    <body style='color:#336;font-size:11px; '>
        <?php

$cid = $_GET['cid'];
        
        $totpay = '0.000';
        
        include('config.php');
        include('example.php');
        
        $results = $js->prepare('SELECT * FROM `invoiced` WHERE cust = :cid ');
        $results->execute(array(':cid' => $cid));
          
        while($rows = $results->fetch(PDO::FETCH_ASSOC))
          {
                  $id = $rows['id'];
                $invid = $rows['invid'];
                $descr = $rows['descr'];
                $invamount = $rows['invamount'];
                $invdate = $rows['invdate'];
                $currency = $rows['currency'];
          }
          
          $duedate =  date('d-m-Y', strtotime($invdate. ' + 2 days - 1 day'));
          /*$duedate =  date('d-m-Y', strtotime($invdate. ' + 31 days - 1 day'));*/
          
          $qedate = date('d-m-Y', strtotime($invdate));
        
        $i = 1;
        
        $resultq = $js->prepare('SELECT * FROM `invoicepayments` WHERE invoiceid = :id');
        $resultq->execute(array(':id' => $id));
		$cc = $resultq->rowCount();
		
        while($rowq = $resultq->fetch(PDO::FETCH_ASSOC))
        {
            $pay = $rowq['payamount'];
            $totpay += $pay;
            
            $pcurrency = $rowq['currency'];
        }
		
		$balance = $invamount - $totpay;
		
        if($balance == '' && $cc == '0')
        {
            $balance = $invamount;    
        }
        if($pcurrency == '')
        {
            $pcurrency = $currency;    
        }
            
        $result = $js->prepare('SELECT * FROM `customer_entry` WHERE `id` = :cid');
        $result->execute(array(':cid' => $cid));
        
        while($row = $result->fetch(PDO::FETCH_ASSOC))
                                        {
                                            $compname = $row['companyname'];
                                            $custname = $row['custname'];
                                            $custid = $row['custid'];
                                            $resultid = mb_substr($custid, 3);
                                            $phone = $row['phone'];
                                            $email = $row['email'];
                                            $address = $row['address'];
                                            $location = $row['location'];
                                            $pdate = date('d-m-Y', strtotime($row['plannningdate']));
                                            $days = $row['daysplanning'];
                                            $todate = date('d-m-Y', strtotime($pdate.' + '.$days.' days - 1 day'));
                                        }

$result2 = $js->prepare('SELECT * FROM `clients` WHERE `compid` = :client');
                $result2->bindParam(':client', $client);
                $result2->execute();
                while($row2 = $result2->fetch(PDO::FETCH_ASSOC)) {
                    //$contact_person = $row2['contact_person'];
                    
                    $crno = $row2['crno'];
                    $contact = $row2['contact_person'];
                    $compaddr = $row2['compaddr'];
                    if($client == '1409202273')
                    {
                        $contact = $row2['comptele'];
                    }    
                    $comploc = $row2['comploc'];
                    $results = $js->prepare('SELECT * FROM `locations` WHERE id = :comploc ');
                    $results->execute(array(':comploc' => $comploc));
                      
                      while($rows = $results->fetch(PDO::FETCH_ASSOC))
                        {
                           $lid = $rows['id'];
                           $locname = $rows['loc_name'];
                        }
                        if($locname == '')
                        {
                            $locname = $comploc;    
                        }
                        $clientvat = $row2['vatno'];
                }

?>
<meta charset="utf-8" />
        <title><?php echo $custname?> - PROFORMA INVOICE FOR <?php echo strtoupper($descr); ?> </title>
<script>
function myFunction() {
    window.print();
}
</script>
<style type="text/css" media="print">

body {
 /* zoom:75%;*/ /*or whatever percentage you need, play around with this number*/
}

</style>

@media print {
    
    table.paging thead td, table.paging tfoot td {
        height: .5in;
    }
footer{
    position: fixed;
}
    footer {
        bottom: 0;
    }
    .noprint {display:none;}
}
</style>

</table>
  </tfoot>

<tr>
            
            <td align="center" style='width:32%;text-align:center;'><span style='font-weight:bold;'><h2>PROFORMA INVOICE</h2></span></td>
            
        </tr>
        </table>
        <table align="left" style="margin-top:-20px;">
        
        <tr>
            <td>Company Name</td>
            <td>:</td>
            <td><?php echo $compname?></td>
        </tr>
        <tr>
            <td>Attention</td>
            <td>:</td>
            <td><?php echo $custname?></td>
        </tr>
        <tr>
            <td>Location</td>
            <td>:</td>
            <td><?php echo strtoupper($location)?></td>
        </tr>
        <tr>
            <td>Phone Number</td>
            <td>:</td>
            <td><?php echo $phone?></td>
            
        </tr>  
        </table>
        <table align="right" style="margin-top:-20px;">
        <tr>
            <td>Invoice No</td>
            <td>:</td>
            <td><?php echo $invid?></td>
        </tr>
        <tr>
            <td>Issue Date</td>
            <td>:</td>
            <td><?php echo $qedate?></td>
        </tr>
        <tr>
            <td>Due Date</td>
            <td>:</td>
            <td><?php echo $duedate?></td>
        </tr>
        <tr>
            <td>Travel Dates</td>
            <td>:</td>
            <td><?php echo $pdate?> to <?php echo $todate?></td>
        </tr>
        </table>
        
        <table width="100%" style="margin-top:20px; border-collapse:collapse;" border="1">
            <tr>
                <th align="center">Description</th>
               
            </tr>
            <tr>
                <td align="center" style="padding-left:10px;"><strong><?php echo $descr?></strong></td>
               
            </tr>
        </table>
        
       <div style="margin-top:10px;" >
           
        <p align="center"><u>COST INCLUSIONS</u></p>
       
      <?php
          
          
          
          $resultserp = $js->prepare('SELECT * FROM `hotelreservations` WHERE custid = :cid ORDER BY `cindate` ');
          $resultserp->execute(array(':cid' => $cid));
          $hcount = $resultserp->rowCount();
          
          if($hcount != '0')
          {
      ?>
        <table class="table table-bordered" id="mydatatable" width="100%" cellpadding="7" border="1" style="border-collapse:collapse;">
            <thead>
            <tr>
                <td colspan="8"> <strong>Hotel Reservations</strong>
            </tr>    
            
                <tr align="center" >
                <th style="padding-left:5px; padding-right:5px;">SL No</th>
                <th>Location </th>
                <th>Hotel Name</th>
                <th>Check-In</th>
                <th>Check-Out</th>
                <th>Room Type</th>
                <th>No. of Rooms</th>
                <th>Meals Included</th>               
            </tr>
            </thead>
            
            <?php
                                            
                                                $x = 1;
                                                
                                                while($rowserp = $resultserp->fetch(PDO::FETCH_ASSOC))
                                                {
                                                    $hotel = $rowserp['hotel'];
                                                    $cindate = date('d-m-Y', strtotime($rowserp['cindate']));
                                                    $coutdate = date('d-m-Y', strtotime($rowserp['coutdate']));
                                                    $roomtype = $rowserp['roomtype'];
                                                    $norooms = $rowserp['norooms'];
                                                    
                                                    $noebs = $rowserp['noebs'];
                                                    if($noebs >= '1')
                                                    {
                                                        $norooms = $norooms.' + '.$noebs.' Extra-bed';    
                                                    }
                                                    $meals = $rowserp['meals'];
                                                    $grand_total += $totals;
                                                    $resultprod = $js->prepare('SELECT * FROM `hotelvendor` WHERE id = :hotel ');
                                                    $resultprod->execute(array(':hotel' => $hotel));
                                                    while($rowprod = $resultprod->fetch(PDO::FETCH_ASSOC))
                                                    {
                                                        $location = $rowprod['location'];
                                                        $hotelname = $rowprod['hotelname'];
                                                    }
                                                    echo "<tr>";
                                                        echo "<td align='center'>$x</td>";
                                                        echo "<td align='center'>$location</td>";
                                                        echo "<td align='center'>$hotelname</td>";
                                                        echo "<td align='center'>$cindate</td>";
                                                        echo "<td align='center'>$coutdate</td>";
                                                        echo "<td align='center'>$roomtype</td>";
                                                        echo "<td align='center'>$norooms</td>";
                                                        echo "<td align='center'>$meals</td>";
                                                    echo "</tr>";
                                                    
                                                
                                                    $x++;
                                                    
                                                    
                                                }
                                                                                            
                                            
                                            
            ?>
            
        </table><br>
        <?php
          }
          
          $resultserpt = $js->prepare('SELECT * FROM `travelassistance` WHERE custid = :cid ORDER BY `id` ');
          $resultserpt->execute(array(':cid' => $cid));
          $tcount = $resultserpt->rowCount();
          if($tcount != '0')
          {
        ?>
         <table class="table table-bordered" id="mydatatable" width="100%" cellspacing="0" border="1" style="border-collapse:collapse;">
            <thead>
            <tr>
                <td colspan="6"> Travel Asssitance</td>
            </tr>    
            
                <tr align="center" >
                <th style="padding-left:5px; padding-right:5px;">SL No</th>
                <th>Vehicle Type </th>
                <th>Description </th>
        
            </tr>
            </thead>
            
            <?php
                                            
                                                $x = 1;
                                                    
                                                
                                                while($rowserp = $resultserpt->fetch(PDO::FETCH_ASSOC))
                                                {
                                                    $vehicle = $rowserp['vehicle'];
                                                    $descr = $rowserp['descr'];
                                                    $des = nl2br($descr);

echo "<tr>";
                                                        echo "<td align='center'>$x</td>";
                                                        echo "<td style='padding-left:10px; padding-top:10px; padding-bottom:10px; padding-right:10px;'>$vehicle</td>";
                                                        echo "<td style='padding-left:10px; padding-top:10px; padding-bottom:10px; padding-right:10px;'>$des</td>";
                                                    echo "</tr>";
                                                    
                                                
                                                    $x++;
                                                    
                                                    
                                                }
            ?>
            
        </table>
        <?php
          }
            $resultother = $js->prepare('SELECT * FROM `otherservices` WHERE custid = :cid ORDER BY `id` ');
            $resultother->execute(array(':cid' => $cid));
            $count = $resultother->rowCount();
            if($count != '0')
            {
        ?>
        
        <br>
         <table class="table table-bordered" id="mydatatable" width="100%" cellspacing="0" border="1" style="border-collapse:collapse;">
            <thead>
            <tr>
                <td colspan="6"> Other Services</td>
            </tr>    
            
                <tr align="center" >
                <th style="padding-left:5px; padding-right:5px;">SL No</th>
                <th>Service </th>
                <th>Description </th>
                
            </tr>
            </thead>
            
            <?php
                                            
                                                $x = 1;
                                                    
                                                
                                                while($rowserp = $resultother->fetch(PDO::FETCH_ASSOC))
                                                {
                                                    $services = $rowserp['services'];
                                                    $descr = $rowserp['descr'];
                                                    $amount = $rowserp['amount'];
                                                    $totother += $amount;

echo "<tr>";
                                                        echo "<td align='center'>$x</td>";
                                                        echo "<td align='center'>$services</td>";
                                                        echo "<td style='padding-left:10px; padding-top:10px; padding-bottom:10px; padding-right:10px;'>$descr</td>";
                                                        /*echo "<td align='right' style='padding-right:10px;'>$amount</td>";*/
                                                    echo "</tr>";
                                                    
                                                
                                                    $x++;
                                                    
                                                    
                                                }
            ?>
            
        </table>
        <?php
            
            
            }
            $totalcost = $invamount;
        ?>
        <br>
        <table class="table table-bordered" id="mydatatable" width="100%" cellspacing="0" border="1" style="border-collapse:collapse;">
            <tr style="line-height:30PX;">
                <td width="85%" align="right" style="padding-right:10px;"><strong>TOTAL PACKAGE COST</strong></td>
                <td width="15%" align="right" style="padding-right:10px;"><strong><?php echo $currency." ".$totalcost?></strong></td>
            </tr>
            <tr style="line-height:30PX;">
                <td width="85%" align="right" style="padding-right:10px;"><strong>ADVANCE PAID</strong></td>
                <td width="15%" align="right" style="padding-right:10px;"><strong><?php echo $pcurrency." ".$totpay?></strong></td>
            </tr>
            <tr style="line-height:30PX;">
                <td width="85%" align="right" style="padding-right:10px;"><strong>BALANCE PAYABLE</strong></td>
                <td width="15%" align="right" style="padding-right:10px;"><strong><?php echo $currency." ".$balance?></strong></td>
            </tr>
        </table>
        <h3>Payment Terms</h3>
        <p align="justify" style="line-height:30px;">
        <table width="100%">
        <tr>
        <td>1) Any confirmation is subject to an advance payment of a minimum of 60% of the invoice amount, if any additional services such as air tickets or visa, to be paid 100%
to issue the same.</td></tr>
        
            <tr><td> 2)  Balance Payment has to be made in advance before 15 days of Arrival to Oman. </td></tr>
           
           <tr><td>3) Under EBS Scheme, 100% payment to be made to avail the offer.</td></tr>
            <tr><td>4) Payments can be remitted to the given below Company's Current Bank A/c.</td></tr>
           </table>
          <?php
          //    if($additional != '')
            //{
          ?>
         
          <?php //echo $additional?>
          <?php
            //}
          ?>
         <br><br>
        <table class="table table-bordered" id="mydatatable" width="100%" cellspacing="0" border="1" style="border-collapse:collapse;">
                            <thead>
                            <tr>
                                <th style='width:20%' align='center'>Bank</th>
                                <th style='width:20%' align='center'>Branch</th>
                                <th style='width:20%' align='center'>A/C Name</th>
                                <th style='width:20%' align='center'> IBAN</th>
                                <th style='width:20%' align='center'>Swift Code</th>
                            </tr>
                            </thead>
                            
                            <?php
                            $stat = 'Active';
                            $resultz = $js->prepare('SELECT * FROM bankaccounts WHERE status = :stat ');
                            $resultz->execute(array(':stat' => $stat));
                            
                            while($rowz = $resultz->fetch(PDO::FETCH_ASSOC))
                                        {
                                            $bid = $rowz['bankid'];
                                            $bname = $rowz['bankname'];
                                            $branch = $rowz['bankbranch'];
                                            $accnt = $rowz['accountno'];
                                            $acname = $rowz['accountname'];
                                            $swift = $rowz['swift'];
                                            
                                            echo "<tr>";
                                                echo "<td style='text-align:center;'>$bname</td>";
                                                echo "<td style='text-align:center;'>$branch</td>";
                                                echo "<td style='text-align:center;'>$acname</td>";
                                                echo "<td style='text-align:center;'>OM160270440068457610012</td>";/*$accnt*/
                                                echo "<td style='text-align:center;'>$swift</td>";
                                            echo "</tr>";
                                        }
                            ?>

</table>
       <br><br>
         
        <table width="100%">
               <tr>
                <td width="60%"></td>
                 <td align="right" style="padding-right:10px;"><img src="images/STAMP AND SIGN.jpg"></td>
            </tr>
       </table>
                        
        
</td></tr></tbody><tfoot><tr><td>&nbsp;</td></tr></tfoot></table>

<td width="100%" style="font-size:14px; height:40px; padding-top:5px;" align="center"> 
    <hr style="height:5px; color:#F49943;  background-color:#F49943;"><br>
     FALCON EXPEDITIONS TRADE LLC - Registration No: 1503838 Post Box NO: 102, Postal Code: 114, Muscat, Sultanate of Oman <br>
Phone : +968 94155255 |+ 968 77190959 |Email : support@thefalconexpeditions.com | www.thefalconexpeditions.com
    </td>
  </tr>

</table><div class="noprint">
<p align="center"><a href="#" onClick="myFunction()" style="border:5px solid; background-color:#093; color:#FFF; padding:8px; text-decoration:none;">PRINT</a> </p>
<p align="center"><a href="home.php" style="border:5px solid; background-color:#093; color:#FFF; padding:8px; text-decoration:none;">CLOSE</a> </p>
</div>

<?php
define("Riyals", 'pounds');
define("Baise", 'p');
class toWords
{
    var $pounds;
    var $pence;
    var $major;
    var $minor;
    var $words = '';
    var $number;
    var $magind;
    var $units = array('', 'one', 'two', 'three', 'four', 'five', 'six', 'seven', 'eight', 'nine');
    var $teens = array('ten', 'eleven', 'twelve', 'thirteen', 'fourteen', 'fifteen', 'sixteen', 'seventeen', 'eighteen', 'nineteen');
    var $tens = array('', 'ten', 'twenty', 'thirty', 'forty', 'fifty', 'sixty', 'seventy', 'eighty', 'ninety');
    var $mag = array('', 'thousand', 'million', 'billion', 'trillion');

function toWords($amount, $major = Riyals, $minor = Baise)
    {
        $this->__toWords__((int)($amount), $major);
        $whole_number_part = $this->words;
        #$right_of_decimal = (int)(($amount-(int)$amount) * 100);
        $strform = number_format($amount,3);
        $right_of_decimal = (int)substr($strform, strpos($strform,'.')+1);
        $this->__toWords__($right_of_decimal, $minor);
        $this->words = $whole_number_part . ' ' . $this->words;
    }