Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <div id="tabs" >
- <ul>
- <?php $counter = 1;?>
- <?php $Data_counter = 1;?>
- <?php foreach($history as $places):?>
- <li class="formfield" ><a href="#tabs-<?php echo $counter++ ?>" data-function-id="<?php echo $Data_counter++?>"><?php echo $places['place_name'] ?></a></li>
- <?php endforeach; ?>
- <li><a href="#tabs-search">Search Filter</a></li>
- </ul>
- <?php $tab_counter = 1;?>
- <?php $table_counter = 1;?>
- <?php $canvas_counter = 1;?>
- <?php foreach($history as $places):?>
- <div id="tabs-<?php echo $tab_counter++ ?>">
- <div class="content">
- <div class="container-fluid">
- <div class="col-md-3" style="border:1px solid;">
- <div class="box-wrapper">
- <div class="box">
- <h6 class="text-center">Total Place <?php //echo $places['place_name']?></h6>
- <p class="count_wrapper text-center"><?php echo $places['Total_parking']; ?> </p>
- </div>
- </div>
- </div>
- <div class="col-md-3" style="border:1px solid;">
- <div class="box-wrapper">
- <div class="box">
- <h6 class="text-center">Total Earning <?php //echo $places['place_name']?></h6>
- <?php $place = $places['place_name'];?>
- <?php $earning_query = $this->db->query("SELECT SUM(price) AS TotalEarning FROM end_live_parking WHERE place_name='$place'");?>
- <?php $total_earning = $earning_query->result()[0]->TotalEarning;?>
- <p class="count_wrapper text-center"><?php echo number_format($total_earning,2, '.', ''); ?> TAKA </p>
- </div>
- </div>
- </div>
- <div class="col-md-3" style="border:1px solid;">
- <div class="box-wrapper">
- <div class="box">
- <h6 class="text-center">Total Car</h6>
- <?php $earning_query = $this->db->query("SELECT COUNT(id) AS TotalCar FROM end_live_parking WHERE place_name='$place' AND type='Car'");?>
- <?php $total_car = $earning_query->result()[0]->TotalCar;?>
- <p class="count_wrapper text-center"><?php echo $total_car; ?> </p>
- </div>
- </div>
- </div>
- <div class="col-md-3" style="border:1px solid;">
- <div class="box-wrapper">
- <div class="box">
- <h6 class="text-center">Total Bike</h6>
- <?php $earning_query = $this->db->query("SELECT COUNT(id) AS TotalBike FROM end_live_parking WHERE place_name='$place' AND type='Bike'");?>
- <?php $total_bike = $earning_query->result()[0]->TotalBike;?>
- <p class="count_wrapper text-center"><?php echo $total_bike; ?> </p>
- </div>
- </div>
- </div>
- <br>
- <hr>
- <div class="col-md-12">
- <?php echo form_open('User_track/parking_history',array('method' => 'get'))?>
- <h1>Recurrent User Filter</h1>
- <div class="form-group">
- <label for="">Date Start</label>
- <input type="date" class="form-control" name="selected_date_start" id="selected_date_start" style="border:1px solid">
- </div>
- <div class="form-group">
- <label for="">Date End</label>
- <input type="date" class="form-control" name="selected_date_end" id="selected_date_end" style="border:1px solid">
- <input type="hidden" name="place_name" value="<?php echo $places['place_name']?>">
- </div>
- <div class="form-group">
- <!-- <a href="javascript:GetSearchValues();" type="button" id="searchBtn" class="btn btn-default">Get Result</a> -->
- <input type="submit" class="btn btn-default" value="Get Result" name="reccurent">
- </div>
- <?php echo form_close(); ?>
- </div>
- <?php if(!empty($check)):?>
- <div class="col-md-12">
- <h3><?php if(isset($date_range) || $date_range > 0) echo $date_range?></h3>
- <h3><?php if(isset($total_user) || $total_user > 0) echo $total_user?></h3>
- <h3><?php if(isset($recurreing_user) || $recurreing_user > 0) echo $recurreing_user?></h3>
- <h3><?php if(isset($non_recurring_user) || $non_recurring_user > 0) echo $non_recurring_user?></h3>
- </div>
- <?php endif; ?>
- <br>
- <div class="col-md-12">
- <?php echo form_open('User_track/parking_history',array('method' => 'get'))?>
- <h1>User Filter</h1>
- <div class="form-group">
- <label for="">Date Start</label>
- <input type="date" class="form-control" name="date_start" id="date_start" style="border:1px solid">
- </div>
- <div class="form-group">
- <label for="">Date End</label>
- <input type="date" class="form-control" name="date_end" id="date_end" style="border:1px solid">
- <input type="hidden" name="place_name" value="<?php echo $places['place_name']?>">
- </div>
- <div class="form-group">
- <!-- <a href="javascript:GetSearchValues();" type="button" id="searchBtn" class="btn btn-default">Get Result</a> -->
- <input type="submit" class="btn btn-default" value="Get Result" name="reccurent-all-time">
- </div>
- <?php echo form_close(); ?>
- </div>
- <?php if(!empty($checks)):?>
- <div class="col-md-12">
- <!-- <h3><?php //if(isset($date_ranges) || $date_ranges > 0) //echo $date_ranges?></h3> -->
- <h3><?php if(isset($total_users) || $total_users > 0) echo $total_users?></h3>
- <h3><?php if(isset($recurreing_user_all) || $recurreing_user_all > 0) echo $recurreing_user_all?></h3>
- <h3><?php if(isset($non_recurring_users) || $non_recurring_users > 0) echo $non_recurring_users?></h3>
- </div>
- <?php endif; ?>
- <div class="col-md-12">
- <h3>Parking History</h3>
- <div class="content">
- <div class="container-fluid">
- <div class="row">
- <div class="col-md-12">
- <div class="card">
- <div class="header">
- <h4 class="title">Chart (Testing)</h4>
- </div>
- <canvas id="myChart-<?php echo $canvas_counter++;?>" width="400" height="200"></canvas>
- </div>
- </div>
- </div>
- </div>
- </div>
- <table class="table table-striped" id="ParkingHistoryList-<?php echo $table_counter ++;?>">
- <thead>
- <th>SL</th>
- <th>User Name</th>
- <th>User Phone</th>
- <th>Place Name</th>
- <th>Date</th>
- <th>Vehicle Type</th>
- <th>Vehicle No.</th>
- <th>Price</th>
- </thead>
- </table>
- </div>
- </div>
- </div>
- </div>
- <?php endforeach; ?>
- <div id="tabs-search">
- <div class="content">
- <div class="container-fluid">
- <div class="col-md-12">
- <h3>Search Filter</h3>
- <?php echo form_open('User_track/search_parking_history', array('id' => 'parking-history-search-form'));?>
- <div class="form-group">
- <div class="col-md-12">
- <div class="form-group">
- <label for="sel1">Select Place:</label>
- <select class="form-control" style="border:1px solid" id="selected_place" name="selected_place">
- <option value=" ">Select Place</option>
- <?php foreach($history as $places):?>
- <option value="<?php echo $places['place_name'] ?>"><?php echo $places['place_name'] ?></option>
- <?php endforeach; ?>
- </select>
- </div>
- </div>
- <div class="col-md-6">
- <div class="form-group">
- <label for="">Date Start</label>
- <input type="date" class="form-control" name="selected_date_start" id="selected_date_start" style="border:1px solid">
- </div>
- </div>
- <div class="col-md-6">
- <div class="form-group">
- <label for="">Date End</label>
- <input type="date" class="form-control" name="selected_date_end" id="selected_date_end" style="border:1px solid">
- </div>
- </div>
- </div>
- <div class="col-md-12">
- <a href="javascript:GetSearchValues();" type="button" id="searchBtn" class="btn btn-default">Search</a>
- </div>
- <?php echo form_close();?>
- </div>
- <br><br>
- <div class="col-md-12">
- <h3>Parking History</h3>
- <div class="col-md-3" style="border:1px solid;">
- <div class="box-wrapper">
- <div class="box">
- <h6 class="text-center">Total Parking </h6>
- <p class="count_wrapper text-center" id="total_parking"></p>
- </div>
- </div>
- </div>
- <div class="col-md-3" style="border:1px solid;">
- <div class="box-wrapper">
- <div class="box">
- <h6 class="text-center">Total Earning </h6>
- <p class="count_wrapper text-center" id="total_earning"></p>
- </div>
- </div>
- </div>
- <div class="col-md-3" style="border:1px solid;">
- <div class="box-wrapper">
- <div class="box">
- <h6 class="text-center">Total Car</h6>
- <p class="count_wrapper text-center" id="total_cars"></p>
- </div>
- </div>
- </div>
- <div class="col-md-3" style="border:1px solid;">
- <div class="box-wrapper">
- <div class="box">
- <h6 class="text-center">Total Bike</h6>
- <p class="count_wrapper text-center" id="total_bikes"></p>
- </div>
- </div>
- </div>
- <br><br>
- <hr>
- <table class="table table-striped" id="ParkingHistoryList-Search">
- <thead>
- <th>SL</th>
- <th>User Name</th>
- <th>User Phone</th>
- <th>Place Name</th>
- <th>Date</th>
- <th>Vehicle Type</th>
- <th>Vehicle No.</th>
- <th>Price</th>
- </thead>
- </table>
- </div>
- </div>
- </div>
- </div>
- <script>
- $( function()
- {
- $( "#tabs" ).tabs();
- } );
- </script>
- <script src="https://cdn.jsdelivr.net/npm/chart.js@2.8.0/dist/Chart.min.js"></script>
- <script>
- $(document).ready(function() {
- var labelForCarMonth = []
- var dataForCarData = []
- var labelForBikeMonth = []
- var dataForBikeData = []
- var table;
- $('ul li a').click(function() {
- var place_name = $(this).text();
- var id = $(this).attr('data-function-id');
- //ctx.clearRect(0, 0, canvas.width, canvas.height);
- //$('#myChart-' +id).append();
- $.ajax({
- method: 'GET',
- url: '<?php echo base_url()?>User_track/TotalBikesForChart/',
- dataType: 'json',
- data: {
- "place_name": place_name,
- },
- success: function (response) {
- response.forEach(function (element) {
- labelForBikeMonth.push(element.Month)
- dataForBikeData.push(element.TotalBike)
- })
- }
- })
- $.ajax({
- method: 'GET',
- url: '<?php echo base_url()?>User_track/TotalCarsForChart/',
- dataType: 'json',
- data: {
- "place_name": place_name,
- },
- success: function (response){
- response.forEach(function (element) {
- labelForCarMonth.push(element.Month)
- dataForCarData.push(element.TotalCar)
- })
- console.log(labelForCarMonth, dataForCarData);
- var ctx = document.getElementById('myChart-'+id).getContext('2d');
- var myChart = new Chart(ctx, {
- type: 'line',
- data: {
- labels: labelForCarMonth,
- backgroundColor: 'rgba(255, 255, 255, 0.5)',
- datasets: [
- {
- data: dataForCarData,
- label: "Car",
- borderColor: 'red'
- },
- {
- data: dataForBikeData,
- label: "Bike",
- borderColor: 'black'
- },
- ]
- },
- options: {
- scales: {
- yAxes: [{
- ticks: {
- beginAtZero: true,
- responsive: false,
- maintainAspectRatio: true
- }
- }]
- }
- }
- });
- }
- })
- labelForCarMonth = [];
- dataForCarData = [];
- labelForBikeMonth = [];
- dataForBikeData = [];
- console.log(labelForCarMonth);
- console.log("id for clear"+id);
- table = $("#ParkingHistoryList-"+ id).DataTable({
- destroy: true,
- "bProcessing": true,
- "serverSide":true,
- "ajax":{
- url:"<?php echo base_url()?>User_track/GetParkingHistoryList/",
- type:"POST",
- data:{
- "place_name": place_name
- },
- }
- });
- });
- // myChart.destroy();
- });
- table.destroy();
- $(document).ready(function() {
- var table;
- var place_name = $(this).text();
- var id = $(this).attr('data-function-id');
- //console.log(place_name);
- table = $("#ParkingHistoryList-Search").DataTable({
- destroy: true,
- "bProcessing": true,
- "serverSide":true,
- "ajax":{
- url:"<?php echo base_url()?>User_track/GetParkingHistoryList/",
- type:"POST",
- data:{
- "place_name": place_name
- },
- }
- });
- table.destroy();
- });
- </script>
- <script>
- function GetSearchValues(){
- var table;
- var place = $( "#selected_place").val();
- var date_start = $( "#selected_date_start").val();
- var date_end = $( "#selected_date_end").val();
- //alert(place+''+date);
- table = $("#ParkingHistoryList-Search").DataTable({
- destroy: true,
- "bProcessing": true,
- "serverSide":true,
- "ajax":{
- url:"<?php echo base_url()?>User_track/SerachAndGetParkingHistoryList/",
- type:"POST",
- data:{
- "place_name": place,
- "date_start" : date_start , "date_end" : date_end
- },
- }
- });
- //table.destroy();
- $.ajax({
- type: 'ajax',
- method: 'get',
- url: "<?php echo base_url()?>User_track/TotalEarningForParkingHistory/",
- data: {
- "place_name": place,
- "date_start" : date_start , "date_end" : date_end
- },
- success: function(data) {
- console.log(data);
- $("#total_earning").html(data.replace(/^"(.*)"$/, '$1'));
- },
- error: function() {
- alert('Ajax failour');
- }
- });
- $.ajax({
- type: 'ajax',
- method: 'get',
- url: "<?php echo base_url()?>User_track/TotalBikesForParkingHistory/",
- data: {
- "place_name": place,
- "date_start" : date_start , "date_end" : date_end
- },
- success: function(data) {
- console.log(data);
- $("#total_bikes").html(data.replace(/^"(.*)"$/, '$1'));
- },
- error: function() {
- alert('Ajax failour');
- }
- });
- $.ajax({
- type: 'ajax',
- method: 'get',
- url: "<?php echo base_url()?>User_track/TotalCarsForParkingHistory/",
- data: {
- "place_name": place,
- "date_start" : date_start , "date_end" : date_end
- },
- success: function(data) {
- console.log(data);
- $("#total_cars").html(data.replace(/^"(.*)"$/, '$1'));
- },
- error: function() {
- alert('Ajax failour');
- }
- });
- $.ajax({
- type: 'ajax',
- method: 'get',
- url: "<?php echo base_url()?>User_track/TotalParkingNumberForParkingHistory/",
- data: {
- "place_name": place,
- "date_start" : date_start , "date_end" : date_end
- },
- success: function(data) {
- console.log(data);
- $("#total_parking").html(data.replace(/^"(.*)"$/, '$1'));
- },
- error: function() {
- alert('Ajax failour');
- }
- });
- }
- </script>
- <!-- <script>
- var ctx = document.getElementById('myChart').getContext('2d');
- var myChart = new Chart(ctx, {
- type: 'line',
- data: {
- labels: ["Jan", "Feb", "Mar", "April", "May","June","July","Aug","Sep","Oct","Nov","Dec"],
- backgroundColor: 'rgba(255, 255, 255, 0.5)',
- datasets: [
- {
- data: [12,24,31,45,51,23,4,20,33,30,40,50],
- label: "Car",
- // backgroundColor: 'rgba(255, 255, 255, 0.5)',
- borderColor: 'red'
- },
- {
- data: [60,24,12,53,13,53,15,75,21,42,53,30],
- label: "Bike",
- // backgroundColor: 'rgba(255, 255, 255, 0.1)',
- borderColor: 'black'
- },
- ]
- },
- options: {
- scales: {
- yAxes: [{
- ticks: {
- beginAtZero: true,
- responsive: false,
- maintainAspectRatio: true
- }
- }]
- }
- }
- });
- </script> -->
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement