File manager

File manager - Edit - /home/autoph/public_html/voc/home/CL_Save_New_TemplateEdit.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'])){ $selectedTemplate = mysql_escape_string($_POST['selectedTemplate']); $LegalOfficerEdit = mysql_escape_string($_POST['LegalOfficerEdit']); $TreasuryOfficerEdit = mysql_escape_string($_POST['TreasuryOfficerEdit']); $PayrollOfficerEdit = mysql_escape_string($_POST['PayrollOfficerEdit']); $AccountOfficerEdit = mysql_escape_string($_POST['AccountOfficerEdit']); $CLApprovingBEdit= mysql_escape_string($_POST['CLApprovingBEdit']); $addCompID = mysql_escape_string($_POST['addCompID']); $hrApprovingOfficerEdit = mysql_escape_string($_POST['hrApprovingOfficerEdit']); $MyUserID = mysql_escape_string($_POST['MyUserID']); $CLTemplateNameEdit = mysql_escape_string($_POST['CLTemplateNameEdit']); $myDate = mysql_escape_string($_POST['myDate']); $CLCoverageEdit = mysql_escape_string($_POST['CLCoverageEdit']); $CLRankEdit = mysql_escape_string($_POST['CLRankEdit']); $CLRecommendBEdit = mysql_escape_string($_POST['CLRecommendBEdit']); $CLRecommendAEdit = mysql_escape_string($_POST['CLRecommendAEdit']); $CLApprovingEdit = mysql_escape_string($_POST['CLApprovingEdit']); //$templateName = "CLEARANCE TEMPLATE - " .$CLRank. " - ".$CLCoverage; switch($CLRank){ case 'RNF': $OfficerSLA = 2; break; case 'EXE': $OfficerSLA = 3; break; case 'MGR': $OfficerSLA = 3; break; } //===================================================================================================================================================== //===================================================================================================================================================== mysql_query("UPDATE cl_template_name SET cl_template_name='$CLTemplateNameEdit', cl_template_rank='$CLRankEdit',cl_approving_officer='$CLApprovingEdit', cl_recommending_officer_a='$CLRecommendAEdit', cl_recommending_officer_b='$CLRecommendBEdit', cl_hr_approval_id='$hrApprovingOfficerEdit',payroll_officer='$PayrollOfficerEdit',treasury_officer='$TreasuryOfficerEdit',legal_officer='$LegalOfficerEdit',accounting_officer='$AccountOfficerEdit',cl_approving_officer_b='$CLApprovingBEdit',sla_days='$OfficerSLAEdit' WHERE `id`='$selectedTemplate'"); $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("Template has been updated")</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.69 | proxy | phpinfo | Settings