public static function nonattendees()
{
$log = '';
$yesterday = Carbon::now()->subDays(1);
$lastweek = Carbon::now()->subDays(7);
echo "<h2>Adding Non-Attendees to the Non-Logged in list (" . $lastweek->format('d/m/Y') . ' - ' . $yesterday->format('d/m/Y') . ")</h2>";
$log .= "Adding Non-Attendees to the Non-Logged in list (" . $lastweek->format('d/m/Y') . ' - ' . $yesterday->format('d/m/Y') . ")\n";
$log .= "-------------------------------------------------------------------------\n\n";
$allowedSites = Site::all()->pluck('id')->toArray();
if (Auth::check()) {
$allowedSites = Auth::user()->company->siteList('1')->pluck('id')->toArray();
}
$roster = SiteRoster::where('date', '>=', $lastweek->format('Y-m-d'))->where('date', '<=', $yesterday->format('Y-m-d'))->whereIn('site_id', $allowedSites)->orderBy('site_id')->get();
$found = false;
foreach ($roster as $rost) {
$site = Site::find($rost->site_id);
$user = User::find($rost->user_id);
$date = Carbon::createFromFormat('Y-m-d H:i:s', $rost->date);
// if date is weekday
if ($date->isWeekday()) {
if (!$site->isUserOnsite($rost->user_id, $rost->date) && !$site->isUserOnCompliance($rost->user_id, $rost->date)) {
echo $rost->date->format('d/m/Y') . " {$site->name} ({$site->code}) - <b>{$user->fullname}</b> (" . $user->company->name . ") was absent<br>";
$log .= $rost->date->format('d/m/Y') . " {$site->name} ({$site->code}) - {$user->fullname} (" . $user->company->name . ") was absent\n";
SiteCompliance::create(array('site_id' => $site->id, 'user_id' => $user->id, 'date' => $rost->date, 'reason' => null, 'status' => 0, 'resolved_date' => '0000-00-00 00:00:00'));
$found = true;
}
}
}
if (!$found) {
echo "There were no Non-Attendees to add or they were already on the list<br>";
$log .= "There were no Non-Attendees to add or they were already on the list\n";
}
echo "<h4>Completed</h4>";
$log .= "\nCompleted\n\n\n";
$bytes_written = File::append(public_path('filebank/log/nightly/' . Carbon::now()->format('Ymd') . '.txt'), $log);
if ($bytes_written === false) {
die("Error writing to file");
}
}
/**
* Is a specific user on site non-attendee list (Compliance table)
*
* @return record
*/
public function isUserOnCompliance($user_id, $date = '')
{
if (!$date) {
$date = Carbon::today()->format('Y-m-d');
}
$oncomply = SiteCompliance::where('site_id', $this->id)->where('user_id', $user_id)->whereDate('date', '=', $date)->first();
return $oncomply ? $oncomply->id : 0;
}
/**
* Update the specified resource in storage.
*
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$comply = SiteCompliance::findOrFail($id);
// Check authorisation and throw 404 if not
if (!Auth::user()->allowedTo('edit', 'compliance', $comply)) {
return view('errors/404');
}
$comply_request = $request->only('reason', 'status', 'notes');
if ($comply_request['reason'] == '') {
$comply_request['reason'] = null;
}
// Format date from datetime picker to mysql format
//$date = new Carbon (preg_replace('/-/', '', $request->get('resolved_date')));
//$comply_request['resolveddate'] = $date->format('Y-m-d H:i:s');
$comply->update($comply_request);
Toastr::success("Updated record");
return $comply;
}
/**
* Migrate Site Comply
*/
public function comply()
{
echo "<h1>Migrating Compliance</h1>";
DB::table('site_compliance')->truncate();
set_time_limit(60);
$complys = zSiteComply::all();
$complys->each(function ($comply) {
echo "<b>" . $comply->sub_id . "</b> {$comply->jobnum} - ({$comply->date})";
$user = User::where('username', $comply->sub_id)->first();
$site = Site::where('code', $comply->jobnum)->first();
$user2 = User::where('username', $comply->updated_by)->first();
if ($user2) {
$updatedby = $user2->id;
} else {
$updatedby = '1';
}
$status = '0';
if ($comply->resolved == "y") {
$status = '1';
}
$reason = null;
if ($comply->reason == '0') {
$reason = 12;
} else {
if ($comply->reason != '') {
$reason = $comply->reason;
}
}
if ($user && $site) {
$newComply = SiteCompliance::create(array('site_id' => $site->id, 'user_id' => $user->id, 'date' => $comply->date, 'reason' => $reason, 'status' => $status, 'resolved_date' => $comply->resdate, 'notes' => reformatOldStr($comply->notes), 'created_by' => '1', 'updated_by' => $updatedby, 'created_at' => $comply->date, 'updated_at' => $comply->updated));
} else {
echo " FAILED";
}
echo "<br>";
});
echo "<h1>Completed</h1>";
}
