PHP EmailMarketing::create_export_query Examples

Example #1

File: EmailMarketingTest.php Project: sacredwebsite/SuiteCRM

 public function testcreate_export_query()
 {
     $emailMarketing = new EmailMarketing();
     //test with empty string params
     $expected = " SELECT  email_marketing.*  , jt0.name template_name , jt0.assigned_user_id template_name_owner  , 'EmailTemplates' template_name_mod FROM email_marketing   LEFT JOIN  email_templates jt0 ON email_marketing.template_id=jt0.id AND jt0.deleted=0\n\n AND jt0.deleted=0 where email_marketing.deleted=0";
     $actual = $emailMarketing->create_export_query('', '');
     $this->assertSame($expected, $actual);
     //test with valid string params
     $expected = " SELECT  email_marketing.*  , jt0.name template_name , jt0.assigned_user_id template_name_owner  , 'EmailTemplates' template_name_mod FROM email_marketing   LEFT JOIN  email_templates jt0 ON email_marketing.template_id=jt0.id AND jt0.deleted=0\n\n AND jt0.deleted=0 where (email_marketing.name=\"\") AND email_marketing.deleted=0";
     $actual = $emailMarketing->create_export_query('email_marketing.id', 'email_marketing.name=""');
     $this->assertSame($expected, $actual);
 }