X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/cf889668782d1ffbb76b9f28e1d36848544fa3b3..6bb7e63612793081eb30a2bdbf42d5b1e7bff7b6:/SL/DB/Helper/Mappings.pm diff --git a/SL/DB/Helper/Mappings.pm b/SL/DB/Helper/Mappings.pm index 477190448..35845a8ea 100644 --- a/SL/DB/Helper/Mappings.pm +++ b/SL/DB/Helper/Mappings.pm @@ -18,7 +18,16 @@ my @lxoffice_blacklist_permanent = qw( my @lxoffice_blacklist_temp = qw( ); -my @lxoffice_blacklist = (@lxoffice_blacklist_permanent, @lxoffice_blacklist_temp); +# tables created by crm module +my @crm_blacklist = qw( +); + +# tables created by cash register +my @cash_register_blacklist = qw( +ekartikel ekbon ekkunde ektext erptasten +); + +my @lxoffice_blacklist = (@lxoffice_blacklist_permanent, @lxoffice_blacklist_temp, @crm_blacklist, @cash_register_blacklist); # map table names to their models. # unlike rails we have no singular<->plural magic. @@ -39,10 +48,14 @@ my %lxoffice_package_names = ( bank_accounts => 'bank_account', buchungsgruppen => 'buchungsgruppe', contacts => 'contact', + 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', custom_variable_configs => 'custom_variable_config', custom_variables => 'custom_variable', custom_variables_validity => 'custom_variable_validity', - customertax => 'customer_tax', datev => 'datev', defaults => 'default', delivery_orders => 'delivery_order', @@ -59,31 +72,25 @@ my %lxoffice_package_names = ( follow_up_links => 'follow_up_link', follow_ups => 'follow_up', generic_translations => 'generic_translation', - gifi => 'gifi', gl => 'GLTransaction', history_erp => 'history', inventory => 'inventory', invoice => 'invoice_item', language => 'language', - license => 'license', - licenseinvoice => 'license_invoice', makemodel => 'make_model', notes => 'note', orderitems => 'order_item', oe => 'order', parts => 'part', partsgroup => 'parts_group', - partstax => 'parts_tax', payment_terms => 'payment_term', periodic_invoices => 'periodic_invoice', periodic_invoices_configs => 'periodic_invoices_config', - prices => 'prices', + prices => 'price', price_factors => 'price_factor', pricegroup => 'pricegroup', printers => 'Printer', record_links => 'record_link', - rma => 'RMA', - rmaitems => 'RMA_item', sepa_export => 'sepa_export', sepa_export_items => 'sepa_export_item', schema_info => 'schema_info', @@ -96,7 +103,7 @@ my %lxoffice_package_names = ( translation_payment_terms => 'translation_payment_term', units => 'unit', units_language => 'units_language', - vendortax => 'vendor_tax', + vendor => 'vendor', ); my (%lxoffice_tables_to_packages, %lxoffice_tables_to_manager_packages, %lxoffice_packages_to_tables); @@ -220,23 +227,23 @@ will die with an error. Returns the package name for a table name: - SL::DB::Helpers::Mappings::get_package_for_table('oe') + SL::DB::Helper::Mappings::get_package_for_table('oe') # SL::DB::Order =item C Returns the manager package name for a table name: - SL::DB::Helpers::Mappings::get_manager_package_for_table('oe') + SL::DB::Helper::Mappings::get_manager_package_for_table('oe') # SL::DB::Manager::Order =item C Returns the table name for a package name: - SL::DB::Helpers::Mappings::get_table_for_package('SL::DB::Order') + SL::DB::Helper::Mappings::get_table_for_package('SL::DB::Order') # oe - SL::DB::Helpers::Mappings::get_table_for_package('Order') + SL::DB::Helper::Mappings::get_table_for_package('Order') # oe =back