<?php
if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');

global $template, $page;

$piwecard = get_plugin_data($plugin_id);

$start =  (isset($_GET['start']) ? $_GET['start'] : 0);
// Verify if the previous action is delete the last ecard on a page, go to first page
if ($start != 0 and $piwecard->get_nb_ecard() == $piwecard->my_config['nb_ecard_page'])
	$start = 0;

if (isset($_GET['action'])) {
	switch ($_GET['action']) {
		case "delete" :
			$ecard_id = $_GET['id'];
			$piwecard->delete_ecard($ecard_id);
			redirect(ECARD_ADMIN . '-consult&amp;start='.$start);
			break;
		case "delall" :
			$piwecard->delete_allinvalid_ecard();
			redirect(ECARD_ADMIN . '-consult');
			break;
		default :
			break;
	}
}


//Create the navigation bar (for more than 1 page)
$consult_url = ECARD_ADMIN.'-consult';
$ecard_navbar = array();
$ecard_navbar = create_navigation_bar($consult_url, $piwecard->get_nb_ecard(), $start, $piwecard->my_config['nb_ecard_page']);

$query = 'SELECT * FROM '.ECARD_TABLE.' ORDER BY date_creation DESC LIMIT '.$start.','.$piwecard->my_config['nb_ecard_page'].';';
$result = pwg_query($query);

while($file = pwg_db_fetch_assoc($result)) {
	$ecard_url = embellish_url(get_absolute_root_url() . './index.php?/ecard/'.$file['id']);

	// Check if the ecard is valid 
	$valid = $piwecard->is_valid($file['id']);

	$template->append('ecard_file',array(
									'id'				=> $file['id'],
									'subject'			=> $file['subject'],
									'url' 				=> $ecard_url,
									'sender_name'  		=> $file['sender_name'],
									'sender_email'		=> $file['sender_email'],
									'recipient_name'	=> $file['recipient_name'],
									'recipient_email'	=> $file['recipient_email'],
									'date_creation' 	=> strftime('%d/%m/%y %H:%M', strtotime($file['date_creation'])),
									'date_validity'		=> (isset($file['date_validity'])) ? strftime('%d/%m/%y %H:%M', strtotime($file['date_validity'])) : l10n('ecard_nolimit'),
									'valid' 			=> $valid,
									'delete' 			=> $consult_url.'&amp;action=delete&amp;id='.$file['id'].'&amp;start='.$start,
	));
}

// Get the number of ecard (total & valid & invalid)
$template->assign('nb_ecard_valid', $piwecard->get_nb_valid_ecard());
$template->assign('nb_ecard', $piwecard->get_nb_ecard());

$template->assign('ecard_del_all', $consult_url.'&amp;action=delall' );
$template->assign('navbar', $ecard_navbar );

$template->set_filename('plugin_admin_consult', dirname(__FILE__) . '/template/admin_consult.tpl');
$template->assign_var_from_handle('ADMIN_CONTENT', 'plugin_admin_consult');
?>