";
    // var_dump($_POST['fileselected']);
    // die();
    $xpersonal = $_POST['txt'];
    $xappcode = $xpersonal['appcode'];

    $xqry = "SELECT * FROM applicantfile WHERE appcode=?";
    $xstmt = $link_id->prepare($xqry);
    $xstmt->execute(array($xappcode));
    $rs = $xstmt->fetch();        
        
    if($_FILES['uploadedfile']['name'] == "")
    {
        $xrec_params =array();
        $xrec_params['emppic']= $_POST['profilepicture'];
        PDO_UpdateRecord($link_id,'applicantfile',$xrec_params,'appcode=?',array($xappcode),false);
    }
    else
    {
        $filename = $_FILES['uploadedfile']['name'];
        $ext = pathinfo($filename, PATHINFO_EXTENSION);
        $target_dir ="application/uploads";
        $target_file = $target_dir . "/PP-".$xappcode."-".$filename;

        if($target_file != $rs['emppic'])
        {
            if (move_uploaded_file($_FILES["uploadedfile"]["tmp_name"], $target_file))
            {
                $xpersonal['emppic']=$target_file;
            }

            $xrec_params =array();
            $xrec_params['emppic']= $xpersonal['emppic'];
            PDO_UpdateRecord($link_id,'applicantfile',$xrec_params,'appcode=?',array($xappcode),false);
        }
    }
}
    


    if( isset($_POST['attach_action']) && trim($_POST['attach_action'])== 'saveatt' )
    {
        $date = date('Y-m-d');
        $par = 'add';
        $recid2 = $_POST['xrecid'];
        $field = $_POST['field'];
        $arr_record = $_POST['field'];
        $arr_record['filepath'] =$_POST['filepath'];
        $arr_record['filename'] = $_FILES['attachfile']['name'];
        $arr_record['appcode'] =$xappcode;
        $arr_record['doccode'] = $_POST['doccode'];
        $arr_record['dte'] = $date;
        $arr_record['dsc'] = $_POST['description'];

        $xfield['dte']= 'Applicant Document Attach Date';
        $xfield['doccode']= 'Applicant Document Attach Code';
        $xfield['filename']= 'Applicant Document Attachment File';
        $xfield['dsc']= 'Applicant Document Attachment Description';
        
        $recid = $_POST['item_id'];
        $xusrcde1 = ($_SESSION[$xg_appkey]['usrcde']);
        $xfullname1 = ($_SESSION[$xg_appkey]['fullname']);
        $xtablename1 = 'applicantattachments';
        $xprogmodule1 = "Applicant Attachment";
        $xsuccess1 = true;
        $xwebpage1 = "http://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";
        
        $xbool=true;
        $xqry="SELECT * FROM applicantattachments";
        $xstmt=$link_id->prepare($xqry);
        $xstmt->execute();
        while($xrs=$xstmt->fetch())
        {
         //~ var_dump($recid2);
            if($arr_record['filename']==$xrs['filename'] && $recid2!=$xrs['recid'])
            {
                $xbool=false;
            }   
        }
        
        if($xbool)
        {
            if( $_POST['attachtype'] == 'add' )
            {   
                foreach ($_POST['attach'] as $key => $value)
                {
                    $filename = $_FILES['uploadedfile']['name'];
                    $ext = pathinfo($filename, PATHINFO_EXTENSION);
                    $target_dir ="application/employeeattachments";
                    $target_file = $target_dir . "/AT-".$xappcode."-".$filename;
                    if (move_uploaded_file($_FILES["uploadedfile"]["tmp_name"], $target_file))
                    {
                        $value['appcode'] = $xappcode;
                        $value['dte'] = $date;
                        $value['filename'] = $_FILES['attachfile']['name'][$key];
                        if($value['filename'] != '')
                        {
                            PDO_InsertRecord($link_id,'applicantattachments',$value,false);    
                        }
                    }
                    
                }
                $xaction1 = "Add";
                $xactivity1 = "Add Applicant Attachment";
                $xremarks1 = "Add Applicant Attachment : ".$arr_record['filename'];
                PDO_UserActivityLog($link_id, $xtablename1 , $xfullname1 , $xusrcde1 , $xactivity1 , $xremarks1, $xwebpage1, $xaction1, $xprogmodule1 , $xsuccess1,$xnewval,$xoldval,$xhead);       
            }
            else if($_POST['attachtype'] == 'edit')
            {
                foreach ($_POST['attach'] as $key => $value) {
                    $xrecid = $value['recid'];
                    unset($value['recid']);
                    // var_dump($value['dsc']);
                    $value['appcode'] = $xappcode;
                    $value['dte'] = $date;
                    $value['filename'] = $_FILES['attachfile']['name'][$key];
                    if($value['filename'] == '')
                    {       
                        unset($value['filename']);
                    }
                    PDO_UpdateRecord($link_id,'applicantattachments', $value,'recid=?', array($xrecid),false);
                };
            }
        }
        else
        {
            echo "";
            //~ echo "";
        }

        
        echo "";
    }
