EVOLUTION-NINJA

Edit File: issue_cs_details.php

function location_function()
{
	
var location=$('#location_name').val();
$('#vendor_name').val(location);
		$.ajax({
            url:"<?php echo base_url('consumable/fetch_cs_location_data');?>",

type:"POST",
           		data:{'location':location},
				async:false,
		       		success:function(data)
		  {

var objData =JSON.parse(data);
    console.log(objData);
	
var contentt = '';
$("#table_row_data").empty();
var i=1;

$.each(objData.details,function(key,value)
{
 var ar_new2=objData.confirmed_data[key];
contentt += '<tr>';
contentt += '<td><input type="checkbox"  class="yarn_material_issue" value="'+value.id+'" style="width: 80px;border:transparent;">';
contentt += '<input type="hidden"  value="'+value.id+'" style="width: 80px;border:transparent;"></td>';
contentt += '<td><input type="text" name="purpose" style="width: 150px !important;border:transparent;" id="purpose" class="purpose" value="'+value.po_no+'" readonly="readonly"></td>';
contentt += '<td><input type="text" name="article" style="width: auto;border:transparent;" id="article" class="article art" value="'+value.product_name+'" readonly="readonly"></td>';
contentt += '<td><input type="text" name="shade" style="width: 150px;border:transparent;" id="shade" class="shade sha" value="'+value.product_type+'" readonly="readonly"></td>';
contentt += '<td><input type="text" name="weft_quality" style="width:auto;border:transparent;" id="weft_quality" class="weft_quality qual" value="'+value.indent_no+'" readonly="readonly"></td>';
contentt += '<td><input type="text" name="weft_quality" style="width: 80px;border:transparent;" id="weft_quality" class="weft_quality qual" value="'+value.department+'" readonly="readonly"></td>';

contentt += '<td><input type="text" name="weft_spec" style="width: 80px;border:transparent;" id="weft_spec" class="weft_spec spec" value="'+value.quantity+'" readonly="readonly"></td>';
contentt += '<td><input type="text" name="weft_denier" style="width: 80px;border:transparent;" id="weft_denier" class="weft_denier denier" value="'+value.total_quantity+'" readonly="readonly"></td>';
contentt += '<td ><input type="text" name="weft_color_code" style="width: 80px;border:transparent;" value="'+ar_new2+'" id="weft_color_code" class="weft_color_code color_code"  readonly="readonly"></td>';
contentt += '</tr>';
});

$("#table_row_data").html(contentt);
$('#myModal_weft_dying').modal('show');

}

});
	 
}

</script>
<script>
$(function () {
        $("#sys_date").datepicker({
            dateFormat: "dd/mm/yy",
            changeMonth: true,
            changeYear: true
        });
    });
	
function m_function()
{
	var location=$('#vendor_name').val();
	$('#location_name').val(location);
	
		$.ajax({
            url:"<?php echo base_url('consumable/fetch_cs_location_data');?>",

type:"POST",
           		data:{'location':location},
				async:false,
		       		success:function(data)
		  {

var objData =JSON.parse(data);
    console.log(objData);
	
var contentt = '';
$("#table_row_data").empty();
var i=1;

$("#table_row_data").html(contentt);

$('#myModal_weft_dying').modal('show');

}

});
			
}

$(document).ready(function () {
        $('input[type="radio"]').click(function () {
		if ($(this).attr("value") == "all")
		{
			$("#all_location").show();
			 $("#ho_location").hide();
			 $("#peenya_location").hide();
			 $("#tailoring_location").hide();
			 $("#nandi_location").hide();
		}	
         if ($(this).attr("value") == "ho") {
				$("#ho_location").show();
                $("#peenya_location").hide();
				$("#all_location").hide();
				 $("#tailoring_location").hide();
			 $("#nandi_location").hide();
               
            }      
		if ($(this).attr("value") == "peenya")
			{
                $("#ho_location").hide();
                $("#peenya_location").show();
				$("#all_location").hide();
				 $("#tailoring_location").hide();
			 $("#nandi_location").hide();
				
            }
		if ($(this).attr("value") == "nandi")
		{
			 $("#tailoring_location").hide();
			 $("#nandi_location").show();
			$("#ho_location").hide();
			$("#peenya_location").hide();
			$("#all_location").hide();
			
		}
		if ($(this).attr("value") == "tailoring")
			{
				 
				 $("#tailoring_location").show();
			 $("#nandi_location").hide();
                $("#ho_location").hide();
                $("#peenya_location").hide();
				$("#all_location").hide();
				
            }
		
		
        });
    });	
</script>
<script>

