[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-cvs] CVS: koha/admin categorie.pl,1.3,1.4
From: |
Andrew Arensburger |
Subject: |
[Koha-cvs] CVS: koha/admin categorie.pl,1.3,1.4 |
Date: |
Sat, 05 Oct 2002 03:02:21 -0700 |
Update of /cvsroot/koha/koha/admin
In directory usw-pr-cvs1:/tmp/cvs-serv26591/admin
Modified Files:
categorie.pl
Log Message:
Merged with arensb-context branch: use C4::Context->dbh instead of
&C4Connect, and generally prefer C4::Context over C4::Database.
Index: categorie.pl
===================================================================
RCS file: /cvsroot/koha/koha/admin/categorie.pl,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** categorie.pl 14 Aug 2002 18:12:53 -0000 1.3
--- categorie.pl 5 Oct 2002 10:02:19 -0000 1.4
***************
*** 38,49 ****
use strict;
- use C4::Output;
use CGI;
use C4::Search;
- use C4::Database;
sub StringSearch {
my ($env,$searchstring,$type)address@hidden;
! my $dbh = &C4Connect;
$searchstring=~ s/\'/\\\'/g;
my @data=split(' ',$searchstring);
--- 38,49 ----
use strict;
use CGI;
+ use C4::Context;
+ use C4::Output;
use C4::Search;
sub StringSearch {
my ($env,$searchstring,$type)address@hidden;
! my $dbh = C4::Context->dbh;
$searchstring=~ s/\'/\\\'/g;
my @data=split(' ',$searchstring);
***************
*** 60,64 ****
# $sth->execute;
$sth->finish;
- $dbh->disconnect;
return ($cnt,address@hidden);
}
--- 60,63 ----
***************
*** 81,85 ****
my $data;
if ($categorycode) {
! my $dbh = &C4Connect;
my $sth=$dbh->prepare("select
categorycode,description,enrolmentperiod,upperagelimit,dateofbirthrequired,finetype,bulk,enrolmentfee,issuelimit,reservefee,overduenoticerequired
from categories where categorycode='$categorycode'");
$sth->execute;
--- 80,84 ----
my $data;
if ($categorycode) {
! my $dbh = C4::Context->dbh;
my $sth=$dbh->prepare("select
categorycode,description,enrolmentperiod,upperagelimit,dateofbirthrequired,finetype,bulk,enrolmentfee,issuelimit,reservefee,overduenoticerequired
from categories where categorycode='$categorycode'");
$sth->execute;
***************
*** 179,183 ****
# called by add_form, used to insert/modify data in DB
} elsif ($op eq 'add_validate') {
! my $dbh=C4Connect;
my $query = "replace categories
(categorycode,description,enrolmentperiod,upperagelimit,dateofbirthrequired,finetype,bulk,enrolmentfee,issuelimit,reservefee,overduenoticerequired)
values (";
$query.= $dbh->quote($input->param('categorycode')).",";
--- 178,182 ----
# called by add_form, used to insert/modify data in DB
} elsif ($op eq 'add_validate') {
! my $dbh = C4::Context->dbh;
my $query = "replace categories
(categorycode,description,enrolmentperiod,upperagelimit,dateofbirthrequired,finetype,bulk,enrolmentfee,issuelimit,reservefee,overduenoticerequired)
values (";
$query.= $dbh->quote($input->param('categorycode')).",";
***************
*** 203,207 ****
# 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 categoryitem where
categorycode='$categorycode'");
$sth->execute;
--- 202,206 ----
# called by default form, used to confirm deletion of data in DB
} elsif ($op eq 'delete_confirm') {
! my $dbh = C4::Context->dbh;
my $sth=$dbh->prepare("select count(*) as total from categoryitem where
categorycode='$categorycode'");
$sth->execute;
***************
*** 209,212 ****
--- 208,212 ----
print "TOTAL : $categorycode : $total->{'total'}<br>";
$sth->finish;
+ # FIXME - there's already a $sth in this scope.
my $sth=$dbh->prepare("select
categorycode,description,enrolmentperiod,upperagelimit,dateofbirthrequired,finetype,bulk,enrolmentfee,issuelimit,reservefee,overduenoticerequired
from categories where categorycode='$categorycode'");
$sth->execute;
***************
*** 237,241 ****
# called by delete_confirm, used to effectively confirm deletion of data in DB
} elsif ($op eq 'delete_confirmed') {
! my $dbh=C4Connect;
my $categorycode=uc($input->param('categorycode'));
my $query = "delete from categories where categorycode='$categorycode'";
--- 237,241 ----
# called by delete_confirm, used to effectively confirm deletion of data in DB
} elsif ($op eq 'delete_confirmed') {
! my $dbh = C4::Context->dbh;
my $categorycode=uc($input->param('categorycode'));
my $query = "delete from categories where categorycode='$categorycode'";
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Koha-cvs] CVS: koha/admin categorie.pl,1.3,1.4,
Andrew Arensburger <=