Разработка информационной системы управления учебным процессом

};

}get_name_group_full($id){

$sql="SELECT `name`,`year`,`group_number` FROM `group` where `id`=$id";

$group=getinfo($sql);

$group=$group[0].$group[1].$group[2];$group;

}

all_info_lectures(){

$ids=get_all_id_lectures();($ids as $id){"<tr>";

$sql="SELECT `id`, `Surname`,`Name`,`Patronymic`,`Stepen_id`,`Departmen_id`,`items_id` FROM `lectures` where `id`=$id";

 

$mysqli = new mysqli(HOST_DB, DB_USER, DB_PASS, DB_NAME);(mysqli_connect_errno()) {("Connect failed: %s\n", mysqli_connect_error());

}

$mysqli->query('SET NAMES utf8');

$result = $mysqli->query($sql);( $result->fetch_assoc() as $key => $value){($key=="Stepen_id")$value=get_stepen_name ($value);($key=="Departmen_id")$value=get_kaf_name ($value);($key=="items_id")$value=get_items_name ($value);"<td><div align=\"center\">$value</div></td>"; }

 

$result->close();

$mysqli->close();

"

<td><div align=\"center\"><a href=\"lectures.php?act=del&id=$id\" title=\"Удалить\"><img src=\"del.png\"\></a></div></td>

<td><div align=\"center\"><a href=\"edit_lectures.php?id=$id\" title=\"Редактировать\"><img src=\"edit.png\"></a></div></td>

</tr>";

};

}

get_all_info_spec(){

 

$count= getinfo("SELECT count(`id`) from `spec");

$count=$count[0];

$sql="SELECT `id`, `Name` from `spec`";

$mysqli = new mysqli(HOST_DB, DB_USER, DB_PASS, DB_NAME);

(mysqli_connect_errno()) {("Connect failed: %s\n", mysqli_connect_error());

}

$mysqli->query('SET NAMES utf8');

$result = $mysqli->query($sql);($k=1; $k<=$count; $k++){ foreach( $result->fetch_assoc() as $key => $value){($key=="id")$id=$value;($key=="Name")$Name=$value;

ПРОДОЛЖЕНИЕ ПРИЛОЖЕНИЯ 2

if(($id)&&($Name)) {

echo "<tr>

<td>".$id ."</td><td>$Name</td><td><a href=\"spec.php?act=del&id=$id\" title=\"Удалить\"><img src=\"del.png\"></a></td>

<td><a href=\"edit_spec.php?id=$id\" title=\"Редактировать\"><img src=\"edit.png\"></a></td></tr>

" ;

$id=""; $Name="";

};

};

};

$result->close();

$mysqli->close();

}

get_all_info_predm(){

 

$count= getinfo("SELECT count(`id`) from `predm");

$count=$count[0];

$sql="SELECT `id`, `Name` from `predm`";

$mysqli = new mysqli(HOST_DB, DB_USER, DB_PASS, DB_NAME);

(mysqli_connect_errno()) {("Connect failed: %s\n", mysqli_connect_error());

}

$mysqli->query('SET NAMES utf8');

$result = $mysqli->query($sql);($k=1; $k<=$count; $k++){( $result->fetch_assoc() as $key => $value){($key=="id")$id=$value;($key=="Name")$Name=$value;(($id)&&($Name)) {"<tr>

<td>".$id ."</td><td>$Name</td><td><a href=\"predm.php?act=del&id=$id\" title=\"Удалить\"><img src=\"del.png\"></a></td>

<td><a href=\"edit_predm.php?id=$id\" title=\"Редактировать\"><img src=\"edit.png\"></a></td></tr> " ;

$id=""; $Name="";

};

};

};

 

$result->close();

$mysqli->close();

}

