# 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
- <a href="{{ route('admin.clanarina.neaktivne-clanarine') }}">

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