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