public function fix()
{
$recipes = Recipe::orderBy('category')->get();
foreach ($recipes as $recipe) {
$recipe->category = ucwords(strtolower(trim($recipe->category)));
$recipe->name = trim($recipe->name);
$recipe->author = trim($recipe->author);
$recipe->category = preg_replace('/^Appetizers/i', 'Appetizer', $recipe->category);
$recipe->category = preg_replace('/^Breakfast.*?/i', 'Breakfast', $recipe->category);
$recipe->category = preg_replace('/^Cake.*?/i', 'Cake', $recipe->category);
$recipe->category = preg_replace('/^Cdake.*?/i', 'Cake', $recipe->category);
$recipe->category = preg_replace('/^Candies.*?/i', 'Candy', $recipe->category);
$recipe->category = preg_replace('/^Deserts.*?/i', 'Dessert', $recipe->category);
$recipe->category = preg_replace('/^Dessert.*?/i', 'Dessert', $recipe->category);
$recipe->category = preg_replace('/^Dip.*?/i', 'Dip', $recipe->category);
$recipe->category = preg_replace('/^Meat.*?/i', 'Meat', $recipe->category);
$recipe->category = preg_replace('/^Mis.*?s.*?/i', 'Miscellaneous', $recipe->category);
$recipe->category = preg_replace('/^Picckles.*?/i', 'Pickles', $recipe->category);
$recipe->category = preg_replace('/^Pie.*?/i', 'Pie', $recipe->category);
$recipe->category = preg_replace('/^Salad.*?/i', 'Salad', $recipe->category);
$recipe->category = preg_replace('/^Sandwitches.*?/i', 'Sandwich', $recipe->category);
$recipe->category = preg_replace('/^Sandwich.*?/i', 'Sandwich', $recipe->category);
$recipe->category = preg_replace('/^Sauce.*?/i', 'Sauce', $recipe->category);
$recipe->category = preg_replace('/^Sea.*?food.*?/i', 'Seafood', $recipe->category);
$recipe->category = preg_replace('/^Vegetable.*?/i', 'Vegetable', $recipe->category);
$recipe->category = preg_replace('/^Vegetales.*?/i', 'Vegetable', $recipe->category);
$recipe->name = preg_replace('/^Appetizer.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Beverage.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Bread.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Breakfast.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Cake.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Candy.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Cobbler.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Cookies.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Cupcake.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Dessert.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Dip.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Entree.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Frosting.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Ice Cream.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Miscellaneous.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Pastery.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Pickle.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Pies.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Salad.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Sandwich.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Sauce.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Sea.*?food.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Soup.*?-\\s+/i', '', $recipe->name);
$recipe->name = preg_replace('/^Vegetable.*?-\\s+/i', '', $recipe->name);
$recipe->author = preg_replace("/[\\/\\']/", '', $recipe->author);
$recipe->author = preg_replace('/Fay.s|Faye.s|Faye Martin Thompson/i', 'Faye Thompson', $recipe->author);
$recipe->author = preg_replace('/Mrs. John Collier/i', 'Alice Collier', $recipe->author);
$recipe->author = preg_replace('/Unknown/i', '', $recipe->author);
if (preg_match('/McCutchen/i', $recipe->author, $match)) {
$recipe->author = "Jeannean McCutchen";
}
if (preg_match('/^Faye$/i', $recipe->author, $match)) {
$recipe->author = "Faye Thompson";
}
if (preg_match('/Mary Alice/i', $recipe->author, $match)) {
$recipe->author = "Mary Alice McComb";
}
$recipe->save();
}
$recipes = Recipe::sortable()->paginate(env('RECIPE_PAGINATION_MAX'));
return view('recipes.index')->with('recipes', $recipes);
}
