bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

halohalo bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

<?php
include "dbc.php"; 
page_protect();
?>
<?php
if(isset($_POST['submit'])){
if($_POST['submit'] == "Submit"){
$id = mysqli_real_escape_string($link,$_POST['id']);
$autoid = mysqli_real_escape_string($link,$_POST['autoid']);
$date = mysqli_real_escape_string($link,$_POST['date']);
$type = mysqli_real_escape_string($link,$_POST['type']);
$amount = mysqli_real_escape_string($link,$_POST['amount']);
$payer_name = mysqli_real_escape_string($link,$_POST['payer_name']);
$category = mysqli_real_escape_string($link,$_POST['category']);
$payment_mode = mysqli_real_escape_string($link,$_POST['payment_mode']);
$description = mysqli_real_escape_string($link,$_POST['description']);
$status = mysqli_real_escape_string($link,$_POST['status']);
if(mysqli_query($link,"INSERT INTO `accounts_tbl` (`id`, `autoid`, `date`, `type`, `amount`, `payer_name`, `category`, `payment_mode`, `description`, `status`, `ip_address`, `browser`, `created_by`, `approved_by`) VALUES ('$id', '$autoid', '$date', '$type', '$amount', '$payer_name', '$category', '$payment_mode', '$description', '$status', '$ip_address', '$browser', '$created_by', '$approved_by')")){
$msg[] = "Successfully Saved!";
	}
	else
	{
		$err[] = "Error in saving data!";
	}
	}
	?>

<?php
if($_POST['submit'] == "Update"){
$id = mysqli_real_escape_string($link,$_POST['id']);
$autoid = mysqli_real_escape_string($link,$_POST['autoid']);
$date = mysqli_real_escape_string($link,$_POST['date']);
$type = mysqli_real_escape_string($link,$_POST['type']);
$amount = mysqli_real_escape_string($link,$_POST['amount']);
$payer_name = mysqli_real_escape_string($link,$_POST['payer_name']);
$category = mysqli_real_escape_string($link,$_POST['category']);
$payment_mode = mysqli_real_escape_string($link,$_POST['payment_mode']);
$description = mysqli_real_escape_string($link,$_POST['description']);
$status = mysqli_real_escape_string($link,$_POST['status']);
if(mysqli_query($link,"UPDATE `accounts_tbl` SET `id` = '$id', `autoid` = '$autoid', `date` = '$date', `type` = '$type', `amount` = '$amount', `payer_name` = '$payer_name', `category` = '$category', `payment_mode` = '$payment_mode', `description` = '$description', `status` = '$status', `ip_address` = '$ip_address', `browser` = '$browser', `created_by` = '$created_by', `approved_by` = '$approved_by' WHERE `autoid`='$autoid'")){$msg[] = "Successfully Saved!";
	}
	else
	{
		$err[] = "Error in saving data!";
	}
	}
}
?>
<?php include'header.php';?>
<script type="text/javascript" src="js/jquery.1.8.3.min.js"></script>
 
          <div class="main-bar">
            <h3>
              <i class="fa fa-plus"></i>&nbsp; Accounts</h3>
          </div>
        </header>
      </div>
      <?php include'admin_admin.php';?>
      <div id="content">
        <div class="outer">
          <div class="inner bg-light lter">
            <style>
              .form-control.col-lg-6 {
                width: 50% !important;
              }
            </style>
            <div class="row">
              <div class="col-lg-12">
                <div class="box">
                  <header class="dark">
                    <div class="icons">
                      <i class="fa fa-check"></i>
                    </div>
                    <h5>Add / Update Accounts</h5>
                    <div class="toolbar">
                      <div class="btn-group">
                      </div>
                    </div>

