query('SELECT DISTINCT PERIODE FROM tabelmaster WHERE PERIODE IS NOT NULL AND PERIODE != \'\' ORDER BY PERIODE DESC'); $periode_options = $periode_options_stmt->fetchAll(PDO::FETCH_COLUMN); // Handle form submission for analysis $analysis_results = []; $chart_labels_json = '[]'; $chart_data_json = '[]'; $selected_periode = $_POST['periode'] ?? 'all'; if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['run_analysis'])) { $sql = "\n SELECT\n NAMA_SALES,\n SUM(QTY) as total_qty,\n SUM(QTY * CAST(REPLACE(HARGA, ',', '') AS DECIMAL(15,2))) as total_omzet,\n AVG(CAST(REPLACE(HARGA, ',', '') AS DECIMAL(15,2))) as avg_price,\n COUNT(DISTINCT NO_FAKTUR) as transactions_count\n FROM\n tabelmaster\n WHERE 1=1"; $params = []; if ($selected_periode !== 'all') { $sql .= ' AND PERIODE = :periode'; $params[':periode'] = $selected_periode; } $sql .= ' GROUP BY NAMA_SALES HAVING SUM(QTY) > 0 ORDER BY total_omzet DESC'; $analysis_stmt = $pdo->prepare($sql); $analysis_stmt->execute($params); $analysis_results = $analysis_stmt->fetchAll(); if (!empty($analysis_results)) { $chart_labels = []; $chart_data = []; foreach ($analysis_results as $row) { $chart_labels[] = $row['NAMA_SALES']; $chart_data[] = $row['total_omzet']; } $chart_labels_json = json_encode($chart_labels); $chart_data_json = json_encode($chart_data); } } } catch (PDOException $e) { $error_message = "Database error: " . $e->getMessage(); } require_once 'header.php'; ?>
Analisa Penjualan per Sales
Hasil Analisa
Nama Sales Total Kuantitas Total Omzet Harga Rata-rata Jumlah Transaksi
Rp Rp
Hasil Analisa
Tidak ada data yang cocok dengan filter yang dipilih.