<?php

namespace App\Http\Controllers;

use App\Models\Material;
use App\Models\Upah;
use App\Models\AhsKategori;
use App\Models\Ahs;
use App\Models\Pemeriksaan;
use App\Models\AhsVendor;
use App\Models\ImagesPemeriksaan;
use App\Models\VendorKategori;
use App\Models\DetailQc;
use Illuminate\Http\Request;

class QcController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        set_time_limit(0);
        $materials = Material::all();
        $menu_master = '';
        $upahs     = Upah::all();
        $ahsKategoris      = AhsKategori::orderBy('urutan', 'asc')->get();
        $vendorKategoris      = VendorKategori::orderBy('urutan', 'asc')->get();
        return view('staff.list-qc', compact('ahsKategoris', 'vendorKategoris', 'upahs', 'materials', 'menu_master'));
    }

    /**
     * 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)
    {
        $id_ahs = $request->get('id');
        $value_pemeriksaan = $request->get('pemeriksaan');
        $failure = $request->get('failure');
        $jenis_pemeriksaan = $request->get('jenis_pemeriksaan');
        $jenis = $request->get('jenis');

        if ($jenis == 'ahs') {
            $pemeriksaan = new Pemeriksaan();
            $pemeriksaan->id_ahs = $id_ahs;
            $pemeriksaan->pemeriksaan = $value_pemeriksaan;
            $pemeriksaan->save();
            $id_pemeriksaan = $pemeriksaan->id;

             // Image
             if($request->file('image')) {
                 for($i = 0; $i <= count($request->file('image')) - 1; $i++) {
                    $location = public_path('uploads/');
                    $file = $request->file('image')[$i];
                    $file->move($location, $file->getClientOriginalName());
                    $images = new ImagesPemeriksaan();
                    $images->name = 'uploads/' . $file->getClientOriginalName();
                    $images->id_pemeriksaan = $id_pemeriksaan;
                    $images->save();

                 }
             }

            // Add Jenis Pemeriksaan

            if (!empty($jenis_pemeriksaan)) {
                for ($i = 0; $i <= count($jenis_pemeriksaan) - 1; $i++) {
                    if ($jenis_pemeriksaan[$i] != NULL) {
                        $detail_qc = new DetailQc();
                        $detail_qc->id_pemeriksaan = $id_pemeriksaan;
                        $detail_qc->jenis_pemeriksaan = $jenis_pemeriksaan[$i];
                        $detail_qc->failure = $failure[$i];
                        $detail_qc->created_at = date('Y-m-d H:i:s');
                        $detail_qc->save();
                    }
                }
            }
        } else if ($jenis == 'ahs_vendor') {
            $pemeriksaan = new Pemeriksaan();
            $pemeriksaan->id_ahs_vendor = $id_ahs;
            $pemeriksaan->pemeriksaan = $value_pemeriksaan;
            $pemeriksaan->save();
            $id_pemeriksaan = $pemeriksaan->id;

             // Image
             if($request->file('image')) {
                 for($i = 0; $i <= count($request->file('image')) - 1; $i++) {
                    $location = public_path('uploads/');
                    $file = $request->file('image')[$i];
                    $file->move($location, $file->getClientOriginalName());
                    $images = new ImagesPemeriksaan();
                    $images->name = 'uploads/' . $file->getClientOriginalName();
                    $images->id_pemeriksaan = $id_pemeriksaan;
                    $images->save();

                 }
             }

            // Add Jenis Pemeriksaan

            if (!empty($jenis_pemeriksaan)) {
                for ($i = 0; $i <= count($jenis_pemeriksaan) - 1; $i++) {
                    if ($jenis_pemeriksaan[$i] != NULL) {
                        $detail_qc = new DetailQc();
                        $detail_qc->id_pemeriksaan = $id_pemeriksaan;
                        $detail_qc->jenis_pemeriksaan = $jenis_pemeriksaan[$i];
                        $detail_qc->failure = $failure[$i];
                        $detail_qc->created_at = date('Y-m-d H:i:s');
                        $detail_qc->save();
                    }
                }
            }
        }

        return redirect()->route('qc.index')->with('msg', 'Data QC Berhasil Disimpan');
    }

    /**
     * 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)
    {
        $value_pemeriksaan = $request->get('pemeriksaan');
        $failure = $request->get('failure');
        $jenis_pemeriksaan = $request->get('jenis_pemeriksaan');

        $pemeriksaan = Pemeriksaan::findOrFail($id);
        $pemeriksaan->pemeriksaan = $value_pemeriksaan;

        // Image
        if($request->file('image')) {
            for($i = 0; $i <= count($request->file('image')) - 1; $i++) {
               $location = public_path('uploads/');
               $file = $request->file('image')[$i];
               $file->move($location, $file->getClientOriginalName());
               $images = new ImagesPemeriksaan();
               $images->name = 'uploads/' . $file->getClientOriginalName();
               $images->id_pemeriksaan = $id;
               $images->save();
            }
        }


        // Delete Jenis Pemeriksaan
        DetailQc::where('id_pemeriksaan', $id)->delete();

        // Add Jenis Pemeriksaan
        if (!empty($jenis_pemeriksaan)) {
            for ($i = 0; $i <= count($jenis_pemeriksaan) - 1; $i++) {
                if ($jenis_pemeriksaan[$i] != NULL) {
                    $detail_qc = new DetailQc();
                    $detail_qc->id_pemeriksaan = $id;
                    $detail_qc->jenis_pemeriksaan = $jenis_pemeriksaan[$i];
                    $detail_qc->failure = $failure[$i];
                    $detail_qc->created_at = date('Y-m-d H:i:s');
                    $detail_qc->save();
                }
            }
        }

        return redirect()->route('qc.index')->with('msg', 'Data QC Berhasil Diupdate');
    }

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

        return redirect()->route('qc.index')->with('msg', 'Data Pemeriksaan Berhasil Dihapus');
    }

    public static function getJenisPemeriksaan($id)
    {
        $jenis_pemeriksaan = DetailQc::where('id_ahs', $id)->get();
        $html = '';

        foreach ($jenis_pemeriksaan as $j) {
            $html .= $j->jenis_pemeriksaan . '<br>';
        }

        return $html;
    }

    public static function getJenisPemeriksaanVendor($id)
    {
        $jenis_pemeriksaan = DetailQc::where('id_ahs_vendor', $id)->get();
        $html = '';

        foreach ($jenis_pemeriksaan as $j) {
            $html .= $j->jenis_pemeriksaan . '<br>';
        }

        return $html;
    }

    public function ajaxJenisPemeriksaan(Request $request)
    {
        $id = $request->get('id_pemeriksaan');

        $jenis_pemeriksaan = DetailQc::where('id_pemeriksaan', $id)->get();

        $html = '';

        $html .= '<div class="col-md-6 col-sm-6 update-append-jenis-pemeriksaan">
        <label>Jenis Pemeriksaan</label>';
        foreach($jenis_pemeriksaan as $j) {
          $html .=  '<label for="jenis-pemeriksaan" class="control-label plus-jenis-pemeriksaan"></label>
            <div class="plus-jenis-pemeriksaan">
                <input id="jenis_pemeriksaan" type="text" class="form-control" value="'.$j->jenis_pemeriksaan.'" name="jenis_pemeriksaan[]">
            </div>';
        }
        
        $html .= '</div>';

       $html .= '<div class="col-md-6 col-sm-6 update-append-failure">
        <label>Failure</label>';
        foreach($jenis_pemeriksaan as $j) {
        $html .= '<label for="failure" class="control-label plus-failure"></label>
            <div class="plus-failure">
                <input id="failure" value="'.$j->failure.'" type="text" class="form-control" name="failure[]">
            </div>';
        }

        $html .= '</div>';

        echo $html;
    }
    
    public function deleteImage(Request $request)
    {
        $id_image = $request->get('id_image');
        $images = ImagesPemeriksaan::findOrFail($id_image);
        $image_path = $images->name;

        if(ImagesPemeriksaan::where('name', $images->name)->count() == 1) {
            if(file_exists(storage_path('app/public/' . $image_path))){
            \Storage::delete('public/'.$image_path);
            }
            ImagesPemeriksaan::destroy($id_image);
        }
    }

    public function copyPemeriksaan(Request $request) {
        $id_pemeriksaan = $request->get('id');
        $jenis = $request->get('jenis');
        $id_ahs = $request->get('id_ahs');
        $ahs = explode('-', $id_ahs);
        
        $pemeriksaan = Pemeriksaan::findOrFail($id_pemeriksaan);
        
        $new_pemeriksaan = new Pemeriksaan();
        if($ahs[1] == 'ahs') {
            $new_pemeriksaan->id_ahs = $ahs[0];
        } else if($ahs[1] == 'vendor') {
            $new_pemeriksaan->id_ahs_vendor = $ahs[0];
        }
        $new_pemeriksaan->pemeriksaan = $pemeriksaan->pemeriksaan;
        $new_pemeriksaan->save();

        if(DetailQc::where('id_pemeriksaan', $id_pemeriksaan)->count() > 0) {
            foreach(DetailQc::where('id_pemeriksaan', $id_pemeriksaan)->get() as $p) {
                $detail = new DetailQc();
                $detail->id_pemeriksaan = $new_pemeriksaan->id;
                $detail->jenis_pemeriksaan = $p->jenis_pemeriksaan;
                $detail->failure = $p->failure;
                $detail->save();
            }
        }

        if(ImagesPemeriksaan::where('id_pemeriksaan', $id_pemeriksaan)->count() > 0) {
            foreach(ImagesPemeriksaan::where('id_pemeriksaan', $id_pemeriksaan)->get() as $i) {
                $images = new ImagesPemeriksaan();
                $images->name = $i->name;
                $images->id_pemeriksaan = $new_pemeriksaan->id;
                $images->save();
            }
        }

        return redirect()->route('qc.index')->with('msg', 'Pemeriksaan Successfully Copied');

    }

    public function copyAllPemeriksaan(Request $request) {
        $id = $request->get('id');
        $jenis = $request->get('jenis');
        $id_ahs = $request->get('id_ahs');
        $ahs = explode('-', $id_ahs);
        
        if($jenis == 'ahs') {
            $pemeriksaan = Pemeriksaan::where('id_ahs', $id)->get();
        } else if($jenis == 'ahs_vendor') {
            $pemeriksaan = Pemeriksaan::where('id_ahs_vendor', $id)->get();
        }

        if(!empty($pemeriksaan)) {
            foreach($pemeriksaan as $p) {
                $new_pemeriksaan = new Pemeriksaan();
                if($ahs[1] == 'ahs') {
                    $new_pemeriksaan->id_ahs = $ahs[0];
                } else if($ahs[1] == 'vendor') {
                    $new_pemeriksaan->id_ahs_vendor = $ahs[0];
                }
                $new_pemeriksaan->pemeriksaan = $p->pemeriksaan;
                $new_pemeriksaan->save();

                if(DetailQc::where('id_pemeriksaan', $p->id)->count() > 0) {
                    foreach(DetailQc::where('id_pemeriksaan', $p->id)->get() as $pa) {
                        $detail = new DetailQc();
                        $detail->id_pemeriksaan = $new_pemeriksaan->id;
                        $detail->jenis_pemeriksaan = $pa->jenis_pemeriksaan;
                        $detail->failure = $pa->failure;
                        $detail->save();
                    }
                }
        
                if(ImagesPemeriksaan::where('id_pemeriksaan', $p->id)->count() > 0) {
                    foreach(ImagesPemeriksaan::where('id_pemeriksaan', $p->id)->get() as $ia) {
                        $images = new ImagesPemeriksaan();
                        $images->name = $ia->name;
                        $images->id_pemeriksaan = $new_pemeriksaan->id;
                        $images->save();
                    }
                }
            }
        }

        return redirect()->route('qc.index')->with('msg', 'Pemeriksaan Successfully Copied');

    }
}