<?php

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

class WhatsappCampaignModel extends My_Model {

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

    public function createWhatsappCampaign($data) {
        $whatsappCampaign = self::create();
        WhatsappCampaignFactory::create($data, $whatsappCampaign, true);
        $whatsappCampaign->save();
        return $whatsappCampaign;
    }

    public function updateWhatsappCampaign($data, $whatsappCampaign) {
        ORM::for_table($this->table)->create($whatsappCampaign);
        WhatsappCampaignFactory::create($data, $whatsappCampaign, false);
        $whatsappCampaign->save();
        return $whatsappCampaign;
    }

    public function deleteWhatsappCampaign($whatsappCampaign) {
        ORM::for_table($this->table)->create($whatsappCampaign);
        $now = new DateTime('now', new DateTimeZone('America/Sao_Paulo'));
        $user = User::_info();
        $whatsappCampaign->active = false;
        $whatsappCampaign->deleted_at = $now->format('Y-m-d H:i:s');
        $whatsappCampaign->deleted_by = $user->id;
        $whatsappCampaign->save();
        return $whatsappCampaign;
    }

    public function getActiveCampaigns(){
        $activeCampaigns = ORM::for_table($this->table)
            ->where_equal('active', 1)
            ->where_null('deleted_at')
            ->where('status', 'pending')
            ->order_by_asc('id')
            ->limit(1)
            ->find_many();
        return $activeCampaigns;
    }

    public function reloadCampaign(&$campaign){
        $campaign = ORM::for_table($this->table)
            ->find_one($campaign->id);
    }

}