function moddecli($produit, $declidisp, $type)
{
$exdecprod = new Exdecprod();
$exdecprod->query("delete from {$exdecprod->table} where produit={$produit} and declidisp={$declidisp}");
if ($type != 0) {
$exdecprod->produit = $produit;
$exdecprod->declidisp = $declidisp;
$exdecprod->add();
}
}
function boucleDeclidisp($texte, $args)
{
global $declidisp;
$declinaison = lireTag($args, "declinaison", "int");
$id = lireTag($args, "id", "int");
$produit = lireTag($args, "produit", "int");
$classement = lireTag($args, "classement", "string");
$stockmini = lireTag($args, "stockmini", "int");
$courante = lireTag($args, "courante", "int");
$num = lireTag($args, "num", "int");
$search = "";
$limit = "";
$res = "";
$tdeclidisp = new Declidisp();
$tdeclidispdesc = new Declidispdesc();
// preparation de la requete
if ($declinaison != "") {
$search .= " and {$tdeclidisp->table}.declinaison=\"{$declinaison}\"";
}
if ($id != "") {
$search .= " and {$tdeclidisp->table}.id=\"{$id}\"";
}
if ($classement == "alpha") {
$order = "order by {$tdeclidispdesc->table}.titre";
} else {
if ($classement == "alphainv") {
$order = "order by {$tdeclidispdesc->table}.titre desc";
} else {
if ($classement == "manuel") {
$order = "order by {$tdeclidispdesc->table}.classement";
}
}
}
if (ActionsLang::instance()->get_action_si_trad_absente() == ActionsLang::UTILISER_LANGUE_INDIQUEE) {
// On retourne uniquement les declidisp traduites
$search .= " and {$tdeclidispdesc->table}.id is not null";
}
if ($stockmini != "" && $produit != "") {
$stock = new Stock();
$stock_join = "inner join {$stock->table} on {$stock->table}.produit={$produit} and {$stock->table}.declidisp = declidisp.id";
$search .= " and {$stock->table}.valeur >= {$stockmini}";
}
if ($num != "") {
$limit = " limit {$num}";
}
$query = "\n\t\t\tselect {$tdeclidisp->table}.* from {$tdeclidisp->table}\n\t\t\t{$stock_join}\n\t\t\tleft join {$tdeclidispdesc->table} on {$tdeclidispdesc->table}.declidisp = {$tdeclidisp->table}.id and {$tdeclidispdesc->table}.lang = " . ActionsLang::instance()->get_id_langue_courante() . "\n\t\t\twhere 1 {$search}\n\t\t\t{$order}\n\t\t\t{$limit}\n\t\t";
$resul = CacheBase::getCache()->query($query);
if (!empty($resul)) {
$exdecprod = new Exdecprod();
foreach ($resul as $row) {
if ($courante == "1" && $row->id . "-" != $declidisp) {
continue;
} else {
if ($courante == "0" && $row->id . "-" == $declidisp) {
continue;
}
}
if ($produit != "" && $exdecprod->charger($produit, $row->id)) {
continue;
}
$tdeclidispdesc = new Declidispdesc($row->id);
$temp = str_replace("#ID", $tdeclidispdesc->declidisp, $texte);
$temp = str_replace("#DECLINAISON", $row->declinaison, $temp);
$temp = str_replace("#TITRE", "{$tdeclidispdesc->titre}", $temp);
$temp = str_replace("#PRODUIT", "{$produit}", $temp);
$res .= $temp;
}
}
return $res;
}
function dupliquer($ref, $refn, $rubrique)
{
$test = new Produit();
if (!$test->charger($refn)) {
$produit = new Produit();
if ($produit->charger($ref)) {
$newproduit = new Produit();
$newproduit = $produit;
$newproduit->id = "";
$newproduit->ref = $refn;
$lastid = $newproduit->add();
$produit->charger($ref);
$lang = new Lang();
$query = "select * from {$lang->table}";
$result = mysql_query($query);
$nb = mysql_num_rows($result);
while ($row = mysql_fetch_object($result)) {
$produitdesc = new Produitdesc();
if ($produitdesc->charger($produit->id, $row->id)) {
$newproduitdesc = new Produitdesc();
$newproduitdesc = $produitdesc;
$newproduitdesc->id = "";
$newproduitdesc->produit = $lastid;
$newproduitdesc->add();
}
}
$caracval = new Caracval();
$query = "select * from {$caracval->table} where produit={$produit->id}";
$resul = mysql_query($query);
while ($row = mysql_fetch_object($resul)) {
$anciencarac = new Caracval();
$anciencarac->charger($row->produit, $row->caracteristique);
$newcarac = new Caracval();
$newcarac = $anciencarac;
$newcarac->id = "";
$newcarac->produit = $lastid;
$newcarac->add();
}
$exdecprod = new Exdecprod();
$query = "select * from {$exdecprod->table} where produit={$produit->id}";
$resul = mysql_query($query);
while ($row = mysql_fetch_object($resul)) {
$oldexdec = new Exdecprod();
$oldexdec->charger($row->produit, $row->declidisp);
$newexdec = new Exdecprod();
$newexdec = $oldexdec;
$newexdec->id = "";
$newexdec->produit = $lastid;
$newexdec->add();
}
$stock = new Stock();
$query = "select * from {$stock->table} where produit={$produit->id}";
$resul = mysql_query($query);
while ($row = mysql_fetch_object($resul)) {
$oldstock = new Stock();
$oldstock->charger($row->declidisp, $row->produit);
$newstock = new Stock();
$newstock = $oldstock;
$newstock->id = "";
$newstock->produit = $lastid;
$newstock->add();
}
?>
<script type="text/javascript">
alert("Duplication correcte");
location="produit_modifier.php?rubrique=<?php
echo $produit->rubrique;
?>
&ref=<?php
echo $refn;
?>
";
</script>
<?php
} else {
?>
<script type="text/javascript">
alert("Le produit n'existe pas");
</script>
<?php
}
}
}
echo trad('Surplus', 'admin');
?>
</th>
<th><?php
echo trad('Active', 'admin');
?>
</th>
</tr>
</thead>
<tbody>
<?php
while ($row2 = mysql_fetch_object($resul2)) {
$declidispdesc->charger_declidisp($row2->id);
$stock = new Stock();
$stock->charger($row2->id, $produit->id);
$exdecprod = new Exdecprod();
$res = $exdecprod->charger($produit->id, $row2->id);
?>
<tr>
<td><?php
echo $declidispdesc->titre;
?>
</td>
<td><input class="input-small" type="text" name="stock<?php
echo $row2->id;
?>
" value="<?php
echo $stock->valeur;
?>
" ></td>
<td><input class="input-small" type="text" name="surplus<?php
protected function checkStock($stock, $declinaison)
{
$this->stock = $stock;
$nb = 0;
foreach ($declinaison as $index => $value) {
$stock = new Stock();
if (!$stock->charger($index, $this->id)) {
$stock->declidisp = $index;
$stock->produit = $this->id;
$nb += $stock->valeur = $value["stock"];
$stock->surplus = $value["surplus"];
$stock->add();
} else {
$nb += $stock->valeur = $value["stock"];
$stock->surplus = $value["surplus"];
$stock->maj();
}
$exdecprod = new Exdecprod();
if ($value['exdecprod'] == '') {
if (!$exdecprod->charger($this->id, $index)) {
$exdecprod->produit = $this->id;
$exdecprod->declidisp = $index;
$exdecprod->id = $exdecprod->add();
}
} else {
if ($exdecprod->charger($this->id, $index)) {
$exdecprod->delete();
}
}
}
if ($nb > 0) {
$this->stock = $nb;
}
}
