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