<?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]="sth_doc_no";
	$listing_search_field[2]="sth_customer_code";
	$listing_search_field[3]="sth_customer_name";
	$listing_search_field[4]="sth_vendor_code";
	$listing_search_field[5]="sth_vendor_name";
	
	
	
        
        
        
  	//===Header Label =============
  	$listing_header[1]="Modified Date";
	$listing_header[2]="Device Tran ID";
	$listing_header[3]="Device";
	$listing_header[4]="Storage Location";
	$listing_header[5]="User";
	$listing_header[6]="Posting Type";
	$listing_header[7]="Product Code";
	$listing_header[8]="Quantity";
	$listing_header[9]="Inventory Posting Status";
	
	
	
		
	//===Database Fields==========
	$listing_content[1]="modified_date";
	$listing_content[2]="iit_device_iit_id";
	$listing_content[3]="device_id";
	$listing_content[4]="iit_location_code";
	$listing_content[5]="iit_user";
	$listing_content[6]="iit_type";
	$listing_content[7]="iit_product_code";
	$listing_content[8]="iit_quantity";
	
	$listing_content[9]="iit_inventory_posting_status";
	
	
	
	
	
	//===Column width==========
	$listing_width[1]="80";
	$listing_width[2]="80";
	$listing_width[3]="100";
	$listing_width[4]="120";
	$listing_width[5]="100";
	$listing_width[6]="80";
	$listing_width[7]="80";
	$listing_width[8]="80";
	
	$listing_width[9]="120";
	$listing_width[10]="100";
	$listing_width[11]="80";
	
	
	
        //===Column align==========
	$listing_align[1]="left";
    	$listing_align[2]="left";
    	$listing_align[3]="left";
	$listing_align[4]="left";
	$listing_align[5]="left";
	$listing_align[6]="left";
	$listing_align[7]="left";
	$listing_align[8]="right";
	
	$listing_align[9]="left";
	$listing_align[10]="left";
	$listing_align[11]="left";
	
    
        
	//==Listing Url===============
	$this_url="mod/stock_transaction_internal/index.php";
	$display_url="mod/stock_transaction_internal/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_internal_stock_transaction_type"]!="ALL")
    {
    		$query=$query." and iit_type = '".$_SESSION["list_filter"]["filter_internal_stock_transaction_type"]."' ";
    }

    if($_SESSION["list_filter"]["filter_internal_stock_transaction_location_code"]!="ALL")
    {
    		$query=$query." and iit_location_code = '".$_SESSION["list_filter"]["filter_internal_stock_transaction_location_code"]."' ";
    }
    
    if($_SESSION["list_filter"]["filter_internal_stock_transaction_product_code"]!="ALL")
    {
    		$query=$query." and iit_product_code = '".$_SESSION["list_filter"]["filter_internal_stock_transaction_product_code"]."' ";
    }
    
    
	//$query=$query." where client_id = '".$CurrentUserID."' ";
	
    
	
	//==Action Button Setting======
	$action_cell=true;
	$action_cell_edit=false;
	$action_cell_delete=false;
?>