function getNetworkSettingsMask()
{
$tbl = new Table(array("", ""));
$rIp = $tbl->createRow();
$rIp->setAttribute(0, new Text("IP:"));
$rIp->setAttribute(1, new Textfield("ip", $this->getLocalIp()));
$tbl->addRow($rIp);
$rMask = $tbl->createRow();
$rMask->setAttribute(0, new Text("Subnet-Mask:"));
$rMask->setAttribute(1, new Textfield("mask", $this->getLocalMask()));
$tbl->addRow($rMask);
$rGate = $tbl->createRow();
$rGate->setAttribute(0, new Text("Gateway:"));
$rGate->setAttribute(1, new Textfield("gate", $this->getLocalGate()));
$tbl->addRow($rGate);
$rDns = $tbl->createRow();
$rDns->setAttribute(0, new Text("DNS-Server:"));
$rDns->setAttribute(1, new Textfield("dns", $this->getLocalDns()));
$tbl->addRow($rDns);
$rOk = $tbl->createRow();
$rOk->setSpawnAll(true);
$rOk->setAttribute(0, new Button("saveNetworkSettingsMask", $this->SAVE_BTN_LABEL));
$tbl->addRow($rOk);
$f = new Form();
$f->add($tbl);
return $f;
}
/**
* Zeigt das gesamte Panel an
*/
function show()
{
$this->CONTENT->setWidth($this->WIDTH - 8 * $this->PANELTITELRIGHTWIDTH);
//---------------------------------------------------
// Inhalt
//---------------------------------------------------
$cont = new Div();
$cont->setBorder(1);
$cont->setWidth($this->WIDTH - 2 * $this->PANELTITELRIGHTWIDTH);
if ($this->HEIGHT > 0) {
$cont->setHeight($this->HEIGHT - $this->PANELTITELHEIGHT);
}
$cont->setOverflow("auto");
$cont->setStyle("background-color", $this->BGCOLOR);
$cont->setStyle("border-style", "solid");
$cont->setStyle("border-top", "1px");
$cont->setStyle("border-left", "1px");
$cont->setStyle("border-right", "2px");
$cont->setStyle("border-bottom", "2px");
$cont->setStyle("border-color", $_SESSION['config']->COLORS['text']);
$cont->add($this->CONTENT);
//---------------------------------------------------
$tb = new Table(array(""));
$rH = $tb->createRow();
$rH->setAlign("center");
$rH->setBackgroundColor($_SESSION['config']->COLORS['text']);
$rH->setFontType($_SESSION['config']->COLORS['text']);
$rH->setAttribute(0, $this->NAME);
$tb->addRow($rH);
$rC = $tb->createRow();
$rC->setAlign("center");
$rC->setAttribute(0, $cont);
$tb->addRow($rC);
return $tb;
}
function createTableFirstPagePic64($array_link)
{
$ind = 0;
$row_table = null;
$table = new Table(10, 10);
for ($i = 0; $i < sizeof($array_link); $i++) {
if ($array_link[$i]->getUserHaveRights()) {
if ($ind % 5 == 0) {
if ($row_table != null) {
$table->addRow($row_table);
}
$row_width = 20;
if (sizeof($array_link) < 5) {
$row_width = 100 / sizeof($array_link);
}
$row_table = new RowTable(RowTable::ALIGN_CENTER, $row_width . "%");
}
$row_table->add($array_link[$i]);
$ind++;
}
}
if ($row_table != null) {
$table->addRow($row_table);
}
return $table;
}
public function Load()
{
parent::$PAGE_TITLE = __(CONFIGURE_DATABASE);
$this->includeJsAndCssFromObjectToPage("ComboBox(\$this)");
// Admin
$this->form = new Form($this);
$table_form = new Table();
$table_form->addRow();
$this->edtHost = new TextBox($this->form);
$this->edtHost->setValue(DB_HOST);
$edtHostValidation = new LiveValidation();
$table_form->addRowColumns(__(EDT_HOST) . ": ", $this->edtHost->setLiveValidation($edtHostValidation->addValidatePresence()->setFieldName(__(EDT_HOST))));
$this->edtPort = new TextBox($this->form);
$this->edtPort->setValue(DB_PORT);
$edtPortValidation = new LiveValidation();
$table_form->addRowColumns(__(EDT_PORT) . ": ", $this->edtPort->setLiveValidation($edtPortValidation->addValidateNumericality(true)->setFieldName(__(EDT_PORT))));
$this->edtRoot = new TextBox($this->form);
$this->edtRoot->setValue(DB_ROOT);
$edtRootValidation = new LiveValidation();
$table_form->addRowColumns(__(EDT_ROOT) . ": ", $this->edtRoot->setLiveValidation($edtRootValidation->addValidatePresence()->setFieldName(__(EDT_ROOT))));
$this->edtPassword = new Password($this->form);
$this->edtPassword->setValue(DB_PASSWORD);
$table_form->addRowColumns(__(EDT_PASSWORD) . ": ", $this->edtPassword);
$this->edtDatabase = new TextBox($this->form);
$this->edtDatabase->setValue(DB_DATABASE);
$table_form->addRowColumns(__(EDT_DATABASE) . ": ", $this->edtDatabase);
$table_form->addRow();
$this->btnValidate = new Button($this->form);
$this->btnValidate->setValue(__(BTN_VALIDATE))->onClick("configureDatabase")->setAjaxEvent();
$table_form->addRowColumns($this->btnValidate)->setColumnColspan(1, 2)->setColumnAlign(1, RowTable::ALIGN_CENTER);
$table_form->addRow();
$table_form->addRow();
$this->form->setContent($table_form);
$this->render = new AdminTemplateForm($this, $this->form);
// generate database object part
$this->objCreateDbClass = new Object();
$this->objCreateDbClass->setId("idCreateDbClass");
$table_form->addRow($this->objCreateDbClass)->setColspan(2);
$table_gen = new Table();
$table_gen->addRow(__(GENERATE_DATABASE_OBJECTS))->setColspan(2);
$table_gen->addRow();
$this->cmb_databases = new ComboBox($this->form);
$this->cmb_databases->onChange("configureGenDbObject")->setAjaxEvent();
$table_gen->addRowColumns(__(DATABASES) . ": ", $this->cmb_databases);
$this->cmb_tables = new ComboBox($this->form);
$table_gen->addRowColumns(__(TABLES) . ": ", $this->cmb_tables);
$table_gen->addRow();
$btnGenObject = new Button($this->form);
$btnGenObject->setValue(__(GENERATE_OBJECTS))->onClick("generateDbObject")->setAjaxEvent();
$table_gen->addRow($btnGenObject)->setColspan(2);
$table_gen->addRow();
$this->objCreateDbClass->add($table_gen);
// database list
if ($this->testDbConnexion(null)) {
$this->loadAllDatabases();
$this->configureGenDbObject(null);
}
}
function list_data_radio($hal = 0) {
$_SESSION[setting_radiologi_spesimen][hal] = $hal;
$objResponse = new xajaxResponse();
$paging = new MyPagina;
$paging->rows_on_page = 15;
$paging->sql = "
SELECT
rp.id as id,
rp.nama as nama,
rp.biaya_bhp as biaya_bhp,
rpd.biaya_jasa as biaya_jasa,
rpd.kelas as kelas
FROM
radio_pemeriksaan rp
JOIN radio_pemeriksaan_detil rpd ON (rpd.tingkat = rp.tingkat)
ORDER BY
rp.nama
";
$paging->hal = $hal;
$paging->get_page_result();
$data = $paging->data;
$no = $paging->start_number();
$navi = $paging->navi();
$table = new Table;
$table->tbody_height = 350;
$table->addTh(
"No",
"Nama",
"Biaya BHP",
"Biaya Jasa",
"Kelas",
"Hapus"
);
//$table->addExtraTh("style=\"width:50px;\"","style=\"width:200px;\"","","","");
//$kon = new Konek;
for($i=0;$i<sizeof($data);$i++) {
$table->addRow(
($no+$i),
$data[$i][nama],
$data[$i][biaya_bhp],
$data[$i][biaya_jasa],
$data[$i][kelas],
"<a href=\"javascript:void(0)\" title=\"Hapus\" onclick=\"hapus_kamar('".$data[$i][id]."', this)\" class=\"tombol_hapus\"><img src=\"".IMAGES_URL."remove.png\" alt=\"Hapus\" border=\"0\" /></a>"
);
$table->addOnclickTd(
"xajax_get_info('".$data[$i][id]."')",
"xajax_get_info('".$data[$i][id]."')",
"xajax_get_info('".$data[$i][id]."')",
"xajax_get_info('".$data[$i][id]."')",
"xajax_get_info('".$data[$i][id]."')"
);
}
$buka = $table->build();
$objResponse->addAssign("list_data_radio", "innerHTML", $buka);
$objResponse->addAssign("navi", "innerHTML", $navi);
return $objResponse;
}
function list_data($hal = 0) {
$_SESSION[hal] = $hal;
$objResponse = new xajaxResponse();
$paging = new MyPagina;
$paging->rows_on_page = 20;
$paging->sql = "SELECT
i.id as icid,
i.kode as kode,
i.nama as nama,
id.id as idid,
id.*
FROM
icopim i
LEFT JOIN icopim_detil id ON (id.tingkat = i.tingkat)
GROUP BY i.id, id.kelas
ORDER BY i.nama, id.kelas
";
$paging->hal = $hal;
$paging->get_page_result();
$data = $paging->data;
$no = $paging->start_number();
$navi = $paging->navi();
$tabel = new Table;
$tabel->tbody_height = 400;
$tabel->addTh(
"No",
"Kode",
"Tindakan",
"Tingkat",
"Kelas",
"Biaya",
"Hapus"
);
for($i=0;$i<sizeof($data);$i++) {
$tabel->addRow(
($no+$i),
$data[$i][kode],
$data[$i][nama],
$data[$i][tingkat],
$data[$i][kelas],
$data[$i][biaya],
"<a href=\"javascript:void(0)\" title=\"Hapus\" onclick=\"hapus_tindakan('".$data[$i][icid]."', '".$data[$i][idid]."', this)\" class=\"tombol_hapus\"><img src=\"".IMAGES_URL."remove.png\" alt=\"Hapus\" border=\"0\" /></a>");
$tabel->addOnclickTd(
"xajax_get_tindakan('".$data[$i][icid]."', '".$data[$i][tingkat]."', '".$data[$i][kelas]."')",
"xajax_get_tindakan('".$data[$i][icid]."', '".$data[$i][tingkat]."', '".$data[$i][kelas]."')",
"xajax_get_tindakan('".$data[$i][icid]."', '".$data[$i][tingkat]."', '".$data[$i][kelas]."')",
"xajax_get_tindakan('".$data[$i][icid]."', '".$data[$i][tingkat]."', '".$data[$i][kelas]."')",
"xajax_get_tindakan('".$data[$i][icid]."', '".$data[$i][tingkat]."', '".$data[$i][kelas]."')",
"xajax_get_tindakan('".$data[$i][icid]."', '".$data[$i][tingkat]."', '".$data[$i][kelas]."')"
);
}
$buka = $tabel->build();
$objResponse->addAssign("list_data", "innerHTML", $buka);
$objResponse->addAssign("navi", "innerHTML", $navi);
return $objResponse;
}
public function getHtml()
{
$predmetyZapisnehoListu = $this->skusky->getPredmetyZapisnehoListu();
$predmetyZapisnehoListuTable = new Table(TableDefinitions::predmetyZapisnehoListu());
$predmetyZapisnehoListuCollapsible = new Collapsible('Predmety zápisného listu', $predmetyZapisnehoListuTable);
$kreditovCelkomLeto = 0;
$kreditovCelkomZima = 0;
$pocetPredmetovLeto = 0;
$pocetPredmetovZima = 0;
foreach (Sorter::sort($predmetyZapisnehoListu->getData(), array("semester" => -1, "nazov" => 1)) as $row) {
if ($row['semester'] == 'L') {
$pocetPredmetovLeto += 1;
$kreditovCelkomLeto += $row['kredit'];
$class = 'leto';
} else {
$pocetPredmetovZima += 1;
$kreditovCelkomZima += $row['kredit'];
$class = 'zima';
}
$predmetyZapisnehoListuTable->addRow($row, array('class' => $class));
}
$pocetPredmetovText = 'Celkom ';
$pocetPredmetovText .= FajrUtils::formatPlural($pocetPredmetovLeto + $pocetPredmetovZima, '0 predmetov', '1 predmet', '%d predmety', '%d predmetov');
if ($pocetPredmetovLeto > 0 && $pocetPredmetovZima > 0) {
$pocetPredmetovText .= sprintf(' (%d v zime, %d v lete)', $pocetPredmetovZima, $pocetPredmetovLeto);
}
$kreditovCelkomText = '' . ($kreditovCelkomLeto + $kreditovCelkomZima);
if ($kreditovCelkomLeto > 0 && $kreditovCelkomZima > 0) {
$kreditovCelkomText .= sprintf(' (%d+%d)', $kreditovCelkomZima, $kreditovCelkomLeto);
}
$predmetyZapisnehoListuTable->addFooter(array('nazov' => $pocetPredmetovText, 'kredit' => $kreditovCelkomText), array());
$predmetyZapisnehoListuTable->setUrlParams(array('studium' => Input::get('studium'), 'list' => Input::get('list')));
return $predmetyZapisnehoListuTable->getHtml();
}
public function getHtml()
{
$trace = $this->trace->addChild("HodnoteniaCallback");
$hodnotenia = $this->app->getHodnotenia($trace);
$hodnoteniaTable = new Table(TableDefinitions::hodnotenia());
$priemeryCalculator = new PriemeryCalculator();
foreach (Sorter::sort($hodnotenia->getData(), array("semester" => -1, "nazov" => 1)) as $row) {
if ($row['semester'] == 'L') {
$class = 'leto';
$priemeryCalculator->add(PriemeryCalculator::SEMESTER_LETNY, $row['znamka'], $row['kredit']);
} else {
$class = 'zima';
$priemeryCalculator->add(PriemeryCalculator::SEMESTER_ZIMNY, $row['znamka'], $row['kredit']);
}
$hodnoteniaTable->addRow($row, array('class' => $class));
}
$hodnoteniaCollapsible = new Collapsible(new HtmlHeader('Hodnotenia'), $hodnoteniaTable);
$priemery = $this->app->getPriemery($trace);
$priemeryTable = new Table(TableDefinitions::priemery());
$priemeryTable->addRows($priemery->getData());
$priemeryContainer = new Container();
$priemeryContainer->addChild(new Label('Nasledovné priemery sú prebraté z AISu, čiže to (ne)funguje presne rovnako:'));
$priemeryContainer->addChild($priemeryTable);
if ($priemeryCalculator->hasPriemer()) {
$priemeryFajrText = '<p><br />Nasledovné vážené študijné priemery sú počítané Fajrom priebežne z tabuľky Hodnotenia, <strong>preto nemôžu byť považované ako oficiálne</strong>:<br /><br />';
$priemeryFajrText .= $priemeryCalculator->getHtml();
$priemeryFajrText .= '</p>';
$priemeryContainer->addChild(new Label($priemeryFajrText));
}
$priemeryCollapsible = new Collapsible(new HtmlHeader('Priemery'), $priemeryContainer);
return $hodnoteniaCollapsible->getHtml() . $priemeryCollapsible->getHtml();
}
function list_kamar($hal = 0) {
$paging = new MyPagina;
$paging->sql = "select p.nama as bangsal,
k.id as kamar_id,
k.nama as nama_kamar,
rk.nomor as no_kamar,
rk.status as status
from kamar k, ref_kamar rk,
pelayanan p
where k.id = rk.kamar_id and k.pelayanan_id = p.id
and p.jenis = 'RAWAT INAP'
order by p.nama, k.kelas, k.nama";
$paging->rows_on_page = 15;
$paging->hal = $hal;
$_SESSION[modul_setting][no_kamar][hal] = $hal;
$paging->get_page_result();
$data = $paging->data;
$no = $paging->start_number();
$navi = $paging->navi();
$table = new Table;
$table->tbody_height = 350;
$table->addTh(
"No",
"Nama Bangsal",
"Nama Kamar",
"No Bed",
"Status",
"Hapus"
);
$table->addExtraTh("style=\"width:50px;\"","style=\"width:200px;\"","","","","","","style=\"width:70px;\"");
$kon = new Konek;
for($i=0;$i<sizeof($data);$i++) {
$table->addRow(
($no+$i),
$data[$i][bangsal],
$data[$i][nama_kamar],
$data[$i][no_kamar],
$data[$i][status],
"<a href=\"javascript:void(0)\" title=\"Hapus\" onclick=\"hapus_kamar('".$data[$i][id]."', this)\" class=\"tombol_hapus\"><img src=\"".IMAGES_URL."remove.png\" alt=\"Hapus\" border=\"0\" /></a>"
);
$table->addOnclickTd(
"xajax_get_info('".$data[$i][id]."')",
"xajax_get_info('".$data[$i][id]."')",
"xajax_get_info('".$data[$i][id]."')",
"xajax_get_info('".$data[$i][id]."')",
"xajax_get_info('".$data[$i][id]."')"
);
}
$buka = $table->build();
$objResponse = new xajaxResponse();
$objResponse->addAssign("navi", "innerHTML", $navi);
$objResponse->addAssign("list_kamar", "innerHTML", $buka);
return $objResponse;
}
public function Load()
{
parent::$PAGE_TITLE = __(CHANGE_PASSWD);
$form = new Form($this, "Form_change_passwd");
if (extension_loaded('openssl')) {
//$form->setEncryptObject(new EncryptDataWspObject("change wsp password", 2048));
}
$table = new Table();
$table->addRow();
$this->edt_old_passwd = new Password($form, "wsp_old_password");
$this->edt_old_passwd->setFocus();
$live_validation = new LiveValidation();
$live_validation->addValidatePresence()->setFieldName(__(OLD_PASSWD));
$table->addRowColumns(__(OLD_PASSWD) . " : ", $this->edt_old_passwd->setLiveValidation($live_validation))->setStyle("color:black;");
$this->edt_new_passwd = new Password($form, "wsp_new_password");
$live_validation = new LiveValidation();
$live_validation->addValidatePresence()->setFieldName(__(NEW_PASSWD));
$table->addRowColumns(__(NEW_PASSWD) . " : ", $this->edt_new_passwd->setLiveValidation($live_validation))->setStyle("color:black;");
$this->edt_confirm_passwd = new Password($form, "wsp_confirm_password");
$live_validation = new LiveValidation();
$live_validation->addValidatePresence()->setFieldName(__(CONFIRM_PASSWD));
$live_validation->addValidateConfirmation("wsp_new_password");
$table->addRowColumns(__(CONFIRM_PASSWD) . " : ", $this->edt_confirm_passwd->setLiveValidation($live_validation))->setStyle("color:black;");
$table->addRow();
$this->validate_btn = new Button($form);
$this->validate_btn->setValue(__(CHANGE_PASSWD))->onClick("onChangePasswd")->setAjaxEvent();
$table->addRow($this->validate_btn)->setColspan(2)->setAlign(RowTable::ALIGN_CENTER);
$table->addRow();
$form->setContent($table);
$table = new Table();
$table->setWidth("100%");
$table->addRow($form, RowTable::ALIGN_CENTER);
$this->render = $table;
}
function list_data($hal = 0) {
$paging = new MyPagina;
$paging->rows_on_page = 20;
$paging->sql = "SELECT id, nama, alamat FROM ref_perujuk ORDER BY nama";
$paging->get_page_result();
$paging->hal = $hal;
$_SESSION[hal] = $hal;
$paging->get_page_result();
$data = $paging->data;
$no = $paging->start_number();
$navi = $paging->navi();
$table = new Table;
$table->tbody_height = 420;
$table->addTh("No", "Nama", "Alamat", "Hapus");
$table->addExtraTh(" style=\"width: 50px;\"", " style=\"width: 200px;\"", "", " style=\"width: 70px;\" ");
for($i=0;$i<sizeof($data);$i++) {
$table->addRow(
($no+$i),
$data[$i][nama],
$data[$i][alamat],
"<a href=\"javascript:void(0)\" title=\"Hapus\" onclick=\"hapus_perujuk('".$data[$i][id]."', this)\" class=\"tombol_hapus\"><img src=\"".IMAGES_URL."remove.png\" alt=\"Hapus\" border=\"0\" /></a>");
$table->addExtraTd(
" onclick=\"xajax_get_perujuk('".$data[$i][id]."')\" ",
" onclick=\"xajax_get_perujuk('".$data[$i][id]."')\" ",
" onclick=\"xajax_get_perujuk('".$data[$i][id]."')\" ");
}
$ret = $table->build();
$objResponse = new xajaxResponse();
$objResponse->addAssign("navi", "innerHTML", $navi);
$objResponse->addAssign("list_data", "innerHTML", $ret);
return $objResponse;
}
public function Load()
{
parent::$PAGE_TITLE = __(CONFIGURE_SMTP);
// Admin
$form = new Form($this);
$table_form = new Table();
$table_form->addRow();
$this->edtHost = new TextBox($form);
$this->edtHost->setValue(SMTP_HOST);
$edtHostValidation = new LiveValidation();
$table_form->addRowColumns(__(EDT_HOST) . ": ", $this->edtHost->setLiveValidation($edtHostValidation->addValidatePresence()->setFieldName(__(EDT_HOST))), " (ssl://smtp.gmail.com)");
$this->edtPort = new TextBox($form);
$this->edtPort->setValue(SMTP_PORT);
$edtPortValidation = new LiveValidation();
$table_form->addRowColumns(__(EDT_PORT) . ": ", $this->edtPort->setLiveValidation($edtPortValidation->addValidateNumericality(true)->setFieldName(__(EDT_PORT))), " (465)");
$this->edtName = new TextBox($form);
$this->edtName->setValue(utf8encode(SMTP_NAME));
$edtNameValidation = new LiveValidation();
$table_form->addRowColumns(__(EDT_NAME) . ": ", $this->edtName->setLiveValidation($edtNameValidation->addValidatePresence()->setFieldName(__(EDT_NAME))), " (Robert Francis)");
$this->edtMail = new TextBox($form);
$this->edtMail->setValue(SMTP_MAIL);
$edtMailValidation = new LiveValidation();
$table_form->addRowColumns(__(EDT_MAIL) . ": ", $this->edtMail->setLiveValidation($edtMailValidation->addValidatePresence()->addValidateEmail()->setFieldName(__(EDT_MAIL))), " (robert.francis@gmail.com)");
$this->cmbAuth = new ComboBox($form);
$this->cmbAuth->addItem("false", __(DESACTIVATE), SMTP_AUTH == false ? true : false)->addItem("true", __(ACTIVATE), SMTP_AUTH == true ? true : false)->setWidth(143)->onChange("changeCmbAuth")->setAjaxEvent()->disableAjaxWaitMessage();
$table_form->addRowColumns(__(CMB_AUTH) . ": ", $this->cmbAuth, " (" . __(ACTIVATE) . ")");
$this->edtUser = new TextBox($form);
$this->edtUser->setValue(SMTP_USER);
if (SMTP_AUTH == false) {
$this->edtUser->disable();
}
$table_form->addRowColumns(__(EDT_USER) . ": ", $this->edtUser, " (robert.francis@gmail.com)");
$this->edtPassword = new Password($form);
$this->edtPassword->setValue(SMTP_PASS);
if (SMTP_AUTH == false) {
$this->edtPassword->disable();
}
$table_form->addRowColumns(__(EDT_PASS) . ": ", $this->edtPassword, " (*********)");
$table_form->addRow();
$btnValidate = new Button($form);
$btnValidate->setValue(__(BTN_VALIDATE))->onClick("configureSmtp")->setAjaxEvent();
$table_form->addRowColumns($btnValidate)->setColumnColspan(1, 3)->setColumnAlign(1, RowTable::ALIGN_CENTER);
$table_form->addRow();
$form->setContent($table_form);
$this->render = new AdminTemplateForm($this, $form);
}
/**
* @param Table|null $table
*
* @return $this
*/
public function setTable(Table $table = null)
{
$this->table = $table;
if ($table && !in_array($this, $table->getRows())) {
$table->addRow($this);
}
return $this;
}
function list_data($hal = 0) {
$_SESSION[hal] = $hal;
$objResponse = new xajaxResponse();
$paging = new MyPagina;
$paging->rows_on_page = 20;
$paging->sql = "
SELECT
d.id as id,
d.nama as nama,
spc.id as spc_id,
spc.nama as spc_nama,
sub.id as sub_id,
sub.nama as sub_nama,
d.telp as telp,
d.aktif as aktif,
CASE
WHEN (d.aktif = '1') THEN 'Ya'
ELSE 'Tidak'
END AS aktif_nama
FROM
dokter d
JOIN subspesialisasi sub ON (sub.id = d.subspesialisasi_id)
JOIN spesialisasi spc ON (spc.id = sub.spesialisasi_id)
ORDER BY
spc.nama, sub.nama, d.nama
";
$paging->hal = $hal;
$paging->get_page_result();
$_SESSION[modul_setting][dokter][hal] = $hal;
$data = $paging->data;
$no = $paging->start_number();
$navi = $paging->navi();
$tabel = new Table;
$tabel->tbody_height = 380;
$tabel->addTh("No", "Nama", "Spesialisasi/<br />Sub Spesialisasi", "Telp", "Aktif", "Hapus");
$tabel->addExtraTh(" style=\"width:50px;\"", "style=\"width:200px;\"", "", "", "", " style=\"width:70px;\" ");
for($i=0;$i<sizeof($data);$i++) {
$tabel->addRow(
($no+$i),
$data[$i][nama],
$data[$i][spc_nama] . "<br />" . $data[$i][sub_nama],
$data[$i][telp], $data[$i][aktif_nama],
"<a href=\"javascript:void(0)\" title=\"Hapus\" onclick=\"hapus_dokter('".$data[$i][id]."', this)\" class=\"tombol_hapus\"><img src=\"".IMAGES_URL."remove.png\" alt=\"Hapus\" border=\"0\" /></a>");
$tabel->addOnclickTd(
"xajax_get_dokter('".$data[$i][id]."')",
"xajax_get_dokter('".$data[$i][id]."')",
"xajax_get_dokter('".$data[$i][id]."')",
"xajax_get_dokter('".$data[$i][id]."')"
);
}
$buka = $tabel->build();
$objResponse->addAssign("list_data", "innerHTML", $buka);
$objResponse->addAssign("navi", "innerHTML", $navi);
return $objResponse;
}
function list_data($hal = 0, $prop_id = "", $kab_id = "") {
$_SESSION[setting_kecamatan][hal] = $hal;
//$all_id = @explode("|", $prop_kab_id);
if($prop_id) $s .= " AND p.id = '".$prop_id."'";
if($kab_id) $s .= " AND k.id = '".$kab_id."'";
$objResponse = new xajaxResponse();
$paging = new MyPagina;
$paging->rows_on_page = 20;
$paging->setOnclickValue($prop_id, $kab_id);
//$paging->onclick2_value = "'" . $prop_kab_id . "'";
$paging->sql = "
SELECT
kec.id AS id,
p.id AS prop_id,
p.nama AS prop,
k.id AS kab_id,
k.nama AS kab,
kec.nama AS nama,
COUNT(d.id) as jml_desa
FROM
ref_kecamatan kec
JOIN ref_kabupaten k ON (k.id = kec.kabupaten_id)
JOIN ref_propinsi p ON (p.id = k.propinsi_id)
LEFT JOIN ref_desa d ON (d.kecamatan_id = kec.id)
WHERE
1=1
$s
GROUP BY kec.id
ORDER BY p.nama, k.nama, kec.nama
";
$paging->hal = $hal;
$paging->get_page_result();
$data = $paging->data;
$no = $paging->start_number();
$navi = $paging->navi();
$tabel = new Table;
$tabel->tbody_height = 370;
$tabel->addTh("No", "Propinsi", "Kabupaten", "Kecamatan", "Jml<br />Kelurahan", "Hapus");
$tabel->addExtraTh(" style=\"width: 50px;\"", " style=\"width: 200px;\"", "", "", "style=\"width: 100px;\"", " style=\"width: 70px;\" ");
for($i=0;$i<sizeof($data);$i++) {
if($data[$i][prop_id] != $data[$i-1][prop_id]) $prop = $data[$i][prop];
else $prop = "";
if($data[$i][kab_id] != $data[$i-1][kab_id]) $kab = $data[$i][kab];
else $kab = "";
$tabel->addRow(($no+$i), $prop, $kab, $data[$i][nama], $data[$i][jml_desa], "<a href=\"javascript:void(0)\" title=\"Hapus\" onclick=\"hapus_kecamatan('".$data[$i][id]."', this)\" class=\"tombol_hapus\"><img src=\"".IMAGES_URL."remove.png\" alt=\"Hapus\" border=\"0\" /></a>");
$tabel->addOnclickTd("xajax_get_kecamatan('".$data[$i][id]."')","xajax_get_kecamatan('".$data[$i][id]."')", "xajax_get_kecamatan('".$data[$i][id]."')", "xajax_get_kecamatan('".$data[$i][id]."')");
}
$buka = $tabel->build();
$objResponse->addAssign("list_data", "innerHTML", $buka);
$objResponse->addAssign("navi", "innerHTML", $navi);
return $objResponse;
}
function show()
{
$t = new Table(array());
$t->setHeight($this->getHeight());
$r = $t->createRow();
$r->setHeight($this->getHeight());
$t->addRow($r);
$t->show();
}
function PublicVarText($dbConnect, $group, $name)
{
$this->BORDER = 0;
$a = getPublicVarArray($dbConnect, $group, $name);
$t = new Table(array(""));
$t->setBorder($this->BORDER);
foreach ($a as $title => $text) {
$r1 = $t->createRow();
$r1->setAttribute(0, new Title($title));
$r1->setHeader(true);
$t->addRow($r1);
$r2 = $t->createRow();
$r2->setAttribute(0, $text);
$t->addRow($r2);
$t->addSpacer();
}
$this->TBL = $t;
}
function list_data($hal = 0) {
$paging = new MyPagina;
$paging->rows_on_page = 20;
$paging->sql = "SELECT
p.id as id,
p.nama as nama,
p.username as username,
pg.nama as `group`,
pel.nama as pelayanan
FROM
pengguna p
JOIN pengguna_group pg ON (pg.id = p.pengguna_group_id)
LEFT JOIN pelayanan pel ON (pel.id = p.pelayanan_id)
WHERE pg.id <> 1
ORDER BY
pg.nama,
p.nama";
$paging->get_page_result();
$paging->hal = $hal;
$_SESSION[hal] = $hal;
$paging->get_page_result();
$data = $paging->data;
$no = $paging->start_number();
$navi = $paging->navi();
$table = new Table;
$table->tbody_height = 300;
$table->addTh("No", "Nama", "Username", "Group", "Bangsal/<br />Klinik", "Hapus");
$table->addExtraTh(" style=\"width: 50px;\"", "", "", "", "", " style=\"width: 70px;\" ");
for($i=0;$i<sizeof($data);$i++) {
$table->addRow(
($no+$i),
$data[$i][nama],
$data[$i][username],
$data[$i][group],
$data[$i][pelayanan],
"<a href=\"javascript:void(0)\" title=\"Hapus\" onclick=\"hapus_pengguna('".$data[$i][id]."', this)\" class=\"tombol_hapus\"><img src=\"".IMAGES_URL."remove.png\" alt=\"Hapus\" border=\"0\" /></a>");
$table->addOnclickTd(
"xajax_get_pengguna('".$data[$i][id]."')",
"xajax_get_pengguna('".$data[$i][id]."')",
"xajax_get_pengguna('".$data[$i][id]."')",
"xajax_get_pengguna('".$data[$i][id]."')",
"xajax_get_pengguna('".$data[$i][id]."')"
);
}
$ret = $table->build();
$objResponse = new xajaxResponse();
$objResponse->addAssign("navi", "innerHTML", $navi);
$objResponse->addAssign("list_data", "innerHTML", $ret);
return $objResponse;
}
function list_data($hal = 0) {
$paging = new MyPagina;
$paging->sql = "
SELECT
pel.id as id,
pel.jenis as jenis,
pel.nama as nama,
spc.nama as spec,
pel.hari_buka as hari_buka
FROM
pelayanan pel
JOIN spesialisasi spc ON (spc.id = pel.spesialisasi_id)
WHERE
pel.jenis IN ('RAWAT JALAN', 'RAWAT INAP')
ORDER BY pel.jenis, spc.nama";
$paging->rows_on_page = 20;
$paging->hal = $hal;
$paging->get_page_result();
$_SESSION[hal] = $hal;
$data = $paging->data;
$no = $paging->start_number();
$navi = $paging->navi();
$table = new Table;
$table->addTh("No", "Jenis<br />Pelayanan", "Spesialisasi", "Nama Poliklinik/<br />Bangsal", "Hari Buka<br />Seminggu", "Hapus");
$table->addExtraTh("style=\"width:50px;\"","","","","","style=\"width:70px;\"");
for($i=0;$i<sizeof($data);$i++) {
if($data[$i][jenis] == $data[$i-1][jenis])
$jenis = "";
else
$jenis = $data[$i][jenis];
$table->addRow(
($no+$i),
$jenis,
$data[$i][spec],
$data[$i][nama],
$data[$i][hari_buka],
"<input type=\"button\" value=\"[ x ]\" name=\"hapus\" class=\"inputan\" onclick=\"xajax_hapus_pelayanan_confirm('".$data[$i][id]."', '".addslashes($data[$i][nama])."')\" />"
);
$table->addOnclickTd(
"xajax_get_pelayanan('".$data[$i][id]."')",
"xajax_get_pelayanan('".$data[$i][id]."')",
"xajax_get_pelayanan('".$data[$i][id]."')",
"xajax_get_pelayanan('".$data[$i][id]."')",
"xajax_get_pelayanan('".$data[$i][id]."')"
);
}
$ret = $table->build();
$objResponse = new xajaxResponse();
$objResponse->addAssign("navi", "innerHTML", $navi);
$objResponse->addAssign("list_data", "innerHTML", $ret);
return $objResponse;
}
function show()
{
$t = new Table(array(""));
$t->setAlign($this->getAlign());
$r = $t->createRow();
$r->setHeader(true);
$txt = new Text($this->TEXT);
$txt->setFonttype($this->FONTTYPE);
$txt->setFilter($this->getFilter());
$r->setAttribute(0, $txt);
$t->addRow($r);
$t->show();
}
public function Load()
{
parent::$PAGE_TITLE = __(CONFIGURE_USERS);
$config_users_obj = new Object("<br/>");
$this->result_obj = new Object();
$this->result_obj->setId("page_result_area");
$config_users_obj->add($this->result_obj);
$this->users_table_obj = new Object();
$this->users_table_obj->setId("users_table_obj");
$config_users_obj->add($this->users_table_obj, "<br/><br/>");
$user_table = new Table();
$form = new Form($this);
if (extension_loaded('openssl')) {
$form->setEncryptObject(new EncryptDataWspObject());
}
$this->edt_login = new TextBox($form);
$validation = new LiveValidation();
$user_table->addRowColumns(__(LOGIN) . ": ", $this->edt_login->setLiveValidation($validation->addValidatePresence()));
$this->cmb_rights = new ComboBox($form);
$this->cmb_rights->addItem(Page::RIGHTS_ADMINISTRATOR, "Administrator");
$this->cmb_rights->addItem(Page::RIGHTS_MODERATOR, "Moderator");
$this->cmb_rights->addItem(Page::RIGHTS_TRANSLATOR, "Translator");
$this->cmb_rights->addItem(Page::RIGHTS_DEVELOPER, "Developer");
$this->cmb_rights->addItem(Page::RIGHTS_AUTH_USER, "Authentificated user");
$this->cmb_rights->addItem(Page::RIGHTS_GUEST, "Guest");
$user_table->addRowColumns(__(RIGHTS) . ": ", $this->cmb_rights);
$this->edt_old_password = new Password($form);
$validation = new LiveValidation();
$this->old_passwd_row = $user_table->addRowColumns(__(OLD_PASSWORD) . ": ", $this->edt_old_password->setLiveValidation($validation->addValidatePresence()->setFieldName(__(OLD_PASSWORD))));
$this->old_passwd_row->setId("old_passwd_row");
$this->edt_password = new Password($form);
$validation = new LiveValidation();
$user_table->addRowColumns(__(PASSWORD) . ": ", $this->edt_password->setLiveValidation($validation->addValidatePresence()->setFieldName(__(PASSWORD))));
$this->edt_confirm_passwd = new Password($form);
$live_validation = new LiveValidation();
$live_validation->addValidatePresence()->setFieldName(__(CONFIRM_PASSWD));
$live_validation->addValidateConfirmation($this->edt_password->getId());
$user_table->addRowColumns(__(CONFIRM_PASSWD) . " : ", $this->edt_confirm_passwd->setLiveValidation($live_validation))->setStyle("color:black;");
$user_table->addRow();
$this->validate_btn = new Button($form);
$this->validate_btn->setValue(__(ADD))->onClick("addWspUser")->setAjaxEvent()->disableAjaxWaitMessage()->assignEnterKey();
$this->modify_btn = new Button($form);
$this->modify_btn->setValue(__(SAVE))->onClick("changeWspUser")->setAjaxEvent()->disableAjaxWaitMessage()->assignEnterKey();
$this->cancel_btn = new Button($this);
$this->cancel_btn->setValue(__(CANCEL))->onClick("refresh")->setAjaxEvent()->disableAjaxWaitMessage();
$modif_btn_table = new Table();
$modif_btn_table->addRowColumns($this->validate_btn, " ", $this->modify_btn, " ", $this->cancel_btn);
$user_table->addRow($modif_btn_table)->setColspan(2)->setAlign(RowTable::ALIGN_CENTER);
$config_users_obj->add($form->setContent($user_table), "<br/><br/>");
$this->render = new AdminTemplateForm($this, $config_users_obj);
}
function list_data($hal = 0) {
$paging = new MyPagina;
$paging->sql = "
SELECT
pel.id as id,
pel.nama as nama,
spc.nama as spec,
pel.hari_buka as hari_buka,
pel.tarif as tarif
FROM
pelayanan pel
JOIN spesialisasi spc ON (spc.id = pel.spesialisasi_id)
WHERE
pel.jenis ='RAWAT JALAN'
ORDER BY spc.nama";
$paging->rows_on_page = 20;
$paging->hal = $hal;
$paging->get_page_result();
$_SESSION[hal] = $hal;
$data = $paging->data;
$no = $paging->start_number();
$navi = $paging->navi();
$table = new Table;
$table->tbody_height = 390;
$table->addTh("No", "Nama Poliklinik", "Spesialisasi", "Hari Buka<br />Seminggu", "Tarif","Hapus");
$table->addExtraTh("style=\"width:50px;\"","","","","","style=\"width:70px;\"");
for($i=0;$i<sizeof($data);$i++) {
$table->addRow(
($no+$i),
$data[$i][nama],
$data[$i][spec],
$data[$i][hari_buka],$data[$i][tarif],
"<a href=\"javascript:void(0)\" title=\"Hapus\" onclick=\"hapus_pelayanan('".$data[$i][id]."', this)\" class=\"tombol_hapus\"><img src=\"".IMAGES_URL."remove.png\" alt=\"Hapus\" border=\"0\" /></a>"
);
$table->addOnclickTd(
"xajax_get_pelayanan('".$data[$i][id]."')",
"xajax_get_pelayanan('".$data[$i][id]."')",
"xajax_get_pelayanan('".$data[$i][id]."')",
"xajax_get_pelayanan('".$data[$i][id]."')",
"xajax_get_pelayanan('".$data[$i][id]."')"
);
}
$ret = $table->build();
$objResponse = new xajaxResponse();
$objResponse->addAssign("navi", "innerHTML", $navi);
$objResponse->addAssign("list_data", "innerHTML", $ret);
return $objResponse;
}
function showFullname()
{
$fp = new Text($this->getPath(), 3, true);
$btnDel = new Button("clearLog", "Log leeren");
$hdnDel = new Hiddenfield("clearLogFile", $this->FULLPATH);
$frmDel = new Form();
$tblTtl = new Table(array("", ""));
$tblTtl->setColSizes(array(null, 100));
$tblTtl->setAlignments(array("left", "right"));
$rTtl = $tblTtl->createRow();
$rTtl->setAttribute(0, $fp);
$rTtl->setAttribute(1, $btnDel);
$tblTtl->addRow($rTtl);
$frmDel->add($tblTtl);
$frmDel->add($hdnDel);
$frmDel->show();
}
function Error($title, $text, $backLink = '')
{
$t = "<font color='red' size='3' ><b>" . $text . "</b></font>";
if (strlen($backLink) > 0) {
$t .= " <br><br><a target ='_top' href='" . $backLink . "'>ZurÃÂÃÂÃÂück</a>";
}
$text = new Text($t);
$text->setFilter(false);
$title = array("FEHLER: " . $title);
$tbl = new Table($title);
$r = $tbl->createRow();
$r->setAttribute(0, $text);
$tbl->addRow($r);
$tbl->setWidth(500);
$tbl->show();
exit;
}
/**
* Executa comando
*
* @param Object $oInput
* @param Object $oOutput
* @access public
* @return void
*/
public function execute($oInput, $oOutput)
{
$oParametros = new \StdClass();
$oParametros->aArquivos = $oInput->getArgument('arquivos');
$oParametros->iTag = ltrim(strtoupper($oInput->getOption('tag')), 'T');
$oParametros->aMensagens = $oInput->getOption('message');
$oParametros->sData = $oInput->getOption('date');
$oArquivoModel = new ArquivoModel();
$aArquivosCommitados = $oArquivoModel->getCommitados($oParametros);
if (empty($aArquivosCommitados)) {
throw new \Exception("Nenhum arquivo encontrado.");
}
$oOutput->writeln("");
$oBuscaOutputFormatter = new OutputFormatterStyle('red', null, array());
$oOutput->getFormatter()->setStyle('busca', $oBuscaOutputFormatter);
foreach ($aArquivosCommitados as $oDadosCommit) {
$sTitulo = "- <comment>" . date('d/m/Y', strtotime($oDadosCommit->date)) . "</comment> as " . date('H:s:i', strtotime($oDadosCommit->date));
$sTitulo .= " " . count($oDadosCommit->aArquivos) . " arquivo(s) commitado(s)";
$oOutput->writeln($sTitulo);
if (!empty($oDadosCommit->title)) {
$oOutput->writeln("\n " . $oDadosCommit->title);
}
$oTabela = new \Table();
$oTabela->setHeaders(array('1', '1', '1', '1'));
foreach ($oDadosCommit->aArquivos as $oArquivo) {
$sArquivo = $this->getApplication()->clearPath($oArquivo->name);
$sTag = $oArquivo->tag;
$sMensagem = $oArquivo->message;
foreach ($oParametros->aArquivos as $sParametroArquivo) {
$sArquivo = $this->colorirBusca($sArquivo, $sParametroArquivo, 'busca');
}
if (!empty($oParametros->iTag)) {
$sTag = $this->colorirBusca($oArquivo->tag, $oParametros->iTag, 'busca');
}
if (!empty($oParametros->aMensagens)) {
foreach ($oParametros->aMensagens as $sMensagemBuscar) {
$sMensagem = $this->colorirBusca($sMensagem, $sMensagemBuscar, 'busca');
}
}
$oTabela->addRow(array($oArquivo->type, " {$sArquivo}", " {$sTag}", " {$sMensagem}"));
}
$oOutput->writeln(" " . str_replace("\n", "\n ", $oTabela->render(true)));
}
}
public static function display()
{
if (!is_numeric($_GET['id'])) {
cc_redirect(Admin::link('users'));
}
if ($_POST['cc_form'] == 'edit-group') {
$id = $_GET['id'];
$previous = (array) unserialize(urldecode($_POST['previous']));
$group = $_POST['group'];
$permissions = (array) $_POST['permissions'];
$new = array_merge($previous, $permissions);
foreach ($new as $k => $v) {
if ($v == "1") {
$new[$k] = true;
}
if (!array_key_exists($k, $permissions)) {
$new[$k] = false;
}
}
if (DB::update('users', array('name', 'data'), array($group, serialize(filter('admin_edit_group_data', array('permissions' => $new)))), array('users_id = ?', $id))) {
$message = Message::success(__('admin', 'group-information-updated'));
} else {
$message = Message::error(__('admin', 'database-error'));
}
}
$p = Permissions::getAll();
$g = new Group((int) $_GET['id']);
$p_form = new Form('');
$p_form->setCC_Form('edit-group');
$p_form->startFieldset(__('admin', 'group-information'));
$p_form->addInput(__('admin', 'group-name'), 'text', 'group', $g->getName());
$p_form->endFieldset();
$p_form->addHTML(sprintf("<h3>%s</h3>", __('admin', 'permissions')));
$p_table = new Table('permissions');
$p_table->addHeader(array('Name', 'Allowed'));
foreach ($p as $k => $v) {
$previous[$v['name']] = $g->isAllowed($v['name']);
$p_table->addRow(array(__('permissions', $v['name']), sprintf('<input type="checkbox" name="permissions[%s]"%svalue="1"/>', $v['name'], $g->isAllowed($v['name']) ? ' checked="checked"' : '')));
}
$p_form->addHidden('previous', urlencode(serialize($previous)));
$p_form->addHTML($p_table->html());
$p_form->addSubmit('', 'save-permissions', __('admin', 'save-changes'));
return array(sprintf('%s: %s', __('admin', 'edit-group'), $g->getName()), $message . $p_form->html());
}
function list_data($hal = 0) {
$_SESSION[setting_bhp][hal] = $hal;
$objResponse = new xajaxResponse();
$paging = new MyPagina;
$paging->rows_on_page = 20;
$paging->sql = "SELECT id, nama, biaya, bhp_p, bhp_rs, bhp_rs_adm, bhp_rs_op FROM bhp ORDER BY nama";
$paging->hal = $hal;
$paging->get_page_result();
$data = $paging->data;
$no = $paging->start_number();
$navi = $paging->navi();
$tabel = new Table;
$tabel->tbody_height = 430;
$tabel->addTh("No", "BHP", "Biaya", "bhp p", "bhp rs", "bhp rs adm", "bhp rs op", "Hapus");
//$tabel->addExtraTh("style=\"width: 50px;\"", "", " style=\"width: 70px;\"");
for($i=0;$i<sizeof($data);$i++) {
$tabel->addRow(
($no+$i),
$data[$i][nama],
$data[$i][biaya],
$data[$i][bhp_p],
$data[$i][bhp_rs],
$data[$i][bhp_rs_adm],
$data[$i][bhp_rs_op],
"<a href=\"javascript:void(0)\" title=\"Hapus\" onclick=\"hapus_bhp('".$data[$i][id]."', this)\" class=\"tombol_hapus\"><img src=\"".IMAGES_URL."remove.png\" alt=\"Hapus\" border=\"0\" /></a>");
$tabel->addOnclickTd(
"xajax_get_bhp('".$data[$i][id]."')",
"xajax_get_bhp('".$data[$i][id]."')",
"xajax_get_bhp('".$data[$i][id]."')",
"xajax_get_bhp('".$data[$i][id]."')",
"xajax_get_bhp('".$data[$i][id]."')",
"xajax_get_bhp('".$data[$i][id]."')",
"xajax_get_bhp('".$data[$i][id]."')"
);
}
$buka = $tabel->build();
$objResponse->addAssign("list_data", "innerHTML", $buka);
$objResponse->addAssign("navi", "innerHTML", $navi);
return $objResponse;
}
/**
* Changes an array of pagenames into a table with "edit", "view" and "delete" options
*/
protected function createPageList($data)
{
$this->setState('CREATING_PAGE_LIST_TABLE');
//Create new Table item
$t = new Table();
//Create new Table
$t->createTable("Pagelist");
//Sets that there is no heading row.
$t->setHead(false);
//Loop Through each page
for ($i = 0; $i < count($data); $i++) {
//Add Page data for each row.
$t->addRow(array($data[$i], "<a href='?system=Editor&page=editor&active=" . $data[$i] . "'>" . $this->localize("Edit") . "</a>", "<a href='?page=" . $data[$i] . "'>" . $this->localize("View") . "</a>", "<a href='?system=Editor&page=delete&active=" . $data[$i] . "'>" . $this->localize("Delete") . "</a>"));
}
//Creates a table from inserted data
$t->runTable();
//Returns the created table.
return $t->getTable();
}
function list_data($hal = 0) {
$_SESSION[setting_karcis][hal] = $hal;
$objResponse = new xajaxResponse();
$paging = new MyPagina;
$paging->rows_on_page = 20;
$paging->sql = "SELECT * FROM karcis ORDER BY jenis, nama";
$paging->hal = $hal;
$paging->get_page_result();
$data = $paging->data;
$no = $paging->start_number();
$navi = $paging->navi();
$tabel = new Table;
$tabel->tbody_height = 430;
$tabel->addTh("No", "Nama", "Jenis", "Kelas", "Jasa", "Hapus");
//$tabel->addExtraTh("style=\"width: 50px;\"", "", " style=\"width: 70px;\"");
for($i=0;$i<sizeof($data);$i++) {
if($data[$i][jenis] == "IGD") $jenis = "IRD";
else $jenis = $data[$i][jenis];
$tabel->addRow(
($no+$i),
$data[$i][nama],
$jenis,
$data[$i][kelas],
$data[$i][biaya_jasa],
"<a href=\"javascript:void(0)\" title=\"Hapus\" onclick=\"hapus_karcis('".$data[$i][id]."', this)\" class=\"tombol_hapus\"><img src=\"".IMAGES_URL."remove.png\" alt=\"Hapus\" border=\"0\" /></a>");
$tabel->addOnclickTd(
"xajax_get_karcis('".$data[$i][id]."')",
"xajax_get_karcis('".$data[$i][id]."')",
"xajax_get_karcis('".$data[$i][id]."')",
"xajax_get_karcis('".$data[$i][id]."')",
"xajax_get_karcis('".$data[$i][id]."')"
);
}
$buka = $tabel->build();
$objResponse->addAssign("list_data", "innerHTML", $buka);
$objResponse->addAssign("navi", "innerHTML", $navi);
return $objResponse;
}
public static function display()
{
$users = Database::select('users', '*', array('type = ?', 'user'), array('name', 'ASC'));
$groups = Database::select('users', '*', array('type = ?', 'group'), array('name', 'ASC'));
$groups_array = array();
$groups_table = new Table("groups", array('', 'actions'));
$groups_table->addHeader(array(__('admin', "group-name"), __('admin', "actions")));
foreach ($groups->fetchAll(PDO::FETCH_ASSOC) as $key => $value) {
$group_array[$value['users_id']] = $value['name'];
$groups_table->addRow(array($value['name'], icon('group_edit', Admin::link('users/edit-group', array('id' => $value['users_id'])), false, array('rel' => 'tooltip', 'title' => StringUtils::escapeForHTMLAttr(sprintf(__('admin', 'edit-specific'), $value['name'])))) . icon('group_delete', Admin::link('users/delete', array('id' => $value['users_id'], 'type' => 'group')), false, array('class' => 'delete-link', 'rel' => 'tooltip', 'title' => StringUtils::escapeForHTMLAttr(sprintf(__('admin', 'delete-specific'), $value['name']))))));
}
$groups_table = $groups_table->html();
$users_table = new Table("users", array('', '', 'actions'));
$users_table->addHeader(array(__('admin', 'name'), __('admin', 'group'), __('admin', 'actions')));
foreach ($users->fetchAll(PDO::FETCH_ASSOC) as $key => $value) {
$users_table->addRow(array($value['name'], $group_array[$value['group']], icon('user_edit', Admin::link('users/edit-user', array('id' => $value['users_id'])), false, array('rel' => 'tooltip', 'title' => StringUtils::escapeForHTMLAttr(sprintf(__('admin', 'edit-specific'), $value['name'])))) . icon('user_delete', Admin::link('users/delete', array('id' => $value['users_id'], 'type' => 'user')), false, array('class' => 'delete-link', 'rel' => 'tooltip', 'title' => StringUtils::escapeForHTMLAttr(sprintf(__('admin', 'delete-specific'), $value['name']))))));
}
$r = "<h3>" . __('admin', 'users') . "</h3>" . $users_table->html() . "<h3>" . __('admin', 'groups') . "</h3>" . $groups_table;
return array(__('admin', 'user-management'), $r);
}