function seleccionarRegistro($param) { $select = array("farmacia", "idDispensable", "codigoNacionalPrescrito", "codigoNacional", "envases", "dni", "contenido", "pvpComer", "pvpCalculado", "aportacionProducto", "codigoAportacion", "idActoDispensacion", "idDispensacion", "farmaceutico", "CONVERT(nvarchar(30), fechaGrabacion, 126) as fechaGrabacion", "CONVERT(nvarchar(30), fechaAnulacion, 126) as fechaAnulacion", "CONVERT(nvarchar(30), fechaFirma, 126) as fechaFirma", "origen", "firma", "firmaFacturacion", "validado", "firmado", "borrado"); global $respError, $conn, $SQLserverName; $param = objectToArray($param); $farmacia = $param["farmacia"]; $DNIFarmacia = $param["DNIFarmacia"]; $where = array("farmacia =" => $farmacia); if (isset($param["idDispensable"])) { $idDispensable = $param["idDispensable"]; $where["idDispensable like"] = "%{$idDispensable}%"; } if (isset($param["fechaGrabacion"])) { $fechaGrabacion = $param["fechaGrabacion"]; $where["fechaGrabacion ="] = $fechaGrabacion; } if (DEBUG & DEBUG_LOG) { $mensaje = print_r($param, TRUE); $mensaje .= "--Llamada hecha en el fichero: " . __FILE__ . ", en la línea: " . __LINE__; error_log("[" . date("c") . "] \r\n {$mensaje}", 3, DIRECTORIO_LOG . __FUNCTION__ . "_" . date("YmdH") . ".log"); } $tabla = PREFIJO_TABLA_DISPENSACION . date("ym"); $resultadoSelect = querySelect($conn, $tabla, $select, $where); if ($resultadoSelect["columnasAfectadas"] === NULL) { $resultadoOperacion = array("codigoResultadoOperacion" => $resultadoSelect[0]["code"], "mensajeResultadoOperacion" => $resultadoSelect[0]["message"]); return array(__FUNCTION__ . "Result" => array("columnasAfectadas" => $resultadoSelect["columnasAfectadas"], "resultadoSelect" => $resultadoSelect["resultset"], "resultadoOperacion" => $resultadoOperacion)); } return array(__FUNCTION__ . "Result" => array("columnasAfectadas" => $resultadoSelect["columnasAfectadas"], "resultadoSelect" => $resultadoSelect["resultset"], "resultadoOperacion" => $respError->sinErrores())); }
/** * * @param array $param * @return array */ function obtenerCN($param) { $select = array("CN"); global $respError, $conn, $SQLserverName; $param = objectToArray($param); $farmacia = $param["farmacia"]; $DNIFarmacia = $param["DNIFarmacia"]; if (DEBUG & DEBUG_LOG) { $mensaje = print_r($param, TRUE); $mensaje .= "--Llamada hecha en el fichero: " . __FILE__ . ", en la línea: " . __LINE__; error_log("[" . date("c") . "] \r\n {$mensaje}", 3, DIRECTORIO_LOG . __FUNCTION__ . "_" . date("YmdH") . ".log"); } $tabla = "catalogo"; $resultadoSelect = querySelect($conn, $tabla, $select); if ($resultadoSelect["columnasAfectadas"] === NULL) { $resultadoOperacion = array("codigoResultadoOperacion" => $resultadoSelect[0]["code"], "mensajeResultadoOperacion" => $resultadoSelect[0]["message"]); return array(__FUNCTION__ . "Result" => array("resultadoOperacion" => $resultadoOperacion)); } elseif ($resultadoSelect["columnasAfectadas"] === 0) { return $respError->noHayRegistros($tabla, __FUNCTION__); } $CN = array(); foreach ($resultadoSelect["resultset"] as $value) { $CN[] = $value["CN"]; } return array(__FUNCTION__ . "Result" => array("CN" => $CN, "resultadoOperacion" => $respError->sinErrores())); }
/** * * @param date $fechaInicio * fecha incio de la consulta. * @param date $fechaFin. * @param string $Id_Receta * @param string $farmacia * @param string $DNI * * @return string XML de salida. */ function obtenerDatosDispensaciones($param) { global $respError, $conn, $SQLserverName; $param = objectToArray($param); $fechaInicio = $param["fechaInicio"]; $fechaFin = $param["fechaFin"]; $Id_Receta = $param["Id_Receta"]; $farmacia = $param["farmacia"]; $DNI = $param["DNI"]; //die(print_r($param)); // Comprobar formato fecha sea correcto (AAAA-MM-DD) if (!strtotime($fechaInicio) or !strtotime($fechaFin)) { $result = array(__FUNCTION__ . "Result" => array('resultadoOperacion' => $respError->errorFormatoFecha())); return $result; } // Comprobar que fechas no sean mayores que hoy if ($fechaInicio > date('Y-m-d') or $fechaFin > date('Y-m-d')) { $result = array(__FUNCTION__ . "Result" => array('resultadoOperacion' => $respError->errorFechaMayorHoy())); return $result; } //Comprobar que fecha inicial no el mayor que fecha final if (strtotime($fechaInicio) > strtotime($fechaFin)) { $result = array(__FUNCTION__ . "Result" => array('resultadoOperacion' => $respError->errorFechaInicioMayor())); return $result; } //Comprobar que mes incio y fin sean el mismo if (date('m', strtotime($fechaInicio)) != date('m', strtotime($fechaFin))) { $result = array(__FUNCTION__ . "Result" => array('resultadoOperacion' => $respError->errorMesInicioMesFinDistintos())); return $result; } //Comprobar que fecha sea superior a 31/01/2013 if (date('Y-m-d', strtotime($fechaInicio)) <= date('Y-m-d', strtotime('2013-01-31'))) { $result = array(__FUNCTION__ . "Result" => array('resultadoOperacion' => $respError->errorMesInicioMenorFecha())); return $result; } if (DEBUG & DEBUG_LOG) { $mensaje = print_r($param, TRUE); $mensaje .= "--Llamada hecha en el fichero: " . __FILE__ . ", en la línea: " . __LINE__; error_log("[" . date("c") . "] \r\n {$mensaje}", 3, DIRECTORIO_LOG . __FUNCTION__ . "_" . date("YmdH") . ".log"); } $diaInicio = date('d', strtotime($fechaInicio)); $diaFin = date('d', strtotime($fechaFin)); if (date('ym', strtotime($fechaInicio)) < "1506") { $tabla = PREFIJO_TABLA_DISPENSACION . date('Ym', strtotime($fechaInicio)); } else { $tabla = PREFIJO_TABLA_DISPENSACION . date('ym', strtotime($fechaInicio)); } $select = array("Farmacia", "idtx", "Dni", "Codfarmacia", "Codcolegiado", "Numcolegiado", "Tsi", "Id_Receta", "Pvpcalculadoaport", "Pvptotal", "Euros_receta", "Envases", "Codnacional", "Pvpcomerenv", "Aportacionproducto", "Check_atep", "indicador_euro", "Check_objecion", "Check_visado", "CONVERT(nvarchar(30), FechaGrabacion, 126) as FechaGrabacion"); $where = array("day(FechaGrabacion) >=" => $diaInicio, "day(FechaGrabacion) <=" => $diaFin, "Id_Receta like" => "%{$Id_Receta}%", "Farmacia =" => $farmacia); $resultadoSelect = querySelect($conn, $tabla, $select, $where); if ($resultadoSelect["columnasAfectadas"] === NULL) { $resultadoOperacion = array("codigoResultadoOperacion" => $resultadoSelect[0]["code"], "mensajeResultadoOperacion" => $resultadoSelect[0]["message"]); return array(__FUNCTION__ . "Result" => array("columnasAfectadas" => $resultadoSelect["columnasAfectadas"], "listaDatosDispensacion" => $resultadoSelect["resultset"], "resultadoOperacion" => $resultadoOperacion)); } return array(__FUNCTION__ . "Result" => array("columnasAfectadas" => $resultadoSelect["columnasAfectadas"], "listaDatosDispensacion" => $resultadoSelect["resultset"], "resultadoOperacion" => $respError->sinErrores())); }
function getLogin($username, $password) { $user = null; $user = querySelect('*', 'user', 'username = "******" AND password = "******"', '0,1'); if (sizeof($user) != 0) { $date = date_create(); $date = date_timestamp_get($date); $session = md5($password . $date); $update = queryUpdate('user', 'session = "' . $session . '"', 'username = "******" AND password = "******"'); if (!$update) { $user = null; } else { $user = querySelect('*', 'user', 'session = "' . $session . '"', '0,1'); } } return $user; }
/** * * @param array $param * @return array */ function obtenerImagenes($param) { $select = array("codigoProducto", "nombreProducto", "imagen", "prospecto", "precio", "fabricante", "CN"); global $respError, $conn, $SQLserverName; $param = objectToArray($param); $farmacia = $param["farmacia"]; $DNIFarmacia = $param["DNIFarmacia"]; $codigoProductoParam = $param["codigoProducto"]; if (DEBUG & DEBUG_LOG) { $mensaje = print_r($param, TRUE); $mensaje .= "--Llamada hecha en el fichero: " . __FILE__ . ", en la línea: " . __LINE__; error_log("[" . date("c") . "] \r\n {$mensaje}", 3, DIRECTORIO_LOG . __FUNCTION__ . "_" . date("YmdH") . ".log"); } $tabla = "catalogo"; $whereString = "WHERE codigoProducto = '{$codigoProductoParam}'"; $resultadoSelect = querySelect($conn, $tabla, $select, $whereString); if ($resultadoSelect["columnasAfectadas"] === NULL) { $resultadoOperacion = array("codigoResultadoOperacion" => $resultadoSelect[0]["code"], "mensajeResultadoOperacion" => $resultadoSelect[0]["message"]); return array(__FUNCTION__ . "Result" => array("resultadoOperacion" => $resultadoOperacion)); } elseif ($resultadoSelect["columnasAfectadas"] === 0) { return $respError->noHayRegistros($tabla, __FUNCTION__); } $nombre_fichero = $resultadoSelect["resultset"][0]["imagen"]; // Cargar la trama y la foto para aplicarle la marca de agua $trama = imagecreatefrompng('C:\\www\\catalogoVFarma\\img\\Marca-de-agua-Cofmservicio32.png'); $imagen = imagecreatefromjpeg($nombre_fichero); // Establecer los márgenes para la trama y obtener el alto/ancho de la imagen de la trama $margen_dcho = 0; $margen_inf = 0; $sx = imagesx($trama); $sy = imagesy($trama); // Copiar la imagen de la trama sobre nuestra foto usando los índices de márgen y el // ancho de la foto para calcular la posición de la trama. imagecopy($imagen, $trama, imagesx($imagen) - $sx - $margen_dcho, imagesy($imagen) - $sy - $margen_inf, 0, 0, imagesx($trama), imagesy($trama)); // Imprimir la salida al búfer ob_start(); imagejpeg($imagen); $imagen_string = ob_get_contents(); ob_end_clean(); //Liberar la memoria imagedestroy($imagen); imagedestroy($trama); return array(__FUNCTION__ . "Result" => array("nombreProducto" => $resultadoSelect["resultset"][0]["nombreProducto"], "imagen" => base64_encode($imagen_string), "prospecto" => $resultadoSelect["resultset"][0]["prospecto"], "precio" => $resultadoSelect["resultset"][0]["precio"], "fabricante" => $resultadoSelect["resultset"][0]["fabricante"], "CN" => $resultadoSelect["resultset"][0]["CN"], "resultadoOperacion" => $respError->sinErrores())); }
Belum ada data wilayah </div> </li>'; } ?> </ul> </div> </div> <div class="isiTab box span-9-5"> <?php if (!empty($wilayah)) { $i = 0; foreach ($wilayah as $w) { echo '<div class="slider-right box span-12 data-display ' . ($i == 0 ? 'active' : '') . '" id="' . strtolower(str_replace(' ', '', $w['nama_wilayah'])) . '">' . '<div class="box span-12" style="text-align:center; font-size:18px;">Wilayah ' . $w['nama_wilayah'] . '</div>'; $masjid = querySelect('*', 'masjid', "id_wilayah='{$w['id_wilayah']}' and validasi=1 order by nama_masjid asc", NULL); if (!empty($masjid)) { foreach ($masjid as $m) { echo '<div class="kotak-kanan box span-12"> <div class="radius box span-12"> <div class="gambar box span-2"> <img src="' . $m['foto'] . '"> </div> <div class="box span-10"> <div class="keterangan box span-5"> <div class="box span-12"> <table> <tr> <td>Nama masjid</td> <td> : </td> <td>' . $m['nama_masjid'] . '</td>
echo $wilayah . '<br>'; echo $nama_masjid . '<br>'; echo $alamat . '<br>'; echo $email . '<br>'; echo $rt . '<br>'; echo $rw . '<br>'; echo $kecamatan . '<br>'; echo $no_tp . '<br>'; $insert_user = queryInsert('user (username, password, privilege)', '"' . $username . '","' . md5($password) . '",1'); $query = 'SELECT * FROM user WHERE username="******" AND password="******"'; $sql = mysql_query($query); var_dump($sql); if ($sql) { $result = mysql_fetch_assoc($sql); $insert_masjid = queryInsert('masjid (id_user, id_wilayah, validasi, nama_masjid, alamat, rt, rw, kecamatan, no_telepon,email)', $result['id_user'] . ',' . $wilayah . ',' . $validasi . ',"' . $nama_masjid . '","' . $alamat . '","' . $rt . '","' . $rw . '","' . $kecamatan . '","' . $no_tp . '","' . $email . '"'); $selectMasjid = querySelect('*', 'masjid', 'id_user='******'id_user'], null); $id_masjid = $selectMasjid[0]['id_masjid']; var_dump($selectMasjid); $targetfile = "../../../View/img/Upload/fotoProfil/"; $allowedExts = array("gif", "jpeg", "jpg", "png", "JPG"); $temp = explode(".", $_FILES["uploadfoto"]["name"]); $extension = end($temp); if (($_FILES["uploadfoto"]["type"] == "image/gif" || $_FILES["uploadfoto"]["type"] == "image/jpeg" || $_FILES["uploadfoto"]["type"] == "image/jpg" || $_FILES["uploadfoto"]["type"] == "image/JPG" || $_FILES["uploadfoto"]["type"] == "image/pjpeg" || $_FILES["uploadfoto"]["type"] == "image/x-png" || $_FILES["uploadfoto"]["type"] == "image/png") && $_FILES["uploadfoto"]["size"] < 8000000 && in_array($extension, $allowedExts)) { if ($_FILES["uploadfoto"]["error"] > 0) { echo "Return Code: " . $_FILES["uploadfoto"]["error"] . "<br>"; } else { $mime = explode("/", $_FILES["uploadfoto"]["type"]); $mime = $mime[1]; $imageName = $nama_masjid . $id_masjid . "." . $mime; move_uploaded_file($_FILES["uploadfoto"]["tmp_name"], $targetfile . $imageName); }
<link rel="stylesheet" href="../css/reset.css"> <link rel="stylesheet" href="../css/style.css"> <link rel="stylesheet" href="../css/PenggunaUmum/beritaUmum.css"> </head> <body> <div class="wrapper"> <div class="col-full"> <div class="header row"> </div> <div class="content row"> <div class="sizeBoxBerita box"> <div class="col"> <div class="slideBerita box span-12"> <?php $dataBeritaUmum = querySelect('*', 'berita_umum ORDER BY tanggal_upload DESC', null, null); if (isset($_GET['offset'])) { $offset = (int) $_GET['offset']; } else { $offset = 0; } $pagination = 0; for ($i = 0; $i < count($dataBeritaUmum); $i++) { $date = $dataBeritaUmum[$i]['tanggal_upload']; $dateArray = explode(" ", $date); $tanggal = $dateArray[0]; $jam = $dateArray[1]; if ($i >= $offset) { if ($pagination < 4) { ?> <div class="berita box span-12 ">
<link rel="stylesheet" href="../css/style.css"> <link rel="stylesheet" href="../css/PenggunaUmum/musik.css"> </head> <body> <div class="wrapper"> <div class="col-full"> <div class="header row"> </div> <div class="content row"> <div class="slideVideo box"> <div class="col"> <div class="video box span-12"> <?php $offset = 0; $dataVideo = querySelect('*', 'video_musik ORDER BY tanggal_upload DESC', null, null); if (isset($_GET['offset'])) { $offset = (int) $_GET['offset']; } else { $offset = 0; } $pagination = 0; $c = 0; for ($i = 0; $i < count($dataVideo); $i++) { if ($i >= $offset) { if ($pagination < 8) { ?> <div class="kotakVideo box span-3"> <a href="musik.php?offset=<?php echo $offset; ?>
$user = $_SESSION['user'][3]; $judulBerita = str_replace('"', "''", $_POST['judulBerita']); $editor = $_POST['editor']; $sumber = $_POST['sumber']; $link = $_POST['link']; $isiBerita = str_replace('"', "''", nl2br($_POST['isiBerita'])); $date = date("Y-m-d H:i:s"); echo $user . '<br>'; echo $judulBerita . '<br>'; echo $editor . '<br>'; echo $sumber . '<br>'; echo $link . '<br>'; echo $isiBerita . '<br>'; echo $date . '<br>'; $insert_berita = queryInsert('berita_umum (id_user, judul, isi_berita, editor, sumber, link, tanggal_upload)', $user . ',"' . $judulBerita . '","' . $isiBerita . '","' . $editor . '","' . $sumber . '","' . $link . '","' . $date . '"'); $dataBerita = querySelect('*', 'berita_umum ORDER BY id_berita_umum DESC', null, null); $idberita = $dataBerita[0]['id_berita_umum']; $targetfile = "../../../View/img/Upload/beritaUmum/"; $allowedExts = array("gif", "jpeg", "jpg", "png", "JPG"); $temp = explode(".", $_FILES["uploadgambarberita"]["name"]); $extension = end($temp); if (($_FILES["uploadgambarberita"]["type"] == "image/gif" || $_FILES["uploadgambarberita"]["type"] == "image/jpeg" || $_FILES["uploadgambarberita"]["type"] == "image/jpg" || $_FILES["uploadgambarberita"]["type"] == "image/JPG" || $_FILES["uploadgambarberita"]["type"] == "image/pjpeg" || $_FILES["uploadgambarberita"]["type"] == "image/x-png" || $_FILES["uploadgambarberita"]["type"] == "image/png") && $_FILES["uploadgambarberita"]["size"] < 8000000 && in_array($extension, $allowedExts)) { if ($_FILES["uploadgambarberita"]["error"] > 0) { echo "Return Code: " . $_FILES["uploadgambarberita"]["error"] . "<br>"; } else { $mime = explode("/", $_FILES["uploadgambarberita"]["type"]); $mime = $mime[1]; $imageName = "BeritaUmum_" . $idberita . "." . $mime; move_uploaded_file($_FILES["uploadgambarberita"]["tmp_name"], $targetfile . $imageName); } try {
<title>Ubah Video Musik</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <meta name="description" content=""> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="shortcut icon" href="../img/SIM/ico.png"> <link rel="stylesheet" href="../css/reset.css"> <link rel="stylesheet" href="../css/AdminUtama/style.css"> <link rel="stylesheet" href="../css/AdminUtama/sidebar.css"> <link rel="stylesheet" href="../css/AdminUtama/tambahVideo.css"> </head> <body> <?php $isi_video_musik = querySelect('*', 'video_musik', 'id_video_musik=' . $_GET['musik_id'], null); ?> <div class="wrapper"> <div class="col-full"> <div class="header row"> </div> <div class="content row"> <div class="side box span-1-8"> </div> <form method='GET' action='../../function/script/edit/editVideoMusik.php'> <div class="box span-10-3"> <div class="kotak-tengah box span-12"> <div class="kotak-judul box span-12"> Ubah Video Musik
$fileName = $temp2[0] . "_" . $nama_masjid . $id_masjid . "_" . $i . "." . $mime; $finalFile = 'http://localhost/SIMasjid/View/img/Upload/file/' . $fileName; if (move_uploaded_file($files['tmp_name'][$i], $targetDir . $fileName)) { $insertFile = queryInsert('file (id_masjid, nama_file, lokasi_file)', $id_masjid . ',"' . $fileNameOri . '","' . $finalFile . '"'); echo 'sukses upload ' . $fileName; } else { echo 'gagal upload ' . $fileName; } } } } } if (isset($_POST['idFileHapus'])) { $listHapusFile = $_POST['idFileHapus']; for ($i = 0; $i < count($listHapusFile); $i++) { $tempFile = querySelect('*', 'file', 'id_file=' . $listHapusFile[$i], null); $temp2 = $tempFile[0]['lokasi_file']; echo 'temp2 =' . $temp2 . '<br>'; $urlFile = split('http://localhost/SIMasjid/', $temp2); echo 'url =' . $urlFile[1]; unlink("../../../" . $urlFile[1]); queryDelete("file", "id_file=" . $listHapusFile[$i]); } } $deleteKegiatanRutin = queryDelete('kegiatan_rutin', 'id_masjid=' . $id_masjid); if (isset($_POST['kegiatanRutin']) && isset($_POST['hari']) && isset($_POST['jamAwal']) && isset($_POST['jamAkhir'])) { $kegiatanRutin = $_POST['kegiatanRutin']; $hari = $_POST['hari']; $jamAwal = $_POST['jamAwal']; $jamAkhir = $_POST['jamAkhir']; for ($i = 0; $i < count($kegiatanRutin); $i++) {
<!DOCTYPE html> <?php include '../../function/connectDB.php'; $id_berita = $_GET['id_berita_umum']; $dataBerita = querySelect('*', 'berita_umum', 'id_berita_umum=' . $id_berita, null); ?> <html> <head> <title>Berita - Umum</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <meta name="description" content=""> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="shortcut icon" href="../img/SIM/ico.png"> <link rel="stylesheet" href="../css/reset.css"> <link rel="stylesheet" href="../css/style.css"> <link rel="stylesheet" href="../css/PenggunaUmum/beritaUmum-1.css"> </head> <body> <div class="wrapper"> <div class="col-scrl"> <div class="header row"> </div> <div class="content row"> <div class="box"> <div class="col"> <div class="kotak-tengah box span-12"> <div class="judul box span-12">
echo $id_masjid . '<br>'; echo $judulBerita . '<br>'; echo $isiBerita . '<br>'; echo $date . '<br>'; $_SESSION['user'][1]; if ($_SESSION['user'][2] == 0) { $jenis = "Admin Utama"; } else { $idmsjd = $_SESSION['user'][3]; $nama_masjid = querySelect('*', 'masjid', 'id_user ='******'nama_masjid']; } $insert_berita = queryInsert('berita_masjid (id_masjid, jenis_admin, judul, isi_berita, tanggal_upload)', $id_masjid . ',"' . $jenis . '","' . $judulBerita . '","' . $isiBerita . '","' . $date . '"'); $selectMasjid = querySelect('*', 'masjid', 'id_masjid=' . $id_masjid, null); $nama = $selectMasjid[0]['nama_masjid']; $dataBerita = querySelect('*', 'berita_masjid ORDER BY id_berita_masjid DESC', null, null); $idberita = $dataBerita[0]['id_berita_masjid']; $targetfile = "../../../View/img/Upload/beritaMasjid/"; $allowedExts = array("gif", "jpeg", "jpg", "png", "JPG"); $temp = explode(".", $_FILES["uploadgambarberita"]["name"]); $extension = end($temp); if (($_FILES["uploadgambarberita"]["type"] == "image/gif" || $_FILES["uploadgambarberita"]["type"] == "image/jpeg" || $_FILES["uploadgambarberita"]["type"] == "image/jpg" || $_FILES["uploadgambarberita"]["type"] == "image/JPG" || $_FILES["uploadgambarberita"]["type"] == "image/pjpeg" || $_FILES["uploadgambarberita"]["type"] == "image/x-png" || $_FILES["uploadgambarberita"]["type"] == "image/png") && $_FILES["uploadgambarberita"]["size"] < 8000000 && in_array($extension, $allowedExts)) { if ($_FILES["uploadgambarberita"]["error"] > 0) { echo "Return Code: " . $_FILES["uploadgambarberita"]["error"] . "<br>"; } else { $mime = explode("/", $_FILES["uploadgambarberita"]["type"]); $mime = $mime[1]; $imageName = $nama . "_" . $id_masjid . "_" . $idberita . "." . $mime; move_uploaded_file($_FILES["uploadgambarberita"]["tmp_name"], $targetfile . $imageName); } try {
</div> <div class="jarak-bawah-tambah box span-12"> <div class="box span-2-5"> <b>Angkot yang lewat</b> </div> <div class="box span-9"> : </div> </div> <div class="box span-12"> <div class="box span-12 target"> <script> var num = 1; </script> <?php $listAngkot = querySelect('*', 'rute_angkot', 'id_masjid=' . $id_masjid, null); if (count($listAngkot) > 0) { for ($j = 0; $j < count($listAngkot); $j++) { ?> <div class="tambah jarak-normal box span-12"> <div class="box span-4"> <div class="styled-select-angkot"> <select name="angkot[]"> <option>Pilih angkot</option> <script> var idAngkot = new Array(); var jurAngkot = new Array(); </script> <?php for ($i = 0; $i < count($angkot); $i++) { if ($listAngkot[$j]['id_angkot'] - 1 == $i) {
<?php require_once '../../connectDB.php'; $video = querySelect('*', 'video_informasi_masjid inner join masjid on masjid.id_masjid = video_informasi_masjid.id_masjid', 'video_informasi_masjid.id_masjid=' . (int) $_GET['idWilayah'] . ' AND masjid.id_wilayah=' . (int) $_GET['wilMasjid'] . ' ORDER BY tanggal_upload DESC', null); $offset = (int) $_GET['offset']; $masjidByWilayah = ''; $pagination = 0; for ($i = 0; $i < count($video); $i++) { if ($i >= $offset) { if ($pagination < 5) { $masjidByWilayah .= ' <div class="baris box span-12"> <div class="nomer center box span-1-5"> ' . ($i + 1) . ' </div> <div class="inherit center box span-2-5"> <table class="tabel-keterangan middle"> <tr> <td> ' . $video[$i]['nama_masjid'] . ' </td> </tr> </table> </div> <div class="inherit center box span-6"> <table class="tabel-judul middle"> <tr> <td> ' . $video[$i]['judul'] . ' </td> </tr>
<?php require_once '../../connectDB.php'; if (isset($_GET['idWilayah'])) { $masjid = querySelect('*', 'masjid', 'id_wilayah = ' . $_GET['idWilayah'] . ' AND validasi=1 ORDER BY nama_masjid ASC', null); $masjidByWilayah = ''; for ($i = 0; $i < count($masjid); $i++) { $pilih = '<option class="option" value="">Pilih masjid</option>'; $masjidByWilayah .= ' <option class="option" value="' . $masjid[$i]['id_masjid'] . '">' . $masjid[$i]['nama_masjid'] . '</option> '; } echo $pilih; echo $masjidByWilayah; } if ($_POST['wilayah'] && $_POST['masjid']) { $masjid = querySelect('masjid.nama_masjid, masjid.alamat, masjid.rt, masjid.rw, masjid.kecamatan, masjid.foto, masjid.latitude, masjid.longitude, wilayah.nama_wilayah', 'masjid left join wilayah on masjid.id_wilayah=wilayah.id_wilayah', "masjid.id_wilayah='{$_POST['wilayah']}' and masjid.id_masjid='{$_POST['masjid']}'", null); $lokasi = array(); if (!empty($masjid)) { $alamat = $masjid[0]['alamat'] . ' RT/RW ' . $masjid[0]['rt'] . '/' . $masjid[0]['rw'] . ', Kec. ' . $masjid[0]['kecamatan']; $lokasi = array('keterangan' => 'Anda mencari Masjid <strong>' . $masjid[0]['nama_masjid'] . '</strong> di wilayah <strong>' . $masjid[0]['nama_wilayah'] . '</strong>', 'infoContent' => '<div style="overflow:hidden; overflow-y:hidden"><h4>' . $masjid[0]['nama_masjid'] . '</h4><img src="' . $masjid[0]['foto'] . '" width="300" height="300"><div style="font-style:italic">' . $alamat . '</div></div>', 'lat' => $masjid[0]['latitude'], 'lng' => $masjid[0]['longitude']); } echo json_encode($lokasi); }
<div class="kolom box span-12"> <div class="judul center box span-1-5"> Nomer </div> <div class="judul center box span-2-5"> Tanggal post </div> <div class="judul center box span-6"> Judul berita </div> <div class="judul center box span-2-5"> Aksi </div> </div> <?php $berita_masjid = querySelect('*', 'berita_masjid', 'id_masjid =' . $_SESSION['id_masjid_admin'] . ' ORDER BY tanggal_upload DESC', null); if (isset($_GET['offset'])) { $offset = (int) $_GET['offset']; } else { $offset = 0; } $pagination = 0; for ($i = 0; $i < count($berita_masjid); $i++) { if ($i >= $offset) { if ($pagination < 5) { ?> <div class="baris box span-12"> <div class="nomer center box span-1-5"> <?php echo $i + 1; ?>
<?php session_start(); require_once '../../connectDB.php'; include_once '../../ImageHandler.php'; $id_masjid = $_POST['id_masjid']; $status = false; $dataGaleri = querySelect('*', 'galeri', 'id_masjid=' . $id_masjid, null); $nDataFoto = count($dataGaleri); $uploadGaleri = $_FILES['uploadgaleri']; $nUpload = count($uploadGaleri['name']); $listGaleri = NULL; $dataMasjid = querySelect('*', 'masjid', 'id_masjid=' . $id_masjid, null); $nama_masjid = $dataMasjid[0]['nama_masjid']; for ($i = 0; $i < $nUpload; $i++) { if (!empty($uploadGaleri['name'][$i])) { $listGaleri[] = array('name' => $uploadGaleri['name'][$i], 'type' => $uploadGaleri['type'][$i], 'tmp_name' => $uploadGaleri['tmp_name'][$i], 'error' => $uploadGaleri['error'][$i], 'size' => $uploadGaleri['size'][$i]); } } $nFile = count($listGaleri); echo 'Total Foto di DB: ' . $nDataFoto . '<br>'; echo 'Upload Foto: ' . $nFile . '<br>'; echo 'Jumlah Foto: ' . ($nDataFoto + $nFile) . '<br>'; if (isset($_POST['adminmasjid_simpanFoto_submit'])) { $insertGallery = null; if ($nDataFoto + $nFile < 19) { if ($nFile > 0) { $targetfile = "../../../View/img/Upload/galeri/"; $allowedExts = array("gif", "jpeg", "jpg", "png", "JPG"); for ($i = 0; $i < $nFile; $i++) { $temp = explode(".", $listGaleri[$i]["name"]);
<?php require_once '../../function/connectDB.php'; session_start(); $id_pesan = $_REQUEST['pesan_id']; $datapesan = querySelect('*', 'pesan', 'id_pesan=' . $id_pesan, null); ?> <!DOCTYPE html> <html> <head> <title>Balas Pesan Admin Masjid</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <meta name="description" content=""> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="shortcut icon" href="../img/SIM/ico.png"> <link rel="stylesheet" href="../css/reset.css"> <link rel="stylesheet" href="../css/AdminMasjid/style.css"> <link rel="stylesheet" href="../css/AdminMasjid/sidebarMessage.css"> <link rel="stylesheet" href="../css/AdminMasjid/balasPesan.css"> </head> <body> <div class="wrapper"> <div class="col-full"> <div class="header row"> </div> <div class="content row"> <div class="side box span-1-8">
</div> <div class="welcome box span-3"> <div class="box span-12"> <img src="../img/AdminUtama/Icon-2.png"> <table class="table"> <tr> <td> <?php $_SESSION['user'][1]; if ($_SESSION['user'][2] == 0) { echo "Admin Utama"; } else { require_once '../../function/connectDB.php'; $idmsjd = $_SESSION['user'][3]; $nama_masjid = querySelect('*', 'masjid', 'id_user ='******'nama_masjid']; } ?> </td> </tr> </table> </div> </div> <div class="notif box span-1"> <div class="box span-12"> <div class="box span-6"> <a href="inbox.php"><img src="../img/Notification/email.png"></a> </div> <div class="box span-6"> <a href="setting.php"><img src="../img/Notification/setting.png"></a>
<?php session_start(); require_once '../../function/connectDB.php'; $id_user = $_SESSION['user'][3]; $iduser = querySelect('*', 'user', 'id_user=' . $id_user, null); ?> <!DOCTYPE html> <html> <head> <title>Setting</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <meta name="description" content=""> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="shortcut icon" href="../img/SIM/ico.png"> <link rel="stylesheet" href="../css/reset.css"> <link rel="stylesheet" href="../css/AdminUtama/style.css"> <link rel="stylesheet" href="../css/AdminUtama/sidebar.css"> <link rel="stylesheet" href="../css/AdminMasjid/setting.css"> </head> <body> <div class="wrapper"> <div class="col-full"> <div class="header row"> </div> <div class="content row"> <div class="side box span-1-8">
<?php require_once '../../function/connectDB.php'; session_start(); $id_masjid = $_SESSION['id_masjid_admin']; $id_video_masjid = $_GET['video_id']; $datavideo = querySelect('*', 'video_informasi_masjid', 'id_video_masjid=' . $id_video_masjid, null); ?> <!DOCTYPE html> <html> <head> <title>Ubah Video Masjid</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <meta name="description" content=""> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="shortcut icon" href="../img/SIM/ico.png"> <link rel="stylesheet" href="../css/reset.css"> <link rel="stylesheet" href="../css/AdminMasjid/style.css"> <link rel="stylesheet" href="../css/AdminMasjid/sidebar.css"> <link rel="stylesheet" href="../css/AdminMasjid/tambahVideoMasjid.css"> </head> <body> <div class="wrapper"> <div class="col-full"> <div class="header row"> </div> <div class="content row">
<link rel="stylesheet" href="../css/style.css"> <link rel="stylesheet" href="../css/PenggunaUmum/ceramah.css"> </head> <body> <div class="wrapper"> <div class="col-full"> <div class="header row"> </div> <div class="content row"> <div class="slideVideo box"> <div class="col"> <div class="video box span-12"> <?php $offset = 0; $dataVideo = querySelect('*', 'video_ceramah ORDER BY tanggal_upload DESC', null, null); if (isset($_GET['offset'])) { $offset = (int) $_GET['offset']; } else { $offset = 0; } $pagination = 0; $c = 0; for ($i = 0; $i < count($dataVideo); $i++) { if ($i >= $offset) { if ($pagination < 8) { ?> <div class="kotakVideo box span-3"> <a href="ceramah.php?offset=<?php echo $offset;
<?php require_once '../../connectDB.php'; $masjid = querySelect('*', 'masjid INNER JOIN `user` ON masjid.id_user = `user`.id_user', 'id_wilayah = ' . $_GET['idWilayah'], null); $masjidByWilayah = ''; for ($i = 0; $i < count($masjid); $i++) { $masjidByWilayah .= ' <div class="baris box span-12"> <div class="nomer center box span-2"> ' . ($i + 1) . ' </div> <div class="isi center box span-2"> ' . $masjid[$i]['username'] . ' </div> <div class="masjid inherit center box span-6"> ' . $masjid[$i]['nama_masjid'] . ' </div> <div class="aksi box span-2"> <div class="ubah box span-12"> <a class="btn btn-block btn-lg btn-ubah-inverse" href="../AdminUtama/isiUbahAdminMasjid.php?id_masjid=' . $masjid[$i]["id_masjid"] . '"> <img src="../img/Notification/edit.png"> </a> </div> </div> </div> '; } echo $masjidByWilayah;
<?php require_once '../../function/connectDB.php'; $adminMasjid = querySelect('*', 'user', null, '0,10 JOIN LEFT masjid'); $adminMasjidByWilayah = ''; for ($i = 0; $i < count($masjid); $i++) { $adminMasjidByWilayah .= ' <div class="baris box span-12"> <div class="nomer center box span-2"> ' . ($i + 1) . ' </div> <div class="isi center box span-2"> ' . $adminMasjid[$i]['username'] . ' </div> <div class="masjid inherit center box span-6"> AL Ukhuwwah </div> <div class="aksi box span-2"> <div class="ubah box span-12"> <a class="btn btn-block btn-lg btn-ubah-inverse" href=""> <img src="../img/Notification/edit.png"> </a> </div> </div> </div> '; } echo $adminMasjidByWilayah;
</div> </div> <div class="lengkung box"> <div class="bentuk-atas-kiri box span-1"></div> <div class="bentuk-tengah box span-10"></div> <div class="bentuk-atas-kanan box span-1"></div> </div> <div class="lengkung-tengah box"> <div class="col"> <div class="video-text box span-12"> <img src="../img/Video/Video.png"> </div> <div class="video box span-12"> <?php $offset = 0; $dataVideo = querySelect('*', 'video_informasi_masjid INNER JOIN `masjid` ON video_informasi_masjid.id_masjid = `masjid`.id_masjid', 'validasi=1 ORDER BY tanggal_upload DESC', null); if (isset($_GET['offset'])) { $offset = (int) $_GET['offset']; } else { $offset = 0; } $pagination = 0; $c = 0; for ($i = 0; $i < count($dataVideo); $i++) { if ($i >= $offset) { if ($pagination < 4) { ?> <div class="box span-3"> <a href="index.php?vid<?php echo $i; ?>
<div class="check center box span-12"> <input type="checkbox" class="clickAll" id="clickAll"> </div> </div> <div class="hapus box span-11"> <div class="gambar box span-0-5"> <img class="trash" src="../img/Icon/Trash.png"> </div> <div class="hapus-text box span-8"> <input id="submit-button" type='submit' class="btn btn-block btn-lg btn-inverse" value='Hapus' name="adminmasjid_hapusinbox_submit"> </div> </div> </div> <div class="slider box span-12"> <?php $_SESSION['pesanAU'] = querySelect('*', 'pesan', 'ke=' . $id_user . ' AND status=0 ORDER BY tanggal_upload DESC', null); if (isset($_GET['offset'])) { $offset = (int) $_GET['offset']; } else { $offset = 0; } $pagination = 0; for ($i = 0; $i < count($_SESSION['pesanAU']); $i++) { if ($i >= $offset) { if ($pagination < 10) { ?> <div class="message box span-12"> <div class="inherit box span-0-5"> <div class="checkbox center box span-12"> <input type="checkbox" name="msg[]" class="msg" value="<?php echo $_SESSION['pesanAU'][$i]['id_pesan'];
<!DOCTYPE html> <?php session_start(); include '../../function/connectDB.php'; $id_berita = $_GET['id_berita']; $id_masjid = $_GET['id_masjid']; $dataMasjid = querySelect('*', 'masjid', 'id_masjid=' . $id_masjid, null); $dataBerita = querySelect('*', 'berita_masjid', 'id_berita_masjid=' . $id_berita, null); ?> <html> <head> <title>Masjid - Berita</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <meta name="description" content=""> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="shortcut icon" href="../img/SIM/ico.png"> <link rel="stylesheet" href="../css/reset.css"> <link rel="stylesheet" href="../css/style.css"> <link rel="stylesheet" href="../css/PenggunaUmum/masjidBerita.css"> </head> <body> <div class="wrapper"> <div class="col-scrl"> <div class="header row"> </div> <div class="content row"> <div class="kotak-kiri box span-3">
<!DOCTYPE html> <?php session_start(); include '../../function/connectDB.php'; $id_masjid = $_GET['id_masjid']; $dataMasjid = querySelect('*', 'masjid', 'id_masjid=' . $id_masjid, null); $joinFasilitas = querySelect('*', 'fasilitas_masjid LEFT JOIN fasilitas ON fasilitas_masjid.id_fasilitas = fasilitas.id_fasilitas', 'id_masjid=' . $id_masjid, null); $joinKegiatan = querySelect('*', 'kegiatan_masjid LEFT JOIN kegiatan ON kegiatan_masjid.id_kegiatan = kegiatan.id_kegiatan', 'id_masjid=' . $id_masjid, null); $kegiatanRutin = querySelect('*', 'kegiatan_rutin', 'id_masjid=' . $id_masjid, null); ?> <html> <head> <title>Masjid - <?php echo $dataMasjid[0]['nama_masjid']; ?> </title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <meta name="description" content=""> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="shortcut icon" href="../img/SIM/ico.png"> <link rel="stylesheet" href="../css/reset.css"> <link rel="stylesheet" href="../css/style.css"> <link rel="stylesheet" href="../css/PenggunaUmum/jquery-ui-1.10.3.css"> <link rel="stylesheet" href="../js/fancybox/jquery.fancybox.css"> <link rel="stylesheet" href="../js/fancybox/helpers/jquery.fancybox-thumbs.css"> <link rel="stylesheet" href="../css/PenggunaUmum/masjid.css"> </head> <body>