PHP COperation::countList方法代码示例

$current_group = CGroups::loadCurrent();
// Urgences du jour
$list_urgences = array();
$operation = new COperation();
if ($userSel->_id) {
    $where = array();
    $where["date"] = "= '{$date}'";
    $where["plageop_id"] = "IS NULL";
    $where[] = "chir_id = '{$userSel->_id}' OR anesth_id = '{$userSel->_id}'";
    if (!$canceled) {
        $where["annulee"] = "= '0'";
    }
    /** @var COperation[] $list_urgences */
    $list_urgences = $operation->loadList($where, "annulee, date");
    $where["annulee"] = "= '1'";
    $nb_canceled += $operation->countList($where);
    $sejours = CMbObject::massLoadFwdRef($list_urgences, "sejour_id");
    CMbObject::massLoadFwdRef($sejours, "patient_id");
    CMbObject::massCountBackRefs($list_urgences, 'actes_ccam');
    foreach ($list_urgences as $_urg) {
        $_urg->canDo();
        $_urg->loadRefsFwd();
        $_urg->loadRefCommande();
        $_sejour = $_urg->_ref_sejour;
        $_urg->countDocItems();
        /* Comptage du nombre d'activités CCAM */
        $_urg->_count['codes_ccam'] = 0;
        foreach (CMbArray::pluck($_urg->_ext_codes_ccam, "activites") as $_code) {
            $_urg->_count['codes_ccam'] += count($_code);
        }
        $_sejour->loadRefsFwd();

$day = $date_min;
$dates = array();
$series = array();
$serie = array('data' => array(), 'label' => utf8_encode("Nombre de nuits prévues"));
$today = CMbDT::date();
while ($day <= $date_max) {
    $display = CMbDT::dateToLocale($day);
    // On préfixe d'une étoile si c'est le jour courant
    if ($day == $today) {
        $display = "* " . $display;
    }
    $dates[] = array(count($dates), $display);
    $day_min = CMbDT::date("-{$max_uscpo} DAY", $day);
    $where[10] = "operations.date BETWEEN '{$day_min}' AND '{$day}'";
    $where[11] = "DATE_ADD(operations.date, INTERVAL duree_uscpo DAY) > '{$day}'";
    $count = $operation->countList($where, null, $ljoin);
    $day = CMbDT::date("+1 day", $day);
    $serie['data'][] = array(count($serie['data']) - 0.2, $count);
}
$series[] = $serie;
$day = $date_min;
$serie = array('data' => array(), 'label' => utf8_encode("Nombre de nuits placées"));
$ljoin["affectation"] = "affectation.sejour_id = operations.sejour_id";
while ($day <= $date_max) {
    $day_min = CMbDT::date("-{$max_uscpo} DAY", $day);
    $where[10] = "operations.date BETWEEN '{$day_min}' AND '{$day}'";
    $where[11] = "DATE_ADD(operations.date, INTERVAL duree_uscpo DAY) > '{$day}'";
    $where[12] = "DATE_ADD(operations.date, INTERVAL duree_uscpo DAY) <= affectation.sortie";
    $day = CMbDT::date("+1 day", $day);
    $count = $operation->countList($where, null, $ljoin);
    $serie['data'][] = array(count($serie['data']) + 0.2, intval($count));

            $event = new CPlanningEvent($_conge->_guid . $_date, $_date, 1430, $libelle, "#ddd", true, "hatching", null, false);
            $event->below = 1;
            $planning->addEvent($event);
        }
    }
}
//Operation hors plage
$operation = new COperation();
$where = array();
for ($i = 0; $i < 7; $i++) {
    $date = CMbDT::date("+{$i} day", $debut);
    $where["date"] = "= '{$date}'";
    $where["annulee"] = " = '0'";
    $where["plageop_id"] = " IS NULL";
    $where[] = "chir_id = '{$chirSel}' OR anesth_id = '{$chirSel}'";
    $nb_hors_plages = $operation->countList($where);
    if ($nb_hors_plages) {
        $onclick = "viewList('{$date}', null, 'CPlageOp')";
        $planning->addDayLabel($date, "{$nb_hors_plages} intervention(s) hors-plage", null, "#ffd700", $onclick);
    }
}
/**
 * Ajout d'un évènement à un planning
 *
 * @param CPlanningWeek &$planning planning concerné
 * @param CPlageHoraire $_plage    plage à afficher
 * @param string        $date      date de l'évènement
 * @param string        $libelle   libellé de l'évènement
 * @param string        $color     couleur de l'évènement
 * @param string        $type      type de l'évènement
 * @param string|null   $class     css class to apply

    if ($libelle_intervention) {
        $where_libelle = "`libelle` LIKE '%{$libelle_intervention}%'";
        $where_intervention[] = $where_libelle;
    }
    if ($ccam_intervention) {
        $where_ccam = "`codes_ccam` LIKE '%{$ccam_intervention}%'";
        $where_intervention[] = $where_ccam;
    }
    if ($where_intervention) {
        $where_intervention = implode(" OR ", $where_intervention);
    }
}
$order_intervention = "rques";
$total_intervs = null;
if ($where_intervention) {
    $total_intervs = $intervention->countList($where_intervention);
    $interventions = $intervention->loadlist($where_intervention, $order_intervention, "{$page_interv}, 30");
}
foreach ($interventions as &$intervention) {
    $intervention->loadRefSejour();
    $intervention->_ref_sejour->loadRefPatient();
}
// Création du template
$smarty = new CSmartyDP();
$smarty->assign("dossierMedical", $dossierMedical);
$smarty->assign("canCabinet", $canCabinet);
$smarty->assign("canPlanningOp", $canPlanningOp);
$smarty->assign("sejours", $sejours);
$smarty->assign("page_sejour", $page_sejour);
$smarty->assign("total_sejours", $total_sejours);
$smarty->assign("interventions", $interventions);

}
$listPlages = array();
$operation = new COperation();
$nbIntervHorsPlage = 0;
$listPlage = new CPlageOp();
$nbIntervNonPlacees = 0;
// Nombre d'interventions hors plage pour la semaine
$ljoin = array();
$ljoin["sejour"] = "sejour.sejour_id = operations.sejour_id";
$where = array();
$where["date"] = "BETWEEN '{$debut}' AND '{$fin}'";
$where["plageop_id"] = "IS NULL";
$where["annulee"] = "= '0'";
$where[] = "salle_id IS NULL OR salle_id " . CSQLDataSource::prepareIn(array_keys($listSalles));
$where["sejour.group_id"] = "= '" . CGroups::loadCurrent()->_id . "'";
$nbIntervHorsPlage = $operation->countList($where, null, $ljoin);
foreach ($listDays as $keyDate => $valDate) {
    // Récupération des plages par jour
    $where = array();
    $where["date"] = "= '{$keyDate}'";
    $where["salle_id"] = CSQLDataSource::prepareIn(array_keys($listSalles));
    $order = "debut";
    $listPlages[$keyDate] = $listPlage->loadList($where, $order);
    // Récupération des interventions hors plages du jour
    $where = array();
    $where["date"] = "= '{$keyDate}'";
    $where["annulee"] = "= '0'";
    $where["plageop_id"] = "IS NULL";
    $where["salle_id"] = CSQLDataSource::prepareIn(array_keys($listSalles));
    $order = "time_operation";
    $horsPlages = $operation->loadList($where, $order);

<?php

/**
 * $Id$
 *
 * @package    Mediboard
 * @subpackage PlanningOp
 * @author     SARL OpenXtrem <dev@openxtrem.com>
 * @license    GNU General Public License, see http://www.gnu.org/licenses/gpl.html
 * @version    $Revision$
 */
