Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- //----------------------------------------------
- // functions
- //----------------------------------------------
- //--------------входной параметр rid
- include("minc.php");
- include("minc_2.php");
- global $currdir;
- global $imgdir;
- global $hrefdir;
- //--------------------------------------------------------------------------------
- //------- авторизация
- //--------------------------------------------------------------------------------
- function auth_cab($rid, $login, $pass)
- {
- $sql="select * from TINFO I, TATTR A where A.AID=I.AID and A.ACC=2 and RID='$rid' order by A.AID";
- $result=mysql_query($sql);
- echo mysql_error();
- $au_ok=1;
- if (mysql_num_rows($result)!=0)
- {
- $row=mysql_fetch_array($result);
- $login_t=$row["TEXTF"];
- $row=mysql_fetch_array($result);
- $pass_t=$row["TEXTF"];
- if (($login!=$login_t) || ($pass!=$pass_t))
- {
- print('<form action="recinfo.php" method="post"><table bgcolor="#D4D4D4">');
- print('<tr><td bgcolor="#E4E4E4">Логин: </td><td bgcolor="#E4E4E4"><input type="password" name="login"></td></tr>');
- print('<tr><td bgcolor="#E4E4E4">Пароль:</td><td bgcolor="#E4E4E4"><input type="password" name="pass"></td></tr>');
- print('<tr><td bgcolor="#E4E4E4"><input type="hidden" name="rid" value='.$rid.'></td></tr>');
- print('<tr><td bgcolor="#E4E4E4"><input type="submit" name="submit" value="сохранить"></td>');
- print('<td bgcolor="#E4E4E4"><input type="reset" name="undo"></td></tr>');
- print('</table></form>');
- $au_ok=0;
- }
- //endif
- }
- else
- $au_ok=0;
- //endif
- return($au_ok);
- }
- //---------------------------------------------------------------------------------
- // информация непосредственно о текущей записи
- //---------------------------------------------------------------------------------
- function curr_rec_info($rid)
- {
- //-------------------------------------------------
- $sql = "select * from TRECORDS R, TRECTYPE T, TINFO I, TATTR A ".
- "where R.RTID=T.RTID and A.AID=I.AID and I.RID=R.RID and R.RID='$rid' order by A.AID";
- $result=mysql_query($sql);
- echo mysql_error();
- $row=mysql_fetch_array($result);
- print("<h3>".$row["RTTEXT"]."</h3>");
- $result=mysql_query($sql);
- print('<table border="0" bordercolor="White">');//--------------------2
- while ($row=mysql_fetch_array($result))
- {
- if ($row["ATYPE"]==1) $inform=$row["TEXTF"];
- if ($row["ATYPE"]>10) $inform=$row["TEXTF"];
- if ($row["ATYPE"]==3) $inform=$row["DATEF"];
- if ($row["ATYPE"]==4) $inform=$row["INTF"];
- if ($row["ATYPE"]==5) $inform=$row["TEXTF"];
- if ($row["ATYPE"]==6) $inform=$hrefdir.$row["TEXTF"].'">'.$row["TEXTF"].'</a>';
- if ($row["ATYPE"]==7)
- {
- $iid=$row["IID"];
- $inform='<a href="vieww.php?iid='.$iid.'" target=blank>смотреть</a>';
- }
- //endif
- if ($row["ACC"]==2) $inform='HIDDEN';
- //------------------------
- print('<tr><td bgcolor="#545454"><font color="white">');
- print(' '.$row["ATEXT"].' ');
- print('</font></td>');
- print('<td bgcolor="#E4E4E4">');
- print(' '.$inform.' ');
- print('</td></tr>');
- }
- //WEND
- print('</table>');//--------------------2
- }
- //----------------------------------------------------------------------------------------------
- // информация о группах, включающих данную запись и записи типа send
- //----------------------------------------------------------------------------------------------
- function recinfo_upgroup($rid)
- {
- $sql=" SELECT * from T_GROUPOFREC WHERE RID1='$rid' ";
- $result=mysql_query($sql);
- echo mysql_error();
- $row=mysql_fetch_array($result);
- $aidf=$row["AID"];
- $ridf=$row["RID"];
- $gidf=$row["GID"];
- //--------------------------------------------------
- $result=mysql_query($sql);
- print('<table border="0" bordercolor="White" bgcolor="#F0F0F0">');//--------------------2
- while ($row=mysql_fetch_array($result))
- {
- //------------------------------
- if (($row["AID"]==$aidf)||($row["RID"]!=$ridf))
- {
- print('</td></tr></table>');
- print('<hr color="black"><B>'.$row["RTTEXT"].'</B> | Новости |');
- $gidf=$row["GID"];
- send_info($gidf,$rid,$login,$pass);
- print('<table border="0" bordercolor="White" bgcolor="#F0F0F0">');
- print('<tr><td>');
- $aidf=$row["AID"];
- $ridf=$row["RID"];
- }
- //endif
- //------------------------------------------
- if ($row["ATYPE"]==1) $inform=$row["TEXTF"];
- if ($row["ATYPE"]>10) $inform=$row["TEXTF"];
- if ($row["ATYPE"]==2) $inform=$row["TEXTF"];
- if ($row["ATYPE"]==3) $inform=$row["DATEF"];
- if ($row["ATYPE"]==4) $inform=$row["INTF"];
- if ($row["ATYPE"]==5) $inform=$row["TEXTF"];
- if ($row["ATYPE"]==6) $inform=$hrefdir.$row["TEXTF"].'">'.$row["TEXTF"].'</a>';
- if ($row["ATYPE"]==7)
- {
- $iid=$row["IID"];
- $inform='<a href="vieww.php?iid='.$iid.'" target=blank>смотреть</a>';
- }
- //endif
- //------------------------
- print('<tr><td bgcolor="#848484"><font color="white">');
- print(' '.$row["ATEXT"].' ');
- print('</font></td>');
- print('<td bgcolor="#fafafa">');
- print(' '.$inform.' ');
- print('</td></tr>');
- }
- //WEND
- print('</table>'); //----------------------------2
- }
- //-----------------------------------------------------------------------------------------
- // Добавление записи (в кабинете данных)
- //-----------------------------------------------------------------------------------------
- function add_rec_d($rtid, $rupid, $func,$login,$pass,$view_ref,$auth_rid)
- {
- global $currdir;
- global $imgdir;
- global $hrefdir;
- $sql = "select R.RTID,R.RTTEXT, A.AID, A.ATEXT, A.ATYPE from TRECTYPE R, TATTR A, TTYPEATTR RA ".
- "where RA.AID=A.AID and RA.RTID=R.RTID and R.RTID='$rtid'";
- $result=mysql_query($sql);
- echo mysql_error();
- $row=mysql_fetch_array($result);
- print('<h2>'.$row["RTTEXT"].'</h2>');
- $result=mysql_query($sql);
- print('<form action="addrec1.php" method="post" ENCTYPE="multipart/form-data">');
- print('<table bgcolor="#D4D4D4">');
- $fld=0;
- while ($row=mysql_fetch_array($result))
- {
- $atype=$row["ATYPE"];
- print('<tr>');
- //------------------------
- print('<td bgcolor="#E4E4E4">');
- print($row["ATEXT"]);
- print('</td>');
- //-------------------------
- print('<td bgcolor="#E4E4E4">');
- if ($atype==1) print('<input type="text" name="fld'.$fld.'" size="50">');
- if ($atype>10) print('<input type="text" name="fld'.$fld.'" size="50">');
- if ($atype==2) print('<input type="password" name="fld'.$fld.'">');
- if ($atype==3) print('<input type="text" name="fld'.$fld.'" value="'.Date("Y-m-d").'">');
- if ($atype==4) print('<input type="text" name="fld'.$fld.'">');
- if ($atype==5) print('<input type="text" name="fld'.$fld.'">');
- if ($atype==6) print('<input type="file" name="fldfile">');
- if ($atype==7)
- {
- print('<textarea cols="40" rows="10" name="fld'.$fld.'"></textarea><br>');
- print('Изображение вверху страницы: <input type="file" name="pictop">');
- }
- //endif
- print('<input type="hidden" name="attr'.$fld.'" value="'.$row["AID"].'">');
- print('<input type="hidden" name="atp'.$fld.'" value="'.$atype.'">');
- print('</td>');
- //-------------------------
- print('</tr>');
- $fld++;
- }
- //wend
- $n_fld=$fld;
- print('<tr>');
- print('<td bgcolor="#E4E4E4">');
- print(' Корректный html-код: <input type="checkbox" name="htcode" value="55">');
- print('</td>');
- print('</tr>');
- print('<input type="hidden" name="rtid" value="'.$rtid.'">');
- print('<input type="hidden" name="n_fld" value="'.$n_fld.'">');
- print('<input type="hidden" name="rupid" value="'.$rupid.'">');
- print('<input type="hidden" name="func" value="'.$func.'">');
- print('<input type="hidden" name="login" value="'.$login.'">');
- print('<input type="hidden" name="pass" value="'.$pass.'">');
- print('<input type="hidden" name="view_ref" value="'.$view_ref.'">');
- print('<input type="hidden" name="auth_rid" value="'.$auth_rid.'">');
- print('<tr><td><input type="submit" name="submit" value="сохранить">');
- print('<input type="reset" name="undo"></td></tr>');
- print('</table></form>');
- print('<br>');
- };
- //-----------------------------------------------------------------------------------------
- // Редактирование записи
- //-----------------------------------------------------------------------------------------
- function edit_rec($rid, $rupid, $func, $login, $pass, $view_ref, $auth_rid)
- {
- global $currdir;
- global $imgdir;
- global $hrefdir;
- $sql = "select R.RTID,RT.RTTEXT, A.AID, A.ATEXT, A.ATYPE, I.IID, I.TEXTF, I.INTF, I.DATEF from ".
- " TRECORDS R, TRECTYPE RT, TATTR A, TTYPEATTR RA, TINFO I where ".
- " RA.AID=A.AID and RA.RTID=RT.RTID and I.RID=R.RID and I.AID=A.AID ".
- " and R.RTID= RT.RTID and R.RID='$rid' ORDER BY A.AID";
- $result=mysql_query($sql);
- echo mysql_error();
- $row=mysql_fetch_array($result);
- print('<h2>'.$row["RTTEXT"].'</h2>');
- $result=mysql_query($sql);
- print('<form action="editrec.php" method="post" ENCTYPE="multipart/form-data">');
- print('<table bgcolor="#D4D4D4">');
- $fld=0;
- while ($row=mysql_fetch_array($result))
- {
- $atype=$row["ATYPE"];
- print('<tr>');
- //------------------------
- print('<td bgcolor="#E4E4E4">');
- print($row["ATEXT"]);
- print('</td>');
- //-------------------------
- print('<td bgcolor="#E4E4E4">');
- if ($atype==1) print('<input type="text" name="fld'.$fld.'" size="50" value="'.$row["TEXTF"].'">');
- if ($atype>10) print('<input type="text" name="fld'.$fld.'" size="50" value="'.$row["TEXTF"].'">');
- if ($atype==2) print('<input type="password" name="fld'.$fld.'" value="'.$row["TEXTF"].'">');
- if ($atype==3) print('<input type="text" name="fld'.$fld.'" value="'.$row["DATEF"].'">');
- if ($atype==4) print('<input type="text" name="fld'.$fld.'" value="'.$row["INTF"].'">');
- if ($atype==5) print('<input type="text" name="fld'.$fld.'" value="'.$row["TEXTF"].'">');
- if ($atype==6) print('<input type="file" name="fldfile" >');
- if ($atype==7)
- {
- print('<textarea cols="40" rows="10" name="fld'.$fld.'">');
- $iid_txt=$row["IID"];
- $sql1="SELECT COMMENT FROM TTEXT WHERE IID='$iid_txt'";
- $result1=mysql_query($sql1);
- $row1=mysql_fetch_array($result1);
- print($row1["COMMENT"]);
- print('</textarea><br>');
- print('Изображение вверху страницы: <input type="file" name="pictop">');
- }
- //endif
- print('<input type="hidden" name="atp'.$fld.'" value="'.$atype.'">');
- print('<input type="hidden" name="fiid'.$fld.'" value="'.$row["IID"].'">');
- print('</td>');
- //-------------------------
- print('</tr>');
- $fld++;
- }
- //wend
- $n_fld=$fld;
- print('<tr>');
- print('<td bgcolor="#E4E4E4">');
- print(' Корректный html-код: <input type="checkbox" name="htcode" value="55">');
- print('</td>');
- print('</tr>');
- print('<input type="hidden" name="n_fld" value="'.$n_fld.'">');
- print('<input type="hidden" name="rid" value="'.$rid.'">');
- print('<input type="hidden" name="rupid" value="'.$rupid.'">');
- print('<input type="hidden" name="login" value="'.$login.'">');
- print('<input type="hidden" name="pass" value="'.$pass.'">');
- print('<input type="hidden" name="view_ref" value="'.$view_ref.'">');
- print('<input type="hidden" name="auth_rid" value="'.$auth_rid.'">');
- print('<tr><td><input type="submit" name="submit" value="сохранить">');
- print('<input type="reset" name="undo"></td></tr>');
- print('</table></form>');
- print('<br>');
- };
- //------------------------------------------------------------------------------------------------
- // Главное меню (в кабинете данных)
- //------------------------------------------------------------------------------------------------
- //-------------------------------------------Категории
- function main_menu_d($rid,$func,&$viewiid,&$hiid,$login,$pass,$view_ref,$auth_rid)
- {
- global $currdir;
- global $imgdir;
- global $hrefdir;
- $sql="SELECT * FROM T_CATRECS WHERE RID1='$rid'";
- $result=mysql_query($sql);
- echo mysql_error();
- //-----------------------------------------------------------------------
- print('<table width="100%" cellpadding="0" cellspacing="0" border="0" bgcolor="#000000"><tr><td>');//---1
- print('<table width="100%" cellpadding="0" cellspacing="1" border="0">');
- while ($row=mysql_fetch_array($result))
- {
- //----------------------------------------------------------------------------------
- //----------- Категории
- //----------------------------------------------------------------------------------
- print('<tr>');
- print('<td bgcolor="#EaEaEa" valign=top><font face="Arial">'.$row["GTNAME"].'</font><br>');
- print('<img src="'.$row["IMG_T"].'"><br><br>');
- $rtid_in=$row["RTID2"];
- if (($auth_rid!=0) && ($login!=""))
- //----------------------------------Добавление записи
- print(' '.
- '<a href="'.$view_ref.'?rtid_a='.$rtid_in.
- '&rupid_a='.$rid.'&gdid_a='.$row["GDID"].'&func=2'.'&rid='.$rid.
- '&login='.$login.'&pass='.$pass.'&bkrid='.$bkrid.'&auth_rid='.$auth_rid.
- '">добавить</a> <br><br>');
- //endif
- print('</td>');
- print('<td bgcolor="#EaEaEa">');
- //----------------------------------------------------------------------------------
- //------------ Списки записей
- //----------------------------------------------------------------------------------
- $sql1="SELECT * FROM T_RECQUERY where RID1='$rid' and RTID1='$rtid_in'";
- print('<table border="0" cellspacing="0" cellpadding="0" bgcolor="#C4D0E6"><tr><td>');//--2
- print('<table width="100%" cellpadding="0" cellspacing="1" border="0">');
- //----------------------------------------------------------------------------------
- //--------- заголовки
- //----------------------------------------------------------------------------------
- print('<tr><td bgcolor="#747474"></td>');
- print('<td bgcolor="#747474"></td>');
- print('<td bgcolor="#747474"></td>');
- print('<td bgcolor="#747474"></td>');
- $result1=mysql_query($sql1);
- $row1=mysql_fetch_array($result1);
- $rid_1f=$row1["RID"];
- print('<td bgcolor="#747474"><font color="white">');
- print('</font></td>');
- $i=0;
- //----------------------------------------------------------------------------------
- //------------ заголовки
- //----------------------------------------------------------------------------------
- while (( $row1["RID"]==$rid_1f ) && ($i<10))
- {
- $atext=$row1["ATEXT"];
- //------------------------
- print('<td bgcolor="#747474"><font face="Arial" color="White"> ');
- print($atext);
- print(' </font></td>');
- //-------------------------
- $row1=mysql_fetch_array($result1);
- $i++;
- }
- //wend
- print('</tr>');
- //----------------------------------------------------------------------------------
- //------------------ Данные
- //----------------------------------------------------------------------------------
- $result1=mysql_query($sql1);
- $row1=mysql_fetch_array($result1);
- $iidf=$row1["IID"];
- $aidf=$row1["AID"];
- $ridf=$row1["RID"];
- $result1=mysql_query($sql1);
- print('<tr>');
- //--------------------------------------------------
- while ($row1=mysql_fetch_array($result1))
- {
- if (($row1["RID"]!=$ridf) or ($row1["AID"]==$aidf))
- {
- print('</tr>');
- print('<tr><td></td>');
- //----------------------------------------------------------------------------------
- //---------------- автор записи
- //----------------------------------------------------------------------------------
- $rstr="openWin2('author.php?rid=".$row1["OWNRID"]."')";
- print('<td>'.
- '<img src="inf1.gif" border="0" onclick="'.
- $rstr.'" style="border: none;" alt="Автор записи"></TD>');
- //----------------------------------------------------------------------------------
- //--------------- редактирование и удаление записи
- //----------------------------------------------------------------------------------
- if (($auth_rid!=0) && ($login!=""))
- {
- print('<td><a href="'.$view_ref.'?rid='.$rid.'&rupid_a='.$rid.'&bkrid='.$bkrid.
- '&rid_a='.$row1["RID"].'&func=6'.'&auth_rid='.$auth_rid.
- '&login='.$login.'&pass='.$pass.'">'.
- '<img src="edit.jpg" border="0" style="border: none;" alt="Редактировать"></a></TD>');
- $delstr="if (confirm('Удалить?')) {openWin2('delete1.php?rid=".
- $row1["RID"]."&login=".$login."&pass=".$pass.'&auth_rid='.$auth_rid.
- "&rupid=".$rid."');}";
- print('<td>'.
- '<img src="del.jpg" border="0" onclick="'.$delstr.
- '" style="border: none;" alt="Удалить"></TD>');
- }
- else
- {
- print('<td></td><td></td>');
- }
- //endif
- //----------------------------------------------------------------------------------
- //------------- информация о записи типа папка документов
- //----------------------------------------------------------------------------------
- $view_ref1=$view_ref;
- if ($view_ref1=='recinfo.php')
- $view_ref1='recdatainfo.php';
- //endif
- print('<td bgcolor="#ffffff"> ');
- print('<a href="'.$view_ref1.'?rid='.$row1["RID"].
- '&login='.$login.'&pass='.$pass.'&auth_rid='.$auth_rid.
- '&bkrid='.$rid.
- '"><img src="2.gif" border="0" alt="открыть папку"></a> </td>');
- if ($row1["RID"]!=$ridf)
- {
- $iidf=$row1["IID"];
- $ridf=$row1["RID"];
- $aidf=$row1["AID"];
- }
- //endif
- }
- //endif
- //------------------------------------------------------------------------
- if ($row1["ATYPE"]==1) $inform=$row1["TEXTF"];
- if ($row1["ATYPE"]==2) $inform=$row1["TEXTF"];
- if ($row1["ATYPE"]==3) $inform=$row1["DATEF"];
- if ($row1["ATYPE"]==4) $inform=$row1["INTF"];
- if ($row1["ATYPE"]==5) $inform=$row1["TEXTF"];
- if ($row1["ATYPE"]==6)
- if (strrchr($row1["TEXTF"],"."))
- $inform=$hrefdir.$row1["TEXTF"].
- '" target="blank" ><img src="w.gif" border="0" style="border: none;" alt="">'.
- $row1["TEXTF"].'</a>';
- else
- $inform='';
- //ENDIF
- //ENDIF
- if ($row1["ATYPE"]==7)
- {
- $inform='<a href="'.$view_ref.'?rid='.$rid.
- '&login='.$login.'&pass='.$pass.'&auth_rid='.$auth_rid.
- '&viewiid='.$row1["IID"].'&hiid='.$iidf.'&bkrid='.$bkrid.
- '">смотреть</a>';
- //-----------------------
- if ($viewiid=='')
- {
- $viewiid=$row1["IID"];
- $hiid=$iidf;
- }
- //ENDIF
- //-----------------------
- }
- //ENDIF
- //------------------------
- print('<td bgcolor="#E4E4E4"> ');
- print($inform);
- print('</td>');
- //-------------------------
- }
- //wend
- print('</table></td></tr></table>');
- print('</td>');
- print('</td>');
- print('</tr>');
- }
- //WEND
- print('</table></td></tr></table>');
- print(' </td>');
- }
- //-----------------------------------------------------------------------------------------------------
- // входящая информация от собствен
- //-----------------------------------------------------------------------------------------------------
- // КОНКРЕТНОЙ ГРУППЫ ПО СВЯЗИ TSEND
- //-----------------------------------------
- function send_info($gid_s,$rid,$login,$pass)
- {
- $sql= "SELECT * FROM T_SENDQUERY where GID1='$gid_s'";
- $result=mysql_query($sql);
- echo mysql_error();
- $row=mysql_fetch_array($result);
- $aidf=$row["AID"];
- $ridf=$row["RID"];
- $rtidf=$row["RTID"];
- print('<table>');
- $result=mysql_query($sql);
- print('<tr><td>');
- while ($row=mysql_fetch_array($result))
- {
- if (($row["RID"]!=$ridf) or ($row["AID"]==$aidf))
- {
- print('</td></tr><tr><TD bgcolor="#E0E0E0">');
- if ((($rtidf-1000)!=$row["RTID"]) and ($rtidf!=$row["RTID"]))
- $rtidf=$row["RTID"];
- //endif
- if ($rtidf==$row["RTID"])
- {
- print($row["RTTEXT"].'<br>');
- $rtidf+=1000;
- }
- //endif
- print('<font color="red">'.$row["DATEIN"].'</font></TD>');
- print('<td bgcolor=#f2f2f2>');
- if ($row["RID"]!=$ridf)
- {
- $ridf=$row["RID"];
- $aidf=$row["AID"];
- }
- //endif
- if ($row["STYPE"]==2)
- print(' <a href="linkrecs.php?rid='.$ridf.'&login='.$login.'&pass='.$pass.'&rupid='.$rid.
- '" ><img src="3.gif" style="border: none;" alt="Поместить в портфель"></a>');
- //ENDIF
- if ($row["STYPE"]==3)
- print(' <a href="linkrecs1.php?rid='.$rid.'&login='.$login.'&pass='.$pass.'&rupid='.$ridf.
- '" ><img src="4.gif" style="border: none;" alt="Записаться"></a>');
- //ENDIF
- $i1++;
- }
- //endif
- if ($row["ATYPE"]==1) $inform=$row["TEXTF"];
- if ($row["ATYPE"]==2) $inform=$row["TEXTF"];
- if ($row["ATYPE"]==3) $inform=$row["DATEF"];
- if ($row["ATYPE"]==4) $inform=$row["INTF"];
- if ($row["ATYPE"]==5) $inform=$row["TEXTF"];
- if ($row["ATYPE"]==6)
- if (strrchr($row["TEXTF"],"."))
- $inform=$hrefdir.$row["TEXTF"].'">'.$row["TEXTF"].'</a>';
- else
- $inform='';
- //endif
- if ($row["ATYPE"]==7)
- {
- $iid=$row["IID"];
- $inform='<a href="vieww.php?iid='.$iid.'" target=blank>смотреть</a>';
- }
- //endif
- //------------------------
- print(' ');
- print($inform);
- print(' ');
- //-------------------------
- }
- //wend
- print('</table>');
- }
- //---------------------------------------------------------
- // входящая информация от собствен
- //---------------------------------------------------------
- // КОНКРЕТНОЙ ГРУППЫ ПО СВЯЗИ DOWNUP
- //-----------------------------------------
- function downup_info($rid, $inf_rid,$login,$pass)
- {
- $sql="SELECT * FROM T_DOWNUPQUERY where RID1='$rid' and RID2='$inf_rid'";
- $result=mysql_query($sql);
- echo mysql_error();
- if (mysql_num_rows($result)!=0)
- print('<hr width="50" size="1" color="#C0C5ED">');
- //endif
- $row=mysql_fetch_array($result);
- $aidf=$row["AID"];
- $ridf=$row["RID"];
- print('<table>');
- $result=mysql_query($sql);
- print('<tr>');
- while ($row=mysql_fetch_array($result))
- {
- if (($row["RID"]!=$ridf) or ($row["AID"]==$aidf))
- {
- print('</tr><tr><TD bgcolor="#E0E0E0">'.$row["SCOMM"].
- '<br> <font color="red">'./*$row["DATEIN"].*/'</font></TD>');
- if ($row["RID"]!=$ridf)
- {
- $ridf=$row["RID"];
- $aidf=$row["AID"];
- }
- //endif
- if ($row["STYPE"]==2)
- print('<td><a href="linkrecs.php?rid='.$row["RID"].'&login='.$login.'&pass='.$pass.'&rupid='.$rid.
- '"><img src="3.gif" border="0" style="border: none;" alt="сохранить в портфель"></a></td>');
- //ENDIF
- $i1++;
- }
- //endif
- if ($row["ATYPE"]==1) $inform=$row["TEXTF"];
- if ($row["ATYPE"]==2) $inform=$row["TEXTF"];
- if ($row["ATYPE"]==3) $inform=$row["DATEF"];
- if ($row["ATYPE"]==4) $inform=$row["INTF"];
- if ($row["ATYPE"]==5) $inform=$row["TEXTF"];
- if ($row["ATYPE"]==6) $inform=$hrefdir.$row["TEXTF"].'">'.$row["TEXTF"].'</a>';
- if ($row["ATYPE"]==7) $inform='';
- //------------------------
- print('<td bgcolor="#E4E4E4">');
- print($inform);
- print('</td>');
- //-------------------------
- }
- //wend
- print('</table>');
- }
- //---------------------------------------------------------------------
- // Информация от записей из портфеля
- //---------------------------------------------------------------------
- function downdown_info($rid, $inf_rid,$login,$pass)
- {
- $sql="SELECT * FROM T_DOWNDOWNQUERY where RID1='$rid' and RID2='$inf_rid'";
- $result=mysql_query($sql);
- echo mysql_error();
- if (mysql_num_rows($result)!=0)
- print('<hr width="50" size="1" color="#C0C5ED">');
- //endif
- $row=mysql_fetch_array($result);
- $aidf=$row["AID"];
- $ridf=$row["RID"];
- print('<table>');
- $result=mysql_query($sql);
- print('<tr>');
- while ($row=mysql_fetch_array($result))
- {
- if (($row["RID"]!=$ridf) or ($row["AID"]==$aidf))
- {
- print('</tr><tr>');
- print('<TD bgcolor="#E0E0E0">'.$row["SCOMM"].'</TD>');
- if ($row["STYPE"]==2)
- print('<td><a href="linkrecs.php?rid='.$row["RID"].'&login='.$login.'&pass='.$pass.'&rupid='.$rid.
- '"><img src="3.gif" border="0" style="border: none;" alt="сохранить в портфель"></a></td>');
- else
- print('<td></td>');
- //ENDIF
- if ($row["RID"]!=$ridf)
- {
- $ridf=$row["RID"];
- $aidf=$row["AID"];
- $i1++;
- }
- //endif
- }
- //endif
- if ($row["ATYPE"]==1) $inform=$row["TEXTF"];
- if ($row["ATYPE"]==2) $inform=$row["TEXTF"];
- if ($row["ATYPE"]==3) $inform=$row["DATEF"];
- if ($row["ATYPE"]==4) $inform=$row["INTF"];
- if ($row["ATYPE"]==5) $inform=$row["TEXTF"];
- if ($row["ATYPE"]==6) $inform=$hrefdir.$row["TEXTF"].'">'.$row["TEXTF"].'</a>';
- if ($row["ATYPE"]==7) $inform='';
- //------------------------
- print('<td bgcolor="#E4E4E4">');
- print($inform);
- print('</td>');
- //-------------------------
- }
- //wend
- print('</table>');
- }
- //------------------------------------------------------------------
- // Журнал проведенных операций (записи вкл. в группу)
- //------------------------------------------------------------------
- function oper_report($rid)
- {
- //--------------------------------------Входящая информация подряд
- // Информация включенная в группы данной записи
- //
- //------------------------------------------------------------------
- $dov_rid=0;
- global $currdir;
- global $imgdir;
- global $hrefdir;
- $sql="SELECT * FROM T_REPORTQUERY where RID1='$rid'";
- $result=mysql_query($sql);
- echo mysql_error();
- $row=mysql_fetch_array($result);
- $aidf=$row["AID"];
- $ridf=$row["RID"];
- print('<table width=100%>');
- $result=mysql_query($sql);
- print('<tr>');
- $i1=0;
- while (($row=mysql_fetch_array($result)) && ($i1<5))
- {
- if (($row["RID"]!=$ridf) or ($row["AID"]==$aidf))
- {
- print('</tr><tr><td>'.$row["DATEIN"].'</td><TD bgcolor="#E0E0E0">'.$row["RTTEXT"].
- ' <IMG SRC="'.$row["IMG_T"].'"></TD>');
- //---------------- автор записи
- $rstr="openWin2('author.php?rid=".$row["OWNRID"]."')";
- print('<td>'.
- '<img src="inf1.gif" border="0" onclick="'.
- $rstr.'" style="border: none;" alt="Автор записи"></TD>');
- if ($row["RID"]!=$ridf)
- {
- $ridf=$row["RID"];
- $aidf=$row["AID"];
- }
- //endif
- $i1++;
- }
- //endif
- if ($row["ATYPE"]==1) $inform=$row["TEXTF"];
- if ($row["ATYPE"]==2) $inform=$row["TEXTF"];
- if ($row["ATYPE"]==3) $inform=$row["DATEF"];
- if ($row["ATYPE"]==4) $inform=$row["INTF"];
- if ($row["ATYPE"]==5) $inform=$row["TEXTF"];
- if ($row["ATYPE"]==6) $inform=$hrefdir.$row["TEXTF"].'">'.$row["TEXTF"].'</a>';
- if ($row["ATYPE"]==7) $inform='';
- //------------------------
- print('<td bgcolor="#E4E4E4">');
- print($inform);
- print('</td>');
- //-------------------------
- }
- //wend
- print('</table>');
- print('<a href="0">Весь журнал</a>');
- }
- //--------------------------------------------------------------------------------------------
- // Просмотр ассоциированных записей
- //--------------------------------------------------------------------------------------------
- function view_assoc($rid)
- {
- $sql="select count(*) AS CONLINK,D.DATEIN,D.IID,D.RID,D.AID,D.OWNRID,D.TEXTF,D.DATEF,D.INTF,D.ATYPE ".
- " from TWORDLINK A, TWORDLINK B, T_RECQUERY D ".
- " WHERE A.NWORD=B.NWORD AND ".
- " D.RID=B.RID AND ".
- " A.RID='$rid' ".
- " GROUP BY D.DATEIN,D.IID,D.RID,D.AID,D.OWNRID,D.TEXTF,D.DATEF,D.INTF,D.ATYPE ".
- " HAVING COUNT(*)>1 ORDER BY CONLINK DESC, D.RID desc, D.AID";
- $result=mysql_query($sql);
- echo mysql_error();
- $row=mysql_fetch_array($result);
- $aidf=$row["AID"];
- $ridf=$row["RID"];
- print('<table width=100%>');
- $result=mysql_query($sql);
- print('<tr>');
- $i1=0;
- while (($row=mysql_fetch_array($result)) && ($i1<50))
- {
- if ($row["RID"]!=$ridf)
- {
- print('</tr><tr><td width="60"><font size=-1><B>'.$row["CONLINK"].'</b> &&& '.$row["DATEIN"].
- '</FONT></td><TD bgcolor="#E0E0E0">'.
- $row["RTTEXT"].
- '%%% <a target=blank href="viewcont.php?rid='.$row["RID"].'">Контекст</a> </TD>');
- //---------------- автор записи
- $rstr="openWin2('author.php?rid=".$row["OWNRID"]."')";
- print('<td>'.
- '<img src="inf1.gif" border="0" onclick="'.
- $rstr.'" style="border: none;" alt="Автор записи"></TD>');
- $ridf=$row["RID"];
- $aidf=$row["AID"];
- $i1++;
- }
- else
- if ($row["AID"]==$aidf)
- {
- print('</tr><tr><td width="60"><font size=-1><B>'.$row["CONLINK"].'</b> &&& '.$row["DATEIN"].
- '</FONT></td><TD bgcolor="#E0E0E0">'.
- $row["RTTEXT"].
- '%%% <a href="viewcont.php?rid='.$row["RID"].'">Контекст</a> </TD>');
- //---------------- автор записи
- $rstr="openWin2('author.php?rid=".$row["OWNRID"]."')";
- print('<td>'.
- '<img src="inf1.gif" border="0" onclick="'.
- $rstr.'" style="border: none;" alt="Автор записи"></TD>');
- $i1++;
- }
- //endif
- //endif
- if ($row["ATYPE"]==1) $inform=$row["TEXTF"];
- if ($row["ATYPE"]==2) $inform=$row["TEXTF"];
- if ($row["ATYPE"]==3) $inform=$row["DATEF"];
- if ($row["ATYPE"]==4) $inform=$row["INTF"];
- if ($row["ATYPE"]==5) $inform=$row["TEXTF"];
- if ($row["ATYPE"]==6)
- if (strrchr($row["TEXTF"],"."))
- $inform=$hrefdir.$row["TEXTF"].'">'.$row["TEXTF"].'</a>';
- else
- $inform='';
- //endif
- //endif
- if ($row["ATYPE"]==7)
- {
- $iid=$row["IID"];
- $inform='<a href="vieww.php?iid='.$iid.'" target=blank>смотреть</a>';
- }
- //endif
- //------------------------
- print('<td bgcolor="#E4f4f5">');
- print('<font size=-1>');
- print($inform);
- print('</font>');
- print('</td>');
- //-------------------------
- }
- //wend
- print('</table>');
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement