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;
