### docker run typo3
docker run -d --name typo3-db \
-e POSTGRES_PASSWORD=password \
-e POSTGRES_USER=postgres \
-e POSTGRES_DATABASE=postgres \
postgres:latest

## docker pull typo3
docker pull martinhelmich/typo3

## get docker container ip
docker inspect --format '{{ .NetworkSettings.IPAddress }}' 2d5c4e8d6af4

<VirtualHost *:80>
# The ServerName directive sets the request scheme, hostname and port that
# the server uses to identify itself. This is used when creating
# redirection URLs. In the context of virtual hosts, the ServerName
# specifies what hostname must appear in the request's Host: header to
# match this virtual host. For the default virtual host (this file) this
# value is not decisive as it is used as a last resort host regardless.
# However, you must set it for any further virtual host explicitly.
#ServerName www.example.com

        ServerAdmin webmaster@localhost
        ServerName t3.local
        ServerAlias www.t3.local
        DocumentRoot /home/marcinsowa/Projects/typo3source/public
        ErrorLog ${APACHE_LOG_DIR}/error.log
        CustomLog ${APACHE_LOG_DIR}/access.log combined
        <Directory /home/marcinsowa/Projects/typo3source/>
            AllowOverride none
            Require all granted
        </Directory>

        # Available loglevels: trace8, ..., trace1, debug, info, notice, warn,
        # error, crit, alert, emerg.
        # It is also possible to configure the loglevel for particular
        # modules, e.g.
<VirtualHost *:80>

### ddev stuff
ddev config  --project-type=typo3 --docroot=public --create-docroot --php-version 8.1
ddev start
ddev describe

### launch phpmyadmin
ddev launch -p

### start mailhog
ddev launch -m

### stop ddev
ddev poweroff

### ToDo
symfony new oscs --version="6.4.*"
composer require symfony/amazon-sqs-messenger
composer require nelmio/api-doc-bundle
composer require symfony/twig-bundle
composer require symfony/asset
composer require friendsofsymfony/rest-bundle
composer require symfony/serializer-pack

### SQS
symfony/messenger  instructions:

* You're ready to use the Messenger component. You can define your own message buses
  or start using the default one right now by injecting the message_bus service
  or type-hinting Symfony\Component\Messenger\MessageBusInterface in your code.

* To send messages to a transport and handle them asynchronously:

    1. Update the MESSENGER_TRANSPORT_DSN env var in .env if needed
       and framework.messenger.transports.async in config/packages/messenger.yaml;
    2. (if using Doctrine) Generate a Doctrine migration bin/console doctrine:migration:diff
       and execute it bin/console doctrine:migration:migrate
    3. Route your message classes to the async transport in config/packages/messenger.yaml.

* Read the documentation at https://symfony.com/doc/current/messenger.html

### TODO
PHP Tools
CSFixer
    composer require --dev friendsofphp/php-cs-fixer
    vendor/bin/php-cs-fixer fix src
Psalm
    composer require --dev vimeo/psalm
    ./vendor/bin/psalm
PHPStan
    composer require --dev phpstan/phpstan
    vendor/bin/phpstan analyse src tests

PHP Unit
    composer require --dev phpunit/phpunit ^10
    ./vendor/bin/phpunit --version
Monolog
    composer require symfony/monolog-bundle


json_schema żeby walidowała open_api i jako źródło jak AuthenticationController.php

/**
* Check if service answers to ping request (authentication+routing check)
* @Get("/ping")
* @SWG\Get(tags={"PING"})
*
* @param UserInterface     $user
*
* @return Response
* @SWG\Response(
*     response=200,
*     description="OK",
*     @SWG\Schema(
*         type="object",
*         ref=@Model(type=\App\Entity\PingResult::class)
*     )
* )
*/




symfony new configuration-php --version="6.3.*"
composer init
composer require nelmio/api-doc-bundle
composer require symfony/twig-bundle
composer require symfony/asset
composer require symfony/validator
composer require --dev friendsofphp/php-cs-fixer
composer require --dev vimeo/psalm
composer require --dev phpstan/phpstan
composer require --dev phpunit/phpunit ^10
composer require symfony/monolog-bundle
composer require justinrainbow/json-schema
copy files :
 - config/routes.yaml
 - config/packages/monolog.yaml
 - config/packages/nelmio_api_doc.yaml
 - config/packages/twig.yaml
 - config/packages/validator.yaml

### git checkout previous branch
git checkout -

### php tool for ddd in php
deptrac

### composer add global dependency
composer require oscs/php-service: "dev-master"

### bash
seq 1 10

### postgres
\q - quit
\l - list all databases
\l+ - list all databases with details
\c - connect to specific database
\d - describe a table
\di - list all indexes
\ds - list all sequences
\dt - list all tables in current database
\du - list all users databases or roles
\dv - list all views
\x - query results in more readable format
\q - quit
\timing - toggle timing for query
\! - run shell command within current directory
\o - redirect output to a file
\H - toggle HTML output mode for query results
\? - list all utility commands

### ubuntu
# grab all lines in a file matching REGEX_LINE_TO_MATCH and for each line replace TEXT_TO_REPLACE_REGEX w/ REPLACEMENT_TEXT
sudo sed -i -e '/<REGEX_LINE_TO_MATCH>/s/<TEXT_TO_REPLACE_REGEX>/<REPLACEMENT_TEXT>/' '<FILE_TO_EDIT>'

