<?php 
  $cc=0;
  $rc=0;
  $tPrice=0;     
  $ttprice=0;
  $ttInv=0;
  require_once "labClass.php";
  
 $con = new labClass();
  ?>
  
 
<table class="table table-bordered" border="1"> 
   <thead class="bg-secondary" >
       
      <th>  
        <small><h6>ORDER DATE/ORDER NO</h6></small>
      </th>
       
      <th>  
        <small><h6>PATICULAR</h6></small>
      </th>
      
      <th>  
        <small><h6>QTY</h6></small>
      </th>
      <th>  
        <small><h6>CONFIRM RECV QTY</h6></small>
      </th>
       
    </thead>
   <?php
    $rc=0; 
    $cp= $con->getThispOrderUnconfirmed();
    $nr=$cp->rowCount();
    ?>
  <tbody>
  </tr>    
 <?php 
 if ($cp->rowCount()>0) {

    $ch=$cp->fetchAll();
      
      foreach ($ch as $key => $c) {
          $quantity =0;
         $rc++;
      if ($c['confrecv']!=NULL) 
                { 
                
                $text=$c['confrecv'];
               if (preg_match_all('/\((\d+)\)/', $text, $matches)) {
                  $numbers = $matches[1]; // all numbers inside ()
                  $sum = array_sum($numbers);
                 $quantity = (int) $sum; 
                 //$quantity = (int) $matches[1];
                 
                }
                }
                ////////////////////
                 if ($quantity>=0 &&  $c['eQty']>$quantity) 
                { 
                ?>
                
          <tr>
          <td>
                 
              <?php echo $c['entryD'];?>
            <sup id="orno<?php echo $rc; ?>"><?php echo $c['orderID'];?></sup>
            </td> 
            <td>
                 
            <sup id="in<?php echo $rc;?>"><?php echo $c['iname'];?></sup>
            </td> 
            
            <td> 
               <?php echo $c['eQty'];?><br/> 
                 <?php if ($c['confrecv']!=NULL) 
                { 
                
                $text=$c['confrecv']; 
                 if (preg_match_all('/\((\d+)\)/', $text, $matches)) {
                  $numbers = $matches[1]; // all numbers inside ()
                  $sum = array_sum($numbers);
                 $quantity = (int) $sum;  
                 if ($c['eQty']>$quantity)
                 {
                     echo "rcv:".$quantity;
                 }
               
                }
                }
                ?>
            </td>

            <td>
              <sup id="rd<?php echo $rc; ?>"></sup>
               <?php if ($c['confrecv']!=NULL) 
                { 
                
                $text=$c['confrecv'];
 
                
                
                if (preg_match_all('/\((\d+)\)/', $text, $matches)) {
                  $numbers = $matches[1]; // all numbers inside ()
                  $sum = array_sum($numbers); 
                  
                 $quantity = (int) $sum;
                 if ($c['eQty']>$quantity)
                 {
                 ?>
                 Add to:
                  <select class="form-control" name="" id="sOpt<?php echo $rc; ?>">
                   <option value="">Select</option>
                  <option value="SHOP">SHOP</option>
                   <option value="STORE">STORE</option> 
                 </select>
                 <input type="hidden"  id="confrv<?php echo $rc; ?>" name="confrv<?php echo $rc; ?>"  value="<?php echo $text; ?>" >
                 
                 <input type="hidden"  id="pQty<?php echo $rc;?>" name="pQty<?php echo $rc;?>"  value="<?php echo $quantity; ?>" >
                 
                 <input type="number" onkeypress="$('#sbq<?php echo $rc;?>').show();" style="width:100%;" class="form-control" id="recvq<?php echo $rc;?>" name="recvq<?php echo $rc;?>"  value="" >
                   <input type="Submit" onclick="var inam =document.getElementById('in<?php echo $rc;?>').innerHTML;var orderID =document.getElementById('orno<?php echo $rc;?>').innerHTML;var recvq=$('#recvq<?php echo $rc;?>').val();var sOpt=$('#sOpt<?php echo $rc;?>').val();var pQty=$('#pQty<?php echo $rc;?>').val(); var user=$('#user').val();var confrv=$('#confrv<?php echo $rc;?>').val(); var sdate=$('#sdate').val();    
                     if(sOpt!=''&&  orderID!=''&& inam!='' && recvq!=''&& sdate!='' && user!='') {$.post('pharmupdatePInvProLPO.php',{confrv:confrv,pQty:pQty,sOpt:sOpt,orderID:orderID,recvq:recvq,inam:inam,user:user,sdate:sdate},function(data){$('#rd<?php echo $rc; ?>').html(data).show();});   $('#sbq<?php echo $rc; ?>').hide();} else{document.getElementById('rd<?php echo $rc;?>').innerHTML='All field required!..';}" style="width:50px; display:none;"  id="sbq<?php echo $rc; ?>" name="sbq<?php echo $rc; ?>"  value="Save" >
                 
                 
                  <?php    
                 }
                 else 
                  {
                       echo $c['confrecv'];
                  } 
                } 
                
                }
                else
                 {
                  ?>
                  Add to:
                  <select class="form-control" name="sOpt<?php echo $rc; ?>" id="sOpt<?php echo $rc; ?>">
                   <option value="">Select</option>
                  <option value="SHOP">SHOP</option>
                   <option value="STORE">STORE</option> 
                 </select>
                 <input type="number" onkeypress="$('#sbq<?php echo $rc; ?>').show();" style="width:100%;" class="form-control" id="recvq<?php echo $rc;?>" name="recvq<?php echo $rc; ?>"   value="" >
                   <input type="Submit" onclick="var inam =document.getElementById('in<?php echo $rc;?>').innerHTML;var orderID =document.getElementById('orno<?php echo $rc;?>').innerHTML;
                     var recvq=$('#recvq<?php echo $rc;?>').val();var sOpt=$('#sOpt<?php echo $rc;?>').val();var pQty=0;pQty=$('#pQty<?php echo $rc;?>').val(); var user=$('#user').val();var confrv=''; var sdate=$('#sdate').val();   
                     if(sOpt!=''&& orderID!=''&& inam!='' && recvq!=''&& sdate!='' && user!='') {$.post('pharmupdatePInvProLPO.php',{confrv:confrv,pQty:pQty,sOpt:sOpt,orderID:orderID,recvq:recvq,inam:inam,user:user,sdate:sdate},function(data){$('#rd<?php echo $rc; ?>').html(data).show();});  $('#sbq<?php echo $rc; ?>').hide();} else{document.getElementById('rd<?php echo $rc;?>').innerHTML='Incomplete submission!..';}" style="width:50px; display:none;"  id="sbq<?php echo $rc; ?>" name="sbq<?php echo $rc; ?>"  value="Save" >
                   <?php
                } 
               ?>
             </td>
              
            </tr>
         <?php 
         }
         
         /////////////////
         } 
    }            
$cc=0; 
?>
 
</tbody>
</table> 
 
 