UPDATE "bus_presence" SET "last_poll" = '2024-09-17 17:04:43', "last_presence" = '2024-09-17 17:04:36.520593' WHERE id IN (152);

[ Date: 2024-09-17 17:08:49 ]

UPDATE "bus_presence" SET "last_poll" = '2024-09-17 17:06:08', "last_presence" = '2024-09-17 17:05:48.954376' WHERE id IN (152);

[ Date: 2024-09-17 17:08:49 ]

UPDATE "bus_presence" SET "last_poll" = '2024-09-17 17:07:39', "last_presence" = '2024-09-17 17:07:30.006603' WHERE id IN (152);

[ Date: 2024-09-17 17:08:49 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1661766 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1661766 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-09-17 15:56:31 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1661750 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1661750 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-09-17 15:56:31 ]

UPDATE "account_move" SET "message_main_attachment_id" = 5708038, "write_uid" = 1005, "write_date" = (now() at time zone 'UTC') WHERE id IN (1662668);

[ Date: 2024-09-17 19:03:46 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1661791 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1661791 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-09-17 16:04:46 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1661743 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1661743 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-09-17 15:55:16 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1661359 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1661359 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-09-17 14:56:48 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1661788 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1661788 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-09-17 15:58:31 ]

UPDATE "account_move" SET "message_main_attachment_id" = 5706401, "write_uid" = 1267, "write_date" = (now() at time zone 'UTC') WHERE id IN (1660801);

[ Date: 2024-09-17 13:16:53 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1661154 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1661154 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-09-17 14:14:46 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1660713 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1660713 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-09-17 13:08:13 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1661248 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1661248 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-09-17 14:32:26 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1422626 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1422626 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-09-17 17:46:18 ]

UPDATE "account_move" SET "access_token" = 'e1a3c470-5ed3-49dc-a9ca-71d015ce4f94', "write_uid" = 1035, "write_date" = (now() at time zone 'UTC') WHERE id IN (1660645);

[ Date: 2024-09-17 12:55:15 ]

UPDATE "account_move" SET "message_main_attachment_id" = 5707432, "write_uid" = 1043, "write_date" = (now() at time zone 'UTC') WHERE id IN (1661819);

[ Date: 2024-09-17 16:18:17 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1661254 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1661254 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-09-17 14:33:58 ]

update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (269947) and warehouse_id = (45));

[ Date: 2024-09-17 16:40:37 ]

DELETE FROM account_move_line WHERE id IN (5845836, 5845837, 5845838, 5845839, 5845840, 5845841, 5845842, 5845843, 5845844, 5845845, 5845846, 5845847, 5845848, 5845849, 5845850, 5845851, 5845852, 5845853, 5845854, 5845855, 5845856, 5845857, 5845858, 5845859, 5845860, 5845861, 5845862, 5845863, 5845864, 5845865, 5845866, 5845867, 5845868, 5845869, 5845870, 5845871, 5845872, 5845873, 5845874, 5845875, 5845876, 5845877, 5845878, 5845879, 5845880, 5845881, 5845882, 5845883, 5845884, 5845885, 5845886, 5845887, 5845888, 5845889, 5845890, 5845891, 5845892, 5845893, 5845894, 5845895, 5845896, 5845897, 5845898, 5845899, 5845900, 5845901, 5845902, 5845903, 5845904, 5845905, 5845906, 5845907, 5845908, 5845909, 5845910, 5845911, 5845912, 5845913, 5845914, 5845915, 5845916, 5845917, 5845918, 5845919, 5845920, 5845921, 5845922, 5845923, 5845924, 5845925, 5845926, 5845927, 5845928, 5845929, 5845930, 5845931, 5845932, 5845933, 5845934, 5845935, 5845936, 5845937, 5845938, 5845939, 5845940, 5845941, 5845942, 5845943, 5845944, 5845945, 5845946, 5845947, 5845948, 5845949, 5845950, 5845951, 5845952, 5845953);

[ Date: 2024-09-17 11:17:39 ]

COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;

