AK-74 Security Team Web Shell

.:: :[ AK-74 Security Team Web-shell ]: ::.

Edit the file

<?
	set_time_limit(1800);

// check if reports are called by user or service
	if (!isset($_POST['schedule']))
	{
		session_start();
	}
	
	include ('../init.php');
	include ('fn_common.php');
	include ('fn_route.php');
	include ('../tools/gc_func.php');
	if (version_compare(PHP_VERSION, '5.5.0', '>=')) { include ('../tools/html2pdf.php'); } else { include ('../tools/html2pdf080.php'); }
	if (version_compare(PHP_VERSION, '5.5.0', '>=')) { include ('../tools/email.php'); } else { include ('../tools/email52.php'); }
	
	// check if reports are called by user or service
	if (isset($_POST['schedule']))
	{
		$_SESSION = getUserData($_POST['user_id']);
		loadLanguage($_SESSION["language"], $_SESSION["units"]);
	}
	else
	{
		checkUserSession();
		loadLanguage($_SESSION["language"], $_SESSION["units"]);
	}
		
	if(@$_POST['cmd'] == 'report')
	{
		// check privileges
		if ($_SESSION["privileges"] == 'subuser')
		{
			$user_id = $_SESSION["manager_id"];
		}
		else
		{
			$user_id = $_SESSION["user_id"];
		}
		
		// generate or send report to e-mail
		if (isset($_POST['schedule']))
		{
			//check user usage
			if (!checkUserUsage($user_id, 'email')) die;
		
			reportsSend();
		}
		else
		{
			$report = reportsGenerate();
			
			if ($report != false)
			{
				echo $report;
			}
		}
		
		die;
	}

