Projects

prepare($query); $stmt->bind_param("i", $user_id); $stmt->execute(); $result = $stmt->get_result(); $user = $result->fetch_assoc(); // Check user role $is_manager = (isset($_SESSION['user_role']) && $_SESSION['user_role'] == 'manager'); // Get all leads with "Won" status $won_leads = []; $stmt = $conn->prepare("SELECT l.*, c.company_name AS client_name, c.email, c.phone FROM leads l LEFT JOIN clients c ON l.client_id = c.id WHERE l.status = 'won'"); $stmt->execute(); $won_leads = $stmt->get_result()->fetch_all(MYSQLI_ASSOC); // Get sent project notifications (for both manager and regular users) $sent_projects = []; $stmt = $conn->prepare("SELECT n.*, u.name AS sender_name FROM notifications n JOIN users u ON n.sender_id = u.id"); $stmt->execute(); $sent_projects = $stmt->get_result()->fetch_all(MYSQLI_ASSOC); // Handle form submission if ($_SERVER['REQUEST_METHOD'] == 'POST') { if (isset($_POST['send_to_manager'])) { // Send message to manager and store in notifications $project_name = $_POST['project_name']; $client_name = $_POST['client_name']; $email = $_POST['email']; $phone = $_POST['phone']; $budget = $_POST['budget']; $requirements = $_POST['requirements']; $lead_id = $_POST['lead_id']; // Use the logged-in user's ID as sender_id $sender_id = $_SESSION['user_id']; // Query to find the first available user ID as receiver_id $receiver_query = "SELECT id FROM users LIMIT 1"; $receiver_result = $conn->query($receiver_query); $receiver_id = $receiver_result->fetch_assoc()['id'] ?? 1; // Default to 1 if no user found // Insert into notifications table $stmt = $conn->prepare("INSERT INTO notifications (sender_id, receiver_id, project_name, client_name, email, phone, budget, requirements, status, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, 'unread', NOW())"); $stmt->bind_param("iissssds", $sender_id, $receiver_id, $project_name, $client_name, $email, $phone, $budget, $requirements); if ($stmt->execute()) { $_SESSION['success'] = "Project sent to manager successfully!"; } else { $_SESSION['error'] = "Error: Failed to send project to manager."; } } elseif (isset($_POST['update_project']) && $is_manager) { // Manager updates project $lead_id = $_POST['lead_id']; $project_name = $_POST['project_name']; $client_name = $_POST['client_name']; $email = $_POST['email']; $phone = $_POST['phone']; $budget = $_POST['budget']; $requirements = $_POST['requirements']; // Update notifications table $stmt = $conn->prepare("UPDATE notifications SET project_name = ?, client_name = ?, email = ?, phone = ?, budget = ?, requirements = ? WHERE id = ?"); $stmt->bind_param("ssssdsi", $project_name, $client_name, $email, $phone, $budget, $requirements, $lead_id); $stmt->execute(); $_SESSION['success'] = "Project updated successfully!"; } header("Location: project.php"); exit(); } ?> Projects | Decconz Admin Dashboard

Won Leads

List of all leads with 'Won' status

Client Name	Email	Phone	Value	Notes	Actions

Sent Projects

List of projects sent to manager

ID	Project Name	Client Name	Email	Phone	Budget	Requirements	Status	Actions