EVOLUTION-NINJA

Edit File: yarn_twisting_billing_grid.php

<?php   //include("menu.php"); 
error_reporting(E_ALL); ?>
<script>
function displaycustomer(str)
{
$.ajax({
  type:"post",
  url:"<?php echo base_url(); ?>display_data/testingcustomer",
  data:"id="+str,
  success:function(data) {
  document.getElementById("dynamicdatamster").innerHTML=data;
  }
  });
}
</script> 
<script>
    $(function () {
        $("#orderDate").datepicker({
            dateFormat: "d-m-yy",
            changeMonth: true,
            changeYear: true
        });
    });
  
</script>
<?php  //include("menu.php");
?>
 
 <div class="page-content-wrapper">
		<div class="page-content">
			
			
			<h3 class="page-title">
	Yarn - Twisting
			</h3>
			<?php  $this->load->view('templates/nav_menu'); ?>
			 <?php  $this->load->view('import_module/masters_data_display'); ?>
			<form action="<?php echo base_url(); ?>billing/yarn_twisting_details" method="post" class="form-horizontal">
<b>To insert data click here:</b>
<input type="submit" name="Insert" value="Insert" /><br><br>
</form>
		
						
					
					  <div id = "" class="jaytab" style="width: 1070px; margin-top:3%" class="col-sm-12">
				<div id = "jaytab" class="jaytab">
										<table id="list2"></table>
										<div id="pager2"></div>
										<div id="dialogSelectRow" title="Warning" style="display:none">
											<p>Please select row</p>
										</div>									
									</div>
									</div>	
					
			
			
			
			
	</div>
</div>
</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'); ?>" />

</script>
 
<script>
	$(document).ready(function() {
		$( "#customer" ).autocomplete({   
		source: '<?php echo base_url('request/auto_sea'); ?>',
		});
	});

</script>

</script>	
<script>
	function adddetails()
	{
		
		var customer=$("#customer").val();
		var date=$("#date").val();
		var product_type=$("#product_type").val();
		var description=$("#description").val();
		var size=$("#size").val();
       var min_quality=$("#min_quality").val();
       var customer_id=$("#customer_id").val();
       var currency= $("#currency").val();
       var article=$("#article").val();
       var design=$("#design").val();
       var price=$("#price").val();
       var image=$("#image").val();
       var reference= $("#reference").val();
       var terms=$("#terms").val();
       var quality= $("#quality").val();
       var color=$("#color").val();
       var composition=$("#composition").val();
       var note=$("#note").val();
       $.ajax({
	        
	        url:"<?php echo base_url('request/customer_insert')?>",
	        type:"POST",
	        data:{'customer':customer,'date':date,'product_type':product_type,'description':description,'size':size,'min_quality':min_quality,'customer_id':customer_id,'currency':currency,'article':article,'design':design,'price':price,'image':image,'reference':reference,'terms':terms,'quality':quality,'color':color,'composition':composition,'note':note},
		                 async:false,
		                 success:function(data){
		                   
		                   alert('Successfully Added.');
		                   	//$("#editmodlist2").remove();
		                    window.location.reload();
		                   	
		                }
		            });
	}

</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;
}

.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 !important;
}   
.ui-jqdialog .ui-jqdialog-titlebar-close span {
    display: block;
    margin: -9px !important;
}
#sData
{
	 height: 27px;
}
#cData
{
	 height: 27px;
}
#dData
{
	 height: 27px;
}
#eData
{
	 height: 27px;
}
			</style> 
			
			
			
			<script>
function getDesignAndQuality(articleNo) {
	
    $.ajax({
        type: "post",
        url: "<?php echo base_url(); ?>marketing/getDesignAndQuality",
        data: "articleNo=" + articleNo,
        success: function (data) {
           // alert();
            var objData = jQuery.parseJSON(data);
          // document.getElementById("design").value = objData.design;
            document.getElementById("quality").value = objData.arrArticleDet.quality;
            var comp="";
            $.each(objData.composition, function(key,val){
                comp +=val.yarnQuality +":" + ((val.sum)*100).toFixed(2) +"%  " ;
            });
            document.getElementById("composition").value = comp;
             }
    });
}
</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('jqgrid/css/ui.jqgrid.min.css'); ?>" />
		<link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('jqgrid/css/ui.jqgrid-bootstrap.min.css'); ?>" />
		<link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('jqgrid/css/ui.jqgrid-bootstrap-ui.min.css'); ?>" />
    
	
    <link rel="stylesheet" type="text/css" href="<?php  echo base_url();?>assets/css/bootstrap-datepicker.min.css"/>
	<script src="<?php  echo base_url();?>assets/js/bootstrap-datepicker.min.js"></script>
	<script>
		$('.datepicker').datepicker({
			//format: 'yyyy/mm/dd',
		   });

</script>
	<style type="text/css">
			
		.ss{
	padding-right: 0 !important;
	padding-left: 0 !important;
}

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

input[type=file] {
    display: none;
}
	</style>

<style>

