PHP filterLink Examples

Example #1

File: customer.php Project: hnJaermuseet/JM-booking

            echo '  <td class="border">' . $entry['contact_person_name'] . '</td>' . chr(10);
            echo '  <td class="border">' . $entry['contact_person_phone'] . '</td>' . chr(10);
            echo '  <td class="border">' . $entry['contact_person_email'] . '</td>' . chr(10);
            echo ' </tr>' . chr(10);
        }
    }
    echo '</table>' . chr(10);
}
$filters = array();
$filters = addFilter($filters, 'customer_id', $customer['customer_id']);
$filters = addFilter($filters, 'deleted', true);
$SQL = genSQLFromFilters($filters, '*') . ' order by time_start';
$Q_next_entries = mysql_query($SQL);
if (mysql_num_rows($Q_next_entries)) {
    echo '<h2>Slettede bookinger knyttet til ' . $customer['customer_name'] . '</h2>' . chr(10);
    filterLink($filters);
    echo '<br><br>' . chr(10) . chr(10);
    echo '<table style="border-collapse: collapse;">' . chr(10);
    echo ' <tr>' . chr(10);
    echo '  <td class="border"><b>' . __('Starts') . '</b></td>' . chr(10);
    echo '  <td class="border"><b>' . __('Name') . '</b></td>' . chr(10);
    echo '  <td class="border"><b>' . __('Where') . '</b></td>' . chr(10);
    echo '  <td class="border"><b>' . __('Contact person') . '</b></td>' . chr(10);
    echo '  <td class="border"><b>' . __('Phone') . '</b></td>' . chr(10);
    echo '  <td class="border"><b>' . __('E-mail') . '</b></td>' . chr(10);
    echo ' </tr>' . chr(10);
    while ($R = mysql_fetch_assoc($Q_next_entries)) {
        $entry = getEntryParseDatabaseArray($R);
        if (count($entry)) {
            echo ' <tr>' . chr(10);
            echo '  <td class="border"><b>' . date('d-m-Y H:i', $entry['time_start']) . '</b></td>' . chr(10);

Example #2

File: invoice_tobemade.php Project: hnJaermuseet/JM-booking

         echo '</b>';
     }
     if ($counter_area != $num_area) {
         echo ' -:- ';
     }
 }
 echo '<br /><br /></span>';
 $filters = array();
 $filters = addFilter($filters, 'invoice', '1');
 $filters = addFilter($filters, 'invoice_status', '1');
 $filters = addFilter($filters, 'time_end', 'current', '<');
 if ($area_spesific) {
     $filters = addFilter($filters, 'area_id', $area_invoice['area_id']);
 }
 $SQL = genSQLFromFilters($filters, 'entry_id');
 filterLink($filters, 'invoice_tobemade');
 echo '<br>' . chr(10);
 echo '</span>';
 filterPrint($filters);
 echo '<br>' . chr(10);
 echo '<br>' . chr(10) . chr(10);
 $tamed_booking = true;
 foreach ($filters as $filter) {
     if ($filter[0] == 'tamed_booking') {
         $tamed_booking = $filter[1];
     }
 }
 entrylist_invoice_tobemade($SQL, $tamed_booking, $area_spesific);
 /*
 	echo '<br><br>';
 	echo '<h2>Bookinger som snart gjennomføres og som skal ha faktura</h2>';

Example #3

File: entry_stat.php Project: HNygard/JM-booking

include "libs/municipals_norway.php";
filterMakeAlternatives();
if (!isset($_GET['filters'])) {
    $_GET['filters'] = '';
}
$filters = filterGetFromSerialized($_GET['filters']);
if (!$filters) {
    $filters = array();
}
$SQL = genSQLFromFilters($filters, 'entry_id');
$SQL .= " order by `time_start`";
if (!isset($noprint)) {
    print_header($day, $month, $year, $area);
    echo '<h1>' . _('Entry statistics') . '</h1>';
    echo '<div class="hiddenprint">';
    filterLink($filters, 'entry_stat');
    echo '</div><br>' . chr(10);
    filterPrint($filters);
    echo '<br>' . chr(10);
    echo '<br>' . chr(10) . chr(10);
}
$Q = mysql_query($SQL);
// Municipal
// Bookingtype
// People (adults / children)
// Number of entries
$municipals2 = array();
$entrytypes = array();
$stats_day = array();
$stats_week = array();
$stats_month = array();

Example #4

File: invoice_tobemade_ready.php Project: HNygard/JM-booking

require "include/invoice_top.php";
$section = 'tobemade_ready';
require "include/invoice_menu.php";
echo '<h1>' . _('Ready to be made');
if (isset($_GET['filters'])) {
    echo ' - ' . _('customized list');
    echo '</h1>' . chr(10) . chr(10);
    $filters = filterGetFromSerialized($_GET['filters']);
    if (!$filters) {
        $filters = array();
    }
    $SQL = genSQLFromFilters($filters, 'entry_id');
    filterLink($filters, 'invoice_tobemade_ready');
    echo '<br>' . chr(10);
    filterPrint($filters);
    echo '<br>' . chr(10);
    echo '<br>' . chr(10) . chr(10);
    entrylist_invoice_tobemade_ready($SQL);
} else {
    echo '</h1>' . chr(10) . chr(10);
    $filters = array();
    $filters = addFilter($filters, 'invoice', '1');
    $filters = addFilter($filters, 'invoice_status', '2');
    $SQL = genSQLFromFilters($filters, 'entry_id');
    filterLink($filters, 'invoice_tobemade_ready');
    echo '<br>' . chr(10);
    filterPrint($filters);
    echo '<br>' . chr(10);
    echo '<br>' . chr(10) . chr(10);
    entrylist_invoice_tobemade_ready($SQL);
}

Example #5

File: invoice_exported.php Project: hnJaermuseet/JM-booking

        }
        echo '<a href="' . $_SERVER['PHP_SELF'] . '?area_id=' . $R['area_id'] . '">' . $R['area_name'] . '</a>';
        if ($area_spesific && $area_invoice['area_id'] == $R['area_id']) {
            echo '</b>';
        }
        if ($counter_area != $num_area) {
            echo ' -:- ';
        }
    }
    echo '<br /><br /></span>';
    $filters = array();
    $filters = addFilter($filters, 'invoice', '1');
    $filters = addFilter($filters, 'invoice_status', '3');
    if ($area_spesific) {
        $filters = addFilter($filters, 'area_id', $area_invoice['area_id']);
    }
    $SQL = genSQLFromFilters($filters, 'entry_id');
    filterLink($filters, 'invoice_exported');
    echo '<br>' . chr(10);
    echo '</span>';
    filterPrint($filters);
    echo '<br>' . chr(10);
    echo '<br>' . chr(10) . chr(10);
    $tamed_booking = true;
    foreach ($filters as $filter) {
        if ($filter[0] == 'tamed_booking') {
            $tamed_booking = $filter[1];
        }
    }
    entrylist_invoice_exported($SQL, $tamed_booking, $area_spesific);
}

Example #6

File: entry_list.php Project: hnJaermuseet/JM-booking

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., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
*/
require 'include/entry_list.php';
print_header($day, $month, $year, $area);
echo '<h1>' . $entry_list_heading . '</h1>' . chr(10);
echo $entry_list_ingress;
echo '<div class="hiddenprint">';
filterLink($filters, $return_to);
echo '</div>' . chr(10);
filterPrint($filters);
echo '<br>' . chr(10);
echo '<br>' . chr(10) . chr(10);
$emaillist_entry = '';
$tamed_booking = true;
foreach ($filters as $filter) {
    if ($filter[0] == 'tamed_booking') {
        $tamed_booking = $filter[1];
    }
}
if (!$tamed_booking || !mysql_num_rows($Q)) {
    echo __('No entries found.');
} else {
    echo mysql_num_rows($Q) . ' ' . __('entries found.');

Example #7

File: invoice_soon.php Project: hnJaermuseet/JM-booking

        echo '<a href="' . $_SERVER['PHP_SELF'] . '?area_id=' . $R['area_id'] . '">' . $R['area_name'] . '</a>';
        if ($area_spesific && $area_invoice['area_id'] == $R['area_id']) {
            echo '</b>';
        }
        if ($counter_area != $num_area) {
            echo ' -:- ';
        }
    }
    echo '<br /><br /></span>';
    $filters = array();
    $filters = addFilter($filters, 'invoice', '1');
    $filters = addFilter($filters, 'invoice_status', '1');
    $filters = addFilter($filters, 'time_end', 'current', '>');
    if ($area_spesific) {
        $filters = addFilter($filters, 'area_id', $area_invoice['area_id']);
    }
    $SQL = genSQLFromFilters($filters, 'entry_id');
    filterLink($filters, 'invoice_soon');
    echo '<br>' . chr(10);
    echo '</span>';
    filterPrint($filters);
    echo '<br>' . chr(10);
    echo '<br>' . chr(10) . chr(10);
    $tamed_booking = true;
    foreach ($filters as $filter) {
        if ($filter[0] == 'tamed_booking') {
            $tamed_booking = $filter[1];
        }
    }
    entrylist_invoice_soon($SQL, $tamed_booking, $area_spesific);
}

