/**
* Store a newly created resource in storage.
*
* @return \Illuminate\Http\Response
*/
public function store(SiteRequest $request)
{
$site_request = $request->except('tabs', 'supervisors');
// Create Site
$newSite = Site::create($site_request);
if ($request->get('supervisors')) {
$newSite->supervisors()->sync($request->get('supervisors'));
}
Toastr::success("Created new site", "Success");
return view('site.list');
}
/**
* Migrate Sites
*/
public function sites()
{
echo "<h1>Migrating Sites</h1>";
$jobs = zJob::all();
$jobs->each(function ($job) {
echo "<b>" . $job->name . "</b> ({$job->supervisor})<br>";
$active = '0';
if ($job->active == "y") {
$active = '1';
}
if ($job->active == "u") {
$active = '-1';
}
$newSite = Site::create(array('name' => reformatOldStr($job->name), 'address' => $job->address, 'suburb' => $job->suburb, 'state' => 'NSW', 'postcode' => '????', 'code' => $job->jobnum, 'completed' => $job->completed, 'notes' => $job->notes, 'status' => $active, 'client_id' => '1', 'created_by' => '1', 'updated_by' => '1'));
// Add supers to created site
if ($job->supervisor) {
$user = User::where('username', '=', $job->supervisor)->get();
//dd ($user[0]->username);
DB::table('supervisor_site')->insert(array('user_id' => $user[0]->id, 'site_id' => $newSite->id));
}
});
echo "<h1>Completed</h1>";
}
