<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Trial;
use App\Client_produk;
use App\RiwayatPembayaran;
use Illuminate\Support\Facades\Hash;
use App\Promo;
use App\Harga;
use App\PaketAplikasi;
use App\PaketPeriod;
use App\PaketVariable;

class ProdukController extends Controller
{
    public function emka()
    {
        $client = Client_produk::where('aplikasi','emka')->get();
        $trial = Trial::where('id',1)->get();
        $promo = Promo::where('aplikasi','emka')->get();
        $harga = Harga::where('aplikasi','emka')->get();
        $paket = PaketAplikasi::where('aplikasi','emka')->get();
        return view('produk.emka',compact('trial','client','promo','harga','paket'));
    }
    public function emkatrial(Request $request){
        $trial = Trial::where('id', $request -> id) -> update([
            'masa_trial' => $request -> trial,
        ]);
        return redirect()->route('produk.emka')->with('message', 'Trial Has Been Updated');
    }

    public function clientemka(Request $request){
        $user = New Client_produk;
        $fullname = $request->firstname." ".$request->lastname;
        $user->fullname = $fullname;
        $user->email = $request->email;
        $user->username = $request->firstname.$request->lastname;
        $user->status = 'trial';
        $user->create_trial = date("Y-m-d");
        $user->aplikasi = 'emka';
        $user->save();
        // return "Success";
    }

    public function trialtoemka(){
        return Trial::where('aplikasi','emka')->get();
    }
    public function bayaremka($email,$paket){
        $mail = $email;
        $paket = $paket;
        return view('produk.bayaremka', compact('mail','paket'));
    }
    public function bayaremkapromo($email,$paket,$promo){
        $mail = $email;
        $paket = $paket;
        $promo = $promo;
        return view('produk.bayaremkapromo', compact('mail','paket','promo'));
    }
    public function buktiemka(Request $request){
        if($request->promo){
            $emka = New RiwayatPembayaran;

            $file = $request->file('file');
            $name_image = $file->getClientOriginalName();
            $file->getClientOriginalExtension();
            $file->getRealPath();
            $file->getSize();
            $file->getMimeType();
            $tujuan_upload = 'bukti_pembayaran';
            $file->move($tujuan_upload,$file->getClientOriginalName());
    
            $emka->email = $request->email;
            $emka->aplikasi = 'emka';
            $emka->tanggal = date("Y-m-d");
            $emka->image = $name_image;
            $emka->paket = $request->paket;
            $emka->promo = $request->promo;
            $emka->save();
        }else{
            $emka = New RiwayatPembayaran;
            $file = $request->file('file');
            $name_image = $file->getClientOriginalName();
            $file->getClientOriginalExtension();
            $file->getRealPath();
            $file->getSize();
            $file->getMimeType();
            $tujuan_upload = 'bukti_pembayaran';
            $file->move($tujuan_upload,$file->getClientOriginalName());
            $emka->email = $request->email;
            $emka->aplikasi = 'emka';
            $emka->tanggal = date("Y-m-d");
            $emka->image = $name_image;
            $emka->paket = $request->paket;
            $emka->save();
        }

        return redirect()->route('template.emka')->with('message', 'Pembayaran Diterima');
    }

    public function riwayatbayaremka($email){
        $riwayat = RiwayatPembayaran::where('email',$email)
        ->where('aplikasi','emka')
        ->get();
        return view('produk.riwayatemka',compact('riwayat'));
    }
    public function aktifemka($email,$idpaket){
        $paket = Harga::where('aplikasi','emka')
        ->where('id',$idpaket)
        ->get()
        ->first();
        $period = $paket->period;
        
        $rentperiod = date('Y-m-d', strtotime('+'.$period.'days', strtotime(date('Y-m-d'))));
        $aktif = Client_produk::where('email', $email)
        -> where('aplikasi','emka') 
        -> update([
            'status' => 'rent',
            'rent_period' => $rentperiod,
        ]);

        $json = [ 
            'email' => $email,
            'rent_period' => $rentperiod,
        ];

        $ch = curl_init();
        $encode = json_encode($json);
        curl_setopt($ch, CURLOPT_URL, 'https://emka.binggo.co.id/api/changestatus');
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_POSTFIELDS, $encode);
        
