robertvrabel · February 27, 2022 15:46 · Mar 9, 2017 · Mar 9, 2017 · Mar 9, 2017 · Mar 9, 2017
diff --git a/move-down.php b/move-down.php
@@ -4,5 +4,5 @@
               SET display_order = (display_order - 1)
               WHERE display_order > :current_position
               AND display_order <= :desired_position
-              AND user_id = :user_id;
+              AND user_id = :user_id";
 }
diff --git a/move-up.php b/move-up.php
@@ -4,5 +4,5 @@
               SET display_order = (display_order + 1)
               WHERE display_order >= :desired_position
               AND display_order < :current_position
-              AND user_id = :user_id
+              AND user_id = :user_id";
 }
diff --git a/reset.php b/reset.php
@@ -2,4 +2,4 @@
 $query = "UPDATE todos
           SET display_order = :desired_position
           WHERE display_order = 0
-          AND user_id = :user_id;
+          AND user_id = :user_id";
diff --git a/set.php b/set.php
@@ -2,4 +2,4 @@
 $query = "UPDATE todos
           SET display_order = 0
           WHERE display_order = :current_position
-          AND user_id = :user_id;
+          AND user_id = :user_id";
diff --git a/move-up.php b/move-up.php
@@ -1,8 +1,8 @@
 // Move up: Update the items between the desired position and the current position, increasing each item by 1 to make space for the new item
 if ($move == 'up') {
-    $query = "UPDATE `form_field_rel`
+    $query = "UPDATE todos
               SET display_order = (display_order + 1)
-              WHERE display_order >= " . $desired_position . "
-              AND display_order < " . $current_position . "
-              AND form_id = " . $form_id;
+              WHERE display_order >= :desired_position
+              AND display_order < :current_position
+              AND user_id = :user_id
 }
diff --git a/gistfile1.txt b/gistfile1.txt
@@ -0,0 +1,36 @@
+<table>
+  <thead>
+    <tr>
+      <th scope="col">user_id</th>
+      <th scope="col">display_order</th>
+      <th scope="col">todo</th>
+    </tr>
+  </thead>
+  <tbody>
+    <tr>
+      <td>2000</td>
+      <td>1</td>
+      <td>Take out garbage</td>
+    </tr>
+    <tr>
+      <td>2000</td>
+      <td>2</td>
+      <td>Clean house</td>
+    </tr>
+    <tr>
+      <td>2000</td>
+      <td>3</td>
+      <td>Do dishes</td>
+    </tr>
+    <tr>
+      <td>2000</td>
+      <td>4</td>
+      <td>Cut grass</td>
+    </tr>
+    <tr>
+      <td>2000</td>
+      <td>5</td>
+      <td>Change light bulb</td>
+    </tr>
+  </tbody>
+</table>
diff --git a/list.html b/list.html
@@ -0,0 +1,7 @@
+<ul class="todos">
+  <li class="todo">Take out garbage</li>
+  <li class="todo">Clean house</li>
+  <li class="todo">Do dishes</li>
+  <li class="todo">Cut grass</li>
+  <li class="todo">Change light bulb</li>
+</ul>
diff --git a/gistfile4.txt → move-down.php b/gistfile4.txt → move-down.php
diff --git a/gistfile5.txt → move-up.php b/gistfile5.txt → move-up.php
diff --git a/gistfile6.txt → reset.php b/gistfile6.txt → reset.php
diff --git a/gistfile3.txt → set.php b/gistfile3.txt → set.php
diff --git a/gistfile2.txt → position.php b/gistfile2.txt → position.php
diff --git a/gistfile1.txt → sort.js b/gistfile1.txt → sort.js
diff --git a/gistfile1.txt b/gistfile1.txt
@@ -0,0 +1,35 @@
+// Make the form fields sortable/draggable
+$('.todos').sortable({
+    items: '.todo',
+    start: function(event, ui) {
+        // Create a temporary attribute on the element with the old index
+        $(this).attr('data-currentindex', ui.item.index());
+    },
+    update: function(event, ui) {
+        let user_id = $('#user_id').val();
+        let current_position = $(this).attr('data-currentindex');
+        let desired_position = ui.item.index();
+
+        // Reset the current index
+        $(this).removeAttr('data-currentindex');
+
+        // Post to the server to handle the changes
+        $.ajax({
+            type: "POST",
+            url: "/url-to-handle-database-updates/",
+            data: {
+                desired_position: desired_position,
+                current_position: current_position,
+                user_id: user_id
+            },
+            beforeSend: function() {
+                // Disable dragging
+                $('.todos').sortable('disable');
+            },
+            success: function(html) {
+                // Re-enable dragging
+                $('.todos').sortable('enable');
+            }
+        });
+    }
+});
diff --git a/gistfile2.txt b/gistfile2.txt
@@ -0,0 +1,2 @@
+// Determine if the user is moving the item up or down in the listing
+$move = $desired_position > $current_position ? 'down' : 'up';
diff --git a/gistfile3.txt b/gistfile3.txt
@@ -0,0 +1,5 @@
+// Set the display_order for the dragged item to be 0 so we can update this record later by display_order = 0
+$query = "UPDATE todos
+          SET display_order = 0
+          WHERE display_order = :current_position
+          AND user_id = :user_id;
diff --git a/gistfile4.txt b/gistfile4.txt
@@ -0,0 +1,8 @@
+// Move down: Update the items between the current position and the desired position, decreasing each item by 1 to make space for the new item
+if ($move == 'down') {
+    $query = "UPDATE todos
+              SET display_order = (display_order - 1)
+              WHERE display_order > :current_position
+              AND display_order <= :desired_position
+              AND user_id = :user_id;
+}
diff --git a/gistfile5.txt b/gistfile5.txt
@@ -0,0 +1,8 @@
+// Move up: Update the items between the desired position and the current position, increasing each item by 1 to make space for the new item
+if ($move == 'up') {
+    $query = "UPDATE `form_field_rel`
+              SET display_order = (display_order + 1)
+              WHERE display_order >= " . $desired_position . "
+              AND display_order < " . $current_position . "
+              AND form_id = " . $form_id;
+}
diff --git a/gistfile6.txt b/gistfile6.txt
@@ -0,0 +1,5 @@
+// Update the item that was dragged and set it to be the desired position now that the slot is opend up
+$query = "UPDATE todos
+          SET display_order = :desired_position
+          WHERE display_order = 0
+          AND user_id = :user_id;
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		// Determine if the user is moving the item up or down in the listing
		$move = $desired_position > $current_position ? 'down' : 'up';
No results found