header("Location: " . _HTML_ROOT_PATH . "/?page=links");
}
exit;
break;
case 'add_category':
$category_name = $_REQUEST['category_name'];
$sql = "insert into tbl_links_categories_list (category_caption, category_type, status) values ('" . mysql_real_escape_string($category_name) . "', '', 0)";
mysql_query($sql);
$id = mysql_insert_id();
$sql = "update tbl_links_categories_list set category_name='category_" . mysql_real_escape_string($id) . "' where id='" . mysql_real_escape_string($id) . "'";
mysql_query($sql);
echo $id;
exit;
break;
case 'add_costs':
$timezone_shift = get_current_timezone_shift();
$date_range = explode(' - ', trim($_REQUEST['date_range']));
$date_start = $date_range[0];
$date_end = $date_range[1];
$source_name = $_REQUEST['source_name'];
$campaign_name = $_REQUEST['campaign_name'];
$ads_name = $_REQUEST['ads_name'];
$costs_value = trim(str_replace(',', '.', $_REQUEST['costs_value']));
$costs_value = convert_to_usd($_REQUEST['currency_code'], $costs_value);
if ($date_start == '' || $date_end == '' || $source_name == '' || $costs_value == '') {
exit;
}
$date_start = date2mysql($date_start);
$date_end = date2mysql($date_end);
$where = '';
if ($campaign_name != '') {
function get_sales($from, $to, $days, $month)
{
$timezone_shift = get_current_timezone_shift();
$sql = "SELECT *, `cnv`.`date_add` as `date` \n FROM `tbl_conversions` `cnv` \n LEFT JOIN `tbl_clicks` `clc` ON `cnv`.`subid` = `clc`.`subid` \n WHERE (`cnv`.`status` = 0 or `cnv`.`status` = 1)\n AND CONVERT_TZ(`cnv`.`date_add`, '+00:00', '" . _str($timezone_shift) . "') BETWEEN STR_TO_DATE('" . _str($from) . " 00:00:00', '%Y-%m-%d %H:%i:%s') \n AND STR_TO_DATE('" . _str($to) . " 23:59:59', '%Y-%m-%d %H:%i:%s') \n ORDER BY `cnv`.`date_add` ASC";
$r = mysql_query($sql);
if (mysql_num_rows($r) == 0) {
return false;
}
$data = array();
$return = array();
while ($f = mysql_fetch_assoc($r)) {
$data[] = $f;
}
foreach ($data as $row) {
if ($row['source_name'] == '') {
$row['source_name'] = '_';
}
foreach ($days as $day) {
$d = !$month ? date('d.m', strtotime($day)) : $day;
if ($d == date(!$month ? 'd.m' : 'm.Y', strtotime($row['date']))) {
$return[$row['source_name']][$d]++;
}
}
}
return $return;
}
function get_excel_report($date)
{
$timezone_shift = get_current_timezone_shift();
$sql = "select tbl_offers.offer_name, CONVERT_TZ(tbl_clicks.date_add, '+00:00', '" . _str($timezone_shift) . "') as date_add, tbl_clicks.user_ip, tbl_clicks.user_agent, tbl_clicks.user_os, tbl_clicks.user_platform, tbl_clicks.user_browser, tbl_clicks.country, tbl_clicks.subid, tbl_clicks.source_name, tbl_clicks.campaign_name, tbl_clicks.ads_name, tbl_clicks.referer, tbl_clicks.conversion_price_main from tbl_clicks left join tbl_offers on tbl_offers.id=tbl_clicks.out_id where CONVERT_TZ(tbl_clicks.date_add, '+00:00', '" . _str($timezone_shift) . "') BETWEEN '" . mysql_real_escape_string($date) . " 00:00:00' AND '" . mysql_real_escape_string($date) . " 23:59:59'";
$result = db_query($sql);
$arr_data = array();
while ($row = mysql_fetch_assoc($result)) {
$arr_data[] = $row;
}
return $arr_data;
}
