<?php


//All this setting can be configured accordingly for the view display
  	
  	//===Row Limit per page========
	$limit=50;
  
  	
    //===Search Label =============
    //no need to specify field for search after v7.1 framework
	//$listing_search_label[1]="Name";
	//$listing_search_label[2]="User ID";
	//$listing_search_label[3]="Email";
	
		
	//===Search Fields==========
	$listing_search_field[1]="poh_doc_no";
	$listing_search_field[2]="poh_vendor_code";
	$listing_search_field[3]="poh_vendor_name";
	$listing_search_field[4]="poh_reference_no";
	$listing_search_field[5]="poh_remark";
	
	
	
        
        
        
  	//===Header Label =============
  	$listing_header[1]="Modified Date";
	$listing_header[2]="Doc. No.";
	$listing_header[3]="Vendor";
	$listing_header[4]="Date";
	$listing_header[5]="Amount";
	$listing_header[6]="Status";
	$listing_header[7]="Transaction";
	$listing_header[8]="Reference";
	$listing_header[9]="Remark";
	
	
	
		
	//===Database Fields==========
	$listing_content[1]="modified_date";
	$listing_content[2]="poh_doc_no";
	$listing_content[3]="poh_vendor_name";
	$listing_content[4]="poh_date";
	$listing_content[5]="poh_total_amount";
	$listing_content[6]="poh_status";
	$listing_content[7]="poh_module";
	$listing_content[8]="poh_reference_no";
	$listing_content[9]="poh_remark";
	
	
	
	
	
	//===Column width==========
	$listing_width[1]="80";
	$listing_width[2]="60";	
	$listing_width[3]="150";
	$listing_width[4]="80";
	$listing_width[5]="60";
	$listing_width[6]="60";
	$listing_width[7]="100";
	$listing_width[8]="80";
	$listing_width[9]="100";
	
	
	
	
        //===Column align==========
	$listing_align[1]="left";
    	$listing_align[2]="left";
    	$listing_align[3]="left";
	$listing_align[4]="left";
	$listing_align[5]="right";
	$listing_align[6]="left";
	$listing_align[7]="left";
	$listing_align[8]="left";
	$listing_align[9]="left";
	
	
	
    
        
	//==Listing Url===============
	$this_url="mod/purchase_order_transaction/index.php";
	$display_url="mod/purchase_order_transaction/display.php";
	
	

	
	
	//===Main SQL query=============
    $query="SELECT * , date_format(modified_date,'%d-%m-%Y') as modified_date_f FROM $form_table_name ";
    $query=$query." where ifnull(client_id,0) >= 0 ";
    
    
    
    
    if($_SESSION["list_filter"]["filter_purchase_order_vendor"]!="ALL")
    {
    		$query=$query." and poh_vendor_code = '".$_SESSION["list_filter"]["filter_purchase_order_vendor"]."' ";
    }
    
    
	//$query=$query." where client_id = '".$CurrentUserID."' ";
	
    
	
	//==Action Button Setting======
	$action_cell=true;
	$action_cell_edit=false;
	$action_cell_delete=false;
?>