controller.php

<?php

namespace App\Http\Controllers;

use App\CrewProgram;
use App\ProgramName;
use Carbon\Carbon;
use App\CrewMemo;
use App\PageRequest;
use Illuminate\Support\Facades\DB;
use Illuminate\Http\Request;
use App\Exports\ReportView;
use Excel;
use Maatwebsite\Excel\Concerns\ToArray;
use App\Http\Controllers\Controller;

class CrewProgramController extends Controller
{

    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        // $crewprogram = DB::connection('sqlsrv2')->select('select * from transaction_crewprogrammemo');

        // return view('CrewProgram.index', compact('crewprogram'));
        // return CrewProgram::all();
        // $dataall =  CrewProgram::orderBy('show_name','asc') ->get();
        // return view('Crewprogram.index', ['data' => $dataall]);
        $dataall = CrewProgram::all()->toArray();

        return view('Crewprogram.index', compact('dataall'));
        //
    }


    /* going to create an item*/
    public function createNew()
    {
        $dataemployee =  DB::connection('sqlsrv2')->select('cp_MstEmployee_Select');
        $dataprogram =  DB::connection('sqlsrv2')->select('sp_MstShow_CrewProgram_Select');
        $crewpositions =  DB::connection('sqlsrv2')->select('sp_crewProgramPositions_Select ');
        $dismissalcrew =  DB::connection('sqlsrv2')->select('sp_Crewprogrammemo_Placement_Select');
        // $getCpid =  DB::connection('sqlsrv2')->select('sp_Crewprogrammemo_Placement_Select');

        return view('CrewProgram.CreateNew.index', compact('dataprogram', 'dataemployee', 'crewpositions', 'dismissalcrew'));
    }

    public function saveData(Request $request){

        // $request = json_decode($request, true);
        // $request = json_decode($request->get('content'));
        // $request = json_decode($request->getContent());
        // $request = 'helo';
        $request = json_decode($request);

        // $transactionmemo = DB::connection('sqlsrv2')->insert('sp_Crewprogrammemo_Insert');
        // $transactionplacement = DB::connection('sqlsrv2')->insert('sp_Crewprogrammemo_Dismissal_Insert');
        // $transactiondismisal = DB::connection('sqlsrv2')->insert('sp_Crewprogrammemo_Placement_Insert');
        // return view('CrewProgram.succes')->render();
        // $getData = $request->tableplacement->employeNik;
        // $getData = 'failed';

        // foreach($request['tableplacement'] as $tablpl){
        //         // $getData = $tablpl->employeNik;
        //         $getData = $tablpl['employeeNik'];
        // };
        dd($request->all());
        // return Response::json(\App\Comment::get());
        // return dd($getData);
        // return view('CrewProgram.succes');

    }

    public function reportView()
    {
        // $dt = new DateTime();
        $startdate = '2020-02-24';
        $enddate = '2020-02-24';
        $criteria = '';
        $reportviewall = DB::connection('sqlsrv2')->select(
            'rp_CrewProgrammemo_All ?, ?, ?', array($startdate, $enddate, $criteria)
        );
        // $reportviewall = DB::connection('sqlsrv2')->select('rp_CrewProgrammemo_All(?, ?)');
        $reportviewactive = DB::connection('sqlsrv2')->select(
            'rp_CrewProgrammemo_Active ?,?,?', array($startdate, $enddate, $criteria)
        );
        $reportviewhistory = DB::connection('sqlsrv2')->select(
            'rp_CrewProgrammemo_History ?,?,?',  array($startdate, $enddate, $criteria)
        );
        return view('CrewProgram.ReportView.index', compact('reportviewall', 'reportviewactive', 'reportviewhistory'));
    }


    public function editView(Request $request){
        $dataemployee =  DB::connection('sqlsrv2')->select('cp_MstEmployee_Select');
        $dataprogram =  DB::connection('sqlsrv2')->select('sp_MstShow_CrewProgram_Select');
        $crewpositions =  DB::connection('sqlsrv2')->select('sp_crewProgramPositions_Select ');
        $dismissalcrew =  DB::connection('sqlsrv2')->select('sp_Crewprogrammemo_Placement_Select');

        return view('CrewProgram.EditView.index', compact('dataprogram', 'dataemployee', 'crewpositions', 'dismissalcrew'));
    }

    public function checkData() {
        echo 'store';
    }

    public function exportExcel(){
        $nama_file = 'report_view_'.date('Y-m-d_H-i-s').'.xlsx';
        return Excel::download(new ReportView, $nama_file);
    }

    public function deleteCrew(Request $request){
        $crewprogrammemoid = $request->$crewprogrammemo_id;
        //  DB::connection('sqlsrv2')->select('sp_Crewprogrammemo_Delete ?', $crewprogrammemoid);
        // return redirect('/crew_memo');
        return dd($crewprogrammemoid);
    }

}