<?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();
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(); }