<?php

$source = $_POST['source'];
$disposition = $_POST['disposition'];
$startdate = $_POST['startdate'];
$enddate = $_POST['enddate'];

$startdate = flipdate($startdate);
$enddate = flipdate($enddate);

function flipdate($date){
    return date("Y-m-j", strtotime($date));
}

$DB_Server = "localhost";
$DB_Username = "******";
$DB_Password = "******";
$DB_DBName = "******";
$DB_TBLName = "******";
$filename = "******";

$db= new mysqli($DB_Server , $DB_Username, $DB_Password, $DB_DBName);
if ($db->connect_errno) {
    echo "Error - Failed to connect to MySQL: " . $db->connect_error;
    die();
}

if(isset($source) && !empty($source)){
    if(isset($disposition) && !empty($disposition)){
        $sql= $db->prepare("SELECT * from $DB_TBLName WHERE type=? AND disp=? AND date >= ? AND date <= ?");
        $sql->bind_param('ssss',$source, $disposition, $startdate, $enddate);
    }else{
        $sql= $db->prepare("SELECT * from $DB_TBLName WHERE type=? AND date >= ? AND date <= ?");
        $sql->bind_param('sss',$source, $startdate, $enddate);
    }
}else{
    if(isset($disposition) && !empty($disposition)){
        $sql= $db->prepare("SELECT * from $DB_TBLName WHERE disp=? AND date >= ? AND date <= ?");
        $sql->bind_param('sss', $disposition, $startdate, $enddate);
    }else{
        $sql= $db->prepare("SELECT * from $DB_TBLName WHERE date >= ? AND date <= ?");
         $sql->bind_param('ss', $startdate, $enddate);
    }
}

$sql->execute();
$result = $sql->get_result();
$file_ending = "xls";

header("Content-Type: application/xls");
header("Content-Disposition: attachment; filename=$filename.xls");
header("Pragma: no-cache");
header("Expires: 0");

$sep = "\t";

while ($row = $result->fetch_field()) {
    echo $row->name . "\t";
}

print("\n");

    while($row = $result->fetch_row()){
        $schema_insert = "";
        for($j=0; $j < $result->field_count; $j++){
            if(!isset($row[$j]))
                $schema_insert .= "NULL".$sep;
            elseif ($row[$j] != "")
                $schema_insert .= "$row[$j]".$sep;
            else
                $schema_insert .= "".$sep;
        }
        $schema_insert = str_replace($sep."$", "", $schema_insert);
        $schema_insert = preg_replace("/\r\n|\n\r|\n|\r/", " ", $schema_insert);
        $schema_insert .= "\t";
        print(trim($schema_insert));
        print "\n";
    }


?>