$isactive = $adb->query_result($adb->pquery($sql, array($contact_mailid)), 0, 'isactive'); } if ($isactive == 1) { $url = "<a href='" . $PORTAL_URL . "/index.php?module=Tickets&action=index&ticketid=" . $modObj->id . "&fun=detail'>Ticket Details</a>"; $email_body = $subject . '<br><br>' . getPortalInfo_Ticket($modObj->id, $sub, $contactname, $url, "edit"); } else { $data['sub'] = $modObj->column_fields['ticket_title']; $data['parent_name'] = $parentname; $data['status'] = $modObj->column_fields['ticketstatus']; $data['category'] = $modObj->column_fields['ticketcategories']; $data['severity'] = $modObj->column_fields['ticketseverities']; $data['priority'] = $modObj->column_fields['ticketpriorities']; $data['description'] = $modObj->column_fields['description']; $data['solution'] = $modObj->column_fields['solution']; $data['mode'] = 'edit'; $email_body = getTicketDetails($modObj->id, $data); } } if ($user_emailid != '') { $mail_status = send_mail('HelpDesk', $user_emailid, $HELPDESK_SUPPORT_NAME, $HELPDESK_SUPPORT_EMAIL_ID, $subject, $email_body); } if ($emailoptout == 0) { //send mail to parent if (!empty($parent_id)) { $parent_email = getParentMailId($parent_module, $parent_id); $mail_status = send_mail('HelpDesk', $parent_email, $HELPDESK_SUPPORT_NAME, $HELPDESK_SUPPORT_EMAIL_ID, $subject, $email_body); } } } //update the log information for ticket history $adb->pquery("update vtiger_troubletickets set update_log=? where ticketid=?", array($fldvalue, $modObj->id));
} if ($isactive == 1) { $url = "<a href='" . $PORTAL_URL . "/index.php?module=HelpDesk&action=index&ticketid=" . $focus->id . "&fun=detail'>" . $mod_strings['LBL_TICKET_DETAILS'] . "</a>"; $email_body = $bodysubject . '<br><br>' . getPortalInfo_Ticket($focus->id, $_REQUEST['ticket_title'], $contactname, $url, $_REQUEST['mode']); } else { $data['sub'] = $_REQUEST['ticket_title']; $data['ticketno'] = $focus->column_fields['ticket_no']; $data['parent_name'] = $parentname; $data['status'] = $focus->column_fields['ticketstatus']; $data['category'] = $focus->column_fields['ticketcategories']; $data['severity'] = $focus->column_fields['ticketseverities']; $data['priority'] = $focus->column_fields['ticketpriorities']; $data['description'] = $focus->column_fields['description']; $data['solution'] = $focus->column_fields['solution']; $data['mode'] = $_REQUEST['mode']; $email_body = getTicketDetails($focus->id, $data); } $_REQUEST['return_id'] = $return_id; if ($_REQUEST['return_module'] == 'Products' & $_REQUEST['product_id'] != '' && $focus->id != '') { $return_id = vtlib_purify($_REQUEST['product_id']); } //send mail to the assigned to user and the parent to whom this ticket is assigned //only if NOTIFY_OWNER_EMAILS is true if (PerformancePrefs::getBoolean('NOTIFY_OWNER_EMAILS', true) === true) { //send mail to the assigned to user and the parent to whom this ticket is assigned require_once 'modules/Emails/mail.php'; $user_emailid = getUserEmailId('id', $focus->column_fields['assigned_user_id']); if ($user_emailid != '') { if ($_REQUEST['mode'] != 'edit') { $mail_status = send_mail('HelpDesk', $user_emailid, $HELPDESK_SUPPORT_NAME, $HELPDESK_SUPPORT_EMAIL_ID, $subject, $email_body); } else {