EVOLUTION-NINJA

Edit File: case_stories_upload.php

<!DOCTYPE HTML>
<html lang="en-US">
<head>
	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<meta http-equiv="X-UA-Compatible" content="IE=Edge" />
	<title>Power Pik Case Stories</title>
	<link rel="stylesheet" type="text/css" href="<?php echo base_url('assets/css/main.css');?>" />
	<link rel="stylesheet" type="text/css" href="<?php echo base_url('assets/css/bootstrap.min.css');?>" />
	<link rel="stylesheet" type="text/css" href="<?php echo base_url('assets/css/font-awesome.min.css');?>" />
	
	<link href="https://fonts.googleapis.com/css?family=Roboto" rel="stylesheet">	
	
	<script type="text/javascript" src="<?php echo base_url('assets/js/jquery-3.6.0.min.js');?>"></script>
	<script type="text/javascript" src="<?php echo base_url('assets/js/bootstrap.min.js');?>"></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.js'); ?>"></script>
    
    <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.css'); ?>" />
    
    <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('jqgrid/css/ui.jqgrid.css'); ?>" />
					
	<script src="<?php echo base_url('assets/js/jquery-ui.js'); ?>" type="text/javascript"></script>
	
	<style type="text/css">
			
				.form-control:focus, input[type="Submit"]:focus, input[type="button"]:focus {
				  border-color: #FF0000;
				  box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075), 0 0 8px rgba(255, 0, 0, 0.6);
				}
			
				#editmodlist2
				{
					//height: 232px !important;
					width: 326px !important;
				}
				#FrmGrid_list2
				{
					width: 100% !important;
				}
				.ui-jqdialog .ui-jqdialog-titlebar
				{
					height: 29px !important;
					background-color:#2A4474 !important;
					color: white;
					padding-left: 10px;
				}
				.fm-button
				{
					height: 21px !important;
					padding: 1px;					
					margin-right: 10px !important;
					height: 21px !important;				    
				    width: 43%;
				    margin-top: -7px !important;
				}
				.ui-jqdialog-content td.navButton {
					padding-top: 12px !important;
				}
				.ui-jqgrid .ui-jqgrid-titlebar
				{
					height: 27px !important;
					background-color: #2A4474!important;
					color:white !important;
				}
				.ui-jqgrid-bdiv
				{
					height: 232px !important;
				}
				.ui-widget-overlay
				{
					z-index:0 !important;
				}
				
					
			</style>
