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; }