11
mjoel
Re: Simple WFH Diary module?
  • 5/19 11:40

  • mjoel

  • Quite a regular

  • Posts: 331

  • Since: 2006/12/9


i open two issues in github

1. missing group/images folder
2. suggestion to add user to a group in batch if thats possible



12
mjoel
Re: Simple WFH Diary module?
  • 5/15 13:57

  • mjoel

  • Quite a regular

  • Posts: 331

  • Since: 2006/12/9


Quote:

goffy wrote:
Mamba suggested to simplify name and to use lower characters to avoid any case sensitive problem, and I agree wtih him

new name: https://github.com/XoopsModules25x/wgdiaries

new path to issues: https://github.com/XoopsModules25x/wgdiaries/issues


nice !!

i've registered myself in github and made several suggestions there to be consider



13
mjoel
Re: Estimate profile completeness
  • 5/15 13:55

  • mjoel

  • Quite a regular

  • Posts: 331

  • Since: 2006/12/9


i would like to try this where do we exactly put this code ?
is it still working?, im using xoops 2.5.10 and php 7.3

i tried putting it in php block but i got
Error : Error: Call to a member function getVar() on null



14
mjoel
Re: Xforms Module- show user their own data report
  • 5/14 11:07

  • mjoel

  • Quite a regular

  • Posts: 331

  • Since: 2006/12/9


Thanks again
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



15
mjoel
Re: Simple WFH Diary module?
  • 5/14 11:00

  • mjoel

  • Quite a regular

  • Posts: 331

  • Since: 2006/12/9


Quote:

goffy wrote:
hi

if you really want to continue on this I would suggest that I create a new project on https://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


that would be great



16
mjoel
Re: Simple WFH Diary module?
  • 5/14 5:59

  • mjoel

  • Quite a regular

  • Posts: 331

  • Since: 2006/12/9


Quote:

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


thank you goffy, i'll try first..if i have any question. i'll post here later



17
mjoel
Re: Simple WFH Diary module?
  • 5/13 16:34

  • mjoel

  • Quite a regular

  • Posts: 331

  • Since: 2006/12/9


OMG, thank you very much Goffy. that is quick. Module builder is a wonder

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



18
mjoel
Xforms Module- show user their own data report
  • 5/13 13:28

  • mjoel

  • Quite a regular

  • Posts: 331

  • Since: 2006/12/9


Hello

In reference to this topic, im currently trying to show user their own data report

with my limited php/mysql knowledge, here's what i tried so far. The code will show data for the currently logged in user

im stucked in how to display the data value for $udata_value , it is stored something like a:1:{i:0;s:8:"YWRtaW4=";} in the database


<?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");
?>



19
mjoel
Re: Simple WFH Diary module?
  • 5/13 4:34

  • mjoel

  • Quite a regular

  • Posts: 331

  • Since: 2006/12/9


thankyou zyspec
i just tested the xforms module and i think it does the job, im able to input date and text and upload image and documents ..and i as admin can see the data inserted by user

i can see the data value of the form are kept as text in mysql

now im trying to figure out
how to direct user to their own data after page submit
how to create a page that would allow a user to see their own reports.
how to allow user to edit their report and save to database

i think i will create a separate topic later



20
mjoel
Re: Simple WFH Diary module?
  • 5/12 16:40

  • mjoel

  • Quite a regular

  • Posts: 331

  • Since: 2006/12/9


Quote:

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.



Thank you very much..I will look into xforms




TopTop
« 1 (2) 3 4 5 ... 28 »



Login

Username:
Password:

Lost Password? Register now!

Who's Online

66 user(s) are online (37 user(s) are browsing Support Forums)


Members: 0


Guests: 66


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Dec 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits