/**
* main call to build profile of title
*
* @return array
*/
public function profile()
{
$this->getIMDBMetadata();
$sqlQuery = "SELECT catalogue.*, member.ID as MID, member.Email, member.FirstName, member.Surname \r\n FROM catalogue \r\n LEFT JOIN member ON catalogue.Owner = member.ID \r\n WHERE catalogue.ID = '{$this->id}'";
$records = DB::query($sqlQuery);
if ($records) {
$set = new ArrayList();
foreach ($records as $record) {
$record['lastupdatedreadable'] = parent::humanTiming($record['LastEdited']);
$record['seasonLinks'] = $this->seasonLinks($record['Seasons']);
$record['displayComments'] = parent::displayComments($record['Comments']);
$set->push(new ArrayData($record));
}
return $set;
}
}
public function television()
{
$keywords = $this->getKeywords();
Requirements::customScript('
var availableKeywords = [
' . $keywords . '
];
$(function() {
$(".keywordsText").autocomplete({
source: availableKeywords,
minLength: 3,
select: function(event, ui) {
$(".keywordsText").trigger("input");
},
html: true, // optional (jquery.ui.autocomplete.html.js required)
});
});
');
$sqlQuery = "SELECT catalogue.*, member.ID AS MID, member.Email, member.FirstName, member.Surname \r\n FROM catalogue \r\n LEFT JOIN member ON catalogue.Owner = member.ID \r\n WHERE catalogue.Video_type = 'series'\r\n AND catalogue.Owner = {$this->member}\r\n ORDER BY catalogue.Video_title";
$records = DB::query($sqlQuery);
//debug::dump($records->value());
if ($records) {
$set = new ArrayList();
foreach ($records as $record) {
$record['lastupdatedreadable'] = parent::humanTiming($record['LastEdited']);
$record['seasonLinks'] = str_replace('Season', '', $record['Seasons']);
$record['genres'] = $this->listFilmGenres($record['Genre']);
$set->push(new ArrayData($record));
}
return $set;
}
}
