Чуть не свихнулся с этими скобками. Еще непонятно, можно их убирать или нет... В общем, обязательно тестировать и проверять это чудо. Но так оно хоть читаемо стало...
PHP:
скопировать код в буфер обмена
<?PHP function bFicator($string) { foreach ($array as $k => $v) { $array[$k] = 'b.' . $v; } } $transport = "b.transfer_charges+b.price_for_towing"; $transport_usa = "b.transfer_charges+b.inside_transport_usa"; $container_fee = "b.container_amount+b.load_fee+b.storeg_fee"; $risk_fee = "b.late_payment+b.other_service"; $road_fee = "$transport+$container_fee+$risk_fee"; $road_fee_usa = "$transport_usa+$container_fee+$risk_fee"; $insurance = "b.insurance_votes/100"; $amortization = "((b.auction_pay+b.services+$road_fee_usa)*$insurance)"; $b_tm = "b.transfer_money_"; $b_transfer_money = "{$b_tm}2_stage+{$b_tm}3_stage+{$b_tm}4_stage+{$b_tm}5_stage"; $pm = "pm_1+pm_2+pm_3+pm_4+pm_5"; $b_pm = bFicator($pm); $payment = "(b.diler+$road_fee+b.auction_real_pay)+$amortization"; $payment_usa = "b.diler+$road_fee_usa+b.auction_pay+$amortization"; $another_fee = "b.services+b.consolidation_fee"; $f2 = "(($payment_usa+$another_fee)-consolidation_fee)-(transfer_fee_1+$pm)"; $f13 = "(($payment_usa+$another_fee)-b.consolidation_fee)-(b.transfer_fee_1+$b_pm)"; $f12 = "(b.transfer_fee_1+$b_pm)-((b.auction_real_pay)+($b_transfer_money))"; $f7 = "($payment)-((b.auction_real_pay+b.transfer_charges)+($b_transfer_money))"; $f14 = "if($f2, $f12, ($f12-$f13)+$f7)"; $sql = "select $f14 as f14 from атата";
(Отредактировано автором: 09 Июля, 2013 - 16:49:34)
|