Sharing Aplikasi CI+YUI sistem inventaris barang

8:11 PM Source Code 4 Comments

Hi all friends ...

This time I want to share applications CodeIgniter (CI) inventory system that collaborated with the YUI (Yahoo UI).

Please click here: http://kenalanwar.co.cc/source-code/elektro-pnj.zip

Enjoy ...

Regards,

Nur Cholikul Anwar

CREATE DATABASE db_inventaris_elektro

CREATE TABLE t_list_barang
(
  f_id serial NOT NULL,
  f_kode character varying(50) NOT NULL,
  f_nama_barang character varying(100) NOT NULL,
  f_tipe_barang character varying(100),
  f_jumlah character varying(15) NOT NULL,
  ref_master_lokasi_f_id integer NOT NULL,
  f_jumlah_kondisi_baik character varying(15) NOT NULL,
  f_tanggal_masuk date NOT NULL,
  f_status_hapus boolean NOT NULL DEFAULT false,
  CONSTRAINT t_list_barang_pkey PRIMARY KEY (f_id),
  CONSTRAINT t_list_barang_ref_master_lokasi_f_id_fkey FOREIGN KEY (ref_master_lokasi_f_id)
      REFERENCES t_master_lokasi (f_id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE RESTRICT
)

CREATE TABLE t_master_lokasi
(
  f_id serial NOT NULL,
  f_kode_lokasi character varying(15) NOT NULL,
  f_nama_lokasi character varying(50) NOT NULL,
  CONSTRAINT t_master_lokasi_pkey PRIMARY KEY (f_id),
  CONSTRAINT t_master_lokasi_f_kode_lokasi_key UNIQUE (f_kode_lokasi),
  CONSTRAINT t_master_lokasi_f_nama_lokasi_key UNIQUE (f_nama_lokasi)
)

CREATE TABLE t_session
(
  session_id character varying(40) NOT NULL DEFAULT 0,
  ip_address character varying(16) NOT NULL DEFAULT 0,
  user_agent character varying(120) NOT NULL,
  last_activity integer NOT NULL DEFAULT 0,
  user_data text NOT NULL DEFAULT ''::text,
  CONSTRAINT ci_sessions_pkey PRIMARY KEY (session_id)
)

CREATE TABLE t_user
(
  f_id serial NOT NULL,
  f_username character varying(20) NOT NULL,
  f_password character varying(50) NOT NULL,
  f_nama character varying(50),
  CONSTRAINT t_user_pkey PRIMARY KEY (f_id),
  CONSTRAINT t_user_f_username_key UNIQUE (f_username)
)