master/apps/php/tab/user_fraksi.php

<?php

/*******************************************************************

    Module        : /apps/php/sys/operator.php
    Desc.         : PHP - Manajemen Data Pengguna
    Created By    : Siau Pheng ([email protected]).
    Created Date  : August 1st, 2008.
    Last Modified : July 14th, 2020.

    (c) 2008 - 2020, 3FONIA Software; WWW.3FONIA.COM.

*******************************************************************/

require_once(__DIR__."/../../../../../vendor/autoload.php");
//require_once(__DIR__."/../func.sippd.php");

use siaupheng\fonia3\DB\MySQL;
use siaupheng\fonia3\DB\SQL;
use siaupheng\fonia3\Web\Param;
use siaupheng\fonia3\Web\Table;
use siaupheng\fonia3\Web\Form;

$db = $db ?? new MySQL();
$ajson = [];
$data = Param::Get("data");
$mode = Param::Get("mode");
$id_user = Param::Get("UserID", 0);

if ( $data == "user-detail" ) {
    $auser = array('Level'=>6, 'Aktif'=>1);
    if ($mode == "edit") {
	    $db->Query("SELECT * FROM app_operator WHERE Level=6 AND UserID='".$id_user."'");
	    if ($db->Next()) $auser = $db->AllRow();
    }
    $form = new Form($db);
    $form->textbox("ID Pengguna", "Username", $auser['Username'], true, true, "text", "masukan id pengguna");
    $form->textbox("Nama Pengguna", "Nama", $auser['Nama'], true, true, "text", "masukan nama pengguna");
    $form->textbox("Posisi Pengguna", "Posisi", $auser['Posisi'], true, true, "text", "masukkan posisi pengguna");
    $form->password("Password", "Password", "", true, false, "", 50, "biarkan kosong jika tidak ingin mengubah password.");
    $form->switch_sq("Status Aktif ?", "Aktif", $auser['Aktif'], true, true, array('1'=>"Ya",'0'=>"Tdk"));
    $form->hidden("UserID", $auser['UserID']);
    $form->hidden("UserLama", $auser['Username']);
    $form->hidden("mode", $mode);
    $form->show('
        _Username_
        _Nama_
        _Password_
        _Posisi_
        _Aktif_
        _mode_ _UserID_ _UserLama_ ');

} else if ( $data == "user-check") {
    $ajson['ada'] = false;
    $db->Query("SELECT COUNT(*) Jumlah FROM app_operator WHERE Username='".Param::Get("Username")."'");
    if ($db->Next()) {
        if ($db->Row("Jumlah", 0) > 0) $ajson['ada'] = true;
    }

} else if ( $data == "save" ) {
	$sql = new SQL($db);
	$sql->set_table("app_operator");
    $sql->add_param("Username");
	$sql->add_param("Nama");
	$sql->add_param("Posisi");
	$sql->add_param("Aktif");
	$sql->add_param("SuperID", user_id());
	$sql->add_where("UserID");

	if ($mode=="add") {
        $sql->add_param("Grup_MenuID", 5);
        $sql->add_param("Level", 6);
        $sql->add_param("Password", "MD5('".Param::Get("Password")."')", true);
		$sql->InsertDB();
	} else if ($mode=="edit") {
		$sql->UpdateDB();
	} else if ($mode=="del") {
		$sql->DeleteDB();
	}
    // SIMPAN PASSWORD
	$pass = Param::Get("Password");
	if (($mode == "edit") and ($pass <> "")) {
		$db->Query("UPDATE app_operator SET Password=MD5('".$pass."') WHERE UserID='".Param::Get("UserID")."'");
	}
    $ajson['status'] = true;

} else if ( $data == "dewan" ) {
    $auser = array('UserID'=>0,'AK_DPRD'=>"");
    $db->Query("SELECT UserID,AK_DPRD FROM app_operator WHERE UserID='".$id_user."' LIMIT 1");
    if ($db->Next()) $auser = $db->AllRow();
    $adprd = explode(",", $auser['AK_DPRD']);

    $hasil  = '<div id="tabDPRDList"><table class="table table-striped table-bordered table-hover">';
    $hasil .= '<thead><tr role="row"><th>Kode</th><th>Nama Anggota Dewan</th><th width="30">C</th></tr></thead><tbody>';
    $db->Query("SELECT * FROM para_dprd WHERE Aktif=1 ORDER BY K_DPRD");
    while ($db->Next()) {
        $kode = "xDPRD_".$db->Row("DPRDID");
        $checked = (in_array($db->Row("DPRDID"), $adprd)) ? "checked" : "";
        $hasil .= sprintf('<tr role="row"><td class="center">%s</td><td class="left">%s</td><td class="center" width="30"><input id="%s" type="checkbox" class="text" value="%s" %s/></td></tr>', $db->Row("K_DPRD"), $db->Row("N_DPRD"), $kode, $db->Row("DPRDID"), $checked);
    }
    $hasil .= '</tbody></table></div>';
    $hasil .= '<input type="hidden" id="UserID" value="'. $auser['UserID'] .'" />';
    echo $hasil;

} else if ( $data == "save-dewan" ) {
    $adprd = array_filter(explode(",", Param::Get("AK_DPRD"))); $ahasil = array(0);
    if (count($adprd) > 0) {
        $ahasil = implode(",", $adprd);
    }
    $db->Query("UPDATE app_operator SET AK_DPRD='".$ahasil."',SuperID='".user_id()."' WHERE UserID='".$id_user."'");
    $ajson['status'] = true;

} else if ( $data == "detail" ) {
    $tcari = trim(Param::Get("Cari_User"));
    $tsql = ($tcari=="") ? "" : " AND CONCAT(Username,Nama) LIKE '%".$tcari."%'";

    $obj = new Table($db);
    $obj->set_query("SELECT * FROM app_operator WHERE Level=6".$tsql);
	$obj->add_field("UserID", "ID", "hidden");
	$obj->add_field("Username", "ID Pengguna");
	$obj->add_field("Nama", "Nama Pengguna", "left autowrap");
	$obj->add_field("Posisi", "Posisi");
	$obj->add_field("Aktif", "Aktif", "center", "checkbox");
    $obj->set_field_order("Username", "A");
    $obj->add_row_btn("shield-check", "Dewan", "TFraksiJS.dewan_show", "Level", 6);
    $obj->add_row_btn("description", "Ubah", "TFraksiJS.detail_ubah");
    $obj->add_row_btn("trash", "Hapus", "TFraksiJS.detail_hapus");
	$obj->set_func_navi("TFraksiJS.data_query('detail')");
    $obj->set_func_btn("TFraksiJS.detail_tambah", "+ Pengguna");
	$ajson[] = $obj->json_table("divDetail");

} else if ( $data == "default") {
    echo '
    <div class="fade-in">
    <div class="card"><div class="card-header custom-style">Daftar Pengguna Fraksi</div><div class="card-body"><div class="row mb-1"><div class="col"><div class="input-group"><input class="form-control" id="Cari_Fraksi" name="Cari_Fraksi" placeholder="Kunci Pencarian" type="text"><span class="input-group-append"><button class="btn btn-info shadow-none" type="button" id="butSearch">Cari</button></span><span class="input-group-append"><button class="btn btn-secondary shadow-none" type="button" id="butAll">Semua</button></span></div></div></div><div id="divDetail">&nbsp;</div></div></div>
    </div>';
}

send_json($ajson);
?>