Exemple #1
1
function showDocument(&$drow)
{
    global $ISSUE_TYPES, $auth_med;
    $docdate = $drow['docdate'];
    echo "<tr class='text docrow' id='" . htmlspecialchars($drow['id'], ENT_QUOTES) . "' title='" . htmlspecialchars(xl('View document'), ENT_QUOTES) . "'>\n";
    // show date
    echo "<td>" . htmlspecialchars(oeFormatShortDate($docdate), ENT_NOQUOTES) . "</td>\n";
    // show associated issue, if any
    echo "<td>";
    if ($auth_med) {
        $irow = sqlQuery("SELECT type, title, begdate " . "FROM lists WHERE " . "id = ? " . "LIMIT 1", array($drow['list_id']));
        if ($irow) {
            $tcode = $irow['type'];
            if ($ISSUE_TYPES[$tcode]) {
                $tcode = $ISSUE_TYPES[$tcode][2];
            }
            echo htmlspecialchars("{$tcode}: " . $irow['title'], ENT_NOQUOTES);
        }
    } else {
        echo "(" . htmlspecialchars(xl('No access'), ENT_NOQUOTES) . ")";
    }
    echo "</td>\n";
    // show document name and category
    echo "<td colspan='3'>" . htmlspecialchars(xl('Document') . ": " . basename($drow['url']) . ' (' . xl_document_category($drow['name']) . ')', ENT_NOQUOTES) . "</td>\n";
    // skip billing and insurance columns
    if (!$GLOBALS['athletic_team']) {
        echo "<td colspan=5>&nbsp;</td>\n";
    }
    echo "</tr>\n";
}
Exemple #2
1
function procedure_order_report($pid, $encounter, $cols, $id)
{
    $cols = 1;
    // force always 1 column
    $count = 0;
    $data = sqlQuery("SELECT * " . "FROM procedure_order WHERE " . "procedure_order_id = '{$id}' AND activity = '1'");
    if ($data) {
        print "<table cellpadding='0' cellspacing='0'>\n<tr>\n";
        foreach ($data as $key => $value) {
            if ($key == "procedure_order_id" || $key == "pid" || $key == "user" || $key == "groupname" || $key == "authorized" || $key == "activity" || $key == "date" || $value == "" || $value == "0" || $value == "0.00") {
                continue;
            }
            $key = ucwords(str_replace("_", " ", $key));
            if ($key == "Order Priority") {
                print "<td valign='top'><span class='bold'>" . xl($key) . ": </span><span class='text'>" . generate_display_field(array('data_type' => '1', 'list_id' => 'ord_priority'), $value) . " &nbsp;</span></td>\n";
            } else {
                if ($key == "Order Status") {
                    print "<td valign='top'><span class='bold'>" . xl($key) . ": </span><span class='text'>" . generate_display_field(array('data_type' => '1', 'list_id' => 'ord_status'), $value) . " &nbsp;</span></td>\n";
                } else {
                    print "<td valign='top'><span class='bold'>" . xl($key) . ": </span><span class='text'>{$value} &nbsp;</span></td>\n";
                }
            }
            $count++;
            if ($count == $cols) {
                $count = 0;
                print "</tr>\n<tr>\n";
            }
        }
        print "</tr>\n</table>\n";
    }
}
Exemple #3
0
function load_menu($menu_set)
{
    $menuTables = " SHOW TABLES LIKE ?";
    $res = sqlQuery($menuTables, array("menu_trees"));
    if ($res === false) {
        return array();
    }
    $menuQuery = " SELECT * FROM menu_trees, menu_entries WHERE menu_trees.entry_id=menu_entries.id AND menu_set=? ORDER BY parent, seq";
    $res = sqlStatement($menuQuery, array($menu_set));
    $retval = array();
    $entries = array();
    $parent_not_found = array();
    while ($row = sqlFetchArray($res)) {
        $entries[$row['entry_id']] = menu_entry_to_object($row);
        if (empty($row['parent'])) {
            array_push($retval, $entries[$row['entry_id']]);
        } else {
            if (isset($entries[$row['parent']])) {
                $parent = $entries[$row['parent']];
                array_push($parent->children, $entries[$row['entry_id']]);
            } else {
                array_push($parent_not_found, $entries[$row['entry_id']]);
            }
        }
    }
    foreach ($parent_not_found as $row) {
        if (isset($entries[$row->parent])) {
            $parent = $entries[$row->parent];
            array_push($parent->children, $row);
        } else {
            array_push($parent_not_found2, $row);
        }
    }
    return json_decode(json_encode($retval));
}
 public function test(CqmPatient $patient, $beginDate, $endDate)
 {
     $age = $patient->calculateAgeOnDate($beginDate);
     if ($age >= 2 && $age <= 18) {
         //Children 2-18 years of age who had an outpatient or emergency department (ED) visit with a diagnosis of pharyngitis during the measurement period and an antibiotic ordered on or three days after the visit
         $pharyngitisArr = array('ICD9:034', 'ICD9:462', 'ICD9:463', 'ICD10:J02.0', 'ICD10:J02.8', 'ICD10:J02.9', 'ICD10:J03.80', 'ICD10:J03.81', 'ICD10:J03.90', 'ICD10:J03.91');
         $query = "SELECT l.title as drug FROM form_encounter fe " . "INNER JOIN openemr_postcalendar_categories opc ON fe.pc_catid = opc.pc_catid " . "INNER JOIN lists l ON l.type = 'medication' AND fe.pid = l.pid " . "WHERE opc.pc_catname = 'Office Visit' ";
         $pharyngitisStr = "(";
         $cnt = 0;
         foreach ($pharyngitisArr as $pharyngitisCode) {
             if ($cnt == 0) {
                 $pharyngitisStr .= " l.diagnosis LIKE '%" . $pharyngitisCode . "%' ";
             } else {
                 $pharyngitisStr .= " OR l.diagnosis LIKE '%" . $pharyngitisCode . "%' ";
             }
             $cnt++;
         }
         $pharyngitisStr .= ")";
         $query .= " AND " . $pharyngitisStr;
         $query .= " AND fe.pid = ? AND (fe.date BETWEEN ? AND ?)";
         $check = sqlQuery($query, array($patient->id, $beginDate, $endDate));
         if ($check['drug'] != "") {
             return true;
         } else {
             return false;
         }
     }
     return false;
 }
