Showing posts with label ubrzanje. Show all posts

Monday, October 15, 2018

MySQl, Excel, SQlite

26 slova engleskih
A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z

CREATE TABLE excel (
A VARCHAR(40),
B VARCHAR(40),
C VARCHAR(40),
D VARCHAR(40),
E VARCHAR(40),
F VARCHAR(40),
G VARCHAR(40),
H VARCHAR(40),
I VARCHAR(40),
J VARCHAR(40),
K VARCHAR(40),
L VARCHAR(40),
M VARCHAR(40),
N VARCHAR(40),
O VARCHAR(40),
P VARCHAR(40),
Q VARCHAR(40),
R VARCHAR(40),
S VARCHAR(40),
T VARCHAR(40),
U VARCHAR(40),
V VARCHAR(40),
W VARCHAR(40),
X VARCHAR(40),
Y VARCHAR(40),
Z VARCHAR(40)
);

studenti.db
Select * FROM isplata where iznos>0
rb, oznaka, ime, adresa, iznos, broj_racuna

="UPDATE ispalata SET oznaka = 1, ime='"&C2&"', iznos='"&F2&"', broj_racuna='"&E2&"' WHERE rb=1;"

="UPDATE isplata SET oznaka = '"&A2&"', ime='"&C2&"', iznos='"&F2&"', broj_racuna='"&E2&"' WHERE rb=1;"

="UPDATE isplata SET oznaka = '"&A6&"', ime='"&B6&"', iznos='"&G6&"', broj_racuna='"&F6&"', adresa='"&C6&"' WHERE rb=1;"

="UPDATE isplata SET oznaka = '"&A2&"-"&B2&"', ime='"&C2&"', iznos='"&J2&"', broj_racuna='"&H2&"' WHERE rb=1;"

xxx-xxxxxxxx-xx

="INSERT INTO table_name VALUES('"&A1&"','"&B1&"','"&C1&"')"

INSERT INTO tbl_sample(first_name, last_name) VALUES('ime','prezime');

