169 lines
4.6 KiB
PHP
169 lines
4.6 KiB
PHP
<?php
|
|
if (!defined("LIBLISTEPRODUITS_INC")){
|
|
define(LIBLISTEPRODUITS_INC,1);
|
|
|
|
class ListeProduits{
|
|
var $_famille;
|
|
var $_prodIn;
|
|
var $_prodInInfo;
|
|
var $_prodFo;
|
|
var $_prodFoInfo;
|
|
|
|
function ListeProduits($famille){
|
|
$this->_prodIn=array();
|
|
$this->_prodInInfo=array();
|
|
$this->_prodFo=array();
|
|
$this->_prodFoInfo=array();
|
|
$this->_famille=$famille;
|
|
$this->chargeListeInterne();
|
|
$this->chargeListeFournisseur();
|
|
}
|
|
|
|
function supprimeProduitFournisseur($ids){
|
|
// on cherche les lignes selectionnees pour la suppression
|
|
if (count($ids)>0){
|
|
$connexion = @mysql_connect(SQL_SERVER,SQL_USER,SQL_PASSWD);
|
|
if ($connexion){
|
|
while( list($case,$val) = each($ids) ){
|
|
// on supprime les lignes selectionnees
|
|
$requete="DELETE FROM ProduitFour "
|
|
."WHERE reference_fournisseur='$val' ";
|
|
$resultat=mysql_db_query(SQL_BASE,$requete,$connexion);
|
|
if(!$resultat){
|
|
print mysql_error($connexion);
|
|
}
|
|
}
|
|
mysql_close($connexion);
|
|
} // connexion
|
|
} // count
|
|
$this->chargeListeFournisseur();
|
|
|
|
}
|
|
|
|
function ajouteProduitInterne($ref_in,$design,$unit){
|
|
$connexion = @mysql_connect(SQL_SERVER,SQL_USER,SQL_PASSWD);
|
|
if ($connexion){
|
|
$requete="INSERT INTO Produit_Interne "
|
|
."( reference_interne, designation, unite, "
|
|
."reference_fam )"
|
|
."VALUES ('$ref_in','$design','$unit','".$this->_famille."')";
|
|
$result=mysql_db_query(SQL_BASE,$requete,$connexion);
|
|
if (!$result){
|
|
print "<span class='bad'>\nErreur :";
|
|
print mysql_error($connexion);
|
|
print "\n</span>\n";
|
|
}
|
|
} else {
|
|
mysql_error($connexion);
|
|
}
|
|
mysql_close($connexion);
|
|
$this->chargeListeInterne();
|
|
}
|
|
|
|
function ajouteProduitFournisseur(
|
|
$fourn,
|
|
$design,
|
|
$prix,
|
|
$unit,
|
|
$ref_out,
|
|
$ref_in){
|
|
$connexion = @mysql_connect(SQL_SERVER,SQL_USER,SQL_PASSWD);
|
|
if ($connexion){
|
|
$requete="INSERT INTO ProduitFour "
|
|
."( reference_fournisseur, designation, prix, "
|
|
."unite,id_fournisseur,reference_interne )"
|
|
."VALUES ('$ref_out','$design','$prix','$unit',"
|
|
."'$fourn','$ref_in')";
|
|
$result=mysql_db_query(SQL_BASE,$requete,$connexion);
|
|
if (!$result){
|
|
print "<span class='bad'>\nErreur :";
|
|
print mysql_error($connexion);
|
|
print "\n</span>\n";
|
|
}
|
|
} else {
|
|
mysql_error($connexion);
|
|
}
|
|
mysql_close($connexion);
|
|
$this->chargeListeFournisseur();
|
|
}
|
|
|
|
function listeFournisseurToHTML(){
|
|
$content="";
|
|
for ($i=0;$i<count($this->_prodFo);$i++){
|
|
$content.="<p class=\"ligne".($i%2)."\" >";
|
|
$content.=$this->_prodFo[$i]->toHTML(1);
|
|
$content.="</p>";
|
|
}
|
|
return $content;
|
|
|
|
}
|
|
|
|
function referencesHTML(){
|
|
$content="";
|
|
$content.="<select id=\"prod_refin_old\" name=\"prod_refin_old\">";
|
|
for ($i=0;$i<count($this->_prodIn);$i++){
|
|
$content.="<option value='".$this->_prodIn[$i]."'>"
|
|
.$this->_prodIn[$i]." - ".$this->_prodInInfo[$i]
|
|
."</option>";
|
|
}
|
|
$content.="</select>";
|
|
return $content;
|
|
}
|
|
|
|
function chargeListeFournisseur(){
|
|
$connexion=@mysql_connect(SQL_SERVER,SQL_USER,SQL_PASSWD);
|
|
if ($connexion){
|
|
$requete="SELECT reference_fournisseur,designation,"
|
|
."prix,unite,A.id_fournisseur,reference_interne "
|
|
."FROM ProduitFour AS A, Fournisseur AS B "
|
|
."WHERE A.id_fournisseur=B.id_fournisseur "
|
|
."AND reference_fam='".$this->_famille."'";
|
|
$resultat=mysql_db_query(SQL_BASE,$requete,$connexion);
|
|
if ($resultat){
|
|
$this->_prodFo=array();
|
|
$this->_prodFoInfo=array();
|
|
while($row=mysql_fetch_object($resultat)){
|
|
//TODO:
|
|
$produit=new ProduitFournisseur(
|
|
$row->reference_fournisseur,
|
|
$row->designation,
|
|
$row->prix,
|
|
$row->unite,
|
|
$row->id_fournisseur,
|
|
$row->reference_interne
|
|
);
|
|
array_push($this->_prodFo,$produit);
|
|
}
|
|
}
|
|
mysql_close($connexion);
|
|
} else {
|
|
print mysql_error($connexion);
|
|
} // connexion
|
|
|
|
}
|
|
|
|
function chargeListeInterne(){
|
|
$connexion=@mysql_connect(SQL_SERVER,SQL_USER,SQL_PASSWD);
|
|
if ($connexion){
|
|
$requete="SELECT reference_interne,designation "
|
|
."FROM Produit_Interne "
|
|
."WHERE reference_fam='".$this->_famille."' "
|
|
."GROUP BY reference_interne";
|
|
$resultat=mysql_db_query(SQL_BASE,$requete,$connexion);
|
|
if ($resultat){
|
|
$this->_prodIn=array();
|
|
$this->_prodInInfo=array();
|
|
while($row=mysql_fetch_object($resultat)){
|
|
array_push($this->_prodIn,$row->reference_interne);
|
|
array_push($this->_prodInInfo,$row->designation);
|
|
}
|
|
}
|
|
mysql_close($connexion);
|
|
} else {
|
|
print mysql_error($connexion);
|
|
} // connexion
|
|
} //function
|
|
} // class
|
|
} // define
|
|
?>
|