function swan_myFunction() {
 //alert();
  var input, filter, table, tr, td, i;
  input = document.getElementById("search_yarn_swan");
  
  filter = input.value.toUpperCase();
  table = document.getElementById("table_row_data");
  tr = table.getElementsByTagName("tr");

// Loop through all table rows, and hide those who don't match the search query
  for (i = 0; i < tr.length; i++) {
	 // alert() 
    td = tr[i].getElementsByTagName("td")[1];
	td2 = tr[i].getElementsByTagName("td")[2];
	td3 = tr[i].getElementsByTagName("td")[3];
	td4 = tr[i].getElementsByTagName("td")[4];
	td5 = tr[i].getElementsByTagName("td")[5];
	td6 = tr[i].getElementsByTagName("td")[6];
	td7 = tr[i].getElementsByTagName("td")[7];
	//td8 = tr[i].getElementsByTagName("td")[8];
	//td9 = tr[i].getElementsByTagName("td")[9];
	// td10 = tr[i].getElementsByTagName("td")[10];
	// td11 = tr[i].getElementsByTagName("td")[11];
  //  if (td) {
      if (td.innerHTML.toUpperCase().indexOf(filter) > -1 ||  td2.innerHTML.toUpperCase().indexOf(filter) > -1 || td3.innerHTML.toUpperCase().indexOf(filter) > -1 || td4.innerHTML.toUpperCase().indexOf(filter) > -1 || td5.innerHTML.toUpperCase().indexOf(filter) > -1 || td6.innerHTML.toUpperCase().indexOf(filter) > -1 || td7.innerHTML.toUpperCase().indexOf(filter) > -1) {
        tr[i].style.display = "";
      } else {
        tr[i].style.display = "none";
      }
    //} 
  }
 }
</script>

<?php if (date('m') <= 3) {//Upto June 2014-2015
    $financial_year = (date('y')-1) . '-' . date('y');
} else {//After June 2015-2016
    $financial_year = date('y') . '-' . (date('y') + 1);
}
?>	
<div class="page-content-wrapper">
	<div class="page-content">		
		<?php // echo $this->load->view('templates/nav_menu'); ?>		
			<div class="page-bar">
		<ul class="page-breadcrumb">
			<li><i class="fa fa-home"></i> <a href="<?php echo base_url(); ?>dashboard/dashboard_fun">Home</a> <i
			class="fa fa-angle-right"></i> <a href="<?php echo base_url('consumable/consumables_spares?prop_id=1'); ?>" >Issue Consumable and Spares </a></li>
		</ul>
	</div>
 <div id="twisting">
			<div class="portlet-body form">
			
			<div class="content-wrapper">
			
			
			<section class="body-middle">
				<div class="twisting">
					<table style="width:100%">
						<tr style="background:#337AB7; color:#fff;">
							<td colspan="14"><strong>Consumables and Spares</strong></td>
						</tr>
						
						<tr>
							<td colspan="14">Work Order # &nbsp &nbsp &nbsp &nbsp : &nbsp &nbsp <input type="text" class="text-input1 work_order" value="<?php echo 'DTL'.$financial_year.'-WO-'.'CS'.$max_id; ?>" id="work_order" name="work_order"></td>
							<input type="hidden" class="text-input1 work_order_num" value="<?php echo $max_id; ?>" id="work_order_num" name="work_order_num">
						</tr>
