Changeset 22769 for extensions/meta/admin

Timestamp:

May 20, 2013, 7:29:15 PM (11 years ago)

Author:

ddtddt

Message:

[extensions] - meta - add metadata personal on all public page

Location:

extensions/meta/admin

Files:

• admin.php (modified) (7 diffs)
• admin.tpl (modified) (1 diff)

extensions/meta/admin/admin.php

@@ -13 +13 @@
 //-------------------------------------------------------- sections definitions
 
-// Gestion des onglets
+// TAB gest
 if (!isset($_GET['tab']))
     $page['tab'] = 'gestion';
@@ -23 +23 @@
                l10n('meta_onglet_gestion'),
                $my_base_url.'&tab=gestion');
+$tabsheet->add('Personal Meta',
+               l10n('Personal Metadata'),
+               $my_base_url.'&tab=persometa');
 $tabsheet->add('description',
                l10n('meta_onglet_description'),
@@ -29 +32 @@
 $tabsheet->assign();
 
-// Onglet gestion des meta
+// Tab gest
 switch ($page['tab'])
 {
   case 'gestion':
 
-//charge la liste des meta
+//read metadata list
 $groups = array();
 $query = '
@@ -64 +67 @@
 
 
-//edit de meta
+//edit meta
 if (isset($_POST['submitchoixmeta']) and is_numeric($_POST['metalist']) and (!$_POST['metalist'])==0 and !is_adviser())
         {
@@ -90 +93 @@
         }
 
-//insértion de meta dans la table
-if (isset($_POST['submitinsmeta']) and !is_adviser())
+//inser metadata in table
+if (isset($_POST['submitinsmeta']))
         {
         $query = '
@@ -103 +106 @@
     break;
 
-// Onglet  description
+//description TAB
   case 'description':
 
@@ -113 +116 @@
           ));
         break;
+
+// TAB personnal metadata
+  case 'persometa':
+
+  $template->assign(
+        'metapersoT',
+        array(
+          'meta'=>l10n('meta_name'),
+          ));
+$admin_base_url = $my_base_url.'&tab=persometa';
+$metapersos = pwg_query("SELECT * FROM `". METAPERSO_TABLE .";");
+
+if (pwg_db_num_rows($metapersos)) {     
+ while ($metaperso = pwg_db_fetch_assoc($metapersos))
+        {
+    $items = array(
+      'METANAME' => $metaperso['metaname'],
+      'METAVAL' => $metaperso['metaval'],
+      'METATYPE' => $metaperso['metatype'],
+          'U_DELETE' => $admin_base_url.'&delete='.$metaperso['id'],
+      'U_EDIT' => $admin_base_url.'&edit='.$metaperso['id'],
+                );
+                
+        $template->append('metapersos', $items);
+        }
+}
+ if (isset($_POST['submitaddpersonalmeta']))
+        {
+          $template->assign(
+        'meta_edit2',
+        array(
+          'meta'=>l10n('meta_name'),
+          'METAID' => 0,
+          ));
+        }
+
+ if (isset($_POST['submitaddmetaperso']))
+        {
+                $query = '
+DELETE 
+  FROM ' . METAPERSO_TABLE . '
+  WHERE id = '.$_POST['invisibleID'].'
+  ;';
+$result = pwg_query($query);
+        
+        
+        $q = '
+INSERT INTO ' . $prefixeTable . 'metaperso(metaname,metaval,metatype)VALUES ("'.$_POST['insername'].'","'.$_POST['inserval'].'","'.$_POST['insertype'].'");';
+    pwg_query($q);
+        $_SESSION['page_infos'] = array(l10n('Personal metadata update'));
+        redirect($admin_base_url);  
+        }
+        
+          if (isset($_GET['edit']))
+  {
+    check_input_parameter('edit', $_GET, false, PATTERN_ID);
+
+                $query = '
+select id,metaname,metaval,metatype
+  FROM ' . METAPERSO_TABLE . '
+  WHERE id = \''.$_GET['edit'].'\'
+  ;';
+$result = pwg_query($query);
+$row = pwg_db_fetch_assoc($result);     
+  $template->assign(
+    'meta_edit2',
+    array(
+      'METAID' => $row['id'],
+          'METANAME' => $row['metaname'],
+      'METAVAL' => $row['metaval'],
+      'METATYPE' => $row['metatype'],
+      ));       
+        
+  }
+                
+        if (isset($_GET['delete']))
+{
+  check_input_parameter('delete', $_GET, false, PATTERN_ID);
+  
+  $query = '
+DELETE
+  FROM '.METAPERSO_TABLE.'
+  WHERE id = '.$_GET['delete'].'
+;';
+  pwg_query($query);
+ 
+  $_SESSION['page_infos'] = array(l10n('Personal metadata update'));
+  redirect($admin_base_url);
+}
+        
+        
+        break;
+
         
 } 

extensions/meta/admin/admin.tpl

@@ -54 +54 @@
         </div>
 {/if}
-{if isset ($MAJ)}
-        <div class="comment">
-                <div style="text-align:center;">
-                <input class="submit" name="submitMAJ" type="submit" value="{'meta_onglet_maj'|@translate}" {$TAG_INPUT_ENABLED} />
-                </div>  
-        </div>
+{if isset ($metapersoT)}
+                <form method="post" >
+                        <fieldset>
+                        <input class="submit" name="submitaddpersonalmeta" type="submit" value="{'Add Personal metadata'|@translate}" {$TAG_INPUT_ENABLED} />
+                        </fieldset>
+                </form>
+                <form method="post" >
+                        <fieldset>
+                                <legend>{'List Personal Metadata'|@translate}</legend>
+  {foreach from=$metapersos item=metaperso}
+          < meta {$metaperso.METATYPE}="{$metaperso.METANAME}" content="{$metaperso.METAVAL}">
+      <a href="{$metaperso.U_EDIT}">
+        <img src="{$ROOT_URL}{$themeconf.admin_icon_dir}/edit_s.png" alt="{'edit'|@translate}" title="{'edit'|@translate}" />
+      </a>
+      <a href="{$metaperso.U_DELETE}" onclick="return confirm( document.getElementById('btn_delete').title + '\n\n' + '{'Are you sure?'|@translate|@escape:'javascript'}');">
+        <img src="{$ROOT_URL}{$themeconf.admin_icon_dir}/delete.png" id="btn_delete" alt="{'delete'|@translate}" title="{'Delete'|@translate}" />
+      </a>
+        <br>
+  {/foreach}
+                        </fieldset>
+                </form>
+        {if isset ($meta_edit2)}
+                <form method="post" >
+                        <fieldset>
+                                <legend>{'Personnal metadata'|@translate}</legend>
+                                <input type="hidden" name="invisibleID" value="{$meta_edit2.METAID}">
+                                < meta <input type="text" name="insertype" value="{$meta_edit2.METATYPE}" size="30" maxlenght="30"> ="<input type="text" name="insername" value="{$meta_edit2.METANAME}" size="30" maxlenght="30">" content="<input type="text" name="inserval" value="{$meta_edit2.METAVAL}" size="60" maxlenght="100">">
+                                <br>    
+                                <br>
+                                        <div style="text-align:center;">
+                                        <input class="submit" name="submitaddmetaperso" type="submit" value="{'Submit'|@translate}" {$TAG_INPUT_ENABLED} />
+                                        </div>
+                        </fieldset>
+                </form>
+        {/if}
 {/if}