/** * @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++) {