searchUser($keywords,$fields,'','','pagenav',$_GET['p']); echo $alls; exit; } else if ($_GET['getlist'] == 'ajax'){ $keywords = $_GET['keyword']; $fields = $_GET['field']; $alls = $user_obj->searchUser($keywords,$fields,'','','data'); $totalrows = sizeof($alls); $totalpgs = ceil($totalrows / $general['showperpageadmin']); $pgs = handlepage($_GET['p'],$totalpgs); $dblast = $user_obj->searchUser($keywords,$fields,$_GET['sortf'],$_GET['sortd'],'data',$pgs); $listtr = ''; if (sizeof($dblast) > 0){ foreach ($dblast as $result){ $statusdep = ''; switch ($result['status']){ case '1' : $statusdep = 'Active'; break; case '2' : $statusdep = 'Inactive'; break; } $listr .= ' '.$result['email'].' '.$result['firstname'].' '.$result['lastname'].' '.$result['companyphone'].' '.number_format($result['deposit'], 0, ",", ".").' '.$statusdep.' '; } } else{ $listr = 'NO DATA'; } echo $listr; exit; } else if($_GET['actions'] == 'checkSaldo'){ //$reff = 'SALDO'.date('dmYHis'); $mandiri->CHECK_SALDO(''); $response = $mandiri->run(); /* $mandiri->CHECK_SALDO(''); echo var_dump($mandiri->ap_param).'


'; $response = $mandiri->run(); echo var_dump($response).'


';exit; */ print_r($response);exit; } if($_POST['do'] == 'filter_report') { $show_table_list = true; if(!empty($_POST['month']) && !empty($_POST['year'])) { $month = $_POST['month']; $year = $_POST['year']; $month_index = $month - 1; $saldo_db = $db->fetch_one("SELECT (SUM(nominal_in) - SUM(nominal_out)) as saldo_awal FROM transaction_summary WHERE (MONTH(STR_TO_DATE(month_year, '%Y%m')) < MONTH(STR_TO_DATE('".$db->clean($year.$month)."', '%Y%m')) AND YEAR(STR_TO_DATE(month_year, '%Y%m')) = YEAR(STR_TO_DATE('".$db->clean($year.$month)."', '%Y%m'))) || (YEAR(STR_TO_DATE(month_year, '%Y%m')) < YEAR(STR_TO_DATE('".$db->clean($year.$month)."', '%Y%m')))"); $saldo_awal = empty($saldo_db['saldo_awal'])?0:$saldo_db['saldo_awal']; $saldo_awal_txt = number_format($saldo_awal, 0, ",", "."); $saldo_akhir = $saldo_awal; /* Other Transaction */ $trx_db = $saldo_db = $db->fetch_all("SELECT * FROM other_transaction WHERE MONTH(created_date) = MONTH(STR_TO_DATE('".$db->clean($year.$month)."', '%Y%m')) AND YEAR(created_date) = YEAR(STR_TO_DATE('".$db->clean($year.$month)."', '%Y%m')) ORDER BY created_date ASC"); $trx_list = ''; if(sizeof($trx_db) > 0){ foreach($trx_db as $row){ if($row['type'] == 1){ $saldo_akhir += $row['amount']; $total_in += $row['amount']; } else if($row['type'] == 2){ $saldo_akhir -= $row['amount']; $total_out += $row['amount']; } $trx_list .= ' Transaksi Lain - lain '.($row['type'] == 1?number_format($row['amount'], 0, ",", "."):'-').' '.($row['type'] == 2?number_format($row['amount'], 0, ",", "."):'-').' '.number_format($saldo_akhir, 0, ",", ".").' '; } } /* Deposit */ $deposit_db = $db->fetch_one("SELECT SUM(amount) as total_deposit FROM deposit WHERE MONTH(approved_date) = MONTH(STR_TO_DATE('".$db->clean($year.$month)."', '%Y%m')) AND YEAR(approved_date) = YEAR(STR_TO_DATE('".$db->clean($year.$month)."', '%Y%m'))"); $total_deposit = empty($deposit_db['total_deposit'])?0:$deposit_db['total_deposit']; $saldo_akhir += $total_deposit; $total_in += $total_deposit; $report_list = ' Total Deposit '.number_format($total_deposit, 0, ",", ".").' - '.number_format($saldo_akhir, 0, ",", ".").' '; $mandiri_trx_db = $db->fetch_one(" SELECT SUM(c.total + o.total + p.total + r.total) as total_amount, SUM(c.fee + o.fee + p.fee + r.fee) as total_fee FROM (SELECT SUM(amount) as total, SUM(fee) as fee FROM bsm_clearing WHERE MONTH(created_date) = MONTH(STR_TO_DATE('".$db->clean($year.$month)."', '%Y%m')) AND YEAR(created_date) = YEAR(STR_TO_DATE('".$db->clean($year.$month)."', '%Y%m'))) c, (SELECT SUM(amount) as total, SUM(fee) as fee FROM bsm_online WHERE MONTH(created_date) = MONTH(STR_TO_DATE('".$db->clean($year.$month)."', '%Y%m')) AND YEAR(created_date) = YEAR(STR_TO_DATE('".$db->clean($year.$month)."', '%Y%m'))) o, (SELECT SUM(amount) as total, SUM(fee) as fee FROM bsm_pos WHERE MONTH(created_date) = MONTH(STR_TO_DATE('".$db->clean($year.$month)."', '%Y%m')) AND YEAR(created_date) = YEAR(STR_TO_DATE('".$db->clean($year.$month)."', '%Y%m'))) p, (SELECT SUM(amount) as total, SUM(fee) as fee FROM bsm_rtgs WHERE MONTH(created_date) = MONTH(STR_TO_DATE('".$db->clean($year.$month)."', '%Y%m')) AND YEAR(created_date) = YEAR(STR_TO_DATE('".$db->clean($year.$month)."', '%Y%m'))) r "); $total_amount = empty($mandiri_trx_db['total_amount'])?0:$mandiri_trx_db['total_amount']; $saldo_akhir -= $total_amount; $total_out += $total_amount; $report_list .= ' Total Transaksi Member/Admin - '.number_format($total_amount, 0, ",", ".").' '.number_format($saldo_akhir, 0, ",", ".").' '; $total_fee = empty($mandiri_trx_db['total_fee'])?0:$mandiri_trx_db['total_fee']; $saldo_akhir -= $total_fee; $total_out += $total_fee; $report_list .= ' Total Fee - '.number_format($total_fee, 0, ",", ".").' '.number_format($saldo_akhir, 0, ",", ".").' '; $total_in = number_format($total_in, 0, ",", "."); $total_out = number_format($total_out, 0, ",", "."); } else{ redirecting("adminbalancereport.php?msg=error"); } } $monthlist = 'Bulan'; if(sizeof($arrmonthnameassoc) > 0){ $i = 1; foreach($arrmonthnameassoc as $key => $value){ $monthlist .= ''.$value.''; $i++; } } $yearlist = 'Tahun'; $curryear = (int)date('Y'); while($curryear >= $installyear){ $yearlist .= ''.$installyear.''; $installyear++; } require_once 'incl/global_template.php'; $theme = gettemplate('adminbalancereport'); eval("\$theme = \"$theme\";"); echo $theme; ?>