Changeset 17655 for branches/version-2
- Timestamp:
- 2008/10/24 15:32:09 (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2/data/class/helper/SC_Helper_DB.php
r17507 r17655 1202 1202 1203 1203 $max = $objQuery->max($tableName, "rank", $where); 1204 1205 // 値の調整(逆順) 1204 // 値の調整(逆順) 1206 1205 if($pos > $max) { 1207 1206 $position = 1; … … 1211 1210 $position = $max - $pos + 1; 1212 1211 } 1213 1212 1214 1213 //入れ替え先の順位が入れ換え元の順位より大きい場合 1215 1214 if( $position > $rank ) $term = "rank - 1"; … … 1226 1225 $sql.= " AND $where"; 1227 1226 } 1228 1229 if( $position > $rank ) $objQuery->exec( $sql, array( $rank + 1, $position )); 1230 if( $position < $rank ) $objQuery->exec( $sql, array( $position, $rank - 1 )); 1231 1232 // 指定した順位へrankを書き換える。 1227 if( $position > $rank ) $objQuery->exec( $sql, array($rank, $position)); 1228 if( $position < $rank ) $objQuery->exec( $sql, array($position, $rank)); 1229 // 指定した順位へrankを書き換える。 1233 1230 $sql = "UPDATE $tableName SET rank = ? WHERE $keyIdColumn = ? "; 1234 1231 if($where != "") { 1235 1232 $sql.= " AND $where"; 1236 1233 } 1237 1238 $objQuery->exec( $sql, array( $position, $keyId ) ); 1234 $objQuery->exec( $sql, array( $position, $keyId ) ); 1239 1235 $objQuery->commit(); 1240 1236 }
Note: See TracChangeset
for help on using the changeset viewer.