как вариант

Азат Разетдинов 18.06.2007 13:16 / 18.06.2007 13:16

@moveObject[hParams][iShift]
$iShift(^math:sign($hParams.new_sort_order - $hParams.sort_order))
^if($iShift){
	^pSQL.void{
		UPDATE
			object
		SET
			sort_order = sort_order - ($iShift)
		WHERE
			^if($iShift > 0){
				sort_order >= ^hParams.sort_order.int(0) + 1
				AND sort_order <= ^hParams.new_sort_order.int(0)
			}{
				sort_order >= ^hParams.new_sort_order.int(0)
				AND sort_order <= ^hParams.sort_order.int(0) - 1
			}
	}
	^pSQL.void{
		UPDATE
			object
		SET
			sort_order = ^hParams.new_sort_order.int(0)
		WHERE
			object_id = ^hParams.object_id.int(0)
	}
}
#end @moveObject[]