[Sommaire] [Imprimer]

   1  <?php
   2  /* Copyright (C) 2004-2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
   3   * Copyright (C) 2005      Laurent Destailleur  <eldy@users.sourceforge.net>
   4   *
   5   * This program is free software; you can redistribute it and/or modify
   6   * it under the terms of the GNU General Public License as published by
   7   * the Free Software Foundation; either version 2 of the License, or
   8   * (at your option) any later version.
   9   *
  10   * This program is distributed in the hope that it will be useful,
  11   * but WITHOUT ANY WARRANTY; without even the implied warranty of
  12   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  13   * GNU General Public License for more details.
  14   *
  15   * You should have received a copy of the GNU General Public License
  16   * along with this program; if not, write to the Free Software
  17   * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
  18   *
  19   * $Id: demandes.php,v 1.10.2.1 2005/12/26 14:25:52 hregis Exp $
  20   * $Source: /cvsroot/dolibarr/dolibarr/htdocs/compta/prelevement/demandes.php,v $
  21   */
  22  
  23  /**
  24          \file       htdocs/compta/prelevement/demandes.php
  25          \brief      Page de la liste des demandes de prélèvements
  26          \version    $Revision: 1.10.2.1 $
  27  */
  28  
  29  require ("./pre.inc.php");
  30  require_once DOL_DOCUMENT_ROOT."/includes/modules/modPrelevement.class.php";
  31  
  32  if (!$user->rights->prelevement->bons->lire)
  33    accessforbidden();
  34  
  35  $langs->load("widthdrawals");
  36  
  37  if ($user->societe_id > 0)
  38  {
  39    $socidp = $user->societe_id;
  40  }
  41  
  42  llxHeader();
  43  
  44  /*
  45   *
  46   */
  47  
  48  $page = $_GET["page"];
  49  $sortorder = $_GET["sortorder"];
  50  $sortfield = $_GET["sortfield"];
  51  
  52  if ($page == -1) $page = 0 ;
  53  $offset = $conf->liste_limit * $page ;
  54  $pageprev = $page - 1;
  55  $pagenext = $page + 1;
  56  if (! $sortorder) $sortorder="DESC";
  57  if (! $sortfield) $sortfield="f.facnumber";
  58  
  59  
  60  /*
  61   * Liste de demandes
  62   *
  63   */
  64  
  65  $sql= "SELECT f.facnumber, f.rowid, s.nom, s.idp";
  66  $sql.= " , ".$db->pdate("pfd.date_demande")." as date_demande";
  67  $sql.= " , pfd.fk_user_demande";
  68  $sql.= " FROM ".MAIN_DB_PREFIX."facture as f, ".MAIN_DB_PREFIX."societe as s";
  69  $sql.= " , ".MAIN_DB_PREFIX."prelevement_facture_demande as pfd";
  70  $sql.= " WHERE s.idp = f.fk_soc";
  71  if (! $statut) $sql.= " AND pfd.traite = 0";
  72  if ($statut) $sql.= " AND pfd.traite = ".$statut;
  73  $sql.= " AND pfd.fk_facture = f.rowid";
  74  if (strlen(trim($_GET["search_societe"])))
  75  {
  76    $sql .= " AND s.nom LIKE '%".$_GET["search_societe"]."%'";
  77  }
  78  if ($socidp)
  79  {
  80    $sql .= " AND f.fk_soc = $socidp";
  81  }
  82  $sql .= " ORDER BY $sortfield $sortorder " . $db->plimit($conf->liste_limit+1, $offset);
  83  
  84  if ( $db->query($sql) )
  85  {
  86    $num = $db->num_rows();
  87    $i = 0;
  88    
  89    if (! $statut)
  90  {  
  91    print_barre_liste($langs->trans("RequestStandingOrderToTreat"), $page, "demandes.php", $urladd, $sortfield, $sortorder, '', $num);
  92  }
  93  else
  94  {
  95      print_barre_liste($langs->trans("RequestStandingOrderTreated"), $page, "demandes.php", $urladd, $sortfield, $sortorder, '', $num);
  96  }
  97    
  98    print '<table class="liste" width="100%">';
  99    print '<tr class="liste_titre">';
 100    print '<td class="liste_titre">'.$langs->trans("Bill").'</td><td class="liste_titre">'.$langs->trans("Company").'</td>';
 101    print '<td class="liste_titre" align="center">'.$langs->trans("Date").'</td>';
 102    print '<td class="liste_titre" align="center">'.$langs->trans("Author").'</td>';
 103    print '</tr>';
 104    
 105    print '<form action="demandes.php" method="GET">';
 106    print '<td class="liste_titre"><input type="text" class="flat" name="search_facture" size="12" value="'.$GET["search_facture"].'"></td>';
 107    print '<td class="liste_titre"><input type="text" class="flat" name="search_societe" size="18" value="'.$GET["search_societe"].'"></td>';
 108    print '<td colspan="2" class="liste_titre" align="right"><input type="image" class="liste_titre" src="'.DOL_URL_ROOT.'/theme/'.$conf->theme.'/img/search.png" name="button_search" alt="'.$langs->trans("Search").'"></td>';
 109    print '</tr>';
 110    print '</form>';
 111  
 112    $var = True;
 113  
 114    $users = array();
 115  
 116    while ($i < min($num,$conf->liste_limit))
 117      {
 118        $obj = $db->fetch_object();
 119        $var=!$var;
 120        print '<tr '.$bc[$var].'>';
 121        
 122        // Ref facture
 123        print '<td><a href="'.DOL_URL_ROOT.'/compta/facture/prelevement.php?facid='.$obj->rowid.'">'.img_file().' '.$obj->facnumber.'</a></td>';
 124  
 125        print '<td><a href="'.DOL_URL_ROOT.'/soc.php?socid='.$obj->idp.'">'.img_object($langs->trans("ShowCompany"),'company').' '.$obj->nom.'</a></td>';
 126  
 127        print '<td align="center">'.dolibarr_print_date($obj->date_demande).'</td>';
 128  
 129        if (!array_key_exists($obj->fk_user_demande,$users))
 130      {
 131        $users[$obj->fk_user_demande] = new User($db, $obj->fk_user_demande);
 132        $users[$obj->fk_user_demande]->fetch();
 133      }
 134  
 135        // User
 136        print '<td align="center"><a href="'.DOL_URL_ROOT.'/user/fiche.php?id='.$users[$obj->fk_user_demande]->id.'">'.img_object($langs->trans("ShowUser"),'user').' '.$users[$obj->fk_user_demande]->code.'</a></td>';
 137  
 138        print '</tr>';
 139        $i++;
 140      }
 141    
 142    print "</table><br />";
 143  
 144  }
 145  else
 146  {
 147    dolibarr_print_error($db);
 148  }  
 149  
 150  
 151  llxFooter('$Date: 2005/12/26 14:25:52 $ - $Revision: 1.10.2.1 $');
 152  ?>