| blob | 440efba9da4faaf6b0436f0b3c57b3933e046bb1 |
1 <?php
63 }
74 //echo $sql;
80 }
84 }
85 }
87 // if we generated an error, create an error return response
90 }
92 // otherwise, we create the right response
93 // with the state name
95 }
96 }
106 //echo $sql;
112 }
116 }
117 }
119 // if we generated an error, create an error return response
122 }
124 // otherwise, we create the right response
125 // with the state name
127 }
128 }
139 //echo $sql;
145 }
149 }
150 }
152 // if we generated an error, create an error return response
155 }
157 // otherwise, we create the right response
158 // with the state name
160 }
161 }
171 //echo $sql;
177 }
181 }
182 }
184 // if we generated an error, create an error return response
187 }
189 // otherwise, we create the right response
190 // with the state name
192 }
193 }
203 //echo $sql;
209 }
213 }
214 }
216 // if we generated an error, create an error return response
219 }
221 // otherwise, we create the right response
222 // with the state name
224 }
225 }
232 // if we generated an error, create an error return response
235 }
237 // otherwise, we create the right response
238 // with the state name
240 }
241 }
247 //unimplemented by OpenEMR
250 // if we generated an error, create an error return response
253 }
255 // otherwise, we create the right response
256 // with the state name
258 }
259 }
269 //echo $sql;
275 }
279 }
280 }
283 // preg_match("/^\((.*?)\)\s(.*?)\-(.*?)$/",$retval,$phone_parts);
287 // if we generated an error, create an error return response
290 }
292 // otherwise, we create the right response
293 // with the state name
295 }
296 }
306 //echo $sql;
312 }
316 }
317 }
320 // preg_match("/^\((.*?)\)\s(.*?)\-(.*?)$/",$retval,$phone_parts);
324 // if we generated an error, create an error return response
327 }
329 // otherwise, we create the right response
330 // with the state name
332 }
333 }
343 //echo $sql;
349 }
353 }
354 }
356 // if we generated an error, create an error return response
359 }
361 // otherwise, we create the right response
362 // with the state name
364 }
365 }
367 /**
368 * Returns a federal ein based on practice, payer, provider
369 * @key int practice identifier used in database, in OpenEMR practices are facilities
370 * @payerkey int database id of the insurance company
371 * @providekey int database id of the provider
372 */
388 //echo $sql;
395 }
400 }
401 }
403 // if we generated an error, create an error return response
406 }
408 // otherwise, we create the right response
409 // with the state name
411 }
412 }
428 //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)
429 $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";
430 //echo $sql;
437 }
442 }
443 }
445 //if there is an exact match or not match and only the default then set it here
448 }
450 //if the exact match was empty for a provider number reference the default which is 1 because the nifty query and sorting above
452 }
454 // if we generated an error, create an error return response
457 }
459 // otherwise, we create the right response
460 // with the state name
462 }
463 }
478 //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)
479 $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";
480 //echo $sql;
487 }
492 }
493 }
495 //if there is an exact match or not match and only the default then set it here
498 }
500 //if the exact match was empty for a provider number reference the default which is 1 because the nifty query and sorting above
502 }
504 // if we generated an error, create an error return response
507 }
509 // otherwise, we create the right response
510 // with the state name
512 }
513 }
528 //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)
529 $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";
530 //echo $sql;
537 }
542 }
543 }
547 }
549 //if the exact match was empty for a group number reference the default which is 1 because the nifty query and sorting above
551 }
554 // if we generated an error, create an error return response
557 }
559 // otherwise, we create the right response
560 // with the state name
562 }
563 }
578 //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)
579 $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";
580 //echo $sql;
587 }
592 }
593 }
595 //if there is an exact match or not match and only the default then set it here
598 }
600 //if the exact match was empty for a provider number reference the default which is 1 because the nifty query and sorting above
602 }
604 // if we generated an error, create an error return response
607 }
609 // otherwise, we create the right response
610 // with the state name
612 }
613 }
628 //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)
629 $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";
630 //echo $sql;
637 }
642 }
643 }
645 //if there is an exact match or not match and only the default then set it here
648 }
650 //if the exact match was empty for a provider number reference the default which is 1 because the nifty query and sorting above
652 }
654 // if we generated an error, create an error return response
657 }
659 // otherwise, we create the right response
660 // with the state name
662 }
663 }
674 //echo $sql;
681 }
686 }
687 }
689 // if we generated an error, create an error return response
692 }
694 // otherwise, we create the right response
695 // with the state name
697 }
698 }
714 //echo $sql;
721 }
726 }
727 }
729 // if we generated an error, create an error return response
732 }
734 // otherwise, we create the right response
735 // with the state name
737 }
738 }
741 }
744 //'FreeB.FBPractice.Name' => \&FreeB_FBPractice_Name,
745 //'FreeB.FBPractice.StreetAddress' => \&FreeB_FBPractice_StreetAddress,
746 //'FreeB.FBPractice.City' => \&FreeB_FBPractice_City,
747 //'FreeB.FBPractice.State' => \&FreeB_FBPractice_State,
748 //'FreeB.FBPractice.Zipcode' => \&FreeB_FBPractice_Zipcode,
749 //'FreeB.FBPractice.PhoneCountry' => \&FreeB_FBPractice_PhoneCountry,
750 //'FreeB.FBPractice.PhoneExtension' => \&FreeB_FBPractice_PhoneExtension,
751 //'FreeB.FBPractice.PhoneNumber' => \&FreeB_FBPractice_PhoneNumber,
752 //'FreeB.FBPractice.PhoneArea' => \&FreeB_FBPractice_PhoneArea,
753 //'FreeB.FBPractice.isAcceptsAssignment' => \&FreeB_FBPractice_isAcceptsAssignment,
754 //'FreeB.FBPractice.PracticeID' => \&FreeB_FBPractice_PracticeID,
755 //'FreeB.FBPractice.RenderingPracticeID' => \&FreeB_FBPractice_RenderingPracticeID,
756 //'FreeB.FBPractice.GroupID' => \&FreeB_FBPractice_GroupID,
757 //'FreeB.FBPractice.TIN' => \&FreeB_FBPractice_TIN,
758 //'FreeB.FBPractice.NPI' => \&FreeB_FBPractice_NPI,
759 //'FreeB.FBPractice.ProviderNumX12Type' => \&FreeB_FBPractice_ProviderNumX12Type,
760 //'FreeB.FBPractice.RenderingNumX12Type' => \&FreeB_FBPractice_RenderingNumX12Type,
761 //'FreeB.FBPractice.X12Id' => \&FreeB_FBPractice_X12Id,
765 ?>