my @taglist = @ARGV;
my $arg_list_length = scalar @taglist;
-if($arg_list_length < 1) { @taglist = ("authorisedvalues","booksellers","budgets","borrowerattributes","calendar","circrules","itemtypes","libraries","patrontypes","preferences","reports","smsproviders"); }
+if($arg_list_length < 1) { @taglist = ("authorisedvalues","booksellers","budgets","borrowerattributes","calendar","circrules","itemtypes","letters","libraries","patrontypes","preferences","reports","smsproviders"); }
$MIGGITDIR =~ s/\/\//\//;
my $timestamp = create_timestamp();
print "Backing up $backupfile ... \n";
backup_itemtypes($dbh,$backupfile);
}
+ if ($backup eq 'letters') {
+ $backupfile = $MIGGITDIR . 'letters' . '.' . $timestamp . '.xml';
+ print "Backing up $backupfile ... \n";
+ backup_letters($dbh,$backupfile);
+ }
if ($backup eq 'libraries') {
$backupfile = $MIGGITDIR . 'libraries' . '.' . $timestamp . '.xml';
print "Backing up $backupfile ... \n";
return;
}
+sub backup_letters {
+ my $dbh = shift;
+ my $backupfile = shift;
+
+ open(my $fh, '>', $backupfile) or die "Could not open $backupfile!";
+ my $xml = XML::Writer->new(OUTPUT => $fh, DATA_MODE => 1, DATA_INDENT => 2, );
+ $xml->xmlDecl('UTF-8');
+ $xml->startTag('letters');
+
+ my $query = "SELECT module,code,branchcode,name,is_html,title,content,message_transport_type,lang FROM letter";
+ my $sth = $dbh->prepare($query);
+ $sth->execute();
+ while (my @row = $sth->fetchrow_array) {
+ $xml->startTag('letter');
+ $xml->dataElement('module',$row[0]);
+ $xml->dataElement('code',$row[1]);
+ $xml->dataElement('branchcode',$row[2]);
+ $xml->dataElement('name',$row[3]);
+ $xml->dataElement('is_html',$row[4]);
+ $xml->dataElement('title',$row[5]);
+ $xml->dataElement('content',$row[6]);
+ $xml->dataElement('message_transport_type',$row[7]);
+ $xml->dataElement('lang',$row[8]);
+ $xml->endTag('letter');
+ }
+
+ $xml->endTag('letters');
+ $xml->end();
+ close $fh;
+ return;
+}
+
sub backup_libraries {
my $dbh = shift;
my $backupfile = shift;
my @taglist = @ARGV;
my $arg_list_length = scalar @taglist;
-if($arg_list_length < 1) { @taglist = ("authorisedvalues","booksellers","borrowerattributes","budgets","calendar","circrules","itemtypes","libraries","patrontypes","preferences","reports","smsproviders"); }
+if($arg_list_length < 1) { @taglist = ("authorisedvalues","booksellers","borrowerattributes","budgets","calendar","circrules","itemtypes","letters","libraries","patrontypes","preferences","reports","smsproviders"); }
$MIGGITDIR =~ s/\/\//\//;
foreach my $restore (@taglist) {
print "Restoring from $restorefile ... \n";
if ($restorefile) { restore_itemtypes($dbh,$restorefile); }
}
+ if ($restore eq 'letters') {
+ my $timestamp = most_recent_single($MIGGITDIR,'letters');
+ if ($timestamp) { $restorefile = $MIGGITDIR . 'letters' . '.' . $timestamp . '.xml'; }
+ print "Restoring from $restorefile ... \n";
+ if ($restorefile) { restore_letters($dbh,$restorefile); }
+ }
if ($restore eq 'libraries') {
my $timestamp = most_recent_single($MIGGITDIR,'libraries');
if ($timestamp) { $restorefile = $MIGGITDIR . 'libraries' . '.' . $timestamp . '.xml'; }
return;
}
+sub restore_letters {
+ my $dbh = shift;
+ my $restore_file = shift;
+ my $parser = XML::LibXML->new();
+ my $dom = $parser->parse_file($restore_file);
+
+ my $query = "DELETE FROM letter WHERE 1 = 1";
+ my $sth = $dbh->prepare($query);
+ $sth->execute();
+
+ foreach my $node ($dom->findnodes('/letters/letter')) {
+ my $module = sql_str($node->findvalue('./module'));
+ my $code = sql_str($node->findvalue('./code'));
+ my $branchcode = sql_str_not_null($node->findvalue('./branchcode'));
+ my $name = sql_str($node->findvalue('./name'));
+ my $is_html = sql_num($node->findvalue('./is_html'));
+ my $title = sql_str($node->findvalue('./title'));
+ my $content = sql_str($node->findvalue('./content'));
+ my $message_transport_type = sql_str($node->findvalue('./message_transport_type'));
+ my $lang = sql_str($node->findvalue('./lang'));
+ $query = "INSERT INTO letter (module,code,branchcode,name,is_html,title,content,message_transport_type,lang) VALUES ($module,$code,$branchcode,$name,$is_html,$title,$content,$message_transport_type,$lang)";
+ $sth = $dbh->prepare($query);
+ $sth->execute();
+ }
+
+ return;
+}
+
sub restore_libraries {
my $dbh = shift;
my $restorefile = shift;