/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$validator = Validator::make($request->all(), ['title' => 'required|max:255', 'content' => 'required', 'lesson_id' => 'required']);
if ($validator->fails()) {
return redirect('/')->withInput()->withErrors($validator);
}
//dd($request);
$info = new Info();
$info->title = $request->title;
$info->content = $request->content;
$info->week = $request->lesson_id;
$info->save();
return redirect('/home/index');
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
//$healthInfos = HealthReport::all();
$healthReport = Info::all();
//dd($healthReport);
return view('admin.AdminHealth.adminHealthInfos', compact('healthReport'));
}
public function handle($request, Closure $next)
{
$today = Carbon::now('Asia/Manila');
$report_date = Config::find(1);
// Send a report if today is not set to our config table
if ($report_date->report_date->day != $today->day || $report_date->report_date->month != $today->month || $report_date->report_date->year != $today->year) {
$report_date->report_date = $today;
$report_date->save();
$deadline_names = [];
$i = new \App\Info();
foreach (\App\Info::all() as $info) {
$deadline = $i->isDeadLineToday($info->dead_line);
if ($deadline == 'deadline' && $info->claim_status != 'approved') {
$deadline_names[$info->name] = $info;
}
}
$data = array('data' => $deadline_names);
\Log::info('Sending mail....');
\Mail::send('email.email', $data, function ($message) {
$message->from('*****@*****.**', 'GIBX Internal System');
$date = \Carbon\Carbon::today('Asia/Manila')->format('d/m/Y');
$recipients = ['*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**'];
$message->to($recipients)->subject('GIBX Claims System Daily Report ' . $date);
});
// TODO: Send an email for reporting here...
}
return $next($request);
}
public function store(Request $request)
{
$post = $request->all();
if ($request != " ") {
$i = $post['info'];
if ($i != " ") {
Info::where('id', 1)->update(array('info' => $i));
}
return redirect('grupas_info');
}
}
public static function make($main, $description, $temperature, $pressure, $humidity, $temp_min, $temp_max, $speed, $sunrise, $sunset, $time, $date, $city, $degree, $sea_level, $grnd_level)
{
$info = new Info();
$info->main = $main;
$info->description = $description;
$info->temperature = $temperature;
$info->pressure = $pressure;
$info->humidity = $humidity;
$info->temp_min = $temp_min;
$info->temp_max = $temp_max;
$info->speed = $speed;
$info->degree = $degree;
$info->sunrise = date("Y-m-d h:i:s", $sunrise);
$info->sunset = date("Y-m-d h:i:s", $sunset);
$info->time = $time;
$info->date = $date;
$info->city = $city;
$info->sea_level = $sea_level;
$info->grnd_level = $grnd_level;
$info->save();
}
/**
* Show the specified photo comment.
*
* @param int $photoId
* @param int $commentId
* @return Response
*/
public static function updateInfo($city)
{
$url = 'http://api.openweathermap.org/data/2.5/weather?q=' . $city . '&appid=2de143494c0b295cca9337e1e96b00e0';
$json = "";
try {
$json = file_get_contents($url);
} catch (Exception $e) {
echo $e->getMessage();
}
$obj = json_decode($json);
$weather_object = new \stdClass();
foreach ($obj->weather as $key => $value) {
$weather_object->main = $value->main;
$weather_object->description = $value->description;
}
$weather_object->temperature = $obj->main->temp;
$weather_object->pressure = $obj->main->pressure;
$weather_object->humidity = $obj->main->humidity;
$weather_object->temp_min = $obj->main->temp_min;
$weather_object->temp_max = $obj->main->temp_max;
if (!empty($obj->main->sea_level)) {
$weather_object->sea_level = $obj->main->sea_level;
} else {
$weather_object->sea_level = "";
}
if (!empty($obj->main->grnd_level)) {
$weather_object->grnd_level = $obj->main->grnd_level;
} else {
$weather_object->grnd_level = "";
}
$weather_object->speed = $obj->wind->speed;
if (!empty($obj->wind->degree)) {
$weather_object->degree = $obj->wind->deg;
} else {
$weather_object->degree = "";
}
$weather_object->sunrise = $obj->sys->sunrise;
$weather_object->sunset = $obj->sys->sunset;
$time = time();
$date = date("Y-m-d");
$info = Info::where('city', $city)->where('date', $date)->get();
if ($info->isEmpty()) {
Info::make($weather_object->main, $weather_object->description, $weather_object->temperature, $weather_object->pressure, $weather_object->humidity, $weather_object->temp_min, $weather_object->temp_max, $weather_object->speed, $weather_object->sunrise, $weather_object->sunset, $time, $date, $city, $weather_object->degree, $weather_object->sea_level, $weather_object->grnd_level);
} else {
$prev_info = Info::where('city', $city)->where('date', $date)->orderBy('created_at', 'desc')->first();
if ($prev_info->city != $city || $prev_info->main != $weather_object->main || $prev_info->description != $weather_object->description || abs($prev_info->temperature - $weather_object->temperature) != 0 || abs($prev_info->pressure - $weather_object->pressure) != 0 || abs($prev_info->humidity - $weather_object->humidity) != 0 || abs($prev_info->temp_min - $weather_object->temp_min) != 0 || abs($prev_info->sea_level - $weather_object->sea_level) != 0 || abs($prev_info->grnd_level - $weather_object->grnd_level) != 0 || date("Y-m-d h:i:s", $weather_object->sunrise) != $prev_info->sunrise || date("Y-m-d h:i:s", $weather_object->sunset) != $prev_info->sunset) {
Info::make($weather_object->main, $weather_object->description, $weather_object->temperature, $weather_object->pressure, $weather_object->humidity, $weather_object->temp_min, $weather_object->temp_max, $weather_object->speed, $weather_object->sunrise, $weather_object->sunset, $time, $date, $city, $weather_object->degree, $weather_object->sea_level, $weather_object->grnd_level);
echo View::make('weather', array('weather_object' => $weather_object, 'prev_info' => $prev_info));
exit;
}
}
echo View::make('weather', array('weather_object' => $weather_object));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index(Request $request)
{
// $lesson = Lesson::where('user_id', $request->user()->id)->get()->medias;
if (Auth::user()->group_id != 1) {
$lessons = Lesson::where('category_id', Auth::user()->category_id)->get();
$infos = Info::all();
$notes = Note::where('user_id', Auth::user()->id)->get();
} else {
$lessons = Lesson::all();
$infos = Info::all();
$notes = Note::where('user_id', Auth::user()->id)->get();
}
return view('home.index', compact('lessons', 'infos', 'notes'));
}
public function healthInfos($id)
{
$trainee = Info::where('course_id', '=', $id)->get();
return view('view_trainee_report.healthInfos', compact('trainee'));
// $trainee = TraineeCourse::where('course_id','=',$id)->get();
// dd($trainee);
// return view('view_trainee_report.healthInfos', compact('trainee'));
$trainee = DB::table('users')->join('traineecourses', 'traineecourses.trainee_id', '=', 'users.id')->join('courses', 'courses.id', '=', 'traineecourses.course_id')->where('courses.id', $id)->get();
//dd($trainee);
$id = [];
$name = [];
$abc = array();
foreach ($trainee as $tra) {
if (HealthReport::where('user_id', '=', $tra->trainee_id)->exists() and HealthExam::where('user_id', '=', $tra->trainee_id)->exists()) {
$abc[$tra->name] = array('id' => $tra->trainee_id, 'name' => $tra->name);
//dd($abc[$tra->name]);
}
}
//return print_r($abc);
return view('view_trainee_report.healthInfos')->with('abc', $abc);
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(PersonatRequest $person, InfoRequest $info, KontaktRequest $kontakt)
{
$vendlindja = Qytet::firstOrCreate(['qyteti' => $person->get('vendlindja')]);
$profesioni = Profesioni::firstOrCreate(['profesioni' => $person->get('profesioni')]);
$gjendja_civile = GjendjaCivile::firstOrCreate(['statusi' => $person->get('gjendja_civile')]);
Personat::create(['emer' => $person->get('emer'), 'mbiemer' => $person->get('mbiemer'), 'datelindja' => $person->get('datelindja'), 'vendlindja' => $vendlindja->id, 'profesioni' => $profesioni->id, 'gjinia' => $person->get('gjinia'), 'gjendja_civile' => $gjendja_civile->id]);
$personi = Personat::where('emer', $person->get('emer'))->where('mbiemer', $person->get('mbiemer'))->where('datelindja', $person->get('datelindja'))->first();
Pozicioni::firstOrCreate(['pozicioni' => $info->get('pozicioni')]);
$pozicioni = Pozicioni::where(['pozicioni' => $info->get('pozicioni')])->first();
Gatishmeria::firstOrCreate(['gatishmeria' => $info->get('gatishmeria')]);
$gatishmeria = Gatishmeria::where(['gatishmeria' => $info->get('gatishmeria')])->first();
$qendra = Dega::where(['dega' => $info->get('qendra')])->first();
$programi = Programi::where(['programi' => $info->get('programi')])->first();
Info::create(['personi' => $personi->id, 'qendra' => $qendra->id, 'pozicioni' => $pozicioni->id, 'programi' => $programi->id, 'disponimi' => $info->get('disponimi'), 'gatishmeria' => $gatishmeria->id, 'koha' => $info->get('koha'), 'rregjistrimi' => $info->get('rregjistrimi'), 'viti_i_fundit' => $info->get('viti_i_fundit')]);
Kontakt::create(['personi' => $personi->id, 'email' => $kontakt->get('email'), 'telefon' => $kontakt->get('telefon'), 'celular' => $kontakt->get('celular')]);
// foreach(Input::get('njohuri_te_tjera[]') as $key => $njohuri){
NjohuriShtese::firstOrCreate(['njohuri_shtese' => Input::get('njohuri_te_tjera')]);
$njohuri = NjohuriShtese::where(['njohuri_shtese' => Input::get('njohuri_te_tjera')])->first();
// }
$personi->njohuri_shtese()->attach($njohuri->id);
return $personi;
}
public function headPhoto(Request $request)
{
$file = $request->input('file');
$userId = $request->session()->get('id');
$base64 = base64_decode($file);
$path = 'uploads';
$filename = time() . '.png';
$destination = $path . "/" . $filename;
if (file_put_contents($filename, $base64)) {
if (rename($filename, $destination)) {
Info::where('user_id', $userId)->update(['head_photo' => $filename]);
return $this->success('上传成功', ['src' => 'uploads/' . $filename]);
}
return $this->fail('上传失败');
}
return $this->fail('上传失败');
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('infos')->truncate();
Info::create(['title' => 'DS dev', 'content' => "Réviser le modèle MVC", 'week' => '10']);
}
public function healthInfos($id)
{
$trainee = Info::where('course_id', '=', $id)->get();
return view('view_trainee_report.healthInfos', compact('trainee'));
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show_attendance_form_function(AttendanceFormRequest $request)
{
$course_id = $request->get('course_id');
$date = $request->get('date');
$session = $request->get('session');
$trainee_list = Info::whereCourse_id($course_id)->get();
$course_name = $this->course_name_by_course_id($course_id);
return view('attendances.attendance_create')->with('trainee_list', $trainee_list)->with('date', $date)->with('session', $session)->with('course_name', $course_name)->with('course_id', $course_id);
$present = Course::whereCourse_id($course_id)->where("trainee_attendance", "P")->count("trainee_attendance");
return $present;
$absent = Course::whereCourse_id($course_id)->where("trainee_attendance", "A")->count("trainee_attendance");
/*$attendance = new Attendance(array(
'day' => $request->get('date'),
'session_name' => $request->get('session'),
//'trainee_attendance' => $request->get('attendance'),
));
$attendance->save();*/
}
public function post_update_record(Info $i)
{
$stage = $this->request->input('stage');
if ($stage == 1) {
$this->validate($this->request, ['name' => 'required', 'claimant' => 'required', 'coc' => 'required', 'inception' => 'required']);
return $i->processStage1($i, $this->request);
} else {
if ($stage == 2) {
return $i->processStage2($i, $this->request);
} else {
if ($stage == 3) {
return $i->processStage3($i, $this->request);
} else {
if ($stage == 4) {
return $i->processStage4($i, $this->request);
} else {
return redirect()->route('home');
}
}
}
}
}
public function run()
{
// DB::table('info')->delete();
Info::create(array('info' => 'Esam muzicējoši jaunieši, kuri satikās folkloras kopā "Kokle". Visi dzīvojam Teikā, no kurienes arī mūsu nosaukums. Esam muzikāli instrumentāla apvienība, kuras dalībnieki katrs savā laikā pievienojās folkloras kopai Kokle. Gadu gaitā sapratām, ka esam labi sadziedājušies un saspēlējušies tāpēc nolēmām izveidot "Teikas Muzikantus".'));
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
Info::create($request->all());
return redirect('/profile/' . $request->user()->id);
}
public function updateAttendance(Request $request)
{
$course_id = $request->get('course_id');
$session_name = $request->get('session');
$day = $request->get('date');
$trainee_ids = Info::whereCourse_id($course_id)->lists('trainee_id');
foreach ($trainee_ids as $trainee_id) {
$attendance = Attendance::wheretrainee_id($trainee_id)->whereCourse_id($course_id)->whereSession_name($session_name)->where('day', '=', Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $day . ' 00:00:00'))->firstorFail();
$attendance->trainee_attendance = $request->get('ta__' . $trainee_id);
$attendance->update();
}
$presents = Attendance::whereCourse_id($course_id)->whereSession_name($session_name)->where('day', '=', Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $day . ' 00:00:00'))->where("trainee_attendance", "P")->select('trainee_id')->get();
$present_att = array();
$i = 0;
foreach ($presents as $present) {
$present = Info::whereTrainee_id($present->trainee_id)->select('name')->firstorFail();
$present_att[$i++] = $present->name;
}
$absents = Attendance::whereCourse_id($course_id)->whereSession_name($session_name)->where('day', '=', Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $day . ' 00:00:00'))->where("trainee_attendance", "A")->select('trainee_id')->get();
$absent_att = array();
$j = 0;
foreach ($absents as $absent) {
$absent = Info::whereTrainee_id($absent->trainee_id)->select('name')->firstorFail();
$absent_att[$j++] = $absent->name;
}
$course_name = $this->course_name_by_course_id($course_id);
$session = $request->get('session');
$date = $request->get('date');
return view('attendances.attendance_show', compact('present_att', 'absent_att'))->with('date', $date)->with('session', $session)->with('course_name', $course_name)->with('course_id', $course_id);
}
public function processStage4(Info $i, Request $request)
{
$info = Info::find($request->input('id'));
$check_released = is_null($request->input('released')) ? 'no' : 'yes';
$info->check_released = $check_released;
$info->track_no = $request->input('track_no');
$message = 'Record has been updated.';
// Move to stage 0
// Mark the last deadline to now/today to recognize 15 working days
// Calculate difference from first to last deadline dates
if ($check_released == 'yes' && $info->stage == 4) {
$info->stage = 0;
$info->claim_status = 'approved';
$info->l_deadline = \Carbon\Carbon::now('Asia/Manila');
$info->days_accomplished = $i->getDeadLineDifference($i, $info->f_deadline, $info->l_deadline);
$message = "Record has been updated. Congrats! The claimant has finished the new GIBX claim process.";
}
if ($info->save()) {
return redirect()->to('/encoded/desc')->with('message', $message);
} else {
return 'Something went wrong recording, please contact master Jim from GIBX';
}
}
public function trainee_by_user_id($trainee_id)
{
$trainee = Info::whereTrainee_login_id($trainee_id)->first();
return view('admin/admin_trainee/trainee_view')->with('trainee', $trainee);
}
public function getQuickReport()
{
$date = \Carbon\Carbon::today('Asia/Manila');
$excelName = 'Claims System Report ' . $date->format('d/m/Y');
\Excel::create($excelName, function ($excel) {
$excel->sheet('Quick Report', function ($sheet) {
// Change font style
$sheet->setStyle(array('font' => array('name' => 'Arial', 'size' => 10)));
// Change cells background color
$sheet->cells('A1:X1', function ($cells) {
$cells->setFontColor('#D0CBCB');
$cells->setBackground('#404040');
$cells->setFontWeight('bold');
});
// Populate data from model
$sheet->fromModel(\App\Info::all());
});
})->export('xlsx');
}
public function guest(Request $request)
{
$result = $this->check($request);
$id = $request->input('id');
$user = Info::where('user_id', $id)->first();
$user->username = User::find($id)->username;
$user->src = 'uploads/' . $user->head_photo;
$data = Goods::personal($id, 8, 'sending');
$news = Comments::newsCount($result['loginFlag'], $result['username']);
return view('pc.guest', ['key' => '', 'loginFlag' => $result['loginFlag'], 'username' => $result['username'], 'sentNum' => $news['sentNum'], 'mesNum' => $news['mesNum'], 'max' => $data['maxPage'], 'user' => $user, 'data' => $data['data']]);
}
public static function sign($id, $proId, $username)
{
$goods = self::where(['id' => $proId, 'receiver' => $username])->first();
if ($goods->update(['is_send' => 1])) {
$user = Info::where('user_id', $id)->first();
$user->score = $user->score + 10;
$user->inc_score = $user->inc_score + 10;
$user->save();
$user = Info::where('user_id', $id)->first();
$level = floor($user->score / 30) + 1;
$user->levell = $level;
$user->save();
return self::success();
}
return self::fail();
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update($slug, InfoFormRequest $request)
{
$info = Info::whereSlug($slug)->firstOrFail();
$info->name = $request->get('name');
$info->gender = $request->get('gender');
$info->trainee_id = $request->get('trainee_id');
$info->institution = $request->get('institution');
$info->educational_qualification = $request->get('educational_qualification');
$info->service_experience = $request->get('service_experience');
$info->experience_year = $request->get('experience_year');
$info->date_of_birth = $request->get('date_of_birth');
$info->birth_place = $request->get('birth_place');
$info->join_date = $request->get('join_date');
$info->guardians_name = $request->get('guardians_name');
$info->village = $request->get('village');
$info->post_office = $request->get('post_office');
$info->sub_district = $request->get('sub_district');
$info->district = $request->get('district');
$info->service_station = $request->get('service_station');
$info->marital = $request->get('marital');
$info->ph_home = $request->get('ph_home');
$info->ph_office = $request->get('ph_office');
$info->ph_mobile = $request->get('ph_mobile');
$info->soprts = $request->get('soprts');
$info->hobby = $request->get('hobby');
$info->interested_game = $request->get('interested_game');
$info->height = $request->get('height');
$info->weight = $request->get('weight');
$info->waist_abdomen = $request->get('waist_abdomen');
$info->chest = $request->get('chest');
$info->weight_end_course = $request->get('weight_end_course');
if ($request->get('status') != null) {
$info->status = 0;
} else {
$info->status = 1;
}
$info->save();
return redirect(action('InfosController@edit', $info->slug))->with('status', 'The trainees information has been updated!');
}
public function update_info($id, InfoFormRequest $request)
{
$input = $request->all();
$expertisearray = $input['expertise'];
$expertiseString = $request->get('expertise');
$expertise = serialize($expertiseString);
$diseasearray = $input['diseases'];
//return dd($diseasearray);
$diseasesString = $request->get('diseases');
$diseases = serialize($diseasesString);
//return dd($diseases);
//dd($diseases);
if (isset($input['image'])) {
$Image = $input['image'];
//dd($Image);
$imagePath = $this->imageUpload($Image);
//call public function imageUpload for small img
} else {
$imagePath = Info::where('id', '=', $id)->pluck('filepath');
//dd($imagePath);
}
$info = Info::whereId($id)->firstOrFail();
$info->name = $request->get('name');
$info->gender = $request->get('gender');
$info->trainee_id = $request->get('trainee_id');
$info->trainee_login_id = $request->get('trainee_login_id');
$info->institution = $request->get('institution');
$info->educational_qualification = $request->get('educational_qualification');
$info->service_experience = $request->get('service_experience');
$info->experience_year = $request->get('experience_year');
$info->date_of_birth = $request->get('date_of_birth');
$info->birth_place = $request->get('birth_place');
$info->join_date = $request->get('join_date');
$info->guardians_name = $request->get('guardians_name');
$info->village = $request->get('village');
$info->post_office = $request->get('post_office');
$info->sub_district = $request->get('sub_district');
$info->district = $request->get('district');
$info->service_station = $request->get('service_station');
$info->marital = $request->get('marital');
$info->ph_home = $request->get('ph_home');
$info->ph_office = $request->get('ph_office');
$info->ph_mobile = $request->get('ph_mobile');
$info->diseases = $diseases;
$info->soprts = $request->get('soprts');
$info->hobby = $request->get('hobby');
$info->expertise = $expertise;
$info->interested_game = $request->get('interested_game');
$info->height = $request->get('height');
$info->weight = $request->get('weight');
$info->waist_abdomen = $request->get('waist_abdomen');
$info->chest = $request->get('chest');
$info->weight_end_course = $request->get('weight_end_course');
$info->filepath = $imagePath;
if ($request->get('status') != null) {
$info->status = 0;
} else {
$info->status = 1;
}
$info->save();
return redirect(action('TrainersController@edit_profile', $info->id))->with('status', 'The trainees information has been updated!');
}
public function trainee_view_course_id($trainee_id)
{
$trainee = Info::find($trainee_id);
return view('admin/admin_trainee/trainee_view')->with('trainee', $trainee);
}
