query($sql);
// Check if there are any invno values available
if ($result->num_rows > 0) {
// Display the form to select an invno
?>
query($sql);
// Display the quothead data for the selected invoice
if ($result->num_rows > 0) {
$row = $result->fetch_assoc();
?>
No Sebutharga:
Client Reg No:
CF No:
Inv Date:
Inv Due Date:
Tax Amt:
Tot Amt:
Tot Rec:
Invoice Details
Code
Detail
Amount
Tax
Tax Amount
data_seek(0);
while ($row = $result->fetch_assoc()) {
?>
>
query($sql);
// Check for errors
if (!$result) {
echo '';
exit;
}
// Insert data into invdet table
$sql = "INSERT INTO invdet SELECT * FROM quotdet WHERE invno = '$invno'";
$result = $conn->query($sql);
// Check if the data was successfully inserted into both tables
if ($result) {
$sql =" UPDATE invhead SET invno = '$next_docno' WHERE invno = '$invno'";
$result = $conn->query($sql);
$sql =" UPDATE invdet SET invno = '$next_docno' WHERE invno = '$invno'";
$result = $conn->query($sql);
echo '';
exit();
} else {
echo "Error: " . $sql . " " . $conn->error;
}
}
if (isset($_POST['print'])) {
// Get the selected invno
$invno = $_POST['invno'];
// Redirect to the print.php file, passing the invno as a parameter in the URL
header("Location: TCPDF/examples/quote.php?invno='$invno'");
exit;
}
if (isset($_POST['delete'])) {
// Get the selected invno
$invno = $_POST['invno'];
// DELETE data FROM invhead table
$sql = "DELETE FROM quothead WHERE invno = '$invno'";
$result = $conn->query($sql);
// Check for errors
if (!$result) {
echo '';
exit;
}
// Insert data into invdet table
$sql = "DELETE FROM quotdet WHERE invno = '$invno'";
$result = $conn->query($sql);
// Check if the data was successfully inserted into both tables
if ($result) {
echo '';
exit();
} else {
echo "Error: " . $sql . " " . $conn->error;
}
}
// Include footer file
include 'footer.php';
?>