MAINHACK

Viewing / Editing File: invoice.php

<?php include("../admin/includes/functions/functions.php");?>
<?php include("../admin/db/db.php");?>
<?php 
if(!isset($_SESSION['username_Xw211qAAsq4']))
{
header('Location: ../auth/');
exit();
} else{

$shopname = $_SESSION['business_name_Xw211qAAsq4'];

$stmtServices = $con->prepare("SELECT * FROM barber_admin  where  business_name = ?");
$stmtServices->execute(array($shopname));
$rowsServices = $stmtServices->fetchAll();
foreach($rowsServices  as $data){
  $location = $data['location'];
  $number = $data['phone'];

}

if(isset($_GET['INVOICEID'])){
 
$do = htmlspecialchars($_GET['INVOICEID']);

$stmt = $con->prepare("SELECT s.sold_date as sdate,s.total_amount as total,s.po_id as poid,s.discount as discount,s.amount_paid as amount_paid,s.payment_mode as payment_mode, e.first_name as fname,e.last_name as lname FROM product_sales s,clients e WHERE s.buy_id = e.client_id AND s.po_id AND s.po_id = ? and s.business_name = ?");

$stmt->execute(array($do,$shopname));
$rowsEmployees = $stmt->fetchAll();
 foreach($rowsEmployees as $rowsService){
 $sdate = $rowsService['sdate'];
  $fname = $rowsService['fname'];
  $lname = $rowsService['lname'];
  $phone = $rowsService['phone'];

$total = $rowsService['total'];

$dis = $rowsService['discount'];

$tdis = ($dis / 100) * $total;

}

$ppp = $con->prepare("SELECT p.product_name as pname,p.price as price, o.qty as qty,o.amount as amount FROM products p,invoice_order_item o WHERE p.pro_id = o.pro_id AND o.sales_id = ? and p.business_name = ?");
$ppp->execute(array($do,$shopname));
$orderitem = $ppp->fetchAll();

}

<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta http-equiv="x-ua-compatible" content="ie=edge">
  <title> Receipt</title>
  <meta name="viewport" content="width=device-width, initial-scale=1">
    <script src="https://cdnjs.cloudflare.com/ajax/libs/html2pdf.js/0.9.2/html2pdf.bundle.js"></script>
  <style type="text/css">
  @media screen {
    @font-face {
      font-family: 'Source Sans Pro';
      font-style: normal;
      font-weight: 400;
      src: local('Source Sans Pro Regular'), local('SourceSansPro-Regular'), url(https://fonts.gstatic.com/s/sourcesanspro/v10/ODelI1aHBYDBqgeIAH2zlBM0YzuT7MdOe03otPbuUS0.woff) format('woff');
    }

@font-face {
      font-family: 'Source Sans Pro';
      font-style: normal;
      font-weight: 700;
      src: local('Source Sans Pro Bold'), local('SourceSansPro-Bold'), url(https://fonts.gstatic.com/s/sourcesanspro/v10/toadOcfmlt9b38dHJxOBGFkQc6VGVFSmCnC_l7QZG60.woff) format('woff');
    }
  }
  body,
  table,
  td,
  a {
    -ms-text-size-adjust: 100%; /* 1 */
    -webkit-text-size-adjust: 100%; /* 2 */
  }

table,
  td {
    mso-table-rspace: 0pt;
    mso-table-lspace: 0pt;
  }
  img {
    -ms-interpolation-mode: bicubic;
  }

a[x-apple-data-detectors] {
    font-family: inherit !important;
    font-size: inherit !important;
    font-weight: inherit !important;
    line-height: inherit !important;
    color: inherit !important;
    text-decoration: none !important;
  }

div[style*="margin: 16px 0;"] {
    margin: 0 !important;
  }

body {
    width: 100% !important;
    height: 100% !important;
    padding: 0 !important;
    margin: 0 !important;
  }

table {
    border-collapse: collapse !important;
  }

a {
    color: #1a82e2;
  }

img {
    height: auto;
    line-height: 100%;
    text-decoration: none;
    border: 0;
    outline: none;
  }
  </style>

</head>
<body style="background-color: #D2C7BA;">
  <table border="0" cellpadding="0" cellspacing="0" width="100%" id="invoice">
 <br  /><br  />
    <tr>
      <td align="center" bgcolor="#D2C7BA">
      </td>
    </tr>
    <tr>
      <td align="center" bgcolor="#D2C7BA">
    <table border="0" cellpadding="0" cellspacing="0" width="100%" style="max-width: 600px;">
          <tr>
            <td align="left" bgcolor="#ffffff" style="padding: 36px 24px 0; font-family: 'Source Sans Pro', Helvetica, Arial, sans-serif; border-top: 3px solid #d4dadf;">
              <center><h1 style="margin: 0; font-size: 32px; font-weight: 700; letter-spacing: -1px; line-height: 48px;">Invoice No - 000<?php echo $do ;?></h1>
                <p style="margin: 0;">
                 Invoice Date : <?php echo $sdate;?><br>
              </p>

</center>
            </td>
          </tr>
        </table>

</td>
    </tr>

<table border="0" cellpadding="0" cellspacing="0" width="100%" style="max-width: 600px;">
          <tr>
            <td align="left" bgcolor="#ffffff" style="padding: 24px; font-family: 'Source Sans Pro', Helvetica, Arial, sans-serif; font-size: 16px; line-height: 24px;">
              <table border="0" cellpadding="0" cellspacing="0" width="100%">
                <tr>
                  <td align="left" bgcolor="#D2C7BA" width="50%" style="padding: 12px;font-family: 'Source Sans Pro', Helvetica, Arial, sans-serif; font-size: 16px; line-height: 24px;"><strong>Product </strong></td>

<td align="left" bgcolor="#D2C7BA" width="29%" style="padding: 12px;font-family: 'Source Sans Pro', Helvetica, Arial, sans-serif; font-size: 16px; line-height: 24px;"><strong>Price</strong></td>

<td align="left" bgcolor="#D2C7BA" width="29%" style="padding: 12px;font-family: 'Source Sans Pro', Helvetica, Arial, sans-serif; font-size: 16px; line-height: 24px;"><strong>Total</strong></td>
                </tr>
                <tr>

<?php 
                      foreach($orderitem as $items)
                      {?>

<tr>
              <td align="left" width="75%" style="padding: 12px; font-family: 'Source Sans Pro', Helvetica, Arial, sans-serif; font-size: 16px; line-height: 24px; border-top: 2px dashed #D2C7BA; border-bottom: 2px dashed #D2C7BA;">Gross Total</td>
              <td align="left" width="75%" style="padding: 12px; font-family: 'Source Sans Pro', Helvetica, Arial, sans-serif; font-size: 16px; line-height: 24px; border-top: 2px dashed #D2C7BA; border-bottom: 2px dashed #D2C7BA;"></td>
              <td align="left" width="75%" style="padding: 12px; font-family: 'Source Sans Pro', Helvetica, Arial, sans-serif; font-size: 16px; line-height: 24px; border-top: 2px dashed #D2C7BA; border-bottom: 2px dashed #D2C7BA;"></td>

<tr>
            <td align="left" width="75%" style="padding: 12px; font-family: 'Source Sans Pro', Helvetica, Arial, sans-serif; font-size: 16px; line-height: 24px; border-top: 2px dashed #D2C7BA; border-bottom: 2px dashed #D2C7BA;"><strong>Payment type</strong></td>
             <td align="left" width="75%" style="padding: 12px; font-family: 'Source Sans Pro', Helvetica, Arial, sans-serif; font-size: 16px; line-height: 24px; border-top: 2px dashed #D2C7BA; border-bottom: 2px dashed #D2C7BA;"><strong></strong></td>
              <td align="left" width="75%" style="padding: 12px; font-family: 'Source Sans Pro', Helvetica, Arial, sans-serif; font-size: 16px; line-height: 24px; border-top: 2px dashed #D2C7BA; border-bottom: 2px dashed #D2C7BA;"><strong></strong></td>

</table>
            </td>
          </tr>
        </table>
      </td>
    </tr>
    <tr>
      <td align="center" bgcolor="#D2C7BA" valign="top" width="100%">
        <table align="center" bgcolor="#ffffff" border="0" cellpadding="0" cellspacing="0" width="100%" style="max-width: 600px;">
          <tr>
            <td align="center" valign="top" style="font-size: 0; border-bottom: 3px solid #d4dadf">
             <div style="display: inline-block; width: 100%; max-width: 50%; min-width: 240px; vertical-align: top;">
                <table align="left" border="0" cellpadding="0" cellspacing="0" width="100%" style="max-width: 300px;">
                  <tr>
                    <td align="left" valign="top" style="padding-bottom: 36px; padding-left: 36px; font-family: 'Source Sans Pro', Helvetica, Arial, sans-serif; font-size: 16px; line-height: 24px;">
                      <p><strong>Office address</strong></p>
                      <p><?php echo $shopname;?><br><?php echo $location;?><br/>
                        <?php echo $number;?></p>
                    </td>
                  </tr>
                </table>
              </div>

</td>
    </tr>
  
    <tr>
      <td align="center" bgcolor="#D2C7BA" style="padding: 24px;">
      <table border="0" cellpadding="0" cellspacing="0" width="100%" style="max-width: 600px;">
        </table>
      </td>
    </tr>
      
  </table>

</body>
</html>

$(function()
    {
        App.initHelpers('table-tools');
    });
</script>
<?php }?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: invoice.php

Server Info

System Features

User Info