MAINHACK

Viewing / Editing File: dashboard.php

<?php include 'header.php'; ?>

<div class="main-panel">
			<div class="content">
				<div class="container-fluid">
					<div class="page-header">
						<h4 class="page-title">Dashboard</h4>
						
					</div>
										<div class="row">
						    	<div class="col-sm-2 col-md-2">
							<div class="card card-stats card-info card-round">
								<div class="card-body">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-6"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
													<a href="add_project_type.php"><p class="card-category">Add Project Type</p></a>
												
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
            	    <div class="col-sm-2 col-md-2">
							<div class="card card-stats card-success card-round">
								<div class="card-body">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-6"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
													<a href="add_source.php"><p class="card-category">Add Source</p></a>
												
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
           <div class="col-sm-3 col-md-2">
							<div class="card card-stats card-warning card-round">
								<div class="card-body">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-6"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
													<a href="add_agent.php"><p class="card-category">Add Agent</p></a>
												
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
         
           <div class="col-sm-3 col-md-2">
							<div class="card card-stats card-danger card-round">
								<div class="card-body">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-6"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
													<a href="all_agent.php"><p class="card-category">All Agent</p></a>
												
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
             <div class="col-sm-3 col-md-2">
							<div class="card card-stats card-success card-round">
								<div class="card-body">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-6"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
													<a href="add_customer.php"><p class="card-category">Add Customer</p></a>
												
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
           
                  <div class="col-sm-3 col-md-2">
							<div class="card card-stats card-warning card-round">
								<div class="card-body">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-6"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
													<a href="all_client.php"><p class="card-category">All Customer</p></a>
												
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
       		     <div class="col-sm-3 col-md-2">
							<div class="card card-stats card-info card-round">
								<div class="card-body">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-6"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
													<a href="add_project.php"><p class="card-category">Add Project</p></a>
												
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
						  <div class="col-sm-3 col-md-2">
							<div class="card card-stats card-warning card-round">
								<div class="card-body">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-6"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
													<a href="all_project.php"><p class="card-category">All Project</p></a>
												
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
						<div class="col-sm-3 col-md-2">
							<div class="card card-stats card-danger card-round">
								<div class="card-body">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-6"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
													<a href="all_bill.php"><p class="card-category">All Invoice</p></a>
												
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
							<div class="col-sm-3 col-md-2">
							<div class="card card-stats card-success card-round">
								<div class="card-body">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-6"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
													<a href="all_bill_performa.php"><p class="card-category">Performa Invoice</p></a>
												
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
							<div class="col-sm-3 col-md-2">
							<div class="card card-stats card-warning card-round">
								<div class="card-body">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-6"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
													<a href="recent_renewal.php"><p class="card-category">Recent Renewals</p></a>
												
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
							<div class="col-sm-3 col-md-2">
							<div class="card card-stats card-info card-round">
								<div class="card-body">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-6"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
													<a href="all_renewals.php"><p class="card-category">All Renewals</p></a>
												
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
						    </div>
						    		<div class="row">
						    		    
						    		    				<div class="container-fluid">
					<div class="page-header">
						<h4 class="page-title">All Project Followups</h4>
						
					</div>
					<div class="row">
						<div class="col-md-12">
							<div class="card">
							
								<div class="card-body">
									<div class="table-responsive">
					            <table id="basic-datatables" class="display table table-striped table-hover">
                                        <thead>
                                            <th>ID</th>
                                           <th>Date</th>
                                           <th>Project Type</th>
                                           <th>Title</th>
                                           <th>Contact Person</th>
                                           <th>Proposed Cost</th>
                                           <th>Final Cost</th>
                                           <th>Followup Date</th>
                                            <th>Follow Up</th>
                                            <th>Action</th>
                                            
                                        </thead>
<tbody>
		
<?php
$count=1;
$sr='project';
$sql="select * from project left join project_proposal on project.project_id=project_proposal.project_id order by project_proposal.id desc";
$stmt=$con->prepare($sql);
$stmt->execute();
$num = $stmt->rowCount();
    if($num>0){
 
        $count=1;
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];

// echo $usr_p;

echo "<tr>
							    <td>$count</td>
								<td>".date('d-m-Y',strtotime($row['date']))."</td>
								<td>".$row['project_type']."</td>
								<td>".$row['title']."</td>
								<td>".$row['customer_id']."<br>".$row['customer_name']."<br>".$row['customer_phone']."</td>
								<td>".$row['proposed_cost']."</td>
								<td>".$row['final_cost']."</td>
								<td><span style='color:red'>".date('d-m-Y',strtotime($row['follow_date']))."</span></td>
								<td>".$row['followup']."</td>
								";
								?>
		
                                <?php echo "<td>
								<a href='show_project.php?id=".$row['project_id']."&table=$sr&url=".$_SERVER['REQUEST_URI']."' class='btn btn-xs btn-info'>Show</a>

<a href='edit_project.php?id=".$row['project_id']."&table=$sr&url=".$_SERVER['REQUEST_URI']."' class='btn btn-xs btn-default'>Edit</a>
								</td>
								</tr>";

++$count;
 }
}

?>							
</tbody>
                                    </table>

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

</div>

