<?php
defined('BASEPATH') OR exit('No direct script access allowed');
$p = array('admin','accountant','manager');
if(!(in_array($this->session->userdata('type'),$p))){
  redirect('auth');
}
$this->load->view('layout/header');
?>
<div class="content-wrapper">
  <!-- Content Header (Page header) -->
    <section class="content-header">
      <h5>
         <ol class="breadcrumb">
          <li><a href="<?php echo base_url('auth/dashboard'); ?>"><i class="fa fa-dashboard"></i> <?php echo $this->lang->line('header_dashboard'); ?></a></li>
          <li class="active">Tax Report</li>
        </ol>
      </h5> 
    </section>
    <!-- Main content -->
    <section class="content">
      <div class="row">
      <!-- right column -->
      <div class="col-md-12">
        <!-- <div class="box">
          <div class="box-header with-border">
            <div class="control-group">
              <div class="controls">
                <input type="submit" class="btn btn-info" id="hide1" name="submit" value="<?php echo $this->lang->line('reports_hide_show'); ?>">
              </div>
            </div>
          </div> -->
          <!-- /.box-header -->
          <!-- <div class="box-body">
            <div class="row hide1">
              <form target="" id="edit-profile" method="post" action="<?php echo base_url('reports/products_report');?>">
                <div class="col-md-6">
                  <div class="form-group">
                    <label for="product"><?php echo $this->lang->line('purchase_select_product'); ?></label>
                    <select class="form-control select2" id="product" name="product" style="width: 100%;">
                      <option value="">Select</option>
                      <?php

                        foreach ($products as $row) {
                          echo "<option value='$row->product_id'".set_select('product_id',$row->product_id).">$row->name</option>";
                        }
                      ?>
                    </select>
                    <span class="validation-color" id="err_product"><?php echo form_error('product'); ?></span>
                  </div>

                  <div class="form-group">
                    <label for="start_date"><?php echo $this->lang->line('reports_start_date'); ?></label>
                    <input type="text" class="form-control datepicker" id="start_date" name="start_date" value="">
                    <span class="validation-color" id="err_start_date"><?php echo form_error('start_date'); ?></span>
                  </div>

                  <div class="form-group">
                    <label for="end_date"><?php echo $this->lang->line('reports_end_date'); ?></label>
                    <input type="text" class="form-control datepicker" id="end_date" name="end_date" value="<?php echo date("Y-m-d");  ?>">
                    <span class="validation-color" id="err_end_date"><?php echo form_error('end_date'); ?></span>
                  </div>
                </div>
                <div class="col-md-12">
                  <div class="box-footer">
                    <input type="submit" class="btn btn-info" id="submit" name="submit" value="<?php echo $this->lang->line('reports_submit'); ?>">
                  </div>
                </div>
              
            </div>
          </div>
        </div>
      </div> -->
      <div class="col-md-12">
        <div class="box box-info">
            <div class="box-header with-border">
              <h3 class="box-title">Tax Report</h3>
              <input type="submit" class="pull-right btn btn-info btn-flat" id="pdf" name="submit" value="PDF">
              <input type="submit" class="pull-right btn btn-info btn-flat" id="csv" name="submit" value="CSV">
            </div></form>
            <!-- /.box-header -->
            <div class="box-body">
              <table id="index" class="table table-bordered table-striped">
                <thead>
                  <tr>
                    <th><?php echo $this->lang->line('product_no'); ?></th>
                    <th><?php echo $this->lang->line('product_hsn_sac_code'); ?></th>
                    <th>IGST</th>
                    <th>SGST</th>
                    <th>CGST</th>
                  </tr>
                </thead>
                <tbody>
                  <?php
                    foreach ($data['product'] as $value) {
                  ?>
                    <tr>
                      <td></td>
                      <td><?php echo $value->hsn_sac_code; ?></td>
                      <td align="right">
                        <?php
                          $tot = 0;
                          foreach ($data['sales'] as $key) {
                            if($value->hsn_sac_code == $key->hsn_sac_code){
                              if($key->shipping_state_id != $key->state_id){
                                $tot += $key->tax;
                              }
                            }
                          }
                          echo $this->session->userdata('symbol').$tot;
                        ?>
                      </td>
                      <td align="right">
                        <?php
                          $tot = 0;
                          foreach ($data['sales'] as $key) {
                            if($value->hsn_sac_code == $key->hsn_sac_code){
                              if($key->shipping_state_id == $key->state_id){
                                $tot += $key->tax/2;
                              }
                            }
                          }
                          echo $this->session->userdata('symbol').$tot;
                        ?>
                      </td>
                      <td align="right">
                        <?php
                          $tot = 0;
                          foreach ($data['sales'] as $key) {
                            if($value->hsn_sac_code == $key->hsn_sac_code){
                              if($key->shipping_state_id == $key->state_id){
                                $tot += $key->tax/2;
                              }
                            }
                          }
                          echo $this->session->userdata('symbol').$tot;
                        ?>
                      </td>
                    </tr>
                  <?php
                    }
                  ?>
                  <!-- <?php
                    foreach ($data['sales'] as $value) {
                  ?>
                    <tr>
                      <td></td>
                      <td><?php echo $value->hsn_sac_code; ?></td>
                      <td align="right">
                        <?php
                          if($value->shipping_state_id != $value->state_id){
                            echo $this->session->userdata('symbol').$value->tax;
                          }
                          else{
                            echo "0";
                          }
                        ?>
                      </td>
                      <td align="right">
                        <?php
                          if($value->shipping_state_id == $value->state_id){
                            echo $this->session->userdata('symbol').($value->tax/2);
                          }
                          else{
                            echo "0";
                          }
                        ?>
                      </td>
                      <td align="right">
                        <?php
                          if($value->shipping_state_id == $value->state_id){
                            echo $this->session->userdata('symbol').($value->tax/2);
                          }
                          else{
                            echo "0";
                          }
                        ?>
                      </td>
                    </tr>
                  <?php
                    }
                  ?> -->
                </tbody>
                <tfoot>
                <tr>
                  <th><?php echo $this->lang->line('product_no'); ?></th>
                  <th><?php echo $this->lang->line('product_hsn_sac_code'); ?></th>
                  <th>IGST</th>
                  <th>SGST</th>
                  <th>CGST</th>
                </tr>
                </tfoot>
              </table>
            </div>
            <!-- /.box-body -->
          </div>
          <!-- /.box -->
        </div>
        <!--/.col (right) -->
      </div>
      <!-- /.row -->
    </section>
    <!-- /.content -->
  </div>
  <!-- /.content-wrapper -->
<?php
  $this->load->view('layout/footer');
?>
<script type="text/javascript">
  $(document).ready(function(){
    $('#pdf').click(function(){
      $('form').attr('target','_blank');
    });
    $('#csv').click(function(){
      $('form').attr('target','_blank');
    });
    $('#submit').click(function(){
      $('form').attr('target','');
    });
  });
  $("#hide1").click(function(){
    $(".hide1").toggle();
  });
</script>
<script type="text/javascript">
$(document).ready(function() {

    //datepicker
    $('.datepicker').datepicker({
        autoclose: true,
        format: "yyyy-mm-dd",
        todayHighlight: true,
        orientation: "auto",
        todayBtn: true,
        todayHighlight: true,  
    });

});
</script>