        $headers = [ 
            'Content-Type: application/json'
          ];
        
        curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
        
        $result = curl_exec($ch);
        if (curl_errno($ch)) {
            echo 'Error:' . curl_error($ch);
        }else{
          echo $result;
        }
        curl_close($ch);

        return redirect()->route('produk.emka')->with('message', 'App User Has Been Updated');
    }

    public function newpromo(){
        return view('produk.newpromoemka');
    }
    public function promoemkacreate(Request $request){
        $promo = New Promo;
        $promo->kode = $request->kode;
        $promo->potongan = $request->potongan;
        $promo->tanggal_awal = $request->tanggal_awal;
        $promo->tanggal_akhir = $request->tanggal_akhir;
        $promo->aplikasi = 'emka';
        $promo->save();
        return redirect()->route('produk.emka')->with('message', 'Promo Has Been Saved');
    }
    public function promoemkaupdate(Request $request){
        $id = $request->get('id');
        $promo = Promo::findOrFail($id);
        $promo->kode = $request->get('kode');
        $promo->potongan = $request->get('potongan');
        $promo->tanggal_awal = $request->get('tanggal_awal');
        $promo->tanggal_akhir = $request->get('tanggal_akhir');
        $promo->save();
        return redirect()->route('produk.emka')->with('message', 'Promo Has Been Updated');
    }
    public function promoemkaedit($id){
        $promo = Promo::where('id',$id)->get()->first();
        return view('produk.editpromoemka', compact('promo'));
    }
    public function deletepromoemka($id){
        Promo::destroy($id);
        return redirect()->route('produk.emka')->with('message', 'Promo Has Been Updated');
    }

    public function emkaharga($id){
        $harga = Harga::where('id', $id)->get()->first();
        return view('produk.editharga', compact('harga'));
    }

    public function emkahargaupdate(Request $request){
        $id = $request->get('id');
        $harga = Harga::findOrFail($id);
        $harga->paket = $request->get('paket');
        $harga->harga = $request->get('harga');
        $harga->save();
        return redirect()->route('produk.emka')->with('message', 'Promo Has Been Updated');
    }
    public function hargaemkaapi(){
        return Harga::where('aplikasi','emka')->get();
    }
    public function hargaemkaid($id){
        return Harga::where('aplikasi','emka')
        ->where('id', $id)->get()->first();
    }
    public function promoemka($kode){
        $promo = Promo::where('aplikasi','emka')
        ->where('tanggal_awal','<=',date('Y-m-d'))
        ->where('tanggal_akhir','>=',date('Y-m-d'))
        ->where('kode',$kode)
        ->get()->first();
        if($promo){
            return $promo;
        }else{
            return "false";
        }
    }
    public function paketemka(){
        return view('paket.emka');
    }
    public function AddPaketEmka(Request $request){
        $paket = New PaketAplikasi;
        $paket->paket = $request->paket;
        $paket->aplikasi = 'emka';
        $paket->save();
        return redirect()->route('produk.emka')->with('message', 'Paket Has Been Saved');
    }
    public function addperiod($id){
        $paket = PaketAplikasi::where('id',$id)->get()->first();
        return view('paket.addperiod', compact('paket'));
    }
    public function addpaketperiod(Request $request){
        $period = new PaketPeriod;
        $period->idpaket_aplikasi = $request->idpaket_aplikasi;
        $period->nama_period = $request->nama_period;
        $period->period = $request->period;
        $period->harga = $request->harga;
        $period->save();
        return redirect()->route('produk.emka')->with('message', 'Period Has Been Saved');
    }   
    public function addvariable($id){
        $paket = PaketAplikasi::where('id',$id)->get()->first();
        return view('paket.addvariable', compact('paket'));
    }
    public function addpaketvariable(Request $request){
        $variable = new PaketVariable;
        $variable->idpaket_aplikasi = $request->idpaket_aplikasi;
        $variable->variable = $request->variable;
        $variable->save();
        return redirect()->route('produk.emka')->with('message', 'Period Has Been Saved');
    } 
}