public static function saveHspSummary($summaryObjArr, $year, $empId = null) { for ($i = 0; $i < count($summaryObjArr); $i++) { try { $log = Logger::getInstance(); $exsisting = HspSummary::fetchHspSummary($year, 1, $summaryObjArr[$i]->getEmployeeId()); $mssg = $summaryObjArr[$i]->isHspValueChangedByAdmin($exsisting[0]); if ($mssg != false) { $log->info($mssg); } } catch (Exception $e) { } } $saveSuccess = HspSummary::saveHspSummary($summaryObjArr); if (isset($empId)) { self::searchHspSummary($empId, $year, $saveSuccess); } else { self::viewHspSummary($year, null, $saveSuccess); } }
public function testSaveHspSummary() { $this->assertTrue(mysql_query("TRUNCATE TABLE `hs_hr_hsp_summary`"), mysql_error()); // Add 2 records to `hs_hr_hsp_summary` $this->assertTrue(mysql_query("INSERT INTO `hs_hr_hsp_summary` VALUES (1, 1, 1, " . date('Y') . ", 1, 0.00, 0.00, 0.00, 0.00, 0.00)"), mysql_error()); $this->assertTrue(mysql_query("INSERT INTO `hs_hr_hsp_summary` VALUES (2, 2, 1, " . date('Y') . ", 1, 0.00, 0.00, 0.00, 0.00, 0.00)"), mysql_error()); $summaryObj[0] = new HspSummary(); $summaryObj[0]->setSummaryId(1); $summaryObj[0]->setAnnualLimit(1200); $summaryObj[0]->setEmployerAmount(60); $summaryObj[0]->setEmployeeAmount(50); $summaryObj[0]->setTotalAccrued(110); $summaryObj[0]->setTotalUsed(75); $summaryObj[1] = new HspSummary(); $summaryObj[1]->setSummaryId(2); $summaryObj[1]->setAnnualLimit(1800); $summaryObj[1]->setEmployerAmount(80); $summaryObj[1]->setEmployeeAmount(70); $summaryObj[1]->setTotalAccrued(150); $summaryObj[1]->setTotalUsed(200); $saveObj = new HspSummary(); $saveObj->saveHspSummary($summaryObj); $result = mysql_query("SELECT `annual_limit`, `employer_amount`, `employee_amount`, `total_accrued`, `total_used` FROM `hs_hr_hsp_summary`"); $i = 0; while ($row = mysql_fetch_array($result)) { $actual[$i][0] = (int) $row[0]; $actual[$i][1] = (int) $row[1]; $actual[$i][2] = (int) $row[2]; $actual[$i][3] = (int) $row[3]; $actual[$i][4] = (int) $row[4]; $i++; } $expected[0][0] = 1200; $expected[0][1] = 60; $expected[0][2] = 50; $expected[0][3] = 110; $expected[0][4] = 75; $expected[1][0] = 1800; $expected[1][1] = 80; $expected[1][2] = 70; $expected[1][3] = 150; $expected[1][4] = 200; $this->assertEquals($expected[0], $actual[0]); $this->assertEquals($actual[1], $expected[1]); }