/** * @return array */ public function rules() { $nameRule = 'required|between:1,100|uniqueObjectForUser:categories,name'; if (Category::find(Input::get('id'))) { $nameRule = 'required|between:1,100|uniqueObjectForUser:categories,name,' . intval(Input::get('id')); } return ['name' => $nameRule]; }
public function moveBackEntriesForCategoriesInJoinedTable() { $set = DB::table('category_transaction_journal')->get(); foreach ($set as $entry) { $category = Category::find($entry->category_id); if ($category) { $component = Component::where('class', 'Category')->where('name', $category->name)->where('user_id', $category->user_id)->first(); if ($component) { DB::table('component_transaction_journal')->insert(['component_id' => $component->id, 'transaction_journal_id' => $entry->transaction_journal_id]); } } } }
private function moveBackEntriesForCategoriesInJoinedTable() { $set = DB::table('category_transaction_journal')->get(); /** @var \stdClass $entry */ foreach ($set as $entry) { $category = Category::find($entry->category_id); if ($category) { /** @var \FireflyIII\Models\Component $component */ $component = Component::where('class', 'Category')->where('name', $category->name)->where('user_id', $category->user_id)->first(); if ($component) { DB::table('component_transaction_journal')->insert(['component_id' => $component->id, 'transaction_journal_id' => $entry->transaction_journal_id]); } } } }