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

<?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;
}
?>