Revision 266101c7
Von Jan Büren vor fast 9 Jahren hinzugefügt
| SL/RP.pm | ||
|---|---|---|
| 746 | 746 |
$customer_join |
| 747 | 747 |
WHERE ((select date_trunc('year', ac.transdate::date)) = (select date_trunc('year', ?::date))) AND ac.ob_transaction
|
| 748 | 748 |
$dpt_where_without_arapgl |
| 749 |
$dpt_where |
|
| 750 | 749 |
$customer_where |
| 751 | 750 |
$project |
| 752 | 751 |
GROUP BY c.accno, c.category, c.description |; |
| ... | ... | |
| 931 | 930 |
$customer_join |
| 932 | 931 |
WHERE $where |
| 933 | 932 |
$dpt_where_without_arapgl |
| 934 |
$dpt_where |
|
| 935 | 933 |
$customer_where |
| 936 | 934 |
$project |
| 937 | 935 |
AND (ac.amount < 0) |
| ... | ... | |
| 943 | 941 |
$customer_join |
| 944 | 942 |
WHERE $where |
| 945 | 943 |
$dpt_where_without_arapgl |
| 946 |
$dpt_where |
|
| 947 | 944 |
$customer_where |
| 948 | 945 |
$project |
| 949 | 946 |
AND ac.amount > 0 |
| ... | ... | |
| 954 | 951 |
$customer_join |
| 955 | 952 |
WHERE $saldowhere |
| 956 | 953 |
$dpt_where_without_arapgl |
| 957 |
$dpt_where |
|
| 958 | 954 |
$customer_where |
| 959 | 955 |
$project |
| 960 | 956 |
AND c.accno = ? AND (NOT ac.ob_transaction OR ac.ob_transaction IS NULL)) AS saldo, |
| ... | ... | |
| 965 | 961 |
$customer_join |
| 966 | 962 |
WHERE $sumwhere |
| 967 | 963 |
$dpt_where_without_arapgl |
| 968 |
$dpt_where |
|
| 969 | 964 |
$customer_where |
| 970 | 965 |
$project |
| 971 | 966 |
AND ac.amount > 0 |
| ... | ... | |
| 977 | 972 |
$customer_join |
| 978 | 973 |
WHERE $sumwhere |
| 979 | 974 |
$dpt_where_without_arapgl |
| 980 |
$dpt_where |
|
| 981 | 975 |
$customer_where |
| 982 | 976 |
$project |
| 983 | 977 |
AND ac.amount < 0 |
| ... | ... | |
| 988 | 982 |
$customer_join |
| 989 | 983 |
WHERE $where |
| 990 | 984 |
$dpt_where_without_arapgl |
| 991 |
$dpt_where |
|
| 992 | 985 |
$customer_where |
| 993 | 986 |
$project |
| 994 | 987 |
AND c.accno = ?) AS last_transaction |
| ... | ... | |
| 1065 | 1058 |
$customer_join |
| 1066 | 1059 |
WHERE $where |
| 1067 | 1060 |
$dpt_where_without_arapgl |
| 1068 |
$dpt_where |
|
| 1069 | 1061 |
$customer_where |
| 1070 | 1062 |
$project |
| 1071 | 1063 |
AND c.accno = ?) AS last_transaction |
Auch abrufbar als: Unified diff
SuSa Abteilungsauswahl liefert SQL-Fehler
Im Nachgang zu b8fee3fc (dpt_trans aus RP.pm entfernen) - Vergessene
dpt_where weiter entfernt, sodass die SuSa nach Abteilungsauswahl
wieder geht.
Getestet mit Soll- und Ist-Haken bei SuSa