?>






    


prepare($xqry);
    $stmt->execute(array($next_docnum));

    lockunlock_docnum('syspar', 'appdocnumlock', 0);

    $xappcode=$xdocnum['appcodedocnum'];
}
else
{
    $xappcode = $_POST['txt']['appcode'];
    $sql = "SELECT * FROM applicantfile WHERE appcode=?";
    $stmt = $link_id->prepare($sql);
    $stmt->execute(array($xappcode));
    $rs_app = $stmt->fetch();

    $sql1 = "SELECT * FROM applicantextension WHERE appcode=?";
    $stmt1 = $link_id->prepare($sql1);
    $stmt1->execute(array($xappcode));
    $rs_ext = $stmt1->fetch();

    $sql2 = "SELECT * FROM applicantfilesub WHERE appcode=?";
    $stmt2 = $link_id->prepare($sql2);
    $stmt2->execute(array($xappcode));
    $rs_sub = $stmt2->fetch();

// echo "
";
//     var_dump($rs_ext);
//     die();
}

// var_dump($xappcode);

$disable="hidden";
$type="button";

    
        
?>



    
    
        

            
            
            

            

            

            


             Save snapshot ? 

            
 Please wait while file is uploading... 

            Yes
            No

            

                
            

            Take Snapshot
        

        
        
        
        
        
        
           
    

        

            

                
                style='width:100%;height:100%;overflow:hidden' title="Profile Picture" > ";}else{echo "";}?>
            
        
        

        
            
            
            
            
        
    






	

	
Position Applied 1 :
	

		
            
		
	
   

	
Application Number : 
        
    
	
    

    
Position Applied 2 :
    

        
            
        
    
    
    

    

        

    

    
Position Applied 3 :
    

        
           
        
    
    





PERSONAL DATA





    

        

        

            	
Last Name : 
            	
    
            	
First Name : 
            	

            	
Middle Name : 
            	

                
Nickname : 
                

        	
        	

                
BIRTHDATE : 
                

            	
AGE : 
            	

            	
Gender :
            	

                    
                    
                    
                		 value='male'>MALE
                		 value='female'>FEMALE
                   
            	
            	
Status : 
            	

                   
                    
                	{$xcivilstat[$i]}";
                        }
                    ?>
                   
            	
        	
            

                
Birthplace : 
                

                    
                
                
                
                
City : 
                

                    
                
                
                
                
RELIGION:
                

                    
                        
                        
                    
                
                
CITIZENSHIP:
                

                    
                        
                        
                    
                
            
            

                
Height : 
                
 FT
                
Weight :
                
 lbs
                
Blood Type : 
                

                   
                    
                    {$xbloodtype[$i]}";
                        }
                    ?>
                   
                
    
            
            

                

                

Mailing Address

                

Permanent Address

            
            
    
                
