Lines 5-10
if( CheckVersion( $DBversion ) ) {
Link Here
|
5 |
INSERT IGNORE INTO account_offset_types ( type ) VALUES ( 'Purchase' ); |
5 |
INSERT IGNORE INTO account_offset_types ( type ) VALUES ( 'Purchase' ); |
6 |
}); |
6 |
}); |
7 |
|
7 |
|
|
|
8 |
$dbh->do(q{ |
9 |
INSERT INTO account_credit_types ( code, description, can_be_added_manually, is_system ) |
10 |
VALUES ('PURCHASE', 'Purchase', 0, 1); |
11 |
}); |
12 |
|
8 |
my $sth = $dbh->prepare(q{ |
13 |
my $sth = $dbh->prepare(q{ |
9 |
SELECT COUNT(*) FROM authorised_values WHERE category = 'PAYMENT_TYPE' AND authorised_value = 'CASH' |
14 |
SELECT COUNT(*) FROM authorised_values WHERE category = 'PAYMENT_TYPE' AND authorised_value = 'CASH' |
10 |
}); |
15 |
}); |
Lines 40-46
if( CheckVersion( $DBversion ) ) {
Link Here
|
40 |
|
45 |
|
41 |
$dbh->do(q{ |
46 |
$dbh->do(q{ |
42 |
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES |
47 |
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES |
43 |
('pos', 'RECEIPT', '', 'Point of sale receipt', 0, 'Receipt', '<table> |
48 |
('pos', 'RECEIPT', '', 'Point of sale receipt', 0, 'Receipt', '[% PROCESS "accounts.inc" %] |
|
|
49 |
<table> |
44 |
[% IF ( LibraryName ) %] |
50 |
[% IF ( LibraryName ) %] |
45 |
<tr> |
51 |
<tr> |
46 |
<th colspan="2" class="centerednames"> |
52 |
<th colspan="2" class="centerednames"> |
Lines 83-89
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`,
Link Here
|
83 |
|
89 |
|
84 |
[% FOREACH offset IN offsets %] |
90 |
[% FOREACH offset IN offsets %] |
85 |
<tr> |
91 |
<tr> |
86 |
<td>[% offset.debit.accounttype %]</td> |
92 |
<td>[% PROCESS account_type_description account=offset.debit %]</td> |
87 |
<td>[% offset.amount * -1 | $Price %]</td> |
93 |
<td>[% offset.amount * -1 | $Price %]</td> |
88 |
</tr> |
94 |
</tr> |
89 |
[% END %] |
95 |
[% END %] |