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;
}
