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

<?php

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

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

	public function getResByParentAjaxAction(){
		try {
			if(!isset($_GET['parent_id'])) throw new Exception("ID is not set.");
				$parent_id = DB::getPDO()->quote($_GET['parent_id'], PDO::PARAM_INT);
				$rows = DB::getPDO()->fetchAll("
					select g.*, p1.ID as p1_ID, p1.DESC as p1_DESC,p2.ID as p2_ID, p2.DESC as p2_DESC, p3.ID as p3_ID, p3.DESC as p3_DESC
					from CRM_LISTA_ZASOBOW g
						left join CRM_LISTA_ZASOBOW p1 on(p1.ID = g.PARENT_ID)
						left join CRM_LISTA_ZASOBOW p2 on(p2.ID = p1.PARENT_ID)
						left join CRM_LISTA_ZASOBOW p3 on(p3.ID = p2.PARENT_ID)
					where g.`PARENT_ID` = ".$parent_id." ORDER BY g.SORT_PRIO
				");
				Response::sendJsonExit($rows);
			} catch (Exception $e) {
				UI::alert('danger', "Error: " . $e->getMessage());
			}
	}

	public function getResAjaxAction(){
		try {
			if(!isset($_GET['word'])) throw new Exception("word is not set.");
				$word = DB::getPDO()->quote("%".$_GET['word']."%", PDO::PARAM_STR);

			$filter = isset($_GET['filter']) ? (int)$_GET['filter'] : 0;


			$sqlFilter = "";
			switch($filter){
				case 2: $sqlFilter = "AND (g.`TYPE` = 'TABELA' OR g.`TYPE` = 'KOMORKA')";break;
				case 1: $sqlFilter = "AND (g.`TYPE` = 'STANOWISKO' OR g.`TYPE` = 'DZIAL' OR g.`TYPE` = 'PODMIOT')";break;
			}
				$rows = DB::getPDO()->fetchAll("
					select g.*, p1.ID as p1_ID, p1.DESC as p1_DESC,p2.ID as p2_ID, p2.DESC as p2_DESC, p3.ID as p3_ID, p3.DESC as p3_DESC
					from CRM_LISTA_ZASOBOW g
						left join CRM_LISTA_ZASOBOW p1 on(p1.ID = g.PARENT_ID)
						left join CRM_LISTA_ZASOBOW p2 on(p2.ID = p1.PARENT_ID)
						left join CRM_LISTA_ZASOBOW p3 on(p3.ID = p2.PARENT_ID)
					where (g.`DESC` LIKE ".$word." OR g.`ID` LIKE ".$word.")
						".$sqlFilter."
					LIMIT 0,100
				");
				Response::sendJsonExit($rows);
			} catch (Exception $e) {
				UI::alert('danger', "Error: " . $e->getMessage());
			}
	}

	public function getSingleResAjaxAction(){

		try {
			if (!isset($_POST['data'])) throw new Exception("data is not set.");
			$data = $_POST['data'];
			$sqlWhereIdIn = array();
			foreach ($data as $value) {
        $sqlWhereIdIn[] = DB::getPDO()->quote($value, PDO::PARAM_INT);
                        }
        $sqlWhereIdIn = (!empty($sqlWhereIdIn)) ? "g.ID in(" . implode(", ", $sqlWhereIdIn) . ")" : "1=1";
			$rows = DB::getPDO()->fetchAll("
			select g.*, p1.ID as p1_ID, p1.DESC as p1_DESC,p2.ID as p2_ID, p2.DESC as p2_DESC, p3.ID as p3_ID, p3.DESC as p3_DESC
			from CRM_LISTA_ZASOBOW g
			  left join CRM_LISTA_ZASOBOW p1 on(p1.ID = g.PARENT_ID)
			  left join CRM_LISTA_ZASOBOW p2 on(p2.ID = p1.PARENT_ID)
				left join CRM_LISTA_ZASOBOW p3 on(p3.ID = p2.PARENT_ID)
			where {$sqlWhereIdIn}");
				Response::sendJsonExit($rows);

			} catch (Exception $e) {
				UI::alert('danger', "Error: " . $e->getMessage());
			}




	}

	public function handleAuth() {
		if (!User::logged()) {
			//throw new HttpException('Unauthorized', 401);
			User::authByRequest();
		}
		// zapisać jsona w sesji
	}

	public function defaultAction() {
		UI::gora();
		UI::menu();

		try {
			$id = V::get('id', 0, $_REQUEST, 'int');
			if ($id <= 0) throw new Exception("Wrong ID");
				$this->showEditor($id);
		} catch (Exception $e) {
			UI::alert('danger', "Error: " . $e->getMessage());
		}

		UI::dol();
	}

	public function showEditor($id) {
		echo '<link rel="stylesheet" type="text/css" href="static/sweetalert2.min.css">';
		$this->showEditorCss();

		echo "<div id=wrapper class=toggled>";
		echo "<div id='sidebar-wrapper'><div id=side>";

		echo "";
		echo "</div></div>";
		echo "<div id='page-content-wrapper'><div class=col-xs-1 id=left style='width:40px;'>";
		echo "<button class='lButton btn btn-default' id=btnZasoby style=top:150px; ><p>Zasoby</p></button><button class='lButton btn btn-default' style=top:315px; id=btnProcesy><p>Procesy</p></button>";
		echo "</div><div class=col-xs-11 id=main>";

		echo '<center>Uruchamianie aplikacji.</center>';

		echo "</div></div>";

		echo "<div class=clearfix></div>";
		echo "</div>";
		echo "<script>var BASE_URL = '".Request::getPathUri()."';var mainProces_id = ".$id.";</script>";
		echo '<script src="static/sweetalert2.min.js"></script>';
		echo '<script src="static/procesEditor.js?'.time().'"></script>';
	}

	public function showEditorCss() {
?>
<style type="text/css">
.activeDrop{
	background-color:#f1f1f1;

}

.treeInfo{
	overflow: hidden;
  text-align: right;
	display:inline-block;
	color:grey;
	font-size:0.9em;

  white-space: nowrap;
  max-width: 90%;
}

.treeInfo div{
	float:right;
}

#left{
	padding:0px;
}

.sDescAdd, .hDescAdd, .step{
	padding-left:10px;
}

.lButton{
	-webkit-transform: translate3d(0,0,0);
    position:fixed;
    padding:0px;
		outline:none;
    margin:0px;
    width: 40px;
    height:160px;
    z-index:30;
    border-top-left-radius: 0px;
		border-bottom-left-radius: 0px;
}

.lButton p
{
		margin-bottom:-50px;
    -moz-transform:rotate(-90deg);
    -ms-transform:rotate(-90deg);
    -o-transform:rotate(-90deg);
    -webkit-transform:rotate(-90deg);
}

.ico {
    float: right;
    margin-top: 10px;
    margin-left: 5px;
    cursor: pointer;
}
.options {
    min-width: 120px;
    width: auto !important;
    width: 120px;
}
#wrapper {
    padding-left: 0;
    -webkit-transition: all 0.5s ease;
    -moz-transition: all 0.5s ease;
    -o-transition: all 0.5s ease;
    transition: all 0.5s ease;
}
#wrapper.toggled {
    padding-left: 600px;
}
#side {
    padding: 15px;
    height: 100%;
		border-top-style:solid;
		border-top-width:1px;
    border-right-style: solid;
    border-color: #A61C2E;
    border-width: 2px;
}
ul {
    list-style: none;
}