Exemple #5
0
function scanned_notes_report($pid, $useless_encounter, $cols, $id)
{
    global $webserver_root, $web_root, $encounter;
    // In the case of a patient report, the passed encounter is vital.
    $thisenc = $useless_encounter ? $useless_encounter : $encounter;
    $count = 0;
    $data = sqlQuery("SELECT * " . "FROM form_scanned_notes WHERE " . "id = '{$id}' AND activity = '1'");
    if ($data) {
        echo "<table cellpadding='0' cellspacing='0'>\n";
        if ($data['notes']) {
            echo " <tr>\n";
            echo "  <td valign='top'><span class='bold'>Comments: </span><span class='text'>";
            echo nl2br($data['notes']) . "</span></td>\n";
            echo " </tr>\n";
        }
        for ($i = -1; true; ++$i) {
            $suffix = $i < 0 ? "" : "-{$i}";
            $imagepath = $GLOBALS['OE_SITE_DIR'] . "/documents/{$pid}/encounters/{$thisenc}_{$id}{$suffix}.jpg";
            $imageurl = "{$web_root}/sites/" . $_SESSION['site_id'] . "/documents/{$pid}/encounters/{$thisenc}_{$id}{$suffix}.jpg";
            if (is_file($imagepath)) {
                echo " <tr>\n";
                echo "  <td valign='top'>\n";
                echo "   <img src='{$imageurl}' />\n";
                echo "  </td>\n";
                echo " </tr>\n";
            } else {
                if ($i >= 0) {
                    break;
                }
            }
        }
        echo "</table>\n";
    }
}
 /**
  *
  * @param RuleCriteria $criteria
  */
 function modify($criteria, $ruleId)
 {
     // get interval
     $result = sqlQuery(self::SQL_RULE_INTERVAL, array($ruleId));
     $criteria->interval = $result['interval'] ? $result['interval'] : 1;
     $criteria->intervalType = $result['value'] ? TimeUnit::from($result['value']) : TimeUnit::from(TimeUnit::Month);
 }
