Esempio n. 1
0
      <tr>
       <td class=let_list_data>
       Отчёт по рейсу <b>$translist_row['tname'] $translist_row['number']</b>
       </td>
      </tr>
      </table>
 */
 /*
   <tr>
    <td class='otcmenu_on' style='border:0pt;' height=35>
    Отчёт по рейсу <b>".$translist_row['tname']." ".$translist_row['number']."</b>
    </td>
   </tr>
 */
 echo "\n  <table width=100% align=center valign=top border=0 cellpadding=0 cellspacing=1>\n  <tr><td class=let_list_data style='border:0pt;background-color:#707052'>&nbsp;</td></tr>\n  <tr>\n   <td bgcolor=#FFFFFF>\n    ";
 dw_transport_cap($translist);
 echo "\n   </td>\n  </tr>\n  <tr><td class=let_list_data style='border:0pt;background-color:#707052'>&nbsp;</td></tr>";
 $query = "select distinct t.div_id, d.divname from {$trans_query} AS t, {$dbname}.div d\n         where t.div_id=d.div_id";
 $res = mysql_query($query) or die(mysql_error());
 $num = mysql_num_rows($res);
 while ($row = mysql_fetch_array($res)) {
     echo "\n     <tr>\n      <td class=let_list_fixed>\n\n       <table width=100% align=center valign=top border=0 cellpadding=0 cellspacing=1>\n       <tr>\n        <td class=let_list_fixed><b>{$row['1']}</b></td>\n       </tr>\n       <tr>\n        <td class=let_list_data>\n\n       <table width=100% align=center valign=top border=0 cellpadding=0 cellspacing=1>\n       <tr>\n        <td class=let_list_fixed align=center width=130>Тип транспорта</td>\n        <td class=let_list_fixed align=center width=80>№</td>\n        <td class=let_list_fixed align=center width=230>Направление</td>\n        <td class=let_list_fixed align=center width=90>На погрузку</td>\n        <td class=let_list_fixed align=center width=90>Вышел</td>\n        <td class=let_list_fixed align=center width=90>Пришёл</td>\n        <td class=let_list_fixed align=right width=100>Мест вышло</td>\n        <td class=let_list_fixed align=right width=100>Мест пришло</td>\n        <td class=let_list_fixed align=center width=120>Инфо</td>\n        <td class=let_list_fixed align=right>&nbsp;</td>\n       </tr>\n       ";
     $query = "select distinct t.trans_id, t.transtype_id, t.transno, t.sourcediv_id, t.destdiv_id,\n         t.transin, t.transout, t.transcame, t.positions, t.transinfo,\n         tt.tname, concat(sourcediv.divname, ' -> ', destdiv.divname) as naprav, t.tdate\n         from {$trans_query} t, {$dbname}.div destdiv, {$dbname}.div sourcediv, transtype tt\n         where t.transtype_id=tt.transtype_id and destdiv.div_id=t.destdiv_id\n         and sourcediv.div_id=t.sourcediv_id and t.div_id={$row['0']}\n          order by tdate desc";
     $res1 = mysql_query($query) or die(mysql_error());
     $num1 = mysql_num_rows($res1);
     while ($row1 = mysql_fetch_array($res1)) {
         $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[3];
         $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) {
Esempio n. 2
0
if (!isset($translist)) {
    $translist = -1;
}
echo "<input type='hidden' name='translist' id='translist' value='" . $translist . "'>";
if ($translist != -1) {
    require 'form_transfull.php';
} else {
    echo "\n  <table width=100% align=center valign=top border=0 cellpadding=0 cellspacing=0>\n  <tr><td class=let_list_data style='border:0pt;background-color:#707052'>&nbsp;</td></tr>\n  <tr>\n   <td height=45>\n    <table width=100% align=center valign=top border=0 cellpadding=0 cellspacing=0>\n    <tr>\n     <td width=110 bgcolor=#FFFFFF align=center valign=middle>\n      <img src='images/sign23.gif'>\n     </td>\n     <td width=25 bgcolor=#ffffff>&nbsp;</td>\n     <td bgcolor=#FFFFFF valign=middle>\n      <table width=100% align=center valign=top border=0 cellpadding=0 cellspacing=0>\n      <tr>\n        <td  style='background-color:#FFFFFF;font-family:Arial;font-size:16pt;color:#454532;' style='border:0pt;'>\n         <b>Выберите транспорт для получения отчёта</b>\n        </td>\n      </tr>\n      <tr>\n        <td  style='background-color:#FFFFFF;font-family:Arial;font-size:8pt;color:#454532;' style='border:0pt;'>\n         Время формирования отчёта не менее 5 минут.\n        </td>\n      </tr>\n      </table>\n     </td>\n   </tr>\n    </table>\n  </tr>\n  <tr><td class=let_list_data style='border:0pt;background-color:#707052' height=3>&nbsp;</td></tr>\n       <tr>\n        <td class=let_list_data>";
    echo "\n      <table width=100% align=center valign=top border=0 cellpadding=0 cellspacing=1>\n       <tr>\n        <td class=let_list_fixed align=left width=100%>Транспорт</td>\n        </td>\n       </tr>";
    $query = "select * from translist\n         order by transdate desc";
    $res = mysql_query($query) or die(mysql_error());
    $num = mysql_num_rows($res);
    while ($row = mysql_fetch_array($res)) {
        $tdnum++;
        echo "\n       <tr>\n        <td id='td" . $tdnum . "' class=let_list_data2 style='cursor:hand;' align=left width=100% onMouseOut=\"change_on(1, {$tdnum}, 'list_onFoff0b');\" onMouseOver=\"change_on(0, {$tdnum}, 'list_onFoff0b');\" onclick='javascript:document.forms[0].translist.value={$row['id']};parent.wsform.submit();' >";
        dw_transport_cap($row[id]);
        echo "\n        </td>\n       </tr>";
    }
    echo "\n     ";
    /*
          <table width=100% align=center valign=top border=0 cellpadding=0 cellspacing=1>
           <tr>
            <td class=let_list_fixed align=center width=440>Транспорт</td>
            <td class=let_list_fixed align=center width=70>На погрузку</td>
            <td class=let_list_fixed align=center width=70>Вышел</td>
            <td class=let_list_fixed align=center width=70>Пришёл</td>
            <td class=let_list_fixed align=left width=150>Параметры</td>
            <td class=let_list_fixed align=center width=170>Инфо</td>
            <td class=let_list_fixed align=right>&nbsp;</td>
           </tr>";