Hi, I have a problem with filtering data in the grid. Below I have set an example of code. Tell me what I’m doing wrong. The answer comes from the server is correct, but the data are displayed in the grid is not correct.
HTML:
var manipulationGrid, dp;
manipulationGrid = new dhtmlXGridObject(‘id_manipulation’);
manipulationGrid.setImagePath(“…/dhtmlx/imgs/”);
manipulationGrid.setHeader(“IDCat,Warehouse,Part Code,Lot Number,Part Code Name,Picking Location,Qty On Hand,Retail Price,Price (40%),Price (80%)”);
manipulationGrid.setInitWidths(“,,,,,,,,,”);
manipulationGrid.setColTypes(“ed,ed,ed,ed,ed,ed,ed,ed,ed,ed”);
manipulationGrid.setDateFormat(‘%Y-%m-%d’);
manipulationGrid.setColSorting(“int,str,str,str,str,str,int,int,int,int”);
manipulationGrid.enableSmartRendering(true);
manipulationGrid.enableMultiselect(true);
manipulationGrid.setMultiLine(false);
manipulationGrid.enableDragAndDrop(true);
manipulationGrid.init();
manipulationGrid.loadXML(“server/get_productresidues.php?IDCat=” + mas);
var dp = new dataProcessor("server/get_productresidues.php");
dp.init(manipulationGrid);
HTML event:
manipulationForm.attachEvent(“onButtonClick”, function(name){
if(name==“Find”) {
var fil=“10075663”;
var lot=“KV188879”;
manipulationGrid.loadXML(“server/get_productresidues_filter.php?IDCat=” + mas + ‘&Filter=’ + fil);
});
PHP:
<?php include '../db_params/config_mysql.php'; require("../codebase/db_mysqli.php"); require("../codebase/grid_connector.php"); /*Part variable*/ $IDCat=$_GET['IDCat']; $Filter=$_GET['Filter']; $Lot=$_GET["Lot"]; $grid = new GridConnector($dbData, "MySQLi"); $grid->enable_log("some.txt", true); $grid->dynamic_loading(4000); $grid->sort("IDProdResidues", "ASC"); $grid->filter("IDCat in (". $IDCat . ") and PartCode='" . $Filter . "'"); $grid->render_table("product_residues","IDProdResidues","IDCat,Warehouse,PartCode,LotNumber,PartCodeName,PickingLocation,QtyOnHand,RetailPrice,Price_1_40,Price_1_2_80"); ?>The answer comes correct
<?xml version='1.0' encoding='utf-8' ?>
But grid displaed wrong information. Please help me understand