<?php
require_once '../db_connect.php'; // Veritabanı bağlantısı

// Besin maddeleri verilerini tanımlayalım (load_config ve save_config'da kullanılacak)
$besinData = [
  1  => ['ad' => 'Kirik',               'min' => 0, 'max' => 1000],
  2  => ['ad' => 'Rutubet (N)',         'min' => 0, 'max' => 1000],
  3  => ['ad' => 'Hektolitre (N)',       'min' => 0, 'max' => 1000],
  4  => ['ad' => 'Gluten',              'min' => 0, 'max' => 1000],
  5  => ['ad' => 'Indeks',              'min' => 0, 'max' => 1000],
  6  => ['ad' => 'Sedim1',              'min' => 0, 'max' => 1000],
  7  => ['ad' => 'Sedim2',              'min' => 0, 'max' => 1000],
  8  => ['ad' => 'FN',                  'min' => 0, 'max' => 1000],
  9  => ['ad' => 'FFN',                 'min' => 0, 'max' => 1000],
  10 => ['ad' => 'ZN',                  'min' => 0, 'max' => 1000],
  11 => ['ad' => 'Su Kaldırma (ETT)',   'min' => 0, 'max' => 1000],
  12 => ['ad' => 'Direnç (ETT)',        'min' => 0, 'max' => 1000],
  13 => ['ad' => 'Elastikiyet (ETT)',   'min' => 0, 'max' => 1000],
  14 => ['ad' => 'Enerji (ETT)',        'min' => 0, 'max' => 1000],
  15 => ['ad' => 'Su Kaldırma (Frog)',  'min' => 0, 'max' => 1000],
  16 => ['ad' => 'Stabilite (Frog)',    'min' => 0, 'max' => 1000],
  17 => ['ad' => 'Yumuşama (Frog)',     'min' => 0, 'max' => 1000],
  18 => ['ad' => 'Gelişme Süresi (Frog)','min' => 0, 'max' => 1000],
  19 => ['ad' => 'Sıcaklık (AML)',       'min' => 0, 'max' => 1000],
  20 => ['ad' => 'Jelatinizasyon (AML)','min' => 0, 'max' => 1000],
  21 => ['ad' => 'Protein (NIR)',       'min' => 0, 'max' => 1000],
  22 => ['ad' => 'Kul (NIR)',           'min' => 0, 'max' => 1000],
  23 => ['ad' => 'W (NIR)',             'min' => 0, 'max' => 1000],
  24 => ['ad' => 'Sertlik (NIR)',       'min' => 0, 'max' => 1000],
  25 => ['ad' => 'Gluten (NIR)',        'min' => 0, 'max' => 1000],
  26 => ['ad' => 'Sedim (NIR)',         'min' => 0, 'max' => 1000],
  27 => ['ad' => 'Renk (NIR)',          'min' => 0, 'max' => 1000]
];

$action = $_GET['action'] ?? '';

