337 lines
24 KiB
PHP
337 lines
24 KiB
PHP
<?php
|
|
|
|
include('includes/config/config.php');
|
|
|
|
//land ac Record
|
|
|
|
|
|
|
|
$excelData = [
|
|
['emp_code' =>'BNF5588','bene_form_key' =>'3','checkup_form_value' => '363'],
|
|
['emp_code' =>'BNF5183','bene_form_key' =>'3','checkup_form_value' => '181'],
|
|
['emp_code' =>'BNF4206','bene_form_key' =>'3','checkup_form_value' => '232'],
|
|
['emp_code' =>'BNF4111','bene_form_key' =>'3','checkup_form_value' => '216'],
|
|
['emp_code' =>'BNF4110','bene_form_key' =>'3','checkup_form_value' => '2949'],
|
|
['emp_code' =>'BNF4109','bene_form_key' =>'3','checkup_form_value' => '290'],
|
|
['emp_code' =>'BNF4107','bene_form_key' =>'3','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4105','bene_form_key' =>'3','checkup_form_value' => '479'],
|
|
['emp_code' =>'BNF4104','bene_form_key' =>'3','checkup_form_value' => '87'],
|
|
['emp_code' =>'BNF4103','bene_form_key' =>'3','checkup_form_value' => '87'],
|
|
['emp_code' =>'BNF4101','bene_form_key' =>'3','checkup_form_value' => '2891'],
|
|
['emp_code' =>'BNF4099','bene_form_key' =>'3','checkup_form_value' => '2781'],
|
|
['emp_code' =>'BNF4098','bene_form_key' =>'3','checkup_form_value' => '693'],
|
|
['emp_code' =>'BNF4097','bene_form_key' =>'3','checkup_form_value' => '693'],
|
|
['emp_code' =>'BNF4096','bene_form_key' =>'3','checkup_form_value' => '1180'],
|
|
['emp_code' =>'BNF4095','bene_form_key' =>'3','checkup_form_value' => '254'],
|
|
['emp_code' =>'BNF4094','bene_form_key' =>'3','checkup_form_value' => '159'],
|
|
['emp_code' =>'BNF4092','bene_form_key' =>'3','checkup_form_value' => '190'],
|
|
['emp_code' =>'BNF4091','bene_form_key' =>'3','checkup_form_value' => '168'],
|
|
['emp_code' =>'BNF4090','bene_form_key' =>'3','checkup_form_value' => '722'],
|
|
['emp_code' =>'BNF4089','bene_form_key' =>'3','checkup_form_value' => '765'],
|
|
['emp_code' =>'BNF4088','bene_form_key' =>'3','checkup_form_value' => '765'],
|
|
['emp_code' =>'BNF4087','bene_form_key' =>'3','checkup_form_value' => '765'],
|
|
['emp_code' =>'BNF4086','bene_form_key' =>'3','checkup_form_value' => '394'],
|
|
['emp_code' =>'BNF4086','bene_form_key' =>'3','checkup_form_value' => '1232'],
|
|
['emp_code' =>'BNF4085','bene_form_key' =>'3','checkup_form_value' => '50'],
|
|
['emp_code' =>'BNF4084','bene_form_key' =>'3','checkup_form_value' => '50'],
|
|
['emp_code' =>'BNF4083','bene_form_key' =>'3','checkup_form_value' => '310'],
|
|
['emp_code' =>'BNF4082','bene_form_key' =>'3','checkup_form_value' => '287'],
|
|
['emp_code' =>'BNF4081','bene_form_key' =>'3','checkup_form_value' => '332'],
|
|
['emp_code' =>'BNF4080','bene_form_key' =>'3','checkup_form_value' => '214'],
|
|
['emp_code' =>'BNF4079','bene_form_key' =>'3','checkup_form_value' => '617'],
|
|
['emp_code' =>'BNF4078','bene_form_key' =>'3','checkup_form_value' => '678'],
|
|
['emp_code' =>'BNF4077','bene_form_key' =>'3','checkup_form_value' => '196'],
|
|
['emp_code' =>'BNF4076','bene_form_key' =>'3','checkup_form_value' => '2573'],
|
|
['emp_code' =>'BNF4075','bene_form_key' =>'3','checkup_form_value' => '2477'],
|
|
['emp_code' =>'BNF4066','bene_form_key' =>'3','checkup_form_value' => '649'],
|
|
['emp_code' =>'BNF4065','bene_form_key' =>'3','checkup_form_value' => '1211'],
|
|
['emp_code' =>'BNF4064','bene_form_key' =>'3','checkup_form_value' => '497'],
|
|
['emp_code' =>'BNF4063','bene_form_key' =>'3','checkup_form_value' => '1707'],
|
|
['emp_code' =>'BNF4062','bene_form_key' =>'3','checkup_form_value' => '497'],
|
|
['emp_code' =>'BNF4061','bene_form_key' =>'3','checkup_form_value' => '1119'],
|
|
['emp_code' =>'BNF4060','bene_form_key' =>'3','checkup_form_value' => '1119'],
|
|
['emp_code' =>'BNF4058','bene_form_key' =>'3','checkup_form_value' => '754'],
|
|
['emp_code' =>'BNF4057','bene_form_key' =>'3','checkup_form_value' => '924'],
|
|
['emp_code' =>'BNF4056','bene_form_key' =>'3','checkup_form_value' => '428'],
|
|
['emp_code' =>'BNF4056','bene_form_key' =>'3','checkup_form_value' => '255'],
|
|
['emp_code' =>'BNF4055','bene_form_key' =>'3','checkup_form_value' => '547'],
|
|
['emp_code' =>'BNF4054','bene_form_key' =>'3','checkup_form_value' => '1894'],
|
|
['emp_code' =>'BNF4053','bene_form_key' =>'3','checkup_form_value' => '2418'],
|
|
['emp_code' =>'BNF4052','bene_form_key' =>'3','checkup_form_value' => '1381'],
|
|
['emp_code' =>'BNF4051','bene_form_key' =>'3','checkup_form_value' => '127'],
|
|
['emp_code' =>'BNF4050','bene_form_key' =>'3','checkup_form_value' => '522'],
|
|
['emp_code' =>'BNF4049','bene_form_key' =>'3','checkup_form_value' => '432'],
|
|
['emp_code' =>'BNF4048','bene_form_key' =>'3','checkup_form_value' => '37'],
|
|
['emp_code' =>'BNF4047','bene_form_key' =>'3','checkup_form_value' => '339'],
|
|
['emp_code' =>'BNF4045','bene_form_key' =>'3','checkup_form_value' => '138'],
|
|
['emp_code' =>'BNF4042','bene_form_key' =>'3','checkup_form_value' => '99'],
|
|
['emp_code' =>'BNF4041','bene_form_key' =>'3','checkup_form_value' => '87'],
|
|
['emp_code' =>'BNF4040','bene_form_key' =>'3','checkup_form_value' => '148'],
|
|
['emp_code' =>'BNF4039','bene_form_key' =>'3','checkup_form_value' => '87'],
|
|
['emp_code' =>'BNF4034','bene_form_key' =>'3','checkup_form_value' => '2597'],
|
|
['emp_code' =>'BNF4031','bene_form_key' =>'3','checkup_form_value' => '430'],
|
|
['emp_code' =>'BNF4030','bene_form_key' =>'3','checkup_form_value' => '125'],
|
|
['emp_code' =>'BNF4030','bene_form_key' =>'3','checkup_form_value' => '154'],
|
|
['emp_code' =>'BNF4029','bene_form_key' =>'3','checkup_form_value' => '20'],
|
|
['emp_code' =>'BNF4028','bene_form_key' =>'3','checkup_form_value' => '92'],
|
|
['emp_code' =>'BNF4027','bene_form_key' =>'3','checkup_form_value' => '488'],
|
|
['emp_code' =>'BNF4026','bene_form_key' =>'3','checkup_form_value' => '295'],
|
|
['emp_code' =>'BNF4025','bene_form_key' =>'3','checkup_form_value' => '80'],
|
|
['emp_code' =>'BNF4024','bene_form_key' =>'3','checkup_form_value' => '399'],
|
|
['emp_code' =>'BNF4024','bene_form_key' =>'3','checkup_form_value' => '488'],
|
|
['emp_code' =>'BNF4023','bene_form_key' =>'3','checkup_form_value' => '2517'],
|
|
['emp_code' =>'BNF4022','bene_form_key' =>'3','checkup_form_value' => '399'],
|
|
['emp_code' =>'BNF4022','bene_form_key' =>'3','checkup_form_value' => '288'],
|
|
['emp_code' =>'BNF4021','bene_form_key' =>'3','checkup_form_value' => '654'],
|
|
['emp_code' =>'BNF4020','bene_form_key' =>'3','checkup_form_value' => '456'],
|
|
['emp_code' =>'BNF4019','bene_form_key' =>'3','checkup_form_value' => '79'],
|
|
['emp_code' =>'BNF4019','bene_form_key' =>'3','checkup_form_value' => '428'],
|
|
['emp_code' =>'BNF4018','bene_form_key' =>'3','checkup_form_value' => '428'],
|
|
['emp_code' =>'BNF4017','bene_form_key' =>'3','checkup_form_value' => '1827'],
|
|
['emp_code' =>'BNF4016','bene_form_key' =>'3','checkup_form_value' => '787'],
|
|
['emp_code' =>'BNF4015','bene_form_key' =>'3','checkup_form_value' => '435'],
|
|
['emp_code' =>'BNF4014','bene_form_key' =>'3','checkup_form_value' => '435'],
|
|
['emp_code' =>'BNF4014','bene_form_key' =>'3','checkup_form_value' => '516'],
|
|
['emp_code' =>'BNF4013','bene_form_key' =>'3','checkup_form_value' => '183'],
|
|
['emp_code' =>'BNF4012','bene_form_key' =>'3','checkup_form_value' => '434'],
|
|
['emp_code' =>'BNF4011','bene_form_key' =>'3','checkup_form_value' => '357'],
|
|
['emp_code' =>'BNF4010','bene_form_key' =>'3','checkup_form_value' => '721'],
|
|
['emp_code' =>'BNF4005','bene_form_key' =>'3','checkup_form_value' => '94'],
|
|
['emp_code' =>'BNF4004','bene_form_key' =>'3','checkup_form_value' => '388'],
|
|
['emp_code' =>'BNF4001','bene_form_key' =>'3','checkup_form_value' => '508'],
|
|
['emp_code' =>'BNF4000','bene_form_key' =>'3','checkup_form_value' => '1747'],
|
|
['emp_code' =>'BNF3997','bene_form_key' =>'3','checkup_form_value' => '1064'],
|
|
['emp_code' =>'BNF3996','bene_form_key' =>'3','checkup_form_value' => '353'],
|
|
['emp_code' =>'BNF3995','bene_form_key' =>'3','checkup_form_value' => '1826'],
|
|
['emp_code' =>'BNF3994','bene_form_key' =>'3','checkup_form_value' => '1826'],
|
|
['emp_code' =>'BNF3993','bene_form_key' =>'3','checkup_form_value' => '2067'],
|
|
['emp_code' =>'BNF3993','bene_form_key' =>'3','checkup_form_value' => '2411'],
|
|
['emp_code' =>'BNF3992','bene_form_key' =>'3','checkup_form_value' => '109'],
|
|
['emp_code' =>'BNF3991','bene_form_key' =>'3','checkup_form_value' => '538'],
|
|
['emp_code' =>'BNF3987','bene_form_key' =>'3','checkup_form_value' => '291'],
|
|
['emp_code' =>'BNF3986','bene_form_key' =>'3','checkup_form_value' => '1501'],
|
|
['emp_code' =>'BNF3985','bene_form_key' =>'3','checkup_form_value' => '594'],
|
|
['emp_code' =>'BNF3984','bene_form_key' =>'3','checkup_form_value' => '64'],
|
|
['emp_code' =>'BNF3983','bene_form_key' =>'3','checkup_form_value' => '64'],
|
|
['emp_code' =>'BNF3980','bene_form_key' =>'3','checkup_form_value' => '467'],
|
|
['emp_code' =>'BNF3979','bene_form_key' =>'3','checkup_form_value' => '467'],
|
|
['emp_code' =>'BNF3979','bene_form_key' =>'3','checkup_form_value' => '319'],
|
|
['emp_code' =>'BNF3978','bene_form_key' =>'3','checkup_form_value' => '398'],
|
|
['emp_code' =>'BNF3977','bene_form_key' =>'3','checkup_form_value' => '426'],
|
|
['emp_code' =>'BNF3976','bene_form_key' =>'3','checkup_form_value' => '135'],
|
|
['emp_code' =>'BNF3975','bene_form_key' =>'3','checkup_form_value' => '135'],
|
|
['emp_code' =>'BNF3974','bene_form_key' =>'3','checkup_form_value' => '532'],
|
|
['emp_code' =>'BNF3973','bene_form_key' =>'3','checkup_form_value' => '414'],
|
|
['emp_code' =>'BNF3972','bene_form_key' =>'3','checkup_form_value' => '465'],
|
|
['emp_code' =>'BNF3971','bene_form_key' =>'3','checkup_form_value' => '588'],
|
|
['emp_code' =>'BNF3970','bene_form_key' =>'3','checkup_form_value' => '1157'],
|
|
['emp_code' =>'BNF3969','bene_form_key' =>'3','checkup_form_value' => '440'],
|
|
['emp_code' =>'BNF3968','bene_form_key' =>'3','checkup_form_value' => '182'],
|
|
['emp_code' =>'BNF3968','bene_form_key' =>'3','checkup_form_value' => '351'],
|
|
['emp_code' =>'BNF3967','bene_form_key' =>'3','checkup_form_value' => '351'],
|
|
['emp_code' =>'BNF3964','bene_form_key' =>'3','checkup_form_value' => '220'],
|
|
['emp_code' =>'BNF3963','bene_form_key' =>'3','checkup_form_value' => '193'],
|
|
['emp_code' =>'BNF3962','bene_form_key' =>'3','checkup_form_value' => '224'],
|
|
['emp_code' =>'BNF3961','bene_form_key' =>'3','checkup_form_value' => '179'],
|
|
['emp_code' =>'BNF3960','bene_form_key' =>'3','checkup_form_value' => '224'],
|
|
['emp_code' =>'BNF3960','bene_form_key' =>'3','checkup_form_value' => '401'],
|
|
['emp_code' =>'BNF3959','bene_form_key' =>'3','checkup_form_value' => '401'],
|
|
['emp_code' =>'BNF3958','bene_form_key' =>'3','checkup_form_value' => '402'],
|
|
['emp_code' =>'BNF3957','bene_form_key' =>'3','checkup_form_value' => '518'],
|
|
['emp_code' =>'BNF3956','bene_form_key' =>'3','checkup_form_value' => '308'],
|
|
['emp_code' =>'BNF3955','bene_form_key' =>'3','checkup_form_value' => '1021'],
|
|
['emp_code' =>'BNF3954','bene_form_key' =>'3','checkup_form_value' => '930'],
|
|
['emp_code' =>'BNF3953','bene_form_key' =>'3','checkup_form_value' => '203'],
|
|
['emp_code' =>'BNF3951','bene_form_key' =>'3','checkup_form_value' => '40'],
|
|
['emp_code' =>'BNF3950','bene_form_key' =>'3','checkup_form_value' => '40'],
|
|
['emp_code' =>'BNF3949','bene_form_key' =>'3','checkup_form_value' => '199'],
|
|
['emp_code' =>'BNF3948','bene_form_key' =>'3','checkup_form_value' => '199'],
|
|
['emp_code' =>'BNF3947','bene_form_key' =>'3','checkup_form_value' => '199'],
|
|
['emp_code' =>'BNF3946','bene_form_key' =>'3','checkup_form_value' => '151'],
|
|
['emp_code' =>'BNF3943','bene_form_key' =>'3','checkup_form_value' => '1582'],
|
|
['emp_code' =>'BNF3942','bene_form_key' =>'3','checkup_form_value' => '231'],
|
|
['emp_code' =>'BNF3940','bene_form_key' =>'3','checkup_form_value' => '1239'],
|
|
['emp_code' =>'BNF3937','bene_form_key' =>'3','checkup_form_value' => '167'],
|
|
['emp_code' =>'BNF3936','bene_form_key' =>'3','checkup_form_value' => '167'],
|
|
['emp_code' =>'BNF3935','bene_form_key' =>'3','checkup_form_value' => '390'],
|
|
['emp_code' =>'BNF3934','bene_form_key' =>'3','checkup_form_value' => '456'],
|
|
['emp_code' =>'BNF3933','bene_form_key' =>'3','checkup_form_value' => '346'],
|
|
['emp_code' =>'BNF3932','bene_form_key' =>'3','checkup_form_value' => '2799'],
|
|
['emp_code' =>'BNF3931','bene_form_key' =>'3','checkup_form_value' => '2800'],
|
|
['emp_code' =>'BNF3930','bene_form_key' =>'3','checkup_form_value' => '366'],
|
|
['emp_code' =>'BNF3929','bene_form_key' =>'3','checkup_form_value' => '45'],
|
|
['emp_code' =>'BNF3928','bene_form_key' =>'3','checkup_form_value' => '1707'],
|
|
['emp_code' =>'BNF3927','bene_form_key' =>'3','checkup_form_value' => '188'],
|
|
['emp_code' =>'BNF3926','bene_form_key' =>'3','checkup_form_value' => '188'],
|
|
['emp_code' =>'BNF3925','bene_form_key' =>'3','checkup_form_value' => '311'],
|
|
['emp_code' =>'BNF3924','bene_form_key' =>'3','checkup_form_value' => '45'],
|
|
['emp_code' =>'BNF3922','bene_form_key' =>'3','checkup_form_value' => '83'],
|
|
['emp_code' =>'BNF3921','bene_form_key' =>'3','checkup_form_value' => '571'],
|
|
['emp_code' =>'BNF3920','bene_form_key' =>'3','checkup_form_value' => '363'],
|
|
['emp_code' =>'BNF3919','bene_form_key' =>'3','checkup_form_value' => '1895'],
|
|
['emp_code' =>'BNF3918','bene_form_key' =>'3','checkup_form_value' => '620'],
|
|
['emp_code' =>'BNF3917','bene_form_key' =>'3','checkup_form_value' => '179'],
|
|
['emp_code' =>'BNF3915','bene_form_key' =>'3','checkup_form_value' => '179'],
|
|
['emp_code' =>'BNF3914','bene_form_key' =>'3','checkup_form_value' => '186'],
|
|
['emp_code' =>'BNF3913','bene_form_key' =>'3','checkup_form_value' => '1047'],
|
|
['emp_code' =>'BNF3912','bene_form_key' =>'3','checkup_form_value' => '1790'],
|
|
['emp_code' =>'BNF3911','bene_form_key' =>'3','checkup_form_value' => '1602'],
|
|
['emp_code' =>'BNF3910','bene_form_key' =>'3','checkup_form_value' => '309'],
|
|
['emp_code' =>'BNF3908','bene_form_key' =>'3','checkup_form_value' => '100'],
|
|
['emp_code' =>'BNF3907','bene_form_key' =>'3','checkup_form_value' => '471'],
|
|
['emp_code' =>'BNF3906','bene_form_key' =>'3','checkup_form_value' => '431'],
|
|
['emp_code' =>'BNF3904','bene_form_key' =>'3','checkup_form_value' => '231'],
|
|
['emp_code' =>'BNF3903','bene_form_key' =>'3','checkup_form_value' => '176'],
|
|
['emp_code' =>'BNF3900','bene_form_key' =>'3','checkup_form_value' => '405'],
|
|
['emp_code' =>'BNF3900','bene_form_key' =>'3','checkup_form_value' => '373'],
|
|
['emp_code' =>'BNF3899','bene_form_key' =>'3','checkup_form_value' => '71'],
|
|
['emp_code' =>'BNF3898','bene_form_key' =>'3','checkup_form_value' => '327'],
|
|
['emp_code' =>'BNF3897','bene_form_key' =>'3','checkup_form_value' => '172'],
|
|
['emp_code' =>'BNF3896','bene_form_key' =>'3','checkup_form_value' => '365'],
|
|
['emp_code' =>'BNF3895','bene_form_key' =>'3','checkup_form_value' => '365'],
|
|
['emp_code' =>'BNF3894','bene_form_key' =>'3','checkup_form_value' => '365'],
|
|
['emp_code' =>'BNF3893','bene_form_key' =>'3','checkup_form_value' => '323'],
|
|
['emp_code' =>'BNF3871','bene_form_key' =>'3','checkup_form_value' => '446'],
|
|
['emp_code' =>'BNF3872','bene_form_key' =>'3','checkup_form_value' => '356'],
|
|
['emp_code' =>'BNF3871','bene_form_key' =>'3','checkup_form_value' => '2482'],
|
|
['emp_code' =>'BNF3869','bene_form_key' =>'3','checkup_form_value' => '2567'],
|
|
['emp_code' =>'BNF3865','bene_form_key' =>'3','checkup_form_value' => '150'],
|
|
['emp_code' =>'BNF3862','bene_form_key' =>'3','checkup_form_value' => '67'],
|
|
['emp_code' =>'BNF3858','bene_form_key' =>'3','checkup_form_value' => '67'],
|
|
['emp_code' =>'BNF3856','bene_form_key' =>'3','checkup_form_value' => '54'],
|
|
['emp_code' =>'BNF3855','bene_form_key' =>'3','checkup_form_value' => '54'],
|
|
['emp_code' =>'BNF3854','bene_form_key' =>'3','checkup_form_value' => '2801'],
|
|
['emp_code' =>'BNF3853','bene_form_key' =>'3','checkup_form_value' => '1589'],
|
|
['emp_code' =>'BNF3850','bene_form_key' =>'3','checkup_form_value' => '1151'],
|
|
['emp_code' =>'BNF3848','bene_form_key' =>'3','checkup_form_value' => '52'],
|
|
['emp_code' =>'BNF3847','bene_form_key' =>'3','checkup_form_value' => '315'],
|
|
['emp_code' =>'BNF3846','bene_form_key' =>'3','checkup_form_value' => '503'],
|
|
['emp_code' =>'BNF3845','bene_form_key' =>'3','checkup_form_value' => '1064'],
|
|
['emp_code' =>'BNF3844','bene_form_key' =>'3','checkup_form_value' => '123'],
|
|
['emp_code' =>'BNF3843','bene_form_key' =>'3','checkup_form_value' => '1486'],
|
|
['emp_code' =>'BNF3842','bene_form_key' =>'3','checkup_form_value' => '268'],
|
|
['emp_code' =>'BNF3841','bene_form_key' =>'3','checkup_form_value' => '268'],
|
|
['emp_code' =>'BNF3840','bene_form_key' =>'3','checkup_form_value' => '546'],
|
|
['emp_code' =>'BNF3827','bene_form_key' =>'3','checkup_form_value' => '320'],
|
|
['emp_code' =>'BNF3818','bene_form_key' =>'3','checkup_form_value' => '1686'],
|
|
['emp_code' =>'BNF3815','bene_form_key' =>'3','checkup_form_value' => '290'],
|
|
['emp_code' =>'BNF3814','bene_form_key' =>'3','checkup_form_value' => '314'],
|
|
['emp_code' =>'BNF3813','bene_form_key' =>'3','checkup_form_value' => '944'],
|
|
['emp_code' =>'BNF3812','bene_form_key' =>'3','checkup_form_value' => '944'],
|
|
['emp_code' =>'BNF3811','bene_form_key' =>'3','checkup_form_value' => '944'],
|
|
['emp_code' =>'BNF3810','bene_form_key' =>'3','checkup_form_value' => '79'],
|
|
['emp_code' =>'BNF3809','bene_form_key' =>'3','checkup_form_value' => '79'],
|
|
['emp_code' =>'BNF3808','bene_form_key' =>'3','checkup_form_value' => '424'],
|
|
['emp_code' =>'BNF3807','bene_form_key' =>'3','checkup_form_value' => '424'],
|
|
['emp_code' =>'BNF3807','bene_form_key' =>'3','checkup_form_value' => '468'],
|
|
['emp_code' =>'BNF3806','bene_form_key' =>'3','checkup_form_value' => '468'],
|
|
['emp_code' =>'BNF3804','bene_form_key' =>'3','checkup_form_value' => '1529'],
|
|
['emp_code' =>'BNF3803','bene_form_key' =>'3','checkup_form_value' => '1849'],
|
|
['emp_code' =>'BNF3802','bene_form_key' =>'3','checkup_form_value' => '1268'],
|
|
['emp_code' =>'BNF3802','bene_form_key' =>'3','checkup_form_value' => '1267'],
|
|
['emp_code' =>'BNF3801','bene_form_key' =>'3','checkup_form_value' => '343'],
|
|
['emp_code' =>'BNF3800','bene_form_key' =>'3','checkup_form_value' => '180'],
|
|
['emp_code' =>'BNF3799','bene_form_key' =>'3','checkup_form_value' => '455'],
|
|
['emp_code' =>'BNF3798','bene_form_key' =>'3','checkup_form_value' => '448'],
|
|
['emp_code' =>'BNF3794','bene_form_key' =>'3','checkup_form_value' => '381'],
|
|
['emp_code' =>'BNF3797','bene_form_key' =>'3','checkup_form_value' => '301'],
|
|
['emp_code' =>'BNF3796','bene_form_key' =>'3','checkup_form_value' => '301'],
|
|
['emp_code' =>'BNF3795','bene_form_key' =>'3','checkup_form_value' => '301'],
|
|
['emp_code' =>'BNF3794','bene_form_key' =>'3','checkup_form_value' => '301'],
|
|
['emp_code' =>'BNF3793','bene_form_key' =>'3','checkup_form_value' => '301'],
|
|
['emp_code' =>'BNF3792','bene_form_key' =>'3','checkup_form_value' => '22'],
|
|
['emp_code' =>'BNF3791','bene_form_key' =>'3','checkup_form_value' => '127'],
|
|
['emp_code' =>'BNF3790','bene_form_key' =>'3','checkup_form_value' => '127'],
|
|
['emp_code' =>'BNF3789','bene_form_key' =>'3','checkup_form_value' => '127'],
|
|
['emp_code' =>'BNF3788','bene_form_key' =>'3','checkup_form_value' => '301'],
|
|
['emp_code' =>'BNF3787','bene_form_key' =>'3','checkup_form_value' => '127'],
|
|
['emp_code' =>'BNF3786','bene_form_key' =>'3','checkup_form_value' => '491'],
|
|
['emp_code' =>'BNF3785','bene_form_key' =>'3','checkup_form_value' => '447'],
|
|
['emp_code' =>'BNF3784','bene_form_key' =>'3','checkup_form_value' => '53'],
|
|
['emp_code' =>'BNF3782','bene_form_key' =>'3','checkup_form_value' => '53'],
|
|
['emp_code' =>'BNF3783','bene_form_key' =>'3','checkup_form_value' => '190'],
|
|
['emp_code' =>'BNF3782','bene_form_key' =>'3','checkup_form_value' => '190'],
|
|
['emp_code' =>'BNF3781','bene_form_key' =>'3','checkup_form_value' => '1697'],
|
|
['emp_code' =>'BNF3779','bene_form_key' =>'3','checkup_form_value' => '24'],
|
|
['emp_code' =>'BNF3778','bene_form_key' =>'3','checkup_form_value' => '24'],
|
|
['emp_code' =>'BNF3777','bene_form_key' =>'3','checkup_form_value' => '2402'],
|
|
['emp_code' =>'BNF3776','bene_form_key' =>'3','checkup_form_value' => '1848'],
|
|
['emp_code' =>'BNF3773','bene_form_key' =>'3','checkup_form_value' => '119'],
|
|
['emp_code' =>'BNF3772','bene_form_key' =>'3','checkup_form_value' => '26'],
|
|
['emp_code' =>'BNF3771','bene_form_key' =>'3','checkup_form_value' => '241'],
|
|
['emp_code' =>'BNF3770','bene_form_key' =>'3','checkup_form_value' => '241'],
|
|
['emp_code' =>'BNF3769','bene_form_key' =>'3','checkup_form_value' => '465'],
|
|
['emp_code' =>'BNF3769','bene_form_key' =>'3','checkup_form_value' => '371'],
|
|
['emp_code' =>'BNF3768','bene_form_key' =>'3','checkup_form_value' => '2548'],
|
|
['emp_code' =>'BNF3767','bene_form_key' =>'3','checkup_form_value' => '1180'],
|
|
['emp_code' =>'BNF3765','bene_form_key' =>'3','checkup_form_value' => '983'],
|
|
['emp_code' =>'BNF3764','bene_form_key' =>'3','checkup_form_value' => '983'],
|
|
['emp_code' =>'BNF3760','bene_form_key' =>'3','checkup_form_value' => '619'],
|
|
['emp_code' =>'BNF3755','bene_form_key' =>'3','checkup_form_value' => '294'],
|
|
['emp_code' =>'BNF3753','bene_form_key' =>'3','checkup_form_value' => '864'],
|
|
['emp_code' =>'BNF3752','bene_form_key' =>'3','checkup_form_value' => '207'],
|
|
['emp_code' =>'BNF3751','bene_form_key' =>'3','checkup_form_value' => '2151'],
|
|
['emp_code' =>'BNF3750','bene_form_key' =>'3','checkup_form_value' => '2150'],
|
|
['emp_code' =>'BNF3749','bene_form_key' =>'3','checkup_form_value' => '2149'],
|
|
['emp_code' =>'BNF3748','bene_form_key' =>'3','checkup_form_value' => '2152'],
|
|
['emp_code' =>'BNF3745','bene_form_key' =>'3','checkup_form_value' => '47'],
|
|
['emp_code' =>'BNF3744','bene_form_key' =>'3','checkup_form_value' => '1839'],
|
|
['emp_code' =>'BNF3743','bene_form_key' =>'3','checkup_form_value' => '2476'],
|
|
['emp_code' =>'BNF3742','bene_form_key' =>'3','checkup_form_value' => '1979'],
|
|
['emp_code' =>'BNF3741','bene_form_key' =>'3','checkup_form_value' => '1979'],
|
|
['emp_code' =>'BNF3740','bene_form_key' =>'3','checkup_form_value' => '2481'],
|
|
['emp_code' =>'BNF3739','bene_form_key' =>'3','checkup_form_value' => '1978'],
|
|
['emp_code' =>'BNF3738','bene_form_key' =>'3','checkup_form_value' => '1978'],
|
|
['emp_code' =>'BNF3737','bene_form_key' =>'3','checkup_form_value' => '37'],
|
|
['emp_code' =>'BNF3736','bene_form_key' =>'3','checkup_form_value' => '37'],
|
|
['emp_code' =>'BNF3725','bene_form_key' =>'3','checkup_form_value' => '53'],
|
|
['emp_code' =>'BNF3722','bene_form_key' =>'3','checkup_form_value' => '1254'],
|
|
['emp_code' =>'BNF3721','bene_form_key' =>'3','checkup_form_value' => '1254'],
|
|
['emp_code' =>'BNF3720','bene_form_key' =>'3','checkup_form_value' => '2627'],
|
|
['emp_code' =>'BNF3719','bene_form_key' =>'3','checkup_form_value' => '845'],
|
|
['emp_code' =>'BNF3718','bene_form_key' =>'3','checkup_form_value' => '845'],
|
|
['emp_code' =>'BNF3717','bene_form_key' =>'3','checkup_form_value' => '618'],
|
|
['emp_code' =>'BNF3716','bene_form_key' =>'3','checkup_form_value' => '1388'],
|
|
['emp_code' =>'BNF3713','bene_form_key' =>'3','checkup_form_value' => '412'],
|
|
['emp_code' =>'BNF3698','bene_form_key' =>'3','checkup_form_value' => '334'],
|
|
['emp_code' =>'BNF3694','bene_form_key' =>'3','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3693','bene_form_key' =>'3','checkup_form_value' => '52'],
|
|
['emp_code' =>'BNF3692','bene_form_key' =>'3','checkup_form_value' => '551'],
|
|
['emp_code' =>'BNF3691','bene_form_key' =>'3','checkup_form_value' => '548'],
|
|
['emp_code' =>'BNF3690','bene_form_key' =>'3','checkup_form_value' => '1116'],
|
|
['emp_code' =>'BNF3689','bene_form_key' =>'3','checkup_form_value' => '281'],
|
|
['emp_code' =>'BNF3686','bene_form_key' =>'3','checkup_form_value' => '1287'],
|
|
['emp_code' =>'BNF3685','bene_form_key' =>'3','checkup_form_value' => '1107'],
|
|
|
|
];
|
|
|
|
foreach ($excelData as $row) {
|
|
$emp_code = $conn->real_escape_string($row['emp_code']);
|
|
$bene_form_key = $conn->real_escape_string($row['bene_form_key']);
|
|
$checkup_form_value = $conn->real_escape_string($row['checkup_form_value']);
|
|
|
|
|
|
$result = $conn->query("SELECT id FROM patient_master WHERE emp_code = '$emp_code' and beneficiary_type='CSR' and ohc_type_id='1'");
|
|
if ($result->num_rows > 0) {
|
|
$patient = $result->fetch_assoc();
|
|
$patient_id = $patient['id'];
|
|
|
|
|
|
$check = $conn->query("SELECT bene_key_id FROM beneficiary_form_key_value WHERE bene_detail_id = '$patient_id' AND bene_form_key = '$bene_form_key'");
|
|
|
|
if ($check->num_rows > 0) {
|
|
|
|
$conn->query("UPDATE beneficiary_form_key_value
|
|
SET checkup_form_value = '$checkup_form_value', last_modified = NOW()
|
|
WHERE bene_detail_id = '$patient_id' AND bene_form_key = '$bene_form_key'");
|
|
} else {
|
|
|
|
$conn->query("INSERT INTO beneficiary_form_key_value (bene_detail_id, bene_form_key, checkup_form_value)
|
|
VALUES ('$patient_id', '$bene_form_key', '$checkup_form_value')");
|
|
}
|
|
}
|
|
}
|
|
|
|
echo "Data processed successfully!";
|
|
?>
|