Referensi RPC

Halaman ini digenerate otomatis oleh scripts/generate-rpc-reference.mjs dari 579 fungsi public.* yang ditemukan di supabase/migrations/ pada repo aplikasi. Jangan edit tabel di bawah secara manual — jalankan ulang skripnya setelah migrasi berubah (lihat README situs ini).

Kolom Keamanan menandai fungsi security definer (berjalan dengan hak pemilik fungsi, dipakai untuk mem-bypass RLS secara terkontrol — lihat Model Keamanan).

activity_*

Fungsi	Argumen	Keamanan	Migrasi sumber
activity_log_list	p_limit integer default 30, p_offset integer default 0	🔒	20260905154724_activity_log_view.sql
activity_log_list_by_order	p_order_id text	🔒	20260905164523_order_detail_activity.sql

ai_*

Fungsi	Argumen	Keamanan	Migrasi sumber
ai_chat_business_context	—	🔒	20260909071500_ai_chat_business_context_rpc.sql
ai_daily_summary_data	—	🔒	20260909080000_ai_daily_summary_rpc.sql
ai_daily_summary_save	p_summary text	🔒	20260909080000_ai_daily_summary_rpc.sql
ai_demand_order_history	p_lookback_days integer	🔒	20260909065130_ai_demand_order_history_rpc.sql

alert_*

Fungsi	Argumen	Keamanan	Migrasi sumber
alert_settings_get	—	🔒	0062_notification_center_domain.sql
alert_settings_save	p_unconfirmed_order_hours numeric, p_unpaid_reminder_days numeric, p_alert_today_not_produced boolean, p_alert_low_stock boolean	🔒	0063_fix_alert_settings_actor.sql

analytics_*

Fungsi	Argumen	Keamanan	Migrasi sumber
analytics_get	—	🔒	20260906100000_analytics_domain_rpc.sql
analytics_order_stats	—	🔒	20260906175000_analytics_order_stats_rpc.sql

announcement_*

Fungsi	Argumen	Keamanan	Migrasi sumber
announcement_active_for_role	p_role text default null	🔒	0095_announcements_domain.sql
announcement_actor	p_manage boolean default false	🔒	0095_announcements_domain.sql
announcement_create	p_document jsonb	🔒	0095_announcements_domain.sql
announcement_delete	p_id text	🔒	0095_announcements_domain.sql
announcement_list	—	🔒	0095_announcements_domain.sql
announcement_update	p_id text,p_patch jsonb	🔒	0095_announcements_domain.sql
announcement_validate	p_document jsonb		0095_announcements_domain.sql

apply_*

Fungsi	Argumen	Keamanan	Migrasi sumber
apply_order_transaction_side_effects	—	🔒	0016_cash_book_domain_adapter.sql

approval_*

Fungsi	Argumen	Keamanan	Migrasi sumber
approval_actor	p_scope text default 'request'	🔒	0097_approval_workflow.sql
approval_by_entity	p_entity_id text	🔒	0097_approval_workflow.sql
approval_list	p_status text default null	🔒	0097_approval_workflow.sql
approval_request	p_entity_id text,p_description text	🔒	0097_approval_workflow.sql
approval_review	p_id text,p_decision text,p_notes text default null	🔒	0097_approval_workflow.sql
approval_settings_get	—	🔒	0097_approval_workflow.sql
approval_settings_save	p_enabled boolean,p_threshold numeric	🔒	0097_approval_workflow.sql
approval_stats	—	🔒	0097_approval_workflow.sql

asset_*

Fungsi	Argumen	Keamanan	Migrasi sumber
asset_document_delete	p_table_name text, p_convex_id text	🔒	0083_asset_management.sql
asset_document_save	p_table_name text, p_convex_id text, p_document jsonb	🔒	0083_asset_management.sql

audit_*

Fungsi	Argumen	Keamanan	Migrasi sumber
audit_logistics_read	—	🔒	20260906178000_audit_logistics_read_rpc.sql

barcode_*

Fungsi	Argumen	Keamanan	Migrasi sumber
barcode_inventory_actor	—	🔒	0109_barcode_inventory_operations.sql
barcode_lookup	p_barcode_value text	🔒	0109_barcode_inventory_operations.sql
barcode_remove	p_ingredient_id text	🔒	0109_barcode_inventory_operations.sql
barcode_set	p_ingredient_id text,p_barcode_value text	🔒	0110_barcode_uniqueness_lock.sql
barcode_stock_change	p_barcode_value text,p_amount numeric,p_note text default null	🔒	0109_barcode_inventory_operations.sql

can_*

Fungsi	Argumen	Keamanan	Migrasi sumber
can_act_on_delivery	p_order_id text	🔒	0019_delivery_domain_adapter.sql
can_manage_cash	p_action text default 'write'	🔒	0016_cash_book_domain_adapter.sql
can_manage_customers	—	🔒	0008_customer_domain_adapter.sql
can_manage_finance	—	🔒	0029_bank_reconciliation_domain.sql
can_manage_hr	—	🔒	0032_employee_attendance_domain.sql
can_manage_inventory	—	🔒	0022_inventory_recipe_domain.sql
can_manage_master	—	🔒	0010_product_master_adapter.sql
can_manage_orders	p_action text, p_target_status text default null	🔒	0014_order_transaction_side_effects.sql
can_manage_prasmanan_inquiries	—	🔒	0087_prasmanan_inquiries_checklist.sql
can_manage_prasmanan_menu	—	🔒	0086_prasmanan_menu.sql
can_manage_procurement	—	🔒	0025_supplier_domain.sql
can_manage_promo_banners	—	🔒	0076_profile_photos_and_promo_banners.sql
can_manage_recipes	—	🔒	0022_inventory_recipe_domain.sql
can_manage_warehouses	—	🔒	0028_warehouse_domain.sql
can_receive_goods	—	🔒	0027_goods_receipt_domain.sql

capacity_*

Fungsi	Argumen	Keamanan	Migrasi sumber
capacity_for_date	p_date date default null	🔒	20260905155943_fix_capacity_greatest.sql
capacity_settings_get	—	🔒	20260905155544_capacity_domain.sql
capacity_settings_save	p_max_orders integer,p_max_quantity numeric,p_warning integer,p_active boolean	🔒	20260905155544_capacity_domain.sql

cash_*

Fungsi	Argumen	Keamanan	Migrasi sumber
cash_book_project	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	0014_order_transaction_side_effects.sql
cash_category_delete	p_convex_id text	🔒	0016_cash_book_domain_adapter.sql
cash_category_save	p_name text, p_type text	🔒	0016_cash_book_domain_adapter.sql
cash_entry_delete	p_convex_id text	🔒	0016_cash_book_domain_adapter.sql
cash_entry_save	p_convex_id text, p_document jsonb	🔒	0016_cash_book_domain_adapter.sql
cash_entry_transition	p_convex_ids text[], p_action text, p_note text default null	🔒	0016_cash_book_domain_adapter.sql
cash_recalculate_balances	—	🔒	0016_cash_book_domain_adapter.sql
cash_seed_defaults	—	🔒	0016_cash_book_domain_adapter.sql

cctv_*

Fungsi	Argumen	Keamanan	Migrasi sumber
cctv_config_mutate	p_action text,p_id text default null,p_payload jsonb default '{}'::jsonb	🔒	20261011150000_cctv_config_canonical.sql

chat_*

