~NAXC~

File Content: `deletefiles.php`

<?php ob_start();?>
  <?php 
	session_start(); 

	if (!isset($_SESSION['username'])) {
		$_SESSION['msg'] = "You must log in first";
		header('location: login.php');
	}

	if (isset($_GET['logout'])) {
		session_destroy();
		unset($_SESSION['username']);
		header("location: login.php");
	}



 


?>       
         
         
   
          <?php include "assets/includes/functions.php";?>
     
     <?php include "assets/includes/header.php";?>
     <style>

.disable-div {
  pointer-events: none;
}
.enable-div {
  pointer-events: block;
}

</style>

            <!-- Page content start -->
            <div class="page-contentbar">

                <!--left navigation start-->
                    <?php include "assets/includes/sidebar.php";?>
           <!--left navigation end-->

                <!-- START PAGE CONTENT -->
                <div id="page-right-content">

                    <div class="container">
        <br><br><br>
        <div class="panel panel-color panel-primary" style="display:none;">
            <div class="panel-heading">
                <h3 class="panel-title">Change NDate News......</h3>

            </div>
            <div class="panel-body" >
              <div class="form-group text-right m-b-0">
                   <form action="" method="post" enctype="multipart/form-data">
                        <button name="submit" type="submit">change head news</button>
                        <button name="submit1" type="submit">change Trend news</button>
                        <button name="submit2" type="submit">change Main news</button>
                        <button name="submit3" type="submit">change Sidebar news</button>
                        <?php
                            if(isset($_POST['submit']))
                            {

                                $sql = "SELECT * FROM headingnews";
                                $result = $connection->query($sql);
                                
                                if ($result->num_rows > 0) {
                                // output data of each row
                                while($row = $result->fetch_assoc()) {
                                    $newsdate = $row['newsdate'];
                                    $newDate = date("Y-m-d", strtotime($newsdate));

                                    $sql="update headingnews set ndate='". mysqli_real_escape_string($connection,$newDate)."' WHERE id = '" . $row['id'] . "'";
                                    if ($connection->query($sql) === TRUE) {
                                        echo "New record created successfully";
                                        
                                        } else {
                                        echo "Error: " . $sql . "<br>" . $connection->error;
                                        }
                                }
                                } else {
                                echo "0 results";
                                }
                            }

                            if(isset($_POST['submit1']))
                            {
                                // ==================trending news==============
                                $sql = "SELECT * FROM trendingnews";
                                $result = $connection->query($sql);
                                
                                if ($result->num_rows > 0) {
                                // output data of each row
                                while($row = $result->fetch_assoc()) {
                                    $newsdate = $row['newsdate'];
                                    $newDate = date("Y-m-d", strtotime($newsdate));

                                    $sql="update trendingnews set ndate='". mysqli_real_escape_string($connection,$newDate)."' WHERE id = '" . $row['id'] . "'";
                                    if ($connection->query($sql) === TRUE) {
                                        echo "New record created successfully";
                                        
                                        } else {
                                        echo "Error: " . $sql . "<br>" . $connection->error;
                                        }
                                }
                                } else {
                                echo "0 results";
                                }
                            }
                            if(isset($_POST['submit2']))
                            {
                                // ===========================main news =================
                                $sql = "SELECT * FROM mainnews";
                                $result = $connection->query($sql);

                                if ($result->num_rows > 0) {
                                // output data of each row
                                while($row = $result->fetch_assoc()) {
                                    $newsdate = $row['newsdate'];
                                    $newDate = date("Y-m-d", strtotime($newsdate));

                                    $sql="update mainnews set ndate='". mysqli_real_escape_string($connection,$newDate)."' WHERE id = '" . $row['id'] . "'";
                                    if ($connection->query($sql) === TRUE) {
                                        echo "New record created successfully";
                                        
                                        } else {
                                        echo "Error: " . $sql . "<br>" . $connection->error;
                                        }
                                }
                                } else {
                                echo "0 results";
                                }
                            }
                            if(isset($_POST['submit3']))
                            {
                                // ===========================sidebar news ==================
                                $sql = "SELECT * FROM sidebarnews";
                                $result = $connection->query($sql);

                                if ($result->num_rows > 0) {
                                // output data of each row
                                while($row = $result->fetch_assoc()) {
                                    $newsdate = $row['newsdate'];
                                    $newDate = date("Y-m-d", strtotime($newsdate));
                                    $oldndate = $row['ndate'];
                                    if ($oldndate !== $newDate)
                                    {
                                        $sql="update sidebarnews set ndate='". mysqli_real_escape_string($connection,$newDate)."' WHERE id = '" . $row['id'] . "'";
                                        if ($connection->query($sql) === TRUE) {
                                            
                                            
                                            } else {
                                            echo "Error: " . $sql . "<br>" . $connection->error;
                                            }
                                    }
                                }
                                echo "New record created successfully";
                                } else {
                                echo "0 results";
                                }


                            }
                        ?>
                    </form>
                </div> 
                <hr>

            </div>
        </div>

        <br><br><br>
        <div class="panel panel-color panel-primary">
            <div class="panel-heading">
                <h3 class="panel-title">Delete News......</h3>

            </div>
            <div class="panel-body" >
              <div class="form-group text-right m-b-0">
                        <div class="radio-list"  style="border: 1px solid;padding: 10px; box-shadow: 5px 5px 8px blue, 10px 10px 8px red, 15px 15px 8px green; ">
                            
                            <div class="radio-inline">
                                <span class="radio radio-info">
                                    <input type="radio" name="radio" id="radio2" value="Monthly">
                                    <label for="radio2">Monthly</label>
                            </span>
                            </div>
                            <div class="radio-inline">
                                <span class="radio radio-info">
                                    <input type="radio" name="radio" id="radio3" value="Date Wise">
                                    <label for="radio3">Date Wise</label>
                            </span>
                            </div>
                            
                        </div>
