Changeset 42 for trunk/bin/module_maker/skel/admin.php
- Timestamp:
- Dec 18, 2005 12:16:03 AM (18 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/bin/module_maker/skel/admin.php
r41 r42 26 26 * CONFIG 27 27 *****************************************************************************/ 28 28 29 29 // Titles and navigation header. 30 30 $nav->addPage(_("%TITLE%"), $_SERVER['PHP_SELF']); 31 31 32 32 // The object to validate form input. 33 33 $fv = new FormValidator(); … … 215 215 // Get the information for the form. 216 216 $qid = DB::query(" 217 SELECT * 217 SELECT * 218 218 FROM %DB_TBL% 219 219 WHERE %PRIMARY_KEY% = '" . addslashes($id) . "' … … 227 227 // Lock this record. 228 228 $lock->set('%DB_TBL%', '%PRIMARY_KEY%', $id, $frm['<##>']); 229 229 230 230 // Set misc values for the form. 231 231 $frm = array_merge(array( … … 246 246 { 247 247 global $lock; 248 248 249 249 $lock->select('%DB_TBL%', '%PRIMARY_KEY%', $id); 250 250 if ($lock->isLocked() && !$lock->isMine()) { … … 254 254 // Break the cache because we are changing the list data. 255 255 SessionCache::breakCache($_SERVER['PHP_SELF']); 256 256 257 257 // Get the information for this object. 258 258 $qid = DB::query(" 259 SELECT <##> 259 SELECT <##> 260 260 FROM %DB_TBL% 261 261 WHERE %PRIMARY_KEY% = '" . addslashes($id) . "' … … 266 266 App::dieBoomerangURL(); 267 267 } 268 268 269 269 // Delete the record. 270 270 DB::query("DELETE FROM %DB_TBL% WHERE %PRIMARY_KEY% = '" . addslashes($id) . "'"); 271 271 272 272 App::raiseMsg(sprintf(_("The %ITEM_TITLE% <strong>%s</strong> has been deleted."), $name), MSG_SUCCESS, __FILE__, __LINE__); 273 273 … … 279 279 { 280 280 global $auth; 281 281 282 282 // Break the cache because we are changing the list data. 283 283 SessionCache::breakCache($_SERVER['PHP_SELF']); 284 284 285 285 %INSERT% 286 286 $last_insert_id = mysql_insert_id(DB::getDBH()); … … 289 289 $version = RecordVersion::getInstance($GLOBALS['auth']); 290 290 $version->create('%DB_TBL%', '%PRIMARY_KEY%', $last_insert_id, $frm['<##>']); 291 291 292 292 App::raiseMsg(sprintf(_("The %ITEM_TITLE% <strong>%s</strong> has been added."), $frm['<##>']), MSG_SUCCESS, __FILE__, __LINE__); 293 293 294 294 return $last_insert_id; 295 295 } … … 298 298 { 299 299 global $auth, $lock; 300 300 301 301 $lock->select('%DB_TBL%', '%PRIMARY_KEY%', $frm['%PRIMARY_KEY%']); 302 302 if ($lock->isLocked() && !$lock->isMine()) { … … 308 308 309 309 %UPDATE% 310 310 311 311 // Create version. 312 312 $version = RecordVersion::getInstance($GLOBALS['auth']); … … 323 323 global $page; 324 324 global $so; 325 325 326 326 $where_clause = ''; 327 327 328 328 // Build search query if available. 329 329 if (getFormData('search_query', false)) { … … 333 333 } 334 334 } 335 335 336 336 if (getFormData('filter_<##>', false)) { 337 337 // Limit by filter. 338 338 $where_clause .= (empty($where_clause) ? 'WHERE' : 'AND') . " <##> = '" . addslashes(getFormData('filter_<##>')) . "'"; 339 339 } 340 340 341 341 // Count the total number of records so we can do something about the page numbers. 342 342 $qid = DB::query(" 343 SELECT COUNT(*) 344 FROM %DB_TBL% 343 SELECT COUNT(*) 344 FROM %DB_TBL% 345 345 $where_clause 346 346 "); 347 347 list($num_results) = mysql_fetch_row($qid); 348 348 349 349 // Set page numbers now we know (needed for next step). 350 350 $page->setTotalItems($num_results); 351 351 $page->calculate(); 352 352 353 353 // Final SQL, with sort and page limiters. 354 354 $sql = " 355 SELECT 356 %DB_TBL%.*, 355 SELECT 356 %DB_TBL%.*, 357 357 a1.username AS added_admin_username, 358 358 a2.username AS modified_admin_username … … 364 364 " . $page->getLimitSQL() . " 365 365 "; 366 366 367 367 // A unique key for this query, with the total_items in case db records 368 368 // were added since the last cache. This identifies a unique set of … … 375 375 Prefs::setValue('cache_hash', $cache_hash, $_SERVER['PHP_SELF']); 376 376 } 377 377 378 378 if (SessionCache::isCached($_SERVER['PHP_SELF'])) { 379 379 // Get the cached results. … … 386 386 $list[] = $row; 387 387 } 388 388 389 389 if (isset($list) && !empty($list)) { 390 390 // Cache the results. … … 397 397 398 398 function updateRank($ranks) 399 { 399 { 400 400 if (!is_array($ranks)) { 401 401 App::logMsg('Saving rank failed, data posted is not an array: ' . $ranks, LOG_ERR, __FILE__, __LINE__); … … 405 405 // Break the cache because we are changing the list data. 406 406 SessionCache::breakCache($_SERVER['PHP_SELF']); 407 407 408 408 // Count the ranks with invalid numbers 409 409 $unspecified_counter = 0; 410 410 411 411 // Go through the array of new ranks. 412 412 foreach ($ranks as $id => $new_rank) { … … 414 414 // Unspecified entries receive a sort order of 10000. 415 415 $new_rank = 10000; 416 $unspecified_counter++; 416 $unspecified_counter++; 417 417 } 418 418 DB::query(" … … 422 422 "); 423 423 } 424 424 425 425 App::raiseMsg(_("Records have been reordered with the new rank."), MSG_SUCCESS, __FILE__, __LINE__); 426 426 if ($unspecified_counter > 0) {
Note: See TracChangeset
for help on using the changeset viewer.