From c40cdac06a0639d034579f8d7351a3cdb82c69ee Mon Sep 17 00:00:00 2001
From: Rogan Hamby <rhamby@equinoxinitiative.org>
Date: Tue, 16 Jun 2020 14:30:05 -0400
Subject: [PATCH] adding letter syncing to kmig import and export

---
 kmig.d/bin/mig-export |   39 ++++++++++++++++++++++++++++++++++++++-
 kmig.d/bin/mig-import |   36 +++++++++++++++++++++++++++++++++++-
 2 files changed, 73 insertions(+), 2 deletions(-)

diff --git a/kmig.d/bin/mig-export b/kmig.d/bin/mig-export
index 2920514..a39a8ad 100755
--- a/kmig.d/bin/mig-export
+++ b/kmig.d/bin/mig-export
@@ -27,7 +27,7 @@ $dbh->{mysql_enable_utf8mb4} = 1;
 
 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();
@@ -69,6 +69,11 @@ foreach my $backup (@taglist) {
         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";
@@ -497,6 +502,38 @@ sub backup_itemtypes {
     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;
diff --git a/kmig.d/bin/mig-import b/kmig.d/bin/mig-import
index ef1aa7e..1edab2c 100755
--- a/kmig.d/bin/mig-import
+++ b/kmig.d/bin/mig-import
@@ -29,7 +29,7 @@ $dbh->do('SET NAMES utf8mb4');
 
 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) {
@@ -76,6 +76,12 @@ 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'; }
@@ -527,6 +533,34 @@ sub restore_itemtypes {
     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;
-- 
1.7.2.5