FM / book.familycab.com.au

/home/desid573/book.familycab.com.au/

/home/desid573/book.familycab.com.au

Name	Size	Mode	Actions
.well-known/	-	0755	rm
assets/	-	0755	rm
cgi-bin/	-	0755	rm
eway-rapid-php-master/	-	0755	rm
invoice/	-	0755	rm
ltjvghp/	-	0755	rm
pdd/	-	0755	rm
pwcsebh/	-	0755	rm
swtrvog/	-	0755	rm
w1mcglu/	-	0755	rm
.htaccess	281	0644	edit dl rm
10.php	1941	0644	edit dl rm
11.php	1176	0644	edit dl rm
22.php	9106	0644	edit dl rm
array.php	2141	0644	edit dl rm
a_name_address.php	959	0644	edit dl rm
brisbaneInvoice.php	11845	0644	edit dl rm
class.phpmailer.php	80046	0644	edit dl rm
class.pop3.php	10385	0644	edit dl rm
class.smtp.php	24586	0644	edit dl rm
dispatch.php	877	0644	edit dl rm
driverInvoice.php	12708	0644	edit dl rm
driverlocation.php	14585	0644	edit dl rm
eCrypt.js	68424	0644	edit dl rm
edit.php	780	0644	edit dl rm
eway-rapid-php-master.zip	57270	0644	edit dl rm
eWay.php	42697	0644	edit dl rm
family-cab_small.jpg	98853	0644	edit dl rm
favicon.ico	1150	0644	edit dl rm
index.php	198358	0644	edit dl rm
index1apr2019.php	92844	0644	edit dl rm
index3.php	60677	0644	edit dl rm
index4.php	91500	0644	edit dl rm
index15thMay.php	92640	0644	edit dl rm
indexJune10.php	93053	0644	edit dl rm
indextest.php	91391	0644	edit dl rm
indexTraffic.php	86040	0644	edit dl rm
index_preSydney.php	60350	0644	edit dl rm
index_sydney.php	74126	0644	edit dl rm
melbAuditReport.php	34176	0644	edit dl rm
melbreport.php	7758	0644	edit dl rm
monthly.php	12046	0644	edit dl rm
perthAuditReport.php	34918	0644	edit dl rm
perthReport.php	7587	0644	edit dl rm
pre-sydneyquote.php	39158	0644	edit dl rm
promo.php	765	0644	edit dl rm
qldreport.php	7544	0644	edit dl rm
quote.php	52358	0644	edit dl rm
quote2.php	38831	0644	edit dl rm
quote_sydney.php	51912	0644	edit dl rm
report.php	10447	0644	edit dl rm
search.php	854	0644	edit dl rm
serialize.php	132	0644	edit dl rm
style.json	1014	0644	edit dl rm
sydneydispatch.php	12177	0644	edit dl rm
sydneyreport.php	7758	0644	edit dl rm
test.php	3851	0644	edit dl rm
thankyou.php	32003	0644	edit dl rm
wp-cron-cwhi.php	1659	0644	edit dl rm

Edit: /home/desid573/book.familycab.com.au/brisbaneInvoice.php (11845B)

<?php
error_reporting(E_ALL ^ E_NOTICE ^ E_DEPRECATED ^ E_STRICT);
date_default_timezone_set("Australia/Sydney");

// if(date("l") == "Monday") {
    //     $period = strtotime("Today 12:00 AM") - 7 * 60 * 60 * 24;
    // } else {

// $period = strtotime("last Monday 12:00 AM") - 7 * 60 * 60 * 24;
    // }
    // $periodLower = strtotime("last Sunday 23:59");
    $period = strtotime("Monday 12:00 AM") - 7 * 60 * 60 * 24;
    $periodLower = strtotime("Today 23:59");
    $dt = new DateTime();
    $dt->setTimestamp($period);
    $periodString = date_format($dt, "jS M, Y H:i a");
    $dt = new DateTime();
    $dt->setTimestamp($periodLower);
    $periodStringLower = date_format($dt, "jS M, Y H:i a");

require_once('class.phpmailer.php');
require_once('class.smtp.php');

$dbhost = "localhost";
	    $dbuser = "desid573_famcab";
	    $dbpass = "C]+6wQySxov(";
	    $dbname = "desid573_familycab";
	    $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
	    $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
	   
	    
	    //$driver = $_REQUEST["driver"];
	    
	    $yesterday = $periodString;
	    
	    $lastDriver = "";
	    $lastDriverTotal = "";
	    $lastDriverTollTotal = "";
	    
	    $dateFormat = "Y-m-d H:i:s";

