<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\User;
use App\Dtmember;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Mail;
use App\EmailVerification;
use Illuminate\Support\Facades\Input;
use Carbon\Carbon;
use Illuminate\Support\Facades\Validator;
use Illuminate\Support\Str;
use Illuminate\Support\Facades\DB;

class ApiController extends Controller
{
    public function test(Request $r){

        $datas = DtMember::where('id_member',$r->id)->first();

        if($datas){
            $isSuccess = true;
            $response_status = 200;
            $message = 'sukses';
            $data = $datas;
        }else{
            $isSuccess = false;
            $response_status = 200;
            $message = 'gagal';
            $data = null;
        }

        return response()->json(compact('isSuccess','response_status','message','data'));
    }

    public function verifyMyEmail(Request $request){
        $token = $request->token;
        $eVerify = EmailVerification::where('token', $token)->firstOrFail();
        // cek mungkin token sudah diverifikasi
        if ($eVerify->status == "1") {
            $html_msg = "Verifikasi email GAGAL, token telah digunakan!";
        } else {
            // cari pengguna
            $user = User::find($eVerify->user_id);
            // ubah status juga
            $user->update(['active' => '1']);
            // update status
            $eVerify->update(['status' => '1']);
            // pesan
            $html_msg = "Verifikasi email berhasil! Silahkan <a href='" . url('login') . "'>masuk</a> untuk mulai menggunakan akun Anda :)";
        }

        return view('emails.success_verification', compact('html_msg'));
    }

    public function register(Request $request){
            $user = new User;
            $eVerif = new EmailVerification;
            //return $request->all();

            $insert = null;

            $name = $request->name;
            $email = $request->email;

            $mail = User::where('email', $email)->first();

                if (empty($mail)) {

                    $email = $request->email;
                        $password = bcrypt($request->password);
                        $active = 1;
                        $name = $request->name;
                        // Data ini akan di insert ke detail

                        $createUser = $user->create(compact('email','password', 'level', 'name'));
                        //get id
                        $user_id = $createUser->id;

                        $getVerificationToken = function () use($email)
                        {
                            $verifToken = sha1(date("D:m:Y") . "-" . $email);
                            return $verifToken;
                        };

                        $token = $getVerificationToken($email);
                        $eVerif->create(compact('user_id', 'token'));

                        // insert seller detail
                        $dat = array('name' => $name,
                            'body' => "Test mailoh",
                            'email' => $email,
                            'action_url' => route('register.verification', ['token' => $token]),
                        );

                        Mail::send('emails.email_verification', $dat, function($message) use($email) {
                                $message->to($email, 'no-reply')
                                        ->subject("no-reply: Verifikasi Email");
                                $message->from('ihsan@udacoding.com', 'Iwapi');
                            });

                    $isSuccess = true;
                    $message = "Register berhasil, Silahkan konfirmasi email Anda";
                    $response_status = 200;
                    $data = $request->all();

                    $isAvaiable = true;
                }elseif (!empty($mail)) {
                    $isAvaiable = false;
                    $message = "Email telah digunakan !";
                }
                return response()->json(compact('isSuccess', 'response_status', 'message', 'data'));
            // Mulai transaction
    }

    public function login(Request $request){
        $email = $request->email;
        $password = $request->password;

        $find = User::where('email', $email)->first();
        $users = DB::table('email_verifications')->where('user_id',$find->id)->first();

        if ($users->status == 1) {

             if (Auth::attempt(['email' => $email, 'password' => $password])) {
                // Authentication passed...
                $user = User::where('email', $email)->first();

                $isSuccess = true;
                $msg = "Login Succes";
                $data = $user;
            }
        }else{
            $isSuccess = false;
            $msg = "Login gagal! Silahkan konfirmasi email Anda Terlebih dahulu";
            $data = null;
        }
        return response()->json(compact('isSuccess', 'msg', 'data'));
    }

