芝麻web文件管理V1.00

编辑当前文件:/home/jambtst2015/public_html/giraffeng.com/admin/new_LCA.php

<?php include("includes/head.php"); ?>

<?php include("includes/header.php"); ?>
<?php

/*---For Add---*/

if($_SERVER["REQUEST_METHOD"]=="POST"){
	//echo "sdss";	
//exit;
//if(isset($_POST)){					
				//insert//
				$time = date("Y-m-d");

$insSql = "INSERT INTO `lca_details` set ";

$insSql .= "candidate_name='".$_REQUEST['userid']."', ";
				
				$insSql .= "lca_count='".mysql_real_escape_string(trim($_POST['lca_count']))."', ";
				
				$insSql .= "lca_number='".mysql_real_escape_string(trim($_POST['lca_number']))."', ";
				
				$insSql .= "work_location1='".mysql_real_escape_string(trim($_POST['work_location1']))."', ";
				
				$insSql .= "prevl_wages1='".mysql_real_escape_string(trim($_POST['prevl_wages1']))."', ";
				
				$insSql .= "work_location2='".mysql_real_escape_string(trim($_POST['work_location2']))."', ";
				
				$insSql .= "prevl_wages2='".mysql_real_escape_string(trim($_POST['prevl_wages2']))."', ";
				
				$insSql .= "wage_rate='".mysql_real_escape_string(trim($_POST['wage_rate']))."', ";
				
				$insSql .= "lca_position_rate='".mysql_real_escape_string(trim($_POST['lca_position_rate']))."', ";
				
				$insSql .= "start_date='".change_dateformat(trim($_POST['start_date']))."', ";
				
				
				$insSql .= "end_date='".change_dateformat(trim($_POST['end_date']))."', ";
				
				$insSql .= "lca_activity_status='".mysql_real_escape_string(trim($_POST['lca_activity_status']))."', ";
				
				$insSql .= "exmpt='".mysql_real_escape_string(trim($_POST['exmpt']))."', ";
				
				$insSql .= "lca_staus='".mysql_real_escape_string(trim($_POST['lca_staus']))."', ";
				
				$insSql .= "associates_qualification='".$_POST['associates_qualification']."', ";

$insSql .= "graduation_year='".change_dateformat(trim($_POST['graduation_year']))."', ";
				
				$insSql .= "experience_years='".mysql_real_escape_string(trim($_POST['experience_years']))."', ";

$insSql .= "current_salary='".trim($_POST['current_salary'])."', ";
				
				$insSql .= "lca_level='".mysql_real_escape_string(trim($_POST['lca_level']))."', ";
				
				$insSql .= "lca_given_rcpt='".mysql_real_escape_string(trim($_POST['lca_given_rcpt']))."', ";
				
				$insSql .= "10days_posting_notice='".mysql_real_escape_string(trim($_POST['10days_posting_notice']))."', ";
				
				
				$insSql .= "current_employment_status='".mysql_real_escape_string(trim($_POST['current_employment_status']))."', ";
				
				
				$insSql .= "public_inspection_file='".mysql_real_escape_string(trim($_POST['public_inspection_file']))."', ";
				
				$insSql .= "notes='".mysql_real_escape_string(trim($_POST['notes']))."', ";
				
				$insSql .= "filed_by='".mysql_real_escape_string(trim($_POST['filed_by']))."', ";
				
				
				
				$insSql .= "created_by='".$_SESSION['sat_login_id']."', ";
				
				$insSql .= "created_date='".$time."', ";
				
				$insSql .= "last_update_by='".$_SESSION['sat_login_id']."', ";
				
				$insSql .= "last_update_date='".$time."'";

//$insSql ;

mysql_query($insSql);
				//header("location:view_LCA.php?userid=$_REQUEST[employee_id]&success=1");
				?>
                <script>
				window.location = "view_LCA.php?userid=<?=$_REQUEST['userid'];?>&success=1&page=<?php echo $_REQUEST['page']; ?>&name=<?=$_REQUEST['name']?>&email=<?=$_REQUEST['email']?>&associate_type=<?=$_REQUEST['associate_type']?>&visa_status=<?=$_REQUEST['visa_status']?>&account_manager=<?=$_REQUEST['account_manager']?>&hr_manager=<?=$_REQUEST['hr_manager']?>&sales_manager=<?=$_REQUEST['sales_manager']?>&hotlist=<?=$_REQUEST['hotlist']?>&blacklisted=<?=$_REQUEST['blacklisted']?>&send_emails=<?=$_REQUEST['send_emails']?>&relocation=<?=$_REQUEST['relocation']?>&record_status=<?=$_REQUEST['record_status']?>&submit2=<?=$_REQUEST['submit2']?>&state=<?=$_REQUEST['state']?>&city=<?=$_REQUEST['city']?>&primary_skills_src=<?=$primary_skills?>&secondary_skills_src=<?=$secondary_skills?>&first=<?=$_REQUEST['first']?>&last=<?=$_REQUEST['last']?>";
				</script>
                <?php

}

