/**
* @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]);
}
}
}
}