#advCon{
	width:870px;
	min-width:100%;
}

.detailsTable{
	color:grey;
	float:left;
	display:inline;
	text-align:center;
	margin-left:5px;
	height:23px;
}

.tree{
	color:grey;
	text-overflow:ellipsis;
	white-space:nowrap;
  overflow:hidden;
	display:block;
	cursor:pointer;
}

.detailsTable2{
	color:grey;
	display:block;
	font-size:0.8em;
	text-align:left;
	margin-left:5px;
	height:23px;
}

.textTable{
	float:left;
	width:200px;
	text-overflow:ellipsis;
	white-space:nowrap;
  overflow:hidden;
	cursor:pointer;
	display:inline-block;
}

.anim-refresh {
    -animation: spin .7s infinite linear;
    -webkit-animation: spin2 .7s infinite linear;
}

@-webkit-keyframes spin2 {
    from { -webkit-transform: rotate(0deg);}
    to { -webkit-transform: rotate(360deg);}
}

@keyframes spin {
    from { transform: scale(1) rotate(0deg);}
    to { transform: scale(1) rotate(360deg);}
}

.list-group-item{
	cursor:pointer;
}

.list-group-item:hover{
	background-color:#eeeeee;
}

.list-group-item:hover .glyphicon{
	opacity:1 !important;
}

