france_250_1.cif 4.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138
  1. <?php
  2. function france_install() {
  3. // Make the entry in the country table.
  4. // VALUES = Country ID, Country Name, 2-digit Code, 3-digit Code, File Version
  5. db_insert('uc_countries')
  6. ->fields(array(
  7. 'country_id' => 250,
  8. 'country_name' => 'France',
  9. 'country_iso_code_2' => 'FR',
  10. 'country_iso_code_3' => 'FRA',
  11. 'version' => 1,
  12. ))
  13. ->execute();
  14. // Make the entries in the zones table.
  15. $zones = array(
  16. array(250, 'FR-01', 'Ain'),
  17. array(250, 'FR-02', 'Aisne'),
  18. array(250, 'FR-03', 'Allier'),
  19. array(250, 'FR-04', 'Alpes-de-Haute-Provence'),
  20. array(250, 'FR-05', 'Hautes-Alpes'),
  21. array(250, 'FR-06', 'Alpes-Maritimes'),
  22. array(250, 'FR-07', 'Ardèche'),
  23. array(250, 'FR-08', 'Ardennes'),
  24. array(250, 'FR-09', 'Ariège'),
  25. array(250, 'FR-10', 'Aube'),
  26. array(250, 'FR-11', 'Aude'),
  27. array(250, 'FR-12', 'Aveyron'),
  28. array(250, 'FR-13', 'Bouches-du-Rhône'),
  29. array(250, 'FR-14', 'Calvados'),
  30. array(250, 'FR-15', 'Cantal'),
  31. array(250, 'FR-16', 'Charente'),
  32. array(250, 'FR-17', 'Charente-Maritime'),
  33. array(250, 'FR-18', 'Cher'),
  34. array(250, 'FR-19', 'Corrèze'),
  35. array(250, 'FR-21', "Côte-d'Or"),
  36. array(250, 'FR-22', "Côtes-d'Armor"),
  37. array(250, 'FR-23', 'Creuse'),
  38. array(250, 'FR-24', 'Dordogne'),
  39. array(250, 'FR-25', 'Doubs'),
  40. array(250, 'FR-26', 'Drôme'),
  41. array(250, 'FR-27', 'Eure'),
  42. array(250, 'FR-28', 'Eure-et-Loir'),
  43. array(250, 'FR-29', 'Finistère'),
  44. array(250, 'FR-2A', 'Corse-du-Sud'),
  45. array(250, 'FR-2B', 'Haute-Corse'),
  46. array(250, 'FR-30', 'Gard'),
  47. array(250, 'FR-31', 'Haute-Garonne'),
  48. array(250, 'FR-32', 'Gers'),
  49. array(250, 'FR-33', 'Gironde'),
  50. array(250, 'FR-34', 'Hérault'),
  51. array(250, 'FR-35', 'Ille-et-Vilaine'),
  52. array(250, 'FR-36', 'Indre'),
  53. array(250, 'FR-37', 'Indre-et-Loire'),
  54. array(250, 'FR-38', 'Isère'),
  55. array(250, 'FR-39', 'Jura'),
  56. array(250, 'FR-40', 'Landes'),
  57. array(250, 'FR-41', 'Loir-et-Cher'),
  58. array(250, 'FR-42', 'Loire'),
  59. array(250, 'FR-43', 'Haute-Loire'),
  60. array(250, 'FR-44', 'Loire-Atlantique'),
  61. array(250, 'FR-45', 'Loiret'),
  62. array(250, 'FR-46', 'Lot'),
  63. array(250, 'FR-47', 'Lot-et-Garonne'),
  64. array(250, 'FR-48', 'Lozère'),
  65. array(250, 'FR-49', 'Maine-et-Loire'),
  66. array(250, 'FR-50', 'Manche'),
  67. array(250, 'FR-51', 'Marne'),
  68. array(250, 'FR-52', 'Haute-Marne'),
  69. array(250, 'FR-53', 'Mayenne'),
  70. array(250, 'FR-54', 'Meurthe-et-Moselle'),
  71. array(250, 'FR-55', 'Meuse'),
  72. array(250, 'FR-56', 'Morbihan'),
  73. array(250, 'FR-57', 'Moselle'),
  74. array(250, 'FR-58', 'Nièvre'),
  75. array(250, 'FR-59', 'Nord'),
  76. array(250, 'FR-60', 'Oise'),
  77. array(250, 'FR-61', 'Orne'),
  78. array(250, 'FR-62', 'Pas-de-Calais'),
  79. array(250, 'FR-63', 'Puy-de-Dôme'),
  80. array(250, 'FR-64', 'Pyrénées-Atlantiques'),
  81. array(250, 'FR-65', 'Hautes-Pyrénées'),
  82. array(250, 'FR-66', 'Pyrénées-Orientales'),
  83. array(250, 'FR-67', 'Bas-Rhin'),
  84. array(250, 'FR-68', 'Haut-Rhin'),
  85. array(250, 'FR-69', 'Rhône'),
  86. array(250, 'FR-70', 'Haute-Saône'),
  87. array(250, 'FR-71', 'Saône-et-Loire'),
  88. array(250, 'FR-72', 'Sarthe'),
  89. array(250, 'FR-73', 'Savoie'),
  90. array(250, 'FR-74', 'Haute-Savoie'),
  91. array(250, 'FR-75', 'Paris'),
  92. array(250, 'FR-76', 'Seine-Maritime'),
  93. array(250, 'FR-77', 'Seine-et-Marne'),
  94. array(250, 'FR-78', 'Yvelines'),
  95. array(250, 'FR-79', 'Deux-Sèvres'),
  96. array(250, 'FR-80', 'Somme'),
  97. array(250, 'FR-81', 'Tarn'),
  98. array(250, 'FR-82', 'Tarn-et-Garonne'),
  99. array(250, 'FR-83', 'Var'),
  100. array(250, 'FR-84', 'Vaucluse'),
  101. array(250, 'FR-85', 'Vendée'),
  102. array(250, 'FR-86', 'Vienne'),
  103. array(250, 'FR-87', 'Haute-Vienne'),
  104. array(250, 'FR-88', 'Vosges'),
  105. array(250, 'FR-89', 'Yonne'),
  106. array(250, 'FR-90', 'Territoire de Belfort'),
  107. array(250, 'FR-91', 'Essonne'),
  108. array(250, 'FR-92', 'Hauts-de-Seine'),
  109. array(250, 'FR-93', 'Seine-Saint-Denis'),
  110. array(250, 'FR-94', 'Val-de-Marne'),
  111. array(250, 'FR-95', "Val-d'Oise"),
  112. array(250, 'FR-NC', 'New Caledonia'),
  113. array(250, 'FR-PF', 'French Polynesia'),
  114. array(250, 'FR-PM', 'Saint-Pierre and Miquelon'),
  115. array(250, 'FR-TF', 'French Southern Territories'),
  116. array(250, 'FR-YT', 'Mayotte'),
  117. array(250, 'FR-WF', 'Wallis and Futuna'),
  118. );
  119. $query = db_insert('uc_zones')->fields(array('zone_country_id', 'zone_code', 'zone_name'));
  120. foreach ($zones as $zone) {
  121. $query->values($zone);
  122. }
  123. $query->execute();
  124. // Set address format
  125. uc_set_address_format(
  126. 250,
  127. "!company\r\n".
  128. "!first_name !last_name\r\n".
  129. "!street1\r\n".
  130. "!street2\r\n".
  131. "!postal_code !city\r\n".
  132. "!country_name_if"
  133. );
  134. }