/** * This function sends a mail to the handler whenever the product reaches the reorder level. * Param $product_id - product id * Param $upd_qty - updated product quantity in no's * Param $prod_name - product name * Param $qtyinstk - quantity in stock * Param $qty - quantity * Param $module - module name * return type void */ function sendPrdStckMail($product_id, $upd_qty, $prod_name, $qtyinstk, $qty, $module) { global $log; $log->debug("Entering sendPrdStckMail(" . $product_id . "," . $upd_qty . "," . $prod_name . "," . $qtyinstk . "," . $qty . "," . $module . ") method ..."); global $current_user; global $adb; $reorderlevel = getPrdReOrderLevel($product_id); $log->debug("Inside sendPrdStckMail function, module=" . $module); $log->debug("Prd reorder level " . $reorderlevel); if ($upd_qty < $reorderlevel) { //send mail to the handler $handler = getRecordOwnerId($product_id); foreach ($handler as $type => $id) { $handler = $id; } $handler_name = getOwnerName($handler); if (vtws_isRecordOwnerUser($handler)) { $to_address = getUserEmail($handler); } else { $to_address = implode(',', getDefaultAssigneeEmailIds($handler)); } //Get the email details from database; if ($module == 'SalesOrder') { $notification_table = 'SalesOrderNotification'; $quan_name = '{SOQUANTITY}'; } if ($module == 'Quotes') { $notification_table = 'QuoteNotification'; $quan_name = '{QUOTEQUANTITY}'; } if ($module == 'Invoice') { $notification_table = 'InvoiceNotification'; } $query = "select * from vtiger_inventorynotification where notificationname=?"; $result = $adb->pquery($query, array($notification_table)); $subject = $adb->query_result($result, 0, 'notificationsubject'); $body = $adb->query_result($result, 0, 'notificationbody'); $status = $adb->query_result($result, 0, 'status'); if ($status == 0 || $status == '') { return false; } $subject = str_replace('{PRODUCTNAME}', $prod_name, $subject); $body = str_replace('{HANDLER}', $handler_name, $body); $body = str_replace('{PRODUCTNAME}', $prod_name, $body); if ($module == 'Invoice') { $body = str_replace('{CURRENTSTOCK}', $upd_qty, $body); $body = str_replace('{REORDERLEVELVALUE}', $reorderlevel, $body); } else { $body = str_replace('{CURRENTSTOCK}', $qtyinstk, $body); $body = str_replace($quan_name, $qty, $body); } $body = str_replace('{CURRENTUSER}', $current_user->user_name, $body); $mail_status = send_mail($module, $to_address, $current_user->user_name, $current_user->email1, decode_html($subject), nl2br(to_html($body))); } $log->debug("Exiting sendPrdStckMail method ..."); }
public static function isUserRegistered($userId, $moduleComponentId) { if (isInternalUserRegistered($userId, $moduleComponentId, false)) { return true; } $userEmail = getUserEmail($userId); if (isExternalUserRegistered($userEmail, $moduleComponentId)) { moveUserToInternal($userEmail, $userId); return true; } return false; }
public function index() { $myID = getUserID(); $name = trim(jsonInput('name')); $description = jsonInput('description'); $membersPost = jsonInput('members'); $this->np_validations(); $newProjID = $this->mdb->project_add($myID, $name, $description); if ($newProjID) { //add yourself in project members $this->mdb->project_member_add(array('project_id' => $newProjID, 'user_id' => $myID, 'email_address' => getUserEmail(), 'joined_by' => 0, 'date_joined' => today(), 'last_visit' => today(), 'is_accepted' => 1, 'project_role' => 3)); $this->mdb->add_project_settings(array('project_id' => $newProjID, 'task_approval' => 0, 'project_approval' => 1)); //add specified members to project if (is_array($membersPost)) { foreach ($membersPost as $member) { if (filter_var($member, FILTER_VALIDATE_EMAIL)) { $qChkifAlreadyMember = $this->mdb->checkIfAlreadyMember($newProjID, $member); if (!$qChkifAlreadyMember) { $qChkUser = $this->model->getUserInfo(array('email_address' => $member)); if ($qChkUser->num_rows()) { $pmRow = $qChkUser->row(); $this->mdb->project_member_add(array('project_id' => $newProjID, 'user_id' => $pmRow->id, 'email_address' => $pmRow->email_address, 'joined_by' => $myID, 'date_joined' => today(), 'last_visit' => NULL, 'is_accepted' => 0, 'project_role' => $this->siteinfo->config('project_roles_default'))); //notification notify('project_invite', $pmRow->id, array('project_id' => $newProjID)); $qProj = $this->db->get_where('projects', array('id' => $newProjID)); if ($qProj->num_rows()) { $qProjRow = $qProj->row(); $myName = $this->session->userdata('display_name'); $redirectLink = base_url('#/app/projects/' . $newProjID); do_sendmail($pmRow->id, $qProjRow->project_name, "{$myName} invited you to join <a href='{$redirectLink}'>" . $qProjRow->project_name . "</a>"); } } else { $this->mdb->project_member_add(array('project_id' => $newProjID, 'user_id' => 0, 'email_address' => $member, 'joined_by' => $myID, 'date_joined' => today(), 'last_visit' => NULL, 'is_accepted' => 0, 'project_role' => $this->siteinfo->config('project_roles_default'))); } } } } } //add project roles foreach ($this->siteinfo->config('project_roles') as $roleID => $role) { $default = $this->siteinfo->config('project_roles_default') == $roleID ? 1 : 0; $this->mdb->project_roles_add($newProjID, $roleID, $default, $role); } } generate_json(array('status' => 1, 'message' => 'New project has been created.')); }
public function index() { $myID = getUserID(); $myEmail = getUserEmail(); $pID = (int) $this->input->get('id'); $visitorType = visitor_type($pID, $myID); $query = $this->mdb->project_get($pID); if ($query->num_rows()) { $row = $query->row(); switch ($visitorType) { case 'invited': $this->mdb->project_member_remove($row->id, $myID); break; } generate_json(array('status' => 1)); } else { generate_json(array('status' => 0, 'message' => 'Project does not exists.')); } }
echo " Gagal," . addslashes(mysql_error($conn)); } break; case 'insert_persetujuan': $sql = "SELECT * FROM " . $dbname . ".`log_prapoht` WHERE `nopp`='" . $nopp . "' "; $query = mysql_query($sql) or die(mysql_error()); $rest = mysql_fetch_assoc($query); if ($rest['close'] > 1) { echo "Warning: Status closed, Can't update the status"; exit; } elseif ($rest['hasilpersetujuan1'] < 1) { $stat_cls = 1; $strx = "update " . $dbname . ". log_prapoht set persetujuan1='" . $user_id . "',close='" . $stat_cls . "' where nopp='" . $nopp . "'"; if (mysql_query($strx)) { #send an email to incharge person $to = getUserEmail($user_id); $namakaryawan = getNamaKaryawan($_SESSION['standard']['userid']); if ($_SESSION['language'] == 'EN') { $subject = "[Notifikasi] PR Submission for approval, submitted by: " . $namakaryawan; $body = "<html>\n\t\t\t\t\t\t\t <head>\n\t\t\t\t\t\t\t <body>\n\t\t\t\t\t\t\t <dd>Dear Sir/Madam,</dd><br>\n\t\t\t\t\t\t\t <br>\n\t\t\t\t\t\t\t Today, " . date('d-m-Y') . ", on behalf of " . $namakaryawan . " submit a PR, requesting for your approval. To follow up, please follow the link below.\n\t\t\t\t\t\t\t <br>\n\t\t\t\t\t\t\t <br>\n\t\t\t\t\t\t\t <br>\n\t\t\t\t\t\t\t Regards,<br>\n\t\t\t\t\t\t\t Owl-Plantation System.\n\t\t\t\t\t\t\t </body>\n\t\t\t\t\t\t\t </head>\n\t\t\t\t\t\t </html>\n\t\t\t\t\t\t "; } else { $subject = "[Notifikasi]Persetujuan PP a/n " . $namakaryawan; $body = "<html>\n\t\t\t\t\t\t\t <head>\n\t\t\t\t\t\t\t <body>\n\t\t\t\t\t\t\t <dd>Dengan Hormat,</dd><br>\n\t\t\t\t\t\t\t <br>\n\t\t\t\t\t\t\t Pada hari ini, tanggal " . date('d-m-Y') . " karyawan a/n " . $namakaryawan . " mengajukan Permintaan Pembelian Barang\n\t\t\t\t\t\t\t kepada bapak/ibu. Untuk menindak-lanjuti, silahkan ikuti link dibawah.\n\t\t\t\t\t\t\t <br>\n\t\t\t\t\t\t\t <br>\n\t\t\t\t\t\t\t <br>\n\t\t\t\t\t\t\t Regards,<br>\n\t\t\t\t\t\t\t Owl-Plantation System.\n\t\t\t\t\t\t\t </body>\n\t\t\t\t\t\t\t </head>\n\t\t\t\t\t\t </html>\n\t\t\t\t\t\t "; } $kirim = kirimEmail($to, '', $subject, $body); #this has return but disobeying; } else { echo " Gagal," . addslashes(mysql_error($conn)); } } else { echo "Warning: Documents already in the process";
public function getRecipientEmails() { $recipientsInfo = $this->scheduledRecipients; $recipientsList = array(); if (!empty($recipientsInfo)) { if (!empty($recipientsInfo['users'])) { $recipientsList = array_merge($recipientsList, $recipientsInfo['users']); } if (!empty($recipientsInfo['roles'])) { foreach ($recipientsInfo['roles'] as $roleId) { $roleUsers = getRoleUsers($roleId); foreach ($roleUsers as $userId => $userName) { array_push($recipientsList, $userId); } } } if (!empty($recipientsInfo['rs'])) { foreach ($recipientsInfo['rs'] as $roleId) { $users = getRoleAndSubordinateUsers($roleId); foreach ($users as $userId => $userName) { array_push($recipientsList, $userId); } } } if (!empty($recipientsInfo['groups'])) { require_once 'include/utils/GetGroupUsers.php'; foreach ($recipientsInfo['groups'] as $groupId) { $userGroups = new GetGroupUsers(); $userGroups->getAllUsersInGroup($groupId); $recipientsList = array_merge($recipientsList, $userGroups->group_users); } } } $recipientsEmails = array(); if (!empty($recipientsList) && count($recipientsList) > 0) { foreach ($recipientsList as $userId) { $userName = getUserFullName($userId); $userEmail = getUserEmail($userId); if (!in_array($userEmail, $recipientsEmails)) { $recipientsEmails[$userName] = $userEmail; } } } return $recipientsEmails; }
function getProfileRegistrantsList($showEditButtons = false) { global $urlRequestRoot, $cmsFolder, $moduleFolder, $templateFolder, $sourceFolder; require_once "{$sourceFolder}/{$moduleFolder}/form/viewregistrants.php"; $sortField = 'useremail'; $sortOrder = 'asc'; if (isset($_GET['sortfield'])) { $sortField = escape($_GET['sortfield']); } if (isset($_GET['sortorder']) && ($_GET['sortorder'] == 'asc' || $_GET['sortorder'] == 'desc')) { $sortOrder = escape($_GET['sortorder']); } $action = './+admin&subaction=' . escape($_GET['subaction']); $columnList['useremail'] = 'User Email'; $columnList['username'] = '******'; $columnList['userfullname'] = 'User Full Name'; $columnList['registrationdate'] = 'Registration Date'; $columnList['lastupdated'] = 'Last Updated'; $columnList = array_merge($columnList, getColumnList(0, false, false, false, false)); $normalImage = "<img alt=\"Sort by this field\" height=\"12\" width=\"12\" style=\"padding:0px\" src=\"{$urlRequestRoot}/{$cmsFolder}/{$templateFolder}/common/icons/16x16/actions/view-refresh.png\" />"; $orderedImage = "<img alt=\"Sort by this field\" height=\"12\" width=\"12\" style=\"padding:0px\" src=\"{$urlRequestRoot}/{$cmsFolder}/{$templateFolder}/common/icons/16x16/actions/go-" . ($sortOrder == 'asc' ? 'up' : 'down') . ".png\" />"; $tableCaptions = "<tr>\n<th nowrap=\"nowrap\">S. No.</th>\n"; if ($showEditButtons) { $tableCaptions .= '<th nowrap="nowrap">Edit</th><th nowrap="nowrap">Delete</th>'; } foreach ($columnList as $columnName => $columnTitle) { $tableCaptions .= "<th nowrap=\"nowrap\">{$columnTitle}<a href=\"{$action}&sortfield={$columnName}"; if ($sortField == $columnName) { $tableCaptions .= '&sortorder=' . ($sortOrder == 'asc' ? 'desc' : 'asc') . '">' . $orderedImage . '</a>'; } else { $tableCaptions .= '">' . $normalImage . '</a>'; } $tableCaptions .= "</th>\n"; $columnNames[] = $columnName; } $tableCaptions .= "</tr>\n"; $userIds = getDistinctRegistrants(0, $sortField, $sortOrder); $userCount = count($userIds); $editImage = "<img style=\"padding:0px\" src=\"{$urlRequestRoot}/{$cmsFolder}/{$templateFolder}/common/icons/16x16/apps/accessories-text-editor.png\" alt=\"Edit\" />"; $deleteImage = "<img style=\"padding:0px\" src=\"{$urlRequestRoot}/{$cmsFolder}/{$templateFolder}/common/icons/16x16/actions/edit-delete.png\" alt=\"Delete\" />"; $tableBody = ''; for ($i = 0; $i < $userCount; $i++) { $tableBody .= '<tr><td>' . ($i + 1) . '</td>'; if ($showEditButtons) { $tableBody .= '<td align="center"><a href="./+admin&subaction=editsiteregistrants&subsubaction=editregistrant&useremail=' . getUserEmail($userIds[$i]) . '" />' . $editImage . '</a></td>'; $tableBody .= '<td align="center"><a href="./+admin&subaction=editsiteregistrants&subsubaction=deleteregistrant&useremail=' . getUserEmail($userIds[$i]) . '" />' . $deleteImage . '</a></td>'; } $tableBody .= '<td>' . join(generateFormDataRow(0, $userIds[$i], $columnNames), '</td><td>') . "</td></tr>\n"; } return '<br /><br /><br /><table border="1">' . $tableCaptions . $tableBody . '</table>'; }
function sendMailUserTicketClose($mail_refno) { global $conn; $sql = " Select * from sptbl_lookup where vLookUpName IN('MailFromName','MailFromMail',"; $sql .= "'MailReplyName','MailReplyMail','Emailfooter','Emailheader','MailEscalation','HelpdeskTitle')"; $result = executeSelect($sql, $conn); if (mysql_num_rows($result) > 0) { while ($row2 = mysql_fetch_array($result)) { switch ($row2["vLookUpName"]) { case "MailFromName": $var_fromName = $row2["vLookUpValue"]; break; case "MailFromMail": $var_fromMail = $row2["vLookUpValue"]; break; case "MailReplyName": $var_replyName = $row2["vLookUpValue"]; break; case "MailReplyMail": $var_replyMail = $row2["vLookUpValue"]; break; case "Emailfooter": $var_emailfooter = $row2["vLookUpValue"]; break; case "Emailheader": $var_emailheader = $row2["vLookUpValue"]; break; case "MailEscalation": $var_emailescalation = $row2["vLookUpValue"]; break; case "HelpdeskTitle": $var_helpdesktitle = $row2["vLookUpValue"]; break; } } } $sql = "Select u.nUserId, u.vUserName, u.vEmail, t.nTicketId from sptbl_tickets t INNER JOIN sptbl_users u ON t.nUserId = u.nUserId WHERE t.vRefNo = '" . mysql_real_escape_string(trim($mail_refno)) . "' ORDER BY t.nTicketId DESC LIMIT 1"; $result_user = executeSelect($sql, $conn); if (mysql_num_rows($result_user) > 0) { $row_user = mysql_fetch_array($result_user); $toemail = $row_user['vEmail']; $var_body = $var_emailheader . "<br>" . TEXT_MAIL_START . " " . $row_user['vUserName'] . ",<br>"; $var_body .= TEXT_CLOSED_BODY . " " . $mail_refno . TEXT_MAIL_BY . htmlentities($_SESSION['sess_staffname']) . "<br><br>"; // $sql_reply = "SELECT nReplyId FROM sptbl_replies WHERE nTicketId='".$row_user['nTicketId']."'"; $sql_reply = "SELECT vStaffLogin FROM sptbl_tickets WHERE nTicketId='" . $row_user['nTicketId'] . "' AND ( vStaffLogin !='NULL' OR \tvStaffLogin !='' OR \tvStaffLogin !='0')"; $res_reply = executeSelect($sql_reply, $conn); if (mysql_num_rows($res_reply) > 0) { $row_staff = mysql_fetch_array($res_reply); if ($row_staff['vStaffLogin'] != "") { $var_body .= TEXT_RATE_URL_MSG1 . " <a href='" . SITE_URL . "rating.php?uid=" . $row_user['nUserId'] . "&ticket_id=" . $row_user['nTicketId'] . "'> " . TEXT_RATE_URL_MSG2 . " </a> " . TEXT_RATE_URL_MSG3 . " <br><br>"; } } $var_body .= TEXT_MAIL_THANK . "<br>" . htmlentities($var_helpdesktitle) . "<br>" . $var_emailfooter; $var_subject = TEXT_CLOSED_SUB . " " . $mail_refno; $Headers = "From: {$var_fromName} <{$var_fromMail}>\n"; $Headers .= "Reply-To: {$var_replyName} <{$var_replyMail}>\n"; $Headers .= "MIME-Version: 1.0\n"; $Headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; // echo $var_body;exit; // it is for smtp mail sending $useremail = getUserEmail($row_user['nUserId']); //get user email if (!in_array($toemail, $useremail)) { $useremail[] = $toemail; } if (count($useremail) > 0) { foreach ($useremail as $key => $value) { $toemail_us = $value; if ($_SESSION["sess_smtpsettings"] == 1) { $var_smtpserver = $_SESSION["sess_smtpserver"]; $var_port = $_SESSION["sess_smtpport"]; SMTPMail($var_fromMail, $toemail_us, $var_smtpserver, $var_port, $var_subject, $var_body); } else { $mailstatus = @mail($toemail_us, $var_subject, $var_body, $Headers); } } //end of for loop user email } //end of if email count } }
<div class="inner_conainer" > <?php include "trainer_dashboard_link.php"; ?> <div class="dashboard_right fade_anim"> <div class="dashbox_wrap"> <div class="dashbox blue_bg"> <div class="title"><img src="images/icon_profile_big.png" />profile <div class="clear"></div> </div> <p><strong>Name :</strong> <?php echo getUserName($conn, $registration_id); ?> </p> <p><strong>Email :</strong> <?php echo getUserEmail($conn, $registration_id); ?> </p> <p><strong>Mobile :</strong> <?php echo getUserMobile($conn, $registration_id); ?> </p> <a class="more" href="trainer_profile.php"></a> </div> <div class="dashbox green_bg"> <div class="title"><img src="images/icon_tranings_big.png" />Trainings Courses <div class="clear"></div> </div> <div class="posted_job"> <?php while ($row = $result->fetch_assoc()) { ?>
function mailCoy($userid) { #send an email to incharge person $to = getUserEmail($userid); $namakaryawan = getNamaKaryawan($_SESSION['standard']['userid']); if ($_SESSION['language'] == 'EN') { $subject = "[Notifikasi] PR Submission for approval, submitted by: " . $namakaryawan; $body = "<html>\r\n <head>\r\n <body>\r\n <dd>Dear Sir/Madam,</dd><br>\r\n <br>\r\n Today, " . date('d-m-Y') . ", on behalf of " . $namakaryawan . " submit a PR, requesting for your approval. To follow up, please follow the link below.\r\n <br>\r\n <br>\r\n <br>\r\n Regards,<br>\r\n Owl-Plantation System.\r\n </body>\r\n </head>\r\n </html>\r\n "; } else { $subject = "[Notifikasi]Persetujuan PP a/n " . $namakaryawan; $body = "<html>\r\n <head>\r\n <body>\r\n <dd>Dengan Hormat,</dd><br>\r\n <br>\r\n Pada hari ini, tanggal " . date('d-m-Y') . " karyawan a/n " . $namakaryawan . " mengajukan Permintaan Pembelian Barang\r\n kepada bapak/ibu. Untuk menindak-lanjuti, silahkan ikuti link dibawah.\r\n <br>\r\n <br>\r\n <br>\r\n Regards,<br>\r\n Owl-Plantation System.\r\n </body>\r\n </head>\r\n </html>\r\n "; } $kirim = kirimEmail($to, '', $subject, $body); #this has return but disobeying; }
$tab .= "<tr><td colspan=3 align=center><button class=mybutton onclick=saveAjukan()>" . $_SESSION['lang']['diajukan'] . "</button></td></tr></table>"; $tab .= "</fieldset>"; echo $tab; break; case 'appSetuju': $sKary = "select distinct status1 from " . $dbname . ".pta_ht where notransaksi='" . $notransaksi . "'"; $qKary = mysql_query($sKary) or die(mysql_error($conn)); $rKary = mysql_fetch_assoc($qKary); if ($rKary['status1'] == 0) { $sUpdate = "update " . $dbname . ".pta_ht set persetujuan1='" . $krywnId . "' \r\n where status1='0' and notransaksi='" . $notransaksi . "'"; } // exit($sUpdate." Error"); if (!mysql_query($sUpdate)) { exit("DB:Error" . mysql_error($conn) . "__" . $sUpdate); } else { $to = getUserEmail($krywnId); $subject = "[Notifikasi] Persetujuan PTA "; $body = "<html>\r\n <head>\r\n <body>\r\n <dd>Dengan Hormat,</dd><br>\r\n <br>\r\n Pada hari ini karyawan A/n " . $_SESSION['empl']['name'] . " mengajukan persetujuan PTA \r\n No." . $notransaksi . " kepada bapak/ibu, untuk menindaklanjuti silahkan click link dibawah.\r\n <br>\r\n <br>\r\n <br>\r\n Regards,<br>\r\n Owl-Plantation System.\r\n </body>\r\n </head>\r\n </html>"; $kirim = kirimEmail($to, '', $subject, $body); #this has return but disobeying; } break; case 'getKegiatan': $optKeg = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>"; if ($_SESSION['language'] == 'EN') { $dd = 'namakegiatan1 as namakegiatan'; } else { $dd = 'namakegiatan as namakegiatan'; } $sKeg = "select distinct kodekegiatan," . $dd . " from " . $dbname . ".setup_kegiatan where noakun like '%" . $_POST['noakun'] . "%' order by kodekegiatan"; $qKeg = mysql_query($sKeg) or die(mysql_error($conn));
function modifyDomainPerm($domainId, $userId, $admin) { if (!$domainId || !$userId) { return FALSE; } if (!isDomainAdmin()) { return FALSE; } if ($userId == $_SESSION['user']['user_id']) { return FALSE; } if (!userIsActive($userId)) { return FALSE; } $user = getUserEmail($userId); if (!$user) { return FALSE; } $domain = getDomain($domainId); if (!$domain) { return FALSE; } $adminDomains = getAdminDomains(); if (!in_array($domain, $adminDomains)) { return FALSE; } $params = array('user_id' => $userId, 'domain_id' => $domainId); if ($admin) { return db_insert('domain_administrators', $params, 'admin_id'); } else { return db_delete('domain_administrators', $params); } }
$actionLogId = mysql_insert_id(); } //send mail to user if ($var_ntuser == "ntuser") { } if ($var_cc != "" or $var_ntuser == "ntuser") { //Get department details for the ticket id here $sql = "Select t.vRefNo,t.vTitle,d.vDeptMail,u.vLogin,u.vEmail, u.nUserId as userid from sptbl_tickets t inner join\n\t\t\t\t\t\t\t\t\t\tsptbl_depts d on t.nDeptId=d.nDeptId inner join sptbl_users u on t.nUserId=u.nUserId\n\t\t\t\t\t\t\t\t\t\t where t.nTicketId='" . mysql_real_escape_string($var_tid) . "'"; //End Get department details for the ticket id here //$sql="select vLogin,vEmail from sptbl_users where nUserId='$var_userid'"; $result = executeSelect($sql, $conn); $row = mysql_fetch_array($result); $var_email = $row['vEmail']; $var_ulogin = $row['vLogin']; $user_id = $row['userid']; $useremail = getUserEmail($user_id); if (!in_array($var_email, $useremail)) { $useremail[] = $var_email; } if (count($useremail) > 0) { foreach ($useremail as $key => $value) { $var_email = $value; //Send replay mail to user ****************** $var_mail_body = $var_emailheader . "<br>" . TEXT_MAIL_START . " " . htmlentities($var_ulogin) . ",<br>"; $var_mail_body .= TEXT_MAIL_BODY . ":" . $var_refno . "<br><br>"; $var_mail_body .= nl2br($var_replymatter) . "<br>" . $var_emailfooter; $var_subject = "Re:" . $row["vTitle"] . " Id#[" . $row["vRefNo"] . "]"; $var_body = $var_mail_body; //$Headers="From: " . $row["vDeptMail"] . "\n"; //$Headers .="Reply-To: " . $row["vDeptMail"] . "\n"; $arr_header = array("Reply-To: " . $row["vDeptMail"]);
$wktu = date("Y-m-d H:i:s"); $sUp .= ",persetujuan1='" . $atasan . "',waktupengajuan='" . $wktu . "'"; } $sUp .= " where " . $where . ""; if (mysql_query($sUp)) { if ($atsSblm != $atasan) { #send an email to incharge person $to = getUserEmail($atasan); $namakaryawan = getNamaKaryawan($_SESSION['standard']['userid']); $subject = "[Notifikasi]Persetujuan Ijin Keluar Kantor a/n " . $namakaryawan; $body = "<html>\r\n <head>\r\n <body>\r\n <dd>Dengan Hormat,</dd><br>\r\n <br>\r\n Pada hari ini, tanggal " . date('d-m-Y') . " karyawan a/n " . $namakaryawan . " mengajukan Ijin/" . $jnsIjin . " (" . $keperluan . ")\r\n kepada bapak/ibu. Untuk menindak-lanjuti, silahkan ikuti link dibawah.\r\n <br>\r\n <br>\r\n Note: Sisa cuti ybs periode " . $periodec . ":" . $sisa . " Hari\r\n <br>\r\n <br>\r\n Regards,<br>\r\n Owl-Plantation System.\r\n </body>\r\n </head>\r\n </html>\r\n "; $kirim = kirimEmail($to, '', $subject, $body); #this has return but disobeying; } } //mysql_query($sUp) or die(mysql_error()); } else { exit("Error:Sudah ada keputusan"); } if ($atsSblm != $atasan) { $to = getUserEmail($atsSblm); $namakaryawan = getNamaKaryawan($_SESSION['standard']['userid']); $subject = "[Notifikasi]Pembatalan Persetujuan Ijin Keluar Kantor a/n " . $namakaryawan; $body = "<html>\r\n <head>\r\n <body>\r\n <dd>Dengan Hormat,</dd><br>\r\n <br>\r\n Pada hari ini, tanggal " . date('d-m-Y') . " karyawan a/n " . $namakaryawan . " mengajukan Ijin/" . $jnsIjin . " (" . $keperluan . ")\r\n kepada bapak/ibu. Untuk menindak-lanjuti, silahkan ikuti link dibawah.\r\n <br>\r\n <br>\r\n Note: Sisa cuti ybs periode " . $periodec . ":" . $sisa . " Hari\r\n <br>\r\n <br>\r\n Regards,<br>\r\n Owl-Plantation System.\r\n </body>\r\n </head>\r\n </html>\r\n "; $kirim = kirimEmail($to, '', $subject, $body); #this has return but disobeying; } break; default: break; }
function sendInvitationMail($blogid, $userid, $name, $comment, $senderName, $senderEmail) { global $database, $service, $hostURL, $serviceURL; if (empty($blogid)) { $blogid = POD::queryCell("SELECT max(blogid)\n\t\t\tFROM {$database['prefix']}BlogSettings"); // If no blogid, get the latest created blogid. } $email = getUserEmail($userid); $password = POD::queryCell("SELECT password\n\t\tFROM {$database['prefix']}Users\n\t\tWHERE userid = " . $userid); $authtoken = getAuthToken($userid); $blogName = getBlogName($blogid); if (empty($email)) { return 1; } if (!preg_match('/^[^@]+@([-a-zA-Z0-9]+\\.)+[-a-zA-Z0-9]+$/', $email)) { return 2; } if (empty($name)) { $name = User::getName($userid); } if (strcmp($email, UTF8::lessenAsEncoding($email, 64)) != 0) { return 11; } //$loginid = POD::escapeString(UTF8::lessenAsEncoding($email, 64)); $name = POD::escapeString(UTF8::lessenAsEncoding($name, 32)); //$headers = 'From: ' . encodeMail($senderName) . '<' . $senderEmail . ">\n" . 'X-Mailer: ' . TEXTCUBE_NAME . "\n" . "MIME-Version: 1.0\nContent-Type: text/html; charset=utf-8\n"; if (empty($name)) { $subject = _textf('귀하를 %1님이 초대합니다', $senderName); } else { $subject = _textf('%1님을 %2님이 초대합니다', $name, $senderName); } $message = file_get_contents(ROOT . "/resources/style/letter/letter.html"); $message = str_replace('[##_title_##]', _text('초대장'), $message); $message = str_replace('[##_content_##]', $comment, $message); $message = str_replace('[##_images_##]', $serviceURL . "/resources/style/letter", $message); $message = str_replace('[##_link_##]', getInvitationLink(getBlogURL($blogName), $email, $password, $authtoken), $message); $message = str_replace('[##_go_blog_##]', getBlogURL($blogName), $message); $message = str_replace('[##_link_title_##]', _text('블로그 바로가기'), $message); if (empty($name)) { $message = str_replace('[##_to_##]', '', $message); } else { $message = str_replace('[##_to_##]', _text('받는 사람') . ': ' . $name, $message); } $message = str_replace('[##_sender_##]', _text('보내는 사람') . ': ' . $senderName, $message); $ret = sendEmail($senderName, $senderEmail, $name, $email, $subject, $message); if ($ret !== true) { return array(14, $ret[1]); } return true; }
/** * Performs the actual openid login once the authentication has been confirmed * from the Provider. * Basically deals with four cases: * 1. The user has used this OpenID before: * This means that this OpenID entry is there in the _openid_users table * and thus the user has previously used this OpenID before. * In such case, the authentication is done and the user logs in. * 2. When the OpenID provider didn't returned the user's email address: * We currently do not support such OpenID provider, and thus an * error message is recieved by the user. * 3. When OpenID provider returns an Email which is already there in our records: * This means that the user of this OpenID is already being registered also * as a normal Pragyan User (or other OpenID user). The main thing is that * the there is an entry for this particular EmailID in _users table. * When this happens, user is asked to give the password of the pre-existing * account at the PragyanCMS so that it can be linked to this OpenID * @todo Check what happen if the entry in _users is because of another OpenID entry * and not because of a Pragyan user. I suspect that the code will still ask * for the password (which it shouldn't). The code shouldn't check Pre-existing * email ID for those entries which have login_method as openid. * 4. When OpenID proovider returns an Email which is not there in our records: * In this case, the system demands the user to give their full name and thus * it registers themselves as a dummy openid user in _users (with login_method * = openid) and create entries in _openid_users too. After this, the user * can start using his account. * * @param $userdata user information returned by the OpenID provider. Can be fetched * by the ->filteruserinfo() function in DopeOpenID class */ function openid_login($userdata) { $userdata['openid_url'] = escape($_GET['openid_identity']); /// Build a query to check if the OpenID already exits in openid_users table $query = "SELECT * FROM `" . MYSQL_DATABASE_PREFIX . "openid_users` WHERE `openid_url` = '" . $userdata['openid_url'] . "';"; $result = mysql_query($query) or die(mysql_error() . " in openid_login() inside login.lib.php while executing query for openid_row"); $openid_row = mysql_fetch_array($result); if ($openid_row) { ///the record exists, this user has already used his OpenID before //print_r($row); ///Fetch the user_id that corresponds to user_id in the _users table $userid = $openid_row['user_id']; ///the OpenID provider did sent us the email of the user. Check if it exists in our database and is activated $userdetails = getUserInfo(getUserEmail($userid)); if (!$userdetails) { displayerror("Your openid registration is corrupted. Please contact site administrator."); return; } /// ASSUMPTION : the `user_activated' column in _users table is 1 if and only if his email is verified. if ($userdetails && $userdetails['user_activated'] == 0) { displayerror("Your account is not activated. Please verify your account using the email sent to you during registration or contact site administrator."); return; } ///Assign the value to $_SESSION['last_to_last_login_datetime'] $query = "SELECT `user_lastlogin` FROM `" . MYSQL_DATABASE_PREFIX . "users` WHERE `user_id`='" . $openid_row['user_id'] . "';"; $result = mysql_query($query) or die(mysql_error() . " in openid_login() inside login.lib.php while trying to fetch last login"); $last_login_row = mysql_fetch_array($result); $_SESSION['last_to_last_login_datetime'] = $last_login_row['user_lastlogin']; ///update the last login $query = "UPDATE `" . MYSQL_DATABASE_PREFIX . "users` SET `user_lastlogin`=NOW() WHERE `" . MYSQL_DATABASE_PREFIX . "users`.`user_id` ='" . $openid_row['user_id'] . "';"; mysql_query($query) or die(mysql_error() . " in openid_login() inside login.lib.php while trying to update the last login"); ///logging in the user setAuth($openid_row['user_id']); return $openid_row['user_id']; } else { /**This user is first time using the OpenID * display a small form to input User's Details * System should now check if the email ID is provided by the openID provider is already there in Our records. * If yes, the current account should be linked up to the account in the database after accepting the password. * Else, User should provide few details about him/her like Full name, and Email. Now after he provides the email, * The System again has to check if the email is under records and if it is, ask the password from user to link * it else, just make a new user in table _users */ //Save the OpenID url first in Session $_SESSION['openid_url'] = $userdata['openid_url']; $_SESSION['openid_email'] = $userdata['email']; if (array_key_exists('email', $userdata)) { ///the OpenID provider did sent us the email of the user. Check if it exists in our database and is activated $userdetails = getUserInfo($userdata['email']); $userid = $userdetails['user_id']; /// ASSUMPTION : the `user_activated' column in _users table is 1 if and only if his email is verified. if ($userdetails && $userdetails['user_activated'] == 0) { displayerror("Your account is not activated. Please verify your account using the email sent to you during registration or contact site administrator."); return; } if ($userdetails && $userdetails['user_activated'] && $userdetails['user_loginmethod'] != 'openid') { ///if the Email was found in the records ///Display a Form to capture the Password and connect it $username = getUserName($userid); displayinfo("<ul><li>An account with your Email was found in our record already. This mean you are already registered as a user.</li>" . "<li>You just need to provide your password of your existing account to link your OpenID with.</li>" . "<li> This is a one time step after which you can use your OpenID account to Login.</li></ul>"); $cmstitle = CMS_TITLE; $openid_pass_form = <<<OPENIDPASS \t\t \t<form method="POST" class="registrationform" name="openid_pass" action="./home/+login&subaction=openid_pass"> \t\t<fieldset> \t\t <legend>Password for the existing account </legend> \t\t\t\t\t Please Enter the Password of the pre-existing account on {$cmstitle} \t\t<input type="hidden" name="email" value="{$userdata['email']}" />\t\t\t\t\t\t\t\t\t\t\t\t\t\t <table> <tr><td>Username</td> <td>{$username}</td></tr> <tr><td>Email</td> <td>{$userdata['email']}</td></tr> <tr><td><label for="user_password" class="labelrequired">Password</label></td> \t\t\t\t <td><input type="password" name="user_password" id="user_password" class="required" /><br /></td> \t\t\t\t </tr> \t\t\t\t <tr> \t\t\t\t <td><input type="submit" value="Submit" /></td> \t\t\t\t </tr> </table> </fieldset> </form> OPENIDPASS; return $openid_pass_form; } else { /** * User have not used this OpenID before. The EmailID returned wasn't found in our records. Hence * now we will have to get the full name of the user and then create a dummy user in _users table * with the login_method as `openid'. Then we also have to make entries in the _openid_users table * and add the user there appropriately. */ displayinfo("Seems like you are using this OpenID for the first time. We just need your full name to continue."); $openid_detail_form = <<<OPENIDFORM \t<form method="POST" class="registrationform" name="quick_openid_reg" action="./home/+login&subaction=quick_openid_reg"> \t<fieldset> \t<legend>Just give us your Full name</legend> \t<table> \t<tr> \t<td><label for="user_email" class="labelrequired">Email</label></td> <td><input type="text" name="user_email" value="{$userdata['email']}" id="user_email" class="required" readonly="true" onchange="if(this.length!=0) return checkEmail(this);"/><br /></td> </tr> \t<tr> \t<td><label for="user_name">Full Name</label></td> <td><input type="text" name="user_name" value="{$userdata['fullname']}" id="user_name" class="required"/><br /></td> </tr> <tr> <td><input type="submit" value="Submit" /></td> </tr> </table> </fieldset> </form> OPENIDFORM; return $openid_detail_form; } } else { /** The OpenID provider didn't sent us the Email. Tell the user that he can't authenticate using such providers */ displayerror("The OpenID provider didn't return your Email Address. Please configure your Provider to provide your Email address"); return; } } }
<?php session_start(); include_once "events.php"; include_once "users.php"; include_once "templates/nav.php"; $logged = isset($_SESSION['username']); $id = isset($_GET['id']) ? $_GET['id'] : ""; $event = getEvent($id); $registered = getRegistered($id); $from_email = getUserEmail($_SESSION['username'])[0]; $comments = getComments($id); $url = 'http' . (empty($_SERVER['HTTPS']) ? '' : 's') . '://' . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI']; include_once "templates/show_event.php"; ?> <!-- Comment form and Share form--> <?php if ($logged && (isRegisteredInEvent($id, $_SESSION['username']) || $_SESSION['username'] == $event['creator'])) { ?> <form action="action_comment.php" method="post"> <input type="hidden" name="id" value="<?php echo $id; ?> "> <input type="hidden" name="event" value="<?php echo $id; ?> "> <input type="hidden" name="author" value="<?php echo $_SESSION['username'];
$notrx = substr($bar->notransaksi, 10, 5); } $notrx = intval($notrx); $notrx = $notrx + 1; $notrx = str_pad($notrx, 5, "0", STR_PAD_LEFT); $notrx = $potSK . $notrx; $str = "insert into " . $dbname . ".sdm_pjdinasht (\r\n\t\t `notransaksi`,`karyawanid`,`tanggalbuat`,\r\n\t\t `tanggalperjalanan`,`kodeorg`,`tujuan1`,\r\n\t\t `tugas1`,`tujuan2`,`tugas2`,`tujuan3`,\r\n\t\t `tugas3`,`tugaslain`,`tujuanlain`,\r\n\t\t `pesawat`,`darat`,`laut`,\r\n\t\t `mess`,`hotel`,`tanggalkembali`,`uangmuka`,\r\n\t\t `hrd`,`persetujuan`,`statuspersetujuan`\r\n\t\t ) values(\r\n\t\t\t\t'" . $notrx . "'," . $karyawanid . "," . date('Ymd') . ",\r\n\t\t\t\t" . $tanggalperjalanan . ",'" . $kodeorg . "','" . $tujuan1 . "',\r\n\t\t\t\t'" . $tugas1 . "','" . $tujuan2 . "','" . $tugas2 . "','" . $tujuan3 . "',\r\n\t\t\t\t'" . $tugas3 . "','" . $tugaslain . "','" . $tujuanlain . "',\r\n\t\t\t\t" . $pesawat . "," . $darat . "," . $laut . ",\r\n\t\t\t\t" . $mess . "," . $hotel . "," . $tanggalkembali . "," . $uangmuka . ",\r\n\t\t\t\t" . $hrd . "," . $persetujuan . ",'1' \r\n\t\t )"; //echo $str; } else { if ($method == 'delete') { $notransaksi = $_POST['notransaksi']; $str = "delete from " . $dbname . ".sdm_pjdinasht\r\n\t where karyawanid=" . $karyawanid . " and notransaksi='" . $notransaksi . "'"; } else { if ($method == 'update') { $notransaksi = $_POST['notransaksi']; $str = "update " . $dbname . ".sdm_pjdinasht set\r\n\t\t `tanggalperjalanan`=" . $tanggalperjalanan . ",\r\n\t\t `kodeorg`='" . $kodeorg . "',\r\n\t\t `tujuan1`='" . $tujuan1 . "',\r\n\t\t `tugas1`='" . $tugas1 . "',\r\n\t\t `tujuan2`='" . $tujuan2 . "',\r\n\t\t `tugas2`='" . $tugas2 . "',\r\n\t\t `tujuan3`='" . $tujuan3 . "',\r\n\t\t `tugas3`='" . $tugas3 . "',\r\n\t\t `tugaslain`='" . $tugaslain . "',\r\n\t\t `tujuanlain`='" . $tujuanlain . "',\r\n\t\t `pesawat`=" . $pesawat . ",\r\n\t\t `darat`=" . $darat . ",\r\n\t\t `laut`=" . $laut . ",\r\n\t\t `mess`=" . $mess . ",\r\n\t\t `hotel`=" . $hotel . ",\r\n\t\t `tanggalkembali`=" . $tanggalkembali . ",\r\n\t\t `uangmuka`=" . $uangmuka . ",\r\n\t\t `hrd`=" . $hrd . ",\r\n\t\t `persetujuan`=" . $persetujuan . "\r\n\t\twhere karyawanid=" . $karyawanid . " and notransaksi='" . $notransaksi . "'"; } } } if (mysql_query($str)) { if ($method == 'update' or $method == 'insert') { $to = getUserEmail($hrd); $namakaryawan = getNamaKaryawan($_SESSION['standard']['userid']); $subject = "[Notifikasi]Persetujuan Perjalanan Dinas a/n " . $namakaryawan; $body = "<html>\r\n <head>\r\n <body>\r\n <dd>Dengan Hormat,</dd><br>\r\n <br>\r\n Pada hari ini, tanggal " . date('d-m-Y') . " karyawan a/n " . $namakaryawan . " mengajukan surat perjalanan dinas\r\n kepada bapak/ibu. Untuk menindak-lanjuti, silahkan ikuti link dibawah.\r\n <br>\r\n <br>\r\n <br>\r\n Regards,<br>\r\n Owl-Plantation System.\r\n </body>\r\n </head>\r\n </html>\r\n "; $kirim = kirimEmail($to, '', $subject, $body); #this has return but disobeying; } } else { echo " Gagal:" . addslashes(mysql_error($conn)); }
<?php try { require $_SERVER['DOCUMENT_ROOT'] . '/model/connect.php'; require $_SERVER['DOCUMENT_ROOT'] . '/controller/functions.php'; } catch (EXCEPTION $ex) { echo 'error files not found'; } if (isset($_POST['submit'])) { //grab all of the Users data thats been input in the login form, and put it in a variable $userName = $_POST['userName']; $password = $_POST['password']; //Grab Email $login = login($userName, $password); $email = getUserEmail($userName, $password); //compare permissions if ($login == true) { //yay //Put User's Email in the url and Redirect them to the Users login home page. $user = comparePermission($userName); $permission = $user['permission']; //if admin if ($permission == 'admin') { Header('Location: /view/admin/index.php?action=home'); } else { //if user Header("Location: /view/client.php?email=" . $email); } } else { if ($login == false) { //nay
//exit("Error:".$tglAkhir."___".$jmAkhir); list($h, $m, $s) = explode(":", $jmAkhir); list($thn, $mth, $dy) = explode("-", $tglAkhir); $dtAkhir = mktime($h, $m, $s, intval($mth), $dy, $thn); $dtSelisih = $dtAkhir - $dtAwal; //exit("Error:".$dtSelisih."___".$dtAkhir."___".$dtAwal."___".$mth."__".$dy."__".$thn); $totalmenit = $dtSelisih / 60; $jam = explode(".", $totalmenit / 60); $sisamenit = $totalmenit / 60 - $jam[0]; $sisamenit2 = $sisamenit * 60; $jml_jam = $jam[0]; //end ambil selisih waktu $sUpdate = "update " . $dbname . ".it_request set jumlah='" . $jml_jam . "',waktuselesai='" . $tlgjmskrng . "',saranpelaksana='" . $saran . "'\r\n where notransaksi='" . $notransaksi . "'"; if (mysql_query($sUpdate)) { #send an email to incharge person $to = getUserEmail($rGet['karyawanid']); $namakaryawan = getNamaKaryawan($rGet['karyawanid']); $subject = "[Notifikasi]Permintaan layanan " . $rGet['keterangan'] . " a/n " . $namakaryawan; $body = "<html>\r\n <head>\r\n <body>\r\n <dd>Dengan Hormat,</dd><br>\r\n <p align=justify>\r\n Permintaan layanan " . $rGet['keterangan'] . " pada tanggal " . tanggalnormal($rGet['tanggal']) . " oleh saudara ke departemen IT\r\n dengan deskripsi " . $rGet['deskripsi'] . ".\r\n <br>\r\n <br>\r\n Telah selesai dilaksanakan pada tanggal " . tanggalnormald($tlgjmskrng) . ", mohon kesediaan saudara untuk memberi penilaian terhadap layanan kami dari menuIT->Permintaan Layanan\r\n <br>\r\n <br>\r\n Regards,<br>\r\n Owl-Plantation System.\r\n </body>\r\n </head>\r\n </html>\r\n "; $kirim = kirimEmail($to, '', $subject, $body); #this has return but disobeying; } break; case 'getDetail': $sData = "select distinct * from " . $dbname . ".it_request where notransaksi='" . $notransaksi . "' "; $qData = mysql_query($sData) or die(mysql_error($conn)); $rData = mysql_fetch_assoc($qData); $dataTab .= "<div style=overflow:auto;width:420px;height:880px;>"; $dataTab .= "<fieldset><legend>" . $_SESSION['lang']['desc'] . "</legend>"; $dataTab .= "<div align=justify>" . $rData['deskripsi'] . "</p>"; $dataTab .= "</fieldset><br />";
} if ($_REQUEST['assigntype'] == 'U') { $focus->column_fields['assigned_user_id'] = $_REQUEST['assigned_user_id']; } elseif ($_REQUEST['assigntype'] == 'T') { $focus->column_fields['assigned_user_id'] = $_REQUEST['assigned_group_id']; } $focus->save($currentModule); $return_id = $focus->id; $search = vtlib_purify($_REQUEST['search_url']); if ($_REQUEST['return_id'] != '') { $return_id = vtlib_purify($_REQUEST['return_id']); } //Checking and Sending Mail from reorder level global $current_user; $productname = $focus->column_fields['productname']; $qty_stk = $focus->column_fields['qtyinstock']; $reord = $focus->column_fields['reorderlevel']; $handler = $focus->column_fields['assigned_user_id']; if ($qty_stk != '' && $reord != '') { if ($qty_stk < $reord) { $handler_name = getUserName($handler); $sender_name = getUserName($current_user->id); $to_address = getUserEmail($handler); $subject = $productname . ' ' . $mod_strings['MSG_STOCK_LEVEL']; $body = $mod_strings['MSG_DEAR'] . ' ' . $handler_name . ',<br><br>' . $mod_strings['MSG_CURRENT_STOCK'] . ' ' . $productname . ' ' . $mod_strings['MSG_IN_OUR_WAREHOUSE'] . ' ' . $qty_stk . '. ' . $mod_strings['MSG_PROCURE_REQUIRED_NUMBER'] . ' ' . $reord . '.<br> ' . $mod_strings['MSG_SEVERITY'] . '<br><br> ' . $mod_strings['MSG_THANKS'] . '<br> ' . $sender_name; include "modules/Emails/mail.php"; $mail_status = send_mail("Products", $to_address, $current_user->user_name, $current_user->email1, $subject, $body); } } $parenttab = getParentTab(); header("Location: index.php?action={$return_action}&module={$return_module}&record={$return_id}&parenttab={$parenttab}&start=" . vtlib_purify($_REQUEST['pagenumber']) . $search);
$result = executeSelect($sql, $conn); if (mysql_num_rows($result) > 0) { $row = mysql_fetch_array($result); $var_body = $var_emailheader . "<br>" . TEXT_MAIL_START . ",<br> <br>"; $var_body .= TEXT_TICKET_CREATION_BODY1 . " ( " . htmlentities($title) . " ) "; $var_body .= TEXT_TICKET_CREATION_BODY2 . date("m-d-Y H:i"); $var_body .= TEXT_TICKET_CREATION_BODY3 . " [" . $var_refno . "].<br><br>"; $var_body .= "<a href=\"" . $var_loginurl . "?mt=y&email=" . urlencode($var_email) . "&ref=" . $var_refno . "&\">" . TEXT_CLICK_HERE . "</a> " . TEXT_VIEW_TICKET_STATUS . "<BR><BR>"; $var_body .= TEXT_MAIL_THANK . "<br>" . htmlentities($var_helpdesktitle) . "<br>" . $var_emailfooter; $var_subject = TEXT_TICKET_CREATION_SUBJECT . $var_helpdesktitle . " Id#[" . $var_refno . "]"; $Headers = "From: " . $row["vDeptMail"] . "\n"; $Headers .= "Reply-To: " . $row["vDeptMail"] . "\n"; $Headers .= "MIME-Version: 1.0\n"; $Headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; //*************Send mail user on ticket $useremail = getUserEmail($var_userid); if (!in_array($var_email, $useremail)) { $useremail[] = $var_email; } if (count($useremail) > 0) { foreach ($useremail as $key => $value) { $var_email = $value; // it is for smtp mail sending if ($_SESSION["sess_smtpsettings"] == 1) { $var_smtpserver = $_SESSION["sess_smtpserver"]; $var_port = $_SESSION["sess_smtpport"]; SMTPMail($var_fromMail, $var_email, $var_smtpserver, $var_port, $var_subject, $var_body); } else { $mailstatus = @mail($var_email, $var_subject, $var_body, $Headers); } //*************Send mail user on ticket ends
<?php require_once 'master_validation.php'; require_once 'config/connection.php'; require_once 'lib/nangkoelib.php'; require_once 'lib/admin_validation.php'; $uname = $_POST['uname']; $sendmail = $_POST['sendmail']; $pw = $_POST['pw']; $userid = $_POST['userid']; $active = $_POST['active']; //Has the password if ($sendmail == 1) { $email = getUserEmail($uname, $userid, $conn); } else { $email = ''; } if ($active == 1) { $ac_comment = 'Active'; } else { $ac_comment = 'Inactive'; } $str = "insert into " . $dbname . ".user (namauser,password,karyawanid,lastuser,status)\r\n\t values('" . $uname . "',MD5('" . $pw . "')," . $userid . ",'" . $_SESSION['standard']['username'] . "'," . $active . ")"; if (mysql_query($str)) { echo "*Account " . $uname . " has been created.<br>"; //if email is available then send an email to user if ($email != '') { $subject = 'Your User Account has been created'; $content = "Dear " . $uname . ",<br><br>\r\n\t\t\t <dd>Your Account has been created as follow:\r\n\t\t\t\t\t <table>\r\n\t\t\t\t\t <tr><td><i>UserName</i></td><td>:" . $uname . "</td></tr>\r\n\t\t\t\t\t <tr><td><i>Password</i></td><td>:" . $pw . "</td></tr>\r\n\t\t\t\t\t <tr><td><i>UserId(Empl.ID)</i></td><td>:" . $userid . "</td></tr>\r\n\t\t\t\t\t <tr><td><i>AccountStatus</i></td><td>:" . $ac_comment . "</td></tr>\r\n\t\t\t\t\t </table><br>\r\n\t\t\t\t\t Please maintain your password periodically.\r\n\t\t\t\t\t <br>\r\n\t\t\t\t\t Regards,\r\n\t\t\t\t\t System, at " . date('d-m-YYY H:i:s'); $from = 'administrator@' . $_SERVER['HOST'] . '.local'; $to = $email;
/** * Returns a form which displays the list of files uploaded in that page and if the user has sufficient permissions option to delete files. * @param $moduleComponentId page_modulecomponentid. * @param $moduleName The module which is calling this function. * @param $deleteFormAction The page or action that must be taken on clicking the delete option in the final form, * @return A variable that has the required form. * */ function getUploadedFilePreviewDeleteForm($moduleComponentId, $moduleName, $deleteFormAction = './+edit') { global $uploadedFormNumber; if (!isset($uploadedFormNumber)) { $uploadedFormNumber = 1; } $uploadedFormNumber += 1; if (isset($_POST['file_deleted']) && $_POST['file_deleted'] == "form_{$uploadedFormNumber}") { if (isset($_GET['deletefile'])) { if (deleteFile($moduleComponentId, $moduleName, escape($_GET['deletefile']))) { displayinfo("The file " . escape($_GET['deletefile']) . " has been removed"); } else { displayinfo("Unable to remove the file."); } } } $uploadedFiles = getUploadedFiles($moduleComponentId, $moduleName); $uploadedFilesString = ""; foreach ($uploadedFiles as $file) { $uploadedUserEmail = getUserEmail($file['user_id']); $uploadedUserName = getUserFullName($file['user_id']); $fileDelete = addslashes($file['upload_filename']); $uploadedFilesString .= <<<UPLOADEDFILESSTRING \t\t<tr> \t\t\t<td><a href="./{$file['upload_filename']}" onMouseOver="javascript:showPath('{$fileDelete}')" target="previewIframe_{$uploadedFormNumber}">{$file['upload_filename']}</a></td> \t\t\t<td>{$uploadedUserName}</td> \t\t\t<td>{$uploadedUserEmail}</td> \t\t\t<td>{$file['upload_time']}</td> \t\t\t<td><input type='submit' value='Delete' onclick="return checkDeleteUpload(this, '{$fileDelete}');"></td> \t\t</tr> UPLOADEDFILESSTRING; } global $urlRequestRoot; global $cmsFolder; global $STARTSCRIPTS; if (count($uploadedFiles) > 0) { $smarttablestuff = smarttable::render(array('filestable'), null); $STARTSCRIPTS .= "initSmartTable();"; $uploadedFilesString = <<<UPLOADEDFILESSTRING \t<form action="{$deleteFormAction}" method="POST" name="deleteFile"> \t\t<script language="javascript"> \t \tfunction showPath(fileName) { \t \t\tpath = document.location.pathname; \t\t\t\tpath = path.split('+'); \t\t\t\tpath = path[0].split('&'); \t\t\t\tdocument.getElementById("preview_uploadedfile_{$uploadedFormNumber}").setAttribute('value',path[0]+fileName); \t\t\t} \t\t\tfunction checkDeleteUpload(butt,fileDel) { \t\t\t\tif(confirm('Are you sure you want to delete '+fileDel+'?')) { \t\t\t\t\tbutt.form.action+='&deletefile='+fileDel; \t\t\t\t\tbutt.form.submit(); \t\t\t\t} \t\t\t\telse \t\t\t\t\treturn false; \t\t\t} \t\t\t \t </script> \t\t{$smarttablestuff} \t\t<table border="1" width="100%"> \t\t\t\t<tr> \t\t\t\t\t \t\t\t\t\t<td height="100" width="100%" style="overflow:scroll"> \t\t\t\t\t<center>Preview (only for images)</center> \t\t\t\t\t<iframe name="previewIframe_{$uploadedFormNumber}" width="100%" style="min-height:200px" ></iframe> \t\t\t\t\t</td> \t\t\t\t\t \t\t\t\t</tr> \t\t\t<tr> \t\t\t\t<td> \t\t\t\t\t<b>Click</b> for preview \t\t\t\t</td> \t\t\t\t \t\t\t</tr> \t\t\t<tr> \t\t\t\t<td> \t\t\t\t\t<table class="display" id="filestable" border="1" width="100%"> \t\t\t\t\t\t<thead> \t\t\t\t\t\t<tr> \t\t\t\t\t\t\t<th>File</th> \t\t\t\t\t\t\t<th>Uploaded By</th> \t\t\t\t\t\t\t<th>Email Id</th> \t\t\t\t\t\t\t<th>Upload Time</th> \t\t\t\t\t\t\t<th>Delete</th> \t\t\t\t\t\t</tr> \t\t\t\t\t\t</thead> \t\t\t\t\t\t<tbody> \t\t\t\t\t\t{$uploadedFilesString} \t\t\t\t\t\t</tbody> \t\t\t\t\t</table> \t\t\t\t</td> \t\t\t\t \t\t\t</tr> \t\t\t<tr> \t\t\t\t<td align="right">Path for file (move mouse over name): \t\t\t\t \t\t\t\t\t<input type="text" style="width:97%" readonly="readonly" id="preview_uploadedfile_{$uploadedFormNumber}" value="Copy the path from here" /> \t\t\t\t</td> \t\t\t</tr> \t\t\t</table> \t\t\t\t<input type="hidden" name="file_deleted" value="form_{$uploadedFormNumber}"> \t\t\t</form> UPLOADEDFILESSTRING; } else { $uploadedFilesString = "No files associated with this page."; } return $uploadedFilesString; }
exit; } ///Parse the URL and retrieve the PageID of the request page if its valid $pageId = parseUrlReal($pageFullPath, $pageIdArray); ///Means that the requested URL is not valid. if ($pageId === false) { define("TEMPLATE", getPageTemplate(0)); $pageId = parseUrlReal("home", $pageIdArray); $TITLE = CMS_TITLE; $MENUBAR = ''; $CONTENT = "The requested URL was not found on this server.<br />{$_SERVER['SERVER_SIGNATURE']}" . "<br /><br />Click <a href='" . $urlRequestRoot . "'>here </a> to return to the home page"; templateReplace($TITLE, $MENUBAR, $ACTIONBARMODULE, $ACTIONBARPAGE, $BREADCRUMB, $SEARCHBAR, $PAGEKEYWORDS, $INHERITEDINFO, $CONTENT, $FOOTER, $DEBUGINFO, $ERRORSTRING, $WARNINGSTRING, $INFOSTRING, $STARTSCRIPTS, $LOGINFORM); exit; } ///If it reaches here, means the page requested is valid. Log the information for future use. logInfo(getUserEmail($userId), $userId, $pageId, $pageFullPath, getPageModule($pageId), $action, $_SERVER['REMOTE_ADDR']); ///The URL points to a file. Download permissions for the file are handled inside the download() function in download.lib.php if (isset($_GET['fileget'])) { require_once $sourceFolder . "/download.lib.php"; $action = ""; if (isset($_GET['action'])) { $action = $_GET['action']; } download($pageId, $userId, $_GET['fileget'], $action); exit; } ///Check whether the user has the permission to use that action on the requested page. $permission = getPermissions($userId, $pageId, $action); ///Gets the page-specific template for that requested page define("TEMPLATE", getPageTemplate($pageId)); ///Gets the page title of the requested page
<?php } ?> </select> </div> <div class="textfield"> To <select name="job_to" id="job_to"> <option value="">--- To ---</option> <?php $transfer_result = $conn->query("SELECT * FROM `job_registration` WHERE `refer_registration_id`='{$registration_id}'"); while ($transfer_row = $transfer_result->fetch_assoc()) { ?> <option value="<?php echo $transfer_row['id']; ?> " ><?php echo getUserName($conn, $transfer_row['id']) . " (" . getUserEmail($conn, $city_row['registration_id']) . ")"; ?> </option> <?php } ?> </select> </div> <div class="textfield fade"> <input type="submit" name="seveRecruiter" id="seveRecruiter" value="Submit"/> </div> <div class="clear"></div> </div> </form> </div>
function iCalendar_event_attendee($activity) { $adb = PearDatabase::getInstance(); $users_res = $adb->pquery("SELECT inviteeid FROM vtiger_invitees WHERE activityid=?", array($activity['id'])); if ($adb->num_rows($users_res) > 0) { for ($i = 0; $i < $adb->num_rows($users_res); $i++) { $inviteeid = $adb->query_result($users_res, $i, 'inviteeid'); $username = getUserFullName($inviteeid); $user_email = getUserEmail($inviteeid); $attendee = 'mailto:' . $user_email; $this->add_property('ATTENDEE', $attendee); } } return true; }
<?php if (!isSignin()) { ?> <a href="sign_in_form.php"> <span class="glyphicon glyphicon-log-in" aria-hidden="true"></span> <?php echo $s_sign_in; ?> </a> <?php } else { ?> <a href="control_sign_out.php"> <span class="glyphicon glyphicon-user" aria-hidden="true"></span> <?php echo getUserEmail(); ?> | <span class="glyphicon glyphicon-log-out" aria-hidden="true"></span> <?php echo $s_sign_out; ?> </a> <?php } ?> </li> </ul> </div>
public function sendEmail() { require_once 'vtlib/Vtiger/Mailer.php'; $vtigerMailer = new Vtiger_Mailer(); $recipientEmails = $this->getRecipientEmails(); Vtiger_Utils::ModuleLog('ScheduleReprots', $recipientEmails); foreach ($recipientEmails as $name => $email) { $vtigerMailer->AddAddress($email, $name); } vimport('~modules/Report/models/Record.php'); $reportRecordModel = Reports_Record_Model::getInstanceById($this->get('reportid')); $currentTime = date('Y-m-d.H.i.s'); Vtiger_Utils::ModuleLog('ScheduleReprots Send Mail Start ::', $currentTime); $reportname = decode_html($reportRecordModel->getName()); $subject = $reportname; Vtiger_Utils::ModuleLog('ScheduleReprot Name ::', $reportname); $vtigerMailer->Subject = $subject; $vtigerMailer->Body = $this->getEmailContent($reportRecordModel); $vtigerMailer->IsHTML(); $baseFileName = $reportname . '__' . $currentTime; $oReportRun = ReportRun::getInstance($this->get('reportid')); $reportFormat = $this->scheduledFormat; $attachments = array(); if ($reportFormat == 'CSV') { $fileName = $baseFileName . '.csv'; $filePath = 'storage/' . $fileName; $attachments[$fileName] = $filePath; $oReportRun->writeReportToCSVFile($filePath); } foreach ($attachments as $attachmentName => $path) { $vtigerMailer->AddAttachment($path, decode_html($attachmentName)); } //Added cc to account owner $accountOwnerId = Users::getActiveAdminId(); $vtigerMailer->AddCC(getUserEmail($accountOwnerId), getUserFullName($accountOwnerId)); $status = $vtigerMailer->Send(true); foreach ($attachments as $attachmentName => $path) { unlink($path); } return $status; }
<?php session_start(); ob_start(); include 'db.inc.php'; include 'functions.php'; $registration_id = $_SESSION['registration_id']; $user = getUserName($conn, $registration_id); $user_mail = getUserEmail($conn, $registration_id); $id = $_REQUEST['id']; $result = $conn->query("select company_name from job_profile where registration_id='{$registration_id}'"); $row = $result->fetch_assoc(); $company_name = $row['company_name']; $result = $conn->query("select contact_name,email_id from admin_master where id='{$id}'"); $row = $result->fetch_assoc(); $admin_name = $row['contact_name']; $email = $row['email_id']; ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <script src="js/1.8.3_min.js" type="text/javascript"></script> <script type="text/javascript"> $(document).ready(function(){ $("#savecontact").on('click',function(e){ e.preventDefault(); formData=$('#sendmail').serialize(); var errors = jQuery('.recruiterError'); $.ajax({