Видимо решений нет, а НАДА.
<?php
defined('_JEXEC') or die('Restricted access');
global $my, $db , $database, $mainframe;
$database =& JFactory::getDBO();
echo 'Сумма с налогами: ';
echo $tax_total = $db->f("order_tax") + $db->f("order_shipping_tax"); //laczna kwota podatkow
echo '<br>Сумма дисконта: ';
echo $discount_total = $db->f("coupon_discount") + $db->f("order_discount"); //laczna kwota obnizek cen
echo '<br>Стоимость доставки: ';
echo $transport = $db->f("order_shipping"); //koszty transportu
echo '<br>Итого оплачено: ';
echo $amount = round( $db->f("order_subtotal")+$tax_total-$discount_total+$transport, 2); //suma zamowienia
echo '<br>';
$order_id = $db->f("order_id") ;
$order_item_sku = $db->f("order_item_sku") ;
$order_item_name = $db->f("order_item_name") ;
echo $b = round( $db->f("order_subtotal")+$tax_total-$discount_total, 2);
if( @get_class( $db )!= 'ps_DB' ) $db = new ps_DB();
//echo $kwota = $db->order_total;
//print_r ($db);
//echo '<br><br><br>';
//print_r ($database);
$row = null;
$sql = "SELECT * FROM jos_vode_credits WHERE userid='$my->id'";
$database->setQuery( $sql );
$row = $database->loadObject();
print_r ($row);
echo $row->credit;
//if ($row->credit > $b) {
if ($row->credit > $amount) {
$database->setQuery( "UPDATE #__vode_credits SET credit=credit-'$amount' WHERE userid='$my->id' " );
$database->query();
echo '<br />Операция успешно выполнена!';
$database->setQuery( "UPDATE `jos_vm_orders` SET `order_status` = 'C' WHERE `jos_vm_orders`.`order_id` = '$order_id' " );
$database->query();
/*
$database->setQuery( "INSERT INTO `movie` ( `userid` , `sku` , `orderid` , `item_name` , `date` , `accessed` , `Status` )
VALUES ( '$my->id', '$order_item_sku', '$order_id', '$order_item_name', '', '0', 'C' ); ");
$database->query();
*/
// extra
//parameter for function order_status_update
$d = array ("order_id" => $order_id,
"notify_customer" => "Y",
"order_status" => "C",
"current_order_status" => "P");
require_once ($mosConfig_absolute_path.'/administrator/components/com_virtuemart/classes/ps_order.php');
$ps_order= new ps_order;
$ps_order->order_status_update($d);
//end
} else {
$database->setQuery( "UPDATE `jos_vm_orders` SET `order_status` = 'R' WHERE `jos_vm_orders`.`order_id` = '$order_id' " );
$database->query();
echo '<br /><b/>Лицевой счет';
echo '<br /><a href="index.php?option=com_vodes">Пополнить счет</a>';
}
?>
24.12.2015, 11:29:51