<?php
session_start();

//включаем универсальное подключение к БД
include ( "b_init.phi" );

if ($_GET[ "view" ] !=  1 )  //== блок операций над данными
{
  $a[ "IDClient" ]   = $_POST[ "IDClient" ];
  $a[ "OKS" ]        = $_POST[ "OKS" ];
  $a[ "nullp" ]      = $_POST[ "nullp" ];
  $a[ "TK" ]         = $_POST[ "TK" ];
  $a[ "Error" ]      = $_POST[ "Error" ];
  $a[ "calling" ]    = $_POST[ "calling" ];
  $a[ "TCC" ]        = $_POST[ "TCC" ];
  $a[ "Err" ]        = $_POST[ "Err" ];
  $a[ "NK" ]         = $_POST[ "NK" ];
  $a[ "vid" ]        = $_POST[ "vid" ];
  $a[ "Partner" ]    = $_POST[ "Partner" ];
  $a[ "Easy" ]       = $_POST[ "Easy" ];
  $a[ "ZoneCall" ]   = $_POST[ "ZoneCall" ];
  $a[ "begindate" ]  = $_POST[ "begindate" ];
  $a[ "enddate" ]    = $_POST[ "enddate" ];
  $a[ "sort" ]       = $_POST[ "sort" ];
  $a[ "gate" ]       = $_POST[ "gate" ];
  $a[ "ShowCBSmog" ] = $_POST[ "ShowCBSmog" ];

  //== здесь можно поменять значения переменных, либо выполнить
  //== какие-либо операции по вставке/обновлению в базе  

  $_SESSION[ "param" ][ "adminstat" ] = serialize($a);
  header( "Location: http://" .$_SERVER[ "HTTP_HOST" ].$_SERVER[ "PHP_SELF" ]. "?view=1 ");
  exit;
}

else   //== блок вывода данных