CCanDo::checkAdmin();
$operation = new COperation();
// Nombre d'interventions...
$counts["total"] = $operation->countList();
// Dans une plage...
$where["operations.plageop_id"] = "IS NOT NULL";
$counts["plaged"] = $operation->countList($where);
// Sans date!
$where["operations.date"] = "IS NULL";
$counts["missing"] = $operation->countList($where);
// Avec une date erronée!
$ljoin["plagesop"] = "plagesop.plageop_id = operations.plageop_id";
$where["operations.date"] = "IS NOT NULL";
$where[] = "plagesop.date != operations.date";
$counts["wrong"] = $operation->countList($where, null, $ljoin);
foreach ($operation->loadList($where, null, null, null, $ljoin) as $_operation) {
    mbTrace($_operation->_guid, $_operation->plageop_id);
}
// Création du template
$smarty = new CSmartyDP();

$ds = CSQLDataSource::get("std");
$view = CValue::get("view", 1);
$date = CMbDT::date();
$request = "SELECT `operations`.*\r\n            FROM `operations`\r\n            LEFT JOIN `plagesop` ON `operations`.`plageop_id` = `plagesop`.`plageop_id`\r\n            WHERE `operations`.`ASA` = '1'\r\n            AND (`plagesop`.`date` >= '" . $date . "'\r\n            OR `operations`.`date` >= '" . $date . "')\r\n            AND NOT EXISTS (\r\n              SELECT * FROM `consultation_anesth`\r\n              WHERE `consultation_anesth`.`operation_id` = `operations`.`operation_id`\r\n            );";
$resultats = $ds->loadList($request);
if ($view == false) {
    $request = "UPDATE `operations`\r\n            LEFT JOIN `plagesop` ON `operations`.`plageop_id` = `plagesop`.`plageop_id`\r\n            SET `operations`.`ASA` = NULL\r\n            WHERE `operations`.`ASA` = '1'\r\n            AND (`plagesop`.`date` >= '" . $date . "'\r\n            OR `operations`.`date` >= '" . $date . "')\r\n            AND NOT EXISTS (\r\n              SELECT * FROM `consultation_anesth`\r\n              WHERE `consultation_anesth`.`operation_id` = `operations`.`operation_id`\r\n            );";
    $ds->query($request);
    $result = $ds->affectedRows();
    CAppUI::stepAjax(count($resultats) . " intervention(s) modifiée(s)", UI_MSG_OK);
} else {
    $where = array();
    $where["operation_id"] = CSQLDataSource::prepareIn(CMbArray::pluck($resultats, "operation_id"));
    /* @var COperation[] $operations*/
    $operation = new COperation();
    $nb_operations = $operation->countList($where);
    $operations = $operation->loadList($where, null, "100");
    $sejours = CMbObject::massLoadFwdRef($operations, "sejour_id");
    CMbObject::massLoadFwdRef($sejours, "patient_id");
    CMbObject::massLoadFwdRef($operations, "plageop_id");
    CMbObject::massLoadFwdRef($operations, "chir_id");
    foreach ($operations as $op) {
        $op->loadRefPraticien();
        $op->loadRelPatient();
        $op->loadRefPlageOp();
    }
    // Creation du template
    $smarty = new CSmartyDP();
    $smarty->assign("operations", $operations);
    $smarty->assign("nb_operations", $nb_operations);
    $smarty->display("check_score_asa.tpl");

 /**
  * count list of Op not linked to a plage
  *
  * @param date      $start    date de début
  * @param date|null $end      date de fin
  * @param array     $chir_ids chir targeted
  *
  * @return int number of HP found
  */
 static function countForDates($start, $end = null, $chir_ids = array())
 {
     $d_start = $start;
     $d_end = $end ? $end : $start;
     $op = new COperation();
     $ljoin = array();
     $ljoin["sejour"] = "sejour.sejour_id = operations.sejour_id";
     $where = array();
     if (count($chir_ids)) {
         $where["chir_id"] = CSQLDataSource::prepareIn($chir_ids);
     }
     $where["operations.plageop_id"] = "IS NULL";
     $where["operations.date"] = "BETWEEN '{$d_start}' AND '{$d_end}'";
     $where["operations.annulee"] = "= '0'";
     $where["sejour.group_id"] = "= '" . CGroups::loadCurrent()->_id . "'";
     /** @var COperation[] $listHorsPlage */
     return $op->countList($where, null, $ljoin);
 }

    // Chargment du numéro de dossier
    $_sejour->loadNDA();
    $whereOperations = array("annulee" => "= '0'");
    // Chargement de l'affectation
    $_sejour->loadRefsAffectations();
    $affectation =& $_sejour->_ref_first_affectation;
    if ($affectation->_id) {
        $affectation->loadRefLit(1);
        $affectation->_ref_lit->loadCompleteView();
    }
    // Pour l'envoi de mail, afficher une enveloppe pour les interventions modifiées par le chirurgien
    if ($envoi_mail) {
        $where = array("sejour.sejour_id" => "= '{$_sejour->_id}'", "user_log.user_id" => "= operations.chir_id");
        $ljoin = array("sejour" => "sejour.sejour_id = operations.sejour_id", "user_log" => "user_log.object_id = operations.operation_id AND user_log.object_class = 'COperation'");
        // @todo déclaration de la variable à réaliser
        $_sejour->_envoi_mail = $operation->countList($where, null, $ljoin);
    }
}
// Si la fonction selectionnée n'est pas dans la liste des fonction, on la rajoute
if ($filterFunction && !array_key_exists($filterFunction, $functions)) {
    $_function = new CFunctions();
    $_function->load($filterFunction);
    $functions[$filterFunction] = $_function;
}
$m = $save_m;
// Création du template
$smarty = new CSmartyDP();
$smarty->assign("current_m", $current_m);
$smarty->assign("hier", $hier);
$smarty->assign("demain", $demain);
$smarty->assign("date_min", $date_min);

 /**
  * Count operations that have not been mined yet
  *
  * @return int
  */
 function countUnmined()
 {
     $date = CMbDT::date(self::$mine_delay);
     $operation = new COperation();
     $table = $this->_spec->table;
     $ljoin[$table] = "{$table}.operation_id = operations.operation_id";
     $where["{$table}.operation_id"] = "IS NULL";
     $where[] = "operations.date < '{$date}'";
     return $this->_count_unmined = $operation->countList($where, null, $ljoin);
 }

