func_downloadi.php

Dokumenacija za ovu datoteku.

<?
/**************************************************************************************
 Studentski Informacijski servis, 2004
 **************************************************************************************
 func_downloadi.php
 repozitorij funkcija za rad sa generalnim i personlanim
 donwloadima


 Srdjan Segvic - srle
 **************************************************************************************
 **************************************************************************************
 This program is free software; you can redistribute it and/or modify
 it under the terms of the GNU General Public License as published by
 the Free Software Foundation; either version 2 of the License, or
 (at your option) any later version.

 This program is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 GNU Library General Public License for more details.

 You should have received a copy of the GNU General Public License
 along with this program; if not, write to the Free Software
 Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
 **************************************************************************************/
//
// funckija vraca naziv predmeta na osnovu id-a
//
function getPredmetNaziv($pred_id){
                 $query = "SELECT naziv_predmeta
                                   FROM predmet
                                   WHERE predmet_ID = '$pred_id'";

                 $result = mysql_query($query) or
                                  die(mysql_error());

                 $row = mysql_fetch_array($result);
                 return $row[0];
         }


//
// funkcija koja priprema informacije za prikaz osnovne forme downloada
// tj. generalnih kategorija (predmeta) i personlanih downloada, poziva printDownStart()
//
function downloadiStart($id, $odsjek){
        $sem_poc = getSemestarPocetak($id);
        $sem_kraj = getSemestarKraj($id);

         $query_predmeti = "SELECT DISTINCT predmet.predmet_ID, predmet.naziv_predmeta
                                FROM  odsjek_predmet, predmet, upload
                                WHERE odsjek_predmet.odsjek_ID = '$odsjek'
                                AND   predmet.predmet_ID = upload.predmet_ID
                                AND   odsjek_predmet.datum_kraja = '0000-00-00'
                                AND   predmet.semestar_pocetak >= $sem_poc
                                AND   predmet.semestar_pocetak <= $sem_kraj
                                AND   predmet.semestar_polaganje >= $sem_poc
                                AND   predmet.semestar_polaganje <= $sem_kraj";


        $result_predmeti = mysql_query($query_predmeti) or die(mysql_error());

        if (mysql_num_rows($result_predmeti)==0){
                $note_general =  _NOGENERALDOWNS;
        }

        $brojac=0;
        while ($row_predmeti = mysql_fetch_array($result_predmeti)){
                $down_general[$brojac][0] = $row_predmeti[0];
                $down_general[$brojac][1] = $row_predmeti[1];
                $brojac++;
        }

        $query_personal = "SELECT down_personal_ID, down_ime, down_opis, down_size, down_datum
                           FROM   downloadi_personal
                           WHERE  student_id = '$id'";
        
        $result_personal = mysql_query($query_personal) or die(mysql_error());
        if (mysql_num_rows($result_personal)==0){
                $note_personal =  _NOPERSONALDOWNS;

        }
        else {
                $brojac_personal = 0;
                while ($row_personal = mysql_fetch_array($result_personal)){
                        $down_personal[$brojac_personal][0] = $row_personal[0];
                        $down_personal[$brojac_personal][1] = $row_personal[1];
                        $down_personal[$brojac_personal][2] = $row_personal[2];
                        $down_personal[$brojac_personal][3] = round(($row_personal[3]/1024),2)." KB";
                        $down_personal[$brojac_personal][4] = $row_personal[4];
                        $brojac_personal++;
                }
        }
        printDownStart($down_general, $brojac, $down_personal, $brojac_personal, $note_general, $note_personal);
}

