use DBRisinajumi\Dimensions\Period;
use DBRisinajumi\Dimensions\Data;
use DBRisinajumi\Dimensions\Level;
if (!isset($_REQUEST['table_id']) || !isset($_REQUEST['record_id']) || !isset($_REQUEST['amt'])) {
echo "not all params provided";
exit;
}
require 'init.php';
$nTableId = (int) $_GET['table_id'];
$nRecordId = (int) $_GET['record_id'];
$nAmt = (double) $_GET['amt'];
$oPeriod = new Period($Database);
$oPeriod->setPeriodType('monthly');
$oData = new Data($Database, $oPeriod);
$oLevel = new Level($Database);
$aDimData = $oData->getDimData($nTableId, $nRecordId);
//var_dump($aDimData);
$sDateFrom = $sDateTo = date($oData->getUserDateFormat());
if (!empty($aDimData['date_from'])) {
$sDateFrom = date($oData->getUserDateFormat(), strtotime($aDimData['date_from']));
}
if (!empty($aDimData['date_to'])) {
$sDateTo = date($oData->getUserDateFormat(), strtotime($aDimData['date_to']));
}
$sTitle = "Set levels for items and split sums by periods";
require 'views/header.php';
?>
<form method="post" action="">
<input type="hidden" id="record_id" name="record_id" value="<?php
echo $nRecordId;
?>
<th>Level II</th>
<th>Level III</th>
<th></th>
</tr>
<?php
require 'init.php';
$oPeriod = new Period($Database);
$oPeriod->setPeriodType('monthly');
$oData = new Data($Database, $oPeriod);
$oLevel = new Level($Database);
$oTable = new \DBRisinajumi\Dimensions\Table($Database);
$nTableId = $oTable->getTableIdByName('dim_sample_bank_trans');
$sSql = "SELECT id, acc_holder, amount, message FROM dim_sample_bank_trans";
$q = $Database->query($sSql);
while ($row = $q->fetch_assoc()) {
$aDimData = $oData->getDimData($nTableId, $row['id']);
$sDateFrom = $sDateTo = '';
if (!empty($aDimData['date_from'])) {
$sDateFrom = date($oData->getUserDateFormat(), strtotime($aDimData['date_from']));
}
if (!empty($aDimData['date_to'])) {
$sDateTo = date($oData->getUserDateFormat(), strtotime($aDimData['date_to']));
}
echo "<tr>\n <td>" . $row['acc_holder'] . "</td>\n <td>" . $row['amount'] . "</td>\n <td>" . $row['message'] . "</td>\n <td>" . $sDateFrom . "</td>\n <td>" . $sDateTo . "</td>\n <td>" . $aDimData['l1_code'] . "</td>\n <td>" . $aDimData['l2_code'] . "</td>\n <td>" . $aDimData['l3_code'] . "</td>\n ";
?>
<td>
<a href="split_popup.php?table_id=<?php
echo $nTableId;
?>
&record_id=<?php
echo $row['id'];
