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 253
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
[
"614960ef588b0"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report (report_date, total_cost, total_sale, ref_id, flag_status, branch_id) VALUES (?, ?, ?, ?, ?, ?)
[ 1 => DateTime @1731935364 {#376 : 2024-11-18 13:09:24.0 +00:00 } 2 => 10280.0 3 => 11826.0 4 => "673b591450ed7" 5 => 1 6 => 3 ] |
|
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.0 5 => 1 6 => 9754 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 = ?
[ 3 96 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -6800.83 213 ] |
|
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
[
"6178c3fc5b238"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 80.0 2 => 100.0 3 => null 4 => 0.39 5 => 1 6 => 9754 7 => 22 ] |
|
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 = ?
[ 3 22 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -4668.04 139 ] |
|
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
[
"6178c3fc5c3c4"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 55.0 2 => 75.0 3 => null 4 => 1.25 5 => 1 6 => 9754 7 => 23 ] |
|
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 = ?
[ 3 23 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -874.52 140 ] |
|
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
[
"6178c3fc5610a"
]
|
|
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 => 145.0 3 => null 4 => 0.56 5 => 1 6 => 9754 7 => 17 ] |
|
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 = ?
[ 3 17 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -4688.01 134 ] |
|
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 => 123.0 3 => null 4 => 2.89 5 => 1 6 => 9754 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 = ?
[ 3 4 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -32838.06 121 ] |
|
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 => 118.0 3 => null 4 => 18.0 5 => 1 6 => 9754 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 = ?
[ 3 4 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -32856.06 121 ] |
|
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
[
"6178c3fc471a0"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 145.0 2 => 165.0 3 => null 4 => 1.19 5 => 1 6 => 9754 7 => 2 ] |
|
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 = ?
[ 3 2 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -1920.53 119 ] |
|
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 => 146.0 3 => null 4 => 5.46 5 => 1 6 => 9754 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 = ?
[ 3 5 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -9530.24 122 ] |
|
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
[
"6178c3fc8d222"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 245.0 2 => 260.0 3 => null 4 => 1.11 5 => 1 6 => 9754 7 => 62 ] |
|
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 = ?
[ 3 11 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -6011.26 128 ] |
|
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 => 2.19 5 => 1 6 => 9754 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 = ?
[ 3 17 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -4690.2 134 ] |
|
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
[
"6178c3fc8f42f"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 80.0 2 => 95.0 3 => null 4 => 2.08 5 => 1 6 => 9754 7 => 63 ] |
|
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 = ?
[ 3 22 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -4670.12 139 ] |
|
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 => 8.02 5 => 1 6 => 9754 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 = ?
[ 3 10 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -3061.83 127 ] |
|
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 => 128.0 3 => null 4 => 6.79 5 => 1 6 => 9754 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 = ?
[ 3 3 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -18823.55 120 ] |
|
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 => 151.0 3 => null 4 => 1.05 5 => 1 6 => 9754 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 = ?
[ 3 5 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -9531.29 122 ] |
|
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
[
"6178c3fc512e8"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 42.0 2 => 62.0 3 => null 4 => 1.77 5 => 1 6 => 9754 7 => 12 ] |
|
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 = ?
[ 3 12 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -6255.37 129 ] |
|
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 => 159.0 3 => null 4 => 0.84 5 => 1 6 => 9754 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 = ?
[ 3 8 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -33121.185 125 ] |
|
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
[
"6178c3fc66003"
]
|
|
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 => 80.0 3 => null 4 => 1.14 5 => 1 6 => 9754 7 => 32 ] |
|
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 = ?
[ 3 32 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -1337.01 149 ] |
|
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
[
"6178c3fc4b226"
]
|
|
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 => 126.0 3 => null 4 => 1.26 5 => 1 6 => 9754 7 => 6 ] |
|
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 = ?
[ 3 6 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -5945.53 123 ] |
|
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 => 154.0 3 => null 4 => 16.13 5 => 1 6 => 9754 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 = ?
[ 3 8 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -33137.315 125 ] |
|
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
[
"6178c3fc55184"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 55.0 2 => 75.0 3 => null 4 => 0.52 5 => 1 6 => 9754 7 => 16 ] |
|
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 = ?
[ 3 16 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -547.61 133 ] |
|
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 => 116.0 3 => null 4 => 7.54 5 => 1 6 => 9754 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 = ?
[ 3 7 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -9477.41 124 ] |
|
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
[
"6178c3fc4851f"
]
|
|
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 => 0.53 5 => 1 6 => 9754 7 => 3 ] |
|
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 = ?
[ 3 3 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -18824.08 120 ] |
|
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
[
"6178c3fc5fa8e"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 8.0 2 => 28.0 3 => null 4 => 1.14 5 => 1 6 => 9754 7 => 26 ] |
|
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 = ?
[ 3 26 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -7020.7 143 ] |
|
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 => 0.5 5 => 1 6 => 9754 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 = ?
[ 3 96 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -6801.33 213 ] |
|
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
[
"61a2cf761f8f4"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 55.0 2 => 75.0 3 => null 4 => 5.0 5 => 1 6 => 9754 7 => 130 ] |
|
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 = ?
[ 3 130 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -81.01 913 ] |
|
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
[
"6178c3fcd95e8"
]
|
|
doctrine | "START TRANSACTION" | |
doctrine |
INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?)
[ 1 => 54.0 2 => 69.0 3 => null 4 => 11.0 5 => 1 6 => 9754 7 => 112 ] |
|
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 = ?
[ 3 25 ] |
|
doctrine | "START TRANSACTION" | |
doctrine |
UPDATE product_branch SET qty = ? WHERE id = ?
[ -3504.72 142 ] |
|
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 |