Exemple #1
0
<?php

require_once Yii::app()->basePath . '/extensions/editor_datatables/php/DataTables.php';
//Alias Editor classes so they are easy to use
use DataTables\Editor, DataTables\Editor\Field, DataTables\Editor\Format, DataTables\Editor\Join, DataTables\Editor\Upload, DataTables\Editor\Validate;
$user = Users::model()->findByPk(Yii::app()->user->id);
$client_id = $user->client_id;
function userupdate()
{
    $user_data = Users::model()->findByPk(Yii::app()->user->id);
    $step_completed = $user_data->step_completed;
    if ($user_data->user_role == 2 && $step_completed < 2) {
        $user_data->step_completed = 2;
        $user_data->save();
        //$this->redirect(Yii::app()->baseUrl.'/site/admin');
        $baseUrl = Yii::app()->baseUrl;
        //Yii::app()->request->redirect($baseUrl.'/site/admin');
        //echo "<script>window.location.href ='".$baseUrl."/site/admin';</script>";
        //return false;
    }
    //else{ $this->render('overview', ['user_data' => $user_data]); }
}
//Build our Editor instance and process the data coming from _POST
$time = date("fYhis");
// $extension = end(explode('.', Upload::DB_FILE_NAME));
Editor::inst($db, 'benchmarks', 'id', $time, $client_id)->fields(Field::inst('benchmarks.client_id'), Field::inst('benchmarks.id as id'), Field::inst('benchmarks.benchmark_name as benchmark_name'), Field::inst('clients.client_name'))->on('postCreate', function () {
    userupdate();
})->leftJoin('clients', 'clients.id', '=', 'benchmarks.client_id')->where('benchmarks.client_id', $client_id)->process($_POST)->json();
Exemple #2
0
require_once Yii::app()->basePath . '/extensions/editor_datatables/php/DataTables.php';
//Alias Editor classes so they are easy to use
use DataTables\Editor, DataTables\Editor\Field, DataTables\Editor\Format, DataTables\Editor\Join, DataTables\Editor\Upload, DataTables\Editor\Validate;
$user = Users::model()->findByPk(Yii::app()->user->id);
$client_id = $user->client_id;
$user_role = $user->user_role;
//$client_id = Yii::app()->user->getState('client_id');
function userupdate($editor, $id, $values, $row)
{
    $user_data = Users::model()->findByPk(Yii::app()->user->id);
    $step_completed = $user_data->step_completed;
    if ($user_data->user_role == 2 && $step_completed < 4) {
        $user_data->step_completed = 4;
        $user_data->default_portfolio_id = $id;
        $user_data->accessable_portfolios = $id;
        $user_data->save();
        //$this->redirect(Yii::app()->baseUrl.'/site/admin');
        $baseUrl = Yii::app()->baseUrl;
    }
    //else{ $this->render('overview', ['user_data' => $user_data]); }
}
if ($user_role == 1) {
    Editor::inst($db, 'portfolios', 'id', $client_id)->fields(Field::inst('clients.client_name as client_name'), Field::inst('portfolios.id as id'), Field::inst('portfolios.portfolio as portfolio')->validator('Validate::notEmpty'), Field::inst('portfolios.client_id as client_id')->validator('Validate::notEmpty'), Field::inst('portfolios.description as description'), Field::inst('portfolios.is_current as is_current'), Field::inst('portfolios.created_at as created_at'), Field::inst('portfolios.benchmark_id as benchmark_id')->validator('Validate::notEmpty'), Field::inst('portfolios.allocation_min as allocation_min')->validator('Validate::notEmpty'), Field::inst('portfolios.allocation_max as allocation_max')->validator('Validate::notEmpty'), Field::inst('portfolios.allocation_normal as allocation_normal')->validator('Validate::notEmpty'), Field::inst('benchmarks.benchmark_name as benchmark_name'), Field::inst('portfolios.parrent_portfolio as parrent_portfolio'), Field::inst('portfolios1.portfolio as parrent_portfolio1'), Field::inst('portfolios.currency as currency')->validator('Validate::notEmpty'))->on('postCreate', function ($editor, $id, $values, $row) {
        userupdate($editor, $id, $values, $row);
    })->leftJoin('clients', 'clients.id', '=', 'portfolios.client_id')->leftJoin('benchmarks', 'benchmarks.id', '=', 'portfolios.benchmark_id')->leftJoin('portfolios as portfolios1', 'portfolios.parrent_portfolio', '=', 'portfolios1.id')->process($_POST)->json();
} else {
    Editor::inst($db, 'portfolios', 'id', $client_id)->fields(Field::inst('clients.client_name as client_name'), Field::inst('portfolios.id as id'), Field::inst('portfolios.portfolio as portfolio')->validator('Validate::notEmpty'), Field::inst('portfolios.client_id as client_id')->validator('Validate::notEmpty'), Field::inst('portfolios.description as description'), Field::inst('portfolios.is_current as is_current'), Field::inst('portfolios.created_at as created_at'), Field::inst('portfolios.benchmark_id as benchmark_id')->validator('Validate::notEmpty'), Field::inst('portfolios.allocation_min as allocation_min')->validator('Validate::notEmpty'), Field::inst('portfolios.allocation_max as allocation_max')->validator('Validate::notEmpty'), Field::inst('portfolios.allocation_normal as allocation_normal')->validator('Validate::notEmpty'), Field::inst('benchmarks.benchmark_name as benchmark_name'), Field::inst('portfolios.parrent_portfolio as parrent_portfolio'), Field::inst('portfolios1.portfolio as parrent_portfolio1'), Field::inst('portfolios.currency as currency')->validator('Validate::notEmpty'))->on('postCreate', function ($editor, $id, $values, $row) {
        userupdate($editor, $id, $values, $row);
    })->leftJoin('clients', 'clients.id', '=', 'portfolios.client_id')->leftJoin('benchmarks', 'benchmarks.id', '=', 'portfolios.benchmark_id')->leftJoin('portfolios as portfolios1', 'portfolios.parrent_portfolio', '=', 'portfolios1.id')->where('portfolios.client_id', $client_id)->process($_POST)->json();
}