<?php 

//include databse cofig file for database connection by manas date 27-04-2016
include("database/config.php"); 

//require common database class file for query execute by manas date 27-04-2016
require_once("common/database.class.php");

//create object for DBController class by manas date 27-04-2016
$db_handle = new DBController();

//create object for common class by manas date 27-04-2016  
$db_class = new common();

//include common function to get the quotation file details
include('function/common.function.php');

//Create object $commonFunction for class commonFunction
$commonFunction=new commonFunction();
$per_rev_file = $commonFunction->get_per_revision_report($db_class);
$total_no_offiles = $per_rev_file[0];   //Get the no of concil uploaded file
$per_rev_file_data = $per_rev_file[1];

?>



<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <meta name="description" content="">
  <meta name="author" content="">
  <title>Baripada Municipality :: Periodic Revision Of Building Bye Law</title>
  <link href="css/bootstrap.min.css" rel="stylesheet">
  <link href="css/animate.min.css" rel="stylesheet"> 
  <link href="css/font-awesome.min.css" rel="stylesheet">
  <link href="css/lightbox.css" rel="stylesheet">
  <link id="css-preset" href="css/presets/preset2.css" rel="stylesheet">
  <link href="css/main.css" rel="stylesheet">
  <link href="css/responsive.css" rel="stylesheet">

  <!--[if lt IE 9]>
    <script src="commonjs/html5shiv.js"></script>
    <script src="commonjs/respond.min.js"></script>
  <![endif]-->
  
  <!-- <link href='https://fonts.googleapis.com/css?family=Open+Sans:300,400,600,700' rel='stylesheet' type='text/css'> -->
  <link rel="shortcut icon" href="image/favicon.ico">
</head><!--/head-->

<body id="gallery">

  <!--.preloader-->
  <div class="preloader"> <img src="image/loading.gif"></div>
  <!--/.preloader-->

  <header>
    
    
    <?php include('html/header.php'); ?>
        
    <div id="gallery-banner" class="page-banner text-center">
      <div class="container-fluid">
         <h1>REVISION</h1>                   
      </div>
    </div><!--/#home-slider-->
  </header><!--/#home-->
  
  <section id="resolution">
    
    <div class="container">
      <div class="row">
        <div class="panel panel-default widget">
            <div class="panel-heading">
                
                <h3 class="panel-title"> Periodic Revision Of Building Bye Law</h3>
                <?php 
                if ($total_no_offiles>0)
                  {
                ?>
                <span class="label label-info"><?php echo $total_no_offiles;?></span>
                <?php
                  }
                ?>  
                      
            </div>
            <div class="panel-body">
                <ul class="list-group">
                    
                <!-- fetch loop starts here by manas date 13-02-2016 -->
                    <?php 
                      if ($total_no_offiles>0)
                        {
                        while ($per_rev_details = $db_class->fetch_array($per_rev_file_data))
                          {
                          $dateValue = $per_rev_details['upload_date'];
                          //Below object will calculate the day,month and year from common function page get_date_value function
                          $calculate_date = $commonFunction->get_date_value($dateValue);
                          $day_value = $calculate_date[0];              //day value
                          $month_value = $calculate_date[1];            //Month name
                          $year_value = $calculate_date[2];             //Year value
                          $path_file= "../per_revision";    //Path to the file directory for ajax function only
                    ?>
                    
                        <li class="list-group-item">
                          <div class="row">
                            <div class="hidden-xs hidden-sm col-md-1">
                              <img src="image/pdf_prvw.jpg" class="img-circle img-responsive" alt="" />
                            </div>
                            <div class="col-xs-3 col-sm-2 col-md-1">
                              <div class="date"><?php echo $day_value; ?> <span><?php echo $month_value; ?></span> <?php echo $year_value; ?></div>
                            </div>
                            <div class="col-xs-9 col-sm-10 col-md-10">
                              <div>
                                  <a href="#">
                                      <!-- Statement showing the Demand,Collection &amp; Balance from the year 2013-14 to 2015-16 -->
                                      <?php echo $per_rev_details['file_description']; ?>
                                  </a>
                                  <div class="action pull-right">
                                      <a href="per_revision/<?php echo $per_rev_details['file_name'];?>" class="btn btn-primary btn-xs" title="View" target="_blank"> 
                                        View
                                      </a>
                                      
                                      <!-- download file function which written in commonjs/ajax.common.js file by manas  -->
                                      <a href="#" onclick="file_force_download('<?php echo $path_file; ?>','<?php echo $per_rev_details["file_name"];?>');" class="btn btn-primary btn-xs" title="Download"> 
                                       Download
                                      </a>
                                      
                                  </div>
                                  <!-- <div class="mic-info">
                                      <a href="#">Dept Name if needed</a> on 2 Aug 2013
                                  </div> -->
                              </div>
                            </div>
                          </div>
                        </li>
                      <?php 
                      } 
                      }
                      ?>
                    
                    <!-- fetch loop ends here -->
                </ul>
                
            </div>
        </div>        
      </div>
    </div>
    <div id="portfolio-single-wrap">
      <div id="portfolio-single">
      </div>
    </div><!-- /#portfolio-single-wrap -->
  </section><!--/#portfolio-->
  
  <?php include('html/footer.php'); ?>

  <script type="text/javascript" src="commonjs/jquery.js"></script>
  <script type="text/javascript" src="commonjs/bootstrap.min.js"></script>
  <script type="text/javascript" src="commonjs/jquery.inview.min.js"></script>
  <script type="text/javascript" src="commonjs/wow.min.js"></script>
  <script type="text/javascript" src="commonjs/mousescroll.js"></script>
  <script type="text/javascript" src="commonjs/smoothscroll.js"></script>
  <script type="text/javascript" src="commonjs/jquery.countTo.js"></script>
  <script type="text/javascript" src="commonjs/lightbox.min.js"></script>
  <script type="text/javascript" src="commonjs/ajax.common.js"></script>
  <script type="text/javascript" src="commonjs/main.js"></script>
  <script>
    $(document).ready(function() {
      $('#Carousel').carousel({
          interval: 5000
      })
  });
  </script>

</body>
</html>