PHP Student::getList方法代码示例

 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";
}