[ Date: 2024-09-17 09:10:30 ]

COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;

[ Date: 2024-09-17 09:04:20 ]

COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;

[ Date: 2024-09-17 09:06:30 ]

DELETE FROM account_move_line WHERE id IN (5653257, 5653258, 5653259, 5653260, 5653261, 5653262, 5653263, 5653264, 5653265, 5653266, 5653267, 5653268, 5653269, 5653270, 5653271, 5653272, 5653273, 5653274, 5653275, 5653276, 5853279, 5853280);

[ Date: 2024-09-17 19:37:16 ]

COPY public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id, is_discount, is_sale_tax, auto_reconcile, is_writeoff, is_extra_line, is_carry_forward) TO stdout;

[ Date: 2024-09-17 09:01:03 ]

DELETE FROM account_move_line WHERE id IN (5765761, 5765762, 5765763, 5765764, 5765765, 5765766, 5765767, 5765768, 5765769, 5765770, 5765771, 5765772, 5765773, 5765774, 5765775, 5849626, 5849627);

[ Date: 2024-09-17 16:04:27 ]

SELECT account_move_line.account_id AS groupby, 'sum' AS key, MAX(account_move_line.date) AS max_date, 0 AS period_number, COALESCE(SUM(account_move_line.amount_currency), 0.0) AS amount_currency, SUM(ROUND(account_move_line.debit * currency_table.rate, currency_table.precision)) AS debit, SUM(ROUND(account_move_line.credit * currency_table.rate, currency_table.precision)) AS credit, SUM(ROUND(account_move_line.balance * currency_table.rate, currency_table.precision)) AS balance FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") LEFT JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id WHERE (((((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line__move_id"."state" != 'cancel') OR "account_move_line__move_id"."state" IS NULL)) AND ("account_move_line"."company_id" = 1)) AND ("account_move_line"."date" <= '2024-09-30')) AND (("account_move_line"."date" >= '2024-01-01') OR ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in ( SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."include_initial_balance" = true))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1))))))) AND ("account_move_line__move_id"."state" = 'posted')) AND ((unaccent ("account_move_line"."account_id"::text) ilike unaccent ('%%')) OR "account_move_line"."account_id" IS NULL)) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY account_move_line.account_id UNION ALL SELECT account_move_line.company_id AS groupby, 'unaffected_earnings' AS key, NULL AS max_date, 0 AS period_number, COALESCE(SUM(account_move_line.amount_currency), 0.0) AS amount_currency, SUM(ROUND(account_move_line.debit * currency_table.rate, currency_table.precision)) AS debit, SUM(ROUND(account_move_line.credit * currency_table.rate, currency_table.precision)) AS credit, SUM(ROUND(account_move_line.balance * currency_table.rate, currency_table.precision)) AS balance FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") LEFT JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id WHERE (((((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line__move_id"."state" != 'cancel') OR "account_move_line__move_id"."state" IS NULL)) AND ("account_move_line"."company_id" = 1)) AND ("account_move_line"."date" <= '2023-12-31')) AND ("account_move_line__move_id"."state" = 'posted')) AND ((unaccent ("account_move_line"."account_id"::text) ilike unaccent ('%%')) OR "account_move_line"."account_id" IS NULL)) AND ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in ( SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."include_initial_balance" IS NULL or "account_account_type"."include_initial_balance" = false))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1)))))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY account_move_line.company_id;

[ Date: 2024-09-17 19:51:08 ]

