
<?php

namespace App\Http\Controllers;

use App\Bayna;
use App\BookingAmount;
use App\BookingForm;
use App\Company;
use App\Expence;
use App\Income;
use App\installment;
use App\LandPurchase;
use App\purchaseInstallment;
use App\ReferenceWithdraw;
use App\Sale;
use Carbon\Carbon;
use Illuminate\Http\Request;

class CashBookController extends Controller
{
    public function report(Request $request)
    {

        $from = $request->get('from');
        $to = $request->get('to');


        if ($from || $to) {
            $from = date("Y-m-d", strtotime($request->from));
            $to = date("Y-m-d", strtotime($request->to));

            $sales = Sale::whereBetween('date', array($from, $to))->sum('paid');
            $total_book = BookingAmount::whereBetween('date', array($from, $to))->sum('amount');
            $land_installment = installment::whereBetween('date',  array($from, $to))->sum('amount');
            $income_t = Income::whereBetween('date', array($from, $to))->sum('amount');

            //expense
            $purchase = LandPurchase::whereBetween('date', array($from, $to))->sum('paid_amount');
            $ref_with = ReferenceWithdraw::whereBetween('date', array($from, $to))->sum('amount');
            $expense_t = Expence::whereBetween('date', array($from, $to))->sum('amount');

            $bayna_total = Bayna::whereBetween('date', array($from, $to))->sum('paid_amount');
            //$purchase_installment = purchaseInstallment::whereBetween('created_at', [$string1, $string2])->sum('amount');

            $book_com = ReferenceWithdraw::where('status_purpose', 2)
                ->whereBetween('date', array($from, $to))
                ->sum('amount');

            $ins_com = ReferenceWithdraw::where('status_purpose', 3)
                ->whereBetween('date', array($from, $to))
                ->sum('amount');
            $ek_com = ReferenceWithdraw::where('status_purpose', 1)
                ->whereBetween('date', array($from, $to))
                ->sum('amount');

            $total_income = $sales + $land_installment + $income_t + $total_book;

            $total_expense = $purchase + $ref_with + $expense_t + $bayna_total;


            $booking =  Sale::whereBetween('date', array($from, $to))
                ->orderBy('date', 'ASC')

                ->paginate(20);
            $book_1 = BookingAmount::orderBy('date', 'ASC')
                ->whereBetween('date', array($from, $to))
                ->paginate(20);
            $ins = installment::whereBetween('date', array($from, $to))
                ->orderBy('date', 'ASC')
                ->paginate(20);

            $expenses = Expence::whereBetween('date', array($from, $to))
                ->orderBy('date', 'ASC')
                ->get();

            $incomes = Income::whereBetween('date', array($from, $to))
                ->orderBy('date', 'ASC')
                ->get();
            $land = LandPurchase::whereBetween('date', array($from, $to))
                ->orderBy('date', 'ASC')
                ->get();
            $bayna = Bayna::whereBetween('date',  array($from, $to))
                ->orderBy('date', 'ASC')
                ->get();
            $withdraws = ReferenceWithdraw::whereBetween('date', array($from, $to))
                ->orderBy('date', 'ASC')
                ->get();
        } else {

            $booking =  Sale::orderBy('date', 'ASC')
                ->get();
            $book_1 = BookingAmount::orderBy('date', 'ASC')
                ->get();
            $ins = installment::orderBy('date', 'ASC')
                ->get();

            $expenses = Expence::orderBy('date', 'ASC')
                ->get();
            $incomes = Income::orderBy('date', 'ASC')
                ->get();
            $land = LandPurchase::orderBy('date', 'ASC')
                ->get();
            $bayna = Bayna::orderBy('date', 'ASC')
                ->get();
            $withdraws = ReferenceWithdraw::orderBy('date', 'ASC')
                ->get();

            $sales = Sale::sum('paid');
            $total_book = BookingAmount::sum('amount');
            $land_installment = installment::sum('amount');

            $purchase = LandPurchase::sum('paid_amount');
            $ref_with = ReferenceWithdraw::sum('amount');
            $book_com = ReferenceWithdraw::where('status_purpose', 2)
                ->sum('amount');
            $ins_com = ReferenceWithdraw::where('status_purpose', 3)
                ->sum('amount');
            $ek_com = ReferenceWithdraw::where('status_purpose', 1)
                ->sum('amount');
            $expense_t = Expence::sum('amount');
            $purchase_installment = purchaseInstallment::sum('amount');
            $income_t = Income::sum('amount');
            $bayna_total = Bayna::sum('paid_amount');

            $total_income = $sales + $land_installment + $income_t + $total_book;

            $total_expense = $purchase + $ref_with + $expense_t + $bayna_total;
        }
        $company = Company::latest()->first();

        return view('report.cashbook', compact(
            'company',
            'sales',
            'land_installment',
            'purchase',
            'purchase_installment',
            'bayna_total',
            'ref_with',
            'total_income',
            'total_expense',
            'booking',
            'ins',
            'expenses',
            'incomes',
            'bayna',
            'land',
            'withdraws',
            'from',
            'to',
            'income_t',
            'expense_t',
            'book_com',
            'ins_com',
            'ek_com',
            'total_book',
            'book_1'

        ));
    }

    // if ($request->date_range) {


    //     $x = 1;
    //     $delim = ' - ';
    //     $str = $request->date_range;
    //     $parts = explode($delim, $str);
    //     $string1 = implode($delim, array_slice($parts, 0, $x)) . $delim;
    //     $string2 = implode($delim, array_slice($parts, $x));

    //     $string2 = date("y-m-d", strtotime($string2));
    //     $string1 = date("y-m-d", strtotime($string1));

    //     $sales = Sale::whereBetween('date', [$string1, $string2])->sum('paid');
    //     $land_installment = installment::whereBetween('date', [$string1, $string2])->sum('amount');

    //     $purchase = LandPurchase::whereBetween('date', [$string1, $string2])->sum('paid_amount');
    //     $ref_with = ReferenceWithdraw::whereBetween('created_at', [$string1, $string2])->sum('amount');
    //     $expence = Expence::whereBetween('date', [$string1, $string2])->sum('amount');
    //     $income = Income::whereBetween('date', [$string1, $string2])->sum('amount');
    //     $bayna_total = Bayna::whereBetween('date', [$string1, $string2])->sum('paid_amount');
    //     //$purchase_installment = purchaseInstallment::whereBetween('created_at', [$string1, $string2])->sum('amount');

    //     $total_income = $sales + $land_installment + $income;

    //     $total_expense = $purchase + $ref_with + $expence + $bayna_total;


    //     $booking =  Sale::orderBy('id', 'DESC')
    //         ->whereBetween('date', [$string1, $string2])
    //         ->paginate(20);

    //     $ins = installment::whereBetween('date',  [$string1, $string2])
    //         ->orderBy('id', 'DESC')
    //         ->paginate(20);

    //     $expenses = Expence::whereBetween('date', [$string1, $string2])
    //         ->orderBy('id', 'DESC')
    //         ->get();

    //     $incomes = Income::whereBetween('date', [$string1, $string2])
    //         ->orderBy('id', 'DESC')
    //         ->get();
    //     $land = LandPurchase::whereBetween('date', [$string1, $string2])
    //         ->orderBy('id', 'DESC')
    //         ->get();
    //     $bayna = Bayna::whereBetween('date', [$string1, $string2])
    //         ->orderBy('id', 'DESC')
    //         ->get();
    //     $withdraws = ReferenceWithdraw::whereBetween('created_at', [$string1, $string2])
    //         ->orderBy('id', 'DESC')
    //         ->get();
    // }

    public function test()
    {

        return view('report.test');
    }
}