$query1 = "SELECT * FROM invoices WHERE type = 'BF' AND driver != 'Trina Moore' AND driver != 'Michael Bowen' AND date_created BETWEEN '".date($dateFormat, $period)."' AND '".date($dateFormat, $periodLower)."'";
	  
        $result = mysqli_query($conn, $query1);
        
         $array = array();
	    
	    while($rowSQL = mysqli_fetch_assoc($result)){
	     
	     $array[] = $rowSQL;  
	        
	    }
        
        $dbhost = "localhost";
	    $dbuser = "desid573_fam_app";
	    $dbpass = "TW#7CCqKReDn";
		$dbname = "desid573_famcab_api";
	    $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
	    $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
	    
	   
        
        
        $query2 = "SELECT * FROM invoices WHERE type = 'BA' AND driver != 'Trina Moore' AND driver != 'Michael Bowen' AND date_created BETWEEN '".date($dateFormat, $period)."' AND '".date($dateFormat, $periodLower)."'";
        $result2 = mysqli_query($conn, $query2);
        
        while($rowSQL = mysqli_fetch_assoc($result2)){
	     
	     $array[] = $rowSQL;  
	        
	    }
	    
	    
	    
	    usort($array, function($a, $b) {
            return $a['date_created'] > $b['date_created'];
            });
            
         $driver_commission = 0.8;
         $query = "SELECT * FROM desid573_eway_codes.driver_commission WHERE driver_name = 'Hemmy Timotius'";
        $result = mysqli_query($conn, $query);   
        
        if($result->num_rows > 0) {
            $row = mysqli_fetch_assoc($result);
            $driver_commission = $row["commission"];
            $driver_email = $row["email"];
        } else {
            echo $conn->error;
        }
          //  echo $driver_commission;
	    
	    
        $lastDriver = "";
        $quotetotal = 0;
        $acttotal = 0;
       $message = "
       
       <!DOCTYPE html>
	<html lang='en'>
       <head>
       <meta charset='utf-8'>
    <meta http-equiv='X-UA-Compatible' content='IE=edge'>
    
    <meta name='viewport' content='width=device-width, initial-scale=1'>
    
    <title>Driver Invoice Report</title>
       <style type='text/css'>
       table {
            
            display: block;
            border-collapse: collapse;
            
          
        }
        tr {
        height:30px;
        
        
        }
        td {
        padding:3px;
        }
       
        .hideextra {
        
        white-space: nowrap; 
        overflow: hidden; 
        text-overflow:ellipsis; 
            
            
        }
        table tr:nth-child(odd) td{
        background-color: #d3d3d3; 
	}
table tr:nth-child(even) td{
	}
       
       </style>
       </head>
       <body>
       <h2>Report for ".$driver." Jobs from ".$periodString." to ".$periodStringLower." In Sydney</h2><br>
        
        <br><table id=`table`><tbody><tr><td><span style='font-size: 150%; font-weight: bold;'>FamilyCab Jobs</span></td><td></td><td></td><td></td><td></td><td></td></tr>
       <tr><td>Job Details</td><td>Commission Total</td><td>Toll Total</td><td>Total</td></tr>";
       
       $x = 0;
       $dateFormat = "d-m-Y";
       
        foreach($array as $row) {
       $x = $x + 1;
        
        
            
            $driver_total = number_format(($row['amount'] - 1.1)*$driver_commission, 2);
            
            $total = $driver_total + $row['tollAmount'];
            
            $message .= "<tr><td style='white-space: nowrap; width:300px;' ><textarea style='display:block;width:100%;' id='desc".$x."'>".date($dateFormat, strtotime($row['date_created']))."\n".$row['invname']."\n".$row['invdesc']." \nFare total = ".$row['amount']." \nToll Amt = ".$row['tollAmount']." \ninc. 1.10 levy</textarea></td><td><div><input type='text' id='amount".$x."' value='".$driver_total."' onchange='updateSpan(".$x.");adjustTotals(); '></div></td><td><input type='text' id='tollAmount".$x."' value='".$row['tollAmount']."' onchange='updateSpan(".$x.");adjustTotals();'></td><td>$<span id='total".$x."'>".$total."</span></td></tr>";
        
        
        $quotetotal = +floatval($quotetotal)+floatval($driver_total);
        $acttotal = +floatval($acttotal)+floatval($row['tollAmount']);
        $lastDriver = $row['driver'];
        $lastDriverTotal = +floatval($lastDriverTotal)+floatval($driver_total);
        $lastDriverTollTotal = +floatval($lastDriverTollTotal)+floatval($row['tollAmount']);
        
        
        }
        
      
        
        $grandTotal = $lastDriverTotal + $lastDriverTollTotal;
            
            $message .= "<tr><td>".$lastDriver." Total</td><td><span id='totalComm'>".$lastDriverTotal."</span></td><td><span id='totalToll'>".$lastDriverTollTotal."</span></td><td><span id='grandTotal'>".$grandTotal."</span></td></tr>";
            $lastDriver = "";
            $lastDriverTotal = 0;
            $lastDriverTollTotal = 0;
        
        
        
        
        
        
        $message .= "</tbody></table><br><button id='addRow'>Add Row</button><br><br><br><br><button id='buildInvoice' onClick='getInvoice(); return false;'>Build Invoice</button><br><br><span id='responseHtml'></span><span id='responseEmail'></span></body></html>