SELECT account_move_line.account_id AS groupby, 'sum' AS key, MAX(account_move_line.date) AS max_date, 0 AS period_number, COALESCE(SUM(account_move_line.amount_currency), 0.0) AS amount_currency, SUM(ROUND(account_move_line.debit * currency_table.rate, currency_table.precision)) AS debit, SUM(ROUND(account_move_line.credit * currency_table.rate, currency_table.precision)) AS credit, SUM(ROUND(account_move_line.balance * currency_table.rate, currency_table.precision)) AS balance FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") LEFT JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id WHERE (((((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line__move_id"."state" != 'cancel') OR "account_move_line__move_id"."state" IS NULL)) AND ("account_move_line"."company_id" = 1)) AND ("account_move_line"."date" <= '2024-09-30')) AND (("account_move_line"."date" >= '2024-01-01') OR ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in ( SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."include_initial_balance" = true))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1))))))) AND ("account_move_line__move_id"."state" = 'posted')) AND ((unaccent ("account_move_line"."account_id"::text) ilike unaccent ('%%')) OR "account_move_line"."account_id" IS NULL)) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY account_move_line.account_id UNION ALL SELECT account_move_line.company_id AS groupby, 'unaffected_earnings' AS key, NULL AS max_date, 0 AS period_number, COALESCE(SUM(account_move_line.amount_currency), 0.0) AS amount_currency, SUM(ROUND(account_move_line.debit * currency_table.rate, currency_table.precision)) AS debit, SUM(ROUND(account_move_line.credit * currency_table.rate, currency_table.precision)) AS credit, SUM(ROUND(account_move_line.balance * currency_table.rate, currency_table.precision)) AS balance FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") LEFT JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id WHERE (((((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line__move_id"."state" != 'cancel') OR "account_move_line__move_id"."state" IS NULL)) AND ("account_move_line"."company_id" = 1)) AND ("account_move_line"."date" <= '2023-12-31')) AND ("account_move_line__move_id"."state" = 'posted')) AND ((unaccent ("account_move_line"."account_id"::text) ilike unaccent ('%%')) OR "account_move_line"."account_id" IS NULL)) AND ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in ( SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."include_initial_balance" IS NULL or "account_account_type"."include_initial_balance" = false))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1)))))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY account_move_line.company_id;

[ Date: 2024-09-17 19:51:11 ]

SELECT account_move_line.account_id AS groupby, 'sum' AS key, MAX(account_move_line.date) AS max_date, 0 AS period_number, COALESCE(SUM(account_move_line.amount_currency), 0.0) AS amount_currency, SUM(ROUND(account_move_line.debit * currency_table.rate, currency_table.precision)) AS debit, SUM(ROUND(account_move_line.credit * currency_table.rate, currency_table.precision)) AS credit, SUM(ROUND(account_move_line.balance * currency_table.rate, currency_table.precision)) AS balance FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") LEFT JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id WHERE (((((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line__move_id"."state" != 'cancel') OR "account_move_line__move_id"."state" IS NULL)) AND ("account_move_line"."company_id" = 1)) AND ("account_move_line"."date" <= '2024-09-30')) AND (("account_move_line"."date" >= '2024-01-01') OR ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in ( SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."include_initial_balance" = true))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1))))))) AND ("account_move_line__move_id"."state" = 'posted')) AND ((unaccent ("account_move_line"."account_id"::text) ilike unaccent ('%%')) OR "account_move_line"."account_id" IS NULL)) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY account_move_line.account_id UNION ALL SELECT account_move_line.company_id AS groupby, 'unaffected_earnings' AS key, NULL AS max_date, 0 AS period_number, COALESCE(SUM(account_move_line.amount_currency), 0.0) AS amount_currency, SUM(ROUND(account_move_line.debit * currency_table.rate, currency_table.precision)) AS debit, SUM(ROUND(account_move_line.credit * currency_table.rate, currency_table.precision)) AS credit, SUM(ROUND(account_move_line.balance * currency_table.rate, currency_table.precision)) AS balance FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") LEFT JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id WHERE (((((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line__move_id"."state" != 'cancel') OR "account_move_line__move_id"."state" IS NULL)) AND ("account_move_line"."company_id" = 1)) AND ("account_move_line"."date" <= '2023-12-31')) AND ("account_move_line__move_id"."state" = 'posted')) AND ((unaccent ("account_move_line"."account_id"::text) ilike unaccent ('%%')) OR "account_move_line"."account_id" IS NULL)) AND ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in ( SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."include_initial_balance" IS NULL or "account_account_type"."include_initial_balance" = false))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1)))))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY account_move_line.company_id;

