<?php
include('db_con.php');
include('db_coni.php');

if (isset($_SESSION['user_id'])) {
  $user_type = $_SESSION['user_type'];
  $user_id = $_SESSION['user_id'];
  $user_name = $_SESSION['user_name'];
  $branch_id = $_SESSION['branch_id'];
  $branch_name = $_SESSION['branch_name'];
  $store_id = $_SESSION['store_id'];
  $store_name = $_SESSION['store_name'];
  $user_acc_no = $_SESSION['user_acc_no'];
}else{
  header('Location: login');
  die();
}
$sql = "SELECT doc_status FROM user_rights WHERE user_id = '".$user_id."' and doc_name = 'cash_invoices_new'";
$statement = $connect->prepare($sql);
            $statement->execute(); // no need to add `$sql` here, you can take that out
            $cash_invoices_new =$statement->fetchColumn();
            if($cash_invoices_new=='OFF'){echo "You Can't Access This Page";return false;}
            $dated = date('Y-m-d');
            $fdated = date('Y-01-01');
            if(isset($_POST["print"]))
            {
             $dated = $_POST['dated'];

      //$result = $statement->fetchAll();
             header('location:rpt_daybook_preview?print=1&dated='.$dated.'');
           }

           ?>
           <!DOCTYPE html>
           <html>
           <head>
            <?php include('include/head.php'); ?>
          </head>
          <body>
            <?php include('include/header.php'); ?>
            <?php include('include/sidebar.php'); ?>
            <?php include('include/script.php'); ?>
            <div class="main-container">
              <!-- Content Wrapper. Contains page content -->
              <div class="content-wrapper">
                <!-- Content Header (Page header) -->
                <div class="content-header">
                  <div class="container-fluid">
                    <div class="row mb-2">
                      <div class="col-sm-6">
                        <h1 class="m-0 text-dark"></h1>
                      </div><!-- /.col -->
                      <div class="col-sm-6">
                        <ol class="breadcrumb float-sm-right">
                          <li class="breadcrumb-item active">GL</li>
                          <li class="breadcrumb-item active">Reports </li>
                          <li class="breadcrumb-item active">Daybook </li>
                        </ol>
                      </div><!-- /.col -->
                    </div><!-- /.row -->
                  </div><!-- /.container-fluid -->
                </div>
                <!-- /.content-header -->
                <!-- Main content -->
                <section class="content">
                  <div class="container-fluid">
                    <!-- Small boxes (Stat box) -->
                    <span id="alert_action"></span>
                    <div class="row">
                      <div class="col-12">
                        <div class="card">
                          <div class="card-header">
                            <div class="row">
                              <div class="col-lg-10 col-md-10 col-sm-8 col-xs-6">
                                <h3 class="panel-title">GL Report</h3>
                              </div>

                            </div>
                          </div>
                          <!-- /.card-header -->
                          <div class="card-body">
                           <form method="post" id="report_form">
                            <br />

                            <div class="table-responsive">
                              <table class="table table-bordered">
                                <tr>
                                  <td colspan="2" align="center"><h2 style="margin-top:10.5px">Daybook</h2></td>
                                </tr>
                                <tr>
                                  <td colspan="2">
                                    <div class="row">
                                      <div class="col-md-6">


                                       <b>Select Date</b><input type="text" name="dated" id="dated" class="form-control input-sm" readonly value="<?php echo $dated; ?>" AutoComplete="off" required />  <br />       


                                       <br />
                                       <br />
                                       <br />
                                       <br />

                                     </div>

                                   </div>


                                 </td>
                               </tr>



                               <tr>
                                <td colspan="2" align="center">
                                  <input type="submit" name="print" id="print" class="btn btn-info form-control" value="Preview" />


                                </td>

                              </tr>
                            </table>
                          </div>
                        </form>
                      </div>
                    </div>
                  </div>
                </div>



              </div><!-- /.container-fluid -->
            </section>
            <!-- /.content -->

            <!-- /.content-wrapper -->


            <script src="js/jquery-ui.js"></script>
            <script src="js/jquery-ui.min.js"></script>
          </div>
        </div>


      </body>
      </html>
      <script>

        $(document).ready(function(){
          $('#dated').datepicker({
            dateFormat: 'yy-mm-dd',
            changeMonth: true,
            changeYear: true
          });
        })
      </script>