Пример #1
0
        $sql = "DELETE FROM " . $xoopsDB->prefix('garage_intervention') . " WHERE id='" . $id_inter . "'";
        $xoopsDB->queryF($sql) or die("Erreur requete : " . $sql . '<br />');
        // suppression des heures saisies
        $sql = "DELETE FROM " . $xoopsDB->prefix('garage_inter_temp') . " WHERE id_inter='" . $id_inter . "'";
        $xoopsDB->queryF($sql) or die("Erreur requete : " . $sql . '<br />');
        // suppression des pieces saisies
        $sql = "DELETE FROM " . $xoopsDB->prefix('garage_inter_pieces') . " WHERE id_inter='" . $id_inter . "'";
        $xoopsDB->queryF($sql) or die("Erreur requete : " . $sql . '<br />');
        redirect_header("intervention.php", 2, _AM_INTER_DELETED);
        break;
}
// fin du switch
if (empty($op)) {
    Xoops_Cp_Header();
    garage_tabsAdminMenu("trash.php");
    doc_info('Trash');
    echo "<style> \n\t\t\t\t\t.encours {background-color: #E6FFE6; padding: 5px;}\n\t\t\t\t\t.solde {background-color: #CAFAFF; padding: 5px;}\n\t\t\t\t\t.archive {background-color: #CAE2FF; padding: 5px;}\n\t\t\t\t\t.deleted {background-color: #FF0000; padding: 5px;}\n\t\t\t\t\t</style>";
    $etat_des = _AM_INTER_TRASHED;
    $style = 'deleted';
    echo "<table width='100%'><tr><td align='center'><img src='images/logo.jpg' alt='' title=''></td></tr></table><br />\n";
    echo "<h1>" . $etat_des . "</h1>";
    // on affiche uniquement les interventions de la corbeille (etat a 9)
    $result = $xoopsDB->query("SELECT id, id_voiture, date_debut, date_fin, delai, solde  FROM " . $xoopsDB->prefix("garage_intervention") . " WHERE solde =9");
    echo "<table class=\"outer\" width=\"100%\">\n" . "<th><center>" . _AM_INTER_DELAI . "</center></th>\n" . "<th><center>" . _AM_VEHICULE . "</center></th>\n" . "<th><center>" . _AM_VEHICULE_PROPRIETAIRE . "</center></th>\n" . "<th colspan=\"2\"><center>" . _AM_ACTION . "</center></th>\n";
    while ((list($id_inter, $id_voiture, $date_debut, $date_fin, $delai, $solde) = $xoopsDB->fetchRow($result)) != false) {
        // recup des infos du vehicule et proprio
        $req3 = $xoopsDB->query("SELECT id, immat, id_marque, gamme, modele_version, id_proprietaire FROM " . $xoopsDB->prefix("garage_vehicule") . " WHERE id={$id_voiture}");
        while ((list($id_vehicule, $immat, $id_marque, $gamme, $modele_version, $id_proprietaire) = $xoopsDB->fetchRow($req3)) != false) {
            $civilite = '';
            $nom = '';
            $prenom = '';
Пример #2
0
        $date_vidange = $_POST["date_vidange"];
        $km_vidange = $_POST["km_vidange"];
        $date_cg = $_POST["date_cg"];
        $observation = $_POST["observation"];
        $sql = sprintf("UPDATE " . $xoopsDB->prefix("garage_vehicule") . " SET immat='{$immat}', id_proprietaire='{$id_proprietaire}', date_mec='{$date_mec}', kilometrage='{$kilometrage}', dernier_ct='{$dernier_ct}', prochain_ct='{$prochain_ct}', id_marque='{$id_marque}', gamme='{$gamme}', modele_version='{$modele_version}', energie='{$energie}', genre='{$genre}', vin='{$vin}', date_garantie='{$date_garantie}', date_distribution='{$date_distribution}', km_distribution='{$km_distribution}', date_vidange='{$date_vidange}', km_vidange='{$km_vidange}', date_cg='{$date_cg}', observation='{$observation}'  WHERE id={$id}");
        $xoopsDB->queryF($sql) or die('Erreur requete : ' . $sql . '<br />');
        redirect_header("vehicule.php", 2, _AM_VEHICULE_MODIF);
        break;
}
//  ------------------------------------------------------------------------ //
//-- CAS GENERAL - ON LISTE LES ENREGISTREMENTS + FORMULAIRE DE CREATION
//  ------------------------------------------------------------------------ //
if (empty($op)) {
    Xoops_Cp_Header();
    garage_tabsAdminMenu("vehicule.php");
    doc_info('Vehicule');
    $result = $xoopsDB->query("SELECT id, immat, id_proprietaire, id_marque, gamme, modele_version FROM " . $xoopsDB->prefix("garage_vehicule") . " ORDER BY id");
    echo "<table class=\"outer\" width=\"100%\">\n" . "<th><center>" . _AM_VEHICULE_IMMAT . ' / ' . _AM_VEHICULE_MARQUE . "</center></th>\n" . "<th><center>" . _AM_VEHICULE_PROPRIETAIRE . "</center></th>\n" . "<th colspan=\"2\"><center>" . _AM_ACTION . "</center></th>\n";
    //		."<th><center>"._AM_ACTION."</center></th>\n";
    while ((list($id, $immat, $id_proprietaire, $id_marque, $gamme, $modele_version) = $xoopsDB->fetchRow($result)) != false) {
        $marque = "";
        if ($id_marque != 0) {
            // on recupere la marque du vehicule
            $req = $xoopsDB->query("SELECT * FROM " . $xoopsDB->prefix("garage_marque") . " WHERE id='{$id_marque}'");
            if ($req) {
                while (($row = $xoopsDB->fetchArray($req)) != false) {
                    $marque = $row['nom'];
                }
            }
        }
        $proprietaire = "";
Пример #3
0
        $sql = "DELETE FROM " . $xoopsDB->prefix('garage_intervention') . " WHERE id='" . $id_inter . "'";
        $xoopsDB->queryF($sql) or die("Erreur requete : " . $sql . '<br />');
        // suppression des heures saisies
        $sql = "DELETE FROM " . $xoopsDB->prefix('garage_inter_temp') . " WHERE id_inter='" . $id_inter . "'";
        $xoopsDB->queryF($sql) or die("Erreur requete : " . $sql . '<br />');
        // suppression des pieces saisies
        $sql = "DELETE FROM " . $xoopsDB->prefix('garage_inter_pieces') . " WHERE id_inter='" . $id_inter . "'";
        $xoopsDB->queryF($sql) or die("Erreur requete : " . $sql . '<br />');
        redirect_header("intervention.php", 2, _AM_INTER_DELETED);
        break;
}
// fin du switch
if (empty($op)) {
    Xoops_Cp_Header();
    garage_tabsAdminMenu("intervention.php");
    doc_info('Suppression_inter');
    echo "<style> \n\t\t\t\t\t.encours {background-color: #E6FFE6; padding: 5px;}\n\t\t\t\t\t.solde {background-color: #CAFAFF; padding: 5px;}\n\t\t\t\t\t.archive {background-color: #CAE2FF; padding: 5px;}\n\t\t\t\t\t</style>";
    $etat_des = _AM_INTER_ENCOURS;
    $style = 'encours';
    echo "<table width='100%'><tr><td align='center'><img src='images/logo.jpg' alt='' title=''></td></tr></table><br />\n";
    echo "<h1>" . $etat_des . "</h1>";
    // on affiche uniquement les interventions en cours (etat a 0)
    $result = $xoopsDB->query("SELECT id, id_voiture, date_debut, date_fin, delai, solde  FROM " . $xoopsDB->prefix("garage_intervention") . " WHERE solde =0");
    echo "<table class=\"outer\" width=\"100%\">\n" . "<th><center>" . _AM_INTER_DELAI . "</center></th>\n" . "<th><center>" . _AM_VEHICULE . "</center></th>\n" . "<th><center>" . _AM_VEHICULE_PROPRIETAIRE . "</center></th>\n" . "<th colspan=\"2\"><center>" . _AM_ACTION . "</center></th>\n";
    while ((list($id_inter, $id_voiture, $date_debut, $date_fin, $delai, $solde) = $xoopsDB->fetchRow($result)) != false) {
        // recup des infos du vehicule et proprio
        $req3 = $xoopsDB->query("SELECT id, immat, id_marque, gamme, modele_version, id_proprietaire FROM " . $xoopsDB->prefix("garage_vehicule") . " WHERE id={$id_voiture}");
        while ((list($id_vehicule, $immat, $id_marque, $gamme, $modele_version, $id_proprietaire) = $xoopsDB->fetchRow($req3)) != false) {
            $civilite = '';
            $nom = '';
            $prenom = '';
Пример #4
0
        $civilite = $_POST["civilite"];
        $email = $_POST["email"];
        $part_prof = $_POST["part_prof"];
        $permis = $_POST["permis"];
        $remise = $_POST["remise"];
        $sql = sprintf("UPDATE " . $xoopsDB->prefix("garage_clients") . " SET compte='{$compte}', rs='{$rs}', nom='{$nom}', prenom='{$prenom}', adresse='{$adresse}', cp='{$cp}', ville='{$ville}', teldom='{$teldom}', telport='{$telport}', telbureau='{$telbureau}', telecopie='{$fax}', civilite='{$civilite}', email='{$email}', particulier_prof='{$part_prof}', permis='{$permis}', remise='{$remise}'  WHERE id={$id}");
        $xoopsDB->queryF($sql) or die('Erreur requete : ' . $sql . '<br />');
        redirect_header("client.php", 2, _AM_CLIENT_MODIF);
}
//  ------------------------------------------------------------------------ //
//-- CAS GENERAL - ON LISTE LES ENREGISTREMENTS + FORMULAIRE DE CREATION
//  ------------------------------------------------------------------------ //
if (empty($op)) {
    Xoops_Cp_Header();
    garage_tabsAdminMenu("client.php");
    doc_info('Client');
    $result = $xoopsDB->query("SELECT id, nom, prenom, cp, ville FROM " . $xoopsDB->prefix("garage_clients") . " ORDER BY id");
    echo "<table class=\"outer\" width=\"100%\">\n" . "<th><center>" . _AM_CLIENT_NOM . ' / ' . _AM_CLIENT_PRENOM . "</center></th>\n" . "<th><center>" . _AM_CLIENT_CP . ' - ' . _AM_CLIENT_VILLE . "</center></th>\n" . "<th colspan=\"2\"><center>" . _AM_ACTION . "</center></th>\n";
    //		."<th><center>"._AM_ACTION."</center></th>\n";
    while ((list($id, $nom, $prenom, $cp, $ville) = $xoopsDB->fetchRow($result)) != false) {
        echo '<tr>';
        echo '<td class="odd" ALIGN="left">' . $nom . ' - ' . $prenom . '</td>';
        echo '<td class="odd" ALIGN="left">' . $cp . ' - ' . $ville . '</td>';
        echo '<td class="odd" align="center"><A HREF="client.php?op=modifclient&id=' . $id . '"><img src="../images/modif.png"></a> </td>';
        echo '<td class="odd" align="center"><A HREF="client.php?op=suprclient&id=' . $id . '"><img src="../images/sup.png"></a></td>';
    }
    echo '</tr></table><br />';
    $form = new XoopsThemeForm(_AM_CLIENT_CREATION, 'cclient', 'client.php?op=creatclient', 'post');
    $form->addElement(new XoopsFormText(_AM_CLIENT_COMPTE, 'compte', 50, 255, ''));
    $form->addElement(new XoopsFormText(_AM_CLIENT_RS, 'rs', 100, 255, ''));
    $civ = new XoopsFormSelect(_AM_CLIENT_CIVILITE, 'civilite');
Пример #5
0
    //-- UPDATE APRES MODIF
    //  ------------------------------------------------------------------------ //
    case "update":
        global $xoopsDB, $myts;
        $nom = $_POST["nom"];
        $sql = sprintf("UPDATE " . $xoopsDB->prefix("garage_marque") . " SET nom='{$nom}' WHERE id={$id}");
        $xoopsDB->queryF($sql) or die('erreur requete :' . $sql . '<br />');
        redirect_header("marque.php", 2, _AM_MARQUE_MODIF);
}
//  ------------------------------------------------------------------------ //
//-- CAS GENERAL - ON LISTE LES ENREGISTREMENTS + FORMULAIRE DE CREATION
//  ------------------------------------------------------------------------ //
if (empty($op)) {
    Xoops_Cp_Header();
    garage_tabsAdminMenu("marque.php");
    doc_info('marque');
    $result = $xoopsDB->query("SELECT * FROM " . $xoopsDB->prefix("garage_marque") . " ORDER BY id");
    $marque = array();
    echo "<table class=\"outer\" width=\"100%\">\n" . "<th><align='left'>" . _AM_MARQUE_NOM . "</center></th>\n" . "<th colspan=\"2\"><center>" . _AM_ACTION . "</center></th>\n";
    while ((list($id, $nom) = $xoopsDB->fetchRow($result)) != false) {
        $marque[$id] = $id;
        echo '<tr>';
        //echo '<td class="odd" ALIGN="left">'.$id.'</td>';
        echo '<td class="odd" ALIGN="left">' . $nom . '</td>';
        echo '<td class="odd" align="center"><A HREF="marque.php?op=modifmarque&id=' . $id . '"><img src="../images/modif.png"></a></td>';
        echo '<td class="odd" align="center"><A HREF="marque.php?op=suprmarque&id=' . $id . '"><img src="../images/sup.png"></a></td>';
    }
    echo '</tr></table><br />';
    $form = new XoopsThemeForm(_AM_MARQUE_CREATION, 'cmarque', 'marque.php?op=creatmarque', 'post');
    $form->addElement(new XoopsFormText(_AM_MARQUE_NOM, 'nom', 50, 255, ''));
    $form->addElement(new XoopsFormButton('', 'submit', _AM_CREATING, 'submit'));
Пример #6
0
            redirect_header("employe.php", 2, _AM_ERROR_IDEMPLREQ);
        }
        $nom_empl = isset($_POST["nom_empl"]) ? $_POST["nom_empl"] : '';
        //	if (empty($nom_empl)) { redirect_header("employe.php", 2, _AM_ERROR_NAMEEMPLREQ);}
        $pre_empl = isset($_POST["pre_empl"]) ? $_POST["pre_empl"] : '';
        //UPDATE
        $sql = sprintf("UPDATE %s SET nom_empl='%s', pre_empl='%s' WHERE id_empl='%s'", $xoopsDB->prefix("garage_employe"), $nom_empl, $pre_empl, $id_empl);
        $xoopsDB->queryF($sql) or die('erreur requete :' . $sql . '<br />');
        redirect_header("employe.php", 2, _AM_GARAGE_EMPL_MODIF);
        break;
}
if (empty($op)) {
    Xoops_Cp_Header();
    // Nice menu with tabs
    garage_tabsAdminMenu("employe.php");
    doc_info('employe');
    echo "<table class=\"outer\" width=\"100%\">\n" . "<th><center>" . _AM_GARAGE_EMPL_NAME . "</center></th>\n" . "<th><center>" . _AM_GARAGE_EMPL_PREN . "</center></th>\n" . "<th colspan=\"2\"><center>" . _AM_ACTION . "</center></th>\n";
    $result = $xoopsDB->query("SELECT id_empl, nom_empl, pre_empl FROM " . $xoopsDB->prefix("garage_employe") . " ORDER BY nom_empl");
    while ((list($id_empl, $nom_empl, $pre_empl) = $xoopsDB->fetchRow($result)) != false) {
        echo '<tr>';
        echo '<td class="odd" ALIGN="left">' . $nom_empl . '</td>';
        echo '<td class="odd" ALIGN="left">' . $pre_empl . '</td>';
        echo '<td class="odd" align="center"><A HREF="employe.php?op=modifempl&id_empl=' . $id_empl . '"><img src="../images/modif.png"></a></td>';
        echo '<td class="odd" align="center"><A HREF="employe.php?op=suprempl&id_empl=' . $id_empl . '"><img src="../images/sup.png"></a></td>';
    }
    echo '</tr></table><br />';
    $form = new XoopsThemeForm(_AM_GARAGE_EMPL_CREATION, 'cempl', 'employe.php?op=creatempl', 'post');
    $form->addElement(new XoopsFormText(_AM_GARAGE_EMPL_NAME, 'nom_empl', 50, 255));
    $form->addElement(new XoopsFormText(_AM_GARAGE_EMPL_PREN, 'pre_empl', 50, 255));
    $form->addElement(new XoopsFormButton('', 'submit', _AM_CREATING, 'submit'));
    $form->display();
Пример #7
0
    //-- UPDATE APRES MODIF
    //  ------------------------------------------------------------------------ //
    case "update":
        global $xoopsDB, $myts;
        $nom = $_POST["nom"];
        $sql = sprintf("UPDATE " . $xoopsDB->prefix("garage_cat_piece") . " SET nom='{$nom}' WHERE id={$id}");
        $xoopsDB->queryF($sql) or die('erreur requete :' . $sql . '<br />');
        redirect_header("cat_piece.php", 2, _AM_CAT_MODIF);
}
//  ------------------------------------------------------------------------ //
//-- CAS GENERAL - ON LISTE LES ENREGISTREMENTS + FORMULAIRE DE CREATION
//  ------------------------------------------------------------------------ //
if (empty($op)) {
    Xoops_Cp_Header();
    garage_tabsAdminMenu("cat_piece.php");
    doc_info('Cat_Piece');
    $result = $xoopsDB->query("SELECT * FROM " . $xoopsDB->prefix("garage_cat_piece") . " ORDER BY id");
    $cat = array();
    echo "<table class=\"outer\" width=\"100%\">\n" . "<th><align='left'>" . _AM_CAT_NOM . "</center></th>\n" . "<th colspan=\"2\"><center>" . _AM_ACTION . "</center></th>\n";
    while ((list($id, $nom) = $xoopsDB->fetchRow($result)) != false) {
        $cat[$id] = $id;
        echo '<tr>';
        //echo '<td class="odd" ALIGN="left">'.$id.'</td>';
        echo '<td class="odd" ALIGN="left">' . $nom . '</td>';
        echo '<td class="odd" align="center"><A HREF="cat_piece.php?op=modifcat&id=' . $id . '"><img src="../images/modif.png"></a></td>';
        echo '<td class="odd" align="center"><A HREF="cat_piece.php?op=suprcat&id=' . $id . '"><img src="../images/sup.png"></a></td>';
    }
    echo '</tr></table><br />';
    $form = new XoopsThemeForm(_AM_CAT_CREATION, 'ccat', 'cat_piece.php?op=creatcat', 'post');
    $form->addElement(new XoopsFormText(_AM_CAT_NOM, 'nom', 50, 255, ''));
    $form->addElement(new XoopsFormButton('', 'submit', _AM_CREATING, 'submit'));
Пример #8
0
        global $xoopsDB, $myts;
        $myts =& MyTextSanitizer::getInstance();
        //	$old_id_doc		= $myts->makeTboxData4save($_POST["old_id_doc"]);
        $id_doc = $_POST["id_doc"];
        $doc_fr = $_POST["doc_fr"];
        //	$sql = sprintf("UPDATE ".$xoopsDB->prefix("garage_doc")." SET doc_fr = '$doc_fr' WHERE id_doc='$id_doc'");
        $xoopsDB->queryF("UPDATE " . $xoopsDB->prefix("garage_doc") . " SET doc_fr = '{$doc_fr}' WHERE id_doc='{$id_doc}'") or die('erreur requete :' . $sql . '<br />');
        redirect_header("gest_doc.php", 2, _AM_DOC_MODIF);
}
//  ------------------------------------------------------------------------ //
//-- CAS GENERAL - ON LISTE LES ENREGISTREMENTS + FORMULAIRE DE CREATION
//  ------------------------------------------------------------------------ //
if (empty($op)) {
    Xoops_Cp_Header();
    garage_tabsAdminMenu("gest_doc.php");
    doc_info('Documentation');
    $result = $xoopsDB->query("SELECT * FROM " . $xoopsDB->prefix("garage_doc"));
    //." ORDER BY id_doc");
    echo "<table class=\"outer\" width=\"100%\">\n" . "<th width='20px'><center>" . _AM_DOC . "</center></th>\n" . "<th><center>" . _AM_DOC_DES . "</center></th>\n" . "<th colspan=\"2\"><center>" . _AM_ACTION . "</center></th>\n";
    while ((list($id_doc, $doc_fr) = $xoopsDB->fetchRow($result)) != false) {
        echo '<tr>';
        echo '<td class="odd" ALIGN="left">' . $id_doc . '</td>';
        echo '<td class="odd" ALIGN="left">' . nl2br($doc_fr) . '</td>';
        // suppression interdite
        //				echo '<td class="odd" align="center"><A HREF="gest_doc.php?op=modifdoc&id_doc='.$id_doc.'"><img src="../images/modif.png"></a> &nbsp;&nbsp;<A HREF="gest_doc.php?op=suprdoc&id_doc='.$id_doc.'"><img src="../images/sup.png"></a></td>';
        echo '<td class="odd" align="center"><A HREF="gest_doc.php?op=modifdoc&id_doc=' . $id_doc . '"><img src="../images/modif.png"></a></td>';
    }
    echo '</tr></table><br />';
    /*
    	$form = new XoopsThemeForm(_AM_DOC_CREATION,'cdoc','gest_doc.php?op=creatdoc','post');
    	$form -> addElement(new XoopsFormText(_AM_DOC,'id_doc',20,255, ''));	
Пример #9
0
    case "update":
        global $xoopsDB, $myts;
        $nom = $_POST["nom_forfait"];
        $description = $_POST["description_forfait"];
        $tarif = $_POST["tarif_forfait"];
        $sql = sprintf("UPDATE " . $xoopsDB->prefix("garage_forfait") . " SET nom='{$nom}', description='{$description}', tarif='{$tarif}' WHERE id={$id}");
        $xoopsDB->queryF($sql) or die('erreur requete :' . $sql . '<br />');
        redirect_header("forfait.php?op=modif&id=" . $id, 2, _AM_FORFAIT_MODIF);
}
//  ------------------------------------------------------------------------ //
//-- CAS GENERAL - ON LISTE LES ENREGISTREMENTS + FORMULAIRE DE CREATION
//  ------------------------------------------------------------------------ //
if (empty($op)) {
    Xoops_Cp_Header();
    garage_tabsAdminMenu("forfait.php");
    doc_info('forfait');
    $result = $xoopsDB->query("SELECT * FROM " . $xoopsDB->prefix("garage_forfait") . " ORDER BY id");
    $cat = array();
    echo "<table class=\"outer\" width=\"100%\">\n" . "<th><align='left'>" . _AM_FORFAIT_NOM . "</center></th>\n" . "<th><align='left'>" . _AM_FORFAIT_DESCRIPTION . "</center></th>\n" . "<th><align='left'>" . _AM_FORFAIT_TARIF . "</center></th>\n" . "<th colspan=\"2\"><center>" . _AM_ACTION . "</center></th>\n";
    while ((list($id, $nom, $description, $tarif) = $xoopsDB->fetchRow($result)) != false) {
        $cat[$id] = $id;
        echo '<tr>';
        echo '<td class="odd" ALIGN="left">' . $nom . '</td>';
        echo '<td class="odd" ALIGN="left">' . nl2br($description) . '</td>';
        echo '<td class="odd" ALIGN="right">' . $tarif . '</td>';
        echo '<td class="odd" align="center"><A HREF="forfait.php?op=modif&id=' . $id . '"><img src="../images/modif.png"></a></td>';
        echo '<td class="odd" align="center"><A HREF="forfait.php?op=suppr&id=' . $id . '"><img src="../images/sup.png"></a></td>';
    }
    echo '</tr></table><br />';
    $form = new XoopsThemeForm(_AM_FORFAIT_CREATION, 'cforfait', 'forfait.php?op=create', 'post');
    $form->addElement(new XoopsFormText(_AM_FORFAIT_NOM, 'nom_forfait', 50, 255, ''));
Пример #10
0
        $nom = $_POST["nom"];
        $adresse = $_POST["adresse"];
        $tel = $_POST["tel"];
        $fax = $_POST["fax"];
        $email = $_POST["email"];
        $sql = sprintf("UPDATE " . $xoopsDB->prefix("garage_fournisseur") . " SET nom='{$nom}' , adresse='{$adresse}', tel='{$tel}', fax='{$fax}', email='{$email}' WHERE id={$id}");
        $xoopsDB->queryF($sql) or die('erreur requete :' . $sql . '<br />');
        redirect_header("fournisseur.php", 2, _AM_FOURNISSEUR_MODIF);
}
//  ------------------------------------------------------------------------ //
//-- CAS GENERAL - ON LISTE LES ENREGISTREMENTS + FORMULAIRE DE CREATION
//  ------------------------------------------------------------------------ //
if (empty($op)) {
    Xoops_Cp_Header();
    garage_tabsAdminMenu("fournisseur.php");
    doc_info('Fournisseur');
    $result = $xoopsDB->query("SELECT * FROM " . $xoopsDB->prefix("garage_fournisseur") . " ORDER BY id");
    $fournisseur = array();
    //    $type = array();
    echo "<table class=\"outer\" width=\"100%\">\n" . "<th><align='left'>" . _AM_FOURNISSEUR_NOM . "</center></th>\n" . "<th><align='left'>" . _AM_FOURNISSEUR_ADDRESS . "</center></th>\n" . "<th><align='left'>" . _AM_FOURNISSEUR_PHONEFAX . "</center></th>\n" . "<th><align='left'>" . _AM_FOURNISSEUR_EMAIL . "</center></th>\n" . "<th colspan=\"2\"><center>" . _AM_ACTION . "</center></th>\n";
    while ((list($id, $nom, $adresse, $tel, $fax, $email) = $xoopsDB->fetchRow($result)) != false) {
        $fournisseur[$id] = $id;
        echo '<tr>';
        //echo '<td class="odd" ALIGN="left">'.$id.'</td>';
        echo '<td class="odd" ALIGN="left">' . $nom . '</td>';
        echo '<td class="odd" ALIGN="left">' . $adresse . '</td>';
        echo '<td class="odd" ALIGN="left">Tel : ' . $tel . ' - Fax : ' . $fax . '</td>';
        echo '<td class="odd" ALIGN="left">' . $email . '</td>';
        echo '<td class="odd" align="center"><A HREF="fournisseur.php?op=modiffournisseur&id=' . $id . '"><img src="../images/modif.png"></a></td>';
        echo '<td class="odd" align="center"><A HREF="fournisseur.php?op=suprfournisseur&id=' . $id . '"><img src="../images/sup.png"></a></td>';
    }
Пример #11
0
        $ref = $_POST["ref"];
        $designation = $_POST["designation"];
        $id_fournisseur = $_POST["id_fournisseur"];
        $ref_fournisseur = $_POST["ref_fournisseur"];
        $id_cat_piece = $_POST["id_cat_piece"];
        $sql = sprintf("UPDATE " . $xoopsDB->prefix("garage_pieces") . " SET ref='{$ref}', designation='{$designation}', id_fournisseur='{$id_fournisseur}', ref_fournisseur='{$ref_fournisseur}', tarif_ha='{$tarif_ha}', tarif_client='{$tarif_client}', id_cat_piece='{$id_cat_piece}' WHERE id={$id}");
        $xoopsDB->queryF($sql) or die('Erreur requete : ' . $sql . '<br />');
        redirect_header("piece.php", 2, _AM_PIECES_MODIF);
}
//  ------------------------------------------------------------------------ //
//-- CAS GENERAL - ON LISTE LES ENREGISTREMENTS + FORMULAIRE DE CREATION
//  ------------------------------------------------------------------------ //
if (empty($op)) {
    Xoops_Cp_Header();
    garage_tabsAdminMenu("piece.php");
    doc_info('Piece');
    // Cache la liste
    echo "\n\t\t\t<script type='text/javascript'>\n\t\t\tfunction hideAll1()\n\t\t\t{document.getElementById('listpiece').style.display = 'none';}\n\t\t\tfunction showForm(obj)\n\t\t\t{obj.style.display = 'block';}\n\t\t\t</script>\n\t\t\t<style type='text/css'>\n\t\t\t#listpiece\n\t\t\t{display: none;}\n\t\t\t</style>";
    echo '<p>&nbsp;
		<span style="background-color: #E9E9E9;border:1px solid #C0C0C0;font-size:10px;">&nbsp;Liste des Pi&egrave;ces&nbsp;
		<a href="javascript:;" onclick="hideAll1();showForm(document.getElementById(\'listpiece\'));"><b>+</b></a>/
		<a href="javascript:;" onclick="hideAll1();"><b>-</b></a>
		&nbsp;
		</span>
		</p>';
    //
    echo "<div id='listpiece'>" . "<table class=\"outer\" width=\"100%\">\n" . "<th><align='left'>" . _AM_CAT . "</center></th>\n" . "<th><align='left'>" . _AM_PIECES_REF . "</center></th>\n" . "<th><align='left'>" . _AM_PIECES_DESIGNATION . "</center></th>\n" . "<th><align='left'>" . _AM_PIECES_FOURNISSEUR . "</center></th>\n" . "<th colspan=\"2\"><center>" . _AM_ACTION . "</center></th>\n";
    $result = $xoopsDB->query("SELECT * FROM " . $xoopsDB->prefix("garage_pieces") . " ORDER BY id_cat_piece");
    $pieces = array();
    $nom_fournisseur = " ";
    $categorie = " ";