Class: CampaignList
- Inherits:
-
ActiveRecord::Base
- Object
- ActiveRecord::Base
- CampaignList
- Defined in:
- lib/vtiger/base.rb
Class Method Summary collapse
- .convert(mysql_res) ⇒ Object
- .find_accounts_by_campaign(id) ⇒ Object
- .find_contacts_by_campaign(id) ⇒ Object
-
.find_contacts_by_customfield(field, value, extra = '') ⇒ Object
“,customfield as latest_receipt”.
- .find_contacts_by_email_and_keynull(key, value) ⇒ Object
- .find_leads_by_campaign(id) ⇒ Object
- .scott_connect(dbhost, dbname, dbuser, dbpasswd) ⇒ Object
- .scott_connect2(dbhost, dbname, dbuser, dbpasswd) ⇒ Object
Class Method Details
.convert(mysql_res) ⇒ Object
40 41 42 43 44 45 46 |
# File 'lib/vtiger/base.rb', line 40 def self.convert(mysql_res) rows=[] mysql_res.each_hash { |h| rows << h # puts "h is #{h} #{h.inspect} #{h.class}" } rows end |
.find_accounts_by_campaign(id) ⇒ Object
55 56 57 58 |
# File 'lib/vtiger/base.rb', line 55 def self.find_accounts_by_campaign(id) mysql_results=CampaignList.connection.execute("select vtiger_account.email1 as 'email', vtiger_account.accountname, vtiger_campaignaccountrel.campaignid from vtiger_account left join vtiger_campaignaccountrel on vtiger_account.accountid=vtiger_campaignaccountrel.accountid where vtiger_campaignaccountrel.campaignid=#{id} and emailoptout=0;;") CampaignList.convert(mysql_results) end |
.find_contacts_by_campaign(id) ⇒ Object
47 48 49 50 |
# File 'lib/vtiger/base.rb', line 47 def self.find_contacts_by_campaign(id) mysql_results=CampaignList.connection.execute("select vtiger_contactdetails.email, vtiger_contactdetails.firstname, vtiger_contactdetails.lastname, vtiger_campaigncontrel.campaignid from vtiger_contactdetails left join vtiger_campaigncontrel on vtiger_contactdetails.contactid=vtiger_campaigncontrel.contactid where vtiger_campaigncontrel.campaignid=#{id} and emailoptout=0;") CampaignList.convert(mysql_results) end |
.find_contacts_by_customfield(field, value, extra = '') ⇒ Object
“,customfield as latest_receipt”
59 60 61 62 63 64 |
# File 'lib/vtiger/base.rb', line 59 def self.find_contacts_by_customfield(field,value,extra='') # ",customfield as latest_receipt" puts "field: #{field} value #{value}" mysql_results=CampaignList.connection.execute("select vtiger_contactdetails.contactid as 'id',vtiger_contactdetails.email as 'email'#{extra},#{field} as 'tsipid' from vtiger_contactdetails left join vtiger_contactscf on vtiger_contactdetails.contactid=vtiger_contactscf.contactid where #{field} like '#{value}%';") # puts "after campaign #{mysql_results}" CampaignList.convert(mysql_results) end |
.find_contacts_by_email_and_keynull(key, value) ⇒ Object
65 66 67 68 69 70 |
# File 'lib/vtiger/base.rb', line 65 def self.find_contacts_by_email_and_keynull(key,value) puts "key: #{key} value #{value}" mysql_results=CampaignList.connection.execute("select vtiger_contactdetails.contactid as 'id',vtiger_contactdetails.email as 'email', #{key} as 'tsipid' from vtiger_contactdetails left join vtiger_contactscf on vtiger_contactdetails.contactid=vtiger_contactscf.contactid where vtiger_contactdetails.email like '#{value}%' and #{key} like '';") # puts "after campaign #{mysql_results}" CampaignList.convert(mysql_results) end |
.find_leads_by_campaign(id) ⇒ Object
51 52 53 54 |
# File 'lib/vtiger/base.rb', line 51 def self.find_leads_by_campaign(id) mysql_results=CampaignList.connection.execute("select vtiger_leaddetails.email, vtiger_leaddetails.firstname, vtiger_leaddetails.lastname, vtiger_campaignleadrel.campaignid from vtiger_leaddetails left join vtiger_campaignleadrel on vtiger_leaddetails.leadid=vtiger_campaignleadrel.leadid where vtiger_campaignleadrel.campaignid=#{id};") CampaignList.convert(mysql_results) end |
.scott_connect(dbhost, dbname, dbuser, dbpasswd) ⇒ Object
20 21 22 23 24 25 26 27 28 29 |
# File 'lib/vtiger/base.rb', line 20 def self.scott_connect(dbhost, dbname, dbuser,dbpasswd) CampaignList.table_name='vtiger_campaigncontrel' @myconnection =CampaignList.establish_connection( :adapter => "mysql", :host => dbhost, :username => dbuser, :password => dbpasswd, :database => dbname ) end |
.scott_connect2(dbhost, dbname, dbuser, dbpasswd) ⇒ Object
30 31 32 33 34 35 36 37 38 39 |
# File 'lib/vtiger/base.rb', line 30 def self.scott_connect2(dbhost, dbname, dbuser,dbpasswd) # CampaignList.set_table_name('vtiger_campaigncontrel') @myconnection =CampaignList.establish_connection( :adapter => "mysql", :host => dbhost, :username => dbuser, :password => dbpasswd, :database => dbname ) end |