5 require_once 'Pman.php';
7 class Pman_Core_Import_Timezone extends Pman
9 static $cli_desc = "Import timezone region name and area name to core_enum";
11 static $cli_opts = array();
15 $ff = HTML_FlexyFramework::get();
22 function get($part = '', $opts=array())
24 $ce = DB_DataObject::factory('core_enum');
27 *, TIME_FORMAT(TIMEDIFF(NOW(), CONVERT_TZ(NOW(), Name, 'UTC')), '%H:%i') as timeOffset
35 Name NOT LIKE 'right%'
37 Name NOT LIKE 'posix%'
41 SUBSTRING_INDEX(Name, '/', 1) ASC,
52 $ar = explode('/', $ce->Name);
54 $area = str_replace('_', ' ', $ar[1]);
56 if(!in_array($region, $regions)) {
58 $values[] = "('Timezone.Region', '" . $region . "', 1, 0, 0, '" . $region . "', 0)";
61 if(!in_array($area, $areas)) {
63 $values[] = "('Timezone.Area', '" . $area . "', 1, 0, 0, '" . $area . "', 0)";
69 core_enum (etype, name, active, seqid, seqmax, display_name, is_system_enum)
71 " . implode(", \n", $values) . "
74 $ce = DB_DataObject::factory('core_enum');