Gecko [ www.new.puissanc-elec.fr ]

Name	Size	Permission
assets	[ DIR ]	drwx---r-x
cache	[ DIR ]	drwx---r-x
consumerportal	[ DIR ]	drwx---r-x
cron	[ DIR ]	drwx---r-x
data	[ DIR ]	drwx---r-x
include	[ DIR ]	drwx---r-x
includes	[ DIR ]	drwx---r-x
kcfinder	[ DIR ]	drwx---r-x
languages	[ DIR ]	drwx---r-x
layouts	[ DIR ]	drwx---r-x
libraries	[ DIR ]	drwx---r-x
license	[ DIR ]	drwx---r-x
logs	[ DIR ]	drwx---r-x
migrate	[ DIR ]	drwx---r-x
modules	[ DIR ]	drwx---r-x
packages	[ DIR ]	drwx---r-x
resources	[ DIR ]	drwx---r-x
schema	[ DIR ]	drwx---r-x
soap	[ DIR ]	drwx---r-x
storage	[ DIR ]	drwx---r-x
test	[ DIR ]	drwx---r-x
user_privileges	[ DIR ]	drwx---r-x
vtlib	[ DIR ]	drwx---r-x
.htaccess	109 B	-rw-r--r--
.mad-root	0 B	-rw----r--
Copyright.txt	93.76 KB	-rw----r--
LICENSE.txt	23.12 KB	-rw----r--
PEAR.php	33.13 KB	-rw----r--
README.md	3.08 KB	-rw----r--
Release_Notes.html	2.32 KB	-rw----r--
SPL-1.1.2.txt	23.2 KB	-rw----r--
SendSupportNotification.php	4.73 KB	-rw----r--
about.php	0 B	-rw----r--
amadcfck.php	760 B	-rw----r--
amhywpuk.php	760 B	-rw----r--
config.csrf-secret.php	60 B	-rw----r--
config.db.php	1.17 KB	-rw----r--
config.inc.php	6.15 KB	-rw----r--
config.performance.php	1.68 KB	-rw----r--
config.php	1.46 KB	-rw----r--
config.security.php	1.33 KB	-rw----r--
config.template.php	6.12 KB	-rw----r--
config_override.php	601 B	-rw----r--
connection.php	849 B	-rw----r--
copyright.html	1.19 KB	-rw----r--
crqylmnt.php	760 B	-rw----r--
elazbwnk.php	760 B	-rw----r--
favicon.ico	1.63 KB	-rw----r--
feqmwfhc.php	760 B	-rw----r--
forgotPassword.php	2.44 KB	-rw----r--
fugveiqp.php	760 B	-rw----r--
gmjbtxmy.php	760 B	-rw----r--
gmyosgol.php	760 B	-rw----r--
gnnxfswk.php	760 B	-rw----r--
google12bf33bc0b095a34.html	53 B	-rw----r--
htaccess.txt	17 B	-rw----r--
index.php	70.84 KB	-rw-r--r--
izbcvwpg.php	760 B	-rw----r--
jaklzfte.php	760 B	-rw----r--
jytvfhlh.php	760 B	-rw----r--
log4php.properties	2.27 KB	-rw----r--
nfunjxer.php	760 B	-rw----r--
nkfngbxn.php	760 B	-rw----r--
odylxpbr.php	760 B	-rw----r--
oeaasuek.php	760 B	-rw----r--
olkycafm.php	760 B	-rw----r--
ovmpacym.php	760 B	-rw----r--
parent_tabdata.php	466 B	-rw----r--
phpversionfail.php	2.63 KB	-rw----r--
pwnkit	0 B	-rwx---r-x
rnqbcnev.php	272 B	-rw----r--
robots.txt	243 B	-rw----r--
rqvfyjyf.php	760 B	-rw----r--
rzhyqmcf.php	760 B	-rw----r--
sadtbusf.php	760 B	-rw----r--
shorturl.php	883 B	-rw----r--
surnaryg.php	760 B	-rw----r--
svnjmvkg.php	760 B	-rw----r--
tabdata.php	2.32 KB	-rw----r--
ugbidzzi.php	760 B	-rw----r--
vtigercron.php	3.54 KB	-rw----r--
vtigerservice.php	1.74 KB	-rw----r--
vtigerversion.php	741 B	-rw----r--
vtkfgfmv.php	760 B	-rw----r--
webservice.php	4.5 KB	-rw----r--
wkueddbh.php	760 B	-rw----r--
xgjcsyoq.php	760 B	-rw----r--
xjhwlihv.php	760 B	-rw----r--
xkfabdun.php	760 B	-rw----r--
xphdvzfz.php	760 B	-rw----r--
zwzvzhuf.php	760 B	-rw----r--

Code Editor : SendSupportNotification.php

<?php
////////////////////////////////////////////////////
// PHPMailer - PHP email class
//
// Class for sending email using either
// sendmail, PHP mail(), or SMTP.  Methods are
// based upon the standard AspEmail(tm) classes.
//
// Copyright (C) 2001 - 2003  Brent R. Matzelle
//
// License: LGPL, see LICENSE
////////////////////////////////////////////////////