Exemple #7
0
function scanned_notes_report($pid, $useless_encounter, $cols, $id)
{
    global $webserver_root, $web_root, $encounter;
    // In the case of a patient report, the passed encounter is vital.
    $thisenc = $useless_encounter ? $useless_encounter : $encounter;
    $count = 0;
    $data = sqlQuery("SELECT * " . "FROM form_scanned_notes WHERE " . "id = '{$id}' AND activity = '1'");
    if ($data) {
        if ($data['notes']) {
            echo "  <span class='bold'>Comments: </span><span class='text'>";
            echo nl2br($data['notes']) . "</span><br />\n";
        }
        for ($i = -1; true; ++$i) {
            $suffix = $i < 0 ? "" : "-{$i}";
            $imagepath = $GLOBALS['OE_SITE_DIR'] . "/documents/{$pid}/encounters/{$thisenc}_{$id}{$suffix}.jpg";
            $imageurl = "{$web_root}/sites/" . $_SESSION['site_id'] . "/documents/{$pid}/encounters/{$thisenc}_{$id}{$suffix}.jpg";
            if (is_file($imagepath)) {
                echo "   <img src='{$imageurl}'";
                // Flag images with excessive width for possible stylesheet action.
                $asize = getimagesize($imagepath);
                if ($asize[0] > 750) {
                    echo " class='bigimage'";
                }
                echo " />\n";
                echo " <br />\n";
            } else {
                if ($i >= 0) {
                    break;
                }
            }
        }
    }
}
Exemple #8
0
 public function test(CqmPatient $patient, $beginDate, $endDate)
 {
     //Children who are taking antibiotics in the 30 days prior to the diagnosis of pharyngitis
     $pharyngitisArr = array('ICD9:034', 'ICD9:462', 'ICD9:463', 'ICD10:J02.0', 'ICD10:J02.8', 'ICD10:J02.9', 'ICD10:J03.80', 'ICD10:J03.81', 'ICD10:J03.90', 'ICD10:J03.91');
     $query = "SELECT count(*) as cnt FROM form_encounter fe " . "INNER JOIN openemr_postcalendar_categories opc ON fe.pc_catid = opc.pc_catid " . "INNER JOIN lists l ON l.type = 'medication' AND fe.pid = l.pid " . "WHERE opc.pc_catname = 'Office Visit' ";
     $pharyngitisStr = "(";
     $cnt = 0;
     foreach ($pharyngitisArr as $pharyngitisCode) {
         if ($cnt == 0) {
             $pharyngitisStr .= " l.diagnosis LIKE '%" . $pharyngitisCode . "%' ";
         } else {
             $pharyngitisStr .= " OR l.diagnosis LIKE '%" . $pharyngitisCode . "%' ";
         }
         $cnt++;
     }
     $pharyngitisStr .= ")";
     $query .= " AND " . $pharyngitisStr;
     $query .= " AND fe.pid = ? AND (fe.date BETWEEN ? AND ?)";
     $check = sqlQuery($query, array($patient->id, $beginDate, $endDate));
     if ($check['cnt'] > 1) {
         //more than one medication it will exclude
         return true;
     } else {
         return false;
     }
 }
