<?php
session_start();
include '../../connection/connect.php';
include '../../common/functions.php';
isLoggedIn();
$myterm = getActiveTerm();
//get active term
$activeterm = $myterm['key3'];
$credit = new credential();
//generate receipt no
$possible = '123456789BCDEFGHJKMNPQRSTVWXYZ';
$code = '';
$i = 0;
while ($i < 5) {
$code .= substr($possible, mt_rand(0, strlen($possible) - 1), 1);
$i++;
}
$sql = "SELECT * FROM tblaccount a inner join tbltransactions t on a.id=t.account_id WHERE term_id=" . $activeterm . " order by t.date asc";
$result = mysql_query($sql) or die('Cannot get Info.');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML Basic 1.1//EN" "http://www.w3.org/TR/xhtml-basic/xhtml-basic11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Skulsys|Trial Balance </title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Keywords" content="mobile applications">
<meta name="Description" content="categories.">
<link rel="stylesheet" type="text/css" href="styles.css" media="screen" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
$time = getDayTime();
echo $time;
?>
</span><?php
echo date("D M j Y g:i a");
?>
</div><br>
</div>
<div class="nav_bar">
<div style="width:inherit; float:left;"> Welcome <strong><?php
echo $_SESSION['full_name'];
?>
</strong> </div>
<div style="float:left; margin-left:100px;"><?php
$termPeriod = getActiveTerm();
?>
<strong> Term/Semester: </strong><?php
echo $termPeriod['key2'];
?>
<?php
echo $termPeriod['key1'];
?>
</div>
<div style="width:inherit; float:right; margin-right:20px"><strong><?php
echo $_SESSION['userName'];
echo '[' . $_SESSION['User_type'] . ']';
?>
</strong>[ <a href="/sms/modules/security/logout.php">logout</a> ]</div>
</div>
<?php
$current_term = getActiveTerm();
$start = "";
if ($_SESSION['User_type'] != "admin" && $_SESSION['User_type'] != "super_admin") {
echo "<script language=javascript>window.location = '/sms/index.php?view=home';</script>";
}
?>
<td width="80%" valign="top">
<!--insert data page-->
<div class="demo">
<div id="tabs">
<ul>
<li><a href="#tabs-1">Move To Next Term</a></li>
<li><a href="#tabs-2">Period Details</a></li>
<li><a href="#tabs-3">Add Term Period</a></li>
</ul>
<div id="tabs-1" ><?php
echo $start;
?>
<?php
$next_term_id = 0;
$query = "SELECT term_id as next_termid,term_name,start_date,end_date,year_name FROM term_period where start_date>(select end_date from term_period where active =1) order by start_date asc limit 1 ";
$result = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
extract($row);
$next_term_id = $next_termid;