Penggunaan Komponan Item Type BizFrame
Penggunaan Item Type "text"
Digunakan untuk input tipe data String/Character
Array Code :
$frmitem_col_1="col-xl-6 col-lg-6 col-md-12 col-sm-12 col-xs-12";
$frmitem_title_1="ITEMTIPE TEXT";
$frmitem_title_color_1="text-bg-primary";
$frmitem_min_1="Y";
$frmitem_row_1=5;
$frmitem_data_1 = array
(
array("prm_title"=>"Normal Input",
"prm_itemfield"=>"fld_table_1",
"prm_itemtype"=>"text",
"prm_itemreq"=>"",
"prm_itemlength"=>"100",
"prm_itemdb"=>"Y",
"prm_itemid"=>"fld_table_1",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"Input (Required)",
"prm_itemfield"=>"fld_table_2",
"prm_itemtype"=>"text",
"prm_itemreq"=>"required",
"prm_itemlength"=>"100",
"prm_itemdb"=>"Y",
"prm_itemid"=>"fld_table_2",
"prm_col"=>"col-xl-6 col-lg-6 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"(Disabled)",
"prm_itemfield"=>"fld_table_3",
"prm_itemtype"=>"text",
"prm_itemreq"=>"disabled",
"prm_itemlength"=>"100",
"prm_itemdb"=>"Y",
"prm_itemid"=>"fld_table_3",
"prm_col"=>"col-xl-6 col-lg-6 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"(Readonly)",
"prm_itemfield"=>"fld_table_4",
"prm_itemtype"=>"text",
"prm_itemreq"=>"readonly",
"prm_itemlength"=>"100",
"prm_itemdb"=>"Y",
"prm_itemid"=>"fld_table_4",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"Input DataMask",
"prm_itemfield"=>"fld_table_5",
"prm_itemtype"=>"text",
"prm_placeholder"=>"+62 (___) ___-____",
"prm_maskdataslot"=>"_",
"prm_maskdataaccept"=>"\w",
"prm_itemlength"=>"100",
"prm_itemdb"=>"Y",
"prm_itemid"=>"fld_table_5",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12")
);
Output :
Penggunaan Item Type "number,intl,intr"
Digunakan untuk input tipe data Number/Integer/Double/Decimal
Array Code :
$frmitem_col_1="col-xl-6 col-lg-6 col-md-12 col-sm-12 col-xs-12";
$frmitem_title_1="ITEMTIPE NUMBER/INTL/INTR";
$frmitem_title_color_1="text-bg-primary";
$frmitem_min_1="Y";
$frmitem_row_1=4;
$frmitem_data_1 = array
(
array("prm_title"=>"Item Tipe (Number)",
"prm_itemfield"=>"fld_table_1",
"prm_itemtype"=>"number",
"prm_defaval"=>"1500000",
"prm_itemlength"=>"100",
"prm_itemdb"=>"Y",
"prm_itemid"=>"fld_table_1",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"Input Integer-Left (intl)",
"prm_itemfield"=>"fld_table_2",
"prm_itemtype"=>"intl",
"prm_itemlength"=>"100",
"prm_defaval"=>"360",
"prm_itemdb"=>"Y",
"prm_itemid"=>"fld_table_2",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"Input Integer-Right (intr)",
"prm_itemfield"=>"fld_table_2",
"prm_itemtype"=>"intr",
"prm_defaval"=>"360",
"prm_itemlength"=>"100",
"prm_itemdb"=>"Y",
"prm_itemid"=>"fld_table_2",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"Input DataMask",
"prm_itemfield"=>"fld_table_2",
"prm_itemtype"=>"text",
"prm_placeholder"=>"_,___,___.00",
"prm_defaval"=>"1500000.00",
"prm_maskdataslot"=>"_",
"prm_maskdataaccept"=>"\w",
"prm_itemlength"=>"100",
"prm_itemdb"=>"Y",
"prm_itemid"=>"fld_table_2",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"),
);
Output :
Penggunaan Item Type "email,password"
Digunakan untuk input tipe data text
Array Code :
$frmitem_col_1="col-xl-6 col-lg-6 col-md-12 col-sm-12 col-xs-12";
$frmitem_title_1="ITEMTIPE EMAIL/PASSWORD";
$frmitem_title_color_1="text-bg-primary";
$frmitem_min_1="Y";
$frmitem_row_1=2;
$frmitem_data_1 = array
(
array("prm_title"=>"Item Tipe (email)",
"prm_itemfield"=>"fld_table_1",
"prm_itemtype"=>"email",
"prm_defaval"=>"info@bezsoft.my.id",
"prm_itemlength"=>"100",
"prm_itemdb"=>"Y",
"prm_itemid"=>"fld_table_1",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"Item Tipe (pasword)",
"prm_itemfield"=>"fld_table_2",
"prm_itemtype"=>"password",
"prm_itemlength"=>"100",
"prm_defaval"=>"pastibisa",
"prm_itemdb"=>"Y",
"prm_itemid"=>"fld_table_2",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12")
);
Output :
Note : Item Tipe "Email" akan tervalidasi setelah data akan disimpan
Penggunaan Item Type "date"
Digunakan untuk input tipe date. Format Standard yyyy-mm-dd
Array Code :
$defa_currn_date =date('Y-m-d');
$frmitem_col_1="col-xl-6 col-lg-6 col-md-12 col-sm-12 col-xs-12";
$frmitem_title_1="ITEMTIPE DATE";
$frmitem_title_color_1="text-bg-primary";
$frmitem_min_1="Y";
$frmitem_row_1=1;
$frmitem_data_1 = array
(
array("prm_title"=>"Item Tipe (email)",
"prm_itemfield"=>"fld_table_1",
"prm_itemtype"=>"date",
"prm_defaval"=>"$defa_currn_date",
"prm_itemlength"=>"10",
"prm_itemdb"=>"Y",
"prm_itemid"=>"fld_table_1",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12")
);
Output :
Note : Item Tipe "Email" akan tervalidasi setelah data akan disimpan
Penggunaan Item Type "select,select2"
Array Code :
$lov_jobs="SELECT a.lovcode,a.lovname
FROM
(
SELECT a.id as lovcode,a.job_name as lovname
FROM $dbname2.mst_jobs a
) a ORDER BY a.lovcode";
$lov_dept="SELECT a.lovcode,a.lovname
FROM
(
SELECT a.id as lovcode,a.dept_name as lovname
FROM $dbname2.mst_dept a
) a ORDER BY a.lovcode";
$lov_jobs_datalist="SELECT a.lovcode
FROM
(
SELECT a.job_name as lovcode
FROM $dbname2.mst_jobs a
) a ORDER BY a.lovcode";
$frmitem_col_1="col-xl-6 col-lg-6 col-md-12 col-sm-12 col-xs-12";
$frmitem_title_1="ITEMTIPE SELECT,SELECT2,DATALIST";
$frmitem_title_color_1="text-bg-primary";
$frmitem_min_1="Y";
$frmitem_row_1=2;
$frmitem_data_1 = array
(
array("prm_title"=>"Pekerjaan (Tipe Item select)",
"prm_itemfield"=>"emp_job",
"prm_itemtype"=>"select",
"prm_itemlength"=>"100",
"prm_sqlval"=>"$lov_jobs",
"prm_itemdb"=>"Y",
"prm_itemid"=>"emp_job",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"Departemen (Tipe Item select2)",
"prm_itemfield"=>"emp_dept",
"prm_itemtype"=>"select2",
"prm_itemlength"=>"100",
"prm_sqlval"=>"$lov_dept",
"prm_itemdb"=>"Y",
"prm_itemid"=>"emp_dept",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"Departemen (Tipe Item datalist)",
"prm_itemfield"=>"emp_deptls",
"prm_itemtype"=>"datalist",
"prm_itemlength"=>"100",
"prm_sqlval"=>"$lov_jobs_datalist",
"prm_itemdb"=>"Y",
"prm_itemid"=>"emp_deptls",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12")
);
Output :
Penggunaan Item Type "lov"
Sebagai LookUp Value dari table lain. Return "lov" bisa lebih dari 1 (satu)
Array Code :
/* 1. sample Lookup Value Item "Kota" dengan menggunakan type data "lov"
yang diambil dari table "mst_city" */
$lov_kota="SELECT a.cityname as NamaKota,a.id as IdKota
FROM $dbname2.mst_city a
ORDER BY a.id";
/* 2. Mnampilkan mode LookUp untuk data Kecamatan, Kelurahan berdasarkan kota yang dipilih
perhatikan ada tanda "@" diakhir Query, digunakan untuk pengiriman parameter*/
$lov_subcity="SELECT a.kecamatan,a.kelurahan,a.postal_code as kodepos
FROM $dbname2.mst_subcity a
WHERE 1=1 @";
$frmitem_col_1="col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12";
$frmitem_title_1="GROUP 3 (Penggunaan lookUp (lov))";
$frmitem_title_color_1="text-bg-primary";
$frmitem_min_1="Y";
$frmitem_row_1=5; //Nilai tidak boleh kurang dari jumlah "Array"
$frmitem_data_1 = array
(
array("prm_title"=>"Kota (1 Return)",
"prm_itemfield"=>"dsp_emp_city",
"prm_itemtype"=>"lov",
"prm_itemreq"=>"required",
"prm_itemlength"=>"100",
"prm_sqlval"=>"$lov_kota",
"prm_itemdb"=>"N",
"prm_itemid"=>"dsp_emp_city",
"prm_lovcaption"=>"NamaKota|IdKota",
"prm_lovreturn"=>"NamaKota=dsp_emp_city|IdKota=emp_city",
"prm_lovbtn"=>"Pilih Kota",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"Kota",
"prm_itemfield"=>"emp_city",
"prm_itemtype"=>"hidden",
"prm_itemreq"=>"",
"prm_itemlength"=>"100",
"prm_sqlval"=>"",
"prm_itemdb"=>"Y",
"prm_itemid"=>"emp_city",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"Kecamatan (3 Return, related dari pemiliham kota)",
"prm_itemfield"=>"kecamatan",
"prm_itemtype"=>"lov",
"prm_itemreq"=>"",
"prm_itemlength"=>"200",
"prm_sqlval"=>"$lov_subcity",
"prm_itemdb"=>"Y",
"prm_itemid"=>"fld_kecamatan",
"prm_lovcaption"=>"kecamatan|kelurahan|kodepos",
"prm_lovbtn"=>"Pilih Kecamatan",
"prm_lovreturn"=>"kecamatan=fld_kecamatan|kelurahan=fld_kelurahan|kodepos=fld_kodepos",
"prm_lovwhere"=>"cityid=emp_city",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"Kelurahan",
"prm_itemfield"=>"kelurahan",
"prm_itemtype"=>"text",
"prm_itemreq"=>"readonly",
"prm_itemlength"=>"100",
"prm_itemdb"=>"Y",
"prm_itemid"=>"fld_kelurahan",
"prm_col"=>"col-xl-10 col-lg-10 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"Kode Pos",
"prm_itemfield"=>"kodepos",
"prm_itemtype"=>"text",
"prm_itemreq"=>"readonly",
"prm_itemlength"=>"10",
"prm_itemdb"=>"Y",
"prm_itemid"=>"fld_kodepos",
"prm_col"=>"col-xl-2 col-lg-2 col-md-12 col-sm-12 col-xs-12")
);
Output :
Penggunaan Item Type "radio, singlecheck, multicheck, multiple, switch"
Array Code :
$lov_jobs="SELECT a.lovcode,a.lovname
FROM
(
SELECT a.id as lovcode,a.job_name as lovname
FROM $dbname2.mst_jobs a
) a ";
$frmitem_col_1="col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12";
$frmitem_title_1="ITEMTIPE radio, singlecheck,
multicheck, multiple, switch";
$frmitem_title_color_1="text-bg-primary";
$frmitem_min_1="Y";
$frmitem_row_1=6;
$frmitem_data_1 = array
(
array("prm_title"=>"Jenis Kelamin (itemtype radio)",
"prm_itemfield"=>"emp_gender",
"prm_itemtype"=>"radio",
"prm_itemreq"=>"required",
"prm_itemlength"=>"20",
"prm_defaval"=>"L",
"prm_itemdb"=>"Y",
"prm_itemval"=>"LAKI-LAKI=L|PEREMPUAN=P",
"prm_itemid"=>"emp_gender",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"Check disini jika setuju (itemtype singlecheck)",
"prm_itemfield"=>"emp_ck",
"prm_itemtype"=>"singlecheck",
"prm_itemreq"=>"required",
"prm_itemlength"=>"5",
"prm_defaval"=>"L",
"prm_itemdb"=>"Y",
"prm_itemval"=>"Y|N",
"prm_itemid"=>"emp_ck",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"Pilih (itemtype multicheck)",
"prm_itemfield"=>"emp_mtlck",
"prm_itemtype"=>"multicheck",
"prm_itemreq"=>"required",
"prm_itemlength"=>"100",
"prm_defaval"=>"L",
"prm_itemdb"=>"Y",
"prm_itemval"=>"MANGGA|JAMBU|PISANG|PEPAYA|RAMBUTAN",
"prm_itemid"=>"emp_mtlck",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"Pekerjaan (itemtype multiple)",
"prm_itemfield"=>"emp_job",
"prm_itemtype"=>"multiple",
"prm_itemlength"=>"100",
"prm_sqlval"=>"$lov_jobs",
"prm_itemdb"=>"Y",
"prm_itemid"=>"emp_job",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"Karyawan Aktif (itemtype switch DEFAULT)",
"prm_itemfield"=>"emp_status",
"prm_itemtype"=>"switch",
"prm_itemreq"=>"",
"prm_itemlength"=>"50",
"prm_defaval"=>"Y",
"prm_itemdb"=>"Y",
"prm_itemval"=>"Y|N",
"prm_itemid"=>"emp_status",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"Karyawan Aktif (itemtype switch CUSTOM)",
"prm_itemfield"=>"emp_status",
"prm_itemtype"=>"switch",
"prm_itemreq"=>"",
"prm_itemlength"=>"50",
"prm_defaval"=>"Y",
"prm_itemdb"=>"Y",
"prm_itemval"=>"Y|N",
"prm_itemid"=>"emp_status",
"prm_switchoption"=>"data-off-color='danger' data-on-color='success'
data-on-text='AKTIF' data-off-text='NONAKTIF' data-size='large'",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12")
);
Output :
Penggunaan Item Type "textarea,editor"
Array Code :
$frmitem_col_1="col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12";
$frmitem_title_1="ITEMTIPE TEXTAREA,EDITOR";
$frmitem_title_color_1="text-bg-primary";
$frmitem_min_1="Y";
$frmitem_row_1=2;
$frmitem_data_1 = array
(
array("prm_title"=>"Alamat (itemtype textarea)",
"prm_itemfield"=>"fld_alm",
"prm_itemtype"=>"textarea",
"prm_itemlength"=>"200",
"prm_itemdb"=>"Y",
"prm_itemid"=>"fld_alm",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"Konten (itemtype editor)",
"prm_itemfield"=>"fld_konten",
"prm_itemtype"=>"editor",
"prm_itemlength"=>"0",
"prm_itemdb"=>"Y",
"prm_itemid"=>"fld_konten",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12")
);
Output :
Penggunaan Item Type "image, imagecam, file"
Array Code :
$frmitem_col_1="col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12";
$frmitem_title_1="ITEMTIPE image, imagecam, file";
$frmitem_title_color_1="text-bg-primary";
$frmitem_min_1="Y";
$frmitem_row_1=3;
$frmitem_data_1 = array
(
array("prm_title"=>"Foto (itemtype image)",
"prm_itemfield"=>"fld_img1",
"prm_itemtype"=>"image",
"prm_itemlength"=>"100",
"prm_itemdb"=>"Y",
"prm_itemid"=>"fld_img1",
"prm_col"=>"col-xl-6 col-lg-6 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"Foto Camera (itemtype imagecam. Working only for mobile device)",
"prm_itemfield"=>"fld_img2",
"prm_itemtype"=>"imagecam",
"prm_itemlength"=>"100",
"prm_itemdb"=>"Y",
"prm_itemid"=>"fld_img2",
"prm_col"=>"col-xl-6 col-lg-6 col-md-12 col-sm-12 col-xs-12"),
array("prm_title"=>"File Attacment (itemtype file)",
"prm_itemfield"=>"fld_file1",
"prm_itemtype"=>"file",
"prm_itemlength"=>"100",
"prm_itemdb"=>"Y",
"prm_itemid"=>"fld_file1",
"prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12")
);
Output :
Penggunaan Item Type "label, header, button, taghtml"
Array Code :
$frmitem_col_1="col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"; $frmitem_title_1="ITEMTIPE label, header, button, taghtml"; $frmitem_title_color_1="text-bg-primary"; $frmitem_min_1="Y"; $frmitem_row_1=8; $frmitem_data_1 = array ( array("prm_title"=>"Saya tipe komponen label", "prm_itemtype"=>"label", "prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"), array("prm_title"=>"Saya tipe komponen header", "prm_itemtype"=>"header", "prm_col"=>"col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12"), array("prm_taghtml"=> "<div class='card'> <img src='https://placehold.co/300x300?text=No+Image' class='card-img-top'> <div class='card-body'> <p class='card-text'>Contoh penggunaan <span class='text-warning'>taghtml</span></p> </div> </div> ", "prm_itemtype"=>"taghtml", "prm_col"=>"col-xl-4 col-lg-4 col-md-4 col-sm-12 col-xs-12"), array("prm_taghtml"=> "<ul class='list-group'> <li class='list-group-item active' aria-current='true'>An active item</li> <li class='list-group-item'>A second item</li> <li class='list-group-item'>A third item</li> <li class='list-group-item'>A fourth item</li> <li class='list-group-item'>And a fifth one</li> </ul> ", "prm_itemtype"=>"taghtml", "prm_col"=>"col-xl-4 col-lg-4 col-md-4 col-sm-12 col-xs-12"), array("prm_taghtml"=> "<nav aria-label='breadcrumb'> <ol class='breadcrumb'> <li class='breadcrumb-item'><a href='#'>Home</a></li> <li class='breadcrumb-item'><a href='#'>Library</a></li> <li class='breadcrumb-item active' aria-current='page'>Data</li> </ol> </nav> ", "prm_itemtype"=>"taghtml", "prm_col"=>"col-xl-4 col-lg-4 col-md-4 col-sm-12 col-xs-12"), array("prm_title"=>"Sample Custom Button non javascrirpt", "prm_itemtype"=>"button", "prm_itemclass"=>"btn-primary", "prm_itemid"=>"fld_btn1", "prm_col"=>"col-xl-4 col-lg-4 col-md-12 col-sm-12 col-xs-12"), array("prm_title"=>"Sample Custom Button dengan javascrirpt", "prm_itemtype"=>"button", "prm_itemclass"=>"btn-secondary", "prm_itemjs"=>"onclick=clickbutonsaya();", "prm_itemid"=>"fld_btn2", "prm_col"=>"col-xl-4 col-lg-4 col-md-12 col-sm-12 col-xs-12"), array("prm_title"=>"Sample Custom Button dengan custom tooltip", "prm_itemtype"=>"button", "prm_itemclass"=>"btn-secondary", "prm_itemstyle"=>" data-bs-toggle='tooltip' data-bs-placement='top' data-bs-custom-class='custom-tooltip' data-bs-title='This top tooltip is themed via CSS variables.'", "prm_itemid"=>"fld_btn2", "prm_col"=>"col-xl-4 col-lg-4 col-md-12 col-sm-12 col-xs-12") );
Output :
Saya tipe komponen header
Contoh penggunaan taghtml
- An active item
- A second item
- A third item
- A fourth item
- And a fifth one