Exemple #9
0
function misc_billing_options_report($pid, $encounter, $cols, $id)
{
    $count = 0;
    $data = formFetch("form_misc_billing_options", $id);
    if ($data) {
        print "<table><tr>";
        foreach ($data as $key => $value) {
            if ($key == "id" || $key == "pid" || $key == "user" || $key == "groupname" || $key == "authorized" || $key == "activity" || $key == "date" || $value == "" || $value == "0" || $value == "0000-00-00 00:00:00" || $value == "0000-00-00") {
                continue;
            }
            if ($value == "1") {
                $value = "yes";
            }
            if ($key === 'box_14_date_qual' || $key === 'box_15_date_qual') {
                $value = text(qual_id_to_description($key, $value));
            }
            if ($key === 'provider_id') {
                $trow = sqlQuery("SELECT id, lname, fname FROM users WHERE " . "id = ? ", array($value));
                $value = $trow['fname'] . ' ' . $trow['lname'];
            }
            $key = ucwords(str_replace("_", " ", $key));
            print "<td><span class=bold>{$key}: </span><span class=text>" . text($value) . "</span></td>";
            $count++;
            if ($count == $cols) {
                $count = 0;
                print "</tr><tr>\n";
            }
        }
    }
    print "</tr></table>";
}
Exemple #10
0
 public function test(AmcPatient $patient, $beginDate, $endDate)
 {
     $procedure_order_id = $patient->object['procedure_order_id'];
     $sql = "SELECT count(r.result) as cnt FROM procedure_result r " . "INNER JOIN procedure_report pr ON pr.procedure_report_id = r.procedure_report_id " . "INNER JOIN procedure_order po ON po.procedure_order_id = pr.procedure_order_id " . "WHERE r.result !=  '' " . "AND po.procedure_order_id = ?";
     $check = sqlQuery($sql, array($procedure_order_id));
     return $check['cnt'];
 }
Exemple #11
0
function section_jointeam_doJoin($id, $invite)
{
    // Try to add player to team
    $obj = mysql_fetch_object(mysql_query("select l_team.id, l_team.name, l_team.leader, count(callsign) nump\n      from l_team left join l_player  on l_team.id = l_player.team\n      where l_team.id = " . $id . "\n      group by l_team.id, l_team.name, l_team.leader"));
    if ($obj->nump == $TEAMSIZE) {
        // Team full
        echo "<center>Sorry, this team is full. Probably someone was joining it at the same time...</center>";
    } else {
        // Okay, let's do the update
        mysql_query("update l_player set team=" . $id . " where id=" . $_SESSION['playerid']);
        // Close team if it's full
        if ($obj->nump == $TEAMSIZE - 1) {
            mysql_query("update l_team set status='closed' where id=" . $id);
        }
        // Close team if it has 3 players and is adminclosed
        if ($obj->nump == 2) {
            mysql_query("update l_team set status='closed' where adminclosed='yes' and id=" . $id);
        }
        echo '<center>You are now a member of the ' . teamLink($obj->name, $obj->id, false) . ' team.<BR> 
        A message has been sent to the team leader.</center>';
        session_refresh();
        // Send a message to the team leader
        $player = playerLink($_SESSION['playerid'], $_SESSION['callsign']);
        if ($invite) {
            $msg = "{$player} has accepted your invitation, and has joined your team!<BR>";
            sqlQuery("DELETE FROM bzl_invites WHERE teamid={$obj->id}  AND \n            playerid={$_SESSION['playerid']}");
        } else {
            $msg = "A new player just joined your team: {$player}";
        }
        sendBzMail(0, $obj->leader, $_SESSION['callsign'] . ' joined your team!', $msg);
    }
}
Exemple #12
0
function ippf_srh_report($pid, $encounter, $cols, $id)
{
    require_once $GLOBALS["srcdir"] . "/options.inc.php";
    echo "<table>\n";
    display_layout_rows('SRH', sqlQuery("SELECT * FROM form_ippf_srh WHERE id = '{$id}'"));
    echo "</table>\n";
}
Exemple #13
0
function timetable($hour, $row)
{
    global $rs;
    // if $rs is null then query database (this should be executed only once - first time)
    if ($rs === null) {
        // first column of the query is used as key in returned array
        $rs = sqlQuery("select concat(t.tbl_row,'_',t.tbl_col) as pos, t.tbl_id, t.sub_id, s.sub_name\n\t\t\t\t\t\tfrom redips_timetable t, redips_subject s\n\t\t\t\t\t\twhere t.sub_id = s.sub_id", 0);
    }
    print '<tr>';
    print '<td class="mark dark">' . $hour . '</td>';
    // column loop starts from 1 because column 0 is for hours
    for ($col = 1; $col <= 5; $col++) {
        // create table cell
        print '<td>';
        // prepare position key in the same way as the array key looks
        $pos = $row . '_' . $col;
        // if content for the current table cell exists
        if (array_key_exists($pos, $rs)) {
            // prepare elements for defined position (it can be more than one element per table cell)
            $elements = $rs[$pos];
            // id of DIV element will start with sub_id and followed with 'b' (because cloned elements on the page have 'c') and with tbl_id
            // this way content from the database will not be in collision with new content dragged from the left table and each id stays unique
            $id = $elements[2] . 'b' . $elements[1];
            $name = $elements[3];
            $class = substr($id, 0, 2);
            // class name is only first 2 letters from ID
            print "<div id=\"{$id}\" class=\"redips-drag {$class}\">{$name}</div>";
        }
        // close table cell
        print '</td>';
    }
    print "</tr>\n";
}
function fetchData()
{
    global $greyVid, $bradyVids, $lastUpdate;
    $greyVid = sqlQuery("SELECT * FROM Video WHERE creator='C.G.P. Grey' ORDER BY uploaddate DESC LIMIT 1")[0];
    $bradyVids = sqlQuery("SELECT * FROM Video WHERE creator='Brady Haran' AND uploaddate > \$1 ORDER BY uploaddate DESC", array($greyVid["uploaddate"]));
    $lastUpdate = sqlQuery("SELECT * FROM UpdateLog ORDER BY updatedatetime DESC LIMIT 1")[0]['updatedatetime'];
}
Exemple #15
0
 /**
  * Retrieve and existing private key based on the public key value and delete it.
  * This function also garbage collects any "stale/unused" pairs that are older than 5 minutes (300 seconds)
  * 
  * @param type $pub
  */
 public function load_from_db($pub)
 {
     $res = sqlQuery("SELECT private FROM rsa_pairs where public=?", array($pub));
     $this->privKey = $res['private'];
     // Delete this pair, and garbage collect any pairs older than 5 minutes.
     sqlQuery("DELETE FROM rsa_pairs where public=? OR timestampdiff(second,created,now()) > ?", array($pub, 300));
 }
