';
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 'Client | ';
print 'Montant | ';
print " \n";
$var=True;
while ($i < min($num,$conf->liste_limit))
{
$obj = $db->fetch_object($resql);
$var=!$var;
print "";
print '';
print img_file();
print ' ';
print ''.$obj->nom." | \n";
print ''.sprintf("%01.2f",$obj->montant)." | \n";
print " \n";
$i++;
}
print " ";
$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 'Mois | ';
print " \n";
$var=True;
while ( $obj = $db->fetch_object($resql))
{
$var=!$var;
print "";
print 'date.'">'.$obj->date." | \n";
print " \n";
}
print " ";
$db->free();
}
else
{
print $db->error() . ' ' . $sql;
}
print ' |