1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104
| $orders_query = tep_db_query("select
o.orders_id,
o.customers_id,
o.customers_group_id,
o.customers_name,
o.customers_company,
o.customers_street_address,
o.customers_suburb,
o.customers_city,
o.customers_postcode,
o.customers_state,
o.customers_country,
o.customers_telephone,
o.customers_email_address,
o.customers_address_format_id,
o.delivery_name,
o.delivery_company,
o.delivery_street_address,
o.delivery_suburb,
o.delivery_city,
o.delivery_postcode,
o.delivery_state,
o.delivery_country,
o.delivery_address_format_id,
o.billing_name,
o.billing_company,
o.billing_street_address,
o.billing_suburb,
o.billing_city,
o.billing_postcode,
o.billing_state,
o.billing_country,
o.billing_address_format_id,
o.payment_method,
o.cc_type,
o.cc_owner,
o.cc_number,
o.cc_expires,
o.last_modified,
o.date_purchased,
o.orders_status,
o.orders_date_finished,
o.currency,
o.currency_value,
o.purchase_order_number
from orders as o
");
// increment pour donner un numéro d'offre, préférable à l'id
$i = 0;
$separator = ';';
$enclosed = '"';
$escaped = '"';
while($orders = tep_db_fetch_array($orders_query)){
$orders_id = $orders['orders_id'];
$orders_status = $orders['orders_status'];
$i++;
$orders_list .= $escaped."E".$enclosed.";".$escaped.str_pad($orders['orders_id'],8," ", STR_PAD_RIGHT) . $enclosed.";";
$orders_list .= $escaped.str_pad($orders['customers_id'],6," ",STR_PAD_LEFT) . $enclosed.";";
//date achat
$date = clean_html_kelkoo($orders['date_purchased'],10);
$date_format = str_replace("-","",$date);
$date_finale_jj = substr($date_format, -6);
$date_finale_aa = substr($date_format, -6);
$date_finale_mm = substr($date_format, -6);
$jj = substr($date_finale_jj,4);
$mm = substr($date_finale_mm,2,-2);
$aa = substr($date_finale_aa,0,-4);
$orders_list .= $escaped.$jj.$mm.$aa.$enclosed.";";
//date livraison
$orders_list .= $escaped.$jj.$mm.$aa.$enclosed."\n";
$orders_products = tep_db_query("select orders_products_id, orders_id, products_id, products_model, products_name, products_price, final_price, products_tax, products_quantity, products_ecotax, ecotax_rates_id from orders_products
where orders_id = " . $orders_id);
// While loop to list the item
while($row_orders_products = mysql_fetch_array($orders_products))
{
$nb_enreg = mysql_num_rows($orders_products);
$orders_list .= $escaped."L".$enclosed.";".$escaped.$row_orders_products[1] . $enclosed.";";
$orders_list .= $escaped."<input type='hidden' name='" . $row_orders_products[2] . "' value='" . $i++ . "'>". $enclosed.";";
$orders_list .= $escaped.$nb_enreg. $enclosed.";";
$orders_list .= $escaped.$row_orders_products[2] . $enclosed.";";
$orders_list .= $escaped.$row_orders_products[8] . $enclosed."\n";
} // end while loop
$orders_products_comment = tep_db_query("select orders_status_history_id, orders_id, orders_status_id, date_added, customer_notified, comments from orders_status_history
where orders_id = " . $orders_id );
while($row_orders_products_comment = mysql_fetch_array($orders_products_comment)){
if ($row_orders_products_comment[5]!=""){
$orders_list .= $escaped."C".$enclosed.";".$escaped.$row_orders_products_comment[1] . $enclosed.";";
$orders_list .= $escaped."<input type='hidden' name='" . $row_orders_products_comment[2] . "' value='" . $i++ . "'>". $enclosed.";";
$orders_list .= $escaped.$row_orders_products_comment[5] . $enclosed."\n";
}else{}
}
} |
Partager