Viewing file:  main_page.php (27.21 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
ob_start();
session_start();
require_once ('includes/db.php');
if(!$_SESSION['fullname']){
header("location: index.php");
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Admin Dashboard : Automation Software</title>
<meta charset="utf-8">
<meta content="ie=edge" http-equiv="x-ua-compatible">
<meta content="template language" name="keywords">
<meta content="Autosoft" name="author">
<meta content="Admin dashboard Autosoft" name="description">
<meta content="width=device-width, initial-scale=1" name="viewport">
<link href="img/favicon_autosoft.png" rel="shortcut icon">
<link href="https://fonts.googleapis.com/css?family=Prompt:300,400,600,700,800%7CShadows+Into+Light%7CPlayfair+Display:400" rel="stylesheet" type="text/css">
<link href="bower_components/select2/dist/css/select2.min.css" rel="stylesheet">
<link href="bower_components/bootstrap-daterangepicker/daterangepicker.css" rel="stylesheet">
<link href="bower_components/dropzone/dist/dropzone.css" rel="stylesheet">
<link href="bower_components/datatables.net-bs/css/dataTables.bootstrap.min.css" rel="stylesheet">
<link href="bower_components/fullcalendar/dist/fullcalendar.min.css" rel="stylesheet">
<link href="bower_components/perfect-scrollbar/css/perfect-scrollbar.min.css" rel="stylesheet">
<link href="bower_components/slick-carousel/slick/slick.css" rel="stylesheet">
<link href="css/main.css?version=4.4.0" rel="stylesheet">
</head>
<body class="menu-position-side menu-side-left full-screen">
<div class="all-wrapper solid-bg-all">
<div class="layout-w">
<!--------------------
START - Mobile Menu
-------------------->
<?php //include ('includes/mobile_menu.php'); ?>
<!--------------------
START - Main Menu
-------------------->
<?php include ('includes/main_menu.php'); ?>
<!--------------------
END - Main Menu
-------------------->
<div class="content-w">
<!--------------------
START - Top Bar
-------------------->
<?php include('includes/top_setting.php'); ?>
<!--------------------
END - Top Bar
-------------------->
<div class="content-i">
<div class="content-box">
<div class="row pt-4">
<div class="col-sm-12">
<!--START - Grid of tablo statistics-->
<div class="element-wrapper">
<h6 class="element-header">
AutoSoft Dashboard
</h6>
<div class="element-content">
<div class="tablo-with-chart">
<div class="row">
<div class="col-sm-5 col-xxl-4">
<div class="tablos">
<div class="row mb-xl-2 mb-xxl-3">
<div class="col-sm-6">
<a class="element-box el-tablo centered trend-in-corner padded bold-label" href="products_dashboard.php">
<div class="value">
<?php
$result_p = $conn->prepare("SELECT count(id) FROM tbl_product");
$result_p->execute();
$number_of_product = $result_p->fetchColumn();
echo $number_of_product;
?>
</div>
<div class="label">
Products
</div>
<!--
<div class="trending trending-up-basic">
<span>12%</span><i class="os-icon os-icon-arrow-up2"></i>
</div>
-->
</a>
</div>
<div class="col-sm-6">
<a class="element-box el-tablo centered trend-in-corner padded bold-label" href="solutions_dashboard.php">
<div class="value">
<?php
$result_s = $conn->prepare("SELECT count(id) FROM tbl_solution");
$result_s->execute();
$number_of_solution = $result_s->fetchColumn();
echo $number_of_solution;
?>
</div>
<div class="label">
Solutions
</div>
<!--
<div class="trending trending-down-basic">
<span>12%</span><i class="os-icon os-icon-arrow-down"></i>
</div>
-->
</a>
</div>
</div>
<div class="row">
<div class="col-sm-6">
<a class="element-box el-tablo centered trend-in-corner padded bold-label" href="teams_dashboard.php">
<div class="value">
<?php
$result_boss = $conn->prepare("SELECT count(id) FROM tbl_boss");
$result_boss->execute();
$number_of_boss = $result_boss->fetchColumn();
echo $number_of_boss;
?>
</div>
<div class="label">
Teams
</div>
<!--
<div class="trending trending-up-basic">
<span>12%</span><i class="os-icon os-icon-arrow-up2"></i>
</div>
-->
</a>
</div>
<div class="col-sm-6">
<a class="element-box el-tablo centered trend-in-corner padded bold-label" href="success_story_dashboard.php">
<div class="value">
<?php
$result = $conn->prepare("SELECT count(id) FROM tbl_success_story");
$result->execute();
$number_of_rows = $result->fetchColumn();
echo $number_of_rows;
?>
</div>
<div class="label">
Success
</div>
<!--
<div class="trending trending-down-basic">
<span>12%</span><i class="os-icon os-icon-arrow-down"></i>
</div>
-->
</a>
</div>
</div>
</div>
</div>
<div class="col-sm-7 col-xxl-8">
<!--START - Chart Box-->
<div class="element-box pl-xxl-5 pr-xxl-5">
<div class="el-tablo bigger highlight bold-label">
<div class="value">
12,537
</div>
<div class="label">
Visitors
</div>
</div>
<div class="el-chart-w">
<canvas height="170px" id="lineChart" width="600px"></canvas>
</div>
</div>
<!--END - Chart Box-->
</div>
</div>
</div>
</div>
</div>
<!--END - Grid of tablo statistics-->
</div>
</div>
<div class="row pt-4">
<div class="col-sm-12">
<!--START - Recent Ticket Comments-->
<div class="element-wrapper">
<h6 class="element-header">
Our Teams
</h6>
<div class="element-box-tp">
<div class="table-responsive">
<table class="table table-padded">
<thead>
<tr>
<th></th>
<th>
Name
</th>
<th class="text-center">
Position
</th>
<th>
Company
</th>
<th>
Status
</th>
<th>
Action
</th>
</tr>
</thead>
<tbody>
<!-- Start Query Sql -->
<?php
$result = $conn->prepare("SELECT * FROM tbl_boss Order By pin ASC");
$result->execute();
for($i=0; $row = $result->fetch(); $i++){
$id=$row['id'];
?>
<!-- End Query Sql -->
<tr>
<td class="text-center">
<?php echo $i+1; ?>
</td>
<td>
<div class="user-with-avatar">
<img src="uploads/teams/<?php echo $row['image_location']; ?>" width="107" class="avatar-w" ><span><?php echo $row['fname'].' '.$row['lname']; ?></span>
</div>
</td>
<td>
<span><?php echo $row['position']; ?></span>
</td>
<td class="text-center">
<a class="badge badge-primary-inverted" href="">Autosoft</a>
</td>
<td class="nowrap">
<span class="status-pill smaller green"></span><span>success</span>
</td>
<td class="row-actions">
<a href="#onboardingWideTextModal<?php echo $i; ?>" data-toggle="modal"><i class="os-icon os-icon-ui-44"></i></a>
</td>
<div aria-hidden="true" class="onboarding-modal modal fade animated" id="onboardingWideTextModal<?php echo $i; ?>" role="dialog" tabindex="-1">
<div class="modal-dialog modal-lg modal-centered" role="document">
<div class="modal-content text-center">
<button aria-label="Close" class="close" data-dismiss="modal" type="button"><span class="close-label">Close</span><span class="os-icon os-icon-close"></span></button>
<div class="onboarding-side-by-side">
<div class="onboarding-media">
<img alt="" src="uploads/teams/<?php echo $row['image_location']; ?>" width="200px">
</div>
<div class="onboarding-content with-gradient">
<h4 class="onboarding-title">
<?php echo $row['pname']." ".$row['fname']." ".$row['lname']; ?>
</h4>
<h6 class="onboarding-title">
<?php echo $row['position']; ?>
</h6>
<ul class="list-unstyled">
<li><h4 class="font-weight-normal"><i class="fab fa-whatsapp text-color-secondary"></i> <?php echo $row['telephone']; ?></H4></li>
<li><h4 class="font-weight-normal"><i class="far fa-envelope text-color-secondary"></i> <?php echo $row['email']; ?></h4> </li>
</ul>
<div class="onboarding-text">
"<?php echo $row['memo']; ?>""
</div>
</div>
</div>
</div>
</div>
</div>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
<!--END - Recent Ticket Comments-->
</div>
</div>
<!--------------------
START - Color Scheme Toggler
<div class="floated-colors-btn second-floated-btn">
<div class="os-toggler-w">
<div class="os-toggler-i">
<div class="os-toggler-pill"></div>
</div>
</div>
<span>Dark </span><span>Colors</span>
</div>
-------------------->
<!--------------------
END - Color Scheme Toggler
--------------------><!--------------------
START - Demo Customizer
<div class="floated-customizer-btn third-floated-btn">
<div class="icon-w">
<i class="os-icon os-icon-ui-46"></i>
</div>
<span>Customizer</span>
</div>
<div class="floated-customizer-panel">
<div class="fcp-content">
<div class="close-customizer-btn">
<i class="os-icon os-icon-x"></i>
</div>
<div class="fcp-group">
<div class="fcp-group-header">
Menu Settings
</div>
<div class="fcp-group-contents">
<div class="fcp-field">
<label for="">Menu Position</label><select class="menu-position-selector">
<option value="left">
Left
</option>
<option value="right">
Right
</option>
<option value="top">
Top
</option>
</select>
</div>
<div class="fcp-field">
<label for="">Menu Style</label><select class="menu-layout-selector">
<option value="compact">
Compact
</option>
<option value="full">
Full
</option>
<option value="mini">
Mini
</option>
</select>
</div>
<div class="fcp-field with-image-selector-w">
<label for="">With Image</label><select class="with-image-selector">
<option value="yes">
Yes
</option>
<option value="no">
No
</option>
</select>
</div>
<div class="fcp-field">
<label for="">Menu Color</label>
<div class="fcp-colors menu-color-selector">
<div class="color-selector menu-color-selector color-bright selected"></div>
<div class="color-selector menu-color-selector color-dark"></div>
<div class="color-selector menu-color-selector color-light"></div>
<div class="color-selector menu-color-selector color-transparent"></div>
</div>
</div>
</div>
</div>
<div class="fcp-group">
<div class="fcp-group-header">
Sub Menu
</div>
<div class="fcp-group-contents">
<div class="fcp-field">
<label for="">Sub Menu Style</label><select class="sub-menu-style-selector">
<option value="flyout">
Flyout
</option>
<option value="inside">
Inside/Click
</option>
<option value="over">
Over
</option>
</select>
</div>
<div class="fcp-field">
<label for="">Sub Menu Color</label>
<div class="fcp-colors">
<div class="color-selector sub-menu-color-selector color-bright selected"></div>
<div class="color-selector sub-menu-color-selector color-dark"></div>
<div class="color-selector sub-menu-color-selector color-light"></div>
</div>
</div>
</div>
</div>
<div class="fcp-group">
<div class="fcp-group-header">
Other Settings
</div>
<div class="fcp-group-contents">
<div class="fcp-field">
<label for="">Full Screen?</label><select class="full-screen-selector">
<option value="yes">
Yes
</option>
<option value="no">
No
</option>
</select>
</div>
<div class="fcp-field">
<label for="">Show Top Bar</label><select class="top-bar-visibility-selector">
<option value="yes">
Yes
</option>
<option value="no">
No
</option>
</select>
</div>
<div class="fcp-field">
<label for="">Above Menu?</label><select class="top-bar-above-menu-selector">
<option value="yes">
Yes
</option>
<option value="no">
No
</option>
</select>
</div>
<div class="fcp-field">
<label for="">Top Bar Color</label>
<div class="fcp-colors">
<div class="color-selector top-bar-color-selector color-bright selected"></div>
<div class="color-selector top-bar-color-selector color-dark"></div>
<div class="color-selector top-bar-color-selector color-light"></div>
<div class="color-selector top-bar-color-selector color-transparent"></div>
</div>
</div>
</div>
</div>
</div>
</div>
-------------------->
<!--------------------
END - Demo Customizer
--------------------><!--------------------
START - Chat Popup Box
<div class="floated-chat-btn">
<i class="os-icon os-icon-mail-07"></i><span>Demo Chat</span>
</div>
<div class="floated-chat-w">
<div class="floated-chat-i">
<div class="chat-close">
<i class="os-icon os-icon-close"></i>
</div>
<div class="chat-head">
<div class="user-w with-status status-green">
<div class="user-avatar-w">
<div class="user-avatar">
<img alt="" src="img/avatar1.jpg">
</div>
</div>
<div class="user-name">
<h6 class="user-title">
John Mayers
</h6>
<div class="user-role">
Account Manager
</div>
</div>
</div>
</div>
<div class="chat-messages">
<div class="message">
<div class="message-content">
Hi, how can I help you?
</div>
</div>
<div class="date-break">
Mon 10:20am
</div>
<div class="message">
<div class="message-content">
Hi, my name is Mike, I will be happy to assist you
</div>
</div>
<div class="message self">
<div class="message-content">
Hi, I tried ordering this product and it keeps showing me error code.
</div>
</div>
</div>
<div class="chat-controls">
<input class="message-input" placeholder="Type your message here..." type="text">
<div class="chat-extra">
<a href="#"><span class="extra-tooltip">Attach Document</span><i class="os-icon os-icon-documents-07"></i></a><a href="#"><span class="extra-tooltip">Insert Photo</span><i class="os-icon os-icon-others-29"></i></a><a href="#"><span class="extra-tooltip">Upload Video</span><i class="os-icon os-icon-ui-51"></i></a>
</div>
</div>
</div>
</div>
-------------------->
<!--------------------
END - Chat Popup Box
-------------------->
</div>
</div>
</div>
</div>
<div class="display-type"></div>
</div>
<script src="bower_components/jquery/dist/jquery.min.js"></script>
<script src="bower_components/popper.js/dist/umd/popper.min.js"></script>
<script src="bower_components/moment/moment.js"></script>
<script src="bower_components/chart.js/dist/Chart.min.js"></script>
<script src="bower_components/select2/dist/js/select2.full.min.js"></script>
<script src="bower_components/jquery-bar-rating/dist/jquery.barrating.min.js"></script>
<script src="bower_components/ckeditor/ckeditor.js"></script>
<script src="bower_components/bootstrap-validator/dist/validator.min.js"></script>
<script src="bower_components/bootstrap-daterangepicker/daterangepicker.js"></script>
<script src="bower_components/ion.rangeSlider/js/ion.rangeSlider.min.js"></script>
<script src="bower_components/dropzone/dist/dropzone.js"></script>
<script src="bower_components/editable-table/mindmup-editabletable.js"></script>
<script src="bower_components/datatables.net/js/jquery.dataTables.min.js"></script>
<script src="bower_components/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>
<script src="bower_components/fullcalendar/dist/fullcalendar.min.js"></script>
<script src="bower_components/perfect-scrollbar/js/perfect-scrollbar.jquery.min.js"></script>
<script src="bower_components/tether/dist/js/tether.min.js"></script>
<script src="bower_components/slick-carousel/slick/slick.min.js"></script>
<script src="bower_components/bootstrap/js/dist/util.js"></script>
<script src="bower_components/bootstrap/js/dist/alert.js"></script>
<script src="bower_components/bootstrap/js/dist/button.js"></script>
<script src="bower_components/bootstrap/js/dist/carousel.js"></script>
<script src="bower_components/bootstrap/js/dist/collapse.js"></script>
<script src="bower_components/bootstrap/js/dist/dropdown.js"></script>
<script src="bower_components/bootstrap/js/dist/modal.js"></script>
<script src="bower_components/bootstrap/js/dist/tab.js"></script>
<script src="bower_components/bootstrap/js/dist/tooltip.js"></script>
<script src="bower_components/bootstrap/js/dist/popover.js"></script>
<script src="js/demo_customizer.js?version=4.4.0"></script>
<script src="js/main.js?version=4.4.0"></script>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','https://www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-XXXXXXX-9', 'auto');
ga('send', 'pageview');
</script>
</body>
</html>
|