</head>
<body>	
	<div class="top-bg"></div>
	<header class="cf">	
		<div class="container">
			<div class="logo">
				<a href="" class="hidden-xs hidden-sm"><img src="<?php echo base_url('assets/img/POWERPIK.svg');?>" class="img-responsive center-block"></a>
				<a href="" class="hidden-md hidden-lg"><img src="<?php echo base_url('assets/img/POWERPIK.svg');?>" class="img-responsive center-block"></a>
			</div>
			<div class="navigation">
				<nav>
					<a href="javascript:void(0)" class="smobitrigger ion-navicon-round"><span>Menu</span></a>
					<ul class="mobimenu">
					<?php if($details->role == 2)
					{
					if($details->department == 4)
					{?>
					<li class="dropdown">
							<a href="" class="dropdown-toggle" data-toggle="dropdown">Information
								<span class="glyphicon glyphicon-chevron-down"></span>
							</a>
							<ul class="dropdown-menu  multi-column-dropdown">
								<li><a href="<?php echo site_url('controller/inventory_import');?>">Stock Updates</a></li>
								<li><a href="<?php echo site_url('controller/po_import');?>">PO Acknowledgemets</a></li>								
							</ul>
						</li>
						
					<?php }elseif($details->department == 5) {?>
					<li class="dropdown">
							<a href="" class="dropdown-toggle" data-toggle="dropdown">Financials
								<span class="glyphicon glyphicon-chevron-down"></span>
							</a>
							<ul class="dropdown-menu  multi-column-dropdown">
								<li><a href="<?php echo site_url('controller/outstanding_statement');?>">Outstanding Statement</a></li>
								<li><a href="<?php echo site_url('controller/overdue_statement');?>">Overdue Statement</a></li>
								<li><a href="<?php echo site_url('controller/c_forms');?>">C forms</a></li>
							</ul>
						</li>	
						
					<?php }elseif($details->department == 6) {?>
					<li class="dropdown">
							<a href="" class="dropdown-toggle" data-toggle="dropdown">Technical Support
								<span class="glyphicon glyphicon-chevron-down"></span>
							</a>
							<ul class="dropdown-menu  multi-column-dropdown">
								<li><a href="<?php echo site_url('controller/drive_mannual_upload');?>">Drive Catalogues</a></li>
								<li><a href="<?php echo site_url('controller/case_stories_upload');?>">Case Stories</a></li>	
						<li><a href="<?php echo site_url('controller/application_letter_upload');?>">Appreciation Letters</a></li>
						<li><a href="<?php echo site_url('controller/application_notes_upload');?>">Application Notes</a></li>
						<li><a href="<?php echo site_url('controller/technical_notes_upload');?>">Technical Notes</a></li>
						<li><a href="<?php echo site_url('controller/training_presentations_upload');?>">Training Presentations</a></li>
						<li><a href="<?php echo site_url('controller/softwares_upload');?>">Softwares</a></li>
						
						
							</ul>
						</li>	
						
					<?php }elseif($details->department == 7) {?>
					
					<?php } } elseif ($details->role == 3) {?>
						<li class="dropdown">
							<a href="" class="dropdown-toggle" data-toggle="dropdown">Information
								<span class="glyphicon glyphicon-chevron-down"></span>
							</a>
							<ul class="dropdown-menu  multi-column-dropdown">
								<li><a href="<?php echo site_url('controller/stock_updates');?>">Stock Updates</a></li>
								<li><a href="<?php echo site_url('controller/po_acknowledgemets');?>">PO Acknowledgemets</a></li>								
							</ul>
						</li>						
						<li class="dropdown">
							<a href="" class="dropdown-toggle" data-toggle="dropdown">Financials
								<span class="glyphicon glyphicon-chevron-down"></span>
							</a>
							<ul class="dropdown-menu  multi-column-dropdown">
								<li><a href="<?php echo site_url('controller/outstanding_statements_display');?>">Outstanding Statement</a></li>
								<li><a href="<?php echo site_url('controller/overdue_statements_display');?>">Overdue Statement</a></li>
								<li><a href="<?php echo site_url('controller/c_forms_display');?>">C forms</a></li>
							</ul>
						</li>						
						<li class="dropdown">
							<a href="" class="dropdown-toggle" data-toggle="dropdown">Technical Support
								<span class="glyphicon glyphicon-chevron-down"></span>
							</a>
							<ul class="dropdown-menu  multi-column-dropdown">
								<li><a href="<?php echo site_url('controller/drive_catalogues');?>">Drive Catalogues</a></li>
								<li><a href="<?php echo site_url('controller/case_stories');?>">Case Stories</a></li>								
							</ul>
						</li>
						
						<?php }?>
									
						  
						<li><a href="<?php echo site_url('controller/profile');?>">Profile</a></li>
						<li><a href="<?php echo site_url('controller/logout');?>">Logout</a></li>
					</ul>
				</nav>
			</div>
		</div>
	</header>

<div class="middle_work_hedding">
		<div class="container">
			<h3><em>Case Stories</em></h3>		
		</div>
	</div>
	
	
	
	<div class="mid-inventory-improt">
		<div class="container">
			<form method="post" action="<?php echo site_url('controller/case_stories_import');?>" enctype="multipart/form-data" onsubmit="return validateForm()">
		
			<div style="width: 400px; margin:0 auto;">	
				<div class="form-group" style="padding-top:20px">
					
					<div class="form-group">
					    <label>Industry :</label>
					    <input type="text" class="form-control" id="pwd" name="industry">
					</div>
					<div class="form-group">
					    <label>Application :</label>
					    <input type="text" class="form-control" id="pwd" name="application">
					</div>
					<div class="form-group">
					    <label>Product Type  :</label>
					    <input type="text" class="form-control" id="pwd" name="product_type">
					</div>
					<div class="form-group">
					    <label>Document Name :</label>
					    <input type="text" class="form-control" id="pwd" name="document_name">
					</div>
				</div>				
				<div class="col-sm-3"></div>
				<div class="file-uploader">
			  <div class="file-uploader__message-area">
				<p>Import CSV/Excel File</p>
			  </div>
			  <div class="file-chooser">
				<input class="file" type="file" name="document">
			  </div>
			  <input class="file-uploader__submit-button" type="submit" value="Upload">
			  </div>
			</form>
			 
  <div class="modal fade" id="edit_modal" role="dialog">
    <div class="modal-dialog modal-lg">
      <div class="modal-content">
        <div class="modal-header">
          <button type="button" class="close" data-dismiss="modal">&times;</button>
          <h4 class="modal-title">Update Case Stories</h4>
        </div>

