EVOLUTION-NINJA

Edit File: debit_note.php

text-transform: uppercase !important;

}
.ui-jqgrid tr.jqgrow td{ 
text-transform: uppercase !important;
}
</style>
<?php  //include("menu.php"); ?>

<h3 class="page-title">
Customer Debit Note List
</h3>

<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="#" > </a></li>
		</ul>
	</div>
	






<form action="<?php echo base_url(); ?>debit_note/insert_dn" method="post" class="form-horizontal">
<b>To insert data click here:</b>
<input type="hidden" value="<?php echo $url_val; ?>" id="url_reference_val" name="url_reference_val" style="width: 230px;" >
<input type="submit" name="Insert" value="Insert New DN" />
</form>

<input type="hidden" id="pay_id" class="pay_id" value="<?php if(empty($access_row)){ } else { echo $access_row->pay_id; } ?>" >
<input type="hidden" id="hhh_id" >
<input type="hidden" id="debitpay_id" >
<input type="button" name="co" onclick="fun_preview3()" value="Preview " />
<input type="button" name="co" onclick="attachments()" value="View Attachments" />
<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="insert_id" class="insert_id" value="<?php if(empty($access_row)){ } else { echo $access_row->insert_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 echo $user_type_id; ?>" >
<input type="hidden" id="approval_id" class="approval_id" value="<?php if(empty($access_row)){ } else { echo $access_row->approval_id; } ?>" >

<div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalLabel">credit details</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <form class="payment_details">
      <div class="modal-body">
      	
        <table border="1" style="width:100%;border-spacing:0;margin-top: 1%;" cellpadding="5px">
				<thead>
					<tr>
						<th>Amount Received</th>
						<th><input type="text"  name="amount_received" onkeypress="if ( isNaN(this.value + String.fromCharCode(event.keyCode) )) return false;" class="amount_received  form-control"> </th></th>
					    <input type="hidden" id='ro_id' name="ro_id" class="ro_id  form-control">
					</tr>
				</thead>
				
		</table>
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
        <button type="submit" class="btn btn-primary submit">Save changes</button>
      </div>
  </form>
    </div>
  </div>
</div>

<input type="hidden" value="<?php echo $ref; ?>" id="ref_id" >
	      <input type="hidden" value="<?php echo $url_val; ?>" id="url_ref" style="width: 230px;" >
					
				<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>

<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'); ?>" />

.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 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>
	<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;
}
.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-bdiv {
overflow:hidden;
}

.col_delete
{
	padding-left:8px !important;
    padding-right:7px !important;
	 padding-bottom: 6px !important;
}
.col_pre
{
	   display: inline;
	padding-left: 32px !important;
    padding-right: 33px !important;
	margin-top:5px !important;
	 padding-bottom: 6px !important;
}
	</style>