No.,Street,Brgy:
                

                
No.,Street,Brgy:
                

            
            

                
Town / City:
                

                
Town / City:
                

            
            

                
State / Province:
                

                    
                        prepare("SELECT prov FROM regionprovcityfile GROUP BY prov");
                        $xstmt_empadd3->execute();
                        while($xrs_empadd3 = $xstmt_empadd3->fetch())
                        {
                            $xselected = '';
                            $xprov = $xrs_empadd3['prov'];
                            if( $xprov == $rs_app['empadd2'] )
                            {
                                $xselected = 'selected';
                            }
                            echo "" . $xprov . "";
                        }
                        ?>
                
                
State / Province:
                

                    
                        prepare("SELECT prov FROM regionprovcityfile GROUP BY prov");
                            $xstmt_empadd3->execute();
                            while($xrs_empadd3 = $xstmt_empadd3->fetch())
                            {
                                $xselected = '';
                                $xprov = $xrs_empadd3['prov'];
                                if( $xprov == $rs_app['empper_add2'] )
                                {
                                    $xselected = 'selected';
                                }
                                echo "" . $xprov . "";
                            }
                            ?>
                
            
            

                
Country:
                

                    
                    
                
                
Country:
                

                
                
                
            
            

                
Area:
                

                    
                        
                
                
Area:
                

                    
                        
                
            

            

                

                

Contact Address

                

If Married

            
            
    
                
Mobile No:
                

                
Date of Marriage:
                

            
            

                
Telephone Number:
                

                
No. of Children:
                

            
            

                
Personal E-mail:
                

            
            

                
Office E-mail:
                

            
        
    








EMERGENCY CONTACT




            

            

                     
Name
                     
Contact No.
                     
Address
                     
Relationship
                
                

                    

                    
'>
                    
'  class = 'txtbox'>
                    
'>
                
                 

                    
'  class = 'input txtbox as_fld' data-db_col="case_emer2">

                    
'  class = 'input txtbox as_fld' data-db_col="emer_tel2">

                    
'  class = 'input txtbox as_fld' data-db_col="emer_add2">
                    
'  class = 'input txtbox as_fld' data-db_col="empcontactrel2">
                
                 

                    
'  class = 'input txtbox as_fld' data-db_col="case_emer3">

                    
'  class = 'input txtbox as_fld' data-db_col="emer_tel3">

                    
'  class = 'input txtbox as_fld' data-db_col="emer_add3">

                    
'  class = 'input txtbox as_fld' data-db_col="empcontactrel3">
                
                
            





REFERENCE

 
 




    
    

    

prepare($xqry);
            $xstmt->execute(array($xappcode));
            // var_dump($xstmt->fetchAll());
            // die();
            $tablenameref = 'appempreffile';
            while($rs_rfrnce = $xstmt->fetch())
            {
                $groupkey = $rs_rfrnce['recid'];

                if($rs_rfrnce['refrel'] == 'Neighbor')
                {
                    $option1 = 'selected';
                }
                else if($rs_rfrnce['refrel'] == 'Schoolmate')
                {
                    $option2 = 'selected';
                }
                else if($rs_rfrnce['refrel'] == 'Close Relative')
                {
                    $option3 = 'selected';
                }
                else if($rs_rfrnce['refrel'] == 'Former Officemate')
                {
                    $option4 = 'selected';
                }

                $echoref.= "";  
            } 
            echo $echoref;
        }
        ?>
    

    

        
FullName
        
Relationship
        
Address
        
Contact No.
        

    
    

        

                    
                    

                        
                    
                    

                        
                        Neighbor
                        Schoolmate
                        Close Relative
                        Former Officemate
                    
                    

                        
                    
                    

                        
                    
                    

                        
                    
                
    



    
    




RELATIVES AND/OR FRIENDS EMPLOYED BY SUMISHO

 
 




    
    

    

