prepare("DELETE FROM " . DB_PREFIX . "clients WHERE id = ?")->execute([$_GET['delete']]); $message = ['type' => 'success', 'text' => 'Клиент удален']; } catch (Exception $e) { $message = ['type' => 'error', 'text' => 'Ошибка удаления']; } } if ($_SERVER['REQUEST_METHOD'] === 'POST') { $id = $_POST['client_id'] ?? null; $data = [ 'name' => trim($_POST['name'] ?? ''), 'contact_name' => trim($_POST['contact_name'] ?? ''), 'email' => trim($_POST['email'] ?? ''), 'phone' => trim($_POST['phone'] ?? ''), 'telegram' => trim($_POST['telegram'] ?? ''), 'website' => trim($_POST['website'] ?? ''), 'description' => trim($_POST['description'] ?? ''), 'status' => $_POST['status'] ?? 'active' ]; if (empty($data['name'])) { $message = ['type' => 'error', 'text' => 'Укажите название клиента']; } else { try { if ($id) { $fields = []; $values = []; foreach ($data as $k => $v) { $fields[] = "$k = ?"; $values[] = $v; } $values[] = $id; $pdo->prepare("UPDATE " . DB_PREFIX . "clients SET " . implode(', ', $fields) . " WHERE id = ?")->execute($values); $message = ['type' => 'success', 'text' => 'Клиент обновлен']; } else { $pdo->prepare("INSERT INTO " . DB_PREFIX . "clients (name, contact_name, email, phone, telegram, website, description, status) VALUES (?, ?, ?, ?, ?, ?, ?, ?)") ->execute(array_values($data)); $message = ['type' => 'success', 'text' => 'Клиент добавлен']; } } catch (Exception $e) { $message = ['type' => 'error', 'text' => 'Ошибка: ' . $e->getMessage()]; } } } if (isset($_GET['edit']) && is_numeric($_GET['edit'])) { $stmt = $pdo->prepare("SELECT * FROM " . DB_PREFIX . "clients WHERE id = ?"); $stmt->execute([$_GET['edit']]); $editClient = $stmt->fetch(); } $search = $_GET['search'] ?? ''; if ($search) { $stmt = $pdo->prepare("SELECT * FROM " . DB_PREFIX . "clients WHERE name LIKE ? OR contact_name LIKE ? OR email LIKE ? ORDER BY created_at DESC"); $stmt->execute(["%$search%", "%$search%", "%$search%"]); } else { $stmt = $pdo->query("SELECT * FROM " . DB_PREFIX . "clients ORDER BY created_at DESC"); } $clients = $stmt->fetchAll(); ?>
НазваниеКонтактEmailТелефонСтатусДействия
Сайт
Клиентов не найдено