File manager

File manager - Edit - /home/autoph/public_html/voc/home/cl_resignation_acceptance_letter.php

Back
<?php include 'core/database/connect.php'; //$connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee1024') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); error_reporting(1); //$compID = $comID; //echo "My Company ID: ".$comID; $myDate = date_create() ->format("Y-m-d"); $toTime =date('H:i:s'); $dateTime = $myDate . " ".$toTime; if(isset($_POST['done'])){ $clearanceID = mysql_escape_string($_POST['clearanceID']); $SelUserName = mysql_escape_string($_POST['SelUserName']); $SelEMPID = mysql_escape_string($_POST['SelEMPID']); $SelDateCreated = mysql_escape_string($_POST['SelDateCreated']); $SelPosition = mysql_escape_string($_POST['SelPosition']); $fileLink = mysql_result(mysql_query("SELECT `cl_final_computation` FROM `cl_clearance_header` WHERE `h_id`='$clearanceID'"),0); $fileLinkT = mysql_result(mysql_query("SELECT `cl_check_request_attachment` FROM `cl_clearance_header` WHERE `h_id`='$clearanceID'"),0); $resLetter = mysql_result(mysql_query("SELECT `cl_resignation_letter` FROM `cl_clearance_header` WHERE `h_id`='$clearanceID'"),0); $accLetter = mysql_result(mysql_query("SELECT `cl_acceptance_letter` FROM `cl_clearance_header` WHERE `h_id`='$clearanceID'"),0); $effectiveDate =mysql_result(mysql_query("SELECT `cl_effectivity_date` FROM `cl_clearance_header` WHERE `h_id`='$clearanceID'"),0); $QCLetter = mysql_result(mysql_query("SELECT `cl_quit_claim_document` FROM `cl_clearance_header` WHERE `h_id`='$clearanceID'"),0); $WVLetter =mysql_result(mysql_query("SELECT `cl_waiver_document` FROM `cl_clearance_header` WHERE `h_id`='$clearanceID'"),0); echo "<div style='float:left;padding:1px;font-family:Yu Gothic;font-size:10px;width:100%;color:black'><hr style='background:transparent;border:0px;border-bottom:1px solid gray;'> </div>"; echo "<div style='float:left;padding:2px;font-family:Yu Gothic;font-size:14px;width:40%;color:black'>EMPLOYEE ID: </div>"; echo "<div style='float:left;padding:2px;font-family:Yu Gothic;font-size:14px;width:60%;font-weight:bold;color:black'>".$SelEMPID." </div>"; echo "<div style='float:left;padding:2px;font-family:Yu Gothic;font-size:14px;width:40%;color:black'>EMPLOYEE NAME: </div>"; echo "<div style='float:left;padding:2px;font-family:Yu Gothic;font-size:14px;width:60%;font-weight:bold;color:black'>".$SelUserName." </div>"; echo "<div style='float:left;padding:2px;font-family:Yu Gothic;font-size:14px;width:40%;color:black'>POSITION: </div>"; echo "<div style='float:left;padding:2px;font-family:Yu Gothic;font-size:14px;width:60%;font-weight:bold;color:black'>".$SelPosition." </div>"; echo "<div style='float:left;padding:2px;font-family:Yu Gothic;font-size:14px;width:40%;color:black'>CLEARANCE DATE: </div>"; echo "<div style='float:left;padding:2px;font-family:Yu Gothic;font-size:14px;width:60%;font-weight:bold;color:black'>".$SelDateCreated." </div>"; echo "<div style='float:left;padding:2px;font-family:Yu Gothic;font-size:14px;width:40%;color:black'>EFFECTIVITY DATE: </div>"; echo "<div style='float:left;padding:2px;font-family:Yu Gothic;font-size:14px;width:60%;font-weight:bold;color:black'>".$effectiveDate." </div>"; echo ""; echo "<div style='margin:2px;padding:2px;width:100%;background:lightgray;font-family:Yu Gothic Light;font-weight:bold;font-size:16px;color:black;text-aligh:left;float:left'>Uploaded Documents:</div>"; if($resLetter != ''){ echo "<div style='float:left;padding:2px;font-family:Yu Gothic;font-size:14px;width:100%;font-weight:normal;color:black;margin-top:10px;text-align:left;background:#f0fdc1'> <a href='".$resLetter."' target='_Blank'>📃 View Resignation Letter</a><hr style='background:transparent;border:0px;border-bottom:1px solid gray;'> </div>"; }else{ echo "<div style='float:left;padding:2px;font-family:Yu Gothic;font-size:14px;width:100%;font-weight:normal;color:black;margin-top:10px;text-align:left;background:#f0fdc1'> <a href='#'>📃 NO Resignation Letter has been attached</a><hr style='background:transparent;border:0px;border-bottom:1px solid gray;'> </div>"; } if($accLetter != ''){ echo "<div style='float:left;padding:2px;font-family:Yu Gothic;font-size:14px;width:100%;font-weight:normal;color:black;margin-top:10px;text-align:left;background:#f0fdc1'> <a href='".$accLetter."' target='_Blank'>📃 View Acceptance Letter</a><hr style='background:transparent;border:0px;border-bottom:1px solid gray;'> </div>"; } else{ echo "<div style='float:left;padding:2px;font-family:Yu Gothic;font-size:14px;width:100%;font-weight:normal;color:black;margin-top:10px;text-align:left;background:#f0fdc1'> <a href='#'>📃 NO Acceptance Letter has been attached</a><hr style='background:transparent;border:0px;border-bottom:1px solid gray;'> </div>"; } //echo "<script>alert('".$hFname ." ". $hLname ." has been cleared!')</script>"; exit(); } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings