* Copyright (C) 2005 Simon TOSSER * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. * * $Id: fiche.php,v 1.1 2005/10/20 19:27:19 simontosser Exp $ * $Source: /srv/cvs/sources/dolibarr/dolibarr/htdocs/compta/ventilation/fournisseur/fiche.php,v $ * */ /** \file htdocs/compta/ventilation/fournisseur/fiche.php \ingroup compta \brief Page fiche ventilation \version $Revision: 1.1 $ */ require("./pre.inc.php"); $mesg = ''; if (!$user->rights->compta->ventilation->creer) accessforbidden(); if ($_POST["action"] == 'ventil' && $user->rights->compta->ventilation->creer) { $sql = " UPDATE ".MAIN_DB_PREFIX."facture_fourn_det"; $sql .= " SET fk_code_ventilation = ".$_POST["codeventil"]; $sql .= " WHERE rowid = ".$_GET["id"]; $db->query($sql); } llxHeader("","","Fiche ventilation"); if ($cancel == $langs->trans("Cancel")) { $action = ''; } /* * * */ $sql = "SELECT rowid, numero, intitule"; $sql .= " FROM ".MAIN_DB_PREFIX."compta_compte_generaux"; $sql .= " ORDER BY numero ASC"; $result = $db->query($sql); if ($result) { $num = $db->num_rows($result); $i = 0; while ($i < $num) { $row = $db->fetch_row($result); $cgs[$row[0]] = $row[1] . ' ' . $row[2]; $i++; } } /* * Création * */ $form = new Form($db); if($_GET["id"]) { $sql = "SELECT f.facnumber, f.rowid as facid, l.fk_product, l.description, l.total_ttc, l.qty, l.rowid, l.tva_taux, l.fk_code_ventilation "; $sql .= " FROM ".MAIN_DB_PREFIX."facture_fourn_det as l"; $sql .= " , ".MAIN_DB_PREFIX."facture_fourn as f"; $sql .= " WHERE f.rowid = l.fk_facture_fourn AND f.fk_statut = 1 AND l.rowid = ".$_GET["id"]; $result = $db->query($sql); if ($result) { $num_lignes = $db->num_rows($result); $i = 0; if ($num_lignes) { $objp = $db->fetch_object($result); if($objp->fk_code_ventilation == 0) { print '
'."\n"; print ''; } print_titre("Ventilation"); print ''; print ''; print ''; print ''; print ''; print ''; if($objp->fk_code_ventilation == 0) { print ''; } print '
Facture'.$objp->facnumber.'
Ligne'.stripslashes(nl2br($objp->description)).'
Ventiler dans le compte :'; if($objp->fk_code_ventilation == 0) { print $form->select_array("codeventil",$cgs, $objp->fk_code_ventilation); } else { print $cgs[$objp->fk_code_ventilation]; } print '
 
'; print '
'; } else { print "Error"; } } else { print "Error"; } } else { print "Error ID incorrect"; } $db->close(); llxFooter("Dernière modification $Date: 2005/10/20 19:27:19 $ révision $Revision: 1.1 $"); ?>