getConnection();
} catch (Exception $e) {
self::$db = false;
}
$this->mysql['user_id'] = self::$db->real_escape_string($_SESSION['user_id']);
// make sure mysql uses the timezone choses by the user
}
function getFilterNames($column_name, $filter_id, $echo = true)
{
$selectDropdown = "";
if ($echo)
echo $selectDropdown;
return $selectDropdown;
}
function getFilter($filter, $filter_id)
{
$sql = "SELECT $filter from 202_filters where id = $filter_id";
$result = _mysqli_query($sql);
if ($result)
$row = $result->fetch_assoc();
$value = '';
if ($row)
$value = $row[$filter];
if(is_numeric($value)){
$split = explode('.', $value);
if($split[1]=='00000')
return number_format($value,0);
else
return number_format($value,2);
}
return $value;
}
function getFilterCheck($val, $filter_id)
{
if (self::getFilter('filter_name', $filter_id) == '' || self::getFilter('filter_condition', $filter_id) == '' || self::getFilter('filter_value', $filter_id) == '')
return true;
switch (self::getFilter('filter_name', $filter_id)) {
case "S/U":
$val=number_format($val*100,2, '.', '');
$percenter = 1;
break;
case "LP CTR":
case "ROI":
$val=number_format($val,0, '.', '');
$percenter = 1;
break;
default:
$percenter = 1;
}
switch (self::getFilter('filter_condition', $filter_id)) {
case "<":
if ($val < self::getFilter('filter_value', $filter_id))
return true;
else
return false;
break;
case ">":
if ($val > self::getFilter('filter_value', $filter_id))
return true;
else
return false;
break;
case "=":
if ($val == (self::getFilter('filter_value', $filter_id))){
return true;}
else
return false;
break;
case ">=":
if ($val >= self::getFilter('filter_value', $filter_id))
return true;
else
return false;
break;
case "<=":
if ($val <= self::getFilter('filter_value', $filter_id))
return true;
else
return false;
break;
case "!=":
if ($val != self::getFilter('filter_value', $filter_id)){
echo self::getFilter('filter_value', $filter_id);
return true;}
else
return false;
break;
}
}
function getFilterNameMapping($filter_id)
{
$filterNameMapping = array(
"Clicks" => "getClicks",
"Click Throughs" => "getClickOut",
"LP CTR" => "getCtr",
"Leads" => "getLeads",
"S/U" => "getSu",
"Payout" => "getPayout",
"EPC" => "getEpc",
"CPC" => "getCpc",
"eCPA" => "getEcpa",
"Income" => "getIncome",
"Cost" => "getCost",
"Net" => "getNet",
"ROI" => "getRoi"
);
return $filterNameMapping[self::getFilter('filter_name', $filter_id)];
}
function setFilter($filter_name, $filter_condition, $filter_value, $filter_id)
{
if (($filter_name!='') && ($filter_condition!='') && ($filter_value!='') && ($filter_id!='')) {
$sql = "INSERT INTO 202_filters values ($filter_id,'$filter_name','$filter_condition',$filter_value) ON DUPLICATE KEY UPDATE filter_name='$filter_name',filter_condition='$filter_condition',filter_value=$filter_value";
echo $sql."
";
$result = _mysqli_query($sql);
} else {
$sql = "INSERT INTO 202_filters values ($filter_id,'','',NULL) ON DUPLICATE KEY UPDATE filter_name='',filter_condition='',filter_value=NULL";
echo $sql."
";
$result = _mysqli_query($sql);
}
}
}