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

<?php

Lib::loadClass('RouteBase');
Lib::loadClass('TypespecialVariable');
Lib::loadClass('Request');
Lib::loadClass('Response');
Lib::loadClass('UI');

// - [ ] TODO: widoki zamówień wg statusu - ustalić dostępy za pomocą procesów
// - [x] Typepsecial do Koresp.ORDER_NR
/*
DBG:
	&DBG_M_DIST_COST_PROJECT=10000
	&DBG_KONIEC_BUDOWY=2016-08-01

*/
class Route_UrlAction_ProjektyProNetMediaBudget extends RouteBase {// TODO: UrlActionBase @see Route_UrlAction

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

/*

Kwota planowana:	`M_DIST_COST_PROJECT` Budżet projektu
Zamówienie:				sumy z CRM_LISTA_ZASOBOW_ORDERS (CRM_LISTA_ZASOBOW_OFFERS)
zaliczki
ilość pracowników / koszty pracownicze: powiązanie z raportami X współczynnik
koszty sprzętu/ wynajmowany na budowie: rozdział na różne rodzaj sprzętu: koparka itp.
koszty własne: naprawy sprzętu
koszty materiałów
osprzet
dodatkowe koszty związane z nadwyżkami - rozbieżności odnośnie ustaleń

dostęp dla zarządu i os. odp.	kwota końcowa

*/

	public function defaultAction() {
		SE_Layout::gora();
		try {
			$viewParams = array();
			$viewParams['print_mode'] = (1 == V::get('_print', '', $_GET));
			if (!$viewParams['print_mode']) SE_Layout::menu();

			$data = array();
			$data['id_project'] = V::get('ID_PROJECT', 0, $_REQUEST, 'int');
			if (!$data['id_project']) throw new Exception("Error: Brak nr projektu!");
			$data = $this->setProps($data);

			$this->budgetView($data, $viewParams);
		} catch (Exception $e) {
			SE_Layout::alert('danger', "Error #" . $e->getCode() .  "|" . $e->getLine() .  ": " . $e->getMessage());
		}
		SE_Layout::dol();
	}

