<?php 

// error_reporting(E_ALL);
// ini_set('display_errors', 1);

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

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

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

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

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

//Create object $commonFunction for class commonFunction
$commonFunction=new commonFunction();
$council_file_ = $commonFunction->get_council_file($db_class);
$total_no_offiles = $council_file_[0];   //Get the no of concil uploaded file
$council_file_data = $council_file_[1];
//echo $total_no_offiles;
//exit();
?>


<!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 :: Tenders</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>TENDERS</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">
                    Tenders</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 ($file_details = $db_class->fetch_array($council_file_data))
                      {
                        $dateValue = $file_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= "../council_fileupload";    //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="#">
                                      <?php echo $file_details['file_description']; ?>
                                  </a>
                                  <div class="action pull-right">
                                      <a href="council_fileupload/<?php echo $file_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 $file_details["file_name"];?>');" class="btn btn-primary btn-xs" title="Download"> 
                                       Download
                                      </a>
                                      <!-- complete download file code by manas -->
                                  </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>