+--- eventum-2.2/htdocs/ajax/order.php 1970-01-01 02:00:00.000000000 +0200
++++ eventum-2.2-order/htdocs/ajax/order.php 2009-10-12 22:10:36.429185594 +0300
+@@ -0,0 +1,69 @@
++<?
++require_once dirname(__FILE__) . '/../../init.php';
++
++// check login
++if (!Auth::hasValidCookie(APP_COOKIE)) {
++ exit;
++}
++
++
++if (!isset($_POST['before']) || !isset($_POST['after'])) {
++ exit;
++}
++
++parse_str($_POST['before'], $before);
++parse_str($_POST['after'], $after);
++
++$before = $before['issue_list_table'];
++$after = $after['issue_list_table'];
++
++
++$before = array_slice($before, 2, count($before)-3);
++$after = array_slice($after, 2, count($after)-3);
++
++if (count($before) != count($after) or count($before) < 1) {
++ exit;
++}
++
++$usr_id = Auth::getUserID();
++
++$order = Issue::getIssueOrderByUser($usr_id);
++
++if (!count($order)) {
++ // no prev order list
++ exit;
++}
++
++$after_filterd = array();
++$before_filterd = array();
++
++// remove issues that are not assigned to me
++foreach ($after as $id) {
++ if (isset($order[$id])) {
++ $after_filterd[] = $id;
++ }
++}
++foreach ($before as $id) {
++ if (isset($order[$id])) {
++ $before_filterd[] = $id;
++ }
++}
++
++foreach ($after_filterd as $key => $nID) {
++ if ($nID != $before_filterd[$key]) {
++ if ($nID) {
++ $stmt = "UPDATE
++ " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "issue_user
++ SET
++ isu_order = " . $order[$before_filterd[$key]] . "
++ WHERE
++ isu_iss_id = $nID AND
++ isu_usr_id = $usr_id";
++ $res = DB_Helper::getInstance()->query($stmt);
++ if (PEAR::isError($res)) {
++ Error_Handler::logError(array($res->getMessage(), $res->getDebugInfo()), __FILE__, __LINE__);
++ die('update failed');
++ }
++ }
++ }
++}
+--- eventum-2.3.1/htdocs/css/style.css~ 2011-09-15 09:36:55.000000000 +0300
++++ eventum-2.3.1/htdocs/css/style.css 2011-09-15 09:38:23.668223576 +0300
+@@ -177,6 +177,24 @@
+ cursor: pointer;
+ }
+
++.tDnD_whileDrag td {
++ background-color: #ffffdd;
++}
++.tDnD_whileDrag td {
++ border: 1px solid red;
++}
++.inline_date_pick {
++ cursor: pointer;
++}
++.custom_field {
++ cursor: pointer;
++}
++.showDragHandle {
++ cursor: move;
++ background-image: url(../images/updown2.gif);
++ background-repeat: no-repeat;
++ background-position: center center;
++}
+
+ ul.excerpts {
+ list-style: none;
+@@ -187,4 +205,4 @@
+ ul.excerpts ul {
+ list-style-type: none;
+ padding-left: 1em;
+-}
+\ No newline at end of file
++}
+--- eventum-2.2/htdocs/js/jquery/jquery.tablednd.js 1970-01-01 02:00:00.000000000 +0200
++++ eventum-2.2-order/htdocs/js/jquery/jquery.tablednd.js 2009-10-12 22:10:36.435851675 +0300
+@@ -0,0 +1,382 @@
++/**
++ * TableDnD plug-in for JQuery, allows you to drag and drop table rows
++ * You can set up various options to control how the system will work
++ * Copyright (c) Denis Howlett <denish@isocra.com>
++ * Licensed like jQuery, see http://docs.jquery.com/License.
++ *
++ * Configuration options:
++ *
++ * onDragStyle
++ * This is the style that is assigned to the row during drag. There are limitations to the styles that can be
++ * associated with a row (such as you can't assign a border--well you can, but it won't be
++ * displayed). (So instead consider using onDragClass.) The CSS style to apply is specified as
++ * a map (as used in the jQuery css(...) function).
++ * onDropStyle
++ * This is the style that is assigned to the row when it is dropped. As for onDragStyle, there are limitations
++ * to what you can do. Also this replaces the original style, so again consider using onDragClass which
++ * is simply added and then removed on drop.
++ * onDragClass
++ * This class is added for the duration of the drag and then removed when the row is dropped. It is more
++ * flexible than using onDragStyle since it can be inherited by the row cells and other content. The default
++ * is class is tDnD_whileDrag. So to use the default, simply customise this CSS class in your
++ * stylesheet.
++ * onDrop
++ * Pass a function that will be called when the row is dropped. The function takes 2 parameters: the table
++ * and the row that was dropped. You can work out the new order of the rows by using
++ * table.rows.
++ * onDragStart
++ * Pass a function that will be called when the user starts dragging. The function takes 2 parameters: the
++ * table and the row which the user has started to drag.
++ * onAllowDrop
++ * Pass a function that will be called as a row is over another row. If the function returns true, allow
++ * dropping on that row, otherwise not. The function takes 2 parameters: the dragged row and the row under
++ * the cursor. It returns a boolean: true allows the drop, false doesn't allow it.
++ * scrollAmount
++ * This is the number of pixels to scroll if the user moves the mouse cursor to the top or bottom of the
++ * window. The page should automatically scroll up or down as appropriate (tested in IE6, IE7, Safari, FF2,
++ * FF3 beta
++ * dragHandle
++ * This is the name of a class that you assign to one or more cells in each row that is draggable. If you
++ * specify this class, then you are responsible for setting cursor: move in the CSS and only these cells
++ * will have the drag behaviour. If you do not specify a dragHandle, then you get the old behaviour where
++ * the whole row is draggable.
++ *
++ * Other ways to control behaviour:
++ *
++ * Add class="nodrop" to any rows for which you don't want to allow dropping, and class="nodrag" to any rows
++ * that you don't want to be draggable.
++ *
++ * Inside the onDrop method you can also call $.tableDnD.serialize() this returns a string of the form
++ * <tableID>[]=<rowID1>&<tableID>[]=<rowID2> so that you can send this back to the server. The table must have
++ * an ID as must all the rows.
++ *
++ * Other methods:
++ *
++ * $("...").tableDnDUpdate()
++ * Will update all the matching tables, that is it will reapply the mousedown method to the rows (or handle cells).
++ * This is useful if you have updated the table rows using Ajax and you want to make the table draggable again.
++ * The table maintains the original configuration (so you don't have to specify it again).
++ *
++ * $("...").tableDnDSerialize()
++ * Will serialize and return the serialized string as above, but for each of the matching tables--so it can be
++ * called from anywhere and isn't dependent on the currentTable being set up correctly before calling
++ *
++ * Known problems:
++ * - Auto-scoll has some problems with IE7 (it scrolls even when it shouldn't), work-around: set scrollAmount to 0
++ *
++ * Version 0.2: 2008-02-20 First public version
++ * Version 0.3: 2008-02-07 Added onDragStart option
++ * Made the scroll amount configurable (default is 5 as before)
++ * Version 0.4: 2008-03-15 Changed the noDrag/noDrop attributes to nodrag/nodrop classes
++ * Added onAllowDrop to control dropping
++ * Fixed a bug which meant that you couldn't set the scroll amount in both directions
++ * Added serialize method
++ * Version 0.5: 2008-05-16 Changed so that if you specify a dragHandle class it doesn't make the whole row
++ * draggable
++ * Improved the serialize method to use a default (and settable) regular expression.
++ * Added tableDnDupate() and tableDnDSerialize() to be called when you are outside the table
++ */
++jQuery.tableDnD = {
++ /** Keep hold of the current table being dragged */
++ currentTable : null,
++ /** Keep hold of the current drag object if any */
++ dragObject: null,
++ /** The current mouse offset */
++ mouseOffset: null,
++ /** Remember the old value of Y so that we don't do too much processing */
++ oldY: 0,
++
++ /** Actually build the structure */
++ build: function(options) {
++ // Set up the defaults if any
++
++ this.each(function() {
++ // This is bound to each matching table, set up the defaults and override with user options
++ this.tableDnDConfig = jQuery.extend({
++ onDragStyle: null,
++ onDropStyle: null,
++ // Add in the default class for whileDragging
++ onDragClass: "tDnD_whileDrag",
++ onDrop: null,
++ onDragStart: null,
++ scrollAmount: 5,
++ serializeRegexp: /[^\-]*$/, // The regular expression to use to trim row IDs
++ serializeParamName: null, // If you want to specify another parameter name instead of the table ID
++ dragHandle: null // If you give the name of a class here, then only Cells with this class will be draggable
++ }, options || {});
++ // Now make the rows draggable
++ jQuery.tableDnD.makeDraggable(this);
++ });
++
++ // Now we need to capture the mouse up and mouse move event
++ // We can use bind so that we don't interfere with other event handlers
++ jQuery(document)
++ .bind('mousemove', jQuery.tableDnD.mousemove)
++ .bind('mouseup', jQuery.tableDnD.mouseup);
++
++ // Don't break the chain
++ return this;
++ },
++
++ /** This function makes all the rows on the table draggable apart from those marked as "NoDrag" */
++ makeDraggable: function(table) {
++ var config = table.tableDnDConfig;
++ if (table.tableDnDConfig.dragHandle) {
++ // We only need to add the event to the specified cells
++ var cells = jQuery("td."+table.tableDnDConfig.dragHandle, table);
++ cells.each(function() {
++ // The cell is bound to "this"
++ jQuery(this).mousedown(function(ev) {
++ jQuery.tableDnD.dragObject = this.parentNode;
++ jQuery.tableDnD.currentTable = table;
++ jQuery.tableDnD.mouseOffset = jQuery.tableDnD.getMouseOffset(this, ev);
++ if (config.onDragStart) {
++ // Call the onDrop method if there is one
++ config.onDragStart(table, this);
++ }
++ return false;
++ });
++ })
++ } else {
++ // For backwards compatibility, we add the event to the whole row
++ var rows = jQuery("tr", table); // get all the rows as a wrapped set
++ rows.each(function() {
++ // Iterate through each row, the row is bound to "this"
++ var row = jQuery(this);
++ if (! row.hasClass("nodrag")) {
++ row.mousedown(function(ev) {
++ if (ev.target.tagName == "TD") {
++ jQuery.tableDnD.dragObject = this;
++ jQuery.tableDnD.currentTable = table;
++ jQuery.tableDnD.mouseOffset = jQuery.tableDnD.getMouseOffset(this, ev);
++ if (config.onDragStart) {
++ // Call the onDrop method if there is one
++ config.onDragStart(table, this);
++ }
++ return false;
++ }
++ }).css("cursor", "move"); // Store the tableDnD object
++ }
++ });
++ }
++ },
++
++ updateTables: function() {
++ this.each(function() {
++ // this is now bound to each matching table
++ if (this.tableDnDConfig) {
++ jQuery.tableDnD.makeDraggable(this);
++ }
++ })
++ },
++
++ /** Get the mouse coordinates from the event (allowing for browser differences) */
++ mouseCoords: function(ev){
++ if(ev.pageX || ev.pageY){
++ return {x:ev.pageX, y:ev.pageY};
++ }
++ return {
++ x:ev.clientX + document.body.scrollLeft - document.body.clientLeft,
++ y:ev.clientY + document.body.scrollTop - document.body.clientTop
++ };
++ },
++
++ /** Given a target element and a mouse event, get the mouse offset from that element.
++ To do this we need the element's position and the mouse position */
++ getMouseOffset: function(target, ev) {
++ ev = ev || window.event;
++
++ var docPos = this.getPosition(target);
++ var mousePos = this.mouseCoords(ev);
++ return {x:mousePos.x - docPos.x, y:mousePos.y - docPos.y};
++ },
++
++ /** Get the position of an element by going up the DOM tree and adding up all the offsets */
++ getPosition: function(e){
++ var left = 0;
++ var top = 0;
++ /** Safari fix -- thanks to Luis Chato for this! */
++ if (e.offsetHeight == 0) {
++ /** Safari 2 doesn't correctly grab the offsetTop of a table row
++ this is detailed here:
++ http://jacob.peargrove.com/blog/2006/technical/table-row-offsettop-bug-in-safari/
++ the solution is likewise noted there, grab the offset of a table cell in the row - the firstChild.
++ note that firefox will return a text node as a first child, so designing a more thorough
++ solution may need to take that into account, for now this seems to work in firefox, safari, ie */
++ e = e.firstChild; // a table cell
++ }
++
++ while (e.offsetParent){
++ left += e.offsetLeft;
++ top += e.offsetTop;
++ e = e.offsetParent;
++ }
++
++ left += e.offsetLeft;
++ top += e.offsetTop;
++
++ return {x:left, y:top};
++ },
++
++ mousemove: function(ev) {
++ if (jQuery.tableDnD.dragObject == null) {
++ return;
++ }
++
++ var dragObj = jQuery(jQuery.tableDnD.dragObject);
++ var config = jQuery.tableDnD.currentTable.tableDnDConfig;
++ var mousePos = jQuery.tableDnD.mouseCoords(ev);
++ var y = mousePos.y - jQuery.tableDnD.mouseOffset.y;
++ //auto scroll the window
++ var yOffset = window.pageYOffset;
++ if (document.all) {
++ // Windows version
++ //yOffset=document.body.scrollTop;
++ if (typeof document.compatMode != 'undefined' &&
++ document.compatMode != 'BackCompat') {
++ yOffset = document.documentElement.scrollTop;
++ }
++ else if (typeof document.body != 'undefined') {
++ yOffset=document.body.scrollTop;
++ }
++
++ }
++
++ if (mousePos.y-yOffset < config.scrollAmount) {
++ window.scrollBy(0, -config.scrollAmount);
++ } else {
++ var windowHeight = window.innerHeight ? window.innerHeight
++ : document.documentElement.clientHeight ? document.documentElement.clientHeight : document.body.clientHeight;
++ if (windowHeight-(mousePos.y-yOffset) < config.scrollAmount) {
++ window.scrollBy(0, config.scrollAmount);
++ }
++ }
++
++
++ if (y != jQuery.tableDnD.oldY) {
++ // work out if we're going up or down...
++ var movingDown = y > jQuery.tableDnD.oldY;
++ // update the old value
++ jQuery.tableDnD.oldY = y;
++ // update the style to show we're dragging
++ if (config.onDragClass) {
++ dragObj.addClass(config.onDragClass);
++ } else {
++ dragObj.css(config.onDragStyle);
++ }
++ // If we're over a row then move the dragged row to there so that the user sees the
++ // effect dynamically
++ var currentRow = jQuery.tableDnD.findDropTargetRow(dragObj, y);
++ if (currentRow) {
++ // TODO worry about what happens when there are multiple TBODIES
++ if (movingDown && jQuery.tableDnD.dragObject != currentRow) {
++ jQuery.tableDnD.dragObject.parentNode.insertBefore(jQuery.tableDnD.dragObject, currentRow.nextSibling);
++ } else if (! movingDown && jQuery.tableDnD.dragObject != currentRow) {
++ jQuery.tableDnD.dragObject.parentNode.insertBefore(jQuery.tableDnD.dragObject, currentRow);
++ }
++ }
++ }
++
++ return false;
++ },
++
++ /** We're only worried about the y position really, because we can only move rows up and down */
++ findDropTargetRow: function(draggedRow, y) {
++ var rows = jQuery.tableDnD.currentTable.rows;
++ for (var i=0; i<rows.length; i++) {
++ var row = rows[i];
++ var rowY = this.getPosition(row).y;
++ var rowHeight = parseInt(row.offsetHeight)/2;
++ if (row.offsetHeight == 0) {
++ rowY = this.getPosition(row.firstChild).y;
++ rowHeight = parseInt(row.firstChild.offsetHeight)/2;
++ }
++ // Because we always have to insert before, we need to offset the height a bit
++ if ((y > rowY - rowHeight) && (y < (rowY + rowHeight))) {
++ // that's the row we're over
++ // If it's the same as the current row, ignore it
++ if (row == draggedRow) {return null;}
++ var config = jQuery.tableDnD.currentTable.tableDnDConfig;
++ if (config.onAllowDrop) {
++ if (config.onAllowDrop(draggedRow, row)) {
++ return row;
++ } else {
++ return null;
++ }
++ } else {
++ // If a row has nodrop class, then don't allow dropping (inspired by John Tarr and Famic)
++ var nodrop = jQuery(row).hasClass("nodrop");
++ if (! nodrop) {
++ return row;
++ } else {
++ return null;
++ }
++ }
++ return row;
++ }
++ }
++ return null;
++ },
++
++ mouseup: function(e) {
++ if (jQuery.tableDnD.currentTable && jQuery.tableDnD.dragObject) {
++ var droppedRow = jQuery.tableDnD.dragObject;
++ var config = jQuery.tableDnD.currentTable.tableDnDConfig;
++ // If we have a dragObject, then we need to release it,
++ // The row will already have been moved to the right place so we just reset stuff
++ if (config.onDragClass) {
++ jQuery(droppedRow).removeClass(config.onDragClass);
++ } else {
++ jQuery(droppedRow).css(config.onDropStyle);
++ }
++ jQuery.tableDnD.dragObject = null;
++ if (config.onDrop) {
++ // Call the onDrop method if there is one
++ config.onDrop(jQuery.tableDnD.currentTable, droppedRow);
++ }
++ jQuery.tableDnD.currentTable = null; // let go of the table too
++ }
++ },
++
++ serialize: function() {
++ if (jQuery.tableDnD.currentTable) {
++ return jQuery.tableDnD.serializeTable(jQuery.tableDnD.currentTable);
++ } else {
++ return "Error: No Table id set, you need to set an id on your table and every row";
++ }
++ },
++
++ serializeTable: function(table) {
++ var result = "";
++ var tableId = table.id;
++ var rows = table.rows;
++ for (var i=0; i<rows.length; i++) {
++ if (result.length > 0) result += "&";
++ var rowId = rows[i].id;
++ if (rowId && rowId && table.tableDnDConfig && table.tableDnDConfig.serializeRegexp) {
++ rowId = rowId.match(table.tableDnDConfig.serializeRegexp)[0];
++ }
++
++ result += tableId + '[]=' + rowId;
++ }
++ return result;
++ },
++
++ serializeTables: function() {
++ var result = "";
++ this.each(function() {
++ // this is now bound to each matching table
++ result += jQuery.tableDnD.serializeTable(this);
++ });
++ return result;
++ }
++
++}
++
++jQuery.fn.extend(
++ {
++ tableDnD : jQuery.tableDnD.build,
++ tableDnDUpdate : jQuery.tableDnD.updateTables,
++ tableDnDSerialize: jQuery.tableDnD.serializeTables
++ }
++);
+\ No newline at end of file
+--- eventum-2.3.2/htdocs/list.php~ 2012-03-09 18:19:56.000000000 +0200
++++ eventum-2.3.2/htdocs/list.php 2012-03-09 18:32:43.998284397 +0200
+@@ -67,6 +67,11 @@
+ }
+ }
+
++@$reorder_usr_id = $_REQUEST["reorder_user"];
++@$reorder_issue_id = $_REQUEST["reorder_source"];
++@$reorder_neworder = $_REQUEST["reorder_neworder"];
++Issue::reorderUserIssues($reorder_usr_id, $reorder_issue_id, $reorder_neworder);
++
+ if (!empty($_REQUEST['nosave'])) {
+ $options = Search::saveSearchParams(false);
+ } else {
+@@ -92,6 +97,24 @@
+ }
+ $assign_options += $users;
+
++// get the isu_order (assigned users) ordering user
++if (!empty($options["users"])) {
++ if ($options["users"] == -2) {
++ $isu_order_user = $usr_id;
++ } else
++ if ($options["users"] > 0) {
++ $isu_order_user = $options["users"];
++ } else {
++ unset($isu_order_user);
++ }
++} else {
++ unset($isu_order_user);
++}
++
++if (isset($isu_order_user)) {
++ $tpl->assign("isu_order_user", $isu_order_user);
++}
++
+ $list = Search::getListing($prj_id, $options, $pagerRow, $rows);
+ $tpl->assign("list", $list["list"]);
+ $tpl->assign("list_info", $list["info"]);
+--- eventum-2.2/lib/eventum/class.display_column.php 2009-09-14 18:07:55.000000000 +0300
++++ eventum-2.2-order/lib/eventum/class.display_column.php 2009-10-12 22:10:36.429185594 +0300
+@@ -230,7 +230,10 @@