示例#1
0
$salle = new CSalle();
$where["bloc_id"] = "= '{$bloc_id}'";
$salles = $salle->loadListWithPerms(PERM_READ, $where);
// Récupération des opérations
$ljoin = array();
$ljoin["plagesop"] = "operations.plageop_id = plagesop.plageop_id";
$where = array();
$in_salles = CSQLDataSource::prepareIn(array_keys($salles));
$where[] = "plagesop.salle_id {$in_salles}  OR operations.salle_id {$in_salles}";
$where["materiel"] = "!= ''";
$where[] = " operations.date BETWEEN '{$date_min}' AND '{$date_max}'";
if ($praticien_id) {
    $where["operations.chir_id"] = " = '{$praticien_id}'";
} elseif ($function_id) {
    $mediuser = new CMediusers();
    $users = $mediuser->loadProfessionnelDeSante(PERM_READ, $function_id);
    $where["operations.chir_id"] = CSQLDataSource::prepareIn(array_keys($users));
}
$order = "operations.date, rank";
$operation = new COperation();
$ops = $operation->loadList($where, $order, null, "operation_id", $ljoin);
$operations = array();
$commande = new CCommandeMaterielOp();
foreach ($commande->_specs["etat"]->_list as $spec) {
    $operations[$spec] = array();
}
foreach ($ops as $_op) {
    /** @var COperation $_op */
    $_op->loadRefPatient();
    $_op->loadRefChir()->loadRefFunction();
    $_op->loadRefPlageOp();
示例#2
0
 * @version $Revision: 7320 $
 * @author SARL OpenXtrem
 * @license GNU General Public License, see http://www.gnu.org/licenses/gpl.html
 */
//CCanDo::checkRead();
$choix = CValue::get("choix", "mois");
$filter = new CPlageAstreinte();
$filter->user_id = CValue::get("user_id", CAppUI::$user->_id);
$filter->start = CValue::get("date_debut", CMbDT::date());
// Tableau des jours fériés sur 2 ans, car
// en mode semaine : 31 décembre - 1 janvier
$bank_holidays = array_merge(CMbDate::getHolidays($filter->start), CMbDate::getHolidays(CMbDT::transform("+1 YEAR", $filter->start, "%Y-%m-%d")));
$mediuser = new CMediusers();
switch ($filter->user_id) {
    case '-1':
        $mediusers = $mediuser->loadProfessionnelDeSante();
        $filter->user_id = "";
        break;
    case '-2':
        $mediusers = $mediuser->loadNonProfessionnelDeSante();
        $filter->user_id = "";
        break;
    default:
        $mediusers = $mediuser->loadListFromType();
        break;
}
if (!$filter->start) {
    $filter->start = Date("Y-m-d");
}
// Si la date rentrée par l'utilisateur est un lundi,
// on calcule le dimanche d'avant et on rajoute un jour.