1 package SL::InstanceConfiguration;
7 use SL::System::Process;
9 use parent qw(Rose::Object);
10 use Rose::Object::MakeMethods::Generic (
11 'scalar --get_set_init' => [ qw(data currencies default_currency _table_currencies_exists crm_installed) ],
15 return {} if !$::auth->client;
16 return SL::DBUtils::selectfirst_hashref_query($::form, $::form->get_standard_dbh, qq|SELECT * FROM defaults|);
19 sub init__table_currencies_exists {
20 return 0 if !$::auth->client;
21 return !!(SL::DBUtils::selectall_hashref_query($::form, $::form->get_standard_dbh, qq|SELECT tablename FROM pg_tables WHERE (schemaname = 'public') AND (tablename = 'currencies')|))[0];
27 return [] if !$self->_table_currencies_exists;
28 return [ map { $_->{name} } SL::DBUtils::selectall_hashref_query($::form, $::form->get_standard_dbh, qq|SELECT name FROM currencies ORDER BY id ASC|) ];
31 sub init_default_currency {
34 return undef if !$self->_table_currencies_exists || !$self->data->{currency_id};
35 return (SL::DBUtils::selectfirst_array_query($::form, $::form->get_standard_dbh, qq|SELECT name FROM currencies WHERE id = ?|, $self->data->{currency_id}))[0];
38 sub init_crm_installed {
39 return -f (SL::System::Process->exe_dir . '/crm/Changelog');
45 delete @{ $self }{qw(data currencies default_currency)};
52 return @{ $self->currencies };
56 # Compatibility function: back in the day there was only a single
60 my $zipcode_city = join ' ', grep { $_ } ($self->get_address_zipcode, $self->get_address_city);
62 return join "\n", grep { $_ } ($self->get_address_street1, $self->get_address_street2, $zipcode_city, $self->get_address_country);
65 sub get_layout_style {
66 return $_[0]->data->{layout_style} if exists $_[0]->data->{layout_style};
74 my $method = $AUTOLOAD;
77 return if $method eq 'DESTROY';
79 if ($method =~ m/^get_/) {
80 $method = substr $method, 4;
81 return $self->data->{$method} if exists $self->data->{$method};
82 croak "Invalid method 'get_${method}'";
85 croak "Invalid method '${method}'" if !$self->can($method);
86 return $self->$method(@_);
99 SL::InstanceConfiguration - Provide instance-specific configuration data
103 kivitendo has two configuration levels: installation specific
104 (provided by the global variable C<%::lx_office_conf>) and instance
105 specific. The latter is provided by a global instance of this class,
114 Creates a new instance. Does not read the configuration.
116 =item C<crm_installed>
118 Returns trueish if the CRM component is installed.
120 =item C<get_currencies>
122 Returns an array of configured currencies.
124 =item C<get_default_currency>
126 Returns the default currency or undef if no currency has been
129 =item C<get_layout_style>
131 Returns the forced default layout style or '' if the database column
134 =item C<get_accounting_method>
136 Returns the default accounting method, accrual or cash
138 =item C<get_inventory_system>
140 Returns the default inventory system, perpetual or periodic
142 =item C<get_profit_determination>
144 Returns the default profit determination method, balance or income
146 =item C<get_balance_startdate_method>
148 Returns the default method for determining the startdate for the balance
152 closed_to start_of_year all_transactions last_ob_or_all_transactions last_ob_or_start_of_year
154 =item C<get_is_changeable>
156 =item C<get_ir_changeable>
158 =item C<get_ar_changeable>
160 =item C<get_ap_changeable>
162 =item C<get_gl_changeable>
164 Returns if and when these record types are changeable or deleteable after
165 posting. 0 means never, 1 means always and 2 means on the same day.
167 =item C<get_datev_check_on_sales_invoice>
169 Returns true if datev check should be performed on sales invoices
171 =item C<get_datev_check_on_purchase_invoice>
173 Returns true if datev check should be performed on purchase invoices
175 =item C<get_datev_check_on_ar_transaction>
177 Returns true if datev check should be performed on ar transactions
179 =item C<get_datev_check_on_ap_transaction>
181 Returns true if datev check should be performed on ap transactions
183 =item C<get_datev_check_on_gl_transaction>
185 Returns true if datev check should be performed on gl transactions
187 =item C<get_show_bestbefore>
189 Returns the default behavior for showing best before date, true or false
191 =item C<get_is_show_mark_as_paid>
193 =item C<get_ir_show_mark_as_paid>
195 =item C<get_ar_show_mark_as_paid>
197 =item C<get_ap_show_mark_as_paid>
199 Returns the default behavior for showing the "mark as paid" button for the
200 corresponding record type (true or false).
202 =item C<get_sales_order_show_delete>
204 =item C<get_purchase_order_show_delete>
206 =item C<get_sales_delivery_order_show_delete>
208 =item C<get_purchase_delivery_order_show_delete>
210 Returns the default behavior for showing the delete button for the
211 corresponding record type (true or false).
213 =item C<get_warehouse_id>
215 Returns the default warehouse_id
219 Returns the default bin_id
221 =item C<get_warehouse_id_ignore_onhand>
223 Returns the default warehouse_id for transfers without checking the
224 current stock quantity
226 =item C<get_bin_id_ignore_onhand>
228 Returns the default bin_id for transfers without checking the
229 current stock quantity
231 =item C<get_transfer_default>
233 =item C<get_transfer_default_use_master_default_bin>
235 =item C<get_transfer_default_ignore_onhand>
237 Returns the default behavior for the transfer out default feature (true or false)
239 =item C<get_max_future_booking_interval>
241 Returns the maximum interval value for future bookings
245 Returns the configuration for WebDAV
247 =item C<get_webdav_documents>
249 Returns the configuration for storing documents in the corresponding WebDAV folder
251 =item C<get_vertreter>
253 Returns the configuration for "vertreter"
255 =item C<get_parts_show_image>
257 Returns the configuarion for show image in parts
259 =item C<get_parts_image_css>
261 Returns the css format string for images shown in parts
263 =item C<get_parts_listing_image>
265 Returns the configuration for showing the picture in the results when you search for parts
271 Updates to the I<defaults> table require that the instance
272 configuration is re-read. This has not been implemented yet.
276 Moritz Bunkus E<lt>m.bunkus@linet-services.deE<gt>