# Sadržaj

## CRONTAB - nano editor
- 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 // 

## 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();

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

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

## cron testing
clanarina id = 91 ,clanski_broj=3188, clan_id=105
Filip Glavaš - mkopcic84@gmail.com - filip.glavas004@gmail.com

za istek
4439, Oliver Sonnenfeld - olikasoni@gmail.com