    public function user_profile(Request $request){

        $find = User::where('id', $request->id)->first();

        $dat = \App\Dtmember::where('id_user',$find->id)->first();

            $dat->id_dpc_asal;
            $dpc = \App\DpcAsal::where('id_dpc_asal',$dat->id_dpc_asal)->first();

            //dpc dan antek2 nya
            if(empty($dat->dpc_asal->nama_dpc)){
                null;
            }else{
                if(empty($dat->dpc_asal->kab)){
                   null;
                }else{
                    $dat->dpc_asal->kab->nama_kabupaten;
                    if(empty($dat->dpc_asal->kab->prov)){
                        null;
                    }else{
                        $dat->dpc_asal->kab->prov;
                    }
                }
                $dat->dpc_asal->nama_dpc;
            }

            // $dat->jabatan;

            $dat->agama;

            //kota dan antek2 nya
            if(empty($dat->kota)){
                null;
            }else{
                $dat->kota;
                if(empty($dat->kota->kab)){
                    null;
                }else{
                    $dat->kota->kab;
                    if(empty($dat->kota->kab->prov)){
                        null;
                    }else{
                        $dat->kota->kab->prov;
                    }
                }
            }

            $dat->pendidikan;
            $dat->sektor_usaha;
            $dat->jenis_usaha;

            //kota_kantor dan antek2 nya
            if(empty($dat->kota_kantor)){
                null;
            }else{
                $dat->kota_kantor;
                if(empty($dat->kota_kantor->kab)){
                    null;
                }else{
                    $dat->kota_kantor->kab;
                    if(empty($dat->kota_kantor->kab->prov)){
                        null;
                    }else{
                        $dat->kota_kantor->kab->prov;
                    }
                }
            }

        $find['member'] = $dat;

        if ($find) {
            $isSuccess = true;
            $msg = "Successs get data";
            $data = $find;
        }else{
            $isSuccess = false;
            $msg = "Failed get data";
            $data = null;
        }
        return response()->json(compact('isSuccess', 'msg', 'data'));
    }

    public function update_profile(Request $request){

        $id = $request->id;

        $user = User::findOrFail($id);

        $user->name = $request->name;

        if ($user) {
            $isSuccess = true;
            $msg = "Successs";
            $data = $user;
        }else{
            $isSuccess = false;
            $msg = "Failed";
            $data = null;
        }

        $user->save();

        return response()->json(compact('isSuccess', 'response_status', 'message', 'data'));
            // Mulai transaction
    }

    public function member_all(){
        $datas = \App\Dtmember::all();

        foreach($datas as $dat){
            $dat->id_dpc_asal;
            $dpc = \App\DpcAsal::where('id_dpc_asal',$dat->id_dpc_asal)->first();

            //dpc dan antek2 nya
            if(empty($dat->dpc_asal->nama_dpc)){
                null;
            }else{
                if(empty($dat->dpc_asal->kab)){
                   null;
                }else{
                    $dat->dpc_asal->kab->nama_kabupaten;
                    if(empty($dat->dpc_asal->kab->prov)){
                        null;
                    }else{
                        $dat->dpc_asal->kab->prov;
                    }
                }
                $dat->dpc_asal->nama_dpc;
            }

            // $dat->jabatan;

            $dat->agama;

            //kota dan antek2 nya
            if(empty($dat->kota)){
                null;
            }else{
                $dat->kota;
                if(empty($dat->kota->kab)){
                    null;
                }else{
                    $dat->kota->kab;
                    if(empty($dat->kota->kab->prov)){
                        null;
                    }else{
                        $dat->kota->kab->prov;
                    }
                }
            }

            $dat->pendidikan;
            $dat->sektor_usaha;
            $dat->jenis_usaha;

            //kota_kantor dan antek2 nya
            if(empty($dat->kota_kantor)){
                null;
            }else{
                $dat->kota_kantor;
                if(empty($dat->kota_kantor->kab)){
                    null;
                }else{
                    $dat->kota_kantor->kab;
                    if(empty($dat->kota_kantor->kab->prov)){
                        null;
                    }else{
                        $dat->kota_kantor->kab->prov;
                    }
                }
            }


        }

        if (!empty($datas)) {
            $isSuccess = true;
            $response_status = 200;
            $message = "Berhasil mendapatkan data";
        } else {
            $isSuccess = false;
            $response_status = 200;
            $message = "Gagal mendapatkan data";
        }

        $data = $datas;
        return response()->json(compact('isSuccess', 'response_status', 'message', 'data'));
    }