Fungsi	Argumen	Keamanan	Migrasi sumber
chat_actor_id	—	🔒	0064_chat_core_normalized.sql
chat_can_access	p_conversation_id text	🔒	0064_chat_core_normalized.sql
chat_conversation_archive	p_conversation_id text, p_archived boolean	🔒	0064_chat_core_normalized.sql
chat_conversation_create_direct	p_other_user_id text	🔒	0064_chat_core_normalized.sql
chat_conversation_create_group	p_name text, p_member_ids text[]	🔒	0064_chat_core_normalized.sql
chat_conversation_delete	p_conversation_id text	🔒	0067_chat_core_operations.sql
chat_conversation_get	p_conversation_id text	🔒	0067_chat_core_operations.sql
chat_conversation_mark_read	p_conversation_id text	🔒	0064_chat_core_normalized.sql
chat_conversations_list	p_archived boolean default false	🔒	0064_chat_core_normalized.sql
chat_disappearing_get	p_conversation_id text	🔒	0068_chat_interactions.sql
chat_disappearing_set	p_conversation_id text, p_duration bigint	🔒	0068_chat_interactions.sql
chat_group_add_members	p_conversation_id text, p_member_ids text[]	🔒	0067_chat_core_operations.sql
chat_group_leave	p_conversation_id text	🔒	0067_chat_core_operations.sql
chat_group_remove_member	p_conversation_id text, p_user_id text	🔒	0067_chat_core_operations.sql
chat_group_update_name	p_conversation_id text, p_name text	🔒	0067_chat_core_operations.sql
chat_message_broadcast	p_conversation_ids text[],p_message jsonb	🔒	0071_chat_polls_and_delivery.sql
chat_message_delete	p_message_id text	🔒	0067_chat_core_operations.sql
chat_message_edit	p_message_id text, p_content text	🔒	0067_chat_core_operations.sql
chat_message_forward	p_message_id text,p_target_conversation_id text	🔒	0071_chat_polls_and_delivery.sql
chat_message_read_by	p_message_id text	🔒	0071_chat_polls_and_delivery.sql
chat_message_send	p_conversation_id text, p_message jsonb	🔒	0064_chat_core_normalized.sql
chat_message_toggle_pin	p_message_id text	🔒	0067_chat_core_operations.sql
chat_messages_list	p_conversation_id text, p_limit integer default 50, p_before timestamptz default null	🔒	0064_chat_core_normalized.sql
chat_messages_search	p_conversation_id text, p_query text	🔒	0068_chat_interactions.sql
chat_messages_search_global	p_query text	🔒	0072_chat_scheduling_and_global_search.sql
chat_pinned_messages	p_conversation_id text	🔒	0067_chat_core_operations.sql
chat_poll_close	p_poll_id text	🔒	0071_chat_polls_and_delivery.sql
chat_poll_create	p_conversation_id text,p_question text,p_options text[]	🔒	0071_chat_polls_and_delivery.sql
chat_poll_get	p_poll_id text	🔒	0071_chat_polls_and_delivery.sql
chat_poll_vote	p_poll_id text,p_option_id text	🔒	0071_chat_polls_and_delivery.sql
chat_reaction_toggle	p_message_id text, p_emoji text	🔒	0068_chat_interactions.sql
chat_reactions_for_messages	p_message_ids text[]	🔒	0068_chat_interactions.sql
chat_read_status	p_conversation_id text	🔒	0067_chat_core_operations.sql
chat_scheduled_cancel	p_scheduled_message_id text	🔒	0072_chat_scheduling_and_global_search.sql
chat_scheduled_create	p_conversation_id text,p_message jsonb,p_scheduled_at timestamptz	🔒	0072_chat_scheduling_and_global_search.sql
chat_scheduled_dispatch_due	—	🔒	0072_chat_scheduling_and_global_search.sql
chat_scheduled_list	p_conversation_id text default null	🔒	0072_chat_scheduling_and_global_search.sql
chat_starred_ids	p_conversation_id text	🔒	0068_chat_interactions.sql
chat_starred_list	p_conversation_id text	🔒	0069_chat_interactions_ui_compat.sql
chat_starred_toggle	p_message_id text	🔒	0068_chat_interactions.sql
chat_stories_list_active	—	🔒	0073_chat_stories.sql
chat_story_create_image	p_image_path text, p_caption text default null	🔒	0073_chat_stories.sql
chat_story_create_text	p_text text, p_background_color text, p_caption text default null	🔒	0073_chat_stories.sql
chat_story_delete	p_story_id text	🔒	0073_chat_stories.sql
chat_story_view	p_story_id text	🔒	0073_chat_stories.sql
chat_story_viewers	p_story_id text	🔒	0073_chat_stories.sql
chat_theme_get	p_conversation_id text	🔒	0068_chat_interactions.sql
chat_theme_set	p_conversation_id text, p_theme text, p_wallpaper text default null	🔒	0069_chat_interactions_ui_compat.sql
chat_total_unread	—	🔒	0065_chat_unread_normalized.sql
chat_typing_clear	p_conversation_id text	🔒	0070_chat_typing_and_storage.sql
chat_typing_list	p_conversation_id text	🔒	0070_chat_typing_and_storage.sql
chat_typing_set	p_conversation_id text	🔒	0070_chat_typing_and_storage.sql
chat_users_list	—	🔒	0066_allow_self_chat_identity.sql

cleanup_*

Fungsi	Argumen	Keamanan	Migrasi sumber
cleanup_deleted_order_side_effects	—	🔒	0016_cash_book_domain_adapter.sql

complaint_*

Fungsi	Argumen	Keamanan	Migrasi sumber
complaint_create	p_document jsonb	🔒	20261011110000_complaints_foodwaste_canonical.sql
complaint_delete	p_convex_id text	🔒	20261011110000_complaints_foodwaste_canonical.sql
complaint_update_status	p_convex_id text,p_status text,p_resolution_notes text default null	🔒	20261011110000_complaints_foodwaste_canonical.sql

credit_*

Fungsi	Argumen	Keamanan	Migrasi sumber
credit_actor	p_manager_only boolean default false	🔒	0102_credit_aging_domain.sql
credit_aging_report	—	🔒	0103_fix_credit_aging_numeric_types.sql
credit_customer_by_phone	p_phone text	🔒	0103_fix_credit_aging_numeric_types.sql
credit_limit_set	p_customer_id text,p_credit_limit numeric	🔒	0102_credit_aging_domain.sql
credit_normalize_phone	p_phone text	🔒	0102_credit_aging_domain.sql

current_*

Fungsi	Argumen	Keamanan	Migrasi sumber
current_app_role	—	🔒	20260906061128_normalize_current_app_role.sql

customer_*

Fungsi	Argumen	Keamanan	Migrasi sumber
customer_adjust_loyalty	p_customer_id text, p_type text, p_points integer, p_description text	🔒	20261011090000_customers_write_path_projection.sql
customer_delete	p_convex_id text	🔒	0008_customer_domain_adapter.sql
customer_merge	p_primary_id text, p_duplicate_ids text[]	🔒	0009_customer_detail_and_merge.sql
customer_patch	p_convex_id text, p_patch jsonb	🔒	0009_customer_detail_and_merge.sql
customer_save	p_convex_id text, p_document jsonb	🔒	0008_customer_domain_adapter.sql
customer_set_vip_threshold	p_threshold integer	🔒	20261011091500_fix_vip_threshold_bulk_update_where.sql

daily_*

Fungsi	Argumen	Keamanan	Migrasi sumber
daily_schedule_for_date	p_date text	🔒	0098_daily_schedule_whatsapp_blast.sql
daily_schedule_phones	p_date text	🔒	0098_daily_schedule_whatsapp_blast.sql
daily_schedule_remove	p_id text	🔒	0098_daily_schedule_whatsapp_blast.sql
daily_schedule_save	p_date text,p_employee_ids jsonb	🔒	0098_daily_schedule_whatsapp_blast.sql
daily_schedule_status	p_id text,p_status text	🔒	0098_daily_schedule_whatsapp_blast.sql
daily_schedule_workers	—	🔒	0098_daily_schedule_whatsapp_blast.sql

delivery_*

Fungsi	Argumen	Keamanan	Migrasi sumber
delivery_assign	p_order_ids text[], p_driver_id text, p_driver_name text, p_vehicle_name text, p_note text	🔒	0019_delivery_domain_adapter.sql
delivery_log_add	p_order_id text, p_order_number text, p_status text, p_note text, p_vehicle_name text, p_lat numeric, p_lng numeric	🔒	0019_delivery_domain_adapter.sql
delivery_notes_for_orders	p_order_ids text[]	🔒	0021_delivery_filtered_notes.sql
delivery_notification_log	p_order_id text, p_order_number text, p_trigger text, p_channel text, p_recipient text, p_status text, p_error_message text	🔒	0020_delivery_workflow_extensions.sql
delivery_save_proof	p_order_id text, p_storage_id text, p_caption text	🔒	20260912180000_delivery_proof_integrity.sql
delivery_set_coords	p_order_id text, p_lat numeric, p_lng numeric	🔒	0020_delivery_workflow_extensions.sql
delivery_undo_failed	p_order_id text	🔒	0020_delivery_workflow_extensions.sql
delivery_update_driver_location	p_order_id text, p_lat numeric, p_lng numeric	🔒	0020_delivery_workflow_extensions.sql
delivery_update_location	p_lat numeric, p_lng numeric, p_accuracy numeric, p_is_active boolean, p_current_order_id text	🔒	0020_delivery_workflow_extensions.sql
delivery_zone_delete	p_convex_id text	🔒	20261011100000_sales_config_zones_promo_canonical.sql
delivery_zone_save	p_convex_id text, p_document jsonb	🔒	20261011100000_sales_config_zones_promo_canonical.sql

