芝麻web文件管理V1.00

编辑当前文件:/home/rejoandoctor/test.joruridoctor.com/app/Http/Controllers/back/ReportController.php

<?php

namespace App\Http\Controllers\back;

use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\Hash;
use Illuminate\Http\Request;
use Illuminate\Validation\Rules;
use Illuminate\Database\Eloquent\Builder;
use App\Models\back\PrimaryModel;  
use App\Models\back\CustomerModel;
use App\Models\back\AirlineModel;
use App\Models\back\AirportModel;
use App\Models\back\TicketModel;
use App\Models\back\PassengerModel;
use App\Models\back\StockModel;
use App\Models\back\AgentModel;
use App\Models\back\AgentAccountModel;
use App\Models\back\TempTicketModel;
use App\Models\back\BankModel;
use App\Models\back\BankAccountModel;
use App\Models\back\DueModel;
use App\Models\back\DueBalanceModel;
use App\Models\back\SubAgentModel;
use App\Models\User;
use Auth;
use DB;
use Carbon\Carbon;
use Session;

class ReportController extends Controller
{

function __construct()
    {
        $this->middleware('auth');
    }

function dailyReport(Request $request)
    {

if(isset($request->start) && isset($request->end)){
                
                $start = $request->start;
                $end = $request->end;

}else{

$start = Carbon::now()->firstOfMonth();
                $end = Carbon::now();
            }

$sale_amount = TicketModel::where('customer_id', Auth::user()->customer_id)
    	->whereBetween('sale_date', array($start, $end))
    	->where('status', 'sale')->sum('sale_amount');

$buy_amount = TicketModel::where('customer_id', Auth::user()->customer_id)
        ->whereBetween('sale_date', array($start, $end))
        ->where('status', 'sale')->sum('buy_amount');
        $profit = $sale_amount - $buy_amount;

$ticket_amount = DueModel::where('customer_id', Auth::user()->customer_id)
        ->whereBetween('ticket_date', array($start, $end))
        ->where('type', 'ticket_purpose')->sum('ticket_price');

$paid_amount = DueModel::where('customer_id', Auth::user()->customer_id)
        ->whereBetween('ticket_date', array($start, $end))
        ->where('type', 'ticket_purpose')->sum('paid_amount');
        $due_amount = $ticket_amount - $paid_amount;

$bank_deposit = BankAccountModel::where('customer_id', Auth::user()->customer_id)
        ->whereBetween('deposit_date', array($start, $end))
        ->where('type', 'deposit')->sum('deposit_amount');

$bank_withdraw = BankAccountModel::where('customer_id', Auth::user()->customer_id)
        ->whereBetween('withdraw_date', array($start, $end))
        ->where('type', 'withdraw')->sum('withdraw_amount');

$ticket_payment = BankAccountModel::where('customer_id', Auth::user()->customer_id)
        ->whereBetween('ticket_payment_date', array($start, $end))
        ->where('type', 'ticket_payment')->sum('ticket_amount');

$refund_payment = BankAccountModel::where('customer_id', Auth::user()->customer_id)
        ->whereBetween('refund_date', array($start, $end))
        ->where('type', 'refund_payment')->sum('refund_amount');

$expense = BankAccountModel::where('customer_id', Auth::user()->customer_id)
        ->whereBetween('expense_date', array($start, $end))
        ->where('type', 'expense')->sum('expense_amount');

$due_return = BankAccountModel::where('customer_id', Auth::user()->customer_id)
        ->whereBetween('due_return_date', array($start, $end))
        ->where('type', 'due_return')->sum('due_return_amount');

$loan_take_credit = BankAccountModel::where('customer_id', Auth::user()->customer_id)
        ->whereBetween('loan_date', array($start, $end))
        ->where('type', 'loan_take_credit')->sum('loan_amount');

$loan_take_debit = BankAccountModel::where('customer_id', Auth::user()->customer_id)
        ->whereBetween('loan_date', array($start, $end))
        ->where('type', 'loan_take_debit')->sum('loan_amount');

$loan_give_debit = BankAccountModel::where('customer_id', Auth::user()->customer_id)
        ->whereBetween('loan_date', array($start, $end))
        ->where('type', 'loan_give_debit')->sum('loan_amount');

$loan_give_credit = BankAccountModel::where('customer_id', Auth::user()->customer_id)
        ->whereBetween('loan_date', array($start, $end))
        ->where('type', 'loan_give_credit')->sum('loan_amount');

$agent_deposit = AgentAccountModel::where('customer_id', Auth::user()->customer_id)
        ->whereBetween('deposit_date', array($start, $end))
        ->where('type', 'deposit')->sum('deposit_amount');
    	
    	return view('back.report.daily_report', compact('sale_amount', 'profit','due_amount', 'bank_deposit', 'bank_withdraw', 'ticket_payment', 'refund_payment', 'expense', 'due_return', 'loan_take_credit', 'loan_take_debit', 'loan_give_debit', 'loan_give_credit', 'agent_deposit', 'start', 'end'));

}
}