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 !");