// Copyright 2008 - 2010 all rights reserved, SQLFusion LLC, info@sqlfusion.com // @author sarvesh kulkarni sarvesh@htmlfusion.com /** * A cron job script for sending user worklog By Email */ include_once 'config.php'; $message_sent = 0; $text = ""; $proj_discuss = new ProjectDiscuss(); $proj_time = new ProjectDiscuss(); //select all the user from project discuss table for the day $proj_discuss->query('select DISTINCT(pd.iduser) as iduser , 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) { while ($proj_discuss->fetch()) { $iduser = $proj_discuss->getdata('iduser'); $email = $proj_discuss->getdata('email'); $proj_time->query('SELECT project_discuss.discuss,project_discuss.date_added,document, project_discuss.iduser,sum( project_discuss.hours_work ) AS total_hrs, project_task.idproject, project_task.idtask FROM project_task left JOIN project_discuss ON project_discuss.idproject_task = project_task.idproject_task where DATE(project_discuss.date_added) = CURDATE() AND project_discuss.iduser = '******' ' . 'group by project_discuss.iduser'); if ($proj_time->getNumRows() == 0) { //$user_id = $proj_time->getData('iduser'); $us_obj = new User(); $user_name = $us_obj->getFullName($iduser); $text .= '<h2>Dear ' . $user_name . ',</h2>'; $text .= '<h2><u>Your Notes For ' . date('jS F Y') . '</u></h2>'; //$text .= '<h3><b>'.$user_name.'</b>'.'</h3>'; $text .= "<h3>Total Hours Entered : 0:00</h3>"; } else {