$contract_type=DB::table('leads_contract_type')->where('name','=',$value['Contract Type'])->first(); $client_type=DB::table('leads_client_type')->where('name','=',$value['Client Type'])->first(); $category_id=DB::table('services_category')->where('name','=',$value['Service Category'])->first(); $cluster_id=DB::table('services_clusters')->where('name','=',$value['Service Cluster'])->first(); $date = date('Y-m-d H:i:s'); $services= new Services (); $services->service_code=$value['Item No.']; $services->name=$value['Service Type']; $services->contract_type=$contract_type->id; $services->client_type=$client_type->id; $services->category_id=$category_id->id; $services->cluster_id=$cluster_id->id; $services->author_id=1; $services->status=1; $services->created_at=$date; $services->updated_at=$date; $services->save();