<?php

include_once __DIR__ . "/../../../autoload/My_Model.php";
include_once __DIR__ . "/../factories/HistoryFactory.php";

class HistoryModel extends My_Model {

    /**
     * @var string
     */
    public $table = 'sys_items';

    /**
     * @param array $data
     * @return bool|ORM
     */
    public function createHistory($data) {
        $procedure = self::create();
        HistoryFactory::create($data, $procedure, true);
        $procedure->save();

        return $procedure;
    }

    public function updateHistoryDiary($data, $procedureId) {
        try {
            //remove todoso os registros, antes de reinserir
            ORM::for_table('module_med_procedure_diary')->where('sys_item_id', $procedureId)->delete_many();
            if (isset($data['diary'])) {

                for ($i = 0; $i < count($data['diary']); $i++) {
                    $d = ORM::for_table('module_med_procedure_diary')->create();
                    $d->module_med_diary = $data['diary'][$i];
                    $d->sys_item_id = $procedureId;
                    $d->save();
                }
            }
            return true;
        } catch (Exception $e) {
            die($e);
            return false;
        }
    }

    public function updateHistorysAgreement($data, $procedureId, $agreement) {
        try {
            //remove todoso os registros, antes de reinserir
            ORM::for_table('module_med_procedure_agreement')->where('sys_item_id', $procedureId)->delete_many();
            foreach ($agreement as $doc) {
                if (isset($data['agreement_' . $doc->id]) && $data['agreement_' . $doc->id] == 'Y') {
                    $d = ORM::for_table('module_med_procedure_agreement')->create();
                    $d->module_med_agreement_id = $doc->id;
                    $d->sys_item_id = $procedureId;
                    $d->patient_value = Finance::amount_fix($data['patient_value_' . $doc->id]);
                    $d->agreement_value = Finance::amount_fix($data['agreement_value_' . $doc->id]);
                    $d->code_table = Finance::amount_fix($data['code_table_' . $doc->id]);
                    $d->save();
                }
            }
            return true;
        } catch (Exception $e) {
            die($e);
            return false;
        }
    }


    /**
     * @param array $data
     * @param ORM $procedure
     * @return bool|ORM
     */
    public function updateHistory($data, $procedure) {
        ORM::for_table($this->table)->create($procedure);
        HistoryFactory::create($data, $procedure);
        $procedure->save();

        return $procedure;
    }
    

    /**
     * @param ORM $procedure
     * @return bool|ORM
     */
    public function deleteHistory($procedure) {
        ORM::for_table($this->table)->create($procedure);

        $now = new DateTime('now', new DateTimeZone('America/Sao_Paulo'));

        $procedure->deleted_at = $now->format('Y-m-d H:i:s');
        $procedure->save();

        return $procedure;
    }

}