コード例 #1
0
    public function __construct($groupColumn, $mainTablePreffix, $mainTableColumn = null) {
        $this->groupColumn = $groupColumn;
        $this->mainTablePreffix = $mainTablePreffix;
        $this->mainTableColumn = $mainTableColumn;
        if (is_null($mainTableColumn)) {
            $this->mainTableColumn = $groupColumn;
        }

        // DB column names
        $raw = Pap_Db_Table_ClicksImpressions::RAW;
        $unique = Pap_Db_Table_ClicksImpressions::UNIQUE;
        $count = 'count';
        $commission = Pap_Db_Table_Transactions::COMMISSION;
        $totalCost = Pap_Db_Table_Transactions::TOTAL_COST;

        $this->statColumns[self::IMPRESSIONS_RAW] = "IF(im.$raw is NULL, 0, im.$raw)";
        $this->statColumns[self::IMPRESSIONS_UNIQUE] = "IF(im.$unique is NULL, 0, im.$unique)";

        $this->statColumns[self::CLICKS_RAW] = "IF(cl.$raw is NULL, 0, cl.$raw)";
        $this->statColumns[self::CLICKS_UNIQUE] = "IF(cl.$unique is NULL, 0, cl.$unique)";

        $this->statColumns[self::CTR_RAW] = "IF(im.$raw>0 AND cl.$raw>0, (cl.$raw/im.$raw)*100, 0)";
        $this->statColumns[self::CTR_UNIQUE] = "IF(im.$unique>0 AND cl.$unique>0, (cl.$unique/im.$unique)*100, 0)";

        $this->statColumns[self::SALES_COUNT] = "IF(tr.$count is NULL, 0, tr.$count)";
        $this->statColumns[self::SALES_TOTAL] = "IF(tr.$totalCost is NULL, 0, tr.$totalCost)";
        $this->statColumns[self::COMMISSIONS] = "IF(tr.$commission is NULL, 0, tr.$commission)";

        $this->statColumns[self::SCR_RAW] = "IF(cl.$raw>0 AND tr.$count>0, (tr.$count/cl.$raw)*100, 0)";
        $this->statColumns[self::SCR_UNIQUE] = "IF(cl.$unique>0 AND tr.$count>0, (tr.$count/cl.$unique)*100, 0)";

        $this->statColumns[self::AVG_COMMISSION_PER_CLICK] = "IF(cl.$raw>0 AND tr.$commission>0, tr.$commission/cl.$raw, 0)";
        $this->statColumns[self::AVG_COMMISSION_PER_IMP] = "IF(im.$raw>0 AND tr.$commission>0, tr.$commission/im.$raw, 0)";
        $this->statColumns[self::AVG_AMOUNT_OF_ORDER] = "IF(tr.$count>0 AND tr.$commission>0, tr.$commission/tr.$count, 0)";

        $context = new Pap_Common_StatsColumnsContext($this->statColumns);
        Gpf_Plugins_Engine::extensionPoint('PostAffiliate.Pap_Common_StatsGrid.initStatsColumns', $context);
        $this->statColumns = $context->getStatsColumns();

        $this->columnsToDatabaseNames[self::SALES_COUNT] = $count;
        $this->columnsToDatabaseNames[self::SALES_TOTAL] = $totalCost;
        $this->columnsToDatabaseNames[self::COMMISSIONS] = $commission;

        parent::__construct();
    }
コード例 #2
0
 function __construct() {
     parent::__construct();
     $this->userId = Gpf_Session::getAuthUser()->getPapUserId();
 }