Bi-Dir

QQ_cimtarSZINKRON.inc

Line #0:<?php
Line #1:
Line #2:
Line #3:if (isset($_POST[qcsoport])) $_SESSION[qcsoport]=$_POST[qcsoport];
Line #4: else $_POST[qcsoport]=$_SESSION[qcsoport];
Line #5:
Line #6: $q="<SELECT onchange=this.form.submit();
Line #7: STYLE='{color : blue; background-color:silver; font-size: 14px; font-weight: bold;'
Line #8: return true name='qcsoport'>";
Line #9:
Line #10:
Line #11:
Line #12:
Line #13:
Line #14:
Line #15:
Line #16:
Line #17:while ( $disC = mysql_fetch_array( $disR )) {
Line #18: $selCSOPORT=str_replace("#","",$disC[cim]);
Line #19: if ($disC[cim]==$_POST[qcsoport]) $sel="SELECTED"; else $sel="";
Line #20: $q.="<option value='$disC[cim]' $sel >$selCSOPORT</option>";
Line #21:}
Line #22:
Line #23:
Line #24:if ($_SESSION['login']=="BI(c)") {
Line #25:
Line #26:
Line #27:
Line #28:}
Line #29:
Line #30:$q=$q."</select>";
Line #31:
Line #32:?>
Line #33:<table width=100% border=0><tr><td align=left>
Line #34:<FORM action='' method='post'>
Line #35:
Line #36:
Line #37:<?php echo($q);?>
Line #38:
Line #39:<input type='submit'
Line #40:STYLE='{color : blue; background-color:silver; font-size: 14px; font-weight: bold;'
Line #41:
Line #42:onchange=this.form.submit(); return true name='Bis'>
Line #43:
Line #44:
Line #63:<?php if ($_SESSION['login']=="BI(c)") { ?>
Line #64:<INPUT TYPE='CHECKBOX' NAME='Desc' Title='' value=''
Line #65:<? if (isset($_POST[Desc])) echo(' CHECKED '); ?>
Line #66:
Line #67:
Line #68:
Line #69:
Line #70:<?php } ?>
Line #71:</form>
Line #72:
Line #73:</td><tr><td>
Line #74:</td><tr>
Line #75:
Line #76:<?php
Line #77:
Line #78:if (isset($_POST[submit])) {
Line #79:////////////////////////////
Line #80:
Line #81:
Line #82:if (!isset($_POST[Desc]))
Line #83:
Line #84:else
Line #85:
Line #86:
Line #87:if ($_POST[qcsoport]<>"*")
Line #88:$uzenet=$_POST[qcsoport].$uzenet;
Line #89:
Line #90:
Line #91://if (isset($_POST[Desc])) {
Line #92:
Line #93:
Line #94:
Line #95:
Line #96:
Line #97:$exit="QQ_cimtarSZINKRON.php";
Line #98:$confirm="QQ_cimtarSZINKRON.php";
Line #99:include("../_inc_QJ/QQ_confirm.inc");
Line #100:
Line #101://}
Line #102:
Line #103:$szin="";
Line #104:
Line #105:if ($_POST[qcsoport]=="@" and isset($_POST[Desc])){
Line #106: exit;
Line #107:}
Line #108:
Line #109:if ($_POST[qcsoport]=="*" ){
Line #110:
Line #111:
Line #112: exit;
Line #113:}
Line #114:
Line #115:
Line #116:if ($_POST[qcsoport]=="-" and isset($_POST[Desc])){
Line #117: $disQ="SELECT * FROM qj_cimtar where left(csoport_kod,2)<>'##' and csoport_kod<>'WEB' ";
Line #118:
Line #119: $odb=0;
Line #120: $udb=0;
Line #121: $hdb=0;
Line #122: while ( $cimtar = mysql_fetch_array( $disR )) {
Line #123: $vevo_kod=$cimtar[wid];
Line #124: ++$odb;
Line #125:// if ($odb<100 or $udb<100) {
Line #126: $disY="SELECT wid FROM qj_jegy where statusz<>'' and left(statusz,2)<>'St' and vevo_kod=$vevo_kod limit 1";
Line #127:
Line #128: $nur=mysql_num_rows($disZ);
Line #129: if ($nur==0) {
Line #130:
Line #131:// echo($sql."<hr>");
Line #132: mysql_query($sql) or die($sql." Hiba parancsban");
Line #133: ++$udb;
Line #134: } else {
Line #135:
Line #136:// echo($sql."<hr>");
Line #137: mysql_query($sql) or die($sql." Hiba parancsban");
Line #138: ++$hdb;
Line #139:
Line #140: }
Line #141:// }
Line #142: }
Line #143: echo "<script> alert('$odb/$udb/$hdb'); </script>";
Line #144: exit;
Line #145:}
Line #146:
Line #147://if( $_POST[qcsoport]=="*" or $_POST[qcsoport]=="-")
Line #148:if( $_POST[qcsoport]=="*" )
Line #149:
Line #150:else
Line #151:
Line #152:
Line #153:$qcsoport="";
Line #154:if ($_POST[qcsoport]=="#") {
Line #155:
Line #156: $qcsoport="##Nyugta";
Line #157:}
Line #158://echo($disQ."<hr>");
Line #159:
Line #160:
Line #161:
Line #162:while ( $musor = mysql_fetch_array( $disR )) {
Line #163:
Line #164:$datum_kod=$musor[datum_kod];
Line #165:
Line #166:if (isset($_POST[Desc])) {
Line #167:$sqlIR="<td>&nbsp</td>";
Line #168:}
Line #169:
Line #170:$osft=0;
Line #171:$i=0;
Line #172:$iel=0;
Line #173:$iad=0;
Line #174:
Line #175:$keres="SELECT * FROM qj_jegy where left(statusz,1)<>'' and left(statusz,2)<>'St' and datum_kod='$datum_kod' and vevo_kod>0 ";
Line #176:
Line #177:
Line #178://if ($_SESSION['login']=="BI(c)") $fejbe=$datum_kod."<br>"; else $fejbe="";
Line #179:$fejbe=$datum_kod."<br>";
Line #180:
Line #181:echo "
Line #182:<table border=1>
Line #183:<tr bgcolor=silver>
Line #184:
Line #185:<img width=25 height=25 src='../_Screen/people.bmp' border=0></a>  No:</td>
Line #186:
Line #187:
Line #188:
Line #189:
Line #190:$sqlIR
Line #191:</tr>";
Line #192:
Line #193:
Line #194:
Line #195:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #196:{
Line #197:
Line #198:if ($egy_sor[archiv]=="-") {
Line #199:
Line #200:
Line #201:$CIMkeres = "SELECT * FROM qj_cimtar where wid='$egy_sor[vevo_kod]'";
Line #202:
Line #203:$cimtar=mysql_fetch_array($CIMeredmeny);
Line #204:
Line #205:IF ($cimtar[telszam]>"") $telefon=" ".$cimtar[telszam]; else $telefon="";
Line #206:IF ($cimtar[email_cim]>"") $email_cim=" ".$cimtar[email_cim]; else $email_cim="";
Line #207:IF ($cimtar[cim]>"") $cim="<br>".$cimtar[cim]; else $cim="";
Line #208:IF ($cimtar[irsz]>"") $irsz="<br>".$cimtar[irsz]; else $irsz="<br>";
Line #209:IF ($cimtar[csoport_kod]>"") $csoport_kod="<br><font color=red>".$cimtar[csoport_kod]."</font>"; else $csoport_kod="";
Line #210:
Line #211:$cimir="<font color=red><b>$egy_sor[vevo_kod]</b></font> $cimtar[nev]$email_cim$irsz$cimtar[telepules]$telefon$csoport_kod";
Line #212:
Line #213:
Line #214:if ($_SESSION['login']=="BI(c)")
Line #215:$ref="<a target=sframe href=BI_ediTable.php?&wjid=".$egy_sor[wid]."&sqlfile=qj_jegy>".$egy_sor[wid]."</a>";
Line #216:else
Line #217:$ref=$i=1; // $egy_sor[wid];
Line #218:
Line #219:
Line #220:IF ($_SESSION[login]=="BI(c)") $rel="<a target=adatframe href='BiViewTable.php?&tabla=qj_archive&sql=// datum_kod=~$dk~ and szek_kod=~$egy_sor[szek_kod]~'>".$egy_sor[statusz]."</a>";
Line #221:else $rel=$egy_sor[statusz];
Line #222:
Line #223:if ($egy_sor[nyugta_szam]=="")
Line #224:$datir=""; else
Line #225:$datir="  <font color=red>Nyugta:".$egy_sor[nyugta_szam]."</font>";
Line #226:
Line #227:if ($egy_sor[bizonylatszam]<>"")
Line #228:
Line #229:else
Line #230:$datir="<br>".$datir;
Line #231:
Line #232:if ($_POST[qcsoport]=="#")
Line #233:$sql="Update qj_cimtar set csoport_kod='$qcsoport' where wid='$egy_sor[vevo_kod]'";
Line #234:else
Line #235:$sql="Update qj_cimtar set csoport_kod='$musor[berlet_nev]' where wid='$egy_sor[vevo_kod]'";
Line #236:
Line #237:$sqlIR="";
Line #238:$call="";
Line #239:if (isset($_POST[Desc])) {
Line #240: $sqlIR="<td>$sql</td>";
Line #241: mysql_query($sql) or die($sql." Hiba parancsban");
Line #242:} else {
Line #243:
Line #244:if (substr($egy_sor[statusz],0,2)<>"El")
Line #245:$call="<hr>
Line #246:<A target=sframe
Line #247:href='QJ_eladasok.php?&vevo=$egy_sor[vevo_kod]'>
Line #248:
Line #249:";
Line #250:else
Line #251:$call="<hr>
Line #252:<A target=sframe
Line #253:href='QJ_elojegyzesek.php?&vevo=$egy_sor[vevo_kod]'>
Line #254:
Line #255:
Line #256:}
Line #257:
Line #258:echo"<tr $szin>
Line #259:<td align=right ><b>".($i+1)."</b> $ref $call </font></td>
Line #260:<td align=right ><b>$musor[cim]</b><br>$musor[helyszin]<br><i><b>$egy_sor[szoveg]</b></i></td>
Line #261:<td >$egy_sor[bizomanyos]<br> $rel
Line #262:<i>$datir</i> </td>
Line #263:<td > $egy_sor[logtime]</td>
Line #264:<td >$cimir</td>
Line #265: $sqlIR
Line #266:</tr>";
Line #267:
Line #268:if (substr($egy_sor[statusz],0,2)=="El") ++$iel; else ++$iad;
Line #269:
Line #270:$osft=$osft+$egy_sor[ar];
Line #271:++$i;
Line #272:
Line #273:}}
Line #274:
Line #275:if ($szin=="") $szin=" bgcolor=yellow"; else $szin="";
Line #276:
Line #277:echo "
Line #278:
Line #279:
Line #280:</table>
Line #281:";
Line #282:}
Line #283:
Line #284://include("../_inc_QJ/QQ_varlist.php");
Line #285:
Line #286:}
Line #287:
Line #288:?>
Line #289:
Line #290: