Laravel Project - Update Products Stock and Invoice Item
Laravel Project - Update Products Stock and Invoice Item
Al-Mamun Sarkar
- Share On:
এই লেসনে Product এ has_sock যুক্ত করা হয়েছে। Invoice item adding এ automatic total calculate করা হয়েছে।
Source Code:
ProductsController.php:
$product->has_stock = $data['has_stock'];
ProductsStockController.php:
public function index()
{
$this->data['products'] = Product::where('has_stock', 1)->get();
return view('products.stocks', $this->data);
}
Product.php:
protected $fillable = [ 'title', 'description', 'category_id', 'cost_price', 'price', 'has_stock' ];
2020_09_22_131109_add_has_stock_on_products_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class AddHasStockOnProductsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('products', function (Blueprint $table) {
$table->boolean('has_stock')->default(1)->after('price');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('products', function (Blueprint $table) {
$table->dropColumn('has_stock');
});
}
}
products/form.blade.php:
<div class="form-group row">
<label for="name" class="col-sm-2 text-right col-form-label">Has Stock </label>
<div class="col-sm-2">
{{ Form::select('has_stock', [ '1'=> 'Yes', '0' => "No" ], NULL, [ 'class'=>'form-control', 'id' => 'group' ]) }}
</div>
</div>
purchases/invoice.blade.php
@extends('users.invoice_layout')
@section('user_content')
<div class="card shadow mb-4">
<div class="card-header py-3">
<h6 class="m-0 font-weight-bold text-primary"> Purchase Invoice Details </h6>
</div>
<div class="card-body">
<div class="row clearfix justify-content-md-center">
<div class="col-md-6">
<div class="no_padding no_margin"> <strong>Supplier:</strong> {{ $user->name }}</div>
<div class="no_padding no_margin"><strong>Email:</strong> {{ $user->email }}</div>
<div class="no_padding no_margin"><strong>Phone:</strong> {{ $user->phone }}</div>
</div>
<div class="col-md-3"></div>
<div class="col-md-3">
<div class="no_padding no_margin"><strong>Date:</strong> {{ $invoice->date }} </div>
<div class="no_padding no_margin"><strong>Challen No:</strong> {{ $invoice->challan_no }} </div>
</div>
</div>
<div class="invoice_items">
<table class="table table-borderless ">
<thead>
<th>SL</th>
<th>Product</th>
<th>Price</th>
<th>Qty</th>
<th class="text-right">Total</th>
<th class="text-right">-</th>
</thead>
<tbody>
@foreach ($invoice->items as $key => $item)
<tr>
<td> {{ $key+1 }} </td>
<td> {{ $item->product->title }} </td>
<td> {{ $item->price }} </td>
<td> {{ $item->quantity }} </td>
<td class="text-right"> {{ $item->total }} </td>
<td class="text-right">
<form
method="POST"
action=" {{ route('user.purchases.delete_item', ['id' => $user->id, 'invoice_id' => $invoice->id, 'item_id'=> $item->id]) }}
">
@csrf
@method('DELETE')
<button onclick="return confirm('Are you sure?')" type="submit" class="btn btn-danger btn-sm">
<i class="fa fa-trash"></i>
</button>
</form>
</td>
</tr>
@endforeach
</tbody>
<tr>
<th></th>
<th>
<button class="btn btn-info btn-sm" data-toggle="modal" data-target="#newProduct">
<i class="fa fa-plus "></i> Add Product
</button>
</th>
<th colspan="2" class="text-right"> Total: </th>
<th class="text-right"> {{ $totalPayable }} </th>
<th></th>
</tr>
<tr>
<th></th>
<th>
<button class="btn btn-primary btn-sm" data-toggle="modal" data-target="#newPaymentForInvoice">
<i class="fa fa-plus "></i> Add Payment
</button>
</th>
<th colspan="2" class="text-right"> Paid: </th>
<th class="text-right"> {{ $totalPaid }} </th>
<th></th>
</tr>
<tr>
<th colspan="4" class="text-right"> Due: </th>
<th class="text-right"> {{ $totalPayable - $totalPaid }} </th>
<th></th>
</tr>
</table>
</div>
</div>
</div>
{{-- Modal For Add new Product --}}
<div class="modal fade" id="newProduct" tabindex="-1" role="dialog" aria-labelledby="newProductModalLabel" aria-hidden="true">
<div class="modal-dialog" role="document">
{!! Form::open([ 'route' => ['user.purchases.add_item', ['id' => $user->id, 'invoice_id' => $invoice->id] ], 'method' => 'post' ]) !!}
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="newProductModalLabel"> Add New Product </h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<div class="form-group row">
<label for="product" class="col-sm-3 col-form-label text-right">Product <span class="text-danger">*</span> </label>
<div class="col-sm-9">
{{ Form::select('product_id', $products, NULL, [ 'class'=>'form-control', 'id' => 'product', 'required', 'placeholder' => 'Select Product' ]) }}
</div>
</div>
<div class="form-group row">
<label for="price" class="col-sm-3 col-form-label text-right">Unite Price <span class="text-danger">*</span> </label>
<div class="col-sm-9">
{{ Form::text('price', NULL, [ 'class'=>'form-control', 'id' => 'price', 'onkeyup' => 'getTotal()', 'placeholder' => 'Unite Price', 'required' ]) }}
</div>
</div>
<div class="form-group row">
<label for="quantity" class="col-sm-3 col-form-label text-right">Quantity <span class="text-danger">*</span> </label>
<div class="col-sm-9">
{{ Form::text('quantity', NULL, [ 'class'=>'form-control', 'id' => 'quantity', 'onkeyup' => 'getTotal()', 'placeholder' => 'Quantity', 'required' ]) }}
</div>
</div>
<div class="form-group row">
<label for="total" class="col-sm-3 col-form-label text-right">Total <span class="text-danger">*</span> </label>
<div class="col-sm-9">
{{ Form::text('total', NULL, [ 'class'=>'form-control', 'id' => 'total', 'placeholder' => 'Total', 'required' ]) }}
</div>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
<button type="submit" class="btn btn-primary">Submit</button>
</div>
</div>
{!! Form::close() !!}
</div>
</div>
{{-- New Receipt For Invoice --}}
<div class="modal fade" id="newPaymentForInvoice" tabindex="-1" role="dialog" aria-labelledby="newPaymentForInvoiceModalLabel" aria-hidden="true">
<div class="modal-dialog" role="document">
{!! Form::open([ 'route' => [ 'user.payments.store', [$user->id, $invoice->id] ], 'method' => 'post' ]) !!}
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="newPaymentForInvoiceModalLabel"> New Payment For This Invoice </h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<div class="form-group row">
<label for="date" class="col-sm-3 col-form-label"> Date <span class="text-danger">*</span> </label>
<div class="col-sm-9">
{{ Form::date('date', NULL, [ 'class'=>'form-control', 'id' => 'date', 'placeholder' => 'Date', 'required' ]) }}
</div>
</div>
<div class="form-group row">
<label for="amount" class="col-sm-3 col-form-label">Amount <span class="text-danger">*</span> </label>
<div class="col-sm-9">
{{ Form::text('amount', NULL, [ 'class'=>'form-control', 'id' => 'amount', 'placeholder' => 'Amount', 'required' ]) }}
</div>
</div>
<div class="form-group row">
<label for="note" class="col-sm-3 col-form-label">Note </label>
<div class="col-sm-9">
{{ Form::textarea('note', NULL, [ 'class'=>'form-control', 'id' => 'note', 'rows' => '3', 'placeholder' => 'Note' ]) }}
</div>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
<button type="submit" class="btn btn-primary">Submit</button>
</div>
</div>
{!! Form::close() !!}
</div>
</div>
<script type="text/javascript">
function getTotal() {
var price = document.getElementById("price").value;
var quantity = document.getElementById("quantity").value;
if ( price && quantity ) {
var total = price * quantity;
document.getElementById("total").value = total;
}
}
</script>
@stop
users/sales/invoice.blade.php
<div class="form-group row">
<label for="price" class="col-sm-3 col-form-label text-right">Unite Price <span class="text-danger">*</span> </label>
<div class="col-sm-9">
{{ Form::text('price', NULL, [ 'class'=>'form-control', 'id' => 'price', 'onkeyup' => 'getTotal()', 'placeholder' => 'Unite Price', 'required' ]) }}
</div>
</div>
<div class="form-group row">
<label for="quantity" class="col-sm-3 col-form-label text-right">Quantity <span class="text-danger">*</span> </label>
<div class="col-sm-9">
{{ Form::text('quantity', NULL, [ 'class'=>'form-control', 'id' => 'quantity', 'onkeyup' => 'getTotal()', 'placeholder' => 'Quantity', 'required' ]) }}
</div>
</div>
<script type="text/javascript">
function getTotal() {
var price = document.getElementById("price").value;
var quantity = document.getElementById("quantity").value;
if ( price && quantity ) {
var total = price * quantity;
document.getElementById("total").value = total;
}
}
</script>