public function equipmentSearch($q)
{
$json = [];
$results = Equipment::where('name', 'LIKE', "%{$q}%")->take(10)->lists('name', 'id');
foreach ($results as $key => $value) {
$json[] = array('id' => $key, 'value' => $value);
}
return json_encode($json);
}
/**
* Searches and returns any equipment added in the last 24 hours
*
* @return Collection
*/
public static function getEquipmentsAddedInTheLast24Hours()
{
# Timestamp of 24 hours ago
$past_24_hours = strtotime('-1 day');
# Convert to MySQL timestamp
$past_24_hours = date('Y-m-d H:i:s', $past_24_hours);
$equipment = App\Equipment::where('created_at', '>', $past_24_hours)->get();
return $equipment;
}
public function run()
{
# Clear the tables to a blank slate
# Disable FK constraints so that all rows can be deleted, even if there's an attachd FK
DB::statement('SET FOREIGN_KEY_CHECKS=0');
DB::statement('TRUNCATE equipment');
DB::statement('TRUNCATE category_equipment');
$audiorecorder = new Equipment();
$audiorecorder->name = 'audiorecorder';
$audiorecorder->brand = 'Sony';
$audiorecorder->model = 'L-185';
$audiorecorder->serial_number = '123456';
$audiorecorder->price = 1500;
$audiorecorder->availability = 1;
$audiorecorder->image_path = 'images/marantz_1.jpg';
$audiorecorder->save();
$dongle = new Equipment();
$dongle->name = 'dongle';
$dongle->brand = 'Apple';
$dongle->model = 'l-185';
$dongle->price = 1500;
$dongle->availability = 1;
$dongle->image_path = 'images/mac_dungle.jpg';
$dongle->save();
# equipment
$laptop = new Equipment();
$laptop->name = 'laptop';
$laptop->brand = 'Dell';
$laptop->model = 'Latitude';
$laptop->serial_number = '123456';
$laptop->price = 1500;
$laptop->availability = 1;
$laptop->image_path = 'images/dell_laptop.jpg';
$laptop->save();
$mac = new Equipment();
$mac->name = 'mac';
$mac->brand = 'Apple';
$mac->model = 'Mac-Pro';
$mac->serial_number = '123789';
$mac->price = 1500;
$mac->availability = 1;
$mac->image_path = 'images/mac-pro.jpg';
$mac->save();
$microphone = new Equipment();
$microphone->name = 'microphone';
$microphone->brand = 'Shure';
$microphone->model = 'sm-58';
$microphone->serial_number = '1255456';
$microphone->price = 1500;
$microphone->availability = 1;
$microphone->image_path = 'images/shure_mic.jpg';
$microphone->save();
$projector = new Equipment();
$projector->name = 'projector';
$projector->brand = 'Sanyo';
$projector->model = 'wtc-500';
$projector->serial_number = '1254566';
$projector->price = 1500;
$projector->availability = 1;
$projector->image_path = 'images/sanyo_projector.jpg';
$projector->save();
$tripod = new Equipment();
$tripod->name = 'tripod';
$tripod->brand = 'Manfrotto';
$tripod->model = 'T-25';
$tripod->serial_number = '1254566';
$tripod->price = 1500;
$tripod->availability = 1;
$tripod->image_path = 'images/tripod.jpg';
$tripod->save();
$videocamera = new Equipment();
$videocamera->name = 'videocamera';
$videocamera->brand = 'Sony';
$videocamera->model = 'ts4000';
$videocamera->serial_number = '1254566';
$videocamera->price = 1500;
$videocamera->availability = 1;
$videocamera->image_path = 'images/hdzoom_cam.jpg';
$videocamera->save();
$sound_system = new equipment();
$sound_system->name = 'sound_system';
$sound_system->brand = 'Yamaha';
$sound_system->model = 't-25';
$sound_system->serial_number = '1254566';
$sound_system->price = 1500;
$sound_system->availability = 1;
$sound_system->image_path = 'images/sound_system.jpg';
$sound_system->save();
$audiorecorder = App\Equipment::where('name', 'audiorecorder')->get()->first();
$category = App\Category::where('name', '=', 'audiorecorder')->first();
$audiorecorder->categories()->attach($category->id);
$category = App\Category::where('name', '=', 'dongle')->first();
$dongle = App\Equipment::where('name', 'dongle')->get()->first();
$dongle->categories()->attach($category->id);
$category = App\Category::where('name', '=', 'laptop')->first();
$laptop = App\Equipment::where('name', 'laptop')->get()->first();
$laptop->categories()->attach($category->id);
$category = App\Category::where('name', '=', 'mac')->first();
$mac = App\Equipment::where('name', 'audiorecorder')->get()->first();
$mac->categories()->attach($category->id);
$category = App\Category::where('name', '=', 'microphone')->first();
$microphone = App\Equipment::where('name', 'mac')->get()->first();
$microphone->categories()->attach($category->id);
$category = App\Category::where('name', '=', 'projector')->first();
$projector = App\Equipment::where('name', 'projector')->get()->first();
$projector->categories()->attach($category->id);
$category = App\Category::where('name', '=', 'tripod')->first();
$tripod = App\Equipment::where('name', 'tripod')->get()->first();
$tripod->categories()->attach($category->id);
$category = App\Category::where('name', '=', 'videocamera')->first();
$videocamera = App\Equipment::where('name', 'videocamera')->get()->first();
$videocamera->categories()->attach($category->id);
$category = App\Category::where('name', '=', 'sound_system')->first();
$sound_system = App\Equipment::where('name', 'sound_system')->get()->first();
$sound_system->categories()->attach($category->id);
}
public function getSearch()
{
$keyword = Input::get('keyword');
return View('/rental.search')->with('equipment', Equipment::where('title', 'LIKE', '%' . $keyword . '%')->get())->with('keyword', $keyword);
}
