/**
* Store a newly created resource in storage via ajax.
*/
public function store(TradeRequest $request)
{
// Check authorisation and throw 404 if not
if (!Auth::user()->can('add.trade')) {
return view('errors/404');
}
if ($request->ajax()) {
return Trade::create($request->all());
}
return view('errors.404');
}
/**
* Migrate Trades
*/
public function trades()
{
echo "<h1>Migrating Trades</h1>";
DB::table('z_lookup_trades')->truncate();
DB::table('z_lookup_tasks')->truncate();
// Create initial records
$notrade = Trade::create(array('name' => 'No Trade', 'status' => '1', 'company_id' => '1', 'created_by' => '1', 'updated_by' => '1'));
$trades = zTrade::all();
$trades->each(function ($trade) {
$active_trade = '0';
if ($trade->active == "y") {
$active_trade = '1';
}
$newtrade = Trade::create(array('name' => reformatOldStr($trade->name), 'status' => $active_trade, 'company_id' => '3', 'created_by' => '1', 'updated_by' => '1'));
zLookupTrade::create(array('old' => $trade->id, 'new' => $newtrade->id));
echo "<b> {$trade->name} [{$trade->id}]->[{$newtrade->id}]</b><br>";
$tasks = zTask::where('trade_id', '=', $trade->id)->get();
foreach ($tasks as $task) {
$active_task = '0';
if ($task->active == "y") {
$active_task = '1';
}
$upcoming_task = '0';
if ($task->upcoming == "y") {
$upcoming_task = '1';
}
$newtask = Task::create(array('name' => reformatOldStr($task->name), 'code' => reformatOldStr($task->code), 'upcoming' => $upcoming_task, 'status' => $active_task, 'trade_id' => $newtrade->id, 'created_by' => '1', 'updated_by' => '1'));
zLookupTask::create(array('old' => $task->id, 'new' => $newtask->id));
echo "<b> {$task->name} [{$task->id}]->[{$newtask->id}]</b><br>";
}
echo "<br>";
});
echo "<h1>Completed</h1>";
}
