PHP - Reminder Notes With Email Notification

Dear all,

I am using PHPMailer to send notification emails after someone submits the form and as a result I'm receiving an email which has only one line:

"A new user has been registered to your website".

What I want is to receive an HTML email (in a table format) with all the data in it.

Data           Field
Date           January 3, 2010
Name:        Aaaaa
Surname:   BBbbb...
Email:         test@email.com
Gender:      male
....               ....

Which code do I need to add in my thanks.php file in order to do this.

After filling all the data in www.domain.com/apply.php, it automatically directs the user to thanks.php file

Here is my code (thanks.php):

<?php

require_once("phpMailer/class.phpmailer.php");
require_once("phpMailer/class.smtp.php");
require_once("phpMailer/language/phpmailer.lang-en.php");

$to_name = "My Website";
$to = "email@mydomain.com";
$subject = "A new user has been registered to my website";
$message = "A new user has been registered to my website";
$message = wordwrap($message,70);
$from_name = "My Website";
$from = "email@mydomain.com";

//PHP SMTP version
$mail = new PHPMailer();

$mail->IsSMTP();
$mail->Host = "mail.website.org";
$mail->Port =25;
$mail->SMTPAuth = false;
$mail->Username = "username";
$mail->Password = "password";

$mail->FromName = $from_name;
$mail->From = $from;
$mail->AddAddress($to, $to_name);
$mail->Subject = $subject;
$mail->Body =<<<EMAILBODY


A new user has been registered to my website.

EMAILBODY;

$result = $mail->Send();
echo $result ? 'Thanks for your registering...' : 'Error';

?>

Hello.
I have a form for users to make reservations and they have to pay for that.

I activate the Payment Gateway Platform (by Redsys in Spain), and it works fine asking you for card number and it goes through correctly and says PAYMENT OK, but the notification.PHP FILE does not work.

Could my server (SSL) configuration be the problem? or is it the CODE?

Any help about this, please, would be highly appreciated.

Thank you.

Part of the Nofication.php code is:

__________________________________________________________________________________

<?php
  @ini_set("display_errors","1");
  @ini_set("display_startup_errors","1");

  $handle = fopen("_redsys.log", "a");

  require_once("include/dbcommon.php");
  require_once("redsysHMAC256_API_PHP_4.0.2/apiRedsys.php"); 

  $miObj = new RedsysAPI; 

  $version = postvalue("Ds_SignatureVersion"); 
  $params = postvalue("Ds_MerchantParameters"); 
  $signatureRecibida = postvalue("Ds_Signature");

