JezK

Edit File: uploadCommission.php

<?php 
$currentPage="commissions";
include("header.php");
if(isset($_SESSION['fileNotExists']))
{
	echo "<script>alert('Error!!! Unable to download file. File doesnot exists.');</script>";
	unset($_SESSION['fileNotExists']);
}
if(isset($_SESSION['fileUploadFailed']))
{
	echo "<script>alert('Error!!! Unable to upload file.');</script>";
	unset($_SESSION['fileUploadFailed']);
}
if(isset($_SESSION['emptyExcelFile']))
{
	echo "<script>alert('Error!!! Please enter some data and then upload the file.');</script>";
	unset($_SESSION['emptyExcelFile']);
}
if(isset($_SESSION['fileSaveFailed']))
{
	echo "<script>alert('Error!!! Unable to save commission upload file. Internal server error.');</script>";
	unset($_SESSION['fileSaveFailed']);
}
if(isset($_SESSION['saveFailed']))
{
	echo "<script>alert('Error!!! Unable to save data. Internal server error.');</script>";
	unset($_SESSION['saveFailed']);
}
if(isset($_SESSION['saveSuccess']))
{
	echo "<script>alert('Data saved successfully.');</script>";
	unset($_SESSION['saveSuccess']);
}
?>
        <div id="page-wrapper">

<div class="container-fluid">
                
                <div class="row">
                    <div class="col-lg-12">
                        <h1 class="page-header">
                            <small>Commissions Upload</small>
                        </h1>

</div>
                </div>
                
				
				<div class="row text-center">
					<div class="col-md-12">
						<a href="download.php?file=Disbursement.xlsx&type=1"><input type="button" value="Download sample excel sheet (Disbursement)" class="btn btn-default"> </a>
						<a href="download.php?file=Repayment.xlsx&type=1"><input type="button" value="Download sample excel sheet (Repayment)" class="btn btn-default"> </a>
					</div>
				</div>
			   		
				
                <div class="row">
					<div class="col-md-6 col-md-offset-3">
						<form action="app/commissionApp.php" onsubmit="return validate()" method="post" enctype="multipart/form-data">
							<div class="form-group col-md-12">
								<label  class="col-md-4 text-left">Month :</label>
								<select class="col-md-3 selectStyle" name="year" id="year">
									<option value="0">Select Year</option>
									<option value="2017">2017</option>
									<option value="2018">2018</option>
									<option value="2019">2019</option>
									<option value="2020">2020</option>
									<option value="2021">2021</option>
								</select>
								&nbsp;&nbsp;
								<select class="col-md-3 selectStyle" name="month" id="month">
									<option value="0">Select Month</option>
									<option value="1">January</option>
									<option value="2">February</option>
									<option value="3">March</option>
									<option value="4">Apirl</option>
									<option value="5">May</option>
									<option value="6">June</option>
									<option value="7">July</option>
									<option value="8">August</option>
									<option value="9">September</option>
									<option value="10">October</option>
									<option value="11">November</option>
									<option value="12">December</option>
								</select>
							</div>
							<div class="form-group col-md-12">
								<label class="col-md-4 text-left">Commission Type</label>
								<select name="commissionType" id="commissionType">
									<option value="1">Disbursement</option>
									<option value="2">Repayment</option>
								</select>
							</div>
							<div class="form-group col-md-12">
								<label class="col-md-4 text-left">Select File :</label>
								<input type="file" value="" id="commisionFile" name="commisionFile" class="browse-o" onchange="ValidateFileUpload('commisionFile')">
								<button type="button" class="browse-d">Browse</button>
								 <div id="fileUploadStatus" class="divSuccess"></div>
								
								<span class="path"></span>
							</div>
							<div class="text-center">
								<input type="submit" value="Submit" class="btn btn-cs">
							</div>
						</form>
					</div>
                </div>

</div>

</div>

<?php include("footer.php");?>
<script>
	$(document).ready(function(){
		$(".browse-d").click(function(){
			$(".browse-o").trigger("click");
		});
		});
excelFlag = 0;
function ValidateFileUpload(fileID)
{
	var fuData = document.getElementById(fileID);
	var FileUploadPath = fuData.value;
	var fileUploadStatus = document.getElementById('fileUploadStatus');
	//To check if user upload any file
	if (FileUploadPath == '') 
	{
		alert("Please upload a xls/xlsx file.");
		fileUploadStatus.innerHTML ='<span class="fail"></span>';
		return false;
	} 
	else 
	{
		var Extension = FileUploadPath.substring(
		FileUploadPath.lastIndexOf('.') + 1).toLowerCase();

//The file uploaded is an pdf
		if (Extension == "xls" || Extension == "xlsx") 
		{
			var size=1048576;
			var file_size=fuData.files[0].size;
			if(file_size>=size)
			{
				alert('File too large. Please upload a file less than 1 MB.');
				fileUploadStatus.innerHTML ='<span class="fail"></span>';
				return false;
			}
			else
			{
				excelFlag = 1;
				fileUploadStatus.innerHTML ='<span class="success"></span>';
				return true;
			}
		} 
		//The file upload is NOT an pdf
		else 
		{
			alert("Please upload a xls/xlsx file.");
			fileUploadStatus.innerHTML ='<span class="fail"></span>';
			return false;
		}
	}
}