display_*

Fungsi	Argumen	Keamanan	Migrasi sumber
display_delivery_board	p_key text	🔒	0105_operational_calendar_display_views.sql
display_get_key	—	🔒	0051_public_review_statistics.sql
display_regenerate_key	—	🔒	0051_public_review_statistics.sql
display_valid_key	p_key text	🔒	0051_public_review_statistics.sql

enqueue_*

Fungsi	Argumen	Keamanan	Migrasi sumber
enqueue_chat_push	—	🔒	0080_web_push_queue_hardening.sql
enqueue_order_status_push	—	🔒	0080_web_push_queue_hardening.sql

event_*

Fungsi	Argumen	Keamanan	Migrasi sumber
event_actor	—	🔒	0094_events_domain.sql
event_calendar	p_year integer,p_month integer	🔒	0094_events_domain.sql
event_check_clash	p_event_date text,p_start_time text,p_end_time text default null,p_location text default null,p_exclude_id text default null	🔒	0094_events_domain.sql
event_create	p_document jsonb	🔒	0094_events_domain.sql
event_delete	p_id text	🔒	0094_events_domain.sql
event_list	p_status text default null,p_search text default null,p_limit integer default 200	🔒	0094_events_domain.sql
event_time_minutes	p_time text		0094_events_domain.sql
event_update	p_id text,p_document jsonb	🔒	0094_events_domain.sql
event_validate	p_document jsonb		0094_events_domain.sql

executive_*

Fungsi	Argumen	Keamanan	Migrasi sumber
executive_dashboard_summary	p_period text default 'week'	🔒	20260906181000_executive_dashboard_rpc.sql
executive_sop_metrics	—	🔒	20260906182000_executive_sop_metrics.sql

finance_*

Fungsi	Argumen	Keamanan	Migrasi sumber
finance_bank_account_delete	p_convex_id text	🔒	0029_bank_reconciliation_domain.sql
finance_bank_account_save	p_convex_id text, p_document jsonb	🔒	0029_bank_reconciliation_domain.sql
finance_budget_comparison	p_month text	🔒	0031_payables_and_budget_domain.sql
finance_budget_copy	p_source_month text, p_target_month text	🔒	0031_payables_and_budget_domain.sql
finance_budget_delete	p_convex_id text	🔒	0031_payables_and_budget_domain.sql
finance_budget_upsert	p_month text, p_category text, p_amount numeric, p_notes text default null	🔒	0031_payables_and_budget_domain.sql
finance_expense_delete	p_convex_id text	🔒	0030_operational_expenses_domain.sql
finance_expense_save	p_convex_id text, p_document jsonb	🔒	0030_operational_expenses_domain.sql
finance_reconciliation_save	p_document jsonb	🔒	0029_bank_reconciliation_domain.sql
finance_statement_line_delete	p_convex_id text	🔒	0029_bank_reconciliation_domain.sql
finance_statement_line_save	p_convex_id text, p_document jsonb	🔒	0029_bank_reconciliation_domain.sql
finance_statement_line_transition	p_convex_id text, p_action text, p_matched_with text, p_matched_type text, p_notes text	🔒	0029_bank_reconciliation_domain.sql
finance_supplier_payment_create	p_po_id text, p_amount numeric, p_paid_at text, p_method text, p_notes text default null	🔒	0031_payables_and_budget_domain.sql
finance_supplier_payment_delete	p_payment_id text	🔒	0031_payables_and_budget_domain.sql

follow_*

Fungsi	Argumen	Keamanan	Migrasi sumber
follow_up_log_action	p_convex_id text,p_action text	🔒	0046_customer_follow_up_domain.sql
follow_up_order_trigger	—	🔒	0046_customer_follow_up_domain.sql
follow_up_schedule_order	p_order_id text	🔒	0047_follow_up_fractional_delay.sql
follow_up_settings_save	p_document jsonb	🔒	0048_follow_up_settings_compatibility.sql
follow_up_trigger_delivered	—	🔒	0046_customer_follow_up_domain.sql

food_*

Fungsi	Argumen	Keamanan	Migrasi sumber
food_waste_delete	p_convex_id text	🔒	20261011110000_complaints_foodwaste_canonical.sql
food_waste_save	p_convex_id text,p_document jsonb	🔒	20261011110000_complaints_foodwaste_canonical.sql

global_*

Fungsi	Argumen	Keamanan	Migrasi sumber
global_command_search	p_query text, p_category text default 'all'	🔒	0077_global_search_and_health.sql

handle_*

Fungsi	Argumen	Keamanan	Migrasi sumber
handle_new_user	—	🔒	0002_identity_and_rls.sql

hpp_*

Fungsi	Argumen	Keamanan	Migrasi sumber
hpp_mutate	p_action text,p_id text default null,p_payload jsonb default '{}'::jsonb	🔒	20260906186000_hpp_mutate_rpc.sql

hr_*

