Lines 203-209
sub ModBranch {
Link Here
|
203 |
my $query = " |
203 |
my $query = " |
204 |
INSERT INTO branches |
204 |
INSERT INTO branches |
205 |
(branchcode,branchname,branchaddress1, |
205 |
(branchcode,branchname,branchaddress1, |
206 |
branchaddress2,branchaddress3,branchzip,branchcity, |
206 |
branchaddress2,branchaddress3,branchzip,branchcity,branchstate, |
207 |
branchcountry,branchphone,branchfax,branchemail, |
207 |
branchcountry,branchphone,branchfax,branchemail, |
208 |
branchurl,branchip,branchprinter,branchnotes) |
208 |
branchurl,branchip,branchprinter,branchnotes) |
209 |
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) |
209 |
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) |
Lines 213-219
sub ModBranch {
Link Here
|
213 |
$data->{'branchcode'}, $data->{'branchname'}, |
213 |
$data->{'branchcode'}, $data->{'branchname'}, |
214 |
$data->{'branchaddress1'}, $data->{'branchaddress2'}, |
214 |
$data->{'branchaddress1'}, $data->{'branchaddress2'}, |
215 |
$data->{'branchaddress3'}, $data->{'branchzip'}, |
215 |
$data->{'branchaddress3'}, $data->{'branchzip'}, |
216 |
$data->{'branchcity'}, $data->{'branchcountry'}, |
216 |
$data->{'branchcity'}, $data->{'branchstate'}, |
|
|
217 |
$data->{'branchcountry'}, |
217 |
$data->{'branchphone'}, $data->{'branchfax'}, |
218 |
$data->{'branchphone'}, $data->{'branchfax'}, |
218 |
$data->{'branchemail'}, $data->{'branchurl'}, |
219 |
$data->{'branchemail'}, $data->{'branchurl'}, |
219 |
$data->{'branchip'}, $data->{'branchprinter'}, |
220 |
$data->{'branchip'}, $data->{'branchprinter'}, |
Lines 225-231
sub ModBranch {
Link Here
|
225 |
UPDATE branches |
226 |
UPDATE branches |
226 |
SET branchname=?,branchaddress1=?, |
227 |
SET branchname=?,branchaddress1=?, |
227 |
branchaddress2=?,branchaddress3=?,branchzip=?, |
228 |
branchaddress2=?,branchaddress3=?,branchzip=?, |
228 |
branchcity=?,branchcountry=?,branchphone=?, |
229 |
branchcity=?,branchstate=?,branchcountry=?,branchphone=?, |
229 |
branchfax=?,branchemail=?,branchurl=?,branchip=?, |
230 |
branchfax=?,branchemail=?,branchurl=?,branchip=?, |
230 |
branchprinter=?,branchnotes=? |
231 |
branchprinter=?,branchnotes=? |
231 |
WHERE branchcode=? |
232 |
WHERE branchcode=? |
Lines 235-241
sub ModBranch {
Link Here
|
235 |
$data->{'branchname'}, |
236 |
$data->{'branchname'}, |
236 |
$data->{'branchaddress1'}, $data->{'branchaddress2'}, |
237 |
$data->{'branchaddress1'}, $data->{'branchaddress2'}, |
237 |
$data->{'branchaddress3'}, $data->{'branchzip'}, |
238 |
$data->{'branchaddress3'}, $data->{'branchzip'}, |
238 |
$data->{'branchcity'}, $data->{'branchcountry'}, |
239 |
$data->{'branchcity'}, $data->{'branchstate'}, |
|
|
240 |
$data->{'branchcountry'}, |
239 |
$data->{'branchphone'}, $data->{'branchfax'}, |
241 |
$data->{'branchphone'}, $data->{'branchfax'}, |
240 |
$data->{'branchemail'}, $data->{'branchurl'}, |
242 |
$data->{'branchemail'}, $data->{'branchurl'}, |
241 |
$data->{'branchip'}, $data->{'branchprinter'}, |
243 |
$data->{'branchip'}, $data->{'branchprinter'}, |