337 lines
23 KiB
PHP
337 lines
23 KiB
PHP
<?php
|
|
|
|
include('includes/config/config.php');
|
|
|
|
//farmer Record
|
|
|
|
|
|
|
|
$excelData = [
|
|
['emp_code' =>'BNF5588','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF5183','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4206','bene_form_key' =>'7','checkup_form_value' => '7'],
|
|
['emp_code' =>'BNF4111','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4110','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4109','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4107','bene_form_key' =>'7','checkup_form_value' => '25'],
|
|
['emp_code' =>'BNF4105','bene_form_key' =>'7','checkup_form_value' => '7'],
|
|
['emp_code' =>'BNF4104','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF4103','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF4101','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF4099','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4098','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF4097','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF4096','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF4095','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF4094','bene_form_key' =>'7','checkup_form_value' => '24'],
|
|
['emp_code' =>'BNF4092','bene_form_key' =>'7','checkup_form_value' => '7'],
|
|
['emp_code' =>'BNF4091','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF4090','bene_form_key' =>'7','checkup_form_value' => '8'],
|
|
['emp_code' =>'BNF4089','bene_form_key' =>'7','checkup_form_value' => '10'],
|
|
['emp_code' =>'BNF4088','bene_form_key' =>'7','checkup_form_value' => '10'],
|
|
['emp_code' =>'BNF4087','bene_form_key' =>'7','checkup_form_value' => '10'],
|
|
['emp_code' =>'BNF4086','bene_form_key' =>'7','checkup_form_value' => '26'],
|
|
['emp_code' =>'BNF4086','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF4085','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF4084','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF4083','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF4082','bene_form_key' =>'7','checkup_form_value' => '11'],
|
|
['emp_code' =>'BNF4081','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF4080','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4079','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF4078','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4077','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4076','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4075','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF4066','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4065','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF4064','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF4063','bene_form_key' =>'7','checkup_form_value' => '11'],
|
|
['emp_code' =>'BNF4062','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF4061','bene_form_key' =>'7','checkup_form_value' => '11'],
|
|
['emp_code' =>'BNF4060','bene_form_key' =>'7','checkup_form_value' => '11'],
|
|
['emp_code' =>'BNF4058','bene_form_key' =>'7','checkup_form_value' => '10'],
|
|
['emp_code' =>'BNF4057','bene_form_key' =>'7','checkup_form_value' => '8'],
|
|
['emp_code' =>'BNF4056','bene_form_key' =>'7','checkup_form_value' => '13'],
|
|
['emp_code' =>'BNF4056','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF4055','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF4054','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF4053','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF4052','bene_form_key' =>'7','checkup_form_value' => '7'],
|
|
['emp_code' =>'BNF4051','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4050','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF4049','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4048','bene_form_key' =>'7','checkup_form_value' => '19'],
|
|
['emp_code' =>'BNF4047','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF4045','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4042','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF4041','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF4040','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF4039','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF4034','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4031','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF4030','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF4030','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF4029','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF4028','bene_form_key' =>'7','checkup_form_value' => '10'],
|
|
['emp_code' =>'BNF4027','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF4026','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF4025','bene_form_key' =>'7','checkup_form_value' => '12'],
|
|
['emp_code' =>'BNF4024','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF4024','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4023','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4022','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF4022','bene_form_key' =>'7','checkup_form_value' => '8'],
|
|
['emp_code' =>'BNF4021','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4020','bene_form_key' =>'7','checkup_form_value' => '13'],
|
|
['emp_code' =>'BNF4019','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF4019','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF4018','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF4017','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF4016','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4015','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF4014','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF4014','bene_form_key' =>'7','checkup_form_value' => '8'],
|
|
['emp_code' =>'BNF4013','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF4012','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4011','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4010','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF4005','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF4004','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF4001','bene_form_key' =>'7','checkup_form_value' => '11'],
|
|
['emp_code' =>'BNF4000','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF3997','bene_form_key' =>'7','checkup_form_value' => '11'],
|
|
['emp_code' =>'BNF3996','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3995','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3994','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF3993','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3993','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF3992','bene_form_key' =>'7','checkup_form_value' => '16'],
|
|
['emp_code' =>'BNF3991','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3987','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3986','bene_form_key' =>'7','checkup_form_value' => '42'],
|
|
['emp_code' =>'BNF3985','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3984','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3983','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3980','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF3979','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF3979','bene_form_key' =>'7','checkup_form_value' => '28'],
|
|
['emp_code' =>'BNF3978','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3977','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3976','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF3975','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF3974','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF3973','bene_form_key' =>'7','checkup_form_value' => '8'],
|
|
['emp_code' =>'BNF3972','bene_form_key' =>'7','checkup_form_value' => '10'],
|
|
['emp_code' =>'BNF3971','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF3970','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3969','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3968','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3968','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3967','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3964','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3963','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3962','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3961','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3960','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3960','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3959','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3958','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3957','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3956','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3955','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3954','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3953','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF3951','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3950','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3949','bene_form_key' =>'7','checkup_form_value' => '7'],
|
|
['emp_code' =>'BNF3948','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3947','bene_form_key' =>'7','checkup_form_value' => '7'],
|
|
['emp_code' =>'BNF3946','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF3943','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3942','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF3940','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF3937','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF3936','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3935','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3934','bene_form_key' =>'7','checkup_form_value' => '13'],
|
|
['emp_code' =>'BNF3933','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3932','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3931','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3930','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3929','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3928','bene_form_key' =>'7','checkup_form_value' => '11'],
|
|
['emp_code' =>'BNF3927','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3926','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3925','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF3924','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF3922','bene_form_key' =>'7','checkup_form_value' => '7'],
|
|
['emp_code' =>'BNF3921','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3920','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3919','bene_form_key' =>'7','checkup_form_value' => '7'],
|
|
['emp_code' =>'BNF3918','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF3917','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3915','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3914','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3913','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3912','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF3911','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF3910','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3908','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3907','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3906','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF3904','bene_form_key' =>'7','checkup_form_value' => '11'],
|
|
['emp_code' =>'BNF3903','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF3900','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF3900','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3899','bene_form_key' =>'7','checkup_form_value' => '7'],
|
|
['emp_code' =>'BNF3898','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF3897','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3896','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3895','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3894','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3893','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3871','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3872','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3871','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3869','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3865','bene_form_key' =>'7','checkup_form_value' => '16'],
|
|
['emp_code' =>'BNF3862','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3858','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3856','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3855','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3854','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3853','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3850','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3848','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF3847','bene_form_key' =>'7','checkup_form_value' => '7'],
|
|
['emp_code' =>'BNF3846','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3845','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3844','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF3843','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF3842','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3841','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3840','bene_form_key' =>'7','checkup_form_value' => '13'],
|
|
['emp_code' =>'BNF3827','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF3818','bene_form_key' =>'7','checkup_form_value' => '8'],
|
|
['emp_code' =>'BNF3815','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3814','bene_form_key' =>'7','checkup_form_value' => '12'],
|
|
['emp_code' =>'BNF3813','bene_form_key' =>'7','checkup_form_value' => '9'],
|
|
['emp_code' =>'BNF3812','bene_form_key' =>'7','checkup_form_value' => '9'],
|
|
['emp_code' =>'BNF3811','bene_form_key' =>'7','checkup_form_value' => '9'],
|
|
['emp_code' =>'BNF3810','bene_form_key' =>'7','checkup_form_value' => '11'],
|
|
['emp_code' =>'BNF3809','bene_form_key' =>'7','checkup_form_value' => '11'],
|
|
['emp_code' =>'BNF3808','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3807','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3807','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF3806','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF3804','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF3803','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF3802','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3802','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3801','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3800','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3799','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF3798','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF3794','bene_form_key' =>'7','checkup_form_value' => '7'],
|
|
['emp_code' =>'BNF3797','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF3796','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF3795','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF3794','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF3793','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF3792','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF3791','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3790','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3789','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3788','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF3787','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF3786','bene_form_key' =>'7','checkup_form_value' => '7'],
|
|
['emp_code' =>'BNF3785','bene_form_key' =>'7','checkup_form_value' => '9'],
|
|
['emp_code' =>'BNF3784','bene_form_key' =>'7','checkup_form_value' => '17'],
|
|
['emp_code' =>'BNF3782','bene_form_key' =>'7','checkup_form_value' => '17'],
|
|
['emp_code' =>'BNF3783','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF3782','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF3781','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3779','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3778','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3777','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3776','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3773','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3772','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3771','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3770','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3769','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3769','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3768','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3767','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3765','bene_form_key' =>'7','checkup_form_value' => '8'],
|
|
['emp_code' =>'BNF3764','bene_form_key' =>'7','checkup_form_value' => '8'],
|
|
['emp_code' =>'BNF3760','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3755','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF3753','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3752','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3751','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3750','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3749','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3748','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3745','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF3744','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3743','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF3742','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3741','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3740','bene_form_key' =>'7','checkup_form_value' => '4'],
|
|
['emp_code' =>'BNF3739','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF3738','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF3737','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3736','bene_form_key' =>'7','checkup_form_value' => '2'],
|
|
['emp_code' =>'BNF3725','bene_form_key' =>'7','checkup_form_value' => '17'],
|
|
['emp_code' =>'BNF3722','bene_form_key' =>'7','checkup_form_value' => '14'],
|
|
['emp_code' =>'BNF3721','bene_form_key' =>'7','checkup_form_value' => '14'],
|
|
['emp_code' =>'BNF3720','bene_form_key' =>'7','checkup_form_value' => '14'],
|
|
['emp_code' =>'BNF3719','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF3718','bene_form_key' =>'7','checkup_form_value' => '6'],
|
|
['emp_code' =>'BNF3717','bene_form_key' =>'7','checkup_form_value' => '8'],
|
|
['emp_code' =>'BNF3716','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3713','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3698','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3694','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF3693','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3692','bene_form_key' =>'7','checkup_form_value' => '1'],
|
|
['emp_code' =>'BNF3691','bene_form_key' =>'7','checkup_form_value' => '21'],
|
|
['emp_code' =>'BNF3690','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
['emp_code' =>'BNF3689','bene_form_key' =>'7','checkup_form_value' => '10'],
|
|
['emp_code' =>'BNF3686','bene_form_key' =>'7','checkup_form_value' => '5'],
|
|
['emp_code' =>'BNF3685','bene_form_key' =>'7','checkup_form_value' => '3'],
|
|
|
|
];
|
|
|
|
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!";
|
|
?>
|