public function getIndex()
{
$year = Year::current_year();
$sponsors = $year->sponsors()->orderBy('sponsor_year.sponsor_level', 'desc')->where('sponsor_year.sponsor_level', '!=', 'Affiliate')->get();
$news = News::orderBy('updated_at', 'desc')->first();
return View::make('home.index')->with('news', $news)->with('sponsors', $sponsors);
}
public function index()
{
$advice = \SecurityTip::orderBy(DB::raw("RAND()"))->first();
$news = \News::orderBy(DB::raw("RAND()"))->first();
$work = \Work::orderBy(DB::raw("RAND()"))->first();
return View::make('welcome/index', compact('news', 'work', 'advice'));
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function getIndex()
{
if (Session::get('user_level') < Config::get('cms.shopManager')) {
return Redirect::to(_l(URL::action('AdminHomeController@getIndex')));
}
$this->setLayout();
if (Input::get('q')) {
$products = Product::where(function ($query) {
$query->where('title', 'LIKE', '%' . Input::get('q') . '%')->orwhere('long_content', 'LIKE', '%' . Input::get('q') . '%')->orwhere('short_content', 'LIKE', '%' . Input::get('q') . '%');
})->orderBy('created_at', 'desc')->paginate(20);
} else {
$products = News::orderBy('created_at', 'desc')->paginate(20);
}
View::share('title', __(Lang::get('shop.products')));
View::share('products', $products);
$this->layout->content = View::make('backend.shop.product.index');
}
/**
* @param $limit
* @return mixed
*/
public function getLastNews($limit)
{
return $this->news->orderBy('created_at', 'desc')->where('lang', $this->getLang())->take($limit)->offset(0)->get();
}
public function getManageNews()
{
$query = News::orderBy('id', 'desc')->paginate(10);
$this->layout->content = View::make('admin.manage_news')->with('news', $query);
}
public function get_va()
{
//Pull our users VA data
$record = User::where('cid', '=', Auth::user()->get()->cid)->first();
// //Figure out what the last 4 months are and append -1 for the first day of the month
// $month = date('Y-m');
// $month .= '-1';
// $month1before = date('Y-m', strtotime('-1 month'));
// $month1before .= '-1';
// $month2before = date('Y-m', strtotime('-2 month'));
// $month2before .= '-1';
// $month3before = date('Y-m', strtotime('-3 month'));
// $month3before .= '-1';
// //Convert to unix time stamps to compare with the DB
// $month = strtotime($month);
// $month1before = strtotime($month1before);
// $month2before = strtotime($month2before);
// $month3before = strtotime($month3before);
//
// //Now let's store our month names in an array
// $clicks = array();
// $clicks['month_name'] = date("F", $month);
// $clicks['month1before_name'] = date("F", $month1before);
// $clicks['month2before_name'] = date("F", $month2before);
// $clicks['month3before_name'] = date("F", $month3before);
//
//
// //Count the data in the DB
// //Where data is greater than the first of this month and is associated with our logged in user.
// $month = Click::where('created_at', '>=', $month)->where('vid', '=', Auth::user()->get()->cid)->count();
// //Where data is greater than the first of last month, but less than the first of this month and is associated with our logged in user.
// $month1before = Click::where('created_at', '>=', $month1before)->where('created_at', '<', $month)->where('vid', '=', Auth::user()->get()->cid)->count();
// //You get the point :)
// $month2before = Click::where('created_at', '>=', $month2before)->where('created_at', '<', $month1before)->where('vid', '=', Auth::user()->get()->cid)->count();
// $month3before = Click::where('created_at', '>=', $month3before)->where('created_at', '<', $month2before)->where('vid', '=', Auth::user()->get()->cid)->count();
// //Add to our clicks array.
// $clicks['month'] = $month;
// $clicks['month1before'] = $month1before;
// $clicks['month2before'] = $month2before;
// $clicks['month3before'] = $month3before;
//Let's just keep it simple for now and get the total number of clicks
$clicks = Click::where('vid', '=', Auth::user()->get()->cid)->count();
//Pull our ticket information
$opentickets = Ticket::where('vid', '=', Auth::user()->get()->cid)->where('status', '=', '1')->orderBy('created_at', 'DESC')->get();
$openticketscount = count($opentickets);
$closedtickets = Ticket::where('vid', '=', Auth::user()->get()->cid)->where('status', '=', '0')->orderBy('created_at', 'DESC')->get();
$closedticketscount = count($closedtickets);
//Create our array
$tickets = array();
$tickets['opentickets'] = $opentickets;
$tickets['opentickets_count'] = $openticketscount;
$tickets['closedtickets'] = $closedtickets;
$tickets['closedtickets_count'] = $closedticketscount;
//Pull our replies
$tickets_request = Ticket::where('vid', '=', Auth::user()->get()->cid)->get();
$tids = array();
foreach ($tickets_request as $ticket_request) {
$tid = $ticket_request->id;
$tids[$tid] = $tid;
}
if (!empty($tids)) {
$replies = TicketReply::whereIn('tid', $tids)->orderBy('created_at', 'ASC')->get();
} else {
$replies = '';
}
$tickets['replies'] = $replies;
//Pull our Category data
$categories = Category::where('hidden', '!=', 1)->get();
//Check to see if there is a banner if so provide the source for it
if ($record->banner) {
$banner = User::getBannerUrl(Auth::user()->get()->cid);
} else {
//No banner we will set this as false so the views no not to try and display it.
$banner = FALSE;
}
//Get our news
$news = News::orderBy("updated_at", "DESC")->get();
//Create our view with the VA, clicks, categories and tickets data.
return View::make('va')->with(array('news' => $news, 'record' => $record, 'clicks' => $clicks, 'tickets' => $tickets, 'categories' => $categories, 'banner' => $banner));
}
public function home()
{
$news = News::orderBy('id', "DESC")->take(5)->get();
$this->layout->content = View::make('home')->with("news", $news);
}
public static function returnShortCodes()
{
$tpl = static::returnTpl();
shortcode::add("news", function ($params = null) use($tpl) {
#print_r($params); die;
if (!Allow::module('news')) {
return false;
}
## Параметры по-умолчанию
$default = array('tpl' => Config::get('app-default.news_template', 'default'), 'limit' => Config::get('app-default.news_count_on_page', 3), 'order' => Helper::stringToArray(News::$order_by), 'pagination' => 1, 'type' => false, 'exclude_type' => false, 'include' => false, 'exclude' => false);
## Применяем переданные настройки
$params = $params + $default;
#dd($params);
#echo $tpl.$params['tpl'];
if (empty($params['tpl']) || !View::exists($tpl . $params['tpl'])) {
throw new Exception('Template [' . $tpl . $params['tpl'] . '] not found.');
}
$news = News::orderBy('news.published_at', 'desc')->with('meta.photo', 'meta.gallery.photos', 'meta.seo');
/*
## Получаем новости, делаем LEFT JOIN с news_meta, с проверкой языка и тайтла
$selected_news = News::where('news.publication', 1)
->leftJoin('news_meta', 'news_meta.news_id', '=', 'news.id')
->where('news_meta.language', Config::get('app.locale'))
->where('news_meta.title', '!=', '')
->select('*', 'news.id AS original_id', 'news.published_at AS created_at')
->orderBy('news.published_at', 'desc');
#$selected_news = $selected_news->where('news_meta.wtitle', '!=', '');
## Получаем новости с учетом пагинации
#echo $selected_news->toSql(); die;
#var_dump($params['limit']);
$news = $selected_news->paginate($params['limit']); ## news list with pagination
#$news = $selected_news->get(); ## all news, without pagination
*/
/**
* Показываем новости только определенных типов
*/
if (@$params['type']) {
$params['types'] = (array) explode(',', $params['type']);
#Helper::d($params);
if (isset($params['types']) && is_array($params['types']) && count($params['types']) && Allow::module('dictionaries') && class_exists('DicVal')) {
$types = DicVal::whereIn('slug', $params['types'])->get();
#Helper::tad($types);
if ($types->count()) {
$types = $types->lists('id');
#Helper::tad($types);
if (count($types)) {
$news = $news->whereIn('type_id', $types);
}
}
}
}
/**
* Исключаем новости определенных типов
*/
if (@$params['exclude_type']) {
$params['exclude_types'] = (array) explode(',', $params['exclude_type']);
#Helper::d($params);
if (isset($params['exclude_types']) && is_array($params['exclude_types']) && count($params['exclude_types']) && Allow::module('dictionaries') && class_exists('DicVal')) {
$types = DicVal::whereIn('slug', $params['exclude_types'])->get();
#Helper::tad($types);
if ($types->count()) {
$types = $types->lists('id');
#Helper::tad($types);
if (count($types)) {
$news = $news->whereNotIn('type_id', $types);
}
}
}
}
/**
* Будем выводить только новости, ID которых указаны
*/
if (@$params['include']) {
$params['includes'] = (array) explode(',', $params['include']);
if (isset($params['includes']) && is_array($params['includes']) && count($params['includes'])) {
$news = $news->whereIn('id', $params['includes']);
}
}
/**
* Исключаем новости с заданными ID
*/
if (@$params['exclude']) {
$params['excludes'] = (array) explode(',', $params['exclude']);
if (isset($params['excludes']) && is_array($params['excludes']) && count($params['excludes'])) {
$news = $news->whereNotIn('id', $params['excludes']);
}
}
$news = $news->paginate($params['limit']);
#Helper::tad($news);
/*
foreach ($news as $n => $new) {
#print_r($new); die;
$gall = Rel_mod_gallery::where('module', 'news')->where('unit_id', $new->original_id)->first();
#foreach ($gall->photos as $photo) {
# print_r($photo->path());
#}
#print_r($gall->photos); die;
$new->gall = @$gall;
$new->image = is_object(@$gall->photos[0]) ? @$gall->photos[0]->path() : "";
$news[$n]->$new;
}
*/
#echo $news->count(); die;
if (!$news->count()) {
return false;
}
return View::make($tpl . $params['tpl'], compact('news'));
});
}
public function siteMap_xml()
{
try {
$page = Pages::where("_name", "=", "sitemap")->get()->first();
$pages = Pages::where('_dependsOn', "=", NULL)->where("_public", "=", "1")->orderBy('_priority', 'DESC')->get();
$news = News::orderBy('_date', 'DESC')->get();
} catch (Exception $e) {
App::abort(500);
}
$header = '<?xml version="1.0" encoding="UTF-8"?>';
// Renvoi de la vue avec les news et l'en-tête :
$page = $this->layout->content = View::make('pages.sitemap.sitemap_xml', array("news" => $news, "pages" => $pages, "header" => $header));
return Response::make($page, '200')->header('Content-Type', 'text/xml');
}
public function get_news()
{
$news = News::orderBy("updated_at", "DESC")->get();
return View::make('console.news')->with(array("news" => $news));
}
