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/perthAuditReport.php (34918B)

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

date_default_timezone_set("Australia/Perth");
	    
	    function driversLicence($driver) {
	        
	        if($driver == "Lewis") {
	            return "4772054";
	        } else if($driver == "David Jenkins") {
	            return "3360758";
	        } else if($driver == "David OConnor") {
	            return "5599907";
	        } else if($driver == "Devinder Uppal") {
	            return "5168590";
	        } else if($driver == "Ben") {
	            return "4539408";
	        } else if($driver == "Muhammad Saleem") {
	            return "7946175";
	        } else if($driver == "Paul Clark") {
	            return "1778856";
	        } else if($driver == "Roy") {
	            return "4759182";
	        } else if($driver == "Michael Bowen") {
	            return "4910667";
	            
	        } else {
	            return $driver;
	        }
	        
	    }
        
        function checkWeb($ref) {
        $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);

$query1 = "SELECT * FROM invoices WHERE reference='".$ref."'";
        $result = mysqli_query($conn, $query1);
        
        if($result->num_rows > 0) {
        $rowSQL = mysqli_fetch_assoc($result);
        
        $array = array();
        
        $array["amount"] = $rowSQL["amount"];
        $array["driver"] = $rowSQL["driver"];
        
        if($rowSQL["driver"] == "Michael Bowen" OR $rowSQL["driver"] == "Devinder Uppal") {
         $array["plate"] = "1GCP191";
	    } else {
	        $array["plate"] = "1GGM897";
	    }
	    $array["licence"] = driversLicence($rowSQL["driver"]);
	    
	    $sql = "SELECT * FROM jobs WHERE reference = '".$ref."'";
	    $result = mysqli_query($conn, $sql);
	    $rowSQL = mysqli_fetch_assoc($result);
	    
	    $array["book_pax"] = $rowSQL["job_pax"];
	    $array["book_seats"] = $rowSQL["job_rf"] + $rowSQL["job_ff"] + $rowSQL["job_boost"];
	    
	    $pickup = $rowSQL["job_pickup"];
	    $pickup = strtolower($pickup);
	    if(strpos($pickup, 'airport') !== false) {
	        $array["airport"] == "5";
	    } else {
	        $array["airport"] == "0";
	    }
        
        $array["pickup"] = str_replace(",","",$rowSQL["job_pickup"]);
        $array["dropoff"] = str_replace(",","",$rowSQL["job_dropoff"]);
	    
	    $booking_date = $rowSQL["job_date"];
	    $d = date_create_from_format("jS M, Y", $booking_date);
        $date24 = date_format($d, "Y-m-d");  
        
        $booking_time = $rowSQL["job_time"];
        $time24 = date("G:i", strtotime($booking_time));
	    $array["date"] = date("d/m/Y G:i", strtotime($date24." ".$time24));
	    
	    $quote_time = $rowSQL["quote_time"];
	    if($quote_time == "") {
	        $quote_time = 15;
	    }
	    
	    $finish = strtotime($date24." ".$time24) + $quote_time * 60 * 60;
	    $array["finish"] = date("d/m/Y G:i", $finish);
	    $array["dist"] = $rowSQL["quote_km"];
	    $array["phone"] = $rowSQL["job_phone"];
	    
	    return $array;
        } else {
            return "none";
        }
	    
	    
        }
        
        function checkApp($ref) {
        $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);
	    
	    $query = "SELECT * FROM invoices WHERE reference='".$ref."'";
        $result = mysqli_query($conn, $query);
        if($result->num_rows > 0) {
        $rowSQL = mysqli_fetch_assoc($result);
	     
	    $array["amount"] = $rowSQL["amount"];
        $array["driver"] = $rowSQL["driver"];
        
        if($rowSQL["driver"] == "Michael Bowen" OR $rowSQL["driver"] == "Devinder Uppal") {
         $array["plate"] = "1GCP191";
	    } else {
	        $array["plate"] = "1GGM897";
	    }
	    $array["licence"] = driversLicence($rowSQL["driver"]);
	    
	    $sql = "SELECT * FROM booking WHERE reference = '".$ref."'";
	    $result = mysqli_query($conn, $sql);
	    $rowSQL = mysqli_fetch_assoc($result);
	    
	    $array["book_pax"] = $rowSQL["book_pax"];
	    $array["book_seats"] = $rowSQL["book_rf"] + $rowSQL["book_ff"] + $rowSQL["book_boost"];
	    
	    $pickup = $rowSQL["pickup_addr"];
	    $pickup = strtolower($pickup);
	    
	    if(strpos($pickup, "airport") !== false) {
	        $array["airport"] == "5";
	    } else {
	        $array["airport"] == "0";
	    }
        
        $array["pickup"] = str_replace(",","",$rowSQL["pickup_addr"]);
        $array["dropoff"] = str_replace(",","",$rowSQL["pickoff_addr"]);
	    
	    $date24 = $rowSQL["booking_date"];
	    
        
        $time24 = $rowSQL["booking_time"];
        
	    $array["date"] = date("d/m/Y G:i", strtotime($date24." ".$time24));
	    
	    $finish = strtotime($date24." ".$time24) + $rowSQL["quote_time"] * 60 * 60;
	    $array["finish"] = date("d/m/Y G:i", $finish);
	    $array["dist"] = $rowSQL["quote_km"];
	    
	    $cid = $rowSQL["cid"];
	    $sql = "SELECT * FROM customers WHERE id = ".$cid;
	    $result = $conn->query($sql);
	    $rowSQL = $result->fetch_assoc();
	    
	    $array["phone"] = $rowSQL["mobile"];
	   return $array;
	    
        } else {
            
            return "none";
        }
	    
        }
        
        $bigArray = array(
	0 => array('1561871087538', '0.00', '4.85'),
	1 => array('15619604083346', '0.00', '5.40'),
	2 => array('15617766313763', '0.00', '5.13'),
	3 => array('15573614163096', '0.00', '11.55'),
	4 => array('15603968002079', '0.00', '4.07'),
	5 => array('15617020873403', '0.00', '6.92'),
	6 => array('15615128234297', '0.00', '4.24'),
	7 => array('15619622342722', '0.00', '6.78'),
	8 => array('15619490152085', '0.00', '3.52'),
	9 => array('1561731167152', '0.00', '4.05'),
	10 => array('15601650782582', '0.00', '7.48'),
	11 => array('15605557103102', '0.45', '0.00'),
	12 => array('15616831774148', '0.00', '4.20'),
	13 => array('1562109536669', '0.00', '6.21'),
	14 => array('15620646542764', '0.00', '2.67'),
	15 => array('15605032753689', '0.00', '8.64'),
	16 => array('15610844883180', '0.00', '2.70'),
	17 => array('1555904105212', '0.00', '1.92'),
	18 => array('15621188584478', '0.00', '4.75'),
	19 => array('15590154501114', '0.00', '3.59'),
	20 => array('1561969680346', '0.00', '4.53'),
	21 => array('1562154353178', '0.00', '4.02'),
	22 => array('15618689051836', '0.00', '7.21'),
	23 => array('1562218692622', '0.00', '3.44'),
	24 => array('15621499212307', '0.00', '4.46'),
	25 => array('15610367602143', '0.00', '6.42'),
	26 => array('1561599081567', '0.00', '3.44'),
	27 => array('15619796773957', '0.00', '2.97'),
	28 => array('15567693312056', '0.00', '5.91'),
	29 => array('15622368634813', '0.00', '4.69'),
	30 => array('15621342401918', '0.00', '5.75'),
	31 => array('15620337783367', '0.00', '4.77'),
	32 => array('1562295335938', '0.00', '2.32'),
	33 => array('15618807141914', '0.00', '4.79'),
	34 => array('15623038102762', '0.00', '5.83'),
	35 => array('15607458223708', '0.00', '7.62'),
	36 => array('15596294444471', '0.00', '2.48'),
	37 => array('15622950994202', '0.00', '1.94'),
	38 => array('1561108346547', '0.00', '3.13'),
	39 => array('15621340581045', '0.00', '3.29'),
	40 => array('15622061852883', '0.00', '6.02'),
	41 => array('15615794341274', '0.00', '5.00'),
	42 => array('15602347251145', '0.00', '5.21'),
	43 => array('15524812722024', '0.00', '8.41'),
	44 => array('15622973301514', '0.00', '3.13'),
	45 => array('15623797243281', '0.00', '1.95'),
	46 => array('15607959891338', '0.00', '7.33'),
	47 => array('15623797243282', '0.00', '1.96'),
	48 => array('15624142913228', '0.00', '6.60'),
	49 => array('15623211551128', '0.00', '2.40'),
	50 => array('15622159664757', '0.00', '5.00'),
	51 => array('1561205074565', '0.00', '4.84'),
	52 => array('15624595651483', '0.00', '3.36'),
	53 => array('15624186494365', '0.00', '3.50'),
	54 => array('15621939764951', '0.00', '6.10'),
	55 => array('15619003052047', '0.00', '5.22'),
	56 => array('15621342401919', '0.00', '5.14'),
	57 => array('1556023911939', '0.00', '5.50'),
	58 => array('1553309552271', '0.00', '7.78'),
	59 => array('15625481712071', '0.00', '2.64'),
	60 => array('15624492331625', '0.00', '7.05'),
	61 => array('15625675973224', '0.00', '2.48'),
	62 => array('1562198463252', '0.00', '8.22'),
	63 => array('15624969003553', '0.00', '2.58'),
	64 => array('15612935351532', '0.00', '5.05'),
	65 => array('15625903784734', '0.00', '5.81'),
	66 => array('15624950561115', '0.00', '4.27'),
	67 => array('15619522074176', '0.00', '5.47'),
	68 => array('15627229591638', '0.00', '2.96'),
	69 => array('15627355512926', '0.00', '5.44'),
	70 => array('15626792704091', '0.00', '6.97'),
	71 => array('15598927901571', '0.00', '8.84'),
	72 => array('1562638378233', '0.00', '8.77'),
	73 => array('15530556663741', '0.00', '5.23'),
	74 => array('15621499212308', '0.00', '4.38'),
	75 => array('15601650782583', '0.00', '7.01'),
	76 => array('15623906372130', '0.00', '7.76'),
	77 => array('1562728648192', '0.00', '5.44'),
	78 => array('1562674261505', '0.00', '7.34'),
	79 => array('15626639762692', '0.00', '6.44'),
	80 => array('15619873122813', '0.00', '5.29'),
	81 => array('15627444004895', '0.00', '2.19'),
	82 => array('1562597893401', '0.00', '2.97'),
	83 => array('1562835213230', '0.00', '3.44'),
	84 => array('15605069703662', '0.00', '5.29'),
	85 => array('15622897312831', '0.00', '4.40'),
	86 => array('1559907433120', '0.00', '3.73'),
	87 => array('15629891511777', '0.00', '6.34'),
	88 => array('15629168172169', '0.00', '3.65'),
	89 => array('15629259223883', '0.00', '7.84'),
	90 => array('15629015154108', '0.00', '3.08'),
	91 => array('1561969680347', '0.00', '4.53'),
	92 => array('15629790882823', '0.00', '3.05'),
	93 => array('15625903784735', '0.00', '5.81'),
	94 => array('15627631643476', '0.00', '3.49'),
	95 => array('15607528084120', '0.00', '7.46'),
	96 => array('15618807141915', '0.00', '4.63'),
	97 => array('15567693312057', '0.00', '6.36'),
	98 => array('15629073162016', '0.00', '6.88'),
	99 => array('15624611254419', '0.00', '6.79'),
	100 => array('15615129782231', '0.00', '5.40'),
	101 => array('15632324921369', '0.00', '3.00'),
	102 => array('15626468701150', '0.00', '2.58'),
	103 => array('15620337783368', '0.00', '4.93'),
	104 => array('15618847692043', '0.00', '2.98'),
	105 => array('15631886812986', '0.00', '4.52'),
	106 => array('15563183044458', '0.00', '4.66'),
	107 => array('1563218252546', '0.00', '5.05'),
	108 => array('15631902723409', '0.00', '2.19'),
	109 => array('1563237067511', '0.00', '4.66'),
	110 => array('15630722934112', '0.00', '5.49'),
	111 => array('1563339226719', '0.00', '1.98'),
	112 => array('15632648152115', '0.00', '6.80'),
	113 => array('15620569433792', '0.00', '5.76'),
	114 => array('1563346576653', '0.00', '8.74'),
	115 => array('15596294444472', '0.00', '2.53'),
	116 => array('15630903454307', '0.00', '4.88'),
	117 => array('15629282684969', '0.00', '6.63'),
	118 => array('15630113341871', '0.00', '5.75'),
	119 => array('15633594083940', '0.00', '10.32'),
	120 => array('15629868973518', '0.00', '4.64'),
	121 => array('15619873122814', '0.00', '5.42'),
	122 => array('15633730981240', '0.00', '5.60'),
	123 => array('15632861591982', '0.00', '5.68'),
	124 => array('15634081521319', '0.00', '5.60'),
	125 => array('15629073162017', '0.00', '6.60'),
	126 => array('15630601723965', '0.00', '5.00'),
	127 => array('15612948883940', '0.00', '5.18'),
	128 => array('15634373844199', '0.00', '2.53'),
	129 => array('15633529663387', '0.00', '6.58'),
	130 => array('1535740322652', '1.36', '0.00'),
	131 => array('15631959721054', '0.00', '3.65'),
	132 => array('15530567163957', '0.00', '8.01'),
	133 => array('15625046273472', '0.00', '4.33'),
	134 => array('15633475074030', '0.00', '3.31'),
	135 => array('15633529663386', '0.00', '3.75'),
	136 => array('15635027053205', '0.00', '3.23'),
	137 => array('15624969003554', '0.00', '3.00'),
	138 => array('156360644388', '0.00', '8.98'),
	139 => array('156367145310', '0.00', '7.22'),
	140 => array('1563667800300', '0.00', '4.00'),
	141 => array('1563589602605', '0.00', '4.02'),
	142 => array('15635689693856', '0.00', '6.68'),
	143 => array('15626792704092', '0.00', '6.81'),
	144 => array('15636288212512', '0.00', '2.90'),
	145 => array('1562589367741', '0.00', '4.40'),
	146 => array('15623908673794', '0.00', '7.32'),
	147 => array('1563531810848', '0.00', '2.82'),
	148 => array('15635239363105', '0.00', '3.35'),
	149 => array('15615129782232', '0.00', '5.52'),
	150 => array('15638811551519', '0.00', '5.18'),
	151 => array('15638944254753', '0.00', '4.82'),
	152 => array('15627245853906', '0.00', '2.66'),
	153 => array('15610856274319', '0.00', '5.64'),
	154 => array('15637085114407', '0.00', '4.22'),
	155 => array('1562219013986', '0.00', '3.65'),
	156 => array('1561707676205', '0.00', '6.36'),
	157 => array('15640328394136', '0.00', '1.98'),
	158 => array('15640248421310', '0.00', '4.82'),
	159 => array('15640453821612', '0.00', '4.00'),
	160 => array('15641033211680', '0.00', '5.07'),
	161 => array('15641402362903', '0.00', '4.82'),
	162 => array('15641429823653', '0.00', '4.98'),
	163 => array('15639532104169', '0.00', '3.60'),
	164 => array('15630903454308', '0.00', '4.72'),
	165 => array('15640493392870', '0.00', '3.67'),
	166 => array('15637909611578', '0.00', '2.61'),
	167 => array('1564207853529', '0.00', '5.18'),
	168 => array('1560838843829', '0.00', '3.29'),
	169 => array('15640175904546', '0.00', '4.25'),
	170 => array('1564186321576', '0.00', '2.37'),
	171 => array('15384681952034', '0.00', '3.79'),
	172 => array('15633477212516', '0.00', '3.39'),
	173 => array('15637916294428', '0.00', '3.55'),
	174 => array('1564376944139', '0.00', '3.57'),
	175 => array('15642895282446', '0.00', '11.36'),
	176 => array('15642895282447', '0.00', '7.65'),
	177 => array('15639532104170', '0.00', '4.19'),
	178 => array('15643219424064', '0.00', '6.37'),
	179 => array('1560838843830', '0.00', '3.29'),
	180 => array('15644780712204', '0.00', '2.44'),
	181 => array('15646111862332', '0.00', '6.71'),
	182 => array('1564617518327', '0.00', '5.84'),
	183 => array('1564288771260', '0.00', '5.70'),
	184 => array('15593728853886', '0.00', '6.61'),
	185 => array('15645313933537', '0.00', '6.68'),
	186 => array('15640539664324', '0.00', '3.99'),
	187 => array('1562110286529', '0.00', '8.63'),
	188 => array('15638656431334', '0.00', '2.91'),
	189 => array('15645465473464', '0.00', '3.65'),
	190 => array('15620569433793', '0.00', '5.60'),
	191 => array('', '0.00', '10.00'),
	192 => array('15645744472576', '0.00', '4.97'),
	193 => array('15648149133423', '0.00', '2.08'),
	194 => array('155987774697', '0.00', '6.63'),
	195 => array('15648149133424', '0.00', '1.88'),
	196 => array('15649112131161', '0.00', '4.09'),
	197 => array('15622159664758', '0.00', '5.14'),
	198 => array('15593728853887', '0.00', '2.82'),
	199 => array('15649008491442', '0.00', '6.08'),
	200 => array('15640539664325', '0.00', '4.12'),
	201 => array('15641033483828', '0.00', '5.32'),
	202 => array('15642923833369', '0.00', '2.83'),
	203 => array('15648087283531', '0.00', '5.08'),
	204 => array('1565065691213', '0.00', '2.61'),
	205 => array('15649051294886', '0.00', '6.02'),
	206 => array('1565063270364', '0.00', '9.99'),
	207 => array('15650067751295', '0.00', '4.05'),
	208 => array('15650038993443', '0.00', '3.68'),
	209 => array('15646335663474', '0.00', '2.53'),
	210 => array('15651422734256', '0.00', '1.95'),
	211 => array('15651666861290', '0.00', '6.07'),
	212 => array('15591391301315', '0.00', '6.19'),
	213 => array('15649055323560', '0.00', '4.24'),
	214 => array('15623844872225', '0.00', '6.78'),
	215 => array('15651639722756', '0.00', '6.47'),
	216 => array('15652190234434', '0.00', '6.75'),
	217 => array('15624882262736', '0.00', '7.05'),
	218 => array('15627738084175', '0.00', '4.17'),
	219 => array('15652393302561', '0.00', '10.77'),
	220 => array('15637706402077', '0.00', '5.00'),
	221 => array('15651898251346', '0.00', '3.73'),
	222 => array('15653133224039', '0.00', '4.51'),
	223 => array('1564195519789', '0.00', '2.44'),
	224 => array('1562110286530', '0.00', '7.38'),
	225 => array('15651851202611', '0.00', '2.61'),
	226 => array('15642080642612', '0.00', '5.77'),
	227 => array('15651513662438', '0.00', '2.82'),
	228 => array('15654314623994', '0.00', '6.35'),
	229 => array('15650581104954', '0.00', '4.92'),
	230 => array('15651347514372', '0.00', '3.73'),
	231 => array('15654133083724', '0.00', '6.43'),
	232 => array('15545522924435', '0.00', '2.94'),
	233 => array('15627738084174', '0.00', '3.75'),
	234 => array('15654950224648', '0.00', '5.99'),
	235 => array('1564288771261', '0.00', '6.27'),
	236 => array('15651817271321', '0.00', '5.06'),
	237 => array('15653346571755', '0.00', '3.65'),
	238 => array('15650040344793', '0.00', '3.52'),
	239 => array('15654295761109', '0.00', '1.43'),
	240 => array('15652703471028', '0.00', '3.00'),
	241 => array('15655832913087', '0.00', '14.70'),
	242 => array('15654160151051', '0.00', '1.46'),
	243 => array('1565241165157', '0.00', '5.45'),
	244 => array('1565063270365', '0.00', '9.91'),
	245 => array('15655455602371', '0.00', '4.02'),
	246 => array('15656668224585', '0.00', '3.81'),
	247 => array('1565522137392', '0.00', '4.56'),
	248 => array('15656086013585', '0.00', '3.62'),
	249 => array('15653038194388', '0.00', '9.06'),
	250 => array('15640175904547', '0.00', '5.11'),
	251 => array('1565737042439', '0.00', '3.32'),
	252 => array('15652718153510', '0.00', '3.54'),
	253 => array('15656931314079', '0.00', '3.44'),
	254 => array('15659076464336', '0.00', '3.65'),
	255 => array('15648199422095', '0.00', '4.61'),
	256 => array('15640569814673', '0.00', '2.73'),
	257 => array('15656750483002', '0.00', '4.64'),
	258 => array('15656975293953', '0.00', '1.97'),
	259 => array('15652718153509', '0.00', '3.25'),
	260 => array('15657529654016', '0.00', '5.53'),
	261 => array('15659021882941', '0.00', '3.73'),
	262 => array('15660308391453', '0.00', '4.20'),
	263 => array('15656741271296', '0.00', '8.99'),
	264 => array('15545522924436', '0.00', '2.68'),
	265 => array('15659269001853', '0.00', '3.18'),
	266 => array('1565879386329', '0.00', '6.26'),
	267 => array('15638656431335', '0.00', '2.48'),
	268 => array('15660246462057', '0.00', '2.45'),
	269 => array('15651851202612', '0.00', '3.41'),
	270 => array('15660246462058', '0.00', '2.45'),
	271 => array('15660205813952', '0.00', '3.00'),
	272 => array('15661760791190', '0.00', '4.51'),
	273 => array('1565006658951', '0.00', '5.89'),
	274 => array('15660809534593', '0.00', '3.89'),
	275 => array('1566297930365', '0.00', '7.17'),
	276 => array('15648976534025', '0.00', '5.22'),
	277 => array('15541884813596', '0.00', '2.27'),
	278 => array('15641033483829', '0.00', '5.24'),
	279 => array('15648118132502', '0.00', '4.46'),
	280 => array('15660809534594', '0.00', '3.73'),
	281 => array('15664632254722', '0.00', '3.96'),
	282 => array('15663668384123', '0.00', '4.66'),
	283 => array('1566375781393', '0.00', '2.73'),
	284 => array('15664871134121', '0.00', '4.25'),
	285 => array('15662963441969', '0.00', '3.55'),
	286 => array('15621429862695', '0.00', '4.55'),
	287 => array('15628048371960', '0.00', '3.21'),
	288 => array('15654291063707', '0.00', '7.59'),
	289 => array('15659317893107', '0.00', '4.53'),
	290 => array('15629191913890', '0.00', '3.55'),
	291 => array('15664160934767', '0.00', '4.61'),
	292 => array('15643520412058', '0.00', '6.86'),
	293 => array('1566479582867', '0.00', '3.91'),
	294 => array('15665453024919', '0.00', '6.17'),
	295 => array('1566630545228', '0.00', '6.20'),
	296 => array('15668109103817', '0.00', '5.11'),
	297 => array('15662963441970', '0.00', '3.26'),
	298 => array('1563523919483', '0.00', '3.64'),
	299 => array('1564955886997', '0.00', '4.98'),
	300 => array('15665313633428', '0.00', '4.27'),
	301 => array('1565703410873', '0.00', '5.21'),
	302 => array('15667261212009', '0.00', '4.48'),
	303 => array('15668741141039', '0.00', '3.39'),
	304 => array('15635051493872', '0.00', '8.19'),
	305 => array('15667282122016', '0.00', '7.55'),
	306 => array('15608254683946', '0.00', '9.68'),
	307 => array('15666437024717', '0.00', '2.90'),
	308 => array('15655151373765', '0.00', '5.06'),
	309 => array('15654291063708', '0.00', '7.35'),
	310 => array('15667254972252', '0.00', '5.89'),
	311 => array('15671172683233', '0.00', '7.30'),
	312 => array('15541886594854', '0.00', '2.10'),
	313 => array('1564962086468', '0.00', '5.32'),
	314 => array('15671976501989', '0.00', '3.34'),
	315 => array('15672345682290', '0.00', '1.73'),
	316 => array('15608254683947', '0.00', '9.68'),
	317 => array('1566956215918', '0.00', '6.89'),
	318 => array('15673115924985', '0.00', '1.48'),
	319 => array('15667046401105', '0.00', '7.41'),
	320 => array('15672351193897', '0.00', '4.05'),
	321 => array('15673054712786', '0.00', '9.33'),
	322 => array('1565589980921', '0.00', '9.66'),
	323 => array('15671491412692', '0.00', '5.45'),
	324 => array('15665404915000', '0.00', '5.34'),
	325 => array('15670837601679', '0.00', '4.29'),
	326 => array('15661313951250', '0.00', '1.47'),
	327 => array('1565589980922', '0.00', '10.00'),
	328 => array('15673225614225', '0.00', '1.46'),
	329 => array('1567310291506', '0.00', '1.46'),
	330 => array('15673877482104', '0.00', '5.32'),
	331 => array('15672197873127', '0.00', '2.77'),
	332 => array('1566879502479', '0.00', '3.65'),
	333 => array('15673924571477', '0.00', '5.62'),
	334 => array('15668052034310', '0.00', '2.27'),
	335 => array('15674119062240', '0.00', '1.52'),
	336 => array('15668725833462', '0.00', '4.82'),
	337 => array('15674144062330', '0.00', '4.92'),
	338 => array('15668052034311', '0.00', '1.92'),
	339 => array('1567471865597', '0.00', '3.52'),
	340 => array('15673926992706', '0.00', '4.53'),
	341 => array('15637741243034', '0.00', '3.57'),
	342 => array('15675660122575', '0.00', '3.65'),
	343 => array('15668125993398', '0.00', '6.21'),
	344 => array('15675075123571', '0.00', '7.41'),
	345 => array('15668125993397', '0.00', '5.05'),
	346 => array('15675517154054', '0.00', '6.66'),
	347 => array('15672850864467', '0.00', '5.81'),
	348 => array('15672224174297', '0.00', '5.13'),
	349 => array('15670961633333', '0.00', '3.46'),
	350 => array('15675506952117', '0.00', '4.53'),
	351 => array('15676442904477', '0.00', '6.61'),
	352 => array('15677492261801', '0.00', '2.53'),
	353 => array('15670552014273', '0.00', '3.73'),
	354 => array('1567740840764', '0.00', '3.68'),
	355 => array('1567772257367', '0.00', '2.45'),
	356 => array('15677317343585', '0.00', '2.53'),
	357 => array('155987774698', '0.00', '6.84'),
	358 => array('15674730092067', '0.00', '2.74'),
	359 => array('15674713061572', '0.00', '6.51'),
	360 => array('15676781544496', '0.00', '4.11'),
	361 => array('1567382201650', '0.00', '4.15'),
	362 => array('15677522861954', '0.00', '6.60'),
	363 => array('15675506952118', '0.00', '4.02'),
	364 => array('15677531763204', '0.00', '4.69'),
	365 => array('15669518882631', '0.00', '1.59'),
	366 => array('15649051294887', '0.00', '6.02'),
	367 => array('15679176533311', '0.00', '2.80'),
	368 => array('15674863654439', '0.00', '3.73'),
	369 => array('15678041412277', '0.00', '2.38'),
	370 => array('15677574903752', '0.00', '6.97'),
	371 => array('15679276044313', '0.00', '2.80'),
	372 => array('15668725833463', '0.00', '7.11'),
	373 => array('15679891853809', '0.00', '4.79'),
	374 => array('15675766801228', '0.00', '2.89'),
	375 => array('15675766801227', '0.00', '1.98'),
	376 => array('1567582422303', '0.00', '4.56'),
	377 => array('15677253832053', '0.00', '4.50'),
	378 => array('15680984094320', '0.00', '3.44'),
	379 => array('15680944504719', '0.00', '6.55'),
	380 => array('15678435201725', '0.00', '5.42'),
	381 => array('15679120043067', '0.00', '4.00'),
	382 => array('1567963017147', '0.00', '4.10'),
	383 => array('1567285218787', '0.00', '5.81'),
	384 => array('15674713061573', '0.00', '6.43'),
	385 => array('15681060761644', '0.00', '3.73'),
	386 => array('15682832934617', '0.00', '2.48'),
	387 => array('15677374741086', '0.00', '5.09'),
	388 => array('15680700464802', '0.00', '3.39'),
	389 => array('15681759922251', '0.00', '4.30'),
	390 => array('15679325402929', '0.00', '6.07'),
	391 => array('15675079434642', '0.00', '5.86'),
	392 => array('1567572580581', '0.00', '2.27'),
	393 => array('15678204732029', '0.00', '4.42'),
	394 => array('15682536834582', '0.00', '2.56'),
	395 => array('15683510992964', '0.00', '3.94'),
	396 => array('15683422222406', '0.00', '4.90'),
	397 => array('15682947702240', '0.00', '3.89'),
	398 => array('1566808107958', '0.00', '3.40'),
	399 => array('15682061093670', '0.00', '2.71'),
	400 => array('15679447603042', '0.00', '5.07'),
	401 => array('15681225024685', '0.00', '6.80'),
	402 => array('15672923294957', '0.00', '5.40'),
	403 => array('15683106744534', '0.00', '6.47'),
	404 => array('15684480613192', '0.00', '1.46'),
	405 => array('1564955886998', '0.00', '4.98'),
	406 => array('15683821612499', '0.00', '4.86'),
	407 => array('15683790643636', '0.00', '2.32'),
	408 => array('15684422714122', '0.00', '3.34'),
	409 => array('1567989684204', '0.00', '3.61'),
	410 => array('15684207293000', '0.00', '6.01'),
	411 => array('15684319364240', '0.00', '1.47'),
	412 => array('15665404915001', '0.00', '5.26'),
	413 => array('15684576361378', '0.00', '4.02'),
	414 => array('156811964890', '0.00', '4.20'),
	415 => array('15683627082976', '0.00', '7.66'),
	416 => array('15679970793924', '0.00', '2.53'),
	417 => array('15684397091665', '0.00', '3.64'),
	418 => array('15674907903839', '0.00', '3.18'),
	419 => array('15685502733591', '0.00', '4.43'),
	420 => array('15676566093340', '0.00', '4.32'),
	421 => array('1568591156756', '0.00', '6.16'),
	422 => array('15685360264647', '0.00', '9.18'),
	423 => array('1568587703315', '0.00', '3.81'),
	424 => array('1554909008618', '0.00', '7.78'),
	425 => array('15677531763205', '0.00', '3.89'),
	426 => array('1568534293223', '0.00', '4.43'),
	427 => array('15685086904162', '0.00', '5.53'),
	428 => array('15681050003678', '0.00', '9.09'),
	429 => array('15685086904161', '0.00', '4.80'),
	430 => array('15683578541097', '0.00', '4.35'),
	431 => array('15674055992804', '0.00', '6.97'),
	432 => array('15687326183518', '0.00', '2.82'),
	433 => array('15684631394266', '0.00', '6.45'),
	434 => array('15687928124711', '0.00', '3.65'),
	435 => array('15682365004809', '0.00', '4.08'),
	436 => array('15686304582169', '0.00', '3.21'),
	437 => array('15687726561946', '0.00', '4.66'),
	438 => array('1568002184846', '0.00', '2.90'),
	439 => array('15688091542240', '0.00', '3.04'),
	440 => array('1568656476135', '0.00', '4.45'),
	441 => array('15656741271297', '0.00', '8.26'),
	442 => array('15682939403751', '0.00', '8.39'),
	443 => array('15689328652480', '0.00', '4.30'),
	444 => array('15685269754289', '0.00', '4.77'),
	445 => array('15687720972232', '0.00', '6.96'),
	446 => array('15688146781536', '0.00', '4.48'),
	447 => array('15689546731060', '0.00', '3.07'),
	448 => array('1568528354314', '0.00', '5.99'),
	449 => array('15689893013286', '0.00', '4.84'),
	450 => array('15690319052853', '0.00', '5.57'),
	451 => array('15667254972253', '0.00', '5.76'),
	452 => array('156811964891', '0.00', '5.00'),
	453 => array('1568986435107', '0.00', '2.07'),
	454 => array('15685573262462', '0.00', '4.77'),
	455 => array('15690412093637', '0.00', '5.38'),
	456 => array('15691423261173', '0.00', '4.48'),
	457 => array('15690673014722', '0.00', '2.48'),
	458 => array('15687685911815', '0.00', '3.05'),
	459 => array('15691906892032', '0.00', '3.75'),
	460 => array('15683267123006', '0.00', '4.98'),
	461 => array('15691951464721', '0.00', '4.89'),
	462 => array('15693030761325', '0.00', '6.39'),
	463 => array('15692399962911', '0.00', '6.45'),
	464 => array('1568625957912', '0.00', '6.75'),
	465 => array('15690597614285', '0.00', '3.89'),
	466 => array('15674068373810', '0.00', '9.57'),
	467 => array('15692325633786', '0.00', '4.58'),
	468 => array('15691525371149', '0.00', '5.06'),
	469 => array('1566860931376', '0.00', '2.98'),
	470 => array('1568777749699', '0.00', '8.06'),
	471 => array('15691977332641', '0.00', '4.49'),
	472 => array('15693271122329', '0.00', '2.45'),
	473 => array('15693794323706', '0.00', '2.50'),
	474 => array('15688692871415', '0.00', '4.69'),
	475 => array('15692079753958', '0.00', '3.00'),
	476 => array('15670475214923', '0.00', '6.96'),
	477 => array('15688777704239', '0.00', '3.02'),
	478 => array('15693830031980', '0.00', '4.77'),
	479 => array('1568702480890', '0.00', '3.57'),
	480 => array('15687879534006', '0.00', '7.88'),
	481 => array('15686262883543', '0.00', '3.41'),
	482 => array('15691305044352', '0.00', '6.36'),
	483 => array('1566860931377', '0.00', '3.52'),
	484 => array('15692677782358', '0.00', '3.92'),
	485 => array('15694161473548', '0.00', '3.23'),
	486 => array('15693829303829', '0.00', '5.00'),
	487 => array('15694648642626', '0.00', '4.05'),
	488 => array('15690412093638', '0.00', '4.85'),
	489 => array('15694195311080', '0.00', '5.26'),
	490 => array('1569563874876', '0.00', '1.43'),
	491 => array('1569534651758', '0.00', '1.87'),
	492 => array('15694175642097', '0.00', '2.32'),
	493 => array('15690667483968', '0.00', '3.15'),
	494 => array('15695600181700', '0.00', '1.88'),
	495 => array('15686262883544', '0.00', '4.20'),
	496 => array('15694963033737', '0.00', '5.46'),
	497 => array('15692183554360', '0.00', '5.11'),
	498 => array('1554909008619', '0.00', '9.00'),
	499 => array('15696407434945', '0.00', '1.88'),
	500 => array('15696267624131', '0.00', '2.70'),
	501 => array('15656216801199', '0.00', '6.48'),
	502 => array('15671733752208', '0.00', '2.27'),
	503 => array('15646608194674', '0.00', '2.95'),
	504 => array('15689929601220', '0.00', '5.35'),
	505 => array('15695647804952', '0.00', '1.88'),
	506 => array('1569637536881', '0.00', '4.20'),
	507 => array('15696434712241', '0.00', '1.88'),
	508 => array('15688692871416', '0.00', '4.69'),
	509 => array('15671172683234', '0.00', '8.54'),
	510 => array('15697529603471', '0.00', '5.91'),
	511 => array('15687685911816', '0.00', '2.91'),
	512 => array('15672351193898', '0.00', '3.97'),
	513 => array('15697222282806', '0.00', '1.88'),
	514 => array('15691505831985', '0.00', '3.84'),
	515 => array('15693475752603', '0.00', '6.13'),
	516 => array('1568019739650', '0.00', '3.37'),
	517 => array('15691094264207', '0.00', '4.74'),
	518 => array('15695785071556', '0.00', '4.88'),
	519 => array('15697526091023', '0.00', '1.88'),
	520 => array('15697526091022', '0.00', '1.88'),
	521 => array('1568002184847', '0.00', '3.05'),
	522 => array('15697201811849', '0.00', '3.29'),
	523 => array('#43153', '18.70', '0.00'),
	524 => array('1566950057655', '0.00', '10.00'),
);
        
       $message = "
       
       <!DOCTYPE html>
	<html lang='en'>
       <head><meta http-equiv='Content-Type' content='text/html; charset=utf-8'>
       
    <meta http-equiv='X-UA-Compatible' content='IE=edge'>
    
    <meta name='viewport' content='width=device-width, initial-scale=1'>
    
    <title>Daily 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>";
       
        foreach($bigArray as $row) {
            
            $A = checkWeb($row[0]);
            $levy = $row[2];
                    if($levy > 10) {
                        $levy = 10;
                    }
            
            if($A == "none") {
                $A = checkApp($row[0]);
                if($A == "none") {
                    $line = $row[0].",,,,,,,,,,,,,,,,,,,,,,,,,,,,<br>";
                    
                } else {
                    if($A["book_pax"] > 4) {
                        $km = 2.2;
                    } else {
                        $km = 1.3;
                    }
                    $child = $A["book_seats"] * 5 + 15;
                    $GST = ($A["amount"] - $levy)/11;
                    $levyable = $A["amount"] - $levy - $child - $A["airport"];
                    $mins = ($levyable - ($A["dist"] * $km))/0.8;
                    $d = date_create_from_format("d/m/Y G:i", $A["date"]);
                    $date24 = date_format($d, "Y-m-d G:i");   
                    error_log(strtotime($date24)." + ".($mins * 60 * 1000));
                    $finish = date("d/m/Y G:i", strtotime($date24) + ($mins * 60 ));
                    $line = $row[0].",".$A['date'].",".$A["phone"].",".$A["plate"].",N,".$A["licence"].",".$A["driver"].",".$A['date'].",".$A["pickup"].",".$finish.",".$A["dropoff"].",".$A["dist"].",0,".$A["amount"].",".$GST.",".$A["airport"].",0,0,".$child.",0,".$levy.",0,0,".$levyable.",".$levy.",".$km.",0.8<br>";
                }
            } else {
            if($A["book_pax"] > 4) {
                $km = 2.2;
            } else {
                $km = 1.3;
            }
            $child = ($A["book_seats"] - 1) * 5 + 15;
            $GST = ($A["amount"] - $levy)/11;
            $levyable = $A["amount"] - $levy - $child - $A["airport"];
            $mins = round(($levyable - ($A["dist"] * $km))/0.8);
            $d = date_create_from_format("d/m/Y G:i", $A["date"]);
                    $date24 = date_format($d, "Y-m-d G:i");   
                    error_log(strtotime($date24)." + ".($mins * 60 * 1000));
                    $finish = date("d/m/Y G:i", strtotime($date24) + ($mins * 60));
            $line = $row[0].",".$A['date'].",".$A["phone"].",".$A["plate"].",N,".$A["licence"].",".$A["driver"].",".$A['date'].",".$A["pickup"].",".$finish.",".$A["dropoff"].",".$A["dist"].",0,".$A["amount"].",".$GST.",".$A["airport"].",0,0,".$child.",0,".$levy.",0,0,".$levyable.",".$levy.",".$km.",0.8<br>";
            }
            echo $line;
            //"..",<br>";
                
        }
        echo "</body></html>";
        
        echo $message;