<tr>
							<td colspan="14">Location Name &nbsp &nbsp &nbsp  : &nbsp &nbsp 
							<select id="vendor_name" name="vendor_name" style="width: 162px;border: transparent;padding-top: 4px;
    padding-bottom: 5px;">
					<option value="">Select Location</option>
						<?php if(isset($consumed_at)) { foreach($consumed_at as $consumed_at) { ?>
						<option value="<?php echo $consumed_at->consumed_at; ?>"><?php echo $consumed_at->consumed_at; ?></option>
						<?php }}  ?>
					</select></td>
						</tr>
						<tr>
						<td colspan="14">Department / Person Name : &nbsp &nbsp <input type="text" class="text-input1 dept_name openDatePicker" id="dept_name" name="dept_name"></td>
						
						</tr>
						<tr>
						<td colspan="14">Issue Date &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp : &nbsp &nbsp <input type="text" class="text-input1 sys_date openDatePicker" id="sys_date" name="sys_date" data-provide="datepicker" value="<?php echo Date('d-m-Y'); ?>"></td>
						 <input type="hidden" value="<?php echo $url_refrer_val; ?>" id="url_ref_value" style="width: 230px;" >
						</tr>
					
									
					</table>
				</div>
				
				<div class="material">
					<table style="width:100%">
						<tr style="background:#337AB7; color:#fff;">
							
							
							<td colspan="13"><strong>Consumables and Spares Issues</strong> <button style="margin-left: 25%;color:#fff;" id="waeving_modal"  onclick="m_function()" name="weaving_modal"> <i class="fa fa-plus" style="color:#337AB7;;"></i></button</td>
							
						</tr>
						
						<tr class="material-tr">
							<td>SI #</td>
							<td>PO No.</td>
							<td>Product Name</td>
							<td>Product Type</td>
							<td>Department</td>
						
							<td>Quantity</td>
							<td>Issue Quantity</td>
							<td>Balanced Quantity</td>
						</tr>
						<tbody class="yarnTbody" id="yarnTbody" name="yarnTbody">	
						<tr>
							<td style="width:4%;text-align:right;">1</td>
							<td style="width:5%;"><input type="text" class="text-input m_yarn_name" name="m_yarn_name" id="m_yarn_name"></td>
							<td style="width:8%;"><input type="text" class="text-input m_yarn_denier" name="m_yarn_denier" id="m_yarn_denier"></td>
							<td style="width:8%;"><input type="text" class="text-input m_yarn_denier" name="m_yarn_denier" id="m_yarn_denier"></td>
							<td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td>
							<td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td>
							<td style="width:17%;"><input type="text" class="text-input m_gweight m_gross_weight" name="m_gross_weight" id="m_gross_weight" onkeyup="gross_weight(this.value)"></td>
							<td style="width:5%;"><input type="text" class="text-input inspected_mtrs" name="inspected_mtrs" id="inspected_mtrs"></td>
							
						</tr>
						</tbody>
					</table>
				</div>
				
			</section>
		</div>  	
			
		</div> 
		
		<input type="hidden" class="ids"  >
		 <div class="modal-footer">
		
		
		
			<button  name="submit_data" id="submit_data" class="btn center-block submit ss" style="background:rgb(35,134,202);color:white;float: left;
    ">Submit</button>
		 <?php if($url_refrer_val == '1') { ?>
																<a href="<?php echo base_url(); ?>consumable/consumables_spares?prop_id=1" class="btn default" style="background:rgb(35,134,202);color:white;float: left;">Cancel</a>
															<?php } else if($url_refrer_val == '2') { ?>
																<a href="<?php echo base_url(); ?>consumable/consumables_spares?prop_id=2" class="btn default" style="background:rgb(35,134,202);color:white;float: left;">Cancel</a>
															<?php } else if($url_refrer_val == '3') { ?>
																	<a href="<?php echo base_url(); ?>consumable/consumables_spares?prop_id=3" class="btn default" style="background:rgb(35,134,202);color:white;float: left;">Cancel</a>
															<?php } else if($url_refrer_val == '4') { ?>
																	<a href="<?php echo base_url(); ?>consumable/consumables_spares?prop_id=4" class="btn default" style="background:rgb(35,134,202);color:white;float: left;">Cancel</a>
															<?php } ?>
	  </div>
	</div>	
	
	<div id="myModal_weft_dying" class="modal fade" role="dialog" style="color:#000;">
					  <div class="modal-dialog" >
							
							    
							    <div class="modal-content" style="    width: 1282px;
   ">
							      <div class="modal-header">
							        <button type="button" class="close" data-dismiss="modal">&times;</button>
							        <h4 class="modal-title">Consumables and Spares Details</h4>
							      </div>
							      <div class="modal-body">
							     
									<fieldset>
									  <div >
									
							      <button  id="generate" class="btn btn-primary generate" value="Generate" style="float:right;" data-dismiss="modal" >Submit</button>
							       
							   
							   
							   <div class="row" style="padding-bottom:15px;">
						<div class="col-sm-4"></div>
						<div class="col-sm-6">
						<select id="location_name" onchange="location_function()" name="location_name" style="border: transparent;padding-top: 4px;
    padding-bottom: 5px;">
					<option value="">Select Location</option>
						<?php if(isset($location)) { foreach($location as $consumed_at) { ?>
						<option value="<?php echo $consumed_at->consumed_at; ?>"><?php echo $consumed_at->consumed_at; ?></option>
						<?php }}  ?>
					</select>
						</div>
						<div class="col-sm-4"></div>							
					</div>  
					
					
					
									
						<div id="all_location">
													<div class="portlet-body" id="portlet-body">
										<div class="col-xs-6">
										<label class="col-sm-2 col-xs-2" style="padding-right:0 !important;"><b>Search :</b> </label>
					<input type="text" id="search_yarn_swan" onkeyup="swan_myFunction()" class=" col-xs-5" placeholder="Type to search">
					</div>
							
						<br/><br/>
								<table class="table table-striped table-bordered table-hover" id="sample">
							<thead>
							<tr>
								<th>
									Select 
								</th>
								
								<th>
									PO No.
								</th>
								
								<th>
									 Product Name
								</th>
								<th>
									Product Type
								</th>
                                <th>
									Indent No.
								</th>
								 <th>
									 Department
								</th>
								<th>
									Total Quantity
								</th>
								 <th>
									Received Quantity
								</th>
                             <th>
									Location
								</th>
								
							</tr>
							</thead>
							<tbody id="table_row_data">
							
								
							</tbody>
							</table>
						</div>
							
				
		</fieldset>
										
	 </div>
	 
		</div>
  </div>
