Download Task Management System Free Using PHP

Projects Inventory

3 weeks ago

Download Code – PHP Project – Employee management system

PHP Task Management System

A PHP task management system is a powerful tool designed to help businesses streamline their project workflows. These systems are built using PHP, a widely-used server-side scripting language that is known for its flexibility and ease of use. PHP-based task management systems are ideal for managing projects, tracking tasks, and improving collaboration within teams.

Features of PHP Task Management Systems

Improved Organization: A PHP project management system centralizes all project-related information, making it easier for teams to access and update data as needed. This leads to better organization and efficiency.

Time and Cost Savings: By automating and streamlining various project management tasks, businesses can save time and reduce costs, enhancing overall productivity.
Task Creation and Tracking: PHP task management systems allow users to create, assign, and track tasks effectively, ensuring that projects stay on track and deadlines are met.
File Sharing: A good PHP project management system should provide seamless file sharing and version control, allowing team members to collaborate on documents easily.
Reporting and Analytics: With built-in reporting and analytics, PHP systems offer valuable insights into project progress, team performance, and potential bottlenecks.
Integration Capabilities: Many PHP task management systems are designed to integrate smoothly with other tools and software, such as employee management systems, improving overall workflow.

FAQs About PHP Project Management Systems

Q1. Are PHP project management systems easy to use?
- A1. Yes, most PHP project management systems are designed to be user-friendly, catering to both beginners and experienced users.
Q2. Can I customize a PHP project management system?
- A2. Absolutely! Many PHP project management systems offer extensive customization options to meet your business’s unique needs.
Q3. Can I migrate data from other systems to a PHP project management system?
- A3. Yes, most systems support data migration, making it easy to transfer information from other project management tools.
Q4. Are there any security concerns with PHP project management systems?
- A4. Like any software, there may be security risks, but reputable systems regularly upd ate to address vulnerabilities.
Q5. Can I access a PHP project management system on my mobile device?
- A5. Many systems offer mobile apps or responsive web interfaces, allowing you to access the system from anywhere.

Conclusion

PHP-based task and project management systems provide businesses with a robust solution to improve collaboration, increase efficiency, and keep projects on track. With features such as task tracking, file sharing, and reporting, these systems are an excellent choice for businesses of all sizes.

How to Run the PHP Employee Task Management System

Download the source code (zip file) for the Employee Task Management System project, which includes the SQL file.
Extract the zip file to get the project folder.
Copy the project folder (source code files) to the htdocs directory.
Open your browser and go to localhost/phpmyadmin. Create a new database (PHP version must be at least 8.0).
Import the SQL file from the database folder into the newly created database.
Check the source code files to ensure the database name matches your setup.
Open the admin panel and log in using the credentials provided in the “Credentials” notepad file.

task-info PHP

<?php

require 'authentication.php'; // admin authentication check 

// auth check
$user_id = $_SESSION['admin_id'];
$user_name = $_SESSION['name'];
$security_key = $_SESSION['security_key'];
if ($user_id == NULL || $security_key == NULL) {
    header('Location: index.php');
}

// check admin
$user_role = $_SESSION['user_role'];


if(isset($_GET['delete_task'])){
  $action_id = $_GET['task_id'];
  
  $sql = "DELETE FROM task_info WHERE task_id = :id";
  $sent_po = "task-info.php";
  $obj_admin->delete_data_by_this_method($sql,$action_id,$sent_po);
}

if(isset($_POST['add_task_post'])){
    $obj_admin->add_new_task($_POST);
}

$page_name="Task_Info";
include("include/sidebar.php");
// include('ems_header.php');


?>

