관리-도구

편집 파일: optin_control.php

<?php
class Optincontrol
{
	var $mysqli;
	var $dbpref;
	var $load;
	function __construct($arr)
	{
		$this->mysqli = $arr['mysqli'];
		$this->dbpref = $arr['dbpref'];
		$this->load = $arr['load'];
	}
	function getOptionForSpecifcPagesforZapier()
	{
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$table = $pref . "quick_optins";
		$qry = $mysqli->query("select `a`.id,`a`.name,`a`.email,`a`.extras,`a`.ipaddr,(select `valid_inputs` from `" . $pref . "quick_pagefunnel` where `id`=`a`.pageid) as `zap_valid_inputs` from `" . $table . "` as `a` where `pageid` in (select `id` from `" . $pref . "quick_pagefunnel` where `settings` like '%\"zapier_enable\":true%') and `send_zap` not in('1') limit 100");
		$token = get_option('site_token');
		$arr = array();
		while ($r = $qry->fetch_assoc()) {
			$r['id'] += 125;
			$r['id'] = hash_hmac('sha1', $r['id'], $token);
			$valid_inputs = explode(",", $r['zap_valid_inputs']);
			$extras = (array)json_decode($r['extras']);

$data_arr = array('id' => $r['id']);
			foreach ($valid_inputs as $valid_input) {
				if (in_array($valid_input, array('name', 'email'))) {
					$data_arr[$valid_input] = $r[$valid_input];
				} elseif (isset($extras[$valid_input])) {
					$data_arr[$valid_input] = $extras[$valid_input];
				}
			}

array_push($arr, json_encode($data_arr));
		}
		$up = $mysqli->query("update `" . $table . "` set `send_zap`='1' where `pageid` in (select `id` from `" . $pref . "quick_pagefunnel` where `settings` like '%\"zapier_enable\":true%') and `send_zap` not in('1') limit 100");

return "[" . implode(",", $arr) . "]";
	}
	function visualOptisForFunnels($funnel_id = 'all', $pagecount = 0)
	{
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$table = $pref . "quick_optins";

$limit = get_option('qfnl_max_records_per_page');

$funnel_id = $mysqli->real_escape_string($funnel_id);
		$pagecount = $mysqli->real_escape_string($pagecount);

$tempdatebetween_arr = dateBetween('addedon');
		$datebetween = $tempdatebetween_arr[1];
		$datebetween_all = $tempdatebetween_arr[0];

$countsql = "select count(`id`) as `totaloptins` from `" . $table . "`" . $datebetween_all;
		$baseurl = "";
		$extrafields = 0;
		$total = 0;
		if (is_numeric($funnel_id) || strpos($funnel_id, "page@") === 0) {
			$pageidqry = "";
			if (strpos($funnel_id, "page@") === 0) {
				$pageidd = str_replace("page@", "", $funnel_id);
				$pageidd = explode('@', $mysqli->real_escape_string($pageidd));

$pageid = $pageidd[1];
				$funnel_id = $pageidd[0];

if (!is_numeric($pageid)) {
					$pagefunnelquery = $mysqli->query("select `id` from `" . $pref . "quick_pagefunnel` where `funnelid`='" . $funnel_id . "' and `filename`='" . $pageid . "'");
					if ($pagefunnelquery->num_rows > 0) {
						$pageidarrr = array();
						while ($fidobb = $pagefunnelquery->fetch_object()) {
							array_push($pageidarrr, "'" . $fidobb->id . "'");
						}
						$pageidqry = ' and `pageid` in (' . implode(',', $pageidarrr) . ') ';
					} else {
						return 0;
					}
				} else {
					$pageidqry = " and `pageid`='" . $pageid . "'";
				}
			}
		} else {
			return 0;
		}

$countsql = "select count(`id`) as totaloptins from `" . $table . "` where funnelid='" . $funnel_id . "'" . $pageidqry . $datebetween;

$total_qry = $mysqli->query($countsql);
		if ($total_qry) {
			if ($res = $total_qry->fetch_object()) {
				$total = $res->totaloptins;
			}
		}

$order_by = "`id` desc";
		if (isset($_GET['arrange_records_order'])) {
			$order_by = base64_decode($_GET['arrange_records_order']);
		}

$search_qry = "";
		if (isset($_POST["onpage_search"]) && strlen($_POST["onpage_search"]) > 0) {
			$_POST["onpage_search"] = $mysqli->real_escape_string($_POST["onpage_search"]);
			$search_qry = " and (`name` like '%" . $_POST["onpage_search"] . "%' or `email` like '%" . $_POST["onpage_search"] . "%' or `extras` like '%:\"%" . $_POST["onpage_search"] . "%\"%' or `ipaddr` like '%" . $_POST["onpage_search"] . "%')";
		}
		if ($pagecount == 0) {
			$sql = "select * from `" . $table . "` where funnelid='" . $funnel_id . "'" . $pageidqry . $datebetween . $search_qry . " order by " . $order_by . " limit " . $limit . "";
		} else {
			$pagecount = ($pagecount * $limit) - $limit;
			$sql = "select * from `" . $table . "` where funnelid='" . $funnel_id . "'" . $pageidqry . $datebetween . $search_qry . " order by " . $order_by . " limit " . $pagecount . ", " . $limit . "";
		}
		$funnel = $this->load->loadFunnel();
		$funnel_data = $funnel->getFunnel($funnel_id);
		$extrafields = $funnel_data->validinputs;
		$baseurl = $funnel_data->baseurl;
		if (strlen($pageidqry) > 1) {
			if (is_numeric($pageid)) {
				$pagevalidinputsquery = $mysqli->query("select `valid_inputs` from `" . $pref . "quick_pagefunnel` where `id`=" . $pageid . " limit 1");
			} else {
				$pagevalidinputsquery = $mysqli->query("select `valid_inputs` from `" . $pref . "quick_pagefunnel` where `funnelid`='" . $funnel_id . "' and `filename`='" . $pageid . "' limit 1");
			}

if ($pagevalidinputsquery->num_rows > 0) {
				$pagevalidinputsquery_ob = $pagevalidinputsquery->fetch_object();
				if (strlen($pagevalidinputsquery_ob->valid_inputs) > 0) {
					$extrafields =	$pagevalidinputsquery_ob->valid_inputs;
				}
			}
		}
		if (strlen($extrafields) > 0) {
			$extrafields = explode(',', $extrafields);
		} else {
			$extrafields = 0;
		}

$qry = $mysqli->query($sql);
		return array('leads' => $qry, 'total' => $total, 'extracols' => $extrafields, 'base_url' => $baseurl);
	}

$funnelid = $mysqli->real_escape_string($funnelid);
		$pageid = $mysqli->real_escape_string($pageid);

if (is_numeric($pageid)) {
			$getpagedataqry = $mysqli->query("select `valid_inputs`,`id`,`filename` from `" . $page_table . "` where `level` in(select `level` from `" . $page_table . "` where `id`='" . $pageid . "') and `funnelid`='" . $funnelid . "'");
		} else {
			$getpagedataqry = $mysqli->query("select `valid_inputs`,`id`,`filename` from `" . $page_table . "` where `funnelid`='" . $funnelid . "' and `filename`='" . $pageid . "'");
		}

if ($getpagedataqry->num_rows) {
			while ($r = $getpagedataqry->fetch_object()) {
				array_push($ids, "'" . $r->id . "'");
				$input_fields = $r->valid_inputs;
				$filename = $r->filename;
			}
		}

if (strlen($input_fields) < 1) {
			$getfetfunnel = $funnel_ob->getFunnel($funnelid);
			if ($getfetfunnel) {
				$input_fields = $getfetfunnel->validinputs;
			}
		}
		$input_fields = explode(",", $input_fields);

$optinqry = $mysqli->query("select * from `" . $table . "` where `funnelid`='" . $funnelid . "' and `pageid` in (" . implode(',', $ids) . ")");

//headers
		$csvheaders = array("#");
		$csvheaders = array_merge($csvheaders, $input_fields, array('ip', 'date'));

$output_filename = $filename . '.csv';
		$output_handle = @fopen('php://output', 'w');

header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
		header('Content-Description: File Transfer');
		header('Content-type: text/csv');
		header('Content-Disposition: attachment; filename=' . $output_filename);
		header('Expires: 0');
		header('Pragma: public');
		fputcsv($output_handle, $csvheaders);

if ($optinqry->num_rows > 0) {
			$count = 0;
			while ($r = $optinqry->fetch_assoc()) {
				++$count;
				$outputarr = array($count);
				$exfarr = (array)json_decode($r['extras']);

if (isset($r['addedon'])) {
					$r['addedon'] = date('d-M-Y h:ia', $r['addedon']);
				}

for ($i = 1; $i < count($csvheaders); $i++) {
					if ($csvheaders[$i] == "ip") {
						$csvheaders[$i] = "ipaddr";
					}
					if ($csvheaders[$i] == "date") {
						$csvheaders[$i] = "addedon";
					}

if (isset($r[$csvheaders[$i]])) {
						array_push($outputarr, $r[$csvheaders[$i]]);
					} elseif (isset($exfarr[$csvheaders[$i]])) {
						array_push($outputarr, $exfarr[$csvheaders[$i]]);
					} else {
						array_push($outputarr, "");
					}
				}
				fputcsv($output_handle, $outputarr);
			}
		}

fclose($output_handle);
		die();
	}
}