<&#63;php
require('page_header.php');
$site_id = getIfSet($_GET, 'site_id', 0);
$customer_type = getIfSet($_GET, 'customer_type',0);
$DB = Database::connect($site_id);
if($site_id>0 && $customer_type>0){
$sql = '';
$out = '';
$short_name_array = SiteSettings::$SITE_SHORT_NAME;
$short_name = $short_name_array[$site_id];
switch ($customer_type) {
case '1':{
$sql = "SELECT
email, CONCAT(UCASE(LEFT(firstname, 1)),SUBSTRING(firstname, 2)) AS firstname, CONCAT(UCASE(LEFT(lastname, 1)),SUBSTRING(lastname, 2)) AS lastname
FROM customers
WHERE site_id =$site_id
AND email NOT REGEXP '.+(avanquest)|(planetart)|(novadevelop)|(qatest).+'
AND email IN(SELECT a.email FROM customers a INNER JOIN orders b ON a.id=b.`customer_id` AND b.is_test=0 AND a.site_id =$site_id)
AND email NOT IN (SELECT email_address FROM `newsletter_unsubscribes` WHERE site_id =$site_id);";
$res = $DB->query($sql);
$out = '
';
}
$short_name .= '_purchased';
break;
}
case '2':{
$DB->query("DROP TEMPORARY TABLE IF EXISTS tmp_purchase;");
$DB->query("CREATE TEMPORARY TABLE tmp_purchase SELECT a.email FROM customers a INNER JOIN orders b ON a.id=b.`customer_id` AND b.is_test=0 AND a.site_id =$site_id; ");
$DB->query("DROP TEMPORARY TABLE IF EXISTS tmp_nopurchase;");
$DB->query("CREATE TEMPORARY TABLE tmp_nopurchase SELECT email FROM customers WHERE site_id =$site_id AND email NOT IN(SELECT email FROM tmp_purchase);");
if(9 != $site_id){
$datatype = SiteSettings::getPurchaseDataType($site_id);
$DB->query("INSERT tmp_nopurchase SELECT DISTINCT email FROM triggered_email_data WHERE datatype='$datatype' AND email NOT IN(SELECT email FROM tmp_purchase);");
}
$sql = "SELECT DISTINCT email FROM tmp_nopurchase WHERE email NOT REGEXP '.+(avanquest)|(planetart)|(novadevelop)|(qatest).+' AND Email REGEXP '[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$' AND email NOT IN (SELECT email_address FROM `newsletter_unsubscribes` WHERE site_id =$site_id);";
$res = $DB->query($sql);
$out = '