static function perform($terms) { $terms = Search::split_terms($terms); $terms_db = Search::db_escape_terms($terms); $terms_rx = Search::rx_escape_terms($terms); $parts = array(); foreach ($terms_db as $term_db) { array_push($parts, "(summary RLIKE '{$term_db}' OR title RLIKE '{$term_db}')"); } $parts = implode(' AND ', $parts); $conn = Persistence::get_database_object(); $sql = "SELECT id, title, summary, created FROM postmortems WHERE {$parts}"; $rows = array(); $stmt = $conn->prepare($sql); $stmt->execute(); $timezone = getUserTimezone(); $tz = new DateTimeZone($timezone); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $row['score'] = 0; $row['created'] = new DateTime("@{$row['created']}"); $row['created']->setTimezone($tz); $row['created'] = $row['created']->format('m/d/Y G:ia'); foreach ($terms_rx as $term_rx) { $row['score'] += preg_match_all("/{$term_rx}/i", $row['summary'], $null); $row['score'] += preg_match_all("/{$term_rx}/i", $row['title'], $null); } $rows[] = $row; } uasort($rows, 'Search::sort_results'); $conn = null; return $rows; }
$event = Postmortem::save_event($event); $app->redirect('/events/' . $event["id"]); }); $app->get('/events/:id', function ($id) use($app) { $event = Postmortem::get_event($id); if (is_null($event["id"])) { echo "loooool"; $app->response->status(404); return; } $page_title = sprintf("%s | Morgue", $event['title']); $starttime = $event["starttime"]; $endtime = $event["endtime"]; $detect_time = $event["detecttime"]; $status_time = $event["statustime"]; $timezone = getUserTimezone(); $severity = $event["severity"]; $gcal = $event["gcal"]; $contact = $event["contact"]; $summary = $event["summary"]; $why_surprised = $event["why_surprised"]; $tz = new DateTimeZone($timezone); $start_datetime = new DateTime("@{$starttime}"); $start_datetime->setTimezone($tz); $end_datetime = new DateTime("@{$endtime}"); $end_datetime->setTimezone($tz); if ($status_time) { $status_datetime = new DateTime("@{$status_time}"); $status_datetime->setTimezone($tz); } else { $status_datetime = false;
<?php ////// HEADER ////// require_once 'phpInclude/header.php'; $userTimezone = getUserTimezone($_SESSION['LoginUserId']); ?> <section class="midsection accountsection"><!-- // MID MAIN SECTION // --> <div class="container"> <div class="row"> <div class="col-xs-12 col-sm-4 col-md-3"> <?php require_once 'phpInclude/sidebar_expert_profile.php'; ?> </div> <div class="col-xs-12 col-sm-8 col-md-9"> <section class="right_main"><!-- // RIGHT MAIN // --> <ul class="breadcrumb"> <li><a href="javascript:void(0);">Home</a></li> <li>My Sessions</li> </ul> <h2 class="accountheading"><small>My</small>Sessions</h2> <div class="MysessionCont"> <ul class="session_tabs "> <li><a href="<?php echo $root; ?> user_sessions.php?tab=schedule" class="<?php if (empty($_GET['tab']) || isset($_GET['tab']) && $_GET['tab'] == 'schedule') { echo 'active';
<div class="row-fluid"> <div class="span12"> <table class="table table-striped"> <thead> <tr> <th>Title</th> <th>Start Time</th> <th>End Time</th> <th>Severity</th> </tr> </thead> <?php $tz = new DateTimeZone(getUserTimezone()); foreach ($events as $event) { $start = new DateTime("@" . $event["starttime"]); $start->setTimezone($tz); $start = $start->format('m/d/Y G:ia'); $end = new DateTime("@" . $event["endtime"]); $end->setTimezone($tz); $end = $end->format('m/d/Y G:ia'); echo "<tr>"; echo "<td><a href=/events/{$event['id']}>{$event['title']}</a></td>"; echo "<td>{$start}</td>"; echo "<td>{$end}</td>"; echo "<td>{$event['severity']}</td>"; echo "</tr>"; } ?> </table> </div> </div>
<div class="row-fluid"> <div class="offset1 span10"> <!-- Title --> <div class="row-fluid"> <input class="input-headline editable" id="eventtitle" type="text" value="<?php echo $event["title"]; ?> " required disabled> </div> <!-- Small Print --> <div class="row-fluid"> <i class="muted"><small>All times are currently shown in <?php echo getUserTimezone(); ?> time.</small></i> </div> <div class="row-fluid"> <br/> </div> <!-- Time and Severity (in two columns) --> <div class="row-fluid"> <!-- Editable Controls --> <form class="form-horizontal"> <div class="span6"> <div class="control-group"> <label class="control-label" id="event-start-time">Start time: </label> <div class="controls controls-row">
echo json_encode(array('status' => $status, 'result' => $tags)); exit; } else { if (isset($_POST['action']) && $_POST['action'] == 'submit_book_schedule_public') { $session_id = ""; $error = array(); foreach ($_POST as $key => $value) { if (!is_array($value)) { $value = empty($value) ? '' : $value; ${$key} = mysql_real_escape_string(trim($value)); } else { $value = empty($value) ? array() : $value; ${$key} = $value; } } $userTimezone = getUserTimezone($user_id); //exp_id if (!isset($tag_selected)) { $tag_selected = array(); } if (!isset($language_selected)) { $language_selected = array(); } if (!isset($slot_selected)) { $slot_selected = array(); } //$tag_selected = (isset(($tag_selected)))?array():$tag_selected; //$language_selected = (isset(($language_selected)))?array():$language_selected; $sql = " INSERT INTO sessions SET user_id='" . $user_id . "',category_id='" . $category_id . "', tag_id='" . implode($tag_selected, ',') . "',language_id='" . implode($language_selected, ',') . "', type='request',duration='" . $duration . "',title='" . $title . "',description='" . $description . "',question='" . $question . "',other='" . $other . "',status='1',created='" . $date . "' "; $query = mysql_query($sql); if ($query) {