QJ_webgyujto.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<>'*' 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=infoframe>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:
Line #105:IF (isset($_POST[email]) and $_POST[email]<>"*") { $wer=" and bizomanyos='".$_POST[email]."'";}
Line #106:else $wer="";
Line #107:
Line #108:IF (isset($_POST[nap]) and $_POST[nap]<>"*") { $wer=" and left(logtime,10)='".$_POST[nap]."'";}
Line #109:
Line #110:$szin="red";
Line #111:$parancs="SELECT * FROM qj_weblog where future<>'*' $wer ORDER BY logtime DESC";
Line #112:
Line #113:
Line #114:$i=0;
Line #115:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #116:{
Line #117:
Line #118:$wjid=$egy_sor[wid];
Line #119:
Line #120:$SQLszek = "SELECT wid FROM qj_jegy WHERE bizonylatszam='WEB:".$wjid."' limit 1 ";
Line #121:
Line #122:
Line #123:$nur=mysql_num_rows($szekek);
Line #124:if ($nur==0) {
Line #125:$SQLszek = "SELECT wid,bizonylatszam FROM qj_jegy WHERE kosar_kod='Qjegy:".$wjid."' limit 1 ";
Line #126:
Line #127:
Line #128:$m_sor = mysql_fetch_array( $szekek );
Line #129:
Line #130:$kosar="<A STYLE='{vlink : gold}'
Line #131:target=infoframe href='QJ_analitika.php?&bizonylat=".$m_sor[bizonylatszam]."'>
Line #132:
Line #133:
Line #134:if ($egy_sor[future]<>"*") {
Line #135:$parancs = "UPDATE `qj_weblog` SET `arforma`='nyomtatva',`uzenet`='".$egy_sor[future]."',`future`='*',`logtime`='".$egy_sor[logtime]."' WHERE `wid`='".$egy_sor[wid]."'";
Line #136:
Line #137:}
Line #138:
Line #139:
Line #140:} else {
Line #141:
Line #142:$kosar="<A STYLE='{vlink : gold}'
Line #143:target=sframe href='QJ_web.php?&bizonylat=".$egy_sor[wid]."'>
Line #144:
Line #145:
Line #146:
Line #147:
Line #148:$ho=substr($egy_sor[logtime],5,2);
Line #149:$ev=substr($egy_sor[logtime],0,4);
Line #150:$nap=substr($egy_sor[logtime],8,2);
Line #151:
Line #152:$tomorrow = mktime (0,0,0,$ho,($nap+7),$ev);
Line #153:
Line #154://$lastmonth = mktime (0,0,0,date("m")-1,date("d"), date("Y"));
Line #155://$nextyear = mktime (0,0,0,date("m"), date("d"), date("Y")+1);
Line #156:$lejart=date("Y-m-d",$tomorrow);
Line #157:$mai=date("Y-m-d");
Line #158:
Line #159:if ($lejart<$mai and substr($egy_sor[lejarat],0,2)=="00") {
Line #160:
Line #161:
Line #162:}
Line #163:
Line #164:}
Line #165:
Line #166:
Line #167: $rel="QJ_okmail.php?&ID=";
Line #168: $relA="QJ_web.php";
Line #169:
Line #170:
Line #171:
Line #172:
Line #173:$ir="<tr>
Line #174:<td align=right >
Line #175:$kosar
Line #176:</td>
Line #177:
Line #178:<td align=right ><b><font color=$szin>".number_format( $egy_sor[osszdb])."</font></b></td>
Line #179:<td align=right ><b><font color=$szin>".number_format( $egy_sor[osszft])."</font></b></td>
Line #180:<td align=right><font color=blue><b>$egy_sor[wid]</b></font></td>
Line #181:<td >$egy_sor[status]</td>
Line #182:<td $szin>$egy_sor[arforma]</td>
Line #183:<td >$egy_sor[logtime]</td>
Line #184:<td ><a target=infoframe href=$rel$egy_sor[wid]>
Line #185:
Line #186:<td >$egy_sor[bizomanyos]</td>
Line #187:";
Line #188:
Line #189:$vevokod=$egy_sor[vevokod];
Line #190:$vevoker="";
Line #191:
Line #192:if ($vevokod>0) {
Line #193:$vevoker = "SELECT * FROM qj_cimtar WHERE wid=".$vevokod;
Line #194:
Line #195:$ct_sor = mysql_fetch_array($ctar);
Line #196:
Line #197:if ($ct_sor[telepules].$ct_sor[cim]=="") $info1=""; else
Line #198:$info1="<br><b>$ct_sor[telepules]</b> $ct_sor[cim]";
Line #199:
Line #200:if ($ct_sor[telszam].$ct_sor[uzenet]=="") $info2=""; else
Line #201:$info2="<br><b>$ct_sor[telszam]</b> $ct_sor[uzenet]";
Line #202:
Line #203:
Line #204://$ref="<a target=sframe href=QJ_elojegyzesek.php?&full=Y&vevo=$vevokod>
Line #205:
Line #206:
Line #207:$ref="
Line #208:<A target=sframe
Line #209:href='QJ_elojegyzesek.php?&vevo=".$vevokod."'>
Line #210:
Line #211:<a target=infoframe href=QJ_vevo.php?&full=Y&vevo=$vevokod>
Line #212:
Line #213:
Line #214:
Line #215:$ir.="<td align=left><font color=red>
Line #216:$ref
Line #217:<A target=sframe href='QJ_cimUP.php?&wjid=".$vevokod."&CimUp=QJ_gyujto.php&sqlfile=qj_cimtar'>
Line #218:$vevokod</a></font> <b>$ct_sor[nev]</b>$info1 $info2 </td>";
Line #219:
Line #220:$vevoker="//".$egy_sor[bizomanyos].
Line #221: "//".$ct_sor[telepules]."//".$ct_sor[nev].
Line #222: "//".$ct_sor[telepules]."//".$ct_sor[telszam].
Line #223: "//".$ct_sor[cim]."//".$ct_sor[uzenet]."//";
Line #224:}
Line #225:
Line #226://$ir.=$vevoker.$_POST[keres]."</tr>";
Line #227:
Line #228:$ir.="</tr>";
Line #229:
Line #230:if (isset($_POST[keres])
Line #231:and $_POST[keres]<>""
Line #232:and strpos(strtoupper($vevoker),strtoupper($_POST[keres]))==0) $ir=""; else
Line #233:{
Line #234:$osft=$osft+$egy_sor[osszft];
Line #235:$osdb=$osdb+$egy_sor[osszdb];
Line #236:}
Line #237:
Line #238:echo $ir;
Line #239:
Line #240:$szin="";
Line #241:
Line #242:
Line #243:}
Line #244:
Line #245:
Line #246:echo"<tr bgcolor=silver>
Line #247:<td align=right >
Line #248:
Line #249:</td>
Line #250:
Line #251:<td align=right ><b><font color=$szin>".number_format( $osdb)."</font></b></td>
Line #252:<td align=right ><b><font color=$szin>".number_format( $osft)."</font></b></td>
Line #253:
Line #254:";
Line #255:
Line #256:
Line #257:echo "
Line #258:</table>";
Line #259:
Line #260:
Line #261:
Line #262:
Line #263:
Line #264:?>