появился еще вопрос:
по видео в youtube предварительно увидел, что debugbar - не выводит имя Контроллера, Модели, список отработанных фильтров - или там в НАСТРОЙКАХ можно указывать?
пока часть инф получилось выудить так
$controllers = [];
$i=0;
foreach (Route::getRoutes()->getRoutes() as $route)
{
$action = $route->getAction();
if (array_key_exists('controller', $action))
{
$_action = explode('@',$action['controller']);
$_namespaces_chunks = explode('\\',$_action[0]);
$controllers[$i]['controller'] = end($_namespaces_chunks);
$controllers[$i]['action'] = end($_action);
$controllers[$i]['namespace'] = $action['controller'];
$controllers[$i]['route'] = $route;
}
$i++;
}
dump($controllers);
SELECT t1.user_id, email, Loans_count
FROM
(SELECT DISTINCT user_id FROM db.adv_partner_user_params WHERE adv_partner_id=1) AS t1
INNER JOIN db.users AS t2
ON t1.user_id=t2.id
INNER JOIN (SELECT user_id, COUNT(*) AS Loans_count FROM db.loans GROUP BY user_id) AS t3
ON t1.user_id = t3.user_id
Ребята, привет
помогите объединить запросы:
$Query_1 = Loan::query()
->select('loans.user_id')
->selectRaw('sum(loans.amount_usd) as llRequest')
->where('loans.status_id',1)
->from('loans')
->groupBy('loans.user_id');
$Query_2 = Loan::query()
->select('loans.user_id')
->selectRaw('sum(loans.amount_usd) as llInWork')
->where('loans.status_id',1)
->from('loans')
->groupBy('loans.user_id');
надо объединить $Query_1 и $Query_2 по 'loans.user_id' столбцу чтоб получить массив вида:
user_id | llRequest | llInWork
guys,
is it possible to do the next query in eloquent:
SELECT
FROM(
(Select Count() as StockCountA from Table_A where dept='AAA') StockCountA ,
(Select Count(*) as StockCountB from Table_B where dept='BBB') StockCountB
);
i want to combine result of two query in one raw.
tried a lot of variants. Would be appreciate for any ideas.
Unable to connect to host 127.0.0.1, or the request timed out.
Be sure that the address is correct and that you have the necessary privileges, or try increasing the connection timeout (currently 10 seconds).
MySQL said: Protocol mismatch; server version = 11, client version = 10