File manager

File manager - Edit - /home/autoph/public_html/portal/includes/menu/masterfile/hrd_active_modules.php

Back
<?php if(isset($_GET['delID'])){ $id=$_GET['delID']; mysql_query("DELETE FROM `pod_training_contents` WHERE `id`='$id'"); } if(isset($_GET['live'])){ $id=$_GET['live']; //echo "EX ID:".$id; mysql_query("UPDATE `hrd_updates` SET `status`='1' WHERE `id`='$id'"); $qqSend = mysql_query("SELECT * FROM `c_users` WHERE `email`!='' AND `status`='1'"); $total = mysql_num_rows($qqSend); while($row = mysql_fetch_array($qqSend)){ $countRow ++; $mailRow = $row['email']; //=================== $message = "HR UPDATES: New Update from Human Resource Department is now available for viewing. Please login to your portal at http://www.autohub.ph/portal To further improve our services, please don't forget to rate us and send us your comments and suggest about this article. Thank you. The Human Resource"; mail($mailRow, 'HR UPDATES', $message, 'From: support@autohubgroup.com'); //=================== if($total == $countRow){ echo "<div id='dialog' title='HR UPDATES' style='background:#FAFAFA;z-index:20000'> <p>E-mail notification has been sent to ".$countRow." employees.</p> <center><a href='main_new.php?menu&view=104&sid=HRD&sview=102&tab=4&#id-0'><input type='button' class='submit' name='Exit' value='Close'></a></center> </div>"; } } } if(isset($_GET['launch'])){ $tid=$_GET['tid']; mysql_query("UPDATE `pod_training_list` SET `status`='1' WHERE `id`='$tid'"); } //================================= //UPLOAD COVER PICTURE FOR MODULE if(isset($_POST['UploadCoverPic'])){ echo "<div style='left:220px;top:60px;position:absolute;width:500px;height:160px;border:1px solid orange;background:white;z-index:5;border-radius:3px;z-index:10'>"; include 'bg_file_update.php'; echo "</div>"; } //UPLOAD TRAINING COVER PICTURE FOR MODULE if(isset($_POST['UploadTrainingCoverPic'])){ echo "<div style='left:220px;top:60px;position:absolute;width:500px;height:160px;border:1px solid orange;background:white;z-index:5;border-radius:3px;z-index:10'>"; include 'bg_file_update_training.php'; echo "</div>"; } //================================= //================================= //UPLOAD TRAINING CONTENT if(isset($_GET['tid'])){ $tid = $_GET['tid']; $title = mysql_result(mysql_query("SELECT `title` FROM `hrd_updates` WHERE `id`='$tid'"),0); $description = mysql_result(mysql_query("SELECT `description` FROM `hrd_updates` WHERE `id`='$tid'"),0); $link ='myportal.php?window=4'; $link = mysql_real_escape_string($link); echo "<div style='left:220px;top:60px;position:absolute;width:800px;height:220px;border:1px solid orange;background:white;z-index:5;border-radius:3px;z-index:10'>"; echo "<h3 class='titleBlue' style='width:99.3%;font-family:Calibri Light;font-size:16px;font-weight:normal;padding-left:5px;padding-top:2px;'>ATTACH FILE</h3>"; echo "<div class='lightGradient' style='top:2px;left:97%;position:absolute;z-index:3'> <a href='main_new.php?menu&view=104&sid=HRD&sview=102&tab=4&#id-0' style='display:block;width:17px;height:17px;border:1px solid lightgray;border-radius:2px;font-size:14px;color:red'> <center>X</center> </a> </div>"; //FILE UPLOAD REQUEST FOR THE TRAINING CONTENT OR MATERIALS //SAVING TRAINING MATERIALS if(isset($_FILES['file'])){ $ext = explode('.', $_FILES['file']['name']); $allow_ext = array('pdf','PDF','JPG','jpg','JPEG','jpeg','PNG','png'); $target_path = basename( $_FILES['file']['name']); $target_path = mysql_real_escape_string($target_path); $filename = $_FILES['file']['name']; $fext = pathinfo($filename, PATHINFO_EXTENSION); $mID = $_GET['m']; $tID = $_GET['tid']; $fType = 'Local'; if(!in_array($fext,$allow_ext)){ $SysMessage='Invalid file extension. Please select image format only...'; $ror=true; }else { if(move_uploaded_file($_FILES['file']['tmp_name'], 'hrd_files/'.$tID.'---'.$target_path)) { $myFile = $tID."---" . $filename; $fullFile=mysql_real_escape_string($myFile); //duplicate image is not allowed mysql_query("UPDATE `hrd_updates` SET `image_path`='$fullFile' WHERE `id`='$tID'"); $SysMessage= "Image upload complete... " . $fullFile; $sql="INSERT INTO `aglobal_updates` (`id`,`title`,`description`,`dept_id`,`link`,`date`,`time`,`created_by`) VALUES('','$title','$description','$deptID','$link','$toDate','$currentTime','$user')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); } }else{ $SysMessage= "There was an error uploading the file, please try again!" . $_FILES['file']['error']; } } } //======================================================================================== ?> <table style='width:100%;border:1px solid white'> <tr style='background:white;border:1px solid white'> <td valign='top' style='background:white;border:1px solid white;border-right:1px solid white;width:90%'> <BR> <form action = "" method="POST" enctype="multipart/form-data"> <div align='left' class="form-group" style='padding:10px;border:1px solid lightgray'> <p style='text-align:bottom;line-height:80%;font-family:Calibri;font-size:12px;padding-left:0px;color:black;font-weight:normal'> Attach PDF format only:<br> <br> <input type="file" name="file" id="file" style="background-color:#fff;width:100%"> <br><br><input type='submit' name='SaveLocalRecord' value='Upload File' style='width:100px;margin:2px;height:25px;border:1px solid lightgray'> <a href='main_new.php?menu&view=104&sid=HRD&sview=102&tab=4&#id-0'><input type='button' name='New' value='Add New' style='width:80px;margin:2px;border:1px solid lightgray'></a> <?php echo $SysMessage;?> </p> </div> </form> </td> </tr> </table> <?php echo "</div>"; } //ADD NEW TRAINING FROM SELECTED MODULE if(isset($_GET['add'])){ switch($_GET['add']){ case 'add'://NEW ENTRY COMPANY OR DEALERS echo "<div style='left:200px;top:50px;position:absolute;width:700px;height:400px;border:1px solid orange;background:white;z-index:5;border-radius:3px'>"; echo "<h3 class='titleBlue' style='width:99.3%;font-family:Calibri Light;font-size:16px;font-weight:normal;padding-left:5px;padding-top:2px;'>ADD NEW ENTRY</h3>"; echo "<div class='lightGradient' style='top:2px;left:97%;position:absolute;z-index:3'> <a href='main_new.php?menu&view=104&sid=HRD&sview=102&tab=4&#id-0' style='display:block;width:17px;height:17px;border:1px solid lightgray;border-radius:2px;font-size:14px;color:red'> <center>X</center> </a> </div>"; $getPage = $_GET['page']; switch($_GET['getPage']){ case '': echo "<form action='' method='POST'><div align='left' class='form-group' style='padding:20px'> <p style='text-align:bottom;line-height:80%;font-family:Calibri Light;font-size:16px;padding-left:0px;color:black;font-weight:bold'> <ABBR title='COURSE CODE'> <input REQUIRED class='textbox' type='text' placeholder='COURSE CODE' name='corCode' maxlength='10' style='font-size:16px;background:white;width:20%;min-width:220px;margin-top:5px'></ABBR> </p> <br> <p style='text-align:bottom;line-height:80%;font-family:Calibri Light;font-size:16px;padding-left:0px;color:black;font-weight:bold'> <ABBR title='COURSE TITLE'> <input REQUIRED class='textbox' type='text' placeholder='COURSE TITLE' name='corTitle' maxlength='50' style='font-size:16px;background:white;width:100%;min-width:220px;margin-top:5px'></ABBR> </p> <br> <p style='text-align:bottom;line-height:80%;font-family:Calibri Light;font-size:16px;padding-left:0px;color:black;font-weight:bold'> <ABBR title='COURSE DESCRIPTION'> <textarea REQUIRED class='textbox' placeholder='COURSE DESCRIPTION' name='corDesc' style='font-size:16px;background:white;width:100%;min-width:220px;margin-top:5px'></textarea></ABBR> <br><br> <select required name='trnGroup' class='textbox' style='font-size:16px;background:white;width:20%;min-width:220px;margin-top:5px'> <option>OPEN</option> <option>INVITATIONAL</option> </select> </p> <br> </div>"; echo "<div align='right' class='form-group' style='padding:10px'> <input type='submit' class='submit' name='SaveNewTrainingRecord' value='Save Record'> <input type='reset' class='submit' name='Clear' value='Clear'> <a href='main_new.php?view=104&sid=POD&sview=101&tab=3&m=".$_GET['mid']."'><input type='button' class='submit' name='Exit' value='Exit'></a> </div>"; break; } echo "</form>"; echo "</div>"; break; } } //LOAD TRAINING LIST FROM SELECTED TRAINING MODULE if(isset($_GET['m'])){ $mID = $_GET['m']; $title=mysql_result(mysql_query("SELECT `title` FROM `pod_training_modulle` WHERE `id`='$mID'"),0); echo "<div style='left:200px;top:50px;position:absolute;width:900px;height:500px;border:1px solid red;background:white;z-index:5;border-radius:3px'>"; echo "<h3 class='titleBlue' style='width:99.4%;font-family:Calibri Light;font-size:16px;font-weight:normal;padding-left:5px;padding-top:2px;'>ACTIVE TRAINING - ".$title."</h3>"; echo "<div class='lightGradient' style='top:2px;left:97.5%;position:absolute;z-index:3'> <a href='main_new.php?view=104&sid=POD&sview=101&tab=3' style='display:block;width:17px;height:17px;border:1px solid lightgray;border-radius:2px;font-size:14px;color:red'> <center>X</center> </a> </div>"; ?> <div class='lightGradientA' style='width:99.2%;height:40px;border:1px solid lightgray;padding-left:5px;padding-top:3px'> <a href='main_new.php?view=104&sid=POD&sview=101&tab=3&mid=<?php echo $_GET['m'];?>&add=add'><ABBR title='Add New Record'><img src='./images/new.png' onmouseover="this.src='images/new_.png';" onmouseout="this.src='images/new.png';" /></ABBR></a> <a href='main_new.php?view=104&sid=POD&sview=101&tab=3&mid=<?php echo $_GET['m'];?>&add=edit'><ABBR title='Advance Search Module'><img src='./images/filter_a.png' onmouseover="this.src='images/filter_b.png';" onmouseout="this.src='images/filter_a.png';" /></ABBR></a> <div class='lightGradientA' style='margin-top:5px;position:relative;height:30px;width:500px;border:1px solid #f2f2f;top:-40px;left:100px;padding-top:4px;border-left:1px solid lightgray;padding-left:30px'> <form action='' method='GET'> <input type='hidden' name='view' value='104'> <input type='hidden' name='sview' value='101'> <input type='hidden' name='tab' value='3'> <input type='hidden' name='sid' value='POD'> <input type='hidden' name='m' value='<?php echo $_GET['m'];?>'> Search : <input type='text' name='tSearch' value='' style='padding-left:10px;width:300px;border:1px solid gray;background:white;height:30px;border-radius:5px 0px 0px 5px'> <input type='submit' name='goTSearch' value='Search...' style='width:70px;border:1px solid gray;height:30px;border-radius:0px 5px 5px 0px'> </form> </div> </div> <?php $id=$_GET['m']; if(isset($_GET['tSearch'])){ $searchString=$_GET['tSearch']; $qq=mysql_query("SELECT * FROM `pod_training_list` WHERE `title` LIKE '%$searchString%' \|\| `title` LIKE '%$searchString%' ORDER by `title` ASC "); }else{ $qq=mysql_query("SELECT * FROM `pod_training_list` WHERE `module_id`='$id' ORDER by `title` ASC "); } echo "<div STYLE='height: 425px; width: 99.9%; font-size: 12px; overflow: auto;border:0px solid red'>"; while($row = mysql_fetch_array($qq)){ echo "<ABBR title='".$row['title']."'> <div style='margin:15px;float:left;width:15%;height:250px;border:1px solid lightgray;border-radius:2px;padding:1px;box-shadow:5px 5px 8px lightblue;background:#1C1C1C'>"; echo "<table style='width:100%;'>"; echo "<tr>"; if(empty($row['cover_pic'])){ echo "<td style='height:150px;background:white;border:1px solid lightgray' align='center' valign='middle'>"; ?> <form action = "" method="POST" enctype="multipart/form-data"> <input type='hidden' name='tid' value='<?php echo $row['id'];?>'> <table style='width:100%;border:1px solid white'> <tr style='background:white;border:1px solid white'> <td valign='top' style='background:white;border:1px solid white;border-right:1px solid white;width:100%'> <div align='left' class="form-group" style='padding:10px;border:1px solid lightgray'> <p style='text-align:bottom;line-height:80%;font-family:Calibri;font-size:14px;padding-left:0px;color:black;font-weight:normal'> <input type="file" name="file" id="file" style="background-color:#fff;width:100%" required> <br> </p> </div> <div align='center' class="form-group" style='padding:2px'> <br><input type='submit' name='UploadTrainingCoverPic' value='Upload File' style='width:50%;margin:2px;height:20px;width:70px;border:1px solid gray;border-radius:5px' class='titleBlue'><br> <?php echo $SysMessage;?> </div> </td> </tr> </table> </form> <?php echo "</td>"; }else{ echo "<td style='height:150;background-image:url(\"moduleCover/training/".$row['cover_pic']."\");background-repeat:no-repeat;background-position:auto;background-size:100%;border:1px solid white'></td>"; } echo "</tr>"; echo "<tr>"; echo "<td valign='bottom' align='center' style='text-align:bottom;padding:2px;height:90px;font-family:Calibri Light;font-size:10px;color:yellow;border:1px solid #1C1C1C;background:#000;font-weight:normal' > <a href='main_new.php?view=104&sid=POD&sview=101&tab=3&m=".$row['module_id']."&tid=".$row['id']."&content=true' style='font-size:11px;color:white'>".$row['title']."</a><br>".$row['grouping']; $stat = $row['status']; if($stat==='1'){ echo "<br><input type='button' name='status' value='Available' style='margin-top:7px;padding:2px;padding-left:5px;padding-right:5px;border:1px solid lightgray;border-radius:3px' class='grnGradient'>"; }else { echo "<br><a href='main_new.php?view=104&sid=POD&sview=101&tab=3&m=".$_GET['m']."&launch&tid=".$row['id']."'><input type='button' name='status' value=' Activate ' style='margin-top:7px;padding:2px;padding-left:5px;padding-right:5px;border:1px solid lightgray;border-radius:3px' class='titlePink'></a>"; } echo "</td>"; echo "</tr>"; echo "</table>"; echo "</div> </ABBR>"; } echo "</div>"; echo "</div>"; } echo "<h3 class='titleBlue' style='width:99.6%;font-family:Calibri Light;font-size:16px;font-weight:normal;padding-left:5px;padding-top:2px;'>HUMAN RESOURCE UPDATES</h3>"; echo "<div style='top:85px;left:97.8%;position:absolute;z-index:3'> <a href='main_new.php?menu&view=104&sid=HRD&sview=102&tab=4&#id-0' style='display:block;width:17px;height:17px;border:1px solid gray;background:lightgray;border-radius:2px'> <center>X</center> </a> </div>"; echo "<div style='width:100%;border:0px solid red;background:#f4f4f4'>"; ?> <div class='lightBlue' style='width:98.5%;height:40px;border:1px solid lightgray;padding-left:20px;padding-top:3px'> <a href='main_new.php?menu&view=104&sid=HRD&sview=102&action=new&tab=4&#id-0'><ABBR title='Add New Record'><img src='./images/new.png' onmouseover="this.src='images/new_.png';" onmouseout="this.src='images/new.png';" /></ABBR></a> <a href='main_new.php?menu&view=104&sid=HRD&sview=102&action=&tab=4&#id-0'><ABBR title='Advance Search Module'><img src='./images/filter_a.png' onmouseover="this.src='images/filter_b.png';" onmouseout="this.src='images/filter_a.png';" /></ABBR></a> <div class='lightGradientA' style='margin-top:5px;position:relative;height:30px;width:500px;border:1px solid #f2f2f;top:-40px;left:100px;padding-top:4px;border-left:1px solid lightgray;padding-left:30px'> <form action='' method='GET'> <input type='hidden' name='view' value='104'> <input type='hidden' name='sview' value='102'> <input type='hidden' name='tab' value='4'> <input type='hidden' name='sid' value='HRD'> Search : <input type='text' name='searchBox' value='' style='padding-left:10px;width:300px;border:1px solid gray;background:white;height:30px;border-radius:5px 0px 0px 5px'> <input type='submit' name='goSearch' value='Search' style='width:70px;border:1px solid gray;height:30px;border-radius:0px 5px 5px 0px'> </form> </div> <!--<div align='left' style='top:137px;left:53%;height:30px;width:200px;float:left;position:absolute;border:0px solid red'> <ABBR title='Edit Record'><img src='./images/advancesearch_a.png' onmouseover="this.src='images/advancesearch_b.png';" onmouseout="this.src='images/advancesearch_a.png';" /></ABBR></a> </div>--> </div> <div class='contentTable' style='height:820px;'> <?php if(isset($_GET['searchBox'])){ $searchString=$_GET['searchBox']; $qq=mysql_query("SELECT * FROM `hrd_updates` WHERE `description` LIKE '%$searchString%' \|\| `title` LIKE '%$searchString%' ORDER by `title` ASC "); }else{ $qq=mysql_query("SELECT * FROM `hrd_updates` WHERE `status`!='9' ORDER by `title` ASC "); } echo "<div STYLE='height:100%;width: 100%; font-size: 12px; overflow: auto;background:white;border:0px solid red'>"; echo "<table style='border-collapse:collapse;width:100%'>"; echo "<th style='width:5%;height:25px;padding:3px;border:1px solid lightgray' class='lightGradient'>NO</th>"; echo "<th style='width:15%;height:25px;padding:3px;border:1px solid lightgray' class='lightGradient'>TITLE</th>"; echo "<th style='width:50%;height:25px;padding:3px;border:1px solid lightgray' class='lightGradient'>DESCRIPTION</th>"; echo "<th style='width:7%;height:25px;padding:3px;border:1px solid lightgray' class='lightGradient'>DATE</th>"; echo "<th style='width:20px;height:25px;padding:3px;border:1px solid lightgray' class='lightGradient'>VIEWS</th>"; echo "<th style='width:40px;height:25px;padding:3px;border:1px solid lightgray' class='lightGradient'>RATINGS</th>"; echo "<th style='width:5%;height:25px;padding:3px;border:1px solid lightgray' class='lightGradient'>STATUS</th>"; echo "<th style='width:5%;height:25px;padding:3px;border:1px solid lightgray' class='lightGradient'></th>"; while($row = mysql_fetch_array($qq)){ $count ++; echo "<tr>"; echo "<td align='center' style='font-family:Calibri Light;font-size:12px;border:1px solid lightgray'>".$count."</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;border:1px solid lightgray'>".$row['title']."</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;border:1px solid lightgray'><ABBR title='". $row['description']."' style='border:0px solid white;border-bottom:none !important;cursor: default !important;text-decoration:none;'>".substr($row['description'],0,95)." <a href='main_new.php?menu&view=104&sid=HRD&sview=102&tab=4&more=".$row['id']."' style='margin-left:10px;font-weight:normal;color:#819FF7'>More...</a></ABBR></td>"; echo "<td style='font-family:Calibri Light;font-size:12px;border:1px solid lightgray'>".$row['date']."</td>"; echo "<td align='center' style='font-family:Calibri Light;font-size:12px;border:1px solid lightgray'>".$row['views']."</td>"; echo "<td align='center' style='font-family:Calibri Light;font-size:12px;border:1px solid lightgray'>".$row['like']." <img src='images/icon/tup.png'></img> \| ".$row['dislike']." <img src='images/icon/tdown.png'></img></td>"; echo "<td align='center' style='font-family:Calibri Light;font-size:12px;border:1px solid lightgray'>"; if($row['status']==='0'){ echo "<a href='main_new.php?menu&live=".$row['id']."&view=104&sid=HRD&sview=102&tab=4&#id-0'>Activate</a>"; }else { echo "<b style='font-size:12px;font-weight:bold;color:green'>Online</b>"; } echo "</td>"; echo "<td align='center' style='font-family:Calibri Light;font-size:12px;border:1px solid lightgray'>"; if($row['image_path']===''){ echo "<a href='main_new.php?menu&tid=".$row['id']."&view=104&sid=HRD&sview=102&tab=4&#id-0' style='font-family:Calibri Light;font-weight:normal;color:black'>Attach...</a>"; }else { echo "<a href='hrd_files/".$row['image_path']."' style='font-family:Calibri Light;font-weight:normal;color:black' target='_Blank'><img src='images/icon/pdf.png' width='20px'></img> </a>"; } echo "</td>"; echo "</tr>"; } echo "</table>"; echo "</div>"; ?> </div> <?php echo "</div>"; ?>

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