### crontab
sudo vim /etc/crontab

### kolejne komendy na vpn

### to reacreate global docker system
docker compose down
docker system prune -a
docker volume prune -a
docker compose up

### docker
docker compose -f docker-compose.yml -f docker-compose_linux.yml down
etcd - Etcd explorer in intellij
Console Command
Import Export
https://github.com/linkorb/etcd-php/tree/master
apisix
export -prefix=/apisix -directory=c:/users/xxx/xyc


### env url for etcd
API_URL=http://127.0.0.1:62378

### git add origin
symfony new sse-messenger-php --version="6.3.*"
cd sse-messenger-php

dodać do scripts w composer.json
"qa": {
"php-cs-fixer": "vendor/bin/php-cs-fixer fix src",
"psalm": "vendor/bin/psalm --no-cache --config=vendor/oscs/php-service/psalm.xml",
"phpstan": "vendor/bin/phpstan analyze src -c vendor/oscs/php-service/phpstan.neon"
},
"tests": {
"local-test": "vendor/bin/phpunit --display-warnings",
"php-service-test": "vendor/bin/phpunit vendor/oscs/php-service/tests --display-warnings"
}

dodać /.idea/ do .gitignore

usuń z phpunit.xml.dist niepotrzebne
przesuń zawartość z .env do .env.local
config/routes/nelmio_api_doc.yaml:
- { resource: '@PhpServiceBundle/config/routes/nelmio_api_doc.yaml' }
zmień config/packages/nelmio_api_doc.yaml
config/packages/monolog.yaml
imports:
- { resource: '@PhpServiceBundle/config/packages/monolog.yaml' }

### rename remote
git remote rename ui_error_logger origin

### running tests with dama
symfony console doctrine:database:create --env=test

symfony console doctrine:migrations:migrate -n --env=test

vendor/bin/phpstan analyze -c vendor/oscs/php-service/phpstan.neon

cat <<< $(jq '.scripts.qa = { "qa": "composer run-script qa -d ./vendor/oscs/php-service"}'  composer.json) > composer.json

### symfony redis
composer require symfony/http-foundation

docker-compose up -d --force-recreate --build integration_nayax_device-php redis

redis://172.17.0.1:65219
redis://localhost:65219
redis://redis:6379

### turn off caching
vi /usr/local/etc/php/conf.d/apcu.ini
vi /usr/local/etc/php/conf.d/docker-php-ext-opcache.ini

enabled=0

### vim end of file shortcut
shift+g

docker compose -f docker-compose.yml -f docker-compose_linux.yml up -d


add line to file
sed -i "5i\        servers:\n            - url: '%env(APP_URL)%'" config/packages/nelmio_api_doc.yaml
sed -i "14i\        return '';" vendor/oscs/php-service/src/Service/Fluentd/Packer.php

remove lines from file
sed -i '15,24d' vendor/oscs/php-service/src/Service/Fluentd/Packer.php

# naprawić markdowny w phpstormie
-> wyłączyć eset
https://youtrack.jetbrains.com/issue/IDEA-309146/README.md-preview-not-working

### clean install postgres volume
docker volume rm oscs-ticketing-localdev_pgdata

php bin/console doctrine:query:sql "SELECT * FROM asd"

### get bearer
$request->headers->get('Authorization');

### puścić tą linijke we wszystkich serwisach z swaggerem
sed -i "7i\    <style>\n    .opblock-options {\n        display: none;\n    }\n    span > .opblock-tag-section > #operations-tag-default {\n        display: none;\n    }\n    </style>" templates/bundles/NelmioApiDocBundle/SwaggerUi/index.html.twig
sed -i '9 s/^..//' templates/bundles/NelmioApiDocBundle/SwaggerUi/index.html.twig

zmienić phpa w composer.json na 8.2 dla wszystkich mikroserwisów
sed -i 's/"php": ">=8.1"/"php": ">=8.2"/' composer.json

### qa projects for php
https://github.com/captainhookphp/captainhook - git hooks
https://github.com/qossmic/deptrac - qa for ddd
https://phpmd.org - dobre
https://github.com/php-parallel-lint/PHP-Parallel-Lint/tree/php-82 - dobre
https://tomasvotruba.com/blog/2018/02/19/rector-part-1-what-and-how/ - rector

### mobile app ->
https://capacitorjs.com/

### How to install msgpack
sudo apt install php8.3-msgpack

sudo apt install php8.3 php8.3-cli php8.3-{common,curl,dev,fpm,intl,mbstring,msgpack,opcache,pgsql,readline,xml}

to snake_case
function tosnakecase{
$output = preg_replace_callback('/([a-z])([A-Z])/', function ($matches) {
return strtolower($matches[1]).'_'.strtolower($matches[2]);
}, $input);
}

### run one phpunit test
php vendor/bin/phpunit  --filter testImportAction

sed -i '36i\            $userId = $this->checkDatabase($userData);\n            return new UserBadge((string) $userId);' vendor/oscs/php-service/src/Security/AccessTokenHandler.php
sed -i '38 s/^/\/\/ /' vendor/oscs/php-service/src/Security/AccessTokenHandler.php #fixToken

git checkout -B develop origin/develop
git fetch
git pull
git checkout -b 'feature/OSCST-625'
composer update "oscs/php-service"
find . -type f -exec sed -i 's/modified_at/updated_at/g' {} +
find . -type f -exec sed -i 's/modified_by/updated_by/g' {} +

