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 | 1 | BO86400 | 24.12.2020 00:00:00 | 5000 | View Edit Remove | |
| 2 | 10364 | OM3149 | 16.07.2020 00:00:00 | 605002 | View Edit Remove | |
| 3 | 103600 | OM31491 | 23.07.2020 00:00:00 | 605000 | View Edit Remove | |
| 4 | 11310 | HQ5502 | 20.12.2001 00:00:00 | 14190 | View Edit Remove | |
| 5 | 11221 | HQ55023 | 29.06.1995 00:00:00 | 99 | View Edit Remove | |
| 6 | 112 | HQ55022 | 30.07.2020 00:00:00 | 99 | View Edit Remove | |
| 7 | 113 | GG31455 | 16.05.2003 00:00:00 | 45870 | View Edit Remove | |
| 8 | 114 | MA76552 | 15.12.2004 00:00:00 | 82261 | View Edit Remove | |
| 9 | 114 | NP60385 | 31.05.2003 00:00:00 | 7565 | View Edit Remove | |
| 10 | 114 | NR27552 | 10.03.2004 00:00:00 | 44894 | View Edit Remove |