File manager

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

Back
<?php include 'core/init.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= $user_data['company']; $myDate = date_create() ->format("Y-m-d"); ?> <?php //if submit/ save to databasevar if(isset($_POST['done'])){ $LegalOfficer = mysql_escape_string($_POST['LegalOfficer']); $TreasuryOfficer = mysql_escape_string($_POST['TreasuryOfficer']); $PayrollOfficer = mysql_escape_string($_POST['PayrollOfficer']); $AccountOfficer = mysql_escape_string($_POST['AccountOfficer']); $CLApprovingB= mysql_escape_string($_POST['CLApprovingB']); $addCompID = mysql_escape_string($_POST['addCompID']); $hrApprovingOfficer = mysql_escape_string($_POST['hrApprovingOfficer']); $MyUserID = mysql_escape_string($_POST['MyUserID']); $CLTemplateName = mysql_escape_string($_POST['CLTemplateName']); $myDate = mysql_escape_string($_POST['myDate']); $CLCoverage = mysql_escape_string($_POST['CLCoverage']); $CLRank = mysql_escape_string($_POST['CLRank']); $CLRecommendB = mysql_escape_string($_POST['CLRecommendB']); $CLRecommendA = mysql_escape_string($_POST['CLRecommendA']); $CLApproving = mysql_escape_string($_POST['CLApproving']); //$templateName = "CLEARANCE TEMPLATE - " .$CLRank. " - ".$CLCoverage; switch($CLRank){ case 'RNF': $OfficerSLA = 2; break; case 'EXE': $OfficerSLA = 3; break; case 'MGR': $OfficerSLA = 3; break; } //===================================================================================================================================================== //===================================================================================================================================================== mysql_query("INSERT INTO cl_template_name (cl_comp_id, cl_template_name, cl_template_tag, cl_template_rank, timeStamp,cl_approving_officer, cl_recommending_officer_a, cl_recommending_officer_b, cl_hr_approval_id,payroll_officer,treasury_officer,legal_officer,accounting_officer,cl_approving_officer_b,sla_days) VALUES('{$addCompID}','{$CLTemplateName}','{$CLCoverage}','{$CLRank}','{$myDate}','{$CLApproving}','{$CLRecommendA}','{$CLRecommendB}','{$hrApprovingOfficer}','{$PayrollOfficer}','{$TreasuryOfficer}','{$LegalOfficer}','{$AccountOfficer}','{$CLApprovingB}','{$OfficerSLA}')"); $gtTempHeader = mysql_query("SELECT * FROM `cl_template_name` WHERE `cl_template_status` = 1 AND `cl_comp_id`='$compID'ORDER BY `id` ASC"); echo "<table>"; echo "<thead>"; echo "<th style='width:5%'>No.</th>"; echo "<th style='width:10%'>LEVEL</th>"; echo "<th style='width:20%'>DESCRIPTOIN</th>"; echo "<th style='width:10%'>COVERAGE</th>"; echo "<th style='width:15%'>RECOMMENDIG OFFICER #1</t>"; echo "<th style='width:15%'>RECOMMENDIG OFFICER #1</t>"; echo "<th style='width:15%'>APPROVING OFFIER</t>"; echo "<th style='width:15%;border:0px solid white'>AUTHORIZING HR</t>"; ECHO "</thead>"; while($row=mysql_fetch_array($gtTempHeader)){ $rcaF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_recommending_officer_a']."'"),0); $rcaL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_recommending_officer_a']."'"),0); $rcbF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_recommending_officer_b']."'"),0); $rcbL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_recommending_officer_b']."'"),0); $aprF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_approving_officer']."'"),0); $aprL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_approving_officer']."'"),0); $aprHRL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_hr_approval_id']."'"),0); $aprHRF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_hr_approval_id']."'"),0); ?><tr onclick="javascript:showSelectedBrand(this);"><?php echo "<td style='cursor:pointer;border:0px solid white'>".$row['id']."</td>"; echo "<td style='cursor:pointer;border:0px solid white'>"; if($row['cl_template_tag']==='CO'){ echo "COMPANY LEVEL"; }else{ echo "AUTOHUB LEVEL"; } echo"</td>"; echo "<td style='cursor:pointer;border:0px solid white'>".$row['cl_template_name']."</td>"; echo "<td style='cursor:pointer;border:0px solid white'>"; echo $row['cl_template_rank']; echo"</td>"; echo "<td style='cursor:pointer;border:0px solid white'>"; echo $rcaL .', '.$rcaF; echo"</td>"; echo "<td style='cursor:pointer;border:0px solid white'>"; echo $rcbL .', '.$rcbF; echo"</td>"; echo "<td style='cursor:pointer;border:0px solid white'>"; echo $aprL .', '.$aprF; echo"</td>"; echo "<td style='cursor:pointer;border:0px solid white'>"; echo $aprHRL .', '.$aprHRF; echo"</td>"; echo "</tr>"; } echo "</table>"; //echo '<script>alert("New Record has been saved...")</script>'; //echo "<p style='margin:0px;padding:5px;font-family:Calibri;font-size:16px;font-weight:normal;color:blue;background:yellow;width:100%;display:block'>✏ NEW RECORD HAS BEEN ADDED</p>"; exit(); } ?>

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