/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('product_snapshot', function (Blueprint $table) {
$table->increments('id');
$table->integer('product_id')->default(0);
$table->integer('snapshot_id')->default(0);
$table->timestamps();
});
// rows have been stored in a comma delimited list, get them out and store in db
$snapshots = Snapshot::orderBy('created_at', 'asc')->get();
foreach ($snapshots as $snapshot) {
if ($snapshot->snapshot_products != '') {
$products = explode(',', $snapshot->snapshot_products);
if (count($products)) {
foreach ($products as $product) {
$snapshot->products()->attach($product);
}
}
}
}
}
/**
* Display a gallery of all of the snapshots
*
* @param Request $request
* @return Response
*/
public function gallery(Request $request)
{
$query = Snapshot::orderBy('created_at', 'desc');
if ($request->from_date) {
$query->where('purchase_date', '>=', date('Y-m-d', strtotime($request->from_date)));
}
if ($request->to_date) {
$query->where('purchase_date', '<=', date('Y-m-d', strtotime($request->to_date)));
}
$snapshots = $query->get();
return view('snapshots.gallery', ['snapshots' => $snapshots]);
}
