Criminal Information System in OpenERP v6

Project :
Criminal Information System, Police Line Peshawar, Pakistan

 

Project Assigned By:
SP Investigation Umer Hayat

 

Project Completed  By:
Mohsin Yaseen

  

Software Tools Used:
OpenERP v6

 

Overview of Modules Developed and Customized in OpenERP:

Purpose:

1. Single Repository of all criminal record at district and province level
2. Quick searching of suspect or criminal from different perspective
3. Analysis of crime rate  from different perspective

Different Perspective Include:

• District wise crime
• Police station wise crime
• Nationality wise crime
• Main and sub caste wise crime
• Also Integration of above all perspective
• And much more.

68 Attributes of Each Criminal:In this criminal repository, 68 attributes are recorded for single criminal including its history of crime. Using these 68 attributes

1. We can analyze statistically ,
2. We can search criminal or suspect from 68 different attributes.

HRDC Survey(Statistical Analysis) Project in OpenERP

Project :
Third Party Validation of Performance of PTCs of Khyber Pakhtoonkhwa Pakistan

 

Project Assigned By:
Education Department of Khyber Pakhtoonkhwa Pakistan

 

Project Assigned To:
HRDC, IMSciences Peshawar Pakistan

 

Project Field Work Domain:
All Schools of Khyber Pakhtoonkhwa Pakistan (No of Sample Schools 5400)

 

Software for Statistical Analysis and Its Reporting:

First Time OpenEPR used as Statistical Analysis Software and for its Statistical Reporting

 

Software Tools Used:
OpenERP Framework, Python, Postgresql, PDF & MSExcel and Linux platform as OS

 

First Time OpenERP for Statistical Analysis and Its Reporting:
First Time OpenERP is used for strong statistical analysis and its reporting.  Approximately 89 users entered 5400 schools data using OpenERP interface from different terminals.Each school have 5 different survey forms i.e. Auditors Form, EDO Form, Secretary Form and Member Council Form.Each form has 40-50 different questions representing school different area of functionality, Physical Infrastructure, Financial Position, Teacher & Students Attendance, Parents & Teachers meeting, Meeting Agenda & its implementation rate  and much more.

 

Overview of Modules Developed in OpenERP for Statistical Analysis

 There are two modules developed for this project

1. Hrdc
2. Hrdc_reporting

• Module hrdc includes objects, tree views, forms views, update data files, wizards, menus and security rights files.
• Module hrdc_reporting includes 15 different statistical reports (including summary and details). These reports first print in pdf and we also export these report in MSExcel for report writing purpose.

OpenERP Developed Module Demonstration for Statistical Analysis 

•Module hrdc_reporting includes summary and detail (district level) reports, these reports extract from 5400 schools information ( each school have 4 different survey forms).

•These reports includes heavy statistical calculation and shows the situation of different area of functionality, Physical Infrastructure, Financial Position, Teacher & Students Attendance, Parents & Teachers meeting, Meeting Agenda & its implementation rate  and much more.

 

Statistical Reports in MSExcel 

•These all reports are also print in excel format for final report writing purpose.

•Final report presents to Education Department of Khyber Pakhtoonkhwa Pakistan.

 

HRDC Survey Project in OpenERP 1

 

 

 

HRDC Survey Project in OpenERP 2

 

 

 

HRDC Survey Project in OpenERP 3

 

PostgreSQL default password

Step 1: open terminal

Step 2: su postgres

Note: If you don’t remember the postgres (ubuntu user) password then use the command ‘sudo passwd postgres’

Stept 3: Type ‘psql’ and enter

Step 4: Use the following command to change the posgres user password

alter user postgres with password ‘newpassword’;

‘\q’ is used to exit psql

and Finsish

Enter a Bank statement in Openerp and Its Bank Reconciliation with Invoices:

I assume that viewer of this post have studied my first and second posts, I will continue using same example I have used in mention two post.

Previous example overview:

List of Suppliers partners: Ahmad, Asif, Dawood & Co, Naeem and Saleem & Co.

List of Customers partners: Crown & Co, Naseem & Co, Rafiq & Sons and Rizwan & Co

we have enter some supplier invoice using supplier partners, and similarly some customers invoices using some customers partners. Above invoices both of supplier and customers were based on accrual. The invoices status was open.

After these accrual basis accounting impact we receipt Rs. 3000 and Rs. 6000 from two customers Naseem & Co and Rafiq & Sons respectively in Bank Acc 123. we reconcile receipt voucher with customers invoices. The these two customers invoice status becomes done. Similarly we also make payment of Rs. 2000, Rs. 2500 and Rs. 1000 to our supplier Asif, Dawood & Co and Naeem respectively. After reconciliation the status of these three supplier invoice were also becomes done.

