/** * 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; } }