<?php
/**
*
* @ This file is created by http://DeZender.Net
* @ deZender (PHP7 Decoder for ionCube Encoder)
*
* @ Version			:	4.1.0.1
* @ Author			:	DeZender
* @ Release on		:	29.08.2020
* @ 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 . '\'';
	}
	else if (($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 . '\'';
	}
	else if (($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\n" . 'FROM driver_vehicle dv, register_driver rd, make m, model md, company c' . "\r\n" . 'WHERE' . "\r\n" . 'dv.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\'';
....................................................................................
...........................................
........................