public function alerts($cc = null) { $current_user = ParseUser::getCurrentUser(); $query = new ParseQuery("Notifications"); $query->equalTo("for", $current_user); $query->equalTo("read", false); $query->includeKey('by'); $query->includeKey('message'); try { $notifications = $query->find(); $notes = array(); foreach ($notifications as $notify) { if (!empty($notify->get('message'))) { if ($notify->get('message')->get('chatRoom')->getObjectId() == $cc) { $notify->set("read", true); $notify->save(); continue; } $notes[] = ['id' => $notify->getObjectId(), 'for' => $notify->get('for')->getObjectId(), 'from' => ['id' => $notify->get('by')->getObjectId(), 'name' => $notify->get('by')->get('name')], 'message' => $notify->get('message')->get('message')]; } } $ret = ['status' => "success", 'data' => ['notifications' => $notes]]; return response()->json($ret); } catch (ParseException $ex) { $ret = ['status' => 'fail', 'error' => $ex->getMessage()]; return response()->json($ret); } }
function getSeekers() { $query = new ParseQuery("BagTransaction"); $query->doesNotExist("status"); $results = $query->find(); $users = array(); //convert BagTransactions to Users foreach ($results as $result) { $user = $result->get("borrower"); $user->fetch(); $users[] = $user; } return $users; }
/** * App index simply grabs all the user's items and returns them. The template will render the list. * * @return array */ public function indexAction() { $query = new ParseQuery(self::PARSE_CLASS); $query->equalTo('user', $this->user); $items = $query->find(); return ['items' => $items]; }
/** * Executes the query and returns its results. * * @param string|string[] $selectKeys * * @return Collection */ public function get($selectKeys = null) { if ($selectKeys) { $this->select($selectKeys); } return $this->createModels($this->parseQuery->find($this->useMasterKey)); }
public function getUserCompanies($user) { $query = new ParseQuery(self::$parseClassName); $query->equalTo("users", $user); $results = $query->find(); return $results; }
/** * @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; }
public function create(array $params = []) { $query = new ParseQuery("Brand"); $results = $query->find(); @($this->viewData->brands = $results); @$this->loadView($this->viewData); }
function getSleepers() { $query = new ParseQuery("BagTransaction"); $query->equalTo("status", "active"); $results = $query->find(); return $results; }
function getSeekers() { $query = new ParseQuery("_User"); $query->equalTo("seeking", true); $results = $query->find(); return $results; }
public function query() { //iniciamos una consulta para recibir todos los usuarios ausentes de la sede del mentor logueado $query = new ParseQuery("Asistencia"); $query->equalTo('Sede', array("__type" => "Pointer", "className" => "Sedes", "objectId" => $_SESSION['sede'])); $query->includeKey('Usuario_FK'); $results = $query->find(); $listado = array(); for ($i = 0; $i < count($results); $i++) { $object = $results[$i]; $usuario = $object->get('Usuario_FK'); $persona = array("ID" => $object->getObjectId(), 'Nombre' => $usuario->get("Nombre"), "Apellido" => $usuario->get("Apellido"), "Presente" => $object->get("Presente")); array_push($listado, $persona); } //definimos una función para ordenar el array con nuestros parámetros function custom_sort($a, $b) { return $a['Nombre'] > $b['Nombre']; } //ordenamos el array usort($listado, "custom_sort"); //transformamos a json $json = json_encode($listado); echo $json; }
public function operators() { $query = new ParseQuery("_User"); $query->equalTo("isOperator", true); $results["operators"] = $query->find(); return $results; }
public function getQuery() { $query = new ParseQuery(Constant::$CLIENT_CONTACT_INFO_CLASS_NAME); // $query->equalTo(Constant::$KEY_FIRST_NAME, $firstName); $query->descending("createdAt"); $results = $query->find(); return $results; }
public function traerNoticiasSeccion($seccion) { $query = new ParseQuery("noticias"); $query->descending("fecha"); $query->equalTo("seccion", $seccion); $results = $query->find(); return $results; }
/** * Returns all objects where a given field matches a given value * @param string $field * @param mixed $value * @param array $keyToInclude * * @return Collection|ParseObject[] */ public function findAllBy($field, $value, $keyToInclude = []) { $this->query->equalTo($field, $value); for ($i = 0; $i < count($keyToInclude); $i++) { $this->query->includeKey($keyToInclude[$i]); } return Collection::make($this->query->find($this->useMasterKey)); }
public function index() { $query = new ParseQuery("attractions"); try { $attractions = $query->find(); return view('expertTemplate.displayAttractions')->with('attractions', $attractions); } catch (ParseException $ex) { } }
/** * 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 getCarsOfUsers($userObjectId) { $_user = new ParseQuery("_User"); $_user->get($userObjectId); $user = $_user->find(); $_car = new ParseQuery("Car"); $_car->equalTo("owner", $user[0]); $cars = $_car->find(); return $cars; }
function getAllRestaurantsAround() { try { $query = new ParseQuery("Restaurant"); $results = $query->find(); } catch (ParseException $ex) { echo $ex; } return $results; }
function getStolenBikes() { $query = new ParseQuery("Bikes"); $query->exists("sessionStartTime"); $query->limit(1000); $results = $query->find(); $count = count($results); $listOfBikes = array(); $stolenBikes = 0; for ($i = 0; $i < $count; $i++) { $startDate = $results[$i]->get("sessionStartTime"); $startDate = $startDate->format('Y-m-d H:i:s'); $startDate = strtotime($startDate); $currentDate = new DateTime('now'); $currentDate = $currentDate->format('Y-m-d H:i:s'); $currentDate = strtotime($currentDate); $subtractedDate = $currentDate - $startDate; $expiredTime = 200 * 60; if ($subtractedDate >= $expiredTime * 60) { $stolenBikes++; $bike = $results[$i]; try { $lostBike = new ParseObject("LostBikes"); $lostBike->set("bikeId", $bike->getObjectId()); $user = $bike->get("currentUser"); $user->fetch(); $customerID = $user->get("stripeID"); $amount = 200 * 100; $charge = \Stripe\Charge::create(array('customer' => $customerID, 'amount' => $amount, 'currency' => 'usd')); $lostBike->set("currentUser", $user); $lostBike->set("lastLocation", $bike->get("lastLocation")); $lostBike->set("condition", $bike->get("condition")); $lostBike->save(); $bike->destroy(); } catch (\Parse\ParseException $ex) { return 'Failed to create LostBikes object and destroy Bikes object ' . $ex->getMessage(); } catch (\Stripe\Error\InvalidRequest $e) { return $e->getMessage(); } catch (\Stripe\Error\Authentication $e) { return $e->getMessage(); } catch (\Stripe\Error\ApiConnection $e) { return $e->getMessage(); } catch (\Stripe\Error\Base $e) { return $e->getMessage(); } catch (Exception $e) { return $e->getMessage(); } } } $rString = 0; if ($stolenBikes > 0) { $rString = "Successfully removed " . $stolenBikes . " stolen bikes."; } return $rString; }
public function information() { $om = new ParseObject("OmOpenMenu", "oGBLMAeTPO"); $query = new ParseQuery("OmRi"); $query->equalTo("omID", $om); $results = $query->find(); // Get a specific object: $data['information'] = $results[0]; $data['singleView'] = true; $this->render('restaurant/information', $data); }
function getAllOrganizationFromCacheOrQuery() { global $cache; $organizations = $cache->get("all_organization"); if ($resources == null) { $query = new ParseQuery("Organization"); $organizations = $query->find(); $cache->set("all_organization", $resources, 1800); } return $organizations; }
function getAllResourcesFromCacheOrQuery() { global $cache; $resources = $cache->get("all_resource"); if ($resources == null) { $query = new ParseQuery("Resource"); $resources = $query->find(); $cache->set("all_resource", $resources, 1800); } return $resources; }
public function get_id($id) { $query = new ParseQuery('CarWashPackages'); try { $query->get($id); $results["packages"] = $query->find(); } catch (ParseException $ex) { $ex_array = array("Message" => $ex->getMessage(), "Code" => $ex->getCode()); return $ex_array; } return $results; }
function getAllEventFromCacheOrQuery() { global $cache; $results = $cache->get("all_event"); if ($results == null) { $query = new ParseQuery("Event"); $results = $query->find(); //cache 15 minute $cache->set("all_event", $results, 900); } return $results; }
public function ventasDiaTotales($fecha) { $query = new ParseQuery("facturas"); $query->startsWith("fecha", $fecha); $results = $query->find(); $data['facturas'] = ''; //print_r($results[0]->folio); foreach ($results as $record) { echo $record->serie . $record->folio; } $this->load->view('reportes/ventas_dia', $data); }
public function getReports() { $query = new ParseQuery("ReportOperator"); $query->includeKey("user"); $query->includeKey("operator"); $results["reports"] = $query->find(); // for ($i = 0; $i < count($results); $i++) { // $usernames = $results[$i]->get("username"); // } // die("<pre>".print_r($results, true)); return $results; }
public function tasks() { $results = array(); $object = array(); $queryCrop = new ParseQuery("Crop"); $queryCrop->select("cropName"); $queryCrop->ascending("cropName"); $object = $queryCrop->find(); foreach ($object as $value) { array_push($results, $value->get('cropName')); } return view('tasks')->with("results", $results); }
public function getAll() { $query = new ParseQuery("todo"); $results = $query->find(); $resposnse = []; foreach ($results as $result) { $object = new \stdClass(); $object->completed = $result->get('completed'); $object->id = $result->getObjectId(); $object->title = $result->get('title'); $resposnse[] = $object; } return $resposnse; }
/** * Default */ function index() { // setup page header data $this->set_title(sprintf(lang('reservations title reservations'), $this->settings->site_name)); $this->set_subtitle(lang('reservations subtitle reservations')); $data = $this->includes; // set content data $query = new ParseQuery("Reservation"); $reservations = $query->find(); $content_data = array('welcome_message' => $this->settings->welcome_message, 'reservations' => $reservations); // load views $data['content'] = $this->load->view('reservations/list', $content_data, true); $this->load->view($this->template, $data); }
public function eliminar() { $id = Input::get('id'); $curso = Curso::find($id); $curso->delete(); $query = new ParseQuery("cursos"); $query->equalTo("myid", 14); $results = $query->find(); //echo "Successfully retrieved " . count($results) . " scores."; // Do something with the returned ParseObject values for ($i = 0; $i < count($results); $i++) { $object = $results[$i]; $object->destroy(); } }