<?php
//cari_anggota
include '../../inc/inc_koneksi.php';
include '../../inc/fungsi_tanggal.php';
include '../../inc/fungsi_koperasi.php';
$table = 'anggota';
$id = $_POST['cari'];
$q = "SELECT * FROM {$table} WHERE noanggota='{$id}'";
$sql = mysql_query($q);
$row = mysql_num_rows($sql);
if ($row > 0) {
$r = mysql_fetch_array($sql);
if ($r['jk'] == 'L') {
$sex = 'Laki-laki';
} else {
$sex = 'Perempuan';
}
$saldo = saldo($r['noanggota']);
echo "<table>\n\t\t<tr>\n\t\t\t<td>Nama</td>\n\t\t\t<td>: {$r['namaanggota']}</td>\n\t\t</tr>\n\t\t<tr>\n\t\t\t<td>Jenis Kelamin</td>\n\t\t\t<td>: {$sex}</td>\n\t\t</tr>\n\t\t<tr>\n\t\t\t<td>Tempat, Tgl Lahir</td>\n\t\t\t<td>: " . $r['tempat_lahir'] . ", " . jin_date_sql($r['tgl_lahir']) . "</td>\n\t\t</tr>\n\t\t<tr>\n\t\t\t<td>Alamat</td>\n\t\t\t<td>: " . $r['alamat'] . "</td>\n\t\t</tr>\n\t\t<tr>\n\t\t\t<td>Saldo</td>\n\t\t\t<td>: " . number_format($saldo) . "</td>\n\t\t</tr>\n\t</table>";
}
<?php include "../../inc/inc.koneksi.php"; include "../../inc/fungsi_koperasi.php"; $noanggota = $_POST['cari']; $saldo = saldo($noanggota); $data['saldo'] = $saldo; echo json_encode($data);
/**
* LISTA USUÁRIOS.
*/
function listarSaldo($aDados)
{
$tjax = new Tjax();
$fg = new FrameworkGeneric();
$fg->config($_SESSION['host']);
$host = $fg->host;
$tjax->addAssign('#painel', 'html', $fg->inc('listar.php'));
$tjax->addAssign('#navegacaoModulo', 'html', $fg->inc('navegacao.php'));
//LISTA SALDO.
$totalSaldo = saldo($aDados);
$tjax->addAssign('#saldo', 'html', 'R$ ' . number_format($totalSaldo, 2, '.', ','));
$graficoApi = saldoGrafico($aDados);
//LineChart, ColumnChart, BubbleChart, BarChart,
$tjax->addGrafico("#chart_div", $graficoApi, "LineChart", 'Fluxo de Renda', $host);
$tjax->setTimeout('timeout', "str = 'acao=listarSaldo'; \$.tjax('" . $host . "modulos/painel/dashboard/controller.php', 'STR='+\$.cry(str));", '15000');
$tjax->addScript("\$('#linkTransferncias').attr('href','" . $host . "painel/transferencia');");
$tjax->display();
listarPedido($aDados);
}
$sql = "SELECT saldo FROM cliente join usuario on(idusuario=usuario_idusuario) WHERE usuario='" . $_SESSION['usuario'] . "'";
/*** prepare the SQL statement ***/
$stmt = $dbh->prepare($sql);
/*** execute the prepared statement ***/
$stmt->execute();
$result = $stmt->fetch(PDO::FETCH_ASSOC);
/*** close the database connection ***/
$dbh = null;
return $result['saldo'];
} catch (PDOException $e) {
//echo $e->getMessage();
$exito = false;
}
return NULL;
}
$saldo = saldo();
$total = $carrito->total;
$restante = $saldo - $total;
$desactivado = $restante < 0 ? "disabled" : "";
?>
<!doctype html>
<html lang='es'>
<?php
include 'head.php';
?>
<body role="document">
<?php
include 'cabecera.php';
?>
<div class="container-fluid col-md-6 col-md-offset-3">
<div class="panel panel-default">
$data = mysql_query($query);
function myheader($judul_H)
{
echo "<div class='header'>\r\n\t\t <h2>" . $judul_H . "</h2>\r\n\t\t </div>\r\n\t\t<table class='grid' >\r\n\t\t<tr>\r\n\t\t\t<th width='5%'>No</th>\r\n\t\t\t<th >Nomor Anggota</th>\r\n\t\t\t<th >No Identitas</th>\r\n\t\t\t<th >Nama Anggota</th>\r\n\t\t\t<th >L/P</th>\r\n\t\t\t<th >HP</th>\r\n\t\t\t<th >Saldo</th>\r\n\t\t</tr>";
}
//echo $query;
function myfooter()
{
echo "</table>";
}
$no = 1;
$page = 1;
$stotal = 0;
while ($r_data = mysql_fetch_array($data)) {
$tgllhr = jin_date_str($r_data['tgl_lahir']);
$saldo = saldo($r_data['noanggota']);
//$total = $r_data[total];
$stotal = $stotal + $saldo;
if ($no % 40 == 1) {
if ($no > 1) {
myfooter();
echo "<div class=\"pagebreak\" align='right'>\r\n\t\t<div class='page' align='center'>Hal - {$page}</div>\r\n\t\t</div>";
$page++;
}
myheader($judul_H);
}
echo "<tr>\r\n\t\t\t<td align='center'>{$no}</td>\r\n\t\t\t<td align='center'>" . $r_data['noanggota'] . "</td>\r\n\t\t\t<td align='center'>" . $r_data['noidentitas'] . "</td>\r\n\t\t\t<td align='left'>" . $r_data['namaanggota'] . "</td>\r\n\t\t\t<td align='center'>" . $r_data['jk'] . "</td>\r\n\t\t\t<td align='left'>" . $r_data['hp'] . "</td>\r\n\t\t\t<td align='right'>" . number_format($saldo) . "</td>\r\n\t\t\t</tr>";
$no++;
}
myfooter();
echo "</table>";