Fungsi	Argumen	Keamanan	Migrasi sumber
hr_attendance_bulk	p_date text, p_entries jsonb	🔒	0032_employee_attendance_domain.sql
hr_attendance_config_get	—	🔒	0034_attendance_self_service_domain.sql
hr_attendance_config_save	p_document jsonb	🔒	0034_attendance_self_service_domain.sql
hr_attendance_correct	p_convex_id text, p_status text, p_check_in text default null, p_check_out text default null, p_note text default null	🔒	0032_employee_attendance_domain.sql
hr_attendance_record	p_employee_id text, p_date text, p_status text, p_check_in text default null, p_check_out text default null, p_note text default null	🔒	20261011120000_employees_attendance_canonical.sql
hr_bukti_potong_all	p_year integer	🔒	20260905170959_bukti_potong_rpc.sql
hr_calendar_config_get	—	🔒	0034_attendance_self_service_domain.sql
hr_calendar_working_days_save	p_working_days jsonb	🔒	0034_attendance_self_service_domain.sql
hr_employee_delete	p_convex_id text	🔒	20261011120000_employees_attendance_canonical.sql
hr_employee_photo_remove	p_employee_id text	🔒	20261011120000_employees_attendance_canonical.sql
hr_employee_photo_set	p_employee_id text, p_object_path text	🔒	20261011120000_employees_attendance_canonical.sql
hr_employee_save	p_convex_id text, p_document jsonb	🔒	20261011120000_employees_attendance_canonical.sql
hr_holiday_delete	p_convex_id text	🔒	0034_attendance_self_service_domain.sql
hr_holiday_save	p_convex_id text,p_date text,p_name text,p_type text	🔒	0034_attendance_self_service_domain.sql
hr_holidays_bulk_add	p_holidays jsonb	🔒	0034_attendance_self_service_domain.sql
hr_holidays_year	p_year integer	🔒	0034_attendance_self_service_domain.sql
hr_loan_action	p_loan_id text,p_action text,p_payload jsonb default '{}'::jsonb	🔒	20261014102000_loans_canonical.sql
hr_loan_bulk_disburse	p_loan_ids text[]	🔒	0043_employee_loans_domain.sql
hr_loan_config_save	p_key text,p_value numeric	🔒	20261014102000_loans_canonical.sql
hr_loan_create	p_document jsonb,p_submission boolean default false	🔒	20261014102000_loans_canonical.sql
hr_loan_history	p_loan_id text,p_from text,p_to text,p_actor text,p_notes text default null	🔒	20261014102000_loans_canonical.sql
hr_loan_type_delete	p_convex_id text	🔒	20261014102000_loans_canonical.sql
hr_loan_type_save	p_convex_id text,p_document jsonb	🔒	20261014102000_loans_canonical.sql
hr_payroll_batch_action	p_batch_id text,p_action text,p_notes text default null	🔒	20261014100000_payroll_core_canonical.sql
hr_payroll_batch_create	p_period_id text,p_working_days integer,p_notes text default null	🔒	20261014100000_payroll_core_canonical.sql
hr_payroll_compute	p_employee jsonb, p_input jsonb	🔒	0041_payroll_self_service.sql
hr_payroll_my_slip_detail	p_slip_id text	🔒	0041_payroll_self_service.sql
hr_payroll_my_slips	—	🔒	0041_payroll_self_service.sql
hr_payroll_period_action	p_period_id text,p_action text	🔒	20261014100000_payroll_core_canonical.sql
hr_payroll_period_create	p_month text,p_notes text default null	🔒	20261014100000_payroll_core_canonical.sql
hr_payroll_preview	p_employee_id text,p_input jsonb	🔒	0033_payroll_core_domain.sql
hr_payroll_recalculate_period	p_period_id text	🔒	20261014100000_payroll_core_canonical.sql
hr_payroll_slip_action	p_slip_id text,p_action text	🔒	20261014100000_payroll_core_canonical.sql
hr_payroll_slip_upsert	p_period_id text,p_employee_id text,p_input jsonb	🔒	20261014100000_payroll_core_canonical.sql
hr_payroll_slips_generate	p_period_id text,p_working_days numeric	🔒	0039_fix_payroll_generator_loan_label.sql
hr_self_attendance_clock	p_action text	🔒	0034_attendance_self_service_domain.sql
hr_self_attendance_data	p_scope text,p_month text default null	🔒	0034_attendance_self_service_domain.sql
hr_spt_masa	p_month text	🔒	20260905171620_spt_reports_rpc.sql
hr_spt_monthly_summaries	p_year integer	🔒	20260905171620_spt_reports_rpc.sql
hr_spt_tahunan	p_year integer	🔒	20260905171620_spt_reports_rpc.sql
hr_tax_config_delete	p_convex_id text	🔒	20261014100000_payroll_core_canonical.sql
hr_tax_config_save	p_document jsonb	🔒	20261014100000_payroll_core_canonical.sql
hr_tax_config_seed	p_configs jsonb	🔒	0036_payroll_tax_config_domain.sql
hr_thr_action	p_year integer,p_action text,p_slip_id text default null	🔒	20261014101000_thr_canonical.sql
hr_thr_config_save	p_document jsonb	🔒	20261014101000_thr_canonical.sql
hr_thr_data	p_year integer	🔒	0040_thr_domain.sql
hr_thr_generate	p_year integer	🔒	20261014101000_thr_canonical.sql
hr_thr_progressive_tax	p_taxable numeric	🔒	0040_thr_domain.sql
hr_thr_tax	p_employee jsonb,p_thr_amount numeric	🔒	0040_thr_domain.sql
hr_user_employee_link	p_user_id uuid,p_employee_id text	🔒	0035_allow_hr_employee_linking.sql
hr_user_employee_links	—	🔒	0034_attendance_self_service_domain.sql

incident_*

Fungsi	Argumen	Keamanan	Migrasi sumber
incident_corrective_action	p_id text,p_action text	🔒	0092_internal_issues.sql
incident_create	p_document jsonb	🔒	0092_internal_issues.sql
incident_update_status	p_id text,p_status text	🔒	0092_internal_issues.sql

inquiry_*

Fungsi	Argumen	Keamanan	Migrasi sumber
inquiry_event_order_link_get	p_inquiry_id text		20260912072557_inquiry_event_order_integration.sql

institution_*

Fungsi	Argumen	Keamanan	Migrasi sumber
institution_customer_delete	p_convex_id text	🔒	0045_institution_customers_domain.sql
institution_customer_save	p_convex_id text,p_document jsonb	🔒	0045_institution_customers_domain.sql

inventory_*

Fungsi	Argumen	Keamanan	Migrasi sumber
inventory_bulk_min_stock	p_updates jsonb	🔒	0022_inventory_recipe_domain.sql
inventory_ingredient_delete	p_convex_id text	🔒	20261010120000_master_inventory_write_path_projection.sql
inventory_ingredient_save	p_convex_id text, p_document jsonb	🔒	20261010120000_master_inventory_write_path_projection.sql
inventory_recipe_delete	p_convex_id text	🔒	20261010120000_master_inventory_write_path_projection.sql
inventory_recipe_item_delete	p_convex_id text	🔒	20261010120000_master_inventory_write_path_projection.sql
inventory_recipe_item_save	p_convex_id text, p_recipe_id text, p_ingredient_id text, p_amount numeric	🔒	20261010120000_master_inventory_write_path_projection.sql
inventory_recipe_save	p_convex_id text, p_document jsonb	🔒	20261010120000_master_inventory_write_path_projection.sql
inventory_stock_change	p_ingredient_id text, p_mode text, p_value numeric, p_note text	🔒	20261010120000_master_inventory_write_path_projection.sql

invoice_*

Fungsi	Argumen	Keamanan	Migrasi sumber
invoice_actor	—	🔒	0100_invoices_domain.sql
invoice_create_from_order	p_order_id text,p_due_date text default null,p_notes text default null	🔒	20261011140000_invoices_canonical.sql
invoice_delete	p_id text	🔒	20261011140000_invoices_canonical.sql
invoice_list	p_status text default null,p_search text default null	🔒	20261011140000_invoices_canonical.sql
invoice_mark_sent	p_id text	🔒	20261011140000_invoices_canonical.sql
invoice_payment	p_id text,p_status text,p_down_payment numeric default null	🔒	20261011140000_invoices_canonical.sql
invoice_summary	—	🔒	20261011140000_invoices_canonical.sql

is_*

Fungsi	Argumen	Keamanan	Migrasi sumber
is_active_user	—	🔒	0007_harden_profile_authorization.sql
is_delivery_dispatcher	—	🔒	0019_delivery_domain_adapter.sql
is_owner	—	🔒	0002_identity_and_rls.sql

issue_*

Fungsi	Argumen	Keamanan	Migrasi sumber
issue_actor	—	🔒	0092_internal_issues.sql
issue_admin_list	p_kind text	🔒	0092_internal_issues.sql
issue_assign	p_kind text,p_id text,p_assignee_id text	🔒	0092_internal_issues.sql
issue_assignable_users	—	🔒	0092_internal_issues.sql
issue_can_manage	p_kind text,p_document jsonb	🔒	0093_fix_issue_null_authorization.sql
issue_can_view	p_kind text,p_document jsonb	🔒	0093_fix_issue_null_authorization.sql
issue_comment_add	p_kind text,p_parent_id text,p_content text	🔒	0092_internal_issues.sql
issue_comments	p_kind text,p_parent_id text	🔒	0092_internal_issues.sql
issue_get	p_kind text,p_id text	🔒	0092_internal_issues.sql
issue_is_admin	—	🔒	0092_internal_issues.sql
issue_list	p_kind text,p_status text default null,p_category text default null,p_severity text default null,p_mine boolean default false,p_assigned boolean default false	🔒	0092_internal_issues.sql
issue_next_number	p_table text,p_prefix text	🔒	0092_internal_issues.sql
issue_patch	p_kind text,p_id text,p_patch jsonb	🔒	0092_internal_issues.sql

item_*

Fungsi	Argumen	Keamanan	Migrasi sumber
item_loan_actor	—	🔒	0107_fix_item_loan_actor_name.sql
item_loan_create_many	p_document jsonb	🔒	0106_customer_item_loans.sql
item_loan_delete	p_id text	🔒	0106_customer_item_loans.sql
item_loan_detail	p_id text	🔒	0106_customer_item_loans.sql
item_loan_list	p_status text default null,p_customer_name text default null	🔒	0106_customer_item_loans.sql
item_loan_note_add	p_loan_item_id text,p_content text	🔒	0106_customer_item_loans.sql
item_loan_note_delete	p_id text	🔒	0106_customer_item_loans.sql
item_loan_notes	p_loan_item_id text	🔒	0106_customer_item_loans.sql
item_loan_overdue_count	—	🔒	0106_customer_item_loans.sql
item_loan_return	p_loan_item_id text,p_returned_qty numeric,p_return_date text, p_condition text default null,p_notes text default null	🔒	0106_customer_item_loans.sql

