$sem_id = $row_reg_src['sem_id'];
$course_code = $row_reg_src['course_code'];
$year_level = $row_reg_src['year_level'];
insert_reg($dest_db_con, $student_id, $reg_no, $reg_date, $year_level, $course_code, $sem_id);
$count++;
}
echo "Copy student registration success :: {$count} entries<br>";
$count = 0;
#Copy class data
$query_class_src = mysqli_query($src_db_con, "SELECT * FROM class_t") or die("Error in save_content.php : line 82 :: " . mysql_error($src_db_con));
while ($row_class_src = mysqli_fetch_array($query_class_src)) {
$subject_id = $row_class_src['subject_id'];
$faculty_id = $row_class_src['faculty_id'];
$block_id = $row_class_src['block_id'];
$sem_id = $row_class_src['sem_id'];
insert_class($dest_db_con, $subject_id, $faculty_id, $block_id, $sem_id);
$count++;
}
echo "Copy class success :: {$count} entries<br>";
$count = 0;
#Copy class schedule data
$query_class_src = mysqli_query($src_db_con, "SELECT * FROM class_schedule_t") or die("Error in save_content.php : line 82 :: " . mysql_error($src_db_con));
while ($row_class_src = mysqli_fetch_array($query_class_src)) {
$class_id = $row_class_src['class_id'];
$day = $row_class_src['day'];
$time_start = $row_class_src['time_start'];
$time_end = $row_class_src['time_start'];
$room_code = $row_class_src['room_code'];
$room_code = NULL;
insert_schedule($dest_db_con, $class_id, $day, $time_start, $time_end, $room_code);
$count++;
$classes = get_declared_classes();
$num = count($classes);
$db->query('BEGIN TRANSACTION');
for ($i = 0; $i < $num; $i++)
{
$ref = new ReflectionClass($classes[$i]);
insert_class($db, $ref);
}
$interfaces = get_declared_interfaces();
foreach ($interfaces as $interface)
{
$ref = new ReflectionClass($interface);
insert_class($db, $ref);
}
for ($i = 0; $i < $num; $i++)
{
$ref = new ReflectionClass($classes[$i]);
foreach ($ref->getInterfaces() as $name => $class)
{
if ($name == 'Reflector')
{
continue;
}
$id = $db->query_value('SELECT id FROM classes WHERE name = "' . $name . '"');
$db->insert('interfaces', array('class' => $i + 1, 'interface' => $id));
//echo $subject_title."<br>";
$faculty_id = verify_faculty_id($temp_db_con, $faculty_id);
//$block_id = get_block_id($temp_db_con, $course, get_year_level($block),$course." ".$block, $sem_id);
$course_code = insert_course($temp_db_con, $course, '');
$block_id = insert_block($temp_db_con, $course_code, get_year_level($block), $course . " " . $block, $sem_id);
//$faculty_id = get_faculty_id($temp_db_con, $faculty);
//$year_level = get_year_level($block);
$block_name = $block;
$subject_id = insert_subject($temp_db_con, $subject_code, $subject_title, $credit_units, $lec_units, $lab_units);
//$room_code = insert_room($temp_db_con, $room, NULL, NULL);
//$subject_title = preg_replace("/\([^)]+\)/","",$subject_title);
//echo $subject_title."<br> ";
#check for existing entry with id no.
if (true || $faculty_id != "") {
//echo $sem_id."<br>";
$class_id = insert_class($temp_db_con, $subject_id, $faculty_id, $block_id, $sem_id);
//echo "class_id = $class_id ";
$schedule_id = insert_schedule_entries($temp_db_con, $class_id, $day, $time, $room);
}
}
echo "Finnished Uploading File.";
$_SESSION['kiosk']['error'] = 1;
header("location: " . $referer);
} else {
echo "No file selected <br />";
}
}
//custome functions
function verify_classes_file($allDataInSheet, $len)
{
echo "verifying personnel file...<br>";
