You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
95 lines
2.9 KiB
95 lines
2.9 KiB
2 years ago
|
<?php
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Holds functions for the calendar, one is for holidays
|
||
|
|
* @package OpenEMR
|
||
|
|
* @link https://www.open-emr.org
|
||
|
|
* @author Brady Miller <brady.g.miller@gmail.com>
|
||
|
|
* @copyright Copyright (c) 2005 Brady Miller <brady.g.miller@gmail.com>
|
||
|
|
* @license https://github.com/openemr/openemr/blob/master/LICENSE GNU General Public License 3
|
||
|
|
*/
|
||
|
|
|
||
|
|
//Require once the holidays controller for the is_holiday() function
|
||
|
|
require_once($GLOBALS['incdir'] . "/main/holidays/Holidays_Controller.php");
|
||
|
|
|
||
|
|
// Returns an array of the facility ids and names that the user is allowed to access.
|
||
|
|
// Access might be for inventory purposes ($inventory=true) or calendar purposes.
|
||
|
|
//
|
||
|
|
function getUserFacilities($uID, $orderby = 'id', $inventory = false)
|
||
|
|
{
|
||
|
|
$restrict = $inventory ? $GLOBALS['gbl_fac_warehouse_restrictions'] : $GLOBALS['restrict_user_facility'];
|
||
|
|
if ($restrict) {
|
||
|
|
// No entries in this table means the user is not restricted.
|
||
|
|
$countrow = sqlQuery(
|
||
|
|
"SELECT count(*) AS count FROM users_facility WHERE " .
|
||
|
|
"tablename = 'users' AND table_id = ?",
|
||
|
|
array($uID)
|
||
|
|
);
|
||
|
|
}
|
||
|
|
if (!$restrict || empty($countrow['count'])) {
|
||
|
|
$rez = sqlStatement(
|
||
|
|
"SELECT id, name, color FROM facility " .
|
||
|
|
"ORDER BY $orderby"
|
||
|
|
);
|
||
|
|
} else {
|
||
|
|
// This query gets facilities that the user is authorized to access.
|
||
|
|
$rez = sqlStatement(
|
||
|
|
"SELECT f.id, f.name, f.color " .
|
||
|
|
"FROM facility AS f " .
|
||
|
|
"JOIN users AS u ON u.id = ? " .
|
||
|
|
"WHERE f.id = u.facility_id OR f.id IN " .
|
||
|
|
"(SELECT DISTINCT uf.facility_id FROM users_facility AS uf WHERE uf.tablename = 'users' AND uf.table_id = u.id) " .
|
||
|
|
"ORDER BY f.$orderby",
|
||
|
|
array($uID)
|
||
|
|
);
|
||
|
|
}
|
||
|
|
$returnVal = array();
|
||
|
|
while ($row = sqlFetchArray($rez)) {
|
||
|
|
$returnVal[] = $row;
|
||
|
|
}
|
||
|
|
return $returnVal;
|
||
|
|
}
|
||
|
|
|
||
|
|
// Returns an array of warehouse IDs for the given user and facility.
|
||
|
|
function getUserFacWH($uID, $fID)
|
||
|
|
{
|
||
|
|
$res = sqlStatement(
|
||
|
|
"SELECT warehouse_id FROM users_facility WHERE tablename = ? " .
|
||
|
|
"AND table_id = ? AND facility_id = ?",
|
||
|
|
array('users', $uID, $fID)
|
||
|
|
);
|
||
|
|
$returnVal = array();
|
||
|
|
while ($row = sqlFetchArray($res)) {
|
||
|
|
if ($row['warehouse_id'] === '') {
|
||
|
|
continue;
|
||
|
|
}
|
||
|
|
$returnVal[] = $row['warehouse_id'];
|
||
|
|
}
|
||
|
|
return $returnVal;
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Check if day is weekend day
|
||
|
|
* @param (int) $day
|
||
|
|
* @return boolean
|
||
|
|
*/
|
||
|
|
function is_weekend_day($day)
|
||
|
|
{
|
||
|
|
|
||
|
|
if (in_array($day, $GLOBALS['weekend_days'])) {
|
||
|
|
return true;
|
||
|
|
} else {
|
||
|
|
return false;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* This function checks if a certain date (YYYY/MM/DD) is a marked as a holiday/closed event in the events table
|
||
|
|
* @param (int) $day
|
||
|
|
* @return boolean
|
||
|
|
*/
|
||
|
|
function is_holiday($date)
|
||
|
|
{
|
||
|
|
Holidays_Controller::is_holiday($date);
|
||
|
|
}
|