#acupoftea - mail.ontime-ae.com

System	:	Linux server1.ontime-gulf.com 4.18.0-553.5.1.el8_10.x86_64 #1 SMP Wed Jun 5 09:12:13 EDT 2024 x86_64
Software	:	Apache
Server	:	162.0.230.206
Domains	:	40 Domain
Permission	:	[ drwxr-x--- ]
	:	/ home / ontikmqz / accounting.ontime-gulf.com /

216.73.216.50

Home

File export.php

<?php
session_start();
if (!isset($_SESSION['username'])) {
    header("Location: login.php");
    exit();
}
if ($_SESSION['role'] !== 'admin' && $_SESSION['role'] !== 'accounting' && $_SESSION['role'] !== 'store_manager') {
    die("Access denied!");
}
include("./config.php");
include("./header.php");
?>
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <title>Scan AWBs</title>
  <link href="https://fonts.googleapis.com/css2?family=Cairo:wght@400;600&display=swap" rel="stylesheet">
  <script src="https://code.jquery.com/jquery-3.7.1.min.js"></script>
  <style>
    * {
      box-sizing: border-box;
      font-family: 'Cairo', sans-serif;
      color: #fff;
    }

body {
      margin: 0;
      background-color: #0f172a;
      display: flex;
      flex-direction: column;
      align-items: center;
      padding: 40px 0;
    }

h1 {
      color: #4da6ff;
      margin-bottom: 20px;
      font-size: 28px;
    }

.tableAndDeliveryCompanyCont {
      display: flex;
      justify-content: space-between;
      align-items: flex-start;
      width: 90%;
      max-width: 1300px;
      background: #1e293b;
      border-radius: 12px;
      padding: 30px;
      box-shadow: 0 0 20px rgba(0,0,0,0.4);
      gap: 40px;
    }

.devComCont {
      display: flex;
      align-items: center;
      gap: 10px;
      background: #0f172a;
      border: 1px solid #334155;
      padding: 10px 15px;
      border-radius: 8px;
      transition: 0.3s;
    }

.devComCont:hover {
      background-color: #1e3a8a;
      transform: scale(1.02);
    }

.devComCont input[type="radio"] {
      transform: scale(1.2);
      cursor: pointer;
      margin-bottom: 0px !important;
    }

form {
      width: 100%;
    }

table {
      width: 100%;
      border-collapse: collapse;
      margin-top: 10px;
      background-color: #0f172a;
      border-radius: 10px;
      overflow: hidden;
    }

th, td {
      border: 1px solid #1e293b;
      padding: 10px;
      text-align: center;
    }

th {
      background-color: #1e3a8a;
      color: #fff;
      font-weight: 600;
    }

tr:nth-child(even) {
      background-color: #1e293b;
    }

input[type="text"] {
      background-color: #1e293b;
      border: 1px solid #334155;
      color: #fff;
      padding: 6px;
      border-radius: 6px;
      width: 95%;
      text-align: center;
    }

input[type="text"]:focus {
      outline: none;
      border-color: #4da6ff;
      box-shadow: 0 0 8px #4da6ff;
    }