prepare($xqry);
            $xstmt->execute(array($xappcode));
            $tablenamerel = 'applicantrelincompfile';
            while($rs_rel = $xstmt->fetch())
            {
                $xopt_position = ListOption2_pdo($link_id,'positionfile2','poscode','posdesc',$rs_rel['poscode'],'',array(),false);
                $groupkey = microtime(true);
                $echorel.="";  
            } 
            echo $echorel;
        }
        ?>
    

    

        
FullName
        
Relationship
        
Position
        

    
    

        

                        

                            
                        
                        

                            
                        
                        

                            
                            ".$xopt_position."
                        
                        

                            
                        
                    
    

    
    





FATHER INFO






    

    

        
Father's Name: 
        
' />
        
Occupation
        
'/>
    
    

        
Birthdate: 
        
'>
        
Business Address
        
' onpaste='return false' maxlength='30' class = 'input ae_fld' data-db_col="fbusinessadd" />
    
    

        
Home Tel: 
        
' maxlength='13' onpaste='return false' maxlength='30' class = 'input numeric ae_fld' data-db_col="ftelno" />
        
Work Tel
        
' maxlength='13 onpaste='return false' maxlength='30' class = 'input numeric ae_fld' data-db_col="fwtelno" />
    
    

        
Mobile: 
        
' maxlength='13' onpaste='return false' maxlength='30' class = 'input numeric ae_fld' data-db_col="fmobile" />
        
Email
        
' onpaste='return false' maxlength='30' class = 'input ae_fld' data-db_col="femail" />
    
    

        
Religion: 
        

            
            
        
        
        
Citizenship
        

            
        
    






MOTHER INFO






    

    

        
Mother's Name: 
        
'  onpaste='return false' maxlength='30' class = 'input af_fld' data-db_col="mothername" />
        
Occupation
        
'  onpaste='return false' maxlength='30' class = 'input af_fld' data-db_col="moccupation" />
    
    

        
Birthdate: 
        
' onpaste='return false' maxlength='30' class = 'input datepicker ae_fld' data-db_col="mbirthdate"  placeholder="mm/dd/yyyy"/>
        
Business Address
        
' onpaste='return false' maxlength='30' class = 'input ae_fld' data-db_col="mbusinessadd"/>
    
    

        
Home Tel: 
        
' maxlength='13' onpaste='return false' maxlength='30' class = 'input numeric ae_fld' data-db_col="mtelno" />
        
Work Tel
        
' maxlength='13' onpaste='return false' maxlength='30' class = 'input numeric ae_fld' data-db_col="mwtelno"/>
    
    

        
Mobile: 
        
' maxlength='13' onpaste='return false' maxlength='30' class = 'input numeric ae_fld' data-db_col="mmobile" />
        
Email
        
' maxlength='13' onpaste='return false' maxlength='30' class = 'input ae_fld' data-db_col="memail" />
    
    

        
Religion: 
        

            
            
        
        
        
Citizenship
        

            
        
    






SPOUSE INFO






    

    

        
Spouse's Name: 
        
' onpaste='return false' maxlength='30' class = 'input af_fld' data-db_col="spousename" />
        
Occupation
        
' onpaste='return false' maxlength='30' class = 'input af_fld' data-db_col="soccupation" />
    
    

        
Address: 
        
' onpaste='return false' maxlength='30' class = 'input ae_fld' data-db_col="saddress" />
        
Telephone No.
        
' maxlength="13" onpaste='return false' maxlength='30' class = 'input numeric ae_fld' data-db_col="stelno" />
    
    

        
Work Tel: 
        
' maxlength="13" onpaste='return false' maxlength='30' class = 'input numeric ae_fld' data-db_col="swtelno" />
        
Mobile: 
        
' maxlength="13" onpaste='return false' maxlength='30' class = 'input numeric ae_fld' data-db_col="smobile"/>
    
    

        
Email: 
        
' onpaste='return false' maxlength='30' class = 'input ae_fld' data-db_col="semail" />
        
Tin No: 
        
' onpaste='return false' maxlength='30' class = 'input ae_fld' data-db_col="stin" />
    