### fix Token 2.0
sed -i '31 s/^/\/\//g' vendor/oscs/php-service/src/Security/AccessTokenHandler.php
sed -i '32s/$userId = /$userId = 1;\/\//' vendor/oscs/php-service/src/Security/AccessTokenHandler.php

### unfix Token 2.0
sed -i '31s#//##' vendor/oscs/php-service/src/Security/AccessTokenHandler.php
sed -i '32s/$userId = 1;\/\//$userId = /' vendor/oscs/php-service/src/Security/AccessTokenHandler.php

docker system prune

### way to downgrade docker
sudo apt-get purge docker-ce docker-ce-cli containerd.io
sudo rm -rf /var/lib/docker
sudo apt-get update
sudo apt-get install docker-ce=5:25.0.5-1~ubuntu.22.04~jammy docker-ce-cli=5:25.0.5-1~ubuntu.22.04~jammy containerd.io

### check availible versions in apt-get
apt-cache madison docker-ce

### jasper command
/home/marcinsowa/Projects/oscs-global/reportgenerator/bin/jasperstarter/bin/jasperstarter process /home/marcinsowa/Projects/oscs-global/reportgenerator/src/Service/cherry2.jasper -f xlsx --db-driver postgresql-42.7.2.jar --db-url postgresql://localhost:5432/docker?user=postgres&password=password

rename 's/\.([^.]+)$/Test.$1/' /home/marcinsowa/Projects/oscs-global/php-service/tests/Enum

/home/marcinsowa/Projects/oscs-global/reportgenerator/bin/jasperstarter/bin/jasperstarter process /home/marcinsowa/Projects/oscs-global/reportgenerator/src/Service/asd.jasper -f pdf --db-driver duckdb_jdbc-0.10.1.jar --db-url jdbc:duckdb:/home/marcinsowa/Projects/oscs-global/reportgenerator/src/Service/my.db

org.duckdb.DuckDBDriver

SELECT transaction_status FROM read_parquet('/home/marcinsowa/Projects/oscs-global/reportgenerator/src/Service/temp_data.parquet');

DATABASE_URL='postgresql://svc_reporting:svc_reporting@postgresql:5432/ticketing?charset=utf8'
DATABASE_URL='postgresql://svc_reporting:svc_reporting@172.30.0.1:65217/ticketing?charset=utf8'

