/**
* Store a newly created resource in storage.
*/
public function store(Request $request)
{
if ($request->ajax()) {
return SitePlanner::create($request->all());
}
return view('errors/404');
}
/**
* 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>";
}
