%s', $url, $name );
} else {
$list[] = sprintf( '
%s
', $name );
}
}
}
$format = <<
%DAY%
%STAFF%
EOD;
$search = array(
'%DAY%',
'%STAFF%',
);
$replace = array(
$args['data']['d'],
implode( "\n", $list ),
);
$html = str_replace( $search, $replace, $format );
return $html;
}
/**
* Weekly all schedule
*/
public function weekly_all_schedule( $atts, $content = null ) {
global $attmgr, $wpdb;
extract(
shortcode_atts(
array(
'name_key' => 'display_name',
),
$atts
)
);
$staff = ATTMGR_User::get_all_staff();
if ( empty( $staff ) ) {
printf( '
%s
', __( 'There are no staff.', ATTMGR::TEXTDOMAIN ) );
} else {
$startdate = $attmgr->page['startdate'];
list( $y, $m, $d ) = explode( '-', $startdate );
$m = intval( $m );
$d = intval( $d );
$starttime = mktime( 0, 0, 0, $m, $d, $y );
$term = 7;
$endtime = mktime( 0, 0, 0, $m, $d + $term, $y );
$enddate = date( 'Y-m-d', $endtime );
// Head
$head = '';
for ( $i = 0; $i < $term; $i++ ) {
$t = $starttime + 60*60*24*$i;
$w = date( 'w', $t );
$date = sprintf( '
%d/%d(%s)', date( 'n', $t ), date( 'j', $t ), ATTMGR_Calendar::dow( $w ) );
$head .= sprintf( '
%s | '."\n", ATTMGR_Calendar::dow_lower( $w ), $date );
}
$head = sprintf( '
| | '."\n".'%s
|---|
', $head );
// body
$prefix = $wpdb->prefix.ATTMGR::TABLEPREFIX;
$table = $prefix.'schedule';
$query = "SELECT * FROM $table "
."WHERE staff_id = %d "
."AND ( date>=%s AND date<= %s ) ";
$body = '';
foreach ( $staff as $s ) {
$staff_id = $s->data['ID'];
$records = $wpdb->get_results( $wpdb->prepare( $query, array( $staff_id, $startdate, $enddate ) ), ARRAY_A );
$schedule = array();
if ( !empty( $records ) ) {
foreach ( $records as $r ) {
$schedule[ $r['date'] ] = $r;
$schedule[ $r['date'] ]['starttime'] = substr( $schedule[ $r['date'] ]['starttime'], 0, 5 );
$schedule[ $r['date'] ]['endtime'] = substr( $schedule[ $r['date'] ]['endtime'], 0, 5 );
}
}
$line = '';
for ( $i = 0; $i < 7; $i++ ) {
$d = date( 'Y-m-d', $starttime + 60*60*24*$i );
$w = date( 'w', $starttime + 60*60*24*$i );
$dow = ATTMGR_Calendar::dow( $w );
if ( isset( $schedule[ $d ] ) ) {
$time = sprintf( '%s ~ %s', $schedule[ $d ]['starttime'], $schedule[ $d ]['endtime'] );
}
else {
$time = '-';
}
$line .= sprintf( '
%s | '."\n", $time );
}
$portrait = null;
$portrait = ATTMGR_Function::get_portrait( $portrait, $s );
$name = $s->data[ $name_key ];
if ( ! empty( $s->data[ATTMGR::PLUGIN_ID.'_mypage_id'] ) ) {
$name = sprintf( '
%s', get_permalink( $s->data[ATTMGR::PLUGIN_ID.'_mypage_id'] ), $name );
}
$body .= sprintf( '
| %s%s | %s
'."\n", $portrait, $name, $line );
}
ob_start();
$format = <<
%HEAD%
%BODY%