01.
02.
03.
04. $sql = "UPDATE absence SET status='A' WHERE absence_no=$document_id";
05. $sqlquery=mysql_db_query($dbname, $sql);
06.
07.
08.
09.
10. $sql = "UPDATE quota_employee SET quota_use=quota_use+'$totalday' , count_use=count_use+1 WHERE employee_id=$employee_id and type_no = 'sick' " ;
11. $sqlquery=mysql_db_query($dbname, $sql);
12.
13.
14.
15. $Insertannual = " INSERT INTO annualday " ;
16. $Insertannual = $Insertannual . "(employee_id,year,month,";
17. $Insertannual = $Insertannual . " sick ".")";
18. $Insertannual = $Insertannual . " VALUES(".$employee_id. ",'".$yearan."','".$monthan."',";
19. $Insertannual = $Insertannual .$totalday." ".")";
20.
21.
22. mysql_query($Insertannual);