if ($action === 'save_config') {
    header('Content-Type: application/json; charset=utf-8');
    $postData = json_decode(file_get_contents('php://input'), true);
    $name = $postData['name'] ?? '';
    $data = $postData['data'] ?? [];
    if (!$name || empty($data)) {
        echo json_encode(['message' => 'Veri eksik.']);
        exit;
    }
    // percentSelect ve scalingInput değerleri
    $percentSelect = $data['percentSelect'] ?? 100;
    $scalingInput = $data['scalingInput'] ?? 100;
    
    // Form verilerini silo indeksine göre gruplandıralım (config_details için)
    $configDetails = [];
    foreach ($data as $key => $value) {
        if (preg_match('/^h(\d+)_(?!scaled)(.+)$/', $key, $matches)) {
            $index = $matches[1];
            $field = $matches[2];
            $configDetails[$index][$field] = $value;
        }
    }
    
    // Silo isimlerini almak için ortalama tablosundan veriler
    $stmt = $pdo->query("SELECT * FROM ortalama ORDER BY silo");
    $siloRows = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    // Aynı isimde konfigürasyon varsa güncelle, yoksa ekle (configs tablosu)
    $stmt = $pdo->prepare("SELECT id FROM configs WHERE name = :name");
    $stmt->execute([':name' => $name]);
    $existing = $stmt->fetch(PDO::FETCH_ASSOC);
    if ($existing) {
        $config_id = $existing['id'];
        $stmt = $pdo->prepare("UPDATE configs SET percent_select = :percent_select, scaling_input = :scaling_input WHERE id = :id");
        $stmt->execute([
          ':percent_select' => $percentSelect, 
          ':scaling_input' => $scalingInput,
          ':id' => $config_id
        ]);
        $stmt = $pdo->prepare("DELETE FROM config_details WHERE config_id = :config_id");
        $stmt->execute([':config_id' => $config_id]);
        $stmt = $pdo->prepare("DELETE FROM config_nutrients WHERE config_id = :config_id");
        $stmt->execute([':config_id' => $config_id]);
    } else {
        $stmt = $pdo->prepare("INSERT INTO configs (name, percent_select, scaling_input) VALUES (:name, :percent_select, :scaling_input)");
        $stmt->execute([
          ':name' => $name, 
          ':percent_select' => $percentSelect,
          ':scaling_input' => $scalingInput
        ]);
        $config_id = $pdo->lastInsertId();
    }
    
    // Her silo için detay verilerini ekle (config_details)
    foreach ($siloRows as $index => $silo) {
        $min = isset($configDetails[$index]['min']) ? $configDetails[$index]['min'] : 0;
        $max = isset($configDetails[$index]['max']) ? $configDetails[$index]['max'] : 100;
        $cost = isset($configDetails[$index]['cost']) ? $configDetails[$index]['cost'] : 1;
        $solution = isset($configDetails[$index]['solution']) ? $configDetails[$index]['solution'] : 0;
        $ton = isset($configDetails[$index]['ton']) ? $configDetails[$index]['ton'] : 0;
        $nutrientFields = ['avg_kirik','avg_rutubet','avg_hektolitre','avg_gluten','avg_indeks','avg_sedim1','avg_sedim2','avg_FN','avg_FFN','avg_ZN','avg_su_kaldirma_ett','avg_direnc_ett','avg_elestikiyet_ett','avg_enerji_ett','avg_su_kaldirma_frog','avg_stabilite_frog','avg_yumusama_frog','avg_gelisme_suresi_frog','avg_sicaklik_aml','avg_jelatinizasyon_aml','avg_protein_nir','avg_kul_nir','avg_w_nir','avg_sertlik_nir','avg_gluten_nir','avg_sedim_nir','avg_renk_nir'];
        $nutrients = [];
        foreach ($nutrientFields as $field) {
            $nutrients[$field] = isset($configDetails[$index][$field]) ? $configDetails[$index][$field] : 0;
        }
    
        $params = [
            ':config_id'    => $config_id,
            ':silo_index'   => $index,
            ':silo'         => $silo['silo'],
            ':min_percent'  => $min,
            ':max_percent'  => $max,
            ':cost'         => $cost,
            ':solution'     => $solution,
            ':ton'          => $ton,
        ];
        foreach ($nutrientFields as $field) {
            $params[":$field"] = $nutrients[$field];
        }
        $stmt = $pdo->prepare("INSERT INTO config_details 
            (config_id, silo_index, silo, min_percent, max_percent, cost, solution, ton,
             avg_kirik, avg_rutubet, avg_hektolitre, avg_gluten, avg_indeks, avg_sedim1, avg_sedim2, 
             avg_FN, avg_FFN, avg_ZN, avg_su_kaldirma_ett, avg_direnc_ett, avg_elestikiyet_ett, avg_enerji_ett, 
             avg_su_kaldirma_frog, avg_stabilite_frog, avg_yumusama_frog, avg_gelisme_suresi_frog, 
             avg_sicaklik_aml, avg_jelatinizasyon_aml, avg_protein_nir, avg_kul_nir, avg_w_nir, 
             avg_sertlik_nir, avg_gluten_nir, avg_sedim_nir, avg_renk_nir)
            VALUES 
            (:config_id, :silo_index, :silo, :min_percent, :max_percent, :cost, :solution, :ton,
             :avg_kirik, :avg_rutubet, :avg_hektolitre, :avg_gluten, :avg_indeks, :avg_sedim1, :avg_sedim2, 
             :avg_FN, :avg_FFN, :avg_ZN, :avg_su_kaldirma_ett, :avg_direnc_ett, :avg_elestikiyet_ett, :avg_enerji_ett, 
             :avg_su_kaldirma_frog, :avg_stabilite_frog, :avg_yumusama_frog, :avg_gelisme_suresi_frog, 
             :avg_sicaklik_aml, :avg_jelatinizasyon_aml, :avg_protein_nir, :avg_kul_nir, :avg_w_nir, 
             :avg_sertlik_nir, :avg_gluten_nir, :avg_sedim_nir, :avg_renk_nir)");
        $stmt->execute($params);
    }
    
    // Besin maddeleri için verileri kaydedelim (config_nutrients)
    foreach ($besinData as $id => $nutrient) {
        $bmin = isset($data["b{$id}_min"]) ? $data["b{$id}_min"] : 0;
        $bmax = isset($data["b{$id}_max"]) ? $data["b{$id}_max"] : 0;
        $bactual = isset($data["b{$id}_actual"]) ? $data["b{$id}_actual"] : 0;
        $stmt = $pdo->prepare("INSERT INTO config_nutrients (config_id, besin_id, besin_ad, min, max, actual) VALUES (:config_id, :besin_id, :besin_ad, :min, :max, :actual)");
        $stmt->execute([
            ':config_id' => $config_id,
            ':besin_id'  => $id,
            ':besin_ad'  => $nutrient['ad'],
            ':min'       => $bmin,
            ':max'       => $bmax,
            ':actual'    => $bactual
        ]);
    }
    
    echo json_encode(['message' => 'Kayıt başarılı.']);
    exit;
}

if ($action === 'get_configs') {
    header('Content-Type: application/json; charset=utf-8');
    $stmt = $pdo->query("SELECT id, name FROM configs ORDER BY id DESC");
    echo json_encode($stmt->fetchAll(PDO::FETCH_ASSOC), JSON_UNESCAPED_UNICODE);
    exit;
}

if ($action === 'load_config') {
    header('Content-Type: application/json; charset=utf-8');
    $id = isset($_GET['id']) ? (int)$_GET['id'] : 0;
    $stmt = $pdo->prepare("SELECT percent_select, scaling_input FROM configs WHERE id = :id");
    $stmt->execute([':id' => $id]);
    $configHeader = $stmt->fetch(PDO::FETCH_ASSOC);
    if (!$configHeader) {
        echo json_encode(['data' => null]);
        exit;
    }
    $percentSelect = $configHeader['percent_select'];
    
    $stmt = $pdo->prepare("SELECT * FROM config_details WHERE config_id = :config_id ORDER BY silo_index ASC");
    $stmt->execute([':config_id' => $id]);
    $details = $stmt->fetchAll(PDO::FETCH_ASSOC);
    $flatData = [];
    foreach ($details as $detail) {
        $index = $detail['silo_index'];
        $flatData["h{$index}_min"] = $detail['min_percent'];
        $flatData["h{$index}_max"] = $detail['max_percent'];
        $flatData["h{$index}_cost"] = $detail['cost'];
        $flatData["h{$index}_solution"] = $detail['solution'];
        $flatData["h{$index}_ton"] = $detail['ton'];
        $nutrientFields = ['avg_kirik','avg_rutubet','avg_hektolitre','avg_gluten','avg_indeks','avg_sedim1','avg_sedim2','avg_FN','avg_FFN','avg_ZN','avg_su_kaldirma_ett','avg_direnc_ett','avg_elestikiyet_ett','avg_enerji_ett','avg_su_kaldirma_frog','avg_stabilite_frog','avg_yumusama_frog','avg_gelisme_suresi_frog','avg_sicaklik_aml','avg_jelatinizasyon_aml','avg_protein_nir','avg_kul_nir','avg_w_nir','avg_sertlik_nir','avg_gluten_nir','avg_sedim_nir','avg_renk_nir'];
        foreach ($nutrientFields as $field) {
            $flatData["h{$index}_{$field}"] = $detail[$field];
        }
    }
    
    // Besin maddeleri verilerini de yükleyelim
    $stmt = $pdo->prepare("SELECT * FROM config_nutrients WHERE config_id = :config_id ORDER BY besin_id ASC");
    $stmt->execute([':config_id' => $id]);
    $nutrientDetails = $stmt->fetchAll(PDO::FETCH_ASSOC);
    foreach ($nutrientDetails as $nutrient) {
        $bid = $nutrient['besin_id'];
        $flatData["b{$bid}_min"] = $nutrient['min'];
        $flatData["b{$bid}_max"] = $nutrient['max'];
        $flatData["b{$bid}_actual"] = $nutrient['actual'];
    }
    
    $flatData['percentSelect'] = $percentSelect;
    $flatData['scalingInput'] = $configHeader['scaling_input'];
    echo json_encode(['data' => $flatData], JSON_UNESCAPED_UNICODE);
    exit;
}

if ($action === 'delete_config') {
    header('Content-Type: application/json; charset=utf-8');
    $id = isset($_GET['id']) ? (int)$_GET['id'] : 0;
    if ($id <= 0) {
        echo json_encode(['message' => 'Geçersiz id.']);
        exit;
    }
    // Önce ilgili detayları sil
    $stmt = $pdo->prepare("DELETE FROM config_details WHERE config_id = :id");
    $stmt->execute([':id' => $id]);
    $stmt = $pdo->prepare("DELETE FROM config_nutrients WHERE config_id = :id");
    $stmt->execute([':id' => $id]);
    // Sonra ana konfigürasyonu sil
    $stmt = $pdo->prepare("DELETE FROM configs WHERE id = :id");
    $stmt->execute([':id' => $id]);
    echo json_encode(['message' => 'Silme başarılı.']);
    exit;
}

if ($action === 'wash_stock') {
    header('Content-Type: application/json; charset=utf-8');
    $postData = json_decode(file_get_contents('php://input'), true);
    if (!$postData || !isset($postData['data'])) {
        echo json_encode(['message' => 'Veri eksik.']);
        exit;
    }
    $data = $postData['data'];
    foreach ($data as $entry) {
        $silo = $entry['silo'];
        $ton = floatval($entry['ton']);
        $stmt = $pdo->prepare("UPDATE toplamstok SET net_stok = net_stok - :ton WHERE silo = :silo");
        $stmt->execute([':ton' => $ton, ':silo' => $silo]);
    }
    echo json_encode(['message' => 'Yıkama işlemi başarılı.']);
    exit;
}

$sql = "SELECT * FROM ortalama ORDER BY silo";
$stmt = $pdo->query($sql);
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);

