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