<?php

/**
 * inoERP
 *
 * @copyright   2014 Nishit R. Das
 * @license     https://www.mozilla.org/MPL/2.0/
 * @link        http://inoideas.org
 * @source code https://github.com/inoerp/inoERP
 */

/**
 * option_header
 *
 */
class option_header extends dbObject {

 public static $table_name = "option_header";
 public static $dependent_classes = ['option_line', 'option_detail'];
 public static $primary_column = "option_header_id";
 public static $key_column = 'option_type';
 public static $module = "sys";
 public static $system_info = [
  'name' => 'Option',
  'number' => '9105',
  'description' => 'Create & Mainten Options',
  'version' => '0.1.1',
  'db_version' => '1001',
  'mod_version' => '1.1.1',
  'dependent_class' => array('option_line', 'option_detail'),
  'primary_entity_cb' => '',
  'module_name' => 'sys',
  'weight' => 5
 ];
 public static $access_level_a = [
  'SYSTEM' => 'System',
  'USER' => 'User',
  'BOTH' => 'Both'
 ];
 public $field_a = [
  "option_header_id",
  "option_type",
  "access_level",
  "description",
  "module_code",
  'option_assignments',
  "efid",
  "status",
  "rev_enabled",
  "rev_number",
  "created_by",
  "creation_date",
  "last_update_by",
  "last_update_date"
 ];
 public $initial_search = [
  "option_header_id",
  "option_type",
  "description",
 ];
 public $checkbox = [
 ];
 public $column = [
  "option_header_id",
  "option_type",
  "description",
  "module_code"
 ];
 public $number_fields = [
  "option_header_id"
 ];
 public $requiredField = [
  "option_type",
  "access_level",
  "description",
  "module_code",
 ];
 public $search = [
//		 '_update_path' => 'modules/sys/option/option',
  '_show_update_path' => 1,
  '_update_action_meassge' => 'Update Option',
  '_show_view_path' => 1,
//		 '_view_action_meassge' => 'View',
//		 '_extra_path' => '',
 ];
 public $pageTitle = " Option - Create & Update different option and values "; //page Title
 public $option_list = [
//		 'calendar_option_line_code' => 'GL_CALENDAR_NAME',
 ]; //list of search fields which have options
 public $option_header_id;
 public $access_level;
 public $option_type;
 public $description;
 public $module_code;
 public $option_assignments;
 public $value_group_id;
 public $efid;
 public $status;
 public $rev_enabled;
 public $rev_number;
 public $created_by;
 public $creation_date;
 public $last_update_by;
 public $last_update_date;
 public $time;
 public $msg;
 public static $dir = __DIR__;

 public function __set($name, $value) {
  $this->$name = $value;
 }

 Public static function find_options_byName($name, $order_by_field = 'priority', $order_by_seq = 'ASC') {
  $option_header = self::find_by_name($name);
  if ($option_header) {
   return option_line::find_by_parent_id($option_header->option_header_id, $order_by_field, $order_by_seq);
  } else {
   return null;
  }
 }

 Public static function countries() {
  $option_header = self::find_by_name('COUNTRY');
  $countries = option_line::find_by_option_id($option_header->option_header_id);
  return $countries;
 }

 Public static function document_types() {
  $option_header = self::find_by_name('SYS_DOCUMENT_TYPE');
  $countries = option_line::find_by_option_id($option_header->option_header_id);
  return $countries;
 }

 Public static function period_types() {
  $option_header = self::find_by_name('SYS_PERIOD_TYPE');
  $lines = option_line::find_by_option_id($option_header->option_header_id);
  return $lines;
 }

 Public static function modules() {
  $option_header = self::find_by_name('SYS_MODULE');
  $lines = option_line::find_by_option_id($option_header->option_header_id);
  return $lines;
 }

 Public static function currencies() {
  $option_header = self::find_by_name('CURRENCY');
  $ol = new option_line();
  $currencies = $ol->findBy_parentId($option_header->option_header_id, 'option_line_code');
  return $currencies;
 }

 Public static function exception_actions() {
  $option_header = self::find_by_name('EXCEPTION_ACTION');
  $exception_actions = option_line::find_by_option_id($option_header->option_header_id);
  return $exception_actions;
 }

 Public static function option_assignments() {
  $option_header = self::find_by_name('OPTION_ASSIGNMENT');
  $ol = new option_line;
  $result = $ol->findBy_parentId($option_header->option_header_id);
  return $result;
 }

 public static function find_all_headers() {
  $sql = " SELECT * FROM " . self::$table_name;
  global $db;
  $result = $db->findBySql($sql);
  return $result;
 }

 public static function find_by_name($option_types) {
  global $db;
  $sql = "SELECT * FROM " . self::$table_name . " where option_type LIKE :option_type ";
  switch (DB_TYPE) {
   case 'ORACLE' :
    $sql .= ' AND ' . ino_perPageSql(1);
    break;

   default:
    $sql .=  ino_perPageSql(1);
    break;
  }
 
  	  global $db;
  $value_a = ['option_type' =>  "%$option_types%"];
  $result_array = $db->findBySql($sql, $value_a);

  return !empty($result_array) ? array_pop($result_array) : false;
 }

 public static function find_by_exact_name($option_types) {
  global $db;
  $sql = "SELECT * FROM " . self::$table_name . " WHERE option_type = :option_type ";
  $sql = ino_perPageSql_i($sql, 1);
   	  global $db;
  $value_a = ['option_type' =>  $option_types];
  $result_array = $db->findBySql($sql, $value_a);
  return !empty($result_array) ? array_shift($result_array) : false;
 }

 public function save() {
  if (empty($this->option_header_id)) {
   $check_option_type = $this->check_option_type();
   if ($check_option_type == 0) {
    $this->create();
   } else {
    $this->msg = "Option type already exists";
   }
  } else {
   $this->update($this->option_header_id);
  }
  return $this->msg;
 }

 private function check_option_type() {
  global $db;
  $sql = "SELECT * FROM " . self::$table_name . " where option_type= :option_type ";
 
  	  global $db;
  $value_a = ['option_type' => $this->option_type];
  $result_array = $db->findBySql($sql, $value_a);
  
  if (count($result_array) > 0) {
   $this->msg = 1;
  } else {
   $this->msg = 0;
  }
  return $this->msg;
 }

 public static function staticVar_init($staticvar) {
  foreach (self::${$staticvar} as $key => $value) {
  	self::${$staticvar}[$key] = gettext($value);
  }
 }

}

//end of path class
option_header::staticVar_init('access_level_a');
?>