function scheduleNewEmail_temp($email_to, $email_content, $subject, $caldate_day, $hour, $USERNAME)
{
$manageUsers = new manageUsers();
$thisuserEmailId = $manageUsers->get_userSingleDetail($USERNAME, 'user_primaryEmail');
$delivery_ts = $caldate_day . ' ' . $hour . ':10:00';
// 'YYYY-MM-DD HH:MM:SS'
$details = array('emailby_user' => $USERNAME, 'email_to' => $email_to, 'email_content' => $email_content, 'emailby_from' => $thisuserEmailId, 'email_subject' => $subject, 'email_scheduledon' => $delivery_ts);
$success = execute_sqlInsert("scheduledmails", $details);
}
public function scheduleNewEmail($email_to, $email_content, $subject, $caldate_day, $hour)
{
$USERNAME = $_SESSION['uname'];
$manageUsers = new manageUsers();
$thisuserEmailId = $manageUsers->get_userSingleDetail($USERNAME, 'user_primaryEmail');
$delivery_ts = $caldate_day . ' ' . $hour . ':01:00';
// 'YYYY-MM-DD HH:MM:SS'
$details = array(emailby_user => $USERNAME, email_to => $email_to, email_content => $email_content, emailby_from => $thisuserEmailId, email_subject => $subject, email_scheduledon => $delivery_ts);
$success = execute_sqlInsert("scheduledmails", $details);
}
echo JSASSETS_URL; ?> date_input.css" type="text/css" charset="utf-8"> <link rel="stylesheet" href="css/global.css" type="text/css" charset="utf-8"> </HEAD> <BODY topmargin=0 leftmargin=0> <div id='feedbackmsg'> </div> <div id='ajaxstatus' style='display:none;'><nobr><img src='/images/loading1.gif' border=0> Loading.. </nobr></div> <div id='search_DIV_main' style='display:none;'> <input type=text size=16 id='de_search_text'> <span class='bluebuttonSmall' onclick='DiscreteEvents_Search();'>Search</span> </div> <div id='logout_DIV_main' onclick="LOGOUT_USER();" TITLE="Log-out and remove the cookie from your machine">Logout</div> <div class="topHeaderImages" style="<?php echo "background-color: " . $tmpManageUsers->get_userSingleDetail($_SESSION["uname"], 'user_bgcolor') . ";"; ?> "> <img src="images/delogo_header.png" border=0> </div> <div style='display:none;'> <form action='search.php' method='post' name='searchform'> <input type='text' id='search_term' name='search_term'> </form> </div> <script>
</tr> </table> </div> <div style='clear:both; margin-left:auto; margin-right:auto; margin-top:25px;'> <table cellpadding=0 cellspacing=2 border=0 width='90%' align=center> <tr> <Td align=center> <b><nobr>iCal Reminders URL</nobr></b> </td> </tr> <tr> <td> <?php $tmp_manageUsers = new manageUsers(); $this_key = $tmp_manageUsers->get_userSingleDetail($username, 'remindersicalkey'); echo 'http://' . $_SESSION["subdomain"] . '.discreteevents.com/ical_reminders.php?key=' . $this_key; ?> </td> </tr> <tr> <td align='center'> <span class="bluebutton" onclick="newIcalURL()"> Generate new iCal URL </span> </td> </tr> </table> </div> <?php include "include_footer.php";
<?php
include_once "include_db.php";
include_once "include_functions.php";
$uekey = @$_GET["key"];
$USERNAME = executesql_returnArray("select username from users where remindersicalkey='{$uekey}' ;");
if (!$USERNAME) {
exit;
}
$tmp_manageUsers = new manageUsers();
$actual_key = $tmp_manageUsers->get_userSingleDetail($USERNAME, 'remindersicalkey');
if (!$uekey || $uekey != $actual_key) {
exit;
}
$result = mysql_query("select * from scheduledmails where emailby_user='******' order by email_scheduledon");
$scE_Count = @mysql_num_rows($result);
?>
BEGIN:VCALENDAR
PRODID:-//CenterLimit LLC//DiscreteEvents Reminders Calendar 0.01//EN
VERSION:2.0
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:DiscreteEvents Reminders
X-WR-TIMEZONE:Asia/Calcutta
X-WR-CALDESC:DiscreteEvents Reminders for <?php
echo $USERNAME;
if ($scE_Count == 0) {
echo "\nEND:VCALENDAR";
exit;
}
while ($row = mysql_fetch_assoc($result)) {
<script>
var show_scheduleEmailForm = function(subj , body ){
//My_JsLibrary.showdeadcenterdiv( 'ScheduleEmail_Form' );
if(!subj){ var subj = '';}
if(!body){ var body = '';}
EDIT_SCHEDULEDEMAILID = 0 ;
<?php
$manageUsers = new manageUsers();
$username = $_SESSION["uname"];
echo "var myemail='" . $manageUsers->get_userSingleDetail($username, 'user_primaryEmail') . "';";
echo "var TomorrowCaldate='" . getTomorrowCaldate(1) . "';";
?>
$("#ScheduleEmail_Form_Title").html('Schedule a Reminder');
_$('nu_scEmail_to').value = myemail ;
_$('nu_scEmail_when').value = TomorrowCaldate ;
_$('nu_scEmail_subject').value = subj ;
_$('nu_scEmail_body').value = body ;
$('#ScheduleEmail_Form').showWithBg();
_$('nu_scEmail_subject').focus();
};
var schedule_newTask = function(){
var emailTo = My_JsLibrary.getFieldValue('nu_scEmail_to');
var emailSubject = My_JsLibrary.getFieldValue('nu_scEmail_subject');
var emailBody = My_JsLibrary.getFieldValue('nu_scEmail_body');
var emailWhen = My_JsLibrary.getFieldValue('nu_scEmail_when');
var emailHour = My_JsLibrary.getFieldValue('nu_scEmail_hr');
if( ! My_JsLibrary.checkRequiredFields( ['nu_scEmail_to', 'nu_scEmail_subject', 'nu_scEmail_when'] ) ){
$mainResult = mysql_query("select dbname as thisdb, timezone as thisTimeZone from " . MASTERDB . ".subdomains where status='Y' ORDER BY pid ");
while ($mainrow = @mysql_fetch_array($mainResult)) {
extract($mainrow);
// $thisdb , $thisTimeZone
putenv("TZ=" . $thisTimeZone);
// Scheduled Tasks
$thisdb_result = mysql_query("select workID, work_userAssigned, work_addedBy, work_dateAdded, work_deadLine, work_startDate, work_completeDate, work_briefDesc, work_Notes, work_status, work_priority, work_projectName, work_isPrivate, daysb4deadline , work_RTID from " . $thisdb . ".WORKS where work_status='" . $DE_GLOBALS_WORK_SCHEDULED . "'");
while ($row = @mysql_fetch_array($thisdb_result)) {
extract($row);
// workID, work_userAssigned, work_addedBy, work_dateAdded, work_deadLine, work_startDate, work_completeDate,
// work_briefDesc, work_Notes, work_status, work_priority, work_projectName, work_isPrivate, daysb4deadline
if (isTodayXdaysBeforeDeadline($daysb4deadline, $work_deadLine)) {
$somequery = mysql_query("update " . $thisdb . ".WORKS set work_status = '" . $DE_GLOBALS_WORK_NEW . "' where workID='{$workID}' ");
$ST_emailText[] = "Task {$workID} of {$thisdb} is added to tasks from scheduled list - <BR> Work Description : {$work_briefDesc} <BR> Deadline: {$work_deadLine} <BR> Days Before : {$daysb4deadline} ";
$tmp_manageUsers = new manageUsers();
$email_userAssigned = $tmp_manageUsers->get_userSingleDetail($work_userAssigned, 'user_primaryEmail');
$email_taskOwner = $tmp_manageUsers->get_userSingleDetail($work_addedBy, 'user_primaryEmail');
$scheduledtask_invoked_email = new sendaMail();
if ($email_userAssigned) {
$scheduledtask_invoked_email->messageTo($email_userAssigned);
}
if ($email_taskOwner && $email_userAssigned != $email_taskOwner) {
$scheduledtask_invoked_email->messageTo($email_taskOwner);
}
if ($work_RTID > 0) {
$scheduledtask_invoked_email->subject("Added Recurring Task {$workID} - {$work_briefDesc} ");
} else {
$scheduledtask_invoked_email->subject("Moved Scheduled Task {$workID} - {$work_briefDesc} ");
}
$scheduledtask_invoked_email->body("Task Description: {$work_briefDesc} <BR> Task Deadline: {$work_deadLine} ");
$scheduledtask_invoked_email->send();
$responseEmail .= "\n" . "Added By : " . $taskDetails["work_addedBy"];
$responseEmail .= "\n" . "Assigned to : " . $taskDetails["work_userAssigned"];
$responseEmail .= "\n" . "Task Created On : " . $taskDetails["work_dateAdded"];
$responseEmail .= "\n" . "Task Deadline : " . $taskDetails["work_deadLine"];
$responseEmail .= "\n\n" . "Comments : ";
while ($row = mysql_fetch_assoc($comments_result)) {
$responseEmail .= "\n" . "----------------------------------------------------";
$responseEmail .= "\n" . $row['comment_by'] . " on " . $row['comment_date'];
$responseEmail .= "\n" . $row['comment'];
}
$responseEmail .= "\n\n";
} else {
$responseEmail = $taskDetails["work_briefDesc"];
}
$tmp_manageUsers = new manageUsers();
$user_fromEMailId = $tmp_manageUsers->get_userSingleDetail($USERNAME, 'user_primaryEmail');
$email = new sendaMail();
$email->asFrom($user_fromEMailId);
$email->messageTo($toemailId);
$email->subject("Details of task - " . $workid);
$email->body($responseEmail);
if ($includeAttachments == 'yes') {
$COMMENTLOGMESSAGE .= "\n Included Attachments";
$attachments = mysql_query("select diskfilename, uploadname from attachments where workid='{$workid}' ");
while ($row = mysql_fetch_assoc($attachments)) {
$email->AddAttachment(APP_INSTALLPATH . 'attachments/' . $_SESSION["subdomain"] . '/' . $row['diskfilename'], $row['uploadname']);
}
}
$email->send();
$manageWorks->addComment($workid, APPNAME, $COMMENTLOGMESSAGE);
send_Action_Response('Success', "Details emailed !");
