Add OpenID auth for editing pages
[busui.git] / labs / servicealert_editor.php
blob:a/labs/servicealert_editor.php -> blob:b/labs/servicealert_editor.php
<?php <?php
include ('../include/common.inc.php'); include ('../include/common.inc.php');
  auth();
include_header("Service Alert Editor", "serviceAlertEditor"); include_header("Service Alert Editor", "serviceAlertEditor");
/** /**
* Currently support: * Currently support:
* network inform * network inform
* stop remove: trip patch, route inform * stop remove: trip patch, route inform
* - stop search * - stop search
* street inform: route inform, trip inform, stop inform * street inform: route inform, trip inform, stop inform
* - street search * - street search
* trip remove: route patch, stop inform * trip remove: route patch, stop inform
* - trip search by route * - trip search by route
*/ */
if (isset($_REQUEST['saveedit'])) { if (isset($_REQUEST['saveedit'])) {
   
if ($_REQUEST['saveedit'] != "") updateServiceAlert($_REQUEST['saveedit'], $_REQUEST['startdate'], $_REQUEST['enddate'], $_REQUEST['description'], $_REQUEST['url']); if ($_REQUEST['saveedit'] != "") updateServiceAlert($_REQUEST['saveedit'], $_REQUEST['startdate'], $_REQUEST['enddate'], $_REQUEST['description'], $_REQUEST['url']);
else addServiceAlert($_REQUEST['startdate'], $_REQUEST['enddate'], $_REQUEST['description'], $_REQUEST['url']); else addServiceAlert($_REQUEST['startdate'], $_REQUEST['enddate'], $_REQUEST['description'], $_REQUEST['url']);
echo "Saved " . $_REQUEST['saveedit']; echo "Saved " . $_REQUEST['saveedit'];
die(); die();
} }
if ($_REQUEST['delete']) { if ($_REQUEST['delete']) {
$deleteParts = explode(";", $_REQUEST['delete']); $deleteParts = explode(";", $_REQUEST['delete']);
deleteInformedAlert($deleteParts[0], $deleteParts[1], $deleteParts[2]); deleteInformedAlert($deleteParts[0], $deleteParts[1], $deleteParts[2]);
echo "Deleted network inform for {$deleteParts[0]} ({$deleteParts[1]},{$deleteParts[2]})<br>\n"; echo "Deleted network inform for {$deleteParts[0]} ({$deleteParts[1]},{$deleteParts[2]})<br>\n";
die(); die();
} }
if ($_REQUEST['networkinform']) { if ($_REQUEST['networkinform']) {
addInformedAlert($_REQUEST['networkinform'], "network", "network", "inform"); addInformedAlert($_REQUEST['networkinform'], "network", "network", "inform");
echo "Added network inform for" . $_REQUEST['networkinform']; echo "Added network inform for" . $_REQUEST['networkinform'];
die(); die();
} }
if ($_REQUEST['stopsearch']) { if ($_REQUEST['stopsearch']) {
addInformedAlert($_REQUEST['stopsearch'], "stop", $_REQUEST['stopid'], "remove"); addInformedAlert($_REQUEST['stopsearch'], "stop", $_REQUEST['stopid'], "remove");
echo "Added stop remove for" . $_REQUEST['stopsearch'] . ", stop" . $_REQUEST['stopid'] . "<br>\n"; echo "Added stop remove for" . $_REQUEST['stopsearch'] . ", stop" . $_REQUEST['stopid'] . "<br>\n";
foreach ($service_periods as $sp) { foreach ($service_periods as $sp) {
echo "Patching $sp trips<br>\n"; echo "Patching $sp trips<br>\n";
foreach (getStopTrips($_REQUEST['stopid'], $sp) as $trip) { foreach (getStopTrips($_REQUEST['stopid'], $sp) as $trip) {
addInformedAlert($_REQUEST['stopsearch'], "trip", $trip['trip_id'], "patch"); addInformedAlert($_REQUEST['stopsearch'], "trip", $trip['trip_id'], "patch");
echo "Added trip patch for" . $_REQUEST['stopsearch'] . ", trip" . $trip['trip_id'] . "<br>\n"; echo "Added trip patch for" . $_REQUEST['stopsearch'] . ", trip" . $trip['trip_id'] . "<br>\n";
} }
echo "Informing $sp routes<br>\n"; echo "Informing $sp routes<br>\n";
foreach (getStopRoutes($_REQUEST['stopid'], $sp) as $route) { foreach (getStopRoutes($_REQUEST['stopid'], $sp) as $route) {
addInformedAlert($_REQUEST['stopsearch'], "route", $route['route_id'], "inform"); addInformedAlert($_REQUEST['stopsearch'], "route", $route['route_id'], "inform");
echo "Added route inform for" . $_REQUEST['stopsearch'] . ", route" . $route['route_id'] . "<br>\n"; echo "Added route inform for" . $_REQUEST['stopsearch'] . ", route" . $route['route_id'] . "<br>\n";
   
   
} }
} }
die(); die();
} }
if ($_REQUEST['routesearch']) { if ($_REQUEST['routesearch']) {
echo "Informing route<br>\n"; echo "Informing route<br>\n";
getRouteTrips(); $stops = Array();
echo "Informing trips<br>\n"; echo "Informing trips<br>\n";
echo "Informing stops<br>\n"; foreach(getRouteTrips() as $trip) {
die(); addInformedAlert($_REQUEST['stopsearch'], "trip", $trip['trip_id'], "patch");
  echo "Added trip patch for" . $_REQUEST['stopsearch'] . ", trip" . $trip['trip_id'] . "<br>\n";
  viaPoints($tripID, "", false);
  }
   
  echo "Informing stops<br>\n";
  foreach($stops as $stop) {
  addInformedAlert($_REQUEST['stopsearch'], "stop", $_REQUEST['stopid'], "remove");
  echo "Added stop remove for" . $_REQUEST['stopsearch'] . ", stop" . $_REQUEST['stopid'] . "<br>\n";
  }
  die();
} }
if ($_REQUEST['streetsearch']) { if ($_REQUEST['streetsearch']) {
echo "Informing stops<br>\n"; echo "Informing stops<br>\n";
foreach(getStopByName() as $stop) { foreach(getStopByName() as $stop) {
addInformedAlert($_REQUEST['stopsearch'], "stop", $_REQUEST['stopid'], "remove"); addInformedAlert($_REQUEST['stopsearch'], "stop", $_REQUEST['stopid'], "remove");
echo "Added stop inform for" . $_REQUEST['stopsearch'] . ", stop" . $_REQUEST['stopid'] . "<br>\n"; echo "Added stop inform for" . $_REQUEST['stopsearch'] . ", stop" . $_REQUEST['stopid'] . "<br>\n";
foreach ($service_periods as $sp) { foreach ($service_periods as $sp) {
echo "Patching $sp trips<br>\n"; echo "Patching $sp trips<br>\n";
foreach (getStopTrips($_REQUEST['stopid'], $sp) as $trip) { foreach (getStopTrips($_REQUEST['stopid'], $sp) as $trip) {
addInformedAlert($_REQUEST['stopsearch'], "trip", $trip['trip_id'], "patch"); addInformedAlert($_REQUEST['stopsearch'], "trip", $trip['trip_id'], "patch");
echo "Added trip inform for" . $_REQUEST['stopsearch'] . ", trip" . $trip['trip_id'] . "<br>\n"; echo "Added trip inform for" . $_REQUEST['stopsearch'] . ", trip" . $trip['trip_id'] . "<br>\n";
} }
echo "Informing $sp routes<br>\n"; echo "Informing $sp routes<br>\n";
foreach (getStopRoutes($_REQUEST['stopid'], $sp) as $route) { foreach (getStopRoutes($_REQUEST['stopid'], $sp) as $route) {
addInformedAlert($_REQUEST['stopsearch'], "route", $route['route_id'], "inform"); addInformedAlert($_REQUEST['stopsearch'], "route", $route['route_id'], "inform");
echo "Added route inform for" . $_REQUEST['stopsearch'] . ", route" . $route['route_id'] . "<br>\n"; echo "Added route inform for" . $_REQUEST['stopsearch'] . ", route" . $route['route_id'] . "<br>\n";
} }
} }
die(); die();
} }
} }
?> ?>
Active and Future Alerts: Active and Future Alerts:
<table> <table>
<?php <?php
foreach(getFutureAlerts() as $alert) { foreach(getFutureAlerts() as $alert) {
echo "<tr><td>{$alert['start']}</td><td>{$alert['end']}</td><td>" . substr($alert['description'], 0, 999) . '</td><td><a href="?edit=' . $alert['id'] . '">edit</a></td></tr>'; echo "<tr><td>{$alert['start']}</td><td>{$alert['end']}</td><td>" . substr($alert['description'], 0, 999) . '</td><td><a href="?edit=' . $alert['id'] . '">edit</a></td></tr>';
} }
   
