1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / mfms22 / demo.mfmsbd.com /
Filename : books_expense.php
back
<?php
	require 'functions.php';
	checkLogin();
	$db_link = connect();
	$timestamp = time();
	
	//NEW EXPENDITURE-Button
	if(isset($_POST['expnew'])){
		
		//Sanitize user input
		$exptype_id = sanitize($db_link, $_POST['exptype_id']);
		$exp_amount = sanitize($db_link, $_POST['exp_amount']);
		$exp_date = strtotime(sanitize($db_link, $_POST['exp_date']));
		$exp_text = sanitize($db_link, $_POST['exp_text']);
		$exp_recipient = sanitize($db_link, $_POST['exp_recipient']);
		$exp_receipt = sanitize($db_link, $_POST['exp_receipt']);
		$expbranch_id = sanitize($db_link, $_POST['expbranch_id']);
		$exp_voucher = sanitize($db_link, $_POST['exp_voucher']);
		
		//Insert into expenses
		// $sql_expnew = "INSERT INTO expenses (exptype_id, exp_amount, exp_date, exp_text, exp_recipient, exp_receipt, exp_voucher, exp_created, user_id) VALUES ('$exptype_id', '$exp_amount', '$exp_date','$exp_text', '$exp_recipient', '$exp_receipt', '$exp_voucher', '$timestamp', '$_SESSION[log_id]')";
		$sql_expnew = "INSERT INTO expenses (exptype_id, exp_amount, exp_date, exp_text, exp_recipient, exp_receipt, expbranch_id, exp_voucher, exp_created, user_id) VALUES ('$exptype_id', '$exp_amount', '$exp_date','$exp_text', '$exp_recipient', '$exp_receipt', $expbranch_id, '$exp_voucher', '$timestamp', '$_SESSION[log_id]')";
		$query_expnew = mysqli_query($db_link, $sql_expnew);
		checkSQL($db_link, $query_expnew);
	}
			
	//Select recent expenses from EXPENSES
	//Select recent expenses from EXPENSES
	if($_SESSION['branch_id']) {
        $branch_id = $_SESSION['branch_id'];

        $sixtydays = time() - convertDays(60);
		$sql_expcur = "SELECT * FROM expenses LEFT JOIN exptype ON expenses.exptype_id = exptype.exptype_id LEFT JOIN branch ON branch.branch_id=expenses.expbranch_id WHERE exp_date > $sixtydays AND expbranch_id= $branch_id ORDER BY exp_date DESC, exp_voucher DESC";
	$query_expcur = mysqli_query($db_link, $sql_expcur);
	// checkSQL($db_link, $query_expcur);
    }else{

    	$sixtydays = time() - convertDays(60);
		$sql_expcur = "SELECT * FROM expenses LEFT JOIN exptype ON expenses.exptype_id = exptype.exptype_id LEFT JOIN branch ON branch.branch_id=expenses.expbranch_id WHERE exp_date > $sixtydays ORDER BY exp_date DESC, exp_voucher DESC";
		$query_expcur = mysqli_query($db_link, $sql_expcur);
    }
	
	//Select types of expenses from EXPTYPE
	$sql_exptype = "SELECT * FROM exptype ORDER BY exptype_type";
	$query_exptype = mysqli_query($db_link, $sql_exptype);
	checkSQL($db_link, $query_exptype);
// Select Branch
	if($_SESSION['branch_id']){
$branch_id = $_SESSION['branch_id'];
$sql_branch = "SELECT * FROM branch WHERE branch_id= $branch_id";
$query_branch = mysqli_query($db_link, $sql_branch)OR DIE("Query Faild");
checkSQL($db_link, $query_branch);
$branch_name= mysqli_fetch_assoc($query_branch);
}else{
//Select Branch for Drop-down-Menu
$sql_branch = "SELECT * FROM branch";
$query_branch = mysqli_query($db_link, $sql_branch);
checkSQL($db_link, $query_branch);
}
?>
<script>
	function validate(form){
		fail = validateDate(form.exp_date.value)
		fail += validateAmount(form.exp_amount.value)
		fail += validateRecipient(form.exp_recipient.value)
		fail += validateVoucher(form.exp_voucher.value)
		if (fail == "") return true
		else { alert(fail); return false }
	}
