/app/administration/practice/data_read.ejs.php

https://github.com/tagcool/MitosEHR-Official · PHP · 145 lines · 108 code · 9 blank · 28 comment · 5 complexity · 7d1e15661faa3ee72a4accbefb5616f6 MD5 · raw file 

    

  1. <?php
    2. 

  2. //--------------------------------------------------------------------------------------------------------------------------
    3. 

  3. // data_read.ejs.php / Permissions List with values for role
    4. 

  4. // v0.0.1
    5. 

  5. // Under GPLv3 License
    6. 

  6. // Integrated by: Ernesto Rodriguez
    7. 

  7. // Remember, this file is called via the Framework Store, this is the AJAX thing.
    8. 

  8. //--------------------------------------------------------------------------------------------------------------------------
    9. 

  9. session_name ( "MitosEHR" );
    10. 

  10. session_start();
    11. 

  11. session_cache_limiter('private');
    12. 

  12. 

  13. include_once($_SESSION['site']['root']."/classes/dbHelper.class.php");
    14. 

  14. include_once($_SESSION['site']['root']."/classes/I18n.class.php");
    15. 

  15. require_once($_SESSION['site']['root']."/classes/dataExchange.class.php");
    16. 

  16. 

  17. //******************************************************************************
    18. 

  18. // Reset session count 10 secs = 1 Flop
    19. 

  19. //******************************************************************************
    20. 

  20. $_SESSION['site']['flops'] = 0;
    21. 

  21. 

  22. //------------------------------------------
    23. 

  23. // Database class instance
    24. 

  24. //------------------------------------------
    25. 

  25. $mitos_db = new dbHelper();
    26. 

  26. 

  27. $start = ($_REQUEST["start"] == null)? 0 : $_REQUEST["start"];
    28. 

  28. $count = ($_REQUEST["limit"] == null)? 10 : $_REQUEST["limit"];
    29. 

  29. //---------------------------------------------------------------------------------------
    30. 

  30. // start the array
    31. 

  31. //---------------------------------------------------------------------------------------
    32. 

  32. $rows = array();
    33. 

  33. switch ($_GET['task']) {
    34. 

  34. 	//**********************************************************************
    35. 

  35. 	// SQL for parmacies, pharmacy address, and phone numbers
    36. 

  36. 	//**********************************************************************
    37. 

  37. 	case "pharmacy":
    38. 

  38. 		//******************************************************************
    39. 

  39. 		// Lets get the pharmacies and address and order by name
    40. 

  40. 		//******************************************************************
    41. 

  41. 		$mitos_db->setSQL("SELECT pharmacies.id, 
    42. 

  42. 								  pharmacies.name,
    43. 

  43. 								  pharmacies.transmit_method,
    44. 

  44. 								  pharmacies.email,
    45. 

  45. 								  addresses.id AS address_id,
    46. 

  46. 								  addresses.line1,
    47. 

  47. 								  addresses.line2,
    48. 

  48. 								  addresses.city,
    49. 

  49. 								  addresses.state,
    50. 

  50. 								  addresses.zip,
    51. 

  51. 								  addresses.plus_four,
    52. 

  52. 								  addresses.country,
    53. 

  53. 								  addresses.foreign_id AS address_foreign_id
    54. 

  54. 			  				 FROM pharmacies
    55. 

  55. 	  					LEFT JOIN addresses ON pharmacies.id = addresses.foreign_id
    56. 

  56. 	  		 			 ORDER BY pharmacies.name DESC");
    57. 

  57. 		$total = $mitos_db->rowCount();
    58. 

  58. 		
    59. 

  59. 		foreach($mitos_db->execStatement(PDO::FETCH_ASSOC) as $row){
    60. 

  60. 			$mitos_db->setSQL("SELECT * FROM phone_numbers WHERE phone_numbers.foreign_id =".$row['id']."");
    61. 

  61. 			foreach ($mitos_db->execStatement(PDO::FETCH_ASSOC) as $phoneRow) {
    62. 

  62. 				switch ($phoneRow['type']) {
    63. 

  63. 					case "2":
    64. 

  64.                         $row['phone_id'] 	        = $phoneRow['id'];
    65. 

  65. 						$row['phone_country_code'] 	= $phoneRow['country_code'];
    66. 

  66.                         $row['phone_area_code'] 	= $phoneRow['area_code'];
    67. 

  67. 						$row['phone_prefix'] 		= $phoneRow['prefix'];
    68. 

  68. 						$row['phone_number'] 		= $phoneRow['number'];
    69. 

  69. 						$row['phone_full'] 			= $phoneRow['country_code'].' '.$phoneRow['area_code'].'-'.$phoneRow['prefix'].'-'.$phoneRow['number'];
    70. 

  70. 						
    71. 

  71. 					break;
    72. 

  72. 					case "5":
    73. 

  73.                         $row['fax_id'] 	            = $phoneRow['id'];
    74. 

  74. 						$row['fax_country_code'] 	= $phoneRow['country_code'];
    75. 

  75.                         $row['fax_area_code'] 		= $phoneRow['area_code'];
    76. 

  76. 						$row['fax_prefix'] 			= $phoneRow['prefix'];
    77. 

  77. 						$row['fax_number'] 			= $phoneRow['number'];
    78. 

  78. 						$row['fax_full'] 			= $phoneRow['country_code'].' '.$phoneRow['area_code'].'-'.$phoneRow['prefix'].'-'.$phoneRow['number'];
    79. 

  79. 					break;
    80. 

  80. 				}	
    81. 

  81. 			}
    82. 

  82. 			$row['address_full'] = $row['line1'].' '.$row['line2'].' '.$row['city'].','.$row['state'].' '.$row['zip'].'-'.$row['plus_four'].' '.$row['country'];
    83. 

  83. 			array_push($rows, $row);
    84. 

  84. 		}
    85. 

  85. 	break;
    86. 

  86. 	//**********************************************************************
    87. 

  87. 	// SQL for insurances co., insurances co. address, and phone numbers
    88. 

  88. 	//**********************************************************************
    89. 

  89. 	case "insurance":
    90. 

  90. 		//******************************************************************
    91. 

  91. 		// Lets get the pharmacies and address and order by name
    92. 

  92. 		//******************************************************************
    93. 

  93. 		$mitos_db->setSQL("SELECT insurance_companies.id, 
    94. 

  94. 								  insurance_companies.name,
    95. 

  95. 								  insurance_companies.attn,
    96. 

  96. 								  insurance_companies.cms_id,
    97. 

  97. 								  insurance_companies.freeb_type,
    98. 

  98. 								  insurance_companies.x12_receiver_id,
    99. 

  99. 								  insurance_companies.x12_default_partner_id,
    100. 

  100. 								  insurance_companies.alt_cms_id,
    101. 

  101. 								  addresses.id AS address_id,
    102. 

  102. 								  addresses.line1,
    103. 

  103. 								  addresses.line2,
    104. 

  104. 								  addresses.city,
    105. 

  105. 								  addresses.state,
    106. 

  106. 								  addresses.zip,
    107. 

  107. 								  addresses.plus_four,
    108. 

  108. 								  addresses.country,
    109. 

  109. 								  addresses.foreign_id AS address_foreign_id
    110. 

  110. 			  				 FROM insurance_companies
    111. 

  111. 	  					LEFT JOIN addresses ON insurance_companies.id = addresses.foreign_id
    112. 

  112. 	  		 			 ORDER BY insurance_companies.name DESC");
    113. 

  113. 		$total = $mitos_db->rowCount();
    114. 

  114. 		
    115. 

  115. 		foreach($mitos_db->execStatement(PDO::FETCH_ASSOC) as $row){
    116. 

  116. 			$mitos_db->setSQL("SELECT * FROM phone_numbers WHERE phone_numbers.foreign_id =".$row['id']."");
    117. 

  117. 			foreach ($mitos_db->execStatement(PDO::FETCH_ASSOC) as $phoneRow) {
    118. 

  118. 				switch ($phoneRow['type']) {
    119. 

  119. 					case "2":
    120. 

  120.                         $row['phone_id'] 	        = $phoneRow['id'];
    121. 

  121. 						$row['phone_country_code'] 	= $phoneRow['country_code'];
    122. 

  122.                         $row['phone_area_code'] 	= $phoneRow['area_code'];
    123. 

  123. 						$row['phone_prefix'] 		= $phoneRow['prefix'];
    124. 

  124. 						$row['phone_number'] 		= $phoneRow['number'];
    125. 

  125. 						$row['phone_full'] 			= $phoneRow['country_code'].' '.$phoneRow['area_code'].'-'.$phoneRow['prefix'].'-'.$phoneRow['number'];
    126. 

  126. 

  127. 					break;
    128. 

  128. 					case "5":
    129. 

  129.                         $row['fax_id'] 	            = $phoneRow['id'];
    130. 

  130. 						$row['fax_country_code'] 	= $phoneRow['country_code'];
    131. 

  131.                         $row['fax_area_code'] 		= $phoneRow['area_code'];
    132. 

  132. 						$row['fax_prefix'] 			= $phoneRow['prefix'];
    133. 

  133. 						$row['fax_number'] 			= $phoneRow['number'];
    134. 

  134. 						$row['fax_full'] 			= $phoneRow['country_code'].' '.$phoneRow['area_code'].'-'.$phoneRow['prefix'].'-'.$phoneRow['number'];
    135. 

  135. 					break;
    136. 

  136. 				}	
    137. 

  137. 			}
    138. 

  138. 			$row['address_full'] = $row['line1'].' '.$row['line2'].' '.$row['city'].','.$row['state'].' '.$row['zip'].'-'.$row['plus_four'].' '.$row['country'];
    139. 

  139. 			array_push($rows, $row);
    140. 

  140. 		}
    141. 

  141. 	break;
    142. 

  142. }
    143. 

  143. print_r(json_encode(array('totals'=>$total,'row'=>$rows)));	
    144. 

  144. 

  145. ?>
    146.