File: /home/temp/yarusvl.ru/adminx/core/CurrencyAdmin.php
<?php
require_once('api/Mgc.php');
class CurrencyAdmin extends Mgc {
public function fetch() {
// Обработка действий
if($this->request->method('post')) {
/*Формирование данных с валютами*/
foreach($this->request->post('currency') as $n=>$va) {
foreach($va as $i=>$v) {
if(empty($currencies[$i])) {
$currencies[$i] = new stdClass;
}
$currencies[$i]->$n = $v;
}
}
$wrong_iso = array();
$currencies_ids = array();
/*Добавление/Удаление валюты*/
foreach($currencies as $currency) {
if(!preg_match('(^[a-zA-Z]{1,3}$)',$currency->code)) {
$wrong_iso[] = $currency->name;
}
if ($currency->id) {
$this->money->update_currency($currency->id, $currency);
} else {
$currency->id = $this->money->add_currency($currency);
}
$currencies_ids[] = $currency->id;
}
if(count($wrong_iso) > 0) {
$this->design->assign('message_error', 'wrong_iso');
$this->design->assign('wrong_iso', $wrong_iso);
}
// Удалить непереданные валюты
$query = $this->db->placehold('DELETE FROM __currencies WHERE id NOT IN(?@)', $currencies_ids);
$this->db->query($query);
// Пересчитать курсы
$old_currency = $this->money->get_currency();
$new_currency = reset($currencies);
if($old_currency->id != $new_currency->id) {
$coef = $new_currency->rate_from/$new_currency->rate_to;
/*Пересчет цен по курсу валюты*/
if($this->request->post('recalculate') == 1) {
$this->db->query("UPDATE __variants SET price=price*?, compare_price=compare_price*? where currency_id=0", $coef, $coef);
$this->db->query("UPDATE __delivery SET price=price*?, free_from=free_from*?", $coef, $coef);
$this->db->query("UPDATE __orders SET delivery_price=delivery_price*?", $coef);
$this->db->query("UPDATE __orders SET total_price=total_price*?", $coef);
$this->db->query("UPDATE __purchases SET price=price*?", $coef);
$this->db->query("UPDATE __coupons SET value=value*? WHERE type='absolute'", $coef);
$this->db->query("UPDATE __coupons SET min_order_price=min_order_price*?", $coef);
$this->db->query("UPDATE __orders SET coupon_discount=coupon_discount*?", $coef);
}
$this->db->query("UPDATE __currencies SET rate_from=1.0*rate_from*$new_currency->rate_to/$old_currency->rate_to");
$this->db->query("UPDATE __currencies SET rate_to=1.0*rate_to*$new_currency->rate_from/$old_currency->rate_from");
$this->db->query("UPDATE __currencies SET rate_to = rate_from WHERE id=?", $new_currency->id);
$this->db->query("UPDATE __currencies SET rate_to = 1, rate_from = 1 WHERE (rate_to=0 OR rate_from=0) AND id=?", $new_currency->id);
}
// Отсортировать валюты
asort($currencies_ids);
$i = 0;
foreach($currencies_ids as $currency_id) {
$this->money->update_currency($currencies_ids[$i], array('position'=>$currency_id));
$i++;
}
// Действия с выбранными
$action = $this->request->post('action');
$id = $this->request->post('action_id');
if(!empty($action) && !empty($id)) {
switch($action) {
case 'disable': {
/*Выключить валюту*/
$this->money->update_currency($id, array('enabled'=>0));
break;
}
case 'enable': {
/*Включить валюту*/
$this->money->update_currency($id, array('enabled'=>1));
break;
}
case 'show_cents': {
/*Показывать копейки*/
$this->money->update_currency($id, array('cents'=>2));
break;
}
case 'hide_cents': {
/*Не показывать копейки*/
$this->money->update_currency($id, array('cents'=>0));
break;
}
case 'delete': {
/*Удалить валюту*/
$this->money->delete_currency($id);
break;
}
}
}
}
// Отображение
$currencies = $this->money->get_currencies();
$currency = $this->money->get_currency();
$this->design->assign('currency', $currency);
$this->design->assign('currencies', $currencies);
return $this->design->fetch('currency.tpl');
}
}