/** * @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>"; }