<?php
Class Controller_Admin_Master_Mapping extends GeneralAction {

    function beforeExec() {
		parent::beforeExec();
		parent::$moduleName = "Mapping";
        parent::$isAdmin = true;
		parent::$mapping = parent::generateMapping('mapping');
        parent::$prefix = 'mmph';
        parent::$table = 'master_mapping_header';
		parent::$validate = array(
            'check_empty'   => array('txtName', 'txtDbName', 'txtDbPrefix', 'txtModuleName')
        );

        /* For Detail */
		parent::$mappingDetail = parent::generateMapping('mapping detail');
        parent::$prefixDetail = 'mmpd';
        parent::$tableDetail = 'master_mapping_detail';
		parent::$validateDetail = array(
            'check_empty'   => array('txtFieldDb', 'txtLabel', 'txtTypeFieldDb')
        );
	}
	
	protected function do_show() {
		$form = GenerateForm::load()->buildForm(static::$mapping); 
		$addJs = "
		var lastNum = '';
		function afterLoadDataApi(data) {
			if(data.lastnum != undefined) {
				lastNum = data.lastnum;
			}
		}
		function afterSelect(obj){
			$('#txtName, #txtDbPrefix, #txtDbName').attr('readonly', true);
		}
		function afterMainSave() {
			$('#txtName, #txtDbPrefix, #txtDbName').attr('readonly', true);
		}
		function afterNewForm(){
			$('.errMsgDesc').remove();
			$('input, select, textarea').removeClass('errMsg');
			$('#txtName, #txtDbPrefix, #txtDbName').attr('readonly', false);
		}
		function afterNewFormDetail(){
			$('.errMsgDesc').remove();
			$('input, select, textarea').removeClass('errMsg');
			$('#txtSort').val(lastNum);
			$('#txtFieldDb').val($('#txtDbPrefix').val());
		}
		";
		$addTpl = array("addJs" => $addJs);
		parent::do_show('/Templates/Admin/default2Grid.html', $addTpl);
	}
	
	protected function do_save() {
		$save = parent::do_save();
		if($save["status"] == "ok") {
			$prefix = strtolower($_POST['txtDbPrefix']);
			$table  = $_POST['txtDbName'];
			if(empty($_POST['slTypeGrid'])) {
				Database::build()->insertArray("master_mapping_detail", "mmpd", array(
													"mmpdMmphId" 	=> $save['id'],
													"mmpdFieldDb"	=> "{$prefix}Id",
													"mmpdTypeDb"	=> "INT",
													"mmpdLengthDb"	=> "0",
													"mmpdType"		=> "hidden",
													"mmpdLabel"		=> "ID",
													"mmpdFieldName"	=> "txtId",
													"mmpdGrid"		=> "true",
													"mmpdSort"		=> 1
												)
											);
				if(!empty($_POST['slCreateTable'])) {							
					$createTable = "CREATE TABLE IF NOT EXISTS {$table}(  
								`{$prefix}Id` INT NOT NULL AUTO_INCREMENT,
								`{$prefix}CreateBy` INT,
								`{$prefix}CreateTime` DATETIME,
								`{$prefix}UpdateBy` INT,
								`{$prefix}UpdateTime` DATETIME,
							  PRIMARY KEY (`{$prefix}Id`)
							);";			
					Database::build()->directlyQuery($createTable);	
				}
			}else{
				Database::build()->insertArray("master_mapping_detail", "mmpd", array(
													"mmpdMmphId" 	=> $save['id'],
													"mmpdFieldDb"	=> "{$prefix}Id",
													"mmpdTypeDb"	=> "INT",
													"mmpdLengthDb"	=> "0",
													"mmpdType"		=> "hidden",
													"mmpdLabel"		=> "ID",
													"mmpdFieldName"	=> "txtIdDetail",
													"mmpdGrid"		=> "true",
													"mmpdSort"		=> 1
												)
											);
											
				$getHeader = Database::build()->getAllDbOne("SELECT mmphDbPrefix FROM master_mapping_header WHERE mmphId = '".$_POST['slTypeGrid']."'");							
				Database::build()->insertArray("master_mapping_detail", "mmpd", array(
													"mmpdMmphId" 	=> $save['id'],
													"mmpdFieldDb"	=> $prefix . ucfirst($getHeader['mmphDbPrefix']) . "Id",
													"mmpdTypeDb"	=> "INT",
													"mmpdLengthDb"	=> "0",
													"mmpdType"		=> "hidden",
													"mmpdLabel"		=> "ID Header",
													"mmpdFieldName"	=> "txtIdHeader",
													"mmpdGrid"		=> "true",
													"mmpdSort"		=> 2
												)
											);	
				
				if(!empty($_POST['slCreateTable'])) {	
					$createTable = "CREATE TABLE IF NOT EXISTS {$table}(  
								`{$prefix}Id` INT NOT NULL AUTO_INCREMENT,
								`{$prefix}".ucfirst($getHeader['mmphDbPrefix'])."Id` INT,
								`{$prefix}CreateBy` INT,
								`{$prefix}CreateTime` DATETIME,
								`{$prefix}UpdateBy` INT,
								`{$prefix}UpdateTime` DATETIME,
							  PRIMARY KEY (`{$prefix}Id`)
							);";			
					Database::build()->directlyQuery($createTable);		
				}
			}
			if(!empty($_POST['slCreateScript'])) {
				$this->readyToScript($_POST);
			}
		}
	 	return $save;
	}
	
	protected function do_update() {
		$getCreateScript = Database::build()->getAllDbOne("SELECT mmphDbDefault, mmphDbPrefix, mmphCreateScript, mmphType FROM master_mapping_header WHERE mmphId = '".$_POST['txtId']."'");
		$update = parent::do_update();
		if($update['status'] == "ok") {
			$table = $getCreateScript['mmphDbDefault'];
			$prefix = $getCreateScript['mmphDbPrefix'];
			if(!empty($_POST['slCreateTable'])) {							
				$createTable = "CREATE TABLE IF NOT EXISTS {$table}(  
							`{$prefix}Id` INT NOT NULL AUTO_INCREMENT,
							`{$prefix}CreateBy` INT,
							`{$prefix}CreateTime` DATETIME,
							`{$prefix}UpdateBy` INT,
							`{$prefix}UpdateTime` DATETIME,
						  PRIMARY KEY (`{$prefix}Id`)
						);";			
				Database::build()->directlyQuery($createTable);	
			}
			if($getCreateScript['mmphType'] != (!empty($_POST['slTypeGrid']) ? $_POST['slTypeGrid'] : 0)) {
				if(!empty($_POST['slTypeGrid'])) {
					if(!empty($getCreateScript['mmphType'])) {
						if(!empty($_POST['slCreateTable'])) {	
							$getHeaderOld = Database::build()->getAllDbOne("SELECT mmphDbPrefix FROM master_mapping_header WHERE mmphId = '".$getCreateScript['mmphType']."'");
							if(!empty($getHeaderOld['mmphDbPrefix'])) {
								$removeColumn = "ALTER TABLE {$table} DROP COLUMN {$prefix}".ucfirst($getHeaderOld['mmphDbPrefix'])."Id";
								Database::build()->directlyQuery($removeColumn);
							}
						}
						Database::build()->delete_data("master_mapping_detail", "mmpd", "mmpdFieldName = 'txtIdHeader' AND mmpdMmphId = '".$update['id']."'");
					}
					
					$getHeader = Database::build()->getAllDbOne("SELECT mmphDbPrefix FROM master_mapping_header WHERE mmphId = '".$_POST['slTypeGrid']."'");
					if(!empty($_POST['slCreateTable'])) {	
						$addColumn = "ALTER TABLE `{$table}` ADD COLUMN {$prefix}".ucfirst($getHeader['mmphDbPrefix'])."Id INT AFTER {$prefix}Id";
						Database::build()->directlyQuery($addColumn);
					}
					
					Database::build()->updateArray("master_mapping_detail", "mmpd", array("mmpdFieldName" => "txtIdDetail"), "mmpdFieldName = 'txtId' AND mmpdMmphId = '".$update['id']."'");
					Database::build()->insertArray("master_mapping_detail", "mmpd", array(
													"mmpdMmphId" 	=> $update['id'],
													"mmpdFieldDb"	=> $prefix . ucfirst($getHeader['mmphDbPrefix']) . "Id",
													"mmpdType"		=> "hidden",
													"mmpdLabel"		=> "ID Header",
													"mmpdFieldName"	=> "txtIdHeader",
													"mmpdGrid"		=> "true",
													"mmpdSort"		=> 2
												)
											);	
					
				}else{
					if(!empty($_POST['slCreateTable'])) {	
						$getHeader = Database::build()->getAllDbOne("SELECT mmphDbPrefix FROM master_mapping_header WHERE mmphId = '".$getCreateScript['mmphType']."'");
						if(!empty($getHeader['mmphDbPrefix'])) {
							$removeColumn = "ALTER TABLE {$table} DROP COLUMN {$prefix}".ucfirst($getHeader['mmphDbPrefix'])."Id";
							Database::build()->directlyQuery($removeColumn);
						}
					}
					
					Database::build()->updateArray("master_mapping_detail", "mmpd", array("mmpdFieldName" => "txtId"), "mmpdFieldName = 'txtIdDetail' AND mmpdMmphId = '".$update['id']."'");
					Database::build()->delete_data("master_mapping_detail", "mmpd", "mmpdFieldName = 'txtIdHeader' AND mmpdMmphId = '".$update['id']."'");
				}
				
				if(!empty($_POST['slCreateScript'])) {
					$this->readyToScript($_POST);
				}
			}
			
			if(!empty($_POST['slCreateScript']) && empty($getCreateScript['mmphCreateScript'])) {
				$this->readyToScript($_POST);
			}
		}
		return $update;	
	}
	
	protected function do_savedetail() {
		$savedetail = parent::do_savedetail();
		if($savedetail['status'] == "ok") {
			$getHeader = Database::build()->getAllDbOne("SELECT mmphDbDefault, mmphDbPrefix FROM master_mapping_header WHERE mmphId = '".$_POST['txtIdHeader']."'");
			$getCustomField = Database::build()->getAllDbOne("SELECT mmpdFieldDb FROM master_mapping_detail WHERE mmpdId != '".$savedetail['id']."' AND mmpdMmphId = '".$_POST['txtIdHeader']."' AND mmpdSort < '".$_POST['txtSort']."' ORDER BY mmpdSort DESC LIMIT 1");
			$column = $_POST['txtFieldDb'] . " " . (($_POST['txtTypeFieldDb'] == "VARCHAR") ? $_POST['txtTypeFieldDb'] ."(".$_POST['txtTypeLengthDb'].")": $_POST['txtTypeFieldDb']);
			$addColumn = "ALTER TABLE `".$getHeader['mmphDbDefault']."` ADD COLUMN {$column} AFTER ".$getCustomField['mmpdFieldDb'];
			Database::build()->directlyQuery($addColumn);
		}	
		return $savedetail;
	}
	
	protected function do_updatedetail() {
		$getDetail = Database::build()->getAllDbOne("SELECT mmphDbDefault, mmpdFieldDb, mmpdTypeDb, mmpdLengthDb FROM master_mapping_detail LEFT JOIN master_mapping_header ON mmphId = mmpdMmphId WHERE mmpdId = '".$_POST['txtIdDetail']."'");
		$updatedetail = parent::do_updatedetail();
		if($_POST['txtFieldDb'] != $getDetail['mmpdFieldDb'] || $_POST['txtTypeFieldDb'] != $getDetail['mmpdTypeDb'] || $_POST['txtTypeLengthDb'] != $getDetail['mmpdLengthDb']) {
			$column = $_POST['txtFieldDb'] . " " . (($_POST['txtTypeFieldDb'] == "VARCHAR") ? $_POST['txtTypeFieldDb'] ."(".$_POST['txtTypeLengthDb'].")": $_POST['txtTypeFieldDb']);
			$changeColumn = "ALTER TABLE `".$getDetail['mmphDbDefault']."` CHANGE `".$getDetail['mmpdFieldDb']."` ".$column;
			Database::build()->directlyQuery($changeColumn);
		}
		return $updatedetail;
	}

	protected function do_datadetail() {
		$data = parent::do_datadetail();
		$getSeq = Database::build()->getAllDbOne("SELECT MAX(mmpdSort) + 1 as lastnum FROM master_mapping_detail WHERE mmpdMmphId = '".parent::getParam(1)."'");
		$data["lastnum"] = $getSeq['lastnum'];
		return $data;
	}	
	
	function readyToScript($post) {
		$filename = ucfirst(str_replace(" ", "", strtolower($post['txtName'])));
		$file = "Controller/Admin/Master/" . $filename . ".php";
		$pf = fopen ($file, "w");
		if (!$pf)
		{
			echo "cannot create $file\n";
			return;
		}
		
		if(empty($post['slTypeGrid'])) {
			$createFile = $this->createScript(1, $filename, $post);
		}else{
			$createFile = $this->createScript(2, $filename, $post);
		}
		
		fwrite ($pf, $createFile);
		fclose ($pf);
	}
	
	function createScript($type = 1, $filename, $post) {
		if($type == 1) {
			$createFile = '<?php
	Class Controller_Admin_Master_'.$filename.' extends GeneralAction {
		function beforeExec() {
			parent::beforeExec();
			parent::$moduleName = "'.$post['txtModuleName'].'";
			parent::$isAdmin = true;
			parent::$btnAction = true;
			parent::$mapping = parent::generateMapping("'.$post['txtName'].'");
							
			parent::$prefix = "'.$post['txtDbPrefix'].'";
			parent::$table = "'.$post['txtDbName'].'";
			parent::$pathupload = "../Assets/img/";
		}
		protected function do_show() {
			parent::do_show("/Templates/Admin/default1Grid.html");
		}
	}';
		}else{
			$getHeader = Database::build()->getAllDbOne("SELECT mmphName, mmphDbDefault, mmphDbPrefix FROM master_mapping_header WHERE mmphId = '".$post['slTypeGrid']."'");
			$createFile = '<?php
	Class Controller_Admin_Master_'.$filename.' extends GeneralAction {
		function beforeExec() {
			parent::beforeExec();
			parent::$moduleName = "'.$post['txtModuleName'].'";
			parent::$isAdmin = true;
			parent::$btnAction = true;
			parent::$mapping = parent::generateMapping("'.$getHeader['mmphName'].'");
			parent::$prefix = "'.$getHeader['mmphDbPrefix'].'";
			parent::$table = "'.$getHeader['mmphDbDefault'].'";
			
			parent::$mappingDetail = parent::generateMapping("'.$post['txtName'].'");
			parent::$prefixDetail = "'.$post['txtDbPrefix'].'";
			parent::$tableDetail = "'.$post['txtDbName'].'";
			
			parent::$pathupload = "../Assets/img/";
		}
		protected function do_show() {
			parent::do_show("/Templates/Admin/default2Grid.html");
		}
	}';
		}
		return $createFile;
	}
	
	function generateField($field, $datatype, $type){
		switch($datatype) {
			case 'input' :
				$tb_type = "INT";
				if($type == 1) {
					$tb_type = "VARCHAR(200)";
				}
				$return = "`" . $field . "` " . $tb_type;
			break;
			case 'hidden' :
				$return = "`" . $field . "` INT";
			break;
			case 'combo' :
				$return = "`" . $field . "` VARCHAR(50)";
			break;
			case 'rbutton' :
				$return = "`" . $field . "` VARCHAR(10)";
			break;
			case 'mcombo' :
				$return = "`" . $field . "` VARCHAR(200)";
			break;
			case 'dpicker' :
				$return = "`" . $field . "` DATE";
			break;
			case 'tpicker' :
				$return = "`" . $field . "` TIME";
			break;
			case 'ufile' :
				$return = "`" . $field . "` VARCHAR(255)";
			break;
			case 'uimg' :
				$return = "`" . $field . "` VARCHAR(255)";
			break;
			case 'cbox' :
				$return = "`" . $field . "` VARCHAR(150)";
			break;
			case 'txtarea' :
				$return = "`" . $field . "` TEXT";
			break;
			case 'tiny' :
				$return = "`" . $field . "` TEXT";
			break;
		}
		return $return;
	}

}