/mnt/web601/b3/14/57451114/htdocs/httpdocs/admin/includes/classes/campaigns.php
<?php
/* --------------------------------------------------------------
campaigns.php 2022-08-04
Gambio GmbH
http://www.gambio.de
Copyright (c) 2022 Gambio GmbH
Released under the GNU General Public License (Version 2)
[http://www.gnu.org/licenses/gpl-2.0.html]
IMPORTANT! THIS FILE IS DEPRECATED AND WILL BE REPLACED IN THE FUTURE.
MODIFY IT ONLY FOR FIXES. DO NOT APPEND IT WITH NEW FEATURES, USE THE
NEW GX-ENGINE LIBRARIES INSTEAD.
--------------------------------------------------------------
--------------------------------------------------------------
$Id: campaigns.php 1176 2005-08-22 21:44:28Z mz $
XT-Commerce - community made shopping
http://www.xt-commerce.com
Copyright (c) 2005 XT-Commerce
--------------------------------------------------------------
based on:
(c) 2000-2001 The Exchange Project (earlier name of osCommerce)
(c) 2002-2003 osCommerce coding standards; www.oscommerce.com
Released under the GNU General Public License
--------------------------------------------------------------*/
class campaigns_ORIGIN {
function __construct(& $get_array) {
global $currencies;
if (count($get_array) == 9) {
$this->startD = $get_array['startD'];
$this->startM = $get_array['startM'];
$this->startY = $get_array['startY'];
$this->startDate = mktime(0, 0, 0, $this->startM, $this->startD, $this->startY);
$this->endD = $get_array['endD'];
$this->endM = $get_array['endM'];
$this->endY = $get_array['endY'];
$this->endDate = mktime(0, 0, 0, $this->endM, $this->endD, $this->endY);
$this->status = $get_array['status'];
$this->campaign = $get_array['campaign'];
$this->campaigns = $this->getCampaigns();
if ($get_array['campaign'] == "0") {
$this->SelectArray = $this->campaigns;
} else {
$this->SelectArray = $this->getSelectedCampaign();
}
$this->type = $get_array['report'];
$this->result = array ();
$this->total = array ();
// query data
$this->counter = 0;
$this->counterCMP = 0;
// daily
$this->getTotalLeads();
$this->getTotalSells();
for ($n = 0; $n < count($this->SelectArray); $n ++) {
$this->campaign = $this->SelectArray[$n]['id'];
$this->result[$this->counterCMP]['id'] = $this->campaign;
$this->result[$this->counterCMP]['text'] = $this->camp[$this->campaign];
switch ($this->type) {
// yearly
case 1 :
$start = $this->startDate;
while ($start <= $this->endDate) {
$end = mktime(0, 0, 0, date("m", $start), date("d", $start), date("Y", $start) + 1);
// get Leads
$this->getLeads($start, $this->type, $end);
// get Sells
$this->getSells($start, $this->type, $end);
$this->getHits($start, $this->type, $end);
$start = $end;
$this->counter++;
}
break;
// monthly
case 2 :
$start = $this->startDate;
while ($start <= $this->endDate) {
$end = mktime(0, 0, 0, date("m", $start) + 1, date("d", $start), date("Y", $start));
// get Leads
$this->getLeads($start, $this->type, $end);
// get Sells
$this->getSells($start, $this->type, $end);
$this->getHits($start, $this->type, $end);
$start = $end;
$this->counter++;
}
break;
// weekly
case 3 :
$start = $this->startDate;
while ($start <= $this->endDate) {
$end = mktime(0, 0, 0, date("m", $start), date("d", $start) + 7, date("Y", $start));
// get Leads
$this->getLeads($start, $this->type, $end);
// get Sells
$this->getSells($start, $this->type, $end);
$this->getHits($start, $this->type, $end);
$start = $end;
$this->counter++;
}
break;
// daily
case 4 :
$start = $this->startDate;
while ($start <= $this->endDate) {
$end = mktime(0, 0, 0, date("m", $start), date("d", $start) + 1, date("Y", $start));
// get Leads
$this->getLeads($start, $this->type);
// get Sells
$this->getSells($start, $this->type);
$this->getHits($start, $this->type);
$start = $end;
$this->counter++;
}
break;
}
$this->counter = 0;
$this->counterCMP++;
}
// $this->printResult();
$this->total['sum_plain'] = $this->total['sum'];
$this->total['sum'] = $currencies->format($this->total['sum']);
}
}
function getCampaigns() {
$campaign = array ();
$campaign_query = "SELECT * FROM ".TABLE_CAMPAIGNS;
$campaign_query = xtc_db_query($campaign_query);
while ($campaign_data = xtc_db_fetch_array($campaign_query)) {
$campaign[] = array ('id' => $campaign_data['campaigns_refID'], 'text' => $campaign_data['campaigns_name']);
$this->camp[$campaign_data['campaigns_refID']] = $campaign_data['campaigns_name'];
}
return $campaign;
}
function getSelectedCampaign() {
$campaign = array ();
$campaign_query = "SELECT * FROM ".TABLE_CAMPAIGNS." WHERE campaigns_refID='".$this->campaign."'";
$campaign_query = xtc_db_query($campaign_query);
while ($campaign_data = xtc_db_fetch_array($campaign_query)) {
$campaign[] = array ('id' => $campaign_data['campaigns_refID'], 'text' => $campaign_data['campaigns_name']);
}
return $campaign;
}
function getTotalLeads() {
$end = mktime(0, 0, 0, date("m", $this->endDate), date("d", $this->endDate) + 1, date("Y", $this->endDate));
$selection = " and ci.customers_info_date_account_created>'".xtc_db_input(date("Y-m-d", $this->startDate))."'"." and ci.customers_info_date_account_created<'".xtc_db_input(date("Y-m-d", $end))."'";
$lead_query = "SELECT count(*) as leads FROM ".TABLE_CUSTOMERS." c, ".TABLE_CUSTOMERS_INFO." ci WHERE c.customers_id=ci.customers_info_id".$selection;
$lead_query = xtc_db_query($lead_query);
$lead_data = xtc_db_fetch_array($lead_query);
$this->total['leads'] = $lead_data['leads'];
}
function getTotalSells() {
$end = mktime(0, 0, 0, date("m", $this->endDate), date("d", $this->endDate) + 1, date("Y", $this->endDate));
$selection = " and o.date_purchased>'".xtc_db_input(date("Y-m-d", $this->startDate))."'"." and o.date_purchased<'".xtc_db_input(date("Y-m-d", $end))."'";
$status = "";
if ($this->status > 0)
$status = " and o.orders_status='".$this->status."'";
$sale_query = "SELECT count(*) as sells, SUM(ot.value) as Summe FROM ".TABLE_ORDERS." o, ".TABLE_ORDERS_TOTAL." ot WHERE o.orders_id=ot.orders_id and ot.class='ot_total'".$selection.$status;
$sale_query = xtc_db_query($sale_query);
$sale_data = xtc_db_fetch_array($sale_query);
$this->total['sells'] = $sale_data['sells'];
$this->total['sum'] = $sale_data['Summe'];
}
function getSells($date_start, $type, $date_end = '') {
global $currencies;
switch ($type) {
case 1 :
case 2 :
case 3 :
$selection = " and o.date_purchased>'".xtc_db_input(date("Y-m-d", $date_start))."'"." and o.date_purchased<'".xtc_db_input(date("Y-m-d", $date_end))."'";
break;
// daily
case 4 :
$end = mktime(0, 0, 0, date("m", $date_start), date("d", $date_start) + 1, date("Y", $date_start));
$selection = " and o.date_purchased>'".xtc_db_input(date("Y-m-d", $date_start))."'"." and o.date_purchased<'".xtc_db_input(date("Y-m-d", $end))."'";
break;
}
$status = "";
if ($this->status > 0)
$status = " and o.orders_status='".$this->status."'";
$sell_query = "SELECT count(*) as sells, SUM(ot.value) as Summe FROM ".TABLE_ORDERS." o, ".TABLE_ORDERS_TOTAL." ot WHERE o.orders_id=ot.orders_id and ot.class='ot_total' and o.conversion_type='1' and o.refferers_id='".$this->campaign."'".$selection.$status;
$sell_query = xtc_db_query($sell_query);
$sell_data = xtc_db_fetch_array($sell_query);
$late_sell_query = "SELECT count(*) as sells, SUM(ot.value) as Summe FROM ".TABLE_ORDERS." o, ".TABLE_ORDERS_TOTAL." ot WHERE o.orders_id=ot.orders_id and ot.class='ot_total' and o.conversion_type='2' and o.refferers_id='".$this->campaign."'".$selection.$status;
$late_sell_query = xtc_db_query($late_sell_query);
$late_sell_data = xtc_db_fetch_array($late_sell_query);
$this->result[$this->counterCMP]['result'][$this->counter]['sells'] = $sell_data['sells'];
$this->result[$this->counterCMP]['result'][$this->counter]['sum'] = $currencies->format(($sell_data['Summe']+$late_sell_data['Summe']));
if (array_key_exists('sells_s', $this->result[$this->counterCMP])) {
$this->result[$this->counterCMP]['sells_s'] += $sell_data['sells'];
} else {
$this->result[$this->counterCMP]['sells_s'] = $sell_data['sells'];
}
if(array_key_exists('sum_s', $this->result[$this->counterCMP])) {
$this->result[$this->counterCMP]['sum_s'] += ($sell_data['Summe'] + $late_sell_data['Summe']);
}
if ($this->total['sells'] == 0) {
$this->result[$this->counterCMP]['result'][$this->counter]['sells_p'] = 0;
$this->result[$this->counterCMP]['result'][$this->counter]['late_sells_p'] = 0;
$this->result[$this->counterCMP]['result'][$this->counter]['sum_p'] = 0;
} else {
$this->result[$this->counterCMP]['result'][$this->counter]['sells_p'] = $sell_data['sells'] / $this->total['sells'] * 100;
$this->result[$this->counterCMP]['result'][$this->counter]['late_sells_p'] = $late_sell_data['sells'] / $this->total['sells'] * 100;
$this->result[$this->counterCMP]['result'][$this->counter]['sum_p'] = round(($sell_data['Summe']+$late_sell_data['Summe'])/$this->total['sum']*100,2);
}
$this->result[$this->counterCMP]['result'][$this->counter]['late_sells'] = $late_sell_data['sells'];
if (array_key_exists('late_sells_s', $this->result[$this->counterCMP])) {
$this->result[$this->counterCMP]['late_sells_s'] += $late_sell_data['sells'];
} else {
$this->result[$this->counterCMP]['late_sells_s'] = $late_sell_data['sells'];
}
}
function getLeads($date_start, $type, $date_end = '') {
switch ($type) {
case 1 :
case 2 :
case 3 :
$selection = " and ci.customers_info_date_account_created>'".xtc_db_input(date("Y-m-d", $date_start))."'"." and ci.customers_info_date_account_created<'".xtc_db_input(date("Y-m-d", $date_end))."'";
break;
case 4 :
$end = mktime(0, 0, 0, date("m", $date_start), date("d", $date_start) + 1, date("Y", $date_start));
$selection = " and ci.customers_info_date_account_created>'".xtc_db_input(date("Y-m-d", $date_start))."'"." and ci.customers_info_date_account_created<'".xtc_db_input(date("Y-m-d", $end))."'";
break;
}
// select leads
$lead_query = "SELECT count(*) as leads FROM ".TABLE_CUSTOMERS." c, ".TABLE_CUSTOMERS_INFO." ci WHERE c.customers_id=ci.customers_info_id AND c.refferers_id='".$this->campaign."'".$selection;
$lead_query = xtc_db_query($lead_query);
$lead_data = xtc_db_fetch_array($lead_query);
$this->result[$this->counterCMP]['result'][$this->counter]['range'] = $this->getDateFormat($date_start, $date_end);
$this->result[$this->counterCMP]['result'][$this->counter]['leads'] = $lead_data['leads'];
if (array_key_exists('leads_s', $this->result[$this->counterCMP])) {
$this->result[$this->counterCMP]['leads_s'] += $lead_data['leads'];
}
if ($this->total['leads'] == 0) {
$this->result[$this->counterCMP]['result'][$this->counter]['leads_p'] = 0;
} else {
$this->result[$this->counterCMP]['result'][$this->counter]['leads_p'] = $lead_data['leads'] / $this->total['leads'] * 100;
}
}
function getHits($date_start, $type=1, $date_end = '') {
switch ($type) {
case 1 :
case 2 :
case 3 :
$selection = " and time>'".xtc_db_input(date("Y-m-d", $date_start))."'"." and time <'".xtc_db_input(date("Y-m-d", $date_end))."'";
break;
case 4 :
$end = mktime(0, 0, 0, date("m", $date_start), date("d", $date_start) + 1, date("Y", $date_start));
$selection = " and time>'".xtc_db_input(date("Y-m-d", $date_start))."'"." and time<'".xtc_db_input(date("Y-m-d", $end))."'";
break;
}
// select leads
$hits_query = "SELECT count(*) as hits FROM ".TABLE_CAMPAIGNS_IP." WHERE campaign='".$this->campaign."'".$selection;
$hits_query = xtc_db_query($hits_query);
$hits_data = xtc_db_fetch_array($hits_query);
$this->result[$this->counterCMP]['result'][$this->counter]['hits'] = $hits_data['hits'];
if (array_key_exists('hits_s', $this->result[$this->counterCMP])) {
$this->result[$this->counterCMP]['hits_s'] += $hits_data['hits'];
} else {
$this->result[$this->counterCMP]['hits_s'] = $hits_data['hits'];
}
if ($this->total['leads'] == 0) {
$this->result[$this->counterCMP]['result'][$this->counter]['leads_p'] = 0;
} else {
$this->result[$this->counterCMP]['result'][$this->counter]['leads_p'] = ($lead_data['leads'] ?? null) / $this->total['leads'] * 100;
}
}
function getDateFormat($date_from, $date_to) {
if ($date_from != $date_to && $date_to != '') {
return date(DATE_FORMAT, $date_from).'-'.date(DATE_FORMAT, $date_to);
} else {
return date(DATE_FORMAT, $date_from);
}
}
function printResult() {
echo '<pre>';
print_r($this->result);
print_r($this->total);
echo '</pre>';
}
}
MainFactory::load_origin_class('campaigns');
Unexpected error occurred...
Class "main_ORIGIN" not found