</div>
			</div>
			
		</div>
	<!---	<div class="quick-sidebar">
			<a href="#" class="close-quick-sidebar">
				<i class="flaticon-cross"></i>
			</a>
			<div class="quick-sidebar-wrapper">
				<ul class="nav nav-tabs nav-line nav-color-primary" role="tablist">
					<li class="nav-item"> <a class="nav-link active show" data-toggle="tab" href="#messages" role="tab" aria-selected="true">Messages</a> </li>
					<li class="nav-item"> <a class="nav-link" data-toggle="tab" href="#tasks" role="tab" aria-selected="false">Tasks</a> </li>
					<li class="nav-item"> <a class="nav-link" data-toggle="tab" href="#settings" role="tab" aria-selected="false">Settings</a> </li>
				</ul>
				<div class="tab-content mt-3">
					<div class="tab-chat tab-pane fade show active" id="messages" role="tabpanel">
						<div class="messages-contact">
							<div class="quick-wrapper">
								<div class="quick-scroll scrollbar-outer">
									<div class="quick-content contact-content">
										<span class="category-title mt-0">Recent</span>
										<div class="contact-list contact-list-recent">
											<div class="user">
												<a href="#">
													<div class="user-image">
														<img src="assets/img/jm_denis.jpg" alt="denis">
														<span class="status online"></span>
													</div>
													<div class="user-data">
														<span class="name">Jimmy Denis</span>
														<span class="message">How are you ?</span>
													</div>
												</a>
											</div>
											<div class="user">
												<a href="#">
													<div class="user-image">
														<img src="assets/img/chadengle.jpg" alt="chad">
														<span class="status away"></span>
													</div>
													<div class="user-data">
														<span class="name">Chad</span>
														<span class="message">Ok, Thanks !</span>
													</div>
												</a>
											</div>
											<div class="user">
												<a href="#">
													<div class="user-image">
														<img src="assets/img/mlane.jpg" alt="john doe">
														<span class="status offline"></span>
													</div>
													<div class="user-data">
														<span class="name">John Doe</span>
														<span class="message">Ready for the meeting today with...</span>
													</div>
												</a>
											</div>
										</div>
										<span class="category-title">Contacts</span>
										<div class="contact-list">
											<div class="user">
												<a href="#">
													<div class="user-image">
														<img src="assets/img/jm_denis.jpg" alt="denis">
														<span class="status"></span>
													</div>
													<div class="user-data2">
														<span class="name">Jimmy Denis</span>
													</div>
												</a>
											</div>
											<div class="user">
												<a href="#">
													<div class="user-image">
														<img src="assets/img/chadengle.jpg" alt="chad">
														<span class="status away"></span>
													</div>
													<div class="user-data2">
														<span class="name">Chad</span>
													</div>
												</a>
											</div>
											<div class="user">
												<a href="#">
													<div class="user-image">
														<img src="assets/img/talha.jpg" alt="talha">
														<span class="status offline"></span>
													</div>
													<div class="user-data2">
														<span class="name">Talha</span>
													</div>
												</a>
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
						<div class="messages-wrapper">
							<div class="messages-title">
								<div class="user">
									<img src="assets/img/chadengle.jpg" alt="chad">
									<span class="name">Chad</span>
									<span class="last-active">Active 2h ago</span>
								</div>
								<button class="return">
									<i class="flaticon-left-arrow-3"></i>
								</button>
							</div>
							<div class="messages-body messages-scroll scrollbar-outer">
								<div class="message-content-wrapper">
									<div class="message message-in">
										<div class="message-pic">
											<img src="assets/img/chadengle.jpg" alt="chad">
										</div>
										<div class="message-body">
											<div class="message-content">
												<div class="name">Chad</div>
												<div class="content">Hello, Rian</div>
											</div>
										</div>
									</div>
								</div>
								<div class="message-content-wrapper">
									<div class="message message-out">
										<div class="message-body">
											<div class="message-content">
												<div class="content">
													Hello, Chad
												</div>
											</div>
										</div>
									</div>
								</div>
								<div class="message-content-wrapper">
									<div class="message message-in">
										<div class="message-pic">
											<img src="assets/img/chadengle.jpg" alt="chad">
										</div>
										<div class="message-body">
											<div class="message-content">
												<div class="name">Chad</div>
												<div class="content">
													When is the deadline of the project we are working on ?
												</div>
											</div>
										</div>
									</div>
								</div>
								<div class="message-content-wrapper">
									<div class="message message-out">
										<div class="message-body">
											<div class="message-content">
												<div class="content">
													The deadline is about 2 months away
												</div>
											</div>
										</div>
									</div>
								</div>
								<div class="message-content-wrapper">
									<div class="message message-in">
										<div class="message-pic">
											<img src="assets/img/chadengle.jpg" alt="chad">
										</div>
										<div class="message-body">
											<div class="message-content">
												<div class="name">Chad</div>
												<div class="content">
													Ok, Thanks !
												</div>
											</div>
										</div>
									</div>
								</div>
							</div>
							<div class="messages-form">
								<div class="messages-form-control">
									<input type="text" placeholder="Type here" class="form-control input-pill input-solid message-input">
								</div>
								<div class="messages-form-tool">
									<a href="#" class="attachment">
										<i class="flaticon-file"></i>
									</a>
								</div>
							</div>
						</div>
					</div>

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

<?php include 'footer.php' ?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: dashboard.php

Server Info

System Features

User Info