<?php

namespace App\Http\Controllers\Master;

use App\Http\Controllers\Controller;
use App\Models\masterakun;
use App\Models\masterbarang;
use App\Models\masterbarangkategori;
use App\Models\mastercompany;
use App\Models\mastergolonganbarang;
use App\Models\mastermerkbarang;
use App\Models\masterpilihan;
use App\Models\mastersatuan;
use App\Models\mkey;
use App\Models\penerimaanbarang;
use App\Models\penerimaanbarangdetail;
use App\Models\tablelist;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;
use Yajra\DataTables\DataTables;

class ApiMasterController extends Controller
{
    //


    public function barangStock(Request $request) {

        $pil_accept = masterpilihan::where([
            ['group_pilihan','status_akseptasi'],
            ['pilihan','accepted']
        ])
        ->first('kd_pilihan');

        // $barang = masterbarang::where([
        //     ['m_barang.kd_barang',$request->kd_barang],
        //     ['m_barang.status_hitung_stock','T'],
        //     ['m_barang.status','!=',0]
        // ])->first();

        $receipt = penerimaanbarangdetail::with(['t_penerimaan_barang'])
        ->where([
            ['t_penerimaan_barang_detail.kd_barang',$request->kd_barang],
            ['t_penerimaan_barang.status','!=',0],
            ['t_penerimaan_barang.kd_pil_status_akseptasi',$pil_accept->kd_pilihan]
        ])
        ->sum('t_penerimaan_barang_detail.jumlah');

        $issued = penerimaanbarangdetail::with(['t_keluar_barang'])
        ->where([
            ['t_keluar_barang_detail.kd_barang',$request->kd_barang],
            ['t_keluar_barang.status','!=',0],
            ['t_keluar_barang.kd_pil_status_akseptasi',$pil_accept->kd_pilihan]
        ])
        ->sum('t_keluar_barang_detail.jumlah');

        $stk_brg = $receipt - $issued;

        return response()->json($receipt);


    }

    public function mastermerkbaranglist (Request $request) {

        $data = mastermerkbarang::where('status','!=',0)->get();

        return DataTables::of($data)->make(true);

    }

    public function mastersatuanlist (Request $request) {

        $data = mastersatuan::where('status','!=',0)->get();

        return DataTables::of($data)->make(true);

    }

    public function mastergolonganbaranglist (Request $request) {

        $data = mastergolonganbarang::where('status','!=',0)->get();

        return DataTables::of($data)->make(true);

    }

    public function masterbarangkategorilist (Request $request) {

        $data = masterbarangkategori::with(['akunbeli','jenisbarangkategori'])
            ->where('m_barang_kategori.status','!=',0)
            ->get()
            ->map(function ($alpha) {

            if ($alpha->status_stock_dan_harga == 0) {
                $alpha->status_stock_dan_harga_label = 'NON STOCK';
            }
            elseif ($alpha->status_stock_dan_harga == 1) {
                $alpha->status_stock_dan_harga_label = 'ONLY STOCK';
            }
            else {
                $alpha->status_stock_dan_harga_label = 'STOCK AND VALUE';
            }

            $alpha->kd_pil_jenis_barang_kategori = trim($alpha->kd_pil_jenis_barang_kategori);

                return $alpha;
            });

        return DataTables::of($data)->make(true);
    }

    public function masterpilihandropdown(Request $request) {

        $data = masterpilihan::where([
            ['group_pilihan',$request->group_pilihan],
            // ['status','!=',0]
        ])
        ->get();

        return response()->json($data);

        // return response()->json([
        //     [
        //         'kd_pilihan' => 1,
        //         'pilihan' => 'Aktif'
        //     ],
        //     [
        //         'kd_pilihan' => 2,
        //         'pilihan' => 'Non Aktif'
        //     ]
        // ]);

    }

    // public function masterakun(Request $request) {

    //     $data = masterakun::with(['masterakun3','masterakun3.masterakun2','masterakun3.masterakun2.masterakun1'])->where('status','!=',0)->get();

    //     return response()->json($data);


    // }

    public function masterakun(Request $request)
    {
        $perPage = 20;

        $query = masterakun::with(['masterakun3','masterakun3.masterakun2','masterakun3.masterakun2.masterakun1'])->where('status', '!=', 0);

        // 🔍 SEARCH
        if ($request->q) {
            $query->where(function ($q) use ($request) {
                $q->where('nama_akun', 'like', "%{$request->q}%")
                ->orWhere('no_akun', 'like', "%{$request->q}%");
            });
        }

        // 📦 PAGINATION
        $data = $query
            ->orderBy('no_akun')
            ->paginate($perPage);

        return response()->json([
            'items' => $data->items(),
            'next_page' => $data->nextPageUrl()
        ]);
    }

    public function masterakunfind (Request $request) {

        $data = masterakun::with([
            'masterakun3',
            'masterakun3.masterakun2',
            'masterakun3.masterakun2.masterakun1'
        ])
        ->where('kd_akun', $request->kd_akun)
        ->first();

        return response()->json($data);


    }

    public function

    // return response()->json()

}