{
  $params = unserialize($_SESSION[ "param" ][ "adminstat" ]);
  $IDClient   = $params[ "IDClient" ];
  $CARD       = $params[ "CARD" ];
  $OKS        = $params[ "OKS" ];
  $nullp      = $params[ "nullp" ];
  $TK         = $params[ "TK" ];
  $Error      = $params[ "Error" ];
  $calling    = $params[ "calling" ];
  $TCC        = $params[ "TCC" ];
  $Err        = $params[ "Err" ];
  $NK         = $params[ "NK" ];
  $vid        = $params[ "vid" ];
  $Partner    = $params[ "Partner" ];
  $Easy       = $params[ "Easy" ];
  $ZoneCall   = $params[ "ZoneCall" ];
  $begindate  = $params[ "begindate" ];
  $enddate    = $params[ "enddate" ];
  $sort       = $params[ "sort" ];
  $gate       = $params[ "gate" ];
  $ShowCBSmog = $params[ "ShowCBSmog" ];


  //включаем универсальную шапку документа
  include ( "b_head.phi" );


  //в этом файле описана функция ShowStat
  include ( "b_ShowStat.php" );


  //загрузка справочника партнеров
  $rs = mssql_query( "SELECT Description,IDPartner FROM partners);
  $PCount = 0 ;
  while ($r = mssql_fetch_row($rs))
  {
    $PName[$PCount] = $r[ 0 ];
    $PIP[$PCount] = $r[ 1 ];
    $PCount++;
  }
  mssql_free_result($rs);

  // установка значений селекторов
  if ($vid == "sl ")  {$Com = " on "; $CAT = "  ";}
  else if ($vid == " pr ")  {$Com = "  ";   $CAT = "  ";}
  else if ($vid == " pro ") {$Com = "  ";   $CAT = "  ";}

  if ($gate != "  ") $gate = 1 ;
  else             $gate =  0 ;

  if ($OKS == "on ")        {$OkOnly = 1 ;     $OKS1 = " checked  ";}
  else                     {$OkOnly = 0 ;     $OKS1 = " ";}
  if ($nullp == " on ")      {$nullp = 1 ;      $OKS2 = " checked  ";}
  else                     {$nullp = 0 ;      $OKS2 = " ";}
  if ($Easy == " on ")       {$Easy = 0 ;       $Easy1 = " checked  ";}
  else                     {$Easy = 1 ;       $Easy1 = " ";}
  if ($ShowCBSmog == " on ") {$ShowCBSmog = 1 ; $ShowCBSmog1 = " checked  ";}
  else                     {$ShowCBSmog = 0 ; $ShowCBSmog1 = " ";}


  echo " <DIV align=\ "center\" >\n\n ";

  // ===================================================
  // ===== ШАПКА С ВЫБОРОМ ФИЛЬТРОВ      ===
  // ===================================================

  echo " <FORM method=\ "POST\"  action=\ "".$_SERVER[" PHP_SELF "]." \ ">\n" ;
  echo  "<INPUT type=\" hidden\ " name=\" IDClient\ " value=\"  ".$IDClient." \ " />\n" ;

  echo  "<TABLE bordercolor=\" #4169E1\ " border=\"  2 \ " cellspacing=\"  0 \ " cellpadding=\"  0 \ ">\n" ;
  echo  "<TR>\n" ;
  echo  "  <TD bgcolor=\" #ccddff\ "> <B>Вид</B></TD>\n" ;
  echo  "  <TD>\n" ;
  echo  "    <TABLE border=\"  0 \ " width=\"  100 %\ " cellspacing=\"  0 \ " cellpadding=\"  1 \ ">\n" ;
  echo  "    <TR bgcolor=\" #ccddff\ ">\n" ;
  if ($vid ==  "pr" ) //простой отчет
  {
    echo  "      <TD align=\" center\ "><INPUT type=\" radio\ " name=\" vid\ " value=\" pr\ " checked />Простой</TD>\n" ;
    echo  "      <TD align=\" center\ "><INPUT type=\" radio\ " name=\" vid\ " value=\" sl\ " />Сводный (по направлениям)</TD>\n" ;
  }
  else //== сводный отчет по направлениям if ($vid ==  "sl" )  
  {
    echo  "      <TD align=\" center\ "><INPUT type=\" radio\ " name=\" vid\ " value=\" pr\ " />Простой</TD>\n" ;
    echo  "      <TD align=\" center\ "><INPUT type=\" radio\ " name=\" vid\ " value=\" sl\ " checked />Сводный (по направлениям)</TD>\n" ;
  }
  echo  "    </TR>\n" ;
  echo  "    </TABLE>\n" ;
  echo  "  </TD>\n" ;
  echo  "  <TD rowspan=\"  5 \ " bgcolor=\" #ccddff\ " align=\" center\ "> <INPUT type=\" submit\ " class=\" wSubmitA\ " name=\" period\ " value=\" показать\ " /> </TD>\n" ;
  echo  "</TR>\n" ;

  echo  "<TR>\n" ;
  echo  "  <TD bgcolor=\" #ccddff\ "> <B>Период,   сортировка</B> </TD>\n" ;
  echo  "  <TD>\n" ;
  echo  "    <TABLE border=\"  0 \ " width=\"  100 %\ " cellspacing=\"  0 \ " cellpadding=\"  1 \ ">\n" ;
  echo  "    <TR>\n" ;
  echo  "      <TD>\n" ;
  echo  "         <INPUT type=\" text\ " class=\" wInputText\ " name=\" begindate\ " size=\"  15 \ " value=\"  ".$begindate." \ " />\n" ;
  echo  "         <B>--</B>  <INPUT type=\"text\" class=\"wInputText\" name=\"enddate\" size=\"15\" value=\"".$enddate."\" /></TD>\n";
 
  echo "      </TD>\n ";
  echo "       <TD align=\ "right\" >\n ";
  echo "         <SELECT name=\ "sort\"  class=\ "wInputText\" >\n ";
  echo "         <OPTION value=\ "CurrentTime\" >Дата</OPTION>\n ";
  echo "         <OPTION value=\ "CalledStationID\" >Куда звонок</OPTION>\n ";
  echo "         <OPTION value=\ "CallingStationID\" >Исходящий номер</OPTION>\n ";
  echo "         </SELECT>\n ";
  echo "       </TD>\n ";
  echo "     </TR>\n ";
  echo "     </TABLE>\n ";
  echo "   </TD>\n ";
  echo " </TR>\n ";

  echo " <TR>\n ";
  echo "   <TD bgcolor=\ "#ccddff\" > <B>Расшифровка</B></TD>\n ";
  echo "   <TD>\n ";
  echo "     <TABLE border=\ "0 \" width=\ "100 %\" cellspacing=\ "0 \" cellpadding=\ "1 \">\n ";
  echo "     <TR>\n ";
  if ($TK != "  ") $chk_str = " checked=\ "checked\"  "; else $chk_str = "  ";
  echo "       <TD><INPUT type=\ "checkbox\"  name=\ "TK\"   ".$chk_str."  />Наимен. зон </TD>\n ";
  if ($gate == 1 ) $chk_str = "checked=\ "checked\"  "; else $chk_str = "  ";
  echo "       <TD><INPUT type=\ "checkbox\"  name=\ "gate\"   ".$chk_str."  />Шлюз </TD>\n ";
  if ($TCC != "  ") $chk_str = " checked=\ "checked\"  "; else $chk_str = "  ";
  echo "       <TD><INPUT type=\ "checkbox\"  name=\ "TCC\"   ".$chk_str."  />Коды возврата </TD>\n ";
  echo "       <TD><INPUT type=\ "checkbox\"  name=\ "Easy\"   ".$Easy1."  /> Подробно </TD>\n ";
//  if ($FH != "  ") $chk_str = " checked=\ "checked\"  "; else $chk_str = "  ";
//  echo "       <TD><INPUT type=\ "checkbox\"  name=\ "FH\"   ".$chk_str."  /> Узел входа </TD>\n ";
  echo "     </TR>\n ";
  echo "     </TABLE>\n ";
  echo "   </TD>\n ";
  echo " </TR>\n ";

  echo " <TR>\n ";
  echo "   <TD bgcolor=\ "#ccddff\" > <B>Фильтр  1 </B> </TD>\n ";
  echo "   <TD>\n ";
  echo "     <TABLE border=\ "0 \" width=\ "100 %\" cellspacing=\ "0 \" cellpadding=\ "1 \">\n ";
  echo "     <TR>\n ";
  echo "       <TD><INPUT type=\ "checkbox\"  name=\ "OKS\"   ".$OKS1." >Зачетные </TD>\n ";
  echo "       <TD><INPUT type=\ "checkbox\"  name=\ "nullp\"   ".$OKS2." >Нул. стоимость </TD>\n ";
  if ($Err != "  ") $chk_str = " checked=\ "checked\"  "; else $chk_str = "  ";
  echo "       <TD><INPUT type=\ "checkbox\"  name=\ "Err\"   ".$chk_str."  />Ошибочные </TD>\n ";
  echo "       <TD><INPUT type=\ "checkbox\"  name=\ "ShowCBSmog\"   ".$ShowCBSmog1."  /> CB \ "мусор\"  </TD>\n ";
  echo "     </TR>\n ";
  echo "     </TABLE>\n ";
  echo "   </TD>\n ";
  echo " </TR>\n ";

  echo " <TR>\n ";
  echo "   <TD bgcolor=\ "#ccddff\" > <B>Фильтр  2 </B> </TD>\n ";
  echo "   <TD>\n ";
  echo "     <TABLE border=\ "0 \" width=\ "100 %\" cellspacing=\ "0 \" cellpadding=\ "1 \">\n ";
  echo "     <TR valign=\ "center\" >\n ";
  echo "       <TD> направление <INPUT type=\ "text\"  name=\ "ZoneCall\"  value=\ "".$ZoneCall." \ " size=\"  8 \ " /></TD>\n" ;
  echo  "      <TD> исх.номер <INPUT type=\" text\ " name=\" calling\ " value=\"  ".$calling." \ " size=\"  8 \ " /></TD>\n" ;
  echo  "      <TD> партнер  \n" ;
  echo  "        <SELECT name=\" Partner\ " class=\" wInputText\ ">\n" ;
  if($Partner ==  "")
    echo "         <OPTION selected value=\ "\" > нет</OPTION>\n ";
  else
    echo "           <OPTION value=\ "\" > нет</OPTION>\n ";
  for($i=0 ; $i<$PCountPr; $i++)
  {
    if ($Partner == $PIPPr[$i])
      echo "          <OPTION selected value=\ "".$PIPPr[$i]." \ "> " .$PNamePr[$i]. "\n" ;
    else
      echo  "          <OPTION value=\"  ".$PIPPr[$i]." \ "> " .$PNamePr[$i]. "\n" ;
  }
  echo  "        </SELECT>\n" ;
  echo  "      </TD>\n" ;
  echo  "    </TR>\n" ;
  echo  "    </TABLE>\n" ;
  echo  "  </TD>\n" ;
  echo  "</TR>\n" ;

  echo  "</TABLE>\n" ;
  echo  "</FORM>\n\n" ;

  // ===================================================
  // =====  САМ ОТЧЕТ (вызов функции)     ===
  // ===================================================

      ShowStat($vid,$nullp,$NK,$CAT,$TCC,$TK,$begindate,$enddate,$IDClient,$OkOnly,$ZoneCall,$Partner,$Easy,$sort,$gate,$calling,$ShowCBSmog);
  
  echo  "</DIV>\n" ;

  echo  "</BODY>\n" ;
  echo  "</HTML>\n" ;

}
?>