    public function member_search(Request $request){
        $nama_member = $request->nama_member;
        $datas = \App\Dtmember::where('nama_member','LIKE','%'.$nama_member.'%')->get();

        foreach($datas as $dat){
            $dat->id_dpc_asal;
            $dpc = \App\DpcAsal::where('id_dpc_asal',$dat->id_dpc_asal)->first();

            //dpc dan antek2 nya
            if(empty($dat->dpc_asal->nama_dpc)){
                null;
            }else{
                if(empty($dat->dpc_asal->kab)){
                   null;
                }else{
                    $dat->dpc_asal->kab->nama_kabupaten;
                    if(empty($dat->dpc_asal->kab->prov)){
                        null;
                    }else{
                        $dat->dpc_asal->kab->prov;
                    }
                }
                $dat->dpc_asal->nama_dpc;
            }

            $dat->jabatan;

            $dat->agama;

            //kota dan antek2 nya
            if(empty($dat->kota)){
                null;
            }else{
                $dat->kota;
                if(empty($dat->kota->kab)){
                    null;
                }else{
                    $dat->kota->kab;
                    if(empty($dat->kota->kab->prov)){
                        null;
                    }else{
                        $dat->kota->kab->prov;
                    }
                }
            }

            $dat->pendidikan;
            $dat->sektor_usaha;
            $dat->jenis_usaha;

            //kota_kantor dan antek2 nya
            if(empty($dat->kota_kantor)){
                null;
            }else{
                $dat->kota_kantor;
                if(empty($dat->kota_kantor->kab)){
                    null;
                }else{
                    $dat->kota_kantor->kab;
                    if(empty($dat->kota_kantor->kab->prov)){
                        null;
                    }else{
                        $dat->kota_kantor->kab->prov;
                    }
                }
            }


        }

        if (!empty($datas)) {
            $isSuccess = true;
            $response_status = 200;
            $message = "Berhasil mendapatkan data";
        } else {
            $isSuccess = false;
            $response_status = 200;
            $message = "Gagal mendapatkan data";
        }

        $data = $datas;
        return response()->json(compact('isSuccess', 'response_status', 'message', 'data'));
    }

    public function create_member(Request $request){
        $table = new Dtmember;

        $table->id_dpc_asal = $request->id_dpc_asal;

        $dpc = \App\DpcAsal::where('id_dpc_asal',$request->id_dpc_asal)->first();
        $kab = \App\Kabupaten::where('id_kabupaten',$dpc->id_kab)->first();
        $prov = \App\Provinsi::where('id_provinsi',$kab->id_provinsi)->first();
        $kode_kab = $kab->code_kabupaten;
        $kode_prov = $prov->kode_provinsi;

        $lastData = Dtmember::orderBy('id_member', 'desc')->first();
        $lastKode = ($lastData != false) ? $lastData->kode_member : '0000000-000-00';
        $lastKode = explode('-', $lastKode);

        $x = str_pad((int) $lastKode[0] + 1, 6, '0', STR_PAD_LEFT);

        $table->kode_member = $x . '-' . $kode_kab . '-' . $kode_prov;
        $table->id_tahun_gabung = $request->tahun_gabung;
        $table->id_user = $request->id_user;
        $table->nama_member = $request->nama_member;
        $table->email_member = $request->email_member;
        $table->id_jabatan_iwapi = $request->jabatan_iwapi;
        $table->tmpt_lahir = $request->tmpt_lahir;
        $table->tgl_lahir = $request->tgl_lahir;
        $table->no_ktp = $request->no_ktp;
        $table->alamat_rumah = $request->alamat_rumah;
        $table->id_agama = $request->id_agama;
        $table->id_kota = $request->id_kota;
        $table->no_hp = $request->no_hp;
        $table->id_jenjang_pendidikan = $request->id_jenjang_pendidikan;

        if($request->hasFile('foto_member')){
            $file = $request->file('foto_member');
            $file->move(public_path().'/foto_member',$file->getClientOriginalName());
            $table->foto_member = $file->getClientOriginalName();
        }else{
            $table->foto_member = null;
        }

        $table->nama_perusahaan = $request->nama_perusahaan;
        $table->jabatan_perusahaan = $request->jabatan_perusahaan;
        $table->alamat_kantor = $request->alamat_kantor;
        $table->fax_kantor = $request->fax_kantor;
        $table->id_kota_kantor = $request->kota_kantor;
        $table->no_tlp_kantor = $request->no_tlp_kantor;
        $table->email_kantor = $request->email_kantor;
        $table->web_kantor = $request->web_kantor;
        $table->id_sektor_usaha = $request->id_sektor_usaha;
        $table->id_jenis_usaha = $request->id_jenis_usaha;
        $table->jml_karyawan = $request->jml_karyawan;
        $table->is_kreditur = $request->is_kreditur;
        $table->is_situ_siup = $request->is_situ_siup;

        $table->tgl_bergabung = $request->tgl_bergabung;

        $table->save();

        if(!empty($table)){
            $isSuccess = true;
            $message = "Tambah Data Succes";
            $response_status = 200;
            $data = $table;
        }else{
            $isSuccess = false;
            $message = "Tambah Data gagal!";
            $response_status = 200;
            $data = null;
        }

        return response()->json(compact('isSuccess','response_status','message','data'));
    }

