} mysql_free_result($res_row); $datastrcame = explode("-", $row1['transcame']); $strdatecame = $datastrcame[2] . "." . $datastrcame[1] . "." . $datastrcame[0]; if ($row1[1] != $transtype) { echo "<tr>\n <td class=let_list_data align=left colspan='13'> <b>" . $row1[tname] . ".</b> {$row['1']} </td>\n </tr>"; $prevtranstype = $transtype; $transtype = $row1[1]; $numtranstype++; } if ($row1['gos_no'] != '') { $gos_no = $row1['gos_no']; } else { $gos_no = '-'; } echo "\n <tr>\n <td class={$classstr} align=center width=130>" . $row1['tname'] . "</td>\n <td class=let_list_fixed_off align=center 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='javascript:document.forms[0].trans.value={$row1['0']};parent.wsform.submit();'>" . $row1['transinfo'] . "</td>\n <td class={$classstr} align=center width=160>" . $gos_no . "</td>\n <td class={$classstr} align=center width=230>" . $row1['naprav'] . "</td>\n <td class={$classstr} align=center width=90>" . n_date($row1['transout']) . "</td>\n <td class={$classstr} align=center width=90>" . $strdatecame . "</td>\n <td class={$classstr} align=right width=100>" . $pos_sent . "</td>\n <td class={$classstr} align=right width=100>{$pos_came}</td>\n <td class={$classstr} align=right width=100>{$pos_vol}</td>\n <td class={$classstr} align=right width=100>{$pos_weight}</td>\n <td class=let_list_fixed align=right valign=top style='cursor:hand;' width=80 id='td" . $row1[0] . "' onMouseOut=\"change_on(1, {$row1['0']}, 'let_list_fixed');\" onMouseOver=\"change_on(0, {$row1['0']}, 'let_list_fixed');\" onclick=show_trans_state({$row1['0']})> <b>Инфо</b></td>\n </tr>\n "; $tdnum++; } echo "\n </table>\n\n </td>\n </tr>\n \n </table>\n\n </td>\n </tr>\n "; } echo "\n </table>"; $str = " Мест: <b>" . $fullposout . "</b>/<b><font color='#364631'>" . $fullposcame . "</font></b>" . "  Вес: <b><font color='#800000'>" . $fullweightout . "</font></b>" . " Объём: <b><font color='#000080'>" . $fullvolumeout . "</font></b>"; echo "\n <script language=javascript>\n total.innerHTML=\"" . $str . "\";\n </script>\n "; } ?> <script> function f23_click(trans) { params = 'directories=no,location=no,menubar=1,status=0,resizable=no,scrollbars=yes,toolbar=0,fullscreen=0 width=600,height=600'; path='oper/otcet/get_bag_packing_trans.php?trans='+trans; id_wnd=window.open(path,'',params);
$res_row = mysql_query($query_row) or die(mysql_error()); $row_row = mysql_fetch_array($res_row); $pos_sent = $row_row[0]; if ($pos_sent == null) { $pos_sent = ' - '; } mysql_free_result($res_row); $query_row = "select sum(p.ibtpos) from ibag_movement m, properties p where\n m.prop_id=p.prop_id and m.strans_id={$translist} and m.trans_id=" . $row1[0] . " and m.div_id=" . $row1[4]; $res_row = mysql_query($query_row) or die(mysql_error()); $row_row = mysql_fetch_array($res_row); $pos_came = $row_row[0]; if ($pos_came == null) { $pos_came = ' - '; } mysql_free_result($res_row); echo "\n <tr>\n <td class=let_list_data align=center width=130>" . $row1['tname'] . "</td>\n <td class=let_list_fixed_off align=center 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='javascript:document.forms[0].trans.value={$row1['0']};parent.wsform.submit();'>" . $row1['transno'] . "</td>\n <td class=let_list_data align=center width=230>" . $row1['naprav'] . "</td>\n <td class=let_list_data align=center width=90>" . n_date($row1['tdate']) . "</td>\n <td class=let_list_data align=center width=90>" . n_date($row1['transout']) . "</td>\n <td class=let_list_data align=center width=90>" . n_date($row1['transcame']) . "</td>\n <td class=let_list_data align=right width=100>" . $pos_sent . "</td>\n <td class=let_list_data align=right width=100>{$pos_came}</td>\n <td class=let_list_data align=center width=120>" . $row1['transinfo'] . "</td>\n <td class=let_list_fixed align=right> </td>\n </tr>\n "; $tdnum++; } echo "\n </table>\n\n </td>\n </tr>\n\n </table>\n\n </td>\n </tr>\n "; } echo "\n </table>"; } /* $query="delete from ibag_movement_sess where phpsess_id='".$sess."'"; $res = mysqli_query($link, $query) or die(mysqli_error()); $query="delete from transport_sess where phpsess_id='".$sess."'"; $res = mysqli_query($link, $query) or die(mysqli_error()); */ ?> </body> </html>
function dw_transport_cap($trans) { $query = "select tl.id, tl.number, tl.trtype, tl.trvolume, tl.trweight, tl.owner_id,\n tl.scomment, tl.transdate,\ttl.sourcediv_id, tl.destdiv_id, tl.transname_id,\n tt.tname, tt.ttimage, ownerd.divname as ownername, sdiv.divname as sdivname,\n ddiv.divname as ddivname, tn.transname\n from translist tl, transtype tt, {$dbname}.div ownerd, {$dbname}.div sdiv,\n {$dbname}.div ddiv, transname tn\n where tl.id={$trans} and tl.trtype=tt.transtype_id and\n tl.owner_id=ownerd.div_id and tl.sourcediv_id=sdiv.div_id\n and tl.destdiv_id=ddiv.div_id and tl.transname_id=tn.transname_id"; $res = mysql_query($query) or die(mysql_error()); $row = mysql_fetch_array($res); $q2 = "select * from transport where translist_id={$trans}"; $r2 = mysql_query($q2) or die(mysql_error()); while ($rowt = mysql_fetch_array($r2)) { $trstr = $trstr . " [ " . $rowt[transinfo] . " ] "; } echo "\n\n <table cellpadding=0 cellspacing=0 border=0 width=100%>\n <tr>\n <td class=letlistdata2>\n\n <table cellpadding=0 cellspacing=0 border=0>\n <tr>\n <td width=80 valign=middle align=center>\n <image src='" . $row['ttimage'] . "'>\n </td>\n <td>\n\n <table cellpadding=0 cellspacing=0 border=0 width=100% valign=top>\n <tr><td height=5></td></tr>\n <tr valign=top>\n <td valign=top style='font-family:Tahoma;font-size:9pt;color:#000000;'>\n {$row['tname']} №<b>{$row['number']}</b> от " . n_date($row['transdate']) . "\n </td>\n </tr>\n <tr valign=top>\n <td valign=top style='font-family:Tahoma;font-size:8pt;color:#333333;'>\n <font style='color=#AAAAAA;'>Маршрут: </font>" . get_div_parent($row['sourcediv_id']) . " . <b>{$row['sdivname']}</b> -> " . get_div_parent($row['destdiv_id']) . " . <b>{$row['ddivname']}</b>\n </td>\n </tr>\n <tr valign=top>\n <td valign=top style='font-family:Tahoma;font-size:8pt;color:#333333;'>\n <font style='color=#AAAAAA;'>Включенные загрузки: </font> {$trstr}\n </td>\n </tr>\n <tr valign=top>\n <td valign=top style='font-family:Tahoma;font-size:8pt;color:#333333;'>\n <font style='color=#AAAAAA;'>Подразделение: </font> {$row['ownername']}\n </td>\n </tr>\n <tr valign=top>\n <td valign=top style='font-family:Tahoma;font-size:8pt;color:#333333;'>\n <font style='color=#AAAAAA;'>Название: </font> <b>{$row['transname']}</b>\n </td>\n </tr>\n <tr><td height=5></td></tr>\n </table>\n\n </td>\n </tr>\n </table>\n\n <td>\n </tr>\n </table>\n\n "; mysql_free_result($res); mysql_free_result($r2); }
$deptstr = $pos_dept; } $datastrcame = explode("-", $row1['transcame']); $strdatecame = $datastrcame[2] . "." . $datastrcame[1] . "." . $datastrcame[0]; if ($row1[1] != $transtype) { echo "<tr>\n <td class=let_list_data align=left colspan='14'> <b>" . $row1[tname] . ".</b> {$row['1']} </td>\n </tr>"; $prevtranstype = $transtype; $transtype = $row1[1]; $numtranstype++; } if ($row1['gos_no'] != '') { $gos_no = $row1['gos_no']; } else { $gos_no = '-'; } echo "\n <tr>\n <td class=let_list_data align=center width=20><input type='CHECKBOX' id='ch[]' name='ch[]' value='{$row1['trans_id']}'></td>\n <td class=let_list_data align=center width=130>" . $row1['tname'] . "</td>\n <td class=let_list_fixed_off align=center style='cursor:hand;' width=80 id='td" . $tdnum . "' onMouseOut=\"change_on(1, {$tdnum}, 'let_list_fixed');\" onMouseOver=\"change_on(0, {$tdnum}, 'let_list_fixed');\"\n onclick='javascript:document.forms[0].trans.value={$row1['0']};document.forms[0].showall.value=-1;parent.wsform.submit();'>" . $row1['transinfo'] . "</td>\n <td class=let_list_data align=center width=230>" . $row1['naprav'] . "</td>\n <td class=let_list_data align=center width=90>" . n_date($row1['transout']) . "</td>\n <td class=let_list_data align=center width=90>" . $strdatecame . "</td>\n <td class=let_list_data align=center width=90>" . $row_row[0] . "</td>\n <td class=let_list_data align=center width=90>" . $row_row[2] . "</td>\n <td class=let_list_data align=center width=90>" . $row_row[1] . "</td>\n <td class=let_list_data align=center width=90><font color='#008000'><b>" . number_format($row_row[3] / $row_row[2], 2, '.', ' ') . "</b></font></td>\n <td class=let_list_data align=center width=90><font color='#000080'><b>" . number_format($row_row[3] / $row_row[1], 2, '.', ' ') . "</b></font></td>\n <td class=let_list_data align=center width=100>" . number_format($pos_summ, 0, '.', ' ') . "</td>\n <td class=let_list_data align=center width=100>" . number_format($pos_paied, 0, '.', ' ') . "</td>\n <td class=let_list_data align=center width=100>" . number_format($pos_dept, 0, '.', ' ') . "</td>\n\n </tr>\n "; $tdnum++; } echo "\n </table>\n\n </td>\n </tr>\n \n </table>\n\n </td>\n </tr>\n "; } echo "\n </table>"; $str = " К оплате: <b>" . number_format($fulltotalsumm, 0, '.', ' ') . "</b>" . "  Оплачено: <b><font color='#800000'>" . number_format($fullsummpaied, 0, '.', ' ') . "</font></b>" . " Долг: <b><font color='#000080'>" . number_format($fullsummdept, 0, '.', ' ') . "</font></b>"; echo "\n <script language=javascript>\n total.innerHTML=\"" . $str . "\";\n </script>\n "; } ?> <script> function f23_click(trans) { params = 'directories=no,location=no,menubar=1,status=0,resizable=no,scrollbars=yes,toolbar=0,fullscreen=0 width=600,height=600'; path='oper/otcet/get_bag_packing_trans.php?trans='+trans; id_wnd=window.open(path,'',params);