Symfony Profiler

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

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 = 1 AND t0.user_id = '27' AND t0.status = 1 ORDER BY t0.sequence ASC;

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

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 = 1 AND t0.default_box_flag = 1 AND t0.status = 1 ORDER BY t0.sequence ASC;

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

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 = 1 AND t0.id = 1 LIMIT 1;

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

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 = 1 AND (t0.branch_id IN (NULL, 0) OR t0.branch_id IS NULL) ORDER BY t0.date DESC LIMIT 11;

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

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 = 1 AND t0.id = 1 LIMIT 1;

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 = ?

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 (0, NULL) OR t0.parent_id IS NULL) AND t0.company_id = 1;

SELECT 
  DISTINCT acc_accounts_head.parent_id 
FROM 
  acc_accounts_head 
WHERE 
  1

SELECT DISTINCT acc_accounts_head.parent_id FROM acc_accounts_head WHERE 1;

select 
  * 
from 
  fiscal_closing 
where 
  closing_end_date < '2024-11-01 00:00:00' 
Order by 
  closing_end_date desc 
limit 
  1

select * from fiscal_closing where closing_end_date < '2024-11-01 00:00:00'  Order by closing_end_date desc limit 1;

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

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;

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'

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'  ;

SELECT 
  DISTINCT acc_accounts_head.parent_id 
FROM 
  acc_accounts_head 
WHERE 
  1

SELECT DISTINCT acc_accounts_head.parent_id FROM acc_accounts_head WHERE 1;

select 
  * 
from 
  fiscal_closing 
where 
  closing_end_date < '2024-10-01 00:00:00' 
Order by 
  closing_end_date desc 
limit 
  1

select * from fiscal_closing where closing_end_date < '2024-10-01 00:00:00'  Order by closing_end_date desc limit 1;

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

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;

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'

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'  ;

SELECT 
  DISTINCT acc_accounts_head.parent_id 
FROM 
  acc_accounts_head 
WHERE 
  1

SELECT DISTINCT acc_accounts_head.parent_id FROM acc_accounts_head WHERE 1;

select 
  * 
from 
  fiscal_closing 
where 
  closing_end_date < '2024-09-01 00:00:00' 
Order by 
  closing_end_date desc 
limit 
  1

select * from fiscal_closing where closing_end_date < '2024-09-01 00:00:00'  Order by closing_end_date desc limit 1;

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

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;