public function getDelete($id)
{
$accountNames = NameOfAccount::find($id);
$accountNames->delete();
Session::flash('message', 'Account Name has been Successfully Deleted.');
return Redirect::to('accountnames/index');
}
public function getDelete($id)
{
$transfer = BalanceTransfer::find($id);
$accountsFrom = NameOfAccount::find($transfer->from_account_name_id);
$accountsFrom->opening_balance = $accountsFrom->opening_balance + $transfer->amount;
$accountsTo = NameOfAccount::find($transfer->to_account_name_id);
$accountsTo->opening_balance = $accountsTo->opening_balance - $transfer->amount;
$accountsTo->save();
$accountsFrom->save();
$transfer->delete();
Session::flash('message', 'Balance Transfer has been Successfully Deleted.');
return Redirect::to('balancetransfers/index');
}
public function getComplete3($id)
{
$register2 = Transaction::find($id);
$register2->cheque_status = 1;
if ($register2->payment_method == "Check") {
if ($register2->cheque_date == '') {
$register2->cheque_date = date("m/d/Y", time());
}
$accountPayment = NameOfAccount::find($register2->account_name_id);
$accountPayment->opening_balance = $accountPayment->opening_balance - $register2->amount;
$accountPayment->save();
}
$register2->save();
return Redirect::to('dashboard');
}
public function getAccountbalance($account_id)
{
$accountBalance = NameOfAccount::find($account_id);
echo "<p3 style='color: blue;font-size: 150%'>Your Current Balance {$accountBalance->opening_balance}</p3>";
}
@extends('baseLayout')
@section('styles')
<link rel="stylesheet" type="text/css" href="{{ URL::asset('assets/plugins/select2/select2_metro.css') }}" />
<link rel="stylesheet" type="text/css" href="{{ URL::asset('assets/plugins/bootstrap-datepicker/css/datepicker.css') }}" />
@stop
@section('content')
<div class="row">
<div class="col-md-12">
<?php
$account = \App\NameOfAccount::find($account_id);
$accountCat = \App\AccountCategory::find($account->account_category_id);
?>
<center>
<h3 class="page-title">
Accounts Report for <span style="color: black"> {{$account->name}} ({{$accountCat->name}})</span>
</h3>
</center>
</div>
</div>
<div class="row">
<div class="col-md-12">
<div class="portlet box light-grey">
<div class="portlet-title">
<?php
$date01 = explode('/', $date1);
$month1 = $date01[0];
$day1 = $date01[1];
$year1 = $date01[2];
$date001 = $day1 . '/' . $month1 . '/' . $year1;
public function postSaveReceiveAll()
{
$transactionId = 0;
$ruless = array('party_id' => 'required', 'branch_id' => 'required', 'account_category_id' => 'required', 'account_name_id' => 'required', 'payment_method' => 'required', 'amount' => 'required');
$validate = Validator::make(Input::all(), $ruless);
if ($validate->fails()) {
var_dump($validate);
die;
return Redirect::to('sales/index/')->withErrors($validate);
} else {
//$this->setReceiveSalePaymentAll();
//return Redirect::to('sales/index');
//$salesreturn = new SalesReturn();
//$this->setSalesReturnData($salesreturn);
//automatically reduce sales payment starts
$return_amount = Input::get('amount');
$remaining_amount = $return_amount;
//var_dump($remaining_amount);
$partyId = Input::get('party_id');
if ($remaining_amount > 0) {
$invoiceId = PurchaseInvoice::where('party_id', '=', $partyId)->get();
foreach ($invoiceId as $invid) {
$detailsPrice = 0;
$paid = 0;
$saleDetails = PurchaseInvoiceDetail::where('detail_invoice_id', '=', $invid->invoice_id)->get();
$transactions = Transaction::where('invoice_id', '=', $invid->invoice_id)->where('payment_method', '=', 'Check')->where('type', '=', 'Payment')->where('cheque_status', '=', 1)->get();
foreach ($saleDetails as $saleDetail) {
$detailsPrice = $detailsPrice + $saleDetail->price * $saleDetail->quantity;
}
foreach ($transactions as $transaction) {
$paid = $paid + $transaction->amount;
}
$transactions2 = Transaction::where('invoice_id', '=', $invid->invoice_id)->where('type', '=', 'Payment')->where('payment_method', '!=', 'Check')->get();
foreach ($transactions2 as $transaction) {
$paid = $paid + $transaction->amount;
}
$difference = $detailsPrice - $paid;
//echo $difference; die();
if ($difference > 0) {
//echo 'greater than 0 difference';
if ($remaining_amount <= $difference) {
if ($remaining_amount > 0) {
$sale = PurchaseInvoice::find($invid->id);
if ($remaining_amount < $difference) {
$sale->status = "Partial";
} elseif ($remaining_amount == $difference) {
$sale->status = "Completed";
}
$transaction = new Transaction();
$transaction->invoice_id = $invid->invoice_id;
$transaction->amount = $remaining_amount;
$transaction->type = 'Payment';
$transaction->payment_method = Input::get('payment_method');
$transaction->account_category_id = Input::get('account_category_id');
$transaction->remarks = Input::get('remarks');
$transaction->account_name_id = Input::get('account_name_id');
$transaction->user_id = Session::get('user_id');
$transaction->cheque_no = Input::get('cheque_no');
$branch = PurchaseInvoiceDetail::where('detail_invoice_id', '=', $invid->invoice_id)->first();
$transaction->branch_id = $branch->branch_id;
$transaction->cheque_date = Input::get('cheque_date');
$transaction->cheque_bank = Input::get('cheque_bank');
if ($transaction->payment_method != "Check") {
$accountPayment = NameOfAccount::find(Input::get('account_name_id'));
$accountPayment->opening_balance = $accountPayment->opening_balance - $remaining_amount;
$accountPayment->save();
}
$transaction->save();
$transactionId = $transaction->id;
$remaining_amount = 0;
}
} elseif ($remaining_amount > $difference) {
if ($remaining_amount > 0) {
$sale = PurchaseInvoice::find($invid->id);
$sale->status = "Completed";
$toBePaid = $remaining_amount - $difference;
$transaction = new Transaction();
$transaction->invoice_id = $invid->invoice_id;
$transaction->amount = $difference;
$transaction->type = 'Payment';
$transaction->payment_method = Input::get('payment_method');
$transaction->account_category_id = Input::get('account_category_id');
$transaction->remarks = Input::get('remarks');
$transaction->account_name_id = Input::get('account_name_id');
$transaction->user_id = Session::get('user_id');
$transaction->cheque_no = Input::get('cheque_no');
$branch = PurchaseInvoiceDetail::where('detail_invoice_id', '=', $invid->invoice_id)->first();
$transaction->branch_id = $branch->branch_id;
$transaction->cheque_date = Input::get('cheque_date');
$transaction->cheque_bank = Input::get('cheque_bank');
if ($transaction->payment_method != "Check") {
$accountPayment = NameOfAccount::find(Input::get('account_name_id'));
$accountPayment->opening_balance = $accountPayment->opening_balance - $difference;
$accountPayment->save();
}
$transaction->save();
$transactionId = $transaction->id;
$remaining_amount = $toBePaid;
}
}
$sale->save();
}
}
}
/*if($remaining_amount>0)
{
echo "How come its possible! Consult with DEVELOPERS!!!";
}*/
//automatically reduce sales payment ends
return Redirect::to('purchases/voucher/' . $transactionId);
}
}
<th>Invoice No</th>
<th>Account Name</th>
<th>Payment Method</th>
<th>Remarks</th>
<th style="text-align: right;">Amount</th>
</tr>
</thead>
<tbody>
<?php
$totalSale = 0;
?>
@foreach($results as $result )
<?php
$accounts = \App\NameOfAccount::find($result->account_name_id);
$accountCategory = \App\AccountCategory::find($result->account_category_id);
$party = \App\Party::find($result->party);
?>
<tr class="odd gradeX">
<td>{{\App\Transaction::convertDate($result->date)}}</td>
<td>{{$party->name}}</td>
<td><a target="_blank" href="{{URL::to('sales?invoice_id='.$result->invoice)}}">{{$result->invoice}}</a></td>
<td>{{$accounts->name }}{{' ( '.$accountCategory->name.' )'}}</td>
<td>{{$result->payment_method}}
@if($result->cheque_no)
{{' ( '.$result->cheque_no.' )'}}
@endif
</td>
<td>{{$result->remarks}}</td>
<?php
$account = \App\NameOfAccount::find($transaction->account_name_id);
?>
@extends('baseLayout')
@section('styles')
<link rel="stylesheet" type="text/css" href="{{ URL::asset('assets/plugins/select2/select2_metro.css') }}"/>
@stop
@section('content')
<div class="row">
<div class="col-xs-2 invoice-block" style="margin-left: 880px;">
<a class="btn btn-sm blue hidden-print" onclick="javascript:window.print();">Print <i class="fa fa-print"></i></a>
</div>
</div>
<div class="invoice">
<div class="row invoice-logo">
<div class="col-xs-12 invoice-logo-space">
<?php
$sale22 = \App\SAleDetail::where('invoice_id', '=', $transaction->invoice_id)->first();
?>
@if($sale22->branch_id == 1)
<img src="../../assets/img/pad/cemon-vc.jpg" style="width: 100%;" alt="" />
@elseif($sale22->branch_id == 2)
<img src="../../assets/img/pad/fst-vc.jpg" style="width: 100%;" alt="" />
@elseif($sale22->branch_id == 3)
<img src="../../assets/img/pad/cemon-vc.jpg" style="width: 100%;" alt="" />
@elseif($sale22->branch_id == 4)
<img src="../../assets/img/pad/cemon-vc.jpg" style="width: 100%;" alt="" />
@elseif($sale22->branch_id == 5)
$count = 0;
$count2 = 0;
?>
@foreach($accountBalanceTransfers as $result )
<?php
$reports = new \App\Report();
$results2 = $reports->getBalanceTransferForFromAccount($result->fromAccount);
$fromAccount = \App\NameOfAccount::find($result->fromAccount);
?>
@foreach($results2 as $result2 )
<?php
$reports = new \App\Report();
$results3 = $reports->getBalanceTransferForToAccount($result->fromAccount, $result2->toAccount);
$remainingAmount = $result2->fromAmount - $results3[0]->toAmount;
$toAccount = \App\NameOfAccount::find($result2->toAccount);
?>
@if($remainingAmount > 0)
<?php
for ($i = 0; $i < $count; $i++) {
$from = $values[$i]["from"];
$to = $values[$i]["to"];
//var_dump($from." ".$to);
if ($from == $fromAccount->name && $to == $toAccount->name) {
$count2 = 1;
}
}
?>
@if($count2==0)
<tr>
<td>{{$slNo}}</td>
public function getAccounts()
{
$accounts = NameOfAccount::all();
return $accounts;
}
public function postAccountsresult()
{
$date1 = Input::get('from_date');
$date2 = Input::get('to_date');
$account_id = Input::get('account_id');
$report = new Report();
$results = $report->getAccountsReportData($date1, $date2, $account_id);
$currentBalance = NameOfAccount::find($account_id);
$balanceIn = $report->getBalanceIn($date1, $date2, $account_id);
$balanceOut = $report->getBalanceOut($date1, $date2, $account_id);
$totalBalanceOut = $report->getTotalBalanceOut($account_id);
$totalBalanceIn = $report->getTotalBalanceIn($account_id);
return view('Reports.accountsReportResult', compact('results'))->with('account_id', $account_id)->with('totalBalanceIn', $totalBalanceIn)->with('totalBalanceOut', $totalBalanceOut)->with('balanceIn', $balanceIn)->with('currentBalance', $currentBalance)->with('balanceOut', $balanceOut)->with('date1', $date1)->with('date2', $date2);
}
<th>Created By</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$sl = 1;
?>
@foreach($balanceTransfers as $transfer )
<?php
$branch1 = \App\Branch::find($transfer->from_branch_id);
$branch2 = \App\Branch::find($transfer->to_branch_id);
$category1 = \App\AccountCategory::find($transfer->from_account_category_id);
$category2 = \App\AccountCategory::find($transfer->to_account_category_id);
$account1 = \App\NameOfAccount::find($transfer->from_account_name_id);
$account2 = \App\NameOfAccount::find($transfer->to_account_name_id);
$user = \App\User::find($transfer->user_id);
?>
<tr class="odd gradeX">
<td><?php
echo $sl;
?>
</td>
<td>{{$branch1->name}}</td>
<td>{{$category1->name}}</td>
<td>{{$account1->name}}</td>
<td>{{$branch2->name}}</td>
<td>{{$category2->name}}</td>
<td>{{$account2->name}}</td>
<td>{{$transfer->amount}}</td>
<td>{{$transfer->remarks}}</td>
