PHP receive_payments_detail Examples

Example #1

File: receive_payments_detail.php Project: vanboingy/OFS_trunk

<?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__));

Example #2

File: receive_payments.php Project: vanboingy/OFS_trunk

    ' . 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>';