<hr>
<br>
<div class="row">

<div class="col-md-5 monthlyreport" style="border: 1px solid;padding: 10px; box-shadow: 5px 10px 8px #888888; ">

    <div class="form-group">
        <label class="control-label mb-10">Select Month from drop down</label>
        <select class="form-control select2" name="monthselect" id="monthselect">
            <option>Select</option>
            
                <option value="1">January</option>
                <option value="2">February</option>
                <option value="3">March</option>
                <option value="4">April</option>
                <option value="5">May</option>
                <option value="6">June</option>
                <option value="7">July</option>
                <option value="8">August</option>
                <option value="9">September</option>
                <option value="10">October</option>
                <option value="11">November</option>
                <option value="12">December</option>
            
        </select>
        <div style="text-align:center;padding-top:10px;">
            <button class="btn btn-success btn-anim" id="monthlyreport"><i class="icon-rocket"></i><span class="btn-text">Delete News</span></button>

        </div>
    </div>	
</div>
<div class="col-md-1"></div>
<div class="col-md-5 datewisereport" style="border: 1px solid;padding: 10px; box-shadow: 5px 10px 8px #888888; ">
    <div class="form-wrap mt-10">

        <div class="form-group col-md-6">
            <label class="control-label mb-10">From Date</label>
            <input class="form-control" type="date" id="fromdate"> 

        </div>	

        <div class="form-group col-md-6">
            <label class="control-label mb-10">To Date</label>
            <input class="form-control" type="date" id="todate">
        </div>
        <div style="text-align:center;padding-top:10px;">
            <button class="btn btn-success btn-anim" id="datewisereport"><i class="icon-rocket"></i><span class="btn-text">Delete News</span></button>

        </div>

    </div>
</div>
</div>

                 
                </div> 
       

            </div>
        </div>


<!-- ============================ -->
<div class="panel panel-color panel-primary"  style="display:none;">
    <div class="panel-heading">
        <h3 class="panel-title">Count News......</h3>

    </div>
    <div class="panel-body" >
        
             <?php
          
           

        $totheadnewscount=0;
        $tottendnewscount=0;
        $totmainnewscount=0;
        $totsidebarnewscount=0;
        $totclassifiedscount=0;
        $totnewscount=0;
            $sqlquery="SELECT SUM(newscount) as ncount FROM headingnews";
            $select_posts = mysqli_query($connectcount,$sqlquery);
            while($rowsqlquery = mysqli_fetch_assoc($select_posts))
                {
                    $totheadnewscount=$totheadnewscount+$rowsqlquery['ncount'];
                }
            $sqlquery="SELECT SUM(newscount) as ncount FROM trendingnews";
            $select_posts = mysqli_query($connectcount,$sqlquery);
            while($rowsqlquery = mysqli_fetch_assoc($select_posts))
            {
                $tottendnewscount=$tottendnewscount+$rowsqlquery['ncount'];
            }
            $sqlquery="SELECT SUM(newscount) as ncount FROM mainnews";
            $select_posts = mysqli_query($connectcount,$sqlquery);
            while($rowsqlquery = mysqli_fetch_assoc($select_posts))
            {
                $totmainnewscount=$totmainnewscount+$rowsqlquery['ncount'];
            }
            $sqlquery="SELECT SUM(newscount) as ncount FROM sidebarnews";
            $select_posts = mysqli_query($connectcount,$sqlquery);
            while($rowsqlquery = mysqli_fetch_assoc($select_posts))
            {
                $totsidebarnewscount=$totsidebarnewscount+$rowsqlquery['ncount'];
            }
            $sqlquery="SELECT SUM(newscount) as ncount FROM classifieds";
            $select_posts = mysqli_query($connectcount,$sqlquery);
            while($rowsqlquery = mysqli_fetch_assoc($select_posts))
                {
                    $totclassifiedscount=$totclassifiedscount+$rowsqlquery['ncount'];
                }
                $totnewscount = $totclassifiedscount + $totsidebarnewscount + $totmainnewscount + 
                $tottendnewscount + $totheadnewscount;
          echo $totnewscount;

          
          ?>
        
        
        
               
