/**
* @inheritdoc
*/
public function process(array $settings = [])
{
$this->processOrders($settings);
$this->processFilters($settings);
$this->source->limit($settings['limit']);
$this->source->skip(($settings['page'] - 1) * $settings['limit']);
// run queries
$gridData = new Grid\Data($this->source->find());
// get all records to set grid total
// @todo: cache result of total query for few minutes
$this->source = new ParseQuery($this->collectionName);
$this->processOrders($settings);
$this->processFilters($settings);
$gridData->setTotal(sizeof($this->source->limit(1000)->find()));
return $gridData;
}
/**
* Lists all ProjectsAdmin entities.
*
* @Route("/index/{page}", name="admin_projects", defaults={ "page" = 1 })
* @Method("GET")
* @Template()
*/
public function indexAction($page)
{
$query = new ParseQuery('Project');
$query->ascending("label");
$query->limit(12);
$query->skip(12 * ($page - 1));
$entities = $query->find();
return array('entities' => $entities, 'hits' => ceil($query->count() / 12), 'page' => $page, 'csrf' => $this->get('form.csrf_provider'));
}
public function testEachFailsWithSkip()
{
$total = 50;
$count = 25;
$this->saveObjects($total, function ($i) {
$obj = new ParseObject("Object");
$obj->set("x", $i + 1);
return $obj;
});
$query = new ParseQuery("Object");
$query->lessThanOrEqualTo("x", $count);
$query->skip(5);
$this->setExpectedException('\\Exception', 'skip');
$query->each(function ($obj) {
});
}
$originated = originated($user->getObjectId());
$query = new ParseQuery("_User");
$query->equalTo("objectId", $user->getObjectId());
$user = $query->first();
$query = new ParseQuery("NiceThing");
$query->includeKey("refered_user");
$query->descending("createdAt");
$query->limit(3);
$lastthreethings = $query->find();
$new = 0;
$inbox = 0;
$query = new ParseQuery("_Session");
$query->equalTo("user", $user);
$query->includeKey("user");
$query->descending("createdAt");
$query->skip(1);
$query->limit(1);
$new = $query->find(true);
if ($_SESSION['notification']) {
$query = new ParseQuery("ChatLogs");
$query->greaterThan('createdAt', date_format($new[0]->getCreatedAt(), 'Y-m-d\\TH:i:s.u\\Z'));
$inbox = count($query->find());
$query = new ParseQuery("NiceThing");
$query->greaterThan('createdAt', $new[0]->getCreatedAt());
$query->equalTo("refered_user", $user);
$new = count($query->find());
$_SESSION['notification'] = false;
} else {
$query = new ParseQuery("ChatLogs");
$query->equalTo('reciever', $user->getObjectId());
$query->greaterThan('createdAt', $_SESSION['last_date']);
public function first($className, $equalToArray = array(), $ascending = null, $descending = null, $skip = null, $includeArray = array())
{
$query = new ParseQuery($className);
if ($equalToArray) {
foreach ($equalToArray as $key => $value) {
$query->equalTo($key, $value);
}
}
if ($ascending) {
$query->ascending($ascending);
}
if ($descending) {
$query->descending($descending);
}
if ($skip) {
$query->skip($skip);
}
if ($includeArray) {
foreach ($includeArray as $include) {
$query->includeKey($include);
}
}
return $query->first();
}
<?php
require '../init.php';
use Parse\ParseQuery;
// Function to check if the request is an AJAX request
function is_ajax()
{
return isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest';
}
if (is_ajax()) {
$query = new ParseQuery("Episode");
$query->descending("epId");
$query->skip(FIRST_SHOWN_LIMIT);
$heldeeps = $query->find();
$count = count($heldeeps);
$contents = [];
for ($i = 0; $i < count($heldeeps); $i++) {
$heldeep = $heldeeps[$i];
$query = new ParseQuery("Track");
$query->equalTo("episode", $heldeep);
$tracks = $query->find();
$content = "";
for ($j = 0; $j < count($tracks); $j++) {
$track = $tracks[$j];
if ($special = $track->get("type")) {
$content .= "<h4>{$special}</h4>";
}
$content .= "<li" . ($special ? " class='special'" : "") . ">" . $track->get("title");
$content .= "<a target='_blank' href='https://soundcloud.com/search?q=" . urlencode($track->get("title")) . "'><i class='fa fa-search'></i></a>";
$content .= "</li>";
}