QJ_webgyujtoEGY.inc
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<>'*' and left(logtime,7)>'2011-06' 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<>'*' and left(logtime,7)>'2011-06' " ;
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<>'*' and left(logtime,7)>'2011-06' 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=sframe 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 and left(logtime,7)>'2011-06' 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: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: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:$ir="<tr>
Line #168:<td align=right >
Line #169:$kosar
Line #170:</td>
Line #171:
Line #172:<td align=right ><b><font color=$szin>".number_format( $egy_sor[osszdb])."</font></b></td>
Line #173:<td align=right ><b><font color=$szin>".number_format( $egy_sor[osszft])."</font></b></td>
Line #174:<td align=right><font color=blue><b>$egy_sor[wid]</b></font></td>
Line #175:<td >$egy_sor[status]</td>
Line #176:<td >$egy_sor[arforma]</td>
Line #177:<td >$egy_sor[logtime]</td>
Line #178:<td ><a target=adatframe href=$rel$egy_sor[wid]>
Line #179:
Line #180:<td >$egy_sor[bizomanyos]</td>
Line #181:";
Line #182:
Line #183:$vevokod=$egy_sor[vevokod];
Line #184:$vevoker="";
Line #185:
Line #186:if ($vevokod>0) {
Line #187:$vevoker = "SELECT * FROM qj_cimtar WHERE wid=".$vevokod;
Line #188:
Line #189:$ct_sor = mysql_fetch_array($ctar);
Line #190:
Line #191:if ($ct_sor[telepules].$ct_sor[cim]=="") $info1=""; else
Line #192:$info1="<br><b>$ct_sor[telepules]</b> $ct_sor[cim]";
Line #193:
Line #194:if ($ct_sor[telszam].$ct_sor[uzenet]=="") $info2=""; else
Line #195:$info2="<br><b>$ct_sor[telszam]</b> $ct_sor[uzenet]";
Line #196:
Line #197:
Line #198:$ref="<a target=sframe href=QJ_elojegyzesek.php?&full=Y&vevo=$vevokod>
Line #199:
Line #200:
Line #201:
Line #202:$ir.="<td align=left><font color=red>
Line #203:$ref
Line #204:<A target=sframe href='QJ_cimUP.php?&wjid=".$vevokod."&CimUp=QJ_gyujto.php&sqlfile=qj_cimtar'>
Line #205:$vevokod</a></font> <b>$ct_sor[nev]</b>$info1 $info2 </td>";
Line #206:
Line #207:$vevoker="//".$egy_sor[bizomanyos].
Line #208: "//".$ct_sor[telepules]."//".$ct_sor[nev].
Line #209: "//".$ct_sor[telepules]."//".$ct_sor[telszam].
Line #210: "//".$ct_sor[cim]."//".$ct_sor[uzenet]."//";
Line #211:}
Line #212:
Line #213://$ir.=$vevoker.$_POST[keres]."</tr>";
Line #214:
Line #215:$ir.="</tr>";
Line #216:
Line #217:if (isset($_POST[keres])
Line #218:and $_POST[keres]<>""
Line #219:and strpos(strtoupper($vevoker),strtoupper($_POST[keres]))==0) $ir=""; else
Line #220:{
Line #221:$osft=$osft+$egy_sor[osszft];
Line #222:$osdb=$osdb+$egy_sor[osszdb];
Line #223:}
Line #224:
Line #225:echo $ir;
Line #226:
Line #227:$szin="";
Line #228:
Line #229:
Line #230:}
Line #231:
Line #232:
Line #233:echo"<tr bgcolor=silver>
Line #234:<td align=right >
Line #235:
Line #236:</td>
Line #237:
Line #238:<td align=right ><b><font color=$szin>".number_format( $osdb)."</font></b></td>
Line #239:<td align=right ><b><font color=$szin>".number_format( $osft)."</font></b></td>
Line #240:
Line #241:";
Line #242:
Line #243:
Line #244:echo "
Line #245:</table>";
Line #246:
Line #247:
Line #248:
Line #249:
Line #250:
Line #251:?>