Exemplo n.º 1
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Session::find();
     $query->select('s.name as service,u.name as username,u1.name as mentorname,mbb.user_id,mbb.mentor_id,mbb.service_id,mbb.id,mbb.type,mbb.status,mbb.datetime_from as date, mbb.datetime_from as time,mbb.booking_hrs,mbb.paid_from');
     $query->leftjoin('users as u', 'u.id=mbb.user_id');
     $query->leftJoin('users as u1', 'u1.id=mbb.mentor_id');
     $query->leftjoin('ms_service as s', 's.id=mbb.service_id');
     $query->where('mbb.type = "book" AND mbb.status != "C"');
     $query->orderBy('mbb.id DESC');
     $query->from('mbb as mbb ');
     $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10]]);
     $this->load($params);
     $dataProvider->sort->attributes['username'] = ['asc' => ['u.name' => SORT_ASC], 'desc' => ['u.name' => SORT_DESC]];
     $dataProvider->sort->attributes['service'] = ['asc' => ['s.name' => SORT_ASC], 'desc' => ['s.name' => SORT_DESC]];
     $dataProvider->sort->attributes['mentorname'] = ['asc' => ['u1.name' => SORT_ASC], 'desc' => ['u1.name' => SORT_DESC]];
     $dataProvider->sort->attributes['date'] = ['asc' => ['mbb.datetime_from' => SORT_ASC], 'desc' => ['mbb.datetime_from' => SORT_DESC]];
     $dataProvider->sort->attributes['time'] = ['asc' => ['mbb.datetime_from' => SORT_ASC], 'desc' => ['mbb.datetime_from' => SORT_DESC]];
     if (!$this->validate()) {
         // uncomment the following line if you do not want to any records when validation fails
         // $query->where('0=1');
         return $dataProvider;
     }
     $query->andFilterWhere(['mbb.mentor_id' => $this->mentor_id, 'datetime_from' => $this->datetime_from, 'mbb.service_id' => $this->service_id, 'hourly_fee' => $this->hourly_fee, 'total_fee' => $this->total_fee, 'created_at' => $this->created_at]);
     $query->andFilterWhere(['like', 'mbb.type', $this->type])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'mbb.status', $this->status])->andFilterWhere(['like', 'u.name', $this->username])->andFilterWhere(['like', 'u1.name', $this->mentorname])->andFilterWhere(['like', 's.name', $this->service])->andFilterWhere(['like', 'mbb.datetime_from', $this->date])->andFilterWhere(['like', 'mbb.datetime_from', $this->time])->andFilterWhere(['like', 'mbb.booking_hrs', $this->booking_hrs])->andFilterWhere(['like', 'mbb.paid_from', $this->paid_from]);
     return $dataProvider;
 }
Exemplo n.º 2
0
 public static function logStat()
 {
     if (Yii::$app->user->isGuest && !Yii::$app->session->has('stat')) {
         $model = Session::find()->where(['id' => Yii::$app->session->id])->one();
         if ($model === null) {
             $model = new Session();
             $model->id = Yii::$app->session->id;
             $model->ip = Yii::$app->request->userIP;
             $model->user_agent = Yii::$app->request->userAgent;
             $model->created = $model->modified = time();
             $model->save();
         }
         Session::updateAll(['status' => 0], 'modified < :time', [':time' => time() - 15 * 60]);
         Yii::$app->session->set('stat', true);
     }
 }
Exemplo n.º 3
0
 public function actionIndex()
 {
     $cateCount = Category::find()->count();
     $productCount = Product::find()->count();
     $onlineCount = Session::find()->where(['status' => 1])->count();
     $userCount = Session::find()->count();
     return $this->render('index', ['cateCount' => $cateCount, 'productCount' => $productCount, 'onlineCount' => $onlineCount, 'userCount' => $userCount]);
 }
 /**
  * Store a newly created resource in storage.
  *
  * @param  Request  $request
  * @return Response
  */
 public function store(Request $request)
 {
     //
     $user = User::getAuthUser();
     if ($user->canCreateSessions(Input::get('team_id'))) {
         $validator = Validator::make($request->all(), ['topic' => 'required', 'date' => 'required']);
         if ($validator->fails()) {
             return response()->json(['message' => $validator->messages()], 400);
         }
         Session::create(Input::all());
     } else {
         return response()->json(['message' => 'You do not have permission to create a session for this team'], 400);
     }
 }
