|
|
|
<?php
//session_start();
//include("connection.php");
?>
<?php
/**
* Created by PhpStorm.
* User: christopheweibel
* Date: 16/01/15
* Time: 12:20
*/
header("Content-type:application/json");
$link = mysqli_connect('localhost', 'root', '', 'mysql');
$json_param = file_get_contents("php://input");
$params = json_decode($json_param,true);
/* check connection */
if (!$link) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$filterQuery = NULL;
$skip = isset($params['skip']) ? $params['skip'] : 0 ;
$take = isset($params['take']) ? $params['take'] : 0;
$search = isset($params['search']) ? $params['search'] : NULL ;
$filter = isset($params['where']) ? $params['where'] : NULL ;
$sort = isset($params['sorted']) ? $params['sorted'] : NuLL ;
$select = isset($params['select']) ? $params['select'] : NuLL ;
$query =$sql = "SELECT * FROM help_category";
/* Searching operation */
. . . . .
if($take != null && $take > 0){
$query = $query." limit ".$skip.",".$take; //perform skip and take operation
}
$result = mysqli_query($link,$query);
$json=array();
while ($row = mysqli_fetch_array($result)) {
array_push($json,array(
'help_category_id' => $row{'help_category_id'},
'name' => $row{'name'},
'parent_category_id' => $row{'parent_category_id'},
));
}
. . . . . .
/* Selection Operation */
?>
|
|
public ActionResult UrlDataSource(DataManager dm)
{
IEnumerable DataSource = OrderRepository.GetAllRecords();
DataOperations ds = new DataOperations();
List<string> str = new List<string>();
if (dm.Search != null && dm.Search.Count > 0)
{
DataSource = ds.PerformSearching(DataSource, dm.Search);
}
if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting
{
DataSource = ds.PerformSorting(DataSource, dm.Sorted);
}
if (dm.Where != null && dm.Where.Count > 0) //Filtering
{
DataSource = ds.PerformWhereFilter(DataSource, dm.Where, dm.Where[0].Operator);
}
var count = DataSource.Cast<EditableOrder>().Count();
DataSource = ds.PerformSkip(DataSource, dm.Skip);
if (dm.Take != null && dm.Take > 0)
{
DataSource = ds.PerformTake(DataSource, dm.Take);
}
return Json(new { result = DataSource, count = count });
} |