Istilah Akutansi

Invoice = Faktur

Sales = Penjualan

Sales Invoice = Faktur Penjualan

Sales Delivery = Pengiriman Penjualan

Order = Memesan

Sales Quote = Kutipan Penjualan

Quote = Kutipan

Sales Order = Order Penjualan

Purchase = Pembelian

Purchase Order (PO) = Pesanan Pembelian

Purchase Delivery = Pengiriman Pembelian

Purchase Quote = Kutipan Pembelian

Purchase Invoice = Faktur Pembelian

Expenses/Cost = Biaya

RBAC Standart Default

 Standar table database RBAC.

  1. user
  2. role
  3. user_role
  4. group
  5. role_group
  6. right
  7. group_right
kata - kata right, right itu bisa diartikan access atau permission.

Ilustrasinya seperti ini 1 user bisa mempunyai banyak role. 1 role bisa mempunyai banyak group, dan 1 group bisa mempunyai banyak right.



Sample Apache Kafka

Learning Apache Kafka from https://kafka.apache.org/quickstart

I'm use OS Window

My Note:

Step 1: Download the code
http://www-us.apache.org/dist/kafka/2.0.0/kafka_2.11-2.0.0.tgz
unzip and copy to c:\

Step 2: Start the server
C:\kafka_2.11-2.0.0\bin\windows>zookeeper-server-start.bat C:\kafka_2.11-2.0.0\config\zookeeper.properties
C:\kafka_2.11-2.0.0\bin\windows>kafka-server-start.bat C:\kafka_2.11-2.0.0\config\server.properties

Step 3: Create a topic
C:\kafka_2.11-2.0.0\bin\windows>kafka-topics.bat --create --zookeeper localhost:2181 --replication-factor 1 --partitions 1 --topic test
Created topic "test".

C:\kafka_2.11-2.0.0\bin\windows>kafka-topics.bat --list --zookeeper localhost:2181
test

Step 4: Send some messages
C:\kafka_2.11-2.0.0\bin\windows>kafka-console-producer.bat --broker-list localhost:9092 --topic test
>This is a message
>This is another message
>Terminate batch job (Y/N)? y

Step 5: Start a consumer
C:\kafka_2.11-2.0.0\bin\windows>kafka-console-consumer.bat --bootstrap-server localhost:9092 --topic test --from-beginning
This is a message
This is another message

Step 6: Setting up a multi-broker cluster
C:\kafka_2.11-2.0.0\config>copy server.properties c:\kafka_2.11-2.0.0\config\server-1.properties
1 file(s) copied.
C:\kafka_2.11-2.0.0\config>copy server.properties c:\kafka_2.11-2.0.0\config\server-2.properties
1 file(s) copied.
config/server-1.properties:
broker.id=1
listeners=PLAINTEXT://:9093
log.dirs=/tmp/kafka-logs-1
config/server-2.properties:
broker.id=2
listeners=PLAINTEXT://:9094
log.dirs=/tmp/kafka-logs-2

C:\kafka_2.11-2.0.0\bin\windows>kafka-server-start.bat c:\kafka_2.11-2.0.0\config\server-1.properties
C:\kafka_2.11-2.0.0\bin\windows>kafka-server-start.bat c:\kafka_2.11-2.0.0\config\server-2.properties

3 ERROR change 2
C:\kafka_2.11-2.0.0\bin\windows>kafka-topics.bat --create --zookeeper localhost:2181 --replication-factor 2 --partitions 1 --topic my-replicated-topic
Created topic "my-replicated-topic".

C:\kafka_2.11-2.0.0\bin\windows>kafka-topics.bat --describe --zookeeper localhost:2181 --topic my-replicated-topic
Topic:my-replicated-topic PartitionCount:1 ReplicationFactor:2 Configs:
Topic: my-replicated-topic Partition: 0 Leader: 1 Replicas: 1,0 Isr: 1,0
C:\kafka_2.11-2.0.0\bin\windows>kafka-topics.bat --describe --zookeeper localhost:2181 --topic test
Topic:test PartitionCount:1 ReplicationFactor:1 Configs:
Topic: test Partition: 0 Leader: 0 Replicas: 0 Isr: 0

C:\kafka_2.11-2.0.0\bin\windows>kafka-console-producer.bat --broker-list localhost:9092 --topic my-replicated-topic
>my test message 1
>my test message 2
>Terminate batch job (Y/N)? y

C:\kafka_2.11-2.0.0\bin\windows>kafka-console-consumer.bat --bootstrap-server localhost:9092 --from-beginning --topic my-replicated-topic
my test message 1
my test message 2
Processed a total of 2 messages
Terminate batch job (Y/N)? y

C:\kafka_2.11-2.0.0\bin\windows>wmic process where "caption = 'java.exe' and commandline like '%server-1.properties%'" get processid
ProcessId
2168

C:\kafka_2.11-2.0.0\bin\windows>taskkill /pid 2168 /f
SUCCESS: The process with PID 2168 has been terminated.

C:\kafka_2.11-2.0.0\bin\windows>kafka-topics.bat --describe --zookeeper localhost:2181 --topic my-replicated-topic
Topic:my-replicated-topic PartitionCount:1 ReplicationFactor:2 Configs:
Topic: my-replicated-topic Partition: 0 Leader: 0 Replicas: 1,0 Isr: 0

C:\kafka_2.11-2.0.0\bin\windows>kafka-console-consumer.bat --bootstrap-server localhost:9092 --from-beginning --topic my-replicated-topic
my test message 1
my test message 2
Processed a total of 2 messages
Terminate batch job (Y/N)? y

Step 7: Use Kafka Connect to import/export data

C:\kafka_2.11-2.0.0\bin\windows> echo foo> test.txt
C:\kafka_2.11-2.0.0\bin\windows> echo bar>> test.txt

ERROR
C:\kafka_2.11-2.0.0\bin\windows>connect-standalone.bat c:\kafka_2.11-2.0.0\config\connect-standalone.properties c:\kafka_2.11-2.0.0\config\connect-file-source.properties c:\kafka_2.11-2.0.0\config\connect-file-sink.properties

C:\kafka_2.11-2.0.0\bin\windows>kafka-console-consumer.bat --bootstrap-server localhost:9092 --topic connect-test --from-beginning
{"schema":{"type":"string","optional":false},"payload":"foo"}
{"schema":{"type":"string","optional":false},"payload":"bar"}

C:\kafka_2.11-2.0.0\bin\windows>kafka-console-consumer.bat --bootstrap-server localhost:9092 --topic connect-test --from-beginning
{"schema":{"type":"string","optional":false},"payload":"foo"}
{"schema":{"type":"string","optional":false},"payload":"bar"}
{"schema":{"type":"string","optional":false},"payload":"Another line"}
Processed a total of 3 messages
Terminate batch job (Y/N)? y