</style> 

 
				    
	
	<script>
	var swan_id='';
$(document).ready(function (){
	//var swan_id='';
	jQuery("#list2").jqGrid({

url:"<?php echo base_url('request/customer_fetch')?>",	 
			 mtype : "post", 	 
			datatype: "json", 
		    colNames:['Id','Customer','Customer Id','Reference','Date','Product Type','Article','Quality','Price','Composition','Description','Preview'],
				
			colModel:[
					  {name:'id',index:'id',hidden:true, width:50,editable:true,width:100},
					  {name:'customer_name',index:'customer_name', width:50,editable:false,width:100},
					  {name:'customer_id',index:'customer_id',editable:true,hidden:true, width:100},
					  {name:'reference',index:'reference',edittype:'text',editable:true,editrules:{required: true}, width:100},
					  {name:'date',index:'date',editable:true,editrules:{required: true},editoptions: {size:10, maxlength: 10}, width:100},
					  {name:'product_type',index:'product_type',editable:true,editrules:{required: true}, width:100},
					  {name:'article',index:'article',editable:true,editrules:{required: true}, width:100},
					  {name:'quality',index:'quality',editable:true,editrules:{required: true}, width:140},
					  {name:'price',index:'price',edittype:'text',editable:true,editrules:{required: true}, width:100},
					  {name:'composition',index:'composition',editable:true,editrules:{required: true}, width:100},
					  {name:'description',index:'description',editable:true,editrules:{required: true}, width:100},
					  {name:'preview',index:'preview',editable:true,editrules:{required: true}, width:100,formatter:'showlink',formatoptions:{baseLinkUrl:'<?php echo base_url('request/preview')?>'}},
							  
		      	  	     	 
		      	    ],
		      	  height: 'auto',
		   rowNum:50,
		      	rowTotal: 200000000000000000000000000,
		      	rowList : [50,100,200,300,500,1000,5000],
		      	rownumbers: true,
		      	rownumWidth: 40,
		      	pager:"#pager2", 
		      	sortname:'id', 
		      	viewrecords: true,
		      	gridview: true,
		      	autowidth: true,
		      	sortorder:"asc",
		      	//multiple: true,  
		      	loadonce:true,
				caption:"Yarn - Twisting",
				 subGrid: true,
    subGridRowExpanded: function(subgrid_id, row_id) {
		
		
		
    // we pass two parameters
    // subgrid_id is a id of the div tag created within a table
    // the row_id is the id of the row
    // If we want to pass additional parameters to the url we can use
    // the method getRowData(row_id) - which returns associative array in type name-value
    // here we can easy construct the following
       var subgrid_table_id;
	  // alert(row_id);
	   swan_id=row_id;
	   //alert(swan_id);
       subgrid_table_id = subgrid_id+"_t";
       jQuery("#"+subgrid_id).html("<table id='"+subgrid_table_id+"' class='scroll'></table>");
	   
       jQuery("#"+subgrid_table_id).jqGrid({
		   
		  
        url:"<?php echo base_url('request/customer_fetch1')?>/s"+row_id+"/",	
		
		
			  mtype : "get", 	 
			datatype: "json", 
         colNames:['Id','Article','Quality','Description','Color','Design','Composition','weight','Size/Width','Price','hanger','cushion','view','Edit','Delete'],
				
         colModel:[
					  
					  {name:'id',index:'id',hidden:true, width:50,editable:true,width:100},
					  {name:'article',index:'article',editable:true,editrules:{required: true}, width:100},
					  {name:'quality',index:'quality',editable:true,editrules:{required: true}, width:80},
					   {name:'description',index:'description',editable:true,editrules:{required: true}, width:100},
					  {name:'color',index:'color',edittype:'text',editable:true,editrules:{required: true}, width:100},
					  {name:'design',index:'design',edittype:'text',editable:true,editrules:{required: true}, width:100},
					  {name:'composition',index:'composition',editable:true,editrules:{required: true}, width:60},
					  {name:'wight',hidden:true,index:'wight',editable:true,editrules:{required: true}, width:100},
					   {name:'size',index:'size',editable:true,editrules:{required: true}, width:60},
					    {name:'price',index:'price',editable:true,editrules:{required: true}, width:60},
					  {name:'hanger',index:'hanger',editable:true,editrules:{required: true}, width:90,formatter:'showlink',formatoptions:{baseLinkUrl:'<?php echo base_url('request/hangerpreview')?>'}},	
		      	  	  {name:'cusion',index:'cusion',editable:true,editrules:{required: true}, width:90,formatter:'showlink',formatoptions:{baseLinkUrl:'<?php echo base_url('request/cusionpreview')?>'}}, 
		      	  	   {name:'view',index:'view',editable:true,editrules:{required: true}, width:42,formatter:'showlink',formatoptions:{baseLinkUrl:'<?php echo base_url('request/view_all_data')?>'}},  
		      	  	   {name:'edit',index:'edit',editable:true,editrules:{required: true}, width:47,formatter:'showlink',formatoptions:{baseLinkUrl:'<?php echo base_url('request/edit_form')?>'}},
		      	  	 {name:'delete',index:'delete',editable:true,editrules:{required: true}, width:53,formatter:'showlink', formatoptions:{baseLinkUrl:'<?php echo base_url('request/delete_form')?>'}},  	 
		      	    ],
		      	  height: 'auto',
          rowNum:20000000,
          sortname: 'num',
          sortorder: "asc",
		//  search:true,
		    // cellEdit : true,
			// cellsubmit : 'remote',
			// cellurl: "<?php echo base_url('request/edit')?>/s"+row_id+"/"+cellname+"/",
			 
			// '<c:url value="/finalgrades/create/"/>' + row_id
		  
		  
		  
		  
       });
   }
  });

//$("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required
	jQuery("#list2").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" });
	 	
	 		$("#list2").jqGrid('navGrid','#pager2',
				{edit:false,add:false,del:false,search:false,refreshstate:false},
				{ },
		        { },
		        { }, 
				{
			    	sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
			        closeOnEscape: true, 
			        	multipleSearch: true, 
			         	closeAfterSearch: true }
			);
 			//$("#list2").navButtonAdd('#pager2',
			//		{ 	caption:"Edit", 
			//			buttonicon:"ui-icon-pencil", 
			//			onClickButton: editRow,
			//			position: "last", 
			//			title:"", 
			//			cursor: "pointer",
			//			id:"client_edit"
			//		} 
			//);
			$("#list2").navButtonAdd('#pager2',
					{ 	caption:"Delete", 
						buttonicon:"ui-icon-trash", 
						onClickButton: deleteRow,
						position: "last", 
						title:"", 
						cursor: "pointer",
						id:"client_delete"
					} 
				);

}); 
	function editRow() {
		// Get the currently selected row

else $( "#dialogSelectRow" ).dialog();
	}
