示例#1
0
文件: basefun.php 项目: qquk/IBAG
function generateListTree(&$rec, &$aux, $parent_id, $sesdiv)
{
    $sql = "SELECT * FROM articles WHERE";
    if ($sesdiv) {
        $sql .= " div_id='" . $sesdiv . "' AND";
    }
    $sql .= " parent_id='" . $parent_id . "' ORDER BY artname COLLATE latin1_general_ci";
    $res = mysql_query($sql) or die("<script>alert('ОШИБКА ЗАПРОСА 1');</script>");
    while ($row = mysql_fetch_array($res)) {
        $rec .= "Tree[" . $aux . "] = \"" . $row['art_id'] . "|" . $row['parent_id'] . "|" . $row['artname'] . "|" . $row['div_id'] . "\";\n";
        $aux++;
        generateListTree($rec, $aux, $row['art_id']);
    }
    return $rec;
}
示例#2
0
文件: basefun.php 项目: qquk/IBAG
function generateListTree(&$rec, &$aux, $parent_id)
{
    $sql = "SELECT * FROM articles WHERE div_id='" . $_SESSION['div'] . "' AND parent_id='" . $parent_id . "' ORDER BY artname COLLATE latin1_general_ci";
    $res = mysql_query($sql) or die("<script>alert('ОШИБКА ЗАПРОСА 1');</script>");
    while ($row = mysql_fetch_array($res)) {
        $sql_child = "SELECT parent_id FROM articles WHERE parent_id='" . $row['art_id'] . "'";
        $res_child = mysql_query($sql_child);
        $num_child = mysql_num_rows($res_child);
        if (!$num_child) {
            $rec .= "Tree[" . $aux . "] = \"" . $row['art_id'] . "|" . $row['parent_id'] . "|" . $row['artname'] . "|" . $row['div_id'] . "\";\n";
            $aux++;
        } else {
            $rec .= "Tree[" . $aux . "] = \"" . $row['art_id'] . "|" . $row['parent_id'] . "|" . $row['artname'] . "|" . $row['div_id'] . "\";\n";
            $aux++;
            generateListTree($rec, $aux, $row['art_id']);
        }
    }
    return $rec;
}
示例#3
0
文件: main.php 项目: qquk/IBAG
      </TD>
    </TR>
  </TABLE>"; */
