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