API tools faq
paste
Advertisement
badlogic

Payroll Migration Exploit

badlogic
Oct 25th, 2016
337
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 30.35 KB | None | 0 0
raw download clone embed print report
  1. INSERT INTO `payroll_deduction_header` (`dduct_id`, `psa_id`, `dduct_comp`, `dduct_status`, `dduct_type`, `dduct_name`, `cal_id`, `dduct_addwho`, `dduct_addwhen`, `dduct_updatedwho`, `dduct_updatedwhen`, `dduct_isnominal`) VALUES
  2. (1, 4,  0,  1,  2,  'W/H Tax (Monthly)',    4,  '99-006',   '2016-10-18 15:38:15',  '', '0000-00-00 00:00:00',  20),
  3. (2, 1,  0,  1,  3,  'SSS (Monthly)',    4,  '99-006',   '2016-10-18 15:40:14',  '', '0000-00-00 00:00:00',  20),
  4. (3, 2,  0,  1,  4,  'PhilHealth (Monthly)', 4,  '99-006',   '2016-10-19 09:00:07',  '99-006',   '2016-10-19 11:29:40',  20),
  5. (4, 3,  0,  1,  5,  'Pag-ibig Fixed 100',   4,  '99-006',   '2016-10-19 11:31:07',  '99-006',   '2016-10-19 01:59:31',  20);
  6.  
  7. INSERT INTO `payroll_ps_account` (`psa_id`, `psa_company_id`, `psa_status`, `psa_type`, `psa_order`, `psa_name`, `psa_accrual`, `psa_debit_accnt`, `psa_credit_accnt`, `psa_addwho`, `psa_addwhen`, `psa_updatedwho`, `psa_updatedwhen`) VALUES
  8. (1, 0,  1,  2,  1,  'SSS',  0,  '', '', 'sysad',    '2016-10-18 14:57:17',  NULL,   NULL),
  9. (2, 0,  1,  2,  2,  'PhilHealth',   0,  '', '', '99-006',   '2016-10-18 15:35:48',  NULL,   NULL),
  10. (3, 0,  1,  2,  3,  'Pag-ibig', 0,  '', '', '99-006',   '2016-10-18 15:36:17',  NULL,   NULL),
  11. (4, 0,  1,  2,  4,  'W/H Tax',  0,  '', '', '99-006',   '2016-10-18 15:36:57',  'sysad',    '2016-10-20 10:04:03');
  12.  
  13. INSERT INTO `payroll_deduction_detail` (`dd_id`, `dduct_id`, `tax_ex_id`, `dd_exemption`, `dd_percent_excess`, `dd_tax`, `dd_wagefrom`, `dd_wageto`, `dd_addwho`, `dd_addwhen`, `dd_updatewho`, `dd_updatewhen`, `dd_phic_sss_monthlysalary`, `dd_phic_sss_er`, `dd_phic_sss_ee`, `dd_phic_sss_totalcont`, `dd_phic_sss_ec`) VALUES
  14. (1, 2,  NULL,   NULL,   NULL,   NULL,   1000.00,    1249.99,    '99-006',   '2016-10-18 15:42:02',  NULL,   NULL,   1000.00,    73.70,  36.30,  110.00, 10.00),
  15. (2, 2,  NULL,   NULL,   NULL,   NULL,   1250.00,    1749.99,    '99-006',   '2016-10-18 15:43:09',  NULL,   NULL,   1500.00,    110.50, 54.50,  165.00, 10.00),
  16. (3, 2,  NULL,   NULL,   NULL,   NULL,   1750.00,    2249.99,    '99-006',   '2016-10-18 15:44:15',  NULL,   NULL,   2000.00,    147.30, 72.70,  220.00, 10.00),
  17. (4, 2,  NULL,   NULL,   NULL,   NULL,   2250.00,    2749.99,    '99-006',   '2016-10-18 15:45:26',  NULL,   NULL,   2500.00,    184.20, 90.80,  275.00, 10.00),
  18. (5, 2,  NULL,   NULL,   NULL,   NULL,   2750.00,    3249.99,    '99-006',   '2016-10-18 16:35:38',  NULL,   NULL,   3000.00,    221.00, 109.00, 330.00, 10.00),
  19. (6, 2,  NULL,   NULL,   NULL,   NULL,   3250.00,    3749.99,    '99-006',   '2016-10-18 16:36:32',  NULL,   NULL,   3500.00,    257.80, 127.20, 385.00, 10.00),
  20. (7, 2,  NULL,   NULL,   NULL,   NULL,   3750.00,    4249.99,    '99-006',   '2016-10-18 16:37:23',  NULL,   NULL,   4000.00,    294.70, 145.30, 440.00, 10.00),
  21. (8, 2,  NULL,   NULL,   NULL,   NULL,   4250.00,    4749.99,    '99-006',   '2016-10-18 16:41:53',  NULL,   NULL,   4500.00,    331.50, 163.50, 495.00, 10.00),
  22. (9, 2,  NULL,   NULL,   NULL,   NULL,   4750.00,    5249.99,    '99-006',   '2016-10-18 16:42:48',  NULL,   NULL,   5000.00,    368.30, 181.70, 550.00, 10.00),
  23. (10,    2,  NULL,   NULL,   NULL,   NULL,   5250.00,    5749.99,    '99-006',   '2016-10-18 16:43:52',  NULL,   NULL,   5500.00,    405.20, 199.80, 605.00, 10.00),
  24. (11,    2,  NULL,   NULL,   NULL,   NULL,   5750.00,    6249.99,    '99-006',   '2016-10-18 16:44:40',  NULL,   NULL,   6000.00,    442.00, 218.00, 660.00, 10.00),
  25. (12,    2,  NULL,   NULL,   NULL,   NULL,   6250.00,    6749.99,    '99-006',   '2016-10-18 16:45:33',  NULL,   NULL,   6500.00,    478.80, 236.20, 715.00, 10.00),
  26. (13,    2,  NULL,   NULL,   NULL,   NULL,   6750.00,    7249.99,    '99-006',   '2016-10-18 16:46:17',  NULL,   NULL,   7000.00,    515.70, 254.30, 770.00, 10.00),
  27. (14,    2,  NULL,   NULL,   NULL,   NULL,   7250.00,    7749.99,    '99-006',   '2016-10-18 16:47:04',  NULL,   NULL,   7500.00,    552.50, 272.50, 825.00, 10.00),
  28. (15,    2,  NULL,   NULL,   NULL,   NULL,   7750.00,    8249.99,    '99-006',   '2016-10-18 17:29:54',  NULL,   NULL,   8000.00,    589.30, 290.70, 880.00, 10.00),
  29. (16,    2,  NULL,   NULL,   NULL,   NULL,   8250.00,    8749.99,    '99-006',   '2016-10-18 17:30:40',  NULL,   NULL,   8500.00,    626.20, 308.80, 935.00, 10.00),
  30. (17,    2,  NULL,   NULL,   NULL,   NULL,   8750.00,    9249.99,    '99-006',   '2016-10-18 17:31:21',  NULL,   NULL,   9000.00,    663.00, 327.00, 990.00, 10.00),
  31. (18,    2,  NULL,   NULL,   NULL,   NULL,   9250.00,    9749.99,    '99-006',   '2016-10-18 17:32:11',  NULL,   NULL,   9500.00,    699.80, 345.20, 1045.00,    10.00),
  32. (19,    2,  NULL,   NULL,   NULL,   NULL,   9750.00,    10249.99,   '99-006',   '2016-10-18 17:33:20',  NULL,   NULL,   10000.00,   736.70, 363.30, 1100.00,    10.00),
  33. (20,    2,  NULL,   NULL,   NULL,   NULL,   10250.00,   10749.99,   '99-006',   '2016-10-18 17:34:19',  NULL,   NULL,   10500.00,   773.50, 381.50, 1155.00,    10.00),
  34. (21,    2,  NULL,   NULL,   NULL,   NULL,   10750.00,   11249.99,   '99-006',   '2016-10-18 17:35:09',  NULL,   NULL,   11000.00,   810.30, 399.70, 1210.00,    10.00),
  35. (22,    2,  NULL,   NULL,   NULL,   NULL,   11250.00,   11749.99,   '99-006',   '2016-10-18 17:36:10',  NULL,   NULL,   11500.00,   847.20, 417.80, 1265.00,    10.00),
  36. (23,    2,  NULL,   NULL,   NULL,   NULL,   11750.00,   12249.99,   '99-006',   '2016-10-18 17:37:22',  NULL,   NULL,   12000.00,   884.00, 436.00, 1320.00,    10.00),
  37. (24,    2,  NULL,   NULL,   NULL,   NULL,   12250.00,   12749.99,   '99-006',   '2016-10-18 17:38:25',  NULL,   NULL,   12500.00,   920.80, 454.20, 1375.00,    10.00),
  38. (25,    2,  NULL,   NULL,   NULL,   NULL,   12750.00,   13249.99,   '99-006',   '2016-10-18 17:39:39',  NULL,   NULL,   13000.00,   957.70, 472.30, 1430.00,    10.00),
  39. (26,    2,  NULL,   NULL,   NULL,   NULL,   13250.00,   13749.99,   '99-006',   '2016-10-18 17:41:23',  NULL,   NULL,   13500.00,   994.50, 490.50, 1485.00,    10.00),
  40. (27,    2,  NULL,   NULL,   NULL,   NULL,   13750.00,   14249.99,   '99-006',   '2016-10-18 17:43:07',  NULL,   NULL,   14000.00,   1031.30,    508.70, 1540.00,    10.00),
  41. (28,    2,  NULL,   NULL,   NULL,   NULL,   14250.00,   14749.99,   '99-006',   '2016-10-18 17:44:38',  NULL,   NULL,   14500.00,   1068.20,    526.80, 1595.00,    10.00),
  42. (29,    2,  NULL,   NULL,   NULL,   NULL,   14750.00,   15249.99,   '99-006',   '2016-10-18 17:47:14',  NULL,   NULL,   15000.00,   1105.00,    545.00, 1650.00,    30.00),
  43. (32,    2,  NULL,   NULL,   NULL,   NULL,   15250.00,   15749.99,   '99-006',   '2016-10-18 17:51:18',  NULL,   NULL,   15500.00,   1141.80,    563.20, 1705.00,    30.00),
  44. (31,    2,  NULL,   NULL,   NULL,   NULL,   15750.00,   0.00,   '99-006',   '2016-10-18 17:50:27',  NULL,   NULL,   16000.00,   1178.70,    581.30, 1760.00,    30.00),
  45. (53,    3,  NULL,   NULL,   NULL,   NULL,   9000.00,    9999.99,    '99-006',   '2016-10-19 10:26:18',  NULL,   NULL,   9000.00,    112.50, 112.50, 225.00, NULL),
  46. (52,    3,  NULL,   NULL,   NULL,   NULL,   1.00,   8999.99,    '99-006',   '2016-10-19 10:25:15',  NULL,   NULL,   8000.00,    100.00, 100.00, 200.00, NULL),
  47. (54,    3,  NULL,   NULL,   NULL,   NULL,   10000.00,   10999.99,   '99-006',   '2016-10-19 10:27:02',  NULL,   NULL,   10000.00,   125.00, 125.00, 250.00, NULL),
  48. (55,    3,  NULL,   NULL,   NULL,   NULL,   11000.00,   11999.99,   '99-006',   '2016-10-19 10:27:48',  NULL,   NULL,   11000.00,   137.50, 137.50, 275.00, NULL),
  49. (38,    1,  3,  0.00,   0.00,   0.00,   0.00,   0.99,   '99-006',   '2016-10-19 09:49:02',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  50. (58,    3,  NULL,   NULL,   NULL,   NULL,   14000.00,   14999.99,   '99-006',   '2016-10-19 10:30:17',  NULL,   NULL,   14000.00,   175.00, 175.00, 350.00, NULL),
  51. (56,    3,  NULL,   NULL,   NULL,   NULL,   12000.00,   12999.99,   '99-006',   '2016-10-19 10:29:04',  NULL,   NULL,   12000.00,   150.00, 150.00, 300.00, NULL),
  52. (57,    3,  NULL,   NULL,   NULL,   NULL,   13000.00,   13999.99,   '99-006',   '2016-10-19 10:29:40',  NULL,   NULL,   13000.00,   162.50, 162.50, 325.00, NULL),
  53. (59,    3,  NULL,   NULL,   NULL,   NULL,   15000.00,   15999.99,   '99-006',   '2016-10-19 11:04:57',  NULL,   NULL,   15000.00,   187.50, 187.50, 375.00, NULL),
  54. (60,    3,  NULL,   NULL,   NULL,   NULL,   16000.00,   16999.99,   '99-006',   '2016-10-19 11:05:38',  NULL,   NULL,   16000.00,   200.00, 200.00, 400.00, NULL),
  55. (61,    3,  NULL,   NULL,   NULL,   NULL,   17000.00,   17999.99,   '99-006',   '2016-10-19 11:06:15',  NULL,   NULL,   17000.00,   212.50, 212.50, 425.00, NULL),
  56. (62,    3,  NULL,   NULL,   NULL,   NULL,   18000.00,   18999.99,   '99-006',   '2016-10-19 11:08:06',  NULL,   NULL,   18000.00,   225.00, 225.00, 450.00, NULL),
  57. (63,    3,  NULL,   NULL,   NULL,   NULL,   19000.00,   19999.99,   '99-006',   '2016-10-19 11:09:16',  NULL,   NULL,   19000.00,   237.50, 237.50, 475.00, NULL),
  58. (64,    3,  NULL,   NULL,   NULL,   NULL,   20000.00,   20999.99,   '99-006',   '2016-10-19 11:11:56',  NULL,   NULL,   20000.00,   250.00, 250.00, 500.00, NULL),
  59. (65,    3,  NULL,   NULL,   NULL,   NULL,   21000.00,   21999.99,   '99-006',   '2016-10-19 11:12:49',  NULL,   NULL,   21000.00,   262.50, 262.50, 525.00, NULL),
  60. (66,    3,  NULL,   NULL,   NULL,   NULL,   22000.00,   22999.99,   '99-006',   '2016-10-19 11:15:29',  NULL,   NULL,   22000.00,   275.00, 275.00, 550.00, NULL),
  61. (67,    3,  NULL,   NULL,   NULL,   NULL,   23000.00,   23999.99,   '99-006',   '2016-10-19 11:16:41',  NULL,   NULL,   23000.00,   287.50, 287.50, 575.00, NULL),
  62. (68,    3,  NULL,   NULL,   NULL,   NULL,   24000.00,   24999.99,   '99-006',   '2016-10-19 11:17:25',  NULL,   NULL,   24000.00,   300.00, 300.00, 600.00, NULL),
  63. (69,    3,  NULL,   NULL,   NULL,   NULL,   25000.00,   25999.99,   '99-006',   '2016-10-19 11:18:15',  NULL,   NULL,   25000.00,   312.50, 312.50, 625.00, NULL),
  64. (70,    3,  NULL,   NULL,   NULL,   NULL,   26000.00,   26999.99,   '99-006',   '2016-10-19 11:19:13',  NULL,   NULL,   26000.00,   325.00, 325.00, 650.00, NULL),
  65. (71,    3,  NULL,   NULL,   NULL,   NULL,   27000.00,   27999.99,   '99-006',   '2016-10-19 11:19:54',  NULL,   NULL,   27000.00,   337.50, 337.50, 675.00, NULL),
  66. (72,    3,  NULL,   NULL,   NULL,   NULL,   28000.00,   28999.99,   '99-006',   '2016-10-19 11:20:48',  NULL,   NULL,   28000.00,   350.00, 350.00, 700.00, NULL),
  67. (73,    3,  NULL,   NULL,   NULL,   NULL,   29000.00,   29999.99,   '99-006',   '2016-10-19 11:21:53',  NULL,   NULL,   29000.00,   362.50, 362.50, 725.00, NULL),
  68. (74,    3,  NULL,   NULL,   NULL,   NULL,   30000.00,   30999.99,   '99-006',   '2016-10-19 11:22:34',  NULL,   NULL,   30000.00,   375.00, 375.00, 750.00, NULL),
  69. (75,    3,  NULL,   NULL,   NULL,   NULL,   31000.00,   31999.99,   '99-006',   '2016-10-19 11:23:42',  NULL,   NULL,   31000.00,   387.50, 387.50, 775.00, NULL),
  70. (76,    3,  NULL,   NULL,   NULL,   NULL,   32000.00,   32999.99,   '99-006',   '2016-10-19 11:26:20',  NULL,   NULL,   32000.00,   400.00, 400.00, 800.00, NULL),
  71. (77,    3,  NULL,   NULL,   NULL,   NULL,   33000.00,   33999.99,   '99-006',   '2016-10-19 11:27:17',  NULL,   NULL,   33000.00,   412.50, 412.50, 825.00, NULL),
  72. (78,    3,  NULL,   NULL,   NULL,   NULL,   34000.00,   34999.99,   '99-006',   '2016-10-19 11:28:03',  NULL,   NULL,   34000.00,   425.00, 425.00, 850.00, NULL),
  73. (79,    3,  NULL,   NULL,   NULL,   NULL,   35000.00,   0.00,   '99-006',   '2016-10-19 11:29:18',  NULL,   NULL,   35000.00,   437.50, 437.50, 875.00, NULL),
  74. (90,    1,  3,  0.00,   15.00,  208.33, 2500.00,    5832.99,    '99-006',   '2016-10-19 14:04:06',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  75. (89,    1,  3,  0.00,   10.00,  41.67,  833.00, 2499.99,    '99-006',   '2016-10-19 14:03:10',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  76. (149,   4,  NULL,   NULL,   NULL,   NULL,   10000.00,   0.00,   '99-006',   '2016-10-20 15:34:21',  NULL,   NULL,   0.00,   100.00, 100.00, NULL,   NULL),
  77. (88,    1,  3,  0.00,   5.00,   0.00,   1.00,   832.99, '99-006',   '2016-10-19 14:02:02',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  78. (91,    1,  3,  0.00,   20.00,  708.33, 5833.00,    11666.99,   '99-006',   '2016-10-19 14:05:00',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  79. (92,    1,  3,  0.00,   25.00,  1875.00,    11667.00,   20832.99,   '99-006',   '2016-10-19 14:06:55',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  80. (93,    1,  3,  0.00,   30.00,  4166.67,    20833.00,   41666.99,   '99-006',   '2016-10-19 14:07:54',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  81. (94,    1,  3,  0.00,   32.00,  10416.67,   41667.00,   0.00,   '99-006',   '2016-10-19 14:08:57',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  82. (106,   1,  4,  50.00,  0.00,   0.00,   0.00,   4166.99,    '99-006',   '2016-10-19 14:41:47',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  83. (107,   1,  4,  50.00,  5.00,   0.00,   4167.00,    4999.99,    '99-006',   '2016-10-19 14:46:48',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  84. (108,   1,  4,  50.00,  10.00,  41.67,  5000.00,    6666.99,    '99-006',   '2016-10-19 14:47:38',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  85. (109,   1,  4,  50.00,  15.00,  208.33, 6667.00,    9999.99,    '99-006',   '2016-10-19 14:48:17',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  86. (110,   1,  4,  50.00,  20.00,  708.33, 10000.00,   15832.99,   '99-006',   '2016-10-19 14:48:56',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  87. (111,   1,  4,  50.00,  25.00,  1875.00,    15833.00,   24999.99,   '99-006',   '2016-10-19 14:49:33',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  88. (113,   1,  4,  50.00,  30.00,  4166.67,    25000.00,   45832.99,   '99-006',   '2016-10-19 14:52:50',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  89. (114,   1,  4,  50.00,  32.00,  10416.67,   45833.00,   0.00,   '99-006',   '2016-10-19 14:53:50',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  90. (116,   1,  1,  75.00,  0.00,   0.00,   0.00,   6249.99,    '99-006',   '2016-10-19 15:14:19',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  91. (117,   1,  1,  75.00,  5.00,   0.00,   6250.00,    7082.99,    '99-006',   '2016-10-19 15:15:03',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  92. (118,   1,  1,  75.00,  10.00,  41.67,  7083.00,    8749.99,    '99-006',   '2016-10-19 15:16:01',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  93. (119,   1,  1,  75.00,  15.00,  208.33, 8750.00,    12082.99,   '99-006',   '2016-10-19 15:17:32',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  94. (120,   1,  1,  75.00,  20.00,  708.33, 12083.00,   17916.99,   '99-006',   '2016-10-19 15:18:42',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  95. (121,   1,  1,  75.00,  25.00,  1875.00,    17917.00,   27082.99,   '99-006',   '2016-10-19 15:19:52',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  96. (122,   1,  1,  75.00,  30.00,  4166.67,    27083.00,   47916.99,   '99-006',   '2016-10-19 15:21:08',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  97. (123,   1,  1,  75.00,  32.00,  10416.67,   47917.00,   0.00,   '99-006',   '2016-10-19 15:22:33',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  98. (124,   1,  2,  100.00, 0.00,   0.00,   1.00,   8332.99,    '99-006',   '2016-10-19 15:28:33',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  99. (125,   1,  2,  100.00, 5.00,   0.00,   8333.00,    9166.99,    '99-006',   '2016-10-19 15:33:27',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  100. (126,   1,  2,  100.00, 10.00,  41.67,  9167.00,    10832.99,   '99-006',   '2016-10-19 15:34:22',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  101. (127,   1,  2,  100.00, 15.00,  208.33, 10833.00,   14166.99,   '99-006',   '2016-10-19 15:35:22',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  102. (128,   1,  2,  100.00, 20.00,  708.33, 14167.00,   19999.99,   '99-006',   '2016-10-19 15:37:02',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  103. (129,   1,  2,  100.00, 25.00,  1875.00,    20000.00,   29166.99,   '99-006',   '2016-10-19 15:37:57',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  104. (130,   1,  2,  100.00, 30.00,  4166.67,    29167.00,   49999.99,   '99-006',   '2016-10-19 15:39:19',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  105. (131,   1,  2,  100.00, 32.00,  10416.67,   50000.00,   0.00,   '99-006',   '2016-10-19 15:43:41',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  106. (132,   1,  5,  125.00, 0.00,   0.00,   1.00,   10416.99,   '99-006',   '2016-10-19 15:47:26',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  107. (133,   1,  5,  125.00, 5.00,   0.00,   10417.00,   11249.99,   '99-006',   '2016-10-19 15:48:16',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  108. (134,   1,  5,  125.00, 10.00,  41.67,  11250.00,   12916.99,   '99-006',   '2016-10-19 15:50:09',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  109. (135,   1,  5,  125.00, 15.00,  208.33, 12917.00,   16249.99,   '99-006',   '2016-10-19 15:50:52',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  110. (136,   1,  5,  125.00, 20.00,  708.33, 16250.00,   22082.99,   '99-006',   '2016-10-19 15:51:53',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  111. (137,   1,  5,  125.00, 25.00,  1875.00,    22083.00,   31249.99,   '99-006',   '2016-10-19 15:52:38',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  112. (138,   1,  5,  125.00, 30.00,  4166.67,    31250.00,   52082.99,   '99-006',   '2016-10-19 15:53:29',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  113. (139,   1,  5,  125.00, 32.00,  10416.67,   52083.00,   0.00,   '99-006',   '2016-10-19 15:54:27',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  114. (140,   1,  6,  150.00, 0.00,   0.00,   1.00,   12499.99,   '99-006',   '2016-10-19 15:55:47',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  115. (141,   1,  6,  150.00, 5.00,   0.00,   12500.00,   13332.99,   '99-006',   '2016-10-19 15:57:04',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  116. (142,   1,  6,  150.00, 10.00,  41.67,  13333.00,   14999.99,   '99-006',   '2016-10-19 15:58:04',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  117. (143,   1,  6,  150.00, 15.00,  208.33, 15000.00,   18332.00,   '99-006',   '2016-10-19 15:58:44',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  118. (144,   1,  6,  150.00, 20.00,  708.33, 18333.00,   24166.99,   '99-006',   '2016-10-19 15:59:39',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  119. (145,   1,  6,  150.00, 25.00,  1875.00,    24167.00,   33332.99,   '99-006',   '2016-10-19 16:00:43',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  120. (146,   1,  6,  150.00, 30.00,  4166.67,    33333.00,   54166.99,   '99-006',   '2016-10-19 16:02:48',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL),
  121. (147,   1,  6,  150.00, 32.00,  10416.67,   54167.00,   0.00,   '99-006',   '2016-10-19 16:03:59',  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL);
  122.  
  123. INSERT INTO `payroll_pay_period_sched` (`pps_id`, `pps_name`, `pps_desc`, `salaryclass_id`, `pps_pri_dateldom`, `pps_pri_trans_dateldom`, `pps_pri_trans_datebd`, `pps_secnd_dateldom`, `pps_secnd_trans_dateldom`, `pps_secnd_trans_datebd`, `pps_addwho`, `pps_addwhen`, `pps_updatewho`, `pps_updatewhen`, `pps_anchor_date`, `pps_primary_date`, `pps_primary_trans_date`, `pps_secnd_date`, `pps_secnd_trans_date`, `pps_day_start_time`, `pps_day_continuous_time`, `pps_start_week_day`, `pps_start_day_week`, `pps_trans_date`, `pps_pri_daymonth`, `pps_secnd_daymonth`, `pps_pri_trans_daymonth`, `pps_secnd_trans_daymonth`, `pps_trans_datebd`, `pps_time_zone`, `pps_new_daytrigger_time`, `pps_max_shifttime`) VALUES
  124. (1, 'Calamba',  'Calamba',  6,  NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   'sysad',    '2016-09-30 09:24:51',  NULL,   NULL,   '0000-00-00 00:00:00',  '0000-00-00 00:00:00',  '0000-00-00 00:00:00',  '0000-00-00 00:00:00',  '0000-00-00 00:00:00',  0,  0,  0,  1,  0,  0,  0,  0,  0,  0,  '', 0,  0);
  125.  
  126. INSERT INTO `payroll_pps_user` (`ppsu_id`, `pps_id`, `emp_id`, `ppsu_addwho`, `ppsu_addwhen`) VALUES
  127. (18,    1,  13, 'sysad',    '2016-10-24 14:15:53'),
  128. (19,    1,  1,  'sysad',    '2016-10-24 15:36:50');
  129.  
  130. INSERT INTO `payroll_pay_period` (`payperiod_id`, `pps_id`, `payperiod_status_id`, `payperiod_is_primary`, `payperiod_addwho`, `payperiod_addwhen`, `payperiod_updatewhen`, `payperiod_updatewho`, `payperiod_start_date`, `payperiod_end_date`, `payperiod_trans_date`, `payperiod_adv_end_date`, `payperiod_adv_trans_date`, `payperiod_tainted`, `payperiod_taintedwho`, `payperiod_taintedwhen`, `pp_stat_id`) VALUES
  131. (5, 1,  0,  0,  'sysad',    '2016-10-20 10:38:12',  NULL,   NULL,   '2016-10-04 00:00:00',  '2016-10-18 23:59:00',  '2016-10-20 23:59:00',  '0000-00-00 00:00:00',  '0000-00-00 00:00:00',  0,  NULL,   NULL,   2);
  132.  
  133. INSERT INTO `payroll_paystub_report` (`ppr_id`, `payperiod_id`, `emp_id`, `emp_dept_id`, `ppr_paystubdetails`, `paystub_id`, `ppr_addwhen`, `ppr_addwho`, `ppr_updatewhen`, `ppr_updatewho`, `ppr_status`, `ppr_isdeleted`) VALUES
  134. (5, 2,  10, NULL,   'a:2:{s:7:\"empinfo\";a:6:{s:6:\"emp_id\";s:2:\"10\";s:6:\"emp_no\";s:6:\"08-025\";s:8:\"fullname\";s:16:\"Abueva, Sheryl R\";s:11:\"jobpos_name\";s:10:\"GS Teacher\";s:7:\"ud_name\";s:12:\"FACULTY DEPT\";s:11:\"tax_ex_name\";s:6:\"ME2/S2\";}s:13:\"paystubdetail\";a:2:{s:12:\"paystubsched\";a:6:{s:6:\"pps_id\";s:1:\"1\";s:12:\"payperiod_id\";s:1:\"2\";s:10:\"paystub_id\";s:2:\"30\";s:20:\"payperiod_start_date\";s:10:\"2016-10-03\";s:18:\"payperiod_end_date\";s:10:\"2016-10-14\";s:20:\"payperiod_trans_date\";s:19:\"2016-10-18 23:59:00\";}s:14:\"paystubaccount\";a:11:{s:7:\"earning\";a:5:{s:5:\"basic\";d:6150;s:11:\"Regulartime\";d:12300;s:2:\"OT\";a:2:{i:0;N;s:12:\"SumAllOTRate\";d:0;}s:7:\"Holiday\";a:2:{i:0;N;s:13:\"SumAllHolRate\";d:0;}s:7:\"Premium\";a:2:{i:0;N;s:17:\"SumAllPremiumRate\";d:0;}}s:9:\"deduction\";a:4:{s:3:\"SSS\";d:454.19999999999999;s:10:\"PhilHealth\";d:150;s:8:\"Pag-ibig\";i:0;s:6:\"Others\";i:0;}s:3:\"TUA\";a:3:{s:5:\"lates\";i:0;s:9:\"undertime\";i:0;s:6:\"absent\";d:4700.6400000000003;}s:23:\"company_duduction_total\";d:0;s:17:\"company_duduction\";a:1:{i:27;a:25:{s:6:\"cdh_id\";s:1:\"1\";s:6:\"psa_id\";s:2:\"27\";s:6:\"cdc_id\";s:1:\"1\";s:10:\"cdh_status\";s:1:\"1\";s:10:\"cdh_addwho\";s:6:\"rodwin\";s:11:\"cdh_addwhen\";s:19:\"2009-05-09 22:37:22\";s:13:\"cdh_updatewho\";s:6:\"rodwin\";s:13:\"cdh_updatwhen\";s:19:\"2009-05-14 19:16:33\";s:6:\"cdu_id\";s:2:\"41\";s:6:\"emp_id\";s:2:\"10\";s:10:\"cdu_addwho\";s:5:\"sysad\";s:11:\"cdu_addwhen\";s:19:\"2016-10-20 09:30:15\";s:8:\"cdc_name\";s:14:\"Provident Fund\";s:15:\"cdc_description\";s:50:\"Provident Fund                                    \";s:8:\"cdc_type\";s:2:\"20\";s:11:\"cdc_percent\";s:1:\"3\";s:10:\"cdc_amount\";s:3:\"200\";s:10:\"cdc_addwho\";s:6:\"rodwin\";s:11:\"cdc_addwhen\";s:19:\"2009-05-09 21:14:19\";s:13:\"cdc_updatewho\";s:6:\"rodwin\";s:14:\"cdc_updatewhen\";s:19:\"2009-05-13 08:13:44\";s:20:\"cdc_isemployer_share\";s:2:\"20\";s:20:\"cdc_employer_percent\";s:3:\"3.9\";s:11:\"cdc_taxable\";s:2:\"20\";s:4:\"cont\";d:369;}}s:9:\"provident\";N;s:18:\"government_regular\";N;s:9:\"amt_loans\";i:0;s:8:\"benefits\";a:0:{}s:10:\"amendments\";a:6:{i:0;N;i:1;N;s:14:\"total_TEarning\";d:0;s:15:\"total_NTEarning\";d:0;s:16:\"total_TDeduction\";d:0;s:17:\"total_NTDeduction\";d:0;}s:7:\"pstotal\";a:8:{s:5:\"gross\";d:0;s:7:\"monthly\";d:12300;s:23:\"gross_nontaxable_income\";d:0;s:13:\"taxable_Gross\";d:0;s:9:\"Deduction\";d:973.20000000000005;s:7:\"W/H Tax\";d:0;s:13:\"aftertaxgross\";d:0;s:7:\"Net Pay\";d:962.75999999999999;}}}}',  30, '2016-10-20 09:49:00',  'sysad',    '2016-10-20',   'sysad',    0,  0),
  135. (4, 2,  1,  NULL,   'a:2:{s:7:\"empinfo\";a:6:{s:6:\"emp_id\";s:1:\"1\";s:6:\"emp_no\";s:6:\"14-108\";s:8:\"fullname\";s:22:\"Cantavieja, Macy Joy G\";s:11:\"jobpos_name\";s:24:\"Administrative Assistant\";s:7:\"ud_name\";s:10:\"ADMIN DEPT\";s:11:\"tax_ex_name\";s:4:\"S/ME\";}s:13:\"paystubdetail\";a:2:{s:12:\"paystubsched\";a:6:{s:6:\"pps_id\";s:1:\"1\";s:12:\"payperiod_id\";s:1:\"2\";s:10:\"paystub_id\";s:2:\"28\";s:20:\"payperiod_start_date\";s:10:\"2016-10-03\";s:18:\"payperiod_end_date\";s:10:\"2016-10-14\";s:20:\"payperiod_trans_date\";s:19:\"2016-10-18 23:59:00\";}s:14:\"paystubaccount\";a:11:{s:7:\"earning\";a:5:{s:5:\"basic\";d:5000;s:11:\"Regulartime\";d:10000;s:2:\"OT\";a:2:{i:0;a:1:{i:0;a:4:{s:12:\"totaltimesec\";s:1:\"0\";s:11:\"totaltimehr\";s:1:\"0\";s:8:\"psa_name\";N;s:8:\"otamount\";d:0;}}s:12:\"SumAllOTRate\";d:0;}s:7:\"Holiday\";a:2:{i:0;N;s:13:\"SumAllHolRate\";d:0;}s:7:\"Premium\";a:2:{i:0;N;s:17:\"SumAllPremiumRate\";d:0;}}s:9:\"deduction\";a:4:{s:3:\"SSS\";d:363.30000000000001;s:10:\"PhilHealth\";d:125;s:8:\"Pag-ibig\";i:0;s:6:\"Others\";i:0;}s:3:\"TUA\";a:3:{s:5:\"lates\";i:0;s:9:\"undertime\";i:0;s:6:\"absent\";i:0;}s:23:\"company_duduction_total\";d:0;s:17:\"company_duduction\";a:1:{i:27;a:25:{s:6:\"cdh_id\";s:1:\"1\";s:6:\"psa_id\";s:2:\"27\";s:6:\"cdc_id\";s:1:\"1\";s:10:\"cdh_status\";s:1:\"1\";s:10:\"cdh_addwho\";s:6:\"rodwin\";s:11:\"cdh_addwhen\";s:19:\"2009-05-09 22:37:22\";s:13:\"cdh_updatewho\";s:6:\"rodwin\";s:13:\"cdh_updatwhen\";s:19:\"2009-05-14 19:16:33\";s:6:\"cdu_id\";s:2:\"42\";s:6:\"emp_id\";s:1:\"1\";s:10:\"cdu_addwho\";s:5:\"sysad\";s:11:\"cdu_addwhen\";s:19:\"2016-10-20 09:48:46\";s:8:\"cdc_name\";s:14:\"Provident Fund\";s:15:\"cdc_description\";s:50:\"Provident Fund                                    \";s:8:\"cdc_type\";s:2:\"20\";s:11:\"cdc_percent\";s:1:\"3\";s:10:\"cdc_amount\";s:3:\"200\";s:10:\"cdc_addwho\";s:6:\"rodwin\";s:11:\"cdc_addwhen\";s:19:\"2009-05-09 21:14:19\";s:13:\"cdc_updatewho\";s:6:\"rodwin\";s:14:\"cdc_updatewhen\";s:19:\"2009-05-13 08:13:44\";s:20:\"cdc_isemployer_share\";s:2:\"20\";s:20:\"cdc_employer_percent\";s:3:\"3.9\";s:11:\"cdc_taxable\";s:2:\"20\";s:4:\"cont\";d:300;}}s:9:\"provident\";N;s:18:\"government_regular\";N;s:9:\"amt_loans\";i:0;s:8:\"benefits\";a:0:{}s:10:\"amendments\";a:6:{i:0;N;i:1;N;s:14:\"total_TEarning\";d:0;s:15:\"total_NTEarning\";d:0;s:16:\"total_TDeduction\";d:0;s:17:\"total_NTDeduction\";d:0;}s:7:\"pstotal\";a:8:{s:5:\"gross\";d:0;s:7:\"monthly\";d:10000;s:23:\"gross_nontaxable_income\";d:0;s:13:\"taxable_Gross\";d:0;s:9:\"Deduction\";d:788.29999999999995;s:7:\"W/H Tax\";d:1231;s:13:\"aftertaxgross\";d:0;s:7:\"Net Pay\";d:4605.8500000000004;}}}}', 28, '2016-10-19 17:35:26',  'sysad',    '2016-10-20',   'sysad',    0,  0),
  136. (7, 4,  1,  NULL,   'a:2:{s:7:\"empinfo\";a:6:{s:6:\"emp_id\";s:1:\"1\";s:6:\"emp_no\";s:6:\"14-108\";s:8:\"fullname\";s:22:\"Cantavieja, Macy Joy G\";s:11:\"jobpos_name\";s:24:\"Administrative Assistant\";s:7:\"ud_name\";s:10:\"ADMIN DEPT\";s:11:\"tax_ex_name\";s:4:\"S/ME\";}s:13:\"paystubdetail\";a:2:{s:12:\"paystubsched\";a:6:{s:6:\"pps_id\";s:1:\"1\";s:12:\"payperiod_id\";s:1:\"4\";s:10:\"paystub_id\";s:2:\"32\";s:20:\"payperiod_start_date\";s:10:\"2016-09-08\";s:18:\"payperiod_end_date\";s:10:\"2016-09-22\";s:20:\"payperiod_trans_date\";s:19:\"2016-10-20 23:59:00\";}s:14:\"paystubaccount\";a:11:{s:7:\"earning\";a:5:{s:5:\"basic\";d:5000;s:11:\"Regulartime\";d:10000;s:2:\"OT\";a:2:{i:0;N;s:12:\"SumAllOTRate\";d:0;}s:7:\"Holiday\";a:2:{i:0;N;s:13:\"SumAllHolRate\";d:0;}s:7:\"Premium\";a:2:{i:0;N;s:17:\"SumAllPremiumRate\";d:0;}}s:9:\"deduction\";a:4:{s:3:\"SSS\";d:363.30000000000001;s:10:\"PhilHealth\";d:125;s:8:\"Pag-ibig\";i:0;s:6:\"Others\";i:0;}s:3:\"TUA\";a:3:{s:5:\"lates\";i:0;s:9:\"undertime\";i:0;s:6:\"absent\";d:4203.8199999999997;}s:23:\"company_duduction_total\";d:0;s:17:\"company_duduction\";a:1:{i:27;a:25:{s:6:\"cdh_id\";s:1:\"1\";s:6:\"psa_id\";s:2:\"27\";s:6:\"cdc_id\";s:1:\"1\";s:10:\"cdh_status\";s:1:\"1\";s:10:\"cdh_addwho\";s:6:\"rodwin\";s:11:\"cdh_addwhen\";s:19:\"2009-05-09 22:37:22\";s:13:\"cdh_updatewho\";s:6:\"rodwin\";s:13:\"cdh_updatwhen\";s:19:\"2009-05-14 19:16:33\";s:6:\"cdu_id\";s:2:\"44\";s:6:\"emp_id\";s:1:\"1\";s:10:\"cdu_addwho\";s:5:\"sysad\";s:11:\"cdu_addwhen\";s:19:\"2016-10-20 10:20:39\";s:8:\"cdc_name\";s:14:\"Provident Fund\";s:15:\"cdc_description\";s:50:\"Provident Fund                                    \";s:8:\"cdc_type\";s:2:\"20\";s:11:\"cdc_percent\";s:1:\"3\";s:10:\"cdc_amount\";s:3:\"200\";s:10:\"cdc_addwho\";s:6:\"rodwin\";s:11:\"cdc_addwhen\";s:19:\"2009-05-09 21:14:19\";s:13:\"cdc_updatewho\";s:6:\"rodwin\";s:14:\"cdc_updatewhen\";s:19:\"2009-05-13 08:13:44\";s:20:\"cdc_isemployer_share\";s:2:\"20\";s:20:\"cdc_employer_percent\";s:3:\"3.9\";s:11:\"cdc_taxable\";s:2:\"20\";s:4:\"cont\";d:300;}}s:9:\"provident\";N;s:18:\"government_regular\";N;s:9:\"amt_loans\";i:0;s:8:\"benefits\";a:0:{}s:10:\"amendments\";a:6:{i:0;N;i:1;N;s:14:\"total_TEarning\";d:0;s:15:\"total_NTEarning\";d:0;s:16:\"total_TDeduction\";d:0;s:17:\"total_NTDeduction\";d:0;}s:7:\"pstotal\";a:8:{s:5:\"gross\";d:0;s:7:\"monthly\";d:10000;s:23:\"gross_nontaxable_income\";d:0;s:13:\"taxable_Gross\";d:0;s:9:\"Deduction\";d:788.29999999999995;s:7:\"W/H Tax\";d:0;s:13:\"aftertaxgross\";d:0;s:7:\"Net Pay\";d:402.02999999999997;}}}}',    32, '2016-10-20 10:21:00',  'sysad',    '2016-10-20',   'sysad',    0,  0),
  137. (8, 5,  1,  NULL,   'a:2:{s:7:\"empinfo\";a:6:{s:6:\"emp_id\";s:1:\"1\";s:6:\"emp_no\";s:6:\"14-108\";s:8:\"fullname\";s:22:\"Cantavieja, Macy Joy G\";s:11:\"jobpos_name\";s:24:\"Administrative Assistant\";s:7:\"ud_name\";s:10:\"ADMIN DEPT\";s:11:\"tax_ex_name\";s:4:\"S/ME\";}s:13:\"paystubdetail\";a:2:{s:12:\"paystubsched\";a:6:{s:6:\"pps_id\";s:1:\"1\";s:12:\"payperiod_id\";s:1:\"5\";s:10:\"paystub_id\";s:2:\"33\";s:20:\"payperiod_start_date\";s:10:\"2016-10-04\";s:18:\"payperiod_end_date\";s:10:\"2016-10-18\";s:20:\"payperiod_trans_date\";s:19:\"2016-10-20 23:59:00\";}s:14:\"paystubaccount\";a:11:{s:7:\"earning\";a:5:{s:5:\"basic\";d:5000;s:11:\"Regulartime\";d:10000;s:2:\"OT\";a:2:{i:0;N;s:12:\"SumAllOTRate\";d:0;}s:7:\"Holiday\";a:2:{i:0;N;s:13:\"SumAllHolRate\";d:0;}s:7:\"Premium\";a:2:{i:0;N;s:17:\"SumAllPremiumRate\";d:0;}}s:9:\"deduction\";a:4:{s:3:\"SSS\";d:363.30000000000001;s:10:\"PhilHealth\";d:125;s:8:\"Pag-ibig\";d:100;s:6:\"Others\";i:0;}s:3:\"TUA\";a:3:{s:5:\"lates\";i:0;s:9:\"undertime\";i:0;s:6:\"absent\";d:764.33000000000004;}s:23:\"company_duduction_total\";d:0;s:17:\"company_duduction\";N;s:9:\"provident\";N;s:18:\"government_regular\";N;s:9:\"amt_loans\";i:0;s:8:\"benefits\";a:0:{}s:10:\"amendments\";a:6:{i:0;N;i:1;N;s:14:\"total_TEarning\";d:0;s:15:\"total_NTEarning\";d:0;s:16:\"total_TDeduction\";d:0;s:17:\"total_NTDeduction\";d:0;}s:7:\"pstotal\";a:8:{s:5:\"gross\";d:0;s:7:\"monthly\";d:10000;s:23:\"gross_nontaxable_income\";d:0;s:13:\"taxable_Gross\";d:0;s:9:\"Deduction\";d:1108.3399999999999;s:7:\"W/H Tax\";d:620.03999999999996;s:13:\"aftertaxgross\";d:-620.03999999999996;s:7:\"Net Pay\";d:3681.5;}}}}',  33, '2016-10-20 10:38:33',  'sysad',    '2016-10-25',   'sysad',    0,  0),
  138. (9, 5,  13, NULL,   'a:2:{s:7:\"empinfo\";a:6:{s:6:\"emp_id\";s:2:\"13\";s:6:\"emp_no\";s:6:\"16-167\";s:8:\"fullname\";s:20:\"Aquino, Luzviminda Q\";s:11:\"jobpos_name\";s:10:\"GS Teacher\";s:7:\"ud_name\";s:12:\"FACULTY DEPT\";s:11:\"tax_ex_name\";s:4:\"S/ME\";}s:13:\"paystubdetail\";a:2:{s:12:\"paystubsched\";a:6:{s:6:\"pps_id\";s:1:\"1\";s:12:\"payperiod_id\";s:1:\"5\";s:10:\"paystub_id\";s:2:\"34\";s:20:\"payperiod_start_date\";s:10:\"2016-10-04\";s:18:\"payperiod_end_date\";s:10:\"2016-10-18\";s:20:\"payperiod_trans_date\";s:19:\"2016-10-20 23:59:00\";}s:14:\"paystubaccount\";a:11:{s:7:\"earning\";a:5:{s:5:\"basic\";d:3750;s:11:\"Regulartime\";d:7500;s:2:\"OT\";a:2:{i:0;N;s:12:\"SumAllOTRate\";d:0;}s:7:\"Holiday\";a:2:{i:0;N;s:13:\"SumAllHolRate\";d:0;}s:7:\"Premium\";a:2:{i:0;N;s:17:\"SumAllPremiumRate\";d:0;}}s:9:\"deduction\";a:4:{s:3:\"SSS\";d:272.5;s:10:\"PhilHealth\";d:100;s:8:\"Pag-ibig\";d:100;s:6:\"Others\";i:0;}s:3:\"TUA\";a:3:{s:5:\"lates\";i:0;s:9:\"undertime\";i:0;s:6:\"absent\";d:3152.8699999999999;}s:23:\"company_duduction_total\";d:0;s:17:\"company_duduction\";N;s:9:\"provident\";N;s:18:\"government_regular\";N;s:9:\"amt_loans\";i:0;s:8:\"benefits\";a:0:{}s:10:\"amendments\";a:6:{i:0;N;i:1;N;s:14:\"total_TEarning\";d:0;s:15:\"total_NTEarning\";d:0;s:16:\"total_TDeduction\";d:0;s:17:\"total_NTDeduction\";d:0;}s:7:\"pstotal\";a:8:{s:5:\"gross\";d:0;s:7:\"monthly\";d:7500;s:23:\"gross_nontaxable_income\";d:0;s:13:\"taxable_Gross\";d:0;s:9:\"Deduction\";d:634.91000000000008;s:7:\"W/H Tax\";d:262.41000000000003;s:13:\"aftertaxgross\";d:-262.41000000000003;s:7:\"Net Pay\";d:279.68000000000001;}}}}',  34, '2016-10-24 15:08:57',  'sysad',    '2016-10-25',   'sysad',    0,  0);
  139.  
  140. INSERT INTO `payroll_deduction_user` (`du_id`, `dduct_id`, `emp_id`, `du_typeid`, `du_addwho`, `du_addwhen`, `du_updatewho`, `du_updatewhen`) VALUES
  141. (58,    2,  9,  3,  'sysad',    '2016-10-20 09:03:06',  NULL,   NULL),
  142. (57,    6,  9,  2,  'sysad',    '2016-10-20 09:03:06',  NULL,   NULL),
  143. (112,   2,  13, 3,  'sysad',    '2016-10-24 14:15:53',  NULL,   NULL),
  144. (113,   3,  13, 4,  'sysad',    '2016-10-24 14:15:53',  NULL,   NULL),
  145. (8, 6,  25, NULL,   NULL,   '2016-10-19 16:59:10',  NULL,   NULL),
  146. (9, 7,  25, NULL,   NULL,   '2016-10-19 16:59:10',  NULL,   NULL),
  147. (10,    10, 25, NULL,   NULL,   '2016-10-19 16:59:10',  NULL,   NULL),
  148. (59,    3,  9,  4,  'sysad',    '2016-10-20 09:03:06',  NULL,   NULL),
  149. (60,    7,  9,  5,  'sysad',    '2016-10-20 09:03:06',  NULL,   NULL),
  150. (166,   4,  1,  5,  'sysad',    '2016-10-24 17:55:19',  NULL,   NULL),
  151. (159,   1,  1,  2,  'sysad',    '2016-10-24 16:52:00',  NULL,   NULL),
  152. (68,    6,  10, 2,  'sysad',    '2016-10-20 09:30:15',  NULL,   NULL),
  153. (69,    2,  10, 3,  'sysad',    '2016-10-20 09:30:15',  NULL,   NULL),
  154. (70,    3,  10, 4,  'sysad',    '2016-10-20 09:30:15',  NULL,   NULL),
  155. (71,    7,  10, 5,  'sysad',    '2016-10-20 09:30:15',  NULL,   NULL),
  156. (81,    13, 10, NULL,   NULL,   '2016-10-20 09:48:57',  NULL,   NULL),
  157. (82,    10, 10, NULL,   NULL,   '2016-10-20 09:48:57',  NULL,   NULL),
  158. (165,   3,  1,  4,  'sysad',    '2016-10-24 17:54:23',  NULL,   NULL),
  159. (84,    1,  24, 2,  'sysad',    '2016-10-20 09:51:56',  NULL,   NULL),
  160. (127,   2,  1,  3,  'sysad',    '2016-10-24 15:36:50',  NULL,   NULL),
  161. (158,   4,  13, NULL,   NULL,   '2016-10-24 16:44:29',  NULL,   NULL),
  162. (157,   1,  13, NULL,   NULL,   '2016-10-24 16:44:29',  NULL,   NULL);
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!