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