Master builder

Master builder project was created by Kenny Koay from Global Connect Resources Sdn Bhd from simple table to system interface to reduce the developer work load. Master builder have been using following technology to make it simple to maintain without the need of the tools after the generation.

  • Codeigniter 2.0
  • JQuery
  • Metronic design template as the base

PrerequisiteEdit

  1. Download the source code to your local drive.
  2. Run download.sh and download.bat file
    • Make sure it points to the right project by open with notepad.
  3. Go to localhost:8080/<project schema> and log in with your company email.

Definition of the code name in the MasterBuilderEdit

IsUniqueEdit

Value Expected effect
Y Will force the system to check to make sure there are no other data with the same data exist before save.

Customer_EmailEdit

Value Expected effect
Y Will lock down the REST API to filter the data base on customer's login-email. This is only for non-admin user only. For admin, they still can see everything. In the edit form, by default...we will disable the edit and hardcode it to be customer email address

CustomerEmail_dont_lockEdit

Value Expected effect
Y Will not lock down as controller side as some customer email is there for reference only instead of filter

fk_viewEdit

This key is used by button selector which will show what are the field the user can see instead of showing everything.

Value Expected effect
Y If only "Y" exist, it will only display those with "Y"
N If only "N" exist, it will only hide those with "N"

admin_onlyEdit

Value Expected effect
Y If only "Y" exist, this field will be visible to admin user only

summary_viewEdit

Value Expected effect
Y If only "Y" exist, it will only display those with "Y" in the dashboard

custom_referenced_column_name_displayEdit

Put the field that you wish to display instead of the ID number

hideFormEdit

Value Expected effect
Y will hide the value as "hidden" instead of remove it totally compare to admin (if not admin). It is useful for calculation or hiding insensitive data and not-important data for user like today exchange rate which will be use partly for calculating

hide_newEdit

Value Expected effect
Y will hide the field when editing to prevent confusion as some field is not required to be seen by client when created

combobox_onlyEdit

Value Expected effect
Y It will display the drop down based on the custom_referenced_column_name_display

custom_referenced_column_name_displayEdit

Only work when comobobox_only = Y

It will display whatever field entered here instead of the default value

default_valueEdit

Value Expected effect
Y Expected default value in the field based on the field_name value

hideTableEdit

Value Expected effect
Y

Source code for download.shEdit

 1 curl "https://master-builder.appspot.com/my_generate_report.php?host_name=[mysql_ip]&user_name=[mysql_user_id]&user_pwd=[mysql_password]&db_name=[mysql_dbname]&socket=null&port=3306"
 2 
 3 success=0;
 4 
 5 while [ $success -eq 0 ]
 6 do
 7 success=0;
 8 gsutil -m cp -R gs://master-builder.appspot.com/project/[mysql_dbname]/* ./
 9 if [ $? -eq 0 ]
10 then
11 success=1;
12 else
13 say -v "Alex" "Download fail...will retry in 5 seconds"
14 sleep 5
15 fi
16 done