else{

$_POST['name']='';

$_POST['street']='';

$_POST['city']='';

$_POST['state']='';

$_POST['zip']='';

$_POST['industry']='';

$_POST['phone']='';

$_POST['contact_name']='';

$_POST['contact_phone']='';

$_POST['client_type']='';

$_POST['add_date']='';

$_POST['email']='';

$_POST['web_address']='';

$_POST['ac_mgr']='';

$_POST['open_reqs']='';

$_POST['close_reqs']='';

$_POST['send_emails']='';

$_POST['added_user']='';

$_POST['notes']='';

$_POST['change_authority']='';

$_POST['blacklisted']='';

$_POST['record_status']='';

}

/*---End Add---*/

?>
<script>
function formSub(){
	//alert(111111111);
	//document.myfrm.submit();
	document.getElementById("formID").submit();
	return true;
}
jQuery.noConflict();
(function($) {jQuery(document).ready(function(){
 // binds form submission and fields to the validation engine
 jQuery("#formID").validationEngine('attach', {
   onValidationComplete: function(form, status){
   //alert("The form status is: " +status+", it will never submit");
   if(status == true){
	   var id = $("#h_id").val();
	   //alert(id);
	    var status = $("#lca_staus").val();
		$.ajax({
		url : 'same_lca.php',
		type : 'POST',
		data : 'id='+id+'&status='+status,
		//dataType : 'json',
		beforeSend : function(jqXHR, settings ){
			//alert(1);
		},
		success : function( data, textStatus, jqXHR){
			//alert(data);
			if(data==0){
				//$('input[type="submit"]').attr('disabled','disabled');
				return formSub();
			}else{
				$("#errorMsg").show("slow");
				//$('input[type="submit"]').attr('disabled','disabled');
				//return false;
			}
			//window.open('same_candidate.php?name='+name,'news view','height=600, width=1000, resizable=yes, scrollbars=yes');
		},
		error : function( jqXHR, textStatus, errorThrown){
		}
		});
   }
  }  
 });
});})(jQuery);

function addSkills(catid)

{

window.open('addSkill.php?catid='+catid,'Add Skill','height=250, width=600, resizable=yes, scrollbars=yes');

}

function addSkillsse(catid)

{

window.open('addSkillsecond.php?catid='+catid,'Add Skill','height=250, width=600, resizable=yes, scrollbars=yes');

}

function addVendors()

{

window.open('addVendor.php','Add Skill','height=250, width=600, resizable=yes, scrollbars=yes');

}

</script>

function getkey(e)

{

if (window.event)

return window.event.keyCode;

else if (e)

return e.which;

else

return null;

}

function goodchars(e, goods)

{

var key, keychar;

key = getkey(e);

if (key == null) return true;

keychar = String.fromCharCode(key);

keychar = keychar.toLowerCase();

goods = goods.toLowerCase();

if (goods.indexOf(keychar) != -1)

return true;

if ( key==null || key==0 || key==8 || key==9 || key==13 || key==27 )

return true;

return false;

}

function open_notes()

