<?php

include_once __DIR__ . "/../../../autoload/My_Model.php";
include_once __DIR__ . "/../factories/UnityFactory.php";
include_once __DIR__ . "/../models/ListingModel.php";

class UnityModel extends My_Model {

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

    public function createEnterprise_unity($data) {
        $unity = self::create();
        UnityFactory::create($data, $unity, true);
        $unity->save();
        $this->saveAmenities($data, $unity->id);
        return $unity;
    }

    public function updateEnterprise_unity($data, $unity) {
        ORM::for_table($this->table)->create($unity);
        UnityFactory::create($data, $unity);
        $unity->save();
        $this->saveAmenities($data, $unity->id);
        return $unity;
    }

    public function saveAmenities($data, $id) {

        ORM::for_table('module_imobles_enterprise_units_amenities')
                ->where('module_imobles_enterprise_units_id', $id)
                ->delete_many();


        if (isset($data['module_imobles_units_amenities'])) {
            foreach ($data['module_imobles_units_amenities'] as $t) {
                $a = ORM::for_table("module_imobles_enterprise_units_amenities")->create();
                $a->module_imobles_enterprise_units_id = $id;
                $a->module_imobles_units_amenities_id = $t;
                $a->save();
            }
        }
    }

    public function deleteEnterprise_unity($unity) {
        ORM::for_table($this->table)->create($unity);
        $now = new DateTime('now', new DateTimeZone('America/Sao_Paulo'));
        $user = User::_info();
        $unity->delete_at = $now->format('Y-m-d H:i:s');
        $unity->delete_by = $user->id;
        $unity->save();
        return $unity;
    }

    public function createUnityListing($unity, $value){
        $d = ORM::for_table('module_imobles_listings')->create();
        $d->entreprise_id = $unity->module_imobles_enterprise_id;
        $d->unit_type_id = $unity->module_imobles_enterprise_units_type_id;
        $d->unit_id = $unity->id;
        $d->crawler_type = 'airtable';
        $d->crawler_type_id = 4;
        $d->crawler_price = Finance::amount_fix(@$value);
        $d->created_at = date('Y-m-d H:i:s');
        $d->created_by = 0;
        $d->verified = 1;
        $d->save();

        // Insert Listing Price
        $sql = "INSERT INTO module_imobles_listings_prices "
            . "(listing_id, unit_type_id, date, price) "
            . "VALUES ((SELECT id FROM module_imobles_listings WHERE unit_id = " . $unity->id . " AND crawler_type_id = 4), " 
            . $unity->module_imobles_enterprise_units_type_id . ", now(), " . Finance::amount_fix(@$value) . ")";
        ORM::execute($sql);
    }

    public function updateListingPrice($unit, $value){
        $listingModel = new ListingModel();
        $listing = ORM::for_table($listingModel->table)
            ->where('unit_id', $unit->id)
            ->where('crawler_type_id', 4)
            ->where_null('delete_at')            
            ->find_one();        
        
        if ($listing->crawler_price <> $value) {
            $listing->crawler_price = Finance::amount_fix($value);
            $listing->save();

            $sql = "INSERT INTO module_imobles_listings_prices "
                 . "(listing_id, unit_type_id, date, price) "
                 . "VALUES ((SELECT id FROM module_imobles_listings WHERE unit_id = " . $unit->id . " AND crawler_type_id = 4), " 
                 . $unit->module_imobles_enterprise_units_type_id . ", now(), " . Finance::amount_fix(@$value) . ")";
            ORM::execute($sql);
        }
    }
}