<?php


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


$form_field_separator[$sys_field_id]="Service Item Identification";

//---------------------------------------------------------------------------------------------------------------------------
$form_field[$sys_field_id]="svi_product_id";
$form_field_label[$sys_field_id]="Product";
$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 pdt_id as value, concat(pdt_code,' - ', pdt_name) as text from t_".$key_table_prefix."_product "; //SQL String(select XX as value, YY as text from...) or Keyword 
$form_field_dropdown_option_values_key[$sys_field_id]="pdt_id"; //SQL row ID
$sys_field_id++;



//---------------------------------------------------------------------------------------------------------------------------
$form_field[$sys_field_id]="svi_serial_no";
$form_field_label[$sys_field_id]="Serial No.";
$form_field_hints[$sys_field_id]="Serial No.";
$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]="Additional Info";


//---------------------------------------------------------------------------------------------------------------------------
$form_field[$sys_field_id]="svi_product_size";
$form_field_label[$sys_field_id]="Size";
$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++;


//---------------------------------------------------------------------------------------------------------------------------
$form_field[$sys_field_id]="svi_product_color";
$form_field_label[$sys_field_id]="Color";
$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++;



//---------------------------------------------------------------------------------------------------------------------------
$form_field[$sys_field_id]="svi_product_pattern";
$form_field_label[$sys_field_id]="Pattern";
$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++;


$form_field_separator[$sys_field_id]="Owner Information";






//---------------------------------------------------------------------------------------------------------------------------
$form_field[$sys_field_id]="svi_customer_code";
$form_field_label[$sys_field_id]="Customer";
$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 cus_code as value, concat(cus_code,' - ', cus_name) as text from t_".$key_table_prefix."_customer "; //SQL String(select XX as value, YY as text from...) or Keyword 
$form_field_dropdown_option_values_key[$sys_field_id]="cus_code"; //SQL row ID
$sys_field_id++;

//---------------------------------------------------------------------------------------------------------------------------
$form_field[$sys_field_id]="svi_date_issued";
$form_field_label[$sys_field_id]="Date Issued";
$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]="textbox textbox-s"; //(textbox/upload/dropdown/textarea/checkbox)
$form_field_type[$sys_field_id]="DATE"; //(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]="Item Status";


//---------------------------------------------------------------------------------------------------------------------------
$form_field[$sys_field_id]="svi_status";
$form_field_label[$sys_field_id]="Status";
$form_field_value[$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 sis_code as value, concat(sis_code,' - ', sis_name) as text from t_".$key_table_prefix."_service_item_status"; //SQL String(select XX as value, YY as text from...) or Keyword 
$form_field_dropdown_option_values_key[$sys_field_id]="sis_code"; //SQL row ID
$sys_field_id++;







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








?>