[Configuration] Config virtual_directories
Config of the list of the virtual dictionaries
/configuration/api/v1/virtual-dictionaries/*/config
^/configuration/api/v1/virtual-dictionaries/([a-zA-Z0-9\.]+)$/config
/api/v1/virtual-dictionaries/$1/config

### if vendor errors
chmod 777 vendor -R

sudo service apache2 stop && sudo service postgresql stop &&  docker-compose up

phpSettings.display_errors = "1"

git config core.autocrlf true

composer require rector/rector --dev

git reset --hard <branch>
git push --force

dodać xdebug do DockerFile80

sudo chown $(whoami):$(whoami) application/logs/$(date +%Y%m%d).error.log && sudo chmod 777 application/logs/$(date +%Y%m%d).error.log

### If [UnexpectedValueException] Unknown package has no name defined
sudo rm -rf vendor/
sudo rm composer.lock
composer clearcache
composer install

### remove duplicates from po file
msguniq --output-file=public/languages/en/default_cln.po public/languages/en/default.po

### to put label inside div in form
setDecorators instead of addDecorators

### po dodaniu volumenu w docker-compose dla nginxa
po zrobieniu
sudo chown marcinsowa:marcinsowa -R .

$('.btn-info').click((e) => { e.preventDefault(); e.stopPropagation(); });

### before language generation
sudo chown -R 1000:1000 public/languages && docker exec -it bs_php sh

for po_path in $(find /var/www/app/public/languages/* -type f -name "*.po" ); do
path="${po_path%.*}"
msgfmt $path.po --output-file=$path.mo
echo generate file $path.mo
done

sudo chown -R 1001:1001 public/languages

curl -e http://onet.pl http://localhost:8080/pl/login

0  3  *  *  *   /bin/find /var/www/app/logs/ -name "*.log" -mtime +90 -exec rm -f {} \;


ai:

use as a rectangle circle and triangle svg and when u change from one into other animate morphing


interaktywny dokument prawa i konstytucji z historią każdej zmiany w formie podświetlania zmiany i daty

QaMBan - kanban alternative to jira,trello,etc



1. Struktura aplikacji

    Entity: Przepis, Komentarz

    Repository: Obsługa pobierania danych

    Controller: API do synchronizacji i pobierania danych

    Service: Obsługa TheMealDB API i synchronizacja

2. Synchronizacja przepisów

   Użyj Symfony Console Command do cyklicznego pobierania przepisów.

   Ustaw CRON lub Symfony Messenger (scheduler) do automatycznej synchronizacji.

3. Wyświetlanie listy przepisów

   Paginacja w Symfony: KnpPaginatorBundle

   Wyszukiwarka: QueryBuilder + LIKE w SQL

4. Szczegóły przepisu i komentarze

   Formularz Symfony do dodawania komentarzy

   Wyświetlanie ostatnich 20 komentarzy posortowanych DESC

5. Obsługa ulubionych przepisów (bonus)

   Przechowywanie ID w localStorage

   JS do dynamicznego dodawania/usuwania ulubionych bez przeładowania

6. Konfiguracja bazy danych

   Tabela recipe (id, title, instructions, category, tags, image_url, etc.)

   Tabela comment (id, recipe_id, content, created_at)

   223300330
   jezeli przekrocze 20000 - x
   zarejestrowac do vatu  - data faktury przekraczajacej x
   czynny żal - wystawić x
   jpk x
   vat
   pkd 62.01.Z
   178751537 - pani skarbowa
   178751404 - pan od vatu

   w umowie jest że netto
   korekta faktur od daty przekroczenia na takie z vatem
   korekta pitu na takiego z vatem



alias +dj "+moveup;  wait; -moveup;  wait; +moveup;"
alias -dj "-moveup;"
bind mouse2 "+dj"


zus zaswiadczenie jaka byla podstawaskladek z dzialalnosci gospodarczej x
odebrać zaświadzcenie z pue i wysłać

✅ Symfony Best Practices
🧱 Project Structure & Architecture

    Follow Domain-Driven Design (DDD) when appropriate — separate business logic from infrastructure.
    Use service classes for business logic — avoid bloating controllers.
    Use src/Domain, src/Application, src/Infrastructure for clearer separation in larger projects.
    Avoid tight coupling to Symfony components — use interfaces & dependency injection.
    Group related code into Bundles or Feature Folders only if necessary — modern Symfony doesn't require bundles.

⚙️ Configuration & Services

    Favor autowiring & autoconfiguration.
    Tag services with autowire: true and autoconfigure: true in services.yaml.
    Keep services.yaml clean — move complex config to separate files in config/services/.
    Use env variables for sensitive config (e.g. DB creds, API keys).
    Use ParameterBagInterface carefully — avoid injecting it everywhere.

🧪 Testing

    Write unit tests for pure business logic.
    Use functional tests (WebTestCase) for controller-level coverage.
    Mock external services (e.g., APIs, DB) — don’t test the network.
    Use Panther or Playwright for full browser tests if needed.
    Keep tests fast — don’t load the whole kernel unless necessary.

📦 Doctrine & Database

    Use DTOs or ViewModels instead of exposing Entities directly to views/forms.
    Avoid bidirectional relations unless truly needed.
    Keep @ORM annotations clean — prefer YAML/XML or PHP attributes consistently.
    Normalize data in DB — avoid premature denormalization.
    Use custom repository methods for queries; keep logic out of controllers.

🎯 Controllers & Routing

    Keep controllers thin — use form handlers or action services.
    Use attribute-based routes (e.g. #[Route(...)]) for modern Symfony.
    Return proper HTTP status codes — especially in APIs.
    Use ParamConverter carefully — avoid automatic Doctrine loading in complex logic.

📤 Forms & Validation

    Use Form Types for user input — even for APIs (with submit()).
    Use custom form handlers/services to process forms.
    Validate with Symfony’s Validator component — include constraints in DTOs/entities.
    Avoid putting validation logic directly in controllers.

🔐 Security

    Use Symfony Security component with roles & voters.
    Hash passwords using UserPasswordHasherInterface.
    Limit access using is_granted(), security.yaml, or access control expressions.
    Protect forms with CSRF tokens (enabled by default).
    Keep sensitive config out of Git — use .env.local.

⚡ Performance

    Use Symfony cache pools (e.g. Redis) for expensive calls.
    Enable HTTP caching and Twig cache tags when needed.
    Profile with Web Profiler Toolbar and Blackfire (if available).
    Optimize autoloading with composer dump-autoload --optimize.

🛠 Dev Experience

    Use maker bundle to scaffold entities, forms, controllers (composer require symfony/maker-bundle).
    Use Xdebug or Symfony Profiler to trace performance issues.
    Use php bin/console debug:* commands to explore services, routes, etc.

✨ Misc

    Use Twig templates efficiently — extend base templates, use macros/components.
    Keep .env files tidy — document expected vars in .env.dist.
    Use meaningful commit messages, semantic versioning if tagging releases.
    Document API routes with NelMioApiDocBundle (if applicable).
    Monitor logs — Symfony logs to var/log/ by default (set up Slack/email alerts for prod errors).


postgresql://neondb_owner:npg_As9NqUdl3WKJ@ep-misty-waterfall-a9boil6o-pooler.gwc.azure.neon.tech/neondb?sslmode=require


gl_shadows 0 -> dejf 1



### run llm localy

cd H:\projects\prompthlp\llama.cpp\build

λ /bin/llama-server.exe -m ../models/tinyllama-1.1b-chat-v1.0.Q4_0.gguf


cd H:\projects\prompthlp
go run main.go "summarize the plot of the matrix"


Quake-2-Ladder

Użytkownik - zakłada konto,potwierdza email
   Dodaj mecz
   Ranking
Admin - akceptuje mecze
Elo ranking -

Wygrany dodaje mecz na discordzie
Admin akceptuje
Moment akceptacji - liczenie elo

Osobne mapy z osobnym wynikiem i screenem



Mappool:

mapy: q2dm1, q2duel1, q2duel5, q2duel8, q2rdm1, q2rdm2, kolduel1, ztn2dm2, ptrip
TL: 10 min

Pierwszy wybiera swoja drugi wybiera swoja kto ma mniej fragow odrzuca pierwszy jak zostanie jedna to jest decydujaca

great could you do this in polish and enter base data

https://script.google.com/macros/s/AKfycby8v_sQeEmOHBICt3Wo7CZM_L2zdFUKlk6FN6wRQdYGGxmyRU1verBLmLHkQTebGdhc/exec

A hyper-realistic, ultra-detailed 8K cinematic image of an old, cracked yellow interior wall. The wall is textured with peeling paint, subtle stains, and visible signs of decay, with tiny specks of dust floating in the air. In the center of the composition is a deep, vertical crack in the wall, rough and irregular, with worn edges and crumbled plaster surrounding it. Through the crack, a beam of warm sunlight pierces into the dark room, illuminating the dust in the air and casting a dramatic golden glow onto the nearby surface of the wall. Inside the crack, in stark magical contrast to the decayed surroundings, there is a miniature, enchanted landscape, as if a hidden world is growing within the fissure. A tiny, vibrant tree with lush green leaves emerges from within, rooted in a patch of soft mossy grass. A small river winds through this tiny landscape, sparkling in the sunlight, and flows gracefully to the edge of the crack, where it spills out as a miniature waterfall, cascading down the wall into the room below. The lighting is cinematic and dramatic, with high contrast between the warm, golden sunbeam and the shadowy, moody interior space. The textures are incredibly rich - the roughness of the old wall, the delicate greenery inside the crack, the flowing water, and the glow of sunlight all rendered in exquisite detail

A hyper-realistic, ultra-detailed 8K cinematic image geiger style of a girl where her whole skin is in barcodes she is looking at the window and sky is falling outside


MaqIT

- Automatyzacje
- Komputery
- Strony Internetowe

Create local first kanban app which synchronizes with sqlite database in background after each change - using nim and sqlite# Siemanko

## Jak się miewasz?

### Skąd mieszkasz?

#### I dlaczego z tak daleka?

https://color.adobe.com/pl/create/color-wheel/?base=2&rule=Monochromatic&selected=4&name=M%C3%B3j%20motyw%20Color&mode=rgb&rgbvalues=0.5,0.23440391601454497,0.03983437495032538,1,0.6419603250842485,0.3796687499006508,1,0.46880783202908993,0.07966874990065076,0.5,0.47449226021259183,0.45580588069393396,0.8,0.37504626562327187,0.06373499992052052&swatchOrder=0,1,2,3,4

szary ciemny - 313C3D
szary jasny - 8A817E tlo albo
czarny - 000000
zielony - 58A621 podswietlanie do linków
biały - F5EFE9 tlo albo
pdoswietlanie zielony

<?php

//css for ie
{
!important will be ignored by IE.
view source
print?
1	margin: 20px !important; margin: 10px;

//pure middle
html {
   width:100%;
   height:100%;
   background:url(logo.png) center center no-repeat;
}

//the same
img {
   position: absolute;
   top: 50%;
   left: 50%;
   width: 500px;
   height: 500px;
   margin-top: -250px; /* Half the height */\
   margin-left: -250px; /* Half the width */
}



