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()));
}
Beispiel #2
0
/**
 *
 * @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>&nbsp;:&nbsp;</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">
                    &nbsp;
                </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>