File Manager

✏️ Edit File: /home/u625410797/domains/monothailand.com/public_html/api/solar-calculator.php

<?php
/**
 * Omni-Dynamic System - Solar Calculator & Geographic Coefficients API
 * ====================================================================
 * Core backend orchestrator managing calculation formulas, solar leads,
 * and provincial geographic coefficients (Peak Sun Hours / Utility rates).
 */

require_once 'shared_headers.php';
require_once '../conn_mono.php';

$method = $_SERVER['REQUEST_METHOD'];
$action = $_GET['action'] ?? 'settings';

// Handle POST / PUT operations
if ($method === 'POST' || $method === 'PUT') {
    $data = json_decode(file_get_contents('php://input'), true);
    
    if ($action === 'save_settings') {
        if (!$data) {
            http_response_code(400);
            echo json_encode(['success' => false, 'message' => 'Empty settings payload']);
            exit();
        }
        
        foreach ($data as $key => $val) {
            $dbKey = 'solar_' . str_replace('solar_', '', $key);
            $dbVal = $conn->real_escape_string($val);
            
            $check = $conn->query("SELECT id FROM site_settings WHERE setting_key = '$dbKey' LIMIT 1");
            if ($check && $check->num_rows > 0) {
                $conn->query("UPDATE site_settings SET setting_value = '$dbVal' WHERE setting_key = '$dbKey'");
            } else {
                $conn->query("INSERT INTO site_settings (setting_key, setting_value, category) VALUES ('$dbKey', '$dbVal', 'solar')");
            }
        }
        
        echo json_encode(['success' => true, 'message' => 'System settings updated successfully']);
        exit();
    }
    
    if ($action === 'save_coefficient') {
        if (!$data) {
            http_response_code(400);
            echo json_encode(['success' => false, 'message' => 'Empty coefficient payload']);
            exit();
        }
        
        $id = isset($data['id']) ? (int)$data['id'] : null;
        $th = $conn->real_escape_string($data['province_name_th'] ?? '');
        $en = $conn->real_escape_string($data['province_name_en'] ?? '');
        $psh = (float)($data['peak_sun_hours'] ?? 4.5);
        $rate = (float)($data['mea_pea_rate'] ?? 4.42);
        $fit = (float)($data['feed_in_tariff'] ?? 2.2);
        $deg = (float)($data['degradation_factor'] ?? 0.005);
        
        if (empty($th) || empty($en)) {
            http_response_code(400);
            echo json_encode(['success' => false, 'message' => 'Bilingual Province names are required']);
            exit();
        }
        
        if ($id) {
            // Update
            $sql = "UPDATE solar_provincial_coefficients 
                    SET province_name_th = '$th', province_name_en = '$en', 
                        peak_sun_hours = $psh, mea_pea_rate = $rate, 
                        feed_in_tariff = $fit, degradation_factor = $deg 
                    WHERE id = $id";
        } else {
            // Insert
            $sql = "INSERT INTO solar_provincial_coefficients 
                    (province_name_th, province_name_en, peak_sun_hours, mea_pea_rate, feed_in_tariff, degradation_factor) 
                    VALUES ('$th', '$en', $psh, $rate, $fit, $deg)";
        }
        
        if ($conn->query($sql)) {
            echo json_encode(['success' => true, 'message' => 'Provincial coefficient saved successfully']);
        } else {
            http_response_code(500);
            echo json_encode(['success' => false, 'message' => 'SQL Error: ' . $conn->error]);
        }
        exit();
    }
    
    if ($action === 'delete_coefficient') {
        if (!$data || !isset($data['id'])) {
            http_response_code(400);
            echo json_encode(['success' => false, 'message' => 'Coefficient ID missing']);
            exit();
        }
        
        $id = (int)$data['id'];
        $sql = "DELETE FROM solar_provincial_coefficients WHERE id = $id";
        
        if ($conn->query($sql)) {
            echo json_encode(['success' => true, 'message' => 'Provincial coefficient deleted successfully']);
        } else {
            http_response_code(500);
            echo json_encode(['success' => false, 'message' => 'SQL Error: ' . $conn->error]);
        }
        exit();
    }
    
    http_response_code(404);
    echo json_encode(['success' => false, 'message' => 'Unknown POST action']);
    exit();
}

