[DEV] OmegaBill

[alex]

*excited*

[Athar]

Interresting, waiting for a release so^^ (This week maybe?^^)

[oddyutza]

sorry for the delay,
had some personal issues!

!!! THIS IS A PRE-RELEASE, DON'T TEST IN PRODUCTION ENVIRONMENT !!!

here it goes..

http://www.itls.ro/billing-1.0.zip (size is to big for attach, The maximum size for that type of file is 1024 kilobytes. and the archive has over 1.5MB)
that is the link for downloading the script witch includes the following:
a. the database (ispcp_billing.sql)
b. gui interface (billing folder)
c. script that moves ispcp domains to billing clients (billing.php)

what is missing :
a. autoinvoice, still has some bugs, need to fix (recurring part)
b. new users for billing gui, permissions based
c. the auth is plain text -> need to change to md5 and to get it work with point b.
d. some other templates (reports, invoices)
- for the moment these are the main missing features

how do i install?
a. unzip the archive.
b. import the ispcp_billing.sql file into your db
c. copy the billing directory to /var/www/ispcp/gui/tools/
d. set the appropriate permissions to it
e. edit the file configuration.php witch is located in includes folder
f. add the alias to your 00_master.conf
eg:

Code:

Alias /billing  /var/www/ispcp/gui/tools/billing/

g. restart the webserver
h. open billing.php and configure it, maybe u`ll need it for moving clients from ispcp to billing.
i. open gui interface
j. login with username : admin & password : admin

what are the next steps :
- add the missing features
- add the option to edit admin user , name password
- implement the logging feature
- release for production environments.

PS : the invoice template is romanian, because i'm a romanian, and i intend to use this for my own production environment.

please test for bugs, and give a hollow!

[mr.x]

Hi,

thanks for your code !

I run a first quick test of your software and found some issues .-)

1. In your ispcp_billing.sql I miss

Quote:create ispcp_billing;
use ispcp_billing;

2. When I created a new item I was forwarded to your server
http://cp.itls.ro/billing/new/index.php instead of my local installation.

3. When I created a new client I got "http://cp.itls.ro/billing/new/index.php
" but all mandatory fields were field.

cheers,
Jan

---

Hi,

when I take a look at your table "logs" there is an issue with your IP address.

Quote:1 Successful login 192.168.0.2 2009-10-10 00:29:15

The private IP is not ok.

Cheers,
Jan

[oddyutza]

first of all,
hello
second:
in configuration.php at line 40 we have
"$installpath = "http://cp.itls.ro/billing/new";"
i bet with my life that u didn't change it! i can say touche on this!
for 1, it's a phpmyadmin dump, of course u don't have those!

for the 3'rd point... i don't get it! give me more details.


for the private ip issue, that is my local ip. perhaps that's why is there, don't u think?
let's assume that i'm working on lan (witch is very true).
and the logging is not yet implemented on that is next to be finished

Quote:- implement the logging feature

PS : i found a small issue in the sql file,
please change the adminid name username password email
adminid must be 1 so u have all permissions that u need for testing!

br++

[mr.x]

Hi,

(10-17-2009 09:34 PM)oddyutza Wrote:  in configuration.php at line 40 we have
"$installpath = "http://cp.itls.ro/billing/new";"
i bet with my life that u didn't change it!

you won .-)
But it wasn't descripted in your posting. May be a good idea to add it.

Quote:for the 3'rd point... i don't get it! give me more details.

I will do.
If you login as admin and go to "New Client".
Fill out all the fields. submit
I got "OmegaBill - New Client
Required fields were left blank."

OmegaBill - New Client
Required fields were left blank.

Quote:for the private ip issue, that is my local ip. perhaps that's why is there, don't u think?
let's assume that i'm working on lan (witch is very true).

ok, but shouldn't it be the address from the visitor?
What about implementing $_SERVER['REMOTE_ADDR'] to get the IP?

Quote:PS : i found a small issue in the sql file,
please change the adminid name username password email

I did it .-) Your defaults were inside .-)

Quote:adminid must be 1 so u have all permissions that u need for testing!

Thanks for this info ! This was important to get the right menu on the left side.

But due to this new information I have to report an other issue .-)

Quote:Error 404!
/billing/adduser.php
File Not Found!

The adduser.php is not inside your zip your provided.

Cheers,
Jan

[oddyutza]

hello again:
you are not reading my initial post

Quote:b. new users for billing gui, permissions based
c. the auth is plain text -> need to change to md5 and to get it work with point b.

equals no adduser.php

and regarding, logging, i`m repeating second time it is not yet implemented. we-ll talk about this when it's ready
PS: i was the visitor, so if my ip was local, is in the db

i saw the issue with the new client, for the moment just comment line 65 and 66 in new_client.php, it will be fixed in the next build! - thanks for this

[mr.x]

Hi

(10-17-2009 10:14 PM)oddyutza Wrote:  i saw the issue with the new client, for the moment just comment line 65 and 66 in new_client.php, it will be fixed in the next build! - thanks for this

take this code to fix it

Code:

// Ensure manditory fields were filled out - this prevents blank clients from being generated:
//if (((($_POST['name'] == "") or ($_POST['surname'] == "") or ($company == "") or ($address == "") or ($country = "") or ($city == "") or ($postalcode == "") or ($country == "") or ($bphone == "") or ($mobile == "" ) or ($email == "") or ($status == ""))))
if (  ($_POST['status'] == "") or
        ($_POST['surname'] == "") or
        ($_POST['name'] == "") or
        ($_POST['company'] == "") or
        ($_POST['address'] == "") or
        ($_POST['country'] = "") or
        ($_POST['city'] == "") or
        ($_POST['postalcode'] == "") or
        ($_POST['bphone'] == "") or
        ($_POST['mphone'] == "" ) or
        ($_POST['email'] == "")
        )
{ echo "Required fields were left blank."; exit; }

and in line 103

Code:

//echo "<meta http-equiv=Refresh content=1;URL='$installpath/admins/'>"
echo "<meta http-equiv=Refresh content=5;URL='$installpath/new_client.php'>"

Cheers,
Jan

---

Hi,

(10-17-2009 10:14 PM)oddyutza Wrote:  hello again:
you are not reading my initial post

Quote:b. new users for billing gui, permissions based
c. the auth is plain text -> need to change to md5 and to get it work with point b.

equals no adduser.php

I missed this point, sorry !

i saw the issue with the new client, for the moment just comment line 65 and 66 in new_client.php, it will be fixed in the next build! - thanks for this
[/quote]

[oddyutza]

i've added the fixes, thanks

don't be sorry we are all human, right?

[pgentoo]

I installed this, and so far it looks really nice!

Couple things though...

Item type should be driven from a DB table, so we can customize it to add other types, such as Domain Registration, SSL Certificate, etc. And still be able to list out different items under these types. Seems this is hardcoded right now which makes it not as configurable (without editing code).

When i add a new invoice:
- would be nice to add a date picker (jquery or similar) to the date field.
- What do i put in the "client" text box? This should be an autocomplete box, or a drop down of existing clients. No matter what i put in there, the client shows as an empty string on the invoice.
- item note and invoice note should go at the bottom (in my opinion) and both be text areas so you can fill in descriptive details about the item if needed.
- Possibility to add more than one item per invoice?

How do I login as a client, oOr can i? Would be great to be able to login as a client, see your invoices, see your balance, pay via creditcard, etc.

Keep up the great work!

-
pgentoo