echo "<TABLE border='0'><TR><TD>" . "<TABLE style='border-collapse:collapse'><TR>" . "<TD class='doc_off' id='new_inTD' onMouseOver='changeOn(0,\"new_inTD\",\"doc\")' onMouseOut='changeOn(1,\"new_inTD\",\"doc\")' onClick='open_form(\"new_inout.php\",\"CreateNewIN\",350)' disabled>" . "<TABLE border='0'>" . "<TR>" . "<TD><img src='images/sender.gif'></TD>" . "<TD valign=top style='color:#000000;font-family:Tahoma;font-size:8pt;font-weight:normal'>Новый</TD>" . "</TR>" . "<TR><TD colspan='2' align='right' valign=top style='color:#999999;font-family:Tahoma;font-size:7pt;font-weight:normal'>приход</TD></TR>" . "</TABLE>" . "</TD>" . "<TD width='10'></TD>" . "<TD class='doc_off' id='new_outTD' onMouseOver='changeOn(0,\"new_outTD\",\"doc\")' onMouseOut='changeOn(1,\"new_outTD\",\"doc\")' onClick='open_form(\"new_inout.php\",\"CreateNewOUT\",350)' disabled>" . "<TABLE border='0'>" . "<TR>" . "<TD><img src='images/payee.gif'></TD>" . "<TD valign=top style='color:#000000;font-family:Tahoma;font-size:8pt;font-weight:normal'>Новый</TD>" . "</TR>" . "<TR><TD colspan='2' align='right' valign=top style='color:#999999;font-family:Tahoma;font-size:7pt;font-weight:normal'>расход</TD></TR>" . "</TABLE>" . "</TD>" . "<TD width='10'></TD>" . "<TD class='doc_off' id='new_groupTD' onMouseOver='changeOn(0,\"new_groupTD\",\"doc\")' onMouseOut='changeOn(1,\"new_groupTD\",\"doc\")' onClick='open_form(\"new_group.php\",\"addNewGroup\",200)' disabled>" . "<TABLE border='0'>" . "<TR>" . "<TD><img src='oper/balance/img/io_add_group_plus.gif'></TD>" . "<TD valign=top style='color:#000000;font-family:Tahoma;font-size:8pt;font-weight:normal'>Добавить</TD>" . "</TR>" . "<TR><TD colspan='2' align='right' valign=top style='color:#999999;font-family:Tahoma;font-size:7pt;font-weight:normal'>группу</TD></TR>" . "</TABLE>" . "</TD>" . "<TD width='10'></TD>" . "<TD class='doc_off' id='delartTD' onMouseOver='changeOn(0,\"delartTD\",\"doc\")' onMouseOut='changeOn(1,\"delartTD\",\"doc\")' onClick='delArt(document.wsform.art_id.value)' disabled>" . "<TABLE border='0'>" . "<TR>" . "<TD><img src='oper/balance/img/del.gif'></TD>" . "<TD valign=top style='color:#000000;font-family:Tahoma;font-size:8pt;font-weight:normal'>Удалить</TD>" . "</TR>" . "<TR><TD colspan='2' align='right' valign=top style='color:#999999;font-family:Tahoma;font-size:7pt;font-weight:normal'>статью</TD></TR>" . "</TABLE>" . "</TD>" . "<TD width='10'></TD>" . "<TD class='doc_off' id='printTD' onMouseOver='changeOn(0,\"printTD\",\"doc\")' onMouseOut='changeOn(1,\"printTD\",\"doc\")' onClick='print_doc(document.wsform.art_id.value)' disabled>" . "<TABLE border='0'>" . "<TR>" . "<TD><img src='oper/balance/img/print.gif'></TD>" . "<TD valign=top style='color:#000000;font-family:Tahoma;font-size:8pt;font-weight:normal'>Печать</TD>" . "</TR>" . "<TR><TD colspan='2' align='right' valign=top style='color:#999999;font-family:Tahoma;font-size:7pt;font-weight:normal'>результата</TD></TR>" . "</TABLE>" . "</TD>" . "<TD width='10'></TD>" . "<TD class='doc_off' id='viewExcel' onMouseOver='changeOn(0,\"viewExcel\",\"doc\")' onMouseOut='changeOn(1,\"viewExcel\",\"doc\")' onClick='exportToExcel(document.wsform.art_id.value)' disabled>" . "<TABLE border='0'>" . "<TR>" . "<TD><img src='oper/balance/img/excel1.gif'></TD>" . "<TD valign=top style='color:#000000;font-family:Tahoma;font-size:8pt;font-weight:normal'>Вывод</TD>" . "</TR>" . "<TR><TD colspan='2' align='right' valign=top style='color:#999999;font-family:Tahoma;font-size:7pt;font-weight:normal'>в Excel</TD></TR>" . "</TABLE>" . "</TD>" . "</TR></TABLE>" . "</TD></TR></TABLE>";
echo "</TD>\n     <TD>\n       <TABLE border='0' width='100%' height='100%' cellpadding='0' cellspacing='0' class='cap2'>\n         <TR>\n           <TD>\n             <TABLE border='0'  cellpadding='0' cellspacing='3'>\n               <TR>";
/*echo"  <TD><input type='button' value='Установить Дату' class='but_on'>
  </TD>";*/
