File manager

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

Back
<?php $compCode = $user_data['company_assignment']; //DELETE RECORDS if(isset($_GET['delete'])){ if(!empty($_GET['delete'])){ $id=$_GET['delete']; mysql_query("DELETE FROM `pod_training_schedule` WHERE `id`='$id'"); } } $add = $_GET['add']; switch($add){ case 'ex'://NEW ENTRY COMPANY OR DEALERS if($_GET['view']==='104'){ //ADD NEW COMPANY echo "<div style='left:200px;top:50px;position:absolute;width:600px;height:300px;border:1px solid orange;background:white;z-index:5;border-radius:3px'>"; echo "<h3 class='titleBlue' style='width:99%;font-family:Calibri Light;font-size:16px;font-weight:normal;padding-left:5px;padding-top:2px;'>CREATE NEW SCHEDULE</h3>"; echo "<div class='lightGradient' style='top:2px;left:96%;position:absolute;z-index:3'> <a href='main_new.php?view=104&sid=SCH&sview=101&tab=3&#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>"; include 'includes/exam/pod_schedule_list.php'; echo "</div>"; } break; } echo "<h3 style='padding-left:5px;padding-top:2px;font-family:Calibri Light;font-weight:normal' class='titleBlue'>TRAINING SCHEDULE SUMMARY LIST</h3>"; echo "<div style='top:112px;left:98%;position:absolute;z-index:3'> <a href='main_new.php?view=104&sid=SCH&sview=101&tab=3&#id-0' style='display:block;width:17px;height:17px;border:1px solid gray;background:white;border-radius:2px'> <center>X</center> </a> </div>"; echo "<div style='width:100%;min-height:880px;border:1px solid gray;background:#fff'>"; ?> <div style='width:98.4%;height:40px;border:1px solid lightgray;background:#f2f2f2;padding-left:20px;padding-top:3px'> <a href='main_new.php?view=104&add=ex&sid=SCH&sview=101&tab=3&#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?view=104&sview=101&sid=SCH&action=edit&tab=0#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 style='position:relative;height:30px;width:500px;border:1px solid #f2f2f2;background:#f2f2f2;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='SCH'> Search : <input type='text' required 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> <?php if(isset($_GET['searchBox'])){ $searchString=$_GET['searchBox']; $qq=mysql_query("SELECT * FROM `pod_training_schedule` WHERE '$searchString' >= `start_date` AND '$searchString' <= `end_date` ORDER by `start_date` ASC "); }else{ $qq=mysql_query("SELECT * FROM `pod_training_schedule` WHERE `status`='1' AND `end_date` >= '$toDate' ORDER by `training_id` ASC "); } echo "<div STYLE='height: 100%; width: 99.9%; font-size: 12px; overflow: auto;'> <table style='width:100%; height:100% border:1px solid gray; border-collapse:collapse;'>"; echo "<tr> <th class='Gradient' align='left' style='width:2%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>NO.</th> <th class='Gradient' align='left' style='width:2%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>EDIT</th> <th class='Gradient' align='left' style='width:30%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>TRAINING TITLE</th> <th class='Gradient' align='left' style='width:10%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>START DATE</th> <th class='Gradient' align='left' style='width:10%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>END DATE</th> <th class='Gradient' align='left' style='width:2%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>MAX</th> <th class='Gradient' align='left' style='width:2%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>INVITED</th> <th class='Gradient' align='left' style='width:2%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>ENROLLED EMP.</th> <th class='Gradient' align='left' style='width:5%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>STATUS</th> <th class='Gradient' align='left' style='width:5%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>DATE CREATED</th> <th class='Gradient' align='left' style='width:5%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>CREATED BY</th> <th class='Gradient' align='left' style='width:2%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>DEL</th>"; echo "</tr>"; while($row = mysql_fetch_array($qq)){ $count = $count + 1; echo "<tr>"; echo "<td class='tableList'>" . $count . "</td>"; echo "<td class='tableList'> <a href='main_new.php?type=".$row['type']."&view=104&action=emp&sid=SCH&sview=101&tab=3&&xid=".$row['id']."&trnID=".$row['training_id']."&id=".$row['id']."'> <img src='images/rica/edit_a.png'></img></a> </td>"; echo "<td class='tableList'>"; $trID = $row['training_id']; $trainingTitle = mysql_result(mysql_query("SELECT `title` FROM `pod_training_list` WHERE `id`='$trID'"),0); echo $trainingTitle; echo "</td>"; echo "<td class='tableList'>" . STRTOUPPER($row['start_date']) . "</td>"; echo "<td class='tableList'>" . STRTOUPPER($row['end_date']) . "</td>"; echo "<td class='tableList'>" . STRTOUPPER($row['participants']) . "</td>"; echo "<td class='tableList'>"; $countInvites=mysql_result(mysql_query("SELECT COUNT('id') FROM `pod_training_invites` WHERE `training_id`='$trID'"),0); echo $countInvites; echo"</td>"; echo "<td class='tableList'>"; $countEntrolled=mysql_result(mysql_query("SELECT COUNT('id') FROM `pod_training_enrollees` WHERE `training_id`='$trID'"),0); echo $countEntrolled; echo"</td>"; echo "<td class='tableList'>"; $status=$row['status']; if($status==1){ echo "OPEN"; }else{ echo "CLOSED"; } echo "</td>"; echo "<td class='tableList'>" . STRTOUPPER($row['date']) . "</td>"; echo "<td class='tableList'>" . STRTOUPPER($row['created_by']) . "</td>"; echo "<td class='tableList' > <center><a href='main_new.php?type=".$row['type']."&view=104&add=exad&sid=SCH&sview=101&tab=3&&xid=".$row['id']."&trnID=".$row['training_id']."&delete=".$row['id']."' style='font-size:14px;font-weight:bold;color:red'> X</a></center> </td>"; echo "</tr>"; } echo "</table>"; ?> <?php echo "</div>"; ?>

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