<%
crlf=chr(13)+chr(10)
*=Sys(3101,1256)
*=SYS(3101,65001)
letterhead=orequest.form('letterhead')
if isnull(letterhead)
    letterhead=nvl(orequest.querystring('letterhead'),'')
endif
record_number=orequest.form("record_number")
if isnull(record_number)
    record_number=orequest.querystring("rref")
endif
tfilename=dbclocation+[details]
tcmd=[select * from (']+tfilename+[') where recno()==]+record_number+[ into cursor 'dcursor']
&tcmd
record_fileref=allt(reffid)
tfilename=dbclocation+[fileref]
tcmd=[select * from (']+tfilename+[') where allt(reffid)==']+record_fileref+[' into cursor 'fcursor']
&tcmd
THESPCONTACT=iif(empty(SPONPHONE),sendphone,SPONPHONE)
tfilename=dbclocation+[category]
tcmd=[select * from (']+tfilename+[') where allt(reffid)==']+record_fileref+[' into cursor 'gcursor']
&tcmd

VUNDERTAKING1V1='We M/S '+Upper(Alltrim(XCOMPANY.Name))+' OEPL No. '+Allt(XCOMPANY.LIC)+;
				' solemnly affirm that M/S '+THESPCONTACT+;
				' vide sikka wakala/khitab letter No. '+Alltrim(fcursor.VISAID)+' dated: '+Dtoc(fcursor.Date)+;
				' have authorized us to recruit ( '+Alltrim(Str(fcursor.QTY,5,0))+' ) workers, and arrange their Departure to the employer.'+;
				' We further confirm and stand guarantee that the employer is in need of workers in the following categories of workers, and shall provide'+;
				' the salary and fringe benefits as detailed bellow:'
			VUNDERTAKING1V2='Other fringe benefits: '+Chr(13)+'<BR/>  a). Accomodation '+Iif(fcursor.ACCOMODATI,'provided','not provided')+Chr(13)+;
				'  <BR/>b). Food '+Iif(fcursor.FOOD,'provided','not provided')+Chr(13)+;
				'  <BR/>c). Medical '+Iif(fcursor.MEDICAL,'provided','not provided')+Chr(13)+;
				'  <BR/>d). Air Passage '+Iif(fcursor.TICKET,'provided','not provided')+Chr(13)+;
				'  <BR/>e). Health Insurrance '+Iif(fcursor.HINSURANCE,'provided','not provided')+Chr(13)+;
				'  <BR/>f). Other fringe benefits as per local labour laws'+Chr(13)+;
				'<BR/><BR/>I undertake that the above information are correct, and the demand received through electronic visa slip is genuine. '+;
				'I/We further undertake that:'+Chr(13)+;
				'<BR/>1. In the event of the afforesaid information being found false or incorrect in any aspect, the recruiting permission shall be liable to legal and disciplinary action.'+Chr(13)+;
				'<BR/>2. In case any worker proceeding abroad in accordance with the permission is unable to secure job, I shall bear all the cost of his/her repartriation.'