?> ?>
</table> </table>
<?php <?php
$alert = getServiceAlert($_REQUEST['edit']); $alert = getServiceAlert($_REQUEST['edit']);
   
?> ?>
<form action="<?php echo basename(__FILE__) ; <form action="<?php echo basename(__FILE__) ;
?>" method="get"> ?>" method="get">
   
<div data-role="fieldcontain"> <div data-role="fieldcontain">
<label for="startdate"> Start Date</label> <label for="startdate"> Start Date</label>
<input type="text" name="startdate" id="startdate" value="<?php <input type="text" name="startdate" id="startdate" value="<?php
if ($alert['start']) echo $alert['start']; if ($alert['start']) echo $alert['start'];
else echo date("c", strtotime("0:00")); else echo date("c", strtotime("0:00"));
?>" /> ?>" />
</div> </div>
<div data-role="fieldcontain"> <div data-role="fieldcontain">
<label for="enddate"> End Date </label> <label for="enddate"> End Date </label>
<input type="text" name="enddate" id="enddate" value="<?php <input type="text" name="enddate" id="enddate" value="<?php
if ($alert['end']) echo $alert['end']; if ($alert['end']) echo $alert['end'];
else echo date("c", strtotime("23:59")); else echo date("c", strtotime("23:59"));
?>" /> ?>" />
</div> </div>
<div data-role="fieldcontain"> <div data-role="fieldcontain">
<label for="description">Description</label> <label for="description">Description</label>
<textarea name="description"> <textarea name="description">
<?php echo $alert['description']; <?php echo $alert['description'];
?></textarea> ?></textarea>
</div> </div>
<div data-role="fieldcontain"> <div data-role="fieldcontain">
<label for="url">URL</label> <label for="url">URL</label>
<input type="text" name="url" id="url" value="<?php echo $alert['url']; <input type="text" name="url" id="url" value="<?php echo $alert['url'];
?>" /> ?>" />
</div> </div>
<input type="hidden" name="saveedit" value="<?php echo $_REQUEST['edit']; <input type="hidden" name="saveedit" value="<?php echo $_REQUEST['edit'];
?>"/> ?>"/>
<input type="submit" value="Save"/> <input type="submit" value="Save"/>
</div></form> </div></form>
   
