File manager

File manager - Edit - /home/autoph/public_html/connect/home/CLLoadClearanceForUpdate.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); <p style="border-radius:0px;float:right;width:100%;padding:10px;padding-top:5px;height:40px">❖   CLEARANCE INFORMATION: </p> $compID= $user_data['company']; $myDate = date_create() ->format("Y-m-d"); $toTime =date('H:i:s'); $dateTime = $myDate . " ".$toTime; if(isset($_POST['done'])){ $recordID = mysql_escape_string($_POST['recordID']); $uID=mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clDate=mysql_result(mysql_query("SELECT `cl_h_date_created` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $ceDate=mysql_result(mysql_query("SELECT `cl_effectivity_date` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $uFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uComp = mysql_result(mysql_query("SELECT `company` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uDeal = mysql_result(mysql_query("SELECT `dealer` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uCompName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$uComp'"),0); $uDealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$uDeal'"),0); $uPosition = mysql_result(mysql_query("SELECT `u_position` FROM `vts_users` WHERE `u_id`='$uID'"),0); ?> <div style="float:left;color:black;padding:1px;width:35%;height:100px;margin:0px;border;1px solid red;background:white;border-bottom:1px solid gray"> Employee Name: <p style='margin:0px;margin-top:0px;font-weight:bold;font-size:14px' id='empName'><?php echo $uFName ." " .$uLName;?></p> Position: <p style='margin-left:0px;margin-top:0px;font-weight:bold;font-size:14px' id='empPosition'><?php echo $uPosition;?></p> </div> <div style="float:left;color:black;padding:1px;width:35%;height:100px;margin:0px;border;1px solid red;background:white;border-bottom:1px solid gray"> Company: <p style='margin:0px;margin-top:0px;font-weight:bold;font-size:14px' id='empCompany'><?php echo $uCompName;?></p> Dealer: <p style='margin:0px;margin-top:0px;font-weight:bold;font-size:14px' id='empDealer'><?php echo $uDealName;?></p> </div> <div style="float:left;color:black;padding:0px;width:30%;height:100px;margin:0px;border;1px solid red;background:white;border-bottom:1px solid gray"> Clearance Date: <p style='margin:0px;margin-top:0px;font-weight:bold;font-size:14px' id='createdDate'><?php echo $clDate;?></p> Effectivity Date: <input type='date' value='' style='width:100%;margin:0px;margin-top:0px;font-weight:bold;font-size:14px' id='EffectiveDate'></p> </div> <?php echo "<p style='margin-bottom:0px;margin-left:0px;padding:0px;padding-top:20px'>Select Dept/Unit:</p>"; echo "<select id='headerData'>"; echo "<option value=''>--Select Unit--</option>"; $getUnit = mysql_query("SELECT `cl_id`, `cl_div_id`,`cl_unit_id` FROM `cl_clearance_data` WHERE `cl_hdr_id`='$recordID' ORDER BY `cl_div_id` ASC"); while($row=mysql_fetch_array($getUnit)){ $unitID =$row['cl_unit_id']; $divID =$row['cl_div_id']; //echo $unitID; $unitName = mysql_result(mysql_query("SELECT `cl_unit_name` FROM `cl_approving_unit` WHERE `id`='$unitID'"),0); $DivName = mysql_result(mysql_query("SELECT `cl_div_name` FROM `cl_approving_division` WHERE `id`='$divID'"),0); echo "<option value='".$row['cl_id']."'>".strtoupper($row['cl_div_id']). ":". strtoupper($row['cl_unit_id'])." - (".strtoupper($DivName).") - ".strtoupper($unitName)."</option>"; } echo "</select>"; echo "<p style='margin-bottom:0px;margin-left:0px;padding:0px;padding-top:20px'>Select Clearing Officer:</p>"; echo "<select id='clearingID'>"; echo "<option value=''>--Select Officers--</option>"; echo "<option value='0'>--Remove Signatory--</option>"; $getOfficers = mysql_query("SELECT cl_approving_officers.`cl_emp_id_a`, cl_approving_officers.`id`, cl_approving_officers.`cl_status`, vts_users.`u_id`, vts_users.`u_fname`, vts_users.`u_lname` FROM cl_approving_officers join vts_users ON cl_approving_officers.cl_emp_id_a = vts_users.u_id WHERE cl_approving_officers.`cl_status`=1 GROUP BY `cl_emp_id_a` ORDER BY `u_lname` ASC "); while($row=mysql_fetch_array($getOfficers)){ $offID =$row['u_id']; echo "<option value='".$row['u_id']."'>".strtoupper($row['u_lname']).", ".strtoupper($row['u_fname'])."</option>"; } echo "</select>"; echo "<div style='margin-top:20px;width:50%;height:150px;border:1px solid gray;float:left;margin-left:0px;padding:5px;'>"; echo "<b style='width:100%;font-size:12px;color:black;font-weight:normal'>Recommending Officer #1</b><br>"; echo "<select id='recomendA' style='margin:5px'>"; echo "<option value=''>--Select Officer A--</option>"; echo "<option value='0'>--Remove Officer--</option>"; $getOfficers = mysql_query("SELECT * FROM `vts_users` WHERE `approver`=1 AND `u_status`=1 ORDER BY `u_lname` ASC"); while($row=mysql_fetch_array($getOfficers)){ $offID =$row['u_id']; echo "<option value='".$row['u_id']."'>".strtoupper($row['u_lname']).", ".strtoupper($row['u_fname'])."</option>"; } echo "</select>"; echo "<br><br><b style='width:100%;font-size:12px;color:black;font-weight:normal'>Recommending Officer #2</b>"; echo "<select id='recomendB' style='margin:5px'>"; echo "<option value=''>--Select Officer B--</option>"; echo "<option value='0'>--Remove Officer--</option>"; $getOfficers = mysql_query("SELECT * FROM `vts_users` WHERE `approver`=1 AND `u_status`=1 ORDER BY `u_lname` ASC"); while($row=mysql_fetch_array($getOfficers)){ $offID =$row['u_id']; echo "<option value='".$row['u_id']."'>".strtoupper($row['u_lname']).", ".strtoupper($row['u_fname'])."</option>"; } echo "</select>"; echo "</div>"; echo "<div style='margin-top:20px;width:49%;height:150px;border:1px solid gray;float:left;margin-left:3px;padding:5px;'>"; echo "<b style='width:100%;font-size:12px;color:black;font-weight:normal'>Approving Officer #1</b><br>"; echo "<select id='approverA' style='margin:5px'>"; echo "<option value=''>--Select Officer A--</option>"; echo "<option value='0'>--Remove Officer--</option>"; $getOfficers = mysql_query("SELECT * FROM `vts_users` WHERE `approver`=1 AND `u_status`=1 ORDER BY `u_lname` ASC"); while($row=mysql_fetch_array($getOfficers)){ $offID =$row['u_id']; echo "<option value='".$row['u_id']."'>".strtoupper($row['u_lname']).", ".strtoupper($row['u_fname'])."</option>"; } echo "</select>"; echo "<br><br><b style='width:100%;font-size:12px;color:black;font-weight:normal'>Approving Officer #2</b>"; echo "<select id='approverB' style='margin:5px'>"; echo "<option value=''>--Select Officer B--</option>"; echo "<option value='0'>--Remove Officer--</option>"; $getOfficers = mysql_query("SELECT * FROM `vts_users` WHERE `approver`=1 AND `u_status`=1 ORDER BY `u_lname` ASC"); while($row=mysql_fetch_array($getOfficers)){ $offID =$row['u_id']; echo "<option value='".$row['u_id']."'>".strtoupper($row['u_lname']).", ".strtoupper($row['u_fname'])."</option>"; } echo "</select>"; echo "</div>"; echo "<p id='actioinMessage' style='font-family:Yu Gothic Light;font-size:12px;color:gray;display:block;width:100%;float:left;;font-weightNormal'></p>"; exit(); } ?>

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