//distance in latlong - latlong
function distance($lat1, $lng1, $lat2, $lng2, $miles = true)
{
$pi80 = M_PI / 180;
$lat1 *= $pi80;
$lng1 *= $pi80;
$lat2 *= $pi80;
$lng2 *= $pi80;

$r = 6372.797; // mean radius of Earth in km
$dlat = $lat2 - $lat1;
$dlng = $lng2 - $lng1;
$a = sin($dlat / 2) * sin($dlat / 2) + cos($lat1) * cos($lat2) * sin($dlng / 2) * sin($dlng / 2);
$c = 2 * atan2(sqrt($a), sqrt(1 - $a));
$km = $r * $c;

return ($miles ? ($km * 0.621371192) : $km);
}

//setting opacity
selector
{
filter: alpha(opacity=60); /* MSIE/PC */
-moz-opacity: 0.6; /* Mozilla 1.6 and older */
opacity: 0.6;
}

//checking structure with css (nice)
* { outline: 2px dotted red }
* * { outline: 2px dotted green }
* * * { outline: 2px dotted orange }
* * * * { outline: 2px dotted blue }
* * * * * { outline: 1px solid red }
* * * * * * { outline: 1px solid green }
* * * * * * * { outline: 1px solid orange }
* * * * * * * * { outline: 1px solid blue }

/* 1. Vertical centering with line-height */
line-height:24px;


/* 2. Prevent oversized content to break fixed width floated layouts */
#main{
overflow:hidden;
}

/* 3. Prevent line breaks in links */
a{
white-space:nowrap;
}

/* 4. Always show Firefox scrollbar */
html{
overflow:-moz-scrollbars-vertical;
}

/* 5. Centering block elements horizontally */
margin:0 auto;

/* 6. Remove vertical textarea scrollbar in IE */
textarea{
overflow:auto;
}

/* 7. Force page breaks when printing your document */
h2{
page-break-before:always;
}

/* 8. Remove active link borders */
a:active, a:focus{
outline:none;
}

img
{
filter: alpha(opacity=60); /* MSIE/PC */
-moz-opacity: 0.6; /* Mozilla 1.6 and older */
opacity: 0.6;
}

//lamanko tekstu dlugieeegooo
.prevent-text-breakouts {
  -ms-word-break: break-all;
      word-break: break-all;
      word-break: break-word;
  -webkit-hyphens: auto;
     -moz-hyphens: auto;
          hyphens: auto;
}

