<?php
include("include/header.php");
// include("include/header.php");
include("include/sidebar.php");
	$software_name=str_replace("www.","",$_SERVER['HTTP_HOST']);
	$con_bill=mysqli_connect("localhost", "ecampusco_global", "ecampusco_global", "ecampusco_billing");
	$billQ=mysqli_query($con_bill,"select transaction.*,software.name as product_name from transaction
	    left join software on software.id=transaction.software_id
	    where software.name='$software_name' AND transaction.status='unpaid' order by transaction.id desc limit 1");
	$billN=mysqli_num_rows($billQ);
	$billR=mysqli_fetch_array($billQ);
	if($billN==0){
	    echo '<script>window.location="index.php";</script>';
	}
?>
<style>
    #loader{
        display:none;
        position:fixed;
        z-index:1000;
        top:0;
        left:0;
        width:100%;
        height:100%;
        background-image:url(images/uploads/loader.gif);
        background-position:50% 50%;
        background-color:rgba(255,255,255,0.6);
        background-repeat:no-repeat;
    }
    body.loading{
        overflow:hidden;
    }
    body.loading #loader{
        display:block;
    }
</style>
<div id="loader"></div>
<link rel="stylesheet" href="bower_components/datatables.net-bs/css/dataTables.bootstrap.min.css">
<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <h1>
        Invoice
        <small></small>
      </h1>
      <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
        <li><a href="#">Billing</a></li>
        <li class="active">Invoice</li>
      </ol>
    </section>

    <!-- Main content -->
    <section class="invoice">
      <!-- title row -->
      <div class="row">
        <div class="col-xs-12">
          <h2 class="page-header">
            <i class="fa fa-globe"></i> Nirmal Technologies
            <small class="pull-right">Date: <?=date("d-m-Y",strtotime($billR['date']));?></small>
          </h2>
        </div>
        <!-- /.col -->
      </div>
      <!-- info row -->
      <div class="row invoice-info">
        <div class="col-sm-4 invoice-col">
          From
          <address>
            <strong>Nirmal Technologies</strong><br>
            795 Folsom Ave, Suite 600<br>
            San Francisco, CA 94107<br>
            Phone: (804) 123-5432<br>
            Email: mail.nirmalsarkar@gmail.com
          </address>
        </div>
        <!-- /.col -->
        <div class="col-sm-4 invoice-col">
          To
          <address>
            <strong>John Doe</strong><br>
            795 Folsom Ave, Suite 600<br>
            San Francisco, CA 94107<br>
            Phone: (555) 539-1037<br>
            Email: john.doe@example.com
          </address>
        </div>
        <!-- /.col -->
        <div class="col-sm-4 invoice-col">
          <br>
          <b>Order ID:</b> <?=$billR['order_id']?><br>
          <b>Payment Due:</b> <?=$billR['expiry_date']?><br>
        </div>
        <!-- /.col -->
      </div>
      <!-- /.row -->

      <!-- Table row -->
      <div class="row">
        <div class="col-xs-12 table-responsive">
          <table class="table table-striped">
            <thead>
            <tr>
              <th>Product</th>
              <th>Service</th>
              <th>Amount</th>
            </tr>
            </thead>
            <tbody>
            <tr>
              <td><?=$billR['product_name'];?></td>
              <td><?=$billR['remark'];?></td>
              <td>Rs. <?=$billR['amount'];?></td>
            </tr>
            </tbody>
          </table>
        </div>
        <!-- /.col -->
      </div>
      <!-- /.row -->

      <div class="row">
        <div class="col-xs-6">
          <p class="lead">Amount Due <?=$billR['expiry_date'];?></p>

          <div class="table-responsive">
            <table class="table">
              <tr>
                <th>Total:</th>
                <td>Rs. <?=$billR['amount'];?></td>
              </tr>
            </table>
          </div>
        </div>
        <!-- /.col -->
      </div>
      <!-- /.row -->

      <!-- this row will not appear when printing -->
      <div class="row no-print">
        <div class="col-xs-12">
          <!--<a href="invoice-print.html" target="_blank" class="btn btn-default"><i class="fa fa-print"></i> Print</a>-->
          <a href="./paytm/"><button type="button" class="btn btn-success pull-right"><i class="fa fa-credit-card"></i> Pay Online
          </button></a>
          <!--<button type="button" class="btn btn-primary pull-right" style="margin-right: 5px;">-->
          <!--  <i class="fa fa-download"></i> Generate PDF-->
          <!--</button>-->
        </div>
      </div>
    </section>
    <!-- /.content -->
    <div class="clearfix"></div>
  </div>
<?php include("include/footer.php"); ?>
<!-- page script -->
</body>
</html>