Esempio n. 1
0
 public function actionDelete()
 {
     if (!isset($_POST['imageId'])) {
         App::instance()->show404();
         exit;
     }
     /** @var \models\Image $model */
     $model = Image::findByID((int) $_POST['imageId']);
     if (!$model || $model->uid != App::instance()->getUser()->getId()) {
         App::instance()->show404();
         exit;
     }
     if ($model->delete()) {
         $response['error'] = false;
     } else {
         $response = json_encode(['error' => true]);
     }
     if (isset($_SERVER['HTTP_X_REQUESTED_WITH']) && 'XMLHttpRequest' === $_SERVER['HTTP_X_REQUESTED_WITH']) {
         $response['totalCount'] = Image::countByProp('uid', App::instance()->getUser()->getId());
         echo json_encode($response);
     } else {
         $this->redirect('/site/index/');
         echo $response;
     }
 }
Esempio n. 2
0
 public function actionLogout()
 {
     if (!App::instance()->isGuest()) {
         App::instance()->logoutUser();
     }
     $this->redirect('/site/index/');
 }
 /**
  * Returns the singleton instance of this class.
  *
  * @return DatabaseService
  */
 public static function instance()
 {
     if (!isset(self::$instance)) {
         $db = App::instance()->config['db'];
         self::$instance = new \PDO('mysql:host=' . $db['host'] . ';dbname=' . $db['name'], $db['username'], $db['password'], $db['options']);
     }
     return self::$instance;
 }
Esempio n. 4
0
 /**
  * Constructor
  */
 public function __construct()
 {
     //create new App instance if no one
     $this->_connection = App::instance()->getDb();
     $currencyDbName = Processor::$currencyDbInfo['tableName'];
     $sql = "SELECT id ,pair FROM {$currencyDbName}";
     $stmnt = $this->_connection->query($sql);
     $results = $stmnt->fetchAll(PDO::FETCH_ASSOC);
     foreach ($results as $result) {
         $this->_currencyPairs[$result['pair']] = (int) $result['id'];
     }
 }
Esempio n. 5
0
 /**
  * @param BaseModel $model
  * @param $propName
  */
 public static function isUnique(BaseModel $model, $propName, $scenario = [])
 {
     if (isset($model->{$propName}) && (empty($scenario) || in_array($model->scenario, $scenario))) {
         /** @var PDO $connection */
         $connection = App::instance()->getDB();
         $modelTable = $model::tableName();
         $sql = "SELECT COUNT(id) AS cnt FROM {$modelTable} WHERE {$propName} = :value";
         $stmnt = $connection->prepare($sql);
         $stmnt->execute([':value' => $model->{$propName}]);
         $result = $stmnt->fetch(PDO::FETCH_ASSOC);
         if (false !== $result && 0 == $result['cnt']) {
             return;
         }
         $model->addErrorMsg($propName, 'Already exists.');
     }
 }
Esempio n. 6
0
 /**
  * Constructor
  */
 public function __construct()
 {
     $this->_connection = App::instance()->getDb();
     $tableName = static::$periodsDbInfo['tableName'];
     $sql = "SELECT id, value FROM {$tableName}";
     $stmnt = $this->_connection->query($sql);
     $results = $stmnt->fetchAll(PDO::FETCH_ASSOC);
     foreach ($results as $result) {
         $this->_periods[(int) $result['id']] = (int) $result['value'];
     }
     $currencyDbName = static::$currencyDbInfo['tableName'];
     $sql = "SELECT id ,pair FROM {$currencyDbName}";
     $stmnt = $this->_connection->query($sql);
     $results = $stmnt->fetchAll(PDO::FETCH_ASSOC);
     foreach ($results as $result) {
         $this->_currencyPairs[$result['pair']] = (int) $result['id'];
     }
 }
Esempio n. 7
0
 public function getBtceAvgData($periodId, $dateStart = null, $dateEnd = null)
 {
     $periodId = (int) $periodId;
     if (!in_array($periodId, array_keys($this->_periods))) {
         throw new \Exception('Parameter error. Wrong period ID.');
     }
     $connection = App::instance()->getDb();
     $tableName = Processor::$btceDbInfo['statTableName'];
     $currencytableName = Processor::$currencyDbInfo['tableName'];
     $tsQuery = '';
     $tsQuery .= $dateStart ? ' AND ts >= ' . (int) $dateStart : '';
     $tsQuery .= $dateEnd ? ' AND ts <= ' . (int) $dateEnd : '';
     $sql = "SELECT cp.name AS name, ts, ask, bid, high, low, avg_val, vol, vol_cur FROM {$tableName} AS st\n                LEFT JOIN {$currencytableName} AS cp ON cp.id = st.pair_id\n                WHERE st.period_id = {$periodId} {$tsQuery}";
     $stmnt = $connection->query($sql);
     if (!$stmnt) {
         return [];
     }
     $result = $stmnt->fetchAll(PDO::FETCH_ASSOC);
     return $result;
 }
