/**
* @DELETE("/requests/{id}", as="admin.requests.delete")
* @param $id
* @return \Illuminate\Http\RedirectResponse
*/
public function delete($id)
{
Purchase::findOrFail($id)->delete();
return back();
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
if (!$request->input('items')) {
Session()->flash('error_message', 'Purchases Update has not been Completed');
return redirect('purchases');
}
try {
DB::transaction(function () use($request, $id) {
$time = time();
$workspace_id = Auth::user()->workspace_id;
$balance_type = Config::get('common.balance_type_intermediate');
$transaction_type = Config::get('common.transaction_type.purchase');
$person_type_supplier = Config::get('common.person_type_supplier');
$year = CommonHelper::get_current_financial_year();
$user_id = Auth::user()->id;
$old_main_purchase = Purchase::findOrFail($id);
$purchase = Purchase::findOrFail($id);
$purchase->supplier_id = $request->input('supplier_id');
$purchase->purchase_date = $request->input('purchase_date');
$purchase->transportation_cost = $request->input('transportation_cost');
$purchase->paid = $request->input('paid');
$purchase->total = $request->input('total');
$purchase->updated_at = time();
$purchase->updated_by = $user_id;
$purchase->update();
//get all old items
$arrange_old_items = [];
$old_purchases = PurchaseDetail::where('purchase_id', $id)->get();
foreach ($old_purchases as $old_purchase) {
$arrange_old_items[$old_purchase['material_id']] = $old_purchase;
}
foreach ($request->input('items') as $item) {
if (isset($arrange_old_items[$item['material_id']])) {
// update old data
$PurchaseDetail = PurchaseDetail::findOrFail($arrange_old_items[$item['material_id']]['id']);
$PurchaseDetail->quantity = $item['quantity'];
$PurchaseDetail->received_quantity = $item['received_quantity'];
$PurchaseDetail->unit_price = $item['unit_price'];
$PurchaseDetail->status = 1;
$PurchaseDetail->updated_at = time();
$PurchaseDetail->updated_by = $user_id;
$PurchaseDetail->update();
//update stock info
if ($arrange_old_items[$item['material_id']]['received_quantity'] < $item['received_quantity']) {
$add_amount = $item['received_quantity'] - $arrange_old_items[$item['material_id']]['received_quantity'];
RawStock::where(['material_id' => $item['material_id'], 'year' => $year, 'stock_type' => $balance_type])->increment('quantity', $add_amount, ['updated_at' => $time, 'updated_by' => $user_id]);
} elseif ($arrange_old_items[$item['material_id']]['received_quantity'] > $item['received_quantity']) {
$sub_amount = $arrange_old_items[$item['material_id']]['received_quantity'] - $item['received_quantity'];
RawStock::where(['material_id' => $item['material_id'], 'year' => $year, 'stock_type' => $balance_type])->decrement('quantity', $sub_amount, ['updated_at' => $time, 'updated_by' => $user_id]);
}
unset($arrange_old_items[$item['material_id']]);
} else {
//purchase details
$item['purchase_id'] = $id;
$item['status'] = 1;
$item['created_at'] = time();
$item['created_by'] = $user_id;
PurchaseDetail::create($item);
//update stock info
RawStock::where(['material_id' => $item['material_id'], 'year' => $year, 'stock_type' => $balance_type])->increment('quantity', $item['received_quantity'], ['updated_at' => $time, 'updated_by' => $user_id]);
}
}
//delete old data
foreach ($arrange_old_items as $old_item) {
//reduce the stock info
RawStock::where(['material_id' => $item['material_id'], 'year' => $year, 'stock_type' => $balance_type])->decrement('quantity', $old_item['received_quantity'], ['updated_at' => $time, 'updated_by' => $user_id]);
//update the purchase info
$PurchaseDetail = PurchaseDetail::findOrFail($old_item['id']);
$PurchaseDetail->delete();
}
/*
* Account management
*
*/
$input = $request->input();
if ($old_main_purchase['transportation_cost'] != $input['transportation_cost']) {
if ($old_main_purchase['transportation_cost'] > $input['transportation_cost']) {
$deviation = $old_main_purchase['transportation_cost'] - $input['transportation_cost'];
// Update Workspace Ledger
$workspace = WorkspaceLedger::where(['account_code' => 24000, 'workspace_id' => $workspace_id, 'balance_type' => $balance_type, 'year' => $year])->first();
$workspace->balance -= $input['transportation_cost'];
$workspace->updated_by = $user_id;
$workspace->updated_at = $time;
$workspace->save();
$workspace = WorkspaceLedger::where(['account_code' => 11000, 'workspace_id' => $workspace_id, 'balance_type' => $balance_type, 'year' => $year])->first();
$workspace->balance += $input['transportation_cost'];
$workspace->updated_by = $user_id;
$workspace->updated_at = $time;
$workspace->save();
//Update General Journal
$general_journal = GeneralJournal::where(['transaction_type' => $transaction_type, 'reference_id' => $id, 'account_code' => 24000, 'year' => $year, 'workspace_id' => $workspace_id])->first();
$general_journal->amount -= $deviation;
$general_journal->updated_by = $user_id;
$general_journal->updated_at = $time;
$general_journal->save();
$general_journal = GeneralJournal::where(['transaction_type' => $transaction_type, 'reference_id' => $id, 'account_code' => 11000, 'year' => $year, 'workspace_id' => $workspace_id])->first();
$general_journal->amount -= $deviation;
$general_journal->updated_by = $user_id;
$general_journal->updated_at = $time;
$general_journal->save();
} elseif ($old_main_purchase['transportation_cost'] < $input['transportation_cost']) {
$deviation = $input['transportation_cost'] - $old_main_purchase['transportation_cost'];
// Update Workspace Ledger
$workspace = WorkspaceLedger::where(['account_code' => 24000, 'workspace_id' => $workspace_id, 'balance_type' => $balance_type, 'year' => $year])->first();
$workspace->balance += $input['transportation_cost'];
$workspace->updated_by = $user_id;
$workspace->updated_at = $time;
$workspace->save();
$workspace = WorkspaceLedger::where(['account_code' => 11000, 'workspace_id' => $workspace_id, 'balance_type' => $balance_type, 'year' => $year])->first();
$workspace->balance -= $input['transportation_cost'];
$workspace->updated_by = $user_id;
$workspace->updated_at = $time;
$workspace->save();
//Update General Journal
$general_journal = GeneralJournal::where(['transaction_type' => $transaction_type, 'reference_id' => $id, 'account_code' => 24000, 'year' => $year, 'workspace_id' => $workspace_id])->first();
$general_journal->amount += $deviation;
$general_journal->updated_by = $user_id;
$general_journal->updated_at = $time;
$general_journal->save();
$general_journal = GeneralJournal::where(['transaction_type' => $transaction_type, 'reference_id' => $id, 'account_code' => 11000, 'year' => $year, 'workspace_id' => $workspace_id])->first();
$general_journal->amount += $deviation;
$general_journal->updated_by = $user_id;
$general_journal->updated_at = $time;
$general_journal->save();
}
}
if ($input['paid'] && $old_main_purchase['paid'] < $input['paid']) {
$workspace = WorkspaceLedger::where(['account_code' => 11000, 'workspace_id' => $workspace_id, 'balance_type' => $balance_type, 'year' => $year])->first();
$new_remain_paid_amount = $input['paid'] - $old_main_purchase['paid'];
if ($new_remain_paid_amount > $workspace->balance) {
Session()->flash('warning_message', 'Low Balance!! New Purchase paid amount(' . $new_remain_paid_amount . ') is greater than Balance (' . $workspace->balance . ')');
throw new \Exception('error');
}
}
//update the accounting tables
$workspace_id = Auth::user()->workspace_id;
$balance_type = Config::get('common.balance_type_intermediate');
$transaction_type = Config::get('common.transaction_type.purchase');
$person_type_supplier = Config::get('common.person_type_supplier');
$user_id = Auth::user()->id;
$time = time();
//update general journal for raw material purchase
$general_journal = GeneralJournal::where(['transaction_type' => $transaction_type, 'reference_id' => $id, 'account_code' => 25000, 'year' => $year, 'workspace_id' => $workspace_id])->first();
$general_journal->amount = $input['total'];
$general_journal->updated_by = $user_id;
$general_journal->updated_at = $time;
$general_journal->save();
//update Workspace for raw material purchase
$new_total_amount = $input['total'];
$old_total_amount = $old_main_purchase['total'];
if ($new_total_amount > $old_total_amount) {
$workspace = WorkspaceLedger::where(['account_code' => 25000, 'workspace_id' => $workspace_id, 'balance_type' => $balance_type, 'year' => $year])->first();
$workspace->balance += $new_total_amount - $old_total_amount;
//add material purchase
$workspace->updated_by = $user_id;
$workspace->updated_at = $time;
$workspace->save();
} elseif ($new_total_amount < $old_total_amount) {
$workspace = WorkspaceLedger::where(['account_code' => 25000, 'workspace_id' => $workspace_id, 'balance_type' => $balance_type, 'year' => $year])->first();
$workspace->balance -= $old_total_amount - $new_total_amount;
//sub material purchase
$workspace->updated_by = $user_id;
$workspace->updated_at = $time;
$workspace->save();
}
//update cash amount
$new_paid_amount = $input['paid'];
$old_paid_amount = $old_main_purchase['paid'];
// throw new \Exception($new_paid_amount.'='.$old_paid_amount);
if (!$new_paid_amount && $old_paid_amount) {
$general_journal = GeneralJournal::where(['transaction_type' => $transaction_type, 'reference_id' => $id, 'account_code' => 11000, 'year' => $year, 'workspace_id' => $workspace_id])->first();
$general_journal->delete();
$workspace = WorkspaceLedger::where(['account_code' => 11000, 'workspace_id' => $workspace_id, 'balance_type' => $balance_type, 'year' => $year])->first();
$workspace->balance -= $old_paid_amount;
//sub Cash
$workspace->updated_by = $user_id;
$workspace->updated_at = $time;
$workspace->save();
} elseif (!$old_paid_amount && $new_paid_amount) {
//Insert data into General Journal
$journal = new GeneralJournal();
$journal->date = $time;
$journal->transaction_type = $transaction_type;
$journal->reference_id = $id;
$journal->year = $year;
$journal->account_code = 11000;
//Cash
$journal->workspace_id = $workspace_id;
$journal->amount = $new_paid_amount;
$journal->dr_cr_indicator = Config::get('common.debit_credit_indicator.credit');
$journal->created_by = $user_id;
$journal->created_at = $time;
$journal->save();
$workspace = WorkspaceLedger::where(['account_code' => 11000, 'workspace_id' => $workspace_id, 'balance_type' => $balance_type, 'year' => $year])->first();
$workspace->balance -= $new_paid_amount;
//sub Cash
$workspace->updated_by = $user_id;
$workspace->updated_at = $time;
$workspace->save();
} elseif ($new_paid_amount > $old_paid_amount) {
$general_journal = GeneralJournal::where(['transaction_type' => $transaction_type, 'reference_id' => $id, 'account_code' => 11000, 'year' => $year, 'workspace_id' => $workspace_id])->first();
$general_journal->amount = $new_paid_amount;
$general_journal->updated_by = $user_id;
$general_journal->updated_at = $time;
$general_journal->save();
$workspace = WorkspaceLedger::where(['account_code' => 11000, 'workspace_id' => $workspace_id, 'balance_type' => $balance_type, 'year' => $year])->first();
$workspace->balance -= $new_paid_amount - $old_paid_amount;
//sub Cash
$workspace->updated_by = $user_id;
$workspace->updated_at = $time;
$workspace->save();
} elseif ($new_paid_amount < $old_paid_amount) {
$general_journal = GeneralJournal::where(['transaction_type' => $transaction_type, 'reference_id' => $id, 'account_code' => 11000, 'year' => $year, 'workspace_id' => $workspace_id])->first();
$general_journal->amount = $new_paid_amount;
$general_journal->updated_by = $user_id;
$general_journal->updated_at = $time;
$general_journal->save();
$workspace = WorkspaceLedger::where(['account_code' => 11000, 'workspace_id' => $workspace_id, 'balance_type' => $balance_type, 'year' => $year])->first();
$workspace->balance += $old_paid_amount - $new_paid_amount;
//add Cash
$workspace->updated_by = $user_id;
$workspace->updated_at = $time;
$workspace->save();
}
//DUE management (liabilities)
$new_due_amount = $input['total'] - $input['paid'];
$old_due_amount = $old_main_purchase['total'] - $old_main_purchase['paid'];
if ($new_due_amount && !$old_due_amount) {
$journal = new GeneralJournal();
$journal->date = $time;
$journal->transaction_type = $transaction_type;
$journal->reference_id = $id;
$journal->year = $year;
$journal->account_code = 41000;
//Account Payable
$journal->dr_cr_indicator = Config::get('common.debit_credit_indicator.credit');
$journal->workspace_id = $workspace_id;
$journal->amount = $new_due_amount;
$journal->created_by = $user_id;
$journal->created_at = $time;
$journal->save();
$workspace = WorkspaceLedger::where(['account_code' => 41000, 'workspace_id' => $workspace_id, 'balance_type' => $balance_type, 'year' => $year])->first();
$workspace->balance += $new_due_amount;
//add account payable credit
$workspace->updated_by = $user_id;
$workspace->updated_at = $time;
$workspace->save();
// Update Personal Account
$personal = PersonalAccount::where('person_id', $input['supplier_id'])->where('person_type', $person_type_supplier)->first();
$personal->balance += $new_due_amount;
$personal->updated_by = $user_id;
$personal->updated_at = $time;
$personal->save();
} elseif ($old_due_amount && !$new_due_amount) {
$general_journal = GeneralJournal::where(['transaction_type' => $transaction_type, 'reference_id' => $id, 'account_code' => 41000, 'year' => $year, 'workspace_id' => $workspace_id])->first();
$general_journal->delete();
$workspace = WorkspaceLedger::where(['account_code' => 41000, 'workspace_id' => $workspace_id, 'balance_type' => $balance_type, 'year' => $year])->first();
$workspace->balance -= $old_due_amount;
//add account payable debit
$workspace->updated_by = $user_id;
$workspace->updated_at = $time;
$workspace->save();
// Update Personal Account
$personal = PersonalAccount::where('person_id', $input['supplier_id'])->where('person_type', $person_type_supplier)->first();
$personal->balance -= $old_due_amount;
$personal->updated_by = $user_id;
$personal->updated_at = $time;
$personal->save();
} elseif ($new_due_amount > $old_due_amount) {
$general_journal = GeneralJournal::where(['transaction_type' => $transaction_type, 'reference_id' => $id, 'account_code' => 41000, 'year' => $year, 'workspace_id' => $workspace_id])->first();
$general_journal->amount = $new_due_amount;
$general_journal->updated_by = $user_id;
$general_journal->updated_at = $time;
$general_journal->save();
$workspace = WorkspaceLedger::where(['account_code' => 41000, 'workspace_id' => $workspace_id, 'balance_type' => $balance_type, 'year' => $year])->first();
$workspace->balance += $new_due_amount - $old_due_amount;
//add account payable debit
$workspace->updated_by = $user_id;
$workspace->updated_at = $time;
$workspace->save();
// Update Personal Account
$personal = PersonalAccount::where('person_id', $input['supplier_id'])->where('person_type', $person_type_supplier)->first();
$personal->balance += $new_due_amount - $old_due_amount;
$personal->updated_by = $user_id;
$personal->updated_at = $time;
$personal->save();
} elseif ($new_due_amount < $old_due_amount) {
$general_journal = GeneralJournal::where(['transaction_type' => $transaction_type, 'reference_id' => $id, 'account_code' => 41000, 'year' => $year, 'workspace_id' => $workspace_id])->first();
$general_journal->amount = $new_due_amount;
$general_journal->updated_by = $user_id;
$general_journal->updated_at = $time;
$general_journal->save();
$workspace = WorkspaceLedger::where(['account_code' => 41000, 'workspace_id' => $workspace_id, 'balance_type' => $balance_type, 'year' => $year])->first();
$workspace->balance -= $old_due_amount - $new_due_amount;
//add account payable debit
$workspace->updated_by = $user_id;
$workspace->updated_at = $time;
$workspace->save();
// Update Personal Account
$personal = PersonalAccount::where('person_id', $input['supplier_id'])->where('person_type', $person_type_supplier)->first();
$personal->balance -= $old_due_amount - $new_due_amount;
$personal->updated_by = $user_id;
$personal->updated_at = $time;
$personal->save();
}
});
} catch (\Exception $e) {
Session()->flash('error_message', $e->getMessage());
// Session()->flash('error_message','Purchases Update has not been Completed');
return Redirect::back();
}
Session()->flash('flash_message', 'Purchases Update has been Completed');
return redirect('purchases');
}
