From 04921c28ef1361ad129ab1604e6e0946ab4faa81 Mon Sep 17 00:00:00 2001
From: Jon Goldberg <jon@megaphonetech.com>
Date: Thu, 7 Jul 2022 19:42:01 -0400
Subject: [PATCH] Test Only - show FALSE is stored as NULL on custom boolean
 fields

---
 .../api/v4/Custom/FalseNotEqualsZeroTest.php  | 62 +++++++++++++++++++
 1 file changed, 62 insertions(+)
 create mode 100644 tests/phpunit/api/v4/Custom/FalseNotEqualsZeroTest.php

diff --git a/tests/phpunit/api/v4/Custom/FalseNotEqualsZeroTest.php b/tests/phpunit/api/v4/Custom/FalseNotEqualsZeroTest.php
new file mode 100644
index 0000000000..b3747d47ea
--- /dev/null
+++ b/tests/phpunit/api/v4/Custom/FalseNotEqualsZeroTest.php
@@ -0,0 +1,62 @@
+<?php
+
+/*
+ +--------------------------------------------------------------------+
+ | Copyright CiviCRM LLC. All rights reserved.                        |
+ |                                                                    |
+ | This work is published under the GNU AGPLv3 license with some      |
+ | permitted exceptions and without any warranty. For full license    |
+ | and copyright information, see https://civicrm.org/licensing       |
+ +--------------------------------------------------------------------+
+ */
+
+/**
+ *
+ * @package CRM
+ * @copyright CiviCRM LLC https://civicrm.org/licensing
+ */
+
+
+namespace api\v4\Custom;
+
+use Civi\Api4\Contact;
+use Civi\Api4\CustomField;
+use Civi\Api4\CustomGroup;
+
+/**
+ * @group headless
+ */
+class FalseNotEqualsZeroTest extends CustomTestBase {
+
+  public function testFalseNotEqualsZero() {
+
+    $customGroup = CustomGroup::create(FALSE)
+      ->addValue('title', 'MyContactFields')
+      ->addValue('extends', 'Contact')
+      ->execute()
+      ->first();
+
+    CustomField::create(FALSE)
+      ->addValue('label', 'Lightswitch')
+      ->addValue('custom_group_id', $customGroup['id'])
+      ->addValue('html_type', 'Radio')
+      ->addValue('data_type', 'Boolean')
+      ->execute();
+
+    $contactId = $this->createTestRecord('Contact', [
+      'first_name' => 'Red',
+      'last_name' => 'Tester',
+      'contact_type' => 'Individual',
+      'MyContactFields.Lightswitch' => FALSE,
+    ])['id'];
+
+    $result = Contact::get($contactId, 'Contact')
+      ->addSelect('MyContactFields.Lightswitch')
+      ->addWhere('id', '=', $contactId)
+      ->execute()
+      ->first()['MyContactFields.Lightswitch'];
+
+    $this->assertNotNull($result);
+  }
+
+}
-- 
2.25.1