/**
* Lập phiếu xin chi
*/
public function addreqpaymentAction()
{
$form = new \Accounting\Form\Transaction\ReqRecieve($this->getServiceLocator());
$this->getViewModel()->setVariable('form', $form);
$companyId = $this->getRequest()->getPost('companyId');
if (!$this->user()->getUser()->isAdmin()) {
$companyId = $this->user()->getCompanyId();
}
$expenseCategory = new \Accounting\Model\ExpenseCategory();
$expenseCategory->setCompanyId($companyId);
$expenseCategoryMapper = $this->getServiceLocator()->get('\\Accounting\\Model\\ExpenseCategoryMapper');
$tree = new \Home\Model\Tree();
$categoryValueOptions = $tree->toSelectBoxArray($expenseCategoryMapper->fetchAll($expenseCategory));
$this->getViewModel()->setVariable('categoryValueOptions', $categoryValueOptions);
if ($this->getRequest()->isPost()) {
$form->setData($this->getRequest()->getPost());
if ($form->isValid()) {
$formData = $form->getData();
$transaction = new \Accounting\Model\Transaction();
$transaction->exchangeArray($formData);
$transaction->setType(\Accounting\Model\Transaction::TYPE_PAYMENT);
$transaction->setCreatedDate(DateBase::getCurrentDate());
$transaction->setCreatedDateTime(DateBase::getCurrentDateTime());
$transaction->setCreatedById($this->user()->getIdentity());
$transaction->setStatus(\Accounting\Model\Transaction::STATUS_NEW);
$transactionMapper = $this->getServiceLocator()->get('\\Accounting\\Model\\TransactionMapper');
$transactionMapper->save($transaction);
$itemMapper = $this->getServiceLocator()->get('\\Accounting\\Model\\Transaction\\ItemMapper');
if (isset($formData['itemData']) && count($formData['itemData'])) {
foreach ($formData['itemData'] as $itemData) {
$item = new \Accounting\Model\Transaction\Item();
$item->exchangeArray($itemData);
$item->setTransactionId($transaction->getId());
$item->setStatus($transaction->getStatus());
$item->setTransactionDate($transaction->getApplyDate());
$itemMapper->save($item);
}
}
if ($form->get('afterSubmit')->getValue()) {
return $this->redirect()->toUrl($form->get('afterSubmit')->getValue());
}
return $this->redirect()->toUrl('/accounting/transaction/index');
}
}
return $this->getViewModel();
}
/**
* @author KienNN
* @param \Accounting\Model\Transaction $item
*/
public function fetchAll($item)
{
$select = $this->getDbSql()->select(['t' => self::TABLE_NAME]);
if ($item->getItemId()) {
$select->where(['t.itemId' => $item->getItemId()]);
}
if ($item->getItemType()) {
$select->where(['t.itemType' => $item->getItemType()]);
}
$select->order(['t.id DESC']);
$rows = $this->getDbAdapter()->query($this->getDbSql()->buildSqlString($select), Adapter::QUERY_MODE_EXECUTE);
$result = [];
if ($rows->count()) {
foreach ($rows->toArray() as $row) {
$model = new \Accounting\Model\Transaction();
$model->exchangeArray($row);
$result[] = $model;
}
}
return $result;
// Nếu muốn load cái j ra nữa thì nhớ check option, vì cái này dùng chung nhiều, load nhiều nặng lắm
}
/**
* 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;
}
