7 my $query = "Select * from categories where (categorycode like 'L%' or categorycode like 'F%'
8 or categorycode like 'S%' or categorycode like 'O%' or categorycode like 'H%') and (categorycode <>'HR'
9 and categorycode <> 'ST')";
10 my $sth=$dbh->prepare($query);
12 while (my $data=$sth->fetchrow_hashref){
13 #update borrowers corresponding
15 my $temp=substr($data->{'categorycode'},0,1);
16 $query="update borrowers set area='$temp' where categorycode='$data->{'categorycode'}'";
17 my $sth2=$dbh->prepare($query);
20 $temp=substr($data->{'categorycode'},1,1);
21 $query="update borrowers set categorycode='$temp' where categorycode='$data->{'categorycode'}'";
22 $sth2=$dbh->prepare($query);
25 $query="delete from categories where categorycode='$data->{'categorycode'}'";
26 $sth2=$dbh->prepare($query);
32 $query = "Select * from categories where (categorycode like 'V%') and (categorycode <>'HR'
33 and categorycode <> 'ST')";
34 my $sth=$dbh->prepare($query);
36 while (my $data=$sth->fetchrow_hashref){
37 #update borrowers corresponding
39 # my $temp=substr($data->{'categorycode'},0,1);
40 $query="update borrowers set area='V' where categorycode='$data->{'categorycode'}'";
41 my $sth2=$dbh->prepare($query);
44 my $temp=substr($data->{'categorycode'},1,1);
45 $query="update borrowers set categorycode='$temp' where categorycode='$data->{'categorycode'}'";
46 $sth2=$dbh->prepare($query);
49 $query="delete from categories where categorycode='$data->{'categorycode'}'";
50 $sth2=$dbh->prepare($query);
56 my $query = "Select * from categories where categorycode = 'ST'";
57 my $sth=$dbh->prepare($query);
59 while (my $data=$sth->fetchrow_hashref){
60 #update borrowers corresponding
62 $query="update borrowers set area='' where categorycode='$data->{'categorycode'}'";
63 my $sth2=$dbh->prepare($query);
66 $query="update borrowers set categorycode='W' where categorycode='$data->{'categorycode'}'";
67 $sth2=$dbh->prepare($query);
70 $query="delete from categories where categorycode='$data->{'categorycode'}'";
71 $sth2=$dbh->prepare($query);
77 my $query = "Select * from categories where categorycode = 'BR' or categorycode='CO' or categorycode='IS'";
78 my $sth=$dbh->prepare($query);
80 while (my $data=$sth->fetchrow_hashref){
81 #update borrowers corresponding
83 $query="update borrowers set area='' where categorycode='$data->{'categorycode'}'";
84 my $sth2=$dbh->prepare($query);
87 $query="update borrowers set categorycode='I' where categorycode='$data->{'categorycode'}'";
88 $sth2=$dbh->prepare($query);
91 $query="delete from categories where categorycode='$data->{'categorycode'}'";
92 $sth2=$dbh->prepare($query);
97 my $query = "Select * from categories where categorycode = 'TD' or categorycode='TR'";
98 my $sth=$dbh->prepare($query);
100 while (my $data=$sth->fetchrow_hashref){
101 #update borrowers corresponding
103 $query="update borrowers set area='X' where categorycode='$data->{'categorycode'}'";
104 my $sth2=$dbh->prepare($query);
107 $query="update borrowers set categorycode='A' where categorycode='$data->{'categorycode'}'";
108 $sth2=$dbh->prepare($query);
111 $query="delete from categories where categorycode='$data->{'categorycode'}'";
112 $sth2=$dbh->prepare($query);
118 my $query = "Select * from categories where categorycode = 'HR'";
119 my $sth=$dbh->prepare($query);
121 while (my $data=$sth->fetchrow_hashref){
122 #update borrowers corresponding
124 $query="update borrowers set area='K' where categorycode='$data->{'categorycode'}'";
125 my $sth2=$dbh->prepare($query);
128 $query="update borrowers set categorycode='A' where categorycode='$data->{'categorycode'}'";
129 $sth2=$dbh->prepare($query);
132 $query="delete from categories where categorycode='$data->{'categorycode'}'";
133 $sth2=$dbh->prepare($query);
139 my $query = "Select * from categories where categorycode = 'IL'";
140 my $sth=$dbh->prepare($query);
142 while (my $data=$sth->fetchrow_hashref){
143 #update borrowers corresponding
145 $query="update borrowers set area='Z' where categorycode='$data->{'categorycode'}'";
146 my $sth2=$dbh->prepare($query);
149 $query="update borrowers set categorycode='L' where categorycode='$data->{'categorycode'}'";
150 $sth2=$dbh->prepare($query);
153 $query="delete from categories where categorycode='$data->{'categorycode'}'";
154 $sth2=$dbh->prepare($query);
159 my $query = "Select * from categories where categorycode = 'TB'";
160 my $sth=$dbh->prepare($query);
162 while (my $data=$sth->fetchrow_hashref){
163 #update borrowers corresponding
165 $query="update borrowers set area='' where categorycode='$data->{'categorycode'}'";
166 my $sth2=$dbh->prepare($query);
169 $query="update borrowers set categorycode='P' where categorycode='$data->{'categorycode'}'";
170 $sth2=$dbh->prepare($query);
173 $query="delete from categories where categorycode='$data->{'categorycode'}'";
174 $sth2=$dbh->prepare($query);
181 $query="insert into categories values ('A','Adult',5,99,0,'A',0,0,0,99,1)";
182 $sth=$dbh->prepare($query);
185 $query="insert into categories values ('E','Senior Citizen',5,99,0,'A',0,0,0,99,1)";
186 $sth=$dbh->prepare($query);
189 $query="insert into categories values ('C','Child',5,16,0,'A',0,0,0,99,0)";
190 $sth=$dbh->prepare($query);
193 $query="insert into categories values ('B','Housebound',5,99,0,'E',0,0,0,99,0)";
194 $sth=$dbh->prepare($query);
197 $query="insert into categories values ('F','Family',5,99,0,'A',0,0,0,99,1)";
198 $sth=$dbh->prepare($query);
201 $query="insert into categories values ('W','Workers',5,99,0,'A',0,0,0,99,0)";
202 $sth=$dbh->prepare($query);
205 $query="insert into categories values ('I','Institution',5,99,0,'A',0,0,0,99,0)";
206 $sth=$dbh->prepare($query);
209 $query="insert into categories values ('P','Privileged',5,99,0,'A',0,0,0,99,0)";
210 $sth=$dbh->prepare($query);
213 $query="insert into categories values ('L','Library',5,99,0,'A',0,0,0,99,0)";
214 $sth=$dbh->prepare($query);