[customer_setting]
db=Pg
database=bukuledger
username=mark
password=myrinix
host=localhost
port=5433
format=json
key=12345
#dbparam=mysql_enable_utf8=1


[customer_insert]
type=1
query=insert into customer (term, discount , creditlimit,blcode,customernumber, contactperson,email,company_setting_id,name,registered_number,tel,fax,street1,street2,city,postcode,state,country) values ({term}, {discount}, {creditlimit}, '{blcode}','{customernumber}','{contactperson}','{email}',  {company_setting_id} ,'{name}', '{registered_number}', '{tel}','{fax}','{street1}','{street2}','{city}','{postcode}', '{state}', '{country}');
setting=customer_setting
table=customer

[customer_update]
type=1
query=update customer  set term = {term}, discount = {discount}, creditlimit = {creditlimit},blcode = '{blcode}', customernumber = '{customernumber}',email = '{email}',contactperson ='{contactperson}',company_setting_id={company_setting_id}, name='{name}',registered_number='{registered_number}',tel = '{tel}',fax = '{fax}',street1 = '{street1}',street2 ='{street2}',city='{city}',postcode='{postcode}',state='{state}',country='{country}' where id = {id} and company_setting_id='{company_setting_id}';
setting=customer_setting


[customer_get]
type=0
query=select * from customer  where id={id} and company_setting_id={company_setting_id};
setting=customer_setting

[customer_delete]
type=0
query=delete from customer  where id={id} and company_setting_id={company_setting_id};
setting=customer_setting

[customer_search]
type=0
query=select * from customer  where (name like '%{query}%' or customernumber like '%{query}%') and company_setting_id={company_setting_id};
setting=customer_setting

[customer_tax]
type=0
query=select * from tax left join (select * from customer_tax where customer_id={id}) as foo on foo.tax_id = tax.id;
setting=customer_setting