id_info_lectures($kaf){

$ids=getinfo("SELECT `id` FROM `lectures` where `Departmen_id`=$kaf");($ids as $id){ echo "<tr>";($kaf) $sql="SELECT `id`, `Surname`,`Name`,`Patronymic`,`Stepen_id`,`Departmen_id`,`items_id` FROM `lectures` where `Departmen_id`=$kaf and id=$id";

$mysqli = new mysqli(HOST_DB, DB_USER, DB_PASS, DB_NAME);(mysqli_connect_errno()) {("Connect failed: %s\n", mysqli_connect_error());

}

$mysqli->query('SET NAMES utf8');

$result = $mysqli->query($sql);( $result->fetch_assoc() as $key => $value){($key=="Stepen_id")$value=get_stepen_name ($value);($key=="Departmen_id")$value=get_kaf_name ($value);($key=="items_id")$value=get_items_name ($value);"<td><div align=\"center\">$value</div></td>";

$value="";

}

 

$result->close();

$mysqli->close();

(!$kaf)echo "

<td><div align=\"center\"><a href=\"lectures.php?act=del&id=$id\" title=\"Удалить\"><img src=\"del.png\"\></a></div></td>

<td><div align=\"center\"><a href=\"lectures.php?act=edit&id=$id\" title=\"Редактировать\"><img src=\"edit.png\"></a></div></td>

</tr>";

};

}

get_all_kaf_li(){

$ids=get_all_kaf_id();($ids as $id){"<li><a href=\"personal-kaf-prep.php?kaf=$id\">". get_kaf_name($id) ."</li>" ;

}

}get_all_predm_li(){

$ids=get_all_predm_id();($ids as $id){"<li><a href=\"personal-kaf-prep.php?kaf=$id\">". get_kaf_name($id) ."</li>" ;

}

}

get_all_predm_li_ved(){

$ids=get_all_predm_id();($ids as $id){"<li><a href=\"ved_predm.php?predm=$id\">". get_predm_name($id) ."</li>" ;

}

}

get_all_group_li_a(){

$ids=get_group_id();($ids as $id){"\n<li><a href=\"vedomost_group.php?group=$id\">". get_group_name($id) .get_group_number($id).get_group_year($id)."</li>" ;

}

}get_all_kaf_dep(){

$count=getinfo("SELECT count(`id`) from `Departments`");

$count=$count[0];

$sql="SELECT `id`, `Name`, `ZavDepartment` from `Departments`";

$mysqli = new mysqli(HOST_DB, DB_USER, DB_PASS, DB_NAME);

(mysqli_connect_errno()) {("Connect failed: %s\n", mysqli_connect_error());

}

$mysqli->query('SET NAMES utf8');

$result = $mysqli->query($sql);

($k=1; $k<=$count; $k++){( $result->fetch_assoc() as $key => $value){($key=="id")$id=$value;($key=="Name")$Name=$value;($key=="ZavDepartment")$zav=$value;(($id)&&($Name)&&($zav)) {"<tr>

<td>".$id ."</td><td>$Name</td><td>$zav</td><td><a href=\"department.php?act=del&id=$id\" title=\"Удалить\"><img src=\"del.png\"></a></td>

<td><a href=\"edit_department.php?id=$id\" title=\"Редактировать\"><img src=\"edit.png\"></a></td></tr>

" ; $id=""; $Name=""; $zav="";

};

};

};

$result->close();

$mysqli->close();$data;

}

del_student($id){

$sql="DELETE FROM `students` where `id`=$id";($sql);1;

}

del_group($id){

$sql="DELETE FROM `group` where `id`=$id";($sql);1;

}

del_lectures($id){

$sql="DELETE FROM `lectures` where `id`=$id";($sql);1;

}

del_kaf($id){

$sql="DELETE FROM `Departments` where `id`=$id";($sql);1;

}del_spec($id){

$sql="DELETE FROM `spec` where `id`=$id";($sql);1;

}del_predm($id){

$sql="DELETE FROM `predm` where `id`=$id";($sql);1;

}

get_all_kaf_id(){

$sql='SELECT `id` FROM `Departments`';(getinfo($sql));

}

get_all_predm_id(){

$sql='SELECT `id` FROM `predm`';(getinfo($sql));

}get_all_spec_id(){

$sql='SELECT `id` FROM `spec`';(getinfo($sql));

 

}get_all_group_id(){

$sql='SELECT `id` FROM `group`';(getinfo($sql));

}