kiosk_*

Fungsi	Argumen	Keamanan	Migrasi sumber
kiosk_access_get	—	🔒	0090_qc_packing_kiosk.sql
kiosk_access_rotate	—	🔒	0091_fix_kiosk_rotation_safe_delete.sql
kiosk_assert_key	p_key text	🔒	0090_qc_packing_kiosk.sql
kiosk_assign_driver	p_session_token text,p_order_id text,p_driver_id text,p_driver_name text	🔒	0090_qc_packing_kiosk.sql
kiosk_customer_by_phone	p_session_token text, p_phone text	🔒	20260909100000_kiosk_order_entry_v2.sql
kiosk_delivery_zones_list	p_session_token text	🔒	20260910060000_kiosk_order_entry_v3.sql
kiosk_drivers	p_session_token text	🔒	0090_qc_packing_kiosk.sql
kiosk_order_create	p_session_token text, p_document jsonb	🔒	20260909090000_kiosk_order_entry.sql
kiosk_order_log	p_order_id text,p_order_number text,p_action text,p_old text,p_new text,p_actor text,p_name text	🔒	0090_qc_packing_kiosk.sql
kiosk_packaging_types_list	p_session_token text	🔒	20260909100000_kiosk_order_entry_v2.sql
kiosk_packing_board	p_session_token text	🔒	0090_qc_packing_kiosk.sql
kiosk_pin_set	p_pin text	🔒	0090_qc_packing_kiosk.sql
kiosk_pin_status	—	🔒	0090_qc_packing_kiosk.sql
kiosk_platform_fee_types_list	p_session_token text	🔒	20260910060000_kiosk_order_entry_v3.sql
kiosk_products_list	p_session_token text	🔒	20260909100000_kiosk_order_entry_v2.sql
kiosk_promo_code_validate	p_session_token text, p_code text, p_order_total numeric, p_customer_phone text default null	🔒	20261014090000_promo_code_validate_consolidation.sql
kiosk_qc_check	p_session_token text,p_order_id text	🔒	0090_qc_packing_kiosk.sql
kiosk_qc_submit	p_session_token text,p_order_id text,p_items jsonb	🔒	0090_qc_packing_kiosk.sql
kiosk_qc_templates	p_session_token text	🔒	0090_qc_packing_kiosk.sql
kiosk_sales_tax_types_list	p_session_token text	🔒	20260910060000_kiosk_order_entry_v3.sql
kiosk_session_profile	p_token text	🔒	0090_qc_packing_kiosk.sql
kiosk_update_status	p_session_token text,p_order_id text,p_status text	🔒	0090_qc_packing_kiosk.sql
kiosk_validate_key	p_key text	🔒	0090_qc_packing_kiosk.sql
kiosk_verify_pin	p_key text,p_pin text	🔒	0090_qc_packing_kiosk.sql

knowledge_*

Fungsi	Argumen	Keamanan	Migrasi sumber
knowledge_base_list_all	—	🔒	20260906173000_knowledge_base_read_rpc.sql
knowledge_base_mutate	p_action text,p_id text default null,p_payload jsonb default '{}'::jsonb	🔒	20260906174000_knowledge_base_crud_rpc.sql

master_*

Fungsi	Argumen	Keamanan	Migrasi sumber
master_document_delete	p_table_name text, p_convex_id text	🔒	20261010120000_master_inventory_write_path_projection.sql
master_document_patch	p_table_name text, p_convex_id text, p_patch jsonb	🔒	0011_master_document_patch.sql
master_document_save	p_table_name text, p_convex_id text, p_document jsonb	🔒	20261010120000_master_inventory_write_path_projection.sql
master_product_type_delete	p_convex_id text	🔒	20261010120000_master_inventory_write_path_projection.sql
master_product_type_save	p_convex_id text, p_document jsonb	🔒	20261010120000_master_inventory_write_path_projection.sql

migration_*

Fungsi	Argumen	Keamanan	Migrasi sumber
migration_set_push_dispatch_secret	p_value text	🔒	0079_web_push_foundation.sql

monthly_*

Fungsi	Argumen	Keamanan	Migrasi sumber
monthly_report	p_month text	🔒	20260906171000_fix_monthly_report_interval.sql

notification_*

Fungsi	Argumen	Keamanan	Migrasi sumber
notification_center_snapshot	—	🔒	0062_notification_center_domain.sql
notification_snapshot	p_days_ahead integer default 3	🔒	0060_notifications_presence_unread.sql
notification_template_toggle	p_key text, p_is_active boolean	🔒	0062_notification_center_domain.sql
notification_template_upsert	p_key text, p_label text, p_subject text, p_body text, p_is_active boolean	🔒	0062_notification_center_domain.sql
notification_templates_list	—	🔒	0062_notification_center_domain.sql
notification_templates_seed	p_templates jsonb	🔒	0062_notification_center_domain.sql

operational_*

Fungsi	Argumen	Keamanan	Migrasi sumber
operational_file_read_allowed	p_object_path text	🔒	20260912190000_harden_operational_storage_read_policy.sql
operational_health_badge	—	🔒	0077_global_search_and_health.sql
operational_home_overview	—	🔒	20260906179000_operational_home_rpc.sql
operational_storage_path	p_storage_id text	🔒	0020_delivery_workflow_extensions.sql
operational_view_actor	—	🔒	0105_operational_calendar_display_views.sql

order_*

Fungsi	Argumen	Keamanan	Migrasi sumber
order_assign_driver	p_convex_ids text[], p_driver_id text, p_driver_name text	🔒	0012_order_domain_adapter.sql
order_bulk_mark_paid	p_convex_ids text[]	🔒	0012_order_domain_adapter.sql
order_bulk_status	p_convex_ids text[], p_status text	🔒	0012_order_domain_adapter.sql
order_create	p_document jsonb	🔒	0012_order_domain_adapter.sql
order_deduct_recipe_stock	p_order_id text, p_document jsonb	🔒	0014_order_transaction_side_effects.sql
order_delete	p_convex_id text	🔒	0012_order_domain_adapter.sql
order_delivery_calendar	p_year integer,p_month integer	🔒	0105_operational_calendar_display_views.sql
order_list_drivers	—	🔒	0013_order_query_projection.sql
order_note_delete	p_order_id text	🔒	0078_order_notes_and_reminders.sql
order_note_get	p_order_id text	🔒	0078_order_notes_and_reminders.sql
order_note_upsert	p_order_id text,p_order_number text,p_content text	🔒	0078_order_notes_and_reminders.sql
order_notes_for_orders	p_order_ids text[]	🔒	0078_order_notes_and_reminders.sql
order_patch	p_convex_id text, p_patch jsonb	🔒	0012_order_domain_adapter.sql
order_project	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	0012_order_domain_adapter.sql
order_reminder_add	p_order_id text,p_order_number text,p_title text,p_reminder_date date	🔒	0078_order_notes_and_reminders.sql
order_reminder_delete	p_id text	🔒	0078_order_notes_and_reminders.sql
order_reminder_toggle	p_id text	🔒	0078_order_notes_and_reminders.sql
order_reminders_due	—	🔒	0078_order_notes_and_reminders.sql
order_reminders_list	p_order_id text	🔒	0078_order_notes_and_reminders.sql
order_stats	—	🔒	20260905173614_fix_order_stats_auth.sql
order_sync_cash	p_order_id text, p_document jsonb	🔒	0014_order_transaction_side_effects.sql
order_sync_customer	p_order_id text, p_document jsonb	🔒	0014_order_transaction_side_effects.sql
order_today_summary	—	🔒	20260905160806_today_order_summary.sql
order_unsync_cash	p_order_id text	🔒	0014_order_transaction_side_effects.sql
order_update_status	p_convex_id text, p_status text	🔒	0012_order_domain_adapter.sql

performance_*

