' . NEW_TABLE_BASKETS . '.delivery_id = "' . mysql_real_escape_string($delivery_id) . '"
AND ' . NEW_TABLE_BASKETS . '.site_id = "' . mysql_real_escape_string($site_array['site_id']) . '"
AND ' . NEW_TABLE_BASKET_ITEMS . '.out_of_stock != "1"
AND ' . NEW_TABLE_PRODUCTS . '.tangible = 1
GROUP BY
' . NEW_TABLE_BASKETS . '.basket_id
ORDER BY
last_name ASC';
$result = @mysql_query($query, $connection) or die(debug_print("ERROR: 769302 ", array($query, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__));
$num_orders = mysql_numrows($result);
while ($row = mysql_fetch_array($result)) {
$member_array = (array) $row;
$display .= '
<table cellpadding=0 cellspacing=0 border=0><tr><td id="' . $member_id . '" width="400" valign=top>';
$display .= '
<li> <b>' . convert_route_code(array_merge($site_array, $member_array)) . '</b><br>
<a href="show_report.php?type=customer_invoice&delivery_id=' . $delivery_id . '&member_id=' . $member_array['member_id'] . '">
<b>' . $member_array['preferred_name'] . ' (Mem#' . $member_array['member_id'] . ')</b></a><!-- - Deliverable Products: ' . $product_quantity_of_member . ' -->';
$display .= ' <ul>';
if ($member_array['ddelivery_type'] == 'W') {
$display .= 'Work address:<br>';
if ($member_array['work_address_line1']) {
$display .= $member_array['work_address_line1'] . '<br>';
} else {
$display .= 'No work address available<br>';
}
if ($member_array['work_address_line2']) {
$display .= $member_array['work_address_line2'] . '<br>';
}
if ($member_array['work_city'] || $member_array['work_state'] || $member_array['work_zip']) {
$display .= $member_array['work_city'] . ', ' . $member_array['work_state'] . ', ' . $member_array['work_zip'] . '<br>';
' . NEW_TABLE_SITES . '.site_long,
' . NEW_TABLE_BASKETS . '.member_id,
' . NEW_TABLE_BASKET_ITEMS . '.product_id,
' . TABLE_PRODUCT_STORAGE_TYPES . '.storage_code';
$result = @mysql_query($query, $connection) or die(debug_print("ERROR: 730302 ", array($query, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__));
while ($row = mysql_fetch_object($result)) {
if ($row->site_id != $site_id_prior) {
$output .= '
</pre>' . ($_GET['paginate'] == 'true' ? '<!-- NEW SHEET -->' : '') . '
<h3>' . $row->site_long . ' [' . $row->site_short . ']</h3>
<pre>
(MEMBR) ROUTE CODE - NAME
PROD_ID CHK STOR DESCRIPTION QUANTITY
___________________________________________________________________________________________________';
}
$route_code = convert_route_code((array) $row);
if ($row->member_id != $member_id_prior || $row->site_id != $site_id_prior) {
$output .= "\n\n " . str_pad('(' . $row->member_id . ')', 6, ' ', STR_PAD_LEFT) . ' ' . $route_code . ' - ' . $row->first_name . ' ' . $row->last_name . "\n " . str_pad($row->product_id, 7, ' ', STR_PAD_LEFT) . ' ' . $checkbox . ' ' . str_pad($row->storage_code, 6) . str_pad(substr($row->product_name, 0, 40), 40) . ' ' . '(' . $row->quantity . ') - ' . Inflect::pluralize_if($row->quantity, $row->ordering_unit);
} else {
$output .= "\n " . str_pad($row->product_id, 7, ' ', STR_PAD_LEFT) . ' ' . $checkbox . ' ' . str_pad($row->storage_code, 6) . str_pad(substr($row->product_name, 0, 40), 40) . ' ' . '(' . $row->quantity . ') - ' . Inflect::pluralize_if($row->quantity, $row->ordering_unit);
}
// $output .= '
//
// <tr>
// <td width="7%">'.$row->storage_code.'</td>
// <td width="75%">('.$row->member_id.') ['.$row->product_id.'] '.$row->product_name.'</td>
// <td width="18%">('.$row->quantity.') - '.Inflect::pluralize_if ($row->product_quantity, $row->ordering_unit).'</td>
// </tr>';
$site_id_prior = $row->site_id;
$storage_code_prior = $row->storage_code;
$member_id_prior = $row->member_id;
$fax = $row['fax'];
$email_address = $row['email_address'];
$email_address_2 = $row['email_address_2'];
$product_quantity_of_member = $row['sum_pm'];
$address_line1 = $row['address_line1'];
$address_line2 = $row['address_line2'];
$city = $row['city'];
$state = $row['state'];
$zip = $row['zip'];
$work_address_line1 = $row['work_address_line1'];
$work_address_line2 = $row['work_address_line2'];
$work_city = $row['work_city'];
$work_state = $row['work_state'];
$work_zip = $row['work_zip'];
$display_rt .= '
<li> <b>' . convert_route_code((array) $row) . '</b><br>
<a href="show_report.php?type=customer_invoice&delivery_id=' . $delivery_id . '&member_id=' . $member_id . '">
<b>' . $preferred_name . ' (Mem#' . $member_id . ')</b></b></a>';
$display_rt .= ' <ul>';
if ($ddelivery_type == 'W') {
$display_rt .= 'Work address: ';
if ($work_address_line1) {
$display_rt .= $work_address_line1;
} else {
$display_rt .= 'No work address available<br>';
}
if ($work_address_line2) {
$display_rt .= ', ' . $work_address_line2;
}
if ($work_city || $work_state || $work_zip) {
$display_rt .= ", {$work_city}, {$work_state}, {$work_zip}<br>";
