201 lines
9.9 KiB
PHP
201 lines
9.9 KiB
PHP
<?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 [];
|
||
}
|
||
}
|