Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/style29.in/public_html/admin

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: gst-reports.php

<?php
// gst-reports.php
include('includes/db.php');

function h($v){ return htmlspecialchars((string)$v, ENT_QUOTES, 'UTF-8'); }
function moneyf($n){ return number_format((float)$n, 2); }

// ---------- Config ----------
$GST_RATE = 18.0;          // % total GST
$CGST_RATE = $GST_RATE/2;  // 9%
$SGST_RATE = $GST_RATE/2;  // 9%
$ASSUME_INCLUSIVE = true;  // invoice totals include GST

// ---------- Month selector (default: current month) ----------
$currYm = date('Y-m');
$ym = isset($_GET['month']) && preg_match('/^\d{4}\-\d{2}$/', $_GET['month']) ? $_GET['month'] : $currYm;

// First and last date-time of selected month
$start = date('Y-m-01 00:00:00', strtotime($ym . '-01'));
$end   = date('Y-m-t 23:59:59', strtotime($ym . '-01'));

// Escape for SQL
$startEsc = mysqli_real_escape_string($conn, $start);
$endEsc   = mysqli_real_escape_string($conn, $end);

// ---------- Fetch invoices for selected month ----------
$invoices = [];
$sqlMonthInv = "
  SELECT id, invoice_number, total, payment_method, created_at
  FROM invoices
  WHERE created_at BETWEEN '{$startEsc}' AND '{$endEsc}'
  ORDER BY created_at ASC, id ASC
";
$res = mysqli_query($conn, $sqlMonthInv);
if($res){
  while($r = mysqli_fetch_assoc($res)){
    $invoices[] = $r;
  }
}

// ---------- Compute month KPIs ----------
$sumInvoice = 0.0;
foreach($invoices as $inv){ $sumInvoice += (float)$inv['total']; }

if($ASSUME_INCLUSIVE){
  // Taxable = Total / (1 + R/100)
  $taxable = ($GST_RATE > 0) ? ($sumInvoice / (1 + $GST_RATE/100)) : $sumInvoice;
  $gst     = $sumInvoice - $taxable;
} else {
  $taxable = $sumInvoice;
  $gst     = $taxable * ($GST_RATE/100);
}
$cgst = $gst * ($CGST_RATE / $GST_RATE);   // split equally
$sgst = $gst * ($SGST_RATE / $GST_RATE);   // split equally

// ---------- Per-invoice computed rows ----------
$rows = [];
foreach($invoices as $inv){
  $total = (float)$inv['total'];
  if($ASSUME_INCLUSIVE){
    $lineTaxable = ($GST_RATE > 0) ? ($total / (1 + $GST_RATE/100)) : $total;
    $lineGST     = $total - $lineTaxable;
  } else {
    $lineTaxable = $total;
    $lineGST     = $lineTaxable * ($GST_RATE/100);
  }
  $lineCGST = $lineGST * ($CGST_RATE / $GST_RATE);
  $lineSGST = $lineGST * ($SGST_RATE / $GST_RATE);

// date formatting
  $created = $inv['created_at'];
  if($ts = strtotime($created)) { $created = date('Y-m-d H:i', $ts); }

$rows[] = [
    'no'      => $inv['invoice_number'],
    'date'    => $created,
    'pay'     => strtoupper($inv['payment_method']),
    'total'   => $total,
    'taxable' => $lineTaxable,
    'gst'     => $lineGST,
    'cgst'    => $lineCGST,
    'sgst'    => $lineSGST
  ];
}

// ---------- Previous 12 months summary ----------
$prevMonths = [];
$sqlPrev = "
  SELECT DATE_FORMAT(created_at, '%Y-%m') AS ym, COUNT(*) AS orders, COALESCE(SUM(total),0) AS gross
  FROM invoices
  WHERE created_at >= DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 12 MONTH), '%Y-%m-01')
  GROUP BY ym
  ORDER BY ym DESC
  LIMIT 13
";
$rp = mysqli_query($conn, $sqlPrev);
if($rp){
  while($r = mysqli_fetch_assoc($rp)){
    $gross = (float)$r['gross'];
    if($ASSUME_INCLUSIVE){
      $ptaxable = ($GST_RATE > 0) ? ($gross / (1 + $GST_RATE/100)) : $gross;
      $pgst     = $gross - $ptaxable;
    } else {
      $ptaxable = $gross;
      $pgst     = $ptaxable * ($GST_RATE/100);
    }
    $pcgst = $pgst * ($CGST_RATE / $GST_RATE);
    $psgst = $pgst * ($SGST_RATE / $GST_RATE);

$prevMonths[] = [
      'ym'      => $r['ym'],
      'orders'  => (int)$r['orders'],
      'gross'   => $gross,
      'taxable' => $ptaxable,
      'gst'     => $pgst,
      'cgst'    => $pcgst,
      'sgst'    => $psgst,
    ];
  }
}
?>
<!doctype html>
<html lang="en">

<?php include('includes/head.php'); ?>

<div class="d-flex justify-content-between align-items-end flex-wrap gap-2 mb-3">
          <div>
            <h4 class="mb-1">GST Reports</h4>
            <div class="muted">Month: <strong><?php echo h($ym); ?></strong> (Assuming GST <?php echo $GST_RATE; ?>% inclusive)</div>
            <div class="help">Taxable = Total / (1 + <?php echo $GST_RATE; ?>/100), GST = Total − Taxable, CGST/SGST split equally.</div>
          </div>

