forked from emaijala/MLInvoice
/
open_invoices.php
executable file
·123 lines (115 loc) · 3.56 KB
/
open_invoices.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
<?php
/**
* Open invoices etc.
*
* PHP version 5
*
* Copyright (C) 2004-2008 Samu Reinikainen
* Copyright (C) 2010-2018 Ere Maijala
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License version 2,
* as published by the Free Software Foundation.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
*
* @category MLInvoice
* @package MLInvoice\Base
* @author Ere Maijala <ere@labs.fi>
* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License
* @link http://labs.fi/mlinvoice.eng.php
*/
require_once 'htmlfuncs.php';
require_once 'sqlfuncs.php';
require_once 'miscfuncs.php';
require_once 'datefuncs.php';
require_once 'translator.php';
require_once 'list.php';
require_once 'settings.php';
/**
* Create open invoice list
*
* @return void
*/
function createOpenInvoiceList()
{
$currentDate = date('Ymd');
$res = dbQueryCheck(
"select count(*) as cnt from {prefix}invoice i where i.deleted = 0"
. " AND i.interval_type > 0 AND i.next_interval_date <= $currentDate"
. " AND i.archived = 0"
);
$row = mysqli_fetch_assoc($res);
if ($row['cnt'] > 0) {
createList(
'open_invoices', 'invoice', 'resultlist_repeating_invoices',
Translator::translate('LabelInvoicesWithIntervalDue'),
"i.interval_type > 0 AND i.next_interval_date <= $currentDate"
. " AND i.archived = 0",
true,
false,
'invoice'
);
}
$open = '';
$res = dbQueryCheck(
'SELECT id FROM {prefix}invoice_state WHERE invoice_open=1'
. ' AND invoice_offer=0'
);
while ($id = dbFetchValue($res)) {
if ($open) {
$open .= ', ';
}
$open .= $id;
}
$unpaid = '';
$res = dbQueryCheck(
'SELECT id FROM {prefix}invoice_state WHERE invoice_open=0'
. ' AND invoice_unpaid=1 AND invoice_offer=0'
);
while ($id = dbFetchValue($res)) {
if ($unpaid) {
$unpaid .= ', ';
}
$unpaid .= $id;
}
$openOffers = '';
$res = dbQueryCheck(
'SELECT id FROM {prefix}invoice_state WHERE invoice_open=1'
. ' AND invoice_offer=1'
);
while ($id = dbFetchValue($res)) {
if ($openOffers) {
$openOffers .= ', ';
}
$openOffers .= $id;
}
if ($open) {
createList(
'open_invoices', 'invoice', 'resultlist_open_invoices',
Translator::translate('LabelOpenInvoices'),
"i.state_id IN ($open) AND i.archived=0", true, false, 'invoice'
);
}
if ($unpaid) {
createList(
'open_invoices', 'invoice', 'resultlist_unpaid_invoices',
Translator::translate('LabelUnpaidInvoices'),
"i.state_id IN ($unpaid) AND i.archived=0", true, true, 'invoice'
);
}
if ($openOffers) {
createList(
'open_invoices', 'offer', 'resultlist_offers',
Translator::translate('LabelUnfinishedOffers'),
"i.state_id IN ($openOffers) AND i.archived=0", true, false, 'offer'
);
}
}