<?php
  
  namespace App\Http\Controllers\V1\Partners;
  
  
  use App\Http\Controllers\Controller;
  use App\Http\Requests\VdmRequest;
  use Carbon\Carbon;
  use Illuminate\Support\Facades\DB;

  
  class VdmController extends Controller
  {
      public function store(VdmRequest $request)
      {

          $records = [];

          // merge two input arrays
          $cve = $request->get('cve');
          $cwe = $request->get('cwe');
  
          $merged = array_merge($cve, $cwe);
  
          foreach ($merged as $item) {
              $records[] = [
                  'asset_id' => $request->get('asset_id'),
                  'time' => Carbon::createFromTimestamp($request->get('timestamp')),
                  'value' => $item
              ];
          }
          DB::table('vdm')->insert($records);

          return response()->json(['success' => 'success'], 200);
      }

  
      public function get()
      {
          return DB::table('vdm')->select([
              'uuid',
              'time',
              'asset_id',
              'value',
          ])->paginate(20);
      }

  }