:: **Zploit** v1.0 | Current Path: **/home/kreativepixelz/tdrbazaar.com/crm/**
:: Editing File: lead_add.php
<?php // Initialize session and database connection if not already included //if (session_status() === PHP_SESSION_NONE) { // session_start(); //} include "db.php"; // Adjust to your actual DB connection file if named differently ini_set('display_errors', 0); ini_set('display_startup_errors', 0); //error_reporting(E_ALL); // Handle Form Submission logic $success_message = ''; $error_message = ''; if ($_SERVER['REQUEST_METHOD'] === 'POST') { // Sanitize and capture inputs $contact_name = mysqli_real_escape_string($conn, $_POST['contact_name'] ?? ''); $company_name = mysqli_real_escape_string($conn, $_POST['company_name'] ?? ''); $contact_no = mysqli_real_escape_string($conn, $_POST['contact_no'] ?? ''); $contact_no_2 = mysqli_real_escape_string($conn, $_POST['contact_no_2'] ?? ''); $deal_name = mysqli_real_escape_string($conn, $_POST['deal_name'] ?? ''); if (empty($deal_name)) { $deal_name = $contact_name; } // Default deal name to contact name if empty $party_type = mysqli_real_escape_string($conn, $_POST['party_type'] ?? ''); //$sub_category = isset($_POST['sub_category']) ? implode(',', $_POST['sub_category']) : ''; $sub_category = mysqli_real_escape_string($conn, $_POST['sub_category'] ?? ''); $sub_pipeline = mysqli_real_escape_string($conn, $_POST['sub_pipeline'] ?? ''); $authority = mysqli_real_escape_string($conn, $_POST['authority'] ?? ''); $location = mysqli_real_escape_string($conn, $_POST['location'] ?? ''); $reg_tdr_area = floatval($_POST['reg_tdr_area'] ?? 0); $rr_rate = floatval($_POST['rr_rate'] ?? 0); $reg_tdr_mrp = floatval($_POST['reg_tdr_mrp'] ?? 0); $slum_tdr_area = floatval($_POST['slum_tdr_area'] ?? 0); $slum_tdr_mrp = floatval($_POST['slum_tdr_mrp'] ?? 0); $source = mysqli_real_escape_string($conn, $_POST['source'] ?? ''); $source_name = mysqli_real_escape_string($conn, $_POST['source_name'] ?? ''); $stage_id = intval($_POST['stage_id'] ?? 1); $deal_priority = mysqli_real_escape_string($conn, $_POST['deal_priority'] ?? ''); $closing_date = !empty($_POST['closing_date']) ? $_POST['closing_date'] : NULL; $description = mysqli_real_escape_string($conn, $_POST['description'] ?? ''); $created_by = $_SESSION['user_id'] ?? 1; // Insert Query $insert_sql = "INSERT INTO leads ( contact_name, company_name, contact_no, contact_no_2, deal_name, party_type, sub_category, sub_pipeline, authority, location, reg_tdr_area, rr_rate, reg_tdr_mrp, slum_tdr_area, slum_tdr_mrp, source, source_name, stage_id, deal_priority, closing_date, description, created_by, created_at ) VALUES ( '$contact_name', '$company_name', '$contact_no', '$contact_no_2', '$deal_name', '$party_type', '$sub_category', '$sub_pipeline', '$authority', '$location', '$reg_tdr_area', '$rr_rate', '$reg_tdr_mrp', '$slum_tdr_area', '$slum_tdr_mrp', '$source', '$source_name', '$stage_id', '$deal_priority', " . ($closing_date ? "'$closing_date'" : "NULL") . ", '$description', '$created_by', NOW() )"; if (mysqli_query($conn, $insert_sql)) { // Redirect back to leads list or stay based on preference (using list.php to prevent confusion) header("Location: lead_list.php?msg=created_successfully"); exit(); } else { $error_message = "Error recording lead: " . mysqli_error($conn); } } include "header.php"; ?> <style> input[type="text"] { height: 40px; padding: 0 12px; /* Adds inner spacing so text isn't pressed against the edges */ box-sizing: border-box; /* Ensures padding doesn't increase the overall 45px height */ } input[type="number"] { height: 40px; padding: 0 12px; /* Adds inner spacing so text isn't pressed against the edges */ box-sizing: border-box; /* Ensures padding doesn't increase the overall 45px height */ } input[type="date"] { height: 40px; padding: 0 12px; /* Adds inner spacing so text isn't pressed against the edges */ box-sizing: border-box; /* Ensures padding doesn't increase the overall 45px height */ } </style> <div class="page-wrapper"> <div class="content pb-0"> <!-- Page Header & Breadcrumbs --> <div class="d-flex align-items-center justify-content-between gap-2 mb-4 flex-wrap"> <div> <h4 class="mb-1">Add New Property Lead</h4> <nav aria-label="breadcrumb"> <ol class="breadcrumb mb-0 p-0"> <li class="breadcrumb-item"><a href="dashboard.php">Home</a></li> <li class="breadcrumb-item"><a href="lead_list.php">Leads Management</a></li> <li class="breadcrumb-item active" aria-current="page">Add Lead</li> </ol> </nav> </div> <div> <a href="list.php" class="btn btn-sm btn-outline-secondary"><i class="ti ti-arrow-left me-1"></i>Back to List</a> </div> </div> <?php if (!empty($error_message)) { ?> <div class="alert alert-danger alert-dismissible fade show" role="alert"> <?php echo $error_message; ?> <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button> </div> <?php } ?> <!-- Start Row Form Card --> <div class="row"> <div class="col-xl-12"> <div class="card border-0 shadow-sm"> <div class="card-header bg-light"> <h5 class="card-title mb-0 text-primary"><i class="ti ti-user-plus me-2"></i>Lead Information Matrix</h5> </div> <div class="card-body"> <form action="" method="POST" class="needs-validation" novalidate> <div class="row g-3"> <!-- Contact Name & Company Name --> <div class="col-md-6"> <label class="form-label small fw-bold">Contact Name *</label> <input type="text" name="contact_name" class="form-control form-control-sm" placeholder="Enter contact person name" required> </div> <div class="col-md-6"> <label class="form-label small fw-bold">Company Name</label> <input type="text" name="company_name" class="form-control form-control-sm" placeholder="e.g. Acme Realty Developers"> </div> <!-- Contact Phone Numbers --> <div class="col-md-6"> <label class="form-label small fw-bold">Primary Contact No *</label> <input type="text" name="contact_no" class="form-control form-control-sm" placeholder="10-digit mobile number" required> </div> <div class="col-md-6"> <label class="form-label small fw-bold">Secondary Contact No</label> <input type="text" name="contact_no_2" class="form-control form-control-sm" placeholder="Alternate phone number"> </div> <!-- Deal Name (Optional) --> <div class="col-12"> <label class="form-label small fw-bold">Deal Name (Optional)</label> <input type="text" name="deal_name" class="form-control form-control-sm" placeholder="Leave empty to auto-use Contact Name"> </div> <!-- Separate Party Groups as requested --> <div class="col-md-6"> <label class="form-label small fw-bold">Party Category</label> <select name="party_type" class="form-select form-select-sm"> <option value="Builder/Developer" selected>Builder/Developer</option> <option value="CP/Broker">CP/Broker</option> <option value="Liasoning Agent">Liasoning Agent</option> <option value="Architect">Architect</option> <option value="DRC Holder/Seller">DRC Holder/Seller</option> <option value="Raw TDR Seller/Owner">Raw TDR Seller/Owner</option> </select> </div> <!-- Multiple Sub Category Selection -- <div class="col-md-6"> <label class="form-label small fw-bold">Sub Category (Hold Ctrl/Cmd for multiple)</label> <select name="sub_category[]" class="form-select form-select-sm" multiple style="height: 78px;"> <option value="Residential">Residential</option> <option value="Commercial">Commercial</option> <option value="Industrial">Industrial</option> <option value="Plotting">Plotting</option> <option value="TDR Buyer">TDR Buyer</option> </select> </div> <!-- Updated Sub-Pipeline options (PMC, PCMC, PMRDA variations) --> <div class="col-md-6"> <label class="form-label small fw-bold">Sub-Pipeline Group</label> <select name="sub_pipeline" class="form-select form-select-sm"> <optgroup label="PMC Options"> <option value="PMC - TDR/DRC Buyer" selected>1. PMC - TDR/DRC Buyer</option> <option value="PMC - DRC Seller">2. PMC - DRC Seller</option> <option value="PMC - Raw TDR Buyer">3. PMC - Raw TDR Buyer</option> <option value="PMC - Raw TDR Seller">4. PMC - Raw TDR Seller</option> </optgroup> <optgroup label="PCMC Options"> <option value="PCMC - TDR/DRC Buyer">1. PCMC - TDR/DRC Buyer</option> <option value="PCMC - TDR/DRC Seller">2. PCMC - TDR/DRC Seller</option> <option value="PCMC - Raw TDR Buyer">3. PCMC - Raw TDR Buyer</option> <option value="PCMC - Raw TDR Seller">4. PCMC - Raw TDR Seller</option> </optgroup> <optgroup label="PMRDA Options"> <option value="PMRDA - TDR/DRC Buyer">1. PMRDA - TDR/DRC Buyer</option> <option value="PMRDA - TDR/DRC Seller">2. PMRDA - TDR/DRC Seller</option> <option value="PMRDA - Raw TDR Buyer">3. PMRDA - Raw TDR Buyer</option> <option value="PMRDA - Raw TDR Seller">4. PMRDA - Raw TDR Seller</option> </optgroup> </select> </div> <!-- Authority and Location --> <div class="col-md-6"> <label class="form-label small fw-bold">Authority</label> <select name="authority" class="form-select form-select-sm"> <option value="--none--" selected>--none--</option> <option value="PMC">PMC</option> <option value="PCMC">PCMC</option> <option value="PMRDA">PMRDA</option> <option value="Phursungi">Phursungi</option> <option value="Out Of Pune">Out Of Pune</option> </select> </div> <div class="col-md-6"> <label class="form-label small fw-bold">Location</label> <input type="text" name="location" class="form-control form-control-sm" placeholder="Specify location/area"> </div> <!-- Source and Source Name (including BNI) --> <div class="col-md-3"> <label class="form-label small fw-bold">Lead Source</label> <select name="source" class="form-select form-select-sm"> <!--<option value="BNI" selected>BNI</option> <option value="Direct Reference">Direct Reference</option> <option value="Digital Campaign">Digital Campaign</option> <option value="Channel Partner">Channel Partner</option> <option value="Cold Calling">Cold Calling</option> <option value="Other">Other</option>--> <option value="Referral">Referral</option> <option value="Builder/Developer">Builder/Developer</option> <option value="Architect/Engineer">Architect/Engineer</option> <option value="BNI" selected>BNI</option> <option value="WhatsApp">WhatsApp</option> <option value="Website">Website</option> <option value="Google">Google</option> <option value="Social Media">Social Media</option> <option value="Channel Partner/Broker">Channel Partner/Broker</option> <option value="Events">Events</option> <option value="Telecalling">Telecalling</option> <option value="Existing Client">Existing Client</option> </select> </div> <div class="col-md-3"> <label class="form-label small fw-bold">Source Details / Name</label> <input type="text" name="source_name" class="form-control form-control-sm" placeholder="e.g. Chapter name or person"> </div> <!-- Areas, Rates & MRP Fields --> <div class="col-md-4"> <label class="form-label small fw-bold">Regular TDR Area (Sq.m)</label> <input type="text" name="reg_tdr_area" class="form-control form-control-sm"> </div> <div class="col-md-4"> <label class="form-label small fw-bold">RR Rate per Sq.m</label> <input type="text" name="rr_rate" class="form-control form-control-sm"> </div> <div class="col-md-4"> <label class="form-label small fw-bold text-success">Regular TDR MRP (Rs.)</label> <input type="text" name="reg_tdr_mrp" class="form-control form-control-sm"> </div> <div class="col-md-4"> <label class="form-label small fw-bold">Slum TDR Area (Sq.m)</label> <input type="text" name="slum_tdr_area" class="form-control form-control-sm"> </div> <div class="col-md-4"> <label class="form-label small fw-bold text-success">Slum TDR MRP (Rs.)</label> <input type="text" name="slum_tdr_mrp" class="form-control form-control-sm" > </div> <!-- Stage, Priority & Closing Target Date --> <div class="col-md-4"> <label class="form-label small fw-bold">Intake Track Stage</label> <select name="stage_id" class="form-select form-select-sm"> <?php $stg_q = mysqli_query($conn, "SELECT * FROM lead_stages ORDER BY id ASC"); while($s = mysqli_fetch_assoc($stg_q)){ echo "<option value='{$s['id']}'>".htmlspecialchars($s['name'])."</option>"; } ?> </select> </div> <div class="col-md-4"> <label class="form-label small fw-bold">Deal Priority</label> <select name="deal_priority" class="form-select form-select-sm"> <option value="--none--" selected>--none--</option> <option value="Hot">Hot – High probability, serious buyer</option> <option value="Warm">Warm – Interested but still exploring</option> <option value="Cold">Cold – Early discussion / uncertain</option> </select> </div> <div class="col-md-4"> <label class="form-label small fw-bold">Closing Target Date</label> <input type="date" name="closing_date" class="form-control form-control-sm"> </div> <!-- Description Box --> <div class="col-12"> <label class="form-label small fw-bold">Internal Description / Notes</label> <textarea name="description" class="form-control form-control-sm" rows="5" placeholder="Add specific notes, multiple requirements context, or channel partner details here..."></textarea> </div> </div> <!-- Action Buttons --> <div class="mt-4 pt-3 border-top text-end"> <a href="list.php" class="btn btn-sm btn-outline-secondary me-2">Cancel</a> <button type="submit" class="btn btn-sm btn-primary px-4"><i class="ti ti-device-floppy me-1"></i>Save Lead Record</button> </div> </form> </div> <!-- end card-body --> </div> <!-- end card --> </div> <!-- end col --> </div> <!-- end row --> </div> <!-- End Content --> <?php include "footer-heading.php"; ?> </div> <?php include "footer.php"; ?> <?php ob_end_flush(); ?>