/**
* Company Tasks for given site + date
*
* @return array
*/
public function companyTasksForSiteOnDate($company_id, $site_id, $date)
{
$carbon_date = Carbon::createFromFormat('Y-m-d H:i:s', $date . ' 00:00:00');
$weekend = $carbon_date->isWeekend() ? 1 : 0;
$planner = SitePlanner::where('site_id', $site_id)->whereDate('from', '<=', $date)->whereDate('to', '>=', $date)->where('weekend', $weekend)->get();
$tasks = [];
foreach ($planner as $plan) {
if ($plan->task_id) {
$task = Task::find($plan->task_id);
$tasks[$task->id] = $task ? $task->name : 'Task Unassigned';
}
}
return $tasks;
}
public static function dailyUpdate()
{
$log = '';
//echo "<h1>Adding New Entities to Roster</h1>";
$log .= "Adding New Entities to Roster\n\n";
$capecod = '3';
$company = Company::findOrFail($capecod);
$allowedSites = $company->siteList('1')->pluck('id')->toArray();
$allowedSites = Site::all()->pluck('id')->toArray();
$date = Carbon::now()->format('Y-m-d');
//$date = '2016-08-17';
$planner = SitePlanner::select(['id', 'site_id', 'entity_type', 'entity_id', 'task_id', 'from', 'to', 'days'])->where('from', '<=', $date)->where('to', '>=', $date)->whereIn('site_id', $allowedSites)->orderBy('site_id')->get();
foreach ($planner as $plan) {
if ($plan->entity_type == 'c') {
$site = Site::find($plan->site_id);
$company = Company::findOrFail($plan->entity_id);
$staff = $company->staffActive()->pluck('id')->toArray();
$log .= "\nf:" . $plan->from->format('Y-m-d') . ' t:' . $plan->to->format('Y-m-d') . ' [' . $plan->id . '] (' . $company->name . ") Task:{$plan->task_id} Site: {$site->name} ({$plan->site_id})\n";
foreach ($staff as $staff_id) {
$user = User::findOrFail($staff_id);
if (!$site->isUserOnRoster($staff_id, $date)) {
//echo 'adding '.$user->fullname.' ('.$user->username.') to roster<br>';
$log .= 'adding ' . $user->fullname . ' (' . $user->username . ") to roster\n";
$newRoster = SiteRoster::create(array('site_id' => $site->id, 'user_id' => $staff_id, 'date' => $date . ' 00:00:00', 'created_by' => '1', 'updated_by' => '1'));
}
}
}
}
//echo "<h1>Completed</h1>";
$log .= "\nCompleted";
$now = Carbon::now()->format('Y-m-d-G-i-s');
$bytes_written = File::put(public_path('filebank/log/nightly/' . $now . '.txt'), $log);
if ($bytes_written === false) {
die("Error writing to file");
} else {
echo 'Logfile filebank/log/nightly/' . $now . '.txt';
}
echo $log;
}
/**
* A list of sites this company is on a Planner for
*
* @return \Illuminate\Database\Eloquent\Collection
*/
public function sitePlannerList($status = '')
{
$client_list = $this->reportsToCompany()->clients->pluck('id')->toArray();
if ($status != '') {
$collection = Site::where('status', $status)->whereIn('client_id', $client_list)->get();
} else {
$collection = Site::whereIn('client_id', $client_list)->get();
}
// If Company has no Parent then return full collection
// ie. a list of all sites of all their own clients
if (!$this->parentCompany) {
return $collection;
}
$logged_site_id = '';
if (Session::has('siteID')) {
$site_code = Session::get('siteID');
$site = Site::where(['code' => $site_code])->first();
$logged_site_id = $site->id;
}
// Otherwise return a filtered collection of sites that company is on Planner for
$filteredCollection = [];
foreach ($collection as $site) {
$onPlanner = SitePlanner::where('site_id', $site->id)->where('entity_type', 'c')->where('entity_id', $this->id)->first();
if (!$onPlanner && $site->id != $logged_site_id) {
$filteredCollection[] = $site->id;
}
}
return $collection->except($filteredCollection);
}
/**
* Company Tasks for given site + date
*
* @return array
*/
public function anyTasksOnDate($date)
{
$carbon_date = Carbon::createFromFormat('Y-m-d H:i:s', $date . ' 00:00:00');
$weekend = $carbon_date->isWeekend() ? 1 : 0;
$planner = SitePlanner::where('site_id', $this->id)->whereDate('from', '<=', $date)->whereDate('to', '>=', $date)->where('weekend', $weekend)->first();
$onplan = SitePlanner::where('site_id', $this->id)->whereDate('from', '<=', $date)->whereDate('to', '>=', $date)->where('weekend', $weekend)->first();
return $planner ? true : false;
}
/**
* Get List of Site Without Job Starts options for 'select' dropdown in Vuejs format
*/
public function getPlannerForWeek($date_from, $date_to, $allowedSites, $excludeTasks)
{
if (Auth::user()->company->subscription) {
return SitePlanner::select(['id', 'site_id', 'entity_type', 'entity_id', 'task_id', 'from', 'to', 'days'])->where(function ($q) use($date_from, $date_to, $allowedSites, $excludeTasks) {
$q->where('from', '>=', $date_from->format('Y-m-d'));
$q->Where('from', '<=', $date_to->format('Y-m-d'));
$q->whereIn('site_id', $allowedSites);
$q->whereNotIn('task_id', $excludeTasks);
})->orWhere(function ($q) use($date_from, $date_to, $allowedSites, $excludeTasks) {
$q->where('to', '>=', $date_from->format('Y-m-d'));
$q->Where('to', '<=', $date_to->format('Y-m-d'));
$q->whereIn('site_id', $allowedSites);
$q->whereNotIn('task_id', $excludeTasks);
})->orWhere(function ($q) use($date_from, $date_to, $allowedSites, $excludeTasks) {
$q->where('from', '<', $date_from->format('Y-m-d'));
$q->Where('to', '>', $date_to->format('Y-m-d'));
$q->whereIn('site_id', $allowedSites);
$q->whereNotIn('task_id', $excludeTasks);
})->orderBy('from')->get();
} else {
return SitePlanner::select(['id', 'site_id', 'entity_type', 'entity_id', 'task_id', 'from', 'to', 'days'])->where(function ($q) use($date_from, $date_to, $allowedSites, $excludeTasks) {
$q->where('from', '>=', $date_from->format('Y-m-d'));
$q->Where('from', '<=', $date_to->format('Y-m-d'));
$q->whereIn('site_id', $allowedSites);
$q->whereNotIn('task_id', $excludeTasks);
$q->where('entity_type', 'c');
$q->where('entity_id', Auth::user()->company->id);
})->orWhere(function ($q) use($date_from, $date_to, $allowedSites, $excludeTasks) {
$q->where('to', '>=', $date_from->format('Y-m-d'));
$q->Where('to', '<=', $date_to->format('Y-m-d'));
$q->whereIn('site_id', $allowedSites);
$q->whereNotIn('task_id', $excludeTasks);
$q->where('entity_type', 'c');
$q->where('entity_id', Auth::user()->company->id);
})->orWhere(function ($q) use($date_from, $date_to, $allowedSites, $excludeTasks) {
$q->where('from', '<', $date_from->format('Y-m-d'));
$q->Where('to', '>', $date_to->format('Y-m-d'));
$q->whereIn('site_id', $allowedSites);
$q->whereNotIn('task_id', $excludeTasks);
$q->where('entity_type', 'c');
$q->where('entity_id', Auth::user()->company->id);
})->orderBy('from')->get();
}
}
public function sitePDF(SitePlannerExportRequest $request, $site_id, $date, $weeks)
{
$date = Carbon::createFromFormat('d/m/Y H:i:s', $request->get('date') . ' 00:00:00')->format('Y-m-d');
$weeks = $request->get('weeks');
/*
* Export by Company
*/
if ($request->has('export_site')) {
$site_id = $request->get('site_id');
//echo "Site: $site_id Date: $date Weeks: $weeks<br>";
//exit();
$sites = [];
if ($site_id) {
$sites[] = $site_id;
} else {
$sites = Auth::user()->company->reportsToCompany()->siteList('1')->pluck('id')->toArray();
}
// Sort Sites by Site Name
$site_list = [];
foreach ($sites as $siteID) {
$site_list[$siteID] = Site::find($siteID)->name;
}
asort($site_list);
// For each Site get Tasks om Planner
$sitedata = [];
foreach ($site_list as $siteID => $siteName) {
$site = Site::findOrFail($siteID);
$obj_site = (object) [];
$obj_site->site_id = $site->id;
$obj_site->site_name = $site->name;
$obj_site->weeks = [];
// For each week get Entities on the Planner
$current_date = $date;
for ($w = 1; $w <= $weeks; $w++) {
$date_from = Carbon::createFromFormat('Y-m-d H:i:s', $current_date . ' 00:00:00');
if ($date_from->isWeekend()) {
$date_from->addDays(1);
}
if ($date_from->isWeekend()) {
$date_from->addDays(1);
}
// Calculate Date to ensuring not a weekend
$date_to = Carbon::createFromFormat('Y-m-d H:i:s', $date_from->format('Y-m-d H:i:s'));
$dates = [$date_from->format('Y-m-d')];
for ($i = 2; $i < 6; $i++) {
$date_to->addDays(1);
if ($date_to->isWeekend()) {
$date_to->addDays(2);
}
$dates[] = $date_to->format('Y-m-d');
}
//echo "From: " . $date_from->format('d/m/Y') . " To:" . $date_to->format('d/m/Y') . "<br>";
$planner = SitePlanner::select(['id', 'site_id', 'entity_type', 'entity_id', 'task_id', 'from', 'to', 'days'])->where(function ($q) use($date_from, $date_to, $site) {
$q->where('from', '>=', $date_from->format('Y-m-d'));
$q->Where('from', '<=', $date_to->format('Y-m-d'));
$q->where('site_id', $site->id);
})->orWhere(function ($q) use($date_from, $date_to, $site) {
$q->where('to', '>=', $date_from->format('Y-m-d'));
$q->Where('to', '<=', $date_to->format('Y-m-d'));
$q->where('site_id', $site->id);
})->orWhere(function ($q) use($date_from, $date_to, $site) {
$q->where('from', '<', $date_from->format('Y-m-d'));
$q->Where('to', '>', $date_to->format('Y-m-d'));
$q->where('site_id', $site->id);
})->orderBy('from')->get();
// Get Unique list of Entities for current week
$entities = [];
foreach ($planner as $plan) {
$key = $plan->entity_type . '.' . $plan->entity_id;
if (!isset($entities[$key])) {
$entity_name = $plan->entity_type == 'c' ? Company::find($plan->entity_id)->name : Trade::find($plan->entity_id)->name;
$entities[$key] = ['key' => $key, 'entity_type' => $plan->entity_type, 'entity_id' => $plan->entity_id, 'entity_name' => $entity_name];
for ($i = 0; $i < 5; $i++) {
$entities[$key][$dates[$i]] = '';
}
}
}
usort($entities, 'sortEntityName');
// Create Header Row for Current Week
$obj_site->weeks[$w] = [];
$obj_site->weeks[$w][0][] = 'COMPANY';
foreach ($dates as $d) {
$obj_site->weeks[$w][0][] = strtoupper(Carbon::createFromFormat('Y-m-d H:i:s', $d . ' 00:00:00')->format('l d/m'));
}
// For each Entity on for current week get their Tasks for each day of the week
$entity_count = 1;
if ($entities) {
foreach ($entities as $e) {
$obj_site->weeks[$w][$entity_count][] = $e['entity_name'];
for ($i = 1; $i <= 5; $i++) {
$tasks = $site->entityTasksOnDate($e['entity_type'], $e['entity_id'], $dates[$i - 1]);
if ($tasks) {
$str = '';
foreach ($tasks as $task_id => $task_name) {
$str .= $task_name . '<br>';
}
} else {
$str = ' ';
}
$obj_site->weeks[$w][$entity_count][$i] = $str;
}
$entity_count++;
}
} else {
$obj_site->weeks[$w][1][] = 'NOTHING-ON-PLAN';
$obj_site->weeks[$w][1][1] = '';
}
$date_next = Carbon::createFromFormat('Y-m-d H:i:s', $current_date . ' 00:00:00')->addDays(7);
$current_date = $date_next->format('Y-m-d');
}
$sitedata[] = $obj_site;
}
//return view('pdf.plan-site', compact('site', 'date', 'weeks', 'sitedata'));
$pdf = PDF::loadView('pdf.plan-site', compact('site', 'date', 'weeks', 'sitedata'))->setOption('page-width', 200)->setOption('page-height', 287)->setOption('margin-bottom', 10)->setOrientation('landscape');
//$file = public_path('filebank/company/' . $doc->for_company_id . '/wms/' . $doc->name . ' v' . $doc->version . ' ref-' . $doc->id . ' ' . '.pdf');
//if (file_exists($file))
// unlink($file);
//$pdf->save($file);
return $pdf->stream();
}
/*
* Export by Company
*/
if ($request->has('export_company')) {
$company_id = $request->get('company_id');
$companies = [];
if ($company_id) {
$companies[] = $company_id;
} else {
$companies = Auth::user()->company->companyList('1')->pluck('id')->toArray();
}
// Sort Companies by Name
$company_list = [];
foreach ($companies as $cid) {
$company_list[$cid] = Company::find($cid)->name;
}
asort($company_list);
// For each Company get Tasks om Planner
$sitedata = [];
foreach ($company_list as $cid => $cname) {
$company = Company::find($cid);
$obj_site = (object) [];
$obj_site->company_id = $company->id;
$obj_site->company_name = $company->name;
$obj_site->weeks = [];
$obj_site->upcoming = [];
// For each week get Sites on the Planner
$current_date = $date;
for ($w = 1; $w <= $weeks; $w++) {
$date_from = Carbon::createFromFormat('Y-m-d H:i:s', $current_date . ' 00:00:00');
if ($date_from->isWeekend()) {
$date_from->addDays(1);
}
if ($date_from->isWeekend()) {
$date_from->addDays(1);
}
// Calculate Date To ensuring not a weekend
$date_to = Carbon::createFromFormat('Y-m-d H:i:s', $date_from->format('Y-m-d H:i:s'));
$dates = [$date_from->format('Y-m-d')];
for ($i = 2; $i < 6; $i++) {
$date_to->addDays(1);
if ($date_to->isWeekend()) {
$date_to->addDays(2);
}
$dates[] = $date_to->format('Y-m-d');
}
//echo "From: " . $date_from->format('d/m/Y') . " To:" . $date_to->format('d/m/Y') . "<br>";
$planner = SitePlanner::select(['id', 'site_id', 'entity_type', 'entity_id', 'task_id', 'from', 'to', 'days'])->where(function ($q) use($date_from, $date_to, $company) {
$q->where('from', '>=', $date_from->format('Y-m-d'));
$q->Where('from', '<=', $date_to->format('Y-m-d'));
$q->where('entity_type', 'c');
$q->where('entity_id', $company->id);
})->orWhere(function ($q) use($date_from, $date_to, $company) {
$q->where('to', '>=', $date_from->format('Y-m-d'));
$q->Where('to', '<=', $date_to->format('Y-m-d'));
$q->where('entity_type', 'c');
$q->where('entity_id', $company->id);
})->orWhere(function ($q) use($date_from, $date_to, $company) {
$q->where('from', '<', $date_from->format('Y-m-d'));
$q->Where('to', '>', $date_to->format('Y-m-d'));
$q->where('entity_type', 'c');
$q->where('entity_id', $company->id);
})->orderBy('from')->get();
// Get Unique list of Sites for current week
$sites = [];
foreach ($planner as $plan) {
if (!isset($sites[$plan->site_id])) {
$site = Site::find($plan->site_id);
$sites[$plan->site_id] = ['site_id' => $plan->site_id, 'site_name' => $site->name, 'site_supervisor' => $site->supervisorsFirstNameSeparatedByComma()];
for ($i = 0; $i < 5; $i++) {
$sites[$plan->site_id][$dates[$i]] = '';
}
}
}
usort($sites, 'sortSiteName');
// Create Header Row for Current Week
$obj_site->weeks[$w] = [];
$obj_site->weeks[$w][0][] = 'SITE';
foreach ($dates as $d) {
$obj_site->weeks[$w][0][] = strtoupper(Carbon::createFromFormat('Y-m-d H:i:s', $d . ' 00:00:00')->format('l d/m'));
}
// For each Site on for current week get the Company Tasks for each day of the week
$site_count = 1;
if ($sites) {
foreach ($sites as $s) {
$obj_site->weeks[$w][$site_count][] = $s['site_name'] . ' (' . $s['site_supervisor'] . ')';
for ($i = 1; $i <= 5; $i++) {
$site = Site::find($s['site_id']);
$tasks = $site->entityTasksOnDate('c', $company->id, $dates[$i - 1]);
if ($tasks) {
$str = '';
foreach ($tasks as $task_id => $task_name) {
$str .= $task_name . '<br>';
}
} else {
$str = ' ';
}
$obj_site->weeks[$w][$site_count][$i] = $str;
}
$site_count++;
}
} else {
$obj_site->weeks[$w][1][] = 'NOTHING-ON-PLAN';
$obj_site->weeks[$w][1][1] = '';
}
$date_next = Carbon::createFromFormat('Y-m-d H:i:s', $current_date . ' 00:00:00')->addDays(7);
$current_date = $date_next->format('Y-m-d');
}
/*
* Upcoming
*/
//for ($w = 1; $w <= 2; $w++) {
$date_from = Carbon::createFromFormat('Y-m-d H:i:s', $current_date . ' 00:00:00');
$date_to = Carbon::createFromFormat('Y-m-d H:i:s', $current_date . ' 00:00:00');
$date_to->addDays(14);
//echo "From: " . $date_from->format('d/m/Y') . " To:" . $date_to->format('d/m/Y') . "<br>";
$planner = SitePlanner::select(['id', 'site_id', 'entity_type', 'entity_id', 'task_id', 'from', 'to', 'days'])->where(function ($q) use($date_from, $date_to, $company) {
$q->where('from', '>=', $date_from->format('Y-m-d'));
$q->Where('from', '<=', $date_to->format('Y-m-d'));
$q->where('entity_type', 'c');
$q->where('entity_id', $company->id);
})->orWhere(function ($q) use($date_from, $date_to, $company) {
$q->where('to', '>=', $date_from->format('Y-m-d'));
$q->Where('to', '<=', $date_to->format('Y-m-d'));
$q->where('entity_type', 'c');
$q->where('entity_id', $company->id);
})->orWhere(function ($q) use($date_from, $date_to, $company) {
$q->where('from', '<', $date_from->format('Y-m-d'));
$q->Where('to', '>', $date_to->format('Y-m-d'));
$q->where('entity_type', 'c');
$q->where('entity_id', $company->id);
})->orderBy('from')->get();
//dd($planner);
$sites = [];
foreach ($planner as $plan) {
if (!in_array($plan->site_id, $sites)) {
$sites[] = $plan->site_id;
}
}
$current_date = Carbon::createFromFormat('Y-m-d H:i:s', $current_date . ' 00:00:00');
if ($sites) {
for ($x = 1; $x <= 14; $x++) {
// Skip Weekends
if ($current_date->isWeekend()) {
$current_date->addDays(1);
}
if ($current_date->isWeekend()) {
$current_date->addDays(1);
}
foreach ($sites as $s) {
$site = Site::find($s);
$tasks = $site->entityTasksOnDate('c', $company->id, $current_date->format('Y-m-d'));
if ($tasks) {
$task_list = '';
foreach ($tasks as $task_id => $task_name) {
$task_list .= $task_name . ', ';
}
$task_list = rtrim($task_list, ', ');
$obj_site->upcoming[] = ['date' => $current_date->format('M j'), 'site' => $site->name, 'tasks' => $task_list];
}
}
$current_date->addDay(1);
}
}
//}
$sitedata[] = $obj_site;
}
//dd($sitedata);
//return view('pdf/plan-company', compact('company_id', 'date', 'weeks', 'sitedata'));
$pdf = PDF::loadView('pdf.plan-company', compact('company_id', 'date', 'weeks', 'sitedata'))->setOption('page-width', 200)->setOption('page-height', 287)->setOption('margin-bottom', 10)->setOrientation('landscape');
//$file = public_path('filebank/company/' . $doc->for_company_id . '/wms/' . $doc->name . ' v' . $doc->version . ' ref-' . $doc->id . ' ' . '.pdf');
//if (file_exists($file))
// unlink($file);
//$pdf->save($file);
return $pdf->stream();
}
}
public static function roster()
{
$log = '';
echo "<h2>Adding Users to Roster</h2>";
$log .= "Adding New Users to Roster\n";
$log .= "------------------------------------------------------------------------\n\n";
$allowedSites = Site::all()->pluck('id')->toArray();
if (Auth::check()) {
$allowedSites = Auth::user()->company->siteList('1')->pluck('id')->toArray();
}
$date = Carbon::now()->format('Y-m-d');
//$date = '2016-08-17';
$planner = SitePlanner::where('from', '<=', $date)->where('to', '>=', $date)->whereIn('site_id', $allowedSites)->orderBy('site_id')->get();
foreach ($planner as $plan) {
if ($plan->entity_type == 'c') {
$site = Site::find($plan->site_id);
$company = Company::findOrFail($plan->entity_id);
$staff = $company->staffActive()->pluck('id')->toArray();
$task = Task::find($plan->task_id);
echo "<br><b>Site:{$site->name} ({$plan->site_id}) Company: {$company->name} Task: {$task->name} PID: {$plan->id}</b><br>";
$log .= "\nSite: {$site->name} ({$plan->site_id}) Company: {$company->name} Task: {$task->name} PID: {$plan->id}\n";
$found = false;
foreach ($staff as $staff_id) {
$user = User::findOrFail($staff_id);
if (!$site->isUserOnRoster($staff_id, $date)) {
echo 'adding ' . $user->fullname . ' (' . $user->username . ') to roster<br>';
$log .= 'adding ' . $user->fullname . ' (' . $user->username . ") to roster\n";
$newRoster = SiteRoster::create(array('site_id' => $site->id, 'user_id' => $staff_id, 'date' => $date . ' 00:00:00', 'created_by' => '1', 'updated_by' => '1'));
$found = true;
}
}
if (!$found) {
echo "There were no users to add or they were already on the roster<br>";
$log .= "There were no users to add or they were already on the roster\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");
}
}
/**
* Migrate Planner
*/
public function planner($id)
{
echo "<h1>Migrating Planner {$id}</h1>";
//$p1 = zSitePlanner::where('jobnum', '<', '7610')->orderBy('jobnum')->orderBy('date')->get();
//$p2 = zSitePlanner::where('jobnum', '>=', '7610')->orderBy('jobnum')->orderBy('date')->get();
//echo "p1:".count($p1)."<br>";
//echo "p2:".count($p2)."<br>";
//dd();
set_time_limit(60);
if ($id == '1') {
//disable foreign key check for this connection before running seeders
DB::statement('SET FOREIGN_KEY_CHECKS=0;');
DB::table('site_planner')->truncate();
DB::table('z_lookup_planner')->truncate();
DB::statement('SET FOREIGN_KEY_CHECKS=1;');
$planner = zSitePlanner::where('jobnum', '<', '7610')->orderBy('jobnum')->orderBy('date')->get();
} else {
$planner = zSitePlanner::where('jobnum', '>=', '7600')->orderBy('jobnum')->orderBy('date')->get();
}
$planner->each(function ($plan) {
if (true) {
//$plan->jobnum == '7599') {
$e = "{$plan->id} <b>" . $plan->company_id . "</b> {$plan->jobnum} - ({$plan->date})";
$site = Site::where('code', $plan->jobnum)->first();
if ($plan->company_id) {
$type = substr($plan->company_id, 0, 1);
if ($type == 'T') {
$etype = 't';
$tid = DB::table('z_lookup_trades')->where('old', substr($plan->company_id, 3))->get();
$tid ? $eid = $tid[0]->new : ($eid = 0);
$cid = "TRD";
} else {
$etype = 'c';
$cid = DB::table('z_lookup_company')->where('old', $plan->company_id)->get();
$cid ? $eid = $cid[0]->new : ($eid = 1);
}
} else {
$cid = '';
}
$user = User::where('username', $plan->updated_by)->first();
if ($user) {
$updatedby = $user->id;
} else {
$updatedby = '1';
}
if (!$cid) {
//echo "<b>NO CID</b> - $e <br>";
} elseif ($site->id) {
$tasks = explode(':', $plan->tasks);
foreach ($tasks as $task) {
if ($task != '') {
if ($task == '0') {
$task = null;
} else {
$lookup = DB::table('z_lookup_tasks')->where('old', $task)->get();
$task = $lookup[0]->new;
}
// If date is a weekday check if Company has same Task previous day
$planDate = Carbon::createFromFormat('Y-m-d H:i:s', $plan->date);
$planDayofWeek = $planDate->dayOfWeek;
$dayBefore = $planDate->subDay();
if ($planDayofWeek > 0 && $planDayofWeek < 6) {
// 6 = Sat 0 = Sun
if ($planDayofWeek == 1) {
$dayBefore = $dayBefore->subDays(2);
}
} else {
$dayBefore = Carbon::createFromFormat('Y-m-d H:i:s', $plan->date);
}
$sameTask = SitePlanner::where('site_id', $site->id)->where('entity_type', $etype)->where('entity_id', $eid)->where('task_id', $task)->where('to', $dayBefore->toDateTimeString())->get();
if (count($sameTask) > 0) {
$sameTask[0]->to = $plan->date;
$sameTask[0]->days++;
$sameTask[0]->save();
// Add to lookup
zLookupPlanner::create(array('old' => $plan->id, 'site_id' => $site->id, 'date' => $plan->date));
} else {
$newPlanner = SitePlanner::create(array('site_id' => $site->id, 'from' => $plan->date, 'to' => $plan->date, 'days' => '1', 'entity_type' => $etype, 'entity_id' => $eid, 'task_id' => $task, 'created_by' => '1', 'updated_by' => $updatedby, 'created_at' => '0000-00-00 00:00:00', 'updated_at' => $plan->updated));
// Add to lookup
zLookupPlanner::create(array('old' => $plan->id, 'site_id' => $site->id, 'date' => $plan->date));
}
//echo "$task - $e <br>";
}
}
} else {
//echo "<b>No SITE</b> - $e <br>";
}
//echo "$e <br>";
}
});
echo "<h1>Completed</h1>";
}