Hey I'm new here and I got 1 Error in my Code.
My English is not the best but I try to explain my Problem so good as I can.
The Plugin shows me all data from my database. That is not my Problem.
I implemented the remote Filterskript from the Paramquery Homepage.
Without any Problems.
If I try to search with keywords, I got the < Uncaught Error : SyntaxError: Unexpected token < pqgrid.min.js9
<xhr.h.ajax.error @ pqgrid.min.js:9
c @ jquery.min.js:3
p.fireWith @ jquery.min.js:3
k @ jquery.min.js:5
r @ jquery.min.js:5
Does anyone know what the Error means?
Here is some code from me.
table2.php
<!DOCTYPE html>
<html>
<head>
<!--jQuery dependencies-->
<link rel="stylesheet" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.9.1/themes/base/jquery-ui.css" />
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.9.2/jquery-ui.min.js"></script>
<!--PQ Grid files-->
<!--PQ Grid Office theme-->
<link rel="stylesheet" href="grid/pqgrid.min.css" />
<script src="grid/pqgrid.min.js"></script>
<link rel="stylesheet" href="grid/themes/office/pqgrid.css" />
<script class="ppjs">
$(function () {
function filterhandler(evt, ui)
{
var $toolbar = $grid.find('.pq-toolbar-search'),
$value = $toolbar.find(".filterValue"),
value = $value.val(),
condition = $toolbar.find(".filterCondition").val(),
dataIndx = $toolbar.find(".filterColumn").val(),
filterObject;
if (dataIndx == "")
{
filterObject = [];
var CM = $grid.pqGrid("getColModel");
for(var i=0, len=CM.length; i<len; i++)
{
var dataIndx = CM[i].dataIndx;
filterObject.push({dataIndx: dataIndx, condition: condition, value: value});
}
}
else
{
filterObject = [{dataIndx: dataIndx, condition: condition, value: value}];
}
$grid.pqGrid("filter",
{
oper: 'replace',
data: filterObject
});
}
var colM = [
/*{ title: "ID", width: 100},*/
{ title: "Datum", width: 100},
{ title: "KW", width:100},
{ title: "Monteure", width: 100},
{ title: "Planung", width: 200},
{ title: "Notizen", width: 400}
];
var dataModel = {
recIndx: "datum",
location : "remote",
sorting: "local",
paging: "local",
dataType: "JSON",
method: "GET",
rPP: 10,
url: "get_data2.php",
getData: function (response) {
return {data: response.data};
}
}
var newObj = {
flexHeight: true,
flexWidth: true,
dataModel: dataModel,
bottomVisible: true,
colModel: colM,
pageModel: {type: "local", rPP: 20, strRpp: "{0}"},
selectionModel: {mode: 'single'},
filterModel: {mode: 'OR', type: "remote"},
toolbar: {
cls: "pq-toolbar-search",
items: [
{type: "<span style='margin:5px;'>Filter</span>"},
{type: 'textbox', attr: 'placeholder="Suche"', cls: "filterValue", listeners: [{'change': filterhandler}]},
{type: 'select', cls: "filterColumn",
listeners: [{'change': filterhandler}],
options: function(ui){
var CM=ui.colModel;
var opts = [{ '': '[Alle Felder]'}];
for(var i=0; i<CM.length; i++){
var column = CM[i];
var obj = {};
obj[column.dataIndx] = column.title;
opts.push(obj);
}
return opts;
}
},
{type : 'select', style: "margin:0px 5px;", cls: "filterCondition",
listeners: [{'change': filterhandler}],
options: [
{ "begin": "Beginnt mit" },
{ "contain": "Beinhaltet" },
{ "end": "Endet mit" },
{ "notcontain": "Beinhaltet nicht!" }
]
}
]
},
editable: false,
scrollModel: {horizontal: false},
title: "Montageplanung",
columnBorders: false
};
var $grid = $("#grid_php").pqGrid(newObj);
});
</script>
</head>
<body>
<div id="grid_php" style="margin:5px auto;"></div>
<!-- Die Ausgabetabelle nur als Grundgerüst definiert, weil die Ausgabe Serverseitig geschieht-->
<!--
<table id="grid_array" border="0" class="display" cellspacing="0" cellpadding="0" width="100%" style="text-align: center;">
<thead>
<tr>
<th>ID</th>
<th>Datum</th>
<th>KW</th>
<th>Monteure</th>
<th>Planung</th>
<th>Notiz</th>
</tr>
</thead>
</table>
-->
</body>
</html>
get_data2.php
<?php
class ColumnHelper
{
public static function isValidColumn($dataIndx)
{
if (preg_match('/^[a-z,A-Z]*$/', $dataIndx))
{
return true;
}
else
{
return false;
}
}
}
class FilterHelper
{
public static function deSerializeFilter($pq_filter)
{
$filterObj = json_decode($pq_filter);
$mode = $filterObj->mode;
$filters = $filterObj->data;
$fc = array();
$param= array();
foreach ($filters as $filter)
{
$dataIndx = $filter->dataIndx;
if (ColumnHelper::isValidColumn($dataIndx) == false)
{
throw new Exception("Invalid column name");
}
$text = $filter->value;
$condition = $filter->condition;
if ($condition == "contain")
{
$fc[] = $dataIndx . " like CONCAT('%', ?, '%')";
$param[] = $text;
}
else if ($condition == "notcontain")
{
$fc[] = $dataIndx . " not like CONCAT('%', ?, '%')";
$param[] = $text;
}
else if ($condition == "begin")
{
$fc[] = $dataIndx . " like CONCAT( ?, '%')";
$param[] = $text;
}
else if ($condition == "end")
{
$fc[] = $dataIndx . " like CONCAT('%', ?)";
$param[] = $text;
}
else if ($condition == "equal")
{
$fc[] = $dataIndx . " = ?";
$param[] = $text;
}
else if ($condition == "notequal")
{
$fc[] = $dataIndx . " != ?";
$param[] = $text;
}
else if ($condition == "empty")
{
$fc[] = "ifnull(" . $dataIndx . ",'')=''";
}
else if ($condition == "notempty")
{
$fc[] = "ifnull(" . $dataIndx . ",'')!=''";
}
else if ($condition == "less")
{
$fc[] = $dataIndx . " < ?";
$param[] = $text;
}
else if ($condition == "great")
{
$fc[] = $dataIndx . " > ?";
$param[] = $text;
}
}
$query = "";
if (sizeof($filters) > 0)
{
$query = " where " . join(" ".$mode." ", $fc);
}
$ds = new stdClass();
$ds->query = $query;
$ds->param = $param;
return $ds;
}
}//end of class
$filterQuery = "";
$filterParam = array();
if(isset($_GET["pq_filter"]))
{
$pq_filter = $_GET["pq_filter"];
$dsf = FilterHelper::deSerializeFilter($pq_filter);
$filterQuery = $dsf->query;
$filterParam = $dsf->param;
}
$dbserver='localhost';
$dbusername='root';
$dbpassword='';
$dbname='monteureinsatz';
$db=mysql_connect("$dbserver","$dbusername","$dbpassword");
$currDb=mysql_selectdb($dbname) or die (mysql_error());
$sqlstring="Select datum,kw,name,bezeichnung,notiz from uebersichtsplan UP
JOIN uebersichtsplan_has_mitarbeiter UHM ON (UP.ID_UP = UHM.uebersichtsplan_ID)
JOIN mitarbeiter M ON (UHM.mitarbeiter_ID = M.ID_M)
JOIN uebersichtsplan_has_planung UHP ON(UP.ID_UP = UHP.uebersichtsplan_ID)
JOIN planung P ON(UHP.planung_ID = P.ID_P) JOIN notizen ON (UP.notizen_ID = notizen.ID_N) order by ID_UP". $filterQuery;
$result=mysql_query($sqlstring) or die (mysql_error());
$php_total=mysql_num_rows($result);
$daten = array();
while($row=mysql_fetch_array($result))//while($row=mysql_fetch_array($result))
{
$daten[] = array(date('d.m.y', strtotime($row['datum'])),$row['kw'],$row['name'],$row['bezeichnung'],$row['notiz']);
}
$json_arr = array('data'=>$daten);
$php_json = json_encode($json_arr);
echo $php_json;
?>
Best Regards
Daniel
