LEFT JOIN ' . TABLE_ORDER_CYCLES . ' USING(delivery_id) LEFT JOIN ' . TABLE_PRODUCER . ' USING(producer_id) WHERE ' . NEW_TABLE_BASKETS . '.delivery_id = "' . mysql_real_escape_string($delivery_id) . '" GROUP BY ' . NEW_TABLE_PRODUCTS . '.producer_id ORDER BY ' . $order_by; $result = @mysql_query($query, $connection) or die(debug_print("ERROR: 579329 ", array($query, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__)); $num_orders = mysql_numrows($result); while ($row = mysql_fetch_array($result)) { $business_name = $row['business_name']; $producer_member_id = $row['producer_member_id']; $payee = $row['payee']; $producer_id = $row['producer_id']; $make_payments_detail_line = make_payments_detail(array('request' => 'producer_total_and_payments', 'delivery_id' => $delivery_id, 'producer_id' => $producer_id)); $page_data .= ' <div id="producer_id' . $producer_id . '" class="producer_section"> <span class="producer_id">' . $producer_id . '</span> <span class="payee">' . ($payee != $business_name ? '[' . $payee . ']' : '') . '</span> <span class="business_name"><a href="show_report.php?type=producer_invoice&delivery_id=' . $delivery_id . '&producer_id=' . $producer_id . '" target="_blank">' . $business_name . '</a></span> <span class="controls"><input type="button" value="Make Payment" onclick="show_make_payment_form(' . $producer_id . ',' . $delivery_id . ', \'' . urlencode($business_name) . '\')"></span> <div id="detail_producer_id' . $producer_id . '" class="ledger_info">' . $make_payments_detail_line . ' </div> </div>'; } $page_specific_javascript = ' <script src="' . PATH . 'make_payments.js" type="text/javascript"></script>'; $page_specific_css = ' <link href="' . PATH . 'make_payments.css" rel="stylesheet" type="text/css">'; $page_title_html = '<span class="title">Delivery Cycle Functions</span>';
<?php include_once 'config_openfood.php'; session_start(); if (CurrentMember::auth_type('cashier') && $call_ajax_as_function != true) { echo make_payments_detail($_POST); } function make_payments_detail($argument) { global $connection; switch ($argument['request']) { // BASKET TOTAL AND PAYMENTS ****************************************************** case 'producer_total_and_payments': $non_payment_total = 0; $non_payment_count = 0; $payment_total = 0; $payment_count = 0; $query = ' SELECT text_key, SUM(amount) AS total, COUNT(amount) AS count FROM ' . NEW_TABLE_LEDGER . ' WHERE delivery_id = "' . mysql_real_escape_string($argument['delivery_id']) . '" AND ((source_type = "producer" AND source_key = "' . mysql_real_escape_string($argument['producer_id']) . '") OR (target_type = "producer" AND target_key = "' . mysql_real_escape_string($argument['producer_id']) . '")) AND replaced_by IS NULL GROUP BY text_key'; $result = @mysql_query($query, $connection) or die(debug_print("ERROR: 768933 ", array($query, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__));