<td>
<span><?php
if (get_post_meta($msg_post->ID, 'message_for', true) == 'user') {
echo gym_get_display_name(get_post_meta($msg_post->ID, 'message_gmgt_user_id', true));
} else {
echo get_post_meta($msg_post->ID, 'message_for', true);
}
?>
</span>
</td>
<td>
<span><?php
if (get_post_meta($msg_post->ID, 'gmgt_class_id', true) != "" && get_post_meta($msg_post->ID, 'gmgt_class_id', true) == 'all') {
_e('All', 'gym_mgt');
} elseif (get_post_meta($msg_post->ID, 'gmgt_class_id', true) != "") {
echo gmgt_get_class_name(get_post_meta($msg_post->ID, 'gmgt_class_id', true));
}
?>
</span>
</td>
<td><a href="?page=gmgt_message&tab=view_message&from=sendbox&id=<?php
echo $msg_post->ID;
?>
"><?php
echo $msg_post->post_title;
?>
</a></td>
<td>
<?php
echo $msg_post->post_content;
?>
<div class="col-md-7 col-sm-12 table_td">
<span class="txt_color"><?php
echo $user_info->gender;
?>
</span>
</div>
</div>
<div class="table_row">
<div class="col-md-5 col-sm-12 table_td">
<i class="fa fa-graduation-cap"></i> <?php
_e('Class', 'gym_mgt');
?>
</div>
<div class="col-md-7 col-sm-12 table_td">
<span class="txt_color"><?php
echo gmgt_get_class_name($user_info->class_id);
?>
</span>
</div>
</div>
<div class="table_row">
<div class="col-md-5 col-sm-12 table_td">
<i class="fa fa-user"></i> <?php
_e('User Name', 'gym_mgt');
?>
</div>
<div class="col-md-7 col-sm-12 table_td">
<span class="txt_color"><?php
echo $user_info->user_login;
?>
</span>
</div>
<div class="col-md-6 col-sm-6 col-xs-12">
<?php
global $wpdb;
$table_attendance = $wpdb->prefix . 'gmgt_attendence';
$table_class = $wpdb->prefix . 'gmgt_class_schedule';
//$sdate = $_REQUEST['sdate'];
//$edate = $_REQUEST['edate'];
//$sdate = '2015-09-01';
//$edate = '2015-09-10';
$chart_array = array();
$report_2 = $wpdb->get_results("SELECT at.class_id,\n\t\t\t\t\tSUM(case when `status` ='Present' then 1 else 0 end) as Present,\n\t\t\t\t\tSUM(case when `status` ='Absent' then 1 else 0 end) as Absent\n\t\t\t\t\tfrom {$table_attendance} as at,{$table_class} as cl where at.attendence_date > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND at.class_id = cl.class_id AND at.role_name = 'member' GROUP BY at.class_id");
$chart_array[] = array(__('Class', 'gym_mgt'), __('Present', 'gym_mgt'), __('Absent', 'gym_mgt'));
if (!empty($report_2)) {
foreach ($report_2 as $result) {
$class_id = gmgt_get_class_name($result->class_id);
$chart_array[] = array("{$class_id}", (int) $result->Present, (int) $result->Absent);
}
}
$options = array('title' => __('Member Attendance Report', 'gym_mgt'), 'titleTextStyle' => array('color' => '#66707e', 'fontSize' => 14, 'bold' => true, 'italic' => false, 'fontName' => 'open sans'), 'legend' => array('position' => 'right', 'textStyle' => array('color' => '#66707e', 'fontSize' => 14, 'bold' => true, 'italic' => false, 'fontName' => 'open sans')), 'hAxis' => array('title' => __('Class', 'gym_mgt'), 'titleTextStyle' => array('color' => '#66707e', 'fontSize' => 14, 'bold' => true, 'italic' => false, 'fontName' => 'open sans'), 'textStyle' => array('color' => '#66707e', 'fontSize' => 10), 'maxAlternation' => 2), 'vAxis' => array('title' => __('No of Member', 'gym_mgt'), 'minValue' => 0, 'maxValue' => 5, 'format' => '#', 'titleTextStyle' => array('color' => '#66707e', 'fontSize' => 14, 'bold' => true, 'italic' => false, 'fontName' => 'open sans'), 'textStyle' => array('color' => '#66707e', 'fontSize' => 12)), 'colors' => array('#22BAA0', '#f25656'));
$GoogleCharts = new GoogleCharts();
$chart = $GoogleCharts->load('column', 'attendance_report')->get($chart_array, $options);
?>
<div class="panel panel-white">
<div class="panel-heading">
<h3 class="panel-title"><?php
_e('Member Attendance Report', 'gym_mgt');
?>
</h3>
</div>
<div class="panel-body">
echo substr($retrieved_data->post_content, 0, 60) . '...';
} else {
echo $retrieved_data->post_content;
}
?>
</td>
<td class="productquentity"><?php
echo get_post_meta($retrieved_data->ID, 'notice_for', true);
?>
</td>
<td>
<?php
if (get_post_meta($retrieved_data->ID, 'gmgt_class_id', true) != "" && get_post_meta($retrieved_data->ID, 'gmgt_class_id', true) == "all") {
_e('All', 'gym_mgt');
} elseif (get_post_meta($retrieved_data->ID, 'gmgt_class_id', true) != "") {
echo gmgt_get_class_name(get_post_meta($retrieved_data->ID, 'gmgt_class_id', true));
}
?>
</td>
<?php
if ($obj_gym->role == 'staff_member' || $obj_gym->role == 'accountant') {
?>
<td class="action">
<a href="#" class="btn btn-success view-notice" id="<?php
echo $retrieved_data->ID;
?>
"> <?php
_e('View', 'gym_mgt');
?>
</a>
<!--<a href="?dashboard=user&page=notice&tab=addnotice&action=edit¬ice_id=<?php
