/**
* @param SaveInvoiceRequest $invoiceRequest
* @return \Illuminate\View\View
*/
public function save(SaveInvoiceRequest $invoiceRequest)
{
if (\Auth::user()) {
$model = Invoice::create(array_add($invoiceRequest->all(), 'user_id', \Auth::user()->id));
//TODO refactor it
} else {
abort(403, 'User is not logged in');
}
flash()->overlay('Success', 'Your invoice has been created!');
return redirect()->action('InvoiceController@index');
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(Request $request)
{
$this->validate($request, ['name' => 'required|max:255']);
$input = $request->all();
$input['branch_id'] = Auth::user()->branch_id;
$input['company_id'] = Auth::user()->company_id;
$input['user_id'] = Auth::user()->id;
$input['account_year_id'] = session('account');
Invoice::create($input);
flash()->success('General Head Created Successfully !');
return redirect('invoice');
}
/**
* Store a newly created resource in storage.
*
* @param InvoiceRequest $request
* @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector
*/
public function store(InvoiceRequest $request)
{
Invoice::create($request->all());
$isExist = Ledger::query()->get()->contains('reference', $request['invoiceNumber']);
$data = ['date' => $request['date'], 'client' => $request['client'], 'description' => $request['comment'], 'reference' => $request['invoiceNumber'], 'debit' => $request['bill'] + $request['ot_bill']];
if ($isExist == true) {
$ledger = Ledger::query()->where('reference', $request['invoiceNumber']);
$data = ['debit' => $ledger->get(['debit'])->sum('debit') + $request['ot_bill'] + $request['bill']];
$ledger->update($data);
} else {
Ledger::create($data);
}
Session::flash('success_message', 'Invoice Updated Successfully! If you have more vehicle to add in this Invoice, go to Create and do the same with same Invoice Number and Date!');
return redirect('invoice');
}
/**
* Save
*/
public function save($invoice = null, $data = null)
{
DB::transaction(function () use(&$data, &$invoice) {
if (is_null($invoice)) {
$invoice = Invoice::create($data);
} else {
$invoice->fill($data)->save();
}
if (!$data['items']) {
throw new UnprocessableEntityHttpException('Empty line items');
}
$invoice->items()->delete();
foreach ($data['items'] as $item) {
$invoice->items()->create($item);
}
});
return $this->getById($invoice->id);
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
echo "Started...";
$employees = Employee::where('category_id', 2)->get();
$rules = ['employee_id' => 'required|unique_with:invoices,months'];
foreach ($employees as $employee) {
$data['employee_id'] = $employee->id;
$data['company_id'] = $employee->company_id;
$data['months'] = Carbon::now()->firstOfMonth();
$data['fee'] = 0;
$data['employee_number'] = $employee->number;
$validator = \Validator::make($data, $rules);
if ($validator->fails()) {
} else {
//MobileFees::create($data);
Invoice::create($data);
}
}
}
protected function portalNewInvoice() {
if ( \Auth::user() ) {
$userTypeID = \Auth::user()->userTypeId;
if ( $userTypeID == 1 || $userTypeID == 2 ) {
$accntId = Input::get('accountId');
$items = Input::get('items');
$total = Input::get('total');
$empId = Input::get('empId');
$newInvoice = Invoice::create([
'accountId' => $accntId,
'total' => $total,
'statusId' => 1,
'employeeId' => $empId,
'created_at' => gmdate('Y-m-d H:i:s')
]);
$balance = Balance::where('accountId','=',$accntId)->first();
$current = $balance->balance;
$balance->balance = $current + $total;
$balance->updated_at = gmdate("Y-m-d H:i:s");
$balance->save();
foreach ( $items as $item ) {
$newInvItem = InvItems::create([
'invoiceId' => $newInvoice->id,
'productId' => $item['id'],
'quantity' => $item['quantity'],
'price' => $item['price'],
'lineTotal' => $item['quantity'] * $item['price'],
'created_at' => gmdate('Y-m-d H:i:s')
]);
}
return "success";
} else {
return Redirect::to('/account');
}
} else {
return Redirect::to('/');
}
}
