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