<?php 
include("includes/FCKeditor/fckeditor.php");
$file_name		= "index?page=view";
$form_action	= "insert";
$button_value 	= "Add";
$table_name 	= "product_group";
$page_name      = "Add Product Group";
$id	 = "";
$vat = "";
$query_string = "";
################################################## START INSERT ##################################################
if(isset($_REQUEST['action']) && $_REQUEST['action'] == 'insert'){	
	utility::addslashesOnAllInput(array("query_string"));
	
    $product_group_name	= $_REQUEST['product_group_name']; 
    $product_short_code	= $_REQUEST['product_short_code'];
	$nominal_code	    = $_REQUEST['nominal_code'];
	
	$updated_by		= $_SESSION['user_id'];
	$created_by		= $_SESSION['user_id'];
	$created_on = date('Y-m-d H:i:s');
	
    $sql= "INSERT INTO $table_name (product_group_name,product_short_code,nominal_code,created_by,created_on) VALUES('$product_group_name','$product_short_code','$nominal_code','$created_by','$created_on')";
    mysqli_query($conn,$sql);
	
	$tmp = ucfirst(str_replace("_"," ", $table_name));
	$_SESSION['info_message'] = "$tmp added successfully";
    header("Location: $file_name");
    exit();
}
################################################# END INSERT #################################################

################################################## START EDIT ##################################################
if(isset($_REQUEST['action']) && $_REQUEST['action'] == 'edit'){	
	$id = $_REQUEST['id'];

	$form_action 	= "update";
	$button_value 	= "Update";
	$page_name      = "Edit Product Group";
	$query_string 	=  (isset($_POST['query_string'])) ? $_POST['query_string'] : $_SERVER['QUERY_STRING'];
	
	
    $sql= "SELECT * FROM $table_name WHERE id = $id";
    $result_edit = mysqli_query($conn,$sql);
    $row_edit = mysqli_fetch_array($result_edit);
	
	$product_group_name 					= $row_edit['product_group_name']; 
	$product_short_code 					= $row_edit['product_short_code']; 
	$nominal_code   		   				= $row_edit['nominal_code']; 
	
}
################################################# END EDIT ################################################# 


################################################## START UPDATE ################################################## 
if(isset($_REQUEST['action']) && $_REQUEST['action'] == 'update'){    
	utility::addslashesOnAllInput(array("query_string"));
	 
	$id								= $_REQUEST['id'];
	$product_group_name 			= $_REQUEST['product_group_name'];
	$product_short_code 			= $_REQUEST['product_short_code'];
	$nominal_code 	        		= $_REQUEST['nominal_code'];
	
	$sql= "UPDATE $table_name SET product_group_name = '$product_group_name' ,product_short_code = '$product_short_code', nominal_code = '$nominal_code', updated_by = '$updated_by' WHERE id = $id";
    mysqli_query($conn,$sql);
	
	$query_string = (isset($_REQUEST['query_string']) && !empty($_REQUEST['query_string'])) ? $_REQUEST['query_string'] : "";
  	$query_string = str_ireplace("page=add", "page=view", $query_string);
	$query_string = "&".$query_string;
	$tmp = ucfirst(str_replace("_"," ", $table_name));
	$_SESSION['info_message'] = "$tmp updated successfully";
    header("Location: $file_name$query_string");
    exit();
}
################################################# END UPDATE ################################################# 
?>
<style>
em{color:red;font-size: 20px;position: absolute;}
</style>
<section class="content-header">
	<div class="container-fluid">
		<div class="row mb-2">
			<div class="col-sm-6">
				<h1>
					<?=$page_name;?>
				</h1>
			</div>
			<div class="col-sm-6">
			<?
			$query_string 	=  (isset($_POST['query_string'])) ? $_POST['query_string'] : $_SERVER['QUERY_STRING'];
			$query_string = str_ireplace("page=add", "page=view", $query_string);	
			?>
			<button type="button" id="back" name="back" value="back"  style="float:right;margin-right:5px;margin-bottom:8px;" class="btn btn-primary" onclick="window.location.href = 'index?<?=$query_string;?>'">Back</button>
			</div>
		</div>
	</div>
</section>
<section class="content">
	<div class="container-fluid">
	<div class="row">
		<div class="col-lg-12">
			<!-- general form elements -->
              <div class="card box-primary">
                <form class="form-horizontal" method="post" name="form1" id="form1" action="index?page=add&action=<? echo $form_action; ?>" onsubmit="return validateForm(this)" enctype="multipart/form-data">
                  <div class="card-body">
                    <div class="form-group">
                       <label for="product_group_name" class=" control-label"> Product Group Name<em>*</em></label>
                      <div class="">
                        <input type="text" id="product_group_name" name="product_group_name" value="<?php echo $product_group_name;?>" class="form-control" placeholder="Enter Product Group Name" required>
						<span style="inline:block;color:red;display:none;" id="product_group_name_check"></span>
                      </div>
                    </div>
					<div class="form-group">
                      <label for="product_short_code" class=" control-label">Product Group Short Code<em>*</em></label>
                      <div class="">
                        <input type="text" id="product_short_code" name="product_short_code" value="<?php echo $product_short_code;?>" class="form-control" placeholder="Enter Product Group Short Code" required>
                      </div>
                    </div>
					<div class="form-group"> 
						<label class="control-label">Nominal Code<em>*</em></label> 
						<? $gsi->getNominalCodeList("nominal_code",$nominal_code,"100%",false,"form-control select2","required","",""); ?>
					</div>
                  </div><!-- /.box-body -->
                  <div class="card-footer">
					<input type="hidden" id="id" name="id" value="<?php echo $id;?>">
					<input type="hidden" id="query_string" name="query_string" value="<?php echo $query_string;?>">
                    <button type="submit" id="submit" name="submit" value="<?php echo $button_value;?>" class="btn btn-primary">Submit
						<i class="fas fa-sync-alt fa-spin" style="display:none;" id="page_load_div"></i>
					</button>
                  </div>
                </form>
              </div><!-- /.box -->
		</div>
	</div>
	</div>
</section>
<script type="text/javascript">
$(function(){
	$('#form1').submit(function(){
		$("#submit").attr("disabled", true);
		$('#page_load_div').show();
	});
});
</script>