public function searchAction()
 {
     $numberPage = 1;
     if ($this->request->isPost()) {
         $query = Criteria::fromInput($this->di, "Companies", $_POST);
         $this->persistent->searchParams = $query->getParams();
     } else {
         $numberPage = $this->request->getQuery("page", "int");
         if ($numberPage <= 0) {
             $numberPage = 1;
         }
     }
     $parameters = array();
     if ($this->persistent->searchParams) {
         $parameters = $this->persistent->searchParams;
     }
     $companies = Department::find($parameters);
     if (count($companies) == 0) {
         $this->flash->notice("没有找到对应的部门");
         return $this->forward("companies/index");
     }
     $paginator = new Phalcon\Paginator\Adapter\Model(array("data" => $companies, "limit" => 10, "page" => $numberPage));
     $page = $paginator->getPaginate();
     $this->view->setVar("page", $page);
     $this->view->setVar("companies", $companies);
 }
 public function all()
 {
     if (\KodeInfo\Utilities\Utils::isDepartmentAdmin(Auth::user()->id)) {
         $department_admin = DepartmentAdmins::where('user_id', Auth::user()->id)->first();
         $department = Department::where('id', $department_admin->department_id)->first();
         $company = Company::where('id', $department->company_id)->first();
         $messages = CannedMessages::where('company_id', $company->id)->where('department_id', $department->id)->orderBy('id', 'desc')->get();
     } elseif (\KodeInfo\Utilities\Utils::isOperator(Auth::user()->id)) {
         $department_admin = OperatorsDepartment::where('user_id', Auth::user()->id)->first();
         $department = Department::where('id', $department_admin->department_id)->first();
         $company = Company::where('id', $department->company_id)->first();
         $messages = CannedMessages::where('company_id', $company->id)->where('department_id', $department->id)->where('operator_id', Auth::user()->id)->orderBy('id', 'desc')->get();
     } else {
         $messages = CannedMessages::orderBy('id', 'desc')->get();
     }
     foreach ($messages as $message) {
         $operator = User::find($message->operator_id);
         $department = Department::find($message->department_id);
         $company = Company::find($message->company_id);
         $message->operator = $operator;
         $message->department = $department;
         $message->company = $company;
     }
     $this->data['messages'] = $messages;
     return View::make('canned_messages.all', $this->data);
 }
 public function indexAction()
 {
     $departments = Department::find();
     $this->view->departments = $departments;
     $employees = Employee::find();
     $this->view->employees = $employees;
 }
