require("entities/entities.class.php");
require("entities/office.class.php");
require("entities/group_b.class.php");
require("entities/booking_b.class.php");
require("class/cls_database/db_data.php");
require("class/cls_database/db_access.class.php");
require("class/cls_database/sys_f_query.class.php");
require("class/cls_html/dropdonwlist.class.php");
require("class/cls_logic/utilities.class.php");
$str_error_html = "";
$today = date("Y-m-d");
$e_o = new office();
$e_g_b = new group_b();
$e_b_b = new booking_b();
$logic = new sys_f_query();
$ddl_o = new dropdonwlist();
$ddl_g = new dropdonwlist();
$obj_util = new utilities();
$ddl_begin_hour_b = new dropdonwlist();
$ddl_begin_minute_b = new dropdonwlist();
$ddl_end_hour_b = new dropdonwlist();
$ddl_end_minute_b = new dropdonwlist();
$ddl_begin_hour_b->recordset = $obj_util->get_hour_lst(8, 20);
$ddl_begin_hour_b->valuefield = "hour";
$ddl_begin_hour_b->textfield = "hour";
$ddl_begin_hour_b->id = "begin_hour_b";
$ddl_begin_hour_b->name = "begin_hour_b";
$ddl_begin_hour_b->valueselect = "8";
$ddl_begin_minute_b->recordset = $obj_util->get_minute_lst();
$ddl_begin_minute_b->valuefield = "minute";
$ddl_begin_minute_b->textfield = "minute";
$ddl_begin_minute_b->id = "begin_minute_b";
$ddl_begin_minute_b->name = "begin_minute_b";
$ddl_begin_minute_b->valueselect = "0";
$ddl_end_hour_b->recordset = $obj_util->get_hour_lst(8, 20);
$ddl_end_hour_b->valuefield = "hour";
$ddl_end_hour_b->textfield = "hour";
$ddl_end_hour_b->id = "end_hour_b";
$ddl_end_hour_b->name = "end_hour_b";
$ddl_end_hour_b->valueselect = "8";
$ddl_end_minute_b->recordset = $obj_util->get_minute_lst();
$ddl_end_minute_b->valuefield = "minute";
$ddl_end_minute_b->textfield = "minute";
$ddl_end_minute_b->id = "end_minute_b";
$ddl_end_minute_b->name = "end_minute_b";
$ddl_end_minute_b->valueselect = "0";
$dbcon = new db_access($host, $dbuser, $dbpass, $dbname);
// get office data for listiem.
$rs_o = $dbcon->get_table($logic->get_office_lst2($e_o));
echo $logic->get_office_lst2($e_o);
// get group data for listiem.
$rs_g = $dbcon->get_table($logic->get_group_lst($e_g_b));
for($i = 0; $i < count($rs_g); $i++){
$rs_g[$i]["groupname_display"] = $rs_g[$i][$e_g_b->f2["fname"]] . " - " . $rs_g[$i][$e_g_b->f4["fname"]];
}
$dbcon->db_close();
// set office data in office listitem
$ddl_o->recordset = $rs_o;
$ddl_o->valuefield = $e_o->f1["fname"];
$ddl_o->textfield = $e_o->f3["fname"];
$ddl_o->firstoptiontext = "-----Select-----";
$ddl_o->valueselect = 0;
$ddl_o->id = "dllOffice";
$ddl_o->name = $e_o->f1["fname"];
// set group data in group listitem
$ddl_g->recordset = $rs_g;
$ddl_g->valuefield = $e_g_b->f1["fname"];
$ddl_g->textfield = "groupname_display";
$ddl_g->firstoptiontext = "-----Select-----";
$ddl_g->valueselect = 0;
$ddl_g->id = "ddlGroup";
$ddl_g->name = $e_g_b->f1["fname"];
?>
require('header.php'); ?>
require('footer.php'); ?>