database_query($sSql);
$SETT = array();
while($aSetting = $database->database_fetch_assoc($rSql))
{
$SETT[$aSetting['setting_code']] = $aSetting['setting_value'];
}
switch ($task)
{
case "create":
$iColDays = intVal($_POST['col_days']);
$fPrice = floatVal($_POST['price']);
if($_POST['price'] == '')
$fPrice = -1;
$error_message = '';
if ($fPrice>=0 && $iColDays>0)
{
if($database->database_num_rows($database->database_query('SELECT true FROM `se_ats_tracking_price` WHERE col_days = '.$iColDays.' LIMIT 1'))>0)
{
$is_error = 1;
$error_message .= '

'.$admin_ats_tracking_prices['count_exists'].'
';
}else{
$database->database_query('INSERT INTO `se_ats_tracking_price` (col_days, price) VALUES ('.$iColDays.','.$fPrice.')');
}
}else{
$is_error = 1;
if ($fPrice<=0)
$error_message .= '
'.$admin_ats_tracking_prices['price_must_be_positive'].'
';
if ($iColDays<=0)
$error_message .= '
'.$admin_ats_tracking_prices['days_must_be_positive'].'
';
}
echo "";
exit();
case "edit":
$iColDays = intVal($_POST['col_days']);
$iPrice = floatVal($_POST['price']);
if (!$item_id)
{
exit();
}
if($iPrice>0 && $iColDays>0)
{
if($database->database_num_rows($database->database_query('SELECT true FROM `se_ats_tracking_price` WHERE col_days = '.$iPrice.' LIMIT 1'))>0)
{
$is_error = 1;
$error_message = $admin_ats_tracking_prices['count_exists'];
}else{
$database->database_query('UPDATE `se_ats_tracking_price` SET price = "'.$iPrice.'", col_days = "'.$iColDays.'" WHERE id = '.$item_id);
}
}else{
$is_error = 1;
$error_message = $admin_ats_tracking_prices['price_must_be_positive'];
}
echo "";
break;
case "delete":
if($item_id)
{
$database->database_query('DELETE FROM `se_ats_tracking_price` WHERE id = '.$item_id);
}
cheader($page.'.php');
break;
}
$rSql = $database->database_query('SELECT * FROM `se_ats_tracking_price` ORDER BY col_days, price');
$aItems = array();
while($aItem = $database->database_fetch_assoc($rSql))
{
$aItems[] = $aItem;
}
// **** PAYMENTS ****
$sSql = 'SELECT p.*,u.user FROM se_ats_tracking_payment AS p INNER JOIN se_users AS u USING(user_id) ORDER BY payment_to_date DESC ';
$rSql = $database->database_query($sSql);
$aPayment = array();
while($aPayments[] = $database->database_fetch_assoc($rSql));
$smarty->assign(
array(
'items' => $aItems,
'aPayments' => $aPayments,
'sCurrency' => $SETT['currency']
));
include "admin_footer.php";
?>