    public function add_member_kantor(Request $request, $id){

        $table = Dtmember::findOrFail($id);

        $table->id_dpc_asal = $request->id_dpc_asal;
        $table->id_user = $request->id_user;

        $dpc = \App\DpcAsal::where('id_dpc_asal',$request->id_dpc_asal)->first();
        $kab = \App\Kabupaten::where('id_kabupaten',$dpc->id_kab)->first();
        $prov = \App\Provinsi::where('id_provinsi',$kab->id_provinsi)->first();
        $kode_kab = $kab->code_kabupaten;
        $kode_prov = $prov->kode_provinsi;

        $lastData = Dtmember::orderBy('id_member', 'desc')->first();
        $lastKode = ($lastData != false) ? $lastData->kode_member : '0000000-000-00';
        $lastKode = explode('-', $lastKode);

        $x = str_pad((int) $lastKode[0] + 1, 6, '0', STR_PAD_LEFT);

        $table->kode_member = $x . '-' . $kode_kab . '-' . $kode_prov;
        $table->id_tahun_gabung = $request->tahun_gabung;
        $table->nama_member = $request->nama_member;
        $table->email_member = $request->email_member;
        $table->id_jabatan_iwapi = $request->jabatan_iwapi;
        $table->tmpt_lahir = $request->tmpt_lahir;
        $table->tgl_lahir = $request->tgl_lahir;
        $table->no_ktp = $request->no_ktp;
        $table->alamat_rumah = $request->alamat_rumah;
        $table->id_agama = $request->id_agama;
        $table->id_kota = $request->id_kota;
        $table->no_hp = $request->no_hp;
        $table->id_jenjang_pendidikan = $request->id_jenjang_pendidikan;

        if($request->hasFile('foto_member')){
            $file = $request->file('foto_member');
            $file->move(public_path().'/foto_member',$file->getClientOriginalName());
            $table->foto_member = $file->getClientOriginalName();
        }else{
            $table->foto_member = $table->foto_member;
        }

        $table->nama_perusahaan = $request->nama_perusahaan;
        $table->jabatan_perusahaan = $request->jabatan_perusahaan;
        $table->alamat_kantor = $request->alamat_kantor;
        $table->fax_kantor = $request->fax_kantor;
        $table->id_kota_kantor = $request->kota_kantor;
        $table->no_tlp_kantor = $request->no_tlp_kantor;
        $table->email_kantor = $request->email_kantor;
        $table->web_kantor = $request->web_kantor;
        $table->id_sektor_usaha = $request->id_sektor_usaha;
        $table->id_jenis_usaha = $request->id_jenis_usaha;
        $table->jml_karyawan = $request->jml_karyawan;
        $table->is_kreditur = $request->is_kreditur;
        $table->is_situ_siup = $request->is_situ_siup;
        $table->tgl_bergabung = $request->tgl_bergabung;

        $table->save();

        if(!empty($table)){
            $isSuccess = true;
            $message = "Tambah Data Succes";
            $response_status = 200;
            $data = $request->all();
        }else{
            $isSuccess = false;
            $message = "Tambah Data gagal!";
            $response_status = 200;
            $data = null;
        }

        return response()->json(compact('isSuccess','response_status','message','data'));
    }

