Skip to main content

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

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

Back to top