[ Date: 2024-09-17 19:50:35 ]

DELETE FROM account_move_line WHERE id IN (5850119, 5850120, 5850121, 5850122, 5846836, 5846837, 5846838, 5850348, 5850349, 5850350, 5850351, 5850352, 5850353, 5850354, 5850355);

[ Date: 2024-09-17 23:24:54 ]

DELETE FROM account_move_line WHERE id IN (5852530, 5852531, 5649645, 5649646, 5649647, 5649648, 5649649, 5649650, 5649651, 5649652, 5649653, 5649654, 5649655, 5649656, 5649657);

[ Date: 2024-09-17 23:36:56 ]

DELETE FROM account_move_line WHERE id IN (5839704, 5839705, 5839706, 5839707, 5839708, 5839709, 5839710, 5839711, 5839712, 5839713, 5839714, 5839715);

[ Date: 2024-09-17 19:03:46 ]

SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "user_id_count", sum("sale_history_line"."product_uom_qty") AS "product_uom_qty", sum("sale_history_line"."cost_price_unit") AS "cost_price_unit", sum("sale_history_line"."cost_subtotal") AS "cost_subtotal", sum("sale_history_line"."price_unit") AS "price_unit", sum("sale_history_line"."price_subtotal") AS "price_subtotal", sum("sale_history_line"."gross_profit") AS "gross_profit", "sale_history_line"."user_id" as "user_id" FROM "sale_history_line" LEFT JOIN "res_users" AS "sale_history_line__user_id" ON ("sale_history_line"."user_id" = "sale_history_line__user_id"."id") LEFT JOIN "res_partner" AS "sale_history_line__user_id__partner_id" ON ("sale_history_line__user_id"."partner_id" = "sale_history_line__user_id__partner_id"."id") WHERE (((("sale_history_line"."invoice_date" >= '2024-09-01') AND ("sale_history_line"."invoice_date" <= '2024-09-30')) AND ("sale_history_line"."is_shipping" IS NULL or "sale_history_line"."is_shipping" = false)) AND ((unaccent ("sale_history_line"."invoice_number"::text) not ilike unaccent ('%x%')) OR "sale_history_line"."invoice_number" IS NULL)) GROUP BY "sale_history_line"."user_id", "sale_history_line__user_id__partner_id"."name", "sale_history_line__user_id"."login" ORDER BY "sale_history_line__user_id__partner_id"."name", "sale_history_line__user_id"."login" LIMIT 80;

[ Date: 2024-09-17 19:08:36 ]

SELECT account_move_line.account_id AS groupby, 'sum' AS key, MAX(account_move_line.date) AS max_date, 0 AS period_number, COALESCE(SUM(account_move_line.amount_currency), 0.0) AS amount_currency, SUM(ROUND(account_move_line.debit * currency_table.rate, currency_table.precision)) AS debit, SUM(ROUND(account_move_line.credit * currency_table.rate, currency_table.precision)) AS credit, SUM(ROUND(account_move_line.balance * currency_table.rate, currency_table.precision)) AS balance FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") LEFT JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id WHERE (((((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line__move_id"."state" != 'cancel') OR "account_move_line__move_id"."state" IS NULL)) AND ("account_move_line"."company_id" = 1)) AND ("account_move_line"."date" <= '2024-09-30')) AND (("account_move_line"."date" >= '2024-01-01') OR ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in ( SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."include_initial_balance" = true))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1))))))) AND ("account_move_line__move_id"."state" = 'posted')) AND ((unaccent ("account_move_line"."account_id"::text) ilike unaccent ('%%')) OR "account_move_line"."account_id" IS NULL)) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY account_move_line.account_id UNION ALL SELECT account_move_line.company_id AS groupby, 'unaffected_earnings' AS key, NULL AS max_date, 0 AS period_number, COALESCE(SUM(account_move_line.amount_currency), 0.0) AS amount_currency, SUM(ROUND(account_move_line.debit * currency_table.rate, currency_table.precision)) AS debit, SUM(ROUND(account_move_line.credit * currency_table.rate, currency_table.precision)) AS credit, SUM(ROUND(account_move_line.balance * currency_table.rate, currency_table.precision)) AS balance FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") LEFT JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id WHERE (((((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line__move_id"."state" != 'cancel') OR "account_move_line__move_id"."state" IS NULL)) AND ("account_move_line"."company_id" = 1)) AND ("account_move_line"."date" <= '2023-12-31')) AND ("account_move_line__move_id"."state" = 'posted')) AND ((unaccent ("account_move_line"."account_id"::text) ilike unaccent ('%%')) OR "account_move_line"."account_id" IS NULL)) AND ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in ( SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."include_initial_balance" IS NULL or "account_account_type"."include_initial_balance" = false))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1)))))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY account_move_line.company_id;

