<?php
session_start();
$path = "../";
include ($path.'include/config_db.php');
include ($path.'include/class_db.php'); 
include ($path.'include/class_display.php'); 
include ($path.'include/class_application.php'); 

$CLASS['db']   = new db();
$CLASS['db']->connect (); 
$CLASS['disp']   = new display();
$db   = $CLASS['db']; 
$disp   = $CLASS['disp']; 

$action = $_REQUEST['action'];
$tb_act_id = $_REQUEST['tb_act_id'];
$tb_act_code = $_REQUEST['tb_act_code'];
$tb_act_name = $_REQUEST['tb_act_name'];
$tb_act_object = $_REQUEST['tb_act_object'];
$tb_act_detail = $_REQUEST['tb_act_detail'];
$tb_act_num = $_REQUEST['tb_act_num'];
$tb_act_room = $_REQUEST['tb_act_room'];
$tb_act_class = $_REQUEST['tb_act_class'];
$tb_act_year = $_REQUEST['tb_act_year'];
$tb_teacher_id = $_REQUEST['tb_teacher_id'];
$tb_act_comment = $_REQUEST['tb_act_comment'];

$fetch_numact = $db->fetch_array($db->query("SELECT COUNT(tb_act_id) AS numact FROM tb_acts"));
$tb_act_code = "ACT-".sprintf("%05d",$fetch_numact['numact']+1);

$fetch_disact = $db->fetch_array($db->query("select * from tb_act_setup"));
$tb_act_num  = $fetch_disact['tb_act_setup_num'];

 	$query_int = $db->query("INSERT INTO  tb_acts (tb_act_code, tb_act_name,tb_act_object, tb_act_detail, tb_act_num, tb_act_room, tb_act_year, tb_act_status, tb_teacher_id, tb_act_comment,tb_act_class) VALUES ('".$tb_act_code."', '".$tb_act_name."','".$tb_act_object."', '".$tb_act_detail."', '".$tb_act_num."', '".$tb_act_room."', '".$tb_act_year."', '1', '".$_SESSION['sessiontuser_id']."' ,'".$tb_act_comment."','".$tb_act_class."')");
	
		print "
	<script language='javascript'>
		window.location.href='display_teacher_act.php';
	</script>
	";

 ?>