* * 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: liste.php,v 1.1 2005/08/25 16:55:11 eldy Exp $ * $Source: /srv/cvs/sources/dolibarr/dolibarr/htdocs/comm/mailing/liste.php,v $ */ /** \file htdocs/comm/mailing/liste.php \ingroup mailing \brief Liste des mailings \version $Revision: 1.1 $ */ require("./pre.inc.php"); if (!$user->rights->mailing->lire) accessforbidden(); // Sécurité accés client if ($user->societe_id > 0) { $action = ''; $socidp = $user->societe_id; } $page=$_GET["page"]; $sortorder=$_GET["sortorder"]; $sortfield=$_GET["sortfield"]; if ($page == -1) { $page = 0 ; } $offset = $conf->liste_limit * $_GET["page"] ; $pageprev = $_GET["page"] - 1; $pagenext = $_GET["page"] + 1; $sall=isset($_GET["sall"])?$_GET["sall"]:$_POST["sall"]; $sref=isset($_GET["sref"])?$_GET["sref"]:$_POST["sref"]; llxHeader(); $sql = "SELECT m.rowid, m.titre, m.nbemail, m.statut, m.date_creat as datec"; $sql.= " FROM ".MAIN_DB_PREFIX."mailing as m"; $sql.= " WHERE 1=1"; if ($sref) $sql.= " AND m.rowid = '".$sref."'"; if ($sall) $sql.= " AND (m.titre like '%".$sall."%' OR m.sujet like '%".$sall."%' OR m.body like '%".$sall."%')"; if (! $sortorder) $sortorder="ASC"; if (! $sortfield) $sortfield="m.titre"; $sql .= " ORDER BY $sortfield $sortorder " . $db->plimit($conf->liste_limit +1, $offset); $result = $db->query($sql); if ($result) { $num = $db->num_rows($result); print_barre_liste($langs->trans("ListOfEMailings"), $page, "liste.php","",$sortfield,$sortorder,"",$num); $i = 0; $addu = "&sall=".$sall; print ''; print ''; print_liste_field_titre($langs->trans("Ref"),"liste.php","m.rowid",$addu,"","",$sortfield); print_liste_field_titre($langs->trans("Title"),"liste.php","m.titre",$addu,"","",$sortfield); print_liste_field_titre($langs->trans("DateCreation"),"liste.php","m.date_creat",$addu,"",'align="center"',$sortfield); print_liste_field_titre($langs->trans("NbOfEMails"),"liste.php","m.nbemail",$addu,"",'align="center"',$sortfield); print_liste_field_titre($langs->trans("Status"),"liste.php","m.statut",$addu,"",'align="center"',$sortfield); print ''; print "\n"; print ''; print ''; print ''; print ''; print ''; print ''; print '"; print "\n"; print ''; $var=True; $email=new Mailing($db); while ($i < min($num,$conf->liste_limit)) { $obj = $db->fetch_object($result); $var=!$var; print ""; print ''; print ''; print ''; print ''; print ''; print ''; print "\n"; $i++; } print "
 
'; print ''; print ''; print ''; print '   '; print "
'; print img_object($langs->trans("ShowEMail"),"email").' '.stripslashes($obj->rowid).''.$obj->titre.''.dolibarr_print_date($obj->datec).''.$obj->nbemail.''.$email->statuts[$obj->statut].($obj->statut==2?' '.img_warning():'').' 
"; $db->free($result); } else { dolibarr_print_error($db); } $db->close(); llxFooter('$Date: 2005/08/25 16:55:11 $ - $Revision: 1.1 $'); ?>