/**
  * @see parent::updateFormFields()
  */
 function updateFormFields()
 {
     parent::updateFormFields();
     if ($this->end_datetime && $this->start_datetime) {
         $this->_duration = CMbDT::timeRelative($this->start_datetime, $this->end_datetime);
     }
 }

/**
 * $Id: inc_personnel.php 20938 2013-11-13 11:02:47Z aurelie17 $
 *
 * @package    Mediboard
 * @subpackage bloodSalvage
 * @author     SARL OpenXtrem <[email protected]>
 * @license    GNU General Public License, see http://www.gnu.org/licenses/gpl.html
 * @version    $Revision: 20938 $
 */
function loadAffected(&$blood_salvage_id, &$list_nurse_sspi, &$tabAffected, &$timingAffect)
{
    $affectation = new CAffectationPersonnel();
    $affectation->object_class = "CBloodSalvage";
    $affectation->object_id = $blood_salvage_id;
    $tabAffected = $affectation->loadMatchingList();
    foreach ($tabAffected as $key => $affect) {
        if (array_key_exists($affect->personnel_id, $list_nurse_sspi)) {
            unset($list_nurse_sspi[$affect->personnel_id]);
        }
        $affect->_ref_personnel->loadRefUser();
    }
    // Initialisations des tableaux des timings
    foreach ($tabAffected as $key => $affectation) {
        $timingAffect[$affectation->_id]["_debut"] = array();
        $timingAffect[$affectation->_id]["_fin"] = array();
    }
    // Remplissage des tableaux des timings
    foreach ($tabAffected as $id => $affectation) {
        foreach ($timingAffect[$affectation->_id] as $key => $value) {
            for ($i = -10; $i < 10 && $affectation->{$key} !== null; $i++) {
                $timingAffect[$affectation->_id][$key][] = CMbDT::time("{$i} minutes", $affectation->{$key});
            }
        }
    }
}

 /**
  * @see parent::build
  */
 function build(CHPREvent $event)
 {
     parent::build($event);
     $message = $event->message;
     $data = array();
     // H-1 : Field Separator
     $data[] = $message->fieldSeparator;
     // H-2: Encoding Characters (ST)
     $data[] = substr($message->getEncodingCharacters(), 1);
     // H-3 : Message ID
     $data[] = $event->_exchange_hpr->_id;
     // H-4 : Password
     $data[] = null;
     // H-5 : Sender ID
     $data[] = $event->_sender->nom;
     // H-6 : Sender address
     $data[] = null;
     // H-7 : Context
     $data[] = $event->event_type;
     // H-8 : Sender phone
     $data[] = null;
     // H-9 : Transmission characteristics
     $data[] = null;
     // H-10 : Receiver ID
     $data[] = array($event->_receiver->_id, $event->_receiver->nom);
     // H-11 : Comment
     $data[] = null;
     // H-12 : Processing ID
     $data[] = null;
     // H-13 : Version and Type
     $data[] = array(array($event->version, $event->_exchange_hpr->type));
     // H-14 : Date/Time of Message
     $data[] = CMbDT::dateTime();
     $this->fill($data);
 }

 protected function updateDateCodage()
 {
     $ds = $this->ds;
     $query = "SELECT * FROM `codage_ccam`;";
     $rows = $ds->exec($query);
     while ($_codage = $ds->fetchObject($rows, 'CCodageCCAM')) {
         $_codage->loadCodable();
         $date = null;
         switch ($_codage->codable_class) {
             case 'CConsultation':
                 $_codage->_ref_codable->loadRefPlageConsult();
                 $date = $_codage->_ref_codable->_date;
                 break;
             case 'COperation':
                 $date = $_codage->_ref_codable->date;
                 break;
             case 'CSejour':
                 $date = CMbDT::date('', $_codage->_ref_codable->entree);
                 break;
         }
         $query = "UPDATE `codage_ccam`\r\n                  SET `date` = '{$date}' WHERE `codage_ccam_id` = {$_codage->_id};";
         $ds->exec($query);
     }
     return true;
 }

 /**
  * @see parent::checkProperty()
  */
 function checkProperty($object)
 {
     $propValue =& $object->{$this->fieldName};
     $time_format = "/^\\d{1,2}:\\d{1,2}(:\\d{1,2})?\$/";
     // Format
     if (!preg_match($time_format, $propValue)) {
         if ($propValue === 'current' || $propValue === 'now') {
             $propValue = CMbDT::time();
             return null;
         }
         return "Format d'heure invalide";
     }
     // min
     if ($this->min) {
         if (!preg_match($time_format, $this->min)) {
             trigger_error("Spécification de minimum time invalide (min = {$this->min})", E_USER_WARNING);
             return "Erreur système";
         }
         if ($propValue < $this->min) {
             return "Doit avoir une valeur minimale de {$this->min}";
         }
     }
     // max
     if ($this->max) {
         if (!preg_match($time_format, $this->max)) {
             trigger_error("Spécification de maximum time invalide (max = {$this->max})", E_USER_WARNING);
             return "Erreur système";
         }
         if ($propValue > $this->max) {
             return "Doit avoir une valeur maximale de {$this->max}";
         }
     }
     return null;
 }

 /**
  * @see parent::store()
  */
 function store()
 {
     if ($this->fieldModified("content") || !$this->last_modified) {
         $this->last_modified = CMbDT::dateTime();
     }
     return parent::store();
 }

 /**
  * @see parent::store()
  */
 function store()
 {
     $this->completeField("handled");
     if (!$this->creation_date) {
         $this->creation_date = CMbDT::dateTime();
         if ($this->_id) {
             $this->creation_date = $this->loadFirstLog()->date;
         }
     }
     if ($this->fieldModified("handled", "1") || $this->handled && !$this->handled_date && !$this->handled_user_id) {
         $this->handled_date = CMbDT::dateTime();
         $this->handled_user_id = CMediusers::get()->_id;
         if ($this->handled) {
             $last_log = $this->loadLastLog();
             $this->handled_date = $last_log->date;
             $this->handled_user_id = $last_log->user_id;
         }
     }
     if ($this->fieldModified("handled", "0")) {
         $this->handled_date = $this->handled_user_id = "";
     }
     if ($msg = parent::store()) {
         return $msg;
     }
 }

 /**
  * Build EVN segement
  *
  * @param CHL7v2Event $event Event
  *
  * @return null
  */
 function build(CHL7v2Event $event)
 {
     parent::build($event);
     $version = $event->message->version;
     $data = array();
     // EVN-1: Event Type Code (ID) (optional)
     // This field has been retained for backward compatibility only
     $data[] = $version < "2.5" ? $event->code : null;
     // EVN-2: Recorded Date/Time (TS)
     $data[] = CMbDT::dateTime();
     // EVN-3: Date/Time Planned Event (TS)(optional)
     $data[] = $this->planned_datetime;
     // EVN-4: Event Reason Code (IS) (optional)
     // Table 062
     // 01 - Patient request
     // 02 - Physician/health practitioner order
     // 03 - Census management
     // O  - Other
     // U  - Unknown
     $data[] = null;
     // EVN-5: Operator ID (XCN) (optional repeating)
     //$data[] = $this->getXCN($event->last_log->loadRefUser());
     $data[] = null;
     // EVN-6: Event Occurred (TS) (optional)
     $data[] = $this->occured_datetime;
     // EVN-7: Event Facility (HD) (optional)
     $data[] = null;
     $this->fill($data);
 }

 /**
  * Menu upgrade
  *
  * @return bool
  */
 protected function fixRepet()
 {
     $ds = $this->ds;
     $query = "SELECT * FROM menu";
     $menus = $ds->loadList($query);
     foreach ($menus as $menu) {
         $nbDays = CMbDT::daysRelative($menu["debut"], $menu["fin"]);
         $nbWeeks = floor($nbDays / 7);
         if (!$nbWeeks) {
             $menu["nb_repet"] = 1;
         } else {
             $menu["nb_repet"] = ceil($nbWeeks / $menu["repetition"]);
         }
         $query = "UPDATE `menu` SET `nb_repet` = '" . $menu["nb_repet"] . "' WHERE(`menu_id`='" . $menu["menu_id"] . "');";
         $ds->exec($query);
         $ds->error();
         $query = "UPDATE `repas` SET `typerepas_id`='" . $menu["typerepas"] . "' WHERE(`menu_id`='" . $menu["menu_id"] . "');";
         $ds->exec($query);
         $ds->error();
     }
     $query = "ALTER TABLE `menu` DROP `fin`;";
     $ds->exec($query);
     $ds->error();
     return true;
 }

 /**
  * Loads messages from a publication date perspective
  *
  * @param string $status   Wanted status, null for all
  * @param string $mod_name Module name restriction, null for all
  * @param int    $group_id Group ID
  *
  * @return self[] Published messages
  */
 function loadPublications($status = null, $mod_name = null, $group_id = null)
 {
     $now = CMbDT::dateTime();
     $where = array();
     switch ($status) {
         case "past":
             $where["fin"] = "< '{$now}'";
             break;
         case "present":
             $where["deb"] = "< '{$now}'";
             $where["fin"] = "> '{$now}'";
             break;
         case "future":
             $where["deb"] = "> '{$now}'";
             break;
     }
     if ($group_id) {
         $where[] = "group_id = '{$group_id}' OR group_id IS NULL";
     }
     /** @var self[] $messages */
     $messages = $this->loadList($where, "deb DESC");
     // Module name restriction
     if ($mod_name) {
         foreach ($messages as $message_id => $_message) {
             if ($_message->module_id) {
                 if ($_message->loadRefModuleObject()->mod_name != $mod_name) {
                     unset($messages[$message_id]);
                 }
             }
         }
     }
     return $messages;
 }

 static function mine($parent_class)
 {
     $classes = CApp::getChildClasses($parent_class);
     $limit = CAppUI::conf("dataminer_limit");
     foreach ($classes as $_class) {
         $miner = new $_class();
         $report = $miner->mineSome($limit, "mine");
         $dt = CMbDT::dateTime();
         echo "<{$dt}> Miner: {$_class}. Success mining count is '" . $report["success"] . "'\n";
         if (!$report["failure"]) {
             echo "<{$dt}> Miner: {$_class}. Failure mining counts is '" . $report["failure"] . "'\n";
         }
         $miner = new $_class();
         $report = $miner->mineSome($limit, "remine");
         $dt = CMbDT::dateTime();
         echo "<{$dt}> Reminer: {$_class}. Success remining count is '" . $report["success"] . "'\n";
         if (!$report["failure"]) {
             echo "<{$dt}> Reminer: {$_class}. Failure remining counts is '" . $report["failure"] . "'\n";
         }
         $miner = new $_class();
         $report = $miner->mineSome($limit, "postmine");
         $dt = CMbDT::dateTime();
         echo "<{$dt}> Postminer: {$_class}. Success postmining count is '" . $report["success"] . "'\n";
         if (!$report["failure"]) {
             echo "<{$dt}> Postminer: {$_class}. Failure postmining counts is '" . $report["failure"] . "'\n";
         }
     }
 }

 /**
  * Magic method (do not call directly)
  *
  * @param string $name method name
  * @param array  $args arguments
  *
  * @return mixed
  *
  * @throws Exception
  * @throws CMbException
  */
 function __call($name, $args)
 {
     $name = strtolower($name);
     $silent = strncmp($name, 'try', 3) === 0;
     $function_name = $silent ? substr($name, 3) : $name;
     $function_name = '_' . (isset(self::$aliases[$function_name]) ? self::$aliases[$function_name] : $function_name);
     if (!method_exists($this, $function_name)) {
         throw new CMbException("CSourceSFTP-call-undefined-method", $name);
     }
     if ($function_name == "_init") {
         return call_user_func_array(array($this, $function_name), $args);
     }
     if (!$this->loggable) {
         try {
             return call_user_func_array(array($this, $function_name), $args);
         } catch (CMbException $fault) {
             throw $fault;
         }
     }
     $echange_ftp = new CExchangeFTP();
     $echange_ftp->date_echange = CMbDT::dateTime();
     $echange_ftp->emetteur = CAppUI::conf("mb_id");
     $echange_ftp->destinataire = $this->hostname;
     $echange_ftp->function_name = $name;
     CApp::$chrono->stop();
     $chrono = new Chronometer();
     $chrono->start();
     $output = null;
     try {
         $output = call_user_func_array(array($this, $function_name), $args);
     } catch (CMbException $fault) {
         $echange_ftp->date_echange = CMbDT::dateTime();
         $echange_ftp->output = $fault->getMessage();
         $echange_ftp->ftp_fault = 1;
         $echange_ftp->store();
         CApp::$chrono->start();
         throw $fault;
     }
     $chrono->stop();
     CApp::$chrono->start();
     // response time
     $echange_ftp->response_time = $chrono->total;
     // Truncate input and output before storing
     $args = array_map_recursive(array("CFTP", "truncate"), $args);
     $echange_ftp->input = serialize($args);
     if ($echange_ftp->ftp_fault != 1) {
         if ($function_name == "_getlistfiles") {
             // Truncate le tableau des fichiers reçus dans le cas où c'est > 100
             $array_count = count($output);
             if ($array_count > 100) {
                 $output = array_slice($output, 0, 100);
                 $output["count"] = "{$array_count} files";
             }
         }
         $echange_ftp->output = serialize(array_map_recursive(array("CSFTP", "truncate"), $output));
     }
     $echange_ftp->store();
     return $output;
 }

 /**
  * @see parent::updateFormFields()
  */
 function updateFormFields()
 {
     parent::updateFormFields();
     $this->_view = "Allaitement du " . CMbDT::transform($this->date_debut, null, CAppUI::conf("date")) . " à " . CMbDT::transform($this->date_debut, null, CAppUI::conf("time"));
     if ($this->date_fin) {
         $this->_view .= " au " . CMbDT::transform($this->date_fin, null, CAppUI::conf("date")) . " à " . CMbDT::transform($this->date_fin, null, CAppUI::conf("time"));
     }
 }

 /**
  * @see parent::updateFormFields()
  */
 function updateFormFields()
 {
     parent::updateFormFields();
     $this->_view = "Indisponibilité du " . CMbDT::dateToLocale($this->deb);
     if ($this->deb != $this->fin) {
         $this->_view .= " au " . CMbDT::dateToLocale($this->fin);
     }
 }

