Ghost Exploiter Team Official

/home/ramdevpcb/public_html/admin.ramdevpcb.com/

<?php
/*	require_once 'include/db.php';

$orderNumber = $_GET['orderNumber'];

$result1 = mysqli_query($conn, "SELECT * FROM Orders WHERE OrderNumber = '$orderNumber'") or die(mysqli_error($conn));
	$row1 = mysqli_fetch_assoc($result1);
	$result2 = mysqli_query($conn, "SELECT * FROM OrderItems WHERE OrderID = '{$row1['OrderID']}'") or die(mysqli_error($conn));
	$row2 = mysqli_fetch_assoc($result2);
	$totalItems = mysqli_num_rows($result2);*/

/*$result3 = mysqli_query($conn, "SELECT * FROM Invoices") or die(mysqli_error($conn));
	$row3 = mysqli_fetch_assoc($result3);
	$totalInvoices = mysqli_num_rows($result3);
	$invoiceNumber = "RDL-" . $totalInvoices + 1 . "/" . get_financial_year_range();*/
	
/*	$result3 = mysqli_query($conn, "SELECT a.InvoiceNumber FROM Invoices a JOIN Orders b ON a.OrderID=b.OrderID WHERE b.OrderNumber = '$orderNumber'") or die(mysqli_error($conn));
	$row3 = mysqli_fetch_assoc($result3);*/
    // $totalInvoices = mysqli_num_rows($result3) + 1; // Increment to get the next invoice number
    
    // Pad the number to 3 digits using sprintf
    // $invoiceNumber = "RDL" . sprintf('%03d', $totalInvoices) . "/" . get_financial_year_range();
    
    // Example output: RDL001/24-25

<?php
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
require_once 'include/db.php';

$orderNumber = $_GET['orderNumber'];

// Fetch order details
$result1 = mysqli_query($conn, "SELECT * FROM Orders WHERE OrderNumber = '$orderNumber'") or die(mysqli_error($conn));
$row1 = mysqli_fetch_assoc($result1);

if (!$row1) {
    die("Order not found.");
}

// Fetch order items
$result2 = mysqli_query($conn, "SELECT * FROM OrderItems WHERE OrderID = '{$row1['OrderID']}'") or die(mysqli_error($conn));
$totalItems = mysqli_num_rows($result2);

// Check if invoice already exists for this order
$result3 = mysqli_query($conn, "SELECT a.InvoiceNumber FROM Invoices a JOIN Orders b ON a.OrderID = b.OrderID WHERE b.OrderNumber = '$orderNumber'") or die(mysqli_error($conn));
$row3 = mysqli_fetch_assoc($result3);

if ($row3 && !empty($row3['InvoiceNumber'])) {
    // Invoice exists, use existing invoice number
    $invoiceNumber = $row3['InvoiceNumber'];
} else {
    // Invoice does not exist, generate new invoice number

// Get total invoices count to generate next invoice number
    /*$resultCount = mysqli_query($conn, "SELECT COUNT(*) as total FROM Invoices") or die(mysqli_error($conn));
    $countRow = mysqli_fetch_assoc($resultCount);
    $totalInvoices = $countRow['total'] + 1;*/
    
    // Query to get max invoice number numeric part
    $resultMax = mysqli_query($conn, "SELECT MAX(CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(InvoiceNumber, '/', 1), 'RDL', -1) AS UNSIGNED)) AS max_invoice_num FROM Invoices") or die(mysqli_error($conn));
    $rowMax = mysqli_fetch_assoc($resultMax);
    $maxInvoiceNum = $rowMax['max_invoice_num'] ?? 0; // default 0 if no invoices
    // Next invoice number numeric part
    $nextInvoiceNum = $maxInvoiceNum + 1;
    // Use your existing get_financial_year_range() function from db.php
    $invoiceNumber = "RDL" . sprintf('%03d', $nextInvoiceNum) . "/" . get_financial_year_range();

// Function to get financial year range, e.g. "24-25"
    if (!function_exists('get_financial_year_range')) {
        function get_financial_year_range() {
            $year = date('Y');
            $startYear = substr($year, 2);
            $endYear = substr($year + 1, 2);
            return $startYear . '-' . $endYear;
        }
    }

// Format invoice number with leading zeros and financial year
    // $invoiceNumber = "RDL" . sprintf('%03d', $totalInvoices) . "/" . get_financial_year_range();
}