connect_error); $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname); $query1 = "SELECT * FROM invoices WHERE reference='".$ref."'"; $result = mysqli_query($conn, $query1); if($result->num_rows > 0) { $rowSQL = mysqli_fetch_assoc($result); $array = array(); $array["amount"] = $rowSQL["amount"]; $array["driver"] = $rowSQL["driver"]; if($rowSQL["driver"] == "Michael Bowen" OR $rowSQL["driver"] == "Devinder Uppal") { $array["plate"] = "1GCP191"; } else { $array["plate"] = "1GGM897"; } $array["licence"] = driversLicence($rowSQL["driver"]); $sql = "SELECT * FROM jobs WHERE reference = '".$ref."'"; $result = mysqli_query($conn, $sql); $rowSQL = mysqli_fetch_assoc($result); $array["book_pax"] = $rowSQL["job_pax"]; $array["book_seats"] = $rowSQL["job_rf"] + $rowSQL["job_ff"] + $rowSQL["job_boost"]; $pickup = $rowSQL["job_pickup"]; $pickup = strtolower($pickup); if(strpos($pickup, 'airport') !== false) { $array["airport"] == "5"; } else { $array["airport"] == "0"; } $array["pickup"] = str_replace(",","",$rowSQL["job_pickup"]); $array["dropoff"] = str_replace(",","",$rowSQL["job_dropoff"]); $booking_date = $rowSQL["job_date"]; $d = date_create_from_format("jS M, Y", $booking_date); $date24 = date_format($d, "Y-m-d"); $booking_time = $rowSQL["job_time"]; $time24 = date("G:i", strtotime($booking_time)); $array["date"] = date("d/m/Y G:i", strtotime($date24." ".$time24)); $quote_time = $rowSQL["quote_time"]; if($quote_time == "") { $quote_time = 15; } $finish = strtotime($date24." ".$time24) + $quote_time * 60 * 60; $array["finish"] = date("d/m/Y G:i", $finish); $array["dist"] = $rowSQL["quote_km"]; $array["phone"] = $rowSQL["job_phone"]; return $array; } else { return "none"; } } function checkApp($ref) { $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); $query = "SELECT * FROM invoices WHERE reference='".$ref."'"; $result = mysqli_query($conn, $query); if($result->num_rows > 0) { $rowSQL = mysqli_fetch_assoc($result); $array["amount"] = $rowSQL["amount"]; $array["driver"] = $rowSQL["driver"]; if($rowSQL["driver"] == "Michael Bowen" OR $rowSQL["driver"] == "Devinder Uppal") { $array["plate"] = "1GCP191"; } else { $array["plate"] = "1GGM897"; } $array["licence"] = driversLicence($rowSQL["driver"]); $sql = "SELECT * FROM booking WHERE reference = '".$ref."'"; $result = mysqli_query($conn, $sql); $rowSQL = mysqli_fetch_assoc($result); $array["book_pax"] = $rowSQL["book_pax"]; $array["book_seats"] = $rowSQL["book_rf"] + $rowSQL["book_ff"] + $rowSQL["book_boost"]; $pickup = $rowSQL["pickup_addr"]; $pickup = strtolower($pickup); if(strpos($pickup, "airport") !== false) { $array["airport"] == "5"; } else { $array["airport"] == "0"; } $array["pickup"] = str_replace(",","",$rowSQL["pickup_addr"]); $array["dropoff"] = str_replace(",","",$rowSQL["pickoff_addr"]); $date24 = $rowSQL["booking_date"]; $time24 = $rowSQL["booking_time"]; $array["date"] = date("d/m/Y G:i", strtotime($date24." ".$time24)); $finish = strtotime($date24." ".$time24) + $rowSQL["quote_time"] * 60 * 60; $array["finish"] = date("d/m/Y G:i", $finish); $array["dist"] = $rowSQL["quote_km"]; $cid = $rowSQL["cid"]; $sql = "SELECT * FROM customers WHERE id = ".$cid; $result = $conn->query($sql); $rowSQL = $result->fetch_assoc(); $array["phone"] = $rowSQL["mobile"]; return $array; } else { return "none"; } } $bigArray = array( 0 => array('1561871087538', '0.00', '4.85'), 1 => array('15619604083346', '0.00', '5.40'), 2 => array('15617766313763', '0.00', '5.13'), 3 => array('15573614163096', '0.00', '11.55'), 4 => array('15603968002079', '0.00', '4.07'), 5 => array('15617020873403', '0.00', '6.92'), 6 => array('15615128234297', '0.00', '4.24'), 7 => array('15619622342722', '0.00', '6.78'), 8 => array('15619490152085', '0.00', '3.52'), 9 => array('1561731167152', '0.00', '4.05'), 10 => array('15601650782582', '0.00', '7.48'), 11 => array('15605557103102', '0.45', '0.00'), 12 => array('15616831774148', '0.00', '4.20'), 13 => array('1562109536669', '0.00', '6.21'), 14 => array('15620646542764', '0.00', '2.67'), 15 => array('15605032753689', '0.00', '8.64'), 16 => array('15610844883180', '0.00', '2.70'), 17 => array('1555904105212', '0.00', '1.92'), 18 => array('15621188584478', '0.00', '4.75'), 19 => array('15590154501114', '0.00', '3.59'), 20 => array('1561969680346', '0.00', '4.53'), 21 => array('1562154353178', '0.00', '4.02'), 22 => array('15618689051836', '0.00', '7.21'), 23 => array('1562218692622', '0.00', '3.44'), 24 => array('15621499212307', '0.00', '4.46'), 25 => array('15610367602143', '0.00', '6.42'), 26 => array('1561599081567', '0.00', '3.44'), 27 => array('15619796773957', '0.00', '2.97'), 28 => array('15567693312056', '0.00', '5.91'), 29 => array('15622368634813', '0.00', '4.69'), 30 => array('15621342401918', '0.00', '5.75'), 31 => array('15620337783367', '0.00', '4.77'), 32 => array('1562295335938', '0.00', '2.32'), 33 => array('15618807141914', '0.00', '4.79'), 34 => array('15623038102762', '0.00', '5.83'), 35 => array('15607458223708', '0.00', '7.62'), 36 => array('15596294444471', '0.00', '2.48'), 37 => array('15622950994202', '0.00', '1.94'), 38 => array('1561108346547', '0.00', '3.13'), 39 => array('15621340581045', '0.00', '3.29'), 40 => array('15622061852883', '0.00', '6.02'), 41 => array('15615794341274', '0.00', '5.00'), 42 => array('15602347251145', '0.00', '5.21'), 43 => array('15524812722024', '0.00', '8.41'), 44 => array('15622973301514', '0.00', '3.13'), 45 => array('15623797243281', '0.00', '1.95'), 46 => array('15607959891338', '0.00', '7.33'), 47 => array('15623797243282', '0.00', '1.96'), 48 => array('15624142913228', '0.00', '6.60'), 49 => array('15623211551128', '0.00', '2.40'), 50 => array('15622159664757', '0.00', '5.00'), 51 => array('1561205074565', '0.00', '4.84'), 52 => array('15624595651483', '0.00', '3.36'), 53 => array('15624186494365', '0.00', '3.50'), 54 => array('15621939764951', '0.00', '6.10'), 55 => array('15619003052047', '0.00', '5.22'), 56 => array('15621342401919', '0.00', '5.14'), 57 => array('1556023911939', '0.00', '5.50'), 58 => array('1553309552271', '0.00', '7.78'), 59 => array('15625481712071', '0.00', '2.64'), 60 => array('15624492331625', '0.00', '7.05'), 61 => array('15625675973224', '0.00', '2.48'), 62 => array('1562198463252', '0.00', '8.22'), 63 => array('15624969003553', '0.00', '2.58'), 64 => array('15612935351532', '0.00', '5.05'), 65 => array('15625903784734', '0.00', '5.81'), 66 => array('15624950561115', '0.00', '4.27'), 67 => array('15619522074176', '0.00', '5.47'), 68 => array('15627229591638', '0.00', '2.96'), 69 => array('15627355512926', '0.00', '5.44'), 70 => array('15626792704091', '0.00', '6.97'), 71 => array('15598927901571', '0.00', '8.84'), 72 => array('1562638378233', '0.00', '8.77'), 73 => array('15530556663741', '0.00', '5.23'), 74 => array('15621499212308', '0.00', '4.38'), 75 => array('15601650782583', '0.00', '7.01'), 76 => array('15623906372130', '0.00', '7.76'), 77 => array('1562728648192', '0.00', '5.44'), 78 => array('1562674261505', '0.00', '7.34'), 79 => array('15626639762692', '0.00', '6.44'), 80 => array('15619873122813', '0.00', '5.29'), 81 => array('15627444004895', '0.00', '2.19'), 82 => array('1562597893401', '0.00', '2.97'), 83 => array('1562835213230', '0.00', '3.44'), 84 => array('15605069703662', '0.00', '5.29'), 85 => array('15622897312831', '0.00', '4.40'), 86 => array('1559907433120', '0.00', '3.73'), 87 => array('15629891511777', '0.00', '6.34'), 88 => array('15629168172169', '0.00', '3.65'), 89 => array('15629259223883', '0.00', '7.84'), 90 => array('15629015154108', '0.00', '3.08'), 91 => array('1561969680347', '0.00', '4.53'), 92 => array('15629790882823', '0.00', '3.05'), 93 => array('15625903784735', '0.00', '5.81'), 94 => array('15627631643476', '0.00', '3.49'), 95 => array('15607528084120', '0.00', '7.46'), 96 => array('15618807141915', '0.00', '4.63'), 97 => array('15567693312057', '0.00', '6.36'), 98 => array('15629073162016', '0.00', '6.88'), 99 => array('15624611254419', '0.00', '6.79'), 100 => array('15615129782231', '0.00', '5.40'), 101 => array('15632324921369', '0.00', '3.00'), 102 => array('15626468701150', '0.00', '2.58'), 103 => array('15620337783368', '0.00', '4.93'), 104 => array('15618847692043', '0.00', '2.98'), 105 => array('15631886812986', '0.00', '4.52'), 106 => array('15563183044458', '0.00', '4.66'), 107 => array('1563218252546', '0.00', '5.05'), 108 => array('15631902723409', '0.00', '2.19'), 109 => array('1563237067511', '0.00', '4.66'), 110 => array('15630722934112', '0.00', '5.49'), 111 => array('1563339226719', '0.00', '1.98'), 112 => array('15632648152115', '0.00', '6.80'), 113 => array('15620569433792', '0.00', '5.76'), 114 => array('1563346576653', '0.00', '8.74'), 115 => array('15596294444472', '0.00', '2.53'), 116 => array('15630903454307', '0.00', '4.88'), 117 => array('15629282684969', '0.00', '6.63'), 118 => array('15630113341871', '0.00', '5.75'), 119 => array('15633594083940', '0.00', '10.32'), 120 => array('15629868973518', '0.00', '4.64'), 121 => array('15619873122814', '0.00', '5.42'), 122 => array('15633730981240', '0.00', '5.60'), 123 => array('15632861591982', '0.00', '5.68'), 124 => array('15634081521319', '0.00', '5.60'), 125 => array('15629073162017', '0.00', '6.60'), 126 => array('15630601723965', '0.00', '5.00'), 127 => array('15612948883940', '0.00', '5.18'), 128 => array('15634373844199', '0.00', '2.53'), 129 => array('15633529663387', '0.00', '6.58'), 130 => array('1535740322652', '1.36', '0.00'), 131 => array('15631959721054', '0.00', '3.65'), 132 => array('15530567163957', '0.00', '8.01'), 133 => array('15625046273472', '0.00', '4.33'), 134 => array('15633475074030', '0.00', '3.31'), 135 => array('15633529663386', '0.00', '3.75'), 136 => array('15635027053205', '0.00', '3.23'), 137 => array('15624969003554', '0.00', '3.00'), 138 => array('156360644388', '0.00', '8.98'), 139 => array('156367145310', '0.00', '7.22'), 140 => array('1563667800300', '0.00', '4.00'), 141 => array('1563589602605', '0.00', '4.02'), 142 => array('15635689693856', '0.00', '6.68'), 143 => array('15626792704092', '0.00', '6.81'), 144 => array('15636288212512', '0.00', '2.90'), 145 => array('1562589367741', '0.00', '4.40'), 146 => array('15623908673794', '0.00', '7.32'), 147 => array('1563531810848', '0.00', '2.82'), 148 => array('15635239363105', '0.00', '3.35'), 149 => array('15615129782232', '0.00', '5.52'), 150 => array('15638811551519', '0.00', '5.18'), 151 => array('15638944254753', '0.00', '4.82'), 152 => array('15627245853906', '0.00', '2.66'), 153 => array('15610856274319', '0.00', '5.64'), 154 => array('15637085114407', '0.00', '4.22'), 155 => array('1562219013986', '0.00', '3.65'), 156 => array('1561707676205', '0.00', '6.36'), 157 => array('15640328394136', '0.00', '1.98'), 158 => array('15640248421310', '0.00', '4.82'), 159 => array('15640453821612', '0.00', '4.00'), 160 => array('15641033211680', '0.00', '5.07'), 161 => array('15641402362903', '0.00', '4.82'), 162 => array('15641429823653', '0.00', '4.98'), 163 => array('15639532104169', '0.00', '3.60'), 164 => array('15630903454308', '0.00', '4.72'), 165 => array('15640493392870', '0.00', '3.67'), 166 => array('15637909611578', '0.00', '2.61'), 167 => array('1564207853529', '0.00', '5.18'), 168 => array('1560838843829', '0.00', '3.29'), 169 => array('15640175904546', '0.00', '4.25'), 170 => array('1564186321576', '0.00', '2.37'), 171 => array('15384681952034', '0.00', '3.79'), 172 => array('15633477212516', '0.00', '3.39'), 173 => array('15637916294428', '0.00', '3.55'), 174 => array('1564376944139', '0.00', '3.57'), 175 => array('15642895282446', '0.00', '11.36'), 176 => array('15642895282447', '0.00', '7.65'), 177 => array('15639532104170', '0.00', '4.19'), 178 => array('15643219424064', '0.00', '6.37'), 179 => array('1560838843830', '0.00', '3.29'), 180 => array('15644780712204', '0.00', '2.44'), 181 => array('15646111862332', '0.00', '6.71'), 182 => array('1564617518327', '0.00', '5.84'), 183 => array('1564288771260', '0.00', '5.70'), 184 => array('15593728853886', '0.00', '6.61'), 185 => array('15645313933537', '0.00', '6.68'), 186 => array('15640539664324', '0.00', '3.99'), 187 => array('1562110286529', '0.00', '8.63'), 188 => array('15638656431334', '0.00', '2.91'), 189 => array('15645465473464', '0.00', '3.65'), 190 => array('15620569433793', '0.00', '5.60'), 191 => array('', '0.00', '10.00'), 192 => array('15645744472576', '0.00', '4.97'), 193 => array('15648149133423', '0.00', '2.08'), 194 => array('155987774697', '0.00', '6.63'), 195 => array('15648149133424', '0.00', '1.88'), 196 => array('15649112131161', '0.00', '4.09'), 197 => array('15622159664758', '0.00', '5.14'), 198 => array('15593728853887', '0.00', '2.82'), 199 => array('15649008491442', '0.00', '6.08'), 200 => array('15640539664325', '0.00', '4.12'), 201 => array('15641033483828', '0.00', '5.32'), 202 => array('15642923833369', '0.00', '2.83'), 203 => array('15648087283531', '0.00', '5.08'), 204 => array('1565065691213', '0.00', '2.61'), 205 => array('15649051294886', '0.00', '6.02'), 206 => array('1565063270364', '0.00', '9.99'), 207 => array('15650067751295', '0.00', '4.05'), 208 => array('15650038993443', '0.00', '3.68'), 209 => array('15646335663474', '0.00', '2.53'), 210 => array('15651422734256', '0.00', '1.95'), 211 => array('15651666861290', '0.00', '6.07'), 212 => array('15591391301315', '0.00', '6.19'), 213 => array('15649055323560', '0.00', '4.24'), 214 => array('15623844872225', '0.00', '6.78'), 215 => array('15651639722756', '0.00', '6.47'), 216 => array('15652190234434', '0.00', '6.75'), 217 => array('15624882262736', '0.00', '7.05'), 218 => array('15627738084175', '0.00', '4.17'), 219 => array('15652393302561', '0.00', '10.77'), 220 => array('15637706402077', '0.00', '5.00'), 221 => array('15651898251346', '0.00', '3.73'), 222 => array('15653133224039', '0.00', '4.51'), 223 => array('1564195519789', '0.00', '2.44'), 224 => array('1562110286530', '0.00', '7.38'), 225 => array('15651851202611', '0.00', '2.61'), 226 => array('15642080642612', '0.00', '5.77'), 227 => array('15651513662438', '0.00', '2.82'), 228 => array('15654314623994', '0.00', '6.35'), 229 => array('15650581104954', '0.00', '4.92'), 230 => array('15651347514372', '0.00', '3.73'), 231 => array('15654133083724', '0.00', '6.43'), 232 => array('15545522924435', '0.00', '2.94'), 233 => array('15627738084174', '0.00', '3.75'), 234 => array('15654950224648', '0.00', '5.99'), 235 => array('1564288771261', '0.00', '6.27'), 236 => array('15651817271321', '0.00', '5.06'), 237 => array('15653346571755', '0.00', '3.65'), 238 => array('15650040344793', '0.00', '3.52'), 239 => array('15654295761109', '0.00', '1.43'), 240 => array('15652703471028', '0.00', '3.00'), 241 => array('15655832913087', '0.00', '14.70'), 242 => array('15654160151051', '0.00', '1.46'), 243 => array('1565241165157', '0.00', '5.45'), 244 => array('1565063270365', '0.00', '9.91'), 245 => array('15655455602371', '0.00', '4.02'), 246 => array('15656668224585', '0.00', '3.81'), 247 => array('1565522137392', '0.00', '4.56'), 248 => array('15656086013585', '0.00', '3.62'), 249 => array('15653038194388', '0.00', '9.06'), 250 => array('15640175904547', '0.00', '5.11'), 251 => array('1565737042439', '0.00', '3.32'), 252 => array('15652718153510', '0.00', '3.54'), 253 => array('15656931314079', '0.00', '3.44'), 254 => array('15659076464336', '0.00', '3.65'), 255 => array('15648199422095', '0.00', '4.61'), 256 => array('15640569814673', '0.00', '2.73'), 257 => array('15656750483002', '0.00', '4.64'), 258 => array('15656975293953', '0.00', '1.97'), 259 => array('15652718153509', '0.00', '3.25'), 260 => array('15657529654016', '0.00', '5.53'), 261 => array('15659021882941', '0.00', '3.73'), 262 => array('15660308391453', '0.00', '4.20'), 263 => array('15656741271296', '0.00', '8.99'), 264 => array('15545522924436', '0.00', '2.68'), 265 => array('15659269001853', '0.00', '3.18'), 266 => array('1565879386329', '0.00', '6.26'), 267 => array('15638656431335', '0.00', '2.48'), 268 => array('15660246462057', '0.00', '2.45'), 269 => array('15651851202612', '0.00', '3.41'), 270 => array('15660246462058', '0.00', '2.45'), 271 => array('15660205813952', '0.00', '3.00'), 272 => array('15661760791190', '0.00', '4.51'), 273 => array('1565006658951', '0.00', '5.89'), 274 => array('15660809534593', '0.00', '3.89'), 275 => array('1566297930365', '0.00', '7.17'), 276 => array('15648976534025', '0.00', '5.22'), 277 => array('15541884813596', '0.00', '2.27'), 278 => array('15641033483829', '0.00', '5.24'), 279 => array('15648118132502', '0.00', '4.46'), 280 => array('15660809534594', '0.00', '3.73'), 281 => array('15664632254722', '0.00', '3.96'), 282 => array('15663668384123', '0.00', '4.66'), 283 => array('1566375781393', '0.00', '2.73'), 284 => array('15664871134121', '0.00', '4.25'), 285 => array('15662963441969', '0.00', '3.55'), 286 => array('15621429862695', '0.00', '4.55'), 287 => array('15628048371960', '0.00', '3.21'), 288 => array('15654291063707', '0.00', '7.59'), 289 => array('15659317893107', '0.00', '4.53'), 290 => array('15629191913890', '0.00', '3.55'), 291 => array('15664160934767', '0.00', '4.61'), 292 => array('15643520412058', '0.00', '6.86'), 293 => array('1566479582867', '0.00', '3.91'), 294 => array('15665453024919', '0.00', '6.17'), 295 => array('1566630545228', '0.00', '6.20'), 296 => array('15668109103817', '0.00', '5.11'), 297 => array('15662963441970', '0.00', '3.26'), 298 => array('1563523919483', '0.00', '3.64'), 299 => array('1564955886997', '0.00', '4.98'), 300 => array('15665313633428', '0.00', '4.27'), 301 => array('1565703410873', '0.00', '5.21'), 302 => array('15667261212009', '0.00', '4.48'), 303 => array('15668741141039', '0.00', '3.39'), 304 => array('15635051493872', '0.00', '8.19'), 305 => array('15667282122016', '0.00', '7.55'), 306 => array('15608254683946', '0.00', '9.68'), 307 => array('15666437024717', '0.00', '2.90'), 308 => array('15655151373765', '0.00', '5.06'), 309 => array('15654291063708', '0.00', '7.35'), 310 => array('15667254972252', '0.00', '5.89'), 311 => array('15671172683233', '0.00', '7.30'), 312 => array('15541886594854', '0.00', '2.10'), 313 => array('1564962086468', '0.00', '5.32'), 314 => array('15671976501989', '0.00', '3.34'), 315 => array('15672345682290', '0.00', '1.73'), 316 => array('15608254683947', '0.00', '9.68'), 317 => array('1566956215918', '0.00', '6.89'), 318 => array('15673115924985', '0.00', '1.48'), 319 => array('15667046401105', '0.00', '7.41'), 320 => array('15672351193897', '0.00', '4.05'), 321 => array('15673054712786', '0.00', '9.33'), 322 => array('1565589980921', '0.00', '9.66'), 323 => array('15671491412692', '0.00', '5.45'), 324 => array('15665404915000', '0.00', '5.34'), 325 => array('15670837601679', '0.00', '4.29'), 326 => array('15661313951250', '0.00', '1.47'), 327 => array('1565589980922', '0.00', '10.00'), 328 => array('15673225614225', '0.00', '1.46'), 329 => array('1567310291506', '0.00', '1.46'), 330 => array('15673877482104', '0.00', '5.32'), 331 => array('15672197873127', '0.00', '2.77'), 332 => array('1566879502479', '0.00', '3.65'), 333 => array('15673924571477', '0.00', '5.62'), 334 => array('15668052034310', '0.00', '2.27'), 335 => array('15674119062240', '0.00', '1.52'), 336 => array('15668725833462', '0.00', '4.82'), 337 => array('15674144062330', '0.00', '4.92'), 338 => array('15668052034311', '0.00', '1.92'), 339 => array('1567471865597', '0.00', '3.52'), 340 => array('15673926992706', '0.00', '4.53'), 341 => array('15637741243034', '0.00', '3.57'), 342 => array('15675660122575', '0.00', '3.65'), 343 => array('15668125993398', '0.00', '6.21'), 344 => array('15675075123571', '0.00', '7.41'), 345 => array('15668125993397', '0.00', '5.05'), 346 => array('15675517154054', '0.00', '6.66'), 347 => array('15672850864467', '0.00', '5.81'), 348 => array('15672224174297', '0.00', '5.13'), 349 => array('15670961633333', '0.00', '3.46'), 350 => array('15675506952117', '0.00', '4.53'), 351 => array('15676442904477', '0.00', '6.61'), 352 => array('15677492261801', '0.00', '2.53'), 353 => array('15670552014273', '0.00', '3.73'), 354 => array('1567740840764', '0.00', '3.68'), 355 => array('1567772257367', '0.00', '2.45'), 356 => array('15677317343585', '0.00', '2.53'), 357 => array('155987774698', '0.00', '6.84'), 358 => array('15674730092067', '0.00', '2.74'), 359 => array('15674713061572', '0.00', '6.51'), 360 => array('15676781544496', '0.00', '4.11'), 361 => array('1567382201650', '0.00', '4.15'), 362 => array('15677522861954', '0.00', '6.60'), 363 => array('15675506952118', '0.00', '4.02'), 364 => array('15677531763204', '0.00', '4.69'), 365 => array('15669518882631', '0.00', '1.59'), 366 => array('15649051294887', '0.00', '6.02'), 367 => array('15679176533311', '0.00', '2.80'), 368 => array('15674863654439', '0.00', '3.73'), 369 => array('15678041412277', '0.00', '2.38'), 370 => array('15677574903752', '0.00', '6.97'), 371 => array('15679276044313', '0.00', '2.80'), 372 => array('15668725833463', '0.00', '7.11'), 373 => array('15679891853809', '0.00', '4.79'), 374 => array('15675766801228', '0.00', '2.89'), 375 => array('15675766801227', '0.00', '1.98'), 376 => array('1567582422303', '0.00', '4.56'), 377 => array('15677253832053', '0.00', '4.50'), 378 => array('15680984094320', '0.00', '3.44'), 379 => array('15680944504719', '0.00', '6.55'), 380 => array('15678435201725', '0.00', '5.42'), 381 => array('15679120043067', '0.00', '4.00'), 382 => array('1567963017147', '0.00', '4.10'), 383 => array('1567285218787', '0.00', '5.81'), 384 => array('15674713061573', '0.00', '6.43'), 385 => array('15681060761644', '0.00', '3.73'), 386 => array('15682832934617', '0.00', '2.48'), 387 => array('15677374741086', '0.00', '5.09'), 388 => array('15680700464802', '0.00', '3.39'), 389 => array('15681759922251', '0.00', '4.30'), 390 => array('15679325402929', '0.00', '6.07'), 391 => array('15675079434642', '0.00', '5.86'), 392 => array('1567572580581', '0.00', '2.27'), 393 => array('15678204732029', '0.00', '4.42'), 394 => array('15682536834582', '0.00', '2.56'), 395 => array('15683510992964', '0.00', '3.94'), 396 => array('15683422222406', '0.00', '4.90'), 397 => array('15682947702240', '0.00', '3.89'), 398 => array('1566808107958', '0.00', '3.40'), 399 => array('15682061093670', '0.00', '2.71'), 400 => array('15679447603042', '0.00', '5.07'), 401 => array('15681225024685', '0.00', '6.80'), 402 => array('15672923294957', '0.00', '5.40'), 403 => array('15683106744534', '0.00', '6.47'), 404 => array('15684480613192', '0.00', '1.46'), 405 => array('1564955886998', '0.00', '4.98'), 406 => array('15683821612499', '0.00', '4.86'), 407 => array('15683790643636', '0.00', '2.32'), 408 => array('15684422714122', '0.00', '3.34'), 409 => array('1567989684204', '0.00', '3.61'), 410 => array('15684207293000', '0.00', '6.01'), 411 => array('15684319364240', '0.00', '1.47'), 412 => array('15665404915001', '0.00', '5.26'), 413 => array('15684576361378', '0.00', '4.02'), 414 => array('156811964890', '0.00', '4.20'), 415 => array('15683627082976', '0.00', '7.66'), 416 => array('15679970793924', '0.00', '2.53'), 417 => array('15684397091665', '0.00', '3.64'), 418 => array('15674907903839', '0.00', '3.18'), 419 => array('15685502733591', '0.00', '4.43'), 420 => array('15676566093340', '0.00', '4.32'), 421 => array('1568591156756', '0.00', '6.16'), 422 => array('15685360264647', '0.00', '9.18'), 423 => array('1568587703315', '0.00', '3.81'), 424 => array('1554909008618', '0.00', '7.78'), 425 => array('15677531763205', '0.00', '3.89'), 426 => array('1568534293223', '0.00', '4.43'), 427 => array('15685086904162', '0.00', '5.53'), 428 => array('15681050003678', '0.00', '9.09'), 429 => array('15685086904161', '0.00', '4.80'), 430 => array('15683578541097', '0.00', '4.35'), 431 => array('15674055992804', '0.00', '6.97'), 432 => array('15687326183518', '0.00', '2.82'), 433 => array('15684631394266', '0.00', '6.45'), 434 => array('15687928124711', '0.00', '3.65'), 435 => array('15682365004809', '0.00', '4.08'), 436 => array('15686304582169', '0.00', '3.21'), 437 => array('15687726561946', '0.00', '4.66'), 438 => array('1568002184846', '0.00', '2.90'), 439 => array('15688091542240', '0.00', '3.04'), 440 => array('1568656476135', '0.00', '4.45'), 441 => array('15656741271297', '0.00', '8.26'), 442 => array('15682939403751', '0.00', '8.39'), 443 => array('15689328652480', '0.00', '4.30'), 444 => array('15685269754289', '0.00', '4.77'), 445 => array('15687720972232', '0.00', '6.96'), 446 => array('15688146781536', '0.00', '4.48'), 447 => array('15689546731060', '0.00', '3.07'), 448 => array('1568528354314', '0.00', '5.99'), 449 => array('15689893013286', '0.00', '4.84'), 450 => array('15690319052853', '0.00', '5.57'), 451 => array('15667254972253', '0.00', '5.76'), 452 => array('156811964891', '0.00', '5.00'), 453 => array('1568986435107', '0.00', '2.07'), 454 => array('15685573262462', '0.00', '4.77'), 455 => array('15690412093637', '0.00', '5.38'), 456 => array('15691423261173', '0.00', '4.48'), 457 => array('15690673014722', '0.00', '2.48'), 458 => array('15687685911815', '0.00', '3.05'), 459 => array('15691906892032', '0.00', '3.75'), 460 => array('15683267123006', '0.00', '4.98'), 461 => array('15691951464721', '0.00', '4.89'), 462 => array('15693030761325', '0.00', '6.39'), 463 => array('15692399962911', '0.00', '6.45'), 464 => array('1568625957912', '0.00', '6.75'), 465 => array('15690597614285', '0.00', '3.89'), 466 => array('15674068373810', '0.00', '9.57'), 467 => array('15692325633786', '0.00', '4.58'), 468 => array('15691525371149', '0.00', '5.06'), 469 => array('1566860931376', '0.00', '2.98'), 470 => array('1568777749699', '0.00', '8.06'), 471 => array('15691977332641', '0.00', '4.49'), 472 => array('15693271122329', '0.00', '2.45'), 473 => array('15693794323706', '0.00', '2.50'), 474 => array('15688692871415', '0.00', '4.69'), 475 => array('15692079753958', '0.00', '3.00'), 476 => array('15670475214923', '0.00', '6.96'), 477 => array('15688777704239', '0.00', '3.02'), 478 => array('15693830031980', '0.00', '4.77'), 479 => array('1568702480890', '0.00', '3.57'), 480 => array('15687879534006', '0.00', '7.88'), 481 => array('15686262883543', '0.00', '3.41'), 482 => array('15691305044352', '0.00', '6.36'), 483 => array('1566860931377', '0.00', '3.52'), 484 => array('15692677782358', '0.00', '3.92'), 485 => array('15694161473548', '0.00', '3.23'), 486 => array('15693829303829', '0.00', '5.00'), 487 => array('15694648642626', '0.00', '4.05'), 488 => array('15690412093638', '0.00', '4.85'), 489 => array('15694195311080', '0.00', '5.26'), 490 => array('1569563874876', '0.00', '1.43'), 491 => array('1569534651758', '0.00', '1.87'), 492 => array('15694175642097', '0.00', '2.32'), 493 => array('15690667483968', '0.00', '3.15'), 494 => array('15695600181700', '0.00', '1.88'), 495 => array('15686262883544', '0.00', '4.20'), 496 => array('15694963033737', '0.00', '5.46'), 497 => array('15692183554360', '0.00', '5.11'), 498 => array('1554909008619', '0.00', '9.00'), 499 => array('15696407434945', '0.00', '1.88'), 500 => array('15696267624131', '0.00', '2.70'), 501 => array('15656216801199', '0.00', '6.48'), 502 => array('15671733752208', '0.00', '2.27'), 503 => array('15646608194674', '0.00', '2.95'), 504 => array('15689929601220', '0.00', '5.35'), 505 => array('15695647804952', '0.00', '1.88'), 506 => array('1569637536881', '0.00', '4.20'), 507 => array('15696434712241', '0.00', '1.88'), 508 => array('15688692871416', '0.00', '4.69'), 509 => array('15671172683234', '0.00', '8.54'), 510 => array('15697529603471', '0.00', '5.91'), 511 => array('15687685911816', '0.00', '2.91'), 512 => array('15672351193898', '0.00', '3.97'), 513 => array('15697222282806', '0.00', '1.88'), 514 => array('15691505831985', '0.00', '3.84'), 515 => array('15693475752603', '0.00', '6.13'), 516 => array('1568019739650', '0.00', '3.37'), 517 => array('15691094264207', '0.00', '4.74'), 518 => array('15695785071556', '0.00', '4.88'), 519 => array('15697526091023', '0.00', '1.88'), 520 => array('15697526091022', '0.00', '1.88'), 521 => array('1568002184847', '0.00', '3.05'), 522 => array('15697201811849', '0.00', '3.29'), 523 => array('#43153', '18.70', '0.00'), 524 => array('1566950057655', '0.00', '10.00'), ); $message = " Daily Report "; foreach($bigArray as $row) { $A = checkWeb($row[0]); $levy = $row[2]; if($levy > 10) { $levy = 10; } if($A == "none") { $A = checkApp($row[0]); if($A == "none") { $line = $row[0].",,,,,,,,,,,,,,,,,,,,,,,,,,,,
"; } else { if($A["book_pax"] > 4) { $km = 2.2; } else { $km = 1.3; } $child = $A["book_seats"] * 5 + 15; $GST = ($A["amount"] - $levy)/11; $levyable = $A["amount"] - $levy - $child - $A["airport"]; $mins = ($levyable - ($A["dist"] * $km))/0.8; $d = date_create_from_format("d/m/Y G:i", $A["date"]); $date24 = date_format($d, "Y-m-d G:i"); error_log(strtotime($date24)." + ".($mins * 60 * 1000)); $finish = date("d/m/Y G:i", strtotime($date24) + ($mins * 60 )); $line = $row[0].",".$A['date'].",".$A["phone"].",".$A["plate"].",N,".$A["licence"].",".$A["driver"].",".$A['date'].",".$A["pickup"].",".$finish.",".$A["dropoff"].",".$A["dist"].",0,".$A["amount"].",".$GST.",".$A["airport"].",0,0,".$child.",0,".$levy.",0,0,".$levyable.",".$levy.",".$km.",0.8
"; } } else { if($A["book_pax"] > 4) { $km = 2.2; } else { $km = 1.3; } $child = ($A["book_seats"] - 1) * 5 + 15; $GST = ($A["amount"] - $levy)/11; $levyable = $A["amount"] - $levy - $child - $A["airport"]; $mins = round(($levyable - ($A["dist"] * $km))/0.8); $d = date_create_from_format("d/m/Y G:i", $A["date"]); $date24 = date_format($d, "Y-m-d G:i"); error_log(strtotime($date24)." + ".($mins * 60 * 1000)); $finish = date("d/m/Y G:i", strtotime($date24) + ($mins * 60)); $line = $row[0].",".$A['date'].",".$A["phone"].",".$A["plate"].",N,".$A["licence"].",".$A["driver"].",".$A['date'].",".$A["pickup"].",".$finish.",".$A["dropoff"].",".$A["dist"].",0,".$A["amount"].",".$GST.",".$A["airport"].",0,0,".$child.",0,".$levy.",0,0,".$levyable.",".$levy.",".$km.",0.8
"; } echo $line; //"..",
"; } echo ""; echo $message; ?>