<?php require_once('../auth/auth.php');require_once('../auth/function.php');require_once('../auth/acid_balance.php');?>
<?php 
$invoice=$_GET['invoice']; 

    $pinvoice_query= mysqli_query($conn,"SELECT o.invoice,o.m_invoice,date(o.datetime) tdate,o.details,a.acid,a.ac_name,a.ac_number,a.balance,o.d_man,o.wh_id,(LEFT(o.invoice,3)) sltype FROM order_list_edit o 
    	LEFT JOIN accounts a ON (a.acid=IF((LEFT(o.invoice,4)='ECOM'),
    		o.acid,(SELECT acid FROM accounts WHERE coid='$coid' AND bid='$bid' AND brid='$brid' AND active=1  LIMIT 1)))  WHERE o.coid='$coid' AND o.invoice ='$invoice' AND o.order_type='ECOM' GROUP BY o.invoice LIMIT 1;") or die(mysqli_error($conn));
    $pin_row= mysqli_fetch_assoc($pinvoice_query);

    $cacid          = $pin_row['acid'];
    $ac_name        = $pin_row['ac_name'];
    $ac_number      = $pin_row['ac_number'];
    $ac_balance     = $pin_row['balance'];


 

    $tdate          = $pin_row['tdate'];
    $m_invoice      = $pin_row['m_invoice'];
    $details        = $pin_row['details'];

    $d_man          = $pin_row['d_man'];
    $wh_id          = $pin_row['wh_id'];

    $sltype         = $pin_row['sltype'];
    
    $custom_field= mysqli_query($conn,"SELECT sales FROM custom_field WHERE coid='$coid' LIMIT 1 ") or die(mysqli_error($conn));
    $rowcf= mysqli_fetch_assoc ($custom_field);
 
    $p=$rowcf['sales'];
    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-1"></div>
      <div class="col-md-10">
      <div class="card card-success 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: 5px 8px;">
          <h3 class="card-title">
          <?php if ($sltype=='ECOM') { echo 'Ecomarch Invoice Create';}  ?>
          </h3>
          <div class="card-tools">
            <span class="mark1" onclick="copy(this);" title="Copy Invoice"><?php echo $invoice;?></span>
            <div class="btn-group">
              <button type="button" class="btn btn-tool" data-card-widget="remove" data-dismiss="modal">
              <i class="fas fa-times"></i>
              </button>
            </div>
          </div>
        </div>
        <div class="card-body">
          <div class="col-md-12">
            <table class="ttable mt-1 " cellpadding="0" cellspacing="0">
              <tbody>
                <tr>
                  <th class="text-center" width="15%"><?php echo language(164);?></th>
                  <th width="30%">
                    <select onchange="ebalancex(this.value,'#n_show','#b_show')" class="form-control select2" style="width: 100%;" required="true">
                      <?php
                      echo '<option value='.$cacid.','.$ac_number.','.$ac_balance.'>'.$ac_name.'</option>';
                      
                      $accat= mysqli_query($conn,"SELECT acid,ac_name,ac_alise,ac_number,balance FROM accounts LEFT JOIN ac_sub_g_category ON(accounts.gcatid=ac_sub_g_category.ac_g_catid) WHERE accounts.coid='$coid' AND bid='$bid' AND brid='$brid' AND active=1 AND g_type IN('su-deb') AND ac_type IS NULL") or die(mysqli_error($conn));
                      while($acat= mysqli_fetch_assoc($accat)){
                      echo '<option value='.$acat["acid"].','.$acat["ac_number"].','.$acat["balance"].'>'.$acat["ac_name"].'</option>';
                      }?>
                    </select>
                  </th>
                  <th class="text-center" width="12%"><?php echo language(111);?></th>
                  <th class="text-center" width="15%" id="n_show"><?php echo $ac_number;?></th>
                  <th class="text-center" width="13%"><?php echo language(137);?></th>
                  <th class="text-center" width="15%" id="b_show"><?php echo $ac_balance;?></th>
                </tr>
              </tbody>
            </table>
          <?php if(input_check('item_scan_status')==1){ ?>
            <form id="sal_sub" class="mt-3" action="#" method="post" autocomplete="off">
          <?php } ?>
              <div class="row">
                <div class="col-md-3"></div>
                <div class="col-md-6">
                  <div class="form-group">
                    <label><?php echo language(138);?></label>
                    <input type="text" id="item_details" class="form-control form-control-sm inputselect" required="true" autofocus="true">
                  </div>
                </div>
                <div class="col-md-3"></div>
                <div class="col-md-12">
                  <hr style="margin-top:-5px;margin-bottom: 7px;">
                </div>
              </div>
          <?php if(input_check('item_scan_status')==1){ ?>
            </form>
          <?php } ?>
          </div>
          <form id="sal_form" action="#" method="post" autocomplete="off">
            <input type="hidden" name="c_acid" value="<?php echo $cacid;?>">
            <input type="hidden" name="sal_invoice" value="<?php echo $invoice;?>">
            <input type="hidden" name="sltype" value="<?php echo $sltype;?>">

  
            <div class="col-md-12">
              <div class="row">
                <div class="col-md-12">
                  <div class="card-body table-responsive cscroll" style="max-height: 450px;">
                    <table class="ttable" cellpadding="0" cellspacing="0">
                      <thead>
                        <tr class="sticky-top">
                          <th class="text-center" style="width:2%;"><?php echo language(15);?></th>
                          <th style="width:40%;"><?php echo language(77);?></th>
                          <th class="text-center" style="width:10%;"><?php echo language(139);?></th>
                          <th class="text-center <?php if(input_check('u_type') !==1){echo 'd-none';}?>" style="width:10%;"><?php echo language(98);?></th>
                          <th class="text-center" style="width:15%;"><?php echo language(84);?></th>
                          <th class="text-center" style="width:10%;"><?php echo language(88);?></th>
                          <!--<th class="text-center" style="width:10%;">NET PRICE</th>-->
                          <th class="text-center" style="width:10%;"><?php echo language(140);?></th>
                          <th class="text-center" style="width:2%;">#</th>
                        </tr>
                      </thead>
                    <tbody id="row_show<?php echo $invoice;?>"></tbody>
                  </table>
                </div>
              </div>
              <div class="col-md-12"><hr style="margin-top: 7px;margin-bottom: 7px;"></div>
              <div class="col-md-7">
                <div class="form-row">
        
                  
                  
                  <div class="col-md-12">
                    <div class="form-group">
                      <label>Narration</label>
                      <textarea name="details" class="form-control form-control-sm inputselect" rows="2" placeholder="Enter ...">N/A</textarea>
                    </div>
                  </div>
                  
                  
                  <div class="col-md-6 ">
                    <div class="form-group">
                      <label>Invoice No</label>
                      <input type="text" name="m_invoice" value="<?php echo $m_invoice;?>" class="form-control form-control-sm text-center inputselect">
                    </div>
                  </div>
                  <div class="col-md-6 ">
                    <div class="form-group">
                      <label>Delivery Man</label>
                      <input type="text" name="d_man" value="<?php echo $d_man;?>" class="form-control form-control-sm inputselect">
                    </div>
                  </div>
                  <div class="col-md-12"><hr style="margin-top:0px;margin-bottom:5px;"></div>
                  
                  
                  
                  <div class="col-md-4 <?php if(input_check('wharehouse')!==1){ echo 'd-none';}?>">
                    <div class="form-group">
                      <label><?php echo language(104);?></label>
                      <select name="wh_id" class="form-control select2" style="width: 100%;" required="true">
                        <?php
                        $swh = mysqli_fetch_assoc(mysqli_query($conn,"SELECT bwid,war_location FROM business_w_house WHERE coid='$coid' AND bid='$bid' AND brid='$brid' AND active=1 AND bwid='$wh_id' LIMIT 1"));
                        ?>
                        <option value="<?php echo $swh['bwid'];?>"><?php echo $swh['war_location'];?></option>
                        <?php
                        $bw= mysqli_query($conn,"SELECT bwid,war_location FROM business_w_house WHERE coid='$coid' AND bid='$bid' AND brid='$brid' AND active=1 ORDER BY bwid ASC") or die(mysqli_error($conn));
                        while($wh= mysqli_fetch_assoc($bw)){
                        echo '<option value='.$wh["bwid"].'>'.$wh["war_location"].'</option>';
                        }?>
                      </select>
                    </div>
                  </div>
                  
                  
                  
                  <div class="col-md-4 ">
                    <div class="form-group">
                      <label>Invoice Date</label>
                      <input type="text" name="tdate" class="form-control form-control-sm text-center" onmouseover="lcdate(this)" readonly="true" required="true" value="<?php echo $tdate;?>">
                    </div>
                  </div>
                  <div class="col-md-2 ">
                    <div class="form-group mt-3">
                      <div class="custom-control custom-checkbox">
                        <input name="email" class="custom-control-input" type="checkbox" id="customCheckbox1" value="yes">
                        <label for="customCheckbox1" class="custom-control-label float-right">E-Mail</label>
                      </div>
                    </div>
                  </div>
                  <div class="col-md-2 ">
                    <div class="form-group mt-3">
                      <div class="custom-control custom-checkbox">
                        <input name="sms" class="custom-control-input" type="checkbox" id="customCheckbox2" value="yes">
                        <label for="customCheckbox2" class="custom-control-label float-right">SMS</label>
                      </div>
                    </div>
                  </div>
                  <div class="col-md-12"><hr style="margin-top:0px;margin-bottom: 5px;"></div>
                  
                  <div class="col-md-6 <?php if(input_check('f_charge')!==1){echo 'd-none';} ?>">
                    <div class="form-group">
                      <label><?php echo language(153);?></label>
                      <dt id="f_show" style="float: right;"></dt>
                      <input type="hidden" name="f_acid">
                      <select id="f_acid" onchange="balance(this.value,'#f_show')" class="form-control select2" style="width: 100%;" required="true">
                      <?php
                        $accat= mysqli_query($conn,"SELECT acid,ac_name,ac_alise,ac_number,balance FROM accounts LEFT JOIN ac_sub_g_category ON(accounts.gcatid=ac_sub_g_category.ac_g_catid) WHERE accounts.coid='$coid' AND bid='$bid' AND brid='$brid' AND active=1 AND g_type IN('dr-inc') ORDER BY acid DESC ") or die(mysqli_error($conn));
                        while($acat= mysqli_fetch_assoc($accat)){
                        echo '<option value='.$acat["acid"].','.$acat["balance"].'>'.$acat["ac_name"]."-".$acat["ac_number"].' '.'('.$acat["ac_alise"].')</option>';
                        }?>
                      </select>
                    </div>
                  </div>
                  
                  
                  
                  <div class="col-md-6 <?php if(input_check('d_account')!==1){echo 'd-none';} ?>">
                    <div class="form-group">
                      <label>Discount A/C</label>
                      <dt id="d_show" style="float: right;"></dt>
                      <input type="hidden" name="d_acid">
                      <select id="d_acid" onchange="balance(this.value,'#d_show')" class="form-control select2" style="width: 100%;" required="true">
                      <?php
                        $accat= mysqli_query($conn,"SELECT acid,ac_name,ac_alise,ac_number,balance FROM accounts LEFT JOIN ac_sub_g_category ON(accounts.gcatid=ac_sub_g_category.ac_g_catid) WHERE accounts.coid='$coid' AND bid='$bid' AND brid='$brid' AND active=1 AND g_type IN('dr-exp')") or die(mysqli_error($conn));
                        while($acat= mysqli_fetch_assoc($accat)){
                        echo '<option value='.$acat["acid"].','.$acat["balance"].'>'.$acat["ac_name"]."-".$acat["ac_number"].' '.'('.$acat["ac_alise"].')</option>';
                        }?>
                      </select>
                    </div>
                  </div>
                  
                  
                </div>
              </div>
              <div class="col-md-1"></div>
              <div class="col-md-4">
                <input type="hidden" id="sl_totalc<?php echo $invoice;?>" name="sl_totalc">
                <table class="ttable" cellpadding="0" cellspacing="0">
                  <tbody>
                    <tr>
                      <td class="text-right w-50"><dt><?php echo language(142);?></dt></td>
                      <td class="w-50"><dt>
                        <input type="number" oninput="slblcal();" name="delivary_c" id="delivary_c" class="form-control form-control-sm inputselect text-right" value="0" style="text-align:center;" required="true">
                      </dt></td>
                    </tr>
                    <tr>
                      <td class="text-right w-50"><dt><?php echo language(88);?></dt></td>
                      <td class="w-50"><dt>
                        <input type="number" oninput="slblcal();" name="sldiscount" id="sldiscount" class="form-control form-control-sm inputselect text-right" value="0" style="text-align:center;" required="true">
                      </dt></td>
                    </tr>
                    <?php if ($sltype=='ECOM') { ?>
                    <tr>
                      <td class="text-right w-50"><dt><?php echo language(143);?></dt></td>
                      <td class="w-50"><dt>
                        <input type="number" id="slsub_total" class="form-control form-control-sm inputselect text-right" value="0" required="true" readonly="true">
                      </dt></td>
                    </tr>
                    <tr>
                      <td class="text-right w-50"><dt>Previous Due</dt></td>
                      <td class="w-50"><dt>
                        <input type="number" id="slpre_due" class="form-control form-control-sm inputselect text-right" value="<?php echo $ac_balance;?>" required="true" readonly="true">
                      </dt></td>
                    </tr>
                    <?php } else { ?>
                    <input type="hidden" id="slsub_total" value="0">
                    <input type="hidden" id="slpre_due" value="0">
                    <?php } ?>
                    <tr>
                      <td class="text-right w-50"><dt><?php echo language(145);?> </dt></td>
                      <td class="w-50"><dt>
                        <input type="number" id="slgrd_total" class="form-control form-control-sm inputselect text-right" value="0" required="true" readonly="true">
                      </dt></td>
                    </tr>
                    <tr>
                      <td class="text-right w-50"><dt><?php echo language(146);?></dt></td>
                      <td class="w-50"><dt>
                        <input type="number" step="0.001" oninput="slblcal();" name="slpayment" id="slpayment" class="form-control form-control-sm inputselect text-right" value="<?php echo $payment;?>" required="true">
                      </dt></td>
                    </tr>
             
            
                    <tr>
                      <th colspan="2">
                        <div class="form-group">
                          <label><?php echo language(161);?></label>
                          <dt id="m_show" style="float: right;"></dt>
                          <input type="hidden" name="m_acid">
                          <select id="m_acid" onchange="balance(this.value,'#m_show')" class="form-control select2" style="width: 100%;" required="true">
                          <?php
                            $accat= mysqli_query($conn,"SELECT acid,ac_name,ac_alise,ac_number,balance FROM accounts LEFT JOIN ac_sub_g_category ON(accounts.gcatid=ac_sub_g_category.ac_g_catid) WHERE accounts.coid='$coid' AND bid='$bid' AND brid='$brid' AND active=1 AND g_type IN('mcash','bank')") or die(mysqli_error($conn));
                            while($acat= mysqli_fetch_assoc($accat)){
                            echo '<option value='.$acat["acid"].','.$acat["balance"].'>'.$acat["ac_name"]."-".$acat["ac_number"].' '.'('.$acat["ac_alise"].')</option>';
                            }?>
                          </select>
                        </div>
                      </th>
                    </tr>
                    
                  </tbody>
                </table>
              </div>
            </div>
          </div>
          <div class="card-footer mt-1" align="center" style="padding: 8px 5px;">
            <button type="submit" id="save" class="btn btn-success"><?php echo language(23);?></button>
          </div>
        </form>
      </div>
    </div>
    <div class="col-md-1"></div> 
  </div>
</div>
</section>
<script>
  $("select").select2(); 
  pagecall('../eco/item_order_list.php?invoice=<?php echo $invoice?>','#row_show<?php echo $invoice;?>',0);



  function ebalance (value,sid){
      var vvvv = value.split(",");
      $(sid).next().val(Number(vvvv[0]));
      var bl  = Number(vvvv[1]);
      if (bl >=0) {
        $(sid).css("color","green");
        $(sid).text(bden.format(bl) + ' Dr');
      } else {
        $(sid).css("color","red");
        $(sid).text(bden.format(-bl) + ' Cr');
      }
  }
ebalance ($("#f_acid").val(),"#f_show");
ebalance ($("#d_acid").val(),"#d_show");
ebalance ($("#m_acid").val(),"#m_show");

function slblcal(){
  let sl_totalc   = Number($('[name=sl_totalc]').val());
  let delivary_c  = Number($('#delivary_c').val());
  let sldiscount  = Number($('#sldiscount').val());
  let slsub_total = Number((sl_totalc + delivary_c)-sldiscount);
  let slpre_due   = Number($('#slpre_due').val());
  let slgrd_total = Number(slsub_total + slpre_due);
  let slpayment   = Number($('#slpayment').val());
  let slcur_due   = Number(slgrd_total-slpayment);
  let slrefund    = Number(slcur_due<0?-slcur_due:0);

  $('#slsub_total').val(slsub_total);
  $('#slgrd_total').val(slgrd_total);
  $('#slcur_due').val(slcur_due);
  $('#slrefund').val(slrefund);

}   
</script>


<script>
   $(document).ready(function() {
   $('#sal_form').on('submit', function(e){
   e.preventDefault(); 
   if (Number($('[name=sl_totalc]').val()) >0) {
   $('#save').prop('disabled', true);
   $('#save').html('<span class="spinner-border spinner-border-sm" role="status" aria-hidden="true"></span> '+'Loading...'); 
        $.post("../eco/sales_db.php",$(this).serialize(),function(data){
        toastr.success(Successfully, yourdata);
        $("#modal-sm").modal({backdrop: "static"});
        pagecall('../sales/sales_invoice_pos.php?invoice=<?php echo $invoice?>','#smdview',0);
      });
      } else {
        alert('Please Select Item...??');
      }
     });
   });  
</script>

<script>
  $(function() {
    $( "#item_details" ).autocomplete({
        minLength: 2,
       source: '../sales/item.php',
       autoFocus: true,
       delay:500,
   //  scroll: true,
       // focus: function( event, ui ) {
       //    $( "#item_details" ).val( ui.item.label );
       //       return false;
       // },
       select: function( event, ui ) {
          $( "#item_details" ).val( ui.item.label );
          $.post("../sales/order_list_db.php",
            {item_id : ui.item.value,oinvoice:'<?php echo $invoice;?>'},
         function(data){
          toastr.success(Successfully, yourdata);
          pagecall('../sales/order_list.php?invoice=<?php echo $invoice?>','#row_show<?php echo $invoice;?>',0);
        });  
        $( "#item_details" ).val('');        
          return false;
       }
    });
  });
</script>

<script>
   $(document).ready(function() {
   $('#sal_sub').on('submit', function(e){
   e.preventDefault();
      let item_code = $('#item_details').val();
        $.post("../sales/order_list_db.php",{item_code : item_code,sinvoice:'<?php echo $invoice;?>'},function(data){
          toastr.success(Successfully, yourdata);
          pagecall('../sales/order_list.php?invoice=<?php echo $invoice?>','#row_show<?php echo $invoice;?>',0);
          $( "#sal_sub" )[0].reset();
          $( "#item_details" ).val('');
          return false;
        });
      });
   });  
</script>

<script>
  $(function() {
    $( "[name=c_name],[name=c_gsm]").autocomplete({
   //  minLength: 0,
       source: '../sales/c_cus.php',
       autoFocus: true,
   //  delay:500,
   //  scroll: true,
       // focus: function( event, ui ) {
       //    $( "#item_details" ).val( ui.item.label );
       //       return false;
       // },
       select: function( event, ui ) {    
       $( "[name=c_gsm]" ).val( ui.item.value );
       $( "[name=c_name]" ).val( ui.item.name );
       $( "[name=c_address]" ).val( ui.item.addr );
          return false;
       }
    });
  });
</script>