PHP - MySQL Matematiksel Hesaplamalar

Selamlar,

Basit anlamda 2 satırlık bir 4 işlem kodu yazılması gerekiyor.

Yapılacak işlem ve açıklama,

[(SUM1 / 1,04 * PPCUR) + (SUM2 / 1,04 * USDCUR) ] + (SUM3 * USDCUR) + SUM4 = $TOTALITRY

$PROFIT = [[((SUM1 + VPSI) / 1,04) - ((SUM5 / PPCUR) + ((SUM6+SUM8) * 1,01) + (SUM7 * 1,01 / USDEURCUR))] * PPCUR] + (SUM2 / 1,04) + (SUM3 * USDCUR) + SUM4

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SUM1= <?PHP $query = mysql_query("SELECT SUM(income) FROM addserver where paymenttype='paypal'"); $ippusd = mysql_fetch_array($query); echo $ippusd['SUM(income)'];?>
SUM2= <?PHP $query = mysql_query("SELECT SUM(income) FROM addserver where paymenttype='webmoney'"); $iwmusd = mysql_fetch_array($query); echo $iwmusd['SUM(income)'];?>
SUM3= <?PHP $query = mysql_query("SELECT SUM(income) FROM addserver where paymenttype='bankwire' and icurrency='USD'"); $ibwusd = mysql_fetch_array($query); echo $ibwusd['SUM(income)'];?>
SUM4= <?PHP $query = mysql_query("SELECT SUM(income) FROM addserver where paymenttype='bankwire' and icurrency='TRY'"); $ibwtry = mysql_fetch_array($query); echo $ibwtry['SUM(income)'];?>
SUM5= <?PHP $query = mysql_query("SELECT SUM(expense) FROM addserver where location='tr-sh'"); $epptry = mysql_fetch_array($query); echo $disp['SUM(epptry)'];?>
SUM6= <?PHP $query = mysql_query("SELECT SUM(expense) FROM addserver where expensetype='payoneer' and ecurrency='USD'"); $epayusd = mysql_fetch_array($query); echo $disp['SUM(epayusd)'];?>
SUM7= <?PHP $query = mysql_query("SELECT SUM(expense) FROM addserver where expensetype='payoneer' and ecurrency='EUR'"); $epayeur = mysql_fetch_array($query); echo $disp['SUM(epayeur)'];?>
SUM8= <?php echo $yazdir["license"];?> 
SUM9= <?PHP $query = mysql_query("SELECT SUM(expense) FROM addserver where expensetype='bankwire' and ecurrency='TRY'"); $ebwtry = mysql_fetch_array($query); echo $disp['SUM(ebwtry)'];?>

USDCUR= <?php echo $yazdir["usd_currency"];?>  --> usd_currency FROM billing where billing_id=1
PPCUR= <?php echo $yazdir["paypal_currency"];?>  --> paypal_currency FROM billing where billing_id=1
USDEURCUR= <?php echo $yazdir["usd_eur_currency"];?>  --> usd_eur_currency FROM billing where billing_id=1
VPSI= <?php echo $yazdir["vpsincome"];?>  --> vpsincome FROM billing where billing_id=1

Ücret ve süreyi PM ile bildirebilirsiniz.

Şeref

Halloldu.