<?php
ob_start();
require("includes/check_auth_user.php");
require("includes/dbconnect.php");
include('includes/function.php');
$zdb = $_SESSION["zdbyear_" . $dbname];
mysqli_select_db($conn,$zdb);
/*


  A quick script to demo the use of the export-xls.class.php script.

 */

if (isset($_REQUEST['vouchno'])) {
    $vouchno = $_REQUEST['vouchno'];
    $getexc = mysqli_query($conn,"SELECT * FROM `leadzip` WHERE `vouchno`='$vouchno'")or die(mysqli_query($conn,));
    $exc = mysqli_fetch_array($getexc);
    $excpath = $exc[zippath];
//    browse($excpath);
    $rows = mysqli_num_rows($getexc);

    $dir = "../tlt/admin/zip/";

    require('export-xls/export-xls.class.php');
    if ($rows > 0) {

        $filename = $excpath; // The file name you want any resulting file to be called.
//set the time out
        
        $mvouch = $_REQUEST['vouchno'];
        function output_file($filename, $name, $mime_type = '') {
            /*
              This function takes a path to a file to output ($file),  the filename that the browser will see ($name) and  the MIME type of the file ($mime_type, optional).
             */

            //Check the file premission
            if (!is_readable($filename))
                die('File not found or inaccessible!');
            $size = filesize($filename);
            $name = rawurldecode($name);
            /* Figure out the MIME type | Check in array */
            $known_mime_types = array(
                "pdf" => "application/pdf",
                "txt" => "text/plain",
                "html" => "text/html",
                "htm" => "text/html",
                "exe" => "application/octet-stream",
                "zip" => "application/zip",
                "doc" => "application/msword",
                "xls" => "application/vnd.ms-excel",
                "xlsx" => "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
                "ppt" => "application/vnd.ms-powerpoint",
                "gif" => "image/gif",
                "png" => "image/png",
                "jpeg" => "image/jpg",
                "jpg" => "image/jpg",
                "php" => "text/plain"
            );

            if ($mime_type == '') {
                $file_extension = strtolower(substr(strrchr($filename, "."), 1));
                if (array_key_exists($file_extension, $known_mime_types)) {
                    $mime_type = $known_mime_types[$file_extension];
                } else {
                    $mime_type = "application/force-download";
                };
            };

            //turn off output buffering to decrease cpu usage
            @ob_end_clean();

            // required for IE, otherwise Content-Disposition may be ignored
            if (ini_get('zlib.output_compression'))
                ini_set('zlib.output_compression', 'Off');

            header('Content-Type: ' . $mime_type);
            header('Content-Disposition: attachment; filename='.$name);
            header("Content-Transfer-Encoding: binary");
            header('Accept-Ranges: bytes');

            /* The three lines below basically make the 
              download non-cacheable */
            header("Cache-control: private");
            header('Pragma: private');
            header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");

            // multipart-download and download resuming support
            if (isset($_SERVER['HTTP_RANGE'])) {
                list($a, $range) = explode("=", $_SERVER['HTTP_RANGE'], 2);
                list($range) = explode(",", $range, 2);
                list($range, $range_end) = explode("-", $range);
                $range = intval($range);
                if (!$range_end) {
                    $range_end = $size - 1;
                } else {
                    $range_end = intval($range_end);
                }
                /*
                  ------------------------------------------------------------------------------------------------------
                  //This application is developed by www.webinfopedia.com
                  //visit www.webinfopedia.com for PHP,Mysql,html5 and Designing tutorials for FREE!!!
                  ------------------------------------------------------------------------------------------------------
                 */
                $new_length = $range_end - $range + 1;
                header("HTTP/1.1 206 Partial Content");
                header("Content-Length: $new_length");
                header("Content-Range: bytes $range-$range_end/$size");
            } else {
                $new_length = $size;
                header("Content-Length: " . $size);
            }

            /* Will output the file itself */
            $chunksize = 1 * (1024 * 1024); //you may want to change this
            $bytes_send = 0;
            if ($file = fopen($filename, 'r')) {
                if (isset($_SERVER['HTTP_RANGE']))
                    fseek($file, $range);

                while (!feof($file) &&
                (!connection_aborted()) &&
                ($bytes_send < $new_length)
                ) {
                    $buffer = fread($file, $chunksize);
                    print($buffer); //echo($buffer); // can also possible
                    flush();
                    $bytes_send += strlen($buffer);
                }
                fclose($file);
            } else
            //If no permissiion
                die('Error - can not open file.');
            //die
            die();
        }

//Set the time out
        set_time_limit(0);

//path to the file
        $file_path = $filename;
//        print 'new';
     

//Call the download function with file path,file name and file type
#header("Content-Disposition: attachment; filename=$newFilename");
        output_file($file_path, $vouchno.'.zip' , 'application/zip');
     

    } else {
        browse('File does not Exist');
        header("refresh: 1; confrecd.php?vouchno=$vouchno&mode=edit");

    }
}
?>