FlattenToForm: nur für Positionsartikel gültige CVars übernehmen
[kivitendo-erp.git] / SL / DB / Helper / Mappings.pm
index a5b6f05..5eb9a5a 100644 (file)
@@ -22,6 +22,53 @@ my @kivitendo_blacklist_temp = qw(
 
 # tables created by crm module
 my @crm_blacklist = qw(
+  blz_data
+  bundesland
+  contmasch
+  contract
+  crm
+  crmdefaults
+  crmemployee
+  custmsg
+  docfelder
+  documents
+  documenttotc
+  docvorlage
+  extra_felder
+  geodb_changelog
+  geodb_coordinates
+  geodb_floatdata
+  geodb_hierarchies
+  geodb_intdata
+  geodb_locations
+  geodb_textdata
+  geodb_type_names
+  grpusr
+  gruppenname
+  history
+  labels
+  labeltxt
+  mailvorlage
+  maschine
+  maschmat
+  opport_status
+  opportunity
+  postit
+  repauftrag
+  telcall
+  telcallhistory
+  telnr
+  tempcsvdata
+  termdate
+  termincat
+  termine
+  terminmember
+  timetrack
+  tt_event
+  tt_parts
+  wiedervorlage
+  wissencategorie
+  wissencontent
 );
 
 # tables created by cash register
@@ -37,29 +84,39 @@ my @kivitendo_blacklist = (@kivitendo_blacklist_permanent, @kivitendo_blacklist_
 my %kivitendo_package_names = (
   # TABLE                           # MODEL (given in C style)
   acc_trans                      => 'acc_transaction',
-  audittrail                     => 'audit_trail',
   'auth.clients'                 => 'auth_client',
   'auth.clients_users'           => 'auth_client_user',
   'auth.clients_groups'          => 'auth_client_group',
   'auth.group'                   => 'auth_group',
   'auth.group_rights'            => 'auth_group_right',
+  'auth.master_rights'           => 'auth_master_right',
+  'auth.schema_info'             => 'auth_schema_info',
+  'auth.session'                 => 'auth_session',
+  'auth.session_content'         => 'auth_session_content',
   'auth.user'                    => 'auth_user',
   'auth.user_config'             => 'auth_user_config',
   'auth.user_group'              => 'auth_user_group',
   ar                             => 'invoice',
   ap                             => 'purchase_invoice',
+  assembly                       => 'assembly',
   background_jobs                => 'background_job',
   background_job_histories       => 'background_job_history',
   ap                             => 'purchase_invoice',
   bank_accounts                  => 'bank_account',
+  bank_transactions              => 'bank_transaction',
   buchungsgruppen                => 'buchungsgruppe',
+  bin                            => 'bin',
+  business                       => 'business',
+  chart                          => 'chart',
   contacts                       => 'contact',
+  customer                       => 'customer',
   csv_import_profiles            => 'csv_import_profile',
   csv_import_profile_settings    => 'csv_import_profile_setting',
   csv_import_reports             => 'csv_import_report',
   csv_import_report_rows         => 'csv_import_report_row',
   csv_import_report_status       => 'csv_import_report_status',
   currencies                     => 'currency',
+  custom_variable_config_partsgroups => 'custom_variable_config_partsgroup',
   custom_variable_configs        => 'custom_variable_config',
   custom_variables               => 'custom_variable',
   custom_variables_validity      => 'custom_variable_validity',
@@ -67,11 +124,14 @@ my %kivitendo_package_names = (
   defaults                       => 'default',
   delivery_orders                => 'delivery_order',
   delivery_order_items           => 'delivery_order_item',
+  delivery_order_items_stock     => 'delivery_order_items_stock',
+  delivery_terms                 => 'delivery_term',
   department                     => 'department',
-  dpt_trans                      => 'dpt_trans',
   drafts                         => 'draft',
   dunning                        => 'dunning',
   dunning_config                 => 'dunning_config',
+  email_journal                  => 'EmailJournal',
+  email_journal_attachments      => 'EmailJournalAttachment',
   employee                       => 'employee',
   exchangerate                   => 'exchangerate',
   finanzamt                      => 'finanzamt',
@@ -84,6 +144,8 @@ my %kivitendo_package_names = (
   inventory                      => 'inventory',
   invoice                        => 'invoice_item',
   language                       => 'language',
+  letter                         => 'letter',
+  letter_draft                   => 'letter_draft',
   makemodel                      => 'make_model',
   notes                          => 'note',
   orderitems                     => 'order_item',
@@ -95,22 +157,51 @@ my %kivitendo_package_names = (
   periodic_invoices_configs      => 'periodic_invoices_config',
   prices                         => 'price',
   price_factors                  => 'price_factor',
+  price_rules                    => 'price_rule',
+  price_rule_items               => 'price_rule_item',
   pricegroup                     => 'pricegroup',
-  printers                       => 'Printer',
+  printers                       => 'printer',
+  project                        => 'project',
+  project_participants           => 'project_participant',
+  project_phase_participants     => 'project_phase_participant',
+  project_phases                 => 'project_phase',
+  project_roles                  => 'project_role',
+  project_statuses               => 'project_status',
+  project_types                  => 'project_type',
   record_links                   => 'record_link',
+  reconciliation_links           => 'reconciliation_link',
+  requirement_spec_acceptance_statuses => 'RequirementSpecAcceptanceStatus',
+  requirement_spec_complexities        => 'RequirementSpecComplexity',
+  requirement_spec_item_dependencies   => 'RequirementSpecDependency',
+  requirement_spec_items               => 'RequirementSpecItem',
+  requirement_spec_orders              => 'RequirementSpecOrder',
+  requirement_spec_parts               => 'RequirementSpecPart',
+  requirement_spec_pictures            => 'RequirementSpecPicture',
+  requirement_spec_predefined_texts    => 'RequirementSpecPredefinedText',
+  requirement_spec_risks               => 'RequirementSpecRisk',
+  requirement_spec_statuses            => 'RequirementSpecStatus',
+  requirement_spec_text_blocks         => 'RequirementSpecTextBlock',
+  requirement_spec_types               => 'RequirementSpecType',
+  requirement_spec_versions            => 'RequirementSpecVersion',
+  requirement_specs                    => 'RequirementSpec',
   sepa_export                    => 'sepa_export',
   sepa_export_items              => 'sepa_export_item',
+  sepa_export_message_ids        => 'SepaExportMessageId',
   schema_info                    => 'schema_info',
+  shipto                         => 'shipto',
   status                         => 'status',
   tax                            => 'tax',
   taxkeys                        => 'tax_key',
   tax_zones                      => 'tax_zone',
+  taxzone_charts                 => 'taxzone_chart',
   todo_user_config               => 'todo_user_config',
+  transfer_type                  => 'transfer_type',
   translation                    => 'translation',
-  translation_payment_terms      => 'translation_payment_term',
+  trigger_information            => 'trigger_information',
   units                          => 'unit',
   units_language                 => 'units_language',
   vendor                         => 'vendor',
+  warehouse                      => 'warehouse',
 );
 
 my (%kivitendo_tables_to_packages, %kivitendo_tables_to_manager_packages, %kivitendo_packages_to_tables);
@@ -123,6 +214,10 @@ sub get_package_names {
   return KIVITENDO => \%kivitendo_package_names;
 }
 
+sub get_name_for_table {
+  return $kivitendo_package_names{ $_[0] };
+}
+
 sub get_package_for_table {
   %kivitendo_tables_to_packages = map { ($_ => "SL::DB::" . camelify($kivitendo_package_names{$_})) } keys %kivitendo_package_names
     unless %kivitendo_tables_to_packages;