Opération non effectuée! Vérifier les informations introduites. '; /*$reqq='SELECT idPaiement FROM tabpaiement WHERE idTypeFrais="'.$Lett->getIdTypeFrais().'" AND nomEtudiant="'.$Lett->getNomEtudiant().'" AND promotion="'.$Lett->getPromotion().'" AND sectionoption="'.$Lett->getSectionoption().'" AND devise="'.$Lett->getDevise().'" AND annee="'.$Lett->getAnnee().'" AND validite="OUI"'; $reqqprepar=$this->pdo->prepare($reqq); $reqqprepar->execute(); $p = 0; while($a = $reqqprepar->fetch()){ $p = $a['idPaiement']; }*/ $queryx = 'SELECT nomPoint AS intitule, commission FROM tabetablissementpoint, tabpointexploitation WHERE tabetablissementpoint.idPoint=tabpointexploitation.idPoint AND idEtablissementPoint="'.$Lett->getIdEtablissementPoint().'" AND tabpointexploitation.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx = $this->pdo->prepare($queryx); $qx->execute(); $commission=""; while ($ax = $qx->fetch()) { $commission = mb_strtoupper($ax['commission']); } $reqq='SELECT tabtaux.valcdf AS tauxcdf FROM tabtaux WHERE validite="OUI"'; $reqqprepar=$this->pdo->prepare($reqq); $reqqprepar->execute(); while($a = $reqqprepar->fetch()){ $tauxcdf = $a['tauxcdf']; } if($Lett->getDevise()=="USD"){ $montPayCom = (($Lett->getMontantPaye())*$commission)/100; $tvaMontPayCom = ($montPayCom*16)/100; if($montPayCom < 1){ $montPayCom=1; $tvaMontPayCom=0.16; } $montPayComTVA = $montPayCom + $tvaMontPayCom; } elseif($Lett->getDevise()=="CDF"){ $montPayCom = (($Lett->getMontantPaye())*$commission)/100; $tvaMontPayCom = ($montPayCom*16)/100; if($montPayCom < $tauxcdf){ $montPayCom=$tauxcdf; $tvaMontPayCom=($tauxcdf*16)/100; } $montPayComTVA = $montPayCom + $tvaMontPayCom; } $reqq='SELECT codeEtablissement FROM tabetablissement WHERE idEtablissement IN (SELECT distinct(idEtablissement) FROM tabetablissementpoint WHERE idEtablissementPoint="'.$Lett->getIdEtablissementPoint().'" AND validite="OUI") AND validite="OUI"'; $reqqprepar=$this->pdo->prepare($reqq); $reqqprepar->execute(); $codeEtab=0; $codePaiement=0; while($a = $reqqprepar->fetch()){ $codeEtab = $a['codeEtablissement']; $codePaiement = $codeEtab.rand(100000,999999).date('d').date('m').date('y'); } $repx="OK"; while($repx=="OK"){ $reqq='SELECT idPaiement FROM tabpaiement WHERE codepaiement="'.$codePaiement.'" AND validite="OUI"'; $reqqprepar=$this->pdo->prepare($reqq); $reqqprepar->execute(); $v=0; while($a = $reqqprepar->fetch()){ $v = $a['idPaiement']; $codePaiement = $codeEtab.rand(100000,999999).date('d').date('m').date('y'); } if($v==0){$repx="NOK";} } $_SESSION['redirect']=""; if($_GET['source']=="indexCE"){ $reqq='SELECT SUM(montantUSD) AS declareUSD, SUM(montantCDF) AS declareCDF FROM tabdeclaration WHERE idUser="'.$_GET['idUser'].'" AND idEtablissementPoint="'.$Lett->getIdEtablissementPoint().'" AND validite="OUI"'; $reqqprepar=$this->pdo->prepare($reqq); $reqqprepar->execute(); $declareUSD=0; $declareCDF=0; while($a = $reqqprepar->fetch()){ $declareUSD = $declareUSD + $a['declareUSD']; $declareCDF = $declareCDF + $a['declareCDF']; } $reqq='SELECT SUM(montantPaye) AS totalMontantPayeUSD FROM tabpaiement WHERE devise="USD" AND idUser="'.$_GET['idUser'].'" AND idEtablissementPoint="'.$Lett->getIdEtablissementPoint().'" AND validite="OUI"'; $reqqprepar=$this->pdo->prepare($reqq); $reqqprepar->execute(); $totalMontantPayeUSD=0; while($a = $reqqprepar->fetch()){ $totalMontantPayeUSD = $a['totalMontantPayeUSD']; } $reqq='SELECT SUM(montantPaye) AS totalMontantPayeCDF FROM tabpaiement WHERE devise="CDF" AND idUser="'.$_GET['idUser'].'" AND idEtablissementPoint="'.$Lett->getIdEtablissementPoint().'" AND validite="OUI"'; $reqqprepar=$this->pdo->prepare($reqq); $reqqprepar->execute(); $totalMontantPayeCDF=0; while($a = $reqqprepar->fetch()){ $totalMontantPayeCDF = $a['totalMontantPayeCDF']; } $maconfirm=""; if($Lett->getDevise() == "USD"){ if(($totalMontantPayeUSD + $Lett->getMontantPaye() - $declareUSD)>$_GET['plafondUSD']) { $maconfirm="OK"; } $_SESSION['messa'] = ' Opération non effectuée! Dépassement du plafond des opérations. '; } elseif($Lett->getDevise() == "CDF"){ if(($totalMontantPayeCDF + $Lett->getMontantPaye() - $declareCDF)>$_GET['plafondCDF']) { $maconfirm="OK"; } $_SESSION['messa'] = ' Opération non effectuée! Dépassement du plafond des opérations. '; } if($maconfirm==""){ $req='INSERT INTO tabpaiement SET codeClient="'.$Lett->getCodeClient().'", titre="'.$Lett->getTitre().'", nom="'.$Lett->getNom().'", postnom="'.$Lett->getPostnom().'", prenom="'.$Lett->getPrenom().'", typePID="'.$Lett->getTypePiece().'", numPID="'.$Lett->getNumPID().'", dateExpiration="'.$Lett->getDateExpiration().'", telephone="'.$Lett->getTelephone().'", dateNaissance="'.$Lett->getDateNaissance().'", observation="'.$Lett->getObservation().'", tva="'.$tvaMontPayCom.'", mtpcommis="'.$montPayCom.'", mtpcommistva="'.$montPayComTVA.'", lettre="'.$Lett->getLettre().'", autreDetail="'.$Lett->getAutreDetail().'", typePaiement="'.$Lett->getTypePaiement().'", numeroOperation="'.$Lett->getNumeroOperation().'", matricule="'.$Lett->getMatricule().'", idEtablissementPoint="'.$Lett->getIdEtablissementPoint().'", idUser="'.$_GET['idUser'].'", idPointService="'.$_GET['idPointService'].'", idTypeFrais="'.$Lett->getIdTypeFrais().'", codePaiement="'.$codePaiement.'", nomDeposant="'.$Lett->getNomDeposant().'", nomEtudiant="'.$Lett->getNomEtudiant().'", promotion="'.$Lett->getPromotion().'", sectionoption="'.$Lett->getSectionoption().'", montantPaye="'.$Lett->getMontantPaye().'", devise="'.$Lett->getDevise().'", datePaiement=now(), dateHeurePaiement=now(), annee="'.$Lett->getAnnee().'", validite="OUI"'; $reqprepar=$this->pdo->prepare($req); $reqprepar->execute(); $_SESSION['codePaiement']=$codePaiement; $_SESSION['printBorde']="OK"; $_SESSION['messa'] = ' Opération terminée avec succès! '; } else{ $_SESSION['redirect']="OK"; } } else{ $_SESSION['codeInfraction']=$codePaiement; //if($p = 0){ echo $req='INSERT INTO tabpaiement SET opsEpargnes="'.$Lett->getOpsEpargnes().'", codeClient="'.$Lett->getCodeClient().'", titre="'.$Lett->getTitre().'", nom="'.$Lett->getNom().'", postnom="'.$Lett->getPostnom().'", prenom="'.$Lett->getPrenom().'", typePID="'.$Lett->getTypePiece().'", numPID="'.$Lett->getNumPID().'", dateExpiration="'.$Lett->getDateExpiration().'", telephone="'.$Lett->getTelephone().'", dateNaissance="'.$Lett->getDateNaissance().'", observation="'.$Lett->getObservation().'", tva="'.$tvaMontPayCom.'", mtpcommis="'.$montPayCom.'", mtpcommistva="'.$montPayComTVA.'", lettre="'.$Lett->getLettre().'", autreDetail="'.$Lett->getAutreDetail().'", typePaiement="'.$Lett->getTypePaiement().'", numeroOperation="'.$Lett->getNumeroOperation().'", matricule="'.$Lett->getMatricule().'", idEtablissementPoint="'.$Lett->getIdEtablissementPoint().'", idUser="'.$_GET['idUser'].'", idPointService="'.$_GET['idPointService'].'", idTypeFrais="'.$Lett->getIdTypeFrais().'", codePaiement="'.$codePaiement.'", nomDeposant="'.$Lett->getNomDeposant().'", nomEtudiant="'.$Lett->getNomEtudiant().'", promotion="'.$Lett->getPromotion().'", sectionoption="'.$Lett->getSectionoption().'", montantPaye="'.$Lett->getMontantPaye().'", devise="'.$Lett->getDevise().'", datePaiement=now(), dateHeurePaiement=now(), annee="'.$Lett->getAnnee().'", validite="OUI"'; die;$reqprepar=$this->pdo->prepare($req); $reqprepar->execute(); $_SESSION['codePaiement']=$codePaiement; $_SESSION['printBorde']="OK"; $_SESSION['messa'] = ' Opération terminée avec succès! '; //} } } public function insererPaiementCLI(Paiement $Lett){ $_SESSION['messa'] = ' Opération non effectuée! Vérifier les informations introduites. '; /*$queryx = 'SELECT nomPoint AS intitule, commission FROM tabetablissementpoint, tabpointexploitation WHERE tabetablissementpoint.idPoint=tabpointexploitation.idPoint AND idEtablissementPoint="'.$Lett->getIdEtablissementPoint().'" AND tabpointexploitation.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx = $this->pdo->prepare($queryx); $qx->execute(); $commission=""; while ($ax = $qx->fetch()) { $commission = mb_strtoupper($ax['commission']); } $reqq='SELECT tabtaux.valcdf AS tauxcdf FROM tabtaux WHERE validite="OUI"'; $reqqprepar=$this->pdo->prepare($reqq); $reqqprepar->execute(); while($a = $reqqprepar->fetch()){ $tauxcdf = $a['tauxcdf']; } if($Lett->getDevise()=="USD"){ $montPayCom = (($Lett->getMontantPaye())*$commission)/100; $tvaMontPayCom = ($montPayCom*16)/100; if($montPayCom < 1){ $montPayCom=1; $tvaMontPayCom=0.16; } $montPayComTVA = $montPayCom + $tvaMontPayCom; } elseif($Lett->getDevise()=="CDF"){ $montPayCom = (($Lett->getMontantPaye())*$commission)/100; $tvaMontPayCom = ($montPayCom*16)/100; if($montPayCom < $tauxcdf){ $montPayCom=$tauxcdf; $tvaMontPayCom=($tauxcdf*16)/100; } $montPayComTVA = $montPayCom + $tvaMontPayCom; } $reqq='SELECT codeEtablissement FROM tabetablissement WHERE idEtablissement IN (SELECT distinct(idEtablissement) FROM tabetablissementpoint WHERE idEtablissementPoint="'.$Lett->getIdEtablissementPoint().'" AND validite="OUI") AND validite="OUI"'; $reqqprepar=$this->pdo->prepare($reqq); $reqqprepar->execute(); $codeEtab=0; $codePaiement=0; while($a = $reqqprepar->fetch()){ $codeEtab = $a['codeEtablissement']; $codePaiement = $codeEtab.rand(100000,999999).date('d').date('m').date('y'); } $repx="OK"; while($repx=="OK"){ $reqq='SELECT idPaiement FROM tabpaiement WHERE codepaiement="'.$codePaiement.'" AND validite="OUI"'; $reqqprepar=$this->pdo->prepare($reqq); $reqqprepar->execute(); $v=0; while($a = $reqqprepar->fetch()){ $v = $a['idPaiement']; $codePaiement = $codeEtab.rand(100000,999999).date('d').date('m').date('y'); } if($v==0){$repx="NOK";} } $_SESSION['redirect']=""; if($_GET['source']=="indexCE"){ $reqq='SELECT SUM(montantUSD) AS declareUSD, SUM(montantCDF) AS declareCDF FROM tabdeclaration WHERE idUser="'.$_GET['idUser'].'" AND idEtablissementPoint="'.$Lett->getIdEtablissementPoint().'" AND validite="OUI"'; $reqqprepar=$this->pdo->prepare($reqq); $reqqprepar->execute(); $declareUSD=0; $declareCDF=0; while($a = $reqqprepar->fetch()){ $declareUSD = $declareUSD + $a['declareUSD']; $declareCDF = $declareCDF + $a['declareCDF']; } $reqq='SELECT SUM(montantPaye) AS totalMontantPayeUSD FROM tabpaiement WHERE devise="USD" AND idUser="'.$_GET['idUser'].'" AND idEtablissementPoint="'.$Lett->getIdEtablissementPoint().'" AND validite="OUI"'; $reqqprepar=$this->pdo->prepare($reqq); $reqqprepar->execute(); $totalMontantPayeUSD=0; while($a = $reqqprepar->fetch()){ $totalMontantPayeUSD = $a['totalMontantPayeUSD']; } $reqq='SELECT SUM(montantPaye) AS totalMontantPayeCDF FROM tabpaiement WHERE devise="CDF" AND idUser="'.$_GET['idUser'].'" AND idEtablissementPoint="'.$Lett->getIdEtablissementPoint().'" AND validite="OUI"'; $reqqprepar=$this->pdo->prepare($reqq); $reqqprepar->execute(); $totalMontantPayeCDF=0; while($a = $reqqprepar->fetch()){ $totalMontantPayeCDF = $a['totalMontantPayeCDF']; } $maconfirm=""; if($Lett->getDevise() == "USD"){ if(($totalMontantPayeUSD + $Lett->getMontantPaye() - $declareUSD)>$_GET['plafondUSD']) { $maconfirm="OK"; } $_SESSION['messa'] = ' Opération non effectuée! Dépassement du plafond des opérations. '; } elseif($Lett->getDevise() == "CDF"){ if(($totalMontantPayeCDF + $Lett->getMontantPaye() - $declareCDF)>$_GET['plafondCDF']) { $maconfirm="OK"; } $_SESSION['messa'] = ' Opération non effectuée! Dépassement du plafond des opérations. '; } if($maconfirm==""){ $req='INSERT INTO tabpaiement SET tva="'.$tvaMontPayCom.'", mtpcommis="'.$montPayCom.'", mtpcommistva="'.$montPayComTVA.'", lettre="'.$Lett->getLettre().'", autreDetail="'.$Lett->getAutreDetail().'", typePaiement="'.$Lett->getTypePaiement().'", numeroOperation="'.$Lett->getNumeroOperation().'", matricule="'.$Lett->getMatricule().'", idEtablissementPoint="'.$Lett->getIdEtablissementPoint().'", idUser="'.$_GET['idUser'].'", idPointService="'.$_GET['idPointService'].'", idTypeFrais="'.$Lett->getIdTypeFrais().'", codePaiement="'.$codePaiement.'", nomDeposant="'.$Lett->getNomDeposant().'", nomEtudiant="'.$Lett->getNomEtudiant().'", promotion="'.$Lett->getPromotion().'", sectionoption="'.$Lett->getSectionoption().'", montantPaye="'.$Lett->getMontantPaye().'", devise="'.$Lett->getDevise().'", datePaiement=now(), dateHeurePaiement=now(), annee="'.$Lett->getAnnee().'", validite="OUI"'; $reqprepar=$this->pdo->prepare($req); $reqprepar->execute(); $_SESSION['codePaiement']=$codePaiement; $_SESSION['printBorde']="OK"; $_SESSION['messa'] = ' Opération terminée avec succès! '; } else{ $_SESSION['redirect']="OK"; } } else{*/ //if($p = 0){ //$req='INSERT INTO tabgenerationbon SET tva="'.$tvaMontPayCom.'", mtpcommis="'.$montPayCom.'", mtpcommistva="'.$montPayComTVA.'", lettre="'.$Lett->getLettre().'", autreDetail="'.$Lett->getAutreDetail().'", typePaiement="'.$Lett->getTypePaiement().'", numeroOperation="'.$Lett->getNumeroOperation().'", matricule="'.$Lett->getMatricule().'", idEtablissementPoint="'.$Lett->getIdEtablissementPoint().'", idUser="'.$_GET['idUser'].'", idPointService="'.$_GET['idPointService'].'", idTypeFrais="'.$Lett->getIdTypeFrais().'", codePaiement="'.$codePaiement.'", nomDeposant="'.$Lett->getNomDeposant().'", nomEtudiant="'.$Lett->getNomEtudiant().'", promotion="'.$Lett->getPromotion().'", sectionoption="'.$Lett->getSectionoption().'", montantPaye="'.$Lett->getMontantPaye().'", devise="'.$Lett->getDevise().'", datePaiement=now(), dateHeurePaiement=now(), annee="'.$Lett->getAnnee().'", validite="OUI"'; $req='INSERT INTO tabgenerationbon SET lettre="'.$Lett->getLettre().'", autreDetail="'.$Lett->getAutreDetail().'", typePaiement="'.$Lett->getTypePaiement().'", numeroOperation="'.$Lett->getNumeroOperation().'", matricule="'.$Lett->getMatricule().'", idEtablissementPoint="'.$Lett->getIdEtablissementPoint().'", idUser="'.$_GET['idUser'].'", idPointService="'.$_GET['idPointService'].'", idTypeFrais="'.$Lett->getIdTypeFrais().'", codePaiement="'.$codePaiement.'", nomDeposant="'.$Lett->getNomDeposant().'", nomEtudiant="'.$Lett->getNomEtudiant().'", promotion="'.$Lett->getPromotion().'", sectionoption="'.$Lett->getSectionoption().'", montantPaye="'.$Lett->getMontantPaye().'", devise="'.$Lett->getDevise().'", datePaiement=now(), dateHeurePaiement=now(), annee="'.$Lett->getAnnee().'", validite="OUI"'; $reqprepar=$this->pdo->prepare($req); $reqprepar->execute(); //$_SESSION['codePaiement']=$codePaiement; $_SESSION['printBorde']="OK"; $_SESSION['messa'] = ' Opération terminée avec succès! '; //} //} } public function modifierPoste(Poste $Lett){ $_SESSION['messa'] = ' Opération non effectuée! Aucune modification n\'a été apportée. '; $reqq='SELECT idPoste FROM postes WHERE intitule="'.$Lett->getIntitule().'" AND sbm="'.$Lett->getSbm().'" AND validite="OUI"'; $reqqprepar=$this->pdo->prepare($reqq); $reqqprepar->execute(); $p=0; while($a = $reqqprepar->fetch()){ $p = $a['idPoste']; } if($p == 0){ $req='UPDATE postes SET intitule="'.$Lett->getIntitule().'", sbm="'.$Lett->getSbm().'" WHERE idPoste="'.$_GET['idPoste'].'"'; $reqprepar=$this->pdo->prepare($req); $reqprepar->execute(); $_SESSION['messa'] = ' Modification effectuée avec succès! '; } } public function supprimerPoste(Poste $Lett){ $req='UPDATE postes SET validite="NON" WHERE idPoste="'.$_GET['idPoste'].'"'; $reqprepar=$this->pdo->prepare($req); $reqprepar->execute(); $_SESSION['messa'] = ' Suppression effectuée avec succès! '; } public function annulerPaiement(Paiement $Lett){ $req='UPDATE tabpaiement SET validite="NON", nomCPAnnulation="'.$_GET['nomCPAnnulation'].'", raisonAnnulation="'.$Lett->getRaisonAnnulation().'" WHERE idPaiement="'.$_GET['idPaiement'].'"'; $reqprepar=$this->pdo->prepare($req); $reqprepar->execute(); $_SESSION['messa'] = ' Annulation effectuée avec succès! '; } public function exonererPaiement(Paiement $Lett){ $req='UPDATE tabpaiement SET nomCPExoneration="'.$_GET['nomCPAnnulation'].'", dateExoneration=now(), raisonExoneration="'.$Lett->getRaisonAnnulation().'" WHERE idPaiement="'.$_GET['idPaiement'].'"'; $reqprepar=$this->pdo->prepare($req); $reqprepar->execute(); $_SESSION['messa'] = ' Opération effectuée avec succès! '; } public function getListPointService(){ $query = 'SELECT idPointService, intitule FROM tabpointservice WHERE validite="OUI" ORDER BY idPointService'; $q = $this->pdo->prepare($query); $q->execute(); while ($a = $q->fetch()) { echo ''; } } } $ddao = new Connect("umxyjxrz_bdifodacademia"); $_GET['maBD'] = $ddao->myDB("umxyjxrz_bdifodacademia"); $_SESSION['maBD'] = $_GET['maBD']; $dao=new DaoPaiement($_GET['maBD']); $db = new Connect($_SESSION['maBD']); $dc = $db->connect_db($_SESSION['maBD']); if(isset($_POST['btnInsertPaiement'])){ $queryx = 'SELECT montant, devise, payerTotal FROM tabtypefrais WHERE idTypeFrais="'.$_POST['idTypeFrais'].'" AND validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $montant=""; $devise=""; $payerTotal=""; while ($ax = $qx->fetch()) { $montant = $ax['montant']; $devise = $ax['devise']; $payerTotal = $ax['payerTotal']; } if($payerTotal=="NON"){ $tabSer1=new Paiement(array ('codeClient'=>trim($_POST['codeClient']), 'titre'=>trim($_POST['titre']), 'nom'=>trim($_POST['nom']), 'postnom'=>trim($_POST['postnom']), 'prenom'=>trim($_POST['prenom']), 'typePiece'=>trim($_POST['typePiece']), 'numPID'=>trim($_POST['numPID']), 'dateExpiration'=>trim($_POST['dateExpiration']), 'telephone'=>trim($_POST['telephone']), 'dateNaissance'=>trim($_POST['dateNaissance']), 'observation'=>trim($_POST['observation']), 'categorie'=>trim($_POST['categorie']), 'numeroOperation'=>trim($_POST['numeroOperation']), 'lettre'=>trim($_POST['lettre']), 'autreDetail'=>trim($_POST['autreDetail']), 'typePaiement'=>trim($_POST['typePaiement']), 'matricule'=>trim($_POST['matricule']), 'idEtablissementPoint'=>trim($_POST['idEtablissementPoint']), 'idTypeFrais'=>trim($_POST['idTypeFrais']), 'nomDeposant'=>trim($_POST['nomDeposant']), 'nomEtudiant'=>trim($_POST['nomEtudiant']), 'promotion'=>trim($_POST['promotion']), 'sectionoption'=>trim($_POST['sectionoption']), 'montantPaye'=>trim($_POST['montantPaye']), 'devise'=>trim($_POST['devise']), 'annee'=>trim($_POST['annee']))); $dao->insererPaiement($tabSer1); $queryx = 'SELECT typeEtablissement, acronyme FROM tabetablissement, tabetablissementpoint WHERE tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND idEtablissementPoint="'.$_GET['idEtablissementPoint'].'" AND tabetablissement.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $typeEtablissement=""; while ($ax = $qx->fetch()) { $typeEtablissement = $ax['typeEtablissement']; $acronyme = mb_strtoupper($ax['acronyme']); } $queryx = 'SELECT nomPoint FROM tabpointexploitation, tabetablissementpoint WHERE tabpointexploitation.idPoint=tabetablissementpoint.idPoint AND idEtablissementPoint="'.$_GET['idEtablissementPoint'].'" AND tabpointexploitation.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $pointExploi=""; while ($ax = $qx->fetch()) { $pointExploi = " ".$ax['nomPoint']; } $agence=""; $etablissement=""; $queryx = 'SELECT intitule FROM tabpointservice WHERE idPointService="'.$_SESSION['idPointService'].'" AND validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); while ($a = $qx->fetch()) { $agence = $a['intitule']; } $queryx = 'SELECT nomEtablissement FROM useretablissementpoint, tabetablissementpoint, tabetablissement, `user` WHERE `user`.idUser="'.$_SESSION['idUser'].'" AND `user`.idUser NOT IN (SELECT idUser FROM userpointservice WHERE validite="OUI") AND `user`.`idUser`=useretablissementpoint.idUser AND useretablissementpoint.idEtablissementPoint=tabetablissementpoint.idEtablissementPoint AND tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND useretablissementpoint.validite="OUI" AND tabetablissementpoint.validite="OUI" AND tabetablissement.validite="OUI" AND `user`.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); while ($a = $qx->fetch()) { $etablissement = $a['nomEtablissement']; } $queryx = 'INSERT INTO tabpisteaudit SET module="Nouveau paiement", typeAction="Ajout", idUser="'.$_SESSION['idUser'].'", login="'.$_SESSION['userName'].'", agence="'.$agence.'", etablissement="'.$etablissement.'", dateOperation="'.date('Y-m-d').'", dateServeur=now(), description="Paiement réussi. Code paiement ou numéro bordereau '.$_SESSION['codePaiement'].', montant : '.$_POST['montantPaye'].', devise : '.$_POST['devise'].'", validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); //header('Location: ../metronic/preview/demo3/index.php?printBorde='.$_SESSION['printBorde'].'&codePaiement='.$_SESSION['codePaiement'].''); if($_SESSION['redirect']=="OK"){ header('Location: ../metronic/preview/demo3/indexCE.php?printBorde='.$_SESSION['printBorde'].'&codePaiement='.$_SESSION['codePaiement'].''); } else{ header('Location: ../RapportPDF/bordereau.php?codePaiement='.$_SESSION['codePaiement'].''); } } else{ if($montant==trim($_POST['montantPaye']) && $devise==trim($_POST['devise'])){ $tabSer1=new Paiement(array ('categorie'=>trim($_POST['categorie']), 'numeroOperation'=>trim($_POST['numeroOperation']), 'lettre'=>trim($_POST['lettre']), 'autreDetail'=>trim($_POST['autreDetail']), 'typePaiement'=>trim($_POST['typePaiement']), 'matricule'=>trim($_POST['matricule']), 'idEtablissementPoint'=>trim($_POST['idEtablissementPoint']), 'idTypeFrais'=>trim($_POST['idTypeFrais']), 'nomDeposant'=>trim($_POST['nomDeposant']), 'nomEtudiant'=>trim($_POST['nomEtudiant']), 'promotion'=>trim($_POST['promotion']), 'sectionoption'=>trim($_POST['sectionoption']), 'montantPaye'=>trim($_POST['montantPaye']), 'devise'=>trim($_POST['devise']), 'annee'=>trim($_POST['annee']))); $dao->insererPaiement($tabSer1); $queryx = 'SELECT typeEtablissement, acronyme FROM tabetablissement, tabetablissementpoint WHERE tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND idEtablissementPoint="'.$_GET['idEtablissementPoint'].'" AND tabetablissement.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $typeEtablissement=""; while ($ax = $qx->fetch()) { $typeEtablissement = $ax['typeEtablissement']; $acronyme = mb_strtoupper($ax['acronyme']); } $queryx = 'SELECT nomPoint FROM tabpointexploitation, tabetablissementpoint WHERE tabpointexploitation.idPoint=tabetablissementpoint.idPoint AND idEtablissementPoint="'.$_GET['idEtablissementPoint'].'" AND tabpointexploitation.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $pointExploi=""; while ($ax = $qx->fetch()) { $pointExploi = " ".$ax['nomPoint']; } $agence=""; $etablissement=""; $queryx = 'SELECT intitule FROM tabpointservice WHERE idPointService="'.$_SESSION['idPointService'].'" AND validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); while ($a = $qx->fetch()) { $agence = $a['intitule']; } $queryx = 'SELECT nomEtablissement FROM useretablissementpoint, tabetablissementpoint, tabetablissement, `user` WHERE `user`.idUser="'.$_SESSION['idUser'].'" AND `user`.idUser NOT IN (SELECT idUser FROM userpointservice WHERE validite="OUI") AND `user`.`idUser`=useretablissementpoint.idUser AND useretablissementpoint.idEtablissementPoint=tabetablissementpoint.idEtablissementPoint AND tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND useretablissementpoint.validite="OUI" AND tabetablissementpoint.validite="OUI" AND tabetablissement.validite="OUI" AND `user`.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); while ($a = $qx->fetch()) { $etablissement = $a['nomEtablissement']; } $queryx = 'INSERT INTO tabpisteaudit SET module="Nouveau paiement", typeAction="Ajout", idUser="'.$_SESSION['idUser'].'", login="'.$_SESSION['userName'].'", agence="'.$agence.'", etablissement="'.$etablissement.'", dateOperation="'.date('Y-m-d').'", dateServeur=now(), description="Paiement réussi. Code paiement ou numéro bordereau '.$_SESSION['codePaiement'].', montant : '.$_POST['montantPaye'].', devise : '.$_POST['devise'].'", validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); //header('Location: ../metronic/preview/demo3/index.php?printBorde='.$_SESSION['printBorde'].'&codePaiement='.$_SESSION['codePaiement'].''); if($_SESSION['redirect']=="OK"){ header('Location: ../metronic/preview/demo3/indexCE.php?printBorde='.$_SESSION['printBorde'].'&codePaiement='.$_SESSION['codePaiement'].''); } else{ header('Location: ../RapportPDF/bordereau.php?codePaiement='.$_SESSION['codePaiement'].''); } } else{ $_SESSION['messa'] = ' Opération non effectuée! Le montant ou la devise saisi ne correspond pas au montant du type de frais sélectionné. '; header('Location: ../metronic/preview/demo3/index.php?acronyme='.$_GET['acronyme'].'&typeEtablissement='.$_GET['typeEtablissement'].'&idEtablissementPoint='.$_GET['idEtablissementPoint'].''); } } } elseif(isset($_POST['btnInsertPaiementCLI'])){ $queryx = 'SELECT montant, devise, payerTotal FROM tabtypefrais WHERE idTypeFrais="'.$_POST['idTypeFrais'].'" AND validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $montant=""; $devise=""; $payerTotal=""; while ($ax = $qx->fetch()) { $montant = $ax['montant']; $devise = $ax['devise']; $payerTotal = $ax['payerTotal']; } if($payerTotal=="NON"){ $tabSer1=new Paiement(array ('categorie'=>trim($_POST['categorie']), 'numeroOperation'=>trim($_POST['numeroOperation']), 'lettre'=>trim($_POST['lettre']), 'autreDetail'=>trim($_POST['autreDetail']), 'typePaiement'=>trim($_POST['typePaiement']), 'matricule'=>trim($_POST['matricule']), 'idEtablissementPoint'=>trim($_POST['idEtablissementPoint']), 'idTypeFrais'=>trim($_POST['idTypeFrais']), 'nomDeposant'=>trim($_POST['nomDeposant']), 'nomEtudiant'=>trim($_POST['nomEtudiant']), 'promotion'=>trim($_POST['promotion']), 'sectionoption'=>trim($_POST['sectionoption']), 'montantPaye'=>trim($_POST['montantPaye']), 'devise'=>trim($_POST['devise']), 'annee'=>trim($_POST['annee']))); $dao->insererPaiementCLI($tabSer1); $queryx = 'SELECT typeEtablissement, acronyme FROM tabetablissement, tabetablissementpoint WHERE tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND idEtablissementPoint="'.$_GET['idEtablissementPoint'].'" AND tabetablissement.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $typeEtablissement=""; while ($ax = $qx->fetch()) { $typeEtablissement = $ax['typeEtablissement']; $acronyme = mb_strtoupper($ax['acronyme']); } $queryx = 'SELECT nomPoint FROM tabpointexploitation, tabetablissementpoint WHERE tabpointexploitation.idPoint=tabetablissementpoint.idPoint AND idEtablissementPoint="'.$_GET['idEtablissementPoint'].'" AND tabpointexploitation.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $pointExploi=""; while ($ax = $qx->fetch()) { $pointExploi = " ".$ax['nomPoint']; } $agence=""; $etablissement=""; $queryx = 'SELECT intitule FROM tabpointservice WHERE idPointService="'.$_SESSION['idPointService'].'" AND validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); while ($a = $qx->fetch()) { $agence = $a['intitule']; } $queryx = 'SELECT nomEtablissement FROM useretablissementpoint, tabetablissementpoint, tabetablissement, `user` WHERE `user`.idUser="'.$_SESSION['idUser'].'" AND `user`.idUser NOT IN (SELECT idUser FROM userpointservice WHERE validite="OUI") AND `user`.`idUser`=useretablissementpoint.idUser AND useretablissementpoint.idEtablissementPoint=tabetablissementpoint.idEtablissementPoint AND tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND useretablissementpoint.validite="OUI" AND tabetablissementpoint.validite="OUI" AND tabetablissement.validite="OUI" AND `user`.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); while ($a = $qx->fetch()) { $etablissement = $a['nomEtablissement']; } $queryx = 'INSERT INTO tabpisteaudit SET module="Nouveau paiement", typeAction="Ajout", idUser="'.$_SESSION['idUser'].'", login="'.$_SESSION['userName'].'", agence="'.$agence.'", etablissement="'.$etablissement.'", dateOperation="'.date('Y-m-d').'", dateServeur=now(), description="Paiement réussi. Code paiement ou numéro bordereau '.$_SESSION['codePaiement'].', montant : '.$_POST['montantPaye'].', devise : '.$_POST['devise'].'", validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); //header('Location: ../metronic/preview/demo3/index.php?printBorde='.$_SESSION['printBorde'].'&codePaiement='.$_SESSION['codePaiement'].''); if($_SESSION['redirect']=="OK"){ header('Location: ../metronic/preview/demo3/indexCE.php?printBorde='.$_SESSION['printBorde'].'&codePaiement='.$_SESSION['codePaiement'].''); } else{ //header('Location: ../RapportPDF/bordereau.php?codePaiement='.$_SESSION['codePaiement'].''); header('Location: ../metronic/preview/demo3/indexCLI.php?acronyme='.$_GET['acronyme'].'&typeEtablissement='.$_GET['typeEtablissement'].'&idEtablissementPoint='.$_GET['idEtablissementPoint'].''); } } else{ if($montant==trim($_POST['montantPaye']) && $devise==trim($_POST['devise'])){ $tabSer1=new Paiement(array ('categorie'=>trim($_POST['categorie']), 'numeroOperation'=>trim($_POST['numeroOperation']), 'lettre'=>trim($_POST['lettre']), 'autreDetail'=>trim($_POST['autreDetail']), 'typePaiement'=>trim($_POST['typePaiement']), 'matricule'=>trim($_POST['matricule']), 'idEtablissementPoint'=>trim($_POST['idEtablissementPoint']), 'idTypeFrais'=>trim($_POST['idTypeFrais']), 'nomDeposant'=>trim($_POST['nomDeposant']), 'nomEtudiant'=>trim($_POST['nomEtudiant']), 'promotion'=>trim($_POST['promotion']), 'sectionoption'=>trim($_POST['sectionoption']), 'montantPaye'=>trim($_POST['montantPaye']), 'devise'=>trim($_POST['devise']), 'annee'=>trim($_POST['annee']))); $dao->insererPaiementCLI($tabSer1); $queryx = 'SELECT typeEtablissement, acronyme FROM tabetablissement, tabetablissementpoint WHERE tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND idEtablissementPoint="'.$_GET['idEtablissementPoint'].'" AND tabetablissement.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $typeEtablissement=""; while ($ax = $qx->fetch()) { $typeEtablissement = $ax['typeEtablissement']; $acronyme = mb_strtoupper($ax['acronyme']); } $queryx = 'SELECT nomPoint FROM tabpointexploitation, tabetablissementpoint WHERE tabpointexploitation.idPoint=tabetablissementpoint.idPoint AND idEtablissementPoint="'.$_GET['idEtablissementPoint'].'" AND tabpointexploitation.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $pointExploi=""; while ($ax = $qx->fetch()) { $pointExploi = " ".$ax['nomPoint']; } $agence=""; $etablissement=""; $queryx = 'SELECT intitule FROM tabpointservice WHERE idPointService="'.$_SESSION['idPointService'].'" AND validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); while ($a = $qx->fetch()) { $agence = $a['intitule']; } $queryx = 'SELECT nomEtablissement FROM useretablissementpoint, tabetablissementpoint, tabetablissement, `user` WHERE `user`.idUser="'.$_SESSION['idUser'].'" AND `user`.idUser NOT IN (SELECT idUser FROM userpointservice WHERE validite="OUI") AND `user`.`idUser`=useretablissementpoint.idUser AND useretablissementpoint.idEtablissementPoint=tabetablissementpoint.idEtablissementPoint AND tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND useretablissementpoint.validite="OUI" AND tabetablissementpoint.validite="OUI" AND tabetablissement.validite="OUI" AND `user`.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); while ($a = $qx->fetch()) { $etablissement = $a['nomEtablissement']; } $queryx = 'INSERT INTO tabpisteaudit SET module="Nouveau paiement", typeAction="Ajout", idUser="'.$_SESSION['idUser'].'", login="'.$_SESSION['userName'].'", agence="'.$agence.'", etablissement="'.$etablissement.'", dateOperation="'.date('Y-m-d').'", dateServeur=now(), description="Paiement réussi. Code paiement ou numéro bordereau '.$_SESSION['codePaiement'].', montant : '.$_POST['montantPaye'].', devise : '.$_POST['devise'].'", validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); //header('Location: ../metronic/preview/demo3/index.php?printBorde='.$_SESSION['printBorde'].'&codePaiement='.$_SESSION['codePaiement'].''); if($_SESSION['redirect']=="OK"){ header('Location: ../metronic/preview/demo3/indexCE.php?printBorde='.$_SESSION['printBorde'].'&codePaiement='.$_SESSION['codePaiement'].''); } else{ //header('Location: ../RapportPDF/bordereau.php?codePaiement='.$_SESSION['codePaiement'].''); header('Location: ../metronic/preview/demo3/indexCLI.php?acronyme='.$_GET['acronyme'].'&typeEtablissement='.$_GET['typeEtablissement'].'&idEtablissementPoint='.$_GET['idEtablissementPoint'].''); } } else{ $_SESSION['messa'] = ' Opération non effectuée! Le montant ou la devise saisi ne correspond pas au montant du type de frais sélectionné. '; header('Location: ../metronic/preview/demo3/indexCLI.php?acronyme='.$_GET['acronyme'].'&typeEtablissement='.$_GET['typeEtablissement'].'&idEtablissementPoint='.$_GET['idEtablissementPoint'].''); } } } elseif(isset($_POST['btnInsertPaiementPOS'])){ $queryx = 'SELECT montant, devise, payerTotal FROM tabtypefrais WHERE idTypeFrais="'.$_POST['idTypeFrais'].'" AND validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $montant=""; $devise=""; $payerTotal=""; while ($ax = $qx->fetch()) { $montant = $ax['montant']; $devise = $ax['devise']; $payerTotal = $ax['payerTotal']; } $opsEpargnes=""; if($_POST['nouveau']=="OUI"){ if(isset($_FILES['imavideo']['name']) && !empty($_FILES['imavideo']['name'])){ if(trim($_POST['titre'])=="" || trim($_POST['nom'])=="" || trim($_POST['prenom'])=="" || trim($_POST['typePiece'])=="" || trim($_POST['telephone'])==""){ $_SESSION['messa'] = ' Opération non effectuée! Vous n\'avez pas complété tous les champs nécessaires. '; $payerTotal=""; } else{ $opsEpargnes="OUI"; } } else{ $_SESSION['messa'] = ' Opération non effectuée! Vous n\'avez joint aucun fichier. '; $payerTotal=""; } } elseif($_POST['nouveau']=="NON"){ if(trim($_POST['codeClient'])=="" || trim($_POST['telephone'])==""){ $_SESSION['messa'] = ' Opération non effectuée! Vous n\'avez pas complété le code client ou le téléphone. '; $payerTotal=""; } else{ $opsEpargnes="OUI"; } } $matriculeEtuEle = $_POST['matricule']; if($_GET['typeEtablissement']=="ECOLE"){ $queryx='SELECT codeEtablissement FROM tabetablissement WHERE idEtablissement IN (SELECT distinct(idEtablissement) FROM tabetablissementpoint WHERE idEtablissementPoint="'.$_GET['idEtablissementPoint'].'" AND validite="OUI") AND validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); while ($ax = $qx->fetch()) { $codeEtab = $ax['codeEtablissement']; } $queryx = 'SELECT matricule FROM tabpaiement WHERE idEtablissementPoint="'.$_GET['idEtablissementPoint'].'" AND lettre="'.$_POST['lettre'].'" AND nomEtudiant="'.$_POST['nomEtudiant'].'" AND promotion="'.$_POST['promotion'].'" AND sectionoption="'.$_POST['sectionoption'].'" AND validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $matriculeEtuEle=$codeEtab.rand(1000,9999); while ($ax = $qx->fetch()) { $matriculeEtuEle = $ax['matricule']; } } if($payerTotal=="NON"){ $tabSer1=new Paiement(array ('opsEpargnes'=>$opsEpargnes, 'codeClient'=>trim($_POST['codeClient']), 'titre'=>trim($_POST['titre']), 'nom'=>trim($_POST['nom']), 'postnom'=>trim($_POST['postnom']), 'prenom'=>trim($_POST['prenom']), 'typePiece'=>trim($_POST['typePiece']), 'numPID'=>trim($_POST['numPID']), 'dateExpiration'=>trim($_POST['dateExpiration']), 'telephone'=>trim($_POST['telephone']), 'dateNaissance'=>trim($_POST['dateNaissance']), 'observation'=>trim($_POST['observation']), 'categorie'=>trim($_POST['categorie']), 'numeroOperation'=>trim($_POST['numeroOperation']), 'lettre'=>trim($_POST['lettre']), 'autreDetail'=>trim($_POST['autreDetail']), 'typePaiement'=>trim($_POST['typePaiement']), 'matricule'=>trim($matriculeEtuEle), 'idEtablissementPoint'=>trim($_POST['idEtablissementPoint']), 'idTypeFrais'=>trim($_POST['idTypeFrais']), 'nomDeposant'=>trim($_POST['nomDeposant']), 'nomEtudiant'=>trim($_POST['nomEtudiant']), 'promotion'=>trim($_POST['promotion']), 'sectionoption'=>trim($_POST['sectionoption']), 'montantPaye'=>trim($_POST['montantPaye']), 'devise'=>trim($_POST['devise']), 'annee'=>trim($_POST['annee']))); $dao->insererPaiement($tabSer1); $queryx = 'SELECT typeEtablissement, acronyme FROM tabetablissement, tabetablissementpoint WHERE tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND idEtablissementPoint="'.$_GET['idEtablissementPoint'].'" AND tabetablissement.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $typeEtablissement=""; while ($ax = $qx->fetch()) { $typeEtablissement = $ax['typeEtablissement']; $acronyme = mb_strtoupper($ax['acronyme']); } $queryx = 'SELECT nomPoint FROM tabpointexploitation, tabetablissementpoint WHERE tabpointexploitation.idPoint=tabetablissementpoint.idPoint AND idEtablissementPoint="'.$_GET['idEtablissementPoint'].'" AND tabpointexploitation.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $pointExploi=""; while ($ax = $qx->fetch()) { $pointExploi = " ".$ax['nomPoint']; } $agence=""; $etablissement=""; $queryx = 'SELECT intitule FROM tabpointservice WHERE idPointService="'.$_SESSION['idPointService'].'" AND validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); while ($a = $qx->fetch()) { $agence = $a['intitule']; } $queryx = 'SELECT nomEtablissement FROM useretablissementpoint, tabetablissementpoint, tabetablissement, `user` WHERE `user`.idUser="'.$_SESSION['idUser'].'" AND `user`.idUser NOT IN (SELECT idUser FROM userpointservice WHERE validite="OUI") AND `user`.`idUser`=useretablissementpoint.idUser AND useretablissementpoint.idEtablissementPoint=tabetablissementpoint.idEtablissementPoint AND tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND useretablissementpoint.validite="OUI" AND tabetablissementpoint.validite="OUI" AND tabetablissement.validite="OUI" AND `user`.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); while ($a = $qx->fetch()) { $etablissement = $a['nomEtablissement']; } $queryx = 'INSERT INTO tabpisteaudit SET module="Nouveau paiement", typeAction="Ajout", idUser="'.$_SESSION['idUser'].'", login="'.$_SESSION['userName'].'", agence="'.$agence.'", etablissement="'.$etablissement.'", dateOperation="'.date('Y-m-d').'", dateServeur=now(), description="Paiement réussi. Code paiement ou numéro bordereau '.$_SESSION['codePaiement'].', montant : '.$_POST['montantPaye'].', devise : '.$_POST['devise'].'", validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); //header('Location: ../metronic/preview/demo3/index.php?printBorde='.$_SESSION['printBorde'].'&codePaiement='.$_SESSION['codePaiement'].''); if(isset($_FILES['imavideo']['name']) && !empty($_FILES['imavideo']['name'])){ $Col1_Array = $_FILES['imavideo']; $Col2_Array = $_FILES['imavideo']['name']; $Col3_Array = $_FILES['imavideo']['error']; $Col4_Array = $_FILES['imavideo']['size']; $Col5_Array = $_FILES['imavideo']['tmp_name']; $t=0; $f1=1; $f2=1; $f3=1; $f4=1; foreach($Col2_Array as $selectValue02){ $_FILES['imavideoName'.$f1.'']=$selectValue02; $f1++; } foreach($Col3_Array as $selectValue03){ $_FILES['imavideoError'.$f2.'']=$selectValue03; $f2++; } foreach($Col4_Array as $selectValue04){ $_FILES['imavideoSize'.$f3.'']=$selectValue04; $f3++; } foreach($Col5_Array as $selectValue05){ $_FILES['imavideoTmp_name'.$f4.'']=$selectValue05; $f4++; } //$verifi=0; foreach($Col1_Array as $selectValue){ $t=$t+1; $_SESSION['monimavideo']=$_SESSION['codeInfraction']; mkdir('../metronic/themes/metronic/theme/default/demo3/dist/assets/media/'.$_SESSION['monimavideo']); $chemin = '../metronic/themes/metronic/theme/default/demo3/dist/assets/media/'.$_SESSION['monimavideo']; // Testons si le fichier a bien été envoyé et s'il n'y a pas d'erreur if (isset($_FILES['imavideo']) AND $_FILES['imavideoError'.$t.''] == 0) {//$verifi=1; // Testons si le fichier n'est pas trop gros if ($_FILES['imavideoSize'.$t.''] <= 90000000) {//$verifi=2; // Testons si l'extension est autorisée $infosfichier = pathinfo($_FILES['imavideoName'.$t.'']); $extension_upload = $infosfichier['extension']; $extensions_autorisees = array('TIF', 'Tif', 'tif', 'TIFF', 'Tiff', 'tiff', 'jpg', 'jpeg', 'gif', 'png', 'JPG', 'JPEG', 'GIF', 'PNG', 'Jpg', 'Jpeg', 'Gif', 'Png', 'MKV', 'Mkv', 'mkv', 'MP4', 'Mp4', 'mp4', 'MOV', 'Mov', 'mov', 'WMV', 'Wmv', 'wmv', 'AVI', 'Avi', 'avi'); if (in_array($extension_upload, $extensions_autorisees)) {//$verifi=3; // On peut valider le fichier et le stocker définitivement move_uploaded_file($_FILES['imavideoTmp_name'.$t.''], ''.$chemin.'/' . basename($_FILES['imavideoName'.$t.''])); //$_SESSION['messa'] = "ok"; $_SESSION['messa'] = ' Opération terminée avec succès! '; } } } } $repo="0"; $dirname="../metronic/themes/metronic/theme/default/demo3/dist/assets/media/".$_SESSION['monimavideo']; //$dirname="../metronic/themes/metronic/theme/default/demo3/dist/assets/media/5525AX0100003"; $dir = opendir($dirname); while($file = readdir($dir)) { if($file != '.' && $file != '..' && !is_dir($dirname.$file)){ $cheminPhoto=$dirname.'/'.$file; $i++; $repo="1"; } } closedir($dir); /*if($repo=="1"){ $query = 'UPDATE tabautoinfraction SET imavideo="OUI" WHERE codeInfraction="'.$_SESSION['monimavideo'].'"'; $q=$dc->prepare($query); $q->execute(); }*/ } if($_SESSION['redirect']=="OK"){ header('Location: ../metronic/preview/demo3/indexCE.php?printBorde='.$_SESSION['printBorde'].'&codePaiement='.$_SESSION['codePaiement'].''); } else{ header('Location: ../RapportPDF/bordereauPOS.php?codePaiement='.$_SESSION['codePaiement'].''); } } else{ if($montant==trim($_POST['montantPaye']) && $devise==trim($_POST['devise'])){ $tabSer1=new Paiement(array ('categorie'=>trim($_POST['categorie']), 'numeroOperation'=>trim($_POST['numeroOperation']), 'lettre'=>trim($_POST['lettre']), 'autreDetail'=>trim($_POST['autreDetail']), 'typePaiement'=>trim($_POST['typePaiement']), 'matricule'=>trim($matriculeEtuEle), 'idEtablissementPoint'=>trim($_POST['idEtablissementPoint']), 'idTypeFrais'=>trim($_POST['idTypeFrais']), 'nomDeposant'=>trim($_POST['nomDeposant']), 'nomEtudiant'=>trim($_POST['nomEtudiant']), 'promotion'=>trim($_POST['promotion']), 'sectionoption'=>trim($_POST['sectionoption']), 'montantPaye'=>trim($_POST['montantPaye']), 'devise'=>trim($_POST['devise']), 'annee'=>trim($_POST['annee']))); $dao->insererPaiement($tabSer1); $queryx = 'SELECT typeEtablissement, acronyme FROM tabetablissement, tabetablissementpoint WHERE tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND idEtablissementPoint="'.$_GET['idEtablissementPoint'].'" AND tabetablissement.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $typeEtablissement=""; while ($ax = $qx->fetch()) { $typeEtablissement = $ax['typeEtablissement']; $acronyme = mb_strtoupper($ax['acronyme']); } $queryx = 'SELECT nomPoint FROM tabpointexploitation, tabetablissementpoint WHERE tabpointexploitation.idPoint=tabetablissementpoint.idPoint AND idEtablissementPoint="'.$_GET['idEtablissementPoint'].'" AND tabpointexploitation.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $pointExploi=""; while ($ax = $qx->fetch()) { $pointExploi = " ".$ax['nomPoint']; } $agence=""; $etablissement=""; $queryx = 'SELECT intitule FROM tabpointservice WHERE idPointService="'.$_SESSION['idPointService'].'" AND validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); while ($a = $qx->fetch()) { $agence = $a['intitule']; } $queryx = 'SELECT nomEtablissement FROM useretablissementpoint, tabetablissementpoint, tabetablissement, `user` WHERE `user`.idUser="'.$_SESSION['idUser'].'" AND `user`.idUser NOT IN (SELECT idUser FROM userpointservice WHERE validite="OUI") AND `user`.`idUser`=useretablissementpoint.idUser AND useretablissementpoint.idEtablissementPoint=tabetablissementpoint.idEtablissementPoint AND tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND useretablissementpoint.validite="OUI" AND tabetablissementpoint.validite="OUI" AND tabetablissement.validite="OUI" AND `user`.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); while ($a = $qx->fetch()) { $etablissement = $a['nomEtablissement']; } $queryx = 'INSERT INTO tabpisteaudit SET module="Nouveau paiement", typeAction="Ajout", idUser="'.$_SESSION['idUser'].'", login="'.$_SESSION['userName'].'", agence="'.$agence.'", etablissement="'.$etablissement.'", dateOperation="'.date('Y-m-d').'", dateServeur=now(), description="Paiement réussi. Code paiement ou numéro bordereau '.$_SESSION['codePaiement'].', montant : '.$_POST['montantPaye'].', devise : '.$_POST['devise'].'", validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); //header('Location: ../metronic/preview/demo3/index.php?printBorde='.$_SESSION['printBorde'].'&codePaiement='.$_SESSION['codePaiement'].''); if($_SESSION['redirect']=="OK"){ header('Location: ../metronic/preview/demo3/indexCE.php?printBorde='.$_SESSION['printBorde'].'&codePaiement='.$_SESSION['codePaiement'].''); } else{ header('Location: ../RapportPDF/bordereauPOS.php?codePaiement='.$_SESSION['codePaiement'].''); } } else{ $_SESSION['messa'] = ' Opération non effectuée! Le montant ou la devise saisi ne correspond pas au montant du type de frais sélectionné. '; header('Location: ../metronic/preview/demo3/index.php?acronyme='.$_GET['acronyme'].'&typeEtablissement='.$_GET['typeEtablissement'].'&idEtablissementPoint='.$_GET['idEtablissementPoint'].''); } } } elseif(isset($_POST['btnInsertPaiementFiltre'])){ header('Location: ../metronic/preview/demo3/indexSuperControle.php?devise='.$_POST['devise'].'&typeFrais='.$_POST['idTypeFrais'].'&datepaiementDebut='.$_POST['datepaiementDebut'].'&datepaiementFin='.$_POST['datepaiementFin'].'&idEtablissementPoint='.$_POST['idEtablissementPoint'].'&pourFiltre=OUI'); } elseif(isset($_POST['btnSelectEtablissement'])){ $queryx = 'SELECT typeEtablissement, acronyme FROM tabetablissement, tabetablissementpoint WHERE tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND idEtablissementPoint="'.$_POST['idEtablissementPoint'].'" AND tabetablissement.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $typeEtablissement=""; while ($ax = $qx->fetch()) { $typeEtablissement = $ax['typeEtablissement']; $acronyme = mb_strtoupper($ax['acronyme']); } $queryx = 'SELECT nomPoint FROM tabpointexploitation, tabetablissementpoint WHERE tabpointexploitation.idPoint=tabetablissementpoint.idPoint AND idEtablissementPoint="'.$_POST['idEtablissementPoint'].'" AND tabpointexploitation.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $pointExploi=""; while ($ax = $qx->fetch()) { $pointExploi = " ".$ax['nomPoint']; } $agence=""; $etablissement=""; $queryx = 'SELECT intitule FROM tabpointservice WHERE idPointService="'.$_SESSION['idPointService'].'" AND validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); while ($a = $qx->fetch()) { $agence = $a['intitule']; } $queryx = 'SELECT nomEtablissement FROM useretablissementpoint, tabetablissementpoint, tabetablissement, `user` WHERE `user`.idUser="'.$_SESSION['idUser'].'" AND `user`.idUser NOT IN (SELECT idUser FROM userpointservice WHERE validite="OUI") AND `user`.`idUser`=useretablissementpoint.idUser AND useretablissementpoint.idEtablissementPoint=tabetablissementpoint.idEtablissementPoint AND tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND useretablissementpoint.validite="OUI" AND tabetablissementpoint.validite="OUI" AND tabetablissement.validite="OUI" AND `user`.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); while ($a = $qx->fetch()) { $etablissement = $a['nomEtablissement']; } $queryx = 'INSERT INTO tabpisteaudit SET module="Choix établissement", typeAction="Ajout", idUser="'.$_SESSION['idUser'].'", login="'.$_SESSION['userName'].'", agence="'.$agence.'", etablissement="'.$etablissement.'", dateOperation="'.date('Y-m-d').'", dateServeur=now(), description="Sélection établissement '.$acronyme.$pointExploi.'", validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); header('Location: ../metronic/preview/demo3/index.php?acronyme='.$acronyme.'&typeEtablissement='.$typeEtablissement.'&idEtablissementPoint='.$_POST['idEtablissementPoint'].''); } elseif(isset($_POST['btnSelectEtablissementCLI'])){ $queryx = 'SELECT typeEtablissement, acronyme FROM tabetablissement, tabetablissementpoint WHERE tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND idEtablissementPoint="'.$_POST['idEtablissementPoint'].'" AND tabetablissement.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $typeEtablissement=""; while ($ax = $qx->fetch()) { $typeEtablissement = $ax['typeEtablissement']; $acronyme = mb_strtoupper($ax['acronyme']); } $queryx = 'SELECT nomPoint FROM tabpointexploitation, tabetablissementpoint WHERE tabpointexploitation.idPoint=tabetablissementpoint.idPoint AND idEtablissementPoint="'.$_POST['idEtablissementPoint'].'" AND tabpointexploitation.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $pointExploi=""; while ($ax = $qx->fetch()) { $pointExploi = " ".$ax['nomPoint']; } $agence=""; $etablissement=""; $queryx = 'SELECT intitule FROM tabpointservice WHERE idPointService="'.$_SESSION['idPointService'].'" AND validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); while ($a = $qx->fetch()) { $agence = $a['intitule']; } $queryx = 'SELECT nomEtablissement FROM useretablissementpoint, tabetablissementpoint, tabetablissement, `user` WHERE `user`.idUser="'.$_SESSION['idUser'].'" AND `user`.idUser NOT IN (SELECT idUser FROM userpointservice WHERE validite="OUI") AND `user`.`idUser`=useretablissementpoint.idUser AND useretablissementpoint.idEtablissementPoint=tabetablissementpoint.idEtablissementPoint AND tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND useretablissementpoint.validite="OUI" AND tabetablissementpoint.validite="OUI" AND tabetablissement.validite="OUI" AND `user`.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); while ($a = $qx->fetch()) { $etablissement = $a['nomEtablissement']; } $queryx = 'INSERT INTO tabpisteaudit SET module="Choix établissement", typeAction="Ajout", idUser="'.$_SESSION['idUser'].'", login="'.$_SESSION['userName'].'", agence="'.$agence.'", etablissement="'.$etablissement.'", dateOperation="'.date('Y-m-d').'", dateServeur=now(), description="Sélection établissement '.$acronyme.$pointExploi.'", validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); header('Location: ../metronic/preview/demo3/indexCLI.php?acronyme='.$acronyme.'&typeEtablissement='.$typeEtablissement.'&idEtablissementPoint='.$_POST['idEtablissementPoint'].''); } elseif(isset($_POST['btnSelectEtablissementDG'])){ $queryx = 'SELECT typeEtablissement, acronyme FROM tabetablissement, tabetablissementpoint WHERE tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND idEtablissementPoint="'.$_POST['idEtablissementPoint'].'" AND tabetablissement.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $typeEtablissement=""; while ($ax = $qx->fetch()) { $typeEtablissement = $ax['typeEtablissement']; $acronyme = mb_strtoupper($ax['acronyme']); } header('Location: ../metronic/preview/demo3/indexDG.php?acronyme='.$acronyme.'&typeEtablissement='.$typeEtablissement.'&idEtablissementPoint='.$_POST['idEtablissementPoint'].''); } elseif(isset($_POST['btnSelectEtablissementOPS'])){ $queryx = 'SELECT typeEtablissement, acronyme FROM tabetablissement, tabetablissementpoint WHERE tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND idEtablissementPoint="'.$_POST['idEtablissementPoint'].'" AND tabetablissement.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $typeEtablissement=""; while ($ax = $qx->fetch()) { $typeEtablissement = $ax['typeEtablissement']; $acronyme = mb_strtoupper($ax['acronyme']); } header('Location: ../metronic/preview/demo3/indexOPS.php?acronyme='.$acronyme.'&typeEtablissement='.$typeEtablissement.'&idEtablissementPoint='.$_POST['idEtablissementPoint'].''); } elseif(isset($_POST['btnSelectEtablissementTR'])){ $queryx = 'SELECT typeEtablissement, acronyme FROM tabetablissement, tabetablissementpoint WHERE tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND idEtablissementPoint="'.$_POST['idEtablissementPoint'].'" AND tabetablissement.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $typeEtablissement=""; while ($ax = $qx->fetch()) { $typeEtablissement = $ax['typeEtablissement']; $acronyme = mb_strtoupper($ax['acronyme']); } header('Location: ../metronic/preview/demo3/indexTR.php?acronyme='.$acronyme.'&typeEtablissement='.$typeEtablissement.'&idEtablissementPoint='.$_POST['idEtablissementPoint'].''); } elseif(isset($_POST['btnSelectEtablissementCI'])){ $queryx = 'SELECT typeEtablissement, acronyme FROM tabetablissement, tabetablissementpoint WHERE tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND idEtablissementPoint="'.$_POST['idEtablissementPoint'].'" AND tabetablissement.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $typeEtablissement=""; while ($ax = $qx->fetch()) { $typeEtablissement = $ax['typeEtablissement']; $acronyme = mb_strtoupper($ax['acronyme']); } header('Location: ../metronic/preview/demo3/indexCI.php?acronyme='.$acronyme.'&typeEtablissement='.$typeEtablissement.'&idEtablissementPoint='.$_POST['idEtablissementPoint'].''); } elseif(isset($_POST['btnDeclarationMontant'])){ echo $queryx = 'SELECT idDeclaration FROM tabdeclaration WHERE idEtablissementPoint="'.$_GET['idEtablissementPoint'].'" AND dateDeclaration=now() AND validite="OUI"'; die;$qx=$dc->prepare($queryx); $qx->execute(); $p=0; while ($ax = $qx->fetch()) { $p = $ax['idDeclaration']; } if($p==0){ $queryx = 'SELECT SUM(montantPaye) AS montantTotalUSD FROM tabpaiement WHERE devise="USD" AND idEtablissementPoint="'.$_GET['idEtablissementPoint'].'" AND datePaiement=now() AND validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $montantTotalUSD=0; $ecartUSD=0; while ($ax = $qx->fetch()) { $montantTotalUSD = $ax['montantTotalUSD']; } $ecartUSD = $montantTotalUSD - $_POST['montantUSD']; $queryx = 'SELECT SUM(montantPaye) AS montantTotalCDF FROM tabpaiement WHERE devise="CDF" AND idEtablissementPoint="'.$_GET['idEtablissementPoint'].'" AND datePaiement=now() AND validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $montantTotalCDF=0; $ecartCDF=0; while ($ax = $qx->fetch()) { $montantTotalCDF = $ax['montantTotalCDF']; } $ecartCDF = $montantTotalCDF - $_POST['montantCDF']; $queryx = 'INSERT INTO tabdeclaration SET idUser="'.$_GET['idUser'].'", idEtablissementPoint="'.$_GET['idEtablissementPoint'].'", montantUSD="'.$_POST['montantUSD'].'", ecartUSD="'.$ecartUSD.'", montantCDF="'.$_POST['montantCDF'].'", ecartCDF="'.$ecartCDF.'", observation="'.$_POST['observation'].'", dateDeclaration=now(), dateTimeDeclaration=now(), validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $_SESSION['messa'] = ' Annulation effectuée avec succès! '; } header('Location: ../metronic/preview/demo3/indexCE.php?idUser='.$_GET['idUser'].'&idEtablissementPoint='.$_GET['idEtablissementPoint'].''); } elseif(isset($_POST['btnSelectEtablissementComptabilite'])){ $queryx = 'SELECT typeEtablissement, acronyme FROM tabetablissement, tabetablissementpoint WHERE tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND idEtablissementPoint="'.$_POST['idEtablissementPoint'].'" AND tabetablissement.validite="OUI" AND tabetablissementpoint.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $typeEtablissement=""; while ($ax = $qx->fetch()) { $typeEtablissement = $ax['typeEtablissement']; $acronyme = mb_strtoupper($ax['acronyme']); } header('Location: ../metronic/preview/demo3/indexComptabilite.php?acronyme='.$acronyme.'&typeEtablissement='.$typeEtablissement.'&idEtablissementPoint='.$_POST['idEtablissementPoint'].''); } elseif(isset($_POST['btnInsertDeclareCE'])){ $_SESSION['messa'] = ' Opération non effectuée! Aucune liaison trouvée entre l\'établissement et le caissier externe. '; $queryx = 'SELECT idUserEtablissementPoint FROM useretablissementpoint WHERE idUser="'.$_POST['idUserCE'].'" AND idEtablissementPoint="'.$_POST['idEtablissementPoint'].'" AND validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $idUserEtablissementPoint=0; while ($ax = $qx->fetch()) { $idUserEtablissementPoint = $ax['idUserEtablissementPoint']; } if($idUserEtablissementPoint>0){ $queryx = 'INSERT INTO tabdeclaration SET idUserCP="'.$_GET['idUser'].'", idUser="'.$_POST['idUserCE'].'", idEtablissementPoint="'.$_POST['idEtablissementPoint'].'", montantUSD="'.$_POST['montantUSD'].'", montantCDF="'.$_POST['montantCDF'].'", numPiece="'.$_POST['numPiece'].'", dateDeclaration=now(), dateTimeDeclaration=now(), validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $_SESSION['messa'] = ' Opération terminée avec succès! '; } header('Location: ../metronic/preview/demo3/indexCaissierPrincipal.php'); } elseif(isset($_POST['btnInsertDeclareCECA'])){ $_SESSION['messa'] = ' Opération non effectuée! Aucune liaison trouvée entre l\'établissement et le caissier externe. '; $queryx = 'SELECT idUserEtablissementPoint FROM useretablissementpoint WHERE idUser="'.$_POST['idUserCE'].'" AND idEtablissementPoint="'.$_POST['idEtablissementPoint'].'" AND validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $idUserEtablissementPoint=0; while ($ax = $qx->fetch()) { $idUserEtablissementPoint = $ax['idUserEtablissementPoint']; } if($idUserEtablissementPoint>0){ $queryx = 'INSERT INTO tabdeclaration SET idUserCP="'.$_GET['idUser'].'", idUser="'.$_POST['idUserCE'].'", idEtablissementPoint="'.$_POST['idEtablissementPoint'].'", montantUSD="'.$_POST['montantUSD'].'", montantCDF="'.$_POST['montantCDF'].'", numPiece="'.$_POST['numPiece'].'", dateDeclaration=now(), dateTimeDeclaration=now(), validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $_SESSION['messa'] = ' Opération terminée avec succès! '; } header('Location: ../metronic/preview/demo3/indexChefAgence.php'); } elseif(isset($_POST['btnInsertPaiementFiltrePDF'])){ header('Location: ../Impression/rapportSuperUser001.php?idPointService='.$_POST['idPointService'].'&typeFrais='.$_POST['idTypeFrais'].'&devise='.$_POST['devise'].'&idEtablissement='.$_GET['idEtablissement'].'&idEtablissementPoint='.$_GET['idEtablissementPoint'].'&datepaiementDebut='.$_POST['datepaiementDebut'].'&datepaiementFin='.$_POST['datepaiementFin'].'&idEtablissementPointFil='.$_POST['idEtablissementPoint'].'&pourFiltre=OUI'); } elseif(isset($_POST['btnInsertPaiementFiltreCIPDF'])){ header('Location: ../Impression/rapportSuperUser002.php?idPointService='.$_POST['idPointService'].'&typeFrais='.$_POST['idTypeFrais'].'&devise='.$_POST['devise'].'&idEtablissement='.$_GET['idEtablissement'].'&idEtablissementPoint='.$_GET['idEtablissementPoint'].'&datepaiementDebut='.$_POST['datepaiementDebut'].'&datepaiementFin='.$_POST['datepaiementFin'].'&idEtablissementPointFil='.$_POST['idEtablissementPoint'].'&pourFiltre=OUI'); } elseif(isset($_POST['btnInsertPaiementFiltreCaissierPDF'])){ header('Location: ../Impression/rapportCaissier001.php?idUser='.$_GET['idUser'].'&typeFrais='.$_POST['idTypeFrais'].'&devise='.$_POST['devise'].'&idEtablissementPoint='.$_GET['idEtablissementPoint'].'&datepaiementDebut='.$_POST['datepaiementDebut'].'&datepaiementFin='.$_POST['datepaiementFin'].'&idEtablissementPointFil='.$_POST['idEtablissementPoint'].'&pourFiltre=OUI'); } elseif(isset($_POST['btnChargerTab'])){ header('Location: ../metronic/preview/demo3/indexOperationMensuelle.php?idUser='.$_GET['idUser'].'&typeFrais='.$_POST['idTypeFrais'].'&devise='.$_POST['devise'].'&idEtablissementPoint='.$_GET['idEtablissementPoint'].'&nomEtudiant='.$_POST['nomEtudiant'].'&matricule='.$_POST['matricule'].'&datepaiementDebut='.$_POST['datepaiementDebut'].'&datepaiementFin='.$_POST['datepaiementFin'].'&idEtablissementPointFil='.$_POST['idEtablissementPoint'].'&pourFiltre=OUI'); } elseif(isset($_POST['btnInsertPaiementFiltreComptablePDF'])){ header('Location: ../Impression/rapportComptable001.php?idUser='.$_GET['idUser'].'&idPointService='.$_GET['idPointService'].'&typeFrais='.$_POST['idTypeFrais'].'&idPointServiceForm='.$_POST['idPointServiceForm'].'&devise='.$_POST['devise'].'&idEtablissementPoint='.$_GET['idEtablissementPoint'].'&datepaiementDebut='.$_POST['datepaiementDebut'].'&datepaiementFin='.$_POST['datepaiementFin'].'&idEtablissementPointFil='.$_POST['idEtablissementPoint'].'&pourFiltre=OUI'); } elseif(isset($_POST['btnInsertPaiementFiltreCaissierPDF002'])){ header('Location: ../Impression/rapportCaissier002.php?idUser='.$_GET['idUser'].'&typeFrais='.$_POST['idTypeFrais'].'&devise='.$_POST['devise'].'&idEtablissementPoint='.$_GET['idEtablissementPoint'].'&datepaiementDebut='.$_POST['datepaiementDebut'].'&datepaiementFin='.$_POST['datepaiementFin'].'&idEtablissementPointFil='.$_POST['idEtablissementPoint'].'&pourFiltre=OUI'); } elseif(isset($_POST['btnInsertPaiementFiltreCaissierPDF003'])){ header('Location: ../Impression/rapportCaissier003.php?idUser='.$_GET['idUser'].'&typeFrais='.$_POST['idTypeFrais'].'&devise='.$_POST['devise'].'&idEtablissementPoint='.$_GET['idEtablissementPoint'].'&datepaiementDebut='.$_POST['datepaiementDebut'].'&datepaiementFin='.$_POST['datepaiementFin'].'&idEtablissementPointFil='.$_POST['idEtablissementPoint'].'&pourFiltre=OUI'); } elseif(isset($_POST['btnInsertPaiementFiltreCaissierPrincipalPDF'])){ header('Location: ../Impression/rapportCaissierPrincipal001.php?idUser='.$_GET['idUser'].'&idPointServiceForm='.$_POST['idPointServiceForm'].'&typeFrais='.$_POST['idTypeFrais'].'&idCaissier='.$_POST['idCaissier'].'&devise='.$_POST['devise'].'&idEtablissementPoint='.$_GET['idEtablissementPoint'].'&datepaiementDebut='.$_POST['datepaiementDebut'].'&datepaiementFin='.$_POST['datepaiementFin'].'&idEtablissementPointFil='.$_POST['idEtablissementPoint'].'&pourFiltre=OUI'); } elseif(isset($_POST['btnInsertPaiementFiltreEXCEL'])){ /*$idEtablissementPoint=$_GET['idEtablissementPoint']; $datepaiementDebut=$_POST['datepaiementDebut']; $datepaiementFin=$_POST['datepaiementFin']; $idEtablissementPointFil=$_POST['idEtablissementPoint']; $reqIdEtablissementPointFil =""; $reqDatepaiementDebut =""; $reqDatepaiementFin =""; if(trim($idEtablissementPointFil<>"")) { $reqIdEtablissementPointFil = "idEtablissementPoint =".$idEtablissementPointFil." AND "; } if(trim($datepaiementDebut<>"")) { $reqDatepaiementDebut = "datePaiement >= '".$datepaiementDebut."' AND "; } if(trim($datepaiementFin<>"")) { $reqDatepaiementFin = "datePaiement <= '".$datepaiementFin."' AND "; } */ $idPointService=$_POST['idPointService']; $typeFrais=$_POST['typeFrais']; $devise=$_POST['devise']; $idEtablissementPoint=$_POST['idEtablissementPoint']; $datepaiementDebut=$_POST['datepaiementDebut']; $datepaiementFin=$_POST['datepaiementFin']; $idEtablissementPointFil=$_GET['idEtablissementPointFil']; $reqIdPointService =""; $reqTypeFrais =""; $reqDevise =""; $reqIdEtablissementPointFil =""; $reqDatepaiementDebut =""; $reqDatepaiementFin =""; if(trim($idPointService<>"")) {$filtreSur=""; $idPointServiceFiltre="Agence/Point de service;
"; $reqIdPointService = "tabpaiement.idPointService =".$idPointService." AND "; } if(trim($typeFrais<>"")) {$filtreSur=""; $typeFraisFiltre="Type de frais;
"; $reqTypeFrais = "tabpaiement.idTypeFrais ='".$typeFrais."' AND "; } if(trim($devise<>"")) {$filtreSur=""; $deviseFiltre="Devise;
"; $reqDevise = "tabpaiement.devise ='".$devise."' AND "; } if(trim($idEtablissementPoint<>"")) {$filtreSur=""; $idEtablissementPointFiltre="Site établissement;
"; $reqIdEtablissementPointFil = "tabpaiement.idEtablissementPoint =".$idEtablissementPoint." AND "; } if(trim($datepaiementDebut<>"")) {$filtreSur=""; $datepaiementFiltre="Date_ops;
"; $reqDatepaiementDebut = "datePaiement >= '".$datepaiementDebut."' AND "; } if(trim($datepaiementFin<>"")) {$filtreSur=""; $datepaiementFiltre="Date_ops;
"; $reqDatepaiementFin = "datePaiement <= '".$datepaiementFin."' AND "; } //$query = 'SELECT idPaiement, numeroOperation, matricule, idEtablissementPoint, tabpaiement.devise AS devise, datePaiement, codePaiement, nomEtudiant, promotion, sectionoption, tabtypefrais.intitule AS typefrais, tabpaiement.montantPaye AS montantPaye, nomDeposant, tabpointservice.intitule AS intitulePointService FROM tabpointservice, tabpaiement, tabtypefrais WHERE '.$reqIdEtablissementPointFil.$reqDatepaiementDebut.$reqDatepaiementFin.' idEtablissementPoint IN (SELECT idEtablissementPoint FROM tabetablissementpoint WHERE idEtablissement IN (SELECT idEtablissement FROM tabetablissementpoint WHERE idEtablissementPoint="'.$idEtablissementPoint.'" AND validite="OUI") AND validite="OUI") AND tabpointservice.idPointservice=tabpaiement.idPointService AND tabpaiement.idTypeFrais=tabtypefrais.idTypeFrais AND tabpaiement.validite="OUI" AND tabtypefrais.validite="OUI" AND tabpointservice.validite="OUI" ORDER BY datepaiement'; //$query = 'SELECT idPaiement, numeroOperation, matricule, tabpaiement.idEtablissementPoint AS idEtablissementPoint, tabpaiement.devise AS devise, datePaiement, codePaiement, nomEtudiant, tabpaiement.promotion AS promotion, tabpaiement.sectionoption AS sectionoption, tabtypefrais.intitule AS typefrais, tabpaiement.montantPaye AS montantPaye, nomDeposant, tabpointservice.intitule AS intitulePointService FROM tabpointservice, tabpaiement, tabtypefrais WHERE '.$reqIdPointService.$reqIdEtablissementPointFil.$reqDatepaiementDebut.$reqDatepaiementFin.$reqDevise.$reqTypeFrais.' tabpointservice.idPointservice=tabpaiement.idPointService AND tabpaiement.idTypeFrais=tabtypefrais.idTypeFrais AND tabpaiement.validite="OUI" AND tabtypefrais.validite="OUI" AND tabpointservice.validite="OUI" ORDER BY datepaiement, nomEtudiant'; $query = 'SELECT idPaiement, numeroOperation, matricule, tabpaiement.idEtablissementPoint AS idEtablissementPoint, tabpaiement.devise AS devise, datePaiement, codePaiement, nomEtudiant, tabpaiement.promotion AS promotion, tabpaiement.sectionoption AS sectionoption, tabtypefrais.intitule AS typefrais, tabpaiement.montantPaye AS montantPaye, nomDeposant, tabpointservice.intitule AS intitulePointService FROM tabpointservice, tabpaiement, tabtypefrais, tabetablissement, tabetablissementpoint WHERE '.$reqIdPointService.$reqIdEtablissementPointFil.$reqDatepaiementDebut.$reqDatepaiementFin.$reqDevise.$reqTypeFrais.' tabetablissement.idEtablissement=tabetablissementpoint.idEtablissement AND tabpaiement.idEtablissementPoint=tabetablissementpoint.idEtablissementPoint AND tabetablissement.idEtablissement="'.$_GET['idEtablissement'].'" AND tabpointservice.idPointservice=tabpaiement.idPointService AND tabpaiement.idTypeFrais=tabtypefrais.idTypeFrais AND tabpaiement.validite="OUI" AND tabtypefrais.validite="OUI" AND tabpointservice.validite="OUI" AND tabetablissement.validite="OUI" AND tabetablissementpoint.validite="OUI" ORDER BY datepaiement, nomEtudiant'; $q=$dc->prepare($query); $q->execute(); $export .= ' '; while ($a = $q->fetch()) { $dateHeure = date('d-m-Y H:i:s'); $queryx = 'SELECT intitule FROM tabtypefrais WHERE idTypeFrais IN (SELECT tabpaiement.idTypeFrais FROM tabpaiement WHERE idPaiement="'.$a['idPaiement'].'" AND validite="OUI") AND validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $typeFrais=""; while ($ax = $qx->fetch()) { $typeFrais = $ax['intitule']; } $queryx = 'SELECT tabetablissement.acronyme AS acronymeEtab, nomPoint FROM tabetablissementpoint, tabetablissement, tabpointexploitation WHERE idEtablissementPoint="'.$a['idEtablissementPoint'].'" AND tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND tabetablissementpoint.idPoint=tabpointexploitation.idPoint AND tabetablissementpoint.validite="OUI" AND tabetablissement.validite="OUI" AND tabpointexploitation.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); while ($ax = $qx->fetch()) { $nomEtab = mb_strtoupper($ax['nomPoint']); } //$dt = DateTime::createFromFormat('Y-m-d', $a['dateEmise']);$date1 = $dt->format('d-m-Y'); $dt = DateTime::createFromFormat('Y-m-d', $a['datePaiement']);$date2 = $dt->format('d/m/Y'); $export .= ' '; } $export .= '

DATE_OPS	MATRICULE	ETUDIANT	PROMOTION	SECTION	MOTIF/TYPE_FRAIS	MOTANT PAYE	DEVISE	SITE	CODE_PAIEMENT	AGENCE
'.$date2.'	'.mb_strtoupper($a['matricule']).'	'.mb_strtoupper($a['nomEtudiant']).'	'.mb_strtoupper($a['promotion']).'	'.mb_strtoupper($a['sectionoption']).'	'.mb_strtoupper($typeFrais).'	'.$a['montantPaye'].'	'.$a['devise'].'	'.$nomEtab.'	'."'".$a['codePaiement'].'	'.mb_strtoupper($a['intitulePointService']).'

'; if (mb_detect_encoding($export) == 'UTF-8') { $export = mb_convert_encoding($export , "HTML-ENTITIES", "UTF-8"); } header('Content-Type: application/xls; charset=utf-16'); header('Content-Disposition: attachment; filename=rapportsimplepay'." ".$dateHeure.'.xls'); echo $export; die; //header('Location: ../Interfaces/adminBrigadePrincipal.php?page=0&btnSelect=afficherOrdreMission&operat=0&periodeOM=ok&dateDebut='.$_POST['dateDebut'].'&dateFin='.$_POST['dateFin'].'&mySchool='.$_SESSION['maBD'].'&cours='); header('Location: ../metronic/preview/demo3/indexSuperControle.php?idEtablissementPoint='.$_GET['idEtablissementPoint'].'&datepaiementDebut='.$_POST['datepaiementDebut'].'&datepaiementFin='.$_POST['datepaiementFin'].'&idEtablissementPointFil='.$_POST['idEtablissementPointFil'].'&pourFiltre=OUI'); } elseif(isset($_POST['btnInsertPaiementFiltreCIEXCEL'])){ /*$idEtablissementPoint=$_GET['idEtablissementPoint']; $datepaiementDebut=$_POST['datepaiementDebut']; $datepaiementFin=$_POST['datepaiementFin']; $idEtablissementPointFil=$_POST['idEtablissementPoint']; $reqIdEtablissementPointFil =""; $reqDatepaiementDebut =""; $reqDatepaiementFin =""; if(trim($idEtablissementPointFil<>"")) { $reqIdEtablissementPointFil = "idEtablissementPoint =".$idEtablissementPointFil." AND "; } if(trim($datepaiementDebut<>"")) { $reqDatepaiementDebut = "datePaiement >= '".$datepaiementDebut."' AND "; } if(trim($datepaiementFin<>"")) { $reqDatepaiementFin = "datePaiement <= '".$datepaiementFin."' AND "; } */ $idPointService=$_POST['idPointService']; $typeFrais=$_POST['typeFrais']; $devise=$_POST['devise']; $idEtablissementPoint=$_POST['idEtablissementPoint']; $datepaiementDebut=$_POST['datepaiementDebut']; $datepaiementFin=$_POST['datepaiementFin']; $idEtablissementPointFil=$_GET['idEtablissementPointFil']; $reqIdPointService =""; $reqTypeFrais =""; $reqDevise =""; $reqIdEtablissementPointFil =""; $reqDatepaiementDebut =""; $reqDatepaiementFin =""; if(trim($idPointService<>"")) {$filtreSur=""; $idPointServiceFiltre="Agence/Point de service;
"; $reqIdPointService = "tabpaiement.idPointService =".$idPointService." AND "; } if(trim($typeFrais<>"")) {$filtreSur=""; $typeFraisFiltre="Type de frais;
"; $reqTypeFrais = "tabpaiement.idTypeFrais ='".$typeFrais."' AND "; } if(trim($devise<>"")) {$filtreSur=""; $deviseFiltre="Devise;
"; $reqDevise = "tabpaiement.devise ='".$devise."' AND "; } if(trim($idEtablissementPointFil<>"")) {$filtreSur=""; $idEtablissementPointFiltre="Site établissement;
"; $reqIdEtablissementPointFil = "tabpaiement.idEtablissementPoint =".$idEtablissementPointFil." AND "; } if(trim($datepaiementDebut<>"")) {$filtreSur=""; $datepaiementFiltre="Date_ops;
"; $reqDatepaiementDebut = "datePaiement >= '".$datepaiementDebut."' AND "; } if(trim($datepaiementFin<>"")) {$filtreSur=""; $datepaiementFiltre="Date_ops;
"; $reqDatepaiementFin = "datePaiement <= '".$datepaiementFin."' AND "; } //$query = 'SELECT idPaiement, numeroOperation, matricule, idEtablissementPoint, tabpaiement.devise AS devise, datePaiement, codePaiement, nomEtudiant, promotion, sectionoption, tabtypefrais.intitule AS typefrais, tabpaiement.montantPaye AS montantPaye, nomDeposant, tabpointservice.intitule AS intitulePointService FROM tabpointservice, tabpaiement, tabtypefrais WHERE '.$reqIdEtablissementPointFil.$reqDatepaiementDebut.$reqDatepaiementFin.' idEtablissementPoint IN (SELECT idEtablissementPoint FROM tabetablissementpoint WHERE idEtablissement IN (SELECT idEtablissement FROM tabetablissementpoint WHERE idEtablissementPoint="'.$idEtablissementPoint.'" AND validite="OUI") AND validite="OUI") AND tabpointservice.idPointservice=tabpaiement.idPointService AND tabpaiement.idTypeFrais=tabtypefrais.idTypeFrais AND tabpaiement.validite="OUI" AND tabtypefrais.validite="OUI" AND tabpointservice.validite="OUI" ORDER BY datepaiement'; //$query = 'SELECT idPaiement, numeroOperation, matricule, tabpaiement.idEtablissementPoint AS idEtablissementPoint, tabpaiement.devise AS devise, datePaiement, codePaiement, nomEtudiant, tabpaiement.promotion AS promotion, tabpaiement.sectionoption AS sectionoption, tabtypefrais.intitule AS typefrais, tabpaiement.montantPaye AS montantPaye, nomDeposant, tabpointservice.intitule AS intitulePointService FROM tabpointservice, tabpaiement, tabtypefrais WHERE '.$reqIdPointService.$reqIdEtablissementPointFil.$reqDatepaiementDebut.$reqDatepaiementFin.$reqDevise.$reqTypeFrais.' tabpointservice.idPointservice=tabpaiement.idPointService AND tabpaiement.idTypeFrais=tabtypefrais.idTypeFrais AND tabpaiement.validite="OUI" AND tabtypefrais.validite="OUI" AND tabpointservice.validite="OUI" ORDER BY datepaiement, nomEtudiant'; $query = 'SELECT idPaiement, numeroOperation, matricule, tabpaiement.idEtablissementPoint AS idEtablissementPoint, tabpaiement.devise AS devise, datePaiement, codePaiement, nomEtudiant, tabpaiement.promotion AS promotion, tabpaiement.sectionoption AS sectionoption, tabtypefrais.intitule AS typefrais, tabpaiement.montantPaye AS montantPaye, nomDeposant, tabpointservice.intitule AS intitulePointService FROM tabpointservice, tabpaiement, tabtypefrais WHERE '.$reqIdPointService.$reqIdEtablissementPointFil.$reqDatepaiementDebut.$reqDatepaiementFin.$reqDevise.$reqTypeFrais.' tabpointservice.idPointservice=tabpaiement.idPointService AND tabpaiement.idTypeFrais=tabtypefrais.idTypeFrais AND tabpaiement.validite="OUI" AND tabtypefrais.validite="OUI" AND tabpointservice.validite="OUI" ORDER BY datepaiement, nomEtudiant'; $q=$dc->prepare($query); $q->execute(); $export .= ' '; while ($a = $q->fetch()) { $dateHeure = date('d-m-Y H:i:s'); $queryx = 'SELECT intitule FROM tabtypefrais WHERE idTypeFrais IN (SELECT tabpaiement.idTypeFrais FROM tabpaiement WHERE idPaiement="'.$a['idPaiement'].'" AND validite="OUI") AND validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); $typeFrais=""; while ($ax = $qx->fetch()) { $typeFrais = $ax['intitule']; } $queryx = 'SELECT tabetablissement.acronyme AS acronymeEtab, nomPoint FROM tabetablissementpoint, tabetablissement, tabpointexploitation WHERE idEtablissementPoint="'.$a['idEtablissementPoint'].'" AND tabetablissementpoint.idEtablissement=tabetablissement.idEtablissement AND tabetablissementpoint.idPoint=tabpointexploitation.idPoint AND tabetablissementpoint.validite="OUI" AND tabetablissement.validite="OUI" AND tabpointexploitation.validite="OUI"'; $qx=$dc->prepare($queryx); $qx->execute(); while ($ax = $qx->fetch()) { $nomEtab = mb_strtoupper($ax['nomPoint']); } //$dt = DateTime::createFromFormat('Y-m-d', $a['dateEmise']);$date1 = $dt->format('d-m-Y'); $dt = DateTime::createFromFormat('Y-m-d', $a['datePaiement']);$date2 = $dt->format('d/m/Y'); $export .= ' '; } $export .= '

DATE_OPS	MATRICULE	ETUDIANT	PROMOTION	SECTION	MOTIF/TYPE_FRAIS	MOTANT PAYE	DEVISE	SITE	CODE_PAIEMENT	AGENCE
'.$date2.'	'.mb_strtoupper($a['matricule']).'	'.mb_strtoupper($a['nomEtudiant']).'	'.mb_strtoupper($a['promotion']).'	'.mb_strtoupper($a['sectionoption']).'	'.mb_strtoupper($typeFrais).'	'.$a['montantPaye'].'	'.$a['devise'].'	'.$nomEtab.'	'."'".$a['codePaiement'].'	'.mb_strtoupper($a['intitulePointService']).'