<?php require_once('../auth/auth.php');?>
<section class="content">
  <div class="container-fluid">
    <div class="row">
      <div class="col-md-12">
        <div class="card card-primary card-outline direct-chat direct-chat-primary shadow-none" style="border-left:1px solid #969c9d;border-right:1px solid #969c9d;border-bottom:1px solid #969c9d;">
          <div class="card-header" style="padding: 3px 8px;">
            <h3 class="card-title"><?php echo language(316);?></h3>
            <div class="card-tools">
              <button type="button" class="btn btn-tool" onclick="ExcelMe('#sale_main_table')"  title="Download Excel">
              <i class="far fa-file-excel"></i>
              </button>
              <button type="button" onclick="BfpdfMe('#sale_main_table');" class="btn btn-tool" title="Download Pdf"><i class="fas fa-download"></i></button>
              <button type="button" class="btn btn-tool" onclick="printMe('#item_sales_show','header')" title="Print Now"><i class="fas fa-print"></i></button>
              <button type="button" class="btn btn-tool" data-card-widget="remove" data-dismiss="modal"><i class="fas fa-times"></i></button>
            </div>
          </div>
          <div class="card-body p-1">
            <div class="col-md-12" style="border:1px solid #969c9d;background: hsla(0,0%,50.2%,.11);border-radius: 5px;">
              <div class="row mt-1 mb-n2">
                <?php if($bid_check>1 || $multi_bid > 1) {?>
                <div class="col-md-2">
                  <div class="form-group">
                    <label>  <?php echo language(231); ?> </label>
                    <select id="bbid" class="form-control select2" style="width: 100%" onchange="lives();">
                      <option selected value="<?php echo $bid;?>">
                        <?php echo $bid_name=mysqli_fetch_assoc(mysqli_query($conn,"SELECT bid_name FROM business WHERE bid='$bid' LIMIT 1 "))['bid_name'];
                        ?>
                      </option>
                      <option value="0"> <?php echo language(222); ?> </option>
                      <?php
                      $prr= mysqli_query($conn,"SELECT bid,bid_name FROM business WHERE coid='$coid'") or die(mysqli_error($conn));
                      while($prw= mysqli_fetch_assoc($prr)){
                      echo '<option value='.$prw["bid"].'>'.$prw["bid_name"].'</option>';
                      }?>
                    </select>
                  </div>
                </div>
                <?php } else { ?>
                <input type="hidden" id="bbid" value="<?php echo $bid;?>">
                <?php } if( $brid_check > 1 ||  $multi_brid > 1) { ?>
                <div class="col-md-2">
                  <div class="form-group" >
                    <label> <?php echo language(232); ?> </label>
                    <select  id="bbrid"  class="form-control select2" style="width: 100%" required="true" onchange="lives();">
                      <option selected value="<?php echo $brid;?>">
                        <?php echo $branch_name=mysqli_fetch_assoc(mysqli_query($conn,"SELECT branch_name FROM branch WHERE bid='$bid'  LIMIT 1 "))['branch_name'];
                        ?>
                      </option>
                      <option value="0"> <?php echo language(222); ?> </option>
                      <?php
                      $prr= mysqli_query($conn,"SELECT brid,branch_name FROM branch WHERE coid='$coid' AND bid='$bid'") or die(mysqli_error($conn));
                      while($prw= mysqli_fetch_assoc($prr)){
                      echo '<option value='.$prw["brid"].'>'.$prw["branch_name"].'</option>';
                      }?>
                    </select>
                  </div>
                </div>
                <?php } else { ?>
                <input type="hidden" id="bbrid" value="<?php echo $brid;?>">
                <?php } ?>
                <div class="col-md-2">
                  <div class="form-group" >
                    <label><?php echo language(68);?></label>
                    <input type="text" id="search" class="form-control form-control-sm text-center">
                  </div>
                </div>

                <div class="col-1">
                  <div class="form-group" >
                    <label> <?php echo language(259);?> </label>
                    <select id="itype" class="form-control" required="true" onchange="lives();">
                      <option value="0"> <?php echo language(222);?> </option>
                      <option value="ECSL"> <?php echo language(62);?> </option>
                      <option value="ERSL"> <?php echo language(63);?> </option>
                      <option value="INSL"> <?php echo language(375);?> </option>

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

              <div class="col-2">
                <div class="form-group">
                   <label><?php echo language(69);?></label>
                   <select id="item_gid" class="form-control" required="true" onchange="lives();">
                      <option value="0">All Group</option>
                      <?php 
                         $pgroup_query= mysqli_query($conn,"SELECT pgid,pgroup_name FROM item_group  WHERE coid='$coid' AND bid='$bid' AND active=1 ORDER BY pgid ASC") or die (mysqli_error($conn));
                         while($rowgroup= mysqli_fetch_assoc($pgroup_query)){
                           echo '<option value='.$rowgroup["pgid"].'>'.$rowgroup["pgroup_name"].' </option>';
                         }?> 
                   </select>
                </div>
              </div>
              <div class="col-2">
               <div class="form-group">
                   <label><?php echo language(70);?></label>
                   <select id="item_cid" class="form-control" required="true" onchange="lives();">
                      <option value="0">All Category</option>
                      <?php 
                         $pcatt_query= mysqli_query($conn,"SELECT pcid,pcat_name FROM item_catagory  WHERE coid='$coid' AND bid='$bid' AND active=1 ORDER BY pcid ASC") or die (mysqli_error($conn));
                         while($rowcat= mysqli_fetch_assoc($pcatt_query)){
                           echo '<option value='.$rowcat["pcid"].'>'.$rowcat["pcat_name"].' </option>';
                         }?> 
                   </select>
                </div>
              </div>
              <div class="col-2">
                <div class="form-group">
                   <label><?php echo language(71);?></label>
                   <select id="item_brnd" class="form-control" required="true" onchange="lives();">
                      <option value="0">All Brand</option>
                      <?php 
                         $pbrand_query= mysqli_query($conn,"SELECT pbid,pbrand_name FROM item_brand  WHERE coid='$coid' AND bid='$bid' AND active=1 ORDER BY pbid ASC") or die (mysqli_error($conn));
                         while($rowbrand= mysqli_fetch_assoc($pbrand_query)){
                           echo '<option value='.$rowbrand["pbid"].'>'.$rowbrand["pbrand_name"].'</option>';
                         }?> 
                   </select>
                </div>
              </div>

                <div class="col-md-1">
                  <div class="form-group" >
                    <label><?php echo language(72);?></label>
                    <input type="number" id="nrow" title="View Limit" class="form-control form-control-sm text-center inputselect" value="50">
                  </div>
                </div>
                
                <div class="col-md-2">
                  <div class="form-group">
                    <label><?php echo language(257);?></label>
                    <input type="text" id="fdate" class="form-control form-control-sm text-center" onmouseover="lcdate(this)" readonly="true" required="true" value="<?php echo $date;?>">
                  </div>
                </div>
                <div class="col-md-2">
                  <div class="form-group">
                    <label><?php echo language(258);?></label>
                    <input type="text" id="edate" class="form-control form-control-sm text-center" onmouseover="lcdate(this)" readonly="true" required="true" value="<?php echo $date;?>">
                  </div>
                </div>
              </div>
            </div>
            <div id="item_sales_show" class="mt-2"></div>
          </div>
        </div>
      </div>
    </div>
  </div>
