public function show($id, Request $request)
 {
     $id = (int) my_decode($id);
     $data['user'] = $this->person->respondWithItem($this->person->get('person_' . $id), new UserTransformer());
     //get invidvidual reports
     $response = $this->report->individual($id);
     $data['totalIReport'] = 0;
     $data['individual'] = [];
     $item = new Item();
     if (!isset($response['error'])) {
         $data['individual'] = $this->report->respondWithCollection($response['data'], new ReportTransformer());
         foreach ($data['individual'] as $i => $row) {
             $items = $item->getItemsByReport((int) my_decode($row['id']));
             $data['individual'][$i]['items'] = $items['totalRecords'];
         }
         $data['totalIReport'] = $response['totalRecords'];
     }
     $response = $this->report->group($id);
     $data['totalGReport'] = 0;
     $data['group'] = [];
     if (!isset($response['error'])) {
         $data['group'] = $this->report->respondWithCollection($response['data'], new ReportTransformer());
         foreach ($data['group'] as $i => $row) {
             $items = $item->getItemsByReport((int) my_decode($row['id']));
             $data['group'][$i]['items'] = $items['totalRecords'];
         }
         $data['totalGReport'] = $response['totalRecords'];
     }
     return view('users_profile', $data);
 }

 /**
  * Show the form for creating a new resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function store(Request $request)
 {
     $validator = Validator::make($request->all(), ['item_name' => 'required']);
     if ($validator->fails()) {
         return redirect('dashboard')->withErrors($validator)->withInput();
     }
     $item = $request->input('item_name');
     if (!Item::where('item_name', $item)->count()) {
         //naya item insert hua hai
         $items = new Item();
         $item_id = $items->insertGetId(['item_name' => $item, 'created_at' => Carbon::now()]);
         $data = new pivot_user_item();
         $data->user_id = Auth::user()->id;
         $data->item_id = $item_id;
         $data->save();
         $request->session()->flash('status', 'Item added.Add another item!');
     } else {
         $item_id = Item::where('item_name', $item)->value('id');
         if (pivot_user_item::where('item_id', $item_id)->where('user_id', Auth::user()->id)->count()) {
             //item agar user ka hoga to added
             $request->session()->flash('list', 'you have already added this item!');
         } else {
             //item naya user add kia hai
             $data = new pivot_user_item();
             $data->user_id = Auth::user()->id;
             $data->item_id = $item_id;
             $data->save();
             $request->session()->flash('status', 'Item added.Add another item!');
         }
     }
     return redirect('items');
 }

 public function create(Requests\ItemRequest $request)
 {
     $name = $request->name;
     $shortdesc = $request->shortdesc;
     $desc = $request->desc;
     $price = $request->price;
     $id = $request->id;
     $characters = 'abcdefghijklmnopqrstuvwxyz0123456789';
     $string = '';
     $random_string_length = 12;
     for ($i = 0; $i < $random_string_length; $i++) {
         $string .= $characters[rand(0, strlen($characters) - 1)];
     }
     $imageName = $name . '_' . $string . '.' . $request->file($id . 'image')->getClientOriginalExtension();
     $item = new Item();
     $item->name = $name;
     $item->shortdesc = $shortdesc;
     $item->desc = $desc;
     $item->image = $imageName;
     $item->group_id = $id;
     $item->price = $price;
     $item->save();
     $request->file($id . 'image')->move(base_path() . '/public/upload/itemimages/', $imageName);
     return redirect('admin/catalogue');
 }

 private function postAddItemStepTwo(ItemRequest $request)
 {
     //Create new item
     $item = new Item();
     $item->name = $request->name;
     $item->description = $request->description;
     $item->price = $request->price;
     $item->by_mail = $request->by_mail ? 1 : 0;
     $item->user()->associate(Auth::user());
     $item->save();
     //Create new itemAttributes based on the defaultAttributes of the market
     foreach ($request->itemAttributes as $name => $value) {
         $itemAttribute = new ItemAttribute();
         $itemAttribute->name = $name;
         $itemAttribute->value = $value;
         $itemAttribute->item()->associate($item);
         $itemAttribute->save();
     }
     //Create new itemPhotos
     /*if (!empty($request->itemPhotos))
       {
           foreach ($request->get('itemPhotos') as $itemPhoto)
           {
               var_dump($itemPhoto);exit;
           }
       }*/
 }

 public function index()
 {
     $person = new Person();
     $report = new Report();
     $item = new Item();
     $role = session('user.role');
     $data = ['total_users' => 0, 'total_report' => 0, 'total_item' => 0];
     if ($role == 'U') {
         //get data on report and item only
     } else {
         if ($role == 'M') {
             $response = $person->getAssignedPersons(session('user.id'));
             if (!empty($response)) {
                 //get total reports or their assigned users
                 $data['total_users'] = $response['totalRecords'];
                 foreach ($response['data'] as $row) {
                     $reports = $report->getReportsByPerson($row['id']);
                     if (!empty($reports['data'])) {
                         $data['total_report'] += $reports['totalRecords'];
                         //get item of the report
                         foreach ($reports['data'] as $srow) {
                             $items = $item->getItemsByReport($srow['id']);
                             $data['total_item'] += $items['totalRecords'];
                         }
                     }
                 }
                 //get current user's report
                 $response = $report->getReportsByPerson(session('user.id'));
                 if (!empty($response['data'])) {
                     $data['total_report'] += $response['totalRecords'];
                     //get item of the report
                     foreach ($response['data'] as $row) {
                         $items = $item->getItemsByReport($row['id']);
                         $data['total_item'] += $items['totalRecords'];
                     }
                 }
             }
         } else {
             //admin
             $response = $person->all([]);
             if (!empty($response)) {
                 //get total reports or their assigned users
                 $data['total_users'] = $response['totalRecords'];
                 foreach ($response['data'] as $row) {
                     $reports = $report->getReportsByPerson($row['id']);
                     if (isset($reports['data']) && !empty($reports['data'])) {
                         $data['total_report'] += $reports['totalRecords'];
                         //get item of the report
                         foreach ($reports['data'] as $srow) {
                             $items = $item->getItemsByReport($srow['id']);
                             $data['total_item'] += $items['totalRecords'];
                         }
                     }
                 }
             }
         }
     }
     return view('dashboard', $data);
 }

 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function show()
 {
     $info = new Item();
     $info->setTable($this->getLoginUsername());
     //$info->setTable($this->getLoginUsername());
     $list = $info->all($this->getLoginUsername(), array('taskname', 'deadline', 'description', 'important'));
     return view('auth.profile')->with(array('username' => $this->getLoginUsername(), 'list' => $list));
 }

 /**
  * Store a newly created resource in storage.
  *
  * @param  Request  $request
  * @return Response
  */
 public function store(Request $request)
 {
     $item = new Item();
     $item->item_name = trim($request->get('item_name'));
     $item->item_id = (int) $request->get('item_id');
     $item->save();
     return redirect('/item')->withSuccess("Item {$item->item_name} was created");
 }

 public function getDelete(Item $task)
 {
     //echo $task;
     //security, make sure that the correct user deletes this task
     if ($task->owner_id == Auth::user()->id) {
         $task->delete();
     }
     return Redirect::route('home');
 }

 public function store(Request $request)
 {
     $item = new Item();
     $item->setSymPass($request->session()->get('sym_pass'));
     $item->key = $request->key;
     $item->val = $request->val;
     $item->resource_id = $request->resource_id;
     $item->save();
     return redirect()->route('resource.show', ['id' => $request->resource_id]);
 }

 public function save(Request $request, Response $response, array $args)
 {
     $_POST = array_filter($_POST, 'trim');
     $metadata = array('id' => filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT), 'title' => filter_input(INPUT_POST, 'title'), 'description' => filter_input(INPUT_POST, 'description'), 'date' => filter_input(INPUT_POST, 'date'), 'date_granularity' => filter_input(INPUT_POST, 'date_granularity', FILTER_SANITIZE_NUMBER_INT), 'edit_group' => filter_input(INPUT_POST, 'edit_group', FILTER_SANITIZE_NUMBER_INT), 'read_group' => filter_input(INPUT_POST, 'read_group', FILTER_SANITIZE_NUMBER_INT));
     $tags = filter_input(INPUT_POST, 'tags');
     $item = new Item(null, $this->user);
     $item->save($metadata, $tags, $_FILES['file']['tmp_name'], filter_input(INPUT_POST, 'file_contents'));
     $config = new Config();
     return new RedirectResponse($config->baseUrl() . '/' . $item->getId());
 }

 public function done(Item $item)
 {
     $login_user = Auth::user();
     $child = $login_user->getChild();
     $child_member_id = $child->member_id;
     $item_record = $item->where("member_id", "=", $child_member_id)->where('did_get', '=', NULL)->first();
     $item_record->did_get = date("Y/m/d H:i:s");
     $item_record->save();
     return redirect()->to('/mypage/cart');
 }

 static function addItem($request)
 {
     $item = new Item();
     $item->user_id = $request->input('user_id');
     $item->name = $request->input('name');
     $item->specifications = $request->input('specifications');
     $item->link = $request->input('link');
     $item->rank = $request->input('rank');
     $item->save();
 }

 /**
  * Returns category items
  *
  * @param string $alias
  * @return array
  */
 public function getCategoryItems($alias)
 {
     $categories = $this->categoryService->getCategoriesByAlias($alias);
     if (count($categories) === 0) {
         return [];
     }
     $categoryIDs = array_map(function (Category $category) {
         return $category->id;
     }, $categories);
     return $this->itemStorage->getCategoriesItems($categoryIDs);
 }

 public function render(Request $request, Response $response, array $args)
 {
     $item = new Item($args['id']);
     $size = isset($args['size']) ? $args['size'] : 'o';
     $version = isset($args['version']) ? $args['version'] : null;
     $cacheFile = $item->getCachePath($size, $version);
     $fileResponse = new BinaryFileResponse($cacheFile);
     $fileResponse->headers->set('Content-Type', 'image/png');
     $fileResponse->setFile($cacheFile);
     $fileResponse->setContentDisposition(ResponseHeaderBag::DISPOSITION_INLINE, $item->getTitle() . '.png');
     return $fileResponse;
 }

 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     $faker = Faker::create();
     for ($i = 0; $i < 300; $i++) {
         Item::create(['name' => $faker->shuffle($faker->name()), 'description' => $faker->text(), 'icon' => $faker->imageUrl(100, 100, 'abstract')]);
     }
 }

 /**
  * Update podcast items
  *
  * @return mixed
  */
 public function handle()
 {
     $uniquePodcasts = DB::table('podcasts')->select('id', 'feed_url', 'machine_name')->groupBy('machine_name')->get();
     foreach ($uniquePodcasts as $podcast) {
         $usersSubscribedToThisPodcast = DB::table('podcasts')->select('user_id', 'id as podcast_id')->where('machine_name', '=', $podcast->machine_name)->get();
         $items = Feeds::make($podcast->feed_url)->get_items();
         // Calculate 48 hours ago
         $yesterday = time() - 24 * 2 * 60 * 60;
         foreach ($items as $item) {
             $itemPubDate = $item->get_date();
             if ($item->get_date('U') > $yesterday) {
                 // new items
                 foreach ($usersSubscribedToThisPodcast as $subscriber) {
                     $podcastItemsCount = DB::table('items')->select('user_id', 'title', 'podcast_id')->where('title', '=', strip_tags($item->get_title()))->where('user_id', '=', $subscriber->user_id)->where('podcast_id', '=', $subscriber->podcast_id)->count();
                     // if this item is not already in the DB
                     if ($podcastItemsCount == 0) {
                         Item::create(['user_id' => $subscriber->user_id, 'title' => strip_tags($item->get_title()), 'description' => strip_tags(str_limit($item->get_description(), 100)), 'published_at' => $item->get_date('Y-m-d'), 'url' => $item->get_permalink(), 'audio_url' => $item->get_enclosure()->get_link(), 'podcast_id' => $subscriber->podcast_id]);
                     }
                 }
             } else {
                 break;
             }
         }
     }
 }

 public function getUpdate($id)
 {
     $gather = Gather::find($id);
     $lists = $gather->detail->lists('item_id');
     $items = Item::whereNotIn('id', $lists)->get();
     return view("gathers.update")->with('gather', $gather)->with('items', $items);
 }

 public function store(Request $request)
 {
     try {
         $counter = $request->input('counter');
         ItemOut::create($request->all());
         $data = ItemOut::orderBy('created_at', 'desc')->first();
         echo $counter;
         for ($i = 0; $i < $counter; $i++) {
             $qty = $request->input('qty' . strval($i));
             $itemId = $request->input('item_id' . strval($i));
             $isItemAvailable = Item::where('id', 'like', '%' . $itemId . '%')->first();
             // Item::findOrFail($itemId);
             if (is_null($isItemAvailable)) {
                 ItemOut::destroy($data->id);
                 return redirect('itemout')->with('message', 'Data dengan kode barang: ' . $itemId . ', tidak ada');
             } else {
                 DetailItemOut::create(['qty' => $qty, 'item_id' => $itemId, 'item_out_id' => $data->id]);
                 Item::decreaseStock($itemId, $qty);
             }
         }
         return redirect('itemout')->with('message', 'Data berhasil dibuat!');
     } catch (\Illuminate\Database\QueryException $e) {
         return redirect('itemout')->with('message', 'Data dengan email tersebut sudah digunakan!');
     } catch (\PDOException $e) {
         return redirect('itemout')->with('message', 'Data dengan email tersebut sudah digunakan!');
     }
 }

 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     DB::table('items')->delete();
     for ($i = 1; $i <= 100; $i++) {
         Item::create(array('title' => 'item test ' . $i));
     }
 }

 public function index(Request $request)
 {
     $request->flash();
     $items = Item::search($request);
     // dd($request);
     return view('spareparts.index', compact('items'));
 }