<?php


//Main Configuration ====================================
//Database Field (Columns)
$form_key_id="loc_id";
$sys_field_id=1;


$form_field_separator[$sys_field_id]="Location Info";


//---------------------------------------------------------------------------------------------------------------------------
$form_field[$sys_field_id]="loc_code";
$form_field_label[$sys_field_id]="Location Code";
$form_field_hints[$sys_field_id]="Location Code";
$form_field_value[$sys_field_id]="";
$form_field_unique[$sys_field_id]="YES";
$form_field_checking[$sys_field_id]="COMPULSORY"; //(COMPULSORY/OPTIONAL/PASSWORD1/PASSWORD2)
$form_field_class[$sys_field_id]="textbox textbox-m"; //(textbox/upload/dropdown/textarea/checkbox)
$form_field_type[$sys_field_id]="TEXT"; //(TEXT/PASSWORD/TEXTSUGGEST/DATE_START/DATE_END/DATE/TIME/PASSWORD/DROPDOWN/FILE_PHOTO/PRICE/QUANTITY)
$form_field_dropdown_option[$sys_field_id]=""; //(KEYWORD = include/keyword.php,  SQL = From database )
$form_field_dropdown_option_values[$sys_field_id]=""; //SQL String(select XX as value, YY as text from...) or Keyword 
$form_field_dropdown_option_values_key[$sys_field_id]=""; //SQL row ID
$sys_field_id++;



//---------------------------------------------------------------------------------------------------------------------------
$form_field[$sys_field_id]="loc_name";
$form_field_label[$sys_field_id]="Location Name";
$form_field_hints[$sys_field_id]="Location Name";
$form_field_value[$sys_field_id]="";
$form_field_unique[$sys_field_id]="";
$form_field_checking[$sys_field_id]="COMPULSORY"; //(COMPULSORY/OPTIONAL/PASSWORD1/PASSWORD2)
$form_field_class[$sys_field_id]="textbox textbox-l"; //(textbox/upload/dropdown/textarea/checkbox)
$form_field_type[$sys_field_id]="TEXT"; //(TEXT/PASSWORD/TEXTSUGGEST/DATE_START/DATE_END/DATE/TIME/PASSWORD/DROPDOWN/FILE_PHOTO/PRICE/QUANTITY)
$form_field_dropdown_option[$sys_field_id]=""; //(KEYWORD = include/keyword.php,  SQL = From database )
$form_field_dropdown_option_values[$sys_field_id]=""; //SQL String(select XX as value, YY as text from...) or Keyword 
$form_field_dropdown_option_values_key[$sys_field_id]=""; //SQL row ID
$sys_field_id++;




$form_field_separator[$sys_field_id]="Floor";



//---------------------------------------------------------------------------------------------------------------------------
$form_field[$sys_field_id]="loc_floor_code";
$form_field_label[$sys_field_id]="Floor";
$form_field_hints[$sys_field_id]="";
$form_field_value[$sys_field_id]="";
$form_field_unique[$sys_field_id]="";
$form_field_checking[$sys_field_id]="COMPULSORY"; //(COMPULSORY/OPTIONAL/PASSWORD1/PASSWORD2)
$form_field_class[$sys_field_id]="dropdown dropdown-auto"; //(textbox/upload/dropdown/textarea/checkbox)
$form_field_type[$sys_field_id]="DROPDOWN"; //(TEXT/PASSWORD/TEXTSUGGEST/DATE_START/DATE_END/DATE/TIME/PASSWORD/DROPDOWN/FILE_PHOTO/PRICE/QUANTITY)
$form_field_dropdown_option[$sys_field_id]="SQL"; //(KEYWORD = include/keyword.php,  SQL = From database )
$form_field_dropdown_option_values[$sys_field_id]="select flr_code as value, concat(flr_code,' - ',flr_name ) as text from t_".$key_table_prefix."_floor_plan "; //SQL String(select XX as value, YY as text from...) or Keyword 
$form_field_dropdown_option_values_key[$sys_field_id]="flr_code"; //SQL row ID
$sys_field_id++;







$form_field_separator[$sys_field_id]="Warehouse";



//---------------------------------------------------------------------------------------------------------------------------
$form_field[$sys_field_id]="loc_warehouse_code";
$form_field_label[$sys_field_id]="Warehouse";
$form_field_hints[$sys_field_id]="";
$form_field_value[$sys_field_id]="";
$form_field_unique[$sys_field_id]="";
$form_field_checking[$sys_field_id]="COMPULSORY"; //(COMPULSORY/OPTIONAL/PASSWORD1/PASSWORD2)
$form_field_class[$sys_field_id]="dropdown dropdown-auto"; //(textbox/upload/dropdown/textarea/checkbox)
$form_field_type[$sys_field_id]="DROPDOWN"; //(TEXT/PASSWORD/TEXTSUGGEST/DATE_START/DATE_END/DATE/TIME/PASSWORD/DROPDOWN/FILE_PHOTO/PRICE/QUANTITY)
$form_field_dropdown_option[$sys_field_id]="SQL"; //(KEYWORD = include/keyword.php,  SQL = From database )
$form_field_dropdown_option_values[$sys_field_id]="select whs_code as value, concat(whs_code, ' - ',whs_name ) as text from t_".$key_table_prefix."_warehouse "; //SQL String(select XX as value, YY as text from...) or Keyword 
$form_field_dropdown_option_values_key[$sys_field_id]="whs_code"; //SQL row ID
$sys_field_id++;


$form_field_separator[$sys_field_id]="Picking List Sequence";



//---------------------------------------------------------------------------------------------------------------------------
$form_field[$sys_field_id]="loc_picking_sequence";
$form_field_label[$sys_field_id]="Sequence Key";
$form_field_hints[$sys_field_id]="";
$form_field_value[$sys_field_id]="";
$form_field_unique[$sys_field_id]="";
$form_field_checking[$sys_field_id]="OPTIONAL"; //(COMPULSORY/OPTIONAL/PASSWORD1/PASSWORD2)
$form_field_class[$sys_field_id]="textbox textbox-m"; //(textbox/upload/dropdown/textarea/checkbox)
$form_field_type[$sys_field_id]="TEXT"; //(TEXT/PASSWORD/TEXTSUGGEST/DATE_START/DATE_END/DATE/TIME/PASSWORD/DROPDOWN/FILE_PHOTO/PRICE/QUANTITY)
$form_field_dropdown_option[$sys_field_id]=""; //(KEYWORD = include/keyword.php,  SQL = From database )
$form_field_dropdown_option_values[$sys_field_id]=""; //SQL String(select XX as value, YY as text from...) or Keyword 
$form_field_dropdown_option_values_key[$sys_field_id]=""; //SQL row ID
$sys_field_id++;


//table name
$form_table_name="t_".$key_table_prefix."_storage_location";








?>