Exemple #16
0
function hist_exam_plan_report($pid, $encounter, $cols, $id)
{
    $cols = 1;
    // force always 1 column
    $count = 0;
    $data = sqlQuery("SELECT * " . "FROM form_hist_exam_plan WHERE " . "id = '{$id}' AND activity = '1'");
    if ($data) {
        print "<table cellpadding='0' cellspacing='0'>\n<tr>\n";
        foreach ($data as $key => $value) {
            if ($key == "id" || $key == "pid" || $key == "user" || $key == "groupname" || $key == "authorized" || $key == "activity" || $key == "date" || $value == "" || $value == "0" || $value == "0.00") {
                continue;
            }
            if ($value == "on") {
                $value = "yes";
            }
            $key = ucwords(str_replace("_", " ", $key));
            print "<td valign='top'><span class='bold'>{$key}: </span><span class='text'>{$value} &nbsp;</span></td>\n";
            $count++;
            if ($count == $cols) {
                $count = 0;
                print "</tr>\n<tr>\n";
            }
        }
        print "</tr>\n</table>\n";
    }
}
function tableExists_de($tblname)
{
    $row = sqlQuery("SHOW TABLES LIKE '{$tblname}'");
    if (empty($row)) {
        return false;
    }
    return true;
}
function get_document_by_catg($pid, $doc_catg)
{
    $result = array();
    if ($pid and $doc_catg) {
        $result = sqlQuery("SELECT d.id, d.date, d.url FROM " . "documents AS d, categories_to_documents AS cd, categories AS c " . "WHERE d.foreign_id = ? " . "AND cd.document_id = d.id " . "AND c.id = cd.category_id " . "AND c.name LIKE ? " . "ORDER BY d.date DESC LIMIT 1", array($pid, $doc_catg));
    }
    return $result['id'];
}
Exemple #19
0
function section_invite_sendInvite($team, $player, $days, $text)
{
    echo "<center>Invitation sent to player, thank you!</center>";
    $text = htmlentities($text);
    $msg = '<b>' . $_SESSION['callsign'] . "</b> is inviting you to join his/her team: <b>{$team->name}</b>.<br>\n      <u>Invitation text:</u><br>{$text}<p><br>\n      <a href='index.php?link=jointeam&id={$team->id}'><font size=+1>Click here to accept the invitation.</font></a><br>\n      Note that the invitation expires {$days} days from when it was sent.";
    sendBzMail($_SESSION['playerid'], $player->id, 'Invitation from ' . $_SESSION['callsign'], $msg, false, true);
    sqlQuery("INSERT INTO bzl_invites (teamid, playerid, expires) VALUES ({$team->id}, {$player->id}, \n     ADDDATE(NOW(), INTERVAL {$days} DAY))");
}
Exemple #20
0
/**
 * Get lab's ID from the users table given its NPI.  If none return 0.
 *
 * @param  string  $npi           The lab's NPI number as known to the system
 * @return integer                The numeric value of the lab's address book entry
 */
