EVOLUTION-NINJA
Edit File: projects_list.php
<?php echo view('includes/header');?> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('public/assets/admin_dashboard/css/ui.jqgrid-bootstrap.css'); ?>" /> <script type="text/ecmascript" src="<?php echo base_url('public/assets/jqgrid/jqgrid/js/jquery.jqGrid.min.js'); ?>"></script> <script type="text/ecmascript" src="<?php echo base_url('public/assets/jqgrid/jqgrid/js/i18n/grid.locale-en.js'); ?>"></script> <section class="content-header"> <h1> Projects </h1> </section> <!--- section 1 --> <section class="content"> <div id="menu1" class="tab-panecol-sm-12 col-md-12 "> <div class="col-sm-1"></div> <div id = "jaytab3" style="margin-top:3%;" class="col-sm-10 grid"> <div class="grid_div"></div><table id="list3"></table> <div id="pager3"></div> <div id="dialogSelectRow3" title="Warning" style="display:none"> <p>Please select row</p> </div> </div> </div> </section> <!--- section 2 --> <!-- Modal --> <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">×</button> <h4 class="modal-title">Update project details</h4> </div> <div class="modal-body"> <form id="land_owner" class="form-inline update_form" method="post" enctype="multipart/form-data"> <input type="hidden" class="form-control col-sm-8 project_id_fk" name="project_id" required="required"> <div class="row land_owner_a"> <div class="col-sm-12 col-md-6" style="margin-left:15px;margin-bottom:15px;"> <label class="radio-inline"> <input style="width: 21% !important;margin-top: -5px;" type="radio" value="DTCP" name="project_type">DTCP</label> <label class="radio-inline"> <input style="width: 19% !important;margin-top: -5px;" type="radio" value="MUDA" name="project_type">MUDA</label> </div> </div> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4">Project Name</label> <input type="text" class="form-control col-sm-8 project_name" name="project_name" required="required"> <!-- <select name="project_name" class="form-control project_name" required> <option value="">Select Project Name</option> <?php foreach($project_master as $val) { ?> <option value="<?php echo $val->project_name;?>"><?php echo $val->project_name;?></option> <?php } ?> </select>--> </div> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-md-4">Nick Name</label> <input type="text" class="form-control col-sm-8 nick_name" name="nick_name" required> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4">Land owner / Developer</label> <select class="form-control land_owner land_owner_dd" name="land_owner"> <!-- <option value="Gss">Gss</option> --> <?php foreach($owners as $value) { ?> <option value="<?php echo $value->owner_id;?>"><?php echo $value->name;?></option> <?php } ?> </select> </div> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-md-4">Land owner / Developer Address</label> <textarea type="text" class="form-control col-sm-8 land_owner_address" name="land_owner_address"></textarea> </div> </div> <!-- row 2--> <!--<div class="row land_owner_a">--> <!--</div> <!-- row 3--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4">Project Ownership</label> <select class="form-control marketing" onchange="owner_hide()" name="marketing"> <option value="Select">Select</option> <option value="Owner">Owner </option> <option value="Confirming Party">Confirming Party </option> </select> </div> <div class="form-group col-sm-12 col-md-6 owner_name"> <label class="col-sm-4 col-md-4">Project Ownership Name</label> <select class="form-control project_ownership" name="project_ownership"> <option value="Select">Select</option> <!-- <option value="Gss">Gss</option> --> <?php foreach($project_owner as $value) { ?> <option value="<?php echo $value->id;?>"><?php echo $value->project_ownership;?></option> <?php } ?> </select> </div> <div class="form-group col-sm-12 col-md-6 party_name"> <label class="col-sm-4 col-md-4">Confirming Party Name</label> <input type="text" class="form-control col-sm-8 confirming_party_name" name="confirming_party_name" > </div> </div> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-md-4">No of Years</label> <input type="text" class="form-control col-sm-8 no_of_years" name="no_of_years" required> </div> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-md-4">Maintenance Per Sqft</label> <input type="text" class="form-control col-sm-8 per_sq_ft" name="per_sq_ft" required> </div> </div> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-md-4">Approved plan</label> <input type="file" class="col-sm-8 text-center center-block well well-sm" name="approved_plan_image"> <div class="approval_image"> </div> </div> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-md-4">Upload excel</label> <input type="file" name="excel_file" id="file" class="file-chooser__input col-sm-8 text-center center-block well well-sm"> </div> </div> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-md-4">Conversion order</label> <input type="file" class="col-sm-8 text-center center-block well well-sm" name="conversion_order_image[]" multiple> <div class="conversion_order"> </div> </div> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-md-4">Handled By</label> <select class="form-control handled_by_dd" name="handled_by"> <option value="">Select</option> <?php foreach($users as $value) { ?> <option value="<?php echo $value->user_id;?>"><?php echo $value->username;?></option> <?php } ?> </select> </div> </div> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-md-4">Release Order</label> <input type="file" class="col-sm-8 text-center center-block well well-sm" name="release_order_image"> <div class="release_image"> </div> </div> <div class="col-sm-4 col-md-4"></div> <div class="col-sm-4 col-md-4"> <button type="submit" class="btn btn-primary center-block submit">Update</button> </div> <div class="col-sm-4 col-md-4"></div> </div><!-- row 6--> </form> </div> </div> </div> </div> <!-- This is the Javascript file of jqGrid --> <script type="text/ecmascript" src="<?php echo base_url('public/jqgrid/js/jquery.jqGrid.min.js'); ?>"></script> <!-- This is the localization file of the grid controlling messages, labels, etc. <!-- We support more than 40 localizations --> <script type="text/ecmascript" src="<?php echo base_url('public/jqgrid/js/i18n/grid.locale-en.js'); ?>"></script> <!-- A link to a jQuery UI ThemeRoller theme, more than 22 built-in and many more custom --> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('public/assets/css/jquery-ui.css'); ?>" /> <!-- The link to the CSS that the grid needs --> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('public/jqgrid/css/ui.jqgrid.css'); ?>" /> <script src="<?php echo base_url('public/assets/js/jquery-ui.js'); ?>" type="text/javascript"></script> <style type="text/css"> .content-wrapper, .right-side { min-height:1200px !important; } a { color: inherit; } .sqft_row input{ width: 100% !important; } </style> <script type="text/javascript"> function owner_hide() { var owner=$(".marketing").val(); if(owner == "Confirming Party") { $(".owner_name").hide(); $(".party_name").show(); } else { $(".owner_name").show(); $(".party_name").hide(); } } function some_function() { console.log(" button clicked!"); } $(document).ready(function (){ $(".party_name").hide(); jQuery("#list3").jqGrid({ url:"<?php echo site_url('new-projects-list')?>", mtype : "post", datatype: "json", colNames:['SI','App Display','Project','Project Type','Land Owner/Developer','Land Owner/Developer Address','project Ownership','Project Ownership Name','Nick Name','No of Years','Maintenance Per Sqft','Status','View','Edit','Delete','Change'], colModel:[ {name:'project_id',index:'project_id', width:50, hidden:true,editable:false,key:true}, // {name:' ',index:' ',search:false,editable:false,align: "center",editrules:{required: true}, width:30,formatter:function (cellvalue, options, rowObject) { // if(rowObject.mobile_status == "SELECTED") // { // return '<input type="checkbox" class="cbox" value="'+rowObject.project_id+'" checked\>'; // } // else // { // return '<input type="checkbox" class="cbox" value="'+rowObject.project_id+'"\>'; // } // }}, {name:'checkbox',index:'checkbox', width:100, editable:false}, {name:'land_project',index:'land_project', width:100, editable:false}, {name:'site_type',index:'site_type', width:100, editable:false}, {name:'owner',index:'owner', width:175, editable:false}, {name:'land_owner_address',index:'owner', width:250, editable:false}, {name:'marketing',index:'marketing', width:100, editable:false}, {name:'project_ownership',index:'project_ownership', width:250, editable:false}, {name:'nick_name',index:'nick_name', width:100, editable:false}, {name:'no_of_years',index:'no_of_years', width:100, editable:false}, {name:'maintenance_per_sqft',index:'maintenance_per_sqft', width:100, editable:false}, {name:'project_status',index:'project_status', width:100, editable:false}, {name:' ',index:' ',editable:false,align: "center",editrules:{required: true}, width:100,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="fun_view($(this))" '; },formatter:function (cellvalue, options, rowObject) { return "<input type='button' value='VIEW' \>"; }}, {name:' ',index:' ',editable:false,align: "center",editrules:{required: true}, width:100,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' \>"; }}, {name:'delete',index:'delete',align: "center",editable:false,editrules:{required: true}, width:100,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="fun_delete($(this))" '; },formatter:function (cellvalue, options, rowObject) { return "<input type='button' value='DELETE' \>"; }}, {name:'close',index:'close',align: "center",editable:false,editrules:{required: true}, width:100,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="fun_close($(this))" '; },formatter:function (cellvalue, options, rowObject) { return "<input type='button' value='CHANGE' \>"; }}, ], rowNum:20, rowTotal: 2000, rowList : [10,20,30,50,100,500,1000], rownumbers: true, rownumWidth: 40, pager:"#pager3", sortname:'owner_id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: false, emptyrecords: 'No records to display', //multiselect: true, // multiboxonly: true, loadonce:true, caption:" Project List", }); $("#list3").jqGrid("setLabel", "rn", "SL"); $("#list3").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required $("#list3").jqGrid('navGrid','#pager3', {edit:true,add:false,del:false,search:true,refreshstate:"current"}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true } ); }); //----------------------------mobile support---------------------------// $(document).on('change','.cbox',function(){ var project_id = $(this).val(); if ($(this).is(':checked')) { var status = 'checked'; } else { var status = 'not_checked'; } $.ajax({ url:"<?php echo site_url('update-mobile-project-status')?>", type:"POST", data:{project_id:project_id,status:status}, success:function(response) { //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { } } }); }); //-----------------------------------------------------------------------// function fun(rowId) { var id = rowId.closest('tr').attr('id'); $.ajax({ url:"<?php echo site_url("edit-new-project")?>", type:"POST", data:{project_id:id}, success:function(response) { //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { $(".project_id_fk").val(response.project_details.project_id); $(".project_name").val(response.project_details.project_name); $(".land_owner_address").val(response.project_details.land_owner_address); $(".marketing").val(response.project_details.marketing); if(response.project_details.marketing == 'Confirming Party') { $('.owner_name').hide(); $('.party_name').show(); $(".confirming_party_name").val(response.project_details.project_ownership); } else { $('.party_name').hide(); $('.owner_name').show(); $(".project_ownership").val(response.project_details.project_ownership); } $(".land_owner_dd option[value='"+response.project_details.land_owner_id+"']").attr("selected","selected"); $(".handled_by_dd option[value='"+response.project_details.handled_by+"']").attr("selected","selected"); $(".nick_name").val(response.project_details.nick_name); $(".no_of_years").val(response.project_details.no_of_years); $(".per_sq_ft").val(response.project_details.maintenance_per_sqft); $("input[name=project_type][value=" + response.project_details.site_type + "]").prop('checked', true); $("#edit_modal").modal("show"); $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); var approval_image_ext = response.project_details.approval_image.split('.'); approval_image_ext = approval_image_ext.reverse(); if(approval_image_ext[0] == "pdf" || approval_image_ext[0] == "PDF" || approval_image_ext[0] == "doc" || approval_image_ext[0] == "docx" ) { $('.approval_image').empty(); var retVal = ''; retVal +='<a href="<?php echo base_url('documentation_approved_uploads');?>/'+response.project_details.approval_image+'" target="_blank" style="margin-left: 35%;" >'+response.project_details.approval_image+'</a>'; $('.approval_image').append(retVal); } else { $('.approval_image').empty(); var retVal = ''; retVal +='<a href="<?php echo base_url('documentation_approved_uploads');?>/'+response.project_details.approval_image+'" target="_blank" style="margin-left: 35%;">'+response.project_details.approval_image+'</a>'; $('.approval_image').append(retVal); } var release_image_ext = response.project_details.release_image.split('.'); release_image_ext = release_image_ext.reverse(); if(release_image_ext[0] == "pdf" || release_image_ext[0] == "PDF" || release_image_ext[0] == "doc" || release_image_ext[0] == "docx" ) { $('.release_image').empty(); var retVal1 = ''; retVal1 +='<a href="<?php echo base_url('documentation_release_uploads');?>/'+response.project_details.release_image+'" target="_blank" style="margin-left: 35%;">'+response.project_details.release_image+'</a>'; $('.release_image').append(retVal1); } else { $('.release_image').empty(); var retVal1 = ''; retVal1 +='<a href="<?php echo base_url('documentation_release_uploads');?>/'+response.project_details.release_image+'" target="_blank" style="margin-left: 35%;">'+response.project_details.release_image+'</a>'; $('.release_image').append(retVal1); } var conversionr_image_ext = response.project_details.conversion_order?.split('.') || []; conversionr_image_ext = conversionr_image_ext.reverse(); if(conversionr_image_ext[0] == "pdf" || conversionr_image_ext[0] == "PDF" || conversionr_image_ext[0] == "doc" || conversionr_image_ext[0] == "docx" ) { $('.conversion_order').empty(); var retVal2 = ''; retVal2 +='<a href="<?php echo base_url('documentation_conversion_uploads');?>/'+response.project_details.conversion_order+'" target="_blank" style="margin-left: 35%;">'+response.project_details.conversion_order+'</a>'; $('.conversion_order').append(retVal2); } else { $('.conversion_order').empty(); var retVal2 = ''; retVal2 +='<a href="<?php echo base_url('documentation_conversion_uploads');?>/'+response.project_details.conversion_order+'" target="_blank" style="margin-left: 35%;">'+response.project_details.conversion_order+'</a>'; $('.conversion_order').append(retVal2); } } } }); } function fun_delete(rowId) { var id = rowId.closest('tr').attr('id'); var project_id=id; swal({ title: "Are you sure?", text: "You will not be able to recover this data!", type: "warning", showCancelButton: true, confirmButtonColor: "#DD6B55", confirmButtonText: "Yes, delete it!", cancelButtonText: "No, cancel plz!", closeOnConfirm: false, closeOnCancel: false }, function(isConfirm){ if (isConfirm) { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); $.ajax({ type : 'post', url : '<?php echo site_url("delete-new-project")?>', data : {project_id:project_id}, success:function(response) { //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { toastr["success"]("Deleted successfully"); $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); } } }); } else { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); } }); } function fun_close(rowId) { var id = rowId.closest('tr').attr('id'); var project_id=id; //alert(project_id); swal({ title: "Are you sure?", text: "Do you really wants to change status of this project?", type: "warning", showCancelButton: true, confirmButtonColor: "#DD6B55", confirmButtonText: "Yes, Change it!", cancelButtonText: "No, Cancel plz!", closeOnConfirm: false, closeOnCancel: false }, function(isConfirm){ if (isConfirm) { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); //test.attr('disabled', 'disabled'); //test.text("Closing..."); $.ajax({ type : 'post', url : '<?php echo site_url("close-new-project")?>', data : {project_id:project_id}, success:function(response) { // response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { toastr["success"](response.message); // NewProjectsList(); $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');// } } }); } else { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); } }); } function fun_view(rowId) { var id = rowId.closest('tr').attr('id'); var project_id=id; $.ajax({ url:"<?php echo site_url('project-details')?>/"+ project_id, type:"POST", //data:{project_id:project_id}, success:function(response) { //alert(response); window.location.href="<?php echo site_url('project-details')?>/"+ project_id; } }); } $('.update_form').submit(function(e){ e.preventDefault(); formdata = new FormData($(this)[0]); $(".submit").attr('disabled', 'disabled'); $(".submit").text("Updating..."); $.ajax({ type : 'post', url : '<?php echo site_url("update-new-project")?>', data : formdata, contentType: false, processData: false, success:function(response){ //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { $("#edit_modal").modal("hide"); //NewProjectsList(); toastr["success"](response.message); $('.update_form')[0].reset(); $(".submit").text("Submit"); $(".submit").removeAttr('disabled'); $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); } else if(response.result == 2) { toastr["error"](response.message); $(".submit").text("Submit"); $(".submit").removeAttr('disabled'); } else if(response.result == 3) { toastr["error"](response.message); $(".submit").text("Submit"); $(".submit").removeAttr('disabled'); } else { toastr["error"](response.message); $(".submit").text("Submit"); $(".submit").removeAttr('disabled'); } } }); }); </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); } #FrmGrid_list2 { width: 100% !important; } .ui-jqdialog .ui-jqdialog-titlebar { height: 29px !important; background-color: #001a00; color: white; padding-left: 10px; } .fm-button { height: 21px !important; padding: 1px; margin-right: 10px !important; height: 21px !important; width: 50%; margin-top: -7px !important; } .ui-jqdialog-content td.navButton { padding-top: 12px !important; } .ui-jqgrid .ui-jqgrid-titlebar { height: 27px !important; background:#AF0100 !important; color:white !important; } .ui-jqgrid-bdiv { height: 232px !important; } .ui-widget-overlay { z-index:0 !important; } .ui-widget-header { background: #1e7ad7 !important; } .ui-jqgrid-hdiv ui-state-default { width: 873px !important; cursor: default!important } ui-state-highlight, .ui-widget-content .ui-state-highlight, .ui-widget-header .ui-state-highlight { border: 1px solid #fed22f; background: #ffe45c; } .ui-state-default, .ui-widget-content .ui-state-default, .ui-widget-header .ui-state-default { font-weight: bold; color: black; } .ui-jqgrid .ui-jqgrid-bdiv { overflow-y: scroll; //overflow-x: hidden; } .content-wrapper, .right-side { min-height: 1750px !important; } </style> <script type="text/javascript"> $(document).ready(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; }; }; <?php echo view('includes/footer');?>