add extjs 6.0.1 sources

[extjs.git] / extjs / examples / kitchensink / data / grid / grid-filter.php

<?php\r
\r
function getDB() {\r
    $dbFile = "filter-demo.db";\r
    $hasDB = file_exists($dbFile);\r
\r
    $db = new SQLiteDatabase($dbFile);\r
    if (!$hasDB) {\r
        $db->query(readCreateSql());\r
    }\r
    return $db;\r
}\r
\r
function readCreateSql() {\r
    $filename = "grid-demo.sql";\r
    $file = fopen($filename, 'r');\r
    $data = fread($file, filesize($filename));\r
    fclose($file);\r
    return $data;\r
}\r
\r
// collect request parameters\r
$start  = isset($_REQUEST['start'])  ? $_REQUEST['start']  :  0;\r
$count  = isset($_REQUEST['limit'])  ? $_REQUEST['limit']  : 50;\r
$sort   = isset($_REQUEST['sort'])   ? json_decode($_REQUEST['sort'])   : null;\r
$filters = isset($_REQUEST['filter']) ? $_REQUEST['filter'] : null;\r
\r
$sortProperty = $sort[0]->property; \r
$sortDirection = $sort[0]->direction;\r
\r
// GridFilters sends filters as an Array if not json encoded\r
if (is_array($filters)) {\r
    $encoded = false;\r
} else {\r
    $encoded = true;\r
    $filters = json_decode($filters);\r
}\r
\r
$where = ' 0 = 0 ';\r
$qs = '';\r
\r
// loop through filters sent by client\r
if (is_array($filters)) {\r
    for ($i=0;$i<count($filters);$i++){\r
        $filter = $filters[$i];\r
\r
        // assign filter data (location depends if encoded or not)\r
        if ($encoded) {\r
            $field = $filter->field;\r
            $value = $filter->value;\r
            $compare = isset($filter->comparison) ? $filter->comparison : null;\r
            $filterType = $filter->type;\r
        } else {\r
            $field = $filter['field'];\r
            $value = $filter['data']['value'];\r
            $compare = isset($filter['data']['comparison']) ? $filter['data']['comparison'] : null;\r
            $filterType = $filter['data']['type'];\r
        }\r
\r
        switch($filterType){\r
            case 'string' : $qs .= " AND ".$field." LIKE '%".$value."%'"; Break;\r
            case 'list' :\r
                if (strstr($value,',')){\r
                    $fi = explode(',',$value);\r
                    for ($q=0;$q<count($fi);$q++){\r
                        $fi[$q] = "'".$fi[$q]."'";\r
                    }\r
                    $value = implode(',',$fi);\r
                    $qs .= " AND ".$field." IN (".$value.")";\r
                }else{\r
                    $qs .= " AND ".$field." = '".$value."'";\r
                }\r
            Break;\r
            case 'boolean' : $qs .= " AND ".$field." = ".($value); Break;\r
            case 'numeric' :\r
                switch ($compare) {\r
                    case 'eq' : $qs .= " AND ".$field." = ".$value; Break;\r
                    case 'lt' : $qs .= " AND ".$field." < ".$value; Break;\r
                    case 'gt' : $qs .= " AND ".$field." > ".$value; Break;\r
                }\r
            Break;\r
            case 'date' :\r
                switch ($compare) {\r
                    case 'eq' : $qs .= " AND ".$field." = '".date('Y-m-d',strtotime($value))."'"; Break;\r
                    case 'lt' : $qs .= " AND ".$field." < '".date('Y-m-d',strtotime($value))."'"; Break;\r
                    case 'gt' : $qs .= " AND ".$field." > '".date('Y-m-d',strtotime($value))."'"; Break;\r
                }\r
            Break;\r
        }\r
    }\r
    $where .= $qs;\r
}\r
\r
$query = "SELECT * FROM demo WHERE ".$where;\r
$query .= " ORDER BY ".$sortProperty." ".$sortDirection;\r
$query .= " LIMIT ".$start.",".$count;\r
\r
$db = getDB();\r
$count = $db->singleQuery("SELECT COUNT(id) FROM demo WHERE ".$where);\r
$result = $db->query($query);\r
$rows = Array();\r
while($row = $result->fetch(SQLITE_ASSOC)) {\r
    array_push($rows, $row);\r
}\r
echo json_encode(Array(\r
    "total"=>$count,\r
    "data"=>$rows\r
));\r
\r
?>