invisio v2.0

<?php
include("innerpageheader.php");
include("config.php");

include('example.php');

$id = $_GET['id'];

$result = $js->prepare('SELECT * FROM `invoicepayments` WHERE id = :id');
	$result->execute(array(':id' => $id));
	while($rowinv0 = $result->fetch(PDO::FETCH_ASSOC)) 
	{
		$payid = $rowinv0['payid'];
		$invid = $rowinv0['invoiceid'];
		$expdate = date('Y-m-d', strtotime($rowinv0['paydate']));
		$payamount = $rowinv0['payamount'];
	
		//$words = displaywords(722.01);
		$mode = $rowinv0['mode'];
		$premarks = $rowinv0['remarks'];
	}
	
	$resultinv1 = $js->prepare('SELECT * FROM `invoiced` WHERE id = :invid');
	$resultinv1->execute(array(':invid' => $invid));
	while($rowinv = $resultinv1->fetch(PDO::FETCH_ASSOC)) 
	{
		$project = strtoupper($rowinv['descr']);
		$comid = $rowinv['cust'];
		$invamount = $rowinv['invamount'];
		$currency = $rowinv['currency'];
		$invoice = $rowinv['invid'];
	}
	
	$net = $invamount;

$result2 = $js->prepare('SELECT * FROM `customer_entry` WHERE `id` = :comid');
	$result2->bindParam(':comid', $comid);
	$result2->execute();
	while($row2 = $result2->fetch(PDO::FETCH_ASSOC)) {
		$contact_person = $row2['custname'];
		$compname = $row2['companyname'];
		$pdate = date('d-m-Y', strtotime($row2['plannningdate']));
		$days = $row2['daysplanning'];
		$todate = date('d-m-Y', strtotime($pdate.' + '.$days.' days - 1 day'));
	}

</script>

<div class="col">
							<div class="heading-messages">
								<h3>Create New Payment</h3>
							</div>
						</div>
						<div class="col-md-4">
							<div class="breadcrumb">
								<div class="breadcrumb-item"><i class="fas fa-angle-right"></i><a href="#">Accounts</a>
								</div>
								<div class="breadcrumb-item active"><i class="fas fa-angle-right"></i>Add Invoice Payments
								</div>
							</div>
						</div>

</div>

<div class="hotel-listing-form">                            
                            <form class="text-center" method="post" action="save_editreceipt.php" enctype="multipart/form-data">
                            	
                                <input type="hidden" name="payid" id="payid" value="<?php echo $id?>">
                            
                            	<div class="row">
                                	
                                    <div class="col-md">
										<div class="form-group">
											<div class="input-group">
												<div class="input-group-prepend">
													<label class="input-group-text" for="inputGroupSelect00">Invoice</label>
												</div>
                                             <select name="invoice" id="invoice" required class="form-select" onChange="showClientcontact(this.value)">
                                            	<option value="<?php echo $invid?>"><?php echo $contact_person?> - <?php echo $invoice?> (<?php echo $project?>)
                                                <option value="">Select Invoice</option>
                                                <?php
                                                       $result = $js->prepare('SELECT * FROM `invoiced` ORDER BY `invdate` ');
												$result->execute(array());
											
												while($row = $result->fetch(PDO::FETCH_ASSOC))
												{
													$cid = $row['cust'];
													$invid = $row['invid'];
													$iid = $row['id'];
													$descr = $row['descr'];
													$invamount = $row['invamount'];
													
													$resultzz = $js->prepare('SELECT * FROM `invoicepayments` WHERE `invoiceid` = :iid ');
													$resultzz->execute(array(':iid' => $iid));
													$cc = $resultzz->rowCount();
													if($cc > '0')
													{
														while($rowsi = $resultzz->fetch(PDO::FETCH_ASSOC))
														{
															$amount = $rowsi['payamount'];
															$totpay += $amount;
															$balance = $rowsi['balance'];
															$icurrency = $rowsi['currency'];
														}
														
													}
													
													$results = $js->prepare('SELECT * FROM `customer_entry` WHERE id = :cid ');
													$results->execute(array(':cid' => $cid));
												
													while($rows = $results->fetch(PDO::FETCH_ASSOC))
													{
														$cname = $rows['custname'];
													}
													if($balance > '0' || $cc == '0')
													{
														echo "<option value='$iid'>$cname - $invid ($descr)</option>";
													}
												}

?>
                                                
                                            </select>
											</div>
										</div>
									</div>
                                    
                                    
                                	
                                   <div class="col-md">
										<div class="form-group">
											<label>Payment Date</label>
                                            <input type="date" class="form-control" id="invdate" name="invdate" value="<?php echo $expdate?>" required>
                                         </div>
                                    
                                	</div>
                                </div>
                                
                                <div class="row">
									<div class="col-md">
										<div class="form-group">
											<div class="input-group">
												<div class="input-group-prepend">
													<label class="input-group-text" for="inputGroupSelect00">Payment Mode</label>
												</div>
                                            	<?php echo $mode?>
											</div>
										</div>
									</div>
									
                                       
                                   </div>
                                
                                <div class="row">
                                	<div class="col-md">
										<div class="form-group">
											<label>Invoice Amount</label>
                                            
                                            <input type="text" class="form-control" id="invamt" name="invamt" placeholder="Invoice Amount" value="<?php echo $net?>">
                                         </div>
                                    
                                	</div>
                                	<div class="col-md">
										<div class="form-group">
											<label>Paid Amount</label>
                                            <input type="text" class="form-control" id="payingamt" name="payingamt" placeholder="Paying Amount" value="<?php echo $payamount?>">
                                         </div>
                                    
                                	</div>
                                    <div class="col-md">
										<div class="form-group">
											<div class="input-group">
												<div class="input-group-prepend">
													<label class="input-group-text" for="inputGroupSelect00">Currency</label>
												</div>
                                             <select name="currency" id="currency" class="form-select" >
                                                <option value="<?php echo $icurrency?>"><?php echo $icurrency?></option>
                                                <option value="" >Select Currency</option>
                                                <option value="USD">USD</option>
                                                <option value="INR">INR</option>
                                                <option value="OMR">OMR</option>
                                                <option value="EURO">EURO</option>
                                            </select>
											</div>
										</div>
									</div>
                                </div>
                                
                            	<div class="row">
                                    <div class="col-sm-12 mb-3 mb-sm-0">
                                    	<textarea class="form-control" id="remarks" name="remarks"  placeholder="Payment Remarks" onKeyUp="this.value = this.value.toUpperCase();">
                                        <?php echo $premarks?> </textarea>
                                    </div>
                                </div>
                                <br /> <br />
                                <input type="submit" value="Update Payment" class="btn btn-primary btn-user btn-block" style="background-color:#F6921E; border-color:#F6921E;">
                                
                        
                            </form>
                      </div>
                   </div>
               </div>
               
               
               </div>
               </section>
                         
    </div>
    <?php
		include('footer.php');
	?>

<script src="js/jquery-3.3.1.min.js"></script>
	<script src="js/popper.min.js"></script>
	<script src="js/bootstrap-5.3.2.min.js"></script>
	<script src="vendors/datatables/datatables.min.js"></script>
	<script src="js/customscriptfile.js"></script>

</html>