function deleteRow() {
		
		// Get the currently selected row
	    var row = $("#list2").jqGrid('getGridParam','selrow');
	   
	   $("#id").val(row);
	   
	    // A pop-up dialog will appear to confirm the selected action
	    if( row != null ) 
			$("#list2").jqGrid( 'delGridRow', row,
	          	{ 
							modal:true,jqModal:true,
							recreateForm: true,
				             beforeSubmit:  function(postdata,formid){
				            	
								$.ajax({
					             
									 url:"<?php echo base_url('request/customer_delete')?>",
					             type:"POST",
					             data:{'id':row},
					             async:false,
					             success:function(data){
					                 if(data==""){
					                  //alert('Successfully Updated.'); 
					                    $("#delmodlist2").remove();
					                    window.location.reload();
					                    //$("#list2").trigger("reloadGrid");
					                 }
					                 else{
					                    // alert('Successful');
					                     $("#delmodlist2").remove();
					                     window.location.reload();
						                 $("#list2").trigger("reloadGrid"); 
					                 }
					             }
					         });
				            }, 
				           	reloadAfterSubmit:false,
	          				closeAfterDelete: true,
	          				afterSubmit : function(response, postdata) 
							{ 
				              
							}
	          	});
		 else $( "#dialogSelectRow" ).dialog();
	}

</script>
<script>
	var form = document.getElementById('formID'); // form has to have ID: <form id="formID">
	form.noValidate = true;
	form.addEventListener('submit', function(event) { // listen for form submitting
	        if (!event.target.checkValidity()) {
	            event.preventDefault(); // dismiss the default functionality
	            alert('Please, fill the form'); // error message
	        }
	    }, false);
	
	</script>
<script>
$(document).ready(function(){	
	   $('#min_quality').on('change keyup', function() {
		  var sanitized = $(this).val().replace(/[^0-9]/g, '');
		  $(this).val(sanitized);
		});
	});		
	$(document).ready(function(){	
				   $('#customer').on('change keyup', function() {
					  var sanitized = $(this).val().replace(/[^a-zA-Z -]+$/,'');
					  $(this).val(sanitized);
					});
				});	
</script> 	
	<style>
	#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:18px !important;
}

#list2
{
	width: 1050px;
height: 0px !important;
}

#gview_list2
{

height: auto !important;
}

@media only screen and (min-width:320px) and (max-width:641px){
			.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;
			}
			
			#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;
			}

}
</style>    
	
<script>
function remove()
{
	var customer=$("#customer").val('');
	var date=$("#date").val('');
	var product_type=$("#product_type").val('');
	var description=$("#description").val('');
	var size=$("#size").val('');
   var min_quality=$("#min_quality").val('');
   var customer_id=$("#customer_id").val('');
   var currency= $("#currency").val('');
   var article=$("#article").val('');
   var design=$("#design").val('');
   var price=$("#price").val('');
   var image=$("#image").val('');
   var reference= $("#reference").val('');
   var terms=$("#terms").val('');
   var quality= $("#quality").val('');
   var color=$("#color").val('');
   var composition=$("#composition").val('');
   var note=$("#note").val('');
}
</script>