</div> 					
		 
		
		
	</div> 
</div> 
<script>
$("#generate").on('click', function () {
	//alert();
    var checkbox_value = "";
    $(":checkbox").each(function () {
        var ischecked = $(this).is(":checked");
        if (ischecked) {
		checkbox_value += $(this).val() + "|";
        }
       
    });

//  alert(checkbox_value);
	 var ids= $(".ids").val(checkbox_value);
	//alert(ids);
	$.ajax({
            url:"<?php echo base_url('consumable/fetch_fabric_checkbox_data');?>",

type:"POST",
           		data:{'ids':checkbox_value },
				async:false,
		        success: function (data) {
			 var objData = jQuery.parseJSON(data);
				var content = '';
	
				$("#yarnTbody").empty();
					var i=1;
					//var key=0;
                var content = '';
	
				$("#yarnTbody").empty();
					var i=1;
					//var key=0;
                  $.each(objData,function(key,val){
				
	//alert(val.id);
		content += '<tr >';
		content += '<td style="width:4% !important;text-align:right;"><input type="text" name="id"';
		content += 'id="id" class="id" value="'+i+'" style="width:20px !important;border:0px !important;padding:0px !important;" readonly="readonly"/><input type="hidden" class="sl_id" id="sl_id"  value="'+val.id+'" ></td>';
		
		content += '<td style="width:10% !important;text-align:right; padding:0px !important;" ><input type="text" name="po_no"';
		content += 'id="po_no" class="po_no" value="'+val.po_no+'" style="width:94px !important;border:0px !important" readonly="readonly"/></td>';
		
		content += '<td style="width:10% !important;text-align:right;"><input type="text" name="product_name"';
		content += 'id="product_name" class="product_name" value="'+val.product_name+'" style="width:200px !important;border:0px !important;padding:0px !important;" readonly="readonly"/></td>';
		
		
		
		content += '<td style="width:8% !important;text-align:right; padding:0px !important;"><input type="text" name="product_type"';
		content += 'id="product_type" class="product_type" value="'+val.product_type+'" style="width:120px !important;border:0px !important" readonly="readonly"/></td>';
		
		content += '<td style="width:8% !important;text-align:right; padding:0px !important;"><input type="text" name="department"';
		content += 'id="department" class="department" value="'+val.department+'" style="width:120px !important;border:0px !important" readonly="readonly"/></td>';
		
		content += '<td style="width:8% !important;text-align:right; padding:0px !important;"><input type="text" name="total_quantity"';
		content += 'id="total_quantity" class="total_quantity'+i+' t_quantity" value="'+val.total_quantity+'" style="width:120px !important;border:0px !important" readonly="readonly"/></td>';
		
		content += '<td style="width:8% !important;text-align:right; padding:0px !important;"><input type="text" name="issue_quantity"';
		content += 'id="issue_quantity" class="issue_quantity'+i+' i_quantity"  onkeyup="dyeing_unitvalue(this.value,'+i+')" style="width:120px !important;border:0px !important" /></td>';
		
		content += '<td style="width:8% !important;text-align:right; padding:0px !important;"><input type="text" name="balanced_quantity"';
		content += 'id="balanced_quantity" class="balanced_quantity'+i+' b_quantity"  style="width:120px !important;border:0px !important" readonly="readonly"/></td>';
		
		content += '</tr>';
					
					i++;
		//key++;
			
			});
	$("#yarnTbody").html(content);

}

});
    
});
</script>

var val = $.trim($(this).val()).replace(/ +/g, ' ').toLowerCase();
    
    $rows.show().filter(function() {
        var text = $(this).text().replace(/\s+/g, ' ').toLowerCase();
          return !~text.indexOf(val);
    }).hide();
	});