%>
<!DOCTYPE html>
    <html lang="EN" dir="ltr" translate="no">

    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <meta name="google" content="notranslate">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta http-equiv="X-UA-Compatible" content="IE=edge" />
        <link rel="icon" href="bootstrap/images/sssoft.png" type="image/x-icon">

    <link rel="icon" href="images/logo.bmp" type="image/x-icon">
    <link href="bootstrap/recruiting.css" rel="stylesheet" />
    <link href="bootstrap/bootstrap.min.css" rel="stylesheet" />
    <link rel="stylesheet" href="bootstrap/web-fonts-with-css/css/all.min.css">
  
        <title>
            SSSoft&trade; -
            <<allt(xcompany.name)>>
        </title>
        <style>
            #wrapper{
                width:600px;
                margin:auto;
                direction: ltr;
                /*border: 1px solid black;*/
                padding:10px;
                font-family:'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
            }
             .centered-on-top {
                position: fixed; /* Ensures it stays on top and fixed relative to the viewport */
                top: 22px; /* Moves the top edge of the div to the vertical center of the viewport */
                left: 50%; /* Moves the left edge of the div to the horizontal center of the viewport */
                transform: translate(-50%, -50%); /* Shifts the div back by half its own width and height to truly center it */
                z-index: 9999; /* Ensures it's on top of other elements (adjust value as needed) */
                /* Add other styling as desired, e.g., width, height, background-color, padding, etc. */
                width: 200px;
                height: auto;
                background-color: white;
                text-align: center;
                }
            TABLE {
                    border-top:6px double black;
                    BORDER-BOTTOM:2PX SOLID BLACK;
            }
            th{
                    border-bottom:2px solid black;
            }
            .txt {
                padding:4px;
                text-decoration:underline;
            }
           @media print {
            .printnoshow {
                display: none;

            }
           
        }
        </style>
        </head>
        <body>
        <div id="wrapper">
                
                    <%if empty(letterhead) or %>
                    <div class='companytitlediv'>
                        <span class='thetittle' style="font-family: 'Arial', 'Verdana', 'Tahoma';font-size:16px !important;line-height: 1 !important;font-weight:bold !important;"><%=xcompany.name%></span>
                        <p style="font-family: 'Arial', 'Verdana', 'Tahoma';font-size:10px !important;line-height:1 !important;font-weight:bold !important;padding:0px"><%=allt(allt(xcompany.address1)+[ ]+allt(xcompany.address2))%>
                        <%=allt(allt(xcompany.phone)+[ ]+allt(xcompany.email))%></p>
                    </div>
                    <%else%>
                    <div style="height:200px;">
                        <%=getimagehead()%>
                        <img src="images/company.jpg">
                    </div>
                    <%endif%>
                
            <h1 align="center">UNDERTAKING</h1>
            <p style="text-align: justify;">
                <%=VUNDERTAKING1V1%>
            </p>
            <%
                gtablestr=[<table width='100%' ><tr>]
                GTABLESTR=GTABLESTR+[    <th>S.No.</th>]+crlf
                GTABLESTR=GTABLESTR+[    <th>CATEGORY OF<BR/>WORKERS</th>]+crlf
                GTABLESTR=GTABLESTR+[    <th>NUMBER<BR/>REQUIRED</th>]+crlf
                GTABLESTR=GTABLESTR+[    <th>MONTHLY<BR/>SALARY</th>]+crlf
                GTABLESTR=GTABLESTR+[    <th>CONTRACT<BR/>PERIOD</th>]+crlf
                GTABLESTR=GTABLESTR+[</tr>]+crlf
                select [gcursor]
                scan
                    GTABLESTR=GTABLESTR+[<tr>]+crlf
                    GTABLESTR=GTABLESTR+[<td>]+allt(transform(recno()))+[</td>]+crlf 
                    GTABLESTR=GTABLESTR+[<td>]+allt(category)+[</td>] +crlf
                    GTABLESTR=GTABLESTR+[<td>]+allt(TRANSFORM(qty))+[</td>]+crlf
                    GTABLESTR=GTABLESTR+[<TD>]+allt(curr)+" "+allt(str(salary,10,0))+[</td>]+crlf
                    GTABLESTR=GTABLESTR+[<TD>]+allt(iif(empty(year),"",allt(str(year,2))+" YEAR ")+ iif(empty(month),"",padl(allt(str(month,2,0)),2,"0")+" Month"))+[</td>]+crlf    
                    GTABLESTR=GTABLESTR+[</tr>]+CRLF    
                endscan
                GTABLESTR=GTABLESTR+[</table>]
            %>
            <%=GTABLESTR%>
            <BR/>
            <p style="text-align: justify;">
               Other fringe benefits:<BR/>  
               &nbsp;a). Accomodation <%=Iif(fcursor.ACCOMODATI,'provided','not provided')%><BR/>
			    &nbsp;b). Food <%=Iif(fcursor.FOOD,'provided','not provided')%><BR/>
				&nbsp;c). Medical <%=Iif(fcursor.MEDICAL,'provided','not provided')%><BR/>
				&nbsp;d). Air Passage <%=Iif(fcursor.TICKET,'provided','not provided')%><BR/>
				&nbsp;e). Health Insurrance <%=Iif(fcursor.HINSURANCE,'provided','not provided')%><BR/>
				&nbsp;f). Other fringe benefits as per local labour laws</P>
            <p style="text-align: justify;">
				I undertake that the above information are correct, and the demand received through electronic visa slip is genuine. 
            </p>
			<p style="text-align: justify;">
			    I/We further undertake that:
				<table style="border-top: 0px; border-bottom: 0px;">
                    <tr>
                        <td style="vertical-align: top;border:0px;">1.&nbsp;</td>
                        <td>In the event of the afforesaid information being found false or incorrect in any aspect, the recruiting permission shall be liable to legal and disciplinary action.
                    </tr>
                        <td style="vertical-align: top;border:0px;">2.&nbsp;</td>
                        <td>In case any worker proceeding abroad in accordance with the permission is unable to secure job, I shall bear all the cost of his/her repartriation.
                </table>
            </p>
            
        </div>
            </body>
    </html>



    <!--APPKSA-Applicant Receipt, APPKSA-Undertaking for registration, Visa-Undertaking 1 Plan paper -->