Skip to main content

Show Posts

This section allows you to view all Show Posts made by this member. Note that you can only see Show Posts made in areas you currently have access to.

Messages - Ross T.

2
General Discussion / Re: Upload image with camera device
I don't think you need to code it differently. Try opening your application page with File Upload field in your Android Mobile phone. Click the button to upload the file and your android should offer you options to select the file source, where you should find camera as well. Select Camera, click the photo, Android OS will automatically feed that photo to your application's file upload field.
3
General Discussion / Show/Hide Menu items conditionally.
Hello,

I've three User Roles in my application and I want to hide certain Menu items based on the role of current logged in User. In order to achieve this, I've two How-To questions...
  • How to get the Role of currently logged-in user?
  • How to hide/show menu items dynamically?

I'm trying it in PHPRad Classic (Laravel + Bootstrap) v5.1.4 of Radsystems.

Awaiting your valuable reply...

Thanks!

R.
4
Questions / Re: (ASK)make accounting applications
One functionality which is lacking in current version of PHPRad and which is quite essential in most of the real life projects is... Parent field for listing the Records per User ID. Let me explain...

Suppose you're developing HR application and you've following Account Types...

Office Head
-- Office Manager 1
---- Employee 1.1
---- Employee 1.2
---- Employee 1.3
--Office Manager 2
---- Employee 2.1
---- Employee 2.2
---- Employee 2.3

Now, the current User Role based listing of Records in PHPRad will allow you to show records per User. So, Employee 1.1 will see only his records, Employee 2.2 will see only his records. Similarly, Office Manager 1 will see only his records, Office Manager 2 will see only his records; and here is the problem.

In most cases, client will demand to have Office Manager 1 to have access to all records generated by the Users "under" him. Here, although the records belong to Employee 1.1, those records should be visible to Office Manager 1 since Employee 1.1 is under Office Manager 1. However, the records of Employee 2.1 should not be visible to Office Manager 1 because Employee 2.1 is NOT under Office Manager 1.

Current Authentication scheme of PHPRad does not allow us to set the penetration of Authentication; and this can pose a serious issues later while dealing with real life applications.

@Emman  Correct me if the above mentioned scenario is possible with PHPRad...
5
Questions / Re: (ASK)make accounting applications
I just used a trial from Phprad, what I want to ask is whether phprad can be used to make accounting applications?
Like corporate financial management?

Is there a tutorial?

I am not sure if PHPRad is flexible enough to make such applications. You will need to have some areas for code customization. PHPRad is not an Event Driven environment where you can grab an event and then write certain code to make customize the default behavior of the generated scripts.

Give a thought before you commit yourself to PHPRad; have some test projects covering the functionalities which you will need your application before you finalize.
6
Questions / Re: how can i see entire query ?
I did this
$records = $db->get($tablename, $limit, $fields);
      echo $db->getLastQuery();

But doesnt show anything for me besides the standard error.

try to add Try Catch and add echo $db->getLastQuery in Catch. The error in $records line is not allowing the code to move on to the next line.

try {
$records = $db->get($tablename, $limit, $fields);
}
catch(\Exception $e) {
echo $db->getLastQuery();
}
8
Suggestions / Better field lookup for Master - Detail (List Page)
In current version, the JOIN interface on List page for the field having master - detail relation with other table allows selecting of table and defining the JOIN over field, to be selected by User. This further imports all fields to the List page field-list. This becomes difficult to handle when tables have too many fields.

I wish the JOIN interface allows me to select the field I want there itself or allows me to edit the SQL statement so only the required fields are selected from master table.

See the screenshot below for illustration of what I mean to say here...

9
General Discussion / Re: PHPRAD still exist or dying ?
New version released. Has someone tried it yet? I've just downloaded the setup. It's a big move to have two different versions of the application. More work to maintain the two versions now... but surely, a clear distinctive option for the Developers to choose the version of their liking. Good thing, at least at the time of writing this comment, both versions are available under same License cost.
10
General Discussion / Re: Custom Item
How about reading the values for 1 and 0 from the table itself? How to achieve this with Master - Detail record relationship?

For example, there is a Sales table with Item ID. The Item Names are in another table. So, how to show the Item Name in Sales table instead of Item ID which is the value of the field in table?
11
General Discussion / Re: how to create blog comments
You will need to have two tables -- Blog Articles and Blog Comments. Each Article will have ID as Primary Key and each Blog Comment will have CommentID as well as Article ID along with the comment text itself.

Inner Join on Article ID between Blog Article and Blog Comments with one to many relation. You may then use Page Parts to show the comments for a Article, tied over :id.

I hope this helps.
13
General Discussion / Re: PHPRAD still exist or dying ?
Glad to hear this. But a major update is required to keep it in competition. There are some very important issues, specifically related to the Authentication, are pending. Some additional features are also required to make this application ready to build real life applications.
15
Questions / Re: Data access by users company, rather than by userid?
>>Id like to filter based on the users COMPANY that entered the data<<
 How about making Company name as Login and let the Users set their own Passwords. This way, you may tie up the Login to the Company ID and that will serve as current logged in User's ID. Just a thought...