EVOLUTION-NINJA

Edit File: swan_stock_details.php

text-transform: uppercase !important;

}
.ui-jqgrid tr.jqgrow td{ 
text-transform: uppercase !important;
}
.ui-jqgrid .ui-jqgrid-titlebar {
    height: 27px !important;
    background: #485b7f !important;
    color: white !important;
   
}
#client_delete_new
{
display:none;
}
#edit_list3
{
	display:none;
}
#search_list3
{
	display:none;
}
#refresh_list3
{
	display:none;
}
</style>
<script>
function back_func()
{
	window.location.href = "<?php echo base_url('reports/inspected_fabric'); ?>"
}

</script>
<div class="page-content-wrapper">
<div class="page-content">

<h3 class="page-title">
Swan - Yarn - Dyed 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="<?php echo base_url('reports/yarn_swan_stock_reports'); ?>" > Swan - Yarn - Dyed Stock Details </a></li>
		</ul>
	</div>

<div class="row date_row">
		<form action="<?php echo base_url('reports/swan_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" value="<?php echo $from_dates; ?>">
						</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" value="<?php echo $to_dates; ?>">
						</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 if($loc->consumed_at == $location) {echo "selected";}?> style="text-transform: uppercase !important"><?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;"/>	
			</div>
		</form>
	</div> 
<br/>

<input type="hidden" id="delete_id" class="delete_id" value="<?php if(empty($access_row)){ } else { echo $access_row->delete_id; } ?>" >	
<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 id = "jaytab3" style="margin-top:3%;margin-left: -28px;" class="col-sm-12 grid">
			<div class="grid_div"></div><table id="list3"></table>
			  <div id="pager3"></div>
		     <div id="dialogSelectRow3" 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>
	<div style="display:none;">
		<table  border="1" style="border-spacing: 0px !important;" id="print_table" class="print_table"></table>
		</div>			
		<script>
			function print_page1()
			{  
				
				var divToPrint=document.getElementById('print_table');
					newWin= window.open("");
					newWin.document.write('<html><head><title></title>');
					newWin.document.write('</head>');
					newWin.document.write(divToPrint.outerHTML);
					newWin.document.write('</html>');
					newWin.print();
					document.getElementById('print_table').style.display='';
					newWin.close();
					location.reload();
			}
			</script>

<script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/jquery.jqGrid.min.js'); ?>"></script>
	    
	    <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/i18n/grid.locale-en.min.js'); ?>"></script>
	    
	    <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.min.css'); ?>" />
	    
	    <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('jqgrid/css/ui.jqgrid.min.css'); ?>" />
						
		<script src="<?php echo base_url('assets/js/jquery-ui.min.js'); ?>" type="text/javascript"></script>
	
