/creafile.php

<?php

session_start();

include 'CSS/templateTop.html';



require_once 'login.php';



if(!isset($_SESSION['changeover_IDutente'])){

    header("location: index.php");

}

else 

{

 /*   

/* per far accedere alla pagina solo un amministratore

if($_SESSION['nonconf_DBA']=='Y')

{

*/



include 'barramenu.php';





/** PHPExcel */

require_once 'Classes/PHPExcel.php';



$numero=$_POST['numero'];

$nomefile="changeover".$numero.".xls";

$percorso="C:\Documents and Settings\amorello\Desktop\Change-over\Programma PHP-MySQL\dati\\".$nomefile;



$datanchange=date ('Y-m-d');

$query = "INSERT INTO nchange (nchange,nomefile,data) VALUES (\"$numero\",\"$nomefile\",\"$datanchange\" )";

$result = mysql_query($query);

if (!$result) die ("Database access failed: " . mysql_error().$query);

$ID_change= mysql_insert_id();



$objPHPExcel = new PHPExcel();



// Rename sheet

$objPHPExcel->getActiveSheet()->setTitle('Change');





// Add some data



//$objPHPExcel->setActiveSheetIndex(0)

//            ->setCellValue('A1', 'Hello')

//            ->setCellValue('B2', 'world!')

//            ->setCellValue('C1', 'Hello')

//            ->setCellValue('D2', 'world!');



$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 1, 'N.');

$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 1, 'ID_bene');

$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, 1, 'marca modello');

$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, 1, 'sc');

$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, 1, 'ufficio');

$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, 1, 'ubicazione');

$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, 1, 'utente di riferimento');

$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, 1, 'telefono');

$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, 1, 'attivita');

$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 1, 'presa di rete');

$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, 1, 'note');









$dainviare= $_POST['dainviare'];

foreach($dainviare as $j => $ID) {

    

    $query = "SELECT * FROM interventi WHERE ID=$ID";

    $result = mysql_query($query);

    if (!$result) die ("Database access failed: " . mysql_error().$query);

        $row = mysql_fetch_row($result);

        $tipo = $row[1];

        if($tipo=='sost'){

            $bene = $row[2];

            

            $query = "SELECT * FROM pc WHERE ID=$bene";

            $result2 = mysql_query($query);

            if (!$result2) die ("Database access failed: " . mysql_error().$query);

            $row2 = mysql_fetch_row($result2);

            $ID_bene = $row2[1];

            $marcamodello= $row2[2];

            $ID_monitor = $row2[3];

            $pollici= $row2[4];

        }else{

            $bene = '';

            $ID_bene = '';

            $marcamodello= '';

            $ID_monitor = '';

            $pollici= '';

        }

        

        $collocazione= $row[3];

        

        $query = "SELECT * FROM collocazione WHERE ID=$collocazione";

        $result2 = mysql_query($query);

        if (!$result2) die ("Database access failed: " . mysql_error().$query);

        $row2 = mysql_fetch_row($result2);

        $ubicazione = $row2[1];

        $sc= $row2[2];

        $ufficio = $row2[3];

        

        $query = "SELECT * FROM sc WHERE ID=$sc";

        $result2 = mysql_query($query);

        if (!$result2) die ("Database access failed: " . mysql_error().$query);

        $row2 = mysql_fetch_row($result2);

        $sc = $row2[1];

        

        $cognome_nome_utente = $row[4];

        $telefono = $row[5];

        $n1 = $row[8];

        $n2 = $row[9];

        $n3 = $row[10];

        $riepnote="";

        if($n1!=0)

        {

            $query = "SELECT nota FROM note WHERE ID=$n1";

            $result2 = mysql_query($query);

            if (!$result2) die ("Database access failed: " . mysql_error().$query);

            $row2 = mysql_fetch_row($result2);

            $riepnote = "Programmi: ".$row2[0];

        }

        if($n2!=0)

        {

            $query = "SELECT nota FROM note WHERE ID=$n2";

            $result2 = mysql_query($query);

            if (!$result2) die ("Database access failed: " . mysql_error().$query);

            $row2 = mysql_fetch_row($result2);

            $riepnote = $riepnote."Orario:".$row2[0];

        }

        if($n3!=0)

        {

            $query = "SELECT nota FROM note WHERE ID=$n3";

            $result2 = mysql_query($query);

            if (!$result2) die ("Database access failed: " . mysql_error().$query);

            $row2 = mysql_fetch_row($result2);

            $riepnote = $riepnote."Varie:".$row2[0];

        }

        

        

        

        $presadirete=$row[6];

        $attiva=$row[7];

        

        $sopralluogo = $row[11];

        

        $query = "SELECT * FROM sopralluogo WHERE ID=\"$sopralluogo\"";

        $result2 = mysql_query($query);

        if (!$result2) die ("Database access failed: " . mysql_error().$query);

        $row2 = mysql_fetch_row($result2);

        $presarete = $row2[1];

        $corrente = $row2[2];

        $nsop = $row2[3];

        

        if($nsop!=0)       

        {

            $query = "SELECT nota FROM note WHERE ID=\"$nsop\"";

            $result2 = mysql_query($query);

            if (!$result2) die ("Database access failed: " . mysql_error().$query);

            $row2 = mysql_fetch_row($result2);

            $riepnote = $riepnote."Sopralluogo:".$row2[0];  

        }

        

        $datarichiesta = $row[15];

        list($data_a,$data_m,$data_g) = explode("-",$datarichiesta);

        $time = mktime(0,0,0, $data_m, $data_g, $data_a);

        $datarichiesta= date ('d-m-Y',$time);

        

        $ID_nelfile=$j+1;

        $riga=$j + 2;

        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $riga, $ID_nelfile);

        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $riga, $ID_bene);

        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, $riga, $marcamodello);

        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, $riga, $sc);

        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, $riga, $ufficio);

        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, $riga, $ubicazione);

        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, $riga, $cognome_nome_utente);

        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, $riga, $telefono);

        if($tipo=='sost'){

            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, $riga, 'SOSTITUZIONE');   

        }else{

            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, $riga, 'NUOVO');

            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, $riga, $presadirete." ".$attiva);

        }

        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, $riga, $riepnote);

        

        $query = "INSERT INTO inva (nchange,ID_nelfile) VALUES (\"$ID_change\",\"$ID_nelfile\" )";

        $result2 = mysql_query($query);

        if (!$result2) die ("Database access failed: " . mysql_error().$query);

        $ID_inva= mysql_insert_id();

        

        $query = "UPDATE interventi SET  inva=\"$ID_inva \" WHERE ID=$ID ";

        $result2 = mysql_query($query);

        if (!$result2) die ("Database access failed: " . mysql_error().$query);

}



//header("location: prova.xls");



// Save Excel file



$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

$objWriter->save($percorso);



header("location: dati\\$nomefile");

}



include 'CSS/templateEnd.html';

?>