id = $context['id']; $this->db_name = $context['db_name']; $this->tbl = $context['table']; } public function set() { global $database; $id = $this->id; $db_name = $this->db_name; $table = $this->tbl; $table_array=array('qls' => 'quotes_labour_settings','pd' =>'production_departments', 'pds' => 'production_departments_sub'); if($table == 'qls'){ $table_name= $table_array['qls']; }elseif($table == 'pd'){ $table_name = $table_array['pd']; }elseif($table == 'pds'){ $table_name = $table_array['pds']; } $this->table_name =$table_name; if(!empty($id)) { $query = " SELECT * FROM $db_name".$table_name." WHERE id = '$id' "; $results = $database->getRow($query); if($table == 'pd'){ $this->department = $results['department']; $this->department_name = $results['department_name']; $this->manual_entry = $results['manual_entry']; $this->status = $results['status']; }else{ $this->labour_name = $results['labour_name']; $this->rate = $results['rate']; $this->fieldtype = $results['fieldtype']; $this->status = $results['status']; } } if($_POST['Submit'] == "Save") { $formtag= $_POST['formtag']; if($formtag == 1){ $this->department = $_POST['department']; $this->department_name = $_POST['department_name']; $this->manual_entry = $_POST['manual_entry']; $this->status = $_POST['status']; }else{ $this->production_departments_id = $_POST['production_departments_id']; $this->labour_name = $_POST['labour_name']; $this->rate = $_POST['rate']; $this->fieldtype = $_POST['fieldtype']; $this->status = $_POST['status']; } $this->table_name=$this->table_name; } if($table == 'pd'){ $this->config['department'] = array("id"=> $id,"value"=> $this->department, "input_name" => "department", "name" => "Labour Name","rule" => "required"); $this->config['department_name'] = array("id"=> $id,"value"=> $this->department_name, "input_name" => "department_name", "name" => "Rate","rule" => "required"); $this->config['manual_entry'] = array("id"=> $id,"value"=> $this->manual_entry, "input_name" => "manual_entry", "name" => "Field Type","rule" => "required"); $this->config['status'] = array("id"=> $id,"value"=> $this->status, "input_name" => "status", "name" => "Status","rule" => "required"); }else{ $this->config['labour_name'] = array("id"=> $id,"value"=> $this->labour_name, "input_name" => "labour_name", "name" => "Labour Name","rule" => "required"); $this->config['rate'] = array("id"=> $id,"value"=> $this->rate, "input_name" => "rate", "name" => "Rate","rule" => "required|numeric"); $this->config['fieldtype'] = array("id"=> $id,"value"=> $this->fieldtype, "input_name" => "fieldtype", "name" => "Field Type","rule" => "required"); $this->config['status'] = array("id"=> $id,"value"=> $this->status, "input_name" => "status", "name" => "Status","rule" => "required"); } self::run_validation(); } public function run_validation() { $id = $this->id; $table = $this->tbl; $static_function = (($_POST['Submit'] == "")) ? "initial" : "validate"; if($table == 'pd'){ $this->validation['department'] = validation::$static_function($this->config['department']); $this->validation['department_name'] = validation::$static_function($this->config['department_name']); $this->validation['manual_entry'] = validation::$static_function($this->config['manual_entry']); $this->validation['status'] = validation::$static_function($this->config['status']); }else{ $this->validation['labour_name'] = validation::$static_function($this->config['labour_name']); $this->validation['rate'] = validation::$static_function($this->config['rate']); $this->validation['fieldtype'] = validation::$static_function($this->config['fieldtype']); $this->validation['status'] = validation::$static_function($this->config['status']); } $this->reasons = validation::formalise($this->validation); } public function form(){ global $database; $id = $this->id; $fieldtype= $this->fieldtype; $manual_entry= $this->manual_entry; $config = $this->config; $validation = $this->validation; $table = $this->tbl; $table_name = $this->table_name; $status = $this->status; $company_name = $this->company_name; $my_group = $_SESSION['user']['groups']; $my_branch = $_SESSION['user']['branch_id']; $my_username = $_SESSION['user']['id']; $options = array("class" => "medium"); ?>
Select what you want to create: