<?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>";