Class: CampaignList

Inherits:
ActiveRecord::Base
  • Object
show all
Defined in:
lib/vtiger/base.rb

Class Method Summary collapse

Class Method Details

.convert(mysql_res) ⇒ Object 



39
40
41
42
43
44
45
 
# File 'lib/vtiger/base.rb', line 39

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 



54
55
56
57
 
# File 'lib/vtiger/base.rb', line 54

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 



46
47
48
49
 
# File 'lib/vtiger/base.rb', line 46

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) ⇒ Object 



58
59
60
61
62
63
 
# File 'lib/vtiger/base.rb', line 58

def self.find_contacts_by_customfield(field,value)
  puts "field: #{field} value #{value}"
  mysql_results=CampaignList.connection.execute("select vtiger_contactdetails.contactid as 'id',vtiger_contactdetails.email as 'email',#{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 



64
65
66
67
68
69
 
# File 'lib/vtiger/base.rb', line 64

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 



50
51
52
53
 
# File 'lib/vtiger/base.rb', line 50

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 



19
20
21
22
23
24
25
26
27
28
 
# File 'lib/vtiger/base.rb', line 19

def self.scott_connect(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

.scott_connect2(dbhost, dbname, dbuser, dbpasswd) ⇒ Object 



29
30
31
32
33
34
35
36
37
38
 
# File 'lib/vtiger/base.rb', line 29

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