echo "<TD>\n                   <TABLE border='0'  cellpadding='0' cellspacing='3'>\n                     <TR>\n                       <TD width='20'style='font-size:10pt;color:maroon'>С:\n                       </TD>\n                       <TD><input name='date_first' id='date_first' type='text' class='date_give' value='" . date("d.m.Y", $firstday) . "' onKeyPress='return false'>\n                       </TD>\n                       <TD><button onClick=\"show_calendar('calendar',getX(this),getY(this),1)\" class='calend'><img src='images/calendar.gif' border=0></button>\n                       </TD>\n                     </TR>\n                   </TABLE>\n                   <TABLE border='0'  cellpadding='0' cellspacing='3'>\n                     <TR>\n                       <TD style='font-size:10pt;color:maroon'>По:\n                       </TD>\n                       <TD><input name='date_last' id='date_last' type='text' class='date_give' value='" . date("d.m.Y", $lastday) . "' onKeyPress='return false'>\n                       </TD>\n                       <TD><button onClick=\"show_calendar('calendar',getX(this),getY(this),2)\" class='calend'><img src='images/calendar.gif' border=0></button>\n                       </TD>\n                     </TR>\n                   </TABLE>\n                 </TD>\n               </TR>\n             </TABLE>\n           </TD>\n         </TR>\n       </TABLE>\n      </TD>\n   </TR>\n</TABLE>";
/***************************************************************************************************************************************************/
/*****************************Основная Таблица*****************************************************************************************************/
echo "<TABLE width='100%' height='100%' border='0' cellpadding='0' cellspacing='1' onClick='cls1_calendar(\"calendar\")'>\n   <TR>\n     <TD valign='top' width='20%'>\n       <TABLE border='0' width='100%' height='100%' cellpadding='0' cellspacing='0' class='let_list_data'>\n         <TR>\n           <TD valign='top'>";
require "oper/balance/js/tree.js";
echo "<div class=\"tree\">\n<script type=\"text/javascript\">\n<!--\n";
echo "var Tree = new Array;\n";
require "oper/balance/basefun.php";
echo generateListTree($rec = '', $aux = 0, 0);
echo "createTree(Tree," . nullParentTree() . ");";
echo "\n//-->\n</script>\n</div>";
echo "\n          </TD>\n         </TR>\n       </TABLE>\n\t</TD>\n\t<TD valign='top'>";
/*	    echo"<TABLE border='0' width='100%' height='10%' cellpadding='0' cellspacing='0' class='cap2'>
        <TR>
          <TD valign='top'>123
          </TD>
        </TR>
       </TABLE>"; */
echo "<TABLE border='3' width='100%' height='100%' cellpadding='0' cellspacing='0' class='let_list_data'>\n         <TR>\n           <TD valign='top'>";
echo "<table width='99%' border='0' cellpadding='1' cellspacing='1' style='margin-left:5;margin-right:5'>" . "<tr>" . "<td align='center' width='20%'>" . "<table  border='0' cellpadding='1' cellspacing='1' width=100%>" . "<tr><td colspan='2' align='left' style='color:maroon;font-family:Arial;font-size:10pt;cursor:hand' onClick=\"prevRemain('" . $_SESSION['div'] . "')\" class='prevremain_off' onMouseOver=\"this.className='prevremain_on'\" onMouseOut=\"this.className='prevremain_off'\">Предыдущий остаток</td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left width='10%'><b>USD:</b></td><td align=left>  <b><div id='prev_usd'>&nbsp;</div></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left><b>Грн:</b></td><td align=left>  <b><div id='prev_grn'>&nbsp;</div></b></td></tr>" . "</table>" . "</td>" . "<td align='center' width='20%'>" . "<table  border='0' cellpadding='1' cellspacing='1' width=100%>" . "<tr><td colspan='2' align='left' style='color:#555555;font-family:Arial;font-size:10pt;cursor:hand'><b><u>Приход за период</u></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left width='10%'><b>USD:</b></td><td align=left>  <b><div id='in_usd'>&nbsp;</div></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left><b>Грн:</b></td><td align=left>  <b><div id='in_grn'>&nbsp;</div></b></td></tr>" . "</table>" . "</td>" . "<td align='center' width='20%'>" . "<table  border='0' cellpadding='1' cellspacing='1' width=100%>" . "<tr><td colspan='2' align='left' style='color:#555555;font-family:Arial;font-size:10pt;cursor:hand'><b><u>Расход за период</u></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left width='10%'><b>USD:</b></td><td align=left>  <b><div id='out_usd'>&nbsp;</div></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left><b>Грн:</b></td><td align=left>  <b><div id='out_grn'>&nbsp;</div></b></td></tr>" . "</table>" . "</td>" . "<td align='center' width='20%'>" . "<table  border='0' cellpadding='1' cellspacing='1' width=100%>" . "<tr><td colspan='2' align='left' style='color:#555555;font-family:Arial;font-size:10pt;cursor:hand'><b><u>Итого за период</u></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left width='10%'><b>USD:</b></td><td align=left>  <b><div id='total_usd'>&nbsp;</div></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left><b>Грн:</b></td><td align=left>  <b><div id='total_grn'>&nbsp;</div></b></td></tr>" . "</table>" . "</td>" . "<td align='center' width='19%'>" . "<table  border='0' cellpadding='1' cellspacing='1' width=100%>" . "<tr><td colspan='2' align='left' style='color:#555555;font-family:Arial;font-size:10pt;cursor:hand'><b><u>Касса</u></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left width='10%'><b>USD:</b></td><td align=left>  <b><div id='cash_usd'>&nbsp;</div></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left><b>Грн:</b></td><td align=left>  <b><div id='cash_grn'>&nbsp;</div></b></td></tr>" . "</table>" . "</td>" . "</tr>" . "</table>";
echo "<table id='ttab' border='0' cellpadding='0' cellspacing='1' style='margin-left:5'>" . "<tr id='ttRows' height='22' align='center' style='color:white;font-family:Tahoma;font-size:14px'>" . "<td>Дата</td>" . "<td>От кого/Кому</td>" . "<td>Сумма, \$</td>" . "<td>Сумма, грн</td>" . "<td>Примечание</td>" . "<td>Удаление</td>" . "</tr></table>";
echo "<IFRAME width='100%' height='68%' name='outputData' id='outputData' scrolling='yes' frameborder='0' marginheight='0' marginwidth='0'>\n             </IFRAME>\n           </TD>\n         </TR>\n        </TABLE>\n\t</TD>\n   </TR>\n</TABLE>";
/***************************************************************************************************************************************************/
?>
示例#4
0
文件: main_total.php 项目: qquk/IBAG
  </TABLE>"; */
