<?php


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


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


//---------------------------------------------------------------------------------------------------------------------------
$form_field[$sys_field_id]="dev_android_id";
$form_field_label[$sys_field_id]="Device ID";
$form_field_hints[$sys_field_id]="";
$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-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[$sys_field_id]="dev_name";
$form_field_label[$sys_field_id]="Device Name";
$form_field_hints[$sys_field_id]="Device 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]="Inventory Posting";

//---------------------------------------------------------------------------------------------------------------------------
$form_field[$sys_field_id]="dev_default_warehouse_code";
$form_field_label[$sys_field_id]="Default Inventory Posting 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[$sys_field_id]="dev_stock_posting_stage";
$form_field_label[$sys_field_id]="Stock Posting Stage";
$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]="KEYWORD"; //(KEYWORD = include/keyword.php,  SQL = From database )
$form_field_dropdown_option_values[$sys_field_id]="key_stock_posting_stage"; //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]="Regional Pricing";


//---------------------------------------------------------------------------------------------------------------------------
$form_field[$sys_field_id]="dev_price_region_id";
$form_field_label[$sys_field_id]="Region (Leave blank if use Standard Price)";
$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]="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 reg_id as value,concat(reg_code,' - ', reg_name ) as text from t_".$key_table_prefix."_price_region "; //SQL String(select XX as value, YY as text from...) or Keyword 
$form_field_dropdown_option_values_key[$sys_field_id]="reg_id"; //SQL row ID
$sys_field_id++;



$form_field_separator[$sys_field_id]="Customer Route";


//---------------------------------------------------------------------------------------------------------------------------
$form_field[$sys_field_id]="dev_route_code";
$form_field_label[$sys_field_id]="Route";
$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]="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 rou_code as value, rou_name as text from t_".$key_table_prefix."_route"; //SQL String(select XX as value, YY as text from...) or Keyword 
$form_field_dropdown_option_values_key[$sys_field_id]="rou_code"; //SQL row ID
$sys_field_id++;



$form_field_separator[$sys_field_id]="Sync Setting";


//---------------------------------------------------------------------------------------------------------------------------
$form_field[$sys_field_id]="dev_sync_company_info";
$form_field_label[$sys_field_id]="Use Server Company Name & Address";
$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]="KEYWORD"; //(KEYWORD = include/keyword.php,  SQL = From database )
$form_field_dropdown_option_values[$sys_field_id]="key_yes_no"; //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."_device";








?>