/** * 发布批次 * @param 产品id $productID * @param 批次信息 $batch * 1. 判断产品状态是否为已通过,只有审核通过的产品才能发布批次 * 2. 创建产品批次信息 * 3. 更新product表中的Batchlist字段 */ public function addProductBatch($productID, $batch) { $result = false; $daoProduct = new DaoProduct(); $products = $daoProduct->getProductByproductId($productID); $daoProductBasicinfo = new DaoProductBasicinfo(); $basicinfo = $daoProductBasicinfo->getProductBasicinfoByproductId($productID); $product = array(); if (count($products) != 1 || count($basicinfo) != 1) { return $result; } else { $product = $products[0]; } //判断产品状态是否合格 if ($basicinfo[0]['basicinfo_status'] != 3) { return $result; } $conn = DaoBase::_getConn(); mysql_query("BEGIN"); //或者mysql_query("START TRANSACTION"); $batchResult = false; $productResult = false; $data = array("batch_harvesttime" => Tools::getNowTime(), "batch_num" => Tools::getFileName(), "batch_auditstatus" => 1, "batch_isvalid" => 1, "batch_isdelete" => 0, "batch_remark_color" => $batch['color'], "batch_remark_power" => $batch['power'], "batch_remark_weight" => $batch['weight'], "batch_remark_SugarScale" => $batch['sugar'], "batch_remark_other" => $batch['other'], "batch_qrcode_loc" => $batch['batch_qrcode_loc']); $batchDAO = new DaoProductBatch(); $batchResult = $batchDAO->insertTransaction($data, $conn); if ($batchResult) { $batchID = $batchDAO->_getLastId($conn); //更新product表 $batchlist = $product['batchlist']; if (!empty($batchlist)) { $batchlist .= "," . $batchID; } else { $batchlist = $batchID; } $dao = new DaoProduct(); $productResult = $dao->updateTransaction($conn, array("batchlist" => $batchlist), array("product_id = " => $productID)); } $result = $batchResult && $productResult; if ($result) { mysql_query("COMMIT"); } else { mysql_query("ROLLBACK"); } DaoBase::_closeConn($conn); return $result; }