public function index()
{
$session_id = 10;
$students = Student::getList('SELECT session_id, firstname, photo, gender FROM student WHERE session_id=' . $session_id . ' ORDER BY firstname');
$vars = array('title' => 'Presence V 1.0', 'description' => 'Les étudiants de votre groupe', 'url_trombino' => IMG_HTTP . 'trombino/', 'students' => $students);
$this->render('trombino', $vars);
}
public function insert()
{
if (!$this->title) {
return "Inserire il titolo dell'avviso";
}
if (!$this->text) {
return "Inserire il testo dell'avviso";
}
if (!is_array($this->id_dest)) {
return "Selezionare almeno un destinatario";
}
$tabella = "avvisi";
$campi = array("titolo", "testo", "id_studente", "invio_mail");
$valori = array($this->title, $this->text, implode(";", $this->id_dest), $this->mail_send);
$auth = $this->connector->insert($tabella, $campi, $valori);
if (mysql_errno() == 1062) {
return "Avviso già presente";
} else {
if (mysql_errno() > 0) {
return "Errore interno numero: " . mysql_errno();
}
}
if ($this->mail_send) {
$student = new Student();
$student->setConnector($this->connector);
$lista = array();
if (in_array(0, $this->id_dest)) {
$lista = $student->getList();
} else {
foreach ($this->id_dest as $id_dest) {
$tmp_stud = $student->getById($id_dest);
$lista[] = $tmp_stud;
}
}
$errore = "";
foreach ($lista as $student) {
$student->setConnector($this->connector);
$destinatario = $student->email;
$mittente_mail = "";
$oggetto = "";
$messaggio = "";
$intestazioni = "MIME-Version: 1.0\r\nContent-type: text/html; charset=iso-8859-1\r\nFrom: {$mittente_mail}";
//invio la mail
$risultato = mail($destinatario, $oggetto, $messaggio, $intestazioni);
//reindirizzamento
if (!$risultato) {
$errore .= "Problema nell'inoltro dell'email all'indirizzo {$destinatario}. L'avviso è stato comunque registrato sul portale<br>";
}
}
if ($errore != "") {
return $errore;
}
}
}
public function index()
{
if (!User::isLogged()) {
$this->response->redirect(ROOT_HTTP . 'login');
}
$day = $this->getParam(0, date('Y-m-d'));
$session_id = 10;
$students = Student::getList('SELECT * FROM student WHERE session_id=' . $session_id);
foreach ($students as $student) {
$student->setPresence($day);
}
$vars = array('title' => 'Feuille de présence WebForce 3', 'description' => '', 'url_trombino' => IMG_HTTP . 'trombino/', 'students' => $students);
$this->render('presence', $vars);
}
/**
* @author Christian Rizza
* www.crizza.com
* email: christian@crizza.com
*/
session_start();
define('BASE_PATH', "./");
include BASE_PATH . "config.php";
if (!isset($_SESSION['admin'])) {
header("Location: index.php");
}
$conn = new MysqlConnector();
$conn->connect();
$student = new Student();
$student->setConnector($conn);
$lista = $student->getList();
foreach ($lista as $entry) {
echo "Email: " . $entry->email . " ";
$entry->setConnector($conn);
if ($entry->generatePassword()) {
echo "[Errore di invio] <br>";
} else {
echo "[OK] <br>";
}
$counter++;
}
$conn->disconnect();
?>
public function data()
{
// Extractaire des data dans la base
$datas = Data::getList('SELECT * FROM data ORDER BY date ASC');
// Extractaire des students avec le tmp_id
global $students;
$students = Student::getList('SELECT id, tmp_id FROM student ORDER BY id ASC');
function getRealStudentId($tmp_id)
{
global $students;
//echo '<pre>'.print_r($students,true).'</pre>';
foreach ($students as $student) {
if ($student->tmp_id == $tmp_id) {
return $student->id;
}
}
return 0;
}
//echo getRealStudentId(11);
//exit;
// Enlever la première ligne et formater les dates
$data_bis = [];
$date_sort = [];
$presences = [];
foreach ($datas as $index => $data) {
if ($index == 0) {
continue;
}
$data_row = [];
$presences_row = [];
$idx = 0;
foreach ($data->getFields() as $key => $item) {
$presences_row['student_id'] = null;
if ($key == 'date') {
$arr = explode('/', $data->{$key});
$date = $arr[2] . '-' . sprintf('%02d', $arr[0]) . '-' . sprintf('%02d', $arr[1]);
$data_row[] = $date;
$date_sort[$index] = $date;
$presences_row['day'] = $date;
} else {
$value = $data->{$key};
$data_row[] = $value;
$presences_row['student_id'] = getRealStudentId($idx);
//echo $idx.' '.getRealStudentId($idx);
$presences_row['r1'] = strpos($value, 'R1') === false ? null : 1;
$presences_row['r2'] = strpos($value, 'R2') === false ? null : 1;
$presences_row['d1'] = strpos($value, 'D1') === false ? null : 1;
$presences_row['d2'] = strpos($value, 'D2') === false ? null : 1;
$presences_row['absent'] = $value == 0 ? 1 : 0;
}
//echo '<pre>'.print_r($presences_row,true).'</pre>';
//exit;
$presences[] = $presences_row;
$idx++;
}
//if ($index==1) echo '<br>';
$data_bis[] = $data_row;
}
// Trier sur les dates
array_multisort($date_sort, SORT_ASC, SORT_STRING, $data_bis);
// Afficher la view
$vars = ['datas' => $datas, 'presences' => $presences];
$this->render('admin/data', $vars);
}
function showStudent()
{
global $connector;
global $result;
$student = new Student();
$course = new Course();
$plan = new Plan();
$student->setConnector($connector);
$course->setConnector($connector);
$plan->setConnector($connector);
if (isset($_POST['operation'])) {
list($operation, $params) = explode("#", $_POST['operation']);
switch ($operation) {
case 'delete':
$error_msg = $student->delete($params);
break;
case 'edit':
$stud = $student->getById($params);
$result['edit'] = $stud;
$result['edit']->student = $stud;
$exam = new Exam();
$exam->setConnector($connector);
$result['edit']->exam = $exam->getList($result['edit']->student);
break;
case 'editChanges':
$student->storeFormValues($_POST);
$error_msg = $student->update();
break;
case 'saveChanges':
$student->storeFormValues($_POST);
$error_msg = $student->insert();
if ($error_msg) {
$result['edit'] = $student;
}
break;
case 'nextPage':
$student->storeFormValues($_POST);
$result['edit'] = $student;
break;
case 'createPassword':
$stud = $student->getById($params);
$stud->setConnector($connector);
$error_msg = $stud->generatePassword();
$result['edit'] = $stud;
break;
default:
$error_msg = "Operazione non valida";
}
if ($error_msg != "") {
$result["errorMessage"] = $error_msg;
} elseif ($operation != 'edit' && $operation != "nextPage") {
$result["statusMessage"] = "Operazione completata!";
}
}
if (isset($_POST['search'])) {
$result["students"] = $student->search($_POST['search']);
} else {
$result["students"] = $student->getList();
}
$result["plans"] = $plan->getList("id_piano");
$result["courses"] = $course->getList("nome");
$page = "student.php";
include_once BASE_PATH . "template.php";
}
