/**
* This url is called when a SEOshop customer installs this application
*
* @param Request $request
* @return \Illuminate\View\View
* @throws \Exception
*/
public function install(Request $request)
{
// Make sure we have received all required information
$this->validate($request, ['language' => 'required', 'shop_id' => 'required', 'signature' => 'required', 'timestamp' => 'required', 'token' => 'required']);
// Validate the signature
$signature = '';
$input = $request->except('signature');
ksort($input);
// Construct the signature
foreach ($input as $key => $value) {
$signature .= $key . '=' . $value;
}
// The signature contains the app secret
$signature = md5($signature . config('services.seoshop.secret'));
// Do the signatures match?
if ($signature != $request->input('signature')) {
throw new \Exception('The signature does not match. You haven\'t secretly tampered with it no?');
}
// Find or create the user
$shop = Shop::firstOrNew(array('shop_id' => $request->input('shop_id')));
$shop->language = $request->input('language');
$shop->token = $request->input('token');
$shop->save();
// Authenticate the user
Auth::loginUsingId($shop->id);
// Create the external services
Webshop::instance()->installExternalServices();
// Were done here
return redirect('dashboard');
}
public function store(Request $request)
{
$dates = explode(',', $request->input('shopdate'));
foreach ($dates as $date) {
$shop = new Shop();
$shop->user_id = $request->user_id;
$shop->shopdate = $date;
$shop->save();
}
Flash::success('সঠিক ভাবে সম্পন্ন হয়েছে।');
return redirect()->back();
}
/**
* Show the application dashboard.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$today = Carbon::today();
$tomorrow = Carbon::tomorrow();
$tomorrowbookinguser = Booking::where('bookingdate', '=', $tomorrow)->get();
$dt = Carbon::now();
$year = $dt->year;
$month = $dt->month;
$currentmonthbreakfast = Booking::where('user_id', Auth::user()->id)->whereMonth('bookingdate', '=', $month)->whereYear('bookingdate', '=', $year)->where('breakfast', '=', 'on')->count();
$currentmonthlunch = Booking::where('user_id', Auth::user()->id)->whereMonth('bookingdate', '=', $month)->whereMonth('bookingdate', '=', $month)->whereYear('bookingdate', '=', $year)->where('lunch', '=', 'on')->count();
$currentmonthdinner = Booking::where('user_id', Auth::user()->id)->whereMonth('bookingdate', '=', $month)->whereMonth('bookingdate', '=', $month)->whereYear('bookingdate', '=', $year)->where('dinner', '=', 'on')->count();
$totalbooking = $currentmonthbreakfast + $currentmonthlunch + $currentmonthdinner;
$price = Account::whereMonth('accountdate', '=', date('m'))->where('user_id', Auth::user()->id)->sum('amount');
$todaydayshop = Shop::where('shopdate', $today)->get();
$tomorrowshop = Shop::where('shopdate', $tomorrow)->get();
$bookings = Booking::where('bookingdate', '=', $today)->get();
$breakfast = Booking::where('bookingdate', '=', $today)->where('breakfast', '=', 'on')->count();
$lunch = Booking::where('bookingdate', '=', $today)->where('lunch', '=', 'on')->count();
$dinner = Booking::where('bookingdate', '=', $today)->where('dinner', '=', 'on')->count();
$t_breakfast = Booking::where('bookingdate', '=', $tomorrow)->where('breakfast', '=', 'on')->count();
$t_lunch = Booking::where('bookingdate', '=', $tomorrow)->where('lunch', '=', 'on')->count();
$t_dinner = Booking::where('bookingdate', '=', $tomorrow)->where('dinner', '=', 'on')->count();
$useraccounts = DB::table('useraccounts')->where('user_id', Auth::user()->id)->select('user_id', DB::raw("SUM(foodamount) AS t_foodamount"), DB::raw("SUM(houserent) AS t_houserent"), DB::raw("SUM(internetbill) AS t_internetbill"), DB::raw("SUM(utlitybill) AS t_utlitybill"), DB::raw("SUM(buabill) AS t_buabill"), DB::raw("SUM(pay) AS t_pay"))->get();
foreach ($useraccounts as $account) {
$amount = $account->t_foodamount + $account->t_houserent + $account->t_internetbill + $account->t_utlitybill + $account->t_buabill;
$balance = $amount - $account->t_pay;
}
return view('home', ['bookings' => $bookings, 'breakfast' => $breakfast, 'lunch' => $lunch, 'dinner' => $dinner, 't_breakfast' => $t_breakfast, 't_lunch' => $t_lunch, 't_dinner' => $t_dinner, 'tomorrow' => $tomorrow, 'todaydayshop' => $todaydayshop, 'tomorrowshop' => $tomorrowshop, 'tomorrowbookinguser' => $tomorrowbookinguser, 'balance' => $balance, 'currentmonthbreakfast' => $currentmonthbreakfast, 'currentmonthlunch' => $currentmonthlunch, 'currentmonthdinner' => $currentmonthdinner, 'totalbooking' => $totalbooking, 'price' => $price]);
}
public function listShop()
{
$today = date('Y-m-d');
$shops = Shop::with(['Photo' => function ($query) {
$query->where('dimension', '=', '200x300')->get();
}])->get();
return $shops;
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker\Factory::create();
// Shop::truncate();
$startDate = Carbon::createFromTimeStamp($faker->dateTimeBetween('-1 years', '+1 month')->getTimestamp());
foreach (range(1, 20) as $index) {
Shop::create(['name' => $faker->name, 'shopDescription' => $faker->realText($maxNbChars = 200, $indexSize = 2), 'location' => $faker->city, 'contactNumber' => $faker->phoneNumber, 'openingDate' => $startDate->toDateTimeString(), 'email' => $faker->companyEmail]);
}
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('shops', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->string('floor');
$table->boolean('lot_no');
$table->timestamps();
});
Shop::create(['name' => 'Midvelly', 'floor' => '10', 'lot_no' => '10-8']);
Shop::create(['name' => 'KLCC', 'floor' => '11', 'lot_no' => '12-1']);
Shop::create(['name' => 'Quill', 'floor' => '12', 'lot_no' => '9-2']);
}
/**
* Bootstrap any application services.
*
* @return void
*/
public function boot()
{
/**this method selects rules from database and bind to this view whenever it is used */
view()->composer('partials/dashboardleftcolumn', function ($view) {
$view->with('rules', \App\Rule::all(['rule_name', 'controller']));
});
view()->composer('partials/foodpartial', function ($view) {
$view->with('items', \App\Item::all());
//->where(['state',1]);
});
view()->composer('menu', function ($view) {
$view->with('messages', \App\Item::all());
//->where(['state',1]);
});
view()->composer('partials/productform', function ($view) {
$id = Auth::user()->user_id;
$view->with('shops', \App\Shop::all()->where('user_id', $id));
});
}
public function buyItem(Request $request)
{
$item = Shop::find($request->get('id'));
if (!is_null($item)) {
if ($item->status == Shop::ITEM_STATUS_SOLD) {
return response()->json(['success' => false, 'msg' => 'Предмет уже куплен!']);
}
if ($this->user->money >= $item->price) {
$item->status = Shop::ITEM_STATUS_SOLD;
$item->buyer_id = $this->user->id;
$item->buy_at = Carbon::now();
$item->save();
$this->sendItem($item);
$this->user->money = $this->user->money - $item->price;
$this->user->save();
return response()->json(['success' => true, 'msg' => 'Вы успешно купили предмет! Вы получите его в течении 5 минут.']);
} else {
return response()->json(['success' => false, 'msg' => 'У вас недостаточно средств для покупки.']);
}
} else {
return response()->json(['success' => false, 'msg' => 'Ошибка! Предмет не найден!']);
}
}
private function saveArticle(Article $article)
{
$article->shop_id = \App\Shop::all()->first()->id;
if ($article->model_id == '') {
$article->model_id = null;
}
if ($article->brand_id == '') {
$article->brand_id = null;
}
if ($article->part_type_id == '') {
$article->part_type_id = null;
}
// this automatically applies the user id for
//the relations ship
//TODO: rever isto para associar a peça à loja de que o user é dono;
$article->save();
}
public function statistics()
{
// Getting data about top 3 products
$products = App\Product::orderBy('clicks', 'desc')->limit(3)->select(['id', 'item_id', 'clicks', 'views'])->get()->toArray();
foreach ($products as $key => $product) {
$products[$key]['img'] = App\Product::find($product['id'])->images()->first()->toArray()['url'];
}
// Total clicks and earned money
$total['clicks'] = App\Product::sum('clicks');
$total['earned'] = 0;
// Getting data about shops + clicks per shop
$shops_query = App\Shop::orderBy('name', 'desc')->select(['id', 'name', 'earned'])->get();
$shops = [];
foreach ($shops_query as $shop) {
$shops[] = ['id' => $shop->id, 'name' => $shop->name, 'earned' => $shop->earned, 'clicks' => round(App\Product::where('shop_id', '=', $shop->id)->sum('clicks'), 2)];
$total['earned'] += $shop->earned;
}
return \View::make('admin/statistics', ['title' => 'Statistiky', 'top_products' => $products, 'shops' => $shops, 'total' => $total]);
}
public function parseAction(Request $request)
{
switch ($request->get('action')) {
case 'userInfo':
$user = User::where('steamid64', $request->get('id'))->first();
if (!is_null($user)) {
$games = Game::where('winner_id', $user->id)->get();
$wins = $games->count();
$gamesPlayed = \DB::table('games')->join('bets', 'games.id', '=', 'bets.game_id')->where('bets.user_id', $user->id)->groupBy('bets.game_id')->orderBy('games.created_at', 'desc')->select('games.*', \DB::raw('SUM(bets.price) as betValue'))->get();
$gamesList = [];
$i = 0;
foreach ($gamesPlayed as $game) {
$gamesList[$i] = (object) [];
$gamesList[$i]->id = $game->id;
$gamesList[$i]->win = false;
$gamesList[$i]->bank = $game->price;
if ($game->winner_id == $user->id) {
$gamesList[$i]->win = true;
}
if ($game->status != Game::STATUS_FINISHED) {
$gamesList[$i]->win = -1;
}
$gamesList[$i]->chance = round($game->betValue / $game->price, 3) * 100;
$i++;
}
return response()->json(['username' => $user->username, 'avatar' => $user->avatar, 'votes' => $user->votes, 'wins' => $wins, 'url' => 'http://steamcommunity.com/profiles/' . $user->steamid64 . '/', 'winrate' => count($gamesPlayed) ? round($wins / count($gamesPlayed), 3) * 100 : 0, 'totalBank' => $games->sum('price'), 'games' => count($gamesPlayed), 'list' => $gamesList]);
}
return response('Error. User not found.', 404);
break;
case 'voteUser':
$user = User::where('steamid64', $request->get('id'))->first();
if (!is_null($user)) {
if ($user->id == $this->user->id) {
return response()->json(['status' => 'error', 'msg' => 'Вы не можете голосовать за себя.']);
}
$votes = $this->redis->lrange($user->steamid64 . '.user.votes.list', 0, -1);
if (in_array($this->user->id, $votes)) {
return response()->json(['status' => 'error', 'msg' => 'Вы уже голосовали за этого пользователя.']);
} else {
$user->votes++;
$user->save();
$this->redis->rpush($user->steamid64 . '.user.votes.list', $this->user->id);
return response()->json(['status' => 'success', 'votes' => $user->votes]);
}
}
return response('Error. User not found.', 404);
break;
case 'shopSort':
$options = $request->get('options');
if (is_null($options['searchRarity']) || empty($options['searchRarity']) || $options['searchRarity'] == NULL) {
$options['searchRarity'] = ["Тайное", "Засекреченное", "Запрещенное", "Промышленное качество", "Армейское качество"];
}
if (is_null($options['searchQuality']) || empty($options['searchQuality']) || $options['searchQuality'] == NULL) {
$options['searchQuality'] = ["Прямо с завода", "Немного поношенное", "После полевых испытаний", "Поношенное", "Закаленное в боях"];
}
if (is_null($options['searchType']) || empty($options['searchType']) || $options['searchType'] == NULL) {
$options['searchType'] = ["Нож", "Винтовка", "Дробовик", "Пистолет", "Снайперская винтовка", "Пулемёт"];
}
$items = Shop::where('name', 'like', '%' . $options['searchName'] . '%')->whereBetween('price', [$options['minPrice'], $options['maxPrice'] + 1])->whereIn('type', $options['searchType'])->whereIn('rarity', $options['searchRarity'])->whereIn('quality', $options['searchQuality'])->orderBy('price', $options['sort'])->where('status', Shop::ITEM_STATUS_FOR_SALE)->get();
return $items->toArray();
break;
}
}
/**
* Bootstrap any application services.
*
* @return void
*/
public function boot()
{
return \View::share(['sections' => App\Section::where('parent_id', 0), 'priceRange' => [App\Product::min('price'), App\Product::max('price')], 'favorites' => App\Product::orderBy('views', 'desc')->limit(6)->get(), 'latestPosts' => App\Blog::orderBy('id', 'desc')->limit(4)->get(), 'favSection' => App\Product::orderBy('views', 'desc')->get()->first()->section->name, 'affiliate' => App\Shop::get()]);
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function postEdit($id = null)
{
$rules = array('shop_name' => 'required', 'shop_address' => 'required', 'shop_code' => 'required');
// Create a new validator instance from our validation rules
$validator = Validator::make(Input::all(), $rules);
// If validation fails, we'll exit the operation now.
if ($validator->fails()) {
return Redirect::back()->withInput()->withErrors($validator);
}
$data = new Shop();
$data->shop_name = Input::get('shop_name');
$data->shop_address = Input::get('shop_address');
$data->shop_code = Input::get('shop_code');
$data->is_active = Input::has('is_active') ? 1 : 0;
//$data->shop_code = Input::get('is_active');
//return $data;exit;
//$data->image_name = $safeName;
//echo '<pre>';
//print_r($data);
//echo '</pre>';
Shop::where('shop_id', $id)->update(['shop_name' => $data->shop_name, 'shop_address' => $data->shop_address, 'shop_code' => $data->shop_code, 'is_active' => $data->is_active]);
//return Redirect::back();
$shops = DB::table('shops')->orderBy('shop_id', 'desc')->get();
//print_r($users);
return View('admin.shops.index', compact('shops'));
}
public function adminChange(User $user, Shop $shop)
{
if ($shop->active == 0) {
//the shop is already disabled
$shop->update(['active' => 1]);
Flash::success(trans('admin/messages.shopActivate'));
} elseif ($shop->active == 1) {
//the shop is already enabled
$shop->update(['active' => 0]);
Flash::success(trans('admin/messages.shopBan'));
}
return redirect()->back();
}
public function deleteShop($id)
{
$shop = Shop::find($id);
$shop->delete();
DB::table('last_modifications')->truncate();
DB::table('last_modifications')->insert(['date' => Carbon::now()]);
}
/**
* Created By Dara on 26/12/2015
* admin-product management
*/
public function adminIndex(User $user, Shop $shop)
{
$products = $shop->products()->latest()->paginate(20);
return view('admin.shop.product.index', compact('shop', 'user', 'products'))->with(['title' => 'User Product Management']);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
return \View::make('admin.shops.browse', ['title' => 'Obchody', 'shops' => App\Shop::select()->get()]);
}
public function saveUpdate(UpdateShopRequest $request)
{
$id = $request->shop_id;
$shop = Shop::findOrFail($id);
$shop->update($request->all());
\Session::flash('success', trans('pagination.shopupdate'));
return view('admin/dashboard');
}
public function addShopImage(Requests\ImageRequest $request, $id)
{
if ($request->ajax()) {
$file = $request->file('picture');
if ($file) {
$fileName = $this->upload($file, 'shop');
$shop = Shop::find($id);
$shop->picture = $fileName;
$shop->save();
}
DB::table('last_modifications')->truncate();
DB::table('last_modifications')->insert(['date' => Carbon::now()]);
}
}
public function destroy($id)
{
$shop = Shop::findOrFail($id);
$shop->delete();
return \Response::json(['error' => false, 'code' => 200, 'feedback' => 'Shop has been deleted.'], 200);
}
/**
* Remove the specified resource from storage.
*
* @param int $shop_id
* @return Response
*/
public function destroy($shop_id)
{
$shop = Shop::destroy($shop_id);
return \Response::json($shop);
}
public function update($id, Request $request)
{
$asset = Shop::findOrFail($id);
$asset->update($request->all());
return redirect('shops');
}