SIBLINGS


 




    
    

    

prepare($xqry);
            $xstmt->execute(array($xappcode));
            $tablenamesibling = 'applicantsiblings';
            while($rs_siblings = $xstmt->fetch())
            {

                if(strtoupper($rs_siblings['cgender']) == 'MALE')
                {
                    $optionmale = 'selected'; 
                }
                else if(strtoupper($rs_siblings['cgender']) == 'FEMALE')
                {
                    $optionfemale = 'selected';
                }

                    
                $groupkey = microtime(true);
                $echosiblings.="";  
            } 
            echo $echosiblings;
        }
        ?>
    

    

        
Name: 
        
Employment: 
        
Date of Birth: 
        
Gender: 
        
Age: 
        
Mental Incapacity: 
        

    
    

        

                        
                        

                            
                        
                        

                            
                        
                        

                            
                        
                        

                            
                            Male
                            Female
                        
                        

                            
                        
                        

                            
                        
                        

                            
                        
                    
    
 


    
    

    


    

    

    
CHILDREN
    
    
 
     
    

    

        
        

        

    prepare($xqry);
                $xstmt->execute(array($xappcode));
                $tablenamechild = 'applicantchildren';
                while($rs_children = $xstmt->fetch())
                {

                    if(strtoupper($rs_children['cgender']) == 'MALE')
                    {
                        $optionmale = 'selected'; 
                    }
                    else if(strtoupper($rs_children['cgender']) == 'FEMALE')
                    {
                        $optionfemale = 'selected';
                    }

                        
                    $groupkey = microtime(true);
                    $echochild.="";  
                } 
                echo $echochild;
            }
            ?>
        

        

            
Name: 
            
Employment: 
            
Date of Birth: 
            
Gender: 
            
Age: 
            
Mental Incapacity: 
            

        
        

            

                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                                Male
                                Female
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                        
    
    
    

        
        

        



    

    
GUARDIAN / OTHERS
    
    
 
     
    

    

        
        

        

    prepare($xqry);
                $xstmt->execute(array($xappcode));
                $tablenameguardian = 'applicantotherrelations';
                while($rs_guardian = $xstmt->fetch())
                {

                    if(strtoupper($rs_guardian['reldsc']) == '1ST DEGREE')
                    {
                        $option1 = 'selected'; 
                    }
                    else if(strtoupper($rs_guardian['reldsc']) == '2ND DEGREE')
                    {
                        $option2 = 'selected';
                    }
                    else if(strtoupper($rs_guardian['reldsc']) == '3RD DEGREE')
                    {
                        $option3 = 'selected';
                    }
                    else if(strtoupper($rs_guardian['reldsc']) == '4TH DEGREE')
                    {
                        $option4 = 'selected';
                    }

                        
                    $groupkey = microtime(true);
                    $echoguardian.="";  
                } 
                echo $echoguardian;
            }
            ?>
        

        

            
Relationship: 
            
Name: 
            
Date of Birth: 
            
Address: 
            
Contact No.: 
            
Mental Incapacity: 
            
Description: 
            

        
        

            

                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                                1st Degree
                                2nd Degree
                                3rd Degree
                                4th Degree
                            
                            

                                
                            
                        
    
    
    

        
        

        
    





EDUCATIONAL BACKGROUND (HIGHEST EDUCATIONAL ATTAINMENT)

 
 




    
    

    

prepare($xqry);
            $xstmt->execute(array($xappcode));
            $tablenameeduc = 'applicantschool';
            $groupkey = microtime(true);
            while($rs_educ = $xstmt->fetch())
            {
                $xopt_level = ListOption2_pdo($link_id,'educstatfile','statcode','statdesc',$rs_educ['schlevel'],'',array(),false);
                $xopt_school = ListOption2_pdo($link_id,'schoolfile','schcode','schdesc',$rs_educ['schcode'],'',array(),false);
                    
                
                $echoeduc.="";  
            } 
            echo $echoeduc;
        }
        ?>
    

    

        
