PHP SC_Helper_CSV_Ex::lfDownloadCsv Examples

Example #1

File: LC_Page_Admin_Contents_Questionnaire.php Project: nobuhiko/questionnaire

 /**
  * 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;
 }