<?php include_once 'config_openfood.php'; session_start(); if (CurrentMember::auth_type('cashier') && $call_ajax_as_function != true) { echo receive_payments_detail($_POST); } function receive_payments_detail($argument) { global $connection; switch ($argument['request']) { // BASKET TOTAL AND PAYMENTS ****************************************************** case 'basket_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 basket_id = "' . mysql_real_escape_string($argument['basket_id']) . '" AND (source_type = "member" OR target_type = "member") 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__));
' . NEW_TABLE_BASKETS . '.member_id ORDER BY ' . $order_by; $result = @mysql_query($query, $connection) or die(debug_print("ERROR: 672323 ", array($query, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__)); $num_orders = mysql_numrows($result); while ($row = mysql_fetch_array($result)) { $basket_id = $row['basket_id']; $member_id = $row['member_id']; $site_id = $row['site_id']; $site_short = $row['site_short']; $last_name = $row['last_name']; $first_name = $row['first_name']; $business_name = $row['business_name']; $preferred_name = $row['preferred_name']; $hub_id = $row['hub_id']; $receive_payments_detail_line = receive_payments_detail(array('request' => 'basket_total_and_payments', 'basket_id' => $basket_id)); $page_data .= ' <div id="member_id' . $member_id . '" class="basket_section"> <span class="member_id">' . $member_id . '</span> <span class="site_short">[' . $site_short . ']</span> <span class="member_name"><a href="' . PATH . 'show_report.php?type=customer_invoice&delivery_id=' . $delivery_id . '&member_id=' . $member_id . '" target="_blank">' . $preferred_name . '</a></span> <span class="controls"><input type="button" value="Receive Payment" onclick="show_receive_payment_form(' . $member_id . ',' . $basket_id . ',\'' . urlencode($preferred_name) . '\')"></span> <div id="basket_id' . $basket_id . '" class="ledger_info">' . $receive_payments_detail_line . ' </div> </div>'; } $page_specific_javascript = ' <script src="' . PATH . 'receive_payments.js" type="text/javascript"></script>'; $page_specific_css = ' <link href="' . PATH . 'receive_payments.css" rel="stylesheet" type="text/css">'; $page_title_html = '<span class="title">Delivery Cycle Functions</span>';