Log Messages
Info. & Errors 1
Informational and error log messages generated during the execution of the application.
Level | Channel | Message |
---|---|---|
INFO | request |
Matched route "submit_sale_report" .
[ "route" => "submit_sale_report" "route_parameters" => [ "_route" => "submit_sale_report" "_controller" => "App\Controller\ServicesController::submitSaleReport" ] "request_uri" => "http://bio-moosod.com/services/submitSaleReport" "method" => "POST" ] |
Deprecations 3
Log messages generated by using features marked as deprecated.
Debug 237
Unimportant log messages generated during the execution of the application.
Time | Channel | Message |
---|---|---|
security |
Checking for authenticator support.
[ "firewall_name" => "main" "authenticators" => 1 ] |
|
security |
Checking support on authenticator.
[ "firewall_name" => "main" "authenticator" => "App\Security\AppCustomAuthenticator" ] |
|
security |
Authenticator does not support the request.
[ "firewall_name" => "main" "authenticator" => "App\Security\AppCustomAuthenticator" ] |
|
event |
Notified event "debug.security.authorization.vote" to listener "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote" .
[ "event" => "debug.security.authorization.vote" "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator" .
[ "event" => "kernel.request" "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest" ] |
|
event |
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController" ] |
|
event |
Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments" .
[ "event" => "kernel.controller_arguments" "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments" ] |
|
event |
Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments" .
[ "event" => "kernel.controller_arguments" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments" ] |
|
event |
Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments" .
[ "event" => "kernel.controller_arguments" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments" ] |
|
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.branch_ref_key AS branch_ref_key_3, t0.branch_id AS branch_id_4, t0.branch_code AS branch_code_5, t0.branch_name AS branch_name_6, t0.address AS address_7, t0.postel AS postel_8, t0.update_by AS update_by_9, t0.update_date AS update_date_10, t0.flag_status AS flag_status_11, t0.flag_show_product_cost AS flag_show_product_cost_12, t0.flag_show_product_balance AS flag_show_product_balance_13, t0.province_key AS province_key_14 FROM branch t0 WHERE t0.ref_id = ? LIMIT 1
[
"62afbdd6e1a88"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report (report_date, total_cost, total_sale, ref_id, flag_status, branch_id) VALUES (?, ?, ?, ?, ?, ?)
[ 1 => DateTime @1731671172 {#376 : 2024-11-15 11:46:12.0 +00:00 } 2 => 7887.0 3 => 9266.0 4 => "67373ec5b070a" 5 => 1 6 => 15 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fcc0495"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 127.0 2 => 162.0 3 => null 4 => 3.13 5 => 1 6 => 9714 7 => 97 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 96 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -3774.62 1560 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fc788de"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 65.0 2 => 85.0 3 => null 4 => 1.0 5 => 1 6 => 9714 7 => 50 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 50 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -122.0 1548 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fca451a"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 106.0 2 => 123.0 3 => null 4 => 6.69 5 => 1 6 => 9714 7 => 75 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 4 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -6550.85 1511 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fc81a19"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 134.0 2 => 151.0 3 => null 4 => 6.23 5 => 1 6 => 9714 7 => 56 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 5 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -2361.51 1512 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fc83823"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 140.0 2 => 159.0 3 => null 4 => 13.0 5 => 1 6 => 9714 7 => 57 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 8 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -11059.74 1515 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"617eaa9829bf3"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 110.0 2 => 140.0 3 => null 4 => 1.0 5 => 1 6 => 9714 7 => 124 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 124 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -264.0 1576 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fc85655"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 113.0 2 => 133.0 3 => null 4 => 11.24 5 => 1 6 => 9714 7 => 58 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 3 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -10138.75 1510 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fc87226"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 105.0 2 => 121.0 3 => null 4 => 1.61 5 => 1 6 => 9714 7 => 59 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 7 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -6899.26 1514 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fc88d80"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 64.0 2 => 79.0 3 => null 4 => 1.4 5 => 1 6 => 9714 7 => 60 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 10 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -204.5 1517 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fc9349d"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 125.0 2 => 140.0 3 => null 4 => 1.42 5 => 1 6 => 9714 7 => 65 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 17 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -1092.36 1524 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fcbea6b"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 127.0 2 => 167.0 3 => null 4 => 1.09 5 => 1 6 => 9714 7 => 96 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 96 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -3775.71 1560 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fcce033"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 50.0 2 => 70.0 3 => null 4 => 1.0 5 => 1 6 => 9714 7 => 104 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 104 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -146.0 1563 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fc49413"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 106.0 2 => 128.0 3 => null 4 => 2.22 5 => 1 6 => 9714 7 => 4 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 4 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -6553.07 1511 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fc4c01b"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 105.0 2 => 126.0 3 => null 4 => 2.27 5 => 1 6 => 9714 7 => 7 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 7 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -6901.53 1514 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fc4d35b"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 140.0 2 => 164.0 3 => null 4 => 1.57 5 => 1 6 => 9714 7 => 8 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 8 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -11061.31 1515 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"617cd0031206e"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 100.0 2 => 120.0 3 => null 4 => 3.0 5 => 1 6 => 9714 7 => 118 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 118 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -1231.0 1570 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"617cd0246ee19"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 85.0 2 => 125.0 3 => null 4 => 1.0 5 => 1 6 => 9714 7 => 119 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 119 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -97.0 1571 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fc778f4"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 40.0 2 => 60.0 3 => null 4 => 1.0 5 => 1 6 => 9714 7 => 49 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 49 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -193.0 1547 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fc460db"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 106.0 2 => 128.0 3 => null 4 => 0.94 5 => 1 6 => 9714 7 => 1 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 1 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -8624.08 1508 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fc8adf3"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 123.0 2 => 138.0 3 => null 4 => 3.02 5 => 1 6 => 9714 7 => 61 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 9 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -4229.15 1516 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fc972b2"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 60.0 2 => 75.0 3 => null 4 => 1.04 5 => 1 6 => 9714 7 => 67 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 140 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -1703.32 1586 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fc7ff9d"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 106.0 2 => 123.0 3 => null 4 => 1.28 5 => 1 6 => 9714 7 => 55 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 1 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -8625.36 1508 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fcbb3ad"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 109.0 2 => 137.0 3 => null 4 => 1.11 5 => 1 6 => 9714 7 => 94 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 94 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -958.51 1559 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = ? LIMIT 1
[
"6178c3fc4a34c"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 134.0 2 => 156.0 3 => null 4 => 1.13 5 => 1 6 => 9714 7 => 5 ] |
|
doctrine | "COMMIT" | |
doctrine |
SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = ? AND p0_.product_id = ?
[ 15 5 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -2362.64 1512 ] |
|
doctrine | "COMMIT" | |
doctrine | SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' | |
doctrine | SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' | |
doctrine | SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' | |
event |
Notified event "kernel.response" to listener "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest" ] |
PHP Notices 0
Log messages generated by PHP notices silenced with the @ operator.
There are no log messages of this level.
Container 897
Log messages generated during the compilation of the service container.
Class | Messages |
---|---|
Symfony\Component\DependencyInjection\Compiler\ResolveChildDefinitionsPass
|
148 |
Symfony\Component\DependencyInjection\Compiler\RemovePrivateAliasesPass
|
174 |
Symfony\Component\DependencyInjection\Compiler\ReplaceAliasByActualDefinitionPass
|
65 |
Symfony\Component\DependencyInjection\Compiler\RemoveAbstractDefinitionsPass
|
142 |
Symfony\Component\DependencyInjection\Compiler\RemoveUnusedDefinitionsPass
|
85 |
Symfony\Component\DependencyInjection\Compiler\InlineServiceDefinitionsPass
|
283 |