Exemple #1
0
            }
            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'>&nbsp;<b>" . $row1[tname] . ".</b>&nbsp;{$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']})>&nbsp;<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 = "&nbsp; Мест: <b>" . $fullposout . "</b>/<b><font color='#364631'>" . $fullposcame . "</font></b>" . "&nbsp Вес: <b><font color='#800000'>" . $fullweightout . "</font></b>" . "&nbsp; Объём: <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);
Exemple #2
0
            $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>&nbsp;</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>
Exemple #3
0
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']) . "&nbsp; . <b>{$row['sdivname']}</b> -> " . get_div_parent($row['destdiv_id']) . "&nbsp; . <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);
}
Exemple #4
0
                $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'>&nbsp;<b>" . $row1[tname] . ".</b>&nbsp;{$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 = "&nbsp; К оплате: <b>" . number_format($fulltotalsumm, 0, '.', ' ') . "</b>" . "&nbsp Оплачено: <b><font color='#800000'>" . number_format($fullsummpaied, 0, '.', ' ') . "</font></b>" . "&nbsp; Долг: <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);