9 HOME MYSQL_HOST MYSQL_TCP_PORT MYSQL_USER MYSQL_DATABASE MYSQL_PW
10 MIGSCHEMA MIGBASEWORKDIR MIGBASEGITDIR MIGGITDIR MIGWORKDIR
12 use open ':encoding(utf8)';
16 my $mig_bin = "$FindBin::Bin/";
17 use lib "$FindBin::Bin/";
19 use open ':std', ':encoding(UTF-8)';
20 use Encode qw( decode_utf8 );
23 my $dbh = KMig::db_connect();
24 $dbh->{mysql_enable_utf8mb4} = 1;
26 #to do check for array passed and if not present then use tags
29 my $arg_list_length = scalar @taglist;
30 if($arg_list_length < 1) { @taglist = ("authorisedvalues","booksellers","budgets","borrowerattributes","calendar","circrules","itemtypes","letters","libraries","messages","patrontypes","preferences","reports","smsproviders"); }
31 $MIGGITDIR =~ s/\/\//\//;
33 my $timestamp = create_timestamp();
35 foreach my $backup (@taglist) {
37 if ($backup eq 'authorisedvalues') {
38 $backupfile = $MIGGITDIR . 'authorisedvalues' . '.' . $timestamp . '.xml';
39 print "Backing up $backupfile ... \n";
40 backup_authorisedvalues($dbh,$backupfile);
42 if ($backup eq 'booksellers') {
43 $backupfile = $MIGGITDIR . 'booksellers' . '.' . $timestamp . '.xml';
44 print "Backing up $backupfile ... \n";
45 backup_booksellers($dbh,$backupfile);
47 if ($backup eq 'borrowerattributes') {
48 $backupfile = $MIGGITDIR . 'borrowerattributes' . '.' . $timestamp . '.xml';
49 print "Backing up $backupfile ... \n";
50 backup_borrower_attributes($dbh,$backupfile);
52 if ($backup eq 'budgets') {
53 $backupfile = $MIGGITDIR . 'budgets' . '.' . $timestamp . '.xml';
54 print "Backing up $backupfile ... \n";
55 backup_budgets($dbh,$backupfile);
57 if ($backup eq 'calendar') {
58 $backupfile = $MIGGITDIR . 'calendar' . '.' . $timestamp . '.xml';
59 print "Backing up $backupfile ... \n";
60 backup_calendar($dbh,$backupfile);
62 if ($backup eq 'circrules') {
63 $backupfile = $MIGGITDIR . 'circrules' . '.' . $timestamp . '.xml';
64 print "Backing up $backupfile ... \n";
65 backup_circrules($dbh,$backupfile);
67 if ($backup eq 'itemtypes') {
68 $backupfile = $MIGGITDIR . 'itemtypes' . '.' . $timestamp . '.xml';
69 print "Backing up $backupfile ... \n";
70 backup_itemtypes($dbh,$backupfile);
72 if ($backup eq 'letters') {
73 $backupfile = $MIGGITDIR . 'letters' . '.' . $timestamp . '.xml';
74 print "Backing up $backupfile ... \n";
75 backup_letters($dbh,$backupfile);
77 if ($backup eq 'libraries') {
78 $backupfile = $MIGGITDIR . 'libraries' . '.' . $timestamp . '.xml';
79 print "Backing up $backupfile ... \n";
80 backup_libraries($dbh,$backupfile);
82 if ($backup eq 'messages') {
83 $backupfile = $MIGGITDIR . 'messages' . '.' . $timestamp . '.xml';
84 print "Backing up $backupfile ... \n";
85 backup_messages($dbh,$backupfile);
87 if ($backup eq 'patrontypes') {
88 $backupfile = $MIGGITDIR . 'patrontypes' . '.' . $timestamp . '.xml';
89 print "Backing up $backupfile ... \n";
90 backup_patrontypes($dbh,$backupfile);
92 if ($backup eq 'preferences') {
93 $backupfile = $MIGGITDIR . 'systempreferences' . '.' . $timestamp . '.xml';
94 print "Backing up $backupfile ... \n";
95 backup_preferences($dbh,$backupfile);
97 if ($backup eq 'reports') {
98 $backupfile = $MIGGITDIR . 'reports' . '.' . $timestamp . '.xml';
99 print "Backing up $backupfile ... \n";
100 backup_reports($dbh,$backupfile);
102 if ($backup eq 'smsproviders') {
103 $backupfile = $MIGGITDIR . 'smsproviders' . '.' . $timestamp . '.xml';
104 print "Backing up $backupfile ... \n";
105 backup_smsproviders($dbh,$backupfile);
109 sub backup_authorisedvalues {
111 my $backupfile = shift;
113 open(my $fh, '>', $backupfile) or die "Could not open $backupfile!";
114 my $xml = XML::Writer->new(OUTPUT => $fh, DATA_MODE => 1, DATA_INDENT => 2, );
115 $xml->xmlDecl('UTF-8');
116 $xml->startTag('document');
118 $xml->startTag('authorisedvalues');
119 my $sth = sql_giveback($dbh,"SELECT category,authorised_value,lib,lib_opac,imageurl FROM authorised_values WHERE category != 'ITEMTYPECAT'");
120 while (my @row = $sth->fetchrow_array) {
121 $xml->startTag('value');
122 $xml->dataElement('category', $row[0]);
123 $xml->dataElement('authorised_value', $row[1]);
124 $xml->dataElement('lib', $row[2]);
125 $xml->dataElement('lib_opac', $row[3]);
126 $xml->dataElement('imageurl', $row[4]);
127 $xml->endTag('value');
129 $xml->endTag('authorisedvalues');
131 $xml->startTag('categories');
132 $sth = sql_giveback($dbh,"SELECT category_name FROM authorised_value_categories WHERE category_name != 'ITEMTYPECAT'");
133 while (my @row = $sth->fetchrow_array) {
134 $xml->startTag('value');
135 $xml->dataElement('name', $row[0]);
136 $xml->endTag('value');
138 $xml->endTag('categories');
140 $xml->endTag('document');
146 sub backup_booksellers {
148 my $backupfile = shift;
150 open(my $fh, '>', $backupfile) or die "Could not open $backupfile!";
151 my $xml = XML::Writer->new(OUTPUT => $fh, DATA_MODE => 1, DATA_INDENT => 2, );
152 $xml->xmlDecl('UTF-8');
153 $xml->startTag('booksellers');
154 my $sth = sql_giveback($dbh,"SELECT name,address1,address2,address3,address4,phone,accountnumber,othersupplier,currency,booksellerfax,notes,bookselleremail,booksellerurl,postal,url,active,listprice,invoiceprice,gstreg,listincgst,invoiceincgst,tax_rate,discount,fax,deliverytime FROM aqbooksellers");
155 while (my @row = $sth->fetchrow_array) {
156 $xml->startTag('value');
157 $xml->dataElement('name', $row[1]);
158 $xml->dataElement('address1', $row[2]);
159 $xml->dataElement('address2', $row[3]);
160 $xml->dataElement('address3', $row[4]);
161 $xml->dataElement('address4', $row[5]);
162 $xml->dataElement('phone', $row[6]);
163 $xml->dataElement('accountnumber', $row[7]);
164 $xml->dataElement('othersupplier', $row[8]);
165 $xml->dataElement('currency', $row[9]);
166 $xml->dataElement('booksellerfax', $row[10]);
167 $xml->dataElement('notes', $row[11]);
168 $xml->dataElement('bookselleremail', $row[12]);
169 $xml->dataElement('booksellerurl', $row[13]);
170 $xml->dataElement('postal', $row[14]);
171 $xml->dataElement('url', $row[15]);
172 $xml->dataElement('active', $row[16]);
173 $xml->dataElement('listprice', $row[17]);
174 $xml->dataElement('invoiceprice ', $row[18]);
175 $xml->dataElement('gstreg', $row[19]);
176 $xml->dataElement('listincgst', $row[20]);
177 $xml->dataElement('invoiceincgst', $row[21]);
178 $xml->dataElement('tax_rate', $row[22]);
179 $xml->dataElement('discount', $row[23]);
180 $xml->dataElement('fax ', $row[24]);
181 $xml->dataElement('deliverytime', $row[25]);
182 $xml->endTag('value');
184 $xml->endTag('booksellers');
190 sub backup_borrower_attributes {
192 my $backupfile = shift;
194 open(my $fh, '>', $backupfile) or die "Could not open $backupfile!";
195 my $xml = XML::Writer->new(OUTPUT => $fh, DATA_MODE => 1, DATA_INDENT => 2, );
196 $xml->xmlDecl('UTF-8');
197 $xml->startTag('document');
199 $xml->startTag('borrower_attribute_types');
200 my $sth = sql_giveback($dbh,"SELECT code,description,repeatable,opac_display,opac_editable,staff_searchable,authorised_value_category,display_checkout,category_code,class FROM borrower_attribute_types");
201 while (my @row = $sth->fetchrow_array) {
202 $xml->startTag('value');
203 $xml->dataElement('code', $row[0]);
204 $xml->dataElement('description', $row[1]);
205 $xml->dataElement('repeat', $row[2]);
206 $xml->dataElement('opac_display', $row[3]);
207 $xml->dataElement('staff_searchable', $row[4]);
208 $xml->dataElement('auth_value_cat', $row[5]);
209 $xml->dataElement('display_checkout', $row[6]);
210 $xml->dataElement('category_code', $row[7]);
211 $xml->dataElement('class', $row[8]);
212 $xml->endTag('value');
214 $xml->endTag('borrower_attribute_types');
216 $xml->startTag('authorised_value_categories');
217 $sth = sql_giveback($dbh,"SELECT category_name FROM authorised_value_categories WHERE category_name IN (select category_name from borrower_attribute_types)");
218 while (my @row = $sth->fetchrow_array) {
219 $xml->dataElement('value', $row[0]);
221 $xml->endTag('authorised_value_categories');
223 $xml->startTag('authorised_values');
224 $sth = sql_giveback($dbh,"SELECT category,authorised_value,lib,lib_opac,imageurl FROM authorised_values where category in (select category_code from borrower_attribute_types);");
225 while (my @row = $sth->fetchrow_array) {
226 $xml->startTag('value');
227 $xml->dataElement('category', $row[0]);
228 $xml->dataElement('authvalue', $row[1]);
229 $xml->dataElement('lib', $row[2]);
230 $xml->dataElement('lib_opac', $row[3]);
231 $xml->dataElement('image_url', $row[4]);
232 $xml->endTag('value');
234 $xml->endTag('authorised_values');
236 $xml->endTag('document');
244 my $backupfile = shift;
246 open(my $fh, '>', $backupfile) or die "Could not open $backupfile!";
247 my $xml = XML::Writer->new(OUTPUT => $fh, DATA_MODE => 1, DATA_INDENT => 2, );
248 $xml->xmlDecl('UTF-8');
249 $xml->startTag('document');
251 $xml->startTag('budgets');
252 my $sth = sql_giveback($dbh,'SELECT AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_NAME = "aqbudgets"');
253 my @ai = $sth->fetchrow_array;
254 $xml->dataElement('autoincrement', $ai[0]);
255 $sth = sql_giveback($dbh,"SELECT budget_id,budget_parent_id,budget_code,budget_name,budget_branchcode,budget_amount,budget_encumb,budget_expend,budget_notes,timestamp,budget_period_id,sort1_authcat,sort2_authcat,budget_owner_id,budget_permission FROM aqbudgets");
256 while (my @row = $sth->fetchrow_array) {
257 $xml->startTag('value');
258 $xml->dataElement('budget_id', $row[0]);
259 $xml->dataElement('budget_parent_id', $row[1]);
260 $xml->dataElement('budget_code', $row[2]);
261 $xml->dataElement('budget_name', $row[3]);
262 $xml->dataElement('budget_branchcode', $row[4]);
263 $xml->dataElement('budget_amount', $row[5]);
264 $xml->dataElement('budget_encumb', $row[6]);
265 $xml->dataElement('budget_expend', $row[7]);
266 $xml->dataElement('budget_notes', $row[8]);
267 $xml->dataElement('timestamp', $row[9]);
268 $xml->dataElement('budget_period_id', $row[10]);
269 $xml->dataElement('sort1_authcat', $row[11]);
270 $xml->dataElement('sort2_authcat', $row[12]);
271 $xml->dataElement('budget_owner_id', $row[13]);
272 $xml->dataElement('budget_permission', $row[14]);
273 $xml->endTag('value');
275 $xml->endTag('budgets');
277 $xml->startTag('budgetperiods');
278 $sth = sql_giveback($dbh,'SELECT AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_NAME = "aqbudgetperiods"');
279 @ai = $sth->fetchrow_array;
280 $xml->dataElement('autoincrement', $ai[0]);
281 $sth = sql_giveback($dbh,"SELECT budget_period_id,budget_period_startdate,budget_period_enddate,budget_period_active,budget_period_description,budget_period_total,budget_period_locked,sort1_authcat,sort2_authcat FROM aqbudgetperiods");
282 while (my @row = $sth->fetchrow_array) {
283 $xml->startTag('value');
284 $xml->dataElement('budget_period_id', $row[0]);
285 $xml->dataElement('budget_period_startdate', $row[1]);
286 $xml->dataElement('budget_period_enddate', $row[2]);
287 $xml->dataElement('budget_period_active', $row[3]);
288 $xml->dataElement('budget_period_description', $row[4]);
289 $xml->dataElement('budget_period_total', $row[5]);
290 $xml->dataElement('budget_period_locked', $row[6]);
291 $xml->dataElement('sort1_authcat', $row[7]);
292 $xml->dataElement('sort2_authcat', $row[8]);
293 $xml->endTag('value');
295 $xml->endTag('budgetperiods');
297 $xml->endTag('document');
303 sub backup_calendar {
305 my $backupfile = shift;
307 open(my $fh, '>', $backupfile) or die "Could not open $backupfile!";
308 my $xml = XML::Writer->new(OUTPUT => $fh, DATA_MODE => 1, DATA_INDENT => 2, );
309 $xml->xmlDecl('UTF-8');
310 $xml->startTag('holidays');
312 my $sth = sql_giveback($dbh,"SELECT branchcode,weekday,day,month,title,description FROM repeatable_holidays");
313 while (my @row = $sth->fetchrow_array) {
314 $xml->startTag('repeatable');
315 $xml->dataElement('branchcode',$row[0]);
316 $xml->dataElement('weekday',$row[1]);
317 $xml->dataElement('day',$row[2]);
318 $xml->dataElement('month',$row[3]);
319 $xml->dataElement('title',$row[4]);
320 $xml->dataElement('description',$row[5]);
321 $xml->endTag('repeatable');
324 $sth = sql_giveback($dbh,"SELECT branchcode,day,month,year,isexception,title,description FROM special_holidays");
325 while (my @row = $sth->fetchrow_array) {
326 $xml->startTag('special');
327 $xml->dataElement('branchcode',$row[0]);
328 $xml->dataElement('day',$row[1]);
329 $xml->dataElement('month',$row[2]);
330 $xml->dataElement('year',$row[3]);
331 $xml->dataElement('isexception',$row[4]);
332 $xml->dataElement('title',$row[5]);
333 $xml->dataElement('description',$row[6]);
334 $xml->endTag('special');
337 $xml->endTag('holidays');
343 sub backup_circrules {
345 my $backupfile = shift;
347 open(my $fh, '>', $backupfile) or die "Could not open $backupfile!";
348 my $xml = XML::Writer->new(OUTPUT => $fh, DATA_MODE => 1, DATA_INDENT => 2, );
349 $xml->xmlDecl('UTF-8');
350 $xml->startTag('document');
352 $xml->startTag('circ');
353 my $sth = sql_giveback($dbh,"SELECT branchcode, categorycode, itemtype, rule_name, rule_value FROM circulation_rules");
354 while (my @row = $sth->fetchrow_array) {
355 $xml->startTag('rule');
356 $xml->dataElement('branchcode', $row[0]);
357 $xml->dataElement('categorycode', $row[1]);
358 $xml->dataElement('itemtype', $row[2]);
359 $xml->dataElement('rule_name', $row[3]);
360 $xml->dataElement('rule_value', $row[4]);
361 $xml->endTag('rule');
363 $xml->endTag('circ');
365 $xml->startTag('issuing');
366 $sth = sql_giveback($dbh,"SELECT categorycode,itemtype,restrictedtype,rentaldiscount,reservecharge,fine,finedays,maxsuspensiondays,suspension_chargeperiod,firstremind,chargeperiod,chargeperiod_charge_at,accountsent,issuelength,lengthunit,hardduedate,hardduedatecompare,renewalsallowed,renewalperiod,norenewalbefore,auto_renew,no_auto_renewal_after,no_auto_renewal_after_hard_limit,reservesallowed,holds_per_record,holds_per_day,branchcode,overduefinescap,cap_fine_to_replacement_price,onshelfholds,opacitemholds,article_requests,note FROM issuingrules");
367 while (my @row = $sth->fetchrow_array) {
368 $xml->startTag('rule');
369 $xml->dataElement('categorycode', $row[0]);
370 $xml->dataElement('itemtype', $row[1]);
371 $xml->dataElement('restrictedtype', $row[2]);
372 $xml->dataElement('rentaldiscount', $row[3]);
373 $xml->dataElement('reservecharge', $row[4]);
374 $xml->dataElement('fine', $row[5]);
375 $xml->dataElement('finedays', $row[6]);
376 $xml->dataElement('maxsuspensiondays', $row[7]);
377 $xml->dataElement('suspension_chargeperiod', $row[8]);
378 $xml->dataElement('firstremind', $row[9]);
379 $xml->dataElement('chargeperiod', $row[10]);
380 $xml->dataElement('chargeperiod_charge_at', $row[11]);
381 $xml->dataElement('accountsent', $row[12]);
382 $xml->dataElement('issuelength', $row[13]);
383 $xml->dataElement('lengthunit', $row[14]);
384 $xml->dataElement('hardduedate', $row[15]);
385 $xml->dataElement('hardduedatecompare', $row[16]);
386 $xml->dataElement('renewalsallowed', $row[17]);
387 $xml->dataElement('renewalperiod', $row[18]);
388 $xml->dataElement('norenewalbefore', $row[19]);
389 $xml->dataElement('auto_renew', $row[20]);
390 $xml->dataElement('no_auto_renewal_after', $row[21]);
391 $xml->dataElement('no_auto_renewal_after_hard_limit', $row[22]);
392 $xml->dataElement('reservesallowed', $row[23]);
393 $xml->dataElement('holds_per_record', $row[24]);
394 $xml->dataElement('holds_per_day', $row[25]);
395 $xml->dataElement('branchcode', $row[26]);
396 $xml->dataElement('overduefinescap', $row[27]);
397 $xml->dataElement('cap_fine_to_replacement_price', $row[28]);
398 $xml->dataElement('onshelfholds', $row[29]);
399 $xml->dataElement('opacitemholds', $row[30]);
400 $xml->dataElement('article_requests', $row[31]);
401 $xml->dataElement('note', $row[32]);
402 $xml->endTag('rule');
404 $xml->endTag('issuing');
406 $xml->endTag('document');
413 sub backup_itemtypes {
415 my $backupfile = shift;
417 open(my $fh, '>', $backupfile) or die "Could not open $backupfile!";
418 my $xml = XML::Writer->new(OUTPUT => $fh, DATA_MODE => 1, DATA_INDENT => 2, );
419 $xml->xmlDecl('UTF-8');
420 $xml->startTag('document');
422 $xml->startTag('itemtypes');
423 my $sth = sql_giveback($dbh,"SELECT itemtype, description, rentalcharge, rentalcharge_daily, rentalcharge_hourly, defaultreplacecost, processfee, notforloan, imageurl, summary, checkinmsg, checkinmsgtype, sip_media_type, hideinopac, searchcategory FROM itemtypes");
424 while (my @row = $sth->fetchrow_array) {
425 $xml->startTag('value');
426 $xml->dataElement('itemtype', $row[0]);
427 $xml->dataElement('description', $row[1]);
428 $xml->dataElement('rentalcharge', $row[2]);
429 $xml->dataElement('rentalcharge_daily', $row[3]);
430 $xml->dataElement('rentalcharge_hourly', $row[4]);
431 $xml->dataElement('defaultreplacecost', $row[5]);
432 $xml->dataElement('processfee', $row[6]);
433 $xml->dataElement('notforloan', $row[7]);
434 $xml->dataElement('imageurl', $row[8]);
435 $xml->dataElement('summary', $row[9]);
436 $xml->dataElement('checkinmsg', $row[10]);
437 $xml->dataElement('checkinmsgtype', $row[11]);
438 $xml->dataElement('sip_media_type', $row[12]);
439 $xml->dataElement('hideinopac', $row[13]);
440 $xml->dataElement('searchcategory', $row[14]);
441 $xml->endTag('value');
443 $xml->endTag('itemtypes');
445 $xml->startTag('authorised_values');
446 $sth = sql_giveback($dbh,"SELECT category,authorised_value,lib,lib_opac,imageurl FROM authorised_values where category = 'ITEMTYPECAT';");
447 while (my @row = $sth->fetchrow_array) {
448 $xml->startTag('value');
449 $xml->dataElement('category', $row[0]);
450 $xml->dataElement('authvalue', $row[1]);
451 $xml->dataElement('lib', $row[2]);
452 $xml->dataElement('lib_opac', $row[3]);
453 $xml->dataElement('image_url', $row[4]);
454 $xml->endTag('value');
456 $xml->endTag('authorised_values');
458 $xml->startTag('localizations');
459 $sth = sql_giveback($dbh,"SELECT entity, code, lang, translation FROM localization WHERE entity = 'itemtypes';");
460 while (my @row = $sth->fetchrow_array) {
461 $xml->startTag('value');
462 $xml->dataElement('entity', $row[0]);
463 $xml->dataElement('code', $row[1]);
464 $xml->dataElement('lang', $row[2]);
465 $xml->dataElement('translation', $row[3]);
466 $xml->endTag('value');
468 $xml->endTag('localizations');
470 $xml->endTag('document');
478 my $backupfile = shift;
480 open(my $fh, '>', $backupfile) or die "Could not open $backupfile!";
481 my $xml = XML::Writer->new(OUTPUT => $fh, DATA_MODE => 1, DATA_INDENT => 2, );
482 $xml->xmlDecl('UTF-8');
483 $xml->startTag('letters');
485 my $sth = sql_giveback($dbh,"SELECT module,code,branchcode,name,is_html,title,content,message_transport_type,lang FROM letter");
486 while (my @row = $sth->fetchrow_array) {
487 $xml->startTag('letter');
488 $xml->dataElement('module',$row[0]);
489 $xml->dataElement('code',$row[1]);
490 $xml->dataElement('branchcode',$row[2]);
491 $xml->dataElement('name',$row[3]);
492 $xml->dataElement('is_html',$row[4]);
493 $xml->dataElement('title',$row[5]);
494 $xml->dataElement('content',$row[6]);
495 $xml->dataElement('message_transport_type',$row[7]);
496 $xml->dataElement('lang',$row[8]);
497 $xml->endTag('letter');
500 $xml->endTag('letters');
506 sub backup_libraries {
508 my $backupfile = shift;
510 open(my $fh, '>', $backupfile) or die "Could not open $backupfile!";
511 my $xml = XML::Writer->new(OUTPUT => $fh, DATA_MODE => 1, DATA_INDENT => 2, );
512 $xml->xmlDecl('UTF-8');
513 $xml->startTag('libraries');
515 my $sth = sql_giveback($dbh,"SELECT id,parent_id,branchcode,title,description,ft_hide_patron_info,ft_search_groups_opac,ft_search_groups_staff FROM library_groups");
516 while (my @row = $sth->fetchrow_array) {
517 $xml->startTag('library_group');
518 $xml->dataElement('id',$row[0]);
519 $xml->dataElement('parent_id',$row[1]);
520 $xml->dataElement('branchcode',$row[2]);
521 $xml->dataElement('title',$row[3]);
522 $xml->dataElement('description',$row[4]);
523 $xml->dataElement('ft_hide_patron_info',$row[5]);
524 $xml->dataElement('ft_search_groups_opac',$row[6]);
525 $xml->dataElement('ft_search_groups_staff',$row[7]);
526 $xml->endTag('library_group');
529 $sth = sql_giveback($dbh,"SELECT branchcode,branchname,branchaddress1,branchaddress2,branchaddress3,branchzip,branchcity,branchstate,branchcountry,branchphone,branchfax,branchemail,branchreplyto,branchreturnpath,branchurl,issuing,branchip,branchprinter,branchnotes,opac_info,geolocation,marcorgcode,pickup_location FROM branches");
530 while (my @row = $sth->fetchrow_array) {
531 $xml->startTag('library');
532 $xml->dataElement('branchcode',$row[0]);
533 $xml->dataElement('branchname',$row[1]);
534 $xml->dataElement('branchaddress1',$row[2]);
535 $xml->dataElement('branchaddress2',$row[3]);
536 $xml->dataElement('branchaddress3',$row[4]);
537 $xml->dataElement('branchzip',$row[5]);
538 $xml->dataElement('branchcity',$row[6]);
539 $xml->dataElement('branchstate',$row[7]);
540 $xml->dataElement('branchcountry',$row[8]);
541 $xml->dataElement('branchphone',$row[9]);
542 $xml->dataElement('branchfax',$row[10]);
543 $xml->dataElement('branchemail',$row[11]);
544 $xml->dataElement('branchreplyto',$row[12]);
545 $xml->dataElement('branchreturnpath',$row[13]);
546 $xml->dataElement('branchurl',$row[14]);
547 $xml->dataElement('issuing',$row[15]);
548 $xml->dataElement('branchip',$row[16]);
549 $xml->dataElement('branchprinter',$row[17]);
550 $xml->dataElement('branchnotes',$row[18]);
551 $xml->dataElement('opac_info',$row[19]);
552 $xml->dataElement('geolocation',$row[20]);
553 $xml->dataElement('marcorgcode',$row[21]);
554 $xml->dataElement('pickup_location',$row[22]);
555 $xml->endTag('library');
558 $xml->endTag('libraries');
564 sub backup_messages {
566 my $backupfile = shift;
568 open(my $fh, '>', $backupfile) or die "Could not open $backupfile!";
569 my $xml = XML::Writer->new(OUTPUT => $fh, DATA_MODE => 1, DATA_INDENT => 2, );
570 $xml->xmlDecl('UTF-8');
571 $xml->startTag('document');
573 $xml->startTag('message_attributes');
574 my $sth = sql_giveback($dbh,'SELECT AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_NAME = "message_attributes"');
575 my @ai = $sth->fetchrow_array;
576 $xml->dataElement('autoincrement', $ai[0]);
577 $sth = sql_giveback($dbh,"SELECT message_attribute_id, message_name, takes_days FROM message_attributes");
578 while (my @row = $sth->fetchrow_array) {
579 $xml->startTag('value');
580 $xml->dataElement('message_attribute_id', $row[0]);
581 $xml->dataElement('message_name', $row[1]);
582 $xml->dataElement('takes_days', $row[2]);
583 $xml->endTag('value');
585 $xml->endTag('message_attributes');
587 $xml->startTag('message_transport_types');
588 $sth = sql_giveback($dbh,"SELECT message_transport_type FROM message_transport_types");
589 while (my @row = $sth->fetchrow_array) {
590 $xml->startTag('value');
591 $xml->dataElement('message_transport_type', $row[0]);
592 $xml->endTag('value');
594 $xml->endTag('message_transport_types');
596 $xml->startTag('message_transports');
597 $sth = sql_giveback($dbh,"SELECT message_attribute_id, message_transport_type, is_digest, letter_module, letter_code, branchcode FROM message_transports");
598 while (my @row = $sth->fetchrow_array) {
599 $xml->startTag('value');
600 $xml->dataElement('message_attribute_id', $row[0]);
601 $xml->dataElement('message_transport_type', $row[1]);
602 $xml->dataElement('is_digest', $row[2]);
603 $xml->dataElement('letter_module', $row[3]);
604 $xml->dataElement('letter_code', $row[4]);
605 $xml->dataElement('branchcode', $row[5]);
606 $xml->endTag('value');
608 $xml->endTag('message_transports');
610 $xml->endTag('document');
616 sub backup_patrontypes {
618 my $backupfile = shift;
620 open(my $fh, '>', $backupfile) or die "Could not open $backupfile!";
621 my $xml = XML::Writer->new(OUTPUT => $fh, DATA_MODE => 1, DATA_INDENT => 2, );
622 $xml->xmlDecl('UTF-8');
623 $xml->startTag('patron');
624 my $sth = sql_giveback($dbh,"SELECT categorycode,description,enrolmentperiod,enrolmentperioddate,upperagelimit,dateofbirthrequired,finetype,bulk,enrolmentfee,overduenoticerequired,issuelimit,reservefee,hidelostitems,category_type,BlockExpiredPatronOpacActions,default_privacy,checkprevcheckout,reset_password,change_password FROM categories");
625 while (my @row = $sth->fetchrow_array) {
626 $xml->startTag('category');
627 $xml->dataElement('categorycode',$row[0]);
628 $xml->dataElement('description',$row[1]);
629 $xml->dataElement('enrolmentperiod',$row[2]);
630 $xml->dataElement('enrolmentperioddate',$row[3]);
631 $xml->dataElement('upperagelimit',$row[4]);
632 $xml->dataElement('dateofbirthrequired',$row[5]);
633 $xml->dataElement('finetype',$row[6]);
634 $xml->dataElement('bulk',$row[7]);
635 $xml->dataElement('enrolmentfee',$row[8]);
636 $xml->dataElement('overduenoticerequired',$row[9]);
637 $xml->dataElement('issuelimit',$row[10]);
638 $xml->dataElement('reservefee',$row[11]);
639 $xml->dataElement('hidelostitems',$row[12]);
640 $xml->dataElement('category_type',$row[13]);
641 $xml->dataElement('BlockExpiredPatronOpacActions',$row[14]);
642 $xml->dataElement('default_privacy',$row[15]);
643 $xml->dataElement('checkprevcheckout',$row[16]);
644 $xml->dataElement('reset_password',$row[17]);
645 $xml->dataElement('change_password',$row[18]);
646 $xml->endTag('category');
648 $xml->endTag('patron');
654 sub backup_preferences {
656 my $backupfile = shift;
658 open(my $fh, '>', $backupfile) or die "Could not open $backupfile!";
659 my $xml = XML::Writer->new(OUTPUT => $fh, DATA_MODE => 1, DATA_INDENT => 2, );
660 $xml->xmlDecl('UTF-8');
661 $xml->startTag('preferences');
662 my $sth = sql_giveback($dbh,"SELECT variable,value FROM systempreferences WHERE value != '' AND value IS NOT NULL");
663 while (my @row = $sth->fetchrow_array) {
664 $xml->startTag('pref');
665 $xml->dataElement('variable',$row[0]);
666 $xml->dataElement('value',$row[1]);
667 $xml->endTag('pref');
669 $xml->endTag('preferences');
677 my $backupfile = shift;
679 open(my $fh, '>', $backupfile) or die "Could not open $backupfile!";
680 my $xml = XML::Writer->new(OUTPUT => $fh, DATA_MODE => 1, DATA_INDENT => 2, );
681 $xml->xmlDecl('UTF-8');
682 $xml->startTag('reports');
684 my $sth = sql_giveback($dbh,"SELECT s.date_created, s.last_modified, s.savedsql, s.report_name, s.type, s.notes, s.cache_expiry, s.public, s.report_area, s.report_group, s.report_subgroup, b.userid FROM saved_sql s LEFT JOIN borrowers b ON b.borrowernumber = s.borrowernumber");
685 while (my @row = $sth->fetchrow_array) {
686 $xml->startTag('sqlreport');
687 $xml->dataElement('date_created',$row[0]);
688 $xml->dataElement('last_modified',$row[1]);
689 $xml->dataElement('savedsql',$row[2]);
690 $xml->dataElement('report_name',$row[3]);
691 $xml->dataElement('type',$row[4]);
692 $xml->dataElement('notes',$row[5]);
693 $xml->dataElement('cache_expiry',$row[6]);
694 $xml->dataElement('public',$row[7]);
695 $xml->dataElement('report_area',$row[8]);
696 $xml->dataElement('report_group',$row[9]);
697 $xml->dataElement('report_subgroup',$row[10]);
698 $xml->dataElement('userid',$row[11]);
699 $xml->endTag('sqlreport');
702 $xml->endTag('reports');
708 sub backup_smsproviders {
710 my $backupfile = shift;
712 open(my $fh, '>', $backupfile) or die "Could not open $backupfile!";
713 my $xml = XML::Writer->new(OUTPUT => $fh, DATA_MODE => 1, DATA_INDENT => 2, );
714 $xml->xmlDecl('UTF-8');
715 $xml->startTag('sms');
716 my $sth = sql_giveback($dbh,"SELECT name,domain FROM sms_providers");
717 while (my @row = $sth->fetchrow_array) {
718 $xml->startTag('provider');
719 $xml->dataElement('name',$row[0]);
720 $xml->dataElement('domain',$row[1]);
721 $xml->endTag('provider');
730 sub create_timestamp {
731 my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime(time);
733 $mon = sprintf("%02s",$mon);
734 $mday = sprintf("%02s",$mday);
735 $hour = sprintf("%02s",$hour);
736 $min = sprintf("%02s",$min);
737 $sec = sprintf("%02s",$sec);
738 my $str = "$year$mon$mday$hour$min$sec";
744 my $statement = shift;
745 my $sth = $dbh->prepare($statement);
753 my $sth = $dbh->prepare($query);
760 print STDERR "$0: $msg", "\n";
768 mig export foo_a foo_b foo_c