public function execute()
 {
     $this->incrementNumber = 47;
     parent::execute();
     $result[] = $this->upgradeUtility->executeSql($this->sql[0]);
     $this->checkTransactionComplete($result);
     $this->updateOhrmUpgradeInfo($this->transactionComplete, $this->incrementNumber);
     $this->upgradeUtility->finalizeTransaction($this->transactionComplete);
     $this->upgradeUtility->closeDbConnection();
 }
 public function execute()
 {
     $this->incrementNumber = 53;
     parent::execute();
     $result = array();
     $result[] = $this->createLeaveTakenStatusChangingMysqlEvent();
     $this->checkTransactionComplete($result);
     $this->updateOhrmUpgradeInfo($this->transactionComplete, $this->incrementNumber);
     $this->upgradeUtility->finalizeTransaction($this->transactionComplete);
     $this->upgradeUtility->closeDbConnection();
 }
 public function execute()
 {
     $this->incrementNumber = 46;
     parent::execute();
     $result[] = $this->updateSalaryCurrencyDetail();
     $result[] = $this->updateOhrmDisplayField();
     for ($i = 0; $i <= 2; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $this->checkTransactionComplete($result);
     $this->updateOhrmUpgradeInfo($this->transactionComplete, $this->incrementNumber);
     $this->upgradeUtility->finalizeTransaction($this->transactionComplete);
     $this->upgradeUtility->closeDbConnection();
 }
 public function execute()
 {
     $this->incrementNumber = 41;
     parent::execute();
     $result = array();
     foreach ($this->sql as $sql) {
         $result[] = $this->upgradeUtility->executeSql($sql);
     }
     $result[] = $this->upgradeAttendanceConfiguration();
     $this->checkTransactionComplete($result);
     $this->updateOhrmUpgradeInfo($this->transactionComplete, $this->incrementNumber);
     $this->upgradeUtility->finalizeTransaction($this->transactionComplete);
     $this->upgradeUtility->closeDbConnection();
 }
示例#5
0
 public function execute()
 {
     $this->incrementNumber = 55;
     parent::execute();
     $result = array();
     foreach ($this->sql as $sql) {
         $result[] = $this->upgradeUtility->executeSql($sql);
     }
     $this->addLeaveEntitlement();
     $this->checkTransactionComplete($result);
     $this->transactionComplete = true;
     $this->updateOhrmUpgradeInfo($this->transactionComplete, $this->incrementNumber);
     $this->upgradeUtility->finalizeTransaction($this->transactionComplete);
     $this->upgradeUtility->closeDbConnection();
 }
 public function execute()
 {
     $this->incrementNumber = 42;
     parent::execute();
     $result = array();
     foreach ($this->sql as $sql) {
         $result[] = $this->upgradeUtility->executeSql($sql);
     }
     $res1 = $this->updateCandidateHistory();
     $res2 = $this->updateCandidateAttachment();
     $result = array_merge($result, $res1, $res2);
     $this->checkTransactionComplete($result);
     $this->updateOhrmUpgradeInfo($this->transactionComplete, $this->incrementNumber);
     $this->upgradeUtility->finalizeTransaction($this->transactionComplete);
     $this->upgradeUtility->closeDbConnection();
 }
 public function execute()
 {
     $this->incrementNumber = 50;
     parent::execute();
     for ($i = 0; $i <= 15; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->insertOhrmWorkWeek();
     for ($i = 17; $i <= 34; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->updateHsHrEmpPicture();
     $this->checkTransactionComplete($result);
     $this->updateOhrmUpgradeInfo($this->transactionComplete, $this->incrementNumber);
     $this->upgradeUtility->finalizeTransaction($this->transactionComplete);
     $this->upgradeUtility->closeDbConnection();
 }
 public function execute()
 {
     $this->incrementNumber = 48;
     parent::execute();
     $result[] = $this->upgradeUtility->executeSql($this->sql[0]);
     $result[] = $this->insertIntoOhrmOrganizationGeneralInfo();
     for ($i = 1; $i <= 3; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->insertIntoOhrmJobTitle();
     $result[] = $this->insertIntoOhrmEmploymentStatus();
     $result[] = $this->readHsHrJobtitEmpStat();
     for ($i = 4; $i <= 6; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->insertIntoHsHrJobtitEmpstat();
     $result[] = $this->upgradeUtility->executeSql($this->sql[7]);
     $result[] = $this->insertIntoOhrmJobCategory();
     $result[] = $this->upgradeUtility->executeSql($this->sql[8]);
     $result[] = $this->updateEmplyeeJobDetails();
     for ($i = 9; $i <= 10; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->updateHsHrLicense();
     for ($i = 11; $i <= 12; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->updateHsHrEmpLicenses();
     for ($i = 13; $i <= 18; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->updateHsPrSalaryGrade();
     for ($i = 19; $i <= 20; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->updateHsHrEmpBasicsalary();
     $result[] = $this->upgradeUtility->executeSql($this->sql[21]);
     $result[] = $this->updateHsPrSalaryCurrencyDetail();
     for ($i = 22; $i <= 26; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->updateHsHrLanguage();
     for ($i = 27; $i <= 28; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->updateHsHrEmpLanguage();
     for ($i = 29; $i <= 32; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->insertIntoOhrmMembership();
     $result[] = $this->updateHsHrEmpMemberDetail();
     for ($i = 33; $i <= 35; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->updateHsHrSkill();
     for ($i = 36; $i <= 37; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->updateHsHrEmpSkill();
     for ($i = 38; $i <= 40; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->updateHsHrEducation();
     for ($i = 41; $i <= 42; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->updateHsHrEmpEducation();
     for ($i = 43; $i <= 49; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->updateHsHrLocation();
     for ($i = 50; $i <= 52; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->updateHsHrEmpLocations();
     for ($i = 53; $i <= 54; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->updateHsHrNationality();
     for ($i = 55; $i <= 56; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->updateHsHrEmployeeNationCode();
     for ($i = 57; $i <= 62; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->insertIntoOhrmUser();
     $result[] = $this->updateOhrmUser();
     $result[] = $this->updateHsHrMailNotifications();
     $result[] = $this->upgradeUtility->executeSql($this->sql[63]);
     $result[] = $this->updateOhrmTimesheetActionLog();
     for ($i = 64; $i <= 88; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->updateOhrmJobVacancy();
     for ($i = 89; $i <= 94; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->updateHsHrEmployeeTerminationId();
     for ($i = 95; $i <= 101; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->updateOhrmEmailNotification();
     for ($i = 102; $i <= 104; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $result[] = $this->updateOhrmSubunit();
     $result[] = $this->upgradeUtility->executeSql($this->sql[105]);
     for ($i = 107; $i <= 135; $i++) {
         $result[] = $this->upgradeUtility->executeSql($this->sql[$i]);
     }
     $this->checkTransactionComplete($result);
     $this->updateOhrmUpgradeInfo($this->transactionComplete, $this->incrementNumber);
     $this->upgradeUtility->finalizeTransaction($this->transactionComplete);
     $this->upgradeUtility->closeDbConnection();
 }