<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/flatpickr/dist/flatpickr.min.css">

  <!-- Modal -->
  <div class="modal fade" id="myModal" role="dialog">
    <div class="modal-dialog add-category-modal">
    
      <!-- Modal content-->
      <div class="modal-content">
        <div class="modal-header">
          <button type="button" class="close" data-dismiss="modal">&times;</button>
          <h3 class="modal-title text-center">Assign New Task</h3>
        </div>
        <div class="modal-body">
              <form role="form" action="" method="post" autocomplete="off">
                <div class="row">
                  <div class="form-group col-md-6">
                    <label class="control-label">Task Title</label>
          
                      <input type="text" placeholder="Task Title" id="task_title" name="task_title" list="expense" class="form-control" id="default" required>
                 
                  </div>
                  <div class="form-group col-md-6">
                    <label class="control-label ">Task Description</label>
                    
                      <textarea name="task_description" id="task_description" placeholder="Text Deskcription" class="form-control" rows="5" cols="5"></textarea>
                  
                  </div>
                  <div class="form-group col-md-6">
                    <label class="control-label ">Start Time</label>
                    
                      <input type="text" name="t_start_time" id="t_start_time" class="form-control">
                    </div>
                 
                  <div class="form-group col-md-6">
                    <label class="control-label ">End Time</label>
                    
                      <input type="text" name="t_end_time" id="t_end_time" class="form-control">
                    
                  </div>
                  <div class="form-group col-md-6">
                    <label class="control-label ">Assign To</label>
                    
                      <?php 
                        $sql = "SELECT user_id, fullname FROM tbl_admin WHERE user_role = 2";
                        $info = $obj_admin->manage_all_info($sql);   
                      ?>
                      <select class="form-control" name="assign_to" id="aassign_to" required>
                        <option value="">Select Employee...</option>

                        <?php while($row = $info->fetch(PDO::FETCH_ASSOC)){ ?>
                        <option value="<?php echo $row['user_id']; ?>"><?php echo $row['fullname']; ?></option>
                        <?php } ?>
                      </select>
                    
                   
                  </div>
                  <div class="form-group col-md-6">
                  </div>
                  <div class="form-group col-md-12">
                    <div class="col-sm-offset-3 col-sm-3">
                      <button type="submit" name="add_task_post" class="btn btn-success-custom">Assign Task</button>
                    </div>
                    <div class="col-sm-3">
                      <button type="submit" class="btn btn-danger-custom" data-dismiss="modal">Cancel</button>
                    </div>
                  </div>
                </div>
              </form> 
         

        </div>
      </div>
    </div>
  </div>





    <div class="row">
      <div class="col-md-12">
        <div class="well well-custom">
          <div class="gap"></div>
          <div class="row">
            <div class="col-md-8">
              <div class="btn-group">
                <?php if($user_role == 1){ ?>
                <div class="btn-group">
                  <button class="btn btn-primary btn-menu" data-toggle="modal" data-target="#myModal">Assign New Task</button>
                </div>
              <?php } ?>

              </div>

            </div>

            
          </div>
          <center ><h3>Task Management Section</h3></center>
          <div class="gap"></div>

          <div class="gap"></div>

          <div class="table-responsive">
            <table class="table table-codensed  display" id="example" style="width:100%">
              <thead>
                <tr>
                  <th>#</th>
                  <th>Task Title</th>
                  <th>Assigned To</th>
                  <th>Start Time</th>
                  <th>End Time</th>
                  <th>Status</th>
                  <th>Action</th>
                </tr>
              </thead>
              <tbody>

              <?php 
                if($user_role == 1){
                  $sql = "SELECT a.*, b.fullname 
                        FROM task_info a
                        INNER JOIN tbl_admin b ON(a.t_user_id = b.user_id)
                        ORDER BY a.task_id DESC";
                }else{
                  $sql = "SELECT a.*, b.fullname 
                  FROM task_info a
                  INNER JOIN tbl_admin b ON(a.t_user_id = b.user_id)
                  WHERE a.t_user_id = $user_id
                  ORDER BY a.task_id DESC";
                } 
                
                  $info = $obj_admin->manage_all_info($sql);
                  $serial  = 1;
                  $num_row = $info->rowCount();
                  if($num_row==0){
                    echo '<tr><td colspan="7">No Data found</td></tr>';
                  }
                      while( $row = $info->fetch(PDO::FETCH_ASSOC) ){
              ?>
                <tr>
                  <td><?php echo $serial; $serial++; ?></td>
                  <td><?php echo $row['t_title']; ?></td>
                  <td><?php echo $row['fullname']; ?></td>
                  <td><?php echo $row['t_start_time']; ?></td>
                  <td><?php echo $row['t_end_time']; ?></td>
                  <td>
                    <?php  if($row['status'] == 1){
                        echo " <span class='label label-warning' ><i class=' glyphicon glyphicon-refresh'></i> In Progress</span>";
                    }elseif($row['status'] == 2){
                       echo " <span class='label label-success'><i class='glyphicon glyphicon-ok'></i> Completed </span>";
                    }else{
                      echo "<span class='label label-danger'><i class='glyphicon glyphicon-remove'></i> Incomplete </span>";
                    } ?>
                    
                  </td>
  
                 <td><a title="Update Task"  href="edit-task.php?task_id=<?php echo $row['task_id'];?>" class="btn btn-primary btn-sm"><span class="glyphicon glyphicon-edit"></span></a>&nbsp;&nbsp;
                  <a title="View" href="task-details.php?task_id=<?php echo $row['task_id']; ?>" class="btn btn-warning btn-sm"><span class="glyphicon glyphicon-folder-open"></span></a>&nbsp;&nbsp;
                  <?php if($user_role == 1){ ?>
                  <a class="btn btn-danger btn-sm" title="Delete" href="?delete_task=delete_task&task_id=<?php echo $row['task_id']; ?>" onclick=" return check_delete();"><span class="glyphicon glyphicon-trash"></span></a></td>
                <?php } ?>
                </tr>
                <?php } ?>
                
              </tbody>
            </table>
          </div>
        </div>
      </div>
    </div>


