Hi to all,
i am using this global to view a SUM of data-records with a special value in colun "Ausgabe":
my $cond = new GT::SQL::Condition;
my($ausgabe)=@_;
$cond->bool('AND');
$cond->add('Ausgabe','=',$ausgabe);
$cond->add('MagArt','=','gumag');
my ($total) = $DB->table('Links')->select(['SUM(Wert)'],$cond)->fetchrow_array;
local $_ = int $total;
my($grouping,$thousands_sep);
$grouping=3;
$thousands_sep='.';
1 while
s/(\d)(\d{$grouping}($|\Q$thousands_sep\E))/$1$thousands_sep$2/;
return "$_";
}
The using is:
1. I define the "Ausgabe" from the actual date and
2. put this Ausgabe (format: mm-yyyy) into global like this:
<%set Ausgabe = GT::Date::date_transform($date, '%dd%.%mm%.%yyyy%', '%mm%-%yyyy%')%>
<%gutscheine_wert($Ausgabe)%>
Now what i need is this:
When the actual "Ausgabe" is not in db (e.g. 02-2005), then the global search for the last available date, in this case: 01-2005.
Perhaps: IF $total = 0 ...... etc ....... ???
How can i do that?
Thanks in advance!
Coyu
i am using this global to view a SUM of data-records with a special value in colun "Ausgabe":
Code:
sub { my $cond = new GT::SQL::Condition;
my($ausgabe)=@_;
$cond->bool('AND');
$cond->add('Ausgabe','=',$ausgabe);
$cond->add('MagArt','=','gumag');
my ($total) = $DB->table('Links')->select(['SUM(Wert)'],$cond)->fetchrow_array;
local $_ = int $total;
my($grouping,$thousands_sep);
$grouping=3;
$thousands_sep='.';
1 while
s/(\d)(\d{$grouping}($|\Q$thousands_sep\E))/$1$thousands_sep$2/;
return "$_";
}
The using is:
1. I define the "Ausgabe" from the actual date and
2. put this Ausgabe (format: mm-yyyy) into global like this:
<%set Ausgabe = GT::Date::date_transform($date, '%dd%.%mm%.%yyyy%', '%mm%-%yyyy%')%>
<%gutscheine_wert($Ausgabe)%>
Now what i need is this:
When the actual "Ausgabe" is not in db (e.g. 02-2005), then the global search for the last available date, in this case: 01-2005.
Perhaps: IF $total = 0 ...... etc ....... ???
How can i do that?
Thanks in advance!
Coyu