<script src='https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js'></script>       
        
        <script src='https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js'></script>

var x = ".$x.";
        
       
        var filepath = '/';
        
    	
    	$('#addRow').on('click', function() {
    	
    	x = x + 1;
    	
    	var html = `<tr><td style='white-space: nowrap; width:300px;' ><input type='text' style='display:block;width:100%; id='desc` + x + `' ></td><td><div><input type='text' id='amount` + x + `' value='' onchange='updateSpan(` + x + `);adjustTotals(); '></div></td><td><input type='text' id='tollAmount` + x + `' value='' onchange='updateSpan(` + x + `);adjustTotals();'></td><td>$<span id='total` + x + `'></span></td></tr>`;
    	
    	var text = $('#newRows').html();
    	
    	if(text == '') {
    	var newHtml = html;
    	} else {
    	    newHtml = text + html;
    	}
    	
    	 var mytable = $('#table').find('tbody');

var last_row = $('table tr:last').prev();

var new_row = html;

last_row.after(new_row);
    	console.log(new_row);
    	
    	//$('#newRows').html(newHtml);
    
    	
    	});
    	
    	
    	
    	function updateSpan(spanId) {
    	
    	
    	   var amountID = `#amount` + spanId;
    	   var tollID = `#tollAmount` + spanId;
    	   var spanID = `#total` + spanId;
    	   
    	   if(parseFloat($(amountID).val())) {
    	       var amount = parseFloat($(amountID).val());
    	   } else {
    	        var amount = 0;
    	   }
    	   if(parseFloat($(tollID).val())) {
    	        var tollAmount = parseFloat($(tollID).val());
    	   } else {
    	       var tollAmount = 0;
    	   }
    	   
    	   var total =  amount + tollAmount;
    	    console.log(total);
    	   $(spanID).text(total);
    	}
    	
    	function adjustTotals() {
    	    var rows = $(this).attr('x');
    	    
    	    var totalComm = 0;
    	    var totalToll = 0;
    	    
    	    
    	    
    	    for(var i = 0; i < rows; i++) {
    	        var j =  i + 1;
    	        
    	        console.log(j);
    	        var amountID = `#amount` + j;
    	        var tollID = `#tollAmount` + j;
    	        
    	        if(parseFloat($(amountID).val())){
    	            var comm = parseFloat($(amountID).val());
    	        } else {
    	            var comm = 0;
    	        }
    	        if(parseFloat($(tollID).val())) {
    	            var toll = parseFloat($(tollID).val());
    	        } else {
    	            var toll = 0;
    	        }
    	        
    	        totalComm = totalComm + comm;
    	        totalToll = totalToll + toll;
    	        
    	    }
    	    
    	    $('#totalComm').text(totalComm);
    	    $('#totalToll').text(totalToll);
    	    $('#grandTotal').text(totalComm + totalToll);
    	    
    	}
    	
    	function getInvoice() {
            var items = [];
            
            var rows = $(this).attr('x');
    	    
    	   
    	    
    	    
    	    
    	    for(var i = 0; i < rows; i++) {
    	        var j =  i + 1;
    	        
    	        var descID = `#desc` + j;
    	        var amountID = `#amount` + j;
    	        var tollID = `#tollAmount` + j;
    	        var totalID = `#total` + j;
    	        
    	        
    	        items[i] = {desc: $(descID).val(), total: $(totalID).text()};
    	        
    	        
    	    }
    	    
    	    var data = {name: '".$driver."', items: items};
    	   console.log(data);
    	    $.ajax({
         	type: `POST`,
         	url: `invoice/pdf/RGTI.php`,
               	data: data,
               	dataType: 'json',
                success: function (data) {
                console.log(data);
                    if(data.status == `error`) {
                        $('#responseHtml').text(`Error generating PDF`);
                    } else {
                        filepath = data.file;
                        var lines = `<a target='_blank' href='invoice/pdf/pdfinvoices/` + data.file + `'>View Invoice</a><br><br><button id='emailInvoice' onClick='emailInvoice();'>Email Invoice</button>`;
                        console.log(lines);
                        
                        $('#responseHtml').html(lines);
                    }
                }
    	    })
        }
        
        function emailInvoice() {
            var file = $(this).attr('filepath');
            var data = {name: '".$driver."', email: '".$driver_email."', file: '../../family/invoice/pdf/pdfinvoices/' + file};
            console.log(data);
            $.ajax({
         	type: `POST`,
         	url: `../google/google-api-php-client-2.2.1/gmailSendBill.php`,
               	data: data,
               	dataType: 'json',
                success: function (data) {
                console.log(data);
                var emailresp = '<br><br><br><p>' + data.message + '</p>';
                
                $('#responseEmail').html(emailresp);
                }
                
            })
            
            
            
        }
    	