Fungsi	Argumen	Keamanan	Migrasi sumber
performance_reviews_mutate	p_action text,p_id text default null,p_payload jsonb default '{}'::jsonb	🔒	20260906187000_performance_reviews_mutate_rpc.sql
performance_reviews_read	p_period text	🔒	20260906180000_performance_reviews_read_rpc.sql
performance_stats	p_period text	🔒	20260905174453_performance_stats_dashboard.sql

periodic_*

Fungsi	Argumen	Keamanan	Migrasi sumber
periodic_report	p_period text,p_custom_start text default null,p_custom_end text default null	🔒	20260906160000_periodic_report_rpc.sql

permission_*

Fungsi	Argumen	Keamanan	Migrasi sumber
permission_all_overrides	—	🔒	0075_role_permissions.sql
permission_logs_list	p_role text default null	🔒	0075_role_permissions.sql
permission_my_overrides	—	🔒	0075_role_permissions.sql
permission_normalized_role	—	🔒	20260906061128_normalize_current_app_role.sql
permission_save_overrides	p_role text, p_overrides jsonb	🔒	0075_role_permissions.sql

portal_*

Fungsi	Argumen	Keamanan	Migrasi sumber
portal_business_phone	—	🔒	0056_token_gated_customer_portal.sql
portal_customer_summary	p_token text	🔒	0056_token_gated_customer_portal.sql
portal_delivery_tracking	p_token text,p_order_number text	🔒	0059_portal_tracking.sql
portal_order_detail	p_token text,p_order_number text	🔒	0056_token_gated_customer_portal.sql
portal_order_history	p_token text,p_limit integer default 20,p_cursor timestamptz default null	🔒	0056_token_gated_customer_portal.sql
portal_order_status_history	p_token text,p_order_number text	🔒	0059_portal_tracking.sql
portal_quotation_respond	p_token text,p_id text,p_decision text	🔒	0056_token_gated_customer_portal.sql
portal_quotations	p_token text	🔒	0056_token_gated_customer_portal.sql
portal_review_submit	p_order_id text,p_phone text,p_document jsonb	🔒	0050_customer_reviews_domain.sql
portal_review_submit_token	p_token text, p_order_id text, p_document jsonb	🔒	20260906104422_secure_portal_reviews.sql
portal_reviewable_orders	p_phone text	🔒	0050_customer_reviews_domain.sql
portal_reviewable_orders_token	p_token text	🔒	20260906104422_secure_portal_reviews.sql
portal_subscription_mutate	p_token text, p_action text, p_id text default null, p_payload jsonb default '{}'::jsonb	🔒	20261011130000_subscriptions_canonical.sql
portal_subscriptions_list	p_token text	🔒	20261011130000_subscriptions_canonical.sql
portal_testimonial_delete	p_convex_id text	🔒	0054_portal_testimonials_domain.sql
portal_testimonial_public_list	—	🔒	0054_portal_testimonials_domain.sql
portal_testimonial_save	p_convex_id text,p_document jsonb	🔒	0054_portal_testimonials_domain.sql
portal_token_generate	p_phone text	🔒	0055_portal_access_tokens.sql
portal_token_list	p_phone text	🔒	0055_portal_access_tokens.sql
portal_token_phone	p_token text	🔒	0056_token_gated_customer_portal.sql
portal_token_validate	p_token text	🔒	0055_portal_access_tokens.sql

prasmanan_*

Fungsi	Argumen	Keamanan	Migrasi sumber
prasmanan_checklist_action	p_action text,p_item_id text,p_order_id text,p_document jsonb	🔒	0087_prasmanan_inquiries_checklist.sql
prasmanan_checklist_generate	p_order_id text	🔒	0087_prasmanan_inquiries_checklist.sql
prasmanan_checklist_get	p_order_id text	🔒	0087_prasmanan_inquiries_checklist.sql
prasmanan_core_delete	p_table_name text, p_convex_id text	🔒	0085_prasmanan_inventory.sql
prasmanan_core_save	p_table_name text, p_convex_id text, p_document jsonb	🔒	0085_prasmanan_inventory.sql
prasmanan_equipment_approve	p_item_id text	🔒	0088_prasmanan_equipment_links.sql
prasmanan_equipment_approve_all	p_order_id text	🔒	0088_prasmanan_equipment_links.sql
prasmanan_equipment_generate	p_order_id text	🔒	0088_prasmanan_equipment_links.sql
prasmanan_equipment_need_delete	p_item_id text	🔒	0088_prasmanan_equipment_links.sql
prasmanan_equipment_needs	p_order_id text	🔒	0088_prasmanan_equipment_links.sql
prasmanan_external_equipment_delete	p_convex_id text	🔒	0088_prasmanan_equipment_links.sql
prasmanan_external_equipment_list	p_order_id text	🔒	0088_prasmanan_equipment_links.sql
prasmanan_external_equipment_save	p_order_id text,p_document jsonb	🔒	0088_prasmanan_equipment_links.sql
prasmanan_external_equipment_status	p_convex_id text,p_status text	🔒	0088_prasmanan_equipment_links.sql
prasmanan_inquiries_list	p_status text default null	🔒	0087_prasmanan_inquiries_checklist.sql
prasmanan_inquiry_convert	p_convex_id text,p_document jsonb	🔒	0087_prasmanan_inquiries_checklist.sql
prasmanan_inquiry_convert_with_event	p_convex_id text, p_document jsonb		20260912072557_inquiry_event_order_integration.sql
prasmanan_inquiry_create	p_document jsonb	🔒	0087_prasmanan_inquiries_checklist.sql
prasmanan_inquiry_get	p_convex_id text	🔒	0087_prasmanan_inquiries_checklist.sql
prasmanan_inquiry_update	p_convex_id text,p_status text,p_admin_notes text default null	🔒	0087_prasmanan_inquiries_checklist.sql
prasmanan_loan_return	p_convex_id text, p_document jsonb	🔒	0085_prasmanan_inventory.sql
prasmanan_maintenance_finish	p_convex_id text, p_document jsonb	🔒	0085_prasmanan_inventory.sql
prasmanan_menu_delete	p_table_name text, p_convex_id text	🔒	0086_prasmanan_menu.sql
prasmanan_menu_save	p_table_name text, p_convex_id text, p_document jsonb	🔒	0086_prasmanan_menu.sql
prasmanan_public_menu_items	—	🔒	0086_prasmanan_menu.sql
prasmanan_public_packages	—	🔒	0086_prasmanan_menu.sql

presence_*

Fungsi	Argumen	Keamanan	Migrasi sumber
presence_heartbeat	—	🔒	0060_notifications_presence_unread.sql
presence_online_count	—	🔒	0060_notifications_presence_unread.sql
presence_status	p_user_ids text[]	🔒	0060_notifications_presence_unread.sql

procurement_*

Fungsi	Argumen	Keamanan	Migrasi sumber
procurement_gr_create	p_po_id text, p_received_date text, p_notes text, p_items jsonb	🔒	0027_goods_receipt_domain.sql
procurement_gr_delete	p_convex_id text	🔒	0027_goods_receipt_domain.sql
procurement_gr_number	—	🔒	0027_goods_receipt_domain.sql
procurement_po_create	p_document jsonb, p_items jsonb	🔒	0026_purchase_order_domain.sql
procurement_po_delete	p_convex_id text	🔒	0026_purchase_order_domain.sql
procurement_po_number	—	🔒	0026_purchase_order_domain.sql
procurement_po_status	p_convex_id text, p_status text, p_cancel_reason text default null	🔒	0026_purchase_order_domain.sql
procurement_po_update	p_convex_id text, p_document jsonb, p_items jsonb	🔒	0026_purchase_order_domain.sql

product_*

Fungsi	Argumen	Keamanan	Migrasi sumber
product_insights	p_threshold numeric default 5	🔒	20260906130000_product_insights_rpc.sql
product_performance	p_period text,p_custom_start text default null,p_custom_end text default null	🔒	20260906120000_product_performance_rpc.sql

profile_*

Fungsi	Argumen	Keamanan	Migrasi sumber
profile_self_service_update	p_full_name text default null, p_display_name_preference text default null, p_nickname text default null	🔒	20260905153826_profile_self_service.sql

profitability_*

