iComsium
<?php
include("include/config.php");
include("include/checklog.php");
if(isset($_POST["businesspartner"]))
{
$businesspartner=mysqli_real_escape_string($conn,$_POST["businesspartner"]);
$conaccno=mysqli_real_escape_string($conn,$_POST["conaccno"]);
$contractno=mysqli_real_escape_string($conn,$_POST["contractno"]);
$startdate=mysqli_real_escape_string($conn,$_POST["startdate"]);
$enddate=mysqli_real_escape_string($conn,$_POST["enddate"]);
$hiveassignment=mysqli_real_escape_string($conn,$_POST["hiveassignment"]);
$yield=mysqli_real_escape_string($conn,$_POST["yield"]);
$yieldum=mysqli_real_escape_string($conn,$_POST["yieldum"]);
$harvestdate=mysqli_real_escape_string($conn,$_POST["harvestdate"]);
$biosecuritystandard=mysqli_real_escape_string($conn,$_POST["biosecuritystandard"]);
$beehealth=mysqli_real_escape_string($conn,$_POST["beehealth"]);
$contractcompliance=mysqli_real_escape_string($conn,$_POST["contractcompliance"]);
$beeyrdmaintn=mysqli_real_escape_string($conn,$_POST["beeyrdmaintn"]);
$hervestweight=mysqli_real_escape_string($conn,$_POST["hervestweight"]);
$score=mysqli_real_escape_string($conn,$_POST["score"]);
$rate=mysqli_real_escape_string($conn,$_POST["rate"]);
$gatefee=mysqli_real_escape_string($conn,$_POST["gatefee"]);
$gateremitance=mysqli_real_escape_string($conn,$_POST["gateremitance"]);
$remitancedate=mysqli_real_escape_string($conn,$_POST["remitancedate"]);
$remitanceref=mysqli_real_escape_string($conn,$_POST["remitanceref"]);
$contactprice=mysqli_real_escape_string($conn,$_POST["contactprice"]);
$currency=mysqli_real_escape_string($conn,$_POST["currency"]);
$contractpayment=mysqli_real_escape_string($conn,$_POST["contractpayment"]);
$contactpaydate=mysqli_real_escape_string($conn,$_POST["contactpaydate"]);
$contactpayref=mysqli_real_escape_string($conn,$_POST["contactpayref"]);
$syndicateprofit=mysqli_real_escape_string($conn,$_POST["syndicateprofit"]);
$totalyield=mysqli_real_escape_string($conn,$_POST["totalyield"]);
$profitsharing=mysqli_real_escape_string($conn,$_POST["profitsharing"]);
$sharedprofit=mysqli_real_escape_string($conn,$_POST["sharedprofit"]);
$dividend=mysqli_real_escape_string($conn,$_POST["dividend"]);
$dividendpaydate=mysqli_real_escape_string($conn,$_POST["dividendpaydate"]);
$sql="update `hand` set `business_partner_number`='".$businesspartner."',`contract_account_number`='".$conaccno."',`contract_number`='".$contractno."',`start_date`='".$startdate."',`end_date`='".$enddate."',`hive_assignment`='".$hiveassignment."',`yield`='".$yield."',`yield_unite_of_measure`='".$yieldum."',`harvest_date`='".$harvestdate."',`bio_security_standerd`='".$biosecuritystandard."',`bee_health`='".$beehealth."',`contract_compliance`='".$contractcompliance."',`bee_yard_maintenance`='".$beeyrdmaintn."',`harvest_weight`='".$hervestweight."',`score`='".$score."',`rate`='".$rate."',`gate_fee`='".$gatefee."',`gate_remittance`='".$gateremitance."',`remittance_date`='".$remitancedate."',`remittance_referance`='".$remitanceref."',`contract_price`='".$contactprice."',`currency`='".$currency."',`contract_payment`='".$contractpayment."',`contract_payment_date`='".$contactpaydate."',`contract_payment_referance`='".$contactpayref."',`syndicate_profite`='".$syndicateprofit."',`total_yield`='".$totalyield."',`profit_sharing`='".$profitsharing."',`shared_profit`='".$sharedprofit."',`dividend`='".$dividend."',`dividend_payment_date`='".$dividendpaydate."' where id='".base64_decode($_GET["id"])."' ";
mysqli_query($conn,$sql);
$success_msg="Hand 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 Hand </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 `hand` 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"> Business Partner </label>
<select name="businesspartner" class="form-control" onchange="getcontract(this.value);" >
<option value="0">--select--</option>
<?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 id="bp" >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Start Date </label>
<input type="date" name="startdate" id="startdate" value="<?php echo $row3["start_date"]; ?>" class="form-control" required>
</div>
<div class="form-group">
<label for="exampleInputEmail1"> End Date </label>
<input type="date" name="enddate" id="enddate" value="<?php echo $row3["end_date"]; ?>" class="form-control" required>
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Hive Assignment </label>
<input type="text" name="hiveassignment" value="<?php echo $row3["hive_assignment"]; ?>" class="form-control" required>
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Yield </label>
<input type="text" name="yield" id="yield" value="<?php echo $row3["yield"]; ?>" class="form-control" required>
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Yield Unit of Measure </label>
<input type="text" name="yieldum" value="<?php echo $row3["yield_unite_of_measure"]; ?>" class="form-control" required>
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Harvest Date </label>
<input type="date" name="harvestdate" value="<?php echo $row3["harvest_date"]; ?>" class="form-control" >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Bio-Security Standards </label>
<select name="biosecuritystandard" id="biosecuritystandard" onchange="calculatescore();" class="form-control" >
<option value="1" <?php if($row3["bio_security_standerd"]==1) echo "selected"; ?> >1</option>
<option value="0" <?php if($row3["bio_security_standerd"]==0) echo "selected"; ?> >0</option>
</select>
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Bee health </label>
<input type="text" name="beehealth" id="beehealth" value="<?php echo $row3["bee_health"]; ?>" onkeyup="calculatescore();" class="form-control" required >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Contract Compliance </label>
<input type="text" name="contractcompliance" id="contractcompliance" value="<?php echo $row3["contract_compliance"]; ?>" onkeyup="calculatescore();" class="form-control" required >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Bee yard Maintenance </label>
<input type="text" name="beeyrdmaintn" id="beeyrdmaintn" value="<?php echo $row3["bee_yard_maintenance"]; ?>" onkeyup="calculatescore();" class="form-control" required >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Harvest Weight </label>
<input type="text" name="hervestweight" id="hervestweight" value="<?php echo $row3["harvest_weight"]; ?>" onkeyup="calculatescore();" class="form-control" required >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Score </label>
<input type="text" name="score" id="score" value="<?php echo $row3["score"]; ?>" onkeyup="calculatescore();" class="form-control" required >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Rate </label>
<input type="text" name="rate" id="rate" value="<?php echo $row3["rate"]; ?>" class="form-control" required >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Gate Fee </label>
<input type="text" name="gatefee" id="gatefee" value="<?php echo $row3["gate_fee"]; ?>" class="form-control" required >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Gate Remittance </label>
<input type="text" name="gateremitance" value="<?php echo $row3["gate_remittance"]; ?>" id="gateremitance" class="form-control" required >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Remittance Date </label>
<input type="date" name="remitancedate" value="<?php echo $row3["remittance_date"]; ?>" id="remitancedate" class="form-control" required >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Remittance Reference </label>
<input type="text" name="remitanceref" value="<?php echo $row3["remittance_referance"]; ?>" id="remitanceref" class="form-control" required >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Contract Price </label>
<input type="text" name="contactprice" value="<?php echo $row3["contract_price"]; ?>" class="form-control" required >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Currency </label>
<select name="currency" class="form-control" >
<option value="USD" <?php if($row3["currency"]=="USD") echo "selected"; ?> >USD</option>
<option value="CAD" <?php if($row3["currency"]=="CAD") echo "selected"; ?> >CAD</option>
<option value="GHC" <?php if($row3["currency"]=="GHC") echo "selected"; ?> >GHC</option>
<option value="AUD" <?php if($row3["currency"]=="AUD") echo "selected"; ?> >AUD</option>
</select>
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Contract Payment </label>
<input type="text" name="contractpayment" value="<?php echo $row3["contract_payment"]; ?>" class="form-control" required >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Contract Payment Date </label>
<input type="date" name="contactpaydate" value="<?php echo $row3["contract_payment_date"]; ?>" class="form-control" required >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Contract payment Reference </label>
<input type="text" name="contactpayref" value="<?php echo $row3["contract_payment_referance"]; ?>" class="form-control" required >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Syndicate Profit </label>
<input type="text" name="syndicateprofit" id="syndicateprofit" value="<?php echo $row3["syndicate_profite"]; ?>" class="form-control" required >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Total Yield </label>
<input type="text" name="totalyield" id="totalyield" value="<?php echo $row3["total_yield"]; ?>" class="form-control" required >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Profit Sharing </label>
<input type="text" name="profitsharing" id="profitsharing" value="<?php echo $row3["profit_sharing"]; ?>" class="form-control" required >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Shared Profit </label>
<input type="text" name="sharedprofit" id="sharedprofit" value="<?php echo $row3["shared_profit"]; ?>" class="form-control" required >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Dividend </label>
<input type="text" name="dividend" id="dividend" value="<?php echo $row3["dividend"]; ?>" class="form-control" required >
</div>
<div class="form-group">
<label for="exampleInputEmail1"> Dividend payment date </label>
<input type="date" name="dividendpaydate" value="<?php echo $row3["dividend_payment_date"]; ?>" class="form-control" required >
</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="";
});
}
function getcontract(a)
{
$.post('getcontract.php', {
bp: a
}).done(function (msg) {
//alert(msg);
//location.reload();
document.getElementById("bp").innerHTML =msg;
//$("#allservicevalue").show();
///document.getElementById("nohivtohervst").value="";
//document.getElementById("hrvstyldprhiv").value="";
});
}
function calculatescore()
{
var a=document.getElementById("biosecuritystandard").value;
var b=document.getElementById("beehealth").value;
var c=document.getElementById("contractcompliance").value;
var d=document.getElementById("beeyrdmaintn").value;
var e=document.getElementById("hervestweight").value;
var f=parseInt(a) + parseInt(b) + parseInt(c) + parseInt(d) + parseInt(e) ;
//a=parseInt(a) + parseInt(b);
f=parseInt(f);
//alert(f);
document.getElementById("score").value=f;
}
$(document).ready(function(){
setInterval(function(){
var a=document.getElementById("score").value;
var b=a/5;
document.getElementById("rate").value=b;
}, 3000);
});
$(document).ready(function(){
setInterval(function(){
var a=document.getElementById("rate").value;
var c=document.getElementById("gatefee").value;
var b=c*a;
document.getElementById("gateremitance").value=b;
}, 3000);
});
$(document).ready(function(){
setInterval(function(){
var a=document.getElementById("syndicateprofit").value;
var c=document.getElementById("profitsharing").value;
var b=c*a;
document.getElementById("sharedprofit").value=b;
}, 3000);
});
$(document).ready(function(){
setInterval(function(){
var a=document.getElementById("yield").value;
var c=document.getElementById("totalyield").value;
var d=document.getElementById("sharedprofit").value;
var b=(a/c)*d;
document.getElementById("dividend").value=b;
}, 3000);
});
</script>