ini dari conn.php
ini dari getPer.php : hari mulai 123
hari : 211
perMg : 13
UNDIAN 9,109,209,309,409,509,609,709,809,909h4
6,106,206,306,406,506,606,706,806,906,1006,1106,1206,1306,1406,1506,1606,1706,1806,1906,2006,2106,2206,2306,2406,2506,2606,2706,2806,2906,3006,3106,3206,3306,3406,3506,3606,3706,3806,3906,4006,4106,4206,4306,4406,4506,4606,4706,4806,4906,5006,5106,5206,5306,5406,5506,5606,5706,5806,5906,6006,6106,6206,6306,6406,6506,6606,6706,6806,6906,7006,7106,7206,7306,7406,7506,7606,7706,7806,7906,8006,8106,8206,8306,8406,8506,8606,8706,8806,8906,9006,9106,9206,9306,9406,9506,9606,9706,9806,9906h5
4,104,204,304,404,504,604,704,804,904,1004,1104,1204,1304,1404,1504,1604,1704,1804,1904,2004,2104,2204,2304,2404,2504,2604,2704,2804,2904,3004,3104,3204,3304,3404,3504,3604,3704,3804,3904,4004,4104,4204,4304,4404,4504,4604,4704,4804,4904,5004,5104,5204,5304,5404,5504,5604,5704,5804,5904,6004,6104,6204,6304,6404,6504,6604,6704,6804,6904,7004,7104,7204,7304,7404,7504,7604,7704,7804,7904,8004,8104,8204,8304,8404,8504,8604,8704,8804,8904,9004,9104,9204,9304,9404,9504,9604,9704,9804,9904,10004,10104,10204,10304,10404,10504,10604,10704,10804,10904,11004,11104,11204,11304,11404,11504,11604,11704,11804,11904,12004,12104,12204,12304,12404,12504,12604,12704,12804,12904,13004,13104,13204,13304,13404,13504,13604,13704,13804,13904,14004,14104,14204,14304,14404,14504,14604,14704,14804,14904,15004,15104,15204,15304,15404,15504,15604,15704,15804,15904,16004,16104,16204,16304,16404,16504,16604,16704,16804,16904,17004,17104,17204,17304,17404,17504,17604,17704,17804,17904,18004,18104,18204,18304,18404,18504,18604,18704,18804,18904,19004,19104,19204,19304,19404,19504,19604,19704,19804,19904,20004,20104,20204,20304,20404,20504,20604,20704,20804,20904,21004,21104,21204,21304,21404,21504,21604,21704,21804,21904,22004,22104,22204,22304,22404,22504,22604,22704,22804,22904,23004,23104,23204,23304,23404,23504,23604,23704,23804,23904,24004,24104,24204,24304,24404,24504,24604,24704,24804,24904,25004,25104,25204,25304,25404,25504,25604,25704,25804,25904,26004,26104,26204,26304,26404,26504,26604,26704,26804,26904,27004,27104,27204,27304,27404,27504,27604,27704,27804,27904,28004,28104,28204,28304,28404,28504,28604,28704,28804,28904,29004,29104,29204,29304,29404,29504,29604,29704,29804,29904,30004,30104,30204,30304,30404,30504,30604,30704,30804,30904,31004,31104,31204,31304,31404,31504,31604,31704,31804,31904,32004,32104,32204,32304,32404,32504,32604,32704,32804,32904,33004,33104,33204,33304,33404,33504,33604,33704,33804,33904,34004,34104,34204,34304,34404,34504,34604,34704,34804,34904,35004,35104,35204,35304,35404,35504,35604,35704,35804,35904,36004,36104,36204,36304,36404,36504,36604,36704,36804,36904,37004,37104,37204,37304,37404,37504,37604,37704,37804,37904,38004,38104,38204,38304,38404,38504,38604,38704,38804,38904,39004,39104,39204,39304,39404,39504,39604,39704,39804,39904,40004,40104,40204,40304,40404,40504,40604,40704,40804,40904,41004,41104,41204,41304,41404,41504,41604,41704,41804,41904,42004,42104,42204,42304,42404,42504,42604,42704,42804,42904,43004,43104,43204,43304,43404,43504,43604,43704,43804,43904,44004,44104,44204,44304,44404,44504,44604,44704,44804,44904,45004,45104,45204,45304,45404,45504,45604,45704,45804,45904,46004,46104,46204,46304,46404,46504,46604,46704,46804,46904,47004,47104,47204,47304,47404,47504,47604,47704,47804,47904,48004,48104,48204,48304,48404,48504,48604,48704,48804,48904,49004,49104,49204,49304,49404,49504,49604,49704,49804,49904,50004,50104,50204,50304,50404,50504,50604,50704,50804,50904,51004,51104,51204,51304,51404,51504,51604,51704,51804,51904,52004,52104,52204,52304,52404,52504,52604,52704,52804,52904,53004,53104,53204,53304,53404,53504,53604,53704,53804,53904,54004,54104,54204,54304,54404,54504,54604,54704,54804,54904,55004,55104,55204,55304,55404,55504,55604,55704,55804,55904,56004,56104,56204,56304,56404,56504,56604,56704,56804,56904,57004,57104,57204,57304,57404,57504,57604,57704,57804,57904,58004,58104,58204,58304,58404,58504,58604,58704,58804,58904,59004,59104,59204,59304,59404,59504,59604,59704,59804,59904,60004,60104,60204,60304,60404,60504,60604,60704,60804,60904,61004,61104,61204,61304,61404,61504,61604,61704,61804,61904,62004,62104,62204,62304,62404,62504,62604,62704,62804,62904,63004,63104,63204,63304,63404,63504,63604,63704,63804,63904,64004,64104,64204,64304,64404,64504,64604,64704,64804,64904,65004,65104,65204,65304,65404,65504,65604,65704,65804,65904,66004,66104,66204,66304,66404,66504,66604,66704,66804,66904,67004,67104,67204,67304,67404,67504,67604,67704,67804,67904,68004,68104,68204,68304,68404,68504,68604,68704,68804,68904,69004,69104,69204,69304,69404,69504,69604,69704,69804,69904,70004,70104,70204,70304,70404,70504,70604,70704,70804,70904,71004,71104,71204,71304,71404,71504,71604,71704,71804,71904,72004,72104,72204,72304,72404,72504,72604,72704,72804,72904,73004,73104,73204,73304,73404,73504,73604,73704,73804,73904,74004,74104,74204,74304,74404,74504,74604,74704,74804,74904,75004,75104,75204,75304,75404,75504,75604,75704,75804,75904,76004,76104,76204,76304,76404,76504,76604,76704,76804,76904,77004,77104,77204,77304,77404,77504,77604,77704,77804,77904,78004,78104,78204,78304,78404,78504,78604,78704,78804,78904,79004,79104,79204,79304,79404,79504,79604,79704,79804,79904,80004,80104,80204,80304,80404,80504,80604,80704,80804,80904,81004,81104,81204,81304,81404,81504,81604,81704,81804,81904,82004,82104,82204,82304,82404,82504,82604,82704,82804,82904,83004,83104,83204,83304,83404,83504,83604,83704,83804,83904,84004,84104,84204,84304,84404,84504,84604,84704,84804,84904,85004,85104,85204,85304,85404,85504,85604,85704,85804,85904,86004,86104,86204,86304,86404,86504,86604,86704,86804,86904,87004,87104,87204,87304,87404,87504,87604,87704,87804,87904,88004,88104,88204,88304,88404,88504,88604,88704,88804,88904,89004,89104,89204,89304,89404,89504,89604,89704,89804,89904,90004,90104,90204,90304,90404,90504,90604,90704,90804,90904,91004,91104,91204,91304,91404,91504,91604,91704,91804,91904,92004,92104,92204,92304,92404,92504,92604,92704,92804,92904,93004,93104,93204,93304,93404,93504,93604,93704,93804,93904,94004,94104,94204,94304,94404,94504,94604,94704,94804,94904,95004,95104,95204,95304,95404,95504,95604,95704,95804,95904,96004,96104,96204,96304,96404,96504,96604,96704,96804,96904,97004,97104,97204,97304,97404,97504,97604,97704,97804,97904,98004,98104,98204,98304,98404,98504,98604,98704,98804,98904,99004,99104,99204,99304,99404,99504,99604,99704,99804,99904h6
insert into tbonus values ('',5,'h4',10,20250731),('',9,'h4',20,20250731),('',3,'h5',200,20250731),('',2,'h6',200,20250731)
SELECT idn, ref, jn from tnetwork where idn in (SELECT idm FROM tpoin WHERE noPoin IN (9,109,209,309,409,509,609,709,809,909)) and ref*100000+jn not in (select idj*100000+jnDL from tjalur where hn='h4') : calon bj
line : 345
SELECT idn, ref, jn from tnetwork where idn in (SELECT idm FROM tpoin WHERE noPoin IN (6,106,206,306,406,506,606,706,806,906,1006,1106,1206,1306,1406,1506,1606,1706,1806,1906,2006,2106,2206,2306,2406,2506,2606,2706,2806,2906,3006,3106,3206,3306,3406,3506,3606,3706,3806,3906,4006,4106,4206,4306,4406,4506,4606,4706,4806,4906,5006,5106,5206,5306,5406,5506,5606,5706,5806,5906,6006,6106,6206,6306,6406,6506,6606,6706,6806,6906,7006,7106,7206,7306,7406,7506,7606,7706,7806,7906,8006,8106,8206,8306,8406,8506,8606,8706,8806,8906,9006,9106,9206,9306,9406,9506,9606,9706,9806,9906)) and ref*100000+jn not in (select idj*100000+jnDL from tjalur where hn='h5') : calon bj
line : 376
SELECT idn, ref, jn from tnetwork where idn in (SELECT idm FROM tpoin WHERE noPoin IN (4,104,204,304,404,504,604,704,804,904,1004,1104,1204,1304,1404,1504,1604,1704,1804,1904,2004,2104,2204,2304,2404,2504,2604,2704,2804,2904,3004,3104,3204,3304,3404,3504,3604,3704,3804,3904,4004,4104,4204,4304,4404,4504,4604,4704,4804,4904,5004,5104,5204,5304,5404,5504,5604,5704,5804,5904,6004,6104,6204,6304,6404,6504,6604,6704,6804,6904,7004,7104,7204,7304,7404,7504,7604,7704,7804,7904,8004,8104,8204,8304,8404,8504,8604,8704,8804,8904,9004,9104,9204,9304,9404,9504,9604,9704,9804,9904,10004,10104,10204,10304,10404,10504,10604,10704,10804,10904,11004,11104,11204,11304,11404,11504,11604,11704,11804,11904,12004,12104,12204,12304,12404,12504,12604,12704,12804,12904,13004,13104,13204,13304,13404,13504,13604,13704,13804,13904,14004,14104,14204,14304,14404,14504,14604,14704,14804,14904,15004,15104,15204,15304,15404,15504,15604,15704,15804,15904,16004,16104,16204,16304,16404,16504,16604,16704,16804,16904,17004,17104,17204,17304,17404,17504,17604,17704,17804,17904,18004,18104,18204,18304,18404,18504,18604,18704,18804,18904,19004,19104,19204,19304,19404,19504,19604,19704,19804,19904,20004,20104,20204,20304,20404,20504,20604,20704,20804,20904,21004,21104,21204,21304,21404,21504,21604,21704,21804,21904,22004,22104,22204,22304,22404,22504,22604,22704,22804,22904,23004,23104,23204,23304,23404,23504,23604,23704,23804,23904,24004,24104,24204,24304,24404,24504,24604,24704,24804,24904,25004,25104,25204,25304,25404,25504,25604,25704,25804,25904,26004,26104,26204,26304,26404,26504,26604,26704,26804,26904,27004,27104,27204,27304,27404,27504,27604,27704,27804,27904,28004,28104,28204,28304,28404,28504,28604,28704,28804,28904,29004,29104,29204,29304,29404,29504,29604,29704,29804,29904,30004,30104,30204,30304,30404,30504,30604,30704,30804,30904,31004,31104,31204,31304,31404,31504,31604,31704,31804,31904,32004,32104,32204,32304,32404,32504,32604,32704,32804,32904,33004,33104,33204,33304,33404,33504,33604,33704,33804,33904,34004,34104,34204,34304,34404,34504,34604,34704,34804,34904,35004,35104,35204,35304,35404,35504,35604,35704,35804,35904,36004,36104,36204,36304,36404,36504,36604,36704,36804,36904,37004,37104,37204,37304,37404,37504,37604,37704,37804,37904,38004,38104,38204,38304,38404,38504,38604,38704,38804,38904,39004,39104,39204,39304,39404,39504,39604,39704,39804,39904,40004,40104,40204,40304,40404,40504,40604,40704,40804,40904,41004,41104,41204,41304,41404,41504,41604,41704,41804,41904,42004,42104,42204,42304,42404,42504,42604,42704,42804,42904,43004,43104,43204,43304,43404,43504,43604,43704,43804,43904,44004,44104,44204,44304,44404,44504,44604,44704,44804,44904,45004,45104,45204,45304,45404,45504,45604,45704,45804,45904,46004,46104,46204,46304,46404,46504,46604,46704,46804,46904,47004,47104,47204,47304,47404,47504,47604,47704,47804,47904,48004,48104,48204,48304,48404,48504,48604,48704,48804,48904,49004,49104,49204,49304,49404,49504,49604,49704,49804,49904,50004,50104,50204,50304,50404,50504,50604,50704,50804,50904,51004,51104,51204,51304,51404,51504,51604,51704,51804,51904,52004,52104,52204,52304,52404,52504,52604,52704,52804,52904,53004,53104,53204,53304,53404,53504,53604,53704,53804,53904,54004,54104,54204,54304,54404,54504,54604,54704,54804,54904,55004,55104,55204,55304,55404,55504,55604,55704,55804,55904,56004,56104,56204,56304,56404,56504,56604,56704,56804,56904,57004,57104,57204,57304,57404,57504,57604,57704,57804,57904,58004,58104,58204,58304,58404,58504,58604,58704,58804,58904,59004,59104,59204,59304,59404,59504,59604,59704,59804,59904,60004,60104,60204,60304,60404,60504,60604,60704,60804,60904,61004,61104,61204,61304,61404,61504,61604,61704,61804,61904,62004,62104,62204,62304,62404,62504,62604,62704,62804,62904,63004,63104,63204,63304,63404,63504,63604,63704,63804,63904,64004,64104,64204,64304,64404,64504,64604,64704,64804,64904,65004,65104,65204,65304,65404,65504,65604,65704,65804,65904,66004,66104,66204,66304,66404,66504,66604,66704,66804,66904,67004,67104,67204,67304,67404,67504,67604,67704,67804,67904,68004,68104,68204,68304,68404,68504,68604,68704,68804,68904,69004,69104,69204,69304,69404,69504,69604,69704,69804,69904,70004,70104,70204,70304,70404,70504,70604,70704,70804,70904,71004,71104,71204,71304,71404,71504,71604,71704,71804,71904,72004,72104,72204,72304,72404,72504,72604,72704,72804,72904,73004,73104,73204,73304,73404,73504,73604,73704,73804,73904,74004,74104,74204,74304,74404,74504,74604,74704,74804,74904,75004,75104,75204,75304,75404,75504,75604,75704,75804,75904,76004,76104,76204,76304,76404,76504,76604,76704,76804,76904,77004,77104,77204,77304,77404,77504,77604,77704,77804,77904,78004,78104,78204,78304,78404,78504,78604,78704,78804,78904,79004,79104,79204,79304,79404,79504,79604,79704,79804,79904,80004,80104,80204,80304,80404,80504,80604,80704,80804,80904,81004,81104,81204,81304,81404,81504,81604,81704,81804,81904,82004,82104,82204,82304,82404,82504,82604,82704,82804,82904,83004,83104,83204,83304,83404,83504,83604,83704,83804,83904,84004,84104,84204,84304,84404,84504,84604,84704,84804,84904,85004,85104,85204,85304,85404,85504,85604,85704,85804,85904,86004,86104,86204,86304,86404,86504,86604,86704,86804,86904,87004,87104,87204,87304,87404,87504,87604,87704,87804,87904,88004,88104,88204,88304,88404,88504,88604,88704,88804,88904,89004,89104,89204,89304,89404,89504,89604,89704,89804,89904,90004,90104,90204,90304,90404,90504,90604,90704,90804,90904,91004,91104,91204,91304,91404,91504,91604,91704,91804,91904,92004,92104,92204,92304,92404,92504,92604,92704,92804,92904,93004,93104,93204,93304,93404,93504,93604,93704,93804,93904,94004,94104,94204,94304,94404,94504,94604,94704,94804,94904,95004,95104,95204,95304,95404,95504,95604,95704,95804,95904,96004,96104,96204,96304,96404,96504,96604,96704,96804,96904,97004,97104,97204,97304,97404,97504,97604,97704,97804,97904,98004,98104,98204,98304,98404,98504,98604,98704,98804,98904,99004,99104,99204,99304,99404,99504,99604,99704,99804,99904)) and ref*100000+jn not in (select idj*100000+jnDL from tjalur where hn='h6') : calon bj
h6:line : 405
jalur sudah diinsert sebelumnya
sekarang ke beriBJ456()
select idj, count(idj) as nx from tjalur where perBln='4' and hn='h4' and idj in(select distinct(idj) from tjalur where perBln<4 and hn='h4') group by idj
select idj, count(idj) as nx from tjalur where perBln='4' and hn='h5' and idj in(select distinct(idj) from tjalur where perBln<4 and hn='h5') group by idj
select idj, count(idj) as nx from tjalur where perBln='4' and hn='h6' and idj in(select distinct(idj) from tjalur where perBln<4 and hn='h6') group by idj
insert into tbonus values ('',1,'h4',1*5,20250731),('',4,'h4',1*5,20250731),('',8,'h4',1*5,20250731),('',1,'h5',1*100,20250731),('',1,'h6',1*100,20250731)
line : 478