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 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 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;
}
/**
* 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));
}
/**
* Alias for ParseQuery's includeKey.
*
* @param string|array $keys
*
* @return $this
*/
public function with($keys)
{
if (is_string($keys)) {
$keys = func_get_args();
}
$this->includeKeys = array_merge($this->includeKeys, $keys);
$this->parseQuery->includeKey($keys);
return $this;
}
public function getAllRatings()
{
try {
$_rate = new ParseQuery("OperatorRatings");
$rate = $_rate->includeKey("user")->includeKey("operator")->find();
return $rate;
} catch (ParseException $px) {
$array_px = array("Message" => $px->getMessage(), "Code" => $px->getCode());
die('<pre>' . print_r($array_px, true));
// return $array_px;
}
}
public function showChat($roomId, Request $request)
{
$current_user = ParseUser::getCurrentUser();
if (!$current_user) {
return redirect()->route('login');
}
Html\Assets::addLink(Html\Link::Css(elixir('css/default.css')));
Html\Assets::addLink(Html\Link::Script(elixir('scripts/chat.js')));
Html\Assets::addLink(Html\Link::Script('//www.parsecdn.com/js/parse-1.6.7.min.js'));
Html\Assets::addMetaTag(Html\Meta::Tag('description', ''));
$query = new ParseQuery("ChatRoom");
$query->includeKey('event');
try {
$chatObj = $query->get($roomId);
// get events
$relation = $chatObj->getRelation("messages");
$query = $relation->getQuery();
$query->includeKey('user');
$query->addAscending('createdAt');
$messages = $query->find();
$msArr = [];
foreach ($messages as $messageObj) {
$relation = $messageObj->getRelation('asset');
$qry = $relation->getQuery();
$assets = $qry->find();
$msArr[] = ['message' => $messageObj, 'assets' => $assets];
}
$renderData = $this->getRenderData($request);
if (count($messages) > 0) {
$last_message = $messages[count($messages) - 1];
$renderData['last_timer'] = $last_message->getCreatedAt()->getTimestamp();
$renderData['lastMsgId'] = !empty($messages[count($messages) - 1]->getObjectId()) ? $messages[count($messages) - 1]->getObjectId() : 0;
} else {
$renderData['last_timer'] = 0;
$renderData['lastMsgId'] = 0;
}
$renderData['user'] = $current_user;
$renderData['chatObj'] = $chatObj;
$renderData['messages'] = $msArr;
$renderData['navTitle'] = $chatObj->get('event')->get('name');
$renderData['user'] = $current_user;
$renderData['uId'] = $current_user->getObjectId();
return view('chat', $renderData);
} catch (ParseException $ex) {
// The object was not retrieved successfully.
// error is a ParseException with an error code and message.
echo $ex->getMessage();
}
}
public function toExcel()
{
$con = new Connect();
$var = $con->connect_to_db();
//iniciamos una consulta para recibir todos los usuarios ausentes de la sede del mentor logueado
$query = new ParseQuery("Asistencia");
$query->limit(1000);
$query->includeKey('Usuario_FK');
$results = $query->find();
$listado = array();
for ($i = 0; $i < count($results); $i++) {
$object = $results[$i];
$usuario = $object->get('Usuario_FK');
$sede = $object->get('Sede');
$persona = array('Nombre' => $usuario->get("Nombre"), "Apellido" => $usuario->get("Apellido"), "Presente" => $object->get("Presente"));
array_push($listado, $persona);
}
//"Fecha" => $object->get("fecha"),
//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;
$filename = "asistencia.csv";
$delimiter = ";";
header('Content-Type: application/csv');
header('Content-Disposition: attachment; filename="' . $filename . '";');
// open the "output" stream
// see http://www.php.net/manual/en/wrappers.php.php#refsect2-wrappers.php-unknown-unknown-unknown-descriptioq
$f = fopen('php://output', 'w');
foreach ($listado as $line) {
fputcsv($f, $line, $delimiter);
}
}
public function testRelationalFields()
{
Helper::clearClass('Item');
Helper::clearClass('Container');
$item = ParseObject::create('Item');
$item->set('property', 'x');
$item->save();
$container = ParseObject::create('Container');
$container->set('item', $item);
$container->save();
$query = new ParseQuery('Container');
$query->includeKey('item');
$containerAgain = $query->get($container->getObjectId());
$itemAgain = $containerAgain->get('item');
$this->assertEquals('x', $itemAgain->get('property'));
$query->equalTo('item', $item);
$results = $query->find();
$this->assertEquals(1, count($results));
}
public function joinEvent(Request $request)
{
$current_user = ParseUser::getCurrentUser();
Html\Assets::addLink(Html\Link::Css(elixir('css/default.css')));
Html\Assets::addMetaTag(Html\Meta::Tag('description', ''));
$renderData = $this->getRenderData($request);
if ($request->method() == "POST" || $request->session()->get('lastAction') == 'joinevent') {
if (!empty($current_user)) {
$code = $request->input('eventCode') ?: $request->session()->get('joinevent:inviteCode');
$query = new ParseQuery("Events");
try {
$query->equalTo('inviteCode', $code);
$query->includeKey('chatRoom');
$eventObj = $query->find();
if (count($eventObj) > 0) {
$eventObj = $eventObj[0];
$relation = $eventObj->getRelation('members');
$relation->add($current_user);
$eventObj->save();
//add member to chatroom
$chatObj = $eventObj->get('chatRoom');
$relation = $chatObj->getRelation('members');
$relation->add($current_user);
$chatObj->save();
//clear last action
$request->session()->set('lastAction', '');
//redirect to chatroom
return redirect()->route('chat', ['roomId' => $chatObj->getObjectId()]);
} else {
$renderData['errorMsg'] = "Sorry invite code '{$code}' is not valid.'";
}
} catch (ParseException $ex) {
// The object was not retrieved successfully.
// error is a ParseException with an error code and message.
echo $ex->getMessage();
}
} else {
$request->session()->set('lastAction', 'joinevent');
$request->session()->set('joinevent:inviteCode', $request->input('inviteCode'));
return redirect()->route('register');
}
}
$renderData['navTitle'] = "Join Event";
return view('joinevent', $renderData);
}
<?php
/**
* Created by PhpStorm.
* User: jokamjohn
* Date: 1/13/2016
* Time: 10:09 PM
*/
use app\Constant;
use Parse\ParseQuery;
require 'vendor/autoload.php';
if (isset($_GET['id'])) {
$id = $_GET['id'];
$query = new ParseQuery(Constant::$CLIENT_CONTACT_INFO_CLASS_NAME);
$query->equalTo(Constant::$KEY_OBJECT_ID, $id);
$query->includeKey(Constant::$KEY_HEALTH_CHECK_INFORMATION);
$query->includeKey(Constant::$KEY_HEALTH_YES_NO);
$query->includeKey(Constant::$KEY_HEALTH_STRUCTURED);
$details = $query->find();
makeView("person", compact("details"));
}
//for ($i = 0; $i < count($details); $i++) {
// // This does not require a network access.
// $record = $details[$i]->get(Constant::$KEY_HEALTH_CHECK_INFORMATION);
// if($record != null){
// var_dump($record->get("HasDiseases"));
// }
//}
function user_register_report($first, $last, $pass, $email, $report_id)
{
$response = new Response();
$name = $first . "_" . $last;
$user = new ParseUser();
$user->set("username", strtolower($name));
$user->set("email", $email);
$user->set("password", $pass);
try {
$user->signUp();
$_SESSION['user'] = $user;
$_SESSION['notification'] = true;
$query = new ParseQuery("_Session");
$query->equalTo("user", $user);
$query->includeKey("user");
$query->descending("createdAt");
$query->limit(1);
$new = $query->find(true);
$_SESSION['last_date'] = date_format($new[0]->getCreatedAt(), 'Y-m-d\\TH:i:s.u\\Z');
echo add_user_report($report_id, $user);
} catch (ParseException $ex) {
$response->success = false;
$response->message = 'Error: Failed to register: ' . $error;
echo json_encode($response);
}
}
function wtd_bus_options($field, $value)
{
$place = 'business_categories_options';
$parent_filters = get_option('wtd_excluded_parent_cats');
if (!empty($parent_filters)) {
$enabled_parent_cat_filters = json_decode($parent_filters);
}
$excluded_cats = get_option('wtd_excluded_cats');
?>
<div ng-controller="categoryExclusion"><?php
$query = new ParseQuery('wp_site');
$query->equalTo('token', get_option('wtd_api_token'));
$site_results = $query->find();
$site = $site_results[0];
$relation = $site->getRelation('resortRelation', 'resort');
$resorts = $relation->getQuery()->find();
$query = new ParseQuery('resortParentCategories');
$query->equalTo('deleted', false);
$query->containedIn('resortObjectId', $resorts);
$query->includeKey('resortObjectId');
$results = $query->find();
?>
<script type="text/javascript"><?php
if (empty($enabled_parent_cat_filters)) {
?>
var enabled_parent_filters = null;
var excluded_cats = null;<?php
} else {
?>
var enabled_parent_filters = JSON.parse('<?php
echo empty($parent_filters) ? '{"result":true}' : $parent_filters;
?>
');<?php
if (empty($excluded_cats)) {
?>
var excluded_cats = null;<?php
} else {
?>
var excluded_cats = JSON.parse('<?php
echo $excluded_cats;
?>
');<?php
}
}
?>
jQuery(document).ready(function(){
if(enabled_parent_filters!= null && enabled_parent_filters!= undefined ){
for(var i = 0; i < enabled_parent_filters.length; i++){
var parent_id = enabled_parent_filters[i];
Parse.Cloud.run('get_subcategory_list_v2', {
parent_id: parent_id,
token: token
}, {
success: function(result){
showSubcategoryList(parent_id, result);
},
error: function(error){
console.log(error);
}
});
}
}
});
</script>
<div data-place="<?php
echo $place;
?>
"><?php
for ($i = 0; $i < count($results); $i++) {
$cat = $results[$i];
$cat_id = $cat->getObjectId();
$cat_enable = '';
$cat_disable = 'selected';
if (!empty($enabled_parent_cat_filters)) {
if (in_array($cat->getObjectId(), $enabled_parent_cat_filters)) {
$cat_enable = 'selected';
$cat_disable = '';
}
}
?>
<div id="<?php
echo $place;
?>
_parent_<?php
echo $cat_id;
?>
">
<fieldset class="redux-field-container redux-field redux-container-switch" data-id="category-<?php
echo $cat->getObjectId();
?>
" data-type="switch">
<div class="switch-options">
<label id="<?php
echo $cat_id;
?>
_filter_enabled" class="cb-enable <?php
echo $cat_enable;
?>
" ng-click="getSubcategories('<?php
echo $cat->getObjectId();
?>
');" data-val="1">
<span>Enable</span>
</label>
<label id="<?php
echo $cat_id;
?>
_filter_disabled" class="cb-disable <?php
echo $cat_disable;
?>
" onclick="disableParentCategoryFilter('<?php
echo $cat->getObjectId();
?>
', this);" data-place="<?php
echo $place;
?>
" data-term="<?php
$cat_id;
?>
" data-val="0">
<span>Disable</span>
</label>
</div>
</fieldset>
<span style="font-weight:bold;"><em><?php
echo $cat->resortObjectId->name . ' - ' . $cat->get('name');
?>
</em> Category Filter</span>
<div id="<?php
echo $cat->getObjectId();
?>
_children" layout="row" layout-wrap><?php
if (!empty($enabled_parent_cat_filters)) {
if (in_array($cat->getObjectId(), $enabled_parent_cat_filters)) {
try {
$subcategories = ParseCloud::run("get_subcategory_list_v2", ['parent_id' => $cat_id, 'token' => get_option('wtd_api_token')]);
} catch (ParseException $ex) {
var_dump($cat_id);
var_dump($ex);
}
$subcategories = json_decode($subcategories);
for ($j = 0; $j < count($subcategories); $j++) {
$sub_cat = $subcategories[$j];
$selected = '';
if (!empty($excluded_cats)) {
if (in_array($sub_cat->objectId, json_decode($excluded_cats))) {
$selected = ' checked ';
}
}
echo '<div flex="33"><input type="checkbox" name="excluded_cats[]" id="excluded_cats[]" onchange="saveExcludedCats();" value="' . $sub_cat->objectId . '" ' . $selected . ' />' . $sub_cat->name . '</div>';
}
}
}
?>
</div>
<hr/>
</div><?php
}
?>
</div>
</div><?php
}
public function getComments()
{
$query = new ParseQuery("Messages");
$query->equalTo("animal_Id", $this);
$query->includeKey("id_user");
$comments = $query->find();
$this->_comments = [];
foreach ($comments as $comment) {
$user = $comment->get('id_user');
$data = ["user_photo" => '', "user_name" => $user->get('name') . " " . $user->get('lastname'), "message" => $comment->get("message"), "likes" => count($comment->get("likesRelation"))];
if ($user->get('photoFile') != null) {
$data["user_photo"] = $user->get('photoFile')->getURL();
} else {
if ($user->get('photo') != null) {
$data['user_photo'] = $user->get('photo');
} else {
$data['user_photo'] = 'http://files.parsetfss.com/a82729a1-e6e9-43f0-acae-a060f3153c6d/tfss-3d88ecd0-d988-4ab3-a297-cf44a2682864-perfil3.jpg';
}
}
array_push($this->_comments, $data);
}
return $this->_comments;
}
public function testIncludeMultipleKeys()
{
Helper::clearClass("Foo");
Helper::clearClass("Bar");
Helper::clearClass("Parent");
$foo = ParseObject::create('Foo');
$foo->set('rev', 'oof');
$foo->save();
$bar = ParseObject::create('Bar');
$bar->set('rev', 'rab');
$bar->save();
$parent = ParseObject::create('Parent');
$parent->set('foofoo', $foo);
$parent->set('barbar', $bar);
$parent->save();
$query = new ParseQuery('Parent');
$query->includeKey(['foofoo', 'barbar']);
$result = $query->first();
$this->assertEquals('oof', $result->get('foofoo')->get('rev'), 'Object should be fetched');
$this->assertEquals('rab', $result->get('barbar')->get('rev'), 'Object should be fetched');
}
public function testRelationalFields()
{
Helper::clearClass("Item");
Helper::clearClass("Container");
$item = ParseObject::create("Item");
$item->set("property", "x");
$item->save();
$container = ParseObject::create("Container");
$container->set("item", $item);
$container->save();
$query = new ParseQuery("Container");
$query->includeKey("item");
$containerAgain = $query->get($container->getObjectId());
$itemAgain = $containerAgain->get("item");
$this->assertEquals("x", $itemAgain->get("property"));
$query->equalTo("item", $item);
$results = $query->find();
$this->assertEquals(1, count($results));
}
echo $template->render(array('title' => 'Report Nice Thing', 'users' => $users, 'not' => 1));
} else {
if (isset($_GET['success'])) {
$template = $twig->loadTemplate('success.html');
$query = new ParseQuery("NiceThing");
$query->limit(1000);
$nice_things = $query->find();
echo $template->render(array('title' => 'Explore', 'nicethings' => $nice_things));
} else {
if (isset($_POST['viewThings'])) {
$query = new ParseQuery("_User");
$query->equalTo('objectId', $_POST['viewThings']);
$userThings = $query->first();
$query = new ParseQuery("NiceThing");
$query->equalTo("User", $userThings);
$query->includeKey("refered_user");
$query->includeKey("User");
$query->limit(1000);
$nicethings = $query->find();
$events = array();
foreach ($nicethings as $nicething) {
$e = new Event();
$e->id = $nicething->getObjectId();
$e->user = $nicething->get('User')->getObjectId();
$e->name = $nicething->get('refered_user')->get('first');
$e->date = $nicething->get('date');
$e->feel = $nicething->get('feel');
$e->location_name = $nicething->get('location_name');
$e->message = $nicething->get('message');
$e->nice_thing = $nicething->get('nice_thing');
$e->privacy = $nicething->get('privacy');
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();
}
for ($i = 0; $i < count($userArray); $i++) {
$arr = $userArray[$i]->get('users');
$ustr = $user->getObjectId() . $_POST['user'];
$ustr1 = $_POST['user'] . $user->getObjectId();
if (gettype(strpos(implode("", $arr), $ustr)) == "integer" || gettype(strpos(implode("", $arr), $ustr1)) == "integer") {
$chatId = $userArray[$i]->getObjectId();
}
}
$query = new ParseQuery("Chat");
$query->equalTo('objectId', $chatId);
$chat = $query->first();
if ($chat) {
$response = new Response();
$query = new ParseQuery("ChatLogs");
$query->equalTo('Chat', $chat);
$query->includeKey('speaker');
$query->ascending('createdAt');
$chatters = $query->find();
$msgArray = array();
$spkArray = array();
$dateArray = array();
$imgArray = array();
for ($i = 0; $i < count($chatters); $i++) {
array_push($msgArray, $chatters[$i]->get('message'));
array_push($spkArray, $chatters[$i]->get('speaker')->get('first'));
array_push($imgArray, $chatters[$i]->get('speaker')->get('avatar'));
array_push($dateArray, date_format($chatters[$i]->getCreatedAt(), 'F jS \\a\\t g:ia'));
}
$response->success = true;
$response->type = 1;
$response->data = $msgArray;
public function testIncludedObjectsGetACLWithDefaultACL()
{
Helper::clearClass("Test");
Helper::clearClass("Related");
$defaultACL = new ParseACL();
$defaultACL->setPublicReadAccess(true);
$defaultACL->setPublicWriteAccess(true);
ParseACL::setDefaultACL($defaultACL, true);
$object = ParseObject::create('Test');
$acl = new ParseACL();
$acl->setPublicReadAccess(true);
$object->setACL($acl);
$object->save();
$this->assertTrue($object->getACL()->getPublicReadAccess());
$related = ParseObject::create('Related');
$related->set('test', $object);
$related->save();
$query = new ParseQuery('Related');
$query->includeKey('test');
$objectAgain = $query->first()->get('test');
$this->assertTrue($objectAgain->getACL()->getPublicReadAccess());
$this->assertFalse($objectAgain->getACL()->getPublicWriteAccess());
}
public function showNotifications(Request $request)
{
$current_user = ParseUser::getCurrentUser();
$query = new ParseQuery("Notifications");
$query->equalTo("for", $current_user);
$query->equalTo("read", false);
$query->includeKey('by');
$query->includeKey('message');
$query->addDescending('createdAt');
try {
$notifications = $query->find();
Html\Assets::addLink(Html\Link::Css(elixir('css/default.css')));
$renderData = $this->getRenderData($request);
$notes = array();
foreach ($notifications as $notify) {
if (!empty($notify->get('message'))) {
$byimage = $notify->get('by')->get('image');
$chatroom = $notify->get('message')->get('chatRoom');
$relation = $notify->get('message')->getRelation('asset');
$assets = $relation->getQuery()->find();
if (empty($chatroom)) {
continue;
}
$chatroom->fetch();
$notes[] = ['notification' => $notify, 'byimage' => $byimage, 'chatRoom' => $chatroom, 'assets' => $assets];
}
$notify->set("read", true);
$notify->save();
}
$renderData['user'] = $current_user;
$renderData['notifications'] = $notes;
return view('notification', $renderData);
} catch (\Exception $ex) {
echo $ex->getMessage();
die;
}
}
$func = $_POST['check'];
if ($func == 'guest') {
(string) ($uniq = uniqid());
$name = "Guest-" . $uniq;
$user = new ParseUser();
$user->set("username", $name);
$user->set("password", $uniq);
$user->setArray("connected", []);
$user->set("status", 0);
try {
$user->signUp();
$_SESSION['user'] = $user;
$_SESSION['notification'] = true;
$query = new ParseQuery("_Session");
$query->equalTo("user", $user);
$query->includeKey("user");
$query->descending("createdAt");
$query->limit(1);
$new = $query->find(true);
$_SESSION['last_date'] = date_format($new[0]->getCreatedAt(), 'Y-m-d\\TH:i:s.u\\Z');
add_user_report($_SESSION['id'], $user);
} catch (ParseException $ex) {
echo $ex;
}
}
if ($func == 'login') {
echo user_login_report($_POST['username'], $_POST['password'], $_SESSION['id']);
}
if ($func == 'register') {
echo user_register_report($_POST['first'], $_POST['last'], $_POST['password'], $_POST['email'], $_SESSION['id']);
}
function getOpenBikesWithinDistance($latitude, $longitude, $radius)
{
$point = new ParseGeoPoint($latitude, $longitude);
$query = new ParseQuery("Bikes");
$query->includeKey("currentUser");
$query->doesNotExist("currentUser");
$query->withinMiles("lastLocation", $point, $radius);
$query->limit(1000);
$results = $query->find();
$count = count($results);
$listOfBikes = array();
for ($i = 0; $i < $count; $i++) {
$bike = $results[$i];
$ID = $bike->getObjectId();
$point = $bike->get("lastLocation");
$lat = $point->getLatitude();
$long = $point->getLongitude();
$object = new stdClass();
$object->bikeID = $ID;
$object->latitude = $lat;
$object->longitude = $long;
array_push($listOfBikes, $object);
}
return $listOfBikes;
}
