PHP make_payments_detail Examples

Example #1

File: make_payments.php Project: vanboingy/OFS_trunk

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

Example #2

File: make_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 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__));