taiwan_158_2.cif 3.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105
  1. <?php
  2. /**
  3. * Implements hook_install() using the name of the country as the base of
  4. * the function name.
  5. */
  6. function taiwan_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' => 158,
  12. 'country_name' => 'Taiwan, Province of China',
  13. 'country_iso_code_2' => 'TW',
  14. 'country_iso_code_3' => 'TWN',
  15. 'version' => 2,
  16. ))
  17. ->execute();
  18. // Make the entries in the zones table.
  19. $zones = array(
  20. array(158, '01', 'ChangHua County'),
  21. array(158, '02', 'ChiaYi City'),
  22. array(158, '03', 'ChiaYi County'),
  23. array(158, '04', 'HsinChu City'),
  24. array(158, '05', 'HsinChu County'),
  25. array(158, '06', 'HuaLien County'),
  26. array(158, '07', 'KaoHsiung City'),
  27. array(158, '08', 'KaoHsiung County'),
  28. array(158, '09', 'KeeLung City '),
  29. array(158, '10', 'KinMen County'),
  30. array(158, '11', 'LienChiang County'),
  31. array(158, '12', 'MiaoLi County'),
  32. array(158, '13', 'NanHai'),
  33. array(158, '14', 'NanTou County'),
  34. array(158, '15', 'PengHu County'),
  35. array(158, '16', 'PingTung County'),
  36. array(158, '17', 'TaiChung City'),
  37. array(158, '18', 'TaiChung County'),
  38. array(158, '19', 'TaiNan City'),
  39. array(158, '20', 'TaiNan County'),
  40. array(158, '21', 'Taipei City'),
  41. array(158, '22', 'Taipei County'),
  42. array(158, '23', 'TaiTung County'),
  43. array(158, '24', 'TaoYuan County'),
  44. array(158, '25', 'Yilan County'),
  45. array(158, '26', 'YunLin County'),
  46. array(158, '27', '南投縣'),
  47. array(158, '28', '南海諸島'),
  48. array(158, '29', '嘉義市'),
  49. array(158, '30', '嘉義縣'),
  50. array(158, '31', '基隆市'),
  51. array(158, '32', '宜蘭縣'),
  52. array(158, '33', '屏東縣'),
  53. array(158, '34', '彰化縣'),
  54. array(158, '35', '新竹市'),
  55. array(158, '36', '新竹縣'),
  56. array(158, '37', '桃園縣'),
  57. array(158, '38', '澎湖縣'),
  58. array(158, '39', '臺中市'),
  59. array(158, '40', '臺中縣'),
  60. array(158, '41', '臺北市'),
  61. array(158, '42', '臺北縣'),
  62. array(158, '43', '臺南市'),
  63. array(158, '44', '臺南縣'),
  64. array(158, '45', '臺東縣'),
  65. array(158, '46', '花蓮縣'),
  66. array(158, '47', '苗栗縣'),
  67. array(158, '48', '連江縣'),
  68. array(158, '49', '金門縣'),
  69. array(158, '50', '雲林縣'),
  70. array(158, '51', '高雄市'),
  71. array(158, '52', '高雄縣'),
  72. );
  73. $query = db_insert('uc_zones')->fields(array('zone_country_id', 'zone_code', 'zone_name'));
  74. foreach ($zones as $zone) {
  75. $query->values($zone);
  76. }
  77. $query->execute();
  78. // Set address format
  79. uc_set_address_format(
  80. 158,
  81. "!company\r\n".
  82. "!last_name !first_name\r\n".
  83. "!street1\r\n".
  84. "!street2\r\n".
  85. "!city, !zone_code !postal_code\r\n".
  86. "!country_name_if"
  87. );
  88. }
  89. function taiwan_update($version) {
  90. switch ($version) {
  91. case 2:
  92. // Correct ISO-3166-1 country name
  93. db_update('uc_countries')
  94. ->fields(array('country_name' => 'Taiwan, Province of China'))
  95. ->condition('country_id', 158)
  96. ->execute();
  97. break;
  98. }
  99. }