Another Tutorials LINK
Index.blade.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
<link href="https://fonts.googleapis.com/css?family=Nunito:200,600" rel="stylesheet">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css"> <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css">
<style>
</style>
</head>
<body>
<form action="/salesorder" method="post">
@csrf
<div class="container">
<div class="panel panel-default" style="background-color: #CCC">
<div class="panel-body">
<div class="col-sm-6"> <!-- FIRST COLUMN -->
<!--------------------------------- Customer Code -------------------------------------------->
<div class="form-group">
<label for="" class="col-sm-4 control-label">Customer</label>
<div class="col-sm-8">
<input type="text" class="form-control" id="" name="CardCode" placeholder="">
</div>
</div>
<!--------------------------------- Customer Name -------------------------------------------->
<div class="form-group">
<label for="" class="col-sm-4 control-label"> Name</label>
<div class="col-sm-8">
<input type="text" class="form-control" id="" name="CardName" placeholder="">
</div>
</div>
</div>
<div class="col-sm-6"> <!-- Second COLUMN -->
<div class="form-group">
<label for="" class="col-sm-4 control-label"> Contact Person</label>
<div class="col-sm-8">
<input type="text" class="form-control" id="" name="CntctCode" placeholder="">
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-4 control-label"> Pi No</label>
<div class="col-sm-8">
<input type="text" class="form-control" id="" name="NumAtCard" placeholder="">
</div>
</div>
</div>
<div class="col-sm-6"> <!-- Third COLUMN -->
<div class="form-group">
<label for="" class="col-sm-4 control-label"> Currency</label>
<div class="col-sm-8">
<input type="text" class="form-control" id="" name="DocCur" placeholder="">
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-4 control-label">Series </label>
<div class="col-sm-8">
<input type="text" class="form-control" id="" name="Series" placeholder="">
</div>
</div>
</div>
<div class="col-sm-6"> <!-- Four COLUMN -->
<div class="form-group">
<label for="" class="col-sm-4 control-label"> So </label>
<div class="col-sm-8">
<input type="text" class="form-control" id="" name="DocNum" placeholder="">
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-4 control-label">Date </label>
<div class="col-sm-8">
<input type="text" class="form-control" id="" name="DocDueDate" placeholder="">
</div>
</div>
</div>
<div class="col-sm-6"> <!-- Five COLUMN -->
<div class="form-group">
<label for="" class="col-sm-4 control-label"> Delivery Date </label>
<div class="col-sm-8">
<input type="text" class="form-control" id="" name="TaxDate" placeholder="">
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-4 control-label">Marketing </label>
<div class="col-sm-8">
<input type="text" class="form-control" id="" name="SlpCode" placeholder="">
</div>
</div>
</div>
<div class="col-sm-6"> <!-- Six COLUMN -->
<div class="form-group">
<label for="" class="col-sm-4 control-label"> Usd Rate </label>
<div class="col-sm-8">
<input type="text" class="form-control" id="" name="DocRate" placeholder="">
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-4 control-label">Owner </label>
<div class="col-sm-8">
<input type="text" class="form-control" id="" name="Owner" placeholder="">
</div>
</div>
</div>
</div>
</div><!-- END PANEL -->
</div>
<h1>Sales Order</h1>
<table class="table table-light " id="myTable">
<thead class="thead-light">
<tr>
<th>#</th>
<th>Item No</th>
<th>Qty</th>
</tr>
</thead>
<tbody>
<tr>
<td></td>
<td><input type="text" name="itemno[]" id=""></td>
<td><input type="text" name="Quantity[]" id=""></td>
<td><input type="text" name="Amount[]" id=""></td>
<td><input type="text" name="Color[]" id=""></td>
<td><input type="text" name="Style[]" id=""></td>
<td><input type="text" name="ItemRef[]" id=""></td>
</tr>
<tr>
<td></td>
<td><input type="text" name="itemno[]" id=""></td>
<td><input type="text" name="Quantity[]" id=""></td>
<td><input type="text" name="Amount[]" id=""></td>
<td><input type="text" name="Color[]" id=""></td>
<td><input type="text" name="Style[]" id=""></td>
<td><input type="text" name="ItemRef[]" id=""></td>
</tr>
</tbody>
<tfoot>
<tr>
<th>#</th>
</tr>
</tfoot>
</table>
<button class="btn-primary">Save</button>
</form>
</div>
</body>
<script>
</script>
</html>
SalesController.php
<?php
namespace App\Http\Controllers;
use App\SalesOrder;
use App\SalesItem;
use Illuminate\Http\Request;
class SalesOrderController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
//
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
//
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
//
$sales = new SalesOrder();
$sales->CardCode = $request->CardCode;
$sales->CardName = $request->CardName;
$sales->CntctCode = $request->CntctCode;
$sales->NumAtCard = $request->NumAtCard;
$sales->DocCur = $request->DocCur;
$sales->DocRate = $request->DocRate;
$sales->Series = $request->Series;
$sales->DocNum = $request->DocNum;
$sales->DocDueDate = $request->DocDueDate;
$sales->TaxDate = $request->TaxDate;
$sales->SlpCode = $request->SlpCode;
$sales->Owner = $request->Owner;
$id = $sales->save();
foreach ($request->itemno as $key => $val){
$data = array("ItemCode"=>$request->itemno[$key],"Quantity"=>$request->Quantity[$key],"Amount"=>$request->Amount[$key],"Color"=>$request->Color[$key],"Style"=>$request->Style[$key],"ItemRef"=>$request->ItemRef[$key]);
SalesItem::insert( $data);
}
}
/**
* Display the specified resource.
*
* @param \App\SalesOrder $salesOrder
* @return \Illuminate\Http\Response
*/
public function show(SalesOrder $salesOrder)
{
//
}
/**
* Show the form for editing the specified resource.
*
* @param \App\SalesOrder $salesOrder
* @return \Illuminate\Http\Response
*/
public function edit(SalesOrder $salesOrder)
{
//
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param \App\SalesOrder $salesOrder
* @return \Illuminate\Http\Response
*/
public function update(Request $request, SalesOrder $salesOrder)
{
//
}
/**
* Remove the specified resource from storage.
*
* @param \App\SalesOrder $salesOrder
* @return \Illuminate\Http\Response
*/
public function destroy(SalesOrder $salesOrder)
{
//
}
}
SalesItemController.php
<?php
namespace App\Http\Controllers;
use App\SalesItem;
use Illuminate\Http\Request;
class SalesItemController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
//
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
//
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
//
}
/**
* Display the specified resource.
*
* @param \App\SalesItem $salesItem
* @return \Illuminate\Http\Response
*/
public function show(SalesItem $salesItem)
{
//
}
/**
* Show the form for editing the specified resource.
*
* @param \App\SalesItem $salesItem
* @return \Illuminate\Http\Response
*/
public function edit(SalesItem $salesItem)
{
//
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param \App\SalesItem $salesItem
* @return \Illuminate\Http\Response
*/
public function update(Request $request, SalesItem $salesItem)
{
//
}
/**
* Remove the specified resource from storage.
*
* @param \App\SalesItem $salesItem
* @return \Illuminate\Http\Response
*/
public function destroy(SalesItem $salesItem)
{
//
}
}
SalesOrderController
<?php
namespace App\Http\Controllers;
use App\SalesOrder;
use App\SalesItem;
use Illuminate\Http\Request;
class SalesOrderController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
//
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
//
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
//
$sales = new SalesOrder();
$sales->CardCode = $request->CardCode;
$sales->CardName = $request->CardName;
$sales->CntctCode = $request->CntctCode;
$sales->NumAtCard = $request->NumAtCard;
$sales->DocCur = $request->DocCur;
$sales->DocRate = $request->DocRate;
$sales->Series = $request->Series;
$sales->DocNum = $request->DocNum;
$sales->DocDueDate = $request->DocDueDate;
$sales->TaxDate = $request->TaxDate;
$sales->SlpCode = $request->SlpCode;
$sales->Owner = $request->Owner;
$id = $sales->save();
foreach ($request->itemno as $key => $val){
$data = array("ItemCode"=>$request->itemno[$key],"Quantity"=>$request->Quantity[$key],"Amount"=>$request->Amount[$key],"Color"=>$request->Color[$key],"Style"=>$request->Style[$key],"ItemRef"=>$request->ItemRef[$key]);
SalesItem::insert( $data);
}
}
/**
* Display the specified resource.
*
* @param \App\SalesOrder $salesOrder
* @return \Illuminate\Http\Response
*/
public function show(SalesOrder $salesOrder)
{
//
}
/**
* Show the form for editing the specified resource.
*
* @param \App\SalesOrder $salesOrder
* @return \Illuminate\Http\Response
*/
public function edit(SalesOrder $salesOrder)
{
//
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param \App\SalesOrder $salesOrder
* @return \Illuminate\Http\Response
*/
public function update(Request $request, SalesOrder $salesOrder)
{
//
}
/**
* Remove the specified resource from storage.
*
* @param \App\SalesOrder $salesOrder
* @return \Illuminate\Http\Response
*/
public function destroy(SalesOrder $salesOrder)
{
//
}
}
SalesOrder Migration File
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateSalesOrdersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('sales_orders', function (Blueprint $table) {
$table->id();
$table->string('CardCode');
$table->string('CardName');
$table->string('CntctCode');
$table->string('NumAtCard');
$table->string('DocCur');
$table->string('DocRate');
$table->string('Series');
$table->string('DocNum');
$table->date('DocDueDate');
$table->date('TaxDate');
$table->timestamps();
$table->string('SlpCode');
$table->string('Owner');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('sales_orders');
}
}
SalesItem Migration File
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateSalesItemsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('sales_items', function (Blueprint $table) {
$table->id();
$table->string('ItemCode');
$table->string('Quantity');
$table->string('Amount');
$table->string('Color');
$table->string('Style');
$table->string('ItemRef');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('sales_items');
}
}
SalesItem Model
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class SalesItem extends Model
{
//
protected $table = "sales_items";
protected $fillable = ['ItemCode','Quantity','Amount','Color','Style','ItemRef'];
}
SalesOrder model
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class SalesOrder extends Model
{
//
protected $table = "sales_orders";
protected $fillable = ['CardCode','CardName','CntctCode','NumAtCard','DocCur','DocRate','Series','DocNum','DocDueDate','TaxDate','SlpCode','Owner'];
}
OLEETECH 