public function create()
{
$accounts = ChartOfAccount::where('account_type', 1)->lists('name', 'code');
$types = Config::get('common.transaction_customer_type');
$years = CommonHelper::get_years();
return view('transactionRecorders.create', compact('accounts', 'types', 'years'));
}
public function create()
{
$accounts = ChartOfAccount::where('account_type', 1)->where('code', 'like', '2%')->orWhere('code', '32000')->lists('name', 'code');
$types = Config::get('common.transaction_customer_type');
$years = CommonHelper::get_years();
return view('makePayment.create', compact('accounts', 'types', 'years'));
}
public function update($id, ChartOfAccountRequest $request)
{
$chart = ChartOfAccount::findOrFail($id);
$chart->parent = $request->input('parent');
$chart->name = $request->input('name');
$chart->code = $request->input('code');
$chart->status = $request->input('status');
if ($request->input('contra_status')) {
$chart->contra_status = 1;
$chart->contra_code = $request->input('contra_id');
}
$chart->update();
Session()->flash('flash_message', 'Chart Of Account has been updated!');
return redirect('charts');
}
/**
* Get the validation rules that apply to the request.
*
* @return array
*/
public function rules()
{
$account = ChartOfAccount::find($this->charts);
// charts = route
switch ($this->method()) {
case 'GET':
case 'DELETE':
return [];
case 'POST':
return ['name' => 'required', 'code' => 'required|unique:chart_of_accounts|digits:5'];
case 'PUT':
case 'PATCH':
return ['name' => 'required', 'code' => 'required|digits:5|unique:chart_of_accounts,code,' . $account->id];
default:
break;
}
}
public function create()
{
$accounts_from = ChartOfAccount::whereIn('code', Config::get('common.adjustment_account_from'))->lists('name', 'code');
$accounts_to = ChartOfAccount::whereIn('code', Config::get('common.adjustment_account_to'))->lists('name', 'code');
return view('adjustments.create', compact('accounts_from', 'accounts_to'));
}
public function store(Request $request)
{
$yearClosingStatus = AccountClosing::where(['year' => CommonHelper::get_current_financial_year(), 'type' => 2])->lists('id');
if (sizeof($yearClosingStatus) == 0) {
$workspaces = Workspace::where('status', 1)->lists('id');
$closedWorkspaces = AccountClosing::where(['year' => CommonHelper::get_current_financial_year(), 'type' => 1])->lists('workspace_id');
if (sizeof($workspaces) == sizeof($closedWorkspaces)) {
try {
DB::transaction(function () use($request) {
$heads = ChartOfAccount::where('status', 1)->lists('code');
$currentYear = CommonHelper::get_current_financial_year();
foreach ($heads as $head) {
$headTotal = WorkspaceLedger::where(['account_code' => $head, 'year' => CommonHelper::get_current_financial_year(), 'balance_type' => Config::get('common.balance_type_closing')])->sum('balance');
// Closing Balance Set
$generalLedger = new GeneralLedger();
$generalLedger->year = $currentYear;
$generalLedger->account_code = $head;
$generalLedger->balance_type = Config::get('common.balance_type_closing');
$generalLedger->balance = $headTotal;
$generalLedger->created_by = Auth::user()->id;
$generalLedger->created_at = time();
$generalLedger->save();
// Opening Balance Set for Next Financial Year
if (substr($head, 0, 1) == 1 || substr($head, 0, 1) == 4 || substr($head, 0, 1) == 6) {
$generalLedger = new GeneralLedger();
$generalLedger->year = CommonHelper::get_next_financial_year();
$generalLedger->account_code = $head;
$generalLedger->balance_type = Config::get('common.balance_type_opening');
$generalLedger->balance = $headTotal;
$generalLedger->created_by = Auth::user()->id;
$generalLedger->created_at = time();
$generalLedger->save();
} else {
$generalLedger = new GeneralLedger();
$generalLedger->year = CommonHelper::get_next_financial_year();
$generalLedger->account_code = $head;
$generalLedger->balance_type = Config::get('common.balance_type_opening');
$generalLedger->balance = 0;
$generalLedger->created_by = Auth::user()->id;
$generalLedger->created_at = time();
$generalLedger->save();
}
}
// Account Closing table Impact
$accountClosing = new AccountClosing();
$accountClosing->type = 2;
// Year Closing type=2 and Workspace Closing type=1;
$accountClosing->year = $currentYear;
$accountClosing->save();
// Raw Stock Table Impact
$rawMaterials = RawStock::where(['year' => CommonHelper::get_current_financial_year(), 'stock_type' => Config::get('common.balance_type_intermediate')])->get();
foreach ($rawMaterials as $rawMaterial) {
// Current Year Opening Balance
$rawStock = new RawStock();
$rawStock->year = $currentYear;
$rawStock->stock_type = Config::get('common.balance_type_closing');
$rawStock->material_id = $rawMaterial->material_id;
$rawStock->quantity = $rawMaterial->quantity;
$rawStock->created_by = Auth::user()->id;
$rawStock->created_at = time();
// Next Year Opening Balance
$rawStock = new RawStock();
$rawStock->year = CommonHelper::get_next_financial_year();
$rawStock->stock_type = Config::get('common.balance_type_opening');
$rawStock->material_id = $rawMaterial->material_id;
$rawStock->quantity = $rawMaterial->quantity;
$rawStock->created_by = Auth::user()->id;
$rawStock->created_at = time();
// Next Year Intermediate Balance
$rawStock = new RawStock();
$rawStock->year = CommonHelper::get_next_financial_year();
$rawStock->stock_type = Config::get('common.balance_type_intermediate');
$rawStock->material_id = $rawMaterial->material_id;
$rawStock->quantity = $rawMaterial->quantity;
$rawStock->created_by = Auth::user()->id;
$rawStock->created_at = time();
}
// Current Year Data Fetch
$existingYearDetail = DB::table('financial_years')->where('year', $currentYear)->first();
$nextYear = CommonHelper::get_next_financial_year();
// Current Year Inactive
DB::table('financial_years')->where('year', $currentYear)->update(['status' => 0]);
// New Year Insert
DB::table('financial_years')->insert(['year' => $nextYear, 'start_date' => strtotime(date("Y-m-d", $existingYearDetail->start_date) . " + 1 year"), 'end_date' => strtotime(date("Y-m-d", $existingYearDetail->end_date) . " + 1 year"), 'created_by' => Auth::user()->id, 'created_at' => time()]);
});
} catch (\Exception $e) {
Session()->flash('error_message', 'Year Closing Not Done!');
return redirect('year_closing');
}
Session()->flash('flash_message', 'Year Closed And New Year Opened Successfully!');
return redirect('year_closing');
} else {
Session()->flash('warning_message', 'Warning: All Workspace Account Not Closed Yet!');
return redirect('year_closing');
}
} else {
Session()->flash('warning_message', 'Warning: Year Closing Done For This Year!');
return redirect('year_closing');
}
}
public function edit($id)
{
$initializations = WorkspaceLedger::where('workspace_id', $id)->get();
$accounts = ChartOfAccount::where('status', 1)->select('name', 'code')->get();
return view('initializations.edit', compact('accounts', 'initializations', 'id'));
}
public function store(Request $request)
{
$workspace_id = Auth::user()->workspace_id;
$closedWorkspace = AccountClosing::where(['year' => CommonHelper::get_current_financial_year(), 'type' => 1, 'workspace_id' => $workspace_id])->lists('workspace_id');
if (sizeof($closedWorkspace) == 0) {
try {
DB::transaction(function () use($request) {
$workspace_id = Auth::user()->workspace_id;
$levelZeros = ChartOfAccount::where(['parent' => 0, 'status' => 1])->select('id', 'name', 'code')->get();
foreach ($levelZeros as $levelZero) {
$workspaceData = WorkspaceLedger::where(['workspace_id' => $workspace_id, 'account_code' => $levelZero->code, 'balance_type' => Config::get('common.balance_type_intermediate'), 'year' => CommonHelper::get_current_financial_year()])->first();
$balance = isset($workspaceData->balance) ? $workspaceData->balance : 0;
$a[] = [$levelZero->id, $levelZero->code, '', $balance];
}
for ($ci = 0; isset($a[$ci][0]); $ci++) {
$nextLevels = ChartOfAccount::where(['parent' => $a[$ci][0], 'status' => 1])->get(['code', 'id']);
foreach ($nextLevels as $nextLevel) {
$NextLevelWorkspaceData = WorkspaceLedger::where(['workspace_id' => $workspace_id, 'account_code' => $nextLevel->code, 'balance_type' => Config::get('common.balance_type_intermediate'), 'year' => CommonHelper::get_current_financial_year()])->first();
$nextLevelBalance = isset($NextLevelWorkspaceData->balance) ? $NextLevelWorkspaceData->balance : 0;
$a[] = [$nextLevel->id, $nextLevel->code, $ci, $nextLevelBalance];
}
}
$ci = sizeof($a) - 1;
for (; $ci >= 0; $ci--) {
if (isset($a[$a[$ci][2]][3])) {
$contra = ChartOfAccount::where(['contra_status' => 1, 'id' => $a[$ci][0]])->first();
if ($contra) {
$a[$a[$ci][2]][3] -= $a[$ci][3];
} else {
$a[$a[$ci][2]][3] += $a[$ci][3];
}
}
// Closing Balance
$workspaceLedger = new WorkspaceLedger();
$workspaceLedger->workspace_id = $workspace_id;
$workspaceLedger->year = CommonHelper::get_current_financial_year();
$workspaceLedger->account_code = $a[$ci][1];
$workspaceLedger->balance_type = Config::get('common.balance_type_closing');
$workspaceLedger->balance = $a[$ci][3];
$workspaceLedger->created_by = Auth::user()->id;
$workspaceLedger->created_at = time();
$workspaceLedger->save();
if (substr($a[$ci][1], 0, 1) == 1 || substr($a[$ci][1], 0, 1) == 4 || substr($a[$ci][1], 0, 1) == 6) {
// Initial Balance Next Year
$workspaceLedger = new WorkspaceLedger();
$workspaceLedger->workspace_id = $workspace_id;
$workspaceLedger->year = CommonHelper::get_next_financial_year();
$workspaceLedger->account_code = $a[$ci][1];
$workspaceLedger->balance_type = Config::get('common.balance_type_opening');
$workspaceLedger->balance = $a[$ci][3];
$workspaceLedger->created_by = Auth::user()->id;
$workspaceLedger->created_at = time();
$workspaceLedger->save();
// Intermediate Balance Next Year
$workspaceLedger = new WorkspaceLedger();
$workspaceLedger->workspace_id = $workspace_id;
$workspaceLedger->year = CommonHelper::get_next_financial_year();
$workspaceLedger->account_code = $a[$ci][1];
$workspaceLedger->balance_type = Config::get('common.balance_type_intermediate');
$workspaceLedger->balance = $a[$ci][3];
$workspaceLedger->created_by = Auth::user()->id;
$workspaceLedger->created_at = time();
$workspaceLedger->save();
} else {
// Initial Balance Next Year
$workspaceLedger = new WorkspaceLedger();
$workspaceLedger->workspace_id = $workspace_id;
$workspaceLedger->year = CommonHelper::get_next_financial_year();
$workspaceLedger->account_code = $a[$ci][1];
$workspaceLedger->balance_type = Config::get('common.balance_type_opening');
$workspaceLedger->balance = 0;
$workspaceLedger->created_by = Auth::user()->id;
$workspaceLedger->created_at = time();
$workspaceLedger->save();
// Intermediate Balance Next Year
$workspaceLedger = new WorkspaceLedger();
$workspaceLedger->workspace_id = $workspace_id;
$workspaceLedger->year = CommonHelper::get_next_financial_year();
$workspaceLedger->account_code = $a[$ci][1];
$workspaceLedger->balance_type = Config::get('common.balance_type_intermediate');
$workspaceLedger->balance = 0;
$workspaceLedger->created_by = Auth::user()->id;
$workspaceLedger->created_at = time();
$workspaceLedger->save();
}
}
// Workspace Account Close Info
$accountClosing = new AccountClosing();
$accountClosing->workspace_id = $workspace_id;
$accountClosing->year = CommonHelper::get_current_financial_year();
$accountClosing->save();
// Workspace Stock Closing
$existingStocks = Stock::where(['stock_type' => Config::get('common.balance_type_intermediate'), 'workspace_id' => $workspace_id, 'year' => CommonHelper::get_current_financial_year()])->get();
if (sizeof($existingStocks) > 0) {
foreach ($existingStocks as $existingStock) {
// Current Year Closing Balance
$stock = new Stock();
$stock->year = CommonHelper::get_current_financial_year();
$stock->stock_type = Config::get('common.balance_type_closing');
$stock->workspace_id = $workspace_id;
$stock->product_id = $existingStock->product_id;
$stock->quantity = $existingStock->quantity;
$stock->created_by = Auth::user()->id;
$stock->created_at = time();
$stock->save();
// Next Year Opening Balance
$stock = new Stock();
$stock->year = CommonHelper::get_next_financial_year();
$stock->stock_type = Config::get('common.balance_type_opening');
$stock->workspace_id = $workspace_id;
$stock->product_id = $existingStock->product_id;
$stock->quantity = $existingStock->quantity;
$stock->created_by = Auth::user()->id;
$stock->created_at = time();
$stock->save();
// Next Year Intermediate Balance
$stock = new Stock();
$stock->year = CommonHelper::get_next_financial_year();
$stock->stock_type = Config::get('common.balance_type_intermediate');
$stock->workspace_id = $workspace_id;
$stock->product_id = $existingStock->product_id;
$stock->quantity = $existingStock->quantity;
$stock->created_by = Auth::user()->id;
$stock->created_at = time();
$stock->save();
}
}
});
} catch (\Exception $e) {
Session()->flash('error_message', 'Workspace Account Closing Not Done!');
return redirect('workspace_closing');
}
Session()->flash('flash_message', 'Workspace Account Closed Successfully!');
return redirect('workspace_closing');
} else {
Session()->flash('warning_message', 'Workspace Account Closed Already For This Year!');
return redirect('workspace_closing');
}
}
public function store(BankRequest $request)
{
try {
DB::transaction(function () use($request) {
$inputs = $request->input();
$time = time();
$user = Auth::user();
$year = CommonHelper::get_current_financial_year();
$bank = new Bank();
$chartOfAccount = new ChartOfAccount();
$workspaceLedgerData = new WorkspaceLedger();
// Bank Entry
$bank->name = $inputs['name'];
$bank->account_name = $inputs['account_name'];
$bank->account_no = $inputs['account_no'];
$bank->account_director = $inputs['account_director'];
$bank->account_type = $inputs['account_type'];
$bank->start_date = $inputs['start_date'];
$bank->balance = $inputs['opening_balance'];
$bank->account_code = $inputs['account_code'];
$bank->created_by = $user->id;
$bank->created_at = $time;
$bank->save();
// Account Head Entry
$chartOfAccount->parent = 1;
// Asset
$chartOfAccount->name = $inputs['name'];
$chartOfAccount->code = $inputs['account_code'];
$chartOfAccount->save();
// Workspace Ledger Account Head Data (Opening)
$workspaceLedgerData->workspace_id = $user->workspace_id;
$workspaceLedgerData->year = $year;
$workspaceLedgerData->account_code = $inputs['account_code'];
$workspaceLedgerData->balance_type = Config::get('common.balance_type_opening');
$workspaceLedgerData->balance = 0;
$workspaceLedgerData->created_by = $user->id;
$workspaceLedgerData->created_at = $time;
$workspaceLedgerData->save();
// Workspace Ledger Account Head Data (Intermediate)
$workspaceLedgerData = new WorkspaceLedger();
$workspaceLedgerData->workspace_id = $user->workspace_id;
$workspaceLedgerData->year = $year;
$workspaceLedgerData->account_code = $inputs['account_code'];
$workspaceLedgerData->balance_type = Config::get('common.balance_type_intermediate');
$workspaceLedgerData->balance = 0;
$workspaceLedgerData->created_by = $user->id;
$workspaceLedgerData->created_at = $time;
$workspaceLedgerData->save();
if ($inputs['opening_balance'] > 0) {
// Update Workspace Ledger
$workspaceLedger = WorkspaceLedger::where(['workspace_id' => $user->workspace_id, 'account_code' => $inputs['account_code'], 'balance_type' => Config::get('common.balance_type_intermediate'), 'year' => $year])->first();
$workspaceLedger->balance += $inputs['opening_balance'];
$workspaceLedger->updated_by = $user->id;
$workspaceLedger->updated_by = $time;
$workspaceLedger->save();
}
});
} catch (\Exception $e) {
dd($e);
Session::flash('error_message', 'Failed to create Bank. Please try again!');
return Redirect::back();
}
Session::flash('flash_message', 'Bank created successfully!');
return redirect('banks');
}