<div class="modal-body">
			<form method="post" class="update" action="<?php echo base_url('controller/case_stories_edit');?>" enctype="multipart/form-data" onsubmit="return updatevalidateForm()">
		
					  <input type="hidden" class="form-control" id="update_id" name="update_id" required>
						<div style="width: 400px; margin:0 auto;">	
				<div class="form-group" style="padding-top:20px">
					
					<div class="form-group">
					    <label>Industry :</label>
					    <input type="text" class="form-control" id="update_industry" name="update_industry">
					</div>
					<div class="form-group">
					    <label>Application :</label>
					    <input type="text" class="form-control" id="update_application" name="update_application">
					</div>
					<div class="form-group">
					    <label>Product Type  :</label>
					    <input type="text" class="form-control" id="update_product_type" name="update_product_type">
					</div>
					<div class="form-group">
					    <label>Document Name :</label>
					    <input type="text" class="form-control" id="update_document_name" name="update_document_name">
					</div>
				</div>				
				<div class="col-sm-3"></div>
				<div class="file-uploader">
			  <div class="file-uploader__message-area">
				<p>Import CSV/Excel File</p>
			  </div>
			  <div class="file-chooser">
				<input class="file" type="file" name="update_document">
			  </div>
			  <input class="file-uploader__submit-button" type="submit" value="Upload">
			  </div>
				
			</form>
			</div>

</div>
    </div>
  </div>
</div>			
		</div>
	</div>
	
		
	
	
	
	<div id = "jaytab" style="width: 100%; margin-top:3%;">
	    <div class="container-fluid">
    	    <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>
				<div class="row" style="padding-bottom:20px;"></div>	
	
		
	<div class="height-50"></div>
<footer class=" navbar-fixed-bottom">
		<div class="top-bg">		
		<div class="container">			
			<ul class="top_marqu">
				<li><strong>Copyright &copy; 2019 Yaskawa</strong> All rights
			reserved.</li>
					<li></li>
					<li></li>
				<li></li>
				<li><b>Version</b> 2.3.6</li>
			</ul>	
		</div>
	</div>
	</footer>
</body>
</html>

//     }},
                {name:'document', index:'document', align:'center',editable:true, width:150,hidden:true, sortable: false},
                
		      	   {name:' ',index:' ', search:false,editable:false,align: "center",editrules:{required: true}, width:100, sortable: false,cellattr: function (rowId, tv, rawObject, cm, rdata) 
						{
                	     return ' onclick="fun('+rdata.case_id+')" ';
                		},formatter:function (cellvalue, options, rowObject) {    
						return "<input type='button' value='EDIT' onclick='some_function' data-toggle='modal' data-target='#edit_modal' \>";
			}},	
		      //{name:'document',index:'document', width:200,hidden:true, sortable: false,editoptions:{size:25}},	   
		      	    ],
			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:"desc", 
			caption:"Case Stories"
			}); 
	  //  $("#list2").jqGrid('filterToolbar',{searchOperators : true});//for multisearch code,remove if not required
	
		// $("#list2").jqGrid('navGrid','#pager2',
		// 			{edit:false,add:false,del:false,search:false,refresh:false},
		// 			{ },
		// 	        { },
		// 	        { }, 
		// 			{
		// 		    	sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
		// 		        closeOnEscape: true, 
		// 		        	multipleSearch: true, 
		// 		         	closeAfterSearch: true,
		//  					multipleGroup:true,
		// 					caption:"search"
		//  }
		// 	);
		 $("#list2").jqGrid("setLabel", "rn", "SL");
            $("#list2").jqGrid('filterToolbar',{stringResult: true,searchOperators : true}); //for multisearch code,remove if not required

