Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - Dan95

Pages: [1]
1
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
Code: [Select]
<!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
Code: [Select]
<?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

Pages: [1]