You are here

SlickGrid example 9: Row reordering in Slickgrid 6

Tips:
Click to select, Ctrl-click to toggle selection, Shift-click to select a range.
Drag one or more rows by the handle to reorder.
Drag one or more rows to the recycle bin to delete.

Recycle Bin

File

js/slickgrid/examples/example9-row-reordering2.html
View source
<!DOCTYPE HTML>
<html>
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
		<title>SlickGrid example 9: Row reordering</title>
		<link rel="stylesheet" href="../slick.grid.css" type="text/css" media="screen" charset="utf-8" />
        <link rel="stylesheet" href="../css/smoothness/jquery-ui-1.8.5.custom.css" type="text/css" media="screen" charset="utf-8" />
		<link rel="stylesheet" href="examples.css" type="text/css" media="screen" charset="utf-8" />
		<style>
		.cell-title {
			zfont-weight: bold;
		}
		.cell-effort-driven {
			text-align: center;
		}
		.cell-reorder {
			cursor: move;
			background: url("../images/drag-handle.png") no-repeat center center;
		}

        .cell-selection {
            border-right-color: silver;
            border-right-style: solid;
            background: #f5f5f5;
            color: gray;
            text-align: right;
            font-size: 10px;
        }

        .slick-row.selected .cell-selection {
            background-color: transparent; /* show default selected row background */
        }

        .recycle-bin {
            width: 120px;
            border: 1px solid gray;
            background: beige;
            padding: 4px;
            font-size: 12pt;
            font-weight: bold;
            color: black;
            text-align: center;
            -moz-border-radius: 10px;
        }

        .red {
            background: red;
        }

        .bold {
            font-weight: bold;
        }
	</style>
	</head>
	<body>
		<div style="width:600px;float:left;">
			<div class="grid-header" style="width:100%">
				<label>Santa's TODO list:</label>
			</div>
			<div id="myGrid" style="width:100%;height:500px;"></div>
		</div>
		<div class="options-panel" style="width:320px;margin-left:650px;">
			<b>Tips:</b>
			<hr/>
			<div style="padding:6px;">
				Click to select, Ctrl-click to toggle selection, Shift-click to select a range.<br/>
				Drag one or more rows by the handle to reorder.<br/>
                Drag one or more rows to the recycle bin to delete.

                <br/>
                <br/>
                <div id="dropzone" class="recycle-bin">
                    Recycle Bin
                </div>
			</div>
		</div>

		<script src="../lib/firebugx.js"></script>

		<script src="../lib/jquery-1.4.3.min.js"></script>
		<script src="../lib/jquery-ui-1.8.5.custom.min.js"></script>
		<script src="../lib/jquery.event.drag-2.0.min.js"></script>
		<script src="../lib/jquery.event.drop-2.0.min.js"></script>

        <script src="../slick.core.js"></script>
        <script src="../plugins/slick.cellrangeselector.js"></script>
        <script src="../plugins/slick.cellselectionmodel.js"></script>
        <script src="../plugins/slick.rowselectionmodel.js"></script>
        <script src="../plugins/slick.rowmovemanager.js"></script>
		<script src="../slick.editors.js"></script>
		<script src="../slick.grid.js"></script>
		<script src="../slick.dataview.js"></script>

		<script>
		var grid;
		var data = [];
		var dataView;

        var columns = [
            {
                id: "#",
                name: "",
                width: 40,
                behavior: "selectAndMove",
                unselectable: true,
                resizable: false,
                cssClass: "cell-reorder dnd"
            },
            {
                id: "name",
                name: "Name",
                field: "name",
                width: 500,
                cssClass: "cell-title",
                editor: TextCellEditor,
                validator: requiredFieldValidator
            },
            {
                id: "complete",
                name: "Complete",
                width: 60,
                cssClass: "cell-effort-driven",
                field: "complete",
                cannotTriggerInsert: true,
                formatter: BoolCellFormatter,
                editor: YesNoCheckboxCellEditor
            }
        ];

		var options = {
			editable: true,
			enableAddRow: true,
			// enableRowReordering: true,
			enableCellNavigation: true,
			forceFitColumns: true,
            autoEdit: false
		};

		function requiredFieldValidator(value) {
			if (value == null || value == undefined || !value.length)
				return {valid:false, msg:"This is a required field"};
			else
				return {valid:true, msg:null};
		}

		$(function()
		{
			data = [
				{ name: "Make a list", complete: true, id: 1},
				{ name: "Check it twice", complete: false, id: 2},
				{ name: "Find out who's naughty", complete: false, id: 3},
				{ name: "Find out who's nice", complete: false, id: 4}
			];
			dataView = new Slick.Data.DataView();
			grid = new Slick.Grid("#myGrid", dataView, columns, options);
			
            grid.setSelectionModel(new Slick.RowSelectionModel());

				            var moveRowsPlugin = new Slick.RowMoveManager();
				
				            moveRowsPlugin.onBeforeMoveRows.subscribe(function(e,data) {
				                for (var i = 0; i < data.rows.length; i++) {
				                    // no point in moving before or after itself
				                    if (data.rows[i] == data.insertBefore || data.rows[i] == data.insertBefore - 1) {
				                        e.stopPropagation();
				                        return false;
				                    }
				                }
				
				                return true;
				            });
				
				            moveRowsPlugin.onMoveRows.subscribe(function(e,args) {
				var extractedRows = [], left, right;
				                var rows = args.rows;
				                var insertBefore = args.insertBefore;
				left = data.slice(0,insertBefore);
				right = data.slice(insertBefore,data.length);
				
				for (var i=0; i<rows.length; i++) {
					extractedRows.push(data[rows[i]]);
				}
				
				rows.sort().reverse();
				
				for (var i=0; i<rows.length; i++) {
					var row = rows[i];
					if (row < insertBefore)
						left.splice(row,1);
					else
						right.splice(row-insertBefore,1);
				}
				
				data = left.concat(extractedRows.concat(right));
				
				var selectedRows = [];
				for (var i=0; i<rows.length; i++)
					selectedRows.push(left.length+i);
				
				                grid.resetActiveCell();
				grid.setData(data);
				grid.setSelectedRows(selectedRows);
				grid.render();
				            });

            grid.registerPlugin(moveRowsPlugin);

			dataView.onRowCountChanged.subscribe(function(e,args) {
				grid.updateRowCount();
			    grid.render();
			});

			dataView.beginUpdate();
			// dataView.setItems(data);
			dataView.endUpdate();

 
		})
		</script>
	</body>
</html>