turkey_792_3.cif 7.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229
  1. <?php
  2. /**
  3. * Implements hook_install() using the name of the country as the base of
  4. * the function name.
  5. */
  6. function turkey_install() {
  7. // Make the entry in the country table.
  8. // VALUES = Country ID, Country Name, 2-digit Code, 3-digit Code, File Version
  9. db_insert('uc_countries')
  10. ->fields(array(
  11. 'country_id' => 792,
  12. 'country_name' => 'Turkey',
  13. 'country_iso_code_2' => 'TR',
  14. 'country_iso_code_3' => 'TUR',
  15. 'version' => 3,
  16. ))
  17. ->execute();
  18. // Make the entries in the zones table.
  19. $zones = array(
  20. array(792, 'TR-01', 'Adana'),
  21. array(792, 'TR-02', 'Adıyaman'),
  22. array(792, 'TR-03', 'Afyon'),
  23. array(792, 'TR-04', 'Ağrı'),
  24. array(792, 'TR-68', 'Aksaray'),
  25. array(792, 'TR-05', 'Amasya'),
  26. array(792, 'TR-06', 'Ankara'),
  27. array(792, 'TR-07', 'Antalya'),
  28. array(792, 'TR-75', 'Ardahan'),
  29. array(792, 'TR-08', 'Artvin'),
  30. array(792, 'TR-09', 'Aydın'),
  31. array(792, 'TR-10', 'Balıkesir'),
  32. array(792, 'TR-74', 'Bartın'),
  33. array(792, 'TR-72', 'Batman'),
  34. array(792, 'TR-69', 'Bayburt'),
  35. array(792, 'TR-11', 'Bilecik'),
  36. array(792, 'TR-12', 'Bingöl'),
  37. array(792, 'TR-13', 'Bitlis'),
  38. array(792, 'TR-14', 'Bolu'),
  39. array(792, 'TR-15', 'Burdur'),
  40. array(792, 'TR-16', 'Bursa'),
  41. array(792, 'TR-17', 'Çanakkale'),
  42. array(792, 'TR-18', 'Çankırı'),
  43. array(792, 'TR-19', 'Çorum'),
  44. array(792, 'TR-20', 'Denizli'),
  45. array(792, 'TR-21', 'Diyarbakır'),
  46. array(792, 'TR-81', 'Düzce'),
  47. array(792, 'TR-22', 'Edirne'),
  48. array(792, 'TR-23', 'Elazığ'),
  49. array(792, 'TR-24', 'Erzincan'),
  50. array(792, 'TR-25', 'Erzurum'),
  51. array(792, 'TR-26', 'Eskişehir'),
  52. array(792, 'TR-27', 'Gaziantep'),
  53. array(792, 'TR-28', 'Giresun'),
  54. array(792, 'TR-29', 'Gümüşhane'),
  55. array(792, 'TR-30', 'Hakkâri'),
  56. array(792, 'TR-31', 'Hatay'),
  57. array(792, 'TR-76', 'Iğdır'),
  58. array(792, 'TR-32', 'Isparta'),
  59. array(792, 'TR-33', 'İçel'),
  60. array(792, 'TR-34', 'İstanbul'),
  61. array(792, 'TR-35', 'İzmir'),
  62. array(792, 'TR-46', 'Kahramanmaraş'),
  63. array(792, 'TR-78', 'Karabük'),
  64. array(792, 'TR-70', 'Karaman'),
  65. array(792, 'TR-36', 'Kars'),
  66. array(792, 'TR-37', 'Kastamonu'),
  67. array(792, 'TR-38', 'Kayseri'),
  68. array(792, 'TR-71', 'Kırıkkale'),
  69. array(792, 'TR-39', 'Kırklareli'),
  70. array(792, 'TR-40', 'Kırşehir'),
  71. array(792, 'TR-79', 'Kilis'),
  72. array(792, 'TR-41', 'Kocaeli'),
  73. array(792, 'TR-42', 'Konya'),
  74. array(792, 'TR-43', 'Kütahya'),
  75. array(792, 'TR-44', 'Malatya'),
  76. array(792, 'TR-45', 'Manisa'),
  77. array(792, 'TR-47', 'Mardin'),
  78. array(792, 'TR-48', 'Muğla'),
  79. array(792, 'TR-49', 'Muş'),
  80. array(792, 'TR-50', 'Nevşehir'),
  81. array(792, 'TR-51', 'Niğde'),
  82. array(792, 'TR-52', 'Ordu'),
  83. array(792, 'TR-80', 'Osmaniye'),
  84. array(792, 'TR-53', 'Rize'),
  85. array(792, 'TR-54', 'Sakarya'),
  86. array(792, 'TR-55', 'Samsun'),
  87. array(792, 'TR-56', 'Siirt'),
  88. array(792, 'TR-57', 'Sinop'),
  89. array(792, 'TR-58', 'Sivas'),
  90. array(792, 'TR-63', 'Şanlıurfa'),
  91. array(792, 'TR-73', 'Şırnak'),
  92. array(792, 'TR-59', 'Tekirdağ'),
  93. array(792, 'TR-60', 'Tokat'),
  94. array(792, 'TR-61', 'Trabzon'),
  95. array(792, 'TR-62', 'Tunceli'),
  96. array(792, 'TR-64', 'Uşak'),
  97. array(792, 'TR-65', 'Van'),
  98. array(792, 'TR-77', 'Yalova'),
  99. array(792, 'TR-66', 'Yozgat'),
  100. array(792, 'TR-67', 'Zonguldak'),
  101. );
  102. $query = db_insert('uc_zones')->fields(array('zone_country_id', 'zone_code', 'zone_name'));
  103. foreach ($zones as $zone) {
  104. $query->values($zone);
  105. }
  106. $query->execute();
  107. // Set address format
  108. uc_set_address_format(
  109. 792,
  110. "!company\r\n".
  111. "!first_name !last_name\r\n".
  112. "!street1\r\n".
  113. "!street2\r\n".
  114. "!postal_code, !city\r\n".
  115. "!country_name_if"
  116. );
  117. }
  118. /**
  119. * Implements hook_update() with $version being the only argument.
  120. * Add a new case for each version update, and be sure to always include the
  121. * latest changes in the install function.
  122. */
  123. function turkey_update($version) {
  124. switch ($version) {
  125. case 2:
  126. db_update('uc_countries')
  127. ->fields(array('country_iso_code_2' => 'TR'))
  128. ->condition('country_id', 792)
  129. ->execute();
  130. break;
  131. case 3:
  132. $zones = array(
  133. array(792, 'TR-01', 'Adana'),
  134. array(792, 'TR-02', 'Adıyaman'),
  135. array(792, 'TR-03', 'Afyon'),
  136. array(792, 'TR-04', 'Ağrı'),
  137. array(792, 'TR-68', 'Aksaray'),
  138. array(792, 'TR-05', 'Amasya'),
  139. array(792, 'TR-06', 'Ankara'),
  140. array(792, 'TR-07', 'Antalya'),
  141. array(792, 'TR-75', 'Ardahan'),
  142. array(792, 'TR-08', 'Artvin'),
  143. array(792, 'TR-09', 'Aydın'),
  144. array(792, 'TR-10', 'Balıkesir'),
  145. array(792, 'TR-74', 'Bartın'),
  146. array(792, 'TR-72', 'Batman'),
  147. array(792, 'TR-69', 'Bayburt'),
  148. array(792, 'TR-11', 'Bilecik'),
  149. array(792, 'TR-12', 'Bingöl'),
  150. array(792, 'TR-13', 'Bitlis'),
  151. array(792, 'TR-14', 'Bolu'),
  152. array(792, 'TR-15', 'Burdur'),
  153. array(792, 'TR-16', 'Bursa'),
  154. array(792, 'TR-17', 'Çanakkale'),
  155. array(792, 'TR-18', 'Çankırı'),
  156. array(792, 'TR-19', 'Çorum'),
  157. array(792, 'TR-20', 'Denizli'),
  158. array(792, 'TR-21', 'Diyarbakır'),
  159. array(792, 'TR-81', 'Düzce'),
  160. array(792, 'TR-22', 'Edirne'),
  161. array(792, 'TR-23', 'Elazığ'),
  162. array(792, 'TR-24', 'Erzincan'),
  163. array(792, 'TR-25', 'Erzurum'),
  164. array(792, 'TR-26', 'Eskişehir'),
  165. array(792, 'TR-27', 'Gaziantep'),
  166. array(792, 'TR-28', 'Giresun'),
  167. array(792, 'TR-29', 'Gümüşhane'),
  168. array(792, 'TR-30', 'Hakkâri'),
  169. array(792, 'TR-31', 'Hatay'),
  170. array(792, 'TR-76', 'Iğdır'),
  171. array(792, 'TR-32', 'Isparta'),
  172. array(792, 'TR-33', 'İçel'),
  173. array(792, 'TR-34', 'İstanbul'),
  174. array(792, 'TR-35', 'İzmir'),
  175. array(792, 'TR-46', 'Kahramanmaraş'),
  176. array(792, 'TR-78', 'Karabük'),
  177. array(792, 'TR-70', 'Karaman'),
  178. array(792, 'TR-36', 'Kars'),
  179. array(792, 'TR-37', 'Kastamonu'),
  180. array(792, 'TR-38', 'Kayseri'),
  181. array(792, 'TR-71', 'Kırıkkale'),
  182. array(792, 'TR-39', 'Kırklareli'),
  183. array(792, 'TR-40', 'Kırşehir'),
  184. array(792, 'TR-79', 'Kilis'),
  185. array(792, 'TR-41', 'Kocaeli'),
  186. array(792, 'TR-42', 'Konya'),
  187. array(792, 'TR-43', 'Kütahya'),
  188. array(792, 'TR-44', 'Malatya'),
  189. array(792, 'TR-45', 'Manisa'),
  190. array(792, 'TR-47', 'Mardin'),
  191. array(792, 'TR-48', 'Muğla'),
  192. array(792, 'TR-49', 'Muş'),
  193. array(792, 'TR-50', 'Nevşehir'),
  194. array(792, 'TR-51', 'Niğde'),
  195. array(792, 'TR-52', 'Ordu'),
  196. array(792, 'TR-80', 'Osmaniye'),
  197. array(792, 'TR-53', 'Rize'),
  198. array(792, 'TR-54', 'Sakarya'),
  199. array(792, 'TR-55', 'Samsun'),
  200. array(792, 'TR-56', 'Siirt'),
  201. array(792, 'TR-57', 'Sinop'),
  202. array(792, 'TR-58', 'Sivas'),
  203. array(792, 'TR-63', 'Şanlıurfa'),
  204. array(792, 'TR-73', 'Şırnak'),
  205. array(792, 'TR-59', 'Tekirdağ'),
  206. array(792, 'TR-60', 'Tokat'),
  207. array(792, 'TR-61', 'Trabzon'),
  208. array(792, 'TR-62', 'Tunceli'),
  209. array(792, 'TR-64', 'Uşak'),
  210. array(792, 'TR-65', 'Van'),
  211. array(792, 'TR-77', 'Yalova'),
  212. array(792, 'TR-66', 'Yozgat'),
  213. array(792, 'TR-67', 'Zonguldak'),
  214. );
  215. $query = db_insert('uc_zones')->fields(array('zone_country_id', 'zone_code', 'zone_name'));
  216. foreach ($zones as $zone) {
  217. $query->values($zone);
  218. }
  219. $query->execute();
  220. break;
  221. }
  222. }