Export Csv Suite Requête Php

zemacse · February 19, 2013

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.

Edited February 19, 2013 by zemacse (see edit history)

zemacse · February 19, 2013

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">

<head>

<title>PrestaShop&trade

var helpboxes = 1

var roundMode = 2

</script>

<!--[if IE]>

<![endif]-->

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 >

var choose_language_trad = "Choisissez une langue"

</script>

<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>

<input type="text" name="bo_query" id="bo_query"

value=""

/>

<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>

</form>

</div>

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

<img src="/img/t/AdminCatalog.gif" alt="" /> Catalogue

</a>

</li><li class="submenu_size " id="maintab2">

<img src="/img/t/AdminCustomers.gif" alt="" /> Clients

</a>

</li><li class="submenu_size " id="maintab3">

<img src="/img/t/AdminOrders.gif" alt="" /> Commandes

</a>

</li><li class="submenu_size " id="maintab4">

<img src="/img/t/AdminPayment.gif" alt="" /> Paiement

</a>

</li><li class="submenu_size " id="maintab5">

<img src="/img/t/AdminShipping.gif" alt="" /> Transport

</a>

</li><li class="submenu_size " id="maintab6">

<img src="/img/t/AdminStats.gif" alt="" /> Stats

</a>

</li><li class="submenu_size active" id="maintab7">

<img src="/img/t/AdminModules.gif" alt="" /> Modules

</a>

</li><li class="submenu_size " id="maintab29">

</a>

</li><li class="submenu_size " id="maintab8">

</a>

</li><li class="submenu_size " id="maintab9">

<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>

$(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>

</body>

</html>

------------------------------------------------------------------------------------------------------------- zemacse69

Haut

Sign In

Export Csv Suite Requête Php

Recommended Posts

zemacse

Link to comment

Share on other sites

zemacse

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Browse

Activity

Go back to prestashop.com