</script>";

echo $message;

setTimestamp($period); $periodString = date_format($dt, "jS M, Y H:i a"); $dt = new DateTime(); $dt->setTimestamp($periodLower); $periodStringLower = date_format($dt, "jS M, Y H:i a"); require_once('class.phpmailer.php'); require_once('class.smtp.php'); $dbhost = "localhost"; $dbuser = "desid573_famcab"; $dbpass = "C]+6wQySxov("; $dbname = "desid573_familycab"; $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error); $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname); //$driver = $_REQUEST["driver"]; $yesterday = $periodString; $lastDriver = ""; $lastDriverTotal = ""; $lastDriverTollTotal = ""; $dateFormat = "Y-m-d H:i:s"; $query1 = "SELECT * FROM invoices WHERE type = 'BF' AND driver != 'Trina Moore' AND driver != 'Michael Bowen' AND date_created BETWEEN '".date($dateFormat, $period)."' AND '".date($dateFormat, $periodLower)."'"; $result = mysqli_query($conn, $query1); $array = array(); while($rowSQL = mysqli_fetch_assoc($result)){ $array[] = $rowSQL; } $dbhost = "localhost"; $dbuser = "desid573_fam_app"; $dbpass = "TW#7CCqKReDn"; $dbname = "desid573_famcab_api"; $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error); $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname); $query2 = "SELECT * FROM invoices WHERE type = 'BA' AND driver != 'Trina Moore' AND driver != 'Michael Bowen' AND date_created BETWEEN '".date($dateFormat, $period)."' AND '".date($dateFormat, $periodLower)."'"; $result2 = mysqli_query($conn, $query2); while($rowSQL = mysqli_fetch_assoc($result2)){ $array[] = $rowSQL; } usort($array, function($a, $b) { return $a['date_created'] > $b['date_created']; }); $driver_commission = 0.8; $query = "SELECT * FROM desid573_eway_codes.driver_commission WHERE driver_name = 'Hemmy Timotius'"; $result = mysqli_query($conn, $query); if($result->num_rows > 0) { $row = mysqli_fetch_assoc($result); $driver_commission = $row["commission"]; $driver_email = $row["email"]; } else { echo $conn->error; } // echo $driver_commission; $lastDriver = ""; $quotetotal = 0; $acttotal = 0; $message = " Driver Invoice Report

Report for ".$driver." Jobs from ".$periodString." to ".$periodStringLower." In Sydney

"; $x = 0; $dateFormat = "d-m-Y"; foreach($array as $row) { $x = $x + 1; $driver_total = number_format(($row['amount'] - 1.1)*$driver_commission, 2); $total = $driver_total + $row['tollAmount']; $message .= ""; $quotetotal = +floatval($quotetotal)+floatval($driver_total); $acttotal = +floatval($acttotal)+floatval($row['tollAmount']); $lastDriver = $row['driver']; $lastDriverTotal = +floatval($lastDriverTotal)+floatval($driver_total); $lastDriverTollTotal = +floatval($lastDriverTollTotal)+floatval($row['tollAmount']); } $grandTotal = $lastDriverTotal + $lastDriverTollTotal; $message .= ""; $lastDriver = ""; $lastDriverTotal = 0; $lastDriverTollTotal = 0; $message .= "

FamilyCab Jobs
Job Details	Commission Total	Toll Total	Total
".date($dateFormat, strtotime($row['date_created']))."\n".$row['invname']."\n".$row['invdesc']." \nFare total = ".$row['amount']." \nToll Amt = ".$row['tollAmount']." \ninc. 1.10 levy			$".$total."
".$lastDriver." Total	".$lastDriverTotal."	".$lastDriverTollTotal."	".$grandTotal."

"; echo $message; ?>