function manage()
{
$this->set('istype', SES_TYPE);
$search_key = $this->request->query['user_srch'];
$search_query = "User.name LIKE '%{$search_key}%' OR User.last_name LIKE '%{$search_key}%' OR User.email LIKE '%{$search_key}%' OR User.short_name LIKE '%{$search_key}%'";
$page_limit = CASE_PAGE_LIMIT;
$page_limit = 26;
$CompanyUser = ClassRegistry::init('CompanyUser');
if (isset($_GET['del']) && trim(urldecode($_GET['del'])) != "") {
$del = urldecode($_GET['del']);
$del = addslashes($del);
$getUsr = $this->User->find('first', array('conditions' => array('User.uniq_id' => $del), 'fields' => array('User.id', 'User.email', 'User.name', 'User.last_name')));
$CompanyUser->deleteAll(array('user_id' => $getUsr['User']['id'], 'company_id' => SES_COMP, 'user_type!=1'));
$UserInvitation = ClassRegistry::init('UserInvitation');
$UserInvitation->query("DELETE FROM user_invitations WHERE user_id='" . $getUsr['User']['id'] . "' AND company_id='" . SES_COMP . "'");
$invit = $UserInvitation->find('first', array('conditions' => array('UserInvitation.user_id' => $getUsr['User']['id'])));
//Event log data and inserted into database in account creation--- Start
$json_arr['email'] = $getUsr['User']['email'];
$json_arr['name'] = trim($getUsr['User']['first_name'] . " " . $getUsr['User']['last_name']);
$json_arr['created'] = GMT_DATETIME;
$this->Postcase->eventLog(SES_COMP, SES_ID, $json_arr, 3);
//End
$this->Session->write("SUCCESS", "user deleted successfully");
$this->redirect(HTTP_ROOT . "users/manage/?role=invited");
}
if (isset($_GET['act']) && trim(urldecode($_GET['act'])) != "") {
if ($GLOBALS['Userlimitation']['subscription_id'] == 1 && strtolower($GLOBALS['Userlimitation']['user_limit']) != "unlimited") {
if ($GLOBALS['usercount'] >= $GLOBALS['Userlimitation']['user_limit']) {
$this->Session->write("ERROR", "Sorry! User cannot be enabled. User Limit Exceeded!");
$this->redirect(HTTP_ROOT . "users/manage/?type=1&role=" . $_GET['role']);
exit;
}
}
$act = urldecode($_GET['act']);
$act = addslashes($act);
$getUsr = $this->User->find('first', array('conditions' => array('User.uniq_id' => $act), 'fields' => array('User.id', 'User.email', 'User.name', 'User.last_name')));
//Below code are written for the subscription i.e in case a disabled user get activated during a subscribed period
$comp_user = $CompanyUser->find('first', array('conditions' => array('user_id' => $getUsr['User']['id'], 'company_id' => SES_COMP)));
if ($GLOBALS['Userlimitation']['btsubscription_id']) {
if (strtotime($comp_user['CompanyUser']['billing_end_date']) < strtotime($GLOBALS['Userlimitation']['next_billing_date'])) {
//$this->update_bt_subscription($comp_user['CompanyUser']['id'], $comp_user['CompanyUser']['company_id'], 2);
}
}
$CompanyUser->query("UPDATE company_users as CompanyUser SET CompanyUser.is_active='1' WHERE CompanyUser.user_id='" . $getUsr['User']['id'] . "' AND CompanyUser.company_id='" . SES_COMP . "' AND CompanyUser.user_type!='1'");
//Event log data and inserted into database in account creation--- Start
$json_arr['email'] = $getUsr['User']['email'];
$json_arr['name'] = trim($getUsr['User']['first_name'] . " " . $getUsr['User']['last_name']);
$json_arr['created'] = GMT_DATETIME;
$this->Postcase->eventLog(SES_COMP, SES_ID, $json_arr, 28);
//End
$this->Session->write("SUCCESS", "User enabled successfully");
$this->redirect(HTTP_ROOT . "users/manage/?role=" . $_GET['role']);
}
if (isset($_GET['deact']) && trim(urldecode($_GET['deact'])) != "") {
$deact = urldecode($_GET['deact']);
$deact = addslashes($deact);
$getUsr = $this->User->find('first', array('conditions' => array('User.uniq_id' => $deact), 'fields' => array('User.id', 'User.email', 'User.name', 'User.last_name')));
$CompanyUser->query("UPDATE company_users as CompanyUser SET CompanyUser.is_active='0' WHERE CompanyUser.user_id='" . $getUsr['User']['id'] . "' AND CompanyUser.company_id='" . SES_COMP . "' AND CompanyUser.user_type!='1'");
//Event log data and inserted into database in account creation--- Start
$json_arr['email'] = $getUsr['User']['email'];
$json_arr['name'] = $getUsr['User']['first_name'] . " " . $getUsr['User']['last_name'];
$json_arr['created'] = GMT_DATETIME;
$this->Postcase->eventLog(SES_COMP, SES_ID, $json_arr, 27);
//End
$this->Session->write("SUCCESS", "User disabled successfully");
$this->redirect(HTTP_ROOT . "users/manage");
}
if (isset($_GET['grant_admin']) && trim(urldecode($_GET['grant_admin'])) != "") {
$grant_admin = urldecode($_GET['grant_admin']);
$grant_admin = addslashes($grant_admin);
$getUsr = $this->User->find('first', array('conditions' => array('User.uniq_id' => $grant_admin), 'fields' => array('User.id')));
$CompanyUser->query("UPDATE company_users as CompanyUser SET CompanyUser.user_type='2' WHERE CompanyUser.user_id='" . $getUsr['User']['id'] . "' AND CompanyUser.company_id='" . SES_COMP . "' AND CompanyUser.user_type!='1'");
$this->Session->write("SUCCESS", "Granted admin privilege");
$this->redirect(HTTP_ROOT . "users/manage");
}
if (isset($_GET['revoke_admin']) && trim(urldecode($_GET['revoke_admin'])) != "") {
$revoke_admin = urldecode($_GET['revoke_admin']);
$revoke_admin = addslashes($revoke_admin);
$getUsr = $this->User->find('first', array('conditions' => array('User.uniq_id' => $revoke_admin), 'fields' => array('User.id')));
$CompanyUser->query("UPDATE company_users as CompanyUser SET CompanyUser.user_type='3' WHERE CompanyUser.user_id='" . $getUsr['User']['id'] . "' AND CompanyUser.company_id='" . SES_COMP . "' AND CompanyUser.user_type!='1'");
$this->Session->write("SUCCESS", "Revoked admin privilege");
$this->redirect(HTTP_ROOT . "users/manage");
}
if (isset($_GET['resend']) && trim(urldecode($_GET['resend'])) != "") {
$resend = urldecode($_GET['resend']);
$resend = addslashes($resend);
$UserInvitation = ClassRegistry::init('UserInvitation');
$invit = $UserInvitation->find('first', array('conditions' => array('UserInvitation.qstr' => $resend)));
if ($invit['UserInvitation']['user_id']) {
$getUser = $this->User->find('first', array('conditions' => array('User.id' => $invit['UserInvitation']['user_id'])));
$Company = ClassRegistry::init('Company');
$comp = $Company->find('first', array('fields' => array('Company.id', 'Company.name', 'Company.uniq_id')));
$expEmail = explode("@", $getUser['User']['email']);
$expName = $expEmail[0];
$qstr = $this->Format->generateUniqNumber();
$loggedin_users = $this->Format->getUserNameForEmail($this->Auth->User("id"));
$fromName = ucfirst($loggedin_users['User']['name']);
$fromEmail = $loggedin_users['User']['email'];
$ext_user = '';
if (!$getUser['User']['password']) {
$subject = $fromName . " Invited you to join " . $comp['Company']['name'] . " on Orangescrum";
$ext_user = 1;
} else {
$subject = $fromName . " Invited you to join on Orangescrum";
}
$this->Email->delivery = EMAIL_DELIVERY;
$this->Email->to = $to;
$this->Email->subject = $subject;
$this->Email->from = FROM_EMAIL;
$this->Email->template = 'invite_user';
$this->Email->sendAs = 'html';
$this->set('expName', ucfirst($expName));
$this->set('qstr', $qstr);
$this->set('existing_user', $ext_user);
$this->set('company_name', $comp['Company']['name']);
$this->set('fromEmail', $fromEmail);
$this->set('fromName', $fromName);
if ($this->Sendgrid->sendgridsmtp($this->Email)) {
$UserInvitation->query("UPDATE user_invitations set qstr='" . $qstr . "' where qstr='" . $resend . "'");
$this->Session->write("SUCCESS", "Invitation resent to '" . $getUser['User']['email'] . "'");
$this->redirect(HTTP_ROOT . "users/manage/?role=invited");
}
}
}
$query = "";
if (isset($_GET['role']) && $_GET['role']) {
$role = $_GET['role'];
}
if (isset($_GET['type']) && $_GET['type']) {
$type = $_GET['type'];
}
if (isset($_GET['user_srch']) && $_GET['user_srch']) {
$user_srch = htmlentities(strip_tags($_GET['user_srch']));
}
if (isset($_GET['page']) && $_GET['page']) {
$page = $_GET['page'];
}
if ($role == "invited") {
$query .= " AND UserInvitation.is_active = '1'";
} else {
if (!$role || $role == 'all') {
$query .= " AND (CompanyUser.is_active = '1')";
} else {
if ($role == 2) {
$query .= " AND (CompanyUser.user_type = '" . $role . "' OR CompanyUser.user_type = '1')";
} elseif ($role == 3) {
$query .= " AND CompanyUser.user_type = '" . $role . "' AND CompanyUser.is_active = '1' ";
} elseif ($role == 'disable') {
$query .= " AND CompanyUser.is_active = '0'";
}
}
}
$page = 1;
if (isset($_GET['page']) && $_GET['page']) {
$page = $_GET['page'];
}
$limit1 = $page * $page_limit - $page_limit;
$limit2 = $page_limit;
if ($user_srch) {
$user_srch = addslashes(urldecode(htmlentities(strip_tags($user_srch))));
$query .= " AND (User.name LIKE '%" . $user_srch . "%' OR User.last_name LIKE '%" . $user_srch . "%' OR User.email LIKE '%" . $user_srch . "%' OR User.short_name LIKE '%" . $user_srch . "%')";
}
if (isset($_GET['user']) && $_GET['user']) {
$query .= " AND (User.uniq_id = '" . $_GET['user'] . "')";
}
if ($role == "invited") {
// $userArr = $this->User->query("SELECT SQL_CALC_FOUND_ROWS * FROM users AS User,user_invitations AS UserInvitation WHERE User.id=UserInvitation.user_id AND UserInvitation.company_id='" . SES_COMP . "' " . trim($query) . " ORDER BY User.dt_created DESC LIMIT $limit1,$limit2");
$userArr = $this->User->query("SELECT SQL_CALC_FOUND_ROWS * FROM company_users AS CompanyUser LEFT JOIN users AS User ON CompanyUser.user_id=User.id WHERE CompanyUser.company_id=" . SES_COMP . " AND CompanyUser.is_active ='2' AND User.email!='' AND (" . $search_query . ") ORDER BY User.dt_created DESC LIMIT {$limit1},{$limit2}");
} else {
$userArr = $this->User->query("SELECT SQL_CALC_FOUND_ROWS * FROM users AS User,company_users AS CompanyUser WHERE User.id=CompanyUser.user_id AND CompanyUser.company_id='" . SES_COMP . "' " . trim($query) . " ORDER BY User.dt_last_login DESC LIMIT {$limit1},{$limit2}");
}
$tot = $this->User->query("SELECT FOUND_ROWS() as total");
$totUser = count($userArr);
$arrusr = array();
App::import("Helper", array("Format", "Casequery", "Tmzone", "Datetime"));
$hFormat = new FormatHelper(new View(null));
$hCasequery = new CasequeryHelper(new View(null));
$hTmzone = new TmzoneHelper(new View(null));
$hDatetime = new DatetimeHelper(new View(null));
foreach ($userArr as $key => $usrall) {
$userArr[$key]['User']['name'] = $hFormat->formatText($usrall['User']['name']);
$userArr[$key]['User']['short_name'] = $hFormat->formatText($usrall['User']['short_name']);
$userArr[$key]['User']['email'] = $hFormat->formatText($usrall['User']['email']);
$userArr[$key]['User']['shln_email'] = $hFormat->shortLength($usrall['User']['email'], 30);
if ($role != 'invited' && $usrall['CompanyUser']['is_active'] != 2) {
$getprj = $hCasequery->getallproject($usrall['User']['id']);
$allpj = "";
foreach ($getprj as $k => $v) {
$allpj = $allpj . ", " . ucwords(strtolower($v));
}
$userArr[$key]['User']['all_project'] = $hFormat->shortLength(trim($allpj, ","), 20);
$userArr[$key]['User']['all_projects'] = trim($allpj, ",");
$userArr[$key]['User']['total_project'] = count($getprj);
} else {
$allpj = $hCasequery->getallInvitedProj($usrall['CompanyUser']['project_id']);
$userArr[$key]['User']['all_project'] = $hFormat->shortLength(trim($allpj, ","), 20);
//$userArr[$key]['User']['total_project'] = count($getprj);
}
if ($role == 'invited') {
$userArr[$key]['User']['qstr'] = $hCasequery->getinviteqstr($usrall['CompanyUser']['company_id'], $usrall['CompanyUser']['user_id']);
} else {
if ($usrall['CompanyUser']['is_active'] == 2) {
$userArr[$key]['User']['qstr'] = $hCasequery->getinviteqstr($usrall['CompanyUser']['company_id'], $usrall['CompanyUser']['user_id']);
}
}
if ($usrall['User']['dt_last_login']) {
$locDT = $hTmzone->GetDateTime(SES_TIMEZONE, TZ_GMT, TZ_DST, TZ_CODE, $usrall['User']['dt_last_login'], "datetime");
$gmdate = $hTmzone->GetDateTime(SES_TIMEZONE, TZ_GMT, TZ_DST, TZ_CODE, GMT_DATE, "date");
$userArr[$key]['User']['latest_activity'] = $hDatetime->dateFormatOutputdateTime_day($locDT, $gmdate);
}
if ($role == "invited") {
$crdt = $usrall['User']['dt_created'];
} else {
$crdt = $usrall['CompanyUser']['created'];
}
if ($crdt != "0000-00-00 00:00:00") {
$locDT = $hTmzone->GetDateTime(SES_TIMEZONE, TZ_GMT, TZ_DST, TZ_CODE, $crdt, "datetime");
$gmdate = $hTmzone->GetDateTime(SES_TIMEZONE, TZ_GMT, TZ_DST, TZ_CODE, GMT_DATE, "date");
$userArr[$key]['User']['created_on'] = $hDatetime->dateFormatOutputdateTime_day($locDT, $gmdate);
}
if (isset($usrall['User']['name']) && !empty($usrall['User']['name'])) {
array_push($arrusr, substr(trim($usrall['User']['name']), 0, 1));
}
}
$active_user_cnt = 0;
$invited_user_cnt = 0;
$disabled_user_cnt = 0;
$grpcount = $CompanyUser->query('SELECT count(CompanyUser.id) as usrcnt , CompanyUser.is_active FROM company_users CompanyUser LEFT JOIN users User on CompanyUser.user_id=User.id WHERE CompanyUser.company_id=' . SES_COMP . ' AND User.email!="" AND (' . $search_query . ') GROUP BY CompanyUser.is_active ');
// pr('SELECT count(CompanyUser.id) as usrcnt , CompanyUser.is_active FROM company_users CompanyUser LEFT JOIN users User on CompanyUser.user_id=User.id WHERE CompanyUser.company_id='.SES_COMP.' AND User.email!="" AND ('.$search_query.') GROUP BY CompanyUser.is_active ');exit;
if ($grpcount) {
foreach ($grpcount as $key => $val) {
if ($val['CompanyUser']['is_active'] == 1) {
$active_user_cnt = $val['0']['usrcnt'];
} elseif ($val['CompanyUser']['is_active'] == 2) {
$invited_user_cnt = $val['0']['usrcnt'];
} elseif ($val['CompanyUser']['is_active'] == 0) {
$disabled_user_cnt = $val['0']['usrcnt'];
}
}
}
$this->set('active_user_cnt', $active_user_cnt);
$this->set('invited_user_cnt', $invited_user_cnt);
$this->set('disabled_user_cnt', $disabled_user_cnt);
$this->set('caseCount', $tot[0][0]['total']);
$this->set('page_limit', $page_limit);
$this->set('page', $page);
$this->set('casePage', $page);
$this->set('projArr', $projArr);
$this->set('userArr', $userArr);
$this->set('role', $role);
$this->set('type', $type);
$this->set('user_srch', $user_srch);
$this->set('arrusr', $arrusr);
$this->set('totUser', $totUser);
if (isset($_GET['resetpassword']) && $_GET['resetpassword']) {
$this->User->recursive = -1;
$userUniqId = urldecode($_GET['resetpassword']);
$getData = $this->User->find("first", array('conditions' => array('User.uniq_id' => $userUniqId), 'fields' => array('User.name', 'User.email')));
if (count($getData)) {
$name = $getData['User']['name'];
$to = $getData['User']['email'];
$newPasswrod = $this->Format->generatePassword(6);
$subject = "Orangescrum Reset Password";
$message = "<table cellspacing='1' cellpadding='1' width='100%' border='0'>\n\t\t\t\t\t\t\t\t\t<tr><td> </td></tr>\n\t\t\t\t\t\t\t\t\t<tr><td align='left' style='font:normal 14px verdana;'>Hi " . $name . ",</td></tr>\n\t\t\t\t\t\t\t\t\t<tr><td> </td></tr>\n\t\t\t\t\t\t\t\t\t<tr><td align='left' style='font:normal 14px verdana;'>Your Password has been reset to <b>" . $newPasswrod . "</b></td></tr>\n\t\t\t\t\t\t\t\t\t<tr><td> </td></tr>\n\t\t\t\t\t\t\t\t\t<tr><td> </td></tr>\n\t\t\t\t\t\t\t\t</table>\n\t\t\t\t\t\t\t\t";
if ($this->Sendgrid->sendGridEmail(FROM_EMAIL, $to, $subject, $message, "ResetPassword")) {
$newMd5Passwrod = md5($newPasswrod);
$this->User->query("UPDATE users SET password='******' WHERE uniq_id='" . $userUniqId . "'");
$this->Session->write("SUCCESS", "Password of '" . $name . "' reset successfully");
$this->redirect(HTTP_ROOT . "users/manage/");
}
}
}
}
function dailyupdate_notifications()
{
$this->layout = 'ajax';
echo "Running Cron Job...";
$Easycase = ClassRegistry::init('Easycase');
$this->loadModel('Timezone');
$this->loadModel('Project');
$DailyupdateNotification = ClassRegistry::init('DailyupdateNotification');
$getAllNot = $DailyupdateNotification->find('all', array('conditions' => array('DailyupdateNotification.dly_update' => 1, 'User.isactive' => 1, 'User.name !=' => ''), 'fields' => array('DailyupdateNotification.id', 'DailyupdateNotification.user_id', 'DailyupdateNotification.notification_time', 'DailyupdateNotification.proj_name', 'DailyupdateNotification.mail_sent', 'User.email', 'User.timezone_id'), 'order' => array('User.id ASC')));
foreach ($getAllNot as $emlNot) {
$to = $emlNot['User']['email'];
$timezn = $this->Timezone->find('first', array('conditions' => array('Timezone.id' => $emlNot['User']['timezone_id']), 'fields' => array('Timezone.gmt_offset', 'Timezone.dst_offset', 'Timezone.code')));
App::import('Helper', 'Tmzone');
$tmzone = new TmzoneHelper(new View(null));
$gmt_datetime = gmdate('Y-m-d H:i:s');
$dateCurnt = $tmzone->GetDateTime($emlNot['User']['timezone_id'], $timezn['Timezone']['gmt_offset'], $timezn['Timezone']['dst_offset'], $timezn['Timezone']['code'], $gmt_datetime, "datetime");
$dateToday = $tmzone->GetDateTime($emlNot['User']['timezone_id'], $timezn['Timezone']['gmt_offset'], $timezn['Timezone']['dst_offset'], $timezn['Timezone']['code'], $gmt_datetime, "date");
$dateSent = '';
if ($emlNot['DailyupdateNotification']['mail_sent']) {
$dateSent = $tmzone->GetDateTime($emlNot['User']['timezone_id'], $timezn['Timezone']['gmt_offset'], $timezn['Timezone']['dst_offset'], $timezn['Timezone']['code'], $emlNot['DailyupdateNotification']['mail_sent'], "date");
}
$time = date('H:i', strtotime($dateCurnt));
$curtime = strtotime($time);
$nottime = strtotime($emlNot['DailyupdateNotification']['notification_time']);
if ($dateSent != $dateToday && $nottime <= $curtime) {
$projArr = '';
$projidarr = explode(",", $emlNot['DailyupdateNotification']['proj_name']);
$this->Project->recursive = -1;
$projArr = $this->Project->find('all', array('conditions' => array('Project.id' => $projidarr, 'Project.isactive' => 1), 'fields' => array('Project.id', 'Project.name', 'Project.short_name')));
$comp = ClassRegistry::init('CompanyUser')->query("SELECT seo_url FROM companies AS Company,company_users AS CompanyUser WHERE Company.id=CompanyUser.company_id AND CompanyUser.user_id='" . $emlNot['DailyupdateNotification']['user_id'] . "'");
$comp_url = $comp['0']['Company']['seo_url'] . DOMAIN_COOKIE;
foreach ($projArr as $prj) {
$prjId = $prj['Project']['id'];
$projName = $prj['Project']['name'];
$projShName = $prj['Project']['short_name'];
$rngFrom = date('Y-m-d', $nottime);
$rngFromGMT = $tmzone->GetDateTime(27, -1 * $timezn['Timezone']['gmt_offset'], 0, NULL, $rngFrom, "datetime");
$rngTo = date('Y-m-d H:i:s', $nottime);
$rngToGMT = $tmzone->GetDateTime(27, -1 * $timezn['Timezone']['gmt_offset'], 0, NULL, $rngTo, "datetime");
$arr = array('Easycase.dt_created BETWEEN ? AND ?' => array($rngFromGMT, $rngToGMT));
$leg = array(2, 3, 4, 5);
$query_All = $Easycase->find('count', array('conditions' => array('Easycase.isactive' => 1, 'Easycase.project_id' => $prjId, 'Easycase.istype' => 1, 'Easycase.type_id !=' => 10, 'Easycase.legend' => $leg, $arr), 'fields' => 'DISTINCT Easycase.id'));
if ($query_All) {
$case_all = $Easycase->find('all', array('conditions' => array('Easycase.isactive' => 1, 'Easycase.project_id' => $prjId, 'Easycase.istype' => 1, 'Easycase.type_id !=' => 10, 'Easycase.legend' => $leg, $arr), 'fields' => array('Easycase.case_no', 'Easycase.title', 'Easycase.legend', 'Easycase.message')));
$str_case = "<table style='width:80%;border-collapse:collapse;border-spacing:0;font-family:Arial;font-size:14px;'>";
$typ_arr = array('1' => '<font color="#AE432E">New</font>', '2' => '<font color="#244F7A">In Progress</font>', '3' => '<font color="#387600">Closed</font>', '4' => '<font color="#244F7A">Started</font>', '5' => '<font color="#EF6807">Resolved</font>');
foreach ($case_all as $case) {
$prj_shortname = $projShName;
$case_no = $case['Easycase']['case_no'];
$case_title = $case['Easycase']['title'];
$case_status1 = $case['Easycase']['legend'];
$case_status = $typ_arr[$case_status1];
$case_replyAll = $Easycase->find('all', array('conditions' => array('Easycase.project_id' => $prjId, 'Easycase.istype' => 2, 'Easycase.case_no' => $case_no, $arr), 'fields' => array('Easycase.message')));
//pr($case_replyAll);die;
if (in_array($case['Easycase']['legend'], $leg)) {
$str_case .= "<tr><td><b>Task# {$case_no}: </b>{$case_title}</td></tr>";
if ($case_replyAll) {
$str_case .= "<tr><td><ul>";
foreach ($case_replyAll as $casereply) {
if ($casereply['Easycase']['message']) {
$caserly = $casereply['Easycase']['message'];
$str_case .= "<li>{$caserly}</li>";
}
}
$str_case .= "</ul></td></tr>";
}
$str_case .= "<tr><td> Status: {$case_status}</td></tr><tr style='height:25px;'><td> </td></tr>";
}
}
$str_case .= "</table>";
if (count($case_all) > 1) {
$casecount = count($case_all) . " Tasks";
} else {
$casecount = count($case_all) . " Task";
}
if (count($case_all) == 0) {
$sb_title = "No Tasks Today<br/><br/><br/>";
}
$sub = $casecount . " Updated on " . $projName;
$subject = $sub . " - " . date("m/d", strtotime(GMT_DATE));
$message = "<tr><td><table style='border-collapse:collapse;border-spacing:0;text-align:left;width:600px;border:1px solid #5191BD'>\n\t\t\t\t\t\t\t\t<tr style='background:#5191BD;height:50px;'>\n\t\t\t\t\t\t\t\t\t<td style='font:bold 14px Arial;padding:10px;color:#FFFFFF;'>\n\t\t\t\t\t\t\t\t\t\t<span style='font-size:18px;'>Orangescrum</span> - Daily Task Updates\n\t\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<td style='padding:10px;'>\n\t\t\t\t\t\t\t\t\t\t" . str_replace('<tr><td><ul></ul></td></tr>', '', $str_case) . "\n\t\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<td align='left' style='font:14px Arial;padding:10px;border-top:1px solid #E1E1E1'>\n\t\t\t\t\t\t\t\t\t\tThanks,<br/>\n\t\t\t\t\t\t\t\t\t\tTeam Orangescrum\n\t\t\t\t\t\t\t\t\t</td>\t \n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t</table></td></tr>\n\t\t\t\t\t\t\t<tr><td>\n\t\t\t\t\t\t\t<table style='margin-top:5px;width:600px;'>\n\t\t\t\t\t\t\t\t<tr><td style='font:13px Arial;color:#737373;'>Don't want these emails? To unsubscribe, please click <a href='" . HTTP_ROOT . "users/email_notifications' target='_blank'>Unsubscribe</a> and trun off <b>Daily Update Report</b> E-mail notification.</td></tr>\n\t\t\t\t\t\t\t</table></td></tr>\n\t\t\t\t\t\t\t";
$this->Sendgrid->sendGridEmail(FROM_EMAIL_NOTIFY, $to, $subject, $message, "notification");
}
}
$DailyupdateNotification->query('UPDATE `dailyupdate_notifications` SET `mail_sent`= \'' . GMT_DATETIME . '\' WHERE `id` =' . $emlNot['DailyupdateNotification']['id']);
}
}
echo "Success";
exit;
}
