From 6c2a0f6afba8cb97e0bbc836286fb0e50ed296bc Mon Sep 17 00:00:00 2001
From: oshri <oshriro@matrix.co.il>
Date: Tue, 7 Feb 2017 16:07:19 +0200
Subject: [PATCH] add namespace as uniq feild

---
 .../src/Multipledb/Controller/MultipledbController.php |  6 ++++++
 .../src/Multipledb/Model/MultipledbTable.php           | 10 ++++++++++
 .../Multipledb/view/multipledb/multipledb/edit.phtml   | 18 +++++++++++++++++-
 sql/5_0_0-to-5_0_1_upgrade.sql                         |  1 +
 4 files changed, 34 insertions(+), 1 deletion(-)

diff --git a/interface/modules/zend_modules/module/Multipledb/src/Multipledb/Controller/MultipledbController.php b/interface/modules/zend_modules/module/Multipledb/src/Multipledb/Controller/MultipledbController.php
index ec23876d2..11b19c5c9 100644
--- a/interface/modules/zend_modules/module/Multipledb/src/Multipledb/Controller/MultipledbController.php
+++ b/interface/modules/zend_modules/module/Multipledb/src/Multipledb/Controller/MultipledbController.php
@@ -112,6 +112,12 @@ class MultipledbController extends BaseController{
 
     }
 
+    public function checknamespacejsonAction(){
+        $namespace = $_REQUEST['namespace'];
+        echo $this->getMultipledbTable()->checknamespace($namespace);
+        exit();
+    }
+
     public function generatesafekeyAction(){
         $id = substr((int)$_REQUEST['id'], 0, 11);
         $this->getJsFiles();
diff --git a/interface/modules/zend_modules/module/Multipledb/src/Multipledb/Model/MultipledbTable.php b/interface/modules/zend_modules/module/Multipledb/src/Multipledb/Model/MultipledbTable.php
index addd73355..c51fe15aa 100644
--- a/interface/modules/zend_modules/module/Multipledb/src/Multipledb/Model/MultipledbTable.php
+++ b/interface/modules/zend_modules/module/Multipledb/src/Multipledb/Model/MultipledbTable.php
@@ -56,6 +56,16 @@ class MultipledbTable
         return $rsArray;
     }
 
+    public function checknamespace($namespace){
+        $rowset = $this->tableGateway->select(array('namespace' => $namespace));
+        $count = $rowset->count();
+
+        if($count AND $_SESSION['multiple_edit_id'] == 0){
+            return 1;
+        }else{
+            return 0;
+        }
+    }
 
     public function storeMultipledb($id = 0,$db = array()){
 
diff --git a/interface/modules/zend_modules/module/Multipledb/view/multipledb/multipledb/edit.phtml b/interface/modules/zend_modules/module/Multipledb/view/multipledb/multipledb/edit.phtml
index 2207bce50..3533ba537 100644
--- a/interface/modules/zend_modules/module/Multipledb/view/multipledb/multipledb/edit.phtml
+++ b/interface/modules/zend_modules/module/Multipledb/view/multipledb/multipledb/edit.phtml
@@ -26,7 +26,7 @@
     <ul class="form-style-1">
         <li>
             <label><?php echo $translate->z_xlt('Namespace')?> <span class="required">*</span></label>
-            <input type="text" value="<?php echo $this->escapeHtml($db->namespace)?>" name="db[namespace]" required class="field-divided" placeholder="<?php echo $translate->z_xlt('Namespace')?>" />
+            <input id="namespace" type="text" value="<?php echo $this->escapeHtml($db->namespace)?>" name="db[namespace]" required class="field-divided" placeholder="<?php echo $translate->z_xlt('Namespace')?>" />
 
         </li>
         <li>
@@ -59,6 +59,22 @@
 
 <script>
 
+    $('input[type=submit]').on('click', function(e){
+        e.preventDefault();
+        var namespace = $('#namespace').val();
+        $.post( "checknamespacejson", { namespace: namespace }, function( data ) {
+            if(data == 1){
+                if($('#namespace-error').length){
+                    $('#namespace-error').remove();
+                }
+                $('#namespace').addClass('error')
+                $('#namespace').after('<label id="namespace-error" class="error" for="namespace"><?php echo $translate->z_xlt('This namespace already exists in database')?> </label>');
+            }else{
+                $('#editForm').submit();
+            }
+        }, "text");
+    });
+
     $("#editForm").validate();
     function onlynumber(e, t) {
 
diff --git a/sql/5_0_0-to-5_0_1_upgrade.sql b/sql/5_0_0-to-5_0_1_upgrade.sql
index 7eab92b09..db66cbef1 100644
--- a/sql/5_0_0-to-5_0_1_upgrade.sql
+++ b/sql/5_0_0-to-5_0_1_upgrade.sql
@@ -103,6 +103,7 @@ ALTER TABLE `list_options` ADD `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TI
     `host` varchar(255) NOT NULL DEFAULT 'localhost',
     `port` smallint(4) NOT NULL DEFAULT '3306',
     `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+     UNIQUE KEY `namespace` (namespace),
      PRIMARY KEY (id)
   ) ENGINE=InnoDB;
 #EndIf
\ No newline at end of file
-- 
2.11.4.GIT