/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index(Request $request)
{
$keyword = $request->input('keyword') ? $request->input('keyword') : '';
$channels = [];
if ($request->input('keyword')) {
$channels = Channel::where('name', 'LIKE', '%' . spaceToLike($request->input('keyword')) . '%')->orderBy('order')->get();
} else {
$channels = Channel::orderBy('order')->get();
}
return view('admin.category.webboard', ['channels' => $channels, 'keyword' => $keyword]);
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$this->comment('Getting Main Channels');
$oldChannels = array(array('name' => 'columnists', 'description' => 'Columnists', 'icon' => 'fa-quote-right', 'color' => '#29639E'), array('name' => 'design', 'description' => 'Marketing & Design', 'icon' => 'fa-picture-o', 'color' => '#EFC050'), array('name' => 'fashion', 'description' => 'Fashion & Style', 'icon' => 'fa-umbrella', 'color' => '#C50161'), array('name' => 'food', 'description' => 'Food & Health', 'icon' => 'fa-coffee', 'color' => '#FF851B'), array('name' => 'society', 'description' => 'Society & Fun', 'icon' => 'fa-smile-o', 'color' => '#3D9970'), array('name' => 'politics', 'description' => 'Politics & News', 'icon' => 'fa-globe', 'color' => '#A76336'), array('name' => 'tech', 'description' => 'Tech & Business', 'icon' => 'fa-laptop', 'color' => '#6C88A0'), array('name' => 'media', 'description' => 'Music, TV & Film', 'icon' => 'fa-music', 'color' => '#02A7A7'));
foreach ($oldChannels as $key => $channel) {
$this->info('Creating Channel [ ' . $channel['name'] . ' ]');
Channel::create(['shorthand' => $channel['name'], 'description' => $channel['description'], 'color' => $channel['color']]);
}
////////////////////////////
//Now Import Sub Channels //
////////////////////////////
$subChannels = array('style' => 'fashion', 'health' => 'food', 'family' => 'society', 'business' => 'tech', 'music' => 'media', 'tv' => 'media', 'film' => 'media', 'advertising' => 'design', 'photography' => 'design', 'art' => 'design');
foreach ($subChannels as $subChannel => $channel) {
// get id of parent channel;
$id = Channel::where('shorthand', $channel)->first()->id;
$this->info('Creating SubChannel [ ' . $subChannel . ' ]');
Channel::create(['shorthand' => $subChannel, 'parent_id' => $id]);
}
}
public function getCurrentMessage($user_id)
{
$user = User::where('url', $user_id)->first();
if ($user) {
$channel = Channel::where('user_id', $user->id)->first();
if ($channel) {
$json['status'] = "success";
$json['message'] = $channel->message;
return json_encode($json);
} else {
$json['status'] = "success";
$json['message'] = "Awaiting message from " . $user_id;
return json_encode($json);
}
} else {
$json['status'] = "fail";
$json['message'] = "Invalid user id: " . $user_id;
return json_encode($json);
}
}
public static function getCache($channel = null)
{
$cacheKey = 'last200' . $channel . 'posts';
if (!Cache::has($cacheKey)) {
// if no cache exists
if (is_null($channel)) {
// if all posts (no channel)
$tempPosts = Post::with('source')->with('scores')->orderBy('publishing_date', 'desc')->take(200)->get()->chunk(20);
} else {
// channel
$tempPosts = Channel::where('shorthand', $channel)->first()->posts()->with('source')->with('scores')->orderBy('publishing_date', 'desc')->take(200)->get()->chunk(20);
}
// if no results, return false
if ($tempPosts->count() == 0) {
return false;
}
// If all ok, cache results for 10 minutes
Cache::put($cacheKey, $tempPosts, 10);
}
return Cache::get($cacheKey);
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
// get sources from the old Lebanese blogs
$sources = @file_get_contents('http://lebaneseblogs.com/sources/' . getenv('PASS'));
$sources = json_decode($sources);
foreach ($sources as $key => $source) {
$this->info('Adding Source [ ' . $source->blog_name . ' ]');
// map old columns to new columns
$newSource = Source::create(['shorthand' => $source->blog_id, 'name' => $source->blog_name, 'description' => $source->blog_description, 'url' => $source->blog_url, 'author' => $source->blog_author, 'author_twitter' => $source->blog_author_twitter_username, 'rss_feed' => $source->blog_rss_feed, 'active' => $source->blog_RSSCrawl_active]);
// channels
$oldChannels = preg_split('#\\s*,\\s*#', $source->blog_tags);
$newChannels = [];
foreach ($oldChannels as $key => $oldChannel) {
// If this channel exists, add it.
if (Channel::where('shorthand', $oldChannel)->get()->count()) {
$newChannels[] = Channel::where('shorthand', $oldChannel)->first()->id;
}
}
// Now associate source with list of channels;
$newSource->channels()->sync($newChannels);
}
$this->comment('Import complete: Total Sources Added: ' . count($sources));
}
public static function getChannelName($channel_id)
{
$channel = Channel::where('id', '=', $channel_id)->firstOrFail();
return $channel['name'];
}
public static function exists($channel)
{
return Channel::where('shorthand', $channel)->get()->count() > 0;
}
public function goInactive()
{
$channel = Channel::where('user_id', Auth::user()->id)->first();
if ($channel) {
$channel->last_active = 0;
$channel->save();
}
if ($channel) {
$json['status'] = "success";
return json_encode($json);
} else {
$json['status'] = "fail";
return json_encode($json);
}
}
public function saveAccessTokenToChannel($accessToken, $channelId)
{
$channel = Channel::where('channel_id', $channelId)->first();
$channel->access_token = $accessToken;
$channel->save();
}
