db; $transaction = $connection->beginTransaction(); try { if (getenv('YII_ENV') == 'production') { $str = << $mainId], null, '*', 'name'); $shop = ShopClass::getById($shopId, true); $shopName = $shop->shopName ?? ''; $sjName = $shop->merchantName ?? ''; if ($shopName != '首店') { echo '不是首店'; die; } if (getenv('YII_ENV') == 'production') { if ($sjName != '集花舍') { echo '不是集花舍，' . $sjName; die; } $staffId = 167182; $cover = 'default-img.png'; } else { if ($sjName != '好运鲜花批发') { echo '不是好运鲜花批发，' . $sjName; die; } $staffId = 126272; $cover = 'item_class/bh.jpeg'; } $staff = ShopAdminClass::getByCondition(['id' => $staffId, 'mainId' => $mainId], true); if (empty($staff)) { util::fail('没有找到员工信息'); } $staffName = $staff->name ?? ''; $adminId = $staff->adminId ?? 0; if (empty($adminId)) { util::fail('没有adminId'); } $str = trim($str); $arr = explode(' ', $str); foreach ($arr as $key => $val) { $val = trim($val); $ls = explode(' ', $val); $count = count($ls); if ($count != 7) { echo $val; die; } $name = $ls[0] ?? ''; $ratio = $ls[3] ?? 20; $catName = $ls[4] ?? ''; $catName = trim($catName); $order = $ls[5] ?? 100; if (!isset($classList[$catName])) { echo $catName . ' 这个分类系统里没有'; die; } $classInfo = $classList[$catName]; $classId = $classInfo['id'] ?? 0; if (empty($classId)) { echo $catName . ' 这个没有分类id'; die; } $sjId = $shop->sjId ?? 0; $post = []; $post['sjId'] = $sjId; $post['adminId'] = $adminId; $post['mainId'] = $mainId; $post['staffId'] = $staffId; $post['staffName'] = $staffName; $post['cgStaffId'] = $staffId; $post['cgStaffName'] = $staffName; $post['adminId'] = $adminId; $post['name'] = $name; $post['py'] = stringUtil::py($name); $post['stock'] = 0; $post['ratio'] = $ratio; $post['bigUnitId'] = 1; $post['smallUnitId'] = 2; $post['classId'] = $classId; $post['className'] = $catName; $post['cover'] = $cover; $post['inTurn'] = $order; $post['price'] = 39; $post['skPrice'] = 39; $post['hjPrice'] = 39; $post['skMore'] = 6; $post['addPrice'] = 3; $post['hjAddPrice'] = 2; $post['hjDiscountPrice'] = 0; $post['discountPrice'] = 0; $post['skDiscountPrice'] = 0; $post['cost'] = 0; $post['weight'] = 1.5; $post['stockWarning'] = 5; $post['status'] = 2; $post['itemId'] = 0; $post['smallRatio'] = 1; $post['ratioType'] = 0; $post['appVersion'] = 1; ProductClass::addProduct($post, $shop); } echo 'ok'; $transaction->commit(); } catch (\Exception $e) { $transaction->rollBack(); $msg = $e->getMessage(); echo $msg; } } public function actionUpdate() { $str = << $mainId], null, '*', 'name'); $itemList = ProductClass::getAllByCondition(['mainId' => $mainId], null, '*', 'name'); foreach ($arr as $key => $val) { $val = trim($val); $ls = explode(' ', $val); $name = $ls[0] ?? ''; $catName = $ls[1] ?? ''; $inTurn = $ls[2] ?? 100; if (isset($catList[$catName]) && isset($itemList[$name])) { $product = $itemList[$name]; $catInfo = $catList[$catName]; $catId = $catInfo['id']; $productId = $product['id']; ProductClass::updateById($productId, ['classId' => $catId, 'inTurn' => $inTurn]); echo $productId . " ok\n"; } } } }