/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function getIndex($order_id)
{
$id = $order_id;
$invoicedata = Invoice::where('Id', $id)->get();
$html22 = View('viewinvoice')->with(array('invoicedata' => $invoicedata))->render();
require_once app_path() . '/libs/html2pdf/html2pdf.class.php';
$html2pdf = new \HTML2PDF('P', 'A4', 'en', true, 'UTF-8', array(0, 0, 0, 0));
// $html2pdf->pdf->SetDisplayMode('fullpage');
$html2pdf->WriteHTML($html22);
$html2pdf->Output('Invoice.pdf');
}
public function calculate()
{
$user = Auth::user();
$cart = Cart::where('user_id', '=', $user->id)->where('status', '=', 'pending')->first();
$invoice = new Invoice();
if (!empty($cart)) {
$total = 0;
foreach ($cart->Product as $order) {
$product = $order->Product;
if ($product->special_price > 0 && $product->special_price < $product->price) {
$total += $product->special_price * $order->quanlity;
} else {
$total += $product->price * $order->quanlity;
}
}
$invoice->cart_id = $cart->id;
$invoice->total = $total;
$invoice->user_id = Auth::user()->id;
$invoice->status = 'pending';
$invoice->save();
$cart->status = 'confirm';
$cart->save();
return redirect('checkout/calculate/success');
} else {
return redirect('/');
}
}
public static function addNew($description, $total_cost)
{
$invoice = new Invoice();
$invoice->description = $description;
$invoice->total_cost = $total_cost;
$invoice->creator_id = \Auth::user()->id;
$invoice->save();
return $invoice;
}
public function devisRepair($id, Request $req, Invoice $invoice)
{
$repair = File::where('id', $id)->with('repair.details.article', 'repair.device.modele.brand', 'repair.device.modele.category', 'client')->first();
if ($req['_action'] == "sendmail") {
$response = $invoice->sendDevisRepairMail($repair);
return $response;
}
return view('/files/devis-repair', ['repair' => $repair]);
}
public function store(CreateInvoiceRequest $request)
{
$user_id = Session::get('user_id');
$user = User::where('id', $user_id)->first();
$invoice = $user->invoice()->create($request->all());
$user_balance = $user->balance;
if ($user->balance != 0) {
session()->flash('flash_message', 'Your invoice has been created successfully! The amount minus user balance is: ' . ($request->amount - $user->balance));
$user->balance = 0;
if ($user->save()) {
$discount_invoice = new App\Invoice();
$discount_invoice->name = 'Paid from your balance for ' . $request->name;
$discount_invoice->amount = $user_balance * -1;
$discount_invoice->user()->associate($user);
$discount_invoice->save();
}
} else {
session()->flash('flash_message', 'Your invoice has been created successfully!');
}
$first_root_id = $user->root_id;
if ($first_root_id !== null) {
$first_root = User::where('id', $first_root_id)->first();
$commission_amount = $request->amount * 0.1;
$commission = new App\Commission();
$commission->user()->associate($first_root);
$commission->invoice()->associate($invoice);
$commission->amount = $commission_amount;
$commission->save();
$first_root->balance += $commission_amount;
$first_root->save();
if ($first_root->root_id !== null) {
$second_root = User::where('id', $first_root->root_id)->first();
$commission_amount = $request->amount * 0.05;
$commission = new App\Commission();
$commission->invoice()->associate($invoice);
$commission->user()->associate($second_root);
$commission->amount = $commission_amount;
$commission->save();
$second_root->balance += $commission_amount;
$second_root->save();
if ($second_root->root_id !== null) {
$third_root = User::where('id', $second_root->root_id)->first();
$commission_amount = $request->amount * 0.02;
$commission = new App\Commission();
$commission->invoice()->associate($invoice);
$commission->user()->associate($third_root);
$commission->amount = $commission_amount;
$commission->save();
$third_root->balance += $commission_amount;
$third_root->save();
}
}
}
$invoices = Invoice::latest()->get()->take(5);
return view('admin', compact('invoices'));
}
public function emailInvoice(Invoice $invoice, $isReminder = 0)
{
$sender = $invoice->pandaw ? ['email' => '*****@*****.**', 'name' => null] : ['email' => '*****@*****.**', 'name' => 'Sayang Holidays'];
$receiver = ['email' => $invoice->user->email, 'name' => $invoice->user->fullName()];
$subject = 'Invoice # ' . $invoice->invoiceId();
$view = $this->getEmailContent($invoice->pandaw, $isReminder);
$bcc = true;
$attachments = $this->getAttachments($invoice->invoiceId());
$data = compact('bcc', 'invoice', 'attachments');
$this->sendTo($sender, $receiver, $subject, $view, $data);
}
public function getPayment($invoiceid)
{
$id = $invoiceid;
$invoice = Invoice::with(['payments', 'comments'])->where('Id', $id)->get();
//dd($invoice);
return View('collectionmodule/payment')->with(array('invoice' => $invoice));
}
public function getInvoice($id)
{
// Get invoice if authorized
$invoice = Invoice::where('invoice_number', '=', $id)->first();
$invoiceData = unserialize($invoice->invoice_data);
return view('settings.invoice', ['invoiceData' => $invoiceData, 'date' => $invoice->created_at]);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$invoice = new Invoice();
$invoice->event_id = 1;
$invoice->school_id = 1;
$invoice->payment_method = 'card';
$invoice->advisor_id = 1;
$invoice->total = 15;
$invoice->save();
Invoice::find(1)->makeKey();
$invoice = new Invoice();
$invoice->event_id = 1;
$invoice->school_id = 1;
$invoice->payment_method = 'card';
$invoice->advisor_id = 2;
$invoice->total = 15;
$invoice->save();
Invoice::find(2)->makeKey();
}
public function postRejectinvoice(Request $request)
{
$approve_id = Input::get('invoice_reject_id');
$post = Input::get();
$i = Invoice::where('Id', $approve_id)->update(array('RejectedwithComments' => $post['reject_comment'], 'Status' => $post['reject_status']));
if ($i > 0) {
$request->session()->flash('alert-success', 'Updated Success!');
return redirect('home2');
}
}
public function downloadPDF($id, Request $request)
{
$invoice = Invoice::find($id);
if (is_null($invoice)) {
return response()->view('errors.404', [], 404);
}
$items = json_decode($invoice->list_items);
$pdf = \PDF::loadView('invoice.pdf', compact(['invoice', 'items']));
return $pdf->download();
}
/**
* 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');
}
public function edit($UserID, $ReturnTo = '')
{
$objUser = \App\User::find($UserID);
if (!$this->objLoggedInUser->HasPermission("View/{$objUser->role}")) {
abort('404');
}
$tInvoices = \App\Invoice::perminvoices($this->objLoggedInUser)->where('user_id', $UserID)->get();
View::share('objUser', $objUser);
View::share('tInvoices', $tInvoices);
View::share('ReturnTo', $ReturnTo);
return view('admin.users.edit');
}
public function complete(CompleteRegistrationRequest $request)
{
// if no invoice number, create one
$invoice = new Invoice();
$invoice->advisor_id = Session::get('advisor')->id;
$invoice->event_id = Session::get('event')->id;
$invoice->school_id = Session::get('school')->id;
$invoice->total = Session::get('advisor')->total();
$invoice->payment_method = $request->input('payment_method');
$invoice->makeKey();
$invoice->save();
// set advisor as complete
Session::get('advisor')->invoice_id = $invoice->id;
Session::get('advisor')->save();
// set all attendees as complete
foreach (Session::get('advisor')->attendees as $attendee) {
$attendee->update(['invoice_id' => $invoice->id]);
}
// send email
Session::get('advisor')->sendConfirmationEmail();
return redirect('/event/' . Session::get('event')->slug . '/step/5');
}
/**
* Processes the invoice and charges the advisor's card.
*/
public function processPayment(Request $request, $event_slug, $key)
{
try {
// get invoice
$invoice = Invoice::where('key', $key)->first();
// load stripe
$stripe = new StripeBilling();
// charge account
$response = $stripe->charge(['email' => $request->input('stripeEmail'), 'token' => $request->input('stripeToken'), 'amount' => $invoice->total, 'receipt_email' => $request->input('stripeEmail')]);
// update invoice
$invoice->update(['stripeToken' => $request->input('stripeToken'), 'stripeEmail' => $request->input('stripeEmail'), 'received_at' => \Carbon\Carbon::now()->toDateTimeString()]);
} catch (\Exception $e) {
throw new Exception("Error Processing Payment");
}
return redirect('/event/' . $event_slug . '/invoice/' . $key . '/payment/received');
}
public function post(Request $req)
{
$ids = $req->invoice;
foreach ($ids as $id) {
$invoice = Invoice::find($id);
$invoice->status = "confirm";
$invoice->save();
$orders = $invoice->Cart->Product;
foreach ($orders as $order) {
$product = Product::find($order->pro_id);
$product->quanlity -= $order->quanlity;
$product->save();
}
}
return redirect('admin/checkpayment');
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function getIndex($dealid)
{
$id = $dealid;
$invoicedata = Deal::where('Id', $id)->get();
// dd($invoicedata);
foreach ($invoicedata as $dat) {
# code...
$evname = $dat['Eventname'];
}
$categories = Event::where('event', $evname)->get();
foreach ($categories as $category) {
$EventDate = $category['date'];
}
$employee = Employee::all();
$invoice = Invoice::all();
return View('createinvoice')->with(array('categories' => $categories, 'employee' => $employee, 'invoice' => $invoice, 'invoicedata' => $invoicedata, 'EventDate' => $EventDate));
}
/**
* 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);
}
public function invoice($id)
{
$Invoice = Invoice::find($id);
$img_logo = public_path() . '\\assets\\img\\logo_cotizacion.jpg';
$route_css = public_path() . '\\assets\\css\\style.css';
/*
$img_logo = url() .'/assets/img/logo_cotizacion.jpg';
$route_css = url() .'/assets/css/style.css';
*/
//$data = $this->getData();
//$date = date('Y-m-d');
//$invoice = "2222";
//$view = \View::make('report.invoice', compact('data', 'date', 'invoice'))->render();
$view = \View::make('report.invoice', compact('Invoice', 'img_logo', 'route_css'))->render();
$pdf = \App::make('dompdf.wrapper');
$pdf->loadHTML($view);
return $pdf->stream();
return $view;
}
/**
* 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);
}
}
}
public function index()
{
$tUpcomingVacations = \App\VacationRequest::upcomingvacations()->get();
$tUpcomingHolidays = \App\VacationRequest::upcomingholidays()->get();
$tVacationRequests = \App\VacationRequest::requests()->get();
$tNewInvoices = \App\Invoice::perminvoices($this->objLoggedInUser)->new()->get();
$tActiveGalleryImages = \App\GalleryImage::all();
$tAllClients = \App\User::clients()->get();
$BlogCount = \App\BlogPost::count();
$tNewClients = \App\User::newclients()->get();
View::share('tUpcomingVacations', $tUpcomingVacations);
View::share('tUpcomingHolidays', $tUpcomingHolidays);
View::share('tVacationRequests', $tVacationRequests);
View::share('tNewInvoices', $tNewInvoices);
View::share('tActiveGalleryImages', $tActiveGalleryImages);
View::share('tAllClients', $tAllClients);
View::share('BlogCount', $BlogCount);
View::share('tNewClients', $tNewClients);
return view('admin.index');
}
public function postEditinvoice(Request $request)
{
$updateinvoice = Input::get('updateinvoice');
$purpose = Input::get('purpose');
if ($purpose == 'annual') {
$post = Input::get();
$i = Invoice::where('Id', $updateinvoice)->update(array('Particulars' => $post['purpose'], 'CientAddress' => $post['client_address'], 'ClientName' => $post['client_name'], 'ClientEmail' => $post['client_email'], 'RepresentativeNo' => $post['rep_id'], 'InvoiceDate' => $post['invoice_date'], 'DueDate' => $post['due_date'], 'AnnualSerialNo' => $post['s_no_anuual1'], 'AnnualText' => $post['anuual_text'], 'AnnualCurrencyType' => $post['annual_currency1'], 'AnnualAmount' => $post['annual_amount1'], 'SerialNo' => $post['s_no'], 'EventName' => $post['event_name'], 'CurrencyType' => $post['currency_type'], 'Amount' => $post['amount'], 'GrandTotal' => $post['grand_total'], 'AmountInWords' => $post['amount_in_words'], 'PaymentTerms' => $post['payment_interms'], 'ServiceTax' => $post['service_tax'], 'Invoice_status' => 'Attended with Modification', 'ServiceTaxAmount' => $post['service_tax_amount']));
if ($i > 0) {
$request->session()->flash('alert-success', 'Updated Success!');
return redirect('home1');
}
}
if ($purpose == 'single') {
$post = Input::get();
$i = Invoice::where('Id', $updateinvoice)->update(array('Particulars' => $post['purpose'], 'CientAddress' => $post['client_address'], 'ClientName' => $post['client_name'], 'ClientEmail' => $post['client_email'], 'RepresentativeNo' => $post['rep_id'], 'InvoiceDate' => $post['invoice_date'], 'DueDate' => $post['due_date'], 'SerialNo' => $post['s_no'], 'EventName' => $post['event_name'], 'CurrencyType' => $post['currency_type'], 'Amount' => $post['amount'], 'ServiceTax' => $post['service_tax'], 'ServiceTaxAmount' => $post['service_tax_amount'], 'GrandTotal' => $post['grand_total'], 'AmountInWords' => $post['amount_in_words'], 'Invoice_status' => 'Attended with Modification', 'PaymentTerms' => $post['payment_interms']));
if ($i > 0) {
$request->session()->flash('alert-success', 'Updated Success!');
return redirect('home1');
}
}
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$detalle = Invoice::find($id)->details();
$detalle->delete();
Invoice::findOrFail($id)->delete();
//Invoice::findOrFail($id)->delete();
Flash::error('Factura eliminada.');
return redirect()->route('facturas.index');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$invoice = Invoice::findOrFail($id);
$client_id = $invoice->client_id;
$invoice->delete();
return redirect('clients/' . $client_id);
}
public function search($type, $value)
{
return Invoice::where($type, '=', $value)->first();
}
public function postEditinvoice(Request $request)
{
$evname = Input::get('event_name');
$result = explode('|', $evname, 2);
$evcode = trim($result[0]);
$eventname = trim($result[1]);
$repnamecode = Input::get('rep_id');
$result = explode('|', $repnamecode, 2);
$empid = trim($result[0]);
$empname = trim($result[1]);
$updateinvoice = Input::get('updateinvoice');
$purpose = Input::get('purpose');
if ($purpose == 'annual') {
$post = Input::get();
$i = Invoice::where('Id', $updateinvoice)->update(array('Particulars' => $post['purpose'], 'CientAddress' => $post['client_address'], 'ClientName' => $post['client_name'], 'ClientEmail' => $post['client_email'], 'Companyname' => $post['companyname'], 'RepresentativeNo' => $empid, 'Repname' => $empname, 'InvoiceDate' => $post['invoice_date'], 'DueDate' => $post['due_date'], 'AnnualSerialNo' => $post['s_no_anuual1'], 'AnnualText' => $post['anuual_text'], 'AnnualCurrencyType' => $post['annual_currency1'], 'AnnualAmount' => $post['annual_amount1'], 'SerialNo' => $post['s_no'], 'Eventcode' => $evcode, 'EventName' => $eventname, 'CurrencyType' => $post['currency_type'], 'Amount' => $post['amount'], 'GrandTotal' => $post['grand_total'], 'AmountInWords' => $post['amount_in_words'], 'PaymentTerms' => $post['payment_interms'], 'ServiceTax' => $post['service_tax'], 'swachtax' => $post['swachtax'], 'swachtaxamount' => $post['swachtaxamount'], 'subtotalb' => $post['subtotalb'], 'Invoice_status' => 'Attended with Modification', 'Status' => 'NULL', 'ServiceTaxAmount' => $post['service_tax_amount']));
if ($i > 0) {
$request->session()->flash('alert-success', 'Updated Success!');
return redirect('executor/home');
}
}
if ($purpose == 'single') {
$post = Input::get();
$i = Invoice::where('Id', $updateinvoice)->update(array('Particulars' => $post['purpose'], 'CientAddress' => $post['client_address'], 'ClientName' => $post['client_name'], 'ClientEmail' => $post['client_email'], 'Companyname' => $post['companyname'], 'RepresentativeNo' => $empid, 'Repname' => $empname, 'InvoiceDate' => $post['invoice_date'], 'DueDate' => $post['due_date'], 'SerialNo' => $post['s_no'], 'Eventcode' => $evcode, 'EventName' => $eventname, 'CurrencyType' => $post['currency_type'], 'Amount' => $post['amount'], 'ServiceTax' => $post['service_tax'], 'ServiceTaxAmount' => $post['service_tax_amount'], 'GrandTotal' => $post['grand_total'], 'swachtax' => $post['swachtax'], 'swachtaxamount' => $post['swachtaxamount'], 'subtotalb' => $post['subtotalb'], 'AmountInWords' => $post['amount_in_words'], 'Invoice_status' => 'Attended with Modification', 'Status' => 'NULL', 'PaymentTerms' => $post['payment_interms']));
if ($i > 0) {
$request->session()->flash('alert-success', 'Updated Success!');
return redirect('executor/home');
}
}
}
/**
* Display Payment Received notification page.
*/
public function received($event_slug, $key)
{
$invoice = Invoice::where('key', $key)->first();
return view('payment.received');
}
static function getLast($count)
{
$Last = Invoice::orderBy('created_at', 'desc')->take($count)->get();
return $Last;
}
public function doInvoicePaid($id)
{
$invoice = Invoice::findOrFail($id);
$invoice->markAsPaid();
return back()->with('invoice-paid', true);
}
public function individualReportPrint($name)
{
$printview = Invoice::where('institute_code', '=', Auth::user()->institute_id)->where('student_name', '=', $name)->first();
$paidtotal = Invoice::where('institute_code', '=', Auth::user()->institute_id)->where('student_name', '=', $name)->sum('payment_ammount');
$duetotal = Invoice::where('institute_code', '=', Auth::user()->institute_id)->where('student_name', '=', $name)->sum('due_amount');
$totalamount = Invoice::where('institute_code', '=', Auth::user()->institute_id)->where('student_name', '=', $name)->sum('total_amount');
//return $duetotal;
$institute = Institute::where('institute_code', '=', Auth::user()->institute_id)->first();
$balance = Invoice::where('institute_code', '=', Auth::user()->institute_id)->where('student_name', '=', $name)->get();
//return $balance;
return view('admin.individualreportprint', ['balance' => $balance, 'print' => $printview, 'iis' => $institute, 'paid' => $paidtotal, 'due' => $duetotal, 'total' => $totalamount]);
}