//  $version = "HMAC_SHA256_V1"; 
//  $params = "eyJEc19BbW91bnQiOiIyMDAiLCJEc19DdXJyZW5jeSI6Ijk3OCIsIkRzX09yZGVyIjoiMjAwNjE4MDkyNDMzIiwiRHNfTWVyY2hhbnRDb2RlIjoiOTk5MDA4ODgxIiwiRHNfVGVybWluYWwiOiIxIiwiRHNfUmVzcG9uc2UiOiI5OTk4IiwiRHNfQXV0aG9yaXNhdGlvbkNvZGUiOiIiLCJEc19UcmFuc2FjdGlvblR5cGUiOiIwIiwiRHNfU2VjdXJlUGF5bWVudCI6IjAiLCJEc19MYW5ndWFnZSI6IjEiLCJEc19NZXJjaGFudERhdGEiOiIifQ=="; 
//  $signatureRecibida = "Aa6GG9IfCYlRrj-yF5VxXg_qmhJ3R-fmfXxGvB8w2Sk="; 
  
  $txt = "version=".$version."\nparams=".$params."\nsignatureRecibida=".$signatureRecibida."\n";
  fwrite($handle,"\n\n\n".date("Y-m-d h:i:s")."\n");
  fwrite($handle,$txt);

  $decodec = $miObj->decodeMerchantParameters($params); 
  $codigoRespuesta = $miObj->getParameter("Ds_Response"); 

  $claveModuloAdmin = 'sq7HjrUOBfKmC576ILgskD5srU870gJ7'; 
  $signatureCalculada = $miObj->createMerchantSignatureNotif($claveModuloAdmin, $params); 
  $res = my_json_decode($decodec);
  fwrite($handle,$decodec."\n");
  

  if ($signatureCalculada === $signatureRecibida && $res["Ds_AuthorisationCode"]!="++++++" && !isset($res["Ds_ErrorCode"]) { 
  
    fwrite($handle,"Ds_Order = ".$res["Ds_Order"]."\n");
    DB::Query("update reservas set status=1 where Ds_Order='".$res["Ds_Order"]."'");
    $rs2 = DB::Query("select * from reservas where Ds_Order='".$res["Ds_Order"]."'");
    $values = $rs2->fetchAssoc();
    $email=$values['Email'];
    $msg="";
    $msg.= "El seu codi de reserva és: ". dechex(999999999-$values['Id_Reserva'])."<br>";
    $msg.= "Código sin cifrar: ". 999999999-$values['Id_Reserva']."<br>";
    $msg.= "Reserva descifrada ". (((hexdec(dechex(999999999-$values['Id_Reserva'])))-999999999)*-1)."<br>";
    $msg.= "La data de la seva reserva es : ".$values['Dia']."-".$values['Mes']."-".$values['Año']."<br>";

    $sql = "SELECT Espacio FROM Espacios WHERE Id_Espacio=" . $values["Id_Espacio"];
    $rs = CustomQuery($sql);
    $data = db_fetch_array($rs);
    //$result["txt"] = "Ãrea: " . $data["c"];
    //$msg.= "QR : " .$values['QR']."\r\n";         //json_decode($image, true);
    //<img src="http://www.htmldog.com/badge1.gif">          https://chart.googleapis.com/chart?cht=qr&chs=150x150&chl=12345678
    //$image2= '<img src="data:image/jpeg;base64,'.$values['QR'].'>';
    $msg.= '<img src="https://chart.googleapis.com/chart?cht=qr&chs=150x150&chl=http%3A%2F%2Fwww.sungest.net/reservas_list.php?qs='.dechex(999999999-$values['Id_Reserva']).'&f=all%2F&choe=UTF-8">';
    //echo '<img src="https://chart.googleapis.com/chart?cht=qr&chs=150x150&chl=http%3A%2F%2Fwww.sungest.net/reservas_list.php?qs='.dechex(999999999-$values['Id_Reserva']).'&f=all%2F&choe=UTF-8">';

    //    echo '<img src="data:image/jpeg;base64,'.$imageData.'">';
    //echo '<img src="data:image/jpeg;base64,'.$imageData.'">';
    //echo '<img src="data:image/jpeg;base64,'.$imageData.'">';
    $msg.= "<font size=4 color='Navy'><b>La seva reserva és per anar a : </b></font>". "<font size=5 color='Olive'><b>" .$data["Espacio"] . "</b></font><br>";
    $msg.= "<font size=4 color='Olive'><b>La seva àrea assignada és: </b></font>".$values['Id_Area']."<br>";

    $subject="La seva reserva per la platja";
    $ret=runner_mail(array('to' => $email, 'subject' => $subject, 'htmlbody' => $msg));
        echo "ok";
  } 
  else
      DB::Exec("delete from reservas where Ds_Order='".$res["Ds_Order"]."'");
fclose($handle);
?>

_______________________________________________________________________________________________

Hi, im trying to make a password reminder for my game server accounts. Ok, so now in mysql i have table with 2 fields: email and pass. Here is my php coding to remind password:
Code: [Select]
<?php
session_start();
include "./global.php";
?>
<html>
<head>
<title>Password Reminder</title>
</head>
<body>
<?php

if(!isset ($_POST['submit'])) {
echo "Your e-mail: <input type='input' name='email'> <input type='submit' name='submit' value='Ok'>\n";
}else{
$to = $_POST['email'];
if($to) {
$sql = "SELECT pass FROM fpass WHERE email='".$to."'";
$res = mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($res) > 0) {
$rrow = mysql_fetch_assoc($res);
echo "Your password is: '".$rrow['pass']."'";
}else{
echo "The e-mail that you supplied does not exist!\n";
}
}else{
echo "E-Mail field is empty! Please fill it up.\n";
}
}
?>
</body>
</html>
global.php connects to mysql. But now when i typing email, the it should select password from table fpass where email = my typed email. But when i click Ok button, then it don't doing anything...
It should show me this: Your password is: blabla...

Hello Guys, can anyone know any tutorials or script to make a reminder program that will remind the user in advance.

Your concern and help is highly appreciated.

HI friends. I want to display the birthday list a week advance. I store DOB in m/d/Y format. Could u please help me ?????????

Hi Hello

I have a problem with this code, I need to make a simple calendar with birthday reminder but it is not working. I just created two variables ($BirthdayMonth and $DayBirthday) but when I add the day, I need this variable ($DayBirthday) to be static, the problem is when I change to another month then the variable $DayBirthday would be changed. Here is the source code:

<?php
$monthNames = Array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
if (!isset($_REQUEST["month"])) $_REQUEST["month"] = date("n");
if (!isset($_REQUEST["year"])) $_REQUEST["year"] = date("Y");

