Bi-Dir

QL_eszmei.inc

Line #0:<?php
Line #1:
Line #2:if (isset($_GET[nyomtat])) {
Line #3:?>
Line #4:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #5:<?PHP
Line #6:$br="</td><td>";
Line #7:} else {
Line #8:include("../_inc_QJ/QC_evhoSELECT.inc");
Line #9:$_SESSION[QC_eszmeiWERevho]=$werEVHO;
Line #10:$br=" ";
Line #11:}
Line #12:
Line #13:
Line #14:IF ($_SESSION[admin]<>"ADMIN") $archiv=" archiv <>'*' "; else $archiv=" future <>'*'";
Line #15:
Line #16:$archiv=" wid>0";
Line #17:$archiv=" future<>'*' ";
Line #18:
Line #19:$login=$_SESSION[login];
Line #20:IF (isset($_POST[sqlord])) $ord = " DESC"; else $ord="";
Line #21:if (isset($_SESSION[CALL_mezo])) $mezo=$_SESSION[CALL_mezo]; else $mezo="datum";
Line #22:if (isset($_SESSION[CALL_ord])) $ord=$_SESSION[CALL_ord]; else $ord="";
Line #23:
Line #24:$keres = "SELECT * FROM qj_musor where $archiv $_SESSION[QC_eszmeiWERevho] ORDER BY $mezo $ord ";
Line #25:
Line #26:
Line #27:$nur=mysql_num_rows($eredmeny);
Line #28:
Line #29:
Line #30:$L_PHP="QJ_eszmei.php";
Line #31:include("QJ_listafej.php");
Line #32:
Line #33:echo "<table border=1 width=100%>
Line #34:<tr bgcolor=silver>
Line #35:
Line #36:
Line #37:
Line #38:
Line #39:
Line #40:
Line #41:</tr>";
Line #42:
Line #43:$mindosszFT=0;
Line #44:$mindosszDB=0;
Line #45:$i=0;
Line #46:while ( $musor = mysql_fetch_array( $eredmeny ) )
Line #47:{
Line #48:++$i;
Line #49:
Line #50:$helyszin_kod=$musor[hely_kod];
Line #51:$datum_kod=$musor[datum_kod];
Line #52:$wjid=$musor[wid];
Line #53:
Line #54:$SQLszek = "SELECT * FROM qj_szek WHERE hely_kod='".$helyszin_kod.
Line #55:"' and archiv='-' and not instr(qj_sor_n,'*EOF') ORDER BY szek_kod";
Line #56:
Line #57:
Line #58:$nur=mysql_num_rows($szekek);
Line #59:$kati[1]=0;
Line #60:$kati[2]=0;
Line #61:$kati[3]=0;
Line #62:while ( $szeksor = mysql_fetch_array( $szekek ))
Line #63:{
Line #64:if ($szeksor[qj_katind]<2) $ki=1; else $ki=$szeksor[qj_katind];
Line #65:$kati[$ki]=$kati[$ki]+1;
Line #66:}
Line #67:
Line #68:$cimkieg="";
Line #69:if($musor[cimkieg1]<>"" ) $cimkieg.="$br".$musor[cimkieg1]."";
Line #70:if($musor[cimkieg2]<>"" ) $cimkieg.="$br".$musor[cimkieg2]."";
Line #71:
Line #72:
Line #73:
Line #74:
Line #75:
Line #76:
Line #77:$Redit="<a target=adatframe href=QJ_musorEDIT.php?&wjid=$wjid><img src='../_Screen/edit.png' border=0></a>$br";
Line #78://$Nedit="<a target=adatframe href=QJ_musorCOPY.php?&wjid=$wjid><img src='../_Screen/plus.ico' border=0></a>";
Line #79://$edit="<a target=adatframe href=QJ_helyszinZAR.php?&datum_kod=$datum_kod>$wjid</a> ";
Line #80:
Line #81:$Redit="<a target=adatframe href=QJ_musorPUBLIC.php?&wjid=$wjid><img src='../_Screen/edit.png' border=0></a>$br";
Line #82:
Line #83:$ref1="<a target=adatframe href=QJ_helyrajz.php?&musor_kod=$datum_kod target=adatframe>$musor[cim]</a>$cimkieg";
Line #84:$ref1="$musor[cim]$cimkieg";
Line #85:
Line #86://$ref2="<a target=adatframe href=QJ_helyszinZAR.php?&datum_kod=$datum_kod><a>";
Line #87://$ref3="<a target=adatframe href=QJ_atforgat.php?&musor_kod=$datum_kod>$musor[szoveg]</a>";
Line #88://$ref4="<a target=adatframe href=QJ_helyszinOSZ.php?&hely_kod=$helyszin_kod&datum_kod=$datum_kod target=adatframe>
Line #89://$musor[helyszin]</a>";
Line #90:
Line #91:$ref4=$musor[helyszin];
Line #92:
Line #93://$ref3="<a target=adatframe href=QJ_EFforgat.php?&musor_kod=$datum_kod>$musor[berlet_kod]</a>";
Line #94:
Line #95:
Line #96:$kati[0]=$kati[1]+$kati[2]+$kati[3];
Line #97:$osszFT=$musor[alapar1]*$kati[1]+$musor[alapar2]*$kati[2]+$musor[alapar3]*$kati[3];
Line #98:
Line #99:
Line #100:include("../_inc_QJ/QB_musorREL.inc");
Line #101:
Line #102:
Line #103:if (isset($_GET[nyomtat])) { $relFULL1=""; $relFULLbi=""; }
Line #104:
Line #105:$kati[0]=$kati[0];
Line #106:if ($kati[0]==0) $atlagar=0; ELSE $atlagar=$osszFT/$kati[0];
Line #107:
Line #108:echo"<tr>
Line #109:<td align=left >$musor[datum_kod]$br
Line #110:$musor[helyszin]$br
Line #111:$musor[datum] $erkezesi</td>
Line #112:<td align=right > $ref1
Line #113:$relFULL1 $relFULLbi
Line #114:</td>
Line #115:<td align=right bgcolor=yellow >".$kati[0]."$br".Bi_number_format($osszFT)."</td>
Line #116:<td align=right >".$kati[1]."$br".Bi_number_format($musor[alapar1])."</td>
Line #117:<td align=right >".$kati[2]."$br".Bi_number_format($musor[alapar2])."</td>
Line #118:<td align=right >".$kati[3]."$br".Bi_number_format($musor[alapar3])."</td>
Line #119:</tr>";
Line #120:
Line #121:$SQL = "UPDATE `qj_musor` SET
Line #122: `sum_keszlet`='$kati[0]'
Line #123: WHERE hely_kod='".$helyszin_kod."'";
Line #124:$sor=mysql_query($SQL) or die($SQL." Hiba !");
Line #125:
Line #126:$mindosszFT=$mindosszFT+$osszFT;
Line #127:$mindosszDB=$mindosszDB+$kati[0];
Line #128:
Line #129:}
Line #130:
Line #131:$atlagar=$mindosszFT/$mindosszDB;
Line #132:
Line #133:echo"<tr bgcolor=silver>
Line #134:
Line #135:
Line #136:<td align=right >".
Line #137:Bi_number_format($mindosszDB)."$br".Bi_number_format($mindosszFT)."</td>
Line #138:<td align=right colspan=10> </tr>";
Line #139:
Line #140:echo "</table>";
Line #141:
Line #142:if (isset($_GET[nyomtat])) {
Line #143:include("QJ_listaveg.php");
Line #144:?>
Line #145:<SCRIPT Language="Javascript">
Line #146:
Line #147:window.print();
Line #148:///////////////////////////////////////
Line #149://window.open("QJ_felad.php", 'sframe');
Line #150:///////////////////////////////////////
Line #151:
Line #152:
Line #153:</script>
Line #154:<?PHP
Line #155:}
Line #156:
Line #157:
Line #158: function Bi_number_format($bi_num)
Line #159: ////////
Line #160: {
Line #161: if (isset($_GET[nyomtat]))
Line #162: return $bi_num;
Line #163: else
Line #164: return number_format($bi_num);
Line #165: }
Line #166:
Line #167:
Line #168://-%-// QJ_eszmei.php
Line #169:
Line #170:?>