update shipping_policy set count_search = 6 where id = 5462442;

[ Date: 2025-02-19 19:59:44 ]

update shipping_policy set count_search = 4 where id = 5470705;

[ Date: 2025-02-19 20:01:43 ]

SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL)))) ORDER BY "policy_number"."id" LIMIT 8;

[ Date: 2025-02-19 16:21:35 ]

SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL)))) ORDER BY "policy_number"."id" LIMIT 8;

[ Date: 2025-02-19 16:08:56 ]

SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL)))) ORDER BY "policy_number"."id" LIMIT 8;

[ Date: 2025-02-19 16:49:45 ]

SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL)))) ORDER BY "policy_number"."id" LIMIT 8;

[ Date: 2025-02-19 16:49:37 ]

UPDATE "shipping_policy" SET "state_collection" = 'confirm', "write_date" = '2025-02-19 15:27:19.983481', "write_uid" = 1079 WHERE id IN (5455111, 5449743, 5448865, 5445988, 5445705, 5444541, 5444395, 5442638, 5442274, 5441534, 5440096, 5440024, 5438739, 5437298, 5436668, 5436326, 5433284, 5430618, 5429983, 5429951, 5425638, 5423369, 5423329, 5420667, 5419360, 5419086, 5408229, 5401634, 5398457, 5381745, 5230687, 5455123, 5455122, 5455118, 5452483, 5448361, 5448283, 5446862, 5444980, 5444800, 5444796, 5444684, 5443962, 5443266, 5442369, 5441967, 5441088, 5441055, 5439583, 5439136, 5437687, 5436958, 5435318, 5434539, 5433265, 5431261, 5430704, 5429837, 5429706, 5429145, 5428152, 5428132, 5427928, 5426814, 5422454, 5419198, 5415315, 5413944, 5411025, 5390842, 5385204, 5381412, 5370995, 5363604, 5449828, 5445284, 5444379, 5441526, 5441303, 5441045, 5440064, 5438751, 5437926, 5437326, 5436319, 5434489, 5429385, 5427618, 5427388, 5420543, 5419073, 5409121, 5405912, 5403663, 5400212, 5395871, 5381191, 5370200, 5222794, 5455125, 5452510, 5452424, 5448160, 5444367, 5441621, 5439122, 5435937, 5434829, 5434550, 5433295, 5431747, 5423611, 5422419, 5420311, 5416466, 5397882, 5394080, 5455137, 5455121, 5452468, 5452397, 5446806, 5444329, 5443826, 5443676, 5443416, 5443244, 5440982, 5440079, 5438624, 5438359, 5437311, 5434527, 5434335, 5433962, 5433356, 5432911, 5430966, 5429173, 5428290, 5421481, 5420448, 5416625, 5402438, 5393953, 5357605, 5455136, 5455124, 5455107, 5455106, 5452458, 5452422, 5452415, 5452351, 5449439, 5449035, 5448983, 5448461, 5448395, 5448297, 5448181, 5448152, 5446519, 5446280, 5445796, 5445745, 5445417, 5444705, 5443803, 5443041, 5442333, 5440136, 5437616, 5436860, 5434768, 5434467, 5432736, 5430900, 5428160, 5428080, 5426584, 5420704, 5420034, 5419099, 5410515, 5402341, 5395500, 5347690, 5455184, 5455112, 5452516, 5448774, 5448401, 5445266, 5444666, 5444575, 5443634, 5442941, 5442801, 5442384, 5439707, 5438933, 5438550, 5437738, 5436910, 5436481, 5436045, 5435437, 5434570, 5434368, 5433067, 5432716, 5432709, 5430176, 5429903, 5428606, 5423400, 5422395, 5422285, 5420757, 5420649, 5416472, 5415651, 5400983, 5398971, 5398621, 5455138, 5447994, 5445957, 5445278, 5445218, 5443568, 5439646, 5437349, 5435721, 5429681, 5428138, 5423518, 5417255, 5415510, 5415307, 5411423, 5406928, 5405888, 5396344, 5395390, 5392533, 5390095, 5348412, 5321614, 5245725, 5237881);

[ Date: 2025-02-19 16:28:39 ]

SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL)))) AND ("policy_number"."name"::text ilike '%4%')) ORDER BY "policy_number"."id" LIMIT 8;

[ Date: 2025-02-19 16:20:21 ]

DELETE FROM "res_partner" WHERE id IN (8007314, 8005377, 8007285, 8006451, 8005374, 8007349);

