function auto_checkout_by_location($location_id)
{
$query = <<<SQL
SELECT
t.`id`,
t.`registration_id`,
t.`checked_in`,
t.`checked_out`,
t.`created`,
t.`modified`
FROM
`tracking` t
INNER JOIN `registration` r ON t.`registration_id` = r.`id`
WHERE
r.`location_id` = :location_id
AND t.`checked_out` IS NULL
SQL;
$dbaccess = new db_access();
$dbaccess->open_connection();
$checkins = $dbaccess->fetch_all($query, array(get_db_param(':location_id', $location_id, PDO::PARAM_INT)), true);
$query = <<<SQL
UPDATE `tracking`
SET
`checked_out` = :now,
`modified` = :now
WHERE `id` = :tracking_id;
SQL;
foreach ($checkins as $checkin) {
$dbaccess->update($query, array(get_db_param(':tracking_id', $checkin['id'], PDO::PARAM_INT), get_db_param(':now', get_db_now(), PDO::PARAM_STR)), true);
}
$dbaccess->close_connection();
return json_decode(json_encode($data), FALSE);
}
