MV_OPTION_TABLE — name of database for product options
If the Interchange variable MV_OPTION_TABLE is not set, it
defaults to "options", which combines options for Simple, Matrix, and
Modular into that one table.
The term database in Interchange lingo has a different meaning as in common language, please check database for more information.
Interchange 5.9.0:
Source: lib/Vend/Options.pm
Line 104 (context shows lines 94-108 in find_options_type():61)
};
$item->{$attrib} = tag_data($tab, $field, $sku);
}
$module = $item->{$attrib} || '';
}
else {
## Old style options
my $loc = $Vend::Cfg->{Options_repository}{Old48} || {};
my $table = $opt->{table}
||= (
$loc->{table} || $::Variable->{MV_OPTION_TABLE} || 'options'
);
my $db = $Vend::Interpolate::Db{$table} || database_exists_ref($table)
or return;
$db->record_exists($sku)
Source: lib/Vend/Options/Simple.pm
Line 152 (context shows lines 142-156 in display_options():138)
$loc ||= $Vend::Cfg->{Options_repository}{Simple} || {};
my $map = $loc->{map} || {};
my $sku = $item->{code};
my $db;
my $tab;
if(not $db = $opt->{options_db}) {
$tab = $opt->{table} ||= $loc->{table}
||= $::Variable->{MV_OPTION_TABLE}
||= 'options';
$db = database_exists_ref($tab)
or do {
logOnce(
Source: lib/Vend/Options/Old48.pm
Line 87 (context shows lines 77-91 in display_options_matrix():77)
sub display_options_matrix {
my ($item, $opt, $loc) = @_;
$loc ||= $Vend::Cfg->{Options_repository}{Old48} || \%Default;
#::logDebug("Matrix options by module, old");
my $sku = $item->{mv_sku} || $item->{code};
my $db;
my $tab;
if(not $db = $opt->{options_db}) {
$tab = $opt->{table} || $::Variable->{MV_OPTION_TABLE} || 'options';
$db = database_exists_ref($tab)
or do {
logOnce(
"Matrix options: unable to find table %s for item %s",
Source: lib/Vend/Options/Old48.pm
Line 359 (context shows lines 349-363 in display_options_simple():348)
my ($item, $opt) = @_;
#::logDebug("Simple options, item=" . ::uneval($item) . "\nopt=" . ::uneval($opt));
my $map = $opt->{options_map} ||= {};
#::logDebug("Simple options by module, old");
my $sku = $item->{code};
my $db;
my $tab;
if(not $db = $opt->{options_db}) {
$tab = $opt->{table} ||= $::Variable->{MV_OPTION_TABLE_SIMPLE}
||= $::Variable->{MV_OPTION_TABLE}
||= 'options';
$db = database_exists_ref($tab)
or do {
logOnce(