public function testBulkAssignLeaveEntitlements()
{
$this->fixture = sfConfig::get('sf_plugins_dir') . '/orangehrmLeavePlugin/test/fixtures/LeaveEntitlement.yml';
TestDataService::populate($this->fixture);
$dao = new LeaveEntitlementDao();
$limit = 5000;
$empList = array();
$employeeService = new EmployeeService();
$employeeService->setEmployeeDao(new EmployeeDao());
for ($i = 0; $i < $limit; $i++) {
$employee = new Employee();
$employee->setFirstName($i);
$employee = $employeeService->saveEmployee($employee);
array_push($empList, $employee->getEmpNumber());
}
$start_time = microtime(true);
$leaveEntitlement = new LeaveEntitlement();
$leaveEntitlement->setLeaveTypeId(1);
$leaveEntitlement->setCreditedDate(date('Y-m-d'));
$leaveEntitlement->setEntitlementType(LeaveEntitlement::ENTITLEMENT_TYPE_ADD);
$leaveEntitlement->setDeleted(0);
$leaveEntitlement->setNoOfDays(2);
$leaveEntitlement->setFromDate('2012-01-01');
$leaveEntitlement->setToDate('2012-08-01');
$result = $dao->bulkAssignLeaveEntitlements($empList, $leaveEntitlement);
$deference = microtime(true) - $start_time;
$this->assertEquals(count($empList), $result, "Time Deference - " . $deference);
echo "Add Entitlement 5000 Time " . $deference;
}
public function getLeavesForMeAndSubordinates($req){
$shareCalendar = $this->baseService->settingsManager->getSetting("Leave: Share Calendar to Whole Company");
$map = json_decode('{"employee":["Employee","id","first_name+last_name"],"leave_type":["LeaveType","id","name"]}');
$employee = $this->baseService->getElement('Employee',$this->getCurrentProfileId(),null,true);
if($shareCalendar != "1"){
$subordinate = new Employee();
$subordinates = $subordinate->Find("supervisor = ?",array($employee->id));
$subordinatesIds = $employee->id;
foreach($subordinates as $sub){
if($subordinatesIds != ""){
$subordinatesIds.=",";
}
$subordinatesIds.=$sub->id;
}
$employeeLeave = new EmployeeLeave();
$startDate = date("Y-m-d H:i:s",$req->start);
$endDate = date("Y-m-d H:i:s",$req->end);
$list = $employeeLeave->Find("employee in (".$subordinatesIds.") and status in ('Approved','Pending') and ((date_start >= ? and date_start <= ? ) or (date_end >= ? and date_end <= ?))",array($startDate,$endDate,$startDate,$endDate));
}else{
$employeeLeave = new EmployeeLeave();
$startDate = date("Y-m-d H:i:s",$req->start);
$endDate = date("Y-m-d H:i:s",$req->end);
$list = $employeeLeave->Find("status in ('Approved','Pending') and ((date_start >= ? and date_start <= ? ) or (date_end >= ? and date_end <= ?))",array($startDate,$endDate,$startDate,$endDate));
}
if(!$list){
LogManager::getInstance()->info($employeeLeave->ErrorMsg());
}
if(!empty($map)){
$list = $this->baseService->populateMapping($list,$map);
}
$data = array();
foreach($list as $leave){
$data[] = $this->leaveToEvent($leave);
}
$holiday = new HoliDay();
$holidays = $holiday->Find("1=1",array());
foreach($holidays as $holiday){
$data[] = $this->holidayToEvent($holiday);
}
echo json_encode($data);
exit();
}
private function compareEmployee(Employee $objectOne, Employee $objectTwo)
{
if ($objectOne->getRank() == $objectTwo->getRank()) {
return 0;
}
return $objectOne->getRank() < $objectTwo->getRank() ? -1 : 1;
}
public function displayEmployee($value, $tr)
{
$template = $this->context->smarty->createTemplate('controllers/logs/employee_field.tpl', $this->context->smarty);
$employee = new Employee((int) $tr['id_employee']);
$template->assign(array('employee_image' => $employee->getImage(), 'employee_name' => $value));
return $template->fetch();
}
public function getInitData($req)
{
$data = array();
$employees = new Employee();
$data['numberOfEmployees'] = $employees->Count("1 = 1");
$company = new CompanyStructure();
$data['numberOfCompanyStuctures'] = $company->Count("1 = 1");
$user = new User();
$data['numberOfUsers'] = $user->Count("1 = 1");
$project = new Project();
$data['numberOfProjects'] = $project->Count("status = 'Active'");
$attendance = new Attendance();
$data['numberOfAttendanceLastWeek'] = $attendance->Count("in_time > '" . date("Y-m-d H:i:s", strtotime("-1 week")) . "'");
if (empty($data['numberOfAttendanceLastWeek'])) {
$data['numberOfAttendanceLastWeek'] = 0;
}
$empLeave = new EmployeeLeave();
$data['numberOfLeaves'] = $empLeave->Count("date_start > '" . date("Y-m-d") . "'");
$timeEntry = new EmployeeTimeEntry();
$data['numberOfAttendanceLastWeek'] = $timeEntry->Count("in_time > '" . date("Y-m-d H:i:s", strtotime("-1 week")) . "'");
$candidate = new Candidate();
$data['numberOfCandidates'] = $candidate->Count("1 = 1");
$job = new Job();
$data['numberOfJobs'] = $job->Count("status = 'Active'");
$course = new Course();
$data['numberOfCourses'] = $course->Count("1 = 1");
return new IceResponse(IceResponse::SUCCESS, $data);
}
public function getDashboardItemData()
{
$data = array();
$emp = new Employee();
$data['numberOfEmployees'] = $emp->Count("1 = 1");
return $data;
}
public function getData($report, $req)
{
$leaveActionManager = new LeavesActionManager();
$department = $req['department'];
$employeeId = $req['employee'];
if (($employeeId == "NULL" || empty($employeeId)) && ($department == "NULL" || empty($department))) {
$emp = new Employee();
$employees = $emp->Find("status = 'Active'", array());
} else {
if ($employeeId != "NULL" && !empty($employeeId)) {
$emp = new Employee();
$employees = $emp->Find("id = ?", array($employeeId));
} else {
$emp = new Employee();
$employees = $emp->Find("department = ? and status = 'Active'", array($department));
}
}
$reportData = array();
$reportData[] = array("Employee ID", "Employee", "Leave Type", "Pending", "Approved", "Rejected", "Canceled", "Available", "To be Accrued", "Carried Forward from Previous Years");
foreach ($employees as $employee) {
$leaveEntitlements = $leaveActionManager->getEntitlementByEmployee($employee)->getObject();
foreach ($leaveEntitlements as $leaveEntitlement) {
$reportData[] = array($employee->employee_id, $employee->first_name . " " . $employee->last_name, $leaveEntitlement['name'], $leaveEntitlement['pendingLeaves'], $leaveEntitlement['approvedLeaves'], $leaveEntitlement['rejectedLeaves'], $leaveEntitlement['cancelRequestedLeaves'], $leaveEntitlement['availableLeaves'], $leaveEntitlement['tobeAccrued'], $leaveEntitlement['carriedForward']);
}
}
return $reportData;
}
/**
* Grant access to the WiFi network to an employee
* @param Employee $employee
* @return bool
*/
public function grantAccess(Employee $employee)
{
//now, it's a network with "access control"
if ($employee->getAccessLevel() === Employee::ACCESS_LEVEL_HIGH) {
return $this->wifiNetwork->grantAccess($employee);
}
return false;
}
private function getEmployeeById($id)
{
$sup = new Employee();
$sup->Load("id = ?", array($id));
if ($sup->id != $id) {
error_log("Employee not found");
return null;
}
return $sup;
}
private function getEmployeeById($id)
{
$sup = new Employee();
$sup->Load("id = ?", array($id));
if ($sup->id != $id) {
LogManager::getInstance()->info("Employee not found");
return null;
}
return $sup;
}
public function editgroup($id)
{
$employeeId = Session::get('userEmployeeId');
$employee = new Employee();
$employeeInfo = $employee->getEmployeeInfoById($employeeId);
// Show details of a user.
$group = Group::findOrFail($id);
$perms = array("view" => 1, "create" => 2, "update" => 3, "delete" => 4);
$permissions = Permission::all();
return View::make('admin.editgroup')->with('group', $group)->with('perms', $perms)->with('permissions', $permissions)->with('employeeInfo', $employeeInfo);
}
public function postProcess()
{
global $cookie, $currentIndex;
if (Tools::isSubmit('submitDatePicker')) {
if (!Validate::isDate($from = Tools::getValue('datepickerFrom')) or !Validate::isDate($to = Tools::getValue('datepickerTo'))) {
$this->_errors[] = Tools::displayError('Date specified is invalid');
}
}
if (Tools::isSubmit('submitDateDay')) {
$from = date('Y-m-d');
$to = date('Y-m-d');
}
if (Tools::isSubmit('submitDateDayPrev')) {
$yesterday = time() - 60 * 60 * 24;
$from = date('Y-m-d', $yesterday);
$to = date('Y-m-d', $yesterday);
}
if (Tools::isSubmit('submitDateMonth')) {
$from = date('Y-m-01');
$to = date('Y-m-t');
}
if (Tools::isSubmit('submitDateMonthPrev')) {
$m = date('m') == 1 ? 12 : date('m') - 1;
$y = $m == 12 ? date('Y') - 1 : date('Y');
$from = $y . '-' . $m . '-01';
$to = $y . '-' . $m . date('-t', mktime(12, 0, 0, $m, 15, $y));
}
if (Tools::isSubmit('submitDateYear')) {
$from = date('Y-01-01');
$to = date('Y-12-31');
}
if (Tools::isSubmit('submitDateYearPrev')) {
$from = date('Y') - 1 . date('-01-01');
$to = date('Y') - 1 . date('-12-31');
}
if (isset($from) and isset($to) and !sizeof($this->_errors)) {
$employee = new Employee($cookie->id_employee);
$employee->stats_date_from = $from;
$employee->stats_date_to = $to;
$employee->update();
Tools::redirectAdmin($_SERVER['REQUEST_URI']);
}
if (Tools::getValue('submitSettings')) {
if ($this->tabAccess['edit'] === '1') {
$currentIndex .= '&module=' . Tools::getValue('module');
$this->_postConfig($this->_fieldsSettings);
} else {
$this->_errors[] = Tools::displayError('You do not have permission to edit here.');
}
}
if (sizeof($this->_errors)) {
AdminTab::displayErrors();
}
}
public function deleteProfileImage($req)
{
$profileId = $this->getCurrentProfileId();
$subordinate = new Employee();
$subordinatesCount = $subordinate->Count("supervisor = ? and id = ?", array($profileId, $req->id));
if ($this->user->user_level == 'Admin' || $this->user->employee == $req->id || $subordinatesCount == 1) {
$fs = FileService::getInstance();
$res = $fs->deleteProfileImage($req->id);
return new IceResponse(IceResponse::SUCCESS, $res);
}
return new IceResponse(IceResponse::ERROR, "Not allowed to delete profile image");
}
protected function createFakerEmployee()
{
$faker = Faker::create();
for ($i = 1; $i < 50; $i++) {
$employee = new Employee();
$employee->first_name = $faker->firstName;
$employee->last_name = $faker->lastName;
$employee->email = $faker->email;
$employee->hire_date = $faker->date($format = 'Y-m-d');
$employee->password = $faker->password;
$employee->save();
}
}
public function run()
{
$employee = new Employee();
$employee->name = 'Ganesh';
$employee->email = '*****@*****.**';
$employee->password = '******';
$employee->password_confirmation = '00d00@ganesh';
$employee->mobile = '9999999999';
$employee->active = 1;
$employee->save();
$employee::$rules = [];
$employee->generateEmployeeId();
}
public function requireDefaultRecords()
{
parent::requireDefaultRecords();
$employeeSet = DataObject::get('Employee');
foreach ($employeeSet as $employee) {
$employee->delete();
}
foreach ($this->data() as $employeeName) {
$employee = new Employee();
$employee->Name = $employeeName;
$employee->write();
}
DB::alteration_message("Added default records to Employee table", "created");
}
protected function renderContent()
{
$model = new Employee('search');
$model->unsetAttributes();
// clear any default values
if (isset($_GET['Employee'])) {
$model->attributes = $_GET['Employee'];
}
if (isset($_GET['pageSize'])) {
Yii::app()->user->setState('pageSize', (int) $_GET['pageSize']);
unset($_GET['pageSize']);
// would interfere with pager and repetitive page size change
}
$this->render('DaftarKaryawan', array('model' => $model));
}
/**
*
* @param array $employee
* @return Employee
* @throws Exception
*/
public function addEmployee($employee)
{
$fileds = array_keys($employee);
foreach ($this->getRequiredFields() as $val) {
if (!in_array($val, $fileds)) {
throw new Exception("required filed " . $val . " is not provided");
}
}
$empObject = new Employee();
foreach ($employee as $key => $val) {
$empObject->set($key, $val);
}
$instance = $this->getServiceInstance();
return $instance->saveEmployee($empObject);
}
public function loadModel($id)
{
if (($model = Employee::model()->findByPk($id)) === null) {
throw new CHttpException(404, Yii::t('TeamModule.team', 'Page was not found!'));
}
return $model;
}
public function index()
{
$entities = Entity::all();
$employees = Employee::all();
$menu = 'data';
return View::make('entities.index', compact('employees', 'entities', 'menu'));
}
public function edit($id)
{
$returnment = Returnment::with('employee')->find($id);
$employees = Employee::where('location_id', '=', Auth::user()->location_id)->get();
$menu = 'finance';
return View::make('returnments.edit', compact('returnment', 'employees', 'menu'));
}
public function run()
{
$faker = Faker::create();
foreach (range(1, 10) as $index) {
Employee::create([]);
}
}
public function constructReturnArr($res)
{
$arr = array();
$i = 0;
while ($row = mysql_fetch_assoc($res)) {
$emp = new Employee();
$emp->setName($row['name']);
$emp->setCode($row['code']);
$emp->setSalary($row['salary']);
$emp->setGrade($row['grade']);
$arr[$i] = $emp;
$i++;
}
$this->getConnection()->releaseRes($res);
return $arr;
}
public function testSearchEmployeeList()
{
$parameterHolder = new EmployeeSearchParameterHolder();
$employee1 = new Employee();
$employee1->setLastName('Last Name');
$employee1->setFirstName('First Name');
$employee2 = new Employee();
$employee2->setLastName('Last Name');
$employee2->setFirstName('First Name');
$list = array($employee1, $employee2);
$mockDao = $this->getMock('EmployeeDirectoryDao');
$mockDao->expects($this->once())->method('searchEmployees')->with($parameterHolder)->will($this->returnValue($list));
$this->employeeDirectoryService->setEmployeeDirectoryDao($mockDao);
$result = $this->employeeDirectoryService->searchEmployees($parameterHolder);
$this->assertEquals($list, $result);
}
private function getModel()
{
if (!$this->isGuest && $this->_model === null) {
$this->_model = Employee::model()->findByPk($this->id, array('select' => 'role'));
}
return $this->_model;
}
/**
* Show the form for editing the specified branch.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$rel = ERelief::find($id);
$employees = Employee::all();
$reliefs = Relief::all();
return View::make('employee_relief.edit', compact('rel', 'employees', 'reliefs'));
}
public function indexAction()
{
$departments = Department::find();
$this->view->departments = $departments;
$employees = Employee::find();
$this->view->employees = $employees;
}
public function postGeneral($id)
{
$id = Crypt::decrypt($id);
$request = RRequest::find($id);
if (Input::has('save')) {
if (Input::get('employee') == 0 || Input::get('organization') == 0 || Input::get('r_plan') == 0 || Input::get('specialist') == 0 || strlen(Input::get('title')) < 2 || strlen(Input::get('description')) < 2) {
Session::flash('sms_warn', trans('sta.require_field'));
} else {
$request->request_by_id = Input::get('employee');
$request->for_organization_id = Input::get('organization');
$request->for_planning_id = Input::get('r_plan');
$request->to_department_id = Input::get('specialist');
$request->request_title = Input::get('title');
$request->description = Input::get('description');
$request->request_date = date('Y-m-d');
$request->created_by = Auth::user()->employee_id;
if ($request->save()) {
Session::flash('sms_success', trans('sta.save_data_success'));
//return Redirect::to('branch_request/general/' . Crypt::encrypt($request->id));
}
}
}
$organizations = $this->array_list(Organization::list_item());
$employees = $this->array_list(Employee::list_item());
$department = $this->array_list(Department::list_item());
$r_plans = $this->array_list(Rplan::list_item());
return View::make('branch_request.edit_general', array('id' => $id, 'organizations' => $organizations, 'employees' => $employees, 'specialist' => $department, 'r_plans' => $r_plans, 'request' => $request));
}
public static function absentEveryEmployee()
{
$employees = Employee::where('status', '=', 'active')->get();
$absentess = [];
foreach ($employees as $employee) {
//Count the absent except half days
foreach (Leavetype::where('leaveType', '<>', 'half day')->get() as $leave) {
//$absentess[$employee->employeeID][$leave->leaveType] = 0;
// Half Day leaves are added to casual leaves.2 half days are equal to one Casual Leave
$absentess[$employee->employeeID][$leave->leaveType] = Attendance::where('status', '=', 'absent')->where('employeeID', '=', $employee->employeeID)->where(function ($query) {
$query->where('application_status', '=', 'approved')->orWhere('application_status', '=', null);
})->where('leaveType', '=', $leave->leaveType)->count();
}
// half days count
foreach (Leavetype::where('leaveType', '=', 'half day')->get() as $leave) {
$half_day = Attendance::select('halfDayType', DB::raw('count(*) as total'))->where('status', '=', 'absent')->where('employeeID', '=', $employee->employeeID)->where(function ($query) {
$query->where('application_status', '=', 'approved')->orWhere('application_status', '=', null);
})->where('leaveType', '=', $leave->leaveType)->groupBy('halfDayType')->get();
foreach ($half_day as $half) {
$absentess[$employee->employeeID][$half->halfDayType] += $half->total / 2;
}
}
// Total of All leaves
$absentess[$employee->employeeID]['total'] = array_sum($absentess[$employee->employeeID]);
}
return $absentess;
}
public function index()
{
$retrievals = Retrieval::where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->get();
$employees = Employee::where('location_id', '=', Auth::user()->location_id)->get();
$menu = 'student';
return View::make('retrievals.index', compact('retrievals', 'employees', 'menu'));
}
