@douglasakula thank you for your response.
this is my migration for sales_details. dont consider the type, location, area, booth.
Schema::create('sales_details', function (Blueprint $table) {
$table->increments('id');
$table->string('sales_id');
$table->date('date');
$table->string('time');
$table->string('customer_id');
$table->string('customer_name');
$table->string('customer_type');
$table->string('customer_location');
$table->string('customer_area');
$table->string('customer_booth');
$table->string('emp');
$table->double('no_of_litre');
$table->double('rate_per_litre');
$table->double('total');
$table->longText('note');
$table->timestamps();
});
and iam not using any relationships.
this is my Sales_details model
class Sales_details extends Model
{
protected $dates = [
'created_at',
'updated_at',
'date'
];
public function getFormattedDateAttribute()
{
return $this->date->format('d-m-Y');
}
protected $appends = ['formatted_date'];
}
and i have a nav bar view sales entry. if i click that.
it moves to index method in sales_details controller
public function index()
{
$all=Sales_details::orderBy('created_at','desc')->get();
$sales = Sales_details::orderBy('created_at','desc')->paginate(100);
if($sales->lastPage() == $sales->currentPage())
{
View::share('grandTotal', $all->sum('no_of_litre'));
View::share('grandTotal1', $all->sum('total'));
}
return view('Sales_details.view', [
'sales' => $sales
]);
}
in this index controller what i did is jest fetching all records and sotred in that $all variable for total. and for pagination wise total i gave $sales.
this what i have done. no relationships nothing i used.
just inserted the record in the sales_table and the view it.
my client expecting the view in the above mentioned format thats it. .
refer:
https://imgur.com/a/uiLblRT
but i kept is
refer
https://imgur.com/a/3b1jd5k --- in this format i kept
Kindly need help
