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); } }
public function addTask(Request $request) { $parseTask = new ParseObject("Task"); $parseCropQuery = new ParseQuery("Crop"); $parseCropQuery->equalTo("cropName", $request->input('crop')); $crop = $parseCropQuery->first(); $parseQuery = new ParseQuery("Task"); $parseQuery->equalTo("cropName", $crop); $parseQuery->equalTo("taskDesc", $request->input('taskName')); if ($parseQuery->count() > 0) { return redirect('/tasks'); } $parseTask->set("cropName", $crop); $parseTask->set("taskDesc", $request->input('taskName')); $parseTask->set("taskDuration", $request->input('taskDuration')); $parseTask->set("taskStart", $request->input('taskStart')); try { $parseTask->save(); \Session::put('message', 1); return redirect('tasks'); } catch (ParseException $e) { \Session::put('message', -1); return redirect('tasks'); } }
public function getById($objectId) { $query = new ParseQuery($this->getClassName()); $query->equalTo('objectId', $objectId); $results = $query->first(); return $results; }
public function view() { $query = new ParseQuery('CarWashPackages'); $query->equalTo("isRemoved", false); $results["packages"] = $query->find(); return $results; }
function getSleepers() { $query = new ParseQuery("BagTransaction"); $query->equalTo("status", "active"); $results = $query->find(); return $results; }
/** * Apply filter settings to the source * * @param array $settings */ protected function processFilters(array $settings = []) { foreach ($settings['filters'] as $column => $filter) { switch (key($filter)) { case Grid\Grid::FILTER_EQ: $this->source->equalTo($column, reset($filter)); break; case Grid\Grid::FILTER_LIKE: $this->source->startsWith($column, reset($filter)); break; default: // throw NotImplemented? break; } } }
/** * Handles authentication via estonian id-card. Saves data into model User. */ public function auth() { $ePerson = getEPerson(); if (!$ePerson) { // TODO: Better handling $this->user->string = "ID kaardiga autentimine ebaõnnestus!"; } else { $this->user->lastName = $ePerson[0]; $this->user->firstName = $ePerson[1]; $this->user->nationalID = $ePerson[2]; $this->user->string = "ID kaardiga autentimine õnnestus edukalt!"; // Check if UserObject already exists // TODO: Put following code into separate function $query = new ParseQuery("UserObject"); $query->equalTo("nationalID", $this->user->nationalID); $count = $query->count(); $parseUser = $query->first(); if ($count == 1 && $parseUser->get('nationalID') == $this->user->nationalID) { $this->user->parseMessage = $parseUser->getObjectId(); } else { $this->saveUserData($this->user, $this->user->lastName, $this->user->firstName, $this->user->nationalID); } // Starts user session $this->begin_session(); // $this->signUp($this->user, $this->user->lastName, $this->user->firstName, $this->user->nationalID); } }
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; }
/** * 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]; }
public function __construct($objectId = null) { parent::__construct("Camera", $objectId, false); $query = new ParseQuery("Camera"); $query->equalTo("objectId", $objectId); $this->_cam = $query->first(); }
function getSeekers() { $query = new ParseQuery("_User"); $query->equalTo("seeking", true); $results = $query->find(); return $results; }
public function getUserCompanies($user) { $query = new ParseQuery(self::$parseClassName); $query->equalTo("users", $user); $results = $query->find(); return $results; }
public function operators() { $query = new ParseQuery("_User"); $query->equalTo("isOperator", true); $results["operators"] = $query->find(); return $results; }
public function traerNoticiasSeccion($seccion) { $query = new ParseQuery("noticias"); $query->descending("fecha"); $query->equalTo("seccion", $seccion); $results = $query->find(); return $results; }
/** * Retrieve a user by the given credentials. * * @param array $credentials * * @return \Illuminate\Contracts\Auth\Authenticatable|\LaraParse\Subclasses\User|null * @throws \Exception * @throws \Parse\ParseException */ public function retrieveByCredentials(array $credentials) { $username = $this->getUsernameFromCredentials($credentials); $query = new ParseQuery('_User'); $query->equalTo('username', $username); $user = $query->first(true); return empty($user) ? null : $user; }
/** * 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 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; }
public function getUsers() { $_User = new ParseQuery("_User"); $_User->equalTo("isRemoved", false); $users = $_User->find(); $user_array = array(); foreach ($users as $user) { $user_array[] = array("objectId" => $user->getObjectId(), "firstName" => $user->get("firstName"), "lastName" => $user->get("lastName")); } return $user_array; }
function getBikesWithUser($user) { $query = new ParseQuery("Bikes"); $query->equalTo("currentUser", $user); $results = $query->find(); $listOfBikes = array(); for ($i = 0; $i < count($results); $i++) { array_push($listOfBikes, $results[$i]->getObjectId()); } return $listOfBikes; }
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); }
public function view() { $array = array(); $query = new ParseQuery('_User'); $query->equalTo("isRemoved", false); try { $results["operators"] = $query->find(); return $results; } catch (Exception $ex) { die('<pre>' . print_r(array("Exception" => "Exception", "Message" => $ex->getMessage(), "Code" => $ex->getCode))); } catch (ParseException $px) { die('<pre>' . print_r(array("Exception" => "ParseException", "Message" => $px->getMessage(), "Code" => $px->getCode))); } }
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(); } }
/** * Update the specified resource in storage. * * @param int $id * @return Response */ public function update() { try { ParseClient::initialize(env('PARSE_ID', 'f**k'), env('PARSE_REST', 'f**k'), env('PARSE_MASTER', 'f**k')); $condicoesJSON = Input::get('condicoes'); $condicoes = json_decode($condicoesJSON); $protocoloId = Input::get('id'); $protocoloQuery = new ParseQuery("Protocolo"); $protocolo = $protocoloQuery->get($protocoloId); $condQuery = new ParseQuery("DescritivoMinimo"); $condQuery->equalTo('protocolo', $protocolo); $condicoesFromServer = $condQuery->find(); $condicoesArray = []; for ($serverIndex = 0; $serverIndex < count($condicoesFromServer); $serverIndex++) { $present = false; if (array_key_exists($serverIndex, $condicoesFromServer)) { $keysArray = array_keys($condicoes); for ($localIndex = 0; $localIndex < count($keysArray); $localIndex++) { if (array_key_exists($keysArray[$localIndex], $condicoes)) { if ($condicoes[$keysArray[$localIndex]]->id == $condicoesFromServer[$serverIndex]->getObjectId()) { $present = true; $condicoesFromServer[$serverIndex]->set('ordem', $condicoes[$keysArray[$localIndex]]->ordem); $condicoesFromServer[$serverIndex]->save(); $condicoesArray[$condicoes[$keysArray[$localIndex]]->ordem] = $condicoesFromServer[$serverIndex]->getObjectId(); unset($condicoes[$keysArray[$localIndex]]); } } } if ($present == false) { $condicoesFromServer[$serverIndex]->destroy(); } } } $keysArray = array_keys($condicoes); for ($index = 0; $index < count($keysArray); $index++) { $condicao = new ParseObject("DescritivoMinimo"); $condicao->set('frase', $condicoes[$keysArray[$index]]->frase); $condicao->set('ordem', $condicoes[$keysArray[$index]]->ordem); $condicao->set('protocolo', $protocolo); $condicao->save(); $condicoesArray[$condicoes[$keysArray[$index]]->ordem] = $condicao->getObjectId(); } return json_encode($condicoesArray); } catch (ParseException $error) { dd($error); return $error; } }
function getAllRestaurantsAround($klm) { try { $userPos = new ParseGeoPoint(floatval($this->latitude), floatval($this->longitude)); $query = new ParseQuery("Restaurant"); $query->withinKilometers("coord", $userPos, $klm); $query->equalTo("validated", true); $results = $query->find(); if ($results != null) { return $results; } } catch (ParseException $ex) { echo $ex; } return null; }
public function testAddRestaurant() { $myRest = new Restaurant("23", "12", true, "Rue du test unitaire", "AGILE", "Superbe resto qui s'emmerde a faire des tests unitaire.", "Unit tests", "32456", "http://www.facebook.com"); $objectId = $myRest->add(); $query = new ParseQuery("Restaurant"); $query->equalTo("objectId", $objectId); $results = $query->find(); $this->assertEquals(1, count($results)); $resto = $results[0]; $this->assertEquals("Rue du test unitaire", $resto->get("address")); $this->assertEquals("AGILE", $resto->get("city")); $this->assertEquals("Superbe resto qui s'emmerde a faire des tests unitaire.", $resto->get("description")); $this->assertEquals("Unit tests", $resto->get("name")); $this->assertEquals("32456", $resto->get("postal")); $this->assertEquals("http://www.facebook.com", $resto->get("website")); }
public function delete($obj) { if (empty($obj)) { die("No hay asistentes para borrar."); } $con = new Connect(); $var = $con->connect_to_db(); $query = new ParseQuery("_User"); $query->equalTo("username", $obj["username"]); $results = $query->find(); try { $results[0]->destroy(); echo 'El usuario fue borrado: ' . $results[0]->getObjectId(); } catch (ParseException $ex) { echo 'Fallo al borrar, mensaje de error: ' . $ex->getMessage(); } }
public function testQueryDataUnt() { $department = "ACCT"; $course = "2010"; $section = "001"; $obj = ParseObject::create('TestObject'); $obj->set('department', $department); $obj->set('course', $course); $obj->set('section', $section); $obj->save(); $query = new ParseQuery('TestObject'); $query->startsWith('department', $department); $query->equalTo('course', $course); $query->startsWith('section', $section); $query->limit(1); $response = $query->find(); $this->assertTrue(count($response) == 1); }
function queryDataUnt($department, $course, $section = "001") { $query = new ParseQuery("Book"); $query->startsWith("department", $department); $query->equalTo("course", $course); //$query->startsWith("section", $section); $query->limit(1); try { $result = $query->find(); if (isset($result[0])) { $object = $result[0]; $GLOBALS['isbn'] = $object->get("isbn"); $GLOBALS['name'] = $object->get("name"); $GLOBALS['priceNewUnt'] = $object->get("priceNew"); } } catch (ParseException $ex) { echo "Book not found in database."; } }
public function testGeoLine() { for ($i = 0; $i < 10; ++$i) { $obj = ParseObject::create('TestObject'); $point = new ParseGeoPoint($i * 4.0 - 12.0, $i * 3.2 - 11.0); $obj->set('location', $point); $obj->set('construct', 'line'); $obj->set('seq', $i); $obj->save(); } $query = new ParseQuery('TestObject'); $point = new ParseGeoPoint(24.0, 19.0); $query->equalTo('construct', 'line'); $query->withinMiles('location', $point, 10000); $results = $query->find(); $this->assertEquals(10, count($results)); $this->assertEquals(9, $results[0]->get('seq')); $this->assertEquals(6, $results[3]->get('seq')); }
public function traerCategorias() { //$categorias = new stdClass(); $query = new ParseQuery("noticias"); $query->equalTo("categorias", "noticia"); $categorias[0]['nombre'] = 'noticia'; $categorias[0]['num'] = $query->count(); $query->equalTo("categorias", "intervencion"); $categorias[1]['nombre'] = 'intervenciones'; $categorias[1]['num'] = $query->count(); $query->equalTo("categorias", "video"); $categorias[2]['nombre'] = 'videos'; $categorias[2]['num'] = $query->count(); $query->equalTo("categorias", "iniciativa"); $categorias[3]['nombre'] = 'iniciativas'; $categorias[3]['num'] = $query->count(); $query->equalTo("categorias", "prensa"); $categorias[4]['nombre'] = 'prensa'; $categorias[4]['num'] = $query->count(); $query->equalTo("categorias", "comunicado"); $categorias[5]['nombre'] = 'comunicados'; $categorias[5]['num'] = $query->count(); return $categorias; }