<?php

namespace App\Http\Controllers;

use App\Models\Project;
use App\Models\Rab;
use App\Models\DetailQc;
use App\Models\Pemeriksaan;
use App\Models\Qc;
use App\Models\QcDetail;
use App\Models\ImagesPemeriksaan;
use App\Models\RabDetail;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;

class ProjectQcController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $level = Auth::user()->level;
        if (strtoupper($level) == 'SUPERADMIN' || strtoupper($level) == 'GENERAL MANAGER' || strtoupper($level) == 'FINANCE MANAGER' || strtoupper($level) == 'SUPPLY CHAIN MANAGER' || strtoupper($level) == 'MARKETING MANAGER' || strtoupper($level) == 'PROJECT MANAGER') {
        $qc = Qc::orderBy('created_at', 'desc')->get();
        } else {
            $qc = Qc::where('id_user', Auth::user()->id)->orderBy('created_at', 'desc')->get();
        }
        return view('staff.project-qc', compact('qc'));
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        $project = Project::whereHas('rab.rabDetails.ahs.pemeriksaan')->orWhereHas('rab.rabDetails.ahs_vendor.pemeriksaan')->get();
        return view('staff.create-projectqc', compact('project'));
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        $id_project = $request->get('id_project');
        $pekerjaan = $request->get('id_pekerjaan');
        $id_pemeriksaan = $request->get('id_pemeriksaan');
        $explode = explode('-', $pekerjaan);
        $id_user = Auth::user()->id;
        $lokasi = $request->get('lokasi');

        $qc = new Qc();
        $qc->id_project = $id_project;
        $qc->id_user = $id_user;
        $qc->lokasi = $lokasi;
        if ($explode[1] == 'ahs') {
            $qc->id_ahs = $explode[0];
        } else if ($explode[1] == 'ven') {
            $qc->id_ahs_vendor = $explode[0];
        }
        $qc->save();

        $id_qc = $qc->id;

        for ($i = 0; $i <= count($id_pemeriksaan) - 1; $i++) {
            for ($a = 0; $a <= count($request->get('jenis_pemeriksaan_' . $i)) - 1; $a++) {
                $qcdetail = new QcDetail();
                $qcdetail->id_qc = $id_qc;
                $qcdetail->id_pemeriksaan = $id_pemeriksaan[$i];
                $qcdetail->jenis_pemeriksaan = $request->get('jenis_pemeriksaan_' . $i)[$a];
                $qcdetail->failure = $request->get('failure_' . $i)[$a];
                $qcdetail->status = $request->get('ket_choice-' . $a . '-' . $i);
                $qcdetail->keterangan = $request->get('keterangan-' . $a . '-' . $i);
                $qcdetail->save();
            }
        }

        return redirect()->route('projectqc.index')->with('msg', 'QC Project Berhasil Diinput');
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        $qc = Qc::findOrfail($id);
        if ($qc->id_ahs != NULL) {
            $pemeriksaan = Pemeriksaan::where('id_ahs', $qc->id_ahs)->get();
        } elseif ($qc->id_ahs_vendor != NULL) {
            $pemeriksaan = Pemeriksaan::where('id_ahs_vendor', $qc->id_ahs_vendor)->get();
        }
        return view('staff.detail-projectqc', compact('qc', 'pemeriksaan'));
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        $qc = Qc::findOrfail($id);
        $id_qc = $id;
        if ($qc->id_ahs != NULL) {
            $pemeriksaan = Pemeriksaan::where('id_ahs', $qc->id_ahs)->get();
        } elseif ($qc->id_ahs_vendor != NULL) {
            $pemeriksaan = Pemeriksaan::where('id_ahs_vendor', $qc->id_ahs_vendor)->get();
        }
        return view('staff.edit-projectqc', compact('qc', 'pemeriksaan', 'id_qc'));
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        $qc = Qc::findOrfail($id);
        $qc->lokasi = $request->get('lokasi');
        $qc->save();

        QcDetail::where('id_qc', $id)->delete();
        $id_pemeriksaan = $request->get('id_pemeriksaan');

        for ($i = 0; $i <= count($id_pemeriksaan) - 1; $i++) {
            for ($a = 0; $a <= count($request->get($id_pemeriksaan[$i] . '-jumlah')) - 1; $a++) {
                $qc_detail = new QcDetail();
                $qc_detail->id_qc = $id;
                $qc_detail->id_pemeriksaan = $id_pemeriksaan[$i];
                $qc_detail->jenis_pemeriksaan = $request->get($id_pemeriksaan[$i] . '-nama')[$a];
                $qc_detail->failure = $request->get($id_pemeriksaan[$i] . '-failure')[$a];
                $qc_detail->status = $request->get($id_pemeriksaan[$i] . '-' . $a . '-status');
                $qc_detail->keterangan = $request->get($id_pemeriksaan[$i] . '-' . $a . '-keterangan');
                $qc_detail->save();
            }
        }

        return redirect()->route('projectqc.index')->with('msg', 'QC Berhasil Diubah');
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
         Qc::destroy($id);
        return redirect()->route('projectqc.index')->with('msg', 'Qc Berhasil Dihapus');
    }

    public function getProject(Request $request)
    {
        $id_project = $request->get('id_project');
        $rab = Rab::where('id_project', $id_project)->first();
        $pekerjaan = RabDetail::where('id_rab', $rab->id)->get();

        $html = '';
        $html .= '<select class="form-control" name="id_pekerjaan" id="select-pekerjaan" style="width:100% !important;" required>
            <option value="" selected disabled>--Pilih Pekerjaan--</option>
        ';

        if (!empty($pekerjaan)) {
            foreach ($pekerjaan as $p) {
                if ($p->id_ahs != NULL) {
                    $count = Pemeriksaan::where('id_ahs', $p->id_ahs)->count();
                    if ($count > 0) {
                        $html .= '<option value="' . $p->ahs->id . '-ahs">' . $p->ahs->nama_pekerjaan . '</option>';
                    }
                } else if ($p->id_ahs_vendor != NULL) {
                    $count = Pemeriksaan::where('id_ahs_vendor', $p->id_ahs_vendor)->count();
                    if ($count > 0) {
                        $html .= '<option value="' . $p->ahs_vendor->id . '-ven">' . $p->ahs_vendor->vendor->nama_pekerjaan . '</option>';
                    }
                }
            }
        }

        $html .= '</select>';

        echo $html;
    }

    public function getPemeriksaan(Request $request)
    {
        $id_pekerjaan = $request->get('id_pekerjaan');
        $explode = explode('-', $id_pekerjaan);

        if ($explode[1] == 'ahs') {
            $pemeriksaan = Pemeriksaan::where('id_ahs', $explode[0])->get();
        } elseif ($explode[1] == 'ven') {
            $pemeriksaan = Pemeriksaan::where('id_ahs_vendor', $explode[0])->get();
        }
        $html = '';
        $html .= '<div class="scroll">';
        $html .= '<table id="table-data" class="table table-striped bulk_action">';
        $html .= '<thead>
                    <th>No</th>
                    <th>Image</th>
                    <th>Pemeriksaan</th>
                    <th>Failure</th>
                    <th>Jenis Pemeriksaan</th>
                    <th colspan="3" class="text-center">Keterangan</th>
                    </thead>
                    <tbody>
        ';

        $i = 1;
        $e = 0;
        foreach ($pemeriksaan as $r) {
            $html .= '<tr>';
            $html .= '<td>' . $i . '</td>';

            //Image
            $html .= '<td>';

            if (ImagesPemeriksaan::where('id_pemeriksaan', $r->id)->count() > 0) {

                $html .= '<a href="'.asset(ImagesPemeriksaan::where('id_pemeriksaan', $r->id)->first()->name).'"  data-lightbox="roadtrip-ahs-'.$r->id.'"><img src="'.asset(ImagesPemeriksaan::where('id_pemeriksaan', $r->id)->first()->name).'" width="50"></a>';
                        
                $im = 1;
                foreach ($r->images_pemeriksaan as $ri) {
                    if ($im != 1) {
                    $html .= '<div style="none">
                    <a href="'.asset($ri->name).'" data-lightbox="roadtrip-ahs-'.$r->id.'"></a>
                        </div>';
                    }
                    $im++;
                }
            }

            $html .= '</td>';

            $html .= '<td>'.$r->pemeriksaan.'</td>';

            // Failure

            $html .= '<td><ul>';
            $failure = DetailQc::where('id_pemeriksaan', $r->id)->get();
            foreach ($failure as $f) {
                $html .= '<li>' . $f->failure . '<input type="hidden" name="failure_' . $e .  '[]" value="' . $f->failure . '"></li>';
            }

            $html .= '</ul></td>';

            // Nama Jenis Pemeriksaan

            $html .= '<td><ul>';
            $jenis_pemeriksaan = DetailQc::where('id_pemeriksaan', $r->id)->get();
            foreach ($jenis_pemeriksaan as $j) {
                $html .= '<li>' . $j->jenis_pemeriksaan . '<input type="hidden" name="jenis_pemeriksaan_' . $e .  '[]" value="' . $j->jenis_pemeriksaan . '"></li>';
            }

            $html .= '</ul></td>';

            // Ya
            $html .= '<td><ul>';
            $a = 0;
            $jenis_pemeriksaan = DetailQc::where('id_pemeriksaan', $r->id)->get();
            foreach ($jenis_pemeriksaan as $j) {
                $html .= '<li><input type="radio" name="ket_choice-' . $a . '-' . $e . '" value="Ya"> Ya</li>';
                $a++;
            }

            $html .= '</ul></td>';

            // Tidak
            $html .= '<td><ul>';
            $b = 0;
            $jenis_pemeriksaan = DetailQc::where('id_pemeriksaan', $r->id)->get();
            foreach ($jenis_pemeriksaan as $j) {
                $html .= '<li><input type="radio" name="ket_choice-' . $b . '-' . $e . '" value="Tidak"> Tidak</li>';
                $b++;
            }

            $html .= '</ul></td>';

            // Keterangan
            $html .= '<td><ul>';

            $c = 0;
            $jenis_pemeriksaan = DetailQc::where('id_pemeriksaan', $r->id)->get();
            foreach ($jenis_pemeriksaan as $j) {
                $html .= '<li><input type="text" name="keterangan-' . $c . '-' . $e . '"></li>';
                $c++;
            }

            $html .= '</ul></td>';

            $html .= '</tr>';
            $i++;
            $e++;
        }

        $html .= '<tbody></table></div>';

        echo $html;
    }
}