/**
* Display a listing of the resource.
*
* @return json
*/
public function index()
{
$timesheets = Timesheet::all();
$response = array();
foreach ($timesheets as $key => $value) {
$item = array("id" => $value->id, "taskname" => $value->taskname, "start" => $value->start, "end" => $value->end, "project");
array_push($response, $item);
}
echo json_encode($response);
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$timesheet = \App\Timesheet::find($id)->with('employee', 'timesheet_details')->first();
$unique_codes_array = array_unique($timesheet->timesheet_details->lists('code_id')->toArray());
$timesheet_array = [];
foreach ($unique_codes_array as $code_id) {
$row = [$code_id];
foreach ($timesheet->timesheet_details as $details) {
if ($details->code_id == $code_id) {
$row[] = $details->hours_worked;
} else {
$row[] = '-';
}
}
$timesheet_array[] = $row;
}
$title = "Timesheet";
return view('timesheets.show', compact('title', 'timesheet', 'timesheet_array'));
}
protected function portalUpdateTimesheet() {
$authUserId = \Auth::id();
$authEmployee = Employee::where('userId','=',$authUserId)->first();
$empId = $authEmployee->id;
$timesheet = Timesheet::where('empId','=',$empId)->first();
$sun = Input::get('sunday');
$mon = Input::get('monday');
$tues = Input::get('tuesday');
$wed = Input::get('wednesday');
$thurs = Input::get('thursday');
$fri = Input::get('friday');
$sat = Input::get('saturday');
$total = $sun + $mon + $tues + $wed + $thurs + $fri + $sat;
$timesheet->sunday = $sun;
$timesheet->monday = $mon;
$timesheet->tuesday = $tues;
$timesheet->wednesday = $wed;
$timesheet->thursday = $thurs;
$timesheet->friday = $fri;
$timesheet->saturday = $sat;
$timesheet->total = $total;
$timesheet->updated_at = gmdate("Y-m-d H:i:s");
$timesheet->save();
return Redirect::to('/portal-timesheet');
}
<?php
$matiere = \App\Matter::where('id', $plan->matter_id)->first();
foreach ($matiere->lesteachers->unique() as $item) {
echo $item->nom_teacher;
}
?>
</td>
<td>
{{ $plan->dayname }}
</td>
<td>{{ substr(\Carbon\Carbon::parse($plan->time)->toTimeString(),0,-3) }}</td>
<td>
<?php
$salle = \App\Timesheet::where('classroom_id', $plan->classroom_id)->where('time', $plan->time)->where('user_id', \Auth::user()->id)->where('color', '#525252')->where('dayname', $plan->dayname)->first();
if ($salle) {
echo \Auth::user()->rooms()->where('id', $salle->room_id)->first()->nom_salle;
}
?>
</td>
<td>
<?php
$classroom = \App\Classroom::where('id', $plan->classroom_id)->first();
foreach ($classroom->lesNiveaux as $niveau) {
echo $niveau->niveau;
}
foreach ($classroom->levels as $niveau) {
/**
* Create a new user instance after a valid registration.
*
* @param array $data
* @return User
*/
protected function create(array $data)
{
$newUser = User::create([
'username' => $data['username'],
'password' => bcrypt($data['password']),
'created_at' => gmdate('Y-m-d H:i:s'),
'updated_at' => gmdate('Y-m-d H:i:s'),
'userTypeId' => $data['userTypeId']
]);
$userTypeId = $newUser->userTypeId;
if ( $userTypeId == 1 || $userTypeId == 2) {
$newEmployee = Employee::create([
'userId' => $newUser->id,
'firstName' => $data['firstName'],
'lastName' => $data['lastName'],
'email' => $data['email'],
'phone' => $data['phone'],
'streetAddress' => $data['streetAddress'],
'city' => $data['city'],
'state' => $data['state'],
'zipcode' => $data['zipcode'],
'ssn' => $data['ssn'],
'hourlyRate' => $data['hourlyRate'],
'primaryStoreId' => $data['primaryStoreId'],
'created_at' => gmdate('Y-m-d H:i:s'),
]);
$newTimesheet = Timesheet::create([
'userId' => $newUser->id,
'sunday' => 0,
'monday' => 0,
'tuesday' => 0,
'wednesday' => 0,
'thursday' => 0,
'friday' => 0,
'saturday' => 0,
'total' => 0,
'created_at' => gmdate('Y-m-d H:i:s'),
]);
}
if ( $userTypeId == 3 ) {
if( array_key_exists('accountId', $data) ) {
$newContact = Contact::create([
'userId' => $newUser->id,
'accountId' => $data['accountId'],
'firstName' => $data['firstName'],
'lastName' => $data['lastName'],
'email' => $data['email'],
'phone' => $data['phone'],
'contactTypeId' => $data['contactTypeId']
]);
} else {
$newAccount = Account::create([
'companyName' => $data['companyName'],
'streetAddress' => $data['streetAddress'],
'city' => $data['city'],
'state' => $data['state'],
'zipcode' => $data['zipcode'],
'accountStatus' => $data['accountStatus'],
]);
$accntId = $newAccount->id;
$newContant = Contact::create([
'empId' => $newEmployee->id,
'accountId' => $accntId,
'firstName' => $data['firstName'],
'lastName' => $data['lastName'],
'email' => $data['email'],
'phone' => $data['phone'],
'contactTypeId' => $data['contactTypeId']
]);
$newBalance = Balance::create([
'accountId' => $accntId,
'balance' => 0.00
]);
}
}
return $newUser;
}
public function trierparsalle()
{
if (\Request::ajax()) {
$room_id = \Input::get('room_id');
$plans = Timesheet::where('user_id', \Auth::user()->id)->CurrentYear()->where('matter_id', '!=', 0)->get();
foreach ($plans as $plan) {
$salle = Timesheet::where("classroom_id", $plan->classroom_id)->where("time", $plan->time)->where("user_id", \Auth::user()->id)->where("color", "#525252")->where("dayname", $plan->dayname)->CurrentYear()->first();
if ($salle && $salle->room_id == $room_id) {
echo '<tr>';
echo ' <td> ' . Classroom::where('id', $plan->classroom_id)->CurrentYear()->first()->nom_classe . '</td>';
echo ' <td>
' . Matter::where('id', $plan->matter_id)->first()->nom_matiere . '
</td>';
echo ' <td>';
foreach (Matter::where('id', $plan->matter_id)->first()->lesteachers->unique() as $item) {
echo $item->nom_teacher;
}
echo '</td>';
echo '<td>';
echo $plan->dayname;
echo '</td>';
echo '<td>';
echo substr(Carbon::parse($plan->time)->toTimeString(), 0, -3);
echo '</td>';
echo '<td>';
$salle = Timesheet::where("classroom_id", $plan->classroom_id)->where("time", $plan->time)->where("user_id", \Auth::user()->id)->where("color", "#525252")->CurrentYear()->where("dayname", $plan->dayname)->first();
if ($salle) {
echo \Auth::user()->rooms()->where('id', $salle->room_id)->first()->nom_salle;
}
echo '</td>';
echo '<td>';
$classroom = Classroom::where('id', $plan->classroom_id)->CurrentYear()->first();
foreach ($classroom->lesNiveaux as $niveau) {
echo $niveau->niveau;
}
foreach ($classroom->levels as $niveau) {
echo $niveau->niveau;
}
echo '</td>';
echo '<td>';
$classroom = Classroom::where('id', $plan->classroom_id)->CurrentYear()->first();
if ($classroom->branches->isEmpty()) {
echo '--';
} else {
foreach ($classroom->branches as $br) {
echo $br->nom_branche;
}
}
echo '</td>';
echo ' </tr>';
}
}
}
}
public function del()
{
if (\Request::ajax()) {
$id = \Input::get('id');
$ok = Timesheet::where('user_id', \Auth::user()->id)->where('id', $id)->first();
$ok->delete();
}
}
public function showef($id)
{
$ts = Timesheet::where('classroom_id', $id)->first();
return view('classrooms.showef', compact('ts'));
}
protected function portalResetTimesheet($id) {
if ( \Auth::user() ) {
$userTypeID = \Auth::user()->userTypeId;
if ( $userTypeID == 1 ) {
$authUserId = \Auth::id();
$authEmployee = Employee::where('userId','=',$authUserId)->first();
$empId = $id;
$timesheet = Timesheet::where('empId','=',$empId)->first();
$timesheet->sunday = 0;
$timesheet->monday = 0;
$timesheet->tuesday = 0;
$timesheet->wednesday = 0;
$timesheet->thursday = 0;
$timesheet->friday = 0;
$timesheet->saturday = 0;
$timesheet->total = 0;
$timesheet->save();
return Redirect::to('/portal-emp-timesheets/' . $empId);
} else if ( $userTypeID == 2 ) {
return Redirect::to('/portal-settings');
} else {
return Redirect::to('/account');
}
} else {
return Redirect::to('/');
}
}