</script>
<script src="<?php echo base_url(); ?>assets/js/sweetalert.min.js" type="text/javascript"></script>
<link href="<?php echo base_url(); ?>assets/css/sweetalert.min.css" rel="stylesheet" type="text/css" >
<script>
		
		sl_id=[];
		po_no=[];
		product_name=[];
		product_type=[];
		department=[];
		total_quantity=[];
		balanced_quantity=[];
		issue_quantity=[];
$("#submit_data").click(function(e) {
	e.preventDefault();

//	var ids =$('.ids').val();
		var work_order =$('#work_order').val();
		var work_order_num =$('#work_order_num').val();
			var vendor_name =$('#vendor_name').val();
		var sys_date =$('#sys_date').val();
			var dept_name =$('#dept_name').val();
	
	if(dept_name != '' && sys_date != '')
	{
		
	$('.sl_id').each(function () {
		sl_id.push($(this).val());
		
	});	
	$('.po_no').each(function () {
		po_no.push($(this).val());
		
	});	
	
	$('.product_name').each(function () {
		product_name.push($(this).val());
		
	});	
	
	$('.product_type').each(function () {
		product_type.push($(this).val());
		
	});	
	
	$('.department').each(function () {
		department.push($(this).val());
		
	});	
	$('.t_quantity').each(function () {
		total_quantity.push($(this).val());
		
	});	
	
	$('.b_quantity').each(function () {
		balanced_quantity.push($(this).val());
		
	});	
	
	$('.i_quantity').each(function () {
		issue_quantity.push($(this).val());
		
	});	
	
	
	var i=parseFloat(issue_quantity);
	var t=parseFloat(total_quantity);
	
	//alert(i);
//alert(t);	
	if(i > t)
	{
		 swal({
	 title: "Issued Stock is Exceeded",
	  text: "",
	 
	});
	
		//alert('Issued Stock is Exceeded');
		 issue_quantity.length=0;
		total_quantity.length=0;
		 balanced_quantity.length=0;
	}
	else
	{
		//alert();
		 $.ajax({
            url:"<?php echo base_url('consumable/insert_cs_data');?>",

type:"POST",
           
				data:{'dept_name':dept_name,'work_order_num':work_order_num,'work_order':work_order,'vendor_name':vendor_name,'sys_date':sys_date,'sl_id':sl_id,'po_no':po_no,'product_name':product_name,'product_type':product_type,'department':department,'total_quantity':total_quantity,'balanced_quantity':balanced_quantity,'issue_quantity':issue_quantity},

async:false,

success:function(data){

$(document).ready(function(){	
	   $('#issue_stock').on('change keyup', function() {
		  var sanitized = $(this).val().replace(/[^0-9.]/g, '');
		  $(this).val(sanitized);
		});
	});	
	$(document).ready(function(){	
	   $('#issue_quantity').on('change keyup', function() {
		  var sanitized = $(this).val().replace(/[^0-9.]/g, '');
		  $(this).val(sanitized);
		});
	});	
$(document).ready(function(){	
	   $('.i_quantity').on('change keyup', function() {
		  var sanitized = $(this).val().replace(/[^0-9.]/g, '');
		  $(this).val(sanitized);
		});
	});		
</script>
<style>
		#dying{
			display:none;
		}					
	.form-horizontal .radio-inline {
    padding-top: 2px !important;
    margin-top: 0;
    margin-bottom: 0;
	}
	.form-horizontal .radio > span {
	    margin-top: -3px !important;
	}						
	.skin-blue .wrapper, .skin-blue .left-side {
		background-color: #ffffff !important;
	}
	
	.skin-blue .main-sidebar
	{
		background-color: #e6e6e6 !important;
	}

@media only screen and (min-width:641px) and (max-width:991px) {
		.form-group label{
			padding-left:20px !important;
		}
	}
	
	.body-middle
	{
		//width:550px;
		padding-top: 20px;
		padding-left: 20px;
		padding-right: 20px;
		color:#000;
	}
	
	.twisting
	{
		padding-bottom:50px;
	}
	
	.twisting table, th, td {
		border: 1px solid black;
		border-collapse: collapse;
	}
	
	.twisting th, td {
		padding:5px;
	}
	
	.text-input
	{
		border: initial;
		width:100%;
	}
	.text-input1
	{
		border: initial;
		width:80%;
	}
	.material-tr td
	{
		text-align:center;
	}
	
	#ui-id-1
	{
		display: none;
width: 350px;
top: 258px;
overflow-x: hidden !important;
overflow-y: scroll !important;
height: 203px !important;

} 
	#ui-id-2
	{
		display: none;
width: 350px;
top: 258px;
overflow-x: hidden !important;
overflow-y: scroll !important;
height: 203px !important;

} 
</style>