public function to_log($message = NULL)
{
parent::getRequest();
$request = $this->getRequest();
$controller = $request->getControllerName();
$action = $request->getActionName();
$data = array('log_user' => $this->user->getLogin(), 'log_ip' => $_SERVER['REMOTE_ADDR'], 'log_controller' => $controller, 'log_action' => $action, 'log_request' => $_SERVER['REQUEST_URI'], 'log_message' => $message);
$log = new Log($this->siteId);
$log->addLog($data);
}
public function logout()
{
//$this->model->logout();
//Session::unsetAll();
Session::createSession();
$log = new Log();
$log->addLog(Session::get('user'), 'LOGOUT', '');
unset($log);
Session::destroySession();
//session_destroy();
header('location:' . URL . 'login');
exit;
}
function save($values, $id_node)
{
$tmp = dibi::fetch("SELECT * FROM " . self::TABLE . " WHERE id_node=%i", $id_node);
// print_r($tmp);
unset($values['id_node']);
//odstranenie premennych ktore niesu v databaze
foreach ($values as $key => $v) {
if (!array_key_exists($key, $tmp)) {
unset($values[$key]);
}
}
// print_r($values);
dibi::query("UPDATE " . self::TABLE . " SET ", $values, " WHERE id_node=%i", $id_node);
Log::addLog($this, "Uprava contact form", "Menil:" . NEnvironment::getSession('Authentication')->login_form, '', $id_node);
}
function saveGMap($values, $id_node)
{
$tmp = dibi::fetch("SELECT * FROM [gmap] WHERE id_node=%i", $id_node);
unset($values['id_node']);
unset($values['saveGMap']);
//odstranenie premennych ktore niesu v databaze
$tmp = (array) $tmp;
foreach ($values as $key => $v) {
if (!array_key_exists($key, $tmp)) {
unset($values[$key]);
}
}
$values['googleBar'] = (int) $values['googleBar'];
$values['enableScrollWheelZoom'] = (int) $values['enableScrollWheelZoom'];
$values['doubleClickZoom'] = (int) $values['doubleClickZoom'];
if (isset($values['modul_visible'])) {
node::changeVisibility($id_node, $values['modul_visible']);
}
dibi::query("UPDATE gmap SET ", $values, " WHERE id_node=%i", $id_node);
Log::addLog($this, "Uprava gmap", "Menil:" . NEnvironment::getSession('Authentication')->login_form, '', $id_node);
}
echo " <a href='?page=" . $_GET['page'] . '&action=' . $_GET['action'] . '&do=' . $_GET['do'] . "&page-id={$lastPage}'>>></a>";
}
echo ' </div>';
break;
}
}
} else {
echo '<h1>Admin Panel</h1>';
if ($_SERVER['REQUEST_METHOD'] == "POST") {
if (empty($_POST['username']) || empty($_POST['password'])) {
echo '<p id="response" class="notification red">Please fill in all the fields.</p>';
} else {
if ($admin->login($_POST['username'], $_POST['password'])) {
echo '<p id="response" class="notification green">You have successfully logged in. Please wait until the page reloads.</p>';
$loggedIn = true;
$log->addLog($_SESSION['loggedIn']['id'], "Logged in.");
redirect("", "3");
} else {
echo '<p id="response" class="notification red">The user / password combination was incorrect. Please try again.</p>';
}
}
}
if ($loggedIn !== true) {
?>
<form class="styled" action="" method="post">
<label>Username</label>
<input type="text" name="username" value="" />
<br />
/**
* Saves all aspects of current request to a log file so that we ensure
* that we never lose user data and can retrieve it in the event of an
* emergency
*
* @return none
*/
function logRequest()
{
$log = new Log("direct_entry");
$logmsg = $_SERVER['REMOTE_ADDR'];
if (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
$logmsg .= " (" . $_SERVER['HTTP_X_FORWARDED_FOR'] . ")";
}
$logmsg .= substr(print_r($_REQUEST, true), 5);
$log->addLog($logmsg);
}
private function deleteUser()
{
dibi::query("DELETE FROM auth_user WHERE id_auth_user=%i", $_GET['id_delete_user']);
Log::addLog($this, "Zmazanie uzovatela", $_GET['id_delete_user']);
}
function saveProduct($values, $id_node)
{
$collums = Tools::getCollum('module_product');
foreach ($values as $k => $v) {
if (!in_array($k, $collums)) {
unset($values[$k]);
}
}
$newname = "";
$name = $values['title'];
$i = 0;
while ($i < 50) {
if ($i == 0) {
$newname = $name;
} else {
$newname = NStrings::webalize($name . $i);
}
$s = dibi::fetchSingle("SELECT COUNT(id_node) FROM [module_product] WHERE url_identifier=%s", $newname, " AND id_node!=%i", $id_node);
if ($s == 0) {
break;
} else {
$i++;
}
}
$values['url_identifier'] = $newname;
dibi::query("UPDATE [module_product] SET ", $values, " WHERE id_node=%i", $id_node);
Log::addLog($this, "Uprava produktu", "Menil:" . NEnvironment::getSession('Authentication')->login_form, $values['title'], $id_node);
}
public function uploadFileSurat()
{
$upload = new Upload('upload');
$upload->setDirTo('arsip/');
$tipe = 'M';
$satker = $_POST['satker'];
$nomor = $_POST['nomor'];
//nama baru akan terdiri dari tipe naskah_nomor surat_asal(asal/tetapi asal terlaku kepanjangan)
$ubahNama = array($tipe, $nomor, $satker);
$upload->setUbahNama($ubahNama);
$upload->changeFileName($upload->getFileName(), $ubahNama);
$namafile = $upload->getFileTo();
$where = ' id_suratmasuk=' . $_POST['id'];
$data = array('file' => $namafile);
if ($upload->uploadFile()) {
$this->model->uploadFile($data, $where);
$datastat = array('stat' => '14');
@Session::createSession();
$user = Session::get('user');
$log = new Log();
$log->addLog($user, 'UPLOAD', 'user ' . $user . ' upload file surat no agenda ' . $this->model->getNomorAgenda($_POST['id']) . ' file:' . $namafile);
unset($log);
$this->model->update('suratmasuk', $datastat, $where);
//update status -> pelaksana
echo "<div id=success>Upload file berhasil</div>";
} else {
echo "<div id=error>Upload file berhasil</div>";
}
// return true;
//header('location:'.URL.'suratmasuk');
}
require_once '../lib/Log.php';
require_once 'arraysDominios.php';
$sqlInsert = 'INSERT INTO sgdoc.tb_pessoa_siorg_carga (co_orgao, co_orgao_pai, link_tipo_orgao, co_tipo_orgao, no_tipo_orgao, link_tipo_unidade, no_orgao, sg_orgao,
link_endereco, link_contato, in_organizacao, tx_versao_consulta)
VALUES (:co_orgao, :co_orgao_pai, :link_tipo_orgao, :co_tipo_orgao, :no_tipo_orgao, :link_tipo_unidade, :no_orgao, :sg_orgao,
:link_endereco, :link_contato, :in_organizacao, :tx_versao_consulta);';
/*
* Em virtude do tamanho do arquivo, ele será lido como um arquivo txt,
* linha a linha, e cada linha será convertida, como um string xml, para um objeto
*/
$arqDadosXml = 'dados.txt';
$log = new Log('.', 'cargaSiorg');
$log->setPrintScreen(true);
$cnnBanco = ConfigWs::factory()->getConnection();
try {
$log->addLog("Abrindo arquivo de dados [{$arqDadosXml}]");
$hdlDados = fopen($arqDadosXml, 'r');
libxml_use_internal_errors(true);
if ($hdlDados) {
$l = 0;
$tmp = '';
$strXml = '';
$cnnBanco->beginTransaction();
$log->addLog('Limpando tabela destino');
$cnnBanco->prepare('truncate sgdoc.tb_pessoa_siorg_carga;')->execute();
$stmt = $cnnBanco->prepare($sqlInsert);
$log->addLog('Início da leitura dos dados');
while (($linha = fgets($hdlDados)) !== false) {
$l++;
/*
if ($l > 100) { break; }
function delete($id_node)
{
dibi::query("DELETE FROM user_form WHERE id_node=%i", $id_node);
Log::addLog($this, "Vymazanie user_form", $id_node);
}
public function uploadrev()
{
$return = true;
$notif = new Notifikasi();
$id = $_POST['id'];
$catatan = $_POST['catatan'];
$user = $_POST['user'];
// var_dump($catatan);
$time = date('Y-m-d H:i:s');
$filename = '';
$datas = $this->model->getSuratById($id, 'detil');
// foreach ($datas as $val){
$filename = $datas->getFile();
// }
//---------------------------------
$fln = array();
if (file_exists('arsip/temp/' . $filename)) {
//jika file telah ada di folder temp/
$temp = explode('.', $filename);
// var_dump($temp);
$sql = "SELECT file FROM revisisurat WHERE file LIKE '{$temp['0']}%'";
$file = $this->model->select($sql);
// var_dump($file);
if (count($file > 0)) {
if (count($file) == 1) {
$pisah = explode('.', $filename);
$nama = $pisah[0];
$ext = $pisah[1];
var_dump($ext);
$filename = $nama . '_1.' . $ext;
// var_dump($filename);
// break;
} else {
foreach ($file as $val) {
$temp = explode('.', $val['file']);
$pisah = explode('_', $temp[0]);
if (count($pisah) <= 3) {
$fln[] = 0;
} else {
$fln[] = $pisah[3];
}
// $fln[] = explode('_', $temp[0]);
// var_dump($fln);
// $len = count($temp);
// $fln[] = (int) ($len-1); //mengambil array terakhir
$num = max($fln);
// var_dump($num);
$filename = $pisah[0] . '_' . $pisah[1] . '_' . $pisah[2] . '_' . ($num + 1) . '.' . $temp[1];
// var_dump($filename);
}
}
}
}
//-----------------------------------
$data = array('id_surat' => $id, 'catatan' => $catatan, 'user' => $user, 'file' => $filename, 'time' => $time);
$ext = explode(".", $filename);
if ($ext[count($ext) - 1] == 'pdf') {
//jika telah diupload tipe file pdf
if (file_exists('arsip/' . $filename)) {
copy('arsip/' . $filename, 'arsip/temp/' . $filename);
}
//copykan ke folder temp/
} else {
$upload = new Upload('upload');
//jika tidak, upload file tersebut
$upload->setDirTo('arsip/temp/');
$upload->setFileTo($filename);
$upload->uploadFile();
}
//upload file revisi
// $upl = $upload->uploadFile(); //upload dengan nama beda jika sudah terdapat file di arsip
// if(!$upl){
// $return = "Gagal upload! cek file dan ekstensi, ekstensi harus pdf, doc atau docx";
// }
$role = Session::get('role');
/*
* alurnya klo revisi kasi->pelaksana
* revisi kk -> kasi dan pelaksana :siiip
* otak atik dari awak lagi, ternyata butuh field user/creator surat keluar yg berisi pelaksananya siapa
*/
//var_dump($id);
$notif->set('id_surat', $id);
//cek lagi
$notif->set('jenis_surat', 'SK');
$notif->set('stat_notif', 1);
$user = $this->model->getUser($id);
//var_dump($user);
$notif->set('bagian', $user[2]);
if ($role == 1) {
$dataks = $this->model->select("SELECT id_user FROM user WHERE role=2 AND bagian =" . $user[2] . " AND active='Y'");
foreach ($dataks as $val) {
$notif->set('id_user', $val['id_user']);
}
$notif->set('role', 2);
//tambah notifikasi untuk kasi
$notif->addNotifikasi();
}
$notif->set('id_user', $user[0]);
$notif->set('role', $user[1]);
//tambah notifikasi untuk pelaksana
$notif->addNotifikasi();
//tambah revisi
if ($this->model->addRevisi($data)) {
// $this->showAll();
@Session::createSession();
$user = Session::get('user');
$log = new Log();
$log->addLog($user, 'REKAM REVISI', 'user ' . $user . ' rekam revisi surat keluar id ' . $id . ' nama file ' . $filename);
unset($log);
echo "<div id=success>Rekam revisi berhasil</div>";
} else {
echo "<div id=error>Rekam revisi gagal</div>";
}
// return $return;
}
/**
* @access public
* @param $id_node
* @ParamType $id_node
*/
public function delete($id_node)
{
parent::deleleFiles($id_node);
dibi::query("DELETE FROM gallery WHERE id_node=%i", $id_node);
Log::addLog($this, "Vymazanie galerie", $id_node);
}
function deleteItemTree($parent, $objNode)
{
$list = dibi::fetchAll("SELECT id_menu_item FROM menu_item WHERE parent=%i", $parent);
foreach ($list as $l) {
$this->deleteItemTree($l['id_menu_item'], $objNode);
$objNode->deleteNode($l['id_menu_item']);
dibi::query("DELETE FROM menu_item WHERE id_menu_item=%i", $l['id_menu_item']);
//vymazanie z access
Log::addLog($this, "Vymazanie polozky z menu", $l['id_menu_item']);
}
}
