<?//require($_SERVER["DOCUMENT_ROOT"] . "/bitrix/header.php");?>
<?require($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/main/include/prolog_before.php");?>
<form action="" method="post">
    <select name="year" id="year">
        <option value="0" selected>выберите год</option>
        <option value="1">2022-2023</option>
        <option value="2">2023-2024</option>
        <option value="000000038">2024-2025</option>
    </select>
    <input type="submit" value="Отправить">
</form>
<?
if(!$_POST["year"]){exit;}
$url = 'http://192.168.3.18/Col/hs/workload/get';

$data = json_encode([
    "year" => $_POST["year"],
    "dep" => "",
    "funding" => "",
    "pt_work" => "",
    "teacher" => "0000-00039",
    "group" => "",
    "type" => ""
]);

$ch = curl_init();

curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'GET');
curl_setopt($ch, CURLOPT_POSTFIELDS, $data);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_VERBOSE, true);
curl_setopt($ch, CURLOPT_USERPWD, "lka:123");
curl_setopt($ch, CURLOPT_HTTPHEADER, [
    'Content-Type: application/json',
    'Content-Length: ' . strlen($data)
]);

$response = curl_exec($ch);
if (curl_errno($ch)) {
    echo 'Ошибка cURL: ' . curl_error($ch);
} else {
	$httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
    $jsonResponse = json_decode($response, true);
}
$result = array();
if($jsonResponse["error"]==200){
    $total = array();
    foreach ($jsonResponse["data"]["workload"] as $keyRes => $valueRes) {
        if(strpos($valueRes["semester"], "1 семестр") !== false){$sem = 1;}
        if(strpos($valueRes["semester"], "2 семестр") !== false){$sem = 2;}
        $result[$valueRes["funding"]][$valueRes["discipline"]][$valueRes["group"]][$valueRes["subgroup"]][$sem] = $valueRes;
        $total[$valueRes["funding"]][$sem]["total"] = $total[$valueRes["funding"]][$sem]["total"]+$valueRes["total"];
        $total[$valueRes["funding"]][$sem]["per_week"] = $total[$valueRes["funding"]][$sem]["per_week"]+$valueRes["per_week"];
        $total[$valueRes["funding"]][$sem]["cl_classes"] = $total[$valueRes["funding"]][$sem]["cl_classes"]+$valueRes["cl_classes"];
        $total[$valueRes["funding"]][$sem]["pr_classes"] = $total[$valueRes["funding"]][$sem]["pr_classes"]+$valueRes["pr_classes"];
        $total[$valueRes["funding"]][$sem]["pr_trainings"] = $total[$valueRes["funding"]][$sem]["pr_trainings"]+$valueRes["pr_trainings"];
        $total[$valueRes["funding"]][$sem]["lectures"] = $total[$valueRes["funding"]][$sem]["lectures"]+$valueRes["lectures"];
        $total[$valueRes["funding"]][$sem]["dist"] = $total[$valueRes["funding"]][$sem]["dist"]+$valueRes["dist"];
        $total[$valueRes["funding"]][$sem]["cp_reception"] = $total[$valueRes["funding"]][$sem]["cp_reception"]+$valueRes["cp_reception"];
        $total[$valueRes["funding"]][$sem]["cp_consultation"] = $total[$valueRes["funding"]][$sem]["cp_consultation"]+$valueRes["cp_consultation"];
        $total[$valueRes["funding"]][$sem]["consultation"] = $total[$valueRes["funding"]][$sem]["consultation"]+$valueRes["consultation"];
        $total[$valueRes["funding"]][$sem]["ind_project"] = $total[$valueRes["funding"]][$sem]["ind_project"]+$valueRes["ind_project"];
        $total[$valueRes["funding"]][$sem]["midterm_assessment"] = $total[$valueRes["funding"]][$sem]["midterm_assessment"]+$valueRes["midterm_assessment"];
        $total[$valueRes["funding"]][$sem]["exams"] = $total[$valueRes["funding"]][$sem]["exams"]+$valueRes["exams"];
        $total["Итого"][$sem]["total"] = $total["Итого"][$sem]["total"]+$valueRes["total"];
        $total["Итого"][$sem]["per_week"] = $total["Итого"][$sem]["per_week"]+$valueRes["per_week"];
        $total["Итого"][$sem]["cl_classes"] = $total["Итого"][$sem]["cl_classes"]+$valueRes["cl_classes"];
        $total["Итого"][$sem]["pr_classes"] = $total["Итого"][$sem]["pr_classes"]+$valueRes["pr_classes"];
        $total["Итого"][$sem]["pr_trainings"] = $total["Итого"][$sem]["pr_trainings"]+$valueRes["pr_trainings"];
        $total["Итого"][$sem]["lectures"] = $total["Итого"][$sem]["lectures"]+$valueRes["lectures"];
        $total["Итого"][$sem]["dist"] = $total["Итого"][$sem]["dist"]+$valueRes["dist"];
        $total["Итого"][$sem]["cp_reception"] = $total["Итого"][$sem]["cp_reception"]+$valueRes["cp_reception"];
        $total["Итого"][$sem]["cp_consultation"] = $total["Итого"][$sem]["cp_consultation"]+$valueRes["cp_consultation"];
        $total["Итого"][$sem]["consultation"] = $total["Итого"][$sem]["consultation"]+$valueRes["consultation"];
        $total["Итого"][$sem]["ind_project"] = $total["Итого"][$sem]["ind_project"]+$valueRes["ind_project"];
        $total["Итого"][$sem]["midterm_assessment"] = $total["Итого"][$sem]["midterm_assessment"]+$valueRes["midterm_assessment"];
        $total["Итого"][$sem]["exams"] = $total["Итого"][$sem]["exams"]+$valueRes["exams"];
    }
}else{
}
curl_close($ch);
?>
<style>
.td_centr {
    text-align: center; vertical-align: middle;
}
</style>
<table style="width: 100%;" border="1" width="100%" cellspacing="0" cellpadding="0">
        <tbody>
        <tr>
            <td rowspan="4">НАИМЕНОВАНИЕ ПРЕДМЕТА</td>
            <td rowspan="4">ГРУППА</td>
            <td style="text-align: left; vertical-align: top;" rowspan="4">П<br />О<br />Д<br />Г<br />Р<br />У<br />П<br />П<br />А</td>
            <td style="text-align: center;" colspan="26">Количество часов</td>
            <td rowspan="4">Всего за год</td>
        </tr>
        <tr>
            <td style="text-align: left; vertical-align: top;" rowspan="3">В<br />С<br />Е<br />Г<br />О</td>
            <td style="text-align: center;" colspan="12">I семестр</td>
            <td rowspan="3">В<br />С<br />Е<br />Г<br />О</td>
            <td style="text-align: center;" colspan="12">II семестр</td>
        </tr>
        <tr>
            <td style="text-align: center;" colspan="12">всего из них</td>
            <td style="text-align: center;" colspan="12">всего из них</td>
        </tr>
        <tr>
            <td style="text-align: center; vertical-align: top;">всего в неделю</td>
            <td style="text-align: center; vertical-align: top;">ауд. занятий</td>
            <td style="text-align: center; vertical-align: top;">практи- ческие</td>
            <td style="text-align: center; vertical-align: top;">практи- ческая подг-ка</td>
            <td style="text-align: center; vertical-align: top;">лекции</td>
            <td style="text-align: center; vertical-align: top;">дистанц. обуч.*</td>
            <td style="text-align: center; vertical-align: top;">прием КП</td>
            <td style="text-align: center; vertical-align: top;">консуль КП</td>
            <td style="text-align: center; vertical-align: top;">консуль- тации</td>
            <td style="text-align: center; vertical-align: top;">индив. проект</td>
            <td style="text-align: center; vertical-align: top;">промеж. аттест.</td>
            <td style="text-align: center; vertical-align: top;">экза- мены</td>
            <td style="text-align: center; vertical-align: top;">всего в неделю</td>
            <td style="text-align: center; vertical-align: top;">ауд. занятий</td>
            <td style="text-align: center; vertical-align: top;">практи- ческие</td>
            <td style="text-align: center; vertical-align: top;">практи- ческая подг-ка</td>
            <td style="text-align: center; vertical-align: top;">лекции</td>
            <td style="text-align: center; vertical-align: top;">дистанц. обуч.*</td>
            <td style="text-align: center; vertical-align: top;">прием КП</td>
            <td style="text-align: center; vertical-align: top;">консуль КП</td>
            <td style="text-align: center; vertical-align: top;">консуль- тации</td>
            <td style="text-align: center; vertical-align: top;">индив. проект</td>
            <td style="text-align: center; vertical-align: top;">промеж. аттест.</td>
            <td style="text-align: center; vertical-align: top;">экза- мены</td>
        </tr>
        <?foreach ($result as $keyBudget => $valueBudget) {?>
            <tr>
                <td colspan="30"><?=$keyBudget?> обучение</td>
            </tr>
            <?foreach ($valueBudget as $keyDiscipline => $valueDiscipline) {?>
                <?foreach ($valueDiscipline as $keyGroup => $valueGroup) {?>
                    <?foreach ($valueGroup as $keySybgroup => $valueSubgroup) {?>
                        <tr>
                            <td><?=$keyDiscipline?></td>
                            <td><?=$keyGroup?></td>
                            <td><?=$keySybgroup?></td>
                            <?//первый семестр?>
                            <td class="td_centr"><?=$valueSubgroup[1]["total"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[1]["per_week"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[1]["cl_classes"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[1]["pr_classes"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[1]["pr_trainings"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[1]["lectures"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[1]["dist"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[1]["cp_reception"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[1]["cp_consultation"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[1]["consultation"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[1]["ind_project"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[1]["midterm_assessment"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[1]["exams"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[2]["total"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[2]["per_week"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[2]["cl_classes"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[2]["pr_classes"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[2]["pr_trainings"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[2]["lectures"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[2]["dist"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[2]["cp_reception"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[2]["cp_consultation"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[2]["consultation"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[2]["ind_project"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[2]["midterm_assessment"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[2]["exams"] ? : ""?></td>
                            <td class="td_centr"><?=$valueSubgroup[1]["total"]+$valueSubgroup[2]["total"]?></td>
                        </tr>
                    <?}?>
                <?}?>
            <?}?>
            <tr>
                <td colspan="3">Всего</td>
                <td><?=$total[$keyBudget][1]["total"] ? : ""?></td>
                <td><?=$total[$keyBudget][1]["per_week"] ? : ""?></td>
                <td><?=$total[$keyBudget][1]["cl_classes"] ? : ""?></td>
                <td><?=$total[$keyBudget][1]["pr_classes"] ? : ""?></td>
                <td><?=$total[$keyBudget][1]["pr_trainings"] ? : ""?></td>
                <td><?=$total[$keyBudget][1]["lectures"] ? : ""?></td>
                <td><?=$total[$keyBudget][1]["dist"] ? : ""?></td>
                <td><?=$total[$keyBudget][1]["cp_reception"] ? : ""?></td>
                <td><?=$total[$keyBudget][1]["cp_consultation"] ? : ""?></td>
                <td><?=$total[$keyBudget][1]["consultation"] ? : ""?></td>
                <td><?=$total[$keyBudget][1]["ind_project"] ? : ""?></td>
                <td><?=$total[$keyBudget][1]["midterm_assessment"] ? : ""?></td>
                <td><?=$total[$keyBudget][1]["exams"] ? : ""?></td>
                <td><?=$total[$keyBudget][2]["total"] ? : ""?></td>
                <td><?=$total[$keyBudget][2]["per_week"] ? : ""?></td>
                <td><?=$total[$keyBudget][2]["cl_classes"] ? : ""?></td>
                <td><?=$total[$keyBudget][2]["pr_classes"] ? : ""?></td>
                <td><?=$total[$keyBudget][2]["pr_trainings"] ? : ""?></td>
                <td><?=$total[$keyBudget][2]["lectures"] ? : ""?></td>
                <td><?=$total[$keyBudget][2]["dist"] ? : ""?></td>
                <td><?=$total[$keyBudget][2]["cp_reception"] ? : ""?></td>
                <td><?=$total[$keyBudget][2]["cp_consultation"] ? : ""?></td>
                <td><?=$total[$keyBudget][2]["consultation"] ? : ""?></td>
                <td><?=$total[$keyBudget][2]["ind_project"] ? : ""?></td>
                <td><?=$total[$keyBudget][2]["midterm_assessment"] ? : ""?></td>
                <td><?=$total[$keyBudget][2]["exams"] ? : ""?></td>
                <td class="td_centr"><?=$total[$keyBudget][1]["total"]+$total[$keyBudget][2]["total"]?></td>
            </tr>
        <?}?>
        <tr>
            <td colspan="3">Итого</td>
            <td><?=$total["Итого"][1]["total"] ? : ""?></td>
            <td><?=$total["Итого"][1]["per_week"] ? : ""?></td>
            <td><?=$total["Итого"][1]["cl_classes"] ? : ""?></td>
            <td><?=$total["Итого"][1]["pr_classes"] ? : ""?></td>
            <td><?=$total["Итого"][1]["pr_trainings"] ? : ""?></td>
            <td><?=$total["Итого"][1]["lectures"] ? : ""?></td>
            <td><?=$total["Итого"][1]["dist"] ? : ""?></td>
            <td><?=$total["Итого"][1]["cp_reception"] ? : ""?></td>
            <td><?=$total["Итого"][1]["cp_consultation"] ? : ""?></td>
            <td><?=$total["Итого"][1]["consultation"] ? : ""?></td>
            <td><?=$total["Итого"][1]["ind_project"] ? : ""?></td>
            <td><?=$total["Итого"][1]["midterm_assessment"] ? : ""?></td>
            <td><?=$total["Итого"][1]["exams"] ? : ""?></td>
            <td><?=$total["Итого"][2]["total"] ? : ""?></td>
            <td><?=$total["Итого"][2]["per_week"] ? : ""?></td>
            <td><?=$total["Итого"][2]["cl_classes"] ? : ""?></td>
            <td><?=$total["Итого"][2]["pr_classes"] ? : ""?></td>
            <td><?=$total["Итого"][2]["pr_trainings"] ? : ""?></td>
            <td><?=$total["Итого"][2]["lectures"] ? : ""?></td>
            <td><?=$total["Итого"][2]["dist"] ? : ""?></td>
            <td><?=$total["Итого"][2]["cp_reception"] ? : ""?></td>
            <td><?=$total["Итого"][2]["cp_consultation"] ? : ""?></td>
            <td><?=$total["Итого"][2]["consultation"] ? : ""?></td>
            <td><?=$total["Итого"][2]["ind_project"] ? : ""?></td>
            <td><?=$total["Итого"][2]["midterm_assessment"] ? : ""?></td>
            <td><?=$total["Итого"][2]["exams"] ? : ""?></td>
            <td class="td_centr"><?=$total["Итого"][1]["total"]+$total["Итого"][2]["total"]?></td>
        </tr>
        </tbody>
    </table>
<?if($jsonResponse["error"]==200){}else{?>
    <p>Произошла ошибка получения данных</p>
<?}?>
<?//require($_SERVER["DOCUMENT_ROOT"] . "/bitrix/footer.php");?>
<?require($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/main/include/epilog_after.php");?>