get_results("select ClientName, tc.ClientId, r.BillOnProjectCompletion
from {$wpdb->prefix}timesheet_clients tc
join {$wpdb->prefix}timesheet_clients_users tcu ON tc.ClientId = tcu.ClientId
join {$wpdb->prefix}timesheet_client_projects tcp on tc.ClientId = tcp.ClientId
and tcp.Active=1
left outer join {$wpdb->prefix}timesheet_recurring_invoices_monthly r on tc.ClientId = r.client_id
WHERE tcu.user_id = $user_id
union
select ClientName, tc1.ClientId, r.BillOnProjectCompletion
from {$wpdb->prefix}timesheet_clients tc1
left outer join {$wpdb->prefix}timesheet_recurring_invoices_monthly r on tc1.ClientId = r.client_id
where tc1.ClientId = $client_id
union
select ClientName, tc2.ClientId, r.BillOnProjectCompletion
from {$wpdb->prefix}timesheet_clients tc2
left outer join {$wpdb->prefix}timesheet_recurring_invoices_monthly r on tc2.ClientId = r.client_id
join {$wpdb->prefix}timesheet t on tc2.ClientId = t.ClientId
where t.timesheet_id = $timesheet_id
order by ClientName");
$sql = "select tcp.ClientId, ProjectId, ProjectName, BillOnProjectCompletion from {$wpdb->prefix}timesheet_client_projects tcp join {$wpdb->prefix}timesheet_clients_users tcu on tcp.ClientId = tcu.ClientId where tcu.user_id = $user_id and tcp.Active=1
union
select ClientId, ProjectId, ProjectName, BillOnProjectCompletion from {$wpdb->prefix}timesheet_client_projects where ProjectId = {$project_id}
order by ProjectName
";
$projects = $db->get_results($sql);
foreach ($projects as $project) {
$project->ProjectName = $this->clean_from_db($project->ProjectName);
$clean_projects[] = $project;
}
$js_projects = json_encode($clean_projects);
if ($options['hide_client_project'] && count($clients)==1 && count($projects)==1) {
$client = $clients[0];
$project = $projects[0];
echo "Client Name: ";
if ($clients) {
echo "Select Client ";
$clientList = '';
foreach ($clients as $client) {
echo "ClientId==$timesheet->ClientId) {
echo " selected";
}
echo ">{$this->clean_from_db($client->ClientName)} ";
if ($client->BillOnProjectCompletion=="1") {
$clientList = "{$clientList}\"{$client->ClientId}\", ";
}
}
if ($clientList) {
$clientList = "[$clientList \"-1\"]";
} else {
$clientList = "[\"-1\"]";
}
echo "New Client must be added.";
}
if ($queue_approval->employee_approver_check()!=0 && $disable_object=="") {
echo "Add a Client ";
}
echo " Project Name: Add a Project ";
}
echo "";
$trailing_color=" ";
}
}
}
}
$date = date_format($date, 'm-d');
$return = "{$leading_color} {$date} {$trailing_color}";
return $return;
}
function show_clients_on_retainer($mine_only = 0) {
global $wpdb;
$db = new time_sheets_db();
$user_id = get_current_user_id();
$sql = "select ClientName, im.MonthlyHours, im.HourlyRate, im.Notes
from {$wpdb->prefix}timesheet_clients tc
inner join {$wpdb->prefix}timesheet_recurring_invoices_monthly im on tc.clientid = im.client_id";
if ($mine_only == 1) {
$sql = $sql." inner join {$wpdb->prefix}timesheet_clients_users tcu on tc.clientid = tcu.clientid and tcu.user_id = {$user_id}";
}
$sql = $sql." where im.MonthlyHours <> 0
order by ClientName";
$clients = $db->get_results($sql);
if ($clients) {
echo "Client Name Number of Hours Hourly Rate on Retainer Notes {$client->ClientName} {$client->MonthlyHours} $ {$client->HourlyRate}
";
}
$sql = "select ClientName, im.MonthlyHours, im.HourlyRate, im.Notes
from {$wpdb->prefix}timesheet_clients tc
inner join {$wpdb->prefix}timesheet_recurring_invoices_monthly im on tc.clientid = im.client_id";
if ($mine_only == 1) {
$sql = $sql." inner join {$wpdb->prefix}timesheet_clients_users tcu on tc.clientid = tcu.clientid and tcu.user_id = {$user_id}";
}
$sql = $sql."
where im.MonthlyHours = 0
order by ClientName";
$clients = $db->get_results($sql);
if ($clients) {
echo "Client Name Notes {$client->ClientName}
";
}
$sql = "select ClientName, ProjectName, p.notes
from {$wpdb->prefix}timesheet_client_projects p
join {$wpdb->prefix}timesheet_clients c on p.ClientId = c.ClientId";
if ($mine_only == 1) {
$sql = $sql." inner join {$wpdb->prefix}timesheet_clients_users tcu on p.clientid = tcu.clientid and tcu.user_id = {$user_id}";
}
$sql = $sql."
where p.notes <> '' and p.Active = 1
order by ClientName, ProjectName";
$clients = $db->get_results($sql);
if ($clients) {
echo "Client Name Project Name Notes {$client->ClientName} {$client->ProjectName}
";
}
}
function is_match($v1, $v2, $return, $debug=0) {
if ($debug==1) {
var_dump($v1);
var_dump($v2);
}
if (trim($v1)==trim($v2)) {
return $return;
} else {
return "";
}
}
function replace($search, $replace, $value) {
return str_replace($search, $replace, $value);
}
function f_date($date) {
$options = get_option('time_sheets');
if ($options['override_date_format'] == 'system_defined') {
$date_format = get_option('date_format');
} else {
$date_format = $options['new_date_format'];
if ($options['user_specific_date_format']) {
if (get_user_option('user_date_format', $user_id)) {
$date_format = get_user_option('user_date_format', $user_id);
}
}
}
return date_i18n($date_format, strtotime($date));
}
function mysql_date($date) {
return date("Y-m-d", strtotime($date));
}
function send_email ($to, $subject, $body) {
global $wpdb;
$options = get_option('time_sheets');
$db = new time_sheets_db();
if($options['enable_email']) {
$sql = "insert into {$wpdb->prefix}timesheet_emailqueue
(send_to, send_from_email, send_from_name, subject, message_body, entered_on)
values (%s, %s, %s, %s, %s, now())";
$parms = array($to, $options['email_from'], $options['email_name'], $subject, $body);
$db->query($sql, $parms);
if ($options['show_email_notice']) {
echo "";
}
}
}
function remove_br($string) {
$string = str_replace("\'", "'", $string);
return nl2br($string);
}
function enqueue_js() {
wp_enqueue_script ("jquery", '', array(), "1.11.0", false);
wp_enqueue_script ("polyfiller", plugins_url( 'js/minified/polyfiller.js' , __FILE__), array(), false, false);
#wp_enqueue_script ("polyfiller", "//afarkas.github.io/webshim/js-webshim/minified/polyfiller.js", array(), "");
}
function show_datestuff() {
?>