<tr> <td width='100%' id='td16' class='otcsubmenu_on' onmouseover=\"change_on(1, 16, 'otcsubmenu');\" onmouseout=\"change_on(0, 16, 'otcsubmenu');\" style='cursor:hand;' onclick='javascript:document.forms[0].cn.value=-1;parent.wsform.submit();'> <b> Îñòàòêè:</b></td> </tr> </table>";*/ $query="select DISTINCT d.parentdiv_id from $dbname.div d, ibag_transit t, ibag_movement m where m.ibt_id=t.ibt_id and d.div_id=t.ibtsourcediv_id and m.div_id=$div"; $res = mysql_query($query) or die("asdfs"); echo "<table width=100% border=0 cellspacing=0 cellpadding=0>"; $tdnum=0; $div=$_SESSION['div_id']; while ($row=mysql_fetch_array($res)) { $tdnum++; $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); $query="select sum(p.ibtpos) from ibag_movement m, properties p, ibag_transit t, dobro_db1.div d where m.barcode=t.ibtbarcode and m.prop_id=p.prop_id and m.div_id=$div and t.ibtsourcediv_id=d.div_id and d.mainparent_id=$parentdiv and m.operstate=2"; $res = mysql_query($query) or die("asdfs"); $row=mysql_fetch_row($res); echo "<tr><td> </td></tr> <td align='center' valign='MIDDLE' colspan='2'>
$flag=get_div_parent_id($m1); $dflag=$m2; //echo $flag; //echo $dflag; $query2="select count(*) from ibag_transit where (ibtgetdate='$m2' and ibtdestdiv_id=44) and (ibtsourcediv_id=$m1 "; $subquery="SELECT distinct ibtsourcediv_id, ibtgetdate from ibag_transit where (ibtdestdiv_id=44 and (TO_DAYS(NOW()) - TO_DAYS(ibtgetdate))<=10) order by ibtgetdate desc"; $subresult = mysql_query ($subquery) or die ("Query failed1"); while (list($m3 ,$m4)=mysql_fetch_row($subresult)){ if ((get_div_parent_id($m3)==get_div_parent_id($m1)) and ($m4==$m2) and ($m3!=$m1)) { $query2=$query2." or ibtsourcediv_id=$m3"; } } $query2=$query2.")"; //echo $query2; $result2=mysql_query($query2) or die ("Query failed2"); $row2=mysql_fetch_row($result2); $datastr=explode("-",$m2); $strdate=$datastr[2].".".$datastr[1].".".$datastr[0]; $i++; if ($i%2==0)
$strfio = " and c.clientcode like '%{$fio}%'"; } if ($fiop2 == 3) { $strfio = " and c.clientcode like '%{$fio}'"; } if ($fiop2 == 4) { $strfio = " and c.clientcode like '{$fio}%'"; } } $strsearch = $strsearch . $strfio; } if ($cn != "") { $result1 = mysql_query("select div_id from transatlant_db3.div") or die("Query failed"); $strcn = " and (t.ibtsourcediv_id=" . $cn; while (list($d1) = mysql_fetch_row($result1)) { if ($cn == get_div_parent_id($d1)) { $strcn = $strcn . " or t.ibtsourcediv_id=" . $d1; } } $strcn = $strcn . ")"; $strsearch = $strsearch . $strcn; } $result = mysql_query($strsearch) or die("Query failed"); //$result = mysql_query ("select * from transport") // or die ("Query failed"); // printing HTML result $searchstr = ""; $searchstr = $searchstr . $num . "<br>"; $searchstr = $searchstr . $nump1 . "<br>"; $searchstr = $searchstr . $nump2 . "<br>"; $searchstr = $searchstr . $fio . "<br>";