Het betreft een prestashop omgeving, waarvoor ik een custom database value export to .cvs module heb aangeschaft.
Deze module werkt overigens prima, echter wil ik een stukje code aan het script toevoegen waardoor er extra waardes in het te exporteren .csv bestand kunnen worden toegevoegd.
Dit zijn waardes betreffende de diverse bestellingen door klanten.
Hieronder zie je een snapshot van de tabel die ik wil benaderen middels het stukje code wat je kunt vinden bij:(scroll naar beneden) //TO GET CUSTOMIZED_DATA VALUES FROM DATABASE 04-09-2012
Wat ik uiteindelijk in het .csv bestand krijg is op elke regel "Array" in plaats van een waarde.
Zie voorbeeld:
Wat doe ik verkeerd?
Het gaat om dit stukje door mij toegevoegde code $print_name = Db::getInstance()->getRow('SELECT `id_cus...........
<?php
$address_choice = $_POST['address_choice'];
// natuurlijk details van de orders
$orders_detail = Db::getInstance()->ExecuteS('SELECT * FROM `'._DB_PREFIX_.'order_detail` od
LEFT JOIN `'._DB_PREFIX_.'orders` o ON (o.`id_order` = od.`id_order`)
WHERE `date_add` >= "'.$date_start.'"
AND `date_add` <= "'.$date_end.'"');
foreach($orders_detail as $order_detail){
if(Customer::customerIdExists($order_detail['id_customer'])){
$f_no = array();
// Objet commande
$Order = new Order($order_detail['id_order']);
$order = $Order->getFields();
$f_no[1] = $order_detail['id_order'];
$f_no[2] = $order_detail['id_order_detail'];
$f_no[3] = date("d.m.Y", strtotime($order['date_add']));
// info client
$Customer = new Customer($order['id_customer']);
$customer = $Customer->getFields();
if($customer['id_gender']==1){$gender=$this->l('Monsieur');}else{$gender=$this->l('Madame');}
// info adresse
if($address_choice=='delivery'){
$Address = new Address($order['id_address_delivery']);
}else{
$Address = new Address($order['id_address_invoice']);
}
$address = $Address->getFields();
$f_no[38] = $address['company'];
$f_no[4] = $gender;
$f_no[5] = $customer['firstname'];
$f_no[6] = $customer['lastname'];
$f_no[7] = $address['address1'];
$f_no[8] = $address['address2'];
$f_no[9] = $address['postcode'];
$f_no[10] = $address['city'];
$country = Country::getNameById($order['id_lang'],$address['id_country']);
$f_no[11] = $country;
$f_no[12] = $address['phone'];
$f_no[13] = $address['phone_mobile'];
$f_no[14] = $customer['email'];
$f_no[15] = $customer['birthday'];
if($customer['newsletter']){
$newsletter=$this->l('Oui');
}else{
$newsletter = $this->l('Non');
}
$f_no[16] = $newsletter;
$group = '';
// v1.3 +
if(isset($customer['id_default_group'])){
$Group = new Group($customer['id_default_group']);
$group = $Group->name[$order['id_lang']];
}else{
$res = Db::getInstance()->getRow('SELECT `id_group` FROM '._DB_PREFIX_.'customer_group WHERE `id_customer` = "'.$order_detail['id_customer'].'"');
$Group = new Group($res['id_group']);
$group = $Group->name[$order['id_lang']];
}
$f_no[17] = $group;
$f_no[18] = $order_detail['product_quantity'];
$f_no[19] = $order_detail['product_name'];
$f_no[20] = round($order_detail['product_price']+($order_detail['product_price']*$order_detail['tax_rate']/100),2);
$f_no[21] = $order_detail['tax_rate'];
$f_no[22] = $order_detail['product_weight'];
$f_no[23] = $order_detail['product_ean13'];
$f_no[24] = $order_detail['product_reference'];
$f_no[25] = $order_detail['product_supplier_reference'];
$f_no[26] = $order['total_paid'];
$f_no[27] = $order['total_paid_real'];
$f_no[28] = $order['total_shipping'];
$Currency = new Currency($order['id_currency']);
$currency = $Currency->getFields();
$f_no[29] = $currency['iso_code'];
$f_no[30] = $order['payment'];
$f_no[31] = $order['invoice_number'];
$f_no[32] = $order['delivery_number'];
if($order['id_carrier']>0){
$Carrier = new Carrier($order['id_carrier']);
$carrier = $Carrier->getFields();
$carrier_name = $carrier['name'];
}else{
$carrier_name = '';
}
$f_no[33] = $carrier_name;
$Language = new Language($order['id_lang']);
$language = $Language->getFields();
$f_no[34] = $language['name'];
$f_no[35] = $order['invoice_date'];
// récupère l'emplacement du produit
$id_product = $order_detail['product_id'];
// simple
if(empty($order_detail['product_attribute_id'])){
$product = Db::getInstance()->getRow('SELECT `location`,`wholesale_price` FROM '._DB_PREFIX_.'product WHERE `id_product`="'.$id_product.'"');
$location = $product['location'];
$wholesale_price = $product['wholesale_price'];
// déclinaison
}else{
$id_product_attribute = $order_detail['product_attribute_id'];
$productDecl = Db::getInstance()->getRow('SELECT `location`,`wholesale_price` FROM '._DB_PREFIX_.'product_attribute WHERE `id_product`="'.$id_product.'" AND `id_product_attribute`="'.$id_product_attribute.'"');
$location = $productDecl['location'];
$wholesale_price = $productDecl['wholesale_price'];
}
$f_no[36] = $location;
$f_no[37] = $wholesale_price;
//TO GET CUSTOMIZED_DATA VALUES FROM DATABASE 04-09-2012
$print_name = Db::getInstance()->getRow('SELECT `id_customization` FROM '._DB_PREFIX_.'customized_data');
$f_no[39] = $print_name;
// Ordonne les cellules selon la base de donnée
$f_place = array();
if(is_array($fields_no)){
foreach($fields_no as $field_no){
$res = Db::getInstance()->ExecuteS('SELECT `place` FROM '._DB_PREFIX_.'customexporter WHERE `field_no`='.$field_no.' AND `export_type`="'.$export_type.'"');
$place = $res[0]['place'];
$f_place[$place] = $f_no[$field_no];
}
}
$this->file[] = $f_place; // ajoute nouvelle ligne triée au fichier
} // end if customer exist
}
?>