Changeset 21514 for branches/version-2_12-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Holiday.php
- Timestamp:
- 2012/02/15 19:56:17 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Holiday.php
r21481 r21514 101 101 if (count($this->arrErr) <= 0) { 102 102 // 新規作成 103 if ($post['holiday_id'] == "") {103 if ($post['holiday_id'] == '') { 104 104 $this->lfInsertClass($this->arrForm, $_SESSION['member_id']); 105 105 } … … 164 164 $objQuery =& SC_Query_Ex::getSingletonInstance(); 165 165 166 $where = "holiday_id = ?";167 return $objQuery->select( "title, month, day", 'dtb_holiday', $where, array($holiday_id));166 $where = 'holiday_id = ?'; 167 return $objQuery->select('title, month, day', 'dtb_holiday', $where, array($holiday_id)); 168 168 } 169 169 … … 171 171 $objQuery =& SC_Query_Ex::getSingletonInstance(); 172 172 173 $where = "del_flg <> 1";174 $objQuery->setOrder( "rank DESC");175 return $objQuery->select( "holiday_id, title, month, day", 'dtb_holiday', $where);173 $where = 'del_flg <> 1'; 174 $objQuery->setOrder('rank DESC'); 175 return $objQuery->select('holiday_id, title, month, day', 'dtb_holiday', $where); 176 176 } 177 177 … … 201 201 $sqlval['day'] = $arrData['day']; 202 202 $sqlval['update_date'] = 'CURRENT_TIMESTAMP'; 203 $where = "holiday_id = ?";203 $where = 'holiday_id = ?'; 204 204 // UPDATEの実行 205 205 $ret = $objQuery->update('dtb_holiday', $sqlval, $where, array($arrData['holiday_id'])); … … 238 238 if (!isset($arrErr['date'])) { 239 239 $objQuery =& SC_Query_Ex::getSingletonInstance(); 240 $where = "del_flg = 0 AND month = ? AND day = ?";240 $where = 'del_flg = 0 AND month = ? AND day = ?'; 241 241 $arrval = array($post['month'], $post['day']); 242 242 if (!empty($post['holiday_id'])) { 243 $where .= " AND holiday_id <> ?";243 $where .= ' AND holiday_id <> ?'; 244 244 $arrval[] = $post['holiday_id']; 245 245 } 246 $arrRet = $objQuery->select( "count(holiday_id) as count", 'dtb_holiday', $where, $arrval);246 $arrRet = $objQuery->select('count(holiday_id) as count', 'dtb_holiday', $where, $arrval); 247 247 248 248 // 編集中のレコード以外に同じ日付が存在する場合 249 249 if ($arrRet[0]['count'] > 0) { 250 $arrErr['date'] = "※ 既に同じ日付の登録が存在します。<br>";250 $arrErr['date'] = '※ 既に同じ日付の登録が存在します。<br>'; 251 251 } 252 252 }
Note: See TracChangeset
for help on using the changeset viewer.