echoproject/loadEditVersionForm.php at master · DanielTaranger/echoproject · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
<?php

session_start();
require('db.php');
    if (isset($_SESSION['username'])){
        $username = $_SESSION['username'];
        $username = stripslashes($username);

        $versionID = $_POST['versionID'];

        $query="SELECT * FROM versions WHERE versionID='$versionID'";
        $result = mysqli_query($conn, $query) or die(mysqli_error($conn));
        $rows = mysqli_num_rows($result);

        $before = '<div><p>Parent version</p><select id="myselect" class="form-group">';
        $after = "</select></div>";

        $projectID = "";
        $titleData = "";
        $descriptionData = "";
        $fileData = "";

        if($rows>=1){
            while($row = mysqli_fetch_array($result)) {
                $projectID = $row[0];
                $titleData = $row[2];
                $descriptionData = $row[3];
                $fileData = $row[5];
            }
        }else {

        }

        $data = array();

        $beforefirst = file_get_contents("include/contentBox.html");
        $first = file_get_contents("include/editForm.html");
        $editClick = '<div id="versionButtons">'.'<a id="editButton"  class="versionButton" onclick="LoadVersionInfo('."'". $versionID ."'".')"></a>' . '<a id="deleteButton"  class="versionButton" onclick="deleteVersion('."'". $projectID ."', '" . $versionID . "'".')"><img src="img/dump.png" alt="Delete" height="15" width="15"></a>';
;
        $bfirst = $editClick . '<a id="boxclose"  class="versionButton" onclick="cleanDiv'."('" ."versionContainer" . "')".'"></a></div>';
        $end = file_get_contents("include/editFormEnd.html");
        $middle = "";
        $sumbit = '	<input  type="submit"  onclick="updateVersion(' ."'".$versionID. "'". ')" value="Update">' . '	<input  type="submit"  onclick="LoadVersionInfo(' ."'".$versionID. "'". ')" value="Cancel">';

        //selection of files
        $filename = 'uploaded_files/'.$projectID;
        $fileSelect = "<p><b>No files connected to this project!</b> click File Manager to add files</p>";

        if (is_dir($filename)) {
            if($fileData=="no file"){
                $fileSelect = '<p id="fileAlert"><b>No files attached!</b> click here to pick track to use </p>';
                $clickList = '<input type="submit" onclick="getFileList'."('" . $projectID . "', '". $versionID ."')".'" value="Add File">';
                $filePicker = '<div id="fileSelector"></div>';


                $fileSelect = $fileSelect . $clickList. $filePicker ;
            }else {

                $fileListing = "";
                $fileBefore = '<p>Audio file</p><select id="fileselect" class="form-group">';
                $fileAfter = "</select>";
                $dir = 'uploaded_files/'.$projectID ."/";
                $files = scandir($dir,2);

                unset($files[0]);
                unset($files[1]);

                foreach ($files as $value){
                    if( is_file($dir.$value)){
                        if($fileData == $value){
                             $fileListing = $fileListing . '<option value="' . $value . '" selected>' . $value . '</option>';
                        }else{
                            $fileListing = $fileListing . '<option value="' . $value . '" >' . $value . '</option>';
                        }
                    }
                }
                $fileSelect = $fileBefore . $fileListing . $fileAfter;

/*
                $fileSelect = '<p id="fileAlert">click here to change file</p>';
                $clickList = '<a id="fileClick" onclick="getFileList'."('" . $projectID . "')".'">Click</a>';
                $filePicker = '<div id="fileSelector"></div>';

                $fileSelect = $fileSelect  . $clickList. $filePicker;
*/
            }
        }


        if($rows>1){
                while($row = mysqli_fetch_array($result)) {
                    $middle = $middle . '<option value="'.$row[1].'">'.$row[2].'</option>';
                }
                $data['data'] =   $beforefirst . $bfirst . $first  . $before . $middle . $after . $fileSelect . $sumbit . $end;
                $data['success'] = true;
            }else{

                $data['data'] =  $beforefirst . $bfirst . $first . $fileSelect .  $sumbit . $end;
                $data['success'] = true;
        }

        $data['title'] = $titleData;
        $data['description'] = $descriptionData;

        echo json_encode($data);
    }

?>