File manager

File manager - Edit - /home/autoph/public_html/connect/home/CL_LOAD_CLEARANCE_SIGNATORY.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'])){ $ClearanceHdrID = mysql_escape_string($_POST['ClearanceDataID']); $addByUID = mysql_escape_string($_POST['addByUID']); //$ActionSlip = mysql_escape_string($_POST['ActionSlip']); $myKeyCode=mysql_result(mysql_query("SELECT `key_code` FROM `cl_clearance_header` WHERE `h_id`='$ClearanceHdrID'"),0); $empUID = mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `h_id`='$ClearanceHdrID'"),0); //mysql_query("INSERT INTO cl_action_slip_data(cl_hdr_id, cl_key_code, cl_emp_id, cl_request_by_id, cl_slip_info, cl_slip_date, cl_slip_time) //VALUES('{$ClearanceHdrID}','{$myKeyCode}','{$empUID}','{$addByUID}','{$actionSlipAction}','{$myDate}','{$toTime}')"); //SEND EMAIL AND SMS NOTIFICATION HERE... echo "<table>"; echo "<thead>"; echo "<th style='min-width:280px'>ACCOUNTABILITY AREAS</th>"; echo "<th style='min-width:280px'>APPROVING OFFICER</th>"; echo "<th style='min-width:110px'>STATUS</th>"; echo "<th style='min-width:135px'>DATE SIGNED</th>"; echo "<th style='min-width:135px'>TIME SIGNED</th>"; echo "<th style='min-width:170px;border-right:0px'>ACTION SLIP</th>"; echo "<th style='min-width:10px;border-left:0px'></th>"; echo "</thead>"; $myCL=mysql_query("SELECT DISTINCT(cl_div_id) FROM `cl_clearance_data` WHERE `key_code`='$myKeyCode' ORDER BY `cl_div_id` ASC"); while($cRow = mysql_fetch_array($myCL)){ $divID = $cRow['cl_div_id']; $divName = mysql_result(mysql_query("SELECT `cl_div_name` FROM `cl_approving_division` WHERE `id`='$divID'"),0); echo "<tr>"; echo "<td colspan='7' style='padding:0px;background:white;border:0px solid white;padding-top:15px;font-family:Calibri;font-size:14px;font-weight:bold'>    ".$cRow['cl_div_id'].".    ".strtoupper($divName); //echo $myKeyCode. " \| ".$divID; $myCLU=mysql_query("SELECT * FROM `cl_clearance_data` WHERE `key_code`='$myKeyCode' AND `cl_div_id`='$divID' ORDER BY `cl_unit_id` ASC"); echo "<table style='width:100%;border-collapse:collapse;'>"; while($uRow=mysql_fetch_array($myCLU)){ $countUnit=$countUnit+1; $unitID = $uRow['cl_unit_id']; $aprID = $uRow['cl_approver_id_a']; $aprByID = $uRow['cl_approved_by_id']; $unitName = mysql_result(mysql_query("SELECT `cl_unit_name` FROM `cl_approving_unit` WHERE `id`='$unitID'"),0); ?><tr onDblclick="javascript:getApproverID(this);"><?php echo "<td style='padding:5px;padding-left:25px;width:270px;border:0px solid white;border-bottom:1px solid lightgray'>".$divID.".".$countUnit."   ".$unitName."</td>"; echo "<td style='min-width:290px;padding:5px;border:0px solid white;border-bottom:1px solid lightgray'>"; if($aprID != '0'){ $uLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$aprID'"),0); $uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$aprID'"),0); echo strtoupper($uLName).", ".strtoupper($uFName); }else{ echo "N/A"; } echo "</td>"; echo "<td style='padding:5px;width:130px;border:0px solid white;border-bottom:1px solid lightgray'>"; if($uRow['cl_approved_date']!=''){ echo "<b style='font-family:Calibri;font-size:12px;bold;color:green'>CLEARED</b>"; }else{ if($aprID != '0'){ echo "<b style='font-family:Calibri;font-size:12px;font-weight:normal;color:black'>PENDING</b>"; }else{ echo "N/A"; } } echo"</td>"; echo "<td style='width:135px;padding:5px;border:0px solid white;text-align:center;border-bottom:1px solid lightgray'>"; if($uRow['cl_approved_date']!=''){ echo $uRow['cl_approved_date']; }else{ echo "--:--:--"; } echo "</td>"; echo "<td style='width:135px;padding:5px;;border:0px solid white;text-align:center;border-bottom:1px solid lightgray'>"; if($uRow['cl_approved_time']!=''){ echo $uRow['cl_approved_time']; }else{ echo "--:--:--"; } echo "</td>"; echo "<td style='width:140px;padding:5px;border:0px solid white;text-align:center;border-bottom:1px solid lightgray'>"; $withAction = mysql_result(mysql_query("SELECT COUNT(id) FROM `cl_action_slip_data` WHERE `cl_key_code`='$myKeyCode' AND `cl_request_by_id`='$aprID'"),0); if($withAction > 0 ){ echo "<button style='font-family:Calibri;font-size:12px;color:red;padding:5px;cursor:pointer;font-weight:normal;height:25px;background:yellow'>ACTION REQUIRED</button>"; }else{ echo "&check;"; } echo "</td>"; echo "<td style='width:80px;padding:5px;border:0px solid white;text-align:center;font-family:Arial;font-size:8px;color:transparent;border-bottom:1px solid lightgray'>".$uRow['cl_id']."</td>"; echo "</tr>"; } echo "</table>"; $countUnit=0; echo "</td>"; echo "</tr>"; } echo "</table>"; exit(); } ?>

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