input[type="submit"] {
      background: linear-gradient(90deg, #0078ff, #4da6ff);
      border: none;
      color: white;
      padding: 10px 24px;
      border-radius: 8px;
      font-size: 16px;
      cursor: pointer;
      margin-top: 15px;
      transition: 0.3s;
    }

input[type="submit"]:hover {
      background: linear-gradient(90deg, #005bb5, #339dff);
      box-shadow: 0 0 12px #4da6ff;
      transform: scale(1.05);
    }

input[type="submit"]:disabled {
      background: #475569;
      cursor: not-allowed;
    }

.doneScanning {
      margin-top: 25px;
      display: flex;
      align-items: center;
      gap: 10px;
      background-color: #1e293b;
      padding: 10px 20px;
      border-radius: 10px;
    }

.doneScanning button {
      background: linear-gradient(90deg, #0078ff, #4da6ff);
      color: white;
      border: none;
      padding: 8px 20px;
      border-radius: 8px;
      cursor: pointer;
      transition: 0.3s;
    }

.doneScanning button:hover {
      transform: scale(1.05);
      box-shadow: 0 0 12px #4da6ff;
    }
  </style>
</head>
<body>
  <h1>📦 AWB Scanning & Delivery Company</h1>

<div class="tableAndDeliveryCompanyCont">
    <form method="post" action="">
      <div style="display: flex; flex-wrap: wrap; gap: 15px;">
      <?php
        if (!$conn) {
          die("Connection failed: " . mysqli_connect_error());
        }
        $sql = "SELECT delivery_company FROM delivery_companies WHERE visible = 1";
        $result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
          while($row = mysqli_fetch_assoc($result)) {
            echo "<label class='devComCont'><input type='radio' name='devComp1' value='" . htmlspecialchars($row["delivery_company"]) . "'> " . htmlspecialchars($row["delivery_company"]) . "</label>";
          }
        } else {
          echo "<p>No delivery companies available.</p>";
        }
      ?>
      </div>

<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $i = 1;
    while (isset($_POST["awb$i"])) {
        $awb  = mysqli_real_escape_string($conn, $_POST["awb$i"]);
        $date = mysqli_real_escape_string($conn, $_POST["date$i"]);
        $delivery_company = mysqli_real_escape_string($conn, $_POST["deliveryCompanyValue$i"]);

if (!empty($awb)) {
            $sql = "INSERT INTO export (awb, delivery_company, date) VALUES ('$awb', '$delivery_company', '$date')";
            if (!mysqli_query($conn, $sql)) {
                echo "<p style='color:red;text-align:center;'>❌ Error inserting row $i: " . mysqli_error($conn) . "</p>";
            }
        }
        $i++;
    }
    mysqli_close($conn);
    echo "<p style='color:lime;text-align:center;font-weight:600;'>✅ Data inserted successfully!</p>";
}
?>

Name	Type	Size	Permission	Last Modified	Actions
.	DIR	-	drwxr-x---	2025-10-25 09:45:35
..	DIR	-	drwx--x--x	2025-10-01 01:49:30
.well-known	DIR	-	drwxr-xr-x	2025-10-01 02:41:40
assets	DIR	-	drwxrwxrwx	2025-10-08 10:35:10
add_user.php	text/x-php	1.34 KB	-rw-rw-rw-	2025-10-01 09:03:03
barcode_exchange.php	text/x-php	5.34 KB	-rw-rw-rw-	2025-10-08 10:37:45
check_existing.php	text/x-php	20.19 KB	-rw-rw-rw-	2025-10-05 11:12:01
config.php	text/x-php	233 B	-rw-rw-rw-	2025-10-06 09:28:42
edit_export.php	text/x-php	9.68 KB	-rw-r--r--	2025-10-25 09:45:35
error_log	text/plain	13.57 KB	-rw-r--r--	2025-10-19 09:45:52
export.php	text/x-php	6.01 KB	-rw-rw-rw-	2025-10-08 10:34:11
header.php	text/x-php	5.64 KB	-rw-r--r--	2025-10-25 09:28:27
import.php	text/x-php	7.15 KB	-rw-rw-rw-	2025-10-08 09:21:54
index.php	text/x-php	157 B	-rw-r--r--	2025-10-04 02:25:51
login.php	text/x-php	4.26 KB	-rw-rw-rw-	2025-10-06 10:25:25
manifest.php	text/x-php	3.97 KB	-rw-rw-rw-	2025-10-08 08:58:51
order_items.php	text/x-php	5.09 KB	-rw-r--r--	2025-10-06 10:16:36
upload.php	text/x-php	5.36 KB	-rw-rw-rw-	2025-10-06 10:19:16

~ ACUPOFTEA - mail.ontime-ae.com