invisio v2.0

<?php
	include("innerpageheader.php");
	include("config.php");
	session_start();
	$empids = $_SESSION['empids'];
	
?>
<section>
			<div class="content listing-content">
				<div class="in-content-wrapper">
					<div class="row no-gutters">

<div class="col">
							<div class="heading-messages">
								<h3>View Thing to do</h3>
							</div>
						</div>
						<div class="col-md-4">
							<div class="breadcrumb">
								<div class="breadcrumb-item"><i class="fas fa-angle-right"></i><a href="#">Listing</a>
								</div>
								<div class="breadcrumb-item active"><i class="fas fa-angle-right"></i>All
								</div>
							</div>
						</div>
					</div>

<div class="box">
						<div class="row no-gutters">
							<div class="col-auto me-auto text-start pe-0">
								<div class="add-new">
									<a href="add_thingstodo.php" class="btn btn-secondary btn-icon-split" >Add Things To Do <i class="fas fa-plus"></i></a>
								</div>
							</div>
							<div class="col text-end">
								<div class="tools-btns">
									<a href="#"><i class="fas fa-print" data-bs-toggle="tooltip" data-html="true" title="Print"></i></a>
									<a href="#"><i class="fas fa-file-pdf" data-bs-toggle="tooltip" data-html="true" title="Pdf"></i></a>
									<a href="#"><i class="fas fa-file-excel" data-bs-toggle="tooltip" data-html="true"
											title="Excel"></i></a>
								</div>
							</div>

</div>
						<div class="row no-gutters">
							<div class="col-12 table-responsive">
                                <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                                    <thead>
    	<tr style="border:none; background-color:#707070; color:#fff;">
            <th >Task Date</th>
            <th>Task By</th>
            <th>To Be Handle By</th>
            <th >Task Description</th>
            <th> Action Taken Description</th>
            <th >Action Taken</th>
            <th >Delete</th>
        </tr>
        </thead>
          <tbody>
        <?php
			$con = mysql_connect("50.62.209.50:3306","iseecrm","iseecrm123!@#");
              //$con = mysql_connect("localhost","root","");
          
              if (!$con)
                {
                  die('Could not connect: ' . mysql_error());
                }
              mysql_select_db("iseecrm", $con);
			  if($empids == 'admin')
			  {
				 $result = mysql_query("SELECT * FROM task_reminders  ORDER BY taskdate "); 
			  }
			  else
			  {
				$result = mysql_query("SELECT * FROM task_reminders WHERE (taskby = '$empids' OR handled = '$empids') ORDER BY taskdate ");
			  }
			while($row = mysql_fetch_array($result))
			{
				$id = $row['id'];
				$subject = $row['tasksubj'];
				$taskdate = $row['taskdate'];
				$tasktime = $row['tasktime'];
				$taskdetails = $row['taskdetails'];
				$upremarks = $row['upremarks'];
				$taskby = $row['taskby'];
				$result1 = mysql_query("SELECT * FROM employees WHERE empid = '$taskby' ORDER BY empname");
              
              	while($row1 = mysql_fetch_array($result1))
                {
                      $taskname = strtoupper($row1['empname']);
                }
				$handled = $row['handled'];
				$result2 = mysql_query("SELECT * FROM employees WHERE empid = '$handled' ORDER BY empname"); 
              
              	while($row2 = mysql_fetch_array($result2))
                {
                      $handledname = strtoupper($row2['empname']);
                }
				
				$taskstatus = $row['taskstatus'];
				
				$updated = $row['taskupdatedtime'];
				
				
				$tdate = date('d-m-Y', strtotime($taskdate));
				echo "<tr>";
				echo "<td>$tdate</td>";
				echo "<td>$taskname</td>";
				echo "<td>$handledname</td>";
				echo "<td>$taskdetails</td>";
				echo "<td>$upremarks</td>";
				if($taskstatus == 'Resolved')
				{
					echo "<td>Action Taken <br> $updated</td>";
				}
				else
				{
					echo "<td><a href='update_thingstodostatus.php?task=$id'>$taskstatus</td>";
				}
				/*echo "<td><a href='edit_reminders.php?task=$id' style='background-color:#47A3CF; border-color:#47A3CF;' class='btn btn-primary btn-circle' ><i  class='fas fa-edit'></i></a></td>";*/
				
		?>
        		<td><a onclick="return add('<?php echo $id?>')" style='background-color:red; border-color:red;' class='btn btn-primary btn-circle' ><i  class='fas fa-trash'></i>
                </a></td>
        <?php
				echo "</tr>";
			}
		?>
    </table>
     <script type="text/javascript"> 
	function add(a)
	{
		if(confirm('Are You Sure to Delete'))
		{
			window.location.href = "delete_reminders.php?taskid="+a;
		}
		else
		{
			return false;
		}
	}
</script>
							</div>
						</div>
					</div>
				</div>
			</div>
		</section>

</div>

<?php
	include('footer.php');
?>

<script src="js/jquery-3.3.1.min.js"></script>
	<script src="js/popper.min.js"></script>
	<script src="js/bootstrap-5.3.2.min.js"></script>
	<script src="vendors/datatables/datatables.min.js"></script>
	<script src="js/customscriptfile.js"></script>

</html>