/** * Update the specified resource in storage. * * @param int $id * @return Response */ public function update(Request $request, $id) { $input = $request->all(); Item::where("id", $id)->update($input); $item = Item::find($id); return response($item); }
/** * @param $id * @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector */ public function destroy($id) { $item = Item::find($id); //select the book using primary id $item->delete(); return redirect('/'); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { $item = \App\Item::find($id); $item->title = $request->title; $item->completed = $request->completed; $item->save(); return $item; }
public function putItem(Request $request) { $this->validate($request, ['id' => 'exists:items', 'descripcion' => 'required|min:5']); $item = Item::find($request->get('id')); $item->descripcion = $request->get('descripcion'); $item->save(); return response()->json($item); }
public function sort(Request $itemsOrder) { $items = explode(',', $itemsOrder->input('list_order')); $i = 1; foreach ($items as $itemId) { $item = Item::find($itemId); $item->item_order = $i; $item->save(); $i++; } return "Order saved"; }
public function testDeleteItem() { $user = factory(User::class)->create(); $item = $this->getFakeItem($user->id); $itemtest = Item::find($item->id); //// TODO: why is user_id -1 in created object??? print 'user_id: ' . $user->id . ' category_id: ' . $item->category_id; print 'Itemtest: user_id: ' . $itemtest->user_id . ' category_id: ' . $itemtest->category_id; $item_criteria = ['name' => $item->name, 'category_id' => $item->category_id]; $this->seeInDatabase('items', $item_criteria); //// create new item $this->actingAs($user)->delete('/api/items/' . $item->id); $this->notSeeInDatabase('items', $item_criteria); }
/** * Update the specified resource in storage. * * @param int $id * @return Response */ public function update(InventoryRequest $request, $id) { $items = Item::find($id); $items->quantity = $items->quantity + Input::get('in_out_qty'); $items->save(); $inventories = new Inventory(); $inventories->item_id = $id; $inventories->user_id = Auth::user()->id; $inventories->in_out_qty = Input::get('in_out_qty'); $inventories->remarks = Input::get('remarks'); $inventories->save(); Session::flash('message', 'You have successfully updated item'); return Redirect::to('inventory/' . $id . '/edit'); }
public function show($id) { //temporarily restore the item Item::withTrashed()->where('id', $id)->restore(); $item = Item::find($id); if ($item->user_id == \Auth::user()->id) { \Session::flash('flash_message', 'The item has been recovered.'); } else { //delete it again if not authorized $item->delete(); \Session::flash('flash_message', "You aren't authorized to recover this item."); } return redirect('items'); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { $this->validate($request, ['category_id' => 'required', 'name' => 'required', 'description' => 'required', 'cost' => 'required']); $item = Item::find($id); $item->category_id = $request->input('category_id'); $item->name = $request->input('name'); $item->description = $request->input('description'); $item->cost = $request->input('cost'); if ($request->hasFile('image')) { $extension = $request->file('image')->getClientOriginalExtension(); $item->image_type = $extension; $storage = Storage::disk('s3')->put('/items/' . $item->id . '.' . $extension, file_get_contents($request->file('image')->getRealPath()), 'public'); } $item->save(); return redirect('items')->with('flash_message', 'Item details updated'); }
/** * Get the validation rules that apply to the request. * * @return array */ public function rules() { switch ($this->method()) { case 'POST': return ['name' => 'required|unique:items', 'unit' => 'required']; case 'PATCH': $item = Item::find($this->segment(2)); //this gets the second segment in the url which is the id of the item if ($this->get('name') == $item['name']) { return ['name' => 'required|unique:items,id' . $this->get('id'), 'unit' => 'required']; } else { return ['name' => 'required|unique:items', 'unit' => 'required']; } default: break; } }
public function postAddToCart(Request $request) { $this->validate($request, ['item' => 'required|numeric|exists:items,id']); $user_id = Auth::user()->id; $item_id = Input::get('item'); $amount = 1; $item = Item::find($item_id); $total = $amount * $item->price; $carts = Cart::with('Items')->where('user_id', $user_id)->get(); $item_stock = $item->stock; if ($item->stock < 1) { return redirect('/')->withErrors('Ce produit n\'est plus disponible'); } Cart::create(['user_id' => $user_id, 'item_id' => $item_id, 'amount' => $amount, 'total' => $total]); $item->decrement('stock'); $last_timestamp = Cart::with('Items')->where('user_id', $user_id)->orderBy('created_at', 'desc')->first()->created_at; Auth::user()->last_cart_timestamp = $last_timestamp; Auth::user()->save(); return redirect('/'); }
public function show($id) { $edificio_id = Input::get('id'); $edificio = Edificio::find($edificio_id); $administrador = Administrador::find($edificio->admin_id); $items = Item::find($id); //obtengo el id de la espensa que vien por la url// $exp_uri = $_SERVER["REQUEST_URI"]; $exp_uri = explode('/', $exp_uri); $exp_uri = explode('?', $exp_uri[4]); $exp_id = $exp_uri[0]; $expensa = new Expensa(); $expensa = $expensa::find($exp_id); $pisos = DB::table('items')->join('propietarios', 'propietarios.id', '=', 'items.unidad_id')->where('items.expensa_id', '=', $id)->get(); if (Auth::user()->rol_id == 2) { //return View::make('administrador.expensas.show') //->with('items', $items) //->with('edificio', $edificio) //->with('admin', $administrador) //->with('pisos', $pisos); $view = \View::make('administrador.expensas.show')->with('items', $items)->with('edificio', $edificio)->with('admin', $administrador)->with('pisos', $pisos)->with('expensa', $expensa); $pdf = \App::make('dompdf.wrapper'); $pdf->loadHTML($view); return $pdf->stream('Expensa.pdf'); } if (Auth::user()->rol_id == 3) { $view = \View::make('propietario.expensas.show')->with('items', $items)->with('edificio', $edificio)->with('admin', $administrador)->with('pisos', $pisos)->with('expensa', $expensa); $pdf = \App::make('dompdf.wrapper'); $pdf->loadHTML($view); return $pdf->stream('Expensa.pdf'); //return View::make('propietario.expensas.index'); } if (Auth::user()->rol_id == 4) { $view = \View::make('inquilino.expensas.show')->with('items', $items)->with('edificio', $edificio)->with('admin', $administrador)->with('pisos', $pisos)->with('expensa', $expensa); $pdf = \App::make('dompdf.wrapper'); $pdf->loadHTML($view); return $pdf->stream('Expensa.pdf'); //return View::make('propietario.expensas.index'); } }
/** * @param Request $request * this function is for adding products to the shopping cart * @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View */ public function add(Request $request) { if ($request->isMethod('post')) { $item_id = $request->get('item_id'); $has_item = false; $item = Item::find($item_id); $cat_name = $request->get('catName'); if (Session::has('items')) { foreach ($request->session()->get('items') as $items) { if ($items['id'] == $item_id) { $has_item = true; } } } if (!$has_item) { $request->session()->push('items', ['id' => "{$item->itID}", 'quantity' => 1, 'name' => "{$item->itName}", 'price' => "{$item->price}", 'imgpath' => "{$item->imName}"]); } //$request->session()->flush(); //retrieve the session array $data = $request->session()->get('items'); return view('pages.cart.cart', compact('data', 'i', 'n', 'cat_name')); } }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { $item = Item::find($id); $item->delete(); return; }
/** * Change the pictures of an item * * @param int $id * @param File $picture1 * @param File $picture2 * @param bool $dp2 * @return Response */ public function changePictures() { $item = Item::find(Request::input('id')); // Delete the secondary picture first if (Request::has('dp2') && Request::input('dp2') == "true" || Request::file('picture2')) { File::delete('uploads/' . $item->hash . '_2.jpg'); $item->picture2 = false; } if (Request::file('picture1')) { $destination = 'uploads'; // Give it a unique filename $extension = Input::file('picture1')->getClientOriginalExtension(); if (strtolower($extension) != 'jpg') { return Response::make("Please upload only .jpg files.", 400); } else { $filename = $item->hash . "_1." . strtolower($extension); File::delete('uploads/' . $item->hash . '_1.jpg'); Input::file('picture1')->move($destination, $filename); } } if (Request::file('picture2')) { $destination = 'uploads'; // Give it a unique filename $extension = Input::file('picture2')->getClientOriginalExtension(); if (strtolower($extension) != 'jpg') { return Response::make("Please upload only .jpg files.", 400); } else { $filename = $item->hash . "_2." . strtolower($extension); Input::file('picture2')->move($destination, $filename); } $item->picture2 = true; } $item->save(); return Response::make("Success", 205); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { // $this->validate($request, ['schedule' => 'required', 'category' => 'required', 'type' => 'required']); $data = Item::find($id); $data->ticket_no = $request->ticket_no; $data->category_id = $request->category; $data->type_id = $request->type; $data->price = $request->price; $data->description = $request->description; $data->save(); $destinationPath = 'images/' . Auth::user()->id . '/' . $request->ticket_no; foreach ($request->file('image') as $key => $photo) { if ($photo) { if ($photo->isValid()) { // original $filename_original = 'image_' . $key . '_original.jpg'; Image_::make($photo->getRealPath())->save($destinationPath . '/' . $filename_original); // for grid view $filename = $destinationPath . '/' . 'image_' . $key . '_349x200.jpg'; ph::resize_image($destinationPath . '/' . $filename_original, 349, 200, $filename); // for view page (big) $filename = $destinationPath . '/' . 'image_' . $key . '_725x483.jpg'; ph::resize_image($destinationPath . '/' . $filename_original, 725, 483, $filename); // for view page (thumbnail) $filename = $destinationPath . '/' . 'image_' . $key . '_173x126.jpg'; ph::resize_image($destinationPath . '/' . $filename_original, 173, 126, $filename); } else { Session::flash('message', 'uploaded file is not valid'); return redirect('/item'); } } } Session::flash('message', 'Item with ticket #' . $request->ticket_no . ' was successfully updated'); return redirect('/item'); }
public function generate() { $input = Request::all(); $counter = 1; $reportType = $input['report_type']; $salesCounter = 0; $counterClientBreakdown = 0; $counterClientLabel = 0; $counterClientData = 0; if ($reportType == "sales") { $monthStart = $input['select_monthFrom']; $monthEnd = $input['select_monthTo']; $yearStart = $input['yearFrom']; $yearEnd = $input['yearTo']; $monthStartName = date("F", mktime(0, 0, 0, $monthStart, 10)); $monthEndName = date("F", mktime(0, 0, 0, $monthEnd, 10)); $results = DB::select("SELECT SUM(total_amount) as 'total' FROM sales_invoices si\n WHERE MONTH(si.date) >= '{$monthStart}' AND MONTH(si.date) <= '{$monthEnd}'\n AND YEAR(si.date) >= '{$yearStart}' AND YEAR(si.date) <= '{$yearEnd}'"); $resultsClient = DB::select("SELECT name, SUM(total_amount) as 'total' FROM clients c\n JOIN sales_invoices si ON si.client_id = c.id\n WHERE MONTH(si.date) >= '{$monthStart}' AND MONTH(si.date) <= '{$monthEnd}'\n AND YEAR(si.date) >= '{$yearStart}' AND YEAR(si.date) <= '{$yearEnd}' GROUP BY c.id"); $resultsSales = DB::select("SELECT username, SUM(total_amount) as 'total' FROM users u\n JOIN clients c ON c.user_id = u.id\n JOIN sales_invoices si ON si.client_id = c.id \n WHERE MONTH(si.date) >= '{$monthStart}' AND MONTH(si.date) <= '{$monthEnd}'\n AND YEAR(si.date) >= '{$yearStart}' AND YEAR(si.date) <= '{$yearEnd}' GROUP BY u.id"); Excel::create('Sales Report ' . \Carbon\Carbon::today()->format('m-d-y'), function ($excel) use($results, $resultsClient, $resultsSales, $counter, $monthStartName, $monthEndName, $salesCounter, $counterClientBreakdown, $counterClientLabel, $counterClientData, $yearStart, $yearEnd) { $excel->sheet('Data', function ($sheet) use($results, $resultsClient, $resultsSales, $counter, $monthEndName, $monthStartName, $salesCounter, $counterClientBreakdown, $counterClientLabel, $counterClientData, $yearStart, $yearEnd) { $sheet->row($counter, array('Sales Report')); $counter++; $sheet->row($counter, array('For ' . $monthStartName . ' ' . $yearStart . ' To ' . $monthEndName . ' ' . $yearEnd)); $counter++; $sheet->row($counter, array('Total Sales: ', 'P' . $results[0]->total)); $counter++; $counter++; $sheet->row($counter, array('Sale Employee Breakdown:')); //styling for 'Sales Employee Breakdown' $sheet->cells('A5', function ($cells) { $cells->setFontSize(14); $cells->setFontWeight('bold'); }); $counter++; $sheet->row($counter, array('Username', 'Total Amount')); $counter++; foreach ($resultsSales as $sales) { $sheet->row($counter, array($sales->username, $sales->total)); $counter++; } $salesCounter = $counter - 1; $counter += 10; $sheet->row($counter, array('Client Breakdown: ')); $counterClientBreakdown = $counter; $counter++; $sheet->row($counter, array('Client Name', 'Total Amount')); $counterClientLabel = $counter; //$counter++; $counterClientData = $counter + 1; foreach ($resultsClient as $client) { $counter++; $sheet->row($counter, array($client->name, $client->total)); //$counter++; } //styling 'Sales Report' -> bold $sheet->mergeCells('A1:B1'); $sheet->cells('A1', function ($cells) { $cells->setFontSize(16); $cells->setFontWeight('bold'); }); //styling for total sales $sheet->cells('A3:B3', function ($cells) { $cells->setFontSize(14); $cells->setFontWeight('bold'); }); //styling for 'Client Breakdown' $sheet->cells('A' . $counterClientBreakdown, function ($cells) { $cells->setFontSize(14); $cells->setFontWeight('bold'); }); //create Sales Employee chart if (Count($resultsSales) > 0) { //Data Series Label $dsl = array(new \PHPExcel_Chart_DataSeriesValues('String', 'Data!$B$6', NULL, 1)); $xal = array(new \PHPExcel_Chart_DataSeriesValues('String', 'Data!$A$7:$A$' . $salesCounter, NULL, count($resultsSales))); $dsv = array(new \PHPExcel_Chart_DataSeriesValues('Number', 'Data!$B$7:$B$' . $salesCounter, NULL, count($resultsSales))); $ds = new \PHPExcel_Chart_DataSeries(\PHPExcel_Chart_DataSeries::TYPE_BARCHART, \PHPExcel_Chart_DataSeries::GROUPING_STANDARD, range(0, count($dsv) - 1), $dsl, $xal, $dsv); $pa = new \PHPExcel_Chart_PlotArea(NULL, array($ds)); $legend = new \PHPExcel_Chart_Legend(\PHPExcel_Chart_Legend::POSITION_RIGHT, NULL, false); $title = new \PHPExcel_Chart_Title('Sales by Employee'); $chart = new \PHPExcel_Chart('chart1', $title, $legend, $pa, true, 0, NULL, NULL); $chart->setTopLeftPosition('E5'); $chart->setBottomRightPosition('L16'); $sheet->addChart($chart); } //create Client Breakdown chart if (Count($resultsClient) > 0) { //Data Series Label $dsl2 = array(new \PHPExcel_Chart_DataSeriesValues('String', 'Data!$B$' . $counterClientLabel, NULL, 1)); $xal2 = array(new \PHPExcel_Chart_DataSeriesValues('String', 'Data!$A$' . $counterClientData . ':$A$' . $counter, NULL, count($resultsClient))); $dsv2 = array(new \PHPExcel_Chart_DataSeriesValues('Number', 'Data!$B$' . $counterClientData . ':$B$' . $counter, NULL, count($resultsClient))); $ds2 = new \PHPExcel_Chart_DataSeries(\PHPExcel_Chart_DataSeries::TYPE_BARCHART, \PHPExcel_Chart_DataSeries::GROUPING_STANDARD, range(0, count($dsv2) - 1), $dsl2, $xal2, $dsv2); $pa2 = new \PHPExcel_Chart_PlotArea(NULL, array($ds2)); $legend2 = new \PHPExcel_Chart_Legend(\PHPExcel_Chart_Legend::POSITION_RIGHT, NULL, false); $title2 = new \PHPExcel_Chart_Title('Sales by Client'); $chart = new \PHPExcel_Chart('chart2', $title2, $legend2, $pa2, true, 0, NULL, NULL); $chart->setTopLeftPosition('E19'); $chart->setBottomRightPosition('L30'); $sheet->addChart($chart); } }); })->export('xlsx'); } else { if ($reportType == "collection") { $monthStart = $input['select_monthFrom']; $monthEnd = $input['select_monthTo']; $yearStart = $input['yearFrom']; $yearEnd = $input['yearTo']; $monthStartName = date("F", mktime(0, 0, 0, $monthStart, 10)); $monthEndName = date("F", mktime(0, 0, 0, $monthEnd, 10)); $counter = 1; $results = DB::select("SELECT sum(total_amount) as 'total', count(*) as 'numCount' FROM sales_invoices si\n WHERE (si.status = 'delivered' OR si.status = 'overdue')\n AND MONTH(si.due_date) >= '{$monthStart}' AND MONTH(si.due_date) <= '{$monthEnd}'\n AND YEAR(si.due_date) >= '{$yearStart}' AND YEAR(si.date) <= '{$yearEnd}'"); $resultsCollected = DB::select("SELECT sum(total_amount) as 'total', count(*) as 'numCount' FROM sales_invoices si\n WHERE si.status = 'collected'\n AND MONTH(si.due_date) >= '{$monthStart}' AND MONTH(si.due_date) <= '{$monthEnd}'\n AND YEAR(si.due_date) >= '{$yearStart}' AND YEAR(si.date) <= '{$yearEnd}'"); $resultsInvoices = DB::select("SELECT name, si_no, date, due_date, total_amount, si.status FROM sales_invoices si\n JOIN clients c ON si.client_id = c.id\n WHERE MONTH(si.due_date) >= '{$monthStart}' AND MONTH(si.due_date) <= '{$monthEnd}'\n AND YEAR(si.due_date) >= '{$yearStart}' AND YEAR(si.date) <= '{$yearEnd}' ORDER BY name, si.status"); Excel::create('Collection Report ' . \Carbon\Carbon::today()->format('m-d-y'), function ($excel) use($results, $counter, $monthStartName, $monthEndName, $yearStart, $yearEnd, $resultsCollected, $resultsInvoices) { $excel->sheet('Data', function ($sheet) use($results, $counter, $monthStartName, $monthEndName, $yearStart, $yearEnd, $resultsCollected, $resultsInvoices) { $sheet->row($counter, array('Collection Report')); $counter++; $sheet->row($counter, array('For ' . $monthStartName . ' ' . $yearStart . ' To ' . $monthEndName . ' ' . $yearEnd)); $counter++; $sheet->row($counter, array('Total Amount Collected: ', $resultsCollected[0]->total)); $counter++; $sheet->row($counter, array('Total Collectibles: ', $results[0]->total)); $counter += 2; $sheet->row($counter, array('List of Collectibles: ')); $counter++; $sheet->row($counter, array('Client Name', 'Sales Invoice Number', 'Date', 'Due Date', 'Total Amount', 'Status')); $counter++; foreach ($resultsInvoices as $result) { $sheet->row($counter, array($result->name, $result->si_no, $result->date, $result->due_date, $result->total_amount, $result->status)); $counter++; } // foreach($results as $result) // { // $sheet->row($counter, array('Total Collectibles: ', $result->total)); // } //style //style for item name $sheet->mergeCells('A1:B1'); $sheet->cells('A1', function ($cells) { $cells->setFontSize(14); $cells->setFontWeight('bold'); }); //style for total amount collected $sheet->cells('A3:B3', function ($cells) { $cells->setFontSize(12); $cells->setFontWeight('bold'); }); //style for total collectibles $sheet->cells('A4:B4', function ($cells) { $cells->setFontSize(12); $cells->setFontWeight('bold'); }); }); })->export('xlsx'); } else { if ($reportType == "item") { $itemID = $input['item']; $item = Item::find($itemID); $itemName = $item->name; $monthStart = $input['select_monthFrom']; $monthEnd = $input['select_monthTo']; $yearStart = $input['yearFrom']; $yearEnd = $input['yearTo']; $monthStartName = date("F", mktime(0, 0, 0, $monthStart, 10)); $monthEndName = date("F", mktime(0, 0, 0, $monthEnd, 10)); $counterLabel = 0; $counterData = 0; $results = DB::select("SELECT name, supplier_id FROM price_logs pl\n JOIN suppliers s ON pl.supplier_id = s.id \n WHERE item_id = '{$itemID}' AND MONTH(pl.date) >= '{$monthStart}' \n AND MONTH(pl.date) <= '{$monthEnd}' AND YEAR(pl.date) >= '{$yearStart}' AND YEAR(pl.date) <= '{$yearEnd}'\n GROUP BY pl.supplier_id"); $itemResults = DB::select("SELECT name, sum(quantity) as 'totalSold', sum(total_price) as 'totalAmount' FROM invoice_items ii\n JOIN items i ON ii.item_id = i.id\n WHERE ii.item_id = '{$itemID}'"); Excel::create('Item Report-' . $itemName . ' ' . \Carbon\Carbon::today()->format('m-d-y'), function ($excel) use($results, $counter, $itemID, $monthStart, $monthStartName, $monthEnd, $monthEndName, $yearStart, $yearEnd, $itemResults, $itemName, $counterLabel, $counterData) { $excel->sheet('Data', function ($sheet) use($results, $counter, $itemID, $monthStart, $monthStartName, $monthEnd, $monthEndName, $yearStart, $yearEnd, $itemResults, $itemName, $counterLabel, $counterData) { $sheet->row($counter, array('Item Report')); //style for Item Report Title $sheet->cells('A1', function ($cells) { $cells->setFontSize(16); $cells->setFontWeight('bold'); }); $counter++; $sheet->row($counter, array('For ' . $monthStartName . ' ' . $yearStart . ' To ' . $monthEndName . ' ' . $yearEnd)); $counter++; $sheet->row($counter, array('Item Name: ' . $itemName)); //style for item name $sheet->mergeCells('A1:B1'); $sheet->cells('A' . $counter, function ($cells) { $cells->setFontSize(14); $cells->setFontWeight('bold'); }); $counter++; $sheet->row($counter, array('Total Quantity Sold: ', $itemResults[0]->totalSold)); //style for quantity sold $sheet->cells('A' . $counter . ':B' . $counter, function ($cells) { $cells->setFontSize(12); $cells->setFontWeight('bold'); }); $counter++; $sheet->row($counter, array('Total Revenue Generated: ', 'P' . $itemResults[0]->totalAmount)); //style for revenue generated $sheet->cells('A' . $counter . ':B' . $counter, function ($cells) { $cells->setFontSize(12); $cells->setFontWeight('bold'); }); $counter += 2; foreach ($results as $result) { $sheet->row($counter, array($result->name)); //style for quantity sold $sheet->cells('A' . $counter, function ($cells) { $cells->setFontWeight('bold'); }); $counter++; $sheet->row($counter, array('Date', 'Unit Price')); $counterLabel = $counter; $counterData = $counter + 1; $logs = DB::select("SELECT date, price FROM price_logs pl \n WHERE item_id = '{$itemID}' AND supplier_id = '{$result->supplier_id}'\n AND MONTH(pl.date) >= '{$monthStart}' \n AND MONTH(pl.date) <= '{$monthEnd}' AND YEAR(pl.date) >= '{$yearStart}' AND YEAR(pl.date) <= '{$yearEnd}'"); foreach ($logs as $log) { $counter++; $sheet->row($counter, array($log->date, $log->price)); } //Create chart if (count($logs) > 0) { //Data Series Label $dsl = array(new \PHPExcel_Chart_DataSeriesValues('String', 'Data!$B$' . $counterLabel, NULL, 1)); $xal = array(new \PHPExcel_Chart_DataSeriesValues('String', 'Data!$A$' . $counterData . ':$A$' . $counter, NULL, count($logs))); $dsv = array(new \PHPExcel_Chart_DataSeriesValues('Number', 'Data!$B$' . $counterData . ':$B$' . $counter, NULL, count($logs))); $ds = new \PHPExcel_Chart_DataSeries(\PHPExcel_Chart_DataSeries::TYPE_LINECHART, \PHPExcel_Chart_DataSeries::GROUPING_STANDARD, range(0, count($dsv) - 1), $dsl, $xal, $dsv); $pa = new \PHPExcel_Chart_PlotArea(NULL, array($ds)); $legend = new \PHPExcel_Chart_Legend(\PHPExcel_Chart_Legend::POSITION_RIGHT, NULL, false); $title = new \PHPExcel_Chart_Title('Price History'); $chart = new \PHPExcel_Chart('chart1', $title, $legend, $pa, true, 0, NULL, NULL); $counter += 5; $chart->setTopLeftPosition('E' . $counterLabel); $chart->setBottomRightPosition('K' . $counter); $sheet->addChart($chart); } $counter += 2; } }); })->export('xlsx'); } else { if ($reportType == "client") { //$client = Client::all(); $clientid = $input['client']; $clientName = Client::find($clientid)->name; $results = DB::select("SELECT c.name AS 'clientName', i.name, SUM(quantity) AS 'total' FROM invoice_items ii\n JOIN items i on ii.item_id = i.id \n JOIN sales_invoices si ON ii.sales_invoice_id = si.id\n JOIN clients c ON si.client_id = c.id\n WHERE c.id = '{$clientid}'\n GROUP BY item_id ORDER BY sum(quantity) DESC LIMIT 3"); //$client = DB::table('clients')->get(); Excel::create('Client Report ' . \Carbon\Carbon::today()->format('m-d-y'), function ($excel) use($results, $counter, $clientName) { $excel->sheet('Data', function ($sheet) use($results, $counter, $clientName) { $sheet->row($counter, array('Client Report')); $counter++; //$sheet->row($counter, array('Client Name', $results[0]->clientName)); $sheet->row($counter, array('Client Name', $clientName)); $counter++; $counter++; //add space $sheet->row($counter, array('Most Bought Items:')); $counter++; $sheet->row($counter, array('Item Name', 'Total Quantity')); $counter++; foreach ($results as $result) { $sheet->row($counter, array($result->name, $result->total)); $counter++; } //Add the styling $sheet->mergeCells('A1:B1'); $sheet->cells('A1', function ($cells) { $cells->setFontSize(16); $cells->setFontWeight('bold'); }); $sheet->cells('A2:B2', function ($cells) { $cells->setFontSize(16); }); $sheet->cells('A4', function ($cells) { $cells->setFontWeight('bold'); }); //Create chart if (count($results) > 0) { //Data Series Label $dsl = array(new \PHPExcel_Chart_DataSeriesValues('String', 'Data!$B$5', NULL, 1)); $xal = array(new \PHPExcel_Chart_DataSeriesValues('String', 'Data!$A$6:$A$' . $counter, NULL, 3)); $dsv = array(new \PHPExcel_Chart_DataSeriesValues('Number', 'Data!$B$6:$B$' . $counter, NULL, 3)); $ds = new \PHPExcel_Chart_DataSeries(\PHPExcel_Chart_DataSeries::TYPE_BARCHART, \PHPExcel_Chart_DataSeries::GROUPING_STANDARD, range(0, count($dsv) - 1), $dsl, $xal, $dsv); $pa = new \PHPExcel_Chart_PlotArea(NULL, array($ds)); $legend = new \PHPExcel_Chart_Legend(\PHPExcel_Chart_Legend::POSITION_RIGHT, NULL, false); $title = new \PHPExcel_Chart_Title('Most Bought'); $chart = new \PHPExcel_Chart('chart1', $title, $legend, $pa, true, 0, NULL, NULL); $chart->setTopLeftPosition('A10'); $chart->setBottomRightPosition('C25'); $sheet->addChart($chart); } }); })->export('xlsx'); } } } } }
public function getDoDelete($item_id) { $item = \App\Item::find($item_id); if (is_null($item)) { \Session::flash('flash_message', 'Item not found.'); return redirect('/items'); } if ($item->stores()) { //remove any tags associated with this book $item->stores()->detach(); } $item->delete(); \Session::flash('flash_message', $item->name . ' was deleted.'); return redirect('/items'); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { $item = Item::find($id); $item->delete(); return redirect()->route('items.index'); }
/** * Store a newly created resource in storage. * * @return Response */ public function store(SaleRequest $request) { $sales = new Sale(); $sales->customer_id = Input::get('customer_id'); $sales->user_id = Auth::user()->id; $sales->payment_type = Input::get('payment_type'); $sales->comments = Input::get('comments'); $sales->save(); // process sale items $saleItems = SaleTemp::all(); foreach ($saleItems as $value) { $saleItemsData = new SaleItem(); $saleItemsData->sale_id = $sales->id; $saleItemsData->item_id = $value->item_id; $saleItemsData->cost_price = $value->cost_price; $saleItemsData->selling_price = $value->selling_price; $saleItemsData->quantity = $value->quantity; $saleItemsData->total_cost = $value->total_cost; $saleItemsData->total_selling = $value->total_selling; $saleItemsData->save(); //process inventory $items = Item::find($value->item_id); if ($items->type == 1) { $inventories = new Inventory(); $inventories->item_id = $value->item_id; $inventories->user_id = Auth::user()->id; $inventories->in_out_qty = -$value->quantity; $inventories->remarks = 'SALE' . $sales->id; $inventories->save(); //process item quantity $items->quantity = $items->quantity - $value->quantity; $items->save(); } else { $itemkits = ItemKitItem::where('item_kit_id', $value->item_id)->get(); foreach ($itemkits as $item_kit_value) { $inventories = new Inventory(); $inventories->item_id = $item_kit_value->item_id; $inventories->user_id = Auth::user()->id; $inventories->in_out_qty = -($item_kit_value->quantity * $value->quantity); $inventories->remarks = 'SALE' . $sales->id; $inventories->save(); //process item quantity $item_quantity = Item::find($item_kit_value->item_id); $item_quantity->quantity = $item_quantity->quantity - $item_kit_value->quantity * $value->quantity; $item_quantity->save(); } } } //delete all data on SaleTemp model SaleTemp::truncate(); $itemssale = SaleItem::where('sale_id', $saleItemsData->sale_id)->get(); Session::flash('message', 'You have successfully added sales'); //return Redirect::to('receivings'); return view('sale.complete')->with('sales', $sales)->with('saleItemsData', $saleItemsData)->with('saleItems', $itemssale); }
static function reserveItem($item_id) { $item = \App\Item::find($item_id); $item->reserved_by = auth()->user()->id; $item->save(); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { $item = Item::find($id); $item->Delete('set null'); return redirect()->action('ItemsController@index'); }
public function review() { $rules = array('name' => 'required|min:5', 'email' => 'required|email', 'address1' => 'required|min:5', 'city' => 'required', 'postcode' => 'required|min:3', 'country' => 'required|max:2', 'payment_method' => 'required|max:6'); $validator = Validator::make(Input::all(), $rules); if ($validator->fails()) { return redirect()->back()->withErrors($validator->errors())->withInput(); } else { $addressinfo = Input::except('_token', 'page', 'cartjson'); $order = Order::create($addressinfo); $order->ordernumber = "LEAF-" . mt_rand(100000, 999999); $cart = json_decode(Input::get('cartjson')); $totalamount = 0; foreach ($cart->items as $cartitem) { $item = Item::find($cartitem->itemid); if ($item->id == Item::SHIPPING) { $shipping = $this->calculateShipping($order); $orderitem = OrderItem::create(["item_id" => $item->id, "order_id" => $order->id, "itemprice" => $shipping, "amount" => 1]); $totalamount += $shipping; } else { $orderitem = OrderItem::create(["item_id" => $item->id, "order_id" => $order->id, "itemprice" => $item->price, "amount" => $cartitem->itemamount]); $totalamount += $item->price * $orderitem->amount; } $orderitem->save(); } $order->totalamount = $totalamount; $order->save(); return view('review', ["order" => $order]); } }
public function edit($id) { $item = Item::find($id); return view('pages.items.edit', compact('item')); }
public function delete($id) { $item = Item::find($id); $item->delete(); return redirect()->back()->with('message_content', '删除成功!')->with('message_type', 'info'); }
public function getItemChecked($id = null) { //get item from item id $item = \App\Item::find($id); //check if item marked as checked $itemChecked = $item->checked; //toggle the value if (!$itemChecked) { $item->checked = true; } else { $item->checked = false; } $item->save(); //\Session::flash('flash_message', 'Item detail updated.'); return redirect('/store/' . $item->store_id . '/items'); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { $items = Item::find($id); $items->delete(); Session::flash('message', 'You have successfully deleted item'); return Redirect::to('items'); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($list_id, $item_id) { // Detach the item from the list $list = App\RatingList::find($list_id); $list->items()->detach($item_id); // Create a success notification $item = App\Item::find($item_id); flash()->success('Success!', 'You have removed <strong>' . e($item->name) . '</strong> from your list.'); // Redirect to the lists page return redirect()->action('ListsController@show', $list_id); }
protected function itemStoreUpdate(Request $request, $id = null) { if (Auth::check()) { if ($id) { $item = Item::find($id); } else { $item = new Item(); } /*['name', 'region', 'platform', 'category', 'type', 'catalog_number', 'isbn', 'sku', 'role', 'directed', 'kojima_team', 'release_date', 'year'];*/ $item->collection_id = $request->input('collection_id'); $item->name = $request->input('name'); $item->region = $request->input('region'); $item->platform = $request->input('platform'); $item->category = $request->input('category'); $item->type = $request->input('type'); $item->catalog_number = $request->input('catalog_number'); $item->isbn = $request->input('isbn'); $item->sku = $request->input('sku'); $item->role = $request->input('role'); $item->directed = $request->input('directed'); $item->kojima_team = $request->input('kojima_team'); $item->release_date = date("Y-m-d H:i:s", strtotime($request->input('release_date'))); $item->year = $request->input('year'); $item->slug = str_slug($request->input('name'), "-"); try { $item->save(); return redirect('/home/items'); } catch (\Illuminate\Database\QueryException $e) { var_dump($e->getMessage()); die; } } else { return 'No auth'; } }
public function manage($id) { $item = Item::find($id); return view('admin.items.manage', ['item' => $item]); }