$hammaddeFields = [
  ['key' => 'avg_kirik',               'label' => 'Kirik'],
  ['key' => 'avg_rutubet',             'label' => 'Rutubet (N)'],
  ['key' => 'avg_hektolitre',          'label' => 'Hektolitre (N)'],
  ['key' => 'avg_gluten',              'label' => 'Gluten'],
  ['key' => 'avg_indeks',              'label' => 'Indeks'],
  ['key' => 'avg_sedim1',              'label' => 'Sedim1'],
  ['key' => 'avg_sedim2',              'label' => 'Sedim2'],
  ['key' => 'avg_FN',                  'label' => 'FN'],
  ['key' => 'avg_FFN',                 'label' => 'FFN'],
  ['key' => 'avg_ZN',                  'label' => 'ZN'],
  ['key' => 'avg_su_kaldirma_ett',     'label' => 'Su Kaldırma (ETT)'],
  ['key' => 'avg_direnc_ett',          'label' => 'Direnç (ETT)'],
  ['key' => 'avg_elestikiyet_ett',     'label' => 'Elastikiyet (ETT)'],
  ['key' => 'avg_enerji_ett',          'label' => 'Enerji (ETT)'],
  ['key' => 'avg_su_kaldirma_frog',    'label' => 'Su Kaldırma (Frog)'],
  ['key' => 'avg_stabilite_frog',      'label' => 'Stabilite (Frog)'],
  ['key' => 'avg_yumusama_frog',       'label' => 'Yumuşama (Frog)'],
  ['key' => 'avg_gelisme_suresi_frog', 'label' => 'Gelişme Süresi (Frog)'],
  ['key' => 'avg_sicaklik_aml',        'label' => 'Sıcaklık (AML)'],
  ['key' => 'avg_jelatinizasyon_aml',  'label' => 'Jelatinizasyon (AML)'],
  ['key' => 'avg_protein_nir',         'label' => 'Protein (NIR)'],
  ['key' => 'avg_kul_nir',             'label' => 'Kul (NIR)'],
  ['key' => 'avg_w_nir',               'label' => 'W (NIR)'],
  ['key' => 'avg_sertlik_nir',         'label' => 'Sertlik (NIR)'],
  ['key' => 'avg_gluten_nir',          'label' => 'Gluten (NIR)'],
  ['key' => 'avg_sedim_nir',           'label' => 'Sedim (NIR)'],
  ['key' => 'avg_renk_nir',            'label' => 'Renk (NIR)']
];