<?php

include("include/footer.php");



?>

<script src="https://cdn.jsdelivr.net/npm/flatpickr"></script>

<script type="text/javascript">
  flatpickr('#t_start_time', {
    enableTime: true
  });

  flatpickr('#t_end_time', {
    enableTime: true
  });

</script>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

<?php

require 'authentication.php'; // admin authentication check

// auth check

$user_id = $_SESSION['admin_id'];

$user_name = $_SESSION['name'];

$security_key = $_SESSION['security_key'];

if ($user_id == NULL || $security_key == NULL) {

header('Location: index.php');

}

// check admin

$user_role = $_SESSION['user_role'];

if(isset($_GET['delete_task'])){

$action_id = $_GET['task_id'];

$sql = "DELETE FROM task_info WHERE task_id = :id";

$sent_po = "task-info.php";

$obj_admin->delete_data_by_this_method($sql,$action_id,$sent_po);

}

if(isset($_POST['add_task_post'])){

$obj_admin->add_new_task($_POST);

}

$page_name="Task_Info";

include("include/sidebar.php");

// include('ems_header.php');

<h3 class="modal-title text-center">Assign New Task</h3>

</div>

<label class="control-label">Task Title</label>

</div>

<label class="control-label ">Task Description</label>

</div>

<label class="control-label ">Start Time</label>

</div>

</div>

<label class="control-label ">Assign To</label>

<?php

$sql = "SELECT user_id, fullname FROM tbl_admin WHERE user_role = 2";

$info = $obj_admin->manage_all_info($sql);

<option value="">Select Employee...</option>

<?php while($row = $info->fetch(PDO::FETCH_ASSOC)){ ?>

<?php } ?>

</select>

</div>

</div>

<button type="submit" name="add_task_post" class="btn btn-success-custom">Assign Task</button>

</div>

<button type="submit" class="btn btn-danger-custom" data-dismiss="modal">Cancel</button>

</div>

</form>

</div>

<?php if($user_role == 1){ ?>

<button class="btn btn-primary btn-menu" data-toggle="modal" data-target="#myModal">Assign New Task</button>

</div>

<?php } ?>

</div>

<center ><h3>Task Management Section</h3></center>

<thead>

<tr>

<th>Task Title</th>

<th>Assigned To</th>

<th>Start Time</th>

<th>Status</th>

<th>Action</th>

</tr>

</thead>

<tbody>

<?php

if($user_role == 1){

$sql = "SELECT a.*, b.fullname

FROM task_info a

INNER JOIN tbl_admin b ON(a.t_user_id = b.user_id)

ORDER BY a.task_id DESC";

}else{

$sql = "SELECT a.*, b.fullname

FROM task_info a

INNER JOIN tbl_admin b ON(a.t_user_id = b.user_id)

WHERE a.t_user_id = $user_id

ORDER BY a.task_id DESC";

}

$info = $obj_admin->manage_all_info($sql);

$serial = 1;

$num_row = $info->rowCount();

if($num_row==0){

echo '<tr><td colspan="7">No Data found</td></tr>';

}

while( $row = $info->fetch(PDO::FETCH_ASSOC) ){

<tr>

<td>

<?php if($row['status'] == 1){

echo " <span class='label label-warning' ><i class=' glyphicon glyphicon-refresh'></i> In Progress</span>";

}elseif($row['status'] == 2){

echo " <span class='label label-success'><i class='glyphicon glyphicon-ok'></i> Completed </span>";

}else{

echo "<span class='label label-danger'><i class='glyphicon glyphicon-remove'></i> Incomplete </span>";

} ?>

</td>

<td><a title="Update Task" href="edit-task.php?task_id=<?php echo $row['task_id'];?>" class="btn btn-primary btn-sm"><span class="glyphicon glyphicon-edit"></span></a>  

<a title="View" href="task-details.php?task_id=<?php echo $row['task_id']; ?>" class="btn btn-warning btn-sm"><span class="glyphicon glyphicon-folder-open"></span></a>  

<?php if($user_role == 1){ ?>

<a class="btn btn-danger btn-sm" title="Delete" href="?delete_task=delete_task&task_id=<?php echo $row['task_id']; ?>" onclick=" return check_delete();"><span class="glyphicon glyphicon-trash"></span></a></td>

<?php } ?>

</tr>

<?php } ?>

