File manager

File manager - Edit - /home/autoph/public_html/connect/home/CL_load_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']; $userID=$user_data['u_id']; $myDate = date_create() ->format("Y-m-d"); ?> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <div id="wait" style="display:none;width:400px;height:100px;border:0px solid red;position:absolute;top:50%;left:45%;padding:2px;z-index:999999999999999999"> <img src='images/demo_wait.gif' width="64" height="64" /><br>Loading...</div> <!-- add jquery --> <script type="text/javascript" src="http://code.jquery.com/jquery-1.9.1.js"></script> <script language="javascript" type="text/javascript"> $(document).ready(function(){ $(document).ajaxStart(function(){ $("#wait").css("display", "block"); }); $(document).ajaxComplete(function(){ $("#wait").css("display", "none"); }); //============================================================================================================================================ //============================================================================================================================================ //============================================================================================================================================ //============================================================================================================================================ }); function hideAssignMsg(){ $("#templateUpdateMSG").fadeOut(3000); }; function showAssignMsg(){ $("#templateUpdateMSG").fadeIn(); }; </script> <script type="text/javascript"> $('.drop').bind("change",function(){ var divID = $(this).attr('id'); // endaya var unitID = $("#unitID").val();// Approving Unit var officerID = $(this).val(); // Approving Person var compID = $("#compID").val(); // Company of Clearance template var templateID = $("#templateID").val(); //Template ID var userID = $("#userID").val();//User ID who created the template var rank = $("#rank").val(); // template applied to position level RNF, MGR or EXE //alert(templateID); //return false; $.ajax({ url: "CL_save_update_Template.php", type: "POST", async: false, data: { "divID": divID, "unitID": unitID, "officerID": officerID, "compID": compID, "templateID": templateID, "userID": userID, "rank": rank, "done": 1 }, success: function(d){ //showAssignMsg(); //invShowAssignMsg(); $("#templateUpdateMSG").html(d); //invHideAssignMsg(); //$('#searchText').val(''); //hideAssignMsg(); } }) }); //SAVE SECONDARY APPROVING OFFICER $('.dropB').bind("change",function(){ var divID = $(this).attr('id'); // ApprovingDivision var unitID = $("#unitID").val();// Approving Unit var officerIDB = $(this).val(); // Approving Person var compID = $("#compID").val(); // Company of Clearance template var templateID = $("#templateID").val(); //Template ID var userID = $("#userID").val();//User ID who created the template var rank = $("#rank").val(); // template applied to position level RNF, MGR or EXE //alert(templateID); //return false; $.ajax({ url: "CL_save_update_Template_b.php", type: "POST", async: false, data: { "divID": divID, "unitID": unitID, "officerIDB": officerIDB, "compID": compID, "templateID": templateID, "userID": userID, "rank": rank, "done": 1 }, success: function(d){ //showAssignMsg(); //invShowAssignMsg(); $("#templateUpdateMSG").html(d); //invHideAssignMsg(); //$('#searchText').val(''); //hideAssignMsg(); } }) }); //SAVE HEAD OFFICE PORTION OF CLEARANCE $('.dropHOa').bind("change",function(){ var divIDh = $(this).attr('id'); // ApprovingDivision var unitIDh = $("#unitID").val();// Approving Unit var officerIDh = $(this).val(); // Approving Person var compIDh = $("#compID").val(); // Company of Clearance template var templateIDh = $("#templateID").val(); //Template ID var userIDh = $("#userID").val();//User ID who created the template var rankh = $("#rank").val(); // template applied to position level RNF, MGR or EXE //alert(divIDh); //alert(unitIDh); //alert(officerIDh); //alert(compIDh); //alert(templateIDh); //return false; $.ajax({ url: "CL_save_update_Template_HO_a.php", type: "POST", async: false, data: { "divIDh": divIDh, "unitIDh": unitIDh, "officerIDh": officerIDh, "compIDh": compIDh, "templateIDh": templateIDh, "userIDh": userIDh, "rankh": rankh, "done": 1 }, success: function(d){ //showAssignMsg(); //invShowAssignMsg(); $("#templateUpdateMSG").html(d); //invHideAssignMsg(); //$('#searchText').val(''); //hideAssignMsg(); } }) }); //SAVE SECONDARY APPROVING OFFICER $('.dropHOb').bind("change",function(){ var divID = $(this).attr('id'); // ApprovingDivision var unitID = $("#unitID").val();// Approving Unit var officerID = $(this).val(); // Approving Person var compID = $("#compID").val(); // Company of Clearance template var templateID = $("#templateID").val(); //Template ID var userID = $("#userID").val();//User ID who created the template var rank = $("#rank").val(); // template applied to position level RNF, MGR or EXE $.ajax({ url: "CL_save_update_Template_HO_b.php", type: "POST", async: false, data: { "divID": divID, "unitID": unitID, "officerID": officerID, "compID": compID, "templateID": templateID, "userID": userID, "rank": rank, "done": 1 }, success: function(d){ showAssignMsg(); //invShowAssignMsg(); $("#templateUpdateMSG").html(d); //invHideAssignMsg(); //$('#searchText').val(''); hideAssignMsg(); } }) }); function showSelectedUnitID(row) { var x=row.cells; document.getElementById("unitID").value = x[0].innerHTML; } </script> <?php //if submit/ save to databasevar if(isset($_POST['done'])){ $rank = mysql_escape_string($_POST['rank']); $selectedTemplate = mysql_escape_string($_POST['selectedTemplate']); $addByUID = mysql_escape_string($_POST['addByUID']); $addCompID = mysql_escape_string($_POST['addCompID']); $fCountHo = 0; $fCount = 0; //===================================================================================================================================================== //===================================================================================================================================================== echo "<input type='hidden' id='compID' value='$addCompID' style='background:yellow;width:100%;float:left'>"; echo "<input type='hidden' id='userID' value='$addByUID' style='background:purple;width:100%;float:left'>"; echo "<input type='hidden' id='templateID' value='$selectedTemplate' style='background:green;width:100%;float;left'>"; echo "<input type='hidden' id='rank' value='$rank' style='background:orange;width:100%;float:left'>"; echo "<input type='hidden' id='unitID' style='background:lightgray;width:100%;float:left'>"; echo "<div id='templateUpdateMSG' style='position:relative;width:100%;top:2px;left:0px;background:yellow;border:0px solid orange;margin-bottom:5px'>"; echo "</div>"; echo "<table> <tr> <td> <p class='menuTitle'>☸     ORGANIZATIONAL UNIT/DEALERSHIP/COMPANY CLEARANCE</P> </td> </tr> <tr> <td style='background:white'>"; $gtCOTemplate = mysql_query("SELECT * FROM `cl_approving_division` WHERE `cl_div_tag`='CO' ORDER BY `cl_div_order` ASC"); echo "<table>"; echo "<thead>"; echo "<th style='width:380px'>ACCOUNTABILITY AREA</th>"; echo "<th style='width:100px'>SLA</th>"; echo "<th style='width:300px'>CLEARING OFFICER (PRIMARY)</th>"; echo "<th style='width:100px'>SLA</th>"; echo "<th style='width:300px'>CLEARING OFFICER (SECONDARY)</th>"; echo "</thead>"; while($row=mysql_fetch_array($gtCOTemplate)){ $fCount = $fCount + 1; $divID = $row['id']; echo "<tr>"; echo "<td colspan='5' style='padding:0px;background:lightgray;padding-top:3px'><b style='font-family:Calibri;font-size:12px;font-weight:bold;color:black;padding:0px'>".$fCount.". ".$row['cl_div_name']."</b><br>"; $gtUNITTemplate = mysql_query("SELECT * FROM `cl_approving_unit` WHERE `cl_div_id`='$divID' ORDER BY `cl_order` ASC"); while($dRow=mysql_fetch_array($gtUNITTemplate)){ $unitID = $dRow['id']; echo "<table stsyle='width:100%;border:1px solid gray;border-collapse:collapse'>"; ?><tr onclick="javascript:showSelectedUnitID(this);"><?php echo "<td style='text-align:right;border:0px solid gray;width:30px;padding:0px;padding-left:30px;border-bottom:1px solid gray;font-family:Calibri;font-size:12px;color:black;border-right:0px solid gray'>".$unitID ."</td>"; echo "<td style='border:0px solid gray;width:250px;padding:0px;padding-left:0px;border-bottom:1px solid gray;font-family:Calibri;font-size:12px;color:black;border-right:1px solid gray'>- " .strtoupper($dRow['cl_unit_name'])."</td>"; echo "<td style='text-align:center;width:80px;border:0px;border-bottom:1px solid gray;border-right:1px solid gray'>"; $oldSLAa = mysql_result(mysql_query("SELECT `cl_sla_a` FROM `cl_approving_officers` WHERE `cl_div_id`='$divID' AND `cl_unit_id`='$unitID' AND `cl_level`='$rank' AND `cl_comp_id`='$compID' AND `cl_status`=1"),0); echo $oldSLAa. " Days"; echo"</td>"; echo "<td style='text-align:left;padding:0px;width:253px;border:0px;border-bottom:1px solid gray;border-right:1px solid gray;padding:2px'>"; echo "<select name='ApprovingPri[]' class='drop' id='". $divID."' style='margin:0px;padding:2px'>"; $oldOfficer = mysql_result(mysql_query("SELECT `cl_emp_id_a` FROM `cl_approving_officers` WHERE `cl_div_id`='$divID' AND `cl_unit_id`='$unitID' AND `cl_template_id`='$selectedTemplate' AND `cl_comp_id`='$compID' AND `cl_status`=1"),0); if($oldOfficer == '0'){ $oldApproverA ="NA"; } if($oldOfficer == ''){ $oldApproverA =""; } if($oldOfficer > 0){ $getFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$oldOfficer'"),0); $getLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$oldOfficer'"),0); $getPosition = mysql_result(mysql_query("SELECT `u_position` FROM `vts_users` WHERE `u_id`='$oldOfficer'"),0); $oldApproverA = $getLName.", ".$getFName." - ".$getPosition; } echo "<option value='0'>".strToUpper($oldApproverA)."</option>"; $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 AND `u_status`=1 ORDER BY `u_lname` ASC"); echo "<option value='0'>N/A</option>"; while($uRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$uRow['u_id']."'>".strToUpper($uRow['u_lname']).", ".strToUpper($uRow['u_fname'])." - ".strToUpper($uRow['u_position'])."</option>"; } echo "</select> </td>"; echo "<td style='text-align:center;width:80px;border:0px;padding:0px;border-bottom:1px solid gray;border-right:1px solid gray'>"; $oldSLAb = mysql_result(mysql_query("SELECT `cl_sla_b` FROM `cl_approving_officers` WHERE `cl_div_id`='$divID' AND `cl_unit_id`='$unitID' AND `cl_level`='$rank' AND `cl_comp_id`='$compID' AND `cl_status`=1"),0); echo $oldSLAb. " Days"; echo"</td>"; echo "<td style='text-align:left;width:253px;padding:0px;border:0px;border-bottom:1px solid gray;border-right:1px solid gray;padding:2px'>"; echo "<select name='ApprovingSec[]' class='dropB' id='". $divID."' style='margin:0px;padding:2px''>"; $oldOfficerB = mysql_result(mysql_query("SELECT `cl_emp_id_b` FROM `cl_approving_officers` WHERE `cl_div_id`='$divID' AND `cl_unit_id`='$unitID' AND `cl_template_id`='$selectedTemplate' AND `cl_comp_id`='$compID' AND `cl_status`=1"),0); if($oldOfficerB == '0'){ $oldApproverB ="NA"; } if($oldOfficerB == ''){ $oldApproverB =""; } if($oldOfficerB > 0){ $getFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$oldOfficerB'"),0); $getLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$oldOfficerB'"),0); $getPosition = mysql_result(mysql_query("SELECT `u_position` FROM `vts_users` WHERE `u_id`='$oldOfficerB'"),0); $oldApproverB = $getLName.", ".$getFName." - ".$getPosition; } echo "<option value=''>".strToUpper($oldApproverB)."</option>"; $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 AND `u_status`=1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($uRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$uRow['u_id']."'>".strToUpper($uRow['u_lname']).", ".strToUpper($uRow['u_fname'])." - ".strToUpper($uRow['u_position'])."</option>"; } echo "</select> </td>"; echo "</tr>"; echo "</table>"; } echo"</td>"; echo "</tr>"; } echo "</table>"; echo "</td> </tr> <tr> <td> <p class='menuTitle'>☸     HEAD OFFICE CLEARANCE</P> </td> </tr> <tr> <td style='background:white;padding:10px;'>"; $gtHOTemplate = mysql_query("SELECT * FROM `cl_approving_division` WHERE `cl_div_tag`='HO' ORDER BY `cl_div_order` ASC"); echo "<table>"; echo "<thead>"; echo "<th style='width:380px'>ACCOUNTABILITY AREA</th>"; echo "<th style='width:100px'>SLA</th>"; echo "<th style='width:300px'>CLEARING OFFICER (PRIMARY)</th>"; echo "<th style='width:100px'>SLA</th>"; echo "<th style='width:300px'>CLEARING OFFICER (SECONDARY)</th>"; echo "</thead>"; while($hRow=mysql_fetch_array($gtHOTemplate)){ $fCountHo = $fCountHo + 1; $divIDHO = $hRow['id']; echo "<tr>"; echo "<td colspan='5' style='padding:0px;background:lightgray;padding-top:2px'><b style='font-family:Calibri;font-size:12px;font-weight:bold;color:black;padding:0px'>".$fCountHo.". ".$hRow['cl_div_name']."</b><br>"; $gtUNITTemplateHO = mysql_query("SELECT * FROM `cl_approving_unit` WHERE `cl_div_id`='$divIDHO' ORDER BY `cl_order` ASC"); while($hoRow=mysql_fetch_array($gtUNITTemplateHO)){ $unitIDHO = $hoRow['id']; echo "<table stsyle='width:100%;border:1px solid gray;border-collapse: separate'>"; ?><tr onclick="javascript:showSelectedUnitID(this);"><?php echo "<td style='text-align:right;border:0px solid gray;width:30px;padding:0px;padding-left:30px;border-bottom:1px solid gray;font-family:Calibri;font-size:12px;color:black;border-right:0px solid gray'>".$unitIDHO ."</td>"; echo "<td style='border:0px solid gray;width:250px;padding:0px;padding-left:0px;border-bottom:1px solid gray;font-family:Calibri;font-size:12px;color:black;border-right:1px solid gray'>- " .strtoupper($hoRow['cl_unit_name'])."</td>"; echo "<td style='text-align:center;width:100px;padding:0px;border:0px;border-bottom:1px solid gray;border-right:1px solid gray'>"; $oldSLAa = mysql_result(mysql_query("SELECT `cl_sla_a` FROM `cl_approving_officers` WHERE `cl_div_id`='$divIDHO' AND `cl_unit_id`='$unitIDHO' AND `cl_level`='$rank' AND `cl_comp_id`='$compID' AND `cl_status`=1"),0); echo $oldSLAa. " Days"; echo"</td>"; echo "<td style='text-align:left;width:253px;padding:0px;border:0px;border-bottom:1px solid gray;border-right:1px solid gray;padding:2px'>"; echo "<select name='HoApprovingPri[]' class='dropHOa' id='". $divIDHO."' style='margin:0px;padding:2px''>"; $oldOfficerH = mysql_result(mysql_query("SELECT `cl_emp_id_a` FROM `cl_approving_officers` WHERE `cl_div_id`='$divIDHO' AND `cl_unit_id`='$unitIDHO' AND `cl_template_id`='$selectedTemplate' AND `cl_comp_id`='$compID' AND `cl_status`=1"),0); if($oldOfficerH == '0'){ $oldApproverA ="NA"; } if($oldOfficerH == ''){ $oldApproverA =""; } if($oldOfficerH > 0){ $getFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$oldOfficerH'"),0); $getLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$oldOfficerH'"),0); $getPosition = mysql_result(mysql_query("SELECT `u_position` FROM `vts_users` WHERE `u_id`='$oldOfficerH'"),0); $oldApproverA = $getLName.", ".$getFName." - ".$getPosition; } echo "<option value=''>".strToUpper($oldApproverA)."</option>"; $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 AND `u_status` = 1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($hoRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$hoRow['u_id']."'>".strToUpper($hoRow['u_lname']).", ".strToUpper($hoRow['u_fname'])." - ".strToUpper($hoRow['u_position'])."</option>"; } echo "</select> </td>"; echo "<td style='text-align:center;width:80px;border:0px;padding:0px;border-bottom:1px solid gray;border-right:1px solid gray;padding:2px'>"; $oldSLAb = mysql_result(mysql_query("SELECT `cl_sla_b` FROM `cl_approving_officers` WHERE `cl_div_id`='$divIDHO' AND `cl_unit_id`='$unitIDHO' AND `cl_level`='$rank' AND `cl_comp_id`='$compID' AND `cl_status`=1"),0); echo $oldSLAb. " Days"; echo"</td>"; echo "<td style='padding:0px;text-align:left;width:253px;border:0px;border-bottom:1px solid gray;border-right:1px solid gray'>"; echo "<select name='HoApprovingSec[]' class='dropHOb' id='". $divIDHO."' style='margin:0px;padding:2px''>"; $oldOfficerB = mysql_result(mysql_query("SELECT `cl_emp_id_b` FROM `cl_approving_officers` WHERE `cl_div_id`='$divIDHO' AND `cl_unit_id`='$unitIDHO' AND `cl_template_id`='$selectedTemplate' AND `cl_comp_id`='$compID' AND `cl_status`=1"),0); if($oldOfficerB == '0'){ $oldApproverB ="NA"; } if($oldOfficerB == ''){ $oldApproverB =""; } if($oldOfficerB > 0){ $getFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$oldOfficerB'"),0); $getLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$oldOfficerB'"),0); $getPosition = mysql_result(mysql_query("SELECT `u_position` FROM `vts_users` WHERE `u_id`='$oldOfficerB'"),0); $oldApproverB = $getLName.", ".$getFName." - ".$getPosition; } echo "<option value=''>".strToUpper($oldApproverB)."</option>"; $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 AND `u_status` = 1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($soRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$soRow['u_id']."'>".strToUpper($soRow['u_lname']).", ".strToUpper($soRow['u_fname'])." - ".strToUpper($soRow['u_position'])."</option>"; } echo "</select> </td>"; echo "</tr>"; echo "</table>"; } echo"</td>"; echo "</tr>"; } echo "</table>"; echo "</td> </tr> </table><br><br><br><br>"; exit(); } ?>

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