Advanced Filter - Demo3 NEW
Complex Advanced filter
HIDE CODE
<?php
$xcrud = Xcrud::get_instance();
$xcrud->table("payments");
$xcrud->label("customerNumber","Customer Number");
$xcrud->label("paymentDate","Payment Date");
//$xcrud->change_type("customerNumber","select","",array(1=>"MPESA",2=>"Cash"));
//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: whether top make adavanced panel always opened or closed
$xcrud->advanced_search_active(true,'left',true);
//
$xcrud->advanced_filter(1,"customerNumber","IN","Customer Numer In List");
$xcrud->advanced_filter(2,"amount",">","Amount Greater Than");
$xcrud->advanced_filter(3,"amount","<","Amount Less Than");
$xcrud->advanced_filter(4,"paymentDate",">", "Payment date greater than ");
$xcrud->advanced_filter(5,"checkNumber","LIKE", "Check Number Like ");
//$xcrud->change_type("amount","checkboxes","",array(10000=>10000,20000=>20000));
//$xcrud->change_type("customerNumber","textarea");
$db = Xcrud_db::get_instance();
$query = 'SELECT * from payments' ;
$db->query($query);
$result = $db->result();
$cnt = 0;
$array_customer_number = array();
foreach ($result as $key => $item)
{
$customerNumber = $item['customerNumber'];
$array_customer_number[$customerNumber] = $customerNumber;
}
$xcrud->change_type("customerNumber","multiselect","",$array_customer_number);
echo $xcrud->render();
?>
<link href="../xcrud/plugins/select2-develop/dist/css/select2.min.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="../xcrud/plugins/select2-develop/dist/js/select2.full.js"></script>
<script type="text/javascript">
$(document).on("xcrudbeforerequest", function(event, container) {
if (container) {
try{
$(container).find("select").select2('destroy');
}catch(e){
}
} else {
try{
$(".xcrud").find("select").select2('destroy');
}catch(e){
}
}
});
$(document).on("ready xcrudafterrequest", function(event, container)
{
if (container) {
try{
$(container).find("select").select2();
}catch(e){
}
} else {
try{
$(".xcrud").find("select").select2();
}catch(e){
}
}
});
$(document).on("xcrudbeforedepend", function(event, container, data) {
console.log(data.name);
//if (container) {
console.log(!$.isEmptyObject($(container).find('select[name="' + data.name + '"]')));
console.log(data.name);
//if(!$.isEmptyObject($(container).find('select[name="' + data.name + '"]'))){
if ($(container).find('select[name="' + data.name + '"]').data('select2')) {
console.log("select2 item");
$(container).find('select[name="' + data.name + '"]').select2('destroy');
} else {
console.log("Not a select2 ");
}
//}
// }
});
$(document).on("xcrudafterdepend", function(event, container, data) {
$(container).find('select[name="' + data.name + '"]').select2();
try{
$(container).find("select").select2();
}catch(e){
}
});
$( document ).ready(function() {
$(".xcrud").find("select").select2();
});
</script>
Payments
| # | Customer Number | Checknumber | Payment Date | Amount | |
|---|---|---|---|---|---|
| 1 | 157 | 12-123456_ | 19.11.2004 00:00:00 | 3 | View Edit Remove |
| 2 | 161 | BR352384 | 14.11.2004 00:00:00 | 5500 | View Edit Remove |
| 3 | 161 | BR478494 | 18.11.2003 00:00:00 | 50743.65 | View Edit Remove |
| 4 | 161 | KG644125 | 02.02.2005 00:00:00 | 12692.19 | View Edit Remove |
| 5 | 161 | NI908214 | 05.08.2003 00:00:00 | 38675.13 | View Edit Remove |
| 6 | 167 | GN228846 | 03.12.2003 00:00:00 | 85024.46 | View Edit Remove |
| 7 | 171 | GB878038 | 15.03.2004 00:00:00 | 18997.89 | View Edit Remove |
| 8 | 171 | IL104425 | 22.11.2003 00:00:00 | 42783.81 | View Edit Remove |
| 9 | 172 | AD832091 | 09.09.2004 00:00:00 | 1960.8 | View Edit Remove |
| 10 | 172 | CE51751 | 04.12.2004 00:00:00 | 51209.58 | View Edit Remove |