fetch_all(MYSQLI_ASSOC); // Get invoices $sql = "SELECT id, client, `desc`, amount, date, status FROM invoices"; $stmt = mysqli_prepare($link, $sql); mysqli_stmt_execute($stmt); $result = mysqli_stmt_get_result($stmt); $invoices = $result->fetch_all(MYSQLI_ASSOC); // GET actions // delete entry if (isset($_GET["del"])) { $sql = "DELETE FROM invoices WHERE id = ?"; $stmt = mysqli_prepare($link, $sql); mysqli_stmt_bind_param($stmt, "s", $param_id); $param_id = $_GET["del"]; if (!mysqli_stmt_execute($stmt) || mysqli_stmt_affected_rows($stmt) != 1) { echo "SQL error."; } else header("location: ".$_SERVER['SCRIPT_NAME']); } if (isset($_GET["pdf"])) { // Get invoice $sql = "SELECT pdf FROM invoices WHERE id = ?"; $stmt = mysqli_prepare($link, $sql); mysqli_stmt_bind_param($stmt, "s", $param_id); $param_id = $_GET["pdf"]; mysqli_stmt_execute($stmt); $result = mysqli_stmt_get_result($stmt); $pdf = $result->fetch_all(MYSQLI_ASSOC)[0]["pdf"]; header("Content-type: application/pdf"); header("Content-Disposition: inline;filename=\"invoice.pdf\""); echo $pdf; } // POST actions if ($_SERVER["REQUEST_METHOD"] == "POST") { // edit entry if (isset($_POST["save"])) { $sql = "UPDATE invoices SET status = ? WHERE id = ?"; $stmt = mysqli_prepare($link, $sql); mysqli_stmt_bind_param($stmt, "ss", $param_status, $param_id); $param_status = $_POST["status"]; $param_id = $_POST["id"]; if (!mysqli_stmt_execute($stmt) || (mysqli_stmt_affected_rows($stmt) != 1)) { echo "SQL error."; } else header("location: ".$_SERVER['SCRIPT_NAME']); } } function getorderbyid($id) { global $orders; foreach ($orders as $order) { if ($order["id"] == $id) { return $order; } } } function getservicebyid($id) { global $services; foreach ($services as $service) { if ($service["id"] == $id) { return $service; } } } function getclientbyid($id) { global $clients; foreach ($clients as $client) { if ($client["id"] == $id) { return $client; } } } function getinvoicebyid($id) { global $invoices; foreach ($invoices as $invoice) { if ($invoice["id"] == $id) { return $invoice; } } } ?> ARFNET CSTIMS
ARFNET

ARFNET Client Service Ticket and Invoice Management System

panel

Orders

Edit invoice ".$invoice["id"]."

\n" ."

\n" ."

\n" ."

\n" ."

\n" ."

\n" ."" ."
cancel" ."
"; } ?> add " ."" ."" ."" ."" ."" ."" ."\n"; } ?>
idclientdescriptionamountdatepdfstatusaction
".$invoice["id"]."".getclientbyid($invoice["client"])["username"]."".$invoice["desc"]."".$invoice["amount"]." €".$invoice["date"]."pdf".$invoice["status"]."del edit

Logged as

Logout

Back to admin panel