/**
* 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;
}