echo "<TABLE border='0'><TR><TD>" . "<TABLE style='border-collapse:collapse'><TR>" . "<TD class='doc_off' id='new_inTD' onMouseOver='changeOn(0,\"new_inTD\",\"doc\")' onMouseOut='changeOn(1,\"new_inTD\",\"doc\")' onClick='open_form(\"new_inout.php\",\"CreateNewIN\",350)' disabled>" . "<TABLE border='0'>" . "<TR>" . "<TD><img src='images/sender.gif'></TD>" . "<TD valign=top style='color:#000000;font-family:Tahoma;font-size:8pt;font-weight:normal'>Новый</TD>" . "</TR>" . "<TR><TD colspan='2' align='right' valign=top style='color:#999999;font-family:Tahoma;font-size:7pt;font-weight:normal'>приход</TD></TR>" . "</TABLE>" . "</TD>" . "<TD width='10'></TD>" . "<TD class='doc_off' id='new_outTD' onMouseOver='changeOn(0,\"new_outTD\",\"doc\")' onMouseOut='changeOn(1,\"new_outTD\",\"doc\")' onClick='open_form(\"new_inout.php\",\"CreateNewOUT\",350)' disabled>" . "<TABLE border='0'>" . "<TR>" . "<TD><img src='images/payee.gif'></TD>" . "<TD valign=top style='color:#000000;font-family:Tahoma;font-size:8pt;font-weight:normal'>Новый</TD>" . "</TR>" . "<TR><TD colspan='2' align='right' valign=top style='color:#999999;font-family:Tahoma;font-size:7pt;font-weight:normal'>расход</TD></TR>" . "</TABLE>" . "</TD>" . "<TD width='10'></TD>" . "<TD class='doc_off' id='new_groupTD' onMouseOver='changeOn(0,\"new_groupTD\",\"doc\")' onMouseOut='changeOn(1,\"new_groupTD\",\"doc\")' onClick='open_form(\"new_group_total.php\",\"addNewGroup\",200)' disabled>" . "<TABLE border='0'>" . "<TR>" . "<TD><img src='oper/balance/img/io_add_group_plus.gif'></TD>" . "<TD valign=top style='color:#000000;font-family:Tahoma;font-size:8pt;font-weight:normal'>Добавить</TD>" . "</TR>" . "<TR><TD colspan='2' align='right' valign=top style='color:#999999;font-family:Tahoma;font-size:7pt;font-weight:normal'>группу</TD></TR>" . "</TABLE>" . "</TD>" . "<TD width='10'></TD>" . "<TD class='doc_off' id='delartTD' onMouseOver='changeOn(0,\"delartTD\",\"doc\")' onMouseOut='changeOn(1,\"delartTD\",\"doc\")' onClick='delArt(document.wsform.art_id.value)' disabled>" . "<TABLE border='0'>" . "<TR>" . "<TD><img src='oper/balance/img/del.gif'></TD>" . "<TD valign=top style='color:#000000;font-family:Tahoma;font-size:8pt;font-weight:normal'>Удалить</TD>" . "</TR>" . "<TR><TD colspan='2' align='right' valign=top style='color:#999999;font-family:Tahoma;font-size:7pt;font-weight:normal'>статью</TD></TR>" . "</TABLE>" . "</TD>" . "<TD width='10'></TD>" . "<TD class='doc_off' id='printTD' onMouseOver='changeOn(0,\"printTD\",\"doc\")' onMouseOut='changeOn(1,\"printTD\",\"doc\")' onClick='print_doc(document.wsform.art_id.value)' disabled>" . "<TABLE border='0'>" . "<TR>" . "<TD><img src='oper/balance/img/print.gif'></TD>" . "<TD valign=top style='color:#000000;font-family:Tahoma;font-size:8pt;font-weight:normal'>Печать</TD>" . "</TR>" . "<TR><TD colspan='2' align='right' valign=top style='color:#999999;font-family:Tahoma;font-size:7pt;font-weight:normal'>результата</TD></TR>" . "</TABLE>" . "</TD>" . "<TD width='10'></TD>" . "<TD class='doc_off' id='viewExcel' onMouseOver='changeOn(0,\"viewExcel\",\"doc\")' onMouseOut='changeOn(1,\"viewExcel\",\"doc\")' onClick='exportToExcel(document.wsform.art_id.value)' disabled>" . "<TABLE border='0'>" . "<TR>" . "<TD><img src='oper/balance/img/excel1.gif'></TD>" . "<TD valign=top style='color:#000000;font-family:Tahoma;font-size:8pt;font-weight:normal'>Вывод</TD>" . "</TR>" . "<TR><TD colspan='2' align='right' valign=top style='color:#999999;font-family:Tahoma;font-size:7pt;font-weight:normal'>в Excel</TD></TR>" . "</TABLE>" . "</TD>" . "</TR></TABLE>" . "</TD></TR></TABLE>";
echo "</TD>\n     <TD width='15%'>\n       <TABLE border='0' width='100%' height='100%' cellpadding='0' cellspacing='0' class='cap2'>\n         <TR>\n           <TD>\n             <TABLE border='0'  cellpadding='0' cellspacing='3'>\n               <TR>";
/*echo"  <TD><input type='button' value='Установить Дату' class='but_on'>
  </TD>";*/