tbl_sample(first_name, last_name

CREATE TABLE IF NOT EXISTS eksel2 (
id bigint(20) NOT NULL AUTO_INCREMENT,
c01 text NULL,
c02 text NULL,
c03 text NULL,
c04 text NULL,
c05 text NULL,
c06 text NULL,
c07 text NULL,
c08 text NULL,
c09 text NULL,
c10 text NULL,
c11 text NULL,
c12 text NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO eksel2(c01,c02,c03,c04,c05,c06,c07,c08,c09,c10,c11,c12) VALUES('1','2','3','4','5','6','7','8','9','10','11','12');

SQLite...:

CREATE TABLE `godisnji` (
`rb` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
`ime` VARCHAR(40),
`jmbg` VARCHAR(13),
`po_osnovu_doprinosa_na_radu` INTEGER,
`po_osnovu_strucne_spreme` INTEGER,
`po_osnovu_godina_rada` INTEGER,
`po_osnovu_uslova_rada` INTEGER,
`po_osnovu_brige_o_deci` INTEGER,
`broj_maloletnih` INTEGER,
`broj_dece_do_14god` INTEGER,
`adresa` VARCHAR(80),
`telefon` VARCHAR(40),
`napomena` VARCHAR(80),
`datum_donosenja_resenja` VARCHAR(10),
`ukupno` INTEGER
);

CREATE TABLE `putnik` (
`oznaka` TEXT,
`ime` TEXT,
`ADRESA` TEXT,
`RODITELJ` TEXT,
`JMBG` TEXT,
`SKOLA` TEXT,
`GRAD` TEXT,
`relacija` INTEGER,
`naziv_relacije` TEXT,
`prvi_mesec` INTEGER,
`drugi_mesec` INTEGER,
`iznos` REAL,
`broj_racuna` TEXT,
`procenat` INTEGER,
`prvi_iznos` REAL,
`drugi_iznos` REAL
);

CREATE TABLE `osnovna_sredstva` (
`rb` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
`naziv` VARCHAR(80),
`inventarski_broj` VARCHAR(20),
`serijski_broj` VARCHAR(80),
`model` VARCHAR(40),
`windows_key` VARCHAR(80),
`opis` VARCHAR(2000),
`sadrzaj` VARCHAR(2000),
`napomena` VARCHAR(200),
`vrednost` REAL,
`amortizacija` REAL,
`datum` VARCHAR(20),
`proizvodjac` VARCHAR(80),
`javna_nabavka` VARCHAR(200),
`revers` VARCHAR(200),
`trebovanje` VARCHAR(200),
`odgovorna_osoba` VARCHAR(60),
`storno` VARCHAR(40)
);

CREATE TABLE `finansije-glavna-knjiga` (
`rb` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
`naslov` VARCHAR(80),
`duguje` REAL,
`potrazuje` REAL,
`saldo` REAL,
`konto` VARCHAR(20),
`partner-kupac-dobavljac` VARCHAR(40),
`napomena` VARCHAR(1000),
`datum` VARCHAR(10),
`storno` VARCHAR(10)

);

CREATE TABLE `kontni-plan` (
`rb` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
`sifra-konta` VARCHAR(20),

`naziv-konta` VARCHAR(80)

);

CREATE TABLE `partner` (
`rb` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
`sifra-partnera` VARCHAR(40),

`naziv-partnera` VARCHAR(80)

);

PRIMER praćenja sopstvenih troškova u prodavnici:

https://sr.wikipedia.org/sr-el/Dvojno_knjigovodstvo

http://informax.serveftp.com/progtools.asp

Friday, October 5, 2018

The endless possibilities

https://www.linuxliteos.com/download.php

FREEWARE ZA SVAKI DAN

Drugari, instalirajte što pre ovaj izvanredan operativni sistem, jer isti ne smeta Windowsu, možete imati na primer Microsoft Windows 10, a pored njega i ovaj predivni operativni sistem kao alternativu.

On je u svakom slučaju mnogo brži od Microsoft Windows-a, neki kažu da je i lepši, mada se o ukusima ne raspravlja.

Imajte Microsoft Windows 10 kao i do sada, ali instalirajte i ovaj operativni sistem. Instalacija je veoma jednostavna i može se obaviti iz samog Windows 10 operativnog sistema koristeći mali instalacioni fajl.

Ukoliko imate neko pitanje ili Vam zatreba pomoć, ja sam Vam uvek na raspolaganju kao i do sada 24 sata, 7 dana u nedelji.

Ovaj linux fabrički ugradjuju u brand new Asus laptopove, tako da predstavlja sasvim solidnu zamenu kako za Windows, tako i za ostale Linux distribucije, a da ne govorimo o Android OS.

Ovaj Linux veoma podseća kako na Microsoft Windows 10, tako i na Android, takoreći od oba sveta po malo šmeka:

Ukoliko i Vi imate da reklamirate neki svoj proizvod ili slične sadržaje, blogove, knjige i sajtove slobodno me kontaktirajte.

https://www.bcgroup-online.com/laptopovi/asus-x540na_gq052-%28pentium-n4200.-4gb.-1tb%29-48144

https://www.bcgroup-online.com/laptopovi/asus-x540na_dm164-%28full-hd.-pentium-quadcore-n4200.-4gb.-500gb%29-48008

ENDLESS OS

Preloaded with content

Endless comes with more than 100 free apps and powerful tools that don’t require an Internet connection.

Simple as a smartphone

Endless is designed to feel natural and intuitive, making it easy to use even if you have little or no computer experience.

No hidden costs

Endless is free to download, and software updates are automatically included. It's also virus-resistant, saving you money at every step.

Connect to the world

When you are connected to the internet, Endless works like any other computer, so you can search the web or stay in touch with friends.

Endless OS Short (English) from Endless on Vimeo.

Još mojih lepih i korisnih aplikacija:
Super korisna aplikacija

https://vimeo.com/168222535

https://endlessos.com/

Endless OS Short (English) from Endless on Vimeo.

Sunday, July 22, 2018

Faster DNS

Setup on PC

Setting up 1.1.1.1 takes two minutes and requires no technical skill or special software. Even if you’re a computer novice, pick your device below for an easy-to-follow setup guide.

Click on the Start menu, then click on Control Panel.
Click on Network and Internet.
Click on Change Adapter Settings.
Right click on the Wi-Fi network you are connected to, then click Properties.
Select Internet Protocol Version 4 (or Version 6 if desired).
Click Properties.
Write down any existing DNS server entries for future reference.
Click Use The Following DNS Server Addresses.
Replace those addresses with the 1.1.1.1 DNS addresses:
- For IPv4: 1.1.1.1 and 1.0.0.1
- For IPv6: 2606:4700:4700::1111 and 2606:4700:4700::1001
Click OK, then Close.
Restart your browser.
You’re all set! Your device now has faster, more private DNS servers ✌️✌️

https://1.1.1.1/

https://www.thebest10websitebuilders.com

http://www.rgz.gov.rs/registri-rgz-a/evidencija-re%C5%A1enja-o-ru%C5%A1enju-bespravno-podignutih-objekata

https://www.phpflow.com/php/how-to-add-edit-and-delete-a-row-in-jquery-flexigrid-using-php-and-mysql/

https://www.phpflow.com/php/simple-example-bootgrid-server-side-with-php-mysql-and-ajax/

https://stackoverflow.com/questions/6386975/flexigrid-examples-returning-data-from-mysql

http://www.lynnnayko.com/2011/12/using-flexigrid-with-php-and-mysql.html

http://planetwatt.com/new/index.php/downloads/

http://www.elivecd.org/ufaqs/tools-to-record-elive-linux-in-an-usb-drive/

http://www.elivecd.org/download/stable/

Beogradsko programiranje

beogradsko programiranje