<th>Нийт үрэлт</th> <th>Бэлэн байгаа</th> <th>Өр зээл</th> </tr> <?php $finance = new db_cn\Table("finance"); $party = new db_cn\Table("party"); $income = new db_cn\Table("income"); $outcome = new db_cn\Table("outcome"); $list = new db_cn\Table("financial_list"); $companies = new db_cn\Table("companies"); $result = $list->select("financeid,partyid,outcomeid,incomeid"); foreach ($result as $res) { $finance_res = $finance->selectFirst("debt,remaining", "id = " . $res['financeid']); $party_res = $party->selectFirst("title", "id = " . $res['partyid']); $outcome_res = $outcome->selectFirst("total", "id = " . $res['outcomeid']); $income_res = $income->selectFirst("total", "id = " . $res['incomeid']); echo "<tr>"; echo "<td>" . $party_res['title'] . "</td>"; echo "<td>\$" . $income_res['total'] . "</td>"; echo "<td>\$" . $outcome_res['total'] . "</td>"; echo "<td>\$" . $finance_res['remaining'] . "</td>"; echo "<td>\$" . $finance_res['debt'] . "</td>"; echo "</tr>"; } ?> </table> </div> </div> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="headingThree" data-toggle="collapse" data-target="#collapseThree" data-parent="#accordion" aria-expanded="true" aria-controls="collapseThree">
?> #eco">Бэлэн байгаа</a></th> <th><a href="economics.php?year=<?php echo $year; ?> #eco">Өр зээл</a></th> </tr> <?php $res = $finance->select("id"); $f_party_id = 0; for ($i = 0; $i < sizeof($res); $i++) { $inner_result = $party_finance_list->select("financeid,partyid,outcomeid,incomeid", "financeid = " . $res[$i]['id']); for ($in = 0; $in < sizeof($inner_result); $in++) { $finance_res = $finance->selectFirst("year,month,day,debt,remaining", "id = " . $inner_result[$in]['financeid']); $party_res = $party->selectFirst("id, title, acronym", "id = " . $inner_result[$in]['partyid']); $outcome_res = $outcome->selectFirst("id, total", "id = " . $inner_result[$in]['outcomeid']); $income_res = $income->selectFirst("id, total", "id = " . $inner_result[$in]['incomeid']); $total_income = $income_res['total']; $total_outcome = $outcome_res['total']; $total_rem = $finance_res['remaining']; $total_debt = $finance_res['debt']; $fi_id = $inner_result[$in]['financeid']; if ($fi_id == 18) { $total_income = 14471847.1; $total_outcome = 14252447; $total_rem = 219400.1; $total_debt = 9960; } else { if ($fi_id == 20) { $total_income = 1293467.4; $total_outcome = 1289953.8;