/**
  *
  * @author Hungpx
  * @param \Accounting\Model\ExpenseCategory $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() . '%']);
     }
     $select->order(['c.companyId' => 'DESC']);
     $query = $this->getDbSql()->buildSqlString($select);
     $results = $this->getDbAdapter()->query($query, Adapter::QUERY_MODE_EXECUTE);
     $paginator = [];
     $userIds = [];
     $companyIds = [];
     $ids = [];
     if ($results->count()) {
         foreach ($results as $row) {
             $row = (array) $row;
             $category = new ExpenseCategory();
             $category->exchangeArray($row);
             $paginator[] = $category;
             if ($category->getCreatedById()) {
                 $userIds[$category->getCreatedById()] = $category->getCreatedById();
             }
             if ($category->getCompanyId()) {
                 $companyIds[$category->getCompanyId()] = $category->getCompanyId();
             }
             $ids[$category->getId()] = $category->getId();
         }
     }
     if ($item->getOption('fetchOnlyIds')) {
         return $ids;
     }
     $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 $category) {
         $userId = $category->getCreatedById();
         $companyId = $category->getCompanyId();
         $itemId = $category->getId();
         $category->addOption('userName', isset($userNames[$userId]) ? $userNames[$userId] : null);
         $category->addOption('companyName', isset($companyNames[$companyId]) ? $companyNames[$companyId] : null);
     }
     return $paginator;
 }
 /**
  *
  * @author Hungpx
  * @param \Accounting\Model\ExpenseCategory $item
  */
 public function checkunique($item)
 {
     $error = '';
     if ($item->getId()) {
         return $error;
     }
     if ($item->getCompanyId() && $item->getCode()) {
         $select = $this->getDbSql()->select(self::TABLE_NAME);
         $select->where(['companyId' => $item->getCompanyId(), 'code' => $item->getCode()]);
         $query = $this->getDbSql()->buildSqlString($select);
         $results = $this->getDbAdapter()->query($query, Adapter::QUERY_MODE_EXECUTE);
         if ($results->count()) {
             $error = 'code';
             return $error;
         }
     }
     if ($item->getCompanyId() && $item->getName()) {
         $select = $this->getDbSql()->select(self::TABLE_NAME);
         $select->where(['companyId' => $item->getCompanyId(), 'name' => $item->getName()]);
         $query = $this->getDbSql()->buildSqlString($select);
         $results = $this->getDbAdapter()->query($query, Adapter::QUERY_MODE_EXECUTE);
         if ($results->count()) {
             $error = 'name';
             return $error;
         }
     }
     return $error;
 }