<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>";