url:"<?php echo base_url('debit_note/getdebit_details')?>/",	 
			 mtype : "post", 	 
			datatype: "json", 
		   	colNames:['Id','Select','Debit Note Ref','Customer ID','Currency', 'DN Value', 'Customer DN Ref','DN Date','Created By','Approved','Partly Credited','Fully Credited','Status','Edit','Delete'],
   	colModel:[
		
		{name:'id',index:'id',hidden:true, width:50,editable:true,width:100},
		{ name: 'select', width:20,align: 'center',cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="fun_radio_val($(this))" ';
	                        		},
                         formatter: function radio(cellValue, option) {
                             return '<input type="radio" name="radio_' + option.id +       '"  />';
                         } },
    	{name:'reference_id',index:'reference_id', width:50,editable:true,width:100},
    	{name:'customer_id',index:'customer_id', width:50,editable:true,width:100},
    	{name:'currency',index:'currency',editable:true, width:100},
        {name:'debit_value',index:'debit_value',editable:true,editrules:{required: true},editoptions: {size:10, maxlength: 10}, width:100},
    	{name:'customer_reference',index:'customer_reference',edittype:'text',editable:true,editrules:{required: true}, width:100},
    	{name:'debit_date',index:'debit_date',edittype:'text', width:100,editrules:{required: true},formatter: 'date', formatoptions: { newformat: 'd-m-Y'}},
        {name:'approved_by',index:'approved_by',edittype:'text',editable:true,editrules:{required: true}, width:100},
        {name:'approved_status', index: 'approved_status', width: 110, align: 'center',formatter: 'checkbox', editoptions: { value: '1:0' },formatoptions: { disabled: false},
             cellattr: function (rowId, tv, rawObject, cm, rdata) 
    				{
    				 
            	     return ' onclick="fun_tan($(this))" ';
            		}
    	},
    	{name:'partly_credited', index: 'partly_credited', width: 110, align: 'center',formatter: 'checkbox', editoptions: { value: '1:0' },formatoptions: { disabled:false},
             cellattr: function (rowId, tv, rawObject, cm, rdata) 
    				{
    				 
            	     return ' onclick="approve_payment_fun($(this))" ';
            		}
    	},
    	{name:'fully_credited', index: 'fully_credited', width: 110, align: 'center',formatter: 'checkbox', editoptions: { value: '1:0' },formatoptions: { disabled:false},
             cellattr: function (rowId, tv, rawObject, cm, rdata) 
    				{
    				 
            	     return ' onclick="fun_pay($(this))" ';
            		}
    	},
    	{name:'status',index:'status', width:50,editable:true,width:100},
    	{name:'edit',index:'edit',align: "center",editable:false,editrules:{required: true}, width:100,editable: true, formatter:vehicalFmatter,
    	        cellattr: function (rowId, tv, rawObject, cm, rdata) 
				{
            	     return ' onclick="fun_edit($(this))" ';
            		},formatter:function (cellvalue, options, rowObject) {    
					return "<input type='button'  id='edit_before_planned' value='EDIT'  \>";
				}
    	    
    	},
    	{name:'edit',index:'edit',align: "center",editable:false,editrules:{required: true}, width:100,editable: true, formatter:vehicalFmatter,
    	        cellattr: function (rowId, tv, rawObject, cm, rdata) 
				{
            	     return ' onclick="fun_delete($(this))" ';
            		},formatter:function (cellvalue, options, rowObject) {    
					return "<input type='button'  id='edit_before_planned' value='DELETE'  \>";
				}
    	    
    	}
   	],          
   			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:"desc",
		      	//multiple: true,  
		      	loadonce:true,
		      	autoencode:true,
		      	shrinkToFit: false,
				caption:"Transactions Order Details",
				footerrow: true,
// loadComplete: function () {
//       var sumOfTotalvalues = jQuery("#list2").jqGrid('getCol','totalValue',false,'sum');  
//         var sumOfindian = jQuery("#list2").jqGrid('getCol','indian',false,'sum');
//                 sumOfindian = '₹ '+ (sumOfindian.toFixed(2));

//       jQuery("#list2").jqGrid('footerData', 'set', { deliveryDate: 'Total:',  totalValue: sumOfTotalvalues.toFixed(2),indian:sumOfindian });

// },
				 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('debit_note/subgrid');?>/"+row_id+"/",
		
		//data:{'sub_id':123},
			  mtype : "get", 	 
			datatype: "json", 
			colNames: ['Id','Remarks','Amount Payed'],
			colModel: [
						{name:'id',index:'id',hidden:false,editable:true},
						{name:'remarks',index:'remarks'},
						{name:'amt_credited',index:'amt_credited'}
					
			],
			loadonce : true,
		  viewrecords: true,
			height: 'auto',
          rowNum:20000000,
          sortname: 'num',
          sortorder: "asc"
       });
   }
  });

