/** * @name operationAttenteFerme($pTypePaiement) * @return array(OperationDetailVO) ou false en erreur * @desc Retourne l'ensemble des opérations des fermes non pointées */ public static function operationAttenteFerme($pTypePaiement) { // Initialisation du Logger $lLogger =& Log::singleton('file', CHEMIN_FICHIER_LOGS); $lLogger->setMask(Log::MAX(LOG_LEVEL)); $lRequete = "SELECT " . FermeManager::CHAMP_FERME_ID . "," . FermeManager::CHAMP_FERME_NUMERO . "," . FermeManager::CHAMP_FERME_NOM . "," . CompteManager::CHAMP_COMPTE_LABEL . "," . CompteManager::CHAMP_COMPTE_SOLDE . "," . OperationManager::CHAMP_OPERATION_MONTANT . "," . OperationManager::CHAMP_OPERATION_TYPE_PAIEMENT . "," . OperationManager::CHAMP_OPERATION_DATE . "," . OperationManager::CHAMP_OPERATION_LIBELLE . "," . OperationManager::CHAMP_OPERATION_ID . "," . OperationChampComplementaireManager::CHAMP_OPERATIONCHAMPCOMPLEMENTAIRE_CHCP_ID . "," . OperationChampComplementaireManager::CHAMP_OPERATIONCHAMPCOMPLEMENTAIRE_VALEUR . "," . OperationRemiseChequeManager::CHAMP_OPERATIONREMISECHEQUE_ID_REMISE_CHEQUE . ',' . RemiseChequeManager::CHAMP_REMISECHEQUE_NUMERO . "\n\t\tFROM " . OperationManager::TABLE_OPERATION . "\n\t\tJOIN " . CompteManager::TABLE_COMPTE . " ON " . CompteManager::CHAMP_COMPTE_ID . " = " . OperationManager::CHAMP_OPERATION_ID_COMPTE . "\n\t\tJOIN " . FermeManager::TABLE_FERME . " ON " . FermeManager::CHAMP_FERME_ID_COMPTE . " = " . OperationManager::CHAMP_OPERATION_ID_COMPTE . "\n\t\tLEFT JOIN " . OperationChampComplementaireManager::TABLE_OPERATIONCHAMPCOMPLEMENTAIRE . "\n\t\t\tON " . OperationChampComplementaireManager::CHAMP_OPERATIONCHAMPCOMPLEMENTAIRE_OPE_ID . " = " . OperationManager::CHAMP_OPERATION_ID . "\n\t\tLEFT JOIN " . OperationRemiseChequeManager::TABLE_OPERATIONREMISECHEQUE . " \n\t\t\tON " . OperationRemiseChequeManager::CHAMP_OPERATIONREMISECHEQUE_ID_OPERATION . " = " . OperationManager::CHAMP_OPERATION_ID . "\n\t\t\tAND " . OperationRemiseChequeManager::CHAMP_OPERATIONREMISECHEQUE_ETAT . " = 0\n\t\tLEFT JOIN " . RemiseChequeManager::TABLE_REMISECHEQUE . "\n\t\t\tON " . OperationRemiseChequeManager::CHAMP_OPERATIONREMISECHEQUE_ID_REMISE_CHEQUE . " = " . RemiseChequeManager::CHAMP_REMISECHEQUE_ID . "\n\t\tWHERE " . OperationManager::CHAMP_OPERATION_TYPE . " = 0\n\t\t\tAND " . OperationManager::CHAMP_OPERATION_TYPE_PAIEMENT . " in (1,2)\n\t\t\tAND " . OperationManager::CHAMP_OPERATION_TYPE_PAIEMENT . " = '" . StringUtils::securiser($pTypePaiement) . "'\n\t\tORDER BY " . OperationManager::CHAMP_OPERATION_DATE . ";"; $lLogger->log("Execution de la requete : " . $lRequete, PEAR_LOG_DEBUG); // Maj des logs $lSql = Dbutils::executerRequete($lRequete); $lListeOperationAttente = array(); if (mysql_num_rows($lSql) > 0) { $lOpeId = NULL; $lChampComplementaire = array(); while ($lLigne = mysql_fetch_assoc($lSql)) { if ($lOpeId != $lLigne[OperationManager::CHAMP_OPERATION_ID]) { if (!is_null($lOpeId)) { $lOperationAttente->setOpeTypePaiementChampComplementaire($lChampComplementaire); $lListeOperationAttente[$lOpeId] = $lOperationAttente; } $lOpeId = $lLigne[OperationManager::CHAMP_OPERATION_ID]; $lOperationAttente = OperationManager::remplirOperationAttenteFermeEntete($lLigne[FermeManager::CHAMP_FERME_ID], $lLigne[FermeManager::CHAMP_FERME_NUMERO], $lLigne[FermeManager::CHAMP_FERME_NOM], $lLigne[CompteManager::CHAMP_COMPTE_LABEL], $lLigne[CompteManager::CHAMP_COMPTE_SOLDE], $lLigne[OperationManager::CHAMP_OPERATION_MONTANT], $lLigne[OperationManager::CHAMP_OPERATION_TYPE_PAIEMENT], $lLigne[OperationManager::CHAMP_OPERATION_DATE], $lLigne[OperationManager::CHAMP_OPERATION_LIBELLE], $lLigne[OperationManager::CHAMP_OPERATION_ID], $lLigne[OperationRemiseChequeManager::CHAMP_OPERATIONREMISECHEQUE_ID_REMISE_CHEQUE], $lLigne[RemiseChequeManager::CHAMP_REMISECHEQUE_NUMERO]); } if (!is_null($lLigne[OperationChampComplementaireManager::CHAMP_OPERATIONCHAMPCOMPLEMENTAIRE_CHCP_ID])) { $lChampComplementaire[$lLigne[OperationChampComplementaireManager::CHAMP_OPERATIONCHAMPCOMPLEMENTAIRE_CHCP_ID]] = OperationManager::remplirOperationDetail(NULL, NULL, NULL, NULL, NULL, $lLigne[OperationChampComplementaireManager::CHAMP_OPERATIONCHAMPCOMPLEMENTAIRE_CHCP_ID], NULL, NULL, NULL, $lLigne[OperationManager::CHAMP_OPERATION_ID], $lLigne[OperationChampComplementaireManager::CHAMP_OPERATIONCHAMPCOMPLEMENTAIRE_VALEUR]); } } $lOperationAttente->setOpeTypePaiementChampComplementaire($lChampComplementaire); $lListeOperationAttente[$lOpeId] = $lOperationAttente; } else { $lListeOperationAttente[0] = new OperationAttenteFermeVO(); } return $lListeOperationAttente; }
/** * @name getListeChequeCaisse($pIdMarche) * @return array(OperationAttenteAdherentVO) * @desc Récupères toutes les opérations chèque du marché et les renvoie sous forme d'une collection de OperationAttenteAdherentVO */ public static function getListeChequeCaisse($pIdMarche) { return OperationManager::operationMarche($pIdMarche, 2); }
<?php //classes loading begin function classLoad($myClass) { if (file_exists('../model/' . $myClass . '.php')) { include '../model/' . $myClass . '.php'; } elseif (file_exists('../controller/' . $myClass . '.php')) { include '../controller/' . $myClass . '.php'; } } spl_autoload_register("classLoad"); include '../config.php'; //classes loading end session_start(); //post input processing $idContrat = $_POST['idContrat']; $idProjet = $_POST['idProjet']; if (!empty($_POST['dateOperation']) && !empty($_POST['montant'])) { $idOperation = $_POST['idOperation']; $dateOperation = htmlentities($_POST['dateOperation']); $montant = htmlentities($_POST['montant']); $operation = new Operation(array('id' => $idOperation, 'date' => $dateOperation, 'montant' => $montant)); $operationsManager = new OperationManager($pdo); $operationsManager->update($operation); $_SESSION['operation-update-success'] = "<strong>Opération valide : </strong>Opération modifiée avec succès."; header('Location:../operations.php?idContrat=' . $idContrat . '&idProjet=' . $idProjet); } else { $_SESSION['operation-update-error'] = "<strong>Erreur modification opération : </strong>Vous devez remplir les champs 'Date opération' et 'Montant'."; header('Location:../operations.php?idContrat=' . $idContrat . '&idProjet=' . $idProjet); }
/** * @name selectOperationAchat($pIdCompte, $pIdMarche) * @param int(11) IdCompte * @param int(11) IdMarche * @return array(OperationVO) * @desc Retourne une liste d'operation */ public function selectOperationAchat($pIdCompte, $pIdMarche) { return OperationManager::selectOperationAchat($pIdCompte, $pIdMarche); }
if (file_exists('../model/' . $myClass . '.php')) { include '../model/' . $myClass . '.php'; } elseif (file_exists('../controller/' . $myClass . '.php')) { include '../controller/' . $myClass . '.php'; } } spl_autoload_register("classLoad"); include '../config.php'; //classes loading end session_start(); if (isset($_SESSION['userMerlaTrav']) and $_SESSION['userMerlaTrav']->profil() == "admin") { //classes managers $clientManager = new ClientManager($pdo); $contratManager = new ContratManager($pdo); $projetManager = new ProjetManager($pdo); $operationManager = new OperationManager($pdo); $appartementManager = new AppartementManager($pdo); $locauxManager = new LocauxManager($pdo); //classes and attributes $bien = ""; $idOperation = $_GET['idOperation']; $operation = $operationManager->getOperationById($idOperation); $contrat = $contratManager->getContratById($operation->idContrat()); $client = $clientManager->getClientById($contrat->idClient()); $projet = $projetManager->getProjetById($contrat->idProjet()); $typeBien = ""; $etage = ""; $expressionOrthographe = ""; if ($contrat->typeBien() == "appartement") { $bien = $appartementManager->getAppartementById($contrat->idBien()); $typeBien = "Appartement";
} elseif(file_exists('controller/'.$myClass.'.php')){ include('controller/'.$myClass.'.php'); } } spl_autoload_register("classLoad"); include('config.php'); include('lib/pagination.php'); //classes loading end session_start(); if( isset($_SESSION['userMerlaTrav']) ){ //classes $projetManager = new ProjetManager($pdo); $clientManager = new ClientManager($pdo); $contratManager = new ContratManager($pdo); $operationManager = new OperationManager($pdo); $compteBancaireManager = new CompteBancaireManager($pdo); //objs $operations =$operationManager->getOpenOperationsGroupByMonth(); $operationsNonValidees = $operationManager->getOperationsNonValidees(); ?> <!DOCTYPE html> <!--[if IE 8]> <html lang="en" class="ie8"> <![endif]--> <!--[if IE 9]> <html lang="en" class="ie9"> <![endif]--> <!--[if !IE]><!--> <html lang="en"> <!--<![endif]--> <!-- BEGIN HEAD --> <head> <meta charset="utf-8" /> <title>ImmoERP - Management Application</title> <meta content="width=device-width, initial-scale=1.0" name="viewport" /> <meta content="" name="description" />
/** * @name rechercheListeFacture() * @return array(FactureVO) * @desc Retourne une liste de Facture */ public function rechercheListeFacture($pDateDebut = null, $pDateFin = null, $pIdMarche = null) { $lTypeRecherche = array(); $lTypeCritere = array(); $lCritereRecherche = array(); if (!is_null($pDateDebut)) { array_push($lTypeRecherche, OperationManager::CHAMP_OPERATION_DATE); array_push($lTypeCritere, '>='); array_push($lCritereRecherche, $pDateDebut); } if (!is_null($pDateFin)) { array_push($lTypeRecherche, OperationManager::CHAMP_OPERATION_DATE); array_push($lTypeCritere, '<='); array_push($lCritereRecherche, $pDateFin); } if (!is_null($pIdMarche)) { array_push($lTypeRecherche, 'marche.' . OperationChampComplementaireManager::CHAMP_OPERATIONCHAMPCOMPLEMENTAIRE_VALEUR); array_push($lTypeCritere, '='); if ($pIdMarche == -1) { // Pour les factures hors marché array_push($lCritereRecherche, NULL); } else { array_push($lCritereRecherche, $pIdMarche); } } return OperationManager::rechercheListeFacture($lTypeRecherche, $lTypeCritere, $lCritereRecherche, array(''), array('')); }
include('config.php'); include('lib/pagination.php'); //classes loading end session_start(); if( isset($_SESSION['userMerlaTrav']) ) { if( isset($_GET['idProjet']) ){ $idProjet = $_GET['idProjet']; } //destroy contrat-form-data session if ( isset($_SESSION['contrat-form-data']) ) { unset($_SESSION['contrat-form-data']); } $projetManager = new ProjetManager($pdo); $clientManager = new ClientManager($pdo); $contratManager = new ContratManager($pdo); $operationManager = new OperationManager($pdo); $compteBancaireManager = new CompteBancaireManager($pdo); /*$codeContrat = $_GET['codeContrat']; $comptesBancaires = $compteBancaireManager->getCompteBancaires(); $contrat = $contratManager->getContratByCode($codeContrat); $projet = $projetManager->getProjetById($contrat->idProjet()); $client = $clientManager->getClientById($contrat->idClient()); $sommeOperations = $operationManager->sommeOperations($contrat->id()); $biens = ""; $niveau = ""; if($contrat->typeBien()=="appartement"){ $appartementManager = new AppartementManager($pdo); $biens = $appartementManager->getAppartementById($contrat->idBien());
spl_autoload_register("classLoad"); include 'config.php'; include 'lib/pagination.php'; //classes loading end session_start(); if (isset($_SESSION['userMerlaTrav'])) { //les sources $idProjet = 0; $projetManager = new ProjetManager($pdo); $contratManager = new ContratManager($pdo); if (isset($_GET['idProjet']) and $_GET['idProjet'] > 0 and $_GET['idProjet'] <= $projetManager->getLastId() and (isset($_GET['idContrat']) and ($_GET['idContrat'] > 0 and $_GET['idContrat'] <= $contratManager->getLastId()))) { $idProjet = $_GET['idProjet']; $idContrat = $_GET['idContrat']; $projet = $projetManager->getProjetById($idProjet); $contrat = $contratManager->getContratById($idContrat); $operationManager = new OperationManager($pdo); $operations = ""; //test the locaux object number: if exists get operations else do nothing $operationsNumber = $operationManager->getOpertaionsNumberByIdContrat($idContrat); if ($operationsNumber != 0) { $operations = $operationManager->getOperationsByIdContrat($idContrat); } } ?> <!DOCTYPE html> <!--[if IE 8]> <html lang="en" class="ie8"> <![endif]--> <!--[if IE 9]> <html lang="en" class="ie9"> <![endif]--> <!--[if !IE]><!--> <html lang="en"> <!--<![endif]--> <!-- BEGIN HEAD --> <head> <meta charset="utf-8" />
//classes loading end session_start(); if (isset($_SESSION['userMerlaTrav']) and isset($_GET['idProjet'])) { //classes managers $usersManager = new UserManager($pdo); $mailsManager = new MailManager($pdo); $notesClientsManager = new NotesClientManager($pdo); $projetManager = new ProjetManager($pdo); $contratManager = new ContratManager($pdo); $clientManager = new ClientManager($pdo); $livraisonsManager = new LivraisonManager($pdo); $fournisseursManager = new FournisseurManager($pdo); $reglementsFournisseurManager = new ReglementFournisseurManager($pdo); $caisseEntreesManager = new CaisseEntreesManager($pdo); $caisseSortiesManager = new CaisseSortiesManager($pdo); $operationsManager = new OperationManager($pdo); //classes and vars $idProjet = $_GET['idProjet']; $projet = $projetManager->getProjetById($idProjet); //users number $usersNumber = $usersManager->getUsersNumber(); $mailsNumberToday = $mailsManager->getMailsNumberToday(); $mailsToday = $mailsManager->getMailsToday(); $clientWeek = $clientManager->getClientsWeek(); $clientNumberWeek = $clientManager->getClientsNumberWeek(); $livraisonsWeek = $livraisonsManager->getLivraisonsWeek(); $livraisonsNumberWeek = $livraisonsManager->getLivraisonsNumberWeek(); $operationsNumberWeek = $operationsManager->getOperationNumberWeek(); //get contacts ids and get sum of client operations $idsContrats = $contratManager->getContratIdsByIdProjet($_GET['idProjet']); $sommeOperationsClients = 0;
//This variable projetContrat defines the actions choosed by the user : Ignorer || a Project $projetContrat = htmlentities($_POST['projet-contrat']); $montant = htmlentities($_POST['montant']); $dateOperation = htmlentities($_POST['dateOperation']); $dateReglement = htmlentities($_POST['dateReglement']); $dateOperation = DateTime::createFromFormat('d/m/Y', trim($dateOperation)); $dateReglement = DateTime::createFromFormat('d/m/Y', trim($dateReglement)); $dateOperation = $dateOperation->format('Y-m-d'); $dateReglement = $dateReglement->format('Y-m-d'); //$designation = htmlentities($_POST['designation']); if ($projetContrat == "Ignorer") { $releveBancaireManager->delete($idReleveBancaire); $actionMessage = "<strong>Opération Valide</strong> : Releve Bancaire traité avec succès."; $typeMessage = "success"; } else { $operationManager = new OperationManager($pdo); //$reference = 'Q'.date('Ymd-his'); $reference = htmlentities($_POST['reference']); $modePaiement = htmlentities($_POST['mode-paiement']); $numeroOperation = htmlentities($_POST['reference']); $compteBancaire = htmlentities($_POST['compte-bancaire']); $status = 1; //$observation ="Ce réglement client fait référence à la ligne : ".$idReleveBancaire." du relevé bancaire du compte bancaire : ".$compteBancaire; $observation = htmlentities($_POST['observation']); $idContrat = htmlentities($_POST['contrat-client']); $updatedBy = $_SESSION['userMerlaTrav']->login(); $updated = date('Y-m-d h:i:s'); //echo $_POST['idOperation']; if (isset($_POST['idOperation'])) { $idOperation = $_POST['idOperation']; $operation = new Operation(array('id' => $idOperation, 'date' => $dateOperation, 'dateReglement' => $dateReglement, 'status' => $status, 'montant' => $montant, 'compteBancaire' => $compteBancaire, 'observation' => $observation, 'reference' => $reference, 'modePaiement' => $modePaiement, 'numeroCheque' => $numeroOperation, 'updatedBy' => $updatedBy, 'updated' => $updated));
<?php //classes loading begin function classLoad($myClass) { if (file_exists('../model/' . $myClass . '.php')) { include '../model/' . $myClass . '.php'; } elseif (file_exists('../controller/' . $myClass . '.php')) { include '../controller/' . $myClass . '.php'; } } spl_autoload_register("classLoad"); include '../config.php'; //classes loading end session_start(); //post input processing $idProjet = $_POST['idProjet']; $idContrat = $_POST['idContrat']; $idOperation = $_POST['idOperation']; $operationManager = new OperationManager($pdo); $operationManager->delete($idOperation); $_SESSION['operation-delete-success'] = "<strong>Opération valide : </strong>Opération supprimée avec succès."; header('Location:../operations.php?idContrat=' . $idContrat . '&idProjet=' . $idProjet);
include 'config.php'; include 'lib/pagination.php'; //classes loading end session_start(); if (isset($_SESSION['userMerlaTrav'])) { if (isset($_GET['idProjet'])) { $idProjet = $_GET['idProjet']; } //destroy contrat-form-data session if (isset($_SESSION['contrat-form-data'])) { unset($_SESSION['contrat-form-data']); } $projetManager = new ProjetManager($pdo); $clientManager = new ClientManager($pdo); $contratManager = new ContratManager($pdo); $operationManager = new OperationManager($pdo); $compteBancaireManager = new CompteBancaireManager($pdo); /*$codeContrat = $_GET['codeContrat']; $comptesBancaires = $compteBancaireManager->getCompteBancaires(); $contrat = $contratManager->getContratByCode($codeContrat); $projet = $projetManager->getProjetById($contrat->idProjet()); $client = $clientManager->getClientById($contrat->idClient()); $sommeOperations = $operationManager->sommeOperations($contrat->id()); $biens = ""; $niveau = ""; if($contrat->typeBien()=="appartement"){ $appartementManager = new AppartementManager($pdo); $biens = $appartementManager->getAppartementById($contrat->idBien()); $niveau = $biens->niveau();
/** * @name remplirAdherent($pId, $pNumero, $pIdCompte, $pNom, $pPrenom, $pCourrielPrincipal, $pCourrielSecondaire, $pTelephonePrincipal, $pTelephoneSecondaire, $pAdresse, $pCodePostal, $pVille, $pDateNaissance, $pDateAdhesion, $pDateMaj, $pCommentaire) * @param integer * @param string * @param integer * @param string * @param string * @param string * @param string * @param string * @param string * @param string * @param string * @param string * @param date * @param date * @param date * @param string * @return AdherentSoldeVO * @desc Retourne un AdherentSoldeVO remplis */ private static function remplirAdherent($pId, $pNumero, $pIdCompte, $pNom, $pPrenom, $pCourrielPrincipal, $pCourrielSecondaire, $pTelephonePrincipal, $pTelephoneSecondaire, $pAdresse, $pCodePostal, $pVille, $pDateNaissance, $pDateAdhesion, $pDateMaj, $pCommentaire) { $lAdherent = new AdherentSoldeVO(); $lAdherent->setId($pId); $lAdherent->setNumero($pNumero); $lAdherent->setIdCompte($pIdCompte); $lAdherent->setNom($pNom); $lAdherent->setPrenom($pPrenom); $lAdherent->setCourrielPrincipal($pCourrielPrincipal); $lAdherent->setCourrielSecondaire($pCourrielSecondaire); $lAdherent->setTelephonePrincipal($pTelephonePrincipal); $lAdherent->setTelephoneSecondaire($pTelephoneSecondaire); $lAdherent->setAdresse($pAdresse); $lAdherent->setCodePostal($pCodePostal); $lAdherent->setVille($pVille); $lAdherent->setDateNaissance($pDateNaissance); $lAdherent->setDateAdhesion($pDateAdhesion); $lAdherent->setDateMaj($pDateMaj); $lAdherent->setCommentaire($pCommentaire); // Ajout des Opérations $lAdherent->setListeOperation(OperationManager::selectByIdCompte($lAdherent->getIdCompte())); // Ajout du montant du solde $lAdherent->setSolde(OperationManager::soldeAdherent($lAdherent->getId())); return $lAdherent; }
include '../lib/image-processing.php'; //classes loading end session_start(); //post input processing $action = htmlentities($_POST['action']); //In this session variable we put all the POST, to get it in the contrats-add file //in case of error, and this help the user to do not put again what he filled out. $_SESSION['operation-data-form'] = $_POST; //This var contains result message of CRUD action $actionMessage = ""; $typeMessage = ""; $redirectLink = ""; //process begins //The History Component is used in all ActionControllers to mention a historical version of each action $historyManager = new HistoryManager($pdo); $operationManager = new OperationManager($pdo); if ($action == "add") { if (!empty($_POST['montant']) and !empty($_POST['numeroOperation'])) { $montant = htmlentities($_POST['montant']); $modePaiement = htmlentities($_POST['modePaiement']); $numeroOperation = htmlentities($_POST['numeroOperation']); $dateOperation = htmlentities($_POST['dateOperation']); $dateReglement = htmlentities($_POST['dateReglement']); $compteBancaire = htmlentities($_POST['compteBancaire']); $observation = htmlentities($_POST['observation']); $idContrat = htmlentities($_POST['idContrat']); $createdBy = $_SESSION['userMerlaTrav']->login(); $created = date('Y-m-d h:i:s'); $operation = new Operation(array('date' => $dateOperation, 'dateReglement' => $dateReglement, 'montant' => $montant, 'compteBancaire' => $compteBancaire, 'observation' => $observation, 'modePaiement' => $modePaiement, 'idContrat' => $idContrat, 'numeroCheque' => $numeroOperation, 'createdBy' => $createdBy, 'created' => $created)); $operationManager->add($operation); //add History data
include 'config.php'; include 'lib/pagination.php'; //classes loading end session_start(); if (isset($_SESSION['userMerlaTrav'])) { if (isset($_GET['idProjet'])) { $idProjet = $_GET['idProjet']; } //destroy contrat-form-data session if (isset($_SESSION['contrat-form-data'])) { unset($_SESSION['contrat-form-data']); } $projetManager = new ProjetManager($pdo); $clientManager = new ClientManager($pdo); $contratManager = new ContratManager($pdo); $operationManager = new OperationManager($pdo); $compteBancaireManager = new CompteBancaireManager($pdo); $contratCasLibreManager = new ContratCasLibreManager($pdo); $reglementPrevuManager = new ReglementPrevuManager($pdo); if (isset($_GET['codeContrat']) and (bool) $contratManager->getCodeContrat($_GET['codeContrat'])) { $codeContrat = $_GET['codeContrat']; $comptesBancaires = $compteBancaireManager->getCompteBancaires(); $contrat = $contratManager->getContratByCode($codeContrat); //ContratCasLibre Elements $contratCasLibreNumber = $contratCasLibreManager->getContratCasLibreNumberByCodeContrat($codeContrat); $contratCasLibreElements = ""; $contratCasLibreTitle = ""; if ($contratCasLibreNumber > 0) { $contratCasLibreTitle = "<h4>Informations Supplémentaires</h4>"; $contratCasLibreElements = $contratCasLibreManager->getContratCasLibresByCodeContrat($codeContrat); }
//classes loading end session_start(); //post input processing $idContrat = htmlentities($_POST['idContrat']); $idProjet = htmlentities($_POST['idProjet']); if (!empty($_POST['dateOperation']) && !empty($_POST['montant'])) { $dateOperation = htmlentities($_POST['dateOperation']); $montant = htmlentities($_POST['montant']); $modePaiement = htmlentities($_POST['modePaiement']); $numeroCheque = 0; if (isset($_POST['numeroCheque'])) { $numeroCheque = htmlentities($_POST['numeroCheque']); } //create a new Operation object $operation = new Operation(array('date' => $dateOperation, 'montant' => $montant, 'modePaiement' => $modePaiement, 'idContrat' => $idContrat, 'numeroCheque' => $numeroCheque)); $operationManager = new OperationManager($pdo); $operationManager->add($operation); $_SESSION['operation-add-success'] = "<strong>Opération valide</strong> : L'opération de paiement est ajoutée avec succès."; $_SESSION['print-quittance'] = "print-quittance"; $redirectLink = 'Location:../operations.php?idContrat=' . $idContrat . '&idProjet=' . $idProjet; if (isset($_GET['p']) and $_GET['p'] == 99) { $redirectLink = 'Location:../contrats-list.php?idProjet=' . $idProjet; } else { if (isset($_GET['p']) and $_GET['p'] == 999) { $redirectLink = 'Location:../clients-search.php'; } } header($redirectLink); } else { $_SESSION['operation-add-error'] = "<strong>Erreur ajout opération</strong> : Vous devez remplir les champs 'Date opération' et 'Montant'."; $redirectLink = 'Location:../operations.php?idContrat=' . $idContrat . '&idProjet=' . $idProjet;
include '../lib/image-processing.php'; //classes loading end session_start(); //post input processing $action = htmlentities($_POST['action']); //In this session variable we put all the POST, to get it in the contrats-add file //in case of error, and this help the user to do not put again what he filled out. $_SESSION['operation-data-form'] = $_POST; //This var contains result message of CRUD action $actionMessage = ""; $typeMessage = ""; $redirectLink = ""; //process begins //The History Component is used in all ActionControllers to mention a historical version of each action $historyManager = new HistoryManager($pdo); $operationManager = new OperationManager($pdo); $projetManager = new ProjetManager($pdo); $clientManager = new ClientManager($pdo); if ($action == "add") { if (!empty($_POST['montant']) and !empty($_POST['numeroOperation'])) { $reference = 'Q' . date('Ymd-his'); $montant = htmlentities($_POST['montant']); $modePaiement = htmlentities($_POST['modePaiement']); $numeroOperation = htmlentities($_POST['numeroOperation']); $dateOperation = htmlentities($_POST['dateOperation']); $dateReglement = htmlentities($_POST['dateReglement']); $compteBancaire = htmlentities($_POST['compteBancaire']); $observation = htmlentities($_POST['observation']); $status = 0; $idContrat = htmlentities($_POST['idContrat']); $createdBy = $_SESSION['userMerlaTrav']->login();
/** * @name selectOperationReservation($pId, $pActive) * @param IdReservation * @param bool * @return array(OperationVO) * @desc Retourne une liste d'operation */ public function selectOperationReservation($pId, $pActive = false) { return OperationManager::selectOperationReservation($pId, $pActive); }
<?php //classes loading begin function classLoad($myClass) { if (file_exists('../model/' . $myClass . '.php')) { include '../model/' . $myClass . '.php'; } elseif (file_exists('../controller/' . $myClass . '.php')) { include '../controller/' . $myClass . '.php'; } } spl_autoload_register("classLoad"); include '../config.php'; //classes loading end session_start(); //post input processing $idContrat = $_POST['idContrat']; $idProjet = $_POST['idProjet']; $idOperation = $_POST['idOperation']; if (!empty($_POST['numeroCheque'])) { $numeroCheque = htmlentities($_POST['numeroCheque']); $operationsManager = new OperationManager($pdo); $operationsManager->updateNumeroCheque($numeroCheque, $idOperation); $_SESSION['operation-update-success'] = "<strong>Opération valide : </strong>Numéro de chèque modifiée avec succès."; header('Location:../operations.php?idContrat=' . $idContrat . '&idProjet=' . $idProjet); } else { $_SESSION['operation-update-error'] = "<strong>Erreur modification opération : </strong>Vous devez remplir le champ 'Numéro de chèque'."; header('Location:../operations.php?idContrat=' . $idContrat . '&idProjet=' . $idProjet); }
include 'config.php'; //classes loading end session_start(); if (isset($_SESSION['userMerlaTrav'])) { //classes managers $usersManager = new UserManager($pdo); $mailsManager = new MailManager($pdo); $notesClientsManager = new NotesClientManager($pdo); $projetManager = new ProjetManager($pdo); $contratManager = new ContratManager($pdo); $clientManager = new ClientManager($pdo); $livraisonsManager = new LivraisonManager($pdo); $fournisseursManager = new FournisseurManager($pdo); $caisseManager = new CaisseManager($pdo); $caisseIaazaManager = new CaisseIaazaManager($pdo); $operationsManager = new OperationManager($pdo); $compteBancaire = new CompteBancaireManager($pdo); //classes and vars //users number $soldeCaisseAnnahda = $caisseManager->getTotalCaisseByType("Entree") - $caisseManager->getTotalCaisseByType("Sortie"); $soldeCaisseIaaza = $caisseIaazaManager->getTotalCaisseByType("Entree") - $caisseIaazaManager->getTotalCaisseByType("Sortie"); $projetNumber = $projetManager->getProjetsNumber(); $usersNumber = $usersManager->getUsersNumber(); $fournisseurNumber = $fournisseursManager->getFournisseurNumbers(); $mailsNumberToday = $mailsManager->getMailsNumberToday(); $mailsToday = $mailsManager->getMailsToday(); $clientWeek = $clientManager->getClientsWeek(); $clientNumberWeek = $clientManager->getClientsNumberWeek(); $livraisonsNumber = $livraisonsManager->getLivraisonNumber(); $livraisonsWeek = $livraisonsManager->getLivraisonsWeek(); $livraisonsNumberWeek = $livraisonsManager->getLivraisonsNumberWeek();
// Création d'un nouveau compte, si il n'existe pas déjà $lCompte = new CompteVO(); $lCompte->setLabel($lCompteLabel); $lSolde = str_replace(",", ".", $lCompteSolde); $lCompte->setSolde($lSolde); $lIdCompte = CompteManager::insert($lCompte); // Initialisation du compte si c'est un nouveau compte $lOperation = new OperationVO(); $lOperation->setIdCompte($lIdCompte); $lOperation->setMontant($lSolde); $lOperation->setLibelle("Création du compte"); $lOperation->setDate(StringUtils::dateAujourdhuiDb()); //$lOperation->setType(1); $lOperation->setIdCommande(0); $lOperation->setTypePaiement(-1); OperationManager::insert($lOperation); } //L'adhérent $lAdherent = new AdherentVO(); $lAdherent->setIdCompte($lIdCompte); $lAdherent->setNumero($lNumero); $lAdherent->setNom(StringUtils::formaterNom(trim($lNom))); $lAdherent->setPrenom(StringUtils::formaterPrenom(trim($lPrenom))); $lAdherent->setCourrielPrincipal(trim($lCourrielP)); $lAdherent->setCourrielSecondaire(trim($lCourrielS)); $lAdherent->setTelephonePrincipal(trim($lTelephoneP)); $lAdherent->setTelephoneSecondaire(trim($lTelephoneS)); $lAdherent->setAdresse(trim($lAdresse)); $lAdherent->setCodePostal(trim($lCodePostal)); $lAdherent->setVille(StringUtils::formaterVille(trim($lVille))); $lAdherent->setDateNaissance($lDateNaissance);
//add it to db $historyManager->add($history); $actionMessage = "<strong>Opération Valide</strong> : Paiement Ajouté avec succès."; $typeMessage = "success"; } else { $actionMessage = "<strong>Erreur Ajout Paiement Client</strong> : Vous devez remplir les champs <strong>Montant</strong> et <strong>Numéro Opération</strong>."; $typeMessage = "error"; } } else { if ($action == "updatePiece") { $codeContrat = htmlentities($_POST['codeContrat']); $url = ""; $idOperation = htmlentities($_POST['idOperation']); if (file_exists($_FILES['urlPiece']['tmp_name']) || is_uploaded_file($_FILES['urlPiece']['tmp_name'])) { $url = imageProcessing($_FILES['urlPiece'], '/pieces/pieces_reglements/'); $operationManager = new OperationManager($pdo); $operationManager->updatePiece($idOperation, $url); $actionMessage = "<strong>Opération valide : </strong>La pièce de réglement est modifiée avec succès."; $typeMessage = "success"; //add history data to db $historyManager = new HistoryManager($pdo); $createdBy = $_SESSION['userMerlaTrav']->login(); $created = date('Y-m-d h:i:s'); $history = new History(array('action' => "Modification Pièce réglement", 'target' => "Table des réglements clients", 'description' => "Modification de la pièce de régelement - Opération : " . $idOperation, 'created' => $created, 'createdBy' => $createdBy)); //add it to db $historyManager->add($history); } else { $actionMessage = "<strong>Erreur Modification Pièce de réglement : </strong>Vous devez séléctionner un fichier."; $typeMessage = "error"; } } else {
//classes managers $appartementManager = new AppartementManager($pdo); $locauxManager = new LocauxManager($pdo); $usersManager = new UserManager($pdo); $projetManager = new ProjetManager($pdo); $contratManager = new ContratManager($pdo); $clientManager = new ClientManager($pdo); $chargeManager = new ChargeManager($pdo); $chargeCommunManager = new ChargeCommunManager($pdo); $livraisonsManager = new LivraisonManager($pdo); $livraisonDetailManager = new LivraisonDetailManager($pdo); $fournisseursManager = new FournisseurManager($pdo); $reglementsFournisseurManager = new ReglementFournisseurManager($pdo); $caisseEntreesManager = new CaisseEntreesManager($pdo); $caisseSortiesManager = new CaisseSortiesManager($pdo); $operationsManager = new OperationManager($pdo); //classes and vars $idProjet = $_GET['idProjet']; $projet = $projetManager->getProjetById($idProjet); //Container 1 : Statistiques $chiffreAffaireTheorique = ceil( $appartementManager->getTotalPrixAppartementsByIdProjet($idProjet) + $locauxManager->getTotalPrixLocauxByIdProjet($idProjet) ); //get contacts ids and get sum of client operations $idsContrats = $contratManager->getContratActifIdsByIdProjet($idProjet); $sommeOperationsClients = 0; $sommePrixVente = 0;
include 'controller/' . $myClass . '.php'; } } spl_autoload_register("classLoad"); include 'config.php'; include 'lib/pagination.php'; //classes loading end session_start(); if (isset($_SESSION['userMerlaTrav'])) { //les sources $projetManager = new ProjetManager($pdo); $clientManager = new ClientManager($pdo); $companyManager = new CompanyManager($pdo); $contratManager = new ContratManager($pdo); $compteBancaireManager = new CompteBancaireManager($pdo); $operationManager = new OperationManager($pdo); $locauxManager = new LocauxManager($pdo); $appartementManager = new AppartementManager($pdo); $comptesBancaires = $compteBancaireManager->getCompteBancaires(); //obj and vars $contrats = $contratManager->getContratsToChange(); ?> <!DOCTYPE html> <!--[if IE 8]> <html lang="en" class="ie8"> <![endif]--> <!--[if IE 9]> <html lang="en" class="ie9"> <![endif]--> <!--[if !IE]><!--> <html lang="en"> <!--<![endif]--> <!-- BEGIN HEAD --> <head> <meta charset="utf-8" /> <title>ImmoERP - Management Application</title> <meta content="width=device-width, initial-scale=1.0" name="viewport" />
include '../model/' . $myClass . '.php'; } elseif (file_exists('../controller/' . $myClass . '.php')) { include '../controller/' . $myClass . '.php'; } } spl_autoload_register("classLoad"); include '../config.php'; //classes loading end session_start(); if (isset($_SESSION['userMerlaTrav']) and $_SESSION['userMerlaTrav']->profil() == "admin") { //classes managers $idProjet = 0; $projetManager = new ProjetManager($pdo); $clientManager = new ClientManager($pdo); $contratManager = new ContratManager($pdo); $operationManager = new OperationManager($pdo); $contratCasLibreManager = new ContratCasLibreManager($pdo); $reglementPrevuManager = new ReglementPrevuManager($pdo); if (isset($_GET['codeContrat']) and (bool) $contratManager->getCodeContrat($_GET['codeContrat'])) { $codeContrat = $_GET['codeContrat']; $contrat = $contratManager->getContratByCode($codeContrat); $projet = $projetManager->getProjetById($contrat->idProjet()); $client = $clientManager->getClientById($contrat->idClient()); $sommeOperations = $operationManager->sommeOperations($contrat->id()); $biens = ""; $typeBien = ""; $niveau = ""; if ($contrat->typeBien() == "appartement") { $appartementManager = new AppartementManager($pdo); $biens = $appartementManager->getAppartementById($contrat->idBien()); $typeBien = "Appartement";
} // some frameworks (namely angularjs) send information in application/json format, we try to adapt to those system with the next if if (empty($_REQUEST)) { $data = json_decode(file_get_contents("php://input")); if (is_object($data) and !empty($data->operation)) { $_POST = get_object_vars($data); // only post is affected by this $_REQUEST = $_POST; } } $operation = vtws_getParameter($_REQUEST, "operation"); $operation = strtolower($operation); $format = vtws_getParameter($_REQUEST, "format", "json"); $sessionId = vtws_getParameter($_REQUEST, "sessionName"); $sessionManager = new SessionManager(); $operationManager = new OperationManager($adb, $operation, $format, $sessionManager); try { if (!$sessionId || strcasecmp($sessionId, "null") === 0) { $sessionId = null; } $input = $operationManager->getOperationInput(); $adoptSession = false; if (strcasecmp($operation, "extendsession") === 0) { if (isset($input['operation'])) { // Workaround fix for PHP 5.3.x: $_REQUEST doesn't have PHPSESSID if (isset($_REQUEST['PHPSESSID'])) { $sessionId = vtws_getParameter($_REQUEST, "PHPSESSID"); } else { // NOTE: Need to evaluate for possible security issues $sessionId = vtws_getParameter($_COOKIE, 'PHPSESSID'); }
function classLoad ($myClass) { if(file_exists('model/'.$myClass.'.php')){ include('model/'.$myClass.'.php'); } elseif(file_exists('controller/'.$myClass.'.php')){ include('controller/'.$myClass.'.php'); } } spl_autoload_register("classLoad"); include('config.php'); include('lib/pagination.php'); //classes loading end session_start(); if( isset($_SESSION['userMerlaTrav']) ){ //les sources $operationManager = new OperationManager($pdo); $operations =$operationManager->getOperationsGroupByMonth(); ?> <!DOCTYPE html> <!--[if IE 8]> <html lang="en" class="ie8"> <![endif]--> <!--[if IE 9]> <html lang="en" class="ie9"> <![endif]--> <!--[if !IE]><!--> <html lang="en"> <!--<![endif]--> <!-- BEGIN HEAD --> <head> <meta charset="utf-8" /> <title>ImmoERP - Management Application</title> <meta content="width=device-width, initial-scale=1.0" name="viewport" /> <meta content="" name="description" /> <meta content="" name="author" /> <link href="assets/bootstrap/css/bootstrap.min.css" rel="stylesheet" /> <link href="assets/css/metro.css" rel="stylesheet" />