예제 #1
0
 /**
  *
  * @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;
 }