|
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'}, |