    public function dpc_asal(){
        $datas = \App\DpcAsal::all();

        foreach($datas as $dat){
             if(empty($dat->nama_dpc)){
                null;
            }else{
                $dat->nama_dpc;
                if(empty($dat->kab)){
                   null;
                }else{
                    $dat->kab->nama_kabupaten;
                    if(empty($dat->kab->prov)){
                        null;
                    }else{
                        $dat->kab->prov;
                    }
                }
            }
        }

        if (!empty($datas)) {
            $isSuccess = true;
            $response_status = 200;
            $message = "Berhasil mendapatkan data";
        } else {
            $isSuccess = false;
            $response_status = 200;
            $message = "Gagal mendapatkan data";
        }

        $data = $datas;
        return response()->json(compact('isSuccess', 'response_status', 'message', 'data'));
    }

    public function kota(){
        $datas = \App\Kota::all();

        foreach($datas as $dat){
             //kota_kantor dan antek2 nya
           $dat->nama_kota;
                if(empty($dat->kab)){
                    null;
                }else{
                    $dat->kab;
                    if(empty($dat->kab->prov)){
                        null;
                    }else{
                        $dat->kab->prov;
                    }
                }
        }

        if (!empty($datas)) {
            $isSuccess = true;
            $response_status = 200;
            $message = "Berhasil mendapatkan data";
        } else {
            $isSuccess = false;
            $response_status = 200;
            $message = "Gagal mendapatkan data";
        }

        $data = $datas;
        return response()->json(compact('isSuccess', 'response_status', 'message', 'data'));
    }

    public function kabupaten(){
        $datas = \App\Kabupaten::all();

        foreach($datas as $dat){
             //kota_kantor dan antek2 nya
           if(empty($dat->prov)){
                        null;
                    }else{
                        $dat->prov;
                    }
        }

        if (!empty($datas)) {
            $isSuccess = true;
            $response_status = 200;
            $message = "Berhasil mendapatkan data";
        } else {
            $isSuccess = false;
            $response_status = 200;
            $message = "Gagal mendapatkan data";
        }

        $data = $datas;
        return response()->json(compact('isSuccess', 'response_status', 'message', 'data'));
    }

    public function jabatan(){
        $datas = \App\Jabatan::all();

        if (!empty($datas)) {
            $isSuccess = true;
            $response_status = 200;
            $message = "Berhasil mendapatkan data";
        } else {
            $isSuccess = false;
            $response_status = 200;
            $message = "Gagal mendapatkan data";
        }

        $data = $datas;
        return response()->json(compact('isSuccess', 'response_status', 'message', 'data'));
    }

    public function provinsi(){
        $datas = \App\Provinsi::all();

        if (!empty($datas)) {
            $isSuccess = true;
            $response_status = 200;
            $message = "Berhasil mendapatkan data";
        } else {
            $isSuccess = false;
            $response_status = 200;
            $message = "Gagal mendapatkan data";
        }

        $data = $datas;
        return response()->json(compact('isSuccess', 'response_status', 'message', 'data'));
    }

    public function agama(){
        $datas = \App\Agama::all();

        if (!empty($datas)) {
            $isSuccess = true;
            $response_status = 200;
            $message = "Berhasil mendapatkan data";
        } else {
            $isSuccess = false;
            $response_status = 200;
            $message = "Gagal mendapatkan data";
        }

        $data = $datas;
        return response()->json(compact('isSuccess', 'response_status', 'message', 'data'));
    }

    public function pendidikan(){
        $datas = \App\Pendidikan::all();

        if (!empty($datas)) {
            $isSuccess = true;
            $response_status = 200;
            $message = "Berhasil mendapatkan data";
        } else {
            $isSuccess = false;
            $response_status = 200;
            $message = "Gagal mendapatkan data";
        }

        $data = $datas;
        return response()->json(compact('isSuccess', 'response_status', 'message', 'data'));
    }

