QQ_szekSORkarb.inc
Line #0:<?php include("QJ_start.php");
Line #1:
Line #2:if (isset($_GET[wjid])) $wjid=$_GET[wjid]; else $wjid=$_POST[wjid];
Line #3:$wid=$wjid;
Line #4:if (isset($_GET[tabla])) $sqlfile=$_GET[tabla]; else $sqlfile=$_POST[tabla];
Line #5:
Line #6:if (isset($_GET[tol])) $tol=$_GET[tol]; else $tol=$_POST[tol];
Line #7:if (isset($_GET[ig])) $ig=$_GET[ig]; else $ig=$_POST[ig];
Line #8:if (isset($_GET[sor])) $sor=$_GET[sor]; else $sor=$_POST[sor];
Line #9:if (isset($_GET[hely_kod])) $hely_kod=$_GET[hely_kod]; else $hely_kod=$_POST[hely_kod];
Line #10:
Line #11:if (isset($_GET[szektol])) $szektol=$_GET[szektol]; else $szektol=$_POST[szektol];
Line #12:if (isset($_GET[lepes])) $lepes=$_GET[lepes]; else $lepes=$_POST[lepes];
Line #13:if (isset($_GET[oldal])) $oldal=$_GET[oldal]; else $oldal=$_POST[oldal];
Line #14:
Line #15:if (isset($_GET[helyek])) $helyek=$_GET[helyek]; else $helyek=$_POST[helyek];
Line #16:
Line #17:if (isset($_POST[dupla])) echo("DUPLA!!!<hr>");
Line #18:
Line #19:if ($wjid==-1 or isset($_POST[dupla]))
Line #20:{
Line #21:
Line #22:for ($jtol=1;$jtol<$helyek+1;$jtol++)
Line #23:{
Line #24:
Line #25:$szek_kod=$sor."/".substr("000".$tol,-3);
Line #26:++$tol;
Line #27:
Line #28:$keres = "SELECT wid FROM qj_szek where hely_kod='$hely_kod' and szek_kod='$szek_kod' ";
Line #29:
Line #30:$csor=mysql_query($keres) or die($keres."Hiba a select-ben");
Line #31:
Line #32:$nur=mysql_num_rows($csor);
Line #33:echo($nur."----".$keres."<hr>");
Line #34:
Line #35:if (!$nur) {
Line #36:$newcim = "INSERT INTO `$sqlfile`
Line #37:( `usr_kod`
Line #38:) VALUES
Line #39:( '$_SESSION[Qusr_kod]'
Line #40:)";
Line #41:
Line #42:mysql_query($newcim) or die($newcim."Hiba a $sqlfile insertben");
Line #43:
Line #44:$keres = "SELECT wid FROM `$sqlfile` order by wid DESC";
Line #45:$csor=mysql_query($keres) or die($keres."Hiba a $sqlfile select-ben");
Line #46:
Line #47:}
Line #48:
Line #49:$cim_sor = mysql_fetch_array( $csor );
Line #50:$wjid=$cim_sor[wid];
Line #51:
Line #52:$eredmeny = mysql_query('show fields from '.$sqlfile);
Line #53:
Line #54:$fid='';
Line #55:
Line #56:
Line #57:while ($row =mysql_fetch_row($eredmeny))
Line #58:{
Line #59:
Line #60: $fid.=$row[0] . ":";
Line #61:}
Line #62:
Line #63:
Line #64:$keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #65:
Line #66:
Line #67:
Line #68:$h=split(':',$fid);
Line #69:$nur=count($h)-1;
Line #70:
Line #71:
Line #72:
Line #73:if ($_POST[W] or isset($_POST[dupla]))
Line #74:{
Line #75:
Line #76:$W=$_POST[W];
Line #77:
Line #78:$parancs = "UPDATE ".$sqlfile." SET ";
Line #79:
Line #80:$vesszo='';
Line #81:
Line #82:for($j=1;$j<$nur;$j++)
Line #83:
Line #84:{
Line #85:
Line #86: //if (isset($_POST[dupla]) and $h[$j]=="datum_kod") $W[$j]=$W[1]."D".substr("00000".$wjid,-5);
Line #87: if (isset($_POST[dupla]) and $h[$j]=="szek_kod") $W[$j]=$szek_kod;
Line #88: if (isset($_POST[dupla]) and $h[$j]=="qj_sor_h") $W[$j]=$szektol;
Line #89: if (isset($_POST[dupla]) and $h[$j]=="qj_sor_n") $W[$j]=trim($W[$j]);
Line #90: if (isset($_POST[dupla]) and $h[$j]=="qj_sor_s") $W[$j]=trim($W[$j]);
Line #91: if (isset($_POST[dupla]) and $h[$j]=="qj_sor_o") $W[$j]=$oldal;
Line #92:
Line #93: $parancs .=$vesszo.$h[$j]."='".$W[$j]."' ";
Line #94: $vesszo=', ';
Line #95:
Line #96:}
Line #97:$parancs .= " WHERE CONCAT( wid )='$wjid' LIMIT 1" ;
Line #98:
Line #99:
Line #100: echo ($parancs.'<br>'.mysql_error().'<br>');
Line #101:
Line #102: $szektol=$szektol+$lepes;
Line #103:
Line #104:
Line #105://///
Line #106:}}}
Line #107:
Line #108:$eredmeny = mysql_query('show fields from '.$sqlfile);
Line #109:
Line #110:$fid='';
Line #111:
Line #112:
Line #113:while ($row =mysql_fetch_row($eredmeny))
Line #114:{
Line #115:
Line #116: $fid.=$row[0] . ":";
Line #117:}
Line #118:
Line #119:$h=split(':',$fid);
Line #120:$nur=count($h)-1;
Line #121:
Line #122: $keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wid;
Line #123:
Line #124:
Line #125:
Line #126://///
Line #127:
Line #128:$bup="<FORM name=orderby action='BI_szekSORkarb.php?&wjid=$wjid&tabla=$sqlfile' method='post'>";
Line #129:$bup.="<table border=1 align=center bgcolor='gold'>";
Line #130:$bup.="<td align=left>";
Line #131:$bup.="<tr><td align=right><input type='submit' value='Ment' name='submit'>
Line #132:
Line #133:</td>";
Line #134:
Line #135:$bup.="<td align=center colspan=4><b>$sqlfile / WID:$wjid</b>";
Line #136:$bup.="<input type='hidden' value='$h[0]' name='Wjid'></td>";
Line #137:
Line #138:$bup.="<tr><td align=right bgcolor=silver>Hely_kod</td><td><input type='text' value='$hely_kod' name='hely_kod'></td>";
Line #139:
Line #140:$bup.="<tr><td align=right bgcolor=silver>Sor</td><td><input type='text' value='$sor' name='sor'></td>";
Line #141:
Line #142:
Line #143:
Line #144:
Line #145:
Line #146:
Line #147:
Line #148:$bup.="<tr><td align=right bgcolor=silver>OLDAL</td><td><input type='text' value='$oldal' name='oldal'></td>";
Line #149:
Line #150:$bup.="<tr><td align=right bgcolor=silver><input type='CHECKBOX' value=' ' name='eof'>EOF</td>";
Line #151:
Line #152:$bup.="</td></tr><tr>";
Line #153:
Line #154:$r=mysql_fetch_row($eredmeny);
Line #155:
Line #156:$tr="</tr><tr>";
Line #157:$colspan="";
Line #158:
Line #159:for($j=1;$j<$nur;$j++)
Line #160:
Line #161:{
Line #162:
Line #163: $bum='W['.$j.']';
Line #164:
Line #165:
Line #166: $bup.="<td align=right>".$h[$j]."</td><td $colspan ><input $ronly type='text' value='".$r[$j]."' name='".$bum."'></td>".$tr;
Line #167:
Line #168:
Line #169:
Line #170:}
Line #171:
Line #172:
Line #173:$bup.="</tr></table></form>";
Line #174:
Line #175:echo($bup);
Line #176:
Line #177:
Line #178:
Line #179:?>