<?php

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

class ProcedureModel extends My_Model {

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

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

        return $procedure;
    }
    
    /**
     * @param array $data
     * @return bool|ORM
     */
    public function createProcedureExpenses($data) {
        $expense = self::create();
        ProcedureFactory::createExpense($data, $expense, true);
        $expense->save();

        return $expense;
    }

    public function updateProcedureDiary($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 updateProceduresAgreement($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;
        }
    }
    
    public function updateProceduresAgreementExpenses($data, $procedureId, $agreement, $row, $table_code) {
        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_expense_'.$row.'_' . $doc->id]) && $data['agreement_expense_'.$row.'_'  . $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_expense_value_' .$row.'_' . $doc->id]);
                    $d->agreement_value = Finance::amount_fix($data['convenio_expense_value_' .$row.'_' . $doc->id]);
                    $d->code_table = $table_code;
                    $d->save();
                }
            }
            return true;
        } catch (Exception $e) {
            die($e);
            return false;
        }
    }

    public function updateProcedureAllowedSchedules($procedureId) {
        //remove todoso os registros, antes de reinserir
        ORM::for_table('module_med_procedure_allowed_schedules')->where('sys_item_id', $procedureId)->delete_many();

        if (_post('ind_dom')) {
            $data_times = ORM::for_table('module_med_procedure_allowed_schedules')->create();
            $data_times->hr_ini_manha = _post('hr_dom_ini_mn');
            $data_times->hr_fim_manha = _post('hr_dom_fim_mn');
            $data_times->hr_ini_tarde = _post('hr_dom_ini_tr');
            $data_times->hr_fim_tarde = _post('hr_dom_fim_tr');
            $data_times->ind_dia = 0;
            $data_times->sys_item_id = $procedureId;
            $data_times->save();
        }

        if (_post('ind_seg')) {
            $data_times = ORM::for_table('module_med_procedure_allowed_schedules')->create();
            $data_times->hr_ini_manha = _post('hr_seg_ini_mn');
            $data_times->hr_fim_manha = _post('hr_seg_fim_mn');
            $data_times->hr_ini_tarde = _post('hr_seg_ini_tr');
            $data_times->hr_fim_tarde = _post('hr_seg_fim_tr');
            $data_times->ind_dia = 1;
            $data_times->sys_item_id = $procedureId;
            $data_times->save();
        }

        if (_post('ind_ter')) {
            $data_times = ORM::for_table('module_med_procedure_allowed_schedules')->create();
            $data_times->hr_ini_manha = _post('hr_ter_ini_mn');
            $data_times->hr_fim_manha = _post('hr_ter_fim_mn');
            $data_times->hr_ini_tarde = _post('hr_ter_ini_tr');
            $data_times->hr_fim_tarde = _post('hr_ter_fim_tr');
            $data_times->ind_dia = 2;
            $data_times->sys_item_id = $procedureId;
            $data_times->save();
        }

        if (_post('ind_qua')) {
            $data_times = ORM::for_table('module_med_procedure_allowed_schedules')->create();
            $data_times->hr_ini_manha = _post('hr_qua_ini_mn');
            $data_times->hr_fim_manha = _post('hr_qua_fim_mn');
            $data_times->hr_ini_tarde = _post('hr_qua_ini_tr');
            $data_times->hr_fim_tarde = _post('hr_qua_fim_tr');
            $data_times->ind_dia = 3;
            $data_times->sys_item_id = $procedureId;
            $data_times->save();
        }

        if (_post('ind_qui')) {
            $data_times = ORM::for_table('module_med_procedure_allowed_schedules')->create();
            $data_times->hr_ini_manha = _post('hr_qui_ini_mn');
            $data_times->hr_fim_manha = _post('hr_qui_fim_mn');
            $data_times->hr_ini_tarde = _post('hr_qui_ini_tr');
            $data_times->hr_fim_tarde = _post('hr_qui_fim_tr');
            $data_times->ind_dia = 4;
            $data_times->sys_item_id = $procedureId;
            $data_times->save();
        }

        if (_post('ind_sex')) {
            $data_times = ORM::for_table('module_med_procedure_allowed_schedules')->create();
            $data_times->hr_ini_manha = _post('hr_sex_ini_mn');
            $data_times->hr_fim_manha = _post('hr_sex_fim_mn');
            $data_times->hr_ini_tarde = _post('hr_sex_ini_tr');
            $data_times->hr_fim_tarde = _post('hr_sex_fim_tr');
            $data_times->ind_dia = 5;
            $data_times->sys_item_id = $procedureId;
            $data_times->save();
        }

        if (_post('ind_sab')) {
            $data_times = ORM::for_table('module_med_procedure_allowed_schedules')->create();
            $data_times->hr_ini_manha = _post('hr_sab_ini_mn');
            $data_times->hr_fim_manha = _post('hr_sab_fim_mn');
            $data_times->hr_ini_tarde = _post('hr_sab_ini_tr');
            $data_times->hr_fim_tarde = _post('hr_sab_fim_tr');
            $data_times->ind_dia = 6;
            $data_times->sys_item_id = $procedureId;
            $data_times->save();
        }
    }

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

        return $procedure;
    }
    
    /**
     * @param array $data
     * @param ORM $expense
     * @return bool|ORM
     */
    public function updateProcedureExpense($data, $expense) {
        ORM::for_table($this->table)->create($expense);
        ProcedureFactory::createExpense($data, $expense);
        $expense->save();

        return $expense;
    }

    /**
     * @param ORM $procedure
     * @return bool|ORM
     */
    public function deleteProcedure($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;
    }

}