Changeset 17829 for branches/version-2/data
- Timestamp:
- 2009/02/25 21:24:08 (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2/data/class/pages/admin/contents/LC_Page_Admin_Contents_Inquiry.php
r17204 r17829 57 57 '質問ID', 58 58 '回答日時', 59 ' 回答名',59 'アンケートタイトル', 60 60 '顧客名1', 61 61 '顧客名2', … … 86 86 */ 87 87 function process() { 88 $ conn = new SC_DBConn();88 $objQuery = new SC_Query(); 89 89 $objView = new SC_AdminView(); 90 90 $objSess = new SC_Session(); … … 98 98 ); 99 99 100 $sql = "SELECT *, cast(create_date as date) as disp_date FROM dtb_question WHERE del_flg = 0 ORDER BY question_id"; 101 $result = $conn->getAll($sql); 100 $result = $objQuery->select('*, cast(create_date as date) as disp_date', 'dtb_question', 'del_flg = 0 ORDER BY question_id'); 102 101 $this->list_data = $result; 103 102 … … 119 118 // 新規登録 120 119 if ( ! is_numeric($_POST['question_id']) ){ 121 $objQuery = new SC_Query();122 120 123 121 //登録 … … 127 125 } 128 126 129 $sql_val = array( $value, $_POST['title'] ,$question_id);130 $ conn->query("INSERT INTO dtb_question ( question, question_name, question_id, create_date) VALUES (?, ?, ?, now())", $sql_val);127 $sql_val = array( 'question' => $value, 'question_name' => $_POST['title'] ,'question_id' => $question_id ,'create_date' => 'now'); 128 $objQuery->insert('dtb_question', $sql_val); 131 129 $this->MESSAGE = "登録が完了しました"; 132 130 … … 142 140 //編集 143 141 $value = serialize($_POST); 144 $sql_val = array( $value, $_POST['title'] ,$_POST['question_id'] );145 $ conn->query("UPDATE dtb_question SET question = ?, question_name = ? WHERE question_id = ?", $sql_val);142 $sql_val = array( 'question'=>$value, 'question_name'=>$_POST['title'] ); 143 $objQuery->update('dtb_question', $sql_val, 'question_id = ?', array($_POST['question_id']) ); 146 144 $this->MESSAGE = "編集が完了しました"; 147 145 $this->QUESTION_ID = $_POST['question_id']; … … 159 157 } elseif ( ( $_GET['mode'] == 'delete' ) && ( SC_Utils_Ex::sfCheckNumLength($_GET['question_id']) ) ){ 160 158 161 $sql = "UPDATE dtb_question SET del_flg = 1 WHERE question_id = ?";162 $ conn->query( $sql, array( $_GET['question_id'] ) );159 $sqlval = array('del_flg' => 1); 160 $objQuery->update('dtb_question', $sqlval, 'question_id = ?', array( $_GET['question_id'] ) ); 163 161 $this->reload(null, true); 164 162 … … 169 167 $objCSV = new SC_Helper_CSV_Ex(); 170 168 $head = SC_Utils_Ex::sfGetCSVList($this->arrCVSTITLE); 171 $list_data = $conn->getAll("SELECT result_id,question_id,question_date,question_name,name01,name02,kana01,kana02,zip01,zip02,pref,addr01,addr02,tel01,tel02,tel03,mail01,question01,question02,question03,question04,question05,question06 FROM dtb_question_result WHERE del_flg = 0 AND question_id = ? ORDER BY result_id ASC",array($_GET['question_id'])); 169 $sql =<<<__EOS__ 170 SELECT 171 dtb_question_result.result_id 172 ,dtb_question_result.question_id 173 ,dtb_question_result.create_date 174 ,dtb_question.question_name 175 ,dtb_question_result.name01 176 ,dtb_question_result.name02 177 ,dtb_question_result.kana01 178 ,dtb_question_result.kana02 179 ,dtb_question_result.zip01 180 ,dtb_question_result.zip02 181 ,dtb_question_result.pref 182 ,dtb_question_result.addr01 183 ,dtb_question_result.addr02 184 ,dtb_question_result.tel01 185 ,dtb_question_result.tel02 186 ,dtb_question_result.tel03 187 ,dtb_question_result.mail01 188 ,dtb_question_result.question01 189 ,dtb_question_result.question02 190 ,dtb_question_result.question03 191 ,dtb_question_result.question04 192 ,dtb_question_result.question05 193 ,dtb_question_result.question06 194 FROM dtb_question_result 195 LEFT JOIN dtb_question 196 ON dtb_question_result.question_id = dtb_question.question_id 197 WHERE 0=0 198 AND dtb_question_result.del_flg = 0 199 AND dtb_question_result.question_id = ? 200 ORDER BY dtb_question_result.result_id ASC 201 __EOS__; 202 203 $list_data = $objQuery->getAll($sql, array($_GET['question_id'])); 172 204 $data = ""; 173 205 for($i = 0; $i < count($list_data); $i++) { … … 186 218 187 219 $sql = "SELECT question FROM dtb_question WHERE question_id = ?"; 188 $result = $ conn->getOne($sql, array($_GET['question_id']));220 $result = $objQuery->getOne($sql, array($_GET['question_id'])); 189 221 190 222 if ( $result ){
Note: See TracChangeset
for help on using the changeset viewer.