[ Date: 2025-02-19 13:48:19 ]

UPDATE "policy_number" SET "done" = true, "write_date" = '2025-02-19 20:56:10.921511', "write_uid" = 1451 WHERE id IN (44672229);

[ Date: 2025-02-19 21:56:56 ]

DELETE FROM "res_partner" WHERE id IN (8005786, 8006693, 8006834, 8005788, 8005790);

[ Date: 2025-02-19 13:50:01 ]

DELETE FROM "delegate_track" WHERE id IN (175596);

[ Date: 2025-02-19 20:01:43 ]

UPDATE "shipping_policy" SET "before_office_id" = 70, "write_date" = '2025-02-18 23:17:22.764070', "write_uid" = 1010 WHERE id IN (5515519, 5515517, 5515512, 5515504, 5515483, 5515470, 5515431, 5515420, 5515418, 5515412, 5515393, 5515344, 5515337, 5515239, 5508956, 5498703);

[ Date: 2025-02-19 00:17:47 ]

UPDATE "policy_number" SET "done" = true, "write_date" = '2025-02-19 19:30:32.152660', "write_uid" = 1238 WHERE id IN (44644149);

[ Date: 2025-02-19 20:30:54 ]

UPDATE "shipping_policy" SET "client_date" = '2025-02-19', "client_delivery_button" = true, "edit_cash_button" = false, "receive_man_id" = 'بوسف نبيل', "return_button" = true, "state" = 'client_receive', "write_date" = '2025-02-19 18:10:32.965866', "write_uid" = 1027 WHERE id IN (5508973, 5502130, 5512213, 5509039, 5508742, 5498040, 5492673, 5521372, 5521370, 5514808, 5496129, 5494387, 5496841, 5457611, 5490565, 5496899, 5511057, 5492923, 5524413, 5512187, 5520455);

[ Date: 2025-02-19 19:11:48 ]

SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE ((("shipping_policy"."active" = true) AND (("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL)) AND (("shipping_policy"."out_date" = '2025-02-18') AND (("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%دمنهور%'))) AND ((("shipping_policy"."state" = 'in_way_to_client') OR ("shipping_policy"."state" = 'client_receive')) AND (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%همام%') OR ("res_partner"."email"::text ilike '%همام%')) OR ("res_partner"."ref"::text ilike '%همام%')) OR ("res_partner"."vat"::text ilike '%همام%')) OR ("res_partner"."company_registry"::text ilike '%همام%')) 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 (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%مخزن%') OR ("res_partner"."email"::text ilike '%مخزن%')) OR ("res_partner"."ref"::text ilike '%مخزن%')) OR ("res_partner"."vat"::text ilike '%مخزن%')) OR ("res_partner"."company_registry"::text ilike '%مخزن%')) 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 (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%رفيق%') OR ("res_partner"."email"::text ilike '%رفيق%')) OR ("res_partner"."ref"::text ilike '%رفيق%')) OR ("res_partner"."vat"::text ilike '%رفيق%')) OR ("res_partner"."company_registry"::text ilike '%رفيق%')) 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 (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%متولى%') OR ("res_partner"."email"::text ilike '%متولى%')) OR ("res_partner"."ref"::text ilike '%متولى%')) OR ("res_partner"."vat"::text ilike '%متولى%')) OR ("res_partner"."company_registry"::text ilike '%متولى%')) 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 (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%صباح%') OR ("res_partner"."email"::text ilike '%صباح%')) OR ("res_partner"."ref"::text ilike '%صباح%')) OR ("res_partner"."vat"::text ilike '%صباح%')) OR ("res_partner"."company_registry"::text ilike '%صباح%')) 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 (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%اشرف%') OR ("res_partner"."email"::text ilike '%اشرف%')) OR ("res_partner"."ref"::text ilike '%اشرف%')) OR ("res_partner"."vat"::text ilike '%اشرف%')) OR ("res_partner"."company_registry"::text ilike '%اشرف%')) 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 (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%اسلام%') OR ("res_partner"."email"::text ilike '%اسلام%')) OR ("res_partner"."ref"::text ilike '%اسلام%')) OR ("res_partner"."vat"::text ilike '%اسلام%')) OR ("res_partner"."company_registry"::text ilike '%اسلام%')) 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 (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%كريم عصام%') OR ("res_partner"."email"::text ilike '%كريم عصام%')) OR ("res_partner"."ref"::text ilike '%كريم عصام%')) OR ("res_partner"."vat"::text ilike '%كريم عصام%')) OR ("res_partner"."company_registry"::text ilike '%كريم عصام%')) 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 (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%احمد عصام%') OR ("res_partner"."email"::text ilike '%احمد عصام%')) OR ("res_partner"."ref"::text ilike '%احمد عصام%')) OR ("res_partner"."vat"::text ilike '%احمد عصام%')) OR ("res_partner"."company_registry"::text ilike '%احمد عصام%')) 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 (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%زغلول%') OR ("res_partner"."email"::text ilike '%زغلول%')) OR ("res_partner"."ref"::text ilike '%زغلول%')) OR ("res_partner"."vat"::text ilike '%زغلول%')) OR ("res_partner"."company_registry"::text ilike '%زغلول%')) 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 (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%محمد رشاد%') OR ("res_partner"."email"::text ilike '%محمد رشاد%')) OR ("res_partner"."ref"::text ilike '%محمد رشاد%')) OR ("res_partner"."vat"::text ilike '%محمد رشاد%')) OR ("res_partner"."company_registry"::text ilike '%محمد رشاد%')) 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 (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%معتز%') OR ("res_partner"."email"::text ilike '%معتز%')) OR ("res_partner"."ref"::text ilike '%معتز%')) OR ("res_partner"."vat"::text ilike '%معتز%')) OR ("res_partner"."company_registry"::text ilike '%معتز%')) 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 (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%علي محمد%') OR ("res_partner"."email"::text ilike '%علي محمد%')) OR ("res_partner"."ref"::text ilike '%علي محمد%')) OR ("res_partner"."vat"::text ilike '%علي محمد%')) OR ("res_partner"."company_registry"::text ilike '%علي محمد%')) 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 (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%عبدالرحمن%') OR ("res_partner"."email"::text ilike '%عبدالرحمن%')) OR ("res_partner"."ref"::text ilike '%عبدالرحمن%')) OR ("res_partner"."vat"::text ilike '%عبدالرحمن%')) OR ("res_partner"."company_registry"::text ilike '%عبدالرحمن%')) 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 (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%عبد الفتاح%') OR ("res_partner"."email"::text ilike '%عبد الفتاح%')) OR ("res_partner"."ref"::text ilike '%عبد الفتاح%')) OR ("res_partner"."vat"::text ilike '%عبد الفتاح%')) OR ("res_partner"."company_registry"::text ilike '%عبد الفتاح%')) 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 (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%علي محمد%') OR ("res_partner"."email"::text ilike '%علي محمد%')) OR ("res_partner"."ref"::text ilike '%علي محمد%')) OR ("res_partner"."vat"::text ilike '%علي محمد%')) OR ("res_partner"."company_registry"::text ilike '%علي محمد%')) 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 (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%منشاوي%') OR ("res_partner"."email"::text ilike '%منشاوي%')) OR ("res_partner"."ref"::text ilike '%منشاوي%')) OR ("res_partner"."vat"::text ilike '%منشاوي%')) OR ("res_partner"."company_registry"::text ilike '%منشاوي%')) 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 (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%شوشة%') OR ("res_partner"."email"::text ilike '%شوشة%')) OR ("res_partner"."ref"::text ilike '%شوشة%')) OR ("res_partner"."vat"::text ilike '%شوشة%')) OR ("res_partner"."company_registry"::text ilike '%شوشة%')) 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 (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%احمد عصام%') OR ("res_partner"."email"::text ilike '%احمد عصام%')) OR ("res_partner"."ref"::text ilike '%احمد عصام%')) OR ("res_partner"."vat"::text ilike '%احمد عصام%')) OR ("res_partner"."company_registry"::text ilike '%احمد عصام%')) 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 (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%انور%') OR ("res_partner"."email"::text ilike '%انور%')) OR ("res_partner"."ref"::text ilike '%انور%')) OR ("res_partner"."vat"::text ilike '%انور%')) OR ("res_partner"."company_registry"::text ilike '%انور%')) 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 ("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%تامر%') OR ("res_partner"."email"::text ilike '%تامر%')) OR ("res_partner"."ref"::text ilike '%تامر%')) OR ("res_partner"."vat"::text ilike '%تامر%')) OR ("res_partner"."company_registry"::text ilike '%تامر%')) 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)))))))))))))))))))))))))))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (28)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (28))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (28))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) LIMIT 10001) t;

[ Date: 2025-02-19 12:19:28 ]

SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL)))) AND ("policy_number"."name"::text ilike '%46%')) ORDER BY "policy_number"."id" LIMIT 8;