<?php
	require_once("paar.class.php");

	$p = strip_tags(trim($_GET['p']));
	$param = explode("-", $p);
	
	switch($param[1]) {
		case "Yesterday":
			$validity = date("Y-m-d", strtotime("-1 day"))." 00:00:00";
			$dim = date("Y-m-d", strtotime("now"))." 00:00:00";
		break;
		case "Last Week":
			$validity = date("Y-m-d", strtotime("last Monday -7 days"))." 00:00:00";
			$dim = date("Y-m-d", strtotime("+7 days",strtotime($validity)))." 00:00:00";
		break;
		case "Last Month":
			$validity = date("Y-m", strtotime("-1 month"))."-01 00:00:00";
			$dim = date("Y-m", strtotime("now"))."-01 00:00:00";
		break;
		case "Last Year":
			$validity = date("Y", strtotime("-1 year"))."-01-01 00:00:00";
			$dim = date("Y", strtotime("now"))."-01-01 00:00:00";
		break;
		case "Custom":
			switch($param[3]) {
				case "day":
                    $validity = date("Y-m-d", strtotime($param[2]))." 00:00:00";
					$dim      = date("Y-m-d", strtotime("+1 day", strtotime($param[2])))." 00:00:00";
				break;
				case "week":
					$day = date("D",strtotime($param[2]));
                    if($day=="Mon")
					{
                    $validity = date("Y-m-d", strtotime($param[2]))." 00:00:00";
					}
                    else
					{
                    $validity = date("Y-m-d", strtotime("last Monday",strtotime($param[2])))." 00:00:00";
					}
					$dim = date("Y-m-d", strtotime("+7 days",strtotime($validity)))." 00:00:00";
				break;
				case "month":
					$validity = date("Y-m", strtotime($param[2]))."-01 00:00:00";
					$dim      = date("Y-m", strtotime("+1 month", strtotime($validity)))."-01 00:00:00";
				break;
				case "year":
					$validity = date("Y", strtotime($param[2]))."-01-01 00:00:00";
					$dim      = date("Y", strtotime("+1 year", strtotime($validity)))."-01-01 00:00:00";
				break;
			}
		break;
	}

	$paar = new paar();
	$db	  = $paar->getDBConn();
	
	$sql = "SELECT * FROM report.view_la_uninstall_feedback WHERE req_received_ts BETWEEN '". $validity."' AND '".$dim."' AND product_id = '".$param[0]."'";
	$result = pg_query($db, $sql);
	$report = array();
	while($row = pg_fetch_array($result, NULL, PGSQL_ASSOC) ) 
	{
		array_push($report, $row);
	}
	
	$product_name = str_replace("_","-",$param[4]);

/*   /// txt file 
$fname = 'uninstall-feedback-report-'.$product_name.'.txt';

header('Content-Description: File Transfer');
header("Content-type: application/text");
header('Content-Disposition: attachment; filename='.$fname);
header('Expires: 0');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public'); 
*/

   /// xls file 
$fname = 'uninstall-feedback-report-'.$product_name.'.xls';

header('Content-Description: File Transfer');
header("Content-Disposition: attachment; filename=\"$fname\"");
header("Content-Type: application/vnd.ms-excel");
header('Expires: 0');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public'); 

ob_clean();
flush();

for($i=0;$i<count($report);$i++)
{
$computer_id = $report[$i]['computer_id'];
$email       = $report[$i]['email'];

//$feedback    = $report[$i]['feedback'];
$feedback    = base64_decode($report[$i]['feedback']);
//$feedback       = mb_detect_encoding($feedback, 'UTF-8, ISO-8859-1', true);
//$feedback    = mb_convert_encoding($feedback, 'UTF-8', mb_detect_encoding($feedback, 'UTF-8, ISO-8859-1', true));
//$feedback = utf8_encode($feedback);

	if(!empty($feedback))
	{
	echo $computer_id.";";
	echo $email.";";
	echo $feedback;
	echo "\r\n";
	}
}

?>