public function run ()
{
DB::table('advertises')->delete();
Advertise::create([
'code' => 'banner_1',
'type' => 'index_banner',
'url' => '/imgs/carousel/banner_1.jpg',
'seq' => 1,
'active' => 1,
'link' => '/text/bouninfo'
]);
Advertise::create([
'code' => 'banner_2',
'type' => 'index_banner',
'url' => '/imgs/carousel/banner_2.jpg',
'seq' => 2,
'active' => 1,
'link' => '/home#buy'
]);
Advertise::create([
'code' => 'banner_3',
'type' => 'index_banner',
'url' => '/imgs/carousel/banner_3.jpg',
'seq' => 3,
'active' => 1,
'link' => '/home#buy'
]);
}
public function getIndex(Request $request)
{
$page = $request->input('page');
$type = $request->input('type');
$code = $request->input('code');
$offset = 20;
$query = Advertise::where('id', '>', 0);
if (!empty($type)) {
$query->where('type', '=', $type);
}
if (!empty($code)) {
$query->where('code', '=', $code);
}
$count = $query->count();
$pages = ceil($count / $offset);
$page = !empty($page) ? $page > $pages ? $pages : $page < 1 ? 1 : $page : 1;
$ads = $query->skip(($page - 1) * $offset)->take($offset)->get();
$data = ['pageName' => '广告位管理', 'current_page' => $page, 'pages' => $pages, 'ads' => $ads, 'route' => $this->route];
return view('admin/advertise_board', $data);
}
/**
* Show the application dashboard to the user.
*
* @return Response
*/
public function index(Request $request)
{
$goodDatas = Good::orderBy('id', 'desc')->get();
$goods = array();
$banners = Advertise::where('type', '=', 'index_banner')
->where('active', '=', 1)
->orderBy('seq', 'asc')
->get();
foreach ($goodDatas as $good) {
$gInfo = GoodAttribsInfo::where('gid', '=', $good->id)
->where('acode', '=', 'price')
->first();
$good->price = $gInfo->value;
array_push($goods, $good);
}
$homeGoodsDisplay = array();
foreach ($goods as $key => $good) {
if (0 == $key % 2) {
$homeGoodsDisplay[$key / 2] = array();
}
$homeGoodsDisplay[$key / 2][] = $good;
}
/////
$goods = Good::orderBy('id', 'desc')->get();
$gid = empty($request->input('gid')) ? $goods[0]->id : $request->input('gid');
$goodInfos = array();
foreach ($goods as $key => $good) {
$goodInfo = GoodAttribsInfo::where('gid', '=', $good->id)
->where('acode', '=', 'price')
->first();
$goodInfos[$key] = $goodInfo;
}
/////
return view('home', array(
'goods' => $goods,
'banners' => $banners,
'home' => 1,
'gid' => $gid,
'active' => 'active',
'goodInfos' => $goodInfos,
'is_select' => true,
'wTitle' => '51临牌网－您身边的车辆临时牌照专家'
));
}