-my $input = new CGI;
-my $searchfield=$input->param('searchfield');
-my $pkfield="branchcode";
-my $reqsel="select branchcode,branchname,branchaddress1,branchaddress2,branchaddress3,branchphone,branchfax,branchemail,issuing from branches where branchcode='$searchfield'";
-my $reqdel="delete from branches where branchcode='$searchfield'";
-#my $branchcode=$input->param('branchcode');
-my $offset=$input->param('offset');
-my $script_name="/cgi-bin/koha/admin/branches.pl";
-
-my $pagesize=20;
-my $op = $input->param('op');
-$searchfield=~ s/\,//g;
-print $input->header;
-
-#start the page and read in includes
-print startpage();
-print startmenu('admin');
-
-################## ADD_FORM ##################################
-# called by default. Used to create form to add or modify a record
-if ($op eq 'add_form') {
- #---- if primkey exists, it's a modify action, so read values to modify...
- my $data;
- if ($searchfield) {
- my $dbh = &C4Connect;
- my $sth=$dbh->prepare("select branchcode,branchname,branchaddress1,branchaddress2,branchaddress3,branchphone,branchfax,branchemail,issuing from branches where branchcode='$searchfield'");
- $sth->execute;
- $data=$sth->fetchrow_hashref;
- $sth->finish;
- }
- print <<printend
- <script>
- /////////////////////////////////////////////////////////////////////////////////////////////////////////////////
- function isNotNull(f,noalert) {
- if (f.value.length ==0) {
- return false;
- }
- return true;
- }
- /////////////////////////////////////////////////////////////////////////////////////////////////////////////////
- function toUC(f) {
- var x=f.value.toUpperCase();
- f.value=x;
- return true;
- }
- /////////////////////////////////////////////////////////////////////////////////////////////////////////////////
- function isNum(v,maybenull) {
- var n = new Number(v.value);
- if (isNaN(n)) {
- return false;
- }
- if (maybenull==0 && v.value=='') {
- return false;
- }
- return true;
- }
- /////////////////////////////////////////////////////////////////////////////////////////////////////////////////
- function isDate(f) {
- var t = Date.parse(f.value);
- if (isNaN(t)) {
- return false;
- }
- }
- /////////////////////////////////////////////////////////////////////////////////////////////////////////////////
- function Check(f) {
- var ok=1;
- var _alertString="";
- var alertString2;
- if (f.searchfield.value.length==0) {
- _alertString += "- branch code missing\\n";
- }
- if (f.branchname.value.length==0) {
- _alertString += "- branch name missing\\n";
- }
- if (_alertString.length==0) {
- document.Aform.submit();
- } else {
- alertString2 = "Form not submitted because of the following problem(s)\\n";
- alertString2 += "------------------------------------------------------------------------------------\\n\\n";
- alertString2 += _alertString;
- alert(alertString2);
- }
- }
- </SCRIPT>
-printend
-;#/
- if ($searchfield) {
- print "<h1>Modify branch</h1>";
- } else {
- print "<h1>Add branch</h1>";
- }
- print "<form action='$script_name' name=Aform method=post>";
- print "<input type=hidden name=op value='add_validate'>";
- print "<table>";
- if ($searchfield) {
- print "<tr><td>Branch code</td><td><input type=hidden name=searchfield value=$searchfield>$searchfield</td></tr>";
- } else {
- print "<tr><td>Branch code</td><td><input type=text name=searchfield size=5 maxlength=5 onBlur=toUC(this)></td></tr>";
- }
- print "<tr><td>Name</td><td><input type=text name=branchname size=40 maxlength=80 value='$data->{'branchname'}'> </td></tr>";
- print "<tr><td>Adress</td><td><input type=text name=branchaddress1 value='$data->{'branchaddress1'}'></td></tr>";
- print "<tr><td> </td><td><input type=text name=branchaddress2 value='$data->{'branchaddress2'}'></td></tr>";
- print "<tr><td> </td><td><input type=text name=branchaddress3 value='$data->{'branchaddress3'}'></td></tr>";
- print "<tr><td>Phone</td><td><input type=text name=branchphone value='$data->{'branchphone'}'></td></tr>";
- print "<tr><td>Fax</td><td><input type=text name=branchfax value='$data->{'branchfax'}'></td></tr>";
- print "<tr><td>E-mail</td><td><input type=text name=branchemail value='$data->{'branchemail'}'></td></tr>";
- print "<tr><td>Issuing</td><td><input type=text name=issuing value='$data->{'issuing'}'></td></tr>";
- print "<tr><td> </td><td><INPUT type=button value='OK' onClick='Check(this.form)'></td></tr>";
- print "</table>";
- print "</form>";
-;
- # END $OP eq ADD_FORM
-################## ADD_VALIDATE ##################################
-# called by add_form, used to insert/modify data in DB
-} elsif ($op eq 'add_validate') {
- my $dbh=C4Connect;
- my $query = "replace branches (branchcode,branchname,branchaddress1,branchaddress2,branchaddress3,branchphone,branchfax,branchemail,issuing) values (";
- $query.= $dbh->quote($input->param('branchcode')).",";
- $query.= $dbh->quote($input->param('branchname')).",";
- $query.= $dbh->quote($input->param('branchaddress1')).",";
- $query.= $dbh->quote($input->param('branchaddress2')).",";
- $query.= $dbh->quote($input->param('branchaddress3')).",";
- $query.= $dbh->quote($input->param('branchphone')).",";
- $query.= $dbh->quote($input->param('branchfax')).",";
- $query.= $dbh->quote($input->param('branchemail')).",";
- $query.= $dbh->quote($input->param('issuing')).")";
- my $sth=$dbh->prepare($query);
- $sth->execute;
- $sth->finish;
- print "data recorded";
- print "<form action='$script_name' method=post>";
- print "<input type=submit value=OK>";
- print "</form>";
- # END $OP eq ADD_VALIDATE
-################## DELETE_CONFIRM ##################################
-# called by default form, used to confirm deletion of data in DB
-} elsif ($op eq 'delete_confirm') {
- my $dbh = &C4Connect;
- my $sth=$dbh->prepare("select count(*) as total from borrowers where branchcode='$searchfield'");
- $sth->execute;
- my $total = $sth->fetchrow_hashref;
- $sth->finish;
- print "$reqsel";
- my $sth=$dbh->prepare($reqsel);
- $sth->execute;
- my $data=$sth->fetchrow_hashref;
- $sth->finish;
- print mktablehdr;
- print mktablerow(2,'#99cc33',bold('Branch code'),bold("$searchfield"),'/images/background-mem.gif');
- print "<form action='$script_name' method=post><input type=hidden name=op value=delete_confirmed><input type=hidden name=searchfield value='$searchfield'>";
- print "<tr><td>Branch code</td><td>$data->{'branchcode'}</td></tr>";
- print "<tr><td> name</td><td>$data->{'branchname'}</td></tr>";
- print "<tr><td> adress</td><td>$data->{'branchaddress1'}</td></tr>";
- print "<tr><td> </td><td>$data->{'branchaddress2'}</td></tr>";
- print "<tr><td> </td><td>$data->{'branchaddress3'}</td></tr>";
- print "<tr><td> phone</td><td>$data->{'branchphone'}</td></tr>";
- print "<tr><td> fax</td><td>$data->{'branchfax'}</td></tr>";
- print "<tr><td> e-mail</td><td>$data->{'branchemail'}</td></tr>";
- print "<tr><td> issuing</td><td>$data->{'issuing'}</td></tr>";
- if ($total->{'total'} >0) {
- print "<tr><td colspan=2 align=center><b>This record is used $total->{'total'} times. Deletion not possible</b></td></tr>";
- print "<tr><td colspan=2></form><form action='$script_name' method=post><input type=submit value=OK></form></td></tr>";
- } else {
- print "<tr><td colspan=2 align=center>CONFIRM DELETION</td></tr>";
- print "<tr><td><INPUT type=submit value='YES'></form></td><td><form action='$script_name' method=post><input type=submit value=NO></form></td></tr>";
- }
- # END $OP eq DELETE_CONFIRM
-################## DELETE_CONFIRMED ##################################
-# called by delete_confirm, used to effectively confirm deletion of data in DB
-} elsif ($op eq 'delete_confirmed') {
- my $dbh=C4Connect;
-# my $searchfield=$input->param('branchcode');
- my $sth=$dbh->prepare($reqdel);
- $sth->execute;
- $sth->finish;
- print "data deleted";
- print "<form action='$script_name' method=post>";
- print "<input type=submit value=OK>";
- print "</form>";
- # END $OP eq DELETE_CONFIRMED
-################## DEFAULT ##################################
-} else { # DEFAULT
- my @inputs=(["text","searchfield",$searchfield],
- ["reset","reset","clr"]);
- print mkheadr(2,'branches admin');
- print mkformnotable("$script_name",@inputs);
- print <<printend
-
-printend
- ;
- if ($searchfield ne '') {
- print "You Searched for <b>$searchfield<b><p>";
- }
- print mktablehdr;
- print mktablerow(9,'#99cc33',bold('Branch code'),bold('name'),bold('adress'),
- bold('phone'),bold('fax'),bold('mail'),bold('issuing'),
- ' ',' ','/images/background-mem.gif');
- my $env;
- my ($count,$results)=StringSearch($env,$searchfield,'web');
- my $toggle="white";
- for (my $i=$offset; $i < ($offset+$pagesize<$count?$offset+$pagesize:$count); $i++){
- #find out stats
- # my ($od,$issue,$fines)=categdata2($env,$results->[$i]{'borrowernumber'});
- # $fines=$fines+0;
- if ($toggle eq 'white'){
- $toggle="#ffffcc";
- } else {
- $toggle="white";
- }
- print mktablerow(9,$toggle,$results->[$i]{'branchcode'},$results->[$i]{'branchname'},
- $results->[$i]{'branchaddress1'}.$results->[$i]{'branchaddress2'}.$results->[$i]{'branchaddress3'},
- $results->[$i]{'branchphone'},,$results->[$i]{'branchfax'},,$results->[$i]{'branchmail'},,$results->[$i]{'issuing'},
- mklink("$script_name?op=add_form&searchfield=".$results->[$i]{'branchcode'},'Edit'),
- mklink("$script_name?op=delete_confirm&searchfield=".$results->[$i]{'branchcode'},'Delete',''));
- }
- print mktableft;
- print "<form action='$script_name' method=post>";
- print "<input type=hidden name=op value=add_form>";
- if ($offset>0) {
- my $prevpage = $offset-$pagesize;
- print mklink("$script_name?offset=".$prevpage,'<< Prev');
- }
- print " ";
- if ($offset+$pagesize<$count) {
- my $nextpage =$offset+$pagesize;
- print mklink("$script_name?offset=".$nextpage,'Next >>');
- }
- print "<br><input type=image src=\"/images/button-add-member.gif\" WIDTH=188 HEIGHT=44 ALT=\"Add budget\" BORDER=0 ></a><br>";
- print "</form>";
-} #---- END $OP eq DEFAULT
-print endmenu('admin');
-print endpage();
+sub editbranchform {
+ my ($branchcode,$innertemplate) = @_;
+ # initiate the scrolling-list to select the printers
+ my $printers = GetPrinters();
+ my @printerloop;
+ my $printercount = 0;
+ my $oldprinter;
+ my $CGIprinter;
+
+ my $data;
+
+ if ($branchcode) {
+ $data = GetBranchInfo($branchcode);
+ $data = $data->[0];
+
+ # get the old printer of the branch
+ $oldprinter = $data->{'branchprinter'};
+
+ # printer loop
+ foreach my $thisprinter ( keys %$printers ) {
+ my $selected = 1
+ if $oldprinter eq $printers->{$thisprinter}->{'printqueue'};
+ my %row = (
+ value => $thisprinter,
+ selected => $selected,
+ branchprinter => $printers->{$thisprinter}->{'printqueue'},
+ );
+ push @printerloop, \%row;
+ }
+
+ $innertemplate->param(
+ printerloop => \@printerloop,
+ branchcode => $data->{'branchcode'},
+ branch_name => $data->{'branchname'},
+ branchaddress1 => $data->{'branchaddress1'},
+ branchaddress2 => $data->{'branchaddress2'},
+ branchaddress3 => $data->{'branchaddress3'},
+ branchphone => $data->{'branchphone'},
+ branchfax => $data->{'branchfax'},
+ branchemail => $data->{'branchemail'},
+ branchip => $data->{'branchip'}
+ );
+ }
+ else { #case of an add branch select printer
+ foreach my $thisprinter ( keys %$printers ) {
+ my %row = (
+ value => $thisprinter,
+ branchprinter => $printers->{$thisprinter}->{'printqueue'},
+ );
+ push @printerloop, \%row;
+ }
+ $innertemplate->param( printerloop => \@printerloop );
+ }
+
+ # make the checkboxs.....
+ #
+ # We export a "categoryloop" array to the template, each element of which
+ # contains separate 'categoryname', 'categorycode', 'codedescription', and
+ # 'checked' fields. The $checked field is either '' or 'checked'
+ # (see bug 130)
+ #
+ my $catinfo = GetBranchCategory();
+ my $catcheckbox;
+
+ # print DEBUG "catinfo=".cvs($catinfo)."\n";
+ my @categoryloop = ();
+ foreach my $cat (@$catinfo) {
+ my $checked = "";
+ my $tmp = quotemeta( $cat->{'categorycode'} );
+ if ( grep { /^$tmp$/ } @{ $data->{'categories'} } ) {
+ $checked = "checked=\"checked\"";
+ }
+ push @categoryloop,
+ {
+ categoryname => $cat->{'categoryname'},
+ categorycode => $cat->{'categorycode'},
+ codedescription => $cat->{'codedescription'},
+ checked => $checked,
+ };
+ }
+ $innertemplate->param( categoryloop => \@categoryloop );
+
+ # {{{ Leave this here until bug 130 is completely resolved in the templates
+ for my $obsolete ( 'categoryname', 'categorycode', 'codedescription' ) {
+ $innertemplate->param(
+ $obsolete => 'Your template is out of date (bug 130)' );
+ }
+
+ # }}}
+}
+
+sub editcatform {
+
+ # prepares the edit form...
+ my ($categorycode,$innertemplate) = @_;
+ warn "cat : $categorycode";
+ my $data;
+ if ($categorycode) {
+ $data = GetBranchCategory($categorycode);
+ $data = $data->[0];
+ $innertemplate->param( categorycode => $data->{'categorycode'} );
+ $innertemplate->param( categoryname => $data->{'categoryname'} );
+ $innertemplate->param( codedescription => $data->{'codedescription'} );
+ }
+}
+
+sub deleteconfirm {
+
+ # message to print if the
+ my ($branchcode) = @_;
+}
+
+sub branchinfotable {
+
+# makes the html for a table of branch info from reference to an array of hashs.
+
+ my ($branchcode,$innertemplate) = @_;
+ my $branchinfo;
+ if ($branchcode) {
+ $branchinfo = GetBranchInfo($branchcode);
+ }
+ else {
+ $branchinfo = GetBranchInfo();
+ }
+ my $toggle;
+ my $i;
+ my @loop_data = ();
+ foreach my $branch (@$branchinfo) {
+ ( $i % 2 ) ? ( $toggle = 1 ) : ( $toggle = 0 );
+
+ #
+ # We export the following fields to the template. These are not
+ # pre-composed as a single "address" field because the template
+ # might (and should) escape what is exported here. (See bug 180)
+ #
+ # - color
+ # - branch_name (Note: not "branchname")
+ # - branch_code (Note: not "branchcode")
+ # - address (containing a static error message)
+ # - branchaddress1 \
+ # - branchaddress2 |
+ # - branchaddress3 | comprising the old "address" field
+ # - branchphone |
+ # - branchfax |
+ # - branchemail /
+ # - address-empty-p (1 if no address information, 0 otherwise)
+ # - categories (containing a static error message)
+ # - category_list (loop containing "categoryname")
+ # - no-categories-p (1 if no categories set, 0 otherwise)
+ # - value
+ # - action
+ #
+ my %row = ();
+
+ # Handle address fields separately
+ my $address_empty_p = 1;
+ for my $field (
+ 'branchaddress1', 'branchaddress2',
+ 'branchaddress3', 'branchphone',
+ 'branchfax', 'branchemail',
+ 'branchip', 'branchprinter'
+ )
+ {
+ $row{$field} = $branch->{$field};
+ if ( $branch->{$field} ) {
+ $address_empty_p = 0;
+ }
+ }
+ $row{'address-empty-p'} = $address_empty_p;
+
+ # {{{ Leave this here until bug 180 is completely resolved in templates
+ $row{'address'} = 'Your template is out of date (see bug 180)';
+
+ # }}}
+
+ # Handle categories
+ my $no_categories_p = 1;
+ my @categories;
+ foreach my $cat ( @{ $branch->{'categories'} } ) {
+ my ($catinfo) = @{ GetBranchCategory($cat) };
+ push @categories, { 'categoryname' => $catinfo->{'categoryname'} };
+ $no_categories_p = 0;
+ }
+
+ # {{{ Leave this here until bug 180 is completely resolved in templates
+ $row{'categories'} = 'Your template is out of date (see bug 180)';
+
+ # }}}
+ $row{'category_list'} = \@categories;
+ $row{'no-categories-p'} = $no_categories_p;
+
+ # Handle all other fields
+ $row{'branch_name'} = $branch->{'branchname'};
+ $row{'branch_code'} = $branch->{'branchcode'};
+ $row{'toggle'} = $toggle;
+ $row{'value'} = $branch->{'branchcode'};
+ $row{'action'} = '/cgi-bin/koha/admin/branches.pl';
+
+ push @loop_data, {%row};
+ $i++;
+ }
+ my @branchcategories = ();
+ my $catinfo = GetBranchCategory();
+ $i = 0;
+ foreach my $cat (@$catinfo) {
+ ( $i % 2 ) ? ( $toggle = 1 ) : ( $toggle = 0 );
+ push @branchcategories,
+ {
+ toggle => $toggle,
+ categoryname => $cat->{'categoryname'},
+ categorycode => $cat->{'categorycode'},
+ codedescription => $cat->{'codedescription'},
+ };
+ $i++;
+ }
+
+ $innertemplate->param(
+ branches => \@loop_data,
+ branchcategories => \@branchcategories
+ );
+
+}
+
+# FIXME logic seems wrong
+sub branchcategoriestable {
+ my $innertemplate = shift;
+ #Needs to be implemented...
+
+ my $categoryinfo = GetBranchCategory();
+ my $color;
+ foreach my $cat (@$categoryinfo) {
+ $innertemplate->param( categoryname => $cat->{'categoryname'} );
+ $innertemplate->param( categorycode => $cat->{'categorycode'} );
+ $innertemplate->param( codedescription => $cat->{'codedescription'} );
+ }
+}
+
+$template->param(
+ intranetcolorstylesheet =>
+ C4::Context->preference("intranetcolorstylesheet"),
+ intranetstylesheet => C4::Context->preference("intranetstylesheet"),
+ IntranetNav => C4::Context->preference("IntranetNav"),
+);
+output_html_with_http_headers $input, $cookie, $template->output;
+
+# Local Variables:
+# tab-width: 8
+# End: