EVOLUTION-NINJA

Edit File: yarn_remnants.php

#refresh_list6
{
	display:none !important;
}
#refresh_list4
{
	display:none !important;
}
#refresh_list5
{
	display:none !important;
}

.ui-jqgrid
{
	    text-transform: capitalize !important;
}
.tablediv
{

text-transform: uppercase !important;

}
.ui-jqgrid tr.jqgrow td{ 
text-transform: uppercase !important;
}
</style>
<div class="page-content-wrapper">
<div class="page-content">

<h3 class="page-title">
Yarn - Raw Stock Details
</h3>
<?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="https://swansilk.co/dashboard/dashboard_fun">Home</a> <i
			class="fa fa-angle-right"></i> <a href="#" > Yarn - Raw Stock Details </a></li>
		</ul>
	</div>

<input type="hidden" id="preview_id" class="preview_id" value="<?php if(empty($access_row)){ } else { echo $access_row->preview_id; } ?>" >
<input type="hidden" id="edit_id" class="edit_id" value="<?php if(empty($access_row)){ } else { echo $access_row->edit_id; } ?>" >

<div class="row date_row">
		<form action="<?php echo base_url('reports/raw_stock_data'); ?>" method="post" class="form">	
				<div class="col-md-3">
					<div class="form-group">
						 <label class="control-label col-md-4">From Date :</label>
						<div class="col-md-8">
							 <input type="text" class="form-control input-group openDatePicker from_delivery_date_required_on" name="from_delivery_date_required_on" id="from_delivery_date_required_on"  data-provide="datepicker">
						</div>
					</div>
				</div>

<div class="col-md-3">
					<div class="form-group">
						 <label class="control-label col-md-4">To Date :</label>
						<div class="col-md-8">
							 <input type="text" class="form-control input-group openDatePicker to_delivery_date_required_on" name="to_delivery_date_required_on" id="to_delivery_date_required_on"  data-provide="datepicker" >
						</div>
					</div>
				</div>
<div class="col-md-3">
					<div class="form-group">
						 <label class="control-label col-md-4">Location :</label>
						<div class="col-md-8">
							<select class="form-control" id="location" name="location">
								<option value="all">ALL</option>
								<?php foreach($loc as $loc){ ?>

<option value="<?php echo $loc->consumed_at; ?>"><?php echo $loc->consumed_at; ?></option>

<?php } ?>
							</select>
						</div>
					</div>
				</div>
				<div class="col-md-3">
			<input type="submit" id="" value="Submit" class="" style="margin-right: 22px;"/>	
			<button type="button" onclick="export_page();" style="padding-top: 4px;padding-bottom: 4px;" class="btn btn-primary">Export </button>	
		
			</div>
		</form>
	</div>

<form action="<?php echo base_url('stock_history_details/stock_piece_card'); ?>" target="_blank" method="post" class="formids">
		<input type="hidden" id="checked_ids" name="checked_ids" class="checked_ids">
		<input type="hidden" id="checked_radios" name="checked_radios" class="checked_radios" value="<?php echo 'raw_yarn';?>">
	</form>

<input type="hidden" id="yarn_type"  class="yarn_type" name="yarn_type" value="raw_yarn">

<div id = "jaytab1" class="jaytab">
					<table id="list3"></table>
					<div id="pager3"></div>
					<div id="dialogSelectRow" title="Warning" style="display:none">
						<p>Please select row</p>
					</div>									
				</div>	
				
				
				
</div>
</div>
</div>
<div style="display:none;"><table  border="1" style="border-spacing: 0px !important;" id="export_table" class="export_table"></table></div>

<link rel="stylesheet" href="<?php echo base_url('assets/css/code_jquery.min.css');?>">
<script src="<?php echo base_url('assets/js/jquery-ui.min.js'); ?>" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.min.css'); ?>" />

<link rel="stylesheet" href="<?php echo base_url('assets/css/code_jquery.min.css');?>">
<script src="<?php echo base_url('assets/js/jquery-ui.min.js'); ?>" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.min.css'); ?>" />
<script>
$("#generate_submit").on('click', function () {
	var id='';
	 $("input[type=checkbox]:checked").each(function() {
		  id += $(this).closest('tr').attr('id') + "|";
		  	
   });
	//alert();
	$(".checked_ids").val('');  
		$(".checked_ids").val(id);  
    $(".formids").submit(); 
});
function export_page() {
	
	id = jQuery("#list3").jqGrid('getDataIDs');
	var type= $('#type').val();
	
	$.ajax({
        type   : 'post',
      url:"<?php echo base_url('out_source/fetch_yarn_raw_data')?>",	
        data   : {id:id},
                                  
          success:function(data){
          response=jQuery.parseJSON(data);
		 		  
		  //alert(d);
          console.log(response);
         var count =1;
         $('.export_table').empty();
		 var received_qty=0;
		 rec_weight =0;
issue_net_weight=0;
issue_gross_weight=0;
variance_mtrs=0;
                var content = '';
                content +='<thead><tr><th><b>SL NO.</b></th><th><b>Purpose</b></th><th><b>Yarn Details</b></th> <th><b>Yarn Denier</b></th> <th><b>Yarn Specification</b></th> <th><b>SSL Shade</b></th> <th><b>Shade</b></th><th><b>Lot</b></th> <th><b>Bale</b></th> <th><b>Gross Weight</b></th> <th><b>Net Weight</b></th> <th><b>PO#</b></th>  <th><b>Rate</b></th><th><b>Location</b></th><th><b>Received Date</b></th></tr></thead>';
                   
				   
				 
					$.each(response,function(key,vas){
					
					issue_gross_weight +=parseFloat(vas.issue_gross_weight);
issue_net_weight +=parseFloat(vas.issue_net_weight);

function export_page_list() {
	
	id = jQuery("#list3").jqGrid('getDataIDs');
	var type= $('#type').val();
	
	$.ajax({
        type   : 'post',
      url:"<?php echo base_url('out_source/fetch_yarn_raw_data')?>",	
        data   : {id:id},
                                  
          success:function(data){
          response=jQuery.parseJSON(data);
		 		  
		  //alert(d);
          console.log(response);
         var count =1;
         $('.export_table').empty();
		 var received_qty=0;
		 rec_weight =0;
issue_net_weight=0;
issue_gross_weight=0;
variance_mtrs=0;
                var content = '';
                content +='<thead><tr><th><b>SL NO.</b></th><th><b>Purpose</b></th><th><b>Yarn Details</b></th> <th><b>Yarn Denier</b></th> <th><b>Yarn Specification</b></th> <th><b>SSL Shade</b></th> <th><b>Shade</b></th><th><b>Lot</b></th> <th><b>Bale</b></th> <th><b>Gross Weight</b></th> <th><b>Net Weight</b></th> <th><b>Location</b></th><th><b>Received Date</b></th></tr></thead>';
                   
				   
				 
					$.each(response,function(key,vas){
					
					issue_gross_weight +=parseFloat(vas.issue_gross_weight);
issue_net_weight +=parseFloat(vas.issue_net_weight);

content +='<tr><td>'+count+'</td> <td>'+vas.purpose+'</td> <td>'+vas.yarnname+'</td> <td>'+vas.yarndenier+'</td> <td>'+vas.yarnspecification+'</td><td>'+vas.ssl_shade+'</td> <td>'+vas.shades+'</td><td>'+vas.lot+'</td> <td>'+vas.bale+'</td><td>'+vas.issue_gross_weight+'</td><td>'+vas.issue_net_weight+'</td><td>'+vas.consumed_at+'</td><td>'+vas.rec_date+'</td> </tr>';
        				count++;
						});
						
						
				 content +='<tr></tr>';
				 content +='<tr><th><b>TOTAL</b></th><th></th><th></th><th></th> <th></th> <th></th> <th></th><th></th> <th></th> <th><b>'+issue_gross_weight+'</b></th><th><b>'+issue_net_weight+'</b></th><th></th><th></th></tr>';
				 
                 $('.export_table').append(content);
                 
                 export_data();
				 pdf_download();
          			}
				 });
				
}
	function export_data()
	{
		//alert();
		
		$("#export_table").table2excel({
			exclude: ".noExl",
			name: "Excel Document Name",
			filename: "Yarn - Raw Stock Details",
			fileext: ".xls",
			exclude_img: true,
			exclude_links: true,
			exclude_inputs: true
		});	
		
	}
// function pdf_download()
	// {
		// alert();
		
      	  // var options = {
      	  // };
      	 
      	  // var pdf = new jsPDF('p', 'pt', 'a4');
      	  // pdf.addHTML($("#export_table"), 0, 0, options, function() {
      		// pdf.save('inspected_fabric.pdf');
      	  // });
        
      	// }  
		$("#export").on("click", function(){
				$("#list3").jqGrid("exportToHtml",{
					includeLabels : true,
					includeGroupHeader : true,
					includeFooter: true,
					autoPrint : true
				});
			});

$(function(){

$(".from_delivery_date_required_on").datepicker({

dateFormat: 'dd-mm-yy',

}).on('changeDate', function(ev){

$('.from_delivery_date_required_on').datepicker('hide');

});

});
$('.from_delivery_date_required_on').on('change', function(){
    var date = $(this).val();
    $('.to_delivery_date_required_on').datepicker({
            dateFormat: 'dd-mm-yy',
            minDate: date,
    });  
});

</script>
<script>
$("#osl_button").click(function(e) {
	
	var as =$('#osl_num').val();
	//alert(as);
	var yarn_type =$('#yarn_type').val();
	var preview_id =$('#preview_id').val();

$.ajax({
			type:'post',
			url:'<?php echo base_url("stock_history_details/outsource_osl_yarn_preview"); ?>',
			data:{'as':as},
			async:false,
			success:function()
			{
				
				window.location.href  = '<?php echo base_url('stock_history_details/outsource_osl_yarn_preview');?>/'+ '?id='+as+'/'+yarn_type+'/'+preview_id;
				}
			 
		});
});
	</script>

.well-sm {
    padding: 3px !important;
	border-radius: 0px !important;
}
input[type="file"] {
    padding-bottom: 28px !important;
    height: 25px !important;
    color:transparent;
}
.portlet.box.blue-madison {
    border: 1px solid #fff !important;
    border-top: 0;
    background:#fff !important;
}
#table_approved_indent
{
	display:none;
}
#refresh_list3
{
	display:none !important;
}
@media only screen and (min-width:320px) and (max-width:640px) {
}
</style> 
			
			
			
			<script>
function getDesignAndQuality(articleNo) {
	
    $.ajax({
        type: "post",
        url: "<?php echo base_url(); ?>marketing/getDesignAndQuality",
        data: "articleNo=" + articleNo,
        success: function (data) {
            var objData = jQuery.parseJSON(data);
           document.getElementById("design").value = objData.design;
            document.getElementById("quality").value = objData.quality;
        }
    });
}
</script>

<link href="<?php echo base_url('assets/css/sweetalert2.min.css');?>" rel="stylesheet"/>
<script src="<?php echo base_url('assets/js/sweetalert2.min.js');?>"></script>

label {
    font-weight: normal;
    text-align: left;
}
.hr-line{
	border-top: 1px solid #465A81;
}

input[type=file] {
    display: none;
}
.ui-jqgrid .ui-jqgrid-caption {
    text-align: left;
    background: rgb(72,91,127);
    color: white;
}
.ui-jqdialog .ui-jqdialog-titlebar {
    padding: .1em .1em;
    min-height: 35px;
     background: rgb(72,91,127);
    color: white;
}
.ui-jqdialog .ui-jqdialog-titlebar-close span {
    display: block;
    margin: -9px;
}
#sData
{
	 height: 27px;
}
#cData
{
	 height: 27px;
}
#dData
{
	 height: 27px;
}
#eData
{
	 height: 27px;
}
.coledit
{	cursor:pointer;
	
padding-right: 22px !important;
padding-left: 23px !important;
margin-top: 4px !important;
color:bold !important;
}
.ui-jqgrid .ui-jqgrid-btable tbody tr.jqgrow td {
    overflow: hidden;
    white-space: pre;
   
	
}
	</style>

<script>
 
	
	
  
		
 $(document).ready(function (){
	var l=$("#location").val();
	//  alert(l);
		jQuery("#list3").jqGrid({
		url:"<?php echo base_url('out_source/fetch_yarn_raw_data')?>",	 
			datatype: "json", 
		   colNames:['Id','Select','Purpose','Yarn Details','Yarn Denier','Yarn Specification','Lot','Bale','Gross Weight','Net Weight','PO#','Rate','Location','Received Date'],
				
			colModel:[
						{name:'id',index:'id',hidden:true, width:50,editable:true,width:100},
						{name:'',index:'',align: "center",editable:false,editrules:{required: true}, width:50,cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="fun_checkbox($(this))" ';
	                        		},formatter:function (cellvalue, options, rowObject) {    
    return "<input type='checkbox' id='check' class='check'   value='SELECT'  \>";
						  }},
					
						{name:'purpose',index:'purpose', width:120,editable:false},
						{name:'yarnname',index:'yarnname', editable:true,editrules:{required: true},width:120},
						{name:'yarndenier',index:'yarndenier', width:120,editable:true,editrules:{required: true}},
						
						
					//	{name:'yarnDenier',index:'yarnDenier', width:120,editable:true,editrules:{required: true}},
						{name:'yarnspecification',index:'yarnspecification', width:120,editable:true,editrules:{required: true}},
						{name:'lot',index:'lot', width:120,editable:true,editrules:{required: true}},
							{name:'bale',index:'bale', width:120,editable:true,editrules:{required: true}},
					//	{name:'issue_gross_weight',index:'issue_gross_weight', width:120,editable:true,editrules:{required: true}},
						
						 {	
	                    name: 'issue_gross_weight', index: 'issue_gross_weight', width: 100, align: 'center',formatter: 'number',
                      formatoptions: { decimalSeparator: ".", thousandsSeparator: " ", decimalPlaces: 2, defaultValue: '0.0000' },
	                       
	                         cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="gross_fun1($(this))" ';
	                        		}
						},
						
						 {	
	                    name: 'issue_net_weight', index: 'issue_net_weight', width: 100, align: 'center',formatter: 'number',
                      formatoptions: { decimalSeparator: ".", thousandsSeparator: " ", decimalPlaces: 2, defaultValue: '0.0000' },
	                       
	                         
	                         cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="net_fun1($(this))" ';
	                        		}
						},
							{name:'po_no',index:'po_no', width:120,editable:false},
						{name:'unit',index:'unit', width:120,editable:false},
						{name:'consumed_at',index:'consumed_at', width:100,editable:true,editrules:{required: true}},
						{name:'rec_date',index:'rec_date', width:100,editable:true,editrules:{required: true}},
						
						//{name:'issue_net_weight',index:'issue_net_weight', width:120,editable:true,editrules:{required: true}},
						
					],
						height: 'auto',
		  rowNum:50,
		      	rowTotal: 200000000000000000000000000,
		      	rowList : [50,100,200,300,500,1000,5000],
		      	rownumbers: true,
		      	rownumWidth: 40,
		      	pager:"#pager3", 
		      	sortname:'id', 
		      	viewrecords: true,
		      	gridview: true,
		      	autowidth: true,
		      	sortorder:"asc",
		       	loadonce:true,
				caption:"Yarn - Raw Stock Details",
	footerrow: true,
loadComplete: function () {
       var sumOfPrice_issue_net_weight = jQuery("#list3").jqGrid('getCol','issue_net_weight',false,'sum');  
 var sumOfPrice_issue_gross_weight = jQuery("#list3").jqGrid('getCol','issue_gross_weight',false,'sum');

jQuery("#list3").jqGrid('footerData', 'set', { bale: 'Total:', issue_gross_weight: sumOfPrice_issue_gross_weight.toFixed(2) , issue_net_weight: sumOfPrice_issue_net_weight.toFixed(2)  });

},
  });

//$("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required
	jQuery("#list3").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" });
	 	
	 		$("#list3").jqGrid('navGrid','#pager3',
				{edit:false,add:false,del:false,search:false,refreshstate:"current"},
				{ },
		        { },
		        { }, 
				{
			    	sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
			        closeOnEscape: true, 
			        	multipleSearch: true, 
			         	closeAfterSearch: true }
			);

}); 
		function gross_fun1(rowId)
	{
		 //var rowid = 123;
        var id = rowId.closest('tr').attr('id'); 
		//alert(id);
				  $.ajax({
	        //alert(email);
	        url:"<?php echo base_url('stock_history_details/yarn_stock_modal_val')?>",
	        type:"POST",
	        data:{'id':id},
		                 success:function(data){
				    
					 var objData = jQuery.parseJSON(data);
    	      
    	            var g_w = objData.f.issue_gross_weight;
					var access = objData.d.designation;
					
				if(access == 'Super Admin')
				{
					if(g_w < 1)
					{
											 
									
								swal({
								 title: 'Do You Want To Set This Value To Zero',
								//  input: 'text',
								  showCancelButton: true,
								  confirmButtonText: 'OK',
								  showLoaderOnConfirm: true,
								 }).then(function (email) {
									  $.ajax({
								//alert(email);
								url:"<?php echo base_url('stock_history_details/add_gross_zero_confirmation')?>",
								type:"POST",
								data:{'id':id},
											 success:function(data){
											$("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
												 }
										});  
								
								})
								
									///alert(email);
								   
							
					}
					else
					{
						
					}
				}
				else 
				{
					  swal({
					 title: "You Don't Have Access For This to Set Zero",
					 text: "",
					 });
				}	
				             }
		            });  
					
		
	}
	
	function net_fun1(rowId)
	{
		 //var rowid = 123;
        var id = rowId.closest('tr').attr('id'); 
		//alert(id);
				  $.ajax({
	        //alert(email);
	        url:"<?php echo base_url('stock_history_details/yarn_stock_modal_val')?>",
	        type:"POST",
	        data:{'id':id},
		                 success:function(data){
				    
					 var objData = jQuery.parseJSON(data);
    	      
			  
			   var n_w = objData.f.issue_net_weight;
					var access = objData.d.designation;
					
				if(access == 'Super Admin')
				{
					
    	           
					//var n_w = objData.issue_net_weight;
					
				
					
					if(n_w < 1)
					{
											
								
									
								swal({
								  title: 'Do You Want To Set This Value To 0',
								 // input: 'text',
								  showCancelButton: true,
								  confirmButtonText: 'OK',
								  showLoaderOnConfirm: true,
								 }).then(function (email) {
									  $.ajax({
								//alert(email);
								url:"<?php echo base_url('stock_history_details/add_net_zero_confirmation')?>",
								type:"POST",
								data:{'id':id},
											 success:function(data){
												$("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
												 }
										});  
								 
								})
								
									///alert(email);
								   
							
					}
					else
					{
						
					}
					}
				else 
				{
					  swal({
					 title: "You Don't Have Access For This to Set Zero",
					 text: "",
					 });
				}	
				             }
		            });  
					
		
	}

</script>
	
<style>
#refresh_list4,#refresh_list5
{
	display:none !important;
}
.preview
{
	padding-bottom:3px !important;
	padding-top:3px !important;
}
</style>

</script>
	<style>
	#jaytab{
	width:100%;
	overflow:auto;
}
}
	#search_list2
{
	display:none !important;
}
	#list2_122_t
	{
		height:0px !important;
	}

list2_136_t
{
	height:12px !important;
}
.scroll 
{
	height:12px !important;
}
.ui-jqgrid-btable
{
	
}
.ui-common-table
{
	height:12px !important;
}
#refresh_list2
{
	display:none !important;
}
#client_edit
{
	padding-right:12px !important;
}
#list2
{
	width: 1050px;
height: 0px !important;
}
#gbox_list2
{

height: auto !important;
}
#gview_list2
{

height: auto !important;
}

@media only screen and (min-width:320px) and (max-width:641px){
		.ui-jqgrid {
			margin-left: 1px !important;
		}
		.radio-list {
			margin-left:7% !important;
		}
		
#table_pending_indent{
	overflow-x: scroll;
}
			#jaytab{
				margin-top: 0 !important;
				margin-left: 0 !important;
				overflow-x: scroll;
				width: 600px !important;
				padding-left: 0 !important;
			}
			#jaytab1 {
				margin-top: 0 !important;
				margin-left: 0 !important;
				overflow-x: scroll;
				width: 300px !important;
				padding-left: 0 !important;
			}
			
			#editmodlist2
			{
				width:90% !important;
			}
			#sData span, #cData span {
				margin-left: 0 !important;
				}
		}
		@media only screen and (min-width:641px) and (max-width:991px){
			
			.ui-jqgrid {
			margin-left: 1px !important;
			}
			#jaytab{
				margin-top: 0 !important;
				margin-left: 0 !important;
				overflow-x: scroll;
				width: 100% !important;
				padding-left:0 !important;
				padding-right:9px !important;
			}

}
		
		
#sData span, #cData span 
{
    margin-left: 3px;
}
#sData {
    height: 29px;
}
#cData {
    height: 29px;
}

.jqgfirstrow
	{
		    height: 0px !important;
	}

</style>