</script>
<script src="functions_validate.js"></script>
<script src="function_randCheck.js"></script>
<?php headandmenu('Expenses', '2a'); ?>
<!--main content start-->
<section id="main-content">
	<section class="wrapper" style="min-height: 850px;">
		
		<!--breadcrumbs start -->
		<div class="row">
			<div class="col-lg-12 pb-4">
				<!--breadcrumbs start -->
				<nav aria-label="breadcrumb">
					<ol class="breadcrumb">
						<li class="breadcrumb-item"><a href="start.php"><i class="fa fa-home"></i> Dashboard</a></li>
						<li class="breadcrumb-item"><a href="#">Accounting</a></li>
						<li class="breadcrumb-item active" aria-current="page">Expenses</li>
					</ol>
				</nav>
			</div>
		</div>
		<!--breadcrumbs end -->
		
		
	
		<!-- Responsive Form -->
		<div class="row">
			<div class="col-md-5">
				
				<section class="card">
					<div class="card-header"><h3>New Expense</h3></div>
					<div class="card-body">
						<form action="books_expense.php" method="post" onSubmit="return validate(this)">
							<div class="form-row">
								<div class="col-md-4 mb-3">
									<label for="validationCustom01">Date</label>
									<input type="text" id="datepicker" name="exp_date" value="<?PHP echo date("d.m.Y", $timestamp); ?>" class="form-control" id="validationCustom01" placeholder="" required>
								</div>
								<div class="col-md-4 mb-3">
									<label>Type</label>
									<select name="exptype_id" class="form-control">
										<?PHP
										while ($row_exptype = mysqli_fetch_assoc($query_exptype)){
											echo '<option value="'.$row_exptype['exptype_id'].'">'.$row_exptype['exptype_type'].'</option>';
										}
										?>
									</select>
								</div>
								
								<div class="col-md-4 mb-3">
									<label for="validationCusto03">Ammount</label>
									<input type="number" name="exp_amount" placeholder="<?PHP echo $_SESSION['set_cur']; ?>" class="form-control" id="validationCusto03">	
								</div>
							</div>
							<div class="form-row">
								<div class="col-md-4 mb-3">
									<label>Paid to</label>
									<input type="text" name="exp_recipient" class="form-control">
								</div>
								<div class="col-md-4 mb-3">
									<label>Voucher No</label>
									<input type="text" name="exp_voucher" class="form-control">
								</div>
								
								<div class="col-md-4 mb-3">
									<label>Receipt No</label>
									<input type="text" name="exp_receipt" placeholder="if any" class="form-control" required>
								</div>
							</div>
							<div class="form-row">
								<div class="col-md-8 mb-3">
									<label>Details</label>
									<input type="text" name="exp_text" class="form-control">
								</div>
								<div class="col-md-4 mb-3">
									<label>Branch</label>
									<select name="expbranch_id" class="form-control">
										<?php
										if($_SESSION['branch_id']){?>
										<option value="<?php echo $_SESSION['branch_id']; ?>"><?php echo $branch_name['branch_name']; ?></option>
										<?php
										}else{
										while ($row_branch = mysqli_fetch_assoc($query_branch)){
										echo '<option value="'.$row_branch['branch_id'].'">'.$row_branch['branch_name'].'</option>';
										}
										}
										?>
										
									</select>
								</div>
								
								
							</div>
							<input type="submit" name="expnew" value="New Entry" class="btn btn-primary" />
						</form>
					</div>
				</section>
				
			</div>

			<!-- RIGHT SIDE: Recent Expenses -->
			<div class="col-md-7">
				
				<div class="table-responsive">
					<table id="tb_table">
						<tr>
							<th class="title" colspan="8">Recent Expenses</th>
						</tr>
						<tr>
							<th>Date</th>
							<th>Type</th>
							<th>Amount</th>
							<th>Paid to</th>
							<th>Details</th>
							<th>Voucher</th>
							<th>Branch</th>
							<th>Delete</th>
						</tr>
						<?PHP
						while ($row_expcur = mysqli_fetch_assoc($query_expcur)){
							if ($row_expcur['cust_id'] != 0 AND $row_expcur['cust_id'] != NULL){
								$result_cust = getCustomer($db_link, $row_expcur['cust_id']);
								$exp_recipient = $result_cust['cust_name'].' (<a href="customer.php?cust='.$row_expcur['cust_id'].'">'.$result_cust['cust_no'].'</a>)';
							}
							else $exp_recipient = $row_expcur['exp_recipient'];
								echo '<tr>
																<td>'.date("d.m.Y",$row_expcur['exp_date']).'</td>
																<td>'.$row_expcur['exptype_type'].'</td>
																<td>'.number_format($row_expcur['exp_amount']).' '.$_SESSION['set_cur'].'</td>
																<td>'.$exp_recipient.'</td>
																<td>'.$row_expcur['exp_text'].'</td>
																<td>'.$row_expcur['exp_voucher'].'</td>
																<td>'.$row_expcur['branch_name'].'</td>
																<td>';
																					if ($_SESSION['log_delete'] == 1) echo '<a href="books_expense_del.php?exp_id='.$row_expcur['exp_id'].'" onClick="return randCheck();" ><i class="fa fa-remove fa-lg"></i></a>';
																	echo '	</td>
										</tr>';
						}
						?>
					</table>
				</div>
			</div>
		</div>
	</section>
</section>
<!--main content end-->
<!-- Footer -->
<?php footer(); ?>