This was the preview of example we used;

Following are the some snaps , so that you can understand the account balances, partner balances, invoices status (open or done). After these snaps we will continue our topic.

Snap of account balances:

Trial Balance

Hire Purchase: Module Development example in openerp 5.0.0.1

In this tutorial, I will share how module develops in openerp. First I will explain the functionality of hire purchase (what we are going to develop), second I will develop hire purchase module in openerp. A simple explanation of hire purchase module is sale of goods in installment. In my example, I will ignore the interest portion of hire purchase. I just spread the price of good in number of monthly installment. I can say that, this module is a demo version of hire purchased without installment. In future I will extend this module with interest. In this tutorial I will focus on step by step development of module in openerp.
What hire purchase is read out the wiki about hire purchase, for detail of hire purchase also read wikieducator.

In this tutorial I will cover; how to create openerp objects (in .py file), interaction with object using openerp views (tree and form), openerp wizards and menuitem.

Step 1:

Create the following files and folders.

a. Folder having named ‘hirepurchase’ and 2nd folder having name ‘wizard’ in ‘hirepurchase’ folder.

b. Create the files in hirepurchase folder, i.e. __init__.py, __terp__.py, hirepurchase_view.xml and hirepurchase.py.

c. Create the files in wizard folder, i.e. __init__.py and wizard_pay_hirepurchaseinvoice.py

File structure: hirepurchase folder contains one folder (wizard) and four files (__init__.py, __terp__.py, hirepurchase_view.xml and hirepurchase.py). Wizard folder contains two files (__init__.py and wizard_pay_hirepurchaseinvoice.py)

Modules Development in OpenERP: View, Events, Menu and Actions

In this tutorial I will explain the syntax of views, events, menus and actions in openERP with some examples.
For detail we can check the documentation of design elements in openERP from
http://doc.openerp.com/developer/2_6_views_events/views/design_element.html

List of syntax and examples of different control in OpenERP
1. View file in OpenERP
2. Button in OpenERP
3. Menu Item in OpenERP
4. Tree View in OpenERP
5. Form View in OpenERP
6. View Action in OpenERP
7. Complete form view in OpenERP

1. View file in openERP
a. XML Declaration
b. OpenERP body tag

Syntax:

<?xml version="1.0" encoding="${encoding}"?>
<openerp>
    <data>
    	[view definitions]
    </data>
</openerp>

Asset Management by Simple Declining Method in OpenERP

I will use the example from one of my post to customize and use asset management module of openerp. Two steps already mention in my previous post like calculating profit and loss (making balance of income and expenses to zero for the respected year) and forwarding the balances of previous year to next year.

Post 1: Complete asset management example: http://tinyurl.com/39tmczh

Post 2: Calculating profit and loss: http://tinyurl.com/3ya4nfz

Post 3: Balance forwarding to new year: http://tinyurl.com/2f8laku

In this tutorial I will refer the to post1, post2 and post3 to eliminate the redundancy steps and I follow the steps of post1.

Step 1:

a. Create following three accounts from Financial Management → Configuration → Financial Accounting → Financial Accounts → List of Accounts.

OpenERP Developement and Dubugging in elipse

I am assuming that you have installed OpenERP Server and OpenERP Client

Step 1: Install Eclipse (sudo apt-get install elipse)

Step 2: Install PyDev plugin in eclipse using this link http://pydev.org/updates

a. Help → Install New Software.

b. In Install dialog box, Click Add.

c. Give name ‘pydev’ and type the path. i.e. http://pydev.org/updates.

d. click ok.

e. select pydev checkbox and follow the steps by clicking finish.

Remotely Access Postgresql from different clients

Step 1:

Open pg_hba.conf and postgresql.conf using below commands.

$ sudo gedit /etc/postgresql/8.4/main/postgresql.conf

$ sudo gedit /etc/postgresql/8.4/main/pg_hba.conf

Setp 2:

change the line listen_addresses =’localhost’ in postgresql.conf to listen_addresses=’*’

save the file

Step 3:

insert a new line under IPv4 local connections

host        all        all        192.168.1.0 255.255.255.0         trust

and save the file. Above mention IP  is the IP range that will connect to postgresql server

Step 4:

restart the postgresql service using below command.

sudo /etc/init.d/postgresql-8.4 restart

Step 5:

from postgresql client connect with postgresql server using following information

host: postgresql server ip

port: 5432

username: postgresql server username

password: password of above mention user name

Note: if clients gives error then try to connect after setting firewall off at postgresql server or define a new profile for this above mention port and IP in firewall.