portal/get_problems.php

   1 <?php
   2 /**
   3  *
   4  * Copyright (C) 2016-2017 Jerry Padgett <sjpadgett@gmail.com>
   5  * Copyright (C) 2011 Cassian LUP <cassi.lup@gmail.com>
   6  *
   7  * LICENSE: This program is free software; you can redistribute it and/or
   8  * modify it under the terms of the GNU General Public License
   9  * as published by the Free Software Foundation; either version 3
  10  * of the License, or (at your option) any later version.
  11  * This program is distributed in the hope that it will be useful,
  12  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  13  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  14  * GNU General Public License for more details.
  15  * You should have received a copy of the GNU General Public License
  16  * along with this program. If not, see <http://opensource.org/licenses/gpl-license.php>;.
  17  *
  18  * @package OpenEMR
  19  * @author Cassian LUP <cassi.lup@gmail.com>
  20  * @author Jerry Padgett <sjpadgett@gmail.com>
  21  * @link http://www.open-emr.org
  22  *
  23  */
  24
  25         require_once("verify_session.php");
  26
  27     $sql = "SELECT * FROM lists WHERE pid = ? AND type = 'medical_problem' ORDER BY begdate";
  28
  29     $res = sqlStatement($sql, array($pid) );
  30
  31       if(sqlNumRows($res)>0)
  32       {
  33           ?>
  34           <table class="table table-striped">
  35               <tr class="header">
  36                   <th><?php echo xlt('Title');?></th>
  37                   <th><?php echo xlt('Reported Date');?></th>
  38                   <th><?php echo xlt('Start Date');?></th>
  39                   <th><?php echo xlt('End Date');?></th>
  40               </tr>
  41           <?php
  42           $even=false;
  43           while ($row = sqlFetchArray($res)) {
  44
  45               echo "<tr class='".text($class)."'>";
  46               echo "<td>".text($row['title'])."</td>";
  47               echo "<td>".text($row['date'])."</td>";
  48               echo "<td>".text($row['begdate'])."</td>";
  49               echo "<td>".text($row['enddate'])."</td>";
  50               echo "</tr>";
  51           }
  52         echo "</table>";
  53       }
  54     else
  55     {
  56         echo xlt("No Results");
  57     }
  58 ?>