addColumn("raison_soc", "STRING_TYPE", "raison_soc", "%"); $tfi_listrsFact1->addColumn("acron_rs", "STRING_TYPE", "acron_rs", "%"); $tfi_listrsFact1->addColumn("nom", "STRING_TYPE", "nom", "%"); $tfi_listrsFact1->addColumn("present", "STRING_TYPE", "present", "%"); $tfi_listrsFact1->addColumn("numfacture", "STRING_TYPE", "numfacture", "%"); $tfi_listrsFact1->addColumn("dateinscription", "DATE_TYPE", "dateinscription", "="); $tfi_listrsFact1->addColumn("MontantTotal", "DOUBLE_TYPE", "MontantTotal", "="); $tfi_listrsFact1->addColumn("etat", "STRING_TYPE", "etat", "%"); $tfi_listrsFact1->Execute(); // Sorter $tso_listrsFact1 = new TSO_TableSorter("rsFact", "tso_listrsFact1"); $tso_listrsFact1->addColumn("raison_soc"); $tso_listrsFact1->addColumn("acron_rs"); $tso_listrsFact1->addColumn("nom"); $tso_listrsFact1->addColumn("present"); $tso_listrsFact1->addColumn("numfacture"); $tso_listrsFact1->addColumn("dateinscription"); $tso_listrsFact1->addColumn("MontantTotal"); $tso_listrsFact1->addColumn("etat"); $tso_listrsFact1->setDefault("numfacture DESC"); $tso_listrsFact1->Execute(); // Navigation $nav_listrsFact1 = new NAV_Regular("nav_listrsFact1", "rsFact", "../", $_SERVER['PHP_SELF'], 25); //NeXTenesio3 Special List Recordset $maxRows_rsFact = $_SESSION['max_rows_nav_listrsFact1']; $pageNum_rsFact = 0; if (isset($_GET['pageNum_rsFact'])) { $pageNum_rsFact = $_GET['pageNum_rsFact']; } $startRow_rsFact = $pageNum_rsFact * $maxRows_rsFact; // Defining List Recordset variable $NXTFilter_rsFact = "1=1"; if (isset($_SESSION['filter_tfi_listrsFact1'])) { $NXTFilter_rsFact = $_SESSION['filter_tfi_listrsFact1']; } // Defining List Recordset variable $NXTSort_rsFact = "numfacture"; if (isset($_SESSION['sorter_tso_listrsFact1'])) { $NXTSort_rsFact = $_SESSION['sorter_tso_listrsFact1']; } mysql_select_db($database_premier, $premier); $query_rsFact = "SELECT inscription.ID AS inscription_id, inscription.idContact, inscription.idConf, inscription.dateinscription, inscription.etat, inscription.MontantTotal, inscription.numfacture, inscription.present, contact.ID AS contact_id, contact.raison_soc, contact.acron_rs, contact.nom FROM inscription LEFT JOIN contact on contact.ID = inscription.idContact WHERE {$NXTFilter_rsFact} ORDER BY {$NXTSort_rsFact} "; $query_limit_rsFact = sprintf("%s LIMIT %d, %d", $query_rsFact, $startRow_rsFact, $maxRows_rsFact); $rsFact = mysql_query($query_limit_rsFact, $premier) or die(mysql_error()); $row_rsFact = mysql_fetch_assoc($rsFact); if (isset($_GET['totalRows_rsFact'])) { $totalRows_rsFact = $_GET['totalRows_rsFact']; } else { $all_rsFact = mysql_query($query_rsFact); $totalRows_rsFact = mysql_num_rows($all_rsFact); } $totalPages_rsFact = ceil($totalRows_rsFact/$maxRows_rsFact)-1; //End NeXTenesio3 Special List Recordset $nav_listrsFact1->checkBoundries(); ?>