Lines 139-147
sub AddBookseller {
Link Here
|
139 |
postal, phone, accountnumber,fax, url, |
139 |
postal, phone, accountnumber,fax, url, |
140 |
active, listprice, invoiceprice, gstreg, |
140 |
active, listprice, invoiceprice, gstreg, |
141 |
listincgst,invoiceincgst, tax_rate, discount, notes, |
141 |
listincgst,invoiceincgst, tax_rate, discount, notes, |
142 |
deliverytime |
142 |
deliverytime, shipping_tax_rate, shippingincgst |
143 |
) |
143 |
) |
144 |
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) | |
144 |
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) | |
145 |
; |
145 |
; |
146 |
my $sth = $dbh->prepare($query); |
146 |
my $sth = $dbh->prepare($query); |
147 |
$sth->execute( |
147 |
$sth->execute( |
Lines 155-160
sub AddBookseller {
Link Here
|
155 |
$data->{'listincgst'}, $data->{'invoiceincgst'}, |
155 |
$data->{'listincgst'}, $data->{'invoiceincgst'}, |
156 |
$data->{'tax_rate'}, $data->{'discount'}, |
156 |
$data->{'tax_rate'}, $data->{'discount'}, |
157 |
$data->{notes}, $data->{deliverytime}, |
157 |
$data->{notes}, $data->{deliverytime}, |
|
|
158 |
$data->{shipping_tax_rate}, $data->{shippingincgst}, |
158 |
); |
159 |
); |
159 |
|
160 |
|
160 |
# return the id of this new supplier |
161 |
# return the id of this new supplier |
Lines 196-202
sub ModBookseller {
Link Here
|
196 |
postal=?,phone=?,accountnumber=?,fax=?,url=?, |
197 |
postal=?,phone=?,accountnumber=?,fax=?,url=?, |
197 |
active=?,listprice=?, invoiceprice=?, |
198 |
active=?,listprice=?, invoiceprice=?, |
198 |
gstreg=?,listincgst=?,invoiceincgst=?, |
199 |
gstreg=?,listincgst=?,invoiceincgst=?, |
199 |
discount=?,notes=?,tax_rate=?,deliverytime=? |
200 |
discount=?,notes=?,tax_rate=?,deliverytime=?, |
|
|
201 |
shipping_tax_rate = ?, shippingincgst = ? |
200 |
WHERE id=?'; |
202 |
WHERE id=?'; |
201 |
my $sth = $dbh->prepare($query); |
203 |
my $sth = $dbh->prepare($query); |
202 |
my $cnt = $sth->execute( |
204 |
my $cnt = $sth->execute( |
Lines 210-215
sub ModBookseller {
Link Here
|
210 |
$data->{'listincgst'}, $data->{'invoiceincgst'}, |
212 |
$data->{'listincgst'}, $data->{'invoiceincgst'}, |
211 |
$data->{'discount'}, $data->{'notes'}, |
213 |
$data->{'discount'}, $data->{'notes'}, |
212 |
$data->{'tax_rate'}, $data->{deliverytime}, |
214 |
$data->{'tax_rate'}, $data->{deliverytime}, |
|
|
215 |
$data->{shipping_tax_rate}, $data->{shippingincgst}, |
213 |
$data->{'id'} |
216 |
$data->{'id'} |
214 |
); |
217 |
); |
215 |
$contacts ||= $data->{'contacts'}; |
218 |
$contacts ||= $data->{'contacts'}; |