/** * the singleton pattern * * @return HumanResources_Controller_CostCenter */ public static function getInstance() { if (self::$_instance === NULL) { self::$_instance = new self(); } return self::$_instance; }
/** * returns the cost center for the current account * * @return HumanResources_Model_CostCenter|Sales_Model_CostCenter */ protected function _getCurrentUsersCostCenter() { $employee = $this->_getCurrentUsersEmployee(); $salesCC = HumanResources_Controller_CostCenter::getInstance()->getValidCostCenter($employee->getId(), NULL, TRUE); return $salesCC; }
/** * returns employees currently belonging to the given cost center (id) * * @param string|Sales_Model_CostCenter $costCenterId * @return Tinebase_Record_RecordSet|NULL */ public function getEmployeesBySalesCostCenter($costCenterId) { $costCenterId = is_string($costCenterId) ? $costCenterId : $costCenterId->getId(); $ccController = HumanResources_Controller_CostCenter::getInstance(); $now = Tinebase_DateTime::now(); $filter = new HumanResources_Model_CostCenterFilter(); $filter->addFilter(new Tinebase_Model_Filter_Text(array('field' => 'cost_center_id', 'operator' => 'equals', 'value' => $costCenterId))); $filter->addFilter(new Tinebase_Model_Filter_Date(array('field' => 'start_date', 'operator' => 'before', 'value' => $now))); $hrccs = $ccController->search($filter); if ($hrccs->count()) { $filter = new HumanResources_Model_EmployeeFilter(array(array('field' => 'id', 'operator' => 'in', 'value' => $hrccs->employee_id)), 'AND'); $filteredEmployees = new Tinebase_Record_RecordSet('HumanResources_Model_Employee'); $employees = $this->search($filter); foreach ($employees as $employee) { $subCC = $hrccs->filter('employee_id', $employee->getId()); if ($subCC->sort('start_date', 'DESC')->getFirstRecord()->start_date <= $now) { $filteredEmployees->addRecord($employee); } } return $filteredEmployees; } else { return NULL; } }
/** * update to 6.7 * * - remove costcenter from contract, create costcenter-employee-mm table */ public function update_6() { $table = new Setup_Backend_Schema_Table_Xml('<table> <name>humanresources_costcenter</name> <version>1</version> <declaration> <field> <name>id</name> <type>text</type> <length>40</length> <notnull>true</notnull> </field> <field> <name>start_date</name> <type>datetime</type> <notnull>false</notnull> </field> <field> <name>employee_id</name> <type>text</type> <length>40</length> <notnull>true</notnull> </field> <field> <name>cost_center_id</name> <type>text</type> <length>40</length> <notnull>true</notnull> </field> <field> <name>created_by</name> <type>text</type> <length>40</length> </field> <field> <name>creation_time</name> <type>datetime</type> </field> <field> <name>last_modified_by</name> <type>text</type> <length>40</length> </field> <field> <name>last_modified_time</name> <type>datetime</type> </field> <field> <name>is_deleted</name> <type>boolean</type> <default>false</default> </field> <field> <name>deleted_by</name> <type>text</type> <length>40</length> </field> <field> <name>deleted_time</name> <type>datetime</type> </field> <index> <name>id</name> <primary>true</primary> <field> <name>id</name> </field> </index> </declaration> </table>'); $this->_backend->createTable($table, 'HumanResources'); // find all contracts $select = $this->_db->select()->from(SQL_TABLE_PREFIX . 'humanresources_contract')->where('is_deleted=0'); $stmt = $select->query(); $contracts = $stmt->fetchAll(); $now = new Tinebase_DateTime(); $be = HumanResources_Controller_CostCenter::getInstance(); foreach ($contracts as $contract) { if ($contract['cost_center_id']) { $costcenter = new HumanResources_Model_CostCenter(array('employee_id' => $contract['employee_id'], 'cost_center_id' => $contract['cost_center_id'], 'start_date' => $contract['start_date'] ? $contract['start_date'] : (string) $now)); $be->create($costcenter); } } // remove costcenter property from contract try { $this->_backend->dropCol('humanresources_contract', 'cost_center_id'); } catch (Exception $e) { } // create type config $cb = new Tinebase_Backend_Sql(array('modelName' => 'Tinebase_Model_Config', 'tableName' => 'config')); $appId = Tinebase_Application::getInstance()->getApplicationByName('HumanResources')->getId(); // update vacation status config $kfc = $cb->getByProperty('freetimeStatus'); $kfc->name = HumanResources_Config::VACATION_STATUS; $cb->update($kfc); // create sickness status config $sicknessStatusConfig = array('name' => HumanResources_Config::SICKNESS_STATUS, 'records' => array(array('id' => 'EXCUSED', 'value' => 'Excused', 'icon' => 'images/oxygen/16x16/actions/smiley.png', 'system' => TRUE), array('id' => 'UNEXCUSED', 'value' => 'Unexcused', 'icon' => 'images/oxygen/16x16/actions/tools-report-bug.png', 'system' => TRUE))); $cb->create(new Tinebase_Model_Config(array('application_id' => $appId, 'name' => HumanResources_Config::SICKNESS_STATUS, 'value' => json_encode($sicknessStatusConfig)))); // update sickness records, set status = excused $filter = new HumanResources_Model_FreeTimeFilter(array(array('field' => 'type', 'operator' => 'equals', 'value' => 'SICKNESS'))); $ftb = new HumanResources_Backend_FreeTime(); $records = $ftb->search($filter); $ftb->updateMultiple($records->id, array('status' => 'EXCUSED')); // create persistenfilters $pfe = Tinebase_PersistentFilter::getInstance(); $commonValues = array('account_id' => NULL, 'application_id' => Tinebase_Application::getInstance()->getApplicationByName('HumanResources')->getId(), 'model' => 'HumanResources_Model_EmployeeFilter'); $pfe->createDuringSetup(new Tinebase_Model_PersistentFilter(array_merge($commonValues, array('name' => "Currently employed", 'description' => "Employees which are currently employed", 'filters' => array(array('field' => 'is_employed', 'operator' => 'equals', 'value' => 1)))))); // add workingtime json $field = '<field> <name>workingtime_json</name> <type>text</type> <length>1024</length> <notnull>true</notnull> </field>'; $declaration = new Setup_Backend_Schema_Field_Xml($field); $this->_backend->addCol('humanresources_contract', $declaration); $this->setTableVersion('humanresources_contract', '4'); // change freetime type field length $field = '<field> <name>type</name> <type>text</type> <length>64</length> <default>vacation</default> </field>'; $declaration = new Setup_Backend_Schema_Field_Xml($field); $this->_backend->alterCol('humanresources_freetime', $declaration); $this->setTableVersion('humanresources_freetime', '3'); // add vacation types $cb = new Tinebase_Backend_Sql(array('modelName' => 'Tinebase_Model_Config', 'tableName' => 'config', 'modlogActive' => FALSE)); $appId = Tinebase_Application::getInstance()->getApplicationByName('HumanResources')->getId(); $filter = new Tinebase_Model_ConfigFilter(array(array('field' => 'name', 'operator' => 'equals', 'value' => HumanResources_Config::FREETIME_TYPE))); $ftt = $cb->search($filter)->getFirstRecord(); $val = json_decode($ftt->value); $existing = $val->records; $existing[] = array('id' => 'VACATION_REMAINING', 'value' => 'Remaining Vacation', 'icon' => 'images/oxygen/16x16/actions/book2.png', 'system' => TRUE); $existing[] = array('id' => 'VACATION_EXTRA', 'value' => 'Extra Vacation', 'icon' => 'images/oxygen/16x16/actions/book2.png', 'system' => TRUE); $freeTimeTypeConfig = array('name' => HumanResources_Config::FREETIME_TYPE, 'records' => $existing); $ftt->value = json_encode($freeTimeTypeConfig); $cb->update($ftt); // update json of workingtime models if they still exist $controller = HumanResources_Controller_WorkingTime::getInstance(); $controller->modlogActive(FALSE); $filter = new HumanResources_Model_WorkingTimeFilter(array()); //array('field' => 'working_hours', 'operator' => 'equals', 'value' => '40'))); $allWT = $controller->search($filter); $wt40 = $allWT->filter('working_hours', "40"); foreach ($wt40 as $wt) { $wt->json = '{"days":[8,8,8,8,8,0,0]}'; $controller->update($wt); } $wt37 = $allWT->filter('working_hours', "37.5"); foreach ($wt37 as $wt) { $wt->json = '{"days":[8,8,8,8,5.5,0,0]}'; $controller->update($wt); } $wt20 = $allWT->filter('working_hours', "20"); foreach ($wt20 as $wt) { $wt->json = '{"days":[4,4,4,4,4,0,0]}'; $controller->update($wt); } $this->setApplicationVersion('HumanResources', '6.7'); }