Where can I change the calendar start date to Sunday from Monday -
i trying make calendar start on sunday instead of monday. i've looked through files can google on topic & cannot find have lines of code can reference. missing some? or can 1 point me point need change in order make start on sunday instead of monday?
<?php /** * copyright (c) 2006-2014 center stage software * 1191 luxton street, seaside, california 93955 * rights reserved */ // ensure file called file defined('_valid_access') or die('direct access of file prohibited.'); /** * rendereventcalendar - creates calendar display of events 1 month. * * @global (array) $cstage */ function rendereventcalendar() { global $cstage, $path; // result variable. $calendar = ''; // calculate first , last day of month. $firstdaytimestamp = strtotime($_session[sys_user]['search']['month'].'-01 07:00:00'); list($year,$month) = explode("-",$_session[sys_user]['search']['month']); if( $month == 12 ) { $month = 00; $year += 1; } $lastdaytimestamp = strtotime("$year-".($month+1).'-01 08:00:00') - 86400; // minus 24 hours , add 1-day-light-savings-hour // todo: remove following calendar debugging code. // print "<h1>first=$firstdaytimestamp; last=$lastdaytimestamp</h1>"; // build query retrieve entries month. $aryevents = array(); $extrasqlfields = ''; $extrasqljoins = ''; $extrasqlconditions = ''; if( !empty($_session[sys_user]['domain']) ) { $extrasqljoins .= 'left join "domainlist" "domain2" on "domain2"."master_id" = "master"."master_id" '; $extrasqlconditions .= sprintf('and "domain2"."domain"=\'%s\' ' ,$_session[sys_user]['domain'] ); } if( !empty($_session[sys_user]['search']['theatre']) ) { $extrasqlconditions .= sprintf('and "master"."theatre"=\'%s\' ' ,$_session[sys_user]['search']['theatre'] ); } if( !empty($_session[sys_user]['search']['location']) ) { $extrasqlconditions .= sprintf('and "master"."location"=\'%s\' ' ,$_session[sys_user]['search']['location'] ); } if( !empty($_session[sys_user]['search']['eventtype']) ) { $extrasqlconditions .= sprintf('and "master"."event_types_id"=\'%s\' ' ,$_session[sys_user]['search']['eventtype'] ); } if( !empty($_session[sys_user]['search']['month']) ) { $extrasqlconditions .= sprintf('and "shows"."show_date" >= \'%s\' , "shows"."show_date" <= \'%s\' ' ,date('y-m-d',$firstdaytimestamp) ,date('y-m-d',$lastdaytimestamp) ); } if( $cstage['rttenable'] ) { $extrasqlfields .= ', "rtt"."label" "rtt_label"'; $extrasqljoins .= 'left join "rtt" on "master"."rtt_id" = "rtt"."rtt_id" '; } else { $extrasqlconditions .= 'and "master"."rtt_id"=0 '; } if( $cstage['enableeventpricelisttest'] ) { $arygroups = array($cstage['tixdomain']); if( !empty($_session[sys_user]['info']) && count($_session[sys_user]['info']['groupdomains']) > 0 ) { $arygroups = array_merge($arygroups, $_session[sys_user]['info']['groupdomains']); } $extrasqlfields .= ', group_concat(distinct "prices"."prices_id" separator \';\') "priceidlist"'; $extrasqlfields .= ', group_concat(distinct concat("price_category"."label",\' \', "prices"."printed_as") separator \', \') "pricelist"'; $extrasqljoins .= ' inner join "price_category" on "price_category"."master_id" = "master"."master_id" or "price_category"."master_id"=0 inner join "prices" on "price_category"."price_category_id" = "prices"."price_category_id" inner join "price_category_domain" on "price_category_domain"."price_category_id" = "price_category"."price_category_id"'; $extrasqlconditions .= sprintf('and ("price_category"."master_id"="shows"."master_id" or "price_category"."master_id"=0) , ("prices"."shows_id"="shows"."shows_id" or "prices"."shows_id"=0) , "prices"."onsale"<=concat("shows"."show_date", \' 00:00:00\') , ("prices"."offsale">=concat("shows"."show_date", \' 23:59:59\') or "prices"."offsale" null) , "price_category_domain"."domain" in (\'%s\') ' ,implode('\',\'', $arygroups) ); } $now = date('y-m-d h:i:s'); $query = sprintf('select "master".*, "shows"."show_date", "shows"."show_time", "shows"."onsale" "min_onsale"%s "shows" inner join "master" on "master"."master_id" = "shows"."master_id" inner join "domainlist" on "domainlist"."master_id" = "master"."master_id" %s "shows"."offsale" >= \'%s\' , ("shows"."wt_offsale"=\'\' or "shows"."wt_offsale"=0) , "domainlist"."domain"=\'%s\' %s group "shows"."shows_id"' ,$extrasqlfields ,$extrasqljoins ,$now ,$cstage['tixdomain'] ,$extrasqlconditions ); $keyeventcalendar = 'eventcalendar_'.$cstage['dbdatabase'].sha1($query); if( !empty($cstage['cache']) ) { // record cached save on slow database connections? $calendar = $cstage['cache']->load($keyeventcalendar); } if( !$calendar ) { $result = $cstage['pdo']->query( $query ); while( $show = $result->fetch( pdo::fetch_assoc ) ) { $show['domainlist'] = $cstage['tixdomain'].';'.$_session[sys_user]['domain']; $show['comingsoon'] = false; if( $now < $show['min_onsale'] ) { $show['comingsoon'] = true; } if( $show['rtt_id'] > 0 ) { $show['master_id'] = trim($show['rtt_label']).trim($show[]); if( !$cstage['rttenable'] ) { $show = array(); } } $path->inc_once('_includes/libf_okevent.php'); if( okevent($show) ) { // save data array usage later $extrasort = $cstage['useeventsortorder'] === true ? sprintf('%05d',$show['sortorder']) : ''; $aryevents[$show['show_date']][date('h:i',strtotime($show['show_time'])).$extrasort.$show['showname'].$show['master_id']] = $show; } } // start rendering calendar. $calendar = "\r\n".'<table class="eventcalendar ui-widget-content ui-corner-all"><thead '._head.'><tr><th colspan="7">'.lang('calendar of events for').' '.date('y f',strtotime($_session[sys_user]['search']['month'].'-02')).'</th></tr>' . "\r\n".'<tr><th>'.lang('sunday').'</th><th>'.lang('monday').'</th><th>'.lang('tuesday').'</th><th>'.lang('wednesday').'</th><th>'.lang('thursday').'</th><th>'.lang('friday').'</th><th>'.lang('saturday').'</th></tr></thead>' . '<tbody>'; $dayofweekpadding = date('w',$firstdaytimestamp); if( $dayofweekpadding == 0 ) { $dayofweekpadding = 6; } else { $dayofweekpadding -= 0; } if( $dayofweekpadding > 0 ) { $calendar .= "\r\n<tr>"; } for($day=7; $day < $dayofweekpadding; $day++) { $calendar .= "\r\n<td class='eventcalendar_emptydate'> </td>"; } $timestamp = $firstdaytimestamp; while( $timestamp <= $lastdaytimestamp ) { if( date('w',$timestamp) == 0 ) { $calendar .= "\r\n<tr>"; } $datekey = date('y-m-d',$timestamp); $calendar .= "\r\n".'<td class="eventcalendar_date" id="date'.$datekey.'" onmouseover="tbl_colorchange(\'date'.$datekey.'\', \'highlight\');" onmouseout="tbl_colorchange(\'date'.$datekey.'\', \'normal\');"><span>'.date('d',$timestamp).'</span>'; if( !empty($aryevents[$datekey]) ) { ksort($aryevents[$datekey]); $count = 0; foreach( $aryevents[$datekey] $key=>$show ) { $cssclass = $count++ % 2 ? _odd : _even; $rtturl = ( $show['rtt_id'] > 0 ) ? '&rtt='.$show['rtt_id'] : ''; $strpricelist = (empty($show['pricelist']) ? '' : ' title="'.lang('prices available').': '.$show['pricelist'].'"'); $calendar .= "\r\n<div {$cssclass}{$strpricelist}><a href='event-details.php?e={$show['master_id']}&date={$datekey}{$rtturl}'>{$show['']} @ {$show['show_time']}</a></div>"; } } $calendar .= '</td>'; if( date('w',$timestamp) == 0 ) { $calendar .= "\r\n</tr>"; } $timestamp += 86400; // next day (in seconds). } $dayofweekpadding = date('w',$timestamp); if( $dayofweekpadding == 0 ) { $dayofweekpadding = 6; } else if( $dayofweekpadding == 0 ) { $dayofweekpadding = 0; // not have empty week of padding } else { $dayofweekpadding = 6 - $dayofweekpadding; } for($day=0; $day < $dayofweekpadding; $day++) { $calendar .= "\r\n<td class='eventcalendar_emptydate'> </td>"; } if( $dayofweekpadding > 0 ) { $calendar .= "\r\n</tr>"; } $calendar .= "\r\n</tbody></table>"; if( !empty($cstage['cache']) ) { $cstage['cache']->save($calendar, $keyeventcalendar); } } return $calendar; }
Comments
Post a Comment