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();
}
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();
}