Changeset 30638

Timestamp:

Dec 1, 2014, 10:50:24 PM (10 years ago)

Author:

ddtddt

Message:

[extensions] - Add info - add export to manage_info_photos

Location:

extensions/AddInfo/admin

Files:

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

extensions/AddInfo/admin/admin.php

@@ -39 +39 @@
           'meta'=>l10n('meta_name'),
           ));
+          
+        $exp = pwg_db_fetch_assoc(pwg_query("SELECT state FROM " . PLUGINS_TABLE . " WHERE id = 'manage_info_photos';"));
+        if($exp['state']=='active'){
+                $template->assign(
+                        'gestionC',
+                                array(
+                                 'meta'=>l10n('meta_name'),
+                ));
+        }       
+        if (isset($_POST['submitexpot'])){
+
+        $idinfo=pwg_db_fetch_assoc(pwg_query('SELECT id_info_pho FROM ' . ADD_INFO_PHOTO_TABLE . ' ORDER BY id_info_pho DESC LIMIT 1;'));       
+        $idinfo=$idinfo['id_info_pho'];
+        $idinfo1=$idinfo+1;$idinfo2=$idinfo+2;$idinfo3=$idinfo+3;
+        $q = 'INSERT INTO ' . $prefixeTable . 'Add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES ('.$idinfo1.',"infos1",'.$idinfo1.',0,1);';
+    pwg_query($q);
+        $q = 'INSERT INTO ' . $prefixeTable . 'Add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES ('.$idinfo2.',"infos2",'.$idinfo2.',0,1);';
+    pwg_query($q);
+        $q = 'INSERT INTO ' . $prefixeTable . 'Add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES ('.$idinfo3.',"infos3",'.$idinfo3.',0,1);';
+    pwg_query($q);
+        $query = 'SELECT * FROM ' . ADDINFO_TABLE . ';';
+        $result = pwg_query($query);
+        if (pwg_db_num_rows($result)) {
+                while ($info = pwg_db_fetch_assoc($result)){
+                        $q = 'INSERT INTO ' . $prefixeTable . 'add_Info_photos_data(id_img,id_info_pho,data)VALUES ('.$info['id'].','.$idinfo1.',"'.$info['info1'].'");';
+                        pwg_query($q);
+                        $q = 'INSERT INTO ' . $prefixeTable . 'add_Info_photos_data(id_img,id_info_pho,data)VALUES ('.$info['id'].','.$idinfo2.',"'.$info['info2'].'");';
+                        pwg_query($q);
+                        $q = 'INSERT INTO ' . $prefixeTable . 'add_Info_photos_data(id_img,id_info_pho,data)VALUES ('.$info['id'].','.$idinfo3.',"'.$info['info3'].'");';
+                        pwg_query($q);
+
+                }
+        }
+        array_push($page['infos'], l10n('export is ok'));
+
+  
+
+        
+        }  
+          
   
         break;

extensions/AddInfo/admin/admin.tpl

@@ -12 +12 @@
                         {'addinfo_explication_update non_help'|@translate}
         </div>
+{/if}
+{if isset ($gestionC)}
+        <form method="post" >
+                <fieldset>
+                        <legend>{'Export infos to manage info photo'|@translate}</legend>
+                        <input class="submit" name="submitexpot" type="submit" value="{'Export'|@translate}">
+                </fieldset>
+        </form>
 {/if}
 {if isset ($gestionA)}