$("#list2").jqGrid('navGrid','#pager2',
                {edit:false,add:false,del:false,search:true,refresh:true},
                { },
                { },
                { }, 
                {
                sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
                closeOnEscape: true, 
                multipleSearch: true, 
                closeAfterSearch: true }
            );
		  
		
		$("#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
	
	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 createdate = $("#createdate").val();
		    	var document = $("#document").val();
		    	 $.ajax({
		             
		    		 url:"<?php echo site_url('controller/case_stories_edit');?>",
		             type:"POST",
		             data:{'case_id':case_id,'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();
		                	    window.location.reload();
			                    //$("#list2").trigger("reloadGrid");
			                    jQuery('#list2').jqGrid('editRow',id,true,reload());
		                 }
		             }
		         });
		    },
			closeAfterEdit: true,
			reloadAfterSubmit:false,
			afterSubmit : false 
			
		});
	
	else $( "#dialogSelectRow" ).dialog();
	}*/
	
	function fun(rowId)
{
   var id =rowId; //rowId.closest('tr').attr('case_id');
   //alert(id);

$.ajax({
        
        url:"<?php echo site_url('controller/case_stories_fetch')?>",
        type:"POST",
        data:{id:id},
        success:function(response) {
            response=jQuery.parseJSON(response);
					console.log(response);

if(response!= "") 
                {
                    	
                    	$("#update_id").val(response.case_id);
			        	$("#update_industry").val(response.industry);
				    	$("#update_application").val(response.application);
				        $("#update_product_type").val(response.product_type);
				    	$("#update_document_name").val(response.document_no);
				        $("#update_document").val(response.document);
                
                    $("#edit_modal").modal("show");
                    $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
                }
            }

});  
}
	function deleteRow() {
	
var row = $("#list2").jqGrid('getGridParam','selrow'); 
  
       var rowData = $("#list2").getRowData(row);
		 var a =rowData.case_id;
		 
		if( row != null ) 
			$("#list2").jqGrid('delGridRow',row,
		{	 
				modal:true,jqModal:true,
			        recreateForm: true,		        
			        beforeSubmit: function(postdata,formid){
			        
		    	 $.ajax({
		             url:"<?php echo site_url('controller/case_stories_delete');?>",
		             type:"POST",
		             data:{'id':a},
				          async:false,
							             success:function(data){
							                 if(data==""){
							                  alert('Successfully Deleted.'); 
							                   $("#delmodlist2").remove();
							                	 window.location.reload();
						                  	
							                 }
							                 else{
							                	 alert('Successfully Deleted.'); 
							                	 $("#delmodlist2").remove();
							                	 window.location.reload();
							                     
							                 }
							             }
							         });
							    },
								closeAfterEdit: true,
								reloadAfterSubmit:false,
								afterSubmit : false 
								
							});

else $( "#dialogSelectRow" ).dialog();
				}
	
	
</script>
		
	<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<link rel="stylesheet" type="text/css" href="http://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">
	<link rel="stylesheet" type="text/css" href="<?php echo base_url('assets/css/simpleMobileMenu.css');?>" />
	<script src="<?php echo base_url('assets/js/simpleMobileMenu.js');?>"></script>
	<script type="text/javascript">
		jQuery(document).ready(function($) {
			$('.smobitrigger').smplmnu();
		});
	</script>
	
		
	<script type="text/javascript">
		jQuery(document).ready(function($) {
			$('.mobimenu li.dropdown').hover(function() {
			  $(this).find('.dropdown-menu').stop(true, true).delay(200).fadeIn(500);
			}, function() {
			  $(this).find('.dropdown-menu').stop(true, true).delay(200).fadeOut(500);
			});			
		});
	</script>
	