<script type="text/javascript">
$(document).ready(function (){
    var ll;
		var type = $('#type').val();
		
	jQuery("#list3").jqGrid({
		
	 url:"<?php echo base_url('reports/location_wise_swan_data')?>",	  
		 mtype : "post", 	 
		datatype: "json", 
	      colNames:['Id','OSL No.','Issue #','Work Order #','Yarn Quality','Yarn Type','Yarn Name','Yarn Denier','Yarn Specification','SSL Shade','Color Code','Dyed Weight','Location','Received Date'],
					colModel:[
						{name:'id',index:'id',hidden:true, width:50,editable:true,width:100},
						{name:'osl_no',index:'osl_no', width:85,editable:false},
						{name:'issue_no',index:'issue_no', width:120,editable:true,editrules:{required: true}},
						{name:'work_order_no',index:'work_order_no', width:120,editable:true,editrules:{required: true}},
						{name:'yarn_quality',index:'yarn_quality', width:120,editable:true,editrules:{required: true}},
						{name:'yarn_type',index:'yarn_type', width:100,editable:true,editrules:{required: true}},
						{name:'yarnName',index:'yarnName', width:155,editable:true,editrules:{required: true}},
						{name:'yarnSpecification',index:'yarnSpecification', width:120,editable:true,editrules:{required: true}},
						{name:'yarnDenier',index:'yarnDenier', width:200,editable:true,editrules:{required: true}},
						
							 
						{name:'shade',index:'shade', editable:true,editrules:{required: true},width:180},
						{name:'color_code',index:'color_code',classes:'edit',hidden:false, editable:true,editrules:{required: true},width:150},
						//{name:'rec_dyed_qua',index:'rec_dyed_qua', width:80,editable:true,editrules:{required: true}},
						{name: 'rec_dyed_qua', index: 'rec_dyed_qua', width: 100, align: 'center',formatter: 'number',
                      formatoptions: { decimalSeparator: ".", thousandsSeparator: " ", decimalPlaces: 2, defaultValue: '0.0000' },
	                       
	                         cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="dyed_weight_fun($(this))" ';
	                        		}
						},
						
						{name:'location',index:'location', width:120,editable:true,editrules:{required: true}},
						{name:'rec_date',index:'rec_date', width:100,editable:true,editrules:{required: true}},						
						
					],
				 height: 'auto',
	      	  rowNum:50,
		      	rowTotal: 2000,
		      	rowList : [10,20,30,50,100,500,1000],
		      	rownumbers: true,
		      	rownumWidth: 40,
		      	pager:"#pager3", 
		      	sortname:'owner_id', 
		      	viewrecords: true,
		      	gridview: true,
		      	autowidth: true,
		      	sortorder:"asc",
		      	shrinkToFit: false,
		      	
		      	 emptyrecords: 'No records to display',
		       //  multiselect: true,
		         // multiboxonly: true,
		      	loadonce:true,
				caption:"Swan - Yarn - Dyed Stock Details",
			footerrow: true,
 loadComplete: function () {
       var sumOfPrice_rec_weight = jQuery("#list3").jqGrid('getCol','rec_dyed_qua',false,'sum');  
 // var sumOfPrice_rec_mtrs = jQuery("#list3").jqGrid('getCol','issue_net_weight',false,'sum'); 
 // var sumOfPrice_insp_mtrs = jQuery("#list3").jqGrid('getCol','inspected_mtrs',false,'sum'); 
  // var sumOfPrice_rej_mtrs = jQuery("#list3").jqGrid('getCol','rejected_mtrs',false,'sum'); 
  //var sumOfPrice_var_mtrs = jQuery("#list3").jqGrid('getCol','variance_mtrs',false,'sum'); 
 
        jQuery("#list3").jqGrid('footerData', 'set', { color_code: 'Total:', rec_dyed_qua: sumOfPrice_rec_weight.toFixed(2) });

},
		});

$("#list3").jqGrid("setLabel", "rn", "SL");

$("#list3").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required

$("#list3").jqGrid('navGrid','#pager3',
			{edit:true,add:false,del:false,search:true,refreshstate:"current"},
			{ },
	        { },
	        { }, 
			{
		    	sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
		        closeOnEscape: true, 
		        	multipleSearch: true, 
		         	closeAfterSearch: true }
		).navButtonAdd('#pager3',
 				{ 	caption:"Print", 
					buttonicon:"ui-icon-print", 
 					onClickButton:print_page,
 					position: "last", 
					title:"", 
 					cursor: "pointer",
					id:"client_delete_new"
 				} 
		);	
 		$("#list3").navButtonAdd('#pager3',
				{ 	caption:"Export", 
					buttonicon:"", 
					onClickButton: export_page_list,
					position: "last", 
					title:"", 
					cursor: "pointer",
					id:"client_delete"
				} 
		);

});