</tbody>

</table>

</div>

<?php

include("include/footer.php");

flatpickr('#t_start_time', {

enableTime: true

});

flatpickr('#t_end_time', {

enableTime: true

});

</script>

index PHP

<?php
require 'authentication.php'; // admin authentication check 

// auth check
if(isset($_SESSION['admin_id'])){
  $user_id = $_SESSION['admin_id'];
  $user_name = $_SESSION['admin_name'];
  $security_key = $_SESSION['security_key'];
  if ($user_id != NULL && $security_key != NULL) {
    header('Location: task-info.php');
  }
}//  Author Name: Mayuri K. 
 // for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com  
 //Visit website : www.mayurik.com

if(isset($_POST['login_btn'])){
 $info = $obj_admin->admin_login_check($_POST);
}

$page_name="Login";
include("include/login_header.php");

?>
<div class="ad-auth-wrapper">

		<div class="well col-md-6" style="position:relative;">
			<div class="row" style="
">
				<div class="col-md-6">
					<img src="assets/img/Taskko.png" width="90%" style="margin-top: 90px;">
			</div>
	<div class="col-md-6">
			<form class="row " action="" method="POST">
			  <div class="form-heading">
			
			    <h2 class="text-left">Login Panel</h2>
			    <p class="text-left">Task Management System by Mayuri K.</p>
			  </div>
			  
			  <!-- <div class="login-gap"></div> -->
			  <?php if(isset($info)){ ?>
			  <h5 class="alert alert-danger"><?php echo $info; ?></h5>
			  <?php } ?>
			  <div class="input-group form-group ">
    <span class="input-group-addon"><i class="glyphicon glyphicon-user"></i></span>
    <input  type="text" class="form-control" name="username" placeholder="Username">
  </div>
			 <!--  <div class="form-group">
			    <input type="text" class="form-control" placeholder="Username" name="username" required/>
			  </div> -->
			  <div class="input-group form-group" ng-class="{'has-error': loginForm.password.$invalid && loginForm.password.$dirty, 'has-success': loginForm.password.$valid}">
    <span class="input-group-addon"><i class="glyphicon glyphicon-lock"></i></span>
    <input  type="password" class="form-control" name="admin_password" placeholder="Password">
  </div>
			 <!--  <div class="form-group" >
			    <input type="password" class="form-control" placeholder="Password" name="" required/>
			  </div> -->
			  <div class="text-left">
			  <button type="submit" name="login_btn" class="btn btn-primary ">Login</button>
			</div>
			</form>
		</div>
		</div>
		</div>
	</div>
<!-- 
//  Author Name: Mayuri K. 
 // for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com  
 //Visit website : www.mayurik.com -->
<?php

include("include/footer.php");

?>

<?php

require 'authentication.php'; // admin authentication check

// auth check

if(isset($_SESSION['admin_id'])){

$user_id = $_SESSION['admin_id'];

$user_name = $_SESSION['admin_name'];

$security_key = $_SESSION['security_key'];

if ($user_id != NULL && $security_key != NULL) {

header('Location: task-info.php');

}

}// Author Name: Mayuri K.

// for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com

//Visit website : www.mayurik.com

if(isset($_POST['login_btn'])){

$info = $obj_admin->admin_login_check($_POST);

}

$page_name="Login";

include("include/login_header.php");

<div class="row" style="

</div>

<h2 class="text-left">Login Panel</h2>

<p class="text-left">Task Management System by Mayuri K.</p>

</div>

<?php if(isset($info)){ ?>

<?php } ?>

</div>

<!-- <div class="form-group">

</div> -->

</div>

<!-- <div class="form-group" >

</div> -->

<button type="submit" name="login_btn" class="btn btn-primary ">Login</button>

</div>

</form>

</div>

<!--

// Author Name: Mayuri K.

// for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com

//Visit website : www.mayurik.com -->

<?php

include("include/footer.php");