$cMonth = $_REQUEST["month"];
$cYear = $_REQUEST["year"];
$prev_year = $cYear;
$next_year = $cYear;

$prev_month = $cMonth-1;
$next_month = $cMonth+1;

if ($prev_month == 0 ) {
$prev_month = 12;
$prev_year = $cYear - 1;
}
if ($next_month == 13 ) {
$next_month = 1;
$next_year = $cYear + 1;
}
?>
<div id="calendar_div" name="calendar_div">
<table width="200">
<tr align="center">
<td bgcolor="#999999" style="color:#FFFFFF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="50%" align="left">&nbsp;&nbsp;<a href="<?php echo $_SERVER["PHP_SELF"] . "?month=". $prev_month . "&year=" . $prev_year; ?>" style="color:#FFFFFF">Previous</a></td>
<td width="50%" align="right"><a href="<?php echo $_SERVER["PHP_SELF"] . "?month=". $next_month . "&year=" . $next_year; ?>" style="color:#FFFFFF">Next</a>&nbsp;&nbsp;</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center">
<table width="100%" border="0" cellpadding="2" cellspacing="2">
<tr align="center">
<td colspan="7" bgcolor="#999999" style="color:#FFFFFF"><strong><?php echo $monthNames[$cMonth-1].' '.$cYear; ?></strong></td>
</tr>
<tr>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>S</strong></td>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>M</strong></td>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>T</strong></td>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>W</strong></td>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>T</strong></td>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>F</strong></td>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>S</strong></td>
</tr>

<?php
$timestamp = mktime(0,0,0,$cMonth,1,$cYear);
$maxday = date("t",$timestamp);
$thismonth = getdate ($timestamp);
$startday = $thismonth['wday'];
$BirthdayMonth = "February";
$DayBirthday = 12;
for ($i=0; $i<($maxday+$startday); $i++) {
if(($i % 7) == 0 ) echo "<tr>\n";
if(($i == $DayBirthday)) {
echo "<td bgcolor='#0000FF' align='center' valign='middle' height='20px'>".($i - $startday + 1) ."</td>\n";
} elseif($i < $startday) {
echo "<td></td>\n";
}
else {echo "<td align='center' valign='middle' height='20px'>". ($i - $startday + 1) . "</td>\n";
}
if(($i % 7) == 6 ) echo "</tr>\n";
}
echo "</br>";
echo "</br>";
echo $startday;
echo $thismonth
?>
</table>
</td>
</tr>
</table>
</div>

Where Am I failing or where is the problem ?

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=344364.0

I have a form that passes multiple images and I wanted them to have a substring of a md5 encrypted time for generating unique codes so I don't delete or overwrite an older file. I keep the actual images in a folder and the path in mysql. The folder is working perfectly and there are no problems generating unique codes but I have been trying all night and I can't figure out why mysql won't update. I can actually get it to update but then I loose the functionallity of the code and if I don't upload a 4 images and leave one blank, the blank one deletes the previously uploaded field in the table row.

Here is the md5 encrypted time for generating unique codes:

Code: [Select]
$unique = strtolower(substr(md5(time()), 0, 4));
This is how it works with the folder:

Code: [Select]
$filePath = $uploadDir . $unique . $fileName;
This is how I get it to update mysql but then loose functionality:

Code: [Select]
$values[$i] =  $unique . mysql_real_escape_string(basename(trim($_FILES[$fields[$i]]['name'])));
Here is the entire code:

Code: [Select]
<?php
require_once('storescripts/connect.php');
mysql_select_db($database_phpimage,$phpimage);
$unique = strtolower(substr(md5(time()), 0, 4));
$uploadDir = 'upload/';

if(isset($_POST['upload' . $config]))
{
foreach ($_FILES as $file)
{

$fileName = $file['name'];
$tmpName = $file['tmp_name'];
$fileSize = $file['size'];
$fileType = $file['type'];

if($fileName==""){

$filePath = 'upload/';
}
else{

$filePath = $uploadDir . $unique . $fileName;
}

$filePath = str_replace(" ", "_", $filePath);
$result = move_uploaded_file($tmpName, $filePath);

if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
$filePath = addslashes($filePath);
}
$fileinsert[]=$filePath;
}
}

$mid   = mysql_real_escape_string(trim($_POST['mid']));
$cat   = mysql_real_escape_string(trim($_POST['cat']));
$item  = mysql_real_escape_string(trim($_POST['item']));
$price = mysql_real_escape_string(trim($_POST['price']));
$about = mysql_real_escape_string(trim($_POST['about']));

