API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 17th, 2020
262
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PostgreSQL 53.19 KB | None | 0 0
raw download clone embed print report
  1. create table attendance_summary
  2. (
  3.   id                                          serial                 not null
  4.     constraint attendance_summary_pk
  5.       primary key,
  6.   emp_id                                      integer                not null,
  7.   designation_id                              integer,
  8.   employment_type_id                          integer,
  9.   department_id                               integer,
  10.   office_id                                   integer                not null,
  11.   company_id                                  integer                not null,
  12.   shift_id                                    integer,
  13.   emp_name                                    varchar(100)           not null,
  14.   profile_picture_url                         varchar(200),
  15.   email                                       varchar(100)           not null,
  16.   gender                                      smallint default 0,
  17.   emp_office_id                               varchar(100),
  18.   office_admin                                boolean  default false not null,
  19.   company_admin                               boolean  default false not null,
  20.   include_in_att_report                       boolean  default true  not null,
  21.   allow_overtime                              boolean  default false not null,
  22.   report_position                             integer,
  23.   designation_name                            varchar(100),
  24.   employment_type_name                        varchar(100),
  25.   designation_hierarchy                       integer,
  26.   department_name                             varchar(100),
  27.   department_hierarchy                        integer,
  28.   office_name                                 varchar(100)           not null,
  29.   company_name                                varchar(100)           not null,
  30.   weekly_off_days                             varchar(7),
  31.   year_of_att                                 integer                not null,
  32.   month_of_att                                integer                not null,
  33.   date_of_att                                 integer                not null,
  34.   att_date_in_milliseconds                    bigint                 not null,
  35.   present                                     boolean  default false not null,
  36.   late                                        boolean  default false not null,
  37.   early_exit                                  boolean                not null,
  38.   on_leave                                    boolean  default false not null,
  39.   holiday                                     boolean  default false not null,
  40.   offday                                      boolean  default false not null,
  41.   total_hour_present_in_millis                bigint,
  42.   entry_time_in_millis                        bigint,
  43.   late_by_millis                              bigint,
  44.   exit_time_in_millis                         bigint,
  45.   overtime_hours_in_millis                    bigint,
  46.   shift_name                                  varchar(100)           not null,
  47.   shift_start_time                            varchar(50),
  48.   shift_start_time_of_this_day_in_millis      bigint,
  49.   shift_end_time                              varchar(50),
  50.   shift_end_time_of_this_day_in_millis        bigint,
  51.   expected_office_time_in_millis              bigint,
  52.   late_count_start_time                       varchar(50),
  53.   late_count_start_time_of_this_day_in_millis bigint,
  54.   early_count_end_time                        varchar(50),
  55.   early_count_end_time_of_this_day_in_millis  bigint,
  56.   shift_midnight_crossing                     boolean  default false,
  57.   emp_status                                  smallint               not null,
  58.   entry_manual                                boolean  default false,
  59.   exit_manual                                 boolean  default false,
  60.   emp_identifier                              varchar(191),
  61.   is_half_day                                 boolean  default false,
  62.   leave_half                                  integer,
  63.   shift_first_half_ends                       varchar(191),
  64.   shift_second_half_starts                    varchar(191),
  65.   first_half_ends_in_millis                   bigint,
  66.   second_half_starts_in_millis                bigint,
  67.   shift_disable_late                          boolean  default false,
  68.   manual_punch_type                           integer,
  69.   workplace_id                                integer,
  70.   workplace_name                              text,
  71.   approved_overtime_in_millis                 bigint,
  72.   shift_group_id                              integer,
  73.   shift_group_name                            varchar,
  74.   creation_date                               bigint,
  75.   update_date                                 bigint
  76. );
  77.  
  78. alter table attendance_summary
  79.   owner to root;
  80.  
  81. create index attendance_summary_allow_overtime_index
  82.   on attendance_summary (allow_overtime);
  83.  
  84. create index attendance_summary_att_date_in_milliseconds_index
  85.   on attendance_summary (att_date_in_milliseconds desc);
  86.  
  87. create index attendance_summary_company_id_index
  88.   on attendance_summary (company_id);
  89.  
  90. create index attendance_summary_department_id_index
  91.   on attendance_summary (department_id);
  92.  
  93. create index attendance_summary_designation_id_index
  94.   on attendance_summary (designation_id);
  95.  
  96. create unique index attendance_summary_emp_id_att_date_in_milliseconds_uindex
  97.   on attendance_summary (emp_id, att_date_in_milliseconds);
  98.  
  99. create index attendance_summary_emp_id_index
  100.   on attendance_summary (emp_id);
  101.  
  102. create index attendance_summary_emp_name_index
  103.   on attendance_summary (emp_name);
  104.  
  105. create index attendance_summary_emp_status_index
  106.   on attendance_summary (emp_status desc);
  107.  
  108. create index attendance_summary_employment_type_id_index
  109.   on attendance_summary (employment_type_id);
  110.  
  111. create unique index attendance_summary_id_uindex
  112.   on attendance_summary (id);
  113.  
  114. create index attendance_summary_office_id_index
  115.   on attendance_summary (office_id);
  116.  
  117. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5541947, 54365, 2639, 612, 1334, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, 'Software Developer', 'Full Time', 60, 'Software', 30, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 23, 1579716000000, false, false, false, false, false, false, 0, null, null, null, 0, 'Regular', '10:00 AM', 1579752000000, '07:00 PM', 1579784400000, 32400000, '10:15 AM', 1579752900000, '06:45 PM', 1579783500000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1579766400000, 1579770000000, false, null, 216, 'Center of Excellence', null, 353, 'Regular', 1579716120833, 1579716120833);
  118. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5328777, 54365, 2639, 612, 1334, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, 'Software Developer', 'Full Time', 60, 'Software', 30, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 22, 1579629600000, true, true, false, false, false, false, 31524000, 1579669295000, 2795000, 1579700819000, 0, 'Regular', '10:00 AM', 1579665600000, '07:00 PM', 1579698000000, 32400000, '10:15 AM', 1579666500000, '06:45 PM', 1579697100000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1579680000000, 1579683600000, false, null, 216, 'Center of Excellence', null, 353, 'Regular', 1579629753562, 1579700971589);
  119. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5269861, 54365, 2639, 612, 1334, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, 'Software Developer', 'Full Time', 60, 'Software', 30, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 21, 1579543200000, true, true, false, false, false, false, 25241000, 1579589323000, 9223000, 1579614564000, 0, 'Regular', '10:00 AM', 1579579200000, '07:00 PM', 1579611600000, 32400000, '10:15 AM', 1579580100000, '06:45 PM', 1579610700000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1579593600000, 1579597200000, false, null, 216, 'Center of Excellence', null, 353, 'Regular', 1579543321829, 1579614816542);
  120. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5251030, 54365, 2639, 612, 1334, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, 'Software Developer', 'Full Time', 60, 'Software', 30, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 20, 1579456800000, true, true, false, false, false, false, 31501000, 1579494741000, 1041000, 1579526242000, 0, 'Regular', '10:00 AM', 1579492800000, '07:00 PM', 1579525200000, 32400000, '10:15 AM', 1579493700000, '06:45 PM', 1579524300000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1579507200000, 1579510800000, false, null, 216, 'Center of Excellence', null, 353, 'Regular', 1579456924865, 1579526376559);
  121. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5232865, 54365, 2639, 612, 1334, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, 'Software Developer', 'Full Time', 60, 'Software', 30, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 19, 1579370400000, true, true, true, false, false, false, 26477000, 1579410613000, 3313000, 1579437090000, 0, 'Regular', '10:00 AM', 1579406400000, '07:00 PM', 1579438800000, 32400000, '10:15 AM', 1579407300000, '06:45 PM', 1579437900000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1579420800000, 1579424400000, false, null, 216, 'Center of Excellence', null, 353, 'Regular', 1579370530374, 1579512861798);
  122. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5214900, 54365, 2639, 612, 1334, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, 'Software Developer', 'Full Time', 60, 'Software', 30, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 18, 1579284000000, true, false, true, false, false, false, 30415000, 1579320648000, 0, 1579351063000, 0, 'Regular', '10:00 AM', 1579320000000, '07:00 PM', 1579352400000, 32400000, '10:15 AM', 1579320900000, '06:45 PM', 1579351500000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1579334400000, 1579338000000, false, null, 216, 'Center of Excellence', null, 353, 'Regular', 1579284129592, 1579512861798);
  123. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5199955, 54365, 2639, 612, 1334, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, 'Software Developer', 'Full Time', 60, 'Software', 30, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 17, 1579197600000, false, false, false, false, false, true, 0, null, null, null, 0, 'Regular', '10:00 AM', 1579233600000, '07:00 PM', 1579266000000, 32400000, '10:15 AM', 1579234500000, '06:45 PM', 1579265100000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1579248000000, 1579251600000, false, null, 216, 'Center of Excellence', null, 353, 'Regular', 1579197727008, 1579512861798);
  124. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5180593, 54365, 2639, 612, 1334, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, 'Software Developer', 'Full Time', 60, 'Software', 30, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 16, 1579111200000, true, true, false, false, false, false, 26323000, 1579157110000, 9010000, 1579183433000, 0, 'Regular', '10:00 AM', 1579147200000, '07:00 PM', 1579179600000, 32400000, '10:15 AM', 1579148100000, '06:45 PM', 1579178700000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1579161600000, 1579165200000, false, null, 216, 'Center of Excellence', null, 353, 'Regular', 1579111314919, 1579512861798);
  125. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5158687, 54365, 2639, 612, 1334, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, 'Software Developer', 'Full Time', 60, 'Software', 30, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 15, 1579024800000, true, true, false, false, false, false, 27468000, 1579066895000, 5195000, 1579094363000, 0, 'Regular', '10:00 AM', 1579060800000, '07:00 PM', 1579093200000, 32400000, '10:15 AM', 1579061700000, '06:45 PM', 1579092300000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1579075200000, 1579078800000, false, null, 216, 'Center of Excellence', null, 353, 'Regular', 1579024918940, 1579512861798);
  126. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5137013, 54365, 2639, 612, 1334, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, 'Software Developer', 'Full Time', 60, 'Software', 30, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 14, 1578938400000, true, true, false, false, false, false, 27059000, 1578980193000, 4893000, 1579007252000, 0, 'Regular', '10:00 AM', 1578974400000, '07:00 PM', 1579006800000, 32400000, '10:15 AM', 1578975300000, '06:45 PM', 1579005900000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1578988800000, 1578992400000, false, null, 216, 'Center of Excellence', null, 353, 'Regular', 1578938509550, 1579512861798);
  127. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5119375, 54365, 2639, 612, 1334, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, 'Software Developer', 'Full Time', 60, 'Software', 30, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 13, 1578852000000, true, true, true, false, false, false, 25666000, 1578892918000, 4018000, 1578918584000, 0, 'Regular', '10:00 AM', 1578888000000, '07:00 PM', 1578920400000, 32400000, '10:15 AM', 1578888900000, '06:45 PM', 1578919500000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1578902400000, 1578906000000, false, null, 216, 'Center of Excellence', null, 353, 'Regular', 1578852082636, 1579512861798);
  128. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5100743, 54365, 2639, 612, 1334, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, 'Software Developer', 'Full Time', 60, 'Software', 30, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 12, 1578765600000, true, true, true, false, false, false, 9292000, 1578811822000, 9322000, 1578821114000, 0, 'Regular', '10:00 AM', 1578801600000, '07:00 PM', 1578834000000, 32400000, '10:15 AM', 1578802500000, '06:45 PM', 1578833100000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1578816000000, 1578819600000, false, null, 216, 'Center of Excellence', null, 353, 'Regular', 1578765733826, 1579512861798);
  129. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5081211, 54365, null, null, 1334, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, null, null, null, 'Software', 30, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 11, 1578679200000, true, false, true, false, false, false, 30254000, 1578715764000, 0, 1578746018000, 0, 'Regular', '10:00 AM', 1578715200000, '07:00 PM', 1578747600000, 32400000, '10:15 AM', 1578716100000, '06:45 PM', 1578746700000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1578729600000, 1578733200000, false, null, null, null, null, 353, 'Regular', 1578679324916, 1579512861798);
  130. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5066632, 54365, null, null, 1334, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, null, null, null, 'Software', 30, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 10, 1578592800000, false, false, false, false, false, true, 0, null, null, null, 0, 'Regular', '10:00 AM', 1578628800000, '07:00 PM', 1578661200000, 32400000, '10:15 AM', 1578629700000, '06:45 PM', 1578660300000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1578643200000, 1578646800000, false, null, null, null, null, 353, 'Regular', 1578592914012, 1579512861798);
  131. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5046288, 54365, null, null, null, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, null, null, null, null, null, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 1, 1577815200000, true, true, true, false, false, false, 21908000, 1577857570000, 5470000, 1577879478000, 0, 'Regular', '10:00 AM', 1577851200000, '07:00 PM', 1577883600000, 32400000, '10:15 AM', 1577852100000, '06:45 PM', 1577882700000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1577865600000, 1577869200000, false, null, null, null, null, 353, 'Regular', 1578554751468, 1579512861798);
  132. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5046221, 54365, null, null, null, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, null, null, null, null, null, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 2, 1577901600000, true, true, true, false, false, false, 19796000, 1577941855000, 3355000, 1577961651000, 0, 'Regular', '10:00 AM', 1577937600000, '07:00 PM', 1577970000000, 32400000, '10:15 AM', 1577938500000, '06:45 PM', 1577969100000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1577952000000, 1577955600000, false, null, null, null, null, 353, 'Regular', 1578554751394, 1579512861798);
  133. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5046154, 54365, null, null, null, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, null, null, null, null, null, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 3, 1577988000000, false, false, false, false, false, true, 0, null, null, null, 0, 'Regular', '10:00 AM', 1578024000000, '07:00 PM', 1578056400000, 32400000, '10:15 AM', 1578024900000, '06:45 PM', 1578055500000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1578038400000, 1578042000000, false, null, null, null, null, 353, 'Regular', 1578554751322, 1579512861798);
  134. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5046087, 54365, null, null, null, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, null, null, null, null, null, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 4, 1578074400000, false, false, false, false, true, false, 0, null, null, null, 0, 'Regular', '10:00 AM', 1578110400000, '07:00 PM', 1578142800000, 32400000, '10:15 AM', 1578111300000, '06:45 PM', 1578141900000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1578124800000, 1578128400000, false, null, null, null, null, 353, 'Regular', 1578554751251, 1579512861798);
  135. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5046020, 54365, null, null, null, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, null, null, null, null, null, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 5, 1578160800000, false, false, false, false, true, false, 0, null, null, null, 0, 'Regular', '10:00 AM', 1578196800000, '07:00 PM', 1578229200000, 32400000, '10:15 AM', 1578197700000, '06:45 PM', 1578228300000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1578211200000, 1578214800000, false, null, null, null, null, 353, 'Regular', 1578554751176, 1579512861798);
  136. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5045953, 54365, null, null, null, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, null, null, null, null, null, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 6, 1578247200000, false, false, false, false, false, false, 0, null, null, null, 0, 'Regular', '10:00 AM', 1578283200000, '07:00 PM', 1578315600000, 32400000, '10:15 AM', 1578284100000, '06:45 PM', 1578314700000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1578297600000, 1578301200000, false, null, null, null, null, 353, 'Regular', 1578554751103, 1579512861798);
  137. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5045886, 54365, null, null, null, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, null, null, null, null, null, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 7, 1578333600000, false, false, false, false, false, false, 0, null, null, null, 0, 'Regular', '10:00 AM', 1578369600000, '07:00 PM', 1578402000000, 32400000, '10:15 AM', 1578370500000, '06:45 PM', 1578401100000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1578384000000, 1578387600000, false, null, null, null, null, 353, 'Regular', 1578554751032, 1579512861798);
  138. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5045819, 54365, null, null, null, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, null, null, null, null, null, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 8, 1578420000000, false, false, false, false, false, false, 0, null, null, null, 0, 'Regular', '10:00 AM', 1578456000000, '07:00 PM', 1578488400000, 32400000, '10:15 AM', 1578456900000, '06:45 PM', 1578487500000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1578470400000, 1578474000000, false, null, null, null, null, 353, 'Regular', 1578554750938, 1579512861798);
  139. INSERT INTO public.attendance_summary (id, emp_id, designation_id, employment_type_id, department_id, office_id, company_id, shift_id, emp_name, profile_picture_url, email, gender, emp_office_id, office_admin, company_admin, include_in_att_report, allow_overtime, report_position, designation_name, employment_type_name, designation_hierarchy, department_name, department_hierarchy, office_name, company_name, weekly_off_days, year_of_att, month_of_att, date_of_att, att_date_in_milliseconds, present, late, early_exit, on_leave, holiday, offday, total_hour_present_in_millis, entry_time_in_millis, late_by_millis, exit_time_in_millis, overtime_hours_in_millis, shift_name, shift_start_time, shift_start_time_of_this_day_in_millis, shift_end_time, shift_end_time_of_this_day_in_millis, expected_office_time_in_millis, late_count_start_time, late_count_start_time_of_this_day_in_millis, early_count_end_time, early_count_end_time_of_this_day_in_millis, shift_midnight_crossing, emp_status, entry_manual, exit_manual, emp_identifier, is_half_day, leave_half, shift_first_half_ends, shift_second_half_starts, first_half_ends_in_millis, second_half_starts_in_millis, shift_disable_late, manual_punch_type, workplace_id, workplace_name, approved_overtime_in_millis, shift_group_id, shift_group_name, creation_date, update_date) VALUES (5045752, 54365, null, null, null, 279, 1, 301, 'Mainul Islam Mahi', 'https://inovace-client-dev.s3-ap-southeast-1.amazonaws.com/profilepic-MainulIslamMahi-1579512861483', 'mahi.inovace@gmail.com', 1, '1', false, false, true, false, 1, null, null, null, null, null, 'Inovace Technologies', 'Inovace Technology', null, 2020, 1, 9, 1578506400000, false, false, false, false, false, false, 0, null, null, null, 0, 'Regular', '10:00 AM', 1578542400000, '07:00 PM', 1578574800000, 32400000, '10:15 AM', 1578543300000, '06:45 PM', 1578573900000, false, 1, false, false, 'Mainul Islam Mahi-00051153', false, null, '02:00 PM', '03:00 PM', 1578556800000, 1578560400000, false, null, null, null, null, 353, 'Regular', 1578554750659, 1579512861798);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!