|
Server : LiteSpeed System : Linux terra.hostitbro.com 5.14.0-611.54.3.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Thu May 7 16:31:24 EDT 2026 x86_64 User : outerorb ( 1091) PHP Version : 8.1.34 Disable Function : mail Directory : /home/outerorb/dev.outerorbittech.com/erp/admin/ | |
|
Path: //home/outerorb/dev.outerorbittech.com/erp/admin/index.php
Size: 29.23 KB
Permissions: 0644
<?php
ob_start();
session_start();
if($_SESSION['aid']!=session_id())
{
header("location:../index.php");
}
?>
<!doctype html>
<html class="no-js" lang="">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>ADMIN</title>
<link rel="icon" type="image/png" href="images/ric.png"/>
<meta name="description" content="Ela Admin - HTML5 Admin Template">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/normalize.css@8.0.0/normalize.min.css">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.1.3/dist/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/font-awesome@4.7.0/css/font-awesome.min.css">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/gh/lykmapipo/themify-icons@0.1.2/css/themify-icons.css">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/pixeden-stroke-7-icon@1.2.3/pe-icon-7-stroke/dist/pe-icon-7-stroke.min.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/flag-icon-css/3.2.0/css/flag-icon.min.css">
<link rel="stylesheet" href="assets/css/cs-skin-elastic.css">
<link rel="stylesheet" href="assets/css/style.css">
<link href="https://cdn.jsdelivr.net/npm/chartist@0.11.0/dist/chartist.min.css" rel="stylesheet">
<link href="https://cdn.jsdelivr.net/npm/jqvmap@1.5.1/dist/jqvmap.min.css" rel="stylesheet">
<link href="https://cdn.jsdelivr.net/npm/weathericons@2.1.0/css/weather-icons.css" rel="stylesheet" />
<link href="https://cdn.jsdelivr.net/npm/fullcalendar@3.9.0/dist/fullcalendar.min.css" rel="stylesheet" />
<style>
#weatherWidget .currentDesc {
color: #ffffff!important;
}
.traffic-chart {
min-height: 335px;
}
#flotPie1 {
height: 150px;
}
#flotPie1 td {
padding:3px;
}
#flotPie1 table {
top: 20px!important;
right: -10px!important;
}
.chart-container {
display: table;
min-width: 270px ;
text-align: left;
padding-top: 10px;
padding-bottom: 10px;
}
#flotLine5 {
height: 105px;
}
#flotBarChart {
height: 150px;
}
#cellPaiChart{
height: 160px;
}
/* CSS PART OF ADD CLIENT */
/* Importing fonts from Google */
@import url('https://fonts.googleapis.com/css2?family=Poppins:wght@300;400;500;600;700;800;900&display=swap');
/* Reseting */
* {
margin: 0;
padding: 0;
box-sizing: border-box;
font-family: 'Poppins', sans-serif;
}
body {
background: #ecf0f3;
}
.wrapper {
max-width: 350px;
min-height: 500px;
margin: 80px auto;
padding: 40px 30px 30px 30px;
background-color: #ecf0f3;
border-radius: 15px;
box-shadow: 13px 13px 20px #cbced1, -13px -13px 20px #fff;
}
.logo {
width: 80px;
margin: auto;
}
.logo img {
width: 100%;
height: 80px;
object-fit: cover;
border-radius: 50%;
box-shadow: 0px 0px 3px #5f5f5f,
0px 0px 0px 5px #ecf0f3,
8px 8px 15px #a7aaa7,
-8px -8px 15px #fff;
}
.wrapper .name {
font-weight: 600;
font-size: 1.4rem;
letter-spacing: 1.3px;
padding-left: 10px;
color: #555;
}
.wrapper .form-field input {
width: 100%;
display: block;
border: none;
outline: none;
background: none;
font-size: 1.2rem;
color: #666;
padding: 10px 15px 10px 10px;
/* border: 1px solid red; */
}
.wrapper .form-field {
padding-left: 10px;
margin-bottom: 20px;
border-radius: 20px;
box-shadow: inset 8px 8px 8px #cbced1, inset -8px -8px 8px #fff;
}
.wrapper .form-field .fas {
color: #555;
}
.wrapper .btn {
box-shadow: none;
width: 100%;
height: 40px;
background-color: #03A9F4;
color: #fff;
border-radius: 25px;
box-shadow: 3px 3px 3px #b1b1b1,
-3px -3px 3px #fff;
letter-spacing: 1.3px;
}
.wrapper .btn:hover {
background-color: #039BE5;
}
.wrapper a {
text-decoration: none;
font-size: 0.8rem;
color: #03A9F4;
}
.wrapper a:hover {
color: #039BE5;
}
@media(max-width: 380px) {
.wrapper {
margin: 30px 20px;
padding: 40px 15px 15px 15px;
}
}
</style>
</head>
<body>
<!-- Left Panel -->
<aside id="left-panel" class="left-panel">
<nav class="navbar navbar-expand-sm navbar-default">
<div id="main-menu" class="main-menu collapse navbar-collapse">
<ul class="nav navbar-nav">
<li class="active">
<a href="index.php"><i class="menu-icon fa fa-dashcube"> </i>Dashboard </a>
</li>
<li class="">
<a href="data.php"><i class="menu-icon fa fa-user"></i>CLIENT LIST </a>
</li>
<li class="">
<a href="add.php"><i class="menu-icon fa fa-money"></i>ADD CLIENT </a>
</li>
<li class="">
<a href="../end.php"><i class="menu-icon fa fa-sign-out"></i>LOGOUT </a>
</li>
</div><!-- /.navbar-collapse -->
</nav>
</aside>
<!-- /#left-panel -->
<!-- Right Panel -->
<div id="right-panel" class="right-panel">
<!-- Header-->
<header id="header" class="header">
<div class="top-left">
<div class="navbar-header">
<a class="navbar-brand" href="./"><img src="../images/logo.png" alt="Logo"></a>
<a class="navbar-brand hidden" href="./"><img src="../images/logo2.png" alt="Logo"></a>
<a id="menuToggle" class="menutoggle"><i class="fa fa-bars"></i></a>
</div>
</div>
<div class="top-right">
<div class="header-menu">
<div class="header-left">
<button class="search-trigger"><i class="fa fa-search"></i></button>
<!-- //search -->
<div class="form-inline">
<form class="search-form">
<input class="form-control mr-sm-2" type="text" placeholder="Search ..." aria-label="Search">
<button class="search-close" type="submit"><i class="fa fa-close"></i></button>
</form>
</div>
</div>
<div class="user-area dropdown float-right">
<a href="#" class="dropdown-toggle active" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
<img class="user-avatar rounded-circle" src="../images/logo2.png" alt="User">
</a>
<div class="user-menu dropdown-menu">
<a class="nav-link" href="../end.php" style="color:red; font-weight:700;"><i class="fa fa-power -off"></i>LOGOUT</a>
</div>
</div>
</div>
</div>
</header>
<!-- /#header -->
<!-- Content -->
<div class="content">
<!-- Animated -->
<div class="animated fadeIn">
<!-- Widgets -->
<div class="row">
<div class="col-lg-4 col-md-6">
<div class="card">
<div class="card-body">
<div class="stat-widget-five">
<div class="stat-icon dib flat-color-1">
<i class="pe-7s-cash"></i>
</div>
<?php
include"connection.php";
$q="SELECT SUM(amount) from client";
$sq=mysqli_query($cn,$q);
$rev=0;
while($r=mysqli_fetch_array($sq))
{
$rev=$r['SUM(amount)'];
}
?>
<div class="stat-content">
<div class="text-left dib">
<div class="stat-text">$<span class="count"><?php echo $rev; ?></span></div>
<div class="stat-heading">Revenue</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="col-lg-4 col-md-6">
<div class="card">
<div class="card-body">
<div class="stat-widget-five">
<div class="stat-icon dib flat-color-2">
<i class="pe-7s-cart"></i>
</div>
<?php
include"connection.php";
$q="select * from client";
$sq=mysqli_query($cn,$q);
$sale=0;
while($r=mysqli_fetch_array($sq))
{
$sale++;
}
?>
<div class="stat-content">
<div class="text-left dib">
<div class="stat-text"><span class="count"><?php echo $sale; ?></span></div>
<div class="stat-heading">Sales</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="col-lg-4 col-md-6">
<div class="card">
<div class="card-body">
<div class="stat-widget-five">
<div class="stat-icon dib flat-color-4">
<i class="pe-7s-users"></i>
</div>
<?php
include"connection.php";
$q="SELECT COUNT(DISTINCT name) as cnt FROM client;";
$sq=mysqli_query($cn,$q);
$cnt=0;
while($r=mysqli_fetch_array($sq))
{
$cnt=$r['cnt'];
}
?>
<div class="stat-content">
<div class="text-left dib">
<div class="stat-text"><span class="count"><?php echo $cnt; ?></span></div>
<div class="stat-heading">Clients</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- /Widgets -->
<!-- Traffic -->
<!-- /Traffic -->
<div class="clearfix"></div>
<!-- Orders -->
<div class="orders">
<div class="row">
<div class="col-xl-6">
<div class="card">
<?php
if(isset($_POST['submit']))
{
$type=trim($_POST['type']);
$name=trim($_POST['name']);
$street=trim($_POST['street']);
$city=trim($_POST['city']);
$state=trim($_POST['state']);
$zip=trim($_POST['zip']);
$email=trim($_POST['email']);
$alt=trim($_POST['alt']);
$date=trim($_POST['date']);
$amt=trim($_POST['amt']);
$invno='INV-00-'.rand(9999,10);
include"connection.php";
$qv="insert into client
(invno,type,name,street,city,state,zip,email ,altemail ,date ,amount)
values('".$invno."','".$type."','".$name."','".$street."','".$city."','".$state."','".$zip."','".$email."','".$alt."','".$date."','".$amt."')";
$sqv=mysqli_query($cn,$qv);
if($sqv)
{
$type=$name=$street=$city=$state=$zip=$email=$alt=$date=$amt=$invno=""; // to clear form after sucess submit
echo '<script> alert("REGISTRATION SUCCESS");
window.location="index.php"; </script>';
}
else
{
// function to show sql query error
echo'<br>'.mysqli_error($cn);
}
}
?>
<div class="wrapper" style="margin-left:8%">
<div class="logo">
<img src="images/zap.jpg" alt="Za">
</div>
<div class="text-center mt-4 name" style="color:red">
ADD CLIENT
</div>
<form action="" class="p-3 mt-3" method="POST" enctype="multipart/form-data">
<div class="form-field d-flex align-items-center">
<select name="type" class="form-control" required style="
width: 100%;
display: block;
border: none;
outline: none;
background: none;
font-size: 1.2rem;
color: #666;
padding: 5px 15px 10px 10px;
">
<option value="">Type Of Client</option>
<option value="Company">Company</option>
<option value="Individual">Individual</option>
</select>
</div>
<div class="form-field d-flex align-items-center">
<input name="name" class="form-control" placeholder="Full name" type="text" required >
</div>
<div class="form-field d-flex align-items-center">
<input name="street" class="form-control" placeholder="Street Name" type="text" style="font-size: 1.1rem" required >
<input name="city" class="form-control" placeholder="City Name" type="text" required >
</div>
<div class="form-field d-flex align-items-center">
<input name="state" class="form-control" placeholder="State" type="text" required >
<input name="zip" class="form-control" placeholder="Zip Code" type="text" required >
</div>
<div class="form-field d-flex align-items-center">
<input name="email" class="form-control" placeholder="Email address" type="text" required >
</div>
<div class="form-field d-flex align-items-center">
<input name="alt" class="form-control" placeholder="Alt. Email address" type="text" required >
</div>
<div class="form-field d-flex align-items-center">
<input name="date" class="form-control" placeholder="Date Of Reg." type="date" required >
</div>
<div class="form-field d-flex align-items-center">
<input name="amt" class="form-control" placeholder="Amount" type="Text" required >
</div>
<button class="btn mt-3" name="submit">ADD</button>
</form>
</div>
</div> <!-- /.table-stats -->
</div>
<div class="col-xl-6">
<div class="card">
</div>
</div>
</div> <!-- /.card -->
</div> <!-- /.col-lg-8 -->
</div>
</div>
<!-- /.orders -->
<!-- To Do and Live Chat -->
<div class="row">
<div class="col-lg-12">
<div class="card">
<div class="card-body">
<h4 class="card-title box-title">Recent Sale</h4>
<div class="card-content">
<div class="todo-list">
<div class="tdl-holder">
<div class="tdl-content">
<table class="table ">
<thead>
<tr>
<th>S.No.</th>
<th class="serial">#</th>
<th class="avatar">TYPE</th>
<th>NAME</th>
<th>MAIL_ID</th>
<th>DATE</th>
<th>AMOUNT</th>
<th>ACTION</th>
</tr>
</thead>
<?php
include"connection.php";
$q="SELECT * FROM (
SELECT * FROM client ORDER BY aid DESC LIMIT 10
)Var1
ORDER BY aid DESC";
$sno=0;
$sq=mysqli_query($cn,$q);
while($r=mysqli_fetch_array($sq))
{
$sno++;
$invno=$r['aid'];
?>
<tbody>
<tr>
<td> <?php echo $sno; ?></td>
<td class="serial"><?php echo $r['invno']; ?> </td>
<td class="avatar">
<?php echo $r['type']; ?>
</td>
<td><?php echo $r['name']; ?> </td>
<td> <span class="name"><?php echo $r['email']; ?></span> </td>
<td> <span class="product"><?php echo $r['date']; ?></span> </td>
<td>$ <span class="count"><?php echo $r['amount']; ?></span></td>
<td>
<span class="badge badge-complete"><?php echo'<a href="adview.php?id='.$invno.'">'; echo'VIEW</a>'; ?></span>
</td>
</tr>
<?php
} ?>
</tbody>
</table>
</div>
</div>
</div> <!-- /.todo-list -->
</div>
</div> <!-- /.card-body -->
</div><!-- /.card -->
</div>
</div>
<!-- /To Do and Live Chat -->
<!-- Calender Chart Weather -->
<!-- /Calender Chart Weather -->
<!-- Modal - Calendar - Add New Event -->
<!-- /#event-modal -->
<!-- Modal - Calendar - Add Category -->
<!-- /#add-category -->
</div>
<!-- .animated -->
</div>
<!-- /.content -->
<div class="clearfix"></div>
<!-- Footer -->
<footer class="site-footer">
<div class="footer-inner bg-white">
<div class="row">
<div class="col-sm-6 text-right">
Copyright © 2023 OOT
</div>
<div class="col-sm-6 text-right">
Designed by <a href="">Ric</a>
</div>
</div>
</div>
</footer>
<!-- /.site-footer -->
</div>
<!-- /#right-panel -->
<!-- Scripts -->
<script src="https://cdn.jsdelivr.net/npm/jquery@2.2.4/dist/jquery.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.14.4/dist/umd/popper.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.1.3/dist/js/bootstrap.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/jquery-match-height@0.7.2/dist/jquery.matchHeight.min.js"></script>
<script src="assets/js/main.js"></script>
<!-- Chart js -->
<script src="https://cdn.jsdelivr.net/npm/chart.js@2.7.3/dist/Chart.bundle.min.js"></script>
<!--Chartist Chart-->
<script src="https://cdn.jsdelivr.net/npm/chartist@0.11.0/dist/chartist.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/chartist-plugin-legend@0.6.2/chartist-plugin-legend.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/jquery.flot@0.8.3/jquery.flot.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/flot-pie@1.0.0/src/jquery.flot.pie.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/flot-spline@0.0.1/js/jquery.flot.spline.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/simpleweather@3.1.0/jquery.simpleWeather.min.js"></script>
<script src="assets/js/init/weather-init.js"></script>
<script src="https://cdn.jsdelivr.net/npm/moment@2.22.2/moment.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/fullcalendar@3.9.0/dist/fullcalendar.min.js"></script>
<script src="assets/js/init/fullcalendar-init.js"></script>
<!--Local Stuff-->
<script>
jQuery(document).ready(function($) {
"use strict";
// Pie chart flotPie1
var piedata = [
{ label: "Desktop visits", data: [[1,32]], color: '#5c6bc0'},
{ label: "Tab visits", data: [[1,33]], color: '#ef5350'},
{ label: "Mobile visits", data: [[1,35]], color: '#66bb6a'}
];
$.plot('#flotPie1', piedata, {
series: {
pie: {
show: true,
radius: 1,
innerRadius: 0.65,
label: {
show: true,
radius: 2/3,
threshold: 1
},
stroke: {
width: 0
}
}
},
grid: {
hoverable: true,
clickable: true
}
});
// Pie chart flotPie1 End
// cellPaiChart
var cellPaiChart = [
{ label: "Direct Sell", data: [[1,65]], color: '#5b83de'},
{ label: "Channel Sell", data: [[1,35]], color: '#00bfa5'}
];
$.plot('#cellPaiChart', cellPaiChart, {
series: {
pie: {
show: true,
stroke: {
width: 0
}
}
},
legend: {
show: false
},grid: {
hoverable: true,
clickable: true
}
});
// cellPaiChart End
// Line Chart #flotLine5
var newCust = [[0, 3], [1, 5], [2,4], [3, 7], [4, 9], [5, 3], [6, 6], [7, 4], [8, 10]];
var plot = $.plot($('#flotLine5'),[{
data: newCust,
label: 'New Data Flow',
color: '#fff'
}],
{
series: {
lines: {
show: true,
lineColor: '#fff',
lineWidth: 2
},
points: {
show: true,
fill: true,
fillColor: "#ffffff",
symbol: "circle",
radius: 3
},
shadowSize: 0
},
points: {
show: true,
},
legend: {
show: false
},
grid: {
show: false
}
});
// Line Chart #flotLine5 End
// Traffic Chart using chartist
if ($('#traffic-chart').length) {
var chart = new Chartist.Line('#traffic-chart', {
labels: ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun'],
series: [
[0, 18000, 35000, 25000, 22000, 0],
[0, 33000, 15000, 20000, 15000, 300],
[0, 15000, 28000, 15000, 30000, 5000]
]
}, {
low: 0,
showArea: true,
showLine: false,
showPoint: false,
fullWidth: true,
axisX: {
showGrid: true
}
});
chart.on('draw', function(data) {
if(data.type === 'line' || data.type === 'area') {
data.element.animate({
d: {
begin: 2000 * data.index,
dur: 2000,
from: data.path.clone().scale(1, 0).translate(0, data.chartRect.height()).stringify(),
to: data.path.clone().stringify(),
easing: Chartist.Svg.Easing.easeOutQuint
}
});
}
});
}
// Traffic Chart using chartist End
//Traffic chart chart-js
if ($('#TrafficChart').length) {
var ctx = document.getElementById( "TrafficChart" );
ctx.height = 150;
var myChart = new Chart( ctx, {
type: 'line',
data: {
labels: [ "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul" ],
datasets: [
{
label: "Visit",
borderColor: "rgba(4, 73, 203,.09)",
borderWidth: "1",
backgroundColor: "rgba(4, 73, 203,.5)",
data: [ 0, 2900, 5000, 3300, 6000, 3250, 0 ]
},
{
label: "Bounce",
borderColor: "rgba(245, 23, 66, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(245, 23, 66,.5)",
pointHighlightStroke: "rgba(245, 23, 66,.5)",
data: [ 0, 4200, 4500, 1600, 4200, 1500, 4000 ]
},
{
label: "Targeted",
borderColor: "rgba(40, 169, 46, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(40, 169, 46, .5)",
pointHighlightStroke: "rgba(40, 169, 46,.5)",
data: [1000, 5200, 3600, 2600, 4200, 5300, 0 ]
}
]
},
options: {
responsive: true,
tooltips: {
mode: 'index',
intersect: false
},
hover: {
mode: 'nearest',
intersect: true
}
}
} );
}
//Traffic chart chart-js End
// Bar Chart #flotBarChart
$.plot("#flotBarChart", [{
data: [[0, 18], [2, 8], [4, 5], [6, 13],[8,5], [10,7],[12,4], [14,6],[16,15], [18, 9],[20,17], [22,7],[24,4], [26,9],[28,11]],
bars: {
show: true,
lineWidth: 0,
fillColor: '#ffffff8a'
}
}], {
grid: {
show: false
}
});
// Bar Chart #flotBarChart End
});
</script>
</body>
</html>