<?php if ( ! defined('BASEPATH')) exit('No direct script is allowed');
require_once("Action_controller.php");
class Form_queries  extends Action_controller{	
	public function __construct(){
		parent::__construct('form_queries');
	}
	
	// LOAD PAGE QUICK LINK,FILTERS AND TABLE HEADERS
	public function index(){
		//PAGE INFO FUNCTION
		$this->page_info();
		$data['quick_link']    = $this->quick_link;
		$data['pick_list']     = $this->pick_list;
		$data['form_info']     = $this->form_info;
		$data['table_head']    = $this->table_head;
		$data['fliter_list']   = $this->fliter_list;
		$data['freeze_list']   = $this->freeze_list;
		$this->load->view("$this->control_name/manage",$data);
	}
	
	//Function For Insert a Time Entry Table
	public function create_form_qry_file(){
		$from_date                 = date("Y-m-d H:i:s",strtotime($this->input->post('from_date')));
		$to_date                   = date("Y-m-d H:i:s",strtotime($this->input->post('to_date')));
		$table_cr_alt_qry_rslt     = [];

		//CREATE AND ALTER QUERY FORMAT
		$table_name                = "cw_all_setting_queries";
		$table_where               = 'cw_all_setting_queries.trans_created_date between "'.$from_date.'" and "'.$to_date.'" and cw_all_setting_queries.trans_status = 1';
		//FUNCTION USED FOR CREATE A QRY 
		$all_setting_qry_rslt      = $this->query_build_function($table_name,$table_where);
		
		//FUNCTION FOR BUILD A ALL QUERIES IN ONE VARIABLE (FUNCTION USED FOR CONCATE A INSERT UPDATE AND CREATE ALTER QUERY )
		if($all_setting_qry_rslt[0]){
			$all_setting_queries   = $this->all_setting_query_function($all_setting_qry_rslt);
			if($all_setting_queries){
				//TEXT FILE CREATE CODES
				$folder 	       = "db_setting_query";
				$file_path_name    = $folder."/setting_queries.txt";
				$oldmask           = umask(0);
				//IF CHECK FOLDER EXIST OR NOT
				if(!file_exists($folder)){
					//CREATE A FILE FOLDER (DIRECTORY)
					mkdir($folder, 0777, true);
					chmod($folder, 0777);
				}
				$fp                = fopen($file_path_name,"wb");
				fwrite($fp,$all_setting_queries);
				fclose($fp);
				chmod($fp, 0777);
				umask($oldmask);
				if(file_exists($file_path_name)){
					echo json_encode(array('success' => TRUE, 'message' => "Queries and Text file are Created Successfully..!"));
				}else{
					echo json_encode(array('success' => FALSE, 'message' => "Query Text File Path are not Correctly Added..!!"));
				}
			}else{
				echo json_encode(array('success' => FALSE, 'message' => "Query Changes are not Correctly Fetch to Text File ..!!"));
			}
		}else{
			echo json_encode(array('success' => FALSE, 'message' => "Query Changes are not Available In this From and To Date ..!!"));
		}
	}
	//FUNCTION USED FOR CREATE A QRY 
	public function query_build_function($table_name,$table_where){
		$form_qry_detail  = 'select * from '.$table_name.' where '.$table_where.'';
		$form_qry_info    = $this->db->query("CALL sp_a_run ('SELECT','$form_qry_detail')");
		$form_qry_rslt    = $form_qry_info->result_array();
		$form_qry_info->next_result();
		return $form_qry_rslt;
	}
	//FUNCTION FOR BUILD A ALL QUERIES IN ONE VARIABLE (FUNCTION USED FOR CONCATE A INSERT UPDATE AND CREATE ALTER QUERY)
	public function all_setting_query_function($all_setting_qry_rslt){
		$all_setting_queries     = "";
		if($all_setting_qry_rslt){
			$all_setting_queries = implode(";\n\n", array_map(function ($v) {
				//CONDITIONS ONLY FOR CREATE AND ALTER QUERY FORMAT
				$build_qry       = $v['all_setting_query'];
				return $build_qry;
			}, $all_setting_qry_rslt));
		}
		//TO CONCATE A (INSERT AND UPDATE) AND (CREATE AND ALTER) QUERIES
		if($all_setting_queries){
			return $all_setting_queries;
		}else{
			return false;
		}
	}
}
?>