{

if(document.getElementById('notes').checked==true)

{

document.getElementById('notes_div').style.display='block';

}

if(document.getElementById('notes1').checked==true)

{

document.getElementById('notes_desc').value='';

document.getElementById('notes_div').style.display='none';

}

function open_blacklisted()

{

if(document.getElementById('blacklisted1').checked==true)

{

document.getElementById('blacklisted_div').style.display='block';

}

if(document.getElementById('blacklisted2').checked==true)

{

document.getElementById('blacklisted_desc').value='';

document.getElementById('blacklisted_div').style.display='none';

}

function candidatetypeother(val){

if(val == 'other'){

document.getElementById('candidatetype_other').style.display='block';

}

else{

document.getElementById('candidate_type_other').value='';

document.getElementById('candidatetype_other').style.display='none';

}

</script>

function ChangeFocuszip(cur,nex)

{

var value=document.getElementById(cur).value;

if(value.length==5)

{

document.getElementById(nex).focus();

}

function ChangeFocus1(cur,nex)

{

var value=document.getElementById(cur).value;

if(value.length==3)

{

document.getElementById(nex).focus();

}

function ChangeFocus(cur,nex)

{

var value=document.getElementById(cur).value;

if(value.length==3)

{

document.getElementById(nex).focus();

}

function ChangeFocus1(cur,nex)

{

var value=document.getElementById(cur).value;

if(value.length==2)

{

document.getElementById(nex).focus();

}

</script>

<form name="myfrm" action="" method="post" id="formID" enctype="multipart/form-data" <?php /*?>onsubmit="return validecan();"<?php */?>>

<?php if(empty($error)){$error='';}

if($error!=''){

<tr>

</td>

</tr>

<?php } ?>

<tr>

<tr>

</tr>
	  <script>
	  $(document).ready(function(){
  		$("#name").change(function(){
    		if( $(this).val() == ''){
      			//alert(000);
			}else{
				//window.open('view_candidate.php?userid='+userid,'news view','height=600, width=1000, resizable=yes, scrollbars=yes');
				var name = $(this).val();
				$.ajax({
					url : 'same_candidate.php',
					type : 'POST',
					data : 'name=' + name,
					//dataType : 'json',
					beforeSend : function(jqXHR, settings ){
						//alert(1);
					},
					success : function( data, textStatus, jqXHR){
						//alert(data);
						window.open('same_candidate.php?name='+name,'news view','height=600, width=1000, resizable=yes, scrollbars=yes');
					},
					error : function( jqXHR, textStatus, errorThrown){
					}
				});
			}
  		});
	  });
	  </script>

<tr>

<td align="right" valign="top">LCA Count</td>
		<input type="hidden" value="<?php echo $_REQUEST['userid']; ?>" name="h_id" id="h_id" />
        <td><input name="lca_count" type="text" class="validate[custom[integer],minSize[2],maxSize[2]] textfield require_field" value="<?php echo $_POST['lca_count']; ?>" maxlength="2"/></td>

</tr>
       <tr>

</tr>

<tr>

<td align="right" valign="top">LCA Number</td>

</tr>

<tr>

<td align="right" valign="top">Work Location1 </td>

</tr>

<tr>

<td align="right" valign="top">Prevl Wages1 </td>

<td><input name="prevl_wages1" type="text" class="textfield require_field" value="<?php echo $_POST['prevl_wages1']; ?>" onKeyPress="return restrictChars(event, this)" /></td>

</tr>

<tr>

<td align="right" valign="top">Work Location2 </td>
          <td><input name="work_location2" type="text" class="textfield require_field" value="<?php echo $_POST['work_location2']; ?>" /></td>

</tr>

<tr>

<td align="right" valign="top">Prevl Wages2 </td>

<td><input name="prevl_wages2" id="prevl_wages2" type="text" class="textfield require_field" value="<?php echo $_POST['prevl_wages2']?>"  onKeyPress="return restrictChars(event, this)"/></td>

</tr>
      
      
      <tr>

<td align="right" valign="top">Wage Rate </td>
        <td width="100%">
	      <input name="wage_rate" id="wage_rate" type="text" class="textfield require_field" value="<?php echo $_POST['wage_rate']?>"  onKeyPress="return restrictChars(event, this)"/>
        </td>
      </tr>
      <tr>

<td align="right" valign="top">LCA Position Title </td>

</tr>

</table>

</td>

<tr>

</tr>

<tr>
     <script>     
$(function()
 //{
//	 $( "#start_date" ).datepicker({
//		dateFormat:"mm/dd/yy"
//	});
{
    $('#start_date').datepicker({
          //  minDate: 0,
            onSelect: function(dateStr) { 
			dateFormat:"mm/dd/yy"     
                  var date = $(this).datepicker('getDate');
                  if (date) {
                        date.setDate(date.getDate());
                  }
                  $('#end_date').datepicker('option', 'minDate', date);
            }
      });
      $('#end_date').datepicker({
           // minDate: 0,
            onSelect: function (selectedDate) {
                  var date = $(this).datepicker('getDate');
                  if (date) {
                        date.setDate(date.getDate());
                  }
                  $('#start_date').datepicker('option', 'maxDate', date || 0);
            }
      });
});
</script>

<td align="right" valign="top">Start Date </td>

</tr>

<tr>

</td>

</tr>
      
       <tr>

<td align="right" valign="top">LCA Activity Status </td>

</tr>

<tr>
		<script>
$(function() {
	$( "#labor_approval_date" ).datepicker({
		dateFormat:"<?php echo $dateFormat; ?>"
	});
	//$( "#post_date" ).datepicker( "dd-mm-yy", "dateFormat" );
});
</script>
        <td align="right" valign="top">Exmpt </td>

</td>

</tr>
      
      <tr>
      <td align="right" valign="top">LCA Status </td>
      <td>
	   
<select id="lca_staus"  class="textfield require_field"style="width:184px;" name="lca_staus">

<option value="Active" selected="selected">Active</option>
    <option value="Inactive">Inactive</option>
    <option value="Expired">Expired</option>
    <option value="Future">Future</option>

</select>
<span id="errorMsg" style="display:none; color:#F00;">Another LCA is already Active; please Inactive that first</span>
</td>
        </tr>

<tr>

<td align="right">Associate's Qualification </td>

</tr>
       <tr>
      <script>
$(function() {
	$( "#graduation_year" ).datepicker({
		dateFormat:"<?php echo $dateFormat; ?>"
	});
	//$( "#post_date" ).datepicker( "dd-mm-yy", "dateFormat" );
});
</script>

<td align="right">Graduation Year </td>

</tr>
      <tr>
		
        <td align="right">Experience Years </td>

</tr>

</table>

</td>
	
     <td width="26%" valign="top">

<tr>

</tr>

<tr>

<td align="right">Current Salary </td>

<td><input name="current_salary" id="current_salary" type="text" class="textfield require_field" value="<?php echo $_POST['current_salary']; ?>" onKeyPress="return restrictChars(event, this)" /></td>

</tr>
      
      <tr>

<td align="right">LCA Level </td>

<td><input name="lca_level" id="lca_level" type="text" class="validate[custom[integer],minSize[2],maxSize[2]] textfield require_field" value="<?php echo $_POST['lca_level']; ?>"  maxlength="2"/></td>

</tr>
      
      <tr>

<td align="right">LCA Given Rcpt </td>

</tr>
      <tr>

<td align="right">10 Days Posting Notice </td>

</tr>

<tr>

<td align="right">Current Employment Status </td>

</tr>

<tr>

<td align="right">Public Inspection File </td>

</tr>
      
       <tr>

<td align="right">Notes </td>

</tr>

<tr>

<td align="right">Filed By </td>

<td>
        <select id="filed_by" class="textfield require_field" style="width:184px;;" name="filed_by">
<option value="">Select</option>
<option value="John">JOHN</option>
<option value="Slowik">SLOWIK</option>
<option value="Boudia">BOUDIA</option>
<option value="Georges">GEORGE</option>
<option value="James">JAMES</option>
<option value="Leblang">LEBLANG</option>
<option value="Andrew">ANDREW</option>
<option value="Absi">ABSI</option>
<option value="Murthy">MURTHY</option>
<option value="N/A">N/A</option>
</select>
        </td>

</tr>
      
	</table>
     
     
     
     <tr>

<td colspan="7" align="center"><input name="update" type="submit" value="Save" class="submit" style="margin-bottom:10px;" />
      
<a href="view_LCA.php?userid=<?=$_REQUEST['userid'];?>&page=<?php echo $_REQUEST['page']; ?>&name=<?=$_REQUEST['name']?>&email=<?=$_REQUEST['email']?>&associate_type=<?=$_REQUEST['associate_type']?>&visa_status=<?=$_REQUEST['visa_status']?>&account_manager=<?=$_REQUEST['account_manager']?>&hr_manager=<?=$_REQUEST['hr_manager']?>&sales_manager=<?=$_REQUEST['sales_manager']?>&hotlist=<?=$_REQUEST['hotlist']?>&blacklisted=<?=$_REQUEST['blacklisted']?>&send_emails=<?=$_REQUEST['send_emails']?>&relocation=<?=$_REQUEST['relocation']?>&record_status=<?=$_REQUEST['record_status']?>&submit2=<?=$_REQUEST['submit2']?>&state=<?=$_REQUEST['state']?>&city=<?=$_REQUEST['city']?>&primary_skills_src=<?=$primary_skills?>&secondary_skills_src=<?=$secondary_skills?>&first=<?=$_REQUEST['first']?>&last=<?=$_REQUEST['last']?>">
<input name="cancel" type="button" value="Cancel" class="submit" style=" margin-bottom:10px;" /></a>
  </td>

</tr>

</table>

</form>

</div>

<?php include("includes/footer.php"); ?>