/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$month = new Carbon($this->argument('month'));
$billboards = Billboard::activated()->get();
$pictures = Storage::files();
$missing_pictures = new Collection();
foreach ($billboards as $billboard) {
$facings = $billboard->facings->all();
foreach ($facings as $facing) {
$ref = $this->reference($billboard, $facing, $month);
$image_url = "{$ref}.jpg";
if (in_array($image_url, $pictures)) {
try {
$this->trackingRepository->create(['facing_id' => $facing->id, 'image_url' => $image_url, 'tracking_date' => $month, 'location_id' => $billboard->location_id]);
$this->info('Tracking #' . $ref . ' with image url ' . $image_url . ' created successfully.');
} catch (\Illuminate\Database\QueryException $e) {
$this->error('Tracking #' . $ref . ' already exists.');
}
} else {
$this->error('Facing #' . $ref . ' picture missing.');
$missing_pictures->push(["name" => $facing->name, "image_url" => $image_url]);
}
}
}
if (!$missing_pictures->isEmpty()) {
$this->notifyMissingPictures($missing_pictures, "*****@*****.**");
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('billboards')->truncate();
$faker = Faker::create();
foreach (range(1, 20) as $index) {
Billboard::create(['latLng' => $faker->latitude . ", " . $faker->longitude, 'structure' => 'Attached to structure', 'placement' => 'Ground Level', 'size' => '5*15', 'panel_type' => 'Digital', 'road_type' => 'Highway', 'speed_of_road' => 120, 'billboard_owner_id' => BillboardOwner::first()->id]);
}
}
public function run()
{
DB::table('facings')->truncate();
$faker = Faker::create();
foreach (range(1, 20) as $index) {
Facing::create(['name' => Str::upper($faker->randomLetter), 'angle' => '5-25', 'is_obstructed' => $faker->boolean(50), 'contact_time' => '5-25', 'illumination_type' => '5-25', 'distance_from_road' => '5-25', 'billboard_proximity' => '50-100', 'billboard_id' => Billboard::find($faker->numberBetween(1, 20))->id]);
}
}
/**
* Show the form for editing the specified Facing.
*
* @param int $id
*
* @return Response
*/
public function edit($id)
{
$facing = $this->facingRepository->findWithoutFail($id);
$billboards = Billboard::lists('id', 'id');
if (empty($facing)) {
Flash::error('Facing not found');
return redirect(route('facings.index'));
}
return view('facings.edit')->with('facing', $facing)->with('billboards', $billboards);
}
