Changeset 19956 for extensions/Piwecard/admin/admin_consult.php

Timestamp:

Jan 7, 2013, 10:26:35 PM (11 years ago)

Author:

julien1311

Message:

[piwecard] various improvements

File:

• extensions/Piwecard/admin/admin_consult.php (modified) (2 diffs)

extensions/Piwecard/admin/admin_consult.php

@@ -12 +12 @@
 
 if (isset($_GET['action'])) {
-        $action = $_GET['action'];
-        // delete one ecard
-        if ($action == "delete") {
-                $ecard_id = $_GET['id'];
-                $ecard->delete_ecard($ecard_id, isset($_GET['force']));
-                redirect(ECARD_ADMIN . '-consult&start='.$start);
-        } elseif ($action == "delall") {        // delete all unvalid
-                $ecard->delete_allinvalid_ecard();
-                redirect(ECARD_ADMIN . '-consult');
+        switch ($_GET['action']) {
+                case "delete" :
+                        $ecard_id = $_GET['id'];
+                        $ecard->delete_ecard($ecard_id);
+                        redirect(ECARD_ADMIN . '-consult&start='.$start);
+                        break;
+                case "delall" :
+                        $ecard->delete_allinvalid_ecard();
+                        redirect(ECARD_ADMIN . '-consult');
+                        break;
+                default :
+                        break;
         }
-} 
+}
+
 
 //Create the navigation bar (for more than 1 page)
@@ -29 +33 @@
 $ecard_navbar = create_navigation_bar($consult_url, $ecard->get_nb_ecard(), $start, $ecard->my_config['nb_ecard_page']);
 
-$query = 'SELECT * FROM '.ECARD_TABLE.' ORDER BY date DESC LIMIT '.$start.','.$ecard->my_config['nb_ecard_page'].';';
+$query = 'SELECT * FROM '.ECARD_TABLE.' ORDER BY date_creation DESC LIMIT '.$start.','.$ecard->my_config['nb_ecard_page'].';';
 $result = pwg_query($query);
 
 while($file = mysql_fetch_assoc($result)) {
-        $ecard_url = embellish_url(get_absolute_root_url() . './index.php?/ecard/'.$file['numero']);
+        $ecard_url = embellish_url(get_absolute_root_url() . './index.php?/ecard/'.$file['id']);
 
         // Check if the ecard is valid 
-        if ($ecard->is_valid($file['numero']))  
-                $actif = true;
-        else 
-                $actif = false;
+        $valid = $ecard->is_valid($file['id']);
 
         $template->append('ecard_file',array(
-                                                                        'ID'                            => $file['numero'],
-                                                                        'SUJET'                         => $file['sujet'],
-                                                                        'LINK'                          => $ecard_url,
-                                                                        'FROM'                          => $file['nomexp'],
-                                                                        'FROMMAIL'                      => $file['adrexp'],
-                                                                        'TO'                            => $file['nomdest'],
-                                                                        'TOMAIL'                        => $file['adrdest'],
-                                                                        'DATE'                          => $file['date'],
-                                                                        'VALID'                         => $actif,
-                                                                        'ECARD_DELETE'          => $consult_url.'&action=delete&id='.$file['numero'].'&start='.$start,
-                                                                        'ECARD_DELETE_ADM'      => $consult_url.'&action=delete&id='.$file['numero'].'&force&start='.$start,
+                                                                        '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.'&action=delete&id='.$file['id'].'&start='.$start,
         ));
 }
 
 // Get the number of ecard (total & valid & invalid)
-$template->assign('NBECARDVALID', $ecard->get_nb_valid_ecard());
-$template->assign('NBECARD', $ecard->get_nb_ecard());
+$template->assign('nb_ecard_valid', $ecard->get_nb_valid_ecard());
+$template->assign('nb_ecard', $ecard->get_nb_ecard());
 
 $template->assign('ecard_del_all', $consult_url.'&action=delall' );