public function paymentAction()
{
$id = $this->getRequest()->getQuery('id');
if (!$id) {
return $this->getViewModel()->setVariable('errorMsg', ['Không tìm thấy phiếu thu chi']);
}
$transaction = new \Accounting\Model\Transaction();
$transaction->setId($id);
$transactionMapper = $this->getServiceLocator()->get('\\Accounting\\Model\\TransactionMapper');
if (!$transactionMapper->get($transaction)) {
return $this->getViewModel()->setVariable('errorMsg', ['Không tìm thấy phiếu thu chi']);
}
if (!in_array($transaction->getStatus(), [\Accounting\Model\Transaction::STATUS_ACCOUNTING])) {
return $this->getViewModel()->setVariable('errorMsg', ['Phiếu chưa được hạch toán, không thể kí chi thu']);
}
$form = new \Accounting\Form\Transaction\ApproveReq($this->getServiceLocator());
$form->setData($transaction->toFormValue());
$form->setCompanyId($transaction->getCompanyId());
$form->setId($transaction->getId());
$this->getViewModel()->setVariable('form', $form);
if ($this->getRequest()->isPost()) {
$form->setData($this->getRequest()->getPost());
if ($form->isValid()) {
$formData = $form->getData();
$transaction->exchangeArray($formData);
$transaction->setPaymentById($this->user()->getIdentity());
$transaction->setPaymentDateTime(DateBase::getCurrentDateTime());
$transaction->setStatus(\Accounting\Model\Transaction::STATUS_PAYMENT);
$transactionMapper->save($transaction);
if (isset($formData['itemData']) && count($formData['itemData'])) {
$transactionItemMapper = $this->getServiceLocator()->get('\\Accounting\\Model\\Transaction\\ItemMapper');
foreach ($formData['itemData'] as $itemData) {
$transactionItem = new \Accounting\Model\Transaction\Item();
$transactionItem->exchangeArray($itemData);
$transactionItem->setTransactionDate($transaction->getApplyDate());
$transactionItem->setTransactionId($transaction->getId());
$transactionItem->setStatus($transaction->getStatus());
$transactionItemMapper->save($transactionItem);
}
}
return $this->redirect()->toUrl('/accounting/transaction/index?id=' . $transaction->getId());
}
}
$this->getViewModel()->setVariable('transaction', $transaction);
$transactionItem = new \Accounting\Model\Transaction\Item();
$transactionItem->setTransactionId($transaction->getId());
$transactionItem->addOption('loadAccountId', true);
$transactionItem->addOption('loadExpenseCategory', true);
$transactionItemMapper = $this->getServiceLocator()->get('\\Accounting\\Model\\Transaction\\ItemMapper');
$items = $transactionItemMapper->fetchAll($transactionItem);
$this->getViewModel()->setVariable('items', $items);
$company = new \Company\Model\Company();
$company->setId($transaction->getCompanyId());
$companyMapper = $this->getServiceLocator()->get('\\Company\\Model\\CompanyMapper');
if ($companyMapper->get($company)) {
$this->getViewModel()->setVariable('company', $company);
}
$userMapper = $this->getServiceLocator()->get('\\User\\Model\\UserMapper');
$this->getViewModel()->setVariable('createdBy', $userMapper->get($transaction->getCreatedById()));
if ($transaction->getApprovedById()) {
$this->getViewModel()->setVariable('approveBy', $userMapper->get($transaction->getApprovedById()));
}
if ($transaction->getAccountingById()) {
$this->getViewModel()->setVariable('accountingBy', $userMapper->get($transaction->getAccountingById()));
}
$expenseCategory = new \Accounting\Model\ExpenseCategory();
$expenseCategory->setCompanyId($transaction->getCompanyId());
$expenseCategoryMapper = $this->getServiceLocator()->get('\\Accounting\\Model\\ExpenseCategoryMapper');
$tree = new \Home\Model\Tree();
$this->getViewModel()->setVariable('categories', $tree->toArrayRecusived($expenseCategoryMapper->fetchAll($expenseCategory)));
$account = new \Accounting\Model\Account();
$account->setCompanyId($transaction->getCompanyId());
$account->addOption('sort', ['sort' => 'c.id', 'dir' => 'ASC']);
$accountMapper = $this->getServiceLocator()->get('\\Accounting\\Model\\AccountMapper');
$this->getViewModel()->setVariable('accounts', $tree->toArrayRecusived($accountMapper->fetchAll($account)));
return $this->getViewModel();
}
/**
* @author KienNN
* @param \Accounting\Model\Transaction $item
* Từ transaction tìm lại hợp đồng
* Tính toán tỉ lệ ăn chia với từng nhân viên [employeeId => amount]
* + nếu đã tồn tại payment (salemanId + transactionId) thì update lại thông tin cho payment
* + nếu không thì tạo mới payment
* Xóa đi những payment ko dc tính
*/
public function recalculatePayment($item)
{
if (!$item->getId() || !$item->getAmount() || !$item->getItemId() || $item->getItemType() != \Accounting\Model\Transaction::ITEM_TYPE_CRM_CONTRACT || !in_array($item->getStatus(), [\Accounting\Model\Transaction::STATUS_ACCOUNTING, \Accounting\Model\Transaction::STATUS_PAYMENT])) {
return null;
}
// lấy ra các sản phẩm trong hợp đồng
$product = new \Crm\Model\Contract\Product();
$product->setContractId($item->getItemId());
$productMapper = $this->getServiceLocator()->get('\\Crm\\Model\\Contract\\ProductMapper');
$products = $productMapper->fetchAll($product);
// lấy commission
$commission = new \Crm\Model\Contract\Commission();
$commission->setContractId($item->getItemId());
$commissionMapper = $this->getServiceLocator()->get('\\Crm\\Model\\Contract\\CommissionMapper');
$commissions = $commissionMapper->fetchAll($commission);
// lấy ra các payment cũ của transaction
$select = $this->getDbSql()->select(['p' => \Crm\Model\Contract\PaymentMapper::TABLE_NAME]);
$select->join(['e' => \Hrm\Model\EmployeeMapper::TABLE_NAME], 'e.userId=p.salemanId', ['employeeId' => 'id']);
$select->where(['p.transactionId' => $item->getId()]);
$rowPays = $this->getDbAdapter()->query($this->getDbSql()->buildSqlString($select), Adapter::QUERY_MODE_EXECUTE);
$paymentToDeletes = [];
if ($rowPays->count()) {
foreach ($rowPays->toArray() as $rowPay) {
$paymentToDeletes[$rowPay['employeeId']] = new \Crm\Model\Contract\Payment($rowPay);
}
}
// lấy ra tài khoản kế toán của phiếu thu
$select = $this->getDbSql()->select(['ti' => \Accounting\Model\Transaction\ItemMapper::TABLE_NAME]);
$select->where(['ti.transactionId' => $item->getId()]);
$select->limit(1);
$row = $this->getDbAdapter()->query($this->getDbSql()->buildSqlString($select), Adapter::QUERY_MODE_EXECUTE);
$row = (array) $row->current();
$accountingAccountId = null;
if ($row['debitAccountId']) {
$accountingAccountId = $row['debitAccountId'];
} elseif ($row['creditAccountId']) {
$accountingAccountId = $row['creditAccountId'];
}
$accountingAccount = new \Accounting\Model\Account();
$accountingAccount->setId($accountingAccountId);
$accountingAccountMapper = $this->getServiceLocator()->get('\\Accounting\\Model\\AccountMapper');
$accountingAccountMapper->get($accountingAccount);
// tính toán ra số tiền cho từng nhân viên
$paymentAmounts = \Crm\Model\Contract\Payment::breakToCommission($item->getAmount(), $products, $commissions);
$employeeMapper = $this->getServiceLocator()->get('\\Hrm\\Model\\EmployeeMapper');
$paymentMapper = $this->getServiceLocator()->get('\\Crm\\Model\\Contract\\PaymentMapper');
foreach ($paymentAmounts as $employeeId => $amount) {
// lấy ra user của employee
$employee = new \Hrm\Model\Employee();
$employee->setId($employeeId);
$employeeMapper->get($employee);
if ($employee->getUserId()) {
$payment = new \Crm\Model\Contract\Payment();
$payment->setTransactionId($item->getId());
$payment->setSalemanId($employee->getUserId());
if ($paymentMapper->isExistedInTransaction($payment)) {
/** nếu payment đã tồn tại chỉ update lại amount */
$payment->setAmount($amount);
$paymentMapper->save($payment);
unset($paymentToDeletes[$employeeId]);
} else {
/** nếu payment chưa tồn tại thì tạo mới */
$payment->setAmount($amount);
$payment->setAccountingAccountId($accountingAccountId);
$payment->setDescription($item->getDescription());
$payment->setCompanyId($employee->getCompanyId());
$payment->setDepartmentId($employee->getDepartmentId());
$payment->setContractId($item->getItemId());
if ($accountingAccount->getType() == \Accounting\Model\Account::TYPE_CASH) {
$payment->setType(\Crm\Model\Contract\Payment::TYPE_CASH);
} else {
$payment->setType(\Crm\Model\Contract\Payment::TYPE_MONEY_TRANSFER);
}
$payment->setStatus(\Crm\Model\Contract\Payment::STATUS_CHECKED);
$payment->setCheckedById($item->getAccountingById());
$payment->setCheckedDate($item->getApplyDate());
$payment->setCheckedDateTime($item->getAccountingDateTime());
$payment->setCreatedById($item->getAccountingById());
$payment->setCreatedDateTime($item->getAccountingDateTime());
$paymentMapper->save($payment);
}
}
}
/** Xóa các payment thừa */
if (count($paymentToDeletes)) {
foreach ($paymentToDeletes as $payment) {
$delete = $this->getDbSql()->delete(\Crm\Model\Contract\PaymentMapper::TABLE_NAME);
$delete->where(['id' => $payment->getId()]);
$this->getDbAdapter()->query($this->getDbSql()->buildSqlString($delete), Adapter::QUERY_MODE_EXECUTE);
}
}
}
/**
* Chỉ rà soát trong 1 khoảng thời gian nhất định
* Rà soát các transaction trong thời gian quy định
* Tình toán ra commission theo từng nhân viên
* Xóa các payment có transactionId=transaction.id
* Tạo mới payment
*
*/
public function recalculatepaymentAction()
{
$fromDate = '2015-08-01';
$transactionId = $this->getRequest()->getQuery('transactionId');
$dbAdapter = $this->getServiceLocator()->get('dbAdapter');
$dbSql = $this->getServiceLocator()->get('dbSql');
$select = $dbSql->select(['t' => \Accounting\Model\TransactionMapper::TABLE_NAME]);
$select->join(['ti' => \Accounting\Model\Transaction\ItemMapper::TABLE_NAME], 't.id=ti.transactionId', ['accountingAccountId' => new Expression('IFNULL(ti.creditAccountId, ti.debitAccountId)')]);
$select->where(['createdDate >= ?' => $fromDate]);
if ($transactionId) {
$select->where(['t.id' => $transactionId]);
}
$query = $dbSql->buildSqlString($select);
//echo $query;die;
$rows = $dbAdapter->query($query, Adapter::QUERY_MODE_EXECUTE);
$commissionMapper = $this->getServiceLocator()->get('\\Crm\\Model\\Contract\\CommissionMapper');
$productMapper = $this->getServiceLocator()->get('\\Crm\\Model\\Contract\\ProductMapper');
$employeeMapper = $this->getServiceLocator()->get('\\Hrm\\Model\\EmployeeMapper');
$paymentMapper = $this->getServiceLocator()->get('\\Crm\\Model\\Contract\\PaymentMapper');
$accountingAccountMapper = $this->getServiceLocator()->get('\\Accounting\\Model\\AccountMapper');
if ($rows->count()) {
foreach ($rows->toArray() as $row) {
$transaction = new \Accounting\Model\Transaction();
$transaction->exchangeArray($row);
$accountingAccount = new \Accounting\Model\Account();
$accountingAccount->setId($row['accountingAccountId']);
$accountingAccountMapper->get($accountingAccount);
/** tính toán commission */
// lấy ra các sản phẩm trong hợp đồng
$product = new \Crm\Model\Contract\Product();
$product->setContractId($transaction->getItemId());
$products = $productMapper->fetchAll($product);
// lấy commission
$commission = new \Crm\Model\Contract\Commission();
$commission->setContractId($transaction->getItemId());
$commissions = $commissionMapper->fetchAll($commission);
$paymentAmounts = \Crm\Model\Contract\Payment::breakToCommission($transaction->getAmount(), $products, $commissions);
/** Xóa các payment có transactionId=transaction.id */
$delete = $dbSql->delete(\Crm\Model\Contract\PaymentMapper::TABLE_NAME);
$delete->where(['transactionId' => $transaction->getId()]);
$dbAdapter->query($dbSql->buildSqlString($delete), Adapter::QUERY_MODE_EXECUTE);
/** Tạo mới payment */
echo '<b>Tạo payment từ transaction ' . $transaction->getId() . '</b><br/>';
foreach ($paymentAmounts as $employeeId => $amount) {
// lấy ra user của employee
$employee = new \Hrm\Model\Employee();
$employee->setId($employeeId);
$employeeMapper->get($employee);
if ($employee->getUserId()) {
$select = $dbSql->select(['p' => \Crm\Model\Contract\PaymentMapper::TABLE_NAME]);
$select->where(['transactionId' => $transaction->getId()]);
$select->where(['salemanId' => $employee->getUserId()]);
$select->limit(1);
$rowP = $dbAdapter->query($dbSql->buildSqlString($select), Adapter::QUERY_MODE_EXECUTE);
if ($rowP->count()) {
$rowP = (array) $rowP->current();
$payment = new \Crm\Model\Contract\Payment();
$payment->exchangeArray($rowP);
$payment->setAmount($amount);
$paymentMapper->save($payment);
echo '<p style="">Update payment ' . $payment->getId() . ' - amount: ' . $rowP['amount'] . ' -> ' . $payment->getAmount() . '</p><br/>';
} else {
$payment = new \Crm\Model\Contract\Payment();
$payment->setAmount($amount);
$payment->setSalemanId($employee->getUserId());
$payment->setAccountingAccountId($accountingAccount->getId());
$payment->setTransactionId($transaction->getId());
$payment->setDescription($transaction->getDescription());
$payment->setCompanyId($employee->getCompanyId());
$payment->setDepartmentId($employee->getDepartmentId());
$payment->setContractId($transaction->getItemId());
if ($accountingAccount->getType() == \Accounting\Model\Account::TYPE_CASH) {
$payment->setType(\Crm\Model\Contract\Payment::TYPE_CASH);
} else {
$payment->setType(\Crm\Model\Contract\Payment::TYPE_MONEY_TRANSFER);
}
if (in_array($transaction->getStatus(), [\Accounting\Model\Transaction::STATUS_ACCOUNTING, \Accounting\Model\Transaction::STATUS_PAYMENT])) {
$payment->setStatus(\Crm\Model\Contract\Payment::STATUS_CHECKED);
} elseif (in_array($transaction->getStatus(), [\Accounting\Model\Transaction::STATUS_NEW, \Accounting\Model\Transaction::STATUS_APPROVED])) {
$payment->setStatus(\Crm\Model\Contract\Payment::STATUS_UNCHECKED);
} else {
$payment->setStatus(\Crm\Model\Contract\Payment::STATUS_DELETED);
}
$payment->setCheckedById($transaction->getAccountingById());
$payment->setCheckedDate($transaction->getApplyDate());
$payment->setCheckedDateTime($transaction->getAccountingDateTime());
$payment->setCreatedById($transaction->getAccountingById() ?: $transaction->getCreatedById());
$payment->setCreatedDateTime($transaction->getAccountingDateTime() ?: $transaction->getCreatedDate() . ' ' . $transaction->getCreatedTime());
$paymentMapper->save($payment);
echo '--<span style="color:red;">Tạo mới payment ' . $payment->getId() . '</span></br/>';
echo '--------User: '******'<br/>';
echo '--------Amount: ' . $payment->getAmount() . '/ ' . $transaction->getAmount() . '<br/>';
}
}
}
}
}
die;
}