Esempio n. 8
0
<?php

/**
 * Site index file
 */
namespace web;

use app\App;
include '../app/autoloader.php';
App::instance()->init();
$requestedPath = isset($_GET['requestedPath']) ? $_GET['requestedPath'] : '';
App::instance()->route($requestedPath);
Esempio n. 9
0
 /**
  * @return bool
  */
 public function login()
 {
     $dbUser = User::findByProp('email', $this->email);
     if (isset($dbUser) && $this->generatePasswordHash($this->password) === $dbUser->passwordHash) {
         //change user App for dbUser
         App::instance()->setUser($dbUser);
         return true;
     }
     $this->addErrorMsg('email', 'Unknown email or password. Try again.');
     return false;
 }
Esempio n. 10
0
<?php

/**
 * @var app\View $this
 */
use app\App;
?>
<!DOCTYPE html>
<html>
<head lang="en">
    <meta charset="UTF-8">
    <title><?php 
echo isset($this->title) ? $this->title : App::instance()->appName;
?>
</title>
    <link rel="stylesheet" href="/css/bootstrap.min.css">
    <link rel="stylesheet" href="/css/site.css">
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.0/jquery.min.js"></script>
    <script type="text/javascript" src="/js/bootstrap.min.js"></script>
</head>
<body>
    <div id="content-container">
        <?php 
echo $this->content;
?>
        <div class="clearfix"></div>
    </div>
    <div class="footer">
        <span><?php 
echo date('Y');
?>
Esempio n. 11
0
 /**
  * @return string
  */
 public function getUserImgDirectory()
 {
     $path = str_replace('/', DIRECTORY_SEPARATOR, App::instance()->getWebRootPath() . '/' . $this->getUserImgDirectoryRel());
     if (!file_exists($path)) {
         mkdir($path, 0777, true);
     }
     return $path;
 }
 /**
  * Render "Method Not Allowed" error response.
  *
  * @param $method String - Requested method
  * @param $url String - Requested URI.
  */
 public static function methodNotAllowed($method, $url)
 {
     self::setHeaders(405);
     $errorMessage = ['error' => 'Method Not Allowed', 'message' => 'The requested method ' . $method . ' is not allowed for the URL ' . $url . '.'];
     echo json_encode($errorMessage, App::instance()->config['json_options']);
     exit;
 }
Esempio n. 13
0
<?php

/**
 * @var app\View $this
 * @var models\Image $image
 */
use app\App;
$this->title = "Gallery: Add new image.";
?>
<div class="container col-sm-8 col-sm-offset-2">
    <div id="upload-inner-container">
        <h1><?php 
echo App::instance()->getUser()->name;
?>
's Gallery: add new image.</h1>
        <hr>
        <form action="/site/upload/" method="POST" enctype="multipart/form-data">
            <div class="row">
                <div class="form-group<?php 
echo $image->hasErrors('imageFile') ? ' has-error' : '';
?>
">
                    <label class="control-label" for="image-file">File:</label>
                    <input type="file" class="form-control" name="Image[imageFile]" id="image-file" accept="image/*">
                </div>
        <?php 
if ($image->hasErrors('imageFile')) {
    ?>
        <?php 
    foreach ($image->getErrorMsg('imageFile') as $msg) {
        ?>
Esempio n. 14
0
<?php

$config = (require_once __DIR__ . '/app/config/config.php');
require_once __DIR__ . '/app/services/AutoLoaderService.php';
require_once __DIR__ . '/app/App.php';
use App\App;
$app = App::instance();
$app->run($config);
Esempio n. 15
0
 public static function countByProp($propName, $propVal)
 {
     if (!is_string($propName)) {
         throw new \Exception('PropName type should be string!');
     }
     if (!property_exists(get_called_class(), $propName)) {
         throw new \Exception('Property "' . $propName . '" not found in ' . get_called_class() . '!');
     }
     if (!in_array($propName, static::$dbProperties)) {
         throw new \Exception('Property "' . $propName . '" should be in "static::$dbProperties" array!');
     }
     $tableName = static::tableName();
     $sql = "SELECT COUNT(id) FROM {$tableName}\n                WHERE {$propName} = :{$propName}\n                LIMIT 1";
     $connection = App::instance()->getDB();
     $stmnt = $connection->prepare($sql);
     $stmnt->bindValue(":{$propName}", $propVal);
     $stmnt->setFetchMode(PDO::FETCH_NUM);
     $stmnt->execute();
     $result = $stmnt->fetch();
     if (isset($result[0])) {
         return $result[0];
     }
     return null;
 }