webshell

Ghost Exploiter Team Official

Directory >> /home/softsuitetech/public_html/DEMO/FCIConstructions/app/Models/

File / Folder	Size	Action
.	-
Accounts	--	ren
Admin	--	ren
Area	--	ren
Blocks	--	ren
Bookings	--	ren
Customers	--	ren
Dealers	--	ren
Installments	--	ren
Marketers	--	ren
Partners	--	ren
Plots	--	ren
Projects	--	ren
Receipts	--	ren
Sales	--	ren
Sectors	--	ren
Tehsil	--	ren
Zila	--	ren
AssignPartner.php	0.266KB	edt ren
File.php	0.438KB	edt ren
Folder.php	0.479KB	edt ren
GoodReceived.php	2.081KB	edt ren
InstallmentHead.php	1.532KB	edt ren
Ledger.php	22.009KB	edt ren
Marla.php	1.227KB	edt ren
ProductUnit.php	0.891KB	edt ren
PurchaseDetail.php	0.541KB	edt ren
User.php	2.042KB	edt ren

<?php

namespace App\Models;

use App\Models\Accounts\Account;
use App\Models\Admin\Product;
use App\Models\Admin\Purchase;
use App\Models\Admin\Vendor;
use App\Models\Customers\Customer;
use App\Models\Dealers\Dealer;
use App\Models\Sales\Sale;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\Auth;