$fields = array();
$values = array();
$updateVals = array();
for($i=1; $i<=4; $i++)
{
    $fields[$i] = 'name'.$i;
    $values[$i] =  mysql_real_escape_string(basename(trim($_FILES[$fields[$i]]['name'])));
    if($values[$i] != '')
    {
        $updateVals[] = "{$fields[$i]} = '{$values[$i]}'";
    }
}

$updateNames = '';
if(count($updateVals))
{
$updateNames =  ", " . implode(', ', $updateVals);
}

$update = "INSERT INTO image
               (mid, cid, item, price, about, name1, name2, name3, name4)
           VALUES
               ('$mid', '$cat', '$item', '$price', '$about', '$values[1]', '$values[2]', '$values[3]', '$values[4]')
           ON DUPLICATE KEY UPDATE
                cid = '$cat', item = '$item', price = '$price', about = '$about' $updateNames";
$result = mysql_query($update) or die (mysql_error());

$id = mysql_insert_id();

?>
<p style="font-size:35px; font-family:Arial, Helvetica, sans-serif; color:#255E67; margin-left:25px;">Your Item Has Been Uploaded!</p>
<script type="text/javascript">
setTimeout('ourRedirect()', 2000)
function ourRedirect() {
location.href='protator_php.php?mid=<?php echo $id ?>'
}
</script>

I'm using a woocommerce order report plugin, some customers order multiple products but order report shows only number of order and one product name: I want to see all product names: also I want to see customer notes it doesn't show up

 

<?php

/**

 * Plugin Name: Custom Order Report

 * Description: Generates a report on individual WooCommerce products sold during a specified time period.

 * Version: 1.4.8

 */





// Add the Product Sales Report to the WordPress admin

add_action('admin_menu', 'hm_psrf_admin_menu');

function hm_psrf_admin_menu() {

	add_submenu_page('woocommerce', 'Custom Order Report', 'Custom Order Report', 'view_woocommerce_reports', 'hm_sbpf', 'hm_sbpf_page');

}



function hm_psrf_default_report_settings() {

	return array(

		'report_time' => '30d',

		'report_start' => date('Y-m-d', current_time('timestamp') - (86400 * 31)),

		'report_end' => date('Y-m-d', current_time('timestamp') - 86400),

		'order_statuses' => array('wc-processing', 'wc-on-hold', 'wc-completed'),

		'products' => 'all',

		'product_cats' => array(),

		'product_ids' => '',

		'variations' => 0,

		'orderby' => 'quantity',

		'orderdir' => 'desc',

		'fields' => array('product_id', 'product_sku', 'product_name', 'quantity_sold', 'gross_sales'),

		'limit_on' => 0,

		'limit' => 10,

		'include_header' => 1,

		'exclude_free' => 0

	);

}



// This function generates the Product Sales Report page HTML

function hm_sbpf_page() {



	$savedReportSettings = get_option('hm_psr_report_settings');

	if (isset($_POST['op']) && $_POST['op'] == 'preset-del' && !empty($_POST['r']) && isset($savedReportSettings[$_POST['r']])) {

		unset($savedReportSettings[$_POST['r']]);

		update_option('hm_psr_report_settings', $savedReportSettings);

		$_POST['r'] = 0;

		echo('<script type="text/javascript">location.href = location.href;</script>');

	}

	

	$reportSettings = (empty($savedReportSettings) ?

						hm_psrf_default_report_settings() :

						array_merge(hm_psrf_default_report_settings(),

								$savedReportSettings[

									isset($_POST['r']) && isset($savedReportSettings[$_POST['r']]) ? $_POST['r'] : 0

								]

						));

	

	// For backwards compatibility with pre-1.4 versions

	if (!empty($reportSettings['cat'])) {

		$reportSettings['products'] = 'cats';

		$reportSettings['product_cats'] = array($reportSettings['cat']);

	}

	

	$fieldOptions = array(
         
         'order_id' => 'Order ID',
		/*'product_id' => 'Product ID',*/
        'customer_name' => 'Customer Name',
		/*'variation_id' => 'Variation ID',*/
		'city' => 'City',
        'address' => 'Address',
        'product_name' => 'Product Name',
        'quantity_sold' => 'Quantity Sold',
		/*'product_sku' => 'Product SKU',*/
		'gross_sales' => 'Gross Sales',
		'product_categories' => 'Schools',
		/*'variation_attributes' => 'Variation Attributes',*/
		/*'gross_after_discount' => 'Gross Sales (After Discounts)'*/
        'ceremony_date' => 'Ceremony Date',
        'ceremony_time' => 'Ceremony Time',
	);

		

	include(dirname(__FILE__).'/admin.php');

}



// Hook into WordPress init; this function performs report generation when

// the admin form is submitted

add_action('init', 'hm_sbpf_on_init', 9999);

function hm_sbpf_on_init() {

	global $pagenow;

	

	// Check if we are in admin and on the report page

	if (!is_admin())

		return;

	if ($pagenow == 'admin.php' && isset($_GET['page']) && $_GET['page'] == 'hm_sbpf' && !empty($_POST['hm_sbp_do_export'])) {

		

		// Verify the nonce

		check_admin_referer('hm_sbpf_do_export');

		

		$newSettings = array_intersect_key($_POST, hm_psrf_default_report_settings());

		foreach ($newSettings as $key => $value)

			if (!is_array($value))

				$newSettings[$key] = htmlspecialchars($value);

		

		// Update the saved report settings

		$savedReportSettings = get_option('hm_psr_report_settings');

		$savedReportSettings[0] = array_merge(hm_psrf_default_report_settings(), $newSettings);

		



		update_option('hm_psr_report_settings', $savedReportSettings);

		

		// Check if no fields are selected or if not downloading

		if (empty($_POST['fields']) || empty($_POST['hm_sbp_download']))

			return;

		

		

		// Assemble the filename for the report download

		$filename =  'Product Sales - ';

		if (!empty($_POST['cat']) && is_numeric($_POST['cat'])) {

			$cat = get_term($_POST['cat'], 'product_cat');

			if (!empty($cat->name))

				$filename .= addslashes(html_entity_decode($cat->name)).' - ';

		}

		$filename .= date('Y-m-d', current_time('timestamp')).'.csv';

		

		// Send headers

		header('Content-Type: text/csv');

		header('Content-Disposition: attachment; filename="'.$filename.'"');

		

		// Output the report header row (if applicable) and body

		$stdout = fopen('php://output', 'w');

		if (!empty($_POST['include_header']))

			hm_sbpf_export_header($stdout);

		hm_sbpf_export_body($stdout);

		

		exit;

	}

}



// This function outputs the report header row

function hm_sbpf_export_header($dest, $return=false) {

	$header = array();

	

	foreach ($_POST['fields'] as $field) {

		switch ($field) {

			case 'order_id':

				$header[] = 'Order ID';

				break;
            case 'product_name':

				$header[] = 'Product Name';

				break;
			case 'quantity_sold':

				$header[] = 'Quantity Sold';

				break;	
			case 'gross_sales':

				$header[] = 'Gross Sales';

				break;	
			case 'product_categories':

				$header[] = 'Schools';

				break;		
            case 'customer_name':

				$header[] = 'Customer Name';

				break;
			case 'city':

				$header[] = 'City';

				break;
			case 'address':

				$header[] = 'Address';

				break;		
			
			case 'ceremony_date':

				$header[] = 'Ceremony Date';

				break;
		    case 'ceremony_time':

				$header[] = 'Ceremony Time';

				break;				

		}

	}

	

	if ($return)

		return $header;

	fputcsv($dest, $header);

}



// This function generates and outputs the report body rows

function hm_sbpf_export_body($dest, $return=false) {

	global $woocommerce, $wpdb;

	

	$product_ids = array();

	if ($_POST['products'] == 'cats') {

		$cats = array();

		foreach ($_POST['product_cats'] as $cat)

			if (is_numeric($cat))

				$cats[] = $cat;

		$product_ids = get_objects_in_term($cats, 'product_cat');

	} else if ($_POST['products'] == 'ids') {

		foreach (explode(',', $_POST['product_ids']) as $productId) {

			$productId = trim($productId);

			if (is_numeric($productId))

				$product_ids[] = $productId;

		}

	}

	

	// Calculate report start and end dates (timestamps)

	switch ($_POST['report_time']) {

		case '0d':

			$end_date = strtotime('midnight', current_time('timestamp'));

			$start_date = $end_date;

			break;

		case '1d':

			$end_date = strtotime('midnight', current_time('timestamp')) - 86400;

			$start_date = $end_date;

			break;

		case '7d':

			$end_date = strtotime('midnight', current_time('timestamp')) - 86400;

			$start_date = $end_date - (86400 * 6);

			break;

		case '1cm':

			$start_date = strtotime(date('Y-m', current_time('timestamp')).'-01 midnight -1month');

			$end_date = strtotime('+1month', $start_date) - 86400;

			break;

		case '0cm':

			$start_date = strtotime(date('Y-m', current_time('timestamp')).'-01 midnight');

			$end_date = strtotime('+1month', $start_date) - 86400;

			break;

		case '+1cm':

			$start_date = strtotime(date('Y-m', current_time('timestamp')).'-01 midnight +1month');

			$end_date = strtotime('+1month', $start_date) - 86400;

			break;

		case '+7d':

			$start_date = strtotime('midnight', current_time('timestamp')) + 86400;

			$end_date = $start_date + (86400 * 6);

			break;

		case '+30d':

			$start_date = strtotime('midnight', current_time('timestamp')) + 86400;

			$end_date = $start_date + (86400 * 29);

			break;

		case 'custom':

			$end_date = strtotime('midnight', strtotime($_POST['report_end']));

			$start_date = strtotime('midnight', strtotime($_POST['report_start']));

			break;

		default: // 30 days is the default

			$end_date = strtotime('midnight', current_time('timestamp')) - 86400;

			$start_date = $end_date - (86400 * 29);

	}

	

	// Assemble order by string

	$orderby = (in_array($_POST['orderby'], array('product_id', 'gross', 'gross_after_discount')) ? $_POST['orderby'] : 'quantity');

	$orderby .= ' '.($_POST['orderdir'] == 'asc' ? 'ASC' : 'DESC');

	

	// Create a new WC_Admin_Report object

	include_once($woocommerce->plugin_path().'/includes/admin/reports/class-wc-admin-report.php');

	$wc_report = new WC_Admin_Report();

	$wc_report->start_date = $start_date;

	$wc_report->end_date = $end_date;

	

	//echo(date('Y-m-d', $end_date));

	

	$where_meta = array();

	if ($_POST['products'] != 'all') {

		$where_meta[] = array(

			'type' => 'order_item_meta',

			'meta_key' => '_product_id',

			'operator' => 'in',

			'meta_value' => $product_ids

		);

	}

	if (!empty($_POST['exclude_free'])) {

		$where_meta[] = array(

			'meta_key' => '_line_total',

			'meta_value' => 0,

			'operator' => '!=',

			'type' => 'order_item_meta'

		);

	}

	

	// Get report data

	

	// Avoid max join size error

	$wpdb->query('SET SQL_BIG_SELECTS=1');

	

	// Prevent plugins from overriding the order status filter

	add_filter('woocommerce_reports_order_statuses', 'hm_psrf_report_order_statuses', 9999);

	

	// Based on woocoommerce/includes/admin/reports/class-wc-report-sales-by-product.php

	$sold_products = $wc_report->get_order_report_data(array(

		'data' => array(

			'_product_id' => array(

				'type' => 'order_item_meta',

				'order_item_type' => 'line_item',

				'function' => '',

				'name' => 'product_id'

			),

			'_qty' => array(

				'type' => 'order_item_meta',

				'order_item_type' => 'line_item',

				'function' => 'SUM',

				'name' => 'quantity'

			),

			'_line_subtotal' => array(

				'type' => 'order_item_meta',

				'order_item_type' => 'line_item',

				'function' => 'SUM',

				'name' => 'gross'

			),

			'_line_total' => array(

				'type' => 'order_item_meta',

				'order_item_type' => 'line_item',

				'function' => 'SUM',

				'name' => 'gross_after_discount'

			),
            /*usama*/
			'order_id' => array(

				'type' => 'order_item',

				'order_item_type' => 'line_item',

				'function' => '',

				'name' => 'order_id'
			)
             /*usama*/
		),

		'query_type' => 'get_results',

		'group_by' => 'order_id',

		'where_meta' => $where_meta,

		'order_by' => $orderby,

		'limit' => (!empty($_POST['limit_on']) && is_numeric($_POST['limit']) ? $_POST['limit'] : ''),

		'filter_range' => ($_POST['report_time'] != 'all'),

		'order_types' => wc_get_order_types('order_count'),

		'order_status' => hm_psrf_report_order_statuses()

	));

	

	// Remove report order statuses filter

	remove_filter('woocommerce_reports_order_statuses', 'hm_psrf_report_order_statuses', 9999);

	

	if ($return)

		$rows = array();



	// Output report rows

	foreach ($sold_products as $product) {

		$row = array();

		
         /*usama*/
		$order = wc_get_order($product->order_id);
        $customerName =  $order->get_billing_first_name().' '.$order->get_billing_last_name();
        $billingCity = $order->get_billing_city();
        $billingAddress1 = $order->get_billing_address_1();
        
        //echo $product->order_id;
        //echo $customerName.$city.$billingAddress1;
		//echo '<pre>';print_r($order);exit;
         /*usama*/
		foreach ($_POST['fields'] as $field) {

			switch ($field) {

				case 'order_id':

					$row[] = $product->order_id;

					break;
				case 'product_name':

					$row[] = html_entity_decode(get_the_title($product->product_id));

					break;

				case 'quantity_sold':

					$row[] = $product->quantity;

					break;

				case 'gross_sales':

					$row[] = $product->gross;

					break;	
				/*case 'variation_id':

					$row[] = (empty($product->variation_id) ? '' : $product->variation_id);

					break;

				case 'product_sku':

					$row[] = get_post_meta($product->product_id, '_sku', true);

					break;*/
				case 'product_categories':

					$terms = get_the_terms($product->product_id, 'product_cat');

					if (empty($terms)) {

						$row[] = '';

					} else {

						$categories = array();

						foreach ($terms as $term)

							$categories[] = $term->name;

						$row[] = implode(', ', $categories);

					}

				break;	
                case 'customer_name':

					$row[] = $customerName;

					break;
                case 'city':

					$row[] = $billingCity;

					break;
				case 'address':

					$row[] = $billingAddress1;

					break;


				/*case 'gross_after_discount':

					$row[] = $product->gross_after_discount;

					break;*/


                /*usama*/
				
				case 'ceremony_date':

					$row[] = $order->get_meta( '_billing_myfield12', true );

					break;
				case 'ceremony_time':

					$row[] = $order->get_meta( '_billing_myfield13', true );

					break;

			}

		}

			

		if ($return)

			$rows[] = $row;

		else

			fputcsv($dest, $row);

	}

	if ($return)

		return $rows;

}



add_action('admin_enqueue_scripts', 'hm_psrf_admin_enqueue_scripts');

function hm_psrf_admin_enqueue_scripts() {

	wp_enqueue_style('hm_psrf_admin_style', plugins_url('css/hm-product-sales-report.css', __FILE__));

	wp_enqueue_style('pikaday', plugins_url('css/pikaday.css', __FILE__));

	wp_enqueue_script('moment', plugins_url('js/moment.min.js', __FILE__));

	wp_enqueue_script('pikaday', plugins_url('js/pikaday.js', __FILE__));

}



// Schedulable email report hook

add_filter('pp_wc_get_schedulable_email_reports', 'hm_psrf_add_schedulable_email_reports');

function hm_psrf_add_schedulable_email_reports($reports) {

	$reports['hm_psr'] = array(

		'name' => 'Product Sales Report',

		'callback' => 'hm_psrf_run_scheduled_report',

		'reports' => array(

			'last' => 'Last used settings'

		)

	);

	return $reports;

}



function hm_psrf_run_scheduled_report($reportId, $start, $end, $args=array(), $output=false) {

	$savedReportSettings = get_option('hm_psr_report_settings');

	if (!isset($savedReportSettings[0]))

		return false;

	$prevPost = $_POST;

	$_POST = $savedReportSettings[0];

	$_POST['report_time'] = 'custom';

	$_POST['report_start'] = date('Y-m-d', $start);

	$_POST['report_end'] = date('Y-m-d', $end);

	$_POST = array_merge($_POST, array_intersect_key($args, $_POST));

	

	if ($output) {

		echo('<table><thead><tr>');

		foreach (hm_sbpf_export_header(null, true) as $heading) {

			echo("<th>$heading</th>");

		}

		echo('</tr></thead><tbody>');

		foreach (hm_sbpf_export_body(null, true) as $row) {

			echo('<tr>');

			foreach ($row as $cell)

				echo('<td>'.htmlspecialchars($cell).'</td>');

			echo('</tr>');

		}

		echo('</tbody></table>');

		$_POST = $prevPost;

		return;

	}

	

	$filename = get_temp_dir().'/Product Sales Report.csv';

	$out = fopen($filename, 'w');

	if (!empty($_POST['include_header']))

		hm_sbpf_export_header($out);

	hm_sbpf_export_body($out);

	fclose($out);

	

	$_POST = $prevPost;

	

	return $filename;

}



function hm_psrf_report_order_statuses() {

	$wcOrderStatuses = wc_get_order_statuses();

	$orderStatuses = array();

	if (!empty($_POST['order_statuses'])) {

		foreach ($_POST['order_statuses'] as $orderStatus) {

			if (isset($wcOrderStatuses[$orderStatus]))

				$orderStatuses[] = substr($orderStatus, 3);

		}

	}

	return $orderStatuses;

}



/* Review/donate notice */



register_activation_hook(__FILE__, 'hm_psrf_first_activate');

function hm_psrf_first_activate() {

	$pre = 'hm_psr';

	$firstActivate = get_option($pre.'_first_activate');

	if (empty($firstActivate)) {

		update_option($pre.'_first_activate', time());

	}

}

