<!DOCTYPE html>
<html lang="en">


<!-- Mirrored from edumin.dexignlab.com/xhtml/add-departments.html by HTTrack Website Copier/3.x [XR&CO'2014], Tue, 17 Nov 2020 13:56:15 GMT -->
<head>
    
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width,initial-scale=1">
    <title>Rizwan </title>
    <!-- Favicon icon -->
    <link rel="icon" type="image/png" sizes="16x16" href="<?php echo base_url();?>assets/images/favicon.png">
    <link rel="stylesheet" href="<?php echo base_url();?>assets/vendor/bootstrap-select/dist/css/bootstrap-select.min.css">
    <link rel="stylesheet" href="<?php echo base_url();?>assets/css/style.css">
    <!-- Pick date -->
   <link rel="stylesheet" href="<?php echo base_url();?>assets/vendor/pickadate/themes/default.css">
    <link rel="stylesheet" href="<?php echo base_url();?>assets/vendor/pickadate/themes/default.date.css">
     <link href="<?php echo base_url();?>assets/vendor/datatables/css/jquery.dataTables.min.css" rel="stylesheet">
    <!-- Custom Stylesheet -->
       <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
    <link href="https://cdn.datatables.net/1.11.3/css/dataTables.bootstrap.min.css">

</head>

<body>

    <!--*******************
        Preloader start
    ********************-->
        <div id="preloader">
        <div class="sk-three-bounce">
            <div class="sk-child sk-bounce1"></div>
            <div class="sk-child sk-bounce2"></div>
            <div class="sk-child sk-bounce3"></div>
        </div>
    </div>
    <!--*******************
        Preloader end
    ********************-->

    <!--**********************************
        Main wrapper start
    ***********************************-->
    <div id="main-wrapper">

      <?php  $this->load->view('header'); ?>
        
        <!--**********************************
            Content body start
        ***********************************-->
        <div class="content-body">
            <!-- row -->
            <div class="container-fluid">
                    
                <div class="row page-titles mx-0">
                    <div class="col-sm-6 p-md-0">
                        <div class="welcome-text">
                            <h4>Material Request</h4>
                        </div>
                    </div>
                    <div class="col-sm-6 p-md-0 justify-content-sm-end mt-2 mt-sm-0 d-flex">
                        <ol class="breadcrumb">
                            <li class="breadcrumb-item"><a href="index.html">Home</a></li>
                            <li class="breadcrumb-item active"><a href="javascript:void(0);">Purchase Order</a></li>
                            <li class="breadcrumb-item active"><a href="javascript:void(0);">Add Order</a></li>
                        </ol>
                    </div>
                </div>
                
                <div class="row">


                    <div class="col-12">
            
                        

                            <div class="col-12">

                                 <div class="card">

                            <div class="card-body">
                                <button type="button" class="btn btn-rounded btn-success" onclick="btnExport_monthly();"><span class="btn-icon-left text-success"><i class="fa fa-download color-success"></i>
                                    </span>Download</button>
                               <br/><br/><br/>
                                <div class="table-responsive">

                                    <table  id="example" class="table table-striped table-bordered" style="font-size:12px; ">
                                        <thead>
                                            <tr>
                                                <th>Sno#</th>
                                               <!--  <th>PO#</th> -->
                                                <th>Materials</th>
                                               
                                                <th>Qty</th>
                                                 <th>Unit</th>
                                                  <th>Action</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php $count =1; ?>
                                            <?php if(!empty($material_request)){ ?>
                                                <?php foreach ($material_request as  $value) {
                                                    
                                                 ?>
                                          <tr>
                                              <td><?php echo $count; ?></td>
                                            
                                             
                                             <td><?php echo material_name($value['material_id']); ?></td>
                                              
                                              <td><?php  
                                              $total_bom=$value['totalqty']; 
                                              $total_po = get_mat_totalqty($value['material_id']);

                                                echo $total_bom-$total_po;
                                               ?></td>
                                              
                                              <td><?php echo get_unit_name($value['unit']); ?></td>

                                               <td>
                                           <a href="<?php echo base_url('Purchase_order/create_po_material/'.$value['material_id']);?>/<?php echo $value['totalqty']; ?>/<?php echo $value['unit']; ?>">Create P.O</a></td>
                                          </tr>

                                      <?php 
                                       $count ++;
                                  } 

                                  } ?>
                                        </tbody>
                                        <tbody>
                                          
                                            
                                        </tbody>
                                    </table>
                                </div>
                                
                            </div>
                            </div>
                            </div>
                        </div>
                    </div>

                   
                </div>
            </div>
       
        <!--**********************************
            Content body end
        ***********************************-->


        <!--**********************************
            Footer start
        ***********************************-->
        
        <!--**********************************
            Footer end
        ***********************************-->

        <!--**********************************
           Support ticket button start
        ***********************************-->

        <!--**********************************
           Support ticket button end
        ***********************************-->


    </div>
    

    <div class="modal fade bd-example-modal-lg" style="width: 100%;" tabindex="-1" role="dialog" aria-hidden="true">
              <div class="modal-dialog modal-lg">
                  <div class="modal-content">
                      <div class="modal-header">
                        
                          <button type="button" class="close" data-dismiss="modal"><span>&times;</span>
                          </button>
                      </div>
                      <div class="modal-body">
                    
                   
                         <div class="card-body" id="invoice_details">
                    
                          </div>
                      



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

        <script src="https://code.jquery.com/jquery-3.5.1.js"></script>
         <script src="https://cdn.datatables.net/1.11.3/js/jquery.dataTables.min.js"></script>
         <script src="https://cdn.datatables.net/1.11.3/js/dataTables.bootstrap.min.js"></script>

         <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>

         
        <style>
        .redborder{
            border:1px solid red;
        }
        </style>


        <SCRIPT language=Javascript>
       <!--
       function isNumberKey(evt)
       {
          var charCode = (evt.which) ? evt.which : evt.keyCode;
          if (charCode != 46 && charCode > 31 
            && (charCode < 48 || charCode > 57))
             return false;

          return true;
       }
       //-->
    </SCRIPT>

    <script type='text/javascript'>



      

      $("#select").change(function() {

        
    
        var id =  this.value;
        
       //var segment = $('#product_id').val();
        var po_id = $('#po_id').val();
        $.ajax({
                    type:'POST',
                    url:'<?php echo base_url('Purchase_order/view_design_pro_mat_packing'); ?>',
                    data:{id:id,po_id:po_id},
                    dataType:'json',
                    success:function(data){
                        //console.log(data[0].material_code);
                        //$('.grade').val(data[0].grade);
                        //$('.code').val(data[0].material_code);
                       $('#show_form').show().html(data.html);
                        
                        //$("#show_form").append(data);
                       
                    },
                    error:function(data){console.log(data.responseText);}
                });

    });

      function view_po_invoice(id) { 
      var id =  id;
      
      $.ajax({
                type:'POST',
                url:'<?php echo base_url('Purchase_order/view_invoice_details'); ?>',
                data:{id:id},
                dataType:'json',
                success:function(data){
                    console.log('first'+data);
                    //if(data.status === 'true'){
                     $('#invoice_details').show().html(data.html);
                       //$('#bom_details').show(data);
                   /* }else{
                        //console.log('third'+data);          
                    }*/
                },
                error:function(data){console.log(data.responseText);}
            });
       
        } 


        
    var add_order = $('#add_purchase_order');   
    
    add_order.on('submit',function(e){
  $("#dis_submit").attr('disabled', true);
        e.preventDefault();
          if (confirm('Are you sure you want to Save.?')) {
  
        var add_add_order = add_order.serialize();
         //var id = $('#main_product').val();
      
            $.ajax({
                type:'POST',
                url:'<?php echo base_url('Purchase_order/add_purchase_order'); ?>',
                data:add_add_order,
                dataType:'json',
                success:function(data){
                
                    console.log('first'+data.status);
                    if(data.status === 'true'){
                        console.log('second'+data.status);
                        $('#purchase_order_success').show().html('Purchase Order added Successfully');
                       setTimeout(function(){location.href="<?php echo base_url('Purchase_order/purchase_order_all/'); ?>"} , 2000);
                    }else{
                        console.log('third'+data);          
                    }
                },
                error:function(data){console.log(data.responseText);}
            });
        }
    });

    function delete_data(id) { 
        var id = id;
        if (confirm('Are you sure you want to Delete.?')) {
  

        var pro_id = $('#product_id').val();
         $.ajax({
                type:'POST',
                url:'<?php echo base_url('Purchase_order/purchase_order_delete_data/'); ?>'+id,
                data:id,
                dataType:'json',
                success:function(data){
                    location.reload();
                    
                },
                error:function(data){console.log(data.responseText);}
            });

         //location.reload();

         } else {
  
            }
        } 



       /* $("#vendor_id").change(function() {
    
        var id =  this.value;

        $.ajax({
                    type:'POST',
                    url:'<?php echo base_url('Purchase_order/get_code'); ?>',
                    data:{id:id},
                    dataType:'json',
                    success:function(data){
                        //console.log(data[0].material_code);
                          //$('#code').val(data);
                        $('.code').val(data[0].vendors_code);
                       
                       //$('.weight').val(data[0].weight);
                       
                    },
                    error:function(data){console.log(data.responseText);}
                });

    });*/



 function btnExport_monthly()
{
    
    var tab_text="<table border='2px'><tr bgcolor='#ebebeb'>";
    var textRange; var j=0;
    tab = document.getElementById('example'); // id of table

    for(j = 0 ; j < tab.rows.length ; j++) 
    {     
        tab_text=tab_text+tab.rows[j].innerHTML+"</tr>";
        //tab_text=tab_text+"</tr>";
    }

    tab_text=tab_text+"</table>";
    tab_text= tab_text.replace(/<A[^>]*>|<\/A>/g, "");//remove if u want links in your table
    tab_text= tab_text.replace(/<img[^>]*>/gi,""); // remove if u want images in your table
    tab_text= tab_text.replace(/<input[^>]*>|<\/input>/gi, ""); // reomves input params


    var ua = window.navigator.userAgent;
    var msie = ua.indexOf("MSIE "); 

    if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./))      // If Internet Explorer
    {
        txtArea2.document.open("txt/html","replace");
        txtArea2.document.write(tab_text);
        txtArea2.document.close();
        txtArea2.focus(); 
        sa=txtArea2.document.execCommand("SaveAs",true,"Generation_School_Report");
    }  
    else                 //other browser not tested on IE 11
        sa = window.open('data:application/vnd.ms-excel,' + encodeURIComponent(tab_text));  

    return (sa);
}
    
    </script>   

       <?php  $this->load->view('footer'); ?>
        
</body>

<!-- Mirrored from edumin.dexignlab.com/xhtml/add-departments.html by HTTrack Website Copier/3.x [XR&CO'2014], Tue, 17 Nov 2020 13:56:15 GMT -->
</html> 