/**
 * Récupération des statistiques du nombre de consultations par mois
 * selon plusieurs filtres
 *
 * @param string $debut   Date de début
 * @param string $fin     Date de fin
 * @param int    $prat_id Identifiant du praticien
 *
 * @return array
 */
function graphConsultations($debut = null, $fin = null, $prat_id = 0)
{
    if (!$debut) {
        $debut = CMbDT::date("-1 YEAR");
    }
    if (!$fin) {
        $fin = CMbDT::date();
    }
    $rectif = CMbDT::transform("+0 DAY", $debut, "%d") - 1;
    $debutact = CMbDT::date("-{$rectif} DAYS", $debut);
    $rectif = CMbDT::transform("+0 DAY", $fin, "%d") - 1;
    $finact = CMbDT::date("-{$rectif} DAYS", $fin);
    $finact = CMbDT::date("+ 1 MONTH", $finact);
    $finact = CMbDT::date("-1 DAY", $finact);
    $pratSel = new CMediusers();
    $pratSel->load($prat_id);
    $ticks = array();
    $serie_total = array('label' => 'Total', 'data' => array(), 'markers' => array('show' => true), 'bars' => array('show' => false));
    for ($i = $debut; $i <= $fin; $i = CMbDT::date("+1 MONTH", $i)) {
        $ticks[] = array(count($ticks), CMbDT::transform("+0 DAY", $i, "%m/%Y"));
        $serie_total['data'][] = array(count($serie_total['data']), 0);
    }
    $ds = CSQLDataSource::get("std");
    $total = 0;
    $series = array();
    $query = "SELECT COUNT(consultation.consultation_id) AS total,\r\n    DATE_FORMAT(plageconsult.date, '%m/%Y') AS mois,\r\n    DATE_FORMAT(plageconsult.date, '%Y%m') AS orderitem\r\n    FROM consultation\r\n    INNER JOIN plageconsult\r\n    ON consultation.plageconsult_id = plageconsult.plageconsult_id\r\n    INNER JOIN users_mediboard\r\n    ON plageconsult.chir_id = users_mediboard.user_id\r\n    WHERE plageconsult.date BETWEEN '{$debutact}' AND '{$finact}'\r\n    AND consultation.annule = '0'";
    if ($prat_id) {
        $query .= "\nAND plageconsult.chir_id = '{$prat_id}'";
    }
    $query .= "\nGROUP BY mois ORDER BY orderitem";
    $serie = array('data' => array());
    $result = $ds->loadlist($query);
    foreach ($ticks as $i => $tick) {
        $f = true;
        foreach ($result as $r) {
            if ($tick[1] == $r["mois"]) {
                $serie["data"][] = array($i, $r["total"]);
                $serie_total["data"][$i][1] += $r["total"];
                $total += $r["total"];
                $f = false;
                break;
            }
        }
        if ($f) {
            $serie["data"][] = array(count($serie["data"]), 0);
        }
    }
    $series[] = $serie;
    // Set up the title for the graph
    $title = "Nombre de consultations";
    $subtitle = "- {$total} consultations -";
    if ($prat_id) {
        $subtitle .= " Dr {$pratSel->_view} -";
    }
    $options = CFlotrGraph::merge("bars", array('title' => utf8_encode($title), 'subtitle' => utf8_encode($subtitle), 'xaxis' => array('ticks' => $ticks), 'bars' => array('stacked' => true, 'barWidth' => 0.8)));
    return array('series' => $series, 'options' => $options);
}

 /**
  * Get a unique order number
  *
  * @return string
  */
 private function getUniqueNumber()
 {
     $format = CAppUI::conf('dPstock CProductOrder order_number_format');
     if (strpos($format, '%id') === false) {
         $format .= '%id';
     }
     $format = str_replace('%id', str_pad($this->_id ? $this->_id : 0, 4, '0', STR_PAD_LEFT), $format);
     return CMbDT::format(null, $format);
 }

 /**
  * @see parent::store()
  */
 function store()
 {
     if (!$this->creation_datetime) {
         $this->creation_datetime = CMbDT::dateTime();
     }
     if ($msg = parent::store()) {
         return $msg;
     }
 }

 /**
  * @see parent::doStore()
  */
 function doStore()
 {
     if (isset($_FILES['attachment'])) {
         $mail_id = CValue::post('mail_id');
         $mail = new CUserMail();
         $mail->load($mail_id);
         $files = array();
         foreach ($_FILES['attachment']['error'] as $key => $file_error) {
             if (isset($_FILES['attachment']['name'][$key])) {
                 $files[] = array('name' => $_FILES['attachment']['name'][$key], 'tmp_name' => $_FILES['attachment']['tmp_name'][$key], 'error' => $_FILES['attachment']['error'][$key], 'size' => $_FILES['attachment']['size'][$key]);
             }
         }
         foreach ($files as $_key => $_file) {
             if ($_file['error'] == UPLOAD_ERR_NO_FILE) {
                 continue;
             }
             if ($_file['error'] != 0) {
                 CAppUI::setMsg(CAppUI::tr("CFile-msg-upload-error-" . $_file["error"]), UI_MSG_ERROR);
                 continue;
             }
             $attachment = new CMailAttachments();
             $attachment->name = $_file['name'];
             $content_type = mime_content_type($_file['tmp_name']);
             $attachment->type = $attachment->getTypeInt($content_type);
             $attachment->bytes = $_file['size'];
             $attachment->mail_id = $mail_id;
             $content_type = explode('/', $content_type);
             $attachment->subtype = strtoupper($content_type[1]);
             $attachment->disposition = 'ATTACHMENT';
             $attachment->extension = substr(strrchr($attachment->name, '.'), 1);
             $attachment->part = $mail->countBackRefs('mail_attachments') + 1;
             $attachment->store();
             $file = new CFile();
             $file->setObject($attachment);
             $file->author_id = CAppUI::$user->_id;
             $file->file_name = $attachment->name;
             $file->file_date = CMbDT::dateTime();
             $file->fillFields();
             $file->updateFormFields();
             $file->doc_size = $attachment->bytes;
             $file->file_type = mime_content_type($_file['tmp_name']);
             $file->moveFile($_file, true);
             if ($msg = $file->store()) {
                 CAppUI::setMsg(CAppUI::tr('CMailAttachments-error-upload-file') . ':' . CAppUI::tr($msg), UI_MSG_ERROR);
                 CApp::rip();
             }
             $attachment->file_id = $file->_id;
             if ($msg = $attachment->store()) {
                 CAppUI::setMsg($msg, UI_MSG_ERROR);
                 CApp::rip();
             }
         }
         CAppUI::setMsg('CMailAttachments-msg-added', UI_MSG_OK);
     } else {
         parent::doStore();
     }
 }

 /**
  * History constructor
  *
  * @param string    $m          Module
  * @param string    $action     Action
  * @param string    $actionType Action type
  * @param CMbObject $object     Object
  * @param array     $params     Parameters
  * @param string    $type       Type of view
  */
 protected function __construct($m, $action, $actionType, CMbObject $object, $params, $type)
 {
     $this->datetime = CMbDT::dateTime();
     $this->m = $m;
     $this->action = $action;
     $this->actionType = $actionType;
     $this->params = $params;
     $this->type = $type;
     $this->object_guid = $object->_guid;
     $this->object = $object;
 }

 /**
  * check if $this is an older rule
  *
  * @return bool
  */
 function checkOlder()
 {
     $now = CMbDT::dateTime();
     if ($this->date_min && $now < $this->date_min) {
         return $this->_inactive = true;
     }
     if ($this->date_max && $now > $this->date_max) {
         return $this->_inactive = true;
     }
     return $this->_inactive = false;
 }