Ejemplo n.º 1
0
function recalculate($projectId)
{
    $db = OcDb::instance();
    $stmt = $db->multiVariableQuery('SELECT * FROM `caches` where `cache_id` IN (SELECT `cacheId` FROM `powerTrail_caches` WHERE `PowerTrailId` =:1 )', $projectId);
    $allCaches = $db->dbResultFetchAll($stmt);
    $newData = powerTrailBase::recalculateCenterAndPoints($allCaches);
    $db->multiVariableQuery('UPDATE `PowerTrail` SET `cacheCount`= :1, `centerLatitude` = :3, `centerLongitude` = :4, `points` = :5 WHERE `id` = :2', $newData['cacheCount'], $projectId, $newData['avgLat'], $newData['avgLon'], $newData['points']);
}
function recalculate($projectId)
{
    $allCachesQuery = 'SELECT * FROM `caches` where `cache_id` IN (SELECT `cacheId` FROM `powerTrail_caches` WHERE `PowerTrailId` =:1 )';
    $db = \lib\Database\DataBaseSingleton::Instance();
    $db->multiVariableQuery($allCachesQuery, $projectId);
    $allCaches = $db->dbResultFetchAll();
    $newData = powerTrailBase::recalculateCenterAndPoints($allCaches);
    $updateQuery = 'UPDATE `PowerTrail` SET `cacheCount`= :1, `centerLatitude` = :3, `centerLongitude` = :4, `points` = :5 WHERE `id` = :2';
    $db->multiVariableQuery($updateQuery, $newData['cacheCount'], $projectId, $newData['avgLat'], $newData['avgLon'], $newData['points']);
}
Ejemplo n.º 3
0
<?php

use Utils\Database\OcDb;
session_start();
if (!isset($_SESSION['user_id'])) {
    print 'no hacking please!';
    exit;
}
require_once __DIR__ . '/../lib/ClassPathDictionary.php';
$ptAPI = new powerTrailBase();
$db = OcDb::instance();
$projectId = $_REQUEST['projectId'];
$allCachesQuery = 'SELECT * FROM `caches` where `cache_id` IN (SELECT `cacheId` FROM `powerTrail_caches` WHERE `PowerTrailId` =:1 )';
$s = $db->multiVariableQuery($allCachesQuery, $projectId);
$allCaches = $db->dbResultFetchAll($s);
$newData = powerTrailBase::recalculateCenterAndPoints($allCaches);
$query = 'SELECT count( `cacheId` ) AS cacheCount FROM `powerTrail_caches` WHERE `PowerTrailId` =:1';
$s = $db->multiVariableQuery($query, $projectId);
$cacheCountResult = $db->dbResultFetchOneRowOnly($s);
$cacheCountResult = $cacheCountResult['cacheCount'];
$updateQuery = 'UPDATE `PowerTrail` SET `cacheCount`= :1,
    `centerLatitude` = ' . $newData['avgLat'] . ',
    `centerLongitude` = ' . $newData['avgLon'] . ',
    `points` = ' . $newData['points'] . '
     WHERE `id` = :2';
$db->multiVariableQuery($updateQuery, $cacheCountResult, $projectId);
// $result = json_encode($cacheCountResult);
echo $cacheCountResult;