Changeset 21481 for branches/version-2_12-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Kiyaku.php
- Timestamp:
- 2012/02/11 05:48:00 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Kiyaku.php
r21480 r21481 108 108 // 削除 109 109 case 'delete': 110 $objDb->sfDeleteRankRecord( "dtb_kiyaku", "kiyaku_id", $post['kiyaku_id'], "", true);110 $objDb->sfDeleteRankRecord('dtb_kiyaku', 'kiyaku_id', $post['kiyaku_id'], "", true); 111 111 // 再表示 112 112 $this->objDisplay->reload(); … … 124 124 break; 125 125 case 'down': 126 $objDb->sfRankDown( "dtb_kiyaku", "kiyaku_id", $post['kiyaku_id']);126 $objDb->sfRankDown('dtb_kiyaku', 'kiyaku_id', $post['kiyaku_id']); 127 127 // 再表示 128 128 $this->objDisplay->reload(); 129 129 break; 130 130 case 'up': 131 $objDb->sfRankUp( "dtb_kiyaku", "kiyaku_id", $post['kiyaku_id']);131 $objDb->sfRankUp('dtb_kiyaku', 'kiyaku_id', $post['kiyaku_id']); 132 132 // 再表示 133 133 $this->objDisplay->reload(); … … 158 158 $sqlval['kiyaku_text'] = $arrData['kiyaku_text']; 159 159 $sqlval['creator_id'] = $member_id; 160 $sqlval['rank'] = $objQuery->max('rank', "dtb_kiyaku") + 1;160 $sqlval['rank'] = $objQuery->max('rank', 'dtb_kiyaku') + 1; 161 161 $sqlval['update_date'] = 'CURRENT_TIMESTAMP'; 162 162 $sqlval['create_date'] = 'CURRENT_TIMESTAMP'; 163 163 // INSERTの実行 164 164 $sqlval['kiyaku_id'] = $objQuery->nextVal('dtb_kiyaku_kiyaku_id'); 165 $ret = $objQuery->insert( "dtb_kiyaku", $sqlval);165 $ret = $objQuery->insert('dtb_kiyaku', $sqlval); 166 166 return $ret; 167 167 } … … 171 171 172 172 $where = "kiyaku_id = ?"; 173 return $objQuery->select("kiyaku_text, kiyaku_title", "dtb_kiyaku", $where, array($kiyaku_id));173 return $objQuery->select("kiyaku_text, kiyaku_title", 'dtb_kiyaku', $where, array($kiyaku_id)); 174 174 } 175 175 … … 179 179 $where = "del_flg <> 1"; 180 180 $objQuery->setOrder("rank DESC"); 181 return $objQuery->select("kiyaku_title, kiyaku_text, kiyaku_id", "dtb_kiyaku", $where);181 return $objQuery->select("kiyaku_title, kiyaku_text, kiyaku_id", 'dtb_kiyaku', $where); 182 182 } 183 183 … … 191 191 $where = "kiyaku_id = ?"; 192 192 // UPDATEの実行 193 $ret = $objQuery->update( "dtb_kiyaku", $sqlval, $where, array($kiyaku_id));193 $ret = $objQuery->update('dtb_kiyaku', $sqlval, $where, array($kiyaku_id)); 194 194 return $ret; 195 195 } … … 222 222 $post = $objFormParam->getHashArray(); 223 223 $objQuery =& SC_Query_Ex::getSingletonInstance(); 224 $arrRet = $objQuery->select("kiyaku_id, kiyaku_title", "dtb_kiyaku", "del_flg = 0 AND kiyaku_title = ?", array($post['kiyaku_title']));224 $arrRet = $objQuery->select("kiyaku_id, kiyaku_title", 'dtb_kiyaku', "del_flg = 0 AND kiyaku_title = ?", array($post['kiyaku_title'])); 225 225 // 編集中のレコード以外に同じ名称が存在する場合 226 226 if ($arrRet[0]['kiyaku_id'] != $post['kiyaku_id'] && $arrRet[0]['kiyaku_title'] == $post['kiyaku_title']) {
Note: See TracChangeset
for help on using the changeset viewer.