MAINHACK

Viewing / Editing File: test.php

<?php include 'header.php' ;

$show=new Oops($db);
?>
<style type="text/css">

#fli,#fli1
	{
	
	}
	#display
	{
		position:absolute;
		width:315px;
		margin-left:0;
		margin-top:0px;
		max-height:300px;
		padding:2px;
		display:none;
		border-top:0px;
		overflow:auto;
		border:1px #CCC solid;
		background-color: white;
		z-index:1000;
	}	
	
	.show,.show1
	{
		padding:7px; 
		border-bottom:1px #999 dashed;
		font-size:15px; 
		
	}
	
	.show:hover,.show1:hover
	{
		background:#4f52ba;
		color:#FFF;
		cursor:pointer;
	}	
.widget{
	overflow:visible !important;
	
}    .blinking{
    animation:blinkingText 1.2s infinite;
}
@keyframes blinkingText{
    0%{     color: #fff;    }
    49%{    color: #fff; }
    60%{    color: transparent; }
    99%{    color:transparent;  }
    100%{   color: #fff;    }
}	
</style>
>
      	<div id="page-wrapper">
			<div class="main-page">
				<div class="row">
    <?php if($cash_status=='ALLOTED'){?>
    <span class="blinking" style="float:left;color: #fff;padding:0px 10px 5px 5px;;font-weight:bold;font-size:15px;background-color:#73df73">PLEASE CHANGE THE ALLOTED STATUS TO RECEIVED BEFORE USING THE PETTY CASH</span>
    <?php } ?>
                        <div class="form-grids row widget-shadow" data-example-id="basic-forms"> 
						<div class="form-title">
							<h4>Add Expense :</h4>
						</div>
						<div class="form-body">
							<form method="post"  enctype="multipart/form-data"> 
                        <div class="col-md-4">
								<div class="form-group">
									<label>Alloted Amount</label>
									<input type="text" class="form-control" id="com_name" value="<?=$amount?>" readonly>
								</div>
							</div>			
							<div class="col-md-4">
								<div class="form-group">
									<label>Balance</label>
									<input type="text" class="form-control" id="com_name" value="<?=$total?>" readonly>
								</div>
							</div>
                            <div class="col-md-4">
								<div class="form-group">
									<label>Expense Head</label>
                            <select name="expense_head"  class="form-control" required>
									    <option value="">Choose</option>
									 <?php 
									 $stmt=$show->state('expense_head');
									 $r=$stmt->rowCount();
									 if($r>0){
                                     while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
									    echo "<option value='".$row['category']."'>".$row['category']."</option>";
    									}
    									}
									 ?>   
									</select>								</div>
							</div>	  
							 <div class="col-md-4">
								<div class="form-group">
									<label>Expense Group</label>
                            <select name="exp_group"  class="form-control" required>
									    <option value="">Choose</option>
									 <?php 
									 $stmt=$show->state('expense_group');
									 $r=$stmt->rowCount();
									 if($r>0){
                                     while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
									    echo "<option value='".$row['ep_group']."'>".$row['ep_group']."</option>";
    									}
    									}
									 ?>   
									</select>								</div>
							</div>	  
							<div class="col-md-4">
								<div class="form-group">
									<label>Expense Amount</label>
									<input type="text" class="form-control" id="com_name" name="cash" placeholder="Add Amount" required>
								</div>
							</div>							
 	                <div class="col-md-12">
								<div class="form-group">
									<label>Comment</label>
									<input type="text" class="form-control" id="com_name" name="comm" placeholder="Add Amount" required>
								</div>
							</div>                       
						<button type="submit" class="btn btn-info btn-fill pull-right" name="sub">Submit</button>
						<div class="clearfix"></div>
                                    </form>
<?php
if(isset($_POST['sub'])){
	
	$table='petty_cash';

$cash=htmlentities(strip_tags($_POST['cash']));
    $total1=$total-$cash;

$data=array(	
	'date'=>date('Y-m-d'),
	'added_by'=>$_SESSION['employee_id'],
	'site_id'=>$site_id,
	'site_name'=>$site,
	'cash'=>$cash,
	'alloted_cash'=>$amount,
	'comment'=>htmlentities(strip_tags($_POST['comm'])),
	'total'=>$total1,
	'status'=>'DEBIT',
	'prev'=>$total,
	'employee_id'=>$_SESSION['employee_id'],
	'employee_name'=>$_SESSION['login_user'],
	'expense_head'=>htmlentities(strip_tags($_POST['expense_head'])),
	'exp_group'=>htmlentities(strip_tags($_POST['exp_group'])),
	'emp_sl_no'=>$_SESSION['emp_serial_no']
	);
    $r=$show->insert($table,$data);
    if($r){
       
		echo "<script>sweetAlert('Ok','Daily expense has been updated','success');</script>";

}else{
	echo "ss";
}
	
}
?>
									
                                </div>
                            </div>
                            </div>
                            </div>
                          </div>
         
<?php include 'footer.php' ?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: test.php

Server Info

System Features

User Info