.Absolute-Center {
  margin: auto;
  position: absolute;
  top: 0; left: 0; bottom: 0; right: 0;
}

//odpalanie sql'a z backupu
pg_restore -c -i -h localhost -p 5432 -U autocard -d autocard_del -O e:/autocard.backup
pg_restore -c -i -h localhost -p 5432 -U kupbon -d kupbon -O e:/kupbon.backup

#To remove existing default gateway
route delete 0.0.0.0
#To configure new gateway
route add 0.0.0.0 10.0.0.1
******************************


//przenoszonko

http.conf
	uncomment # at beginning of vhost
vhosts.conf
	change to every site you need
php.ini
	short open tags ( or exclude them from your sites)
	(for postgres)
	pdo_pgsql uncomment

0.apache/php.ini apache/conf vhosts conf windows/hosts //!!! change directories in all files !!! 1.expires module 2.headers module 3.rewrite module
1.Files
2.DB's
3.libpq.dll from php!
4.postgres + cake  in php.ini
5.zwiekszyc black na drukarce do kart
6.C:\Users\Marcin\AppData\Roaming take what needed
7.http://mssql-to-postgresql.blogspot.com/2007/12/cool-groupconcat.html group_cocat postgres 8.4
8. //dla autocard sciezka z public_html na koncu

progsy
http://pnggauntlet.com/
cakestrap
windows grep
wampserver
tortoise svn
sublime text
pngquant
filezilla
bru
process monitor
process explorer
light image resizer
cdbxp
ninite.com
blat

//zmiany w bibliotekach cake'a
//pod ipad'a
1.E:\wamp\www\opencard_2013\lib\Cake\Network\CakeRequest.php - iPad zmienić na coś innego żeby alkowi na iPadzie wyświetlało nie-mobilną stronę
//pod raportowanie błędów
2.E:\wamp\www\opencard_2013\lib\Cake\Error\ErrorHandler.php - l:115 - $exception->getTraceAsString().' - http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI']."\n".'useragent - '.$_SERVER['HTTP_USER_AGENT']."\n"

email regex || \b[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}\b
join files into one // cmd || for %f in (*.eml) do type "%f" >> new.txt

Pdf Libre Office
W nowym officie zapisz jako pdf


UPDATE locals SET woj=wojewodztwa.id LEFT JOIN miasta ON miasta.nazwa = locals.miasto WHERE
UPDATE locals SET woj=14 WHERE miasto='Warszawa';UPDATE locals SET woj=14 WHERE woj2='mazowieckie';
UPDATE locals SET woj=10 WHERE miasto='Łódź';UPDATE locals SET woj=10 WHERE woj2='łódzkie';
UPDATE locals SET woj=18 WHERE miasto='Rzeszów';UPDATE locals SET woj=18 WHERE woj2='Podkarpackie';
UPDATE locals SET woj=12 WHERE miasto='Kraków';UPDATE locals SET woj=12 WHERE woj2='małopolskie';
UPDATE locals SET woj=2 WHERE miasto='Wrocław';UPDATE locals SET woj=2 WHERE woj2='dolnośląskie';
UPDATE locals SET woj=4 WHERE miasto='Bydgoszcz';UPDATE locals SET woj=4 WHERE woj2='kujawsko-pomorskie';
UPDATE locals SET woj=4 WHERE miasto='Toruń';UPDATE locals SET woj=4 WHERE woj2='kujawsko-pomorskie';
UPDATE locals SET woj=6 WHERE miasto='Lublin';UPDATE locals SET woj=6 WHERE woj2='lubelskie';
UPDATE locals SET woj=8 WHERE miasto='Gorzów Wielkopolski';UPDATE locals SET woj=8 WHERE woj2='lubuskie';
UPDATE locals SET woj=8 WHERE miasto='Zielona Góra';UPDATE locals SET woj=8 WHERE woj2='lubuskie';
UPDATE locals SET woj=16 WHERE miasto='Opole';UPDATE locals SET woj=16 WHERE woj2='opolskie';
UPDATE locals SET woj=20 WHERE miasto='Białystok';UPDATE locals SET woj=20 WHERE woj2='podlaskie';
UPDATE locals SET woj=22 WHERE miasto='Gdańsk';UPDATE locals SET woj=22 WHERE woj2='pomorskie';
UPDATE locals SET woj=24 WHERE miasto='Katowice';UPDATE locals SET woj=24 WHERE woj2='śląskie';
UPDATE locals SET woj=26 WHERE miasto='Kielce';UPDATE locals SET woj=26 WHERE woj2='świętokrzyskie';
UPDATE locals SET woj=28 WHERE miasto='Olsztyn';UPDATE locals SET woj=28 WHERE woj2='warmińsko-mazurskie';
UPDATE locals SET woj=30 WHERE miasto='Poznań';UPDATE locals SET woj=30 WHERE woj2='Wielkopolskie';
UPDATE locals SET woj=32 WHERE miasto='Szczecin';UPDATE locals SET woj=32 WHERE woj2='zachodniopomorskie';

SELECT kod_pocztowy,miasto,k.woj FROM `locals` as l
LEFT JOIN `kody_pocztowe` as k
ON k.kod = l.kod_pocztowy

