User Deprecated: Since symfony/security-guard 5.3: The "Symfony\Component\Security\Guard\Authenticator\GuardBridgeAuthenticator" class is deprecated, use the new authenticator system instead.
"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.is_active AS is_active_7, t0.person_id AS person_id_8 FROM user t0 WHERE t0.id = ? LIMIT 1"
(parameters:
[1 => 44]
, 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.is_active AS is_active_7, t0.person_id AS person_id_8 FROM user t0 WHERE t0.id = ? LIMIT 1"
"params" => [1 => 44]
"types" => [1 => 1]
]
deprecation
User Deprecated: Since symfony/security-guard 5.3: The "Symfony\Component\Security\Guard\Token\PostAuthenticationGuardToken" class is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-guard 5.3: The "Symfony\Component\Security\Guard\Token\GuardTokenInterface" class is deprecated, use the new authenticator system instead.
"""
SELECT a.id, \n (select count(*) from transaction where created_by = a.user_id and daily_account_id = a.id) as transactions,\n (select sum(amount) from transaction where created_by = a.user_id and daily_account_id = a.id and is_cancelled = false) as transactions_amount,\n\n (select count(*) from transaction where created_by = a.user_id and is_cancelled = true and daily_account_id = a.id) as cancelled_transactions,\n (select sum(amount) from transaction where created_by = a.user_id and is_cancelled = true and daily_account_id = a.id) as cancelled_amount,\n\n (select count(*) from transaction where created_by = a.user_id and is_cancelled = false and mpesa_amount > 0 and daily_account_id = a.id) as mpesa_transactions,\n (select sum(mpesa_amount) from transaction where created_by = a.user_id and is_cancelled = false and mpesa_amount > 0 and daily_account_id = a.id) as mpesa_amount,\n\n (select count(*) from transaction where created_by = a.user_id and is_cancelled = false and cash_amount > 0 and daily_account_id = a.id) as cash_transactions,\n (select sum(cash_amount) from transaction where created_by = a.user_id and is_cancelled = false and cash_amount > 0 and daily_account_id = a.id) as cash_amount,\n (SELECT sum(inner_a.amount) FROM station_expense inner_a WHERE inner_a.daily_account_id = a.id and inner_a.is_cancelled = false ) as expenses,\n (SELECT count(*) FROM station_expense inner_a WHERE inner_a.daily_account_id = a.id and inner_a.is_cancelled = false ) as expenses_count\n FROM daily_account a where a.user_id = 44 and a.is_closed = 0 ORDER BY a.id desc LIMIT 1\n\n
"""
(parameters:
[]
, types:
[]
)
doctrine
[
"sql" => """
SELECT a.id, \n (select count(*) from transaction where created_by = a.user_id and daily_account_id = a.id) as transactions,\n (select sum(amount) from transaction where created_by = a.user_id and daily_account_id = a.id and is_cancelled = false) as transactions_amount,\n\n (select count(*) from transaction where created_by = a.user_id and is_cancelled = true and daily_account_id = a.id) as cancelled_transactions,\n (select sum(amount) from transaction where created_by = a.user_id and is_cancelled = true and daily_account_id = a.id) as cancelled_amount,\n\n (select count(*) from transaction where created_by = a.user_id and is_cancelled = false and mpesa_amount > 0 and daily_account_id = a.id) as mpesa_transactions,\n (select sum(mpesa_amount) from transaction where created_by = a.user_id and is_cancelled = false and mpesa_amount > 0 and daily_account_id = a.id) as mpesa_amount,\n\n (select count(*) from transaction where created_by = a.user_id and is_cancelled = false and cash_amount > 0 and daily_account_id = a.id) as cash_transactions,\n (select sum(cash_amount) from transaction where created_by = a.user_id and is_cancelled = false and cash_amount > 0 and daily_account_id = a.id) as cash_amount,\n (SELECT sum(inner_a.amount) FROM station_expense inner_a WHERE inner_a.daily_account_id = a.id and inner_a.is_cancelled = false ) as expenses,\n (SELECT count(*) FROM station_expense inner_a WHERE inner_a.daily_account_id = a.id and inner_a.is_cancelled = false ) as expenses_count\n FROM daily_account a where a.user_id = 44 and a.is_closed = 0 ORDER BY a.id desc LIMIT 1\n\n
"""
"params" => []
"types" => []
]