EVOLUTION-NINJA

Edit File: projects_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 Projects</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>
						<li><a href="<?php echo site_url('controller/projects_upload');?>">Projects</a></li>
						<li><a href="<?php echo site_url('controller/others_upload');?>">Others</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>Projects</em></h3>		
		</div>
	</div>
	
	
	
	<div class="mid-inventory-improt">
		<div class="container">
			<form method="post" action="<?php echo site_url('controller/projects_import');?>" enctype="multipart/form-data" onsubmit="return validateForm()">
			
			<div style="width: 400px; margin:0 auto;">	
				<div class="form-group" style="padding-top:20px">
					  <label>Customer :</label>
					    <input type="text" class="form-control" id="email" name="customer">
					 </div>				
					 <div class="form-group">
					    <label>Description :</label>
					    <input type="text" class="form-control" id="email" name="description">
					 </div>
					<div class="form-group">
					    <label>Product :</label>
					    <input type="text" class="form-control" id="pwd" name="product">
					</div>
					<div class="form-group">
					    <label>Application /Segment:</label>
					    <input type="text" class="form-control" id="pwd" name="application">
					</div>
					<div class="form-group">
					    <label>Segment  :</label>
					    <input type="text" class="form-control" id="pwd" name="segment">
					</div>

<div class="form-group">
					<label>Drawing Upload</label>
					<div class="file-uploader">
						<div class="file-uploader__message-area">
						<p>Import CSV/Excel File (Drawing)</p>
						</div>
						<div class="file-chooser">
						<input class="file" type="file" name="document">
						</div>
					
					</div>
				</div>

<div class="form-group">
					<label>Report Upload</label>
					<div class="file-uploader">
						<div class="file-uploader__message-area">
						<p>Import CSV/Excel File (Report)</p>
						</div>
						<div class="file-chooser">
						<input class="file" type="file" name="report"> 
						</div>
						
					</div>

</div>

</div>			
				<div class="col-sm-3"></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 Projects</h4>
        </div>

<div class="modal-body">
				<form method="post" action="<?php echo site_url('controller/projects_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">
					  <label>Customer :</label>
					    <input type="text" class="form-control" id="update_customer" name="update_customer">
					 </div>				
					 <div class="form-group">
					    <label>Description :</label>
					    <input type="text" class="form-control" id="update_description" name="update_description">
					 </div>
					<div class="form-group">
					    <label>Product :</label>
					    <input type="text" class="form-control" id="update_product" name="update_product">
					</div>
					<div class="form-group">
					    <label>Application /Segment:</label>
					    <input type="text" class="form-control" id="update_application" name="update_application">
					</div>
					<div class="form-group">
					    <label>Segment  :</label>
					    <input type="text" class="form-control" id="update_segment" name="update_segment">
					</div>

<div class="form-group">
					<label>Drawing Upload</label>
						<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>
					</div>
				</div>

<div class="form-group">
					<label>Report Upload</label>
					<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_report">
						</div>
					</div>
				</div>

</div>				
				<div class="col-sm-3"></div>
			</form>
			</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:'report',hidden: true,index:'report', width:200,editable:true,editoptions:{size:25}, sortable: false},

{name:'',index:'', search:false,
                         width:100, align:'center',editable:false, sortable: false,formatter: function (cellvalue, options, rowObject) {
											var retVal = "";
											if(rowObject.report != ''){
													var path='<?php echo base_url();?>\''+rowObject.report+'\'';
													var finalpath=path.replace(/\'/g, '');
													var retVal = '<a data-toggle="tooltip" title="Download" class="" target="new_blank"   href="'+finalpath+'"><button>Download</button></a> ';
													return retVal;
											}
											else{
													var retVal = 'Not Uploaded';
													return retVal;
											}

}},

{name:' ',index:' ',editable:false, search:false,align: "center",editrules:{required: true}, width:100, sortable: false,cellattr: function (rowId, tv, rawObject, cm, rdata) 
						{
                	     return ' onclick="fun($(this))" ';
                		},formatter:function (cellvalue, options, rowObject) {    
						return "<input type='button' value='EDIT' onclick='some_function' data-toggle='modal' data-target='#edit_modal' \>";
			}},	
		      	    ],
			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:"Projects"
			}); 
	   $("#list2").jqGrid('filterToolbar',{searchOperators : false});//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").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 = $("#id").val();
		    	//var partner_code = $("#partner_code").val();
		    	var industry = $("#customer").val();
		    	var application = $("#description").val();
		    	var product_type = $("#product").val();
		    	var document_name = $("#application").val();
				var segment = $("#segment").val();
		    	var document = $("#document").val();
		    	 $.ajax({
		             
		    		 url:"<?php echo site_url('controller/projects_edit');?>",
		             type:"POST",
		             data:{'id':case_id,'customer':industry,'description':application,'product':product_type,'application':document_name,'segment':segment,'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.closest('tr').attr('id');

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

if(response!= "") 
                {
                    	$("#update_id").val(response.id);
			        	$("#update_customer").val(response.customer);
				    	$("#update_description").val(response.description);
				        $("#update_product").val(response.product);
				         $("#update_application").val(response.application);
				        $("#update_segment").val(response.segment);
				        $("#update_document").val(response.document);
                
                    $("#edit_modal").modal("show");
                    $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
                }
            }

});  
}	
	
	
	function deleteRow() {

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(update_customer)) {
            alert("Invalid input detected.");
            return false;
        }
        if (!alphaNumericPattern.test(update_description)) {
            alert("Invalid input detected.");
            return false;
        }
        if (!alphaNumericPattern.test(update_product)) {
            alert("Invalid input detected.");
            return false;
        }  if (!alphaNumericPattern.test(update_application)) {
            alert("Invalid input detected.");
            return false;
        }  if (!alphaNumericPattern.test(update_segment)) {
            alert("Invalid input detected.");
            return false;
        } 
        return true;
    }
</script>

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