//zmiana maila jak ktoś już sobie zmienił 04.06.13
core_uzytkownicy -> sklep_uzytkownicy_dane;

//Lista Plików E:\wamp\www\maq

[f] mpdf - najlepsza biblioteka do generowania pdfów
[f] tcpdf - 2 najlepsza biblioteka do generowania pdfów
[f] html5bp - HTML 5 Boiler Plate
[f] mailingOC - mailing OpenCard z antwort
[f] TimeTable - testy js z patternami
[f] multi - multiselect multiplatform
[f] server - jquery file upload demo
[f] agile-uploader - uploader swf
[f] bootstrap - bootstrap
[f] designpatterns - php wzorce projektowe
[f] jquery-file-upload - jquery file upload demo
[f] animatable-master - js animacje
[f] Php Mailer - wysylanie maili przez phpa
[f] Test - moje próby
	\\
	asdfb.php - widget facebooka z boku
	chars.php - przerabiarka na nr ascii
	ean13.php - generowanko ean13 (nr kart)
	json.js - javascript próby ajaxa
	json.php - json próby php
	json1.php - cos jakas próba
	pu.php - trick z zdjęciem wbudowanym w html
	exc.php - php one liners
	asd.php - generowanie nr kart opencard i  generowanie kodów rabatowych
	pdf2txt.php - pobieranie tekstu z bardzo prostego pdf'a z bardziej skomplikowanymi jest trudniej
	ImageHelper.php - helper dla CakePhp
	dir.php - wybieracz z pliku i wrzucacz do bazy zdjecia openzdj.csv
	latlong.php - wybieracz z pliku i wrzucacz do bazy lat long lokacje.txt
	json2.php - wybieracz z pliku i wrzucacz do bazy lat long map.json
	woot.php - testy js
	asdf.php - config class for connecting with db's
	test.php - test do parsowania danych z kupbonu
	popup.php - popup css
	talon.php - grzesia Talon php
	img.php - curl img php
	dbmagic.php - manipulacja zdjęciami z opencardu
	vasco.php - login i hasło do vasco
	kodrabatowy.php - js do kodów rabatowych opencard

//js oneliners
//check if ie
function isIE() {
    return '\v' == 'v';
}

function chain(fn) {
    return function() {
        return fn.apply(this, arguments) || this;
    }
}

CanvasRenderingContext2D.prototype.fillRect =
    chain(CanvasRenderingContext2D.prototype.fillRect);

ctx.fillRect(0, 0, 10, 10).fillRect(90, 90, 10, 10).fillRect(0, 10, 100, 10);

//cake /tmp/cache/*
skasuj cache modeli przy zmianie bazy bo się sam nie zmieni:F

preg_replace("/[^a-z A-Z 0-9;ąćęłńóśżźĄĆĘŁŃÓŚŻŹ]/", "",$_POST['nazwa'])

//wersja jquery
$.fn.jquery

firefox -CreateProfile maq E:\AppData\Local\Temp\firefox

firefox -profile "E:\AppData\Local\Temp\firefox"

//making win7 bootable iso
oscdimg -n -m -b"E:\Windows7\BOOT\etfsboot.com" E:\Windows7\ E:\Win7_7048_x86_EN.iso

Mateusz Macherzyński Dolina 2/6 61-551 Poznań

http://www.rzeszowiak.pl/rss/Nieruchomosci-Mam-do-wynajecia.xml

52:04

prosta

czerwony czarny i bialy

db332e


znacznik

?>





//mysql backup dump export
mysqldump -u root -p --all-databases > alldb.sql

//Import:
mysql -u root -p < alldb.sql
check if folder empty

copy /b "E:\apps\Love\love.exe"+"E:\maq\lua\game.love" "E:\maq\lua-game\game.exe"

php bin/console debug:autowiring // check services
php bin/console --version //check version
php bin/console doctrine:schema:update --force // create tables

"E:\download\lapspy\magia.py"

http://roadtripbus.pl/chaczapuri-adzarskie/

folio 9470m

//instaling windows remotly
go into pxesrv.exe
ipxe-undionly.kpxe
menu.ipxe
go to shell
chain http://172.16.0.4/winpe/boot.ipxe

mount winodws 7 iso on computer as V:
net use \\172.16.0.4\v\setup.exe


softproc
pure maq soft auto process autonomus

maqmaq

egg singularity maqularity

not so complex

mulo

s kom plik ow any software

https://github.com/jeanlucaslima/linux-checklist/blob/master/ubuntu.md
https://github.com/huyingjie/Checklist-Checklist

Fuzzy Thinking
The Theory That Would Not Die

thinkcomplexity
27

//upgrade cakephp
composer require --update-with-dependencies "cakephp/cakephp:3.6.*"

<img src="yacht_race@fallback.jpg"
  srcset="
    img/yacht_race@mobile.jpg 320w,
    img/yacht_race@wide-mobile.jpg 480w,
    img/yacht_race@tablet.jpg 768w,
    img/yacht_race@desktop.jpg 1024w,
    img/yacht_race@hires.jpg 1280w"
  sizes="
    (max-width: 20em) 30vw,
    (max-width: 30em) 60vw,
    (max-width: 40em) 90vw"
  alt="A very exciting yacht race.">




czystek , rozmaryn , konopie indyjskie

