$entryType = $entryType3;
}
}
}
if ($row['running'] == '1') {
$isRunning = $yesBtn;
} else {
$isRunning = $noBtn;
}
// Get any Previous Edit data
$results = $wpdb->get_results($query = "SELECT\r\n\t\t\t\t\t{$table_name_timeedits}.editedBy,\r\n\t\t\t\t\tDATE_FORMAT({$table_name_timeedits}.editedDate,'%M %d, %Y at %h:%i %p') AS editedDate,\r\n\t\t\t\t\t{$table_name_timeedits}.editReason,\r\n\t\t\t\t\tCONCAT({$table_name_employees}.user_id,' ','user') AS editedByN\r\n\t\t\t\tFROM\r\n\t\t\t\t\t{$table_name_timeedits}\r\n\t\t\t\t\tLEFT JOIN {$table_name_employees} ON {$table_name_timeedits}.editedBy = {$table_name_employees}.user_id\r\n\t\t\t\tWHERE {$table_name_timeedits}.entryId = {$entryId}", ARRAY_A);
$resultsnum = $wpdb->num_rows;
// Get the Total Time Worked
$times = $wpdb->get_results($query = "SELECT\r\n\t\t\t\tTIMEDIFF({$table_name_timeentry}.endTime,{$table_name_timeentry}.startTime) AS diff\r\n\t\t\tFROM\r\n\t\t\t\t{$table_name_timeclock}\r\n\t\t\t\tLEFT JOIN {$table_name_timeentry} ON {$table_name_timeclock}.clockId = {$table_name_timeentry}.clockId\r\n\t\t\tWHERE\r\n\t\t\t\t{$table_name_timeentry}.entryId = {$entryId}");
if ($row['endTime'] != '0000-00-00 00:00:00') {
$totalTime = sumHours($times);
$dateEnded = $row['dateEnded'];
$hourEnded = $row['hourEnded'];
} else {
$totalTime = $dateEnded = $hourEnded = '';
}
if ($row['user_id'] != $user_id && $isAdmin != '1') {
?>
<div class="content">
<h3><?php
echo $accessErrorHeader;
?>
</h3>
<div class="alertMsg danger no-margin">
<i class="fa fa-warning"></i> <?php
echo $permissionDenied;
// Check for an Existing Record
$wpdb->get_results($query = "SELECT * FROM {$table_name_timeclock} WHERE user_id = {$user_id} AND weekNo = {$weekNo};");
if ($wpdb->num_rows) {
$col = $wpdb->get_row($query = "SELECT clockId,user_id,weekNo,clockYear,running FROM {$table_name_timeclock} WHERE user_id = {$user_id} AND weekNo = {$weekNo}", ARRAY_A);
$clockId = $col['clockId'];
$running = $col['running'];
$rows = $wpdb->get_row($query = "SELECT entryId,clockId,user_id FROM {$table_name_timeentry} WHERE clockId = {$clockId} AND user_id = {$user_id} AND endTime = '0000-00-00 00:00:00'", ARRAY_A);
$entryId = is_null($rows['entryId']) ? '' : $rows['entryId'];
$isRecord = '1';
// Get Total Time Worked for the Current Week
$u = $wpdb->get_results($query = "SELECT TIMEDIFF({$table_name_timeentry}.endTime,{$table_name_timeentry}.startTime) AS diff\r\n\t\t\t FROM {$table_name_timeclock}\r\n\t\t\t\t\tLEFT JOIN {$table_name_timeentry} ON {$table_name_timeclock}.clockId = {$table_name_timeentry}.clockId\r\n\t\t\tWHERE {$table_name_timeclock}.user_id = {$user_id} AND\r\n\t\t\t\t\t{$table_name_timeclock}.weekNo = {$weekNo} AND\r\n\t\t\t\t\t{$table_name_timeclock}.clockYear = {$clockYear} AND\r\n\t\t\t\t\t{$table_name_timeentry}.endTime != '0000-00-00 00:00:00'");
//$times = array();
//while ($u as $urow) {
// $times[] = $u['diff'];
//}
$totalTime = sumHours($u);
} else {
$clockId = '';
$entryId = '';
$running = $isRecord = '0';
$totalTime = '00:00:00';
}
// Get Unread Message Count
$wpdb->get_results($query = "SELECT * FROM {$table_name_privatemessages} WHERE toId = {$user_id} AND toRead = 0");
$unread = $wpdb->num_rows;
// Get Notice Data
$smtRes = $wpdb->get_results($query = "SELECT\r\n\t\t\t\t\t{$table_name_notices}.createdBy,\r\n\t\t\t\t\t{$table_name_notices}.isActive,\r\n\t\t\t\t\t{$table_name_notices}.noticeTitle,\r\n\t\t\t\t\t{$table_name_notices}.noticeText,\r\n\t\t\t\t\tDATE_FORMAT({$table_name_notices}.noticeDate,'%M %d, %Y') AS noticeDate,\r\n\t\t\t\t\tUNIX_TIMESTAMP({$table_name_notices}.noticeDate) AS orderDate,\r\n\t\t\t\t\t{$table_name_notices}.noticeStart,\r\n\t\t\t\t\t{$table_name_notices}.noticeExpires,\r\n\t\t\t\t\t{$table_name_employees}.user_id AS postedBy\r\n\t\t\t\tFROM\r\n\t\t\t\t\t{$table_name_notices}\r\n\t\t\t\t\tLEFT JOIN {$table_name_employees} ON {$table_name_notices}.createdBy = {$table_name_employees}.user_id\r\n\t\t\t\tWHERE\r\n\t\t\t\t\t{$table_name_notices}.noticeStart <= DATE_SUB(CURDATE(),INTERVAL 0 DAY) AND\r\n\t\t\t\t\t{$table_name_notices}.noticeExpires >= DATE_SUB(CURDATE(),INTERVAL 0 DAY) OR\r\n\t\t\t\t\t{$table_name_notices}.isActive = 1\r\n\t\t\t\tORDER BY\r\n\t\t\t\t\torderDate", ARRAY_A);
$smtRes_numrows = $wpdb->num_rows;
$res = $wpdb->get_results($query = "SELECT\r\n\t\t\t\t{$table_name_emptasks}.empTaskId,\r\n\t\t\t\t{$table_name_emptasks}.createdBy,\r\n\t\t\t\t{$table_name_emptasks}.taskTitle,\r\n\t\t\t\t{$table_name_emptasks}.taskDesc,\r\n\t\t\t\t{$table_name_emptasks}.taskPriority,\r\n\t\t\t\tDATE_FORMAT({$table_name_emptasks}.taskStart,'%b %d %Y') AS taskStart,\r\n\t\t\t\tDATE_FORMAT({$table_name_emptasks}.taskDue,'%b %d %Y') AS taskDue,\r\n\t\t\t\tUNIX_TIMESTAMP({$table_name_emptasks}.taskDue) AS orderDate,\r\n\t\t\t\t{$table_name_employees}.user_id AS postedBy\r\n\t\t\tFROM\r\n\t\t\t\t{$table_name_emptasks}\r\n\t\t\t\tLEFT JOIN {$table_name_employees} ON {$table_name_emptasks}.createdBy = {$table_name_employees}.empId\r\n\t\t\tWHERE\r\n\t\t\t\t{$table_name_emptasks}.assignedTo = {$user_id} AND\t{$table_name_emptasks}.isClosed = 0\r\n\t\t\tORDER BY\r\n\t\t\t\torderDate\r\n\t\t\tLIMIT 3", ARRAY_A);
$res_numrows = $wpdb->num_rows;
$result = $wpdb->get_results($query = "SELECT\r\n\t\t\t\t{$table_name_privatemessages}.messageId,\r\n\t\t\t\t{$table_name_privatemessages}.fromId,\r\n\t\t\t\t{$table_name_privatemessages}.messageTitle,\r\n\t\t\t\t{$table_name_privatemessages}.messageText,\r\n\t\t\t\tDATE_FORMAT({$table_name_privatemessages}.messageDate,'%b %d %Y') AS messageDate,\r\n\t\t\t\tUNIX_TIMESTAMP({$table_name_privatemessages}.messageDate) AS orderDate,\r\n\t\t\t\t{$table_name_employees}.user_id AS sentBy\r\n\t\t\tFROM\r\n\t\t\t\t{$table_name_privatemessages}\r\n\t\t\t\tLEFT JOIN {$table_name_employees} ON {$table_name_privatemessages}.fromId = {$table_name_employees}.user_id\r\n\t\t\tWHERE\r\n\t\t\t\t{$table_name_privatemessages}.toId = {$user_id} AND\r\n\t\t\t\t{$table_name_privatemessages}.toArchived = 0 AND\r\n\t\t\t\t{$table_name_privatemessages}.toDeleted = 0\r\n\t\t\tORDER BY\r\n\t\t\t\torderDate DESC\r\n\t\t\tLIMIT 3", ARRAY_A);
<button type="button" class="btn btn-default btn-icon" data-dismiss="modal"><i class="fa fa-times-circle-o"></i> <?php
echo $cancelBtn;
?>
</button>
</div>
</form>
</div>
</div>
</div>
<?php
}
?>
</tbody>
</table>
<?php
sumHours($times);
echo '
<p class="mt20">
<span class="label label-default preview-label" data-toggle="tooltip" data-placement="right" title="hh:mm:ss">
Total: ' . $totalTime . '
</span>
</p>
';
?>
</dd>
<?php
}
echo '</dl>';
}
?>
</div>
</button>
</div>
</form>
</div>
</div>
</div>
<?php
}
?>
<?php
}
?>
</tbody>
</table>
<?php
sumHours($result);
echo '
<p class="mt20">
<span class="label label-default preview-label" data-toggle="tooltip" data-placement="right" title="' . $timeFormatHelp . '">
' . $totalText . ': ' . $totalTime . '
</span>
</p>
';
?>
</dd>
<?php
}
echo '</dl><div class="clearfix"></div>';
}
?>
</div>