Fungsi	Argumen	Keamanan	Migrasi sumber
profitability_report	p_period text,p_custom_start text default null,p_custom_end text default null,p_group_by text default 'product'	🔒	20260906140000_profitability_report_rpc.sql

project_*

Fungsi	Argumen	Keamanan	Migrasi sumber
project_attendance_record	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261011120000_employees_attendance_canonical.sql
project_cctv_config	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261011150000_cctv_config_canonical.sql
project_complaint	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261011110000_complaints_foodwaste_canonical.sql
project_customer	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261011090000_customers_write_path_projection.sql
project_delivery_zone	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261011100000_sales_config_zones_promo_canonical.sql
project_employee	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261011120000_employees_attendance_canonical.sql
project_food_waste	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261011110000_complaints_foodwaste_canonical.sql
project_ingredient	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261010120000_master_inventory_write_path_projection.sql
project_invoice	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261011140000_invoices_canonical.sql
project_loan	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261014102000_loans_canonical.sql
project_loan_config	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261014102000_loans_canonical.sql
project_loan_payment	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261014102000_loans_canonical.sql
project_loan_status_history	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261014102000_loans_canonical.sql
project_loan_type	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261014102000_loans_canonical.sql
project_package_composition	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261010120000_master_inventory_write_path_projection.sql
project_package_type	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261010120000_master_inventory_write_path_projection.sql
project_packaging_type	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261010120000_master_inventory_write_path_projection.sql
project_payroll_batch	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261014100000_payroll_core_canonical.sql
project_payroll_period	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261014100000_payroll_core_canonical.sql
project_payroll_slip	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261014100000_payroll_core_canonical.sql
project_payroll_slips_by_batch	p_batch_id text	🔒	20261014100000_payroll_core_canonical.sql
project_payroll_tax_config	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261014100000_payroll_core_canonical.sql
project_platform_fee_type	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261011100000_sales_config_zones_promo_canonical.sql
project_product	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261010120000_master_inventory_write_path_projection.sql
project_product_category	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261010120000_master_inventory_write_path_projection.sql
project_product_type	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261010120000_master_inventory_write_path_projection.sql
project_promo_code	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261011100000_sales_config_zones_promo_canonical.sql
project_recipe	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261010120000_master_inventory_write_path_projection.sql
project_recipe_item	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261010120000_master_inventory_write_path_projection.sql
project_sales_tax_type	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261011100000_sales_config_zones_promo_canonical.sql
project_stock_log	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261010120000_master_inventory_write_path_projection.sql
project_subscription	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261011130000_subscriptions_canonical.sql
project_tax_invoice	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261014110000_tax_invoices_canonical.sql
project_thr_config	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261014101000_thr_canonical.sql
project_thr_slip	p_convex_id text, p_document jsonb, p_created_at timestamptz	🔒	20261014101000_thr_canonical.sql
project_thr_slips_by_year	p_year integer	🔒	20261014101000_thr_canonical.sql

promo_*

Fungsi	Argumen	Keamanan	Migrasi sumber
promo_banner_delete	p_id text	🔒	0076_profile_photos_and_promo_banners.sql
promo_banner_save	p_id text, p_document jsonb	🔒	0076_profile_photos_and_promo_banners.sql
promo_banners_list	p_active_only boolean default false	🔒	0076_profile_photos_and_promo_banners.sql
promo_code_actor	—	🔒	0108_promo_codes_domain.sql
promo_code_delete	p_id text	🔒	20261011100000_sales_config_zones_promo_canonical.sql
promo_code_evaluate	p_code text, p_order_total numeric, p_customer_phone text default null	🔒	20261014090000_promo_code_validate_consolidation.sql
promo_code_save	p_id text,p_document jsonb	🔒	20261011100000_sales_config_zones_promo_canonical.sql
promo_code_validate	p_code text, p_order_total numeric, p_customer_phone text default null	🔒	20261014090000_promo_code_validate_consolidation.sql
promo_codes_list	—	🔒	20261011101500_promo_codes_list_canonical_read.sql

protect_*

Fungsi	Argumen	Keamanan	Migrasi sumber
protect_profile_authorization_fields	—	🔒	0066_allow_self_chat_identity.sql

public_*

Fungsi	Argumen	Keamanan	Migrasi sumber
public_catalog_list	—	🔒	20260905150254_public_catalog.sql
public_catalog_toggle	p_active boolean	🔒	20260905172814_public_catalog_toggle.sql
public_order_tracking	p_order_number text	🔒	20260905145318_public_order_tracking.sql
public_portal_order_create	p_document jsonb	🔒	20260907102000_fix_public_portal_order_date_validation.sql
public_review_stats	p_display_key text	🔒	0051_public_review_statistics.sql

qc_*

Fungsi	Argumen	Keamanan	Migrasi sumber
qc_check_batch	p_order_ids text[]	🔒	0090_qc_packing_kiosk.sql
qc_check_get	p_order_id text	🔒	0090_qc_packing_kiosk.sql
qc_check_submit	p_order_id text,p_items jsonb	🔒	0090_qc_packing_kiosk.sql
qc_check_write	p_order_id text,p_items jsonb,p_actor text,p_actor_name text,p_allow_partial boolean	🔒	0090_qc_packing_kiosk.sql
qc_require_manager	—	🔒	0090_qc_packing_kiosk.sql
qc_template_delete	p_id text	🔒	0090_qc_packing_kiosk.sql
qc_template_list	p_active_only boolean default false	🔒	0090_qc_packing_kiosk.sql
qc_template_save	p_id text,p_document jsonb	🔒	0090_qc_packing_kiosk.sql

quotation_*

Fungsi	Argumen	Keamanan	Migrasi sumber
quotation_actor	—	🔒	0099_quotations_domain.sql
quotation_convert	p_id text,p_delivery_date text,p_delivery_time text default null,p_delivery_type text default 'antar'	🔒	0099_quotations_domain.sql
quotation_delete	p_id text	🔒	0099_quotations_domain.sql
quotation_list	p_status text default null,p_search text default null,p_limit integer default 200	🔒	0099_quotations_domain.sql
quotation_normalize	p_document jsonb,p_existing jsonb default null	🔒	0099_quotations_domain.sql
quotation_save	p_id text,p_document jsonb	🔒	0099_quotations_domain.sql
quotation_status	p_id text,p_status text	🔒	0099_quotations_domain.sql
quotation_summary	—	🔒	0099_quotations_domain.sql
quotation_valid_date	p_value text,p_label text	🔒	0099_quotations_domain.sql

rekap_*

Fungsi	Argumen	Keamanan	Migrasi sumber
rekap_bahan	p_delivery_date text default null	🔒	20260906113000_rekap_bahan_rpc.sql
rekap_dapur	p_delivery_date text default null	🔒	20260906110000_rekap_dapur_rpc.sql
rekap_kemasan	p_delivery_date text default null	🔒	20260906104000_fix_rekap_kemasan_date.sql

review_*

Fungsi	Argumen	Keamanan	Migrasi sumber
review_create	p_document jsonb	🔒	0050_customer_reviews_domain.sql
review_delete	p_convex_id text	🔒	0053_review_storage_delete_api.sql
review_normalize_phone	p_phone text		0050_customer_reviews_domain.sql
review_photo_path	p_storage_id text	🔒	0050_customer_reviews_domain.sql
review_public_object	p_name text	🔒	0050_customer_reviews_domain.sql
review_update	p_convex_id text,p_rating numeric,p_comment text default null	🔒	0050_customer_reviews_domain.sql

sales_*

Fungsi	Argumen	Keamanan	Migrasi sumber
sales_config_delete	p_table_name text, p_convex_id text	🔒	20261011100000_sales_config_zones_promo_canonical.sql
sales_config_save	p_table_name text, p_convex_id text, p_document jsonb	🔒	20261011100000_sales_config_zones_promo_canonical.sql
sales_config_seed	p_table_name text	🔒	20261011100000_sales_config_zones_promo_canonical.sql

scheduling_*

Fungsi	Argumen	Keamanan	Migrasi sumber
scheduling_actor	—	🔒	0098_daily_schedule_whatsapp_blast.sql
scheduling_assert_date	p_date text	🔒	0098_daily_schedule_whatsapp_blast.sql