[ Date: 2024-09-17 18:44:42 ]

DELETE FROM account_move_line WHERE id IN (5845647, 5845648, 5845649, 5851475, 5851476, 5851477, 5851478, 5851479, 5851480, 5851481, 5851482, 5851483, 5851484);

[ Date: 2024-09-17 23:38:12 ]

SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "user_id_count", sum("sale_history_line"."product_uom_qty") AS "product_uom_qty", sum("sale_history_line"."cost_price_unit") AS "cost_price_unit", sum("sale_history_line"."cost_subtotal") AS "cost_subtotal", sum("sale_history_line"."price_unit") AS "price_unit", sum("sale_history_line"."price_subtotal") AS "price_subtotal", sum("sale_history_line"."gross_profit") AS "gross_profit", "sale_history_line"."user_id" as "user_id" FROM "sale_history_line" LEFT JOIN "res_users" AS "sale_history_line__user_id" ON ("sale_history_line"."user_id" = "sale_history_line__user_id"."id") LEFT JOIN "res_partner" AS "sale_history_line__user_id__partner_id" ON ("sale_history_line__user_id"."partner_id" = "sale_history_line__user_id__partner_id"."id") WHERE (((("sale_history_line"."invoice_date" >= '2024-09-01') AND ("sale_history_line"."invoice_date" <= '2024-09-30')) AND ("sale_history_line"."is_shipping" IS NULL or "sale_history_line"."is_shipping" = false)) AND ((unaccent ("sale_history_line"."invoice_number"::text) not ilike unaccent ('%x%')) OR "sale_history_line"."invoice_number" IS NULL)) GROUP BY "sale_history_line"."user_id", "sale_history_line__user_id__partner_id"."name", "sale_history_line__user_id"."login" ORDER BY "sale_history_line__user_id__partner_id"."name", "sale_history_line__user_id"."login" LIMIT 80;

[ Date: 2024-09-17 19:09:09 ]

DELETE FROM account_move_line WHERE id IN (5664828, 5664829, 5664830, 5664831, 5664832, 5664833, 5664834, 5664835, 5664836, 5849418, 5849419);

[ Date: 2024-09-17 15:56:14 ]

COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage, technician_id, inventory_vendor_id, product_type, current_branch) TO stdout;

[ Date: 2024-09-17 09:12:48 ]

SELECT "sale_line_report".id FROM "sale_line_report" WHERE (("sale_line_report"."cus_part_route" = 3) AND (("sale_line_report"."id" > '0') AND (((((("sale_line_report"."branch_id" in (37)) AND "sale_line_report"."display_type" IS NULL) AND ((("sale_line_report"."open_qty_fil" > 0.0) AND (("sale_line_report"."state" not in ('draft', 'cancel')) OR "sale_line_report"."state" IS NULL)) AND ("sale_line_report"."move_options" = 'new_product'))) AND ("sale_line_report"."so_line_id" IS NULL AND (unaccent ("sale_line_report"."move_options"::text) ilike unaccent ('%new%')))) AND ("sale_line_report"."on_hand" > 0.0)) AND ("sale_line_report"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."tue_deli_day" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private')))))))) ORDER BY "sale_line_report"."date" DESC, "sale_line_report"."id" ASC LIMIT 80;