invisio v2.0

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

include('example.php');
?>

</script>
<body onLoad="a()">

<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_invoicepayments.php" enctype="multipart/form-data">
                            
                            	<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="">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'];
														}
														
													}
													
													$enq1 = 'Confirmed';
													
													$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'];
														$enquirystatus = $rows['enquirystatus'];
													}
													if(($balance > '0' || $cc == '0') && $enquirystatus == 'Confirmed')
													{
														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" 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>
                                             <select name="r_mode" id="r_mode" class="form-select" onChange="mode()">
                                                <option value="" disabled selected>Select Payment Mode</option>
                                                <option value="Cash">Cash</option>
                                                <option value="Card Payment">Card Payment</option>
                                                <option value="Online Payment">Online Payment</option>
                                                <option value="Cheque">Cheuqe</option>
                                            </select>
											</div>
										</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">Bank/Branch</label>
												</div>
                                               <select name="banks" id="banks"  class="form-select"  >
                                               <option value="">Select Bank</option>
												<?php
													$resultz1 = $js->query('SELECT * FROM `bankaccounts` ');
													$resultz1->execute();
                                                    while($rowz1 = $resultz1->fetch(PDO::FETCH_ASSOC)) 
                                                    {
                                                        $bid = $rowz1['bankid'];
                                                        $bname = $rowz1['bankname'];
                                                        $accountno = $rowz1['accountno'];
                                                        echo "<option value='$bid'>$bname - $accountno</option>";	
                                                    }
                                                ?></select>
                                                
                                                <select name="branch" id="branch"  class="form-select"  >
                                               <option value="">Select Branch</option>
												<?php
													$resultz11 = $js->query('SELECT * FROM `branches` ');
													$resultz11->execute();
                                                    while($rowz11 = $resultz11->fetch(PDO::FETCH_ASSOC)) 
                                                    {
                                                        $bid = $rowz11['brid'];
                                                        $bname = $rowz11['brname'];
                                                        echo "<option value='$bid'>$bname</option>";	
                                                    }
                                                ?></select>
											</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">
                                         </div>
                                    
                                	</div>
                                	<div class="col-md">
										<div class="form-group">
											<label>Paying Amount</label>
                                            <input type="text" class="form-control" id="payingamt" name="payingamt" placeholder="Paying Amount">
                                         </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="" disabled selected>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();"></textarea>
                                    </div>
                                </div>
                                <br /> <br />
                                <input type="submit" value="Save 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>