echo "<TD>\n                   <TABLE border='0'  cellpadding='0' cellspacing='3'>\n                     <TR>\n                       <TD width='20'style='font-size:10pt;color:maroon'>С:\n                       </TD>\n                       <TD><input name='date_first' id='date_first' type='text' class='date_give' value='" . date("d.m.Y", $firstday) . "' onKeyPress='return false'>\n                       </TD>\n                       <TD><button onClick=\"show_calendar('calendar',getX(this),getY(this),1)\" class='calend'><img src='images/calendar.gif' border=0></button>\n                       </TD>\n                     </TR>\n                   </TABLE>\n                   <TABLE border='0'  cellpadding='0' cellspacing='3'>\n                     <TR>\n                       <TD style='font-size:10pt;color:maroon'>По:\n                       </TD>\n                       <TD><input name='date_last' id='date_last' type='text' class='date_give' value='" . date("d.m.Y", $lastday) . "' onKeyPress='return false'>\n                       </TD>\n                       <TD><button onClick=\"show_calendar('calendar',getX(this),getY(this),2)\" class='calend'><img src='images/calendar.gif' border=0></button>\n                       </TD>\n                     </TR>\n                   </TABLE>\n                 </TD>\n               </TR>\n             </TABLE>\n           </TD>\n         </TR>\n       </TABLE>\n      </TD>\n      <TD valign='top'>\n      \t<TABLE border='0' width='100%' height='100%' cellpadding='0' cellspacing='0' class='cap2'>\n         <TR>\n           <TD valign='top'>";
echo "<TABLE valign='top' border='1'  cellpadding='0' cellspacing='0'>" . "<TR>" . "<TD style='background-color: #CECCBF'>" . "<TABLE width='100%' border='0' cellpadding='0' cellspacing='1'>" . "<TR>" . "<TD style='font-weight:bold' class='main_oper_list_cap'>Поиск по полю От кого/Кому" . "</TD>" . "</TR>" . "<TR>" . "<TD style='font-weight:bold'>" . "<input name='fromto' type='text' size='30' maxlength='30' class='textfield_search_art'>" . "<button class='search_btn' onClick='searchAndLocateInToFrame(this.previousSibling.value)' onmouseover=show('text2',getX(this),getY(this)) onmouseout=cls('text2');><img src='images/search.gif'></button><br>" . "</TD>" . "</TR>" . "</TABLE>" . "</TD>" . "</TR>" . "</TABLE>";
echo " </TD>\n         </TR>\n         <TR>\n         \t<TD><input name='ifdate' type='checkbox' value='ON' checked><span onClick='isChecked(this)' style='cursor:hand'>Использовать дату при поиске</span>\n         \t</TD>\n         </TR>\n       </TABLE>\n      </TD>\n   </TR>\n</TABLE>";
/***************************************************************************************************************************************************/
/*****************************Основная Таблица*****************************************************************************************************/
echo "<TABLE width='100%' height='100%' border='0' cellpadding='0' cellspacing='1' onClick='cls1_calendar(\"calendar\")'>\n   <TR>\n     <TD valign='top' width='20%'>\n       <TABLE border='0' width='100%' height='100%' cellpadding='0' cellspacing='0' class='let_list_data'>\n         <TR>\n           <TD valign='top'>";
require "oper/balance/js/tree_total.js";
echo "<div class=\"tree\">\n<script type=\"text/javascript\">\n<!--\n";
echo "var Tree = new Array;\n";
require "oper/balance/basefun.php";
echo generateListTree($rec = '', $aux = 0, 0, false);
echo "createTree(Tree,null,null,'" . get_div_name($_SESSION['div']) . "');";
echo "\n//-->\n</script>\n</div>";
echo "\n          </TD>\n         </TR>\n       </TABLE>\n\t</TD>\n\t<TD valign='top'>";
/*	    echo"<TABLE border='0' width='100%' height='10%' cellpadding='0' cellspacing='0' class='cap2'>
        <TR>
          <TD valign='top'>123
          </TD>
        </TR>
       </TABLE>"; */
