#!/usr/bin/env php
<?
	$root = substr(__DIR__,0,strrpos(__DIR__,'/'));
	require_once($root."/dronebl.config.php");
	require_once($frameworks_path."/DroneBL/Database.framework");
	require_once($frameworks_path."/DroneBL/Cron.framework");
	require_once($frameworks_path."/DroneBL/Logging.framework");
	require_once($frameworks_path."/DroneBL/Validation.framework");
	require_once($frameworks_path."/PHPMailer/class.phpmailer.php");

	chkprog('Feed Export');
	
	$res = get_db_rows("SELECT * FROM output_feeds");
	if (!db_num_rows($res))
		endprog();
	
	$targets = [];
	while ($tuple = get_db_tuple($res))
		$targets[] = $tuple;

	$dataset = array();
	$res = get_db_rows("SELECT ip, timestamp, type FROM blacklist WHERE timestamp >= now()::abstime::int4 - 86400 ORDER BY timestamp ASC");
	while ($tuple = get_db_tuple($res))
		$dataset[] = array('ip' => $tuple['ip'], 'timestamp' => date('c', $tuple['timestamp']), 'category' => description($tuple['type']), 'classid' => $tuple['type']);
	
	if (empty($dataset))
		endprog();
	
	$csv = '"ip", "timestamp", "category", "classid"'.PHP_EOL;
	$xml = '<?xml version="1.0"?>'.PHP_EOL.'<dataset>'.PHP_EOL;
	foreach ($dataset AS $data)
	{
		$csv .= '"'.$data['ip'].'", "'.$data['timestamp'].'", "'.$data['category'].'", '.PHP_EOL;
		$xml .= tab().'<entry>'.PHP_EOL.
		tab(2).'<ip>'.$data['ip'].'</ip>'.PHP_EOL.
		tab(2).'<timestamp>'.$data['timestamp'].'</timestamp>'.PHP_EOL.
		tab(2).'<category>'.$data['category'].'</category>'.PHP_EOL.
		tab(2).'<classid>'.$data['classid'].'</classid>'.PHP_EOL.
		tab().'</entry>'.PHP_EOL;
	}
	$xml .= '</dataset>'.PHP_EOL;
	
	$zip = new ZipArchive();
	$filename = sys_get_temp_dir().'/report.zip';
	if ($zip->open($filename, ZipArchive::CREATE)!==TRUE) {
		exit("cannot open <$filename>\n");
	}
	$zip->addFromString('report.csv', $csv);
	$zip->addFromString('report.xml', $xml);
	$zip->addFromString('report.json', json_encode($dataset));
	$zip->addFromString('report.serialized', serialize($dataset));
	$zip->close();
	
	$mail = new PHPMailer;
	$mail->setFrom(MAINTAINER_EMAIL, SITE_NAME);
	foreach ($targets AS $target)
		$mail->addBCC($target['email'], $target['name']);
	$mail->Subject = SITE_NAME.' Datafeed '.date('c');
	$mail->msgHTML('This is the requested datafeed informing you about additions within the last 24 hours');
	$mail->AddAttachment($filename, 'report.zip', 'base64', 'application/zip');
	$mail->send();
	
	unlink($filename);

	endprog();
?>
