How:
The jumped in part is added.
line 75

$header = array( //thanks to blackice78 for this code fix
array('data' => t('Qty'), 'field' => 'Qty', 'sql_field' => "$uc_order_products.qty"),
array('data' => t('LName'), 'field' => 'LName', 'sql_field' => "$uc_orders.billing_last_name"),
array('data' => t('FName'), 'field' => 'FName', 'sql_field' => "$uc_orders.billing_first_name"),
array('data' => t('Email'), 'field' => 'Email', 'sql_field' => "$uc_orders.primary_email"),
array('data' => t('Phone'), 'field' => 'Phone', 'sql_field' => "$uc_orders.billing_phone"),
array('data' => t('delivery_first_name'), 'field' => 'delivery_first_name', 'sql_field' => "$uc_orders.delivery_first_name"),
array('data' => t('delivery_last_name'), 'field' => 'delivery_last_name', 'sql_field' => "$uc_orders.delivery_last_name"),
array('data' => t('delivery_company'), 'field' => 'delivery_company', 'sql_field' => "$uc_orders.delivery_company"),
array('data' => t('delivery_phone'), 'field' => 'delivery_phone', 'sql_field' => "$uc_orders.delivery_phone"),
array('data' => t('Price'), 'field' => 'Price', 'sql_field' => "$uc_order_products.price"),
array('data' => t('Total'), 'field' => 'Total', 'sql_field' => "($uc_order_products.price * $uc_order_products.qty)"),
array('data' => t('Date'), 'field' => 'Date', 'sql_field' => "FROM_UNIXTIME($uc_orders.created, '%Y.%m.%e')"),
array('data' => t('HowPay'),'field' => 'HowPay','sql_field' => "$uc_orders.payment_method"),
array('data' => t('Status'),'field' => 'Status','sql_field' => "$uc_orders.order_status"),
array('data' => t('ID'), 'field' => 'ID', 'sql_field' => "$uc_orders.order_id"),

line 151

$temparray = array();
$temparray[]= $customer['Qty'];
$temparray[]= l($customer['LName'], 'user/' . $customer['uid']);
$temparray[]= l($customer['FName'], 'user/' . $customer['uid']);
$temparray[]= l($customer['Email'], 'mailto:' . $customer['Email']);
$temparray[]= $customer['Phone'];
$temparray[]= $customer[t('delivery_last_name')];
$temparray[]= $customer[t('delivery_first_name')];
$temparray[]= $customer[t('delivery_company')];
$temparray[]= $customer[t('delivery_phone')];
$temparray[]= number_format($customer['Price'],2);
$temparray[]= number_format($customer['Total'],2);
$temparray[]= $customer['Date'];
$temparray[]= $customer['HowPay'];
$temparray[]= l($customer['Status'],'admin/store/orders/' . $customer['ID']);
$temparray[]= l("#" . $customer['ID'],'admin/store/orders/' . $customer['ID']);

It works here, but the title header of first and last name are switched for some reason, and not in the query.

Comments

cayenne’s picture

The real issue in my mind is how many fields should the report support? In general, I have felt that if you are shipping something, you should really be looking at the invoice anyway, which is just one click away from the wbw report.

But maybe I am confused. You want just the Name of the delivery person? Not the address? Can you share your thoughts here?

ikeigenwijs’s picture

We use the delivery name as the cursist person, is not always the same as the billing person/company.
The cursist gets a named certificate.
And the list serves as a list of attendees., expected attendees.

cayenne’s picture

Okay, I think it's clear that I am going to have to learn how to set up a configuration form. In the meantime what about this:

A. In the very short run, add an attribute "Name on Certificate" which is more definite anyway
B. I'll look at adding the shipping and billing informatokn to the .csv file

What's a cursist?

ikeigenwijs’s picture

i added my hack for now so im an update behind.

i want to help where i can for the configuration form, i think it would be greet for uc if there is a possibility to make custem reports and lists in the way that the people want.

thx a lot.

cayenne’s picture

Status: Needs review » Closed (works as designed)

Delivery and billing names will be in the .csv in the next release.