From 4333227051cb544ddaca28c1fc68f53ec9e94ee1 Mon Sep 17 00:00:00 2001
From: Christophe Croullebois <christophe.croullebois@biblibre.com>
Date: Thu, 9 Sep 2010 13:49:51 +0200
Subject: [PATCH] (MT #3338) Fixing hold policies issues
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

The update n°3.00.06.013 fixes hold policy preferences and this one allow to delete it.
---
 admin/smart-rules.pl | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)

diff --git a/admin/smart-rules.pl b/admin/smart-rules.pl
index 2be5364eb9..c46e347151 100755
--- a/admin/smart-rules.pl
+++ b/admin/smart-rules.pl
@@ -74,6 +74,28 @@ elsif ($op eq 'delete-branch-cat') {
         $sth_delete->execute($branch, $categorycode);
     }
 }
+elsif ($op eq 'delete-branch-item') {
+    my $itemtype  = $input->param('itemtype');
+    if ($branch eq "*") {
+        if ($itemtype eq "*") {
+            my $sth_delete = $dbh->prepare("DELETE FROM default_circ_rules");
+            $sth_delete->execute();
+        } else {
+            my $sth_delete = $dbh->prepare("DELETE FROM default_branch_item_rules
+                                            WHERE itemtype = ?");
+            $sth_delete->execute($itemtype);
+        }
+    } elsif ($itemtype eq "*") {
+        my $sth_delete = $dbh->prepare("DELETE FROM default_branch_circ_rules
+                                        WHERE branchcode = ?");
+        $sth_delete->execute($branch);
+    } else {
+        my $sth_delete = $dbh->prepare("DELETE FROM branch_item_rules
+                                        WHERE branchcode = ?
+                                        AND itemtype = ?");
+        $sth_delete->execute($branch, $itemtype);
+    }
+}
 # save the values entered
 elsif ($op eq 'add') {
     my $sth_search = $dbh->prepare("SELECT COUNT(*) AS total FROM issuingrules WHERE branchcode=? AND categorycode=? AND itemtype=?");
-- 
2.39.5