$listSalles = new CSalle();
$listSalles = $listSalles->loadGroupList();
$plage = new CPlageOp();
$where = array();
$where["date"] = "= '{$date}'";
$where["salle_id"] = CSQLDataSource::prepareIn(array_keys($listSalles));
$order = "debut";
$step = 30;
$limit = "{$page},{$step}";
/** @var CPlageOp[] $plages */
$plages = $plage->loadList($where, $order);
$operation = new COperation();
$where = array();
$where["plageop_id"] = CSQLDataSource::prepareIn(array_keys($plages));
$where["annulee"] = "= '0'";
$count = $operation->countList($where);
$operations = $operation->loadList($where, null, $limit);
/** @var CSejour[] $sejours */
$sejours = COperation::massLoadFwdRef($operations, "sejour_id");
/** @var CPatient[] $patients */
$patients = CSejour::massLoadFwdRef($sejours, "patient_id");
CSejour::massLoadNDA($sejours);
CPatient::massLoadIPP($patients);
CSejour::massCountDocItems($sejours);
COperation::massCountDocItems($operations);
$chirurgiens = COperation::massLoadFwdRef($operations, "chir_id");
CMediusers::massLoadFwdRef($chirurgiens, "function_id");
/** @var COperation[] $operations */
foreach ($operations as $_operation) {
    // Détails de l'opérations
    $_operation->loadRefChir()->loadRefFunction();