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

<?php

Lib::loadClass('RouteBase');
Lib::loadClass('Typespecial');
Lib::loadClass('TypespecialVariable');
Lib::loadClass('Request');
Lib::loadClass('Response');
Lib::loadClass('ProcesHelper');
Lib::loadClass('Route_UrlAction');
Lib::loadClass('UI');
Lib::loadClass('Core_AclHelper');

// TODO: zaliczkaListaView:
// TODO: btn "Dodaj Zaliczkę" $acl->addItem($item); // @require only 'worker' => [ 'id', 'login', 'name' ]
// TODO: lista 10 najnowszych + btn "load more ..."
// TODO: Rozlicz / Podgląd - tylko najnowsza Zaliczka
// TODO: Rozlicz / Podgląd - edytowć może tylko właściciel / grupa / user connected by REF ?
// TODO: create view for printZaliczka to view older rows

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

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

	public function defaultAction() {
		UI::gora();
		UI::emptyTag('link', ['href'=>'static/zaliczka/main.css', 'rel'=>'stylesheet']);
		if (1 != V::get('_print', '', $_GET)) UI::menu();
		try {
			$data = array();
			$data['idUser'] = V::get('idUser', User::getID(), $_REQUEST, 'int');
			$data['idZaliczka'] = V::get('idZaliczka', 0, $_REQUEST, 'int');// TODO: idZaliczka is always MAX(z.ID);

			if (!$data['idZaliczka']) {
				$this->zaliczkaListaView($data);
			} else {
				UI::startContainer();
				UI::tag('a', [
					'href' => "index.php?_route=UrlAction_UserProNetMediaZaliczka&idUser={$data['idUser']}",
					'class' => "btn btn-link"
				], "<i class=\"glyphicon glyphicon-arrow-left\"></i> wróć");
				UI::endContainer();
				$this->zaliczkaFormView($data);
			}
		} catch (Exception $e) {
			UI::alert('danger', "Error #" . $e->getCode() .  "|" . $e->getLine() .  ": " . $e->getMessage());
		}
		if (1 != V::get('_print', '', $_GET)) UI::dol();
	}

	public function syncStataAjaxAction() {
		Response::sendTryCatchJson(array($this, 'syncStataAjaxReponseCallback'), $args = 'JSON_FROM_REQUEST_BODY');// try to read json from request body
	}
	public function syncStataAjaxReponseCallback($args) {
		if (empty($args) || !array_key_exists('updates', $args)) throw new HttpException("Error Parsing Request - missing args", 400);
		$args['idUser'] = V::get('idUser', 0, $_REQUEST, 'int');// (int)$args['idUser'];
		if ($args['idUser'] <= 0) throw new HttpException("Error Parsing Request - missing idUser", 400);
		$args['idZaliczka'] = V::get('idZaliczka', 0, $_REQUEST, 'int');// (int)$args['idZaliczka'];
		if ($args['idZaliczka'] <= 0) throw new HttpException("Error Parsing Request - missing idZaliczka", 400);

		$acl = Core_AclHelper::getAclByNamespace("default_db/ZALICZKA/Zaliczka");
		$schema = $acl->getSimpleSchemaTree();
		if (!empty($args['updates'])) {
			throw new Exception("TODO: F." . __FUNCTION__ . " L." . __LINE__);
		}

		$zaliczkaData = $this->fetchDataBySchema($schema, $args['idUser']);
		return [
			'nierozliczonaKwota' => V::get('nierozliczona_kwota', 0, $zaliczkaData),
			'schema' => [
				'zaliczka' => $schema,
			],
			'zaliczka' => $zaliczkaData,
		];
	}

	public function fetchDataAjaxAction() {
		Response::sendTryCatchJson(array($this, 'fetchDataAjaxReponseCallback'), $args = 'JSON_FROM_REQUEST_BODY');// try to read json from request body
	}
	public function fetchDataAjaxReponseCallback($args) {
		if (empty($args) || empty($args['schema']['@namespace']) || empty($args['schema']['@namespace'])) throw new HttpException("Error Parsing Request - missing @namespace", 400);
		$nsUri = $args['schema']['@namespace'];
		if ('default_db/IN7_DZIENNIK_KORESP' == $nsUri) {
			return [
				'options' => [
					[ 'id' => "65432", 'title' => "testowa koresp 1", 'kategoriaKosztu' => "KOSZT1" ],
					[ 'id' => "10008", 'title' => "testowa koresp 8", 'kategoriaKosztu' => "KOSZT8" ],
					[ 'id' => "10009", 'title' => "testowa koresp 9", 'kategoriaKosztu' => "KOSZT9" ],
				]
			];
		}
		if ('default_db/IN7_MK_BAZA_DYSTRYBUCJI' == $nsUri) {
			return [
				'options' => [
					[ 'id' => 100, 'nrBudowy' => 'Budowa 100/2016' ],
					[ 'id' => 101, 'nrBudowy' => 'Budowa 101/2016' ],
					[ 'id' => 102, 'nrBudowy' => 'Budowa 102/2016' ],
				]
			];
		}
		return null;// msg?
	}

	public function fetchDataBySchema($schema, $idUser, $primaryKey = null) {// if $primaryKey is null then search for last row
		return [// TODO: fetch data from DB
			'id' => 123,
			'created' => '2016-11-22', // data wydania zaliczki - data utworzenia rekordu
			'worker' => [
				'id' => 666,
				'name' => 'Kowalski', // 'TODO' => get name from admin_users - imię i nazwisko pracownika pobierającego zaliczkę
				'login' => 'kowalski'
			],
			'kwota' => 555.55, // kwota wypłaconej zaliczki
			'nierozliczona_kwota' => 123.56,
			'pozycja' => [
				[ 'id' => 1,
					'kwota' => 100.22,
					'korespondencja' => [ 'id' => 65432, 'title' => 'testowa koresp 1', 'kategoriaKosztu' => 'KOSZT1' ],
					'projekt' => [ 'nrBudowy' => 'Budowa/1' ]
				],
				[ 'id' => 2,
					'kwota' => 200.55,
					'korespondencja' => [ 'id' => 76543, 'title' => 'testowa koresp 2', 'kategoriaKosztu' => 'KOSZT2' ],
					'projekt' => [ 'id' => 123, 'nrBudowy' => 'Budowa/2' ]
				]
			]
		];
	}

	public function zaliczkaListaView($data) {
		$idUser = V::get('idUser', User::getID(), $data);

		$acl = Core_AclHelper::getAclByNamespace("default_db/ZALICZKA/Zaliczka");
		$schema = $acl->getSimpleSchemaTree();
		$zaliczkaData = $this->fetchDataBySchema($schema, $idUser);

		UI::startContainer();
		UI::setTitle("Zaliczka");

		UI::startTag('form', ['action'=>'', 'method'=>'POST']);
			UI::emptyTag('input', ['type'=>"hidden", 'name'=>'_route', 'value'=>"UrlAction_UserProNetMediaZaliczka"]);
			UI::emptyTag('input', ['type'=>"hidden", 'name'=>'_task', 'value'=>"add"]);
			UI::emptyTag('input', ['type'=>"hidden", 'name'=>'idUser', 'value'=>$idUser]);
			UI::emptyTag('input', ['type'=>"submit", 'value'=>"Dodaj nową zaliczkę", 'class'=>'btn btn-primary']);
		UI::endTag('form');

		UI::table([
			'caption' => "Zaliczki:",
			'rows' => array_map(
				function ($row) use ($idUser) {
					static $isFirst = true;
					$editLink = Request::getPathUri() . "index.php?_route=UrlAction_UserProNetMediaZaliczka&idUser={$idUser}&idZaliczka={$row['ID']}";
					$editLabel = ($isFirst) ? "Rozlicz / Podgląd" : "Podgląd";
					if ($isFirst) $isFirst = false;
					$histLink = Request::getPathUri() . "index.php?_route=UrlAction_UserProNetMediaZaliczka&_task=hist&idUser={$idUser}&idZaliczka={$row['ID']}";
					return [
						'Nr' => $row['ID'],
						'Status' => $row['A_STATUS'],
						'INSTANCE' => DB::getPDO()->fetchValue("select INSTANCE_NAME from `ZALICZKA__#INSTANCE` where PRIMARY_KEY = {$row['ID']}"),
						'L_APPOITMENT_USER' => $row['L_APPOITMENT_USER'],
						'KWOTA' => $row['KWOTA'],
						'NIEROZLICZONA_KWOTA' => $row['NIEROZLICZONA_KWOTA'],
						'#' => '<a href="' . $editLink . '">' . $editLabel . '</a>',
						'DBG' => '<a href="' . $histLink . '">' . "DBG HIST" . '</a>'
					];
				},
				DB::getPDO()->fetchAll("
					select z.*
					from ZALICZKA z
						join ADMIN_USERS u on(z.L_APPOITMENT_USER = u.ADM_ACCOUNT and u.ID = {$idUser})
					order by z.ID DESC
				")
			),
			'empty_msg' => "Brak",
			'disable_lp' => true,
		]);
		UI::alert('danger', "TODO: pierwsza na liście - aktualna - btn(Rozlicz)");// -> Edycja zaliczki

		UI::endContainer();
	}

	public function addAction() {
		$idUser = V::get('idUser', User::getID(), $_REQUEST);
		try {
			$acl = Core_AclHelper::getAclByNamespace("default_db/ZALICZKA/Zaliczka");
			$id = $acl->addItem([
				'worker' => [
					'id' => $idUser
				]
			]);
			if (!$id) throw new Exception("Nie udało się utworzyć zaliczki");

		} catch (Exception $e) {
			UI::gora();
			// UI::menu();// TODO: show menu
			UI::startContainer();
				UI::alert('danger', $e->getMessage());
			UI::endContainer();
			UI::dol();
			exit;
		}

		$redirectUrl = Request::getPathUri() . "index.php?_route=UrlAction_UserProNetMediaZaliczka&idUser={$idUser}&idZaliczka={$id}";
		if (!headers_sent()) {
			header("Location: {$redirectUrl}");
		} else {
			echo'<script type="text/javascript">'."
window.location.href='{$redirectUrl}';
			".'</script>';
			echo "\n".'<noscript>';
			echo "\n".'<meta http-equiv="refresh" content="0;url='.$redirectUrl.'" />';
			echo "\n".'</noscript>';
			echo'<p>'.'<a href="'.$redirectUrl.'">'."dalej".'</a>'.'</p>';
		}
	}

	public function reinstallAction() {
		UI::gora();
		try {
			Core_AclHelper::getAclByNamespace("default_db/ZALICZKA/Zaliczka")->reinstall();
			UI::startContainer();
			UI::alert('success', "Structure for 'default_db/ZALICZKA/Zaliczka' created in a database");
			$backUrl = Request::getPathUri() . "index.php?_route=UrlAction_UserProNetMediaZaliczka";
			UI::tag('a', ['href'=>$backUrl, 'class'=>"btn btn-primary"], "wróć");

			UI::table([
				'caption' => "Zaliczka",
				'rows' => DB::getPDO()->fetchAll("
					select t.TABLE_NAME, t.COLUMN_NAME, t.DATA_TYPE, t.COLUMN_TYPE
					from `information_schema`.`COLUMNS` t
					where t.TABLE_SCHEMA = 'SES_USERS2'
						and (t.TABLE_NAME like 'ZALICZKA'
							or t.TABLE_NAME like 'ZALICZKA\_\_%'
							or t.TABLE_NAME like 'ZALICZKA_HIST'
							or t.TABLE_NAME like 'Zaliczka\_\_%'
						)
					order by t.TABLE_NAME asc, t.COLUMN_NAME asc
				")
			]);

			UI::table([
				'caption' => "Zaliczka Pozycja",
				'rows' => DB::getPDO()->fetchAll("
					select t.TABLE_NAME, t.COLUMN_NAME, t.DATA_TYPE, t.COLUMN_TYPE
					from `information_schema`.`COLUMNS` t
					where t.TABLE_SCHEMA = 'SES_USERS2'
						and (t.TABLE_NAME like 'ZALICZKA_POZYCJA'
							or t.TABLE_NAME like 'ZALICZKA_POZYCJA\_\_%'
							or t.TABLE_NAME like 'ZALICZKA_POZYCJA_HIST'
							or t.TABLE_NAME like 'ZaliczkaPozycja\_\_%'
						)
					order by t.TABLE_NAME asc, t.COLUMN_NAME asc
				")
			]);

			$tableList = array_map(
				function($item) {
					return $item['TABLE_NAME'];
				}
				, DB::getPDO()->fetchAll("
						select t.TABLE_NAME
						from `information_schema`.`COLUMNS` t
						where t.TABLE_SCHEMA = 'SES_USERS2'
							and (t.TABLE_NAME like 'ZALICZKA'
								or t.TABLE_NAME like 'ZALICZKA\_\_%'
								or t.TABLE_NAME like 'ZALICZKA_HIST'
								or t.TABLE_NAME like 'Zaliczka\_\_%'
								or t.TABLE_NAME like 'ZALICZKA_POZYCJA'
								or t.TABLE_NAME like 'ZALICZKA_POZYCJA\_\_%'
								or t.TABLE_NAME like 'ZALICZKA_POZYCJA_HIST'
								or t.TABLE_NAME like 'ZaliczkaPozycja\_\_%'
							)
						group by t.TABLE_NAME
					")
			);
			foreach ($tableList as $tableName) {
				UI::startTag('div', ['style'=>"margin:10px 0; max-width:100%; overflow:scroll; border:1px solid #ccc"]);
				UI::table([
					'caption' => "Tabela '{$tableName}'",
					'rows' => DB::getPDO()->fetchAll("
						select t.*
						from `{$tableName}` t
					")
				]);
				UI::endTag('div');
			}

			if ('1' == V::get('_clear', '', $_GET)) {
				foreach ($tableList as $tableName) {
					DB::getPDO()->exec("TRUNCATE `{$tableName}`");
				}
				UI::tag('a', ['class'=>"btn btn-primary", 'href'=>"index.php?_route=UrlAction_UserProNetMediaZaliczka&_task=reinstall"], "Dane usunięte - odśwież stronę");
			} else {
				UI::tag('a', ['class'=>"btn btn-danger", 'href'=>"index.php?_route=UrlAction_UserProNetMediaZaliczka&_task=reinstall&_clear=1"], "Wyczyść tabele");
			}

			UI::startTag('pre');
			foreach ($tableList as $tableName) {
				echo "DROP TABLE `{$tableName}`;\n";
			}
			UI::endTag('pre');

			UI::endContainer();
		} catch (Exception $e) {
			UI::alert('danger', $e->getMessage());
		}
		UI::dol();
	}

	public function zaliczkaFormView($data) {
		$idUser = V::get('idUser', User::getID(), $data);
		$idZaliczka = V::get('idZaliczka', 0, $data);

		UI::tag('div', ['id'=>"zaliczka-app", 'data-dbg'=>V::get('DBG', '', $_GET), 'data-sync-js-function'=>"syncZaliczkaState", 'data-fetch-data-js-function'=>"zaliczkaFetchData"]);
		UI::emptyTag('br');

		$acl = Core_AclHelper::getAclByNamespace("default_db/ZALICZKA/Zaliczka");
		$schema = $acl->getSimpleSchemaTree();
		$zaliczkaData = $this->fetchDataBySchema($schema, $idUser);

		DBG::nicePrint($zaliczkaData, '$zaliczkaData');// TODO: DBG

		UI::inlineJS(__FILE__ . '.fetchData.js', [
			'_initData' => $initData,
			'syncUrl' => Request::getPathUri() . "index.php?_route=UrlAction_UserProNetMediaZaliczka&_task=fetchDataAjax&idUser={$idUser}&idZaliczka={$idZaliczka}"
		]);
		UI::inlineJS(__FILE__ . '.syncState.js', [
			'_initData' => $initData,
			'syncUrl' => Request::getPathUri() . "index.php?_route=UrlAction_UserProNetMediaZaliczka&_task=syncStataAjax&idUser={$idUser}&idZaliczka={$idZaliczka}"
		]);
		UI::tag('script', ['src'=>'static/vendor.js' . (V::get('DBG', '', $_GET) ? '?_ts=' . time() : ''), 'type'=>'text/javascript']);
		UI::tag('script', ['src'=>'static/zaliczka/main.js' . (V::get('DBG', '', $_GET) ? '?_ts=' . time() : ''), 'type'=>'text/javascript']);
	}

}

/*    Akcje

# dodanie pierwszej zaliczki - 500 zł
$data = [ worker => [ login => 'Kowalski' ], kwota => 500.00 ]
insert into `ZALICZKA` (`L_APPOITMENT_USER`, `KWOTA`) values('{$data['worker']['login']}', '{$data['kwota']}');
-- return id = 123

# rozliczenie częściowe pierwszej zaliczki np. 500 zł
$data = [ id => 123, pozycja => [ [ kwota => 200.00, korespondencja => [ ... ], projekt => [ ... ] ] ] ]
update `ZALICZKA__#REF__POZYCJA` set `A_STATUS` = 'DELETED' where `PRIMARY_KEY` = 123;


*/