You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
152 lines
5.8 KiB
152 lines
5.8 KiB
<?php
|
|
/*********************************************************************************
|
|
* The contents of this file are subject to the SugarCRM Public License Version 1.1.2
|
|
* ("License"); You may not use this file except in compliance with the
|
|
* License. You may obtain a copy of the License at http://www.sugarcrm.com/SPL
|
|
* Software distributed under the License is distributed on an "AS IS" basis,
|
|
* WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for
|
|
* the specific language governing rights and limitations under the License.
|
|
* The Original Code is: SugarCRM Open Source
|
|
* The Initial Developer of the Original Code is SugarCRM, Inc.
|
|
* Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.;
|
|
* All Rights Reserved.
|
|
* Contributor(s): ______________________________________.
|
|
********************************************************************************/
|
|
/*********************************************************************************
|
|
* $Header: /advent/projects/wesat/vtiger_crm/vtigercrm/modules/HelpDesk/Save.php,v 1.8 2005/04/25 05:21:46 rajeshkannan Exp $
|
|
* Description: Saves an Account record and then redirects the browser to the
|
|
* defined return URL.
|
|
* Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
|
|
* All Rights Reserved.
|
|
* Contributor(s): ______________________________________..
|
|
********************************************************************************/
|
|
|
|
require_once('modules/HelpDesk/HelpDesk.php');
|
|
require_once('include/logging.php');
|
|
require_once('include/database/PearDatabase.php');
|
|
|
|
$focus = new HelpDesk();
|
|
if(isset($_REQUEST['record']))
|
|
{
|
|
$focus->id = $_REQUEST['record'];
|
|
}
|
|
if(isset($_REQUEST['mode']))
|
|
{
|
|
$focus->mode = $_REQUEST['mode'];
|
|
}
|
|
|
|
foreach($focus->column_fields as $fieldname => $val)
|
|
{
|
|
if(isset($_REQUEST[$fieldname]))
|
|
{
|
|
$value = $_REQUEST[$fieldname];
|
|
$focus->column_fields[$fieldname] = $value;
|
|
}
|
|
|
|
}
|
|
|
|
|
|
//$focus->saveentity("HelpDesk");
|
|
$focus->save("HelpDesk");
|
|
$return_id = $focus->id;
|
|
|
|
if(isset($_REQUEST['return_module']) && $_REQUEST['return_module'] != "") $return_module = $_REQUEST['return_module'];
|
|
else $return_module = "HelpDesk";
|
|
if(isset($_REQUEST['return_action']) && $_REQUEST['return_action'] != "") $return_action = $_REQUEST['return_action'];
|
|
else $return_action = "DetailView";
|
|
if(isset($_REQUEST['return_id']) && $_REQUEST['return_id'] != "") $return_id = $_REQUEST['return_id'];
|
|
|
|
if($_REQUEST['mode'] == 'edit')
|
|
$reply = 'Re : ';
|
|
else
|
|
$reply = '';
|
|
|
|
$_REQUEST['name'] = '[ Ticket ID : '.$focus->id.' ] '.$reply.$_REQUEST['ticket_title'];
|
|
$bodysubject = ' Subject : '.$focus->id.' : '.$_REQUEST['ticket_title'].'<br><br>';
|
|
|
|
if($focus->column_fields['parent_id'] != '')
|
|
{
|
|
$query = "select * from crmentity where crmid=".$focus->column_fields['parent_id'];
|
|
$parent_module = $adb->query_result($adb->query($query),0,'setype');
|
|
if($parent_module == 'Contacts')
|
|
{
|
|
$sql = "select * from contactdetails where contactid=".$focus->column_fields['parent_id'];
|
|
$result = $adb->query($sql);
|
|
$emailoptout = $adb->query_result($result,0,'emailoptout');
|
|
$contactname = $adb->query_result($result,0,'firstname').' '.$adb->query_result($result,0,'lastname');
|
|
$contact_mailid = $adb->query_result($result,0,'email');
|
|
}
|
|
}
|
|
if($contact_mailid != '')
|
|
{
|
|
$sql = "select * from PortalInfo where user_name='".$contact_mailid."'";
|
|
$isactive = $adb->query_result($adb->query($sql),0,'isactive');
|
|
}
|
|
if($isactive == 1)
|
|
{
|
|
$bodydetails = "Dear ".$contactname.",<br><br>";
|
|
$bodydetails .= 'There is a reply to <b>'.$_REQUEST['ticket_title'].'</b> in the "Customer Portal" at VTiger.';
|
|
$bodydetails .= "You can use the following link to view the replies made:<br>";
|
|
|
|
//Provide your customer portal url
|
|
$PORTAL_URL = "<customerportal-url:port>";//e.g : vtigercrm:90/customerportal
|
|
|
|
$bodydetails .= "<a href='http://".$PORTAL_URL."/general.php?action=UserTickets&ticketid=".$focus->id."&fun=detail'>Ticket Details</a>";
|
|
$bodydetails .= "<br><br>Thanks,<br><br> Vtiger Support Team ";
|
|
|
|
$_REQUEST['description'] = $bodysubject.$bodydetails;
|
|
}
|
|
else
|
|
{
|
|
$desc = 'Ticket ID : '.$focus->id.'<br> Ticket Title : '.$reply.$_REQUEST['ticket_title'];
|
|
$desc .= "<br><br>Dear ".$contactname.",<br><br>The Ticket is replied and the details are : <br>";
|
|
$desc .= "<br> Status : ".$focus->column_fields['ticketstatus'];
|
|
$desc .= "<br> Category : ".$focus->column_fields['ticketcategories'];
|
|
$desc .= "<br> Severity : ".$focus->column_fields['ticketseverities'];
|
|
$desc .= "<br> Priority : ".$focus->column_fields['ticketpriorities'];
|
|
$desc .= '<br><br>Description : <br>'.$focus->column_fields['description'];
|
|
$desc .= '<br><br>Solution : <br>'.$focus->column_fields['solution'];
|
|
$desc .= getTicketComments($focus->id);
|
|
|
|
$_REQUEST['description'] = $desc;
|
|
}
|
|
//$_REQUEST['parent_id'] = $_REQUEST['contact_id'];
|
|
$_REQUEST['return_id'] = $return_id;
|
|
|
|
if($_REQUEST['product_id'] != '' && $focus->id != '' && $_REQUEST['mode'] != 'edit')
|
|
{
|
|
$sql = 'insert into seticketsrel values('.$_REQUEST['product_id'].' , '.$focus->id.')';
|
|
$adb->query($sql);
|
|
$return_id = $_REQUEST['product_id'];
|
|
}
|
|
|
|
if($emailoptout == 0)
|
|
{
|
|
require_once('modules/Emails/send_mail.php');
|
|
}
|
|
else
|
|
{
|
|
header("Location: index.php?action=$return_action&module=$return_module&record=$return_id");
|
|
}
|
|
|
|
function getTicketComments($ticketid)
|
|
{
|
|
global $adb;
|
|
|
|
$commentlist = '';
|
|
$sql = "select * from ticketcomments where ticketid=".$ticketid;
|
|
$result = $adb->query($sql);
|
|
for($i=0;$i<$adb->num_rows($result);$i++)
|
|
{
|
|
$comment = $adb->query_result($result,$i,'comments');
|
|
if($comment != '')
|
|
{
|
|
$commentlist .= '<br><br>'.$comment;
|
|
}
|
|
}
|
|
if($commentlist != '')
|
|
$commentlist = '<br><br> The comments are : '.$commentlist;
|
|
|
|
return $commentlist;
|
|
}
|
|
?>
|
|
|