|
1
|
|
|
<?php |
|
2
|
|
|
class Intraface_modules_accounting_AccountGateway |
|
3
|
|
|
{ |
|
4
|
|
|
private $year; |
|
5
|
|
|
private $types = array( |
|
6
|
|
|
1 => 'headline', |
|
7
|
|
|
2 => 'operating', // drift |
|
8
|
|
|
3 => 'balance, asset', // aktiv |
|
9
|
|
|
4 => 'balance, liability', // passiv |
|
10
|
|
|
5 => 'sum' |
|
11
|
|
|
); |
|
12
|
|
|
|
|
13
|
|
|
private $use = array( |
|
14
|
|
|
1 => 'none', |
|
15
|
|
|
2 => 'income', |
|
16
|
|
|
3 => 'expenses', |
|
17
|
|
|
4 => 'finance' |
|
18
|
|
|
); |
|
19
|
|
|
|
|
20
|
|
|
private $vat = array( |
|
21
|
|
|
0 => 'none', |
|
22
|
|
|
1 => 'in', |
|
23
|
|
|
2 => 'out' |
|
24
|
|
|
); |
|
25
|
|
|
|
|
26
|
|
|
|
|
27
|
17 |
|
function __construct($year) |
|
28
|
|
|
{ |
|
29
|
17 |
|
$this->year = $year; |
|
30
|
17 |
|
} |
|
31
|
|
|
|
|
32
|
|
|
/** |
|
33
|
|
|
* Denne funktion bruges bl.a. under bogf�ringen, s� man bare taster kontonummer |
|
34
|
|
|
* og s� s�ttes den rigtige konto. |
|
35
|
|
|
* |
|
36
|
|
|
* @param integer $account_number |
|
37
|
|
|
* |
|
38
|
|
|
* @return object |
|
39
|
|
|
*/ |
|
40
|
13 |
|
public function findFromNumber($account_number) |
|
41
|
|
|
{ |
|
42
|
12 |
|
$account_number = (int)$account_number; |
|
43
|
|
|
|
|
44
|
12 |
|
if ($this->year->get('id') == 0) { |
|
45
|
|
|
return 0; |
|
46
|
|
|
} |
|
47
|
|
|
|
|
48
|
|
|
$sql = "SELECT id FROM accounting_account |
|
49
|
12 |
|
WHERE number = '".$account_number."' |
|
50
|
12 |
|
AND intranet_id = ".$this->year->kernel->intranet->get('id')." |
|
51
|
12 |
|
AND year_id = ".$this->year->get('id')." AND active = 1 |
|
52
|
12 |
|
LIMIT 1"; |
|
53
|
|
|
|
|
54
|
13 |
|
$db = new Db_Sql; |
|
55
|
12 |
|
$db->query($sql); |
|
56
|
|
|
|
|
57
|
12 |
|
if (!$db->nextRecord()) { |
|
58
|
1 |
|
return new Account($this->year); |
|
59
|
|
|
} |
|
60
|
|
|
|
|
61
|
11 |
|
return new Account($this->year, $db->f('id')); |
|
62
|
|
|
} |
|
63
|
|
|
|
|
64
|
|
|
/** |
|
65
|
|
|
* @deprecated |
|
66
|
|
|
* @param $id |
|
67
|
|
|
* @return unknown_type |
|
68
|
|
|
*/ |
|
69
|
|
|
function findFromId($id) |
|
70
|
|
|
{ |
|
71
|
|
|
return $this->findById($id); |
|
72
|
|
|
} |
|
73
|
|
|
|
|
74
|
|
|
function findById($id) |
|
75
|
11 |
|
{ |
|
76
|
|
|
require_once dirname(__FILE__) . '/Account.php'; |
|
77
|
11 |
|
return new Account($this->year, $id); |
|
78
|
11 |
|
} |
|
79
|
|
|
|
|
80
|
|
|
function findByType($type, $saldo = false) |
|
81
|
|
|
{ |
|
82
|
|
|
return $this->getList($type, $saldo); |
|
83
|
|
|
} |
|
84
|
|
|
|
|
85
|
|
|
function getAll() |
|
86
|
|
|
{ |
|
87
|
|
|
return $this->getList(); |
|
88
|
|
|
} |
|
89
|
|
|
|
|
90
|
|
|
/** |
|
91
|
|
|
* Returns collection with all accounts |
|
92
|
|
|
* |
|
93
|
|
|
* @param string $type Typen af konto, kig i Account::type; |
|
94
|
|
|
* @param boolean $saldo Whether to return the saldo |
|
95
|
|
|
* |
|
96
|
|
|
* @return array |
|
97
|
|
|
*/ |
|
98
|
|
|
public function getList($type = '', $saldo = false) |
|
99
|
1 |
|
{ |
|
100
|
|
|
$type = safeToDb($type); |
|
101
|
1 |
|
$type_sql = ''; |
|
102
|
1 |
|
|
|
103
|
|
|
//if ($this->year->get('id') == 0 || $this->id == 0) { |
|
|
|
|
|
|
104
|
|
|
if ($this->year->get('id') == 0) { |
|
105
|
1 |
|
//$this->value['id'] = 0; |
|
|
|
|
|
|
106
|
|
|
//$this->id = 0; |
|
|
|
|
|
|
107
|
|
|
return array(); |
|
108
|
|
|
} |
|
109
|
|
|
|
|
110
|
|
|
$db = new DB_Sql; |
|
111
|
1 |
|
if (!empty($type)) { |
|
112
|
1 |
|
switch ($type) { |
|
113
|
|
|
case 'expenses': |
|
114
|
1 |
|
$type_sql = " AND use_key = '".array_search('expenses', $this->use)."'"; |
|
115
|
|
|
break; |
|
116
|
|
|
case 'income': |
|
117
|
1 |
|
$type_sql = " AND use_key = '".array_search('income', $this->use)."'"; |
|
118
|
|
|
break; |
|
119
|
|
|
case 'finance': |
|
120
|
1 |
|
$type_sql = " AND use_key = '".array_search('finance', $this->use)."'"; |
|
121
|
|
|
break; |
|
122
|
|
|
case 'balance': |
|
123
|
1 |
|
// fall through |
|
124
|
|
|
case 'status': |
|
125
|
1 |
|
$type_sql = " AND (type_key = '".array_search('balance, liability', $this->types)."' OR type_key = '".array_search('balance, asset', $this->types)."')"; |
|
126
|
|
|
break; |
|
127
|
|
|
case 'drift': |
|
128
|
1 |
|
// fall through |
|
129
|
|
|
case 'operating': |
|
130
|
1 |
|
$type_sql = " AND type_key = '".array_search('operating', $this->types)."'"; |
|
131
|
1 |
|
break; |
|
132
|
1 |
|
default: |
|
133
|
|
|
break; |
|
134
|
|
|
} |
|
135
|
|
|
} |
|
136
|
1 |
|
$accounts = array(); |
|
137
|
1 |
|
$sql = "SELECT |
|
138
|
|
|
account.id, |
|
139
|
|
|
account.number, |
|
140
|
|
|
account.name, |
|
141
|
|
|
account.type_key, |
|
142
|
|
|
account.primosaldo_debet, |
|
143
|
|
|
account.primosaldo_credit, |
|
144
|
|
|
account.created_from_id, |
|
145
|
|
|
account.vat_key, |
|
146
|
|
|
account.sum_from_account_number, |
|
147
|
|
|
account.sum_to_account_number |
|
148
|
|
|
FROM accounting_account account |
|
149
|
|
|
WHERE intranet_id = ".$this->year->kernel->intranet->get('id')." ".$type_sql." |
|
150
|
1 |
|
AND active = 1 AND year_id = ".$this->year->get('id')." ORDER BY number ASC"; |
|
151
|
1 |
|
|
|
152
|
|
|
$db->query($sql); |
|
153
|
1 |
|
|
|
154
|
|
|
$i = 0; |
|
155
|
1 |
|
while ($db->nextRecord()) { |
|
156
|
1 |
|
$accounts[$i]['id'] = $db->f('id'); |
|
157
|
|
|
$accounts[$i]['name'] = $db->f('name'); |
|
158
|
|
|
$accounts[$i]['number'] = $db->f('number'); |
|
159
|
|
|
$accounts[$i]['type_key'] = $db->f('type_key'); |
|
160
|
|
|
$accounts[$i]['type'] = $this->types[$db->f('type_key')]; |
|
161
|
|
|
$accounts[$i]['sum_from'] = $db->f('sum_from_account_number'); |
|
162
|
|
|
$accounts[$i]['sum_to'] = $db->f('sum_to_account_number'); |
|
163
|
|
|
|
|
164
|
|
|
|
|
165
|
|
|
$accounts[$i]['primosaldo_debet'] = $db->f('primosaldo_debet'); |
|
166
|
|
|
$accounts[$i]['primosaldo_credit'] = $db->f('primosaldo_credit'); |
|
167
|
|
|
$accounts[$i]['created_from_id'] = $db->f('created_from_id'); |
|
168
|
|
|
$accounts[$i]['vat_shorthand'] = $this->vat[$db->f('vat_key')]; |
|
169
|
|
|
|
|
170
|
|
|
if ($saldo === true) { |
|
171
|
|
|
$account = new Account($this->year, $db->f('id')); |
|
172
|
|
|
$account->getSaldo(); |
|
173
|
|
|
$accounts[$i]['debet'] = $account->get('debet'); |
|
174
|
|
|
$accounts[$i]['credit'] = $account->get('credit'); |
|
175
|
|
|
$accounts[$i]['saldo'] = $account->get('saldo'); |
|
176
|
|
|
} |
|
177
|
|
|
|
|
178
|
|
|
|
|
179
|
|
|
$i++; |
|
180
|
|
|
} |
|
181
|
|
|
return $accounts; |
|
182
|
1 |
|
} |
|
183
|
|
|
|
|
184
|
|
|
function anyAccounts() |
|
185
|
2 |
|
{ |
|
186
|
|
|
$db = new DB_Sql; |
|
187
|
2 |
|
$sql = "SELECT id |
|
188
|
|
|
FROM accounting_account |
|
189
|
|
|
WHERE intranet_id = " . $this->year->kernel->intranet->get("id") . " AND year_id = ".$this->year->get('id')." AND active = 1"; |
|
190
|
2 |
|
$db->query($sql); |
|
191
|
2 |
|
|
|
192
|
|
|
return $db->numRows(); |
|
193
|
2 |
|
} |
|
194
|
|
|
} |
|
195
|
|
|
|
intraface /
intraface.dk
Loading history...
Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it.
The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production.
This check looks for comments that seem to be mostly valid code and reports them.