if (is_admin() && get_option('hm_psr_rd_notice_hidden') != 1 && time() - get_option('hm_psr_first_activate') >= (14*86400)) {

	add_action('admin_notices', 'hm_psrf_rd_notice');

	add_action('wp_ajax_hm_psrf_rd_notice_hide', 'hm_psrf_rd_notice_hide');

}

function hm_psrf_rd_notice() {

	$pre = 'hm_psr';

	$slug = 'product-sales-report-for-woocommerce';

	echo('

		<div id="'.$pre.'_rd_notice" class="updated notice is-dismissible"><p>Do you use the <strong>Product Sales Report</strong> plugin?

		Please support our free plugin by <a href="" target="_blank">making a donation</a>!product-sales-report-for-woocommerce

		Thanks!</p></div>

		<script>jQuery(document).ready(function($){$(\'#'.$pre.'_rd_notice\').on(\'click\', \'.notice-dismiss\', function(){jQuery.post(ajaxurl, {action:\'hm_psrf_rd_notice_hide\'})});});</script>

	');

}

function hm_psrf_rd_notice_hide() {

	$pre = 'hm_psr';

	update_option($pre.'_rd_notice_hidden', 1);

}

?>

 

hey guys im interested in the jquery notification scripts...where a user registers and then gets redirected to homepage where a notification pops up saying "thank you for registering".   now ive looked at a few examples online but im clueless to how each individiual notification pops up is it activated by the refering url?   would be good to know...but thats the only way to me that makes sense on how it works.   thank you

Hello, I want this to Block NULLS and When its not there own. Please help.

<?php if($_GET['usercp'] == 'vinbox' && $_GET['id']) {  ?>
<?php
$id="{$_GET['id']}";
if($_GET['id'] == null or $_GET['id'] == 0){
  die("You have reached a Null Page. <a href=\"index.php\">Go back home</a>");
}
$view_a = mysql_query("SELECT * FROM notifications WHERE id='$id'");
    while($view_b = mysql_fetch_array($view_a)){
        $msgid = $view_b['id'];
        $msgname = $view_b['title'];
        $msgdate = $view_b['sent'];
        $msgsender = $view_b['senderid'];
        $msgreciever = $view_b['msgreciever'];
        $msgtext = $view_b['text'];
        $msgread = $view_b['read'];
    }
    $msgdatee = date('D, M d, Y h:i A', strtotime($msgdate));
$recieverfind = mysql_query("SELECT * FROM users WHERE id='$msgsender'");
While($recieverfound = mysql_fetch_assoc($recieverfind)) {
$username = $recieverfound['username'];
$userid = $recieverfound['id'];
}
if($userid == $msgreciever) {
    if($msgread <= 0){
    mysql_query("UPDATE notifications SET `read`='1' WHERE `id`='".$id."'");
    }
?>
<div class="usercp_body"><!--  UserCP Notification Sent Start -->
<div id="dash_chart" class="notifications" style="width:100%;margin: 0 auto;">
<div class="notifications-header">
<h4><center>Viewing Message: <?php echo ucfirst($msgname); ?></center></h4>
</div>
<div class="notifications-content" style="padding:10px 10px 10px 10px;">
<i><b>Sent From: </b></i><?php echo $username; ?><br>
<i><b>Date Sent: </b></i><?php echo $msgdatee ;?><br>
<i><b>Message: </b></i><br><hr><?php echo ucfirst($msgtext); ?>
<br><hr><br>
<i><b>Reply: </b></i><textarea> </textarea>
</div></div></div><!--  UserCP Notification Sent End -->
<?php 
    } else { 
    echo "This Message does not Belong to you"; 
    } 
    }



Sorry for short explanation. I'm very tired

hi all, how can i create a notification badge in php eg like when i have a new message, it will display on the nav indicating new message and the number of messages.

thanks

Hey guys what should i look for in a script to make a small script that gets the DB information and shows notifications?

like messages(3)

members(23)

.....

i know count rows can do it.i think?

Helo, I am new here. I have a simple  " Like " plugin for Vanilla Forums which does it work nicely. Sadly, it won't sent notifications when someone likes our post. I have another plugin from the same author which gives notifications on Profile-Like aka Kick/Poke. I am trying to use the notification part of the Kick plugin ( which I modified at my best to " Like ") added to the " Like " plugin so that I will able to provide notifications to post-authors on receiving  a " Like ". I have created a GitHub repo with my attempt so far. It would be nice if someone can help me find a final solution. Thanks

https://github.com/meetdilip/Like