PHP RsStudent::sql_status Examples

Example #1

File: StudentController.php Project: nguyenvanvu/slu

 public function actionExportAttendedStudent()
 {
     Yii::import('ext.ECSVExport');
     $model = new RsStudent();
     $sql_status = $model->sql_status();
     $sql = $sql_status['sql'];
     $list_student = $model->data_query($sql);
     $data_csv = array();
     foreach ($list_student as $values) {
         $faculty = Yii::app()->params['faculty_values'][$values["faculty"]];
         $status = Yii::app()->params['status'][$values["status"]];
         $item_csv = array("名大ID" => $values["student_code"], "名前" => $values["first_name"] . '　' . $values["last_name"], "フリガナ" => $values["first_kana"] . '　' . $values["last_kana"], "所属" => $faculty, "学籍・教員番号" => $values["professor_code"], "状況" => $status);
         array_push($data_csv, $item_csv);
     }
     $csv = new ECSVExport($data_csv);
     //$output = $csv->toCSV();
     //$output = mb_convert_encoding($csv->toCSV(),"SJIS", "UTF-8");
     $output = mb_convert_encoding($csv->toCSV(), "SJIS-win", "UTF-8");
     $filename = "認定者一覧.csv";
     Yii::app()->getRequest()->sendFile($filename, $output, "text/csv", false);
 }