mysqli_query($conn, "insert into message_user(sender,message,reciever,date_send,message_file,unread,sentbox,inbox,notif_sound) values('{$sender}','{$message}','admin','{$dd}','','NO','1','1','1')") or die(mysqli_error($conn));
$_SESSION['sent'] = 'ok';
echo 1;
} else {
echo 0;
}
} elseif ($_POST['loader'] == 7) {
$section = mysqli_real_escape_string($conn, strtoupper($_POST['section']));
$grade = mysqli_real_escape_string($conn, $_POST['grade_id']);
// echo $_SESSION['school_id'];
////checker section
$checker = mysqli_query($conn, "select *from section where school_id='{$_SESSION['school_id']}' and section_desc='{$section}' and grade_id='{$grade}'") or die(mysqli_error($conn));
if (mysqli_num_rows($checker) == 0) {
mysqli_query($conn, "insert into section(school_id,section_desc,grade_id) values('{$_SESSION['school_id']}','{$section}','{$grade}')") or die(mysqli_error($conn));
echo 1;
} else {
echo 2;
}
} elseif ($_POST['loader'] == 8) {
$count = get_section('count', '');
if ($count == 0) {
echo 0;
} else {
echo 1;
}
} elseif ($_POST['loader'] == 9) {
$grade_id = mysqli_real_escape_string($conn, $_POST['grade_id']);
$data = get_section('', $grade_id);
echo $data;
}
mysqli_close($conn);
<?php
include "db.php";
//Ligacao a base de dados
$dbconn = connect_db();
$funcao = $_GET['funcao'] ? $_GET['funcao'] : $_POST['funcao'];
if ($funcao == 'get_destaques') {
get_destaque($dbconn);
} elseif ($funcao == 'get_formacao') {
get_formacao($dbconn);
} elseif ($funcao == 'get_tecnicas') {
get_tecnica($dbconn);
} elseif ($funcao == 'get_equipa') {
get_equipa($dbconn);
} elseif ($funcao == 'get_section') {
$pagina = $_GET['pagina'] ? $_GET['pagina'] : $_POST['pagina'];
get_section($dbconn, $page);
} elseif ($funcao == 'get_espaco') {
get_espaco($dbconn);
}
mysqli_close($dbconn);
if (trim($line) == '') {
return true;
} else {
return false;
}
}
function line_is_not_blank($line)
{
return !line_is_blank($line);
}
$equipment = array();
$materials = array();
foreach ($lines as $line) {
++$line_number;
if (line_is_section_header($line)) {
$section = get_section($line);
test_out('Identified section as ' . $section);
} else {
if (line_is_not_blank($line)) {
// is instruction
test_out('Checking line ' . $line_number);
if (preg_match('/([0-9]+\\.[0-9]*)(.*)/', $line, $matches)) {
list(, $instruction_number, $instruction) = $matches;
} else {
$instruction_number = '';
$instruction = $line;
}
if ($section == 'equipment') {
test_out('Adding ' . $instruction . ' to ' . $section);
$equipment[] = $instruction;
} else {
?>
<input class="class" type="checkbox" id="4_<?php
echo $classesArrayNum4[$k][4];
?>
" onchange="disableOtherSections(this.checked, 'class4', '<?php
echo get_section($classesArrayNum4[$k]);
?>
', '<?php
echo get_start_time($classesArrayNum4[$k]);
?>
', '<?php
echo get_end_time($classesArrayNum4[$k]);
?>
');">
<?php
print $class4[0] . " " . $class4[1] . ", section " . get_section($classesArrayNum4[$k]) . " goes from " . get_class_time($classesArrayNum4[$k]) . " on " . get_concat_meet_days($classesArrayNum4[$k]);
?>
</input><?php
?>
</br>
<?php
$i++;
}
$crnOld = $crnNew;
}
$firstLine = true;
?>
<?php
//prints the start time of the class
} else {
if (htmlspecialchars($_POST['className4']) == "Select Class") {
function set_section()
{
global $post, $section;
$section = get_section();
}
function production_test()
{
global $message;
global $page;
//passage en prod si etat 2 + popup + item en prod
$page['vue'] = "tests/test.vue.php";
$page['colonne'] = "tests/sidebar_test.vue.php";
$page['tests'] = liste_test();
$page['sphere'] = liste_sphere();
$page['facteur'] = liste_facteur();
$page['lieu'] = liste_lieux_auteur();
$page['projet'] = liste_projet();
if (isset($_GET['id'])) {
$id = $_GET['id'];
}
if (isset($_POST['id_test'])) {
$id = $_POST['id_test'];
}
$page['gabarit'] = "administration";
$page['test'] = get_test($id);
$page['test'] = $page['test'][0];
$page['test']['id_test'] = $id;
$page['etat'] = liste_etat();
if (has_reponse_test($id)) {
$page['message_info'] = $message['info_test_prod'];
}
if (isset($_POST['prod'])) {
$page['test'] = get_test($id);
$page['test'] = $page['test'][0];
if (is_current_version_test($id, $_POST['revision'])) {
if ($_POST['code_test'] != "" && $_POST['libelle_long_test'] != "" && $_POST['version_test'] != "") {
if ($page['test']['id_etat'] == 2) {
if (has_reponse_test($id)) {
/*duplication: la source passe en archive et le nouveau passe en production*/
$new_id = dupliquation_test_prod($_POST['id_test'], $_POST['code_test'], $_POST['libelle_long_test'], $_POST['version_test']);
if ($new_id != false) {
$page['test']['contenu_test'] = get_contenu_test($_POST['id_test']);
foreach ($page['test']['contenu_test'] as $key => $content) {
if ($content['type'] == 'item') {
set_item_to_archive($content['id_element']);
} else {
$section = get_section($content['id_element']);
foreach ($section[0] as $k => $v) {
$items = get_item_by_section($content['id_element']);
foreach ($items as $it) {
set_item_to_archive($it['id_item']);
}
}
}
}
set_test_to_archive($id);
header("Location: index.php?controleur=test&tache=visualiser_test&id=" . $new_id);
} else {
$page['message'] = $message['test_existe'] . "<br/> Merci de les modifier pour le passage en production";
}
} else {
$mprod = set_test_to_production($id, $_POST['code_test'], $_POST['libelle_long_test'], $_POST['version_test']);
if (mprod) {
$page['test']['contenu_test'] = get_contenu_test($_POST['id_test']);
foreach ($page['test']['contenu_test'] as $key => $content) {
if ($content['type'] == 'item') {
set_item_to_production($content['id_element']);
} else {
$section = get_section($content['id_element']);
foreach ($section[0] as $k => $v) {
$items = get_item_by_section($content['id_element']);
foreach ($items as $it) {
set_item_to_production($it['id_item']);
}
}
}
}
header("Location: index.php?controleur=test&tache=visualiser_test&id=" . $id);
} else {
$page['message'] = $message['test_existe'] . "<br/> Merci de les modifier pour le passage en production";
}
}
}
} else {
$page['message'] = $message['champs_obligatoire_2'];
}
} else {
header("Location: index.php?controleur=test&tache=visualiser_test&id=" . $id . "&message=outdated_test");
}
}
}