<p>Heading News : <?php echo $totheadnewscount ?></p>
<p>Trending News : <?php echo $tottendnewscount ?></p>
<p>Main News : <?php echo $totmainnewscount ?></p>
<p>Sidebar News : <?php echo $totsidebarnewscount ?></p>
<p>Classified News : <?php echo $totclassifiedscount ?></p>
    </div>
</div>                   
                        <!-- end row -->

                    </div>
                    <!-- end container -->

                     <div class="footer">
                        <div class="pull-right hidden-xs">
                            Project Completed <strong class="text-custom">100%</strong>.
                        </div>
                        <div>
                          <strong>C Media</strong> - Copyright &copy; 2021
                        </div>
                    </div> <!-- end footer -->

                </div>
                <!-- End #page-right-content -->

            </div>
            <!-- end .page-contentbar -->
        </div>
        <!-- End #page-wrapper -->



        <!-- js placed at the end of the document so the pages load faster -->
        <script src="assets/js/jquery-2.1.4.min.js"></script>
        <script src="assets/js/bootstrap.min.js"></script>
        <script src="assets/js/metisMenu.min.js"></script>
        <script src="assets/js/jquery.slimscroll.min.js"></script>

        <!-- Datatable js -->
        <script src="assets/plugins/datatables/jquery.dataTables.min.js"></script>
        <script src="assets/plugins/datatables/dataTables.bootstrap.js"></script>
        <script src="assets/plugins/datatables/dataTables.buttons.min.js"></script>
        <script src="assets/plugins/datatables/buttons.bootstrap.min.js"></script>
        <script src="assets/plugins/datatables/jszip.min.js"></script>
        <script src="assets/plugins/datatables/pdfmake.min.js"></script>
        <script src="assets/plugins/datatables/vfs_fonts.js"></script>
        <script src="assets/plugins/datatables/buttons.html5.min.js"></script>
        <script src="assets/plugins/datatables/buttons.print.min.js"></script>
        <script src="assets/plugins/datatables/dataTables.keyTable.min.js"></script>
        <script src="assets/plugins/datatables/dataTables.responsive.min.js"></script>
        <script src="assets/plugins/datatables/responsive.bootstrap.min.js"></script>
        <script src="assets/plugins/datatables/dataTables.scroller.min.js"></script>
        <script src="assets/plugins/datatables/dataTables.colVis.js"></script>
        <script src="assets/plugins/datatables/dataTables.fixedColumns.min.js"></script>

        <!-- init -->
        <script src="assets/pages/jquery.datatables.init.js"></script>

        <!-- App Js -->
        <script src="assets/js/jquery.app.js"></script>
        <script>

            $(document).ready(function() {
                $(".monthlyreport").addClass("disable-div");
                $(".datewisereport").addClass("disable-div");

            });


            $('#radio2').click(function() {
            if($('#radio2').is(':checked')) 
            { 
                $(".datewisereport").addClass("disable-div");
                $(".monthlyreport").removeClass("disable-div");
                $(".monthlyreport").addClass("enable-div");
            }                      
            });

            $('#radio3').click(function() {
            if($('#radio3').is(':checked')) 
            { 
                $(".monthlyreport").addClass("disable-div");

                $(".datewisereport").removeClass("disable-div");
                $(".datewisereport").addClass("enable-div");
            }                      
            });


            $('#monthlyreport').click(function()
            {  
            var input = {
                                "userid":$('#monthselect').val(),
                                "reportmode":"Monthly"
                            };
                console.log(input);
                $.ajax({
                            url : 'ajaxreports.php',
                            type : 'POST',
                            data : input,
                            success : function(response) {
                                alert (response);
                                
                        }
                        });
            });

            $('#datewisereport').click(function()
            {  
            var input = {
                                "fromdate":$('#fromdate').val(),
                                "todate":$('#todate').val(),
                                "reportmode":"Datewise"
                            };
                console.log(input);
                $.ajax({
                            url : 'ajaxreports.php',
                            type : 'POST',
                            data : input,
                            success : function(response) {
                                alert (response);
                        }
                        });
            });




        </script>
    </body>
</html>
   <?php ob_end_flush(); ?>
File Content: deletefiles.php

File Content: `deletefiles.php`
