QJ_webgyujto.old
Line #0:<?php /*Qjegy2010v02-010 */
Line #1:
Line #2:IF (isset($_POST[email]) and $_SESSION[webemail]==$_POST[email]) $_POST[email]="*";
Line #3:IF (isset($_POST[nap]) and $_SESSION[webnap]==$_POST[nap] ) $_POST[nap]="*";
Line #4:
Line #5:$_SESSION[webnap]=$_POST[nap];
Line #6:$_SESSION[webemail]=$_POST[email];
Line #7:
Line #8:
Line #9:
Line #10:
Line #11:$osft=0;
Line #12:$osdb=0;
Line #13:
Line #14:
Line #15:$disQ = "SELECT distinct bizomanyos FROM qj_weblog where future<>'*' order by bizomanyos" ;
Line #16:
Line #17:
Line #18:$sel2="<SELECT TITLE='e-Mail cim'
Line #19:onchange=this.form.submit(); return true name='email'>";
Line #20:
Line #21:
Line #22:
Line #23:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #24:if ($disC[bizomanyos]==$_POST[email]) $sel="SELECTED"; else $sel="";
Line #25:$sel2.="<option value='".$disC[bizomanyos]."' $sel >".$disC[bizomanyos]."</option>";
Line #26://echo($disC[hely_kod]."/".$disC[helyszin]."<hr>");
Line #27:}
Line #28:
Line #29:$sel2.="</SELECT>";
Line #30:
Line #31:
Line #32:$disQ = "SELECT distinct status FROM qj_weblog where future<>'*' " ;
Line #33:
Line #34:
Line #35:$sel3="<SELECT TITLE='Nap'
Line #36:onchange=this.form.submit(); return true name='datum_fej'>";
Line #37:
Line #38:
Line #39:
Line #40:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #41:if ($disC[datum_fej]==$_POST[datum_fej]) $sel="SELECTED"; else $sel="";
Line #42:$sel3.="<option value='".$disC[datum_fej]."' $sel >".$disC[datum_fej]."</option>";
Line #43:}
Line #44:
Line #45:$sel3.="</SELECT>";
Line #46:
Line #47:$disQ = "SELECT logtime FROM qj_weblog where future<>'*' order by logtime DESC" ;
Line #48:
Line #49:
Line #50:
Line #51://echo($disQ."<hr>");
Line #52:
Line #53:
Line #54:onchange=this.form.submit(); return true name='nap'>";
Line #55:
Line #56:
Line #57:$nap="?";
Line #58:
Line #59:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #60:$Wnap=substr($disC[logtime],0,10);
Line #61:
Line #62:if ($nap<>$Wnap ) {
Line #63:$nap=$Wnap;
Line #64:if ($nap==$_POST[nap]) $sel="SELECTED"; else $sel="";
Line #65:$sel1.="<option value='".$nap."' $sel >". $nap."</option>";
Line #66:}
Line #67:}
Line #68:
Line #69:$sel1.="</SELECT>";
Line #70:
Line #71:
Line #72:
Line #73:
Line #74:////////////////
Line #75:
Line #76:$fajlnev="qj_weblog";
Line #77:
Line #78:$_SESSION[CimUp]="QJ_kijelol.php";
Line #79:
Line #80:
Line #81:echo(" <a href=QJ_gyujto.php?&lista=1 target=sframe>Vissza...</a>");
Line #82:
Line #83:echo("<FORM name=cimform target=adatframe action='QJ_webgyujto.php' method='post'>".$sel1." ".$sel2." ");
Line #84:
Line #85:echo("
Line #86:<input type='submit' value='>>>' name='submit'>
Line #87:
Line #88:</form>");
Line #89:
Line #90:
Line #91:echo "<table border=1>
Line #92:<tr bgcolor=silver>
Line #93:<td align=right ><b></b></td>
Line #94:<td align=right ><b>Db</b></td>
Line #95:<td align=right ><b>Ft</b></td>
Line #96:
Line #97:
Line #98:
Line #99:
Line #100:
Line #101:
Line #102:
Line #103:
Line #104:IF (isset($_POST[email]) and $_POST[email]<>"*") { $wer=" and bizomanyos='".$_POST[email]."'";}
Line #105:else $wer="";
Line #106:
Line #107:IF (isset($_POST[nap]) and $_POST[nap]<>"*") { $wer=" and left(logtime,10)='".$_POST[nap]."'";}
Line #108:
Line #109:$szin="red";
Line #110:$parancs="SELECT * FROM qj_weblog where future<>'*' $wer ORDER BY logtime DESC";
Line #111:
Line #112:
Line #113:$i=0;
Line #114:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #115:{
Line #116:
Line #117:$wjid=$egy_sor[wid];
Line #118:
Line #119:$SQLszek = "SELECT wid FROM qj_jegy WHERE bizonylatszam='WEB:".$wjid."' limit 1 ";
Line #120:
Line #121:
Line #122:$nur=mysql_num_rows($szekek);
Line #123:if ($nur==0) {
Line #124:$SQLszek = "SELECT wid,bizonylatszam FROM qj_jegy WHERE kosar_kod='Qjegy:".$wjid."' limit 1 ";
Line #125:
Line #126:
Line #127:$m_sor = mysql_fetch_array( $szekek );
Line #128:
Line #129:$kosar="<A STYLE='{vlink : gold}'
Line #130:target=sframe href='QJ_analitika.php?&bizonylat=".$m_sor[bizonylatszam]."'>
Line #131:
Line #132:
Line #133:if ($egy_sor[future]<>"*") {
Line #134:$parancs = "UPDATE `qj_weblog` SET `arforma`='nyomtatva',`uzenet`='".$egy_sor[future]."',`future`='*',`logtime`='".$egy_sor[logtime]."' WHERE `wid`='".$egy_sor[wid]."'";
Line #135:
Line #136:}
Line #137:
Line #138:
Line #139:} else {
Line #140:$kosar="<A STYLE='{vlink : gold}'
Line #141:target=sframe href='QJ_web.php?&bizonylat=".$egy_sor[wid]."'>
Line #142:
Line #143:
Line #144:$ho=substr($egy_sor[logtime],5,2);
Line #145:$ev=substr($egy_sor[logtime],0,4);
Line #146:$nap=substr($egy_sor[logtime],8,2);
Line #147:
Line #148:$tomorrow = mktime (0,0,0,$ho,($nap+7),$ev);
Line #149:
Line #150://$lastmonth = mktime (0,0,0,date("m")-1,date("d"), date("Y"));
Line #151://$nextyear = mktime (0,0,0,date("m"), date("d"), date("Y")+1);
Line #152:$lejart=date("Y-m-d",$tomorrow);
Line #153:$mai=date("Y-m-d");
Line #154:
Line #155:if ($lejart<$mai and substr($egy_sor[lejarat],0,2)=="00") {
Line #156:
Line #157:
Line #158:}
Line #159:
Line #160:}
Line #161:
Line #162:
Line #163: $rel="QJ_okmail.php?&ID=";
Line #164: $relA="QJ_web.php";
Line #165:
Line #166:
Line #167:
Line #168:
Line #169:$ir="<tr>
Line #170:<td align=right >
Line #171:$kosar
Line #172:</td>
Line #173:
Line #174:<td align=right ><b><font color=$szin>".number_format( $egy_sor[osszdb])."</font></b></td>
Line #175:<td align=right ><b><font color=$szin>".number_format( $egy_sor[osszft])."</font></b></td>
Line #176:<td align=right><font color=blue><b>$egy_sor[wid]</b></font></td>
Line #177:<td >$egy_sor[status]</td>
Line #178:<td $szin>$egy_sor[arforma]</td>
Line #179:<td >$egy_sor[logtime]</td>
Line #180:<td ><a target=infoframe href=$rel$egy_sor[wid]>
Line #181:
Line #182:<td >$egy_sor[bizomanyos]</td>
Line #183:";
Line #184:
Line #185:$vevokod=$egy_sor[vevokod];
Line #186:$vevoker="";
Line #187:
Line #188:if ($vevokod>0) {
Line #189:$vevoker = "SELECT * FROM qj_cimtar WHERE wid=".$vevokod;
Line #190:
Line #191:$ct_sor = mysql_fetch_array($ctar);
Line #192:
Line #193:if ($ct_sor[telepules].$ct_sor[cim]=="") $info1=""; else
Line #194:$info1="<br><b>$ct_sor[telepules]</b> $ct_sor[cim]";
Line #195:
Line #196:if ($ct_sor[telszam].$ct_sor[uzenet]=="") $info2=""; else
Line #197:$info2="<br><b>$ct_sor[telszam]</b> $ct_sor[uzenet]";
Line #198:
Line #199:
Line #200:$ref="<a target=sframe href=QJ_elojegyzesek.php?&full=Y&vevo=$vevokod>
Line #201:
Line #202:
Line #203:
Line #204:$ir.="<td align=left><font color=red>
Line #205:$ref
Line #206:<A target=sframe href='QJ_cimUP.php?&wjid=".$vevokod."&CimUp=QJ_gyujto.php&sqlfile=qj_cimtar'>
Line #207:$vevokod</a></font> <b>$ct_sor[nev]</b>$info1 $info2 </td>";
Line #208:
Line #209:$vevoker="//".$egy_sor[bizomanyos].
Line #210: "//".$ct_sor[telepules]."//".$ct_sor[nev].
Line #211: "//".$ct_sor[telepules]."//".$ct_sor[telszam].
Line #212: "//".$ct_sor[cim]."//".$ct_sor[uzenet]."//";
Line #213:}
Line #214:
Line #215://$ir.=$vevoker.$_POST[keres]."</tr>";
Line #216:
Line #217:$ir.="</tr>";
Line #218:
Line #219:if (isset($_POST[keres])
Line #220:and $_POST[keres]<>""
Line #221:and strpos(strtoupper($vevoker),strtoupper($_POST[keres]))==0) $ir=""; else
Line #222:{
Line #223:$osft=$osft+$egy_sor[osszft];
Line #224:$osdb=$osdb+$egy_sor[osszdb];
Line #225:}
Line #226:
Line #227:echo $ir;
Line #228:
Line #229:$szin="";
Line #230:
Line #231:
Line #232:}
Line #233:
Line #234:
Line #235:echo"<tr bgcolor=silver>
Line #236:<td align=right >
Line #237:
Line #238:</td>
Line #239:
Line #240:<td align=right ><b><font color=$szin>".number_format( $osdb)."</font></b></td>
Line #241:<td align=right ><b><font color=$szin>".number_format( $osft)."</font></b></td>
Line #242:
Line #243:";
Line #244:
Line #245:
Line #246:echo "
Line #247:</table>";
Line #248:
Line #249:
Line #250:
Line #251:
Line #252:
Line #253:?>