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('/'); } }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(InvoiceRequest $request) { $Invoice = new Invoice($request->all()); $Invoice->save(); return redirect()->route('facturas.edit', $Invoice->id); //Flash::success('Se ha creado a ' . $Client->nombre . ', como cliente.'); //return redirect()->route('clientes.index'); }
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 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')); }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store($client_id, Request $request) { $invoice = new Invoice(); $client = Client::findOrFail($client_id); $invoice_count = $client->invoices()->count(); $invoice->client_specific_id = $invoice_count + 1; $invoice->client_id = $client_id; $invoice->user_id = Auth::user()->id; $invoice->issue_date = $request->issue_date; $invoice->amount = $request->amount; $invoice->due_date = $request->due_date; $invoice->is_paid = 0; $invoice->save(); return redirect('clients/' . $client_id); }
/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(Request $request) { $validator = Validator::make(Input::all(), Invoice::$rules); if ($validator->fails()) { return Redirect::back()->withInput()->withErrors($validator->messages()); } $invoice = new Invoice(); $invoice->invoice_code = Input::get("invoice_code"); $invoice->customer_name = Input::get("customer_name"); $invoice->customer_number = Input::get("customer_number"); $invoice->description = Input::get("description"); $invoice->total_net = "0"; $invoice->total_gross = "0"; $invoice->total_vat = "0"; $invoice->save(); return Redirect::route("invoices.index"); }
/** * 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 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'); }
public function postInvoice(Request $request) { $dealid = Input::get('dealid'); $variable = Input::get('purpose'); $evname = Input::get('event_name'); $result = explode('|', $evname, 2); $evcode = trim($result[0]); $eventname = trim($result[1]); $inv = 'IDE'; $nameofinvoice = 'PROFORMA INVOICE'; $dateValue = date('d-m-Y'); $time = strtotime($dateValue); $year = date("Y", $time); $count = Invoice::all()->count(); $counti = str_pad($count, 3, '0', STR_PAD_LEFT); $invoicecode = $inv . '-' . '' . $evcode . '-' . '' . $year . $counti; $varr = 'NULL'; $st = 'Invoice Created'; $dealstatus = '0'; $repnamecode = Input::get('rep_id'); $result = explode('|', $repnamecode, 2); $empid = trim($result[0]); $empname = trim($result[1]); // dd($empname); $ydate = date('Y-m-d', strtotime("-1 days")); // dd($ydate); if (Input::get('currency_type') != 'INR') { $exchnagerate = $this->getExchangex(Input::get('amount'), Input::get('currency_type'), $ydate); } else { $exchnagerate = Input::get('amount'); } if ($variable == 'annual') { $c = new Invoice(); $c->Particulars = Input::get('purpose'); $c->CientAddress = Input::get('client_address'); $c->ClientName = Input::get('client_name'); $c->Companyname = Input::get('companyname'); $c->ClientEmail = Input::get('client_email'); $c->RepresentativeNo = $empid; $c->Repname = $empname; $c->InvoiceDate = Input::get('invoice_date'); $c->DueDate = Input::get('due_date'); $c->AnnualSerialNo = Input::get('s_no_anuual1'); $c->AnnualText = Input::get('anuual_text'); $c->AnnualCurrencyType = Input::get('annual_currency1'); $c->AnnualAmount = Input::get('annual_amount1'); $c->SerialNo = Input::get('s_no'); $c->Eventcode = Input::get('eventcode'); $c->EventName = $eventname; $c->CurrencyType = Input::get('currency_type'); $c->Amount = Input::get('amount'); $c->Rcvalue = $exchnagerate; $c->GrandTotal = Input::get('grand_total'); $c->Subtotal = Input::get('sub_total'); $c->AmountInWords = Input::get('amount_in_words'); $c->PaymentTerms = Input::get('payment_interms'); $c->ServiceTax = Input::get('service_tax'); $c->ServiceTaxAmount = Input::get('service_tax_amount'); $c->swachtax = Input::get('swachtax'); $c->swachtaxamount = Input::get('swachtaxamount'); $c->subtotalb = Input::get('subtotalb'); $c->Status = $varr; $c->InvoiceCode = $invoicecode; $c->Nameofinvoice = $nameofinvoice; $c->dealid = $dealid; $c->save(); // you had skipped the parenthesis in your code. $insertedId = $c->Id; $invoicedata = Invoice::where('Id', $insertedId)->get(); foreach ($invoicedata as $in) { $inv = $in->InvoiceCode; } $html22 = View('pdfgenerate')->with(array('invoicedata' => $invoicedata))->render(); $html1 = "<h1>adsfadsfasdf</h1>"; 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); $htmltosend = $html2pdf->Output('', 'S'); $i = 'Invoice_'; $b = $inv; $h = '_Generated'; $subject = $i . $b . $h; Mail::send('emails.test', ['Invoice' => 'hgff'], function ($message) use($subject, $htmltosend) { // note: if you don't set this, it will use the defaults from config/mail.php $message->from('*****@*****.**', 'Jeevan'); $message->to('*****@*****.**', 'Harshitha')->subject($subject)->attachData($htmltosend, 'invoice.pdf', array('mime' => 'application/pdf', 'Content-Disposition' => 'attachment')); }); $request->session()->flash('alert-success', 'Invoice was successful added!'); return redirect('executor/dealsclosed'); } if ($variable == 'single') { $c = new Invoice(); $c->Particulars = Input::get('purpose'); $c->CientAddress = Input::get('client_address'); $c->ClientName = Input::get('client_name'); $c->Companyname = Input::get('companyname'); $c->ClientEmail = Input::get('client_email'); $c->RepresentativeNo = $empid; $c->Repname = $empname; $c->InvoiceDate = Input::get('invoice_date'); $c->DueDate = Input::get('due_date'); $c->SerialNo = Input::get('s_no'); $c->Eventcode = Input::get('eventcode'); $c->EventName = $eventname; $c->CurrencyType = Input::get('currency_type'); $c->Amount = Input::get('amount'); $c->Rcvalue = $exchnagerate; $c->ServiceTax = Input::get('service_tax'); $c->ServiceTaxAmount = Input::get('service_tax_amount'); $c->GrandTotal = Input::get('grand_total'); $c->Subtotal = Input::get('sub_total'); $c->AmountInWords = Input::get('amount_in_words'); $c->PaymentTerms = Input::get('payment_interms'); $c->swachtax = Input::get('swachtax'); $c->swachtaxamount = Input::get('swachtaxamount'); $c->subtotalb = Input::get('subtotalb'); $c->InvoiceCode = $invoicecode; $c->Nameofinvoice = $nameofinvoice; $c->dealid = $dealid; $c->Status = $varr; $c->save(); // you had skipped the parenthesis in your code. $insertedId = $c->Id; // dd($insertedId); $invoicedata = Invoice::where('Id', $insertedId)->get(); // dd($invoicedata->InvoiceCode); foreach ($invoicedata as $in) { $inv = $in->InvoiceCode; } // $inv=$invoicedata->InvoiceCode; // dd($inv); $i = Deal::where('Id', $dealid)->update(array('Status' => $dealstatus)); $html22 = View('pdfgenerate')->with(array('invoicedata' => $invoicedata))->render(); $html1 = "<h1>adsfadsfasdf</h1>"; 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); $htmltosend = $html2pdf->Output('', 'S'); $i = 'Invoice_'; $b = $inv; $h = '_Generated'; $subject = $i . $b . $h; Mail::send('emails.test', ['Invoice' => 'hgff'], function ($message) use($subject, $htmltosend) { // note: if you don't set this, it will use the defaults from config/mail.php $message->from('*****@*****.**', 'Jeevan'); $message->to('*****@*****.**', 'Harshitha')->subject($subject)->attachData($htmltosend, 'invoice.pdf', array('mime' => 'application/pdf', 'Content-Disposition' => 'attachment')); }); $request->session()->flash('alert-success', 'Invoice was successful added!'); //return redirect()->route('/home'); return redirect('executor/dealsclosed'); } }
public function postInvoice(Request $request) { if ($request->ajax()) { $data = Input::all(); $cls = $data['class']; $sec = $data['section']; $std = $data['student']; $fee = $data['feetype']; $amn = $data['amount']; $paidamount = $data['paid']; // $dueamount=$data['due']; $date = $data['date']; $answer = $data['answer']; //return $answer; $studentid = Students::where('institute_code', '=', Auth::user()->institute_id)->where('name', '=', $std)->where('class', '=', $cls)->pluck('st_id'); //return $studentid; $classname = ClassAdd::where('institute_code', '=', Auth::user()->institute_id)->where('class_id', '=', $cls)->pluck('class_name'); $feetype = AccountFeeType::where('institute_code', '=', Auth::user()->institute_id)->where('fee_id', '=', $fee)->pluck('fee_type'); //return $feetype; $price = DB::table('tbl_ac_invoice_create')->where('institute_code', '=', Auth::user()->institute_id)->max('invoice_id'); $price++; $iid = Auth::user()->institute_id; $s = new Invoice(); $s->class_id = $cls; $s->class_name = $classname; $s->invoice_id = $price; $s->student_name = $std; $s->student_id = $studentid; $s->fee_id = $fee; $s->fee_type = $feetype; $s->total_amount = $amn; $s->payment_ammount = $paidamount; $s->section_id = $sec; $s->date = $date; $s->institute_code = $iid; $s->due_amount = $answer; $s->status = 0; $s->save(); //return $insertedId; return response()->json(["message" => "created"]); } }
public static function createInvoices($session, $term_id) { try { //create new record for this table in the termly records table $invoice = new Invoice(); $invoice->table_name = 'invoices_' . $session . '_' . $term_id; $invoice->session = $session; $invoice->term = $term_id; $invoice->save(); \Schema::create('invoices_' . $session . '_' . $term_id, function (Blueprint $table) { $table->integer('student_id'); $table->string('fee_schedule_code'); $table->string('invoice_number'); $table->double('amount', 15, 2); $table->double('discount', 15, 2); $table->double('balance', 15, 2); $table->double('total', 15, 2); $table->json('exempted_fee_elements')->nullable(); $table->integer('status_id')->default(4); $table->primary(array('student_id', 'fee_schedule_code')); $table->softDeletes(); $table->timestamps(); }); } catch (\Illuminate\Database\QueryException $e) { $errorCode = $e->errorInfo[1]; if ($errorCode == 1050) { $error_msg[] = 'Invoices table for chosen session and term already exists.'; // session()->flash('flash_message', 'Invoices table for chosen session and term already exists.'); // return \Redirect::back()->withInput(); } } }