se/SE/se-lib/Route/UrlAction/ProcesView.php

<?php

Lib::loadClass('RouteBase');
Lib::loadClass('ProcesHelper');
Lib::loadClass('Config');
Lib::loadClass('UI');
Lib::loadClass('Request');
Lib::loadClass('ProcesHelper');
Lib::loadClass('Response');

class Route_UrlAction_ProcesView extends RouteBase {// TODO: UrlActionBase @see Route_UrlAction

	public function getAllAjaxAction(){
		try {
			$rows = DB::getPDO()->fetchAll("
				select `ID`, `PARENT_ID`, `DESC`, `OPIS`, `TYPE`, `IF_TRUE_GOTO`, `IF_TRUE_GOTO_FLAG`, `SORT_PRIO`
				from CRM_PROCES
				WHERE `PARENT_ID`>=0
					AND `A_STATUS` <> 'DELETED'
					AND `ID` <> `PARENT_ID`
				ORDER BY `SORT_PRIO` ASC, `ID` DESC
			");
			$state = array();
			foreach ($rows as $key => $value) {
				$id = intval($value["ID"]);
				$parent_id = intval($value["PARENT_ID"]);
				$state[$id]["ID"] = $value["ID"];
				$state[$id]["DESC"] = $value["DESC"];
				$state[$id]["OPIS"] = $value["OPIS"];
				$state[$id]["TYPE"] = $value["TYPE"];
				$state[$id]["IF_TRUE_GOTO"] = intval($value["IF_TRUE_GOTO"]);
				$state[$id]["IF_TRUE_GOTO_FLAG"] = $value["IF_TRUE_GOTO_FLAG"];
				$state[$id]["PARENT_ID"] = (intval($value["PARENT_ID"]) != 0) ? intval($value["PARENT_ID"]) : "#";
				$state[$id]["SORT_PRIO"] = $value["SORT_PRIO"];
				if (!isset($state[$id]["childs"])) $state[$id]["childs"] = array();
				if (!isset($state[$parent_id]["childs"])) $state[$parent_id]["childs"] = array();
				$temp = array();
				$temp["ID"] = $id;
				array_push($state[$parent_id]["childs"], $temp);
			}
			Response::sendJsonExit($state);
		} catch (Exception $e) {
			UI::alert('danger', "Error: " . $e->getMessage());
		}
	}

	public function getConnectedProcAjaxAction(){
		try {
			$id = V::get('id', 0, $_REQUEST, 'int');
			$rows = DB::getPDO()->fetchAll("
				SELECT * FROM `CRM_WSKAZNIK` WHERE `ID_ZASOB` = $id AND `A_STATUS` <> 'DELETED'
			");
			$state = array();
			$state["wsk"] = array();
			foreach($rows as $key => $value){
				$temp["ID"] = $value["ID"];
				$temp["ID_PROCES"] = $value["ID_PROCES"];
				$temp["ID_ZASOB"] = $value["ID_ZASOB"];
				array_push($state["wsk"], $temp);
			}
			Response::sendJsonExit($state);
		} catch (Exception $e) {
			UI::alert('danger', "Error: " . $e->getMessage());
		}
	}

	public function getDetailsAjaxAction(){
		try {
			$id = V::get('id', 0, $_REQUEST, 'int');
			$rows = DB::getPDO()->fetchAll("
				SELECT * FROM `CRM_WSKAZNIK` WHERE `ID_PROCES` = {$id} AND `A_STATUS` <> 'DELETED'
			");
			$state = array();
			$state["wsk"] = array();
			foreach($rows as $key => $value){
				$temp["ID"] = $value["ID"];
				$temp["ID_PROCES"] = $value["ID_PROCES"];
				$temp["ID_ZASOB"] = $value["ID_ZASOB"];
				array_push($state["wsk"], $temp);
			}
			$count = DB::getPDO()->fetchAll("
				SELECT count(*) as imgCount FROM `CRM_IMAGE` WHERE `REMOTE_ID` = {$id} AND `REMOTE_TABLE` = 'CRM_PROCES'
			");
			$state["IMG_COUNT"] = $count[0]["imgCount"];
			Response::sendJsonExit($state);
		} catch (Exception $e) {
			UI::alert('danger', "Error: " . $e->getMessage());
		}
	}

	public function getAllResAjaxAction(){
		try {
			$rows = DB::getPDO()->fetchAll("
				select `ID`, `PARENT_ID`, `DESC`, `OPIS`, `ALIAS_ID`, `TYPE`
				from CRM_LISTA_ZASOBOW
				WHERE `PARENT_ID`>=0
					AND `A_STATUS` <> 'DELETED'
					AND `ID` <> `PARENT_ID`
				ORDER BY `SORT_PRIO` ASC, `ID` DESC
			");
			$state = array();
			foreach ($rows as $key => $value) {
				$id = intval($value["ID"]);
				$parent_id = intval($value["PARENT_ID"]);
				$state[$id]["ALIAS_ID"] = intval($value["ALIAS_ID"]);
				$state[$id]["ID"] = $value["ID"];
				$state[$id]["DESC"] = $value["DESC"];
				$state[$id]["TYPE"] = $value["TYPE"];
				$state[$id]["OPIS"] = $value["OPIS"];
				$state[$id]["PARENT_ID"] = (intval($value["PARENT_ID"]) != 0) ? intval($value["PARENT_ID"]) : "#";
				if (!isset($state[$id]["childs"])) $state[$id]["childs"] = array();
				if (!isset($state[$value["PARENT_ID"]])) $state[$parent_id]["childs"] = array();
				$temp = array();
				$temp["ID"] = $id;
				array_push($state[$parent_id]["childs"], $temp);
			}
			Response::sendJsonExit($state);
		} catch (Exception $e) {
			UI::alert('danger', "Error: " . $e->getMessage());
		}
	}

	public function handleAuth() {
		if (!User::logged()) User::authByRequest();
	}

	public function defaultAction() {
		UI::gora();
		UI::menu();
		try {
			$start_id = V::get('START_ID', 0, $_REQUEST, 'int');
			$type = V::get('TYPE', '', $_REQUEST, 'string');
			$type = ($type == "zasoby") ? "res" : "childs";
			$this->showView($start_id, $type);
		} catch (Exception $e) {
			UI::alert('danger', "Error: " . $e->getMessage());
		}
		UI::dol();
	}

	public function showView($start_id, $type) {
		echo "<div class=container-fluid>";
		echo "<div class=row>";
		echo "<div class=col-md-12 style=padding-top:15px;><a id=toggleMenu style=cursor:pointer;>Przełącz menu</a><a style=float:right;cursor:pointer; id=toggleView>Przełącz widok</a></div>";
		echo "<div class=col-md-12 id=view>";
		echo "";
		echo "</div>";
		echo "</div>";
		echo "<script>var TYPE = '".$type."';var START_ID = '".$start_id."';var BASE_URL = '".Request::getPathUri()."';var ProcesTableId=".ProcesHelper::getZasobTableID('CRM_PROCES').";</script>";
		echo '<script src="static/sweetalert2.min.js"></script>';
		echo '<link rel="stylesheet" type="text/css" href="static/sweetalert2.min.css">';
		echo '<link rel="stylesheet" href="static/jstree-theme/style.min.css" />';
		echo '<script src="static/jstree.min.js"></script>';
		echo '<script src="static/procesView.js?v=2'.((V::get('DBG', '', $_GET)) ? time() : '').'"></script>';// TODO: static v, only in DBG
    $this->showViewCss();
	}

  public function showViewCss() {
?>
<style type="text/css">
.singleAdv{
float:left;
padding-bottom:20px;
display:block;
width:460px;
}

.toggleRoute{
	text-align:center;
	margin-top:10px;
	padding:5px;
	background-color:#ededed;
	opacity:0.6;
	cursor:pointer;
}

.route{
	border-style:solid;
	border-width:2px;
	padding:5px;
	display:none;
	border-radius:2px;
	border-color:#ededed;
}

.toggleRoute:hover{
	opacity:1;
}

.goto{

}

.singleAdvList{
		overflow-y:scroll;
}

.gotoInfo{
	background-color:#e5a100;
	color:white;
	padding:10px;
	margin-left:50px;
	font-size:1.0em;
}

.gotoWay{
	background-color:#ededed;
	padding:10px;
}

.normalChilds{
	background-color: #ededed;
}

#procCon{
	display:block;
	height:100%;
}

.textTable{
	float:left;
	width:400px;

  overflow:hidden;
	display:inline-block;
}

.glyph{
  opacity:0.4;
}
.glyph:hover{
  opacity:1;
}

.detailsTable{
	color:black;
	display:inline-block;
	padding:4px;
	padding-top:1px;
	padding-bottom:1px;
	border-width:1px;
	border-color:grey;
}

.detailsTable2{
	color:black;
	display:inline-block;
	padding:3px;
	padding-top:0px;
	padding-bottom:0px;
	border-width:1px;
	border-color:grey;
	height:24px; line-height:22px; border:1px solid #fff;
}

#ulproc{
    background-color: white;
    overflow-y: scroll;
    height: 70% !important;
		border-style:solid;
		border-width:1px;
		border-color:grey;
    margin-top: 10px;
    border-radius: 5px;
    padding-bottom: 10px;
    border-style: solid;
    border-width: 1px;
    border-color: #e5e5e5;
    color: black;
    padding-left: 0px;
    font-family: tahoma;
    font-size: 13px;
}
#tree { overflow:hidden; border:1px solid #ddd; }
</style>
<?php
  }

}