Exemple #4
0
 public static function getDepartmentPermissions($department_id)
 {
     $department = Department::find($department_id);
     $permissions_keys = explode(",", $department->permissions);
     $permissions = Permissions::whereIn('key', $permissions_keys)->get();
     return $permissions;
 }
 public function detail()
 {
     $department = Department::find(Input::get('department_id'));
     if ($department) {
         $this->set_template('hospital.department.detail');
         $this->set_data(array('name' => $department->name, 'photo' => $department->photo, 'content' => $department->description));
         // Json response:
         //     Remove html tags
         $this->set_postprocess_function('json', function ($result, $status) {
             if ($status) {
                 $result['content'] = strip_tags($result['content']);
             }
             return $result;
         });
         // Html response:
         //     add some information
         $this->set_postprocess_function('html', function ($result, $status) use($department) {
             if ($status) {
                 $chief_doctor = $department->doctors()->where('is_chief', true)->first();
                 $hospital_name = $department->hospital()->first()->name;
                 $result['photo'] = $department->photo;
                 $result['hospital_name'] = $hospital_name;
                 if (isset($chief_doctor)) {
                     $result['doctor'] = array('photo' => $chief_doctor->photo, 'description' => $chief_doctor->description, 'specialty' => $chief_doctor->specialty);
                 }
             }
             return $result;
         });
     } else {
         $this->set_error_code($this->not_found_error_code);
     }
     return $this->response();
 }
 public function showSpecificDepartment()
 {
     $departmentIDInput = Input::get('department-dropdown');
     $department = Department::find($departmentIDInput);
     $departmentprograms = $department->programs()->where('degreelevel', 'U')->whereNotIn('programid', array(62, 66, 38))->get();
     //ave students per year and ave difference
     $programids = $department->programs()->whereNotIn('programid', array(62, 66, 38))->where('degreelevel', 'U')->lists('programid');
     //To get batches of program whithin 2000-2009
     $yearsArray = Studentterm::whereIn('programid', $programids)->where('year', '>', 1999)->where('year', '<', 2014)->groupBy('year')->orderBy('year', 'asc')->lists('year');
     $yearlyStudentAverage = [];
     $departmentProgramsAverage = [];
     foreach ($yearsArray as $yearData) {
         $aveStudents = round($department->getYearlyAveStudents($yearData), 2);
         if ($aveStudents > 1) {
             $yearlyStudentAverage[$yearData] = $aveStudents;
         }
     }
     foreach ($departmentprograms as $departmentprogram) {
         $departmentProgramsAverage[$departmentprogram->programtitle] = round($departmentprogram->getAveStudents(), 2);
     }
     $batchAttrition = $department->getBatchAttrition();
     $programsAttrition = $department->getProgramsAveBatchAttrition();
     $aveAttrition = $department->getAveAttrition();
     $aveShiftRate = $department->getAveShiftRate();
     $aveYearsBeforeDropout = $department->getAveYearsBeforeDropout();
     $aveYearsBeforeShifting = $department->getAveYearsBeforeShifting();
     $gradeCount = $department->getGradeCount();
     $shiftGradeCount = $department->getShiftGradeCount();
     $stbracketCount = $department->getSTBracketCount();
     $shiftBracketCount = $department->getShiftSTBracketCount();
     return View::make('department.department-specific', ['department' => $department, 'yearlyStudentAverage' => $yearlyStudentAverage, 'departmentprograms' => $departmentprograms, 'departmentProgramsAverage' => $departmentProgramsAverage, 'aveAttrition' => $aveAttrition, 'batchAttrition' => $batchAttrition, 'aveShiftRate' => $aveShiftRate, 'aveYearsBeforeDropout' => $aveYearsBeforeDropout, 'aveYearsBeforeShifting' => $aveYearsBeforeShifting, 'programsAttrition' => $programsAttrition, 'gradeCount' => $gradeCount, 'shiftGradeCount' => $shiftGradeCount, 'stbracketCount' => $stbracketCount, 'shiftBracketCount' => $shiftBracketCount]);
 }
 /**
  * @desc - สร้างฟอร์มสำหรับ่ข้อมูลพนักงานที่เรียกดู
  * @return object
  */
 public function editFormAction($SSN)
 {
     $employee = Employee::findFirst(array("conditions" => "SSN=?0", "bind" => array($SSN)));
     $this->tag->setDefault('SSN', $employee->SSN);
     $this->tag->setDefault('FNAME', $employee->FNAME);
     $this->tag->setDefault('LNAME', $employee->LNAME);
     $this->tag->setDefault('DNO', $employee->DNO);
     $this->view->department = Department::find();
 }
 function getDepartmentList($compCode)
 {
     App::import("Model", "Department");
     $model = new Department();
     $con2 = $model->find('list', array('fields' => array('Department.dept_code', 'Department.dept_name'), 'conditions' => array('Department.comp_code' => $compCode)));
     if (empty($con2)) {
         return 0;
     } else {
         return $con2;
     }
 }
 /**
  * Departments tree
  * 
  * @return \View
  */
 public function getIndex($department_id = NULL)
 {
     $department = NULL;
     if ($department_id) {
         $department = Department::find($department_id);
     }
     $root = Department::find(1);
     $tree = $root->getNestedList("name", NULL, "- ");
     $items = Position::select(["positions.id", "positions.name", "departments.name as department_name", DB::RAW("(SELECT COUNT(*) FROM users WHERE users.position_id = positions.id) as count_users"), "positions.chief_position_id"])->leftjoin("departments", "departments.id", "=", "positions.department_id")->wheredepartment($department)->orderBy("departments.name")->orderBy("positions.name")->paginate(50);
     $departments = Department::whereNotNull("parent_id")->orderBy("name")->get();
     $content = View::make("positions/list", ["department" => $department, "departments" => $departments, "tree" => $tree, "items" => $items]);
     return View::make("common/tpl", array("template" => $content));
 }
 public function select_doctor()
 {
     $department = Department::find(Input::get('department_id'));
     if (!isset($department)) {
         // ..
     }
     $doctors = $department->doctors;
     if (!isset($doctors)) {
         // ..
     }
     foreach ($doctors as $doctor) {
         $doctor['title'] = $doctor->title;
     }
     return View::make('register.select_doctor', array('hospital_name' => $department->hospital->name, 'department' => $department, 'doctors' => $doctors));
 }
 function test_find()
 {
     //Arrange
     $name = "Biology";
     $address = "346 Stupid Avenue";
     $test_department = new Department($name, $address);
     $test_department->save();
     $name2 = "Chemiology";
     $address2 = "55 Bo Ct";
     $test_department2 = new Department($name2, $address2);
     $test_department2->save();
     //Act
     $result = Department::find($test_department2->getId());
     //Assert
     $this->assertEquals($test_department2, $result);
 }
 public function get_doctors()
 {
     $department = Department::find(Input::get('department_id'));
     if (!isset($department)) {
         return Response::json(array('error_code' => 1, 'message' => '不存在该诊室'));
     }
     $doctors = $department->doctors;
     if (!isset($doctors)) {
         return Response::json(array('error_code' => 2, 'message' => '该诊室无医生...'));
     }
     $result = array();
     foreach ($doctors as $doctor) {
         $result[] = array('id' => $doctor->id, 'name' => $doctor->name, 'title' => $doctor->title, 'photo' => $doctor->photo, 'specialty' => strip_tags($doctor->specialty), 'can_be_registered' => $this->can_be_registered($doctor->id), 'is_consultable' => $doctor->is_consultable);
     }
     return Response::json(array('error_code' => 0, 'doctors' => $result));
 }
 function testFind()
 {
     //Arrange
     $name = "Math";
     $id = 1;
     $test_department = new Department($name, $id);
     $test_department->save();
     $name2 = "Business";
     $id2 = 2;
     $test_department2 = new Department($name2, $id2);
     $test_department2->save();
     //Act
     $id = $test_department->getId();
     $result = Department::find($id);
     //Assert
     $this->assertEquals($test_department, $result);
 }
 public function downloadTable($id, $year, $month)
 {
     $contents = "DATA ABSENSI BINA BAKTI\n\n";
     $department = Department::find($id);
     $contents .= "Unit: ," . $department->name . "\n";
     $months = MyDate::get_month_names();
     $contents .= "Bulan: ," . $months[$month - 1] . "\n";
     $contents .= "Tahun: ," . $year . "\n\n";
     $contents .= "KODE,NAMA,NORMAL,,PULANG AWAL,,,TERLAMBAT,LUPA,TUGAS LUAR,,OTHER,TIDAK MASUK,,,JUMLAH HARI MASUK,,JUMLAH HARI TIDAK MASUK,NOMINAL UANG KONSUMSI\n";
     $contents .= ",,WEEKDAY,WEEKEND,WEEKDAY < 12,WEEKDAY >= 12,WEEKEND,,,WEEKDAY,WEEKEND,,SAKIT,IZIN,ALPHA,WEEKDAY,WEEKEND,,WEEKDAY,WEEKEND,PULANG AWAL,TOTAL\n";
     $employees = Employee::where('department_id', '=', $id)->orderBy('name')->get();
     $total = 0;
     foreach ($employees as $employee) {
         $contents .= $employee->ssn . ",";
         $contents .= $employee->name . ",";
         $data = Session::pull($employee->id, 'default');
         $total += $data['konsumsi_total'];
         $contents .= $data['normal_weekday'] . ",";
         $contents .= $data['normal_weekend'] . ",";
         $contents .= $data['pulang_awal_weekday_before_12'] . ",";
         $contents .= $data['pulang_awal_weekday'] . ",";
         $contents .= $data['pulang_awal_weekend'] . ",";
         $contents .= $data['terlambat'] . ",";
         $contents .= $data['lupa'] . ",";
         $contents .= $data['tugas_luar_weekday'] . ",";
         $contents .= $data['tugas_luar_weekend'] . ",";
         $contents .= $data['other'] . ",";
         $contents .= $data['sakit'] . ",";
         $contents .= $data['izin'] . ",";
         $contents .= $data['alpha'] . ",";
         $contents .= $data['masuk_weekday'] . ",";
         $contents .= $data['masuk_weekend'] . ",";
         $contents .= $data['tidak_masuk'] . ",";
         $contents .= $data['konsumsi_weekday'] . ",";
         $contents .= $data['konsumsi_weekend'] . ",";
         $contents .= $data['konsumsi_pulang_awal'] . ",";
         $contents .= $data['konsumsi_total'] . ",";
         $contents .= "\n";
     }
     $contents .= ",,,,,,,,,,,,,,,,,,,,," . $total;
     //        $file_name = "allowance.csv";
     $file = public_path() . "/download/allowance.csv";
     File::put($file, $contents);
     return Response::download($file, "allowance-" . strtolower($department->name) . "-" . $month . "-" . $year . ".csv", array('Content-Type' => 'text/csv', 'Content-Disposition' => 'attachment;'));
 }
 public function __construct()
 {
     $this->beforeFilter(function () {
         if (!Session::has('deptIdForPC')) {
             if (Auth::check()) {
                 if (Helpers::isDeptAdminOrHigher()) {
                     Session::put('deptIdForPC', Auth::user()->current_department);
                     Session::put('deptNameForPC', Department::find(Session::get('deptIdForPC'))->long_name);
                 } else {
                     if (Request::header('Referer') != URL::to('/') . '/dashboard') {
                         return "Invalid Session";
                     }
                 }
             } else {
                 return "Invalid Session";
             }
         }
     });
 }
 public function getOperators($company_id)
 {
     $department_ids = Department::where('company_id', $company_id)->lists('id');
     $operators = [];
     if (sizeof($department_ids) > 0) {
         $operator_ids = OperatorsDepartment::whereIn('department_id', $department_ids)->lists('user_id');
         if (sizeof($operator_ids) > 0) {
             $operators = User::whereIn('id', $operator_ids)->get();
         }
     }
     foreach ($operators as $operator) {
         $department_id = OperatorsDepartment::where('user_id', $operator->id)->pluck("department_id");
         $department = Department::find($department_id);
         $company = Company::find($department->company_id);
         $operator->department = $department;
         $operator->company = $company;
     }
     $this->data['operators'] = $operators;
     return View::make('companies.operators', $this->data);
 }
 /**
  * Remove the specified resource from storage.
  * DELETE /department/{id}
  *
  * @param  int  $id
  * @return Response
  */
 public function destroy($id)
 {
     $department = Department::find($id)->delete();
     if (is_null($department)) {
         $class = 'error';
         $message = 'Record does not exist.';
     } else {
         $class = 'success';
         $message = 'Record successfully deleted.';
     }
     return Redirect::route('department.index')->with('class', $class)->with('message', $message);
 }
 public function findAllDepartmentName($comp_code = null)
 {
     App::import("Model", "Department");
     $model = new Department();
     if (empty($comp_code)) {
         $conditions = array('comp_code' => $comp_code);
     } else {
         $conditions = array();
     }
     $dept_name = $model->find("list", array('fields' => array('Department.dept_code', 'Department.dept_name'), 'conditions' => $conditions));
     if (!empty($dept_name)) {
         return $dept_name;
     } else {
         return false;
     }
 }
 /**
  * Show the form for editing the specified branch.
  *
  * @param  int  $id
  * @return Response
  */
 public function edit($id)
 {
     $department = Department::find($id);
     return View::make('departments.edit', compact('department'));
 }
							</div>
						<div style="padding-top:20px;"></div><button class="btn btn-success">
						<i class="glyphicon glyphicon-filter"></i> Filter</button>
						{{ Form::token() }}

					</form>




			@if(empty($users))
				<br>No record
			@else
				@if($deptid != "*")
					<?php 
