/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker\Factory::create();
$faker->addProvider(new Faker\Provider\ne_NP\Address($faker));
$faker->addProvider(new Faker\Provider\ne_NP\Internet($faker));
$faker->addProvider(new Faker\Provider\ne_NP\Person($faker));
$faker->addProvider(new Faker\Provider\ne_NP\PhoneNumber($faker));
foreach (range(1, 10) as $index) {
App\Supplier::create(['name' => $faker->company(), 'location' => $faker->cityName(), 'email' => $faker->companyEmail(), 'telephone1' => $faker->phoneNumber(), 'telephone2' => $faker->phoneNumber(), 'date_added' => $faker->dateTimeThisYear($max = 'now'), 'default_order_mode' => 'delivery', 'is_enabled' => $faker->boolean($chanceOfGettingTrue = 50)]);
}
}
</thead>
<tbody>
<?php
//$price_logs = PriceLog::where('item_id', $invoice_item->Item->id)->orderBy('created_at', 'desc')->take(3)->orderBy('price','asc')->get();
$price_logs = DB::table('price_logs AS t1')->select('t1.*')->leftJoin('price_logs AS t2', function ($join) {
$join->on('t1.supplier_id', '=', 't2.supplier_id');
$join->on('t1.created_at', '<', 't2.created_at');
})->whereNull('t2.created_at')->where('t1.item_id', '=', $invoice_item->Item->id)->get();
?>
@foreach($price_logs as $price_log)
<tr>
<td>{{ $price_log->created_at }}</td>
<?php
$supplier = App\Supplier::find($price_log->supplier_id);
?>
<td>{{ $supplier->name }}</td>
<td>{{ $supplier->payment_terms }}</td>
<td>{{ $supplier->telephone_number }}</td>
<td>{{ $supplier->email }}</td>
<td>Php {{ number_format($price_log->price, 2, '.', ',') }}</td>
<td>@if ($price_log->stock_availability === 1) Yes @else No @endif</td>
</tr>
@endforeach
</tbody>
</table>
@endforeach
<table>
<tr>