class Ledger extends Model
{
    use HasFactory;
    protected $fillable = [
        'account_id',
        'sale_id',
        'day',
        'debit',
        'credit',
        'remarks',
        'type',
        'status',
        'user_id',
        'bank_name',
        'cheque_no',
        'account_title',
        'receipt_id',
        'voucher_id',
        'purchase_id',
        'mutation_id',
        'cheque_no',
        'transaction_entry',
    ];
    public function  Account_Name()
    {
        return $this->hasOne(Account::class,'id','account_id');
    }
    public function  Purchase()
    {
        return $this->hasOne(Purchase::class,'id','purchase_id');
    }
    public function  Sale()
    {
        return $this->hasOne(Sale::class,'id','sale_id');
    }
    public static function saveAdvancedEntry($request,$sale_id,$voucher_id,$customer_id)
    {
        $customer_account = Customer::where('project_id',Auth::user()->temp_project_id)->where('id',$customer_id)->first();
        $cash_account     = Account::where('project_id',Auth::user()->temp_project_id)->where('type2','=','cashinhand')->first();
        if ($request->mode_of_payment == "Cheque"){
            $debit_account = $request->bank_account_id;
        }
        else{
            $debit_account = $cash_account->id;
        }
        parent::create([
            'account_id'    => $debit_account,
            'sale_id'       => $sale_id,
            'mutation_id'   => $request->mutation_id,
            'day'           => $request->day,
            'debit'         => $request->received,
            'credit'        => 0,
            'remarks'       => "Advance Paid By $customer_account->name",
            'type'          => "Sale",
            'status'        => 0,
            'user_id'       => Auth::user()->id,
            'voucher_id'    => $voucher_id,
            'transaction_entry'    => 1,
        ]);
        parent::create([
            'account_id'    => $customer_account->account_id,
            'sale_id'       => $sale_id,
            'mutation_id'   => $request->mutation_id,
            'day'           => $request->day,
            'debit'         => 0,
            'credit'        => $request->received,
            'remarks'       => "Advance Paid By $customer_account->name",
            'type'          => "Sale",
            'status'        => 0,
            'user_id'       => Auth::user()->id,
            'voucher_id'    => $voucher_id,
            'transaction_entry'    => 1,
        ]);

//        }
    }
    public static function saveInstallmentsEntry($installments,$sale)
    {
        $customer_account = Customer::where('project_id',Auth::user()->temp_project_id)->where('id',$sale->customer_id)->first();
        $cash_account     = Account::where('project_id',Auth::user()->temp_project_id)->where('type2','=','cashinhand')->first();
        if ($sale->mode_of_payment == "Cheque"){
            $debit_account = $sale->bank_account_id;
        } else {
            $debit_account = $cash_account->id;
        }
        parent::create([
            'account_id'    => $debit_account,
            'sale_id'       => $sale->id,
            'day'           => date('Y-m-d'),
            'debit'         => $installments->installment_amount,
            'credit'        => 0,
            'remarks'       => "Installment Paid By $customer_account->name",
            'type'          => "receipt",
            'status'        => 1,
            'user_id'       => Auth::user()->id,
//            'voucher_id'    => $voucher_id,
        ]);
        parent::create([
            'account_id'    => $customer_account->account_id,
            'sale_id'       => $sale->id,
            'day'           => date('Y-m-d'),
            'debit'         => 0,
            'credit'        => $installments->installment_amount,
            'remarks'       => "Installment Paid By $customer_account->name",
            'type'          => "receipt",
            'status'        => 1,
            'user_id'       => Auth::user()->id,
//            'voucher_id'    => $voucher_id,
        ]);

//        }
    }
    public static function saveBookingEntry($request,$sale_id,$voucher_id,$customer_id)
    {
        ///////////// agreed price debit entry //////////////////////////////////
        $customer_account = Customer::where('id',$customer_id)->first();
        $username = Auth::user()->name;
        parent::create([
            'account_id' => $customer_account->account_id,
            'sale_id'    => $sale_id,
            'day'        => $request->day,
            'debit'      => $request->total_amount,
            'credit'     => 0,
            'remarks'    => "$customer_account->name s/o $customer_account->father_name Unit sold by $username",
            'type'       => "Sale",
            'status'     => 0,
            'user_id'    => Auth::user()->id,
            'voucher_id' => $voucher_id,
        ]);
        //////////// agreed price credit entry //////////////////////////////////
        $sales_account = Account::where('project_id',Auth::user()->temp_project_id)->where('type2',"income_from_sale_of_land")->first();
//        if($request->on_account_of>0)
//        {
        parent::create([
            'account_id' => $sales_account->id,
            'sale_id'    => $sale_id,
            'day'        => $request->day,
            'debit'      => 0,
            'credit'     => $request->total_amount,
            'remarks'    => "$customer_account->name s/o $customer_account->father_name Unit sold by $username",
            'type'       => "Sale",
            'status'     => 0,
            'user_id'    => Auth::user()->id,
            'voucher_id' => $voucher_id,
        ]);
//        }
    }
    public static function saveDealerCommission($request,$sale_id,$voucher_id)
    {
        $project_id         = Project();
        $user_id            = User();
        $dealer_account     = Dealer::where('id',$request->dealer_id)
                                        ->first();

$commission_account = Account::where('project_id',$project_id)
                                        ->where('type2','commision_on_sale')
                                        ->first();

$cash_account       = Account::where('project_id',$project_id)
                                        ->where('type2','=','cashinhand')
                                        ->first();

parent::create([
            'account_id' => $commission_account->id,
            'sale_id'    => $sale_id,
            'day'        => $request->day,
            'debit'      => $request->dealer_commision_value,
            'credit'     => 0,
            'remarks'    => "Commission Payable to Dealer $dealer_account->name",
            'type'       => "Sale",
            'status'     => 0,
            'user_id'    => Auth::user()->id,
            'voucher_id' => $voucher_id,
        ]);
        parent::create([
            'account_id' => $dealer_account->account_id,
            'sale_id'    => $sale_id,
            'day'        => $request->day,
            'debit'      => 0,
            'credit'     => $request->dealer_commision_value,
            'remarks'    => "Commission Payable to Dealer $dealer_account->name",
            'type'       => "Sale",
            'status'     => 0,
            'user_id'    => Auth::user()->id,
            'voucher_id' => $voucher_id,
        ]);

/////////// if amounmt is paid to dealer
        if($request->dealer_commision_due>0)
        {
            parent::create([
                'account_id' => $dealer_account->account_id,
                'sale_id'    => $sale_id,
                'day'        => $request->day,
                'debit'      => $request->dealer_commision_due,
                'credit'     => 0,
                'remarks'    => "Commission Paid to Dealer $dealer_account->name",
                'type'       => "Sale",
                'status'     => 0,
                'user_id'    => Auth::user()->id,
                'voucher_id' => $voucher_id,
                'transaction_entry'    => 1,
            ]);
            parent::create([
                'account_id' => $cash_account->id,
                'sale_id'    => $sale_id,
                'day'        => $request->day,
                'debit'      => 0,
                'credit'     => $request->dealer_commision_due,
                'remarks'    => "Commission Paid to Dealer $dealer_account->name",
                'type'       => "Sale",
                'status'     => 0,
                'user_id'    => Auth::user()->id,
                'voucher_id' => $voucher_id,
                'transaction_entry'    => 1,
            ]);
        }
        /////////// if Premium amount is paid to dealer
        if($request->premium_amount > 0)  {
            $premium_amount = $request->premium_amount/2;
            parent::create([
                'account_id' => $dealer_account->account_id,
                'sale_id'    => $sale_id,
                'day'        => $request->day,
                'debit'      => $premium_amount,
                'credit'     => 0,
                'remarks'    => "Premium Amount Paid to Dealer $dealer_account->name",
                'type'       => "Sale",
                'status'     => 0,
                'user_id'    => Auth::user()->id,
                'voucher_id' => $voucher_id,
                'transaction_entry'    => 1,
            ]);
            parent::create([
                'account_id' => $cash_account->id,
                'sale_id'    => $sale_id,
                'day'        => $request->day,
                'debit'      => 0,
                'credit'     => $premium_amount,
                'remarks'    => "Premium Amount commission $dealer_account->name",
                'type'       => "Sale",
                'status'     => 0,
                'user_id'    => Auth::user()->id,
                'voucher_id' => $voucher_id,
                'transaction_entry'    => 1,
            ]);
        }
    }

public static function ReceiptEntry($request,$receiptId)
    {
        $customer_account = Customer::where('owner_id',$request->owner_id)->where('id',$request->customer_id)->first();
        $cash_account     = Account::where('owner_id',$request->owner_id)->where('type2',"cashinhand")->first();
        parent::create([
            'account_id' => $cash_account->id,
            'sale_id'    => $request->sale_id,
            'day'        => $request->day,
            'debit'      => $request->amount_paid,
            'credit'     => 0,
            'remarks'    => "Installment Paid By $customer_account->name",
            'type'       => "Receipt",
            'status'     => 0,
            'user_id'    => Auth::user()->id,
            'receipt_id' => $receiptId,
        ]);
        parent::create([
            'account_id' => $customer_account->account_id,
            'sale_id'    => $request->sale_id,
            'day'        => $request->day,
            'debit'      => 0,
            'credit'     => $request->amount_paid,
            'remarks'    => "Installment Paid By $customer_account->name",
            'type'       => "Receipt",
            'status'     => 0,
            'user_id'    => Auth::user()->id,
            'receipt_id' => $receiptId,
        ]);
    }

public static function savePurchaseEntry($request,$purchase_id,$voucher_id)
    {
        $project_id         = Project();
        $user_id            = User();
        $cash_account       = Account::where('project_id',$project_id)->where('type2','=','cashinhand')->first();
        $purchase_of_raw_material   = Account::where('project_id',$project_id)->where('type2',"purchase_of_land")->first();
        $vendor_account     = Vendor::where('id',$request->vendor_id)->first();

// debit the accounts of products
        foreach ($request->product_id as $key => $product_id){
            $product_account = Product::find($product_id);
            parent::create([
                'purchase_id' => $purchase_id,
                'voucher_id'  => $voucher_id,
                'day'         => $request->day,
                'account_id'  => $product_account->account_id,
                'debit'       => $request->total_cost[$key],
                'credit'      => 0,
                'remarks'     => "Purchase Amount of Raw Material",
                'type'        => "Purchase",
                'status'      => 0,
                'user_id'     => $user_id,
            ]);
        }

// credit the vendor  account
        parent::create([
            'purchase_id' => $purchase_id,
            'voucher_id'  => $voucher_id,
            'mutation_id' => $request->mutation_id,
            'day'         => $request->day,
            'account_id'  => $vendor_account->account_id,
            'debit'       => 0,
            'credit'      => $request->total_amount,
            'remarks'     => "Payable to Vendor",
            'type'        => "Purchase",
            'status'      => 0,
            'user_id'     => $user_id,
        ]);

// for the amount paid by leghari estates
        // debit the vendor account from amount paid by Warble Project
        if($request->amount_paid > 0){

// debit the vandor account
            parent::create([
                'purchase_id' => $purchase_id,
                'voucher_id'  => $voucher_id,
                'day'         => $request->day,
                'account_id'  => $vendor_account->account_id,
                'debit'       => $request->tax_amount,
                'credit'      => 0,
                'remarks'     => "WithHolding Tax Debit Transaction",
                'type'        => "Purchase",
                'status'      => 0,
                'user_id'     => $user_id,
            ]);

$with_holding_tax_amount_amount   = Account::where('project_id',$project_id)
                                                        ->where('type2',"with_holding_income_tax")
                                                        ->first();
            // credit the WithHolding Tax
            parent::create([
                'purchase_id' => $purchase_id,
                'voucher_id'  => $voucher_id,
                'mutation_id' => $request->mutation_id,
                'day'         => $request->day,
                'account_id'  => $with_holding_tax_amount_amount->id,
                'debit'       => 0,
                'credit'      => $request->tax_amount,
                'remarks'     => "With Holding Tax Amount",
                'type'        => "Purchase",
                'status'      => 0,
                'user_id'     => $user_id,
            ]);

parent::create([
                'purchase_id' => $purchase_id,
                'voucher_id'  => $voucher_id,
                'mutation_id' => $request->mutation_id,
                'day'         => $request->day,
                'account_id'  => $vendor_account->account_id,
                'debit'       => $request->amount_paid,
                'credit'      => 0,
                'remarks'     => "Pay to Vendor",
                'type'        => "Purchase",
                'status'      => 0,
                'user_id'     => $user_id,
                'transaction_entry'    => 1,
            ]);
            // credit the cash & bank account which paid by leghai estates
            if ($request->mode_of_payment == "Cash In Hand"){
                $credit_account = $cash_account->id;
            }
            else{
                $credit_account = $request->bank_account;
            }

parent::create([
                'purchase_id' => $purchase_id,
                'voucher_id'  => $voucher_id,
                'mutation_id' => $request->mutation_id,
                'day'         => $request->day,
                'account_id'  => $credit_account,
                'debit'       => 0,
                'credit'      => $request->amount_paid,
                'remarks'     => "Pay to Vendor",
                'type'        => "Purchase",
                'status'      => 0,
                'user_id'     => $user_id,
                'transaction_entry'    => 1,
            ]);
        }
    }

public static function saveInheritedEntry($request,$purchase_id,$voucher_id){
        $purchase_of_land = Account::where('owner_id',$request->owner_id)->where('type2',"purchase_of_land")->first();
        $capital_account  = Account::where('owner_id',$request->owner_id)->where('type2',"capital")->first();

// debit the purchase of land account
        parent::create([
            'purchase_id' => $purchase_id,
            'voucher_id'  => $voucher_id,
            'mutation_id' => $request->mutation_id,
            'day'         => $request->day,
            'account_id'  => $purchase_of_land->id,
            'debit'       => $request->total_amount,
            'credit'      => 0,
            'remarks'     => "Inherited Property",
            'type'        => "Purchase",
            'status'      => 0,
            'user_id'     => Auth::user()->id,
        ]);

// credit the capital account of the owner
        parent::create([
            'purchase_id' => $purchase_id,
            'voucher_id'  => $voucher_id,
            'mutation_id' => $request->mutation_id,
            'day'         => $request->day,
            'account_id'  => $capital_account->id,
            'debit'       => 0,
            'credit'      => $request->total_amount,
            'remarks'     => "Inherited Property",
            'type'        => "Purchase",
            'status'      => 0,
            'user_id'     => Auth::user()->id,
        ]);
    }

public static function saveDiscountEntry($request,$sale_id,$voucher_id,$customer_id)
    {
        ///////////// agreed price debit entry //////////////////////////////////
        $customer_account = Customer::where('project_id',Auth::user()->temp_project_id)->where('id',$customer_id)->first();
        $discount         = Account::where('project_id',Auth::user()->temp_project_id)->where('type2',"trade_discount")->first();
        $username = Auth::user()->name;
        parent::create([
            'account_id' => $discount->id,
            'sale_id'    => $sale_id,
            'day'        => $request->day,
            'debit'      => $request->discount,
            'credit'     => 0,
            'remarks'    => "Give Discount to Customer $customer_account->name s/o $customer_account->father_name Area sold by $username",
            'type'       => "Sale",
            'status'     => 0,
            'user_id'    => Auth::user()->id,
            'voucher_id' => $voucher_id,
        ]);
        //////////// agreed price credit entry //////////////////////////////////
        $sales_account = Account::where('project_id',Auth::user()->temp_project_id)->where('type2',"income_from_sale_of_land")->first();
//        if($request->on_account_of>0)
//        {
        parent::create([
            'account_id' => $customer_account->account_id,
            'sale_id'    => $sale_id,
            'day'        => $request->day,
            'debit'      => 0,
            'credit'     => $request->discount,
            'remarks'    => "Give Discount to Customer $customer_account->name s/o $customer_account->father_name Area sold by $username",
            'type'       => "Sale",
            'status'     => 0,
            'user_id'    => Auth::user()->id,
            'voucher_id' => $voucher_id,
        ]);
//        }
    }

public static function saveSalesTaxEntry($request,$sale_id,$voucher_id)
    {
        ///////////// accounts //////////////////////////////////
        $sales_tax_payable_account   = Account::where('project_id',Auth::user()->temp_project_id)->where('type2',"sales_tax_payable_account")->first();
        $sale_tax_expense_account   = Account::where('project_id',Auth::user()->temp_project_id)->where('type2',"sale_tax_expense_account")->first();
        //////////// Sales Tax Expense Account //////////////////////////////////
        parent::create([
            'account_id' => $sale_tax_expense_account->id,
            'sale_id'    => $sale_id,
            'day'        => $request->day,
            'debit'      => $request->tax_amount,
            'credit'     => 0,
            'remarks'    => "Sales Tax Expense Account",
            'type'       => "Sale",
            'status'     => 0,
            'user_id'    => Auth::user()->id,
            'voucher_id' => $voucher_id,
        ]);
        //////////// Sales Tax Payable Account //////////////////////////////////
        parent::create([
            'account_id' => $sales_tax_payable_account->id,
            'sale_id'    => $sale_id,
            'day'        => $request->day,
            'debit'      => 0,
            'credit'     => $request->tax_amount,
            'remarks'    => "Sales Tax Payable Account",
            'type'       => "Sale",
            'status'     => 0,
            'user_id'    => Auth::user()->id,
            'voucher_id' => $voucher_id,
        ]);
    }
    public static  function saveJournalVoucherEntry($request,$voucher_id)
    {
//dd($request->is_posted);
        foreach ($request->account_id as $key => $account_id)
        {
            $status = 0;
            if($request->is_posted==1)
            {
                $status = 1;
            }

parent::create([
                'account_id'      => $account_id,
                'voucher_id'      => $voucher_id,
                'day'             => date('Y-m-d'),
                'debit'           => $request->debit[$key],
                'credit'          => $request->credit[$key],
                'remarks'         => $request->description[$key],
                'type'            => "JV",
                'status'          => 0,
                'user_id'         => Auth::user()->id,
                'cheque_no'       => $request->cheque_no[$key],
                'transaction_entry'    => 1,
            ]);
        }
        return [
            'message' => "Journal Voucher Saved Successfully!"
        ];
    }
}

<=Back