"SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.created_at AS created_at_4, t0.roles AS roles_5, t0.email AS email_6, t0.person_id AS person_id_7 FROM user t0 WHERE t0.id = ?"
(parameters:
[1 => 86]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.created_at AS created_at_4, t0.roles AS roles_5, t0.email AS email_6, t0.person_id AS person_id_7 FROM user t0 WHERE t0.id = ?"
"params" => [1 => 86]
"types" => [1 => 1]
]
User Deprecated: Since symfony/framework-bundle 5.4: Method "Symfony\Bundle\FrameworkBundle\Controller\AbstractController::getDoctrine()" is deprecated, inject an instance of ManagerRegistry in your controller instead.
"SELECT t0.id AS id_1, t0.account_date AS account_date_2, t0.is_closed AS is_closed_3, t0.closing_date AS closing_date_4, t0.is_banked AS is_banked_5, t0.created_at AS created_at_6, t0.closed_by AS closed_by_7, t0.created_by AS created_by_8, t0.station_id AS station_id_9 FROM station_daily_account t0 WHERE t0.id = ? LIMIT 1"
(parameters:
[1 => "18776"
]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.account_date AS account_date_2, t0.is_closed AS is_closed_3, t0.closing_date AS closing_date_4, t0.is_banked AS is_banked_5, t0.created_at AS created_at_6, t0.closed_by AS closed_by_7, t0.created_by AS created_by_8, t0.station_id AS station_id_9 FROM station_daily_account t0 WHERE t0.id = ? LIMIT 1"
"params" => [1 => "18776"
]
"types" => [1 => 1]
]
debug
Executing statement:
"""
select a.id,a.account_date, a.station_id, d.station_name, sum(c.amount) as amount, count(c.id) as transactions, \n (SELECT sum(inner_a.amount) FROM station_expense inner_a \n JOIN daily_account inner_b ON inner_b.id = inner_a.daily_account_id \n JOIN station_daily_account inner_c ON inner_c.id = inner_b.station_daily_account \n WHERE inner_c.id =a.id and is_cancelled = false ) as expenses \n FROM station_daily_account a \n JOIN daily_account b ON b.station_daily_account = a.id \n JOIN transaction c ON c.daily_account_id = b.id \n JOIN station d ON a.station_id = d.id \n WHERE a.id =:station_daily_account AND c.is_cancelled = false AND c.is_paid = true AND c.payment_method IS NOT NULL
"""
(parameters:
[
"station_daily_account" => 18776]
, types:
[]
)
doctrine
[
"sql" => """
select a.id,a.account_date, a.station_id, d.station_name, sum(c.amount) as amount, count(c.id) as transactions, \n (SELECT sum(inner_a.amount) FROM station_expense inner_a \n JOIN daily_account inner_b ON inner_b.id = inner_a.daily_account_id \n JOIN station_daily_account inner_c ON inner_c.id = inner_b.station_daily_account \n WHERE inner_c.id =a.id and is_cancelled = false ) as expenses \n FROM station_daily_account a \n JOIN daily_account b ON b.station_daily_account = a.id \n JOIN transaction c ON c.daily_account_id = b.id \n JOIN station d ON a.station_id = d.id \n WHERE a.id =:station_daily_account AND c.is_cancelled = false AND c.is_paid = true AND c.payment_method IS NOT NULL
"""
"params" => [
"station_daily_account" => 18776]
"types" => []
]
debug
Executing statement:
"""
select b.id,a.account_date, a.station_id, d.station_name, sum(c.amount) as amount, count(c.id) as transactions, \n f.first_name, f.second_name, f.sir_name,\n (SELECT sum(amount) FROM transaction WHERE is_cancelled = true and daily_account_id = b.id ) as cancelled_amount, \n (SELECT count(id) FROM transaction WHERE is_cancelled = true and daily_account_id = b.id ) as cancelled,\n\n (SELECT sum(cash_amount) FROM transaction WHERE is_cancelled = false and daily_account_id = b.id AND payment_method is not null) as cash_amount,\n (SELECT sum(mpesa_amount) FROM transaction WHERE is_cancelled = false and daily_account_id = b.id AND payment_method is not null ) as mpesa_amount,\n\n (SELECT sum(inner_a.amount) FROM station_expense inner_a WHERE inner_a.daily_account_id = b.id and inner_a.is_cancelled = false ) as expenses \n FROM station_daily_account a \n JOIN daily_account b ON b.station_daily_account = a.id \n JOIN transaction c ON c.daily_account_id = b.id \n JOIN station d ON a.station_id = d.id \n JOIN user e ON e.id = b.user_id\n JOIN person f ON f.id = e.person_id\n WHERE a.id =:station_daily_account AND c.is_paid = true AND c.is_cancelled = false AND c.payment_method IS NOT NULL GROUP BY b.id
"""
(parameters:
[
"station_daily_account" => 18776]
, types:
[]
)
doctrine
[
"sql" => """
select b.id,a.account_date, a.station_id, d.station_name, sum(c.amount) as amount, count(c.id) as transactions, \n f.first_name, f.second_name, f.sir_name,\n (SELECT sum(amount) FROM transaction WHERE is_cancelled = true and daily_account_id = b.id ) as cancelled_amount, \n (SELECT count(id) FROM transaction WHERE is_cancelled = true and daily_account_id = b.id ) as cancelled,\n\n (SELECT sum(cash_amount) FROM transaction WHERE is_cancelled = false and daily_account_id = b.id AND payment_method is not null) as cash_amount,\n (SELECT sum(mpesa_amount) FROM transaction WHERE is_cancelled = false and daily_account_id = b.id AND payment_method is not null ) as mpesa_amount,\n\n (SELECT sum(inner_a.amount) FROM station_expense inner_a WHERE inner_a.daily_account_id = b.id and inner_a.is_cancelled = false ) as expenses \n FROM station_daily_account a \n JOIN daily_account b ON b.station_daily_account = a.id \n JOIN transaction c ON c.daily_account_id = b.id \n JOIN station d ON a.station_id = d.id \n JOIN user e ON e.id = b.user_id\n JOIN person f ON f.id = e.person_id\n WHERE a.id =:station_daily_account AND c.is_paid = true AND c.is_cancelled = false AND c.payment_method IS NOT NULL GROUP BY b.id
"""
"params" => [
"station_daily_account" => 18776]
"types" => []
]