	public function setProps($data) {
		$idProj = V::get('id_project', 0, $data, 'int');
		if (!$idProj) return $data;// throw errro?
		$data['budget'] = 0;
		$data['projectInfo'] = null;
		$data['projectLabel'] = '';
		$data['costs'] = array();

		$rows = DB::getPDO()->fetchAll("
			select p.ID
					, p.M_DIST_DESC
					, p.M_DIST_DEALNUM
					, p.M_DIST_COST_PROJECT
					, p.POCZATEK_UMOWY
					, p.KONIEC_BUDOWY
					, p.COST_OSPRZET
					, p.COST_MATERIALY
			from IN7_MK_BAZA_DYSTRYBUCJI p
			where p.A_STATUS not in('DELETED')
				and p.ID = {$idProj}
		");
		if (empty($rows)) return $data;// throw errro?
		$data['projectInfo'] = $rows[0];
		$data['budget'] = V::get('M_DIST_COST_PROJECT', 0, $data['projectInfo']);
		$data['projectLabel'] = $data['projectInfo']['M_DIST_DESC'];
		$data['POCZATEK_UMOWY'] = V::get('POCZATEK_UMOWY', '', $data['projectInfo']);
		$data['KONIEC_BUDOWY'] = V::get('KONIEC_BUDOWY', '', $data['projectInfo']);
		$data['days_to_finish'] = null; // pozostało dni - // ilość dni wyliczana z różnicy dat [13513] KONIEC_BUDOWY - [13512] POCZATEK_UMOWY (raczej today)
		$data['budget'] = V::get('DBG_M_DIST_COST_PROJECT', $data['budget'], $_GET);// TODO: TEST
		$data['KONIEC_BUDOWY'] = V::get('DBG_KONIEC_BUDOWY', $data['KONIEC_BUDOWY'], $_GET);// TODO: TEST
		if ($data['KONIEC_BUDOWY']) {
			$dStart = new DateTime(date('Y-m-d'));
			$dEnd = new DateTime($data['KONIEC_BUDOWY']);
			$dDiff = $dStart->diff($dEnd);
			$data['days_to_finish'] = ('-' == $dDiff->format('%R')) ? -1 * $dDiff->days : $dDiff->days;
		}
		$data['COST_OSPRZET'] = V::get('COST_OSPRZET', 0, $data['projectInfo']);
		$data['COST_MATERIALY'] = V::get('COST_MATERIALY', 0, $data['projectInfo']);

		// TODO: tylko ZATWIERDZONE, OCZEKUJE_ZATWIERDZENIA i OCZEKUJE_OSTATECZNEGO_ZATWIERDZENIA
		$data['ordersRaw'] = DB::getPDO()->fetchAll("
			select r.ID
					, r.ORDER_LABEL
					, r.ORDER_DATE
					, r.APPROVE_STATUS
					, sum(o.OFFER_PRICE_PER_UNIT * o.OFFER_QUANTITY) as SUM_NETTO
			from CRM_LISTA_ZASOBOW_ORDERS r
				left join CRM_LISTA_ZASOBOW_OFFERS o on(
					o.ID_ORDER = r.ID
					and (o.A_STATUS is null or o.A_STATUS not in('DELETED'))
				)
			where (r.A_STATUS is null or r.A_STATUS not in('DELETED'))
				and r.ID_PROJECT = {$idProj}
		--		and r.APPROVE_STATUS in('ZATWIERDZONE', 'OCZEKUJE_ZATWIERDZENIA', 'OCZEKUJE_OSTATECZNEGO_ZATWIERDZENIA')
			group by r.ID
		");

		$toFindKoresp = array();// Order.ID => Order.label
		{
			$idx = 0;
			foreach ($data['ordersRaw'] as $idxOrders => $order) {
				$idOrder = $order['ID'];
				$labelOrder = $order['ORDER_LABEL'];
				$toFindKoresp[$idOrder] = $labelOrder;
				if (count($data['costs']) < $idxOrders + 1) {
					$data['costs'][] = array(
						'_type'=>'order',
						'data'=>$order['ORDER_DATE'],
						'order_approve_status'=>$order['APPROVE_STATUS'],
						'order_cost'=>$order['SUM_NETTO'],
						'order_nr'=>$labelOrder,
						'nr_fv_do_zamowienia'=>array(),
						'sum'=>$order['SUM_NETTO'],
						'orderRaw'=>$order
					);
				}
			}
			if (!empty($toFindKoresp)) {// TODO: find fv nr - from Koresp. (nr_fv_do_zamowienia) - Koresp.ORDER_NR
				$sqlOrderLabels = array();
				foreach ($toFindKoresp as $idOrder => $labelOrder) {
					$sqlOrderLabels[] = "'{$labelOrder}'";
				}
				$sqlOrderLabels = implode(",", $sqlOrderLabels);
				// TODO: tylko określone typy z Koresp?
				// TODO: co jeśli brakuje obcy_nr_koresp(`K_NR_OTRZYM_KORESP`) - ID?
				$data['fvToOrdersRaw'] = DB::getPDO()->fetchAll("
					select k.ID
								, k.ORDER_NR
								, k.K_NR_OTRZYM_KORESP as obcy_nr_koresp
								, k.COST_VALUE as cost
					from IN7_DZIENNIK_KORESP k
					where k.ORDER_NR in({$sqlOrderLabels})
				");
				foreach ($data['fvToOrdersRaw'] as $fv) {
					$labelOrder = $fv['ORDER_NR'];
					foreach ($data['costs'] as $cost) {
						if ($isOrder && $labelOrder == $cost['order_nr']) {
							$idKoresp = $fv['ID'];
							// $cost['nr_fv_do_zamowienia'][$idKoresp] = $fv['obcy_nr_koresp'];
							$cost['nr_fv_do_zamowienia'][] = array('id'=>$idKoresp, 'nr'=>$fv['obcy_nr_koresp'], 'cost'=>$fv['cost']);
						}
					}
				}
			}

			{// PROJECT_COSTS
				$data['projectCostsRaw'] = DB::getPDO()->fetchAll("
					select c.ID
							, c.ID_PROJECT
							, c.COST_DATE
							, c.COST_VALUE
							, c.COST_TYPE
					from PROJECT_COSTS c
					where (c.A_STATUS is null or c.A_STATUS not in('DELETED'))
						and c.ID_PROJECT = {$idProj}
					order by c.COST_DATE ASC, c.ID ASC
				");
				foreach ($data['projectCostsRaw'] as $projCost) {
					$item = array(
						'_type'=>'project_cost',
						'data'=>$projCost['COST_DATE'],
						'sum'=>$projCost['COST_VALUE'],
						'costRaw'=>$projCost
					);
					switch ($projCost['COST_TYPE']) {
						case 'ANEKS': $item['budget_aneks'] = (float)$projCost['COST_VALUE']; break;
						case 'KARY': $item['budget_kary'] = (float)$projCost['COST_VALUE']; break;
						case 'OSPRZET': $item['budget_osprzet'] = (float)$projCost['COST_VALUE']; break;
						case 'MATERIALY': $item['budget_materialy'] = (float)$projCost['COST_VALUE']; break;
						case 'PRACOWNICY': $item['budget_koszt_pracownikow'] = (float)$projCost['COST_VALUE']; break;
						case 'PODWYKONAWCY': $item['budget_koszt_podwykonawcow'] = (float)$projCost['COST_VALUE']; break;
						case 'REPREZENTACYJNE': $item['budget_koszt_reprezentacyjny'] = (float)$projCost['COST_VALUE']; break;
						case 'ZALICZKA_KWOTA': $item['budget_zaliczki'] = (float)$projCost['COST_VALUE']; break;
						case 'ZALICZKA_KOSZTY_DZIENNE': $item['budget_rozliczone_zaliczki'] = (float)$projCost['COST_VALUE']; break;
						case 'ZGODY_SLUZEBNOSCI': $item['budget_zgoda_sluzebnosci'] = (float)$projCost['COST_VALUE']; break;
						case 'ZGODY_ODSZKODOWANIA': $item['budget_zgoda_odszkodowania'] = (float)$projCost['COST_VALUE']; break;
						case 'SPRZET_WLASNY': $item['budget_sprzet_wlasny'] = (float)$projCost['COST_VALUE']; break;
						case 'SPRZET_WYNAJETY': $item['budget_sprzet_wynajety'] = (float)$projCost['COST_VALUE']; break;
						case 'ORGANIZACJA_RUCHU': $item['budget_organizacja_ruchu'] = (float)$projCost['COST_VALUE']; break;
						case 'ZAJETOSC_PASA': $item['budget_zajetosc_pasa'] = (float)$projCost['COST_VALUE']; break;
					}
					$data['costs'][] = $item;
				}
			}

			// order $data['costs'] by `data`, then by `ID` for the same `_type` else: order, project_cost, koresp
			usort($data['costs'], function($a, $b) {
				if ($a['data'] == $b['data']) {
					if ($a['_type'] == $b['_type']) {
						if ('project_cost' == $a['_type']) {
							return ($a['costRaw']['ID'] < $b['costRaw']['ID']) ? -1 : 1;
						}
						if ('order' == $a['_type']) {
							return ($a['orderRaw']['ID'] < $b['orderRaw']['ID']) ? -1 : 1;
						}
						return 0;
					}
					$oa = 999; $ob = 999;
					if ('order' == $a['_type']) $oa = 1;
					else if ('project_cost' == $a['_type']) $oa = 2;
					if ('order' == $b['_type']) $ob = 1;
					else if ('project_cost' == $b['_type']) $ob = 2;
					return ($oa < $ob) ? -1 : 1;
				}
				return ($a['data'] < $b['data']) ? -1 : 1;
			});

			$budget = $data['budget'];
			foreach ($data['costs'] as $idx => $cost) {
				// TODO: fix - `cost_wynajem` pewnie będzie częścią z zamówienia - minus od project COST_OSPRZET
				// TODO: fix - `cost_materialy` pewnie będzie częścią z zamówienia - minus od project COST_MATERIALY
				// TODO: cost_wynajem i cost_materialy - edit in this table - cost may be verified by fv, etc.
				$sum = $cost['sum'];
				$budget -= $sum;
				$data['costs'][$idx]['budget_minus_sum'] = $budget;
			}
		}
		return $data;
	}

	public function budgetView($data, $viewParams) {
		$styleZyskStrata = 'color: black';
		if ($data['TODO__sum_zysk_strata'] > 0) $styleZyskStrata = 'color:green';
		if ($data['TODO__sum_zysk_strata'] < 0) $styleZyskStrata = 'color:red';
		$costs = $data['costs'];
		?>
<div class="container">
	<div class="row">
		<div class="col-md-6">
			<?php if (!$viewParams['print_mode']) : ?>
				<a class="btn btn-primary"
					 href="index.php?_route=UrlAction_ProjektyProNetMediaBudget&ID_PROJECT=<?php echo $data['id_project']; ?>&_print=1"
					 target="_blank">drukuj</a>
			<?php endif; ?>
		</div>
		<div class="col-md-6" style="text-align:right">
			<?php echo date("Y-m-d"); ?>
		</div>
	</div>
	<h3>Projekt: <?php echo $data['projectLabel']; ?></h3>
	<table class="table table-bordered">
		<thead>
			<tr>
				<td rowspan="5" colspan="1" style="width:80px; text-align:center; vertical-align:middle">data</td>
				<td rowspan="1" colspan="5" style="padding:0">
					<table class="table table-bordered" style="width:100%; margin:0; border:0">
						<tr>
							<td rowspan="1" colspan="1" style="text-align:center; vertical-align:middle; border-top:0; border-left:0">data rozpoczęcia umowy</td>
							<td rowspan="1" colspan="1" style="text-align:center; vertical-align:middle; border-top:0">data zakończenia umowy</td>
							<td rowspan="1" colspan="1" style="text-align:center; vertical-align:middle; border-top:0">pozostało dni:</td>
							<td rowspan="2" colspan="1" style="text-align:center; vertical-align:middle; border-top:0; border-right:0; border-bottom:0">Wartość kosztorysu</td>
						</tr>
						<tr>
							<td rowspan="1" colspan="1" style="text-align:center; vertical-align:middle; border-bottom:0; border-left:0"><?php echo $data['POCZATEK_UMOWY']; ?></td>
							<td rowspan="1" colspan="1" style="text-align:center; vertical-align:middle; border-bottom:0"><?php echo $data['KONIEC_BUDOWY']; ?></td>
							<td rowspan="1" colspan="1" style="text-align:center; vertical-align:middle; border-bottom:0"><?php echo $data['days_to_finish']; ?></td>
						</tr>
					</table>
				</td>
				<td rowspan="2" colspan="2" style="text-align:center; vertical-align:middle">ROBOCIZNA</td>
				<td rowspan="4" colspan="1" style="text-align:center; vertical-align:middle; border-bottom:none">Koszty dodatkowe (reprezentacyjne)</td>
				<td rowspan="3" colspan="2" style="text-align:center; vertical-align:middle">Zamówienia</td>
				<td rowspan="3" colspan="2" style="text-align:center; vertical-align:middle">Zaliczki</td>
				<td rowspan="3" colspan="2" style="text-align:center; vertical-align:middle">Zgody wejścia w teren</td>
				<td rowspan="3" colspan="2" style="text-align:center; vertical-align:middle">Wynajem sprzętu</td>
				<td rowspan="3" colspan="2" style="text-align:center; vertical-align:middle">Koszty projektu</td>
			</tr>
			<tr>
				<td rowspan="1" colspan="1" style="text-align:center; vertical-align:middle">Kwota Umowy (netto)</td>
				<td rowspan="1" colspan="1" style="text-align:center; vertical-align:middle">Aneks (netto)</td>
				<td rowspan="1" colspan="1" style="text-align:center; vertical-align:middle">kary, potrącenia (netto)</td>
				<td rowspan="1" colspan="1" style="text-align:center; vertical-align:middle">Osprzęt</td>
				<td rowspan="1" colspan="1" style="text-align:center; vertical-align:middle">Materiały</td>
			</tr>
			<tr>
				<th rowspan="2" colspan="1" style="text-align:center; vertical-align:middle; white-space:nowrap; border-bottom:none"><?php echo UI::price($data['budget']); ?><br><span id="p5Budget__zysk_strata" style="font-size:11px; font-weight:normal; white-space:nowrap"></span></th>
				<th rowspan="2" colspan="1" style="text-align:center; vertical-align:middle; white-space:nowrap; border-bottom:none" id="p5Budget__aneks"></th>
				<th rowspan="2" colspan="1" style="text-align:center; vertical-align:middle; white-space:nowrap; border-bottom:none" id="p5Budget__kary"></th>
				<th rowspan="2" colspan="1" style="text-align:center; vertical-align:middle; white-space:nowrap; border-bottom:none"><?php echo UI::price($data['COST_OSPRZET']); ?><br><span id="p5Budget__osprzet_zysk_strata" style="font-size:11px; font-weight:normal; white-space:nowrap"></span></th>
				<th rowspan="2" colspan="1" style="text-align:center; vertical-align:middle; white-space:nowrap; border-bottom:none"><?php echo UI::price($data['COST_MATERIALY']); ?><br><span id="p5Budget__materialy_zysk_strata" style="font-size:11px; font-weight:normal; white-space:nowrap"></span></th>
				<td rowspan="2" colspan="1" style="text-align:center; vertical-align:middle; border-bottom:none">koszty pracowników</td>
				<td rowspan="2" colspan="1" style="text-align:center; vertical-align:middle; border-bottom:none">koszt firmy podwykonawczej</td>
			</tr>
			<tr>
				<!-- <td rowspan="2" colspan="1" style="text-align:center; vertical-align:middle; white-space:nowrap; <?php echo $styleZyskStrata; ?>"><?php echo UI::price($data['TODO__sum_zysk_strata']); ?></td> -->
				<td rowspan="2" colspan="1" style="text-align:center; vertical-align:middle">numer zamówienia (kwota netto)</td>
				<td rowspan="2" colspan="1" style="text-align:center; vertical-align:middle">numer faktury kwota po weryfikacji</td>
				<td rowspan="1" colspan="1" style="text-align:center; vertical-align:middle; border-bottom:none">zaliczka kwota</td>
				<td rowspan="1" colspan="1" style="text-align:center; vertical-align:middle; border-bottom:none">rozliczanie zaliczki koszty dzienne</td>
				<td rowspan="1" colspan="1" style="text-align:center; vertical-align:middle; border-bottom:none">służebności</td>
				<td rowspan="1" colspan="1" style="text-align:center; vertical-align:middle; border-bottom:none">odszkodowania</td>
				<td rowspan="1" colspan="1" style="text-align:center; vertical-align:middle; border-bottom:none">Sprzęt własny</td>
				<td rowspan="1" colspan="1" style="text-align:center; vertical-align:middle; border-bottom:none">Sprzęt wynajęty</td>
				<td rowspan="1" colspan="1" style="text-align:center; vertical-align:middle; border-bottom:none">organizacja ruchu</td>
				<td rowspan="1" colspan="1" style="text-align:center; vertical-align:middle; border-bottom:none">zajętość pasa drogowego</td>
			</tr>
			<tr>
				<td rowspan="1" colspan="1" style="padding:0; text-align:center; vertical-align:middle; border-top:none"></td>
				<td rowspan="1" colspan="1" style="padding:0; text-align:center; vertical-align:middle; border-top:none"><button onClick="return p5UI__Clickable(this, 'p5:Budget:addCost', {type: 'ANEKS'})" class="btn btn-link" style="padding:0"><i class="glyphicon glyphicon-plus-sign"></i></button></td>
				<td rowspan="1" colspan="1" style="padding:0; text-align:center; vertical-align:middle; border-top:none"><button onClick="return p5UI__Clickable(this, 'p5:Budget:addCost', {type: 'KARY'})" class="btn btn-link" style="padding:0"><i class="glyphicon glyphicon-plus-sign"></i></button></td>
				<td rowspan="1" colspan="1" style="padding:0; text-align:center; vertical-align:middle; border-top:none"><button onClick="return p5UI__Clickable(this, 'p5:Budget:addCost', {type: 'OSPRZET'})" class="btn btn-link" style="padding:0"><i class="glyphicon glyphicon-plus-sign"></i></button></td>
				<td rowspan="1" colspan="1" style="padding:0; text-align:center; vertical-align:middle; border-top:none"><button onClick="return p5UI__Clickable(this, 'p5:Budget:addCost', {type: 'MATERIALY'})" class="btn btn-link" style="padding:0"><i class="glyphicon glyphicon-plus-sign"></i></button></td>
				<td rowspan="1" colspan="1" style="padding:0; text-align:center; vertical-align:middle; border-top:none"><button onClick="return p5UI__Clickable(this, 'p5:Budget:addCost', {type: 'PRACOWNICY'})" class="btn btn-link" style="padding:0"><i class="glyphicon glyphicon-plus-sign"></i></button></td>
				<td rowspan="1" colspan="1" style="padding:0; text-align:center; vertical-align:middle; border-top:none"><button onClick="return p5UI__Clickable(this, 'p5:Budget:addCost', {type: 'PODWYKONAWCY'})" class="btn btn-link" style="padding:0"><i class="glyphicon glyphicon-plus-sign"></i></button></td>
				<td rowspan="1" colspan="1" style="padding:0; text-align:center; vertical-align:middle; border-top:none"><button onClick="return p5UI__Clickable(this, 'p5:Budget:addCost', {type: 'REPREZENTACYJNE'})" class="btn btn-link" style="padding:0"><i class="glyphicon glyphicon-plus-sign"></i></button></td>
				<td rowspan="1" colspan="1" style="padding:0; text-align:center; vertical-align:middle; border-top:none"><button onClick="return p5UI__Clickable(this, 'p5:Budget:addCost', {type: 'ZALICZKA_KWOTA'})" class="btn btn-link" style="padding:0"><i class="glyphicon glyphicon-plus-sign"></i></button></td>
				<td rowspan="1" colspan="1" style="padding:0; text-align:center; vertical-align:middle; border-top:none"><button onClick="return p5UI__Clickable(this, 'p5:Budget:addCost', {type: 'ZALICZKA_KOSZTY_DZIENNE'})" class="btn btn-link" style="padding:0"><i class="glyphicon glyphicon-plus-sign"></i></button></td>
				<td rowspan="1" colspan="1" style="padding:0; text-align:center; vertical-align:middle; border-top:none"><button onClick="return p5UI__Clickable(this, 'p5:Budget:addCost', {type: 'ZGODY_SLUZEBNOSCI'})" class="btn btn-link" style="padding:0"><i class="glyphicon glyphicon-plus-sign"></i></button></td>
				<td rowspan="1" colspan="1" style="padding:0; text-align:center; vertical-align:middle; border-top:none"><button onClick="return p5UI__Clickable(this, 'p5:Budget:addCost', {type: 'ZGODY_ODSZKODOWANIA'})" class="btn btn-link" style="padding:0"><i class="glyphicon glyphicon-plus-sign"></i></button></td>
				<td rowspan="1" colspan="1" style="padding:0; text-align:center; vertical-align:middle; border-top:none"><button onClick="return p5UI__Clickable(this, 'p5:Budget:addCost', {type: 'SPRZET_WLASNY'})" class="btn btn-link" style="padding:0"><i class="glyphicon glyphicon-plus-sign"></i></button></td>
				<td rowspan="1" colspan="1" style="padding:0; text-align:center; vertical-align:middle; border-top:none"><button onClick="return p5UI__Clickable(this, 'p5:Budget:addCost', {type: 'SPRZET_WYNAJETY'})" class="btn btn-link" style="padding:0"><i class="glyphicon glyphicon-plus-sign"></i></button></td>
				<td rowspan="1" colspan="1" style="padding:0; text-align:center; vertical-align:middle; border-top:none"><button onClick="return p5UI__Clickable(this, 'p5:Budget:addCost', {type: 'ORGANIZACJA_RUCHU'})" class="btn btn-link" style="padding:0"><i class="glyphicon glyphicon-plus-sign"></i></button></td>
				<td rowspan="1" colspan="1" style="padding:0; text-align:center; vertical-align:middle; border-top:none"><button onClick="return p5UI__Clickable(this, 'p5:Budget:addCost', {type: 'ZAJETOSC_PASA'})" class="btn btn-link" style="padding:0"><i class="glyphicon glyphicon-plus-sign"></i></button></td>
			</tr>
		</thead>
		<tbody id="p5Budget__costs"></tbody>
	</table>
</div>
<link rel="stylesheet" href="static/sweetalert2.min.css" type="text/css">
<script src="static/sweetalert2.min.js"></script>
<script>
(function(){
	var _saveLink = '<?php echo Request::getPathUri(); ?>index.php?_route=UrlAction_ProjektyProNetMediaBudget&_task=addCostAjax&ID_PROJECT=<?php echo $data['id_project']; ?>';
	var _dbg = <?php echo V::get('DBG', 0, $_REQUEST, 'int'); ?>;
	var _initCosts = <?php echo json_encode($costs); ?>;
	var _initBudgetValue = <?php echo ($data['budget']) ? $data['budget'] : 0; ?>;
	var _initOsprzetValue = <?php echo ($data['COST_OSPRZET']) ? $data['COST_OSPRZET'] : 0; ?>;
	var _initMaterialyValue = <?php echo ($data['COST_MATERIALY']) ? $data['COST_MATERIALY'] : 0; ?>;

	if (_initCosts) {
		budget__renderCosts(_initCosts);
	}

	function budget__renderCosts(costs) {
		var _tbody = document.getElementById('p5Budget__costs');
		if (!_tbody) throw "Missing node #p5Budget__costs";
		if(_dbg)console.log('render costs: ', costs);

		function budget__renderNodePrice(idNode, value) {
			var node = document.getElementById(idNode);
			p5Utils__clearNode(node);
			if (value != 0) node.appendChild(document.createTextNode(p5Utils__pricePrintPL(value)));
			else node.appendChild(document.createTextNode('0,00'));
		}
		function budget__renderZyskStrataPrice(idNode, value) {
			var node = document.getElementById(idNode);
			if(_dbg)console.log('budget__renderZyskStrataPrice('+idNode+') value: ', value, 'node', node);
			var sign = '';
			if (value > 0) {
				sign = '+';
				node.style.color = '#009600';
			} else {
				sign = '';
				node.style.color = '#f00';
			}
			p5Utils__clearNode(node);
			node.appendChild(document.createTextNode(sign + '' + p5Utils__pricePrintPL(value)));
		}
		{
			var budgetZyskStrata = costs.reduce(function (prevValue, currCost) {
				return currCost['budget_minus_sum'];// get last value - calculated in php
			}, _initBudgetValue);
			budget__renderZyskStrataPrice('p5Budget__zysk_strata', budgetZyskStrata);
		}
		{
			var osprzetZyskStrata = _initOsprzetValue - costs.reduce(function (prevValue, currCost) {
				if (!currCost['budget_osprzet']) return prevValue;
				return prevValue + currCost['budget_osprzet'];
			}, 0);
			if(_dbg)console.log('osprzetZyskStrata: _initOsprzetValue', _initOsprzetValue, 'osprzetZyskStrata', osprzetZyskStrata);
			budget__renderZyskStrataPrice('p5Budget__osprzet_zysk_strata', osprzetZyskStrata);
		}
		{
			var materialyZyskStrata = _initMaterialyValue - costs.reduce(function (prevValue, currCost) {
				if (!currCost['budget_materialy']) return prevValue;
				return prevValue + currCost['budget_materialy'];
			}, 0);
			if(_dbg)console.log('materialyZyskStrata: _initMaterialyValue', _initMaterialyValue, 'materialyZyskStrata', materialyZyskStrata);
			budget__renderZyskStrataPrice('p5Budget__materialy_zysk_strata', materialyZyskStrata);
		}

		{
			var aneksValue = costs.reduce(function (prevValue, currCost) {
				if (!currCost['budget_aneks']) return prevValue;
				return prevValue + currCost['budget_aneks'];
			}, 0);
			if(_dbg)console.log('aneksValue', aneksValue);
			// budget__renderNodePrice('p5Budget__aneks', aneksValue);
			budget__renderZyskStrataPrice('p5Budget__aneks', -1 * aneksValue);
		}
		{
			var karyValue = costs.reduce(function (prevValue, currCost) {
				if (!currCost['budget_kary']) return prevValue;
				return prevValue + currCost['budget_kary'];
			}, 0);
			if(_dbg)console.log('karyValue', karyValue);
			budget__renderNodePrice('p5Budget__kary', karyValue);
		}

		p5Utils__clearNode(_tbody);
		var costNodes = costs.map(function(cost) {
			var costNode = document.createElement('tr')
			var tdNode = null

			// 					<td style="white-space:nowrap"><?php echo $cost['data']; ?></td>
			tdNode = document.createElement('td')
			tdNode.setAttribute('style', 'white-space:nowrap')
			tdNode.appendChild(document.createTextNode(cost['data']))
			costNode.appendChild(tdNode)

			// <td><?php echo UI::price($cost['budget_minus_sum']); ?></td>
			tdNode = document.createElement('td')
			tdNode.setAttribute('style', 'white-space:nowrap')
			tdNode.appendChild(document.createTextNode(p5Utils__pricePrintPL(cost['budget_minus_sum'], '0,00')))
			costNode.appendChild(tdNode)

			// <td style="color:<?php echo ($cost['budget_aneks']) ? 'black' : 'silver'; ?>"><?php echo UI::price($cost['budget_aneks']); ?></td>
			tdNode = document.createElement('td')
			tdNode.setAttribute('style', 'white-space:nowrap; color:' + ((cost['budget_aneks']) ? 'black' : 'silver'))
			tdNode.appendChild(document.createTextNode(p5Utils__pricePrintPL(cost['budget_aneks'], '0,00')))
			costNode.appendChild(tdNode)

			// <td style="color:<?php echo ($cost['budget_kary']) ? 'black' : 'silver'; ?>"><?php echo UI::price($cost['budget_kary']); ?></td>
			tdNode = document.createElement('td')
			tdNode.setAttribute('style', 'white-space:nowrap; color:' + ((cost['budget_kary']) ? 'black' : 'silver'))
			tdNode.appendChild(document.createTextNode(p5Utils__pricePrintPL(cost['budget_kary'], '0,00')))
			costNode.appendChild(tdNode)

			// <td style="color:<?php echo ($cost['budget_osprzet']) ? 'black' : 'silver'; ?>"><?php echo UI::price($cost['budget_osprzet']); ?></td>
			tdNode = document.createElement('td')
			tdNode.setAttribute('style', 'white-space:nowrap; color:' + ((cost['budget_osprzet']) ? 'black' : 'silver'))
			tdNode.appendChild(document.createTextNode(p5Utils__pricePrintPL(cost['budget_osprzet'], '0,00')))
			costNode.appendChild(tdNode)

			// <td style="color:<?php echo ($cost['budget_materialy']) ? 'black' : 'silver'; ?>"><?php echo UI::price($cost['budget_materialy']); ?></td>
			tdNode = document.createElement('td')
			tdNode.setAttribute('style', 'white-space:nowrap; color:' + ((cost['budget_materialy']) ? 'black' : 'silver'))
			tdNode.appendChild(document.createTextNode(p5Utils__pricePrintPL(cost['budget_materialy'], '0,00')))
			costNode.appendChild(tdNode)

			// <td style="color:<?php echo ($cost['budget_koszt_pracownikow']) ? 'black' : 'silver'; ?>"><?php echo UI::price($cost['budget_koszt_pracownikow']); ?></td>
			tdNode = document.createElement('td')
			tdNode.setAttribute('style', 'white-space:nowrap; color:' + ((cost['budget_koszt_pracownikow']) ? 'black' : 'silver'))
			tdNode.appendChild(document.createTextNode(p5Utils__pricePrintPL(cost['budget_koszt_pracownikow'], '0,00')))
			costNode.appendChild(tdNode)

			// <td style="color:<?php echo ($cost['budget_koszt_podwykonawcow']) ? 'black' : 'silver'; ?>"><?php echo UI::price($cost['budget_koszt_podwykonawcow']); ?></td>
			tdNode = document.createElement('td')
			tdNode.setAttribute('style', 'white-space:nowrap; color:' + ((cost['budget_koszt_podwykonawcow']) ? 'black' : 'silver'))
			tdNode.appendChild(document.createTextNode(p5Utils__pricePrintPL(cost['budget_koszt_podwykonawcow'], '0,00')))
			costNode.appendChild(tdNode)

			// <td style="color:<?php echo ($cost['budget_koszt_reprezentacyjny']) ? 'black' : 'silver'; ?>"><?php echo UI::price($cost['budget_koszt_reprezentacyjny']); ?></td>
			tdNode = document.createElement('td')
			tdNode.setAttribute('style', 'white-space:nowrap; color:' + ((cost['budget_koszt_reprezentacyjny']) ? 'black' : 'silver'))
			tdNode.appendChild(document.createTextNode(p5Utils__pricePrintPL(cost['budget_koszt_reprezentacyjny'], '0,00')))
			costNode.appendChild(tdNode)

			tdNode = document.createElement('td')
			if (cost['order_nr']) {
				var cellOrderColor = '#aaa';
				var cellOrderTitle = '';
				var cellOrderNrNode = document.createElement('div')
				switch (cost['order_approve_status']) {
					case 'ZATWIERDZONE': cellOrderColor = 'black'; break;
					case 'OCZEKUJE_OSTATECZNEGO_ZATWIERDZENIA': cellOrderColor = '#777'; break;
					case 'OCZEKUJE_ZATWIERDZENIA': cellOrderColor = '#777'; break;
					case 'WERSJA_ROBOCZA': cellOrderColor = '#aaa'; break;
				}
				switch (cost['order_approve_status']) {
					case 'ZATWIERDZONE': cellOrderTitle = "Zamówienie zatwierdzone"; break;
					case 'OCZEKUJE_OSTATECZNEGO_ZATWIERDZENIA': cellOrderTitle = "Zamówienie oczekuje ostatecznego zatwierdzenia"; break;
					case 'OCZEKUJE_ZATWIERDZENIA': cellOrderTitle = "Zamówienie oczekuje zatwierdzenia"; break;
					case 'ODRZUCONE': cellOrderTitle = "Zamówienie odrzucone"; break;
					case 'WERSJA_ROBOCZA': cellOrderTitle = "Wersja robocza"; break;
				}
				cellOrderNrNode.setAttribute('style', 'white-space:nowrap; color:silver')
				cellOrderNrNode.appendChild(document.createTextNode('nr: ' + cost['order_nr']))
				tdNode.setAttribute('style', 'white-space:nowrap; color:' + cellOrderColor)
				tdNode.setAttribute('title', cellOrderTitle)
				tdNode.appendChild(document.createTextNode(p5Utils__pricePrintPL(cost['order_cost'], '0,00')))
				tdNode.appendChild(cellOrderNrNode)
			} else {
				tdNode.setAttribute('style', 'white-space:nowrap; color:silver')
				tdNode.appendChild(document.createTextNode('0,00'))
			}
			costNode.appendChild(tdNode)

			// FV for Order
			tdNode = document.createElement('td')
			if (cost['nr_fv_do_zamowienia']) {
				// $cost['nr_fv_do_zamowienia'][] = array('id'=>$idKoresp, 'nr'=>$fv['obcy_nr_koresp'], 'cost'=>$fv['cost']);
				cost['nr_fv_do_zamowienia'].map(function(fv) {
					// TODO: link do edycji koresp by $idKoresp
					tdNode.appendChild(document.createTextNode(p5Utils__pricePrintPL(fv['cost'], '0,00')))
					if (fv['nr']) tdNode.appendChild(document.createTextNode(' (' + fv['nr'] + ')'))
				})
			}
			tdNode.setAttribute('style', 'white-space:nowrap; color:' + ((cost['nr_fv_do_zamowienia']) ? 'black' : 'silver'))
			costNode.appendChild(tdNode)

			// <td style="color:<?php echo ($cost['budget_zaliczki']) ? 'black' : 'silver'; ?>"><?php echo UI::price($cost['budget_zaliczki']); ?></td>
			tdNode = document.createElement('td')
			tdNode.setAttribute('style', 'white-space:nowrap; color:' + ((cost['budget_zaliczki']) ? 'black' : 'silver'))
			tdNode.appendChild(document.createTextNode(p5Utils__pricePrintPL(cost['budget_zaliczki'], '0,00')))
			costNode.appendChild(tdNode)

			// <td style="color:<?php echo ($cost['budget_rozliczone_zaliczki']) ? 'black' : 'silver'; ?>"><?php echo UI::price($cost['budget_rozliczone_zaliczki']); ?></td>
			tdNode = document.createElement('td')
			tdNode.setAttribute('style', 'white-space:nowrap; color:' + ((cost['budget_rozliczone_zaliczki']) ? 'black' : 'silver'))
			tdNode.appendChild(document.createTextNode(p5Utils__pricePrintPL(cost['budget_rozliczone_zaliczki'], '0,00')))
			costNode.appendChild(tdNode)

			// <td style="color:<?php echo ($cost['budget_zgoda_sluzebnosci']) ? 'black' : 'silver'; ?>"><?php echo UI::price($cost['budget_zgoda_sluzebnosci']); ?></td>
			tdNode = document.createElement('td')
			tdNode.setAttribute('style', 'white-space:nowrap; color:' + ((cost['budget_zgoda_sluzebnosci']) ? 'black' : 'silver'))
			tdNode.appendChild(document.createTextNode(p5Utils__pricePrintPL(cost['budget_zgoda_sluzebnosci'], '0,00')))
			costNode.appendChild(tdNode)

			// <td style="color:<?php echo ($cost['budget_zgoda_odszkodowania']) ? 'black' : 'silver'; ?>"><?php echo UI::price($cost['budget_zgoda_odszkodowania']); ?></td>
			tdNode = document.createElement('td')
			tdNode.setAttribute('style', 'white-space:nowrap; color:' + ((cost['budget_zgoda_odszkodowania']) ? 'black' : 'silver'))
			tdNode.appendChild(document.createTextNode(p5Utils__pricePrintPL(cost['budget_zgoda_odszkodowania'], '0,00')))
			costNode.appendChild(tdNode)

			// <td style="color:<?php echo ($cost['budget_sprzet_wlasny']) ? 'black' : 'silver'; ?>"><?php echo UI::price($cost['budget_sprzet_wlasny']); ?></td>
			tdNode = document.createElement('td')
			tdNode.setAttribute('style', 'white-space:nowrap; color:' + ((cost['budget_sprzet_wlasny']) ? 'black' : 'silver'))
			tdNode.appendChild(document.createTextNode(p5Utils__pricePrintPL(cost['budget_sprzet_wlasny'], '0,00')))
			costNode.appendChild(tdNode)

			// <td style="color:<?php echo ($cost['budget_sprzet_wynajety']) ? 'black' : 'silver'; ?>"><?php echo UI::price($cost['budget_sprzet_wynajety']); ?></td>
			tdNode = document.createElement('td')
			tdNode.setAttribute('style', 'white-space:nowrap; color:' + ((cost['budget_sprzet_wynajety']) ? 'black' : 'silver'))
			tdNode.appendChild(document.createTextNode(p5Utils__pricePrintPL(cost['budget_sprzet_wynajety'], '0,00')))
			costNode.appendChild(tdNode)

			// <td style="color:<?php echo ($cost['budget_organizacja_ruchu']) ? 'black' : 'silver'; ?>"><?php echo UI::price($cost['budget_organizacja_ruchu']); ?></td>
			tdNode = document.createElement('td')
			tdNode.setAttribute('style', 'white-space:nowrap; color:' + ((cost['budget_organizacja_ruchu']) ? 'black' : 'silver'))
			tdNode.appendChild(document.createTextNode(p5Utils__pricePrintPL(cost['budget_organizacja_ruchu'], '0,00')))
			costNode.appendChild(tdNode)

			// <td style="color:<?php echo ($cost['budget_zajetosc_pasa']) ? 'black' : 'silver'; ?>"><?php echo UI::price($cost['budget_zajetosc_pasa']); ?></td>
			tdNode = document.createElement('td')
			tdNode.setAttribute('style', 'white-space:nowrap; color:' + ((cost['budget_zajetosc_pasa']) ? 'black' : 'silver'))
			tdNode.appendChild(document.createTextNode(p5Utils__pricePrintPL(cost['budget_zajetosc_pasa'], '0,00')))
			costNode.appendChild(tdNode)

			return costNode;
		})

		costNodes.map(function(costNode) {
			_tbody.appendChild(costNode);
		});
	}

	jQuery(document).on('p5:Budget:addCost:click', function(e, n, payload) {
		if (!payload || !payload.props || !payload.props.type) return false;
		budget_addCost(n, payload.props.type);
	});

	function budget_addCost(n, type) {
		var labels = {}
		labels['ANEKS'] = "Aneks"
		labels['KARY'] = "Kary, potrącenia"
		labels['OSPRZET'] = "Osprzęt"
		labels['MATERIALY'] = "Materiały"
		labels['PRACOWNICY'] = "Koszty pracowników"
		labels['PODWYKONAWCY'] = "Koszt firmy podwykonawczej"
		labels['REPREZENTACYJNE'] = "Koszty reprezentacyjne"
		labels['ZALICZKA_KWOTA'] = "Zaliczka kwota"
		labels['ZALICZKA_KOSZTY_DZIENNE'] = "Rozliczanie zaliczki koszty dzienne"
		labels['ZGODY_SLUZEBNOSCI'] = "Służebności"
		labels['ZGODY_ODSZKODOWANIA'] = "Odszkodowania"
		labels['SPRZET_WLASNY'] = "Sprzęt własny"
		labels['SPRZET_WYNAJETY'] = "Sprzęt wynajęty"
		labels['ORGANIZACJA_RUCHU'] = "Organizacja ruchu"
		labels['ZAJETOSC_PASA'] = "Zajętość pasa drogowego"
		var labelText = (type in labels) ? labels[type] : type
		var desc = {}
		desc['ANEKS'] = "<br>Proszę wprowadzić róznicę pomiędzy aktualnym <abbr title=\"kwotą na umowie lub poprzednim aneksie\">budżetem</abbr>, a kwotą na aneksie"
		desc['ANEKS'] += ", np.:"
		desc['ANEKS'] += "<br><small>- kwota na umowie: 100,000"
		desc['ANEKS'] += "<br>- kwota na aneksie: 150,000"
		desc['ANEKS'] += "<br>wprowadzamy: <code>-50,000</code></small>"
		var descText = (type in desc) ? desc[type] : type

		swal({
		  title: 'Kwota netto dla kosztu:',
			html: '"' + labelText + '"' + descText,
			animation: false,
		  input: 'text',
			inputPlaceholder: '0,00',
			// inputAttributes: {'step': '0.01'},
		  showCancelButton: true,
		  confirmButtonText: 'Dodaj koszt',
		  showLoaderOnConfirm: true,
		  preConfirm: function(price) {
		    return new Promise(function(resolve, reject) {
					price = p5Utils__parseFloatOrZero(price)
	        if ('ANEKS' != type && price <= 0) {
	          reject('Kwota musi być większa od zera.')
	        } else if ('ANEKS' == type && price == 0) {
	          reject('Kwota musi być inna niż zera.')
	        } else {
						superagent
							.post(_saveLink)
							.type('json') // header ĺapplication/x-www-form-urlencoded' requires type('form');
							.send({
								type: type,
								price: price
							})
							.set('Accept', 'application/json')
							.end(function(err, res) {
								if(_dbg)console.log('#widget-budget/addCost: res:', res, 'res.body:', res.body)
								if (err || !res.ok) {
									// jQuery(document).trigger('DBG:notify', {type: 'warning', msg: 'Req error', err: err});
									reject("Request error")
								} else {
									if ('application/json' !== res.type) {
										reject("Wrong response type - required json")
										return
									}
									if (!res.body.id || res.body.id <= 0) reject(res.body.msg || "Wystąpiły błędy podczas dodawaniu kosztu")
									resolve(res.body)
								}
							})
		      }
		    })
		  },
		  allowOutsideClick: false
		}).then(function(responseBody) {
		  swal({
		    type: 'success',
				animation: false,
		    title: responseBody.msg || 'Koszt dodano',
		    html: 'Rodzaj kosztu: ' + (labelText || responseBody.type) + '<br>Kwota: ' + p5Utils__pricePrintPL(responseBody.price, '0') + '.'
		  })
			if (responseBody.update_data) {
				// TODO: budget__renderData(responseBody.update_data)
				budget__renderCosts(responseBody.update_data['costs']);
			}
		}).catch(function(e) {
			// eg. hit Cancel
		})
	}
})();
</script>
<?php if ($viewParams['print_mode']) : ?>
<script>window.print();</script>
<?php endif; ?>
		<?php
		DBG::_('DBG', '>2', 'data', $data, __CLASS__, __FUNCTION__, __LINE__);
	}

	public function addCostAjaxAction() {
		$response = array();
		$response['type'] = 'danger';
		$response['msg'] = 'Unknown error';
		try {
			$idProject = V::get('ID_PROJECT', 0, $_REQUEST, 'int');
			if (!$idProject) throw new Exception("Missing id project");
			$json = Request::getRequestBody();
			if (empty($json)) throw new Exception("Error Processing Request - json expected");
			$json = @json_decode($json, $assoc = true);
			if (null == $json && 0 !== json_last_error()) throw new Exception("Error Processing Request - Parse json error: " . json_last_error());
			$price = V::get('price', '', $json);
			$type = V::get('type', '', $json);
			if (empty($price)) throw new Exception("Missing price");
			if (empty($type)) throw new Exception("Missing type");
			$response['price'] = $price;
			$response['type'] = $type;

			$cost = array();
			$cost['ID_PROJECT'] = $idProject;
			$cost['COST_VALUE'] = $price;
			$cost['COST_TYPE'] = $type;
			$cost['COST_DATE'] = date("Y-m-d");
			// $cost['NOTES'] = $notes;// TODO: add notes to form?
			$idItem = DB::getDB()->ADD_NEW_OBJ('PROJECT_COSTS', (object)$cost);
			if ($idItem <= 0) throw new Exception("Wystąpiły błędy podczas tworzenia nowego rekordu w bazie danych");
			$response['type'] = 'success';
			$response['id'] = $idItem;
			$response['msg'] = "Koszt został dodany";
			{// update costs
				$data = array();
				$data['id_project'] = $idProject;
				$data = $this->setProps($data);
				$response['update_data'] = $data;
			}
		} catch (Exception $e) {
			$response['type'] = 'danger';
			$response['msg'] = $e->getMessage();
		}
		Response::sendJsonExit($response);
	}

}

/*
-- `PROJECT_COSTS`.`COST_VALUE` max 1000000123456,78

CREATE TABLE IF NOT EXISTS `PROJECT_COSTS` (
	`ID` int(11) NOT NULL AUTO_INCREMENT,
	`ID_PROJECT` int(11) NOT NULL DEFAULT 0,
	`A_RECORD_CREATE_DATE` datetime  DEFAULT NULL,
	`A_RECORD_CREATE_AUTHOR` varchar(20)  DEFAULT NULL,
	`SYNC_SQIX_STATUS` varchar(100) NOT NULL DEFAULT '',
	`A_RECORD_UPDATE_DATE` datetime  DEFAULT NULL,
	`A_RECORD_UPDATE_AUTHOR` varchar(20) NOT NULL DEFAULT '',
	`A_STATUS` enum('WAITING','NORMAL','MONITOR','WARNING','OFF_SOFT','OFF_HARD','DELETED') DEFAULT NULL,
	`A_ADM_COMPANY` varchar(100) NOT NULL DEFAULT '',
	`A_CLASSIFIED` varchar(100) NOT NULL DEFAULT '',
	`COST_VALUE` decimal(16,2) NOT NULL DEFAULT '',
	`COST_TYPE` varchar(32) NOT NULL DEFAULT '',
	`COST_DATE` date DEFAULT NULL,
	`NOTES` varchar(255) NOT NULL DEFAULT '',
	PRIMARY KEY (`ID`)
	KEY `ID_PROJECT` (`ID_PROJECT`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

CREATE TABLE IF NOT EXISTS `PROJECT_COSTS_HIST` (
	`ID` int(11) NOT NULL AUTO_INCREMENT,
	`ID_USERS2` int(11) NOT NULL,
	`ID_PROJECT` varchar(255) NOT NULL DEFAULT 'N/S;',
	`A_RECORD_CREATE_DATE` varchar(255) NOT NULL DEFAULT 'N/S;',
	`A_RECORD_CREATE_AUTHOR` varchar(20) NOT NULL DEFAULT 'N/S;',
	`SYNC_SQIX_STATUS` varchar(255) NOT NULL DEFAULT 'N/S;',
	`A_RECORD_UPDATE_DATE` varchar(255) NOT NULL DEFAULT 'N/S;',
	`A_RECORD_UPDATE_AUTHOR` varchar(20) NOT NULL DEFAULT 'N/S;',
	`A_STATUS` varchar(255) NOT NULL DEFAULT 'N/S;',
	`A_STATUS_INFO` varchar(255) NOT NULL DEFAULT 'N/S;',
	`A_ADM_COMPANY` varchar(255) NOT NULL DEFAULT 'N/S;',
	`A_CLASSIFIED` varchar(255) NOT NULL DEFAULT 'N/S;',
	`COST_VALUE` varchar(16) NOT NULL DEFAULT 'N/S;',
	`COST_TYPE` varchar(32) NOT NULL DEFAULT 'N/S;',
	`COST_DATE` varchar(10) NOT NULL DEFAULT 'N/S;',
	`NOTES` varchar(255) NOT NULL DEFAULT 'N/S;',
	PRIMARY KEY (`ID`),
  KEY `ID_USERS2` (`ID_USERS2`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2;

*/