public function actionIndex()
{
$items = Request::query()->select(['cap_requests.*', 'cap_users.avatar as cap_users_avatar', 'cap_users.name_first as cap_users_name_first', 'cap_users.name_last as cap_users_name_last', 'cap_users.email as cap_users_email', 'cap_stock.name as cap_stock_name', 'cap_stock.logo as cap_stock_logo'])->innerJoin('cap_users', 'cap_users.id = cap_requests.user_id')->innerJoin('cap_stock', 'cap_stock.id = cap_requests.stock_id')->orderBy(['datetime' => SORT_DESC])->all();
return $this->render(['items' => $items]);
}
public function actionRequests()
{
return $this->render(['items' => \app\models\Request::query(['user_id' => \Yii::$app->user->id])->all()]);
}
