Pods Employee Information System - Install Pods Wordpress Plugin and Enable Migrate Packages -> Import

pods-employee.json

{"meta":{"version":"2.6","build":1451884220},"pods":{"4":{"id":4,"name":"user","label":"User","description":"","type":"user","storage":"table","object":"user","alias":"","fields":{"employee_id":{"id":5,"name":"employee_id","label":"Employee ID","description":"GIO-001","help":"","class":"","type":"text","weight":0,"pick_object":"","pick_val":"","sister_id":"","required":"0","unique":"0","text_allow_shortcode":"0","text_allow_html":"0","text_allowed_html_tags":"strong em a ul ol li b i","text_max_length":"255","admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"text_repeatable":"0"},"designation":{"id":101,"name":"designation","label":"Designation","description":"","help":"","class":"","type":"pick","weight":1,"pick_object":"custom-simple","pick_val":"","sister_id":"","pick_custom":"Executive Director\nBusiness Analyst\nDriver\nNetwork Engineer\nRecruitment Supervisor\nRecruitment Assistant\nSoftware Engineer\nUI Developer\n","required":"0","unique":"0","pick_format_type":"single","pick_format_single":"dropdown","pick_format_multi":"checkbox","pick_taggable":"0","pick_limit":"0","pick_allow_html":"0","pick_user_role":[],"admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"pick_select_text":"","pick_table_id":"","pick_table_index":"","pick_display":"","pick_where":"","pick_orderby":"","pick_groupby":""},"date_of_birth":{"id":6,"name":"date_of_birth","label":"Date of Birth","description":"","help":"","class":"","type":"date","weight":2,"pick_object":"","pick_val":"","sister_id":"","required":"0","unique":"0","date_format":"mdy","date_allow_empty":"1","date_html5":"0","admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"date_repeatable":"0"},"gender":{"id":7,"name":"gender","label":"Gender","description":"","help":"","class":"","type":"pick","weight":3,"pick_object":"custom-simple","pick_val":"","sister_id":"","pick_custom":"M\nF","required":"0","unique":"0","pick_format_type":"single","pick_format_single":"radio","pick_format_multi":"checkbox","pick_taggable":"0","pick_limit":"0","pick_allow_html":"0","pick_user_role":[],"admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"pick_select_text":"","pick_table_id":"","pick_table_index":"","pick_display":"","pick_where":"","pick_orderby":"","pick_groupby":""},"blood_group":{"id":8,"name":"blood_group","label":"Blood Group","description":"","help":"","class":"","type":"pick","weight":4,"pick_object":"custom-simple","pick_val":"","sister_id":"","pick_custom":"A+\nA-\nB+\nB-\nAB+\nAB-\nO+\nO-","required":"0","unique":"0","pick_format_type":"single","pick_format_single":"dropdown","pick_format_multi":"checkbox","pick_taggable":"0","pick_limit":"0","pick_allow_html":"0","pick_user_role":[],"admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"pick_select_text":"","pick_table_id":"","pick_table_index":"","pick_display":"","pick_where":"","pick_orderby":"","pick_groupby":""},"date_of_joining":{"id":9,"name":"date_of_joining","label":"Date of Joining","description":"","help":"","class":"","type":"date","weight":5,"pick_object":"","pick_val":"","sister_id":"","required":"0","unique":"0","date_format":"mdy","date_allow_empty":"1","date_html5":"0","admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"date_repeatable":"0"},"department":{"id":10,"name":"department","label":"Department","description":"","help":"","class":"","type":"pick","weight":6,"pick_object":"custom-simple","pick_val":"","sister_id":"","required":"0","unique":"0","pick_format_type":"single","pick_format_single":"dropdown","pick_format_multi":"checkbox","pick_taggable":"0","pick_limit":"0","pick_allow_html":"0","pick_user_role":[],"admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"pick_custom":"HR\nIT","pick_select_text":"","pick_table_id":"","pick_table_index":"","pick_display":"","pick_where":"","pick_orderby":"","pick_groupby":""},"immediate_manager":{"id":11,"name":"immediate_manager","label":"Immediate Manager","description":"","help":"","class":"","type":"pick","weight":7,"pick_object":"user","pick_val":"","sister_id":"","required":"0","unique":"0","pick_format_type":"single","pick_format_single":"dropdown","pick_format_multi":"checkbox","pick_taggable":"0","pick_limit":"0","pick_allow_html":"0","pick_user_role":[],"admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"pick_select_text":"","pick_table_id":"","pick_table_index":"","pick_display":"","pick_where":"","pick_orderby":"","pick_groupby":""},"current_location":{"id":12,"name":"current_location","label":"Current Location","description":"","help":"","class":"","type":"pick","weight":8,"pick_object":"custom-simple","pick_val":"","sister_id":"","required":"0","unique":"0","pick_format_type":"single","pick_format_single":"dropdown","pick_format_multi":"checkbox","pick_taggable":"0","pick_limit":"0","pick_allow_html":"0","pick_user_role":[],"admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"pick_custom":"Gurgaon\nDubai","pick_select_text":"","pick_table_id":"","pick_table_index":"","pick_display":"","pick_where":"","pick_orderby":"","pick_groupby":""},"official_email":{"id":13,"name":"official_email","label":"Official Email","description":"","help":"","class":"","type":"email","weight":9,"pick_object":"","pick_val":"","sister_id":"","required":"0","unique":"0","email_max_length":"255","email_html5":"0","admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"email_repeatable":"0"},"personal_email":{"id":15,"name":"personal_email","label":"Personal Email","description":"","help":"","class":"","type":"email","weight":10,"pick_object":"","pick_val":"","sister_id":"","required":"0","unique":"0","email_max_length":"255","email_html5":"0","admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"email_repeatable":"0"},"avaya":{"id":16,"name":"avaya","label":"Avaya Ext","description":"Example: 684","help":"","class":"","type":"text","weight":11,"pick_object":"","pick_val":"","sister_id":"","required":"0","unique":"0","text_allow_shortcode":"0","text_allow_html":"0","text_allowed_html_tags":"strong em a ul ol li b i","text_max_length":"255","admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"text_repeatable":"0"},"mobile":{"id":17,"name":"mobile","label":"Mobile","description":"Example: 9888444666","help":"","class":"","type":"text","weight":12,"pick_object":"","pick_val":"","sister_id":"","required":"0","unique":"0","text_allow_shortcode":"0","text_allow_html":"0","text_allowed_html_tags":"strong em a ul ol li b i","text_max_length":"255","admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"text_repeatable":"0"},"permanent_phone_number":{"id":18,"name":"permanent_phone_number","label":"Permanent Phone Number","description":"","help":"","class":"","type":"phone","weight":13,"pick_object":"","pick_val":"","sister_id":"","required":"0","unique":"0","phone_format":"international","phone_enable_phone_extension":"0","phone_max_length":"25","phone_html5":"0","admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"phone_repeatable":"0"},"biometric_id":{"id":79,"name":"biometric_id","label":"Biometric ID","description":"Example:10 ","help":"","class":"","type":"number","weight":14,"pick_object":"","pick_val":"","sister_id":"","required":"0","unique":"0","number_format_type":"number","number_format":"i18n","number_decimals":"0","number_step":"1","number_min":"0","number_max":"100","number_max_length":"12","admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"number_repeatable":"0"},"bmi":{"id":111,"name":"bmi","label":"BMI","description":"Example: 18.5 - 25","help":"","class":"","type":"text","weight":15,"pick_object":"","pick_val":"","sister_id":"","required":"0","unique":"0","text_allow_shortcode":"0","text_allow_html":"0","text_allowed_html_tags":"strong em a ul ol li b i","text_max_length":"255","admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"text_repeatable":"0"},"height":{"id":114,"name":"height","label":"Height","description":"","help":"","class":"","type":"text","weight":16,"pick_object":"","pick_val":"","sister_id":"","required":"0","unique":"0","text_allow_shortcode":"0","text_allow_html":"0","text_allowed_html_tags":"strong em a ul ol li b i","text_max_length":"255","admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"text_repeatable":"0"},"weight":{"id":115,"name":"weight","label":"Weight","description":"","help":"","class":"","type":"text","weight":17,"pick_object":"","pick_val":"","sister_id":"","required":"0","unique":"0","text_allow_shortcode":"0","text_allow_html":"0","text_allowed_html_tags":"strong em a ul ol li b i","text_max_length":"255","admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"text_repeatable":"0"},"marital_status":{"id":220,"name":"marital_status","label":"Marital Status","description":"","help":"","class":"","type":"pick","weight":18,"pick_object":"custom-simple","pick_val":"","sister_id":"","pick_custom":"Single\nMarried","required":"0","unique":"0","pick_format_type":"single","pick_format_single":"dropdown","pick_format_multi":"checkbox","pick_taggable":"0","pick_limit":"0","pick_allow_html":"0","pick_user_role":[],"admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"pick_select_text":"","pick_table_id":"","pick_table_index":"","pick_display":"","pick_where":"","pick_orderby":"","pick_groupby":""},"anniversary":{"id":221,"name":"anniversary","label":"If Married, Anniversary","description":"DD\/MM\/YYYY","help":"","class":"","type":"date","weight":19,"pick_object":"","pick_val":"","sister_id":"","required":"0","unique":"0","date_format":"dmy","date_allow_empty":"1","date_html5":"0","admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"date_repeatable":"0"}},"show_in_menu":1}},"templates":{"user_detail":{"id":37,"name":"user_detail","code":"<?php\r\n\r\n$uid = $this->get_field('id');\r\n\r\n\r\n?>\r\n<div style=\"margin:10px;\">\r\n\t\r\n\t<div>\r\n\t\t<span style=\"float:left;margin-right:10px;border-radius:5px\"><?php echo  user_avatar_get_avatar($uid, 120); ?><\/span>\r\n\t\t<h1 class=\"entry-title\">{@display_name}<\/h1>\r\n\r\n\t\t<h4>{@current_location} - {@department} - {@designation} - <\/h4>\r\n\t\t{@employee_id} | <b>@{@user_login}<\/b> |  {@official_email} <b>{@user_email}<\/b> | <b>{@avaya}<\/b> \/ {@mobile}<br>  \r\n\t<\/div>\r\n<\/div>\t\r\n\r\n\r\n<hr>\r\n<br>\r\n<table>\r\n<tr><td>Reporting to<\/td><td>: <a href=\"\/users\/{@immediate_manager.user_login}\">{@immediate_manager} <\/a><\/td><\/tr>\r\n<tr><td>DOB   <\/td><td>: {@date_of_birth}<\/td><\/tr>\r\n<tr><td>Gender <\/td><td>: {@gender}<\/td><\/tr>\r\n<tr><td>Blood Group<\/td><td>: {@blood_group}<\/td><\/tr>\r\n<tr><td>Joining Date<\/td><td>: {@date_of_joining}<\/td><\/tr>\r\n<tr><td>Personal Email<\/td><td>: {@personal_email}<\/td><\/tr>\r\n<tr><td>Permanent Phone<\/td><td>: {@permanent_phone_number}<\/td><\/tr>\r\n<\/table>\r\n","type":"template","slug":"user_detail","options":{"_edit_lock":"1450767566:3","_edit_last":"3","admin_only":"","restrict_capability":"","capability_allowed":"","pod_reference":"a:1:{s:3:\"pod\";s:4:\"user\";}"}},"user_list":{"id":122,"name":"user_list","code":"<?php $uid = $this->get_field('id'); ?>\r\n<div style=\"margin:10px;\">\r\n\t<div>\r\n\t\t<div style=\"display:inline-block;width:20%;\">\r\n\t\t\t<span style=\"float:left;margin-right:10px;border-radius:5px;\"><?php echo  user_avatar_get_avatar($uid, 120); ?><\/span>\r\n\t\t<\/div>\r\n\t\t<div style=\"display:inline-block;width:79%; vertical-align: top;\">\t\r\n\t\t\t<h4 class=\"entry-title\" style=\"margin:0;font-size:24px\"><a href=\"\/users\/{@user_login}\">{@display_name}<\/a><\/h4>\r\n\t\t\t<h6 style=\"margin:0\">{@current_location} - {@department} - {@designation} <\/h6>\r\n\t\t\t {@official_email}  | <b>{@avaya}<\/b> \/ {@mobile} | BMI: {@bmi}<br>  \r\n\t\t<\/div>\t\r\n\t<\/div>\r\n<\/div>\r\n<hr>\r\n","type":"template","slug":"user_list","options":{"_edit_lock":"1450766517:3","_edit_last":"3","admin_only":"","restrict_capability":"","capability_allowed":"","pod_reference":"a:1:{s:3:\"pod\";s:0:\"\";}"}},"report_export":{"id":144,"name":"report_export","code":"<tr class=\"{@bmi,status}\">\r\n\t<td>{@employee_id}<\/td>\r\n\t<td>{@display_name}<\/td>\r\n\t<td>{@avaya}<\/td>\r\n\t<td>{@user_login}<\/td>\r\n\t<td>{@designation}<\/td>\r\n\t<td>{@department}<\/td>\r\n\t<td>{@official_email}<\/td>\r\n\t<td>{@mobile}<\/td>\r\n\t<td>{@immediate_manager}<\/td>\r\n\t<td>{@gender}<\/td>\r\n\t<td>{@blood_group}<\/td>\r\n\t<td>{@date_of_birth}<\/td>\r\n\t<td>{@date_of_joining}<\/td>\r\n\t<td>{@personal_email}<\/td>\r\n\t<td>{@permanent_phone_number}<\/td>\r\n\t<td>{@height}<\/td>\r\n\t<td>{@weight}<\/td>\r\n\t<td>{@biometric_id}<\/td>\r\n\t<td>{@bmi}<\/td>\r\n<\/tr>\r\n","type":"template","slug":"report_export","options":{"_edit_lock":"1450776407:3","_edit_last":"3","admin_only":"","restrict_capability":"","capability_allowed":"","_post_restored_from":"a:3:{s:20:\"restored_revision_id\";i:210;s:16:\"restored_by_user\";i:3;s:13:\"restored_time\";i:1450772398;}","pod_reference":"a:1:{s:3:\"pod\";s:0:\"\";}"}}},"pages":{"users\/*":{"id":34,"name":"users\/*","code":"<?php\r\n\r\n\/\/ Get the latest variable from Pods URL\r\n$id = pods_url_variable('last');\r\n\r\n\/\/ Define the params to find the Pods Item based on the $id\r\n$params = array( 'where' => 'user_login = \"'.$id.'\"', 'limit' => 1 );\r\n\r\n\/\/ Display it by using Pods Template\r\necho pods( 'user' )->find( $params )->template( 'user_detail' );\r\n\r\n?>","type":"page","slug":"users","options":{"_edit_lock":"1450767565:3","_edit_last":"3","page_title":"","precode":"","page_template":"_custom","pod":"user","pod_slug":"","admin_only":"","restrict_role":"","roles_allowed":"","restrict_capability":"","capability_allowed":"","restrict_redirect":"","restrict_redirect_login":"","restrict_redirect_url":""}},"reports":{"id":146,"name":"reports","code":"<?php\r\nfunction status($input){\t \t\r\n $input = (float) $input;\t \t\r\n if($input < 16.4){\t \t \r\n \treturn \"full-yellow\";\t \t \r\n }\r\n if($input < 18.5){\t \t \r\n \treturn \"yellow\";\t \t \r\n }\r\n if($input < 20.6){\t \r\n \treturn \"green-yellow\";\t \t \r\n }\r\n if($input < 22.7){\t \r\n \treturn \"green\";\t \t \r\n } \t\r\n if($input < 25){\t \r\n \treturn \"green-red\";\t \t \r\n }   \r\n if($input < 27.1){\t \r\n \treturn \"red\";\t \t \r\n }   \r\n return \"full-red\";\t \t \r\n};\r\n?>\r\n\r\n<table id=\"example\" class=\"display\" cellspacing=\"0\" width=\"100%\">\r\n\t<thead>\r\n    <tr>\r\n\t\r\n\t\t<th>EmpID<\/th>\r\n\t\t<th>Full Name<\/th>\r\n        <th>Avaya<\/th>\r\n\t\t<th>Username<\/th>\r\n\t\t<th>Designation<\/th>\r\n\t\t<th>Department<\/th>\r\n\t\t<th>Official Email<\/th>\r\n\t\t<th>Mobile<\/th>\r\n\t\t<th>Immidiate Manager<\/th>\r\n\t\t<th>Gender<\/th>\r\n\t\t<th>Blood<\/th>\r\n        <th>DOB<\/th>\r\n\t\t<th>Joining Date<\/th>\r\n\t\t<th>Personal Email<\/th>\r\n        <th>Personal Phone<\/th>\r\n        <th>Height<\/th>\r\n\t\t<th>Weight<\/th>\r\n        <th>Bio-ID<\/th>\r\n        <th>BMI<\/th>\r\n\t<\/tr>\r\n        <\/thead>\r\n     <tbody>\r\n    \r\n<?php\r\n\r\n\/\/ Define the params to find the Pods Item based on the $id\r\n$params = array(  'orderby' => ' biometric_id ASC', 'limit' => 100 );\r\n\r\n\/\/ Display it by using Pods Template\r\necho pods( 'user' )->find( $params )->template( 'report_export' );\r\n\r\n?>\r\n         <\/tbody>\r\n    <\/table>\r\n    \r\n    \r\n    \r\n    ","type":"page","slug":"reports","options":{"_edit_lock":"1450776869:3","_edit_last":"3","page_title":"Reports","precode":"<link href='https:\/\/fonts.googleapis.com\/css?family=Roboto:400,300italic,300' rel='stylesheet' type='text\/css'>\r\n<link href=\"https:\/\/cdn.datatables.net\/1.10.10\/css\/jquery.dataTables.min.css\" rel=\"stylesheet\">\r\n<script type='text\/javascript' src='http:\/\/easy.dokku.florahospitality.com\/wordpress\/wp-includes\/js\/jquery\/jquery.js?ver=1.11.3'><\/script>\r\n<script type='text\/javascript' src='http:\/\/easy.dokku.florahospitality.com\/wordpress\/wp-includes\/js\/jquery\/jquery-migrate.min.js?ver=1.2.1'><\/script>\r\n<script src=\"https:\/\/cdn.datatables.net\/1.10.10\/js\/jquery.dataTables.min.js\"><\/script>\r\n<script>\r\n    jQuery(document).ready(function() {\r\n    jQuery('#example').DataTable();\r\n} );\r\n<\/script>\r\n<style>\r\n    table {\r\n    \tfont-family:  'Roboto', sans-serif;\r\n    }\r\n    th{\r\n    \ttext-transform:uppercase;\r\n    }\r\n    tr.yellow {\r\n    \tbackground-color: #FDFDA1 !important;\r\n\t}\r\n    tr.red {\r\n    \tbackground-color: #BBF1BB !important\r\n\t}\r\n    tr.green {\r\n    \tbackground-color: #BBF1BB !important;\r\n\t}\r\n    tr.green-yellow {\r\n    \tbackground-color: #F9F9D3 !important;\r\n\t}\r\n    tr.green-red {\r\n    \tbackground-color: #F9E0E0 !important;\r\n\t}\r\n    tr.full-red {\r\n    \tbackground-color: #F37676 !important;\r\n\t}\r\n    tr.full-yellow {\r\n        background-color: #F7F75B !important;\r\n    }\r\n    \r\n    \r\n<\/style>","page_template":"_custom","pod":"user","pod_slug":"","admin_only":"","restrict_role":"","roles_allowed":"","restrict_capability":"","capability_allowed":"","restrict_redirect":"","restrict_redirect_login":"","restrict_redirect_url":""}}}}