search_*

Fungsi	Argumen	Keamanan	Migrasi sumber
search_preset_delete	p_id uuid	🔒	0077_global_search_and_health.sql
search_preset_save	p_name text, p_filters jsonb	🔒	0077_global_search_and_health.sql
search_presets_list	—	🔒	0077_global_search_and_health.sql
search_recent_clear	—	🔒	0077_global_search_and_health.sql
search_recent_delete	p_id uuid	🔒	0077_global_search_and_health.sql
search_recent_list	—	🔒	0077_global_search_and_health.sql
search_recent_save	p_query text, p_category text, p_result_count integer	🔒	0077_global_search_and_health.sql

settings_*

Fungsi	Argumen	Keamanan	Migrasi sumber
settings_get	—	🔒	20260908020226_fix_settings_mutate_target_table.sql
settings_mutate	p_payload jsonb	🔒	20260908020226_fix_settings_mutate_target_table.sql
settings_public_get	—	🔒	20260910074131_protect_app_settings_and_storage.sql

sop_*

Fungsi	Argumen	Keamanan	Migrasi sumber
sop_actor	p_manage boolean default false	🔒	0096_sop_checklist_domain.sql
sop_assert_date	p_date text		0096_sop_checklist_domain.sql
sop_monitor_date	p_date text	🔒	0096_sop_checklist_domain.sql
sop_my_logs	p_date text	🔒	0096_sop_checklist_domain.sql
sop_template_create	p_document jsonb	🔒	0096_sop_checklist_domain.sql
sop_template_delete	p_id text	🔒	0096_sop_checklist_domain.sql
sop_template_list	—	🔒	0096_sop_checklist_domain.sql
sop_template_update	p_id text,p_patch jsonb	🔒	0096_sop_checklist_domain.sql
sop_template_validate	p_document jsonb		0096_sop_checklist_domain.sql
sop_templates_for_role	p_role text default null	🔒	0096_sop_checklist_domain.sql
sop_toggle_item	p_template_id text,p_item_id text,p_date text	🔒	0096_sop_checklist_domain.sql
sop_weekly_summary	p_days integer default 7	🔒	0096_sop_checklist_domain.sql

stock_*

Fungsi	Argumen	Keamanan	Migrasi sumber
stock_forecast	p_range_days integer default 3	🔒	20260905163125_stock_forecast.sql

subscriptions_*

Fungsi	Argumen	Keamanan	Migrasi sumber
subscriptions_list	p_phone text default null	🔒	20261011130000_subscriptions_canonical.sql
subscriptions_mutate	p_action text, p_id text default null, p_payload jsonb default '{}'::jsonb	🔒	20261011130000_subscriptions_canonical.sql

supplier_*

Fungsi	Argumen	Keamanan	Migrasi sumber
supplier_category_delete	p_convex_id text	🔒	0025_supplier_domain.sql
supplier_category_save	p_convex_id text, p_name text	🔒	0025_supplier_domain.sql
supplier_delete	p_convex_id text	🔒	0025_supplier_domain.sql
supplier_performance	p_start_date text default null,p_end_date text default null	🔒	20260906150000_supplier_performance_rpc.sql
supplier_purchase_add	p_document jsonb, p_update_stock boolean default false	🔒	0025_supplier_domain.sql
supplier_purchase_delete	p_convex_id text	🔒	0025_supplier_domain.sql
supplier_save	p_convex_id text, p_document jsonb	🔒	0025_supplier_domain.sql
supplier_seed_categories	—	🔒	0025_supplier_domain.sql

sync_*

Fungsi	Argumen	Keamanan	Migrasi sumber
sync_order_query_columns	—		0013_order_query_projection.sql

system_*

Fungsi	Argumen	Keamanan	Migrasi sumber
system_health_error_log	p_limit integer default 50	🔒	20260906172000_system_health_snapshot.sql
system_health_snapshot	—	🔒	20260906176000_fix_system_health_metrics.sql

targets_*

Fungsi	Argumen	Keamanan	Migrasi sumber
targets_get	p_month text	🔒	20260905180220_fix_targets_raw_creator.sql
targets_save	p_month text,p_order_target numeric,p_revenue_target numeric	🔒	20260905175832_targets_domain_rpc.sql

tax_*

Fungsi	Argumen	Keamanan	Migrasi sumber
tax_invoice_actor	—	🔒	0101_tax_invoices_domain.sql
tax_invoice_cancel	p_id text	🔒	20261014110000_tax_invoices_canonical.sql
tax_invoice_delete	p_id text	🔒	20261014110000_tax_invoices_canonical.sql
tax_invoice_issuable_orders	p_search text default null	🔒	0101_tax_invoices_domain.sql
tax_invoice_issue	p_order_id text,p_buyer_npwp text default null,p_buyer_address text default null, p_transaction_date text default null,p_notes text default null	🔒	20261014110000_tax_invoices_canonical.sql
tax_invoice_list	p_status text default null,p_search text default null	🔒	0101_tax_invoices_domain.sql
tax_invoice_settings	—	🔒	0101_tax_invoices_domain.sql
tax_period	p_period text,p_custom_start text default null,p_custom_end text default null	🔒	0101_tax_invoices_domain.sql
tax_ppn_recap	p_period text,p_custom_start text default null,p_custom_end text default null	🔒	0101_tax_invoices_domain.sql

ticket_*

Fungsi	Argumen	Keamanan	Migrasi sumber
ticket_create	p_document jsonb	🔒	0092_internal_issues.sql
ticket_update	p_id text,p_patch jsonb	🔒	0092_internal_issues.sql
ticket_update_status	p_id text,p_status text	🔒	0092_internal_issues.sql

user_*

Fungsi	Argumen	Keamanan	Migrasi sumber
user_admin_approve	p_user_id uuid,p_role text	🔒	0081_user_administration.sql
user_admin_block	p_user_id uuid	🔒	0081_user_administration.sql
user_admin_delete	p_user_id uuid	🔒	0081_user_administration.sql
user_admin_list	—	🔒	0081_user_administration.sql
user_admin_require_owner	—	🔒	0081_user_administration.sql
user_admin_set_role	p_user_id uuid,p_role text	🔒	0081_user_administration.sql
user_profile_photo_remove	p_target_id text	🔒	0076_profile_photos_and_promo_banners.sql
user_profile_photo_set	p_target_id text, p_path text	🔒	0076_profile_photos_and_promo_banners.sql

wa_*

Fungsi	Argumen	Keamanan	Migrasi sumber
wa_blast_cancel	p_id text	🔒	0098_daily_schedule_whatsapp_blast.sql
wa_blast_create	p_title text,p_message text,p_target_filter text,p_recipients jsonb	🔒	0098_daily_schedule_whatsapp_blast.sql
wa_blast_delete	p_id text	🔒	0098_daily_schedule_whatsapp_blast.sql
wa_blast_get	p_id text	🔒	0098_daily_schedule_whatsapp_blast.sql
wa_blast_list	—	🔒	0098_daily_schedule_whatsapp_blast.sql
wa_blast_recipient_status	p_id text,p_phone text,p_status text	🔒	0098_daily_schedule_whatsapp_blast.sql
wa_blast_start	p_id text	🔒	0098_daily_schedule_whatsapp_blast.sql

warehouse_*

Fungsi	Argumen	Keamanan	Migrasi sumber
warehouse_delete	p_convex_id text	🔒	0028_warehouse_domain.sql
warehouse_save	p_convex_id text, p_document jsonb	🔒	0028_warehouse_domain.sql
warehouse_stock_adjust	p_warehouse_id text, p_ingredient_id text, p_new_stock numeric, p_min_stock numeric	🔒	0028_warehouse_domain.sql
warehouse_stock_sync	p_warehouse_id text	🔒	0028_warehouse_domain.sql
warehouse_transfer_create	p_from_warehouse_id text, p_to_warehouse_id text, p_ingredient_id text, p_quantity numeric, p_notes text	🔒	0028_warehouse_domain.sql
warehouse_transfer_number	—	🔒	0028_warehouse_domain.sql

---

Sumber: digenerate dari ../02_Working_Copy/supabase/migrations (200 berkas migrasi dipindai, 579 fungsi unik ditemukan).