function main()
{
$serviceUrl = 'https://service.berlin.de/terminvereinbarung/termin/tag.php?termin=1&anliegen[]=%s&Datum=%s&dienstleisterlist=%s';
$officeList = [150230, 122301, 122297, 122294, 122210, 122217, 122219, 122227, 122280, 122282, 122284];
$date = time();
// Change accordingly....
$serviceType = '120686';
// This one is for Almendung
// Generate the URL with all the offices we need
$url = sprintf($serviceUrl, $serviceType, $date, implode(',', $officeList));
// Fetch the data from our URL
$data = fetchData($url);
// Parse received data from berlin.de
$finalLinks = parseData($data);
// Render links for booking if found
renderResults($finalLinks);
}
<?php
require_once 'vendor/autoload.php';
require_once 'output-results.php';
$adapter = (require_once 'adapter.php');
/** @var \Zend\Db\Adapter\Driver\StatementInterface $statement */
$statement = $adapter['sqlite']->createStatement("SELECT c.FirstName, c.LastName, c.Email, c.Country,\n i.InvoiceId, i.InvoiceDate, i.Total\n FROM Customer c\n INNER JOIN Invoice I ON (i.CustomerId = c.CustomerId)\n WHERE (i.Total BETWEEN 13 AND 22)\n AND (c.Country = 'USA' OR c.Country = 'Germany')\n ORDER BY i.Total DESC\n LIMIT 1, 30");
/** @var \Zend\Db\Adapter\Driver\Pdo\Result $results */
$results = $statement->execute();
renderResults($results, $statement);
