source: extensions/Piwecard/admin/consult.php @ 8771

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

global $template, $page;
 
 
$me = 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 $me->get_nb_ecard() == $me->my_config['nb_ecard_page']
        )
        $start = 0 ;

if (isset($_GET['action']))
{
        $action = $_GET['action'];
        // delete one unvalid
        if ($action == "delete")
        {
                $ecard_id = $_GET['id'];
                $me->delete_ecard($ecard_id, isset($_GET['force']));
                redirect( PHPWG_ROOT_PATH . 'admin.php?page=plugin&amp;section=' . ECARD_DIR . '%2Fadmin%2Fadmin.php&amp;tab=consult&amp;start='.$start);

        }
        elseif ($action == "delall")    // delete all unvalid
        {
                $me->delete_allinvalid_ecard();
                redirect( PHPWG_ROOT_PATH . 'admin.php?page=plugin&amp;section=' . ECARD_DIR . '%2Fadmin%2Fadmin.php&amp;tab=consult');
        }
} 



// Create the navigation bar (for more than 1 page)
$url = PHPWG_ROOT_PATH . 'admin.php?page=plugin&amp;section=' . ECARD_DIR . '%2Fadmin%2Fadmin.php&amp;tab=consult';
//PHPWG_ROOT_PATH  . 'admin.php?page=plugin&amp;section='       . ECARD_DIR . '%2Fadmin%2Fconsult.php';
$ecard_navbar = array();
$ecard_navbar =  create_navigation_bar(
  $url, $me->get_nb_ecard(), $start, $me->my_config['nb_ecard_page']);

$query = 'SELECT * FROM '.ECARD_TABLE
                . ' ORDER BY date DESC'
                . ' LIMIT '.$start.','.$me->my_config['nb_ecard_page']
                .';';
$result = pwg_query($query);
//$tableau = mysql_fetch_assoc($result);


while($file = mysql_fetch_assoc($result))
{
//      echo "numero=".$file['numero'];
        $chemin = embellish_url(get_absolute_root_url() . './index.php?/ecard/'.$file['numero']);

        if ($me->debug)
        {
                echo "date = ".date("Y-m-d H:m:s");
                echo " / date file = ".$file['date'];
                echo " / config= ".$me->my_config['activ'];
                echo " / Nbjours = ".$me->NbJours($file['date'], date("Y-m-d H:m:s"));
        }

        // Check if the ecard is valid 
        
        if ($me->is_valid($file['numero']))     
                $actif = true;
        else 
                $actif = false;
                
        
        /*
        if ($me->my_config['activ'] == 0)       // unlimited
                $actif = true;
        elseif ($me->NbJours($file['date'], date("Y-m-d H:m:s")) > $me->my_config['activ'])             // during the validate time
                $actif = false;
        else 
                $actif = true;
        */
        

        $template->append('FILE',array( 'ID'    => $file['numero'],
                                                                        'SUJET' => $file['sujet'],
                                                                    'LINK'      => $chemin,
                                                                        'FROM'          => $file['nomexp'],
                                                                        'FROMMAIL'=> $file['adrexp'],
                                                                        'TO'    => $file['nomdest'],
                                                                        'TOMAIL' => $file['adrdest'],
                                                                        'DATE' => $file['date'],
                                                                        'VALID' => $actif,
                                                                        'ECARD_DELETE' => PHPWG_ROOT_PATH . 'admin.php?page=plugin&amp;section=' . ECARD_DIR . '%2Fadmin%2Fconsult.php&amp;action=delete&amp;id='.$file['numero'].'&amp;start='.$start,
                                                                        'ECARD_DELETE_ADM' => PHPWG_ROOT_PATH . 'admin.php?page=plugin&amp;section=' . ECARD_DIR . '%2Fadmin%2Fconsult.php&amp;action=delete&amp;id='.$file['numero'].'&amp;force&amp;start='.$start,

                                                                        
                                                                        
                                        ));
}

// Get the number of ecard (total & valid & invalid)
$template->assign( 'NBECARDVALID', $me->get_nb_valid_ecard());
$template->assign( 'NBECARD', $me->get_nb_ecard());


$template->assign( 'DELALL', PHPWG_ROOT_PATH . 'admin.php?page=plugin&amp;section=' . ECARD_DIR . '%2Fadmin%2Fconsult.php&amp;action=delall&amp' );
$template->assign( 'navbar', $ecard_navbar );

$template->set_filename('plugin_admin_content', dirname(__FILE__) . '/template/consult.tpl');
$template->assign_var_from_handle('ADMIN_CONTENT', 'plugin_admin_content');



?>