Exemplo n.º 5
0
<?php

//namespace app\core;
use app\models\Cookie;
use app\models\Config;
use app\models\Session;
use app\models\User;
use app\classes\DB;
session_start();
$GLOBALS['config'] = ['mysql' => ['host' => '127.0.0.1', 'username' => 'root', 'password' => 'root', 'db' => 'test'], 'remember' => ['cookie_name' => 'hash', 'cookie_expiry' => 604800], 'session' => ['session_name' => 'root', 'token_name' => 'token']];
spl_autoload_register(function ($class) {
    require_once 'classes/' . $class . '.php';
});
require_once "functions/sanitize.php";
if (Cookie::exists(Config::get('remember/cookie_name')) && !Session::exists(Config::get('session/session_name'))) {
    $hash = Cookie::get(Config::get('remember/cookie_name'));
    $hashCheck = DB::connect()->get('users_session', ['hash', '=', $hash]);
    if ($hashCheck->count()) {
        $user = new User($hashCheck->first()->user_id);
        $user->login();
    }
}
Exemplo n.º 6
0
 /**
  * Finds the Session model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param integer $id
  * @return Session the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModel($id)
 {
     if (($model = Session::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }
Exemplo n.º 7
0
 public static function createRecord($data)
 {
     $data['organization_id'] = \Session::get('user_organization');
     return self::create($data);
 }
Exemplo n.º 8
0
$ctrl = isset($_GET['ctrl']) ? $_GET['ctrl'] : 'News';
$act = isset($_GET['act']) ? $_GET['act'] : 'All';
$classController = 'app\\controllers\\' . $ctrl . 'Controller';
//require __DIR__ . '/classes/DB.php';
$controller = new $classController();
$method = "action" . $act;
$controller->{$method}();
if (require_once 'core/init.php') {
    echo 1;
}
use app\models\Session;
use app\models\User;
use app\classes\DB;
$user = DB::connect();
if (Session::exists('home')) {
    echo "<p><b>" . Session::flash('home') . "</b></p>";
}
$user = new User();
if ($user->isLoggedIn()) {
    ?>
    <p>Hello, <a href="profile.php?user=<?php 
    echo escape($user->data()->username);
    ?>
"><?php 
    echo $user->data()->username;
    ?>
</a></p>
    <ul>
        <li>You can <a href="logout.php">log out</a> here!</li>
        <li>You can <a href="update.php">update</a> your profile here!</li>
        <li>You can <a href="changepassword.php">change password</a> here!</li>
Exemplo n.º 9
0
    public function actionSave()
    {
        $session = new Session();
        $user = Yii::$app->user->identity;
        $cart = Cart::getCurrentCart();
        $cart->processCart();
        if ($cart->total > 0) {
            return $this->actionCharge();
        }
        $cart->status = Cart::CART_SOLD;
        $cart->save();
        $session->addSuccess(Yii::t('app', 'Congratulations, you\'ve completed your order!'));
        $cart_lines = [];
        foreach ($cart->items as $item) {
            $cart_lines[] = $item->ticket->group->event->name . ': ' . $item->ticket->name . ' x' . $item->quantity . ' @ ' . $item->ticket->ticket_price . ' each';
        }
        $cart_details = implode("\n", $cart_lines);
        $email = new Email();
        $email->to_name = $user->name;
        $email->to_email = $user->email;
        $email->subject = "Your Tixty Purchase";
        $message = <<<EOT
Hi {$user->name}!!

You just bought {$cart->quantity} tickets for a total of {$cart->total} - details below.

Thanks,

Tixty

---
{$cart_details}
EOT;
        $email->body = nl2br($message);
        $email->save();
        $email->send();
        $email = new Email();
        $email->to_name = "Tixty";
        $email->to_email = \Yii::$app->params['adminEmail'];
        $email->subject = "Tixty Purchase #{$cart->id}";
        $message = <<<EOT
{$user->name} just bought {$cart->quantity} tickets for a total of {$cart->total} - details below.

Tixty

---
{$cart_details}
EOT;
        $email->body = nl2br($message);
        $email->save();
        $email->send();
        return $this->redirect('index');
    }
Exemplo n.º 10
0
 public function cleanUp()
 {
     $items = $this->getItems()->all();
     $items_removed = false;
     foreach ($items as $item) {
         $ticket = Ticket::findOne($item->ticket_id);
         if (!$ticket->isAvailable()) {
             $this->removeItem($item->ticket_id);
             $items_removed = true;
         } else {
             if ($ticket->getAvailableQuantity() !== false && $item->quantity > $ticket->getAvailableQuantity()) {
                 $this->updateItem($item->ticket_id, $ticket->getAvailableQuantity());
                 $items_removed = true;
             }
         }
     }
     if ($items_removed) {
         $session = new Session();
         $session->addError(Yii::t('app', 'Unavailable tickets removed'));
     }
 }
Exemplo n.º 11
0
 public function getSessionByEnseignant($id_Enseignant)
 {
     return Session::join("Session_Medecin", "Session_Medecin.id_Session", "=", "Session.id_Session")->where("Session_Medecin.id_Enseignant", "=", $id_Enseignant)->get();
 }
Exemplo n.º 12
0
 /**
  * Check if the hash is valid to get the user linked to the hash
  *
  * @param Request $request
  * @return Bool
  */
 protected function setSessionUser(Request $request)
 {
     $hash = $request->header('X-SESSION-ID');
     $session = Session::whereHash($hash)->first();
     if (!$session) {
         return false;
     }
     $this->hash = $hash;
     $this->user = $session->user;
     return true;
 }
