Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
I don't know when that is going to be:(
I tried creating a new contact called mister client and put as his email, foo@ba2r.com.
Also, what will this do with existing clients/invoices in bamboo?It doesn't make any change in Bamboo database.
As in, as soon as I implement this patch, will I have duplicates because I had manually created the same people in bamboo before and invoices for them.You will not see BI clients at all anymore, so there should be no duplicate. Relations between clients and invoices should be broken because "id" of OG companies/contacts is not the same as the "id" of BI clients. Don't worry, invoices is the objective of the next version.
It didn't copy his email over to bamboo.There is no email field in BI clients... Only in BI clientcontact.
I appreciate the patch, but I think a lot of people do not use each entry as a company.True for b2c, this version supports billing individuals as a company.
Each contact is not a company. I think many people would not have every single contact as a different "company." What could we do?Actually i just did this as an exercise to evaluate BambooInvoice; we only do b2b so we never bill contacts although this version supports it.
For instance, myself, I have a workspace called "Clients" with all of the subworkspaces for different clients, etc. The clients workspace has all the contacts I have.In that case, joinning tables project_contacts and project_companies looks trivial to implement.
diff --git a/bamboo_system_files/application/models/clients_model.php b/bamboo_system_files/application/models/clients_model.php
index fc6da08..939db6c 100755
--- a/bamboo_system_files/application/models/clients_model.php
+++ b/bamboo_system_files/application/models/clients_model.php
@@ -26,8 +26,32 @@ class clients_model extends Model {
// $companies[$company->id] = $company->name;
// }
+ // goodified
+ return $this->db->query( '
+ select
+ ogc.id,
+ ogc.name,
+ ogc.address as address1,
+ ogc.address2 as address2,
+ ogc.city,
+ ogc.state as province,
+ ogc.zipcode as postal_code,
+ ogc.country as country,
+ ogc.homepage as website,
+ ogc.notes as client_notes,
+ ogts.value as tax_status,
+ ogtc.value as tax_code
+ from og_companies as ogc
+ left join (
+ select * from og_object_properties where name="tax_status"
+ ) ogts on ogts.rel_object_id = ogc.id
+ left join (
+ select * from og_object_properties where name="tax_code"
+ ) ogtc on ogtc.rel_object_id = ogc.id
+ ' );
+
+ // Originnal code
$this->db->orderby('name', 'asc');
-
return $this->db->get('clients');
}
@@ -35,6 +59,30 @@ class clients_model extends Model {
function get_client_info($id, $fields = '*')
{
+ // goodified
+ return $this->db->query( '
+ select
+ ogc.id,
+ ogc.name,
+ ogc.address as address1,
+ ogc.address2 as address2,
+ ogc.city,
+ ogc.state as province,
+ ogc.zipcode as postal_code,
+ ogc.country as country,
+ ogc.homepage as website,
+ ogc.notes as client_notes,
+ ogts.value as tax_status,
+ ogtc.value as tax_code
+ from og_companies as ogc
+ left join (
+ select * from og_object_properties where name="tax_status"
+ ) ogts on ogts.rel_object_id = ogc.id
+ left join (
+ select * from og_object_properties where name="tax_code"
+ ) ogtc on ogtc.rel_object_id = ogc.id
+ where ogc.id = ' . intval( $id ) )->row( );
+
$this->db->select($fields);
$this->db->where('id', $id);