Jump to content

zemacse

Members
 View Profile  See their activity

  • Posts

    5

  • Joined

  • Last visited

Profile Information

  • Location
    Lyon
  • Activity
    Developer

zemacse's Achievements

Newbie

Newbie (1/14)

1

Reputation

  1. zemacse
    merci infiniment pepitoww, effectivement je pouvais pas trouver la solution si mes test était mal construit ^^ je vais continuer de chercher un moyen de remplir ce pointeur.
  2. zemacse
    Bonjour à tous, j'utilise la fonction PHP fopen() afin d'extraire des données d'un fichier csv, seulement cela ne marche pas et j'aimerais savoir si quelqu'un avait connaissance d'un test me permettant de véréfier que mon pointeur pointe bien vers mon fichier. J'ai effectué le test suivant : FILE* $fp = NULL; $fp = fopen('C:\Users\Philippe\Downloads'.$_POST['fichier'], 'r'); if ($fp = NULL) { echo"echoue"; } else if($fp != NULL) { echo"success"; } il n'affiche rien et impossible de faire marcher la fonction fgetcsv() donc si mon pointeur ne contient ni la valeur "NULL" ni mon fichier, que contient il? Si j'effectue le test suivant : FILE* $fp = NULL; $fp = fopen('C:\Users\Philippe\Downloads'.$_POST['fichier'], 'r'); if ($fp = NULL) { echo"echoue"; } else { echo"success"; } Il m'affiche "success" Voici la suite de monde code pour ceux que sa interesserai : if(isset($_POST['fichier'])) { FILE* $fp = NULL; $fp = fopen('C:\Users\Philippe\Downloads'.$_POST['fichier'], 'r'); if ($fp = NULL) { echo"echoue"; } else { echo"success"; } while ($data = fgetcsv($fp, 1000, ";")) { $num = count($data); for ($c=0; $c < $num; $c++) { echo $data[$c] . "<br />\n"; $insert += $data[$c].", "; if($num = $c) { $test = true; } } } fclose($fp); } En vous remerciant d'avance de l'attention accordé à mon problême.
  3. zemacse
    hi everybody! I'v to create a module wich insert in a csv file, exported data (in that case my product) from an sql query. The problem is that my brand new csv file (excel file) is full of html code and isn't implemented by my query's data. here my code : <?php class exportDeclinaison extends Module { function __construct() { global $cookie; $this->_cookie = $cookie; $this->name = 'exportDeclinaison'; $this->tab = 'front_office_features'; $this->version = '1.0'; parent::__construct(); $this->displayName = $this->l('Export Declinaison'); $this->description = $this->l('Export your products and declinaisons in TXT or CSV file.'); } function install() { if (!parent::install()) return false; return true; } public function uninstall() { if (!parent::uninstall()) return false; return true; } function getContent() { if(!isset($_POST['produit'])){ echo'Choisissez la cat&eacutegorie de produit d&eacutesir&eacutee :'; //__________Liste categorie echo"<form action='#' method='POST'>"; echo "<select name='category' onchange='javascript:submit(this)'>"; mysql_connect("localhost","root","root"); mysql_select_db("c1_ks"); $res = mysql_query("SELECT * FROM ps_category_lang ORDER BY id_category"); while($cat = mysql_fetch_assoc($res)){ echo "<option value='".$cat["id_category"]."'>".$cat["name"]."</option>"; } echo"</select>"; echo"</form>"; } //__________Fin liste categorie //__________Liste prod if(isset($_POST['category'])){ echo"<form action='#' method='POST'>"; echo "<select name='produit' onchange='javascript:submit(this)'>"; mysql_connect("localhost","root","root"); mysql_select_db("c1_ks"); $res = mysql_query('SELECT p.* , pl.* , m.name AS manufacturer_name, s.name AS supplier_name, t.rate, sp.reduction, sp.reduction_type, sp.from, sp.to FROM ps_product AS p LEFT JOIN ps_category_product AS cp ON p.id_product = cp.id_product LEFT JOIN ps_category_lang AS cl ON cl.id_category = cp.id_category LEFT JOIN ps_product_lang AS pl ON p.id_product = pl.id_product LEFT JOIN ps_manufacturer AS m ON p.id_manufacturer = m.id_manufacturer LEFT JOIN ps_supplier AS s ON p.id_supplier = s.id_supplier LEFT JOIN ps_tax AS t ON p.id_tax_rules_group = t.id_tax LEFT JOIN ps_specific_price AS sp ON p.id_product = sp.id_product WHERE cp.id_category ="'.$_POST['category'].'"order by cp.id_product'); while($prod = mysql_fetch_assoc($res)){ echo "<option value='".$prod["id_product"]."'>".$prod["name"]."</option>"; } echo "</select>"; } if (isset($_POST['produit'])){ // la variable qui va contenir les données CSV $fputcsv = ''; // Nom du fichier final $fileName = 'export-csv.csv'; $req= mysql_query('SELECT cat.* FROM ps_category AS cat'); if(mysql_num_rows($req) > 0) { $i = 0; while($Row = mysql_fetch_assoc($req)) { $i++; // Si c'est la 1er boucle, on affiche le nom des champs pour avoir un titre pour chaque colonne if($i == 1) { foreach($Row as $clef => $valeur) $fputcsv .= trim($clef).';'; $fputcsv = rtrim($fputcsv, ';'); $fputcsv .= "\n"; } // On parcours $Row et on ajoute chaque valeur à cette ligne foreach($Row as $clef => $valeur) $fputcsv .= trim($valeur).';'; // Suppression du ; qui traine à la fin $fputcsv = rtrim($fputcsv, ';'); // Saut de ligne $fputcsv .= "\n"; } } else exit('Aucune donnée à enregistrer.'); // Entêtes (headers) PHP qui vont bien pour la création d'un fichier Excel CSV header("Content-disposition: attachment; filename=".$fileName); header("Content-Type: application/force-download"); header("Content-Transfer-Encoding: application/text/csv\n"); header("Pragma: no-cache"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0, public"); header("Expires: 0"); echo $fputcsv; exit(); } //__________Fin liste prod } } ?> and here my csv's content : <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr"> " <head>" " <meta http-equiv=""Content-Type"" content=""application/xhtml+xml" " <meta name=""robots"" content=""NOFOLLOW, NOINDEX"" />" " <link type=""text/css"" rel=""stylesheet"" href=""/js/jquery/datepicker/datepicker.css"" />" " <link type=""text/css"" rel=""stylesheet"" href=""/css/admin.css"" />" " <link type=""text/css"" rel=""stylesheet"" href=""/css/jquery.cluetip.css"" />" " <link type=""text/css"" rel=""stylesheet"" href=""themes/flashyturtle/admin.css"" />" " <title>PrestaShop&trade" " <script type=""text/javascript"">" " var helpboxes = 1" " var roundMode = 2" " </script>" " <script type=""text/javascript"" src=""/js/jquery/jquery.min.js""></script>" " <script type=""text/javascript"" src=""/js/jquery/jquery.hoverIntent.minified.js""></script>" " <script type=""text/javascript"" src=""/js/jquery/jquery.cluetip.js""></script>" " <script type=""text/javascript"" src=""/js/admin.js""></script>" " <script type=""text/javascript"" src=""/js/toggle.js""></script>" " <script type=""text/javascript"" src=""/js/tools.js""></script>" " <link rel=""shortcut icon"" href=""/img/favicon.ico"" />" " " " <!--[if IE]>" " <link type=""text/css"" rel=""stylesheet"" href=""/css/admin-ie.css"" />" " <![endif]-->" " <style type=""text/css"">" " div#header_infos, div#header_infos a#header_shopname, div#header_infos a#header_logout, div#header_infos a#header_foaccess {" " color:#383838" " }" " </style>" " </head>" " <body >" " <script>" " var choose_language_trad = ""Choisissez une langue""" " </script>" " <div id=""top_container"">" " <div id=""container"">" " <div id=""header_infos""><span>" " <a id=""header_shopname"" href=""index.php""><span>KS Motorcycles</span></a><br />" " F.&nbsp" " [ <a href=""index.php?logout"" id=""header_logout""><span>déconnexion</span></a> ]" " - <a href=""/"" id=""header_foaccess"" target=""_blank"" title=""Voir mon magasin""><span>Voir mon magasin</span></a>" " - <a href=""index.php?tab=AdminEmployees&id_employee=12&updateemployee&token=3f6c780568d15bf3b2ab7eba859afe3c"" style=""font-size: 10px" " </span></div>" " <div id=""header_search"">" " <form method=""post"" action=""index.php?tab=AdminSearch&token=b0727016d10a7a3f2b2d208ab8e488cf"">" " <input type=""text"" name=""bo_query"" id=""bo_query""" " value=""""" " />" " <select name=""bo_search_type"" id=""bo_search_type"">" " <option value=""0"">tout</option>" " <option value=""1"" >catalogue</option>" " <option value=""2"" >clients</option>" " <option value=""6"" >adresse ip</option>" " <option value=""3"" >commandes</option>" " <option value=""4"" >factures</option>" " <option value=""5"" >paniers</option>" " </select>" " <input type=""submit"" id=""bo_search_submit"" class=""button"" value=""Recherche""/>" " </form>" " </div>" " <div id=""header_quick"">" " <script type=""text/javascript"">" " function quickSelect(elt)" " {" " var eltVal = $(elt).val()" " if (eltVal == ""0"") return false" " else if (eltVal.substr(eltVal.length - 6) == ""_blank"") window.open(eltVal.substr(0, eltVal.length - 6), ""_blank"")" " else location.href = eltVal" " }" " </script>" " <select onchange=""quickSelect(this)" " <option value=""0"">Accès rapide</option><option value=""index.php"">&gt" " </div>" " <div class=""flatclear"">&nbsp" " <a href=""index.php?tab=AdminCatalog&token=843b8197b08ba10d165c51bd6a0faeb4"">" " <img src=""/img/t/AdminCatalog.gif"" alt="""" /> Catalogue" " </a>" " </li><li class=""submenu_size "" id=""maintab2"">" " <a href=""index.php?tab=AdminCustomers&token=bc2504c7ef458aadad5ecff721c3e23c"">" " <img src=""/img/t/AdminCustomers.gif"" alt="""" /> Clients" " </a>" " </li><li class=""submenu_size "" id=""maintab3"">" " <a href=""index.php?tab=AdminOrders&token=59cb173171d0d3dee1c8b08d022cb025"">" " <img src=""/img/t/AdminOrders.gif"" alt="""" /> Commandes" " </a>" " </li><li class=""submenu_size "" id=""maintab4"">" " <a href=""index.php?tab=AdminPayment&token=38c2ad9073d29e84e30176c9c4fe462d"">" " <img src=""/img/t/AdminPayment.gif"" alt="""" /> Paiement" " </a>" " </li><li class=""submenu_size "" id=""maintab5"">" " <a href=""index.php?tab=AdminShipping&token=dfc82a41d4e3927810e67f786185a533"">" " <img src=""/img/t/AdminShipping.gif"" alt="""" /> Transport" " </a>" " </li><li class=""submenu_size "" id=""maintab6"">" " <a href=""index.php?tab=AdminStats&token=54259ac1c2e43749100e327107f13127"">" " <img src=""/img/t/AdminStats.gif"" alt="""" /> Stats" " </a>" " </li><li class=""submenu_size active"" id=""maintab7"">" " <a href=""index.php?tab=AdminModules&token=62b0fc62be3a5d7599cb5b531fee4f86"">" " <img src=""/img/t/AdminModules.gif"" alt="""" /> Modules" " </a>" " </li><li class=""submenu_size "" id=""maintab29"">" " <a href=""index.php?tab=AdminEmployees&token=3f6c780568d15bf3b2ab7eba859afe3c"">" " <img src=""/img/t/AdminEmployees.gif"" alt="""" /> Employés" " </a>" " </li><li class=""submenu_size "" id=""maintab8"">" " <a href=""index.php?tab=AdminPreferences&token=7bb9a099e4a1c3110daf92300668a374"">" " <img src=""/img/t/AdminPreferences.gif"" alt="""" /> Préférences" " </a>" " </li><li class=""submenu_size "" id=""maintab9"">" " <a href=""index.php?tab=AdminTools&token=cec28aa16eec991a7ea89c380612b8b9"">" " <img src=""/img/t/AdminTools.gif"" alt="""" /> Outils" " </a>" " </li> </ul><div id=""tab1_subtabs"" style=""display:none""><li><a href=""index.php?tab=AdminTracking&token=9f6a4bdb16b18c12db4af07fbc11ec87"">Suivi</a></li><li><a href=""index.php?tab=AdminManufacturers&token=741a6940440db5d47ae4b4d37ce37ac2"">Fabricants</a></li><li><a href=""index.php?tab=AdminSuppliers&token=14c0a3af54b4de2e5a37090c3992ae35"">Fournisseurs</a></li><li><a href=""index.php?tab=AdminAttributesGroups&token=217c16574d3bec59573a251c27800856"">Attributs et groupes</a></li><li><a href=""index.php?tab=AdminFeatures&token=377e29d6393d55b6694a7a8eb908a526"">Caractéristiques</a></li><li><a href=""index.php?tab=AdminScenes&token=74cdd5bd2184f4a82957ad95a7df08fd"">Scènes</a></li><li><a href=""index.php?tab=AdminTags&token=8f4a2dd17eac8471b26643493b1563b3"">Tags</a></li><li><a href=""index.php?tab=AdminAttachments&token=58c2ee13ba23a2cb40b5bb73d2a4f49b"">Documents joints</a></li><li><a href=""index.php?tab=AdminStockMvt&token=a5cad4d6954c16d6164075bb13eab781"">Mouvements de Stock</a></li><li><a href=""index.php?tab=AdminMiscEdit&token=65d82507b992df83767f0ed8c9b675dd"">Edition en liste des produits</a></li></div><div id=""tab2_subtabs"" style=""display:none""><li><a href=""index.php?tab=AdminAddresses&token=08837a46c8301912b8908bab340d55db"">Adresses</a></li><li><a href=""index.php?tab=AdminGroups&token=b9ce42a4ba5a3bfc3f7402cabfe25010"">Groupes</a></li><li><a href=""index.php?tab=AdminCarts&token=7f100d48f250e4bc0b1d40dee622e7a0"">Paniers</a></li><li><a href=""index.php?tab=AdminSuperUser&token=413775d974fac3e4e3d443cd2dcb8b42"">SuperUtilisateur</a></li></div><div id=""tab3_subtabs"" style=""display:none""><li><a href=""index.php?tab=AdminInvoices&token=f91da142bdd458b032f655b264f55c65"">Factures</a></li><li><a href=""index.php?tab=AdminDeliverySlip&token=7d48f66c5e903c97b22cb4628df67587"">Bons de livraison</a></li><li><a href=""index.php?tab=AdminReturn&token=7043fb834a7b997c0b8ea43fc67f7273"">Retours produits</a></li><li><a href=""index.php?tab=AdminSlip&token=a38292a79b89c4a82485fb34f777b7fa"">Avoirs</a></li><li><a href=""index.php?tab=AdminMessages&token=195551945731c945a61154cd49392aee"">Messages clients</a></li><li><a href=""index.php?tab=AdminStatuses&token=3157f391fbeb5c03dd489c2d2dda793b"">Statuts</a></li><li><a href=""index.php?tab=AdminOrderMessage&token=9e7513a1b7b6ffe0138a84f495bf6da0"">Messages prédéfinis</a></li><li><a href=""index.php?tab=AdminPDF&token=203f4c8c3eadcd0745edadd9ac86186e"">PDF</a></li><li><a href=""index.php?tab=AdminMondialRelay&token=84067e9d7c44b171f6073e8130bf8169"">Mondial Relay</a></li></div><div id=""tab4_subtabs"" style=""display:none""><li><a href=""index.php?tab=AdminCurrencies&token=b2d84a512b153610a561465d37fcb710"">Devises</a></li><li><a href=""index.php?tab=AdminTaxes&token=296f336b7766ef93adad30a794a76fe8"">Taxes</a></li><li><a href=""index.php?tab=AdminTaxRulesGroup&token=3e2c5ec046bcb1672fad92f2494db9ee"">Règles de taxes</a></li><li><a href=""index.php?tab=AdminDiscounts&token=2869c03df4df9aadd871f31f3197dcb5"">Bons de réduction</a></li></div><div id=""tab5_subtabs"" style=""display:none""><li><a href=""index.php?tab=AdminCarriers&token=a3835a7ed5faced6739021348e2cd7ca"">Transporteurs</a></li><li><a href=""index.php?tab=AdminStates&token=2e21bcba49cfb7c68c5c5ad112633eba"">Etats</a></li><li><a href=""index.php?tab=AdminCountries&token=ab90fd378a4396ce86789d7ddc4ec376"">Pays</a></li><li><a href=""index.php?tab=AdminCounty&token=c5f87bdd168c8bd4468ebcd15b625e1f"">Comtés</a></li><li><a href=""index.php?tab=AdminZones&token=efd72a88885391be568f60fb60d0e34f"">Zones</a></li><li><a href=""index.php?tab=AdminRangePrice&token=9c3ba029e17395f9a1259b7c361aca6c"">Tranches de prix</a></li><li><a href=""index.php?tab=AdminRangeWeight&token=c27264d826161788a86c64950c934e15"">Tranches de poids</a></li></div><div id=""tab6_subtabs"" style=""display:none""><li><a href=""index.php?tab=AdminStatsConf&token=15a159c9b764e353a534be6281c6f125"">Configuration</a></li><li><a href=""index.php?tab=AdminSearchEngines&token=f7e5cbc956b63cfde731ef470593f815"">Moteurs de recherche</a></li><li><a href=""index.php?tab=AdminReferrers&token=66a69ca7717dc1c2d2647b98d015befa"">Sites affluents</a></li></div><div id=""tab7_subtabs"" style=""display:none""><li><a href=""index.php?tab=AdminAddonsCatalog&token=9b3d1605d1dbb04eb5f888c93526cdc9"">Catalogue de modules et thèmes</a></li><li><a href=""index.php?tab=AdminAddonsMyAccount&token=5348c414a7b0228487844a6607639fe6"">Mon compte</a></li><li><a href=""index.php?tab=AdminThemes&token=fe751a7e73f7818527f1463c56897513"">Thèmes</a></li><li><a href=""index.php?tab=AdminModulesPositions&token=5173c2ac020f20c2a51f0c8ea024894a"">Positions</a></li></div><div id=""tab29_subtabs"" style=""display:none""><li><a href=""index.php?tab=AdminProfiles&token=5ee00712e6b2841ea9fe721927fa940f"">Profils</a></li><li><a href=""index.php?tab=AdminAccess&token=177a0bb09309da9a78a26d0846609301"">Permissions</a></li><li><a href=""index.php?tab=AdminTabs&token=88e5cceb79edad047bad7a917afa583f"">Onglets</a></li><li><a href=""index.php?tab=AdminContacts&token=628b7861e16d834a8940887f74bf2de0"">Contacts</a></li><li><a href=""index.php?tab=AdminCustomerThreads&token=dd38f841c80cf680e95990fbd1e2bf18"">SAV</a></li></div><div id=""tab8_subtabs"" style=""display:none""><li><a href=""index.php?tab=AdminContact&token=10edd973a15155bf5ef3a8e8a150cf33"">Coordonnées</a></li><li><a href=""index.php?tab=AdminAppearance&token=4a838f58b95a3793375394f199c14c10"">Apparence</a></li><li><a href=""index.php?tab=AdminMeta&token=938d02ef5e4020fecd472fb5305a1e07"">SEO & URLs</a></li><li><a href=""index.php?tab=AdminPPreferences&token=53082108b42a90802838daf076721e2e"">Produits</a></li><li><a href=""index.php?tab=AdminAliases&token=ca637d45223898fd1276a997371ccd28"">Alias</a></li><li><a href=""index.php?tab=AdminEmails&token=7f4c34d53ec7894842a760ee375a9d76"">Emails</a></li><li><a href=""index.php?tab=AdminImages&token=a28e30ba6d3ec76c6447eb324b1b1d13"">Images</a></li><li><a href=""index.php?tab=AdminDb&token=6fd6b0d0e2bf994fff52562eef0160e4"">Base de données</a></li><li><a href=""index.php?tab=AdminLocalization&token=f39cc01003d71ac7de32a163a8f0673b"">Localisation</a></li><li><a href=""index.php?tab=AdminSearchConf&token=4d4248340704367dc0051098aad9b3e0"">Recherche</a></li><li><a href=""index.php?tab=AdminPerformance&token=33db2146c30c81a5070346dec26b98e9"">Performances</a></li><li><a href=""index.php?tab=AdminGeolocation&token=b06f26c61226a16b339f0cc92a51bebf"">Géolocalisation</a></li></div><div id=""tab9_subtabs"" style=""display:none""><li><a href=""index.php?tab=AdminLanguages&token=0df22b35e1c32fef65114851d19a613d"">Langues</a></li><li><a href=""index.php?tab=AdminTranslations&token=07c8c70b18840c1e41926f4b0535c0cf"">Traductions</a></li><li><a href=""index.php?tab=AdminQuickAccesses&token=85b585540a4ff39a553c08b31dd34b48"">Accès rapide</a></li><li><a href=""index.php?tab=AdminImport&token=e0c701c158c4e8690e575ad5e4c35215"">Import</a></li><li><a href=""index.php?tab=AdminSubDomains&token=19698ec1cc95d98c96e3a26c8433e14b"">Sous domaines</a></li><li><a href=""index.php?tab=AdminBackup&token=b3250f62be8ebeb5b932cace47a6cc0b"">Sauvegarde BDD</a></li><li><a href=""index.php?tab=AdminCMSContent&token=de17a704a1e2a30dfa8ce839acfbef14"">CMS</a></li><li><a href=""index.php?tab=AdminGenerator&token=cbe1d968c57526afc84525502f5fbfb1"">Générateurs</a></li><li><a href=""index.php?tab=AdminInformation&token=a251fc578d9b7fc2dc299ff767ff95bb"">Informations</a></li><li><a href=""index.php?tab=AdminStores&token=e226404ccd950589ea166f33738ad857"">Magasins</a></li><li><a href=""index.php?tab=AdminWebservice&token=fc039012bc7cf0e364e302be4b3c3042"">Service web</a></li><li><a href=""index.php?tab=AdminLogs&token=27ff1c798dc5b0525e9d5826ec344bbd"">Log</a></li><li><a href=""index.php?tab=AdminSelfUpgrade&token=88324186e711ac05936d00dd7d5f246a"">1-Click Upgrade</a></li></div> <ul id=""submenu"" class=""withLeftBorder clearfix""><li><a href=""index.php?tab=AdminAddonsCatalog&token=9b3d1605d1dbb04eb5f888c93526cdc9"">Catalogue de modules et thèmes</a></li><li><a href=""index.php?tab=AdminAddonsMyAccount&token=5348c414a7b0228487844a6607639fe6"">Mon compte</a></li><li><a href=""index.php?tab=AdminThemes&token=fe751a7e73f7818527f1463c56897513"">Thèmes</a></li><li><a href=""index.php?tab=AdminModulesPositions&token=5173c2ac020f20c2a51f0c8ea024894a"">Positions</a></li></ul>" " <div id=""main"">" " <div id=""content"">" " <script type=""text/javascript"">" " $(document).ready(function(){" " $.ajax({" " type : ""POST""," " url: ""ajax.php""," " data:{" " ""helpAccess"":""1""," " ""item"":""AdminModules""," " ""isoUser"":""fr""," " ""country"":""FR""," " ""version"":""1.4.9""" " }," " async : true," " success: function(msg) {" " $(""#help-button"").html(msg)" " $(""#help-button"").fadeIn(""slow"")" " }" " })" " })" " <div id=""help-button"" class=""floatr"" style=""display: none" " <img src=""../img/admin/separator_breadcrum.png"" style=""margin-right:5px"" alt=""&gt" " <div style=""float:left" " <a href=""http://www.prestashop.com/"" target=""_blank"" style=""font-weight:700" " <span style=""font-size:10px"">Temps de chargement : 0.135s</span>" " </div>" " <div style=""float:right" " | <a href=""http://forge.prestashop.com"" target=""_blank"" class=""footer_link"">Bug Tracker</a>" " | <a href=""http://www.prestashop.com/forums/"" target=""_blank"" class=""footer_link"">Forum</a> " " </div>" " </div>" " </div>" " </div>" " </body>" </html> </html> I would like to now why my csv file is full of html content and not whith my datas and thanks you to help me if you've ever seen this problem before
  4. zemacse
    Voici le contenu de mon fichier excel (.csv) créé et téléchargé par le module : ------------------------------------------------------------------------------------------------------------- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr"> <head> <meta http-equiv="Content-Type" content="application/xhtml+xml <meta name="robots" content="NOFOLLOW, NOINDEX" /> <link type="text/css" rel="stylesheet" href="/js/jquery/datepicker/datepicker.css" /> <link type="text/css" rel="stylesheet" href="/css/admin.css" /> <link type="text/css" rel="stylesheet" href="/css/jquery.cluetip.css" /> <link type="text/css" rel="stylesheet" href="themes/flashyturtle/admin.css" /> <title>PrestaShop&trade <script type="text/javascript"> var helpboxes = 1 var roundMode = 2 </script> <script type="text/javascript" src="/js/jquery/jquery.min.js"></script> <script type="text/javascript" src="/js/jquery/jquery.hoverIntent.minified.js"></script> <script type="text/javascript" src="/js/jquery/jquery.cluetip.js"></script> <script type="text/javascript" src="/js/admin.js"></script> <script type="text/javascript" src="/js/toggle.js"></script> <script type="text/javascript" src="/js/tools.js"></script> <link rel="shortcut icon" href="/img/favicon.ico" /> <!--[if IE]> <link type="text/css" rel="stylesheet" href="/css/admin-ie.css" /> <![endif]--> <style type="text/css"> div#header_infos, div#header_infos a#header_shopname, div#header_infos a#header_logout, div#header_infos a#header_foaccess { color:#383838 } </style> </head> <body > <script> var choose_language_trad = "Choisissez une langue" </script> <div id="top_container"> <div id="container"> <div id="header_infos"><span> <a id="header_shopname" href="index.php"><span>KS Motorcycles</span></a> F.&nbsp [ <a href="index.php?logout" id="header_logout"><span>déconnexion</span></a> ] - <a href="/" id="header_foaccess" target="_blank" title="Voir mon magasin"><span>Voir mon magasin</span></a> - <a href="index.php?tab=AdminEmployees&id_employee=12&updateemployee&token=3f6c780568d15bf3b2ab7eba859afe3c" style="font-size: 10px </span></div> <div id="header_search"> <form method="post" action="index.php?tab=AdminSearch&token=b0727016d10a7a3f2b2d208ab8e488cf"> <input type="text" name="bo_query" id="bo_query" value="" /> <select name="bo_search_type" id="bo_search_type"> <option value="0">tout</option> <option value="1" >catalogue</option> <option value="2" >clients</option> <option value="6" >adresse ip</option> <option value="3" >commandes</option> <option value="4" >factures</option> <option value="5" >paniers</option> </select> <input type="submit" id="bo_search_submit" class="button" value="Recherche"/> </form> </div> <div id="header_quick"> <script type="text/javascript"> function quickSelect(elt) { var eltVal = $(elt).val() if (eltVal == "0") return false else if (eltVal.substr(eltVal.length - 6) == "_blank") window.open(eltVal.substr(0, eltVal.length - 6), "_blank") else location.href = eltVal } </script> <select onchange="quickSelect(this) <option value="0">Accès rapide</option><option value="index.php">&gt </div> <div class="flatclear">&nbsp <a href="index.php?tab=AdminCatalog&token=843b8197b08ba10d165c51bd6a0faeb4"> <img src="/img/t/AdminCatalog.gif" alt="" /> Catalogue </a> </li><li class="submenu_size " id="maintab2"> <a href="index.php?tab=AdminCustomers&token=bc2504c7ef458aadad5ecff721c3e23c"> <img src="/img/t/AdminCustomers.gif" alt="" /> Clients </a> </li><li class="submenu_size " id="maintab3"> <a href="index.php?tab=AdminOrders&token=59cb173171d0d3dee1c8b08d022cb025"> <img src="/img/t/AdminOrders.gif" alt="" /> Commandes </a> </li><li class="submenu_size " id="maintab4"> <a href="index.php?tab=AdminPayment&token=38c2ad9073d29e84e30176c9c4fe462d"> <img src="/img/t/AdminPayment.gif" alt="" /> Paiement </a> </li><li class="submenu_size " id="maintab5"> <a href="index.php?tab=AdminShipping&token=dfc82a41d4e3927810e67f786185a533"> <img src="/img/t/AdminShipping.gif" alt="" /> Transport </a> </li><li class="submenu_size " id="maintab6"> <a href="index.php?tab=AdminStats&token=54259ac1c2e43749100e327107f13127"> <img src="/img/t/AdminStats.gif" alt="" /> Stats </a> </li><li class="submenu_size active" id="maintab7"> <a href="index.php?tab=AdminModules&token=62b0fc62be3a5d7599cb5b531fee4f86"> <img src="/img/t/AdminModules.gif" alt="" /> Modules </a> </li><li class="submenu_size " id="maintab29"> <a href="index.php?tab=AdminEmployees&token=3f6c780568d15bf3b2ab7eba859afe3c"> <img src="/img/t/AdminEmployees.gif" alt="" /> Employés </a> </li><li class="submenu_size " id="maintab8"> <a href="index.php?tab=AdminPreferences&token=7bb9a099e4a1c3110daf92300668a374"> <img src="/img/t/AdminPreferences.gif" alt="" /> Préférences </a> </li><li class="submenu_size " id="maintab9"> <a href="index.php?tab=AdminTools&token=cec28aa16eec991a7ea89c380612b8b9"> <img src="/img/t/AdminTools.gif" alt="" /> Outils </a> </li> </ul><div id="tab1_subtabs" style="display:none"><li><a href="index.php?tab=AdminTracking&token=9f6a4bdb16b18c12db4af07fbc11ec87">Suivi</a></li><li><a href="index.php?tab=AdminManufacturers&token=741a6940440db5d47ae4b4d37ce37ac2">Fabricants</a></li><li><a href="index.php?tab=AdminSuppliers&token=14c0a3af54b4de2e5a37090c3992ae35">Fournisseurs</a></li><li><a href="index.php?tab=AdminAttributesGroups&token=217c16574d3bec59573a251c27800856">Attributs et groupes</a></li><li><a href="index.php?tab=AdminFeatures&token=377e29d6393d55b6694a7a8eb908a526">Caractéristiques</a></li><li><a href="index.php?tab=AdminScenes&token=74cdd5bd2184f4a82957ad95a7df08fd">Scènes</a></li><li><a href="index.php?tab=AdminTags&token=8f4a2dd17eac8471b26643493b1563b3">Tags</a></li><li><a href="index.php?tab=AdminAttachments&token=58c2ee13ba23a2cb40b5bb73d2a4f49b">Documents joints</a></li><li><a href="index.php?tab=AdminStockMvt&token=a5cad4d6954c16d6164075bb13eab781">Mouvements de Stock</a></li><li><a href="index.php?tab=AdminMiscEdit&token=65d82507b992df83767f0ed8c9b675dd">Edition en liste des produits</a></li></div><div id="tab2_subtabs" style="display:none"><li><a href="index.php?tab=AdminAddresses&token=08837a46c8301912b8908bab340d55db">Adresses</a></li><li><a href="index.php?tab=AdminGroups&token=b9ce42a4ba5a3bfc3f7402cabfe25010">Groupes</a></li><li><a href="index.php?tab=AdminCarts&token=7f100d48f250e4bc0b1d40dee622e7a0">Paniers</a></li><li><a href="index.php?tab=AdminSuperUser&token=413775d974fac3e4e3d443cd2dcb8b42">SuperUtilisateur</a></li></div><div id="tab3_subtabs" style="display:none"><li><a href="index.php?tab=AdminInvoices&token=f91da142bdd458b032f655b264f55c65">Factures</a></li><li><a href="index.php?tab=AdminDeliverySlip&token=7d48f66c5e903c97b22cb4628df67587">Bons de livraison</a></li><li><a href="index.php?tab=AdminReturn&token=7043fb834a7b997c0b8ea43fc67f7273">Retours produits</a></li><li><a href="index.php?tab=AdminSlip&token=a38292a79b89c4a82485fb34f777b7fa">Avoirs</a></li><li><a href="index.php?tab=AdminMessages&token=195551945731c945a61154cd49392aee">Messages clients</a></li><li><a href="index.php?tab=AdminStatuses&token=3157f391fbeb5c03dd489c2d2dda793b">Statuts</a></li><li><a href="index.php?tab=AdminOrderMessage&token=9e7513a1b7b6ffe0138a84f495bf6da0">Messages prédéfinis</a></li><li><a href="index.php?tab=AdminPDF&token=203f4c8c3eadcd0745edadd9ac86186e">PDF</a></li><li><a href="index.php?tab=AdminMondialRelay&token=84067e9d7c44b171f6073e8130bf8169">Mondial Relay</a></li></div><div id="tab4_subtabs" style="display:none"><li><a href="index.php?tab=AdminCurrencies&token=b2d84a512b153610a561465d37fcb710">Devises</a></li><li><a href="index.php?tab=AdminTaxes&token=296f336b7766ef93adad30a794a76fe8">Taxes</a></li><li><a href="index.php?tab=AdminTaxRulesGroup&token=3e2c5ec046bcb1672fad92f2494db9ee">Règles de taxes</a></li><li><a href="index.php?tab=AdminDiscounts&token=2869c03df4df9aadd871f31f3197dcb5">Bons de réduction</a></li></div><div id="tab5_subtabs" style="display:none"><li><a href="index.php?tab=AdminCarriers&token=a3835a7ed5faced6739021348e2cd7ca">Transporteurs</a></li><li><a href="index.php?tab=AdminStates&token=2e21bcba49cfb7c68c5c5ad112633eba">Etats</a></li><li><a href="index.php?tab=AdminCountries&token=ab90fd378a4396ce86789d7ddc4ec376">Pays</a></li><li><a href="index.php?tab=AdminCounty&token=c5f87bdd168c8bd4468ebcd15b625e1f">Comtés</a></li><li><a href="index.php?tab=AdminZones&token=efd72a88885391be568f60fb60d0e34f">Zones</a></li><li><a href="index.php?tab=AdminRangePrice&token=9c3ba029e17395f9a1259b7c361aca6c">Tranches de prix</a></li><li><a href="index.php?tab=AdminRangeWeight&token=c27264d826161788a86c64950c934e15">Tranches de poids</a></li></div><div id="tab6_subtabs" style="display:none"><li><a href="index.php?tab=AdminStatsConf&token=15a159c9b764e353a534be6281c6f125">Configuration</a></li><li><a href="index.php?tab=AdminSearchEngines&token=f7e5cbc956b63cfde731ef470593f815">Moteurs de recherche</a></li><li><a href="index.php?tab=AdminReferrers&token=66a69ca7717dc1c2d2647b98d015befa">Sites affluents</a></li></div><div id="tab7_subtabs" style="display:none"><li><a href="index.php?tab=AdminAddonsCatalog&token=9b3d1605d1dbb04eb5f888c93526cdc9">Catalogue de modules et thèmes</a></li><li><a href="index.php?tab=AdminAddonsMyAccount&token=5348c414a7b0228487844a6607639fe6">Mon compte</a></li><li><a href="index.php?tab=AdminThemes&token=fe751a7e73f7818527f1463c56897513">Thèmes</a></li><li><a href="index.php?tab=AdminModulesPositions&token=5173c2ac020f20c2a51f0c8ea024894a">Positions</a></li></div><div id="tab29_subtabs" style="display:none"><li><a href="index.php?tab=AdminProfiles&token=5ee00712e6b2841ea9fe721927fa940f">Profils</a></li><li><a href="index.php?tab=AdminAccess&token=177a0bb09309da9a78a26d0846609301">Permissions</a></li><li><a href="index.php?tab=AdminTabs&token=88e5cceb79edad047bad7a917afa583f">Onglets</a></li><li><a href="index.php?tab=AdminContacts&token=628b7861e16d834a8940887f74bf2de0">Contacts</a></li><li><a href="index.php?tab=AdminCustomerThreads&token=dd38f841c80cf680e95990fbd1e2bf18">SAV</a></li></div><div id="tab8_subtabs" style="display:none"><li><a href="index.php?tab=AdminContact&token=10edd973a15155bf5ef3a8e8a150cf33">Coordonnées</a></li><li><a href="index.php?tab=AdminAppearance&token=4a838f58b95a3793375394f199c14c10">Apparence</a></li><li><a href="index.php?tab=AdminMeta&token=938d02ef5e4020fecd472fb5305a1e07">SEO & URLs</a></li><li><a href="index.php?tab=AdminPPreferences&token=53082108b42a90802838daf076721e2e">Produits</a></li><li><a href="index.php?tab=AdminAliases&token=ca637d45223898fd1276a997371ccd28">Alias</a></li><li><a href="index.php?tab=AdminEmails&token=7f4c34d53ec7894842a760ee375a9d76">Emails</a></li><li><a href="index.php?tab=AdminImages&token=a28e30ba6d3ec76c6447eb324b1b1d13">Images</a></li><li><a href="index.php?tab=AdminDb&token=6fd6b0d0e2bf994fff52562eef0160e4">Base de données</a></li><li><a href="index.php?tab=AdminLocalization&token=f39cc01003d71ac7de32a163a8f0673b">Localisation</a></li><li><a href="index.php?tab=AdminSearchConf&token=4d4248340704367dc0051098aad9b3e0">Recherche</a></li><li><a href="index.php?tab=AdminPerformance&token=33db2146c30c81a5070346dec26b98e9">Performances</a></li><li><a href="index.php?tab=AdminGeolocation&token=b06f26c61226a16b339f0cc92a51bebf">Géolocalisation</a></li></div><div id="tab9_subtabs" style="display:none"><li><a href="index.php?tab=AdminLanguages&token=0df22b35e1c32fef65114851d19a613d">Langues</a></li><li><a href="index.php?tab=AdminTranslations&token=07c8c70b18840c1e41926f4b0535c0cf">Traductions</a></li><li><a href="index.php?tab=AdminQuickAccesses&token=85b585540a4ff39a553c08b31dd34b48">Accès rapide</a></li><li><a href="index.php?tab=AdminImport&token=e0c701c158c4e8690e575ad5e4c35215">Import</a></li><li><a href="index.php?tab=AdminSubDomains&token=19698ec1cc95d98c96e3a26c8433e14b">Sous domaines</a></li><li><a href="index.php?tab=AdminBackup&token=b3250f62be8ebeb5b932cace47a6cc0b">Sauvegarde BDD</a></li><li><a href="index.php?tab=AdminCMSContent&token=de17a704a1e2a30dfa8ce839acfbef14">CMS</a></li><li><a href="index.php?tab=AdminGenerator&token=cbe1d968c57526afc84525502f5fbfb1">Générateurs</a></li><li><a href="index.php?tab=AdminInformation&token=a251fc578d9b7fc2dc299ff767ff95bb">Informations</a></li><li><a href="index.php?tab=AdminStores&token=e226404ccd950589ea166f33738ad857">Magasins</a></li><li><a href="index.php?tab=AdminWebservice&token=fc039012bc7cf0e364e302be4b3c3042">Service web</a></li><li><a href="index.php?tab=AdminLogs&token=27ff1c798dc5b0525e9d5826ec344bbd">Log</a></li><li><a href="index.php?tab=AdminSelfUpgrade&token=88324186e711ac05936d00dd7d5f246a">1-Click Upgrade</a></li></div> <ul id="submenu" class="withLeftBorder clearfix"><li><a href="index.php?tab=AdminAddonsCatalog&token=9b3d1605d1dbb04eb5f888c93526cdc9">Catalogue de modules et thèmes</a></li><li><a href="index.php?tab=AdminAddonsMyAccount&token=5348c414a7b0228487844a6607639fe6">Mon compte</a></li><li><a href="index.php?tab=AdminThemes&token=fe751a7e73f7818527f1463c56897513">Thèmes</a></li><li><a href="index.php?tab=AdminModulesPositions&token=5173c2ac020f20c2a51f0c8ea024894a">Positions</a></li></ul> <div id="main"> <div id="content"> <script type="text/javascript"> $(document).ready(function(){ $.ajax({ type : "POST", url: "ajax.php", data:{ "helpAccess":"1", "item":"AdminModules", "isoUser":"fr", "country":"FR", "version":"1.4.9" }, async : true, success: function(msg) { $("#help-button").html(msg) $("#help-button").fadeIn("slow") } }) }) <div id="help-button" class="floatr" style="display: none <img src="../img/admin/separator_breadcrum.png" style="margin-right:5px" alt="&gt <div style="float:left <a href="http://www.prestashop.com/" target="_blank" style="font-weight:700 <span style="font-size:10px">Temps de chargement : 0.135s</span> </div> <div style="float:right | <a href="http://forge.prestashop.com" target="_blank" class="footer_link">Bug Tracker</a> | <a href="http://www.prestashop.com/forums/" target="_blank" class="footer_link">Forum</a> </div> </div> </div> </div> </body> </html> </html> ------------------------------------------------------------------------------------------------------------- zemacse69 Haut
  5. zemacse
    Bonjours à tous! Je travail en ce moment ,dans le cadre d'un stage de 2èm année de dev, sur la création d'un module prestashop destiné à exporter mes déclinaisons de produits dans un tableau excel au format .csv j'ai put trouver diverses méthodes sur plusieurs forums mais toutes me conduisent au même résultat : mon fichier .csv se crée mais ne contient aucune donnée et à la place j'obtient un fichier remplit par du code html. (voir post ci-bas) Voici le code de ma page php la plus aboutit et représentative de mon cas (surement remplie d'incohérences mais à peut près fonctionelle)(solution repêché sur le net mais j'ai oublié le lien) : <?php class exportDeclinaison extends Module { function __construct() { global $cookie; $this->_cookie = $cookie; $this->name = 'exportDeclinaison'; $this->tab = 'front_office_features'; $this->version = '1.0'; parent::__construct(); $this->displayName = $this->l('Export Declinaison'); $this->description = $this->l('Export your products and declinaisons in TXT or CSV file.'); } function install() { if (!parent::install()) return false; return true; } public function uninstall() { if (!parent::uninstall()) return false; return true; } function getContent() { if(!isset($_POST['produit'])){ echo'Choisissez la cat&eacutegorie de produit d&eacutesir&eacutee :'; //__________Liste categorie echo"<form action='#' method='POST'>"; echo "<select name='category' onchange='javascript:submit(this)'>"; mysql_connect("localhost","root","root"); mysql_select_db("c1_ks"); $res = mysql_query("SELECT * FROM ps_category_lang ORDER BY id_category"); while($cat = mysql_fetch_assoc($res)){ echo "<option value='".$cat["id_category"]."'>".$cat["name"]."</option>"; } echo"</select>"; echo"</form>"; } //__________Fin liste categorie //__________Liste prod if(isset($_POST['category'])){ echo"<form action='#' method='POST'>"; echo "<select name='produit' onchange='javascript:submit(this)'>"; mysql_connect("localhost","root","root"); mysql_select_db("c1_ks"); $res = mysql_query('SELECT p.* , pl.* , m.name AS manufacturer_name, s.name AS supplier_name, t.rate, sp.reduction, sp.reduction_type, sp.from, sp.to FROM ps_product AS p LEFT JOIN ps_category_product AS cp ON p.id_product = cp.id_product LEFT JOIN ps_category_lang AS cl ON cl.id_category = cp.id_category LEFT JOIN ps_product_lang AS pl ON p.id_product = pl.id_product LEFT JOIN ps_manufacturer AS m ON p.id_manufacturer = m.id_manufacturer LEFT JOIN ps_supplier AS s ON p.id_supplier = s.id_supplier LEFT JOIN ps_tax AS t ON p.id_tax_rules_group = t.id_tax LEFT JOIN ps_specific_price AS sp ON p.id_product = sp.id_product WHERE cp.id_category ="'.$_POST['category'].'"order by cp.id_product'); while($prod = mysql_fetch_assoc($res)){ echo "<option value='".$prod["id_product"]."'>".$prod["name"]."</option>"; } echo "</select>"; } if (isset($_POST['produit'])){ // la variable qui va contenir les données CSV $outputCsv = ''; // Nom du fichier final $fileName = 'export-csv.csv'; $req= mysql_query('SELECT p.id_product, p.price, p.reference, p.supplier_reference , pl.name, agl.name AS attribGroupName , agl.id_attribute_group, al.id_attribute, al.name FROM ps_product AS p LEFT JOIN ps_product_lang AS pl ON p.id_product = pl.id_product LEFT JOIN ps_product_attribute AS pa ON pa.id_product = p.id_product LEFT JOIN ps_product_attribute_combination AS pac ON pa.id_product_attribute = pac.id_product_attribute LEFT JOIN ps_attribute_lang AS al ON al.id_attribute = pac.id_attribute LEFT JOIN ps_attribute AS a ON al.id_attribute = a.id_attribute LEFT JOIN ps_attribute_group_lang AS agl ON agl.id_attribute_group = a.id_attribute_group WHERE pl.id_product ="'.$_POST['produit'].'"order by p.id_product'); if(mysql_num_rows($req) > 0) { $i = 0; while($Row = mysql_fetch_assoc($req)) { $i++; // Si c'est la 1er boucle, on affiche le nom des champs pour avoir un titre pour chaque colonne if($i == 1) { foreach($Row as $clef => $valeur) $outputCsv .= trim($clef).';'; $outputCsv = rtrim($outputCsv, ';'); $outputCsv .= "\n"; } // On parcours $Row et on ajoute chaque valeur à cette ligne foreach($Row as $clef => $valeur) $outputCsv .= trim($valeur).';'; // Suppression du ; qui traine à la fin $outputCsv = rtrim($outputCsv, ';'); // Saut de ligne $outputCsv .= "\n"; } } else exit('Aucune donnée à enregistrer.'); // Entêtes (headers) PHP qui vont bien pour la création d'un fichier Excel CSV header("Content-disposition: attachment; filename=".$fileName); header("Content-Type: application/force-download"); header("Content-Transfer-Encoding: application/vnd.ms-excel\n"); header("Pragma: no-cache"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0, public"); header("Expires: 0"); echo $outputCsv; exit(); } //__________Fin liste prod } } ?> Déroulement : - Sélection catégorie de produit dans une 1ère liste déroulante - Sélection produit désiré dans une 2èm liste implémentée par la 1ère - Lancement du téléchargement du fichier csv dès qu'une sélection d'un produit a été effectué dans la deuxième liste. Je sollicite donc votre aide pour que mon fichier.csv soit correctement remplis car je piétine depuis plus d'une semaine et là c'est le point mort. Je vous remerci d'avance de l'intérêt porté à mon problème PS : j'ai d'autre solutions aboutissants au même résultat à poster si besoin.
×
×
  • Create New...