EVOLUTION-NINJA

Edit File: reg_projects_view.php

<?php $this->load->view('includes/region_header');?>

<div class="row">
                    <div class="col-lg-12">
                       
                    </div>
                </div>

<section class="admin_heading">
					<div class="col-sm-12">
                		<h3>Projects</h3>
					</div>
					<div class="col-sm-12">
						<div id = "jaytab" style="width: 100%; margin-top:1%;">
							<p>Last Updated Date and Time is : <?php  if(empty($time)) {  echo "Data not found"; }else{ echo $time->createdate;  }  ?></p>
							<table id="list2"></table>
							<div id="pager2"></div>
						
							<div id="dialogSelectRow" title="Warning" style="display:none">
								<p>Please select row</p>
							</div>
						</div>
					</div>
				</section>
		 <?php
		        $ci =& get_instance();
		        $base_url = base_url();
		    ?>

</div>
            
        </div>
    </div>

<?php $this->load->view('includes/region_footer');?>
    <style>

@media only screen and (min-width:320px) and (max-width:641px){
.ui-jqgrid {
margin-left: 1px !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;
	}
	
	.text_color a{
	
	color:white !important;
	}
</style>  
<script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/jquery.jqGrid.js'); ?>"></script>
                      
     <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/i18n/grid.locale-en.js'); ?>"></script>
                    <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/jquery.jqGrid.min.js'); ?>"></script>
<script>
  $(document).ready(function (){
	//var l=$("#loc").val();
	  //alert(l);
		jQuery("#list2").jqGrid({
			url:"<?php echo site_url('controller/get_projects_view');?>",
			mtype : "post",
			datatype: "json", 
		  colNames:['Id','Customer','Description','Product','Application Segment','Segment','Attachments'],
			colModel:[
					{name:'id',index:'id', width:50, align:'center',key:true,editable:true,hidden:true},
		      	    {name:'customer',index:'customer', width:50, align:'center',key:true,editable:true},
					{name:'description', index:'description', align:'center',editable:true, width:50},
					{name:'product',index:'product', width:50, align:'center',key:true,editable:true},
					{name:'application', index:'application', align:'center',editable:true, width:50},
					{name:'segment', index:'segment', align:'center',editable:true, width:50},
					{name:'',index:'', search:false,
                         width:80, align:'center',editable:false,formatter: function (cellvalue, options, rowObject) {
                        var retVal = "";
                        var retVal = '<a data-toggle="tooltip" title="Download" class="" target="new_blank"   href="<?php echo base_url();?>'+rowObject.document+'"><button>Download</button></a> ';
                        return retVal;

}},
		      	    ],
			rowNum:50,
            rowTotal: 2000,
            rowList : [50,100,500,1000],
			rownumbers: true,
            rownumWidth: 40,
			pager:"#pager2", 
			sortname:'case_id', 
			viewrecords: true,
			loadonce:true,
			gridview: true,
			autowidth: true,
			sortorder:"asc", 
			caption:"Projects"
			}); 
	   $("#list2").jqGrid('filterToolbar',{searchOperators : false});//for multisearch code,remove if not required
	
		$("#list2").jqGrid('navGrid','#pager2',
					{edit:false,add:false,del:false,search:true,refreshstate:"current"},
					{ },
			        { },
			        { }, 
					{
				    	sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
				        closeOnEscape: true, 
				        	multipleSearch: true, 
				         	closeAfterSearch: true,
		 					multipleGroup:true,
							caption:"search"
		 }
			);
	  //$('#pager2').css("height", "auto");
// 	  $("#list2").navButtonAdd('#pager2',
// 					{ 	caption:"Add", 
// 						buttonicon:"ui-icon-plus", 
// 						onClickButton: addRow,
// 						position: "last", 
// 						title:"", 
// 						cursor:"pointer",
// 						id:"client_add"
// 					} 
// 			);	 
// 			$("#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 addRow() {
					// Get the currently selected row
				    $("#list2").jqGrid('editGridRow','new',
				    		{ 	
				    			modal:true,jqModal:true,
							    recreateForm: true,			    
							    beforeSubmit: function(postdata,formid){
							    	var case_id = $("#case_id").val();
							    	var partner_code = $("#partner_code").val();
							    	var industry = $("#industry").val();
							    	var application = $("#application").val();
							    	var product_type = $("#product_type").val();
							    	var document_name = $("#document_name").val();
							    	var document = $("#document").val();
							    	
							    	$.ajax({
							            
							            url:"<?php echo site_url('controller/case_stories_add');?>",
							            type:"POST",
							            data:{'case_id':case_id,'partner_code':partner_code,'industry':industry,'application':application,'product_type':product_type,'document_name':document_name,'document':document},
							                 async:false,
							                success:function(data){
							                   
							                   	alert('Successfully Added.');
								               
							                   	$("#editmodlist2").remove();
							                   	$("#list2").trigger("reloadGrid");
							                }
							            });
							      },
								closeAfterAdd: true,
								reloadAfterSubmit:false,
								closeOnEscape:true,
								clearAfterAdd: true,
								afterSubmit :false
								
				    		});
				}

function editRow() {
			// Get the currently selected row
			
			var row = $("#list2").jqGrid('getGridParam','selrow'); 
			if( row != null ) 
				$("#list2").jqGrid('editGridRow',row,
					{	 
						modal:true,jqModal:true,
				        recreateForm: true,		        
				        beforeSubmit: function(postdata,formid){
					        
				        	var case_id = $("#case_id").val();
					    	var partner_code = $("#partner_code").val();
					    	var industry = $("#industry").val();
					    	var application = $("#application").val();
					    	var product_type = $("#product_type").val();
					    	var document_name = $("#document_name").val();
					    	var document = $("#document").val();
					    	 $.ajax({
					             
					    		 url:"<?php echo site_url('controller/case_stories_edit');?>",
					             type:"POST",
					             data:{'case_id':case_id,'partner_code':partner_code,'industry':industry,'application':application,'product_type':product_type,'document_name':document_name,'document':document},
					             async:false,
					             success:function(data){
					                 if(data==""){

alert(' .'); 
				                  	
					                 }
					                 else{
					                	  alert('Successfully Updated.'); 
					                	    $("#editmodlist2").remove();
						                    //$("#list2").trigger("reloadGrid");
						                    jQuery('#list2').jqGrid('editRow',id,true,reload());
					                 }
					             }
					         });
					    },
						closeAfterEdit: true,
						reloadAfterSubmit:false,
						afterSubmit : false 
						
					});

else $( "#dialogSelectRow" ).dialog();
		}

else $( "#dialogSelectRow" ).dialog();
		}

</script>

<script src="<?php echo base_url('admin_assets/js/bootstrap.min.js');?>"></script>
    <script src="<?php echo base_url('admin_assets/js/plugins/morris/raphael.min.js');?>"></script>
    <script src="<?php echo base_url('admin_assets/js/plugins/morris/morris.min.js');?>"></script>
    <script src="<?php echo base_url('admin_assets/js/plugins/morris/morris-data.js');?>"></script>