Example #8

File: invoice_tobemade.php Project: HNygard/JM-booking

    echo '<br>' . chr(10) . chr(10);
    entrylist_invoice_tobemade($SQL);
} else {
    echo '</h1>' . chr(10) . chr(10);
    echo 'Øverst er de som har passert arrangementsdato. Listen under er de kommende bookingene med faktura planlagt.';
    echo '<br><br>';
    $filters = array();
    $filters = addFilter($filters, 'invoice', '1');
    $filters = addFilter($filters, 'invoice_status', '1');
    $filters = addFilter($filters, 'time_start', 'current', '<');
    $SQL = genSQLFromFilters($filters, 'entry_id');
    filterLink($filters, 'invoice_tobemade');
    echo '<br>' . chr(10);
    filterPrint($filters);
    echo '<br>' . chr(10);
    echo '<br>' . chr(10) . chr(10);
    entrylist_invoice_tobemade($SQL);
    echo '<br><br>';
    echo '<h2>Bookinger som snart gjennomføres og som skal ha faktura</h2>';
    $filters = array();
    $filters = addFilter($filters, 'invoice', '1');
    $filters = addFilter($filters, 'invoice_status', '1');
    $filters = addFilter($filters, 'time_start', 'current', '>');
    $SQL = genSQLFromFilters($filters, 'entry_id');
    filterLink($filters, 'entry_list');
    echo '<br>' . chr(10);
    filterPrint($filters);
    echo '<br>' . chr(10);
    echo '<br>' . chr(10) . chr(10);
    entrylist_invoice_tobemade($SQL);
}