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 - zolwito

2
Questions / Re: View not showing record
Thanks for the answer Felix.
I did the change to normal view and didn't work.
It was working fine until yesterday that it stopped working and is a little frustrating.

Any other idea?
3
Questions / View not showing record
Hello,

After working for several days in a web app I got a LIST with a View Button where it shows a detail of that record and also shows some related tables of other tables.

Then yesterday it stopped showing the information of the record on the VIEW page. It says there is no record (is in spanish). I tried checking everything I could but there is no way to show the record on VIEW.

Please help!



4
Questions / Sending email - Subject with accenter characters
Hello,

I am sending emails and it works fine.
What I can ´t figure out is how to send and email with accented characters.

The text I am sending as the subject is: Envío de Requerimientos
When the email arrives to any kind of email address (Hotmail, Gmail, Corporate email) is: Envío de Requerimientos

It´s something about the encoding for the title but I can´t find where to fix it.

Please help.

Regards,

Carlos
5
Questions / Re: Add nowrap to a column
Quote from: willvin –
@zolwito‍ please use the bootstrap class text-nowrap to do that. You can read more about bootstrap classes for text over here.

I had to change the display Type to Custom and then add the text-nowrap on the div and it worked.
 <span class="text-nowrap"><?php echo $data['program']; ?></span>

But is that the way to do it? Or I can add the class text-nowrap somewhere else?


Thank you,

Carlos
6
Questions / Add nowrap to a column
Hello,

I have a specific column that I don't want the text to split to a next line.
How can I do to add a nowrap or something similar so it stays on the same line?

Regards,

Carlos
7
Questions / Re: Send an email to users when a status field is changed.
Already solved it.

Code: [Select]
$status_text = $db->rawQueryOne("SELECT text_email FROM status WHERE id_status ='" . $modeldata['status_id'] . "'");
$mailer    = new Mailer;
$texthtml = $status_text['text_email'];

$mailer->send_mail("myemail@gmail.com", "An Example Subject", "The message to be sent.<br><br>texthtml-->$texthtml<--<br><br><br>IT Team");

The trick was no to call the Array with index but with the name of the field.

Thank you.
8
Questions / Re: Send an email to users when a status field is changed.
Thank you for the reply.

I get a message saying ARRAY and I tried getting the elements from the array but I don't get anything.

Code: [Select]
$status_text = $db->rawQueryOne("SELECT texto_email FROM status WHERE id_status ='" . $modeldata['status_id'] . "'");
$mailer    = new Mailer;
$mailer->send_mail("myemail@gmail.com", "An Example Subject", "The message to be sent.<br><br>-->$status_text<--<br><br><br><br>IT Team");

And in the email I get: -->Array<-- where the $status_text is inserted.

I have tried with all this options:
Code: [Select]
$status_text[0];
$status_text[1];
print_r($status_text);
And all the same result.

Any hint?

Regards,

Carlos
9
Questions / Re: Some files are missing
Willvin,

I did a little change on the "Add New" button on all my pages from "Ajax Inline" to "Ajax Modal" and it started working the links, it was not the missing files.
Thank you.
10
Questions / Re: Send an email to users when a status field is changed.
Quote from: willvin –
@zolwito‍ this question has already been asked and answered here. Please go through it, thanks.

Willvin, the email sending is not the problem I am already sending emails.
What I need is to get a value from a record in a different table than the one I'm inserting in.

For example, I am changing the status of the user and after inserting the change in the "users" table, I need to get the text for the body of the email from the status table. The user goes from "contacted" to "meeting". The text for the "meeting" status is in the "status" table and I need that text so I can send the email with the correct information.

How do I get that field from another table? (I know that I can get values from the same table with $modeldata['fieldname'])

Thank you,

Carlos
11
Questions / Send an email to users when a status field is changed. [Solved]
How can I add some code so an email is sent to a specific user (there is a candidate's table) when the status is changed in a table.
There is also a status table where I will enter the HTML code of the email that has to be sent.

I already read in other post how to send the email but I need to know how to extract the HTML code I mentioned earlier and send the email. Is there a way to do a lookup of database tables with shortcodes or something?

Thank you,

Carlos
12
Questions / Re: Some files are missing
Maybe they are not needed.
The thing is that the modal windows for the form are not opening and I don't know why.

Can you help me?
13
Questions / Some files are missing
I just created a simple app to mantain a database but I am getting a button for "Record Creation" that is not working.

There are some files that should be published, see the image: error-files.jpg and they are different from the ones actually published on the server, check the file: files-server.jpg

How can I do in order to have those files published correctly?

Regards,

Carlos
14
General Discussion / Users accesing only info about their location
Hello,

I am building an application that needs certain profiles to access only information from their location.
This location is in a field on the users table and is called id_location. So all users except the Admin profile have an id_location.

Now the questions are:
  • How do I access this value in all pages in order to validate if the user is an admin so that user can see all records, but the other users can only see the record on their specific location?
  • When I have that value about their location, how do I modify the query in order to bring only their location records?
  • How do I redirect users that have no access to a certain page to another? For example: If I have a table called Stores and I dont want a user with level Teller to access the Add Page but a new page called Add Page Teller how do I do it?

Thank you for the help.

Regards,

Zolwito