01.for($i=0;$i<count($_POST["AS"]);$i++) {
02.
03. if(trim($_POST["AS"][$i]) != "") {
04.
05. $strSQL = "INSERT INTO ReqInfo (ReqNo, ReqType, EmployeeID, ReqDate, ReqHour, ReqMinute, ReqOTType, ReqIssuer, ReqIssueDate, Status) VALUES (
06.
07. + cast(year(Getdate()) as nvarchar)
08. + right('00' + cast(month(getdate()) as nvarchar), 2)
09. + right('00' + cast(day(getdate()) as nvarchar), 2)
10.
11. + case when day(getdate()) = 1 then '0000'
12. else right('0000' + cast(isnull((select right(max(ReqNo), 4) + 1 from ReqInfo), 1) as nvarchar), 4)
13. end
14.
15. , '1', '".$_POST["AS"][$i]."', GETDATE(), '".$h."', '".$m."', '$TXTcode', '".$_SESSION['UserID']."', GETDATE(), '1')";
16. $objQuery = sqlsrv_query($conn, $strSQL)
17. or die ("Error Query [".$strSQL."]");
18.
19.
20. }
21.}
