That is a good start and i have many request and suggestion
I really think this module can be a multipurpose module and not just a wfh report tool
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;
?>
Work From Home Report
$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());
}
?>
User
Date
Ip Address
while($row = $GLOBALS['xoopsDB']->fetchArray($getcaption))
{
$ele_id=$row['ele_id'];
$ele_caption=$row['ele_caption'];
echo "$ele_caption ($ele_id) ";
}
echo " ";
echo "
";
$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 "";
echo "$uname
$udata_time2
$udata_ip
$udata_value
";
}
?>
include(XOOPS_ROOT_PATH."/footer.php");
?>
zyspec wrote:
@mjoel,
You could try the Xforms module. It will allow you to create the report you want. The module would need to be modified to create a page that would allow a user to see their own reports. I would think that would be easier than creating a completely new module.