</header>
				  <div class="box-content">
             <?php include 'msg_display.php'; ?>
            <form class="form-horizontal" method="post" enctype="multipart/form-data" action="">
	<div class="box-body">
	
    <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 no-pad">
	<?php
	if(isset($_REQUEST['update'])){
	$autoid = mysqli_real_escape_string($link,$_GET['autoid']);
	$update = mysqli_real_escape_string($link,$_GET['update']);
	if($update == "yes"){
	$sel_row = mysqli_query($link,"select * from accounts_tbl where `autoid`='$autoid'");
	$row = mysqli_fetch_object($sel_row);
	$upload_id = $row->autoid;
	}
	}
	else
	{
		list($max_id) = mysqli_fetch_row(mysqli_query($link,"SELECT MAX(id) AS max FROM `accounts_tbl`"));
	$max_id=$max_id+1;
	$upload_id="acc-".$max_id;
	}
	?><input type="hidden" class="form-control" name="id" id="id" placeholder="Enter the id" value="<?php echo $row->id; ?>" readonly="readonly"    >
		<div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad">
			<div class="form-group">
				<div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad">
				<label for="autoid">Autoid</label>
				</div>
				<div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad">
				<input type="text" class="form-control" name="autoid" id="autoid" placeholder="Enter the Autoid" value="<?php echo $upload_id; ?>" readonly="readonly"    >
				</div>
			</div>
		</div>
		<div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad">
			<div class="form-group">
				<div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad">
				<label for="date">Date</label>
				</div>
				<div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad">
				<input type="date" class="form-control" name="date" id="date" placeholder="" value="<?php echo $row->date; ?>"     required="required">
				</div>
			</div>
		</div>
		<div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad">
			<div class="form-group">
				<div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad">
				<label for="type">Type</label>
				</div>
				<div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad">
   <select name="type" id="type" class="form-control"      required="required">
<option value="credit">Credit</option>
<option value="debit">Debit</option>
</select>
				</div>
			</div>
		</div>
		<div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad">
			<div class="form-group">
				<div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad">
				<label for="amount">Amount</label>
				</div>
				<div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad">
				<input type="text" class="form-control" name="amount" id="amount" placeholder="Enter the Amount" value="<?php if(isset($_REQUEST['update'])){ echo $row->amount; } ?>" required="required">
				</div>
			</div>
		</div>
		<div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad">
			<div class="form-group">
				<div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad">
				<label for="payer_name">Payer/Payee Name</label>
				</div>
				<div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad">
				<input type="text" class="form-control" name="payer_name" id="payer_name" placeholder="Select the Payer" value="<?php if(isset($_REQUEST['update'])){ echo $row->payer_name; } ?>" required="required">
				</div>
			</div>
		</div>
		<div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad">
			<div class="form-group">
				<div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad">
				<label for="category">Category</label>
				</div>
				<div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad">
   <select name="category" id="category" class="form-control"      required="required">
<?php
				$sel_rw = mysqli_query($link,"select accountcategory_name from accountcategory_tbl");
				while($row1 = mysqli_fetch_object($sel_rw)){
				?>

<option value="<?php echo $row1->accountcategory_name; ?>"><?php echo $row1->accountcategory_name; ?></option>

<?php } ?>
				</select>
				</div>
			</div>
		</div>
		<div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad">
			<div class="form-group">
				<div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad">
				<label for="payment_mode">Payment Mode</label>
				</div>
				<div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad">
   <select name="payment_mode" id="payment_mode" class="form-control"      required="required">
<option value="cash">Cash</option>
<option value="cheque">Cheque</option>
<option value="Online transfer">Online Transfer</option>
<option value="card">Card</option>
</select>
				</div>
			</div>
		</div>
		<div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad">
			<div class="form-group">
				<div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad">
				<label for="description">Description</label>
				</div>
				<div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad">
				<textarea class="form-control" name="description" id="description" placeholder="Enter the Description" required="required">
				<?php if(isset($_REQUEST['update'])){ echo $row->description; } ?></textarea>
				</div>
			</div>
        </div>
		<div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad">
			<div class="form-group">
				<div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad">
				<label for="status">Status</label>
				</div>
				<div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad">
   <select name="status" id="status" class="form-control"      >
<option value="active">Active</option>
<option value="disable">Disable</option>
</select>
				</div>
			</div>
		</div></div>
	</div>

</div>

</div>
	
			
		</div>
		</div>
		
	<div class="modal hide fade" id="myModal">
		<div class="modal-header">
			<button type="button" class="close" data-dismiss="modal">×</button>
			<h3>Settings</h3>
		</div>
		<div class="modal-body">
			<p>Here settings can be configured...</p>
		</div>
		<div class="modal-footer">
			<a href="#" class="btn" data-dismiss="modal">Close</a>
			<a href="#" class="btn btn-primary">Save changes</a>
		</div>
	</div>
                
            
          </div>
        </div>
      </div>
      
            <?php include "right-side.php";?>

    </div>
    <script src="js/jquery-1.9.1.min.js"></script>
    <script>
	  $(document).ready(function() {
	  	$("#stock_avail option[value='<?php echo $row->stock_avail; ?>']").attr("selected", "selected");
	   	$("#status option[value='<?php echo $row->status; ?>']").attr("selected", "selected");
	   	$("#type option[value='<?php echo $row->type; ?>']").attr("selected", "selected");
	  });
   	</script>
    <?php include'footer.php';?>