function getLabID($npi)
{
    $lrow = sqlQuery("SELECT ppid FROM procedure_providers WHERE " . "npi = ? ORDER BY ppid LIMIT 1", array($npi));
    if (empty($lrow['ppid'])) {
        return 0;
    }
    return intval($lrow['ppid']);
}
function getCopay($patient_id, $encdate)
{
    $tmp = sqlQuery("SELECT provider, copay FROM insurance_data " . "WHERE pid = '{$patient_id}' AND type = 'primary' " . "AND date <= '{$encdate}' ORDER BY date DESC LIMIT 1");
    if ($tmp['provider']) {
        return sprintf('%01.2f', 0 + $tmp['copay']);
    }
    return -1;
}
Exemple #22
0
 public function test(AmcPatient $patient, $beginDate, $endDate)
 {
     $off_visits = sqlQuery("select count(encounter) as cnt from form_encounter e inner join openemr_postcalendar_categories opc on opc.pc_catid = e.pc_catid where e.pid = ? and e.date >= ? and e.date <= ? and opc.pc_catname = 'office visit'", array($patient->id, $beginDate, $endDate));
     if ($off_visits['cnt'] >= 1) {
         return true;
     }
     return false;
 }
Exemple #23
0
function row_modify($table, $set, $where)
{
    if (sqlQuery("SELECT * FROM {$table} WHERE {$where}")) {
        newEvent("deactivate", $_SESSION['authUser'], $_SESSION['authProvider'], 1, "{$table}: {$where}");
        $query = "UPDATE {$table} SET {$set} WHERE {$where}";
        echo $query . "<br>\n";
        sqlStatement($query);
    }
}
Exemple #24
0
/**
 * Function to return the category id of a category title.
 *
 * @param  string  $category_title  category title
 * @return int/boolean              category id (returns false if the category title does not exist)
 */
function document_category_to_id($category_title)
{
    $ret = sqlQuery("SELECT `id` FROM `categories` WHERE `name`=?", array($category_title));
    if ($ret['id']) {
        return $ret['id'];
    } else {
        return false;
    }
}
Exemple #25
0
 public function test(AmcPatient $patient, $beginDate, $endDate)
 {
     $check = sqlQuery("SELECT dc_father,dc_mother, dc_siblings, dc_offspring FROM `history_data` WHERE `pid`=? ORDER BY id DESC LIMIT 1", array($patient->id));
     if ($check['dc_father'] != "" || $check['dc_mother'] != "" || $check['dc_siblings'] != "" || $check['dc_offspring'] != "") {
         return true;
     } else {
         return false;
     }
 }
Exemple #26
0
/**
 * Get a list item title, translating if required.
 *
 * @param  string  $listid  List identifier.
 * @param  string  $value   List item identifier.
 * @return string  The item's title.
 */
