Hey,
I am trying to resize an image that i am getting from a complex query. I have tried a few ways but not been successful. This is what i have at the moment. I cant get it to work. Is there any other way?
PHP:
function ShowHomeVacancies(){
$sqlQuery = new SQLQuery();
$sqlQuery->select = array(
'Vacancy.*',
'VacancyCategory.vCategory As vCategoryName',
'SiteTree.URLSegment As vURLSegment',
'(SELECT Member.Company FROM Member Where Member.ID= Vacancy.MyEmployerID) AS Employer',
'(SELECT Member.MemberLogoID FROM Member Where Member.ID= Vacancy.MyEmployerID) AS EmployerLogo',
'(SELECT Filename FROM File LEFT JOIN Member ON File.ID = Member.MemberLogoID WHERE Member.ID= Vacancy.MyEmployerID) AS Logo',
'Vacancy.hasLogo AS hasLogo'
);
$sqlQuery->from = array(
"Vacancy",
"LEFT JOIN VacancyCategory ON Vacancy.MyCategoryID = VacancyCategory.ID",
"LEFT JOIN VacancyCategoryPage ON Vacancy.MyCategoryID = VacancyCategoryPage.vCategoryID ",
"LEFT JOIN SiteTree ON VacancyCategoryPage.ID = SiteTree.ID"
);
$sqlQuery->where = array(
"vActive = true "
);
//$sqlQuery->orderby = "Vacancy.ID DESC";
$sqlQuery->limit = "0, 5";
$result = $sqlQuery->execute();
$pagedVacancies = singleton('Vacancy')->buildDataObjectSet($result);
return $pagedVacancies;
}
function eLogo($ID){
return ($img = DataObject::get_by_id("Image", $ID) ? $img : false);
}
SS Code:
<% if ShowHomeVacancies %>
<% control ShowHomeVacancies %>
<div class="VacancyListItem $EvenOdd">
<% if hasLogo = 1 %>
<% control eLogo($EmployerLogo).SetWidth(80) %>
<img src="$URL" alt="Company Logo" />
<% end_control %>
<% end_if %>
<h2><a href="/$vURLSegment/show/$ID">$vTitle</a></h2>
<p><span class="bold">Location: </span>$vLocation</p>
<p><span class="bold">Salary: </span>$vSalary</p>
<p>$vDescription.LimitWordCount(30)</p>
<p><span class="bold">Sector: </span><a href="/$vURLSegment/">$vCategoryName</a></p>
</div>
<% end_control %>
<% end_if %>