taskmatic SQL

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 03, 2024 at 03:57 PM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.2.4

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `taskmatic`
--

-- --------------------------------------------------------

--
-- Table structure for table `attendance_info`
--

CREATE TABLE `attendance_info` (
  `aten_id` int(20) NOT NULL,
  `atn_user_id` int(20) NOT NULL,
  `in_time` varchar(200) DEFAULT NULL,
  `out_time` varchar(150) DEFAULT NULL,
  `total_duration` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `attendance_info`
--

INSERT INTO `attendance_info` (`aten_id`, `atn_user_id`, `in_time`, `out_time`, `total_duration`) VALUES
(38, 18, '22-03-2021 13:51:01', '09-11-2023 10:09:02', '20:18:01'),
(35, 17, '22-03-2021 11:37:44', '07-01-2024 22:55:15', '11:17:31'),
(37, 21, '22-03-2021 13:49:26', NULL, NULL),
(39, 23, '22-03-2021 13:51:51', NULL, NULL),
(40, 20, '22-03-2021 13:52:24', NULL, NULL),
(41, 25, '22-03-2021 15:09:00', NULL, NULL),
(42, 1, '22-03-2021 22:01:43', '13-01-2024 22:54:50', '00:53:07'),
(43, 17, '07-01-2024 22:56:44', '07-01-2024 22:57:16', '00:00:32'),
(44, 28, '13-01-2024 22:52:18', '13-01-2024 22:52:45', '00:00:27');

-- --------------------------------------------------------

--
-- Table structure for table `task_info`
--

CREATE TABLE `task_info` (
  `task_id` int(50) NOT NULL,
  `t_title` varchar(120) NOT NULL,
  `t_description` text DEFAULT NULL,
  `t_start_time` varchar(100) DEFAULT NULL,
  `t_end_time` varchar(100) DEFAULT NULL,
  `t_user_id` int(20) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0 COMMENT '0 = incomplete, 1 = In progress, 2 = complete'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `task_info`
--

INSERT INTO `task_info` (`task_id`, `t_title`, `t_description`, `t_start_time`, `t_end_time`, `t_user_id`, `status`) VALUES
(20, 'Communications', 'You\'re assigned to handle incoming calls and other communications within the office.', '2021-03-22 12:00', '2021-03-22 13:00', 17, 2),
(21, 'Filing', 'You\'re assigned to management of filing system.', '2021-03-22 10:00', '2021-03-22 15:10', 22, 0),
(22, 'Virtual Meeting', 'Please join the virtual meeting with your senior manager regarding your works on this placement.', '2021-03-22 15:00', '2021-03-22 15:20', 24, 0),
(23, 'Data Entry', 'Go through some data!', '2021-03-22 14:00', '2021-03-22 17:00', 25, 1),
(26, 'Project Planning Session', 'Participate in a project planning session with the team.', '2023-03-23 15:30', '2023-03-23 17:00', 11, 1),
(27, 'Content Creation for Social Media', 'Create engaging content for social media channels.', '2023-03-23 09:00', '2023-03-23 10:30', 12, 2),
(28, 'Customer Support Calls', 'Handle customer support calls and address inquiries.', '2023-03-23 11:00', '2023-03-23 12:30', 13, 0),
(29, 'Quality Assurance Testing', 'Conduct quality assurance testing for the software release.', '2023-03-23 13:00', '2023-03-23 14:30', 14, 1),
(30, 'Employee Training Session', 'Lead a training session for new employees.', '2023-03-23 15:00', '2023-03-23 16:30', 15, 2),
(31, 'Market Research Analysis', 'Conduct analysis on recent market research data.', '2023-03-23 09:30', '2023-03-23 11:00', 16, 0),
(32, 'Inventory Management', 'Manage and update the inventory records.', '2023-03-23 12:00', '2023-03-23 13:30', 17, 1),
(33, 'Website Maintenance', 'Perform maintenance tasks for the company website.', '2023-03-23 14:00', '2023-03-23 15:30', 18, 2),
(34, 'Event Planning for Company Anniversary', 'Plan and organize activities for the upcoming company anniversary.', '2023-03-23 16:00', '2023-03-23 17:30', 19, 0),
(35, 'Code Review Session', 'Conduct a code review session for the development team.', '2023-03-23 10:30', '2023-03-23 12:00', 20, 1),
(36, 'Task Automation Implementation', 'Implement task automation processes to improve efficiency.', '2023-03-23 13:00', '2023-03-23 14:30', 21, 2),
(37, 'Product Launch Preparation', 'Prepare for the upcoming product launch event.', '2023-03-23 15:00', '2023-03-23 16:30', 22, 0),
(38, 'Client Consultation Meeting', 'Hold a consultation meeting with a key client.', '2023-03-23 09:00', '2023-03-23 10:30', 23, 1),
(39, 'Employee Performance Reviews', 'Conduct performance reviews for team members.', '2023-03-23 11:00', '2023-03-23 12:30', 24, 2),
(40, 'IT Infrastructure Upgrade', 'Plan and execute upgrades for the company\'s IT infrastructure.', '2023-03-23 13:30', '2023-03-23 15:00', 25, 0),
(41, 'Login Form Designing', 'Design HTML, CSS, JS files for login form designing.', '2024-01-07 12:00', '2024-01-10 12:00', 17, 2),
(42, 'Development of Login Form', 'design, develop and test forms related login and write logic for secure login functionality', '2024-01-13 12:00', '2024-01-20 12:00', 28, 2);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_admin`
--

CREATE TABLE `tbl_admin` (
  `user_id` int(20) NOT NULL,
  `fullname` varchar(120) NOT NULL,
  `username` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `temp_password` varchar(100) DEFAULT NULL,
  `user_role` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_admin`
--

INSERT INTO `tbl_admin` (`user_id`, `fullname`, `username`, `email`, `password`, `temp_password`, `user_role`) VALUES
(1, 'Mayuri K', 'mayuri.infospace@gmail.com', 'mayuri.infospace@gmail.com', 'cd92a26534dba48cd785cdcc0b3e6bd1', NULL, 1),
(17, 'Raghav Shasri', 'raghavshasri', 'raghav.shasri@example.com', 'e10adc3949ba59abbe56e057f20f883e', '', 2),
(18, 'Rajeev Kapoor', 'rajeev_kapoor', 'rajeev.kapoor@example.com', '5f4dcc3b5aa765d61d8327deb882cf99', '', 2),
(19, 'Priya Singh', 'priya_singh', 'priya.singh@example.com', 'd19cbde3f7ae39d1ac027dd5319ff687', '7301941', 2),
(20, 'Anand Kumar', 'anand_kumar', 'anand.kumar@example.com', '5f4dcc3b5aa765d61d8327deb882cf99', '', 2),
(21, 'Deepika Reddy', 'deepika_reddy', 'deepika.reddy@example.com', '5f4dcc3b5aa765d61d8327deb882cf99', '', 2),
(22, 'Vikram Verma', 'vikram_verma', 'vikram.verma@example.com', 'd03b2612e88338d193a0ff05c3216053', '7329407', 2),
(23, 'Sanya Gupta', 'sanya_gupta', 'sanya.gupta@example.com', '5f4dcc3b5aa765d61d8327deb882cf99', '', 2),
(24, 'Ravi Khanna', 'ravi_khanna', 'ravi.khanna@example.com', '789395abc72a025db1604582f52af520', '5876160', 2),
(25, 'Meera Joshi', 'meera_joshi', 'meera.joshi@example.com', '5f4dcc3b5aa765d61d8327deb882cf99', '', 2),
(27, 'Suresh Jain', 'surejain', 'surejain@example.com', 'a10f11c1ba82d9698f377c1408da77b2', '6246125', 2),
(28, 'Sachin Mahajan', 'sachinmahajan', 'sachinmahajan@gmail.com', '1455494c9f58563769b601366047c030', '', 2);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `attendance_info`
--
ALTER TABLE `attendance_info`
  ADD PRIMARY KEY (`aten_id`);

--
-- Indexes for table `task_info`
--
ALTER TABLE `task_info`
  ADD PRIMARY KEY (`task_id`);

--
-- Indexes for table `tbl_admin`
--
ALTER TABLE `tbl_admin`
  ADD PRIMARY KEY (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `attendance_info`
--
ALTER TABLE `attendance_info`
  MODIFY `aten_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;

--
-- AUTO_INCREMENT for table `task_info`
--
ALTER TABLE `task_info`
  MODIFY `task_id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `tbl_admin`
--
ALTER TABLE `tbl_admin`
  MODIFY `user_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

-- phpMyAdmin SQL Dump

-- version 5.2.1

-- https://www.phpmyadmin.net/

-- Host: 127.0.0.1

-- Generation Time: Mar 03, 2024 at 03:57 PM

-- Server version: 10.4.28-MariaDB

-- PHP Version: 8.2.4

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

START TRANSACTION;

SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8mb4 */;

-- Database: `taskmatic`

-- --------------------------------------------------------

-- Table structure for table `attendance_info`

CREATE TABLE `attendance_info` (

`aten_id` int(20) NOT NULL,

`atn_user_id` int(20) NOT NULL,

`in_time` varchar(200) DEFAULT NULL,

`out_time` varchar(150) DEFAULT NULL,

`total_duration` varchar(100) DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table `attendance_info`

INSERT INTO `attendance_info` (`aten_id`, `atn_user_id`, `in_time`, `out_time`, `total_duration`) VALUES

(38, 18, '22-03-2021 13:51:01', '09-11-2023 10:09:02', '20:18:01'),

(35, 17, '22-03-2021 11:37:44', '07-01-2024 22:55:15', '11:17:31'),

(37, 21, '22-03-2021 13:49:26', NULL, NULL),

(39, 23, '22-03-2021 13:51:51', NULL, NULL),

(40, 20, '22-03-2021 13:52:24', NULL, NULL),

(41, 25, '22-03-2021 15:09:00', NULL, NULL),

(42, 1, '22-03-2021 22:01:43', '13-01-2024 22:54:50', '00:53:07'),

(43, 17, '07-01-2024 22:56:44', '07-01-2024 22:57:16', '00:00:32'),

(44, 28, '13-01-2024 22:52:18', '13-01-2024 22:52:45', '00:00:27');

-- --------------------------------------------------------

-- Table structure for table `task_info`

CREATE TABLE `task_info` (

`task_id` int(50) NOT NULL,

`t_title` varchar(120) NOT NULL,

`t_description` text DEFAULT NULL,

`t_start_time` varchar(100) DEFAULT NULL,

`t_end_time` varchar(100) DEFAULT NULL,

`t_user_id` int(20) NOT NULL,

`status` int(11) NOT NULL DEFAULT 0 COMMENT '0 = incomplete, 1 = In progress, 2 = complete'

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table `task_info`

INSERT INTO `task_info` (`task_id`, `t_title`, `t_description`, `t_start_time`, `t_end_time`, `t_user_id`, `status`) VALUES

(20, 'Communications', 'You\'re assigned to handle incoming calls and other communications within the office.', '2021-03-22 12:00', '2021-03-22 13:00', 17, 2),

(21, 'Filing', 'You\'re assigned to management of filing system.', '2021-03-22 10:00', '2021-03-22 15:10', 22, 0),

(22, 'Virtual Meeting', 'Please join the virtual meeting with your senior manager regarding your works on this placement.', '2021-03-22 15:00', '2021-03-22 15:20', 24, 0),

(23, 'Data Entry', 'Go through some data!', '2021-03-22 14:00', '2021-03-22 17:00', 25, 1),

(26, 'Project Planning Session', 'Participate in a project planning session with the team.', '2023-03-23 15:30', '2023-03-23 17:00', 11, 1),

(27, 'Content Creation for Social Media', 'Create engaging content for social media channels.', '2023-03-23 09:00', '2023-03-23 10:30', 12, 2),

(28, 'Customer Support Calls', 'Handle customer support calls and address inquiries.', '2023-03-23 11:00', '2023-03-23 12:30', 13, 0),

(29, 'Quality Assurance Testing', 'Conduct quality assurance testing for the software release.', '2023-03-23 13:00', '2023-03-23 14:30', 14, 1),

(30, 'Employee Training Session', 'Lead a training session for new employees.', '2023-03-23 15:00', '2023-03-23 16:30', 15, 2),

(31, 'Market Research Analysis', 'Conduct analysis on recent market research data.', '2023-03-23 09:30', '2023-03-23 11:00', 16, 0),

(32, 'Inventory Management', 'Manage and update the inventory records.', '2023-03-23 12:00', '2023-03-23 13:30', 17, 1),

(33, 'Website Maintenance', 'Perform maintenance tasks for the company website.', '2023-03-23 14:00', '2023-03-23 15:30', 18, 2),

(34, 'Event Planning for Company Anniversary', 'Plan and organize activities for the upcoming company anniversary.', '2023-03-23 16:00', '2023-03-23 17:30', 19, 0),

(35, 'Code Review Session', 'Conduct a code review session for the development team.', '2023-03-23 10:30', '2023-03-23 12:00', 20, 1),

(36, 'Task Automation Implementation', 'Implement task automation processes to improve efficiency.', '2023-03-23 13:00', '2023-03-23 14:30', 21, 2),

(37, 'Product Launch Preparation', 'Prepare for the upcoming product launch event.', '2023-03-23 15:00', '2023-03-23 16:30', 22, 0),

(38, 'Client Consultation Meeting', 'Hold a consultation meeting with a key client.', '2023-03-23 09:00', '2023-03-23 10:30', 23, 1),

(39, 'Employee Performance Reviews', 'Conduct performance reviews for team members.', '2023-03-23 11:00', '2023-03-23 12:30', 24, 2),

(40, 'IT Infrastructure Upgrade', 'Plan and execute upgrades for the company\'s IT infrastructure.', '2023-03-23 13:30', '2023-03-23 15:00', 25, 0),

(41, 'Login Form Designing', 'Design HTML, CSS, JS files for login form designing.', '2024-01-07 12:00', '2024-01-10 12:00', 17, 2),

(42, 'Development of Login Form', 'design, develop and test forms related login and write logic for secure login functionality', '2024-01-13 12:00', '2024-01-20 12:00', 28, 2);

-- --------------------------------------------------------

-- Table structure for table `tbl_admin`

CREATE TABLE `tbl_admin` (

`user_id` int(20) NOT NULL,

`fullname` varchar(120) NOT NULL,

`username` varchar(100) NOT NULL,

`email` varchar(100) NOT NULL,

`password` varchar(100) NOT NULL,

`temp_password` varchar(100) DEFAULT NULL,

`user_role` int(10) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table `tbl_admin`

INSERT INTO `tbl_admin` (`user_id`, `fullname`, `username`, `email`, `password`, `temp_password`, `user_role`) VALUES

(1, 'Mayuri K', 'mayuri.infospace@gmail.com', 'mayuri.infospace@gmail.com', 'cd92a26534dba48cd785cdcc0b3e6bd1', NULL, 1),

(17, 'Raghav Shasri', 'raghavshasri', 'raghav.shasri@example.com', 'e10adc3949ba59abbe56e057f20f883e', '', 2),

(18, 'Rajeev Kapoor', 'rajeev_kapoor', 'rajeev.kapoor@example.com', '5f4dcc3b5aa765d61d8327deb882cf99', '', 2),

(19, 'Priya Singh', 'priya_singh', 'priya.singh@example.com', 'd19cbde3f7ae39d1ac027dd5319ff687', '7301941', 2),

(20, 'Anand Kumar', 'anand_kumar', 'anand.kumar@example.com', '5f4dcc3b5aa765d61d8327deb882cf99', '', 2),

(21, 'Deepika Reddy', 'deepika_reddy', 'deepika.reddy@example.com', '5f4dcc3b5aa765d61d8327deb882cf99', '', 2),

(22, 'Vikram Verma', 'vikram_verma', 'vikram.verma@example.com', 'd03b2612e88338d193a0ff05c3216053', '7329407', 2),

(23, 'Sanya Gupta', 'sanya_gupta', 'sanya.gupta@example.com', '5f4dcc3b5aa765d61d8327deb882cf99', '', 2),

(24, 'Ravi Khanna', 'ravi_khanna', 'ravi.khanna@example.com', '789395abc72a025db1604582f52af520', '5876160', 2),

(25, 'Meera Joshi', 'meera_joshi', 'meera.joshi@example.com', '5f4dcc3b5aa765d61d8327deb882cf99', '', 2),

(27, 'Suresh Jain', 'surejain', 'surejain@example.com', 'a10f11c1ba82d9698f377c1408da77b2', '6246125', 2),

(28, 'Sachin Mahajan', 'sachinmahajan', 'sachinmahajan@gmail.com', '1455494c9f58563769b601366047c030', '', 2);

-- Indexes for dumped tables

-- Indexes for table `attendance_info`

ALTER TABLE `attendance_info`

ADD PRIMARY KEY (`aten_id`);

-- Indexes for table `task_info`

ALTER TABLE `task_info`

ADD PRIMARY KEY (`task_id`);

-- Indexes for table `tbl_admin`

ALTER TABLE `tbl_admin`

ADD PRIMARY KEY (`user_id`);

-- AUTO_INCREMENT for dumped tables

-- AUTO_INCREMENT for table `attendance_info`

ALTER TABLE `attendance_info`

MODIFY `aten_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;

-- AUTO_INCREMENT for table `task_info`

ALTER TABLE `task_info`

MODIFY `task_id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

-- AUTO_INCREMENT for table `tbl_admin`

ALTER TABLE `tbl_admin`

MODIFY `user_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

task-info PHP

index PHP

taskmatic SQL

Related Posts: