#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 / leads.pure-amber.com /

216.73.216.50

Home

File data.php

<?php
// CORS headers
header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Methods: POST, OPTIONS");
header("Access-Control-Allow-Headers: Content-Type");

if ($_SERVER['REQUEST_METHOD'] === 'OPTIONS') exit;

$host = 'localhost';
$db   = 'ontikmqz_pure';
$user = 'ontikmqz_pure';
$pass = 'USNco#QJZB,4$@Hj';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$db;charset=utf8mb4", $user, $pass, [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
    ]);
} catch (PDOException $e) {
    http_response_code(500);
    exit('Database connection failed: ' . $e->getMessage());
}

date_default_timezone_set('Asia/Dubai');

$rawInput = file_get_contents("php://input");
$data = json_decode($rawInput, true);

// Handle JSON POST insertion
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($data['fullName'])) {
    $stmt = $pdo->prepare("INSERT INTO pure_table 
        (full_name, phone, address, price, qty, customer_ip, url_referer, barcode, pro_name) 
        VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)");
    $stmt->execute([
        $data['fullName'],
        $data['phone'],
        $data['address'],
        $data['price'],
        $data['qty'],
        $data['customerIp'] ?? $_SERVER['REMOTE_ADDR'],
        $data['urlReferer'] ?? '',
        $data['barcode'],
        $data['pro_name']
    ]);
    header('Content-Type: application/json');
    echo json_encode(['status' => 'success', 'message' => 'Inserted']);
    exit;
}

// Handle form submissions with x-www-form-urlencoded for update_status and delete actions
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'])) {
    if ($_POST['action'] === 'update_status' && isset($_POST['id'], $_POST['status'])) {
        $stmt = $pdo->prepare("UPDATE pure_table SET status = ? WHERE id = ?");
        $stmt->execute([$_POST['status'], $_POST['id']]);
        exit('Status updated');
    }
    if ($_POST['action'] === 'delete' && isset($_POST['id'])) {
        $stmt = $pdo->prepare("DELETE FROM pure_table WHERE id = ?");
        $stmt->execute([$_POST['id']]);
        exit('Deleted');
    }
}

// Fetch all orders for display
$orders = $pdo->query("SELECT * FROM pure_table ORDER BY id DESC")->fetchAll(PDO::FETCH_ASSOC);
?>
<!DOCTYPE html>
<html>
<head>
  <meta charset="UTF-8">
  <title>Pure UAE Orders</title>
  <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
  <style>
    body { font-family: Arial; background: #f4f4f4; padding: 0px; }
    table { width: 100%; border-collapse: collapse; background: white; box-shadow: 0 0 10px rgba(0,0,0,0.1); }
    th, td { border: 1px solid #ccc; padding: 10px; text-align: center; }
    th { background: #222; color: white; }
    select, button { padding: 5px 8px; }
    .delete-btn { background: red; color: white; border: none; padding: 5px 10px; border-radius: 4px; cursor: pointer; }
    h2 { text-align: center; margin-bottom: 20px; }
  </style>
</head>
<body>

<h2>Pure UAE Orders</h2>

<table>
  <thead>
    <tr>
      <th>ID</th><th>Name</th><th>Phone</th><th>Address</th><th>Product</th>
      <th>Qty</th><th>Price</th><th>Barcode</th><th>Status</th><th>WhatsApp</th><th>Delete</th><th>Time</th>
    </tr>
  </thead>
  <tbody>
    <?php foreach ($orders as $o): ?>
    <tr data-id="<?= $o['id'] ?>">
      <td><?= $o['id'] ?></td>
      <td><?= htmlspecialchars($o['full_name']) ?></td>
      <td><?= htmlspecialchars($o['phone']) ?></td>
      <td><?= htmlspecialchars($o['address']) ?></td>
      <td><?= htmlspecialchars($o['pro_name']) ?></td>
      <td><?= $o['qty'] ?></td>
      <td><?= $o['price'] ?></td>
      <td><?= htmlspecialchars($o['barcode']) ?></td>
      <td>
        <select class="status" data-id="<?= $o['id'] ?>">
          <?php
            $statuses = ['waiting','in progress','completed','no answer','canceled','sales','gift','submitted'];
            foreach ($statuses as $s) {
                $sel = ($o['status'] === $s) ? 'selected' : '';
                echo "<option value=\"$s\" $sel>$s</option>";
            }
          ?>
        </select>
      </td>
      <td>
        <?php
          $rawPhone = preg_replace('/\D+/', '', $o['phone']); // Remove non-digit characters
          if (strpos($rawPhone, '971') === 0) {
              $cleanPhone = $rawPhone;
          } else {
              $cleanPhone = '971' . ltrim($rawPhone, '0');
          }
          $waLink = "https://web.whatsapp.com/send?phone=$cleanPhone";
        ?>
        <a href="<?= $waLink ?>" target="_blank">Chat</a>
      </td>
      <td><button class="delete-btn" data-id="<?= $o['id'] ?>">Delete</button></td>
      <td><?= date('Y-m-d H:i:s', strtotime($o['created_at'])) ?></td>
    </tr>
    <?php endforeach; ?>
  </tbody>
</table>

const status = selectEl.value;
    const bgColor = colorMap[status] || '#fff';
    selectEl.style.backgroundColor = bgColor;
    selectEl.style.color = (status === 'waiting' || status === 'submitted') ? '#000' : '#fff';
}

// Apply colors on page load
document.querySelectorAll('.status').forEach(applyStatusColor);

// On change
$(document).on('change', '.status', function() {
    const id = $(this).data('id');
    const status = $(this).val();

applyStatusColor(this);

$.post('data.php', {
        action: 'update_status',
        id: id,
        status: status
    });
});

$(document).on('click', '.delete-btn', function() {
    if (!confirm('Are you sure to delete this order?')) return;

const id = $(this).data('id');
    const row = $(this).closest('tr');

$.post('data.php', {
        action: 'delete',
        id: id
    }, function(res) {
        row.remove();
    });
});
</script>

</body>
</html>

Name	Type	Size	Permission	Last Modified	Actions
.	DIR	-	drwxr-x---	2025-07-03 02:56:19
..	DIR	-	drwx--x--x	2025-10-01 01:49:30
.well-known	DIR	-	drwxr-xr-x	2025-07-03 02:56:19
data.php	text/x-php	5.99 KB	-rw-r--r--	2025-07-03 02:13:33
error_log	text/plain	1.16 KB	-rw-r--r--	2025-07-03 02:12:03

~ ACUPOFTEA - mail.ontime-ae.com