File Manager

X7ROOT File Manager

Current Path: /home/u126090504/domains/sketkaranjia.com/public_html/admin/includes

home / u126090504 / domains / sketkaranjia.com / public_html / admin / includes /

📁 ..
📄 auth.php(292 B)
📄 footer.php(4.54 KB)
📄 header.php(5.5 KB)
📄 init.php(4.22 KB)
📄 master_menu.php(670 B)
📄 sidebar.php(8.57 KB)

Editing: init.php

<?php
/* init.php — load once on every admin page (robust) */
if (session_status() === PHP_SESSION_NONE) { session_start(); }

/* ---------- includes (tolerant paths) ---------- */
try { require_once __DIR__ . '/../secure_session.php'; } catch (Throwable $e) {}
try { require_once __DIR__ . '/../includes/auth.php'; } catch (Throwable $e) {}
try { require_once __DIR__ . '/../../config.php'; } catch (Throwable $e) {}

/* ---------- normalize $conn (handle $con / $mysqli too) ---------- */
if (!isset($conn)) {
  if (isset($con) && $con instanceof mysqli)      { $conn = $con; }
  elseif (isset($mysqli) && $mysqli instanceof mysqli) { $conn = $mysqli; }
}

date_default_timezone_set('Asia/Kolkata');

/* turn on error mode but don't fatal if mysqli missing */
if (class_exists('mysqli')) {
  mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
}

if (isset($conn) && $conn instanceof mysqli && method_exists($conn, 'set_charset')) {
  $conn->set_charset('utf8mb4');
}

/* ---------- tiny helpers ---------- */
function tExists(mysqli $c,$t){ try{$q=$c->query("SHOW TABLES LIKE '".$c->real_escape_string($t)."'"); return ($q&&$q->num_rows>0);}catch(Throwable $e){return false;}}
function hCol(mysqli $c,$t,$col){ try{$q=$c->query("SHOW COLUMNS FROM `".$c->real_escape_string($t)."` LIKE '".$c->real_escape_string($col)."'"); return ($q&&$q->num_rows>0);}catch(Throwable $e){return false;}}
function pick(mysqli $c,$t,$arr){ foreach($arr as $x){ if(hCol($c,$t,$x)) return $x; } return null; }
function i($x){ return (int)($x ?? 0); }
function f($x){ return (float)($x ?? 0.0); }

/* ---------- metrics for sidebar/topbar badges (very light) ---------- */
$METRICS = [
  'payments_today_cnt' => 0,
  'homework_today_cnt' => 0,
  'admissions_total'   => 0
];

try {
  if (isset($conn) && $conn instanceof mysqli) {
    $today = date('Y-m-d');

// Payments count (today)
    foreach(['payments','payment_records','online_payments','student_payments','fees_payments'] as $t){
      if(!tExists($conn,$t)) continue;
      $A = pick($conn,$t,['amount','paid_amount','fee_amount','final_amount','total_amount']); 
      $S = pick($conn,$t,['status','payment_status']); 
      $D = pick($conn,$t,['payment_date','created_at','created_on','paid_at','date','datetime','timestamp']);
      if(!$S || !$D) continue;
      $paid = "LOWER(`$S`) IN ('paid','success','completed','approved','confirm','confirmed')";
      $st = $conn->prepare("SELECT COUNT(*) FROM `$t` WHERE $paid AND DATE(`$D`)=?");
      $st->bind_param('s',$today); $st->execute(); $st->bind_result($c); $st->fetch(); $st->close();
      $METRICS['payments_today_cnt'] = i($c);
      break;
    }

// Homework today
    foreach(['homework','homeworks','assignments','hw_assignments'] as $t){
      if(!tExists($conn,$t)) continue;
      $S = pick($conn,$t,['status','state']); 
      $D = pick($conn,$t,['assign_date','date','created_at','created_on','given_on','assigned_on']);
      if(!$S || !$D) continue;
      $active = "(LOWER(`$S`) IN ('active','published','posted') OR `$S` IS NULL)";
      $st = $conn->prepare("SELECT COUNT(*) FROM `$t` WHERE $active AND (DATE(`$D`)=? OR DATE(STR_TO_DATE(`$D`,'%d-%m-%Y'))=?)");
      $st->bind_param('ss',$today,$today); $st->execute(); $st->bind_result($c); $st->fetch(); $st->close();
      $METRICS['homework_today_cnt'] = i($c);
      break;
    }

// Online Admissions (fallback to total if no status col)
    foreach(['admissions','online_admissions','admission_forms','applications'] as $t){
      if(!tExists($conn,$t)) continue;
      $S = pick($conn,$t,['payment_status','status','final_status','admission_status']);
      if($S){
        $r=$conn->query("SELECT COUNT(*) c FROM `$t` WHERE LOWER(`$S`) IN ('paid','approved','confirmed','admitted','completed','success','accepted')")->fetch_assoc();
      } else {
        $r=$conn->query("SELECT COUNT(*) c FROM `$t`")->fetch_assoc();
      }
      $METRICS['admissions_total'] = i($r['c']); break;
    }
  }
} catch(Throwable $e){ /* keep defaults */ }

/* ---------- per-page variables (optional) ---------- */
if(!isset($PAGE_TITLE)) $PAGE_TITLE = 'Admin';
if(!isset($ACTIVE_MENU)) $ACTIVE_MENU = '';   // e.g. 'homework','payments','banners'...
?>

X7ROOT File Manager

Editing: init.php

Upload File

Create Folder