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

class SAV_Form_validation extends CI_Form_validation
{

  protected $CI;

  public function __construct($rules = array())
  {
    parent::__construct($rules);
    $this->CI = &get_instance();
  }


  /**
   * is_unique_multiple
   * check multiple unique field at time
   * handy when checking if two or more column of some set of value
   * e.g if firstname="something" and username="something"
   * usage: 
   *is_unique_multiple[
   * 	table_name,
   * 	column_name1.column_name2.column_name3,
   * 	post_filed_name1.post_field_name2.post_field_name3
   *]
   *real example $this->form_validation->set_rules('fee_name', 'fee_name', "required|is_unique_multiple[arasoft_fee, fee_name.fee_term.fee_users, fee_name.term.fee_users ]");
   **/
  public function is_unique_multiple($str, $data)
  {
    $data = explode(",", $data);
    if (count($data) < 2)
      return TRUE;

    $table = @$data[0];
    $str = @$data[1];
    $str = explode(".", $str);
    $field = @$data[2];

    $field = empty($field) ? $str : explode(".", $field);
    if (count($str) != count($field)) {
      return TRUE;
    }
    $where = [];

    foreach ($str as $key => $value) {
      # code...
      $q = $this->CI->input->post($field[$key]);
      $where[$value] = $q;
    }

    $check = $this->CI->db->get_where($table, $where, 1);

    if ($check->num_rows() > 0) {

      $this->set_message('is_unique_multiple', 'This data exist already');

      return FALSE;
    }

    return TRUE;
  }

  function exist($str, $data)
  {
    $data = explode(",", $data);
    if (count($data) < 2)
      return TRUE;

    $table = @$data[0];
    $str = @$data[1];
    $str = explode(".", $str);
    $field = @$data[2];

    $field = empty($field) ? $str : explode(".", $field);
    if (count($str) != count($field)) {
      return TRUE;
    }
    $where = [];

    foreach ($str as $key => $value) {
      # code...
      $q = ! is_null($this->CI->input->post($field[$key]))
        ? $this->CI->input->post($field[$key])
        : $this->CI->input->get($field[$key]);
      $where[$value] = $q;
    }

    $check = $this->CI->db->get_where($table, $where, 1);

    if ($check->num_rows() === 0) {

      $this->set_message('exist', 'This data does not exists');

      return FALSE;
    }

    return TRUE;
  }
}