$fieldMapping = [
  1  => 'avg_kirik',
  2  => 'avg_rutubet',
  3  => 'avg_hektolitre',
  4  => 'avg_gluten',
  5  => 'avg_indeks',
  6  => 'avg_sedim1',
  7  => 'avg_sedim2',
  8  => 'avg_FN',
  9  => 'avg_FFN',
  10 => 'avg_ZN',
  11 => 'avg_su_kaldirma_ett',
  12 => 'avg_direnc_ett',
  13 => 'avg_elestikiyet_ett',
  14 => 'avg_enerji_ett',
  15 => 'avg_su_kaldirma_frog',
  16 => 'avg_stabilite_frog',
  17 => 'avg_yumusama_frog',
  18 => 'avg_gelisme_suresi_frog',
  19 => 'avg_sicaklik_aml',
  20 => 'avg_jelatinizasyon_aml',
  21 => 'avg_protein_nir',
  22 => 'avg_kul_nir',
  23 => 'avg_w_nir',
  24 => 'avg_sertlik_nir',
  25 => 'avg_gluten_nir',
  26 => 'avg_sedim_nir',
  27 => 'avg_renk_nir'
];
?>
<!DOCTYPE html>
<html lang="tr">
<head>
  <meta charset="UTF-8" />

  <title>Paçal Yapma Sistemi</title>

  <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet">

  <style>
    body { background-color: #f4f7f6; }
    h1 { color: #2a9d8f; text-align: center; margin-bottom: 20px; }
    .table { background-color: #fff; box-shadow: 0 0 10px rgba(0,0,0,0.1); }
    .table thead { background-color: #264653; color: #fff; }
    th, td { text-align: center; vertical-align: middle; }
    .btn-primary { background-color: #e76f51; border: none; }
    .btn-primary:hover { background-color: #d65a3b; }
    .form-control { width: 80px; height: 28px; padding: 0.25rem 0.5rem; text-align: center; margin: 0 auto; }
    .actual-text { color: darkblue; font-weight: bold; }
    input[id*="_solution"] { font-weight: bold; color: darkblue; }
    .toggle-col { display: none; }
    .hammadde-table th, .hammadde-table td { padding: 0.3rem; font-size: 0.9rem; }


      body { background-color: #f8f9fa; }
        .container { max-width: 1200; }
        .card { margin-top: 20px; }
        .nav-btns a { margin-right: 5px; }
        .table { table-layout: auto; }
        th, td { white-space: nowrap; }
        th { 
            white-space: normal !important; 
            vertical-align: top; 
            padding-top: 10px; 
            padding-bottom: 10px;
        }


  </style>
</head>
<body>

<div class="container">
    <!-- Navigasyon -->
    <div class="card">
        <div class="card-body">
            <div class="btn-group nav-btns" role="group">
                <a href="stok.php?<?php echo htmlspecialchars($_SERVER['QUERY_STRING']); ?>" class="btn btn-primary">Buğday Giriş</a>
                <a href="ortalama.php?last4=1&<?php echo htmlspecialchars($_SERVER['QUERY_STRING']); ?>" class="btn btn-warning">Ortalama Analiz Kaydetme</a>
                <a href="rasyon.php?<?php echo htmlspecialchars($_SERVER['QUERY_STRING']); ?>" class="btn btn-secondary">Paçal Yapma</a>
                <a href="stoktakip.php?<?php echo htmlspecialchars($_SERVER['QUERY_STRING']); ?>" class="btn btn-success">Stok Giriş-Çıkış</a>
                <a href="sonuc.php?<?php echo htmlspecialchars($_SERVER['QUERY_STRING']); ?>" class="btn btn-danger">Sonuç</a>
            </div>
        </div>
    </div>
  
  <h1 class="mb-4">Paçal Yapma Sistemi</h1>
  
  <!-- Çözüm mesajı buraya taşındı -->
  <div id="solutionStatus" class="text-center mb-3"></div>
  
  <div class="text-center mb-3">
    <label for="percentSelect">Yüzde Seçin: </label>
    <select id="percentSelect" onchange="updateMaxInputs()">
      <option value="100">100</option>
      <option value="140">140</option>
      <option value="160">160</option>
    </select>
    <label for="scalingInput" style="margin-left:20px;">Yıkama Tonu: </label>
    <input type="number" id="scalingInput" value="60" style="width:80px;" oninput="updateTonSolutions()"/>
  </div>
  
  <div class="text-center mb-3">
    <button class="btn btn-secondary" style="float: left" onclick="toggleColumns()">Sütunları Göster/Gizle</button>
    <button class="btn btn-primary" style="float: inline-end" onclick="solveLP()">Hesapla (Solver)</button>
    <button class="btn btn-success" onclick="washStock()">Yıkama Yap</button>
  </div>
  <div class="text-center mb-3">
    <select id="configSelect" style="background-color:pink" onchange="loadData()">
      <option value="">Kaydedilenleri Seç</option>
    </select>
    <button class="btn btn-info" onclick="saveData()">Kaydet</button>
    <button class="btn btn-danger" onclick="deleteConfig()">Sil</button>
  </div>
  
  <div class="row">
    <div class="col-lg-7 mb-4">
      <div id="hammaddeContainer" class="table-responsive"></div>
      <div style="margin-top:10px;">
        <strong>Toplam Çözüm: <span id="totalSolution">0</span></strong>
        <strong style="margin-left:20px;">Toplam Oranlı Çözüm: <span id="totalScaledSolution">0</span></strong>
      </div>
    </div>
    <div class="col-lg-5 mb-4">
      <div id="besinContainer" class="table-responsive"></div>
    </div>
  </div>
  
  <script src="solver.js"></script>
  <script>
    const siloRows = <?php echo json_encode($rows, JSON_UNESCAPED_UNICODE); ?>;
    const hammaddeFields = <?php echo json_encode($hammaddeFields, JSON_UNESCAPED_UNICODE); ?>;
    const besinData = <?php echo json_encode($besinData, JSON_UNESCAPED_UNICODE); ?>;
    const fieldMapping = <?php echo json_encode($fieldMapping, JSON_UNESCAPED_UNICODE); ?>;
    
    function createHammaddeTable(){
      let html = `<h2 class="mb-3">Silolar (Hammaddeler)</h2>
      <table class="table table-bordered table-striped hammadde-table">
        <thead>
          <tr>
            <th>#</th>
            <th>Silo</th>
            <th>Min (%)</th>
            <th>Max (%)</th>
            <th>Fiyat (TL/kg)</th>
            <th>Çözüm (%)</th>
            <th>Ton</th>`;
      hammaddeFields.forEach(field => {
        html += `<th class="toggle-col">${field.label}</th>`;
      });
      html += `</tr></thead><tbody>`;
      siloRows.forEach((row, idx) => {
        html += `<tr>
          <td>${idx+1}</td>
          <td>${row.silo}</td>
          <td><input type="number" class="form-control" step="0.1" id="h${idx}_min" value="0"/></td>
          <td><input type="number" class="form-control" step="0.1" id="h${idx}_max" value="100"/></td>
          <td><input type="number" class="form-control" step="0.01" id="h${idx}_cost" value="1"/></td>
          <td><input type="number" class="form-control" step="0.1" id="h${idx}_solution" value="0" oninput="manualSolutionChange()"/></td>
          <td><input type="number" class="form-control" step="0.1" id="h${idx}_ton" value="0" readonly/></td>`;
        hammaddeFields.forEach(field => {
          const val = parseFloat(row[field.key] || 0);
          html += `<td class="toggle-col">
            <input type="number" class="form-control" step="0.1" id="h${idx}_${field.key}" value="${val.toFixed(2)}"/>
          </td>`;
        });
        html += `</tr>`;
      });
      html += `</tbody></table>`;
      document.getElementById('hammaddeContainer').innerHTML = html;
    }
    
    function createBesinTable(){
      let html = `<h2 class="mb-3">Besin Maddeleri</h2>
      <table class="table table-bordered table-striped">
        <thead>
          <tr>
            <th>ID</th>
            <th>Besin Adı</th>
            <th>Min</th>
            <th>Max</th>
            <th>Gerçekleşen</th>
          </tr>
        </thead>
        <tbody>`;
      Object.keys(besinData).forEach(id => {
        const b = besinData[id];
        html += `<tr>
          <td>${id}</td>
          <td>${b.ad}</td>
          <td><input type="number" class="form-control" id="b${id}_min" value="${b.min}" step="0.1"/></td>
          <td><input type="number" class="form-control" id="b${id}_max" value="${b.max}" step="0.1"/></td>
          <td><span class="actual-text" id="b${id}_actual">0</span></td>
        </tr>`;
      });
      html += `</tbody></table>`;
      document.getElementById('besinContainer').innerHTML = html;
    }
    
    function recalcNutrients(){
      Object.keys(besinData).forEach(bID => {
        let total = 0, sumSolution = 0;
        const colKey = fieldMapping[bID];
        if(!colKey) return;
        siloRows.forEach((row, idx) => {
          const solPercent = parseFloat(document.getElementById(`h${idx}_solution`).value) || 0;
          const val = parseFloat(document.getElementById(`h${idx}_${colKey}`).value) || 0;
          total += solPercent * val;
          sumSolution += solPercent;
        });
        let actualVal = (sumSolution > 0) ? total / sumSolution : 0;
        document.getElementById(`b${bID}_actual`).textContent = actualVal.toFixed(2);
      });
    }
    
    function manualSolutionChange(){
      recalcNutrients();
      updateTotalSolution();
      updateTotalCost();
      updateTonSolutions();
    }
    
    function updateTotalCost() {
      let totalCost = 0;
      siloRows.forEach((_, i) => {
        const cost = parseFloat(document.getElementById(`h${i}_cost`).value) || 0;
        const sol = parseFloat(document.getElementById(`h${i}_solution`).value) || 0;
        totalCost += cost * sol;
      });
      document.getElementById('solutionStatus').innerHTML =
        '<span style="color:blue;font-size:22px;font-weight:bold">Toplam Maliyet = ' + totalCost.toFixed(2) + ' TL</span>';
    }
    
    function updateTotalSolution(){
      let sum = 0;
      siloRows.forEach((_, idx) => {
        sum += parseFloat(document.getElementById(`h${idx}_solution`).value) || 0;
      });
      document.getElementById('totalSolution').textContent = sum.toFixed(2);
    }
    
    function updateTonSolutions(){
      let target = parseFloat(document.getElementById('scalingInput').value) || 100;
      let totalSolution = 0;
      siloRows.forEach((_, idx) => {
        totalSolution += parseFloat(document.getElementById(`h${idx}_solution`).value) || 0;
      });
      siloRows.forEach((_, idx) => {
        let solVal = parseFloat(document.getElementById(`h${idx}_solution`).value) || 0;
        let tonVal = (totalSolution > 0) ? (solVal / totalSolution) * target : 0;
        document.getElementById(`h${idx}_ton`).value = tonVal.toFixed(2);
      });
      updateTotalTonSolution();
    }
    
    function updateTotalTonSolution(){
      let sumTon = 0;
      siloRows.forEach((_, idx) => {
        sumTon += parseFloat(document.getElementById(`h${idx}_ton`).value) || 0;
      });
      document.getElementById('totalScaledSolution').textContent = sumTon.toFixed(2);
    }
    
  function animateSolutionMessage(message, color) {
    let solutionStatus = document.getElementById('solutionStatus');
    solutionStatus.innerHTML = `<span id="solutionText" style="color:${color};font-size:22px;font-weight:bold; display: inline-block;">${message}</span>`;

    let solutionText = document.getElementById('solutionText');
    solutionText.style.transition = "transform 0.2s ease-in-out";
    solutionText.style.transform = "scale(1.5)";

    setTimeout(() => {
        solutionText.style.transform = "scale(1)";
    }, 500);
}

// Solver çözüm sağladıktan sonra bu fonksiyonu çağır
function solveLP(){
    let model = {
        optimize: "cost",
        opType: "min",
        constraints: {},
        variables: {}
    };

    let selectedPercent = parseFloat(document.getElementById("percentSelect").value);
    model.constraints.sumPct = { equal: selectedPercent };

    let activeIndices = [];
    siloRows.forEach((row, i) => {
        let maxVal = parseFloat(document.getElementById(`h${i}_max`).value);
        if(maxVal > 0){
            activeIndices.push(i);
        } else {
            document.getElementById(`h${i}_solution`).value = "0.00";
            model.constraints[`silo${i}_lower`] = { min: 0 };
            model.constraints[`silo${i}_upper`] = { max: 0 };
        }
    });

    activeIndices.forEach(i => {
        const minVal = parseFloat(document.getElementById(`h${i}_min`).value) || 0;
        const maxVal = parseFloat(document.getElementById(`h${i}_max`).value) || 100;
        model.constraints[`silo${i}_lower`] = { min: minVal };
        model.constraints[`silo${i}_upper`] = { max: maxVal };

        const varName = `silo_${i}`;
        const costVal = parseFloat(document.getElementById(`h${i}_cost`).value) || 1;
        let variableDef = {
            cost: costVal,
            sumPct: 1
        };
        variableDef[`silo${i}_lower`] = 1;
        variableDef[`silo${i}_upper`] = 1;
        Object.keys(besinData).forEach(bID => {
            const colKey = fieldMapping[bID];
            if(!colKey) return;
            const val = parseFloat(document.getElementById(`h${i}_${colKey}`).value) || 0;
            variableDef[`nutrient${bID}_min`] = val;
            variableDef[`nutrient${bID}_max`] = val;
        });
        model.variables[varName] = variableDef;
    });

    Object.keys(besinData).forEach(bID => {
        const bMin = parseFloat(document.getElementById(`b${bID}_min`).value) || 0;
        const bMax = parseFloat(document.getElementById(`b${bID}_max`).value) || 999999;
        model.constraints[`nutrient${bID}_min`] = { min: bMin * selectedPercent };
        model.constraints[`nutrient${bID}_max`] = { max: bMax * selectedPercent };
    });

    let results = solver.Solve(model);
    if (!results.feasible) {
        animateSolutionMessage("Çözüm Sağlanamadı (Çözümsüz)", "red");
        return;
    }

    activeIndices.forEach(i => {
        const varName = `silo_${i}`;
        const val = results[varName] ? results[varName] : 0;
        document.getElementById(`h${i}_solution`).value = val.toFixed(2);
    });

    recalcNutrients();
    updateTotalSolution();
    updateTonSolutions();
    animateSolutionMessage(`Çözüm Sağlandı. Toplam Maliyet = ${results.result.toFixed(2)} TL`, "blue");
}


    function toggleColumns(){
      const cols = document.querySelectorAll('.toggle-col');
      cols.forEach(col => {
        col.style.display = (col.style.display === 'none' || col.style.display === '') ? 'table-cell' : 'none';
      });
    }
    
    function updateMaxInputs(){
      let selectedValue = document.getElementById('percentSelect').value;
      siloRows.forEach((row, idx) => {
        let maxInput = document.getElementById(`h${idx}_max`);
        if(maxInput) {
           maxInput.value = selectedValue;
        }
      });
    }
    
    function saveData(){
      if(!confirm("Kaydetmek istediğinize emin misiniz?")) return;
      const name = prompt("Kaydetmek için isim giriniz:");
      if(!name) return;
      let data = {};
      document.querySelectorAll('input[type="number"]').forEach(input => {
        data[input.id] = input.value;
      });
      data["percentSelect"] = document.getElementById("percentSelect").value;
      Object.keys(besinData).forEach(id => {
        data["b" + id + "_actual"] = document.getElementById("b" + id + "_actual").textContent;
      });
      fetch('?action=save_config', {
        method: 'POST',
        headers: { 'Content-Type': 'application/json' },
        body: JSON.stringify({ name, data })
      })
      .then(res => res.json())
      .then(resp => {
        alert(resp.message);
        loadConfigs();
      });
    }
    
    function deleteConfig(){
      const id = document.getElementById('configSelect').value;
      if(!id) {
        alert("Lütfen silinecek kaydı seçin.");
        return;
      }
      if(!confirm("Kaydı silmek istediğinize emin misiniz?")) return;
      fetch('?action=delete_config&id=' + id)
        .then(res => res.json())
        .then(resp => {
          alert(resp.message);
          loadConfigs();
        });
    }
    
    function loadConfigs(){
      fetch('?action=get_configs')
        .then(res => res.json())
        .then(configs => {
          const sel = document.getElementById('configSelect');
          sel.innerHTML = '<option value="">Kaydedilenleri Seç</option>';
          configs.forEach(conf => {
            let opt = document.createElement('option');
            opt.value = conf.id;
            opt.textContent = conf.name;
            sel.appendChild(opt);
          });
        });
    }
    
    function loadData(){
      const id = document.getElementById('configSelect').value;
      if(!id) return;
      fetch('?action=load_config&id=' + id)
        .then(res => res.json())
        .then(resp => {
          if(resp.data){
            let percent = parseInt(resp.data.percentSelect);
            document.getElementById("percentSelect").value = percent;
            document.getElementById("scalingInput").value = resp.data.scalingInput;
            for(let key in resp.data){
              if(key === "percentSelect" || key === "scalingInput") continue;
              let inp = document.getElementById(key);
              if(inp) inp.value = resp.data[key];
            }
            recalcNutrients();
            updateTotalSolution();
            updateTonSolutions();
          }
        });
    }
    
    function washStock() {
      if (!confirm("Yıkama yapmak istediğinize emin misiniz?")) return;
    
      let data = [];
      siloRows.forEach((row, idx) => {
        let tonVal = parseFloat(document.getElementById(`h${idx}_ton`).value) || 0;
        let siloName = row.silo;
        data.push({ silo: siloName, ton: tonVal });
      });
    
      fetch('?action=wash_stock', {
        method: 'POST',
        headers: { 'Content-Type': 'application/json' },
        body: JSON.stringify({ data: data })
      })
      .then(res => res.json())
      .then(resp => {
        alert(resp.message);
        // Wash_log.php entegrasyonu
        let configId = document.getElementById('configSelect').value || 0;
        fetch('wash_log.php?config_id=' + configId)
          .then(res => res.json())
          .then(logResp => {
            console.log(logResp.message);
          });
      });
    }
    
 window.onload = () => {
    createHammaddeTable();
    createBesinTable();
    recalcNutrients();
    updateTotalSolution();
    updateTonSolutions();
    loadConfigs();
    
    // Tüm inputları text olarak değiştir
    document.querySelectorAll('input').forEach(input => {
        input.type = "text";
    });
};

  </script>
  <script src="https://unpkg.com/javascript-lp-solver@0.4.24/lib/solver.js"></script>
  <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/js/bootstrap.bundle.min.js"></script>
<div class="text-center mt-4">
  <a href="../logout.php" class="btn btn-danger">Çıkış Yap</a>
</div>