<?php
/**
* $Id$
*
* @package Mediboard
* @subpackage SSR
* @author SARL OpenXtrem <*****@*****.**>
* @license GNU General Public License, see http://www.gnu.org/licenses/gpl.html
* @version $Revision$
*/
CCanDo::checkAdmin();
$type = CValue::get("type", "CEvenementSSR");
$date = CValue::get("date");
$period = CValue::get("period", "month");
$stats = new CMediusersStats($date, $period, "DATE(debut)", 18);
$consult = new CConsultation();
$ds = $consult->_spec->ds;
$group = CGroups::loadCurrent();
$query = new CRequest();
$query->addColumn("COUNT(*) total");
$query->addColumn("therapeute_id", "user_id");
$query->addColumn($stats->sql_date, "refdate");
$query->addWhere("{$stats->sql_date} BETWEEN '{$stats->min_date}' AND '{$stats->max_date}'");
$query->addWhereClause("functions_mediboard.group_id", "= '{$group->_id}'");
$query->addGroup("therapeute_id, refdate");
$query->addOrder("refdate DESC");
$totals = array();
switch ($type) {
case "CEvenementSSR":
$query->addTable("`evenement_ssr`");
<?php
/**
* $Id$
*
* @package Mediboard
* @subpackage Cabinet
* @author SARL OpenXtrem <*****@*****.**>
* @license GNU General Public License, see http://www.gnu.org/licenses/gpl.html
* @version $Revision$
*/
CCanDo::checkAdmin();
$type = CValue::get("type", "RDV");
$date = CValue::get("date");
$period = CValue::get("period", "month");
$stats = new CMediusersStats($date, $period, "date", 18);
$consult = new CConsultation();
$group = CGroups::loadCurrent();
$ds = $consult->_spec->ds;
$query_complement = "1";
if ($type == "consult") {
$query_complement = "consultation.chrono > 32\r\n OR consultation.traitement IS NOT NULL\r\n OR consultation.histoire_maladie IS NOT NULL\r\n OR consultation.conclusion IS NOT NULL\r\n OR consultation.examen IS NOT NULL\r\n ";
}
$query = "SELECT COUNT(*) total, user_id, {$stats->sql_date} AS refdate\r\n FROM `consultation`\r\n LEFT JOIN plageconsult AS plage ON plage.plageconsult_id = consultation.plageconsult_id\r\n LEFT JOIN users_mediboard AS user ON user.user_id = plage.chir_id\r\n LEFT JOIN functions_mediboard AS function ON function.function_id = user.function_id\r\n WHERE {$stats->sql_date} BETWEEN '{$stats->min_date}' AND '{$stats->max_date}'\r\n AND function.group_id = '{$group->_id}'\r\n AND consultation.annule != '1'\r\n AND consultation.patient_id IS NOT NULL\r\n AND consultation.sejour_id IS NULL\r\n AND ({$query_complement})\r\n GROUP BY user_id, refdate\r\n ORDER BY refdate DESC\r\n";
foreach ($result = $ds->loadList($query) as $_row) {
$stats->addTotal($_row["user_id"], $_row["refdate"], $_row["total"]);
}
$stats->display("CMediusersStats-CConsultation-{$type}");
