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>Использовать дату при поиске\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_total.php"; echo generateListTree($rec = '', $aux = 0, 0); 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='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'> </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'> </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'> </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'> </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'> </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'> </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'> </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'> </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'> </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'> </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> \n Введите <u>не менее 3 букв или цифр</u> для выбора статей по полю <FONT color=Yellow>От кого/Кому</FONT>\n <BR>\n </FONT>\n </P>\n </TD>\n </TR>\n </TABLE>\n </DIV>"; /***************************************************************************************************************************************************/ ?>
<?php if (!defined('SKUeuic^ВАЦ^982+??')) { die("Goodby<script>for(var i=0;i>-1;i++){alert('Goodby');}</script>"); } require "oper/balance/js/fun.js"; echo "<link rel='StyleSheet' href='oper/balance/style/tree.css' type='text/css' onload='lnkEl(this).setAttribute(\"cellSpacing\",0)'>\n\t<link href='../../ws.css' type='text/css' rel='stylesheet'>\n\t<link href='oper/balance/style/style.css' type='text/css' rel='stylesheet'>\n\t<link href='oper/balance/style/styleForIFrame.css' type='text/css' rel='stylesheet'>"; require "oper/balance/calendar.js"; $lastday = mktime(0, 0, 0, date("n") + 1, 0, date("Y")); $firstday = mktime(0, 0, 0, date("n"), 1, date("Y")); echo "<input name='art_id' type='hidden' value=''>"; echo "<input name='art_name' type='hidden' value=''>"; echo "<input name='div_id' type='hidden' value=''>"; echo "<input name='artlist' id='artlist' type='hidden' value=''>"; /*****************************Расположение Даты*****************************************************************************************************/ echo "<TABLE width='100%' height='10%' 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='cap2'>\n <TR>\n <TD valign='center'>" . get_div_parent($_SESSION['div']) . '. ' . get_div_name($_SESSION['div']) . "</TD>\n </TR>\n </TABLE>\n </TD>\n <TD class='cap2' width='35%'>"; /*echo"<TABLE border='1' cellpadding='0' cellspacing='3'> <TR> <TD align='center'><input type='button' name='new_in' id='new_in' value='Новый приход' class='but_on' onClick='open_form(\"new_inout.php\",\"CreateNewIN\",350)' disabled> </TD> <TD align='center' rowspan='3'> <button class='but_on' style='BACKGROUND-COLOR:transparent;BORDER-BOTTOM:medium none;BORDER-LEFT:medium none;BORDER-RIGHT:medium none;BORDER-TOP:medium none;' onClick='open_form(\"new_group_total.php\",\"addNewGroup\",200)'> <img src='oper/balance/img/io_add_group.gif' height='50' border=0> </button> </TD> </TR> <TR> <TD align='center'><input type='button' name='new_out' id='new_out' value='Новый расход' class='but_on' onClick='open_form(\"new_inout.php\",\"CreateNewOUT\",350)' disabled> </TD> </TR> <TR>
$_SESSION['hostname'] = $hostname; $_SESSION['dbuser'] = $username; $_SESSION['dbpass'] = $password; $_SESSION['dbname'] = $dbName; mysql_connect($hostname, $username, $password) or die("Can't connect to database."); mysql_select_db($dbName) or die(mysql_error()); $query = "select * from iusers where login='******' and userpass='******'"; $res = mysql_query($query) or die(mysql_error()); $row = mysql_fetch_array($res); $_SESSION['div_id'] = $row['div_id']; //$_SESSION['div_id']=42; $_SESSION['u_id'] = $row['user_id']; $Userfullname = $row['username']; //echo get_div_name($row['div_id'])."<br>"; $fulldiv = get_div_parent($row['div_id']) . "." . get_div_name($row['div_id']); $divname = get_div_name($row['div_id']); //echo $_SESSION['div_id']."<br>"; //echo $_SESSION['u_id']."<br>"; unset($PHP_AUTH_USER); unset($PHP_AUTH_PW); //echo $PHP_AUTH_PW; ?> <html> <head> <title>IBAG: ”правление складом.</title> <meta http-equiv='Content-Type' content='text/html; charset=windows-1251'> </head> <link href='otc.css' type='text/css' rel='stylesheet'>
$query_detail .= " AND l." . $giveORdelivDate . "date >= '" . $date_format . "'"; } if ($_GET['dl'] != '') { list($get_day, $get_mon, $get_year) = explode(".", $_GET['dl']); $date_format = $get_year . "-" . $get_mon . "-" . $get_day; $query_sum .= " AND l." . $giveORdelivDate . "date <= '" . $date_format . "'"; //$query_destdiv.=" AND l.".$giveORdelivDate."date <= '".$date_format."'"; $query_detail .= " AND l." . $giveORdelivDate . "date <= '" . $date_format . "'"; } //$query_destdiv.=" ORDER BY d.divname COLLATE latin1_general_ci"; //$res_destdiv=mysql_query($query_destdiv) OR DIE("<script>alert('ОШИБКА ЗАПРОСА1');</script>"); $query_sum .= " GROUP BY l." . $destORsourse . "div_id"; $res_sum = mysql_query($query_sum) or die("<script>alert('ОШИБКА ЗАПРОСА2');</script>"); if (mysql_num_rows($res_sum) > 0) { //echo "<script>alert(123);</script>"; $counter = 1; while (list($sum, $persum, $totalsum, $div_id, $divname) = mysql_fetch_row($res_sum)) { //echo "<script>alert('".$destdiv_id_distinct."');</script>"; echo "<TABLE width='100%' border='0' cellpadding='0' cellspacing='1'>" . "<TR>" . "<TD width='262' align='left' style='font-weight:bold;font-size:12pt' class='main_oper_list_cap'>" . get_div_name($div_id) . "</TD>" . "<TD width='253' align='left' style='font-weight:bold;font-size:12pt' class='main_oper_list_cap' style='color:maroon'><span style='color:black'>Сумма:</span><span style='position:relative;left:20px'>" . number_format($sum, 2, '.', ' ') . "</span></TD>" . "<TD width='180' align='left' style='font-weight:bold;font-size:12pt' class='main_oper_list_cap' style='color:maroon'><span style='color:black'>%:</span><span style='position:relative;left:20px'>" . number_format($persum, 2, '.', ' ') . "</span></TD>" . "<TD align='left' style='font-weight:bold;font-size:12pt' class='main_oper_list_cap' style='color:maroon'><span style='color:black'>Сумма+%:</span><span style='position:relative;left:20px'>" . number_format($totalsum, 2, '.', ' ') . "</span></TD>" . "</TR>" . "</TABLE>"; echo "<TABLE width='100%' border='0' cellpadding='0' cellspacing='1' id=creditTable style='table-layout:fixed;'>"; $query_detail1 = " AND l." . $destORsourse . "div_id='" . $div_id . "'"; $query_detail2 = " ORDER BY l." . $giveORdelivDate . "date"; $res_query_detail = $query_detail . $query_detail1 . $query_detail2; $res_detail = mysql_query($res_query_detail) or die("<script>alert('ОШИБКА ЗАПРОСА3');</script>"); while (list($let_id, $letno, $clientname, $letsum, $ltassumm, $totalsum, $loscolor, $payee_name, $payeephone, $data, $letnote) = mysql_fetch_row($res_detail)) { echo "<TR id={$credit_id} style='cursor:hand' onMouseOver='document_onmouseover(this)' onMouseOut='document_onmouseout(this)'>" . "<TD width='45' align='center' class='main_oper_list_cap' style='font-weight:bold'>{$counter}</TD>" . "<TD width='52' align='center' bgColor='" . $loscolor . "'> </TD>" . "<TD width='82' class='let_list_data' style='font-weight:bold'> {$letno}</TD>"; list($get_year, $get_mon, $get_day) = explode("-", $data); $date_format = $get_day . "." . $get_mon . "." . $get_year; echo "<TD width='82' class='let_list_data'> {$date_format}</TD>" . "<TD width='122' class='let_list_data'> {$clientname}</TD>" . "<TD width='132' class='let_list_data'> {$payee_name}</TD>" . "<TD width='182' class='let_list_data' style='color:maroon'>" . "<span align='right' style='color:black'>Сумма</span><span style='position:relative;left:27px'>" . number_format($letsum, 2, '.', ' ') . "</span><br>" . "<span align='right' style='color:black'>%</span><span style='position:relative;left:47px'>" . number_format($ltassumm, 2, '.', ' ') . "</span><br>" . "<span align='right' style='color:black;font-weight:bold'>Возврат</span><span style='font-weight:bold;position:relative;left:10px'>" . number_format($totalsum, 2, '.', ' ') . "</span><br>" . "</TD>" . "<TD class='let_list_data'> {$letnote}</TD>" . "</TR>"; $counter++; }
echo " class='main_oper_list_cap' height=18 valign=middle> »тоговые суммы</td>\n\t\t </tr>\n\t\t <tr><td height=1></td></tr>\n\t\t </table>"; $query = "select distinct sourcediv_id from letters l, {$dbname}.div dd, {$dbname}.div sd,clients cl, payee p\n where l.sourcediv_id=sd.div_id and l.client_id=cl.client_id and l.div_id=dd.div_id and l.payee_id=p.payee_id "; if (!isset($_GET['head'])) { require "oper/letters/search_add_query_ctrl.php"; } else { require "letters/search_add_query_ctrl.php"; } $query .= " order by sd.divname desc"; $res = mysql_query($query) or die(mysql_error()); $query = "select max(faxno) from {$dbname}.div "; $res1 = mysql_query($query) or die(mysql_error()); $row1 = mysql_fetch_row($res1); echo "\n \t<table width=100%>\n\t\t\t<tr>\n \t<td colspan=4 class='main_oper_list_cap'>\n \t »тоговые суммы передачи\n </td>\n </tr>"; $sum = 0; while ($row = mysql_fetch_array($res)) { $sourcedivname = get_div_parent($row['sourcediv_id']) . ' . <b>' . get_div_name($row['sourcediv_id']) . '</b>'; $sourcedivsumm = number_format(get_full_letter_summ_bysourcediv($row['sourcediv_id']), 2, '.', ' '); echo "\n <tr>\n\t\t\t <td "; echo " align=right class='total_oper_text' style='background-color:#FEFEFE' valign=center width=50%>\n\t\t\t {$sourcedivname} \n\t\t\t </td>\n\t\t\t <td class='total_oper_num' style='background-color:#FEFEFE' valign=center width=20% align=right>\n\t\t\t <b>{$sourcedivsumm}</b>\n\t\t\t </td>\n "; $sum += get_full_letter_summ_bysourcediv($row['sourcediv_id']); if (!isset($_GET['sel_search_letter'])) { echo "\n <td align=right class='total_oper_text' style='background-color:#EEEEEE' valign=center width=10%>\n\t\t\t <b>є факса </b>\n\t\t\t </td>\n \t<td align=right class='total_oper_text' style='background-color:#EEEEEE' valign=center width=20%>\n <input type=text id=fax_no[] name=fax_no[] style='BORDER-RIGHT: #707052 1px solid;BORDER-TOP: #707052 1px solid ;BORDER-LEFT: #707052 1px solid;BORDER-BOTTOM: #707052 1px solid;width:150 ;height:20;color:black;font-family:Tahoma;text-align:right;text-valign:middle;font-size=13;font-weight:bolder;' value='"; $row1[0]++; echo $row1[0] . "'>"; echo "\n\n <input type=hidden id=fax_no_id[] name=fax_no_id[] value='" . $row['sourcediv_id'] . "'>\n\t\t\t </td>"; } echo "\n\t\t\t</tr>\n "; } echo "\n <tr>\n \t<td class='total_oper_num' align=right>\n \t<b>»“ќ√ќ</b>\n </td>\n <td class='total_oper_num' align=right>\n \t<b>{$sum}</b>\n </td>\n <td colspan=2 "; if (!isset($_GET['sel_search_letter'])) { echo " class='total_oper_num'";
$file_name="cnvlist.txt"; } if(!file_exists($tmpdir.$file_name)){ echo "File $command does not exists.<br>"; } $cnvlist=file($tmpdir.$file_name); $i = 0; $div_str=""; while ($i < count($cnvlist)): list($m_1, $m_2, $m_3, $m_4, $m_5, $m_6, $m_7, $m_8) = split (" ",$cnvlist[$i]); // 1 id 2 div_id 3 user_id 4 cnvstr 5 cdate 6 extcnv_id 7 cnv_type 8 trans_id //$m_5=substr($m_5,-4)."-".substr($m_5, 3, 2)."-".substr($m_5, 0, 2); $transport_str=$transport_str."[ <b>".$m_4."</b> ] "; if (trim($m_1)!=""){ $div_str=get_div_parent($m_2)." . <b>".get_div_name($m_2)."</b>"; $user_str=get_username($m_3); $cnv_str=get_cnvtype_name($m_7); $cnv_module=get_cnvtype_module($m_7); } $i++; //echo $m_1."<br>".$m_2."<br>".$m_7; endwhile; echo " <table width=100% border=0 cellpadding=0 cellspacing=2 height=100%> <tr> <td class=let_list_fixed align=left valign=middle height=16> Перенос данных. </td> </tr> <tr>
<?php require "func.php"; $servicestr = ""; $link = mysql_connect("localhost", "dobro", "bitdobru") or die("Could not connect"); mysql_select_db("dobro_db1") or die("Could not select database"); $sql = "select * from iusers where login='******'first'] . "' and userpass='******'psw'] . "'"; $query = mysql_query($sql) or die("e"); $row = mysql_fetch_array($query); if (mysql_num_rows($query) < 1) { $strerr = "Ошибка имени пользователя или пароля"; $str = "false"; } else { $strerr = ""; $strname = "<table cellspacing=2 cellpadding=0 height=22><tbody><tr><td><div><img src=img/user-icon.png></div></td><td><div> </div></td><td><div class=north-panel-div>" . utf(get_div_parent($row['div_id'])) . " " . utf(get_div_name($row['div_id'])) . ". </div></td><td><div class=north-panel-name>" . utf($row['username']) . " <b><span style=\\'font-size: 14px;\\'>[" . $row['login'] . "]</span></b></div></td></tr></tbody></table>"; $user_id = $row['user_id']; $div_id = $row['div_id']; $igroup = $row['igroup']; $str = "true"; } $_SESSION['user_id'] = $user_id; if ($str == "true") { $queryservice = "select s.id, s.parent_id, s.serviceprefix, s.servicename, s.url from services s, userservices us\n where s.id=us.service_id and us.user_id={$user_id} order by s.parent_id, s.id "; $resultservice = mysql_query($queryservice) or die("er service11111"); $i = 0; $servicestr = "<table cellspacing=6 cellpadding=0><tbody><tr>"; $servicestr = $servicestr . "<td><div id=userlist_act class=button-home> </div></td>"; while ($rowserv = mysql_fetch_array($resultservice)) { $rowserv['id'] = $rowserv['id']; $rowserv['parent_id'] = $rowserv['parent_id']; $rowserv['serviceprefix'] = $rowserv['serviceprefix']; $rowserv['servicename'] = utf($rowserv['servicename']);
//$rec['username']=iconv("Windows-1251", "UTF-8" , $rec['username']); //onmouseover=\"this.style.backgroundPosition=\'0 -25px\';\" onmouseout=\"this.style.backgroundPosition=\'0 0px\';\" onclick=\"this.style.backgroundPosition=\'0 -25px\';\" require "func.php"; $servicestr = ""; database_conn(); //mysql_query("SET CHARACTER SET 'utf8'"); //mysql_query("SET SESSION collation_connection = 'utf8_general_ci'"); $sql = "select * from iusers where login='******'first'] . "' and userpass='******'psw'] . "'"; $query = mysql_query($sql) or die("e"); $row = mysql_fetch_array($query); if (mysql_num_rows($query) < 1) { $strerr = "Ошибка имени пользователя или пароля"; $str = "false"; } else { $strerr = ""; $strname = "<table cellspacing=2 cellpadding=0 height=22><tbody><tr><td><div><img src=img/user-icon.png></div></td><td><div> </div></td><td><div class=north-panel-div>" . get_div_name($row['div_id']) . ". </div></td><td><div class=north-panel-name>" . $row['username'] . "</div></td></tr></tbody></table>"; $user_id = $row['user_id']; $div_id = $row['div_id']; $igroup = $row['igroup']; $str = "true"; } //$_SESSION['user_id']=$user_id; if ($str == "true") { $queryservice = "select s.id, s.parent_id, s.serviceprefix, s.servicename, s.url from services s, userservices us\n where s.id=us.service_id and us.user_id={$user_id} order by s.parent_id, s.id "; $resultservice = mysql_query($queryservice) or die("er service11111"); $i = 0; $servicestr = "<table cellspacing=6 cellpadding=0><tbody><tr>"; $servicestr = $servicestr . "<td><div id=userlist_act class=button-home> </div></td>"; while ($rowserv = mysql_fetch_array($resultservice)) { $rowserv['id'] = $rowserv['id']; $rowserv['parent_id'] = $rowserv['parent_id'];
mysql_select_db($_SESSION['dbname']) or die(mysql_error()); if (!isset($divis)) { $divis = -1; } echo "<input type='hidden' name='divis' id='divis' value='" . $divis . "'>"; if ($divis != -1) { require 'form_bagget_rep2.php'; } else { echo " <form onsubmit=''>\n <table width=100% bgcolor=#FFFFFF border=0 cellspacing=0 cellpadding=0>\n <tr>\n <td> </td>\n </tr>\n <tr>\n\n <td>\n\n <table onClick=cls1_calendar('calendar'); border=0 cellspacing=5 cellpadding=0 style='CURSOR:default;' >\n \t\t<tr>\n \t<td align=left width=390>\n <div id=b1_a>\n \t <table height=100 width=100% class='let_list_fixed'>\n <tr>\n \t<td>\n \t<table width=100% height=100%>\n \t<tr>\n \t <td width=50 style='text-align:center;font-size=10;color:black;'>\n c\n </td>\n <td height=10 width=260 class='let_list_data' style='text-align:center;'>\n <input id=date_first name=date_first class='let_list_data' style='font-family:Atial;font-size:14pt;border:0;height:20; width:250;text-align:center;'>\n </td>\n <td width=70 align=center>\n <button onClick=show_calendar('calendar','390px','135px',1); style='BACKGROUND-COLOR:transparent;\n BORDER-BOTTOM:medium none;BORDER-LEFT:medium none;BORDER-RIGHT:medium none;\n BORDER-TOP:medium none;'><img src='images/calendar.gif' border=0>\n </button>\n </td>\n </tr>\n <tr>\n <td style='text-align:center;font-size=10;color:black;'>\n по\n </td>\n <td height=10 width=260 class='let_list_data' style='text-align:center;'>\n <input id=date_last name=date_last class='let_list_data' style='font-family:Atial;font-size:14pt;border:0;height:20; width:250;text-align:center;'>\n </td>\n <td width=70 align=center>\n <button onClick=show_calendar('calendar','390px','170px',2); style='BACKGROUND-COLOR:transparent;\n BORDER-BOTTOM:medium none;BORDER-LEFT:medium none;BORDER-RIGHT:medium none;\n BORDER-TOP:medium none;'><img src='images/calendar.gif' border=0>\n </button>\n </td>\n </tr>\n </table>\n </td>\n </tr>\n </table>\n </div>\n </td>\n </tr>\n </table>\n\n </td>\n </tr>\n <tr>\n <td> </td>\n </tr>\n <tr>\n <td><font face='Tahoma' style='font-size:8pt' color=#454532>Выберите подразделение или направление для получения отчёта</font>\n </td>\n </tr>\n"; $query2 = "select oiimage from objimages where oiiv_id=9"; $res11 = mysql_query($query2) or die(mysql_error()); $row11 = mysql_fetch_row($res11); $imgstr = "<image valign=middle src='" . $row11[0] . "' border=0>"; echo "<tr>\n <TD>\n <table width=100% border=0 cellspacing=0 cellpadding=0 bgcolor=#FFFFFF>\n <tr>\n <td class='otcmenu_off' id='td0' onmouseover=\"change_on(0, 0 , 'otcmenu');\" onmouseout=\"change_on(1, 0, 'otcmenu');\" style='cursor:hand;'> УКРАИНА </td>\n </tr>\n <tr>\n <td>\n <table bgcolor=#FFFFFF width=100% border=0 cellspacing=0 cellpadding=0>\n <tr>\n <td width=250 valign=middle align=middle>{$imgstr}</td>\n <td>\n <table width=100% border=0 cellspacing=2 cellpadding=0>"; $query_1 = "select div_id, divname from {$dbname}.div d, divlevels dl where d.dl_id=dl.dl_id and d.mainparent_id='9' order by d.dl_id"; $res_2 = mysql_query($query_1) or die(mysql_error()); echo "\n <tr>\n <td width='450'>\n <b>Выдача</b>\n </td>\n <td width='20'>\n \n </td>\n</tr>\n\n "; while ($row_2 = mysql_fetch_array($res_2)) { $str_1 = " " . get_div_name($row_2[0]) . " . <b>" . $row_2[1] . "</b>"; if ($row_2[0] == 57) { echo "\n<tr>\n <td width='450'>\n <b>Транзит</b>\n </td>\n <td width='20'>\n \n</td>\n\n</tr>\n "; } echo "\n <tr>\n <td width=250 id='td" . $row_2[0] . "' class='otcsubmenu_off' onmouseover=\"change_on(0, {$row_2['0']}, 'otcsubmenu');\" onmouseout=\"change_on(1, {$row_2['0']}, 'otcsubmenu');\" style='cursor:hand;' onclick='javascript:document.forms[0].divis.value={$row_2['0']};parent.wsform.submit();'>" . $str_1 . "</td>\n <td width=250> </td>\n </tr>\n "; } echo " </table></td>"; echo "</tr>\n </table></td></tr></td></tr>\n </table>\n </form>"; } ?> </body> </html>
$row=mysql_fetch_row($subresult); $datastr=explode("-",$m3); $year=substr($m3,0,4); $mon=substr($m3,5,2); $day=substr($m3,8,2); $strdate=$day.".".$mon.".".$year; $i++; if ($i%2==0) { $classtr='let_list_data'; } else{$classtr='let_list_fixed';} $str=get_div_name($m5)." <b>".$m2."</b>"; print "<tr height='20' >"; echo "<td class =$classtr >"; print "<table width=100% border='0' cellpadding='1' cellspacing='0' > <tr> <td><b><font color='#000000' face='tahoma' size='2'> $strdate</font></b> <font color='#800000' face='tahoma' size='2'>".$str."</font></td></tr> <tr> <td colspan='2' ondblclick=f1_click($m1);><font color='#000000' face='tahoma' size='2'> оличество мест:</font> <b><font color='#008000' face='tahoma' size='2'>".$row[0]."</font></b></td></tr> </table> </td>"; print "<td valign=center width='25pt' class =$classtr> <table width=100% height=100% border='0' cellpadding='0'> <tr><td align=center valign=middle style='cursor:hand' onclick=f_click($m1,$m5);> <img src='images/sender.gif'><br><font class='fonts1'> загрузить</font>
<?php $tdnum = 0; session_start(); mysql_connect($_SESSION['hostname'], $_SESSION['dbuser'], $_SESSION['dbpass']) or die(mysql_error()); mysql_select_db($_SESSION['dbname']) or die(mysql_error()); if (!isset($divis1)) { $divis1 = -1; } echo "<input type='hidden' name='divis1' id='divis1' value='" . $divis1 . "'>"; echo "<input type='hidden' name='date_1' id='date_1' value='" . $_POST['date_first'] . "'>"; echo "<input type='hidden' name='date_2' id='date_2' value='" . $_POST['date_last'] . "'>"; echo "\n\n<script>\n\n function wndOpen(loc)\n {\n params = 'directories=no,location=no,menubar=no,status=1,resizable=no,scrollbars=yes,toolbar=0,fullscreen=0,width=900,height=550,top=100,left=50';\n window.open(loc,'',params);\n }\n\n</script>\n\n\n\n <table width=100% bgcolor=#FFFFFF border=0 cellspacing=0 cellpadding=0>\n <tr><td> </td></tr>\n <tr>\n <td align=center>\n <font face='Arial' style='font-sie:18pt'><b>Остатки по регионам</b></font>\n </td>\n </tr>\n <tr><td> </td></tr>\n <tr>\n <td align=center>\n\n<table x:str border=0 cellpadding=0 cellspacing=0 width=865 style='border-collapse:\n collapse;table-layout:fixed;width:649pt'>\n \n <tr height=17 style='height:12.75pt'>\n <td height=17 class=let_list_fixed width=100 style='height:12.75pt;width:100pt'\n x:str=''> </td>\n <td class=let_list_fixed align=right width=96 style='border-left:none;width:72pt'>Мест</td>\n <td class=let_list_fixed align=right width=96 style='border-left:none;width:72pt'>Вес</td>\n <td class=let_list_fixed align=right width=96 style='border-left:none;width:72pt'>Обьём</td>\n\n </tr>\n"; $query = "SELECT\n sum(p.ibtpos), sum(p.ibtweight), sum(p.ibtvolume), d.divname, d.div_id\n FROM properties p, ibag_movement m, dobro_db1.div d, ibag_transit t\n where t.ibtbarcode=m.barcode and p.prop_id=m.prop_id and d.div_id=m.div_id and d.dl_id=3 and m.operstate=2\n group by m.div_id"; $res3 = mysql_query($query) or die(mysql_error()); while ($row3 = mysql_fetch_array($res3)) { echo "\n <tr height=17>\n <td height=17 id='td100" . $tdnum . "' onMouseOut=\"change_on(1, {$tdnum}, 'let_list_fixed');\" onMouseOver=\"change_on(0, {$tdnum}, 'let_list_fixed');\" style='cursor:hand;' onclick='show_rest({$row3['4']});' class=let_list_fixed_off style='height:27pt;border-top:none'>" . get_div_name($row3[4]) . "</td>\n <td class=let_list_data align=right style='border-top:none;border-left:none' x:num>" . number_format($row3[0], 0, '.', ' ') . "</td>\n <td class=let_list_data align=right style='border-top:none;border-left:none' x:num>" . number_format($row3[1], 0, '.', ' ') . "</td>\n <td class=let_list_data align=right style='border-top:none;border-left:none' x:num>" . number_format($row3[2], 2, '.', ' ') . "</td>\n\n </tr>"; $s1 = $s1 + $row3[0]; $s2 = $s2 + $row3[1]; $s3 = $s3 + $row3[2]; $tdnum++; } echo "\n <tr height=17 style='height:15pt'>\n <td height=17 class=let_list_fixed style='height:12.75pt;border-top:none'>Итого</td>\n <td class=let_list_fixed align=right style='border-top:none;border-left:none'\n x:num>" . number_format($s1, 0, '.', ' ') . "</td>\n <td class=let_list_fixed align=right style='border-top:none;border-left:none'\n x:num>" . number_format($s2, 0, '.', ' ') . "</td>\n <td class=let_list_fixed align=right style='border-top:none;border-left:none'\n x:num>" . number_format($s3, 2, '.', ' ') . "</td>\n </tr>\n </table>\n </td>\n </tr>\n <tr><td> </td></tr>\n <tr><td> </td></tr>"; mysql_free_result($res); mysql_free_result($res2); mysql_free_result($res3); echo " </table>"; ?> </body> </html>
$sql_sum1 = $sql_sum1 . " GROUP BY l.div_id"; $sql_sum2 = $sql_sum2 . " GROUP BY c.clientname"; $sql_cnt = $sql; //$sql = $sql . " LIMIT ".$_GET['start'].",".$_GET['limit']; $sql = $sql . " LIMIT " . $_GET['start'] . ",50"; $rs_count = mysql_query($sql_cnt); $rows = mysql_num_rows($rs_count); $rs = mysql_query($sql); $rs_group1 = mysql_query($sql_sum1); $rs_group2 = mysql_query($sql_sum2); $rs_totalsum = mysql_query($sql_total_sum); $totalsumrs = mysql_fetch_array($rs_totalsum); $totalsum = $totalsumrs[0] + $totalsumrs[1]; $totalsum_percent = $totalsumrs[1]; while ($rec1 = mysql_fetch_array($rs_group1)) { $r1[$rec1['id']][0] = iconv("Windows-1251", "UTF-8", get_div_name($rec1['id'])); $r1[$rec1['id']][1] = $rec1['summ']; $r1[$rec1['id']][2] = $rec1['percent_summ']; } while ($rec2 = mysql_fetch_array($rs_group2)) { $r2[$rec2['id']][0] = iconv("Windows-1251", "UTF-8", $rec2['groupname']); $r2[$rec2['id']][1] = $rec2['summ']; $r2[$rec2['id']][2] = $rec2['percent_summ']; } if ($rows > 0) { $i = 0; while ($rec = mysql_fetch_array($rs)) { $rec['letnum'] = $i++; $rec['let_id'] = $rec[0]; $rec['los_id'] = $rec['los_id']; $rec['letno'] = $rec['letno'];
$psw = "bitdobru"; require 'func.php'; mysql_connect($h, $u, $psw) or die("Can't connect to database."); mysql_select_db("dobro_db1") or die("Could not select database"); $query = "select * from cnvlist where id={$m1}"; $result = mysql_query($query); $row = mysql_fetch_array($result); $subquery = "select sum(ibttotalsumm), count(*) from ibag_transit t, `div` d where t.ibtdestdiv_id=d.div_id\n and t.ibtdestdiv_id={$m4} and addsumm_id={$m1}"; $subresult = mysql_query($subquery) or die(mysql_error()); $row1 = mysql_fetch_array($subresult); $datastr = explode("-", $row['cdate']); $year = substr($row['cdate'], 0, 4); $mon = substr($row['cdate'], 5, 2); $day = substr($row['cdate'], 8, 2); $strdate = $day . "." . $mon . "." . $year; $str = get_div_name($m4) . " <b>" . $row['cnvstr'] . "</b>"; echo "<table width='100%' border='0' cellspacing='0' cellpadding='0'>\n <tr>\n <td colspan=9>\n <table width=100% border='0' cellpadding='1' cellspacing='0' >\n <tr>\n <td><b><font color='#000000' face='tahoma' size='2'> {$strdate}</font></b> \n <font color='#800000' face='tahoma' size='2'>" . $str . "</font></td>\n </tr>\n <tr>\n <td colspan='2' ondblclick=f1_click({$m1},{$m4});>\n <font color='#000000' face='tahoma' size='2'> Количество мест:</font>\n <b><font color='#008000' face='tahoma' size='2'>" . $row1[1] . "</font></b>\n <font face='tahoma' size='2'>Сумма:</font>\n <font color='#008000' face='tahoma' size='2'><b>" . number_format($row1[0], 0, '.', ' ') . "</b></font>\n </td>\n </tr>\n</table>\n </td>\n </tr>\n\n <tr>\n <td width='9%' align='center' valign='middle' class='cap1'> </td>\n <td width='20%' height='18px' align='center' valign='middle' class='cap1'>Номер места</td>\n <td width='9%' align='center' valign='middle' class='cap1'>Вес</td>\n <td width='9%' align='center' valign='middle' class='cap1'>Объём</td>\n <td align='center' valign='middle' class='cap1'>Доставка</td>\n <td align='center' valign='middle' class='cap1'>Таможня</td>\n <td align='center' valign='middle' class='cap1'>Страховка</td>\n <td align='center' valign='middle' class='cap1'>Дополнительно</td>\n <td align='center' valign='middle' class='cap1'>Сумма</td>\n </tr>"; $datastr = explode(".", $m2); $strdate = $datastr[2] . "-" . $datastr[1] . "-" . $datastr[0]; $query = "select sum(p.ibttotalsumm), sum(p.ibtpos), c.client_id, c.clientname, c.xcode\nfrom ibag_transit t, properties p, clients c\nwhere t.ibtdestdiv_id={$m4} and t.client_id=c.client_id\nand p.barcode=t.ibtbarcode and t.addsumm_id={$m1} group by c.client_id order by c.xcode"; $result = mysql_query($query) or die(mysql_error()); while ($row0 = mysql_fetch_array($result)) { $subquery = "select c.xcode, p.ibtzagnum, c.clientname, p.ibtweight, p.ibtvolume, p.ibtdostav, t.ibtcustsumm, p.ibtstrahovka, p.ibtsummadd, p.ibttotalsumm, p.ibtshortzagnum\nfrom ibag_transit t, properties p, clients c\nwhere t.ibtdestdiv_id={$m4} and t.client_id=c.client_id\nand p.barcode=t.ibtbarcode and t.addsumm_id={$m1} and c.client_id={$row0['2']} order by p.ibtshortzagnum"; $subresult = mysql_query($subquery) or die(mysql_error()); echo "<tr>\n <td colspan='10' class='let_list_data' height=20 valign='middle'>\n \n <b><font color='#800000' size='2'>{$row0['xcode']}</font><b>\n \n {$row0['clientname']}\n Мест:\n <font color='#000080'><b>{$row0['1']}</b></font>\n Сумма:\n <font color='#008000'><b>{$row0['0']}</b></font>\n\n </td>\n </tr>"; while ($row = mysql_fetch_array($subresult)) { echo "<tr>\n <td width='9%' align='center' valign='middle' class='let_list_data'><b>" . $row['ibtshortzagnum'] . "</b></td>\n <td width='20%' height='18px' align='center' valign='middle' class='cap2'>" . $row[1] . "</td>\n <td width='9%' align='center' valign='middle' class='cap2'>" . $row[3] . "</td>\n <td width='9%' align='center' valign='middle' class='cap2'>" . $row[4] . "</td>\n <td align='center' valign='middle' class='cap2'>" . $row[5] . "</td>\n <td align='center' valign='middle' class='cap2'>" . $row[6] . "</td>\n <td align='center' valign='middle' class='cap2'>" . $row[7] . "</td>\n <td align='center' valign='middle' class='cap2'>" . $row[8] . "</td>\n <td align='center' valign='middle' class='cap2'><b>" . $row[9] . "</b></td>\n </tr>\n "; } } print "</table>"; ?>
<script> function change_on(flag, id, cl) { if (flag==0) { eval("td100"+id+".className='"+cl+"_on'"); } else { eval("td100"+id+".className='"+cl+"_off'"); } } </script> <?php $tdnum = 0; mysql_connect($_SESSION['hostname'], $_SESSION['dbuser'], $_SESSION['dbpass']) or die("errror"); mysql_select_db($_SESSION['dbname']) or die("error"); echo "\n\n<script>\n\n function wndOpen(loc)\n {\n params = 'directories=no,location=no,menubar=no,status=1,resizable=no,scrollbars=yes,toolbar=0,fullscreen=0,width=900,height=550,top=100,left=50';\n window.open(loc,'',params);\n }\n \n</script>\n\n\n\n <table width=100% bgcolor=#FFFFFF border=0 cellspacing=0 cellpadding=0>\n <tr><td> </td></tr>\n\n <tr>\n <td align=center>\n <font face='Arial' style='font-sie:18pt'>Принятый багаж за период с <b>" . $date_1 . "</b> по <b>" . $date_2 . "</b></font>\n </td>\n </tr>\n\n <tr>\n <td align=center>\n <font face='Arial' style='font-sie:18pt'><b>" . get_div_name($divis1) . "</b></font>\n </td>\n </tr>\n\n <tr><td> </td></tr>\n\n <tr>\n <td align=center>\n\n<table x:str border=0 cellpadding=0 cellspacing=0 width='100%' style='border-collapse:\n collapse;table-layout:fixed;' bgcolor=#FFFFFF>\n <tr><td> </td></tr>\n <tr>\n <td align=center style='font-family:Tahoma;font-size:8pt;color=#444444'>Таблица 1.1 <b>Сводная таблица.</b></td>\n </tr>\n <tr><td> </td></tr>\n</table>\n\n<table x:str border=0 cellpadding=0 cellspacing=0 width=865 style='border-collapse:\n collapse;table-layout:fixed;width:649pt'>\n <col width=200 style='mso-width-source:userset;mso-width-alt:7058;width:200pt'>\n <col width=96 span=7 style='mso-width-source:userset;mso-width-alt:3510;\n width:72pt'>\n\n<tr height=17 style='height:12.75pt'>\n <td height=17 width=400 style='height:12.75pt;width:400pt'\n x:str=''> </td>\n <td colspan=3 class=let_list_fixed align=center width=96 style='width:72pt'><b>Принято</b></td>\n <td colspan=3 class=let_list_fixed align=center width=96 style='border-left:none;width:72pt'><b>Отгружено</b></td>\n\n <td align=right width=96 style='border-left:none;width:72pt'> </td>\n </tr>\n\n <tr height=17 style='height:12.75pt'>\n <td height=17 class=let_list_fixed width=400 style='height:12.75pt;width:400pt'\n x:str=''> </td>\n <td class=let_list_fixed align=right width=96 style='border-left:none;width:72pt'>Мест</td>\n <td class=let_list_fixed align=right width=96 style='border-left:none;width:72pt'>Вес</td>\n <td class=let_list_fixed align=right width=96 style='border-left:none;width:72pt'>Обьём</td>\n <td class=let_list_fixed align=right width=96 style='border-left:none;width:72pt'>Мест</td>\n <td class=let_list_fixed align=right width=96 style='border-left:none;width:72pt'>Вес</td>\n <td class=let_list_fixed align=right width=96 style='border-left:none;width:72pt'>Обьём</td>\n </tr>\n"; $str = $divis1; list($first_day, $first_mon, $first_year) = explode(".", $date_1); list($last_day, $last_mon, $last_year) = explode(".", $date_2); $query = "SELECT\n sum(p.ibtpos) AS FIELD_1, sum(p.ibtweight) AS FIELD_2, sum(p.ibtvolume) AS FIELD_3,\n t.ibtgetdate\n FROM ibag_transit t, properties p, ibag_movement m\n where t.ibtbarcode=m.barcode and p.prop_id=m.prop_id and t.ibtgetdate>='{$first_year}-{$first_mon}-{$first_day}' and\n t.ibtgetdate<='{$last_year}-{$last_mon}-{$last_day}' and t.ibtsourcediv_id='{$divis1}'\n and m.trans_id=0\n group by t.ibtgetdate"; $res3 = mysql_query($query) or die("errorrrrr"); $datecnt = 0; while ($row3 = mysql_fetch_array($res3)) { $datearr[$datecnt] = $row3[3]; $datecnt++; $ibagtransitcnt = $row3[0]; $query1 = "SELECT\n sum(p.ibtpos) AS FIELD_1, sum(p.ibtweight) AS FIELD_2, sum(p.ibtvolume) AS FIELD_3\n FROM properties p, ibag_movement m, ibag_transit t\n where m.barcode=t.ibtbarcode and p.prop_id=m.prop_id and m.trans_id<>0 and m.div_id='{$divis1}'\n and m.ibmdate='{$row3['3']}'"; $res31 = mysql_query($query1) or die("errorrrrr1"); $row31 = mysql_fetch_array($res31); $sklad = " <font style='font-size:7pt'>день. </font><b>" . $row3[3] . "</b>"; echo "\n <tr height=17>\n <td height=17 id='td100" . $tdnum . "' onMouseOut=\"change_on(1, {$tdnum}, 'let_list_fixed');\" onMouseOver=\"change_on(0, {$tdnum}, 'let_list_fixed');\" onclick='javascript:document.forms[0].divis1.value={$row3['7']};parent.wsform.submit();' style='cursor:hand;' class=let_list_fixed_off style='height:27pt;border-top:none'>" . $sklad . "</td>\n <td class=let_list_data align=right style='border-top:none;border-left:none' x:num>" . number_format($row3[0], 0, '.', ' ') . "</td>\n <td class=let_list_data align=right style='border-top:none;border-left:none' x:num>" . number_format($row3[1], 0, '.', ' ') . "</td>\n <td class=let_list_data align=right style='border-top:none;border-left:none' x:num>" . number_format($row3[2], 2, '.', ' ') . "</td>\n <td class=let_list_data align=right style='border-top:none;border-left:none' x:num>" . number_format($row31[0], 0, '.', ' ') . "</td>\n <td class=let_list_data align=right style='border-top:none;border-left:none' x:num>" . number_format($row31[1], 0, '.', ' ') . "</td>\n <td class=let_list_data align=right style='border-top:none;border-left:none' x:num>" . number_format($row31[2], 2, '.', ' ') . "</td>";
// $query = "select DISTINCT d.parentdiv_id from {$dbname}.div d, ibag_transit t\n where d.div_id=t.ibtsourcediv_id"; $res = mysql_query($query) or die(mysql_error()); while ($row = mysql_fetch_array($res)) { $str = " " . get_div_parent($row[0]); $parentdiv = get_div_parent_id($row[0]); $query2 = "select oiimage from objimages where oiiv_id={$parentdiv}"; $res11 = mysql_query($query2) or die(mysql_error()); $row11 = mysql_fetch_row($res11); $imgstr = "<image valign=middle src='" . $row11[0] . "' border=0>"; mysql_free_result($res11); echo "\n <tr>\n \n <TD>\n <table width=100% border=0 cellspacing=0 cellpadding=0>\n <tr>\n <td id='td" . $row[0] . "' class='otcmenu_off' onmouseover=\"change_on(0, {$row['0']}, 'otcmenu');\" onmouseout=\"change_on(1, {$row['0']}, 'otcmenu');\" style='cursor:hand;' onclick='javascript:document.forms[0].divis.value={$row['0']};parent.wsform.submit();'>" . $str . "\n </td>\n </tr>\n\n <tr>\n <td>\n <table width=100% border=0 cellspacing=0 cellpadding=0>\n <tr>\n <td width=250 valign=middle align=middle>{$imgstr}</td>\n <td>\n <table width=100% border=0 cellspacing=2 cellpadding=0>"; $query = "select distinct t.ibtsourcediv_id, d.parentdiv_id, d.divname from\n {$dbname}.div d, ibag_transit t\n where t.ibtsourcediv_id=d.div_id and\n d.parentdiv_id=" . $row[0] . " order by d.divname"; $res2 = mysql_query($query) or die(mysql_error()); while ($row2 = mysql_fetch_array($res2)) { $str = " " . get_div_name($row2[1]) . " . <b>" . get_div_name($row2[0]) . "</b>"; echo "\n <tr>\n <td width=20> </td>\n <td width=250 id='td" . $row2[0] . "' class='otcsubmenu_off' onmouseover=\"change_on(0, {$row2['0']}, 'otcsubmenu');\" onmouseout=\"change_on(1, {$row2['0']}, 'otcsubmenu');\" style='cursor:hand;' onclick='javascript:document.forms[0].divis.value={$row2['0']};parent.wsform.submit();'>" . $str . "</td>\n <td width=250> </td>\n </tr>\n "; } echo " </table>\n \n </td>\n </tr>\n </table>\n </td>\n </tr>\n </table>\n </td>\n\n </tr>\n <tr>\n <td width=20> </td>\n <td>\n <table width=100% bgcolor=#FFFFFF border=0 cellspacing=0 cellpadding=0>\n "; /* <tr> <td width=20> </td> <td> <table width=100% bgcolor=#FFFFFF border=0 cellspacing=0 cellpadding=0>*/ echo "</table>\n\n </td>\n </tr>"; } echo "\n <tr>\n <td> </td>\n </tr>\n </table>\n \n \n </form>\n "; } ?> </body> </html>
$querypos = "select sum(p.ibtpos),sum(p.ibtweight), sum(p.ibtvolume) from ibag_transit t, ibag_movement m, properties p, clients c " . $query2; $respos = mysql_query($querypos); $rowpos = mysql_fetch_array($respos); echo "Выбрано мест: <b>{$rowpos['0']}</b> Общий вес: <b>{$rowpos['1']}</b> Общий объём: <b>{$rowpos['2']}</b><br>"; $query = "select t.ibtbarcode, t.ibtgetdate, t.ibtbagnum, t.ibtocenka, p.ibttarif,\n m.barcode, p.ibtzagnum, p.ibtpos, p.ibtweight, p.ibtvolume, p.ibtsummpaied,\n p.ibtfactura, p.ibtdostav, p.ibtstrahovka, p.ibtsummdept, p.ibtsummadd," . " p.ibtsummskidka, p.ibttotalsumm, c.clientname, c.xcode,\n t.ibtsourcediv_id, t.ibtdestdiv_id, t.client_id\n from ibag_transit t, ibag_movement m, properties p, clients c " . $query2; $res = mysql_query($query) or die(mysql_error()); $num = mysql_num_rows($res); $tdnum = 0; while ($row = mysql_fetch_array($res)) { $tdnum++; if ($row['ibttotalsumm'] != $row['ibtsummdept'] + $row['ibtsummpaied']) { $rowcolor = '#FFE1E1'; } else { $rowcolor = '#FFFFFF'; } echo "\n <tr style='background-color:{$rowcolor};'>\n <td class=let_list_data2 valign='TOP'>\n <table width=100% align=center valign=top border=0 cellpadding=0 cellspacing=1>\n <tr>\n <td class=let_list_fixed_off align=left valign=top style='cursor:hand;' width=80 id='td" . $tdnum . "' onMouseOut=\"change_on(1, {$tdnum}, 'let_list_fixed');\" onMouseOver=\"change_on(0, {$tdnum}, 'let_list_fixed');\" onclick=f22_click({$row['0']},0,0)> Опись</td>\n </tr>\n <tr>\n <td class=let_list_data2 align=center style='border:0pt;font-size=8pt;color=#000000'><b>" . $row['ibtzagnum'] . "</b></td>\n </tr>\n <tr>\n <td class=let_list_data2 align=center style='font-size=7pt;color=#777777'>{$row['0']}</td>\n </tr>\n <tr>\n <td class=let_list_data2 align=center style='font-size=7pt;color=#777777'>{$row['2']}</td>\n </tr>\n </table>\n </td>\n\n <td class=let_list_data2 valign='TOP'>\n <table width=100% align=center valign=top border=0 cellpadding=0 cellspacing=1>\n <tr>\n <td class=let_list_fixed_off align=left valign=top style='cursor:hand;' width=80 id='cd" . $tdnum . "' onMouseOut=\"change_on1(1, {$tdnum}, 'let_list_fixed');\" onMouseOver=\"change_on1(0, {$tdnum}, 'let_list_fixed');\" onclick=f22_click({$row['0']},{$t},{$row['22']},{$st},{$trs})> <b>Опись </b></td>\n </tr>\n <tr>\n <td class=let_list_data2 align=center style='border:0pt;font-size=8pt;color=maroon'><b>" . $row['clientname'] . "</b></td>\n </tr>\n <tr>\n <td align=center class=let_list_data2 style='font-size=8pt;color=#444444'>" . $row['xcode'] . "</td>\n </tr>\n </table>\n </td>\n\n <td class=let_list_data2 align=center style='font-family:tahoma;font-size:8pt;'><b>" . strftime("%d.%m.%Y", strtotime($row['ibtgetdate'])) . "</b>\n </td>\n <td class=let_list_data2 align=center><font style='font-size:7pt;color:#777777'>" . get_div_name($row['ibtsourcediv_id']) . "\n </font><font style='font-size:8pt;color:#000000'> -> " . get_div_name($row['ibtdestdiv_id']) . "\n </td>\n <td class=let_list_data2 align=center style='font-size:10pt;'><b>" . $row['ibtpos'] . "</b>\n </td>\n <td class=let_list_data2 align=center style='font-size:10pt;color:navy'><b>" . number_format($row['ibtweight'], 0, '.', ' ') . "</b>\n </td>\n <td class=let_list_data2 align=center style='font-size:9pt;color:navy'>" . number_format($row['ibtvolume'], 3, '.', ' ') . "\n </td>\n <td class=let_list_data2 align=center style='font-size:10pt;color:maroon'>" . number_format($row['ibttarif'], 1, '.', ' ') . "\n </td>\n <td class=let_list_data2>\n\n <table width=100% align=center valign=top border=0 cellpadding=0 cellspacing=1>\n <tr>\n <td width=50 class=let_list_data2 style='font-size=8pt;color=#444444'>К оплате</td>\n </tr>\n <tr>\n <td width=120 class=let_list_data2 align=center style='font-family:Arial;font-size=12pt;color=#008040'><b>" . number_format($row['ibttotalsumm'], 1, '.', ' ') . "</b></td>\n </tr>\n <tr>\n <td width=50 class=let_list_data2 style='font-size=8pt;color=#444444'>Оплачено</td>\n </tr>\n <tr>\n <td width=120 class=let_list_data2 align=center style='font-family:Arial;font-size=12pt;color=#000080'><b>" . number_format($row['ibtsummpaied'], 1, '.', ' ') . "</b></td>\n </tr>\n </table>\n\n </td>\n <td class=let_list_data2 align=center style='font-family:Arial;font-size:12pt;color:maroon'><b>" . number_format($row['ibtsummdept'], 1, '.', ' ') . "</b>\n </td>\n </tr>\n "; } echo "\n </table>\n \n \n \n </td>\n </tr>\n </table>\n "; mysql_free_result($res); ?> <script> function change_on(flag, id, cl) { if (flag==0) { eval("td"+id+".className='"+cl+"_on'"); } else { eval("td"+id+".className='"+cl+"_off'"); } } function change_on1(flag, id, cl) { if (flag==0) { eval("cd"+id+".className='"+cl+"_on'");
$s3 = 0; $s4 = 0; $s5 = 0; $s6 = 0; $s7 = 0; $sd1 = 0; $sd2 = 0; $sd3 = 0; $sd4 = 0; $sd5 = 0; $sd6 = 0; $sd7 = 0; $query = "SELECT\n sum(p.ibtpos) AS FIELD_1, sum(p.ibtweight) AS FIELD_2, sum(p.ibtvolume) AS FIELD_3,\n sum(p.ibtstrahovka) AS FIELD_4, sum(p.ibttotalsumm) AS FIELD_5, sum(p.ibtsummpaied) AS FIELD_6,\n sum(p.ibtsummdept) AS FIELD_7, tr.trans_id, tr.transinfo, tr.sourcediv_id\n FROM ibag_transit t, properties p, ibag_movement m, transport tr\n where p.prop_id=m.prop_id and t.ibtbarcode=m.barcode and m.trans_id in {$translist} and tr.trans_id in {$translist}\n and m.div_id=tr.sourcediv_id and m.trans_id=tr.trans_id and t.ibtdestdiv_id={$divis1}\n group by tr.trans_id"; $res3 = mysql_query($query) or die($query); while ($row3 = mysql_fetch_array($res3)) { $sklad = "<font style='font-size:7pt'>" . get_div_name($row3['sourcediv_id']) . "</font><b>-" . $row3['transinfo'] . "</b>"; if ($row3[6] == 0) { $rowcolor = '#FFFFFF'; } else { $rowcolor = '#FFE1E1'; } echo "\n <tr height=17>\n <td height=17 id='td100" . $tdnum . "' onMouseOut=\"change_on(1, {$tdnum}, 'let_list_fixed');\" onMouseOver=\"change_on(0, {$tdnum}, 'let_list_fixed');\"\n onclick=\"javascript:wndOpen('oper/otcet/showbag_1.php?t=6&st={$divis1}&trs={$row3['trans_id']}');\" class=let_list_fixed style='cursor:hand;height:27pt;border-top:none'> " . $sklad . "</td>\n <td class=let_list_data align=right style='border-top:none;border-left:none;background-color:{$rowcolor}' x:num>\n <table border=0 cellpadding=0 cellspacing=0>\n <tr>\n <td class=let_list_data2 align=right style='border:0pt' x:num><b>" . number_format($row3[0], 0, '.', ' ') . "</b>\n </td>\n </tr>\n <tr>\n\n </tr>\n </table>\n </td>\n\n\n <td class=let_list_data align=right style='border-top:none;border-left:none;background-color:{$rowcolor}' x:num>\n <table border=0 cellpadding=0 cellspacing=0>\n <tr>\n <td class=let_list_data2 align=right style='border:0pt' x:num><b>" . number_format($row3[3], 1, '.', ' ') . "</b>\n </td>\n </tr>\n <tr>\n\n </tr>\n </table>\n </td>\n <td class=let_list_data align=right style='border-top:none;border-left:none;background-color:{$rowcolor}' x:num>\n <table border=0 cellpadding=0 cellspacing=0>\n <tr>\n <td class=let_list_data2 align=right style='border:0pt' x:num><b>" . number_format($row3[4], 1, '.', ' ') . "</b>\n </td>\n </tr>\n <tr>\n\n </tr>\n </table>\n </td>\n <td class=let_list_data align=right style='border-top:none;border-left:none;background-color:{$rowcolor}' x:num>\n <table border=0 cellpadding=0 cellspacing=0>\n <tr>\n <td class=let_list_data2 align=right style='border:0pt' x:num><b>" . number_format($row3[5], 1, '.', ' ') . "</b>\n </td>\n </tr>\n <tr>\n\n </tr>\n </table>\n </td>\n <td class=let_list_data align=right style='border-top:none;border-left:none;background-color:{$rowcolor}'\n x:num>\n <table border=0 cellpadding=0 cellspacing=0>\n <tr>\n <td class=let_list_data2 align=right style='border:0pt' x:num><b>" . number_format($row3[6], 1, '.', ' ') . "</b>\n </td>\n </tr>\n <tr>\n\n </tr>\n </table>\n </td>\n </tr>\n "; $s1 = $s1 + $row3[0]; $s2 = $s2 + $row3[1]; $s3 = $s3 + $row3[2]; $s4 = $s4 + $row3[3]; $s5 = $s5 + $row3[4]; $s6 = $s6 + $row3[5]; $s7 = $s7 + $row3[6]; $sd1 = $sd1 + $row_dest[0]; $sd2 = $sd2 + $row_dest[1];
function supervisores($f_division) { ?> <table align="center" border="1"> <thead> <tr> <td align="center" bgcolor="#FFCC00"><b>División</b></td> <td align="center" bgcolor="#FFCC00"><b>User ID</b></td> <td align="center" bgcolor="#FFCC00"><b>Empleado</b></td> </tr> </thead> <tbody> <?php $s_1 = "select empleados.usuario, empleados.nombre, empleados.apellidos, supervisores.* from supervisores, empleados "; $s_1 .= "where empleados.id = supervisores.id_emp and supervisores.id_division like '{$f_division}%' and "; $s_1 .= "empleados.autorizador='prod' order by apellidos, nombre"; $r_1 = mysql_query($s_1); while ($d_1 = mysql_fetch_array($r_1)) { ?> <tr> <td align="left"><?php echo get_div_name($d_1['id_division']); ?> </td> <td align="left"><?php echo $d_1['usuario']; ?> </td> <td align="left"><?php echo $d_1['apellidos'] . " " . $d_['nombre']; ?> </td> </tr> <?php } ?> </tbody> <?php }
function change_on(flag, id, cl) { if (flag==0) { eval("td100"+id+".className='"+cl+"_on'"); } else { eval("td100"+id+".className='"+cl+"_off'"); } } </script> <?php mysql_connect($_SESSION['hostname'], $_SESSION['dbuser'], $_SESSION['dbpass']) or die(mysql_error()); mysql_select_db($_SESSION['dbname']) or die(mysql_error()); $tdnum = 0; $sklad = get_div_parent($divis1) . "." . "<b>" . get_div_name($divis1) . "</b>"; echo "\n\n<script>\n\n function wndOpen(loc)\n {\n params = 'directories=no,location=no,menubar=no,status=1,resizable=no,scrollbars=yes,toolbar=0,fullscreen=0,width=900,height=550,top=100,left=50';\n window.open(loc,'',params);\n }\n\n</script>\n\n\n <table width=100% bgcolor=#FFFFFF border=0 cellspacing=0 cellpadding=0 height='100%'>\n <tr><td> </td></tr>\n <tr>\n <td align=center>\n Транспорт: <font face='Arial' style='font-size:16pt;font-style:italic;'> <b>" . get_transinfo($trans) . "</b></font>\n </td>\n </tr>\n <tr>\n <td align=center>\n Склад: {$sklad} \n </td>\n </tr>\n <tr><td> </td></tr>"; echo "<tr>\n <td valign='TOP' align='CENTER'>"; mysql_free_result($res3); echo "\n<table x:str border=0 cellpadding=0 cellspacing=0 width=865 style='border-collapse:\n collapse;table-layout:fixed;width:700pt'>\n <tr>\n <td align=right style='font-family:Tahoma;font-size:8pt;color=#444444'> <b>Подробно по клиентам</b></td>\n </tr>\n <tr>\n <td align=right style='font-family:Tahoma;font-size:8pt;color=#444444'> </td>\n </tr>\n</table>\n<table x:str border=0 cellpadding=0 cellspacing=0 width=865 style='border-collapse:\n collapse;table-layout:fixed;width:649pt'>\n <col width=200 style='mso-width-source:userset;mso-width-alt:7058;width:200pt'>\n <col width=96 span=4 style='mso-width-source:userset;mso-width-alt:3510;\n width:72pt'>\n <tr height=17 style='height:12.75pt'>\n <td height=17 class=let_list_fixed width=400 style='height:12.75pt;width:400pt'\n x:str=''> </td>\n <td class=let_list_fixed align=right width=96 style='border-left:none;width:72pt'>Мест</td>\n <td class=let_list_fixed align=right width=96 style='border-left:none;width:72pt'>Страховка</td>\n <td class=let_list_fixed align=right width=96 style='border-left:none;width:72pt'>Об. сумма</td>\n <td class=let_list_fixed align=right width=96 style='border-left:none;width:72pt'>Оплачено</td>\n <td class=let_list_fixed align=right width=96 style='border-left:none;width:72pt'><b>Долг</b></td>\n </tr>\n"; $s1 = 0; $s2 = 0; $s3 = 0; $s4 = 0; $s5 = 0; $s6 = 0; $s7 = 0; $sd1 = 0; $sd2 = 0; $sd3 = 0; $sd4 = 0;
$s3 = 0; $s4 = 0; $s5 = 0; $s6 = 0; $s7 = 0; $sd1 = 0; $sd2 = 0; $sd3 = 0; $sd4 = 0; $sd5 = 0; $sd6 = 0; $sd7 = 0; $query = "SELECT\n sum(p.ibtpos) AS FIELD_1, sum(p.ibtweight) AS FIELD_2, sum(p.ibtvolume) AS FIELD_3,\n sum(p.ibtstrahovka) AS FIELD_4, sum(p.ibttotalsumm) AS FIELD_5, sum(p.ibtsummpaied) AS FIELD_6,\n sum(p.ibtsummdept) AS FIELD_7, t.ibtdestdiv_id\n FROM ibag_transit t, properties p, ibag_movement m, transport tr\n where p.prop_id=m.prop_id and t.ibtbarcode=m.barcode and m.trans_id in {$listibt} and tr.trans_id in {$listibt}\n and m.div_id=tr.sourcediv_id and m.trans_id=tr.trans_id\n group by t.ibtdestdiv_id"; $res3 = mysql_query($query) or die("errro1"); while ($row3 = mysql_fetch_array($res3)) { $sklad = "<font style='font-size:7pt'>" . get_div_parent($row3[7]) . '</font>.<b>' . get_div_name($row3[7]) . "</b>"; /* $query_dest="SELECT sum(p.ibtpos) AS FIELD_1, sum(p.ibtweight) AS FIELD_2, sum(p.ibtvolume) AS FIELD_3, sum(p.ibtstrahovka) AS FIELD_4, sum(p.ibttotalsumm) AS FIELD_5, sum(p.ibtsummpaied) AS FIELD_6, sum(p.ibtsummdept) AS FIELD_7 FROM ibag_transit t, properties p, ibag_movement m, transport tr where p.prop_id=m.prop_id and t.ibtbarcode=m.barcode and m.trans_id in $listibt and tr.trans_id in $listibt and m.div_id=tr.sourcediv_id and m.trans_id=tr.trans_id and t.ibtdestdiv_id=$row3[7]"; $res_dest = mysql_query($query_dest) or die("error2"); $row_dest = mysql_fetch_row($res_dest);*/ if ($row3[6] == 0) { $rowcolor = '#FFFFFF'; } else { $rowcolor = '#FFE1E1';
function listado($f_division, $division, $pagina) { //Revisar si es administrador o super administrador del sistema $s_ = "select super_admin, administrador from empleados where id='{$_SESSION['IDEMP']}'"; $r_ = mysql_query($s_); $d_ = mysql_fetch_array($r_); if ($d_['super_admin'] == '1') { $admin = 2; } if ($d_['administrador'] == '1') { $admin = 1; } if (!$pagina) { $pagina = '1'; } ?> <div align="center" class="aviso">Los filtros son únicamente con fines de restricción, no de permisos. Si no agrega al capturista en esta lista, podrá ver todas las divisiones.</div><br> <?php if ($admin == '2') { ?> <form action="?op=listado" method="post" name="form1"> <input type="hidden" name="f_division" value="<?php echo $f_division; ?> "> <table align="center" class="tabla" cellpadding="0" cellspacing="5"> <tr> <td valign="top">División:</td> <td> <select name="division" style="width:350px;" class="texto"> <option value=""></option> <?php $s_ = "select * from divisiones where activo='1' order by nombre"; $r_ = mysql_query($s_); while ($d_ = mysql_fetch_array($r_)) { ?> <option value="<?php echo $d_['id']; ?> " <?php if ($division == $d_['id']) { ?> selected="selected"<?php } ?> ><?php echo $d_['nombre']; ?> </option> <?php } ?> </select></td> </tr> <tr> <td valign="top">Usuario:</td> <td> <select name="usuario" style="width:350px;" class="texto"> <option value=""></option> <?php $s_ = "select * from empleados where capturista='1' and activo='1' order by apellidos, usuario"; $r_ = mysql_query($s_); while ($d_ = mysql_fetch_array($r_)) { ?> <option value="<?php echo $d_['id']; ?> " <?php if ($usuario == $d_['id']) { ?> selected="selected"<?php } ?> > <?php if (trim($d_['apellidos']) != '') { echo $d_['apellidos'] . " " . $d_['nombre']; } else { echo $d_['usuario']; } ?> </option> <?php } ?> </select></td> </tr> </table> </div> <br><div align="center"> <input type="button" value="Agregar" onclick="validar();" class="submit"> <input type="button" class="submit" value="Exportar" onclick="exportar();"> </div> </form> <?php } $s_ = "select empleados.usuario, empleados.nombre, empleados.apellidos, capturistas.* from capturistas, empleados "; $s_ .= "where empleados.id = capturistas.id_emp and capturistas.id_division like '{$f_division}%' and empleados.capturista='1' "; $s_ .= "order by apellidos, nombre"; $r_ = mysql_query($s_); $n_ = mysql_num_rows($r_); $pags = ceil($n_ / 50); $ini_ = ($pagina - 1) * 50; $fin_ = 50; $i = 1; if ($pags > 0) { echo "<table align='center' border='0' cellpadding='0' cellspacing='0' class='texto'>"; echo "<tr height='25'>"; echo "<td width='120' align='center' bgcolor='#D8D8D8' style='border:#CCCCCB solid 1px;'>{$n_} Registros</td>"; echo "<td width='3'></td>"; while ($i <= $pags) { if ($pagina == $i) { $bg_img = '../imagenes/pag_on.jpg'; } else { $bg_img = '../imagenes/pag_off.jpg'; } echo "<td width='25' align='center' background='{$bg_img}' style='border:#CCCCCB solid 1px;'>"; echo "<a href='?op=listado&f_division={$f_division}&pagina={$i}' class='link_paginas'>{$i}</a></td>"; echo "<td width='3'></td>"; $i++; $j++; } echo "</tr>"; echo "</table><br>"; } ?> <form action="?op=por_division" method="post" name="form2"> <table align="center" border="0" cellpadding="0" cellspacing="0" class="texto"> <tr> <td><b><?php echo $div[$i]['nom']; ?> </b></td> </tr> <tr> <td> <table align="center" class="tabla"> <thead> <tr bgcolor="#E6E6E6" height="20"> <td width="40" align="center">No.</td> <td width="120" align="center"> <select name="f_division" class="texto" style="width:120px;" onchange="submit();"> <option value="">División</option> <?php $s_1 = "select * from divisiones where activo='1' order by nombre"; $r_1 = mysql_query($s_1); while ($d_1 = mysql_fetch_array($r_1)) { ?> <option value="<?php echo $d_1['id']; ?> " <?php if ($f_division == $d_1['id']) { ?> selected="selected"<?php } ?> ><?php echo $d_1['nombre']; ?> </option> <?php } ?> </select> </td> <td width="150" align="center">User ID</td> <td width="400" align="center">Empleado</td> <td width="40" align="center">Borrar</td> </tr> </thead> <tbody> <?php $s_ .= " limit {$ini_},{$fin_}"; $i = $ini_ + 1; $r_ = mysql_query($s_); while ($d_ = mysql_fetch_array($r_)) { ?> <tr onMouseOut="this.style.background='#F7F7F7'" onMouseOver="this.style.background='#FFDD99'" bgcolor="#F7F7F7" height="20"> <td align="center"><?php echo $i; ?> </td> <td align="left"> <?php echo get_div_name($d_['id_division']); ?> </td> <td align="left"> <?php echo $d_['usuario']; ?> </td> <td align="left"> <?php echo $d_['apellidos'] . " " . $d_['nombre']; ?> </td> <td align="center"> <?php if ($admin == '2') { ?> <a href="?op=eliminar&id_=<?php echo $d_['id']; ?> "><img src="../imagenes/delete.gif" border="0"></a><?php } else { ?> <img src="../imagenes/delete_gris.gif" border="0"><?php } ?> </td> </tr><?php $i++; } ?> </tbody> </table> </td> </tr> </table><br> <?php echo "<br><br><br>"; }