$contactname = $adb->query_result($result, 0, 'firstname') . ' ' . $adb->query_result($result, 0, 'lastname');
$parentname = $contactname;
$contact_mailid = $adb->query_result($result, 0, 'email');
}
if ($parent_module == 'Accounts') {
$result = $adb->pquery("select * from vtiger_account where accountid=?", array($parent_id));
$emailoptout = $adb->query_result($result, 0, 'emailoptout');
$parentname = $adb->query_result($result, 0, 'accountname');
}
if ($contact_mailid != '') {
$sql = "select * from vtiger_portalinfo where user_name=?";
$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);
$contact_mailid = $adb->query_result($result, 0, 'email');
}
if ($parent_module == 'Accounts') {
$result = $adb->pquery("select * from vtiger_account where accountid=?", array($focus->column_fields['parent_id']));
$emailoptout = $adb->query_result($result, 0, 'emailoptout');
$parentname = $adb->query_result($result, 0, 'accountname');
}
}
//Get the status of the vtiger_portal user. if the customer is active then send the vtiger_portal link in the mail
if ($contact_mailid != '') {
$sql = "select * from vtiger_portalinfo where user_name=?";
$isactive = $adb->query_result($adb->pquery($sql, array($contact_mailid)), 0, 'isactive');
}
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 != '') {
