API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 25th, 2016
201
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 14.48 KB | None | 0 0
raw download clone embed print report
  1. [/PHP]
  2.  
  3. Pagina Index:
  4.  
  5. [PHP]
  6.  <?php
  7. //creo la sessione
  8. //in TUTTE le pagine in cui uso le sessioni
  9.   session_start ();
  10. ?>
  11. <?php
  12. //verifico l'esistenza delle sessioni
  13. if((!isset($_SESSION['user'])) || !isset($_SESSION['pwd']) ){
  14.     //le sessioni non esistono per cui riinvio al login (o alla pagina che voglio)
  15.     @header('Location:login.php');
  16. }
  17. ?><!DOCTYPE html>
  18. <html>
  19.   <head>
  20.     <meta charset="UTF-8">
  21.     <title>Sinistri Edilfar Rent | Dashboard</title>
  22.     <!-- Tell the browser to be responsive to screen width -->
  23.     <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
  24.     <!-- Bootstrap 3.3.4 -->
  25.     <link href="bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
  26.     <!-- FontAwesome 4.3.0 -->
  27.     <link href="https://maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" rel="stylesheet" type="text/css" />
  28.     <!-- Ionicons 2.0.0 -->
  29.     <link href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css" rel="stylesheet" type="text/css" />
  30.     <!-- Theme style -->
  31.     <link href="dist/css/AdminLTE.min.css" rel="stylesheet" type="text/css" />
  32.     <!-- AdminLTE Skins. Choose a skin from the css/skins
  33.          folder instead of downloading all of them to reduce the load. -->
  34.     <link href="dist/css/skins/_all-skins.min.css" rel="stylesheet" type="text/css" />
  35.     <!-- iCheck -->
  36.     <link href="plugins/iCheck/flat/blue.css" rel="stylesheet" type="text/css" />
  37.     <!-- Morris chart -->
  38.     <link href="plugins/morris/morris.css" rel="stylesheet" type="text/css" />
  39.     <!-- jvectormap -->
  40.     <link href="plugins/jvectormap/jquery-jvectormap-1.2.2.css" rel="stylesheet" type="text/css" />
  41.     <!-- Date Picker -->
  42.     <link href="plugins/datepicker/datepicker3.css" rel="stylesheet" type="text/css" />
  43.     <!-- Daterange picker -->
  44.     <link href="plugins/daterangepicker/daterangepicker-bs3.css" rel="stylesheet" type="text/css" />
  45.     <!-- bootstrap wysihtml5 - text editor -->
  46.     <link href="plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.min.css" rel="stylesheet" type="text/css" />
  47.  
  48.     <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
  49.     <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
  50.     <!--[if lt IE 9]>
  51.         <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
  52.         <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
  53.     <![endif]-->
  54.   </head>
  55.   <body class="skin-blue sidebar-mini">
  56.     <div class="wrapper">
  57.  
  58.       <header class="main-header">
  59.         <!-- Logo -->
  60.         <a href="index_user.php" class="logo">
  61.           <!-- mini logo for sidebar mini 50x50 pixels -->
  62.           <span class="logo-mini">SX</span>
  63.           <!-- logo for regular state and mobile devices -->
  64.           <span class="logo-lg">Gestione Sinistri</span>
  65.         </a>
  66.         <!-- Header Navbar: style can be found in header.less -->
  67.         <nav class="navbar navbar-static-top" role="navigation">
  68.           <!-- Sidebar toggle button-->
  69.           <a href="#" class="sidebar-toggle" data-toggle="offcanvas" role="button">
  70.             <span class="sr-only">Toggle navigation</span>
  71.           </a>
  72. </nav></header>          
  73.       <!-- Left side column. contains the logo and sidebar -->
  74.       <aside class="main-sidebar">
  75.         <!-- sidebar: style can be found in sidebar.less -->
  76.         <section class="sidebar">
  77.           <!-- Sidebar user panel -->
  78.           <div class="user-panel">
  79.              <!-- IMMAGINE PROFILO -->
  80.             <div class="pull-left image">
  81.             <?php
  82.             if ($_SESSION['user'] == 'Notarangelo'){
  83.               echo '<img src="dist/img/notarangelo.jpg" class="img-circle" alt="User Image" />';
  84.             } else {
  85.                 if ($_SESSION['user'] == 'XXX')
  86.               echo '<img src="dist/img/XXX.jpg" class="img-circle" alt="User Image" />';
  87.             }
  88.             if ($_SESSION['user'] != 'Notarangelo'){
  89.               echo '<img src="dist/img/avatar2.png" class="img-circle" alt="User Image" />';} else {
  90.                  if ($_SESSION['user'] != 'XXX')
  91.               echo '<img src="dist/img/avatar2.png" class="img-circle" alt="User Image" />';
  92.             }
  93.              ?>
  94.             </div>
  95.             <div class="pull-left info">
  96.               <?php echo $_SESSION['user'].'<br>'.$_SESSION['stazioneuser'];
  97.     $_SESSION['stazioneuser']=$stazioneuser;  ?>
  98.               <br><br>
  99.             </div>
  100.           </div>
  101.           <!-- search form -->
  102.           <form action="ricerca_pratica.php" method="post" class="sidebar-form">
  103.             <div class="input-group">
  104.               <input type="text" name="cerca" class="form-control" placeholder="Search..." />
  105.               <span class="input-group-btn">
  106.                 <button type="submit" name="search" id="search-btn" class="btn btn-flat"  onclick="location.href='ricerca_pratica.php'"><i class="fa fa-search"></i></button>
  107.               </span>
  108.             </div>
  109.           </form>
  110.           <!-- /.search form -->
  111.           <!-- sidebar menu: : style can be found in sidebar.less -->
  112.           <ul class="sidebar-menu">
  113.             <li class="header">MAIN MENU</li>
  114.             <li>
  115.               <a href="index_user.php">
  116.             <i class="fa fa-th"></i> <span>Dashboard</span></a></li>
  117.             <li>
  118.               <a href="insert_pratica_user.php">
  119.                 <i class="fa fa-edit"></i> <span>Inserisci Pratica</span>
  120.             </a></li>
  121.             <li>
  122.               <a href="visualizza.php">
  123.                 <i class="fa fa-folder"></i> <span>Visualizza Pratiche</span>
  124.               </a>
  125.             </li>
  126.           </ul>
  127.         </section>
  128.         <!-- /.sidebar -->
  129.       </aside>
  130.  
  131.       <!-- Content Wrapper. Contains page content -->
  132.       <div class="content-wrapper">
  133.         <!-- Content Header (Page header) -->
  134.         <section class="content-header">
  135.           <h1>
  136.             Dashboard
  137.             <small>Control panel</small>
  138.           </h1>
  139.           <ol class="breadcrumb">
  140.             <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
  141.             <li class="active">Dashboard</li>
  142.           </ol>
  143.         </section>
  144.  
  145.         <!-- Main content -->
  146.         <section class="content">
  147.           <!-- Small boxes (Stat box) -->
  148.           <div class="row">
  149.             <div class="col-lg-3 col-xs-6">
  150.               <!-- small box -->
  151.               <div class="small-box bg-aqua">
  152.                 <div class="inner">
  153.                 <?php
  154.                 include ('connect.php');
  155. $query = mysql_query("SELECT COUNT(NContratto) FROM anagrafica_sinistri WHERE Stazione ='$stazioneuser' ") or die("Query non valida: " . mysql_error());
  156. while($row = mysql_fetch_array($query)){
  157.     $totpratiche=$row['COUNT(NContratto)'];
  158.     //echo "Ci sono ". $row['COUNT(NContratto)'] ." contratti nel database...";
  159. }                  
  160. ?>
  161.                  <?php echo '<h3>'.$totpratiche.'</h3>'; ?>
  162.                   <p>Totale Pratiche</p>
  163.                 </div>
  164.                 <div class="icon">
  165.                   <i class="ion ion-bag"></i>
  166.                 </div>
  167.                 <a href="#" class="small-box-footer">Maggiori Informazioni <i class="fa fa-arrow-circle-right"></i></a>
  168.               </div>
  169.             </div><!-- ./col -->
  170.             <div class="col-lg-3 col-xs-6">
  171.               <!-- small box -->
  172.               <div class= "small-box bg-yellow">
  173.                 <div class="inner">
  174.                 <?php
  175.                 include ('connect.php');
  176. $query = mysql_query ("SELECT COUNT(DISTINCT sinistri.Ncontratto) AS Conta, anagrafica_sinistri.NContratto,sinistri.NContratto,sinistri.Stato FROM anagrafica_sinistri INNER JOIN sinistri ON anagrafica_sinistri.NContratto = sinistri.NContratto WHERE sinistri.Stato = 'EMAIL SINISTRO' AND anagrafica_sinistri.Stazione = '$stazioneuser'")or die("Query non valida: " . mysql_error());
  177.  
  178. /*$query = mysql_query("SELECT COUNT(NContratto) FROM sinistri WHERE Stato ='EMAIL SINISTRO' AND ") or die("Query non valida: " . mysql_error());*/
  179. while($row = mysql_fetch_array($query)){
  180.     $pratichenuove=$row['Conta'];
  181.     //echo "Ci sono ". $row['COUNT(NContratto)'] ." contratti nel database...";
  182. }  
  183. ?>
  184.                   <?php echo '<h3>'.$pratichenuove.'</h3>'; ?>
  185.                   <p>Pratiche Nuove</p>
  186.                 </div>
  187.                 <div class="icon">
  188.                   <i class="ion ion-person-add"></i>
  189.                 </div>
  190.                 <a href="#" class="small-box-footer">Maggiori Informazioni <i class="fa fa-arrow-circle-right"></i></a>
  191.               </div>
  192.             </div><!-- ./col -->
  193.             <div class="col-lg-3 col-xs-6">
  194.               <!-- small box -->
  195.               <div class="small-box bg-green">
  196.                 <div class="inner">
  197.                  <?php
  198.                 include ('connect.php');
  199. $query = mysql_query ("SELECT COUNT(DISTINCT sinistri.Ncontratto) AS Conta, anagrafica_sinistri.NContratto,sinistri.NContratto,sinistri.Stato FROM anagrafica_sinistri INNER JOIN sinistri ON anagrafica_sinistri.NContratto = sinistri.NContratto WHERE sinistri.Stato !='PRATICA CONCLUSA' AND anagrafica_sinistri.Stazione = '$stazioneuser'") or die("Query non valida: " . mysql_error());
  200. /*$query = mysql_query("SELECT COUNT(NContratto) FROM sinistri WHERE Stato !='EMAIL SINISTRO' AND Stato!='PRATICA CONCLUSA'") or die("Query non valida: " . mysql_error());*/
  201. while($row = mysql_fetch_array($query)){
  202.     $pratichelavorazione=$row['Conta'];
  203.     //echo "Ci sono ". $row['COUNT(NContratto)'] ." contratti nel database...";
  204. }                  
  205. ?>
  206.                   <?php echo '<h3>'.$pratichelavorazione.'</h3>'; ?>
  207.                   <p>Pratiche in Lavorazione</p>
  208.                 </div>
  209.                 <div class="icon">
  210.                   <i class="ion ion-stats-bars"></i>
  211.                 </div>
  212.                 <a href="#" class="small-box-footer">Maggiori Informazioni <i class="fa fa-arrow-circle-right"></i></a>
  213.               </div>
  214.             </div><!-- ./col -->
  215.             <div class="col-lg-3 col-xs-6">
  216.               <!-- small box -->
  217.               <div class="small-box bg-red">
  218.                 <div class="inner">
  219.                 <?php
  220.                 include ('connect.php');
  221. $query = mysql_query ("SELECT COUNT(DISTINCT sinistri.Ncontratto) AS Conta, anagrafica_sinistri.NContratto,sinistri.NContratto,sinistri.Stato FROM anagrafica_sinistri INNER JOIN sinistri ON anagrafica_sinistri.NContratto = sinistri.NContratto WHERE sinistri.Stato ='PRATICA CONCLUSA' AND anagrafica_sinistri.Stazione = '$stazioneuser'") or die("Query non valida: " . mysql_error());
  222.  
  223.  
  224. /*$query = mysql_query("SELECT COUNT(NContratto) FROM sinistri WHERE Stato ='PRATICA CONCLUSA'") or die("Query non valida: " . mysql_error());*/
  225. while($row = mysql_fetch_array($query)){
  226.     $praticheconcluse=$row['Conta'];
  227.     //echo "Ci sono ". $row['COUNT(NContratto)'] ." contratti nel database...";
  228. }                  
  229. ?>
  230.                  <?php echo '<h3>'.$praticheconcluse.'</h3>'; ?>
  231.                   <p>Pratiche Concluse</p>
  232.                 </div>
  233.                 <div class="icon">
  234.                   <i class="ion ion-pie-graph"></i>
  235.                 </div>
  236.                 <a href="#" class="small-box-footer">Maggiori Informazioni <i class="fa fa-arrow-circle-right"></i></a>
  237.               </div>
  238.             </div><!-- ./col -->
  239.           </div><!-- /.row -->
  240.           <!-- Main row -->
  241.           <div class="row">
  242.             <!-- Left col -->
  243.             <section class="col-lg-7 connectedSortable">
  244.               <!-- Custom tabs (Charts with tabs)-->
  245.             </section><!-- /.Left col -->
  246.             <!-- right col (We are only adding the ID to make the widgets sortable)-->
  247.             <section class="col-lg-5 connectedSortable">
  248.             </section><!-- right col -->
  249.           </div><!-- /.row (main row) -->
  250.  
  251.         </section><!-- /.content -->
  252.       </div><!-- /.content-wrapper -->
  253.       <footer class="main-footer">
  254.         <div class="pull-right hidden-xs">
  255.           <b>Version</b> 1.0
  256.         </div>
  257.         <strong>Copyright &copy; 2015-2016 <a href="http://solutionslab.it/index.php">Solutions Lab &copy;</a>.</strong> Tutti i diritti riservati.
  258.       </footer>
  259.     <!-- jQuery 2.1.4 -->
  260.     <script src="plugins/jQuery/jQuery-2.1.4.min.js"></script>
  261.     <!-- jQuery UI 1.11.4 -->
  262.     <script src="https://code.jquery.com/ui/1.11.4/jquery-ui.min.js" type="text/javascript"></script>
  263.     <!-- Resolve conflict in jQuery UI tooltip with Bootstrap tooltip -->
  264.     <script type="text/javascript">
  265.       $.widget.bridge('uibutton', $.ui.button);
  266.     </script>
  267.     <!-- Bootstrap 3.3.2 JS -->
  268.     <script src="bootstrap/js/bootstrap.min.js" type="text/javascript"></script>
  269.     <!-- Morris.js charts -->
  270.     <script src="https://cdnjs.cloudflare.com/ajax/libs/raphael/2.1.0/raphael-min.js"></script>
  271.     <script src="plugins/morris/morris.min.js" type="text/javascript"></script>
  272.     <!-- Sparkline -->
  273.     <script src="plugins/sparkline/jquery.sparkline.min.js" type="text/javascript"></script>
  274.     <!-- jvectormap -->
  275.     <script src="plugins/jvectormap/jquery-jvectormap-1.2.2.min.js" type="text/javascript"></script>
  276.     <script src="plugins/jvectormap/jquery-jvectormap-world-mill-en.js" type="text/javascript"></script>
  277.     <!-- jQuery Knob Chart -->
  278.     <script src="plugins/knob/jquery.knob.js" type="text/javascript"></script>
  279.     <!-- daterangepicker -->
  280.     <script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.10.2/moment.min.js" type="text/javascript"></script>
  281.     <script src="plugins/daterangepicker/daterangepicker.js" type="text/javascript"></script>
  282.     <!-- datepicker -->
  283.     <script src="plugins/datepicker/bootstrap-datepicker.js" type="text/javascript"></script>
  284.     <!-- Bootstrap WYSIHTML5 -->
  285.     <script src="plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.all.min.js" type="text/javascript"></script>
  286.     <!-- Slimscroll -->
  287.     <script src="plugins/slimScroll/jquery.slimscroll.min.js" type="text/javascript"></script>
  288.     <!-- FastClick -->
  289.     <script src="plugins/fastclick/fastclick.min.js" type="text/javascript"></script>
  290.     <!-- AdminLTE App -->
  291.     <script src="dist/js/app.min.js" type="text/javascript"></script>
  292.     <!-- AdminLTE dashboard demo (This is only for demo purposes) -->
  293.     <script src="dist/js/pages/dashboard.js" type="text/javascript"></script>
  294.     <!-- AdminLTE for demo purposes -->
  295.     <script src="dist/js/demo.js" type="text/javascript"></script>
  296.   </body>
  297. </html>
  298.  
  299. [/PHP]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!