|
Lines 91-97
for ($newDay->add(days => 1); $newDay <= $latestedDate; $newDay->add(days => 1))
Link Here
|
| 91 |
my $yearAgo = $newDay->clone(); |
91 |
my $yearAgo = $newDay->clone(); |
| 92 |
$yearAgo = $yearAgo->add(years => -1); |
92 |
$yearAgo = $yearAgo->add(years => -1); |
| 93 |
my $last_year = 'SELECT is_opened, holiday_type, note FROM discrete_calendar WHERE date=? AND branchcode=?'; |
93 |
my $last_year = 'SELECT is_opened, holiday_type, note FROM discrete_calendar WHERE date=? AND branchcode=?'; |
| 94 |
my $day_last_week = "SELECT open_hour, close_hour FROM discrete_calendar WHERE DAYOFWEEK(date)=DAYOFWEEK(?) and date < ? order by date desc limit 1"; |
94 |
my $day_last_week = "SELECT open_hour, close_hour, holiday_type, note FROM discrete_calendar WHERE DAYOFWEEK(date)=DAYOFWEEK(?) and date < ? order by date desc limit 1"; |
| 95 |
my $add_Day = 'INSERT INTO discrete_calendar (date,branchcode,is_opened,open_hour,close_hour) VALUES (?,?,?,?,?)'; |
95 |
my $add_Day = 'INSERT INTO discrete_calendar (date,branchcode,is_opened,open_hour,close_hour) VALUES (?,?,?,?,?)'; |
| 96 |
my $note =''; |
96 |
my $note =''; |
| 97 |
#insert into discrete_calendar for each branch |
97 |
#insert into discrete_calendar for each branch |
|
Lines 112-118
for ($newDay->add(days => 1); $newDay <= $latestedDate; $newDay->add(days => 1))
Link Here
|
| 112 |
$holiday_type = '' if $is_opened; |
112 |
$holiday_type = '' if $is_opened; |
| 113 |
$statement = $dbh->prepare($day_last_week); |
113 |
$statement = $dbh->prepare($day_last_week); |
| 114 |
$statement->execute($newDay, $newDay); |
114 |
$statement->execute($newDay, $newDay); |
| 115 |
my ($open_hour,$close_hour ) = $statement->fetchrow_array; |
115 |
my ( $open_hour, $close_hour, $weekly_holiday_type, $weekly_note ) = $statement->fetchrow_array; |
|
|
116 |
|
| 117 |
# weekly repeatable holidays |
| 118 |
if ( $weekly_holiday_type eq 'W' ) { |
| 119 |
$is_opened = 0; |
| 120 |
$holiday_type = $weekly_holiday_type unless $holiday_type; |
| 121 |
$note = $weekly_note unless $note; |
| 122 |
} |
| 123 |
|
| 116 |
my $add_Day = 'INSERT INTO discrete_calendar (date,branchcode,is_opened,holiday_type, note,open_hour,close_hour) VALUES (?,?,?,?,?,?,?)'; |
124 |
my $add_Day = 'INSERT INTO discrete_calendar (date,branchcode,is_opened,holiday_type, note,open_hour,close_hour) VALUES (?,?,?,?,?,?,?)'; |
| 117 |
$statement = $dbh->prepare($add_Day); |
125 |
$statement = $dbh->prepare($add_Day); |
| 118 |
$statement->execute($newDay,$branchCode,$is_opened,$holiday_type,$note, $open_hour,$close_hour); |
126 |
$statement->execute($newDay,$branchCode,$is_opened,$holiday_type,$note, $open_hour,$close_hour); |
| 119 |
- |
|
|