Exemplo n.º 13
0
use app\models\CartItems;
use app\models\Session;
use yii\helpers\Url;
use yii\helpers\Html;
$this->title = Yii::t('app', 'Your cart');
$cartItems = CartItems::find()->where(['cart_id' => $cart->id]);
$cart->processCart();
$dataProvider = new yii\data\ActiveDataProvider(['query' => $cartItems]);
$formatter = \Yii::$app->formatter;
?>
<h1><?php 
echo Html::encode($this->title);
?>
</h1>
<?php 
$session = new Session();
$errors = $session->getErrors();
$session->clearErrors();
foreach ($errors as $e) {
    ?>
<div class="alert alert-danger"><h2><?php 
    echo $e;
    ?>
</h2></div><?php 
}
$successes = $session->getSuccesses();
$session->clearSuccesses();
foreach ($successes as $e) {
    ?>
<div class="alert alert-success"><h2><?php 
    echo $e;
Exemplo n.º 14
0
 public function logout()
 {
     $this->_db->delete('users_session', ['user_id', '=', $this->data()->id]);
     Session::delete($this->_sessionName);
     Cookie::delete($this->_cookieName);
 }
Exemplo n.º 15
0
 public function postEditSchedule(int $id)
 {
     $file = fopen(request()->file('schedule_file')->getRealPath(), 'r');
     $l = 0;
     while ($line = fgetcsv($file)) {
         if ($l++ === 0) {
             continue;
         }
         //skipping headers
         Session::create(['title' => $line[0], 'description' => $line[1], 'begin' => $line[2], 'end' => $line[3], 'event_id' => $id]);
     }
     $total = $l - 1;
     //skipping header
     if ($total > 0) {
         \Session::flash('success', __('One activity was imported.', 'A total of %d activities were imported.', $total));
     } else {
         \Session::flash('warning', _('No activity was found in the file.'));
     }
     return $this->edit('schedule', $id);
 }
Exemplo n.º 16
0
 function validAccess($id)
 {
     $row = \DB::table('tb_groups_access')->where('module_id', '=', $id)->where('group_id', '=', \Session::get('gid'))->get();
     if (count($row) >= 1) {
         $row = $row[0];
         if ($row->access_data != '') {
             $data = json_decode($row->access_data, true);
         } else {
             $data = array();
         }
         return $data;
     } else {
         return false;
     }
 }
Exemplo n.º 17
0
 public function init()
 {
     Session::logStat();
 }