<?php
defined('BASEPATH') OR exit('No direct script access allowed');

use \Illuminate\Database\Capsule\Manager as DB;

class MY_Form_validation extends CI_Form_validation
{
    /**
     * MY_Form_validation constructor.
     * @param array $rules
     */
    public function __construct($rules = array())
    {
        parent::__construct($rules);
    }

    /**
     * Validate datetime format
     *
     * @param $date
     * @return bool
     */
    public function validate_datetime($date)
    {
        if($date) {
            $format = 'Y-m-d H:i:s';
            $d = DateTime::createFromFormat($format, $date);
            if(!$d || $d->format($format) <> $date){
                $this->set_message(__FUNCTION__,'{field} '.__('is invalid format.'));
                return false;
            }
        }
        return true;
    }

    /**
     * Validate date format
     *
     * @param $date
     * @return bool
     */
    public function validate_date($date)
    {
        if($date) {
            $format = 'Y-m-d';
            $d = DateTime::createFromFormat($format, $date);
            if(!$d || $d->format($format) <> $date){
                $this->set_message(__FUNCTION__,'{field} '.__('is invalid format.'));
                return false;
            }
        }
        return true;
    }

    /**
     * Is Unique
     *
     * Check if the input value doesn't already exist
     * in the specified database field.
     *
     * @param	string	$str
     * @param	string	$field
     * @param	integer	$deleted
     * @return	bool
     */
    public function is_unique($str, $field, $deleted = 0)
    {
        sscanf($field, '%[^.].%[^.]', $table, $field);
        return DB::table($table)->where($field,$str)->where('deleted',$deleted)->count() == 0;
//        return isset($this->CI->db)
//            ? ($this->CI->db->limit(1)->get_where($table, array($field => $str,'deleted'=>$deleted))->num_rows() === 0)
//            : FALSE;
    }

}