Suketpengajuancontroller.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Suketpengajuan;
use App\User;


class SuketpengajuanController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        //
        return view('suketpengajuan.save');
    }



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

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        //
        // return $request->all(); => untuk membaca data JSON yang datanya telah dimasukkan
        // return $request->nama_lengkap(); => untuk membaca data JSON yang munculnya hanya data nama lengkapnya saja

        $request->validate(['keperluan' => 'required|unique:suketpengajuan|min:5']);

        $suketpengajuan = New suketpengajuan();
        //$suketpengajuan->create($request->all());
        //return redirect('/suketpengajuan');


        $getNoSK = \DB::select("SELECT NoSK FROM suketpengajuan ORDER BY NoSK DESC LIMIT 1");

        $NoSK = $getNoSK[0]->NoSK;
        $getYear = date('y');
        $NoSK = str_replace("SK","",$NoSK) + 1;
        $NoSK = "SK".$NoSK;
        $dataSet = [
                'NoSK' => $NoSK,
                'id' => $request->id,
                'nama_lengkap'  => $request->nama_lengkap,
                'TglSurat' => date('d:m:Y'),
                'Alamat'    => $request->alamat,
                'Keperluan'   => $request->keperluan,
                'Status' => $request->status
            ];
        //\DB::table('suketpengajuan')->insert($dataSet);
        return view('suketpengajuan.submit', $dataSet);

    }

    public function simpanpengajuan(Request $request, $NoSK){
        $dataSet = [
            'NoSK' => $request->NoSK,
            'id' => $request->id,
            'nama_lengkap'  => $request->nama_lengkap,
            'TglSurat' => $request->TglSurat,
            'Alamat'    => $request->alamat,
            'Keperluan'   => $request->keperluan,
            'Status' => 'Sudah Diterima HRD',
            'TglSubmit' => Carbon\Carbon::now()
        ];

        $save = \DB::table('suketpengajuan')->insert($dataSet);
        if($save){


            $datafix = DB::select("SELECT * FROM suketpengajuan WHERE NoSK == $NoSK")->get();

            $datask = [

                'NoSK' => $datafix->NoSK,
                'nama_lengkap' => $datafix->nama_lengkap,
                'TglSurat' => $datafix->TglSurat,
                'Alamat' => $datafix->Alamat,
                'Keperluan' => $datafix->Keperluan,
                'Status' => $datafix->Status
            ];
          return view('suketpengajuan.receive', $datask);

        }else{
            echo "Gagal Menyimpan";
        }
    }


    public function selesaisubmit($NoSK){

        $aftersubmit = DB::table('suketpengajuan')
                       ->where('NoSK', '=', $NoSK)
                       ->get();

        $aftersubmit = [

            'NoSK' => $aftersubmit->NoSK,
            'nama_lengkap' => $aftersubmit->nama_lengkap,
            'TglSurat' => $aftersubmit->TglSurat,
            'Alamat' => $aftersubmit->Alamat,
            'Keperluan' => $aftersubmit->Keperluan,
            'Status' => $aftersubmit->Status
        ];

        return view('suketpengajuan.receive', $aftersubmit);
    }
    /**
     * 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)
    {
        //
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        //
    }
}