public function testcreate_list_query()
{
$lead = new Lead();
//test with empty string params
$expected = "SELECT leads.*, users.user_name assigned_user_name,leads_cstm.* FROM leads \t\t\tLEFT JOIN users\n ON leads.assigned_user_id=users.id LEFT JOIN email_addr_bean_rel eabl ON eabl.bean_id = leads.id AND eabl.bean_module = 'Leads' and eabl.primary_address = 1 and eabl.deleted=0 LEFT JOIN email_addresses ea ON (ea.id = eabl.email_address_id) LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c where leads.deleted=0 ";
$actual = $lead->create_list_query('', '');
$this->assertSame($expected, $actual);
//test with valid string params
$expected = "SELECT leads.*, users.user_name assigned_user_name,leads_cstm.* FROM leads \t\t\tLEFT JOIN users\n ON leads.assigned_user_id=users.id LEFT JOIN email_addr_bean_rel eabl ON eabl.bean_id = leads.id AND eabl.bean_module = 'Leads' and eabl.primary_address = 1 and eabl.deleted=0 LEFT JOIN email_addresses ea ON (ea.id = eabl.email_address_id) LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c where (users.user_name=\"\") AND leads.deleted=0 ORDER BY leads.id";
$actual = $lead->create_list_query('leads.id', 'users.user_name=""');
$this->assertSame($expected, $actual);
}