</section>
<script type="text/javascript">
   $(document).ready(function(){
     $('select').select2();       
     pagecall('../display_report/item_sales_register_view.php?search=0'+'&bbid=<?php echo $bid;?>'+'&bbrid=<?php echo $brid;?>'+'&item_gid=0'+'&item_cid=0'+'&item_brnd=0'+'&itype=0'+'&nrow=50'+'&fdate=<?php echo $date;?>'+'&edate=<?php echo $date;?>','#item_sales_show',0);
   });
     function lives() {
       let search      = $('#search').val()==''?0:$('#search').val();
       let bbid        = $('#bbid').val();
       let bbrid       = $('#bbrid').val();
       let item_gid    = $('#item_gid').val();
       let item_cid    = $('#item_cid').val();
       let item_brnd   = $('#item_brnd').val();
       let itype       = $('#itype').val();
       let nrow        = $('#nrow').val()==''?50:$('#nrow').val();
       let fdate       = $('#fdate').val();
       let edate       = $('#edate').val();
       $(".preloader").css('display','flex');
       $.get("../display_report/item_sales_register_view.php",
         {
           search      : search,
           bbid        : bbid,
           bbrid       : bbrid,
           item_gid    : item_gid,
           item_cid    : item_cid,
           item_brnd   : item_brnd,
           itype       : itype,
           nrow        : nrow,
           fdate       : fdate,
           edate       : edate
         },
         function(html) {
           $("#item_sales_show").html(html);
           $('.preloader').hide();
         });
     }
      // FOR DATE PICKER //
    var timer = null;
    $('#fdate,#edate').change(function(){
      clearTimeout(timer);
      timer = setTimeout(lives, 100);
    });
      // FOR keyup //
    var timer1 = null;
    $('#search,#nrow').on('input',function(){
      clearTimeout(timer1);
      timer1 = setTimeout(lives, 500);
    });    
</script>

