request = Request::getInstance(); } public function search($s = 0) { if ($s) { $c = intval($s); } else { $data = Request::params(); $c = $data['b'] ?: 1; } switch ($c) { //添加商品索引库 case 1: $mappings = array( 'mappings' => array( "_default_" => [ "properties" => [ 'basicGoodsId' => ["type" => "integer"],//关联商品基本资料id, 'id' => ["type" => "integer"],//商品id, 'enterpriseId' => ['type' => 'integer'],//enterpriseId, 'shopId' => ["type" => "integer"],//'商铺id', 'warehouseId' => ["type" => "integer"],//'仓库id', 'images' => [ 'type' => 'text' ], 'serviceInfo' => ["type" => "integer"],//'服务保证', 'salesNum' => [ "properties" => [ "skuId" => ["type" => "integer",], "salesNum" => ["type" => "integer",], ] ],//销量 'content' => [ 'type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word" ],//'商品详情', 'extend' => [ 'type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word" ],// '扩展字段', 'sort' => ["type" => "integer"],//'排序', 'isRecommend' => ["type" => "integer"],//是否推荐(5是 4否)', 'deleteStatus' => ["type" => "integer"],//删除状态(5未删除 4已删除)', 'enableStatus' => ["type" => "integer"],//上下架(5上架 4下架)', 'createTime' => [ 'type' => 'integer', ],//'创建时间' 'updateTime' => [ 'type' => 'integer', ],//'修改时间', ] ] ) ); $searchServer = Factory::search('goods_search'); $result = $searchServer->createBase('online_goods_search', $mappings); if ($result && !isset($result['error'])) { echo 'online_goods_search init done.'; return true; } else { print_r($result['error']); return false; } break; //删除商品索引库 case 2: $searchServer = Factory::search('goods_search'); $searchServer->setIndex('online_goods_search'); $a = $searchServer->deleteBase('online_goods_search'); print_r($a); break; //添加客户索引库 case 3: $mappings = array( 'mappings' => array( "_default_" => [ "properties" => [ 'id' => ['type' => 'integer'],//customerId, 'userCenterId' => ['type' => 'integer'],//userCenterId, 'mobile' => ['type' => 'keyword'], 'source' => ['type' => 'integer'],//客户来源 'enterpriseId' => ['type' => 'integer'],//enterpriseId, 'status' => ['type' => 'integer'],//'账号状态(1已审核 2待审核)', 'statusName' => ['type' => 'keyword'],//状态名称, 'name' => [ 'type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word" ],//'客户名称', 'code' => ['type' => 'keyword'],//'客户编码', 'type' => ['type' => 'integer'],//'客户类型', 'provinceCode' => ['type' => 'keyword'],//varchar(20) NOT NULL COMMENT '客户地址省编码', 'cityCode' => ['type' => 'keyword'],//varchar(20) NOT NULL COMMENT '客户地址市编码', 'districtCode' => ['type' => 'keyword'],//varchar(20) NOT NULL COMMENT '客户地址区编码', 'provinceName' => ['type' => 'keyword'],//省名称 'cityName' => ['type' => 'keyword'],//市名称 'districtName' => ['type' => 'keyword'],//区名称 "address" => [ "type" => "text", "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word" ], 'managerMobile' => ['type' => 'keyword'],//'负责人电话', 'shopId' => ['type' => 'integer'],//商铺id, 'shopName' => ['type' => 'keyword'],//商铺名称, 'departmentId' => ['type' => 'integer'],//销售部Id, 'departmentName' => ['type' => 'keyword'],//部门名称, 'salesManId' => ['type' => 'integer'],//int(10) DEFAULT NULL COMMENT '业务员id', 'salesManCode' => ['type' => 'keyword'],//'业务员编码', 'salesManName' => [ 'type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word" ],//'业务员名称', 'birthday' => [ 'type' => 'integer' ],//'客户生日', 'enableStatus' => ['type' => 'integer'],//'启用状态(5启用 4禁用)', 'deleteStatus' => ['type' => 'integer'],//'删除状态(5未删除 4已删除)', 'createTime' => ['type' => 'integer'],//'创建时间' 'updateTime' => ['type' => 'integer'],//'修改时间', 'extend' => [ 'type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word" ],// '扩展字段', 'tag' => [// '客户标签', 'type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word" ], 'remark' => [ "type" => "text", "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word", ],// '备注' 'location' => [ "type" => "geo_point", ],//经纬度 'contact' => [ "properties" => [ "name" => ["type" => "keyword",], "mobile" => ["type" => "keyword",], ] ],// '联系人' ] ] ) ); $searchServer = Factory::search('customer_search'); $result = $searchServer->createBase('online_customer_search', $mappings); if ($result && !isset($result['error'])) { echo 'online_customer_search init done.'; return true; } else { print_r($result['error']); return false; } break; //删除客户索引库 case 4: $searchServer = Factory::search('customer_search'); $searchServer->setIndex('online_customer_search'); $a = $searchServer->deleteBase('online_customer_search'); print_r($a); break; //添加商品基本资料 case 5: //创建映射 $mappings = array( "settings" => [ "analysis" => [ "analyzer" => [ "comma"=>[ "type" => "pattern", "pattern" => "," ] ] ] ], 'mappings' => array( "_default_" => [ "properties" => [ 'id' => ["type" => "integer"],//商品基本资料id, 'enterpriseId' => ['type' => 'integer'],//enterpriseId, 'images' => ['type' => 'text'], 'title' => [ 'type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word" ],//商品名称, 'code' => ["type" => "keyword"], 'barCode' => ["type" => "keyword"], 'categoryId' => ["type" => "integer"],//'商品分类id', 'expireTime' => ["type" => "integer"],//'过期时间', 'brandId' => ["type" => "integer"],//'品牌id', 'tag' => [ 'type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word" ],//'关键词', 'description' => [ 'type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word" ],//'商品详情', 'noSalesShop' => ['type' => 'text'],//'禁止销售店铺', 'extends' => [ 'type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word" ],//'拓展字段', 'enableStatus' => ["type" => "integer"],//'商品状态 默认5 上线 6下线', 'deleteStatus' => ["type" => "integer"],//'是否删除 4 删除 5正常', 'createTime' => [ 'type' => 'integer', ],//'创建时间' 'updateTime' => [ 'type' => 'integer', ],//'修改时间', 'categoryPath' => [ "type" => "text", "analyzer" => "comma", "search_analyzer" => "comma" ],//'分类路径', 'skuData' => [ "properties" => [ "masterUnit" => [ "properties" => [ "id" => ["type" => "integer",], "unitName" => ["type" => "keyword",], "unitId" => ["type" => "integer",], "isMaster" => ["type" => "integer",], "deleteStatus" => ["type" => "integer",], ] ], "branchUnit" => [ "properties" => [ "id" => ["type" => "integer",], "unitName" => ["type" => "keyword",], "unitId" => ["type" => "integer",], "isMaster" => ["type" => "integer",], "deleteStatus" => ["type" => "integer",], ] ] ] ],//sku ], ] ) ); $searchServer = Factory::search('goods_basic_search'); $result = $searchServer->createBase('goods_basic_search', $mappings); if ($result && !isset($result['error'])) { echo 'online_goods_basic_search init done.'; return true; } else { print_r($result['error']); return false; } break; //删除商品基本资料索引库 case 6: $searchServer = Factory::search('goods_basic_search'); $searchServer->setIndex('goods_basic_search'); $a = $searchServer->deleteBase('online_goods_basic_search'); print_r($a); break; //创建订单索引库 case 7: $mappings = array( 'mappings' => array( "order" => [ "properties" => [ /*订单表信息*/ 'id' => ["type" => "integer"],//订单id, 'no' => ["type" => "keyword"],//订单编号, 'outerTradeNo' => ['type' => 'keyword'],//'外部流水号(支付宝/微信返回的流水号)' 'shopId' => ['type' => 'integer'],//商铺id 'userCenterId' => ['type' => 'integer'],//用户id 'enterpriseId' => ['type' => 'integer'],//企业id 'customerType' => ['type' => 'integer'],//客户类型 'totalMoney' => [ 'type' => 'scaled_float', 'scaling_factor' => 100 ],//'总金额', 'payAmount' => [ 'type' => 'scaled_float', 'scaling_factor' => 100 ],//实付金额 'buyTotal' => ["type" => "integer"],//购买总数 'customerName' => ["type" => "keyword"],//客户姓名 'customerId' => ["type" => "integer"],//客户id 'payStatus' => ["type" => "integer"],//'支付状态 默认1 未支付 2已支付' 'orderStatus' => ["type" => "integer"],//订单状态 默认1 创建 2待支付 3代发货 4待收货 5已完成 6已关闭 'payType' => ["type" => "integer"],//'支付方式 1微信 2支付宝 3货到付款 4上门自提' 'deliveryType' => ["type" => "integer"],//'配送方式 1商品配送 2上门自提' 'source' => ["type" => "integer"],//订单来源 默认1 ios 2android 3小程序 4后台创建 'remark' => [ 'type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word" ],//订单备注 'auditStatus' => ["type" => "integer"],// '审核状态 默认1 待审 2审核通过 3 审核未通过 4 审核中' 'payTime' => [ 'type' => 'integer', /**/ ],//'付款时间' 'createTime' => [ 'type' => 'integer', ],//'创建时间' 'updateTime' => [ 'type' => 'integer', ],//'修改时间', 'salesManId' => ["type" => "integer"],//业务员id 'salesManName' => ["type" => "keyword"],//业务员名称 /*收货人信息*/ 'realName' => ["type" => "keyword"],//收货人姓名 'mobile' => ["type" => "keyword"],//收货人电话 'address' => [ 'type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word" ],//收货详细地址 'provinceCode' => ["type" => "integer"],//收货人省份编码 'cityCode' => ["type" => "integer"],//收货人城市编码 'districtCode' => ["type" => "integer"],//收货人区编码 'goodsName' => [ 'type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word" ], ] ] ) ); $searchServer = Factory::search('order_search'); $result = $searchServer->createBase('online_order_search', $mappings); if ($result && !isset($result['error'])) { echo 'online_order_search init done.'; return true; } else { print_r($result['error']); return false; } break; //删除订单索引库 case 8: $searchServer = Factory::search('order_search'); $searchServer->setIndex('online_order_search'); $a = $searchServer->deleteBase('online_order_search'); print_r($a); break; //添加商铺索引库 case 9: //创建映射 $mappings = array( "settings" => [ "analysis" => [ "analyzer" => [ "comma"=>[ "type" => "pattern", "pattern" => "," ] ] ] ], 'mappings' => array( "_default_" => [ "properties" => [ 'id' => ["type" => "integer"],//商铺id, 'enterpriseId' => ['type' => 'integer'],//enterpriseId, 'name' => [ 'type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word" ],//商铺名称, 'logo' => ['type' => 'text'],//商铺logo, 'shopCode' => ['type' => 'text'],//商铺仓库编码, 'shopType' => ['type' => 'integer'],//商铺类型, 'openTime' => [ "properties" => [ "start" => ["type" => "text",], "end" => ["type" => "text",], "isAllDay" => ["type" => "integer",], ] ],//营业时间 'contactName' => ['type' => 'keyword'],//联系人, 'mobile' => ['type' => 'keyword'],//联系电话, 'deleteStatus' => ["type" => "integer"],//删除状态(5未删除 4已删除)', 'enableStatus' => ["type" => "integer"],//启用状态(4未启用 5已启用) 'createTime' => [ 'type' => 'integer', ],//'创建时间' 'updateTime' => [ 'type' => 'integer', ],//'修改时间', 'provinceCode' => ['type' => 'keyword'],//varchar(20) NOT NULL COMMENT '商铺地址省编码', 'cityCode' => ['type' => 'keyword'],//varchar(20) NOT NULL COMMENT '商铺地址市编码', 'districtCode' => ['type' => 'keyword'],//varchar(20) NOT NULL COMMENT '商铺地址区编码', 'provinceName' => ['type' => 'keyword'],//商铺省名称 'cityName' => ['type' => 'keyword'],//商铺市名称 'districtName' => ['type' => 'keyword'],//商铺区名称 "address" => [ "type" => "text", "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word" ], 'location' => [ "type" => "geo_point", ],//经纬度 'salesArea' => [ "type" => "text", "analyzer" => "comma", "search_analyzer" => "comma" ],//'销售区域', ], ] ) ); $searchServer = Factory::search('shop_search'); $result = $searchServer->createBase('online_shop_search', $mappings); if ($result && !isset($result['error'])) { echo 'online_shop_search init done.'; return true; } else { print_r($result['error']); return false; } break; //删除商铺索引库 case 10: $searchServer = Factory::search('shop_search'); $searchServer->setIndex('online_shop_search'); $a = $searchServer->deleteBase('online_shop_search'); print_r($a); break; //添加登录日志索引库 case 11: //创建映射 $mappings = array( 'mappings' => array( "_default_" => [ "properties" => [ 'id' => ["type" => "integer"], 'userCenterId' => ['type' => 'integer'], 'enterpriseId' => ['type' => 'integer'],//enterpriseId, 'mobile' => ['type' => 'keyword'],//联系电话, 'createTime' => [ 'type' => 'integer', ],//'创建时间' 'source' => [ 'type' => 'keyword', ], 'actionType' => [ 'type' => 'keyword', ] ] ] ) ); $searchServer = Factory::search('login_log'); $result = $searchServer->createBase('online_login_log', $mappings); if ($result && !isset($result['error'])) { echo 'online_login_log init done.'; return true; } else { print_r($result['error']); return false; } break; //删除登录日志 case 12: $searchServer = Factory::search('login_log'); $searchServer->setIndex('online_login_log'); $a = $searchServer->deleteBase('online_login_log'); print_r($a); break; //添加日志索引库 case 13: //创建映射 $mappings = array( 'mappings' => array( "_default_" => [ "properties" => [ 'id' => ["type" => "integer"], 'userCenterId' => ['type' => 'integer'], 'enterpriseId' => ['type' => 'integer'],//enterpriseId, 'createTime' => [ 'type' => 'integer', ],//'创建时间' 'no' => [ 'type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word" ], 'actionType' => [ 'type' => 'keyword', ] ] ] ) ); $searchServer = Factory::search('logs'); $result = $searchServer->createBase('online_logs', $mappings); if ($result && !isset($result['error'])) { echo 'online_logs init done.'; return true; } else { print_r($result['error']); return false; } break; //删除日志 case 14: $searchServer = Factory::search('logs'); $searchServer->setIndex('online_logs'); $a = $searchServer->deleteBase('online_logs'); print_r($a); break; //入库列表 case 15: $mappings = array( 'mappings' => array( "inventory_in" => [ "properties" => [ //入库表信息 'id' => ["type" => "integer"],//入库id 'no' => ["type" => "keyword"],//入库编号 'sourceNo' => ['type' => 'keyword'],//来源单号 'materielNum' => ['type' => 'integer'],//商品数量 'amount' => ['type' => 'scaled_float', 'scaling_factor' => 100],//总金额 'warehouseId' => ['type' => 'integer'],//仓库id 'warehouseName' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"],//仓库名称 'operatorId' => ['type' => 'integer'],//操作人id 'operatorName' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"],//操作人name 'auditId' => ['type' => 'integer'],//审核人id 'auditName' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"], //审核人name 'remark' => ['type' => 'text'],//备注 'deleteStatus' => ['type' => 'integer'],//删除状态 'source' => ['type' => 'integer'],//来源 'type' => ['type' => 'integer'], 'auditStatus' => ['type' => 'integer'],//审核状态 'auditTime' => ['type' => 'integer'],//审核日期 'createTime' => ['type' => 'integer'],//创建时间 'updateTime' => ['type' => 'integer'],//更新时间 ], ] ) ); $searchServer = Factory::search('inventory_in_search'); $result = $searchServer->createBase('online_inventory_in_search', $mappings); if ($result && !isset($result['error'])) { echo 'online_inventory_in_search init done.'; return true; } else { print_r($result['error']); return false; } break; //删除入库 case 16: $searchServer = Factory::search('inventory_in_search'); $searchServer->setIndex('online_inventory_in_search'); $a = $searchServer->deleteBase('online_inventory_in_search'); print_r($a); break; //出库列表 case 17: $mappings = array( 'mappings' => array( "inventory_out" => [ "properties" => [ //入库表信息 'id' => ["type" => "integer"],//入库id 'no' => ["type" => "keyword"],//入库编号 'sourceNo' => ['type' => 'keyword'],//来源单号 'materielNum' => ['type' => 'integer'],//商品数量 'amount' => ['type' => 'scaled_float', 'scaling_factor' => 100],//总金额 'warehouseId' => ['type' => 'integer'],//仓库id 'warehouseName' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"],//仓库名称 'operatorId' => ['type' => 'integer'],//操作人id 'operatorName' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"],//操作人name 'auditId' => ['type' => 'integer'],//审核人id 'auditName' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"], //审核人name 'customerId' => ['type' => 'integer'], 'customerName' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"], 'customerCode' => ['type' => 'text'], 'customerMobile' => ['type' => 'keyword'], 'remark' => ['type' => 'text'],//备注 'deleteStatus' => ['type' => 'integer'],//删除状态 'source' => ['type' => 'integer'],//来源 'type' => ['type' => 'integer'], 'auditStatus' => ['type' => 'integer'],//审核状态 'auditTime' => ['type' => 'integer'],//审核日期 'createTime' => ['type' => 'integer'],//创建时间 'updateTime' => ['type' => 'integer'],//更新时间 ] ] ) ); $searchServer = Factory::search('inventory_out_search'); $result = $searchServer->createBase('online_inventory_out_search', $mappings); if ($result && !isset($result['error'])) { echo 'online_inventory_out_search init done.'; return true; } else { print_r($result['error']); return false; } break; //删除出库 case 18: $searchServer = Factory::search('inventory_out_search'); $searchServer->setIndex('online_inventory_out_search'); $a = $searchServer->deleteBase('online_inventory_out_search'); print_r($a); break; //商品调价单 case 19: $mappings = array( 'mappings' => array( "priceAdjustmentSheet" => [ "properties" => [ /*订单表信息*/ 'enterpriseId' => ['type' => 'integer'],//enterpriseId, 'id' => ["type" => "integer"],//自增id, 'no' => ["type" => "keyword"],//调价单号, 'goodsCode' => ['type' => 'keyword'],//商品编号 'goodsName' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"],//商品名称 'goodsId' => ['type' => 'integer'],//商品id 'saleType' => ['type' => 'integer'],//销售类型 1实物销售 2虚库销售 'salePriceAreaType' => ['type' => 'integer'],//销售价格生效区域类型 1全国统一价 2大区价 'salePriceType' => ['type' => 'integer'],//销售价格类型 1销售价格 2秒杀活动价 'shopId' => ['type' => 'integer'],//店铺id 'shopName' => ['type' => 'keyword'],//店铺名称 'cargoOwnerCode' => ['type' => 'keyword'],//货主编码 'createUserId' => ['type' => 'integer'],//创建人id 'createUserName' => ['type' => 'keyword'],//创建人姓名 'effectiveUserName' => ['type' => 'keyword'],//生效人姓名 'effectiveUserId' => ['type' => 'integer'],//生效人id 'deleteStatus' => ['type' => 'integer'],//删除状态 4删除 5正常 'effectiveStatus' => ['type' => 'integer'],//生效状态 1.待审 2审核通过 3未通过 4审核中 'createTime' => ['type' => 'integer',],//创建时间 'updateTime' => ['type' => 'integer',],//修改时间 'salePrice' => [ "properties" => [ ] ],//销售价格 ] ] ) ); $searchServer = Factory::search('priceAdjustmentSheet_search'); $result = $searchServer->createBase('online_priceadjustmentsheet_search', $mappings); if ($result && !isset($result['error'])) { echo 'online_priceadjustmentsheet_search init done.'; } else { print_r($result['error']); return false; } break; //删除商品调价单 case 20: $searchServer = Factory::search('priceAdjustmentSheet_search'); $searchServer->setIndex('online_priceadjustmentsheet_search'); $a = $searchServer->deleteBase('online_priceadjustmentsheet_search'); print_r($a); break; //调拨列表 case 21: $mappings = array( 'mappings' => array( "allocate" => [ "properties" => [ //入库表信息 'id' => ["type" => "integer"],//入库id 'no' => ["type" => "keyword"],//入库编号 'warehouseId' => ['type' => 'integer'],//仓库id 'inWarehouseId' => ['type' => 'integer'],//in仓库id 'warehouseName' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"],//仓库名称 'operatorId' => ['type' => 'integer'],//操作人id 'operatorName' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"],//操作人name 'auditId' => ['type' => 'integer'],//审核人id 'auditName' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"], //审核人name 'remark' => ['type' => 'text'],//备注 'deleteStatus' => ['type' => 'integer'],//删除状态 'auditStatus' => ['type' => 'integer'],//审核状态 'auditTime' => ['type' => 'integer'],//审核日期 'createTime' => ['type' => 'integer'],//创建时间 'updateTime' => ['type' => 'integer'],//更新时间 'linkId' => ["type" => "integer"], 'materielId' => ["type" => "integer"], 'materielName' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"], 'materielCode' => ["type" => "text"], 'skuId' => ["type" => "integer"], 'num' => ["type" => "double"], 'costUnitPrice' => ["type" => "double"], 'batch' => ["type" => "object"], ] ] ) ); $searchServer = Factory::search('allocate_search'); $result = $searchServer->createBase('dev_allocate_search', $mappings); if ($result && !isset($result['error'])) { echo 'dev_allocate_search init done.'; return true; } else { print_r($result['error']); return false; } break; //调拨删除 case 22: $searchServer = Factory::search('allocate_search'); $searchServer->setIndex('dev_allocate_search'); $a = $searchServer->deleteBase('dev_allocate_search'); print_r($a); break; //盘点 case 23: $mappings = array( 'mappings' => array( "stocktaking" => [ "properties" => [ 'id' => ["type" => "integer"], 'no' => ["type" => "keyword"], 'warehouseId' => ['type' => 'integer'], 'operatorId' => ['type' => 'integer'], 'operatorName' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"], 'auditId' => ['type' => 'integer'], 'auditName' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"], 'remark' => ['type' => 'text'], 'deleteStatus' => ['type' => 'integer'], 'stocktakingTime' => ['type' => 'integer'], 'saleOutTime' => ['type' => 'integer'], 'createTime' => ['type' => 'integer'], 'updateTime' => ['type' => 'integer'], 'auditStatus' => ["type" => "integer"], 'auditTime' => ["type" => "integer"], ] ] ) ); $searchServer = Factory::search('stocktaking_search'); $result = $searchServer->createBase('dev_stocktaking_search', $mappings); if ($result && !isset($result['error'])) { echo 'dev_stocktaking_search init done.'; return true; } else { print_r($result['error']); return false; } break; //盘点删除 case 24: $searchServer = Factory::search('stocktaking_search'); $searchServer->setIndex('dev_stocktaking_search'); $a = $searchServer->deleteBase('dev_stocktaking_search'); print_r($a); break; //库存流水 case 25: $mappings = array( 'mappings' => array( "inventory_details" => [ "properties" => [ 'id' => ["type" => "integer"], 'sourceNo' => ["type" => "keyword"], 'warehouseId' => ['type' => 'integer'], 'materielId' => ['type' => 'integer'], 'materielName' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"], 'operatorId' => ['type' => 'integer'], 'operatorName' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"], 'inventoryNum' => ['type' => 'double'], 'inventoryChangeNum' => ['type' => 'double'], 'skuId' => ['type' => 'integer'], 'source' => ['type' => 'integer'], 'batch' => ['type' => 'object'], 'costType' => ['type' => 'integer'], 'averageCost' => ['type' => 'double'], 'batchCost' => ['type' => 'double'], 'actionType' => ["type" => "integer"], 'createTime' => ['type' => 'integer'], 'updateTime' => ['type' => 'integer'], ] ] ) ); $searchServer = Factory::search('inventory_details_search'); $result = $searchServer->createBase('online_inventory_details_search', $mappings); if ($result && !isset($result['error'])) { echo 'online_inventory_details_search init done.'; return true; } else { print_r($result['error']); return false; } break; //库存流水删除 case 26: $searchServer = Factory::search('inventory_details_search'); $searchServer->setIndex('online_inventory_details_search'); $a = $searchServer->deleteBase('online_inventory_details_search'); print_r($a); break; //客户调价单 case 27: $mappings = array( 'mappings' => array( "customerPriceAdjustmentSheet" => [ "properties" => [ /*订单表信息*/ 'enterpriseId' => ['type' => 'integer'],//enterpriseId, 'id' => ["type" => "integer"],//自增id, 'no' => ["type" => "keyword"],//调价单号, 'goodsCode' => ['type' => 'keyword'],//商品编号 'goodsName' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"],//商品名称 'goodsId' => ['type' => 'integer'],//商品id 'shopId' => ['type' => 'integer'],//店铺id 'shopName' => ['type' => 'keyword'],//店铺名称 'createUserId' => ['type' => 'integer'],//创建人id 'createUserName' => ['type' => 'keyword'],//创建人姓名 'effectiveUserName' => ['type' => 'keyword'],//生效人姓名 'effectiveUserId' => ['type' => 'integer'],//生效人id 'deleteStatus' => ['type' => 'integer'],//删除状态 4删除 5正常 'effectiveStatus' => ['type' => 'integer'],//生效状态 1.待审 2审核通过 3未通过 4审核中 'createTime' => ['type' => 'integer'],//创建时间 'updateTime' => ['type' => 'integer'],//修改时间 'customerId' => ['type' => 'integer'],//客户id 'customerName' => ['type' => 'keyword'],//客户名称 'customerCode' => ['type' => 'keyword'],//客户编码 'salePrice' => [ "properties" => [ ] ],//销售价格 ] ] ) ); $searchServer = Factory::search('customerPriceAdjustmentSheet_search'); $result = $searchServer->createBase('online_customer_price_adjustment_sheet_search', $mappings); if ($result && !isset($result['error'])) { echo 'online_customer_price_adjustment_sheet_search init done.'; } else { print_r($result['error']); return false; } break; //客户调价单删除 case 28: $searchServer = Factory::search('customerPriceAdjustmentSheet_search'); $searchServer->setIndex('online_customer_price_adjustment_sheet_search'); $a = $searchServer->deleteBase('dev_customer_price_adjustment_sheet_search'); print_r($a); break; //销售退货 case 29: $mappings = array( 'mappings' => array( "order_out" => [ "properties" => [ 'id' => ["type" => "integer"], 'no' => ["type" => "keyword"], 'sourceId' => ["type" => "integer"], 'sourceNo' => ["type" => "keyword"], 'shopId' => ['type' => 'integer'], 'operatorId' => ['type' => 'integer'], 'operatorName' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"], 'auditId' => ['type' => 'integer'], 'auditName' => ['type' => 'text'], 'remark' => ['type' => 'text'], 'auditTime' => ['type' => 'integer'], 'auditStatus' => ['type' => 'integer'], 'deleteStatus' => ['type' => 'integer'], 'linkId' => ['type' => 'integer'], 'goodsId' => ['type' => 'integer'], 'goodsName' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"], 'goodsCode' => ['type' => 'text'], 'goodsBasicId' => ['type' => 'integer'], 'skuId' => ['type' => 'integer'], 'num' => ['type' => 'double'], 'costUnitPrice' => ['type' => 'double'], 'createTime' => ['type' => 'integer'], 'updateTime' => ['type' => 'integer'], ] ] ) ); $searchServer = Factory::search('order_out_search'); $result = $searchServer->createBase('online_order_out_search', $mappings); if ($result && !isset($result['error'])) { echo 'online_order_out_search init done.'; return true; } else { print_r($result['error']); return false; } break; //销售退货删除 case 30: $searchServer = Factory::search('order_out_search'); $searchServer->setIndex('online_order_out_search'); $a = $searchServer->deleteBase('online_order_out_search'); print_r($a); break; //采购明细 case 31: $mappings = array( 'mappings' => array( "purchase_details" => [ "properties" => [ 'id' => ["type" => "integer"], 'no' => ["type" => "keyword"], 'shopId' => ["type" => "integer"], 'shopName' => ["type" => "text", "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"], 'supplierId' => ['type' => 'integer'], 'supplierName' => ['type' => 'text'], 'buyerId' => ['type' => 'integer'], 'buyerName' => ['type' => 'text'], 'remark' => ['type' => 'text'], 'operatorId' => ['type' => 'integer'], 'operatorName' => ['type' => 'text'], 'auditId' => ['type' => 'integer'], 'auditName' => ['type' => 'text'], 'auditTime' => ['type' => 'integer'], 'auditStatus' => ['type' => 'integer'], 'deleteStatus' => ['type' => 'integer'], 'createTime' => ['type' => 'integer'], 'updateTime' => ['type' => 'integer'], 'linkId' => ['type' => 'integer'], 'goodsId' => ['type' => 'integer'], 'goodsName' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"], 'basicGoodsId' => ['type' => 'integer'], 'skuId' => ['type' => 'integer'], 'categoryId' => ['type' => 'integer'], 'categoryName' => ['type' => 'text'], 'buyerNum' => ['type' => 'double'], 'buyerUnitPrice' => ['type' => 'double'], 'subtotalPrice' => ['type' => 'double'], ] ] ) ); $searchServer = Factory::search('purchase_details_search'); $result = $searchServer->createBase('online_purchase_details_search', $mappings); if ($result && !isset($result['error'])) { echo 'online_purchase_details_search init done.'; return true; } else { print_r($result['error']); return false; } break; //采购明细删除 case 32: $searchServer = Factory::search('purchase_details_search'); $searchServer->setIndex('online_purchase_details_search'); $a = $searchServer->deleteBase('online_purchase_details_search'); print_r($a); break; //优惠券 case 33: $mappings = array( 'mappings' => array( "coupon" => [ "properties" => [ /*优惠券信息*/ 'enterpriseId' => ['type' => 'integer'],//enterpriseId, 'id' => ["type" => "integer"],//自增id, 'startTime' => ["type" => "keyword"],//优惠券生效开始时间 'endTime' => ['type' => 'keyword'],//结束时间 'name' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"],//优惠券名称 'couponType' => ['type' => 'integer'],//优惠券类型 'reducePrice' => ['type' => 'scaled_float', 'scaling_factor' => 100],//满减券-减免金额(面值) 'minPrice' => ['type' => 'scaled_float', 'scaling_factor' => 100],//最低消费金额 0.00不限金额 'remark' => ['type' => 'text'],//使用说明 'grantType' => ['type' => 'integer'],//发放方式(10主动领取 20定向发放 30注册领取 40在线支付赠送) 'totalNum' => ['type' => 'integer'],//发放总数量(-1为不限制) 'allowNum' => ['type' => 'integer'],//每人限制领取数量(-1为不限制) 'customerSourceId' => ['type' => 'text'],//领取范围 'mustCondition' => ['type' => 'scaled_float', 'scaling_factor' => 100],//(40在线支付赠送)-满X金额发放 0.00所有在线支付不限金额可领取这个优惠券 'grantStartTime' => ['type' => 'integer'],//发放开始时间 'grantEndTime' => ['type' => 'integer'],//发放结束时间 'useShop' => ['type' => 'text'],//使用范围 'applyRange' => ['type' => 'integer'],//商品适用范围 'categoryCollect' => ['type' => 'text'],//分类集合 'brandCollect' => ['type' => 'text'],//品牌集合 'receiveNum' => ['type' => 'integer'],//已领取数量 'deleteStatus' => ['type' => 'integer'],//删除状态 'auditStatus' => ['type' => 'integer'], 'createTime' => ['type' => 'integer'], 'updateTime' => ['type' => 'integer'], ] ] ) ); $searchServer = Factory::search('coupon_search'); $result = $searchServer->createBase('dev_coupon_search', $mappings); if ($result && !isset($result['error'])) { echo 'dev_coupon_search init done.'; } else { print_r($result['error']); return false; } break; //删除优惠券 case 34: $searchServer = Factory::search('coupon_search'); $searchServer->setIndex('dev_coupon_search'); $a = $searchServer->deleteBase('dev_coupon_search'); print_r($a); break; //优惠券记录 case 35: $mappings = array( 'mappings' => array( "user_coupon" => [ "properties" => [ /*优惠券信息*/ 'enterpriseId' => ['type' => 'integer'],//enterpriseId, 'id' => ["type" => "integer"],//自增id, 'couponId' => ["type" => "integer"],//优惠券id 'name' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"],//优惠券名称 'remark' => ['type' => 'text'],//使用说明 'couponType' => ['type' => 'integer'],//优惠券类型 'reducePrice' => ['type' => 'scaled_float', 'scaling_factor' => 100],//满减券-减免金额(面值) 'minPrice' => ['type' => 'scaled_float', 'scaling_factor' => 100],//最低消费金额 0.00不限金额 'startTime' => ["type" => "keyword"],//优惠券生效开始时间, 'endTime' => ['type' => 'keyword'],//结束时间 'applyRange' => ['type' => 'integer'],//商品适用范围 'categoryCollect' => ['type' => 'text'],//分类集合 'brandCollect' => ['type' => 'text'],//品牌集合 'isExpire' => ['type' => 'integer'],//是否过期 4未过期 5已过期 'isUse' => ['type' => 'integer'],//是否使用 4未过期 5已过期 'useTime' => ['type' => 'integer'],//使用时间 'userId' => ['type' => 'integer'],//用户id 'customerId' => ['type' => 'integer'],//客户id 'shopId' => ['type' => 'integer'],//店铺id 'useShop' => ['type' => 'text'],//使用范围 'source' => ['type' => 'integer'],//优惠券来源(10主动领取 20定向发放 30注册领取 40在线支付赠送) 'createTime' => ['type' => 'integer'],//创建时间 'updateTime' => ['type' => 'integer'],//更新时间 'orderNo' => ['type' => 'text'],//使用单号 'orderId' => ['type' => 'integer'],//订单id ] ] ) ); $searchServer = Factory::search('user_coupon_search'); $result = $searchServer->createBase('online_user_coupon_search', $mappings); if ($result && !isset($result['error'])) { echo 'online_user_coupon_search init done.'; } else { print_r($result['error']); return false; } break; //删除优惠券记录 case 36: $searchServer = Factory::search('user_coupon_search'); $searchServer->setIndex('online_user_coupon_search'); $a = $searchServer->deleteBase('online_user_coupon_search'); print_r($a); break; //促销活动 case 37: $mappings = array( 'mappings' => array( "activity" => [ "properties" => [ /*促销活动信息*/ 'enterpriseId' => ['type' => 'integer'],//enterpriseId, 'id' => ["type" => "integer"],//自增id, 'activityType' => ["type" => "integer"],//活动类型 'title' => ['type' => 'text', "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"],//名称 'remark' => ['type' => 'text'],//客户沟通 'startTime' => ["type" => "integer"],//活动开始时间, 'endTime' => ['type' => 'integer'],//活动结束时间 'enableStatus' => ["type" => "integer"], 'images' => ["type" => "text"],//活动图 'useShop' => ['type' => 'text'],//使用范围 'customerRange' => ['type' => 'integer'],//客户范围 'customerSourceId' => ['type' => 'text'],//客户id 1,2 'sort' => ['type' => 'integer'], 'describe' => ['type' => 'text'], 'createTime' => ['type' => 'integer'], 'updateTime' => ['type' => 'integer'], 'isEnd' => ['type' => 'integer'], 'deleteStatus' => ['type' => 'integer'], 'auditStatus' => ['type' => 'integer'], ] ] ) ); $searchServer = Factory::search('activity_search'); $result = $searchServer->createBase('online_activity_search', $mappings); if ($result && !isset($result['error'])) { echo 'online_activity_search init done.'; } else { print_r($result['error']); return false; } break; //促销活动删除 case 38: $searchServer = Factory::search('activity_search'); $searchServer->setIndex('online_activity_search'); $a = $searchServer->deleteBase('online_activity_search'); print_r($a); break; //批次 case 39: $mappings = array( 'mappings' => array( "inventory_batch" => [ "properties" => [ 'id' => ["type" => "integer"], 'enterpriseId' => ['type' => 'integer'], 'warehouseId' => ["type" => "integer"], 'batchNo' => ["type" => "keyword"], 'originId' => ["type" => "integer"], 'originNo' => ["type" => "keyword"], 'sourceNo' => ["type" => "keyword"], 'materielId' => ["type" => "integer"], 'materielCode' => ["type" => "keyword"], 'materielName' => ["type" => "text", "analyzer" => "ik_max_word", "search_analyzer" => "ik_max_word"], 'skuId' => ["type" => "integer"], 'num' => ['type' => 'double'], 'averageCost' => ['type' => 'double'], 'batchCost' => ['type' => 'double'], 'productionData' => ["type" => "integer"], 'batchStatus' => ["type" => "integer"], 'createTime' => ["type" => "integer"], 'updateTime' => ["type" => "integer"], ] ] ) ); $searchServer = Factory::search('inventory_batch_search'); $result = $searchServer->createBase('online_inventory_batch_search', $mappings); if ($result && !isset($result['error'])) { echo 'online_inventory_batch_search init done.'; return true; } else { print_r($result['error']); return false; } break; //批次删除 case 40: $searchServer = Factory::search('inventory_batch_search'); $searchServer->setIndex('online_inventory_batch_search'); $a = $searchServer->deleteBase('online_inventory_batch_search'); print_r($a); break; //添加登录日志索引库 case 41: //创建映射 $mappings = array( 'mappings' => array( "_default_" => [ "properties" => [ 'id' => ["type" => "integer"], 'name' => ['type' => 'keyword'],//联系电话 ] ] ) ); $searchServer = Factory::search('test'); $result = $searchServer->createBase('test', $mappings); if ($result && !isset($result['error'])) { echo 'test init done.'; return true; } else { print_r($result['error']); return false; } break; //删除登录日志 case 42: $searchServer = Factory::search('test'); $searchServer->setIndex('test'); $a = $searchServer->deleteBase('test'); print_r($a); break; } } public function initSearch() { $num = $this->request->param('request_id'); //$search = [2,4,6,8,10,12]; //$search = [1,3,5,7,9,11]; $search = [$num]; foreach ($search as $s) { $this->search($s); } } }