fitness-laravel-cron-queries
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