| blob | 5d50bc53d5e61871191e4e115eeff61cd55fc5e1 |
1 <?php
53 }
64 //echo $sql;
70 }
74 }
75 }
77 // if we generated an error, create an error return response
80 }
82 // otherwise, we create the right response
83 // with the state name
85 }
86 }
96 //echo $sql;
102 }
106 }
107 }
109 // if we generated an error, create an error return response
112 }
114 // otherwise, we create the right response
115 // with the state name
117 }
118 }
129 //echo $sql;
135 }
139 }
140 }
142 // if we generated an error, create an error return response
145 }
147 // otherwise, we create the right response
148 // with the state name
150 }
151 }
161 //echo $sql;
167 }
171 }
172 }
174 // if we generated an error, create an error return response
177 }
179 // otherwise, we create the right response
180 // with the state name
182 }
183 }
193 //echo $sql;
199 }
203 }
204 }
206 // if we generated an error, create an error return response
209 }
211 // otherwise, we create the right response
212 // with the state name
214 }
215 }
222 // if we generated an error, create an error return response
225 }
227 // otherwise, we create the right response
228 // with the state name
230 }
231 }
237 //unimplemented by OpenEMR
240 // if we generated an error, create an error return response
243 }
245 // otherwise, we create the right response
246 // with the state name
248 }
249 }
259 //echo $sql;
265 }
269 }
270 }
275 // if we generated an error, create an error return response
278 }
280 // otherwise, we create the right response
281 // with the state name
283 }
284 }
294 //echo $sql;
300 }
304 }
305 }
311 // if we generated an error, create an error return response
314 }
316 // otherwise, we create the right response
317 // with the state name
319 }
320 }
330 //echo $sql;
336 }
340 }
341 }
343 // if we generated an error, create an error return response
346 }
348 // otherwise, we create the right response
349 // with the state name
351 }
352 }
354 /**
355 * Returns a federal ein based on practice, payer, provider
356 * @key int practice identifier used in database, in OpenEMR practices are facilities
357 * @payerkey int database id of the insurance company
358 * @providekey int database id of the provider
359 */
375 //echo $sql;
382 }
387 }
388 }
390 // if we generated an error, create an error return response
393 }
395 // otherwise, we create the right response
396 // with the state name
398 }
399 }
415 //this query gets the exact match or resorts to the default when no exact is found (default has a NULL value for insurance_company_id)
416 $sql = "SELECT * FROM insurance_numbers where (insurance_company_id = '$payerkey' OR insurance_company_id is NULL) AND provider_id = '$providerkey' order by insurance_company_id DESC";
417 //echo $sql;
424 }
429 }
430 }
432 //if there is an exact match or not match and only the default then set it here
435 }
437 //if the exact match was empty for a provider number reference the default which is 1 because the nifty query and sorting above
439 }
441 // if we generated an error, create an error return response
444 }
446 // otherwise, we create the right response
447 // with the state name
449 }
450 }
465 //this query gets the exact match or resorts to the default when no exact is found (default has a NULL value for insurance_company_id)
466 $sql = "SELECT * FROM insurance_numbers where (insurance_company_id = '$payerkey' OR insurance_company_id is NULL) AND provider_id = '$providerkey' order by insurance_company_id DESC";
467 //echo $sql;
474 }
479 }
480 }
484 }
486 //if the exact match was empty for a group number reference the default which is 1 because the nifty query and sorting above
488 }
491 // if we generated an error, create an error return response
494 }
496 // otherwise, we create the right response
497 // with the state name
499 }
500 }
516 //this query gets the exact match or resorts to the default when no exact is found (default has a NULL value for insurance_company_id)
517 $sql = "SELECT * FROM insurance_numbers where (insurance_company_id = '$payerkey' OR insurance_company_id is NULL) AND provider_id = '$providerkey' order by insurance_company_id DESC";
518 //echo $sql;
525 }
530 }
531 }
533 //if there is an exact match or not match and only the default then set it here
536 }
538 //if the exact match was empty for a provider number reference the default which is 1 because the nifty query and sorting above
540 }
542 // if we generated an error, create an error return response
545 }
547 // otherwise, we create the right response
548 // with the state name
550 }
551 }
562 //echo $sql;
569 }
574 }
575 }
577 // if we generated an error, create an error return response
580 }
582 // otherwise, we create the right response
583 // with the state name
585 }
586 }
588 }
591 //'FreeB.FBPractice.Name' => \&FreeB_FBPractice_Name,
592 //'FreeB.FBPractice.StreetAddress' => \&FreeB_FBPractice_StreetAddress,
593 //'FreeB.FBPractice.City' => \&FreeB_FBPractice_City,
594 //'FreeB.FBPractice.State' => \&FreeB_FBPractice_State,
595 //'FreeB.FBPractice.Zipcode' => \&FreeB_FBPractice_Zipcode,
596 //'FreeB.FBPractice.PhoneCountry' => \&FreeB_FBPractice_PhoneCountry,
597 //'FreeB.FBPractice.PhoneExtension' => \&FreeB_FBPractice_PhoneExtension,
598 //'FreeB.FBPractice.PhoneNumber' => \&FreeB_FBPractice_PhoneNumber,
599 //'FreeB.FBPractice.PhoneArea' => \&FreeB_FBPractice_PhoneArea,
600 //'FreeB.FBPractice.isAcceptsAssignment' => \&FreeB_FBPractice_isAcceptsAssignment,
601 //'FreeB.FBPractice.PracticeID' => \&FreeB_FBPractice_PracticeID,
602 //'FreeB.FBPractice.GroupID' => \&FreeB_FBPractice_GroupID,
603 //'FreeB.FBPractice.TIN' => \&FreeB_FBPractice_TIN,
604 //'FreeB.FBPractice.X12IdType' => \&FreeB_FBPractice_X12IdType,
605 //'FreeB.FBPractice.X12Id' => \&FreeB_FBPractice_X12Id,
608 ?>