protected function fieldRegion($jsAction = "")
{
$output = "";
$allRegions = Region::getAllRows();
echo "HERE";
$output .= "<select name=\"" . static::regionIdFieldName . "\" {$jsAction}>\n";
/* The following logic will determine the selected option */
/* Chose a do...while() in order to avoid code duplication for the 'selected' option logic */
$regionId = static::anyRegionCode;
$regionName = "Any region";
$firstRow = true;
do {
if (!$firstRow) {
$regionId = Region::getRegionId($row);
$regionName = Region::getRegionName($row);
} else {
$firstRow = false;
}
if ($this->searchedRegionId == $regionId) {
$selected = "selected";
} else {
$selected = "";
}
/* here is the actual option output */
$output .= " <option {$selected} value =\"{$regionId}\">{$regionName}</option>\n";
} while (($row = $allRegions->fetch_row()) != NULL);
$output .= "</select>\n";
return $output;
}
function encoder_redirect_success(Region $new_region)
{
$new_region_name = $new_region->getRegionName();
$dir = "VIEW/html/Encoder/Add_Place/Add_Place_Region_inc.php?success=1&Region_Name={$new_region_name}";
$url = BASE_URL . $dir;
header("Location:{$url}");
//redirect the encoder to the regions add place
exit;
}
public function insertRandomRow()
{
/* generate the field values */
/* first generate the random values, then add them to query */
$workTypeId = rand(1, WorkType::getRowsNumber());
$districtId = rand(1, District::getRowsNumber());
$jobSubCategoryId = rand(1, JobSubCategory::getRowsNumber());
$salaryLow = rand(20, 200) * 1000;
$salaryRange = rand(5, 30) * 1000;
$daysOffset = -60 + rand(1, 90);
$startDate = strtotime(sprintf("%+d", $daysOffset) . " day");
$endDate = strtotime(sprintf("%+d", $daysOffset + 30) . " day");
/* Processing this information */
$workType = WorkType::getWorkTypeName(WorkType::getWorkType($workTypeId));
$district = District::getDistrict($districtId);
$districtName = District::getDistrictName($district);
$regionName = Region::getRegionName(Region::getRegion(District::getRegionId($district)));
$jobSubCategory = JobSubCategory::getJobSubCategory($jobSubCategoryId);
$jobSubCategoryName = JobSubCategory::getJobSubCategoryName($jobSubCategory);
$jobCategoryId = JobSubCategory::getJobCategoryId($jobSubCategory);
$jobCategoryName = JobCategory::getJobCategoryName(JobCategory::getJobCategory($jobCategoryId));
$salaryHigh = $salaryLow + $salaryRange;
$jobTitle = "Job in {$regionName}";
$jobDescription = "{$jobSubCategoryName} " . strtolower($workType) . " job in {$districtName}, {$regionName}, in the domain of {$jobCategoryName}, salary from \${$salaryLow} to \${$salaryHigh}.\n";
$jobDescription .= "Posted on " . date("D, jS \\of F, Y", $startDate) . ", valid until " . date("D, jS \\of F, Y", $endDate);
/* Now build the query with the values generated above */
/* job_id */
$values = "NULL";
//AUTO_INCREMENT field
/* job_title */
$values .= ", '{$jobTitle}'";
/* job_description */
$values .= ", '{$jobDescription}'";
/* work_type_id */
$values .= ", '{$workTypeId}'";
/* district_id */
$values .= ", '{$districtId}'";
/* subcategory_id */
$values .= ", '{$jobSubCategoryId}'";
/* salary_low */
$values .= ", '{$salaryLow}'";
/* SalaryHihg */
$values .= ", '{$salaryHigh}'";
/* start_ad_date */
/* format: '2013-05-14 00:00:00' */
$values .= ", '" . date("Y-m-d 00:00:00", $startDate) . "'";
/* end_ad_date */
$values .= ", '" . date("Y-m-d 00:00:00", $endDate) . "'";
/* Build the query */
$query = Job::insertRowQuery($values);
return $query;
}
/**
* @param Region $region
* @return bool
* this function will add the region to the data base
* takes region parameter
*/
function Add_Region(Region $region)
{
$Region_Name = $region->getRegionName();
$Region_Name_Amharic = $region->getRegionNameAmharic();
//add the region to the region database
$query = "INSERT INTO region (Name,Name_Amharic) VALUES('{$Region_Name}','{$Region_Name_Amharic}')";
$result = mysqli_query($this->getDbc(), $query);
if ($result) {
return TRUE;
} else {
return FALSE;
}
}
public static function getRegion($job)
{
/* job -> DistrictId => District row -> RegionId => Region row -> region_name */
/* -> is array access; => is query access */
return Region::getRegionName(Region::getRegion(District::getRegionId(District::getDistrict(self::getDistrictId($job)))));
}
function Edit_Region(Region $region, $Region_ID)
{
$Name = $region->getRegionName();
$Name_Amharic = $region->getRegionNameAmharic();
$query = "UPDATE Region set Name='{$Name}',Name_Amharic='{$Name_Amharic}' where ID='{$Region_ID}'";
$result = mysqli_query($this->getDbc(), $query);
//if the company is deleted return true
if ($result) {
return TRUE;
} else {
return FALSE;
}
}