/**
* 发布批次
* @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;
}
