/**
* @param $x [days ago to show]
* @return mixed [associative array with period, labels, data]
*/
function getLastXTraffic($x)
{
//Initialize PArse in PHP
ParseClient::initialize('P60EfTUuOZoeZyD2qSLpOrc8DWwUk2YjEqU2HY1R', 's3b2cfGtQhSFYM16ZIJQ7yXioTjt35Um5mn9SyP8', '3jz6CONqt5psS4UlGu3RB28ldIw311Iv2I8eA3Mh');
$query = new ParseQuery("Reading");
//Parse Object
//filter the result (maximum 31 days)
if ($x < 32) {
$period = date('Y-m-d\\TH:i:s.u\\Z', strtotime("-" . $x . "day"));
//set period in Parse format
} else {
//if else set to one week by default
$period = date('Y-m-d\\TH:i:s.u\\Z', strtotime("-7 day"));
//set period in Parse format
$x = 7;
}
$results = array();
$query->greaterThan("createdAt", $period);
//Select all the reading done after those date
$results = $query->find();
//Run query
$weeklyTraffic = array();
$currentDay = $results[0]->getCreatedAt()->format('d');
//register the day, will use it as a checker
$weeklyTraffic[$currentDay] = 0;
//Set this day with 0 view already
$labelsString = "";
$data = "";
for ($i = 0; $i < count($results); $i++) {
if ($currentDay == $results[$i]->getCreatedAt()->format('d')) {
//here we have element to store in current array's day
$weeklyTraffic[$results[$i]->getCreatedAt()->format('d') . ""] = $weeklyTraffic[$results[$i]->getCreatedAt()->format('d') . ""] + 1;
} else {
/*
* Prepare strings for x axis in javascript
*/
$labelsString .= "'" . $currentDay . "',";
//made the string ready in json
$data .= "'" . $weeklyTraffic[$currentDay] . "',";
//made the string ready in json
//set new day into the array
$weeklyTraffic[$results[$i]->getCreatedAt()->format('d') . ""] = 1;
$currentDay = $results[$i]->getCreatedAt()->format('d');
//set new currentday with the one actually in use
}
}
//set last results
$labelsString .= "'" . $currentDay . "',";
//made the string ready in json with the last element
$data .= "'" . $weeklyTraffic[$currentDay] . "',";
//made the string ready in json with the last element
// Set the array in order to return it
$vars['period'] = $x;
$vars['labels'] = $labelsString;
$vars['data'] = $data;
return $vars;
}
$LastSyncTime = 0;
if ($LastSyncTime == 0) {
$query = new ParseQuery("PRIVILEGE");
$query->equalTo("DEL", 0);
$query->descending("POST_TS");
try {
$result = $query->find();
// The object was retrieved successfully.
} catch (ParseException $ex) {
// The object was not retrieved successfully.
// error is a ParseException with an error code and message.
}
} elseif ($LastSyncTime > 0) {
$query = new ParseQuery("PRIVILEGE");
$query->equalTo("DEL", 0);
$query->greaterThan($LastSyncTime);
$query->descending("POST_TS");
try {
$result = $query->find();
// The object was retrieved successfully.
} catch (ParseException $ex) {
// The object was not retrieved successfully.
// error is a ParseException with an error code and message.
}
}
if (count($result) > 0) {
if (count($result) > 0) {
$toSend = array();
for ($c = 0; $c < count($result); $c++) {
//$toSend[$c] = json_decode($result[$c]->get("data"), true);
$toSend[$c]["POST_TS"] = $result[$c]->get("POST_TS") ? $result[$c]->get("POST_TS") : 0;
public function testOrQueries()
{
$this->provideTestObjects(10);
$subQuery1 = new ParseQuery("TestObject");
$subQuery1->lessThan("foo", "bar2");
$subQuery2 = new ParseQuery("TestObject");
$subQuery2->greaterThan("foo", "bar5");
$mainQuery = ParseQuery::orQueries([$subQuery1, $subQuery2]);
$results = $mainQuery->find();
$length = count($results);
$this->assertEquals(6, $length, 'Did not return correct number of objects.');
for ($i = 0; $i < $length; $i++) {
$this->assertTrue($results[$i]->get("foo") < "bar2" || $results[$i]->get("foo") > "bar5", 'Did not return the correct object.');
}
}
public function testOrQueries()
{
$this->provideTestObjects(10);
$subQuery1 = new ParseQuery('TestObject');
$subQuery1->lessThan('foo', 'bar2');
$subQuery2 = new ParseQuery('TestObject');
$subQuery2->greaterThan('foo', 'bar5');
$mainQuery = ParseQuery::orQueries([$subQuery1, $subQuery2]);
$results = $mainQuery->find();
$length = count($results);
$this->assertEquals(6, $length, 'Did not return correct number of objects.');
for ($i = 0; $i < $length; ++$i) {
$this->assertTrue($results[$i]->get('foo') < 'bar2' || $results[$i]->get('foo') > 'bar5', 'Did not return the correct object.');
}
}
$result = $queryAdd->find();
// The object was retrieved successfully.
} catch (ParseException $ex) {
// The object was not retrieved successfully.
// error is a ParseException with an error code and message.
}
//////////////////////////////////////////////////////////////////////
//do this if app wasn't runing first time COMMENT JOE//
} elseif ($LastSyncTime > 0) {
$queryAdd->greaterThan("POST_TS", $LastSyncTime);
$queryAdd->descending("POST_TS");
$queryAdd->equalTo("DEL", 0);
$queryDel->equalTo("DEL", 1);
$queryDel->descending("POST_TS");
//$queryDel->limit(15);
$queryEdit->greaterThan("OLD_POST_TS", 0);
$queryEdit->descending("OLD_POST_TS");
//$queryEdit->limit(15);
try {
$result = $queryAdd->find();
$resultDel = $queryDel->find();
$resultEdit = $queryEdit->find();
// The object was retrieved successfully.
} catch (ParseException $ex) {
// The object was not retrieved successfully.
// error is a ParseException with an error code and message.
}
}
/////////////////////////////////////////////////////////////////////
if (count($result) > 0 || count($resultDel) > 0) {
if (count($result) > 0) {
use Parse\ParseQuery;
/**
* Same code from analytics.php Should need a ajax-Php function in order to call those methods...
* Copied the code for quickness
*/
$x = $_GET['q'];
ParseClient::initialize('P60EfTUuOZoeZyD2qSLpOrc8DWwUk2YjEqU2HY1R', 's3b2cfGtQhSFYM16ZIJQ7yXioTjt35Um5mn9SyP8', '3jz6CONqt5psS4UlGu3RB28ldIw311Iv2I8eA3Mh');
$query = new ParseQuery("Reading");
if ($x < 32) {
$period = date('Y-m-d\\TH:i:s.u\\Z', strtotime("-" . $x . "day"));
} else {
$period = date('Y-m-d\\TH:i:s.u\\Z', strtotime("-7 day"));
$x = 7;
}
$results = array();
$query->greaterThan("createdAt", $period);
$query->limit(10000);
$results = $query->find();
$weeklyTraffic = array();
$currentDay = $results[0]->getCreatedAt()->format('d');
$weeklyTraffic[$currentDay] = 0;
$labelsString = "";
$data = "";
for ($i = 0; $i < count($results); $i++) {
if ($currentDay == $results[$i]->getCreatedAt()->format('d')) {
$weeklyTraffic[$results[$i]->getCreatedAt()->format('d') . ""] = $weeklyTraffic[$results[$i]->getCreatedAt()->format('d') . ""] + 1;
} else {
/*
* Prepare strings for x axis in javascript
*/
$labelsString .= $currentDay . ',';
if ($_SESSION['notification']) {
$query = new ParseQuery("ChatLogs");
$query->greaterThan('createdAt', date_format($new[0]->getCreatedAt(), 'Y-m-d\\TH:i:s.u\\Z'));
$inbox = count($query->find());
$query = new ParseQuery("NiceThing");
$query->greaterThan('createdAt', $new[0]->getCreatedAt());
$query->equalTo("refered_user", $user);
$new = count($query->find());
$_SESSION['notification'] = false;
} else {
$query = new ParseQuery("ChatLogs");
$query->equalTo('reciever', $user->getObjectId());
$query->greaterThan('createdAt', $_SESSION['last_date']);
$inbox = count($query->find());
$query = new ParseQuery("NiceThing");
$query->greaterThan('createdAt', $_SESSION['last_date']);
$query->equalTo("refered_user", $user);
$new = count($query->find());
}
$query = new ParseQuery("NiceThing");
$query->equalTo("User", $user);
$favorite = $query->find();
$sum_fav = 0;
foreach ($favorite as $fav) {
$sum_fav += count($fav->get('likes'));
}
echo $template->render(array('title' => 'Dashboard', 'user' => $user, 'nav' => 1, 'nicethings' => $nicethings, 'last3' => $lastthreethings, 'originated' => $originated, 'inbox' => $inbox, 'new' => $new, 'favorite' => $sum_fav));
}
}
}
}
private function results()
{
global $wp_query, $post, $wtd_plugin, $wtd_connector;
$res_id = get_post_meta($post->ID, 'res_id', true);
$query = new ParseQuery("resort");
try {
$resort = $query->get($res_id);
// The object was retrieved successfully.
} catch (ParseException $ex) {
error_log($ex->getMessage());
}
$cat_id = get_query_var('wtds');
if (empty($cat_id) && isset($_GET['wtds'])) {
$cat_id = $_GET['wtds'];
}
// get parent category
$query = new ParseQuery('resortParentCategories');
$query->equalTo('cat_class', 'D');
$query->equalTo('resortObjectId', $resort);
$parent_cat = $query->find();
$parent_cat = $parent_cat[0];
// get category if its set
if (!empty($cat_id)) {
$query = new ParseQuery('resortCategory');
try {
$cat = $query->get($cat_id);
} catch (\Parse\ParseException $ex) {
var_dump($ex);
}
}
// parent restriction query
$parent_cat_query = new ParseQuery('resortParentCategories');
$parent_cat_query->equalTo('objectId', $parent_cat->getObjectId());
// subcategory query
$query = new ParseQuery('resortCategory');
$query->matchesQuery('parentResCatObjectId', $parent_cat_query);
$query->greaterThan('diningCnt', 0);
$query->ascending('name');
$categories = $query->find();
?>
<link rel="stylesheet" href="<?php
echo WTD_PLUGIN_URL . 'assets/css/wtd_activities_page.css?wtd_version=' . WTD_VERSION;
?>
" media="screen"/>
<div ng-app="diningApp" ng-controller="diningCtrl">
<div layout="row" layout-sm="column" layout-padding><?php
if ($wtd_plugin['dining_page_type'] == 3) {
?>
<ul layout="column"><?php
for ($i = 0; $i < count($categories); $i++) {
$category = $categories[$i];
$category_url_name = strtolower($parent_cat->get('name'));
$category_url_name = str_replace(' ', '-', $category_url_name);
$category_url_name = str_replace('/', '-', $category_url_name);
$subcategory_url_name = strtolower($category->get('name'));
$subcategory_url_name = str_replace(' ', '-', $subcategory_url_name);
$subcategory_url_name = str_replace(',', '', $subcategory_url_name);
$subcategory_url_name = str_replace('/', '-', $subcategory_url_name);
$url = site_url() . '/' . $post->post_name . '/whattodo/' . $category_url_name . '/' . $parent_cat->getObjectId() . '/' . $subcategory_url_name . '/' . $category->getObjectId() . '/';
?>
<li class="wtd_subcategory_menu_item <?php
echo $category->getObjectId() == $wp_query->query['wtds'] ? 'active' : '';
?>
">
<a href="<?php
echo $url;
?>
"><?php
echo $category->get('name');
?>
</a>
</li><?php
}
?>
</ul><?php
}
if ($wtd_plugin['dining_page_type'] == 2) {
$column_size = 100;
} else {
$column_size = 75;
}
?>
<div layout="row" layout-align="center start" ng-hide="progress == false" layout-padding flex="100">
<md-progress-circular class="md-primary" md-mode="indeterminate"></md-progress-circular>
</div>
<div layout="column" flex="<?php
echo $column_size;
?>
" flex-sm="100" ng-hide="progress == true">
<div layout="row" style="margin-bottom: 5px;">
<a id="parent_<?php
echo $post->ID;
?>
_header" href="<?php
echo get_post_permalink($post->ID);
?>
" class="wtd_pull_left"><?php
echo $post->post_title;
?>
</a><?php
if (!empty($parent_cat_id)) {
$category_url_name = strtolower($parent_cat->get('name'));
$category_url_name = str_replace(' ', '-', $category_url_name);
$url = site_url() . '/' . $wtd_plugin['url_prefix'] . '/' . $post->post_name . '/whattodo/' . $category_url_name . '/' . $parent_cat->getObjectId() . '/';
?>
<span class="wtd_bread_separator">></span>
<a id="parent_<?php
echo $parent_cat->getObjectId();
?>
_header" class="wtd_pull_left" href="<?php
echo $url;
?>
"><?php
echo $parent_cat->get('name');
?>
</a><?php
}
if ($wtd_plugin['dining_page_type'] == 2) {
?>
<span class="wtd_bread_separator">></span>
<select class="wtd_subcategory_navigator">
<option>Select Subcategory</option><?php
for ($i = 0; $i < count($categories); $i++) {
$category = $categories[$i];
$category_url_name = strtolower($parent_cat->get('name'));
$category_url_name = str_replace(' ', '-', $category_url_name);
$category_url_name = str_replace('/', '-', $category_url_name);
$subcategory_url_name = strtolower($category->get('name'));
$subcategory_url_name = str_replace(' ', '-', $subcategory_url_name);
$subcategory_url_name = str_replace(',', '', $subcategory_url_name);
$subcategory_url_name = str_replace('/', '-', $subcategory_url_name);
$url = site_url() . '/' . $post->post_name . '/whattodo/' . $category_url_name . '/' . $parent_cat->getObjectId() . '/' . $subcategory_url_name . '/' . $category->getObjectId() . '/';
$selected = '';
if ($cat_id == $category->getObjectId()) {
$selected = ' selected="selected"';
}
echo '<option value="' . $url . '" ' . $selected . '>' . $category->get('name') . '</option>';
}
?>
</select><?php
} elseif (!empty($cat_id)) {
?>
<span class="wtd_bread_separator">></span>
<span class="wtd_current_cat"><?php
echo $cat->name;
?>
</span><?php
}
?>
</div>
<script>
jQuery('.wtd_subcategory_navigator').change(function(){
var val = jQuery('.wtd_subcategory_navigator option:selected').val();
if(val)
window.location = val;
});
</script>
<div layout="row" layout-align="center center" ng-hide="progress == false" layout-padding>
<md-progress-circular class="md-primary" md-mode="indeterminate"></md-progress-circular>
</div>
<div id="wtd_listing_sc_container" layout="column" layout-align="start start"></div>
</div>
</div>
</div><?php
$wtd_base_request = $wtd_connector->get_base_request();
$wtd_base_request['resorts'] = array($res_id);
$wtd_base_request['page'] = 1;
$subcat_id = "";
if (!empty($cat)) {
$subcat_id = $cat->getObjectId();
}
if (!empty($subcat_id)) {
$wtd_base_request['category_id'] = $subcat_id;
}
?>
<script src="//www.parsecdn.com/js/parse-1.3.5.min.js"></script>
<script src="<?php
echo WTD_PLUGIN_URL;
?>
/assets/js/parse_init.js"></script>
<script>
var wtd_categories = <?php
echo json_encode($this->wtd_categories);
?>
;
var wtd_base_request = <?php
echo json_encode($wtd_base_request);
?>
;
var cat_id = '<?php
echo $cat_id;
?>
';
var subcat_id = '<?php
echo $subcat_id;
?>
';
var wtd_parse_page = 1;
var cur_category = '<?php
echo $cat_id;
?>
';
</script>
<script src="<?php
echo WTD_PLUGIN_URL;
?>
/assets/js/pages/dining.js"></script><?php
wtd_copyright();
}
<link rel="stylesheet" type="text/css" href="css/bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="css/iftaCss.css">
<?php
require './vendor/autoload.php';
require './dataTableInfo.php';
use Parse\ParseClient;
use Parse\ParseQuery;
ParseClient::initialize('wbBrSDOUcBhQnbIwxrHDwpXTOu2YXzROiSynhtmH', 'cBgdYmWxTiK3rUTChtDVhYEyBuvRT8WlUAtxK4Cj', 'fi2UFS8TwmEzx4oKtsrv567TG4nuZV94GSj2ruYF');
?>
</head>
<body>
<div class="container">
<table class="table table-hover">
<?php
$orderQuery = new ParseQuery($TABLE_ORDER);
$orderQuery->greaterThan($ORDER_ID, 1);
$result = $orderQuery->find();
$count = 1;
foreach ($result as $r) {
echo '<tr><td>' . $count++ . '</td><td>';
echo 'Order Id :' . $r->get($ORDER_ID) . '<br>';
echo 'Product Name :' . $r->get($PRODUCT) . '<br>';
echo 'Quantity :' . $r->get($QUANTITY) . '<br>';
echo 'Customer :' . $r->get($CUSTOMER) . '<br>';
echo 'Customer Address :' . $r->get($CUSTOMER_ADDRESS) . '<br>';
echo 'Market Name :' . $r->get($MARKET_NAME) . '<br>';
echo 'Delevary Date :' . $r->get($DELIVARY_DATE) . '<br>';
echo '</td></tr>';
}
?>
</table>
$queryAdd = new ParseQuery("NEWS");
//do this if app was runing first time COMMENT JOE//
if ($LastSyncTime == 0) {
$queryAdd->equalTo("DEL", 0);
$queryAdd->descending("POST_TS");
try {
$result = $queryAdd->find();
// The object was retrieved successfully.
} catch (ParseException $ex) {
// The object was not retrieved successfully.
// error is a ParseException with an error code and message.
}
//////////////////////////////////////////////////////////////////////
//do this if app wasn't runing first time COMMENT JOE//
} elseif ($LastSyncTime > 0) {
$queryAdd->greaterThan("POST_TS", $LastSyncTime);
$queryAdd->descending("POST_TS");
$queryAdd->equalTo("DEL", 0);
try {
$result = $queryAdd->find();
// The object was retrieved successfully.
} catch (ParseException $ex) {
// The object was not retrieved successfully.
// error is a ParseException with an error code and message.
}
}
/////////////////////////////////////////////////////////////////////
if (count($result) > 0 || count($resultDel) > 0) {
if (count($result) > 0) {
$toSend = array();
for ($c = 0; $c < count($result); $c++) {
