<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use App\Donors;
use DB;
use Carbon\Carbon;

class Donations extends Model
{
    
    protected $primaryKey = 'id';
    public $timestamps = false;

    protected function getDonations()
    {
        $results = $this->select(['donors.id','donors.first_name','donors.last_name','donations.currency','donations.donation_amount','donations.receipt_no'])
					->join('donors','donors.id','=','donations.donor_id')
					->orderBy('donations.id', 'desc')
					->get();
		return $results;
    }

   

    protected function getDetails()
    {
        $results = $this->select('*')
					->join('donors','donors.id','=','donations.donor_id')
                    ->orderBy('donations.id', 'desc')
                    
                    ->get();
					
		return $results;
    }

    protected function getTotalAmount()
    {
        $results = $this->select('*')
                    ->join('donors','donors.id','=','donations.donor_id')
                    ->sum('donation_amount');
         // dd($results);       
        return $results;
    }

    protected function getTotalDonation()
    {
        $query = "SELECT created_at AS '0',count(donation_amount) AS '1' FROM `donations` GROUP BY  MONTH(created_at)";
        
        
        $results = DB::select($query);
        $result = array_map(function ($results) {
            return (array)$results;
        }, $results);
        return $result;
    }

    protected function getTotalAmountDonation()
    {
        $query = "SELECT created_at AS '0',sum(donation_amount) AS '1' FROM `donations` GROUP BY  MONTH(created_at)";
        
        $results = DB::select($query);
        $result = array_map(function ($results) {
            return (array)$results;
        }, $results);
        return $result;
    }

     protected function getDonationDetails($id)
    {
       
        $results = $this->select(['donations.donor_id','donors.first_name',
            
            'donors.last_name',
            'donors.picture_url',
            'donors.title',
            'donors.mobile_no',
            'donors.donor_type',
            'donors.care_of',
            'donors.company',
            'donors.designation',
            'donations.id',
            'donations.receipt_no',
            'donations.donation_date',
            'donations.currency',
            'donations.tax',
            'donations.donation_amount',
            'donations.exchange',
            'donations.ecurrency',
            'donations.actual_amt',
            'donations.receipt_name',
            'donations.mode',
            'donations.cheque_num',
            'donations.receipt_status',
            'donations.rmd_status',
            'donations.finance_status',
            'donations.bank',
            'donations.ins_date',
            'donations.description',
            'donations.purpose',
            'donations.user_id',
            'project_list.pro_name',
            'category_list.cat_name',
            'allocation_list.allo_name',
            'users.name'
            
        ])
        ->leftjoin('donors','donors.id','=','donations.donor_id')
        ->leftjoin('project_list','project_list.pro_id','=','donations.project')
        ->leftjoin('category_list','category_list.cat_id','=','donations.category')
        ->leftjoin('allocation_list','allocation_list.allo_id','=','donations.allocation')
        ->leftjoin('users','users.id','=','donations.user_id')
        ->where('donations.id',$id)
        ->orderBy('donations.id', 'desc')
        ->get();
        
        
        if(!empty($results->toArray())){
            return $results[0];
        }
        // dd($results1);
        // dd(DB::getQueryLog()); //Last executed query
    }
}