1#@!#!123s

ALWAYS HENGHENG888 1#@!#!123s
: / var / www / priyotraveller.com / app / Http / Controllers /
Filename : GoldenPriceDetailsController.php
back
<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use DB;
use App\GoldenInfo;
use App\GoldenPrice;


class GoldenPriceDetailsController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $goldenTypes = GoldenInfo::all();
        $us = GoldenPrice::all();

        $us = DB::table('golden_prices')
                ->join('golden_infos', 'golden_infos.id', '=', 'golden_prices.golden_id')
                ->select('golden_prices.*', 'golden_infos.goldenTypeEng')
                ->get();
        return view('admin.n24_goldenPriceDetails', ['us' => $us, 'goldenTypes' => $goldenTypes]);
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        //
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        $this->validate($request, [
            'golden_id' => 'required',
            'goldenRate' => 'required',
            ]);

        DB::table('golden_prices')->insert([
            'golden_id' => $request->golden_id,
            'goldenRate' => $request->goldenRate,
            "created_at" =>  \Carbon\Carbon::now(),
            "updated_at" => \Carbon\Carbon::now()
        ]);

        return redirect('/admin/n24_goldenPriceDetails')->with('message_success', 'Golden Price save Successfully');
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        $sql = DB::table('golden_prices')
                ->where('id', $id)
                ->update([
                    'golden_id' => $request->golden_id,
                    'goldenRate' => $request->goldenRate,
                    'updated_at' => \Carbon\Carbon::now()
            ]);
            return redirect('/admin/n24_goldenPriceDetails')->with('message_success', 'Golden Price Info Update Successfully');
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        $us = GoldenPrice::find($id);
     if($us){
          GoldenPrice::destroy($id);
          \Session::flash('message_delete', 'Golden Price info Deleted Successfully');
          return redirect()->back();
      } else {
          \Session::flash('message_delete', 'Golden price info doesn\'t found');
          return redirect()->back();
      }
    }
}