$dept = Department::find($deptid);
?>
					<h2><label>Department: </label> {{ $dept->name }}</h2>
				@else
					<h2><label>Department: </label> All Departments</h2>
				@endif
				
				<h2><label>Years Working: </label> {{$yearString}}</h2>				

							<div class="col-md-2">
								<div style="padding-top:20px;"></div><a href="{{ route('ems-reports-pdf') }}" class="btn btn-primary" target="_blank">
									<i class="fa fa-print"></i> Print</a>
							</div>
							<div class="col-md-offset-9"> <h3 style="color:green;">{{ $users->count()}} records found. </h3></div>
						
								
@extends('layouts.admin.default')

@section('content')

<?php 
$departmentCount = Department::count();
$departments = Department::paginate(10);
$departmentDelete = Department::find($id);
$message = Session::get('message');
?>

<div class="page-container">

        <div class="row" style="padding-bottom:20px;">

          <div class="col-md-2 clearfix">

            <aside class="sidebar">
              <nav class="sidebar-nav">
                <ul id="menu">
                  <li>
                    <a href="{{ url('/admin/dashboard') }}">
                      <span class="sidebar-nav-item-icon fa fa-tachometer fa-lg"></span>                      
                      <span class="sidebar-nav-item">Dashboard</span>                      
                    </a>
                    
                  </li>
                  <li>
                    <a href="#">
                      <span class="sidebar-nav-item-icon fa fa-users fa-lg"></span>                      
                      <span class="sidebar-nav-item">Employees</span>                      
 public function save_department()
 {
     $id = Input::get('id');
     $store_id = Input::get('store_id');
     $department = Department::find($id);
     if (!$department) {
         $department = new Department();
     }
     $department->name = Input::get('name');
     $department->store_id = $store_id;
     $department->save();
     $message = "Successfully updated the department";
     $type = "success";
     return Redirect::to('/admin/store/' . $store_id . '/departments')->with('type', $type)->with('message', $message);
 }
 public function chooseDepartmentPost()
 {
     $rules = array('currentDepartment' => 'required');
     $validator = Validator::make(Input::all(), $rules);
     if ($validator->fails()) {
         return Redirect::to('cd')->with('cd_errors', true);
     } else {
         if (!Department::find(Input::get('currentDepartment'))) {
             return Redirect::to('cd')->with('cd_errors', true);
         }
         $user = Auth::user();
         $user->current_department = Input::get('currentDepartment');
         $user->save();
         return Redirect::to('dashboard');
     }
 }
 /**
  * Remove the specified resource from storage.
  * DELETE /department/{id}
  *
  * @param  int  $id
  * @return Response
  */
 public function destroy($id)
 {
     $barang = Department::find($id);
     $barang->delete();
     // redirect
     Session::flash('message', 'Successfully deleted Department!');
     return Redirect::to('department');
     //
 }
 /**
  * Delete department from DB.  Cannot delete one that's in use.
  *
  * @param $id
  * @return mixed
  */
 public function deleteDept($id)
 {
     $dept = Department::find($id);
     if (count($dept->employees()->get()->toArray())) {
         return Redirect::back()->with('danger_flash_message', 'You cannot delete a department that is in use.');
     }
     $dept->delete();
     return Redirect::route('manageDepartments')->with('flash_message', 'Department ' . $dept->name . ' has been deleted');
 }
					<td>{{	$property->properties->id }}</td>
					<td><a href="{{ route('view-property', $property->properties_id) }}">{{	$property->properties->propname }} </a></td>
					<td>
					<?php 