<?php <?php
if ($_REQUEST['edit']) { if ($_REQUEST['edit']) {
echo "Informed Entities for ID {$_REQUEST['edit']}:"; echo "Informed Entities for ID {$_REQUEST['edit']}:";
echo '<table>'; echo '<table>';
foreach(getInformedAlerts($_REQUEST['edit'], "", "") as $informed) { foreach(getInformedAlerts($_REQUEST['edit'], "", "") as $informed) {
echo "<tr><td>{$informed['informed_class']}</td><td>{$informed['informed_id']}</td><td>{$informed['informed_action']}" . '</td><td><a href="?delete=' . $_REQUEST['edit'] . ';' . $informed['informed_class'] . ';' . $informed['informed_id'] . '">delete</a></td></tr>'; echo "<tr><td>{$informed['informed_class']}</td><td>{$informed['informed_id']}</td><td>{$informed['informed_action']}" . '</td><td><a href="?delete=' . $_REQUEST['edit'] . ';' . $informed['informed_class'] . ';' . $informed['informed_id'] . '">delete</a></td></tr>';
} }
echo '</table>'; echo '</table>';
?> ?>
<form action="<?php echo basename(__FILE__) ; <form action="<?php echo basename(__FILE__) ;
?>" method="get"> ?>" method="get">
<input type="hidden" name="networkinform" value="<?php echo $_REQUEST['edit']; <input type="hidden" name="networkinform" value="<?php echo $_REQUEST['edit'];
?>"/> ?>"/>
<input type="submit" value="Add Network Inform"/> <input type="submit" value="Add Network Inform"/>
</form> </form>
<form action="<?php echo basename(__FILE__) ; <form action="<?php echo basename(__FILE__) ;
?>" method="get"> ?>" method="get">
<div data-role="fieldcontain"> <div data-role="fieldcontain">
<label for="stopid">StopID</label> <label for="stopid">StopID</label>
<input type="text" name="stopid" /> <input type="text" name="stopid" />
</div> </div>
<input type="hidden" name="stopsearch" value="<?php echo $_REQUEST['edit']; <input type="hidden" name="stopsearch" value="<?php echo $_REQUEST['edit'];
?>"/> ?>"/>
<input type="submit" value="Stop Search"/> <input type="submit" value="Stop Search"/>
</form> </form>
<form action="<?php echo basename(__FILE__) ; <form action="<?php echo basename(__FILE__) ;
?>" method="get"> ?>" method="get">
<div data-role="fieldcontain"> <div data-role="fieldcontain">
<label for="street">Street</label> <label for="street">Street</label>
<input type="text" name="street" /> <input type="text" name="street" />
</div> </div>
<input type="hidden" name="streetsearch" value="<?php echo $_REQUEST['edit']; <input type="hidden" name="streetsearch" value="<?php echo $_REQUEST['edit'];
?>"/> ?>"/>
<input type="submit" value="Street Search"/> <input type="submit" value="Street Search"/>
</form> </form>
<form action="<?php echo basename(__FILE__) ; <form action="<?php echo basename(__FILE__) ;
?>" method="get"> ?>" method="get">
<div data-role="fieldcontain"> <div data-role="fieldcontain">
<label for="routeid">routeID</label> <label for="routeid">routeID</label>
<input type="text" name="routeid" /> <input type="text" name="routeid" />
</div> </div>
<input type="hidden" name="routesearch" value="<?php echo $_REQUEST['edit']; <input type="hidden" name="routesearch" value="<?php echo $_REQUEST['edit'];
?>"/> ?>"/>
<input type="submit" value="Route Search"/> <input type="submit" value="Route Search"/>
</form> </form>
<?php <?php
} }
include_footer(); include_footer();
?> ?>