function manage() { expHistory::set('manageable', $this->params); $taxes = taxController::getTaxClasses(); assign_to_template(array('taxes' => $taxes)); }
function show_payment_summary() { global $order, $db; $payments = billingmethod::$payment_types; $order_ids = array(); if (isset($this->params['applytoall']) && $this->params['applytoall'] == 1) { $obs = expSession::get('order_export_values'); foreach ($obs as $ob) { $order_ids[] = $ob->id; } } else { foreach ($this->params['act-upon'] as $order_id) { $order_ids[] = $order_id; } } $order_ids = array_unique($order_ids); $orders_string = implode(',', $order_ids); $payment_summary = array(); // $Credit Cards $sql = "SELECT orders_id, billing_cost, billing_options, calculator_name, user_title FROM " . DB_TABLE_PREFIX . "_billingmethods, " . DB_TABLE_PREFIX . "_billingcalculator WHERE " . DB_TABLE_PREFIX . "_billingcalculator.id = billingcalculator_id and orders_id IN (" . $orders_string . ")"; $res = $db->selectObjectsBySql($sql); if (!empty($res)) { foreach ($res as $item) { $options = unserialize($item->billing_options); if (!empty($item->billing_cost)) { if ($item->user_title == 'Credit Card') { if (!empty($options->cc_type)) { //@$payment_summary[$payments[$options->cc_type]] += $item->billing_cost; @($payment_summary[$payments[$options->cc_type]] += $options->result->amount_captured); } } else { @($payment_summary[$payments[$item->calculator_name]] += $item->billing_cost); } } } } foreach ($payment_summary as $key => $item) { $payments_key_arr[] = '"' . $key . '"'; $payment_values_arr[] = round($item, 2); } $payments_key = implode(",", $payments_key_arr); $payment_values = implode(",", $payment_values_arr); //tax $tax_sql = "SELECT SUM(tax) as tax_total FROM " . DB_TABLE_PREFIX . "_orders WHERE id IN (" . $orders_string . ")"; $tax_res = $db->selectObjectBySql($tax_sql); $tax_types = taxController::getTaxClasses(); $tax_type_formatted = $tax_types[0]->zonename . ' - ' . $tax_types[0]->classname . ' - ' . $tax_types[0]->rate . '%'; assign_to_template(array('payment_summary' => $payment_summary, 'payments_key' => $payments_key, 'payment_values' => $payment_values, 'tax_total' => $tax_res->tax_total, 'tax_type' => $tax_type_formatted)); }