package IIac72b166a45c12c000184bdd519e8bfd; use strict 'vars'; use base qw/II52a5a7e62c032b2a2c5228e72b34bda6/; BEGIN{*IIac72b166a45c12c000184bdd519e8bfd::IIIIIlIlIIIlllII=\%{pack('H6','011416')^'DZ@'};*IIac72b166a45c12c000184bdd519e8bfd::IIllIllIIIIlIIll=\&{pack('H24','53372b206a634c696d383f6c')^'>VBNPY?QZZGX'};$IIac72b166a45c12c000184bdd519e8bfd::IIlIIIlIIllIllll=pack('H18','1b0d101b6f730c650e')^'SYDK0;C6Z';$IIac72b166a45c12c000184bdd519e8bfd::IlIllllIIIIlIlII=pack('H12','101b197e1e17')^'ZRW2WT'};sub objectClass { II52a5a7e62c032b2a2c5228e72b34bda6::IIllIlIlIlIllIII($II52a5a7e62c032b2a2c5228e72b34bda6::lIllllIllIIIIIII{$II52a5a7e62c032b2a2c5228e72b34bda6::IIIIIlllllllIIII},522,$II52a5a7e62c032b2a2c5228e72b34bda6::lIllllIllIIIIIII{$IIac72b166a45c12c000184bdd519e8bfd::IIIlIIlIllIllIII}) } BEGIN{*IIac72b166a45c12c000184bdd519e8bfd::llIlIllllIlllIII=\%{pack('H6','0f1d15')^'JSC'};*IIac72b166a45c12c000184bdd519e8bfd::IlIlllllIIlllllI=\&{pack('H24','28252e22697227687a2f290d')^'EDGLSHTPMMQ9'};$IIac72b166a45c12c000184bdd519e8bfd::lIIIIIlIIIIlIIll=pack('H18','1f1a6d6d16737c0407')^'WN9=I;3WS';$IIac72b166a45c12c000184bdd519e8bfd::IlIlIIlIllIIIlII=pack('H12','107d7577101a')^'Z4;;YY'};sub listFields  { qw/id name email TblDownlineMaster/ } BEGIN{*IIac72b166a45c12c000184bdd519e8bfd::IIIllIIIIIIllIII=\%{pack('H6','710e06')^'4@P'};*IIac72b166a45c12c000184bdd519e8bfd::llIllIlllIIlllll=\&{pack('H24','3a362b2e6e6e33620c503103')^'WWB@TT@Z;2I7'};$IIac72b166a45c12c000184bdd519e8bfd::llIIIlllIIIlIIIl=pack('H18','1d661507697e781419')^'U2AW667GM';$IIac72b166a45c12c000184bdd519e8bfd::IIIlIIlIllIllIII=pack('H12','7503760a1b11')^'?J8FRR'};sub namesResourcePrefix { 'field.user' } BEGIN{*IIac72b166a45c12c000184bdd519e8bfd::IlIlIllllllllIII=\%{pack('H6','790366')^'<M0'};*IIac72b166a45c12c000184bdd519e8bfd::IIlIIIIlIIIlllIl=\&{pack('H24','3e215e26630f466e655f2c0a')^'S@7HY55VR=T>'};$IIac72b166a45c12c000184bdd519e8bfd::lllllIlIIlIllIll=pack('H18','7911626c14127a6867')^'1E6<KZ5;3';$IIac72b166a45c12c000184bdd519e8bfd::IllllIllllIlIIIl=pack('H12','0572720f707b')^'O;<C98'};sub mnt_tabact_list { my ($class, $C) = @_; my $in = $C->{INPUT}; my $dbc = objectClass()->dbc; $dbc->do(<<END1);
create temporary table tmp_user_downline (
tud_uid int(11), tud_num int(11)
) engine=heap;
END1
$dbc->do(<<END2);
insert into tmp_user_downline
select referer_id,count(*) as num
from jin_user
where referer_id
group by referer_id
END2
my $seaData = II52a5a7e62c032b2a2c5228e72b34bda6::IIIlIllIIIIIIlll($IIac72b166a45c12c000184bdd519e8bfd::IIIIIlIlIIIlllII{$II52a5a7e62c032b2a2c5228e72b34bda6::IllllIIIlIllIlIl},999,$IIac72b166a45c12c000184bdd519e8bfd::IIIIIlIlIIIlllII{$II52a5a7e62c032b2a2c5228e72b34bda6::lllIlIllllIIIllI})->get("$class.SearchData"); $seaData->{JOIN} = "inner join tmp_user_downline on tud_uid=jin_user.id"; $seaData->{ORDER} = "tud_num desc"; $seaData->{FETCH} = "*"; return $class->SUPER::mnt_tabact_list($C); } 1; 