Changeset 1109

Timestamp:

03/16/10 00:23:44 (2 years ago)

Author:

Prostu

Message:

Added a new button in the page generated by /admin/[round]?action=sterge-runda
that erases all the information regarding the round from the database.
Information relation to a round is found in the following tables:
ia_job_test
ia_job
ia_parameter_value
ia_round_task
ia_user_round
ia_round_task
ia_round

Location:

trunk

Files:

• common/db/round.php (modified) (1 diff)
• scripts/seek-value-in-db.php (added)
• www/controllers/round.php (modified) (2 diffs)
• www/index.php (modified) (1 diff)
• www/views/round_delete.php (modified) (1 diff)

trunk/common/db/round.php

@@ -423 +423 @@
 }
 
+function round_delete($round_id) {
+    log_assert(is_round_id($round_id));
+
+    // Delete round from cache
+    _round_cache_delete($round_id);
+
+    // Delete job_tests
+    $query = sprintf("SELECT `id`
+                      FROM `ia_job`
+                      WHERE `round_id` = %s",
+                      db_quote($round_id));
+
+    $job_ids_fetched = db_fetch_all($query);
+
+    $job_ids = array();
+    foreach ($job_ids_fetched as $job) {
+        $job_ids[] = (int)$job["id"];
+    }
+
+    if (count($job_ids)) {
+        $formated_job_ids = implode(", ", array_map("db_quote", $job_ids));
+        $query = sprintf("DELETE FROM `ia_job_test`
+                          WHERE `job_id` IN (%s)",
+                          $formated_job_ids);
+        db_query($query);
+
+        $query = sprintf("DELETE FROM `ia_job`
+                          WHERE `id` IN (%s)",
+                          $formated_job_ids);
+        db_query($query);
+    }
+
+    // Delete entries from ia_parameter_value...
+    $query = sprintf("DELETE FROM `ia_parameter_value`
+                      WHERE `object_type` = 'round'
+                        AND `object_id` = %s",
+                      db_quote($round_id));
+    db_query($query);
+
+    // Delete entries from round-task
+    $query = sprintf("DELETE FROM `ia_round_task`
+                      WHERE `round_id` = %s",
+                      db_quote($round_id));
+    db_query($query);
+
+    // Delete entries from user-round
+    $query = sprintf("DELETE FROM `ia_user_round`
+                      WHERE `round_id` = %s",
+                      db_quote($round_id));
+    db_query($query);
+
+    // Delete entries from round-task
+    $query = sprintf("DELETE FROM `ia_round_task`
+                      WHERE `round_id` = %s",
+                      db_quote($round_id));
+    db_query($query);
+
+    // Delete entries from ia_score
+    $query = sprintf("DELETE FROM `ia_score`
+                      WHERE `round_id` = %s",
+                      db_quote($round_id));
+    db_query($query);
+
+    // ACTUALLY DELETE THE ROUND
+    $query = sprintf("DELETE FROM `ia_round`
+                      WHERE `id` = %s",
+                      db_quote($round_id));
+    db_query($query);
+}
+
 ?>

trunk/www/controllers/round.php

@@ -270 +270 @@
 }
 
-function controller_round_delete($round_id) {
+function controller_round_delete_view($round_id) {
     // Validate round_id
     if (!is_round_id($round_id)) {
@@ -324 +324 @@
 }
 
+function controller_round_delete($round_id) {
+    if (!request_is_post()) {
+        flash_error('Runda nu a putut fi stearsa.');
+    }
+
+    // Validate round_id
+    if (!is_round_id($round_id)) {
+        flash_error('Identificatorul rundei este invalid.');
+        redirect(url_home());
+    }
+
+    // Get round
+    $round = round_get($round_id);
+    if (!$round) {
+        flash_error('Runda nu exista.');
+        redirect(url_home());
+    }
+
+    // Security check
+    identity_require('round-delete', $round);
+
+    // Delete all the round related information from the database
+    round_delete($round_id);
+
+    flash('Runda a fost stearsa.');
+    redirect(url_home());
+}
+
 ?>

trunk/www/index.php

@@ -127 +127 @@
     require_once(IA_ROOT_DIR.'www/controllers/textblock.php');
     if ($action == 'sterge-runda') {
-        if (request('delete')) {
+        if (request('delete-pages')) {
             $v = request('textblocks');
             controller_textblock_delete_many($v, url_round_delete($obj_id));
+        } elseif (request('delete-round')) {
+            controller_round_delete($obj_id);
         } else {
-            controller_round_delete($obj_id);
+            controller_round_delete_view($obj_id);
         }
     } else {

trunk/www/views/round_delete.php

@@ -70 +70 @@
         if ($view['total_entries']) {
     ?>
-        <br /><input type="submit" value="Sterge Paginile" class="button" name="delete" onclick="return confirm('Aceasta actiune este ireversibila! Doresti sa continui?');" />
+        <br /><input type="submit" value="Sterge Paginile" class="button" name="delete-pages" onclick="return confirm('Aceasta actiune este ireversibila! Doresti sa continui?');" />
     <?php } ?>
     </form>
 
+    <form method = 'post' action = ''>
+    <input type="submit" value="Sterge Runda, Forever..." class="button" name="delete-round" onclick="return confirm('Aceasta actiune este ireversibila! Doresti sa continui?');" />
+    </form>
+
 <?php include('footer.php'); ?>