<?php

// $Id: class.order.php 915 2009-01-21 19:27:01Z Ruebenwurzel $

/*

 Website Baker Project <http://www.websitebaker.org/>
 Copyright (C) 2004-2009, Ryan Djurovich

 Website Baker is free software; you can redistribute it and/or modify
 it under the terms of the GNU General Public License as published by
 the Free Software Foundation; either version 2 of the License, or
 (at your option) any later version.

 Website Baker is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 GNU General Public License for more details.

 You should have received a copy of the GNU General Public License
 along with Website Baker; if not, write to the Free Software
 Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

*/

/*

Ordering class

This class will be used to change the order of an item in a table
which contains a special order field (type must be integer)

*/

// Stop this file from being accessed directly
if(!defined('WB_URL')) {
	header('Location: ../index.php');
	exit(0);
}

define('ORDERING_CLASS_LOADED', true);

// Load the other required class files if they are not already loaded
require_once(WB_PATH."/framework/class.database.php");

class order {
	
	// Get the db values
	function order($table, $order_field, $id_field = 'id', $common_field) {
		$this->table = $table;
		$this->order_field = $order_field;
		$this->id_field = $id_field;
		$this->common_field = $common_field;
	}
	
	// Move a row up
	function move_up($id) {
		global $database;
		// Get current order
		$query_order = "SELECT ".$this->order_field.",".$this->common_field." FROM ".$this->table." WHERE ".$this->id_field." = '$id'";
		$get_order = $database->query($query_order);
		$fetch_order = $get_order->fetchRow();
		$order = $fetch_order[$this->order_field];
		$parent = $fetch_order[$this->common_field];
		// Find out what row is before current one
		$query_previous = "SELECT ".$this->id_field.",".$this->order_field." FROM ".$this->table." WHERE ".$this->order_field." < '$order' AND ".$this->common_field." = '$parent' ORDER BY ".$this->order_field." DESC LIMIT 1";
		$get_previous = $database->query($query_previous);
		if($get_previous->numRows() > 0) {
			// Change the previous row to the current order
			$fetch_previous = $get_previous->fetchRow();
			$previous_id = $fetch_previous[$this->id_field];
			$decremented_order = $fetch_previous[$this->order_field];
			$query = "UPDATE ".$this->table." SET ".$this->order_field." = '$order' WHERE ".$this->id_field." = '$previous_id' LIMIT 1";
			$database->query($query);
			// Change the row we want to the decremented order
			$query = "UPDATE ".$this->table." SET ".$this->order_field." = '$decremented_order' WHERE ".$this->id_field." = '$id' LIMIT 1";
			$database->query($query);
			
			if($database->is_error()) {
				return false;
			} else {
				return true;
			}
		} else {
			return false;
		}
	}
	// Move a row up
	function move_down($id) {
		global $database;
		// Get current order
		$query_order = "SELECT ".$this->order_field.",".$this->common_field." FROM ".$this->table." WHERE ".$this->id_field." = '$id'";
		$get_order = $database->query($query_order);
		$fetch_order = $get_order->fetchRow();
		$order = $fetch_order[$this->order_field];
		$parent = $fetch_order[$this->common_field];
		// Find out what row is before current one
		$query_next = "SELECT $this->id_field,".$this->order_field." FROM ".$this->table." WHERE ".$this->order_field." > '$order' AND ".$this->common_field." = '$parent' ORDER BY ".$this->order_field." ASC LIMIT 1";
		$get_next = $database->query($query_next);
		if($get_next->numRows() > 0) {
			// Change the previous row to the current order
			$fetch_next = $get_next->fetchRow();
			$next_id = $fetch_next[$this->id_field];
			$incremented_order = $fetch_next[$this->order_field];
			$query = "UPDATE ".$this->table." SET ".$this->order_field." = '$order' WHERE ".$this->id_field." = '$next_id' LIMIT 1";
			$database->query($query);
			// Change the row we want to the decremented order
			$query = "UPDATE ".$this->table." SET ".$this->order_field." = '$incremented_order' WHERE ".$this->id_field." = '$id' LIMIT 1";
			$database->query($query);
			if($database->is_error()) {
				return false;
			} else {
				return true;
			}
		} else {
			return false;
		}
	}
	
	// Get new number for order
	function get_new($cf_value) {
		global $database;
		$database = new database();
		// Get last order
		$query_last = "SELECT ".$this->order_field." FROM ".$this->table." WHERE ".$this->common_field." = '$cf_value' ORDER BY ".$this->order_field." DESC LIMIT 1";
		$get_last = $database->query($query_last);
		if($get_last->numRows() > 0) {
			$fetch_last = $get_last->fetchRow();
			$last_order = $fetch_last[$this->order_field];
			return $last_order+1;
		} else {
			return 1;
		}
	}
	
	// Clean ordering (should be called if a row in the middle has been deleted)
	function clean($cf_value) {
		global $database;
		// Loop through all records and give new order
		$query_all = "SELECT * FROM ".$this->table." WHERE ".$this->common_field." = '$cf_value' ORDER BY ".$this->order_field." ASC";
		$get_all = $database->query($query_all);
		if($get_all->numRows() > 0) {
			$count = 1;
			while($row = $get_all->fetchRow()) {
				// Update row with new order
				$database->query("UPDATE ".$this->table." SET ".$this->order_field." = '$count' WHERE ".$this->id_field." = '".$row[$this->id_field]."'");
				$count = $count+1;
			}
		} else {
			 return true;
		}
	}
	
}

?>