/**
* Update an existing account
*
* @param array $input
* An array as follows: array('id' => $id, 'key'=>$key, 'name'=>$name, 'balance_type'=>$balanceType, 'is_group'=>$isGroup,
* 'account_type_id'=>$accountTypeId, 'parent_account_id'=>$parentAccountId, 'parent_account' => $parentAccount
* 'account_type' => $accountType, 'parent_account' => $parentAccount
* );
*
* @return JSON encoded string
* A string as follows:
* In case of success: {"success" : form.defaultSuccessUpdateMessage}
*/
public function update(array $input)
{
$newParentAccount = $input['parent_account'];
$newAccountType = $input['account_type'];
$groupsAccounts = $info = false;
unset($input['_token'], $input['parent_account'], $input['balance_type_name'], $input['account_type']);
$input = eloquent_array_filter_for_update($input);
// $input['date'] = $this->Carbon->createFromFormat($this->Lang->get('form.phpShortDateFormat'), $input['date'])->format('Y-m-d');
if ($this->getAccountChildrenCount($input['id']) > 0 && $input['is_group'] == 0) {
return json_encode(array('info' => $this->Lang->get('decima-accounting::account-management.isGroupException')));
}
$this->DB->transaction(function () use(&$input, $newParentAccount, $newAccountType, &$groupsAccounts, &$info) {
$Account = $this->Account->byId($input['id']);
$unchangedAccountValues = $Account->toArray();
if (rtrim($input['key']) != rtrim($Account->key) && $this->Account->byOrganizationAndByKey($this->AuthenticationManager->getCurrentUserOrganizationId(), $input['key'])->count() > 0) {
$info = $this->Lang->get('decima-accounting::account-management.keyValidationMessage', array('key' => $input['key']));
return;
}
$this->Account->update($input, $Account);
if (!empty($input['is_group'])) {
$groupsAccounts = $this->getGroupsAccounts();
}
$diff = 0;
foreach ($input as $key => $value) {
if ($unchangedAccountValues[$key] != $value) {
$diff++;
if ($diff == 1) {
$Journal = $this->Journal->create(array('journalized_id' => $Account->id, 'journalized_type' => $this->Account->getTable(), 'user_id' => $this->AuthenticationManager->getLoggedUserId(), 'organization_id' => $this->AuthenticationManager->getCurrentUserOrganizationId()));
}
if ($key == 'balance_type') {
$this->Journal->attachDetail($Journal->id, array('field' => $this->Lang->get('decima-accounting::account-management.balanceType'), 'field_lang_key' => 'decima-accounting::account-management.balanceType', 'old_value' => $this->Lang->get('decima-accounting::account-management.' . $unchangedAccountValues[$key]), 'new_value' => $this->Lang->get('decima-accounting::account-management.' . $value)), $Journal);
} else {
if ($key == 'account_type_id') {
$oldAccountType = $this->AccountType->byId($unchangedAccountValues[$key]);
$this->Journal->attachDetail($Journal->id, array('field' => $this->Lang->get('decima-accounting::account-management.accountType'), 'field_lang_key' => 'decima-accounting::account-management.accountType', 'old_value' => $oldAccountType->name, 'new_value' => $newAccountType), $Journal);
} else {
if ($key == 'parent_account_id') {
if (!empty($unchangedAccountValues[$key])) {
$OldParentAccount = $this->Account->byId($unchangedAccountValues[$key]);
$oldParentAccount = $OldParentAccount->key . ' ' . $OldParentAccount->name;
} else {
$oldParentAccount = '';
}
$this->Journal->attachDetail($Journal->id, array('field' => $this->Lang->get('decima-accounting::account-management.parentAccount'), 'field_lang_key' => 'decima-accounting::account-management.parentAccount', 'old_value' => $oldParentAccount, 'new_value' => $newParentAccount), $Journal);
} else {
if ($key == 'is_group') {
$this->Journal->attachDetail($Journal->id, array('field' => $this->Lang->get('decima-accounting::account-management.isGroupLong'), 'field_lang_key' => 'decima-accounting::account-management.isGroupLong', 'old_value' => $this->Lang->get('decima-accounting::account-management.' . $unchangedAccountValues[$key]), 'new_value' => $this->Lang->get('decima-accounting::account-management.' . $value)), $Journal);
} else {
$this->Journal->attachDetail($Journal->id, array('field' => $this->Lang->get('decima-accounting::account-management.' . camel_case($key)), 'field_lang_key' => 'decima-accounting::account-management.' . camel_case($key), 'old_value' => $unchangedAccountValues[$key], 'new_value' => $value), $Journal);
}
}
}
}
}
}
});
if (!$info) {
return json_encode(array('success' => $this->Lang->get('form.defaultSuccessUpdateMessage'), 'groupsAccounts' => $groupsAccounts));
} else {
return json_encode(array('info' => $info));
}
}
/**
* Update an existing cost center
*
* @param array $input
* An array as follows: array('id' => $id, 'key'=>$key, 'name'=>$name, 'balance_type'=>$balanceType, 'is_group'=>$isGroup,
* 'parent_cc_id'=>$parentCostCenterId, 'parent_cc' => $parentCostCenter
* );
*
* @return JSON encoded string
* A string as follows:
* In case of success: {"success" : form.defaultSuccessUpdateMessage}
*/
public function update(array $input)
{
$newParentCostCenter = $input['parent_cc'];
$groupsCostCenters = $info = false;
unset($input['_token'], $input['parent_cc']);
$input = eloquent_array_filter_for_update($input);
if ($this->getCostCenterChildrenCount($input['id']) > 0 && $input['is_group'] == 0) {
return json_encode(array('info' => $this->Lang->get('decima-accounting::cost-center-management.isGroupException')));
// return json_encode(array('validationFailed' => true , 'fieldValidationMessages' => array('is-group' => $this->Lang->get('decima-accounting::cost-center-management.isGroupException'))));
}
$this->DB->transaction(function () use(&$input, $newParentCostCenter, &$groupsCostCenters, &$info) {
$CostCenter = $this->CostCenter->byId($input['id']);
$unchangedCostCenterValues = $CostCenter->toArray();
if (rtrim($input['key']) != rtrim($CostCenter->key) && $this->CostCenter->byOrganizationAndByKey($this->AuthenticationManager->getCurrentUserOrganizationId(), $input['key'])->count() > 0) {
$info = $this->Lang->get('decima-accounting::cost-center-management.keyValidationMessage', array('key' => $input['key']));
return;
}
$this->CostCenter->update($input, $CostCenter);
if (!empty($CostCenter->is_group)) {
$groupsCostCenters = $this->getGroupsCostCenters();
}
$diff = 0;
foreach ($input as $key => $value) {
// var_dump($unchangedCostCenterValues);die();
if ($unchangedCostCenterValues[$key] != $value) {
$diff++;
if ($diff == 1) {
$Journal = $this->Journal->create(array('journalized_id' => $CostCenter->id, 'journalized_type' => $this->CostCenter->getTable(), 'user_id' => $this->AuthenticationManager->getLoggedUserId(), 'organization_id' => $this->AuthenticationManager->getCurrentUserOrganizationId()));
}
if ($key == 'parent_cc_id') {
if (!empty($unchangedCostCenterValues[$key])) {
$OldParentcostCenter = $this->CostCenter->byId($unchangedCostCenterValues[$key]);
$oldParentcostCenter = $OldParentcostCenter->key . ' ' . $OldParentcostCenter->name;
} else {
$oldParentcostCenter = '';
}
$this->Journal->attachDetail($Journal->id, array('field' => $this->Lang->get('decima-accounting::cost-center-management.parentCc'), 'field_lang_key' => 'decima-accounting::cost-center-management.parentCc', 'old_value' => $oldParentcostCenter, 'new_value' => $newParentCostCenter), $Journal);
} else {
if ($key == 'is_group') {
$this->Journal->attachDetail($Journal->id, array('field' => $this->Lang->get('decima-accounting::cost-center-management.isGroupLong'), 'field_lang_key' => 'decima-accounting::cost-center-management.isGroupLong', 'old_value' => $this->Lang->get('decima-accounting::account-management.' . $unchangedCostCenterValues[$key]), 'new_value' => $this->Lang->get('decima-accounting::account-management.' . $value)), $Journal);
} else {
$this->Journal->attachDetail($Journal->id, array('field' => $this->Lang->get('decima-accounting::account-management.' . camel_case($key)), 'field_lang_key' => 'decima-accounting::account-management.' . camel_case($key), 'old_value' => $unchangedCostCenterValues[$key], 'new_value' => $value), $Journal);
}
}
}
}
});
if (!$info) {
return json_encode(array('success' => $this->Lang->get('form.defaultSuccessUpdateMessage'), 'groupsCostCenters' => $groupsCostCenters));
} else {
return json_encode(array('info' => $info));
}
}
/**
* Update an existing ...
*
* @param array $input
* An array as follows: array('id' => $id, 'field0'=>$field0, 'field1'=>$field1
*
* @return JSON encoded string
* A string as follows:
* In case of success: {"success" : form.defaultSuccessUpdateMessage}
*/
public function update(array $input)
{
unset($input['_token']);
$input = eloquent_array_filter_for_update($input);
// $input['date'] = $this->Carbon->createFromFormat($this->Lang->get('form.phpShortDateFormat'), $input['date'])->format('Y-m-d');
$this->DB->transaction(function () use(&$input) {
$VoucherType = $this->VoucherType->byId($input['id']);
$unchangedVoucherTypeValues = $VoucherType->toArray();
$this->VoucherType->update($input, $VoucherType);
$diff = 0;
foreach ($input as $key => $value) {
if ($unchangedVoucherTypeValues[$key] != $value) {
$diff++;
if ($diff == 1) {
$Journal = $this->Journal->create(array('journalized_id' => $VoucherType->id, 'journalized_type' => $this->VoucherType->getTable(), 'user_id' => $this->AuthenticationManager->getLoggedUserId(), 'organization_id' => $this->AuthenticationManager->getCurrentUserOrganizationId()));
}
if ($key == 'name') {
$this->Journal->attachDetail($Journal->id, array('field' => $this->Lang->get('decima-accounting::voucher-type-management.name'), 'field_lang_key' => 'decima-accounting::voucher-type-management.name', 'old_value' => $this->Lang->get($unchangedVoucherTypeValues[$key]), 'new_value' => $this->Lang->get($value)), $Journal);
} else {
$this->Journal->attachDetail($Journal->id, array('field' => $this->Lang->get('decima-accounting::voucher-type-management.' . camel_case($key)), 'field_lang_key' => 'decima-accounting::voucher-type-management.' . camel_case($key), 'old_value' => $unchangedVoucherTypeValues[$key], 'new_value' => $value), $Journal);
}
}
}
});
return json_encode(array('success' => $this->Lang->get('form.defaultSuccessUpdateMessage')));
}
/**
* Update an existing journal entry
*
* @param array $input
* An array as follows: array('journal_entry_id' => $journalEntryId, 'debit'=>$debit, 'credit'=>$credit, 'system_reference_type'=>$systemReferenceType, 'system_reference_field'=>$systemReferenceField,
* 'journal_voucher_id'=> journalVoucherId, 'cost_center_id'=>$costCenterId, 'account_id' => $accountId
* );
*
* @return JSON encoded string
* A string as follows:
* In case of success: {"success" : form.defaultSuccessUpdateMessage, "statusLabel": $statusLabel, "status": $status}
*/
public function updateJournalEntry(array $input, $Journal = null)
{
$journalNumber = $input['number'];
$unchangedInputValues = $input;
$input['id'] = $input['journal_entry_id'];
unset($input['_token'], $input['cost_center'], $input['account'], $input['number'], $input['journal_entry_id']);
$input = eloquent_array_filter_for_update($input);
$input['debit'] = remove_thousands_separator($input['debit']);
$input['credit'] = remove_thousands_separator($input['credit']);
$JournalVoucher = $this->JournalVoucher->byId($input['journal_voucher_id']);
$Period = $this->Period->byId($JournalVoucher->period_id);
if ($Period->is_closed) {
return json_encode(array('success' => false, 'info' => $this->Lang->get('decima-accounting::journal-management.closedPeriodValidationMessage2', array('period' => $this->Lang->get('decima-accounting::period-management.' . $Period->month)))));
}
$this->DB->transaction(function () use(&$input, $journalNumber, $unchangedInputValues, &$status, $Journal) {
$JournalEntry = $this->JournalEntry->byId($input['id']);
$unchangedJournalEntryValues = $JournalEntry->toArray();
$this->JournalEntry->update($input, $JournalEntry);
$diff = 0;
foreach ($input as $key => $value) {
if ($unchangedJournalEntryValues[$key] != $value) {
$diff++;
if ($diff == 1) {
if (empty($Journal)) {
$Journal = $this->Journal->create(array('journalized_id' => $JournalEntry->journal_voucher_id, 'journalized_type' => $this->JournalVoucher->getTable(), 'user_id' => $this->AuthenticationManager->getLoggedUserId(), 'organization_id' => $this->AuthenticationManager->getCurrentUserOrganizationId()));
}
}
if ($key == 'cost_center_id') {
$CostCenter = $this->CostCenter->byId($value);
$this->Journal->attachDetail($Journal->id, array('field' => $this->Lang->get('decima-accounting::journal-management.costCenter'), 'field_lang_key' => 'decima-accounting::journal-management.costCenter', 'old_value' => $unchangedInputValues['cost_center'], 'new_value' => $CostCenter->key . ' ' . $CostCenter->name), $Journal);
} else {
if ($key == 'account_id') {
$Account = $this->Account->byId($value);
$this->Journal->attachDetail($Journal->id, array('field' => $this->Lang->get('decima-accounting::journal-management.account'), 'field_lang_key' => 'decima-accounting::journal-management.account', 'old_value' => $unchangedInputValues['account'], 'new_value' => $Account->key . ' ' . $Account->name), $Journal);
} else {
$this->Journal->attachDetail($Journal->id, array('field' => $this->Lang->get('decima-accounting::journal-management.' . camel_case($key)), 'field_lang_key' => 'decima-accounting::journal-management.' . camel_case($key), 'old_value' => $unchangedJournalEntryValues[$key], 'new_value' => $value), $Journal);
}
}
}
}
if (empty($Journal)) {
$status = $this->updateJournalVoucherStatus($JournalEntry->journal_voucher_id);
} else {
$status = $this->updateJournalVoucherStatus($JournalEntry->journal_voucher_id, $Journal);
}
});
return json_encode(array('success' => $this->Lang->get('form.defaultSuccessUpdateMessage'), 'status' => $status, 'statusLabel' => $this->Lang->get('decima-accounting::journal-management.' . $status)));
}
