1 files changed, 185 insertions, 0 deletions

diff --git a/admin/survey/classes/class.VprasanjeDeleted.php b/admin/survey/classes/class.VprasanjeDeleted.php
new file mode 100644
index 0000000..11c42c6
--- /dev/null
+++ b/admin/survey/classes/class.VprasanjeDeleted.php
@@ -0,0 +1,185 @@
+<?php

+

+/**

+* 

+* Pobrisana vprasanja - pred brisanjem se vprasanje kopira med pobrisane - podobno kot knjiznica

+* 

+*/

+

+class VprasanjeDeleted {

+	

+	var $ank_id;                // trenutna anketa

+

+		

+	public function __construct ($anketa = 0) {

+		

+		if (isset ($_GET['anketa']))

+			$this->ank_id = $_GET['anketa'];

+		elseif (isset ($_POST['anketa'])) 

+			$this->ank_id = $_POST['anketa'];

+		elseif ($anketa != 0) 

+			$this->ank_id = $anketa;

+	}

+	

+    

+    // Prikazemo seznam pobrisanih vprasanj uporabnika

+    private function displayDeletedVprasanja(){

+        global $lang;

+        global $global_user_id;

+        global $admin_type;

+

+

+        // Naslov v oknu

+        echo '<h2><span class="faicon delete"></span>'.$lang['srv_deleted_vprasanja'].'</h2>';

+        echo '<div class="popup_close"><a href="#" onclick="popupClose();">✕</a></div>';

+

+

+        // Vsebina

+        echo '<div id="vprasanje_deleted_content" class="content">';

+

+        

+        // Seznam vseh pobrisanih vprasanj

+        echo '<div class="question_list">';

+

+        // Loop po vseh pobrisanih vprasanjih v anketi

+        $sql = sisplet_query("SELECT sd.*, s.naslov 

+                                FROM srv_spremenljivka_deleted sd, srv_spremenljivka s 

+                                WHERE sd.ank_id='".$this->ank_id."' AND sd.spr_id=s.id 

+                                ORDER BY sd.delete_time DESC

+                            ");  

+

+        while($row = mysqli_fetch_array($sql)){

+            

+            echo '<div id="question_item_holder_'.$row['spr_id'].'" class="question_item_holder" onClick="selectVprasanjeDeletedItem(\''.$row['spr_id'].'\');">';

+            

+            echo '  <input type="checkbox" id="question_item_check_'.$row['spr_id'].'" class="question_item_check" onClick="selectVprasanjeDeletedItem(\''.$row['spr_id'].'\');"><label for="question_item_check_'.$row['spr_id'].'"></label>';

+            

+            echo '  <div id="question_item_info_'.$row['spr_id'].'" item-id="'.$row['spr_id'].'" class="question_item_info">';

+            

+            echo '      <div>';

+            echo '          <span class="faicon list"></span>';

+            echo '          <span class="title">'.substr(strip_tags($row['naslov']), 0, 40).'</span>';

+            echo '          <span class="date">('.date("G:i d.m.Y", strtotime($row['delete_time'])).')</span>';

+            echo '      </div>';

+            

+            echo '      <span class="faicon monitor" title="'.$lang['srv_predogled_spremenljivka'].'" onClick="previewVprasanje(\''.$row['spr_id'].'\');"></span>';

+            

+            echo '  </div>';

+            

+            echo '</div>';

+        }

+

+        echo '</div>';

+

+

+        // Item counter

+        echo '<div class="selected_items">'.$lang['srv_library_item_counter'].': <span id="selected_item_counter">0</span></div>';

+

+

+        // Gumbi na dnu

+        echo '<div class="button_holder">';

+        echo '  <button class="medium white-blue" onClick="popupClose();">'.$lang['edit1338'].'</button>';

+        echo '  <button id="insert_vprasanje_deleted_button" class="medium blue" disabled="disabled" onClick="insertVprasanjeDeletedItemsIntoSurvey();">'.$lang['srv_library_survey_add'].'</button>';

+        echo '</div>';

+

+

+        echo '</div>';

+    }

+

+

+    // Pri brisanju najprej skopiramo vprasanje ki ga brisemo

+    public function createDeletedVprasanje($spr_id){

+        global $global_user_id;

+

+        // Skopiramo spremenljivko 

+        $b = new Branching($this->ank_id);

+        $new_spr_id = $b->nova_spremenljivka(-3, 0, 0, $spr_id);  

+

+        // Zabelezimo v bazi povezavo z anketo in cas brisanja

+        $sql1 = sisplet_query("INSERT INTO srv_spremenljivka_deleted (spr_id, ank_id, delete_time) VALUES ('".$new_spr_id."', '".$this->ank_id."', NOW())");

+    }

+

+    // Vrnemo stevilo pobrisanih vprasanj v anketi

+    public function countDeletedVprasanja(){

+

+        $sql = sisplet_query("SELECT COUNT(id) AS cnt FROM srv_spremenljivka_deleted WHERE ank_id='".$this->ank_id."'");  

+        $row = mysqli_fetch_array($sql);

+

+        return $row['cnt'];

+    }

+

+

+    // Dokoncno brisanje vprasanja

+    public static function permanentDeleteVprasanje($spremenljivka){

+

+        if ($spremenljivka > 0) {

+

+            $rowg = Cache::srv_spremenljivka($spremenljivka);

+

+            // pri brisanju multiple grid vprasanja, moramo pobrisate tudi vse child spremenljivke (ker kljuci niso nastavljeni)

+            if ($rowg['tip'] == 24) {

+                $sqld = sisplet_query("SELECT spr_id FROM srv_grid_multiple WHERE parent='$spremenljivka'");

+                while ($rowd = mysqli_fetch_array($sqld)) {

+                    sisplet_query("DELETE FROM srv_spremenljivka WHERE id='$rowd[spr_id]'");

+                }

+            }

+

+            $sql = sisplet_query("DELETE FROM srv_vrednost WHERE spr_id='$spremenljivka'");

+            $sql = sisplet_query("DELETE FROM srv_grid WHERE spr_id='$spremenljivka'");

+            $sql = sisplet_query("DELETE FROM srv_spremenljivka WHERE id='$spremenljivka'");

+        }

+    }

+

+

+    /**

+    * @desc pohendla ajax klice

+    */

+    public function ajax () {

+        global $lang;

+        global $global_user_id;

+

+

+        // Odpremo popup s pobrisanimi vprasanji

+    	if ($_GET['a'] == 'displayVprasanjeDeletedPopup') {

+            $this->displayDeletedVprasanja();

+

+            // Div za dodaten popup za preview

+            echo '<div id="vprasanje_preview" class="displayNone"></div>';

+        } 

+

+        // Dodajanje pobrisanega vprasanja nazaj v vprasalnik

+        elseif ($_GET['a'] == 'addIntoSurvey') {

+            

+            $items = $_POST['items'];

+            

+            $b = new Branching($this->ank_id);

+            $ba = new BranchingAjax($this->ank_id);

+            

+            foreach(array_reverse($items) as $item_id){

+

+                $last_spr = $b->find_last_spr();

+

+                // Dodamo vprasanje v anketo           

+                $ba->spremenljivka_new($spremenljivka=$last_spr, $if=0, $endif=0, $copy=$item_id, $drop=0);   

+            }

+

+            Common::getInstance()->Init($this->ank_id);

+            Common::getInstance()->prestevilci(0, $all=true);

+

+            $b->branching_struktura();

+        } 

+

+

+        // Dokoncen izbris pobrisanega vprasanja

+        elseif ($_GET['a'] == 'deleteItem') {

+            

+            $item_id = $_POST['item_id'];

+

+            if($item_id != '' && $item_id > 0){

+                sisplet_query("DELETE FROM srv_spremenljivka WHERE id='".$item_id."'AND folder!='0'");

+            }

+        }

+    }

+}

+

+?>
\ No newline at end of file