get_all_stud_id(){

$sql='SELECT `id` FROM `students`';(getinfo($sql));

}

get_all_stepen_id(){

$sql='SELECT `id` FROM `stepeni`';(getinfo($sql));

}

get_predm_ved($predm){"<tr>";

$sql="SELECT `id`, `id_stud`,`id_pred`,`ocenka` FROM `vedomosti` where `id_pred`=$predm";

$mysqli = new mysqli(HOST_DB, DB_USER, DB_PASS, DB_NAME);(mysqli_connect_errno()) {("Connect failed: %s\n", mysqli_connect_error());

}

$mysqli->query('SET NAMES utf8');

$result = $mysqli->query($sql);( $result->fetch_assoc() as $key => $value){($key=="id_stud")$value=get_fio_student ($value);($key=="id_pred")$value= get_predm_name ($value);"<td><div align=\"center\">$value</div></td>";

}

$result->close(); $mysqli->close();"</tr>";

}get_fio_student($id){

$sql="SELECT `Surname` FROM `students`";

$x=getinfo($sql);

$fio.=$x[0];

$sql="SELECT `Name` FROM `students`";

$x=getinfo($sql);

$fio.=' '.$x[0];

$sql="SELECT `Patronymic` FROM `students`";

$x=getinfo($sql);

$fio.=" ".$x[0];$fio;

}

get_all_kaf_sel(){

$ids=get_all_kaf_id();"<option disabled>Выберите кафедру</option>";($ids as $id){

$sql="SELECT `Name` FROM `Departments` where `id`=$id";

$mysqli = new mysqli(HOST_DB, DB_USER, DB_PASS, DB_NAME);(mysqli_connect_errno()) {("Connect failed: %s\n", mysqli_connect_error());

}

$mysqli->query('SET NAMES utf8');

$result = $mysqli->query($sql);( $row = $result->fetch_assoc() ){($row as $fieldValue){"<OPTION value=\"$id\">$fieldValue</OPTION>\n";

}

}

$result->close();

$mysqli->close();

};1;

}

get_all_stud_sel(){

$ids=get_all_stud_id();"<option disabled>Выберите студента</option>";($ids as $id){

$sql="SELECT `Name` FROM `students` where `id`=$id";

$mysqli = new mysqli(HOST_DB, DB_USER, DB_PASS, DB_NAME);(mysqli_connect_errno()) {("Connect failed: %s\n", mysqli_connect_error());

}

$mysqli->query('SET NAMES utf8');

$result = $mysqli->query($sql);( $row = $result->fetch_assoc() ){($row as $fieldValue){"<OPTION value=\"$id\">$fieldValue</OPTION>\n";

}

}

$result->close();

$mysqli->close();

}; return 1;

}

 

get_all_spec_sel_opt($id){

$ids=get_all_spec_id();($ids as $id){

$sql="SELECT `Name` FROM `spec` where `id`=$id";

$mysqli = new mysqli(HOST_DB, DB_USER, DB_PASS, DB_NAME);(mysqli_connect_errno()) {("Connect failed: %s\n", mysqli_connect_error());

}

$mysqli->query('SET NAMES utf8');

$result = $mysqli->query($sql);

( $row = $result->fetch_assoc() ){($row as $fieldValue){($id==$fieldValue)$x="disabled";"<OPTION value=\"$id\" $x>$fieldValue</OPTION>\n";

}

}

$result->close();

$mysqli->close();

};1;

}get_all_kaf_sel_opt($id){

$ids=get_all_kaf_id();($ids as $id){

$sql="SELECT `Name` FROM `Departments` where `id`=$id";

$mysqli = new mysqli(HOST_DB, DB_USER, DB_PASS, DB_NAME);(mysqli_connect_errno()) {("Connect failed: %s\n", mysqli_connect_error());

}

$mysqli->query('SET NAMES utf8');

$result = $mysqli->query($sql);( $row = $result->fetch_assoc() ){($row as $fieldValue){($id==$fieldValue)$x="disabled";"<OPTION value=\"$id\" $x>$fieldValue</OPTION>\n";

}

}

$result->close();

$mysqli->close();

};1;

}