$cat = PropertyCategory::find($property->cat_id);
?>
	
																	
						{{ $cat->catname }}

					</td>
					<td>{{	$property->properties->propcondition }}</td>
					<td>{{	$property->user->formatName(':fn :ln') }}</td>
					<td>
				<?php 
$dept = Department::find($property->dept_id);
?>
	
																	
						{{ $dept->name }}
					</td>
					<td>{{	$property->properties->par  }}</td>
					<td>{{	$property->formatTimeAssign()}}</td>
					<td>
						<a href="{{ route('remove-accountability', $property->id) }}" class="btn btn-primary" style="float: right;"><span class="fa fa-arrows-h"></span>Transfer</a>
				
					</td>
				</tr>
				@endforeach	

			</tbody>
 public function search()
 {
     $paginatorFilter = "";
     if (Input::has('busq')) {
         $busq = Input::get('busq');
         $auxLider = Publicaciones::leftJoin('categoria', 'categoria.id', '=', 'publicaciones.categoria')->leftJoin('usuario', 'usuario.id', '=', 'publicaciones.user_id')->leftJoin('departamento', 'publicaciones.departamento', '=', 'departamento.id')->where('publicaciones.status', '=', 'Aprobado')->where('publicaciones.deleted', '=', 0)->where(function ($query) {
             $query->where('publicaciones.ubicacion', '=', 'Categoria')->orWhere('publicaciones.ubicacion', '=', 'Ambos');
         })->where(function ($query) {
             $query->where('publicaciones.fechFin', '>=', date('Y-m-d'))->orWhere('publicaciones.fechFinNormal', '>=', date('Y-m-d'));
         })->where(function ($query) use($busq) {
             $query->whereRaw("LOWER(`publicaciones`.`titulo`) LIKE  '%" . strtolower($busq) . "%'")->orWhereRaw("LOWER(`publicaciones`.`pag_web`) LIKE  '%" . strtolower($busq) . "%'")->orWhereRaw("LOWER(`categoria`.`desc`) LIKE  '%" . strtolower($busq) . "%'");
         });
         $auxRes = Publicaciones::leftJoin('categoria', 'publicaciones.categoria', '=', 'categoria.id')->leftJoin('departamento', 'publicaciones.departamento', '=', 'departamento.id')->leftJoin('usuario', 'usuario.id', '=', 'publicaciones.user_id')->where(function ($query) use($busq) {
             $query->whereRaw("LOWER(`publicaciones`.`titulo`) LIKE  '%" . strtolower($busq) . "%'")->orWhereRaw("LOWER(`departamento`.`nombre`) LIKE  '%" . strtolower($busq) . "%'")->orWhereRaw("LOWER(`categoria`.`desc`) LIKE  '%" . strtolower($busq) . "%'");
         })->where(function ($query) {
             $query->where('publicaciones.fechFin', '>=', date('Y-m-d'))->orWhere('publicaciones.fechFinNormal', '>=', date('Y-m-d'));
         })->where('publicaciones.tipo', '!=', 'Lider')->where('publicaciones.status', '=', 'Aprobado')->where('publicaciones.deleted', '=', 0);
         /*Se agrega*/
         if (Input::has('filter')) {
             $filter = Input::get('filter');
             if ($filter != -1) {
                 $filter = Department::find(Input::get('filter'));
                 $auxRes = $auxRes->where('publicaciones.departamento', '=', $filter->id);
                 $paginatorFilter .= '&filter=' . $filter->id;
             } else {
                 $filter = "";
             }
         }
         if (Input::has('min') || Input::has('max')) {
             $min = Input::get('min');
             $max = Input::get('max');
             $currency = Input::get('currency');
             if (!is_null($min) && !is_null($max) && !empty($min) && !empty($max)) {
                 $minmax = array($min, $max);
                 $paginatorFilter .= '&min=' . $min . '&max=' . $max . '&currency=' . $currency;
                 $auxLider = $auxLider->where('publicaciones.moneda', '=', $currency)->where('publicaciones.precio', '>=', $min)->whereRaw('`publicaciones`.`precio` <= ' . $max);
                 $auxRes = $auxRes->where('publicaciones.precio', '>=', $min)->whereRaw('`publicaciones`.`precio` <= ' . $max)->where('publicaciones.moneda', '=', $currency);
             } else {
                 if (!is_null($max) && !empty($max)) {
                     $minmax = array('', $max);
                     $paginatorFilter .= '&max=' . $max . '&currency=' . $currency;
                     $auxLider = $auxLider->where('publicaciones.moneda', '=', $currency)->whereRaw('`publicaciones`.`precio` <= ' . $max);
                     $auxRes = $auxRes->whereRaw('`publicaciones`.`precio` <= ' . $max)->where('publicaciones.moneda', '=', $currency);
                 } elseif (!is_null($min) && !empty($min)) {
                     $minmax = array($min, '');
                     $paginatorFilter .= '&min=' . $min . '&currency=' . $currency;
                     $auxLider = $auxLider->where('publicaciones.moneda', '=', $currency)->where('precio', '>=', $min);
                     $auxRes = $auxRes->where('publicaciones.moneda', '=', $currency)->where('publicaciones.precio', '>=', $min);
                 }
             }
         }
         if (Input::has('rel')) {
             $rel = Input::get('rel');
             switch ($rel) {
                 case 'rep':
                     $auxLider = $auxLider->orderBy('usuario.reputation', 'DESC');
                     $auxRes = $auxRes->orderBy('usuario.reputation', 'DESC');
                     $paginatorFilter .= '&rel=rep';
                     break;
                 case 'fin':
                     $auxLider = $auxLider->orderBy('publicaciones.fechFin', 'ASC')->orderBy('publicaciones.fechFinNormal', 'ASC');
                     $auxRes = $auxRes->orderBy('publicaciones.fechFin', 'ASC')->orderBy('publicaciones.fechFinNormal', 'ASC');
                     $paginatorFilter .= '&rel=fin';
                     break;
                 case 'ini':
                     $auxLider = $auxLider->orderBy('publicaciones.fechIni', 'DESC')->orderBy('publicaciones.fechIniNormal', 'DESC');
                     $auxRes = $auxRes->orderBy('publicaciones.fechIni', 'DESC')->orderBy('publicaciones.fechIniNormal', 'DESC');
                     $paginatorFilter .= '&rel=ini';
                     break;
                 default:
                     break;
             }
         }
         if (Input::has('cond')) {
             $cond = Input::get('cond');
             $paginatorFilter .= '&cond=' . $cond;
             $auxRes = $auxRes->where('publicaciones.condicion', '=', strtolower($cond));
         }
         if (Input::has('buss')) {
             $buss = Input::get('buss');
             $paginatorFilter .= '&buss=' . $buss;
             $auxLider = $auxLider->where('publicaciones.bussiness_type', '=', strtolower($buss));
             $auxRes = $auxRes->where('publicaciones.bussiness_type', '=', strtolower($buss));
         }
         $lider = $auxLider->get($this->toReturn);
         $res = $auxRes->paginate(5, $this->toReturn);
         $categorias = Categorias::where('id', '=', $busq)->pluck('desc');
         if (!is_null($categorias)) {
             $busq = $categorias;
         } else {
             $busq = $busq;
         }
         $departamentos = Department::get();
         $view = array('publicaciones' => $res, 'busq' => $busq, 'lider' => $lider, 'departamento' => $departamentos, 'paginatorFilter' => $paginatorFilter);
         if (isset($filter)) {
             $view = $view + array('filter' => $filter);
         }
         if (isset($currency)) {
             $view = $view + array('minmax' => $minmax, 'currency' => $currency);
         }
         if (isset($cond)) {
             $view = $view + array('cond' => $cond);
         }
         if (isset($buss)) {
             $view = $view + array('buss' => $buss);
         }
         if (isset($rel)) {
             $view = $view + array('rel' => $rel);
         }
         return Response::json($view);
     } elseif (Input::has('cat')) {
         $id = Input::geT('cat');
         /*Query inicial*/
         $auxLider = Publicaciones::leftJoin('usuario', 'usuario.id', '=', 'publicaciones.user_id')->leftJoin('departamento', 'publicaciones.departamento', '=', 'departamento.id')->where('publicaciones.status', '=', 'Aprobado')->where('publicaciones.deleted', '=', 0)->where(function ($query) {
             $query->where('publicaciones.ubicacion', '=', 'Categoria')->orWhere('publicaciones.ubicacion', '=', 'Ambos');
         })->where(function ($query) {
             $query->where('publicaciones.fechFin', '>=', date('Y-m-d'))->orWhere('publicaciones.fechFinNormal', '>=', date('Y-m-d'));
         })->where('publicaciones.categoria', '=', $id);
         //->get(array('id','img_1','titulo','precio','moneda'));
         $auxRes = Publicaciones::leftJoin('departamento', 'publicaciones.departamento', '=', 'departamento.id')->leftJoin('usuario', 'usuario.id', '=', 'publicaciones.user_id')->where('publicaciones.status', '=', 'Aprobado')->where('publicaciones.categoria', '=', $id)->where('publicaciones.tipo', '!=', 'Lider')->where('publicaciones.deleted', '=', 0)->where(function ($query) {
             $query->where('publicaciones.ubicacion', '=', 'Categoria')->orWhere('publicaciones.ubicacion', '=', 'Ambos');
         })->where(function ($query) {
             $query->where('publicaciones.fechFin', '>=', date('Y-m-d', time()))->orWhere('publicaciones.fechFinNormal', '>=', date('Y-m-d', time()));
         });
         /*Se agrega*/
         if (Input::has('filter')) {
             $filter = Input::get('filter');
             if ($filter != -1) {
                 $filter = Department::find(Input::get('filter'));
                 $auxRes = $auxRes->where('publicaciones.departamento', '=', $filter->id);
                 $paginatorFilter .= '&filter=' . $filter->id;
             } else {
                 $filter = "";
             }
         }
         if (Input::has('min') || Input::has('max')) {
             $min = Input::get('min');
             $max = Input::get('max');
             $currency = Input::get('currency');
             if (!is_null($min) && !is_null($max) && !empty($min) && !empty($max)) {
                 $minmax = array($min, $max);
                 $paginatorFilter .= '&min=' . $min . '&max=' . $max . '&currency=' . $currency;
                 $auxLider = $auxLider->whereRaw('`publicaciones`.`precio` >= ' . $min)->whereRaw('`publicaciones`.`precio` <= ' . $max)->where('moneda', '=', $currency);
                 $auxRes = $auxRes->whereRaw('`publicaciones`.`precio` >= ' . $min)->whereRaw('`publicaciones`.`precio` <= ' . $max)->where('publicaciones.moneda', '=', $currency);
             } else {
                 if (!is_null($max) && !empty($max)) {
                     $minmax = array('', $max);
                     $paginatorFilter .= '&max=' . $max . '&currency=' . $currency;
                     $auxLider = $auxLider->where('moneda', '=', $currency)->whereRaw('`publicaciones`.`precio` <= ' . $max);
                     $auxRes = $auxRes->whereRaw('`publicaciones`.`precio` <= ' . $max)->where('publicaciones.moneda', '=', $currency);
                 } elseif (!is_null($min) && !empty($min)) {
                     $minmax = array($min, '');
                     $paginatorFilter .= '&min=' . $min . '&currency=' . $currency;
                     $auxLider = $auxLider->whereRaw('`publicaciones`.`precio` >= ' . $min)->where('moneda', '=', $currency);
                     $auxRes = $auxRes->where('publicaciones.moneda', '=', $currency)->whereRaw('`publicaciones`.`precio` >= ' . $min);
                 }
             }
         }
         if (Input::has('rel')) {
             $rel = Input::get('rel');
             switch ($rel) {
                 case 'rep':
                     $auxLider = $auxLider->leftJoin('usuario', 'usuario.id', '=', 'publicaciones.user_id')->orderBy('usuario.reputation', 'DESC');
                     $auxRes = $auxRes->leftJoin('usuario', 'usuario.id', '=', 'publicaciones.user_id')->orderBy('usuario.reputation', 'DESC');
                     $paginatorFilter .= '&rel=rep';
                     break;
                 case 'fin':
                     $auxLider = $auxLider->orderBy('publicaciones.fechFin', 'ASC')->orderBy('publicaciones.fechFinNormal', 'ASC');
                     $auxRes = $auxRes->orderBy('publicaciones.fechFin', 'ASC')->orderBy('publicaciones.fechFinNormal', 'ASC');
                     $paginatorFilter .= '&rel=fin';
                     break;
                 case 'ini':
                     $auxLider = $auxLider->orderBy('publicaciones.fechIni', 'DESC')->orderBy('publicaciones.fechIniNormal', 'DESC');
                     $auxRes = $auxRes->orderBy('publicaciones.fechIni', 'DESC')->orderBy('publicaciones.fechIniNormal', 'DESC');
                     $paginatorFilter .= '&rel=ini';
                     break;
                 default:
                     break;
             }
         }
         if (Input::has('cond')) {
             $cond = Input::get('cond');
             $paginatorFilter .= '&cond=' . $cond;
             $auxRes = $auxRes->where('publicaciones.condicion', '=', strtolower($cond));
         }
         if (Input::has('buss')) {
             $buss = Input::get('buss');
             $paginatorFilter .= '&buss=' . $buss;
             $auxLider = $auxLider->where('publicaciones.bussiness_type', '=', strtolower($buss));
             $auxRes = $auxRes->where('publicaciones.bussiness_type', '=', strtolower($buss));
         }
         $lider = $auxLider->get($this->toReturn);
         $res = $auxRes->paginate(5, $this->toReturn);
         $categorias = Categorias::where('id', '=', $id)->pluck('id');
         if (!is_null($categorias)) {
             $busq = $categorias;
         } else {
             $busq = $id;
         }
         $departamentos = Department::get();
         $view = array('publicaciones' => $res, 'busq' => $busq, 'lider' => $lider, 'departamento' => $departamentos, 'paginatorFilter' => $paginatorFilter);
         if (isset($filter)) {
             $view = $view + array('filter' => $filter);
         }
         if (isset($currency)) {
             $view = $view + array('minmax' => $minmax, 'currency' => $currency);
         }
         if (isset($cond)) {
             $view = $view + array('cond' => $cond);
         }
         if (isset($buss)) {
             $view = $view + array('buss' => $buss);
         }
         if (isset($rel)) {
             $view = $view + array('rel' => $rel);
         }
         return Response::json($view);
     }
 }
