Und noch eine Frage.
Könnte mir jemand helfen bei:
- möchte Sendungsnummer in Tabellenübersicht einbauen
- geht bei mir weil nur ein Paketdienst und nie mehr als 1 Paket
Folgender Code funktioniert aber gibt den Sendungscode bei jeder Bestellung aus. Fehlt also die Zuweisung zur Order.
$tracking_links_ueb_query = xtc_db_query("select
t.ortra_order_id, t.ortra_parcel_id,
o.orders_id,
o.language
from ".TABLE_ORDERS_TRACKING." t,
".TABLE_ORDERS." o
where t.ortra_order_id=o.orders_id order by o.orders_id DESC");
$tracking_XXX = xtc_db_fetch_array($tracking_links_ueb_query);
$tracking_XXX['ortra_parcel_id'];
Und hier sollte es rein: aus der orders.php
if ($_GET['cID']) {
$cID = xtc_db_prepare_input($_GET['cID']);
// BOF - Tomcraft - 2009-10-11 - BUGFIX: #0000247 view orders query bug in admin
$orders_query_raw = "select o.orders_id, o.afterbuy_success, o.afterbuy_id, o.customers_name,
o.customers_id, o.payment_method, o.date_purchased, o.refferers_id,
o.last_modified, o.currency, o.currency_value, o.orders_status,
s.orders_status_name,
ot.text as order_total
from ".TABLE_ORDERS." o
left join ".TABLE_ORDERS_TOTAL." ot
on (o.orders_id = ot.orders_id), ".TABLE_ORDERS_STATUS." s
where o.customers_id = '".xtc_db_input($cID)."'
and ((o.orders_status = s.orders_status_id)
or (o.orders_status = '0' and s.orders_status_id = '1'))
and ot.class = 'ot_total'
and s.language_id = '".$_SESSION['languages_id']."'
order by orders_id DESC";
// EOF - Tomcraft - 2009-10-11 - BUGFIX: #0000247 view orders query bug in admin
}
elseif ($_GET['status']=='0') {
$orders_query_raw = "select o.orders_id, o.afterbuy_success, o.afterbuy_id, o.customers_name,
o.payment_method, o.date_purchased, o.refferers_id, o.last_modified,
o.currency, o.currency_value, o.orders_status,
ot.text as order_total
from ".TABLE_ORDERS." o
left join ".TABLE_ORDERS_TOTAL." ot
on (o.orders_id = ot.orders_id)
where o.orders_status = '0'
and ot.class = 'ot_total'
order by o.orders_id DESC";
}
elseif ($_GET['status']) {
$status = xtc_db_prepare_input($_GET['status']);
$orders_query_raw = "select o.orders_id, o.afterbuy_success, o.afterbuy_id, o.customers_name,
o.payment_method, o.date_purchased, o.refferers_id, o.last_modified,
o.currency, o.currency_value,
s.orders_status_name,
ot.text
as order_total
from ".TABLE_ORDERS." o
left join ".TABLE_ORDERS_TOTAL." ot
on (o.orders_id = ot.orders_id), ".TABLE_ORDERS_STATUS." s
where o.orders_status = s.orders_status_id
and s.language_id = '".$_SESSION['languages_id']."'
and s.orders_status_id = '".xtc_db_input($status)."'
and ot.class = 'ot_total'
order by o.orders_id DESC";
}
//BOF - web28 - 2010-04-10 added for ADMIN SEARCH BAR
elseif ($action == 'search' && $_GET['oID']) {
//$orders_query_raw siehe oben
//EOF - web28 - 2010-04-10 added for ADMIN SEARCH BAR
} else {
$orders_query_raw = "select o.orders_id, o.orders_status, o.afterbuy_success, o.afterbuy_id,
o.customers_name, o.payment_method, o.date_purchased, o.refferers_id, o.last_modified,
o.currency, o.currency_value, s.orders_status_name, ot.text as order_total
from ".TABLE_ORDERS." o
left join ".TABLE_ORDERS_TOTAL." ot
on (o.orders_id = ot.orders_id), ".TABLE_ORDERS_STATUS." s
where (o.orders_status = s.orders_status_id and s.language_id = '".$_SESSION['languages_id']."' and ot.class = 'ot_total')
or (o.orders_status = '0' and ot.class = 'ot_total' and s.orders_status_id = '1' and s.language_id = '".$_SESSION['languages_id']."')
order by o.orders_id DESC";
}
$orders_split = new splitPageResults($_GET['page'], '30', $orders_query_raw, $orders_query_numrows);
$orders_query = xtc_db_query($orders_query_raw);
Das ist zuviel für mich. Habe es versucht aber es fehlt mir an Wissen!