Revision 891fe11e
Von Jan Büren vor fast 14 Jahren hinzugefügt
| SL/RP.pm | ||
|---|---|---|
| 1182 | 1182 |
$dpt_join = qq| JOIN department d ON (a.department_id = d.id) |; |
| 1183 | 1183 |
$where .= qq| AND (a.department_id = | . conv_i($department_id, 'NULL') . qq|)|; |
| 1184 | 1184 |
} |
| 1185 |
my $review_of_aging_list; |
|
| 1186 |
if ($form->{review_of_aging_list}) {
|
|
| 1187 |
if ($form->{review_of_aging_list} =~ m "-"){
|
|
| 1188 |
my @period = split(/-/, $form->{review_of_aging_list});
|
|
| 1189 |
$review_of_aging_list = " AND $period[0] < date_part('days', now() - duedate)
|
|
| 1190 |
AND date_part('days', now() - duedate) < $period[1]";
|
|
| 1191 |
} else {
|
|
| 1192 |
$form->{review_of_aging_list} =~ s/[^0-9]//g;
|
|
| 1193 |
$review_of_aging_list = " AND $form->{review_of_aging_list} < date_part('days', now() - duedate)";
|
|
| 1194 |
} |
|
| 1195 |
} |
|
| 1185 | 1196 |
|
| 1186 | 1197 |
my $q_details = qq| |
| 1187 |
-- between 0-30 days |
|
| 1188 | 1198 |
|
| 1189 | 1199 |
SELECT ${ct}.id AS ctid, ${ct}.name,
|
| 1190 | 1200 |
street, zipcode, city, country, contact, email, |
| ... | ... | |
| 1202 | 1212 |
AND (${arap}.${ct}_id = ${ct}.id)
|
| 1203 | 1213 |
AND (${ct}.id = ?)
|
| 1204 | 1214 |
AND (transdate <= (date $todate) $fromwhere ) |
| 1205 |
|
|
| 1215 |
$review_of_aging_list |
|
| 1206 | 1216 |
ORDER BY ctid, transdate, invnumber |; |
| 1207 | 1217 |
|
| 1208 | 1218 |
my $sth_details = prepare_query($form, $dbh, $q_details); |
| bin/mozilla/rp.pl | ||
|---|---|---|
| 265 | 265 |
|
| 266 | 266 |
<input type=hidden name=title value="$form->{title}">
|
| 267 | 267 |
|
| 268 |
<table width=100%> |
|
| 268 |
<table width=100% border="0">
|
|
| 269 | 269 |
<tr> |
| 270 | 270 |
<th class=listtop>$form->{title}</th>
|
| 271 | 271 |
</tr> |
| 272 | 272 |
<tr height="5"></tr> |
| 273 | 273 |
<tr> |
| 274 | 274 |
<td> |
| 275 |
<table> |
|
| 275 |
<table border="0">
|
|
| 276 | 276 |
$department |
| 277 | 277 |
|; |
| 278 | 278 |
|
| ... | ... | |
| 805 | 805 |
<th align=right>| . $locale->text($label) . qq|</th> |
| 806 | 806 |
<td>$vc</td> |
| 807 | 807 |
</tr> |
| 808 |
<tr> |
|
| 809 |
<td>| . $locale->text('Review of Aging list') . qq|</td>
|
|
| 810 |
<td><select name="review_of_aging_list"> |
|
| 811 |
<option></option> |
|
| 812 |
<option>0-30</option> |
|
| 813 |
<option>30-60</option> |
|
| 814 |
<option>60-90</option> |
|
| 815 |
<option>90-120</option> |
|
| 816 |
<option>> 120</option> |
|
| 817 |
</select> |
|
| 818 |
</td> |
|
| 819 |
</tr> |
|
| 808 | 820 |
<tr> |
| 809 | 821 |
<td align=left colspan=4>| . $locale->text('From') . qq|
|
| 810 | 822 |
$button1 |
| doc/changelog | ||
|---|---|---|
| 19 | 19 |
befinden anzuzeigen (s.a.: doc/excel_templates.txt). |
| 20 | 20 |
- FiBu -> Bericht um Suchfeld Kontonummer erweitert |
| 21 | 21 |
- Ansprechpartner für abweichende Lieferadresse, um das Attribut Geschlecht erweitert |
| 22 |
- FiBu -> Bericht -> Offene Forderung | Offene Verbindlichkeiten um Altersstrukturliste (30, 60, 90, 120) erweitert |
|
| 22 | 23 |
|
| 23 | 24 |
API Änderungen: |
| 24 | 25 |
|
| locale/de/all | ||
|---|---|---|
| 1358 | 1358 |
'Revenue Account' => 'Erl?skonto', |
| 1359 | 1359 |
'Revenues EU with UStId' => 'Erlöse EU m. UStId', |
| 1360 | 1360 |
'Revenues EU without UStId' => 'Erlöse EU o. UStId', |
| 1361 |
'Review of Aging list' => 'Altersstrukturliste', |
|
| 1361 | 1362 |
'Right' => 'Rechts', |
| 1362 | 1363 |
'SAVED' => 'Gespeichert', |
| 1363 | 1364 |
'SAVED FOR DUNNING' => 'Gespeichert', |
Auch abrufbar als: Unified diff
FiBu -> Bericht -> Offene Forderung | Offene Verbindlichkeiten um Altersstrukturliste (30, 60, 90, 120) erweitert