echo "<TABLE border='0' width='100%' height='100%' cellpadding='0' cellspacing='0' class='let_list_data'>\n         <TR>\n           <TD valign='top'>";
echo "<table width='99%' border='0' cellpadding='1' cellspacing='1' style='margin-left:5;margin-right:5'>" . "<tr>" . "<td align='center' width='17%'>" . "<table  border='0' cellpadding='1' cellspacing='1' width=100%>" . "<tr><td colspan='2' align='left' style='color:maroon;font-family:Arial;font-size:10pt;cursor:hand' onClick=\"prevRemain('" . $_SESSION['div'] . "')\" class='prevremain_off' onMouseOver=\"this.className='prevremain_on'\" onMouseOut=\"this.className='prevremain_off'\">Предыдущий остаток</td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left width='10%'><b>USD:</b></td><td align=left>  <b><div id='prev_usd'>&nbsp;</div></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left><b>Грн:</b></td><td align=left>  <b><div id='prev_grn'>&nbsp;</div></b></td></tr>" . "</table>" . "</td>" . "<td align='center' width='17%'>" . "<table  border='0' cellpadding='1' cellspacing='1' width=100%>" . "<tr><td colspan='2' align='left' style='color:#555555;font-family:Arial;font-size:10pt;cursor:hand'><b><u>Приход за период</u></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left width='10%'><b>USD:</b></td><td align=left>  <b><div id='in_usd'>&nbsp;</div></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left><b>Грн:</b></td><td align=left>  <b><div id='in_grn'>&nbsp;</div></b></td></tr>" . "</table>" . "</td>" . "<td align='center' width='17%'>" . "<table  border='0' cellpadding='1' cellspacing='1' width=100%>" . "<tr><td colspan='2' align='left' style='color:#555555;font-family:Arial;font-size:10pt;cursor:hand'><b><u>Расход за период</u></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left width='10%'><b>USD:</b></td><td align=left>  <b><div id='out_usd'>&nbsp;</div></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left><b>Грн:</b></td><td align=left>  <b><div id='out_grn'>&nbsp;</div></b></td></tr>" . "</table>" . "</td>" . "<td align='center' width='17%'>" . "<table  border='0' cellpadding='1' cellspacing='1' width=100%>" . "<tr><td colspan='2' align='left' style='color:#555555;font-family:Arial;font-size:10pt;cursor:hand'><b><u>Итого за период</u></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left width='10%'><b>USD:</b></td><td align=left>  <b><div id='total_usd'>&nbsp;</div></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left><b>Грн:</b></td><td align=left>  <b><div id='total_grn'>&nbsp;</div></b></td></tr>" . "</table>" . "</td>" . "<td align='center' width='17%'>" . "<table  border='0' cellpadding='1' cellspacing='1' width=100%>" . "<tr><td colspan='2' align='left' style='color:maroon;font-family:Arial;font-size:10pt;cursor:hand'><b><u>Остаток на период</u></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left width='10%'><b>USD:</b></td><td align=left>  <b><div id='remper_usd'>&nbsp;</div></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left><b>Грн:</b></td><td align=left>  <b><div id='remper_grn'>&nbsp;</div></b></td></tr>" . "</table>" . "</td>" . "<td align='center' width='15%'>" . "<table  border='0' cellpadding='1' cellspacing='1' width=100%>" . "<tr><td colspan='2' align='left' style='color:#555555;font-family:Arial;font-size:10pt;cursor:hand'><b><u>Касса</u></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left width='10%'><b>USD:</b></td><td align=left>  <b><div id='cash_usd'>&nbsp;</div></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left><b>Грн:</b></td><td align=left>  <b><div id='cash_grn'>&nbsp;</div></b></td></tr>" . "</table>" . "</td>" . "</tr>" . "</table>";
echo "<table id='ttab' border='0' cellpadding='0' cellspacing='1' style='margin-left:5'>" . "<tr id='ttRows' height='22' align='center' style='color:white;font-family:Tahoma;font-size:14px'>" . "<td>Дата</td>" . "<td>От кого/Кому</td>" . "<td>Сумма, \$</td>" . "<td>Сумма, грн</td>" . "<td>Примечание</td>" . "<td>Удаление</td>" . "</tr></table>";
echo "<IFRAME width='100%' height='69%' name='outputData' id='outputData' scrolling='yes' frameborder='0' marginheight='0' marginwidth='0'>\n             </IFRAME>\n           </TD>\n         </TR>\n        </TABLE>\n\t</TD>\n   </TR>\n</TABLE>";
echo "   <DIV id=text2\n        style='position:absolute;LEFT: 370px; WIDTH: 130px; TOP: 180px; HEIGHT: 45px;z-index:1900;visibility:hidden'\n        align=center>\n        <TABLE cellSpacing=1 cellPadding=2 width='100%'  border=0>\n        <TR>\n        <TD align=middle bgColor='#556B2F' class='promt_layer'>\n        <P align=left>\n        <FONT face='MS Sans Serif' size=2>&nbsp;\n        Введите <u>не менее 3 букв или цифр</u> для выбора статей по полю <FONT color=Yellow>От кого/Кому</FONT>\n        <BR>\n        </FONT>\n        </P>\n        </TD>\n        </TR>\n        </TABLE>\n        </DIV>";
/***************************************************************************************************************************************************/