public function indexAction()
 {
     $form = new \Accounting\Form\AccountFilter($this->getServiceLocator());
     $form->setData($this->params()->fromQuery());
     $this->getViewModel()->setVariable('form', $form);
     if ($form->isValid()) {
         $account = new Account();
         $account->exchangeArray($form->getData());
         $account->addOption('loadUser', true);
         $account->addOption('loadCompany', true);
         if (!$this->user()->getUser()->isAdmin()) {
             $account->addOption('companyId', $this->user()->getCompanyId());
         }
         if (!$this->user()->getCompanyId()) {
             return $this->page403();
         }
         $accountMapper = $this->getServiceLocator()->get('Accounting\\Model\\AccountMapper');
         $tree = new Tree();
         $accounttrees = $tree->toArrayRecusived($accountMapper->fetchAll($account));
         $this->getViewModel()->setVariable('paginator', $accounttrees);
     }
     return $this->getViewModel();
 }
 /**
  *
  * @author Hungpx
  * @param \Accounting\Model\Account $item
  */
 public function fetchAll($item)
 {
     $select = $this->getDbSql()->select(array('c' => self::TABLE_NAME));
     if ($item->getId()) {
         $select->where(['c.id' => $item->getId()]);
     } elseif ($item->getOption('ids')) {
         $select->where(['c.id' => $item->getOption('ids')]);
     }
     if ($item->getCompanyId()) {
         $select->where(['c.companyId' => $item->getCompanyId()]);
     }
     if ($item->getOption('companyId')) {
         $select->where(['c.companyId' => $item->getOption('companyId')]);
     }
     if ($item->getName()) {
         $select->where(['c.name LIKE ?' => '%' . $item->getName() . '%']);
     }
     if ($item->getOption('sort')) {
         $select->order([implode(' ', $item->getOption('sort'))]);
     } else {
         $select->order(['c.id' => 'DESC']);
     }
     $query = $this->getDbSql()->buildSqlString($select);
     $results = $this->getDbAdapter()->query($query, Adapter::QUERY_MODE_EXECUTE);
     $paginator = [];
     $userIds = [];
     $companyIds = [];
     $accountIds = [];
     if ($results->count()) {
         foreach ($results as $row) {
             $row = (array) $row;
             $account = new Account();
             $account->exchangeArray($row);
             $paginator[] = $account;
             if ($account->getCreatedById()) {
                 $userIds[$account->getCreatedById()] = $account->getCreatedById();
             }
             if ($account->getCompanyId()) {
                 $companyIds[$account->getCompanyId()] = $account->getCompanyId();
             }
             $accountIds[$account->getId()] = $account->getId();
         }
     }
     if ($item->getOption('fetchOnlyIds')) {
         return $accountIds;
     }
     $userNames = [];
     $companyNames = [];
     // get User's name
     if (count($userIds) && $item->getOption('loadUser')) {
         $select = $this->getDbSql()->select(['c' => \User\Model\UserMapper::TABLE_NAME], ['id', 'fullName']);
         $select->where(['c.id' => $userIds]);
         $query = $this->getDbSql()->buildSqlString($select);
         $results = $this->getDbAdapter()->query($query, Adapter::QUERY_MODE_EXECUTE);
         unset($select);
         if ($results) {
             $resultArr = $results->toArray();
             foreach ($resultArr as $result) {
                 $userNames[$result['id']] = $result['fullName'];
             }
         }
     }
     // Get Company
     if (count($companyIds) && $item->getOption('loadCompany')) {
         $select = $this->getDbSql()->select(['cp' => \Company\Model\CompanyMapper::TABLE_NAME], ['id', 'name']);
         $select->where(['cp.id' => $companyIds]);
         $query = $this->getDbSql()->buildSqlString($select);
         $results = $this->getDbAdapter()->query($query, Adapter::QUERY_MODE_EXECUTE);
         unset($select);
         if ($results) {
             $resultArr = $results->toArray();
             foreach ($resultArr as $result) {
                 $companyNames[$result['id']] = $result['name'];
             }
         }
     }
     foreach ($paginator as $account) {
         $userId = $account->getCreatedById();
         $companyId = $account->getCompanyId();
         $itemId = $account->getId();
         $account->addOption('userName', isset($userNames[$userId]) ? $userNames[$userId] : null);
         $account->addOption('companyName', isset($companyNames[$companyId]) ? $companyNames[$companyId] : null);
     }
     return $paginator;
 }
 public function loadAction()
 {
     $companyId = $this->getRequest()->getPost('companyId');
     if (!$companyId) {
         $companyId = $this->user()->getCompanyId();
     } elseif (!$this->company()->canManage($companyId)) {
         return $this->getJsonModel()->setVariables(array('code' => 0, 'messages' => ['Bạn không có quyền quản lí doanh nghiệp này']));
     }
     $modeLoad = $this->getRequest()->getPost('modeLoad');
     $accountIds = [];
     $accountMapper = $this->getServiceLocator()->get('\\Accounting\\Model\\AccountMapper');
     if ($modeLoad && $modeLoad == 'basic') {
         $account = new \Accounting\Model\Account();
         $account->setCompanyId($companyId);
         $accountIds = $accountMapper->recusiveBranchChildIds($account, [\Accounting\Model\Account::ID_CASH]);
     }
     $account = new \Accounting\Model\Account();
     if (count($accountIds)) {
         $account->addOption('ids', $accountIds);
     } else {
         $account->setCompanyId($companyId);
         $account->addOption('loadSystemAccount', true);
     }
     $tree = new \Home\Model\Tree();
     $accounts = $tree->toArrayRecusived($accountMapper->fetchAll($account));
     $data = [];
     if ($accounts) {
         foreach ($accounts as $account) {
             $data[] = array('id' => $account->getId(), 'name' => $account->getName(), 'code' => $account->getCode(), 'ord' => $account->getOption('ord'), 'displayName' => str_repeat('--', $account->getOption('ord') ?: 0) . $account->getName());
         }
     }
     return $this->getJsonModel()->setVariables(array('code' => 1, 'data' => $data));
 }