<?
if($_REQUEST['mod_group'] || $id_group > 0 || $_REQUEST['p']>0){$txts_once = "";}
echo $txts_once;
?>
<style>
.th{
    background-color:#eee;
    text-align:center;
}
.coll{
    margin:5px;
    width:130px;
    float:left;
}
.clear{
    clear:both;
}

#zakaz_form{
    position:fixed;
    left:50%;
    top:100px;
    //position:absolute;
    top: expression(100 + ( ignoreMe = document.documentElement.scrollTop ? document.documentElement.scrollTop : document.body.scrollTop ) + "px" );
    margin-left:-235px;
    width:570px;
    background-color:#FFF;
    border: solid 1px #999;
    padding:10px;
    background-color:#CCC;
}
</style>
<div id="zakaz_form" style="display:none;" >&nbsp;</div>
<?
//print_r($_GET);

$params_name=array('mod', 'id_group', 'gost', 'mod_group');
$add_to_link=array();
foreach($params_name as $k=>$v){
if($$v){$add_to_link[]=$v."=".urlencode($$v);}
}
$add_to_link=join("&",$add_to_link);

$group_filtr=array();
$gost_filtr=array();
$query="SELECT gost  FROM tovar where gost<>'' group by gost order by gost asc";
if(!$result=mysql_query($query)){echo mysql_error(); return false;}
while($row=mysql_fetch_object($result)){
$gost_sel=stripslashes($row->gost);
$gost_filtr[rawurlencode($gost_sel)]=$gost_sel;
}

$query="SELECT *  FROM  tovar_group where name<>'' order by name";
if(!$result=mysql_query($query)){echo mysql_error(); return false;}
if(mysql_num_rows($result)>0){
    $i=0;
?>
<ul class="coll" >
<?
while($row=mysql_fetch_object($result)){
    $i++;
    $id_group_sel=stripslashes($row->id);
    $group_name=stripslashes($row->name);
    $group_name_id=stripslashes($row->name_id);
    $group_name=preg_replace("/Комплект/"," Комплект крепежа ",$group_name);

    $group_title=stripslashes($row->title);
    $group_keywords=stripslashes($row->keywords);
    $group_description=stripslashes($row->description);

    $group_filtr[$id_group_sel]=$group_name;
    $style="";

    if($id_group==$id_group_sel  || ( ($group_name_id == $mod_group) && $group_name_id) ){
        $seo_title=$group_name;
        if($group_title){$seo_title=$group_title;}
        if($group_keywords){$seo_keywrds=$group_keywords;}
        if($group_description){$seo_descr=$group_description;}
        $style="style=\"color:#F00;\"";
        }

    $link="/tovar_group_$id_group_sel.html";
    if($group_name_id){$link="/catalog_$group_name_id.html";}
    ?>
   <li><a href="<?=$link?>" <?=$style?>><?=$group_name?></a></li>
    <?
    if(!($i%10)){?>
    </ul>
    <ul class="coll" >
<? }
}
?>
</ul>
<div class="clear">&nbsp;</div>

<div id="zakaz_cart" ></div>
<script type="text/javascript">
ajax_text_to_div('/modules/zakaz_cart.php','zakaz_cart');
</script>
<?
}


$pages=25;
$p=(int)$_GET['p'];
if(!$p){$p=1;}
$offset=(int)($p-1)*$pages;

$sql_filtr="";
$gost=addslashes($_GET['gost']);
if($gost){$sql_filtr.=" AND T.gost='$gost' ";}
if((int)$id_group){$sql_filtr.=" AND TG.id='$id_group' ";}
if($mod_group){$sql_filtr.=" AND TG.name_id LIKE '$mod_group' ";}
$query="SELECT count(*) FROM tovar T, tovar_group TG where T.id_group=TG.id $sql_filtr";
if(!$result=mysql_query($query)){echo mysql_error(); return false;}
$count=mysql_result($result,0);

$query="SELECT T.id, TG.name as group_name, T.artikul, T.name, T.gost, T.value, T.tara, T.info FROM tovar T, tovar_group TG where T.id_group=TG.id $sql_filtr order by TG.name asc, T.name asc  limit $offset, $pages";

