public function RelPatrimonio()
{
$array_data = explode('/', $data);
$data = mktime(0, 0, 0, $array_data[1], $array_data[0], $array_data[2]);
$sql = "SELECT\n A.codigo_patrimonio, A.descricao,\n A.data, A.quantidade , A.valor,\n A.codigo_professor , B.nome\n FROM pilates.patrimonio AS A\n LEFT JOIN pilates.professor AS B ON (A.codigo_professor = B.codigo_professor)\n WHERE A.apagado = 0\n ORDER BY A.codigo_patrimonio DESC ";
//echo $sql;
return MysqlManager::ExecutaConsultaMysql($sql, $this->db);
}
function get_kartukeluarga_id($nik)
{
$sql = "select keluarga_id from penduduk where nik = '{$nik}'";
$connection = MysqlManager::get_connection();
$result = $connection->query($sql);
check_error($connection);
$row = $result->fetch_object();
MysqlManager::close_connection($connection);
return $row->keluarga_id;
}
function get_alamat_id($sql)
{
if (strlen($sql) == 0) {
return "";
}
$conn = MysqlManager::get_connection();
$result = $conn->query($sql);
$row = $result->fetch_array();
MysqlManager::close_connection($conn);
return $row['id'];
}
public function get_penduduk_id($nik)
{
$connection = MysqlManager::get_connection();
$result = $connection->query("select id from penduduk where nik = '{$nik}'");
$id = null;
if ($result) {
$row = $result->fetch_object();
$id = $row->id;
}
MysqlManager::close_connection($connection);
return $id;
}
function retrieve_data()
{
$connection = MysqlManager::get_connection();
$result = $connection->query($this->sql);
check_error($connection);
$row = $result->fetch_object();
$this->nik = $row->nik;
$this->nama = $row->nama;
$this->jenis_kelamin = $row->jenis_kelamin;
$this->photo = $row->photo;
$this->status_nikah = $row->status_nikah;
$this->gol_darah = $row->gol_darah;
$this->tempat_lahir = $row->tmp_lahir;
$this->tgl_lahir = $row->tgl_lahir;
$this->agama = $row->agama;
$this->pendidikan = $row->pendidikan;
$this->pekerjaan = $row->pekerjaan;
$this->keluarga_id = $row->keluarga_id;
$this->wni = $row->wni;
// --
$sql = "select alamat_id from keluarga where id = {$this->keluarga_id}";
$result = $connection->query($sql);
check_error($connection);
$alamat_id = $result->fetch_object()->alamat_id;
$sql = "select a.alamat as alamat, a.rukun_tetangga as rt, a.rukun_warga as rw,\r\r\n kel.nama_kelurahan as kelurahan, kec.nama_kecamatan as kecamatan, kec.kodepos as kodepos \r\r\n from alamat a, kelurahan kel, kecamatan kec where a.id = {$alamat_id} and a.kelurahan_id = kel.id and\r\r\n kel.kecamatan_id = kec.id ";
$result = $connection->query($sql);
check_error($connection);
$row = $result->fetch_object();
$this->alamat = $row->alamat;
$this->rt = $row->rt;
$this->rw = $row->rw;
$this->kelurahan = $row->kelurahan;
$this->kecamatan = $row->kecamatan;
$this->kodepos = $row->kodepos;
MysqlManager::close_connection($connection);
}
break;
case "edit":
$username = $_POST['username'];
$password = $_POST['password'];
$id = $_POST['id'];
$sql = "update users set username = '******', password = password('{$password}') where id = {$id}";
$connection->query($sql);
check_error($connection);
MysqlManager::close_connection($connection);
break;
case "del":
$id = $_POST['id'];
$sql = "delete from users where id = {$id}";
$connection->query($sql);
check_error($connection);
MysqlManager::close_connection($connection);
break;
}
}
if (isset($_POST['data'])) {
$data_request = $_POST['data'];
switch ($data_request) {
case 1:
// already exist a user
if (isset($_SESSION['user'])) {
$menus = retrieve_menus();
$user = $_SESSION['user'];
$resp = array('result' => 1, 'menu' => $menus, 'user' => $user);
echo json_encode($resp);
} else {
// no user exist in session
public function EditarUsuario($id, $nome, $senha)
{
$sql = "UPDATE usuarios SET USUARIO_NOME = '{$nome}', USUARIO_SENHA = '{$senha}' WHERE id = '{$id}'";
//echo $sql;
return MysqlManager::ExecutaConsultaMysql($sql, $this->db);
}
function headerPDF()
{
global $app_strings;
global $pdfFontSize, $pdfColors;
$headerLblCol = $pdfColors["headerLbl"];
$headerFldCol = $pdfColors["headerFld"];
$headerBg = $pdfColors["field"];
$headerFontSize = $pdfFontSize["header"];
$datab = new MysqlManager();
$datab->connect();
$q = "SELECT logo, country, city, state, street, phone, fax, web, email FROM companyinfo";
$res = $datab->query($q, true, " Error filling in additional detail fields: ");
$r = mysql_fetch_array($res);
$header = null;
$header .= "<img width=212px height=40px src=include/images/company_logo_pdf.jpg>";
$header .= "<br /><br /><hr>";
$header .= "<table cellspacing=0 cellpadding=0 width=100% bgcolor={$headerBg}>";
$header .= "<tr><td><font size={$headerFontSize}>";
$header .= "<font color={$headerLblCol}>" . $app_strings['LBL_ADDRESS'] . ":</font> <font color={$headerFldCol}>" . $r['street'] . ", " . $r['city'] . ", " . $r['country'] . "</font> ";
$header .= "<font color={$headerLblCol}>" . $app_strings['LBL_PHONE'] . ":</font> <font color={$headerFldCol}>" . $r['phone'] . "</font>, ";
$header .= "<font color={$headerLblCol}>" . $app_strings['LBL_FAX'] . ":</font> <font color={$headerFldCol}>" . $r['fax'] . "</font>, ";
$header .= "<font color={$headerLblCol}>" . $app_strings['LBL_WWW'] . ":</font> <font color={$headerFldCol}>" . $r['web'] . "</font>, ";
$header .= "<font color={$headerLblCol}>" . $app_strings['LBL_EMAIL'] . ":</font> <font color={$headerFldCol}>" . $r['email'] . "</font>";
$header .= "</font></td></tr></table>";
return $header;
}
/**
* will quote the strings of the passed in array
* The array must only contain strings
*
* @param ARRAY $array
* @param unknown_type $isLike
*/
function arrayQuote(&$array, $isLike = true)
{
for ($i = 0; $i < count($array); $i++) {
$array[$i] = MysqlManager::quote($array[$i], $isLike);
}
}
/**
* @see MysqlManager::query()
*/
public function query($sql, $dieOnError = false, $msg = '', $suppress = false, $autofree = false)
{
static $queryMD5 = array();
parent::countQuery($sql);
$GLOBALS['log']->info('Query:' . $sql);
$this->checkConnection();
//$this->freeResult();
$this->query_time = microtime(true);
$this->lastsql = $sql;
if ($suppress == true) {
} else {
$result = mysqli_query($this->database, $sql);
}
$md5 = md5($sql);
if (empty($queryMD5[$md5])) {
$queryMD5[$md5] = true;
}
$this->lastmysqlrow = -1;
$this->query_time = microtime(true) - $this->query_time;
$GLOBALS['log']->info('Query Execution Time:' . $this->query_time);
// This is some heavy duty debugging, leave commented out unless you need this:
/*
$bt = debug_backtrace();
for ( $i = count($bt) ; $i-- ; $i > 0 ) {
if ( strpos('MysqliManager.php',$bt[$i]['file']) === false ) {
$line = $bt[$i];
}
}
$GLOBALS['log']->fatal("${line['file']}:${line['line']} ${line['function']} \nQuery: $sql\n");
*/
$this->checkError($msg . ' Query Failed: ' . $sql, $dieOnError);
if ($autofree) {
$this->lastResult[] =& $result;
}
return $result;
}
public function RelProfessor()
{
$sql = "SELECT codigo_professor, nome, telefone_celular,\n endereco,bairro,crefito FROM pilates.professor WHERE apagado = 1\n ORDER BY codigo_professor DESC";
//echo $sql;
return MysqlManager::ExecutaConsultaMysql($sql, $this->db);
}
public function ExcluirProfessor($id)
{
$sql = "UPDATE pilates.professor SET apagado = 0 where codigo_professor = '{$id}'";
//echo $sql;
return MysqlManager::ExecutaPersistenciaMysql($sql, $this->db);
}
/**
* @see MysqlManager::query()
*/
public function query($sql, $dieOnError = false, $msg = '', $suppress = false, $autofree = false)
{
static $queryMD5 = array();
parent::countQuery($sql);
//$GLOBALS['log']->info('Query:' . $sql);
$this->checkConnection();
//$this->freeResult();
$this->query_time = microtime(true);
$this->lastsql = $sql;
if ($suppress == true) {
} else {
$result = mysqli_query($this->database, $sql);
}
$md5 = md5($sql);
if (empty($queryMD5[$md5])) {
$queryMD5[$md5] = true;
}
$this->lastmysqlrow = -1;
$this->query_time = microtime(true) - $this->query_time;
//$GLOBALS['log']->info('Query Execution Time:'.$this->query_time);
//$this->checkError($msg.' Query Failed:' . $sql . '::', $dieOnError);
$this->checkError($msg . ' Failed:::', 'SQL');
if ($autofree) {
$this->lastResult[] =& $result;
}
return $result;
}
private function get_orang_tua($id)
{
$resp = array();
if (strlen($id) > 0) {
$sql = "select p.nama as ayah, pp.nama as ibu from penduduk p, penduduk pp,\r\n orang_tua o where p.id = o.bapak_id and pp.id = o.ibu_id and o.id = {$id}";
$conn = MysqlManager::get_connection();
$result = $conn->query($sql);
check_error($conn);
$row = $result->fetch_object();
$resp["ayah"] = $row->ayah;
$resp["ibu"] = $row->ibu;
MysqlManager::close_connection($conn);
} else {
$resp["ayah"] = "";
$resp["ibu"] = "";
}
return $resp;
}
public function EditarVigario($id, $destaque, $noticia)
{
$sql = "UPDATE sjbb.sjbb_palavravigario SET PALAVRAVIGARIO_TITULO='{$destaque}', PALAVRAVIGARIO_DESCRICAO='{$noticia}' WHERE PALAVRAVIGARIO_ID='{$id}'";
return MysqlManager::ExecutaPersistenciaMysql($sql, $this->db);
}
public function ExibirIdProfissional()
{
$sql = "SELECT A.IDCURRICULO AS IDCURRICULO , B.IDEXPERIENCIAPROFISSIONAL AS PROFISSIONAL FROM posgraduacao.tblcurriculos AS A\n LEFT JOIN posgraduacao.tblexperienciaprofissional AS B ON (A.IDCURRICULO = B.IDCURRICULO) ";
return MysqlManager::ExecutaConsultaMysql($sql, $this->db);
}
public function ApagarArtigos($id)
{
$sql = "UPDATE posgraduacao.tblartigos SET APAGADO = 1 WHERE IDARTIGO = '{$id}'";
// echo $sql;
return MysqlManager::ExecutaPersistenciaMysql($sql, $this->db);
}
public function retrieve_data()
{
$conn = MysqlManager::get_connection();
$sql = "select n.no_pernikahan as nomor_pernikahan, n.tanggal as tanggal,\n n.wali as wali, p.nama as pria, p.wni as wni_pria, a.agama as agama_pria,\n pp.nama as wanita, pp.wni as wni_wanita, aa.agama as agama_wanita from pernikahan n,\n penduduk p, penduduk pp, agama a, agama aa where n.id = {$this->id} and\n n.pria = p.id and n.wanita = pp.id and p.agama_id = a.id and pp.agama_id = aa.id";
$result = $conn->query($sql);
check_error($conn);
$row = $result->fetch_object();
$this->pria = $row->pria;
$this->no_pernikahan = $row->nomor_pernikahan;
$this->tanggal_menikah = $row->tanggal;
$this->wali = $row->wali;
$this->pria_agama = $row->agama_pria;
$this->pria_wni = $row->wni_pria;
$this->wanita = $row->wanita;
$this->wanita_agama = $row->agama_wanita;
$this->wanita_wni = $row->wni_wanita;
MysqlManager::close_connection($conn);
}
public function retrieve_data()
{
$conn = MysqlManager::get_connection();
$sql = "select p.nik as nik, p.nama as nama, p.tmp_lahir as tempat_lahir, p.tgl_lahir as tgl_lahir, \r\n p.jenis_kelamin as jenis_kelamin, p.wni as wni, \r\n a.no_akta as no_akta, a.created_at as tanggal_pembuatan, pp.nama as ayah, ppp.nama as ibu \r\n from penduduk p, penduduk pp, penduduk ppp, akta_kelahiran a, orang_tua o where p.id = " . $this->id . " and p.id = a.penduduk_id and p.orangtua_id = o.id and o.bapak_id = pp.id and o.ibu_id = ppp.id";
$result = $conn->query($sql);
check_error($conn);
$row = $result->fetch_object();
$this->nik = $row->nik;
$this->nama = $row->nama;
$this->tempat_lahir = $row->tempat_lahir;
$this->tanggal_lahir = $row->tgl_lahir;
$this->jenis_kelamin = $row->jenis_kelamin;
$this->wni = $row->wni;
$this->no_akta = $row->no_akta;
$this->tanggal_pembuatan = $row->tanggal_pembuatan;
$this->ayah = $row->ayah;
$this->ibu = $row->ibu;
MysqlManager::close_connection($conn);
}
/**
* @see MysqlManager::query()
*/
protected function queryMulti($sql, $dieOnError = false, $msg = '', $suppress = false, $keepResult = false, $multiquery = true)
{
if (is_array($sql)) {
return $this->queryArray($sql, $dieOnError, $msg, $suppress);
//queryArray does not support any return sets
}
static $queryMD5 = array();
parent::countQuery($sql);
$GLOBALS['log']->info('Query:' . $sql);
$this->checkConnection();
$this->query_time = microtime(true);
$this->lastsql = $sql;
if ($multiquery) {
$query_result = $suppress ? @mysqli_multi_query($this->database, $sql) : mysqli_multi_query($this->database, $sql);
$result = mysqli_use_result($this->database);
// Clear any remaining recordsets
while (mysqli_next_result($this->database)) {
$tmp_result = mysqli_use_result($this->database);
mysqli_free_result($tmp_result);
}
} else {
$result = $suppress ? @mysqli_query($this->database, $sql) : mysqli_query($this->database, $sql);
}
$md5 = md5($sql);
if (empty($queryMD5[$md5])) {
$queryMD5[$md5] = true;
}
$this->query_time = microtime(true) - $this->query_time;
$GLOBALS['log']->info('Query Execution Time:' . $this->query_time);
// slow query logging
if ($this->dump_slow_queries($sql)) {
$this->track_slow_queries($sql);
}
// This is some heavy duty debugging, leave commented out unless you need this:
/*
$bt = debug_backtrace();
$line['file'] = 'NO_FILE';
$line['line'] = 'NO_LINE';
$line['function'] = 'NO_FUNCTION';
$i = 0;
foreach ( $bt as $i => $tryLine ) {
if ( strpos($tryLine['file'],'include/database') === false && strpos($tryLine['file'],'include/SugarQuery') === false ) {
$line = $tryLine;
// Go function line up to find the real function
if ( isset($bt[($i+1)]['function']) ) {
$line['function'] = $bt[($i+1)]['function'];
}
break;
}
}
$dumpQuery = str_replace(array(' ',' ',' ',' ',' ',"\n","\t","\r"),
array(' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ',),
$sql);
$GLOBALS['log']->fatal("{$line['file']}:{$line['line']} ${line['function']} \nQuery: $dumpQuery\n");
*/
if ($keepResult) {
$this->lastResult = $result;
}
if ($this->database && mysqli_errno($this->database) == 2006 && $this->retryCount < 1) {
$GLOBALS['log']->fatal('mysqli has gone away, retrying');
$this->retryCount++;
$this->disconnect();
$this->connect();
return $this->query($sql, $dieOnError, $msg, $suppress, $keepResult);
} else {
$this->retryCount = 0;
}
$this->checkError($msg . ' Query Failed: ' . $sql, $dieOnError);
return $result;
}
$res = $datab->query($q, true, " Error filling in additional detail fields: ");
$r = mysql_fetch_array($res);
$sugar_smarty->assign('CI', $r);
///////////////////////////////////////////////////////////////////////////////
//// HANDLE CHANGES
if (isset($_REQUEST['process']) && $_REQUEST['process'] == 'true') {
$logo = $_REQUEST['logo'];
$country = $_POST['country'];
$city = $_POST['city'];
$state = $_POST['state'];
$street = $_POST['street'];
$phone = $_POST['phone'];
$fax = $_POST['fax'];
$web = $_POST['web'];
$email = $_POST['email'];
$datab = new MysqlManager();
$datab->connect();
$q = "SELECT * FROM `companyinfo`";
$res = $datab->query($q, true, " Error filling in additional detail fields: ");
$num = $datab->getRowCount($result);
if ($num = 0) {
$query = 'INSERT into companyinfo (logo, country, city, state, street, phone, fax, web, email) VALUES';
$query .= "('{$logo}', '{$country}', '{$city}', '{$state}', '{$street}', '{$phone}', '{$fax}', '{$web}', '{$email}') ";
$result = $datab->query($query, true, " Error filling in additional detail fields: ");
} else {
$query = "UPDATE companyinfo SET logo = '{$logo}' , \n country = '{$country}' , \n city = '{$city}', \n state = '{$state}', \n street = '{$street}', \n phone = '{$phone}', \n fax = '{$fax}', \n web = '{$web}', \n email = '{$email}'";
$result = $datab->query($query, true, " Error filling in additional detail fields: ");
}
$cfg->populateFromPost();
$cfg->handleOverride();
}
public function RelAlunos()
{
$sql = "SELECT \n A.codigo_paciente, A.nome as aluno,\n A.telefone_fixo, A.telefone_celular,\n A.endereco, A.bairro,\n A.numero, \n B.nome as Nome_Professor\n FROM pilates.paciente as A\n LEFT JOIN pilates.professor as B ON (A.codigo_professor = B.codigo_professor)\n WHERE A.apagado = 0 \n ORDER BY A.codigo_paciente DESC";
//echo $sql;
return MysqlManager::ExecutaConsultaMysql($sql, $this->db);
}
public static function ExecutaConsultaMysql($sql, $db)
{
//echo "sql MysqlManager:$sql no DB $db<br>";
$result = MysqlManager::mysqlQuery($sql, $db);
return MysqlManager::CarregaVariaveisMysql($result);
}
public function RelLog()
{
$sql = "SELECT\n A.codigo_professor,\n B.nome AS PROFESSOR,\n A.codigo_mensalidade,\n A.data_alteracao,\n A.aluno,\n C.codigo_paciente,\n C.nome as ALUNO,\n A.regapagado,\n A.regusuario\n FROM pilates.log as A\n LEFT JOIN pilates.professor AS B ON (B.codigo_professor = A.codigo_professor)\n LEFT JOIN pilates.paciente AS C ON (C.codigo_paciente = A.aluno)\n ORDER BY A.codigo_mensalidade DESC";
// echo $sql;
return MysqlManager::ExecutaConsultaMysql($sql, $this->db);
}
public function ApagarUsuario($id)
{
$sql = "UPDATE posgraduacao.tblusuarios SET APAGADO = 1 WHERE IDUSUARIO = '{$id}'";
// echo $sql;
return MysqlManager::ExecutaPersistenciaMysql($sql, $this->db);
}
public function ExcluirDicas($id)
{
$sql = "UPDATE posgraduacao.tbldicas SET APAGADO = 1 WHERE IDDICA = '{$id}'";
echo $sql;
return MysqlManager::ExecutaPersistenciaMysql($sql, $this->db);
}
public function ExcluirCurso($id)
{
$sql = "UPDATE posgraduacao.tblcursos SET apagado = 1 where IDCURSO = '{$id}'";
//echo $sql;
return MysqlManager::ExecutaPersistenciaMysql($sql, $this->db);
}
public function ApagarPresenca($id)
{
$sql = "UPDATE pilates.presenca SET apagado = 1 WHERE codigo_presenca = '{$id}'";
return MysqlManager::ExecutaPersistenciaMysql($sql, $this->db);
}
/**
*
* 批量转义字符串
* @param array $arrFields 要转义的数组
* @param array $arrStrFields 哪些KEY是字符串类型的
*/
public static function escapeStrings(&$arrFields, $arrStrFields = null)
{
$db = new MysqlManager();
if (false === $db->fetchMysqlHandler(null, 0)) {
KC_LOG_WARNING::waning(__FUNCTION__ . ' failed, fetch mysql handler failed [ dbNo: 0, arrFields: ' . json_encode($arrFields) . ', arrStrFields: ' . json_encode($arrStrFields) . ' ].');
return false;
}
foreach ($arrFields as $k => &$v) {
if (is_null($arrStrFields)) {
!is_null($v) && ($v = "'" . $db->escapeString($v) . "'");
continue;
}
in_array($k, $arrStrFields) && !is_null($v) && ($v = "'" . $db->escapeString($v) . "'");
}
return true;
}
public function EventosMaxId()
{
$sql = "SELECT MAX(IDEVENTOFOTO) AS ULTIMO FROM posgraduacao.tbleventofotos";
// echo $sql;
return MysqlManager::ExecutaConsultaMysql($sql, $this->db);
}
