iComsium
<?php
include("include/config.php");
include("include/checklog.php");
if(isset($_POST["businesspartner"]))
{
$businesspartner=mysqli_real_escape_string($conn,$_POST["businesspartner"]);
$serreqdate=mysqli_real_escape_string($conn,$_POST["serreqdate"]);
$serschdate=mysqli_real_escape_string($conn,$_POST["serschdate"]);
$serdelvdate=mysqli_real_escape_string($conn,$_POST["serdelvdate"]);
$nohivtohervst=mysqli_real_escape_string($conn,$_POST["nohivtohervst"]);
$hrvstyldprhiv=mysqli_real_escape_string($conn,$_POST["hrvstyldprhiv"]);
$flatfee=mysqli_real_escape_string($conn,$_POST["flatfee"]);
$pkg=mysqli_real_escape_string($conn,$_POST["pkg"]);
//$mdp=mysqli_real_escape_string($conn,$_POST["mdp"]);
$service1=mysqli_real_escape_string($conn,$_POST["service1"]);
$servrental=mysqli_real_escape_string($conn,$_POST["servrental"]);
$memberquote=mysqli_real_escape_string($conn,$_POST["memberquote"]);
$hquote=mysqli_real_escape_string($conn,$_POST["hquote"]);
$sql="update `service_request` set `business_partner_number`='".$businesspartner."',`request_date`='".$serreqdate."',`schedule_date`='".$serschdate."',`delivery_date`='".$serdelvdate."',`no_hives_hervest`='".$nohivtohervst."',`hervest_yield_pr_hive`='".$hrvstyldprhiv."',`service_extract`='".$service1."',`member_quote`='".$memberquote."',`service_rental`='".$servrental."',`quote`='".$hquote."',`flat_fees`='".$flatfee."',`pr_kg_fee`='".$pkg."' where id='".base64_decode($_GET["id"])."' ";
mysqli_query($conn,$sql);
$success_msg="Service Request update success";
}
?>
<?php include("include/header.php"); ?>
<!-- /.navbar -->
<!-- Main Sidebar Container -->
<?php include("include/sidebar.php"); ?>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<div class="content-header">
<div class="container-fluid">
<div class="row mb-2">
<div class="col-sm-6">
<h1 class="m-0 text-dark">Edit Service Request </h1>
<?php if(isset($success_msg)){ ?><p style="color:red;"><?php echo $success_msg; ?></p> <?php } ?>
</div><!-- /.col -->
<div class="col-sm-6">
<ol class="breadcrumb float-sm-right">
<li class="breadcrumb-item"><a href="#">Home</a></li>
<li class="breadcrumb-item active"><a href="logout.php">Logout</a></li>
</ol>
</div><!-- /.col -->
</div><!-- /.row -->
</div><!-- /.container-fluid -->
</div>
<!-- /.content-header -->
<!-- Main content -->
<section class="content">
<div class="container-fluid">
<!-- Small boxes (Stat box) -->
<!-- /.row -->
<!-- Main row -->
<div class="row">
<!-- left column -->
<div class="col-md-9">
<!-- general form elements -->
<div class="card card-primary">
<div class="card-header">
<h3 class="card-title">Enter details</h3>
</div>
<!-- /.card-header -->
<!-- form start -->
<?php
$sql3="select *from `service_request` where id='".base64_decode($_GET["id"])."' ";
$result3=mysqli_query($conn,$sql3);
$row3=mysqli_fetch_assoc($result3);
?>
<form role="form" action="" method="post" enctype="multipart/form-data" >
<div class="card-body">
<div class="form-group">
<label for="exampleInputEmail1"> Select Business Partner </label>
<select name="businesspartner" class="form-control">
<?php
$sql="select *from `register_user` ";
$result=mysqli_query($conn,$sql);
while($row=mysqli_fetch_assoc($result))
{
?>
<option value="<?php echo $row["business_partner_number"]; ?>" <?php if($row3["business_partner_number"]==$row["business_partner_number"]) echo "selected"; ?> ><?php echo $row["business_partner_number"]; ?></option>
<?php } ?>
</select>
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Service Type </label>
<select name="service1" class="form-control" onchange="getservicefees(this.value);" >
<option value="0" >--select--</option>
<?php
$sql="select *from `service_extract` ";
$result=mysqli_query($conn,$sql);
while($row=mysqli_fetch_assoc($result))
{
?>
<option value="<?php echo $row["id"]; ?>" <?php if($row3["service_extract"]==$row["id"]) echo "selected"; ?> ><?php echo $row["service_name"]; ?></option>
<?php } ?>
</select>
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Service Request Date </label>
<input type="date" name="serreqdate" id="serreqdate" value="<?php echo $row3["request_date"]; ?>" class="form-control" required>
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Service Schedule Date </label>
<input type="date" name="serschdate" id="serschdate" value="<?php echo $row3["schedule_date"]; ?>" class="form-control" required>
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Service Delivery Date </label>
<input type="date" name="serdelvdate" id="serdelvdate" value="<?php echo $row3["delivery_date"]; ?>" class="form-control" required>
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Number of Hives to Harvest </label>
<input type="text" name="nohivtohervst" id="nohivtohervst" value="<?php echo $row3["no_hives_hervest"]; ?>" class="form-control" onkeyup="getquote(this.value);" required>
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Harvest yield per Hive </label>
<input type="text" name="hrvstyldprhiv" id="hrvstyldprhiv" value="<?php echo $row3["hervest_yield_pr_hive"]; ?>" class="form-control" onkeyup="getquote(this.value);" required>
</div>
<div id="allservicevalue" >
<div class="form-group">
<label for="exampleInputEmail1"> <?php echo $row2["service_name"]; ?> Fees</label>
<input type="text" name="flatfee" id="flatfee" value="<?php echo $row3["flat_fees"]; ?>" class="form-control" >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> per Kg fee </label>
<input type="text" name="pkg" id="pkg" value="<?php echo $row3["pr_kg_fee"]; ?>" class="form-control" >
</div>
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Service Rental </label>
<input type="text" name="servrental" id="servrental" value="<?php echo $row3["service_rental"]; ?>" class="form-control" >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Members Quote </label>
<input type="text" name="memberquote" id="memberquote" value="<?php echo $row3["member_quote"]; ?>" class="form-control" >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Quote </label>
<input type="text" name="hquote" id="hquote" value="<?php echo $row3["quote"]; ?>" class="form-control" >
</div>
</div>
<!-- /.card-body -->
<div class="card-footer">
<button type="submit" class="btn btn-primary">Submit</button>
</div>
</form>
</div>
<!-- /.card -->
<!-- Form Element sizes -->
<!-- /.card -->
<!-- /.card -->
<!-- Input addon -->
<!-- /.card -->
<!-- Horizontal Form -->
<!-- /.card -->
</div>
<!--/.col (left) -->
<!-- right column -->
<!--/.col (right) -->
</div>
<!-- /.row (main row) -->
</div><!-- /.container-fluid -->
</section>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->
<?php include("include/footer.php"); ?>
<!-- Include Date Range Picker -->
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.4.1/js/bootstrap-datepicker.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.4.1/css/bootstrap-datepicker3.css"/>
<script>
$(document).ready(function(){
var today = new Date(new Date().getFullYear(), new Date().getMonth(), new Date().getDate());
var date_input=$('input[name="date"]'); //our date input has the name "date"
//var date_input=document.getElementById("transdate");
var container=$('.card-primary form').length>0 ? $('.card-primary form').parent() : "body";
date_input.datepicker({
format: 'mm/dd/yyyy',
container: container,
todayHighlight: true,
autoclose: true,
minDate: today,
})
})
function setleasend(a)
{
var b=document.getElementById("leasestartdate").value;
$.post('calculatedate.php', {
d: b, // Use fname.value
m: a // Use lname.value
}).done(function (msg) {
//alert(msg);
//location.reload();
document.getElementById("leaseenddate").value=msg;
});
}
function getquote(a)
{
var flatfee=document.getElementById("flatfee").value;
var pkg=document.getElementById("pkg").value;
var nohivtohervst=document.getElementById("nohivtohervst").value;
var hrvstyldprhiv=document.getElementById("hrvstyldprhiv").value;
$.post('getquote.php', {
flatfee: flatfee, // Use fname.value
pkg: pkg, // Use lname.value
nohives: nohivtohervst, // Use fname.value
yldphiv: hrvstyldprhiv // Use fname.value
}).done(function (msg) {
//alert(msg);
//location.reload();
document.getElementById("hquote").value=msg;
});
}
function getservicefees(a)
{
$.post('getservicefees.php', {
stype: a
}).done(function (msg) {
//alert(msg);
//location.reload();
document.getElementById("allservicevalue").innerHTML =msg;
$("#allservicevalue").show();
document.getElementById("nohivtohervst").value="";
document.getElementById("hrvstyldprhiv").value="";
});
}
</script>