// Now $invoiceNumber contains either the existing or new invoice number
// echo "Invoice Number: " . $invoiceNumber;

?>
<!doctype html>
<html lang="en" dir="ltr">
	<head>
		
		<meta charset="UTF-8">
		<meta name='viewport' content='width=device-width, initial-scale=1.0, user-scalable=0'>
		<meta http-equiv="X-UA-Compatible" content="IE=edge">
		<meta name="description" content="Ramdev PCB Admin">
		<meta name="author" content="Ramdev PCB Admin">
		<meta name="keywords" content="Ramdev PCB">
		
		<link rel="shortcut icon" type="image/x-icon" href="assets/images/brand/favicon.ico" />
		
		<title>Products Ramdev PCB </title>
		
		<link id="style" href="assets/plugins/bootstrap/css/bootstrap.min.css" rel="stylesheet" />
		
		<link href="assets/css/style.css" rel="stylesheet" />
		<link href="assets/css/dark-style.css" rel="stylesheet" />
		<link href="assets/css/transparent-style.css" rel="stylesheet">
		<link href="assets/css/skin-modes.css" rel="stylesheet" />
		
		<link href="assets/css/icons.css" rel="stylesheet" />
		
		<link id="theme" rel="stylesheet" type="text/css" media="all" href="assets/colors/color1.css" />
	</head>
	<body class="app sidebar-mini ltr light-mode">
		
		<div class="page">
			<div class="page-main">
				
				<?php include('include/header.php');?>
				
				<?php include('include/sidebarmenu.php');?>
				
				<div class="main-content app-content mt-0">
					<div class="side-app">
						
						<div class="main-container container-fluid">
							
							<div class="page-header">
								<h1 class="page-title">Invoice</h1>
								<div>
									<ol class="breadcrumb">
										<li class="breadcrumb-item"><a href="javascript:void(0)">Home</a></li>
										<li class="breadcrumb-item active" aria-current="page">Invoice</li>
									</ol>
								</div>
							</div>
							
							
							<div class="row">
								<div class="col-xl-12 col-lg-12">
									<div class="card">
										<div class="card-header">
											<h3 class="card-title">Generate Invoice</h3>
										</div>
										<div class="card-body">
											<form id="invoice-form" action="generate-invoice-server.php" class="form-horizontal col-xl-12" method="post">
												<input type="hidden" name="orderId" value="<?= $row1['OrderID'] ?>" />
												<div class="row mb-12">
													<div class="row mb-4">
														<label class="col-md-2 form-label">Invoice Number</label>
														<div class="col-md-4">
															<input type="text" class="form-control" name="invoiceNumber" value="<?= $invoiceNumber ?>"  />
														</div>
														<label class="col-md-2 form-label">Invoice Date</label>
														<div class="col-md-4">
															<input type="text" class="form-control" name="invoiceDate" value="<?= date('d-M-y') ?>" readonly />
														</div>
													</div>
													<div class="row mb-4">
														<label class="col-md-2 form-label">Order Number</label>
														<div class="col-md-4">
															<input type="text" class="form-control" name="orderNumber" value="<?= $orderNumber ?>" readonly />
														</div>
														<label class="col-md-2 form-label">Order Date</label>
														<div class="col-md-4">
															<input type="text" class="form-control" name="orderDate" value="<?= date('d-M-y', strtotime($row1['OrderDate'])) ?>" readonly />
														</div>
													</div>
													<div class="row mb-4">
														<label class="col-md-2 form-label">Total Amount</label>
														<div class="col-md-4">
															<input type="text" class="form-control" name="totalAmount" value="<?= $row1['OrderAmount'] ?>" readonly />
														</div>
														<label class="col-md-2 form-label">Total Items</label>
														<div class="col-md-4">
															<input type="text" class="form-control" name="orderDate" value="<?= $totalItems ?>" readonly />
														</div>
													</div>
													<div class="row mb-4">
														<label class="col-md-2 form-label">Delivery Note</label>
														<div class="col-md-4">
															<input type="text" class="form-control" name="deliveryNote" />
														</div>
														<label class="col-md-2 form-label">Reference Number</label>
														<div class="col-md-4">
															<input type="text" class="form-control" name="referenceNumber" />
														</div>
													</div>
													<div class="row mb-4">
														<label class="col-md-2 form-label">Reference Date</label>
														<div class="col-md-4">
															<input type="text" class="form-control fc-datepicker" name="referenceDate" />
														</div>
														<label class="col-md-2 form-label">Other References</label>
														<div class="col-md-4">
															<input type="text" class="form-control" name="otherReference" />
														</div>
													</div>
													<div class="row mb-4">
														<label class="col-md-2 form-label">Dispatch Doc No.</label>
														<div class="col-md-4">
															<input type="text" class="form-control" name="dispatchDocNo" />
														</div>
														<label class="col-md-2 form-label">Dispatched through</label>
														<div class="col-md-4">
															<select type="text" class="form-control" name="dispatchedThrough">
																<option value="Self Pickup" <?= $row1['DeliveryOption'] == 'Self Pickup' ? 'selected' : '' ?>>Self Pickup</option>
																<option value="Courier" <?= $row1['DeliveryOption'] == 'Courier' ? 'selected' : '' ?>>Courier</option>
																<option value="Transport" <?= $row1['DeliveryOption'] == 'Transport' ? 'selected' : '' ?>>Transport</option>
																<option value="Porter" <?= $row1['DeliveryOption'] == 'Porter' ? 'selected' : '' ?>>Porter</option>
															</select>
														</div>
													</div>
													<div class="row mb-4">
														<label class="col-md-2 form-label">Destination</label>
														<div class="col-md-4">
															<input type="text" class="form-control" name="destination" />
														</div>
														<label class="col-md-2 form-label">Delivery Note Date</label>
														<div class="col-md-4">
															<input type="text" class="form-control fc-datepicker" name="deliveryNoteDate" />
														</div>
													</div>
													<div class="col-md-4">
														<button class="btn btn-primary mt-4 mb-0" name="submit">Submit</button>
													</div>
												</div>
											</form>
										</div>
									</div>
								</div>
							</div>
						</div>
						
					</div>
				</div>
				
			</div>
			
			<?php include('include/footer.php');?>
			
		</div>
		
		<a href="#top" id="back-to-top"><i class="fa fa-angle-up"></i></a>
		
		<script src="assets/js/jquery.min.js"></script>
		
		<script src="assets/plugins/bootstrap/js/popper.min.js"></script>
		<script src="assets/plugins/bootstrap/js/bootstrap.min.js"></script>
		
		<script src="assets/js/jquery.sparkline.min.js"></script>
		
		<script src="assets/js/sticky.js"></script>
		
		<script src="assets/js/circle-progress.min.js"></script>
		
		<script src="assets/plugins/peitychart/jquery.peity.min.js"></script>
		<script src="assets/plugins/peitychart/peitychart.init.js"></script>
		
		<script src="assets/plugins/sidebar/sidebar.js"></script>
		
		<script src="assets/plugins/p-scroll/perfect-scrollbar.js"></script>
		<script src="assets/plugins/p-scroll/pscroll.js"></script>
		<script src="assets/plugins/p-scroll/pscroll-1.js"></script>
		
		<script src="assets/plugins/chart/Chart.bundle.js"></script>
		<script src="assets/plugins/chart/rounded-barchart.js"></script>
		<script src="assets/plugins/chart/utils.js"></script>
		
		<script src="assets/plugins/select2/select2.full.min.js"></script>
		
		<script src="assets/plugins/bootstrap-datepicker/bootstrap-datepicker.js"></script>
		
		<script src="assets/plugins/date-picker/date-picker.js"></script>
		<script src="assets/plugins/date-picker/jquery-ui.js"></script>
		<script src="assets/plugins/input-mask/jquery.maskedinput.js"></script>
		
		<script src="assets/plugins/datatable/js/jquery.dataTables.min.js"></script>
		<script src="assets/plugins/datatable/js/dataTables.bootstrap5.js"></script>
		<script src="assets/plugins/datatable/js/dataTables.buttons.min.js"></script>
		<script src="assets/plugins/datatable/js/buttons.bootstrap5.min.js"></script>
		<script src="assets/plugins/datatable/js/jszip.min.js"></script>
		<script src="assets/plugins/datatable/pdfmake/pdfmake.min.js"></script>
		<script src="assets/plugins/datatable/pdfmake/vfs_fonts.js"></script>
		<script src="assets/plugins/datatable/js/buttons.html5.min.js"></script>
		<script src="assets/plugins/datatable/js/buttons.print.min.js"></script>
		<script src="assets/plugins/datatable/js/buttons.colVis.min.js"></script>
		<script src="assets/plugins/datatable/dataTables.responsive.min.js"></script>
		<script src="assets/plugins/datatable/responsive.bootstrap5.min.js"></script>
		<script src="assets/js/table-data.js"></script>
		
		<script src="assets/js/apexcharts.js"></script>
		<script src="assets/plugins/apexchart/irregular-data-series.js"></script>
		
		<script src="assets/plugins/charts-c3/d3.v5.min.js"></script>
		<script src="assets/plugins/charts-c3/c3-chart.js"></script>
		
		<script src="assets/js/charts.js"></script>
		
		<script src="assets/plugins/flot/jquery.flot.js"></script>
		<script src="assets/plugins/flot/jquery.flot.fillbetween.js"></script>
		<script src="assets/plugins/flot/chart.flot.sampledata.js"></script>
		<script src="assets/plugins/flot/dashboard.sampledata.js"></script>
		
		<script src="assets/plugins/jvectormap/jquery-jvectormap-2.0.2.min.js"></script>
		<script src="assets/plugins/jvectormap/jquery-jvectormap-world-mill-en.js"></script>
		
		<script src="assets/plugins/sidemenu/sidemenu.js"></script>
		
		<script src="assets/js/index1.js"></script>
		
		<script src="assets/js/themeColors.js"></script>
		
		<script src="assets/js/custom.js"></script><script>
			$(function() {
				$('.fc-datepicker').bootstrapdatepicker({
					showOtherMonths: true,
					selectOtherMonths: true,
					format: 'dd-M-yy'
				});
				$('#invoice-form').submit(function(e) {
					e.preventDefault();
					var $this = $(this), data = $this.serialize(), url = $this.attr('action');
					$.ajax({
						type: 'POST',
						url: url,
						data: data,
						dataType: 'json',
						success: function(d) {
							if (d.status) {
								alert(d.msg);
								 window.location.href="order-details.php";
							}
						}
					});
				});
			});
		</script>
	</body>