// other
		if ($type == 'travel_sheet_dn')
		{
			$default = array('dn_starts_hour' => '22',
							 'dn_starts_minute' => '00',
							 'dn_ends_hour' => '06',
							 'dn_ends_minute' => '00');
			
			if (($other == '') || (json_decode(stripslashes($other),true) == null))
			{
				$other = $default;						     
			}
			else
			{
				$other = json_decode(stripslashes($other),true);
				
				if (!isset($other["dn_starts_hour"])) { $other["dn_starts_hour"] = $default["dn_starts_hour"]; }
				if (!isset($other["dn_starts_minute"])) { $other["dn_starts_minute"] = $default["dn_starts_minute"]; }
				if (!isset($other["dn_ends_hour"])) { $other["dn_ends_hour"] = $default["dn_ends_hour"]; }
				if (!isset($other["dn_ends_minute"])) { $other["dn_ends_minute"] = $default["dn_ends_minute"]; }
			}
		}
		else if (($type == 'rag') || ($type == 'rag_driver'))
		{
			$default = array('low_score' => 0, 'high_score' => 5);
			
			if (($other == '') || (json_decode(stripslashes($other),true) == null))
			{
				$other = $default;						     
			}
			else
			{
				$other = json_decode(stripslashes($other),true);
				
				if (!isset($other["low_score"])) { $other["low_score"] = $default["low_score"]; }
				if (!isset($other["high_score"])) { $other["high_score"] = $default["high_score"]; }
			}
		}
		else
		{
			$other = '';
		}
		
		$report_html = reportsAddHeaderStart($format);
		$report_html .= reportsAddStyle($type, $format);
		$report_html .= reportsAddJS($type);
		$report_html .= reportsAddHeaderEnd();
		
		if ($format == 'html')
		{
			$report_html .= '<img class="logo" src="'.$gsValues['URL_ROOT'].'/img/'.$gsValues['LOGO'].'" /><hr/>';
		}
		else if ($format == 'pdf')
		{
			$image_source = $gsValues['PATH_ROOT'].'/img/'.$gsValues['LOGO'];
			$image = fopen($image_source, 'r');
			$image_string = fread($image, filesize($image_source));
			
			$img_base64 = base64_encode($image_string);

$report_html .= '<img class="logo" src="data:image/jpg;base64,'.$img_base64.'" /></br><hr/>';
		}
		
		$report_html .= reportsGenerateLoop($type, $imeis, $dtf, $dtt, $ignore_empty_reports, $speed_limit, $stop_duration, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $marker_ids, $zone_ids, $sensor_names, $data_items, $other);
		$report_html .= '</body></html>';
		
		$report = $report_html;
		
		if ($format == 'pdf')
		{
			$report = html2pdf($report);
		}
		
		if (!isset($_POST['schedule']))
		{
			$report = base64_encode($report);
		}
		
		// store generated report
		if ($marker_ids != '')
		{
			$markers = count(explode(",", $marker_ids));
		}
		else
		{
			$markers = 0;
		}
		
		if ($zone_ids != '')
		{
			$zones = count(explode(",", $zone_ids));
		}
		else
		{
			$zones = 0;
		}
		
		if ($sensor_names != '')
		{
			$sensors = count(explode(",", $sensor_names));
		}
		else
		{
			$sensors = 0;
		}
		
		if (isset($_POST['schedule']))
		{
			$schedule = 'true';
		}
		else
		{
			$schedule = 'false';
		}
		$filename = strtolower($name).'_'.$dtf.'_'.$dtt;
		
		$report_file = $user_id.'_'.md5($type.$dtf.$dtt.gmdate("Y-m-d H:i:s").rand());
		$file_path = $gsValues['PATH_ROOT'].'data/user/reports/'.$report_file;
		
		$report_html = base64_encode($report_html);
		
		$fp = fopen($file_path, 'wb');
		fwrite($fp, $report_html);
		fclose($fp);
		
		if(is_file($file_path))
		{
			$q = "INSERT INTO `gs_user_reports_generated`(	`user_id`,
															`dt_report`,
															`name`,
															`type`,
															`format`,
															`objects`,
															`markers`,
															`zones`,
															`sensors`,
															`schedule`,
															`filename`,
															`report_file`)
															VALUES
															('".$user_id."',
															'".gmdate("Y-m-d H:i:s")."',
															'".$name."',
															'".$type."',
															'".$format."',
															'".count($imeis)."',
															'".$markers."',
															'".$zones."',
															'".$sensors."',
															'".$schedule."',
															'".$filename."',
															'".$report_file."')";
			$r = @mysqli_query($ms, $q);
			
			// in case MySQL connection is closed due to long report generation - open it again
			if (!$r)
			{
				$ms = mysqli_connect($gsValues['DB_HOSTNAME'], $gsValues['DB_USERNAME'], $gsValues['DB_PASSWORD'], $gsValues['DB_NAME'], $gsValues['DB_PORT']);
				
				if ($ms)
				{
					$r = mysqli_query($ms, $q);
				}
			}			
		}
		
		return $report;
	}
	
	function reportsGenerateLoop($type, $imeis, $dtf, $dtt, $ignore_empty_reports, $speed_limit, $stop_duration, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $marker_ids, $zone_ids, $sensor_names, $data_items, $other)
	{
		global $la;
		
		$result = '';
		
		for ($i=0; $i<count($imeis); ++$i)
		{
			$imei = $imeis[$i];
			
			if ($type == "general") //GENERAL_INFO
			{
				$report = reportsGenerateGenInfo($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $speed_limit, $stop_duration, $data_items);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['GENERAL_INFO'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['GENERAL_INFO'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "route_data_sensors") //ROUTE DATA WITH SENSORS
			{
				$sensors = getSensors($imei);
				$sensors_ = array();
				
				$sensor_names_ = explode(",", $sensor_names);
				for ($j=0; $j<count($sensor_names_); ++$j)
				{
					for ($k=0; $k<count($sensors); ++$k)
					{
						if ($sensor_names_[$j] == $sensors[$k]['name'])
						{
							$sensors_[] = $sensors[$k];
						}
					}
				}
				
				$report = reportsGenerateRouteDataSensors($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $sensors_, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['ROUTE_DATA_WITH_SENSORS'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['ROUTE_DATA_WITH_SENSORS'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}			
			else if ($type == "drives_stops") //DRIVES_AND_STOPS
			{
				$report = reportsGenerateDrivesAndStops($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $stop_duration, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items);
				$report2 = reportsGenerateRoutes($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $speed_limit, $stop_duration, $data_items, true);
	
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['DRIVES_AND_STOPS'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['DRIVES_AND_STOPS'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
                                        $result .= $report2;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "drives_stops_sensors") //DRIVES_AND_STOPS_WITH_SENSORS
			{
				$sensors = getSensors($imei);
				$sensors_ = array();
				
				$sensor_names_ = explode(",", $sensor_names);
				for ($j=0; $j<count($sensor_names_); ++$j)
				{
					for ($k=0; $k<count($sensors); ++$k)
					{
						if ($sensor_names_[$j] == $sensors[$k]['name'])
						{
							$sensors_[] = $sensors[$k];
						}
					}
				}
				
				$report = reportsGenerateDrivesAndStopsSensors($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $sensors_, $stop_duration, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['DRIVES_AND_STOPS_WITH_SENSORS'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['DRIVES_AND_STOPS_WITH_SENSORS'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "drives_stops_logic") //DRIVES_AND_STOPS_WITH_LOGIC_SENSORS
			{
				$sensors = getSensors($imei);
				$sensors_ = array();
				
				$sensor_names_ = explode(",", $sensor_names);
				for ($j=0; $j<count($sensor_names_); ++$j)
				{
					for ($k=0; $k<count($sensors); ++$k)
					{
						if ($sensors[$k]['result_type'] == 'logic')
						{
							if ($sensor_names_[$j] == $sensors[$k]['name'])
							{
								$sensors_[] = $sensors[$k];
							}
						}
					}
				}
				
				$report = reportsGenerateDrivesAndStopsLogicSensors($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $sensors_, $stop_duration, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['DRIVES_AND_STOPS_WITH_LOGIC_SENSORS'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['DRIVES_AND_STOPS_WITH_LOGIC_SENSORS'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "travel_sheet") //TRAVEL_SHEET
			{
				$report = reportsGenerateTravelSheet($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $stop_duration, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['TRAVEL_SHEET'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['TRAVEL_SHEET'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "travel_sheet_dn") //TRAVEL_SHEET_DAY_NIGHT
			{
				$report = reportsGenerateTravelSheetDayNight($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $stop_duration, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items, $other);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['TRAVEL_SHEET_DAY_NIGHT'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['TRAVEL_SHEET_DAY_NIGHT'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "mileage_daily") //MILEAGE_DAILY
			{
				$report = reportsGenerateMileageDaily($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $data_items);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['MILEAGE_DAILY'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['MILEAGE_DAILY'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "overspeed") //OVERSPEED
			{
				$report = reportsGenerateOverspeed($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $speed_limit, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['OVERSPEEDS'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['OVERSPEEDS'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "underspeed") //UNDERSPEED
			{
				$report = reportsGenerateUnderspeed($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $speed_limit, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['UNDERSPEEDS'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['UNDERSPEEDS'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "marker_in_out") //MARKER_IN_OUT
			{
				$report = reportsGenerateMarkerInOut($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $marker_ids, $data_items);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['MARKER_IN_OUT'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['MARKER_IN_OUT'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "marker_in_out_gen") //MARKER_IN_OUT_WITH_GEN_INFO
			{
				$report = reportsGenerateMarkerInOutGenInfo($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $speed_limit, $stop_duration, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $marker_ids, $data_items);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['MARKER_IN_OUT_WITH_GEN_INFORMATION'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['MARKER_IN_OUT_WITH_GEN_INFORMATION'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "zone_in_out") //ZONE_IN_OUT
			{
				$report = reportsGenerateZoneInOut($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $zone_ids, $data_items);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['ZONE_IN_OUT'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['ZONE_IN_OUT'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "zone_in_out_general") //ZONE_IN_OUT_WITH_GEN_INFO
			{
				$report = reportsGenerateZoneInOutGenInfo($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $speed_limit, $stop_duration, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $zone_ids, $data_items);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['ZONE_IN_OUT_WITH_GEN_INFORMATION'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['ZONE_IN_OUT_WITH_GEN_INFORMATION'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "events") //EVENTS
			{
				$report = reportsGenerateEvents($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['EVENTS'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['EVENTS'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "service") //SERVICE
			{
				$report = reportsGenerateService($imei, $data_items);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['SERVICE'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['SERVICE'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "fuelfillings") //FUEL_FILLINGS
			{
				$report = reportsGenerateFuelFillings($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['FUEL_FILLINGS'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['FUEL_FILLINGS'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "fuelthefts") //FUEL_THEFTS
			{
				$report = reportsGenerateFuelThefts($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['FUEL_THEFTS'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['FUEL_THEFTS'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "logic_sensors") //LOGIC_SENSORS
			{
				$sensors = getSensors($imei);
				$sensors_ = array();
				
				$sensor_names_ = explode(",", $sensor_names);				
				for ($j=0; $j<count($sensor_names_); ++$j)
				{
					for ($k=0; $k<count($sensors); ++$k)
					{
						if ($sensors[$k]['result_type'] == 'logic')
						{
							if ($sensor_names_[$j] == $sensors[$k]['name'])
							{
								$sensors_[] = $sensors[$k];
							}
						}
					}
				}
				
				$report = reportsGenerateLogicSensorInfo($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $sensors_, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['LOGIC_SENSORS'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['LOGIC_SENSORS'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "speed_graph") //SPEED
			{
				$sensors = array(array('name' => '', 'type' => 'speed', 'units' => $la["UNIT_SPEED"], 'result_type' => ''));
				
				$report = reportsGenerateGraph($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $sensors);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['SPEED_GRAPH'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['SPEED_GRAPH'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "altitude_graph") //ALTITUDE
			{
				$sensors = array(array('name' => '', 'type' => 'altitude', 'units' => $la["UNIT_HEIGHT"], 'result_type' => ''));
				
				$report = reportsGenerateGraph($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $sensors);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['ALTITUDE_GRAPH'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['ALTITUDE_GRAPH'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "acc_graph") //ACC
			{
				$sensors = getSensorFromType($imei, 'acc');
				
				$report = reportsGenerateGraph($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $sensors);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['IGNITION_GRAPH'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['IGNITION_GRAPH'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "fuellevel_graph") //FUEL_LEVEL
			{
				$fuel_sensors = getSensorFromType($imei, 'fuel');
				$fuelsumup_sensor = getSensorFromType($imei, 'fuelsumup');
				
				if ($fuelsumup_sensor == false)
				{
					$sensors = $fuel_sensors;	
				}
				else
				{
					$sensors = array_merge($fuel_sensors, $fuelsumup_sensor);
				}
				
				$report = reportsGenerateGraph($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $sensors);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['FUEL_LEVEL_GRAPH'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['FUEL_LEVEL_GRAPH'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			else if ($type == "temperature_graph") //TEMPERATURE
			{
				$sensors = getSensorFromType($imei, 'temp');
				
				$report = reportsGenerateGraph($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $sensors);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['TEMPERATURE_GRAPH'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['TEMPERATURE_GRAPH'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}			
			else if ($type == "sensor_graph") //SENSOR
			{
				$sensors = getSensors($imei);
				$sensors_ = array();
				
				$sensor_names_ = explode(",", $sensor_names);				
				for ($j=0; $j<count($sensor_names_); ++$j)
				{
					for ($k=0; $k<count($sensors); ++$k)
					{
						if ($sensor_names_[$j] == $sensors[$k]['name'])
						{
							$sensors_[] = $sensors[$k];
						}
					}
				}
				
				$report = reportsGenerateGraph($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $sensors_);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['SENSOR_GRAPH'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['SENSOR_GRAPH'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
			elseif ($type == "routes") //ROUTES
			{
				$report = reportsGenerateRoutes($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $speed_limit, $stop_duration, $data_items, false);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						if ($i == 0)
						{
							$result .= '<div style="height: 815px">';					
						}
						else
						{
							$result .= '<div style="height: 900px">';
						}
						$result .= '<h3>'.$la['ROUTES'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
						$result .= '</div>';
					}
				}
				else
				{
					if ($i == 0)
					{
						$result .= '<div style="height: 815px">';					
					}
					else
					{
						$result .= '<div style="height: 900px">';
					}
					$result .= '<h3>'.$la['ROUTES'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
					$result .= '</div>';
				}
			}
			elseif ($type == "routes_stops") //ROUTES WITH STOPS
			{
				$report = reportsGenerateRoutes($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $speed_limit, $stop_duration, $data_items, true);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						if ($i == 0)
						{
							$result .= '<div style="height: 815px">';					
						}
						else
						{
							$result .= '<div style="height: 900px">';
						}
						$result .= '<h3>'.$la['ROUTES'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
						$result .= '</div>';
					}
				}
				else
				{
					if ($i == 0)
					{
						$result .= '<div style="height: 815px">';					
					}
					else
					{
						$result .= '<div style="height: 900px">';
					}
					$result .= '<h3>'.$la['ROUTES'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
					$result .= '</div>';
				}
			}
			elseif ($type == "image_gallery") //IMAGE_GALLERY
			{
				$report = reportsGenerateImageGallery($imei, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items);
				
				if ($report == false)
				{
					if ($ignore_empty_reports == 'false')
					{
						$result .= '<h3>'.$la['IMAGE_GALLERY'].'</h3>';
						$result .= reportsAddReportHeader($imei, $dtf, $dtt);
						$result .= '<table><tr><td>'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td></tr></table>';
						$result .= '<br/><hr/>';
					}
				}
				else
				{
					$result .= '<h3>'.$la['IMAGE_GALLERY'].'</h3>';
					$result .= reportsAddReportHeader($imei, $dtf, $dtt);
					$result .= $report;
					$result .= '<br/><hr/>';
				}
			}
		}
		
		if ($type == "general_merged") //GENERAL_INFO_MERGED
		{
			$result .= '<h3>'.$la['GENERAL_INFO_MERGED'].'</h3>';
			$result .= reportsAddReportHeader('', $dtf, $dtt);
			$result .= reportsGenerateGenInfoMerged($imeis, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $speed_limit, $stop_duration, $data_items);
			$result .= '<br/><hr/>';
		}
		elseif ($type == "object_info") //OBJECT_INFO
		{
			$result .= '<h3>'.$la['OBJECT_INFO'].'</h3>';
			$result .= reportsAddReportHeader('', $dtf, $dtt);
			$result .= reportsGenerateObjectInfo($imeis, $data_items);
			$result .= '<br/><hr/>';
		}
		else if ($type == "current_position") //CURRENT POSITION
		{
			$result .= '<h3>'.$la['CURRENT_POSITION'].'</h3>';
			$result .= reportsAddReportHeader('', $dtf, $dtt);
			$result .= reportsGenerateCurrentPosition($imeis, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items, false);
			$result .= '<br/><hr/>';
		}
		else if ($type == "current_position_off") //CURRENT POSITION OFFLINE
		{
			$result .= '<h3>'.$la['CURRENT_POSITION_OFFLINE'].'</h3>';
			$result .= reportsAddReportHeader('', $dtf, $dtt);
			$result .= reportsGenerateCurrentPosition($imeis, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items, 'offline');
			$result .= '<br/><hr/>';
		}
		else if ($type == "overspeed_count") //OVERSPEED COUNT
		{
			$result .= '<h3>'.$la['OVERSPEED_COUNT_MERGED'].'</h3>';
			$result .= reportsAddReportHeader('', $dtf, $dtt);
			$result .= reportsGenerateOverspeedCountMerged($imeis, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $speed_limit, $data_items);
			$result .= '<br/><hr/>';
		}
		else if ($type == "underspeed_count") //UNDERSPEED COUNT
		{
			$result .= '<h3>'.$la['UNDERSPEED_COUNT_MERGED'].'</h3>';
			$result .= reportsAddReportHeader('', $dtf, $dtt);
			$result .= reportsGenerateUnderspeedCountMerged($imeis, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $speed_limit, $data_items);
			$result .= '<br/><hr/>';
		}		
		elseif ($type == "rag") //RAG BY OBJECT
		{
			$result .= '<h3>'.$la['DRIVER_BEHAVIOR_RAG'].'</h3>';
			$result .= reportsAddReportHeader('', $dtf, $dtt);
			$result .= reportsGenerateRagByObject($imeis, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $speed_limit, $data_items, $other);
			$result .= '<br/><hr/>';
		}
		elseif ($type == "rag_driver") //RAG BY OBJECT
		{
			$result .= '<h3>'.$la['DRIVER_BEHAVIOR_RAG'].'</h3>';
			$result .= reportsAddReportHeader('', $dtf, $dtt);
			$result .= reportsGenerateRagByDriver($imeis, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $speed_limit, $data_items, $other);
			$result .= '<br/><hr/>';
		}
		elseif ($type == "tasks") //TASKS
		{
			$result .= '<h3>'.$la['TASKS'].'</h3>';
			$result .= reportsAddReportHeader('', $dtf, $dtt);
			$result .= reportsGenerateTasks($imeis, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items);
			$result .= '<br/><hr/>';
		}
		elseif ($type == "rilogbook") //RFID_AND_IBUTTON_LOGBOOK
		{
			$result .= '<h3>'.$la['RFID_AND_IBUTTON_LOGBOOK'].'</h3>';
			$result .= reportsAddReportHeader('', $dtf, $dtt);
			$result .= reportsGenerateRiLogbook($imeis, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items);
			$result .= '<br/><hr/>';
		}
		elseif ($type == "dtc") //DIAGNOSTIC_TROUBLE_CODES
		{
			$result .= '<h3>'.$la['DIAGNOSTIC_TROUBLE_CODES'].'</h3>';
			$result .= reportsAddReportHeader('', $dtf, $dtt);
			$result .= reportsGenerateDTC($imeis, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items);
			$result .= '<br/><hr/>';
		}
		elseif ($type == "expenses") //EXPENSES
		{
			$result .= '<h3>'.$la['EXPENSES'].'</h3>';
			$result .= reportsAddReportHeader('', $dtf, $dtt);
			$result .= reportsGenerateExpenses($imeis, convUserUTCTimezone($dtf), convUserUTCTimezone($dtt), $data_items);
			$result .= '<br/><hr/>';
		}
		
		return $result;
	}

$result .= '</table>';
		
		return $result;
	}
	
	function reportsGenerateObjectInfo($imeis, $data_items)
	{
		global $ms, $_SESSION, $gsValues, $la, $user_id;
		
		$groups = array();
		
		$q = "SELECT * FROM `gs_user_object_groups` WHERE `user_id`='".$user_id."' ORDER BY `group_id` ASC";
		$r = mysqli_query($ms, $q);
		
		while($row=mysqli_fetch_array($r))
		{
			$groups[$row['group_id']] = $row['group_name'];
		}
		
		$result = '<table class="report" width="100%" ><tr align="center">';
				
		$result .= '<th>'.$la['OBJECT'].'</th>';
		
		if (in_array("imei", $data_items))
		{
			$result .= '<th>'.$la['IMEI'].'</th>';
		}
		
		if (in_array("group", $data_items))
		{
			$result .= '<th>'.$la['GROUP'].'</th>';
		}
		
		if (in_array("transport_model", $data_items))
		{
			$result .= '<th>'.$la['TRANSPORT_MODEL'].'</th>';
		}
		
		if (in_array("vin", $data_items))
		{
			$result .= '<th>'.$la['VIN'].'</th>';
		}
		
		if (in_array("plate_number", $data_items))
		{
			$result .= '<th>'.$la['PLATE_NUMBER'].'</th>';
		}
		
		if (in_array("odometer", $data_items))
		{
			$result .= '<th>'.$la['ODOMETER'].'</th>';
		}
		
		if (in_array("engine_hours", $data_items))
		{
			$result .= '<th>'.$la['ENGINE_HOURS'].'</th>';
		}
		
		if (in_array("driver", $data_items))
		{
			$result .= '<th>'.$la['DRIVER'].'</th>';
		}
		
		if (in_array("trailer", $data_items))
		{
			$result .= '<th>'.$la['TRAILER'].'</th>';
		}
		
		if (in_array("gps_device", $data_items))
		{
			$result .= '<th>'.$la['GPS_DEVICE'].'</th>';
		}
		
		if (in_array("sim_card_number", $data_items))
		{
			if ($gsValues['SIM_NUMBER'] == 'true')
			{
				$result .= '<th>'.$la['SIM_CARD_NUMBER'].'</th>';	
			}			
		}
		
		$result .= '</tr>';
		
		for ($i=0; $i<count($imeis); ++$i)
		{
			$imei = $imeis[$i];
						
			$q = "SELECT gs_objects.*, gs_user_objects.*
				FROM gs_objects
				INNER JOIN gs_user_objects ON gs_objects.imei = gs_user_objects.imei
				WHERE gs_user_objects.user_id='".$user_id."' AND gs_user_objects.imei='".$imei."'";
			$r = mysqli_query($ms, $q);
			$row = mysqli_fetch_array($r);
			
			$odometer = getObjectOdometer($imei);
			$odometer = floor(convDistanceUnits($odometer, 'km', $_SESSION["unit_distance"]));
			
			$result .= '<tr align="center">';
			
			$result .= '<td>'.$row['name'].'</td>';
			
			if (in_array("imei", $data_items))
			{
				$result .= '<td>'.$row['imei'].'</td>';
			}
			
			if (in_array("group", $data_items))
			{
				$group_name = '';
			
				if (isset($groups[$row['group_id']]))
				{
					$group_name = $groups[$row['group_id']];
				}
			
				$result .= '<td>'.$group_name.'</td>';
			}
			
			if (in_array("transport_model", $data_items))
			{
				$result .= '<td>'.$row['model'].'</td>';
			}
			
			if (in_array("vin", $data_items))
			{
				$result .= '<td>'.$row['vin'].'</td>';
			}
			
			if (in_array("plate_number", $data_items))
			{
				$result .= '<td>'.$row['plate_number'].'</td>';
			}
			
			if (in_array("odometer", $data_items))
			{
				$result .= '<td>'.$odometer.' '.$la["UNIT_DISTANCE"].'</td>';
			}
			
			if (in_array("engine_hours", $data_items))
			{
				$result .= '<td>'.getObjectEngineHours($imei, true).'</td>';
			}
			
			if (in_array("driver", $data_items))
			{
				$params = json_decode($row['params'],true);
				$driver = getObjectDriver($user_id, $imei, $params);
				if ($driver['driver_name'] == ''){$driver['driver_name'] = $la['NA'];}
				
				$result .= '<td>'.$driver['driver_name'].'</td>';
			}
			
			if (in_array("trailer", $data_items))
			{
				$params = json_decode($row['params'],true);
				$trailer = getObjectTrailer($user_id, $imei, $params);
				if ($trailer['trailer_name'] == ''){$trailer['trailer_name'] = $la['NA'];}
				
				$result .= '<td>'.$trailer['trailer_name'].'</td>';
			}
			
			if (in_array("gps_device", $data_items))
			{
				$result .= '<td>'.$row['device'].'</td>';
			}
			
			if (in_array("sim_card_number", $data_items))
			{
				if ($gsValues['SIM_NUMBER'] == 'true')
				{
					$result .= '<td>'.$row['sim_number'].'</td>';	
				}				
			}
			
			$result .= '</tr>';
		}
		
		$result .= '</table>';
		
		return $result;
	}
	
	function reportsGenerateCurrentPosition($imeis, $dtf, $dtt, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items, $status)
	{
		global $ms, $_SESSION, $gsValues, $la, $user_id;
		
		$result = '';
		
		$result = '<table class="report" width="100%" ><tr align="center">';
				
		$result .= '<th>'.$la['OBJECT'].'</th>';
		
		if (in_array("time", $data_items))
		{
			$result .= '<th>'.$la['TIME'].'</th>';
		}
		
		if (in_array("position", $data_items))
		{
			$result .= '<th>'.$la['POSITION'].'</th>';
		}
		
		if (in_array("speed", $data_items))
		{
			$result .= '<th>'.$la['SPEED'].'</th>';
		}
		
		if (in_array("altitude", $data_items))
		{
			$result .= '<th>'.$la['ALTITUDE'].'</th>';
		}
		
		if (in_array("angle", $data_items))
		{
			$result .= '<th>'.$la['ANGLE'].'</th>';
		}
		
		if (in_array("status", $data_items))
		{
			$result .= '<th>'.$la['STATUS'].'</th>';
		}
		
		if (in_array("odometer", $data_items))
		{
			$result .= '<th>'.$la['ODOMETER'].'</th>';
		}
		
		if (in_array("engine_hours", $data_items))
		{
			$result .= '<th>'.$la['ENGINE_HOURS'].'</th>';
		}
		
		if (in_array("driver", $data_items))
		{
			$result .= '<th>'.$la['DRIVER'].'</th>';
		}
		
		if (in_array("trailer", $data_items))
		{
			$result .= '<th>'.$la['TRAILER'].'</th>';
		}
		
		$result .= '</tr>';
		
		for ($i=0; $i<count($imeis); ++$i)
		{
			$imei = $imeis[$i];
			
			$q = "SELECT * FROM `gs_objects` WHERE `imei`='".$imei."'";
			$r = mysqli_query($ms, $q);
			
			while($row = mysqli_fetch_array($r))
			{
				$dt_server = $row['dt_server'];
				$dt_tracker = $row['dt_tracker'];
				$lat = $row['lat'];
				$lng = $row['lng'];
				$altitude = $row['altitude'];
				$angle = $row['angle'];
				$speed = $row['speed'];
				
				if (($lat != 0) && ($lng != 0))
				{					
					$speed = convSpeedUnits($speed, 'km', $_SESSION["unit_distance"]);
					$altitude = convAltitudeUnits($altitude, 'km', $_SESSION["unit_distance"]);
					
					// status
					$status_type = false;
					$status_str = '';					
					$dt_last_stop = strtotime($row['dt_last_stop']);
					$dt_last_idle = strtotime($row['dt_last_idle']);
					$dt_last_move = strtotime($row['dt_last_move']);
					
					if (($dt_last_stop > 0) || ($dt_last_move > 0))
					{
						// stopped and moving
						if ($dt_last_stop >= $dt_last_move)
						{
							$status_type = 'stopped';
							$status_str = $la['STOPPED'].' '.getTimeDetails(strtotime(gmdate("Y-m-d H:i:s")) - $dt_last_stop, true);
						}
						else
						{
							$status_type = 'moving';
							$status_str = $la['MOVING'].' '.getTimeDetails(strtotime(gmdate("Y-m-d H:i:s")) - $dt_last_move, true);
						}
						
						// idle
						if (($dt_last_stop <= $dt_last_idle) && ($dt_last_move <= $dt_last_idle))
						{
							$status_type = 'idle';
							$status_str = $la['ENGINE_IDLE'].' '.getTimeDetails(strtotime(gmdate("Y-m-d H:i:s")) - $dt_last_idle, true);
						}
					}
					
					// offline status
					$dt_now = gmdate("Y-m-d H:i:s");
					$dt_difference = strtotime($dt_now) - strtotime($dt_server);
					if($dt_difference > $gsValues['CONNECTION_TIMEOUT'] * 60)
					{
						if (strtotime($dt_server) > 0)
						{
							$status_type = 'offline';
							$status_str = $la['OFFLINE'].' '.getTimeDetails(strtotime(gmdate("Y-m-d H:i:s")) - strtotime($dt_server), true);
						}
						
						$speed = 0;
					}
					
					// filter status
					if (($status != false) && ($status != $status_type))
					{
						continue;
					}
					
					$odometer = getObjectOdometer($imei);
					$odometer = floor(convDistanceUnits($odometer, 'km', $_SESSION["unit_distance"]));
					
					$result .= '<tr align="center">';
					
					$result .= '<td>'.getObjectName($imei).'</td>';
					
					if (in_array("time", $data_items))
					{
						$result .= '<td>'.convUserTimezone($dt_tracker).'</td>';
					}
					
					if (in_array("position", $data_items))
					{
						$result .= '<td>'.reportsGetPossition($lat, $lng, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses).'</td>';
					}
					
					if (in_array("speed", $data_items))
					{
						$result .= '<td>'.$speed.' '.$la["UNIT_SPEED"].'</td>';
					}
					
					if (in_array("altitude", $data_items))
					{
						$result .= '<td>'.$altitude.' '.$la["UNIT_HEIGHT"].'</td>';
					}
					
					if (in_array("angle", $data_items))
					{
						$result .= '<td>'.$angle.'</td>';
					}
					
					if (in_array("status", $data_items))
					{
						$result .= '<td>'.$status_str.'</td>';
					}
					
					if (in_array("odometer", $data_items))
					{
						$result .= '<td>'.$odometer.' '.$la["UNIT_DISTANCE"].'</td>';
					}
					
					if (in_array("engine_hours", $data_items))
					{
						$result .= '<td>'.getObjectEngineHours($imei, true).'</td>';
					}
					
					if (in_array("driver", $data_items))
					{
						$params = json_decode($row['params'],true);
						$driver = getObjectDriver($user_id, $imei, $params);
						if ($driver['driver_name'] == ''){$driver['driver_name'] = $la['NA'];}
						
						$result .= '<td>'.$driver['driver_name'].'</td>';
					}
					
					if (in_array("trailer", $data_items))
					{
						$params = json_decode($row['params'],true);
						$trailer = getObjectTrailer($user_id, $imei, $params);
						if ($trailer['trailer_name'] == ''){$trailer['trailer_name'] = $la['NA'];}
						
						$result .= '<td>'.$trailer['trailer_name'].'</td>';
					}
		
					$result .= '</tr>';
				}
				else
				{
					$result .= '<tr align="center">';
					$result .= '<td>'.getObjectName($imei).'</td>';
					$result .= '<td colspan="9">'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td>';
					$result .= '</tr>';
				}
			}
		}
		
		$result .= '</table>';
		
		return $result;
	}
	
	function reportsGenerateRouteDataSensors($imei, $dtf, $dtt, $sensors, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items)	
	{
		global $ms, $_SESSION, $gsValues, $la;
		
		$result = '';
		
		$accuracy = getObjectAccuracy($imei);
		
		$route = getRouteRaw($imei, $accuracy, $dtf, $dtt);
		if (count($route) == 0)
		{
			return false;
		}
		
		$result = '<table class="report" width="100%" ><tr align="center">';
		
		if (in_array("time", $data_items))
		{
			$result .= '<th>'.$la['TIME'].'</th>';
		}
		
		if (in_array("position", $data_items))
		{
			$result .= '<th>'.$la['POSITION'].'</th>';
		}
		
		if (in_array("speed", $data_items))
		{
			$result .= '<th>'.$la['SPEED'].'</th>';
		}
		
		if (in_array("altitude", $data_items))
		{
			$result .= '<th>'.$la['ALTITUDE'].'</th>';
		}
		
		if (in_array("angle", $data_items))
		{
			$result .= '<th>'.$la['ANGLE'].'</th>';
		}
		
		for ($k=0; $k<count($sensors); ++$k)
		{
			$sensor = $sensors[$k];
			if (($sensors[$k]['result_type'] == 'logic') || ($sensors[$k]['result_type'] == 'value') || ($sensors[$k]['result_type'] == 'percentage'))
			{
				$result .= '<th>'.$sensor['name'].'</th>';	
			}			
		}
		
		$result .= '</tr>';

$is_interval = false;
		
		for ($i=0; $i<count($route); ++$i)
		{
			$dt_tracker = $route[$i][0];
			
			if (isset($prev_dt_tracker))
			{
				$dt_difference = strtotime($dt_tracker) - strtotime($prev_dt_tracker);
				if ($dt_difference >= 300)
				{
					$is_interval = true;
				}
			}
			
			if (($i == 0) || ($i == count($route)-1) || ($is_interval == true))
			{
				$prev_dt_tracker = $dt_tracker;
				$is_interval = false;
				
				$lat = $route[$i][1];
				$lng = $route[$i][2];
				$altitude = $route[$i][3];
				$angle = $route[$i][4];
				$speed = $route[$i][5];
				$params = $route[$i][6];
				
				$result .= '<tr align="center">';
				
				if (in_array("time", $data_items))
				{
					$result .= '<td>'.$dt_tracker.'</td>';
				}
				
				if (in_array("position", $data_items))
				{
					$result .= '<td>'.reportsGetPossition($lat, $lng, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses).'</td>';
				}
				
				if (in_array("speed", $data_items))
				{
					$result .= '<td>'.$speed.' '.$la["UNIT_SPEED"].'</td>';
				}
				
				if (in_array("altitude", $data_items))
				{
					$result .= '<td>'.$altitude.' '.$la["UNIT_HEIGHT"].'</td>';
				}
				
				if (in_array("angle", $data_items))
				{
					$result .= '<td>'.$angle.'</td>';
				}
				
				for ($k=0; $k<count($sensors); ++$k)
				{
					$sensor = $sensors[$k];
					if (($sensors[$k]['result_type'] == 'logic') || ($sensors[$k]['result_type'] == 'value') || ($sensors[$k]['result_type'] == 'percentage'))
					{
						$sensor_data = getSensorValue($params, $sensors[$k]);
						$result .= '<td>'.$sensor_data['value_full'].'</td>';	
					}			
				}
				
				$result .= '</tr>';	
			}
		}
		
		$result .= '</table>';
		
		return $result;
	}

$result .= '</table><br/>';
		
		$result .= '<table>';
		
		if (in_array("move_duration", $data_items))
		{
			$result .= 	'<tr>
						<td><strong>'.$la['MOVE_DURATION'].':</strong></td>
						<td>'.$data['drives_duration'].'</td>
					</tr>';
		}
		
		if (in_array("stop_duration", $data_items))
		{
			$result .= 	'<tr>
						<td><strong>'.$la['STOP_DURATION'].':</strong></td>
						<td>'.$data['stops_duration'].'</td>
					</tr>';
		}
		
		if (in_array("route_length", $data_items))
		{
			$result .= 	'<tr>
						<td><strong>'.$la['ROUTE_LENGTH'].':</strong></td>
						<td>'.$data['route_length'].' '.$la["UNIT_DISTANCE"].'</td>
					</tr>';
		}
		
		if (in_array("top_speed", $data_items))
		{
			$result .= 	'<tr>
						<td><strong>'.$la['TOP_SPEED'].':</strong></td>
						<td>'.$data['top_speed'].' '.$la["UNIT_SPEED"].'</td>
					</tr>';
		}
		
		if (in_array("avg_speed", $data_items))
		{
			$result .= 	'<tr>
						<td><strong>'.$la['AVG_SPEED'].':</strong></td>
						<td>'.$data['avg_speed'].' '.$la["UNIT_SPEED"].'</td>
					</tr>';
		}
		
		if (in_array("fuel_consumption", $data_items))
		{
			$result .= 	'<tr>
						<td><strong>'.$la['FUEL_CONSUMPTION'].':</strong></td>
						<td>'.$data['fuel_consumption'].' '.$la["UNIT_CAPACITY"].'</td>
					</tr>';
		}
		
		if (in_array("avg_fuel_consumption", $data_items))
		{
			if ($_SESSION["unit_capacity"] == 'l')
			{
				$result .= 	'<tr>
						<td><strong>'.$la['AVG_FUEL_CONSUMPTION_100_KM'].':</strong></td>
						<td>'.$data['fuel_consumption_per_100km'].' '.$la["UNIT_CAPACITY"].'</td>
					</tr>';
			}
			else
			{
				$result .= 	'<tr>
						<td><strong>'.$la['AVG_FUEL_CONSUMPTION_MPG'].':</strong></td>
						<td>'.$data['fuel_consumption_mpg'].' '.$la["UNIT_MI"].'</td>
					</tr>';
			}
		}
		
		if (in_array("fuel_cost", $data_items))
		{
			$result .= 	'<tr>
						<td><strong>'.$la['FUEL_COST'].':</strong></td>
						<td>'.$data['fuel_cost'].' '.$_SESSION["currency"].'</td>
					</tr>';
		}
		
		if (in_array("engine_work", $data_items))
		{
			$result .= 	'<tr>
						<td><strong>'.$la['ENGINE_WORK'].':</strong></td>
						<td>'.$data['engine_work'].'</td>
					</tr>';
		}
		
		if (in_array("engine_idle", $data_items))
		{
			$result .= 	'<tr>
						<td><strong>'.$la['ENGINE_IDLE'].':</strong></td>
						<td>'.$data['engine_idle'].'</td>
					</tr>';
		}
		
		$result .= '</table>';
		
		return $result;
	}
	
	function reportsGenerateTravelSheet($imei, $dtf, $dtt, $stop_duration, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items) //TRAVEL_SHEET
	{
		global $la, $user_id;
		
		$result = '';		
		$data = getRoute($user_id, $imei, $dtf, $dtt, $stop_duration, true);
		
		if (count($data['drives']) < 1)
		{
			return false;
		}
		
		// get odo sensor
		$odo_sensor = getSensorFromType($imei, 'odo');
		
		$result = '<table class="report" width="100%"><tr align="center">';
		
		if (in_array("time_a", $data_items))
		{
			$result .= '<th>'.$la['TIME_A'].'</th>';
		}
		
		if (in_array("position_a", $data_items))
		{
			$result .= '<th>'.$la['POSITION_A'].'</th>';
		}
		
		if (in_array("odometer_a", $data_items))
		{
			$result .= '<th>'.$la['ODOMETER_A'].'</th>';
		}
		
		if (in_array("time_b", $data_items))
		{
			$result .= '<th>'.$la['TIME_B'].'</th>';
		}
		
		if (in_array("position_b", $data_items))
		{
			$result .= '<th>'.$la['POSITION_B'].'</th>';
		}
		
		if (in_array("odometer_b", $data_items))
		{
			$result .= '<th>'.$la['ODOMETER_B'].'</th>';
		}
		
		if (in_array("duration", $data_items))
		{
			$result .= '<th>'.$la['DURATION'].'</th>';
		}
		
		if (in_array("route_length", $data_items))
		{
			$result .= '<th>'.$la['LENGTH'].'</th>';
		}
		
		if (in_array("fuel_consumption", $data_items))
		{
			$result .= '<th>'.$la['FUEL_CONSUMPTION'].'</th>';
		}
		
		if (in_array("avg_fuel_consumption", $data_items))
		{
			if ($_SESSION["unit_capacity"] == 'l')
			{
				$result .= '<th>'.$la['AVG_FUEL_CONSUMPTION_100_KM'].'</th>';
			}
			else
			{
				$result .= '<th>'.$la['AVG_FUEL_CONSUMPTION_MPG'].'</th>';
			}
		}
		
		if (in_array("fuel_cost", $data_items))
		{
			$result .= '<th>'.$la['FUEL_COST'].'</th>';
		}
		
		if (in_array("driver", $data_items))
		{
			$result .= '<th>'.$la['DRIVER'].'</th>';
		}
		
		if (in_array("trailer", $data_items))
		{
			$result .= '<th>'.$la['TRAILER'].'</th>';
		}		
		
		$result .= '</tr>';
		
		for ($j=0; $j<count($data['drives']); ++$j)
		{			
			$route_id_a = $data['drives'][$j][0];
			$route_id_b = $data['drives'][$j][2];
			
			$lat1 = sprintf("%01.6f", $data['route'][$route_id_a][1]);
			$lng1 = sprintf("%01.6f", $data['route'][$route_id_a][2]);
			$lat2 = sprintf("%01.6f", $data['route'][$route_id_b][1]);
			$lng2 = sprintf("%01.6f", $data['route'][$route_id_b][2]);
			
			$time_a = $data['drives'][$j][4];
			$time_b = $data['drives'][$j][5];
			
			$params_a = $data['route'][$route_id_a][6];
			$params_b = $data['route'][$route_id_b][6];
			
			// this prevents double geocoder calling
			if(!isset($position_a))
			{
				$position_a = reportsGetPossition($lat1, $lng1, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses);
			}
			else
			{
				$position_a = $position_b;
			}
			
			$position_b = reportsGetPossition($lat2, $lng2, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses);			
			
			if ($odo_sensor)
			{
				if ($odo_sensor[0]['result_type'] == 'abs')
				{
					$odometer_a = getSensorValue($params_a , $odo_sensor[0]);
					$odometer_a = convDistanceUnits($odometer_a['value'], 'km', $_SESSION["unit_distance"]);
					$odometer_a = round($odometer_a * 100) / 100;
					$odometer_a = $odometer_a.' '.$la["UNIT_DISTANCE"];	
				}
				else
				{
					$odometer_a = $la['NA'];
				}
			}
			else
			{
				$odometer_a = $la['NA'];
			}
			
			if ($odo_sensor)
			{
				if ($odo_sensor[0]['result_type'] == 'abs')
				{
					$odometer_b = getSensorValue($params_b , $odo_sensor[0]);
					$odometer_b = convDistanceUnits($odometer_b['value'], 'km', $_SESSION["unit_distance"]);
					$odometer_b = round($odometer_b * 100) / 100;
					$odometer_b = $odometer_b.' '.$la["UNIT_DISTANCE"];
				}
				else
				{
					$odometer_b = $la['NA'];
				}
			}
			else
			{
				$odometer_b = $la['NA'];
			}
			
			$duration = $data['drives'][$j][6];
			
			$route_length = $data['drives'][$j][7];
			
			$fuel_consumption = $data['drives'][$j][10];
			
			if (isset($data['stops'][$j]))
			{
				$fuel_consumption += $data['stops'][$j][9];	
			}
						
			$fuel_consumption = round($fuel_consumption * 100) / 100;
			
			if ($_SESSION["unit_capacity"] == 'l')
			{
				$avg_fuel_consumption = $data['drives'][$j][13];
			}
			else
			{
				$avg_fuel_consumption = $data['drives'][$j][14];
			}
				
			$fuel_cost = $data['drives'][$j][11];
			
			if (isset($data['stops'][$j]))
			{
				$fuel_cost += $data['stops'][$j][10];	
			}
						
			$fuel_cost = round($fuel_cost * 100) / 100;
			
			$result .= '<tr align="center">';
			
			if (in_array("time_a", $data_items))
			{
				$result .= '<td>'.$time_a.'</td>';
			}
			
			if (in_array("position_a", $data_items))
			{
				$result .= '<td>'.$position_a.'</td>';
			}
			
			if (in_array("odometer_a", $data_items))
			{
				$result .= '<td>'.$odometer_a.'</td>';
			}
			
			if (in_array("time_b", $data_items))
			{
				$result .= '<td>'.$time_b.'</td>';
			}
			
			if (in_array("position_b", $data_items))
			{
				$result .= '<td>'.$position_b.'</td>';
			}
			
			if (in_array("odometer_b", $data_items))
			{
				$result .= '<td>'.$odometer_b.'</td>';
			}
			
			if (in_array("duration", $data_items))
			{
				$result .= '<td>'.$duration.'</td>';
			}
			
			if (in_array("route_length", $data_items))
			{
				$result .= '<td>'.$route_length.' '.$la["UNIT_DISTANCE"].'</td>';
			}
			
			if (in_array("fuel_consumption", $data_items))
			{
				$result .= '<td>'.$fuel_consumption.' '.$la["UNIT_CAPACITY"].'</td>';
			}
			
			if (in_array("avg_fuel_consumption", $data_items))
			{
				
				if ($_SESSION["unit_capacity"] == 'l')
				{
					$result .= '<td>'.$avg_fuel_consumption.' '.$la["UNIT_CAPACITY"].'</td>';
				}
				else
				{
					$result .= '<td>'.$avg_fuel_consumption.' '.$la["UNIT_MI"].'</td>';
				}
			}
			
			if (in_array("fuel_cost", $data_items))
			{
				$result .= '<td>'.$fuel_cost.' '.$_SESSION["currency"].'</td>';
			}
			
			if (in_array("driver", $data_items))
			{
				$params = $data['route'][$data['drives'][$j][1]][6];
				$driver = getObjectDriver($user_id, $imei, $params);
				if ($driver['driver_name'] == ''){$driver['driver_name'] = $la['NA'];}
				
				$result .= '<td>'.$driver['driver_name'].'</td>';
			}
			
			if (in_array("trailer", $data_items))
			{
				$params = $data['route'][$data['drives'][$j][1]][6];
				$trailer = getObjectTrailer($user_id, $imei, $params);
				if ($trailer['trailer_name'] == ''){$trailer['trailer_name'] = $la['NA'];}
				
				$result .= '<td>'.$trailer['trailer_name'].'</td>';
			}
			
			$result .= '</tr>';
		}
		
		if (in_array("total", $data_items))
		{
			$result .= '<tr align="center">';
			
			if (in_array("time_a", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("position_a", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("odometer_a", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("time_b", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("position_b", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("odometer_b", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("duration", $data_items))
			{
				$result .= '<td>'.$data['drives_duration'].'</td>';
			}
			
			if (in_array("route_length", $data_items))
			{
				$result .= '<td>'.$data['route_length'].' '.$la["UNIT_DISTANCE"].'</td>';
			}
			
			if (in_array("fuel_consumption", $data_items))
			{
				$result .= '<td>'.$data['fuel_consumption'].' '.$la["UNIT_CAPACITY"].'</td>';
			}
			
			if (in_array("avg_fuel_consumption", $data_items))
			{
				if ($_SESSION["unit_capacity"] == 'l')
				{
					$result .= '<td>'.$data['fuel_consumption_per_100km'].' '.$la["UNIT_CAPACITY"].'</td>';
				}
				else
				{
					$result .= '<td>'.$data['fuel_consumption_mpg'].' '.$la["UNIT_MI"].'</td>';
				}
			}
			
			if (in_array("fuel_cost", $data_items))
			{
				$result .= '<td>'.$data['fuel_cost'].' '.$_SESSION["currency"].'</td>';
			}
			
			if (in_array("driver", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("trailer", $data_items))
			{
				$result .= '<td></td>';
			}
			
			$result .= '</tr>';
		}
			
		$result .= '</table>';
		
		return $result;
	}
	
	function reportsGenerateTravelSheetDayNight($imei, $dtf, $dtt, $stop_duration, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items, $other) //TRAVEL_SHEET_DAY_NIGHT
	{
		global $la, $user_id;
		
		$result = '';		
		$data = getRoute($user_id, $imei, $dtf, $dtt, $stop_duration, true);
		
		if (count($data['drives']) < 1)
		{
			return false;
		}
		
		// get odo sensor
		$odo_sensor = getSensorFromType($imei, 'odo');
		
		$result = '<table class="report" width="100%"><tr align="center">';
		
		if (in_array("time_a", $data_items))
		{
			$result .= '<th>'.$la['TIME_A'].'</th>';
		}
		
		if (in_array("position_a", $data_items))
		{
			$result .= '<th>'.$la['POSITION_A'].'</th>';
		}
		
		if (in_array("odometer_a", $data_items))
		{
			$result .= '<th>'.$la['ODOMETER_A'].'</th>';
		}
		
		if (in_array("time_b", $data_items))
		{
			$result .= '<th>'.$la['TIME_B'].'</th>';
		}
		
		if (in_array("position_b", $data_items))
		{
			$result .= '<th>'.$la['POSITION_B'].'</th>';
		}
		
		if (in_array("odometer_b", $data_items))
		{
			$result .= '<th>'.$la['ODOMETER_B'].'</th>';
		}
		
		if (in_array("duration", $data_items))
		{
			$result .= '<th>'.$la['DURATION'].'</th>';
		}
		
		if (in_array("route_length", $data_items))
		{
			$result .= '<th>'.$la['LENGTH'].'</th>';
		}
		
		if (in_array("fuel_consumption", $data_items))
		{
			$result .= '<th>'.$la['FUEL_CONSUMPTION'].'</th>';
		}
		
		if (in_array("avg_fuel_consumption", $data_items))
		{
			if ($_SESSION["unit_capacity"] == 'l')
			{
				$result .= '<th>'.$la['AVG_FUEL_CONSUMPTION_100_KM'].'</th>';
			}
			else
			{
				$result .= '<th>'.$la['AVG_FUEL_CONSUMPTION_MPG'].'</th>';
			}
		}
		
		if (in_array("fuel_cost", $data_items))
		{
			$result .= '<th>'.$la['FUEL_COST'].'</th>';
		}
		
		if (in_array("driver", $data_items))
		{
			$result .= '<th>'.$la['DRIVER'].'</th>';
		}
		
		if (in_array("trailer", $data_items))
		{
			$result .= '<th>'.$la['TRAILER'].'</th>';
		}		
		
		$result .= '</tr>';
		
		$total_day_duration = 0;
		$total_day_route_length = 0;
		$total_day_fuel_consumption = 0;
		$total_day_avg_fuel_consumption = 0;
		$total_day_fuel_cost = 0;
		
		$total_night_duration = 0;
		$total_night_route_length = 0;
		$total_night_fuel_consumption = 0;
		$total_night_avg_fuel_consumption = 0;
		$total_night_fuel_cost = 0;
		
		for ($j=0; $j<count($data['drives']); ++$j)
		{			
			$route_id_a = $data['drives'][$j][0];
			$route_id_b = $data['drives'][$j][2];
			
			$lat1 = sprintf("%01.6f", $data['route'][$route_id_a][1]);
			$lng1 = sprintf("%01.6f", $data['route'][$route_id_a][2]);
			$lat2 = sprintf("%01.6f", $data['route'][$route_id_b][1]);
			$lng2 = sprintf("%01.6f", $data['route'][$route_id_b][2]);
			
			$time_a = $data['drives'][$j][4];
			$time_b = $data['drives'][$j][5];
			
			$params_a = $data['route'][$route_id_a][6];
			$params_b = $data['route'][$route_id_b][6];
			
			// day night
			$is_night = false;
			$dt_check = intval(date("Hi", strtotime($time_a)));
			$from = intval($other["dn_starts_hour"].$other["dn_starts_minute"]);		
			$to = intval($other["dn_ends_hour"].$other["dn_ends_minute"]);
			
			if ($from > $to)
			{
				if (($from <= $dt_check) && (2400 >= $dt_check))
				{
					$is_night = true;
				}
				
				if (($to >= $dt_check) && (0000 <= $dt_check))
				{
					$is_night = true;
				}
			}
			else
			{
				if (($from <= $dt_check) && ($to >= $dt_check))
				{
					$is_night = true;
				}
			}
					
			// this prevents double geocoder calling
			if(!isset($position_a))
			{
				$position_a = reportsGetPossition($lat1, $lng1, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses);
			}
			else
			{
				$position_a = $position_b;
			}
			
			$position_b = reportsGetPossition($lat2, $lng2, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses);
			
			if ($odo_sensor)
			{
				if ($odo_sensor[0]['result_type'] == 'abs')
				{
					$odometer_a = getSensorValue($params_a , $odo_sensor[0]);
					$odometer_a = convDistanceUnits($odometer_a['value'], 'km', $_SESSION["unit_distance"]);
					$odometer_a = round($odometer_a * 100) / 100;
					$odometer_a = $odometer_a.' '.$la["UNIT_DISTANCE"];	
				}
				else
				{
					$odometer_a = $la['NA'];
				}
			}
			else
			{
				$odometer_a = $la['NA'];
			}
			
			if ($odo_sensor)
			{
				if ($odo_sensor[0]['result_type'] == 'abs')
				{
					$odometer_b = getSensorValue($params_b , $odo_sensor[0]);
					$odometer_b = convDistanceUnits($odometer_b['value'], 'km', $_SESSION["unit_distance"]);
					$odometer_b = round($odometer_b * 100) / 100;
					$odometer_b = $odometer_b.' '.$la["UNIT_DISTANCE"];
				}
				else
				{
					$odometer_b = $la['NA'];
				}
			}
			else
			{
				$odometer_b = $la['NA'];
			}
			
			$duration = $data['drives'][$j][6];			
			
			if ($is_night)
			{
				$diff = strtotime($time_b)-strtotime($time_a);
				$total_night_duration += $diff;
			}
			else
			{
				$diff = strtotime($time_b)-strtotime($time_a);
				$total_day_duration += $diff;
			}
			
			$route_length = $data['drives'][$j][7];
			
			if ($is_night)
			{
				$total_night_route_length += $route_length;
			}
			else
			{
				$total_day_route_length += $route_length;
			}
			
			$fuel_consumption = $data['drives'][$j][10];
			
			if (isset($data['stops'][$j]))
			{
				$fuel_consumption += $data['stops'][$j][9];	
			}
						
			$fuel_consumption = round($fuel_consumption * 100) / 100;
			
			if ($is_night)
			{
				$total_night_fuel_consumption += $fuel_consumption;
			}
			else
			{
				$total_day_fuel_consumption += $fuel_consumption;
			}
			
			if ($_SESSION["unit_capacity"] == 'l')
			{
				$avg_fuel_consumption = $data['drives'][$j][13];
			}
			else
			{
				$avg_fuel_consumption = $data['drives'][$j][14];
			}
				
			$fuel_cost = $data['drives'][$j][11];
			
			if (isset($data['stops'][$j]))
			{
				$fuel_cost += $data['stops'][$j][10];	
			}
						
			$fuel_cost = round($fuel_cost * 100) / 100;			
			
			if ($is_night)
			{
				$total_night_fuel_cost += $fuel_cost;
			}
			else
			{
				$total_day_fuel_cost += $fuel_cost;
			}
			
			if ($is_night)
			{
				$result .= '<tr align="center" class="night">';	
			}
			else
			{
				$result .= '<tr align="center">';	
			}
			
			if (in_array("time_a", $data_items))
			{
				$result .= '<td>'.$time_a.'</td>';
			}
			
			if (in_array("position_a", $data_items))
			{
				$result .= '<td>'.$position_a.'</td>';
			}
			
			if (in_array("odometer_a", $data_items))
			{
				$result .= '<td>'.$odometer_a.'</td>';
			}
			
			if (in_array("time_b", $data_items))
			{
				$result .= '<td>'.$time_b.'</td>';
			}
			
			if (in_array("position_b", $data_items))
			{
				$result .= '<td>'.$position_b.'</td>';
			}
			
			if (in_array("odometer_b", $data_items))
			{
				$result .= '<td>'.$odometer_b.'</td>';
			}
			
			if (in_array("duration", $data_items))
			{
				$result .= '<td>'.$duration.'</td>';
			}
			
			if (in_array("route_length", $data_items))
			{
				$result .= '<td>'.$route_length.' '.$la["UNIT_DISTANCE"].'</td>';
			}
			
			if (in_array("fuel_consumption", $data_items))
			{
				$result .= '<td>'.$fuel_consumption.' '.$la["UNIT_CAPACITY"].'</td>';
			}
			
			if (in_array("avg_fuel_consumption", $data_items))
			{				
				if ($_SESSION["unit_capacity"] == 'l')
				{
					$result .= '<td>'.$avg_fuel_consumption.' '.$la["UNIT_CAPACITY"].'</td>';
				}
				else
				{
					$result .= '<td>'.$avg_fuel_consumption.' '.$la["UNIT_MI"].'</td>';
				}
			}
			
			if (in_array("fuel_cost", $data_items))
			{
				$result .= '<td>'.$fuel_cost.' '.$_SESSION["currency"].'</td>';
			}
			
			if (in_array("driver", $data_items))
			{
				$params = $data['route'][$data['drives'][$j][1]][6];
				$driver = getObjectDriver($user_id, $imei, $params);
				if ($driver['driver_name'] == ''){$driver['driver_name'] = $la['NA'];}
				
				$result .= '<td>'.$driver['driver_name'].'</td>';
			}
			
			if (in_array("trailer", $data_items))
			{
				$params = $data['route'][$data['drives'][$j][1]][6];
				$trailer = getObjectTrailer($user_id, $imei, $params);
				if ($trailer['trailer_name'] == ''){$trailer['trailer_name'] = $la['NA'];}
				
				$result .= '<td>'.$trailer['trailer_name'].'</td>';
			}
			
			$result .= '</tr>';
		}
		
		if (($total_night_fuel_consumption > 0) && ($total_night_route_length > 0))
		{
			$total_night_avg_fuel_consumption = ($total_night_fuel_consumption / $total_night_route_length) * 100;				
			$total_night_avg_fuel_consumption = round($total_night_avg_fuel_consumption * 100) / 100;
		}
		
		if (($total_day_fuel_consumption > 0) && ($total_day_route_length > 0))
		{
			$total_day_avg_fuel_consumption = ($total_day_fuel_consumption / $total_day_route_length) * 100;				
			$total_day_avg_fuel_consumption = round($total_day_avg_fuel_consumption * 100) / 100;
		}

if (in_array("total", $data_items))
		{
			$result .= '<tr align="center">';
			
			if (in_array("time_a", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("position_a", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("odometer_a", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("time_b", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("position_b", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("odometer_b", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("duration", $data_items))
			{
				$total_day_duration = getTimeDetails($total_day_duration, true);
				$result .= '<td>'.$total_day_duration.'</td>';
			}
			
			if (in_array("route_length", $data_items))
			{
				$result .= '<td>'.$total_day_route_length.' '.$la["UNIT_DISTANCE"].'</td>';
			}
			
			if (in_array("fuel_consumption", $data_items))
			{
				$result .= '<td>'.$total_day_fuel_consumption.' '.$la["UNIT_CAPACITY"].'</td>';
			}
			
			if (in_array("avg_fuel_consumption", $data_items))
			{
				if ($_SESSION["unit_capacity"] == 'l')
				{
					$result .= '<td>'.$total_day_avg_fuel_consumption.' '.$la["UNIT_CAPACITY"].'</td>';
				}
				else
				{
					$result .= '<td>'.$total_day_avg_fuel_consumption.' '.$la["UNIT_MI"].'</td>';
				}
			}
			
			if (in_array("fuel_cost", $data_items))
			{
				$result .= '<td>'.$total_day_fuel_cost.' '.$_SESSION["currency"].'</td>';
			}
			
			if (in_array("driver", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("trailer", $data_items))
			{
				$result .= '<td></td>';
			}
			
			$result .= '</tr>';
		}
		
		if (in_array("total", $data_items))
		{
			$result .= '<tr align="center">';
			
			if (in_array("time_a", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("position_a", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("odometer_a", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("time_b", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("position_b", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("odometer_b", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("duration", $data_items))
			{
				$total_night_duration = getTimeDetails($total_night_duration, true);
				$result .= '<td class="night">'.$total_night_duration.'</td>';
			}
			
			if (in_array("route_length", $data_items))
			{
				$result .= '<td class="night">'.$total_night_route_length.' '.$la["UNIT_DISTANCE"].'</td>';
			}
			
			if (in_array("fuel_consumption", $data_items))
			{
				$result .= '<td class="night">'.$total_night_fuel_consumption.' '.$la["UNIT_CAPACITY"].'</td>';
			}
			
			if (in_array("avg_fuel_consumption", $data_items))
			{
				if ($_SESSION["unit_capacity"] == 'l')
				{
					$result .= '<td class="night">'.$total_night_avg_fuel_consumption.' '.$la["UNIT_CAPACITY"].'</td>';
				}
				else
				{
					$result .= '<td class="night">'.$total_night_avg_fuel_consumption.' '.$la["UNIT_MI"].'</td>';
				}
			}
			
			if (in_array("fuel_cost", $data_items))
			{
				$result .= '<td class="night">'.$total_night_fuel_cost.' '.$_SESSION["currency"].'</td>';
			}
			
			if (in_array("driver", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("trailer", $data_items))
			{
				$result .= '<td></td>';
			}
			
			$result .= '</tr>';
		}
		
		if (in_array("total", $data_items))
		{
			$result .= '<tr align="center">';
			
			if (in_array("time_a", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("position_a", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("odometer_a", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("time_b", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("position_b", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("odometer_b", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("duration", $data_items))
			{
				$result .= '<td>'.$data['drives_duration'].'</td>';
			}
			
			if (in_array("route_length", $data_items))
			{
				$result .= '<td>'.$data['route_length'].' '.$la["UNIT_DISTANCE"].'</td>';
			}
			
			if (in_array("fuel_consumption", $data_items))
			{
				$result .= '<td>'.$data['fuel_consumption'].' '.$la["UNIT_CAPACITY"].'</td>';
			}
			
			if (in_array("avg_fuel_consumption", $data_items))
			{
				if ($_SESSION["unit_capacity"] == 'l')
				{
					$result .= '<td>'.$data['fuel_consumption_per_100km'].' '.$la["UNIT_CAPACITY"].'</td>';
				}
				else
				{
					$result .= '<td>'.$data['fuel_consumption_mpg'].' '.$la["UNIT_MI"].'</td>';
				}
			}
			
			if (in_array("fuel_cost", $data_items))
			{
				$result .= '<td>'.$data['fuel_cost'].' '.$_SESSION["currency"].'</td>';
			}
			
			if (in_array("driver", $data_items))
			{
				$result .= '<td></td>';
			}
			
			if (in_array("trailer", $data_items))
			{
				$result .= '<td></td>';
			}
			
			$result .= '</tr>';
		}
			
		$result .= '</table>';
		
		return $result;
	}
	
	function reportsGenerateMileageDaily($imei, $dtf, $dtt, $data_items) //MILEAGE_DAILY
	{
		global $la, $user_id;
		
		$result = '';
		
		// get date ranges
		$dates = array();
		$current = strtotime($dtf);
		$last = strtotime($dtt);
		
		while($current < $last)
		{
			$date = gmdate('Y-m-d H:i:s', $current);
			
			if (count($dates) == 0)
			{
				$dates[] = $date;
			}
			else
			{
				$dates[] = convUserUTCTimezone(substr(convUserTimezone($date),0,10));	
			}
						
			$current = strtotime('+1 day', $current);
		}
				
		array_push($dates, $dtt);
		
		$rows = '';
		
		$total_drives_duration = 0;
		$total_route_length = 0;
		$total_fuel_consumption = 0;
		$total_fuel_cost = 0;
		$total_engine_hours = 0;
		
		for ($i=0; $i<count($dates)-1; ++$i)
		{
			$result .= $dates[$i].'</br>';
			
			$data = getRoute($user_id, $imei, $dates[$i], $dates[$i+1], 1, true);
			
			if (count($data['route']) > 0)
			{				
				$rows .= '<tr align="center">';
				
				if (in_array("time", $data_items))
				{
					$rows .= '<td>'.substr($data['route'][0][0],0,10).'</td>';
				}
				
				if (in_array("start", $data_items))
				{
					$rows .= '<td>'.$data['route'][0][0].'</td>';
				}
				
				if (in_array("end", $data_items))
				{
					$rows .= '<td>'.$data['route'][count($data['route'])-1][0].'</td>';
				}
				
				if (in_array("move_duration", $data_items))
				{
					$rows .= '<td>'.$data['drives_duration'].'</td>';
					$total_drives_duration += $data['drives_duration_time'];
				}				
				
				if (in_array("route_length", $data_items))
				{
					$rows .= '<td>'.$data['route_length'].' '.$la["UNIT_DISTANCE"].'</td>';
					$total_route_length += $data['route_length'];
				}
				
				if (in_array("fuel_consumption", $data_items))
				{
					$rows .= '<td>'.$data['fuel_consumption'].' '.$la["UNIT_CAPACITY"].'</td>';
					$total_fuel_consumption += $data['fuel_consumption'];
				}
				
				if (in_array("avg_fuel_consumption", $data_items))
				{	
					if ($_SESSION["unit_capacity"] == 'l')
					{
						$rows .= '<td>'.$data['fuel_consumption_per_100km'].' '.$la["UNIT_CAPACITY"].'</td>';						
					}
					else
					{
						$rows .= '<td>'.$data['fuel_consumption_mpg'].' '.$la["UNIT_MI"].'</td>';						
					}
				}
				
				if (in_array("fuel_cost", $data_items))
				{
					$rows .= '<td>'.$data['fuel_cost'].' '.$_SESSION["currency"].'</td>';
					$total_fuel_cost += $data['fuel_cost'];
				}
				
				if (in_array("engine_hours", $data_items))
				{
					$rows .= '<td>'.getTimeDetails($data['engine_work_time'], true).'</td>';
					$total_engine_hours += $data['engine_work_time'];
				}
				
				if (in_array("driver", $data_items))
				{
					$params = $data['route'][0][6];
					$driver = getObjectDriver($user_id, $imei, $params);
					if ($driver['driver_name'] == ''){$driver['driver_name'] = $la['NA'];}
					
					$rows .= '<td>'.$driver['driver_name'].'</td>';
				}
				
				if (in_array("trailer", $data_items))
				{
					$params = $data['route'][0][6];
					$trailer = getObjectTrailer($user_id, $imei, $params);
					if ($trailer['trailer_name'] == ''){$trailer['trailer_name'] = $la['NA'];}
					
					$rows .= '<td>'.$trailer['trailer_name'].'</td>';
				}
				
				$rows .= '</tr>';
			}
		}
		
		if ($rows == '')
		{
			return false;
		}
		else
		{
			$result = '<table class="report" width="100%"><tr align="center">';
			
			if (in_array("time", $data_items))
			{
				$result .= '<th>'.$la['TIME'].'</th>';
			}
			
			if (in_array("start", $data_items))
			{
				$result .= '<th>'.$la['START'].'</th>';
			}
			
			if (in_array("end", $data_items))
			{
				$result .= '<th>'.$la['END'].'</th>';
			}
			
			if (in_array("move_duration", $data_items))
			{
				$result .= '<th>'.$la['MOVE_DURATION'].'</th>';
			}
			
			if (in_array("route_length", $data_items))
			{
				$result .= '<th>'.$la['LENGTH'].'</th>';
			}
			
			if (in_array("fuel_consumption", $data_items))
			{
				$result .= '<th>'.$la['FUEL_CONSUMPTION'].'</th>';
			}
			
			if (in_array("avg_fuel_consumption", $data_items))
			{
				if ($_SESSION["unit_capacity"] == 'l')
				{
					$result .= '<th>'.$la['AVG_FUEL_CONSUMPTION_100_KM'].'</th>';
				}
				else
				{					
					$result .= '<th>'.$la['AVG_FUEL_CONSUMPTION_MPG'].'</th>';
				}
			}
			
			if (in_array("fuel_cost", $data_items))
			{
				$result .= '<th>'.$la['FUEL_COST'].'</th>';
			}
			
			if (in_array("engine_hours", $data_items))
			{
				$result .= '<th>'.$la['ENGINE_HOURS'].'</th>';
			}
			
			if (in_array("driver", $data_items))
			{
				$result .= '<th>'.$la['DRIVER'].'</th>';
			}
			
			if (in_array("trailer", $data_items))
			{
				$result .= '<th>'.$la['TRAILER'].'</th>';
			}
			
			$result .= '</tr>';
			
			$result .= $rows;
			
			if (in_array("total", $data_items))
			{
				$result .= '<tr align="center">';
				
				if (in_array("time", $data_items))
				{
					$result .= '<td></td>';
				}
				
				if (in_array("start", $data_items))
				{
					$result .= '<td></td>';
				}
				
				if (in_array("end", $data_items))
				{
					$result .= '<td></td>';
				}
				
				if (in_array("move_duration", $data_items))
				{
					$result .= '<td>'.getTimeDetails($total_drives_duration, false).'</td>';
				}
				
				if (in_array("route_length", $data_items))
				{
					$result .= '<td>'.$total_route_length.' '.$la["UNIT_DISTANCE"].'</td>';
				}
				
				if (in_array("fuel_consumption", $data_items))
				{
					$result .= '<td>'.$total_fuel_consumption.' '.$la["UNIT_CAPACITY"].'</td>';
				}
				
				if (in_array("avg_fuel_consumption", $data_items))
				{
					if ($_SESSION["unit_capacity"] == 'l')
					{
						$total_avg_fuel_consumption = 0;
						
						if (($total_fuel_consumption > 0) && ($total_route_length > 0))
						{
							$total_avg_fuel_consumption = ($total_fuel_consumption / $total_route_length) * 100;
							$total_avg_fuel_consumption = round($total_avg_fuel_consumption * 100) / 100;	
						}						
						
						$result .= '<td>'.$total_avg_fuel_consumption.' '.$la["UNIT_CAPACITY"].'</td>';
					}
					else
					{
						$total_avg_fuel_consumption = 0;
						
						if (($total_fuel_consumption > 0) && ($total_route_length > 0))
						{
							$total_avg_fuel_consumption = ($total_route_length / $total_fuel_consumption);
							$total_avg_fuel_consumption = round($total_avg_fuel_consumption * 100) / 100;	
						}
						
						$result .= '<td>'.$total_avg_fuel_consumption.' '.$la["UNIT_MI"].'</td>';
					}
				}
				
				if (in_array("fuel_cost", $data_items))
				{
					$result .= '<td>'.$total_fuel_cost.' '.$_SESSION["currency"].'</td>';
				}
				
				if (in_array("engine_hours", $data_items))
				{
					$result .= '<td>'.getTimeDetails($total_engine_hours, true).'</td>';
				}
				
				if (in_array("driver", $data_items))
				{
					$result .= '<td></td>';
				}
				
				if (in_array("trailer", $data_items))
				{
					$result .= '<td></td>';
				}
				
				$result .= '</tr>';
			}
			
			$result .= '</table>';
		}
		
		return $result;
	}
	
	function reportsGenerateOverspeed($imei, $dtf, $dtt, $speed_limit, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items) //OVERSPEED
	{
		global $la, $user_id;
		
		$accuracy = getObjectAccuracy($imei);
		
		$route = getRouteRaw($imei, $accuracy, $dtf, $dtt);
		//$route = removeRouteFakeCoordinates($route, array());
		$overspeeds = getRouteOverspeeds($route, $speed_limit);
		
		if ((count($route) == 0) || (count($overspeeds) == 0))
		{
			return false;
		}
		
		$result = '<table class="report" width="100%"><tr align="center">';
		
		if (in_array("start", $data_items))
		{
			$result .= '<th>'.$la['START'].'</th>';
		}
		
		if (in_array("end", $data_items))
		{
			$result .= '<th>'.$la['END'].'</th>';
		}
		
		if (in_array("duration", $data_items))
		{
			$result .= '<th>'.$la['DURATION'].'</th>';
		}
		
		if (in_array("top_speed", $data_items))
		{
			$result .= '<th>'.$la['TOP_SPEED'].'</th>';
		}
		
		if (in_array("avg_speed", $data_items))
		{
			$result .= '<th>'.$la['AVG_SPEED'].'</th>';
		}
		
		if (in_array("overspeed_position", $data_items))
		{
			$result .= '<th>'.$la['OVERSPEED_POSITION'].'</th>';
		}
		
		if (in_array("driver", $data_items))
		{
			$result .= '<th>'.$la['DRIVER'].'</th>';
		}
		
		if (in_array("trailer", $data_items))
		{
			$result .= '<th>'.$la['TRAILER'].'</th>';
		}
		
		$result .= '</tr>';
		
		for ($i=0; $i<count($overspeeds); ++$i)
		{
			$result .= '<tr align="center">';
			
			if (in_array("start", $data_items))
			{
				$result .= '<td>'.$overspeeds[$i][0].'</td>';
			}
			
			if (in_array("end", $data_items))
			{
				$result .= '<td>'.$overspeeds[$i][1].'</td>';
			}
			
			if (in_array("duration", $data_items))
			{
				$result .= '<td>'.$overspeeds[$i][2].'</td>';
			}
			
			if (in_array("top_speed", $data_items))
			{
				$result .= '<td>'.$overspeeds[$i][3].' '.$la["UNIT_SPEED"].'</td>';
			}
			
			if (in_array("avg_speed", $data_items))
			{
				$result .= '<td>'.$overspeeds[$i][4].' '.$la["UNIT_SPEED"].'</td>';
			}
			
			if (in_array("overspeed_position", $data_items))
			{
				$result .= '<td>'.reportsGetPossition($overspeeds[$i][5], $overspeeds[$i][6], $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses).'</td>';
			}
			
			if (in_array("driver", $data_items))
			{
				$params = $overspeeds[$i][7];
				$driver = getObjectDriver($user_id, $imei, $params);
				if ($driver['driver_name'] == ''){$driver['driver_name'] = $la['NA'];}
				
				$result .= '<td>'.$driver['driver_name'].'</td>';
			}
			
			if (in_array("trailer", $data_items))
			{
				$params = $overspeeds[$i][7];
				$trailer = getObjectTrailer($user_id, $imei, $params);
				if ($trailer['trailer_name'] == ''){$trailer['trailer_name'] = $la['NA'];}
				
				$result .= '<td>'.$trailer['trailer_name'].'</td>';
			}
			
			$result .= '</tr>';
		}
		
		$result .= '</table>';
		
		return $result;
	}
	
	function reportsGenerateOverspeedCountMerged($imeis, $dtf, $dtt, $speed_limit, $data_items) //OVERSPEED_COUNT
	{
		global $ms, $_SESSION, $la, $user_id;
		
		$result = '<table class="report" width="100%"><tr align="center">';
		
		$result .= '<th>'.$la['OBJECT'].'</th>';
		
		if (in_array("route_start", $data_items))
		{
			$result .= '<th>'.$la['ROUTE_START'].'</th>';
		}
		
		if (in_array("route_end", $data_items))
		{
			$result .= '<th>'.$la['ROUTE_END'].'</th>';
		}
		
		if (in_array("route_length", $data_items))
		{
			$result .= '<th>'.$la['ROUTE_LENGTH'].'</th>';
		}
		
		if (in_array("move_duration", $data_items))
		{
			$result .= '<th>'.$la['MOVE_DURATION'].'</th>';
		}
		
		if (in_array("top_speed", $data_items))
		{
			$result .= '<th>'.$la['TOP_SPEED'].'</th>';
		}
		
		if (in_array("avg_speed", $data_items))
		{
			$result .= '<th>'.$la['AVG_SPEED'].'</th>';
		}
		
		if (in_array("overspeed_count", $data_items))
		{
			$result .= '<th>'.$la['OVERSPEED_COUNT'].'</th>';
		}
		
		$result .= '</tr>';
		
		for ($i=0; $i<count($imeis); ++$i)
		{
			$imei = $imeis[$i];
			
			$accuracy = getObjectAccuracy($imei);		
			$route = getRoute($user_id, $imei, $dtf, $dtt, 1, true);
			$overspeeds = getRouteOverspeeds($route['route'], $speed_limit);
											
			if (count($route['route']) == 0)
			{
				$result .= '<tr align="center">';
				$result .= '<td>'.getObjectName($imei).'</td>';
				$result .= '<td colspan="7">'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td>';
				$result .= '</tr>';
			}
			else
			{
				$result .= '<tr align="center">';
				
				$result .= '<td>'.getObjectName($imei).'</td>';
				
				if (in_array("route_start", $data_items))
				{
					$result .= '<td>'.$route['route'][0][0].'</td>';
				}
				
				if (in_array("route_end", $data_items))
				{
					$result .= '<td>'.$route['route'][count($route['route'])-1][0].'</td>';
				}
				
				if (in_array("route_length", $data_items))
				{
					$result .= '<td>'.$route['route_length'].' '.$la["UNIT_DISTANCE"].'</td>';					
				}
				
				if (in_array("move_duration", $data_items))
				{
					$result .= '<td>'.$route['drives_duration'].'</td>';					
				}
				
				if (in_array("top_speed", $data_items))
				{
					$result .= '<td>'.$route['top_speed'].' '.$la["UNIT_SPEED"].'</td>';					
				}
				
				if (in_array("avg_speed", $data_items))
				{
					$result .= '<td>'.$route['avg_speed'].' '.$la["UNIT_SPEED"].'</td>';					
				}
				
				if (in_array("overspeed_count", $data_items))
				{
					$result .= '<td>'.count($overspeeds).'</td>';					
				}
				
				$result .= '</tr>';
			}
		}		
		
		$result .= '</table>';
		
		return $result;
	}
	
	function reportsGenerateUnderspeed($imei, $dtf, $dtt, $speed_limit, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $data_items) //UNDERSPEED
	{
		global $la, $user_id;
		
		$accuracy = getObjectAccuracy($imei);
		
		$route = getRouteRaw($imei, $accuracy, $dtf, $dtt);
		//$route = removeRouteFakeCoordinates($route, array());
		$underpeeds = getRouteUnderspeeds($route, $speed_limit);
		
		if ((count($route) == 0) || (count($underpeeds) == 0))
		{
			return false;
		}
		
		$result = '<table class="report" width="100%"><tr align="center">';
		
		if (in_array("start", $data_items))
		{
			$result .= '<th>'.$la['START'].'</th>';
		}
		
		if (in_array("end", $data_items))
		{
			$result .= '<th>'.$la['END'].'</th>';
		}
		
		if (in_array("duration", $data_items))
		{
			$result .= '<th>'.$la['DURATION'].'</th>';
		}
		
		if (in_array("top_speed", $data_items))
		{
			$result .= '<th>'.$la['TOP_SPEED'].'</th>';
		}
		
		if (in_array("avg_speed", $data_items))
		{
			$result .= '<th>'.$la['AVG_SPEED'].'</th>';
		}
		
		if (in_array("underspeed_position", $data_items))
		{
			$result .= '<th>'.$la['UNDERSPEED_POSITION'].'</th>';
		}
		
		if (in_array("driver", $data_items))
		{
			$result .= '<th>'.$la['DRIVER'].'</th>';
		}
		
		if (in_array("trailer", $data_items))
		{
			$result .= '<th>'.$la['TRAILER'].'</th>';
		}
		
		$result .= '</tr>';
		
		for ($i=0; $i<count($underpeeds); ++$i)
		{
			$result .= '<tr align="center">';
			
			if (in_array("start", $data_items))
			{
				$result .= '<td>'.$underpeeds[$i][0].'</td>';
			}
			
			if (in_array("end", $data_items))
			{
				$result .= '<td>'.$underpeeds[$i][1].'</td>';
			}
			
			if (in_array("duration", $data_items))
			{
				$result .= '<td>'.$underpeeds[$i][2].'</td>';
			}
			
			if (in_array("top_speed", $data_items))
			{
				$result .= '<td>'.$underpeeds[$i][3].' '.$la["UNIT_SPEED"].'</td>';
			}
			
			if (in_array("avg_speed", $data_items))
			{
				$result .= '<td>'.$underpeeds[$i][4].' '.$la["UNIT_SPEED"].'</td>';
			}
			
			if (in_array("underspeed_position", $data_items))
			{
				$result .= '<td>'.reportsGetPossition($underpeeds[$i][5], $underpeeds[$i][6], $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses).'</td>';
			}
			
			if (in_array("driver", $data_items))
			{
				$params = $underpeeds[$i][7];
				$driver = getObjectDriver($user_id, $imei, $params);
				if ($driver['driver_name'] == ''){$driver['driver_name'] = $la['NA'];}
				
				$result .= '<td>'.$driver['driver_name'].'</td>';
			}
			
			if (in_array("trailer", $data_items))
			{
				$params = $underpeeds[$i][7];
				$trailer = getObjectTrailer($user_id, $imei, $params);
				if ($trailer['trailer_name'] == ''){$trailer['trailer_name'] = $la['NA'];}
				
				$result .= '<td>'.$trailer['trailer_name'].'</td>';
			}
			
			$result .= '</tr>';
		}
		
		$result .= '</table>';
		
		return $result;
	}
	
	function reportsGenerateUnderspeedCountMerged($imeis, $dtf, $dtt, $speed_limit, $data_items) //UNDERSPEED_COUNT
	{
		global $ms, $_SESSION, $la, $user_id;
		
		$result = '<table class="report" width="100%"><tr align="center">';
		
		$result .= '<th>'.$la['OBJECT'].'</th>';
		
		if (in_array("route_start", $data_items))
		{
			$result .= '<th>'.$la['ROUTE_START'].'</th>';
		}
		
		if (in_array("route_end", $data_items))
		{
			$result .= '<th>'.$la['ROUTE_END'].'</th>';
		}
		
		if (in_array("route_length", $data_items))
		{
			$result .= '<th>'.$la['ROUTE_LENGTH'].'</th>';
		}
		
		if (in_array("move_duration", $data_items))
		{
			$result .= '<th>'.$la['MOVE_DURATION'].'</th>';
		}
		
		if (in_array("top_speed", $data_items))
		{
			$result .= '<th>'.$la['TOP_SPEED'].'</th>';
		}
		
		if (in_array("avg_speed", $data_items))
		{
			$result .= '<th>'.$la['AVG_SPEED'].'</th>';
		}
		
		if (in_array("underspeed_count", $data_items))
		{
			$result .= '<th>'.$la['UNDERSPEED_COUNT'].'</th>';
		}
		
		$result .= '</tr>';
		
		for ($i=0; $i<count($imeis); ++$i)
		{
			$imei = $imeis[$i];
			
			$accuracy = getObjectAccuracy($imei);		
			$route = getRoute($user_id, $imei, $dtf, $dtt, 1, true);
			$underspeeds = getRouteUnderspeeds($route['route'], $speed_limit);
											
			if (count($route['route']) == 0)
			{
				$result .= '<tr align="center">';
				$result .= '<td>'.getObjectName($imei).'</td>';
				$result .= '<td colspan="7">'.$la['NOTHING_HAS_BEEN_FOUND_ON_YOUR_REQUEST'].'</td>';
				$result .= '</tr>';
			}
			else
			{
				$result .= '<tr align="center">';
				
				$result .= '<td>'.getObjectName($imei).'</td>';
				
				if (in_array("route_start", $data_items))
				{
					$result .= '<td>'.$route['route'][0][0].'</td>';
				}
				
				if (in_array("route_end", $data_items))
				{
					$result .= '<td>'.$route['route'][count($route['route'])-1][0].'</td>';
				}
				
				if (in_array("route_length", $data_items))
				{
					$result .= '<td>'.$route['route_length'].' '.$la["UNIT_DISTANCE"].'</td>';					
				}
				
				if (in_array("move_duration", $data_items))
				{
					$result .= '<td>'.$route['drives_duration'].'</td>';					
				}
				
				if (in_array("top_speed", $data_items))
				{
					$result .= '<td>'.$route['top_speed'].' '.$la["UNIT_SPEED"].'</td>';					
				}
				
				if (in_array("avg_speed", $data_items))
				{
					$result .= '<td>'.$route['avg_speed'].' '.$la["UNIT_SPEED"].'</td>';					
				}
				
				if (in_array("underspeed_count", $data_items))
				{
					$result .= '<td>'.count($underspeeds).'</td>';					
				}
				
				$result .= '</tr>';
			}
		}		
		
		$result .= '</table>';
		
		return $result;
	}
	
	function reportsGenerateMarkerInOut($imei, $dtf, $dtt, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $marker_ids, $data_items) //MARKER_IN_OUT
	{
		global $ms, $_SESSION, $la, $user_id;
		
		$marker_ids = explode(",", $marker_ids);
		
		$accuracy = getObjectAccuracy($imei);
		
		$route = getRouteRaw($imei, $accuracy, $dtf, $dtt);
		//$route = removeRouteFakeCoordinates($route, array());
		
		$q = "SELECT * FROM `gs_user_markers` WHERE `user_id`='".$user_id."'";
		$r = mysqli_query($ms, $q);
		$markers = array();
		
		while($row=mysqli_fetch_array($r))
		{
			if(in_array($row['marker_id'], $marker_ids))
			{
				$markers[] = array($row['marker_id'],$row['marker_name'], $row['marker_lat'], $row['marker_lng'], $row['marker_radius']);	
			}
		}
		
		if ((count($route) == 0) || (count($markers) == 0))
		{
			return false;
		}
		
		$in_markers = array();
		$in_marker = 0;
		$in_marker_route_length = 0;
		$in_marker_engine_hours = 0;
		$in_markers_total = array();
		
		// get ACC sensor
		$sensor = getSensorFromType($imei, 'acc');
		$acc = $sensor[0]['param'];
		
		for ($i=0; $i<count($route); ++$i)
		{
			$point_dt_tracker = $route[$i][0];
			$point_lat = $route[$i][1];
			$point_lng = $route[$i][2];
			$point_params = $route[$i][6];
			
			for ($j=0; $j<count($markers); ++$j)
			{
				$marker_id = $markers[$j][0];
				$marker_name = $markers[$j][1];
				$marker_lat = $markers[$j][2];
				$marker_lng = $markers[$j][3];
				$marker_radius = $markers[$j][4];
				
				$dist = getLengthBetweenCoordinates($point_lat, $point_lng, $marker_lat, $marker_lng);
				$dist = convDistanceUnits($dist, 'km', $_SESSION["unit_distance"]);
				
				if ($dist <= $marker_radius)
				{
					
					if ($in_marker == 0)
					{
						$in_marker_start = $route[$i][0];
						$in_marker_name = $marker_name;
						$in_marker_lat = $point_lat;
						$in_marker_lng = $point_lng;
						$in_marker = $marker_id;
					}
					
					if (isset($prev_point_lat) && isset($prev_point_lng))
					{
						$in_marker_route_length += getLengthBetweenCoordinates($prev_point_lat, $prev_point_lng, $point_lat, $point_lng);
						
						if ($acc !== false)
						{				
							if (isset($prev_point_params[$acc]) && isset($point_params[$acc]))
							{
								if (($prev_point_params[$acc] == '1') && ($point_params[$acc] == '1'))
								{	
									$in_marker_engine_hours += strtotime($point_dt_tracker)-strtotime($prev_point_dt_tracker);									
								}
							}	
						}
					}
				}
				else
				{
					if ($in_marker == $marker_id)
					{
						$in_marker_end = $route[$i][0];
						$in_marker_duration = strtotime($in_marker_end) - strtotime($in_marker_start);
						
						$in_marker_route_length = convDistanceUnits($in_marker_route_length, 'km', $_SESSION["unit_distance"]);						
						$in_marker_route_length = (round($in_marker_route_length * 100) / 100);
						
						$in_markers[] = array(	$in_marker_start,
												$in_marker_end,
												$in_marker_duration,
												$in_marker_route_length,
												$in_marker_engine_hours,
												$in_marker_name,
												$in_marker_lat,
												$in_marker_lng
												);
						
						if (isset($in_marker_total[$marker_id]))
						{
							$in_markers_total[$marker_id]['duration'] += $in_marker_duration;
							$in_markers_total[$marker_id]['route_length'] += $in_marker_route_length;
							$in_markers_total[$marker_id]['engine_hours'] += $in_marker_engine_hours;
						}
						else
						{
							$in_markers_total[$marker_id] = array('name' => $in_marker_name, 'duration' => $in_marker_duration, 'route_length' => $in_marker_route_length, 'engine_hours' => $in_marker_engine_hours);	
						}						
						
						$in_marker = 0;
						$in_marker_route_length = 0;
						$in_marker_engine_hours = 0;
					}
				}
			}
			
			$prev_point_dt_tracker = $point_dt_tracker;
			$prev_point_lat = $point_lat;
			$prev_point_lng = $point_lng;
			$prev_point_params = $point_params;
		}
		
		// add last marker record if it did not leave
		if ($in_marker != 0)
		{			
			$in_marker_end = $route[$i-1][0];
			$in_marker_duration = strtotime($in_marker_end) - strtotime($in_marker_start);
			
			$in_marker_route_length = convDistanceUnits($in_marker_route_length, 'km', $_SESSION["unit_distance"]);						
			$in_marker_route_length = (round($in_marker_route_length * 100) / 100);
			
			$in_markers[] = array(	$in_marker_start,
									$la['NA'],
									$in_marker_duration,
									$in_marker_route_length,
									$in_marker_engine_hours,
									$in_marker_name,
									$in_marker_lat,
									$in_marker_lng
									);
			
			if (isset($in_markers_total[$marker_id]))
			{
				$in_markers_total[$marker_id]['duration'] += $in_marker_duration;
				$in_markers_total[$marker_id]['route_length'] += $in_marker_route_length;
				$in_markers_total[$marker_id]['engine_hours'] += $in_marker_engine_hours;
			}
			else
			{
				$in_markers_total[$marker_id] = array('name' => $in_marker_name, 'duration' => $in_marker_duration, 'route_length' => $in_marker_route_length, 'engine_hours' => $in_marker_engine_hours);	
			}	
		}
		
		if (count($in_markers) == 0)
		{
			return false;
		}
		
		$result = '<table class="report" width="100%"><tr align="center">';
		
		if (in_array("marker_in", $data_items))
		{
			$result .= '<th>'.$la['MARKER_IN'].'</th>';
		}
		
		if (in_array("marker_out", $data_items))
		{
			$result .= '<th>'.$la['MARKER_OUT'].'</th>';
		}
		
		if (in_array("duration", $data_items))
		{
			$result .= '<th>'.$la['DURATION'].'</th>';
		}
		
		if (in_array("route_length", $data_items))
		{
			$result .= '<th>'.$la['ROUTE_LENGTH'].'</th>';
		}
		
		if (in_array("engine_hours", $data_items))
		{
			$result .= '<th>'.$la['ENGINE_HOURS'].'</th>';
		}
		
		if (in_array("marker_name", $data_items))
		{
			$result .= '<th>'.$la['MARKER_NAME'].'</th>';
		}
		
		if (in_array("marker_position", $data_items))
		{
			$result .= '<th>'.$la['MARKER_POSITION'].'</th>';
		}
		
		$result .= '</tr>';
		
		for ($i=0; $i<count($in_markers); ++$i)
		{
			$result .= '<tr align="center">';
			
			if (in_array("marker_in", $data_items))
			{
				$result .= '<td>'.$in_markers[$i][0].'</td>';
			}
			
			if (in_array("marker_out", $data_items))
			{
				$result .= '<td>'.$in_markers[$i][1].'</td>';
			}
			
			if (in_array("duration", $data_items))
			{
				$result .= '<td>'.getTimeDetails($in_markers[$i][2], true).'</td>';
			}
			
			if (in_array("route_length", $data_items))
			{
				$result .= '<td>'.$in_markers[$i][3].' '.$la['UNIT_DISTANCE'].'</td>';
			}
			
			if (in_array("engine_hours", $data_items))
			{
				$result .= '<td>'.getTimeDetails($in_markers[$i][4], true).'</td>';
			}
			
			if (in_array("marker_name", $data_items))
			{
				$result .= '<td>'.$in_markers[$i][5].'</td>';
			}
			
			if (in_array("marker_position", $data_items))
			{
				$result .= '<td>'.reportsGetPossition($in_markers[$i][6], $in_markers[$i][7], $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses).'</td>';
			}
			
			$result .= '</tr>';
		}
		
		$result .= '</table>';
		
		if (in_array("total", $data_items))
		{

$result .= '<tr>
				<td><strong>'.$la['ROUTE_END'].':</strong></td>
				<td>'.$data['route'][count($data['route'])-1][0].'</td>
			</tr>';

$result .= '<tr>
				<td><strong>'.$la['ROUTE_LENGTH'].':</strong></td>
				<td>'.$data['route_length'].' '.$la["UNIT_DISTANCE"].'</td>
			</tr>';

$result .= '<tr>
				<td><strong>'.$la['MOVE_DURATION'].':</strong></td>
				<td>'.$data['drives_duration'].'</td>
			</tr>';

$result .= '<tr>
				<td><strong>'.$la['STOP_DURATION'].':</strong></td>
				<td>'.$data['stops_duration'].'</td>
			</tr>';

$result .= '<tr>
				<td><strong>'.$la['STOP_COUNT'].':</strong></td>
				<td>'.count($data['stops']).'</td>
			</tr>';

$result .= '<tr>
				<td><strong>'.$la['TOP_SPEED'].':</strong></td>
				<td>'.$data['top_speed'].' '.$la["UNIT_SPEED"].'</td>
			</tr>';

$result .= '<tr>
				<td><strong>'.$la['AVG_SPEED'].':</strong></td>
				<td>'.$data['avg_speed'].' '.$la["UNIT_SPEED"].'</td>
			</tr>';

$result .= '<tr>
				<td><strong>'.$la['OVERSPEED_COUNT'].':</strong></td>
				<td>'.$overspeeds_count.'</td>
			</tr>';

$result .= '<tr>
				<td><strong>'.$la['FUEL_CONSUMPTION'].':</strong></td>
				<td>'.$data['fuel_consumption'].' '.$la["UNIT_CAPACITY"].'</td>
			</tr>';

if ($_SESSION["unit_capacity"] == 'l')
		{
			$result .= '<tr>
					<td><strong>'.$la['AVG_FUEL_CONSUMPTION_100_KM'].':</strong></td>
					<td>'.$data['fuel_consumption_per_100km'].' '.$la["UNIT_CAPACITY"].'</td>
				</tr>';	
		}
		else
		{
			$result .= '<tr>
					<td><strong>'.$la['AVG_FUEL_CONSUMPTION_MPG'].':</strong></td>
					<td>'.$data['fuel_consumption_mpg'].' '.$la["UNIT_MI"].'</td>
				</tr>';	
		}

$result .= '<tr>
				<td><strong>'.$la['FUEL_COST'].':</strong></td>
				<td>'.$data['fuel_cost'].' '.$_SESSION["currency"].'</td>
			</tr>';

$result .= '<tr>
				<td><strong>'.$la['ENGINE_WORK'].':</strong></td>
				<td>'.$data['engine_work'].'</td>
			</tr>';

$result .= '<tr>
				<td><strong>'.$la['ENGINE_IDLE'].':</strong></td>
				<td>'.$data['engine_idle'].'</td>
			</tr>';

$result .= '<tr>
				<td><strong>'.$la['ODOMETER'].':</strong></td>
				<td>'.$odometer.' '.$la["UNIT_DISTANCE"].'</td>
			</tr>';

$result .= '<tr>
				<td><strong>'.$la['ENGINE_HOURS'].':</strong></td>
				<td>'.getObjectEngineHours($imei, true).'</td>
			</tr>';
			
		$result .= '<tr>';
		
		$params = $data['route'][count($data['route'])-1][6];
		$driver = getObjectDriver($user_id, $imei, $params);
		if ($driver['driver_name'] == ''){$driver['driver_name'] = $la['NA'];}
		
		$result .= 	'<td><strong>'.$la['DRIVER'].':</strong></td>
				<td>'.$driver['driver_name'].'</td>
				</tr>';

if ($dist <= $marker_radius)
				{
					
					if ($in_marker == 0)
					{
						$in_marker_start = $route[$i][0];
						$in_marker_name = $marker_name;
						$in_marker_lat = $point_lat;
						$in_marker_lng = $point_lng;
						$in_marker = $marker_id;
					}
					
					if (isset($prev_point_lat) && isset($prev_point_lng))
					{
						$in_marker_route_length += getLengthBetweenCoordinates($prev_point_lat, $prev_point_lng, $point_lat, $point_lng);
						
						if ($acc !== false)
						{				
							if (isset($prev_point_params[$acc]) && isset($point_params[$acc]))
							{
								if (($prev_point_params[$acc] == '1') && ($point_params[$acc] == '1'))
								{	
									$in_marker_engine_hours += strtotime($point_dt_tracker)-strtotime($prev_point_dt_tracker);									
								}
							}	
						}
					}
				}
				else
				{
					if ($in_marker == $marker_id)
					{
						$in_marker_end = $route[$i][0];
						$in_marker_duration = strtotime($in_marker_end) - strtotime($in_marker_start);
						
						$in_marker_route_length = convDistanceUnits($in_marker_route_length, 'km', $_SESSION["unit_distance"]);						
						$in_marker_route_length = (round($in_marker_route_length * 100) / 100);
						
						$in_markers[] = array(	$in_marker_start,
												$in_marker_end,
												$in_marker_duration,
												$in_marker_route_length,
												$in_marker_engine_hours,
												$in_marker_name,
												$in_marker_lat,
												$in_marker_lng
												);
						
						if (isset($in_marker_total[$marker_id]))
						{
							$in_markers_total[$marker_id]['duration'] += $in_marker_duration;
							$in_markers_total[$marker_id]['route_length'] += $in_marker_route_length;
							$in_markers_total[$marker_id]['engine_hours'] += $in_marker_engine_hours;
						}
						else
						{
							$in_markers_total[$marker_id] = array('name' => $in_marker_name, 'duration' => $in_marker_duration, 'route_length' => $in_marker_route_length, 'engine_hours' => $in_marker_engine_hours);	
						}						
						
						$in_marker = 0;
						$in_marker_route_length = 0;
						$in_marker_engine_hours = 0;
					}
				}
			}
			
			$prev_point_dt_tracker = $point_dt_tracker;
			$prev_point_lat = $point_lat;
			$prev_point_lng = $point_lng;
			$prev_point_params = $point_params;
		}
		
		// add last marker record if it did not leave
		if ($in_marker != 0)
		{			
			$in_marker_end = $route[$i-1][0];
			$in_marker_duration = strtotime($in_marker_end) - strtotime($in_marker_start);
			
			$in_marker_route_length = convDistanceUnits($in_marker_route_length, 'km', $_SESSION["unit_distance"]);						
			$in_marker_route_length = (round($in_marker_route_length * 100) / 100);
			
			$in_markers[] = array(	$in_marker_start,
									$la['NA'],
									$in_marker_duration,
									$in_marker_route_length,
									$in_marker_engine_hours,
									$in_marker_name,
									$in_marker_lat,
									$in_marker_lng
									);
			
			if (isset($in_markers_total[$marker_id]))
			{
				$in_markers_total[$marker_id]['duration'] += $in_marker_duration;
				$in_markers_total[$marker_id]['route_length'] += $in_marker_route_length;
				$in_markers_total[$marker_id]['engine_hours'] += $in_marker_engine_hours;
			}
			else
			{
				$in_markers_total[$marker_id] = array('name' => $in_marker_name, 'duration' => $in_marker_duration, 'route_length' => $in_marker_route_length, 'engine_hours' => $in_marker_engine_hours);	
			}	
		}
		
		if (count($in_markers) == 0)
		{
			return false;
		}
		
		$result .= '<table class="report" width="100%"><tr align="center">';
		
		if (in_array("marker_in", $data_items))
		{
			$result .= '<th>'.$la['MARKER_IN'].'</th>';
		}
		
		if (in_array("marker_out", $data_items))
		{
			$result .= '<th>'.$la['MARKER_OUT'].'</th>';
		}
		
		if (in_array("duration", $data_items))
		{
			$result .= '<th>'.$la['DURATION'].'</th>';
		}
		
		if (in_array("route_length", $data_items))
		{
			$result .= '<th>'.$la['ROUTE_LENGTH'].'</th>';
		}
		
		if (in_array("engine_hours", $data_items))
		{
			$result .= '<th>'.$la['ENGINE_HOURS'].'</th>';
		}
		
		if (in_array("marker_name", $data_items))
		{
			$result .= '<th>'.$la['MARKER_NAME'].'</th>';
		}
		
		if (in_array("marker_position", $data_items))
		{
			$result .= '<th>'.$la['MARKER_POSITION'].'</th>';
		}
		
		$result .= '</tr>';
		
		for ($i=0; $i<count($in_markers); ++$i)
		{
			$result .= '<tr align="center">';
			
			if (in_array("marker_in", $data_items))
			{
				$result .= '<td>'.$in_markers[$i][0].'</td>';
			}
			
			if (in_array("marker_out", $data_items))
			{
				$result .= '<td>'.$in_markers[$i][1].'</td>';
			}
			
			if (in_array("duration", $data_items))
			{
				$result .= '<td>'.getTimeDetails($in_markers[$i][2], true).'</td>';
			}
			
			if (in_array("route_length", $data_items))
			{
				$result .= '<td>'.$in_markers[$i][3].' '.$la['UNIT_DISTANCE'].'</td>';
			}
			
			if (in_array("engine_hours", $data_items))
			{
				$result .= '<td>'.getTimeDetails($in_markers[$i][4], true).'</td>';
			}
			
			if (in_array("marker_name", $data_items))
			{
				$result .= '<td>'.$in_markers[$i][5].'</td>';
			}
			
			if (in_array("marker_position", $data_items))
			{
				$result .= '<td>'.reportsGetPossition($in_markers[$i][6], $in_markers[$i][7], $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses).'</td>';
			}
			
			$result .= '</tr>';
		}
		
		$result .= '</table>';
		
		if (in_array("total", $data_items))
		{

$result .= '<br/>';
			
			usort($in_markers_total, function($a, $b) {
				return strcmp($a["name"], $b["name"]);
			});
			
			$result .= '<table>';
			foreach ($in_markers_total as $key=>$value)
			{
				$result .= '<tr>
					<td><strong>'.$value['name'].':</strong></td>
					<td>'.getTimeDetails($value['duration'], true).';</td>
					<td>'.$value['route_length'].' '.$la['UNIT_DISTANCE'].';</td>
					<td>'.getTimeDetails($value['engine_hours'], true).'.</td>
				</tr>';
			}
			$result .= '</table>';
		}
		
		return $result;
	}
	
	function reportsGenerateZoneInOut($imei, $dtf, $dtt, $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses, $zone_ids, $data_items) //ZONE_IN_OUT
	{
		global $ms, $_SESSION, $la, $user_id;
		
		$zone_ids = explode(",", $zone_ids);
		
		$accuracy = getObjectAccuracy($imei);
		
		$route = getRouteRaw($imei, $accuracy, $dtf, $dtt);
		//$route = removeRouteFakeCoordinates($route, array());
		
		$q = "SELECT * FROM `gs_user_zones` WHERE `user_id`='".$user_id."'";
		$r = mysqli_query($ms, $q);
		$zones = array();
		
		while($row=mysqli_fetch_array($r))
		{
			if(in_array($row['zone_id'], $zone_ids))
			{
				$zones[] = array($row['zone_id'],$row['zone_name'], $row['zone_vertices']);	
			}
		}
		
		if ((count($route) == 0) || (count($zones) == 0))
		{
			return false;
		}
		
		$in_zones = array();
		$in_zone = 0;
		$in_zone_route_length = 0;
		$in_zone_engine_hours = 0;
		$in_zones_total = array();
		
		// get ACC sensor
		$sensor = getSensorFromType($imei, 'acc');
		$acc = $sensor[0]['param'];
		
		for ($i=0; $i<count($route); ++$i)
		{
			$point_dt_tracker = $route[$i][0];
			$point_lat = $route[$i][1];
			$point_lng = $route[$i][2];
			$point_params = $route[$i][6];
			
			for ($j=0; $j<count($zones); ++$j)
			{
				$zone_id = $zones[$j][0];
				$zone_name = $zones[$j][1];
				$zone_vertices = $zones[$j][2];
				
				$isPointInPolygon = isPointInPolygon($zone_vertices, $point_lat, $point_lng);
				
				if ($isPointInPolygon)
				{
					if ($in_zone == 0)
					{
						$in_zone_start = $route[$i][0];
						$in_zone_name = $zone_name;
						$in_zone_lat = $point_lat;
						$in_zone_lng = $point_lng;
						$in_zone = $zone_id;
					}
					
					if (isset($prev_point_lat) && isset($prev_point_lng))
					{
						$in_zone_route_length += getLengthBetweenCoordinates($prev_point_lat, $prev_point_lng, $point_lat, $point_lng);
						
						if ($acc !== false)
						{				
							if (isset($prev_point_params[$acc]) && isset($point_params[$acc]))
							{
								if (($prev_point_params[$acc] == '1') && ($point_params[$acc] == '1'))
								{	
									$in_zone_engine_hours += strtotime($point_dt_tracker)-strtotime($prev_point_dt_tracker);									
								}
							}	
						}
					}
				}
				else
				{
					if ($in_zone == $zone_id)
					{
						$in_zone_end = $route[$i][0];
						$in_zone_duration = strtotime($in_zone_end) - strtotime($in_zone_start);
						
						$in_zone_route_length = convDistanceUnits($in_zone_route_length, 'km', $_SESSION["unit_distance"]);						
						$in_zone_route_length = (round($in_zone_route_length * 100) / 100);
						
						$in_zones[] = array($in_zone_start,
											$in_zone_end,
											$in_zone_duration,
											$in_zone_route_length,
											$in_zone_engine_hours,
											$in_zone_name,
											$in_zone_lat,
											$in_zone_lng
											);
						
						if (isset($in_zones_total[$zone_id]))
						{
							$in_zones_total[$zone_id]['duration'] += $in_zone_duration;
							$in_zones_total[$zone_id]['route_length'] += $in_zone_route_length;
							$in_zones_total[$zone_id]['engine_hours'] += $in_zone_engine_hours;
						}
						else
						{
							$in_zones_total[$zone_id] = array('name' => $in_zone_name, 'duration' => $in_zone_duration, 'route_length' => $in_zone_route_length, 'engine_hours' => $in_zone_engine_hours);	
						}						
						
						$in_zone = 0;
						$in_zone_route_length = 0;
						$in_zone_engine_hours = 0;
					}
				}
			}
			
			$prev_point_dt_tracker = $point_dt_tracker;
			$prev_point_lat = $point_lat;
			$prev_point_lng = $point_lng;
			$prev_point_params = $point_params;
		}
		
		// add last zone record if it did not leave
		if ($in_zone != 0)
		{			
			$in_zone_end = $route[$i-1][0];
			$in_zone_duration = strtotime($in_zone_end) - strtotime($in_zone_start);
			
			$in_zone_route_length = convDistanceUnits($in_zone_route_length, 'km', $_SESSION["unit_distance"]);						
			$in_zone_route_length = (round($in_zone_route_length * 100) / 100);
			
			$in_zones[] = array($in_zone_start,
								$la['NA'],
								$in_zone_duration,
								$in_zone_route_length,
								$in_zone_engine_hours,
								$in_zone_name,
								$in_zone_lat,
								$in_zone_lng
								);
			
			if (isset($in_zones_total[$zone_id]))
			{
				$in_zones_total[$zone_id]['duration'] += $in_zone_duration;
				$in_zones_total[$zone_id]['route_length'] += $in_zone_route_length;
				$in_zones_total[$zone_id]['engine_hours'] += $in_zone_engine_hours;
			}
			else
			{
				$in_zones_total[$zone_id] = array('name' => $in_zone_name, 'duration' => $in_zone_duration, 'route_length' => $in_zone_route_length, 'engine_hours' => $in_zone_engine_hours);	
			}	
		}
		
		if (count($in_zones) == 0)
		{
			return false;
		}
		
		$result = '<table class="report" width="100%"><tr align="center">';
		
		if (in_array("zone_in", $data_items))
		{
			$result .= '<th>'.$la['ZONE_IN'].'</th>';
		}
		
		if (in_array("zone_out", $data_items))
		{
			$result .= '<th>'.$la['ZONE_OUT'].'</th>';
		}
		
		if (in_array("duration", $data_items))
		{
			$result .= '<th>'.$la['DURATION'].'</th>';
		}
		
		if (in_array("route_length", $data_items))
		{
			$result .= '<th>'.$la['ROUTE_LENGTH'].'</th>';
		}
		
		if (in_array("engine_hours", $data_items))
		{
			$result .= '<th>'.$la['ENGINE_HOURS'].'</th>';
		}
		
		if (in_array("zone_name", $data_items))
		{
			$result .= '<th>'.$la['ZONE_NAME'].'</th>';
		}
		
		if (in_array("zone_position", $data_items))
		{
			$result .= '<th>'.$la['ZONE_POSITION'].'</th>';
		}
		
		$result .= '</tr>';
		
		for ($i=0; $i<count($in_zones); ++$i)
		{
			$result .= '<tr align="center">';
			
			if (in_array("zone_in", $data_items))
			{
				$result .= '<td>'.$in_zones[$i][0].'</td>';
			}
			
			if (in_array("zone_out", $data_items))
			{
				$result .= '<td>'.$in_zones[$i][1].'</td>';
			}
			
			if (in_array("duration", $data_items))
			{
				$result .= '<td>'.getTimeDetails($in_zones[$i][2], true).'</td>';
			}
			
			if (in_array("route_length", $data_items))
			{
				$result .= '<td>'.$in_zones[$i][3].' '.$la['UNIT_DISTANCE'].'</td>';
			}
			
			if (in_array("engine_hours", $data_items))
			{
				$result .= '<td>'.getTimeDetails($in_zones[$i][4], true).'</td>';
			}
			
			if (in_array("zone_name", $data_items))
			{
				$result .= '<td>'.$in_zones[$i][5].'</td>';
			}
			
			if (in_array("zone_position", $data_items))
			{
				$result .= '<td>'.reportsGetPossition($in_zones[$i][6], $in_zones[$i][7], $show_coordinates, $show_addresses, $markers_addresses, $zones_addresses).'</td>';
			}
			
			$result .= '</tr>';
		}
		
		$result .= '</table>';
		
		if (in_array("total", $data_items))
		{