125 lines
3.2 KiB
PHP
Executable File
125 lines
3.2 KiB
PHP
Executable File
<?php
|
|
require_once 'Framework/Modele.php';
|
|
class Tabmodepaiement extends Modele{
|
|
|
|
public function getlistermodepaiement(){
|
|
$sql = "SELECT a.*, a.codeSociete, b.libelle AS libtypefr, b.libelleEng AS libtypeeng
|
|
FROM modepaiement a
|
|
JOIN typepaiement b ON (b.codeTypePaiement = a.codeTypePaiement)
|
|
ORDER BY 1;";
|
|
|
|
$resultat = $this->executerRequete($sql);
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getTypePaiement(){
|
|
if (est_anglophone()){
|
|
$sql = "SELECT codeTypePaiement AS code, libelleEng AS libelle
|
|
FROM typepaiement;";
|
|
}else{
|
|
$sql = "SELECT codeTypePaiement AS code, libelle
|
|
FROM typepaiement;";
|
|
}
|
|
|
|
$resultat = $this->executerRequete($sql);
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function existeligne($codeModePaiement) {
|
|
$sql = 'select id FROM modepaiement WHERE (codeModePaiement=?)';
|
|
$resultat = $this->executerRequete($sql, array($codeModePaiement));
|
|
return ($resultat->rowCount() > 0);
|
|
}
|
|
|
|
|
|
public function ajoutermodepaiement($libelle,$libelleEng,$codeTypePaiement,$ordre){
|
|
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
/*$sql ='INSERT INTO modepaiement(codeSociete,codeModePaiement, libelle, libelleEng, codeTypePaiement, ordre)
|
|
VALUES (?,?,?,?,?,?);';*/
|
|
$sql =' CALL sp_ajouter_modepaiement (?,?,?,?,?);';
|
|
|
|
$this->executerRequete($sql, array($codeSociete,$libelle,$libelleEng,$codeTypePaiement,$ordre));
|
|
|
|
}
|
|
|
|
public function modifiermodepaiement($libelle,$libelleEng,$codeTypePaiement,$ordre,$id){
|
|
|
|
|
|
$sql = 'UPDATE modepaiement
|
|
SET libelle=?,libelleEng=?,codeTypePaiement=?,ordre=?
|
|
WHERE (id =?);';
|
|
|
|
$this->executerRequete($sql, array($libelle,$libelleEng,$codeTypePaiement,$ordre,$id));
|
|
}
|
|
|
|
///////////////////////////////////////////////////////
|
|
|
|
public function selectionnerune($id){
|
|
|
|
$sql = "UPDATE modepaiement
|
|
SET choix='1'
|
|
WHERE (id = ?);";
|
|
|
|
$this->executerRequete($sql, array($id));
|
|
}
|
|
|
|
public function deselectionnerune($id){
|
|
|
|
$sql = "UPDATE modepaiement
|
|
SET choix='0'
|
|
WHERE (id = ?);";
|
|
|
|
$this->executerRequete($sql, array($id));
|
|
}
|
|
|
|
public function selectionnertoutes(){
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = "UPDATE modepaiement
|
|
SET choix='1';";
|
|
|
|
$this->executerRequete($sql);
|
|
}
|
|
|
|
public function deselectionnertoutes(){
|
|
|
|
$sql = "UPDATE modepaiement
|
|
SET choix='0';";
|
|
|
|
$this->executerRequete($sql, array($codeSociete));
|
|
}
|
|
|
|
public function existeSelection() {
|
|
$sql = 'select id FROM modepaiement WHERE (choix="1")';
|
|
$resultat = $this->executerRequete($sql);
|
|
return ($resultat->rowCount() > 0);
|
|
}
|
|
|
|
public function getid($id){
|
|
$sql = "SELECT *
|
|
FROM modepaiement
|
|
WHERE (id = ?);";
|
|
|
|
$resultat = $this->executerRequete($sql, array($id));
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function supprimertoutes(){
|
|
|
|
$sql = 'DELETE
|
|
FROM modepaiement;';
|
|
|
|
$this->executerRequete($sql);
|
|
}
|
|
|
|
public function supprimerchoix(){
|
|
|
|
$sql = "DELETE
|
|
FROM modepaiement
|
|
WHERE (choix='1');";
|
|
|
|
$this->executerRequete($sql);
|
|
}
|
|
} |