    public function jenis_usaha(){
        $datas = \App\JenisProduk::all();

        if (!empty($datas)) {
            $isSuccess = true;
            $response_status = 200;
            $message = "Berhasil mendapatkan data";
        } else {
            $isSuccess = false;
            $response_status = 200;
            $message = "Gagal mendapatkan data";
        }

        $data = $datas;
        return response()->json(compact('isSuccess', 'response_status', 'message', 'data'));
    }

    public function sektor_usaha(){
        $datas = \App\SektorUsaha::all();
        foreach($datas as $dat){
            if(empty($dat->detail_klbi)){
                null;
            }else{
                $dat->detail_klbi;
                if(empty($dat->detail_klbi->sub_sub_klbi)){
                    null;
                }else{
                    $dat->detail_klbi->sub_sub_klbi;

                    if(empty($dat->detail_klbi->sub_sub_klbi->sub_klbi)){
                        null;
                    }else{
                        $dat->detail_klbi->sub_sub_klbi->sub_klbi;

                        if(empty($dat->detail_klbi->sub_sub_klbi->sub_klbi->Kat_klbi)){
                            null;
                        }else{
                            $dat->detail_klbi->sub_sub_klbi->sub_klbi->Kat_klbi;

                        }
                    }
                }
            }
        }

        if (!empty($datas)) {
            $isSuccess = true;
            $response_status = 200;
            $message = "Berhasil mendapatkan data";
        } else {
            $isSuccess = false;
            $response_status = 200;
            $message = "Gagal mendapatkan data";
        }

        $data = $datas;
        return response()->json(compact('isSuccess', 'response_status', 'message', 'data'));
    }

    public function detail_klbi(){
        $datas = \App\DetailKLBI::all();

        foreach($datas as $dat){
            if(empty($dat->sub_sub_klbi)){
                null;
            }else{
                $dat->sub_sub_klbi;

                if(empty($dat->sub_sub_klbi->sub_klbi)){
                    null;
                }else{
                    $dat->sub_sub_klbi->sub_klbi;

                    if(empty($dat->sub_sub_klbi->sub_klbi->Kat_klbi)){
                        null;
                    }else{
                        $dat->sub_sub_klbi->sub_klbi->Kat_klbi;

                    }
                }
            }
        }

        if (!empty($datas)) {
            $isSuccess = true;
            $response_status = 200;
            $message = "Berhasil mendapatkan data";
        } else {
            $isSuccess = false;
            $response_status = 200;
            $message = "Gagal mendapatkan data";
        }

        $data = $datas;
        return response()->json(compact('isSuccess', 'response_status', 'message', 'data'));
    }

    public function sub_sub_klbi(){
        $datas = \App\SubSubKLBI::all();

        foreach($datas as $dat){
            if(empty($dat->sub_klbi)){
                null;
            }else{
                $dat->sub_klbi;

                if(empty($dat->sub_klbi->Kat_klbi)){
                    null;
                }else{
                    $dat->sub_klbi->Kat_klbi;

                }
            }
        }

        if (!empty($datas)) {
            $isSuccess = true;
            $response_status = 200;
            $message = "Berhasil mendapatkan data";
        } else {
            $isSuccess = false;
            $response_status = 200;
            $message = "Gagal mendapatkan data";
        }

        $data = $datas;
        return response()->json(compact('isSuccess', 'response_status', 'message', 'data'));
    }

    public function sub_klbi(){
        $datas = \App\SubKLBI::all();

        foreach($datas as $dat){
            if(empty($dat->Kat_klbi)){
                    null;
            }else{
                $dat->Kat_klbi;
            }
        }

        if (!empty($datas)) {
            $isSuccess = true;
            $response_status = 200;
            $message = "Berhasil mendapatkan data";
        } else {
            $isSuccess = false;
            $response_status = 200;
            $message = "Gagal mendapatkan data";
        }

        $data = $datas;
        return response()->json(compact('isSuccess', 'response_status', 'message', 'data'));
    }

    public function kat_klbi(){
        $datas = \App\KatKLBI::all();

        if (!empty($datas)) {
            $isSuccess = true;
            $response_status = 200;
            $message = "Berhasil mendapatkan data";
        } else {
            $isSuccess = false;
            $response_status = 200;
            $message = "Gagal mendapatkan data";
        }

        $data = $datas;
        return response()->json(compact('isSuccess', 'response_status', 'message', 'data'));
    }
}