get_all_predm_sel_opt($id){

$ids=get_all_predm_id();($ids as $id){

$sql="SELECT `Name` FROM `predm` where `id`=$id";

$mysqli = new mysqli(HOST_DB, DB_USER, DB_PASS, DB_NAME);(mysqli_connect_errno()) {("Connect failed: %s\n", mysqli_connect_error());

} $mysqli->query('SET NAMES utf8');

$result = $mysqli->query($sql);( $row = $result->fetch_assoc() ){($row as $fieldValue){($id==$fieldValue)$x="disabled";"<OPTION value=\"$id\" $x>$fieldValue</OPTION>\n";

}

}

$result->close();

$mysqli->close();

};1;

}

get_name_group_ved($ved){

$sql="SELECT `id_predm` FROM `vedomosti_list` where `id`=$ved";

$predm=getinfo($sql);

$predm=$predm[0];

$sql="SELECT `Name` FROM `predm` WHERE `id`=$predm";

$name_predm=getinfo($sql);$name_predm[0];

}

get_all_lectors_opt($ved){

$sql="SELECT `id_predm` FROM `vedomosti_list` where `id`=$ved";

$predm=getinfo($sql);

$predm=$predm[0];

$sql="SELECT `id` FROM `lectures` WHERE `items_id` LIKE '%$predm%'"; $prep=getinfo($sql);($x=0; $x<count($prep); $x++){

$sql="SELECT `Surname`, `Name`, `Patronymic` FROM `lectures` WHERE `id`=".$prep[$x];

$name=getinfo($sql);

$name=$name[0]." ".$name[1]." ".$name[2];"<OPTION value=\"".$prep[$x]."\">$name</OPTION>\n";

 

}

1;

}

get_all_spec_sel(){

$ids=get_all_spec_id();"<option disabled>Выберите специальность</option>";($ids as $id){

$sql="SELECT `Name` FROM `spec` where `id`=$id";

$mysqli = new mysqli(HOST_DB, DB_USER, DB_PASS, DB_NAME);(mysqli_connect_errno()) {("Connect failed: %s\n", mysqli_connect_error());

}

$mysqli->query('SET NAMES utf8');

$result = $mysqli->query($sql);( $row = $result->fetch_assoc() ){($row as $fieldValue){"<OPTION value=\"$id\">$fieldValue</OPTION>\n";

} }

$result->close();

$mysqli->close();

};1;

}

get_all_group_sel(){

$ids=get_all_group_id();

$count=count($ids);

($ids as $id){

$sql="SELECT `name`, `year`, `group_number` from `group` WHERE `id`=$id";

$mysqli = new mysqli(HOST_DB, DB_USER, DB_PASS, DB_NAME);

(mysqli_connect_errno()) {("Connect failed: %s\n", mysqli_connect_error());

}

$mysqli->query('SET NAMES utf8');

$result = $mysqli->query($sql);

($k=1; $k<=$count; $k++){( $result->fetch_assoc() as $key => $value){($key=="id")$id=$value;($key=="name")$name=$value;($key=="year")$year=$value;($key=="group_number")$group_number=$value;(($id)&&($name)&&($year)&&($group_number)) {"<OPTION value=\"$id\">$name$year$group_number</OPTION>\n" ;

$id=""; $name="";$year=""; $group_number="";

};

};

};

 

$result->close();

$mysqli->close();

};1;

};

get_all_predm_sel(){

$ids=get_all_predm_id();"<option disabled>Выберите факультет</option>";($ids as $id){

$sql="SELECT `Name` FROM `predm` where `id`=$id";

$mysqli = new mysqli(HOST_DB, DB_USER, DB_PASS, DB_NAME);(mysqli_connect_errno()) {("Connect failed: %s\n", mysqli_connect_error());