function getListItem($listid, $value)
{
    $lrow = sqlQuery("SELECT title FROM list_options " . "WHERE list_id = ? AND option_id = ?", array($listid, $value));
    $tmp = xl_list_label($lrow['title']);
    if (empty($tmp)) {
        $tmp = "({$report_status})";
    }
    return $tmp;
}
/**
 * Get a list item title, translating if required.
 *
 * @param  string  $listid  List identifier.
 * @param  string  $value   List item identifier.
 * @return string  The item's title.
 */
function getListItem($listid, $value)
{
    $lrow = sqlQuery("SELECT title FROM list_options " . "WHERE list_id = ? AND option_id = ? AND activity = 1", array($listid, $value));
    $tmp = xl_list_label($lrow['title']);
    if (empty($tmp)) {
        $tmp = $value === '' ? '' : "({$value})";
    }
    return $tmp;
}
function thisLineItem($row, $codetype, $code)
{
    global $code_types;
    $provname = $row['provider_lname'];
    if (!empty($row['provider_fname'])) {
        $provname .= ', ' . $row['provider_fname'];
        if (!empty($row['provider_mname'])) {
            $provname .= ' ' . $row['provider_mname'];
        }
    }
    $crow = sqlQuery("SELECT code_text FROM codes WHERE " . "code_type = '" . $code_types[$codetype]['id'] . "' AND " . "code = '{$code}' LIMIT 1");
    $code_text = $crow['code_text'];
    if ($_POST['form_csvexport']) {
        echo '"' . addslashes($row['patient_name']) . '",';
        echo '"' . addslashes($row['pubpid']) . '",';
        echo '"' . addslashes($row['date_ordered']) . '",';
        echo '"' . addslashes($row['procedure_name']) . '",';
        echo '"' . addslashes($provname) . '",';
        echo '"' . addslashes($code) . '",';
        echo '"' . addslashes($code_text) . '"' . "\n";
    } else {
        ?>
 <tr>
  <td class="detail"><?php 
        echo $row['patient_name'];
        ?>
</td>
  <td class="detail"><?php 
        echo $row['pubpid'];
        ?>
</td>
  <td class="detail"><?php 
        echo $row['date_ordered'];
        ?>
</td>
  <td class="detail"><?php 
        echo $row['procedure_name'];
        ?>
</td>
  <td class="detail"><?php 
        echo $provname;
        ?>
</td>
  <td class="detail"><?php 
        echo $code;
        ?>
</td>
  <td class="detail"><?php 
        echo $code_text;
        ?>
</td>
 </tr>
<?php 
    }
    // End not csv export
}
Exemple #29
0
 public function test(AmcPatient $patient, $beginDate, $endDate)
 {
     $encQry = "SELECT * FROM forms f " . "INNER JOIN form_encounter fe ON f.encounter = fe.encounter " . "WHERE  f.formdir != 'newpatient' AND f.deleted = 0 AND f.pid = ? AND (f.date BETWEEN ? AND ?) ";
     $check = sqlQuery($encQry, array($patient->id, $beginDate, $endDate));
     if (!empty($check)) {
         return true;
     } else {
         return false;
     }
 }
Exemple #30
0
 public function test(CqmPatient $patient, $beginDate, $endDate)
 {
     $riskCatAssessQry = "SELECT count(*) as cnt FROM form_encounter fe " . "INNER JOIN openemr_postcalendar_categories opc ON fe.pc_catid = opc.pc_catid " . "INNER JOIN procedure_order pr ON  fe.encounter = pr.encounter_id " . "INNER JOIN procedure_order_code prc ON pr.procedure_order_id = prc.procedure_order_id " . "WHERE opc.pc_catname = 'Office Visit' " . "AND (fe.date BETWEEN ? AND ?) " . "AND fe.pid = ? " . "AND ( prc.procedure_code = '73830-2' OR prc.procedure_code = '57254-5' ) " . "AND prc.procedure_order_title = 'Risk Category Assessment'";
     $check = sqlQuery($riskCatAssessQry, array($beginDate, $endDate, $patient->id));
     if ($check['cnt'] > 0) {
         return true;
     } else {
         return false;
     }
 }