"; exit; } $str_main=new XTemplate("templates/main.tpl", "main"); $query=trim($query); If ($query=="") { $query="1^"; } $query=explode(';',strip_tags(addslashes(trim($query)))); $zapr="select * from docc"; $ass=$query[count($query)-1]; $ass=explode('^',$ass); $query[count($query)-1]=$ass[0]; if ($ass[1]=="8") { $da=explode('-',$ass[2]); $da_1=explode('.',$da[0]); $da_1=$da_1[2].'-'.$da_1[1].'-'.$da_1[0]; $da_2=explode('.',$da[1]); $da_2=$da_2[2].'-'.$da_2[1].'-'.$da_2[0]; $zapr_da="('$da_1'<=date_creation) and (date_creation<='$da_2')"; } if (($ass[1]!="8") and ($ass[1]!="1")) { If ($ass[2]!="") { $zapr_razd="(id_razdela='$ass[1]') and (number_='$ass[2]')"; } else { $zapr_razd="(id_razdela='$ass[1]')"; } } for ($i=0;$i<=count($query)-1;$i++) { $zapr_q=$zapr_q."(type_='$query[$i]') or "; } $q=strrpos($zapr_q, " or "); $zapr_q=substr($zapr_q, 0, $q-3); If ($ass[1]=="1") //общий { $zapr=$zapr." where (uses='A') order by date_creation DESC"; ; } ElseIf (($query[count($query)-1]!="") and ($ass[1]=="")) //типы { $zapr=$zapr." where (".$zapr_q.") and (uses='A') order by date_creation DESC"; ; } ElseIf (($query[count($query)-1]!="") and ($ass[1]=="8")) // типы и дата { $zapr=$zapr." where "."(".$zapr_q.")"." and ".$zapr_da; $zapr=$zapr." and (uses='A') order by date_creation DESC"; } ElseIf (($query[count($query)-1]!="") and ($ass[1]!="8")) // типы и раздел { $zapr=$zapr." where "."(".$zapr_q.")"." and ".$zapr_razd; $zapr=$zapr." and (uses='A') order by date_creation DESC"; } ElseIf (($query[count($query)-1]=="") and ($ass[1]=="8")) // дата { $zapr=$zapr." where ".$zapr_da; $zapr=$zapr." and (uses='A') order by date_creation DESC"; } ElseIf (($query[count($query)-1]=="") and ($ass[1]!="8")) // раздел { $zapr=$zapr." where ".$zapr_razd; $zapr=$zapr." and (uses='A') order by date_creation DESC"; } $docum=mysql(DBName, $zapr); $all_docum=mysql_numrows($docum); For ($i=0;$i<=$all_docum-1;$i++) { $str_main->Assign("name", strtoupper(mysql_result($docum, $i, "name"))); $str_main->Assign("whereis", mysql_result($docum, $i, "whereis_")); $type=mysql_result($docum, $i, "id_razdela"); switch ($type) { case "2" : $typee="Наказ МОН"; break; case "3" : $typee="Наказ НМЦ"; break; case "4" : $typee="Лист МОН"; break; case "5" : $typee="Лист НМЦ"; break; case "6" : $typee="Розпорядження Президента"; break; case "7" : $typee="Наказ Президента"; break; case "8" : $typee=""; break; } $date=mysql_result($docum, $i, "date_creation"); $date=explode('-',$date); $date=$date[2].'-'.$date[1].'-'.$date[0]; $number=mysql_result($docum, $i, "number_"); if ($number!="") { $number=" №".$number; } $str_main->Assign("number", $typee." вiд ".$date.$number); //--парсим додатки $id=mysql_result($docum, $i, "id_doc"); $dod=mysql(DBName, "select * from dod where id_doc='$id'"); $all_dod=mysql_numrows($dod); For ($j=0;$j<=$all_dod-1;$j++) { $pa=mysql_result($dod, $j, "whereis"); $str_main->Assign("dod_whereis", $pa); $typpe=substr($pa, count($pa)-4, 3); If ($typpe=="doc") { $typpe="word_icon.gif\" width=\"10\" height=\"10\""; } Else { $typpe="dot.gif\" width=\"5\" height=\"7\""; } $str_main->Assign("typpe", $typpe); $str_main->Assign("dod_doc_name", mysql_result($dod, $j, "name")); $str_main->parse("main.doc.dod_name_doc"); } $str_main->parse("main.doc"); } $str_main->parse("main"); $str_main->QuickPrint("main"); ?>