WebSVN – LeadersLinked - Services – Diff – /module/LeadersLinked/src/Mapper/RecruitmentSelectionVacancyMapper.php

 use LeadersLinked\Model\RecruitmentSelectionVacancy;
 use LeadersLinked\Hydrator\ObjectPropertyHydrator;
 use Laminas\Paginator\Paginator;
 use Laminas\Db\ResultSet\HydratingResultSet;
 use Laminas\Paginator\Adapter\DbSelect;
+use Laminas\Db\Sql\Expression;
 class RecruitmentSelectionVacancyMapper extends MapperCommon
         $paginator->setCurrentPageNumber($page);
+        return $paginator;
+    }*/
+    /**
+     *
+     * @param int $company_id
+     * @return int
+     */
+    public function fetchCountByCompanyId($company_id)
+    {
+        $select = $this->sql->select(self::_TABLE);
+        $select->columns(['total' => new Expression('COUNT(*)')]);
+        $select->where->equalTo('company_id', $company_id);
+        $select->where->equalTo('status', RecruitmentSelectionVacancy::STATUS_ACTIVE);
+        $select->where->greaterThanOrEqualTo('last_date', new Expression('date(now())'));
+        $record = $this->executeFetchOneArray($select);
+        return $record['total'];
         return $paginator;
     }*/

Proyectos de Subversion LeadersLinked - Services