im not a programmer and i tried to replicate in the front end, it is somehow working but with error and no page style
i've send you PM zyspec.
For future it would be better this feature to be integrate in this great module
goffy wrote:
hi
if you really want to continue on this I would suggest that I create a new project onhttps://github.com/XoopsModules25x and you create issues there.
it is easier to split the work when you and I have forks of it which we can merge and I can try to solve problems/wishes issue by issue
goffy wrote:
1) take the content of "htdocs\modules\wgwfhdiary\extras\modulebuilder\testdata\english"
2) copy it into "htdocs\modules\modulebuilder\testdata\english"
3) run "import sample data" in modulebuilder than you have the definition of that module in modulebuilder and you can work on this
use XmfFilterInput;
use XmfRequest;
use XoopsModulesXforms;
use XoopsModulesXformsConstants;
use XoopsModulesXformsUtility;
require __DIR__ . '/header.php';
$myts = MyTextSanitizer::getInstance();
<?php
include("../../mainfile.php");
include(XOOPS_ROOT_PATH."/header.php");
$meta_keywords = "WFH Report";
$meta_description = "WFH Report";
$pagetitle = "WFH Report";
if(isset($xoTheme) && is_object($xoTheme)) {
$xoTheme->addMeta( 'meta', 'keywords', $meta_keywords);
$xoTheme->addMeta( 'meta', 'description', $meta_description);
} else {
$xoopsTpl->assign('xoops_meta_keywords', $meta_keywords);
$xoopsTpl->assign('xoops_meta_description', $meta_description);
}
$xoopsTpl->assign('xoops_pagetitle', $pagetitle);
//this will only work if your theme is using this smarty variables
$xoopsTpl->assign( 'xoops_showlblock', 0); //set to 0 to hide left blocks
$xoopsTpl->assign( 'xoops_showrblock', 0); //set to 0 to hide right blocks
$xoopsTpl->assign( 'xoops_showcblock', 1); //set to 0 to hide center blocks
//$xoopsUser->isAdmin() or redirect_header('index.php', 3, _NOPERM);
global $xoopsUser;
//get current user id
$loggedinuid = is_object($xoopsUser) ? $xoopsUser->getVar('uid') : 0;
?>
<div class="container-fluid">
<div class="row">
<h2>Work From Home Report</h2>
<?php
$getcaption=$GLOBALS['xoopsDB']->query("SELECT
form.*, element.*
FROM ".$GLOBALS['xoopsDB']->prefix("xforms_form")." AS form
INNER JOIN ".$GLOBALS['xoopsDB']->prefix("xforms_element")." as element
ON form.form_id=element.form_id WHERE element.form_id=1 ORDER BY ele_order ASC ");
if (!$getcaption) {
trigger_error($GLOBALS['xoopsDB']->error());
}
?>
<table id="report" class="table table-bordered" cellspacing="0">
<thead>
<tr>
<th>User</th>
<th>Date</th>
<th>Ip Address</th>
<?php
while($row = $GLOBALS['xoopsDB']->fetchArray($getcaption))
{
$ele_id=$row['ele_id'];
$ele_caption=$row['ele_caption'];
echo "<th>$ele_caption ($ele_id)</th>";
}
echo "</tr>";
echo "</thead>
<tbody>";
$getdata=$GLOBALS['xoopsDB']->query("SELECT D.uid, D.form_id, D.ele_id, D.udata_time, D.udata_ip, D.udata_value
, U.name, U.uname
, E.ele_type, E.ele_caption
FROM ".$GLOBALS['xoopsDB']->prefix("xforms_userdata")." D
LEFT JOIN ".$GLOBALS['xoopsDB']->prefix("users")." U ON (D.uid=U.uid)
INNER JOIN ".$GLOBALS['xoopsDB']->prefix("xforms_element")." E ON (D.ele_id=E.ele_id)
WHERE D.form_id=1 AND D.uid='$loggedinuid'
ORDER BY D.uid ASC, D.udata_time ASC, D.udata_ip ASC, E.ele_order ASC");
if (!$getdata) {
trigger_error($GLOBALS['xoopsDB']->error());
}
while($row = $GLOBALS['xoopsDB']->fetchArray($getdata))
{
$uid=$row['uid'];
$uname=$row['uname'];
$udata_time2=date("Y-m-d", strval($row["udata_time"]));
$udata_ip=$row['udata_ip'];
$udata_value=$row['udata_value'];
echo "<tr>";
echo "<td>$uname</td>
<td>$udata_time2</td>
<td>$udata_ip</td>
<td>$udata_value</td>
</tr>";
}
?>
</tbody>
</table>
</div></div>
<?php
include(XOOPS_ROOT_PATH."/footer.php");
?>