Merge pull request #17706 from demeritcowboy/mysql-ssl-alt
[civicrm-core.git] / tests / phpunit / api / v3 / DashboardContactTest.php
1 <?php
2 /**
3 * File for the TestActionSchedule class
4 *
5 * (PHP 5)
6 *
7 * CiviCRM is free software; you can redistribute it and/or
8 * modify it under the terms of the GNU Affero General Public License
9 * as published by the Free Software Foundation; either version 3 of
10 * the License, or (at your option) any later version.
11 *
12 * CiviCRM is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 * GNU Affero General Public License for more details.
16 *
17 * You should have received a copy of the GNU Affero General Public
18 * License along with this program. If not, see
19 * <http://www.gnu.org/licenses/>.
20 */
21
22 /**
23 * Test APIv3 civicrm_action_schedule functions
24 *
25 * @package CiviCRM_APIv3
26 * @subpackage API_ActionSchedule
27 * @group headless
28 */
29 class api_v3_DashboardContactTest extends CiviUnitTestCase {
30 protected $_params;
31 protected $_params2;
32 protected $_entity = 'dashboard_contact';
33 protected $_apiversion = 3;
34
35 /**
36 * Test setup for every test.
37 *
38 * Connect to the database, truncate the tables that will be used
39 * and redirect stdin to a temporary file
40 */
41 public function setUp() {
42 // Connect to the database
43 parent::setUp();
44 $this->useTransaction(TRUE);
45 }
46
47 /**
48 * @param int $version
49 * @dataProvider versionThreeAndFour
50 */
51 public function testDashboardContactCreate($version) {
52 $this->_apiversion = $version;
53 $dashParams = [
54 'label' => 'New Dashlet element',
55 'name' => 'New Dashlet element',
56 'url' => 'civicrm/report/list&compid=99&reset=1',
57 'fullscreen_url' => 'civicrm/report/list&compid=99&reset=1&context=dashletFullscreen',
58 ];
59 $dashresult = $this->callAPISuccess('dashboard', 'create', $dashParams);
60 $contact = $this->callAPISuccess('contact', 'create', [
61 'first_name' => 'abc1',
62 'contact_type' => 'Individual',
63 'last_name' => 'xyz1',
64 'email' => 'abc@abc.com',
65 ]);
66 $oldCount = CRM_Core_DAO::singleValueQuery("select count(*) from civicrm_dashboard_contact where contact_id = {$contact['id']} AND is_active = 1 AND dashboard_id = {$dashresult['id']}");
67 $params = [
68 'contact_id' => $contact['id'],
69 'dashboard_id' => $dashresult['id'],
70 'is_active' => 1,
71 ];
72 $this->callAPISuccess('dashboard_contact', 'create', $params);
73 $newCount = CRM_Core_DAO::singleValueQuery("select count(*) from civicrm_dashboard_contact where contact_id = {$contact['id']} AND is_active = 1 AND dashboard_id = {$dashresult['id']}");
74 $this->assertEquals($oldCount + 1, $newCount);
75 }
76
77 }