* * 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: remav.php,v 1.1 2005/09/13 13:29:40 rodolphe Exp $ * $Source: /srv/cvs/sources/dolibarr/dolibarr/htdocs/telephonie/distributeurs/Attic/remav.php,v $ * */ require("./pre.inc.php"); if ($user->distributeur_id) { $_GET["id"] = $user->distributeur_id; } llxHeader(); $page = $_GET["page"]; $sortorder = $_GET["sortorder"]; $sortfield = $_GET["sortfield"]; if ($sortorder == "") $sortorder="DESC"; if ($sortfield == "") $sortfield="p.datepo"; /* * * */ if ($_GET["id"]) { $h = 0; $distri = new DistributeurTelephonie($db); $distri->fetch($_GET["id"]); $head[$h][0] = DOL_URL_ROOT.'/telephonie/distributeurs/distributeur.php?id='.$distri->id; $head[$h][1] = $distri->nom; $h++; $head[$h][0] = DOL_URL_ROOT.'/telephonie/distributeurs/contrat.php?id='.$distri->id; $head[$h][1] = "Contrat"; $h++; $head[$h][0] = DOL_URL_ROOT.'/telephonie/distributeurs/commissions.php?id='.$distri->id; $head[$h][1] = "Commissions"; $h++; $head[$h][0] = DOL_URL_ROOT.'/telephonie/distributeurs/remav.php?id='.$distri->id; $head[$h][1] = "Rém. avance"; $hselected = $h; $h++; $head[$h][0] = DOL_URL_ROOT.'/telephonie/distributeurs/remconso.php?id='.$distri->id; $head[$h][1] = "Rém. conso"; $h++; $head[$h][0] = DOL_URL_ROOT.'/telephonie/distributeurs/po.php?id='.$distri->id; $head[$h][1] = "Prises d'ordre"; $h++; $head[$h][0] = DOL_URL_ROOT.'/telephonie/distributeurs/stats.php?id='.$distri->id; $head[$h][1] = "Statistiques"; $h++; dolibarr_fiche_head($head, $hselected, "Distributeur"); print ''; print '
'; if ($page == -1) { $page = 0 ; } $offset = $conf->liste_limit * $page ; $pageprev = $page - 1; $pagenext = $page + 1; /* * Mode Liste * */ if ($_GET["month"] > 0) { $datetime = mktime(12,12,12,substr($_GET["month"], -2), 1 , substr($_GET["month"],0,4)); } else { $datetime = time(); } $month = substr("00".strftime("%m", $datetime), -2); $year = strftime("%Y", $datetime); $mois = strftime("%B %Y", $datetime); $sql = "SELECT s.idp, s.nom, a.fk_contrat, sum(a.montant) as montant"; $sql .= " FROM ".MAIN_DB_PREFIX."telephonie_commission_avance as a"; $sql .= " , ".MAIN_DB_PREFIX."telephonie_contrat as c"; $sql .= " , ".MAIN_DB_PREFIX."societe as s"; $sql .= " WHERE a.fk_distributeur =".$distri->id; $sql .= " AND a.fk_contrat = c.rowid"; $sql .= " AND c.fk_soc = s.idp"; $sql .= " AND a.date ='".$year.$month."'"; $sql .= " GROUP BY s.idp"; $sql .= " ORDER BY s.nom ASC"; $resql = $db->query($sql); if ($resql) { $num = $db->num_rows($resql); $i = 0; print_barre_liste("Rémunération sur avance pour $mois", $page, "po.php", "", $sortfield, $sortorder, '', $num); print ''; print ''; print ''; print "\n"; $var=True; while ($i < min($num,$conf->liste_limit)) { $obj = $db->fetch_object($resql); $var=!$var; print ""; print '\n"; print '\n"; print "\n"; $i++; } print "
ClientMontant
'; print img_file(); print ' '; print ''.$obj->nom."'.sprintf("%01.2f",$obj->montant)."
"; $db->free(); } else { print $db->error() . ' ' . $sql; } print '
'; $sql = "SELECT distinct(a.date)"; $sql .= " FROM ".MAIN_DB_PREFIX."telephonie_commission_avance as a"; $sql .= " ORDER BY a.date DESC"; $resql = $db->query($sql); if ($resql) { $num = $db->num_rows($resql); $i = 0; print ''; print ''; print "\n"; $var=True; while ( $obj = $db->fetch_object($resql)) { $var=!$var; print "\n"; print "\n"; } print "
Mois
"; print ''.$obj->date."
"; $db->free(); } else { print $db->error() . ' ' . $sql; } print '
'; } $db->close(); llxFooter("Dernière modification $Date: 2005/09/13 13:29:40 $ révision $Revision: 1.1 $"); ?>