Skip to main content

Sadržaj

##CRONTAB

sudo EDITOR=nano crontab -e
export VISUAL=nano

##Laravel Carbon dates istek - Carbon dates - Carbon::parse($clanarina->datum_isteka)->diffInDays($danas) >= 5

          • cd /home/fitness/razvoj.mellon-fitness.com && php artisan schedule:run >> /dev/null 2>&1
          • /usr/local/bin/php /home/fitness/razvoj.mellon-fitness.com/artisan schedule:run 1>> /dev/null 2>&1 //

85,86,88,101

##DB quries - testing SELECT * FROM clanarina WHERE datum_isteka='2022-06-26' SELECT * FROM clanarina WHERE datum_isteka='2022-06-27' SELECT * FROM clanarina WHERE datum_isteka= CURRENT_DATE(); ##manual članarina status id query

update clanarina set status_id=2 where datum_isteka <= CURRENT_DATE();

##manual select clanarina query SELECT * FROM clanarina where datum_isteka <= CURRENT_DATE();

##msql select SELECT * FROM clan WHERE id not in(85,86,88,101)

#fk connstrain remove SET FOREIGN_KEY_CHECKS=0; ALTER TABLE clan DISABLE KEYS;

##razvoj baza testno delete FROM clan WHERE id NOT IN (85,86,88,101); delete from clanarina where clanarina.clan_id not in (85,86,88,101);

##Datatables - ajax status change // fix ##ajax dolasci,članarine,neaktivne,istek

  • App/Https/Controllers/ClanarinaController.php

  • ispravak querya, dodan status za status id ajax response

  • resources/views/index.php

##dt ajax call change: pregled dolazaka naslovna -ajax pregled članarina naslovna -ajax naslovna index.php - 2 ajaxa clanarina index pregled - ajax

prijava - dolazak - fix double clanarina

-query SELECT * FROM clan_dolazak left join clan on clan_dolazak.clan_id=clan.id left join clanarina on clan.id=clanarina.clan_id where clan.clan_status_id=1 order by clanarina.datum_isteka desc

Back to top