THELIA Forum

<?php
require_once(__DIR__."/Baseobj.class.php");

class Baseobjclassable extends Baseobj {

	private function construire_where_clause($colonnes = false) {
		if ($colonnes == false)
			$where_colonne = "";
		else if (is_array($colonnes)) {
			$where_colonne = "";

			foreach($colonnes as $colonne) {
				$where_colonne .= "$colonne=".intval($this->$colonne)." and ";
			}
		}
		else
			$where_colonne = "$colonnes=".intval($this->$colonnes)." and ";

		return $where_colonne;
	}

	protected function modifier_classement_base($id, $classement, $colonnes = false, $methode_module = false) {

		if ($this->charger_id($id)) {

			$where_colonne = $this->construire_where_clause($colonnes);

			if ($classement > $this->classement) {
				$between = "$this->classement and $classement";
				$delta = -1;
			}
			else {

				$between = "$classement and $this->classement";
				$delta = +1;
			}

			$query = "select * from $this->table where $where_colonne classement BETWEEN $between";

			$resul = $this->query($query);

			while ($resul && $row = $this->fetch_object($resul, get_class($this))) {
				$row->classement += $delta;
				$row->maj();
			}

			$this->classement = $classement;
			$this->maj();

			if ($methode_module != false) ActionsModules::instance()->appel_module($methode_module, $this);
		}
	}

	protected function changer_classement_base($id, $sens, $colonnes = false) {

		if ($this->charger_id($id)) {

			$where_colonne = $this->construire_where_clause($colonnes);

			if ($sens == "M")
				$req = " < " . $this->classement . " order by classement desc";
			else if ($sens == "D")
				$req = " > " . $this->classement . " order by classement";
			else
				return;

			$res = $this->query("select id, classement from $this->table where $where_colonne classement $req limit 0,1");

			if ($res && $this->num_rows($res) > 0) {

				$repl_id = $this->get_result($res, 0, 0);
				$repl_classement = $this->get_result($res, 0, 1);

				$res = $this->query("update $this->table set classement = ".intval($repl_classement)." where id = $this->id");

				if ($res)
					$this->query("update $this->table set classement = ".intval($this->classement)." where id = $repl_id");
			}
		}
	}
}
require_once(__DIR__."/actions/ActionsModules.class.php");