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