<script>
(function( $ ) {
   
   $.fn.uploader = function( options ) {
     var settings = $.extend({
       MessageAreaText: "No files selected.",
       MessageAreaTextWithFiles: "File List:",
       DefaultErrorMessage: "Unable to open this file.",
       BadTypeErrorMessage: "We cannot accept this file type at this time.",
       acceptedFileTypes: ['csv', 'rtf', 'xls', 'xlsx']
     }, options );
  
     var uploadId = 1;
     //update the messaging 
      $('.file-uploader__message-area p').text(options.MessageAreaText || settings.MessageAreaText);
     
     //create and add the file list and the hidden input list
     var fileList = $('<ul class="file-list"></ul>');
     var hiddenInputs = $('<div class="hidden-inputs hidden"></div>');
     $('.file-uploader__message-area').after(fileList);
     $('.file-list').after(hiddenInputs);
     
    //when choosing a file, add the name to the list and copy the file input into the hidden inputs
     $('.file-chooser__input').on('change', function(){
        var file = $('.file-chooser__input').val();
        var fileName = (file.match(/([^\\\/]+)$/)[0]);

//clear any error condition
       $('.file-chooser').removeClass('error');
       $('.error-message').remove();
       
       //validate the file
       var check = checkFile(fileName);
       if(check === "valid") {
         
         // move the 'real' one to hidden list 
         $('.hidden-inputs').append($('.file-chooser__input')); 
       
         //insert a clone after the hiddens (copy the event handlers too)
         $('.file-chooser').append($('.file-chooser__input').clone({ withDataAndEvents: true})); 
       
         //add the name and a remove button to the file-list
         $('.file-list').append('<li style="display: none;"><span class="file-list__name">' + fileName + '</span><button class="removal-button" data-uploadid="'+ uploadId +'"></button></li>');
         $('.file-list').find("li:last").show(800);
        
         //removal button handler
         $('.removal-button').on('click', function(e){
           e.preventDefault();
         
           //remove the corresponding hidden input
           $('.hidden-inputs input[data-uploadid="'+ $(this).data('uploadid') +'"]').remove(); 
         
           //remove the name from file-list that corresponds to the button clicked
           $(this).parent().hide("puff").delay(10).queue(function(){$(this).remove();});
           
           //if the list is now empty, change the text back 
           if($('.file-list li').length === 0) {
             $('.file-uploader__message-area').text(options.MessageAreaText || settings.MessageAreaText);
           }
         });
       
         //so the event handler works on the new "real" one
         $('.hidden-inputs .file-chooser__input').removeClass('file-chooser__input').attr('data-uploadId', uploadId); 
       
         //update the message area
         $('.file-uploader__message-area').text(options.MessageAreaTextWithFiles || settings.MessageAreaTextWithFiles);
         
         uploadId++;
         
       } else {
         //indicate that the file is not ok
         $('.file-chooser').addClass("error");
         var errorText = options.DefaultErrorMessage || settings.DefaultErrorMessage;
         
         if(check === "badFileName") {
           errorText = options.BadTypeErrorMessage || settings.BadTypeErrorMessage;
         }
         
         $('.file-chooser__input').after('<p class="error-message">'+ errorText +'</p>');
       }
     });
     
     var checkFile = function(fileName) {
       var accepted          = "invalid",
           acceptedFileTypes = this.acceptedFileTypes || settings.acceptedFileTypes,
           regex;

for ( var i = 0; i < acceptedFileTypes.length; i++ ) {
         regex = new RegExp("\\." + acceptedFileTypes[i] + "$", "i");

if ( regex.test(fileName) ) {
           accepted = "valid";
           break;
         } else {
           accepted = "badFileName";
         }
       }

return accepted;
    };
  }; 
}( jQuery ));

//init 
$(document).ready(function(){
  $('.fileUploader').uploader({
    MessageAreaText: "No files selected. Please select a file."
  });
});
</script>

if (!alphaNumericPattern.test(pwd)) {
            alert("Invalid input detected.");
            return false;
        }
        return true;
    }
</script>

if (!alphaNumericPattern.test(update_industry)) {
            alert("Invalid input detected.");
            return false;
        }
        if (!alphaNumericPattern.test(update_application)) {
            alert("Invalid input detected.");
            return false;
        }
        if (!alphaNumericPattern.test(update_product_type)) {
            alert("Invalid input detected.");
            return false;
        }  if (!alphaNumericPattern.test(update_document_name)) {
            alert("Invalid input detected.");
            return false;
        } 
        return true;
    }
</script>