$message_sent = 0; $text = ""; $proj_discuss = new ProjectDiscuss(); $pd_discuss = new ProjectDiscuss(); $text .= "<h2> <u>Worklog Summary </u></h2>"; foreach ($type as $tp) { //select all the user from project discuss table for the day $proj_discuss->query('select DISTINCT(pd.iduser) as iduser,usr.firstname, usr.email from project_discuss pd inner join user usr on usr.iduser=pd.iduser WHERE DATEDIFF(NOW(), date_added) <= 7;'); //check if any of the user enterd worklog for the day if ($proj_discuss->getNumRows() > 0) { $text .= "<h3>Total Hours Entered {$tp} </h3>"; $text .= "<h4><u> Per Participants:</h4></u>"; while ($proj_discuss->fetch()) { $iduser = $proj_discuss->getData('iduser'); $name = $proj_discuss->getData('firstname'); $total_hrs = $pd_discuss->getTotalHoursEnteredByIndividual($iduser, $tp); //echo 'sa'.(int)$total_hrs.'<br/>'; if ($total_hrs != '') { $text .= '<b>' . $total_hrs . '</b> Hrs By ' . $name . '<br/>'; } else { $text .= '<b> 0:00</b> Hrs By ' . $name . '.<br/>'; } } } } //echo $text; // send mails to the ofuz users with their respective worklog foreach ($admin_emails as $email) { $do_template = new EmailTemplate(); $do_template->senderemail = "*****@*****.**"; $do_template->sendername = "Ofuz";