|
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 %] |