/** * dtb_questionnaire_results * * @param mixed $questionnaire_id * @access public * @return void */ function lfDoCSV($questionnaire_id) { $arrHeader = array(1 => '結果ID', 2 => '顧客ID', 3 => '回答日'); $objQuery =& SC_Query_Ex::getSingletonInstance(); $arrResult = $objQuery->select("result_id, customer_id, create_date", "dtb_questionnaire_result", "questionnaire_id = ?", array($questionnaire_id)); foreach ($arrResult as $result) { $arrAns = $objQuery->select("answer_id, answer", "dtb_questionnaire_result_answer", "result_id = ?", array($result['result_id'])); $count = count($arrAns); for ($cnt = 0; $cnt < $count; $cnt++) { $key = 'answer' . $arrAns[$cnt]['answer_id']; $val = $arrAns[$cnt]['answer']; $arrRet[$key] = $val; } $arrCsv[] = array_merge($result, $arrRet); } for ($cnt = 1; $cnt <= $count; $cnt++) { $arrHeader[] = '回答' . $cnt; } // header array_unshift($arrCsv, $arrHeader); // csv出力 require_once CLASS_EX_REALDIR . 'helper_extends/SC_Helper_CSV_Ex.php'; $objCSV = new SC_Helper_CSV_Ex(); $objCSV->lfDownloadCsv($arrCsv); exit; }