<?php
namespace Stemcell\Datacollection\Setup\Patch\Data;

use Magento\Framework\Setup\Patch\DataPatchInterface;
use Magento\Framework\App\ResourceConnection;

class InitializationData implements DataPatchInterface
{
    /**
     * @var ResourceConnection
     */
    private $resource;

    public function __construct(
        ResourceConnection $resource
    ) {
        $this->resource = $resource;
    }

    public function apply()
    {
        $connection = $this->resource->getConnection();
        //$tableName = $this->resource->getTableName('your_table_name');

        $sql = "INSERT INTO `alekseon_custom_form` (`created_at`, `identifier`, `group_fields_in`, `admin_note`)
VALUES
	('2025-08-25 15:58:32', 'Inquiry', 'fieldsets', NULL),
	('2025-08-26 03:00:21', 'Lecture', 'fieldsets', NULL),
	('2025-08-26 05:03:59', 'Livedemo', 'fieldsets', NULL);
";
        $connection->query($sql);

        $sql = "INSERT INTO `alekseon_custom_form_tab` (`label`, `form_id`)
VALUES
	('stemcell_inquiry', '1'),
	('stemcell_lecture', '2'),
	('stemcell_livedemo', '3');
";
        $connection->query($sql);

        $sql = "INSERT INTO `alekseon_custom_form_record_attribute` (`entity_type_code`, `attribute_code`, `frontend_input`, `backend_type`, `frontend_label`, `source_model`, `backend_model`, `scope`, `is_required`, `visible_in_grid`, `sort_order`, `note`, `is_user_defined`, `default_value`, `is_unique`, `frontend_class`, `is_wysiwyg_enabled`, `group_code`, `input_validator`, `attribute_extra_params`, `has_option_codes`, `form_id`, `identifier`, `input_visibility`)
VALUES
	('alekseon_custom_form_record', 'inquiry_username', 'text', 'varchar', '姓名', NULL, NULL, '0', '1', '1', '1', NULL, '1', NULL, '0', NULL, '0', '1', '0', '{\"input_params\":[]}', '0', '1', 'username', '1'),
	('alekseon_custom_form_record', 'inquiry_mobile', 'text', 'varchar', '手机号码', NULL, NULL, '0', '1', '1', '10', NULL, '1', NULL, '0', NULL, '0', '1', '0', '{\"input_params\":[]}', '0', '1', 'mobile', '1'),
	('alekseon_custom_form_record', 'inquiry_email', 'text', 'varchar', '电子邮箱', NULL, NULL, '0', '1', '1', '20', NULL, '1', NULL, '0', NULL, '0', '1', '0', '{\"input_params\":[]}', '0', '1', 'email', '1'),
	('alekseon_custom_form_record', 'inquiry_company', 'text', 'varchar', '公司单位', NULL, NULL, '0', '1', '1', '30', NULL, '1', NULL, '0', NULL, '0', '1', '0', '{\"input_params\":[]}', '0', '1', 'company', '1'),
	('alekseon_custom_form_record', 'inquiry_subject_group', 'text', 'varchar', '课题组', NULL, NULL, '0', '0', '1', '40', NULL, '1', NULL, '0', NULL, '0', '1', '0', '{\"input_params\":[]}', '0', '1', 'subject_group', '1'),
	('alekseon_custom_form_record', 'inquiry_province', 'text', 'varchar', '所在省份', NULL, NULL, '0', '1', '1', '50', NULL, '1', NULL, '0', NULL, '0', '1', '0', '{\"input_params\":[]}', '0', '1', 'province', '1'),
	('alekseon_custom_form_record', 'lecture_username', 'text', 'varchar', '姓名', NULL, NULL, '0', '0', '1', '1', NULL, '1', NULL, '0', NULL, '0', '2', '0', '{\"input_params\":[]}', '0', '2', 'username', '1'),
	('alekseon_custom_form_record', 'lecture_company', 'text', 'varchar', '单位', NULL, NULL, '0', '1', '1', '10', NULL, '1', NULL, '0', NULL, '0', '2', '0', '{\"input_params\":[]}', '0', '2', 'company', '1'),
	('alekseon_custom_form_record', 'lecture_subject_group', 'text', 'varchar', '课题组', NULL, NULL, '0', '0', '1', '20', NULL, '1', NULL, '0', NULL, '0', '2', '0', '{\"input_params\":[]}', '0', '2', 'subject_group', '1'),
	('alekseon_custom_form_record', 'lecture_province', 'text', 'varchar', '省份', NULL, NULL, '0', '1', '1', '30', NULL, '1', NULL, '0', NULL, '0', '2', '0', '{\"input_params\":[]}', '0', '2', 'province', '1'),
	('alekseon_custom_form_record', 'lecture_email', 'text', 'varchar', '邮件', NULL, NULL, '0', '1', '1', '40', NULL, '1', NULL, '0', NULL, '0', '2', '0', '{\"input_params\":[]}', '0', '2', 'email', '1'),
	('alekseon_custom_form_record', 'lecture_mobile', 'text', 'varchar', '手机', NULL, NULL, '0', '0', '1', '50', NULL, '1', NULL, '0', NULL, '0', '2', '0', '{\"input_params\":[]}', '0', '2', 'mobile', '1'),
	('alekseon_custom_form_record', 'lecture_species_studied', 'multiselect', 'varchar', '研究的物种', NULL, NULL, '0', '0', '1', '60', NULL, '1', '', '0', NULL, '0', '2', NULL, '{\"input_params\":[]}', '0', '2', 'species_studied', '1'),
	('alekseon_custom_form_record', 'lecture_cell_type', 'select', 'int', '研究的细胞类型', NULL, NULL, '0', '0', '1', '70', NULL, '1', '', '0', NULL, '0', '2', NULL, '{\"input_params\":[]}', '0', '2', 'cell_type', '1'),
	('alekseon_custom_form_record', 'lecture_apply_topics', 'text', 'varchar', '需要申请的讲座主题', NULL, NULL, '0', '0', '1', '80', NULL, '1', NULL, '0', NULL, '0', '2', '0', '{\"input_params\":[]}', '0', '2', 'apply_topics', '1'),
	('alekseon_custom_form_record', 'lecture_the_way', 'select', 'int', '希望通过哪种方式进行讲座', NULL, NULL, '0', '0', '1', '90', NULL, '1', '', '0', NULL, '0', '2', NULL, '{\"input_params\":[]}', '0', '2', 'the_way', '1'),
	('alekseon_custom_form_record', 'livedemo_username', 'text', 'varchar', '姓名', NULL, NULL, '0', '0', '1', '10', NULL, '1', NULL, '0', NULL, '0', '3', '0', '{\"input_params\":[]}', '0', '3', NULL, '1'),
	('alekseon_custom_form_record', 'livedemo_company', 'text', 'varchar', '单位', NULL, NULL, '0', '0', '1', '20', NULL, '1', NULL, '0', NULL, '0', '3', '0', '{\"input_params\":[]}', '0', '3', NULL, '1'),
	('alekseon_custom_form_record', 'livedemo_subject_group', 'text', 'varchar', '课题组', NULL, NULL, '0', '0', '1', '30', NULL, '1', NULL, '0', NULL, '0', '3', '0', '{\"input_params\":[]}', '0', '3', NULL, '1'),
	('alekseon_custom_form_record', 'livedemo_province', 'text', 'varchar', '省份', NULL, NULL, '0', '0', '1', '40', NULL, '1', NULL, '0', NULL, '0', '3', '0', '{\"input_params\":[]}', '0', '3', NULL, '1'),
	('alekseon_custom_form_record', 'livedemo_email', 'text', 'varchar', '邮箱', NULL, NULL, '0', '0', '1', '50', NULL, '1', NULL, '0', NULL, '0', '3', '0', '{\"input_params\":[]}', '0', '3', NULL, '1'),
	('alekseon_custom_form_record', 'livedemo_mobile', 'text', 'varchar', '手机', NULL, NULL, '0', '0', '1', '60', NULL, '1', NULL, '0', NULL, '0', '3', '0', '{\"input_params\":[]}', '0', '3', NULL, '1'),
	('alekseon_custom_form_record', 'livedemo_product_show', 'select', 'int', '需要申请上门演示的产品', NULL, NULL, '0', '0', '1', '70', NULL, '1', '', '0', NULL, '0', '3', NULL, '{\"input_params\":[]}', '0', '3', NULL, '1'),
	('alekseon_custom_form_record', 'livedemo_species_studied', 'multiselect', 'varchar', '研究的物种', NULL, NULL, '0', '0', '1', '80', NULL, '1', '', '0', NULL, '0', '3', NULL, '{\"input_params\":[]}', '0', '3', NULL, '1'),
	('alekseon_custom_form_record', 'livedemo_cell_type', 'select', 'int', '研究的细胞类型', NULL, NULL, '0', '0', '1', '90', NULL, '1', '', '0', NULL, '0', '3', NULL, '{\"input_params\":[]}', '0', '3', NULL, '1');
";
        $connection->query($sql);

        $sql = "INSERT INTO `alekseon_custom_form_entity_int` (`attribute_id`, `store_id`, `entity_id`, `value`)
VALUES
	('4', '0', '1', '0'),
	('9', '0', '1', '0'),
	('2', '0', '1', '0'),
	('4', '0', '2', '0'),
	('9', '0', '2', '0'),
	('2', '0', '2', '0'),
	('4', '0', '3', '0'),
	('9', '0', '3', '0'),
	('2', '0', '3', '0');
";
        $connection->query($sql);

        $sql = "INSERT INTO `alekseon_custom_form_entity_text` (`attribute_id`, `store_id`, `entity_id`, `value`)
VALUES
	('8', '0', '1', ''),
	('8', '0', '2', ''),
	('8', '0', '3', '');
";
        $connection->query($sql);

        $sql = "INSERT INTO `alekseon_custom_form_entity_varchar` (`attribute_id`, `store_id`, `entity_id`, `value`)
VALUES
	('1', '0', '1', '询价'),
	('3', '0', '1', ''),
	('6', '0', '1', ''),
	('5', '0', '1', '0'),
	('7', '0', '1', ''),
	('1', '0', '2', '讲座申请'),
	('3', '0', '2', ''),
	('6', '0', '2', ''),
	('5', '0', '2', '0'),
	('7', '0', '2', ''),
	('1', '0', '3', '现场演示'),
	('3', '0', '3', ''),
	('6', '0', '3', ''),
	('5', '0', '3', '0'),
	('7', '0', '3', '');
";
        $connection->query($sql);

        $sql = "INSERT INTO `alekseon_custom_form_record_attribute_option` (`attribute_id`, `sort_order`, `option_code`)
VALUES
	('13', '1', ''),
	('13', '2', ''),
	('13', '3', ''),
	('13', '4', ''),
	('13', '5', ''),
	('14', '1', ''),
	('14', '2', ''),
	('14', '3', ''),
	('14', '4', ''),
	('14', '5', ''),
	('14', '6', ''),
	('14', '7', ''),
	('14', '8', ''),
	('16', '1', ''),
	('16', '2', ''),
	('23', '1', ''),
	('23', '2', ''),
	('23', '3', ''),
	('23', '4', ''),
	('24', '1', ''),
	('24', '2', ''),
	('24', '3', ''),
	('24', '4', ''),
	('24', '5', ''),
	('25', '1', ''),
	('25', '2', ''),
	('25', '3', ''),
	('25', '4', ''),
	('25', '5', ''),
	('25', '6', ''),
	('25', '7', ''),
	('25', '8', '');
";
        $connection->query($sql);

        $sql = "INSERT INTO `alekseon_custom_form_record_attribute_option_value` (`option_id`, `store_id`, `value`)
VALUES
	('1', '0', '人'),
	('2', '0', '小鼠'),
	('3', '0', '大鼠'),
	('4', '0', '非人灵长类（NHP）'),
	('5', '0', '其它'),
	('6', '0', 'T细胞'),
	('7', '0', 'B细胞'),
	('8', '0', 'NK细胞'),
	('9', '0', '单核细胞'),
	('10', '0', 'PBMCs'),
	('11', '0', 'iPSCs'),
	('12', '0', 'CD34+造血干祖细胞'),
	('13', '0', '其它'),
	('14', '0', '线上'),
	('15', '0', '线下'),
	('16', '0', '细胞分选试剂盒'),
	('17', '0', 'CellPore转染系统'),
	('18', '0', 'RoboSep全自动细胞分选仪'),
	('19', '0', 'STEMvison造血集落计数与成像仪'),
	('20', '0', '人'),
	('21', '0', '小鼠'),
	('22', '0', '大鼠'),
	('23', '0', '非人灵长类（NHP）'),
	('24', '0', '其它'),
	('25', '0', 'T细胞'),
	('26', '0', 'B细胞'),
	('27', '0', 'NK细胞'),
	('28', '0', '单核细胞'),
	('29', '0', 'PBMCs'),
	('30', '0', 'iPSCs'),
	('31', '0', 'CD34+造血干祖细胞'),
	('32', '0', '其它');
";

        $connection->query($sql);

        //$connection->insert($tableName, $data);
    }

    public static function getDependencies()
    {
        return [];
    }

    public function getAliases()
    {
        return [];
    }
}