Level / Degree
        
School
        
Major / Specialization
        
GPA / SCORE
        
START DATE
        
END DATE
        

    
    

        

                            
                            

                                
                                ".$xopt_level."
                                
                            
                            

                                
                                ".$xopt_school."
                                
                            
                            
    
                                
                            
                            

                                
                            
                            

                                
                            
   
                            

                                
                            
                            

                                
                            
                        
    


    
    

    




SKILLS

 
 




    
    

    


prepare($xqry);
            $xstmt->execute(array($xappcode));
            $tablenameskill = 'applicantskills';
            // echo "
";
            while($rs_skills = $xstmt->fetch())
            {   
                // var_dump($rs_skills);
                $xopt_skillfile = ListOption2_pdo($link_id,'skillfile','skillcode','skilldesc',$rs_skills['skillcode'],'',array(),false);
                $xopt_exp = ListOption2_pdo($link_id,'experiencelevelfile','explvlcde','explvldsc',$rs_skills['exlvl'],'',array(),false);
                $xopt_level = ListOption2_pdo($link_id,'levelfile','levelcde','leveldsc',$rs_skills['proflvl'],'',array(),false);
                    
                $groupkey = $rs_skills['recid'];
                $echoskill.="
";
            } 
            // die();
            echo $echoskill;
        }
        ?>
    

    

        
Skill
        
Years Of Experience
        
Experience Level
        
Proficiency Level
        

    
    

        

                            
                            

                                
                                ".$xopt_skillfile."
                                
                            
                            

                                
                            
                            

                                
                                ".$xopt_exp."
                                
                            
                            

                                
                                ".$xopt_level."
                                
                            
                            

                                
                            
                            
                        
  





LANGUAGES

 
 




    
    

    


prepare($xqry);
            $xstmt->execute(array($xappcode));
            $tablenamelang = 'emplangfile';
            // echo "
";
            while($rs_language = $xstmt->fetch())
            {   
                // var_dump($rs_skills);
                $xopt_language = ListOption2_pdo($link_id,'languagefile','langcode','langdesc',$rs_language['langcde'],'',array(),false);
                
                if($rs_language['langspeak'] == 'Fair')
                {
                    $optionspeak1 = 'selected';
                }
                else if($rs_language['langspeak'] == 'Good')
                {
                    $optionspeak2 = 'selected';
                }
                else if($rs_language['langspeak'] == 'Very Good')
                {
                    $optionspeak3 = 'selected';
                }

                if($rs_language['langread'] == 'Fair')
                {
                    $optionread1 = 'selected';
                }   
                else if($rs_language['langread'] == 'Good')
                {
                    $optionread2 = 'selected';
                }
                else if($rs_language['langread'] == 'Very Good')
                {
                    $optionread3 = 'selected';
                }

                if($rs_language['langwrite'] == 'Fair')
                {
                    $optionwrite1 = 'selected';
                }
                else if($rs_language['langwrite'] == 'Good')
                {   
                    $optionwrite2 = 'selected';
                }
                else if($rs_language['langwrite'] == 'Very Good')
                {
                    $optionwrite3 = 'selected';
                }

                $groupkey = $rs_language['recid'];
                $echolang.="
";
            } 
            // die();
            echo $echolang;
        }
        ?>
    

    

        
Language
        
Speak
        
Read
        
Write
        

    
    

        

                            
                            

                                
                                ".$xopt_language."
                                
                            
                            

                                
                                Fair
                                Good
                                Very Good
                                
                            
                            

                                
                                Fair
                                Good
                                Very Good
                                
                            
                            

                                
                                Fair
                                Good
                                Very Good
                                
                            
                            

                                
                            
                        
  




AWARDS

 
 




    
    

    


prepare($xqry);
            $xstmt->execute(array($xappcode));
            $tablenameaward = 'applicantaward';
            // echo "
";
            while($rs_award = $xstmt->fetch())
            {   
                // var_dump($rs_skills);
                $xopt_award = ListOption2_pdo($link_id,'awardfile','awardcode','awarddesc',$rs_award['awardcode'],'',array(),false);
                    
                $groupkey = $rs_award['recid'];
                $echoaward.="
";
            } 
            // die();
            echo $echoaward;
        }
        ?>
    

    

        
Award: 
        
Date Issued: 
        
Issued by: 
        
External Awards / Others: 
        

    
    

        

                            
                            

                                
                                ".$xopt_award."
                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                        
  


    
    
  



Certifications

 
 




    
    

    


prepare($xqry);
            $xstmt->execute(array($xappcode));
            $tablenamecert = 'applicantcertificate';
            // echo "
";
            while($rs_cert = $xstmt->fetch())
            {   
                $groupkey = $rs_cert['recid'];
                $echocert.="
";
            } 
            // die();
            echo $echocert;
        }
        ?>
    

    

        
Description: 
        
Score: 
        
Date Valid: 
        
Expiry Date: 
        

    
    

        

                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            

                                
                            
                        
  


    
    

    
  



SEMINARS/TRAININGS ATTENDED

 
 




    
    

    


prepare($xqry);
            $xstmt->execute(array($xappcode));
            $tablenamesem = 'applicantseminar';
            // echo "
";
            while($rs_seminar = $xstmt->fetch())
            {   
                $groupkey = $rs_seminar['recid'];
                $echoseminar.="
";
            } 
            // die();
            echo $echoseminar;
        }
        ?>
    

    

        
Description: 
        
Venue: 
        
Date From: 
        
End From: 
        
Cost: 
        
Paid By: 
        
Internal/External: 
        

    
    

        

                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                        
  


    
    

    
  



WORK EXPERIENCE

 
 




    
    

    


prepare($xqry);
            $xstmt->execute(array($xappcode));
            $tablenamework = 'applicantrecord';
            // echo "
";
            while($rs_work = $xstmt->fetch())
            {   
                $groupkey = $rs_work['recid'];
                $echowork.="
";
            } 
            // die();
            echo $echowork;
        }
        ?>
    

    

        
Company: 
        
Job Title: 
        
From: 
        
To: 
        
Salary: 
        

    
    

        

                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                        
  


    
    

    




MEMBERSHIP

 
 




    
    

    


prepare($xqry);
            $xstmt->execute(array($xappcode));
            $tablenamemember = 'employeemembership';
            // echo "
";
            while($rs_member = $xstmt->fetch())
            {   
                if($rs_member['subpaidby'] == 'Company')
                {
                    $option1 = 'selected';
                }
                else if($rs_member['subpaidby'] == 'Employee')
                {
                    $option2 = 'selected';
                }

                $xopt_membership = ListOption2_pdo($link_id,'membershipfile','memdesc','memdesc',$rs_member['memdesc'],'',array(),false);
                $xopt_currency = ListOption2_pdo($link_id,'currencyfile','curcde','curdsc',$rs_member['currency'],'',array(),false);
                $groupkey = $rs_member['recid'];
                $echomember.="
";
            } 
            // die();
            echo $echomember;
        }
        ?>
    

    

        
Type: 
        
No.: 
        
Date Start: 
        
Expiration Date: 
        
Paid by: 
        
Amount: 
        
Currency: 
        

    
    

        

                            
                            

                                
                                ".$xopt_membership."
                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            

                                
                                Company
                                Employee
                                
                            
                            

                                
                            
                            

                                
                                ".$xopt_currency."
                                
                            
                            

                                
                            
                        
  


    
    

    




IMMIGRATION

 
 




    
    

    


prepare($xqry);
            $xstmt->execute(array($xappcode));
            $tablenameimmi = 'employeeimmigrationfile';
            // echo "
";
            while($rs_immigration = $xstmt->fetch())
            {   
                if($rs_member['subpaidby'] == 'Passport')
                {
                    $option1 = 'selected';
                }
                else if($rs_member['subpaidby'] == 'Visa')
                {
                    $option2 = 'selected';
                }

                $xopt_country = ListOption2_pdo($link_id,'countryfile','cntrycde','cntrydsc',$rs_immigration['issby'],'',array(),false);
                $groupkey = $rs_immigration['recid'];
                $echoimmi.="
";
            } 
            // die();
            echo $echoimmi;
        }
        ?>
    

    

        
Document: 
        
Number.:     
        
Issued Date: 
        
Expiry Date: 
        
Eligible Status: 
        
Issued by: 
        
Eligible Review Date: 
        

    
    

        

                            
                            

                                
                                Passport
                                Visa
                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                                ".$xopt_country."
                                
                            
                            

                                
                            
                            

                                
                            
                        
  


    
    

    




REQUIREMENTS

 
 




    
    

    


prepare($xqry);
            $xstmt->execute(array($xappcode));
            $tablenamereq = 'applicantrequirementsfile';
            // echo "
";
            while($rs_requirements = $xstmt->fetch())
            {   
                $xopt_requirement = ListOption2_pdo($link_id,'requirementsnamefile','requirementcde','requirementname',$rs_requirements['requirement'],'',array(),false);
                $groupkey = $rs_requirements['recid'];
                $echoreq.="
";
            } 
            // die();
            echo $echoreq;
        }
        ?>
    

    

        
Requirement: 
        
Date Issued: 
        
Expiry Date: 
  
        

    
    

        

                            
                            

                                
                                ".$xopt_requirement."
                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                        
  


    
    

    




LICENSES

 
 




    
    

    


prepare($xqry);
            $xstmt->execute(array($xappcode));
            $tablenamelic = 'applicantlicenses';
            // echo "
";
            while($rs_license = $xstmt->fetch())
            {   
                $xopt_license = ListOption2_pdo($link_id,'licensefile','licode','lidesc',$rs_license['licname'],'',array(),false);
                $groupkey = $rs_license['recid'];
                $echolicense.="
";
            } 
            // die();
            echo $echolicense;
        }
        ?>
    

    

        
License Type: 
        
License No.: 
        
Date Issued: 
        
Expiry Date: 
  
        
Place Issued: 
  
        

    
    

        

                            
                            

                                
                                ".$xopt_license."
                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                            

                                
                            
                        
  



ATTACHMENTS

 
 
prepare($xqry);
        $xstmt->execute();
        while($xrs = $xstmt->fetch())
        {   
            $attachments .= "";
            
            $xqry1='select * from applicantattachments where appcode=? AND doccode=?';
            $xstmt1=$link_id->prepare($xqry1);
            $xstmt1->execute(array($rs_app['appcode'], $xrs['doccode']));
            $xtableattach = 'applicantattachments';
            if($xrs1=$xstmt1->fetch())
            {
                $attachments .= "";
                $attachments .= "";

                $attachments .= "";

                $attachments .= "";
                $attachments .= "
"; 
            }
            else
            {
                $attachments .= "";
                $attachments .= "";

                $attachments .= "";

                $attachments .= "
"; 
            }                                 
        }

        $attachments .= "

    

        
Document Type
        
Filename
        
Description
        
Action
    
    

        

            
".$xrs['doccode']." (.doc maximum size:2MB)
".$xrs1['filename']."

                
                

                ";

                $attachments .= "
                
".$xrs1['filename']."

                
                

                ";
                $attachments .= "
";
        echo $attachments;
        ?>  
        

        
        
        
        
        
        
        
        
        
    
  


    
    

    












prepare($xqry);
      $xstmt->execute(array($_POST['item_id2']));
      $xrs=$xstmt->fetch();
      
      unlink($xrs['filepath'].$xrs['filename']); 
        $query  = "Delete FROM applicantattachments where recid=?";
        $stmt   = $link_id->prepare($query);
        $stmt->execute(array($_POST['item_id2']));
    }

    
 ?>