Advanced Filter - Demo2 NEW
Simple Advanced filter - Hidden Panel
HIDE CODE
<?php
$xcrud = Xcrud::get_instance();
$xcrud->table("payments");
$xcrud->label("customerNumber","Customer Number");
$xcrud->label("paymentDate","Payment Date");
//1st Param: whether to show or hide advanced search button
//2nd Param: Position to show advanced panel. Can be top, bottom, right or left
//3rd Param: Makes the advanced panel either opened or closed on window load
$xcrud->advanced_search_active(true,'left',false);
//1st Param: Sequence of field arrangement. Start with 1
//2nd Param: Field Name
//3rd Param: Operator can be "<",">","=","IN","LIKE"
//4th Param: Search Column Title
$xcrud->advanced_filter(1,"amount",">","Amount Greater Than");
$xcrud->advanced_filter(2,"amount","<","Amount Less Than");
$xcrud->advanced_filter(3,"paymentDate",">", "Payment date greater than ");
$xcrud->advanced_filter(4,"checkNumber","LIKE", "Check Number Like ");
echo $xcrud->render();
?>
Payments
| # | Customer Number | Checknumber | Payment Date | Amount | Test1 | |
|---|---|---|---|---|---|---|
| 1 | 141 | KT52578 | 09.12.2003 00:00:00 | 63843.55 | View Edit Remove | |
| 2 | 141 | MC46946 | 09.07.2004 00:00:00 | 35420.74 | View Edit Remove | |
| 3 | 141 | MF629602 | 16.08.2004 00:00:00 | 35420.74 | View Edit Remove | |
| 4 | 141 | NU627706 | 17.05.2004 00:00:00 | 26155 | View Edit Remove | |
| 5 | 144 | IR846303 | 12.12.2004 00:00:00 | 36005.71 | View Edit Remove | |
| 6 | 144 | LA685678 | 09.04.2003 00:00:00 | 7674.94 | View Edit Remove | |
| 7 | 145 | CN328545 | 03.07.2004 00:00:00 | 4710.73 | View Edit Remove | |
| 8 | 145 | ED39322 | 26.04.2004 00:00:00 | 28211.7 | View Edit Remove | |
| 9 | 145 | JJ246391 | 20.02.2003 00:00:00 | 53959.21 | View Edit Remove | |
| 10 | 146 | FP549817 | 18.03.2004 00:00:00 | 40978.9 | View Edit Remove |