| 
<?phpsession_start();
 require __DIR__.'/../config.php';
 include __DIR__.'../../scripts/status.php';
 include __DIR__.'../../scripts/verifyauth.php';
 
 $TITLEPAGE = 'My tickets - '.$SERVER_NAME;
 include __DIR__ . '/static/header.php';
 ?>
 <div class="mininav">
 <nav aria-label="breadcrumb">
 <ol class="breadcrumb">
 <li class="breadcrumb-item"><a href="System.php"><i class="fa-solid fa-circle-chevron-left"></i> Back</a></li>
 <li class="breadcrumb-item active" aria-current="page"><i class="fa-solid fa-ticket"></i> My tickets</li>
 </ol>
 </nav>
 </div>
 <?php
 if(isset($_SESSION['Msg'])){
 echo $_SESSION['Msg'];
 unset($_SESSION['Msg']);
 }
 else{
 unset($_SESSION['Msg']);
 }
 ?>
 <nav class="menufilters">
 <h1><i class="fa-solid fa-ticket"></i> My tickets</h1>
 <form action="../scripts/ticketsquerys/searchticketheader.php" method="POST" class="formsearchtip">
 <div class="input-group input-group-lg">
 <span class="input-group-text" id="searchlabel">Search</span>
 <input type="text" class="form-control" id="searchbar" name="searchbar" placeholder="Type something to search" aria-describedby="searchlabel" minlength="3" maxlength="99" required/>
 <select class="form-select" id="searchtype" name="searchtype">
 <option value="0" selected>Filter by protocol</option>
 <option value="1">Filter by hash</option>
 <option value="2">Filter by tag</option>
 </select>
 <button class="btn btn-primary" type="submit"><i class="fa-solid fa-magnifying-glass"></i></button>
 </div>
 </form>
 <h5>ou</h5>
 <form action="../scripts/ticketsquerys/searchticketfilter.php" method="POST" class="formsearchfilter">
 <div class="row" align="center">
 <div class="col-md-3">
 <label for="periodsearch" class="form-label"><i class="fa-solid fa-calendar-week"></i> Period</label>
 <select id="periodsearch" name="periodsearch" class="form-select">
 <option value="0" selected>All</option>
 <option value="1">Today</option>
 <option value="2">Yesterday</option>
 <option value="3">Last 7 days</option>
 <option value="4">Last 30 days</option>
 </select>
 </div>
 <div class="col-md-3">
 <label for="statussearch" class="form-label"><i class="fa-solid fa-bars-progress"></i> Status</label>
 <select id="statussearch" name="statussearch" class="form-select">
 <option value="0" selected>All</option>
 <option value="1">Opened</option>
 <option value="2">Canceled</option>
 <option value="3">Rejected</option>
 <option value="4">Resolved</option>
 </select>
 </div>
 <div class="col-md-3">
 <label for="dateinitsearch" class="form-label"><i class="fa-solid fa-hourglass-start"></i> Opened in</label>
 <input type="date" id="dateinitsearch" name="dateinitsearch" class="form-select"/>
 </div>
 <div class="col-md-3">
 <label for="dateendsearch" class="form-label"><i class="fa-solid fa-hourglass-end"></i> Finished in</label>
 <input type="date" id="dateendsearch" name="dateendsearch" class="form-select"/>
 </div>
 </div>
 <div class="row">
 <small>If you choose a date in "Open in" or "Finished in", the "Period" will be disregarded!</small>
 </div>
 <div class="row">
 <button class="btn btn-primary" type="submit"><i class="fa-solid fa-filter"></i> Filter</button>
 </div>
 </form>
 </nav>
 <section class="ticketstable">
 <table class="table table-hover">
 <thead>
 <tr>
 <th scope="col"><i class="fa-solid fa-hand"></i></th>
 <th scope="col"><i class="fa-solid fa-ticket-simple"></i> Protocol</th>
 <th scope="col"><i class="fa-solid fa-envelope"></i> Title</th>
 <th scope="col"><i class="fa-regular fa-paper-plane"></i> Tag</th>
 <th scope="col"><i class="fa-solid fa-bars-progress"></i> Status</th>
 <th scope="col"><i class="fa-solid fa-hourglass-start"></i> Opened in</th>
 <th scope="col"><i class="fa-solid fa-hourglass-end"></i> Finished in</th>
 </tr>
 </thead>
 <tbody>
 <?php
 for($j=0; $j<$_SESSION['DataMyTickets']['count']; $j++){
 $DataTicketFormatadaAberto = new DateTime($_SESSION['DataMyTickets'][$j][4]);
 $DataTicketFormatadaFechado = new DateTime($_SESSION['DataMyTickets'][$j][5]);
 if($DataTicketFormatadaFechado->format('Y-m-d')=="-0001-11-30"){
 $DataTicketFormatadaFechadoView = ' - ';
 }else{
 $DataTicketFormatadaFechadoView = $DataTicketFormatadaFechado->format('d/m/Y').' at '.$DataTicketFormatadaFechado->format('H:i:s');
 }
 echo '<tr>
 <th scope="row"><a class="btn btn-success" href="'.'../scripts/selectticket.php?protocolticket='.$_SESSION['DataMyTickets'][$j][0].'" role="button"><i class="fa-solid fa-arrow-pointer"></i></a></th>
 <td>'.$_SESSION['DataMyTickets'][$j][0].'</td>
 <td>'.$_SESSION['DataMyTickets'][$j][2].'</td>
 <td>'.$_SESSION['DataMyTickets'][$j][1].'</td>
 <td>'.$_SESSION['DataMyTickets'][$j][3].'</td>
 <td>'.$DataTicketFormatadaAberto->format('d/m/Y').' at '.$DataTicketFormatadaAberto->format('H:i:s').'</td>
 <td>'.$DataTicketFormatadaFechadoView.'</td>
 </tr>';
 }
 ?>
 </tbody>
 </table>
 <?php
 if($_SESSION['DataMyTickets']['count']==0){
 echo '<h2><i class="fa-regular fa-circle-xmark"></i> We were unable to get results for your search.</h2>';
 }
 ?>
 </section>
 <?php
 include __DIR__ . '/static/footer.php';
 ?>
 |