function modclassementcaracdisp($idcaracteristique, $idcaracdispdesc, $type, $lang)
{
$caracdispdesc = new Caracdispdesc();
if ($caracdispdesc->charger($idcaracdispdesc, $lang)) {
$remplace = new Caracdispdesc();
if ($type == "M") {
$where = "classement<" . $caracdispdesc->classement . " order by classement desc";
} else {
if ($type == "D") {
$where = "classement>" . $caracdispdesc->classement . " order by classement";
}
}
$caracdisp = new Caracdisp();
$query = "\n\t\t\t\tselect\n\t\t\t\t\t*\n\t\t\t\tfrom\n\t\t\t\t\t{$caracdispdesc->table}\n\t\t\t\twhere\n\t\t\t\t\tlang={$lang}\n\t\t\t\tand\n\t\t\t\t\tcaracdisp in (select id from {$caracdisp->table} where caracteristique = {$idcaracteristique})\n\t\t\t\tand\n\t\t\t\t\t{$where}\n\t\t\t\tlimit\n\t\t\t\t\t0, 1\n\t\t\t";
if ($remplace->getVars($query)) {
$sauv = $remplace->classement;
$remplace->classement = $caracdispdesc->classement;
$caracdispdesc->classement = $sauv;
$remplace->maj();
$caracdispdesc->maj();
}
}
}
/**
*
* increment or decrement the current caracdispdesc rank.
*
* @param int $idcaracdispdesc caracdisdesc id to modify
* @param sting $type M for increase, D pour decrease rank
* @param int $lang current lang
*/
function modClassementCaracdisp($idcaracdispdesc, $type, $lang)
{
$caracdispdesc = new Caracdispdesc();
if ($caracdispdesc->charger($idcaracdispdesc, $lang)) {
$remplace = new Caracdispdesc();
if ($type == "M") {
$where = "classement<" . $caracdispdesc->classement . " order by classement desc";
} else {
if ($type == "D") {
$where = "classement>" . $caracdispdesc->classement . " order by classement";
}
}
$caracdisp = new Caracdisp();
$query = "\n select\n *\n from\n {$caracdispdesc->table}\n where\n lang={$lang}\n and\n caracdisp in (select id from {$caracdisp->table} where caracteristique = " . $this->id . ")\n and\n {$where}\n limit\n 0, 1\n ";
if ($remplace->getVars($query)) {
$sauv = $remplace->classement;
$remplace->classement = $caracdispdesc->classement;
$caracdispdesc->classement = $sauv;
$remplace->maj();
$caracdispdesc->maj();
}
}
redirige("caracteristique_modifier.php?id=" . $this->id . "&lang=" . $lang);
}
