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.person_id AS person_id_7 FROM user t0 WHERE t0.id = ? LIMIT 1"
(parameters:
[1 => 127]
, 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 = ? LIMIT 1"
"params" => [1 => 127]
"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.
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 a.id as id, \n a.receiver_name,\n a.receiver_phone_number,\n a.sender_name,\n a.is_collected,\n a.is_received,\n a.sender_phone_number,\n b.station_name as from_station, \n c.station_name as to_station,\n d.amount as amount,\n (SELECT GROUP_CONCAT(description) from parcel where way_bill_id = a.id) AS parcels,\n cp.collector_name as collector_name,\n cp.consignee_national_id as consignee_national_id,\n a.receiver_name as consignee_name,\n cp.national_id as national_id, \n cp.created_at as collected_at,\n concat(j.first_name,' ',j.second_name,' ', j.sir_name) as sending_clerk,\n a.created_at as sending_time,\n concat(h.first_name,' ',h.second_name,' ', h.sir_name) as loading_clerk, \n concat(l.first_name,' ',l.second_name,' ', l.sir_name) as receiving_clerk,\n concat(n.first_name,' ',n.second_name,' ', n.sir_name) as collector_clerk,\n concat(p.first_name,' ',p.second_name,' ', p.sir_name) as receiving_clerk_1,\n a.received_at as received_at_1,\n dp.received_at as received_at\n\n\n\n FROM way_bill a \n JOIN station b ON b.id = a.from_station_id\n JOIN station c ON c.id = a.to_station_id\n JOIN transaction d on a.id = d.way_bill_id \n LEFT JOIN collected_parcel cp on a.id = cp.waybill_id\n LEFT JOIN parcel e on e.way_bill_id = a.id\n LEFT JOIN delivery_parcel dp on e.id = dp.parcel_id\n LEFT JOIN delivery f on f.id = dp.delivery_id\n\n LEFT JOIN user g ON g.id = f.loaded_by\n LEFT JOIN person h on h.id = g.person_id\n\n JOIN user i ON i.id = a.created_by\n JOIN person j on j.id = i.person_id \n\n LEFT JOIN user k ON k.id = dp.received_by\n LEFT JOIN person l on l.id = k.person_id\n\n LEFT JOIN user m ON m.id = cp.created_by\n LEFT JOIN person n on n.id = m.person_id\n\n LEFT JOIN user o ON o.id = a.received_by\n LEFT JOIN person p on p.id = o.person_id\n\n WHERE a.to_station_id = 2 AND a.id = 1077534 LIMIT 1
"""
(parameters:
[]
, types:
[]
)
doctrine
[
"sql" => """
SELECT a.id as id, \n a.receiver_name,\n a.receiver_phone_number,\n a.sender_name,\n a.is_collected,\n a.is_received,\n a.sender_phone_number,\n b.station_name as from_station, \n c.station_name as to_station,\n d.amount as amount,\n (SELECT GROUP_CONCAT(description) from parcel where way_bill_id = a.id) AS parcels,\n cp.collector_name as collector_name,\n cp.consignee_national_id as consignee_national_id,\n a.receiver_name as consignee_name,\n cp.national_id as national_id, \n cp.created_at as collected_at,\n concat(j.first_name,' ',j.second_name,' ', j.sir_name) as sending_clerk,\n a.created_at as sending_time,\n concat(h.first_name,' ',h.second_name,' ', h.sir_name) as loading_clerk, \n concat(l.first_name,' ',l.second_name,' ', l.sir_name) as receiving_clerk,\n concat(n.first_name,' ',n.second_name,' ', n.sir_name) as collector_clerk,\n concat(p.first_name,' ',p.second_name,' ', p.sir_name) as receiving_clerk_1,\n a.received_at as received_at_1,\n dp.received_at as received_at\n\n\n\n FROM way_bill a \n JOIN station b ON b.id = a.from_station_id\n JOIN station c ON c.id = a.to_station_id\n JOIN transaction d on a.id = d.way_bill_id \n LEFT JOIN collected_parcel cp on a.id = cp.waybill_id\n LEFT JOIN parcel e on e.way_bill_id = a.id\n LEFT JOIN delivery_parcel dp on e.id = dp.parcel_id\n LEFT JOIN delivery f on f.id = dp.delivery_id\n\n LEFT JOIN user g ON g.id = f.loaded_by\n LEFT JOIN person h on h.id = g.person_id\n\n JOIN user i ON i.id = a.created_by\n JOIN person j on j.id = i.person_id \n\n LEFT JOIN user k ON k.id = dp.received_by\n LEFT JOIN person l on l.id = k.person_id\n\n LEFT JOIN user m ON m.id = cp.created_by\n LEFT JOIN person n on n.id = m.person_id\n\n LEFT JOIN user o ON o.id = a.received_by\n LEFT JOIN person p on p.id = o.person_id\n\n WHERE a.to_station_id = 2 AND a.id = 1077534 LIMIT 1
"""
"params" => []
"types" => []
]