if(!$result=mysql_query($query)){echo mysql_error(); return false;}
if($count>0){
Page_List($count, $pages);
?>
<table width="100%" border="1" cellspacing="0" cellpadding="3" style="font-size:12px; border-collapse:collapse; border-color:#CCC; margin:10px 0;">
  <tr>
    <td  class="th">Артикул</td>
    <td class="th" style="width:100px; height:30px;" >
   <span id="filtr_group_link"><a href="#" onclick="rele_div('filtr_group_div'); rele_div('filtr_group_link'); return false;">Группа</a></span>
    <span id="filtr_group_div" style="display:none;">
    <select onchange="rele_div('filtr_group_div'); rele_div('filtr_group_link'); document.location='/?id_razdel=<?=$id_razdel?>&id_group='+this.value" class="border_input" style="width:94px;">
    <option value="">Группа отменить</option>
    <? foreach($group_filtr as $k => $v){  ?>
    <option <? if((int)$id_group==$k){ ?> selected="selected" <? } ?>  value="<?=$k?>"><?=$v?></option>
    <? } ?>
    </select>
    </span>
    </td>
    <td class="th">Наименование</td>
    <td class="th">Единица измерения</td>
    <td class="th">Вес</td>
    <td class="th" style="width:100px; height:30px;">
    <span id="filtr_gost_link"><a href="#" onclick="rele_div('filtr_gost_div'); rele_div('filtr_gost_link'); return false;">ГОСТ</a></span>
    <span id="filtr_gost_div" style="display:none;">
    <select onchange="rele_div('filtr_gost_div'); rele_div('filtr_gost_link'); document.location='/?id_razdel=<?=$id_razdel?>&gost='+this.value" class="border_input" style="width:94px;">
    <option value="">ГОСТ  отменить</option>
    <? foreach($gost_filtr as $k => $v){  ?>
    <option <? if($gost==$v){ ?> selected="selected" <? } ?> value="<?=$k?>"><?=$v?></option>
    <? } ?>
    </select>
    </span>
    </td>
    <td class="th">Дополнительно</td>
    <td class="th">Операции</td>
  </tr>
<?
$row_tr=0;
while($row=mysql_fetch_object($result)){
    $row++;
    $id_tovar=$tovar_id=(int)stripslashes($row->id);
    $tovar_name=stripslashes($row->name);
    $tovar_group_name=stripslashes($row->group_name);
    $tovar_group_name=str_replace("Комплект","Комплект крепежа",$tovar_group_name);
    $tovar_name=$tovar_group_name." ".$tovar_name;
    $tovar_name=preg_replace("/^(ОГ|ГО)/"," Отвод гнутый ",$tovar_name);
    $tovar_name=str_replace("Комплект крепежа крепежа","Комплект крепежа",$tovar_name);

    //$tovar_name=preg_replace("/^Комплект$/"," Комплект крепежа ",$tovar_group_name)." ".$tovar_name;
    $tovar_artikul=stripslashes($row->artikul);
    $tovar_value=stripslashes($row->value);
    $tovar_tara=stripslashes($row->tara);
    $tovar_gost=stripslashes($row->gost);
    $tovar_info=stripslashes($row->info);

$count_tov=0;
$cart_off='';
$cart_on='none';
if($_SESSION['cart']){
foreach ($_SESSION['cart'] as $pkey => $pgoods){
if($pgoods['id'] == $id_tovar){
$count_tov=$pgoods['count'];
$cart_off='none';
$cart_on='';
break;
}
}
}
?>

  <tr id="tr_zakaz_<?=$row_tr?>" onmouseover="this.style.backgroundColor='#eeeeee';" onmouseout="this.style.backgroundColor='#ffffff';">
    <td><?=sprintf("%08s",$tovar_artikul)?></td>
    <td  nowrap="nowrap"><?=$tovar_group_name?></td>
    <td><?=$tovar_name?></td>
    <td><?=$tovar_value?></td>
    <td><?=sprintf("%01.2f",$tovar_tara)?></td>
    <td><?=$tovar_gost?></td>
    <td><?=$tovar_info?></td>
    <td nowrap="nowrap">
  <input type="text" class="border_input"  style="width:30px;" id="count_tovar_<?=(int)$id_tovar?>"  value="<?=(int)$count_tov?>" onfocus="if(this.value==0){this.value='';}" />
 <span id="<?=$id_tovar?>_off" style="display:<?=$cart_off?>;"><a href="#" onclick="add_tovar_count(<?=(int)$id_tovar?>); return false;">Добавить</a></span>
  <span id="<?=$id_tovar?>_on"  style="display:<?=$cart_on?>;"><a href="#" onclick="del_tovar(<?=(int)$id_tovar?>); return false;">Удалить</a></span>
    </td>
  </tr>
<?
}
?>
</table>
<?
//"SELECT R.Id, R.Model, R.Foto FROM rezina R, (select model from rezina where foto<>'' group by model) as R1 WHERE R.foto='' AND R.model=R1.model ";
}
?>