<?php

//require_once __DIR__ . '/../../../autoload/My_Model.php';
require_once 'AbstractModel.php';
require_once __DIR__ . '/../factories/ArboFormDataFactory.php';

class ArboFormDataModel extends AbstractModel
{
	/**
	 * @var string
	 */
	public $table = 'module_arbo_form_data';
	public $factory = ArboFormDataFactory::class;

	/**
	 * @param $data
	 * @return mixed|ORM
	 */
	public function createRecord($data)
	{
		$model = self::create();
        ArboFormDataFactory::create($data, $model, true);
		$model->save();

		return $model;
	}

	/**
	 * @param $data
	 * @param $model
	 * @return mixed
	 */
	public function update($data, $model)
	{
		ORM::for_table($this->table)->create($model);
        ArboFormDataFactory::create($data, $model);
		$model->save();

		return $model;
	}

	public function delete($model)
	{
		ORM::for_table($this->table)->create($model);

//		$now = new DateTime('now', new DateTimeZone('America/Sao_Paulo'));
		$model->delete();

		return $model;
	}
        
        public static function searchAnswer($form_id, $typeform_question_id)
	{
                $arr_typeform_questio_id = explode(';', $typeform_question_id);
                $data = ORM::for_table('module_arbo_form_data');
                $data->having_in('typeform_question_id', $arr_typeform_questio_id);
                $data->where('form_id', $form_id);
                $result = $data->find_array();
                
                foreach ($result as $item)
                {
                    if($item['value'])
                    {
                        return $item['value'];
                    }
                }
                
                return null;
                
		
	}
}