Log Messages
Info. & Errors 2
Informational and error log messages generated during the execution of the application.
Level | Channel | Message |
---|---|---|
INFO | request |
Matched route "sales_dashboard" .
[ "route" => "sales_dashboard" "route_parameters" => [ "_route" => "sales_dashboard" "_controller" => "ApplicationBundle\Controller\DashboardController::indexSalesAction" ] "request_uri" => "https://www.ourhoneybee.xyz/sales_dashboard" "method" => "GET" ] |
INFO | security | Populated the TokenStorage with an anonymous Token. |
Deprecations 35
Log messages generated by using features marked as deprecated.
Time | Channel | Message |
---|---|---|
n/a (2 times) |
The "framework.templating" configuration is deprecated since Symfony 4.3. Configure the "twig" section provided by the Twig Bundle instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2896 +count: 2 -severity: E_USER_DEPRECATED : { { Symfony\Component\Config\Definition\ArrayNode->finalizeValue($value) … › { { Symfony\Component\Config\Definition\ArrayNode->finalizeValue($value) … › |
|
n/a |
Enabling the Templating component is deprecated since version 4.3 and will be removed in 5.0; use Twig instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2899 +count: 1 -severity: E_USER_DEPRECATED : { { Symfony\Bundle\FrameworkBundle\DependencyInjection\FrameworkExtension->load(array $configs, ContainerBuilder $container) … › { { Symfony\Bundle\FrameworkBundle\DependencyInjection\FrameworkExtension->load(array $configs, ContainerBuilder $container) … › |
|
n/a (2 times) |
The "twig.exception_controller" configuration key has been deprecated in Symfony 4.4, set it to "null" and use "framework.error_controller" configuration key instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2898 +count: 2 -severity: E_USER_DEPRECATED : { { Symfony\Bundle\TwigBundle\DependencyInjection\Configuration::Symfony\Bundle\TwigBundle\DependencyInjection\{closure} … › { { Symfony\Bundle\TwigBundle\DependencyInjection\Configuration::Symfony\Bundle\TwigBundle\DependencyInjection\{closure} … › |
|
n/a |
Loading Twig templates from the "/var/www/html/applications/honeybee_main/app/Resources/views" directory is deprecated since Symfony 4.2, use "/var/www/html/applications/honeybee_main/templates" instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2900 +count: 1 -severity: E_USER_DEPRECATED : { { Symfony\Bundle\TwigBundle\DependencyInjection\TwigExtension->load(array $configs, ContainerBuilder $container) … › { { Symfony\Bundle\TwigBundle\DependencyInjection\TwigExtension->load(array $configs, ContainerBuilder $container) … › |
|
n/a |
The Doctrine\Common\Persistence\ObjectManager class is deprecated since doctrine/persistence 1.3 and will be removed in 2.0. Use \Doctrine\Persistence\ObjectManager instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2901 +count: 1 -severity: E_USER_DEPRECATED : { { spl_autoload_call($class_name) … › { { spl_autoload_call($class_name) … › |
|
n/a |
The Doctrine\Common\PropertyChangedListener class is deprecated since doctrine/persistence 1.3 and will be removed in 2.0. Use \Doctrine\Persistence\PropertyChangedListener instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2902 +count: 1 -severity: E_USER_DEPRECATED : { { spl_autoload_call($class_name) … › { { spl_autoload_call($class_name) … › |
|
n/a |
The "Symfony\Bundle\FrameworkBundle\Command\ContainerAwareCommand" class is deprecated since Symfony 4.2, use "Symfony\Component\Console\Command\Command" with dependency injection instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2903 +count: 1 -severity: E_USER_DEPRECATED : { { spl_autoload_call($class_name) … › › { { spl_autoload_call($class_name) … › › |
|
n/a |
The "ApplicationBundle\Command\ScheduledBigRowEntryCommand" class extends "Symfony\Bundle\FrameworkBundle\Command\ContainerAwareCommand" that is deprecated since Symfony 4.2, use {@see Command} instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2904 +count: 1 -severity: E_USER_DEPRECATED : { { spl_autoload_call($class_name) … › { { spl_autoload_call($class_name) … › |
|
n/a |
The "ApplicationBundle\Command\ScheduledNotificationCommand" class extends "Symfony\Bundle\FrameworkBundle\Command\ContainerAwareCommand" that is deprecated since Symfony 4.2, use {@see Command} instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2905 +count: 1 -severity: E_USER_DEPRECATED : { { spl_autoload_call($class_name) … › { { spl_autoload_call($class_name) … › |
|
n/a |
The "ApplicationBundle\Command\BuddybeeScheduleMissingCheckCommand" class extends "Symfony\Bundle\FrameworkBundle\Command\ContainerAwareCommand" that is deprecated since Symfony 4.2, use {@see Command} instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2906 +count: 1 -severity: E_USER_DEPRECATED : { { spl_autoload_call($class_name) … › { { spl_autoload_call($class_name) … › |
|
n/a |
The "ApplicationBundle\Command\DailyUserReportBuddyBeeCommand" class extends "Symfony\Bundle\FrameworkBundle\Command\ContainerAwareCommand" that is deprecated since Symfony 4.2, use {@see Command} instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2907 +count: 1 -severity: E_USER_DEPRECATED : { { spl_autoload_call($class_name) … › { { spl_autoload_call($class_name) … › |
|
n/a |
The "ApplicationBundle\Command\FixedAssetSchedulerActionCommand" class extends "Symfony\Bundle\FrameworkBundle\Command\ContainerAwareCommand" that is deprecated since Symfony 4.2, use {@see Command} instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2908 +count: 1 -severity: E_USER_DEPRECATED : { { spl_autoload_call($class_name) … › { { spl_autoload_call($class_name) … › |
|
n/a |
Using the "Twig_Extension_GlobalsInterface" class is deprecated since Twig version 2.7, use "Twig\Extension\GlobalsInterface" instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2909 +count: 1 -severity: E_USER_DEPRECATED : { { spl_autoload_call($class_name) … › › { { spl_autoload_call($class_name) … › › |
|
n/a |
The Symfony\Bundle\TwigBundle\CacheWarmer\TemplateCacheCacheWarmer class is deprecated since version 4.4 and will be removed in 5.0; use Twig instead.
[
"exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2910
+count: 1
-severity: E_USER_DEPRECATED
: {
{
spl_autoload_call($class_name) …
›
›
|
|
n/a |
The "Symfony\Component\HttpKernel\EventListener\ExceptionListener" class is deprecated since Symfony 4.4, use "ErrorListener" instead.
[
"exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2911
+count: 1
-severity: E_USER_DEPRECATED
: {
{
spl_autoload_call($class_name) …
›
›
|
|
n/a |
The "templating.cache_warmer.template_paths" service is deprecated since Symfony 4.3 and will be removed in 5.0.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2912 +count: 1 -severity: E_USER_DEPRECATED : { { require … › › { { require … › › |
|
n/a |
The Symfony\Bundle\FrameworkBundle\CacheWarmer\TemplatePathsCacheWarmer class is deprecated since version 4.3 and will be removed in 5.0; use Twig instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2913 +count: 1 -severity: E_USER_DEPRECATED : { { include … › › { { include … › › |
|
n/a |
The "templating.finder" service is deprecated since Symfony 4.3 and will be removed in 5.0.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2914 +count: 1 -severity: E_USER_DEPRECATED : { { require … › › { { require … › › |
|
n/a |
The Symfony\Bundle\FrameworkBundle\CacheWarmer\TemplateFinder class is deprecated since version 4.3 and will be removed in 5.0; use Twig instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2915 +count: 1 -severity: E_USER_DEPRECATED : { { include … › › { { include … › › |
|
n/a |
The Symfony\Bundle\FrameworkBundle\CacheWarmer\TemplateFinderInterface interface is deprecated since version 4.3 and will be removed in 5.0; use Twig instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2916 +count: 1 -severity: E_USER_DEPRECATED : { { include … › › { { include … › › |
|
n/a |
The Symfony\Bundle\FrameworkBundle\Templating\TemplateFilenameParser class is deprecated since version 4.3 and will be removed in 5.0; use Twig instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2917 +count: 1 -severity: E_USER_DEPRECATED : { { include … › › { { include … › › |
|
n/a |
The "templating.locator" service is deprecated since Symfony 4.3 and will be removed in 5.0.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2918 +count: 1 -severity: E_USER_DEPRECATED : { { require … › › { { require … › › |
|
n/a |
The Symfony\Bundle\FrameworkBundle\Templating\Loader\TemplateLocator class is deprecated since version 4.3 and will be removed in 5.0; use Twig instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2919 +count: 1 -severity: E_USER_DEPRECATED : { { include … › › { { include … › › |
|
n/a |
The "twig.cache_warmer" service is deprecated since Symfony 4.4 and will be removed in 5.0.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2920 +count: 1 -severity: E_USER_DEPRECATED : { { require … › › { { require … › › |
|
n/a |
The Doctrine\Common\Persistence\Mapping\Driver\MappingDriverChain class is deprecated since doctrine/persistence 1.3 and will be removed in 2.0. Use \Doctrine\Persistence\Mapping\Driver\MappingDriverChain instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2921 +count: 1 -severity: E_USER_DEPRECATED : { { include … › { { include … › |
|
n/a |
The Doctrine\Common\Persistence\Mapping\Driver\FileDriver class is deprecated since doctrine/persistence 1.3 and will be removed in 2.0. Use \Doctrine\Persistence\Mapping\Driver\FileDriver instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2922 +count: 1 -severity: E_USER_DEPRECATED : { { include … › { { include … › |
|
n/a |
The Doctrine\Common\Persistence\Mapping\Driver\SymfonyFileLocator class is deprecated since doctrine/persistence 1.3 and will be removed in 2.0. Use \Doctrine\Persistence\Mapping\Driver\SymfonyFileLocator instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2923 +count: 1 -severity: E_USER_DEPRECATED : { { include … › { { include … › |
|
n/a (2 times) |
YAML mapping driver is deprecated and will be removed in Doctrine ORM 3.0, please migrate to annotation or XML driver.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2924 +count: 2 -severity: E_USER_DEPRECATED : { { Doctrine\ORM\Mapping\Driver\YamlDriver->__construct($locator, $fileExtension = self::DEFAULT_FILE_EXTENSION) … › { { Doctrine\ORM\Mapping\Driver\YamlDriver->__construct($locator, $fileExtension = self::DEFAULT_FILE_EXTENSION) … › |
|
n/a |
The Doctrine\Common\Persistence\ObjectRepository class is deprecated since doctrine/persistence 1.3 and will be removed in 2.0. Use \Doctrine\Persistence\ObjectRepository instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2925 +count: 1 -severity: E_USER_DEPRECATED : { { include … › { { include … › |
|
n/a |
Creating Doctrine\ORM\Mapping\UnderscoreNamingStrategy without making it number aware is deprecated and will be removed in Doctrine ORM 3.0.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2926 +count: 1 -severity: E_USER_DEPRECATED : { { Doctrine\ORM\Mapping\UnderscoreNamingStrategy->__construct($case = CASE_LOWER, bool $numberAware = false) … › { { Doctrine\ORM\Mapping\UnderscoreNamingStrategy->__construct($case = CASE_LOWER, bool $numberAware = false) … › |
|
n/a |
The Doctrine\Common\Persistence\Mapping\AbstractClassMetadataFactory class is deprecated since doctrine/persistence 1.3 and will be removed in 2.0. Use \Doctrine\Persistence\Mapping\AbstractClassMetadataFactory instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2927 +count: 1 -severity: E_USER_DEPRECATED : { { include … › { { include … › |
|
n/a |
The Doctrine\Common\Persistence\Mapping\RuntimeReflectionService class is deprecated since doctrine/persistence 1.3 and will be removed in 2.0. Use \Doctrine\Persistence\Mapping\RuntimeReflectionService instead.
[ "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2928 +count: 1 -severity: E_USER_DEPRECATED : { { include … › { { include … › |
Debug 81
Unimportant log messages generated during the execution of the application.
Time | Channel | Message |
---|---|---|
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\FragmentListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\FragmentListener::onKernelRequest" ] |
|
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\Bundle\FrameworkBundle\EventListener\ResolveControllerNameSubscriber::resolveControllerName" .
[ "event" => "kernel.request" "listener" => "Symfony\Bundle\FrameworkBundle\EventListener\ResolveControllerNameSubscriber::resolveControllerName" ] |
|
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\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 "ApplicationBundle\Listener\SessionListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "ApplicationBundle\Listener\SessionListener::onKernelController" ] |
|
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 "Nzo\UrlEncryptorBundle\Annotations\AnnotationResolver::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Nzo\UrlEncryptorBundle\Annotations\AnnotationResolver::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController" ] |
|
doctrine |
SELECT t0.id AS id_1, t0.data AS data_2, t0.user_id AS user_id_3, t0.company_id AS company_id_4, t0.default_box_flag AS default_box_flag_5, t0.all_dashboard_flag AS all_dashboard_flag_6, t0.sequence AS sequence_7, t0.status AS status_8, t0.size_tiny AS size_tiny_9, t0.size_small AS size_small_10, t0.size_medium AS size_medium_11, t0.size_large AS size_large_12, t0.refresh_interval AS refresh_interval_13, t0.route_names AS route_names_14 FROM dashboard_widget t0 WHERE t0.company_id = ? AND t0.user_id = ? AND t0.status = ? ORDER BY t0.sequence ASC
[ 1 "27" true ] |
|
doctrine |
SELECT t0.id AS id_1, t0.data AS data_2, t0.user_id AS user_id_3, t0.company_id AS company_id_4, t0.default_box_flag AS default_box_flag_5, t0.all_dashboard_flag AS all_dashboard_flag_6, t0.sequence AS sequence_7, t0.status AS status_8, t0.size_tiny AS size_tiny_9, t0.size_small AS size_small_10, t0.size_medium AS size_medium_11, t0.size_large AS size_large_12, t0.refresh_interval AS refresh_interval_13, t0.route_names AS route_names_14 FROM dashboard_widget t0 WHERE t0.company_id = ? AND t0.default_box_flag = ? AND t0.status = ? ORDER BY t0.sequence ASC
[ 1 1 true ] |
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.app_id AS app_id_4, t0.country_id AS country_id_5, t0.company_hash AS company_hash_6, t0.company_unique_code AS company_unique_code_7, t0.enabled_module_id_list AS enabled_module_id_list_8, t0.company_type AS company_type_9, t0.usage_valid_upto_date AS usage_valid_upto_date_10, t0.post_dated_job_active AS post_dated_job_active_11, t0.address AS address_12, t0.shipping_address AS shipping_address_13, t0.sms_notification_enabled AS sms_notification_enabled_14, t0.sms_settings AS sms_settings_15, t0.lock_device_id_on_first_login_user AS lock_device_id_on_first_login_user_16, t0.lock_device_id_on_first_login_supplier AS lock_device_id_on_first_login_supplier_17, t0.lock_device_id_on_first_login_client AS lock_device_id_on_first_login_client_18, t0.dark_vibrant AS dark_vibrant_19, t0.light_vibrant AS light_vibrant_20, t0.vibrant AS vibrant_21, t0.billing_address AS billing_address_22, t0.motto AS motto_23, t0.invoice_footer AS invoice_footer_24, t0.general_footer AS general_footer_25, t0.company_bin AS company_bin_26, t0.company_tin AS company_tin_27, t0.company_reg AS company_reg_28, t0.company_tl AS company_tl_29, t0.user_allowed AS user_allowed_30, t0.user_allocated AS user_allocated_31, t0.user_remaining AS user_remaining_32, t0.me_str AS me_str_33, t0.cash AS cash_34, t0.bank AS bank_35, t0.sales AS sales_36, t0.asset AS asset_37, t0.liability AS liability_38, t0.expense AS expense_39, t0.revenue AS revenue_40, t0.payable AS payable_41, t0.receivable AS receivable_42, t0.net_worth AS net_worth_43, t0.monthly_growth AS monthly_growth_44, t0.wacc AS wacc_45, t0.active AS active_46, t0.created_at AS created_at_47, t0.updated_at AS updated_at_48, t0.doc_booked_flag AS doc_booked_flag_49, t0.time_stamp_of_form AS time_stamp_of_form_50 FROM company t0 WHERE t0.active = ? AND t0.id = ? LIMIT 1
[ true 1 ] |
|
doctrine |
SELECT t0.id AS id_1, t0.date AS date_2, t0.cash AS cash_3, t0.bank AS bank_4, t0.cash_position AS cash_position_5, t0.bank_position AS bank_position_6, t0.asset AS asset_7, t0.liability AS liability_8, t0.asset_position AS asset_position_9, t0.liability_position AS liability_position_10, t0.revenue AS revenue_11, t0.expense AS expense_12, t0.revenue_position AS revenue_position_13, t0.expense_position AS expense_position_14, t0.receivable AS receivable_15, t0.payable AS payable_16, t0.receivable_position AS receivable_position_17, t0.payable_position AS payable_position_18, t0.loan AS loan_19, t0.net_worth AS net_worth_20, t0.monthly_growth AS monthly_growth_21, t0.company_id AS company_id_22, t0.branch_id AS branch_id_23 FROM monthly_summary t0 WHERE t0.company_id = ? AND (t0.branch_id IN (?) OR t0.branch_id IS NULL) ORDER BY t0.date DESC LIMIT 11
[ 1 [ null 0 ] ] |
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.app_id AS app_id_4, t0.country_id AS country_id_5, t0.company_hash AS company_hash_6, t0.company_unique_code AS company_unique_code_7, t0.enabled_module_id_list AS enabled_module_id_list_8, t0.company_type AS company_type_9, t0.usage_valid_upto_date AS usage_valid_upto_date_10, t0.post_dated_job_active AS post_dated_job_active_11, t0.address AS address_12, t0.shipping_address AS shipping_address_13, t0.sms_notification_enabled AS sms_notification_enabled_14, t0.sms_settings AS sms_settings_15, t0.lock_device_id_on_first_login_user AS lock_device_id_on_first_login_user_16, t0.lock_device_id_on_first_login_supplier AS lock_device_id_on_first_login_supplier_17, t0.lock_device_id_on_first_login_client AS lock_device_id_on_first_login_client_18, t0.dark_vibrant AS dark_vibrant_19, t0.light_vibrant AS light_vibrant_20, t0.vibrant AS vibrant_21, t0.billing_address AS billing_address_22, t0.motto AS motto_23, t0.invoice_footer AS invoice_footer_24, t0.general_footer AS general_footer_25, t0.company_bin AS company_bin_26, t0.company_tin AS company_tin_27, t0.company_reg AS company_reg_28, t0.company_tl AS company_tl_29, t0.user_allowed AS user_allowed_30, t0.user_allocated AS user_allocated_31, t0.user_remaining AS user_remaining_32, t0.me_str AS me_str_33, t0.cash AS cash_34, t0.bank AS bank_35, t0.sales AS sales_36, t0.asset AS asset_37, t0.liability AS liability_38, t0.expense AS expense_39, t0.revenue AS revenue_40, t0.payable AS payable_41, t0.receivable AS receivable_42, t0.net_worth AS net_worth_43, t0.monthly_growth AS monthly_growth_44, t0.wacc AS wacc_45, t0.active AS active_46, t0.created_at AS created_at_47, t0.updated_at AS updated_at_48, t0.doc_booked_flag AS doc_booked_flag_49, t0.time_stamp_of_form AS time_stamp_of_form_50 FROM company t0 WHERE t0.active = ? AND t0.id = ? LIMIT 1
[ true 1 ] |
|
doctrine |
SELECT t0.accounts_head_id AS accounts_head_id_1, t0.parent_id AS parent_id_2, t0.replication_head_id AS replication_head_id_3, t0.replicate AS replicate_4, t0.advance_tagged AS advance_tagged_5, t0.advance_of AS advance_of_6, t0.name AS name_7, t0.narration_on_check AS narration_on_check_8, t0.path_tree AS path_tree_9, t0.head_level AS head_level_10, t0.type AS type_11, t0.head_nature AS head_nature_12, t0.cc_enabled AS cc_enabled_13, t0.opening_balance AS opening_balance_14, t0.current_balance AS current_balance_15, t0.current_balance_reconciled AS current_balance_reconciled_16, t0.marker_hash AS marker_hash_17, t0.cost_centre_types AS cost_centre_types_18, t0.company_id AS company_id_19, t0.ledger_head_code AS ledger_head_code_20, t0.edit_flag AS edit_flag_21, t0.delete_flag AS delete_flag_22, t0.lock_flag AS lock_flag_23, t0.refresh_flag AS refresh_flag_24, t0.disabled_flag AS disabled_flag_25, t0.create_login_id AS create_login_id_26, t0.edit_login_id AS edit_login_id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29 FROM acc_accounts_head t0 WHERE (t0.parent_id IN (?) OR t0.parent_id IS NULL) AND t0.company_id = ?
[ [ 0 null ] 1 ] |
|
doctrine | SELECT DISTINCT acc_accounts_head.parent_id FROM acc_accounts_head WHERE 1 | |
doctrine | select * from fiscal_closing where closing_end_date < '2024-11-01 00:00:00' Order by closing_end_date desc limit 1 | |
doctrine | SELECT t0.accounts_head_id AS accounts_head_id_1, t0.parent_id AS parent_id_2, t0.replication_head_id AS replication_head_id_3, t0.replicate AS replicate_4, t0.advance_tagged AS advance_tagged_5, t0.advance_of AS advance_of_6, t0.name AS name_7, t0.narration_on_check AS narration_on_check_8, t0.path_tree AS path_tree_9, t0.head_level AS head_level_10, t0.type AS type_11, t0.head_nature AS head_nature_12, t0.cc_enabled AS cc_enabled_13, t0.opening_balance AS opening_balance_14, t0.current_balance AS current_balance_15, t0.current_balance_reconciled AS current_balance_reconciled_16, t0.marker_hash AS marker_hash_17, t0.cost_centre_types AS cost_centre_types_18, t0.company_id AS company_id_19, t0.ledger_head_code AS ledger_head_code_20, t0.edit_flag AS edit_flag_21, t0.delete_flag AS delete_flag_22, t0.lock_flag AS lock_flag_23, t0.refresh_flag AS refresh_flag_24, t0.disabled_flag AS disabled_flag_25, t0.create_login_id AS create_login_id_26, t0.edit_login_id AS edit_login_id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29 FROM acc_accounts_head t0 | |
doctrine | select * from acc_accounts_head left outer join (select accounts_head_id opening_head_id, SUM(CASE WHEN position = 'dr' THEN amount ELSE 0 END) opening_balance_debit, SUM(CASE WHEN position = 'cr' THEN amount ELSE 0 END) opening_balance_credit from acc_transaction_details where acc_transaction_details.approved = 1 AND acc_transaction_details.ledger_hit=1 AND acc_transaction_details.ledger_hit_date < '2024-11-01 00:00:00' GROUP BY accounts_head_id) opening_add_table on opening_add_table.opening_head_id =acc_accounts_head.accounts_head_id left outer join (select accounts_head_id dur_head_id, SUM(CASE WHEN position = 'dr' THEN amount ELSE 0 END) dur_balance_debit, SUM(CASE WHEN position = 'cr' THEN amount ELSE 0 END) dur_balance_credit from acc_transaction_details where acc_transaction_details.approved = 1 AND acc_transaction_details.ledger_hit=1 AND acc_transaction_details.ledger_hit_date >= '2024-11-01' AND acc_transaction_details.ledger_hit_date <= '2024-11-01 23:59:59.999' GROUP BY accounts_head_id) dur_balance_table on dur_balance_table.dur_head_id =acc_accounts_head.accounts_head_id where acc_accounts_head.accounts_head_id not in(0,1,3,94,95,4,5,89,90,110,99,100,101,102,103,104,105,106,107,108,139,109,112,176,177,96,114,204,129,130,121,123,234,236,235,245,241,246,243,242,244,117,337,132,680,225,892,1122,180,1139,1110,134,170,118,227,181,205,956,111,340,1310,119,1352,907,115,228,131,120,1420,1423) AND acc_accounts_head.type ='exp' | |
doctrine | SELECT DISTINCT acc_accounts_head.parent_id FROM acc_accounts_head WHERE 1 | |
doctrine | select * from fiscal_closing where closing_end_date < '2024-10-01 00:00:00' Order by closing_end_date desc limit 1 | |
doctrine | SELECT t0.accounts_head_id AS accounts_head_id_1, t0.parent_id AS parent_id_2, t0.replication_head_id AS replication_head_id_3, t0.replicate AS replicate_4, t0.advance_tagged AS advance_tagged_5, t0.advance_of AS advance_of_6, t0.name AS name_7, t0.narration_on_check AS narration_on_check_8, t0.path_tree AS path_tree_9, t0.head_level AS head_level_10, t0.type AS type_11, t0.head_nature AS head_nature_12, t0.cc_enabled AS cc_enabled_13, t0.opening_balance AS opening_balance_14, t0.current_balance AS current_balance_15, t0.current_balance_reconciled AS current_balance_reconciled_16, t0.marker_hash AS marker_hash_17, t0.cost_centre_types AS cost_centre_types_18, t0.company_id AS company_id_19, t0.ledger_head_code AS ledger_head_code_20, t0.edit_flag AS edit_flag_21, t0.delete_flag AS delete_flag_22, t0.lock_flag AS lock_flag_23, t0.refresh_flag AS refresh_flag_24, t0.disabled_flag AS disabled_flag_25, t0.create_login_id AS create_login_id_26, t0.edit_login_id AS edit_login_id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29 FROM acc_accounts_head t0 | |
doctrine | select * from acc_accounts_head left outer join (select accounts_head_id opening_head_id, SUM(CASE WHEN position = 'dr' THEN amount ELSE 0 END) opening_balance_debit, SUM(CASE WHEN position = 'cr' THEN amount ELSE 0 END) opening_balance_credit from acc_transaction_details where acc_transaction_details.approved = 1 AND acc_transaction_details.ledger_hit=1 AND acc_transaction_details.ledger_hit_date < '2024-10-01 00:00:00' GROUP BY accounts_head_id) opening_add_table on opening_add_table.opening_head_id =acc_accounts_head.accounts_head_id left outer join (select accounts_head_id dur_head_id, SUM(CASE WHEN position = 'dr' THEN amount ELSE 0 END) dur_balance_debit, SUM(CASE WHEN position = 'cr' THEN amount ELSE 0 END) dur_balance_credit from acc_transaction_details where acc_transaction_details.approved = 1 AND acc_transaction_details.ledger_hit=1 AND acc_transaction_details.ledger_hit_date >= '2024-10-01' AND acc_transaction_details.ledger_hit_date <= '2024-10-31 23:59:59.999' GROUP BY accounts_head_id) dur_balance_table on dur_balance_table.dur_head_id =acc_accounts_head.accounts_head_id where acc_accounts_head.accounts_head_id not in(0,1,3,94,95,4,5,89,90,110,99,100,101,102,103,104,105,106,107,108,139,109,112,176,177,96,114,204,129,130,121,123,234,236,235,245,241,246,243,242,244,117,337,132,680,225,892,1122,180,1139,1110,134,170,118,227,181,205,956,111,340,1310,119,1352,907,115,228,131,120,1420,1423) AND acc_accounts_head.type ='exp' | |
doctrine | SELECT DISTINCT acc_accounts_head.parent_id FROM acc_accounts_head WHERE 1 | |
doctrine | select * from fiscal_closing where closing_end_date < '2024-09-01 00:00:00' Order by closing_end_date desc limit 1 | |
doctrine | SELECT t0.accounts_head_id AS accounts_head_id_1, t0.parent_id AS parent_id_2, t0.replication_head_id AS replication_head_id_3, t0.replicate AS replicate_4, t0.advance_tagged AS advance_tagged_5, t0.advance_of AS advance_of_6, t0.name AS name_7, t0.narration_on_check AS narration_on_check_8, t0.path_tree AS path_tree_9, t0.head_level AS head_level_10, t0.type AS type_11, t0.head_nature AS head_nature_12, t0.cc_enabled AS cc_enabled_13, t0.opening_balance AS opening_balance_14, t0.current_balance AS current_balance_15, t0.current_balance_reconciled AS current_balance_reconciled_16, t0.marker_hash AS marker_hash_17, t0.cost_centre_types AS cost_centre_types_18, t0.company_id AS company_id_19, t0.ledger_head_code AS ledger_head_code_20, t0.edit_flag AS edit_flag_21, t0.delete_flag AS delete_flag_22, t0.lock_flag AS lock_flag_23, t0.refresh_flag AS refresh_flag_24, t0.disabled_flag AS disabled_flag_25, t0.create_login_id AS create_login_id_26, t0.edit_login_id AS edit_login_id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29 FROM acc_accounts_head t0 | |
doctrine | select * from acc_accounts_head left outer join (select accounts_head_id opening_head_id, SUM(CASE WHEN position = 'dr' THEN amount ELSE 0 END) opening_balance_debit, SUM(CASE WHEN position = 'cr' THEN amount ELSE 0 END) opening_balance_credit from acc_transaction_details where acc_transaction_details.approved = 1 AND acc_transaction_details.ledger_hit=1 AND acc_transaction_details.ledger_hit_date < '2024-09-01 00:00:00' GROUP BY accounts_head_id) opening_add_table on opening_add_table.opening_head_id =acc_accounts_head.accounts_head_id left outer join (select accounts_head_id dur_head_id, SUM(CASE WHEN position = 'dr' THEN amount ELSE 0 END) dur_balance_debit, SUM(CASE WHEN position = 'cr' THEN amount ELSE 0 END) dur_balance_credit from acc_transaction_details where acc_transaction_details.approved = 1 AND acc_transaction_details.ledger_hit=1 AND acc_transaction_details.ledger_hit_date >= '2024-09-01' AND acc_transaction_details.ledger_hit_date <= '2024-09-30 23:59:59.999' GROUP BY accounts_head_id) dur_balance_table on dur_balance_table.dur_head_id =acc_accounts_head.accounts_head_id where acc_accounts_head.accounts_head_id not in(0,1,3,94,95,4,5,89,90,110,99,100,101,102,103,104,105,106,107,108,139,109,112,176,177,96,114,204,129,130,121,123,234,236,235,245,241,246,243,242,244,117,337,132,680,225,892,1122,180,1139,1110,134,170,118,227,181,205,956,111,340,1310,119,1352,907,115,228,131,120,1420,1423) AND acc_accounts_head.type ='exp' | |
doctrine | SELECT count(sales_order.sales_order_id) so_count FROM sales_order WHERE sales_order.status=1 AND sales_order.approved=1 AND sales_order.company_id=1 | |
doctrine | SELECT count(sales_order.sales_order_id) so_count, sum(sales_order.so_amount) so_amount, sales_order.sales_order_date FROM sales_order WHERE sales_order.status=1 AND sales_order.approved=1 AND sales_order.company_id=1 GROUP BY sales_order.sales_order_date ORDER BY sales_order.sales_order_date DESC limit 100 | |
doctrine | SELECT sales_order.*, acc_clients.* FROM sales_order JOIN acc_clients on acc_clients.client_id= sales_order.client_id WHERE sales_order.status=1 AND sales_order.approved=1 AND sales_order.company_id=1 ORDER BY sales_order.sales_order_date DESC, sales_order.so_amount DESC LIMIT 5 | |
doctrine |
SELECT t0.system_notice AS system_notice_1, t0.title AS title_2, t0.descrption AS descrption_3, t0.data AS data_4, t0.enabled AS enabled_5, t0.show_as_notification AS show_as_notification_6, t0.trigger_logout AS trigger_logout_7, t0.trigger_logout_delay AS trigger_logout_delay_8, t0.skip_user_ids AS skip_user_ids_9, t0.notification_type AS notification_type_10, t0.company_id AS company_id_11, t0.app_id AS app_id_12, t0.create_login_id AS create_login_id_13, t0.edit_login_id AS edit_login_id_14, t0.count_down_ends AS count_down_ends_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.doc_booked_flag AS doc_booked_flag_18, t0.time_stamp_of_form AS time_stamp_of_form_19 FROM system_notice t0 WHERE t0.enabled = ? AND t0.show_as_notification = ? LIMIT 1
[ true true ] |
|
doctrine |
SELECT t0.supplier_id AS supplier_id_1, t0.device_id AS device_id_2, t0.device_id_locked_flag AS device_id_locked_flag_3, t0.lock_device_id_on_next_login_flag AS lock_device_id_on_next_login_flag_4, t0.username AS username_5, t0.password AS password_6, t0.app_id AS app_id_7, t0.global_user_id AS global_user_id_8, t0.email_verification_hash AS email_verification_hash_9, t0.phone_verification_hash AS phone_verification_hash_10, t0.otp_action_id AS otp_action_id_11, t0.otp AS otp_12, t0.otp_expire_ts AS otp_expire_ts_13, t0.trigger_reset_password AS trigger_reset_password_14, t0.forgot_password_token AS forgot_password_token_15, t0.forgot_password_token_expire_ts AS forgot_password_token_expire_ts_16, t0.is_email_verified AS is_email_verified_17, t0.is_phone_verified AS is_phone_verified_18, t0.is_banned AS is_banned_19, t0.ban_expires AS ban_expires_20, t0.strike_count AS strike_count_21, t0.strike_threshold AS strike_threshold_22, t0.account_status AS account_status_23, t0.accounts_head_id AS accounts_head_id_24, t0.image AS image_25, t0.provision_flag AS provision_flag_26, t0.advance_head_id AS advance_head_id_27, t0.representative_emails AS representative_emails_28, t0.representative_emails_data AS representative_emails_data_29, t0.head_addition_pending_flag AS head_addition_pending_flag_30, t0.company_id AS company_id_31, t0.supplier_name AS supplier_name_32, t0.supplier_short_code AS supplier_short_code_33, t0.category AS category_34, t0.type AS type_35, t0.supplier_paid AS supplier_paid_36, t0.supplier_due AS supplier_due_37, t0.initial_opening_balance AS initial_opening_balance_38, t0.supplier_address AS supplier_address_39, t0.factory_address AS factory_address_40, t0.tagged_item_groups AS tagged_item_groups_41, t0.credit_limit AS credit_limit_42, t0.contact_person AS contact_person_43, t0.contact_number AS contact_number_44, t0.email AS email_45, t0.fax AS fax_46, t0.is_individual AS is_individual_47, t0.general_info_tin AS general_info_tin_48, t0.general_info_bin AS general_info_bin_49, t0.general_info_bank_name AS general_info_bank_name_50, t0.general_info_bank_ac_name AS general_info_bank_ac_name_51, t0.general_info_bank_ac_number AS general_info_bank_ac_number_52, t0.date_of_addition AS date_of_addition_53, t0.edit_login_id AS edit_login_id_54, t0.create_login_id AS create_login_id_55, t0.status AS status_56, t0.last_settings_updated_ts AS last_settings_updated_ts_57, t0.created_at AS created_at_58, t0.updated_at AS updated_at_59, t0.doc_booked_flag AS doc_booked_flag_60, t0.time_stamp_of_form AS time_stamp_of_form_61 FROM acc_suppliers t0 WHERE t0.status = ?
[
true
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.data AS data_3, t0.company_id AS company_id_4, t0.create_login_id AS create_login_id_5, t0.edit_login_id AS edit_login_id_6, t0.lock_flag AS lock_flag_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.doc_booked_flag AS doc_booked_flag_10, t0.time_stamp_of_form AS time_stamp_of_form_11 FROM acc_setting t0 WHERE t0.name = ? LIMIT 1
[
"payment_voucher_credit_parents"
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.data AS data_3, t0.company_id AS company_id_4, t0.create_login_id AS create_login_id_5, t0.edit_login_id AS edit_login_id_6, t0.lock_flag AS lock_flag_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.doc_booked_flag AS doc_booked_flag_10, t0.time_stamp_of_form AS time_stamp_of_form_11 FROM acc_setting t0 WHERE t0.name = ? LIMIT 1
[
"payment_voucher_debit_parents"
]
|
|
doctrine | SELECT DISTINCT acc_accounts_head.parent_id FROM acc_accounts_head where company_id=1 | |
doctrine | SELECT acc_accounts_head.name, acc_accounts_head.opening_balance, acc_accounts_head.current_balance, acc_accounts_head.current_balance_reconciled, acc_accounts_head.path_tree, acc_accounts_head.head_nature, acc_accounts_head.cc_enabled, acc_accounts_head.accounts_head_id, acc_accounts_head.parent_id, acc_accounts_head.type, acc_accounts_head.advance_of, b.name parent_name FROM acc_accounts_head left join acc_accounts_head as b on acc_accounts_head.parent_id=b.accounts_head_id WHERE acc_accounts_head.company_id=1 AND acc_accounts_head.parent_id !=0 AND acc_accounts_head.accounts_head_id NOT IN (0,1,3,94,95,4,5,89,90,110,99,100,101,102,103,104,105,106,107,108,139,109,112,176,177,96,114,204,129,130,121,123,234,236,235,245,241,246,243,242,244,117,337,132,680,225,892,1122,180,1139,1110,134,170,118,227,181,205,956,111,340,1310,119,1352,907,115,228,131,120,1420,1423) ORDER BY name ASC | |
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.data AS data_3, t0.company_id AS company_id_4, t0.create_login_id AS create_login_id_5, t0.edit_login_id AS edit_login_id_6, t0.lock_flag AS lock_flag_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.doc_booked_flag AS doc_booked_flag_10, t0.time_stamp_of_form AS time_stamp_of_form_11 FROM acc_setting t0 WHERE t0.name = ? LIMIT 1
[
"payment_voucher_credit_parents"
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.data AS data_3, t0.company_id AS company_id_4, t0.create_login_id AS create_login_id_5, t0.edit_login_id AS edit_login_id_6, t0.lock_flag AS lock_flag_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.doc_booked_flag AS doc_booked_flag_10, t0.time_stamp_of_form AS time_stamp_of_form_11 FROM acc_setting t0 WHERE t0.name = ? LIMIT 1
[
"payment_voucher_debit_parents"
]
|
|
doctrine | SELECT DISTINCT acc_accounts_head.parent_id FROM acc_accounts_head where company_id=1 | |
doctrine | SELECT acc_accounts_head.name, acc_accounts_head.opening_balance, acc_accounts_head.current_balance, acc_accounts_head.current_balance_reconciled, acc_accounts_head.path_tree, acc_accounts_head.head_nature, acc_accounts_head.cc_enabled, acc_accounts_head.accounts_head_id, acc_accounts_head.parent_id, acc_accounts_head.type, acc_accounts_head.advance_of, b.name parent_name FROM acc_accounts_head left join acc_accounts_head as b on acc_accounts_head.parent_id=b.accounts_head_id WHERE acc_accounts_head.company_id=1 AND acc_accounts_head.parent_id !=0 AND acc_accounts_head.accounts_head_id NOT IN (0,1,3,94,95,4,5,89,90,110,99,100,101,102,103,104,105,106,107,108,139,109,112,176,177,96,114,204,129,130,121,123,234,236,235,245,241,246,243,242,244,117,337,132,680,225,892,1122,180,1139,1110,134,170,118,227,181,205,956,111,340,1310,119,1352,907,115,228,131,120,1420,1423) ORDER BY name ASC | |
doctrine |
SELECT t0.check_id AS check_id_1, t0.accounts_head_id AS accounts_head_id_2, t0.voucher_id AS voucher_id_3, t0.rec_accounts_head_id AS rec_accounts_head_id_4, t0.rec_accounts_head_id_list AS rec_accounts_head_id_list_5, t0.acc_number AS acc_number_6, t0.check_number AS check_number_7, t0.check_book_number AS check_book_number_8, t0.check_narration AS check_narration_9, t0.check_amount AS check_amount_10, t0.active AS active_11, t0.status AS status_12, t0.assigned AS assigned_13, t0.printed AS printed_14, t0.security_check AS security_check_15, t0.destroyed AS destroyed_16, t0.type AS type_17, t0.details AS details_18, t0.assigned_date AS assigned_date_19, t0.recon_date AS recon_date_20, t0.check_date AS check_date_21, t0.transaction_date AS transaction_date_22, t0.ledger_hit_date AS ledger_hit_date_23, t0.format_id AS format_id_24, t0.company_id AS company_id_25, t0.create_login_id AS create_login_id_26, t0.edit_login_id AS edit_login_id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.doc_booked_flag AS doc_booked_flag_30, t0.time_stamp_of_form AS time_stamp_of_form_31 FROM acc_check t0 WHERE t0.assigned = ? ORDER BY t0.accounts_head_id DESC, t0.check_number DESC
[
0
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.module_ids AS module_ids_3, t0.warehouse_ids AS warehouse_ids_4, t0.supervising_region_ids AS supervising_region_ids_5, t0.st_discount_usable_percentages AS st_discount_usable_percentages_6, t0.ct_discount_usable_percentages AS ct_discount_usable_percentages_7, t0.back_entry_limit_days AS back_entry_limit_days_8, t0.back_entry_enabled AS back_entry_enabled_9, t0.options AS options_10, t0.created_login_id AS created_login_id_11, t0.edited_login_id AS edited_login_id_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.doc_booked_flag AS doc_booked_flag_15, t0.time_stamp_of_form AS time_stamp_of_form_16 FROM sys_user_application_access_control t0 WHERE t0.user_id = ? LIMIT 1
[
"27"
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.data AS data_3, t0.company_id AS company_id_4, t0.create_login_id AS create_login_id_5, t0.edit_login_id AS edit_login_id_6, t0.lock_flag AS lock_flag_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.doc_booked_flag AS doc_booked_flag_10, t0.time_stamp_of_form AS time_stamp_of_form_11 FROM acc_setting t0 WHERE t0.name = ? LIMIT 1
[
"expense_parent"
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.data AS data_3, t0.company_id AS company_id_4, t0.create_login_id AS create_login_id_5, t0.edit_login_id AS edit_login_id_6, t0.lock_flag AS lock_flag_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.doc_booked_flag AS doc_booked_flag_10, t0.time_stamp_of_form AS time_stamp_of_form_11 FROM acc_setting t0 WHERE t0.name = ? LIMIT 1
[
"lc_ac_parent"
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.data AS data_3, t0.company_id AS company_id_4, t0.create_login_id AS create_login_id_5, t0.edit_login_id AS edit_login_id_6, t0.lock_flag AS lock_flag_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.doc_booked_flag AS doc_booked_flag_10, t0.time_stamp_of_form AS time_stamp_of_form_11 FROM acc_setting t0 WHERE t0.name = ? LIMIT 1
[
"add_expense_extra_head"
]
|
|
doctrine | SELECT DISTINCT acc_accounts_head.parent_id FROM acc_accounts_head where company_id=1 | |
doctrine | SELECT acc_accounts_head.name, acc_accounts_head.opening_balance, acc_accounts_head.current_balance, acc_accounts_head.current_balance_reconciled, acc_accounts_head.path_tree, acc_accounts_head.head_nature, acc_accounts_head.cc_enabled, acc_accounts_head.accounts_head_id, acc_accounts_head.parent_id, acc_accounts_head.type, acc_accounts_head.advance_of, b.name parent_name FROM acc_accounts_head left join acc_accounts_head as b on acc_accounts_head.parent_id=b.accounts_head_id WHERE acc_accounts_head.company_id=1 AND acc_accounts_head.parent_id !=0 AND acc_accounts_head.accounts_head_id NOT IN (0,1,3,94,95,4,5,89,90,110,99,100,101,102,103,104,105,106,107,108,139,109,112,176,177,96,114,204,129,130,121,123,234,236,235,245,241,246,243,242,244,117,337,132,680,225,892,1122,180,1139,1110,134,170,118,227,181,205,956,111,340,1310,119,1352,907,115,228,131,120,1420,1423)AND (acc_accounts_head.path_tree like '%/5/%' OR acc_accounts_head.path_tree like '%/1249/%' ) ORDER BY name ASC | |
doctrine | SELECT * FROM acc_cost_centre WHERE 1 ORDER BY name ASC | |
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.data AS data_3, t0.company_id AS company_id_4, t0.create_login_id AS create_login_id_5, t0.edit_login_id AS edit_login_id_6, t0.lock_flag AS lock_flag_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.doc_booked_flag AS doc_booked_flag_10, t0.time_stamp_of_form AS time_stamp_of_form_11 FROM acc_setting t0 WHERE t0.name = ? LIMIT 1
[
"payment_voucher_credit_parents"
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.data AS data_3, t0.company_id AS company_id_4, t0.create_login_id AS create_login_id_5, t0.edit_login_id AS edit_login_id_6, t0.lock_flag AS lock_flag_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.doc_booked_flag AS doc_booked_flag_10, t0.time_stamp_of_form AS time_stamp_of_form_11 FROM acc_setting t0 WHERE t0.name = ? LIMIT 1
[
"payment_voucher_debit_parents"
]
|
|
doctrine | SELECT DISTINCT acc_accounts_head.parent_id FROM acc_accounts_head where company_id=1 | |
doctrine | SELECT acc_accounts_head.name, acc_accounts_head.opening_balance, acc_accounts_head.current_balance, acc_accounts_head.current_balance_reconciled, acc_accounts_head.path_tree, acc_accounts_head.head_nature, acc_accounts_head.cc_enabled, acc_accounts_head.accounts_head_id, acc_accounts_head.parent_id, acc_accounts_head.type, acc_accounts_head.advance_of, b.name parent_name FROM acc_accounts_head left join acc_accounts_head as b on acc_accounts_head.parent_id=b.accounts_head_id WHERE acc_accounts_head.company_id=1 AND acc_accounts_head.parent_id !=0 AND acc_accounts_head.accounts_head_id NOT IN (0,1,3,94,95,4,5,89,90,110,99,100,101,102,103,104,105,106,107,108,139,109,112,176,177,96,114,204,129,130,121,123,234,236,235,245,241,246,243,242,244,117,337,132,680,225,892,1122,180,1139,1110,134,170,118,227,181,205,956,111,340,1310,119,1352,907,115,228,131,120,1420,1423) ORDER BY name ASC | |
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.data AS data_3, t0.company_id AS company_id_4, t0.create_login_id AS create_login_id_5, t0.edit_login_id AS edit_login_id_6, t0.lock_flag AS lock_flag_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.doc_booked_flag AS doc_booked_flag_10, t0.time_stamp_of_form AS time_stamp_of_form_11 FROM acc_setting t0 WHERE t0.name = ? LIMIT 1
[
"payment_voucher_credit_parents"
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.data AS data_3, t0.company_id AS company_id_4, t0.create_login_id AS create_login_id_5, t0.edit_login_id AS edit_login_id_6, t0.lock_flag AS lock_flag_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.doc_booked_flag AS doc_booked_flag_10, t0.time_stamp_of_form AS time_stamp_of_form_11 FROM acc_setting t0 WHERE t0.name = ? LIMIT 1
[
"payment_voucher_debit_parents"
]
|
|
doctrine | SELECT DISTINCT acc_accounts_head.parent_id FROM acc_accounts_head where company_id=1 | |
doctrine | SELECT acc_accounts_head.name, acc_accounts_head.opening_balance, acc_accounts_head.current_balance, acc_accounts_head.current_balance_reconciled, acc_accounts_head.path_tree, acc_accounts_head.head_nature, acc_accounts_head.cc_enabled, acc_accounts_head.accounts_head_id, acc_accounts_head.parent_id, acc_accounts_head.type, acc_accounts_head.advance_of, b.name parent_name FROM acc_accounts_head left join acc_accounts_head as b on acc_accounts_head.parent_id=b.accounts_head_id WHERE acc_accounts_head.company_id=1 AND acc_accounts_head.parent_id !=0 AND acc_accounts_head.accounts_head_id NOT IN (0,1,3,94,95,4,5,89,90,110,99,100,101,102,103,104,105,106,107,108,139,109,112,176,177,96,114,204,129,130,121,123,234,236,235,245,241,246,243,242,244,117,337,132,680,225,892,1122,180,1139,1110,134,170,118,227,181,205,956,111,340,1310,119,1352,907,115,228,131,120,1420,1423) ORDER BY name ASC | |
doctrine |
SELECT t0.client_id AS client_id_1, t0.client_level AS client_level_2, t0.parent_id AS parent_id_3, t0.is_consumer AS is_consumer_4, t0.device_id AS device_id_5, t0.device_id_locked_flag AS device_id_locked_flag_6, t0.lock_device_id_on_next_login_flag AS lock_device_id_on_next_login_flag_7, t0.username AS username_8, t0.password AS password_9, t0.app_id AS app_id_10, t0.global_user_id AS global_user_id_11, t0.otp_action_id AS otp_action_id_12, t0.otp AS otp_13, t0.otp_expire_ts AS otp_expire_ts_14, t0.email_verification_hash AS email_verification_hash_15, t0.phone_verification_hash AS phone_verification_hash_16, t0.trigger_reset_password AS trigger_reset_password_17, t0.forgot_password_token AS forgot_password_token_18, t0.forgot_password_token_expire_ts AS forgot_password_token_expire_ts_19, t0.is_email_verified AS is_email_verified_20, t0.is_phone_verified AS is_phone_verified_21, t0.is_banned AS is_banned_22, t0.ban_expires AS ban_expires_23, t0.strike_count AS strike_count_24, t0.strike_threshold AS strike_threshold_25, t0.account_status AS account_status_26, t0.accounts_head_id AS accounts_head_id_27, t0.advance_head_id AS advance_head_id_28, t0.tagged_item_groups AS tagged_item_groups_29, t0.project_ids AS project_ids_30, t0.credit_limit AS credit_limit_31, t0.freeze_balance AS freeze_balance_32, t0.credit_limit_enabled AS credit_limit_enabled_33, t0.delivery_locked AS delivery_locked_34, t0.image AS image_35, t0.provision_flag AS provision_flag_36, t0.temp_client_flag AS temp_client_flag_37, t0.head_addition_pending_flag AS head_addition_pending_flag_38, t0.company_id AS company_id_39, t0.client_name AS client_name_40, t0.client_area_wise_code AS client_area_wise_code_41, t0.client_numerical_code AS client_numerical_code_42, t0.client_short_code AS client_short_code_43, t0.client_alternate_code AS client_alternate_code_44, t0.country_id AS country_id_45, t0.geographical_region_id AS geographical_region_id_46, t0.geographical_region_name AS geographical_region_name_47, t0.region_id AS region_id_48, t0.contact_person_name AS contact_person_name_49, t0.sales_person_id AS sales_person_id_50, t0.general_info_tin AS general_info_tin_51, t0.general_info_bin AS general_info_bin_52, t0.type AS type_53, t0.division_id AS division_id_54, t0.is_individual AS is_individual_55, t0.allowed_brand_ids AS allowed_brand_ids_56, t0.delivery_instruction AS delivery_instruction_57, t0.address_contact AS address_contact_58, t0.contact_number AS contact_number_59, t0.shipping_address AS shipping_address_60, t0.billing_address AS billing_address_61, t0.email AS email_62, t0.representative_emails AS representative_emails_63, t0.representative_emails_data AS representative_emails_data_64, t0.fax AS fax_65, t0.client_order_amount AS client_order_amount_66, t0.client_invoice_amount AS client_invoice_amount_67, t0.client_received AS client_received_68, t0.client_due AS client_due_69, t0.initial_opening_balance AS initial_opening_balance_70, t0.client_own_balance_amount AS client_own_balance_amount_71, t0.client_own_due_amount AS client_own_due_amount_72, t0.client_own_sales_amount AS client_own_sales_amount_73, t0.client_own_received_amount AS client_own_received_amount_74, t0.client_cash_amount AS client_cash_amount_75, t0.client_bank_amount AS client_bank_amount_76, t0.client_payment_methods_info AS client_payment_methods_info_77, t0.date_of_addition AS date_of_addition_78, t0.create_login_id AS create_login_id_79, t0.edit_login_id AS edit_login_id_80, t0.status AS status_81, t0.last_settings_updated_ts AS last_settings_updated_ts_82, t0.created_at AS created_at_83, t0.updated_at AS updated_at_84, t0.default_courier_id AS default_courier_id_85, t0.temp_area_str AS temp_area_str_86, t0.temp_customer_id_hash AS temp_customer_id_hash_87, t0.doc_booked_flag AS doc_booked_flag_88, t0.time_stamp_of_form AS time_stamp_of_form_89 FROM acc_clients t0 WHERE t0.status = ?
[
true
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.data AS data_3, t0.company_id AS company_id_4, t0.create_login_id AS create_login_id_5, t0.edit_login_id AS edit_login_id_6, t0.lock_flag AS lock_flag_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.doc_booked_flag AS doc_booked_flag_10, t0.time_stamp_of_form AS time_stamp_of_form_11 FROM acc_setting t0 WHERE t0.name = ? LIMIT 1
[
"receipt_voucher_credit_parents"
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.data AS data_3, t0.company_id AS company_id_4, t0.create_login_id AS create_login_id_5, t0.edit_login_id AS edit_login_id_6, t0.lock_flag AS lock_flag_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.doc_booked_flag AS doc_booked_flag_10, t0.time_stamp_of_form AS time_stamp_of_form_11 FROM acc_setting t0 WHERE t0.name = ? LIMIT 1
[
"receipt_voucher_debit_parents"
]
|
|
doctrine | SELECT DISTINCT acc_accounts_head.parent_id FROM acc_accounts_head where company_id=1 | |
doctrine | SELECT acc_accounts_head.name, acc_accounts_head.opening_balance, acc_accounts_head.current_balance, acc_accounts_head.current_balance_reconciled, acc_accounts_head.path_tree, acc_accounts_head.head_nature, acc_accounts_head.cc_enabled, acc_accounts_head.accounts_head_id, acc_accounts_head.parent_id, acc_accounts_head.type, acc_accounts_head.advance_of, b.name parent_name FROM acc_accounts_head left join acc_accounts_head as b on acc_accounts_head.parent_id=b.accounts_head_id WHERE acc_accounts_head.company_id=1 AND acc_accounts_head.parent_id !=0 AND acc_accounts_head.accounts_head_id NOT IN (0,1,3,94,95,4,5,89,90,110,99,100,101,102,103,104,105,106,107,108,139,109,112,176,177,96,114,204,129,130,121,123,234,236,235,245,241,246,243,242,244,117,337,132,680,225,892,1122,180,1139,1110,134,170,118,227,181,205,956,111,340,1310,119,1352,907,115,228,131,120,1420,1423) ORDER BY name ASC | |
doctrine | SELECT DISTINCT acc_accounts_head.parent_id FROM acc_accounts_head where company_id=1 | |
doctrine | SELECT acc_accounts_head.name, acc_accounts_head.opening_balance, acc_accounts_head.current_balance, acc_accounts_head.current_balance_reconciled, acc_accounts_head.path_tree, acc_accounts_head.head_nature, acc_accounts_head.cc_enabled, acc_accounts_head.accounts_head_id, acc_accounts_head.parent_id, acc_accounts_head.type, acc_accounts_head.advance_of, b.name parent_name FROM acc_accounts_head left join acc_accounts_head as b on acc_accounts_head.parent_id=b.accounts_head_id WHERE acc_accounts_head.company_id=1 AND acc_accounts_head.parent_id !=0 AND acc_accounts_head.accounts_head_id NOT IN (0,1,3,94,95,4,5,89,90,110,99,100,101,102,103,104,105,106,107,108,139,109,112,176,177,96,114,204,129,130,121,123,234,236,235,245,241,246,243,242,244,117,337,132,680,225,892,1122,180,1139,1110,134,170,118,227,181,205,956,111,340,1310,119,1352,907,115,228,131,120,1420,1423) ORDER BY name ASC | |
doctrine |
SELECT t0.check_id AS check_id_1, t0.accounts_head_id AS accounts_head_id_2, t0.voucher_id AS voucher_id_3, t0.rec_accounts_head_id AS rec_accounts_head_id_4, t0.rec_accounts_head_id_list AS rec_accounts_head_id_list_5, t0.acc_number AS acc_number_6, t0.check_number AS check_number_7, t0.check_book_number AS check_book_number_8, t0.check_narration AS check_narration_9, t0.check_amount AS check_amount_10, t0.active AS active_11, t0.status AS status_12, t0.assigned AS assigned_13, t0.printed AS printed_14, t0.security_check AS security_check_15, t0.destroyed AS destroyed_16, t0.type AS type_17, t0.details AS details_18, t0.assigned_date AS assigned_date_19, t0.recon_date AS recon_date_20, t0.check_date AS check_date_21, t0.transaction_date AS transaction_date_22, t0.ledger_hit_date AS ledger_hit_date_23, t0.format_id AS format_id_24, t0.company_id AS company_id_25, t0.create_login_id AS create_login_id_26, t0.edit_login_id AS edit_login_id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.doc_booked_flag AS doc_booked_flag_30, t0.time_stamp_of_form AS time_stamp_of_form_31 FROM acc_check t0 WHERE t0.assigned = ? ORDER BY t0.accounts_head_id DESC, t0.check_number DESC
[
0
]
|
|
event |
Notified event "kernel.response" to listener "ApplicationBundle\Listener\SessionListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "ApplicationBundle\Listener\SessionListener::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\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\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse" ] |
|
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" ] |
PHP Notices 0
Log messages generated by PHP notices silenced with the @ operator.
There are no log messages of this level.
Container 715
Log messages generated during the compilation of the service container.
Class | Messages |
---|---|
Symfony\Component\DependencyInjection\Compiler\ResolveChildDefinitionsPass
|
113 |
Symfony\Component\DependencyInjection\Compiler\RemovePrivateAliasesPass
|
138 |
Symfony\Component\DependencyInjection\Compiler\ReplaceAliasByActualDefinitionPass
|
54 |
Symfony\Component\DependencyInjection\Compiler\RemoveAbstractDefinitionsPass
|
118 |
Symfony\Component\DependencyInjection\Compiler\RemoveUnusedDefinitionsPass
|
61 |
Symfony\Component\DependencyInjection\Compiler\InlineServiceDefinitionsPass
|
231 |