$sWhere .= " `user`.`user_name` LIKE ? OR `group`.`group_name` LIKE ? OR "; $search_param[] = '%' . $_GET['sSearch'] . '%'; $search_param[] = '%' . $_GET['sSearch'] . '%'; } else { $sWhere .= " " . $fields_info[$aColumns[$i]]["table"] . "." . $aColumns[$i] . " LIKE ? OR "; $search_param[] = '%' . $_GET['sSearch'] . '%'; } } } } for ($i = 0; $i < $_GET['iColumns']; $i++) { if ($_GET['sSearch_' . $i] != '') { if ($sWhere != "") { $sWhere .= " AND "; } else { $sWhere .= "WHERE "; } } } //echo $sWhere;exit; $do_data_display->set_ds_where_cond($sWhere); $do_data_display->set_ds_search_params($search_param); $do_data_display->set_ds_fields_info($fields_info); $do_data_display->set_ds_show_record_selector(false); $do_data_display->set_ds_object($object); //-- while showing the related values do not use group by in Products if ($module == 'Products') { $object->list_query_group_by = ''; } $do_data_display->display_data($mid, false, $primary_key);
} } $query_params = array(); //print_r($custom_view_adv_filter_qry); if (false !== $custom_view_adv_filter_qry) { if (count($custom_view_adv_filter_qry["bind_params"]) > 0) { $query_params = $custom_view_adv_filter_qry["bind_params"]; if (count($search_param) > 0) { foreach ($search_param as $key => $val) { array_push($query_params, $val); } } } } elseif (count($search_param) > 0) { $query_params = $search_param; } for ($i = 0; $i < $_GET['iColumns']; $i++) { if ($_GET['sSearch_' . $i] != '') { if ($sWhere != "") { $sWhere .= " AND "; } else { $sWhere .= "WHERE "; } } } $do_data_display->set_ds_where_cond($sWhere); $do_data_display->set_ds_search_params($query_params); $do_data_display->set_ds_fields_info($fields_info); $do_data_display->set_ds_object($object); $do_data_display->display_data($mid);
} else { $sWhere .= " " . $fields_info[$aColumns[$i]]["table"] . "." . $aColumns[$i] . " LIKE ? )"; $search_param[] = '%' . $_GET['sSearch'] . '%'; } } else { if ($aColumns[$i] == 'assigned_to') { $sWhere .= "`user`.`user_name` LIKE ? OR `group`.`group_name` LIKE ? OR "; $search_param[] = '%' . $_GET['sSearch'] . '%'; $search_param[] = '%' . $_GET['sSearch'] . '%'; } else { $sWhere .= " " . $fields_info[$aColumns[$i]]["table"] . "." . $aColumns[$i] . " LIKE ? OR "; $search_param[] = '%' . $_GET['sSearch'] . '%'; } } } } for ($i = 0; $i < $_GET['iColumns']; $i++) { if ($_GET['sSearch_' . $i] != '') { if ($sWhere != "") { $sWhere .= " AND "; } else { $sWhere .= "WHERE "; } } } $do_data_display->set_ds_where_cond($sWhere); $do_data_display->set_ds_search_params($search_param); $do_data_display->set_ds_fields_info($fields_info); $do_data_display->set_ds_object($object); $do_data_display->display_data($mid, true);