<?php require_once('../auth/auth.php');
  $creditor_id=$_GET['creditor_id'];
   $custom_field= mysqli_query($conn,"SELECT supplier FROM custom_field WHERE coid='$coid' LIMIT 1 ") or die(mysqli_error($conn));
      $rowcf= mysqli_fetch_assoc ($custom_field);
   
      $p=$rowcf['supplier'];
      function input_check($ap)
      {
       if (strpos($GLOBALS['p'], $ap) !== false) { return 1;} 
      }
?>
<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(38);?> </h3>
          <div class="card-tools">
            <button type="button" class="btn btn-tool" onclick="ExcelMe('#creditor_table')"  title="Download Excel">
              <i class="far fa-file-excel"></i>
            </button>
            <button type="button" onclick="BfpdfMe('#creditor_table');" class="btn btn-tool" title="Download Pdf"><i class="fas fa-download"></i></button>
            <button type="button" class="btn btn-tool" onclick="printMe('#payable_display')" 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-2">
              <div class="form-group">
                  <label>  <?php echo language(231); ?> </label>
                  <select id="bbid" class="form-control" 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-2">
               <div class="form-group" >
                  <label> <?php echo language(232); ?> </label>
                  <select  id="bbrid"  class="form-control" 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-2">
               <div class="form-group" >
                  <label><?php echo language(68);?></label>
                  <input type="text" id="search" class="form-control form-control-sm text-center" oninput="lives();">
               </div>
             </div> 
              <div class="col-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" value="50" oninput="lives();">
               </div>
              </div> 

   
           <div class="col-2">      
            <div class="form-group" >
             <label> <?php echo language(207); ?> </label>
             <dt id="show1" style="float: right;"></dt>
             <select  id="ttype"  class="form-control" required="true" onchange="lives();">
              <option selected value="0"> <?php echo language(222); ?> </option> 
              <option value="dr"> <?php echo language(217); ?> (+) </option> 
              <option value="cr"> <?php echo language(218); ?> (-) </option>  
            </select>
          </div>
        </div>
         <div class="col-2">        
                     <div class="form-group">
                        <label><?php echo language(224); ?>  </label>
                        <select  id="areaid" name="areaid"  class="form-control" onchange="lives();">
                          <option value="0"><?php echo language(222); ?> </option>
                         <?php 
                           $em_Route= mysqli_query($conn,"SELECT * FROM route_area  WHERE coid='$coid' AND bid='$bid' AND brid='$brid' ") or die (mysqli_error($conn));
                           while($rot= mysqli_fetch_assoc($em_Route)){
                             echo '<option value='.$rot["roid"].'>'.$rot["route_name"]."-".$rot["road_name"].' </option>';
                          }?> 
                       </select>
                    </div>
        </div>
        <input type="hidden" value="<?php echo $creditor_id; ?>" id="creditor_id" name="creditor_id">
     </div>
         </div>
        <div id="payable_display" class="mt-2"></div>
       </div>
    </div>
   </div>
  </div>
</div>
</section>

<script type="text/javascript">
   $("select").select2();
  function vprofile( 
    ){    
    $("#modal-xl").modal({backdrop: "static"});
    pagecall('../accounts/ac_profile.php?acid='+acid,'#xlmdview');   
  }  
</script>
<script type="text/javascript">
   $(document).ready(function(){
     $('select').select2();       
     pagecall('../supplier/payable_search_view.php?search=0'+'&bbid=<?php echo $bid;?>'+'&bbrid=<?php echo $brid;?>'+'&nrow=50'+'&creditor_id=<?php echo $creditor_id;?>'+'&ttype=0'+'&areaid=0','#payable_display',0);
   });
     function lives() {
       var search      = $('#search').val()==''?0:$('#search').val();
       var bbid        = $('#bbid').val();
       var bbrid       = $('#bbrid').val();
       var creditor_id  = $('#creditor_id').val();
       var nrow        = $('#nrow').val()==''?50:$('#nrow').val();
       var ttype       = $('#ttype').val();
       var areaid      = $('#areaid').val();
       $.get("../supplier/payable_search_view.php",
         {
           search      : search,
           bbid        : bbid,
           bbrid       : bbrid,
           creditor_id  : creditor_id,
           nrow        : nrow,
           ttype       : ttype,
           areaid      : areaid
         },
         function(html) {
           $("#payable_display").html(html);
         });
     }

      // fdate : fdate,
      //           edate : edate,

</script>

