<?php

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

class AgreementModel extends My_Model {

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

    /**
     * @param array $data
     * @return bool|ORM
     */
    public function createAgreement($data) {
        $agreement = self::create();
        AgreementFactory::create($data, $agreement, true);
        //SE ESSE É DEFAULT ATUALIZA TODOS PARA N
        if ($agreement->standard_agreement == 'Y') {
            $sql = "update " . $this->table . " set standard_agreement='N'  where id>=1";
            ORM::execute($sql);
        }
        $agreement->save();

        return $agreement;
    }

    /**
     * @param array $data
     * @param ORM $agreement
     * @return bool|ORM
     */
    public function updateAgreement($data, $agreement) {
        ORM::for_table($this->table)->create($agreement);
        AgreementFactory::create($data, $agreement);
        //SE ESSE É DEFAULT ATUALIZA TODOS PARA N
        if ($agreement->standard_agreement == 'Y') {
            $sql = "update " . $this->table . " set standard_agreement='N'  where id>=1";
            ORM::execute($sql);
        }
        $agreement->save();
        return $agreement;
    }

    public function defaultAgrement($agreement) {
        $sql = "update " . $this->table . " set standard_agreement='N'  where id>=1";
        ORM::execute($sql);
        $agreement->standard_agreement = 'Y';
        $agreement->save();
        return $agreement;
    }

    public function importProcedures($agreementImport, $agreementDetiny) {
        //remove todoso os registros, antes de reinserir
        $procedures = ORM::for_table('module_med_procedure_agreement')->where('module_med_agreement_id', $agreementImport)->find_many();
        foreach ($procedures as $p) {
            //tratamento para remover, na importação caso já tenha registrado o item, com o convênio
            ORM::for_table('module_med_procedure_agreement')->where('module_med_agreement_id', $agreementDetiny)->where('sys_item_id', $p->sys_item_id)->delete_many();
            $d = ORM::for_table('module_med_procedure_agreement')->create();
            $d->module_med_agreement_id = $agreementDetiny;
            $d->sys_item_id = $p->sys_item_id;
            $d->patient_value = $p->patient_value;
            $d->agreement_value = $p->agreement_value;
            $d->code_table = $p->code_table;
            $d->save();
        }
    }

    public function updateDoctorsAgreement($data, $agreementId, $doctors) {
        try {
            //remove todoso os registros, antes de reinserir
            ORM::for_table('module_med_agreement_doctors')->where('module_med_agreement_id', $agreementId)->delete_many();
            foreach ($doctors as $doc) {
                if (isset($data['doctor_' . $doc->id]) && $data['doctor_' . $doc->id] == 'Y') {
                    $d = ORM::for_table('module_med_agreement_doctors')->create();
                    $d->doctor_id = $doc->id;
                    $d->module_med_agreement_id = $agreementId;
                    $d->number_agreement = $data['number_agreement_' . $doc->id];
                    $d->save();
                }
            }
            return true;
        } catch (Exception $e) {
            return false;
        }
    }

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

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

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

        return $agreement;
    }

}