Exemple #28
0
//DELETE: EXISTING COMPANY
Route::get('/admin/department/delete/{id}', array('as' => 'adminDeleteDepartment', 'uses' => function ($id) {
    $id = (int) $id;
    $employeeId = Session::get('userEmployeeId');
    $userId = Session::get('userId');
    $employee = new Employee();
    $employeeInfo = $employee->getEmployeeInfoById($employeeId);
    //return 'Update Company';
    return View::make('admin.departmentdelete', array('id' => $id, 'employeeInfo' => $employeeInfo));
    //return Redirect::route('updateCompany', array('id' => $id));
}));
//DELETE: EXISTING COMPANY
Route::post('/admin/department/delete/{id}', array('as' => 'adminProcessDeleteDepartment', 'uses' => function ($id) {
    $data = Input::all();
    $id = (int) $id;
    $department = Department::find($id);
    if ($department->delete()) {
        $message = 'Deleted Successfully.';
        return Redirect::route('adminNewDepartment')->with('message', $message);
    }
}));
//CREATE: new JobTitle
Route::get('/admin/jobtitle/new', array('as' => 'adminNewJobTitle', 'uses' => function () {
    //return 'Add Job Title';
    $employeeId = Session::get('userEmployeeId');
    $userId = Session::get('userId');
    $employee = new Employee();
    $employeeInfo = $employee->getEmployeeInfoById($employeeId);
    return View::make('admin.jobtitlenew', ['employeeInfo' => $employeeInfo]);
}));
//CREATE: new JobTitle
$summary = DB::table('employee_summary')->select(DB::raw('SUM(lates) as lates, SUM(undertime) as undertime, SUM(absent) as absent, SUM(paid_sick_leave) as paid_sick_leave, SUM(paid_vacation_leave) as paid_vacation_leave, SUM(leave_without_pay) as leave_without_pay, SUM(maternity_leave) as maternity_leave, SUM(paternity_leave) as paternity_leave,
                      SUM(regular) as regular, SUM(regular_overtime) as regular_overtime, SUM(regular_overtime_night_diff) as regular_overtime_night_diff, SUM(regular_night_differential) as regular_night_differential, SUM(rest_day) as rest_day, SUM(rest_day_overtime) as rest_day_overtime, SUM(rest_day_overtime_night_diff) as rest_day_overtime_night_diff, SUM(rest_day_night_differential) as rest_day_night_differential,
                       SUM(rest_day_special_holiday) as rest_day_special_holiday, SUM(rest_day_special_holiday_overtime) as rest_day_special_holiday_overtime, SUM(rest_day_special_holiday_overtime_night_diff) as rest_day_special_holiday_overtime_night_diff, SUM(rest_day_special_holiday_night_diff) as rest_day_special_holiday_night_diff, SUM(rest_day_legal_holiday) as rest_day_legal_holiday, SUM(rest_day_legal_holiday_overtime) as rest_day_legal_holiday_overtime,
                       SUM(rest_day_legal_holiday_overtime_night_diff) as rest_day_legal_holiday_overtime_night_diff, SUM(rest_day_legal_holiday_night_diff) as rest_day_legal_holiday_night_diff, SUM(special_holiday) as special_holiday, SUM(special_holiday_overtime) as special_holiday_overtime, SUM(special_holiday_overtime_night_diff) as special_holiday_overtime_night_diff, SUM(special_holiday_night_diff) as special_holiday_night_diff, SUM(legal_holiday) as legal_holiday,
                       SUM(legal_holiday_overtime) as legal_holiday_overtime, SUM(legal_holiday_overtime_night_diff) as legal_holiday_overtime_night_diff, SUM(legal_holiday_night_diff) as legal_holiday_night_diff'))->where('employee_id', $employeeId)->whereBetween('daydate', [$cutOffDateFrom, $cutOffDateTo])->first();
//dd($summary);
$userGroups = DB::table('users_groups')->where('user_id', $userId)->first();
//$userGroups = DB::table('users_groups')->where('user_id', Auth::user()->id)->first();
if (!empty($userGroups)) {
    $groups = DB::table('groups')->where('id', (int) $userGroups->group_id)->first();
}
$currentUser = Sentry::getUser();
//$employeeId = Session::get('userEmployeeId');
//$employeeInfo[0]->id
$company = Company::find($employeeInfo[0]->company_id);
$department = Department::find($employeeInfo[0]->department_id);
$jobTitle = JobTitle::find($employeeInfo[0]->position_id);
$manager = '';
$manager = Employee::where('id', '=', $employeeInfo[0]->manager_id)->first();
if (!empty($manager)) {
    $managerFullname = $manager->firstname . ', ' . $manager->lastname;
} else {
    $managerFullname = '';
}
$employees = DB::table('employees')->where('manager_id', $employeeInfo[0]->id)->orWhere('supervisor_id', $employeeInfo[0]->id)->get();
$employeeArr[0] = '';
foreach ($employees as $employee) {
    $employeeArr[$employee->id] = $employee->firstname . ', ' . $employee->lastname;
}
//$getSchedule = DB::table('employee_schedule')->where('employee_id', $employee->id)->where('schedule_date', trim($currentDate))->get();
//$getWorkShiftByDayOfTheWeek = DB::table('work_shift')->where('employee_id',  $employee->id)->where('name_of_day', $dayOfTheWeek)->where('shift', $shift)->get();
Exemple #30
0
<?php

Route::collection(array('before' => 'auth,csrf'), function () {
    Route::get(array('admin/departments', 'admin/departments/(:num)'), function ($page = 1) {
        $vars['messages'] = Notify::read();
        $vars['departments'] = Department::paginate($page, Config::get('meta.posts_per_page'));
        return View::create('departments/index', $vars)->partial('header', 'partials/header')->partial('footer', 'partials/footer');
    });
    Route::get('admin/departments/edit/(:num)', function ($id) {
        $vars['messages'] = Notify::read();
        $vars['token'] = Csrf::token();
        $vars['department'] = Department::find($id);
        $vars['fields'] = Extend::fields('department', $id);
        return View::create('departments/edit', $vars)->partial('header', 'partials/header')->partial('footer', 'partials/footer');
    });
    Route::post('admin/departments/edit/(:num)', function ($id) {
        $input = Input::get(array('title', 'slug', 'description'));
        $validator = new validator($input);
        $validator->check('title')->is_max(3, __('departments.title_missing'));
        if ($errors = $validator->errors()) {
            Input::flash();
            Notify::error($errors);
            return Response::redirect('admin/departments/edit/' . $id);
        }
        if (empty($input['slug'])) {
            $input['slug'] = $input['title'];
        }
        $input['slug'] = slug($input['slug']);
        department::update($id, $input);
        Extend::process('department', $id);
        Notify::successs(__('departments.update'));