//youtube search
py m3utoyoutube.py
//youtube download mp3
E:\maq\python\ytdownload>youtube-dl.exe --audio-format mp3 --extract-audio --batch-file madelist3.txtcomposer require components/angular.js
composer require holt59/cakephp3-bootstrap-helpers:dev-master

 bin\cake bake all Users
 bin\cake bake all Articles


//users model
namespace App\Model\Entity;

//users controller
public function beforeFilter(\Cake\Event\Event $event)
{
    $this->Auth->allow(['add']);
}

public function login()
{
    if ($this->request->is('post')) {
        $user = $this->Auth->identify();
        if ($user) {
            $this->Auth->setUser($user);
            return $this->redirect($this->Auth->redirectUrl());
        }
        $this->Flash->error('Your username or password is incorrect.');
    }
}

public function logout()
{
    $this->Flash->success('You are now logged out.');
    return $this->redirect($this->Auth->logout());
}

// src/Model/Table/UsersTable.php
namespace App\Model\Table;

use Cake\ORM\Table;
use Cake\Validation\Validator;

class UsersTable extends Table
{
    public function validationDefault(Validator $validator)
    {
        return $validator
            ->notEmpty('username', 'A username is required')
            ->notEmpty('password', 'A password is required')
            ->notEmpty('role', 'A role is required')
            ->add('role', 'inList', [
                'rule' => ['inList', ['admin', 'author']],
                'message' => 'Please enter a valid role'
            ]);
    }

}

//src/Template/Users/login.ctp
<h1>Login</h1>
<?= $this->Form->create() ?>
<?= $this->Form->input('email') ?>
<?= $this->Form->input('password') ?>
<?= $this->Form->button('Login') ?>
<?= $this->Form->end() ?>bin\cake bake all users --theme Bootstrap
bin\cake bake all accounts --theme Bootstrap
bin\cake bake all stores --theme Bootstrap
bin\cake bake all computers --theme Bootstrap
bin\cake bake all licenses --theme Bootstrap
bin\cake bake all products --theme Bootstrap

composer require elboletaire/twbs-cake-plugin

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE accounts;
TRUNCATE stores;
TRUNCATE computers;
TRUNCATE licenses;
SET FOREIGN_KEY_CHECKS = 1;

//Load Account old bad way queries build ground up not up to ground
        /*
        $accounts = $this->Accounts
            ->find()
            ->select(['id',
                's.name',
                'c.name',
                'l.id','l.name','l.computer_id','l.id_code','l.registration_key','l.system_key','l.activation_key','l.version_code','l.expired_date','l.active'])
            ->where(['Accounts.id' => $id])
            ->join([
                    's' => [
                        'table' => 'stores',
                        'type' => 'INNER',
                        'conditions' => 's.account_id = Accounts.id',
                    ],
                    'c' => [
                        'table' => 'computers',
                        'type' => 'INNER',
                        'conditions' => 'c.store_id = s.id',
                    ],
                    'l' => [
                        'table' => 'licenses',
                        'type' => 'INNER',
                        'conditions' => 'l.computer_id = c.id'
                    ]
                    ])
            ->order(['l.id_code'=>'ASC']);
        */


//modified core php files for logging
D:\wamp\www\cakecrm\vendor\cakephp\cakephp\src\Database\Log\QueryLogger.php
D:\wamp\www\cakecrm\vendor\cakephp\cakephp\src\Database\Log\LoggedQuery.php

//for one form
D:\wamp\www\crmspa\vendor\cakephp\cakephp\src\View\Helper\FormHelper.php :: 1787

//Flash for notifications
D:\wamp\www\crm\vendor\friendsofcake\bootstrap-ui\src\Template\Element\Flash\default.ctp

//update SDIO signs

 //update after cakephp update this file -> D:\wamp\www\cakecrm\vendor\cakephp\cakephp\src\Database\Log\QueryLogger.php

 Zmienić program_code w products
 Zmienić strukture licenses
 D:\wamp\www\cakecrm\src\Model\Table\LicensesTable.php -> Zmienić validatora na nowe Pola
 Generator Version ->





/to upload

http://localhost/convert-mysql-to-sqlite-master/

beforeSend: function(xhr) {
    xhr.setRequestHeader('Content-type', 'application/x-www-form-urlencoded');
},

/*

D:\wamp\www\ewypozycz\vendor\twbs\bootstrap\dist\css\bootstrap.min.css => D:\wamp\www\ewypozycz\webroot\css\bootstrap.min.css
D:\wamp\www\ewypozycz\vendor\twbs\bootstrap\dist\js\bootstrap.min.js => D:\wamp\www\ewypozycz\webroot\js\bootstrap.min.js

npm init
npm install --save-dev babel-loader babel-core babel-preset-react babel-preset-es2015
npm install webpack
npm install --save-dev react react-dom react-router
npm install --save-dev browser-sync-webpack-plugin

babel webroot/js/routes.js -o webroot/js/compiled.js
webpack webroot/js/compiled.js webroot/js/bundle.js

webpack --watch<?php
	composer create-project --prefer-dist cakephp/app uslugi
	edit composer.json
		->	"twitter/bootstrap": "dev-master",
        	"friendsofcake/bootstrap-ui": "~0.3",
        	"components/jquery": "dev-master"
	composer update
	php artisan asset:publish --path="vendor/twitter/bootstrap/bootstrap/css" webroot/css
	php artisan asset:publish --path="vendor/twitter/bootstrap/bootstrap/js" webroot/js

?>