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();
}
}
}
