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>
Warning: mysqli_connect(): (HY000/1049): Unknown database 'xcrud1_7_v6' in /var/www/html/xcrud/demo/xcrud-lte/xCrud_1.7.26/xcrud/xcrud_db.php on line 50
xCRUDConnection error. Can not connect to database