### 導入商品信息生成唯一碼 **位置：** Common\Lib\GoodsLib.class.php **參數：** * @param $skuID int SKU的ID值 * @return $goodsNo mix 成功返回：生成不重復的唯一碼，失敗返回：false **調用：** * $GoodsLib = new GoodsLib; * $GoodsLib->createNewGoodsNo($skuID) ; **完整代碼：** ~~~ /** * 導入商品信息生成唯一碼 * whz 2018-05-17 * @param $skuID int SKU的ID值 * @return $goodsNo mix 成功返回：生成不重復的唯一碼，失敗返回：false */ public function createNewGoodsNo($skuID) { $where = [ 'sku_id' => $skuID ]; $num = M('goods_item')->where($where)->count(); // 通過SKU的ID獲取SKU碼 $skuNo = M('goods_sku')->where("id = '{$skuID}'")->getField('goods_sku'); if ($num == 0) { return $skuNo.'0001'; } // 以下代碼為老邏輯的生成規則,第二唯一碼從0401開始 Lanson 2018-03-22 $numA = $num + 400; $len = strlen($numA); if ($len < 4) { for ($i=0; $i<(4-$len); $i++) { $numA = '0'.$numA; } } $goodsNo = $skuNo.$numA; // 進行驗證是否有與唯一碼表有重復數據 $res = M('goods_item')->where("item_no = '{$goodsNo}'")->find(); if (!empty($res)) { // 說明有重復的唯一碼 $numC = $num + 400; $numB = $numC + 10000; // 最多測試10000次加1操作,得出不重復的唯一碼 for ($i = $numC; $i<= $numB; $i++) { if (strlen($i) < 4) { $goodsNo = $skuNo.'0'.$i; } else { $goodsNo = $skuNo.$i; } $res = M('goods_item')->where("item_no = '{$goodsNo}'")->find(); if (empty($res)) { break; } if ($i == $numB) { return false; } } } return $goodsNo; } ~~~