</html>

Nama File / Folder	Size	Action
.well-known	--	NONE
Data_	--	NONE
assets	--	NONE
cgi-bin	--	NONE
include	--	NONE
uploads	--	NONE
.htaccess	0.274KB	Hapus Edit Rename
8Products.php	15.674KB	Hapus Edit Rename
MonthlyProducts.php	15.686KB	Hapus Edit Rename
add-brand.php	27.782KB	Hapus Edit Rename
add-vendor.php	42.001KB	Hapus Edit Rename
b-bclients.php	12.086KB	Hapus Edit Rename
b-bclients1.php	9.329KB	Hapus Edit Rename
b-cclients.php	13.998KB	Hapus Edit Rename
category.php	13.583KB	Hapus Edit Rename
color.php	11.327KB	Hapus Edit Rename
company.php	14.712KB	Hapus Edit Rename
courier.php	16.539KB	Hapus Edit Rename
delete_product_pdf.php	0.618KB	Hapus Edit Rename
discount-b2b.php	9.862KB	Hapus Edit Rename
discount-b2c.php	8.333KB	Hapus Edit Rename
discount-list.php	10.272KB	Hapus Edit Rename
generate-invoice-server.php	3.183KB	Hapus Edit Rename
generate-invoice.php	15.014KB	Hapus Edit Rename
invoice-list.php	10.6KB	Hapus Edit Rename
invoice22222.php	31.864KB	Hapus Edit Rename
invoicenew1.php	17.683KB	Hapus Edit Rename
newstock.php	15.827KB	Hapus Edit Rename
offline-order-add.php	2.254KB	Hapus Edit Rename
offline-order-delete.php	0.338KB	Hapus Edit Rename
offline-order-server.php	1.695KB	Hapus Edit Rename
offline-order.php	30.544KB	Hapus Edit Rename
order-details.php	14.237KB	Hapus Edit Rename
order-item-details.php	7.875KB	Hapus Edit Rename
paidd.png	27.518KB	Hapus Edit Rename
product-list.php	8.904KB	Hapus Edit Rename
product.php	35.78KB	Hapus Edit Rename
productreport.php	28.885KB	Hapus Edit Rename
save_image_order.php	1.284KB	Hapus Edit Rename
sms.js	2.603KB	Hapus Edit Rename
stock.php	14.202KB	Hapus Edit Rename
stockreport.php	24.525KB	Hapus Edit Rename
subcategory.php	13.671KB	Hapus Edit Rename
update-order-status.php	2.562KB	Hapus Edit Rename
update-user-role.php	0.306KB	Hapus Edit Rename
vijayinvoice.php	17.683KB	Hapus Edit Rename