function get_result_teacher($dataTKB)
{
$results = [];
$result = [];
//Sheet LichGV
$sheet_num = 2;
$sheet = $dataTKB->sheets[$sheet_num]['cells'];
$persons = get_persons_teacher($dataTKB);
for ($j = 5; $j <= $dataTKB->sheets[$sheet_num]['numCols']; $j++) {
if ($sheet[8][$j] == "" || $sheet[8][$j] == "EOF") {
return;
}
$person = get_person_teacher($sheet[8][$j], $persons);
for ($i = 9; $i <= $dataTKB->sheets[$sheet_num]['numRows']; $i++) {
if ($sheet[$i][$j] == "EOF") {
return;
}
if ($sheet[$i][$j] != "") {
$string = explode("-", $sheet[$i][$j]);
$result["Person"] = $person;
$result["Date"] = date("Y-m-d", $dataTKB->sheets[$sheet_num]['cellsInfo'][$i][1]['raw']);
$result["Slot"] = $sheet[$i][3];
$result["Room"] = $string[2];
$result["Class"] = $string[1];
$result["Course"] = $string[0];
print_r($result);
array_push($results, $result);
}
}
}
//print_r($results);
return $results;
}
function get_result_teacher($dataTKB)
{
date_default_timezone_set('UTC');
$START_COL = 5;
$TEACHER_NAME_ROW = 8;
$SCHEDULE_SLOT_ROW_START = 9;
$results = array();
$result = array();
//Sheet LichGV
$sheet_num = get_LichGV_sheet($dataTKB);
$sheet = $dataTKB->sheets[$sheet_num]['cells'];
$persons = get_persons_teacher($dataTKB);
// print_r($persons);
for ($j = $START_COL; $j <= $dataTKB->sheets[$sheet_num]['numCols']; $j++) {
if (!isset($sheet[$TEACHER_NAME_ROW][$j]) || $sheet[$TEACHER_NAME_ROW][$j] == "" || $sheet[$TEACHER_NAME_ROW][$j] == "EOF") {
continue;
}
$person = get_person_teacher($sheet[$TEACHER_NAME_ROW][$j], $persons);
//print_r($person);
// echo "<br/>-----------------------------------<br/><br/>";
for ($i = $SCHEDULE_SLOT_ROW_START; $i < $dataTKB->sheets[$sheet_num]['numRows']; $i++) {
if (!isset($sheet[$i][$j]) || $sheet[$i][$j] == "EOF") {
continue;
}
// echo "Reading $i-$j <br/>";
if ($sheet[$i][$j] != "") {
$string = explode("-", $sheet[$i][$j]);
$result["Person"] = $person;
$result["Date"] = date("Y-m-d", (int) $dataTKB->sheets[$sheet_num]['cellsInfo'][$i][1]['raw'] - 86400);
//$result["Date"] = $dataTKB->sheets[$sheet_num]['cellsInfo'][$i][1]['raw'];
$result["Slot"] = $sheet[$i][3];
$result["Room"] = $string[2];
$result["Class"] = $string[1];
$result["Course"] = $string[0];
array_push($results, $result);
}
}
}
//print_r($results);
return $results;
}
