Changeset 18060
- Timestamp:
- 2009/06/09 12:07:05 (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/comu-ver2/data/class/pages/admin/contents/LC_Page_Admin_Contents_Inquiry.php
r17949 r18060 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 … … 170 168 $head = SC_Utils_Ex::sfGetCSVList($this->arrCVSTITLE); 171 169 $sql =<<<__EOS__ 172 SELECT173 dtb_question_result.result_id174 ,dtb_question_result.question_id175 ,dtb_question_result.create_date176 ,dtb_question.question_name177 ,dtb_question_result.name01178 ,dtb_question_result.name02179 ,dtb_question_result.kana01180 ,dtb_question_result.kana02181 ,dtb_question_result.zip01182 ,dtb_question_result.zip02183 ,dtb_question_result.pref184 ,dtb_question_result.addr01185 ,dtb_question_result.addr02186 ,dtb_question_result.tel01187 ,dtb_question_result.tel02188 ,dtb_question_result.tel03189 ,dtb_question_result.mail01190 ,dtb_question_result.question01191 ,dtb_question_result.question02192 ,dtb_question_result.question03193 ,dtb_question_result.question04194 ,dtb_question_result.question05195 ,dtb_question_result.question06196 FROM dtb_question_result197 LEFT JOIN dtb_question198 ON dtb_question_result.question_id = dtb_question.question_id199 WHERE 0=0200 AND dtb_question_result.del_flg = 0201 AND dtb_question_result.question_id = ?202 ORDER BY dtb_question_result.result_id ASC170 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 203 201 __EOS__; 204 $list_data = $conn->getAll($sql, array($_GET['question_id'])); 202 203 $list_data = $objQuery->getAll($sql, array($_GET['question_id'])); 205 204 $data = ""; 206 205 for($i = 0; $i < count($list_data); $i++) { … … 219 218 220 219 $sql = "SELECT question FROM dtb_question WHERE question_id = ?"; 221 $result = $ conn->getOne($sql, array($_GET['question_id']));220 $result = $objQuery->getOne($sql, array($_GET['question_id'])); 222 221 223 222 if ( $result ){
Note: See TracChangeset
for help on using the changeset viewer.