3 * Table Definition for core company
5 class_exists('DB_DataObject') ? '' : require_once 'DB/DataObject.php';
7 class Pman_Core_DataObjects_Core_holiday extends DB_DataObject
10 /* the code below is auto generated do not remove the above tag */
12 public $__table = 'core_holiday'; // table name
18 /* the code above is auto generated do not remove the tag below */
23 'hk' => 'http://www.1823.gov.hk/common/ical/gc/en.ics'
27 function updateHolidays($country)
30 if (!isset(self::$map[$country])) {
31 die("invalid country");
34 // do we alredy have the data for this year.
35 $d = DB_DataObject::Factory('core_holiday');
36 $d->country = $country;
37 $d->orderBy('holiday_date DESC');
39 if ($d->count() && $d->find(true) && strtotime($d->holiday_date) > strtotime('NOW + 6 MONTHS')) {
46 $data = file_get_contents("http://www.1823.gov.hk/common/ical/gc/en.ics");
48 $vevents = explode('BEGIN:VEVENT', $data);
50 foreach ($vevents as $vevent){
52 $lines = explode("\n", $vevent);
57 foreach ($lines as $line){
59 if(preg_match('/^DTSTART;VALUE=DATE:([0-9]+)/', $line, $matches)){
60 $fmt = substr($matches[1], 0, 4) . "-" . substr($matches[1], 4, 2) . "-" . substr($matches[1], 6, 2);
61 $start_dt = date('Y-m-d', strtotime($fmt));
64 if(preg_match('/^DTEND;VALUE=DATE:([0-9]+)/', $line, $matches)){
65 $fmt = substr($matches[1], 0, 4) . "-" . substr($matches[1], 4, 2) . "-" . substr($matches[1], 6, 2);
66 $end_dt = date('Y-m-d', strtotime($fmt));
71 if(empty($start_dt) || empty($end_dt)){
75 //var_dump($start_dt); var_dump($end_dt); exit;
77 for ($i = strtotime($start_dt); $i < strtotime($end_dt) ; $i += (60 * 60 * 24)) {
79 $d = DB_DataObject::Factory('core_holiday');
80 $d->country = $country;
81 $d->holiday_date = date('Y-m-d', $i);
92 function isHoliday($country, $date)
94 $d = DB_DataObject::Factory('core_holiday');
95 $d->country = $country;
96 $d->holiday_date = $date;