// GET requests
if ($action === 'leads') {
    $r = $conn->query("SELECT id, name, email, phone, message, budget, created_at FROM contact_inquiries WHERE subject LIKE '%solar%' OR message LIKE '%solar%' ORDER BY created_at DESC LIMIT 50");
    $leads = [];
    
    $price_per_kw = 35000;
    $kwh_per_kw_per_month = 120;
    $elec_rate = 4.5;
    $roof_area_per_kw = 6;
    
    $settingsRes = $conn->query("SELECT setting_key, setting_value FROM site_settings WHERE setting_key LIKE 'solar_%'");
    if ($settingsRes) {
        while ($row = $settingsRes->fetch_assoc()) {
            if ($row['setting_key'] === 'solar_price_per_kw') $price_per_kw = (float)$row['setting_value'];
            if ($row['setting_key'] === 'solar_kwh_per_kw_per_month') $kwh_per_kw_per_month = (float)$row['setting_value'];
            if ($row['setting_key'] === 'solar_elec_rate') $elec_rate = (float)$row['setting_value'];
            if ($row['setting_key'] === 'solar_roof_area_per_kw') $roof_area_per_kw = (float)$row['setting_value'];
        }
    }

if ($r) {
        while ($row = $r->fetch_assoc()) {
            $budget = 0.0;
            if (!empty($row['budget'])) {
                $budget = (float)preg_replace('/[^0-9.]/', '', $row['budget']);
            }
            if ($budget <= 0) {
                if (preg_match('/(?:งบ|งบประมาณ|ราคา)\s*([0-9,]+)/u', $row['message'] ?? '', $m)) {
                    $budget = (float)str_replace(',', '', $m[1]);
                }
            }
            if ($budget <= 0) {
                $budget = 140000;
            }
            
            $system_size = round($budget / $price_per_kw, 1);
            if ($system_size <= 0) $system_size = 3.3;
            
            $monthly_bill = round($system_size * $kwh_per_kw_per_month * $elec_rate);
            $roof_area = round($system_size * $roof_area_per_kw);
            
            $row['system_size'] = $system_size;
            $row['monthly_bill'] = $monthly_bill;
            $row['roof_area'] = $roof_area;
            
            $leads[] = $row;
        }
    }
    
    echo json_encode(['success' => true, 'leads' => $leads]);
    exit();
    
} elseif ($action === 'coefficients') {
    // Read and verify coefficients
    $r = $conn->query("SELECT id, province_name_th, province_name_en, peak_sun_hours, mea_pea_rate, feed_in_tariff, degradation_factor FROM solar_provincial_coefficients ORDER BY province_name_en ASC");
    $coefficients = [];
    
    if ($r) {
        while ($row = $r->fetch_assoc()) {
            $coefficients[] = $row;
        }
    }
    
    // Auto-seed default provinces if database table is empty
    if (empty($coefficients)) {
        $seeds = [
            ['กรุงเทพมหานคร', 'Bangkok (Central)', 4.82, 4.42, 2.20, 0.005],
            ['เชียงใหม่', 'Chiang Mai (North)', 4.65, 4.42, 2.20, 0.005],
            ['ภูเก็ต', 'Phuket (South)', 4.95, 4.42, 2.20, 0.005],
            ['ชลบุรี', 'Chonburi (East)', 4.78, 4.42, 2.20, 0.005],
            ['นครราชสีมา', 'Nakhon Ratchasima (NE)', 5.02, 4.42, 2.20, 0.005]
        ];
        
        foreach ($seeds as $s) {
            $th = $conn->real_escape_string($s[0]);
            $en = $conn->real_escape_string($s[1]);
            $psh = $s[2];
            $rate = $s[3];
            $fit = $s[4];
            $deg = $s[5];
            
            $conn->query("INSERT INTO solar_provincial_coefficients 
                          (province_name_th, province_name_en, peak_sun_hours, mea_pea_rate, feed_in_tariff, degradation_factor) 
                          VALUES ('$th', '$en', $psh, $rate, $fit, $deg)");
        }
        
        // Re-query seeds
        $r = $conn->query("SELECT id, province_name_th, province_name_en, peak_sun_hours, mea_pea_rate, feed_in_tariff, degradation_factor FROM solar_provincial_coefficients ORDER BY province_name_en ASC");
        if ($r) {
            while ($row = $r->fetch_assoc()) {
                $coefficients[] = $row;
            }
        }
    }
    
    echo json_encode(['success' => true, 'coefficients' => $coefficients]);
    exit();
    
} else {
    // Settings view keys mapped
    $settings = [];
    $r = $conn->query("SELECT setting_key, setting_value FROM site_settings WHERE setting_key LIKE 'solar_%'");
    if ($r) {
        while ($row = $r->fetch_assoc()) {
            $key = str_replace('solar_', '', $row['setting_key']);
            $settings[$key] = $row['setting_value'];
        }
    }
    
    $defaults = [
        'price_per_kw'            => '35000',
        'kwh_per_kw_per_month'    => '120',
        'elec_rate'               => '4.50',
        'roof_area_per_kw'        => '6',
    ];
    $settings = array_merge($defaults, $settings);
    
    echo json_encode(['success' => true, 'settings' => $settings]);
    exit();
}

Batal

⬅ Naik ke public_html 135 item

Nama	Tipe	Ukuran	Diubah	Aksi
📄.htaccess	htaccess	124 B	2026-06-12 05:53	✏️ Edit 👁️ View
🐘about-sections.php	php	3.8 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘admin-dashboard.php	php	2.8 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘admin-users.php	php	3.2 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘banners.php	php	3.8 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘blocks.php	php	1.2 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘branches.php	php	4 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘cart.php	php	6.4 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘categories.php	php	4.6 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘contact-info.php	php	5.2 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘contact.php	php	3.1 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘coupons.php	php	3 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘cta_buttons.php	php	3.3 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘customers.php	php	1.4 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘database-viewer.php	php	4.4 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘documents.php	php	10 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘entity-types.php	php	654 B	2026-05-31 16:39	✏️ Edit 👁️ View
🐘faqs.php	php	3 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘favorites.php	php	3.6 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘features.php	php	3.6 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘file-manager.php	php	32.6 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘finance-stats.php	php	6.6 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🌐googlef2cb86b1d86d529a.html	html	53 B	2026-06-12 05:53	✏️ Edit 👁️ View
🐘hero-sections.php	php	4.5 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘image-gallery.php	php	7.7 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘index.php	php	1.6 MB	2026-06-12 05:53	✏️ Edit 👁️ View
🐘inquiries.php	php	1.4 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘inventory.php	php	3.6 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘knowledge.php	php	4.4 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘knowledge_categories.php	php	3.7 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘login.php	php	2.9 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘map-locations.php	php	3.6 KB	2026-05-31 16:39	✏️ Edit 👁️ View
📄map.xml	xml	5.3 KB	2026-06-12 05:54	✏️ Edit 👁️ View
🐘menus.php	php	6.9 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘navigation.php	php	33.3 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘omni-dynamic.php	php	5.5 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘omni-stats.php	php	1.7 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘orders.php	php	7.5 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘page-instances.php	php	889 B	2026-05-31 16:39	✏️ Edit 👁️ View
🐘pages.php	php	5.2 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘payments.php	php	8.9 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘product-attributes.php	php	5.7 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘product-images.php	php	8 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘products.php	php	14.6 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘projects.php	php	4.4 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘reviews.php	php	7.5 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘services.php	php	3.5 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘settings.php	php	1.8 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘shared_headers.php	php	836 B	2026-05-31 16:39	✏️ Edit 👁️ View
🐘shipping.php	php	2.3 KB	2026-05-31 16:39	✏️ Edit 👁️ View
📄site1.xml	xml	971.5 KB	2026-06-12 05:53	✏️ Edit 👁️ View
📄site10.xml	xml	1.7 MB	2026-06-12 05:53	✏️ Edit 👁️ View
📄site11.xml	xml	1.6 MB	2026-06-12 05:53	✏️ Edit 👁️ View
📄site12.xml	xml	1.6 MB	2026-06-12 05:53	✏️ Edit 👁️ View
📄site13.xml	xml	1.6 MB	2026-06-12 05:53	✏️ Edit 👁️ View
📄site14.xml	xml	1.7 MB	2026-06-12 05:53	✏️ Edit 👁️ View
📄site15.xml	xml	1.6 MB	2026-06-12 05:53	✏️ Edit 👁️ View
📄site16.xml	xml	1.7 MB	2026-06-12 05:53	✏️ Edit 👁️ View
📄site17.xml	xml	1.6 MB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site18.xml	xml	1.6 MB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site19.xml	xml	1.6 MB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site2.xml	xml	1.4 MB	2026-06-12 05:53	✏️ Edit 👁️ View
📄site20.xml	xml	1.4 MB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site21.xml	xml	1.8 MB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site22.xml	xml	1.6 MB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site23.xml	xml	1.5 MB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site24.xml	xml	1.1 MB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site25.xml	xml	744.7 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site26.xml	xml	750.9 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site27.xml	xml	745.8 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site28.xml	xml	747.2 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site29.xml	xml	746 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site3.xml	xml	1.8 MB	2026-06-12 05:53	✏️ Edit 👁️ View
📄site30.xml	xml	748.2 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site31.xml	xml	746.9 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site32.xml	xml	747 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site33.xml	xml	745.1 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site34.xml	xml	757.1 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site35.xml	xml	741.2 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site36.xml	xml	746.1 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site37.xml	xml	723 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄site4.xml	xml	1.5 MB	2026-06-12 05:53	✏️ Edit 👁️ View
📄site5.xml	xml	1.5 MB	2026-06-12 05:53	✏️ Edit 👁️ View
📄site6.xml	xml	1.8 MB	2026-06-12 05:53	✏️ Edit 👁️ View
📄site7.xml	xml	1.6 MB	2026-06-12 05:53	✏️ Edit 👁️ View
📄site8.xml	xml	1.7 MB	2026-06-12 05:53	✏️ Edit 👁️ View
📄site9.xml	xml	1.7 MB	2026-06-12 05:53	✏️ Edit 👁️ View
🐘sitemap.php	php	2.6 KB	2026-06-12 05:53	✏️ Edit 👁️ View
📄sitemap1.xml	xml	689.4 KB	2026-06-12 05:53	✏️ Edit 👁️ View
📄sitemap10.xml	xml	909 KB	2026-06-12 05:53	✏️ Edit 👁️ View
📄sitemap11.xml	xml	905.1 KB	2026-06-12 05:53	✏️ Edit 👁️ View
📄sitemap12.xml	xml	901.3 KB	2026-06-12 05:53	✏️ Edit 👁️ View
📄sitemap13.xml	xml	902.7 KB	2026-06-12 05:53	✏️ Edit 👁️ View
📄sitemap14.xml	xml	909.7 KB	2026-06-12 05:53	✏️ Edit 👁️ View
📄sitemap15.xml	xml	902.5 KB	2026-06-12 05:53	✏️ Edit 👁️ View
📄sitemap16.xml	xml	907 KB	2026-06-12 05:53	✏️ Edit 👁️ View
📄sitemap17.xml	xml	904.7 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap18.xml	xml	905.6 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap19.xml	xml	884.5 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap2.xml	xml	834.7 KB	2026-06-12 05:53	✏️ Edit 👁️ View
📄sitemap20.xml	xml	864.6 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap21.xml	xml	954.6 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap22.xml	xml	887.4 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap23.xml	xml	866.4 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap24.xml	xml	743.5 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap25.xml	xml	642.6 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap26.xml	xml	649.9 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap27.xml	xml	644.3 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap28.xml	xml	646.1 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap29.xml	xml	644.6 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap3.xml	xml	945.4 KB	2026-06-12 05:53	✏️ Edit 👁️ View
📄sitemap30.xml	xml	647.4 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap31.xml	xml	644.1 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap32.xml	xml	645 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap33.xml	xml	644.2 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap34.xml	xml	655.3 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap35.xml	xml	640.4 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap36.xml	xml	644.5 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap37.xml	xml	579.4 KB	2026-06-12 05:54	✏️ Edit 👁️ View
📄sitemap4.xml	xml	880.3 KB	2026-06-12 05:53	✏️ Edit 👁️ View
📄sitemap5.xml	xml	888 KB	2026-06-12 05:53	✏️ Edit 👁️ View
📄sitemap6.xml	xml	955.5 KB	2026-06-12 05:53	✏️ Edit 👁️ View
📄sitemap7.xml	xml	895.5 KB	2026-06-12 05:53	✏️ Edit 👁️ View
📄sitemap8.xml	xml	936.9 KB	2026-06-12 05:53	✏️ Edit 👁️ View
📄sitemap9.xml	xml	908.7 KB	2026-06-12 05:53	✏️ Edit 👁️ View
🐘solar-calculator.php	php	9 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘solutions.php	php	3.5 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘statistics.php	php	3 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘stream.php	php	2.5 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘testimonials.php	php	3.8 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘theme-config.php	php	4.7 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘upload.php	php	1.5 KB	2026-05-31 16:39	✏️ Edit 👁️ View
📝urls.txt	txt	11.3 MB	2026-06-12 05:53	✏️ Edit 👁️ View
🐘variations.php	php	5.8 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘videos.php	php	6.9 KB	2026-05-31 16:39	✏️ Edit 👁️ View