<form method="get" class="d-flex gap-2 align-items-end">
            <div>
              <label class="form-label mb-1">Select Month</label>
              <input type="month" name="month" class="form-control form-control-sm" value="<?php echo h($ym); ?>">
            </div>
            <button class="btn btn-primary btn-sm">Apply</button>
            <a href="gst-reports.php" class="btn btn-outline-secondary btn-sm">Reset</a>
          </form>
        </div>

<div class="row g-3">
          <div class="col-md-2 col-6">
            <div class="kpi-card">
              <div class="kpi-title">Invoices</div>
              <div class="kpi-value"><?php echo count($invoices); ?></div>
            </div>
          </div>
          <div class="col-md-2 col-6">
            <div class="kpi-card">
              <div class="kpi-title">Total Invoice Value (₹)</div>
              <div class="kpi-value"><?php echo moneyf($sumInvoice); ?></div>
            </div>
          </div>
          <div class="col-md-2 col-6">
            <div class="kpi-card">
              <div class="kpi-title">Taxable Value (₹)</div>
              <div class="kpi-value"><?php echo moneyf($taxable); ?></div>
            </div>
          </div>
          <div class="col-md-2 col-6">
            <div class="kpi-card">
              <div class="kpi-title">GST @ <?php echo $GST_RATE; ?>% (₹)</div>
              <div class="kpi-value"><?php echo moneyf($gst); ?></div>
            </div>
          </div>
          <div class="col-md-2 col-6">
            <div class="kpi-card">
              <div class="kpi-title">CGST @ <?php echo $CGST_RATE; ?>% (₹)</div>
              <div class="kpi-value"><?php echo moneyf($cgst); ?></div>
            </div>
          </div>
          <div class="col-md-2 col-6">
            <div class="kpi-card">
              <div class="kpi-title">SGST @ <?php echo $SGST_RATE; ?>% (₹)</div>
              <div class="kpi-value"><?php echo moneyf($sgst); ?></div>
            </div>
          </div>
        </div>

<div class="card">
          <div class="card-body">
            <h5 class="mb-3">Invoices in <?php echo h($ym); ?> (GST @ <?php echo $GST_RATE; ?>%)</h5>
            <table id="monthInvoices" class="table table-bordered table-striped display nowrap" style="width:100%">
              <thead>
                <tr>
                  <th>#</th>
                  <th>Invoice No.</th>
                  <th>Date</th>
                  <th>Payment</th>
                  <th>Total (₹)</th>
                  <th>Taxable (₹)</th>
                  <th>GST (₹)</th>
                  <th>CGST (₹)</th>
                  <th>SGST (₹)</th>
                </tr>
              </thead>
              <tbody>
                <?php if(!empty($rows)): $i=1; foreach($rows as $r): ?>
                  <tr>
                    <td><?php echo $i++; ?></td>
                    <td><?php echo h($r['no']); ?></td>
                    <td><?php echo h($r['date']); ?></td>
                    <td><?php echo h($r['pay']); ?></td>
                    <td><?php echo moneyf($r['total']); ?></td>
                    <td><?php echo moneyf($r['taxable']); ?></td>
                    <td><?php echo moneyf($r['gst']); ?></td>
                    <td><?php echo moneyf($r['cgst']); ?></td>
                    <td><?php echo moneyf($r['sgst']); ?></td>
                  </tr>
                <?php endforeach; else: ?>
                  <tr><td colspan="9" class="text-center">No invoices for this month.</td></tr>
                <?php endif; ?>
              </tbody>
            </table>
          </div>
        </div>

<div class="card">
          <div class="card-body">
            <h5 class="mb-3">Previous Months (last 12 months)</h5>
            <table id="prevMonths" class="table table-bordered table-striped display nowrap" style="width:100%">
              <thead>
                <tr>
                  <th>#</th>
                  <th>Month (YYYY-MM)</th>
                  <th>Invoices</th>
                  <th>Total (₹)</th>
                  <th>Taxable (₹)</th>
                  <th>GST (₹)</th>
                  <th>CGST (₹)</th>
                  <th>SGST (₹)</th>
                </tr>
              </thead>
              <tbody>
                <?php if(!empty($prevMonths)): $i=1; foreach($prevMonths as $pm): ?>
                  <tr>
                    <td><?php echo $i++; ?></td>
                    <td>
                      <a href="gst-reports.php?month=<?php echo h($pm['ym']); ?>">
                        <?php echo h($pm['ym']); ?>
                      </a>
                    </td>
                    <td><?php echo (int)$pm['orders']; ?></td>
                    <td><?php echo moneyf($pm['gross']); ?></td>
                    <td><?php echo moneyf($pm['taxable']); ?></td>
                    <td><?php echo moneyf($pm['gst']); ?></td>
                    <td><?php echo moneyf($pm['cgst']); ?></td>
                    <td><?php echo moneyf($pm['sgst']); ?></td>
                  </tr>
                <?php endforeach; else: ?>
                  <tr><td colspan="8" class="text-center">No historical data.</td></tr>
                <?php endif; ?>
              </tbody>
            </table>
          </div>
        </div>

</div>
    </div>

<?php include('includes/footer.php'); ?>
  </div>
</div>

<?php include('includes/rightbar.php'); ?>
<?php include('includes/scripts.php'); ?>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: gst-reports.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation