<?php
	// ini_set("display_errors", true);
	// error_reporting(E_ALL);
	require_once("appconfig.php");
	require_once("./include/JSON.php");
	
	if(isset($_POST['event_action']) && trim($_POST['event_action']) == 'show_addform')
	{
		$xtableid = trim($_POST['tableid']);
		$xitemid = trim($_POST['itemid']);
		$xpar = trim($_POST['xpar']);
		$xnewtbid = "form".$xtableid;
		$xform = "<table id = {$xnewtbid} border = '0' width='80%'>";
		$xtable = get_table($xtableid);
		$xreadonly = "";
		$dateclass = "class_date";
		if($xpar == 'edit')
		{
			$xreadonly = "readonly";
			$dateclass = "";
			$sql_edit = "SELECT * FROM $xtable WHERE recid = ?";
			$stmt_edit = $link_id->prepare($sql_edit);
			$stmt_edit->execute(array($xitemid));
			$rs_edit = $stmt_edit->fetch();
		}
		if($xtableid =='eduback2' || $xtableid =='appeduback2')
		{
			$xform.="
					<tr>
						<td width = '20%'>Level/Degree: *</td>
						<td width = '30%'>
							<select name='txtfields[schlevel]' class=' txtbox reqfld' style='width:138px;'  >";
							$sql = "SELECT * FROM educstatfile";
							$stmt = $link_id->prepare($sql);
							$stmt ->execute();
							while($rs = $stmt->fetch())
							{
								$xstate = $rs_edit['schlevel'] == $rs['statdesc'] ?"selected" :'';
								
								$xform.="<option {$xstate} >".$rs['statdesc']."</option>";
							}
								  
								  $xform.=" </select>
						</td>
						<td width = '20%'>School: *</td>
						<td><input name='txtfields[schdesc]' type='text' value='".$rs_edit['schdesc']."'  autocomplete='off' class = 'txtbox reqfld' /></td>
					</tr>
					
					<tr>
						<td>Major/ Specialization:</td>
						<td><input name='txtfields[schcourse]' type='text' value='".$rs_edit['schcourse']."'  autocomplete='off' class = 'txtbox reqfld' /></td>
				  
				   
						 <td>GPA/Score:</td>
						<td><input name='txtfields[schave]' type='text' value='".$rs_edit['schave']."'  autocomplete='off' class = 'txtbox' /></td>
					</tr>
					<tr>
						
						<td>Start Date: *</td>
						<td><input class=' txtbox' name='txtfields[strtdte]' type='text' value='".$rs_edit['strtyear']."'  autocomplete='off'  /></td>
						<td>End Date: *</td>
						<td><input class=' txtbox' name='txtfields[enddte]' type='text' value='".$rs_edit['endyear']."'  autocomplete='off'  /></td>
					</tr>
					<tr>
						<td>Year Graduated: </td>
						<td><input name='txtfields[schyear]' type='text' value='".$rs_edit['schyear']."'  autocomplete='off' class = 'txtbox' /></td>
                    
					</tr>
					<tr height = '10%'>
                    
						<td>Notes:</td>
						<td rowspan = '2' colspan = '3'  >
							<textarea  rows = '5' style = 'resize:none' name='txtfields[notes]'  >".$rs_edit['notes']."</textarea>
						</td>
					</tr>
					<tr>                
						<td>&nbsp</td>
					</tr>
					<tr>

						<td>&nbsp</td>
						<td>Note: * Required Fields</td>
					</tr>
                
				<tr>
                   
              
                </tr>
				";
				
               
		}
		if($xtableid =='skiback2' || $xtableid =='appskiback2')
		{
			$xform .=" <tr>
                    <td>Skills: *</td>
                    <td>
                        <select name='txtfields[skilldesc]' class='style reqfld txtbox' style='width:138px;' >";
						 $sql_skll = "SELECT skilldesc FROM skillfile";
						 $stmt_skll = $link_id->prepare($sql_skll);
						 $stmt_skll->execute();
						 while($rs_skll = $stmt_skll->fetch())
						 {
							$xstate = $rs_edit['skilldesc'] == $rs_skll['skilldesc'] ? "selected":"";
							$xform .= "<option {$xstate}>".$rs_skll['skilldesc']." </option>";
						 }
             $xform .="</select>
                    </td>
                </tr>
				<tr>
                    <td>Years of Experience *:</td>
                    <td>
                       <input type = 'text' name = 'txtfields[exyear]' id = 'txtexyear' value = '".$rs_edit['exyear']."' class = 'reqfld txtbox' />
                    </td>
                
                    <td>Experience Level *</td>
                    <td>
					<select name='txtfields[exlvl]' class='style reqfld txtbox' style='width:138px;'>";
					$sql_lvl = "SELECT level FROM levelfile";
					$stmt_lvl = $link_id->prepare($sql_lvl);
					$stmt_lvl->execute();
					while($rs_lvl = $stmt_lvl->fetch())
					{
						$xstate = $rs_edit['exlvl'] == $rs_lvl['level'] ? "selected":"";
						$xform .="<option {$xstate}>". $rs_lvl['level']." </option>";
					}
                      $xform .="
                        </select>
					</td>
                </tr>
                <tr>
                    <td>Proficiency Level *:</td>
                    <td>
						<select name='txtfields[proflvl]' class='style reqfld txtbox' style='width:138px;'>";
						$sql_prf = "SELECT level FROM levelfile";
						$stmt_prf = $link_id->prepare($sql_prf);
						$stmt_prf->execute();
						while($rs_prf = $stmt_prf->fetch())
						{
							$xstate = $rs_edit['proflvl'] == $rs_prf['level'] ? "selected":"";
							$xform .="<option {$xstate}>". $rs_prf['level']." </option>";
						}
                     $xform .="
                        </select>
					</td>
					<td>Priority (Numeric) *:</td>
                    <td><input name='txtfields[priority]' type='text' value='".$rs_edit['priority']."'  autocomplete='off' class = 'reqfld txtbox' /></td>
                </tr>
                <tr height = '10%'>
                    <td>Remark:</td>
                    <td colspan = '3' rowspan = 2>
						<textarea   rows = '5' name='txtfields[remark]'   style = 'resize:none'>".$rs_edit['remark']."</textarea>
					</td>
                </tr>
				<tr>

						<td>&nbsp</td>
						
					</tr>
				<tr>

						<td>&nbsp</td>
						<td>Note: * Required Fields</td>
					</tr>
				
               ";
		}
		
		if($xtableid =='langback2')
		{
			$xform .= " <tr>
                    <td>Language</td>
                    <td>
						<select name = 'txtfields[langcde]' class = 'reqfld style txtbox'>";
						 $sql_skll = "SELECT langdesc FROM languagefile";
						 $stmt_skll = $link_id->prepare($sql_skll);
						 $stmt_skll->execute();
						 while($rs_skll = $stmt_skll->fetch())
						 {
							$xstate = $rs_edit['langcde'] == $rs_skll['langdesc'] ? "selected":"";
							$xform .= "<option {$xstate}>".$rs_skll['langdesc']." </option>";
						 }
				$xform .="
						</select>
					</td>
            
                    <td>Fluency</td>
                    <td>
						<select name='txtfields[langfluency]'  class = 'reqfld style txtbox'>";
							$xstate = ($rs_edit['langfluency'] =='Writing'?'selected':'');
							$xform .="<option value = 'Writing'{$xstate}>Writing</option>";
							$xstate = ($rs_edit['langfluency'] =='Communication'?'selected':'');
						$xform .="	<option value = 'Communication'{$xstate}>Communication</option>
						</select>
					</td>
                </tr>
				<tr>
                    <td>Competency</td>
                    <td>
						<select name='txtfields[langcomp]'  class = 'reqfld style txtbox'>";
						$sql_skll = "SELECT level FROM levelfile";
						$stmt_skll = $link_id->prepare($sql_skll);
						$stmt_skll->execute();
						 while($rs_skll = $stmt_skll->fetch())
						 {
							$xstate = $rs_edit['level'] == $rs_skll['langcomp'] ? "selected":"";
							$xform .= "<option {$xstate}>".$rs_skll['level']." </option>";
						 }
						$xform .="
						</select>
					</td>
                </tr>
				<tr height = '10%'>
                    <td>Remarks</td>
                    <td colspan = 3 rowspan = 2>
						
						<textarea name='txtfields[remarks]' rows = '5' style = 'resize:none' id='txtremaks'>".$rs_edit['remarks']."</textarea>
					</td>
                </tr>
				<tr>
					<td>
						&nbsp;
					</td>
				</tr>
               ";
		}
		
		if($xtableid == 'extback2' || $xtableid =='appextback2')
		{
			$xform .="<tr>
						<td>Description *:</td>
						<td><input name='txtfields[certdesc]' type='text' value='".$rs_edit['certdesc']."'  autocomplete='off' class = 'txtbox reqfld' /></td>
						<td>Score *:</td>
						<td><input name='txtfields[score]' type='text' value='".$rs_edit['score']."'  autocomplete='off' class = 'txtbox reqfld' /></td>
					</tr>
					<tr>
						<td>Date Valid *:</td>
						<td><input name='txtfields[datevalid]' type='text' value='".display_date($rs_edit['datevalid'])."'  autocomplete='off' class = 'reqfld txtbox class_date ' placeholder='mm-dd-yyyy' /></td>
						<td>Expiry Date *:</td>
						<td><input name='txtfields[expdate]' type='text' value='".display_date($rs_edit['expdate'])."'  autocomplete='off' class = 'txtbox reqfld class_date' placeholder='mm-dd-yyyy' /></td>
					</tr>
					<tr height = '10%'>
					<td>Remarks:</td>
					<td colspan = '3' rowspan = '2'>
						<textarea  rows = '5' name='txtfields[remarks]' >".$rs_edit['remarks']."</textarea>
					</td>
					</tr>
					<tr>
						<td>&nbsp;</td>
					</tr>
					<tr>
						<td>&nbsp;</td>
						<td>Note: * Required Fields</td>
					</tr>";
		}
		if($xtableid == 'awdback2')
		{
			// var_dump($xform);
			$xform .=" <tr>
                   
					
                    <td>Award Code *:</td>
                    <td>
                        <select name='txtfields[awardcode]' class='style txtbox reqfld' style='width:138px;'>";
						 $sql_skll = "SELECT awardcode FROM awardfile";
						 $stmt_skll = $link_id->prepare($sql_skll);
						 $stmt_skll->execute();
						 while($rs_skll = $stmt_skll->fetch())
						 {
							$xstate = $rs_edit['awardcode'] == $rs_skll['awardcode'] ? "selected":"";
							$xform .= "<option {$xstate}>".$rs_skll['awardcode']." </option>";
						 }
                        $xform .="
                        </select> 
                    </td>
					 <td>Date Issued *:</td>
                    <td><input name='txtfields[awarddate]' id='awarddate' placeholder='mm-dd-yyyy' type='text' value='". display_date($rs_edit['awarddate'])."'  autocomplete='off' class = 'class_date txtbox reqfld' /></td>
                </tr>
                 <tr>
					 <td>Issued By *:</td>
                    <td><input name='txtfields[awardissuedby]' type='text' value='". $rs_edit['awardissuedby']."'  autocomplete='off' class = 'txtbox reqrfld' /></td>
                    <td>External Awards/Others:</td>
                    <td><input name='txtfields[awardexternal]' type='text' value='". $rs_edit['awardexternal']."'  autocomplete='off' class = 'txtbox' /></td>
                   
                </tr>
				<tr height = '10%'>
                    <td>Remarks:</td>
                    <td colspan = '3' rowspan = '2'>
						<textarea name='txtfields[awarddesc]' rows = '5' style ='resize:none'>". $rs_edit['awarddesc']."</textarea>
					</td>
                </tr>
				<tr>
                    <td>&nbsp;</td>
                    
                </tr>
				<tr>
                    <td>&nbsp;</td>
                    <td>Note: * Required fields</td>
                    
                </tr>"
				;
		}
		if($xtableid == 'semback2' || $xtableid =='appsemback2')
		{
			$xform .=" <tr>
						<td>Description *:</td>
						<td><input name='txtfields[seminardesc]' type='text' value='". $rs_edit['seminardesc']."'  autocomplete='off' class ='txtbox reqfld' /></td>
						<td>Venue *:</td>
						<td><input name='txtfields[semvenue]' type='text' value='". $rs_edit['semvenue']."'  autocomplete='off' class ='txtbox reqfld' /></td>
					</tr>
					<tr>
						<td>Date From *:</td>
						<td><input name='txtfields[strtdate]' placeholder='mm-dd-yyyy' id='strtdate' type='text' value='".display_date($rs_edit['strtdate'])."'  autocomplete='off' class = 'class_date txtbox reqfld'  /></td>
						<td>End From:</td>
						<td><input name='txtfields[enddate]' placeholder='mm-dd-yyyy' id='enddate' type='text' value='".display_date($rs_edit['enddate'])."'  autocomplete='off' class = 'class_date txtbox'  /></td>
					</tr>
					<tr>
						<td>Cost:</td>
						<td><input name='txtfields[semcost]'  id='semcost' type='text' value='".$rs_edit['semcost']."'  autocomplete='off' class = ' txtbox'  /></td>
						<td>Paid By: </td>
						<td><input name='txtfields[sempayby]' id='sempayby' type='text' value='".$rs_edit['sempayby']."'  autocomplete='off' class = 'txtbox'  /></td>
					</tr>
					<tr>
						<td>Internal/External:</td>
						<td><input name='txtfields[semcost]'  id='semcost' type='text' value='".$rs_edit['semcost']."'  autocomplete='off' class = ' txtbox reqfld'  /></td>
						
					</tr>
					<tr>
						<td>&nbsp;</td>
						<td>Note: * Required Fields</td>
						
					</tr>
					";
			
		}
		
		if($xtableid == 'pseback2' || $xtableid =='apppseback2')
		{
			$xform .="<tr>
                    <td>Company * :</td>
                    <td><input name='txtfields[comdsc]' type='text' value='".$rs_edit['comdsc']."'  autocomplete='off' class = 'txtbox reqfld' /></td>
                    <td>Job Title * :</td>
                    <td><input name='txtfields[firstpos]' type='text' value='".$rs_edit['firstpos']."'  autocomplete='off' class = 'txtbox reqfld' /></td>
                </tr>
				<tr>
                    <td>From * :</td>
                    <td><input name='txtfields[datehired]' id='datehired' type='text' value='". display_date($rs_edit['datehired'])."'  autocomplete='off' class= 'class_date txtbox reqfld'/></td>
              
                    <td>To *:</td>
                    <td><input name='txtfields[dateterm]' id='dateterm' placeholder='mm-dd-yyyy' type='text' value='".display_date($rs_edit['dateterm'])."'  autocomplete='off' class= 'class_date txtbox reqfld' /></td>
                </tr>
				<tr>
                    <td>Salary * :</td>
                    <td><input name='txtfields[empsal]' id='salary' type='text' value='". $rs_edit['empsal']."'  autocomplete='off' class= ' txtbox reqfld numeric'/></td>
                </tr>
				<tr height = '10%'>
                    <td>Remarks:</td>
					<td colspan = '3'rowspan = '2' ><textarea name='txtfields[remarks]' style = resize:none id='txtremaks' rows = '5' >". $rs_edit['remarks']."</textarea>
					</td>
                </tr>
                <tr>
                    <td >
                        &nbsp;
                    </td>
                </tr>
				<tr>
                    <td >
                        &nbsp;
                    </td>
					<td >
                        Note: * Required Fields
                    </td>
                </tr>";
		}
		
		if($xtableid =="osback" || $xtableid == 'chback2' || $xtableid =='apposback' || $xtableid == 'appchback2')
		{
			// var_dump("pass");
			$xgender = array("Male", "Female");
			$xform .=" <tr>
                    <td>Children Name * :</td>
                    <td>
                        <input type='text' name='txtfields[cname]' value='". $rs_edit['cname']."'  autocomplete='off' class='style txtbox reqfld' >
	                </td>
					 <td>Employment</td>
                    <td>
                        <input type='text' name='txtfields[cemployement]' value='".$rs_edit['cemployement']."' class='style txtbox' >
                    </td>
                </tr>
				 <tr>
                    <td>Date of Birth * :</td>
                    <td>
                        <input type='text' name='txtfields[cbirthdate]' value='".display_date($rs_edit['cbirthdate'])."'   class='class_date txtbox reqfld'>
                    </td>
            
                    <td>Gender: </td>
                    <td>
                        <select name='txtfields[cgender]' class='style txtbox' style='width:138px;' >";
						for($i = 0; $i <count($xgender); $i++)
						{
							$xstate = $rs_edit['cgender'] == $xgender[$i] ? "selected":"";
							$xform.="<option {$xstate}> {$xgender[$i]}</option>";
						}
						// $sql_skll = "SELECT cvlstatfile FROM cvlstatfile";
						// $stmt_skll = $link_id->prepare($sql_skll);
						// $stmt_skll->execute();
						// while($rs_skll = $stmt_skll->fetch())
						// {
							// $xstate = $rs_edit['ccivilstatus'] == $rs_skll['cvlstatfile'] ? "selected":"";
							// $xform .= "<option {$xstate}>".$rs_skll['cvlstatfile']." </option>";
						// }
						$xform .="
						</select>
                    </td>
                </tr>
				 <tr>
                    <td>Age :</td>
                    <td>
                        <input type='text' name='txtfields[cage]' value='". $rs_edit['cage']."'  autocomplete='off' class='style txtbox' >
	                </td>
					
                </tr>
				<tr>
                    <td>&nbsp; </td>
                   
                    <td>
                        Note: * Required Fields
                    </td>
                </tr>
					";
		}
		
		if($xtableid == "osbackrelation2" || $xtableid =='apposbackrelation2')
		{
			$xform .= " <tr>
                    <td>Relation * </td>
                    <td>
                        <input type='text' name='txtfields[relationship]' value='". $rs_edit['relationship']."'  autocomplete='off' class='style txtbox' >
	                </td>
              
                    <td>Name * </td>
                    <td>
                        <input type='text' name='txtfields[fullname]' value='".$rs_edit['fullname']."' class='style txtbox reqfld' >
                    </td>
                </tr>
                <tr>
                    <td>Address * </td>
                    <td>
                        <input type='text' name='txtfields[address]' value='". $rs_edit['address']."' class='style txtbox reqfld' >
                    </td>
             
                    <td>Contact No. * </td>
                    <td>
                        <input type='text' name='txtfields[contactno]' value='".$rs_edit['contactno']."' class='style txtbox reqfld' >
                    </td>
                
                </tr>
				<tr>
                    <td>&nbsp; </td>
                    <td>
                       Note: * Required Fields
                    </td>
                </tr>";
		}
		
		if($xtableid == "salback")
		{
			$xform .= "<tr>
                    <td>Position Code *: </td>
                    <td>
                        <select name='txtfields[poscode]' class='style txtbox reqfld' style='width:138px;' onchange = 'getdescription(this.value)' id = 'selcode'>";
						$sql_skll = "SELECT poscode FROM positionfile";
						$stmt_skll = $link_id->prepare($sql_skll);
						$stmt_skll->execute();
						$xform .= "<option></option>";
						while($rs_skll = $stmt_skll->fetch())
						{
							$xstate = $rs_edit['poscode'] == $rs_skll['poscode'] ? "selected":"";
							$xform .= "<option {$xstate}>".$rs_skll['poscode']." </option>";
						}
                         $xform .="
                        </select>
                    </td>
              
                    <td>Description:</td>
                    <td><input name='txtfields[posdesc]' type='text' value='".$rs_edit['posdesc']."' readonly  autocomplete='off'  class= 'txtbox' /></td>
                <tr>
                    <td>Date from *:</td>
                    <td><input name='txtfields[posdatefrom]' type='text' value='".display_date($rs_edit['posdatefrom'])."'  placeholder='mm-dd-yyyy' autocomplete='off' class= 'class_date txtbox reqfld' /></td>
                
                    <td>Date to * :</td>
                    <td><input name='txtfields[posdateto]' type='text' value='".display_date($rs_edit['posdateto'])."' class = 'class_date txtbox reqfld'  autocomplete='off' placeholder='mm-dd-yyyy' /></td>
                </tr>
				<tr>
                    <td>Job title :</td>
                    <td><input name='txtfields[jobtitle]' type='text' value='".$rs_edit['jobtitle']."'   autocomplete='off' class= 'txtbox' /></td>
                
                    <td>Salary:</td>
                    <td><input name='txtfields[monthlyrate]' type='text' value='".$rs_edit['monthlyrate']."'  autocomplete='off' class= 'txtbox' /></td>
                </tr>
				<tr height = '10%'>
                    <td>Notes:</td>
                    <td colspan = '4' rowspan ='2'>
						<textarea name = 'txtfields[remarks]' rows = '5' style = 'resize:none' >".$rs_edit['remarks']."</textarea>
						</td>
                </tr>
				<tr>
                    <td>&nbsp;</td>
                    
                </tr>
				<tr>
                    <td>&nbsp;</td>
                    <td>Note: * Required Fields</td>
                    
                </tr>
                <tr>
                    <td><input name='txtfields[encodedate]' type='hidden' value='".display_date(date('Y-m-d'))."' placeholder='mm-dd-yyyy' /></td>
                </tr>";
		}
		
		if($xtableid == 'vioback')
		{
			$xform .="
                <tr>
                    <td>Violation Code * :</td>
                    <td>
                        <select name='txtfields[viocode]' class='style txtbox reqfld' style='width:138px;' onchange = 'get_description(\"violation\", this.value,  \"viodesc\",\"viodesc\" , \"viocode\")'>";
						$sql_skll = "SELECT viocode FROM violationfile";
						$stmt_skll = $link_id->prepare($sql_skll);
						$stmt_skll->execute();
						$xform .= "<option></option>";
						while($rs_skll = $stmt_skll->fetch())
						{
							$xstate = $rs_edit['viocode'] == $rs_skll['viocode'] ? "selected":"";
							$xform .= "<option {$xstate}>".$rs_skll['viocode']." </option>";
						}
                        $xform.="
                        </select> 
                    </td>
                
                    <td>Description:</td>
                    <td>
						<input name='txtfields[viodesc]' type='text' value='".$rs_edit['viodesc']."'  autocomplete='off' id = 'viodesc' readonly  class = 'txtbox' />
                    </td>
                </tr>
				<tr>
                    <td>Date * :</td>
                    <td><input name='txtfields[viodate]' id='viodate' placeholder='mm-dd-yyyy' type='text' value='".display_date($rs_edit['viodate'])."'  autocomplete='off' class = 'class_date txtbox reqfld' /></td>
					 <td>Action Taken:</td>
                    <td><input name='txtfields[vioaction]' type='text' value='".$rs_edit['vioaction']."'  autocomplete='off' class = 'txtbox' /></td>
                </tr>
                <tr height = '10%'>
                    <td>Remarks:</td>
                    <td colspan = '3' rowspan ='2'>
						<textarea name='txtfields[remarks]' rows = '5' style = 'resize:none' >".$rs_edit['remarks']."</textarea>
					</td>
                </tr>
				<tr>
					<td>
					</td>
				</tr>
				<tr>
					<td>
					</td>
					<td>
						Note: * Required Fields
					</td>
				</tr>
               ";
		}
		
		if($xtableid =='nonpayback')
		{
			$xform.=" <tr>
                    <td>Code *:</td>
                    <td>
                        <select name='txtfields[bencode]' class='style txtbox reqfld' style='width:138px;' onchange = 'get_description(\"npbenefits\", this.value,  \"bendesc\",\"bendesc\" , \"poscode\")' >";
						$sql_skll = "SELECT bencode FROM benefitsfile2";
						$stmt_skll = $link_id->prepare($sql_skll);
						$stmt_skll->execute();
						$xform .= "<option></option>";
						while($rs_skll = $stmt_skll->fetch())
						{
							$xstate = $rs_edit['bencode'] == $rs_skll['bencode'] ? "selected":"";
							$xform .= "<option {$xstate}>".$rs_skll['bencode']." </option>";
						}
						$xform.="	
                        </select> 
                    </td>
					<td>
						Description: 
					</td>
					<td>
						<input name='txtfields[bendesc]' type='text' value='".$rs_edit['bendesc']."'  autocomplete='off' id = 'bendesc' readonly  class = 'txtbox' />
					</td>
                </tr>
					<tr>
						<td>Note: * Required Fields
						</td>
					</tr>
				";
               
		}
		
		if($xtableid == 'oeback')
		{
			$xform .=" <tr>
                    <td>Code * :</td>
                    <td>
                        <select name='txtfields[earningscode]' class='style txtbox reqfld'  onchange = 'get_description(\"earnings\", this.value,  \"earningsdesc\",\"earningsdesc\" , \"earningscode\")' >";
						$sql_skll = "SELECT earningscode FROM otherearnings";
						$stmt_skll = $link_id->prepare($sql_skll);
						$stmt_skll->execute();
						$xform .= "<option></option>";
						while($rs_skll = $stmt_skll->fetch())
						{
							$xstate = $rs_edit['earningscode'] == $rs_skll['earningscode'] ? "selected":"";
							$xform .= "<option {$xstate}>".$rs_skll['earningscode']." </option>";
						}
						$xform .="
                        </select> 
                    </td>
					<td>
						Description: 
					</td>
					<td>
						<input name='txtfields[earningsdesc]' type='text' value='".$rs_edit['earningsdesc']."'  autocomplete='off' id = 'earningsdesc' readonly  class = 'txtbox' />
					</td>
                </tr>
                <tr>
                    <td>Amount * :</td>
                    <td><input name='txtfields[earningsamount]' type='text' value='".$record['earningsamount']."'  autocomplete='off' class = 'txtbox reqfld' /></td>
                </tr>
				<tr>
                    <td>Note:  * Required Fields </td>
                    
                </tr>";
		}
		
		if($xtableid =='awback')
		{
			$xform.= "<tr>
                    <td>Code * :</td>
                    <td>
                        <select name='txtfields[allowcode]' class='style txtbox reqfld' style='width:138px;'  onchange = 'get_description(\"allowance\", this.value,  \"allowdesc\",\"allowdesc\" , \"allowcode\")'>";
						$sql_skll = "SELECT allowcode FROM allowancefile";
						$stmt_skll = $link_id->prepare($sql_skll);
						$stmt_skll->execute();
						$xform .= "<option></option>";
						while($rs_skll = $stmt_skll->fetch())
						{
							$xstate = $rs_edit['allowcode'] == $rs_skll['allowcode'] ? "selected":"";
							$xform .= "<option {$xstate}>".$rs_skll['allowcode']." </option>";
						}
                        $xform .="
                        </select> 
                    </td>
					<td>
						Description: 
					</td>
					<td>
						<input name='txtfields[allowdesc]' type='text' value='".$rs_edit['allowdesc']."'  autocomplete='off' id = 'allowdesc' readonly  class = 'txtbox' />
					</td>
                </tr>
                <tr>
                    <td>Rate * :</td>
                    <td><input name='txtfields[allowrate]' type='text' value='".$record['allowrate']."'  autocomplete='off' class = 'txtbox reqfld' /></td>
                    <td>Factor:</td>
                    <td><input name='txtfields[allowqty]' type='text' value='".$record['allowqty']."'  autocomplete='off' class = 'txtbox' /></td>
                </tr>
				<tr>
                    <td>&nbsp;</td>
                   
                    <td>Note: * Required Field</td>
                </tr>";
		}
		
		
		if($xtableid =='leback')
		{
			$xform.=" <tr>
				
            <td>Code *: <b style='font-family:Courrier;font-size:20;'>*</b></td>
            <td>
                <select name='txtfields[loanscode]' id='txt_loanscode' class='validate[required] reqfld txtbox' class='style' style='width:138px;'>";
				$sql_skll = "SELECT loanscode FROM loansfile";
				$stmt_skll = $link_id->prepare($sql_skll);
				$stmt_skll->execute();
				$xform .= "<option></option>";
				while($rs_skll = $stmt_skll->fetch())
				{
					$xstate = $rs_edit['loanscode'] == $rs_skll['loanscode'] ? "selected":"";
					$xform .= "<option {$xstate}>".$rs_skll['loanscode']." </option>";
				}
				$xform .="
                </select>
            </td>
        </tr>
        <tr>
            <td>Loan Date : <b style='font-family:Courrier;font-size:20;'>*</b></td>
            <td><input name='txtfields[loandate]' id='txt_loandate' class='validate[required] {$dateclass} reqfld txtbox' placeholder='mm-dd-yyyy' ".$xreadonly." type='text' value='".display_date($rs_edit['loandate'])."'  autocomplete='off' /></td>
      
            <td>Original Amt. : <b style='font-family:Courrier;font-size:20;'>*</b></td>
            <td>
                <input name='txtfields[orgamt]' id='txt_orgamt' class='validate[required] reqfld txtbox' type='text' value='".$rs_edit['orgamt']."'  autocomplete='off' />
            </td>
        </tr>
        <tr>
            <td>Beg. Balance: <b style='font-family:Courrier;font-size:20;'>*</b></td>
            <td>
                <input name='txtfields[loanamount]' id='txt_loanamount' class='validate[required] reqfld txtbox' type='text' value='". $rs_edit['loanamount']."'  autocomplete='off' />
                <input name='txtfields[loanamount1]' id='txt_loanamount1' class='validate[required] txtbox' type='hidden' value='".$rs_edit['loanamount']."' />
            </td>
      
            <td>Amortization: <b style='font-family:Courrier;font-size:20;'>*</b></td>
            <td><input name='txtfields[amortization]' id='txt_amortization' class='validate[required] reqfld txtbox' type='text' value='".$rs_edit['amortization']."'  autocomplete='off' /></td>
        </tr>
        <tr>
            <td>Eff. Month: <b style='font-family:Courrier;font-size:20;'>*</b></td>
            <td><input name='txtfields[effcremon]' id='txt_effcremon' class='validate[required] reqfld txtbox' type='text' value='". $rs_edit['effcremon']."'  autocomplete='off' /></td>

            <td>Eff. Year: <b style='font-family:Courrier;font-size:20;'>*</b></td>
            <td><input name='txtfields[effcreyer]' id='txt_effcreyear' class='validate[required] reqfld txtbox'  type='text' value='". $rs_edit['effcreyer']."'  autocomplete='off' /></td>
        </tr>
		<tr>
			<td>
				&nbsp;
			</td>
			<td>
				Note: * Required Fields
			</td>
		</tr>
		";
		}
		
		if($xtableid =='loback')
		{
			$xform .=" <tr>
                    <td>Code *:</td>
                    <td>
                        <select name='txtfields[leavescode]' class='style txtbox' style='width:138px;' onchange = 'get_description(\"leaves\", this.value,  \"leavesdesc\",\"leavesdesc\" , \"leavescode\")' >";
						$sql_skll = "SELECT leavescode FROM leavesfile";
						$stmt_skll = $link_id->prepare($sql_skll);
						$stmt_skll->execute();
						$xform .= "<option></option>";
						while($rs_skll = $stmt_skll->fetch())
						{
							$xstate = $rs_edit['leavescode'] == $rs_skll['leavescode'] ? "selected":"";
							$xform .= "<option {$xstate}>".$rs_skll['leavescode']." </option>";
						}
						$xform .="
                        </select> 
                    </td>
					<td>
						Description: 
					</td>
					<td>
						<input name='txtfields[leavesdesc]' type='text' value='".$rs_edit['leavesdesc']."'  autocomplete='off' id = 'leavesdesc' readonly  class = 'txtbox' />
					</td></tr>
					<tr>
						<td>
							Note: * Required Fields
						</td>
					</tr>
					"
					;
                // var_dump($rs_edit);
				$xqry = "SELECT * FROM payrollparameters";
				$xstmt_params	= $link_id->prepare($xqry);
				$xstmt_params->execute();
				$rs_params	= $xstmt_params->fetch();
				if(htmlentities($rs_params['leavemode'])=='DAYS')
				{
					$xmode	= 'DAYS';
				}
				elseif(htmlentities($rs_params['leavemode'])=='HHHH')
				{
					$xmode	= 'HRS';
				}
				else
				{
					$xmode	= 'HRS-MINS';
				}
				$xform.="<tr><td>Available [ {$xmode}]:</td>
                    <td><input name='txtfields[leavesearned]' type='text' value='".$rs_edit['leavesearned']."'  autocomplete='off' class = 'txtbox' /></td>
                </tr>";
				$xform .="<tr>
						<td>Used:</td>
						<td><input name='txtfields[leavesused]' id='viodate'  type='text' value='".$rs_edit['leavesused']."'  autocomplete='off' class = ' txtbox' /></td>
						 <td>Balance:</td>
						<td><input name='txtfields[leavesleft]' type='text' value='".$rs_edit['leavesleft']."'  autocomplete='off' class = 'txtbox' /></td>
					</tr>";
		}
		
		if($xtableid =='membback')
		{
			$xform .="<tr>
                    <td>Type *:</td>
                    <td>
						<select name = 'txtfields[memdesc]' class = 'txtbox reqfld'  >";
						$sql_skll = "SELECT memdesc FROM membershipfile";
						$stmt_skll = $link_id->prepare($sql_skll);
						$stmt_skll->execute();
						$xform .= "<option></option>";
						while($rs_skll = $stmt_skll->fetch())
						{
							$xstate = $rs_edit['memdesc'] == $rs_skll['memdesc'] ? "selected":"";
							$xform .= "<option {$xstate}>".$rs_skll['memdesc']." </option>";
						}
						$xform .="
						</select>
					</td>
					 <td>No. * :</td>
					<td>
						<input type = 'text' name = 'txtfields[memno]'  value = '".$rs_edit['memno']."'autocomplete='off' id = 'txtsubamt'  class = 'txtbox reqfld' />
					</td>
					<tr>
						<td> Date Start * :</td>
						<td>
							<input name='txtfields[subcomsdte]' class = 'class_date txtbox reqfld'  id='txtsubcomsdte' type='text' value='". display_date($rs_edit['subcomsdte'])."'   autocomplete='off' />
						</td>
				   
						<td>Expiration Date * :</td>
						<td>
							<input name='txtfields[subrenewdte]' class = 'class_date txtbox reqfld'  id='txtsubrenewdte' type='text' value='".display_date($rs_edit['subrenewdte'])."'  autocomplete='off'  />
						</td>
					</tr>
                    <td> Paid By:</td>
                    <td>
						<select style = 'width:140px' name = 'txtfields[subpaidby]' id = 'txtsubpaidby' class = 'txtbox' >";
								$xstate = ($rs_edit['subpaidby'] == 'Company'?'selected':'');
								$xstate2 = ($rs_edit['subpaidby'] == 'Employee'?'selected':'');
							$xform .="
							<option value = 'Company'{$xstate} >Company</option>
							<option value = 'Employee'{$xstate} >Employee</option>
							
						</select>
					</td>
					<td>Amount:</td>
                    <td>
						
						<input type = 'text' name = 'txtfields[subamt]'  value = '".$rs_edit['subamt']."'autocomplete='off' id = 'txtsubamt'  class = 'txtbox' />
					</td>
                </tr>
				<tr>
                    
                
                    <td>Currency:</td>
                    <td>
						<select name='txtfields[currency]' id = 'selcurrency'  class = 'txtbox' >";
						$sql_skll = "SELECT curdsc FROM currencyfile";
						$stmt_skll = $link_id->prepare($sql_skll);
						$stmt_skll->execute();
						while($rs_skll = $stmt_skll->fetch())
						{
							$xstate = $rs_edit['curdsc'] == $rs_skll['curdsc'] ? "selected":"";
							$xform .= "<option {$xstate}>".$rs_skll['curdsc']." </option>";
						}
						$xform .="
						</select>
					</td>
                </tr>
				<tr>
					<td>
						&nbsp;
					</td>
					<td>
						Note: * Required Fields
					<t/d>
				</tr>
				";
		}
		
		if($xtableid == 'immigback')
		{
			$xform .= "<tr>
                    <td>Document * :</td>
                    <td>";
					
						$xcheck = ($rs_edit['doctype'] =='Passport' ? 'checked':'');
						$xcheck2 = ($rs_edit['doctype'] =='Visa' ? 'checked':'');
					$xform .="
						<input checked name='txtfields[doctype]'  id='txtdoctype' type='radio' value='Passport'  autocomplete='off' {$xcheck} />Passport
						<input name='txtfields[doctype]'  id='txtdoctype' type='radio' value='Visa'  autocomplete='off' {$xcheck2} />Visa
					</td>
                
                    <td>Number * :</td>
                    <td>
						<input name='txtfields[docnum]'  id='txtdocnum' type='text'  autocomplete='off' value = '".$rs_edit['docnum'] ."' class = 'txtbox reqfld' />
					</td>
                </tr>
				<tr>
                    <td>Issued Date *:</td>
                    <td>
						<input name='txtfields[isdte]' class= 'class_date txtbox reqfld'  id='txtisdte' type='text'  autocomplete='off' value = '".display_date($rs_edit['isdte'])."'  />
					</td>
              
                    <td>Expiry Date *:</td>
                    <td>
						<input name='txtfields[expdte]' class= 'class_date txtbox reqfld'  id='txtexpdte' type='text'  autocomplete='off' value = '".display_date($rs_edit['expdte'])."'  />
					
					</td>
                </tr>
				<tr>
                    <td>Eligible Status:</td>
                    <td>
						<input name='txtfields[elgstat]'  id='txtelgstat' type='text'  autocomplete='off' value = '".$rs_edit['elgstat']."'  class ='txtbox'  />
					</td>
             
                    <td>Issued By:</td>
                    <td>
						<select name='txtfields[issby]' id='txtissby'  class ='txtbox'> ";
						$sql_skll = "SELECT cntrycde FROM countryfile";
						$stmt_skll = $link_id->prepare($sql_skll);
						$stmt_skll->execute();
						$xform .= "<option></option>";
						while($rs_skll = $stmt_skll->fetch())
						{
							$xstate = $rs_edit['cntrycde'] == $rs_skll['cntrycde'] ? "selected":"";
							$xform .= "<option {$xstate}>".$rs_skll['cntrycde']." </option>";
						}
						$xform.="
						</select>
					</td>
                </tr>
				<tr>
                    <td>Eligible Review Date:</td>
                    <td>
						<input name='txtfields[elgrevdte]' class= 'class_date txtbox'  id='txtelgrevdte' type='text'  autocomplete='off' value = '".display_date($rs_edit['elgrevdte'])."'  />
					
					</td>
                </tr>
				<tr height = '10%'>
                    <td >Remarks:</td>
                    <td colspan = '3' rowspan = '2'>
						
						<textarea name='txtfields[remarks]'  id='txtremarks' rows = '5' style = 'resize:none' >".$rs_edit['remarks']."</textarea>
					</td>
                </tr>
				
				<tr>
                    <td >&nbsp;</td>
                    
                </tr><tr>
					  <td >&nbsp;</td>
                    <td >Note : * Required Field</td>
                    
                </tr>
				";
			
		}
		
		if($xtableid =='reqback' || $xtableid =='appreqback')
		{
			$xform.=" <tr>
                    <td>Requirement * :</td>
                    <td>
                        <select name='txtfields[requirement]' class='style txtbox reqfld' style='width:138px;'>";
						$sql_skll = "SELECT requirementname FROM requirementsnamefile";
						$stmt_skll = $link_id->prepare($sql_skll);
						$stmt_skll->execute();
						$xform .= "<option></option>";
						while($rs_skll = $stmt_skll->fetch())
						{
							$xstate = $rs_edit['requirement'] == $rs_skll['requirementname'] ? "selected":"";
							$xform .= "<option {$xstate}>".$rs_skll['requirementname']." </option>";
						}
                          $xform .="
                        </select>
                    </td>
                </tr>
                <tr>
                    <td>Date Issued * :</td>
                    <td><input name='txtfields[dateissue]' placeholder='mm-dd-yyyy' id='dateissue' type='text' value='".display_date($rs_edit['dateissue'])."'  autocomplete='off' class = 'class_date txtbox' /></td>
             
                    <td>Date Expiration * :</td>
                    <td><input name='txtfields[dateexpire]' placeholder='mm-dd-yyyy' type='text' value='".display_date($rs_edit['dateexpire'])."'  autocomplete='off' class = 'class_date txtbox'  /></td>
                </tr>
                <tr height = '10%'>
                    <td>Remark:</td>
                    <td colspan = '3' rowspan = '2'>
						<textarea name='txtfields[remark]' rows = '5' style = 'resize:none;'>". $rs_edit['remark']."</textarea>
					</td>
                </tr>
				
                <tr>
                    <td>&nbsp;</td>
                   
                </tr>
				<tr>
                    <td>&nbsp;</td>
                    <td>Note: * Requires Fields</td>
                   
                </tr>
				";
		}
		
		if($xtableid == 'licback' || $xtableid =='applicback')
		{
			$xform .="  <tr>
                    <td>License Type *:</td>
                    <td>
						<select name='txtfields[licname]' class='style txtbox reqlfld' style='width:138px;' >";
						$sql_skll = "SELECT lidesc FROM licensefile";
						$stmt_skll = $link_id->prepare($sql_skll);
						$stmt_skll->execute();
						while($rs_skll = $stmt_skll->fetch())
						{
							$xstate = $rs_edit['licname'] == $rs_skll['lidesc'] ? "selected":"";
							$xform .= "<option {$xstate}>".$rs_skll['lidesc']." </option>";
						}
						$xform .="
						</select>
					</td>
              
                    <td>License No. *:</td>
                    <td><input name='txtfields[licno]' type='text' value='".$rs_edit['licno']."'  autocomplete='off' class = 'txtbox reqfld' /></td>
                </tr>
                
                <tr>
                    <td>Date issued:</td>
                    <td>
						<input name='txtfields[issdte]' id = 'txtissdte' class='class_date txtbox' type='text' placeholder='mm-dd-yyyy' value='".display_date($rs_edit['issdte'])."'  autocomplete='off' />
					</td>
               
                    <td>Expiration Date:</td>
                    <td><input name='txtfields[expdte]' class='class_date txtbox' id='expdtestr' placeholder='mm-dd-yyyy' type='text' value='".display_date($rs_edit['expdte'])."'  autocomplete='off' /></td>
                </tr>
				<tr>
                    <td>Place issued:</td>
                    <td><input name='txtfields[licplace]' type='text'  value='". $rs_edit['licplace']."'  autocomplete='off' class = 'txtbox' /></td>
                </tr>
				<tr height = '10%'>
                    <td>Remarks:</td>
                    <td colspan = '3' rowspan = '2'>
						<textarea name='txtfields[remarks]' rows ='5' style = 'resize:none'>". $rs_edit['remarks']."</textarea>
					
					</td>
                </tr>
				<tr >
					<td>
					</td>
				</tr>
				<tr>
					<td>
					</td>
					<td>
						Note: * Required Field
					</td>
				</tr>
				";
		}
		
	
		
		$xform .= "</table >";
		$xretobj = $xform;
		
	}
	
	if(isset($_POST['event_action']) && trim($_POST['event_action']) == 'save_item')
	{
		$xpar = trim($_POST['xpar']);
		$xrecid = trim($_POST['itemid']);
		$xfld = trim($_POST['xfld']);
		$xarr_record = array();
		$xid = trim($_POST['tableid']);
		$xtable = get_table($xid);
		
		foreach ($_POST['txtfields'] as $key =>$val)
		{
			if(strpos($key, "date") !=false || strpos($key, "dte") !=false || substr($key,0,4) == "date" ||substr($key,0,3) == "dte")
			{
				$val = format_date($val);
			}
			$xarr_record[$key] = $val;
		}
		$xarr_record[$xfld] = trim($_POST['apempcode']);
		$xbool = true;
		
		if($xtable == "empdefloan")
		{
			$xbalance   = $xarr_record['loanamount1']+($xarr_record['loanamount']-$xarr_record['balance']);
			unset($xarr_record['loanamount1']);
			if($xarr_record['loanamount']< $xarr_record['amortization'])
			{
				$xretobj = 'Amortization Cannot exceed Beginning balance!';
				$xbool = false;
			}
			elseif($xarr_record['orgamt']<$xarr_record['loanamount'])
			{
				$xretobj = 'Beginning Balance Cannot exceed Original Amount!';
				$xbool = false;
			}
			elseif($xbalance<$txtfields['amortization'])
			{
				$xretobj = 'Amorization Cannot exceed Balance!';
				$xbool = false;
				
			}
			else{
				if($xpar  != 'edit')
				{
					$xquery_val = "SELECT * FROM empdefloan WHERE empcode=? AND loanscode =?";
					$stmt_val = $link_id->prepare($xquery_val);
					$stmt_val->execute(array($refcde,$txtfields['loanscode']));
					if ( $rs_val = $stmt_val->fetch() )
					{
						$xretobj = 'Loans code is already exist.';
						$xbool = false;
					}
					else{
						$xbool = true;
					}
				}
			}
			
		
		}
		if($xbool)
		{
			if($xpar  == 'edit')
			{
				PDO_UpdateRecord($link_id, $xtable, $xarr_record, "recid = ?", array($xrecid), false);
			}
			else
			{
				PDO_InsertRecord($link_id, $xtable, $xarr_record, false);
			}
			$xretobj = "SUCCESS!";
		}
		
	}
	if(isset($_POST['event_action']) && trim($_POST['event_action']) == "delete_item")
	{ 
		$xrecid = trim($_POST['itemid']);
		$xtbid = trim($_POST['tableid']);
		$xtable = get_table($xtbid);
		if($xrecid !="")
		{
			$sql_del = "DELETE FROM $xtable WHERE recid = ?";
			$stmt_del = $link_id->prepare($sql_del);
			$stmt_del->execute(array($xrecid));
			$xretobj = "Record Deleted!";
		}
	}

	if(isset($_POST['event_action']) && trim($_POST['event_action']) == 'getdesc')
	{
		$xcodeid = trim($_POST['codeid']);
		$xtable = get_table($xcodeid);
		$xdescfld = trim($_POST['descriptionfld']);
		$xcodefld = trim($_POST['codefld']);
		$xcodeval = trim($_POST['code']);
		$sql = "SELECT $xdescfld FROM $xtable WHERE $xcodefld = ?";
		$stmt = $link_id->prepare($sql);
		$stmt->execute(array($xcodeval));
		$xretobj = $xcodeval;
		if($rs = $stmt->fetch())
		{
			$xretobj = $rs[$xdescfld];
		}
	
	}
	
	
	
	$json = new Services_JSON();
    echo $json->encode($xretobj);
	
	
	function get_table ($tableid)
	{
		switch($tableid)
		{
			//according to code id
			case "violation":
				$xtable = "violationfile";
				break;
			case "npbenefits":
				$xtable = "benefitsfile2";
				break;
			case "earnings":
				$xtable = "otherearnings";
				break;
			case "allowance":
				$xtable = "allowancefile";
				break;
			case "loans":
				$xtable = "loansfile";
				break;
			case "leaves":
				$xtable = "leavesfile";
				break;
		 
		 
			//according to table id
			case "edubackeduback2":			
				$xtable = "employeeschool";
				break;
			case "skiback2":			
				$xtable = "employeeskills";
				break;
			case "langback2":			
				$xtable = "emplangfile";
				break;
			case "extback2":			
				$xtable = "employeecertificate";
				break;
			case "appextback2":			
				$xtable = "applicantcertificate";
				break;
			case "awdback2":			
				$xtable = "employeeaward";
				break;
			case "semback2":			
				$xtable = "employeeseminar";
				break;
			case "apppseback2":			
				$xtable = "applicantrecord";
				break;
			case "pseback2":			
				$xtable = "employeerecord";
				break;
			case "osback":			
				$xtable = "employeesiblings";
				break;
			case "osbackrelation2":			
				$xtable = "employeeotherrelations";
				break;
			case "salback":			
				$xtable = "employeepositionsalaryhistory";
				break;
			case "vioback":			
				$xtable = "employeeviolation";
				break;
			case "nonpayback":			
				$xtable = "empdefnonbenefits";
				break;
			case "oeback":			
				$xtable = "empdefear";
				break;
			case "awback":			
				$xtable = "empdefallow";
				break;
			case "leback":			
				$xtable = "empdefloan";
				break;
			case "loback":			
				$xtable = "empdefleave";
				break;
			case "membback":			
				$xtable = "employeemembership";
				break;
			case "immigback":			
				$xtable = "employeeimmigrationfile";
				break;
			case "reqback":			
				$xtable = "employeerequirementsfile";
				break;
			case "appreqback":			
				$xtable = "applicantrequirementsfile";
				break;
			case "licback":			
				$xtable = "employeelicenses";
				break;
			case "applicback":			
				$xtable = "applicantlicenses";
				break;
			case "chback2":			
				$xtable = "employeechildren";
				break;
			case "apposback":			
				$xtable = "applicantsiblings";
				break;
			case "appchback2":			
				$xtable = "applicantchildren";
				break;
			case "apposbackrelation2":			
				$xtable = "applicantotherrelations";
				break;
			case "appeduback2":			
				$xtable = "applicantschool";
				break;
			case "appsemback2":			
				$xtable = "applicantseminar";
				break;
			case "appskiback2":			
				$xtable = "applicantskills";
				break;
			default:
				$xtable = "employeeschool";
		}
		return $xtable;
	}
?>