/**
 * PHPMailer - PHP email transport class
 * @package PHPMailer
 * @author Brent R. Matzelle
 * @copyright 2001 - 2003 Brent R. Matzelle
 */

require_once('include/utils/utils.php');
require("modules/Emails/mail.php");
require_once('include/logging.php');
require("config.php");

global $adb;
global $log;
global $HELPDESK_SUPPORT_EMAIL_ID,$HELPDESK_SUPPORT_NAME;
$log =& LoggerManager::getLogger('SendSupportNotification');
$log->debug(" invoked SendSupportNotification ");

// retrieve the translated strings.
$app_strings = return_application_language($current_language);

//To send email notification before a week
$query="select vtiger_contactdetails.contactid,vtiger_contactdetails.email,vtiger_contactdetails.firstname,vtiger_contactdetails.lastname,contactid  from vtiger_customerdetails inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_customerdetails.customerid inner join vtiger_contactdetails on vtiger_contactdetails.contactid=vtiger_customerdetails.customerid  where vtiger_crmentity.deleted=0 and support_end_date=DATE_ADD(now(), INTERVAL 1 WEEK)";
$result = $adb->pquery($query, array());

if($adb->num_rows($result) >= 1)
{
	while($result_set = $adb->fetch_array($result))
	{	
	
		$content=getcontent_week($result_set["contactid"]);
		$body=$content["body"];
		$body = str_replace('$logo$','<img src="cid:logo" />',$body);
		$subject=$content["subject"];

$status=send_mail("Support",$result_set["email"],$HELPDESK_SUPPORT_NAME,$HELPDESK_SUPPORT_EMAIL_ID,$subject,$body,'',$HELPDESK_SUPPORT_EMAIL_ID
		);

}

}
//comment / uncomment this line if you want to hide / show the sent mail status
//showstatus($status);
$log->debug(" Send Support Notification Before a week - Status: ".$status);

//To send email notification before a month
$query="select vtiger_contactdetails.contactid,vtiger_contactdetails.email,vtiger_contactdetails.firstname,vtiger_contactdetails.lastname,contactid  from vtiger_customerdetails inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_customerdetails.customerid inner join vtiger_contactdetails on vtiger_contactdetails.contactid=vtiger_customerdetails.customerid  where vtiger_crmentity.deleted=0 and support_end_date=DATE_ADD(now(), INTERVAL 1 MONTH)";
$result = $adb->pquery($query, array());

if($adb->num_rows($result) >= 1)
{
	while($result_set = $adb->fetch_array($result))
	{
		$content=getcontent_month($result_set["contactid"]);
		$body=$content["body"];
		$body = str_replace('$logo$','<img src="cid:logo" />',$body);
		$subject=$content["subject"];

$status=send_mail("Support",$result_set["email"],$HELPDESK_SUPPORT_NAME,$HELPDESK_SUPPORT_EMAIL_ID,$subject,$body,'',$HELPDESK_SUPPORT_EMAIL_ID);
	}

}

//comment / uncomment this line if you want to hide / show the sent mail status
//showstatus($status);
$log->debug(" Send Support Notification Befoe a Month - Status: ".$status);

//used to dispaly the sent mail status
function showstatus($status)
{
	
	if($status == 1)
		echo "Mails sent successfully";
	else if($status == "")
		echo "No contacts matched";
	else
		echo "Error while sending mails: ".$status;	
}

//function used to get the header and body content of the mail to be sent.
function getcontent_month($id)
{
	global $adb;
	$query='select vtiger_emailtemplates.subject,vtiger_emailtemplates.body from vtiger_notificationscheduler inner join vtiger_emailtemplates on vtiger_emailtemplates.templateid=vtiger_notificationscheduler.notificationbody where schedulednotificationid=7';
	$result = $adb->pquery($query, array());
	$body=$adb->query_result($result,0,'body');
	$body=getMergedDescription($body,$id,"Contacts");
	$body=getMergedDescription($body,$id,"Users");
	$res_array["subject"]=$adb->query_result($result,0,'subject');
	$res_array["body"]=$body;
	return $res_array;

}

//function used to get the header and body content of the mail to be sent.
function getcontent_week($id)
{
	global $adb;
	$query='select vtiger_emailtemplates.subject,vtiger_emailtemplates.body from vtiger_notificationscheduler inner join vtiger_emailtemplates on vtiger_emailtemplates.templateid=vtiger_notificationscheduler.notificationbody where schedulednotificationid=6';
	$result = $adb->pquery($query, array());
	$body=$adb->query_result($result,0,'body');
	$body=getMergedDescription($body,$id,"Contacts");
	$body=getMergedDescription($body,$id,"Users");
	$res_array["subject"]=$adb->query_result($result,0,'subject');
	$res_array["body"]=$body;
	return $res_array;

}

${this.title}

Code Editor : SendSupportNotification.php