/**
* Проверка корректности подсчёта баланса
*/
public function testStat()
{
$login = '******' . mktime();
$pass = '******';
$options = array('user_login' => $login, 'user_pass' => sha1($pass), 'user_active' => 1, 'user_new' => 0, 'user_currency_default' => myMoney::UAH);
CreateObjectHelper::makeUser($options);
$user = new oldUser($login, $pass);
// Счета
$options = array('user_id' => $user->getId(), 'account_name' => 'USD Account For stat test', 'account_currency_id' => myMoney::USD);
$account = CreateObjectHelper::makeAccount($options);
$operation = new Operation_Model($user);
$options = array('user_id' => $user->getId());
$catId = CreateObjectHelper::createCategory($options);
$dateFrom = '2009-12-29';
$dateTo = '2010-01-02';
$rate = sfConfig::get('ex')->getRate(myMoney::UAH, myMoney::USD);
$usdSpent = 100;
$uahSpent = $usdSpent / $rate;
$opId = $operation->add(Operation::TYPE_EXPENSE, $usdSpent, '2010-01-01', $catId, 'Комментарий', $account['account_id'], array('тег 1'));
$stat = $operation->getOperationList($dateFrom, $dateTo, null, null, -1, null, null, null, true);
$this->assertEquals(round($uahSpent, 2), round(abs($stat), 2), 'Expected 100 dollars have been spent');
}
/**
* Редактирует событие
* @param $args array mixed Какие-нибудь аргументы
* @return void
*/
function edit(array $args = array())
{
//тип редактируемой операции
$operationId = 0;
$operation = array();
if (array_key_exists(0, $args) && is_numeric($args[0]) && $args[0]) {
$operationId = (int) $args[0];
} elseif (isset($this->request->post['id']) && $this->request->post['id']) {
$operationId = $this->request->post['id'];
}
// Получаем данные по редактируемой операции (а если нет ид, то и даных фиг..)
if ($operationId) {
$operation = $this->model->getOperation(Core::getInstance()->user->getId(), $operationId);
$initType = $operation['type'];
} else {
$operation = array();
}
if (_Core_Request::getCurrent()->method == 'POST') {
// Определяем массив данных для обработки
$operation = array('id' => $operationId, 'type' => isset($this->request->post['type']) ? $this->request->post['type'] : $operation['type'], 'account' => $this->request->post['account'], 'amount' => $this->request->post['amount'], 'category' => isset($this->request->post['category']) ? $this->request->post['category'] : null, 'date' => null, 'comment' => isset($this->request->post['comment']) ? $this->request->post['comment'] : '', 'tags' => isset($this->request->post['tags']) ? $this->request->post['tags'] : $operation['tags'], 'convert' => isset($this->request->post['convert']) ? $this->request->post['convert'] : array(), 'close' => isset($this->request->post['close']) ? $this->request->post['close'] : array(), 'currency' => isset($this->request->post['currency']) ? $this->request->post['currency'] : array(), 'toAccount' => isset($this->request->post['toAccount']) ? $this->request->post['toAccount'] : null, 'target' => isset($this->request->post['target']) ? $this->request->post['target'] : null, 'accepted' => isset($this->request->post['accepted']) ? (int) $this->request->post['accepted'] : 1);
// Если дата передана массивом (PDA) ...
if (is_array($this->request->post['date'])) {
$operation['date'] = $this->request->post['date']['day'] . '.' . $this->request->post['date']['month'] . '.' . $this->request->post['date']['year'];
} elseif (empty($this->request->post['date'])) {
$operation['date'] = date("d.m.Y");
} else {
$operation['date'] = $this->request->post['date'];
}
$operation = $this->model->checkData($operation);
if (is_null($operation['type'])) {
$this->model->errorData['id'] = 'Не удалось изменить операцию';
}
// Если нет ошибок - проводим операцию
if (count($this->model->errorData) == 0) {
//если изменили тип операции
if ($operation['type'] != $initType) {
if ($initType == Operation::TYPE_TARGET) {
$this->model->deleteTargetOperation($operation['id']);
} else {
$this->model->deleteOperation($operation['id']);
}
//удалили операцию. вот теперь создадим новую
switch ($operation['type']) {
//Расход
case Operation::TYPE_WASTE:
$operation['amount'] = abs($operation['amount']) * -1;
$this->model->add($operation['type'], $operation['amount'], $operation['date'], $operation['category'], $operation['comment'], $operation['account'], $operation['tags']);
break;
// Доход
// Доход
case Operation::TYPE_PROFIT:
$this->model->add($operation['type'], $operation['amount'], $operation['date'], $operation['category'], $operation['comment'], $operation['account'], $operation['tags']);
break;
// Перевод со счёта
// Перевод со счёта
case Operation::TYPE_TRANSFER:
$operation['category'] = -1;
$this->model->addTransfer($operation['amount'], $operation['convert'], $operation['currency'], $operation['date'], $operation['account'], $operation['toAccount'], $operation['comment'], $operation['tags']);
break;
// Перевод на финансовую цель
// Перевод на финансовую цель
case Operation::TYPE_TARGET:
$target = new Targets_Model();
$target->addTargetOperation($operation['account'], $operation['target'], $operation['amount'], $operation['comment'], $operation['date'], $operation['close']);
//@FIXME Сделать автоматическое получение нового списка операций, при удачном добавлении
//exit(json_encode($target->getLastList(0, 100)));
break;
}
}
// а иначе редактируем по старому, конкретную операцию
switch ($operation['type']) {
case Operation::TYPE_WASTE:
//Расход
$operation['amount'] = abs($operation['amount']) * -1;
$this->model->edit($operation['type'], $operation['id'], $operation['amount'], $operation['date'], $operation['category'], $operation['comment'], $operation['account'], $operation['tags']);
break;
case Operation::TYPE_PROFIT:
//Доход
$operation['amount'] = abs($operation['amount']);
$this->model->edit($operation['type'], $operation['id'], $operation['amount'], $operation['date'], $operation['category'], $operation['comment'], $operation['account'], $operation['tags']);
break;
case Operation::TYPE_TRANSFER:
// Перевод со счёта
$operation['category'] = null;
$this->model->editTransfer($operation['id'], $operation['amount'], $operation['convert'], $operation['date'], $operation['account'], $operation['toAccount'], $operation['comment'], $operation['tags']);
break;
case Operation::TYPE_TARGET:
// Перевод на финансовую цель см. в модуле фин.цели
$target = new Targets_Model();
$target->editTargetOperation($operation['id'], $operation['amount'], $operation['date'], $operation['target'], $operation['account'], $operation['comment'], $operation['close']);
break;
}
// #856. fixed by Jet. выводим разные сообщения для обычной и PDA версии
$text = '';
if (_Core_TemplateEngine::getResponseMode($this->request) == "json") {
$text = "Операция успешно изменена.";
} else {
$text = "Операция успешно изменена. <a href='/operation/last'>последние операции</a>";
}
$this->tpl->assign('result', array('text' => $text));
} else {
$this->tpl->assign('error', array('text' => implode(" \n", $this->model->errorData)));
}
}
// Переделываем дату изменённую в checkData для вставки в mysql обратно в человеческий вид
$operation['date'] = date('d.m.Y', strtotime($operation['date']));
$this->tpl->assign('operation', $operation);
$this->tpl->assign('name_page', 'operations/edit');
}
/**
* Закрывает финцель
*
* @param int $targetId
* @param int $targetCat
* @param float $amount
* @param int $account
* @return int ИД расходной операции
*/
public function CloseOp($targetId = 0, $targetCat = 0, $amount = 0, $account = 0)
{
// Обновляем данные финцели
$userId = Core::getInstance()->user->getId();
$sql = "UPDATE target SET done=1 WHERE id = ? AND user_id = ?";
$result = $this->db->select($sql, $targetId, $userId);
$sql = "SELECT * FROM target WHERE id = ? AND user_id = ?";
$target = $this->db->select($sql, $targetId, $userId);
$title = addslashes($target[0]['title']);
$comment = "Закрытие финансовой цели \\'{$title}\\'";
$category = null;
$date = date('Y-m-d');
// Делаем фактическую операцию перевода на финцель.
$operation = new Operation_Model(Core::getInstance()->user);
$operationId = $operation->add(0, -$amount, $date, $category, $comment, $account, null, false);
return $operation->getOperation($userId, $operationId);
}
