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
Comment #1
cayenne commentedThe 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?
Comment #2
ikeigenwijs commentedWe 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.
Comment #3
cayenne commentedOkay, 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?
Comment #4
ikeigenwijs commentedi 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.
Comment #5
cayenne commentedDelivery and billing names will be in the .csv in the next release.