function export_page() {
	
	id = jQuery("#list3").jqGrid('getDataIDs');
	var type= $('#type').val();
	
	$.ajax({
        type   : 'post',
      url:"<?php echo base_url('reports/location_wise_swan_data')?>",	
        data   : {id:id},
                                  
          success:function(data){
          response=jQuery.parseJSON(data);
		 		  
		  //alert(d);
          console.log(response);
         var count =1;
         
		 var received_qty=0;
		 rec_weight =0;
issue_net_weight=0;
rec_dyed_qua=0;
variance_mtrs=0;

$('.export_table').empty();
 
                var content = '';
                content +='<thead><tr><th><b>SL NO.</b></th><th><b>OSL No.</b></th><th><b>Issue #</b></th>  <th><b>Work Order#</b></th> <th><b>Yarn Quality</b></th> <th><b>Yarn Type</b></th> <th><b>Yarn Name</b></th><th><b>Yarn Denier</b></th> <th><b>Yarn Specification</b></th> <th><b>SSL Shade</b></th> <th><b>Color Code</b></th> <th><b>Dyed Weight</b></th><th><b>Location</b></th><th><b>Received Date</b></th></tr></thead>';
                   
				   
				 
					$.each(response,function(key,vas){
					
					rec_dyed_qua +=parseFloat(vas.rec_dyed_qua);
//issue_net_weight +=parseFloat(vas.issue_net_weight);

content +='<tr><td>'+count+'</td> <td>'+vas.osl_no+'</td> <td>'+vas.issue_no+'</td> <td>'+vas.work_order_no+'</td> <td>'+vas.yarn_quality+'</td> <td>'+vas.yarn_type+'</td><td>'+vas.yarnName+'</td><td>'+vas.yarnSpecification+'</td> <td>'+vas.yarnDenier+'</td><td>'+vas.shade+'</td><td>'+vas.color_code+'</td><td>'+vas.rec_dyed_qua+'</td><td>'+vas.location+'</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></th><th><b>'+rec_dyed_qua+'</b></th><th></th><th></th></tr>';
				 
                 $('.export_table').append(content);
                 
                  doit('xlsx');
               //  doit(type, fn, dl);
                // export_data();
				// pdf_download();
          			}
				 });
				
}

function export_page_list() {
	
	id = jQuery("#list3").jqGrid('getDataIDs');
	var type= $('#type').val();
	
	$.ajax({
        type   : 'post',
      url:"<?php echo base_url('reports/location_wise_swan_data')?>",	
        data   : {id:id},
                                  
          success:function(data){
          response=jQuery.parseJSON(data);
		 		  
		  //alert(d);
          console.log(response);
         var count =1;
         
		 var received_qty=0;
		 rec_weight =0;
issue_net_weight=0;
rec_dyed_qua=0;
variance_mtrs=0;

$('.export_table').empty();
 
                var content = '';
                content +='<thead><tr><th><b>SL NO.</b></th><th><b>OSL No.</b></th><th><b>Issue #</b></th> <th><b>Yarn Quality</b></th> <th><b>Yarn Type</b></th> <th><b>Yarn Name</b></th><th><b>Yarn Denier</b></th> <th><b>Yarn Specification</b></th> <th><b>SSL Shade</b></th> <th><b>Color Code</b></th> <th><b>Dyed Weight</b></th><th><b>Location</b></th><th><b>Received Date</b></th></tr></thead>';
                   
				   
				 
					$.each(response,function(key,vas){
					
					rec_dyed_qua +=parseFloat(vas.rec_dyed_qua);
//issue_net_weight +=parseFloat(vas.issue_net_weight);

content +='<tr><td>'+count+'</td> <td>'+vas.osl_no+'</td> <td>'+vas.issue_no+'</td> <td>'+vas.yarn_quality+'</td> <td>'+vas.yarn_type+'</td><td>'+vas.yarnName+'</td><td>'+vas.yarnSpecification+'</td> <td>'+vas.yarnDenier+'</td><td>'+vas.shade+'</td><td>'+vas.color_code+'</td><td>'+vas.rec_dyed_qua+'</td><td>'+vas.location+'</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></th><th><b>'+rec_dyed_qua+'</b></th><th></th><th></th></tr>';
				 
                 $('.export_table').append(content);
                 
                 export_data();
				 pdf_download();
          			}
				 });
				
}

function fun(rowId)
{
	var type= $('#type').val();
   var id = rowId.closest('tr').attr('id');

$.ajax({          
       type   : 'post',
       url    : "<?php echo site_url("edit-broker")?>?type="+type,
       data   : {broker_id:id},

success:function(response) {
       response=jQuery.parseJSON(response);
			console.log(response);

if(response.result == 1) 
           {
           	$(".broker_id_pk").val(response.broker_details.broker_id);
           	$(".name_or_id").val(response.broker_details.name_or_id);
           	$(".associate_name").val(response.broker_details.associate_name);
           	$(".address").val(response.broker_details.address);
           	$(".email").val(response.broker_details.email);
           	$(".mobile").val(response.broker_details.mobile);
        	$(".mobile2").val(response.broker_details.mobile2);
           	$(".reference_details").val(response.broker_details.reference_details);
           	$(".pan_number").val(response.broker_details.pan_number);
           	$(".adhar_number").val(response.broker_details.adhar_number);

var ext = response.broker_details.scan_copy.split('.').pop();
				if(ext == 'JPG' || ext == 'jpg' || ext == 'JPEG' || ext == 'jpeg' || ext == 'png' || ext == 'PNG')
				{
           		$(".scanned_image").html('<img src ="<?php echo base_url("broker_uploads");?>/'+response.broker_details.scan_copy+'" style="width:250px;height:350px"/>');
				}
				else if(ext == 'pdf')
				{
					$(".scanned_image").html('<embed src ="<?php echo base_url("broker_uploads");?>/'+response.broker_details.scan_copy+'" style="width:250px;height:350px"/>');
				}

var content = '';
				if(response.broker_details.type == "Executives")
                {
                	content += '<label class="radio-inline"><input type="radio" value="Executives" name="type" checked>Executives</label>';
                }
                else
                {
                	content +='<label class="radio-inline"><input type="radio" value="Executives" name="type">Executives</label>';
                }

if(response.broker_details.type == "Associate")
                {
                	content += '<label class="radio-inline"><input type="radio" value="Associate" name="type" checked>Associate</label>';
                }
                else
                {
                	content +='<label class="radio-inline"><input type="radio" value="Associate" name="type">Associate</label>';
                }

if(response.broker_details.type == "Logistic")
                {
                	content += '<label class="radio-inline"><input type="radio" value="Logistic" name="type" checked>Logistic</label>';
                }
                else
                {
                	content +='<label class="radio-inline"><input type="radio" value="Logistic" name="type">Logistic</label>';
                }
				if(response.broker_details.type == "Sub Associate")
                {
                	content += '<label class="radio-inline"><input type="radio" value="Sub Associate" name="type" checked>Sub Associate</label>';
                }
                else
                {
                	content +='<label class="radio-inline"><input type="radio" value="Sub Associate" name="type">Sub Associate</label>';
                }

$(".radio_button_class").html(content);
               
                $("#edit_modal").modal("show");
                $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
                }
            }
	            });  
}

function fun_delete(rowId)
{
	var type= $('#type').val();
	var id = rowId.closest('tr').attr('id'); 
  var broker_id=id;
  swal({

title: "Are you sure?",
      text: "You will not be able to recover this data!",
      type: "warning",   showCancelButton: true,
      confirmButtonColor: "#DD6B55",
      confirmButtonText: "Yes, delete it!",
      cancelButtonText: "No, cancel plz!",
      closeOnConfirm: false,
      closeOnCancel: false 
      },

function(isConfirm){

if (isConfirm) {

$(".sweet-alert").hide();
          $(".sweet-overlay").hide();
         // test.attr('disabled', 'disabled');
          //test.text("Deleting...");
              $.ajax({          
                      type   : 'post',
                      url    : "<?php echo site_url("delete-broker")?>?type="+type,
                      data   : {broker_id:broker_id},

success:function(response) {
                      response=jQuery.parseJSON(response);
							console.log(response);

if(response.result == 1) 
                          {
                             toastr["success"](response.message);
                             //BrokersList();
                             $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
                          }
                      }
                  });

} 
                      else {

$(".sweet-alert").hide();
                      $(".sweet-overlay").hide();
                  }

});

}

$('.update_form').submit(function(e){    
    e.preventDefault();
	 var type= $('#type').val();
     formdata = new FormData($(this)[0]);

// $(".submit").attr('disabled', 'disabled');
        // $(".submit").text("Updating...");

$.ajax({

type   : 'post',
            url    : "<?php echo site_url("update-broker")?>?type="+type,
            data   : formdata,
            contentType: false,
            processData: false,
                                      
              success:function(response){
              response=jQuery.parseJSON(response);
              console.log(response);

if(response.result==1)
                {
                	$("#edit_modal").modal("hide");
                	 $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
                    toastr["success"](response.message);
                    $('.update_form')[0].reset();
                    $(".submit").text("Submit");    
                    $(".submit").removeAttr('disabled');                
                }
                else if(response.result==2)
                {
                    toastr["error"](response.message);    
                    $(".submit").text("Submit"); 
                    $(".submit").removeAttr('disabled');                   
                }
                else 
                {
                    toastr["error"](response.message);                       
	                $(".submit").text("Submit"); 
	                $(".submit").removeAttr('disabled');                      
                }
               
            }
            
     });
         
 });

function SortedResult(brokers_list)
{
	tbody.empty();
	var table_row = [];
	
	var slno  = 1;
	var index = 1;

$.each(brokers_list,function(idx,vx){
    var row = [];
    var image = "";

row.push(slno);    
    
   	image='<img src ="<?php echo base_url("broker_uploads");?>/'+vx.scan_copy+'" style="width:80px;height:70px"/>';

row.push(vx.type);
        row.push(vx.name_or_id);
        row.push(vx.associate_name);
        row.push(vx.email);
        row.push(vx.mobile);
        row.push(vx.address);
        row.push(vx.pan_number);
        row.push(vx.reference_details);
        row.push(vx.adhar_number);
        
        var table_content = '';

table_content += '<div style="float:left;">';				               
        table_content += '<a data-toggle="tooltip" title="Edit" class="edit" broker_id="'+vx.broker_id+'" href="javascript:void(0);"><span class="glyphicon glyphicon-edit"></span></a> <a data-toggle="tooltip" title="Delete" class="delete" broker_id="'+vx.broker_id+'" href="javascript:void(0);"><span class="glyphicon glyphicon-trash"></span></a>';				
        table_content += '</div>'
        
        row.push(table_content);   
        table_row.push(row);
        slno++;
        index ++;
    
    });

datatable.clear();
    datatable.rows.add(table_row).draw();
    datatable.draw(); 
} 
</script>

$(document).ready(function(){

$("#sites_print").click(function(){
        var divToPrint=document.getElementById("print_sites_report");
		   newWin= window.open("");
		   newWin.document.write(divToPrint.outerHTML);
		   newWin.print();
		   newWin.close();	
		 });
		    
		   $("#sites_export").click(function(){
         $(".sites_table_print").table2excel({
					exclude: ".noExl",
					name: "Excel Document Name",
					filename: "Broker List",
					fileext: ".xls",
					exclude_img: true,
					exclude_links: true,
					exclude_inputs: true
				});						   
		    });		
		  
});

</script>
<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>
$(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>
<style type="text/css">

.content-wrapper, .right-side {			
		//min-height:900px !important;
	}	
	
	a {
	 color: inherit; 
	}
	.checkbox input[type=checkbox], .checkbox-inline input[type=checkbox], .radio input[type=radio], .radio-inline input[type=radio] {
    position: absolute;
    margin-top: 4px\9;
	margin-left: -47px;
}
input[type=checkbox], input[type=radio] {
    margin: -8px 0 0;
    margin-top: 1px\9;
    line-height: normal;
}

.radio-inline input[type=radio] {
    margin-left: -20px;
    width: 15px !important;
    margin-top: -5px;
}
#ui-datepicker-div {
		z-index: 1000 !important;
	}
.date_row {
	padding-bottom: 3%;
}	
</style>