sale.php

<?php
include "Conx.php";

header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Headers: Content-Type, Authorization');
header('Access-Control-Allow-Methods: POST, GET, OPTIONS');
header('Content-Type: application/json');

if ($_SERVER['REQUEST_METHOD'] == 'GET') {
    $stmt = $conn->prepare("
        SELECT p.id, p.name AS product, p.image, p.price, m.percentage
        FROM makesale m
        JOIN products p ON m.product_id = p.id
        WHERE p.status = 0  -- Fetch only products with status = 0
        AND m.percentage IS NOT NULL  -- Ensure percentage is filled
        AND p.name IS NOT NULL  -- Ensure product name is filled
    ");
    
    if ($stmt) {
        if ($stmt->execute()) {
            $result = $stmt->get_result();
            if ($result->num_rows > 0) {
                $products = $result->fetch_all(MYSQLI_ASSOC);
                echo json_encode(['success' => true, 'data' => $products]);
            } else {
                echo json_encode(['success' => false, 'message' => 'No products found']);
            }
        } else {
            echo json_encode([ 
                'success' => false, 
                'message' => 'Failed to execute the query', 
                'error' => $conn->error 
            ]);
        }
    } else {
        echo json_encode([ 
            'success' => false, 
            'message' => 'Failed to prepare the SQL query',
            'error' => $conn->error 
        ]);
    }
    $stmt->close();
}

$conn->close();
?>