}
if (!file_exists("arhiv/faculty/" . rus2translit($student[0][3]) . "/" . rus2translit($student[0][2]) . "/Semester " . rus2translit($student[0][4]) . "/Date " . $date . "/Vidomist/")) {
mkdir("arhiv/faculty/" . rus2translit($student[0][3]) . "/" . rus2translit($student[0][2]) . "/Semester " . rus2translit($student[0][4]) . "/Date " . $date . "/Vidomist/");
}
if (!file_exists("arhiv/faculty/" . rus2translit($student[0][3]) . "/" . rus2translit($student[0][2]) . "/Semester " . rus2translit($student[0][4]) . "/Date " . $date . "/Statistick/")) {
mkdir("arhiv/faculty/" . rus2translit($student[0][3]) . "/" . rus2translit($student[0][2]) . "/Semester " . rus2translit($student[0][4]) . "/Date " . $date . "/Statistick/");
}
if (@fopen($_GET['file'], "r")) {
rename($_GET['file'], "arhiv/faculty/" . rus2translit($student[0][3]) . "/" . rus2translit($student[0][2]) . "/Semester " . rus2translit($student[0][4]) . "/Date " . $date . "/original.xls");
}
for ($i = 0; $i < count($discipline); $i++) {
$plan = $contingent->select("select bvm.modulenum,gd.discipline,bvm.moduletheme,BT.SEMESTER from STUDENT2TESTLIST S2T\n\t\t inner join B_TESTLIST BT on (BT.TESTLISTID = S2T.TESTLISTID) inner join B_VARIANT_ITEMS BVI_M on (BVI_M.VARIANTID = BT.VARIANTID) inner join b_variant_module bvm \n\t\t\ton (BVI_M.VARIANTID = bvm.VARIANTID) inner join B_VARIANT_ITEMS BVI_V on (BVI_V.VARIANTID = BVI_M.PARENTVARIANTID) inner join guide_discipline gd\n\t\t\ton (BVI_V.disciplineid = gd.disciplineid) where BT.TESTLISTID=" . $discipline[$i][2] . "");
for ($j = 0; $j < count($group); $j++) {
$tochn = $local->select("SELECT COUNT(value) FROM `zv`,`to` WHERE zv.name_user='******'role'] . "' AND zv.idstyd=to.idstyd AND to.num=" . $discipline[$i][1] . " AND zv.gr=" . $group[$j][0] . " AND to.value='true'");
if ($tochn[0][0] != '0') {
$stream = "<html>\n\t\t\t\t\t\t<head>\n\t\t\t\t\t\t\t<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>\n\t\t\t\t\t\t<style> \n\t\t\t\t\t\tbody {font-size:14px;} \n\t\t\t\t\t\t</style> \n\t\t\t\t\t</head>\n\t\t\t\t\t<body>\n \n\t\t\t\t\t<p align=center>МІНІСТЕРСТВО ОХОРОНИ ЗДОРОВЯ УКРАЇНИ </p>\n\t\t\t\t\t<p align=center><b><u>Тернопільський державний медичний університет імені І.Я. Горбачевського</u></b></p>\n\t\t\t\t\t<span align=left> Факультет <u>" . $student[0][3] . "</u></span><br>\n\t\t\t\t\t<span align=left> Спеціальність <u>" . $student[0][2] . "</u></span>\n \t\t\t\t <span align=right> Група_<u>" . $student[0][5] . "</u>___</span>\n\t\t\t\t\t 2012/2013 навчальний рік \n \t\t \n Курс _<u>" . course($student[0][4]) . "</u>___<br />\n \t <p align=center>ЕКЗАМЕНАЦІЙНА ВІДОМІСТЬ №____ </p>\n \t <p>З <u>" . $plan[0][0] . "." . $plan[0][2] . "</u> - <u>" . $plan[0][1] . "</u></p>\n \t <p>За _<u>" . $plan[0][3] . "</u>___ навчальний семестр, екзамен <u>_" . $date . "___</u></p>\n\t\t\t\t\t <table class=guestbook width=600 align=center cellspacing=0 cellpadding=3 border=1>\n \t <tr>\n \t <td width=10%>\n \t\t\t<b>№ п/п</b>\n \t\t </td>\n \t <td width=50%>\n \t\t\t<b>Прізвище, ім'я по-батькові</b>\n \t\t </td>\n \t <td width=10%>\n \t\t\t<b>№ індиві-дуального навч. плану</b>\n \t\t </td>\n \t <td width=15%>\n \t \t\t<b>Оцінка за поточну успішність</b>\n \t \t </td>\n \n \t \t <td width=15%>\n \t\t\t<b>Екзаме-наційна оцінка</b>\n \t \t </td>\n \t <td width=10%>\n \t \t\t<b>Оцінка за модуль</b>\n \t \t </td>\n \n \t </tr>\n ";
$styd = $local->select("SELECT * FROM `zv` WHERE name_user='******'role'] . "' AND gr='" . (int) $group[$j][0] . "';");
for ($x = 0; $x < count($styd); $x++) {
if ($_POST['to'] == 'on') {
$to = $local->select("SELECT value FROM `zv`,`to` WHERE zv.name_user='******'role'] . "' AND zv.idstyd=" . $styd[$x][1] . " AND zv.idstyd=to.idstyd AND to.num=" . $discipline[$i][1] . "");
} else {
$to[0][0] = 'true';
}
if ($to[0][0] == 'true') {
$exam_styd = $local->select("SELECT oc.oc FROM `zv`,`oc` WHERE zv.name_user='******'role'] . "' AND zv.kod LIKE oc.kod AND oc.num=" . $discipline[$i][1] . " AND zv.idstyd=" . $styd[$x][1] . "");
$students = $contingent->select("SELECT STUDENTS.STUDENTID, STUDENTS.FIO,GUIDE_SPECIALITY.SPECIALITY,GUIDE_DEPARTMENT.DEPARTMENT,STUDENTS.SEMESTER, STUDENTS.GROUPNUM,STUDENTS.RECORDBOOKNUM FROM STUDENTS,GUIDE_SPECIALITY,GUIDE_DEPARTMENT WHERE STUDENTS.STUDENTID='" . $styd[$x][1] . "' AND GUIDE_SPECIALITY.SPECIALITYID=STUDENTS.SPECIALITYID AND GUIDE_DEPARTMENT.DEPARTMENTID=STUDENTS.DEPARTMENTID;");
$plans = $contingent->select("select bvm.modulenum,gd.discipline,bvm.moduletheme,S2T.TESTLISTID,S2T.CREDITS_CUR from STUDENT2TESTLIST S2T\n\t\t\t\tinner join B_TESTLIST BT on (BT.TESTLISTID = S2T.TESTLISTID) inner join B_VARIANT_ITEMS BVI_M on (BVI_M.VARIANTID = BT.VARIANTID) inner join b_variant_module bvm \n\t\t\t\ton (BVI_M.VARIANTID = bvm.VARIANTID) inner join B_VARIANT_ITEMS BVI_V on (BVI_V.VARIANTID = BVI_M.PARENTVARIANTID) inner join guide_discipline gd\n\t\t\t\ton (BVI_V.disciplineid = gd.disciplineid) where BT.TESTLISTID=" . $discipline[$i][2] . " AND S2T.STUDENTID=" . $students[0][0] . "");
if ($exam_styd[0][0] == 0 || $_POST['to'] != 'on' && $to[0][0] == 'true') {
$ex = '0(не склав)';
$ost = '(не склав)';
} else {
function courseDispatch($op)
{
if (isset($_POST['new_course'])) {
$op = 'new_course';
}
if (isset($_POST['mod_course']) || isset($_GET['mod_course'])) {
$op = 'mod_course';
}
if (isset($_POST['del_course'])) {
$op = 'del_course';
}
if (isset($_POST['del_course_edition'])) {
$op = 'del_course_edition';
}
if (isset($_POST['confirm_del_edition_course'])) {
$op = 'del_course_edition';
}
if (isset($_POST['mod_course_edition'])) {
$op = 'mod_course_edition';
}
if (isset($_POST['course_edition_modify'])) {
$op = 'confirm_mod_course_edition';
}
if (isset($_POST['course_undo'])) {
$id_course = importVar('id_course', false, 0);
$query_course = "SELECT course_type FROM " . $GLOBALS['prefix_lms'] . "_course WHERE idCourse = '" . $id_course . "'";
list($course_type) = sql_fetch_row(sql_query($query_course));
if ($course_type === 'classroom') {
Util::jump_to('index.php?r=alms/classroom/show');
} else {
$op = 'course_list';
}
}
if (isset($_POST['course_undo_edition'])) {
$op = 'course_list';
}
if (isset($_POST['assignClassroomToEd'])) {
$op = 'assignClassroomToEd';
}
if (isset($_POST['assignClassroom'])) {
$op = 'assignClassroom';
}
if (isset($_POST['classroom_to_course'])) {
$op = 'classroom_to_course';
}
if (isset($_POST['classroom_to_edition'])) {
$op = 'classroom_to_edition';
}
if (isset($_POST['classroom_to_course_ed'])) {
$op = 'classroom_to_course_ed';
}
if (isset($_POST['checkAvailableClass'])) {
$op = 'classroom_to_course';
}
if (isset($_POST['assign_menu_course'])) {
$op = 'assignMenu';
}
if (isset($_POST['move_course'])) {
$op = 'move_course';
}
if (isset($_POST['move_course_here'])) {
$op = 'move_course_upd';
}
if (isset($_POST['undo'])) {
$op = 'course_list';
}
if (isset($_POST['new_course_edition'])) {
$op = 'new_course_edition';
}
if (isset($_POST['upd_course'])) {
$op = 'upd_course';
}
if ((isset($_GET['ini_hidden']) || isset($_POST['ini_hidden'])) && $op != 'course_list') {
$_SESSION['course_category']['ini_status'] = importVar('ini_hidden', true, 0);
}
switch ($op) {
case "course_list":
course();
break;
case "new_course":
addCourse();
break;
case "add_course":
insCourse();
break;
case "del_course":
courseDelete();
break;
case "add_course_edition":
insCourseEdition();
break;
case "mod_course":
modCourse();
break;
case "new_course_edition":
newCourseEdition();
break;
case "mod_course_edition":
modCourseEdition();
break;
case "confirm_mod_course_edition":
confirmModCourseEdition();
break;
case "upd_course":
courseUpdate();
break;
case "move_course":
move_course();
break;
case "move_course_upd":
move_course_upd();
break;
case "del_course_edition":
courseEditionDelete();
break;
case "assignMenu":
assignMenu();
break;
case "classroom_to_course":
classroomToCourse();
break;
case "classroom_to_edition":
classroomToEdition();
break;
case "assignClassroomToEd":
case "assignEditionClassroom":
assignClassroomToEdition();
break;
case "assignClassroom":
assignClassroom();
break;
/*case "certifications": {
require_once($GLOBALS["where_lms"]."/admin/modules/certificate/course.certificate.php");
courseCertifications(true);
} break;
case "upd_certifications": {
require_once($GLOBALS["where_lms"]."/admin/modules/certificate/course.certificate.php");
updateCertifications();
} break;*/
}
}
Proyecto: Codeando.org
Author: Paulo Andrade
Email: paulo_866@hotmail.com
Web: http://www.pauloandrade1.com
********************************************************************/
// Obtenemos las variables por parametro
if (empty($_GET['category'])) {
$category = '';
} else {
$category = addslashes($_GET['category']);
}
// Router del admin
switch ($category) {
// curso
case 'course':
course();
break;
// Categorias
// Categorias
case 'category':
category();
break;
// Avisos de cursos
// Avisos de cursos
case 'notices':
notices();
break;
// Perfil de usuario
// Perfil de usuario
case 'profile':
profile();
<head>
<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>
<style>
body {font-size:14px;}
</style>
</head>
<body>
<p align=center>МІНІСТЕРСТВО ОХОРОНИ ЗДОРОВЯ УКРАЇНИ </p>
<p align=center><b><u>Тернопільський державний медичний університет імені І.Я. Горбачевського</u></b></p>
<span align=left> Факультет <u>".$student[0][3]."</u></span><br>
<span align=left> Спеціальність <u>".$student[0][2]."</u></span>
<span align=right> Група_<u>".$student[0][5]."</u>___</span>
2012/2013 навчальний рік
Курс _<u>".course($student[0][4])."</u>___<br />
<p align=center>ЕКЗАМЕНАЦІЙНА ВІДОМІСТЬ №____ </p>
<p>З <u>".$plan[0][0].".".$plan[0][2]."</u> - <u>".$plan[0][1]."</u></p>
<p>За _<u>".$_GET['semester']."</u>___ навчальний семестр, екзамен <u>_".$_GET['date']."___</u></p>
<table class=guestbook width=600 align=center cellspacing=0 cellpadding=3 border=1>
<tr>
<td width=10%>
<b>№ п/п</b>
</td>
<td width=50%>
<b>Прізвище, ім'я по-батькові</b>
</td>
<td width=10%>
<b>№ індиві-дуального навч. плану</b>
</td>
<td width=15%>
for ($i=0;$i<count($discipline);$i++)
{
$plan = $contingent->select("select bvm.modulenum,gd.discipline,bvm.moduletheme,BT.SEMESTER from STUDENT2TESTLIST S2T
inner join B_TESTLIST BT on (BT.TESTLISTID = S2T.TESTLISTID) inner join B_VARIANT_ITEMS BVI_M on (BVI_M.VARIANTID = BT.VARIANTID) inner join b_variant_module bvm
on (BVI_M.VARIANTID = bvm.VARIANTID) inner join B_VARIANT_ITEMS BVI_V on (BVI_V.VARIANTID = BVI_M.PARENTVARIANTID) inner join guide_discipline gd
on (BVI_V.disciplineid = gd.disciplineid) where BT.TESTLISTID=".$discipline[$i][2]."");
$zag=$local->select("SELECT count(oc.oc) FROM `oc`,`to`,`zv` WHERE oc.name_user='******'role']."' AND oc.name_user=zv.name_user AND oc.name_user=to.name_user AND oc.num=".$discipline[$i][1]." AND oc.kod=zv.kod AND to.idstyd=zv.idstyd AND to.num=oc.num AND to.value='true';");
if ($zag[0][0]==0){$zag2[0][0]=1;}else{$zag2[0][0]=$zag[0][0];}
$o2=$local->select("SELECT count(oc.oc) FROM `oc`,`to`,`zv` WHERE oc.name_user='******'role']."' AND oc.name_user=zv.name_user AND oc.name_user=to.name_user AND oc.num=".$discipline[$i][1]." AND oc.kod=zv.kod AND to.idstyd=zv.idstyd AND to.num=oc.num AND ((to.value='true' AND oc='0(n)')or(to.value='true' AND oc='0'))");$o2=$o2[0][0]."(".(number_format($o2[0][0]/$zag2[0][0]*100,2))."%)";
$o3=$local->select("SELECT count(oc.oc) FROM `oc`,`to`,`zv` WHERE oc.name_user='******'role']."' AND oc.name_user=zv.name_user AND oc.name_user=to.name_user AND oc.num=".$discipline[$i][1]." AND oc.kod=zv.kod AND to.idstyd=zv.idstyd AND to.num=oc.num AND to.value='true' AND oc>=4 AND oc<=6;");$o3=$o3[0][0]."(".(number_format($o3[0][0]/$zag2[0][0]*100,2))."%)";
$o4=$local->select("SELECT count(oc.oc) FROM `oc`,`to`,`zv` WHERE oc.name_user='******'role']."' AND oc.name_user=zv.name_user AND oc.name_user=to.name_user AND oc.num=".$discipline[$i][1]." AND oc.kod=zv.kod AND to.idstyd=zv.idstyd AND to.num=oc.num AND to.value='true' AND oc>=7 AND oc<=9;");$o4=$o4[0][0]."(".(number_format($o4[0][0]/$zag2[0][0]*100,2))."%)";
$o5=$local->select("SELECT count(oc.oc) FROM `oc`,`to`,`zv` WHERE oc.name_user='******'role']."' AND oc.name_user=zv.name_user AND oc.name_user=to.name_user AND oc.num=".$discipline[$i][1]." AND oc.kod=zv.kod AND to.idstyd=zv.idstyd AND to.num=oc.num AND to.value='true' AND oc>=10 AND oc<=12;");$o5=$o5[0][0]."(".(number_format($o5[0][0]/$zag2[0][0]*100,2))."%)";
$ser_bal = $local->select("SELECT avg(oc.oc) FROM `oc`,`to`,`zv` WHERE oc.name_user='******'role']."' AND oc.name_user=zv.name_user AND oc.name_user=to.name_user AND oc.num=".$discipline[$i][1]." AND oc.kod=zv.kod AND to.idstyd=zv.idstyd AND to.num=oc.num AND to.value='true';");
$styd = $local->select("SELECT zv.idstyd FROM `oc`,`to`,`zv` WHERE oc.name_user='******'role']."' AND oc.name_user=zv.name_user AND oc.name_user=to.name_user AND oc.num=".$discipline[$i][1]." AND oc.kod=zv.kod AND to.idstyd=zv.idstyd AND to.num=oc.num AND to.value='true';");
$pot=0;
for ($x=0;$x<count($styd);$x++)
{
$plans = $contingent->select("select bvm.modulenum,gd.discipline,bvm.moduletheme,S2T.TESTLISTID,S2T.CREDITS_CUR from STUDENT2TESTLIST S2T
inner join B_TESTLIST BT on (BT.TESTLISTID = S2T.TESTLISTID) inner join B_VARIANT_ITEMS BVI_M on (BVI_M.VARIANTID = BT.VARIANTID) inner join b_variant_module bvm
on (BVI_M.VARIANTID = bvm.VARIANTID) inner join B_VARIANT_ITEMS BVI_V on (BVI_V.VARIANTID = BVI_M.PARENTVARIANTID) inner join guide_discipline gd
on (BVI_V.disciplineid = gd.disciplineid) where BT.TESTLISTID=".$discipline[$i][2]." AND S2T.STUDENTID=".$styd[$x][0]."");
$pot=$pot+potochna($plans[0][4]);
}
if (count($styd)==0){$pot=0;$styd[0][0]=1;}
$stream.="<tr><td>".($i+1)."</td><td>".course($student[0][4])."</td><td>".$plan[0][1]." - ".$plan[0][0].".".$plan[0][2]."</td><td>".$zag[0][0]."</td><td>".$o2."</td><td>".$o3."</td><td>".$o4."</td><td>".$o5."</td><td>".$ser_bal[0][0]."</td><td>".$pot/count($styd)."<td></td><td></td><td></td></tr>";
}
$fp2=fopen("arhiv/faculty/".rus2translit($student[0][3])."/".rus2translit($student[0][2])."/Semester ".rus2translit($student[0][4])."/Date ".$date."/Statistick/Zagalna.doc","w+");
fwrite($fp2, $stream);
fclose($fp2);
?>
if (count($kol) == 3) {
text_help(4);
videos(2);
course(2);
faq(4);
} else {
if (count($kol) == 2) {
text_help(8);
videos(2);
course(2);
faq(8);
} else {
if (count($kol) == 1) {
text_help(8);
videos(2);
course(2);
faq(4);
}
}
}
}
?>
</div>
</div>
<!--overview Content-repalce End-->
</div>
</div>
</div>
</div>
</div>
</div>
