EVOLUTION-NINJA

Edit File: po_view_new.php

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

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

<div class="container-fluid">              
				<section class="admin_heading">
					<div class="col-sm-12">
						
	            		<h3>PO-Acknowledgements</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>							  
<div style="text-align: right; margin-bottom: 10px;align-items: center;">
  <label for="dateSearch" style="font-weight: bold; margin-right: 10px;">Search:</label>
  <input type="date" id="dateSearch" style="padding: 5px; width: 200px;">
</div>

<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>
</div>

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

<?php $this->load->view('includes/admin_dashboard_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>

// Separate Download column
    {
        name: 'download',
        index: 'download',
        width: 50,
        align: 'center',
        sortable: false,
        formatter: downloadFormatter
    }					  
			      	    ],
			rowNum:50,
        	rowTotal: 2000,
        	rowList : [50,100,500,1000],
			rownumbers: true,
        	rownumWidth: 40,
			pager:"#pager2", 
			sortname:'po_id', 
			viewrecords: true,
			loadonce:true,
			gridview: true,
			autowidth: true,
			sortorder:"desc", 
			loadonce: true,
			caption:"PO Acknowledgement"
			});

$('#dateSearch').on('keyup change', function () {
    let searchDate = $(this).val().trim();  // e.g. "2025-05-28"
    console.log('Original searchDate:', searchDate);

if (!searchDate) {
        const allData = $("#list2").jqGrid('getGridParam', 'data');
        $("#list2").jqGrid('clearGridData')
            .jqGrid('setGridParam', { data: allData })
            .trigger('reloadGrid');
        return;
    }

// Convert YYYY-MM-DD to DD-MM-YYYY
    const parts = searchDate.split('-');
    if(parts.length === 3) {
        searchDate = parts[2] + '-' + parts[1] + '-' + parts[0];  // DD-MM-YYYY
    }
    console.log('Converted searchDate:', searchDate);

const allData = $("#list2").jqGrid('getGridParam', 'data');

const filteredData = allData.filter(row => {
        return row.createdate && row.createdate.includes(searchDate);
    });

console.log('Filtered rows:', filteredData.length);

$("#list2").jqGrid('clearGridData')
        .jqGrid('setGridParam', { data: filteredData })
        .trigger('reloadGrid');
});

$("#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 viewFormatter(cellValue, options, rowObject) {
    const ackFile = rowObject[3];
    return `
<button onclick="viewDetails('${ackFile}')" title="View">View </button>
                  
       
    `;
}

function downloadFormatter(cellValue, options, rowObject) {
    const ackFile = rowObject[3];
    return `
 <button onclick="downloadPo('${ackFile}')" title="Download">Download </button>
                 
       
    `;
}

function viewDetails(fileName) {

// fileName="00002-Prithvi Power Engineers Pvt Ltd.pdf";
    if (!fileName) {
        alert("File name is missing");
        return;
    }
var base_url = "<?php echo base_url(); ?>";
const url = base_url + fileName;

window.open(url, '_blank');
}

function downloadPo(fileName) {
    // fileName = "00002-Prithvi Power Engineers Pvt Ltd.pdf";
    if (!fileName) {
        alert("File name is missing");
        return;
    }

var base_url = "<?php echo base_url(); ?>";
    const url = base_url + fileName;

const link = document.createElement('a');
    link.href = url;
    link.download = fileName; // Hint the browser to download
    document.body.appendChild(link);
    link.click();
    document.body.removeChild(link);
}

// function downloadPo(poId) {
//     //alert("Downloading PO ID: " + poId);
//     // You can trigger file download here, e.g.:
//     window.location.href = "<?= site_url('controller/download_po') ?>?po_id=" + poId;
// }

async:false,
				             success:function(data){
				                 if(data==""){
				                  alert('Successfully Deleted.'); 
				                
				                 
				                    //$("#editmodlist2").remove();
				                    $("#list2").trigger("reloadGrid");
				                    jQuery('#list2').jqGrid('editRow',po_id,true,reload());
				                   // $("#clientcode").attr("aria-expanded","false");
				                   // $("#cname").attr("aria-expanded","false");

}
				                 else{
				                	 alert('Successfully Deleted.'); 
				                	  $("#editmodlist2").remove();
				                	  window.location.reload();
				                 }
				             }
				         });
				         
				         
				     
				    	 
				    },
					closeAfterEdit: true,
					reloadAfterSubmit:false,
					afterSubmit : false 
					
				});

else $( "#dialogSelectRow" ).dialog();
	}
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 po_id = $("#po_id").val();
				    	
				    	var partner_code = $("#partner_code").val();
				    	var po_number = $("#po_number").val();
						//var date = $("#date").val();
				    	var acknowledgement = $("#acknowledgement").val();
				    	//var createdate = $("#createdate").val();
				    	 $.ajax({
				             
				             url:"<?php echo site_url('controller/po_info_insert_edit');?>",
				             type:"POST",
				            data:{'po_id':po_id,'partner_code':partner_code,'po_number':po_number,'acknowledgement':acknowledgement},

async:false,
				             success:function(data){
				                 if(data==""){
				                  alert('Successfully Updated.'); 
				                
				                 
				                    //$("#editmodlist2").remove();
				                    $("#list2").trigger("reloadGrid");
				                    jQuery('#list2').jqGrid('editRow',po_id,true,reload());
				                   // $("#clientcode").attr("aria-expanded","false");
				                   // $("#cname").attr("aria-expanded","false");

}
				                 else{
				                	 alert('Successfully Updated.'); 
				                	 $("#editmodlist2").remove();
				                	 window.location.reload();
				                 }
				             }
				         });
				         
				         
				     
				    	 
				    },
					closeAfterEdit: true,
					reloadAfterSubmit:false,
					afterSubmit : false 
					
				});

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>