Daily updating content from database

Ask the community
,
21

Hi, mud-ahmed!

I am glad for your letter. Please answer me a few questions, I will send you the text of the processing of the repeater.

  1. I would like to know if switching the prayer schedule to a new day works correctly in your zone. In which country (or time zone) do you intend to launch the schedule?

  2. I have some problem in the mobile version. At startup, the site apparently loads from the cache and up to 6-10 seconds the date and time of day and the time of prayers are shown as before. Then everything changes to real data and the clock runs in 1 second. This is not visible on the computer version. Do you have this output delay effect?

  3. What needs to be changed on the site?
    For example, is all the data listed here necessary in the mobile version?

Thanks

22

Hi,

Thank you very much for the assistance, your answers as follows:

  1. I intend to use this for the United Kingdom (GMT)

  2. I dont have this issue when using mobile site

  3. For my website, only five items are needed on the repeaters, FAJR, DHUHR, ASR, MAGHRIB and Isha. I have a separate timetable for my area in excel format

23

Thanks for answers. Sorry for some delay.

I don’t connect collection “tab” to dataset and repeater to dataset.
In order not to read the schedule for the whole year, I first determine the day number and read from the file only this record (results) corresponding to this day.

var today = new Date ();
const dayoy = dindex ( today ); // the day number
//console.log(dayoy);
//console.log(today);
const results =[];
return wixData . query ( “tab” )
. eq ( “dofY” , dayoy )
. find ()
. then (( results ) => {
vew ( results );
…

Using the vew (results) function, I connect the file’s record to page elements through a data-based repeater.
// connect to page
function vew ( results ) {
$w ( “#repeater1” ). forEachItem (( $item , itemData , index ) => {
index == 0 ? $item ( “#text8” ). text = results . items [ 0 ]. fajer :
index == 1 ? $item ( “#text8” ). text = results . items [ 0 ]. shuroq :
index == 2 ? $item ( “#text8” ). text = results . items [ 0 ]. dhohur :
index == 3 ? $item ( “#text8” ). text = results . items [ 0 ]. aser :
index == 4 ? $item ( “#text8” ). text = results . items [ 0 ]. maghreb :
$item ( “#text8” ). text = results . items [ 0 ]. isha ;
});

“#text8” - container’s element for displaying the schedule time. In your case, this time must be rewritten in the file, taking into account the traditions of the United Kingdom.
Good luck to you!

24

Please upload your separate timetable to the cloud and send me a link with editor permissions. I will help you get csv file. In the future, only 2 tables will be needed: for a regular year and a leap year.