ppeasy/public/dashboard.php

378 lines
21 KiB
PHP

<?php
include('include/headscript.php');
if (isset($_SESSION["tempcode"])) {
unset($_SESSION["tempcode"]);
} ?>
<?php
$trfnumbersuser = new WA_MySQLi_RS("trfnumbersuser", $cmctrfdb, 1);
$trfnumbersuser->setQuery("SELECT * FROM `trf-details` WHERE `trf-details`.iduser='$iduserlogin'");
$trfnumbersuser->execute();
$numbertrfuser = $trfnumbersuser->TotalRows;
?>
<?php
$trfnumberpercompany = new WA_MySQLi_RS("trfnumberpercompany", $cmctrfdb, 1);
$trfnumberpercompany->setQuery("SELECT * FROM `trf-details` WHERE `trf-details`.idcompany='$idcompany'");
$trfnumberpercompany->execute(); ?>
<?php
$totalparts = new WA_MySQLi_RS("totalparts", $cmctrfdb, 1);
$totalparts->setQuery("SELECT * FROM identificationparts LEFT JOIN `trf-details` ON identificationparts.idtrfdetails=`trf-details`.idtrfdetails WHERE `trf-details`.iduser='$user'");
$totalparts->execute();
?><?php $totalpartstrf = $totalparts->TotalRows ?>
<?php
$numbertrfcompany = $trfnumberpercompany->TotalRows;
?>
<?php //search if any module 2 go
?>
<?php
$modulego = new WA_MySQLi_RS("modulego", $cmctrfdb, 0);
$modulego->setQuery("SELECT * FROM `trf-details` WHERE `trf-details`.iduser='$iduserlogin' AND `trf-details`.csgo='Y' AND `trf-details`.signedonsecondcert IS NULL");
$modulego->execute();
?>
<?php if (!empty($modulego->getColumnVal("csgo"))) {
$csgoyes = 'Y';
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title><?php echo $titlepage; ?> </title>
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta content="CIMAC TRF Portal" name="description" />
<meta content="" name="author" />
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<!-- App favicon -->
<link rel="shortcut icon" href="../images/favicon.ico">
<!--Form Wizard-->
<link href="../plugins/jquery-steps/jquery.steps.css" rel="stylesheet" type="text/css">
<!-- App css -->
<link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
<link href="assets/css/jquery-ui.min.css" rel="stylesheet">
<link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" />
<link href="assets/css/metisMenu.min.css" rel="stylesheet" type="text/css" />
<link href="assets/css/app.min.css" rel="stylesheet" type="text/css" />
<?php include('back.php'); ?>
</head>
<body>
<!-- Top Bar Start -->
<?php include('include/topbar.php'); ?>
<!-- Top Bar End -->
<!-- Left Sidenav -->
<?php include('include/leftsidenav.php'); ?>
<!-- end left-sidenav-->
<div class="page-wrapper">
<!-- Page Content-->
<div class="page-content">
<div class="container-fluid">
<!-- Page-Title -->
<div class="row">
<div class="col-sm-12">
<div class="page-title-box">
<div class="float-right">
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="javascript:void(0);"><?php echo $titlepage; ?></a></li>
<li class="breadcrumb-item active">Starter</li>
</ol>
</div>
<h4 class="page-title"><?php echo $titlewb; ?></h4>
</div><!--end page-title-box-->
</div><!--end col-->
</div>
<div class="row">
<div class="col-xl-12">
<div class="card">
<div class="card-body">
<div class="media">
<img src="upload/users/<?php echo $avatarname; ?>" alt="" class="thumb-md rounded-circle mr-2">
<div class="media-body align-self-center">
<h4 class="mt-0 mb-1"><?php echo $welcomeuser; ?><?php echo $nameuser; ?></h4>
<p class="text-muted mb-0 font-14 pr-5"><?php echo $welcome_help; ?></p>
</div><!--end media-body-->
</div><!--end media-->
</div><!--end card-body-->
</div><!--end card-->
<?php /*
//pannello secondo pdf
if (isset($csgoyes)) { ?>
<div class="card">
<div class="card-body">
<div class="media">
<div class="alert alert-outline-warning alert-warning-shadow mb-0 alert-dismissible fade show" role="alert">
<strong><?php echo $certification2list; ?></strong>
</div>
</div><!--end media-->
<br>
<div class="table-responsive-sm">
<table class="table mb-0">
<thead>
<tr>
<th scope="col"><?php echo $ntrf; ?></th>
<th scope="col"><?php echo $descriptionitem; ?></th>
<th scope="col"><?php echo $proceedmodule2; ?></th>
</tr>
</thead>
<tbody>
<?php
$wa_startindex = 0;
while(!$modulego->atEnd()) {
$wa_startindex = $modulego->Index;
?>
<tr>
<th scope="row"><?php echo($modulego->getColumnVal("trfnumber")); ?></th>
<td><?php echo($modulego->getColumnVal("sample_description")); ?></td>
<td>
<a class="badge_btn" href='adddocument2.php?idtrf=<?php echo($modulego->getColumnVal("idtrfdetails")); ?>'><i class="fas fa-angle-double-right text-primary font-20"></i></a></td>
</tr>
<?php
$modulego->moveNext();
}
$modulego->moveFirst(); //return RS to first record
unset($wa_startindex);
unset($wa_repeatcount);
?>
</tbody>
</table>
<!--end /table-->
</div>
</div><!--end card-body-->
</div><!--end card-->
<?php } */ ?>
<!--<div class="card">
<div class="card-body">
<h4 class="header-title mt-0"><?php echo $controlpanel; ?></h4>
<div id="CrmDashChart" class=""></div>
<a href="typeofcertificate.php?varcertificate=0&certotherclient=N"><button type="button" class="btn btn-primary waves-effect waves-light"><?php echo $newtrf; ?></button></a>
<a href="typeofcertificate.php?varcertificate=0&certotherclient=Y"><button type="button" class="btn btn-primary waves-effect waves-light"><?php echo $newtrfforclient; ?></button></a>
<br>
<br>
<br>
<a href="archivetrf.php"><button type="button" class="btn btn-secondary waves-effect waves-light"><?php echo $historicaltrf; ?></button></a>
<a href="downloadfile.php"><button type="button" class="btn btn-danger waves-effect waves-light"><?php echo $helpdocument; ?></button><br></a>
</div>
</div> -->
<div class="card" style="background-color: rgba(255, 255, 255, 0);">
<div class="card-body">
<div class="container-fluid py-3" style="background-color: #ffffff; border-radius: 12px;">
<div class="row text-center">
<!-- Card 1 -->
<div class="col-lg-4 mb-4">
<a href="typeofcertificate.php?varcertificate=0&certotherclient=N" class="card shadow-sm border-0 text-decoration-none hover-effect"
style="background-color: #EFBC86; border-radius: 12px; transition: transform 0.3s ease, box-shadow 0.3s ease;">
<div class="card-body d-flex align-items-center justify-content-center py-4">
<i class="fas fa-file-alt fa-2x text-primary me-3"></i>
<h4 class="card-title text-dark fw-bold mb-0"><?php echo $newtrf; ?></h4>
</div>
</a>
</div>
<!-- Card 2 -->
<div class="col-lg-4 mb-4">
<a href="typeofcertificate.php?varcertificate=0&certotherclient=Y" class="card shadow-sm border-0 text-decoration-none hover-effect"
style="background-color: #fde8e8; border-radius: 12px; transition: transform 0.3s ease, box-shadow 0.3s ease;">
<div class="card-body d-flex align-items-center justify-content-center py-4">
<i class="fas fa-user-friends fa-2x text-danger me-3"></i>
<h4 class="card-title text-dark fw-bold mb-0"><?php echo $newtrfforclient; ?></h4>
</div>
</a>
</div>
<!-- Card 3 -->
<div class="col-lg-4 mb-4">
<a href="#" class="card shadow-sm border-0 text-decoration-none hover-effect"
style="background-color: #e8f5e9; border-radius: 12px; transition: transform 0.3s ease, box-shadow 0.3s ease;">
<div class="card-body d-flex align-items-center justify-content-center py-4">
<i class="fas fa-cogs fa-2x text-success me-3"></i>
<h4 class="card-title text-dark fw-bold mb-0"><?php echo $techdossier; ?></h4>
</div>
</a>
</div>
</div>
<div class="row text-center">
<!-- Card 4 -->
<div class="col-lg-4 mb-4">
<a href="archivetrf.php" class="card shadow-sm border-0 text-decoration-none hover-effect"
style="background-color: #fff3e0; border-radius: 12px; transition: transform 0.3s ease, box-shadow 0.3s ease;">
<div class="card-body d-flex align-items-center justify-content-center py-4">
<i class="fas fa-archive fa-2x text-warning me-3"></i>
<h4 class="card-title text-dark fw-bold mb-0"><?php echo $historicaltrf; ?></h4>
</div>
</a>
</div>
<!-- Card 5 -->
<div class="col-lg-4 mb-4">
<a href="downloadfile.php" class="card shadow-sm border-0 text-decoration-none hover-effect"
style="background-color: #ede7f6; border-radius: 12px; transition: transform 0.3s ease, box-shadow 0.3s ease;">
<div class="card-body d-flex align-items-center justify-content-center py-4">
<i class="fas fa-question-circle fa-2x text-purple me-3"></i>
<h4 class="card-title text-dark fw-bold mb-0"><?php echo $helpdocument; ?></h4>
</div>
</a>
</div>
<!-- Card 6 -->
<div class="col-lg-4 mb-4">
<a href="#" class="card shadow-sm border-0 text-decoration-none hover-effect"
style="background-color: #fbe9e7; border-radius: 12px; transition: transform 0.3s ease, box-shadow 0.3s ease;">
<div class="card-body d-flex align-items-center justify-content-center py-4">
<i class="fas fa-archive fa-2x text-danger me-3"></i>
<h4 class="card-title text-dark fw-bold mb-0"><?php echo $techdossierark; ?></h4>
</div>
</a>
</div>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-sm-3">
<div class="card crm-data-card">
<div class="card-body">
<div class="row">
<div class="col-4 align-self-center">
<div class="icon-info">
<i class="far fa-user rounded-circle bg-soft-success"></i>
</div>
</div><!-- end col-->
<div class="col-8 text-right">
<p class="text-muted font-14"><?php echo $numbertrfusertitle; ?></p>
<h3 class="mb-0"><?php echo $numbertrfuser; ?></h3>
</div><!-- end col-->
</div><!-- end row-->
</div><!--end card-body-->
</div><!--end card-->
</div><!--end col-->
<div class="col-sm-3">
<div class="card crm-data-card">
<div class="card-body">
<div class="row">
<div class="col-4 align-self-center">
<div class="icon-info">
<i class="fas fa-chess-rook rounded-circle bg-soft-pink"></i>
</div>
</div><!-- end col-->
<div class="col-8 text-right">
<p class="text-muted font-14"><?php echo $numbertrfcompanytitle; ?></p>
<h3 class="mb-0"><?php echo $numbertrfcompany; ?></h3>
</div><!-- end col-->
</div><!-- end row-->
</div><!--end card-body-->
</div><!--end card-->
</div><!--end col-->
<div class="col-sm-3">
<div class="card crm-data-card">
<div class="card-body">
<div class="row">
<div class="col-4 align-self-center">
<div class="icon-info">
<i class="fas fa-angle-double-up rounded-circle bg-soft-purple"></i>
</div>
</div><!-- end col-->
<div class="col-8 text-right">
<p class="text-muted font-14"><?php echo $partsnumbertitle; ?></p>
<h3 class="mb-0"><?php echo $totalpartstrf; ?></h3>
</div><!-- end col-->
</div><!-- end row-->
</div><!--end card-body-->
</div><!--end card-->
</div><!--end col-->
<div class="col-sm-3">
<div class="card crm-data-card">
<div class="card-body">
<div class="row">
<div class="col-4 align-self-center">
<div class="icon-info">
<i class="far fa-registered rounded-circle bg-soft-warning"></i>
</div>
</div><!-- end col-->
<div class="col-8 text-right">
<p class="text-muted font-14">xxx</p>
<h3 class="mb-0">-</h3>
</div><!-- end col-->
</div><!-- end row-->
</div><!--end card-body-->
</div><!--end card-->
</div><!--end col-->
</div><!--end row-->
</div>
</div>
<!-- end page title end breadcrumb -->
</div><!-- container -->
<!-- footer start -->
<?php include('include/footer.php'); ?>
</footer><!--end footer-->
</div>
<!-- end page content -->
</div>
<!-- end page-wrapper -->
<!-- jQuery -->
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/bootstrap.bundle.min.js"></script>
<script src="assets/js/metismenu.min.js"></script>
<script src="assets/js/waves.js"></script>
<script src="assets/js/feather.min.js"></script>
<script src="assets/js/jquery.slimscroll.min.js"></script>
<script src="assets/js/jquery-ui.min.js"></script>
<script src="../plugins/jquery-steps/jquery.steps.min.js"></script>
<script src="assets/pages/jquery.form-wizard.init.js"></script>
<!-- App js -->
<script src="assets/js/app.js"></script>
</body>
</html>