function getServiceAreaByRegionalId($regionalId)
{
$model_ServiceArea = new Model_ServiceArea();
$whereSA = array('RegionalId = ?' => $regionalId);
$serviceArea = $model_ServiceArea->getAll($whereSA);
foreach ($serviceArea as $keyRow => $valueData) {
foreach ($valueData as $keyData => $valueRow) {
if ($keyData == 'StateId' and $valueRow != NULL) {
$col = $keyData;
$where[] = array("{$keyData} = ?" => $valueRow);
} else {
if ($keyData == 'CityId' and $valueRow != NULL) {
$where[] = array("{$keyData} = ?" => $valueRow);
$col = $keyData;
} else {
if ($keyData == 'NeighborhoodId' and $valueRow != NULL) {
$where[] = array("{$keyData} = ?" => $valueRow);
$col = $keyData;
}
}
}
}
}
$array = array($where, $col);
return $array;
}
public function getAllEnterpriseByRegionalServiceArea($regionalId, $count = null, $offset = null, $filter = null)
{
$modelServiceArea = new Model_ServiceArea();
$dbTable_Enterprise = new DbTable_Enterprise();
$sa = $modelServiceArea->getAllServiceAreaByRegionalId($regionalId);
$indice = $sa['indice'];
$getAllEnterpriseQuery = $dbTable_Enterprise->getAllByColAE($sa['value'][$indice], $indice, null, 'select', $filter);
return Zend_Paginator::factory($getAllEnterpriseQuery)->setItemCountPerPage($count ? $count : null)->setCurrentPageNumber($offset ? $offset : 1);
}
