<?php

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

class NeighborhoodModel extends My_Model {

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

    public function createNeighborhood($data) {
        $neighborhood = self::create();
        NeighborhoodFactory::create($data, $neighborhood, true);
        $neighborhood->save();
        $this->saveRelated($data, $neighborhood->id);
        return $neighborhood;
    }

    public function updateNeighborhood($data, $neighborhood, $update = false) {
        ORM::for_table($this->table)->create($neighborhood);
        NeighborhoodFactory::create($data, $neighborhood, false, $update);
        $neighborhood->save();
        $this->saveRelated($data, $neighborhood->id);
        return $neighborhood;
    }

    public function saveRelated($data, $id) {

        ORM::for_table('module_imobles_neighborhoods_related')
                ->where('neighborhood_id', $id)
                ->delete_many();

        if (isset($data['neighborhood_id_related'])) {
            foreach ($data['neighborhood_id_related'] as $t) {
                $a = ORM::for_table("module_imobles_neighborhoods_related")->create();
                $a->neighborhood_id = $id;
                $a->related_neighborhood_id = $t;
                $a->save();
            }
        }
    }

    public function deleteNeighborhood($neighborhood) {
        ORM::for_table($this->table)->create($neighborhood);

        $now = new DateTime('now', new DateTimeZone('America/Sao_Paulo'));
        $user = User::_info();
        $neighborhood->deleted_at = $now->format('Y-m-d H:i:s');
        $neighborhood->deleted_by = $user->id;
        $neighborhood->save();
        return $neighborhood;
    }

}