<?php
	session_start();
	include_once($_SERVER['DOCUMENT_ROOT'].'/php/mysql.php');
	$serial_list = array();
	if(!empty($_SESSION['company_db'])) {
		if(!empty($_GET['date'])) {
			$res = $db->get_results("SELECT phone_id as serial_number FROM debug_from_pi
									WHERE pi_id=".$db->clean($_SESSION['company_db'])."
									AND DATE(punch_date)='".$db->clean(date('Y-m-d',strtotime($_GET['date'])))."'
									AND phone_id NOT IN (SELECT serial_number FROM timeclock_users_".$db->clean($_SESSION['company_db']).")
									GROUP BY serial_number
									ORDER BY punch_date DESC");
		} else {
			$res = $db->get_results("SELECT phone_id as serial_number FROM debug_from_pi
									WHERE pi_id=".$db->clean($_SESSION['company_db'])."
									AND DATE(punch_date)=CURDATE()
									AND phone_id NOT IN (SELECT serial_number FROM timeclock_users_".$db->clean($_SESSION['company_db']).")
									GROUP BY serial_number
									ORDER BY punch_date DESC");
		}
		if(!empty($res)) {
			foreach($res as $r) {
				$serial_list[] = $r->serial_number;
			}
		}
	}
	ob_start();
	?>
	<form method="GET" action="phone_add_new_device_list.php" style="margin:10px 0px;">
		<label style="font-size:14px;">Date Plugged In: <input type="date" name="date" value="<?= (empty($_GET['date'])) ? date('Y-m-d') : date('Y-m-d',strtotime($_GET['date']));?>" style="font-size:14px;" /></label>
		<input type="submit" name="submit" value="Update Date" style="font-size:14px;" />
	</form>
	<h3>New Devices List</h3>
	<?php
	if(!empty($serial_list)) {
		foreach($serial_list as $serial) {
			?>
			<div class="device_list">
				<a href="phone_add_user.php?serial=<?= $serial;?>"><?= $serial;?></div>
			</div>
			<?php
		}
	}
	$body = ob_get_clean();
	include('layout.php');