PNG  IHDR pHYs   OiCCPPhotoshop ICC profilexڝSgTS=BKKoR RB&*! J!QEEȠQ, !{kּ> H3Q5 B.@ $pd!s#~<<+"x M0B\t8K@zB@F&S`cbP-`'{[! eDh;VEX0fK9-0IWfH  0Q){`##xFW<+*x<$9E[-qWW.(I+6aa@.y24x6_-"bbϫp@t~,/;m%h^ uf@Wp~<5j>{-]cK'Xto(hw?G%fIq^D$.Tʳ?D*A, `6B$BB dr`)B(Ͱ*`/@4Qhp.U=pa( Aa!ڈbX#!H$ ɈQ"K5H1RT UH=r9\F;2G1Q= C7F dt1r=6Ыhڏ>C03l0.B8, c˱" VcϱwE 6wB aAHXLXNH $4 7 Q'"K&b21XH,#/{C7$C2'ITFnR#,4H#dk9, +ȅ3![ b@qS(RjJ4e2AURݨT5ZBRQ4u9̓IKhhitݕNWGw Ljg(gwLӋT071oUX**| J&*/Tު UUT^S}FU3S ԖUPSSg;goT?~YYLOCQ_ cx,!k u5&|v*=9C3J3WRf?qtN (~))4L1e\kXHQG6EYAJ'\'GgSSݧ M=:.kDwn^Loy}/TmG X $ <5qo</QC]@Caaᄑ.ȽJtq]zۯ6iܟ4)Y3sCQ? 0k߬~OCOg#/c/Wװwa>>r><72Y_7ȷOo_C#dz%gA[z|!?:eAAA!h쐭!ΑiP~aa~ 'W?pX15wCsDDDޛg1O9-J5*>.j<74?.fYXXIlK9.*6nl {/]py.,:@LN8A*%w% yg"/6шC\*NH*Mz쑼5y$3,幄'L Lݛ:v m2=:1qB!Mggfvˬen/kY- BTZ(*geWf͉9+̳ې7ᒶKW-X潬j9(xoʿܔĹdff-[n ڴ VE/(ۻCɾUUMfeI?m]Nmq#׹=TR+Gw- 6 U#pDy  :v{vg/jBFS[b[O>zG499?rCd&ˮ/~јѡ򗓿m|x31^VwwO| (hSЧc3- cHRMz%u0`:o_F@8N ' p @8N@8}' p '#@8N@8N pQ9p!i~}|6-ӪG` VP.@*j>[ K^<֐Z]@8N'KQ<Q(`s" 'hgpKB`R@Dqj '  'P$a ( `D$Na L?u80e J,K˷NI'0eݷ(NI'؀ 2ipIIKp`:O'`ʤxB8Ѥx Ѥx $ $P6 :vRNb 'p,>NB 'P]-->P T+*^h& p '‰a ‰ (ĵt#u33;Nt̵'ޯ; [3W ~]0KH1q@8]O2]3*̧7# *p>us p _6]/}-4|t'|Smx= DoʾM×M_8!)6lq':l7!|4} '\ne t!=hnLn (~Dn\+‰_4k)0e@OhZ`F `.m1} 'vp{F`ON7Srx 'D˸nV`><;yMx!IS钦OM)Ե٥x 'DSD6bS8!" ODz#R >S8!7ّxEh0m$MIPHi$IvS8IN$I p$O8I,sk&I)$IN$Hi$I^Ah.p$MIN$IR8I·N "IF9Ah0m$MIN$IR8IN$I 3jIU;kO$ɳN$+ q.x* tEXtComment

Viewing File: /home/u456810272/domains/globalsoftech.org.in/public_html/unimatrix/admin/getdatachart.php

<?php

include_once('../common/init.loader.php');

if (verifylog_sess('admin') == '') {
    die('o o p s !');
}

// registered and incoming
function getDataChart($days, $format = 'd/m') {
    global $db;

    $m = date("m");
    $de = date("d");
    $y = date("Y");
    $allarr = $dateArray = $datearr = $refarr = $ernarr = array();
    for ($i = 0; $i <= $days - 1; $i++) {
        $dateArray[] = date($format, mktime(0, 0, 0, $m, ($de - $i), $y));
        $datearr[] = date('Y-m-d', mktime(0, 0, 0, $m, ($de - $i), $y));
    }

    foreach ($datearr as $key => $value) {
        $condition = " AND mbrstatus = '1' AND in_date LIKE '%{$value}%'";
        $row = $db->getAllRecords(DB_TBLPREFIX . '_mbrs', 'COUNT(*) as totref', $condition);
        $valamount = ($row[0]['totref'] > 9999999) ? 10000000 : $row[0]['totref'];
        $refarr[] = intval($valamount);
    }
    foreach ($datearr as $key => $value) {
        $condition = " AND txtoid = '0' AND txstatus = '1' AND (txtoken LIKE '%|REG:%' OR txtoken LIKE '%|RENEW:%') AND txdatetm LIKE '%{$value}%'";
        $row = $db->getAllRecords(DB_TBLPREFIX . '_transactions', 'SUM(txamount) as sumearn', $condition);
        $valamount = ($row[0]['sumearn'] > 9999999) ? 10000000 : $row[0]['sumearn'];
        $ernarr[] = floatval($valamount);
    }

    $allarr['isdat1'] = array_reverse($refarr);
    $allarr['isdat2'] = array_reverse($ernarr);
    $allarr['islbel'] = array_reverse($dateArray);

    $allarr['label1'] = 'Registered';
    $allarr['label2'] = 'Incoming';
    $allarr['text'] = 'Registered & Incoming';
    return $allarr;
}

// registered and member
function getDataChart1($days, $format = 'd/m') {
    global $db, $cfgtoken;

    $m = date("m");
    $de = date("d");
    $y = date("Y");
    $allarr = $dateArray = $datearr = $regarr = $mbrarr = array();
    for ($i = 0; $i <= $days - 1; $i++) {
        $dateArray[] = date($format, mktime(0, 0, 0, $m, ($de - $i), $y));
        $datearr[] = date('Y-m-d', mktime(0, 0, 0, $m, ($de - $i), $y));
    }

    foreach ($datearr as $key => $value) {
        if ($cfgtoken['isautoregplan'] == 1) {
            $condition = " AND reg_date LIKE '%{$value}%'";
            $row = $db->getAllRecords(DB_TBLPREFIX . '_mbrplans', 'COUNT(*) as totref', $condition);
        } else {
            $condition = " AND in_date LIKE '%{$value}%'";
            $row = $db->getAllRecords(DB_TBLPREFIX . '_mbrs', 'COUNT(*) as totref', $condition);
        }
        $regarr[] = intval($row[0]['totref']);
    }
    foreach ($datearr as $key => $value) {
        if ($cfgtoken['isautoregplan'] == 1) {
            $condition = " AND reg_date LIKE '%{$value}%' AND mpstatus = '1'";
            $row = $db->getAllRecords(DB_TBLPREFIX . '_mbrplans', 'COUNT(*) as totref', $condition);
        } else {
            $condition = " AND reg_date LIKE '%{$value}%'";
            $row = $db->getAllRecords(DB_TBLPREFIX . '_mbrplans', 'COUNT(*) as totref', $condition);
        }
        $mbrarr[] = intval($row[0]['totref']);
    }

    $allarr['isdat1'] = array_reverse($regarr);
    $allarr['isdat2'] = array_reverse($mbrarr);
    $allarr['islbel'] = array_reverse($dateArray);

    $allarr['label1'] = 'Registered';
    $allarr['label2'] = 'Member';
    $allarr['text'] = 'Registered & Member';
    return $allarr;
}

// incoming and withdraw
function getDataChart2($days, $format = 'd/m') {
    global $db;

    $m = date("m");
    $de = date("d");
    $y = date("Y");
    $allarr = $dateArray = $datearr = $ernarr = $wtdrarr = array();
    for ($i = 0; $i <= $days - 1; $i++) {
        $dateArray[] = date($format, mktime(0, 0, 0, $m, ($de - $i), $y));
        $datearr[] = date('Y-m-d', mktime(0, 0, 0, $m, ($de - $i), $y));
    }

    foreach ($datearr as $key => $value) {
        $condition = " AND txtoid = '0' AND (txtoken LIKE '%|REG:%' OR txtoken LIKE '%|RENEW:%' OR txtoken LIKE '%|STORE:%') AND txdatetm LIKE '%{$value}%'";
        $row = $db->getAllRecords(DB_TBLPREFIX . '_transactions', 'SUM(txamount) as sumearn', $condition);
        $valamount = ($row[0]['sumearn'] > 9999999) ? 10000000 : $row[0]['sumearn'];
        $ernarr[] = floatval($valamount);
    }
    foreach ($datearr as $key => $value) {
        $condition = " AND txfromid = '0' AND txtoid > '0' AND txtoken LIKE '%|WIDR:%' AND txdatetm LIKE '%{$value}%'";
        $row = $db->getAllRecords(DB_TBLPREFIX . '_transactions', 'SUM(txamount) as sumearn', $condition);
        $valamount = ($row[0]['sumearn'] > 9999999) ? 10000000 : $row[0]['sumearn'];
        $wtdrarr[] = floatval($valamount);
    }

    $allarr['isdat1'] = array_reverse($ernarr);
    $allarr['isdat2'] = array_reverse($wtdrarr);
    $allarr['islbel'] = array_reverse($dateArray);

    $allarr['label1'] = 'Incoming';
    $allarr['label2'] = 'Withdraw';
    $allarr['text'] = 'Incoming & Withdraw';
    return $allarr;
}

function getDataChart3($limit) {
    global $db, $country_array;

    $allarr = $userRow = $labelarr = $refarr = array();

    $hit = 0;
    $row = $db->getRecFrmQry("SELECT country FROM " . DB_TBLPREFIX . "_mbrs WHERE 1 GROUP BY country");
    foreach ($row as $val) {
        $label = $val['country'];
        $labelarr[] = (strlen($label ?? '') == 1) ? 'Unknown' : ucwords(strtolower($country_array[$label] ?? ''));
        $condition = " AND country = '{$val['country']}'";
        $row = $db->getAllRecords(DB_TBLPREFIX . '_mbrs', 'COUNT(*) as totref', $condition);
        $refarr[] = intval($row[0]['totref']);
        $hit++;
        if ($limit <= $hit) {
            break;
        }
    }

    $allarr['isdat1'] = $refarr;
    $allarr['islbel'] = $labelarr;

    $allarr['label1'] = 'Country';
    $allarr['text'] = 'Member by Country';
    return $allarr;
}

$seskey = verifylog_sess('admin');
if ($seskey == '') {
    $datarr[] = array();
    echo json_encode($datarr);
    die();
}

$dataform = intval($FORM['dchart']);
switch ($dataform) {
    case "1":
        $getallarr = getDataChart1(7, "j M");
        break;
    case "2":
        $getallarr = getDataChart2(7, "j M");
        break;
    case "3":
        $getallarr = getDataChart3(9);
        break;
    default:
        $getallarr = getDataChart(7, "l\n j M");
}

echo json_encode($getallarr);
Back to Directory=ceiIENDB`