WinTrado Sales | Dashboard

Customer Status Overview

Distribution

Status

Number

Per Sales Person Report

$today, ":endDate" => $today); foreach($res_users as $res_user) { ?> =:startDate AND dateAdded <=:endDate'; $values = array(":userId" => $res_user['id'], ":messageType" => 'Meeting', ":startDate" => $today, ":endDate" => $today); $res_select_contacts = db_query_val($sql,$values); echo ""; // Presentations/meetings $sql = 'SELECT count(*) FROM communication WHERE userId = '.$res_user['id'].' AND messageType="Meeting" AND dateAdded >=:startDate AND dateAdded <=:endDate'; $values = array(":startDate" => $today, ":endDate" => $today); $res_select_meetings = db_query_val($sql,$values); echo ""; // Offers $sql = 'SELECT count(*) FROM customers WHERE userId = '.$res_user['id'].' AND offerSent=1 AND offerDate >=:startDate AND offerDate <=:endDate'; $values = array(":startDate" => $today, ":endDate" => $today); $res_select_offers = db_query_val($sql,$values); echo ""; ?>

Sales Person	# Contacts	# Presentations	# Offers
	".$res_select_contacts[0][0]."	".$res_select_meetings[0][0]."	".$res_select_offers[0][0]."

$startDate, ":endDate" => $endDate); // Calls $sql = 'SELECT count(*) FROM communication WHERE messageType="Call" AND dateAdded >=:startDate AND dateAdded <=:endDate'; $res_select_call = db_query_val($sql,$values); $total_calls = $res_select_call[0][0]; // email $sql = 'SELECT count(*) FROM communication WHERE messageType="email" AND dateAdded >=:startDate AND dateAdded <=:endDate'; $res_select_email = db_query_val($sql,$values); $total_emails = $res_select_email[0][0]; // Meetings $sql = 'SELECT count(*) FROM communication WHERE messageType="Meeting" AND dateAdded >=:startDate AND dateAdded <=:endDate'; $res_select_meetings = db_query_val($sql, $values); $total_meetings = $res_select_meetings[0][0]; $total_activity = $total_calls + $total_emails + $total_meetings; $percent_calls= ($total_calls * 100) / $total_activity; $percent_emails= ($total_emails * 100) / $total_activity; $percent_meetings= ($total_meetings * 100) / $total_activity; ?>

Sales Activity Overview

Number of Calls -

Number of Emails -

Number of Meetings -

"; echo ""; echo ""; echo ""; echo ""; } ?>

	ID	Question
	ID	Question
	".$row['id']."	".$row['question']." Answer : ".$row['answer']."

Salesperson Activity

Salesperson Activity Today

Customers/Leads Assigned

"; //print_r($overview); // Create list of contacts on email $email_contacts = ""; foreach ($overview->to as $contact){ //echo $contact->mailbox."@".$contact->host."
"; $email_contacts .= '"'.$contact->mailbox."@".$contact->host.'",'; } $email_contacts = substr($email_contacts, 0, -1); //echo "message no : ".$msgno."
"; // Check if email exists in customers table if (strlen($email_contacts) >0){ $sql = 'SELECT id, email from customers WHERE email IN ('.$email_contacts.')'; $customers = db_query($sql); foreach($customers as $customer) { //echo "Cust id -". $customer['id']." , email message no -".$msgno."
"; $message = imap_fetchbody($conn, $msgno, 1, FT_PEEK); $time = date('Y-m-d h:i:s',strtotime($overview->Date)); $sql = 'INSERT INTO communication(customerId, userId, dateAdded, messageType, message) VALUES (:custID, :userID, :dateAdded, :messageType, :message)'; // Get the boundary string $boundary = strtok($message, "\n"); // Get the start position of the text encoded message $start = strpos($message,$boundary); // Get the end position of the text encoded message $end = strpos($message,$boundary,$start+1); // Get the substring (start-end) $message = substr($message,$start,$end); // Convert new line chars to
$message = nl2br(quoted_printable_decode ($message)); // remove the first 3 lines containing header info $message = implode("\n", array_slice(explode("\n", $message), 3)); $values = array( ":custID" => $customer['id'], ":userID" => $_SESSION['userID'], ":dateAdded" => $time, ":messageType" => "email", ":message" => $message); //":message" => nl2br(quoted_printable_decode (strip_tags($message)))); $res = db_insert_val($sql, $values); } } // Check if email exists in contacts table if (strlen($email_contacts) >0){ $sql = 'SELECT customerId, email from contacts WHERE email IN ('.$email_contacts.')'; $customers = db_query($sql); foreach($customers as $customer) { //echo "Cust id -". $customer['customerId']." , email message no-".$msgno."
"; $message = imap_fetchbody($conn, $msgno, 1, FT_PEEK); $time = date('Y-m-d h:i:s',strtotime($overview->Date)); $sql = 'INSERT INTO communication(customerId, userId, dateAdded, messageType, message) VALUES (:custID, :userID, :dateAdded, :messageType, :message)'; // Get the boundary string $boundary = strtok($message, "\n"); // Get the start position of the text encoded message $start = strpos($message,$boundary); // Get the end position of the text encoded message $end = strpos($message,$boundary,$start+1); // Get the substring (start-end) $message = substr($message,$start,$end); // Convert new line chars to
$message = nl2br(quoted_printable_decode ($message)); // remove the first 3 lines containing header info $message = implode("\n", array_slice(explode("\n", $message), 3)); $values = array( ":custID" => $customer['customerId'], ":userID" => $_SESSION['userID'], ":dateAdded" => $time, ":messageType" => "email", ":message" => $message); //":message" => nl2br(quoted_printable_decode ( strip_tags($message)))); $res = db_insert_val($sql, $values); } } } // Udpate UID if the loop was executed (new messages arrived) if ($updateUID){ $lastUID = imap_uid($conn, $msgno); $query = "UPDATE users SET lastEmailUID = :lastEmailUID WHERE id = :id"; $values = array( ":lastEmailUID" => $lastUID, ":id" => $_SESSION['userID']); $res = db_insert_val($query, $values); } } ?>