$("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required
	
	 		$("#list2").jqGrid('navGrid','#pager2',
				{edit:false,add:false,del:false,search:false,refreshstate:"current"},
				{ },
		        { },
		        { }, 
				{
			    	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:,
						position: "last", 
						title:"", 
						cursor: "pointer",
						id:"client_delete"
					} 
				);

}); 
	function vehicalFmatter (cellvalue, options, rowObject)
{
   a
}
	function fun_radio_val(rowId)
{
	    var id = rowId.closest('tr').attr('id'); 
		var as=id;
		var m=$('#hhh_id').val(as);
		var n=$('#ref_id').val(as);
		
}

});
	
	function approve_payment_fun(rowId)
{
    var v=$('#edit_id').val();
// 	var v=$('#pay_id').val();
	if(v == 1)
	{
		var id = rowId.closest('tr').attr('id'); 
	
		var as=id;
		$.ajax({
    		type:'post',
    		url:'<?php echo base_url("debit_note/get_debitid"); ?>',
    		data:{'as':as},
    		async:false,
    		success: function (data)
		    {
				 var objdata = jQuery.parseJSON(data);
				 var fetch_res= objdata.approved_status;
				 var pay=objdata.partly_credited;
				 if(pay==1)
				 {
    				var id = rowId.closest('tr').attr('id'); 
    					//alert(id);
    				var confirmMsg= confirm("This Invoice Is Already Payed. Do You Want To Unpayed This!");
    				if (confirmMsg==true)
    				{
    				    	$.ajax({
								url:"<?php echo base_url('debit_note/no_confirmation')?>",
								type:"POST",
								data:{'id':id},
								success:function(data){
									$("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
								}
							});
						$("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
    				}
    				else if (confirmMsg==false)
					{
						    $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
					}
				 }
				 else
				 {
			        if(fetch_res == 1)	
			        {
				        var id = rowId.closest('tr').attr('id'); 
				        var as=id;
				        	var p=$('#ro_id').val(as);
						//alert(id);
						var confirmMsg= confirm("Do You Want To Confirm This Payment!");
						if (confirmMsg==true)
						{
        			         $('#exampleModal').modal('show');
						}	                    
						else if (confirmMsg==false)
						{
						     $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
						}
		
                	}	
                    else{
                        swal({
                            title: "Plese Approve The Order",
                            text: "",
                                        });  
                        $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
                    }
				}
		    }
		});
			
    }
    else
    {
        $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
    	    swal({
    			 title: "You Don't Have Acces To Approve This",
    			 text: "",
    		});
    		$("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');	
    }
		
}
		function fun_pay(rowId)
		{
		  var id = rowId.closest('tr').attr('id'); 
		  //	var as=$('#hhh_id').val();
		  var as=id;
		  //alert(as);
		 var v=$('#edit_id').val();
			if(v == 1)
			{
			
			$.ajax({
				type:'post',
				url:'<?php echo base_url("debit_note/add_debitpay"); ?>',
				data:{'as':as},
				async:false,
				success:function()
				{
            		 $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');	
				}
				 
			});
			}
	 else
	 {
		 swal({
			title: "You Don't Have Access For This ",
			text: "",
	 		});
	 }
	 
		}	
function attachments(){
    // var id = rowId.closest('tr').attr('id'); 
		  	var as=$('#hhh_id').val();
		  //var as=id;
		  //alert(as);
		 var v=$('#edit_id').val();
			if(v == 1)
			{
			
			$.ajax({
				type:'post',
				url:'<?php echo base_url("debit_note/view_image"); ?>',
				data:{'as':as},
				async:false,
				success:function()
				{
            		 var url_r=$('#url_ref').val();
				    
					if(url_r == '1')
					{
					//	window.location.href  = '<?php echo base_url('marketing/orderinput');?>/'+ '?id='+as;
						window.open('<?php echo base_url('debit_note/view_image');?>/'+as,'_blank');
					}
				}
				 
			});
			}
	 else
	 {
		 swal({
			title: "You Don't Have Access For This ",
			text: "",
	 		});
	 }
	 
}		
	
	
</script>

#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;
	}
	.preview
{
	padding-bottom:3px !important;
	padding-top:3px !important;
}
.preview
{
	padding-bottom:3px !important;
	padding-top:3px !important;
}
.tablediv
{
	width: auto !important;
   // overflow: scroll !important;
}
.ui-jqgrid .ui-jqgrid-btable tbody tr.jqgrow td {
    overflow: hidden;
    white-space: pre;
   
	
}
</style>