.textTable2{
	float:left;
	width:230px;
	text-overflow:ellipsis;
	white-space:nowrap;
  overflow:hidden;
	cursor:pointer;
	display:inline-block;
}


.pbody{
	padding-left:20px;
	padding-right:20px;
	text-align:justify;
}



.singleAdv{
float:left;
height:100%;

width:290px;
}

#side #adv{

}

#side #ulcon, #side #ulproc, #side #adv {
    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;
}

.selectedAdv{
	background-color:#e4e4e4;
}

.selectedAdv:hover{
	background-color:#e4e4e4;
}

#side .dragStyle {
    padding-left: 8px;
    padding-top: 4px;
    padding-bottom: 4px;
    border-bottom-style: dotted;
    border-width: 1px;
    cursor: pointer;
    border-color: #e5e5e5;
    background-color: white;
    display: block;
}
#side .showMore {
    padding-left: 2px;
    padding-top: 4px;
    padding-bottom: 4px;
    border-width: 1px;
    border-color: #e5e5e5;
}
#side .gIco {
    padding-left: 2px;
    padding-top: 4px;
    padding-bottom: 4px;
    border-width: 1px;
    border-color: #e5e5e5;
    cursor: pointer;
}
#side .hov,
#side .grad {
    cursor: pointer;
}
#side .click {
    float: left;
    color: grey;
    font-size: 10px;
    cursor: pointer;
}
.delRes,
.btnEdit,
.hdesc,
.sdesc {
    cursor: pointer;
}

.goto{
	padding-left:10px;

}

#side .tabelaName {
    white-space: nowrap;
    margin-right: 10px;
    overflow: hidden;
    width: 350px;
    float: left;
    text-overflow: ellipsis;
    display: block;
    cursor: pointer;
}
#side .hov:hover {
    background-color: #e5e5e5;
}
#sidebar-wrapper {
    position: fixed;
    left: 600px;
    width: 0;
    height: 100%;
    color: white;
    margin-left: -600px;
    overflow-y: auto;
    background: #222;
    -webkit-transition: all 0.5s ease;
    -moz-transition: all 0.5s ease;
    -o-transition: all 0.5s ease;
    transition: all 0.5s ease;
}
#wrapper.toggled #sidebar-wrapper {
    width: 600px;
}
#page-content-wrapper {
    width: 100%;
    position: absolute;
		z-index:0 !important;
    padding-top: 15px;
		padding-left:0px !important;
}
#wrapper.toggled #page-content-wrapper {
    position: absolute;
    margin-right: -600px;
}

    #wrapper {
        padding-left: 600px;
    }
    #wrapper.toggled {
        padding-left: 0 !important;
    }
    #sidebar-wrapper {
        width: 600px;
    }
    #wrapper.toggled #sidebar-wrapper {
        width: 0 !important;
    }
    #page-content-wrapper {
        padding: 20px;
        position: relative;
    }
    #wrapper.toggled #page-content-wrapper {
        position: relative;
        margin-right: 0;
    }
    .drop {
        margin-top: 10px;
    }
		.sdesc{
			margin-bottom:10px;
		}
    .hdesc textarea,
    .sdesc textarea {
        min-width: 100%;
        padding: 10px;
    }
    .step,
    .sDescAdd {
				margin-top:5px;
        color: grey;
        cursor: pointer;
				display:block;
    }

		.sDescAdd:hover{
			color:black;
		}
		.goto{

		}

		.editGoto{
			cursor:pointer;
		}
    .sdesc {
        display: block;
    }
    .hDescAdd {
        cursor: pointer;
    }
    #saveBtn {} .changable {
        padding-left: 10px;
    }
    .changed {
        border-left-style: solid;
        border-width: 3px;
        border-color: #ffc107;
        padding-left: 7px;
    }
    .del {

    }

		.liRes:hover{
			background-color:#fafafa;
		}

		span.glyphicon{
			opacity:0.6;
			cursor:pointer;
			margin-left:3px;

		}

		span.glyphicon:hover{
			opacity:1;
		}

		.delRes:hover{
			color:red;
		}

		.delGoto:hover{
			color:red;
			cursor:pointer;
		}

		.del:hover{
			color:red;
		}
    .ids {
        color: grey;
        font-size: 12px;
    }
    .more {
        margin-left: 15px;
    }
    .resSelected {
        background-color: #d3d3d3;
    }
</style>
<?php
	}

}