//
// Priprema informacije za generisanje forma za dodavanje downloada
// tj. prvenstveno provjerava da li je popunjeno 10 raspoloziv mjesta
//
function downAddForm($id){
        $query_personal = "SELECT down_personal_ID
                           FROM   downloadi_personal
                           WHERE  student_ID = '$id'";
        
        $result_personal = mysql_query($query_personal) or die(mysql_error());
        if (mysql_num_rows($result_personal)==10){
                printRokoviStart(_OPERROR, 350);
                printServisGreska(_OPDOWNFOLDERFULL);
        }
        else {printDownAdd();}
}
//
// funkcija vrsi spasavanje novog downloada
// provjera raspolozivi prostor, te potom dodaje novi file u bazu
//
function downloadiAdd($id){
        
        $query_personal = "SELECT *
                           FROM   downloadi_personal
                           WHERE  student_id = '$id'";
        
        $result_personal = mysql_query($query_personal) or die(mysql_error());
        if (mysql_num_rows($result_personal)==10){
                printRokoviStart(_OPERROR, 350);
                printServisGreska(_OPDOWNFOLDERFULL);
        }
        
        else {
                if (isset($_FILES['myfile']['tmp_name']) && ($_FILES['myfile']['tmp_name']!="") && ($_FILES['myfile']['tmp_name']!="none")) {
                        $check = filesize($_FILES['myfile']['tmp_name']);
                
                        if($check>2000000){
                                printRokoviStart(_OPERROR, 350);
                                printServisGreska(_OPERRORFILETOBIG);
                        }
                        else {
                                
                                set_magic_quotes_runtime(0); 
                                $filehandle = fopen($_FILES['myfile']['tmp_name'], "rb");
                                $filedata = fread($filehandle, filesize($_FILES['myfile']['tmp_name']));
                                $filedata = addslashes($filedata);

                                $name = $_FILES['myfile']['name'];
                                $size = filesize($_FILES['myfile']['tmp_name']);
                                $mime = $_FILES['myfile']['type'];
                                $desc = $_POST['opisfile'];
                                $date = date("Y-m-d");
                
                                
                                
                                $query = "INSERT INTO downloadi_personal VALUES ('auto_increment','$id', '$name', '$mime', '$size', '$desc', '$date','$filedata')"; 
                                $result = mysql_query($query)  or die(mysql_error());
                                if ($result) { 
                                        printRokoviStart(_DOWNSMAINTITLE, 350); 
                                        printServisGreska(_OPDOWNADDSUCCESS);
                                }
                                set_magic_quotes_runtime(1); 
                        }
                        
                }
                else {
                        printRokoviStart(_OPERROR, 350);
                        printServisGreska(_OPDOWNSYSTEMERROR);
                }
        }

}


//
// funkcija se brine za korektno brisanje downloda iz baze
//
//
function downloadiDelete($delete, $id, $fid){
        if($delete==0){
                if (isset($fid)){
                        
                        $query = "SELECT down_ime, down_opis
                                  FROM   downloadi_personal
                                  WHERE  down_personal_ID = '$fid'
                                  AND    student_ID = '$id'";

                        $result = mysql_query($query) or die(mysql_error());
                        if (mysql_num_rows($result) == 0){
                                printRokoviStart(_OPERROR, 350);
                                printServisGreska(_OPSYSTEMERROR);
                        }
                        else {
                                $row = mysql_fetch_array($result);
                                
                                $naslov = $row[0];
                                $opis = $row[1];
                                printDeleteDown($fid, $naslov, $opis);
                        }
                }
        }
        
        //
        // obrada zahtjeva za brisanjem linka
        //
        elseif($delete==1){
                if (isset($fid)){                       
                        $query = "DELETE
                                  FROM   downloadi_personal
                                  WHERE  down_personal_ID = '$fid'
                                  AND    student_id = '$id'";

                        $result = mysql_query($query) or die(_OPSYSTEMERROR);
                        printRokoviStart(_OPSUCCESS, 350);
                        printServisGreska(_OPDOWNDELSUCCESS);
                }
                else {
                        printRokoviStart(_OPERROR, 350);
                        printServisGreska(_OPSYSTEMERROR);
                }
        }
}

//
// funkcija vrsi pripremu za prikaz gen. downloada iz odabrane kategorije
// tj. predmeta
//
function downloadiGeneral($id, $pid, $odsjek){

         $query_predmeti =
                                "SELECT upload.upload_id, upload.naziv_dokumenta, upload.opis_dokumenta, upload.datum_uploada, upload.velicina
                                FROM  odsjek_predmet, predmet, upload
                                WHERE odsjek_predmet.odsjek_ID = '$odsjek'
                                AND   predmet.predmet_ID = $pid
                                AND   upload.predmet_ID = $pid
                                AND   odsjek_predmet.predmet_ID = $pid
                                AND   odsjek_predmet.datum_kraja = '0000-00-00'";


        $result_predmeti = mysql_query($query_predmeti) or die(mysql_error());

        if (mysql_num_rows($result_predmeti)==0){
                $note_general =  _NOPERSONALDOWNS;
        }

        $brojac=0;
        while ($row_predmeti = mysql_fetch_array($result_predmeti)){
                $down_general[$brojac][0] = $row_predmeti[0];
                $down_general[$brojac][1] = $row_predmeti[1];
                $down_general[$brojac][2] = $row_predmeti[2];
                $down_general[$brojac][3] = $row_predmeti[3];
                $down_general[$brojac][4] = round(($row_predmeti[4]/1024),2)." KB";
                $brojac++;
        }

        printRokoviStart(_DOWNSMAINTITLE." - <strong>".getPredmetNaziv($pid) ."</strong>", 724);
        printDownGeneral($down_general, $brojac, $pid);
}
?>

---