

<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: chits.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;;

// Fetch chits and member list
$conn = db_connect();

$chits = [];
$res = $conn-&gt;query(&quot;SELECT id, name, total_amount, duration_months, monthly_amount, status, start_date FROM chit_groups ORDER BY id DESC&quot;);
if ($res) {
    while ($row = $res-&gt;fetch_assoc()) {
        $chits[] = $row;
    }
    $res-&gt;free();
}

// Members for assignment
$memberList = [];
$res = $conn-&gt;query(&quot;SELECT id, name FROM members WHERE status=&#039;active&#039; ORDER BY name&quot;);
if ($res) {
    while ($row = $res-&gt;fetch_assoc()) {
        $memberList[] = $row;
    }
    $res-&gt;free();
}
$conn-&gt;close();
?&gt;
&lt;h2&gt;Chit Groups&lt;/h2&gt;
&lt;div class=&quot;d-flex justify-content-between mb-3&quot;&gt;
    &lt;h5&gt;Manage chit groups&lt;/h5&gt;
    &lt;button class=&quot;btn btn-primary&quot; data-bs-toggle=&quot;modal&quot; data-bs-target=&quot;#addChitModal&quot;&gt;Create Chit&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;ID&lt;/th&gt;
                &lt;th&gt;Name&lt;/th&gt;
                &lt;th&gt;Total Amount&lt;/th&gt;
                &lt;th&gt;Duration (months)&lt;/th&gt;
                &lt;th&gt;Monthly Amount&lt;/th&gt;
                &lt;th&gt;Status&lt;/th&gt;
                &lt;th&gt;Start Date&lt;/th&gt;
                &lt;th&gt;Actions&lt;/th&gt;
            &lt;/tr&gt;
        &lt;/thead&gt;
        &lt;tbody&gt;
            &lt;?php foreach ($chits as $c): ?&gt;
            &lt;tr&gt;
                &lt;td&gt;&lt;?php echo e($c[&#039;id&#039;]); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo e($c[&#039;name&#039;]); ?&gt;&lt;/td&gt;
                &lt;td&gt;₹&lt;?php echo number_format($c[&#039;total_amount&#039;], 2); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo e($c[&#039;duration_months&#039;]); ?&gt;&lt;/td&gt;
                &lt;td&gt;₹&lt;?php echo number_format($c[&#039;monthly_amount&#039;], 2); ?&gt;&lt;/td&gt;
                &lt;td&gt;
                    &lt;span class=&quot;badge &lt;?php echo $c[&#039;status&#039;] === &#039;active&#039; ? &#039;bg-success&#039; : &#039;bg-secondary&#039;; ?&gt;&quot;&gt;
                        &lt;?php echo ucfirst($c[&#039;status&#039;]); ?&gt;
                    &lt;/span&gt;
                &lt;/td&gt;
                &lt;td&gt;&lt;?php echo e($c[&#039;start_date&#039;]); ?&gt;&lt;/td&gt;
                &lt;td&gt;
                    &lt;button class=&quot;btn btn-sm btn-info edit-chit-btn&quot; 
                        data-id=&quot;&lt;?php echo $c[&#039;id&#039;]; ?&gt;&quot;
                        data-name=&quot;&lt;?php echo e($c[&#039;name&#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;
                        data-monthly=&quot;&lt;?php echo $c[&#039;monthly_amount&#039;]; ?&gt;&quot;
                        data-status=&quot;&lt;?php echo $c[&#039;status&#039;]; ?&gt;&quot;
                        data-start=&quot;&lt;?php echo $c[&#039;start_date&#039;]; ?&gt;&quot;&gt;Edit&lt;/button&gt;
                    &lt;button class=&quot;btn btn-sm btn-secondary assign-members-btn&quot; data-id=&quot;&lt;?php echo $c[&#039;id&#039;]; ?&gt;&quot; data-name=&quot;&lt;?php echo e($c[&#039;name&#039;]); ?&gt;&quot;&gt;Assign Members&lt;/button&gt;
                    &lt;button class=&quot;btn btn-sm btn-danger delete-chit-btn&quot; data-id=&quot;&lt;?php echo $c[&#039;id&#039;]; ?&gt;&quot;&gt;Delete&lt;/button&gt;
                &lt;/td&gt;
            &lt;/tr&gt;
            &lt;?php endforeach; ?&gt;
        &lt;/tbody&gt;
    &lt;/table&gt;
&lt;/div&gt;

&lt;!-- Add Chit Modal --&gt;
&lt;div class=&quot;modal fade&quot; id=&quot;addChitModal&quot; tabindex=&quot;-1&quot; aria-labelledby=&quot;addChitModalLabel&quot; aria-hidden=&quot;true&quot;&gt;
  &lt;div class=&quot;modal-dialog&quot;&gt;
    &lt;form id=&quot;addChitForm&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;addChitModalLabel&quot;&gt;Create Chit&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;addChitAlert&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;Name&lt;/label&gt;
            &lt;input type=&quot;text&quot; name=&quot;name&quot; class=&quot;form-control&quot; required&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Total Amount&lt;/label&gt;
            &lt;input type=&quot;number&quot; name=&quot;total_amount&quot; step=&quot;0.01&quot; class=&quot;form-control&quot; required&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Duration (months)&lt;/label&gt;
            &lt;input type=&quot;number&quot; name=&quot;duration_months&quot; class=&quot;form-control&quot; required&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Monthly Amount&lt;/label&gt;
            &lt;input type=&quot;number&quot; name=&quot;monthly_amount&quot; step=&quot;0.01&quot; class=&quot;form-control&quot; required&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Start Date&lt;/label&gt;
            &lt;input type=&quot;date&quot; name=&quot;start_date&quot; class=&quot;form-control&quot;&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;!-- Edit Chit Modal --&gt;
&lt;div class=&quot;modal fade&quot; id=&quot;editChitModal&quot; tabindex=&quot;-1&quot; aria-labelledby=&quot;editChitModalLabel&quot; aria-hidden=&quot;true&quot;&gt;
  &lt;div class=&quot;modal-dialog&quot;&gt;
    &lt;form id=&quot;editChitForm&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;editChitModalLabel&quot;&gt;Edit Chit&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;editChitAlert&quot; class=&quot;alert d-none&quot; role=&quot;alert&quot;&gt;&lt;/div&gt;
          &lt;input type=&quot;hidden&quot; name=&quot;id&quot; id=&quot;editChitId&quot;&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Name&lt;/label&gt;
            &lt;input type=&quot;text&quot; name=&quot;name&quot; id=&quot;editChitName&quot; class=&quot;form-control&quot; required&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Total Amount&lt;/label&gt;
            &lt;input type=&quot;number&quot; name=&quot;total_amount&quot; id=&quot;editChitTotal&quot; step=&quot;0.01&quot; class=&quot;form-control&quot; required&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Duration (months)&lt;/label&gt;
            &lt;input type=&quot;number&quot; name=&quot;duration_months&quot; id=&quot;editChitDuration&quot; class=&quot;form-control&quot; required&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Monthly Amount&lt;/label&gt;
            &lt;input type=&quot;number&quot; name=&quot;monthly_amount&quot; id=&quot;editChitMonthly&quot; step=&quot;0.01&quot; class=&quot;form-control&quot; required&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Status&lt;/label&gt;
            &lt;select name=&quot;status&quot; id=&quot;editChitStatus&quot; class=&quot;form-select&quot;&gt;
              &lt;option value=&quot;active&quot;&gt;Active&lt;/option&gt;
              &lt;option value=&quot;closed&quot;&gt;Closed&lt;/option&gt;
            &lt;/select&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Start Date&lt;/label&gt;
            &lt;input type=&quot;date&quot; name=&quot;start_date&quot; id=&quot;editChitStart&quot; class=&quot;form-control&quot;&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;Update&lt;/button&gt;
        &lt;/div&gt;
      &lt;/div&gt;
    &lt;/form&gt;
  &lt;/div&gt;
&lt;/div&gt;

&lt;!-- Assign Members Modal --&gt;
&lt;div class=&quot;modal fade&quot; id=&quot;assignMembersModal&quot; tabindex=&quot;-1&quot; aria-labelledby=&quot;assignMembersModalLabel&quot; aria-hidden=&quot;true&quot;&gt;
  &lt;div class=&quot;modal-dialog modal-lg&quot;&gt;
    &lt;form id=&quot;assignMembersForm&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;assignMembersModalLabel&quot;&gt;Assign Members&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;assignMembersAlert&quot; class=&quot;alert d-none&quot; role=&quot;alert&quot;&gt;&lt;/div&gt;
          &lt;input type=&quot;hidden&quot; name=&quot;chit_id&quot; id=&quot;assignChitId&quot;&gt;
          &lt;p id=&quot;assignChitName&quot; class=&quot;fw-bold&quot;&gt;&lt;/p&gt;
          &lt;div class=&quot;row&quot;&gt;
            &lt;?php foreach ($memberList as $member): ?&gt;
            &lt;div class=&quot;col-md-4&quot;&gt;
              &lt;div class=&quot;form-check&quot;&gt;
                &lt;input class=&quot;form-check-input assign-member-checkbox&quot; type=&quot;checkbox&quot; name=&quot;members[]&quot; value=&quot;&lt;?php echo $member[&#039;id&#039;]; ?&gt;&quot; id=&quot;memberCheck&lt;?php echo $member[&#039;id&#039;]; ?&gt;&quot;&gt;
                &lt;label class=&quot;form-check-label&quot; for=&quot;memberCheck&lt;?php echo $member[&#039;id&#039;]; ?&gt;&quot;&gt;
                  &lt;?php echo e($member[&#039;name&#039;]); ?&gt;
                &lt;/label&gt;
              &lt;/div&gt;
            &lt;/div&gt;
            &lt;?php endforeach; ?&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;
$(document).ready(function() {
    // Add chit submit
    $(&#039;#addChitForm&#039;).on(&#039;submit&#039;, function(e) {
        e.preventDefault();
        $.ajax({
            url: &#039;../api/chit_add.php&#039;,
            method: &#039;POST&#039;,
            data: $(this).serialize(),
            dataType: &#039;json&#039;,
            success: function(res) {
                if (res.success) {
                    location.reload();
                } else {
                    $(&#039;#addChitAlert&#039;).removeClass(&#039;d-none alert-success&#039;).addClass(&#039;alert-danger&#039;).text(res.message);
                }
            },
            error: function() {
                $(&#039;#addChitAlert&#039;).removeClass(&#039;d-none alert-success&#039;).addClass(&#039;alert-danger&#039;).text(&#039;An error occurred.&#039;);
            }
        });
    });
    // Show edit modal
    $(&#039;.edit-chit-btn&#039;).on(&#039;click&#039;, function() {
        $(&#039;#editChitId&#039;).val($(this).data(&#039;id&#039;));
        $(&#039;#editChitName&#039;).val($(this).data(&#039;name&#039;));
        $(&#039;#editChitTotal&#039;).val($(this).data(&#039;total&#039;));
        $(&#039;#editChitDuration&#039;).val($(this).data(&#039;duration&#039;));
        $(&#039;#editChitMonthly&#039;).val($(this).data(&#039;monthly&#039;));
        $(&#039;#editChitStatus&#039;).val($(this).data(&#039;status&#039;));
        $(&#039;#editChitStart&#039;).val($(this).data(&#039;start&#039;));
        var editModal = new bootstrap.Modal(document.getElementById(&#039;editChitModal&#039;));
        editModal.show();
    });
    // Edit chit submit
    $(&#039;#editChitForm&#039;).on(&#039;submit&#039;, function(e) {
        e.preventDefault();
        $.ajax({
            url: &#039;../api/chit_edit.php&#039;,
            method: &#039;POST&#039;,
            data: $(this).serialize(),
            dataType: &#039;json&#039;,
            success: function(res) {
                if (res.success) {
                    location.reload();
                } else {
                    $(&#039;#editChitAlert&#039;).removeClass(&#039;d-none alert-success&#039;).addClass(&#039;alert-danger&#039;).text(res.message);
                }
            },
            error: function() {
                $(&#039;#editChitAlert&#039;).removeClass(&#039;d-none alert-success&#039;).addClass(&#039;alert-danger&#039;).text(&#039;An error occurred.&#039;);
            }
        });
    });
    // Delete chit
    $(&#039;.delete-chit-btn&#039;).on(&#039;click&#039;, function() {
        if (!confirm(&#039;Are you sure you want to delete this chit?&#039;)) return;
        const id = $(this).data(&#039;id&#039;);
        $.ajax({
            url: &#039;../api/chit_delete.php&#039;,
            method: &#039;POST&#039;,
            data: { id: id },
            dataType: &#039;json&#039;,
            success: function(res) {
                if (res.success) {
                    location.reload();
                } else {
                    alert(res.message);
                }
            },
            error: function() {
                alert(&#039;An error occurred.&#039;);
            }
        });
    });
    // Show assign members modal
    $(&#039;.assign-members-btn&#039;).on(&#039;click&#039;, function() {
        const chitId = $(this).data(&#039;id&#039;);
        const chitName = $(this).data(&#039;name&#039;);
        $(&#039;#assignChitId&#039;).val(chitId);
        $(&#039;#assignChitName&#039;).text(&#039;Chit: &#039; + chitName);
        // Uncheck all checkboxes
        $(&#039;.assign-member-checkbox&#039;).prop(&#039;checked&#039;, false);
        // Fetch existing assignments via ajax
        $.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) {
                    res.members.forEach(function(mid) {
                        $(&#039;#memberCheck&#039; + mid).prop(&#039;checked&#039;, true);
                    });
                    var assignModal = new bootstrap.Modal(document.getElementById(&#039;assignMembersModal&#039;));
                    assignModal.show();
                } else {
                    alert(res.message);
                }
            },
            error: function() {
                alert(&#039;An error occurred while loading members.&#039;);
            }
        });
    });
    // Assign members submit
    $(&#039;#assignMembersForm&#039;).on(&#039;submit&#039;, function(e) {
        e.preventDefault();
        $.ajax({
            url: &#039;../api/chit_assign.php&#039;,
            method: &#039;POST&#039;,
            data: $(this).serialize(),
            dataType: &#039;json&#039;,
            success: function(res) {
                if (res.success) {
                    location.reload();
                } else {
                    $(&#039;#assignMembersAlert&#039;).removeClass(&#039;d-none alert-success&#039;).addClass(&#039;alert-danger&#039;).text(res.message);
                }
            },
            error: function() {
                $(&#039;#assignMembersAlert&#039;).removeClass(&#039;d-none alert-success&#039;).addClass(&#039;alert-danger&#039;).text(&#039;An error occurred.&#039;);
            }
        });
    });
});
&lt;/script&gt;
&lt;?php
require_once __DIR__ . &#039;/footer.php&#039;;</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/qbfdcvcb/cms.enginx.in/admin/chits.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>