<?php
	require('_mod_security.php');

	form_prep('frm_import', 'basic_info');
	if (($_POST['form_submitted'] ?? '') === '1') :
		form_prep_submit();
		form_validate_all();
		if (!$err_flag) :
			$upload_dir = APP_UPLOAD_DIR . '/data_import/';
			if (!is_dir($upload_dir)) :
				mkdir($upload_dir, 0777, true);
			endif;
			$file_name = basename($_FILES['import_file']['name']);
			$upload_path = $upload_dir . $file_name;
			move_uploaded_file($_FILES['import_file']['tmp_name'], $upload_path);
			$form_message = "Data Import Job Submitted!";
			form_uid_reset();
			if ($_POST['xsubmit'] == 'Import') :
				echo "<SCRIPT>";
				echo '$(document).ready(function() {';
				echo "process_job('import_csv_data', 'import', '" . json_encode($_POST) . "', '" . $file_name . "');";
				echo '});';
				echo "</SCRIPT>";
				$active_tab = 'job_status';
			endif;
		else :
			$active_tab = $err_tab;
			$form_message = "Errors found!";
		endif;
	endif;
	
?>

<script>
	var active_page = '<?php echo $_REQUEST['IX']; ?>';
	var active_tab = '';
	
	$(document).ready(function() {
		switch_tab('<?php echo $active_tab; ?>');
		$(':input:not(.search, .no_dirty, .no_dirty input)').change(function() {sheet_dirty = true; } );
		setInterval(function() {
			if ($('#tab_content_job_status').is(':visible')) {
				lcs_db_load('db_grid_jobs', 'batch_job_ajax', 'grid', '', db_grid_jobs_sort_col, db_grid_jobs_sort_order, $('#db_grid_jobs_strSearch').val(), db_grid_jobs_parm1, db_grid_jobs_parm2, db_grid_jobs_parm3, db_grid_jobs_filter_cols, db_grid_jobs_multi_filter);
			}
		}, 60000);
		setInterval(function() {
			update_running_jobs('batch_import_csv');
		}, 2000);
	});
</script>

<h1>Data Import - CSV Events</h1>
<?php echo form_message($form_message); ?>

<form name="frm_import" id="frm_import" method="post" action="" enctype="multipart/form-data">
	<input name="form_submitted" type="hidden" value="1" />
	<input name="id" type="hidden" value="<?php echo $_REQUEST['id']; ?>" />
	<input name="active_tab" id="active_tab" type="hidden" value="basic_info" />
	<?php
		form_button_strip('top', [
			'save' => ['show' => false],
			'save_as' => ['show' => false],
			'save_close' => ['show' => false],
			'save_new' => ['show' => false],
			'import'=>['show'=>true, 'caption'=>'Import', 'js' => "sheet_dirty = false; document.getElementById('xsubmit').value = this.value; this.form.submit();"],
		]);
		form_tab_strip_start();
		form_tab_header('basic_info', 'Basic Info', 'admin,super');
		form_tab_header('job_status', 'Job Status', 'admin,super');
		form_tab_strip_end();
		//******************************************************************************************
		form_tab_start('basic_info', 'Basic Info');

		form_column_start();
		form_field(['fname'=>'import_file', 'ftype'=>'file', 'frequired'=>true, 'fdbname'=>'', 'flabel'=>'Select a CSV File', 'fclass'=>'no_dirty']);
		form_field(['fname'=>'import_column_names', 'ftype'=>'checkbox', 'frequired'=>false, 'fdbname'=>'', 'flabel'=>'CSV First Row Has Column Names', 'fclass'=>'no_dirty']);
		form_column_end();

		form_tab_end();

		//******************************************************************************************
		form_tab_start('job_status', 'Job Status');
		db_navigator_bar(['table_id' => 'db_grid_jobs', 'form' => '', 'btn_addnew'=>'false', 'print_section' => 'db_grid_jobs', 'call' => 'batch_job_ajax', 'sort_col' => '3', 'sort_order' => '1', 'parm1' => " AND bj.job_type = 'batch_import_csv' ", 'func' => 'grid']);
		form_tab_end();
		?>
		<div id="grid_popup" class="grid_popup" style="padding:18px!important;">
			<div style="position:absolute; right:0; top:0; padding:8px;">
				<a href="javascript:hide_job_output_details();">X</a>
			</div>
			<b><br>Job Output:</b>&nbsp;&nbsp;&nbsp;<br />
			<div id="grid_popup_contents">
			</div>
		</div>
		<?php

		form_button_strip('bottom', [
			'save' => ['show' => false],
			'save_as' => ['show' => false],
			'save_close' => ['show' => false],
			'save_new' => ['show' => false],
			'import'=>['show'=>true, 'caption'=>'Import', 'js' => "sheet_dirty = false; document.getElementById('xsubmit').value = this.value; this.form.submit();"],
		], false);
	?>
</form>