<?php
/*
 *
 * @ This file is created by http://DeZender.Net
 * @ deZender (PHP5 Decoder for ionCube Encoder)
 *
 * @ Version		:	3.5.0.0
 * @ Author			:	DeZender
 * @ Release on		:	22.06.2018
 * @ Official site	:	http://DeZender.Net
 *
 */

if ($iCustomerId == '1') {
	$cmp_ssql = '';
	$eSystem = " AND eSystem = 'General'";
	$sql = "SELECT * FROM company WHERE eStatus != 'Deleted'  " . $cmp_ssql . ' order by tRegistrationDate desc';
	$cmp_ssql = '';

	if (SITE_TYPE == 'Demo') {
		$cmp_ssql = " And rd.tRegistrationDate > '" . WEEK_DATE . "'";
	}
	$ssl = '';

	if ($status != '' && $status == 'active') {
		$ssl = " AND rd.eStatus = '" . $status . "'";
	} elseif ($status != '' && $status == 'inactive') {
		$ssl = " AND rd.eStatus = '" . $status . "'";
	}
	$sql = "SELECT rd.*, c.vCompany companyFirstName, c.vLastName companyLastName FROM register_driver rd LEFT JOIN company c ON rd.iCompanyId = c.iCompanyId WHERE  rd.eStatus != 'Deleted'" . $ssl . $cmp_ssql;
	$cmp_ssql = '';

	if (SITE_TYPE == 'Demo') {
		$cmp_ssql = " And rd.tRegistrationDate > '" . WEEK_DATE . "'";
	}
	$ssl = '';

	if ($status != '' && $status == 'active') {
		$ssl = " AND rd.eStatus = '" . $status . "'";
	} elseif ($status != '' && $status == 'inactive') {
		$ssl = " AND rd.eStatus = '" . $status . "'";
	}
	$sql = "SELECT count(rd.iDriverId) as tot_driver FROM register_driver rd LEFT JOIN company c ON rd.iCompanyId = c.iCompanyId and c.eStatus != 'Deleted' WHERE  rd.eStatus != 'Deleted'";
	$cmp_ssql = '';

	if (SITE_TYPE == 'Demo') {
		$cmp_ssql = " And rd.tRegistrationDate > '" . WEEK_DATE . "'";
	}
	$sql = "SELECT dv.*, m.vMake, md.vTitle,rd.vEmail, rd.vName, rd.vLastName, c.vName as companyFirstName, c.vLastName as companyLastName\r\nFROM driver_vehicle dv, register_driver rd, make m, model md, company c\r\nWHERE\r\ndv.iMakeId = m.iMakeId" . $cmp_ssql;
	$cmp_ssql = '';

	if (SITE_TYPE == 'Demo') {
		$cmp_ssql = " And tRegistrationDate > '" . WEEK_DATE . "'";
	}

	if ($status == 'all') {
		$sql = 'SELECT * FROM register_user WHERE 1 = 1 ';
	} else {
		$sql = "SELECT * FROM register_user WHERE eStatus != 'Deleted'";
	}
	$cmp_ssql = '';

	if (SITE_TYPE == 'Demo') {
		$cmp_ssql = " And tRegistrationDate > '" . WEEK_DATE . "'";
	}
	$ssql1 = "AND (vEmail != '' OR vPhone != '')";

	if ($status == 'all') {
		$sql = 'SELECT count(iUserId) as tot_rider FROM register_user WHERE 1 = 1 ' . $ssql1 . $cmp_ssql;
	} else {
		$sql = "SELECT count(iUserId) FROM register_user WHERE eStatus != 'Deleted'" . $ssql1 . $cmp_ssql;
	}

	if (count($data) > 0) {
		$common_member = "SELECT iDriverId\r\nFROM register_driver\r\nWHERE tRegistrationDate < '" . $er_date . "'";
		$sql = 'DELETE FROM driver_vehicle WHERE iDriverId IN (' . $member . ')';
		$sql = 'DELETE FROM trips WHERE iDriverId IN (' . $member . ')';
		$sql = 'DELETE FROM log_file WHERE iDriverId IN (' . $member . ')';
		$sql = "DELETE FROM register_driver WHERE tRegistrationDate < '" . $date . "'";
	}

	if (count($userObj->locations) > 0) {
		$locations = implode(', ', $userObj->locations);
		$locations_where = ' AND EXISTS(SELECT * FROM vehicle_type WHERE trips.iVehicleTypeId = vehicle_type.iVehicleTypeId AND vehicle_type.iLocationid IN(-1, ' . $locations . '))';
	}

	if ($tripStatus != '') {
		if ($tripStatus == 'on ride') {
			$ssl = " AND (iActive = 'On Going Trip' OR iActive = 'Active') AND eCancelled='No'";
		} elseif ($tripStatus == 'cancelled') {
			$ssl = " AND (iActive = 'Canceled' OR eCancelled='yes')";
		} elseif ($tripStatus == 'finished') {
			$ssl = " AND iActive = 'Finished' AND eCancelled='No'";
		} else {
			$ssl = '';
		}
		$sql = "SELECT COUNT(iTripId) as tot FROM trips WHERE 1 = 1 AND eSystem = 'General'" . $cmp_ssql . $ssl . $dsql . $locations_where;
	}

	if ($tripStatus != '') {
		if ($tripStatus == 'on ride') {
			$ssl = " AND (iActive = 'On Going Trip' OR iActive = 'Active') AND eCancelled='No'";
		} elseif ($tripStatus == 'cancelled') {
			$ssl = " AND (iActive = 'Canceled' OR eCancelled='yes')";
		} elseif ($tripStatus == 'finished') {
			$ssl = " AND iActive = 'Finished' AND eCancelled='No'";
		} else {
			$ssl = '';
		}
		$sql = 'SELECT iTripId FROM trips WHERE 1' . $cmp_ssql . $ssl . $dsql . $locations_where;
	}

	if (SITE_TYPE == 'Demo') {
		$cmp_ssql = " And tEndDate > '" . WEEK_DATE . "'";
	}

	if ($time == 'month') {
		$startDate = date('Y-m') . '-01';
		$endDate = date('Y-m') . '-31';
		$ssl = " AND tTripRequestDate BETWEEN '" . $startDate . "' AND '" . $endDate . "'";
	} elseif ($time == 'year') {
		$startDate1 = date('Y') . '-00-01';
		$endDate1 = date('Y') . '-12-31';
		$ssl = " AND tTripRequestDate BETWEEN '" . $startDate1 . "' AND '" . $endDate1 . "'";
	} else {
		$startDate2 = date('Y-m-d') . '';
		$endDate2 = date('Y-m-d') . '';
		$ssl = " AND tTripRequestDate BETWEEN '" . $startDate2 . "' AND '" . $endDate2 . "'";
	}
	$mailerCharSet = 'UTF-8';
	$mailerHost = 'mail.example.com';
	$mailerSMTPDebug = 0;
	$mailerSMTPAuth = true;
	$mailerPort = 25;
	$mailerUsername = 'username';
	$mailerPassword = 'password';
	$message = "The mail message was sent with the following mail setting:\r\nSMTP = aspmx.l.google.com\r\nsmtp_port = 25\r\nsendmail_from = YourMail@address.com";
	$headers = 'From: YOURMAIL@gmail.com';
	echo 'Check your email now....<BR/>';
	$NS = 'http://www.w3.org/2005/Atom';
	$ATOM_CONTENT_ELEMENTS = array('content', 'summary', 'title', 'subtitle', 'rights');
	$ATOM_SIMPLE_ELEMENTS = array('id', 'updated', 'published', 'draft');
	$debug = false;
	$depth = 0;
	$indent = 2;
	$ns_contexts = array();
	$ns_decls = array();
	$content_ns_decls = array();
	$content_ns_contexts = array();
	$is_xhtml = false;
........................................................................
..........................................
.................