<?php

    // For decimal fees school if school needed decimal value in fees section here we need to add those school code
    $decimalFeesSchool = array("SYRP", "demor");

// echo $url = "root.php";
// include_once("C:/wamp64/www/OnFees/demo/root.php");
// include($url);
require_once('rootphp.php');
$rootObj=new rootphp();
$rootObj->connect();
$response=$rootObj->getFeesDB();
$servername = "localhost";
 $host="localhost";
 
 
 
 $username = $response['dbUsernameFees'];
$password = $response['dbPassword'];
$dbname=$response['dbFees'];
$smsId=$response['smsId'];
$api=$response['smsApi'];
$url= $response['smsUrl'];
$schoolName= $response['schoolname'];
$startingDate= $response['startingDate'];
$endingDate= $response['endingDate'];
$trustieNumbers= $response['feesAlertNumbers'];

$code=$response['schoolCode'];


$rootcon=$rootObj->getRootCon();

 
//echo"<pre>"; print_r($response); exit;

// $dbname = "Demo1_Fees";
// create connection object  
$burl="http://".$code.".smsoft.in/school_logos";
  if(isset($_SESSION['last_year'])){
      $con=mysqli_connect($servername,$username,$password,$dbname."_2019"); 
    if (!$con)
      {
      echo"<script>alert('Database missing contact to administrator...'); window.location='logout.php';</script>";
      }   
  }
  else if(isset($_SESSION['PastYear'])){
      //echo $servername."/".$username.$_SESSION['PastYear']."/".$password."/",$dbname.$_SESSION['PastYear']; exit;
      $con=mysqli_connect($servername,$username.$_SESSION['PastYear'],$password,$dbname.$_SESSION['PastYear']); 
     if (!$con)
     {
         echo"<script>alert('Database missing contact to administrator...'); window.location='logout.php';</script>";
     }
  }
  else
  {
      //echo $servername."/".$username."/".$password."/".$dbname; exit;
     $con=mysqli_connect($servername,$username,$password,$dbname); 
    if($con)
    {
        //echo"Done"; exit;
    }
    else
    {
        echo"<script>alert('Database missing contact to administrator...'); window.location='logout.php';</script>";
    }
  }

  
//$rootObj->close();
unset($rootObj);
?>