get('t/get-week', ['uses' => 'ManskedController@testWeeks']); get('t/mansked/week/{weekno}', function ($weekno) { $mansked = App\Models\Manskedhdr::with('manskeddays')->select('id')->where('weekno', $weekno)->get()->first(); return $mansked->manskeddays->keyBy('date'); $manday = new App\Models\Manskedday(); return $manday->where('id', 'B0092A7B666611E596ECDA40B3C0AA12')->get(); }); get('t/manday-dtl', function () { $manday = new App\Models\Manskedday(); $manday->date = '20015-10-07'; $manday->manskedid = 'A7AECDD2666611E596ECDA40B3C0AA12'; $manday->id = $manday->get_uid(); $manday->save(); $x = new App\Models\Manskeddtl(); $x->daytype = 0; $x->id = $x->get_uid(); $manday->manskeddtls()->save($x); return dd($manday); }); /*************************************************************************************/ /******************** Data Manipulation for Migrations *****************************/ /*************************************************************************************/ get('compcat-expense', function () { $compcats = App\Models\Compcat::all(); foreach ($compcats as $compcat) { $expense = App\Models\Expense::where('code', 'LIKE', '%' . $compcat->code . '%')->get()->first(); if (empty($expense)) { echo 'empty<br>'; } else { echo $expense->id . '<br>'; $compcat->expenseid = $expense->id;